. A1xfe Chapter 3: Applying Excel 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost Machine-hours 300,000 $290,000 6 Estimated total amount of the allocation base 7 Actual manufacturing overhead cost 8 Actual total amount of the allocation base 75,000 machine-hours 68,000 machine-hours 10 Enter a formula into each of the cells marked with a ? below 12 Computation of the predetermined overhead rate 13 Estimated manufacturing overhead cost 14 Estimated total amount of the alocation base 15 Predetermined overhead rate 16 ? machine-hours ? per machine-hour 17 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 21 ? per machine-hour machine-hours Predetemined overhead rate Actual total amount of the allocation base Manufacturing overhead applied ? 23 Underappled (overapplied) manufacturting overhead 24 25 26 27 28 29 30