Here are the data for the past 21 months for actual sales of a particular product LAST YEAR THIS YEAR January 315 300 February 418 400 March 390 350 April 430 460 May 400 390 June 480 395 July 430 355 August 320 245 September 385 340 October 530 November 592 December 555 Develop a forecast for the fourth quarter using a three quarter, weighted moving average Weight the most recent quarter 0 50, the second most recent 0 25, and the third 0 25 Do the problem using quarters, as opposed to forecasting separate months (Round your answer to 2 decimal places )

The Answer is in the image, click to view ...

Question: Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 315 300 February 418

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

LAST YEAR	THIS YEAR
January	315	300
February	418	400
March	390	350
April	430	460
May	400	390
June	480	395
July	430	355
August	320	245
September	385	340
October	530
November	592
December	555

Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Do the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.)

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!

Consider the Sherwin-Williams Company example discussed in this chapter (see Table 4.1). Suppose one is interested in developing a simple regression model with paint sales (Y) as the dependent...

2 Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 300 275 February 400 375 March 425 350 April 450 425 400 400 May 400 June 460 June 350...

Here are the data for the past 21 months for actual sales of a particular product: Last Year This Year January 300 275 February 400 375 March 425 350 April 450 425 May 400 400 June 460 350 July 400...

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 300 280 February 440 345 March 465 350 April 505 440 May 430 455 June 440 375 July 455...

Problem 3-4 (Algo) Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 300 280 February 440 345 March 465 350 April 505 440 May 430 455 June...

Here are the data for the past 2 1 months for actual sales of a particular product LAST YEAR THIS YEAR January 2 7 5 February 3 7 5 March 4 2 5 3 5 8 April 4 5 0 4 2 5 May 4 8 8 June 4 6 0 July 3 5 0...

ere are the data for the past 2 1 months for actual sales of a particular product: LAST YEAR THIS YEAR January 3 6 5 3 0 0 February 4 5 5 3 7 5 March 4 0 0 3 7 5 April 4 3 0 4 5 5 May 4 3 2 4 4 0...

Here are the data for the past 2 1 months for actual sales of a particular product: LAST YEAR THIS YEAR January 3 7 0 3 0 5 February 4 1 0 3 9 5 March 4 1 0 3 4 0 April 4 4 0 4 5 0 May 4 4 0 4 5 5...

Problem 3 - 4 ( Algo ) Here are the data for the past 2 1 months for actual sales of a particular product: LAST YEAR THIS YEAR January 3 1 0 2 6 5 February 4 3 0 3 6 5 March 4 4 0 3 9 0 April 4 7 5 4...

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 315 300 February 418 400 March 390 350 April 430 460 May 400 390 June 480 395 July 430...

4. Here are the data for the past 21 months for actual sales of a particular product: Last Year This Year Last Year 300 This Year 275 January July 400 350 400 375 August 300 275 February March 425...

Growth rates of insects depend on the temperature T. Suppose that the length of an insect L follows the differential equation dL/dt = 0.001T(t) with t measured in days starting from January 1 and...

You are the manager of a small team of 11 software developers who have been working together successfully for three years. Seven of the employees are in your office, while the other 4 are in a time...

The bonds are issued at a price of $ 1 , 8 1 4 , 6 3 5 . Required: Prepare the January 1 journal entry to record the bonds' issuance. 2 ( a ) For each semiannual period, complete the table below to...

ADMN1016 Assignment 1 - Gambling: A Cash Cow for Provincial Governments Due February 16 2023 worth 10% neter to textbook cast Chupte. + Anal, zing Management Decisions, Gambling: A Cash Cow for...