typing only not hand written

Question 4: (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; [2] (i) 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. [3] (iii) Simple linear regression; [3] (iv) Determine the MAD, and SE for all the models, and choose which model is most appropriate. [2] Table Q4(a) Marino Company Sales of Swimming pool motors Month Quantity (units) January 11,062 February 14,951 March 16,026 April 10,249 May 15,708 June 17,501 July 11,815 August 14,525 September 17,615 October 12,881 November 14,714 December 16,159 (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 [2] (ii) Least amount of Slack per operation (ii) Johnson's rule [2] Table Q4(b) Jobs (in the order they arrived) Days until due date Remaining processing time (days) Cutting Drilling R 6 1 S 7 3 2 T 3 4 5 9 5 3 U V 4 3 1