Using the model, answer the following request from the maintenance manager in regard to realistic utilisation targets:Using the model, answer the following request from the maintenance manager in regard to realistic utilisation targets:

Using the model, answer the following request from the maintenance manager in regard to realistic utilisation targets: Background info: The average utilisation for the dump truck for the year is 44.5% During the year they have achieved numbers exceeding this number as well as below. The engineering manager has asked you to determine a realistic achievable utilisation target based in historical performance. Analysis and recommendations Task: The utilisation of trucks spread sheet contains the daily utilisation figures for the dump truck fleet. The information has been analysed and split between the first half of the year and the second. 1. Based on the analysis, describe which targets in the short term and longer term could be achievable? And why? 2. For each of these targets, how much more profit could be made by the mine when they are achieved? Dump Trucks Utilisation 44.5% 46.0% 43.3% 47% 47% 46% 13% 11% 14% 2% 1% 2% 49% 50% 49% 52% Analysis of Data Mean Mean (1st half) Mean (2nd half) Median Median(1st half) Median(2nd half) Std deviation STDEV(1st Half) STDEV(2nd Half) Variance Variance(1st Half) Variance(2nd Half) P65 (mean) P65 (mean) - 1st Half P65(mean) - 2nd Half P65 (median) P65(median) - 1st Half P65(median) - 2nd half P75 (mean) P75 (mean) - 1st Half P75 (mean) - 2nd half | Max(1st half) Max(2nd Half) Round max Round max(1st half) Round max(2nd half) Min Min (1st Half) Min (2nd Half) Diff Diff(1st Half) Diff(2nd Half) 51% 51% 53% 54% 53% 66% 57% 66% 66% 57% 66% 0% 0% 0% 66% 57% 66% Using the model, answer the following request from the maintenance manager in regard to realistic utilisation targets: Background info: The average utilisation for the dump truck for the year is 44.5% During the year they have achieved numbers exceeding this number as well as below. The engineering manager has asked you to determine a realistic achievable utilisation target based in historical performance. Analysis and recommendations Task: The utilisation of trucks spread sheet contains the daily utilisation figures for the dump truck fleet. The information has been analysed and split between the first half of the year and the second. 1. Based on the analysis, describe which targets in the short term and longer term could be achievable? And why? 2. For each of these targets, how much more profit could be made by the mine when they are achieved? Dump Trucks Utilisation 44.5% 46.0% 43.3% 47% 47% 46% 13% 11% 14% 2% 1% 2% 49% 50% 49% 52% Analysis of Data Mean Mean (1st half) Mean (2nd half) Median Median(1st half) Median(2nd half) Std deviation STDEV(1st Half) STDEV(2nd Half) Variance Variance(1st Half) Variance(2nd Half) P65 (mean) P65 (mean) - 1st Half P65(mean) - 2nd Half P65 (median) P65(median) - 1st Half P65(median) - 2nd half P75 (mean) P75 (mean) - 1st Half P75 (mean) - 2nd half | Max(1st half) Max(2nd Half) Round max Round max(1st half) Round max(2nd half) Min Min (1st Half) Min (2nd Half) Diff Diff(1st Half) Diff(2nd Half) 51% 51% 53% 54% 53% 66% 57% 66% 66% 57% 66% 0% 0% 0% 66% 57% 66%