Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Related questions
Question
thumb_up100%
Given:
Year Demand
1 7
2 9
3 5
4 9
5
Predict the value for Year 5:
- 2 year moving average
- What is MSE for 2 year moving average?
- 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period
- Exponential smoothing, =0.2 and
forecast for Year 1 = 5 - Linear trend
- Which forecast method has the least amount of error using MAD?
- What is the coefficient?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 7 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Need help with discerning the coefficient of determination or r^2 for question number 7.
Solution
by Bartleby Expert
Follow-up Question
Can you please demonstrate #7 how to identify the coefficient?
Given:
Year Demand
1 7
2 9
3 5
4 9
5
Predict the value for Year 5:
- 2 year moving average
- What is MSE for 2 year moving average?
- 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period
- Exponential smoothing, =0.2 and
forecast for Year 1 = 5 - Linear trend
- Which forecast method has the least amount of error using MAD?
- What is the coefficient?
Solution
by Bartleby Expert
Follow-up Question
*** Can you please demonstrate how to do parts d, e, f?
Given:
Year Demand
1 7
2 9
3 5
4 9
5
Predict the value for Year 5:
- 2 year moving average
- What is MSE for 2 year moving average?
- 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period
- Exponential smoothing, =0.2 and
forecast for Year 1 = 5 - Linear trend
- Which forecast method has the least amount of error using MAD?
- What is the coefficient?
Solution
by Bartleby Expert
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Need help with discerning the coefficient of determination or r^2 for question number 7.
Solution
by Bartleby Expert
Follow-up Question
Can you please demonstrate #7 how to identify the coefficient?
Given:
Year Demand
1 7
2 9
3 5
4 9
5
Predict the value for Year 5:
- 2 year moving average
- What is MSE for 2 year moving average?
- 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period
- Exponential smoothing, =0.2 and
forecast for Year 1 = 5 - Linear trend
- Which forecast method has the least amount of error using MAD?
- What is the coefficient?
Solution
by Bartleby Expert
Follow-up Question
*** Can you please demonstrate how to do parts d, e, f?
Given:
Year Demand
1 7
2 9
3 5
4 9
5
Predict the value for Year 5:
- 2 year moving average
- What is MSE for 2 year moving average?
- 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period
- Exponential smoothing, =0.2 and
forecast for Year 1 = 5 - Linear trend
- Which forecast method has the least amount of error using MAD?
- What is the coefficient?
Solution
by Bartleby Expert
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
- sniparrow_forwardGive typed explanation Part 2: Using exponential smoothing, the forecasted demand for period 5 using the smoothing constant determined in image= ?arrow_forwardAsvnch Problem - Statistical Forecasting Data Set – Eunice BC Fashion Monthly Sales, in million units. Year Total Sales Year Total Sales 2010 38 2016 43 2011 41 2017 40 2012 40 2018 45 2013 45 2019 47 2014 50 2020 42 2015 42 2021 48 Questions: a. Find the naïve forecast. b. Use the 3 years moving average forecast. c. Have a 5 years weighted moving average. d. Develop forecast using exponential smoothing with a = 0.2. e. Determine the trend line equation and present the forecast. f. Find the best forecast for year 2022. Note: Use the first 5 years as the training samples and the last 5 years as the forecasting samples. Solve it in Excel Sheet/Sheet with Equations as possible.arrow_forward
- Following table shows the monthly sales of X-box consoles at a retail store in Kuwait: Answer the following questions based on the data given above. Show your calculations. a. What is the expected sales for the 8th month based on 3 period moving average? b. What is the expected sales for the 8th month based on exponential smoothing with α =0.2? c. Which of the above two forecasting method is better based on MSE?arrow_forwardGiven the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——arrow_forwardGiven the following historical data, what is the simple three-period moving average forecast for period 6? Period 1 2 3 4 5 67.67 68.2 67.3 68.4 Value 73 66 64 73 66arrow_forward
- A forecasting method has produced the following over the past five months. What is the mean absolute percentage error (MAPE)? Actual 11 OA. 0.00% B. 31.87% 5178 11 13 Forecast 13 10 30668 $7arrow_forwardGiven the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——arrow_forwardWeekly income for Quiet Mental Breakdown, an online psychology firm, is provided below. Determine, on the basis of minimizing the mean square error, whether a three-period or four-period simple moving average gives a better forecast. Week Income 1 980 2 1040 3 1120 4 1050 5 960 6 990 7 1030 8 1260 9 1240 10 1100 Group of answer choices Both the four-period & three-period simple moving averages have the same forecast accuracy in terms of their MSE There is not enough information to determine the answer The four-period simple moving averages gives a better forecast because it has the smallest MSE The three-period simple moving average gives a better forecast because it has the smallest MSEarrow_forward
- Forecasting with Linear Regression The company VID-CO-19 has manufactured swim suits for men, women, and children for 10 years. The company is located in Boston, Massachusetts. Swim suits have always had a higher demand during the months of April, May, June, July, August, and September. The demand has always been lower during the months of October, November, December, January, February, and March. TETT The real demand, based on sales of year 20X1 is the following (it starts with December of the previous year): Period Bimester Demand Season Average December-January February-March 1 100 90 2 200 180 3 April-May June-July August-September 900 910 4 3,000 2,100 4,000 4,900 October-November 300 350 VID-CO-19 has hired you as an Operations Management expert to help them to forecast demand for year 20X2 using the Linear Regression Method. What is the TOTAL "seasonalized" or "deseasonalized' forecasted demand for Quito-Ecuador in year 20X2? (write your answer rounded to two decimals)arrow_forward41) A medium-term forecast is considered to cover what length of time? A) 2-4 weeks B) 1 month to 1 year C) 2-4 years D) 5-10 years E) 20 years 42) When is the exponential smoothing model equivalent to the naïve forecasting model? A) ? = 0 B) ? = 0.5 C) ? = 1 D) during the first period in which it is used E) never 43) Enrollment in a particular class for the last four semesters has been 120, 126, 110, and 130. Suppose a one-semester moving average was used to forecast enrollment (this is sometimes referred to as a naïve forecast). Thus, the forecast for the second semester would be 120, for the third semester it would be 126, and for the last semester it would be 110. What would the MSE be for this situation? A) 196.00 B) 230.67 C) 100.00 D) 42.00 E) None of the above 44) Which of the following methods tells whether the forecast tends to be too high or too low? A) MAD B) MSE C) MAPE D) decomposition E) bias 45) Assume that you have tried three different…arrow_forwardGiven the following original forecast and actual data: Month Actual Forecast Jan Feb Mar Apr May Jun Jul 600 475 550 575 688 649 ??? 400 —— 1 ??? Using exponential smoothing with a - = 0.64, what is the forecast for July. Round your answer to 2 decimal places.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,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education 
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.