In: Accounting
Horngren's Accounting Eleventh Edition
Refer to the budgets prepared in E22-25. Determine the cost per kit to manufacture the toys. Gordon projects sales to 5800, 5600, 5700, 5400 for the next four quarters. Prepare a cost of goods sold budget for the year. Gordon has 2,000 kits in beginning inventory at a cost of $200,000.
FROM E22-25
Gordon, Inc. makes toys and projects production to be 6100, 5900, 6000, and 5500 for the next four quarters. Direct materials are $8 per kit. Beginning Raw Material Inventory is $20,000 and the company desires to end each quarter with 25% of the material needed for the next two quarter's production. Direct Materials needed for production in the First Quarter of the following year is $45,000. Gordon desires a balance of $25,000 in Raw Materials Inventory at the end of the fourth quarter. Each kit requires 1.3 hours of direct labor at an average cost of $30 per hour. Each kit requires 1.25 machine hours. Manufacturing overhead is allocated using machine hours as the allocation base. Variable overhead is $50 per kit and fixed overhead is $30,000 in the first two quarters and $32,000 in the third and fourth quarter.
| Prepare a cost of goods sold budget for the year. Gordon has no kits in beginning inventory. Round amounts to two decimal places. | |||||||||
| Solution: | |||||||||
| First calculate the total projected manufacturing cost per kit | |||||||||
| GORDON, INC. | |||||||||
| Cost of Goods Sold Budget | |||||||||
| For the Year Ended December 31 | |||||||||
| First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Total | |||||
| Computation of Manufacturing Overhead Budget | |||||
| Q-1 | Q-2 | Q-3 | Q-4 | Total | |
| Estiamted Production | 6100 | 5900 | 6000 | 5500 | 23500 |
| Variable Overhead Cost per Unit | $50 | $50 | $50 | $50 | $50 |
| Budgeted Variable Overhead (a) | $3,05,000 | $2,95,000 | $3,00,000 | $2,75,000 | $11,75,000 |
| Budgeted Fixed Overhead (b) | $30,000 | $30,000 | $32,000 | $32,000 | $1,24,000 |
| Budgeted Manufacturing OH Cost (a+b) | $3,35,000 | $3,25,000 | $3,32,000 | $3,07,000 | $12,99,000 |
| No. of Machine Hours used ( Qty* 1.25) | 29375 | ||||
| Predetermined OH | $44 | ||||
| Computation of Manufacturing Cost | |
| Direct Material Cost Per Unit | $8 |
| Direct Labour Cost Per Unit (1.3 hourX $30) | $39 |
| Manufacturing Overhead Per
Unit ($44.22X 1.25) |
$55 |
| Total Manufacturing Cost | $102 |
| Gordan Inc. | |||||
| Cost of Goods Sold Budget | |||||
| For the year Dec 31 | |||||
| Q-1 | Q-2 | Q-3 | Q-4 | Total | |
| Unit Sold | 5800 | 5600 | 5700 | 5400 | 22500 |
| Manufacturing Cost/Unit | $102 | $102 | $102 | $102 | $102 |
| Total Cost of Goods Sold | $5,91,600 | $5,71,200 | $5,81,400 | $5,50,800 | $22,95,000 |