Answer the following questions

NUMBER ONE Boni Wahome, a financial analyst at Green City Bus Company Ltd. is examining the behavior of the company's monthly transportation costs for budgeting purposes. The transportation costs are a sum of a two types of costs: 1) Operating costs, such as fuel and labour. 2) Maintenance costs, such as overhaul of engines and spraying. Wahome collects monthly data on items 1 and 2 above and the distance covered by the buses. Monthly observations for the year ended 31 December 2004 were as follows: Month Operating costs Maintenance Distance costs covered in kilometers (d) Shs. '000' Shs. '000' Shs. '000' January 471 437 3,420 February 504 388 5,310 March 609 343 5,410 April 690 347 8.440 May 742 294 9,320 June 774 211 8,910 July 784 176 8,870 August 986 210 10,980 September 895 280 4,980 October 651 394 5,220 November 481 381 4,480 December 386 514 2,980 Wahome ran three linear regression equations based on the data above and came up with the following results: Regression equation I Operating costs = a + bd Variable Coefficient Standard t - value error Constant 309.19 96.05 3.22 Distance covered in kilometers 0.054 0.014 3.86 r = 0.61, Durbin - Watson 1.61 statistic = Regression equation II Maintenance costs = a + bdVariable Coefficient Standard error value Constant 531.55 46.95 11.32 Distance covered in kilometers - 0.031 0.007 - 4.43 * = 0.68, Durbin - Watson 1.72 statistic = Regression equation III Total transportation costs = a + bd Variables Coefficient Standard t - value error Constant 840.73 80.25 10.48 Distance covered in kilometers 0.023 0.011 2.09 r' = 0.29, Durbin - Watson 2.34 statistic = Required: (a) Evaluate the three linear regression equations using: Economic plausibility. (3 marks) Goodness of fit (3 marks) Significance of independent variables. (3 marks) (iv) Specifications analysis criteria (3 marks) (Use a 95% confidence level where applicable). (b) List three variables, other than distance covered, that could be important drivers of the company's operating costs, (3 marks) (c) Suggest an alternative database that Wahome could have used to examine the drivers of the company's maintenance costs, (2 marks) (d) Explain three limitations of the linear regression analysis used by the company. (3 marks) (Total: 20 marks) NUMBER TWO Luka Lid. is a distributor of an industrial chemical in the South Coast. The chemical is supplied in drums which have to be stored at a controlled temperature. The company's objective is to maximize profits, however the management team disagrees on the stock control policy and holds the following different views: The Managing Director's view: The company's managing director (MD) wishes to improve the stock holding policy by applying the economic order quantity (EOQ) model. Each drum of the chemical costs Shs. 5,000 from a supplier and is sold for Shs. 6,000. The annual demand is estimated to be 10,000 drums which the MD assumes to be evenly distributed over the 300 working days in a year. The cost of delivery is estimated at Shs. 2,500 per order and the annual variable holding cost per drum at Shs. 4,500 plus 10% of the purchase price. Using these data, the MD calculated the EOQ and proposes that it should be used as the basis for future purchasing decisions of the industrial chemUsing these data, the MD calculated the EOQ and proposes that it should be used as the basis for future purchasing decisions of the industrial chemical. The Purchasing Manager's view: Provided in the employment contract of the company's purchasing manager (PM), is a clause stating that he will receive a bonus (rounded at the nearest Shs. 100) calculate as follows: b = [1,000,000 - (0 + Ho)] x 0.1 whereb is the annual bonus. Of is the annual ordering cost. He is the annual holding cost. Using the same assumption as the MD, the PM points out that in making his calculation, the MD has not only ignored the bonus but also the fact that suppliers offer quantity discounts on purchase orders, where if the order size is 200 drums or above, the price per drum for an entire consignment is only Shs. 4,990 compared to Shs. 5,000 when the order is between 100 and 199 drums and Shs. 5,010 when an order is between 50 and 99 drums. The Finance Director's view: The company's finance director (FD) accepts the need to consider quantity discounts and pay a bonus, but he also holds the view that the MD's approach is too simplistic. He points out that there is a three days lead time for an order and that demand has not been entirely even over the past year. Moreover, if the company has no drums of the chemical in stock, it will lose specific orders as potential customers will source the chemical from competitors. He gives the frequency of lead time demand over the last year as follows: Demand during lead Frequency time (No. of drums) 106 4 104 10 102 16 100 40 98 14 96 14 94 2 Under the circumstances, the MD decided that he would seek further advice on the course of action to be taken by the company. Required: (a) The EOQ as originally determined by the company's managing director. (2 marks) (b) Determine the optimum order quantity, taking into consideration the MD's assumptions and after allowing for the purchasing manager's bonus and supplier quantity discount. (4 marks) (c) The safety stock the company should maintain after applying the finance director's assumptions and assuming further that the supplier's contract(d) As a consultant, write a brief report to the managing director on the company's stock ordering and stock holding policies, referring where necessary to your answers in (a) to (c) above. The report should refer to other factors that should be considered when making the final decisions on stock ordering and holding policies. (8 marks) (Total: 20 marks) NUMBER THREE (a) List five assumptions underlying the cost-volume-profit (CVP) analysis. (5 marks) (b) Framepark Led. manufactures a hedge-trimming tool which has been selling at Shs. 1,600 per unit for a number of years. The selling price is to be reviewed and the following information is available on costs and the likely demand: 1. The standard variable cost of manufacturing the tool is Shs. 1,000 per unit and an analysis of the cost variances in the past 20 months shows the following pattern which the production manager expects to continue in the future. . Adverse variances of 10% of the standard variables cost occurred in ten of the twenty months. . Nil variances occurred in six of the twenty months. . Favorable variances of 5% of the standard variable cost occurred in four of the twenty months. 2. Fixed costs have been Shs. 400 per unit at an average sales level of 20,000 units, but are expected to rise in the future. 3. The following estimates have been made of the total fixed cost: Shs. Probability Optimistic estimate 8,200,000 0.3 Most likely estimate 8,500,000 0.5 Pessimistic estimate 9,000,000 0.2 4. The demand estimates at the two proposed selling prices being considered are as follows: Proposed selling price Shs. 1,700 Shs. 1,800 No. of units No. of units Probability demanded demanded Optimistic estimate 21,000 19,000 0.2 Most likely estimate 19,000 17,500 0.5 Pessimistic estimate 16,500 15,500 0.3 Assume that all the estimates and probabilities are independent. Required: Based on the information given above, advise the management of Framepark Lid. on whether they should change the selling price. Indicate the price you would recommend. (6 marks) The expected profit at the price you have recommended in (i) above and the resulting margin of safety expressed as a percentage of expected sales. (4 marks)