Question: Please answer c & d Historical demand for a product is as follows: ok April May June July August September DEMAND 50 45 70 50

Please answer c & d Please answer c & d Historical demand for a

Historical demand for a product is as follows: ok April May June July August September DEMAND 50 45 70 50 75 70 aces a. Using a simple four- month moving average, calculate a forecast for October (Round your answer to 2 decimal places.) Forecast for October 66.25 b. Using single exponential smoothing with a = 0.20 and a September forecast - 55, calculate a forecast for October (Round your answer to 2 decimal places.) Forecast for October 58.00 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 Yaxis is demand. (Round your intercept value to the nearest whole number and slope value to 2 decimal places.) Y d. Calculate a forecast for October using your regression formula. (Round your answer to 2 decimal places.) Forecast for October

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Check my wo 3 Historical demand for a product is as follows: April May June July August September DEMAND 50 45 70 50 75 70 ed a. Using a simple four-month moving average, calculate a forecast for...

Historical demand for a product is as follows: April May June July August September DEMAND 50 45 70 50 75 70 a. Using a simple four-month moving average, calculate a forecast for October (Round your...

Problem 18-13 (Algo) Historical demand for a product is as follows: April May June July August September DEMAND 68) 63 88 68 93 88 a. Using a simple four month moving average calculate a forecast for...

Historical demand for a product is as follows: April May June July August September DEMAND 63 58 73 63 78 73 a. Using a simple four-month moving average, calculate a forecast for October. (Round your...

Historical demand for a product is as follows: April May June July August September DEMAND 56 51 76 56 81 76 a. Using a simple four-month moving average, calculate a forecast for October. (Round your...

Historical demand for a product is as follows: April May June July August September DEMAND 61 56 76 61 81 76 a. Using a simple four-month moving average, calculate a forecast for October. (Round your...

Problem 3-13 (Algo) Historical demand for a product is as follows: April May June July August September DEMAND 59 54 79 59 84 79 a. Using a simple four month moving average calculate a forecast for...

Historical demand for a product is as follows: April May June July August September DEMAND 71 66 91 71 96 91 a. Using a simple four-month moving average, calculate a forecast for October. (Round your...

Historical demand for a product is as follows: April May June July August September DEMAND 68 63 88 68 93 88 a. Using a simple four-month moving average, calculate a forecast for October. (Round your...

Watertown, Inc. was founded in May, 2005 by Lawrence Rollins, who was employed for 20 years prior as a river rafting guide. Mr. Rollins received an unexpected inheritance of $2,000,000 in January,...

why am i receiving error message "array indices must be positive integers or logical values" for the below code in MATLAB f=@ (t, x, y, z) 10* (y-x); g-@ (t, x, y, z) x* (28-z)-y; h-@ (t, x, y, z)...

Which of the following is not considered a permanent difference? Question 9 options: 1 ) Interest received on municipal bonds. 2 ) Fines resulting from violating the law. 3 ) Premiums paid for life...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...