Practical Management Science
5th Edition
ISBN: 9781305250901
Author: Wayne L. Winston, S. Christian Albright
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 7.6, Problem 34P
The method for rating teams in Example 7.8 is based on actual and predicted point spreads. This method can be biased if some teams run up the score in a few games. An alternative possibility is to base the ratings only on wins and losses. For each game, you observe whether the home team wins. Then from the proposed ratings, you predict whether the home team will win. (You predict the home team will win if the home team advantage plus the home team’s rating is greater than the visitor team’s rating.) You want the ratings such that the number of predictions that match the actual outcomes is maximized. Try modeling this. Do you run into difficulties? (Remember that Solver doesn’t like IF functions.)
EXAMPLE 7.8 RATING NFL TEAMS9
We obtained the results of the 256 regular-season NFL games from the 2015 season (the 2016 season was still ongoing as we wrote this) and entered the data into a spreadsheet, shown at the bottom of Figure 7.38. See the file NFL Ratings Finished.xlsx. (Some of these results are hidden in Figure 7.38 to conserve space.) The teams are indexed 1 to 32, as shown at the top of the sheet. For example, team 1 is Arizona, team 2 is Atlanta, and so on. The first game entered (row 6) is team 19 New England versus team 25 Pittsburgh, played at New England. New England won the game by a score of 28 to 21, and the point spread (home team score minus visitor team score) is calculated in column J. A positive point spread in column J means that the home team won; a negative point spread indicates that the visiting team won. The goal is to determine a set of ratings for the 32 NFL teams that most accurately predicts the actual outcomes of the games played.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
1) View the video Service Processing at BuyCostumes (10.41 minutes, Ctrl+Click on the link); what are your key takeaways (tie to one or more of the topics discussed in Chapter 3) after watching this video. (viddler.com/embed/a6b7054c)
Note: As a rough guideline, please try to keep the written submission to one or two paragraphs.
2) Orkhon Foods makes hand-held pies (among other products). The firm’s weekly sales of hand-held pies over the past seven weeks are given in the table. The firm’s operations manager, Amarjargal, wants to forecast sales for week 8.
Weeks
Sales of hand-held pies(000s)
1
19
2
18
3
17
4
20
5
18
6
22
7
20
Forecast the week 8 sales using the following approaches:
a) Naïve approach
b) 5-month moving average
c) 3-month weighted moving average using the following weights: 0.50 for week 7, 0.30 for week 6, and 0.20 for week 5.
d) Exponential smoothing using a smoothing constant of 0.30, assume a week 2…
What area of emotional intelligence refers to the ability to manage your emotions, particularly in stressful situations, and maintain a positive outlook despite setbacks?
relationship management
self awareness
social awareness
self management
What area of emotional intelligence refers to the ability to manage your emotions, particularly in stressful situations, and maintain a positive outlook despite setbacks?
relationship management
self awareness
social awareness
self management
Chapter 7 Solutions
Practical Management Science
Ch. 7.3 - Prob. 1PCh. 7.3 - Prob. 2PCh. 7.3 - Pricing Decisions at Madison The Madison Company...Ch. 7.3 - Prob. 4PCh. 7.3 - Prob. 5PCh. 7.3 - Prob. 6PCh. 7.3 - Prob. 7PCh. 7.3 - Prob. 8PCh. 7.3 - Prob. 9PCh. 7.3 - Prob. 10P
Ch. 7.3 - Prob. 11PCh. 7.3 - Prob. 12PCh. 7.3 - Prob. 13PCh. 7.3 - PRICING SUITS AT SULLIVANS Sullivans is a retailer...Ch. 7.3 - Prob. 15PCh. 7.4 - Prob. 16PCh. 7.4 - Prob. 17PCh. 7.4 - Prob. 18PCh. 7.4 - Prob. 19PCh. 7.4 - Prob. 20PCh. 7.4 - Prob. 21PCh. 7.4 - Prob. 22PCh. 7.4 - Prob. 23PCh. 7.5 - Prob. 24PCh. 7.5 - Prob. 25PCh. 7.5 - Prob. 26PCh. 7.5 - Prob. 27PCh. 7.6 - Prob. 28PCh. 7.6 - Prob. 29PCh. 7.6 - Prob. 30PCh. 7.6 - Prob. 31PCh. 7.6 - The method for rating teams in Example 7.8 is...Ch. 7.7 - Prob. 35PCh. 7.7 - Prob. 36PCh. 7.7 - Prob. 37PCh. 7.7 - The stocks in Example 7.9 are all positively...Ch. 7.7 - Prob. 39PCh. 7.7 - Prob. 40PCh. 7.7 - Prob. 41PCh. 7.7 - Prob. 42PCh. 7.8 - Given the data in the file Stock Beta.xlsx,...Ch. 7.8 - Prob. 44PCh. 7 - Prob. 45PCh. 7 - Prob. 46PCh. 7 - Another way to derive a demand function is to...Ch. 7 - Prob. 48PCh. 7 - If a monopolist produces q units, she can charge...Ch. 7 - Prob. 50PCh. 7 - Prob. 51PCh. 7 - Prob. 52PCh. 7 - Prob. 53PCh. 7 - Prob. 54PCh. 7 - Prob. 55PCh. 7 - Prob. 56PCh. 7 - A beer company has divided Bloomington into two...Ch. 7 - Prob. 58PCh. 7 - Prob. 59PCh. 7 - Prob. 60PCh. 7 - Prob. 61PCh. 7 - Prob. 62PCh. 7 - Prob. 63PCh. 7 - Prob. 64PCh. 7 - Prob. 65PCh. 7 - Prob. 66PCh. 7 - Prob. 67PCh. 7 - Prob. 68PCh. 7 - Prob. 69PCh. 7 - Prob. 70PCh. 7 - Based on Grossman and Hart (1983). A salesperson...Ch. 7 - Prob. 73PCh. 7 - Prob. 74PCh. 7 - Prob. 75PCh. 7 - Prob. 76PCh. 7 - Prob. 77PCh. 7 - Prob. 78PCh. 7 - Prob. 79PCh. 7 - Prob. 80PCh. 7 - Prob. 81PCh. 7 - Prob. 82PCh. 7 - Prob. 83PCh. 7 - Prob. 84PCh. 7 - Prob. 85PCh. 7 - Prob. 86PCh. 7 - Prob. 1.1CCh. 7 - Prob. 1.2CCh. 7 - Prob. 1.3CCh. 7 - Prob. 1.4C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- This area of emotional intelligence describes your ability to not only understand your strengths and weaknesses but to recognize your emotions and their effect on you and your team’s performance self management self awareness relationship management social awarenessarrow_forwardEmotional intelligence is defined as the ability to understand and manage your emotions, as well as recognize and influence the emotions of those around you. True Falsearrow_forwardAt the Ford automobile Highland plant, assume the one-millionth vehicle was produced in 1916 at a cost of $8084 (in 2013 US$), by how much did the Ford company reduce his cost with each doubling of cumulative output from 1916 to 1927?arrow_forward
- At the Ford automobile Highland plant,in 1913, how long did the average worker stay with the plant and what was the average tenure of a worker?arrow_forwardCommunity Federal Bank in Dothan, Alabama, recently increased its fees to customers who use employees as tellers. Management is interested in whether its new tee policy has increased the number of customers now using its automatic teller machines to that point that more machines are required. The following table provides the number of automatic teller transactions by week. Use trend projection with regression to forecast usage for weeks 13-16.arrow_forwardDavison Electronics manufactures three LED television monitors, identified as Model A, Model B, and Model C. Davison Electronics four manufacturing plants. Each model has its lowest possible production cost when produced at Plant 1. However, Plant 1 does not have the capacity to handle the total production of all three models. As a result, at least some of the production must be routed to the other manufacturing plants. The following table shows the minimum production requirements for next month, the plant capacities in units per month, and the production cost per unit at each plant: Model Production Cost per Unit Minimum Production Requirements Plant 1 Plant 2 Plant 3 Plant 4 A $25 $28 $37 $34 48,000 B $26 $35 $36 $41 75,000 C $20 $31 $26 $23 60,000 Production Capacity 65,000 50,000 32,000 43,000 Davison’s objective is to determine the cost-minimizing production planarrow_forward
- Anecdotally, entrepreneurs frequently encounter two critical dilemmas in managing human resources: the timing of hiring and the decision regarding hiring a generalist versus a specialist for their growing venture. Deciding when to expand a team is crucial, as premature hiring (i.e., hiring too soon) can strain resources, while delayed hiring (i.e., hiring too late) might hinder growth opportunities. Moreover, the choice between hiring a generalist or a specialist depends on the specific needs and stage of the venture, with each option presenting distinct advantages and challenges. To address these issues, a management scholar seeks to identify the factors shaping the hiring cycle throughout the entrepreneurial journey and to understand the criteria for choosing between generalists and specialists at various stages of a venture. The scholar has assembled a sample of 20 experienced South African entrepreneurs who have encountered both failure and success in the financial technology…arrow_forward3. [25 pts.] Four projects are available for investment. The projects require the cash flows and yield the net present values (NPV) (in millions) shown in the following table. Project id. 1 2 Cash outflow at time 0 (million Lira) 8 8 NPV (million Lira) 12 11 3 4 6 5 8 6 If 20 million Lira is available for investment at time 0, find the investment plan that maximizes NPV. All investments are required to be 0 or 1 (fractional investment values are not permitted). a. Formulate the mathematical model. (Write the decision variables, objective function and the constraints.) [10 pts.] b. Find the optimal solution by using Branch and Bound method (Draw the branch and bound tree clearly, write also lower bounds(LB)) (Left branches x=0, right branches x =1) [15 pts.].arrow_forwardexamine the production concept and operations management, what are the key steps required to achieve success? Be specific in your response.arrow_forward
- Produce a 3000 report with references on one international organization of your choice and Address the following: Provide a brief introduction of the organisation and sector it operates in, including its mission and vision statements, its core values, a summary of its financial performance and a general overview of the business’s operational activities. From the relevant literature explain the Total Quality Management (TQM) processes the chosen organization follows and identify one quality challenge/issue that the organization faced or is currently facing. Explain how the organization managed/or still managing the particular quality challenge/issue. Critically analyze whether the organization failed or succeeded in achieving and maintaining quality performance. Provide a few critical recommendations for business managers in order to highlight the importance of Total Quality Management (TQM) within an organization.arrow_forward問題2 Production system design involves determining the arrangement of workstations and the... O allocation of resources to workstations design of the process O production schedule all of the abovearrow_forwardElaborate on the need for and the benefits of an effective supply chain management (SCM) system in the context of a globalized and networked economy. In your answer, explain how organizations like Dell and Hewlett-Packard leverage supply chain networks to maintain competitiveness, and analyse the impact of globalization, technological advancements, and business environment changes on supply chain structures. Additionally, evaluate the key components of SCM, including distribution network configuration, inventory management, and cash-flow management, and discuss how these components contribute to creating an effective and integrated supply chain. (15) 3.2. Critically evaluate the requirements for effective inventory management within an organization. In your answer, discuss the importance of inventory accounting systems, the role of cost information (holding, ordering, and shortage costs), and the significance of classification systems like ABC analysis. Additionally, analyse how…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License