Please solve all of the answers and blanks using the info provided with explaination! Thank yooouuu

Variable Cells Final Value Cell Reduced Cost 0 0.1 Name homework Weight project Weight midterm Weight final Weight Objective Allowable Coefficient Increase 75 10 94 1E+30 85 1E+30 92 2 $C$2 $C$3 $C$4 $C$5 Allowable Decrease 1E+30 2. 10 17 2 2 0.25 0.4 10 0.25 0 Constraints Final Shadow Price Constraint R.H. Side Value 75 1 Cell $C$6 $E$6 $F$6 Name Subject to: Weight Subject to: mid/final Subject to: proj/fin Allowable Allowable Increase Decrease 0.15 0.05 1E+30 0.05 0.05 0.15 0.7 0.65 0.5 0.5 Question 1 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 midterm 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 midterm 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 W1 = weight assigned to homework W2 = weight assigned to the project W3 = weight assigned to the mid-term W4 = weight assigned to the final MAX: 75W1 + 94W2 + 85W3 + 9264 Subject to: W1 + W2 + W3 + W4 = 1 W3 + W4 50.70 W2 + W4 S 0.50 0.05 SW1 S 0.25 0.05 > W2 = 0.25 0.10 5 W3 S 0.40 0.10 s W4 0.40 Answer the following questions based on the Sensitivity Analysis Report that was given to you. DO NOT ATTEMPT TO IMPLEMENT THIS MODEL. 1) The model Choose... degenerate because Choose... the Choose... column(s) in the Choose... section of the Sensitivity Analysis contain Choose... values. 2) The model Choose... have alternate optimal solutions because Choose... the Choose... column(s) in the Choose... section of the Sensitivity Analysis contain Choose... values. 3) Constraint $C$6 corresponds to the constraint W1 + W2+W3 + W4 = 1, and has a shadow price of 75. Complete the following: The constraint Choose... have the Choose... Choose... and is a Choose... constraint. The RHS of the constraint Choose... be changed. Robert's current mark is: Answer: Is there anything that Robert can request to improve his final grade? Robert can improve his final grade by requesting a(n) Choose... in the total weight allowed for the Choose... since that has the Choose... Choose... Robert has been approved by his instructor to increase the total weight allowed for the project and final exam to 0.50 plus the allowable increase. Robert will use the following justification to calculate his new grade: Since the Choose... is . , Robert will multiply this by the Choose... of Choose... to obtain the increase in his mark. The increase in Robert's mark would be: Answer: Robert's new mark would be: Answer: Variable Cells Final Value Cell Reduced Cost 0 0.1 Name homework Weight project Weight midterm Weight final Weight Objective Allowable Coefficient Increase 75 10 94 1E+30 85 1E+30 92 2 $C$2 $C$3 $C$4 $C$5 Allowable Decrease 1E+30 2. 10 17 2 2 0.25 0.4 10 0.25 0 Constraints Final Shadow Price Constraint R.H. Side Value 75 1 Cell $C$6 $E$6 $F$6 Name Subject to: Weight Subject to: mid/final Subject to: proj/fin Allowable Allowable Increase Decrease 0.15 0.05 1E+30 0.05 0.05 0.15 0.7 0.65 0.5 0.5 Question 1 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 midterm 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 midterm 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 W1 = weight assigned to homework W2 = weight assigned to the project W3 = weight assigned to the mid-term W4 = weight assigned to the final MAX: 75W1 + 94W2 + 85W3 + 9264 Subject to: W1 + W2 + W3 + W4 = 1 W3 + W4 50.70 W2 + W4 S 0.50 0.05 SW1 S 0.25 0.05 > W2 = 0.25 0.10 5 W3 S 0.40 0.10 s W4 0.40 Answer the following questions based on the Sensitivity Analysis Report that was given to you. DO NOT ATTEMPT TO IMPLEMENT THIS MODEL. 1) The model Choose... degenerate because Choose... the Choose... column(s) in the Choose... section of the Sensitivity Analysis contain Choose... values. 2) The model Choose... have alternate optimal solutions because Choose... the Choose... column(s) in the Choose... section of the Sensitivity Analysis contain Choose... values. 3) Constraint $C$6 corresponds to the constraint W1 + W2+W3 + W4 = 1, and has a shadow price of 75. Complete the following: The constraint Choose... have the Choose... Choose... and is a Choose... constraint. The RHS of the constraint Choose... be changed. Robert's current mark is: Answer: Is there anything that Robert can request to improve his final grade? Robert can improve his final grade by requesting a(n) Choose... in the total weight allowed for the Choose... since that has the Choose... Choose... Robert has been approved by his instructor to increase the total weight allowed for the project and final exam to 0.50 plus the allowable increase. Robert will use the following justification to calculate his new grade: Since the Choose... is . , Robert will multiply this by the Choose... of Choose... to obtain the increase in his mark. The increase in Robert's mark would be: Answer: Robert's new mark would be