Session 23

Decision Support Systems 150:127 -- D. Power

Today's Agenda -- Tuesday, April 3, 2007

• Who are the major vendors of Excel add-in programs for building model-driven DSS?
• Discuss Ch. 10. Building Model-driven DSS
1. Suppose you have several factories and want to find the best locations to manufacture different products to meet demand in nearby cities. You want to maximize profits and minimize shipping costs. What kind of model would you probably want for a special decision study? Would you ever need a model-driven DSS in this situation?
2. How does sensitivity analysis differ from "what if?" analysis? How would you implement each type of analysis using MS Excel?
3. What is a data table? Data tables are part of a suite of commands sometimes called what-if analysis tools. A data table is a range of cells that shows how changing certain values in your formulas affects the results of the formulas. Check http://faculty.fuqua.duke.edu/~pecklund/ExcelReview/ExcelReview.htm

To Do and Upcoming

• Complete Excel Tutorial 5 "Trouble Shooting Formulas", on p. 250 complete step 11 printing Fig. 5-15, then print the formula sheet (with row/col headings and gridlines) for Fig. 5-15. Print formula sheet (with row/col headings and gridlines) for Fig. 5-23 p. 258. On p. 264 print formulas for both worksheets (with row/col headings and gridlines). On p. 271 step 6 with Atty. On p. 275 step 5. On p. 279 formula sheet (with row/col headings and gridlines) for fig. 5-47. On p. 291 complete step 7. Print and staple in the order listed!! (5 pts.)