Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

18th Edition

1119790972, 9781119790976

More Books

Students also viewed these Accounting questions

Question

LO2 Discuss the constraints faced in a typical recruitment process.

Answered: 1 week ago