Reference no: EM133284471
Create a chart for sales forecast data.
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.
Create a chart for gross margin forecast data.
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.
Create a chart for gross margin less R&D and capital costs calculations.
Calculate gross margin less R&D and capital costs for options A and B.
Graph total gross margin less R&D and capital costs forecasts to compare options A and B on a line chart.
Both options should appear on the same chart.
Explain any conclusions you can draw from your data visualizations.
Review the charts and discuss any conclusions you can make from those data visualizations.
Explain whether option A or option B will provide your company the most financial benefit. You should reference your data visualizations to justify your explanation and conclusions.