Allocate the $662,748 estimated manufacturing overhead costs for a year 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.

Cost Management Systems: Activity-Based, Just-In-Time, and Quality Management Systems Using Excel for allocating manufacturing overhead with activity-based costing (ABC) A Manufacturing company uses ABC to allocate manufacturing overhead costs, and has computed the following: The company produces two models of industrial air conditioners, Gunter and Hoover. The quantity of each activity required by Gunter and Hoover is listed below. 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 marked wrong. Requirement Allocate the $662,748 estimated manufacturing overhead costs for a year 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 formulas with cell references. Saving \& Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you just saved and click Open c. Click Upload button under step 3 d. Click Submit button under step 4 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 3 Click on Project link; this will bring up your Score Card 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback locate the $662,748 estimated manufacturing overhead costs for a year between the products using activity-based costing to obtain the total manufacturing overhead cost