Question: pls use the number from the table Question 4: (a) The Marino Company in Ventura County, southern California sells swimming pool equipment. The sales for

pls use the number from the table Question 4: (a)

pls use the number from the table

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. (1) Three-month simple moving average; [2] c)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,749 February 14,831 March 16,758 April 10,748 May 15,904 June 17,429 July 11,429 August 14,135 September 17,555 October 12,468 November 14,541 December 16,674 (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; (0) Critical ratio [2] (1) Least amount of Slack per operation [2] (ii) Johnson's rule [2] Jobs (in the order they arrived) Table Q4(b) Remaining processing Days until time (days) due date Cutting Drilling 1 R S T U V 7 6 9 4 5 3 3 5 3 2 2 4 3 1

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!