Please I need Help with this case Also please with detailed and the type of formula that used to calculated each of the requirements. The case study must be completed in Excel using appropriate cell formulas.

TRADITIONAL versus ABC COSTING

Top-Line Suitcases manufactures three lines of suitcases from basic to deluxe to heavy-duty. The company uses a traditional job-order costing system with manufacturing overhead allocated based on direct labor hours.

The company has been losing market share. Upon analysis, the basic model was overpriced compared to competitors. Competitors were selling basic suitcase for $115, yet this is the cost of the basic suitcase for Top-Line. The company president said how can our competitors sell for this price? What are we doing wrong? The new CFO anxiously responded I think your job-order costing system is outdated and distorting product costs. The president requested an analysis of alternative product-costing systems.

In her analysis, the CFO compared the traditional job-order costing system with an activity-based costing system. She determined three manufacturing overhead activity cost pools:

Cost Pool Cost Driver Product Line Breakdown

Basic Deluxe Heavy-Duty

Purchasing # of purchase orders 48% 10% 42%

Maintenance # of machine hours 40% 12% 48%

Inspection # of inspections 45% 10% 45%

REQUIRED:

1. Calculate the traditional predetermined overhead rate with manufacturing overhead allocated based on direct labor hours.
   1. Calculate the unit cost for each product line using the traditional job-order costing system currently used by Top-Line Suitcases.
2. Calculate the unit cost for each product line using the activity-based costing system.
3. Top-Line Suitcases prices its suitcases at 110% of product cost. Assuming the CFO has decided to keep this formula, determine the target price for each product under both methods, traditional and activity-based systems.
4. Assume you are the CFO. Write a memo to the company president explaining your analysis including your recommendation for target pricing.