1. Click Data -> What-IF Analysis. Set up a Data Table with one variable to determine how varying the gross sales growth rate from 1 percent to 7 percent affects the after-tax profit in each of the years 2019 through 2021. Show the growth rate variation in increments of 1 percent. Place the northwest corner of the data table in cell B36. After generating the table, copy it to another area of the worksheet, then add suitable title and labels and format the output area properly. Print the resulting data table into one page without frames.

2. Continue your data table exercise. Set up a Data Table with two variables to determine the effect that varying the labor growth rate from 2 percent to 8 percent in steps of 1 percent and the material growth rate from 5 percent to 9 percent in steps of 1 percent has on the after-tax profit for 2019. Place the northwest corner of the data table in cell B52. Like what we did earlier, after generating the table, copy it to another area of the worksheet and style it for a professional presentation and printing. Print the resulting data table into one page with frames.

3. Based on the output from Step 1 above, prepare a column chart to show the after-tax profit for sales growth rate of 2, 4, and 6 percent only, including suitable titles and legends. Print the resulting chart into one page.

4. Based on the output from Step 2 above, prepare a line chart with labor growth rate on the x-axis and with suitable titles and legends. Print the resulting chart into one page.

5. Based on information in Column F (total figures), create a pie chart to provide analytical data such as breakdown of costs and expenses that will be useful for management decision making. Again, provide suitable titles and legends at the professional level. Make sure that the pie chart you create will make sense to corporate management. (You will need to design your own pie chart, no further information will be provided as for how this pie chart is going to look like.) Print the resulting chart into one page

Data to use: