In: Accounting
Following the instructions on the Data tab, complete the spreadsheet for your Chief Financial Officer.
| Estimates at the beginning of the year | Assembly | Production | Total | ||||||
| Manufacturing Overhead Costs | $ 480,000 | $ 528,000 | $ 108,000 | ||||||
| Direct Labor-hours | 12,000 | 7,200 | 19,200 | ||||||
| Machine hours | 4,800 | 24,000 | 28,800 | ||||||
| Job 142 | |||||||||
| Direct labor-hours | 25 | 17 | 42 | ||||||
| Machine hours | 17 | 20 | 37 | ||||||
| 1. Calculate the amount of manufacturing overhead applied to Job 142. Converse uses a plantwide predetermined overhead rate based on direct labor hours. | |||||||||
| 2. The CFO is considering changing the allocation base for Production to machine hours (instead of direct labor hours). The allocation base for Assembly would continue to be direct labor hours. | |||||||||
| Assembly | Production | Total | |||||||
| 1 | Calculation of predetermined overhead rate | |||
| Assembly | Production | Total | ||
| Manufacturing overhead cost(a) | $4,80,000 | $5,28,000 | $10,08,000 | |
| Direct labor hours(b) | 12000 | 7200 | 19200 | |
| Predetermined overhead rate(a/b) | $40.00 | $73.33 | $52.50 | |
| Manufacturing overhead applied to Job 142 | ||||
| Assembly | Production | Total | ||
| Predetermined overhead rate | $40.00 | $73.33 | $52.50 | |
| Direct labor hours for Job 142 | 25 | 17 | 42 | |
| Manufacturing overhead | $1,000.00 | $1,246.67 | $2,246.67 | |
| 2 | Calculation of predetermined overhead rate | |||
| Assembly | Production | Total | ||
| Manufacturing overhead cost(a) | $4,80,000 | $5,28,000 | $10,08,000 | |
| Direct labor hours(b) | 12000 | 7200 | 19200 | |
| Machine Hours© | 4800 | 24000 | 28800 | |
| Predetermined overhead rate for Assembly(a/b) | $40.00 | $73.33 | $52.50 | |
| Predetermined overhead rate for Production(a/c) | $100.00 | $22.00 | $35.00 |