Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Data Table
Calculations set to Manual. Press F9 to recalculate.
Fail
#
Time
between
failures
Actual
failure
time
Begin
maint
Wait
for
maint
Maint
time
End
maint
Time in
system
Begin
maint
Wait
for
maint
Maint
time
End
maint
Time in
system
Run
Annual
downtime
savings
1 78.27 78.27 78.27 0.00 35.84 114.11 35.84 78.27 0.00 15.07 93.34 15.07 Daily prodn per cell (tons) 5 1 $23,155.11
6 96.52 275.01 275.01 0.00 26.01 301.02 26.01 275.01 0.00 18.45 293.46 18.45 Old maintenance procedure 6 $29,402.75
7 6.32 281.33 301.02 19.69 23.54 324.57 43.23 293.46 12.13 14.64 308.10 26.77 Mean (hrs) 21 7 $52,695.06
10 15.54 339.58 355.12 15.54 24.78 379.90 40.33 339.58 0.00 15.25 354.82 15.25 10 $21,999.28
11 26.51 366.09 379.90 13.81 18.01 397.92 31.83 366.09 0.00 11.09 377.18 11.09 New maintenance procedure 11 $35,450.26
16 41.45 474.34 474.34 0.00 19.35 493.69 19.35 474.34 0.00 12.67 487.01 12.67
Based on 1 replication: 16 $20,026.45
24 28.32 779.59 779.59 0.00 19.79 799.38 19.79 779.59 0.00 20.87 800.46 20.87 24 $36,865.89
25 1.94 781.53 799.38 17.85 15.20 814.58 33.05 800.46 18.93 14.30 814.76 33.23 Based on 200 replications: 25 $16,178.56
26 0.21 781.74 814.58 32.84 27.80 842.38 60.64 814.76 33.02 14.90 829.66 47.91 Annual downtime saving $23,959.94 26 $20,974.80
30 32.01 1016.23 1016.23 0.00 29.10 1045.33 29.10 1016.23 0.00 15.82 1032.05 15.82 30 $16,832.81
31 44.40 1060.63 1060.63 0.00 18.79 1079.42 18.79 1060.63 0.00 7.04 1067.67 7.04 31 $29,310.65
36 29.21 1157.53 1159.99 2.46 31.01 1191.00 33.47 1157.53 0.00 11.11 1168.63 11.11 36 $13,801.57
37 10.01 1167.54 1191.00 23.46 17.07 1208.06 40.53 1168.63 1.10 8.55 1177.18 9.64 37 $17,514.17
44 27.32 1335.61 1340.33 4.71 15.18 1355.51 19.90 1335.61 0.00 16.80 1352.41 16.80 44 $15,495.68
45 25.87 1361.48 1361.48 0.00 15.45 1376.92 15.45 1361.48 0.00 12.38 1373.86 12.38 45 $15,434.76
52 56.07 1531.15 1531.15 0.00 14.37 1545.52 14.37 1531.15 0.00 16.03 1547.18 16.03 52 $20,294.08
53 32.88 1564.03 1564.03 0.00 19.64 1583.66 19.64 1564.03 0.00 3.00 1567.03 3.00 53 $48,797.31
58 42.88 1735.38 1742.62 7.24 25.53 1768.15 32.77 1735.38 0.00 16.09 1751.47 16.09 58 $24,480.60
59 28.90 1764.28 1768.15 3.87 16.88 1785.03 20.75 1764.28 0.00 13.51 1777.79 13.51 59 $34,238.69
64 99.32 1979.23 1979.23 0.00 35.14 2014.37 35.14 1979.23 0.00 16.33 1995.56 16.33 64 $23,025.73
65 26.43 2005.66 2014.37 8.70 23.40 2037.76 32.10 2005.66 0.00 10.19 2015.85 10.19 65 $58,855.96
70 70.17 2180.67 2180.67 0.00 26.49 2207.17 26.49 2180.67 0.00 16.53 2197.21 16.53 70 $22,963.22
71 28.98 2209.65 2209.65 0.00 17.49 2227.14 17.49 2209.65 0.00 17.74 2227.39 17.74 71 $13,025.75
76 27.45 2351.68 2351.68 0.00 22.36 2374.04 22.36 2351.68 0.00 15.85 2367.53 15.85 76 $23,863.05
77 43.02 2394.70 2394.70 0.00 13.73 2408.43 13.73 2394.70 0.00 11.27 2405.97 11.27 77 $29,259.37
Problem 10-41
Old maintenance procedure
New maintenance procedure
86 10.73 2665.57 2693.86 28.29 28.92 2722.78 57.21 2665.84 0.27 13.15 2678.99 13.42 86 $43,781.25
87 16.24 2681.81 2722.78 40.98 18.50 2741.28 59.47 2681.81 0.00 14.29 2696.09 14.29 87 $15,892.95
94 7.35 2891.41 2920.08 28.68 17.11 2937.20 45.79 2902.01 10.60 13.95 2915.96 24.55 94 $21,594.40
95 18.65 2910.06 2937.20 27.14 13.77 2950.97 40.91 2915.96 5.90 11.48 2927.44 17.38 95 $12,701.42
100 0.70 2961.60 3037.00 75.40 31.47 3068.47 106.87 2992.34 30.74 13.34 3005.68 44.08 100 $20,069.31
101 32.09 2993.69 3068.47 74.78 21.02 3089.49 95.80 3005.68 11.99 16.16 3021.83 28.14 101 $27,284.33
106 6.15 3097.24 3161.54 64.30 16.73 3178.26 81.03 3109.95 12.71 18.47 3128.41 31.18 106 $17,111.56
107 6.58 3103.82 3178.26 74.45 16.78 3195.04 91.22 3128.41 24.60 19.98 3148.39 44.58 107 $25,985.94
112 26.07 3214.70 3266.63 51.93 28.21 3294.84 80.14 3214.70 0.00 14.82 3229.52 14.82 112 $21,323.30
113 33.72 3248.43 3294.84 46.41 19.68 3314.52 66.09 3248.43 0.00 3.62 3252.05 3.62 113 $14,865.96
118 47.18 3374.28 3397.38 23.10 31.79 3429.17 54.89 3374.28 0.00 21.17 3395.45 21.17 118 $45,520.02
119 6.90 3381.18 3429.17 47.99 21.08 3450.25 69.07 3395.45 14.27 13.74 3409.19 28.01 119 $26,275.75
124 62.10 3596.67 3596.67 0.00 20.86 3617.53 20.86 3596.67 0.00 13.87 3610.53 13.87 124 $26,010.43
125 50.94 3647.61 3647.61 0.00 25.80 3673.41 25.80 3647.61 0.00 8.55 3656.16 8.55 125 $31,465.48
130 1.44 3824.36 3846.21 21.85 25.46 3871.67 47.31 3835.42 11.06 16.35 3851.77 27.41 130 $20,219.17
131 43.57 3867.93 3871.67 3.74 26.94 3898.61 30.67 3867.93 0.00 15.06 3883.00 15.06 131 $20,832.37
138 41.58 4096.93 4096.93 0.00 16.77 4113.70 16.77 4096.93 0.00 19.56 4116.48 19.56 138 $16,120.02
139 69.66 4166.59 4166.59 0.00 15.18 4181.76 15.18 4166.59 0.00 11.89 4178.48 11.89 139 $22,322.29
144 13.55 4413.55 4453.65 40.10 18.15 4471.80 58.24 4429.66 16.11 15.69 4445.35 31.79 144 $21,815.77
145 9.01 4422.56 4471.80 49.24 22.25 4494.04 71.48 4445.35 22.79 21.19 4466.54 43.98 145 $33,161.56
152 11.18 4702.24 4720.88 18.64 20.72 4741.61 39.37 4707.48 5.24 14.38 4721.86 19.62 152 $13,275.79
153 12.86 4715.10 4741.61 26.51 26.06 4767.66 52.57 4721.86 6.76 22.76 4744.62 29.52 153 $30,075.19
158 106.73 4992.01 4992.01 0.00 28.42 5020.43 28.42 4992.01 0.00 7.33 4999.34 7.33 158 $15,832.37
159 30.40 5022.41 5022.41 0.00 13.61 5036.02 13.61 5022.41 0.00 17.12 5039.53 17.12 159 $19,997.77
162 4.12 5091.17 5113.15 21.98 23.90 5137.05 45.89 5097.59 6.43 16.62 5114.21 23.05 162 $21,381.24
163 60.45 5151.61 5151.61 0.00 22.94 5174.55 22.94 5151.61 0.00 11.34 5162.95 11.34 163 $21,269.01
170 27.50 5424.84 5424.84 0.00 25.65 5450.49 25.65 5424.84 0.00 6.77 5431.61 6.77 170 $17,446.64
171 48.92 5473.76 5473.76 0.00 5.00 5478.76 5.00 5473.76 0.00 18.85 5492.61 18.85 171 $29,248.48
176 24.86 5571.17 5607.98 36.81 25.45 5633.43 62.26 5571.17 0.00 14.93 5586.11 14.93 176 $22,762.27
177 5.28 5576.45 5633.43 56.98 13.78 5647.21 70.76 5586.11 9.65 16.07 5602.18 25.73 177 $20,584.83
186 3.31 5687.33 5798.15 110.82 12.58 5810.72 123.39 5716.66 29.33 11.66 5728.33 41.00 186 $19,440.21
187 19.82 5707.15 5810.72 103.57 20.25 5830.97 123.82 5728.33 21.18 15.86 5744.19 37.03 187 $25,883.99
194 88.39 5885.59 5944.31 58.72 17.76 5962.07 76.48 5885.59 0.00 11.70 5897.29 11.70 194 $20,410.10
195 6.25 5891.84 5962.07 70.23 15.65 5977.72 85.88 5897.29 5.45 14.97 5912.26 20.42 195 $33,553.56
200 37.17 6171.40 6171.40 0.00 28.49 6199.89 28.49 6171.40 0.00 13.44 6184.84 13.44 200 $17,879.95
