HillStar case study

Quarterly supply-chain sourcing

A major US energy company turned tariff-driven price volatility into a repeatable, defensible quarterly sourcing system at national scale.

50

STATE FOOTPRINT

250

SKUs PER VENDOR

RE-BID PER YEAR

100%

CERTS VERIFIED

Weeks→Days

EVALUATION TIME

AT A GLANCE

Customer

Major US energy company with operations and supply footprint across all 50 states

Scope

Quarterly supply-chain RFP covering ~250 SKUs per participating vendor — materials, equipment, and components across grid and generation operations

Cadence

Re-bid every quarter: tariff and commodity volatility makes annual pricing impossible to hold

Challenge

Each cycle required weeks of manual SME review of thousands of line items, certifications, and pricing schedules — with the next cycle starting almost as soon as the last one closed

Outcome

Evaluation compressed from weeks to days; every score citation-linked to vendor source documents; certification and compliance exceptions surfaced before award, not after

THE SITUATION: WHEN PRICING WON’T HOLD STILL

Tariff and trade volatility has upended utility supply chains. Duties on transformers, steel, aluminum, and grid components shift with little notice, lead times stretch, and vendors will no longer hold prices for a year[1]. Our customer — a major energy company operating across all 50 states — responded the only way a disciplined buyer can: by re-bidding its strategic supply categories every quarter, keeping pricing current with the market instead of locked to a stale annual award.

The strategy was right. The workload was crushing. Each quarterly RFP covered approximately 250 SKUs per participating vendor — thousands of line items per cycle once multiple vendors responded — each carrying technical specifications, certification requirements, country-of-origin and tariff-exposure declarations, and a structured pricing schedule. Evaluating one cycle manually consumed weeks of senior engineering and supply-chain time. With a quarterly cadence, the team was effectively evaluating year-round: the next RFP opened almost as soon as the last award was documented. Corners inevitably got cut — spot-checking certifications instead of verifying all of them, comparing headline prices instead of normalized total cost — in exactly the categories where a missed exception becomes a field failure or a compliance finding.

WHAT HILLSTAR DID

HillStar deployed its platform against the customer’s existing RFP structure — no workflow change, no new system of record — and, through forward engineering, encoded the customer’s own evaluation standards into a reusable quarterly rubric. Four capabilities carried the engagement:

Technical Requirements Analysis

HillStar extracts, normalizes, and compares complex technical requirements across vendor submissions while preserving full source traceability. For this customer, that meant decomposing ~250 SKU-level specifications — ratings, tolerances, materials, standards conformance — into a structured requirements matrix, then reading every vendor’s submission against it line by line. Where vendors described the same product in different formats, units, or part-numbering schemes, HillStar normalized them into one comparable view. Every extracted value stayed linked to the page and paragraph of the vendor document it came from, so an engineer checking any line item could jump straight to the source.

Compliance & Evaluation Alignment

HillStar evaluates vendor responses against procurement requirements, mandatory criteria, governance standards, and organization-specific evaluation frameworks. Each quarter, that included verifying the certifications the customer’s standards demanded — UL and ANSI/IEEE conformance, ISO 9001 quality systems, DOT and safety qualifications where applicable — plus domestic-content and country-of-origin declarations that determine tariff exposure. Mandatory (pass/fail) criteria were checked for every SKU and every vendor, not sampled. Responses that skipped a required certification, answered a different question than was asked, or left a mandatory field unsupported were flagged automatically against the customer’s own evaluation framework — the same rubric, applied the same way, every quarter.

Risk & Evaluation Intelligence

HillStar identifies technical gaps, contractual risk, compliance exceptions, unsupported claims, and evaluation inconsistencies across submissions. In quarterly cycles this is where volatility hides: a vendor quietly substituting a component of different origin (changing tariff treatment), a certification that lapsed since last quarter’s submission, a claim of stock availability with no supporting evidence, or exception language buried in commercial terms that shifts tariff and escalation risk back onto the buyer. HillStar surfaced these as red flags with severity and source citation — and, because it evaluates every submission against the same rubric, it also caught scoring inconsistencies between reviewers and between quarters that manual processes never see.

Commercial & Financial Analysis

HillStar performs structured financial comparisons aligned with the RFP’s pricing schedules, commercial terms, cost models, alternates, and evaluation criteria. With ~250 SKUs per vendor re-priced every quarter, the customer needed more than a cheapest-cell comparison: HillStar normalized pricing across schedules, evaluated alternates and substitutions on equal footing, applied the customer’s cost model (including freight, escalation, and tariff-exposure assumptions), and tracked quarter-over-quarter price movement by SKU and vendor — turning the quarterly cadence from a burden into a market-intelligence asset. Award recommendations reconciled technical scores with commercial reality, documented to the standard a regulated buyer’s auditors expect.

THE COST MODEL

The quarterly cadence is what makes the economics compelling. A manual evaluation that consumes roughly three weeks per cycle repeats four times a year; HillStar turns each of those cycles into a two-day review. The saving is not a one-time project win — it recurs every quarter, and it frees senior engineering and supply-chain staff to spend their time on judgment rather than document reading.

Evaluation time per quarterly cycle

Business days per cycle

Manual evaluation
~3 weeks
With HillStar
~2 days

87% faster per cycle

Annual evaluation effort

Cumulative person-hours

Annual evaluation effortManual evaluation effort rises from 480 person-hours in Q1 to 1,920 in Q4. With HillStar, effort rises from 40 person-hours in Q1 to 160 in Q4.
Annual evaluation effort in cumulative person-hours
QuarterManualWith HillStar
Q148040
Q296080
Q31,440120
Q41,920160

Illustrative cost model. Manual baseline assumes ~3 weeks of evaluation per quarter across the internal review team (~480 person-hours per cycle); the HillStar figures reflect the compressed, exception-focused review this engagement delivered. Replace with the customer’s measured figures for an account-specific version.

RESULTS

Before HillStar

With HillStar

Weeks of manual SME review per quarterly cycle — evaluation effectively year-round

Evaluation compressed from weeks to days; SMEs review flagged exceptions instead of reading every page

Certifications and mandatory criteria spot-checked under time pressure

100% of SKUs and vendors checked against every mandatory criterion, every quarter

Headline-price comparisons across inconsistent schedules

Normalized total-cost comparison with alternates, tariff exposure, and quarter-over-quarter movement by SKU

Evaluation records reconstructed after the fact

Every score linked to a source citation — audit-ready the day the award is recommended

The compounding effect is the point. Because HillStar’s Knowledge Agent retains the rubric, the requirements matrix, and every prior quarter’s evaluations, each cycle starts from the last one instead of from scratch. Quarter over quarter, the system gets faster and the customer’s market picture gets sharper — which is exactly what a volatile tariff environment demands. What began as a workload problem became a capability: the customer can now re-price the market as often as the market moves.

References

  1. ProcureAbility, “Utility Supply Chain Tariffs.” Discusses tariff-driven cost volatility and supply-chain disruption across utility equipment and materials categories. procureability.com/utility-supply-chain-tariffs

See HillStar evaluate your next RFP

Bring a real bid stack. We'll show you scored, ranked, evidence-backed results in a single working session.