Quantitative Methods Homework

Nov 27th, 2015
Price: $15 USD

Question description

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.


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.


Tutor Answer

(Top Tutor) Daniel C.
School: UC Berkeley

Studypool has helped 1,244,100 students

Review from our student for this Answer

Nov 27th, 2015
"Solid work, thanks. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1826 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors