Practical Management Science
6th Edition
ISBN: 9781337671989
Author: WINSTON
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 13.3, Problem 10P
Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excel’s Trend line options.)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Discuss how training and development programs can be best presented to ultimately change the behavior of employees, often without their knowledge or awareness.
Doctor E
Considering contemporary challenges in business, analyze a real-world case where a company successfully navigated a major shift in its marketing strategy to adapt to changing market dynamics.
Discussion Question and Prompt:
Identify the key factors that contributed to the success of their marketing strategy in the face of contemporary issues.
How can businesses draw insights from this case to inform their own marketing strategies amid current business challenges?
Chapter 13 Solutions
Practical Management Science
Ch. 13.3 - The file P13_01.xlsx contains the monthly number...Ch. 13.3 - The file P13_02.xlsx contains five years of...Ch. 13.3 - The file P13_03.xlsx contains monthly data on...Ch. 13.3 - The file P13_04.xlsx lists the monthly sales for a...Ch. 13.3 - Management of a home appliance store wants to...Ch. 13.3 - Do the sales prices of houses in a given community...Ch. 13.3 - Prob. 7PCh. 13.3 - The management of a technology company is trying...Ch. 13.3 - Prob. 9PCh. 13.3 - Sometimes curvature in a scatterplot can be fit...
Ch. 13.4 - Prob. 12PCh. 13.4 - A trucking company wants to predict the yearly...Ch. 13.4 - An antique collector believes that the price...Ch. 13.4 - Stock market analysts are continually looking for...Ch. 13.4 - Suppose that a regional express delivery service...Ch. 13.4 - The owner of a restaurant in Bloomington, Indiana,...Ch. 13.6 - The file P13_19.xlsx contains the weekly sales of...Ch. 13.6 - The file P13_20.xlsx contains the monthly sales of...Ch. 13.6 - The file P13_21.xlsx contains the weekly sales of...Ch. 13.6 - The file P13_22.xlsx contains total monthly U.S....Ch. 13.7 - You have been assigned to forecast the number of...Ch. 13.7 - Simple exponential smoothing with = 0.3 is being...Ch. 13.7 - The file P13_25.xlsx contains the quarterly...Ch. 13.7 - The file P13_26.xlsx contains the monthly number...Ch. 13.7 - The file P13_27.xlsx contains yearly data on the...Ch. 13.7 - The file P13_28.xlsx contains monthly retail sales...Ch. 13.7 - The file P13_29.xlsx contains monthly time series...Ch. 13.7 - A version of simple exponential smoothing can be...Ch. 13 - Prob. 31PCh. 13 - Prob. 32PCh. 13 - Management of a home appliance store would like to...Ch. 13 - A small computer chip manufacturer wants to...Ch. 13 - The file P13_35.xlsx contains the amount of money...Ch. 13 - Prob. 36PCh. 13 - Prob. 37PCh. 13 - Prob. 39PCh. 13 - The Baker Company wants to develop a budget to...Ch. 13 - Prob. 41PCh. 13 - The file P13_42.xlsx contains monthly data on...Ch. 13 - Prob. 43PCh. 13 - Prob. 44PCh. 13 - Prob. 45PCh. 13 - Prob. 46PCh. 13 - Prob. 49P
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
- 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…arrow_forwardAnswer all parts to question 4 and show all workingarrow_forward1) 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…arrow_forward
- 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 managementarrow_forwardWhat 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 managementarrow_forwardThis 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_forward
- Emotional 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_forwardAt 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_forward
- Community 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_forwardAnecdotally, 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_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