Question

Masters Level work....all work must be shown. FORECASTING

Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work below) 2. Below is 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 quarter 0.5, the second most recent 0.25, and the third 0.25. Approach this roblem using quarters, as opposed to forecasting separate months. Last Y 75 Feb 510575 Mar 535 丨550 Apr 560 525 1 Mayls10 500 Jun 570 550 Aug 410 Sep 48s Oct 610 NovsoI Dec 610 575 s60 I Answer (Please show your work below) 3. The following table contains the number of complaints received in a department store for the first 6 months of operation. If a three month moving average is used, what would have been the forecast for July? Feb 29 Mar 34 Apr 50 May 12 Jun 36

Answer 1

	Last Year	Quarter	Last Year	This Year	Quarter	This year
Jan	210	I	690	235	I	735
Feb	235			245
Mar	245			255
Apr	285	II	890	295	II	895
May	295			305
Jun	310			295
Jul	260	III	750		III	777
Aug	250						adding last year 3 quarter data and dividing by 3
Sep	240
Oct	310	IV	1005		IV
Nov	335
Dec	360

Only one answer at a time is permitted. Thank you