Background:
Performance Drinks makes four different kinds of sports drinks. Those drinks are as follows:
· Basic
· Hydration
· Intensity
· Post-Workout
You recall from your Management Accounting class that product costs are comprised of:
· Direct Materials
· Direct Labor
· Manufacturing Overhead
That report is following:
Since your primary area of focus is on the indirect costs you compile the following report which further details your overhead charges:
Requirements:
1. Based on all of the date provided, compute the cost driver rates for each of the four activities.
2. Compute the per unit product costs for each of the four products. Compute this cost using ABC allocation for overhead. Show the computation for each per unit product cost in detail.
3. Prepare a "Monthly Profit Report", like the one provided on page 4 of this packet. Create this report using the results of your ABC overhead allocation.
4. Explain why the profit for each product is different when comparing the Traditional report with the ABC report. Explain what the company might consider doing, based on all of this information, to stop the erosion of company profits. Defend your recommendations with data.
Additional Consideration:
If plant capacity was shifted from 20,000 machine-hours a month to 40,000 machine-hours per month!
5. Compute the new cost per unit for each of the products considering the increase in capacity. Show the computation for each per unit product cost in detail.
6. What is the cost of the unused capacity if it is assumed that the company has 40,000 machine-hours of capacity but it using 20,000 machine-hours? Amend your "Management Report" to include a discussion on how to best use the additional capacity.
| PERFORMANCE DRINKS - MONTHLY PROFIT REPORT |
| |
Basic |
Hydration |
Intensity |
Post Workout |
Total |
| REVENUE |
|
|
|
|
|
| Sales |
$ 125,000 |
$ 120,000 |
$ 74,250 |
$ 93,000 |
$ 412,250 |
| COSTS |
|
|
|
|
|
| Direct Materials |
$ 40,000 |
$ 50,000 |
$ 31,000 |
$ 33,000 |
$ 154,000 |
| Direct Labor |
$ 25,000 |
$ 20,000 |
$ 10,000 |
$ 18,000 |
$ 73,000 |
| Fringe Benefits on Direct Labor |
$ 11,250.00 |
$ 9,000.00 |
$ 4,500.00 |
$ 8,100.00 |
$ 32,850.00 |
| Manufacturing Overhead |
$ 43,750.00 |
$ 35,000.00 |
$ 17,500.00 |
$ 31,500.00 |
$ 127,750.00 |
| TOTAL COST |
$ 120,000.00 |
$ 114,000.00 |
$ 63,000.00 |
$ 90,600.00 |
$ 387,600.00 |
| GROSS MARGIN |
$ 5,000.00 |
$ 6,000.00 |
$ 11,250.00 |
$ 2,400.00 |
$ 24,650.00 |
| GROSS MARGIN RATIO |
4.00% |
5.00% |
15.15% |
2.58% |
5.98% |
| |
|
|
|
|
|
| Annual Volume: |
100,000 |
80,000 |
45,000 |
60,000 |
285,000 |
| Unit Price: |
$ 1.25 |
$ 1.50 |
$ 1.65 |
$ 1.55 |
$ 1.45 |
| Unit Cost: |
$ 1.200 |
$ 1.425 |
$ 1.400 |
$ 1.510 |
$ |
|
|
Monthly Charge
|
Equipment
Set-ups
|
Production
Runs
|
Number
of
Products
|
Machine-
HOW'
Capacity
|
|
indirect Labor
|
5 55,000.00
|
20%
|
45%
|
15%
|
20%
|
|
Fringe Benefits on Indirect Labor
|
$ 24,750.00
|
20%
|
45%
|
15%
|
20%
|
|
Utilities
|
$ 5,000.00
|
5%
|
65%
|
0%
|
30%
|
|
Processing Equipment - Depreciation
|
$ 10,000.00
|
0%
|
100%
|
0%
|
0%
|
|
Preventative Maintenance
|
$ 10,000.00
|
40%
|
30%
|
0%
|
30%
|
|
Information Technology
|
5 23,000.00
|
10%
|
15%
|
70%
|
5%
|
|
Activity
|
Basic
|
Hydration
|
Intensi
|
Post Workout
|
|
Set-ups
|
15
|
15
|
50
|
5
|
|
Production Runs
|
125
|
65
|
35
|
25
|
|
Production MV.
|
1
|
1
|
1
|
1
|
|
Machine-Hour Capacity
|
9000
|
4000
|
3000
|
4000
|
|
PERFORMANCE DRINKS - MONTHLY MFG OHD COST REPORT
|
|
|
Monthly Charge
|
|
Indirect Labor
|
$ 55,000.00
|
|
Fringe Benefits on Indirect Labor
|
$ 24,750.00
|
|
Utilities
|
$ 5,000.00
|
|
Processing Equipment - Depreciation
|
$ 10,000.00
|
|
Preventative Maintenance
|
$ 10,000.00
|
|
Information Technology
|
$ 23,000.00
|
|
Total
|
$ 127,750.00
|