MUST SHOW/include CELL REFERENCES for each box. thank you. do not just write answer.

6 Anacortes Manufacturing, Inc. Manufacturing Overhead Report For the year ended Dec. 31, 2019 9 0 Computation of Predetermined Overhead Rate (POHR): Predetermined overhead rate: per machine-hour 2 3 4 5 5 Computation of Underapplied or Overapplied Manufacturing Overhead: Actual total manufacturing overhead cost: Total manufacturing overhead applied to Work in Process during the year: Amount of underapplied (or overapplied) manufacturing overhead I MI 1 2. Was overhead underapplied or overapplied? m Lab 2 Given Data 6 Total manufacturing overhead applied to Work in Process during the year: 7 9 Amount of underapplied (or overapplied) manufacturing overhead 0 1 2 Was overhead underapplied or overapplied? 4 5 Assume the company closes any balance in the Manufacturing Overhead account to Cost of Goods Sold. What journal entry should be made to close the Manufacturing Overhead account? Note: "Correct" indicator only applies to the AMOUNT, not the accounts. 6 CO 9 0 Points Possible: 10 To receive full credit, you must use cell references (linking) to the Given Data when possible and use Excel formulas for all calculated amounts. (Do not copy and paste from the Given Data.) In this lab you will use Excel to compute and work with the predetermined overhead rate for 1 a manufacturing company. 5 Anacortes Manufacturing, Inc. Manufacturing Overhead Report 7 For the year ended Dec. 31, 2019 6 8 19 20 Computation of Predetermined Overhead Rate (POHR): Predetermined overhead rate: 21 22 per machine-hour 23 25 26 27 Computation of Underapplied or Overapplied Manufacturing Overhead: Actual total manufacturing overhead cost: Total manufacturing overhead applied to Work in Process during the year: Lab 2 Given Data This company applies manufacturing overhead on the basis of machine-hours. Below is information for the most recently completed year of operations. Anacortes Manufacturing, Inc. Estimated total manufacturing overhead cost Estimated total amount of allocation base $ 525,000 75,000 machine-hours Actual total manufacturing overhead cost Actual total machine-hours $ 468,000 72,000