Question

The following is the data for the number of complains a telephone company received during the...

The following is the data for the number of complains a telephone company received during the past 5 weeks for the service they offer. Use the data to forecast the number of complaints for week 6, based on the following methods:

Week Demand
1 111
2 100
3 105
4 112
5 114



Naive approach.
Simple moving average with span of 3.
Weighted moving average with weights of 0.55, 0.25, and 0.2.
Simple exponential smoothing with smoothing factor of 0.4.
Keep two decimal places in your calculations.

Week Forecast: Naïve Forecast: Simple Moving Average Forecast: Weighted Moving Average Forecast: Exponential Smoothing
1 -- -- -- --
2 -- -- --
3 -- -- --
4 -- -- --
5 -- -- --
6
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Naïve forecast is made by using the value for the previous period

3 period moving average is simply the average of the previous three periods

Weighted moving average is the multiplication of weights with the previous actual data.

Exponential smoothing uses the formula F2 = alpha*A1 + (1-alpha)*F1 where F1 and A1 are the forecast and demand for previous period respectively.

The calculated values are shown below

Week Demand Naïve SMA WMA ES
1 111 111
2 100 111 111
3 105 100 106.6
4 112 105 105.33 104.95 105.96
5 114 112 105.67 107.85 108.38
6 114 110.33 111.70 110.63
Add a comment
Know the answer?
Add Answer to:
The following is the data for the number of complains a telephone company received during the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The following is the data of recent refrigerator sales at a local Home Depot store. Month...

    The following is the data of recent refrigerator sales at a local Home Depot store. Month 1 2 3 4 5 Actual Sales 95 100 80 90 ??? Inputs will be exact numbers. What is the forecasted sales in month 5 using naive approach. Please use a 2-month simple moving average method to forecast sales in month 5. Please use a weighted moving average method, with weights of 0.6 one period ago, 0.3 two periods ago, and 0.1 three periods...

  • The following table gives the number of pints of type A blood used at Damascus Hospital...

    The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6​ weeks: The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6​ weeks: The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6​ weeks: ​a) The forecasted demand for the week of October 12 using a​ 3-week moving average​ =_________ pints...

  • An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

    An electrical contractor's records during the last five weeks indicate the number of job requests: Week: 1 2 3 4 5 Requests: 25 27 25 26 27 Predict the number of requests for week 6 using each of these methods: a. Naive. Number of requests             b. A four-period moving average. (Round your answer to 2 decimal places.) Number of requests             c. Exponential smoothing with α = .25. Use 25 for week 2 forecast. (Round your intermediate...

  • The following data are monthly sales of jeans at a local department store.

     4. The following data are monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. (a) Forecast sales of jeans for March through June using the naive method, a two-period moving average, and exponential smoothing with an a = 0.2. (Hint: Use naive to start the exponential smoothing process.) (b) Compare the forecasts using MAD and decide which is best. (c) Using your method of choice, make a forecast for...

  • 2. (20 points) The following table shows the monthly sales in a local grocery store Month and 120 115 125 119 127 114 114 120 124 116 137 10 a. Suppose that Three-weeks moving average are used to...

    2. (20 points) The following table shows the monthly sales in a local grocery store Month and 120 115 125 119 127 114 114 120 124 116 137 10 a. Suppose that Three-weeks moving average are used to forecast sales. Determine the one-step-ahead forecasts for weeks 4 through 10. b. Suppose that exponential smoothing is used with a smoothing constant α-02. Find the exponential smoothing forecasts weeks 4 through 10. (To get the method started, use 120.00 as the forecast...

  • An electrical contractor's records during the last five weeks indicate the number of job requests: Week:...

    An electrical contractor's records during the last five weeks indicate the number of job requests: Week: Requests: 27 29 21 28 29 Predict the number of requests for week 6 using each of these methods: a. Naive. Number of requests b. A four-period moving average. (Round your answer to 2 decimal places.) Number of requests 26.75 C. Exponential smoothing with a = .15. Use 27 for week 2 forecast. (Round your intermediate forecast values and final answer to 2 29...

  • 11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table sum...

    11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table summarizes the number of new cars sold during each of the past 12 weeks: (PLEASE ANSWER BY USING EXCEL) week number sold 1 22 2 26 3 23 4 27 5 21 6 25 7 28 8 26 9 29 10 29 11 27 12 31 (a) Provide a forecast by using a 3-week weighted moving average technique with weights...

  • Note: Data for these problems are in the Module 2 Individual Assignments Data file - there is a tab for each problem, A...

    Note: Data for these problems are in the Module 2 Individual Assignments Data file - there is a tab for each problem, All answers should be entered using two decimal places unless otherwise specified. If both decimal places are zeros-then just enter the integer value. Percentages should be entered without"%" sign- 3.45% should be entered as 3.45. M2 IND1. Mariah Henderson is a WCU student who has just finished her junior year. The data in Worksheet IND1 summarizes her grade...

  • the following table gives the number of pints of type A blood used at Damascus Hospital...

    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 370 410 383 371 374 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10.0 25,...

  • Please help Consider the following time series data. Week 1 N 3 4 5 6 Value...

    Please help Consider the following time series data. Week 1 N 3 4 5 6 Value 19 11 13 10 14 12 (a) Construct a time series plot. 20 18 20 18 14 12 10 Week 3 4 Week D 20 18+ 16 Time Series Value Time Series Value 5 Week 0 Wook What type of pattem exists in the data? The data appear to follow a cyclical pattern. The data appear to follow a trend pattem. The data appear...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT