Need help with c and dThanks!

a. Complete the table in the Student Work Area by inputting formulas to compute the percentage of net sales for each item on the income statements for each of the five years. b. Prepare a clustered column chart by year to visualize each of the four subtotal percentages computed in part a. Include a descriptive chart title, axes labels, properly formatted axes, and a legend. Add a trend line for each expense percentage. c. What does the chart tell you about the gross profit percentage? What trends do you see in operating and other expenses and in members' dividends? What do you think may be the cause? What costs seem to have contributed most to the decline in net income? d. If REl shifts its work model to allow non-retail employees to work up to five days a week from hom what effects do you think this model will have on each of the expenses? How will the effects on expenses affect the company's net income? b. Chart for part b REI's Income Statement Items by Year 120.00% 100.00% 80.00% 60.00% 40.00% 20.00% 0.00% 20.00% 2016 2017 2018 2019 2020 Gross protit Income (loss) before taxes and dividends Income before members' dividends Net income Linear (Cost of goods sold) Linear (Operating and other expenses) Linear flncome tax provision (benefit). Linear (Wernber's dividends) a. Complete the table in the Student Work Area by inputting formulas to compute the percentage of net sales for each item on the income statements for each of the five years. b. Prepare a clustered column chart by year to visualize each of the four subtotal percentages computed in part a. Include a descriptive chart title, axes labels, properly formatted axes, and a legend. Add a trend line for each expense percentage. c. What does the chart tell you about the gross profit percentage? What trends do you see in operating and other expenses and in members' dividends? What do you think may be the cause? What costs seem to have contributed most to the decline in net income? d. If REl shifts its work model to allow non-retail employees to work up to five days a week from hom what effects do you think this model will have on each of the expenses? How will the effects on expenses affect the company's net income? b. Chart for part b REI's Income Statement Items by Year 120.00% 100.00% 80.00% 60.00% 40.00% 20.00% 0.00% 20.00% 2016 2017 2018 2019 2020 Gross protit Income (loss) before taxes and dividends Income before members' dividends Net income Linear (Cost of goods sold) Linear (Operating and other expenses) Linear flncome tax provision (benefit). Linear (Wernber's dividends)