Jse the data set below to answer the following questions: Gunakan set data di bawah untuk menjawab soalan-soalan berikut: Table 1: Monthly sales unit IJadual 1: Unit juglan bulanau) Month Sales Units [Bulan] 1 [Unit Jualan] 1100 2 1200 3 1450 4 1800 2100 2700 Calculate the three-period simple moving average forecasts for months 4, 5 and 6. (Hitungkau ramalan 2AKata bergerak mudak menggunakan empat-tempoh untuk bulan 5 dan 6.) Calculate the four-period weighted moving average forecasts for months 5 and 6 using weights of 0.05, 0.15, 0.30, and 0.50 from the earliest period to the latest period,

Jse the data set below to answer the following questions: Gunakan set data di bawah untuk menjawab soalan-soalan berikut: Table 1: Monthly sales unit IJadual 1: Unit juglan bulanau) Month Sales Units [Bulan] 1 [Unit Jualan] 1100 2 1200 3 1450 4 1800 2100 2700 Calculate the three-period simple moving average forecasts for months 4, 5 and 6. (Hitungkau ramalan 2AKata bergerak mudak menggunakan empat-tempoh untuk bulan 5 dan 6.) Calculate the four-period weighted moving average forecasts for months 5 and 6 using weights of 0.05, 0.15, 0.30, and 0.50 from the earliest period to the latest period,

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

4. The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1 600 600 775 10 775 3 600 11 600 4 650 12 575 700 13 625 800 14 650 550 15 600 8 775 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.1. Which provides the better forecasts based on MSE? b. Find the forecast for the next month using the best forecast method. 2.
Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
A forecast for the first six months of the year revealed a tendency to underpredict the actual demand for the revitalized Hubig’s Pies plant in the Marigny. Month Actual Forecast January 675 600 February 720 700 March 640 620 April 510 495 May 480 410 June 565 535 What is the mean squared error of this forecast? a. 1,694 b. 1,873 c. 2,075 d. 1,469
Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 315 February 418 March 390 April 430 May 400 [ June 480 July 430 August 320 September 385 October 530 November 592 555 December 300 400 350 460 390 395 355 245 340 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Do the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.) Forecast for the fourth quarter
376.98 says its wrong
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of Pints Used August 31 September 7 September 14 September 21 September 28 345 372 408 383 368 October 5 378 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.25, and 0.60, using 0.60 for the most recent week, the forecasted demand for the week of October 12 = 376.25 pints (round your response to two decimal places and remember to use the weights in propriate order– the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 345 and a = 0.25, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places).…
Air travel on Mountain Airlines for the past 18 weeks was:Week Passengers1 4052 4103 4204 4155 4126 4207 4248 4339 43810 44011 44612 45113 45514 46415 46616 47417 47618 482a. Explain why an averaging technique would not be appropriate for forecasting.b. Use an appropriate technique to develop a forecast for the expected number of passengers forthe next three weeks.
I The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 Pints Used 345 389 412 383 366 371 a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal places and remember to use the weights in appropriate order recent period and smallest weight applies to oldest period.) the largest weight applies to most
Use = 0.2 to compute the exponential smoothing values for the time series. Forecast for Month 8. The forecast for Month 6 is 21. Month 1 2 3 4 5 6 7 Value 22 15 19 10 16 21 20
13. Two forecasting methods have been used to evaluate the same economic time series. The results are Forecast from Forecast from Realized Value Method 1 Method 2 of the Series 256 340 375 223 210 289 320 430 390 134 112 110 190 150 490 225 525 550 Compare the effectiveness of these methods by computing the MSE, the MAD, and the MAPE. Do each of the measures of forecasting accuracy indicate that the same forecasting technique is best? If not, why?
Asvnch 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.