Question: Please answer the second and third questions to complete the previous solution in previous post Generate random demand (using any data generation application) (at least

Please answer the second and third questions to complete the previous solution in previous post Please answer the second and third questions to
Generate random demand (using any data generation application) (at least 50 data points). Solve the followings in excel, each question on a separate sheet: 1. If you want to use simple moving average method, what is the best value of n to choose between 1 and 10), take increments of 2. 2. If you want to use exponential smoothing forecasting, what is the best value of alpha to choose, take increments of 0.2. 3. Use trend projection with regression, to forecast demand for t=51. And calculate tracking signal

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!