Total Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Finishing Department Department Cost Driver Maintenance $ 24,000 12,000 Machine hours Materials handling 36,000 18,000 Material moves Machine 84,000 6,000 Machine setups Inspections 30,000 Inspection hours $144,000 $66,000 The following activity predictions were also made for the year: Fabrication Finishing Department Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 Inspection hours 500 It is assumed that the cost per unit of activity for a given activity does not vary between departments. Steampunk's president, Abner Punk, is trying to evaluate the company's product mix strategy regarding two of its product models, SW100 and SG150. The company has been using a company wide overhead rate based on machine hours but is considering switching to either department rates of activity-based rates. The production manager has provided the following data for the production of a batch of 100 units for each of these models: 25 SW100 SG 150 350 Direct materials cost $8,000 $ 12,000 Direct labor cost $3,200 $2,400 Machine hours (Fabrication) 250 Machine hours (Finishing) 100 Materials moves Machine setups Inspection hours a. Determine the cost of one unit each of SW100 and SG150, assuming a company-wide overhead rate is used based on total machine hours. Round rate to two decimal places. Overhead rate based on total machine hours: $ per machine hour Use rounded overhead rate calculated about for calculations below. Round cost answers to the nearest whole number. Round cost per unit to two decimal places. Product Costs per Unit SW100 SG150 Direct materials Direct labor Manufacturing overhead Total cost per batch Number of units per batch Cost per unit b. Determine the cost of one unit of SW100 and SG150, assuming department overhead rates are used. Overhead is assigned based on machine hours In both departments Round to two decimal places, if applicable. WEMESTRIS persen Cost per unit b. Determine the cost of one unit of SW100 and SG150, assuming department overhead rates are used. Overhead is assigned based on machine hours in both departments. Round to two decimal places, if applicable. Overhead rate based on machine hours for Fabrication Dept.: $ per machine hour. Overhead rate based on machine hours for Finishing Dept.: $ per machine hour. Use rounded overhead rate calculated above for calculations below. Round cost answers to the nearest whole number, when needed. Round cost per unit to two decimal places, if needed. Product Costs per Unit SW100 SG150 Direct materials Direct labor Manufacturing overhead: Fabrication Dept. Finishing Dept Total cost per batch $ 5 Number of units per batch Cost per unit c. Determine the cost of one unit of SW100 and SG150, assuming activity-based overhead rates are used for maintenance, materials handling machine setup, and inspection activities. Round rate to two decimal places, if applicable. Activity based overhead rates: Materials handling Machine setup 5 Finishing Dept. Total cost per batch 5 5 Number of units per batch Cost per unit C. Determine the cost of one unit of SW100 and SG150, assuming activity based overhead rates are used for maintenance, materials handling, machine setup, and inspection activities. Round rate to two decimal places, if applicable. Activity based overhead rates: Maintenance 5 Materials handling 5 Machine setup Inspection activities $ Use rounded overhead rate calculated above for calculations below. Round cost answers to the nearest whole number, when needed. Round cost per unit to two decimal places, if needed. Product Costs per Unit SW100 SG150 Direct materials Direct labor Manufacturing overhead: Maintenance activity Materials handling activity Machine setups activity Inspections activity Total cost per batch Number of units per batch Cost per unit Check
