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 430 365 August 325 280 September 375 375 October 535 November 570 December 550 1) 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 345 290 February 395

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	430	365
August	325	280
September	375	375
October	535
November	570
December	550

1) 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!

Lori Harpoolian (John's sister) had the steely blue eyes that seemed to be a prerequisite for high priced corporate attorneys. Those eyes would bore into the soul of her managerial victims, forcing...

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

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

Problem 18-4 (Algo) Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR 345 395 470 460 THIS YEAR 290 375 365 475 440 325 365 280 375 January February March...

Problem 18-4 Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 320 245 February 415 370 March 455 375 April 445 470 May 395 400 June 450...

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

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 310 305 February 430 345 March 440 345 April 485 455 May 450 410 June 465 365 July 395...

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

To test its line of sight adjustment, a level is setup near C (elev 193.436 m) and then near D. Rod readings listed in the order taken are C = 1.256 m, D = 1.115 m, D = 1.296 m, and C = 1.151 m....

What is goodwill and how is it measured?

The ieventory cost flow method that assigns the most recent costs to coit of goods sold is a b . LF c . wrighed iwnoge cost d . epecilic Mentibation

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...