1. Overhead assigned to each product | Home | Work | Total | ||||
a | Total overhead | 186180 | |||||
b | No. of Machine Hours | 1300 | 1600 | 2900 | |||
c | Cost per Machine hour (c=a/b) | 64.20 | |||||
d | Overhead to be assigned (d= machine hour * cost per machine hour) | 83460 | 102720 | 186180 | |||
e | Expected production | 620 | 470 | ||||
f | overhead cost per unit (f = d/e) | 135 | 219 | ||||
2. production cost per unit | |||||||
Home | Work | ||||||
a | Direct Materials | 37 | 71 | ||||
b | Direct labor | 15 | 37 | ||||
c | Overheads | 134.61 | 218.55 | ||||
d | production cost per unit (sum from a to c) | 186.61 | 326.55 | ||||
3. Gross margin per unit | |||||||
Home | Work | ||||||
a | Sales price | 363 | 578 | ||||
b | Production cost per unit | 186.61 | 326.55 | ||||
c | production cost per unit (a - b) | 176.39 | 251.45 | ||||
4. activity Rate as per ABC | |||||||
Activity cost | Cost drivers | Activity Rate per driver = (Activity cost /Cost drivers) | |||||
a | Setup cost | 86920 | 106 | 820 | |||
b | Quality control | 55760 | 680 | 82 | |||
c | Maintenance | 43500 | 2900 | 15 | |||
5. overhead cost to each product | |||||||
Activity Rate per driver | no. of drivers | Total cost = a*b | expected production | cost per unit =c/d | |||
Home | a | b | c | d | e | ||
Setup cost | 820 | 38 | 31160 | 620 | 50.26 | ||
Quality control | 82 | 340 | 27880 | 620 | 44.97 | ||
Maintenance | 15 | 1300 | 19500 | 620 | 31.45 | ||
Work | |||||||
Setup cost | 820 | 68 | 55760 | 470 | 118.64 | ||
Quality control | 82 | 340 | 27880 | 470 | 59.32 | ||
Maintenance | 15 | 1600 | 24000 | 470 | 51.06 | ||
6. production cost per unit as per ABC | |||||||
Home | Work | ||||||
a | Direct Materials | 37 | 71 | ||||
b | Direct labor | 15 | 37 | ||||
c | Overheads | ||||||
d | Setup cost | 50.26 | 118.64 | ||||
e | Quality control | 44.97 | 59.32 | ||||
f | Maintenance | 31.45 | 51.06 | ||||
g | production cost per unit (sum from a to f) | 178.68 | 337.02 | ||||
7. Gross margin per unit as per ABC | |||||||
Home | Work | ||||||
a | Sales price | 363 | 578 | ||||
b | Production cost per unit | 178.68 | 337.02 | ||||
c | production cost per unit (a - b) | 184.32 | 240.98 | ||||
8. comparison of Gross margin per unit | |||||||
Home | Work | ||||||
a | Traditional System | 176.39 | 251.45 | ||||
b | ABC System | 184.32 | 240.98 | ||||
increase/decrease | 7.94 | -10.47 | |||||
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information...
Harbour Company makes two models of electronic tablets, the Home and the Work Basic production information follows: 5 65 $44 20 Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month 367 583 790 units 500 units Harbour has monthly overhead of $191,680, which is divided into the following cost pools: Setup costs Quality control Maintenance $ 85,680 57.469 48,600 $191,680 Total The company has also compiled the following information about the...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month Home Work $ 40 $ 70 20 32 360574 650 units 320 units Harbour has monthly overhead of $173,730, which is divided into the following cost pools: Setup costs Quality control Maintenance Total $ 83, 740 56,990 33,000 $173,730 The company has also compiled the...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month Home Work $ 35 $ 67 21 39 351 568 740 units 470 units Harbour has monthly overhead of $184,250, which is divided into the following cost pools: Setup costs Quality control Maintenance Total $ 87,980 54,270 42,000 $184,250 The company has also compiled the...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Work Home $ 45 Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month 370 750 units 380 units Harbour has monthly overhead of $195,020, which is divided into the following cost pools: Setup costs Quality control Maintenance Total 78.960 60,960 55,100 195,020 $ The company has also compiled the following information about the chosen...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month Home Work $ 43 $ 68 22 40 369567 630 units 420 units Harbour has monthly overhead of $209,850, which is divided into the following cost pools: Setup costs Quality control Maintenance Total $ 91,300 62,550 56,000 $209,850 The company has also compiled the following...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month Home Work $ 38 $ 66 25 30 571 700 units 450 units 370 Harbour has monthly overhead of $205,440, which is divided into the following cost pools: Setup costs Quality control Maintenance Total $ 89,040 58,800 57,600 $ 205,440 The company has also compiled...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work $ 30 20 300 500 700 units 400 units Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month 30 Harbour has monthly overhead of $175,200, which is divided into the following cost pools: Setup costs Quality control Maintenance Total $ 68,800 58,400 48.000 $175,200 The company has also compiled the following information...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month Home Work $ 35 $ 71 39 573 690 units 470 units 22 365 Harbour has monthly overhead of $196,120, which is divided into the following cost pools: Setup costs Quality control Maintenance Total $ 77,900 57,420 60,800 $196, 120 The company has also compiled...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production Information follows: Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month Home Work $ 40 $ 71 20 360 582 670 units 430 units Harbour has monthly overhead of $173,925, which is divided into the following cost pools: Setup costs Quality control Maintenance Total $ 80,850 55, 675 37, 400 $173.925 The company has also compiled...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home $ 30 20 Work $ 48 30 Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month 300 500 700 units 400 units Harbour has monthly overhead of $175,200, which is divided into the following cost pools: Setup costs Quality control Maintenance Total S 68.800 58,400 49.000 $ 175,200 The company has also compiled...