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 440 375 July 455 370 August 320 270 September 375 355 October 555 November 610 December 518 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 Solve 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: 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

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	440	375
July	455	370
August	320	270
September	375	355
October	555
November	610
December	518

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

Check my work 10 Problem 3-4 (Algo) Here are the data for the past 21 months for actual sales of a particular product: 5 points Skipped January February March April May 350 eBook Print June LAST YEAR...

Problem 3-4 (Algo) Here are the data for the past 21 months for actual sales of a particular product: January February March April May June July August September October November December LAST YEAR...

Problem 18-4 (Algo) Here are the data for the past 21 months for actual sales of a particular product: January February March April May June July August September October November December LAST YEAR...

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 (Algo) Here are the data for the past 21 months for actual sales of a particular product: 330 January February March April May June July LAST YEAR THIS YEAR 295 400 360 460 365 490 475...

Here are the data for the past 21 months for actual sales of a particular product: ET January February March April May June July August September October November December LAST YEAR THIS YEAR 320 295...

Here are the data for the past 21 months for actual sales of a particular product: 455 January February March April May June July August September October November December LAST YEAR THIS YEAR 310...

Here are the data for the past 21 months for actual sales of a particular product: ETT January February March April May June July August September October November December LAST YEAR 320 415 455 445...

Question 16 The complete combustion of 0.31 moles of propane, C3H8, will consume 1.6 mol O2 and produce 4.7 mol CO2. consume 1.6 mol O2 and produce 1.2 mol CO2. consume 1.6 mol O2 and produce 0.93...

Obtain the financial statements of a bank that is listed on the Nairobi Securities Exchange and critically analyze its compliance with the disclosure requirements under IFRS 7: Financial Instruments:...

What is the HPR for a share of stock that was purchase for $ 2 5 , sold for $ 2 7 and distributed $ 1 . 2 5 in dividends?What is the Div yield? Capital gain yield?

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...