Handouts for Spring 2008

---

· Introduction

· Standard Printout

· Useful EXCEL functions

LOOKUP

INDEX

· Even computers make mistakes

LINEAR PROGRAMMING

· Contractors

Solver dialog box

· Bags Problem

Constructing and Solving the Model

Spreadsheet Solution Page 1

Graphical Solution

· Diet Problem Page 13

Spreadsheet Solution

Solver dialog box

· Bikewheels Problem Page 27

Constructing and Solving the Model

Spreadsheet Solution

· Perfume Problem Page 30

Constructing and Solving the Model

Spreadsheet Solution

· Pigskin Problem page 37
Constructing and Solving the Model

· Gases Problem page 40

Constructing and Solving the Model

· Juice Problem page 43
Constructing and Solving the Model

· Chandler Problem (Spreadsheet) page 46

· Pickles Problem page 57
Spreadsheet Solution (case of production <= demand)

· Investment Problem page 60
Spreadsheet Solution

An Alternative Solution

· Mining Problem page 63
Spreadsheet Solution

· Carseats Problem page 66
Spreadsheet Solution

· Project Scheduling Problem page 97
Spreadsheet Solution 1
Spreadsheet Solution 2

Project Diagram

Algebraic Formulation

· Project Scheduling Crashing Problem

Algebraic Formulation
Spreadsheet Solution

INTEGER PROGRAMMING (INTEGER AND BINARY VARIABLES)

· Some Problems have Integer Solutions (without asking)

A Transportation Problem with Integer Data

· StockCo Problem page 105
Spreadsheet Solution

· Plane Problem page 108
Spreadsheet Solution

· MachineCo Problem page 111
Spreadsheet Solution

· An Assignement Problem with a Trick

Spreadsheet Solution

· Milkem Problem page 124
Spreadsheet Solution

· Air Hubs Problem page 127
Spreadsheet Solution

· SmallTime Problem page 130
Spreadsheet Solution

· Pitchers Problem page 117
 Spreadsheet Solution

· Gandy Problem page141
Spreadsheet Solution

· Boilers Problem page 121
Spreadsheet Solution

· Hiring Problem page 153
Spreadsheet Solution

· Huntco Problem page 156
Spreadsheet Solution

· Logical Constraints and Binary Variables

· A problem in quantity discount

SIMULATION

· YASAI webpage

· Coins

· A Guessing Game

· Newspaper Problem page 167
Spreadsheet Simulation

· Translators Problem page 175
Spreadsheet Template
Spreadsheet Simulation

· Binomial, Poisson and Normal- Graphic Excel Slides

· Overbooking Problem page 171
Spreadsheet Simulation

· Illustration of the Central Limit Theorem

· The 3 Door “Paradox”

Spreadsheet Simulation

· Project Scheduling with Random Activities

· Power Supply Problem page 195
Spreadsheet Simulation

· Insurance Problem page 203
Spreadsheet Simulation

· Inventory Problem page 207
Spreadsheet Simulation

· Repair Shop Problem page 211
Spreadsheet Simulation

· Horses Problem page 215
Spreadsheet Simulation

· Truck Bays Problem page 220
Spreadsheet Simulation

· The St. Petersburg Paradox

· The Buffon Needle Problem

· The Birthday Problem

· Pi

· The Inspection Paradox

· Belts Replacement Problem page 224
Spreadsheet Simulation

· Queueing Problem page 228
Spreadsheet Simulation

Back to Course page