[URGENT]

Your task for this optional assignment is to write a short case where you present the need to utilize Decision support systems (DSS) available from MS Excel. The case can depict a real business problem, reflect your personal experience or cover a fictional business scenario of your choosing. To score points your submission must include: A short case (up to one page of text) written by you. What-lf Analysis of the problem/s present in the case. Please note that BA is not graded partially (e.g. by item) but in its totality - you are either having all elements well developed and you score full points, or you score no points alternatively. Explanation: As you probably know from the class, DSS combine models and data to analyze semi structured problems and some unstructured problems that involve extensive user involvement. The models used there are simplified representations, or abstractions, of reality. While we have covered multiple DSS tools in class, this BA focuses on What If Analysis exclusively. In this analysis model builder must make predictions and assumptions regarding the input data, many of which are based on the assessment of uncertain futures. The results of the modelling depend on the accuracy of these assumptions, which can be highly subjective. In terms of MS Excel, What-lf Analysis is the process of changing the values in cells to see how those changes affect the outcome of formulas on the worksheet. Three kinds of What-lf Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables Scenarios and Data tables take sets of input values and determine possible results. A Data Table works with only one or two variables, but it can accept many different values for those variables. A Scenario can have multiple variables, but it can only accommodate up to 32 values. Goal Seek works differently from Scenarios and Data Tables in that it takes a result and determines possible input values that produce that result