I need help filling out the excel sheet, where the question marks are.

Data Markup on job cost 75% Department Assemb Milling ly 60,000 3,000 8,000 80,000 $390,00 $500,00 Machine-hours Direct labor-hours Total fixed manufacturing overhead cost Variable manufacturing overhead per machine-hour Variable manufacturing overhead per direct labor-hour $2.00 $3.75 Cost summary for Job 407 Machine-hours Direct labor-hours Direct materials Direct labor cost Department Assemb Milling ly 90 4 5 20 $800 $370 $70 $280 Enter a formula into each of the cells marked with a ? below Step 1: Calculate the estimated total manufacturing overhead cost for each department Milling Assemb ly ? ? ? Total fixed manufacturing overhead ? cost Variable manufacturing overhead per ? machine-hour or direct labor-hour Total machine-hours or direct labor- ? hours Total variable manufacturing overhead ? Total manufacturing overhead ? ? ? ? Step 2: Calculate the predetermined overhead rate in each department Milling Assemb ? ? ? ? Total manufacturing overhead Total machine-hours or direct labor- hours Predetermined overhead rate per machine-hour or direct labor-hour ? ? Step 3: Calculate the amount of overhead applied from both departments to Job 407 Milling Predetermined overhead rate per ? machine-hour or direct labor-hour Machine-hours or direct labor-hours for ? the job Manufacturing overhead applied ? Assemb ly ? ? ? Step 4: Calculate the total job cost for Job 407 Milling Assemb Total EXHIBIT 2-5 Dickson Company: An Example Using Multiple Predetermined Overhead Rates Step 1 Calculate the estimated total manufacturing overhead cost for each department Milling Department Overhead Cost (Y) Assembly Department Overhead Cost/Y) = $390.000 + ($2.00 per MH 60,000 MHs) = $500,000 + ($3.75 per DLH80.000 DLHs) = $390,000+ $120.000 = $500,000 $300,000 = $510,000 = $800,000 Step 2. Calculate the predetermined overhead rate in each department Milting Department Overhead Rate Assembly Department Overhead Rate $510,000 $800,000 60,000 machine-hours 80,000 direct labor-hours $8.50 per machine-hour $10.00 per direct labor-hour Step 3. Calculate the amount of overhead applied from both departments to Job 407 Milling Department. Overhead Applied to Job 407 Assembly Department. Overhead Applied to Job 407 =$8.50 per MH 90 MHs =$10.00 per DLH 20 DLHs = $765 = $200 Step 4: Calculate the total job cost for Job 407 Milling Assembly Total Direct materials $800 $370 $ 1170 Direct labor $70 $280 350 Manufacturing overhead applied $765 $200 965 Total cost of Job 407 $2.485 Step 5: Calculate the selling price for Job 407 Total cost of Job 407 $2.485.00 Markup ($2.485 75%) 186375 Selling price of Job 407 $4,34875