Give B part solution (implement your model on spreadsheet and find an optimal solution using solver) Perfect solution for all parts Of B question

Homework. Assignn HW Score: 51.11%, 51.11 of 100 3 of 5 (4 complete) Score: 14.44 of 20 pts Question Help W 13.6.25 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, 85% on the final, 93% on the individual assignments, and 85% 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. IV 0.20 F 20.25 Restrictions A2 0.1 .1 M+F+A+P = 1.0 M.F.A.P 20 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, b. Implement your model on a spreadsheet and find an optimal solution using Solver. M= F= Print Done A= P= Weighted Score = (Type integers or decimals rounded to three decimal places as needed.) odit fields and then click Check