Many problems are available here
Their spreadsheet solutions are here

Class 1: Tuesday, Sep 5, 00

• Two problems

• Insurance advertising (spreadsheet solution)
• Insurance advertising (Solver dialog box)
• Computer assembly (spreadsheet solution)
• Computer assembly (Solver dialog box)

• The bags problem (html format)
• The bags problem (spreadsheet solution)
• The bikewheels problem (html format)
• The bikewheels problem (spreadsheet solution)

• Example 2.2, p. 36 in text (spreadsheet solution)
• Example 2.3, p. 36 in text (graphic solution in MAPLE)
• The diet problem (html format)
• The diet problem (spreadsheet solution)
• LP Formulation guidelines

• The Pickles Problem (html format)
• The Pickles Problem (spreadsheet solution)
• The juice problem (html format)
• The juice problem (spreadsheet solution)
• Example 3.2, p. 79 in text (spreadsheet solution)
• The Excel DATA TABLES

• The perfume problem (Problem 3.19 in text)
• The perfume problem (spreadsheet solution)
• Example 3.3, p. 88 in text (spreadsheet solution)
• Example 3.4, p. 97 in text (spreadsheet solution)
• The Excel LOOKUP function

• Example 3.5, p. 111 in text (spreadsheet solution)
• Example 3.6, p. 116 in text (spreadsheet solution)
• An Investment Problem (html format)
• An Investment Problem (spreadsheet solution)
• The Investment Problem (alternative solution)
• The Excel RANDOM functions

• The Powerco Transportation Problem, Example 4.1, p. 151 (spreadsheet solution)
• The Sailco Problem, Example 4.2, p. 154 (spreadsheet solution)
• The Machinco Problem, Example 4.3, p. 162 (spreadsheet solution)
• The Excel FACT and PERMUT functions

• Critical Path, Example 4.4, p. 168 (spreadsheet solution)
• Crashing project time, Example 4.4a, p. 172 (spreadsheet solution)
• Minimum Cost Network Flows, Example 4.5, p. 179 (spreadsheet solution)
• The Excel BINOMDIST function

• The Consolidated Mines Problem (html format)
• The Consolidated Mines Problem (spreadsheet solution)
• The Excel POISSON function

Class 11: Tuesday, Oct 10, 00

• The Excel EXPONDIST  function
• LP Review Problems

• Midterm Exam 1
• Solutions
• Spreadsheet solution of Problem 3

Class 13, Tuesday, Oct 17, 00

• A Knapsack Problem, Example 5.1, p. 214 (spreadsheet solution)
• Fixed Charge Problem, Example 5.2, p. 225 (spreadsheet solution)
• The Excel NORMAL function

• Location Problem, Example 5.3, p. 236 (spreadsheet solution)
• A Plane Loading Problem (html format)
• A Plane Loading Problem (spreadsheet solution)

• A Warehouse Location Problem, Example 5.4, p. 241 (spreadsheet solution)
• Problem 5.53, p. 257 (spreadsheet solution)
• Problem 5.59, pp. 259-260 (spreadsheet solution)
• Problem 5.61, p. 260 (spreadsheet solution)

Class 16, Thursday, Oct 26, 00

• Set Covering Problem, Example 5.5, p. 248 (spreadsheet solution)
• Either-Or Constraints, Example 5.6, p. 252 (spreadsheet solution)

• Hiring problem (html format)
• Hiring problem (spreadsheet solution)
• Integer Programming Review Problems (word document)

• The quantity discount problem (html format)
• The quantity discount problem (spreadsheet solution)
• Coin simulation
• Die simulation

Class 19, Tuesday, Nov 7, 00

• Example 5.41, p. 240 (spreadsheet solution)
• Example 5.37, p. 235 (spreadsheet solution)
• Example 5.35, p. 234 (spreadsheet solution)

• The birthday problem (spreadsheet simulation)
• A belt replacement problem (spreadsheet simulation)

• The transportation paradox (spreadsheet solution)
• The St Petersburg paradox (spreadsheet simulation)
• The newsboy problem (spreadsheet simulation)

• Midterm Exam 2
• Solution

• Example of errors in computation (spreadsheet example)
• Airline overbooking, Example 10.3, p. 507 (spreadsheet simulation)
• Grades simulation (spreadsheet simulation)

• Thanksgiving

• The 3 door puzzle (spreadsheet simulation)
• The Buffon needle experiment (spreadsheet simulation)

• The translators problem (html format)
• The translators problem (spreadsheet simulation)
• A financial problem (word document)
• A financial problem (spreadsheet simulation)
• The Excel EXPONDIST  function (needed for HW# 9)

• The M/M/1 queue (spreadsheet simulation)
• The inspection paradox (spreadsheet simulation)
• Problem 12.27, text p. 641 (spreadsheet simulation)