Question
The Managing Director has come to you on a Friday afternoon all inspired from a conference she has just been on about Activity Based Costing.
The Managing Director has come to you on a Friday afternoon all inspired from a conference she has just been on about Activity Based Costing. The conference focus was on the costs and benefits of implementing activity-based costing (ABC) method. The managing director has asked for you to prepare an analysis comparing two products Compact Discs (CD) and Vinyl Records.
The firm has always applied overhead (OH) to products based on direct labor-hours (DLH) as a cost driver. The OH has been calculated to be $15.00 per DLH. The following data summaries the companys sales and cost estimated for 2014.
2019 Sales and Cost estimates | Vinyl Records | CD |
Forecast Sales (Units) | 200,000 | 20,000 |
Selling price per unit($) | $12 | $15 |
Prime Costs per unit | $6 | $8 |
DLH per Unit | 0.25 | 0.25 |
OH per DLH | $4 | $4 |
Activity | Cost | Cost Driver | Amount of Cost Driver | |
Vinyl Records | CD | |||
Machining Set Ups | $94,000 | Set up Hours | 50 | 200 |
Electronic Assembly | $35,500 | Machine Hours | 30,000 | 70,000 |
Quality Control | $65,500 | QA Samples per 10,000 units | 150,000 | 250,000 |
Packaging | $25,000 | Number of Orders | 2,600 | 3,400 |
Total Activity Costs | $220,000 |
|
|
|
Required:
- Using the current factory-wide cost driver method of applying overhead develop a spreadsheet to calculate for each product the expected:
- Gross Proft per unit,
- Total Gross Profit per Model, and
- Total Firm Gross Profit
-
- Using the activity cost data provided conduct the same analysis utilizing Activity Based Costing techniques to again calculate for each model the expected:
-
-
- Gross Proft per unit,
- Total Gross Profit per Model, and
- Total Firm Gross Profit
-
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started