Due tonight please help!
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 97% on the midterm, 89% on the final, 91% 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. Click the icon to view the list of restrictions. a. 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.) 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 97% on the midterm, 89% on the final, 91% 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. Click the icon to view the list of restrictions. b. Implement your model on a spreadsheet and find an optimal solution using Solver. M=F=A=P= Weighted Score = (Type integers or decimals rounded to three decimal places as needed.) Restrictions The participation weight can be no more than 15%. The midterm weight must be at least twice as much as the individual assignment weight. The final exam weight must be at least three times as much as the individual assignment weight. The weights for each exam must be at least 25%. The weights for assignments and participation must be at least 10%. The weights must sum to 1.0 and be nonnegative