D Xact Corporation produces collapsible storage boxes. The two most popular styles of storage boxes: Green Large and Blue Medium: Xact uses an ABC couting wstem and has the following overhead costs: G 5 Overhead Costs Manufacturing overhead Selling overhead Administrative overhead Total Overhead $900,000 $600.000 $100.000 $1.200.000 The company is the final contpools and drivers civity cost De Total Act Green Large Medium Amb Humber of unit 10,000 2.00 ILO umo 200 Ad 160 Michelon 20.000 2000 120 300 154 o loco no et on antener and are conducted with compacted to the cost poolt as Customer Med Assen LON Setups Total 20 10 Support Other Number of customers Not allocated to customers or products 300 150 150 is based on an edersive analysis and surveys conducted with all employees, Xact distributes its overhead to the cost pools as follows: 29 20 21 Total Manufacturing overhead Selline overhead Administrative overhead Assembly 40% 58 303 Setups 203 5 20% Machining 20 5% 10 Customer Support 10% 80% 30% Other 10% 5% 10 100% 1001 14 JOON Price and direct couts per unit for last year are as follows: 20 Green Blue Medium Sensor $200 $150.00 Director S100.00 $50.00 Curatato $20.00 510.00 11 Chapter lors 5 A tal cost in cos pool activity level 2 retto cott A. Ach level incurred by costo Required H 33 1. Activity rate = Total cost in cost pool/ total activity level 34 2. Indirect costs applied to cost object - Activity ratex Activity level incurred by cost object 35 36 Required: 31 Part 1: Prepare a report showing first stage allocation of the overhead costs to the activity cost pools. (5 maris) Assembly Setups Machining Customer Support Other Total 41 Manufacturing overhead Selling overhead Administrative overhead Total overhead costs Part 2: Calculate the activity rates for each cost poolmarks --=-=- Activity Cost Pool Assembly Setups Machining Customer Support Other Part in the strong, so cute purchased a total of units of the largestorbe The orders to an Customer Support Other 3 - Part 3:During the past month, 50 customers purchased a total of 250 units of the large storage boxes. These orders required a total of 20 setups and AB0 machine hours. Compute the product margin using an income statement format. (6 marts All row may not be required 95 SS3 Product man