AutoSave OFF A FDC ... 3 Chapter_3_Applying_Excel_Student_Form (1) Home Insert Draw Page Layout Formulas Data Review View ? Tell me I Share Comments Arial v 10 AA al Wrap Text General Insert v Ex AP- O. Ex Delete v v Z Paste BIUV DVAv E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data B27 fx A B C D E F G H K L M N 0 Q R Chapter 3: Applying Excel Data 4 Allocation base Machine-hours 5 Estimated manufacturing overhead cost $300,000 6 Estimated total amount of the allocation base 75,000 machine-hours 7 Actual manufacturing overhead cost $290,000 Actual total amount of the allocation base 68,000 machine-hours 10 00 Enter a formula into each of the cells marked with a ? below Computation of the predetermined overhead rate Estimated manufacturing overhead cost 14 Estimated total amount of the allocation base machine-hours 15 Predetermined overhead rate ? per machine-hour 16 Computation of underapplied or overapplied manufacturing overhead 18 Actual manufacturing overhead cost ? 19 Manufacturing overhead cost applied to Work in Process during the year: 20 Predetermined overhead rate ? per machine-hour 21 Actual total amount of the allocation base machine-hours 22 Manufacturing overhead applied 2 23 Underapplied (overapplied) manufacturing overhead 24 25 26 27 28 29 30 Font 31 32 33 34 35 36 38 39 40 41 42 43 44 45 46 47 48 49 D Chapter 3 Form + Ready + 100%