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:

1. Using the current factory-wide cost driver method of applying overhead develop a spreadsheet to calculate for each product the expected:
   1. Gross Proft per unit,
   2. Total Gross Profit per Model, and
   3. Total Firm Gross Profit

1. 2. Using the activity cost data provided conduct the same analysis utilizing Activity Based Costing techniques to again calculate for each model the expected:
   3. 1. 1. Gross Proft per unit,
         2. Total Gross Profit per Model, and
         3. Total Firm Gross Profit