Answer the empty places 
* M * 12%D E Mon 10:28 PM Q E Excel File Edit View Insert Format .. AutoSave OFF Home Insert Draw Page Layout Formulas | BAS A x fox ? Tools Data Window Help Chapter_2_Applying_Excel_Student_Form (1) Data Review View Share Comments C D E F G H I J K L M N O P Q 1 Chapter 2: Applying Excel 3 Data 4 Markup on job cost 75% B Machine hours 9 Direct labor-hours 10 Total foved manufacturing overead cost 11 Variable manufacturing averhead per machine hour 12 Variable manufacturing overhead per direct labor-hour Department Miling Assembly 80,000 3,000 8.000 80,000 $390.000 $500,000 S2.00 $3.75 14 Cost summary for Job 407 Department Miling Assembly 16 Machine hours 17 Direct labor-hours 18 Direct materials 19 Dimet labor cost 3800 $70 20 $370 $280 21 Enter a farmu ina each of the cells rurked with a ? below 22 23 Step 1: Calculate the estimated total manufacturing overhead cost for each department Miling 25 Total faced manufacturing overeed cost 26 Variable manufacturing avemead per machine hour or direct la bar hour 27 Total machine-hours or direct labor-hours 28 Total variable manufacturing overhead 29 Total manufacturing overhead 30 31 Step 2: Calculate the predetermined overhead rate in each department Assembly 33 Total manufacturing overead 34 Tolal machine-hours or direct labor-hours 35 Predetermined overhond rata par machine-hour or direct labor-hour Assembly 37 Step 3: Calculate the amount of overhead applied from both departments to Job 407 Miling 39 Predetermined overhead rate per machine-hour or direct labor-hour 40 Machine hour or direct Inbar hours for the job 41 Manufacturing overead applied 43 Step 4: Calculate the total Job cost for Job 407 Chapter 2 Form + Microsoft Word + 100% 4009511988 * TONO A9 =), w x DEU * M * 12%D E Mon 10:28 PM Q E Excel File Edit View Insert Format ... AutoSave OFF QE S U Home Insert Draw Page Layout Formulas | B45 x v fox ? Tools Data Window Help Chapter_2_Applying_Excel_Student_Form (1) Data Review View Share Comments E F G H I J K L M N O P Q 30 31 Step 2: Calculate the predetermined overhead rate in each department 32 Assembly 33 Tolal manufacturing overhead 34 Total machine-hours or direct labor-hours 35 Predetermined overhead rate per machine-hour or direct labor-hour Assembly 37 Step 3: Calculate the amount of overhead applied from both departments to Job 407 38 Miling 39 Predetermined overhand rata per machine-hour or direct labor-hour 40 Machine-hours or direct labor hours for the job 41 Manufacturing overhead applied 43 Step 4: Calculate the total job cost for Job 407 Assembly 45 l Direct materials 46 Direct labor cast 47 Manufacturing overhead appled 48 Tolal cost of Jab 407 50 Step 5: Calculate the selling price for Job 407 51 Total cost of Job 407 S2 Markup 53 Seling price of Job 407 72 Chapter 2 Form + E E - OG + 100%
