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, 83% on the final, 95% on the individual assignments, and 86% on participation. The instructor is allowing students to determine their own weights for each of the four grade components, with the accompanying restrictions. Implement your model on a spreadsheet and find an optimal solution using Solver.
