This page summarizes procurement activity for award number 0018 under agency ID 9700 during the last full year. The record reflects 25 award actions and net obligations of -$3,467,521.53, or about -$138,700.86 per action.
Award Number
Award Number 9700 / 0018 Federal Contract Action Summary (Last Year)
Award number 0018 for agency 9700 shows 25 actions in the last full year with total obligations of -3.47 million.
Dollar figures are shown as reported for the selected analysis window and may include negative obligations.
Agency ID
9700
PIID
0018
Type
Award
Total Obligated
-3.47 million
-3,467,521.53
Actions
25
Average Action Value
-138,700.86
Overview
For the last full year, award number 0018 under agency ID 9700 shows 25 award actions and a net obligated value of -$3,467,521.53. The average action value across the period was -$138,700.86. These figures describe the reported activity for the award within the selected window.
How to use this page
Use this page to review the award-level obligation pattern for award number 0018 and compare it with other awards in agency 9700. The action count and average action value help show how the reported total changed over the year.
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 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 |
|---|---|---|---|---|
| 97AK | DEFENSE INFORMATION SYSTEMS AGENCY (DISA) | 4,062.25 | 4.06 thousand | 6 |
| 9763 | DEFENSE CONTRACT MANAGEMENT AGENCY (DCMA) | 0.00 | 0.00 | 4 |
| 97F5 | WASHINGTON HEADQUARTERS SERVICES (WHS) | -21,434.18 | -21.43 thousand | 1 |
| 5700 | DEPT OF THE AIR FORCE | -623,605.64 | -623.61 thousand | 3 |
| 1700 | DEPT OF THE NAVY | -1,013,794.90 | -1.01 million | 4 |
| 2100 | DEPT OF THE ARMY | -1,812,749.06 | -1.81 million | 7 |
Insight
Obligations for PIID 0018 over the past year are dominated by negative amounts across the Army, Navy, Air Force, and WHS, indicating net deobligations or downward funding adjustments in these components. The largest negative total is with the Department of the Army (-1.81 million across 7 awards), followed by the Department of the Navy (-1.01 million across 4 awards) and the Department of the Air Force (-623.61 thousand across 3 awards). DISA is the only agency with a positive obligated total, but at 4.06 thousand across 6 awards it is minimal relative to the larger negative balances; DCMA is flat at zero across 4 awards.
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 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 |
|---|---|---|---|---|
| HAKO PLUMBING, INC. | 3C0F2 | 71,944.00 | 71.94 thousand | 1 |
| CLARK NEXSEN, INC. | 2D534 | 63,474.18 | 63.47 thousand | 1 |
| QWEST GOVERNMENT SERVICES INC | 1XWZ7 | 4,092.18 | 4.09 thousand | 3 |
| ULTISAT, INC. | 3H9E0 | 3,328.95 | 3.33 thousand | 1 |
| GOODRICH CORPORATION (2680) | 05WL4 | 0.00 | 0.00 | 1 |
| AMENTUM SERVICES, INC. | 5W3V7 | 0.00 | 0.00 | 1 |
| LEIDOS, INC. | 7LQ18 | 0.00 | 0.00 | 1 |
| OCEANEERING INTERNATIONAL, INC | 1TVU1 | 0.00 | 0.00 | 1 |
| BTAS, INC | 07GB6 | 0.00 | 0.00 | 1 |
| VERTEX MODERNIZATION AND SUSTAINMENT LLC | 96JA0 | -685.70 | -685.70 | 1 |
Insight
Obligations under PIID 0018 are concentrated among two vendors: HAKO PLUMBING, INC. and CLARK NEXSEN, INC. account for about 135.4 thousand in combined obligations across two awards, far exceeding the next highest vendor. QWEST GOVERNMENT SERVICES INC is the only other vendor with multiple awards (3) but at a much lower obligated amount of 4.09 thousand. Several vendors have one award each with no obligated amount reported, and VERTEX MODERNIZATION AND SUSTAINMENT LLC reflects a negative obligated amount, indicating a deobligation or adjustment within the 1-year window.
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 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 |
|---|---|---|---|---|
| 236220 | COMMERCIAL AND INSTITUTIONAL BUILDING CONSTRUCTION | 71,944.00 | 71.94 thousand | 1 |
| 517110 | WIRED TELECOMMUNICATIONS CARRIERS | 4,092.18 | 4.09 thousand | 3 |
| 517919 | ALL OTHER TELECOMMUNICATIONS | 3,328.95 | 3.33 thousand | 1 |
| 541710 | RESEARCH AND DEVELOPMENT IN THE PHYSICAL, ENGINEERING, AND LIFE SCIENCES | 0.00 | 0.00 | 1 |
| 333314 | OPTICAL INSTRUMENT AND LENS MANUFACTURING | 0.00 | 0.00 | 1 |
| 336414 | GUIDED MISSILE AND SPACE VEHICLE MANUFACTURING | 0.00 | 0.00 | 1 |
| 541512 | COMPUTER SYSTEMS DESIGN SERVICES | -685.70 | -685.70 | 1 |
| 541611 | ADMINISTRATIVE MANAGEMENT AND GENERAL MANAGEMENT CONSULTING SERVICES | -21,434.18 | -21.43 thousand | 1 |
| 336412 | AIRCRAFT ENGINE AND ENGINE PARTS MANUFACTURING | -21,811.23 | -21.81 thousand | 1 |
| 336419 | OTHER GUIDED MISSILE AND SPACE VEHICLE PARTS AND AUXILIARY EQUIPMENT MANUFACTURING | -70,266.62 | -70.27 thousand | 1 |
Insight
Obligations for PIID 0018 are concentrated in NAICS 236220, Commercial and Institutional Building Construction, which accounts for 71.94 thousand across 1 award. The remaining positive obligations are limited to telecommunications categories, with 517110 at 4.09 thousand over 3 awards and 517919 at 3.33 thousand over 1 award, while several other NAICS codes show zero obligation. Offsetting this, the period also includes negative obligations in manufacturing and professional services, led by 336419 at -70.27 thousand and 336412 at -21.81 thousand, indicating material downward adjustments in the 1-year window.
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 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 |
|---|---|---|---|---|
| Z2AA | REPAIR OR ALTERATION OF OFFICE BUILDINGS | 71,944.00 | 71.94 thousand | 1 |
| C1EZ | ARCHITECT AND ENGINEERING- CONSTRUCTION: OTHER INDUSTRIAL BUILDINGS | 63,474.18 | 63.47 thousand | 1 |
| D304 | IT AND TELECOM- TELECOMMUNICATIONS AND TRANSMISSION | 4,092.18 | 4.09 thousand | 3 |
| D316 | IT AND TELECOM- TELECOMMUNICATIONS NETWORK MANAGEMENT | 3,328.95 | 3.33 thousand | 1 |
| R799 | SUPPORT- MANAGEMENT: OTHER | 0.00 | 0.00 | 1 |
| AJ44 | R&D- GENERAL SCIENCE/TECHNOLOGY: ENGINEERING (ENGINEERING DEVELOPMENT) | 0.00 | 0.00 | 1 |
| B599 | SPECIAL STUDIES/ANALYSIS- OTHER | 0.00 | 0.00 | 1 |
| 1410 | GUIDED MISSILES | 0.00 | 0.00 | 1 |
| D399 | IT AND TELECOM- OTHER IT AND TELECOMMUNICATIONS | 0.00 | 0.00 | 1 |
| J020 | MAINT/REPAIR/REBUILD OF EQUIPMENT- SHIP AND MARINE EQUIPMENT | 0.00 | 0.00 | 1 |
Insight
Obligations for PIID 0018 are concentrated in two PSCs: Z2AA (Repair or Alteration of Office Buildings) at $71.94K and C1EZ (Architect and Engineering-Construction: Other Industrial Buildings) at $63.47K, together accounting for the large majority of obligated dollars in the period. Remaining obligated amounts are minimal and limited to IT/telecom PSCs D304 and D316, with all other listed PSCs at $0 obligated. The distribution indicates a small number of work categories driving funding, with several additional PSCs associated with award counts but no obligated dollars.
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 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2025 | -3,467,521.53 | -3.47 million | 25 |
Insight
For FY 2025, the award shows net obligations of -$3.47 million across 25 awards, indicating a negative funding position over the 1-year window. The obligation is fully concentrated in a single year, so there is no observable multi-year distribution or trend pattern within the provided data. The combination of multiple awards and negative net obligation suggests activity, but not positive funding growth, in this period.
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.