1. Cr3at3 a chart for sales forecast data.
   1. 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. Cr3at3 a chart for gross margin forecast data.
   1. 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. Cr3at3 a chart for gross margin less R&D and capital costs calculations.
   1. Calculate gross margin less R&D and capital costs for options A and B.
   2. 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.
4. Explain any conclusions you can draw from your data visualizations.
   1. Review the charts and discuss any conclusions you can make from those data visualizations.
   2. 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.

Year 1 2 3 4 5 6 7 8 9 10 9 10 Sales Traditional (A) 183.3 190.8153 198.6387 206.7829 215.261 224.0867 233.2743 242.8385 252.7949 263.1595 273.949 11 Sales Connected (A) 3.8 4.1876 4.614735 5.768419 7.210524 9.013155 11.26644 14.08305 17.60382 22.00477 27.50597 12 Total Sales 187.1 195.0029 203.2535 212.5513 222.4715 233.0999 244.5407 256.9216 270.3987 285.1643 301.455 13 14 Gross Margin Traditional (A 27.495 28.6223 29.79581 31.01744 32.28915 33.61301 34.99114 36.42578 37.91923 39.47392 41.09235 15 Gross Margin Connected (A 0.798 0.879396 0.969094 1.211368 1.51421 1.892762 2.365953 2.957441 3.696802 4.621002 5.776253 16 Total Gross Margin 28.293 29.50169 30.7649 32.22881 33.80336 35.50577 37.35709 39.38322 41.61604 44.09493 46.86861 17 18 R&D and Capital Costs 4.1 4.133 1.16699 1.202 1.23806 1.275201 1.313458 1.352861 1.393447 1.435251 1.478308 19 20 21 Notes: Your company grows connected cars at 10.2%/year for 2 years, then grows connected cars at 25%/year. 22 Your company grows traditional cars at industry growth rate of 4.1 %/year. 23 Margin for connected cars: 21%. 24 Margin for traditional cars: 15%. 25 Numbers shown in billions. 26 There are two additional R&D costs for this option in year 0 and year 1. 27 28 29 30 31 32 33 34 40 Year 9 10 41 42 Sales Traditional (B) 183.3 190.8153 198.6387 206.7829 215.261 224.0867 233.2743 242.8385 252.7949 263.1595 273.949 43 Sales Connected (B) 3.8 4.1876 4.614735 5.085438 5.604153 6.175776 6.805706 7.499888 8.264876 9.107894 10.0369 44 Total Sales 187.1 195.0029 203.2535 211.8684 220.8652 230.2625 240.08 250.3384 261.0598 272.2674 283.9859 45 46 Gross Margin Traditional (B 27.495 28.6223 29.79581 31.01744 32.28915 33.61301 34.99114 36.42578 37.91923 39.47392 41.09235 47 Gross Margin Connected (B 0.798 0.879396 0.969094 1.067942 1.176872 1.296913 1.429198 1.574976 1.735624 1.912658 2.107749 48 Total Gross Margin 28.293 29.50169 30.7649 32.08538 33.46602 34.90992 36.42034 38.00075 39.65486 41.38658 43.2001 49 50 R&D and Capital Costs 1.1 1.133 1.16699 1.202 1.23806 1.275201 1.313458 1.352861 1.393447 1.435251 1.478308 51 52 53 Notes: Your company grows connected cars at 10.2%/year. 54 Your company grows traditional cars at industry growth rate of 4.1 %/year. 55 Margin for connected cars: 21%. 56 Margin for traditional cars: 15%. 57 R&D and Capital Costs grow at a rate of 3%. 58 59