Answer Happy

Chapter 13: Linear Optimization Problems: 25, 27, and 35 (pp. 513 & 516) 1. Develop a linear optimization model for #25 and #27. 2. Find the optimal solutions for all 3 problems (#25, #27, &#35) using Excel Solver. 3. You may use the Excel template (incomplete) for this assignment. Check the detailed requirements in the template 4. Submit ONE Excel file for your team for this assignment. 5. Due date: TBA. The submission link on Canvas will stay open till midnight of the due date, 6. Grading policy 1 Points 5 5 10 Points 5 5 10 250 LP model formulation a. Definitions of decision variables b. Objective function Constraints 25 Spreadsheet model & Solver solution a. Objective function b LHS of the constraints Solver inputs Objective cell b. Cells for decision variables Constraints (LHS vs. RHS) Solving method Total points 5 5 270 UP model formulation 3. Definitions of decision variables b. Objective function Constraints 276 Spreadsheet model & Solver solution a. Objective function b. LHS of the constraints Solver inputs a. Objective cell b. Cells for decision variables c. Constraints (LHS vs. RMS) Solving method Total points 5 5 2 2 5 1 40 2 2 5 1 40 35 Spreadsheet model & Solver solution a. Objective function 5 b. U4S of the constraints 5 Solver Inputs 2. Objective cell 2 b. Cells for decision variables 2 c. Constraints (UHS VS. RHS) 5 solving method 1 Total points 20
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 1096. 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.
B D 1 3 Part a: Develop an LP model for this problem (Filling out colored cells). a. Define 4 decision variables b. Setup the objective function c. Formulate a total of 8 constraints 4 5 7 Decision variables 159 10 11 12 25. Key is a businessdent at State U. She has completed a counse la decision models, which had a midterm am a final cum, Individual lignments and a carticipation grade. She cured a the midim, on the final 93 on the individual augments, and 855 participation. The beneve lentlastructor is allowing his students to determine their own weight for each of the four grade comp- of couns, with some restriction The participation weight can be no more than The midum weight be at least twice much as the individual signment weight The final weight must be at least three times as much as the Individualment weight The weights for each cam must be at least 33 The weights for assignments and participation must be at least 10 The weight must sum to 10 and beneative Develop a mathematical model that will yield vald set of weights to mimine Korey's score for the con bnplement your model on spreadsheet and find in optimal solutioning Soler 12 Objective function: Maximize: Subject to constraints) 14 15 16 17 10 10 20 21 22 23
H Spreadsheet model Weight Grade Total weighted pts Midterm 1 94 Final 1 86 Assignments Participation 1 1 93 85 0 15% 2. Kes compared to delicada வா tail aum nan காலமாக werde. She de the final on the are Thebe er allowing is dat die their ows was the found of course, with The whole than 150 Theme muchas didelis The foam free tiems diving Thomwa The forrit exion The weights to Love Develop a mais model that will who Kary's for con mpyourmodel pendid olmaslutioning Show 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. Weicht for assignments 7. Weight for participation Sum of total weights 25% 25% 10% 10% 1.0 Notes: a. Complete the spreadsheet model above by filling out colored cells using cell references and/or formulas b. Find the optimal solution using Solver. What set weights should Korey use to maximize her score for the course?