Scm 16: Supply Chain Modeling & Optimization Session Introduction to Modeling & ms excel I january 23, 2023

 Page 1/3 Date 03.04.2023 Size 61.1 Kb. #61031
1   2   3
02 Jan 23 Class SCM 416 (Modeling 1)

SCM 416: Supply Chain Modeling
& Optimization
Session 2
Introduction to Modeling
& MS Excel - I
January 23, 2023
• Intro to Modeling
• Modeling Basics: Example 1
• Modeling Basics: Example 2
• Summary

Session Outline

Basic Spreadsheet Modeling: Concepts & Best Practices (1 of 2)

• Most mathematical models, including spreadsheet models, involve inputs, decision variables, and outputs.
• The inputs have given fixed values, at least for the purposes of the model.
• The decision variables are those a decision maker controls.
• The outputs are the ultimate values of interest; they are determined by the inputs and the decision variables.
• Spreadsheet modeling is the process of entering the inputs and decision variables into a spreadsheet and then relating them appropriately, by means of formulas, to obtain the outputs.

Concepts & Best Practices (2 of 2)

• Analyze the outputs to yield insights.
• Sensitivity analysis
• Optimization
• Charts
• Clear, logical layout
• Multiple worksheets (or tabs) to separate different parts
• Heading, coloring, font size, italics
• Use of cell names and/or comments
• Much of the power of spreadsheets derives from their flexibility.
• Intro to Modeling
• Modeling Basics: Example 1
• Modeling Basics: Example 2
• Summary

Session Outline
Example 1: Breakeven Analysis