Manufacturing Pro Forma Template

Once assumptions are in place, review the Cost of Goods Sold sheet and verify the cost percentages match your actual production economics. Direct materials as a percent of revenue is the most important input — it varies from 20% for highly labor-intensive custom work to 60%+ for manufacturers who buy expensive raw stock and do light conversion. Direct labor hours per unit and the wage rate plus burden will drive your labor cost calculation. If you have historical job cost data, use it to calibrate these numbers; if you're projecting a new product or line, use industry benchmarks as your starting point and build in a 5–10% buffer for startup inefficiency. Then populate the Overhead & SG&A sheet with your actual or planned fixed cost base.

The two numbers that define manufacturing financial health are gross margin and EBITDA margin. For discrete manufacturers — machined parts, fabricated assemblies, consumer goods — gross margins typically run 20–35%, with gross margin determined almost entirely by the relationship between your average selling price and your direct material plus direct labor cost. Net margins in manufacturing are tight: 4–10% is normal, and many manufacturers run at 5–7% net. This means that a 2-percentage-point increase in material costs — from steel price increases, aluminum tariffs, or supply disruptions — can cut net income by 40% if you don't raise prices to match. Modeling these scenarios in a pro forma before they happen is how manufacturing operators stay solvent through commodity cycles.