Instructions
Please watch this Unit’s instructional videos before starting this assignment. Also, read the Getting Ready for Modeling and Simulation file. It would be helpful if you worked through the quiz once (and then take the second quiz attempt after you finish this assignment). It would also help if you completed the Unit 1 discussion first before attempting this assignment.
The assignment itself is in the attached EXCEL file. Using the data in this file, run Crystal Ball simulations to answer the two questions posed in the attached EXCEL file. Make sure to submit your Crystal Ball EXCEL file(s) (with the simulation assumption and forecast cells) along with the charts for each question? Also, in the charts, post the split view of the chart (so that the statistics of the simulation run are visible)? You will run two separate simulations (one for each of the two questions). You will also need to include in your submission very clear, complete, and logical step-by-step explanations for how you arrived at your answers to the two questions after running the simulations. You will lose points if you don’t provide these explanations (even if your simulations are run correctly and your answers are right).
Finally, in one short paragraph, comment on whether the answers (to the two questions in this individual assignment) that you got using Crystal Ball are “comparable” (meaning, roughly equal) to the ones you got in this week’s discussion activity? They will most likely not be identical – explain why that is the case.
Assignment file: Individual Assignment EXCEL file