Production Budget: Videos & Practice Problems
A Production Budget shows how many units a business must make to meet planned sales while maintaining enough safety stock in finished goods inventory. It is built directly from the sales budget and focuses on units, not cash, so it does not create cash collections or cash disbursements. A common policy is to set desired ending inventory as a percentage of the next period’s expected sales.
The key relationship is \( \text{Units to Produce}=\text{Budgeted Unit Sales}+\text{Desired Ending Inventory}-\text{Beginning Inventory} \) . This formula helps determine units to produce for each period by adding sales needs and desired ending inventory, then subtracting inventory already available at the beginning of the period.
When preparing a yearly column, unit sales are added across periods, but beginning and ending amounts follow a timing rule: the year’s beginning inventory comes from the first period, and the year’s desired ending inventory comes from the last period. This makes the budget easier to interpret and connect to the broader master budget.
Production Budget: Equation
Production Budget: Document
Production Budget
A retailer has set the following budgeted Unit Sales for the coming three months:
It is a policy to maintain ending finished goods inventory equal to 20% of the following month’s expected sales. Calculate the number of Units to Produce in the month of May.
464
480
476
460
Here's what students ask on this topic:
The formula to calculate the units to produce in a production budget is given by: . This formula helps determine how many units a business must produce in a period to meet planned sales and maintain enough safety stock. The budgeted unit sales represent the expected sales for the period, the desired ending inventory is the safety stock the business wants to hold at the end of the period (often calculated as a percentage of the next period's sales), and the beginning inventory is the amount of finished goods inventory available at the start of the period. By adding sales needs and desired ending inventory, then subtracting beginning inventory, the business ensures it produces enough units without overproducing.
Safety stock in a production budget is typically calculated as a percentage of the next period's expected sales or production. For example, a common policy is to set the desired ending inventory as 10% of the next period's production. This means the business plans to keep extra inventory on hand to handle unexpected increases in demand or delays in production. The formula for safety stock can be expressed as: . This approach helps businesses avoid stockouts and lost sales by maintaining a buffer of finished goods.
The production budget focuses on the number of units to produce to meet sales and maintain inventory levels; it deals with physical quantities, not monetary values. Because it does not involve cash transactions directly, such as payments or receipts, it does not create cash collections or disbursements. Therefore, the production budget does not influence the cash budget. Instead, costs related to production, like raw materials and labor, are handled in separate cost budgets that do affect cash flow. Understanding this distinction helps students see how different budgets in the master budget serve different purposes.
When preparing a yearly production budget, the beginning and ending inventory values follow a timing rule. The beginning inventory for the year is taken from the beginning inventory of the first period (e.g., the first quarter), and the desired ending inventory for the year is taken from the ending inventory of the last period (e.g., the fourth quarter). This means you do not sum beginning or ending inventories across periods. For example, if the beginning inventory in quarter 1 is 150 units, that is the beginning inventory for the year. If the ending inventory in quarter 4 is 200 units, that is the ending inventory for the year. This approach ensures the yearly budget accurately reflects inventory levels at the start and end of the year.
To prepare a production budget, you need the budgeted unit sales for each period from the sales budget. This information tells you how many units the business plans to sell, which is the starting point for determining how many units to produce. Additionally, you need information about desired safety stock levels, often expressed as a percentage of the next period's sales or production, which may come from management instructions. Combining these with beginning inventory levels allows you to calculate the total units to produce using the formula: .
