Dss modeling
Download
1 / 17

DSS Modeling - PowerPoint PPT Presentation


  • 216 Views
  • Uploaded on

DSS Modeling. Current trends Multidimensional analysis (modeling) A modeling method that involves data analysis in several dimensions Influence diagram

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' DSS Modeling' - kellan


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Dss modeling
DSS Modeling

  • Current trends

    • Multidimensional analysis (modeling)

      A modeling method that involves data analysis in several dimensions

    • Influence diagram

      A diagram that shows the various types of variables in a problem (e.g., decision, independent, result) and how they are related to each other


Static and dynamic models
Static and Dynamic Models

  • Static models

    Models that describe a single interval of a situation

  • Dynamic models

    Models whose input data are changed over time (e.g., a five-year profit or loss projection)


Mss modeling with spreadsheets
MSS Modeling with Spreadsheets

  • Models can be developed and implemented in a variety of programming languages and systems

  • The spreadsheet is clearly the most popular end-user modeling tool because it incorporates many powerful financial, statistical, mathematical, and other functions


Mss modeling with spreadsheets1
MSS Modeling with Spreadsheets


Mss modeling with spreadsheets2
MSS Modeling with Spreadsheets

  • Other important spreadsheet features include what-if analysis, goal seeking, trial and error, optimization , data management, and programmability

  • Most spreadsheet packages provide fairly seamless integration because they read and write common file structures and easily interface with databases and other tools

  • Static or dynamic models can be built in a spreadsheet


Mss modeling with spreadsheets3
MSS Modeling with Spreadsheets


Mathematical programming optimization
Mathematical Programming Optimization


Mathematical programming optimization1
Mathematical Programming Optimization


Multiple goals sensitivity analysis what if analysis and goal seeking
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking

  • Multiple goals

    Refers to a decision situation in which alternatives are evaluated with several, sometimes conflicting, goals

  • Sensitivity analysis

    A study of the effect of a change in one or more input variables on a proposed solution


Multiple goals sensitivity analysis what if analysis and goal seeking1
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking

  • Sensitivity analysis tests relationships such as:

    • The impact of changes in external (uncontrollable) variables and parameters on the outcome variable(s)

    • The impact of changes in decision variables on the outcome variable(s)

    • The effect of uncertainty in estimating external variables

    • The effects of different dependent interactions among variables

    • The robustness of decisions under changing conditions


Multiple goals sensitivity analysis what if analysis and goal seeking2
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking

  • Sensitivity analyses are used for:

    • Revising models to eliminate too-large sensitivities

    • Adding details about sensitive variables or scenarios

    • Obtaining better estimates of sensitive external variables

    • Altering a real-world system to reduce actual sensitivities

    • Accepting and using the sensitive (and hence vulnerable) real world, leading to the continuous and close monitoring of actual results

  • The two types of sensitivity analyses are automatic and trial-and-error


Multiple goals sensitivity analysis what if analysis and goal seeking3
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking

  • Automatic sensitivity analysis

    • Automatic sensitivity analysis is performed in standard quantitative model implementations such as LP

  • Trial-and-error sensitivity analysis

    • The impact of changes in any variable, or in several variables, can be determined through a simple trial-and-error approach


Multiple goals sensitivity analysis what if analysis and goal seeking4
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking

  • What-If Analysis

    A process that involves asking a computer what the effect of changing some of the input data or parameters would be


Multiple goals sensitivity analysis what if analysis and goal seeking5
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking


Multiple goals sensitivity analysis what if analysis and goal seeking6
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking

  • Goal seeking

    Asking a computer what values certain variables must have in order to attain desired goals


Multiple goals sensitivity analysis what if analysis and goal seeking7
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking


Multiple goals sensitivity analysis what if analysis and goal seeking8
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking

  • Computing a break-even point by using goal seeking

    • Involves determining the value of the decision variables that generate zero profit


ad