This page summarizes procurement activity for award number N0002418C2305 within agency ID 9700 over the last full year. The award shows 45 actions and total obligated dollars of 136.51 million.
Award Number
Award Number 9700 / N0002418C2305 Federal Contract Action Summary (Last Year)
FPDS analysis page for award number N0002418C2305 under agency ID 9700, summarizing obligations and action activity for the last full year.
Totals shown are based on the provided analysis window, with exact obligated dollars of 136507619 and an average action value of 3033502.64.
Agency ID
9700
PIID
N0002418C2305
Type
Award
Total Obligated
136.51 million
136,507,619.00
Actions
45
Average Action Value
3,033,502.64
Overview
Award number N0002418C2305 is associated with agency ID 9700 and recorded activity in the last full year. Across 45 award actions, the total obligated amount was 136507619, or 136.51 million when rounded to readable format. The average action value was 3033502.64.
How to use this page
Use this page to review obligation volume and action frequency for award number N0002418C2305 over the selected analysis window. The figures are useful for comparing this award's pace of activity and average action size against other awards in the same agency context.
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 = 'N0002418C2305'
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 |
|---|---|---|---|---|
| 1700 | DEPT OF THE NAVY | 136,507,619.00 | 136.51 million | 45 |
Insight
Within the 1-year window, all reported obligations are concentrated in DEPT OF THE NAVY (agency ID 1700), with $136.51 million across 45 awards. This indicates the award activity for PIID N0002418C2305 is fully concentrated within a single agency, with no reported distribution across other agencies in the provided data.
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 = 'N0002418C2305'
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 |
|---|---|---|---|---|
| BATH IRON WORKS CORPORATION | 70876 | 136,507,619.00 | 136.51 million | 45 |
Insight
BATH IRON WORKS CORPORATION is the sole top vendor listed for this award in the 1-year window, with $136.51 million in total obligated funding across 45 awards. This indicates very high vendor concentration and a strong reliance on a single contractor for the cited PIID. The volume of awards relative to obligation suggests repeated funding activity rather than a small number of large actions.
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 = 'N0002418C2305'
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 |
|---|---|---|---|---|
| 336611 | SHIP BUILDING AND REPAIRING | 136,507,619.00 | 136.51 million | 45 |
Insight
The award is fully concentrated in NAICS 336611, Ship Building and Repairing, with $136.51 million obligated across 45 awards in the 1-year window. This indicates the activity is highly concentrated in a single industrial base category, with no evidence of diversification across other NAICS codes in the provided data. The award count suggests repeated contracting activity within the same sector rather than distribution across multiple industries.
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 = 'N0002418C2305'
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 |
|---|---|---|---|---|
| 1905 | COMBAT SHIPS AND LANDING VESSELS | 136,507,619.00 | 136.51 million | 45 |
Insight
For award N0002418C2305 in the 1-year window, obligations are fully concentrated in PSC 1905, Combat Ships and Landing Vessels. This PSC accounts for $136.51 million across 45 awards, indicating a highly focused distribution within the contract activity. The concentration in a single PSC suggests the award is centered on naval vessel-related requirements rather than a broad mix of product categories.
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 = 'N0002418C2305'
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 | 136,507,619.00 | 136.51 million | 45 |
Insight
For the 1-year window, obligations are concentrated in a single reported year: FY2025 accounts for $136.51 million across 45 awards. This indicates a high level of annual funding concentration within the observed period, with an average obligation of roughly $3.0 million per award. No year-over-year comparison is available from the provided rows.
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.