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: The following LP model allows Robert to maximize his numerical grade. What values would you enter in the Analytic Solver Platform (ASP) 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:  The following LP model allows Robert to maximize his numerical grade.  ​  What values would you enter in the Analytic Solver Platform (ASP) 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:  The following LP model allows Robert to maximize his numerical grade.  ​  What values would you enter in the Analytic Solver Platform (ASP) 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