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



Download 61.1 Kb.
Page3/3
Date03.04.2023
Size61.1 Kb.
#61031
1   2   3
02 Jan 23 Class SCM 416 (Modeling 1)
Quantity Ordered

Unit Price (for all units)

1 - 999

$24.00

1000 - 1999

$23.00

2000 - 2999

$22.25

3000 - 3999

$21.75

4000 +

$21.30

Example 2 (cont.)
Suppose that the demand can take the following values with given probabilities.

Demand

500

1000

1500

2000

2500

3000

3500

4000

4500

Probability

0.025

0.05

0.15

0.25

0.25

0.15

0.07

0.04

0.015

How many copies of the hardcover book should BN order from the publisher?
Example 2 Takeaways:
Modeling & Excel Features
  • Model readability
  • VLOOKUP
  • Two-way DATATABLE
  • SUMPRODUCT
  • Intro to Modeling
  • Modeling Basics: Example 1
  • Modeling Basics: Example 2
  • Summary

Session Outline
Summary & Key Takeaways

Next Class: Modeling - II
  • Example 2 wrap-up
  • Readings (see “Reading(s) by Date” folder)
      • Chapter 2, WA: read p.39-53

Download 61.1 Kb.

Share with your friends:
1   2   3




The database is protected by copyright ©ininet.org 2024
send message

    Main page