Please assist with step$-$by$-$step formulas

Year 10 II 12 13 Year S Gross Profit - Year I Gross Profit 16 reem, moute fm S. (Ramd Region East East East M idwest M idwest Midwest Midwest Midwest West Wes t Wes t Wes t "Vest Net Sales 250,000 350,000 4W000 870,2so 840, ooo 430,000 3cn,ooo 215,000 180,000 m ooo 510,000 325,000 440, ooo Cost of Goods Sold 322,om 324.4m 144,050 265, om 320, om 175, om Complete this question bv entering your answers in the tabs below. 2 2 Gross pmfi t fu year Rea 2 Percent Che nge Enter gross for (a) Year and (b) Year S. Qu esti.% 2 Gross Req Gross Req Percent profit for Year Change Question 2 2 Gross profit for Yer Question 3 Rea 2 Percent Change Year Year S Question Question 2 Question 3 Compute the percentage change in gross profit from Year 1 to Year 5. (Round Percent Change value to 2 decimals.) Qu 2 Year I Gross Profit Reg 2 Percent Change Reg pmfit Reg 2 (a) For each region, enter gross for Year 1. (b) Which region has the best gross profit in Year 17 Whid has the gross Year ? 2 Ch. nge (a) Yeu S. (b) Which the in S? nas 50 Req 2 Gross Reg I Gross Req I Pe rcent Profit for Year Change Req 2 Gross 2 Percent Profit for Year Chan g e Question I Question 2 Req 3 Question 3 dimals-) 5 (a) ch reem, margin for Year 1. answers to 2 "'ich in 1 Enter the gross margin ratio for (a) Year 1 and (b) Year 5. (Round your answers to 2 decimals.) Year Rea 2 (b) Which the best OroSS in Year (a) (b) Year 1 Year 5 1? (Rou (a) For each region, gros mu$n ratio for Year (b) Which has the test grxs muon Year S? (Rotnd Wbch h Voss rabo S'