This page summarizes award-level procurement activity for award number W31P4Q23C0036 during the last full year. The award recorded 17 actions with total obligated funding of $622.58 million.
Award Number
Award Number 9700 / W31P4Q23C0036 Federal Contract Action Summary (Last Year)
Procurement analysis page for award number W31P4Q23C0036 under agency ID 9700, showing last full year obligations and action activity.
Values are based on the provided analysis window and reflect total obligated exact of 622575194.46 and average action value of 36622070.26.
Agency ID
9700
PIID
W31P4Q23C0036
Type
Award
Total Obligated
622.58 million
622,575,194.46
Actions
17
Average Action Value
36,622,070.26
Overview
For the last full year, award number W31P4Q23C0036 under agency ID 9700 had 17 recorded actions and total obligations of $622,575,194.46. The average action value was $36,622,070.26, indicating that the award’s activity was concentrated in relatively large transactions.
How to use this page
Use this page to review obligation volume and action frequency for award W31P4Q23C0036 over the selected period. The figures support award-level comparison, trend review, and follow-up on the timing and scale of procurement actions without adding assumptions beyond the reported totals.
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 = 'W31P4Q23C0036'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 | 622,575,194.46 | 622.58 million | 16 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | 0.00 | 0.00 | 1 |
Insight
Obligations are highly concentrated in the DEPT OF THE ARMY, which accounts for $622.58 million across 16 awards in the 1-year window. DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) appears once but with no obligated value, indicating no material obligation distribution outside the Army for this PIID. This pattern suggests the award’s funding is effectively centralized within a single agency.
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 = 'W31P4Q23C0036'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| RAYTHEON COMPANY | 05716 | 622,575,194.46 | 622.58 million | 17 |
Insight
Within the 1-year window for award W31P4Q23C0036, all reported obligation in this section is concentrated with a single vendor, RAYTHEON COMPANY (CAGE 05716). The vendor accounts for $622.58 million across 17 awards, indicating a highly concentrated vendor profile for this award. With no other vendors listed, there is no visible distribution of obligations across additional suppliers 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 = 'W31P4Q23C0036'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| 336414 | GUIDED MISSILE AND SPACE VEHICLE MANUFACTURING | 622,575,194.46 | 622.58 million | 17 |
Insight
Award activity for PIID W31P4Q23C0036 is fully concentrated in NAICS 336414, Guided Missile and Space Vehicle Manufacturing, over the 1-year window. This category accounts for $622.58 million across 17 awards, indicating a highly concentrated procurement profile with no other NAICS codes represented in the provided data. The distribution suggests the award is tied to a single industrial classification rather than a diversified set of procurement categories.
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 = 'W31P4Q23C0036'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| 1420 | GUIDED MISSILE COMPONENTS | 622,575,194.46 | 622.58 million | 17 |
Insight
Obligations under PIID W31P4Q23C0036 are fully concentrated in PSC 1420, Guided Missile Components, with $622.58 million across 17 awards in the 1-year window. This indicates a narrow product scope and a highly concentrated obligation pattern rather than a diversified PSC distribution. The award volume suggests repeated activity within the same PSC, but no other PSCs are represented in the provided data for comparison.
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 = 'W31P4Q23C0036'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2025 | 622,575,194.46 | 622.58 million | 17 |
Insight
For PIID W31P4Q23C0036 under agency 9700, obligations in 2025 totaled $622.58 million across 17 awards. This indicates a highly concentrated obligation profile, with substantial funding activity occurring within the 1-year window. The award count suggests the obligated amount was distributed across a limited number of actions rather than broadly dispersed.
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 full year view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.