Question: Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a 3-year moving

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Which method do you think isbest?

DEMAND FOR FERTILIZER (1,000S OF BAGS) YEAR 10 12 14 15 10

Step by Step Solution

★★★★★

3.38 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

MAD for 3year average 20368 255 MAD for weighted 3year ave... 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)

162-M-S-F (48).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

The data shown in the following table were obtained from the 1990 Census. Included is information on 26 randomly selected Metropolitan Statistical Areas (MSAs). Of interest are factors that...

The financial statements of Eagle Sport Supply are shown in Table 29.17. For simplicity, "Costs" include interest. Assume that Eagle's assets are proportional to its sales. a. Find Eagle's required...

The data shown in the following table are highway gasoline mileage performance and engine displacement for a sample of 20 cars. (a) Fit a simple linear model relating highway miles per gallon (y) to...

17,18,19 CHAPTER 5. FORECASTING 5-17 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a 3-year mov- ing average...

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 4 6 1 2 3 4 5 4 5 6 18. |17:...

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Find the three year moving average. Year Demand (Bags) 1 4 2 6 3 4 4 5 5...

1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. YEAR 1 2 3 4 5 6 7 8 DEMAND FOR FERTILIZER (1,000S OF BAGS) 7 6 5 7...

Answer A-E with complete work and explanations typed. 1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. DEMAND FOR...

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. 1. To develop a 3-year moving average to fo forecast sales, complete the...

Please,refer to question 19. YEAR DEMAND FOR FERTILIZER (1,0005 OF BAGS) 5 5 10 6 8 7 8 9 12 9 10 14 15 11 Ecussion Questions 5-1 Describe briefly the steps used to develop a forecast- ing system 5-2...

Jackson owns 40% interest in Beyond Belief Dance Company, un S-corporation with ordinary operating income of $91,000 in the current year. On weekends, Jackson sometimes performs as a drag queen,...

Figure Q2(a) shows the block diagram for a process plant. The control unit comprises two transfer functions: G, (s), which represents the system process, while G,(s)represents control system for...

Use a diagram to distinguish between price elastic PES and price inelastic PES.

3. Components Playing a board game, you are stuck in jail until you roll doubles (same numbers) on a pair of dice. You will simulate using random digits to estimate how many turns you expect to...

=1. Simulation is a technique usually reserved for studying only the simplest and most straightforward of problems. a. True b. False

=2. Which option do you recommend?

=1. Determine the average amount of time that a guest spends checking in. How would this change under each of the stated options?

In this problem you will be calculating compound interest on 4 different deposit amounts. For each deposit amount, you will calculate the value of the deposit using 2 different interest rates...

You are a consultant to a firm evaluating an expansion of its current business. The cash-flow forecasts (in millions of dollars) for the project are as follows: Years Cash Flow 0 100 110 + 18 On the...

On August 1 , 2 0 2 2 , Colombo Company's treasurer signed a note promising to pay $ 1 2 3 , 0 0 0 on December 3 1 , 2 0 2 2 . The proceeds of the note were $ 1 1 4 , 9 0 0 . c . 1 . Use the...