1. Compute the
manufacturing cost per unit using the plantwide overhead rate based
on direct labor hours. |
|
Overhead costs |
$93,300 |
$11.66 |
per direct labor hour |
|
|
Direct labor hours |
8,000 |
|
|
Overhead Assigned |
Activity Driver |
Plantwide OH rate |
Total Overhead Cost |
Units Produced |
OH Cost per unit |
|
Product A |
5,000 |
$11.66 |
$58,300 |
10,000 |
$5.83 |
|
Product B |
3,000 |
$11.66 |
$34,980 |
2,000 |
$17.49 |
|
|
|
|
|
|
|
|
Total
manufacturing cost per unit: |
Product A |
Product B |
|
|
Direct material
cost per unit |
$14.00 |
$26.00 |
|
|
|
Direct labor cost
per unit(Direct labour hour*per hour rate) |
10 |
30 |
10=.5*20, 30=1.5*20 |
|
|
Overhead cost per
unit |
5.83 |
17.49 |
|
|
|
Total
manufacturing cost |
$29.83 |
$73.49 |
|
|
|
|
|
1.2 What is the
gross profit per unit? |
|
|
Product A |
Product B |
|
|
Market price |
$34.00 |
$95.00 |
|
|
|
Manufacturing cost
per unit |
($29.83) |
($73.49) |
|
|
|
Gross profit per
unit |
$4.17 |
$21.51 |
|
|
|
2.1 How much gross
profit is generated by each customer of Product A and Product B
using the plantwide overhead rate? |
|
|
Product A |
Product B |
|
|
Gross profit per
unit |
$4.17 |
$21.51 |
|
|
|
Units purchased
per customer |
20 |
5 |
|
|
|
Gross profit per
customer |
$83.40 |
$107.55 |
|
|
|
2.2 What is the
cost of providing customer service to each customer? |
|
Customer service costs |
$72,000 |
$80.00 |
per customer |
|
|
Number of customers |
900 |
|
|
Is the gross
profit adequate for each customer of Product A and B using the
plantwide overhead rate? |
|
|
Product A |
Product B |
|
|
Gross profit per
customer |
$83.40 |
$107.55 |
|
|
|
Customer service
cost per customer |
80 |
80 |
|
|
|
Profit (loss) per
customer |
$3.40 |
$27.55 |
|
|
|
Is the profit
adequate? |
Yes |
Yes |
|
|
|
3.1 Determine the
manufacturing cost per unit of each product line using ABC. |
|
Engineering Support |
|
|
|
|
|
|
Inspection hours |
$26,500 |
$490.74 |
|
|
|
Number of modifications |
54 |
|
|
Electricity |
|
Overhead costs |
$24,800 |
$4.00 |
|
|
|
Number of machine hours |
6,200 |
|
|
Setup |
|
Overhead costs |
$42,000 |
$140.00 |
|
|
|
Number of batches |
300 |
|
|
|
|
Overhead Assigned |
Activity Driver |
Activity rate |
Total Overhead Cost |
|
Product A |
|
|
|
|
|
|
Engineering support |
9 |
modifications |
$490.74 |
per modification |
$4,417 |
|
Electricity |
4,000 |
machine hours |
$4.00 |
per machine hour |
16,000 |
|
Setup |
100 |
Batches |
$140.00 |
per batch |
$14,000 |
|
Total Overhead for
A |
$34,417 |
|
No. of units |
10000 |
|
Overhead per
unit |
$3.44 |
|
Product B |
|
|
|
|
|
|
Engineering support |
45 |
modifications |
$490.74 |
per modification |
$22,083 |
|
Electricity |
2,200 |
machine hours |
$4.00 |
per machine hour |
8,800 |
|
Setup |
200 |
Batches |
$140.00 |
per batch |
$28,000 |
|
Total Overhead for
B |
$58,883 |
|
No. of units |
2000 |
|
Overhead per
unit |
$29.44 |
|
Total
manufacturing costs |
Product A |
Product B |
|
|
|
Direct Materials
per unit |
$14.00 |
$26.00 |
|
|
Direct Labor per
unit |
$10.00 |
$30.00 |
|
Overhead per
unit |
$3.44 |
$29.44 |
|
Total
manufacturing cost per unit |
$27.44 |
$85.44 |
|
|
|
3.2 What is the
gross profit per unit? |
|
|
Product A |
Product B |
|
|
Market price |
$34.00 |
$95.00 |
|
|
|
|
-27.44 |
-85.44 |
|
|
|
|
$6.56 |
$9.56 |
|
|
|
4.1 How much gross
profit is generated by each customer of Product A and Product B
using ABC? |
|
|
Product A |
Product B |
|
|
0 |
$6.56 |
$9.56 |
|
|
|
Units purchased
per customer |
20 |
5 |
|
|
|
Gross profit
(loss) per customer |
$131.20 |
$47.80 |
|
|
|
4.2 Is the gross
profit adequate for each customer of Product A and B using
ABC? |
|
|
Product A |
Product B |
|
|
Gross profit
(loss) per customer |
$131.20 |
$47.80 |
|
|
|
Customer service
cost per customer |
80 |
80 |
|
|
|
Profit (loss) per
customer |
$51.20 |
($32.20) |
|
|
|
Is the
profit adequate using ABC? |
Yes |
No |
|
|
|