Product costs using activity rates Body-Solid Inc. manufactures elliptical exercise machines and treadmills. The products are...

Transcribed Image Text:

Product costs using activity rates Body-Solid Inc. manufactures elliptical exercise machines and treadmills. The products are prouced 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 Fabrication Assembly Setup Inspecting Production scheduling Purchasing Activity Rate $24 per machine hour $16 per direct labor hour $49 per setup $32 per inspection $17 per production order $14 per purchase order The activity-base usage quantities and units produced for each product were as follows: Activity Base Elliptical Machines Treadmill Machine hours 2,004 1,182 Direct labor hours 477 186 Setups 60 19 Inspections 613 368 Production orders 63 13 Purchase orders 184 112 245 164 Units produced This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Use the activity rate and usage information to determine the total activity cost and activity cost per unit for each product. If required, round the per unit answers to the nearest cent. Elliptical machines Treadmill Total Activity Cost Activity Cost Per Unit 76,931 X $ 314 X 35,640 X $ 214 X Product costs using activity rates Body-Solid Inc. manufactures elliptical exercise machines and treadmills. The products are prouced 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 Fabrication Assembly Setup Inspecting Production scheduling Purchasing Activity Rate $24 per machine hour $16 per direct labor hour $49 per setup $32 per inspection $17 per production order $14 per purchase order The activity-base usage quantities and units produced for each product were as follows: Activity Base Elliptical Machines Treadmill Machine hours 2,004 1,182 Direct labor hours 477 186 Setups 60 19 Inspections 613 368 Production orders 63 13 Purchase orders 184 112 245 164 Units produced This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Use the activity rate and usage information to determine the total activity cost and activity cost per unit for each product. If required, round the per unit answers to the nearest cent. Elliptical machines Treadmill Total Activity Cost Activity Cost Per Unit 76,931 X $ 314 X 35,640 X $ 214 X