Solved

Robert Hope Received a Welcome Surprise in This Management Science

Question 73

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: 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: The following LP model allows Robert to maximize his numerical grade. 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 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: 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:

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions