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 to October
Using the data answer the following questions:
Using excel draw graphs representing the demand trend for all four parts.
Looking at the graph for Part what would be the forecasted range of demand in the months September thru December of
What is the trend of demand for Partshow and lable the trend line on the demand graph
Calculate and graph the forecast for months November to August using month moving average for Part show calculatons.
Calculate the mean and std deviation of Part demand? Show calculations.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
