HomeworkLib
Question

Historical demand for a product is as follows: DEMAND April 59 May 54 June 74 July...

Historical demand for a product is as follows:


DEMAND
April 59
May 54
June 74
July 59
August 79
September 74

a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.)

Forecast for October            

b. Using single exponential smoothing with α = 0.30 and a September forecast = 64, calculate a forecast for October. (Round your answer to 2 decimal places.)

Forecast for October            

c. Using simple linear regression, calculate the trend line for the historical data. Say the X axis is April = 1, May = 2, and so on, while the Y axis is demand. (Round your intercept value to the nearest whole number and slope value to 2 decimal places.)

Y =  +  t

d. Calculate a forecast for October using your regression formula. (Round your answer to 2 decimal places.)

Forecast for October            

math   Statistics-And-Probability   
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:
Historical demand for a product is as follows: DEMAND April 59 May 54 June 74 July...
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

  • DEMAND   April 71          May 66          June 91          July 71         &nbs

    DEMAND   April 71          May 66          June 91          July 71          August 96          September 91        1. Using single exponential smoothing with α = 0.20 and a September forecast = 49, calculate a forecast for October. 2.Using simple linear regression, calculate the trend line for the historical data. Say the X axis is April = 1, May = 2, and so on, while the Y axis is demand. (Round your intercept value to the nearest whole number...

  • 2. The historical demand for a product is below. Please forecast the demand in April. Month...

    2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 © Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y=a+bx, and then forecast demand. (3 points)

  • 2. The historical demand for a product is below. Please forecast the demand in April. Month...

    2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 (c) Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y = a+bx, and then forecast demand. (3 points)

  • The historical demand for a product is as follows: Month Demand January 12 February 11 March...

    The historical demand for a product is as follows: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Stating any assumptions that you make answer the following questions. (i) Using a weighted moving average with weights of 0.60 for June; 0.30 for May and 0.10 for April, find the July forecast. (4 marks) (ii) Using a simple three-month moving average, find the July forecast. (4 marks) (iii) Using simple exponential smoothing with α=0,2 and 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 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 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 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: 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...

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

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