Quantitative Methods Homework
Instructions for Homework
1) 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.
2) You are required to use the Excel Solver to solve the LP problems. Answers without embedded formulas for solver will not be given credit.
3) Download the homework template Excel file “Hw8_2015_Fall_Template”. You are required to use the template for the homework.
4) 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.
5) Click on the link “Week 8 Homework Submission”. Submit the completed homework as attachment.
Notes
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.
mat540_hw_wk8_2.pdf
mat540_hw_wk8_2.pdf
hw8_fall_2015_template_v1.xlsx
