Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these General Management questions