Cold Case~67min

The Change Orders That Always Landed Just Under The Limit

PM-06 approved 4 change orders for vendor VEN-14 — $24,100, $24,600, $24,850, and $24,300, totaling $97,850.00 — every single one just under his $25,000 sole-approval authority, avoiding the second-signature review a single larger change order would trigger. VEN-14 also charges $185.50 per cubic yard of concrete on PM-06's projects on average, versus $132.00 on every other PM's project with the same vendor — 40% higher, only for PM-06. PM-11 also approved 3 change orders for VEN-22 clustered just under the $25,000 threshold, totaling $73,350.00, but VEN-22 charges the identical $95.00 per unit to every PM, including PM-11 — a vendor whose standard job package happens to price near that number, not a kickback.

Tables you'll query

projectschange_ordersvendor_unit_costs

What you'll learn

JOINsAggregations & GROUP BYSubqueries
Investigate this case →