Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 13.7, Problem 26P
The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency.
- a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best
forecasting model? Why? - b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1.
- c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Question content area
Part 1
Oakwood Hospital is considering using ABC analysis to classify laboratory SKUs into three categories: those that will be delivered daily from their supplier (Class A items), those that will be controlled using a continuous review system (B items), and those that will be held in a two bin system (C items).
The following table shows the annual dollar usage for a sample of eight SKUs. Fill in the blanks for annual dollar usage below. (Enter your responses rounded to the nearest whole number.)
Part 2
Rank the SKUs in descending order on the basis of their annual dollar usage and fill in the table with the ranked SKU's percentage of dollar usage. (Enter your responses rounded to two decimal places.)
Sam's Pet Hotel operates 51 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag.
The following information is available about these bags:
> Demand 70 bags/week
> Order cost $58.00/order
> Annual holding cost 30 percent of cost
> Desired cycle-service level = 80 percent
>Lead time 4 weeks (24 working days)
> Standard deviation of weekly demand = 15 bags
> Current on-hand inventory is 320 bags, with no open orders or backorders.
a. Suppose that the weekly demand forecast of 70 bags is incorrect and actual demand averages only 45 bags per week. How much higher will total
costs be, owing to the distorted EOQ caused by this forecast error?
The costs will be $ higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)
a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is
$enter your response here. (Enter your response as a whole
number.)
b. The aggregate inventory value of the product if Ruby-Star used vendor 2 exclusively is shown below.
c. How would your analysis change if average weekly demand increased to 160 units per week? The aggregate inventory values are shown below.
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
- a. What order quantity should be used? lures. (Enter your response rounded to the nearest whole number.) b. What reorder point should be used? (Enter your response rounded to the nearest whole number.) c. What is the total annual cost for this inventory system? (Enter your response rounded to two decimal places)arrow_forwardOakwood Hospital is considering using ABC analysis to classify laboratory SKUS into three categories: those that will be delivered daily from their supplier (Class A items), those that will be controlled using a continuous review system (B items), and those that will be held in a two bin system (C items). The following table shows the annual dollar usage for a sample of eight SKUS. Fill in the blanks for annual dollar usage below. (Enter your responses rounded to the nearest whole number.) SKU Unit Value Demand (units) Annual Dollar Usage 1 $1.10 30,000 $ 2 $0.02 125,000 $ 3 $0.20 65,000 S 4 $0.02 1,100 SA 5 $1.40 150 SA 678 $4.10 900 $ $0.80 350 $ $0.55 80 EA $arrow_forwardDyson, a high-tech home appliance maker, has cut ties with Malaysian supplier ATA IMS Bhd following an audit of the company's labour practices and allegations by a whistleblower. ATA is already under US investigation over forced labour allegations. Dyson has terminated its contracts and is in talks with its customer over the audit findings. ATA, which produces parts for Dyson's vacuum cleaners and air purifiers, tumbled 30% to its lowest since April 2020. The termination is a significant blow for Malaysia, a major electronics manufacturing hub, which has faced scrutiny this year over claims of abusive working and living conditions. Dyson terminated the relationship with six months' contractual notice, hoping it would give ATA the impetus to improve and enable an orderly withdrawal in the interests of the workers they employ. Former ATA worker Dhan Kumar Limbu was beaten by police in Malaysia after sharing information about conditions at the factory with activists. ATA denied all…arrow_forward
- Question 4 (25 Marks) Discuss how developing internal performance measures to track the performance of supplier development, can create efficiency for Pick n Pay.arrow_forwardLeadership and people Earlier this year, Pick n Pay actioned the first priority of the plan: the introduction of a new, simplified and seasoned leadership team with proven track records. The team has already implemented strengthened structures, including establishing regional trading areas with local decision-making, with clear sight of strong long-term succession Each operating region now has a regional buying team and store management team in place to meet specific customer needs particular to that region, while also increasing staff training and productivity for an overall improved store experience. Reset the store estate To create a more sustainable supermarket business, the Group is resetting its store estate to minimise losses by creating a smaller but more profitable Pick n Pay store estate. The plan is to leverage the strength of its multi-format model with strategic conversions to lift store profitability: selected Pick n Pay stores will be converted to Boxer, where customer…arrow_forwardQuestion 3 (25 Marks) Elaborate on how Pick n Pay could use information technology and ERP systems across the company and their suppliers to improve their operating model? Question 4 (25 Marks)arrow_forward
- Question 2 (25 Marks) Discuss how you would "reset the store estate" to remain competitive and relevant in the market? Question 3 (25 Marks)arrow_forwardWhat should leaders do after conducting an employee survey? take immediate action on results take at least 6 months to review the results to make sure the leader understands them review them immediately, but do not take action right away keep results confidential from employeesarrow_forwardOne of the best ways to encourage teamwork is to: continually promote from outside of the department recognize employees who focus on their personal performance goals only reward employees who complete their own tasks and also assist with problems outside of their department discuss individual performance issues at staff meetingsarrow_forward
- What can happen if a leader doesn't encourage teamwork? team members will support each other more the environment can become overly competitive and hostile turnover will descrease team members become more motivatedarrow_forwardunderstand 4 Classwork LSC Drag the name of the figure of speech to its example. 12 February 2025 personification Onomatopoeia Simile Metaphor Hyperbole Onomatopoeia metaphor 1. He tried to help but his legs were wax. Metaphor 2. The man flights like a lion on the soccer field. Simile 3. The books fell on the table with a loud thump. Onomatopoeia 4. Rita heard the last piece of pie calling her name. Personification 5. The rustling leaves kept me away. Personification 6. Kisses are the flowers of affection. 7. He's running faster than the windarrow_forwardAnswer the question in the attached photo and draw the network that interprets the dataarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
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