Class 1: Tuesday, Jan 16, 01

• Two problems
• Insurance advertising ( Solver dialogbox)
• Computer assembly (Solver dialog box)

• Insurance advertising ( spreadsheet)
• Computer assembly (spreadsheet )
• Example of errors in computation ( spreadsheet)
• Spreadsheet for solving Problem 1 of Assignment1

• Monet's problem: Example 3.1, text, p. 69 ( spreadsheet)
• Scaled down Monet's problem: Example 3.2, text, p. 87  (spreadsheet)
• Scaled down Monet's problem:  Graphicalsolution.
• Diet problem (html format )
• Diet problem (spreadsheet)

• Pigskin problem: Example 3.3, text, p. 91 ( spreadsheet)
• Post office problem: Example 4.1, text, p. 113 ( spreadsheet)

• SureStep problem: Example 4.2, text, p. 120 ( spreadsheet)
• Same problem, with backlogging allowed:
• Nonlinear model (spreadsheet )
• Linear model (spreadsheet )

• Data tables (spreadsheet )
• Sensitivity analysis for Example 3.1, text, p. 69 ( spreadsheet)

• Training employees: Example 4.3, text, p. 131 (spreadsheet)
• Blending problem: Example 4.4, text, p. 137 (spreadsheet)
• Drug production: Example 4.5, text, p. 146 (spreadsheet)

• Financial planning: Example 4.6, text, p. 154 (spreadsheet)
• Financial planning: Sensitivity analysis to the ratio ST/LT. Text, p. 159 (spreadsheet)
• Example of LP with max buying price < min selling price (spreadsheet)

• Transportation model: Example 5.1, text, p. 193 (spreadsheet)
• Transportation model: Alternative formulation, text, p. 199 (spreadsheet)
• Manufacturing sailboats: Example 5.2, text, p. 200 (spreadsheet)

• Production & shipping model: Example 5.3, text, p. 208 (spreadsheet)
• Same model, with two products: Text, p. 213 (spreadsheet)
• Same model, accounting for perishability: Text, p. 214 (spreadsheet)
• Distributin oil: Example 5.4, text, p. 215 (spreadsheet)
• The assignment problem: Text, p. 223 (spreadsheet)
• Previous exam with solutions (word document)

• Assignment problem: Example 5.5, text, p. 224 (spreadsheet)
• Crew scheduling: Example 5.6, text, p. 227 (spreadsheet)
• Shortest path: Example 5.7, text, p. 233 (spreadsheet)

Class 13: Tuesday, Feb 27, 01

•      CONMINE Problem
•      CONMINE (spreadsheet)
•      CARSEATS Problem
•      CARSEATS (spreadsheet)
•      Project Scheduling Problem (AON formulation):
•      PROJECT(spreadsheet)
•      CRASH (spreadsheet)

• Project scheduling, AOA model: Example 5.10, text, p. 253 (spreadsheet)
• Crashing a project, AOA model: Example 5.10, text, p. 258 (spreadsheet)
• Project scheduling, AON model: Example 5.10, text, p. 253 (spreadsheet)
• The Transportation Paradox (spreadsheet)
• Equipment replacement: Example 5.8, text, p. 235 (spreadsheet)
• Scheduling flights: Example 5.9, text, p. 243 (spreadsheet)
• Excel LOOKUP function (spreadsheet)
• Excel FACT function (spreadsheet)
• Excel RANDOM function (spreadsheet)

• Midterm Exam 1
• Solution of Problem 1 (spreadsheet)
• Solution of Problem 2 (spreadsheet)

• Knapsack problem: Example 6.1, text, p. 278 (spreadsheet)
• Knapsack problem with 2 constraints: Text, p. 283 (spreadsheet)
• Fixed cost model: Example 6.2, text, p. 290 (spreadsheet)

• Facility location and assignment : Example 6.3, text, p. 301 (spreadsheet)
• Facility location and transportation: Example 6.4, text, p. 307 (spreadsheet)
• Hub location: Example 6.5, text, p. 313 (spreadsheet)
• Hub location: Sensitivity to distances (spreadsheet)
• Logical constraints: Example 6.6, text, p. 319 (spreadsheet)

• Cuttiong stock: Example 6.7, text, p. 323 (spreadsheet)
• Coin simulation (spreadsheet)
• Dice simulation (spreadsheet)

• Integer Programming Review Problems (word document)
• The quantity discount problem (html format)
• The quantity discount problem (spreadsheet solution)
• A belt replacement problem (spreadsheet simulation)
• The newsboy problem (spreadsheet simulation)

• Airline overbooking, Example 10.3, p. 507 (spreadsheet simulation)
• Grades simulation (spreadsheet simulation)
• The 3 door puzzle (spreadsheet simulation)
• The Buffon needle experiment (spreadsheet simulation)

• The Excel BINOMDIST function
• The Excel POISSON function
• The Excel NORMAL function
• A financial problem (word document)
• A financial problem (spreadsheet simulation)

• The translators problem (html format)
• The translators problem (spreadsheet simulation)
• The Excel EXPONDIST function

Midterm Exam 2 with solutions

• Meet 500 random numbers (spreadsheet simulation)
• Walton's bookstore: Text, Example 11.1, p. 570 (spreadsheet simulation)
• Same example  with data table: Text, p. 577  (spreadsheet simulation)
• Same example with 2-way data table: Text, p. 578  (spreadsheet simulation)
• The St Petersburg paradox (spreadsheet simulation)

• The M/M/1 queue (spreadsheet simulation)
• The inspection paradox (spreadsheet simulation)
• Here is the answer, what was the question ?

• The Excel HYPGEOMDIST function
• The M/M/1 queuing system

• A comparison of NORMINV & NORMSINV (the S makes a difference)
• Repair shop problem
• Power generating problem

• Review
• Teaching Evaluation

Final Exam