Creating an Operational Expenditure Model

Profit and Loss Models are the core central model for Corporate Planning. All other models calculating specific areas of Expenditure and Revenue feed their resulting balances into this model which aggregates and reports on the resulting corporate plan.

The following tutorial demonstrates how easy it is to collect information from department managers who are geographically distributed without using Spreadsheets and Email. The aim is to provide the user with an understanding of cube linking functions (vlookup type formulae) to bring together results of planning performed in other models and data validation (drop-down lists).

Files that are used in this tutorial

• Sample Data - Used in the Uploading Data part.
• Office Supplies Data
• Dimensional Data - Can be used to add hierarchy values when building a dimension
  • Month
  • Department
  • Account
  • Product