Downloadthe Applying Excel form and enter formulas in all cells thatcontain question marks. | | For example, in cell B13 enter the formula "= B5". | After entering formulas in all of the cells that containedquestion marks, verify that the dollar amounts match the example inthe text. | | Check your worksheet by changing the estimated total amount ofthe allocation base in the Data area to 50,000 machine-hours,keeping all of the other data the same as in the original example.If your worksheet is operating properly, the predetermined overheadrate should now be $6.00 per machine-hour. If you do not get thisanswer, find the errors in your worksheet and correct them. | Chapter 3: Applying Excel | | |
| | |
Data | | |
Allocation base | Machine-hours |
Estimated manufacturing overhead cost | $300,000 | |
Estimated total amount of the allocationbase | 75,000 | machine-hours |
Actual manufacturing overhead cost | $290,000 | |
Actual total amount of the allocationbase | 68,000 | machine-hours |
| | |
Enter a formula into each of the cellsmarked with a ? below | | |
| | |
Computation of the predeterminedoverhead rate | | |
Estimated manufacturing overhead cost | ? | |
Estimated total amount of the allocationbase | ? | machine-hours |
Predetermined overhead rate | ? | per machine-hour |
| | |
Computation of underapplied oroverapplied manufacturing overhead | | |
Actual manufacturing overhead cost | ? | |
Manufacturing overhead cost applied toWork in Process during the year: | | |
Predetermined overhead rate | ? | per machine-hour |
Actual total amount of the allocationbase | ? | machine-hours |
Manufacturing overhead applied | ? | |
Underapplied (overapplied) manufacturingoverhead | ? | |