1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base sEstimated manufacturing overhead cost 6Estimated total amount of the allocation base 7 Actual manufacturing overhead cost 8 Actual total amount of the allocation base Machine-hours $300,000 75,000 machine-hours $290,000 68,000 machine-hours 10 Enter a formula into each of the cells marked with a ? below 11 12 Computation of the predetermined overhead rate 13 Estimated manufacturing overhead cost 14 Estimated total amount of the allocation base 15 Predetermined overhead rate machine-hours ?per machine-hour 16 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 ?per machine-hour machine-hours Predetemined overhead rate 20 Actual total amount of the allocation base Manufacturing overhead applied 23 Underapplied (overapplied) manufacturing overhead 21 22 24 Chapter 3 Form Filed in Chapter 3 Form Chapter 3 Formula