mary: Activity rates for trax Company are presented in cells A5 to C8 and Activity usage is presented in cells A12 to C16. A statement of requi D E F G 2 Trax Company manufactures 75 stationary bikes and 100 rowing machines with three activities. Activity rates to produce these products follow 4 S Activity 6 Assembly 7 Purchasing 8 Inspection 9 10 Activity usage for each product follows 11 Activity Rate $20 per direct labor hour $10 per purchase order $25 per inspection Stationary bikes Rowing machines 75 100 12 Activity Usage 13 Activity Cost Driver Stationary bikes Rowing machines 14 Direct labor hours 300 15 Purchase orders 16 Inspections 829 500 12 15 18 20 17 18 Required: 19 Compute the overhead cost per unit for the stationary bikes and the rowing machines. 20 21 (Use cells A4 to C16 from the given information to complete this question. Round Overhead per unit amounts to 2 decimal places.) 22 23 Overhead cost per unit--Stationary bikes 24 Activity Cost Pool 25 Assembly 26 Purchasing Activity Usage Activity Rate Allocated Cost 27 Inspection 28 Total allocated rod Graded Worksheet + H McGraw H Legend Graded c needed. Scratche workspace Save an 18 Required: Mo 19 Compute the overhead cost per unit for the stationary bikes and the rowing machines. 20 21 (Use cells A4 to C16 from the given information to complete this question. Round Overhead per unit amounts to 2 decimal places.) 22 23 Overhead cost per unit-Stationary bikes 24 Activity Cost Pool Activity Usage Activity Rate Allocated Cost L 25 Assembly 26 Purchasing 27 Inspection 28 Total allocated cost 29 Units produced 30 Overhead cost per unit 31 32 Overhead cost per unit-Rowing machines 33 Activity Cost Pool 34 Assembly 35 Purchasing 36 Inspection 37 Total allocated cost 38 Units produced 39 Overhead cost per unit 40 41 42 Activity Usage Activity Rate Allocated Cost 43 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work 44 Nothing in this area will be graded, but it will be submitted with your assignment. AGraded Worksheet +