Question: In the worksheet named 'Data' you will see realtime demand data for four parts. The time frame for the the demand is from January 2

In the worksheet named 'Data' you will see realtime demand data for four parts. The time frame for the the demand is from January 2017 to October 2018.
Using the data answer the following questions:
1. Using excel draw graphs representing the demand trend for all four parts.
2. Looking at the graph for Part-1 what would be the forecasted range of demand in the months September -thru- December of 2018.
3. What is the trend of demand for Part-2?(show and lable the trend line on the demand graph)
4. Calculate and graph the forecast for months November 2018 to August 2019 using 10 month moving average for Part-3. show calculatons.
5. Calculate the mean and std. deviation of Part-4 demand? Show calculations.

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!