Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill in the blank following the question. Please keep the answer in thr same format and legible 25. Korey is a business student at State
Fill in the blank following the question. Please keep the answer in thr same format and legible
25. Korey is a business student at State U. She has just completed a course in decision models, which had a midterm exam, a final exam, individual assignments, and a class participation grade. She earned a 94% on the midterm, 86% on the final, 93% on the individual assignments, and 85% on participation. The benevo- lent instructor is allowing his students to determine their own weights for each of the four grade compo- nents of course, with some 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, a. Develop a mathematical model that will yield a valid set of weights to maximize Korey's score for the course b. Implement your model on a spreadsheet and find an optimal solution using Solver. Spreadsheet model Weight Grade Total weighted pts Midtern X1) Final (X2) Assignments (X3) 1.00 1.00 1.00 94 86 93 Participation (X4) 1.00 85 >= >= Restrictions 1. Participation weight 2. Midterm weight 3. Final weight Minimum weight for exams 4. Weight for midterm 4. Weight for final Minimum weight for other items 6. Weight for assignments 7. Weight for participation 8. Sum of total weights 0.25 0.25 > 0.10 0.10 1.00 Notes: 2. To answer part (b), need to: a. Fill out the colored cells using cell references and/or formulas h Find the intimal solution nisino Solver Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started