Production Budget

Learning Outcomes

  • Prepare a production budget
A flowchart titled “Types of Budgets”. The production budget is highlighted in yellow. At the top is the sales budget. The sales budget has two arrows pointing to the production budget and the SG&A budget. The production budget has three arrows pointing to the materials budget, labor budget, and manufacturing overhead budget. Those three budgets are all pointing to the cost of goods sold budget. The sales, production, materials, labor, manufacturing overhead, cost of goods sold, and SG&A budget boxes are all blue and there is a bracket labeling those as the operating budget. Below the operating budget is a horizontal line showing the capital expenditures budget in red on the left, and going to the right from there, an arrow pointing to the cash budget, with another arrow pointing to the budgeted income statement, and a final arrow pointing to the budgeted balance sheet. The cash budget, budgeted income statement, and budgeted balance sheet are all green and there is a bracket labeling those as the operating budget. There are also arrows pointing from the cost of goods sold budget and the SG&A budget to the cash budget.

The production budget considers the units in the sales budget and the company’s inventory policy. Managers develop the production budget in units and then in dollars. Determining production volume is an important task. Companies should schedule production carefully to maintain certain minimum quantities of inventory while avoiding excessive inventory accumulation. The principal objective of the production budget is to coordinate the production and sale of goods in terms of time and quantity.

Companies using a just-in-time inventory system need to closely coordinate purchasing, sales, and production. In general, maintaining high inventory levels allows for more flexibility in coordinating purchases, sales, and production. However, businesses must compare the convenience of carrying inventory with the cost of carrying inventory; for example, they must consider storage costs and the opportunity cost of funds tied up in inventory.

Firms often subdivide the production budget into budgets for materials, labor, and manufacturing overhead, which we will discuss next. Usually materials, labor, and some elements of manufacturing overhead vary directly with production within a given relevant range of production. Fixed manufacturing overhead costs do not vary directly with production but are constant in total within a relevant range of production. To determine fixed manufacturing overhead costs accurately, management must determine the relevant range for the expected level of operations.

For our example company, GelSoft, we’ll assume the new company policy is to hold enough product in ending inventory to cover the first month of sales of the next quarter, and so they try to produce enough to maintain one-third of the next quarter’s sales in ending inventory (and they round that amount to the nearest hundred). Finished goods inventory at the end of the prior budget year is projected to be 30,000 units.

From this data, we can prepare the schedule of planned production using the sales budget as our starting place.

GelSoft
Sales Budget in Units
Quarter Units (rounded)
Q1         40,000
Q2         42,000
Q3         44,100
Q4         46,305
Total Projected Sales Single Line      172,405Double line

 

GelSoft
Production Budget in Units
Description Amount
Budgeted/Projected sales, in units     172,405
Plus: ending inventory target (see below)         16,200
Total units needed to meet goals Single Line188,605
Less: units in beginning inventory         30,000
Units needed to be produced to meet goals Single Line158,605Double line
Units to produce     158,605
Plus beginning inventory         30,000
Ending inventory held over     (16,200)
      Units available for sale Single Line  172,405Double line

 

Important things to note:

  1. In addition to the 172,405 units that will be sold, the company has to produce enough units to have 16,200 on hand at the end of the year to cover January sales of the next budget year. Assuming the same sales increase of 5%, Q1 sales for the next budget cycle would be Q4 of this budget cycle time 1.05 = 46,305 * 1.05 = 48,620. One-third of that amount is 16,206.75 which, when rounded to the nearest hundred, equals 16,200 units for December 31 ending inventory.
  2. There are 30,000 units on hand at the beginning of the budget year, which reduces the number of units that need to be produced to hit the sales and ending inventory targets.
  3. 172,405 to be sold plus 16,200 to have on hand at the end of the year is 188,605, less the 30,000 on hand at the beginning of the year, equals a production run of 158,605. This is less than the number of units to be sold because the company is trying to reduce the number of units on hand by selling off beginning inventory and then, using the production budget, keeping units on hand as low as possible.

Here is the production budget by quarter, starting with a recap of the sales budget:

GelSoft Sales Budget
Description Q1 Q2 Q3 Q4 Year
Sales in Units 40,000 42,000 44,100 46,305 172,405
Budgeted Price $34 $34 $34 $34
Sales in Dollars Single Line$1,360,000Double line Single Line$1,428,000Double line Single Line$1,499,400Double line Single Line$1,574,370Double line Single Line$5,861,770Double line

 

GelSoft
Production Budget in Units
Description Q1 Q2 Q3 Q4 Year
Budgeted/Project sales, in units 40,000 42,000 44,100 46,305   172,405
Plus: ending inventory target 14,000 14,700 15,400 16,200 16,200
Total units needed to meet goals Single Line54,000 Single Line56,700 Single Line59,500 Single Line62,505 Single Line188,605
Less: units in beginning inventory 30,000 14,000 14,700 15,400 30,000
Units needed to be produced to meet goals Single Line24,000Double line Single Line42,700Double line Single Line44,800Double line Single Line47,105Double line Single Line158,605Double line

 

Explanation: Each quarter is calculated the same as an annual budget, starting with projected sales, adding ending inventory, and subtracting beginning inventory to get the number of units needed to be produced. Notice the drastic reduction in units needed to be produced in Q1 because of the large beginning inventory.

Here is a short review of how to create a production budget:

You can view the transcript for “The Production Budget” here (opens in new window).

Before you create a production budget based on this sales budget, check your understanding of how to create a sales budget.

Practice Question