Run the simulation, entering the following numbers at each of the four major decision points:
1) Decision 1: For Years 2008-2012
a) Pricing – Manual
b) Module Price – $0.13
c) Revenue to Process Improvement – 5%
d) Years to Advance – 5 years
2) Decision 2: For Years 2013-2017
a) Pricing – Manual
b) Module Price – $0.11
c) Revenue to Process Improvement – 5%
d) Years to Advance – 5 years
3) Decision 3: For Years 2018-2022
a) Pricing – Manual
b) Module Price – $0.09
c) Revenue to Process Improvement – 5%
d) Years to Advance – 5 years
4) Decision 4: For Years 2023-2025
a) Pricing – Manual
b) Module Price – $0.08
c) Revenue to Process Improvement – 5%
d) Years to Advance – To end
NOTE: Do not change the numbers displayed in the “Settings” tab!
At each of the four (4) decision points above, you are required to analyze the impact of your Module Price on market share and total profits. You are also required to determine how process improvements yield a reduction in unit costs. Be sure to copy tables and charts to support your analysis. You may need t use Excel to edit the charts and tables. However, do not use figures and tables as “space fillers” – use these only to support your analysis
