Instructions
Assignments must be completed on MindTap AND a completed workbook with your full completed solutions must be submitted via Sakai. You must submit both in order to receive any credit.
Hardcopies or copies emailed will not be graded.
There is no option for late submissions in MindTap. Failure to submit your submit your assignment on MindTap before the due date will result in zero credit.
Submit your worked data in one single MS Excel Workbook. Start your solution set by using the assignment shell provided on Sakai. Use appropriately labeled worksheets for each problem/section of a problem.
Pay very close attention to the final presentation of your work and make sure it is print-ready. Prepare all spreadsheets so that they are clear, attractive and easy for the untrained eye to follow and understand. While accurate content and precise execution of the techniques is critical, formatting, typographical and grammatical acuteness is also very important. General sloppiness and inconsistent formatting will lower your grade.
Note: Ignore MindTap warning about text-based answers. All open ended questions will be graded as well. In fact, your grade will depend equally on the accuracy of your analytical techniques and your interpretation of the results.
Assignment files should be named as follows:
Question 1. 50 points
In PC Tech’s product mix problem that we solved this week, assume there is another PC model, the VXP, that the company can produce in addition to Basics and XPs.
The following inputs are available:
From these available inputs, calculate the following inputs:
A.Use an LP spreadsheet model to find the best mix of computer models that stays within the company’s labor availability and maximum sales constraints and maximizes total profit. |
B.You should find that the optimal solution is not integer-valued. If you round the values in the decision variable cells to the nearest integers, is the resulting solution still feasible? |
Question 2. 50 points
A furniture company manufactures desks and chairs.
A.Use Solver to maximize the company’s profit. How many desks and chairs should the furniture company produce?
DO NOT Answer Parts B and C of Question 2.