S02 - Attachment D - (SAMPLE COMPLETED) Pricing Volumes (7 Years)_1-17-2023.xlsx

XLSX spreadsheet 238 KB Posted

Attached to
6550--ID/AST/MALDI CPT Solution IDIQ VISN 22 - Seven (7) Stations Federal contract opportunity
Solicitation number
36C26223Q0138
Issued by
Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 22

View the file

Other files for this federal contract opportunity

Other files attached to 6550--ID/AST/MALDI CPT Solution IDIQ VISN 22 - Seven (7) Stations, newest first.
File Type Posted
S02 - RFQ-36C26223Q0138_Amendment0001.docx DOCX document
36C26223Q0138 0001_1.docx DOCX document
S02 - Attachment A - Pricing Volumes (7 Years)_1-17-2023.xlsx XLSX spreadsheet
S02 - Attachment B - VA Handbook 6500.6_Appendix C_1-17-2023.pdf PDF
S02 - RFQ-36C26223Q0138_ID_AST_MALDI_01-17-2023.docx DOCX document
36C26223Q0138.docx DOCX document

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

1. VISN CPT

Test DescriptionVISN 22 Estimated Annual Test VolumesVISN 22 Estimated 5-Year Test Total
(Column K)VISN 22 Estimated 5-Year Test Extended Price
(Column U x Column I)VISN 22 Estimated Year 6-7 Test Total
(SUM of Column P-Q)VISN 22 Estimated Year 6-7 Test Extended Price (Reagent Service Only)
(Column (C+G) x Column W)VISN 22 Estimated Year 1-7 Test Total
(SUM of Column K-Q)VISN 22 Estimated 7-Year Test Extended Price

(Column V x Column X)

Reagent CPTINSTRUMENTS / Capital PurchaseOTHER HW SW TRAINING / Capital PurchaseTRACK/
5 year volumeService / Licensing CPTInstall / Capital PurchaseTOTAL CPT (Years 1 -5)TOTAL CPT (Years 6 - 7)Base Period 5 YearsBase Period Year 2Base Period Year 3Base Period Year 4Base Period Year 5Option Year 1Option Year 2
estimated 3% increaseestimated 3% increaseestimated 3% increaseestimated 3% increaseestimated 3% increaseestimated 3% increase
ID GN$3.0000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$7.9172$7.917216,500- 0- 0- 0- 03,3993,50116,500$ 130,634.506,900$ 54,628.7323,400$ 185,263.23
AST GN$3.0000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$7.9172$7.9172357,300- 0- 0- 0- 073,60475,812357,300$ 2,828,830.67149,416$ 1,182,960.41506,716$ 4,011,791.07
ID GP$3.0000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$7.9172$7.91729,700- 0- 0- 0- 01,9992,0599,700$ 76,797.254,058$ 32,127.9313,758$ 108,925.18
AST GP Staph$2.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$7.4172$7.417283,500- 0- 0- 0- 017,20117,71783,500$ 619,339.7334,918$ 258,995.49118,418$ 878,335.22
AST GP Strep$2.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$7.4172$7.417214,900- 0- 0- 0- 03,0703,16214,900$ 110,516.916,232$ 46,225.0021,132$ 156,741.91
ID Yeast$2.0000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$6.9172$6.91721,600- 0- 0- 0- 03303401,600$ 11,067.59670$ 4,633.862,270$ 15,701.45
AST Yeast$2.0000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$6.9172$6.91723,900- 0- 0- 0- 08048283,900$ 26,977.241,632$ 11,289.775,532$ 38,267.01
ID ANC$1.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$6.4172$6.41722,700- 0- 0- 0- 05575742,700$ 17,326.551,131$ 7,256.043,831$ 24,582.59
ID NH$1.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$6.4172$6.41721,500- 0- 0- 0- 03093181,500$ 9,625.86627$ 4,025.342,127$ 13,651.21
ID GN Mass Spec$0.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$5.4172$5.4172164,500- 0- 0- 0- 033,88734,904164,500$ 891,136.3568,791$ 372,655.40233,291$ 1,263,791.76
ID GP Mass Spec$0.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$5.4172$5.417289,250- 0- 0- 0- 018,38618,93889,250$ 483,488.8737,324$ 202,190.88126,574$ 685,679.75
ID Yeast Mass Spec$0.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$5.4172$5.417212,650- 0- 0- 0- 02,6062,68412,650$ 68,528.115,290$ 28,658.1917,940$ 97,186.30
ID ANC Mass Spec$0.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$5.4172$5.41725,400- 0- 0- 0- 01,1131,1465,400$ 29,253.112,259$ 12,239.667,659$ 41,492.77
ID NH Mass Spec$0.5000$1,465,000.0000$280,000.0000$0.0000$4.9172$225,000.0000$5.4172$5.41723,900- 0- 0- 0- 08048283,900$ 21,127.241,632$ 8,841.595,532$ 29,968.83
767,300- 0- 0- 0- 0158,069162,811- 0- 0767,300$ 5,324,650.00320,880$ 2,226,728.291,088,180$ 7,551,378.29

&"-,Bold"ATTACHMENT C

2. EST ANNUAL SITE VOL

Loma LindaLong BeachLos Angeles ACCPhoenixPrescottSan DiegoSanta MariaSepulvedaTucsonGreater Los AngelesNew MexicoVISN 22 TOTAL ANNAUL VOLUME
Est. Test Volume# of ControlsEst. 5% Repeat Rate (B+C)*.05Est. Test Volume# of ControlsEst. 5% Repeat Rate (F+G)*.05Est. Test Volume# of ControlsEst. 5% Repeat RateEst. Test Volume# of ControlsEst. 5% Repeat Rate (N+O)*.05Est. Test Volume# of ControlsEst. 5% Repeat RateEst. Test Volume# of ControlsEst. 5% Repeat Rate (V+W)*.05Est. Test Volume# of ControlsEst. 5% Repeat RateEst. Test Volume# of ControlsEst. 5% Repeat RateEst. Test Volume# of ControlsEst. 5% Repeat Rate (AH+AI)*.05Est. Test Volume# of ControlsEst. 5% Repeat Rate (AL+AM)*.05Est. Test Volume# of ControlsEst. 5% Repeat Rate (AP+AQ)*.05
ID GN430152246742020224628877750450152348840825300021916002031651779375042789702943675015097202037777340451940434020183783300
AST GN43005002405040880061247198836700550363761318591150030059012390080004164218837830042043691563400420191401156929
ID GP260101428420010112210340151837372446020245040002002011231280361633220020112312175
AST GP Staph260031214630582000460123258330003251663491300030016534651200312761588310036017336331800480114239420211
AST GP Strep700156438993602323062240016528593130024077161700000000220250244944224
ID Yeast804488601047440524740203630000603551004030474445
AST Yeast000022014418382200100153152001201633600000000160140153151348
ID ANC40825001011120010112214020363000026025142990000644
ID NH60436700002005102150000000040203630000345
ID GN Mass Spec4300365233489842003652284793450036524351086000365318668372003653787943330073020242323400730207433737994
ID GP Mass Spec26000130273018509319433000015031504500022547252000010021002800014029401100055115518743
ID Yeast Mass Spec72036554113946036541866350365367512403653063500005007306212922607305010405723
ID ANC Mass Spec3800193990000200010210240012252000026001327300001134
ID NH Mass Spec44002246200002000102101000510500004002420000819
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
16,9101,73993219,58118,5702,2281,04021,8388,877750- 09,62719,7801,9201,08522,78541,0823,0002,20446,28628,2201,7701,50031,4907,7937504278,97029,4367501,50931,69519,3201,1331,02321,47619,2802,4011,08422,76510,9202,82068714,427250,940

3. REAGENTS CPT

PARTIAL COST PER TEST
(Cost of single test including all Reagents and Consumables Only)VISN22

ANNUAL VOLUME PER TEST

(VOLUME PROVIDED FOR INFORMATIONAL PURPOSES ONLY ---DO NOT PROVIDE AN EXTENDED OR PACKAGE COST)Please identify what Reagents and Consumables are required to run a single test
ID GN$3.00003,300Reagent A, Nozzel, Control A
AST GN$3.000056,929Reagent B, Card, Control B
ID GP$3.00002,175Reagent C, Nozzel, Card, Control C
AST GP Staph$2.500020,211etc
AST GP Strep$2.50004,224etc
ID Yeast$2.0000445etc
AST Yeast$2.00001,348etc
ID ANC$1.5000644etc
ID NH$1.5000345etc
ID GN Mass Spec$0.500037,994etc
ID GP Mass Spec$0.500018,743etc
ID Yeast Mass Spec$0.50005,723etc
ID ANC Mass Spec$0.50001,134etc
ID NH Mass Spec$0.5000819etc
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
0- 0
154,034

4. INSTRUMENTS

InstrumentsPart/Product #CostLoma LindaLong BeachLos Angeles
ACCPhoenixPrescottSan DiegoSanta MariaSepulvedaTucsonGreater
Los AngelesNew MexicoVISN 22
TOTAL QTYVISN 22

EXTENDED

COSTS

DescriptionIndicate quantity per site
Mass SpecABC$100,000.000011111117$700,000.0000
Analyzer 100XYZ$85,000.000011121219$765,000.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
- 0$0.0000
Total Cost$1,465,000.0000

5. OTHER

OTHER HARDWARE / SOFTWARE / TRAINING
(Do not include software licenses, include licenses in Service)Part/Product #CostLoma LindaLong BeachLos Angeles
ACCPhoenixPrescottSan DiegoSanta MariaSepulvedaTucsonGreater
Los AngelesNew MexicoVISN 22
TOTAL QTYVISN 22

EXTENDED

COSTS

DESCRIPTIONIndicate quantity per site
Hardware ADEF$ 25,000.0011111117$175,000.0000
Hardware BGHI$ 10,000.0011111117$70,000.0000
SoftwareJKL$ 5,000.0011111117$35,000.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
Total Cost$280,000.0000

6. TRACK

TRACKPart #CostLoma LindaLong BeachLos Angeles
ACCPhoenixPrescottSan DiegoSanta MariaSepulvedaTucsonWest
Los AngelesNew MexicoVISN 22
TOTAL QTYVISN 22

EXTENDED

COSTS

DESCRIPTIONIndicate quantity per site
Track 1 component (example)$0.00000$0.0000
Track 2 component (example)$0.00000$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
0$0.0000
Total Cost$0.0000
5 Year CPT Cost$0.0000

7. SERVICE

Annual Service Cost, to include Software Licensing, (as outlined in SOW)Loma LindaLong BeachLos Angeles ACCPhoenixPrescottSan DiegoSanta MariaSepulvedaTucsonGreater Los AngelesNew MexicoTOTAL COST per TEST
Total Number of years =
7
PM & Service Agreement ($10K x 7 years)$ 70,000.00$ 70,000.00$ 70,000.00$ 70,000.00$ 70,000.00$ 70,000.00$ 70,000.00$490,000.0000
Licensing ($1K x 7 years)$ 7,000.00$ 7,000.00$ 7,000.00$ 7,000.00$ 7,000.00$ 7,000.00$ 7,000.00$49,000.0000
$0.0000
$0.0000
$0.0000
$0.0000
$0.0000
$0.0000
$0.0000
Total Service Cost$3,773,000.0000
CPT Addition to Service$ 4.917242

8. INSTALL

Base Equipment Installation RequirementsDescriptionCost
Loma LindaEarthquake mounting plate, installation of instumentation, validation.$25,000.00
Long Beach$25,000.00
LosAngeles ACC
Phoenix$25,000.00
Prescott
San Diego$50,000.00
Santa Maria
Supulveda
Tucson$25,000.00
Greater Los Angeles$50,000.00
New Mexico$25,000.00
Total$225,000.00

9. IND ITEM COST

Item / ReagentItem number
OEMUnit of MeasureCOSTComments
Reagent AX123EA$2.5000
NozzelX123aEA$0.5000
Expedited ShippingSHIPEA$25.0000

10. OPT TESTS

Optional TestsPARTIAL COST PER TEST
(Cost of single test including all Reagents and Consumables Only)VISN22

ANNUAL VOLUME PER TEST

(VOLUME PROVIDED FOR INFORMATIONAL PURPOSES ONLY ---DO NOT PROVIDE AN EXTENDED OR PACKAGE COST)Please identify what Reagents and Consumables are required to run a single test
Option D$3.0000Reagent D, Nozzel, Control D

- 0

11. OPT AUTOMATION

12. OPT AUTOMATION INSTALL

File details come from the government source that posted it. Updated .