Production Budget: How to Build a Manufacturing Budget

What a production budget is

A production budget is the plan, in units and in money, of what the plant will produce in a period and the resources needed: materials, labor and overhead. It starts from the sales forecast and from the inventory the company wants to hold.

In the example below, a quarter with sales of 3,300 units requires producing 3,410 units and results in a production cost of $135,840. The budget turns the commercial forecast into a plan that the shop floor and finance can both follow.

Visual map of the production budget

The map shows the sequence sales, production, materials, labor and overhead, with the figures from the example.

The budget sequence

Each step feeds the next, so the order matters:

1. Sales budget: comes from the demand forecast (see demand forecasting) and the commercial plan.
2. Production budget: units to produce, adjusted for inventory.
3. Direct materials: usage and purchases from the bill of materials.
4. Direct labor: hours and cost, checked against capacity.
5. Manufacturing overhead: a variable part and a fixed part.
6. Total and unit cost: the basis for pricing and for standard costing.

Formula for units to produce

Production = Forecast sales + Target ending inventory − Beginning inventory

Target ending inventory is usually a policy, for example coverage of 20% of next month's sales. To set the protection level, see safety stock.

Worked example: production for the quarter

Fictional example. Single product. Forecast sales: January 1,000, February 1,200, March 1,100 and April 1,300 units. Policy: ending inventory equal to 20% of next month's sales. Beginning inventory in January: 150 units.

January: 1,000 + 240 − 150 = 1,090. Each month's ending inventory is the next month's beginning inventory. Quarter check: 3,300 + 260 − 150 = 3,410 units.

Materials, labor and overhead

Example assumptions: 2 kg of material per unit at $5.00/kg; 0.5 direct labor hour per unit at $24.00/hour (fully loaded); overhead of $4.00 per labor hour (variable) plus $18,000 per month (fixed). To keep it simple, material usage equals purchases, with no material inventory.

Consolidated budget and unit cost

Check: 34,100 + 40,920 + 60,820 = $135,840. Average cost per unit produced: 135,840 ÷ 3,410 = $39.84. This value changes each month because fixed cost is spread over different volumes, a topic covered in production cost per unit. Once cost is set, the next step is price: see markup vs margin.

Capacity check before approval

If monthly capacity is 650 direct labor hours, utilization is 545 ÷ 650 = 83.8% in January, 590 ÷ 650 = 90.8% in February and 570 ÷ 650 = 87.7% in March. February is the tight month. If the result exceeded 100%, the options would be building ahead, overtime, outsourcing or revisiting sales. The capacity calculation is in production capacity.

How the budget connects to planning

• In S&OP, sales, operations and finance approve the volume that feeds the budget.
• The master production schedule (MPS) breaks quantities down by week and product.
• MRP converts the MPS into material requirements and purchases.
• For long horizons with seasonal demand, aggregate planning sets the capacity strategy.
• Production planning and control executes and tracks actuals against budget.

Control: budget vs actual

A budget only helps if it is tracked. Every month, compare the columns and investigate the gaps. If January materials cost $11,300 against a $10,900 budget, the variance is $400 (3.67%). The next question is where it came from: material price, higher usage or output above forecast. Separating price, quantity and volume is the method in standard costing and variance analysis.

Common mistakes

• Budgeting production equal to sales, ignoring beginning and ending inventory.
• Starting from an optimistic sales forecast that sales never validated.
• Skipping the capacity test and finding the bottleneck mid-month.
• Treating fixed cost as variable (or the reverse), distorting unit cost in low-volume months.
• Ignoring scrap, yield loss and rework in material usage.
• Building the budget once a year and never revising it.

Frequently asked questions

What is a production budget?

It is the plan of units to produce and the resources needed (materials, labor and overhead) in a period, built from the sales forecast.

What is the formula for units to produce?

Production = forecast sales + target ending inventory − beginning inventory. In the example for January: 1,000 + 240 − 150 = 1,090.

What is the difference between a production budget and an MPS?

The budget works with quantities and costs per period, usually monthly. The MPS details quantities by product and week for scheduling.

Who prepares the production budget?

Production planning and controlling (cost accounting), using data from sales, engineering (bill of materials and routings) and purchasing.

How often should it be reviewed?

Compare actuals every month and reforecast the quarter when sales or costs deviate significantly.

What is a flexible budget?

A budget recalculated for the volume actually produced, which separates the volume variance from the other variances.

About the author

Vagner Soares

Lean Manufacturing & Behavioral Management Specialist

Over 20 years in the automotive and metalworking industries (GM and Dana), Lean Manufacturing practitioner since 2006. SENAI instructor and mentor in Brazil’s Brasil Mais Produtivo program, delivering consulting, training and audits for 50+ companies, combining quality, productivity and people development.

LinkedInInstagramFull profile →