Given the following historical data, what is the moving-average forecast for period 6 based on the last three periods?

Period Value

1 33

2 28

3 25

4 32

5 27

Did is solve correctly I tried it in excel is 29.5 correct

or do avg(25+32+27)/3 =29

Please advise?

### Want to see the full answer?

Check out a sample Q&A here*arrow_forward*Check out a sample Q&A here

*star_border*

## Related Operations Management Q&A

Find answers to questions asked by students like you.

Q: 2. Seasonality Index table Period Year Seasonality Index (SI) 2021-period 1 2021-period 2…

A: Since the first question is incomplete we have answered the second question with the available data…

Q: If the forecasted demand for the week of August 31 is 360 and α = 0.20, using exponential…

A: Sept. 7 forecast = Aug. 31 forecast + alpha (Aug. 31 demand- Aug. 31 forecast) Sept. 7 forecast =…

Q: Choose the type of forecasting technique (survey, Delphi, averaging, seasonal, naive, trend,…

A: Forecasting techniques are used to predict the future on the basis of past and present data.…

Q: Given forecast errors of 4, 8, and −3, what is the mean absolute deviation (MAD) and mean square…

A: Forecast errors = 4,8 and -3 Absolute errors = 4, 8 and 3

Q: Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 18 15 Using the…

A: The naïve method of forecasting uses the value of the previous week as the current week's forecast.…

Q: The demand for Krispee Crunchies, a favorite breakfast cereal of people born in the 1940s, is…

A: Click to see the answer

Q: a. Predict the sales for Jasmine Slush using the following forecasting methods: - naïve (use simple…

A: Forecasting is to predict the uncertain future of demand and sales. There are various methods to do…

Q: Your manager is trying to determine what forecasting method to use. Based on the following…

A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…

Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…

A: Click to see the answer

*question_answer*

Q: Apply the 3-years moving average method to forecast the required demand for the year 2021 from the…

A: Years Demand 2012 245 2013 325 2014 300 2015 350 2016 295 2017 400 2018 450 2019 380…

*question_answer*

Q: Given the following history, use a three-quarter moving average to forecast the demand for the third…

A: Given data is

*question_answer*

Q: Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last…

A: Find the Given details below: Given details: Month Price Per Chip ($) January 1.90 February…

*question_answer*

Q: Compute a 3-month weighted average forecast for months 4 through 9. Assign weights of 0.55, 0.33 and…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. There are…

*question_answer*

Q: Use exponential smoothing with a=0.2 and a=0.5 to generate forecasts for periods 2 through 6. Use…

A: Click to see the answer

*question_answer*

Q: The following are monthly actual and forecast demand levels for May through December for units of a…

A: Forecast Error = Actual Demand - Forecast Demand Absolute Error = Positive value of Forecast Error

*question_answer*

Q: You work for BMW as a planner. BMW is expecting to increase its annual sales for BMW- X5 in year…

A: BMW-X5 sales are increasing by 10% every quarter looking at as per the given data. let us clarify…

*question_answer*

Q: I'm trying to forecast how many TV's my shop will sell in 2021. I have data for the previous 4…

A: Forecasts generated applying exponential smoothing techniques are weighted averages of preceding…

*question_answer*

Q: (Round your answers to 2 decimal places.) Complete the table above, filling in the "Forecast for…

A: Forecast refers to the estimation of the future happening according to the previous and current data…

*question_answer*

Q: Demand and forecast for 5 months are given below: Month Demand Forecast 1 50 46 2 52 52 3…

A: Tracking Signal is used to determine the larger deviation (in both plus and minus) of Error in…

*question_answer*

Q: The sales of XYZ company for the previous three periods are 45, 42, and 43 respectively. Estimate…

A: The following is the data provided: Period Data January 45 February 42 March 43 The…

*question_answer*

Q: Given the actual demand for years 2013/14, calculate the total forecast for year 2015, as well as…

A: Below is the solution:-

*question_answer*

Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…

A: Click to see the answer

*question_answer*

Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…

A: Given that: Year Sales Forecasted Sales 2005 455 415 2006 510 427 2007 516 451.9 2008 570…

*question_answer*

Q: Given the following historical data, what is the moving-average forecast for period 6 based on the…

A: Determine the moving-average forecast for Period 6 based on the last three period:

*question_answer*

Q: Given the following data, use exponential smoothing with a = 0.1 and a = 0.6 to generate forecasts…

A: Given data a=0.1 and 0.6 as smoothing constants MAD AND MSE which is better Exponential smoothing…

*question_answer*

Q: With a = 0.1 and the initial forecast for October of $1.83, using exponential smoothing, the…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

*question_answer*

Q: 4. What is the forecast for the 13th period based on the four-period moving average? Round your…

A: Given data is

*question_answer*

Q: B). Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. The smoothing…

A: Find the Calculations below: Formulas:

*question_answer*

Q: National Standard, Inc. sells radio frequency identification (RFID) tags. Monthly demand for a…

A: Note: - Since we only answer up to 3 sub-parts, we’ll answer the first3. Please resubmit the…

*question_answer*

Q: Corporate triple-A bond interest rates for 12 consecutive months follow. Month 1 2 3 4 5 6 7 8 9 10…

A: a)

*question_answer*

Q: c. Using simple exponential smoothing, what would your forecast be for this month if the…

A: Click to see the answer

*question_answer*

Q: Sales of Volkswagens have grown steadily at auto dealerships in Nevada during the past 5 years (see…

A: Given data is

*question_answer*

Q: 1. What is the tracking signal for the forecast?

A: Forecasting is the process of predicting future demand according to the previous information or…

*question_answer*

Q: Explain the difference between qualitative and quantitative approaches to forecasting. Describe…

A: Forecasting is the method of forming foresight dependent on historical and existing or present…

*question_answer*

Q: a. Forecast April through September using a three-month moving average. b. Use simple exponential…

A: Below is the solution:-

*question_answer*

Q: A manager uses this equation to predict demand for landscaping services: Ft= 10 + 5t. Over the past…

A: Click to see the answer

*question_answer*

Q: Consider the following time series data. Choose the correct time series plot. (i) (ii)…

A: A time series is a grouping of information focuses that happen in progressive requests throughout…

*question_answer*

Q: onsider the following time series data. Week 1 2 3 4 5 6 Value 18 12 15 11 18 13 Using the…

A: Given that: Week Value 1 18 2 12 3 15 4 11 5 18 6 13

*question_answer*

Q: 2. Using the same table above, compute the weighted moving average forecast for demand for four…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

*question_answer*

Q: Develop a three-week moving average. A.What is the forecast for week 5? (Make sure no decimal place…

A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…

*question_answer*

Q: Assume that the initial forecast for February is $85,000 and the initial trend adjustment is 0. The…

A: Unadjusted forecast = alpha*actual income of previous period+(1-alpha)*forecast of the previous…

*question_answer*

Q: Using an exponential smoothing model with an alpha value of 0.30, estimate the smoothed value…

A: Below is the solution:-

*question_answer*

Q: a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a…

A: ANSWER IS AS FOLLOWS:

*question_answer*

Q: Use the following information to compute a single exponential smoothing model forecast with a…

A: From the above information, Let, Forecast for period 1 =f1 =115 Actual value for period 1 =a1…

*question_answer*

Q: 2017 2019 2018 89 59 24 Summer 56 78 Fall Winter Spring 88 52 71 48 82 69 79 Using the table above…

A: Given Data-

*question_answer*

Q: State and describe the forecasting technique which places more emphasis on recent values and explain…

A: To be determined: the forecasting technique which places more emphasis on recent values and explains…

*question_answer*

Q: What is the expected sales for the 7th week based on 3 period moving average. What is the forecast…

A: Forecasting is the process of predicting the future demand using previous or historic information.

*question_answer*

Q: Calculate and answer parts a through d. Include all calculations and spreadsheets in your post.…

A: Formula: Answer:

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_forward*

*arrow_back_ios*

- SEE MORE QUESTIONS

*arrow_forward_ios*