Install "solver" if necessary

image005.jpg
image001.jpg
image003.jpg
image002.jpg

Learn Excel Solver

For this lab we will follow some instructions found online in order to learn how to use Excel's "solver." We will do three problems — one from each example and [[[ppol225-text:linear-programming-electricity-and-pollution-ex| one from the text book].

Follow the instructions on this web page

And this one for interpreting results

Lab Work

Implement Solutions to 223, 224, 225, 226 in Excel. Present in a google doc in which each problem is presented as

Title
Problem Text
Variables
Objective
Constraints

Excel File Here

References

Problems and Solutions

File nameFile typeSize
image001.jpgJPEG image data34.17 kBInfo
image002.jpgJPEG image data13.25 kBInfo
image003.jpgJPEG image data14.51 kBInfo
image004.jpgJPEG image data5.98 kBInfo
image005.jpgJPEG image data6.09 kBInfo
labexercises.xlsxNo description80.98 kBInfo
LPlabexercises2016.xlsxNo description65.24 kBInfo
solver-examples.xlsxNo description48.71 kBInfo
study_time.xlsxNo description29.79 kBInfo