1
answer
0
watching
461
views
amberswan397Lv1
28 Sep 2019
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 ?
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 | ? |
Collen VonLv2
28 Sep 2019