Vehicle Number

Vehicle Number 12C2 / AG024BC139010 Federal Contract Action Summary (Last 10 Years)

FPDS query page for vehicle number AG024BC139010 under agency ID 12C2, showing obligations and award activity over the last 10 years.

This page summarizes federal procurement activity for vehicle number AG024BC139010 across the last 10 years. It records 27 award actions with total obligated amount of 45.48 million dollars.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 10 years

Total obligated exact is 45,480,092.96 and the average action value is 1,684,447.89.

Agency ID

12C2

PIID

AG024BC139010

Type

Vehicle

Total Obligated

45.48 million

45,480,092.96

Actions

Average Action Value

1,684,447.89

Overview

The record covers 27 award actions associated with vehicle number AG024BC139010 for agency ID 12C2. Across the analysis window, total obligated amount is 45,480,092.96, which rounds to 45.48 million dollars, and the average action value is 1,684,447.89. These figures provide a compact view of procurement activity for this vehicle identifier.

How to use this page

Use this page to review obligation totals and action count for the selected vehicle record within the last 10 years. The exact obligated total and average action value support comparisons across related FPDS query results without adding interpretation beyond the reported 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 = '12C2' AND content__IDV__contractID__IDVID__PIID = 'AG024BC139010'
    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
12C2	FOREST SERVICE	45,480,092.96	45.48 million	27

Insight

Within the 10-year window for vehicle PIID AG024BC139010, all reported obligations are concentrated in a single agency: the Forest Service (agency ID 12C2). The agency accounts for $45.48 million across 27 awards, indicating repeated use of this vehicle by one buying activity rather than broad distribution across agencies.

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 = '12C2' AND content__IDV__contractID__IDVID__PIID = 'AG024BC139010'
        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 = '12C2' AND content__IDV__contractID__IDVID__PIID = 'AG024BC139010'
    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
325314	FERTILIZER (MIXING ONLY) MANUFACTURING	45,480,092.96	45.48 million	27

Insight

Across the 10-year window for vehicle PIID AG024BC139010 under Agency ID 12C2, obligations are entirely concentrated in NAICS 325314, Fertilizer (Mixing Only) Manufacturing. This category accounts for $45.48 million across 27 awards, indicating a single-industry spending pattern with no diversification in the provided data.

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 = '12C2' AND content__IDV__contractID__IDVID__PIID = 'AG024BC139010'
    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
6850	MISCELLANEOUS CHEMICAL SPECIALTIES	45,480,092.96	45.48 million	27

Insight

Over the 10-year window for vehicle PIID AG024BC139010, obligations are concentrated in PSC 6850, Miscellaneous Chemical Specialties, with $45.48 million across 27 awards. This pattern indicates a sustained buying profile centered on a single PSC, rather than broad distribution across multiple product categories. The award count suggests repeated procurement activity within this category over time.

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 = '12C2' AND content__IDV__contractID__IDVID__PIID = 'AG024BC139010'
    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
2016	15,621,718.28	15.62 million	5
2017	11,766,778.54	11.77 million	10
2018	16,711,410.19	16.71 million	9
2019	604,998.30	605.00 thousand	2
2020	775,187.65	775.19 thousand	1

Insight

Obligations under PIID AG024BC139010 are concentrated in 2016 through 2018, when annual funding ranged from $11.77 million to $16.71 million across 5 to 10 awards. Activity then dropped sharply in 2019 and 2020, with obligations falling below $1 million in each year and award counts declining to 2 and 1, respectively. This pattern indicates a front-loaded funding profile followed by a pronounced taper in later years.

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