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 1 = weight assigned to homework W 2 = weight assigned to the project W 3 = weight assigned to the mid-term
W 4 = 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:

Question

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 1 = weight assigned to homework W 2 = weight assigned to the project W 3 = weight assigned to the mid-term
W 4 = 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:

Quizplus · Accepted Answer

The Answer of 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 1 = weight assigned to homework W 2 = weight assigned to the project W 3 = weight assigned to the mid-term
W 4 = 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:

Robert Hope Received a Welcome Surprise in This Management Science