In: Accounting
Job Costs Using Activity-Based Costing
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 | $101,200 | Number of moves | 4,000 | ||
| Engineering | 142,400 | Number of change orders | 8,000 | ||
| Other overhead | 358,800 | Direct labor hours | 52,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 | $24,200 | $17,200 | $3,600 | $0 | ||||
| Direct materials | $5,600 | $8,600 | $11,100 | $10,300 | ||||
| Direct labor cost | $970 | $950 | $1,680 | $130 | ||||
| Job 13-43 | Job 13-44 | Job 13-45 | Job 13-46 | |||||
| Number of moves | 44 | 50 | 35 | 5 | ||||
| Number of change orders | 27 | 41 | 18 | 19 | ||||
| Direct labor hours | 970 | 950 | 1,680 | 130 | ||||
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?
| 1) | Activity rates | ||||||||
| Materials handling rate | 25.3 | per move | |||||||
| engineering rate | 17.8 | per change order | |||||||
| other overhead rate | 6.9 | per direct labor hour | |||||||
| 2) | Job order cost sheet | ||||||||
| job 13-43 | job 13-44 | job13-45 | job 13-46 | ||||||
| Balance,july 1 | 24,200 | 17,200 | 3,600 | 0 | |||||
| direct materials | 5,600 | 8,600 | 11,100 | 10,300 | |||||
| direct labor cost | 970 | 950 | 1680 | 130 | |||||
| materials handling | 1113 | 1265 | 886 | 127 | |||||
| engineering | 481 | 730 | 320 | 338 | |||||
| other overhead | 6693 | 6555 | 11592 | 897 | |||||
| total | 39,057 | 35,300 | 29,178 | 11,792 | |||||
| 3) | Balance of work in process july 31 | 40,970 | |||||||
| (job 45 and job 46) | |||||||||
| 4) | cost of goods sold for july | 74,357 | |||||||
| (job 43 and 44) | |||||||||
| 5) | difference in cost will be | 338 | |||||||