ZuoTi.Pro
Question

8. The table below shows the past 10 weeks of actual sales (y) and forecast sales for the next period (Øt+1): Forecast for We

business   economics   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Week

Sales

Forecast for next period

1

400

400.00

2

430

406.00

3

420

408.80

4

440

415.04

5

460

424.03

6

440

427.23

7

470

435.78

8

430

434.62

9

440

435.70

10

420

432.56

11

410

428.05

12

428.05

428.05

The formula used = alpha*actual sales+(1-alpha)*previous forecast

Forecast for 12 week = 0.2*428.05+(1-0.2)*428.05 = 428.05

0 0
Add a comment
Know the answer?
Add Answer to:
8. The table below shows the past 10 weeks of actual sales (y) and forecast sales...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • A small Italian restaurant wants to forecast pepperoni pizza sales. Actual sales and forecasts for the...

    A small Italian restaurant wants to forecast pepperoni pizza sales. Actual sales and forecasts for the past several months are shown below. The owner prefers to use an exponential smoothing forecasting model with αλπηα&νβσπ; = 0.30. What would be the exponential smoothing forecast for June? Period Demand Forecast April 500 480 May 476 June 503

  • Sales of tablet computers at Ted​ Glickman's electronics store in​ Washington, D.C., over the past 10 weeks are show...

    Sales of tablet computers at Ted​ Glickman's electronics store in​ Washington, D.C., over the past 10 weeks are shown in the table​ below:                                                                                                                     Week 1 2 3 4 5 6 7 8 9 10 Demand 19 21 28 38 26 30 36 24 25 30 ​a) The forecast for weeks 2 through 10 using exponential smoothing with alpha ​= 0.55 and a week 1 initial forecast of 19.0 are ​(round your responses to two decimal​ places): Week 1 2 3...

  • 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...

  • Wk Qu. 10-13 The table below shows the sales of widgets... The table below shows the...

    Wk Qu. 10-13 The table below shows the sales of widgets... The table below shows the sales of widgets (in units) over the past 5 years. Using exponential smoothing with a smoothing constant of 0.1, what is the forecast for next year? The initial forecast (for 5 years ago) was 1,400 units. Forecast: Time 5 years ago 4 years ago 3 years ago 2 years ago Last year Sales 1,400 1,440 1,350 1,270 1,410 (Do not round intermediate calculations, round...

  • 3.13 pts Question 23 During the past three weeks sales of a product have been as...

    3.13 pts Question 23 During the past three weeks sales of a product have been as follows: Sales 71 70 69 Week 2 3 Use exponential smoothing with a smoothing constant of 0.10 to forecast sales for week 3. O 71.60 O 70.71 71.00 ○ 69.95 70.90

  • Sales of tablet computers at Ted​ Glickman's electronics store in​ Washington, D.C., over the past 10...

    Sales of tablet computers at Ted​ Glickman's electronics store in​ Washington, D.C., over the past 10 weeks are shown in the table​ below:                                                                                                                     Week 1 2 3 4 5 6 7 8 9 10 Demand 19 21 28 38 26 30 36 24 25 30 ​a) The forecast for weeks 2 through 10 using exponential smoothing with alpha ​= 0.55 and a week 1 initial forecast of 19.0 are ​(round your responses to two decimal​ places): Week 1 2 3...

  • Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The...

    Examples 1,2,3 1. Beyond Tea Inc. wants to forecast sales of its menthol green tea. The company is considering either using a simple mean or a three-period moving average to forecast monthly sales. Given sales data for the past 10 months use both forecasting methods to forecast periods 7 to 10 and then evaluate each. Which method should they use? Use the selected method to make a forecast for month 11. (Show all calculations .... Please read Examples1, 2, 3...

  • Problem II The following time series shows the sales of a clothing store over a 10-week...

    Problem II The following time series shows the sales of a clothing store over a 10-week period. Week Sales ($1,000s) 15 a. Compute a 4-week moving average for the above time series. b. Compute the mean square error (MSE) and mean Absolut deviation (MAD) for the 4. week moving average forecast. c. Use a -0.3 to compute the exponential smoothing values and MSE and MAD for the time series. d. Forecast sales for week 11. e. Which model is the...

  • 46. Consider the sales for six consecutive weeks for Sam’s Strawberries. The sales are in “flats”...

    46. Consider the sales for six consecutive weeks for Sam’s Strawberries. The sales are in “flats” sold.        Week              Sales         1                   16         2                   18         3                   14         4                   10         5                   20         6                   22 I just need the answer of E . E problem a.   Using a moving average with AP = 3, forecast the sales for weeks four through six. What is the forecast for week 6? 14.7 b) Use...

  • 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...

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