Product costs using activity rates Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $30 per machine hour Assembly $36 per direct labor hour Setup $85 per setup Inspecting $19 per inspection Production scheduling $18 per production order Purchasing $9 per purchase order The activity-base usage quantities and units produced for each product were as follows: Activity Base Elliptical Machines Treadmill Machine hours 650 400 Direct labor hours 208 265 47 22 Setups Inspections Production orders Purchase orders 50 40 305 Units produced 510 360 3 D 1 Product costs using activity rates 2 Hercules Inc, manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: 18 5 DATA Activity Activity Rate 7 Fabricaton 30 per machine hour 3 Assembly 36 9 Setup 85 por Setup 10 Inspecting 19 por inspection 11 Production scheduling 18 por production order 12 Purchasig 9 por purchase order e Data C79 E D 14. The activity-base usage quantities and units produced for each product were as follows: 15 16 DATA 17 Activity Base Elliptical Machines Treadmill 18 Machine bours 650 400 19 Direct labor hours 208 265 20 Setups 47 47 21 Inspections 17 22 22 Production orders 50 40 21Purchase orders 305 84 24 Units produced 510 380 Using formulas and cell references, perform the required analysis, and input your answers into Total Activity Cost and Activity Cost Per Unit columns 26 Transfer the numeric results for the green entry colls (C29 030) into the appropriate folds in CNOWV2 for grading 25 Using formulas and cell references, perform the required analysis, and input your answers into Total Activity Cost and Activity Cost Per Unit columns 26 Transfer the numeric results for the green entry cells (C29.030) Into the appropriate fields in CNOWV2 for grading Total Activity Cost Activity Cost Per Unit Formulas 29 Elliptical Machines 30Treadmill 34 15 Data Use the activity rate and usage information to calculate the total activity cost and activity cost per unit for each product. If required, roun the per unit answers to the nearest cent Total Activity Cost Activity Cost Per Unit Elliptical Machines $ Treadmill