1 Activity-Based Costing, Lean Operations, and the Cost of Quality 2 Use department overhead rates to allocate manufacturing overhead 3. Whitney Furniture uses department overhead rates (rather than a plantwide overhead rate) to allocate its manufacturing overhead to jobs. The company's two production departments have the 4 following departmental overhead rates: Assume for Job 484 that direct labor is paid at a rate of $24 per hour and the job used $2,400 of direct materials. Job 484 used the following direct labor hours and machine hours in the two 9 manufacturing departments: 10 11 12 13 14 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you is copy/paste from the instructions tab or if you type the numbers in, you will be marked wrong. 16 17 Requirements 181 How much manufacturing overhead should be allocated to Job 484 ? 192 What was the total manufacturing cost of Job 484 ? 20 a. Check your spelling carefully and do not abbreviate. 21 22 For help completing the requirements, watch the video walk through. 23 24 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 spreadsh 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 A (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.) 1. How much manufacturing overhead should be allocated to Job 484 ? Allocation of Manufacturing overhead from Cutting Department Allocation of Manufacturing overhead from Finishing Department Total Manufacturing overhead allocated to Job 484 2. What was the total manufacturing cost of Job 484 ? 10 11 12 13. Total Job Cost