Provides 12 months of P&L data (columns) for the selected financial year, allocated to a company hierarchical structure (rows). Profit and Cost Centres are repositioned to above or below the Contribution Margin line to provide an accurate representation of the true Contribution Margin, Margin After Recoveries and Operational Expenditure.
This report is used to display Actual, Budget or combined Actual and Budget data for forecasting purposes and tailored to report on specific P&L subsections (e.g. OPEX and Direct Opex)
Filtering by financial year, data type (e.g. Actual, Budget or Actual & Budget), budget comparison figures, data from which original System, company structure (e.g. by company, plant, division, profit centre, department, cost centre etc.)
Drill down provided and only limited to the degree of data granularity, as imported into the system.
Although this sample report was written in SSRS with a SQL back end, the concepts can be applied to most current business intelligence and reporting systems.