You are working in a company as procurement consultant and your role is to perform procurement forecasting of materials. Following are the indices of materials for next eight quarters plus base price as off Dec 2022 also mentioned in table below: Material Dec 2022 Q1 2023 Q2 2023 Q3 2023 Q4 2023 Q1 2024 Q2 2024 Q3 2024 Q4 2024 Glass - DM1 $ 1150/Ton 106 108 109 110 111 113 115 117 Metal - DM2 $ 1990/Ton 99 98 99 100 101 103 105 107 Plastics - DM3 $ 1380/Ton 102 104 106 107 108 109 110 112 Break up of COGS is as follows for a product using glass, metal and plastic all in material. Dec 2021: Net Sales - COGS = Gross Profit ; NS - (DM1+DM2+DM3 + DL + FOH) = GP Net Sales = 6000$ , DM 1 = 0.6 ton usage, DM 2 = 0.85 ton usage, DM 3 = 0.9 ton usage DL = $ 525, FOH = $ 625, GP = $ 1760 a) In order to maintain same profitability in Q1 2023, Q3 2023, Q2 2024 & Q4 2024 what price increase needs to be taken during these periods as per price forecasting modeling. b) What would be the price increase to be taken in same periods if there would be additional inflation of 15% in Labor cost and 18% in FOH cost then what would be price increase to be taken