70.2K

Verified Solution

Link Copied!

_{(a) The Marino Company in Ventura County, southern California sells swimming pool equipment. The sales for swimming pool motors in southern California over the last 12 months is given in Table Q4(a). Forecast the demand from March to December of the current year using the following forecasting models. Use excel for the tabulation. (i) Three-month simple moving average; (ii)Three-month weighted moving average. Use 0.7, 0.2, and 0.1 for the weights, with 0.7 for the most recent period, and 0.1 for the oldest period. (iii) Simple linear regression; (iv) Determine the MAD, and SE for all the models, and choose which model is most appropriate.}

Table Q4(a) Marino Company Sales of Swimming pool motors
Month					Quantity (units)
January					11,026
February					14,950
March					16,350
April					10,072
May					15,402
June					17,966
July					11,687
August					14,188
September					17,706
October					12,054
November					14,438
December					16,340

(b) Oman Steel Company is currently having five jobs to be completed in details of which is given in Table Q4(b) . Using the following priority rules determine the order in which the jobs given in Table Q4(b) should be processed using the following rules; (i) Critical ratio (ii) Least amount of Slack per operation (ii) Johnsons rule

Table Q4(b)
Jobs (in the order they arrived)		Days until due date			Remaining processing time (days)
					Cutting		Drilling
R		4			1		2
S		9			3		2
T		5			3		4
U		7			5		3
V		6			3		1

Answer & Explanation Solved by verified expert

See Answer