Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Cougars Company prepares monthly operating and financial budgets. Estimates of s

ID: 2455371 • Letter: C

Question

Cougars Company prepares monthly operating and financial budgets. Estimates of sales in units are made for each month. Production is scheduled at a level high enough to take care of current needs and to carry into each month one-half of the next month's unit sales. Direct materials, direct labor, and variable manufacturing overhead are estimated at USD 12, USD 6, and USD 4 per unit, respectively. Total fixed manufacturing overhead is budgeted at USD 480,000 per month. Sales for April, May, June, and July 2009 are estimated at 100,000, 120,000, 160,000, and 120,000 units. The inventory at 2009 April 1, consists of 50,000 units with a cost of USD 28.80 per unit.

Prepare a schedule showing the budgeted cost of goods sold for the three months assuming that the FIFO method is used for inventories.

Explanation / Answer

Cost of Good Sold Budget

Note 1. Closing Stock

Note :2 Production (units)

Note :3 Cost Sheet

Note :4 Fixed overhead recovery rate($)

Note: 5 Calculation of Value of Closing Stock

Note :6 Direct Material Cost

Note 7 :Direct wages

Note : 8 Overheads

Particulars April May June Direct Materials ( note 6) $1,320,000 $1,680,000 $1,680,000 Direct Wages    (note 7) $660,000 $840,000 $840,000 Overheads        (note 8) $920,000 $1,040,000 $1,040,000 Total $2,900,000 $3,560,000 $3,560,000 Add: Opening Stock $1,440,000 $1,581,600 $2,034,400 Total $4,340,000 $5,141,600 $5,594,400 Less: Closing Stock ( note 5) $1,581,600 $2,034,400 $1,525,800 Cost of Good sold $2,758,400 $3,107,200 $4,068,600