| Chapter 3: Applying Excel |
| Data |
| Allocation base | Machine-hours |
| Estimated manufacturing overhead cost | $300,000 |
| Estimated total amount of the allocation base | 75,000 | machine-hours |
| Actual manufacturing overhead cost | $290,000 |
| Actual total amount of the allocation base | 68,000 | machine-hours |
| Enter a formula into each of the cells marked with a ? below |
| Computation of the predetermined overhead rate |
| Estimated manufacturing overhead cost | ? |
| Estimated total amount of the allocation base | ? | machine-hours |
| Predetermined overhead rate | ? | per machine-hour |
| 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 | ? | per machine-hour |
| Actual total amount of the allocation base | ? | machine-hours |
| Manufacturing overhead applied | ? |
| Underapplied (overapplied) manufacturing overhead | ? |