Vehicle Number

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

Procurement analysis for vehicle number PIID HHSP233201700041C under agency ID 7570, covering obligations in the last 5 years.

This page summarizes award activity for vehicle number HHSP233201700041C using the last 5 years of available data. Total obligated amount is $13.66 million across 4 award actions, with an average action value of $3,413,797.04.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 5 years

Amounts shown reflect the provided total obligated exact value of 13,655,188.14 and the readable rounded total of 13.66 million.

Agency ID

7570

PIID

HHSP233201700041C

Type

Vehicle

Total Obligated

13.66 million

13,655,188.14

Actions

Average Action Value

3,413,797.04

Overview

The record for vehicle number HHSP233201700041C shows $13,655,188.14 obligated over the last 5 years, based on 4 award actions. The average action value is $3,413,797.04, which indicates relatively concentrated obligation activity within the analysis window.

How to use this page

Use this page to review the obligation profile tied to PIID HHSP233201700041C and compare it with other vehicle records in agency ID 7570. The figures provide a compact summary of award frequency and dollar volume without adding details beyond the supplied contract data.

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 5 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)	13,655,188.14	13.66 million	4

Insight

Within the 5-year window for PIID HHSP233201700041C, all reported obligation is concentrated in a single agency: the OFFICE OF THE ASSISTANT SECRETARY FOR ADMINISTRATION (ASA). That agency accounts for $13.66 million across 4 awards, indicating a narrow distribution of vehicle activity with no diversification across additional agencies in the provided data. This concentration suggests the vehicle’s usage is fully tied to ASA within the reported 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__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 5 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 5 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	13,655,188.14	13.66 million	4

Insight

Obligations under this vehicle are fully concentrated in NAICS 541611, Administrative Management and General Management Consulting Services, with $13.66 million across 4 awards over the 5-year window. This indicates a narrow procurement profile with no observed diversification across other NAICS codes in the provided data. The distribution suggests the vehicle has been used primarily for consulting-related 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 5 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	13,655,188.14	13.66 million	4

Insight

Obligations for this vehicle are fully concentrated in PSC R499, Support- Professional: Other, with $13.66 million across 4 awards in the 5-year window. This indicates a narrow service profile with all recorded obligation activity falling within a single PSC category. The limited PSC distribution suggests the vehicle has been used primarily for one type of professional support requirement rather than a diversified set of services.

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 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

Year	Total Obligated	Readable	Actions
2021	15,098,848.59	15.10 million	3
2022	-1,443,660.45	-1.44 million	1

Insight

Obligations under PIID HHSP233201700041C are concentrated in 2021, when 3 awards totaled $15.10 million. In 2022, activity dropped to 1 award with -$1.44 million in obligations, indicating a net downward adjustment rather than continued positive funding growth. Over the 5-year window provided, the award pattern is sparse and uneven, with spending concentrated in a single year and a reversal in the following year.

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.

Start 7-Day Trial Learn More