Robert Hope Received a Welcome Surprise in This Management Science

Essay

Robert Hope received a welcome surprise in this management science class;the instructor has decided to let each person define the percentage contribution to their grade for each of the graded instruments used in the class.These instruments were: homework,an individual project,a mid-term exam,and a final exam.Robert's grades on these instruments were 75,94,85,and 92,respectively.However,the instructor complicated Robert's task somewhat by adding the following stipulations:
• homework can account for up to 25% of the grade,but must be at least 5% of the grade;
• the project can account for up to 25% of the grade,but must be at least 5% of the grade;
• the mid-term and final must each account for between 10% and 40% of the grade but cannot account for more than 70% of the grade when the percentages are combined;and
• the project and final exam grades may not collectively constitute more than 50% of the grade.The following LP model allows Robert to maximize his numerical grade.
Let W₁= weight assigned to homework W₂= weight assigned to the project W₃= weight assigned to the mid-term
W₄= weight assigned to the final


12 Both Exams 0.65 0.70
13 Final & Project 0.5 0.50
What values would you enter in the Risk Solver Platform RSP)task pane for the cells in this Excel spreadsheet implementation of this problem?
Objective Cell: Variables Cells: Constraints Cells: