Assignment title: Information


Sultan Company wants to develop a cost formula (function) for its repairs and maintenance costs (R&M Costs) so it can deal with its contractors in a way that helps maximizing the Company's return. Currently, the contractors are charging the Company a monthly flat rate of 20,000 AED plus AED 20 per labor hour. Some managers argue that labor hours are the best predictor of repair and maintenance costs. Others are claiming that machine hours are a better predictor of repair and maintenance costs.The accountant suggested collecting data about repairs and maintenance costs, number of labor hours, and number of machine hours for the last 24 months. He indicated that analyzing these data will help judge the fairness of the fees charged by the contractors.The following table presented collected data for possible analysis:Month Machine hours labor hours R&M CostsJanuary, 2014 29000 15000 95500February 24000 16000 99500March 22500 16500 89000April 21000 14000 90000May 20500 15500 81500June 19500 16000 75500July 14000 11500 70500August 8000 7500 64500September 12000 4000 69000October 16500 13000 75000November 16000 11000 71500December 18500 12000 78000January, 2015 21500 17000 86000February 24000 18000 93000March 23000 17500 93000April 22000 17900 87000May 20000 16700 80000June 18000 14000 76500July 12500 8900 67500August 13000 9500 71000September 15000 11000 73500October 17000 12000 72500November 15000 11500 71000December 18800 13500 79000Required: (4 marks each)1. Using the high-low method, estimate R&M cost formula. Do the results of the high-low method cause you any concern about the current fees charged by the contractors?2. Employ a least-square regression analysis with the relevant data points to estimate R&M cost formula using machine hours as the cost driver. Attach the print-out of your results. 3. Employ a least-square regression analysis with the relevant data points to estimate R&M cost formula using labor hours as the cost driver. Attach the print-out of your results.4. Which regression analysis would you consider better than the other? Do the results of the regression analysis cause you any concerns about the accuracy of the high-low method??5. Would the results of the regression analysis cause you any concerns about the current fees charged by the contractors?