Answer To: Objective: Demonstrate understanding of Activity-based Costing analysis and managerial application...
Tanmoy answered on Feb 17 2021
Exercise_pg1
Activity-based Management Case
Data:
Cost Product Design Labor Support Automation Customer Relations Other Total
Production Department
Indirect Labor $ 2,000,000 5% 75% 10% 0% 10% 100%
Material Planning & Logistics 1,200,000 10% 40% 45% 0% 5% 100%
Plant Facilities Expense 1,800,000 5% 25% 60% 0% 10% 100%
Depreciation Expense 3,500,000 10% 4% 70% 0% 16% 100%
Total Production Dept Expense $ 8,500,000
Selling & Administrative Department
Design Engineering $ 600,000 75% 5% 10% 5% 5% 100%
Administrative Staff Wages 300,000 5% 20% 10% 15% 50% 100%
Marketing Expense 400,000 10% 10% 0% 70% 10% 100%
Selling Expenses 200,000 0% 0% 0% 90% 10% 100%
Total Selling & Admin. Dept Expense $ 1,500,000
Total Overhead $ 10,000,000
PART #1: Assign Costs to Activity Cost Pools
Activity Cost Pools
Product Design Labor Support Automation Customer Relations Other
Production Department
Indirect Labor $ 100,000 $ 1,500,000 $ 200,000 $ - 0 $ 200,000
Material Planning & Logistics $ 120,000 $ 480,000 $ 540,000 $ - 0 $ 60,000
Plant Facilities Expense $ 90,000 $ 450,000 $ 1,080,000 $ - 0 $ 180,000
Depreciation Expense $ 350,000 $ 140,000 $ 2,450,000 $ - 0 $ 560,000
Selling & Administrative Department
Design Engineering $ 450,000 $ 30,000 $ 60,000 $ 30,000 $ 30,000
Administrative Staff Wages $ 15,000 $ 60,000 $ 30,000 $ 45,000 $ 150,000
Marketing Expense $ 40,000 $ 40,000 $ - 0 $ 280,000 $ 40,000
Selling Expenses $ - 0 $ - 0 $ - 0 $ ...