Code | Name | Hours | Materials |
---|---|---|---|
73 | Compressed air systems | ||
731 | Starting air systems | 200 | |
731.001 | Starting air compressor | $150,000 | |
731.003 | Starting air emergency compressor | $98,000 | |
731.005 | Starting air water/oil separator | $17,000 | |
731.010 | Starting air tanks | $33,000 | |
731.012 | Starting air bottles | $9,500 | |
731.014 | Starting air coolers | $12,000 | |
731.016 | Starting air compressor silencers | $5,000 |
Code | Name | Planned | Actual | Difference |
---|---|---|---|---|
731.001 | Starting air compressor | 150,000 | 158,000 | +8,000 |
Code | Name | Planned | Actual | Difference |
---|---|---|---|---|
731 | Starting air systems | 200 | 210 | +10 |
=VLOOKUP(value,group_table,column,TRUE)
=VLOOKUP(D5,G5:H8,2,TRUE)