Can you also show work for each cell. Ty!

Type your name here: Class Hour: ACCT8 203 Excel Lab 2 - Spring 2022 Points Possible: 10 To receive full credit, you must use cell references (links) to the Given Data when possible and use Excel formulas for all calculated amounts. (Do not copy and paste from the Given Data.) Save your file with your name in the file name. Submit on Canvas. In this assignment you will use Excel to compute and work with the predetermined overhead rate for a manufacturing company. Metal Products Manufacturing, Inc. Manufacturing Overhead Report For the year ended Dec. 31, 2021 Computation of Predetermined Overhead Rate (POHR): Predetermined overhead rate: per machine-hour 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 Was overhead underapplied or overapplied? 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? TYPE IN ACCOUNT TITLES. Note: "Correct" indicator only applies to the AMOUNT, not the accounts. See Chapter 3 PowerPoint slide 44. Given Data for Excel Lab 2 This company applies manufacturing overhead on the basis of machine-hours. Below is information for the most recently completed year of operations. Metal Products Manufacturing, Inc. Estimated total manufacturing overhead cost Estimated total number of machine-hours to be worked $ 200,000 50,000 Actual total manufacturing overhead cost Actual total machine-hours worked $ 211,600 52,000