Question: Please help me complete part b of this question. I've included the answers that I got, however, they're incorrect. A business student has just completed
Please help me complete part b of this question. I've included the answers that I got, however, they're incorrect.
A business student has just completed a course, which had a midterm exam, a final exam, individual assignments, and a class participation grade. She earned a 91% on the midterm, 88% on the final, 94% on the individual assignments, and 83% on participation. The instructor is allowing students to determine their own weights for each of the four grade components, with the accompanying restrictions. Complete parts a and b.
Part a. (I got this part correct) :
Develop a mathematical model that will yield a valid set of weights to maximize the student's score for the course. Let M, F, A, and P represent the weights for the midterm, final exam, individual assignments, and participation, respectively.
(Type integers or decimals. Do not round.)
Maximum Score = .91M + .88F + .94A + .83P
P 0.15
M - 2 A 0
F - 3 A 0
M 0.25
F 0.25
A 0.1
P 0.1
M + F + A + P = 1.0
M,F,A,P 0
Part b. (need help with this part...some part of it is wrong and I don't know what) :
Implement your model on a spreadsheet and find an optimal solution using Solver.
M= (my answer= .300??)
F= (my answer= .450??)
A= (my answer= .150??)
P= (my answer= .100??)
Weighted Score = (my answer= .893??)
THANK YOU!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
