| "When you try to pull just one thing out of the Universe, you find it attached to everything else." --John Muir |
| Special notes and announcements go here:
The tutorial for EXTEND simulation models is run directly from the
working CD ROM by executing the file Ext_De32.exe which is right in the
Extend folder. The file to run the modeling program directly is ExtendLT.exe
The LP problem is a problem from the book on hospital expansion. See the table at the bottom of the page. |
Onsite 1 Saturday September 8, 1:30-5:30 SSB 134 |
Week 1 Introduction & Overview of tools
Making Quality Decisions
Decision models: risk avoidance vs. risk management
module A
Interactive Powerpoint show on risk management
(660K)
Decision trees and value of information
PDF on EVSI
(shift click or right click to download pdf's instead of viewing them in
acrobat add-in)
Decision Tree Problem RVFC and value of imperfect
information.
Joint events-reliability and redundancy
Chapter 17
Facilities /Capacity and Location Planning:
Cost Structures
Chapter 7
Spreadsheet Budgeting (NIB)
budget.xls
"Location" Break even Analysis
Chapter 8
Factor rating
jobrate.XLS a spreadsheet for
factor-rating decisions
Onsite 2 Friday October 12, 1:30-5:30 SSB 134 |
Optimization models
Linear Optimization Models Geometric
and using POM-WIN Module B
Computer Solutions using Excel Solver
p.759 (6th Edn) p. 724 (5th Edn), packet
The X-Y Companyas an EXCEL
Lp model
Onsite 3 Saturday October 13, 1:30-5:30 SSB 134 |
Transportation Model
Module C
Greedy solutions and opportunity cost
The company that wrote solver for Microsoft has aweb page at http://www.frontsys.com
EXCEL spreadsheet of a transportation model generic
EXCEL Transportation Model for the technician travel problem in class
Description
of Technician travel model to explore shadow prices of hiring
more technicians and spreadsheet Solver
Model for Exercise 4A
EXCEL transportation model for exploring extra plant capacity expansion
rbbexpan.pdf
description and rbbexpan.xls
beginning of model
macdog.exe file to be
used in the assignment This is a self- extracting archive, so execute it
and it will extract in the same directory to give you macdog2.mox which
you can then use with the EXTEND program to do the assignment. It's small
(20 K archive, 35 K extracted) so you can save it and extract it anyplace,
even on a floppy disk.
Onsite 4 Friday November 9, 1:30-5:30 SSB 134 |
Queuing: Infinite Source
Module D
Simulation modeling
Module F
Process Priority Rules-Excel/ POM-Win
Scheduling & Inventory Management
Inventory Formulas, PDF
Aggregate Planning - scheduling
Chapter 13
EOQ Model & Quantity discounts
Chapter 12
Service Level, Safety Stock & shortages; Reorder Point vs. Fixed Interval
Onsite 5 Saturday November 10, 1:30-5:30 SSB 134 (begin Project Reports) |
Week 14 Economic Run Size (ERS), Make vs. Buy &
JIT
Single Period Model
Just in Time Philosophy
Project management, CPM & PERT
Chapter 16
Week 16 Learning
Curves
Module E
Efficiency, Time & Motion Studies
Ch.10 scan
Onsite 6 Friday December 7, 1:30-5:30 SSB 134 Finish Project Reports |
| Cases/ exercises: | due | case link | Examples |
| #1 Decisions | by October 12 | Internet Case decision tree / value of imperfect information | risk
management interactive PPT,
gametheory, lousywork lowpay |
| #2 Decisions, games, reliability & Redundancy | by October 12 | problem set | PDF Trees:Drug
test, EVSI, OSHA,
Reliability PDF Zscore tables |
| #3 LP POM Win or Solver | by November 9 | Linear programming problem:
Problem from the Book on hospital expansion |
LP
Geometric, XY-LP in solver,
Admiral Motors.pdf, Admiral.exe compressed file for LP in POM-Win, self extracts to give adm.lin to run in POM-WIN |
| #4 Excel Solver Transportation | by November 9 | expansion problems in Solver
techhire.htm and techire.xls extra Credit: rbbexpan.pdf and rbbexpan.xls |
The X-Y Companyas an EXCEL Lp model compare this to Geometric sensitivity analysis |
| #5 Simple Simulation in EXTEND | by November 9 | MacDoggies service model
Case/exercise description |
MacDog.Exe self extracting archive gives macdog2.mox for EXTEND MacDog exercise See the tutorials on the book CD and the manual for more. the file for the tutorials is Ext_De32.exe on the working CD ROM |
| #6 Assignment Model and Priority Rules | by November 19 | Assignment and scheduling sequence problems assign.doc | Assign Boss example and an elegant compact solution in EXCEL Solver by Bill Cacheris, OLMBA, 2000 |
| #7 Inventory model implications | by November 26 | Inventory problems | solved examples ERS
v EOQ and Make vs. Buy, FOI v ROP
single period, formulas, shortages, Z score table |
| #8 Learning Curves & Projects | by December 7 | lernproj.doc a few short problems | learn.pdf
lerncurv.pdf |
Return
to Bud's Page
Go to UM-St. Louis Home Page
Go to UM-St. Louis School of Business Page
last modified September 16, 2001 ~~ comments and suggestions
to rbanis@jinx.umsl.edu