Data table Data table Requirement 1. Calculate the manufacturing overhead allocation rate. Identify the formula and calculate the manufacturing overhead allocation rate. (Enter the result as a whole number.) Requirement 2. Compute the amount of under-or overallocated manufacturing overhead. Identify the formula and calculate the under-or manufacturing overallocated overhead. (Use parentheses or a minus sign to report overh quirement 3. Calculate the ending balances in work in process, finished goods and cost of goods sold if under- or overallocated manufacturing ovethead is as follows: (a) then off to cost of goods sold, (b) prorated based on ending balances (before proration) in each of the three accounts, (c) prorated based on the overhead allocated in 2020 in ending balances (before proration) in each of the theee accounts. Calculate the ending balances in work in process, finished goods and cost of goods sold if under-or overallocated manufacturing overthead is written off to cost of eoods sold (b) Begin by identitying the formula and calculating the adjustment to each account assuming under-of overallocated manulacturing overhead is profated based on enung balances (before proration) in each of the three accounts. (Use a minus sign or parentheses to show overallocated amounts and adjustments to be subtracted) Now calculate the ending balances in work in process, finished goods and cost of goods sold if under-of overallocated manutacturing owerhead is prorated based on ending (c) Begin by identifying the formula and calculating the adpustment to Work in-Porcess, Finistied Goods, and Cost of Goods Sold assuming under or oreraliocated manufacturing overtsead is prorated based on the the actual dred labor dolsws given in the poestion (Use a reirus sign or pareetheses to show overallocated amounts and wet-menente in the rubleaded) (c) Enter the formula and calculate the ending balances in work in process, finished goods and cost of goods sold if under-or overallocated manulachuring overhead is profated based on the overhead allocated in 2020 in the ending balances (before proraton) in each of the three accounts (Use a minus sign of parentheses to show overallocated amourits and adjustruents to be subtracted) Requirement 4. Which method would you choose? Justify your