Create a weighted scoring model to determine grades for a course. Final grades are based on threeexams worth 20 percent, 15 percent, and 25 percent, respectively; homework is worth 15 percent;and a group project is worth 25 percent. Enter scores for three students. Assume that Student 1earns 90 percent (or 90) on every item. Assume that Student 2 earns 70 percent on each of theexams, 80 percent on the homework, and 95 percent on the group project. Assume that Student 3earns 90 percent on Exam 1, 80 percent on Exam 2, 75 percent on Exam 3, 80 percent on thehomework, and 70 percent on the group project.

A weighted scoring model, also known as a weighted scoring system or weighted decision matrix, is a…

Answered: Create a weighted scoring model to…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Paige Turner has been working in a law firm for the last two years and has been bullied by her manager ever since she joined. She is given targets that are impossible to complete within the given time frame. When she is unable to complete her work, her manager admonishes her in front of everyone. In addition, Paige is not invited to take part in discussions that involve making decisions about client's accounts, which are being attended by all other team members.Identify TWO (2) types of workplace discrimination that are evident in this scenario. Justify your answer.
The present inquiry concerns the correlation between the waterfall model and the software development life cycle (SDLC), as well as the various stages that constitute the waterfall model. Barry Boehm's perspective on spiral models and his commentary regarding these models are of interest.
Which statement regarding Time-Cost Models tradeoffs is true? Crashing a project reduces the duration of noncritical activities Projects with multiple critical paths cannot be crashed The crash time of an activity exceeds the normal time of the activity To crash a project, costs are increased on critical activities to reduce their duration Noncritical activities cannot become critical after crashing
A project has the following tasks and duration estimates given. These three tasks are done in succession on a project. Task Optimistic Estimate Most Likely Estimate Pessimistic Estimate Alpha 30 days 40 days 50 days Beta 20 days 25 days 28 days Charlie 4 days 10 days 12 days Delta 25 days 30 days 50 days What is the expected duration for the project? (3 points) What is the variance for the project? (3 points) What is the standard deviation of the project? (3 points) What is the range of the duration of the project given 3 sigma? (3 points)
Every member of a dragon boat crew has an important role to play, according to where they are in the boat: 1. Drummer - also called the Caller. For festivals, when the dragon boat is in full regalia, the drummer sits in a chair at the front and uses a large drum to relay the stroke timing to the rest of the boat. In this photo, the drum has been removed for safety during a longer-distance race. The caller works with the tiller to manage the boat and its crew, and is essential for safety because they are the only person that can easily see behind the boat. 2. Strokers (benches 1, 2, and 3) - The first pair, in bench 1, set the timing for the rest of the boat, and seats 2 and 3 pick it up and carry it for the rest of the boat to follow. People in these seats tend to be shorter, lighter, and have the excellent sense of timing that is required to keep the crew together. They tend to have experience for the feel of the boat, and can adjust the timing when they can feel the crew is with…
Quorex is evaluating two mutually exclusive projects. Project A has a net investment of $50,000 and net cash flows over a six-year period of $13,000 per year (NOTE: that project requires a reinvestment with the same cost and cash flow for another six years). Project B has a net investment of $48,500, but its net cash flows of $8,740 per year will occur over a 12-year period. If Quorex has a cost of capital of 14% for these projects, which project, if either, should be chosen, and what is its NPV?
Specifying optimistic, pessimistic, and most likely or mode times are sufficient to generate the beta distribution describing completion times. The applet opens with values Optimistic = 2 weeks, Pessimistic = 11 weeks, and Mode = 4 weeks. Drag the mode line inside the distribution to see how the shape changes as expectations about the most likely outcome change. Drag between 0 and the current Optimistic value to change the Optimistic value. Drag, in either direction, beyond the upper end to change the pessimistic value.
A project costs $360,000 initially and will generate project cash flows of $50,000 every year for 8 years. The required return for the project is 9%. What is the NPV of the project (in $)? p+ decimals Submit
A survey was conducted to 12 first time voters on their preferred candidate. The results are: BBM, BBM, LR, IM, PL, PL, IM, IM, BBM, BBM, LR, LR. Which statement is true? A The Borda score of PL is two points. B BBM wins by plurality method. The Condorcet winner is IM. D The modes are LR and IM.
The structure of your firm has two lower-level positions: an entry level position in which each employee receives a one year contract and a second level position (i.e., one step up from entry level) in which employees receive three year contracts. At the end of the first year, entry level employees undergo a formal evaluation that has three possible outcomes: a promotion to the second level position with a three year contract, a renewal of the one year contract for a second year at the entry level, or termination from the firm. At the end of the three year contract at the second level, employees undergo a similar formal evaluation resulting in either renewal for another three years or termination. The firm makes initial hires at both the entry level and second level positions. As the firm’s HR manager, you have a job applicant you are interested in hiring who has the resume qualifications of someone that you would typically hire at the second level position (with a three year…
The client of a project has requested the project team to crash 8 hours of time. The table below provides the necessary information about the possible project crashing. (a) What is the crash cost for 8 hours of time-savings?(b) Assume the team calls the client and asks for a project extension, reducing the amount of time they need to crash. The project team has a $20 crash budget. Is the budget sufficient to crash 4 hours of time?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS