In: Accounting
Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows:
Activity | Cost | Driver | Amount of Driver | ||
Materials handling | $81,900 | Number of moves | 3,500 | ||
Engineering | 135,150 | Number of change orders | 8,500 | ||
Other overhead | 240,000 | Direct labor hours | 48,000 |
Heitger worked on four jobs in July. Data are as follows:
Job 13-43 | Job 13-44 | Job 13-45 | Job 13-46 | |||||
Beginning balance | $21,300 | $19,600 | $3,900 | $0 | ||||
Direct materials | $6,100 | $9,800 | $11,100 | $8,000 | ||||
Direct labor cost | $820 | $1,080 | $1,670 | $110 |
Job 13-43 | Job 13-44 | Job 13-45 | Job 13-46 | |||||
Number of moves | 47 | 48 | 29 | 8 | ||||
Number of change orders | 33 | 43 | 22 | 16 | ||||
Direct labor hours | 820 | 1,080 | 1,670 | 110 |
By July 31, Jobs 13-43 and 13-44 were completed and sold. Jobs 13-45 and 13-46 were still in process.
Required:
1. Calculate the activity rates for each of the three overhead activities. Round all activity rates to the nearest cent.
Materials handling rate | $ per move |
Engineering rate | $ per change order |
Other overhead rate | $ per direct labor hour |
2. Prepare job-order cost sheets for each job showing all costs through July 31.
When required, round your answers to the nearest dollar. If an amount is zero, enter "0".
Heitger Company | ||||
Job-Order Cost Sheets | ||||
Job 13-43 | Job 13-44 | Job 13-45 | Job 13-46 | |
Balance, July 1 | $ | $ | $ | $ |
Direct materials | ||||
Direct labor cost | ||||
Materials handling | ||||
Engineering | ||||
Other overhead | ||||
Total | $ | $ | $ | $ |
3. Calculate the balance in Work in Process on
July 31.
$___________
4. Calculate the cost of goods sold for
July.
$__________
5. What if Job 13-46 required no engineering change orders? What is the difference in the new cost of Job 13-46?
$ ___________ : Higher , Lower , No Affect
How would the cost of the other jobs be affected?
Higher , Lower , No affect
1.
Activity | Cost | Quantity | Activity Rate | |
Material Handling | $ 81,900 | 3500 | $ 23.40 | per move |
Engineering | $ 135,150 | 8500 | $ 15.90 | per change order |
Other Overhead | $ 240,000 | 48000 | $ 5.00 | per direct labor hour |
Total | $ 457,050 |
2.
Heitger Company | ||||
Job-Order Cost Sheets | ||||
Job 13-43 | Job 13-44 | Job 13-45 | Job 13-46 | |
Balance, July 1 | $ 21,300 | $ 19,600 | $ 3,900 | $ - |
Direct materials | $ 6,100 | $ 9,800 | $ 11,100 | $ 8,000 |
Direct labor cost | $ 820 | $ 1,080 | $ 1,670 | $ 110 |
Materials handling | $ 1,100 | $ 1,123 | $ 679 | $ 187 |
Engineering | $ 525 | $ 684 | $ 350 | $ 254 |
Other overhead | $ 4,100 | $ 5,400 | $ 8,350 | $ 550 |
Total | $ 33,945 | $ 37,687 | $ 26,048 | $ 9,102 |
3. Balance in Work in Process = $26048+9102 = $35150
4. Cost of Goods Sold = $33945+37687 = $71631
5. Cost of Job 13-46 will be Lower
No effect on other jobs