Question: using excel please a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4

using excel please

a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data. c) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average with weights of .1,.3, and .6, using . 6 for the most recent year. Plot this forecast on the same graph

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!

Forecast and Moving average. Q4. 1 with advertising as the independent variable. Problems Note: Px means the problem may be solved with POM for Windows and/or Excel OM. Problems 4.1-4.42 relate to...

(4.25 (trend line is given as y=5+20x, 4.28, 4.1, and 4.42) 4.25 The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month January...

( 4.25 ( trend line is given as y=5+20x , 4.28, 4.1, and 4.42) 4.25 The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Forecast the...

Note: means the problem may be solved with POM for Windows and/or Excel OM. . b) Use a 3-week weighted moving average, with weights of .1,.3, and .6, using .6 for the most recent week. Forecast...

4.2 a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your...

( Note; please check picture attached to question for data ) a . Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b . Starting in year 4 and going to year 1 2 ,...

without excel Question 1: 11 Year Demand 1 7 ON 2 9 Uw 3 5 4 9 5 13 wun 6 8 7 12 8 13 9 9 10 11 0 0 7 a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b)...

4.2 3 4 4 1 2 3 5 YEAR 7 8 9 10 6 11 9 13 11 8 9 7 5 12 7 9 un 13 DEMAND a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to...

4.1 The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks Week or Pints Used August 31 360 September 7 389 September 14 410 September 21 381 September...

please answer a,b,c, and d (4.2) a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12 , forecast demand using a 3-year...

A debt of $52000 with interest at 9 6% compounded quarterly is to be repaid by equal payments at the end of every three months for five years. Calculate the size of the monthly payments, total amount...

Refer to the information in Exercise 6.23. REQUIRED A. Prepare journal entries assuming the spoilage is considered normal. B. Prepare journal entries assuming the spoilage is considered abnormal.

Which of the following property forms part of the spouse s NFP ? Question 6 options: Proceeds of a life insurance policy payable to the wife on the death of her father Damages received for personal...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...