| "When you try to pull just one thing out of the Universe, you find it attached to everything else." --John Muir |
You may need access to a computer where you can install the software from the book to do the exercises. You should also have a copy of Microsoft Office on your computer so you can do the EXCEL assignments at home. Try the bookstore for the Academic version Office Pro at a very reasonable price.
Special announcements go here:Selected Overheads as PDF's and EXCEL FilesPrevious semester first exam examples are on the overheads page You will need the Course CD's to do exercises 3 and 4 Online sources: Excellent EXCEL Videotutorials from DataPigTechnologies
For each exercise, submit paper copies for grading, and put a copy of
the file into the mygateway dropbox for reference. Remember to send after
submitting or I won't get it.
|
Making Quality Decisions
Decision models: risk avoidance vs. risk management
Interactive Powerpoint show on risk management
(660K)--this has a different set of numbers than used in class to give
a little more 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)
Joint events-reliability and redundancy
Chapter 17
Week 3 Cost Structures
Chapter 7
Spreadsheet Budgeting (NIB)
Excercise 1 budgets PDF
"Location" Break even Analysis
Chapter 8
Factor rating
Excercise 2 jobrate PDF
| 1) Here are EXCEL sheets for budgets and factor rating: these
should also open in recent versions of LOTUS
jobrate.xls and budget.xls The parts of the sheets that you can change are shown in blue. I protected it so that people wouldn't inadvertantly mess up the formulas. You can deprotect it by simply copy and paste to the same place on another spreadsheet file. 2)Make your own EXCEL, LOTUS or QUATTROPRO sheet
|
Week 6 Optimization models
Linear Optimization Models
Module B
Computer Solutions using Excel Solver
p.759 (6th Edn) p. 724 (5th Edn), packet
The X-Y Company as an EXCEL Lp model
Videotutorials
for solving the X-Y Lp problem in EXCEL Solver
Problems can also be solved in POM-Win (the second CD that came with the
Heizer-Render text) Install it on your machine.
Exam 1 |
Facilities /Capacity and Location Planning:
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 set up in class
Modified
EXCEL Technician travel model to explore shadow prices of hiring more
technicians
Tech Travel
description and tables
for manual solution
EXCEL transportation model for exploring extra plant
capacity expansion
| Computer Exercise 3--use of EXCEL Solver with Sensitivity analysis
and comparison to POM-WIN LP module
You will solve the same diet problem in both systems to see how they relate to each other. They should be the same. though the format and terms are a little different. See the description of the diet project. |
Week 7
Microscheduling/ job sequencing:
Joe Gantt's auto repair schedule
Job Matching -Assignment Method-Excel
Chapter 15
Assigning jobs--an example, as a PDF file,
(you need the free add-in, Adobe Acrobat for this)
and an EXCEL Solver solution by Bill Cacheris
of the MBA online program
What does it Mean?
Week 9 Process Priority
Rules-Excel/ POM-Win excel sheet for FCFS.
pdf for Johnson's rule. Description
of
Johnson's rule procedure.
| Memorial Day Holiday, Monday, May 30 |
| Excused grades available until Last drop Day,
June 4 (note advising is closed June 4. |
| Computer Excercise 5 -- simulation using the EXTEND Light Modeling
system that is on the supplementary CD.
PDF of the assignment 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. Videos on the project There is a manual on EXTEND lite in the EXTENDLT directory, manual.pdf, 70 pp.. I've printed a few if someone wants to dig into it further. There are also larger manuals, User Guide.pdf, 738 pp., and a Developer Reference.pdf, 335 pp that extract if you install the software. I have other books from the previous version, BPR.pdf on Business Process Reengineering applications, 264 pp, and MFG.pdf on manufacturing applications, 320 pp. Installing EXTEND6LT also provides a number of example models with descriptions.
|
Scheduling & Inventory Management
Inventory
Formulas, PDF Inventory
powerpoint #1 (modified from Dr. Campbell)
Inventory
Overheads
Aggregate Planning - scheduling
Chapter 13
EOQ Model & Quantity discounts
Chapter 12
Service Level, Safety Stock & shortages; Reorder Point vs. Fixed Interval
Week 14 Economic Run Size (ERS), Make vs. Buy
& JIT
Single Period Model
Just in Time Philosophy
Week 15 Project
management, CPM & PERT powerpoint
Chapter 3 (16 in older editions)
Week 16 Learning
Curves
Module E
Efficiency, Time & Motion Studies
Ch.10 scan
| Ref. no./Section Time Room | Exam 2-date/time |
| 14020/ D01 MW 09:30-10:45 SSB216 | Monday May 9 / 7:45-9:45 am |
| 14030/ D02 MW 11:00-12:15 SSB216 | Monday May 9 / 10:00-12:00 Noon |
| 35640 /E01 W 6:55--9:35pm SSB216 | Wednesday May 11 / 7:45-9:45 pm |
| No switching sections without prior permission and a good reason |
Project schedules
A typical exam problem might also have a list of activities, durations,
precedence relationships and a predrawn PERT chart for you to fill in.
Project schedule and Bathroom solutions
learning curve data and the real
world.
two features about learning curves:
One is the doubling of experience gives a constant % reduction.
Thus, divide the times required T2/T1; T4/T2; T6/T3; T8/T4 This will reveal
a second feature, that the first time you do something, the data
usually doesn't fit the theory (i.e. it is "anomalous").
Use the table factors to figure out how much experience you must have
before the time to do it is 72 hours or less. The lesson is that it takes
time to implement a process change and realize the projected benefit.
Answers to Macdog output and learning curves
and the real world.
Merge lanes game
A linear Programming problem with solver
output to interpret.
similar to expan LP above
Solution to merge and Solver output
Bathroom queuing
Interpretation of MacDog output
miscellaneous MC questions
solutions have been added
| Due dates for Computer exercises: | Due | ||
| #1 budgets- | May 23 | 2.5% | |
| #2 factor rating | May 23 | 2.5% | |
| #3 EXCEL&POM-WIN LP | June 2 | 10% | |
| #4 simulation | June 6 | 5% | |
| Original research using LP or Simulation | last class day
June 9 |
5% and used for borderline decisions | |
| A few administrative issues ("The Rules"):
Attendance at Classes:
Computer Exercises:
Extra credit is sometimes awarded for doing something novel on one of the regular assignments. Extra credit isn't awarded to people who don't complete the basic assignments. Working together can be very useful, but it is very important to actually do the exercises yourself and understand what's going on. Consult with others, but generate your own data and submit only your own work. Note that the exercises are designed to be personalized to some degree to encourage this. If assignments submitted are very similar in form and substance to someone else's then both parties will share a zero for the assignment. Exams
reporting final grades:
Final grades are reported on time and available online. Please
do not call me to get your final grade. Please especially don't call to
"discuss your grade" while I am working on it. I will probably not be very
accessible by phone. If you want, or need more detail, E-mail me so I can
send you a copy and paste from my grade sheet. Grades are not adjusted
by offering students opportunities to do "extra credit assignments" or
regrade selected assignments or redo work after the end of the semester.
Excused grades
Delayed Grades
Course Evaluation:
|
Return
to Bud's Page
You are person number
to access this page since September 9, 1997
Go
to UM-St. Louis School of Business Page
last modified February 9, 2005 ~~ comments and suggestions
to
rbanis @ jinx . umsl . edu