Finance Assignment Question

Questions: Sultan Company wants to develop a cost formula (function) for its repairs and maintenance costs (RM Costs) so it can deal with its contractors in a way that helps maximizing the Companys 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 RM Costs January, 2014 29000 15000 95500 February 24000 16000 99500 March 22500 16500 89000 April 21000 14000 90000 May 20500 15500 81500 June 19500 16000 75500 July 14000 11500 70500 August 8000 7500 64500 September 12000 4000 69000 October 16500 13000 75000 November 16000 11000 71500 December 18500 12000 78000 January, 2015 21500 17000 86000 February 24000 18000 93000 March 23000 17500 93000 April 22000 17900 87000 May 20000 16700 80000 June 18000 14000 76500 July 12500 8900 67500 August 13000 9500 71000 September 15000 11000 73500 October 17000 12000 72500 November 15000 11500 71000 December 18800 13500 79000 Required: Using the high-low method, estimate RM cost formula. Do the results of the high-low method cause you any concern about the current fees charged by the contractors? Employ a least-square regression analysis with the relevant data points to estimate RM cost formula using machine hours as the cost driver. Attach the print-out of your results. Employ a least-square regression analysis with the relevant data points to estimate RM cost formula using labor hours as the cost driver. Attach the print-out of your results. 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 Would the results of the regression analysis cause you any concerns about the current fees charged by the contractors? Answers: (1). High Low method is method of dividing a mixed cost into fixed cost and variable cost. If total cost is given by y= a+ b*x, where a is the fixed cost and b is the variable cost per unit then the formula used to determine variable and foxed cost is b = (y2- y1)/ (x2- x1) y2 = total cost at highest level of activity y1 = total cost at lowest level of activity x2 = number of units at highest level of activity x1 = number of units at lowest level of activity a = y2- b*x1 In this case, Y (RM cost) = a (fixed cost) + b (variable cost per unit)* (labor hours) y1 = 64500, y2 = 99500 x1 = 7500 ,x2 = 16000 Thus b = (99500- 64500)/ (16000 7500) = 4.11 a = 99500 4.11*16000 = 33617.65 Thus the rate that should be charged by the contractor = 33617.65 + 4.11 *labor hour. It can be seen that the company currently charges 20000 + 20 * labor hours. Thus if the company does not get work for long hours it will be charging a low amount from the customers and if they are working for very long hours it will be charging a high amount from the customer. Thus to stay competitive in the market, the company should look at its price policy again and take corrective actions. (2). Using Machine hours as input and RM cost as out the regression analysis was conducted. The output generated using the least regression method is given below SUMMARY OUTPUT Regression Statistics Multiple R 0.932115 R Square 0.868839 Adjusted R Square 0.862877 Standard Error 3642.259 Observations 24 ANOVA df SS MS F Significance F Regression 1 1.93E+09 1.93E+09 145.7331 3.54E-11 Residual 22 2.92E+08 13266052 Total 23 2.23E+09 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 44032.32 3035.641 14.50511 9.63E-13 37736.79 50327.86 37736.79 50327.86 X Variable 1 1.932301 0.160065 12.072 3.54E-11 1.600347 2.264255 1.600347 2.264255 Thus the R squared value of the regression analysis is 0.868, the co-efficient of intercept is 44032.32 and the co-efficient of X variable 1 is 1.932. Thus the equation of the cost can be given by Y (RM cost) = 1.932* X (Machine hours) + 44032.32 (3). Using Labor hours as input and RM cost as out the regression analysis was conducted. The output generated using the least regression method is given below SUMMARY OUTPUT Regression Statistics Multiple R 0.786823 R Square 0.619091 Adjusted R Square 0.601777 Standard Error 6206.97 Observations 24 ANOVA df SS MS F Significance F Regression 1 1.38E+09 1.38E+09 35.75654 5.11E-06 Residual 22 8.48E+08 38526480 Total 23 2.23E+09 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 50754 4981.55 10.1884 8.59E-10 40422.9 61085.1 40422.9 61085.1 X Variable 1 2.164019 0.361896 5.979677 5.11E-06 1.413493 2.914544 1.413493 2.914544 Thus the R squared value of the regression analysis is 0.619, the co-efficient of intercept is 50754 and the co-efficient of X variable 1 is 2.164. Thus the equation of the cost can be given by Y (RM cost) = 2.164* X (Labor hours) + 50754 (4). A linear regression analysis results in co-efficient of independent variable, co-efficient of constant term and the R square value. The co-efficient of the independent variable is used to understand its effect on the independent variable. If the value of the co-efficient of the independent variable is positive, then the variables are positively correlated i.e. the value of dependent variable will rise with the surge in independent variable. In the first case the machine hours and RM costs are positively correlated. Also in the second case the labor hours and RM costs are positively correlated. Thus increase in machine hours or labor hours will cause RM cost to increase. The co-efficient of the constant term provides the fixed cost incurred by the company i.e. the cost that the company will suffer even if no production is done by the company. The fixed cost in both the cases are positive. P value of a regression analysis helps us understand the statistical significance of the co-efficient obtained from the regression. It tells us how confident we can be about the relation between the dependent and independent variable. In this case we can be 95% confident about the results from the regression analysis in both the cases. The R square value of the regression is the fraction of variation that can be forecasted by the independent variables. The R squared value helps to check how closely the data are related to each other. The R squared value varies from 0$and 1. The greater the value of R squared the more accurately the regression line can predicted the output for a particular input. In the first case the R square value for the regression between the machine hours and the RM costs is 0.868. Thus with the help of machine hours 86% of the total cost can be predicted. In the second case the R square value for the regression between the labor hours and the RM costs is 0.619. Thus with the help of labor hours 61% of the total cost can be predicted. Thus we should use machine hours to determine the total cost to the company. The equation of the cost from regression analysis is given by Y (RM cost) = 1.932* X (Machine hours) + 44032.32 And the equation of the cost from High low method is given by Y (RM cost) = 4.11* X (Machine hours) + 33617.65 Comparing both the results, it can be found that the fixed cost charged by the company using regression analysis is higher than the fixed cost charged by the company for high low method. While the variable cost per unit using regression analysis is lower than the variable cost per unit for high low method. Thus if the company does work for longer hours then it will earn more money using high low method but if the company works for a shorter duration of time, then it should use cost variables obtained from regression analysis. The data obtained from regression analysis takes into account all the data points and is not dependent on the only two points as is the case with high low method. This makes it more accurate than the high low method. (5). The company currently charges the customers using the equation Total cost = 20000 + 20 * labor hours. Whereas from the regression analysis it was found that the Total cost, Y (RM cost) = 1.932* X (Machine hours) + 44032.32 From the regression analysis it was observed that the total cost to the company can be predicted more accurately if we use machine hours instead of the labor hours. Thus the company should change the cost driver from labor hours to machine hours. Also the fixed cost charge by the company currently is less than the half it is found from the regression analysis while the rate per unit currently used is very high compared to the regression analysis. Thus if the company continues using the current method to determine cost, and if does not get work for long hours it will be charging a low amount from the customers Whereas if they are working for very long hours it will be charging a high amount from the customer. Thus to stay competitive in the market, the company should look at its price policy again and take corrective actions and change the cost driver from labor hours to machine hours and increase the fixed cost while decreasing the variable cost per unit. References High-Low Method. (n.d.). Frost Jim (2013). How to Interpret Regression Analysis Results: P-values and Coefficients. Interpreting Regression Output. (n.d.).