EBK OM
6th Edition
ISBN: 9781305888210
Author: Collier
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 5PA
Summary Introduction
Interpretation: The best smoothing constant needs to be determined by evaluating the MSE .
Concept Introduction: Single Exponential Smoothing is a method which computes the weighted average of previous sales data to forecast the future sales value.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Define the term Exponential smoothing?
What effect does the value of the smoothing constant have on the weight given to the recent values?
How is the moving average approach equivalent to exponential smoothing?
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
- Explain how is the moving average equivalent to exponential smoothing ?arrow_forwardExplain how does adjusted exponential smoothing different from exponential smoothing?arrow_forwardPlease use an exponential smoothing method with a=.3 and a 2011 forecast of 35 to forecast the mileage for 2013? Keep two decimal places.arrow_forward
- Step 1 of 4: Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place. Step 2 of 4: Determine the three-period weighted moving average for the next time period with weights of 33 (most recent), 22 (second latest time period), and 11 (oldest time period). If necessary, round your answer to one decimal place. Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.500.50. If necessary, round your answer to one decimal place. Step 4 of 4: Which forecasting method is best and why?arrow_forwardA retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the single exponential smoothing forecast and answer the following questions. 1. What is the forecast for the 13th period based on the single exponential smoothing? Round your answer to two decimal places. 2. What is the MSE for the single exponential smoothing forecast? Round your answer to two decimal places.arrow_forwardHow is exponential smoothing superior to moving averages as a forecasting tool?arrow_forward
- A restaurant wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown below. Use Excel and the Moving Averagetemplate to answer the following questions. Time Period Observation 1 1,536 2 1,521 3 1,403 4 1,250 5 1,142 6 1,313 7 1,501 8 1,301 9 1,289 10 1,521 11 1,472 12 1,500 13 1,654 14 1,569 15 1,300 Plot the data and provide insights about the time series. The correct graph is -Select-graph Agraph Bgraph Cgraph DItem 1 . A. B. C. D. What is the forecast for week 16, using a two-period moving average? Round your answer to the nearest cent. $ What is the forecast for week 16, using a three-period moving average? Round your answer to the nearest cent. $ Compute MSE for the two- and three-period moving average models to determine the best model. Do not round intermediate calculations. Round your answers to two decimal places. 2-period MA…arrow_forwardWhat are the advantages of exponential smoothing over the moving average and the weighted moving average?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Forecasting 2: Forecasting Types & Qualitative methods; Author: Adapala Academy & IES GS for Exams;https://www.youtube.com/watch?v=npWni9K6Z_g;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