The Financials cube assembles revenue and cost information from the other cubes to make financial projections on gross margins.
Revenue projections from the Demand cube
Cost projections from the Transportation, Production, and Materials cubes
Analyze the financial impact of changing assumptions such as currency exchange rate and inflation
Revenue, cost of goods sold, and gross margin projections by product family, geography, and month
Table 10. Predefined Information in the Financials Cube
| Dimensions | Measures | Constraints | Allocation Maps | Related Objects |
|---|---|---|---|---|
| Fiscal Geography ProductFamily | Actual COGS Actual Revenue COS Rate Cumulative Inflation Rate Labor Costs – Local Currency Labor Costs – Pre-Inflation Loaded COS Rate Material Costs – Local Currency Material Costs – Pre-Inflation Operating COS Operating Gross Profit Operating Revenue Other Expenses Projects Cost of Goods Sold Project Gross Margin Projected Gross Margin % Projected Labor Costs Projected Material Costs Projected Operating Expenses Projected Operating Margin Project Operating Margin % Projected R and D Expenses Projected Revenue Projected Revenue Ratio Projected SG and A Expenses Projected Transportation Costs Revenue – Local Currency Target Operating Margin % Target Revenue Transportation Costs – Local Currency Transportation Costs – Pre-Inflation | Low Gross Margin Negative Gross Margin | allocate-geography allocate-product | Cubes
Dimensions
Row Sources
|