Selected Overheads BA3320:
Forgetting curve
Ode to Procrastination
Decision Tools & Risk Management
Textbook HeizerRender Quantitative
Modules A
Risk Management Powerpoint show
tools/macro/security must be medium or low and macros must be enabled
to work)
another version has a different set
of numbers than the one used in class, so it might be good for practice.
Textbook
Textbook components and redundancy p.513
Textbook: SPC and TQM Ch 6 Supplement
6 p 174
Linear Programming
Textbook Linear
Programming module B Transportation
Module C
(Note you don't have to know how to solve these manually, but I'll talk
a little about that for historical interest)

Tport NWC & OCM pdf

XY Company

Formulation and Interpretations of LP output
Tech Travel
description and tables
for manual solution
EXCEL Technician
Transportation Model
Modified
EXCEL Technician travel model to explore shadow prices of hiring more
technicians
EXCEL transportation model for exploring
extra plant capacity expansion
description
of the diet project.
Videos on the diet LP Project videos
on the diet problem
See the recording of the Centra session on screen captures and putting
all of this on one page , 101606pt2
Microscheduling:
Job Matching Assignment MethodExcel
Chapter 15
Assigning jobsan example, as a PDF
file, (you need the free addin, Adobe Acrobat for this)
and an EXCEL Solver solution by Bill
Cacheris of the MBA online program
What does it Mean?
Process Priority RulesExcel/ POMWin excel
sheet for FCFS.sequence sheet completed
FCFS,DD,SPT,CR solution
Bang For The Buck (BFTB) sequencing exam questions
MILP And what to do if there is no partial creditThe
knapsack problem
Video on formulating
the knapsack problem in Solver
MILP scheduling
employees
overtime costs
pdf for Johnson's rule. Description
of
Johnson's rule procedure.
Queuing
Simulation:
Don't do this exercise. I did it for you. Watch the videos if you need
to understand it in preparation for an exam question.Videos on the simulation
queuing experiments, fixed vs.
variable service time, disproportionate effect of a second
server, combining queues.
simulation using the EXTEND Light Modeling system that is on the supplementary
CD. Other Videos on the Macdog project
PDF of the assignment
macdog.exe used in the
example. 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.
Monte Carlo Simulations in EXCEL
An example of using EXCEL's Rand() function to build a Monte Carlo Simulation
on the Transmission of disease
This sheet has most of the formulas and mechanisms out in the
open to make it easier to understand. I did have to resort to a short macro
to provide an accumulator to track results on successive trials of the
model.
This same sort of model could be used to simulate all kinds of other
chance events such as gambling outcomes, weather, customer arrivals, stock
returns, baseball game outcomes, etc..
It could be spiffed up with more buttons, spinners and dynamic graphs.
You could probably build games on this format.
Here's an extension with a loop for 1000 trials and a pie chart Disease
Sim K
Benefits of Simulation:

Low Cost (Risk) Experiments

Compress time scales
Best for

Complex processes

Multiple step

Sequential random events

Unpredictable by other models

Sexual reproduction
Mitochondrial DNA and the origin of Humankind

Nova Article

History
of Medicine (Mitochondrial DNA Powerpoint show)

Max Ingman
Thesis

BBC Article

Pitcairn Island
has only four family names

EXCEL simulation on extinction of family
names
An Overview of Forecasting & Aggregate Planning
Production Planning

multiperiod Inventory Model Prodplan2.xls

I fixed some of the problems in this and simplified the formulas so
limits on Overtime and Outsourcing could be enforced as constraints, but
apparently still have some things to fix. Isn't life wonderful that there
is always a way to make it better?

Classical Inventory:
Project Management

PERT and CPM ppt show

FREE 60 day trial of Microsoft
Project
Learning and Efficiency

Learning Curves

Efficiency, Time and Motion Studies
Summary: