Linear Programming with EXCEL Solver:

Some of these are EXE's  that include the viewer. In that case, you may have to save to the hard drive and run using windows explorer or Start/ Run

And Simulation with EXTEND:

 

Linear Programming with EXCEL Solver
Excel file for the XY LP Problem xylp2.xls
PDF of the geometric solution of the XY LP Problem lpgeom.pdf
Video on XY LP problem set up xylp1.exe
Video on XY LP problem set up in solver xylpsol.exe
Video on XY LP problem sensitivity data in solver xylpsens.exe
importing pdf data on the diet problem from the Heizer-Render site dietdat.exe
Cofiguring diet Data for Solver model in EXCEL diettbl.avi
Solver setup & solve diet problem dietsolv.avi
paste diet data into POM and solve dietpoms.avi

Macdog Queuing in EXTEND
random service and 2 separate queues 2queues.avi
Combining Queues  combqueu.avi
Combine queues the easy way expt3ezway.avi
Experiment 2, hook up a second server extexpt2.avi

EXCEL Simulations
  • Random extinction of family names 
 http://www.umsl.edu/~rbanis/252/docs/namsim2.xls
    • Slot machine configuration simulation. What does "96% payout" mean? 
    • A slot machine game configuration is described by wizardofodds.com
    • Suppose payoffs are proportional to odds: is it better to play a high jackpot low frequency game, or a medium jackpot higher frequency game? use this model to explore the question. changing  odds by adding symbols to reels causes recalculation of payoffs.
 slotsimulation.xls

E-mail: LOM5320 @ budbanis,com
Campus office CCB 230
On-campus phone 314-516-6136
Off-campus 636-394-4950

last modified September 4, 2004