HomeworkLib
Question

Jim's department at a local department store has tracked the sales of a product over the...

Jim's department at a local department store has tracked the sales of a product over the last ten weeks. Forecast demand using exponential smoothing with an alpha of 0.4, and an initial forecast of 25.0 for period 1. Calculate the MAD covering periods 1-10. Calculate the tracking signal covering periods 1-10. What do you recommend?

Period

Demand

1

24

2

23

3

26

4

37

5

26

6

30

7

32

8

27

9

25

10

28
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
Jim's department at a local department store has tracked the sales of a product over the...
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

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

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

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

  • Exercise # 1-0M6322-week 4-Forecasting using Exponential Smoothing The first five periods of demand data are shown...

    Exercise # 1-0M6322-week 4-Forecasting using Exponential Smoothing The first five periods of demand data are shown in the following table Let the smoothing coefficient, alpha, equal 0.2.Compute the exponentially smoothed forecasts for periods one through four Initialize the procedure with a forecast value for period one of 37 Period Aggregate Demand Forecast demand 38 42 40 36 42 37 Determine the Running Sum of Forecast Errors (RSFE), the Mean Absolute Deviation, MADt Land the Tracking Signal(TS) at the end of...

  • 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 thetable below:                                                                                                       Week 1 2 3 4 5 6 7 8 9 10 Demand 19 20 29 38 26 28 37 24 25 30 ​ Forecast 19.0 a) The forecast for weeks 2 through 10 using exponential smoothing with alpha ​= 0.50 and a week 1 initial forecast of 19.0 are ​(round your responses to two decimal​ places):

  • Question 11 (10 points) a) For the following demand data, use exponential smoothing with alpha =...

    Question 11 (10 points) a) For the following demand data, use exponential smoothing with alpha = 0.2 to calculate a forecast for period 7. Assume the forecast for period #1 was 7.0. b) Calculate the MAD error for periods 1-6 for your forecast Period Demand 1 10

  • 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 21 21 28 36 26 29 35 20 25 30 ​a) The forecast for weeks 2 through 10 using exponential smoothing with alpha ​= 0.55 and a week 1 initial forecast of 21.0 are ​(round your responses to two decimal​ places): Week 1 2 3...

  • A) for the following demand data, use exponential smoothing with alpha = .02 to calculate for...

    A) for the following demand data, use exponential smoothing with alpha = .02 to calculate for perieod 7 assume forecast for period #1 was 7.0 B) Calculate the MAD error for periods 1-6 for your forecast period demand 1 10 2 8 3 7 4 10 5 12 6 9

  • Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for...

    Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for the data that appear in this table. Use the actual demand of period 1 as the forecast for period 2 and then use the forecasts for periods 2 through 9 to calculate MAD. Period Demand 1 272 2 278 3 269 4 280 5 267 6 258 7 278 8 298 9 286 10 290 0.43 0.36 0.54 0.62

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

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