Question

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 Assembly Setup $30 per machine hour $35 per direct labor hour $90 per setup $20 per inspection $19 per production order $5 per purchase order Inspecting Production scheduling Purchasing The activity-base usage quantities and units produced for each product were as follows: Activity Base Elliptical Machines Treadmill Machine hours 600 400 Direct labor hours Setups Inspections Production orders 15 40 318 Purchase orders Units produced 500 320 Use the activity rate and usage information to determine the total activity cost and activity cost per unit for each product. Total Activity Cost Activity Cost Per Unit Elliptical machines A Treadmill

Answer 1

Con = FCDDF000 (Autosaved) (Autosaved) (Autosaved) - Microsoft Excel - 0 X Page Layout Formulas Data Review View A = = Comic Sans MS - 11 BI U - A A = E = Wrap Text Merge & Center General % - 09 Home Insert * Cut La Copy Pastels in Clipboard A19 A A AutoSum" AY - $ Insert Delete Format D Cell Styles E E , to Conditional Format Formatting as Table Styles Clear Sort & Find & Filter Select Editing Alignment Number Cells Font fic 2 3 पीपीसी Activity Rate(A) 30.00 35.00 90.00 20.00 19.00 5.00 Activity Base Total Activity Cost Eliptical Machine (B) Treadmill(C) Eliptical Machine (A*B) Treadmill(A*C) 600 400 $ 18,000.00 $ 12,000.00 190 223 $ 6,650.00 $ 7,805.00 30 $ 2,700.00 $ 2,700.00 15 25 $ 300.00 $ 500.00 40 30 $ 760.00 $ 570.00 318 85 $ 1,590.00 $ 425.00 30 4 Activity 5 Fabrication 6 Assembly 7 Set up 8 Inspecting 9 Production Scheduling 10 Purchasing 11 12 13 14 15 16 17 Eliptical Machine 18 Treadmill 19 Sheet243 Sheet238 Ready Number of units produced Activity Cost per unit 30,000.00 500 60.00 $ 24,000.00 320 $ 75.00 Total Activity Cost Activity Cost per unit $ 30,000.00 $ 60.00 $ 24,000.00 $ 75.00 Sheet239 Sheet240 Sheet242 Sheet244 Sheet245 Sheet246 Sheet248 Februar BO A o Type here to search e @ 120% u + 11:36 = 4) ENG 29-02-2020 EA 9 1