Att.5-LIS Workload Data Pull_W81K0025QA091.xlsx

14 KB Posted

Attached to
Solicitation- Chemistry Immunoassays testing reagents- WBAMC
Solicitation number
W81K0025QA091
Issued by

About this file

Written by GovTribe AI ·

The file is an Excel workload data pull for the William Beaumont Army Medical Center (WBAMC) detailing laboratory test quantities for Fiscal Year 2025. The spreadsheet contains 141 unique laboratory tests with associated CPT codes and projected annual test volumes, totaling 6,208 tests. Key tests include comprehensive metabolic panels (843 tests), hemoglobin A1c (430 tests), lipid panels (409 tests), thyroid stimulating hormone (481 tests), and various other clinical chemistry, immunology, and diagnostic tests.

The associated federal contract opportunity (Solicitation W81K0025QA091) is for chemistry and immunoassay testing reagents at WBAMC in El Paso, Texas. The solicitation is for a one-month base period (1-30 September 2025) with two 12-month option periods, structured as a firm fixed-price contract. Key dates include questions due by 15 July 2025 at 10:00 AM Mountain Time and offers due by 13 August 2025 at 10:00 AM Mountain Time. Offers should be submitted via email to Ms. Fabiola Palma-Trujillo and Ms. Robyn Villafranco, with attachments including a Statement of Work, cybersecurity requirements, and the laboratory workload data pull.

View the file

Other files

File Type Posted
QAs- Amendment 0004_RFQ W81K0025QA091-.pdf PDF
Att.1- Chemistry SOW Immunoassay_W81K0025QA091_A0004-.pdf PDF
Amendment 00004-W81K0025QA091-.pdf PDF
Amendment 0003- W81K0025QA091_.pdf PDF
Amendment 0002-W81K0025QA091-.pdf PDF
Att.4- CAD_W81K0025QA091.pdf PDF
Amendment 0001-RFQ W81K0025QA091.pdf PDF
Att.2- DHA MDE Cybersecurity-RMF Contracting Requirements.pdf PDF
Att. 1- Chemistry SOW Immunoassay_W81K0025QA091-.pdf PDF
Att.3-DHA Cybersecurity-Service Maintenance Agreement Contracting Requirements.pdf PDF
Solicitation - W81K0025QA091 Chemistry Reagents.pdf PDF
Show all 11

On GovTribe

Work with this file

  • 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.

Sheet1

FYORG_NAMECPTORDERABLETEST_DESCRIPTIONQUANTITY
20250108A-AMC William Beaumont-Bliss80048Basic Metabolic PanelBasic metabolic panel (Calcium, total) This panel must inclu112
20250108A-AMC William Beaumont-Bliss80053Comprehensive Metabolic PanelComprehensive metabolic panel This panel must include the fo843
20250108A-AMC William Beaumont-Bliss80061Lipid PanelLipid panel This panel must include the following: Cholester409
20250108A-AMC William Beaumont-Bliss80069Renal Function PanelRenal function panel This panel must include the following:191
20250108A-AMC William Beaumont-Bliss80076Hepatic Function Panel103
20250108A-AMC William Beaumont-Bliss80164Valproic Acid LevelValproic acid (dipropylacetic acid); total2
20250108A-AMC William Beaumont-Bliss80202Vancomycin Level TroughVancomycin3
20250108A-AMC William Beaumont-Bliss80305Drug Screen, Rapid, UrineDrug test(s), presumptive, any number of drug classes, any n63
20250108A-AMC William Beaumont-Bliss80320Ethanol LevelAlcohols29
20250108A-AMC William Beaumont-Bliss80329Acetaminophen LevelAnalgesics, non-opioid; 1 or 215
20250108A-AMC William Beaumont-Bliss80329Salicylate LevelAnalgesics, non-opioid; 1 or 215
20250108A-AMC William Beaumont-Bliss82040Albumin LevelAlbumin; serum, plasma or whole blood2
20250108A-AMC William Beaumont-Bliss82043Microalbumin Level, UrineAlbumin; urine (eg, microalbumin), quantitative34
20250108A-AMC William Beaumont-Bliss82043Ur MicroalbuminAlbumin; urine (eg, microalbumin), quantitative67
20250108A-AMC William Beaumont-Bliss82105AFP Tumor MarkerAlpha-fetoprotein (AFP); serum9
20250108A-AMC William Beaumont-Bliss82140Ammonia LevelAmmonia7
20250108A-AMC William Beaumont-Bliss82150Amylase LevelAmylase5
20250108A-AMC William Beaumont-Bliss82247Bilirubin TotalBilirubin; total12
20250108A-AMC William Beaumont-Bliss82248Bilirubin DirectBilirubin; direct11
20250108A-AMC William Beaumont-Bliss82306Vitamin D 25 Hydroxy LevelVitamin D; 25 hydroxy, includes fraction(s), if performed351
20250108A-AMC William Beaumont-Bliss82378CEACarcinoembryonic antigen (CEA)7
20250108A-AMC William Beaumont-Bliss82465Cholesterol TotalCholesterol, serum or whole blood, total3
20250108A-AMC William Beaumont-Bliss82533Cortisol LevelCortisol; total21
20250108A-AMC William Beaumont-Bliss82550Creatine KinaseCreatine kinase (CK), (CPK); total47
20250108A-AMC William Beaumont-Bliss82553CK-MB IsoenzymeCreatine kinase (CK), (CPK); MB fraction only7
20250108A-AMC William Beaumont-Bliss82565Creatinine LevelCreatinine; blood4
20250108A-AMC William Beaumont-Bliss82570Creatinine, UrineCreatinine; other source9
20250108A-AMC William Beaumont-Bliss82570Ur CreatCreatinine; other source104
20250108A-AMC William Beaumont-Bliss82575Creatinine ClearanceCreatinine; clearance1
20250108A-AMC William Beaumont-Bliss82607Vitamin B12 LevelCyanocobalamin (Vitamin B-12);6
20250108A-AMC William Beaumont-Bliss82607Vitamin B12Cyanocobalamin (Vitamin B-12);131
20250108A-AMC William Beaumont-Bliss82728FerritinFerritin14
20250108A-AMC William Beaumont-Bliss82728Ferritin LvlFerritin147
20250108A-AMC William Beaumont-Bliss82746Folate LevelFolic acid; serum3
20250108A-AMC William Beaumont-Bliss82746Folate LvlFolic acid; serum131
20250108A-AMC William Beaumont-Bliss82945Glucose Level 24 Hour UrineGlucose, body fluid, other than blood1
20250108A-AMC William Beaumont-Bliss82945Glucose Level, Body FluidGlucose, body fluid, other than blood1
20250108A-AMC William Beaumont-Bliss82947*Glucose Level 1 HourGlucose; quantitative, blood (except reagent strip)25
20250108A-AMC William Beaumont-Bliss82947Glucose, FastingGlucose; quantitative, blood (except reagent strip)13
20250108A-AMC William Beaumont-Bliss82947Glucose Level, RandomGlucose; quantitative, blood (except reagent strip)4
20250108A-AMC William Beaumont-Bliss82951*Glucose Level 2 HourGlucose; tolerance test (GTT), 3 specimens (includes glucose)6
20250108A-AMC William Beaumont-Bliss82951*Glucose Level 3 HourGlucose; tolerance test (GTT), 3 specimens (includes glucose)6
20250108A-AMC William Beaumont-Bliss82977GGT (Gamma Glutamyl Transferase)Glutamyltransferase, gamma (GGT)25
20250108A-AMC William Beaumont-Bliss83001Follicle Stimulating Hormone LevelGonadotropin; follicle stimulating hormone (FSH)10
20250108A-AMC William Beaumont-Bliss83002Hepatitis B Core AntibodyGonadotropin; luteinizing hormone (LH)4
20250108A-AMC William Beaumont-Bliss83002Luteinizing HormoneGonadotropin; luteinizing hormone (LH)8
20250108A-AMC William Beaumont-Bliss83010HaptoglobinHaptoglobin; quantitative7
20250108A-AMC William Beaumont-Bliss83036Hemoglobin A1cHemoglobin; glycosylated (A1C)430
20250108A-AMC William Beaumont-Bliss83090Homocysteine LevelHomocysteine2
20250108A-AMC William Beaumont-Bliss83525Insulin Level, RandomInsulin; total35
20250108A-AMC William Beaumont-Bliss83540Iron LevelIron19
20250108A-AMC William Beaumont-Bliss83540IronIron147
20250108A-AMC William Beaumont-Bliss83550TIBCIron binding capacity147
20250108A-AMC William Beaumont-Bliss83605Lactic Acid LevelLactate (lactic acid)54
20250108A-AMC William Beaumont-Bliss83615Lactate DehydrogenaseLactate dehydrogenase (LD), (LDH);31
20250108A-AMC William Beaumont-Bliss83615LDH Body FluidLactate dehydrogenase (LD), (LDH);2
20250108A-AMC William Beaumont-Bliss83690Lipase LevelLipase142
20250108A-AMC William Beaumont-Bliss83735Magnesium LevelMagnesium203
20250108A-AMC William Beaumont-Bliss83874MyoglobinMyoglobin11
20250108A-AMC William Beaumont-Bliss83880Pro B-Type Natriuretic Peptide (ProBNP)Natriuretic peptide81
20250108A-AMC William Beaumont-Bliss83970PTH Intact w/ CalciumParathormone (parathyroid hormone)18
20250108A-AMC William Beaumont-Bliss83970PTH IntactParathormone (parathyroid hormone)26
20250108A-AMC William Beaumont-Bliss84100Phosphorus LevelPhosphorus inorganic (phosphate);66
20250108A-AMC William Beaumont-Bliss84134Prealbumin LevelPrealbumin9
20250108A-AMC William Beaumont-Bliss84144Progesterone LevelProgesterone15
20250108A-AMC William Beaumont-Bliss84145ProcalcitoninProcalcitonin (PCT)30
20250108A-AMC William Beaumont-Bliss84146Prolactin LevelProlactin24
20250108A-AMC William Beaumont-Bliss84153Prostate Specific AntigenProstate specific antigen (PSA); total42
20250108A-AMC William Beaumont-Bliss84153PSA TotalProstate specific antigen (PSA); total2
20250108A-AMC William Beaumont-Bliss84154PSA, FreeProstate specific antigen (PSA); free2
20250108A-AMC William Beaumont-Bliss84156Protein, UrineProtein, total, except by refractometry; urine2
20250108A-AMC William Beaumont-Bliss84156Ur ProteinProtein, total, except by refractometry; urine37
20250108A-AMC William Beaumont-Bliss84156Protein, TotalProtein, total, except by refractometry; urine1
20250108A-AMC William Beaumont-Bliss84300Sodium, UrineSodium; urine2
20250108A-AMC William Beaumont-Bliss84403Testosterone TotalTestosterone; total31
20250108A-AMC William Beaumont-Bliss84436T4 Total LevelThyroxine; total6
20250108A-AMC William Beaumont-Bliss84439Free T4 LevelThyroxine; free87
20250108A-AMC William Beaumont-Bliss84439T4 FreeThyroxine; free135
20250108A-AMC William Beaumont-Bliss84443Thyroid Stimulating HormoneThyroid stimulating hormone (TSH)347
20250108A-AMC William Beaumont-Bliss84443TSHThyroid stimulating hormone (TSH)134
20250108A-AMC William Beaumont-Bliss84450ASTTransferase; aspartate amino (AST) (SGOT)5
20250108A-AMC William Beaumont-Bliss84460ALTTransferase; alanine amino (ALT) (SGPT)5
20250108A-AMC William Beaumont-Bliss84466TransferrinTransferrin148
20250108A-AMC William Beaumont-Bliss84478TriglyceridesTriglycerides7
20250108A-AMC William Beaumont-Bliss84480T3 Total LevelTriiodothyronine T3; total (TT-3)7
20250108A-AMC William Beaumont-Bliss84481Free T3 LevelTriiodothyronine T3; free24
20250108A-AMC William Beaumont-Bliss84484Troponin-T, High SensitivityTroponin, quantitative183
20250108A-AMC William Beaumont-Bliss84520Urea Nitrogen, UrineUrea nitrogen; quantitative1
20250108A-AMC William Beaumont-Bliss84520BUNUrea nitrogen; quantitative1
20250108A-AMC William Beaumont-Bliss84550Uric Acid LevelUric acid; blood37
20250108A-AMC William Beaumont-Bliss84550Uric Acid, UrineUric acid; blood1
20250108A-AMC William Beaumont-Bliss84702Beta HCG QuantitativeGonadotropin, chorionic (hCG); quantitative170
20250108A-AMC William Beaumont-Bliss86140C-Reactive ProteinC-reactive protein;107
20250108A-AMC William Beaumont-Bliss86160C3/C4 Complement PanelComplement; antigen, each component5
20250108A-AMC William Beaumont-Bliss86431Rheumatoid Factor, QuantitativeRheumatoid factor; quantitative11
20250108A-AMC William Beaumont-Bliss86705Hepatitis B Core Antibody, IgM (Acute)Hepatitis B core antibody (HBcAb); IgM antibody1
20250108A-AMC William Beaumont-Bliss86706Hepatitis B Surface AntibodyHepatitis B surface antibody (HBsAb)11
20250108A-AMC William Beaumont-Bliss86803Hepatitis C AntibodyHepatitis C antibody;110
20250108A-AMC William Beaumont-Bliss87340Hepatitis B Surface AntigenInfectious agent antigen detection by immunoassay technique26
Total6208

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