Instructions Formulas Req 1 Ch3 Req 2 Ch3 Req 3 Ch3 Req 4 Ch3 Chapter 3: Applying Excel Data Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost Actual total amount of the allocation base Name: Machine-hours $300,000 75,000 machine-hours $290,000 68,000 machine-hours Enter a formula into each of the green cells marked with a ? below. Once complete use the "Copy Formula" button. Computation of the predetermined overhead rate Estimated manufacturing overhead cost Estimated total amount of the allocation base 7 machine-hours ? per machine-hour Copy Formulas Predetermined overhead rate Computation of underapplied or overapplied manufacturing overhead Actual manufacturing overhead cost Manufacturing overhead cost applied to Work in Process during the year. Predetermined overhead rate Actual total amount of the allocation base Manufacturing overhead applied Underapplied (overapplied) manufacturing overhead per machine-hour ? machine-hours