Spreadsheet: 600254d1543570746-calculate-cost-of-service-over-5-years-based-on-services-due-frequency-copy-of-komatsu-830e-lcc-example-v2
Sheet: Plant Rate Summary

 |  | AVAIL.   CAT. | CLEM.  CAT. | QTY | EXPENSE CAT. | LAST | FREQ. | Hierarchy | TOTAL COST | Per hour cost
GROUP | [NAME] | - | - | # | CPX / OPX | Hr | Hr | Hr | $
 | Machine Frame Arrangement | Comp. | E | 1 | Capex | 0 | 150000 | P-1 | 2538156.9426
 | Machine [NAME] | Comp. | E | 1 | Capex | 0 | 60000 | P-1 | 472638
 | Machine Electrical Overhaul | Comp. | E | 1 | Capex | 0 | 60000 | P-1 | 222638
 | [NAME] | Comp. | E | 1 | Capex | 0 | 60000 | P-1 | 122638
Dump Truck Komatsu 830E | Dump Truck Komatsu 830E |  |  | 1 | Capex | 0 | 60000 | P-1 | 5970000
 | Engine ([NAME]) (30% Load Factor) | Comp. |  | 1 | Capex | 0 | 30000 | P-1 | 611657.6399999999
 | Engine 'D' Service | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 9240
 | Starter Motor | Comp. |  | 1 | Opex | 0 | 6500 | C-1 | 15580.5912
 | Starter Motor | Comp. |  | 1 | Opex | 0 | 6500 | C-1 | 15580.5912
 | Alternator - 140 Amp | Comp. |  | 1 | Opex | 0 | 6500 | C-1 | 1009.4808
 | TURBO LP-Front | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 6660
 | TURBO LP-Rear | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 6660
 | TURBO HP-Left | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 8660
 | TURBO HP-Right | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 8660
 | FUEL PUMP | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 4660
 | INJECTORS | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 29320
 | WATER PUMP | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 6660
 | PRELUBE | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 5660
 | FAN CLUTCH | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 38010.2
 | A/C COMPRESSOR | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 2296.72
 | Radiator/Shroud Assembly (Repair) | Comp. |  | 1 | Opex | 0 | 30000 | C-1 | 52264.9008
 | Grid Resitor Repairs (Repair) | Comp. |  | 1 | Opex | 0 | 6500 | P-2 | 24807.42662399999
 | Grid Blower Motor (Reman) | Comp. |  | 1 | Opex | 0 | 30000 | P-3 | 48296.4768
 | RP Contactor (Repair) | Comp. |  | 1 | Opex | 0 | 6500 | P-4 | 16954.88
 | GF & GFR Contactor (Repair) | Comp. |  | 1 | Opex | 0 | 6500 | P-5 | 4214.306
 | Wheel Motor (Reman) | Comp. |  | 1 | Capex | 0 | 30000 | P-6 | 600828.4799999999
 | Wheel Motor (Reman) | Comp. |  | 1 | Capex | 0 | 30000 | P-7 | 600828.4799999999
 | HV Alternator (Reman) | Comp. |  | 1 | Capex | 0 | 30000 | C-6 | 73909.05215999999
 | Drive shaft - [NAME] | Comp. |  | 1 | Opex | 0 | 18000 | C-7 | 4457.397312
 | Hoist Pump | Comp. |  | 1 | Opex | 0 | 25000 | P-10 | 28772.083488
 | Steering & Brake Pump | Comp. |  | 1 | Opex | 0 | 11000 | P-11 | 21301.52304
 | Hoist Control Valve | Comp. |  | 1 | Opex | 0 | 44000 | P-12 | 44930.352384
 | Brake Treadle Valve | Comp. |  | 1 | Opex | 0 | 18000 | P-13 | 8062.1352
 | [NAME] | Comp. |  | 1 | Opex | 0 | 25000 | P-14 | 11269.992672
 | Steering [NAME] | Comp. |  | 1 | Opex | 0 | 14000 | P-15 | 3869.451215999999
 | Bleed [NAME] (Repair) | Comp. |  | 1 | Opex | 0 | 25000 | P-16 | 6367.876704
 | [NAME] (Repair) | Comp. |  | 1 | Opex | 0 | 25000 | P-17 | 9482.213087999999
 | Steering Accumulator | Comp. |  | 1 | Opex | 0 | 14000 | P-18 | 29711.20032
 | Brake Accumulator | Comp. |  | 1 | Opex | 0 | 14000 | P-19 | 13992.011136
 | [NAME] (Reman) | Comp. |  | 1 | Opex | 0 | 25000 | P-20 | 77046.706752
 | [NAME] (Reman) | Comp. |  | 1 | Opex | 0 | 25000 | P-21 | 77046.706752
 | Steering Cylinder (Reman) | Comp. |  | 1 | Opex | 0 | 14000 | P-22 | 19537.318368
 | Steering Cylinder (Reman) | Comp. |  | 1 | Opex | 0 | 14000 | P-23 | 19537.318368
 | Steering Tie Rod Pins & Bushes | Comp. |  | 1 | Opex | 0 | 14000 | P-24 | 17565.866928
 | Rear Axle Nose Cone | Comp. |  | 1 | Opex | 0 | 18000 | P-25 | 29376.457488
 | Anti-Sway Bar Bushes | Comp. |  | 1 | Opex | 0 | 25000 | P-26 | 16805.454912
 | Dump Body Pads, Pins & Bushes | Comp. |  | 1 | Opex | 0 | 25000 | P-27 | 37293.63945599999
 | Front Corner ([NAME]) (Reman) | Comp. |  | 1 | Opex | 0 | 18000 | P-28 | 214349.224032
 | Front Corner ([NAME]) (Reman) | Comp. |  | 1 | Opex | 0 | 18000 | P-29 | 214349.224032
 | Front Brake Pads | Comp. |  | 1 | Opex | 0 | 9000 | P-30 | 7941.398592
 | Front Brake Pads | Comp. |  | 1 | Opex | 0 | 9000 | P-31 | 7941.398592
 | Rear Suspension (Reman) | Comp. |  | 1 | Opex | 0 | 25000 | P-32 | 64189.82419199999
 | Rear Suspension (Reman) | Comp. |  | 1 | Opex | 0 | 25000 | P-33 | 64189.82419199999
 | Rear Suspension Pins & Bushes | Comp. |  | 1 | Opex | 0 | 25000 | P-34 | 30202.33996799999
 | Rear Brake Discs | Comp. |  | 1 | Opex | 0 | 12000 | P-35 | 17097.620544
 | Rear Brake Discs | Comp. |  | 1 | Opex | 0 | 12000 | P-36 | 17097.620544
 | Rear Brake Caliper Kit (Repair) | Comp. |  | 1 | Opex | 0 | 24000 | P-37 | 16505.038272
 | Rear Brake Caliper Kit (Repair) | Comp. |  | 1 | Opex | 0 | 24000 | [NAME] | 16505.038272
 | Rear Brake Pads | Comp. |  | 1 | Opex | 0 | 6000 | [NAME] | 7283.518848
 | Rear Brake Pads | Comp. |  | 1 | Opex | 0 | 6000 | P-40 | 7283.518848
 | Seat Assembly (Operator) | Comp. |  | 1 | Opex | 0 | 5000 | P-41 | 6926.399519999999
 | Refrigerant Compressor (A/C) | Comp. |  | 1 | Opex | 0 | 5000 | P-42 | 1746.914736
 | Auto Lube Pump | Comp. |  | 1 | Opex | 0 | 14000 | P-43 | 10342.261584
 | [NAME] | Comp. |  | 1 | Opex | 0 | 12000 | P-44 | 91088
[NAME] | [NAME] | Rep. | AC | 1 | Opex | 0 | 1000 | - | 1665
[NAME] | Bucket, Bowls & Bodies - Unassigned | Cons. | BBB | 1 | Opex | 0 | 1000 | - | 6470
[NAME] | [NAME] | Rep. | B | 1 | Opex | 0 | 1000 | - | 5644.999999999999
[NAME] | Chassis - Unassigned | Rep. | C | 1 | Opex | 0 | 1000 | - | 4775
[NAME] | Engine - Unassigned | Rep. | E | 1 | Opex | 0 | 1000 | - | 3780
[NAME] | Electrical - Unassigned | Rep. | EL | 1 | Opex | 0 | 1000 | - | 1825
[NAME] | GET - Unassigned | Cons. | G | 1 | Opex | 0 | 1000 | - | 0.00166
[NAME] | Hydraulic - Unassigned | Rep. | H | 1 | Opex | 0 | 1000 | - | 2160
[NAME] | High Voltage Propulsion - Unassigned | Rep. | HV | 1 | Opex | 0 | 1000 | - | 4675
[NAME] | [NAME] | Rep. | L | 1 | Opex | 0 | 1000 | - | 365
[NAME] | Power Train - Unassigned | Rep. | P | 1 | Opex | 0 | 1000 | - | 0.00166
[NAME] | Servicing - Unassigned | Rep. | S | 1 | Opex | 0 | 1000 | - | 990
[NAME] | Steering - Unassigned | Rep. | ST | 1 | Opex | 0 | 1000 | - | 2160
[NAME] | Tyres - Unassigned | Cons. | T | 1 | Opex | 0 | 1000 | - | 265
[NAME] | [NAME] | Rep. | W | 1 | Opex | 0 | 1000 | - | 0.00166
[NAME] | NDT Inspection | Serv. | S | 1 | Opex | 0 | 2000 | - | 1495
[NAME] | FSS Servicing | Serv. | S | 1 | Opex | 0 | 2000 | - | 1665
[NAME] | Air Filter - Engine - Outer - XA4292 | Serv. | E | 1 | Opex | 0 | 500 | - | 1402.81
[NAME] | Air Filter - Engine - Inner - XA4291 | Serv. | E | 1 | Opex | 0 | 1000 | - | 368.61
[NAME] | Air Filter - Cab - Fresh - PB7001 | Serv. | E | 1 | Opex | 0 | 500 | - | 88.05
[NAME] | Air Filter - Cab - Recirc - EM0055 | Serv. | E | 1 | Opex | 0 | 1000 | - | 75.00999999999999
[NAME] | Contactor Tips (Repair) | Serv. | E | 1 | Opex | 0 | 2000 | - | 548.88
[NAME] | 250 Hour PM Service | Serv. | S | 1 | Opex | 0 | 500 | - | 1783.24
[NAME] | 500 Hour PM Service | Serv. | S | 1 | Opex | 0 | 1000 | - | 5748.190000000001
[NAME] | 1000 Hour PM Service | Serv. | S | 1 | Opex | 0 | 2000 | - | 7683
[NAME] | 2000 Hour PM Service | Serv. | S | 1 | Opex | 0 | 2000 | - | 12633
 |  |  |  |  |  |  |  |  |  |  | 2019-07-31 00:00:00