# 7.4 Manufacturing Budgets

In a manufacturing company, you will have a budget for all of your manufacturing costs including Direct Materials, Direct Labor and Overhead.  Each cost will have their own budget.  You will need the information from the Sales and Production budgets to complete these 3 budgets.

Materials Budget

The materials budget (or materials purchases budget) is used to plan how much raw materials we need to have available to meet budgeted production.  This budget is prepare similarly to the production budget as the company must decide how much raw materials inventory they want to have on hand at the end of each quarter.  This is typically determined as a percent of next quarter's material needs.  In a materials budget, we will deal with units first and then add the budgeted cost near the end.  We also need to know how many direct materials are needed for each unit.

For Leed Company, our budgeted cost is $2 per pound. We need 5 pounds of materials for each unit. We want to maintain 25% of next quarter's production needs in ending inventory. Beginning raw materials inventory was 20,000 pounds (at$2 per pound) and we are expecting ending raw materials inventory to be 30,000 pounds.

 Leed Company Materials Purchases Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 YEAR Units to be produced (from production budget) 21,000 32,000 22,000 21,000 96,000 x lbs. of materials required per unit x 5 lb. x 5 lb. x 5 lb. x 5 lb Pounds of materials required for production 105,000 160,000 110,000 105,000 480,000 Add: Desired Ending Inventory 40,000 27,500 26,250 30,000 30,000 Total Material Needed 145,000 187,500 136,250 135,000 510,000 Less: Beginning Inventory (20,000) (40,000) (27,500) (26,250) (20,000) Material to be Purchased (in lbs) 125,000 147,500 108,750 108,750 460,000 x $2 cost per pound x$ 2 x $2 x$ 2 x $2 Total Material to be Purchased (in$) $250,000$295,000 $217,500$217,500 $980,000 Just like with the production budget, please note the following items: • Ending inventory is calculated as NEXT quarter's production needs x 25% for all but quarter 4. • Quarter 4 ending inventory is the same as the ending inventory for the year and was given in the example. • Beginning inventory refers to the previous quarters ending inventory for all quarters except quarter 1. For quarter 1, beginning raw materials was given in the problem and should also be the beginning inventory for the YEAR. If beginning inventory is not provided, assume the company followed the same inventory policy last year and multiply Quarter 1 pounds of materials needed x percent provided for ending inventory. • Quarter 2 beginning is quarter 1 ending inventory. Quarter 3 beginning is quarter 2 ending inventory and quarter 4 beginning is quarter 3 ending inventory. The total material to be purchased will be used later in the cash disbursement section of the CASH budget. Direct Labor Budget The direct labor budget is a very easy one. We need to know the units required from the production budget. Next, we need to know how many direct labor hours it takes to complete one unit and the cost per labor hour. Using this information, we can determine how many direct labor hours are required to meet the budgeted level of production. We will take the production units x direct labor per unit to get the number of direct labor hours. Finally, we will take the direct labor hours x the rate per hour. For Leed Company, each unit requires 0.5 hours of direct labor and the hourly rate is$12 per hour.  The direct labor budget would be:

 Leed Company Direct Labor Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 YEAR Units to be produced 21,000 32,000 22,000 21,000 96,000 x 0.5 DL hour per unit x 0.5 hr x 0.5 hr x 0.5 hr x 0.5 hr Direct Labor Hours Required 10,500 16,000 11,000 10,500 48,000 x $12 per hour x$12 x $12 x$12 x $12 Budgeted direct labor dollars$126,000 $192,000$132,000 $126,000$576,000
The budgeted direct labor dollar amount will be used later in the cash disbursement section of the CASH budget.

Leed Company has decided to allocate variable overhead on the basis of $1.50 per direct labor hour and fixed overhead is$75,000 per quarter.  Depreciation on the factory machinery of $10,000 per quarter is included in the fixed overhead.  Leed Company Mfg. Overhead Budget Qtr 1 Qtr 2 Qtr 3 Qtr 4 YEAR Budgeted direct labor hours (from direct labor budget) 10,500 16,000 11,000 10,500 48,000 x Variable OH per unit x$1.50 x $1.50 x$1.50 x $1.50 Variable Overhead Cost$15,750 $24,000$16,500 $15,750$72,000 Fixed Overhead Cost 75,000 75,000 75,000 75,000 300,000 Total Overhead Cost $90,750$99,000 $91,500$90,750 $372,000 Less: Depreciation on Factory Machinery (10,000) (10,000) (10,000) (10,000) (40,000) Total Cash payments for mfg overhead$80,750 $89,000$81,500 $80,750$332,000