3P Financiero
DSS de Mexico
Overview
3PFinanciero is an integrated financial planning and budgeting solution for the manufacturing enterprise. It provides financial statements based on sales, costs, expenses, loans, investment projects, and Accounts Receivable modules. The main benefit is the ability to simulate different business scenarios and determine the associated cash flow. Besides bottom-up planning capabilities, the solution offers top-down modeling based on break-back enabled by Cognos Planning.
3PFinanciero incorporates customer catalogues of products, sales markets, expense charts of accounts, manufacturing raw materials, loan characteristics, payroll characteristics, and main financial statement accounts. It also leverages actual data from customer sources.
Benefits
- Comprehensive application where all the relevant financial aspects are taken care of: sales, expenses, costs, assets acquisition, depreciation, loans, accounts receivable, financial planning, P&L, balance sheet, and cash flow
- Top-down and bottom-up planning
- Faster budgeting, report preparation, and scenario creation time
- Incorporates best-practice modeling based on Cognos Planning
- Provides financial visibility under different scenarios, so you can evaluate the impact of different initiatives undertaken, reflecting them in cash flow
- Sales analysis by product and market; integrates units to sale, unit price, and discounts
- The Cost module evaluates the impact of how changes in raw materials will impact the unit cost of each product
- Combining the estimated sale in units with raw material requirements, you can establish year-round commitments with suppliers to gain special volume discounts
Features
- Forecasting of units to sell, by product and market.
- Budget of units to sell by applying two different forecast methods: least square method applied to a lineal function and to a saturated growth function.
- Product unit cost calculation based on raw material requirements.
- Expenses forecasting applies three different actualization methods: by inflation, exchange rate, or an increment.
- Loan simulation takes loans in different currencies, interest rates, payment frequencies for capital and the interest (monthly, quarterly, by semester or annual); and calculates the loan balance, interest generated, interest payable, interest paid, in foreign currency and national currency.
- The project investment module is distinguished from asset acquisition since the project requires investment for a number of months before starting depreciation. This investment goes to Construction in Progress; once it is finished, the investment is moved to Plants and Equipment. The user can delay the expected cash flow by changing the project start.
- The top-down planning module is based on operating margin.
- The financial planning module iterates until equilibrium in the balance sheet is obtained. If capital plus liabilities exceeds assets, the difference is allocated to an investment account—provided that maximum cash is exceeded, with a yield that positively affects year earnings. If otherwise, the difference is allocated to a short-term loan that generates an interest rate and also affects the year earnings. The model allows a minimum cash limit, below which a loan is automatically generated.
Architecture
- Comparative P&L, balance sheet reports (actuals vs forecast and budget)
- Comparative sales by product and market (actuals vs forecast and budget)
- Best sold product by market
- Worst sold product by market
- Expense as a percentage of sales
- Raw material consumption
- Financial ratios based on Cognos Planning
- Uses Windows operating system
Availability
For more details, visit our Website: www.dssmexico.com.mx
RSS Feeds
 |
| Interested in this solution? |
