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
A certain business process is no longer providing the desired benefits, therefore it needs to be re-designed through a project. You have to:
Choose the business process to re-design and specify the reason why it is no longer satisfactory.
Ask ChatGPT (or a similar generative AI; specify name and version) to create a Project Charter for the process redesign project.
Modify and refine the response provided by the AI tool ensuring it complies with the instructor’s lesson, with particular focus on the project goals, project objectives, and deliverables (remember: project objectives must be SMART!).
Your work must be delivered in the following format:
a)Describe the business process to re-design (example: “The process of hiring and integrating new employees into the Sales Administration department”. Do not exceed 20 words)
b)Specify the reason to re-design the business process which is already in place (describe the reason why the current process is no longer satisfactory, for…
The demand for subassembly S is 100 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 1 unit of V, 2 units of W, and 1 unit of X. Finally, each unit of U
requires 2 units of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make V, 3 weeks to make W, 1 week to
make X, 2 weeks to make Y, and 1 week to make Z.
Click the icon to view the product structure and the time-phased product structure.
Click the icon to view the on-hand inventory.
Construct a net material requirements plan using on-hand inventory (enter your responses as whole numbers).
Item
1
2
3
Week
4
Lead Time
5
6
7
(weeks)
S
Gross req
On hand
Net req
Order receipt
Order release
T
Gross req
On hand
Net req
Order receipt
Order release
Gross rea
100
100
It is January 1 of year 0, and Merck is trying to determine whether to continue development of a newdrug. The following information is relevant. You can assume that all cash flows occur at the ends of therespective years.■ Clinical trials (the trials where the drug is tested on humans) are equally likely to be completed in year1 or 2.■ There is an 80% chance that clinical trials will succeed. If these trials fail, the FDA will not allow thedrug to be marketed.■ The cost of clinical trials is assumed to follow a triangular distribution with best case $100 million,most likely case $150 million, and worst case $250 million. Clinical trial costs are incurred at the end ofthe year clinical trials are completed.■ If clinical trials succeed, the drug will be sold for five years, earning a profit of $6 per unit sold.■ If clinical trials succeed, a plant will be built during the same year trials are completed. The cost of theplant is assumed to follow a triangular distribution with best case $1…
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) Under “Costs of Quality”, costs associated with quality can be classified into four categories: appraisal, prevention, internal failures, and external failures. The costs of quality for Corley Motors Logistics is given in the table. Cost Elements Amount Checking outbound boxes for errors $31,000 Quality planning $10,625 Downtime due to conveyor/computer problems $342,125 Incoming product inspection $21,000 Customer complaint rework $33,000 Correcting erroneous orders before shipping $36,550 Quality training of associates $25,925 Correction of typographical errors--pick tickets $11,475 a) Classify the quality cost elements given in the table into the different quality cost categories (prevention, appraisal, internal failure, external failure). b) Total the quality costs in each of the different quality cost categories (prevention, appraisal, internal failure, external failure). c) Using a) and b), suggest which areas…arrow_forwardNote: In chapter 9, section 9.4 of the Stevenson text, the costs of quality are covered; chapter 9 Stevenson lecture power point slide 7 touches upon this topic; see lecture video, 3.55 mins to 4.54 mins. 2) The production process at Hansa Ceylon Coffee fills boxes with dark arabica coffee. The data for the fill weight (in ounces) of eight samples are presented below. A sample size of six was used. The firm’s operations analyst wants to construct X-bar and R-charts to monitor the filling process. Sample Sample Mean Sample Range 1 15.80 0.42 2 16.10 0.38 3 16.02 0.08 4 15.95 0.15 5 16.12 0.42 6 16.18 0.23 7 15.87 0.36 8 16.20 0.40 a) Calculate the upper and lower control limits for the X-bar chart. b) Calculate the upper and lower control limits for the R chart. c) Is the process under control? Why or why not? Note: In chapter 10, section 10.3 of the Stevenson text, control charts for variables are…arrow_forwardDo the inherent differences between private and public sector objectives—profit versus publicgood—render private sector category management practices unsuitable for public sectorpurchasing, where open tendering is the norm?You have now undergone the Category Management classes and your superiors have requestedfor your input on how to integrate some of the learnings into the public sector policy. Discuss and elaborate what are the activities and governance you would introduce in yourrecommendations without violating the principle of transparency and accountability withinyour organisation. This is based on Singapore context. Pls provide a draft with explanation, examples and useful links for learning purposes. Citations will be good too. This is a module in SUSS called category management and supplier evaluationarrow_forward
- Travelling and working internationally can lead to a life of adventure and unique career experiences. For businesses, selecting the right candidates to take on foreign assignments can propel, delay, or deny the success of the international ventures. As an international manager, identify key competencies you would look for in choosing expatriates. What might be some of their concerns in taking on overseas assignments? What are some best practices in supporting expats during and after their assignments?arrow_forwardTravelling and working internationally can lead to a life of adventure and unique career experiences. For businesses, selecting the right candidates to take on foreign assignments can propel, delay, or deny the success of the international ventures. As an international manager, identify key competencies you would look for in choosing expatriates. What might be some of their concerns in taking on overseas assignments? What are some best practices in supporting expats during and after their assignments?arrow_forwardI need answer typing clear urjent no chatgpt used pls i will give 5 Upvotes.arrow_forward
- I need answer typing clear urjent no chatgpt used pls i will give 5 Upvotes. Pls full explanationarrow_forwardCariveh Co sells automotive supplies from 25 different locations in one country. Each branch has up to 30 staff working there, although most of the accounting systems are designed and implemented from the company's head office. All accounting systems, apart from petty cash, are computerised, with the internal audit department frequently advising and implementing controls within those systems. Cariveh has an internal audit department of six staff, all of whom have been employed at Cariveh for a minimum of five years and some for as long as 15 years. In the past, the chief internal auditor appoints staff within the internal audit department, although the chief executive officer (CEO) is responsible for appointing the chief internal auditor. The chief internal auditor reports directly to the finance director. The finance director also assists the chief internal auditor in deciding on the scope of work of the internal audit department. You are an audit manager in the internal audit…arrow_forwardCariveh Co sells automotive supplies from 25 different locations in one country. Each branch has up to 30 staff working there, although most of the accounting systems are designed and implemented from the company's head office. All accounting systems, apart from petty cash, are computerised, with the internal audit department frequently advising and implementing controls within those systems. Cariveh has an internal audit department of six staff, all of whom have been employed at Cariveh for a minimum of five years and some for as long as 15 years. In the past, the chief internal auditor appoints staff within the internal audit department, although the chief executive officer (CEO) is responsible for appointing the chief internal auditor. The chief internal auditor reports directly to the finance director. The finance director also assists the chief internal auditor in deciding on the scope of work of the internal audit department. You are an audit manager in the internal audit…arrow_forward
- Please show all steps and answers, thank you!arrow_forwardI am not sure if this is correct, because 8 cannot go directly to 10.arrow_forwardA practical application in real life to the Critical Path Method is the construction of a bridge with references, give a detailed essay on the stages involved in constructing a bridgearrow_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