TABLEB ASSUME THAT MNO CORP HAS TWO PRODUCTS 1 2 3 TABLE C TABLE D TARI F F (P) NOTE: 2022 PERCENTAGE OF COST WAS DIVIDED AS FOUOW: Materials: 55% Labor: 30% Overhead: 15% For CoGs Growth Analysis Only 1) Calculate & fill in the missing numbers (color gray cells); And calculate the COGS growth rate (from Table E (2). 2) What is the COGS growth rate projection for 2023? Is the COGS growth rate justified given the Inflation rate? 3) Can the 2022 Supply-Chain problems affect the COGS growth projection for 2023? Why or Why Not? Explain! 4) Review the three areas' cost of production (Materials, Labor, \& Overhead) projection for 2023. Are numbers justified? For Labor? 5) is the 2023 Labor projection decline, justified? What could explain the decline? 6) Assume (for this question only) that the firm took on a substantial increase in Long-Term debt in 2022. Can it explain the Labor decline for 2023 projection? Explaint 7) Assume the Firm invested substantial amount of funds into Plants, Equipment, \& Robotics (Fixed Cost), is the Firm leveragi 8) Assuming factory labor cost is reduced & fixed cost increased, what effect may these changes have on profitability & stock TABLEB ASSUME THAT MNO CORP HAS TWO PRODUCTS 1 2 3 TABLE C TABLE D TARI F F (P) NOTE: 2022 PERCENTAGE OF COST WAS DIVIDED AS FOUOW: Materials: 55% Labor: 30% Overhead: 15% For CoGs Growth Analysis Only 1) Calculate & fill in the missing numbers (color gray cells); And calculate the COGS growth rate (from Table E (2). 2) What is the COGS growth rate projection for 2023? Is the COGS growth rate justified given the Inflation rate? 3) Can the 2022 Supply-Chain problems affect the COGS growth projection for 2023? Why or Why Not? Explain! 4) Review the three areas' cost of production (Materials, Labor, \& Overhead) projection for 2023. Are numbers justified? For Labor? 5) is the 2023 Labor projection decline, justified? What could explain the decline? 6) Assume (for this question only) that the firm took on a substantial increase in Long-Term debt in 2022. Can it explain the Labor decline for 2023 projection? Explaint 7) Assume the Firm invested substantial amount of funds into Plants, Equipment, \& Robotics (Fixed Cost), is the Firm leveragi 8) Assuming factory labor cost is reduced & fixed cost increased, what effect may these changes have on profitability & stock