Question

7. C-Cell Electric sells fuel cells with current year’s sales projected to be $600 million. The company is developing a new product, the Electric T roadster, and within the next few years, the company anticipates entering the car market with its Electric T. The company expects sales of Electric T to be $100 million in the year in which it enters the car sales market. Assuming an annual sales growth of 10% for both products (its fuel cells and Electric T car), create a model that accepts as input the year Electric T enters the market. Have your model compute the annual sales for the company from the current year to 2031.

Answer 1

	Assumuing The sale starts from different years
	Projected Sales
Year	Fuel Cell	Electric T	Annual Sales		Annual Sales		Annual Sales		Annual Sales		Annual Sales		Annual Sales		Annual Sales		Annual Sales		Annual Sales		Annual Sales		Annual Sales
	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions	In Millions
	$	$	$	$		$		$		$		$		$		$		$		$		$
2020	600.00		600.00		600.00		600.00		600.00		600.00		600.00		600.00		600.00		600.00		600.00		600.00
2021	660.00	100.00	760.00		660.00		660.00		660.00		660.00		660.00		660.00		660.00		660.00		660.00		660.00
2022	726.00	110.00	836.00	100.00	826.00		726.00		726.00		726.00		726.00		726.00		726.00		726.00		726.00		726.00
2023	798.60	121.00	919.60	110.00	908.60	100.00	898.60		798.60		798.60		798.60		798.60		798.60		798.60		798.60		798.60
2024	878.46	133.10	1,011.56	121.00	999.46	110.00	988.46	100.00	978.46		878.46		878.46		878.46		878.46		878.46		878.46		878.46
2025	966.31	146.41	1,112.72	133.10	1,099.41	121.00	1,087.31	110.00	1,076.31	100.00	1,066.31		966.31		966.31		966.31		966.31		966.31		966.31
2026	1,062.94	161.05	1,223.99	146.41	1,209.35	133.10	1,196.04	121.00	1,183.94	110.00	1,172.94	100.00	1,162.94		1,062.94		1,062.94		1,062.94		1,062.94		1,062.94
2027	1,169.23	177.16	1,346.39	161.05	1,330.28	146.41	1,315.64	133.10	1,302.33	121.00	1,290.23	110.00	1,279.23	100.00	1,269.23		1,169.23		1,169.23		1,169.23		1,169.23
2028	1,286.15	194.87	1,481.02	177.16	1,463.31	161.05	1,447.20	146.41	1,432.56	133.10	1,419.25	121.00	1,407.15	110.00	1,396.15	100.00	1,386.15		1,286.15		1,286.15		1,286.15
2029	1,414.77	214.36	1,629.13	194.87	1,609.64	177.16	1,591.92	161.05	1,575.82	146.41	1,561.18	133.10	1,547.87	121.00	1,535.77	110.00	1,524.77	100.00	1,514.77		1,414.77		1,414.77
2030	1,556.25	235.79	1,792.04	214.36	1,770.60	194.87	1,751.12	177.16	1,733.40	161.05	1,717.30	146.41	1,702.66	133.10	1,689.35	121.00	1,677.25	110.00	1,666.25	100.00	1,656.25		1,556.25
2031	1,711.87	259.37	1,971.24	235.79	1,947.66	214.36	1,926.23	194.87	1,906.74	177.16	1,889.03	161.05	1,872.92	146.41	1,858.28	133.10	1,844.97	121.00	1,832.87	110.00	1,821.87	100.00	1,811.87