STAT290 (SPRING 2017) EXCEL QUIZ
Tom would like 3 pints of home brew today and an additional 4 pints of home brew tomorrow. Dick is willing to sell a maximum of 5 pints total at a price of $3.00 per pint today and $2.70 per pint tomorrow. Harry is willing to sell a maximum of 4 pints total at a price of $2.90 per pint today and $2.80 per pint tomorrow. Find the optimal allocation and the minimal cost by EXCEL Solver.
Hint: Let X11 = the number of pints that Tom buys from Dick today.
And Let X12 = the number of pints that Tom buys from Dick tomorrow.
<Remarks>
1. This is the question we tested in the midterm exam.
2. Email your Excel spreadsheet to my email account (before 12:20pm) – coquitlampai@yahoo.com.
3. Your sent Excel spreadsheet should be named as follows:
SujinWang290.xls (if your last name is Wang and first name is Sujin).
4. Evaluation of your Excel work:
A) The correctness of your final answer - 60%
B) The applying the knowledge learned - 20%
C) The presentability of your work - 20%
5. Good Luck!