How would I solve this and type this in excel with formulas?

Activity-Based Costing, Lean Operations, and the Cost of Quality Use department overhead rates to allocate manufacturing overhead 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 following departmental overhead rates: per machine hour 9 Cutting Department: per direct labor hour 18 Finishing Department: 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 manufacturing 9 departments: Cutting Department Finishing Department 10 JOB 484 2 7 11 Direct Labor Hours 8 4 Machine Hours 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 copy/paste from 15 the Instruction tab you will be marked wrong. 16 17 Requirements 1 How much manufacturing overhead should be allocated to Job 484? 2 What was the total manufacturing cost of Job 484? Check your spelling carefully and do not abbreviate. 18 19 20 a 21 (Always use cell references and formulas where appropriate to receive full credit. If 1 you copy/paste from the Instruction tab you will be marked wrong.) 2 3 1. How much manufacturing overhead should be allocated to Job 484? 4 5 Allocation of Manufacturing overhead from Cutting Department 6 Allocation of Manufacturing overhead from Finishing Department 7 Total Manufacturing overhead allocated to Job 484 9 2. What was the total manufacturing cost of Job 484? 10 11 Direct materials 12 Direct labor 13 Manufaturing overhead 14 Total Job Cost 15 16 17