Question: please answer question 3 only to complete my previous solution in previous post this is my previous question Generate random demand (using any data generation

please answer question 3 only to complete my previous solution in previous post please answer question 3 only to complete my
this is my previous question please answer question 3 only to complete my
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!