Students, please find attached an excel spreadsheet with raw real world data for four part numbers. In the worksheet named 'Data' you will see realtime demand data for four parts. The time...

1 answer below »

Students, please find attached an excel spreadsheet with raw real world data for four part numbers.

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 forPart-1what would be the forecasted range of demand in the months September -thru- December of 2018.
3. What is the trend of demand forPart-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 forPart-3. show calculatons.
5.Calculate the mean and std. deviation ofPart-4demand? Show calculations.

Show your graphs and calculations in the "Answer page" of the Excel workbook.

Answered Same DayApr 14, 2022

Solution

Tanmoy answered on Apr 15 2022
8 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here