Activity-Based Costing lack Corporation has the following predicted indirect costs and cost drivers for 2016 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver $25,000 Machine hours Materials handling 30,000 15,000 Material moves 5,000 Machine setups 25,000 Inspection hours Machine setups $135,000 $70,000 The following activity predictions were also made for the year: Machine hours Material moves Machine setups Inspection hours 10,000 3,000 700 5,000 1,500 50 1,000 It is assumed that the cost per unit of activity for a given activity does not vary between departments. Slack's president, Charles Slack, is trying to evaluate the company's product mix strategy regarding two of its five product models, ZX300 and SL500. The company has been using a company-wide overhead rate based on machine hours but is considering switching to either department rates or 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: Direct materials cost Direct labor cost Machine hours (Fabrication)00 Machine hours (Finishing) Materials move Machine setups Inspection hours ZX300 SL500 $14,000 $20,000 $5,000 $4,000 700 100 50 200 30 30 60 a. Determine the cost of one unit each of ZX300 and SL500, 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 13.67 per machine hour Use rounded overhead rate calculated above for calculations below. Round cost answers to the nearest whole number. Round cost per unit to two decimal places. Use rounded overhead rate calculated above for calculations below. Round cost answers to the nearest whole number. Round cost per unit to two decimal places. Product Costs per Unit ZX300 5L500 14,000 5,000 1350 Direct materials 20000 Direct labor 4000 Manufacturing overhead 24,000 X Total cost per batch Number of units per batch Cost per unit b. Determine the cost of one unit of ZX300 and SL500, assuming department overhead rates are used. Overhead is assigned based on machine hours in both Round rate to two decimal places, if applicable. Overhead rate based on machine hours for Fabrication Deptsxper machine hour Overhead rate based on machine hours for Finishing Dept. s 0 x 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 Product Costs per Unit ZX300 SL500 Direct materials o x Direct labor 0 XX Manufacturing overhead Fabrication Dept 0 x Finishing Dept Total cost per batch Number of units per batch o xx c. Determine the cost of one unit of ZX300 and SL500, 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: 0 XX 0 per materials move 0 per machine setup o X per inspection hour per machine hour 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 ZX300 SL500 Direct materials Direct labor 0 X Manufacturing overhead: Maintenance activity Materials handling activity Machine setups activity o X Inspections activity Total cost per batch Number of units per batch Cost per unit Check You have correctly selected 5. Marks for this submission: 5.00/51.00
