Question

The following table contains the demand from the last 10 months: answer to all the boxes...

The following table contains the demand from the last 10 months:

answer to all the boxes plz

MONTH ACTUAL DEMAND
1 31
2 34
3 35
4 39
5 40
6 45
7 45
8 47
9 43
10 44

a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 31. (Round your intermediate calculations and answers to 2 decimal places.)

Month Exponential Smoothing
1
2
3
4
5
6
7
8
9
10

b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.30, a δ of 0.30, an initial trend forecast (T1) of 1.00, and an initial exponentially smoothed forecast (F1) of 30. (Round your intermediate calculations and answers to 2 decimal places.)

Month FITt
1
2
3
4
5
6
7
8
9
10

c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. (Round your intermediate calculations and answers to 2 decimal places.)

MAD
Single exponential smoothing forecast
Exponential smoothing with trend forecast
0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
The following table contains the demand from the last 10 months: answer to all the boxes...
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 table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 27...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 27 2 29 3 33 4 41 5 44 6 43 7 44 8 46 9 47 10 41 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 27. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 27 2 27 3 27.6 4 29.22 5 32.75 6...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6 37 7 42 8 44 9 41 10 42 a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 29 3 32 4 33 5 35 6 32 7 35 8 42 9 44 10 45 a. Calculate the single exponential smoothing forecast for these data using an α of 0.10 and an initial forecast (F1) of 33. (Round your answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.10, a...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 32 3 31 4 38 5 42 6 38 7 42 8 42 9 43 10 43 a. Calculate the single exponential smoothing forecast for these data using an α of 0.20 and an initial forecast (F1) of 33. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10

  • excel spreadsheet information: Month Sales (in millions of boxes) 1 1306 2 1305 3 1311 4...

    excel spreadsheet information: Month Sales (in millions of boxes) 1 1306 2 1305 3 1311 4 1313 5 1324 6 1329 7 1346 8 1347 9 1378 10 1394 11 1441 12 1469 Problem 3 You have realized that the sales for Select-A-Size Paper Towel packs have been increasing over the past year. You have learned that the double exponential smoothing method can account for such a trend in the data. Use double (trend-adjusted) exponential smoothing method to forecast sales...

  • Assume that your stock of sales merchandise is maintained based on the forecast demand. If the...

    Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 154 July 194 August 225 a. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) b. Using a weighted moving average, what is the forecast for September with weights...

  • The following table shows the actual demand observed over the last 11 years Year 10 11...

    The following table shows the actual demand observed over the last 11 years Year 10 11 Demand 7 4 Using exponential smoothing with α = 0.30 and a forecast for year 1 of 6.0, provide the forecast from periods 2 through 12 round your responses place) one decimal Year 2 4 10 12 Forecast 6.0

  • My App is a small but growing start-up that sees demand for several of its apps...

    My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six months of downloads. Use a forecast for the first month of 215000, an initial trend forecast of 50000, and smoothing parameters of 0.05 for both demand smoothing and trend smoothing. Month (t) Monthly Application Downloads Forecast for Next Month Trend 215,000.00 50,000.00 1 200,000 2 250,020 3 320,000 4 410,000 5 445,000 6 496,000 (Round...

  • A large Portland manufacturer wants to forecast demand for a piece of pollution-control equipment. A review...

    A large Portland manufacturer wants to forecast demand for a piece of pollution-control equipment. A review of past sales (At), as shown below, indicates that an increasing trend is present. Smoothing constants are assigned the values of a = 0.20 and ß = 0.4. The firm assumes the initial forecast for month 1 (F1) was 9.00 units and the trend over that period T1 was 2.00 units. Using trend-adjusted exponential smoothing, Forecasts (Ft), Trend (Tt), and Forecasts Including Trend (FIT+)...

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