Vehicle Number

Vehicle Number 7570 / HHSP233201700041C Federal Contract Action Summary (Last 10 Years)

FPDS analysis page for vehicle number tied to PIID HHSP233201700041C under agency ID 7570, covering the last 10 years of award activity.

This page summarizes procurement activity for vehicle number associated with PIID HHSP233201700041C for agency ID 7570. The record shows 13 award actions with total obligations of $76.65 million over the last 10 years.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 10 years

Dollar figures are based on the provided exact total obligated value of 76,654,767.14 and the corresponding readable total of $76.65 million.

Agency ID

7570

PIID

HHSP233201700041C

Type

Vehicle

Total Obligated

76.65 million

76,654,767.14

Actions

Average Action Value

5,896,520.55

Overview

The analysis window covers the last 10 years and shows 13 award actions recorded for this vehicle. Total obligated funding is $76,654,767.14, with an average action value of $5,896,520.55.

How to use this page

Use this page to review the overall obligation level and award activity tied to the vehicle number under PIID HHSP233201700041C. The figures support basic trend and scale checks without adding details not present in the source inputs.

Top Agencies

SELECT
    content__IDV__purchaserInformation__contractingOfficeAgencyID AS agency_id,
    content__IDV__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '7570' AND content__IDV__contractID__IDVID__PIID = 'HHSP233201700041C'
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__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
7570	OFFICE OF THE ASSISTANT SECRETARY FOR ADMINISTRATION (ASA)	76,654,767.14	76.65 million	13

Insight

Obligations are fully concentrated in OFFICE OF THE ASSISTANT SECRETARY FOR ADMINISTRATION (ASA), which accounts for $76.65 million across 13 awards over the 10-year window. This indicates all reported activity for PIID HHSP233201700041C is centered in a single agency, with no evidence of distribution across additional agencies in the provided data. The award pattern suggests repeated use of this vehicle within one organizational component rather than broad agency-wide dispersion.

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__IDV__dollarValues__obligatedAmount) AS total_obligated,
        count() AS award_count
    FROM fpds.data
    WHERE
        content__IDV__contractID__IDVID__agencyID = '7570' AND content__IDV__contractID__IDVID__PIID = 'HHSP233201700041C'
        AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
        AND content__award__vendor__vendorHeader__vendorName != ''
        AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
        AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
    GROUP BY
        vendor_name,
        cage_code
)
ORDER BY total_obligated DESC
LIMIT 10

Vendor	CAGE Code	Total Obligated	Readable	Actions

Insight

No vendor concentration was available for this analysis window.

Top NAICS

SELECT
    content__IDV__productOrServiceInformation__principalNAICSCode AS naics_code,
    content__IDV__productOrServiceInformation__principalNAICSCode__description AS naics_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '7570' AND content__IDV__contractID__IDVID__PIID = 'HHSP233201700041C'
    AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    naics_code,
    naics_name
ORDER BY total_obligated DESC
LIMIT 10

NAICS Code	Description	Total Obligated	Readable	Actions
541611	ADMINISTRATIVE MANAGEMENT AND GENERAL MANAGEMENT CONSULTING SERVICES	76,654,767.14	76.65 million	13

Insight

Obligations for PIID HHSP233201700041C are fully concentrated in NAICS 541611, Administrative Management and General Management Consulting Services. Over the 10-year window, this category accounts for $76.65 million across 13 awards, indicating sustained use of a single professional services code rather than a diversified NAICS mix. This concentration suggests the vehicle was used consistently for management consulting requirements.

Top PSC Codes

SELECT
    content__IDV__productOrServiceInformation__productOrServiceCode AS psc_code,
    content__IDV__productOrServiceInformation__productOrServiceCode__description AS psc_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '7570' AND content__IDV__contractID__IDVID__PIID = 'HHSP233201700041C'
    AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    psc_code,
    psc_name
ORDER BY total_obligated DESC
LIMIT 10

PSC Code	Description	Total Obligated	Readable	Actions
R499	SUPPORT- PROFESSIONAL: OTHER	76,654,767.14	76.65 million	13

Insight

Obligations for this vehicle are entirely concentrated in PSC R499, Support- Professional: Other, with 13 awards totaling $76.65 million over the 10-year window. This indicates a highly focused scope of spending with no visible PSC diversification in the provided data. The concentration suggests the vehicle has been used primarily for one service category rather than a broad mix of professional support activities.

Annual Trend

SELECT
    toYear(parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate)) AS year,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable,
    count() AS award_count
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '7570' AND content__IDV__contractID__IDVID__PIID = 'HHSP233201700041C'
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

Year	Total Obligated	Readable	Actions
2017	6,482,527.00	6.48 million	1
2018	17,367,374.70	17.37 million	5
2019	18,794,245.00	18.79 million	1
2020	20,355,432.30	20.36 million	2
2021	15,098,848.59	15.10 million	3
2022	-1,443,660.45	-1.44 million	1

Insight

Obligations for PIID HHSP233201700041C were concentrated in 2018 through 2021, when annual funding ranged from $15.10 million to $20.36 million, compared with $6.48 million in 2017. Award activity was also uneven, with the highest count in 2018 (5 awards) and only one award in most other years. In 2022, obligations were negative at $1.44 million, indicating a downward adjustment or deobligation after the prior multi-year funding pattern.

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 10 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.

Start 7-Day Trial Learn More