Question: Here are the data for the past 21 months for actual sales of a particular product: Develop a forecast for the fourth quarter using a

Here are the data for the past 21 months for actual sales of a particular product:

THIS YEAR LAST YEAR January February 300 275 400 375 350 March 425 April May 425 450 400 400 350 June 460 July August 40

Develop a forecast for the fourth quarter using a three- quarter, weighted moving average. Weight the most recent quarter .5, the second most recent .25, and the third .25. Do the problem using quarters, as opposed to forecasting separate months.

THIS YEAR LAST YEAR January February 300 275 400 375 350 March 425 April May 425 450 400 400 350 June 460 July August 400 350 300 275 September 375 350 October 500 November 550 eSmart December 500

Step by Step Solution

★★★★★

3.31 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Third most recent quarter 275 375 ... 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)

287-B-M-L-S-C-M (1597).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

A supermarket chain analyzed data on sales of a particular brand of snack cracker at 104 stores in the chain for a certain 1- week period. The analyst tried to predict sales based on the total sales...

Sales of a particular make and size of nails during a day were 4 13 kg, 3 34 kg, 5 12 kg, and 6 58 kg. (a) How many kilograms of nails were sold? (b) What is the total sales value at $1.20 per...

The file P14_19.xlsxcontains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10...

Here are the data for the past 2 1 months for actual salesMonthLast YearThis YearJanuary 2 0 0 2 5 0 February 2 0 0 2 6 0 March 2 1 0 3 1 0 April 2 3 0 3 5 0 May 2 0 0 2 9 0 JuneJuly 2 5 0 3 0 0 3 1...

Here are the data for the past 21 months for actual sales of a particular product. Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent...

Here are the data for the past 21 months for actual sales of a particular product: Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent...

Given the following history, use a three - quarter moving average to forecast the demand for the third quarter of this year. Note: the 1 st quarter is January, February, and March; 2 nd quarter...

If a three-month moving average is used to smooth this series, what would have been the forecast for May? Here are the data for the past 21 months for actual sales of a particular product: Develop a...

Problem 1 8 - 4 ( Algo ) Here are the data for the past 2 1 months for actual sales of a particular product: Develop a forecast for the fourth quarter using a three - quarter, weighted moving...

The market demand curve for mineral water is given by P = 15 - Q. If there are two firms that produce mineral water, each with a constant marginal cost of 3 per unit, fill in the entries for each of...

Hayley produces a product that requires two types of labor: assembly and finishing. The standard and actual cost data for the month of October are as follows: A total of 200 units of finished product...

Choose the statement that best describes the cash flow diagrams below if the interest rate is \ ( 1 2 \ % \ ) per year. \ The cash flow diagram on the left has the greater present worth. To compare...

Prepare a list of questions that have arisen as a result of your E-R modeling efforts, and that need to be answered to clarify your understanding of Mountain View Community Hospitals business rules...

1. A process that emphasizes cross-functional integration and concurrent development of a product and its associated processes is known as __________. 2. The first step in developing a house of...

Match the following product types to the appropriate product development description. _______Technology-push products _______Platform products _______Process-intensive products _______High-risk...

Rotor Limited needs to purchase a wind tunnel for the testing of its new turbine driven technology. The cost is R1 354 776. To finance the purchase, it has secured a loan from STORM Bank at a rate of...

can you please do the math for months, 2, 3, 6, 12, and 24, thank ! a. What is the mid-rate quote for each maturity? b. What is the annual forward premium on the yen for all maturities? (Assume that...

1. Explain what is meant by the "time value of money" in your own words. Why is this such an important concept in finance? 2. What is meant by the "effective interest rate" versus the "simple...