Corporate triple-A bond interest rates for 12 consecutive months follow. 9.6 9.4 9.5 9.7 9.9 9.8 9.8 10.6 10.0 9.8 9.6 9.6 (b) Develop three-month and four-month moving averages for this time series. (Round your answers to two decimal places.) Month Time SeriesValue 3-Month MovingAverage Forecast 4-Month MovingAverage Forecast 1 9.6 2 9.4 3 9.5 4 9.7 5 9.9 6 9.8 7 9.8 8 10.6 9 10.0 10 9.8 11 9.6 12 9.6 (c) Using the more accurate forecast, what is the moving average forecast for the next month? (Round your answer to two decimal places.)

Corporate triple-A bond interest rates for 12 consecutive months follow. 9.6 9.4 9.5 9.7 9.9 9.8 9.8 10.6 10.0 9.8 9.6 9.6 (b) Develop three-month and four-month moving averages for this time series. (Round your answers to two decimal places.) Month Time SeriesValue 3-Month MovingAverage Forecast 4-Month MovingAverage Forecast 1 9.6 2 9.4 3 9.5 4 9.7 5 9.9 6 9.8 7 9.8 8 10.6 9 10.0 10 9.8 11 9.6 12 9.6 (c) Using the more accurate forecast, what is the moving average forecast for the next month? (Round your answer to two decimal places.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Month	Time Series Value	3-Month Moving Average Forecast	4-Month Moving Average Forecast
1	9.6
2	9.4
3	9.5
4	9.7
5	9.9
6	9.8
7	9.8
8	10.6
9	10.0
10	9.8
11	9.6
12	9.6

Similar questions

The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
constants of .6 and .9, develop fo recasts for the sales of VWBeetles. What effect did the smoothing constant have on the forecast?Use MAD to deternline which of the three smoothing constants (.3,.6, or .9) gives the most accurate forecast. ~ (MyLab OperationsManagement also includes a shorter (brief) version of this problem.)
formula refers Naive Forecast method. O a. Forecast value for the current period = Last period actual value O b. Last period forecast demand value = Actual value for the current period O c. Ratio of Actual value / Forecast value O d. Sum of all data / number of data
b. Kim’s department at a local department store has tracked the sales of a product over thelast nine weeks. The demand can be seen in the table below.Period Demand1 242 233 264 365 266 307 328 269 25i. Forecast demand using exponential smoothing with an alpha of 0.3, and an initialforecast of 30.0 for period 2 to 9.ii. Use a 5-period moving average, forecast the demand up to period 9.iii. Using MAD, determine which forecasting technique is better.
4. What is the difference between trend and seasonality in time series data? 5. Here are the errors associated with a particular forecast over the past 5 months, in chronological order: 5, 10, -15, 0, 8. In which month was the forecast perfectly accurate? In which month was the forecast the least accurate? In which month or months was the forecast too high? (Noteshaper Ramp Up # 23) 6. Tutoring Center needs to allocate tutors this week for office appointments, so it needs to forecast the number of students who will seek appointments. The director has gathered the following time series data recently: Time Period Code Student Appointments Jan 6 - 10 95 Jan 13 - 17 80 Jan 20 - 24 65 Jan 27 – 31 4 50 a) What is the naïve forecast for the number of student appointments for Time Period 5 (Feb 3– 7)? b) What is the 2 week moving average for Time Period 5? c) What is the 3 week moving average for Time Period 5? d) What is the forecast for Time Period 5 using exponential smoothing with alpha =…
Accuracy of forecasts. The manager of a large manufacturer of industrial pumps must choose betweentwo alternative forecasting techniques. Both techniques have been used to prepare forecasts for a sixmonth period. Using MAD as a criterion, which technique has the better performance record?FORECASTMonth Demand Technique 1 Technique 21 492 488 4952 470 484 4823 485 480 4784 493 490 4885 498 497 4926 492 493 493
tions Management Spring21 Time left 0:30:19 Qui The sales of XYZcompany for the previous three periods are 45, 42, and 43 respectively. Estimate the sales of the fourth period by exponential smoothing with 0.5. Use naïve as a starting/initial forecast (Round to 2 decimals) O a. 42.8 O b. 41 Mar O C. None is correct 12- O d. 43.25 O e. 41.92 S PAGE NEXT PAGE Finish TOSHIBA F11 F17 F9 F10 F6 F7 F8 F5 F3 F4 60 AH
Source Available at: http://panmore.com/walmart-inventory-management [Accessed 18 July 2022] Reading the above, it becomes clear that good inventory management and forecasting can deliver supply chain success for and could ultimately lead to profitability and growth. In a report you are required to evaluate the importance of forecasting for Walmart Your report, must include but is limited to the following: • The importance of forecasting to Walmart. • Examine if a combination of both qualitative and quantitative forecasting may be best suited. • Argue the relevance of cloud-based forecasting for Walmart. NB: • The marks allocated next to each concept in the rubric below should serve only as a guide to the depth your discussion should cover. Your answer should be a minimum of 1 200 to a maximum of 1 500 words. Markers are to stop marking after the threshold of 1 500 words (two-and-a-half to three pages) has been reached. Please indicate the word count at the end of your answer. • You…
Part C Exponential Exponential Gasoline Demand Gasoline Month smoothed forecast smoothed forecast Exponential smoothed forecast (a = 0.25) Demand (a = 0.25) (a = 0.45) Exponential smoothed forecast (a = 0.45) Mar 900 920 920 1200 Apr May 755 915.00 911.00 1100 1000 650 875.00 840.80 g20 915.00 846 80 755 818.75 754.94 904.76 835.12 Jun 550 818.75 754.94 800 320 751.56 66272 645.74 746.83 Jul 625 751.56 662.72 650 600 550 Aug Sep 730 719.92 645.74 820 722.44 683.66 400 D Oct 1100 746.83 745.01 200 1 Nov 835.12 904.76 Mar Apr May Jun Jul Aug Sep Oct Nov 1. Make a comparative analysis out of your answers in the plotted data. (3-5 5 sentences)
Forecast is calculating estimates of future cycle/s based on data of past cycles, there is no ............. time interval in forecasting. Fill in the blank.
Forecast deliveries for one of Cadbury Schweppes' subsidiaries for period 10 using the exponential smoothing with trend adjustment method. Let the beginning trend value be 4 and the initial prediction be 200, and set alpha and beta to 0.4 and 0.2, respectively. Period 01 = Actual Demand 200 Period 02 = Actual Demand 212 Period 03 = Actual Demand 214 Period 04 = Actual Demand 222 Period 05 = Actual Demand 236 Period 06 = Actual Demand 221 Period 07 = Actual Demand 240 Period 08 = Actual Demand 244 Period 09 = Actual Demand 250 Period 10 = Actual Demand 266
4, The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. Complete the exponential smoothing forecast model for stock B. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast B 09/03/2010 09/07/2010 enter your response here 09/08/2010 enter your response here 09/09/2010 enter your response here 09/10/2010 enter your response here 09/13/2010 enter your response here 09/14/2010 enter your response here 09/15/2010 enter your response here 09/16/2010 enter your response here 09/17/2010 enter your response here 09/20/2010 enter your response here 09/21/2010 enter your response here Date A B C D Stock Exchange 09/03/2010 127.07 18.54 20.84 15.44 10,536.56 09/07/2010 124.84 18.21 20.45 15.55 10,245.77 09/08/2010 125.67 17.77 20.83 15.72…