The Weekly Demand for a certain commodity has been recorded as follows: Week 1 2 3 4 5 6 7 8 9 Demand 800 1400 1000 1500 1500 1300 1800 1700 1300 Week 10 11 12 13 14 15 16 17 18 Demand 1700 1500 2300 2300 2000 2000 2100 2200 2300   Using a Naïve Method, de

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter8: Time Series Analysis And_forecasting
Section: Chapter Questions
Problem 9P
icon
Related questions
Question
100%
  1. The Weekly Demand for a certain commodity has been recorded as follows:

Week

1

2

3

4

5

6

7

8

9

Demand

800

1400

1000

1500

1500

1300

1800

1700

1300

Week

10

11

12

13

14

15

16

17

18

Demand

1700

1500

2300

2300

2000

2000

2100

2200

2300

 

  1. Using a Naïve Method, determine the Forecast for Week 19
  2. Using the Moving average with a 3-week Forecast, what is the demand for Week 19.
  3. Using the moving average with a 9-week Forecast, what is the demand for Week 19.
  4. State which forecast is best on the result for a., b., and c. forecasts. Explain your answer.
  5. Use the exponential smoothing technique with an α = 0.1 to determine the forecast for Week 19.
  6. Use the exponential smoothing technique with an α = 0.3 to determine the forecast for Week 19.
  7. Which forecast on e., and f. is better? Explain.
  8. Use the Least Square Method to determine the forecast for Week 19.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Horizontal Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning