Quantitative Methods Homework

Nov 27th, 2015
Anonymous
Category:
Accounting
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.

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

Tutor Answer

(Top Tutor) Studypool Tutor
School: Boston College
PREMIUM TUTOR

Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1821 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