11:29 Chapter 19 Excel Template rev221 A Save a copy Read Only - Save a copy to edit. A G 1 1 2 Cost Management Systems: Activity-Based, Just-In-Time, and Quality Management Systems Using Excel for allocating manufacturing overhead with activity-based costing (ARC) 3 1 Mt. Hood Manufacturing uses ABC to allocate manufacturing overhead costs, and has computed the following: 5 Activity Allocation Base Allocation Rate Equipman Setup Ordering Number of Setup 5500 per setup Number of Drders $20 per ander 9 Machine Maintenance Machine Hours $20 per hour 10 Recent Bestling Hours $30 per hour 12 The company produces two models of industrial heaters, Crest and Cascade The quantity of each activity required by Crest and Cascade is listed below. 15 Allocation Base Crest Cascade 16 Number of Setups 17 Number of Orders Machine Hours 19 Receiving Hours 360 6.000 25,000 4.000 250 12.000 19.101 80C0 21 22 25 29 "-E=":--=t 20 Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marken Requirement Allocate the $1,910,000 estimated manufacturing overhead between the products using activity-based costing to obtain the total manufacturing overhead cost per product. Reconcile the manufacturing overhead allocated to the two products with total manufacturing overhead. Excel Skills Create formules with cell references. 34 15 16 37 38 39 33 Saving & Submitting Solution Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2ped and submit your file to be graded. Now back to the activity window-screen where you downloaded the initial spreadsheet Clox Choose button under step 3; locate the file you just saved and click Open Cid Upload button under step 3 d. Click Submit button under step 4 401 41 42 Viewing Results 43 1 Click on Results tal in MyAccountingLab 44 45 46 2 dick on the Assment you were working un dick on Project Ink; this will bring up your Scare Card 4 Within Score Card window, click on Uve Comments Report (lower right to download spreadsheet with feedback 47 48 49 500 1. Save file 51 Saving & Submitting Chapter Excel Assignments 8. You may want to create folder on desktop, and label COMPLETED EXCEL PROJECTS 52 b. Name your files: CHnumber FirstNameLastName (e.g., CH1 RobynVerdery). 53 2. Upload and submit your file to be graded. 54 55 56 8. Click on "Assessments" located on the navigation bar at the top of the pace to open the dropdown menu. b. Click on "Assignments." G.Select the assignment for this chapter. 57 d. Upload your file(s). 58 e. Double check you uploaded the right files. 59 f. Submit them. ED 61 62 b5 Completing Chapter Excel Quizzes 1. Click on "Assessments" located on the navigation bar at the top of the page to open the dropdown menu. 2. Click on "Exama/Quizzes." 3. Select the Quiz for this chapter. ES 4. Complete the Quiz 66 5. Double check your answers against your Excel worksheets. 57 6. Submit the Quiz. Ni 19 70 71 72 7% 72 75 76 27 fx Enter text or formula here Instructions ENTERANSWERS + " 11:21 Pulse Chapter 19 Excel Template rev221 Read Only - Save a copy to edit. A Save a copy 12 1 the product can advity-based costing to obtain that acting product code the manufacturing | serband al scared to the two amater with sora nandactating c apropia zacierakow Iber raw call refer you and formal D Valas 15 1 www.dataL 15 14 17 13 12 21 21 22 MONA isulzundutakabadhad. M Tog 25 2 T 25 20 27 2K 27 13 24 15 22 38 27 40 41 42 45 45 45 44 41 45 " 55 21 " 52 AL Si 55 53 52 " 1 es " " PL " G PK 09 10 11 12 15 M %3 15 17 13 " 60 el 2 22 65 97 " 51 52 S 57 SP 100 " 102 305 34 105 3 DWA Lockha Nich 300 4200 | 580 ||| per hour Ma DEHUSAR M w izal Mandasa ELRS For call wwwson, beginne fra vita vequal sign 1:1, click on the coresponding Lata tak win the Delbe booters the in CLIU the factions that are are varia Cust Ma ay D 12,000 14 fx (Always use cell references and formulas Instructions ENTERANSWERS +