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