Homework problems are listed in the pdf file “mat540 hw wk8.pdf”.
There are 6 problems. You
are required to do problems 1,2,3,4 and 5.
To reduce your workload, ignore Q3 part b.
You are required to use the Excel Solver to solve the LP
problems. Answers without embedded
formulas for solver will not be given credit.
Download the homework template Excel file “Hw8_2015_Fall_Template”. You are required to use the template for the
Do the homework and enter your answers in the
cells highlighted in yellow. I will
grade only answers in the cells highlighted in yellow. You must show how you obtain the answers
using embedded Excel formula.
Click on the link “Week 8 Homework
Submission”. Submit the completed
homework as attachment.
These homework problems are quite
challenging. To help you, I have left
some of the “usage” and “objective” formulas in the template. You are to complete the rest and run the
solver to solve it. The cells highlighted in gray are variables. Cells highlighted in yellow are places where
formulas need to be inserted. Solver
setups for Q1,2,3 are quite similar to Week 6 and week 7 homework. It just has more variables and
constraints. Solver layout for Q4 and Q5
are different from Q1,2,3. Study the
comments I have left with cells. You
should be able to figure out the rest. I
will go over these problems during Supplemental Instruction. I have also uploaded a file “Chapter 4
Textbook Examples”. It is the Excel
solver solutions for the examples given in Chapter 4 of your textbook. Study them with the equations given in the
textbook. You will get a better idea how
to use solver. To see the embedded
formula, hold the Ctrl key and click ~ key or double-click the highlighted
cells, it will show you which cells are being multiplied and added. Study the pattern and how it relates to the
LP equations. To go back to normal
display mode, hold the Ctrl key and click ~ key. It will toggle between the two modes.