| "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:
Some resources:EXCEL Solver --LP video tutorialsEXCEL statistics videos Intro to computers videos WORD, windows explorer, netscape bookmarks, Excel formula techniques, Excel import techniques, ACCESS crosstabulation and Pivottables in EXCEL, Winzip and FTP for large, files EXCEL models for controlling cheating |
Onsite 1 Saturday September 11, 1:30-5:30 CCB005 |
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) with different numbers for you to practice
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.
Quiz 1: group effort-- draw the tree
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
Onsite 2 Friday October 8 & Saturday October 9 , 1:30-5:30 CCB 005 |
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
Solver video
tutorials
Transportation Model
Module C
Greedy solutions and opportunity cost
The company that wrote solver for Microsoft has a web 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
EXCEL transportation model for exploring extra plant capacity expansion
rbbexpan.pdf
description and rbbexpan.xls
beginning of model
Queuing: Infinite Source
Module D
Simulation modeling
Module F
PDF of the Macdoggie Case macdog.exe file to be used in the Exercise in class.See the EXTEND videos on the CD and at videolist. 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 3 Friday November 5 & Saturday November 6, 1:30-5:30 CCB005 |
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
Economic Run Size (ERS), Make vs. Buy & JIT
Single Period Model
Just in Time Philosophy
Project management, CPM & PERT Chapter 16
Learning Curves
Module E
Efficiency, Time & Motion Studies
Ch.10 scan
Onsite 4 Friday December 3, 1:30-5:30 CCB005 Project Reports |
| Cases/ exercises: | due | case link | Examples |
| #1 Decisions | by October 9 | Internet Case decision tree / value of imperfect information | risk
management interactive PPT,
PDF Trees:Drug test, EVSI, OSHA, |
| #2 Decisions, games, reliability & Redundancy | by November 6 | problem set | Reliability PDF Zscore tables gametheory, lousywork lowpay |
| #3 LP POM Win or Solver | by November 6 | Linear programming problem:
Problem from the Book on Manufacturing Computer Product Mix, B.29, page 771 |
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 which you purchased bundled with the textbook. solution to admiral motors questions. |
| Excel Solver Transportation | Diet problem from the Heizer Render
site.
Diet Problem for group quiz. |
The X-Y
Companyas an EXCEL Lp model compare this to Geometric
sensitivity analysis.
XYLP and diet videos. Expansion problems in Solver techhire.htm and techire.xls rbbexpan.pdf and rbbexpan.xls |
|
| #4 Simulation in EXTEND | We'll start this in class
November 5. It will be due sometime after that. |
MacDog.Exe
self extracting archive gives macdog2.mox for EXTEND MacDog exercise
MacDoggies service model Case
description
See the tutorials on the EXTEND CD and the manual for more. the file is Ext_De32.exe for the tutorials on the working CD ROM provided by agreement with Prentice-Hall related to the textbook. The Program is ExtendLT.exe |
For your interest:
The Gender Inequities Restroom Queuing/Simulation Problem. Here is an example from a paper on this issue by Ahn Tran. Combining queues may be a bad strategy in this case (unless there is much excess capacity that isn't being used) as the theory predicts increasing variance in service times exacerbates the line length. My videotutorials on the MacDog assignment. |
| Assignment Model and Priority Rules | assignment
& scheduling problem set/quiz
Classroom scheduling and reclaiming Fridays? |
Assign Boss example and an elegant compact solution in EXCEL Solver by Bill Cacheris, OLMBA, 2000 | |
| #5 Inventory model implications | by December 3 | Inventory problems | solved examples ERS
v EOQ and Make vs. Buy, FOI v ROP
single period, formulas, shortages, Z score table |
| Learning Curves & Projects | by December 3 | 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 October 4, 2004 ~~ comments and suggestions to
rbanis@jinx.umsl.edu