Site-level profit and loss tracking for multi-plant PE-backed platforms. P&L summary dashboard, plant-level template, YTD trend analysis, and budget vs. actual bridge — in one workbook.
| Worksheet | Purpose |
|---|---|
| P&L Summary Dashboard | All plants on one page — revenue, COGS, margin, EBITDA |
| Plant P&L Template | Detailed P&L for each operating site |
| YTD Trend | Trailing performance by month across all plants |
| Bridge — Budget vs. Actual | Variance decomposition by driver |
Five worksheets — from plant-level detail to portfolio-level summary
The template supports 5–20 plants. Each plant gets a row on the summary dashboard and can have its own detailed P&L worksheet.
Not directly. This is a management reporting layer. Export your ERP data monthly and paste into the plant P&L template. The summary dashboard and bridge worksheets auto-calculate.
No. Standard Excel formulas only. Works in Excel 2016+ and Google Sheets.
A former Managing Director with direct P&L ownership across a multi-site industrial services platform under PE ownership.
P&L dashboard. Plant-level detail. YTD trends. Budget bridge. One workbook.