Business Intelligence · Client Case Study

Buyer Performance Report

An internal BI hub for a construction & materials company

This client runs a multi-yard construction and scrap-materials operation, and the numbers that matter — what each yard moves, what each buyer pays, and the margin left over — lived in multiple different systems: yard scale tickets, buyer purchase logs, and monthly accounting exports. Every reporting cycle meant hours of manual spreadsheet work. BKY built this internal business-intelligence dashboard to consolidate those sources into one automated report, so leadership opens a single page and sees volume, revenue, and gross margin across every yard and every buyer.

🔗
Multiple sources, one report Scale data, purchase logs, and finance exports merged into a single automated refresh
🏭
Two lenses on the business Toggle between per-yard performance and per-buyer profitability
📈
Margin intelligence Volume, revenue, and gross-margin trends tracked month over month

Live demo — names and figures shown are anonymized client data.

Dashboard view:
7,554,721
Volume (Lbs)
$8.42M
Total Revenue
12.83%
Overall GM %
June 2026
Data Period
Revenue by Location Breakdown
Gross Margin by Location
Volume & Margin Trends (MoM)
Gross Margin $ by Buyer Over Time
Gross Margin % by Buyer Over Time
Volume (Lbs) by Buyer Over Time
Total Gross Margin $ by Buyer
Average Gross Margin % by Buyer

Buyer Performance Summary

Buyer Total GM $ Avg GM % Total Lbs Avg GM $/Month
Metro Metals $4,857,721 15.27% 100,771,124 $231,320
Coastal Recycling $1,681,945 8.03% 25,289,464 $80,093
Tech Scrap Solutions $46,362 24.11% 718,398 $2,208
Junction Yard $2,512,658 30.16% 36,300,181 $119,650
Southern Network $179,331 12.90% 6,663,434 $17,933