Mock Lab Services Scenario_UTARNG Lab Services BPA.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- 5-Year UTARNG Lab Services Blanket Purchase Agreement (BPA) Federal contract opportunity
- Solicitation number
- W911YP25RA005
About this file
This is a pricing template spreadsheet and related solicitation for a 5-year Blanket Purchase Agreement (BPA) for medical laboratory services required by the Utah Army National Guard. The spreadsheet details historical usage data for 57 different types of laboratory tests including blood work, urinalysis, and other medical screenings, with monthly quantities provided for a full year.
The solicitation (W911YP25RA005) is structured as a total small business set-aside under NAICS 621511 with a size standard of $41.5M. Proposals are due by 0800 MST on March 25, 2025. The BPA will be awarded on a Lowest Price Technically Acceptable basis for five 1-year ordering periods. Key requirements include daily local pickup Monday-Thursday and testing within 24 hours by a laboratory located in Davis, Salt Lake, or Utah counties. Services will be performed at the Utah Army National Guard Joint Force Headquarters Facility in Draper, UT. Payment will be made via Electronic Funds Transfer or Government Purchase Card when authorized. The solicitation emphasizes that vendors must be registered in SAM.gov and maintain registration throughout the contract period.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| SF1449_W911YP25RA005_UTARNG Lab Services BPA.pdf | ||
| Statement of Work (UPDATED 2-24-25)_Lab Services BPA.pdf |
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
Text version
Sheet1
| Test Num/TestName | Ind. Price | QTY | AUG | QTY | SEPT | QTY | OCT | QTY | NOV | QTY | DEC | QTY | JAN | QTY | FEB | QTY | MAR | QTY | APR | QTY | MAY | QTY | JUN | QTY | JUL | Ind. Price | Total QTY | Total Cost | FY2025 | FY2026 | FY2027 | FY2028 | FY2029 | ||||||||||
| 001917/G-6-PD, QUANT, BLOOD AND RBC | 43 | 56 | 85 | 54 | 58 | 28 | 93 | 36 | 30 | 11 | 82 | 41 | 617 | $0.00 | 617 | $0.00 | 617 | $0.00 | 617 | $0.00 | 617 | $0.00 | 617 | $0.00 | |||||||||||||||||||
| 003038/URINALYSIS, ROUTINE | 10 | 15 | 1 | 2 | 6 | 1 | 35 | $0.00 | 35 | $0.00 | 35 | $0.00 | 35 | $0.00 | 35 | $0.00 | 35 | $0.00 | |||||||||||||||||||||||||
| 003772/URINALYSIS, COMPLETE | 9 | 6 | 24 | 20 | 18 | 34 | 29 | 23 | 31 | 20 | 20 | 17 | 251 | $0.00 | 251 | $0.00 | 251 | $0.00 | 251 | $0.00 | 251 | $0.00 | 251 | $0.00 | |||||||||||||||||||
| 005058/HEMATOCRIT | 7 | 8 | 15 | 10 | 8 | 21 | 21 | 14 | 15 | 11 | 13 | 9 | 152 | $0.00 | 152 | $0.00 | 152 | $0.00 | 152 | $0.00 | 152 | $0.00 | 152 | $0.00 | |||||||||||||||||||
| 321211/CMP14+LP+RPR+SICKLE+CBC/PLT | 6 | 11 | 9 | 7 | 8 | 5 | 3 | 6 | 10 | 6 | 4 | 3 | 78 | $0.00 | 78 | $0.00 | 78 | $0.00 | 78 | $0.00 | 78 | $0.00 | 78 | $0.00 | |||||||||||||||||||
| 006049/ABO GROUPING AND RHO(D) TYPING | 5 | 17 | 16 | 13 | 38 | 7 | 54 | 17 | 11 | 4 | 13 | 12 | 207 | $0.00 | 207 | $0.00 | 207 | $0.00 | 207 | $0.00 | 207 | $0.00 | 207 | $0.00 | |||||||||||||||||||
| 321206/CMP14+LP+UA/M+CBC/PLT | 10 | 17 | 11 | 6 | 6 | 16 | 8 | 15 | 7 | 10 | 10 | 8 | 124 | $0.00 | 124 | $0.00 | 124 | $0.00 | 124 | $0.00 | 124 | $0.00 | 124 | $0.00 | |||||||||||||||||||
| 007286/CHOLINESTERASE, RBC | 3 | 5 | 3 | 1 | 2 | 4 | 18 | $0.00 | 18 | $0.00 | 18 | $0.00 | 18 | $0.00 | 18 | $0.00 | 18 | $0.00 | |||||||||||||||||||||||||
| 001032/GLUCOSE | 3 | 1 | 2 | 3 | 1 | 1 | 5 | 2 | 4 | 11 | 33 | $0.00 | 33 | $0.00 | 33 | $0.00 | 33 | $0.00 | 33 | $0.00 | 33 | $0.00 | |||||||||||||||||||||
| 004556/HCG,BETA SUBUNIT,QUAL,SERUM | 3 | 12 | 2 | 1 | 2 | 2 | 4 | 7 | 2 | 1 | 5 | 18 | 59 | $0.00 | 59 | $0.00 | 59 | $0.00 | 59 | $0.00 | 59 | $0.00 | 59 | $0.00 | |||||||||||||||||||
| 303756/LIPID PANEL | 3 | 1 | 3 | 4 | 11 | 9 | 8 | 11 | 6 | 8 | 23 | 87 | $0.00 | 87 | $0.00 | 87 | $0.00 | 87 | $0.00 | 87 | $0.00 | 87 | $0.00 | ||||||||||||||||||||
| 010322/PROSTATE-SPECIFIC AG, SERUM | 3 | 2 | 3 | 3 | 8 | 7 | 6 | 7 | 6 | 6 | 1 | 52 | $0.00 | 52 | $0.00 | 52 | $0.00 | 52 | $0.00 | 52 | $0.00 | 52 | $0.00 | ||||||||||||||||||||
| 005009/CBC WITH DIFFERENTIAL/PLATELET | 2 | 2 | 2 | 2 | 6 | 4 | 1 | 2 | 2 | 23 | $0.00 | 23 | $0.00 | 23 | $0.00 | 23 | $0.00 | 23 | $0.00 | 23 | $0.00 | ||||||||||||||||||||||
| 007625/LEAD, BLOOD (ADULT) | 2 | 3 | 1 | 2 | 4 | 12 | $0.00 | 12 | $0.00 | 12 | $0.00 | 12 | $0.00 | 12 | $0.00 | 12 | $0.00 | ||||||||||||||||||||||||||
| 313174/CMP14+LP | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 2 | 13 | $0.00 | 13 | $0.00 | 13 | $0.00 | 13 | $0.00 | 13 | $0.00 | 13 | $0.00 | |||||||||||||||||||||||
| 321207/CMP14+LP+PSA+UA/M+CBC/PLT | 4 | 5 | 11 | 3 | 9 | 1 | 3 | 3 | 3 | 6 | 3 | 2 | 53 | $0.00 | 53 | $0.00 | 53 | $0.00 | 53 | $0.00 | 53 | $0.00 | 53 | $0.00 | |||||||||||||||||||
| 001107/ALKALINE PHOSPHATASE | 1 | 1 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | |||||||||||||||||||||||||||||
| 001545/ALT (SGPT) | 1 | 2 | 3 | 1 | 1 | 1 | 9 | $0.00 | 9 | $0.00 | 9 | $0.00 | 9 | $0.00 | 9 | $0.00 | 9 | $0.00 | |||||||||||||||||||||||||
| 001123/AST (SGOT) | 1 | 3 | 1 | 1 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | |||||||||||||||||||||||||||
| 322758/BASIC METABOLIC PANEL (8) | 2 | 3 | 1 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | ||||||||||||||||||||||||||||
| 001099/BILIRUBIN, TOTAL | 1 | 1 | 1 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | ||||||||||||||||||||||||||||
| 001016/CALCIUM | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||||||||||||||||||||||||||||
| 028142/CBC, PLATELET, NO DIFFERENTIAL | 2 | 1 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | |||||||||||||||||||||||||||||
| 001065/CHOLESTEROL, TOTAL | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 321205/CMP14+LP+CBC/PLT | 2 | 1 | 2 | 1 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | |||||||||||||||||||||||||||
| 321209/CMP14+LP+RPR+CBC/PLT | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 321709/CMP14+LP+2AC+CBC/D/PLT+UA+T4 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||||||||||||||||||||||||||||
| 322000/COMP. METABOLIC PANEL (14) | 1 | 1 | 3 | 2 | 7 | $0.00 | 8 | $0.00 | 8 | $0.00 | 8 | $0.00 | 8 | $0.00 | 8 | $0.00 | |||||||||||||||||||||||||||
| 002311/CREATINE KINASE (CK), MB/TOTAL | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||||||||||||||||||||||||||||
| 001370/CREATININE | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 322755/HEPATIC FUNCTION PANEL (7) | 1 | 1 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | |||||||||||||||||||||||||||||
| 006530/HEPATITIS B SURF AB QUANT | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||||||||||||||||||||||||||||
| 005223/HGB SOLUBILITY | 4 | 4 | 1 | 2 | 1 | 1 | 3 | 16 | $0.00 | 16 | $0.00 | 16 | $0.00 | 16 | $0.00 | 16 | $0.00 | 16 | $0.00 | ||||||||||||||||||||||||
| 235010/LIPID PANEL WITH LDL/HDL RATIO | 1 | 1 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | |||||||||||||||||||||||||||||
| 058495/MEASLES/MUMPS/RUBELLA IMMUNITY | 1 | 1 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | |||||||||||||||||||||||||||||
| 083935/PANEL 083935 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||||||||||||||||||||||||||||
| 005033/RBC | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||||||||||||||||||||||||||||
| 322777/RENAL PANEL (10) | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 006072/RPR | 1 | 2 | 1 | 1 | 5 | $0.00 | 5 | $0.00 | 5 | $0.00 | 5 | $0.00 | 5 | $0.00 | 5 | $0.00 | |||||||||||||||||||||||||||
| 004226/TESTOSTERONE, SERUM | 1 | 2 | 1 | 3 | 1 | 1 | 1 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | ||||||||||||||||||||||||
| 001149/THYROXINE (T4) | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 001172/TRIGLYCERIDES | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | |||||||||||||||||||||||||||||||
| 004259/TSH | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 096206/VARICELLA-ZOSTER V AB, IGG | 5 | 1 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | |||||||||||||||||||||||||||||
| 998085/VENIPUNCTURE | 10 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | ||||||||||||||||||||||||||||||
| 001800/ZINC, PLASMA OR SERUM | 2 | 2 | 2 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | ||||||||||||||||||||||||||||
| 322744/HEPATITIS PANEL (4) | 2 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | ||||||||||||||||||||||||||||||
| 006726/HEP A AB, TOTAL | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 004515/ESTRADIOL | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 001321/IRON AND TIBC | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 070001/TESTOSTERONE, TOTAL, LC/MS | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 058537/HAV/HBV IMMUNE STATUS (PRO IV) | 6 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | 6 | $0.00 | ||||||||||||||||||||||||||||||
| 096552/MUMPS ANTIBODIES, IGG | 4 | 4 | $0.00 | 4 | $0.00 | 4 | $0.00 | 4 | $0.00 | 4 | $0.00 | 4 | $0.00 | ||||||||||||||||||||||||||||||
| 005041/HEMOGLOBIN | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 006734/HEP A AB, IGM | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 096560/RUBEOLA ANTIBODIES, IGG | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 085324/MERCURY, BLOOD | 10 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | 10 | $0.00 | ||||||||||||||||||||||||||||||
| 007773/MERCURY, URINE | 5 | 5 | $0.00 | 5 | $0.00 | 5 | $0.00 | 5 | $0.00 | 5 | $0.00 | 5 | $0.00 | ||||||||||||||||||||||||||||||
| 004416/HCG,BETA SUBUNIT, QNT, SERUM | 1 | 1 | 1 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | ||||||||||||||||||||||||||||
| 144980/TESTOSTERONE, FREE, DIRECT | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 070466/CHAIN-OF-CUSTODY PROTOCOL | 1 | 10 | 13 | 9 | 6 | 6 | 10 | 14 | 9 | 9 | 12 | 16 | 115 | $0.00 | 115 | $0.00 | 115 | $0.00 | 115 | $0.00 | 115 | $0.00 | 115 | $0.00 | |||||||||||||||||||
| 726778/ 7+ALC-UNBUND | 1 | 6 | 12 | 8 | 6 | 7 | 8 | 13 | 7 | 8 | 8 | 4 | 88 | $0.00 | 88 | $0.00 | 88 | $0.00 | 88 | $0.00 | 88 | $0.00 | 88 | $0.00 | |||||||||||||||||||
| 071282/AMPHETAMINES CONFIRMATION, UR | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 144065/HCV AB W/RFLX TO VERIFICATION | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 005215/SEDIMENTATION RATE-WESTERGREN | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 330015/THYROID CASCADE PROFILE | 1 | 1 | 1 | 1 | 4 | $0.00 | 4 | $0.00 | 4 | $0.00 | 4 | $0.00 | 4 | $0.00 | 4 | $0.00 | |||||||||||||||||||||||||||
| 001974/THYROXINE (T4) FREE, DIRECT, S | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 001057/URIC ACID | 1 | 1 | 1 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | 3 | $0.00 | ||||||||||||||||||||||||||||
| 001362/CREATINE KINASE,TOTAL | 1 | 1 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | 2 | $0.00 | |||||||||||||||||||||||||||||
| 005199/PROTHROMBIN TIME (PT) | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| 001453/HEMOGLOBIN A1C | 1 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | 1 | $0.00 | ||||||||||||||||||||||||||||||
| FIRST YEAR OF LAB SERVICES = | 2177 | $0.00 | 2178 | $0.00 | 2178 | $0.00 | 2178 | $0.00 | 2178 | $0.00 | 2178 | $0.00 |
| Grand Total Amount for 5-Year BPA |
| $0.00 |
File details come from the government source that posted it. Updated .