Award Number

Award Number 9700 / W911QY21C0031 Federal Contract Action Summary (Last 5 Years)

Award number W911QY21C0031 for agency ID 9700 shows 7 recorded actions over the last 5 years with $2.21 billion obligated.

This page summarizes procurement activity for award number W911QY21C0031 under agency ID 9700 across the last 5 years. The award shows total obligated funding of $2,205,000,834 across 7 actions, with an average action value of $315,000,119.14.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last 5 years

Totals reflect the provided analysis window and obligation values for the award record; averages are based on the recorded action count.

Agency ID

9700

PIID

W911QY21C0031

Type

Award

Total Obligated

2.21 billion

2,205,000,834.00

Actions

Average Action Value

315,000,119.14

Overview

Award number W911QY21C0031 is associated with agency ID 9700 and reflects procurement activity recorded within the last 5 years. The award total obligated amount is $2,205,000,834 across 7 actions, producing an average action value of $315,000,119.14.

How to use this page

Use this page to review the award-level obligation summary, action count, and average action value for W911QY21C0031. The figures are limited to the provided 5-year analysis window and should be read as record-level summary data.

Top Agencies

SELECT
    content__award__purchaserInformation__contractingOfficeAgencyID AS agency_id,
    content__award__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
    sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W911QY21C0031'
    AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
    AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    agency_id,
    agency_name
ORDER BY total_obligated DESC
LIMIT 10

Agency ID	Agency Name	Total Obligated	Readable	Actions
2100	DEPT OF THE ARMY	2,205,000,834.00	2.21 billion	7

Insight

Over the 5-year window for award PIID W911QY21C0031, obligations are concentrated in a single top agency: DEPT OF THE ARMY (agency ID 2100), which accounts for $2.21 billion across 7 awards. This indicates that funding activity for this award is highly concentrated within one agency rather than broadly distributed across multiple agencies.

Top Vendors

SELECT
    vendor_name,
    cage_code,
    total_obligated,
    award_count,
    formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
    SELECT
        content__award__vendor__vendorHeader__vendorName AS vendor_name,
        ifNull(content__award__vendor__vendorSiteDetails__entityIdentifiers__cageCode, '') AS cage_code,
        sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
        count() AS award_count
    FROM fpds.data
    WHERE
        content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W911QY21C0031'
        AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
        AND content__award__vendor__vendorHeader__vendorName != ''
        AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
        AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
    GROUP BY
        vendor_name,
        cage_code
)
ORDER BY total_obligated DESC
LIMIT 10

Vendor	CAGE Code	Total Obligated	Readable	Actions
MERCK SHARP & DOHME CORP.	6B2S4	2,205,000,834.00	2.21 billion	7

Insight

Over the 5-year window for award W911QY21C0031, obligations are fully concentrated with a single vendor, MERCK SHARP & DOHME CORP. (CAGE 6B2S4). This vendor received 7 awards totaling $2.21 billion, indicating a highly concentrated spending pattern with no diversification among top vendors in the provided data.

Top NAICS

SELECT
    content__award__productOrServiceInformation__principalNAICSCode AS naics_code,
    content__award__productOrServiceInformation__principalNAICSCode__description AS naics_name,
    sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W911QY21C0031'
    AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
    AND content__award__productOrServiceInformation__principalNAICSCode != ''
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    naics_code,
    naics_name
ORDER BY total_obligated DESC
LIMIT 10

NAICS Code	Description	Total Obligated	Readable	Actions
325412	PHARMACEUTICAL PREPARATION MANUFACTURING	2,205,000,834.00	2.21 billion	7

Insight

Across the 5-year window for award W911QY21C0031, obligations are fully concentrated in NAICS 325412, Pharmaceutical Preparation Manufacturing, with $2.21 billion across 7 awards. This indicates a narrow industrial focus for the award’s funded activity, rather than a broad distribution across multiple NAICS codes. The combination of a single dominant NAICS and a small number of awards suggests sustained reliance on this industry category within the period reviewed.

Top PSC Codes

SELECT
    content__award__productOrServiceInformation__productOrServiceCode AS psc_code,
    content__award__productOrServiceInformation__productOrServiceCode__description AS psc_name,
    sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W911QY21C0031'
    AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
    AND content__award__productOrServiceInformation__productOrServiceCode != ''
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    psc_code,
    psc_name
ORDER BY total_obligated DESC
LIMIT 10

PSC Code	Description	Total Obligated	Readable	Actions
6505	DRUGS AND BIOLOGICALS	2,205,000,834.00	2.21 billion	7

Insight

Obligations under PIID W911QY21C0031 are fully concentrated in PSC 6505, Drugs and Biologicals, totaling $2.21 billion across 7 awards. This indicates a narrow product mix and a high degree of spending concentration within the 5-year window. No other PSCs are listed for this award in the provided data, so the observed activity is entirely centered on this category.

Annual Trend

SELECT
    toYear(parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate)) AS year,
    sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
    formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable,
    count() AS award_count
FROM fpds.data
WHERE
    content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'W911QY21C0031'
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

Year	Total Obligated	Readable	Actions
2021	2,204,799,848.00	2.20 billion	4
2022	200,986.00	200.99 thousand	2
2023	0.00	0.00	1

Insight

Obligations are heavily concentrated in 2021, when the award accounted for $2.20 billion across 4 awards. Activity dropped sharply in 2022 to $200.99 thousand across 2 awards, and declined further in 2023 to zero obligated dollars on 1 award. This pattern indicates a steep post-2021 reduction in obligated funding and a clear shift away from the initial funding level.

Use FPDS Query for deeper award and vehicle analysis

Explore federal procurement data with custom SQL, fast filtering, and deeper contract action analysis across agencies, vendors, NAICS, PSC, and annual trends.

Continue from this last 5 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.

Start 7-Day Trial Learn More