Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Finishing Dement Department Center Maintenance 550.000 10000 Machine hours handing 90,000 45.000 Materal moves Machine 200.000 15.000 chines Inspections M The following activity predictions were also made for the years Fabrication Finishing Department Department Machine hours Material moves Machine Setups 350 5.00 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 companys product mix strategy regarding two of its product models, SW100 and 56150. 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 rate. The production manager has provided the following data for the production of a batch of 100 units for each of these models: SW100 SG 150 Direct mu s t 5 20000 10000 Direct labor cost SRLOO $6000 Machine hours braon 250 350 Machine hours Finishing Machine setups 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: $0 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 S6150 Direct materials Direct later Manufacturing overhead Total cost perbatch 5 Number of units perbach 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.: 50 per machine hour. Overhead rate based on machine hours for Finishing Dept. $0 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 dedmal places if needed Product Costs per Unit SW100 S6150 Direct materials SOS Direct labor Ma r ng overhead bution Dept Finishing Dept Total cost per batch 5 05 0 Number of units per bach0 0 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 0 Materials tunding 5 0 Machine setup $ 0 Inspection activities $ 0 Use rounded overhead rate cakulated above for calculations below. Round cost answers to the nearest whole number, when needed. Round cost per unit to two decimal places if needed. Produkt Costs per Unik SW100 SG150 Drect material 505 Manufacturing overhead Maintenance activity Maintenance handing activity Machines activity Inspections activity Total cost per bal Murrber of units per batch Cost per unit Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools Maintenance Matera handing Department Department Cost Driver 560.000 30.000 1.000 Material moves 210,000 15.000 Machine setups 2.000 inspection hours The following activity predictions were also made for the year Fabrication Finishing Department Department Machine hours 5.000 2.500 Material moves 1.500 Machine was 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 ma strategy regarding two of its product models, SW100 and 56150. The company has been using a company wide overhead race based on machine hours but is considering switching to either department rates of activity-based rate. The production manager has provided the following data for the production of a batch of 100 units for each of these models: SW100 56150 Direct materials cost $20,000 $30,000 Direct labor cost S&000 6000 Machine hours Fabrication 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: 50 per machine hour Use rounded overhead rate calculated about for calculations below. Round cost answers to the nearest whole number. Hound cost per unit to two decimal places Product Costs per Unit SW100 SG 150 Direct materials Direct labor Manufacturing overhead Total cost per batch Number of per batch Cost per unit b. Determine the cost of one unit of SW100 and SG150, assuming department overhead rates are used. Overheads assigned based on machine hours in both departments, Round to two decimal places, if applicable. Overhead rate based on machine hours for Fabrication Dept: 0 per machine hour. Overhead rate based on machine hours for Finishing Dept: $0 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 Finishine Dept Total cost per batch 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 Material handling Machine setup 5 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 Direct materials Direct labor Manufacturing over Maintenance activity Maintenance banding activity Machine seus activity Inspections activity Total cost per batch Number of units per batch Cost per unit 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 $ 60,000 30,000 Machine hours Materials handling 45,000 Material moves Machine 210,000 15,000 Machine setups Inspections 75,000 Inspection hours Total $360,000 $165,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 SG 150. 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 rate. The production manager has provided the following data for the production of a batch of 100 units for each of these models: SW100 SG150 Direct materials cost $ 20,000 S 30,000 Direct labor cost $ 8,000 $6,000 Machine hours (Fabrication) 250 Machine hours (Finishing) Materials moves Machine setups Inspection hours 15 30 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. 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 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 Materials handling 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 Maintenance handling activity Machine setups activity Inspections activity Total cost per batch Number of units per batch Cost per unit