Home → Case Studies → Procurement Preference Calculator

Procurement Preference Calculator
Try the Bid Evaluation Yourself

Three bids come in. One vendor qualifies for a 5% small business preference. The calculator applies it the same way every time, names the winner, and writes the record an auditor will ask for.

1,300+Awards a Year
30%Faster Processing
1Audit Record per Award
The Problem

Challenge

The lowest bid doesn't always win. Getting that right by hand, 1,300 times a year, is where compliance quietly slips.

  • At the California Department of Corrections and Rehabilitation, most purchases drew three bids: a major vendor, a mid-size vendor that didn't qualify for a preference, and a certified small business or DVBE.
  • State rules gave qualifying vendors a 5% preference during evaluation. Applied by hand, it was easy to miss, apply to the wrong vendor, or calculate inconsistently.
  • When an award was questioned, there was no single document showing how the winner was chosen.
Live Demo · Mock Data

Run an Evaluation

Change a vendor number or any unit price. The subtotals, preference, winner, and award record update instantly.

Bid Evaluation: Regional Office Workstations

Solicitation RFQ-2026-0417 · Fictional vendors and pricing

Vendor number = vendor type. 1xxxx large business · 2xxxx mid-size, non-small business · 3xxxx certified small business / DVBE. Preference = 5% of the lowest non-small-business bid, deducted from a qualifying bid for evaluation only. The award is paid at the actual bid price.

Award Record (audit file)


        

      

      
A rebuild for demonstration. Vendors, pricing, and the solicitation number are fictional. The original was built in Excel for internal use.

    

  


  

    

      

        How It Works
        
From Bids to Award

      

      

        

          Step 1 · Identify
          
Vendor Number In

          
Enter the vendor number. Name and type fill in automatically, so nobody decides eligibility from memory.

        

        

          Step 2 · Price
          
Line Items to Subtotals

          
Unit prices times quantities roll up to a subtotal for each vendor, side by side.

        

        

          Step 3 · Adjust
          
Apply the 5% Preference

          
Qualifying vendors get the deduction for evaluation only. Everyone else is evaluated at their bid.

        

        

          Step 4 · Document
          
Winner + Audit Record

          
The lowest evaluated price wins, and the full math is written up for the file, including what the preference cost.

        

      

    

  


  

    

      

        Results
        
Impact

      

      

        

          
          
Preference Compliance Restored

          
DVBE and small business preferences applied the same way on every award, not just when someone remembered.

        

        

          
          
30% Faster Processing

          
Across 1,300+ transactions a year, evaluation went from hand math to a fill-in-the-numbers step.

        

        

          
          
The Audit Record

          
The calculator output became the official record for how each award was structured.

        

      

    

  


  

    

      

        Enterprise Translation
        
Why This Maps to Tech

      

      

        

          
Vendor ops at scale

          
Tech companies buy software, contractors, and services constantly. Same problem: consistent rules, many requests, little time.

        

        

          
Policy turned into a tool

          
The rule lives in the system, not in someone's head. That's the same thinking behind my Software and Vendor Request SOP.

        

        

          
Decisions you can defend

          
Every award shows its math. When Finance or an auditor asks "why this vendor?", the answer is one click away.

        

      

    

  


  

    

      

        More Case Studies
        
Related Work

      

      

        

          
$5M Portfolio Audit-Readiness

          
The bigger controls story this calculator was part of, including 3,000+ digitized records.

          $75K+ misallocations prevented →
        

        

          
AI Ops Toolkit

          
Includes a Software and Vendor Request SOP with approval thresholds and an expedited path.

          See the toolkit →
        

        

          
How I Work Remotely

          
The operating habits behind delivering this kind of work without sharing a building.

          See the rhythm →