Harbour Company makes two models of electronic tablets, the Home
and the Work. Basic production information follows:
Home | Work | |||||
Direct materials cost per unit | $ | 36 | $ | 71 | ||
Direct labor cost per unit | 25 | 31 | ||||
Sales price per unit | 360 | 575 | ||||
Expected production per month | 680 | units | 390 | units | ||
Harbour has monthly overhead of $199,680, which is divided into the following cost pools:
Setup costs | $ | 81,810 |
Quality control | 68,870 | |
Maintenance | 49,000 | |
Total | $ | 199,680 |
The company has also compiled the following information about
the chosen cost drivers:
Home | Work | Total | |
Number of setups | 37 | 64 | 101 |
Number of inspections | 340 | 370 | 710 |
Number of machine hours | 1,400 | 2,100 | 3,500 |
Required:
1. Suppose Harbour uses a traditional costing
system with machine hours as the cost driver. Determine the amount
of overhead assigned to each product line. (Do not round
intermediate calculations and round your final answers to the
nearest whole dollar amount.)
Harbour Company makes two models of electronic tablets, the Home
and the Work. Basic production information follows:
Home | Work | |||||
Direct materials cost per unit | $ | 36 | $ | 71 | ||
Direct labor cost per unit | 25 | 31 | ||||
Sales price per unit | 360 | 575 | ||||
Expected production per month | 680 | units | 390 | units | ||
Harbour has monthly overhead of $199,680, which is divided into the following cost pools:
Setup costs | $ | 81,810 |
Quality control | 68,870 | |
Maintenance | 49,000 | |
Total | $ | 199,680 |
The company has also compiled the following information about
the chosen cost drivers:
Home | Work | Total | |
Number of setups | 37 | 64 | 101 |
Number of inspections | 340 | 370 | 710 |
Number of machine hours | 1,400 | 2,100 | 3,500 |
Required:
1. Suppose Harbour uses a traditional costing
system with machine hours as the cost driver. Determine the amount
of overhead assigned to each product line. (Do not round
intermediate calculations and round your final answers to the
nearest whole dollar amount.)
HOme: $70,870
WOrk: $119,805
Total Overhead Cost: $199,675
2. Calculate the production cost per unit for each
of Harbour’s products under a traditional costing system.
(Round your intermediate calculations and final answers to
2 decimal places.)
unit cost
Work:
Home:
3. Calculate Harbour’s gross margin per unit
for each product under the traditional costing system.
(Round your intermediate calculations and final answers to
2 decimal places.)
Gross Margin:
Work:
Home:
4. Select the appropriate cost driver for each cost pool and calculate the activity rates if Harbour wanted to implement an ABC system.
Setup Costs:
Quality Control:
MAintance:
5. Assuming an ABC system, assign overhead costs
to each product based on activity demands.
HOME WORK
Setup Costs:
Quality Control:
MAintance:
Total OVerhead Cost:
6. Calculate the production cost per unit for each
of Harbour’s products in an ABC system. (Round your
intermediate calculations and final answers to 2 decimal
places.)
UNIT COST
home:
work:
7. Calculate Harbour’s gross margin per unit for each product under an ABC system. (Round your intermediate calculations and final answers to 2 decimal places.)
GROSS MARGIN
home:
work:
8. 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):
Solution 1:
Overhead Assigned (Traditional Costing) | |
Home model | $79,872 |
Work model | $119,808 |
Total overhead costs | $199,680 |
Solution 2:
Computation of product cost per unit (Traditional) | ||
Particulars | Home | Work |
Direct material cost per unit | $36.00 | $71.00 |
Direct labor cost per unit | $25.00 | $31.00 |
Overhead
cost per unit Home - $79,872 / 680 Work - $119,808 / 390 |
$117.46 | $307.20 |
Production cost per unit | $178.46 | $409.20 |
Solution 3:
Computation of Gross Margin per unit (Traditional) | ||
Particulars | Home | Work |
Selling price per unit | $360.00 | $575.00 |
Production cost per unit | $178.46 | $409.20 |
Gross Margin per unit | $181.54 | $165.80 |
Solution 4 & 5:
Computation of activity rate and Allocation of overhead to Products - ABC - Harbour | ||||||||
Activity | Estimated Overhead Cost | Activity Base | Usage of Activity Base | Activity Rate | Home | Work | ||
Usage | Allocated Costs | Usage | Allocated Costs | |||||
Setup costs | $81,810.00 | Nos of setups | 101 | $810.00 | 37 | $29,970 | 64 | $51,840 |
Quality control | $68,870.00 | Nos of inspections | 710 | $97.00 | 340 | $32,980 | 370 | $35,890 |
Maintenance | $49,000.00 | Machine hours | 3500 | $14.00 | 1400 | $19,600 | 2100 | $29,400 |
Total | $199,680.00 | $82,550.00 | $117,130.00 | |||||
Nos of units | 680 | 390 | ||||||
Overhead cost per unit | $121.40 | $300.33 |
Solution 6:
Computation of product cost per unit - Harbour Company - ABC | ||
Particulars | Home | Work |
Direct material cost per unit | $36.00 | $71.00 |
Direct labor cost per unit | $25.00 | $31.00 |
Overhead cost per unit | $121.40 | $300.33 |
Production cost per unit | $182.40 | $402.33 |
Solution 7:
Computation of Gross Margin per unit - ABC | ||
Particulars | Home | Work |
Selling price per unit | $360.00 | $575.00 |
Production cost per unit | $182.40 | $402.33 |
Gross Margin per unit | $177.60 | $172.67 |
Solution 8:
Comparison of Gross Margin under traditional system and ABC | ||
Particulars | Home | Work |
Gross Margin ( Traditional) | $181.54 | $165.80 |
Gross Margin (ABC) | $177.60 | $172.67 |
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: Home Work Direct materials cost per unit $ 39 $ 62 Direct labor cost per unit 18 32 Sales price per unit 364 571 Expected production per month 640 units 370 units Harbour has monthly overhead of $198,050, which is divided into the following cost pools: Setup costs $ 80,510 Quality control 66,240 Maintenance 51,300 Total $ 198,050 The company has also compiled...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 42 $ 69 Direct labor cost per unit 21 31 Sales price per unit 368 576 Expected production per month 670 units 480 units Harbour has monthly overhead of $219,720, which is divided into the following cost pools: Setup costs $ 92,020 Quality control 61,200 Maintenance 66,500 Total $ 219,720 The company has also compiled...
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 18 34 Sales price per unit 365 574 Expected production per month 800 units 350 units Harbour has monthly overhead of $180,010, which is divided into the following cost pools: Setup costs $ 79,050 Quality control 65,760 Maintenance 35,200 Total $ 180,010 The company has also compiled...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 36 $ 64 Direct labor cost per unit 19 35 Sales price per unit 356 572 Expected production per month 610 units 440 units Harbour has monthly overhead of $210,470, which is divided into the following cost pools: Setup costs $ 80,510 Quality control 65,960 Maintenance 64,000 Total $ 210,470 The company has also compiled...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 42 $ 68 Direct labor cost per unit 21 38 Sales price per unit 361 572 Expected production per month 670 units 470 units Harbour has monthly overhead of $175,865, which is divided into the following cost pools: Setup costs $ 76,140 Quality control 64,525 Maintenance 35,200 Total $ 175,865 The company has also compiled...
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...
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 $ 66 Direct labor cost per unit 18 37 Sales price per unit 361 580 Expected production per month 650 units 490 units Harbour has monthly overhead of $172,590, which is divided into the following cost pools: Setup costs $ 74,260 Quality control 59,130 Maintenance 39,200 Total $ 172,590 The company has also compiled...
Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work $ 37 $ 71 15 363 578 620 units 470 units Direct materials cost per unit Direct labor cost per unit Sales price per unit Expected production per month 37 Harbour has monthly overhead of $186,180, which is divided into the following cost pools: Setup costs Quality control Maintenance Total $ 86,920 55,760 43,500 $186, 180 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 $ 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...