In: Accounting
Harbour Company makes two models of electronic tablets, the Home
and the Work. Basic production information follows:
Home | Work | |||||
Direct materials cost per unit | $ | 44 | $ | 71 | ||
Direct labor cost per unit | 23 | 35 | ||||
Sales price per unit | 369 | 573 | ||||
Expected production per month | 740 | units | 410 | units | ||
Harbour has monthly overhead of $187,410, which is divided into the following cost pools:
Setup costs | $ | 86,110 |
Quality control | 58,800 | |
Maintenance | 42,500 | |
Total | $ | 187,410 |
The company has also compiled the following information about
the chosen cost
drivers:
Home | Work | Total | |
Number of setups | 38 | 71 | 109 |
Number of inspections | 310 | 390 | 700 |
Number of machine hours | 1,100 | 1,400 | 2,500 |
1. Compare the gross margin of each product under the traditional system and ABC. (Round your answers to 2 decimal places.)
Home | Work | |
Gross Margin (Traditional) | ||
Gross Margin (ABC) |
Firstly we allocate overhead costs using traditional method | ||||||
Overhead | 187410 | |||||
Machine hours | 2500 | |||||
overhead per machine hour | 74.96 | |||||
allocated to | ||||||
Home model | Work model | |||||
Machine hours(a) | 1100 | 1400 | ||||
Rate (b) | 74.96 | 74.96 | ||||
overheads allocated(a*b) | 82460 | 104950 | ||||
Units | 740 | 410 | ||||
Overhead cost per unit | $ 111.43 | $ 255.97 | ||||
Product costs | ||||||
Home model | Work model | |||||
Direct material | $ 44.00 | $ 71.00 | ||||
Direct labor | $ 23.00 | $ 35.00 | ||||
overhead costs | $ 111.43 | $ 255.97 | ||||
total unit costs | $ 178.43 | $ 361.97 | ||||
Home model | Work model | |||||
sale price | $ 369.00 | $ 573.00 | ||||
Unit costs | $ 178.43 | $ 361.97 | ||||
Gross profit | $ 190.57 | $ 211.03 | ||||
now using ABC method | ||||||
Activity | Costs | Units | Cost per activity | |||
setup | 86110 | 109 | 790 | |||
quality control | 58800 | 700 | 84 | |||
maintenance | 42500 | 2500 | 17 | |||
allocated to | ||||||
Setup | Qaulity control | Maintenance | ||||
Number | 38 | 71 | 310 | 390 | 1100 | 1400 |
Rate (b) | 790 | 790 | 84 | 84 | 17 | 17 |
overheads allocated(a*b) | 30020 | 56090 | 26040 | 32760 | 18700 | 23800 |
so we have | ||||||
Home model | Work model | |||||
Overheads | 74760 | 112650 | ||||
Units | 740 | 410 | ||||
Overhead cost per unit | $ 101.03 | $ 274.76 | ||||
Product costs | ||||||
Home model | Work model | |||||
Direct material | $ 44.00 | $ 71.00 | ||||
Direct labor | $ 23.00 | $ 35.00 | ||||
overhead costs | $ 101.03 | $ 274.76 | ||||
total unit costs | $ 168.03 | $ 380.76 | ||||
Home model | Work model | |||||
sale price | $ 369.00 | $ 573.00 | ||||
Unit costs | $ 168.03 | $ 380.76 | ||||
Gross profit | $ 200.97 | $ 192.24 | ||||
So your answer | ||||||
Home | Work | |||||
Traditional | $ 190.57 | $ 211.03 | ||||
ABC | $ 200.97 | $ 192.24 |