Question: What is the forecast for May, June,, and July based on a 3-month weighted moving average applied to the following past demand data and using

What is the forecast for May, June,, and July based on a 3-month weighted moving average applied to the following past demand data and using the weights: 5,4, and 3 (greatest weights is to the most recent data point)? Use bottom of page to show computations for May through July for credit. You are working with months, so the weights are 5, 4, and 3 parts of 12. April's forecast was given as a guide.

Month Demand Forecast Jan. 80 Feb. 83 March 87 April 93 83.91 May 97 June 99 July

Step by Step Solution

★★★★★

3.25 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Forecast for May 93 5 87 4 83 ... 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)

1019-B-C-A-C-B-A-M(3558).docx

120 KBs Word File

Students Have Also Explored These Related Cost Accounting Questions!

A check-processing center uses exponential smoothing to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the forecast was 42 million. A...

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributors sales personnel call on the first day of each month, compute your fore-cast sales by each...

The historical sale for a certain model of a single serve coffee maker in units is: January, 18; February, 21; March, 16; April, 13; May, 17, and June, 20. Using a 2-month moving average, what is the...

Suppose a company needs to forecast the demand for its key component for June based on the 3 - period weighted moving average. The following past demand data is available, and the company uses...

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

CHAPTER 17TIME SERIES ANALYSIS AND FORECASTING MULTIPLE CHOICE 1. Which of the following is not present in a time series? a. seasonality b. operational variations c. trend d. cycles ANS: B PTS: 1...

Consider the following. Month Demand January 2 9 February 4 8 March 5 8 April 5 9 May 7 6 June 8 6 July What is the forecast for July based on a three - month weighted moving average applied to the...

What is the forecast for July based on a three - month weighted moving average applied to the following past demand data and using the weights 5 , 3 , and 2 ( largest weight is for most recent data )...

What is the forecast for July based on a three-month weighted moving average applied to the following past demand data and using the weights: 6, 4, and 1(largest weight is for most recent data)? Show...

"It has been observed that to replace a former employee who has resigned or retired, the company has to spend 150% of the previous employees salary". In the light of the above statement, it is...

c. Key on the musical scale d. Heart beats per minute of a Tour de France cyclist, averaged over the duration of the race e. Stage of fruit ripeness (e.g., underripe, ripe, or over ripe) f. Angle of...

What is the equation for approximating the nominal rate of return? R = the nominal rate of interest r = the real rate of interest h = the inflation rate. R = r h R = r h R = r - h R = r h

6 How can objectives and tasks be communicated from senior management while at the same time motivating those who have to implement them?

Two sinusoidal waves of the same frequency travel in the same direction along a string. If ym1 = 3.0 cm, 4.0 cm, 1 = 0, and 1 = /2 rad, what is the amplitude of the resultant wave?

Two sinusoidal waves of the same frequency are to be sent in the same direction along a taut string. One wave has an amplitude of 5.0 mm, the other 8.0 mm. (a) What phase difference 1 between the two...

Two sinusoidal waves of the same period, with amplitudes of 5.0 and 7.0 mm, travel in the same direction along a stretched string; they produce a resultant wave with an amplitude of 9.0 mm. The phase...

6. What are the various forms of business organization? What are the advantages and disad-vantages of each? 9. The president of Southern Semiconductor Corporation (SSC) made this statement in the...

If Susie earns $ 7 6 8 , 0 0 0 in taxable income and files as head of household for year 2 0 2 3 , what is Susie's average tax rate? ( Use tax rate schedule. ) Note: Do not round intermediate...

#3 The market price of a stock is $43.54 and it is expected to pay a $2.31 dividend next year. The dividend is expected to grow at 3.65% forever. What is the required rate of return for the stock?...