Question: (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

(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.

Year	Demand
1	7
2	9
3	5
4	9
5	13
6	8
7	12
8	13
9	9
10	11
11	7
12

Step by Step Solution

★★★★★

3.42 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Year Demand moving average weighted moving average 1 7 2 9 3 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

68-B-E-M-E (1716).xlsx

300 KBs Excel File

Students Have Also Explored These Related Economics Questions!

A uniform series of payments begins in year 4 and ends in year 11. If you use the PA factor with n = 8, the P value you get will be located in year: (a) 0 (b) 3 (c) 4 (d) 5

Data Set 4 "Births" in Appendix B lists birth weights from babies born at Albany Medical Center, Bellevue Hospital in New York City, Olean General Hospital, and Strong Memorial Hospital in Rochester,...

4 . 2 Year 1 2 3 4 5 6 7 8 9 1 0 1 1 Demand 7 9 5 9 1 3 8 1 2 1 3 9 1 1 7 Plot the above data on a graph. Do you observe any trend, cycles, or random variations? Starting in year 4 and going to year...

Your new employer, Freeman Software, is considering a new project whose data are shown below. The equipment that would be used has a 3-year tax life, and the allowed depreciation rates for such...

( 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...

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...

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...

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 Year 1 2 3 4 5 6 7 8 9 1 0 1 1 Demand 7 9 5 9 1 3 8 1 2 1 3 9 1 1 7 a ) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b ) Starting in year 4 and going...

Refer to Exercise 19.1. Use the least significant difference criterion to identify which pairs of methods of irrigation have significantly different mean yields. In Exercise 19.1 In Exercise 15.1, we...

You are required to write a report to the directors of ABC Co based on the above scenario and address the following: i. Introduction: An analysis of why there is a need for an audit and the directors...

48. A study of job satisfaction was conducted for four occupations. Job satisfaction was measured using an 18-item questionnaire with each question receiving a response score of 1 to 5 with higher...

. A university gathers student admission data from three different sources: through forms filled manually at university desks, by registering at the university Web site, or by registering on the...

A business using the retail method of inventory costing determines that merchandise inventory at retail is $880,000. If the ratio of cost to retail price is 65%, what is the amount of inventory to be...

A business using the retail method of inventory costing determines that merchandise inventory at retail is $375,000. If the ratio of cost to retail price is 60%, what is the amount of inventory to be...

On the basis of the following data, estimate the cost of the merchandise inventory at April 30 by the retailmethod: Cost Retail Merchandise inventory April 1 April 1-30 April 1-30 Purchases (net)...

Suppose you are 45 years old this year and plan to retire 15 years from now. You have just signed a contract to put a certain amount of annual contributions into the EYF retirement plan. It is...

Please give formulas and explain how you got the answer, thanks! E12-21A (similar to) Question Help Caruso Hardware is adding a new product line that will require an investment of $1,418,000....

Given an array, arr, of distinct elements and two numbers a and b, write a function void findMissing(int arr[], int n, int a, int b ), which finds and sorts all numbers that are in the range between...