Excel File Edit View Insert Format Tools Data Window Help 59% Sun 8:11 PM Q DE AutoSave OFF Chapter_2_Applying_Excel_Student_Form (2) Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments v 10 V AA Number Conditional Formatting Insert v Aria = Format as Table Ex Delete Paste BIU BY OvAv v % 9 Sort & Find & Analyze Sensitivity Create and Share Cell Styles v Format v ) v Filter Select Data Adobe PDF D53 4 X V fx =D51+D52 AA AB AC AD AE AF AG D Department Milling Assembly Machine-hours 3,000 9 Direct labor-hours 8,000 80,000 10 Total fixed manufacturing overhead cost $390,000 $500,000 11 Variable manufacturing overhead per machine-hour $2.00 12 Variable manufacturing overhead per direct labor-hour $3.75 4 Cost summary for Job 407 Department 15 Milling Assembly to Machine-hours 90 17 Direct labor-hou 20 18 Direct $800 $370 Direct labor cost $70 $280 21 Enter a formula into each of the cells marked with a ? below 3 Step 1: Calculate the estimated total ma ing overhead cost for each department Milling Assembly 25 Total fixed manufacturing overhead cost $390,000 $500,000 26 Vanable manufacturing overhead per machine-hour or direct labor-hour $2.00 $3.75 27 Total machine-hours or direct labor-hours 60,000 80 000 28 Total vanable manufacturing overhead $510, 090 $300,000 29 Total manufacturing overhead 31 Step 2: Calculate the predetermined overhead rate in each department Milling Total manufacturing overhead $546 000 Assembly 34 Total machine-hours or direct labor-hours 60 000 80.000 35 Predetermined overhead rate per machine- er machine-hour or direct labor-hour $8 50 810 00 7 Step 3: Calculate the amount of overhead applied from both departments to Job 407 Milling Assembly 39 Predetermined overhead rate per machine-hour or direct labor-hour $8.50 $10.00 40 Machine-hours or direct labor-hours for the job 90 20 41 Manufacturing overhead applied $765.00 $200.00 Step 4: Calculate the total job cost for Job 407 Milling Assembly Total 5 Direct materials $800.00 1,170.00 46 Direct labor cost $70.00 $280.00 $350.00 47 Manufacturing overhead applied $765.00 $200.00 $965.00 48 Total cost of Job 407 50 Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 2,485.00 52 Markup 3 Selling price of Job 407 Chapter 2 Form + Ready - + 66% NOV 7 W X