1. Create a chart for sales forecast data. a. Graph sales forecast data for total sales for options A and B on a three-dimensional stacked column chart. . Each column should show traditional sales on the bottom and connected sales on the top. . Both options may appear on the same three-dimensional chart, or you can make a separate chart for each option. 2. Create a chart for gross margin forecast data. a. Graph gross margin forecast data for total sales for options A and B on a three-dimensional stacked column chart. . Each column should show traditional sales on the bottom and connected sales on the top. . Both options may appear on the same three dimensional chart, or you can make a separate chart for each option 3. Create a chart for gross margin less R&D and capitaboosts calculations. a. Calculate gross margin less R&D and capital costs for options A and B. b. Graph total gross margin less R&D and capitalcosts forecasts to compare options A and B on a line chart. . Both options should appear on the same chart 4. Explain any conclusions you can draw from your data visualizations a, Review the charts and discuss any conclusions you can make from those data visualization b. Explain whether option A or option B Will provide your company the most inandallbenefu You winold prepares your data visualizations to justify your explanation and conclusions Guidelines for Submission Submit an Excel document with all your charts . Submit a y- to 1-page Word document with 12-point James acing and one ion margins, is your include references, they should be cited according to APA style Co Shapir