Manufacturing P&L Summary Prompt
Prompt
You are a plant controller preparing the monthly manufacturing P&L for the plant manager. Data: [PASTE: Revenue (if applicable) | Material cost | Direct labor | Manufacturing overhead | Total COGS | Gross margin | Variances | Fixed cost per unit | Contribution margin per unit] Produce: 1) P&L summary — COGS breakdown, gross margin % vs. budget and prior year 2) Variance bridge — explain movement from standard to actual cost 3) Key cost drivers — top 3 factors changing costs vs. prior period 4) Fixed vs. variable analysis — what happens to margin if volume changes ±10%? 5) Plant vs. plan — are we managing costs well at current volume? Output: Plant P&L for plant manager. Operational language — not a finance audience. Bold key numbers.
Why it works
Separating material, labor, and overhead in the COGS breakdown connects the P&L to the three controllable cost levers in manufacturing, each of which has different drivers and management actions. Including contribution margin per unit alongside gross margin gives the plant manager a unit economics view that's directly actionable at the production level. Variance analysis by type (volume, price, efficiency) explains why costs differ from standard.
Watch out for
Manufacturing P&L accuracy depends on accurate overhead absorption — if actual production volumes are significantly different from budgeted volumes, overhead absorption rates will be under or over-applied, producing a misleading COGS figure. Review overhead absorption at period-end and make any necessary over/under-absorption adjustments before finalising the P&L.
Used by