1- Build a decision support system (DSS) for a small

1- Build a decision support system (DSS) for a small investor to manage an investment portfolio of 20 to 30 stocks. The total money allocated is 100,000. Begin by looking at Yahoo Finance website to select your stocks.

OR

2- Instead portfolio of stocks you may develop a DSS to select a house from a list of 20.

3- You may use any resource: Microsoft website, or Youtube, to refresh your knowledge of excel

4- Be mindful that the assignment is to “build a decision support system (DSS) using Excel” NOT just to create a LIST only.

5- Spreadsheets are dynamic tables in which variables are connected via formulas and cell addresses. DSS uses what if analysis and logic for example, what to do when a stock value after a week drops 20%. Or what additional income I need to buy a house above $ 500,000. —

6- In this course, we assume that you have basic skills in EXCEL. In your DSS, you have to use formulas for calculations such as addition, %, multiplication, etc,.

7- It is up to you to decide on tables structure (variables to be included), on selection Criteria (what variables to use to select stocks, or houses) and Parameters (what variables to monitor), and Scenarios (2-3 portfolios)

It would be helpful for someone to do a template or maybe draw it out to know the items needed. Also opened to share a doc to get a step-by-step.