| "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:Syllabus as a PDFUndergrad online course recordings Some resources:HEY!! where did the EXCEL menus go?How to find EXCEL 2003 commands in EXCEL 2007 "Ribbons"try downloading the Excel Ribbon mapping workbook. I recommend clicking on the OFFICE icon at the top left of EXCEL 2007, click EXCEL OPTIONS (a button down at the bottom) and fix whatever needs fixing to get access to what you need, such as "Developer tab." Change the SaveAs default to old (1997-2003) EXCEL so you can still work on the product files on older versions of EXCEL. In case you have to, you might be able to find file converters at microsoft.com. They are also promising to someday make their file formats open source. Uncommon fonts may also wreak havoc as you try to work on a file across machines. Change default font theme under "page layout." I know Times New Roman and Arial are uninspiring, but they are more likely to be on your other machine. Logistics & Operations Management video
tutorials
EXCEL statistics videos
from the Business Statistics Course
Intro to Computers videos:
Horizon WIMBA Live
Classroom Participant's Guide
|
Cases/ exercises: |
Ground Rules: |
case link |
Due Before |
Solved Examples and Resources |
| Statistics and Decisions | Homework-individual effort but consultation | Quizzes/problems in mygateway, Course Documents Q1,
Q2-DriversEd case, Q3-Cheating incentives tree Put responses in mygateway quizzes and get feedback right away with 3 attempts allowed. |
Before July 11 | See the Zscore table links and tutorials in selected overheads, under reliability, and examples in class and videos on minimax regret. recorded online classes from statistics and the undergrad Operations course should also be helpful if you need more. |
| Group project in class to draw tree. Analysis is individual effort (with consultation if needed) | Case: RVFC decision tree / value of imperfect information | Before July 11 | PDF Trees:Drug
test, EVSI,
OSHA,
A start on the RVFC tree as an example of how this might be done in EXCEL. Find drawing tools in EXCEL 2007 under the ribbon insert/shapes. After insertion, right click shapes to remove color fill to make them transparent. |
|
| Decisions, games, reliability & Redundancy | Homework-individual effort but consultation | Problem set/Quizzes 4,5,6 on mygateway | Before July 31 | Reliability PDF Zscore tables gametheory, lousywork lowpay |
| Simpson's Paradox PivotTable | Homework-individual effort but consultation | Simpson's Paradox PivotTable See handout and videos | Before July 31 | |
| LP POM Win and Solver | Videos show you how to do this-individual effort as homework. | Diet problem from the Heizer-Render site.
Diet Problem Here is the data already set up in EXCEL to save you time: dietLPstart.xls See also the videos on how to do this including screen captures to report everything on a one-page report |
Before Sept. 8 | LP Geometric,
compare to
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 Production planning | I'll provide starter EXCEL sheets with data already set up. Finish as individual homework. | Linear programming problems:
Hospital Beds: Expansion hint: profit should be $9,551,659 Product Mix Problem from the Book Computer Product Mix, B.29 Hint: profits should be $9683 $8865 $9380 another configuration with sparse matrix for minimum requirements alternate hint |
before Sept 8 | Capacity Expansion problems in Solver
techhire.htm and techire.xls rbbexpan.pdf and rbbexpan.xls See also the videos on sensitivity analysis in the tech travel example. |
| Simulation in EXTEND | I have videos on doing these experiments. Repeat them on your own to get your own data. | MacDog.Exe
self extracting archive gives macdog2.mox for EXTEND MacDog exercise
MacDoggies service model. It's easier to find macdog2.mox on the course
CD under /extpomrun
Case description Here is an example layout for a one page report on the experiments. 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 |
Before Sept 8 |
My videotutorials on the MacDog assignment. |
| Quiz 7: Generic LP output interpretation | Quiz 7 in mygateway. | Overheads: Formulation and Interpretations of LP output
o The Mulch Company o Molly's Fruit Pies o answers to mulch and molypie see online undergrad course videos as well to refresh on what we did in class |
||
| Quiz 8: Assignment Model and Priority Rules | Homework-individual effort but consultation | assignment & scheduling description of quiz 8 on mygateway in course documents. | Before Sept 8 | Assign Boss example and an elegant compact solution in EXCEL Solver by Bill Cacheris, OLMBA, 2000 |
| Quiz 9: Inventory model implications | Homework-individual effort but consultation | Inventory POQ
vs EOQ
quiz 9 put on mygateway in course documents. See especially the solved example. |
Before Sept 8 | solved example ERS
v EOQ and Make vs. Buy eoqvpoq spreadsheet
model, FOI v ROP
single period, formulas, shortages, Z score table |
| Quiz 10: Qeueing table calculations | Description of Quiz 10 put on my gateway in course documents. | Before Sept 8 | For your interest:
The Gender Inequities Restroom Queuing/Simulation Problem. Here is an example from a paper on this issue by Ahn Tran. There's a wealth of literature about this on the web--Potty Parity. 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. |
|
| Quiz 11: Learning Curves & Projects | Homework-individual effort but consultation | Learning curves quiz 11 put on mygateway in course documents. | Before Sept 8 | learncurv.pdf
See the videos on learning curve calculations Project Mgt crashing example. |
| "Quiz" 12: | Read Beyond Lean + comment | WORD about 1 page review of lessons learned. | Before Sept 8 | I gave you a copy of this book in class. |
| Extra Credit: Course feedback Survey | feedback survey Extra credit equivalent to one quiz. | By Sept 14 |
Return
to Bud's Page
Go to UM-St. Louis School of Business Page
last modified August 15, 2008 ~~ comments and suggestions to
bud_banis (at) umsl.edu