I am working on question 4-30. The question and data are in the first 2 photos. the third is a copy of the spreadsheet I am completing. Can you please look at what I have already completed to see if it is correct as well as help me with the parts I have not yet finished.

labor hours) $ 8 per hour (LO3, Determine the total cost for job 903. 4-29 Job order costing and consulting Mackenzie Consulting computes the cost of each consulting engagement by adding a portion of firmwide overhead costs to the labor cost of the consultants on the engagement. The overhead costs are assigned to each consulting engagement using a cost driver rate based on consultant labor costs. Mackenzie Consulting's overhead costs are $5 million per year, and total consultant labor cost is estimated at $2.5 million per year. Required (a) What is Mackenzie Consulting's cost driver rate? (b) If the consultant labor cost on an engagement is $25,000, what cost will Mackenzie Consult- ing compute as the total cost of the consulting engagement? 4-30 Job order costing and cost driver rates KAM Company uses a job order costing system at its (L03 local plant. The plant has a machining department and a finishing department. The company uses machine hours to allocate machining department overhead costs to jobs and uses direct labor cost to allocate finishing department overhead costs to jobs. Cost and practical capacity estimates for the current year are as follows: Cambridge Business Publisher Accumulating and Assigning Costs to Products MACHINING DEPARTMENT FINISHING DEPARTMENT Manufacturing overhead costs Machine hours Direct labor hours.... Direct labor cost. $450,000 14,000 3,500 $ 63,000 $320,000 1,400 15,400 $323,400 Required (a) Determine the cost driver rate for each department. (b) Cost records for job 103 show the following: MACHINING DEPARTMENT FINISHING DEPARTMENT Direct materials cost. Direct labor cost Direct labor hours. Machine hours .... $9,000 $ 126 7 50 $1,200 $ 735 35 6 Determine the total cost charged to job 103. -6) 4-31 Single rate versus departmental ratae Noth winction deput Table Tools use Assignment 091320 - Word es Mailings Review View Help Design Layout Tell me what you want to do a- . 1 Normal No Spac... Heading 1 Heading 2 Title "A Styles Paragraph Gross Margin Per Monitor $500-$417= $83 Activity 4-30 Requirement a Cost driver rate for the machine department Cost driver rate for the finishing department Answer Here/machine hour Answer Here % of direct labor cost Requirement b Direct materials cost Direct labor cost Manufacturing overhead (rounded) Total costs of Job 103 (rounded) Machining Finishing Total $9.000 $1,200 $10,200 $126 $735 $861 $450,000 $320.000 $770,000 Answer Here Answer Here Answer Here Activity 5-20 Dacian Installation Maintenance