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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!