This award page summarizes procurement activity for award number 0018 under agency ID 9700 during the last 5 years. The record includes 421 award actions and total obligated amounts of $13,103,820.85.
Award Number
Award Number 9700 / 0018 Federal Contract Action Summary (Last 5 Years)
Award number 0018 for agency 9700 shows 421 recorded actions over the last 5 years with $13.10 million obligated.
Average action value across the reporting window is $31,125.47, based on the recorded award actions.
Agency ID
9700
PIID
0018
Type
Award
Total Obligated
13.10 million
13,103,820.85
Actions
421
Average Action Value
31,125.47
Overview
The award record for agency 9700 and PIID 0018 reflects 421 actions in the last 5 years. Total obligated funding is $13,103,820.85, with an average action value of $31,125.47. These figures describe the observed transaction history for the award within the stated analysis window.
How to use this page
Use this page to review high-level award activity, obligated totals, and average action value for PIID 0018. It provides a compact summary of the award's recorded procurement activity for agency ID 9700 over the last 5 years.
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 = '0018'
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 |
|---|---|---|---|---|
| 1700 | DEPT OF THE NAVY | 23,440,567.13 | 23.44 million | 146 |
| 9761 | DEFENSE THREAT REDUCTION AGENCY (DTRA) | 757,449.48 | 757.45 thousand | 5 |
| 97JC | MISSILE DEFENSE AGENCY (MDA) | -9,078.12 | -9.08 thousand | 1 |
| 97F2 | DEPT OF DEFENSE EDUCATION ACTIVITY (DODEA) | -9,211.09 | -9.21 thousand | 1 |
| 97AS | DEFENSE LOGISTICS AGENCY | -88,687.95 | -88.69 thousand | 15 |
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | -94,299.08 | -94.30 thousand | 30 |
| 97F5 | WASHINGTON HEADQUARTERS SERVICES (WHS) | -129,773.81 | -129.77 thousand | 5 |
| 97DH | DEFENSE HEALTH AGENCY (DHA) | -325,672.95 | -325.67 thousand | 2 |
| 5700 | DEPT OF THE AIR FORCE | -2,518,854.36 | -2.52 million | 52 |
| 2100 | DEPT OF THE ARMY | -3,002,179.63 | -3.00 million | 91 |
Insight
Over the past 5 years, obligations under PIID 0018 are concentrated in the Department of the Navy, which accounts for 146 awards and $23.44 million in obligations, far exceeding all other agencies listed. The next highest positive obligation is DTRA at $757.45 thousand across 5 awards, while most other listed agencies reflect net deobligations, including the Department of the Army (-$3.00 million across 91 awards) and the Department of the Air Force (-$2.52 million across 52 awards). This pattern indicates that award activity is heavily concentrated with the Navy, with smaller follow-on activity and multiple agencies posting negative net obligations over the period.
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 = '0018'
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 |
|---|---|---|---|---|
| BAE SYSTEMS TECHNOLOGY SOLUTIONS & SERVICES INC. | 99789 | 32,778,664.30 | 32.78 million | 81 |
| JOHNSON CONTROLS BUILDING AUTOMATION SYSTEMS LLC | 4CWR3 | 1,465,848.54 | 1.47 million | 7 |
| AMENTUM SERVICES, INC. | 5W3V7 | 780,867.19 | 780.87 thousand | 5 |
| APPLIED RESEARCH ASSOCIATES, INC. | 9R446 | 757,449.48 | 757.45 thousand | 5 |
| BOEING COMPANY, THE | 88277 | 727,024.00 | 727.02 thousand | 3 |
| SES GOVERNMENT SOLUTIONS, INC. | 1VKQ6 | 297,853.60 | 297.85 thousand | 4 |
| CLARK NEXSEN, INC. | 2D534 | 285,654.09 | 285.65 thousand | 4 |
| ALLNATIVE SOLUTIONS CORPORATION | 4CZC0 | 281,262.89 | 281.26 thousand | 7 |
| ULTISAT, INC. | 3H9E0 | 180,872.81 | 180.87 thousand | 10 |
| PARS - GANNETT FLEMING JOINT VENTURE | 65W82 | 173,164.00 | 173.16 thousand | 1 |
Insight
Obligations for PIID 0018 over the last 5 years are heavily concentrated with BAE SYSTEMS TECHNOLOGY SOLUTIONS & SERVICES INC., which accounts for $32.78 million across 81 awards and far exceeds every other vendor listed. The remaining obligations are distributed among a much smaller set of vendors, with only JOHNSON CONTROLS BUILDING AUTOMATION SYSTEMS LLC exceeding $1 million; all others are below $1 million and generally tied to low award counts. This pattern indicates a strong incumbent relationship with one dominant vendor and a long tail of smaller awards to multiple suppliers.
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 = '0018'
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 |
|---|---|---|---|---|
| 541330 | ENGINEERING SERVICES | 29,591,952.10 | 29.59 million | 167 |
| 541512 | COMPUTER SYSTEMS DESIGN SERVICES | 1,384,841.82 | 1.38 million | 11 |
| 532420 | OFFICE MACHINERY AND EQUIPMENT RENTAL AND LEASING | 313,063.89 | 313.06 thousand | 11 |
| 517410 | SATELLITE TELECOMMUNICATIONS | 297,853.60 | 297.85 thousand | 4 |
| 517919 | ALL OTHER TELECOMMUNICATIONS | 180,872.81 | 180.87 thousand | 10 |
| 236220 | COMMERCIAL AND INSTITUTIONAL BUILDING CONSTRUCTION | 55,497.22 | 55.50 thousand | 7 |
| 334412 | BARE PRINTED CIRCUIT BOARD MANUFACTURING | 18,881.80 | 18.88 thousand | 2 |
| 517110 | WIRED TELECOMMUNICATIONS CARRIERS | 10,850.42 | 10.85 thousand | 8 |
| 532111 | PASSENGER CAR RENTAL | 1,481.14 | 1.48 thousand | 1 |
| 333314 | OPTICAL INSTRUMENT AND LENS MANUFACTURING | 0.00 | 0.00 | 1 |
Insight
Obligations under PIID 0018 over the 5-year window are highly concentrated in NAICS 541330, Engineering Services, which accounts for $29.59 million across 167 awards and far exceeds every other code. The next largest category, NAICS 541512, Computer Systems Design Services, totals $1.38 million across 11 awards, with all remaining NAICS codes each contributing less than $0.32 million. This pattern indicates a predominantly engineering-driven award profile with a limited secondary presence of IT, telecommunications, leasing, and construction-related activities.
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 = '0018'
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 |
|---|---|---|---|---|
| B541 | SPECIAL STUDIES/ANALYSIS- DEFENSE | 32,816,575.17 | 32.82 million | 79 |
| N059 | INSTALLATION OF EQUIPMENT- ELECTRICAL AND ELECTRONIC EQUIPMENT COMPONENTS | 1,465,848.54 | 1.47 million | 7 |
| AD93 | R&D- DEFENSE OTHER: OTHER (ADVANCED DEVELOPMENT) | 757,449.48 | 757.45 thousand | 5 |
| D304 | IT AND TELECOM- TELECOMMUNICATIONS AND TRANSMISSION | 321,040.52 | 321.04 thousand | 11 |
| C1EZ | ARCHITECT AND ENGINEERING- CONSTRUCTION: OTHER INDUSTRIAL BUILDINGS | 285,654.09 | 285.65 thousand | 4 |
| 3610 | PRINTING, DUPLICATING, AND BOOKBINDING EQUIPMENT | 249,198.80 | 249.20 thousand | 2 |
| D316 | IT AND TELECOM- TELECOMMUNICATIONS NETWORK MANAGEMENT | 179,672.31 | 179.67 thousand | 11 |
| Z2AA | REPAIR OR ALTERATION OF OFFICE BUILDINGS | 90,861.00 | 90.86 thousand | 3 |
| 7025 | INFORMATION TECHNOLOGY INPUT/OUTPUT AND STORAGE DEVICES | 63,865.09 | 63.87 thousand | 9 |
| 6910 | TRAINING AIDS | 29,446.77 | 29.45 thousand | 4 |
Insight
Over the 5-year window for PIID 0018 under agency 9700, obligations are highly concentrated in PSC B541, Special Studies/Analysis–Defense, which accounts for $32.82 million across 79 awards. The next largest PSC, N059, Installation of Equipment–Electrical and Electronic Equipment Components, is far smaller at $1.47 million, indicating a steep drop-off after the lead category. The remaining PSCs are each below $1 million and spread across technical, IT, engineering, construction, and equipment-related activities, suggesting a mixed but materially lower-value set of requirements beyond the primary research/analysis profile.
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 = '0018'
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 | 15,741,117.06 | 15.74 million | 177 |
| 2022 | 7,214,741.69 | 7.21 million | 101 |
| 2023 | -3,012,474.19 | -3.01 million | 60 |
| 2024 | -3,372,042.18 | -3.37 million | 58 |
| 2025 | -3,467,521.53 | -3.47 million | 25 |
Insight
Obligations for PIID 0018 declined sharply over the 5-year period, falling from 15.74 million across 177 awards in 2021 to 7.21 million across 101 awards in 2022. From 2023 through 2025, annual net obligations were negative, at -3.01 million, -3.37 million, and -3.47 million respectively, while award counts also contracted from 60 to 25. This pattern indicates both lower award volume and recurring downward adjustments in later years, with the greatest activity concentrated in 2021–2022.
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.