Using EXCEL for Decision Support Modeling
Introduction
Willy Wonka is considering starting a production line to produce fizzy lifting drinks. As Chief Oompa Loompa (COL) you have access to a wide variety of financial data to help you determine whether bringing the new production line on will be a smart investment or not.
In this exercise you will create a decision-support model.
This assignment will be a bit more of a challenge than previous assignments, but it relies on the basics you learned in the previous lessons, especially the creation of formulas.
Organization of the DSS Model
As you learned in the previous lessons, it is always good practice to separate constant data from your calculations and inputs. In this exercise, your spreadsheet will have the following major sections: constants, inputs, summary of key results, calculations (new product line) and calculations (no new product line). The spreadsheet will also have other sections that will be described in greater detail later.
Attachment:- EXCEL_DECISION.docx