Spreadsheet: 93088a1c-9d38-4b99-8a7d-8050a25e63e6
Sheet: Sheet1

DRAFT 7-21-10 | Unnamed: 1 | Unnamed: 2 | Financial Analysis of ISU RFP # 61157 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  | Analysis is based on potential purchases projected for the first three years, up to the full term of the contract.
Companies Bidding ----> |  |  | Agilent |  |  | [NAME] |  |  | Varian
 |  |  | Unit cost |  |  | Unit cost |  |  | Unit cost
Equipment type | 3-5 year est.
1.  HPLC Systems | 30 | 1 | 31292 | 751008 |  | 24327 | 620338.5 | 4 | 25039 | 638494.5
 |  |  | Net Unit Cost | 25033.6 |  | Net Unit Cost | 20677.95 |  | Net Unit Cost | 21283.15
 |  |  | Value added | -47022.4 |  | Value added | -20677.95 |  | Value added | -21283.15
 |  |  | Adjusted cost | 703985.6 |  | Adjusted cost | 599660.55 |  | Adjusted cost | 617211.35
 |  |  | Equipment Discount | 0.2 |  | Equipment Discount | 0.15 |  | Equipment Discount | 0.15
 |  |  | Supply Discount | 0.2 |  | Supply Discount | 0.15 |  | Supply Discount | 0.08
II.  [NAME] | 15 |  | 13342 | 160104 |  | 13100 | 167025 | 2 | 15516 | 197829
 |  |  | Net Unit Cost | 10673.6 |  | Net Unit Cost | 11135 |  | Net Unit Cost | 13188.6
 |  |  | Value added | -13441.6 |  | Value added | -11135 |  | Value added | -13188.6
 |  |  | Adjusted cost | 146662.4 |  | Adjusted cost | 155890 |  | Adjusted cost | 184640.4
 |  |  | Equipment Discount | 0.2 |  | Equipment Discount | 0.15 |  | Equipment Discount | 0.15
 |  |  | Supply Discount | 0.2 |  | Supply Discount | 0.15 |  | Supply Discount | 0.08
 |  |  |  |  |  |  |  |  | [NAME] | -21453
III.  FTIR Systems | 3 |  |  |  |  | 30036 | 76591.8 |  | 21632 | 58406.4
 |  |  | Net Unit Cost |  |  | Net Unit Cost | 25530.6 |  | Net Unit Cost | 19468.8
 |  |  | Value added |  |  | Value added | -25530.6 |  | Value added | -19468.8
 |  |  | Adjusted cost |  |  | Adjusted cost | 51061.2 |  | Adjusted cost | 38937.60000000001
 |  |  | Equipment Discount |  |  | Equipment Discount | 0.15 |  | Equipment Discount | 0.1
 |  |  | Supply Discount |  |  | Supply Discount | 0.15 |  | Supply Discount | 0.08
IV. Gas Chromatograhy | 4 |  | 23291 | 74531.2 |  | 20565 | 69921 | 3 | 22350 | 75990
 |  |  | Net Unit Cost | 18632.8 |  | Net Unit Cost | 17480.25 |  | Net Unit Cost | 18997.5
 |  |  | Value added | -20688 |  | Value added | -17480.25 |  | Value added | -18997.5
 |  |  | Adjusted cost | 53843.2 |  | Adjusted cost | 52440.75 |  | Adjusted cost | 56992.5
 |  |  | Equipment Discount | 0.2 |  | Equipment Discount | 0.15 |  | Equipment Discount | 0.15
 |  |  | Supply Discount | 0.2 |  | Supply Discount | 0.15 |  | Supply Discount | 0.08
[NAME] | 8 |  | 59969 | 383801.6 |  | 93376 | 634956.8 |  | 91783 | 624124.4
 |  |  | Net Unit Cost | 47975.2 |  | Net Unit Cost | 79369.6 |  | Net Unit Cost | 78015.55
 |  |  | Value added | -72372.8 |  | Value added | -79369.6 |  | Value added | -78015.55
 |  |  | Adjusted cost | 311428.8 |  | Adjusted cost | 555587.2000000001 |  | Adjusted cost | 546108.85
 |  |  | Equipment Discount | 0.2 |  | Equipment Discount | 0.15 |  | Equipment Discount | 0.15
 |  |  | Supply Discount | 0.2 |  | Supply Discount | 0.15 |  | Supply Discount | 0.08
VI.  LC/MS Systems | 2 |  | 141425 | 226280 |  |  |  |  | 258583 | 439591.1
 |  |  | Net Unit Cost | 113140 |  | Net Unit Cost |  |  | Net Unit Cost | 219795.55
 |  |  | Value added | 0 |  | Value added |  |  | Value added | -219795.55
 |  |  | Adjusted cost | 226280 |  | Adjusted cost |  |  | Adjusted cost | 219795.55
 |  |  | Equipment Discount | 0.2 |  | Equipment Discount |  |  | Equipment Discount | 0.15
 |  |  | Supply Discount | 0.2 |  | Supply Discount |  |  | Supply Discount | 0.08
 |  |  | 310384 | 496614.4 |  |  |  |  | 141322 | 240247.4
 |  |  | Net Unit Cost | 248307.2 |  |  |  |  | Net Unit Cost | 120123.7
 |  |  | Value added | -248307.2 |  |  |  |  | Value added | 0
 |  |  | Adjusted cost | 248307.2 |  |  |  |  | Adjusted cost | 240247.4
 |  |  | Equipment Discount | 0.2 |  |  |  |  | Equipment Discount | 0.15
 |  |  | Supply Discount | 0.2 |  |  |  |  | Supply Discount | 0.08
VII.  [NAME] | 1 |  |  |  |  | 54523 | 46344.55 |  | 61545.88 | 52313.998
 |  |  | Net Unit Cost |  |  | Net Unit Cost | 46344.55 |  | Net Unit Cost | 52313.998
 |  |  | Value added |  |  | Value added | -46344.55 |  | Value added | -52313.998
 |  |  | Adjusted cost |  |  | Adjusted cost | 0 |  | Adjusted cost | 0
 |  |  | Equipment Discount |  |  | Equipment Discount | 0.15 |  | Equipment Discount | 0.15
 |  |  | Supply Discount |  |  | Supply Discount | 0.15 |  | Supply Discount | 0.08
VIII. CE Systems | 1 |  | 67636 | 54108.8
 |  |  | Net Unit Cost | 54108.8 |  | Net Unit Cost |  |  | Net Unit Cost
 |  |  | Value added | 0 |  | Value added |  |  | Value added
 |  |  | Adjusted cost | 54108.8 |  | Adjusted cost |  |  | Adjusted cost
 |  |  | Equipment Discount | 0.2 |  | Equipment Discount |  |  | Equipment Discount
 |  |  | Supply Discount | 0.2 |  | Supply Discount |  |  | Supply Discount
IX.  Maldi TOF/MS | 3
 |  |  | Net Unit Cost |  |  | Net Unit Cost |  |  | Net Unit Cost
 |  |  | Value added |  |  | Value added |  |  | Value added
 |  |  | Adjusted cost |  |  | Adjusted cost |  |  | Adjusted cost
 |  |  | Equipment Discount |  |  | Equipment Discount |  |  | Equipment Discount
 |  |  | Supply Discount |  |  | Supply Discount |  |  | Supply Discount
X.  Analytical Software | 1 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  | Discount | 0.2 |  | Discount | 0.15 |  | Discount | 0.15
Misc. Value Added
Total projected cost |  |  |  | 2146448 |  |  | 1615177.65 |  |  | 2326996.798
Total Value Added |  |  |  | -401832 |  |  | -200537.95 |  |  | -444516.148
Adjusted  total cost |  |  |  | 1744616 |  |  | 1414639.7 |  |  | 1882480.65
[NAME] in % |  |  |  | 0.1872078894993031 |  |  | 0.1241584478338962 |  |  | 0.1910256809902151
Offer comparison notes: | 1 Agilent added an auto sampler which was removed for equivalent price comparison to Perkin Elmer
 | 2 [NAME] water bath removed, not requested.
 | 3 Varian GC two detectors and auto sampler removed to make better price comparison.
 | 4 Varian LC two detectors and auotsampler removed tp make better price comparison.
Three to five year cost analysis allows ISU to consider the full instrument value for demonstration lab equipment.
Value added is calculated at the cost ISU would pay for equipment at the vendors contract price.  Out typical expeerience is that leasing
for 5 years will cost more than the purchase price of equipment.  Therefore the value of the demo lab equipment is
calculated as the purchase price of the equipment.