Question: Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 310 270 February 405

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

LAST YEAR THIS YEAR
January 310 270
February 405 365
March 380 360
April 470 455
May 415 395
June 490 400
July 440 340
August 325 260
September 375 360
October 540
November 595
December 515

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!

Q:

The structural member is fabricated by welding two W130 x 28.1 sections together at an angle. Determine the maximum and minimum normal stresses acting on section m-n.

Q:

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

Q:

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

Q:

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

Q:

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

Q:

1 Here are the data for the past 21 months for actual sales of a particular product LAST YEAR THIS YEAR January 320 279 February 400 350 March 475 355 April 475 450 May 440 380 June 445 365 July 450...

Q:

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR 320 380 420 425 440 475 440 310 375 540 575 555 January February March April May June July August...

Q:

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR 320 380 420 425 440 475 440 310 375 540 575 555 January February March April May June July August...

Q:

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 320 270 February 440 395 March 445 375 April 465 405 May 415 430 June 430 355 July 405...

Q:

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 325 260 February 440 380 March 450 370 April 440 420 May 380 440 June 460 360 July 410...

Q:

1 )Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 345 290 February 395 375 March 470 365 April 460 475 May 400 440 June 470 325 July...

Q:

Figure shows four penguins that are being playfully pulled along very slippery (frictionless) ice by a curator. The masses of three penguins and the tension in two of the cords are m1 = 12 kg, m3 =...

Q:

The Solution Design, Purchase of the required hardware and software and the installation should be a total of 19 days. The total budgeted amount for these three tasks is $4000. During the completion...

Q:

Question 4 A market order is sxecuted: Only at a specified price At the end of the day Immediately at the best available price When volume permits

Q:

What is an example of constructive feedback? provide reference