Transparency portal
What residents, reporters and bidders can read.
When staff publish an award, the public portal shows who won, every bid as opened, how the panel scored it and the contract that followed. Spending and competition pages draw on the same records. None of it needs an account.
- The demo portal's Procurement Data page for the City of Westbridge: Total Contract Value This Fiscal Year $12.1M, 13 contracts; Competitive Solicitations 90%; Average Bidders 4.3; Local Vendor Spending 40%.
- Recent awards: FAC-26-104 Fire Station HVAC Modernization, Horizon Mechanical, $1,382,450; PW-26-049 Bridge Deck Rehabilitation - Market Street, Northstar Civil Construction, $3,820,000.
Demonstration data. The City of Westbridge is a fictional municipality.
Award page
One award page answers the questions people ask.
- The public award page for FAC-26-104, Fire Station HVAC Modernization, on the demo portal, with its seven parts numbered as in the list that follows.
- Awarded to Horizon Mechanical. Winning bid $1,382,450. Government estimate $1,600,000. Difference from estimate $217,550 below. 6 bids received, ranging from $1,382,450 to $1,538,900.
- The part the list is on is outlined; the rest of the page is dimmed.
Demonstration data. The City of Westbridge is a fictional municipality.
FAC-26-104, the title and the department, with the status Awarded. The same number follows the purchase from the solicitation to the contract, so anyone can trace it.
Who asks: Reporters
Who won, the winning bid of $1,382,450, the government estimate, the difference from the estimate, the 6 bids received and the range of prices, in one block.
Who asks: Residents
The page labels the gap as the difference from the estimate and explains what a government estimate is: what the agency expected the work to cost before it saw any bids.
Who asks: Council members
The bid tabulation lists every bid, lowest price first. The bid found non-responsive is marked, and the bid withdrawn before opening is listed too.
Who asks: Bidders
The committee average against each weight published in the solicitation, from 29 of 30 for price to a total of 94 of 100.
Who asks: Bidders
The award links to contract C-26-0058. Its current value moves only when a change order is executed, and the contract page gives the reason.
Who asks: Residents
One download with the solicitation, addenda, answered questions, the award and the bid tabulation. Sealed bids are not in it.
Who asks: Records clerks
Contracts
Every change, with its reason.
Residents see executed changes only, each with its reason.
- The public contract page for C-26-0041, Bridge Deck Rehabilitation - Market Street, Northstar Civil Construction. When awarded it reads: No changes have been published for this contract. The contract is at the value it was awarded for. Original value $3,820,000.
- Change order 1 is executed: adds $85,000, reason for the change: Unexpected electrical relocation. Current value $3,905,000.
- Change order 2 is executed: adds $42,500, reason for the change: Additional asbestos abatement. Published changes $127,500 from 2 executed changes. Current value $3,947,500. Change from original +3.3%.
- The staff page for the same contract also lists a pending change, Additional catch basin repairs, $47,500, awaiting approval and marked Internal. 1 change is in flight for $47,500. If all of them are executed the contract value becomes $3,995,000. The public page does not show it.
Demonstration data. The City of Westbridge is a fictional municipality.
Change from original
+3.3% executed
The public page labels growth of 25 percent or more, so a contract that keeps growing is easy to spot.
- Calculated from the record
- The current value is the original value plus every executed change order, so nobody enters it by hand.
- A reason for every change
- Each change on the public page carries the reason the agency gave, next to the amount.
- Pending changes stay internal
- A change awaiting approval appears on the staff page only. It reaches the public page when it is executed.
Spending and competition
Every chart comes with its table.
The spending and competition pages chart the same contract records the award pages use. Every chart has a text table behind it, and figures built on estimates carry their caveat.
$18,235,400$18,235,400
Current value of public contractsAcross 20 contracts in the demo city, fiscal year 2026.
Spending by Department
Current contract value by department.
| Department | Contract value |
|---|---|
| Public Works | $5.6M |
| Information Technology | $3.7M |
| Facilities Management | $2.8M |
| Water & Utilities | $2.3M |
| Parks & Recreation | $1.6M |
| Transportation | $1.6M |
| Fire & Rescue | $325K |
| Police | $310K |
Top Vendors by Award Value
Total awarded value by vendor.
| Vendor | Awarded value |
|---|---|
| Northstar Civil Construction | $3.9M |
| Meridian IT Solutions | $3.2M |
| Clearwater Pump & Well | $1.7M |
| Horizon Mechanical | $1.4M |
| Sterling Janitorial Services | $1.2M |
| Brightpath Traffic Systems | $941K |
| Lakeshore Roofing | $919K |
| Riverstone Concrete | $799K |
Competitive vs Noncompetitive Spending
Current contract value split by whether the contract was competitively bid.
98.5%
competitive
- Competitive contracts$17,955,400
- Noncompetitive contracts$280,000
| Contract type | Contract value | Share |
|---|---|---|
| Competitive contracts | $17,955,400 | 98.5% |
| Noncompetitive contracts | $280,000 | 1.5% |
4.64.6
Average bidders per competitive contractFrom the competitive contracts in the demo city, fiscal year 2026.
How Many Bids Contracts Receive
Public contracts by recorded bidder count.
1 bid
10%
2-3 bids
30%
4-6 bids
50%
7+ bids
10%
| Bidders | Contracts | Share |
|---|---|---|
| 1 bid | 2 | 10% |
| 2-3 bids | 6 | 30% |
| 4-6 bids | 10 | 50% |
| 7+ bids | 2 | 10% |
Competition by Department
Average number of bidders by department.
| Department | Average bidders |
|---|---|
| Public Works | 6 |
| Parks & Recreation | 5 |
| Water & Utilities | 4.5 |
| Facilities Management | 4 |
| Information Technology | 4 |
| Transportation | 3.5 |
| Police | 2 |
| Fire & Rescue | 2 |
Difference Between Government Estimate and Awarded Value
Across 5 published awards.
| Measure | Amount |
|---|---|
| Government estimates | $11,000,000 |
| Awarded value | $10,142,450 |
| Difference | $857,550 |
This difference is not a guarantee of realized savings; estimates are planning figures.
Demonstration data, City of Westbridge (fictional), fiscal year 2026.
Vendors and records
Vendor pages and records packets.
Each company with a public contract has a page with its awards and contract history. Each published solicitation has a records packet, one zip file with the record, for anyone who asks.
01Vendor pages
- The demo portal's Vendors page. Every company holding a public City of Westbridge contract, with total awarded value and competition figures from public contract records. Vendors by total awarded: Northstar Civil Construction $3.9M, local; Meridian IT Solutions $3.2M; Clearwater Pump & Well $1.7M; Horizon Mechanical $1.4M, local; Sterling Janitorial Services $1.2M, local; Brightpath Traffic Systems $941K.
- A visitor searches vendors by name for Horizon. One company matches.
- Horizon Mechanical's page: Local Vendor, Westbridge, OH, NAICS 238220. Total awarded $1.4M, Public contracts 1, Departments served 1. Figures reflect public City of Westbridge contracts only.
- Contract history: Fire Station HVAC Modernization, C-26-0058, current value $1,411,200, Active. Awards won: Fire Station HVAC Modernization, FAC-26-104, $1,382,450.
Demonstration data. The City of Westbridge is a fictional municipality.
02Records packets
FAC-26-104-records.zip
The award is published, so the tabulation is in.
- README.txt
- manifest.json
- solicitation.json
- addenda.json
- requirements.json
- response-form.json
- pricing.json
- documents.csv
- questions.json
- award.json
- contracts.json
- tabulation.csv
README.txt
City of Westbridge is a fictional municipality. This file is an AwardBeam demonstration record. It is not an official record of any government, and it does not certify any company or any person.
Records packet for FAC-26-104
The bid tabulation is included because the bids have been opened under the portal rules, or the award has been published.
What every packet leaves out
- Document files themselves. documents.csv lists each one, and each downloads from the solicitation page.
- Government estimates stored on the solicitation, award internal notes and evaluator notes.
- Correspondence that was never entered in the portal. The Procurement Office can still provide it on request.
- CSV downloads
- Contracts, spending and vendors download as CSV files from the transparency pages, without an account.
- A packet per solicitation
- Every published solicitation has its own records packet, ready for a public records request.
- Sealed means left out
- Until the opening is recorded, a packet holds a note in place of the bids, and says why.
Live demo
Open it in the live demo.
The public pages described here are live on the demo portal, and none of them needs a sign-in.
The City of Westbridge is a fictional municipality.
- DemoAward, FAC-26-104The award pageHorizon Mechanical at $1,382,450, every bid as opened, the 94 of 100 evaluation and the contract it produced.Open in the demo (opens in a new tab)
- DemoContract, C-26-0041A contract with change orders$3,820,000 to $3,947,500, with the reason for each change.Open in the demo (opens in a new tab)
- Demo/transparencyTransparency overviewThe fiscal year at a glance: contract value, competitive share, average bidders and local spending.Open in the demo (opens in a new tab)
- Demo/transparency/spendingSpendingBy department, by category, by month and by vendor, each chart with its table.Open in the demo (opens in a new tab)
- Demo/transparency/competitionCompetitionHow many bids contracts receive and competition by department, with the estimate caveat.Open in the demo (opens in a new tab)
- Demo/transparency/vendorsVendorsEvery company holding a public contract, with award totals, searchable by name.Open in the demo (opens in a new tab)
- Demo/recordsRecords packetsOne zip file per published solicitation, with sealed bids left out.Open in the demo (opens in a new tab)
The City of Westbridge shown on this site is a fictional municipality used for demonstration.