2. 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 92% on the midterm, 85% on the final, 95% on the individual assignments, and 84% on participation. The instructor is allowing students to determine their own weights for each of the four grade components, with the accompanying restrictions. (20-points) 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 Questions a Provide an LP formulation that will yield a valid set of weights to maximize the student's grade for the course --Do not forget the non-negativity constraints b. Using Excel, solve part (a) using linear optimization i. What is the maximum grade? ii. What are the weights for the midterm final exam, individual assignments, and participation? 2. 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 92% on the midterm, 85% on the final, 95% on the individual assignments, and 84% on participation. The instructor is allowing students to determine their own weights for each of the four grade components, with the accompanying restrictions. (20-points) 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 Questions a Provide an LP formulation that will yield a valid set of weights to maximize the student's grade for the course --Do not forget the non-negativity constraints b. Using Excel, solve part (a) using linear optimization i. What is the maximum grade? ii. What are the weights for the midterm final exam, individual assignments, and participation