Hi,

Please i need all steps for answer this question

Thanks..

Question 4: (a) The Marino Company in Ventura County, southern Califomia sells swimming pool equipment. The sales for swimming pool motors in southern Califomia 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. () Three-month simple moving average; [2] 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] (i) 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,851 February 14,202 March 16,083 Apri 10,489 May 15,026 June 17,294 July 11,734 August 14,161 September 17,375 October 12,751 November 14,095 December 16,612 (b) Oman Steel Company is currently having five jobs to be completed in details of which is given in Table 04(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; (0) Critical ratio [2] (u) Least amount of Slack per operation (ii) Johnson's rule Jobs (in the order they arrived) Table Q4(b) Days Remaining processing until due time (days) date Cutting Drilling 6 1 2 7 3 2 5 3 4 9 5 3 4 3 R S T U V 1