Business Pattern Analysis
Uncovering hidden capital inefficiencies, utilization imbalances, and transformation opportunities across the fleet
?
Total Fleet Value
Total dollar value of all equipment across your fleet (on-site + yard + repair + damage). Source: yard_inventory table.
SUM(TotalQty$_PL_USD)Total dollar value of all equipment across your fleet (on-site + yard + repair + damage). Source: yard_inventory table.
$2.0B
Total Fleet Value
14,864 SKUs • 198 branches • 11 regions
?
Overall Utilization
Percentage of total equipment actively deployed at customer sites vs sitting idle. Higher = better capital efficiency.
SUM(QtyOnSite) / SUM(TotalQty) × 100Percentage of total equipment actively deployed at customer sites vs sitting idle. Higher = better capital efficiency.
61.8%
Overall Utilization
69 branches <20% • 63 branches >70%
?
Trapped Capital
Where Repair$ = (QtyInRepair/TotalQty) × TotalValue and Damage$ = (QtyDamage/TotalQty) × TotalValue. This is capital locked in broken equipment generating zero revenue.
Repair$ + Damage$Where Repair$ = (QtyInRepair/TotalQty) × TotalValue and Damage$ = (QtyDamage/TotalQty) × TotalValue. This is capital locked in broken equipment generating zero revenue.
$55.5M
Trapped Capital
2.7% of fleet • Repair + Damage queues
?
Rebalancing Opportunity
For branches with <20% utilization, calculates surplus inventory value and takes 30% as conservative transfer estimate. Move equipment from surplus to high-demand locations.
SUM(SurplusValue × 0.30)For branches with <20% utilization, calculates surplus inventory value and takes 30% as conservative transfer estimate. Move equipment from surplus to high-demand locations.
$95.8M
Rebalancing Opportunity
Est. transferable value from surplus branches
?
Dead Capital
Sum of inventory value for branch-category positions where more than 60% of equipment sits idle in yards. This is "dead" inventory not generating any revenue.
SUM(YardValue) WHERE (QtyInYard/TotalQty) > 60%Sum of inventory value for branch-category positions where more than 60% of equipment sits idle in yards. This is "dead" inventory not generating any revenue.
$161.2M
Dead Capital
30 positions with >60% idle in yards
Executive Summary — Key Findings & Opportunities
1. Fleet Utilization Gap: The $2.0B fleet operates at 61.8% average utilization.
69 branches (34.8%) operate below 20% utilization with $319.4M in surplus inventory,
while 63 branches (31.8%) exceed 70% and are capacity-constrained.
2. Trapped Capital: $55.5M (2.7%) is locked in repair ($49.9M) and damage ($5.6M) queues — capital that generates zero revenue while accumulating holding costs.
3. Transfer Opportunity: Rebalancing inventory from surplus to constrained branches could unlock an estimated $95.8M in earning potential without new capex.
4. System Fragmentation: 20 items worth $6.1M are tracked across multiple ERPs with >20% cost variance — a hidden procurement tax.
5. Pricing Arbitrage: 20 items totaling $5.2M show >50% regional rate spreads — margin leakage requiring rate harmonization.
2. Trapped Capital: $55.5M (2.7%) is locked in repair ($49.9M) and damage ($5.6M) queues — capital that generates zero revenue while accumulating holding costs.
3. Transfer Opportunity: Rebalancing inventory from surplus to constrained branches could unlock an estimated $95.8M in earning potential without new capex.
4. System Fragmentation: 20 items worth $6.1M are tracked across multiple ERPs with >20% cost variance — a hidden procurement tax.
5. Pricing Arbitrage: 20 items totaling $5.2M show >50% regional rate spreads — margin leakage requiring rate harmonization.
Trapped Capital
$55.5M
In Repair
$49.9M
Damaged
$5.6M
Top branches:
Toronto F&S, Seattle F&S, Fontana
Click to drill down → Audit repair queues, set 30-day SLA
Fleet Rebalancing
$95.8M
Surplus Branches
69
34.8% of 198 branches
Constrained
63
31.8% of branches
Top surplus:
Great Lakes CC (16.4%), B&H Athens (0.0%), Toronto F&S (12.4%)
Click to drill down → Match surplus with constrained branches
System Fragmentation
$6.1M
Affected Items
20
>20% cost spread
Inventory Value
$6.1M
Top items:
T7 TIRFOR (4030900% spread); GUARD RAIL GATE (492900% spread)
Click to drill down → Harmonize to lowest allocation cost
Regional Pricing Gap
$5.2M
Items Affected
20
>50% rate spread
Inventory at Risk
$5.2M
Top items:
MOD PLATFORM 1/2M W/4 HB… (5933% spread); A CLAMP ASSEMBLY (4400% spread)
Click to drill down → Implement zone-based pricing
Capital at Vendors
$7.3M
% of Fleet
0.4%
Est. Monthly Loss
$7.3M
@5% monthly rate
ACTION: Weekly vendor return SLA, prioritize high-value items
Dead Capital in Yards
$161.2M
Positions
30
branch-category combos
Units Idle
2.7M
>60% in yard
Top positions:
B&H Athens / Construction E… ($22.3M); SA Carlstad / Construction E… ($14.8M)
Click to drill down → Set disposition plan for items idle >90 days
Regional Utilization Heatmap
Fleet avg: 61.8% | Target: >50% | Click region for branch breakdown
Gulf
70.5%
19 branches
West
67.0%
52 branches
Northeast
63.8%
46 branches
Southeast & Specialty
61.0%
36 branches
Canada
57.6%
31 branches
FS LATAM
43.7%
4 branches
NA HQ
0.2%
4 branches
CFO
0.0%
1 branches
HQ HOB / Other
0.0%
5 branches
NA
0.0%
0 branches
Corp Affairs
0.0%
1 branches
>60% (High)
45-60%
20-45%
<20% (Low)
Source System Comparison
Click row for branch breakdown
| System | Branches | SKUs | Total Qty | Fleet Value | Utilization | Impaired % |
|---|---|---|---|---|---|---|
| Profield | 75 | 8,949 | 61.4M | $1.1B | 59.4% | 1.8% |
|
Loading branch breakdown...
|
||||||
| BAS | 98 | 9,051 | 25.7M | $895.6M | 68.4% | 0.2% |
|
Loading branch breakdown...
|
||||||
| AGF | 5 | 644 | 333.9K | $16.1M | 3.4% | 0.0% |
|
Loading branch breakdown...
|
||||||
| ORACLE | 0 | 26 | 4.9K | $103.0K | 0.0% | 0.0% |
|
Loading branch breakdown...
|
||||||
| JDE | 25 | 54 | 2.0K | $16.5K | 0.1% | 0.2% |
|
Loading branch breakdown...
|
||||||
Category Portfolio Mix
Click row for branch breakdown
| Category | Branches | SKUs | Total Qty | Fleet Value | Utilization | Repair % | Concentration |
|---|---|---|---|---|---|---|---|
| Scaffolding System | 155 | 3,523 | 29.7M | $791.8M | 74.8% | 0.1% | |
|
Loading branch breakdown...
|
|||||||
| Universal | 166 | 2,212 | 27.4M | $514.2M | 81.7% | 0.3% | |
|
Loading branch breakdown...
|
|||||||
| Construction Elevator | 76 | 541 | 955.3K | $143.4M | 38.9% | 0.0% | |
|
Loading branch breakdown...
|
|||||||
| Shoring System | 140 | 908 | 7.8M | $124.2M | 46.8% | 2.6% | |
|
Loading branch breakdown...
|
|||||||
| Suspended | 153 | 2,396 | 635.5K | $114.7M | 47.2% | 0.1% | |
|
Loading branch breakdown...
|
|||||||
| Formwork | 80 | 1,742 | 4.3M | $104.0M | 53.0% | 2.9% | |
|
Loading branch breakdown...
|
|||||||
| Grid and Decking | 34 | 305 | 988.1K | $59.7M | 13.6% | 16.1% | |
|
Loading branch breakdown...
|
|||||||
| Beam Formwork | 135 | 372 | 1.2M | $58.3M | 40.6% | 3.6% | |
|
Loading branch breakdown...
|
|||||||
| Mast Climber | 82 | 606 | 99.8K | $47.6M | 24.0% | 0.1% | |
|
Loading branch breakdown...
|
|||||||
| Formwork Accessories | 142 | 1,089 | 13.8M | $26.1M | 14.9% | 2.6% | |
|
Loading branch breakdown...
|
|||||||
| SITE INFRASTRUCTURE & SAFETY | 74 | 81 | 148.4K | $15.2M | 26.0% | 0.9% | |
|
Loading branch breakdown...
|
|||||||
| Material Hoist | 102 | 143 | 39.4K | $13.0M | 51.5% | 0.0% | |
|
Loading branch breakdown...
|
|||||||
| Transport Platform | 78 | 202 | 22.7K | $10.4M | 20.2% | 0.0% | |
|
Loading branch breakdown...
|
|||||||
| Climbing Formwork | 17 | 353 | 260.5K | $8.3M | 35.1% | 0.6% | |
|
Loading branch breakdown...
|
|||||||
| AWP Core | 6 | 27 | 99.0 | $2.5M | 36.4% | 0.0% | |
|
Loading branch breakdown...
|
|||||||
| Material Lifting | 88 | 104 | 1.7K | $1.8M | 25.9% | 0.1% | |
|
Loading branch breakdown...
|
|||||||
| Aerial Work Platforms – Legacy | 9 | 18 | 2.5K | $989.9K | 68.3% | 0.0% | |
|
Loading branch breakdown...
|
|||||||
| None | 6 | 122 | 55.7K | $959.8K | 0.6% | 0.0% | |
|
Loading branch breakdown...
|
|||||||
| AWP Repair Parts | 33 | 59 | 53.2K | $586.4K | 22.9% | 0.0% | |
|
Loading branch breakdown...
|
|||||||
| SHORING SYSTEM | 0 | 13 | 3.0K | $89.5K | 0.0% | 0.0% | |
|
Loading branch breakdown...
|
|||||||
Capital trapped in repair and damage queues is the most immediate value-destruction pattern.
Each day in repair is a day of lost rental revenue. The branches below have the highest absolute dollar value
locked in non-earning states — these are the priority targets for repair SLA enforcement, write-off review,
or vendor acceleration programs. Click any row to see category breakdown.
| Branch | Region | Repair Qty | Damaged Qty | Repair Value | Damage Value | Total Fleet | Trapped % |
|---|---|---|---|---|---|---|---|
| Toronto F&S | Canada | 212,341 | 1,204 | $13.6M | $197.8K | $45.6M | 30.2% |
|
Loading category breakdown...
|
|||||||
| Seattle F&S | West | 73,848 | 25,946 | $5.8M | $1.3M | $14.3M | 49.9% |
|
Loading category breakdown...
|
|||||||
| Fontana | West | 92,829 | 8,383 | $6.3M | $662.9K | $17.2M | 40.3% |
|
Loading category breakdown...
|
|||||||
| Great Lakes CC | Northeast | 316,067 | 5,331 | $6.6M | $309.4K | $16.5M | 41.6% |
|
Loading category breakdown...
|
|||||||
| Sacramento Main | West | 35,555 | 4,884 | $3.9M | $482.5K | $15.7M | 28.0% |
|
Loading category breakdown...
|
|||||||
| Vancouver F&S | Canada | 35,804 | 47,432 | $1.9M | $762.7K | $16.2M | 16.8% |
|
Loading category breakdown...
|
|||||||
| Houston F&S | Gulf | 30,654 | 3,341 | $2.0M | $395.9K | $27.0M | 8.8% |
|
Loading category breakdown...
|
|||||||
| Edmonton F&S | Canada | 26,453 | 21,321 | $1.8M | $553.7K | $21.8M | 10.8% |
|
Loading category breakdown...
|
|||||||
| Miami | Southeast & Specialty | 44,460 | 0 | $2.0M | $0 | $11.1M | 18.1% |
|
Loading category breakdown...
|
|||||||
| Engel Holdings - Stanwood | West | 11 | 0 | $1.4M | $0 | $2.0M | 68.8% |
|
Loading category breakdown...
|
|||||||
| Engel Holdings - Fontana | West | 33 | 0 | $911.7K | $0 | $3.4M | 26.5% |
|
Loading category breakdown...
|
|||||||
| Edmonton | Canada | 30,478 | 2 | $766.2K | $37 | $9.6M | 8.0% |
|
Loading category breakdown...
|
|||||||
| SW Boston | Northeast | 135 | 0 | $765.5K | $0 | $806.4K | 94.9% |
|
Loading category breakdown...
|
|||||||
| Fort McMurray | Canada | 21,453 | 7,019 | $410.6K | $102.1K | $49.5M | 1.0% |
|
Loading category breakdown...
|
|||||||
| Montreal F&S | Canada | 30,943 | 1,816 | $280.8K | $220.2K | $2.4M | 20.7% |
|
Loading category breakdown...
|
|||||||
| Linden | Northeast | 1,885 | 3,286 | $103.9K | $115.7K | $11.1M | 2.0% |
|
Loading category breakdown...
|
|||||||
| Atlanta F&S | Southeast & Specialty | 3,857 | 1,117 | $201.7K | $16.6K | $5.0M | 4.4% |
|
Loading category breakdown...
|
|||||||
| Charlotte | Southeast & Specialty | 203 | 0 | $205.6K | $0 | $865.1K | 23.8% |
|
Loading category breakdown...
|
|||||||
| Huntington | Northeast | 6,907 | 644 | $179.7K | $19.9K | $219.0K | 91.1% |
|
Loading category breakdown...
|
|||||||
| Cincinnati | Southeast & Specialty | 4 | 0 | $159.8K | $0 | $1.4M | 11.2% |
|
Loading category breakdown...
|
|||||||
Utilization imbalance reveals the fleet allocation problem: some branches sit on surplus equipment
earning nothing, while others turn away business because they lack inventory.
The table is sorted lowest-utilization-first — these are the branches where capital is most idle
and transfers would have the highest impact. Click any row to see category breakdown.
| Branch | Region | On Site | Rent Ready | In Yard | Total Qty | Fleet Value | Utilization |
|---|---|---|---|---|---|---|---|
| DSS | HQ HOB / Other | 0 | 10,810 | 10,810 | 10,914 | $475.7K | 0.0% |
|
Loading category breakdown...
|
|||||||
| Safeworks, LLC (Spider)-60026-E&I | West | 0 | 37 | 37 | 37 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| SW SAN FRANCISCO | West | 0 | 130 | 130 | 130 | $2.4K | 0.0% |
|
Loading category breakdown...
|
|||||||
| Corporate Maintenance | CFO | 0 | 139,026 | 139,026 | 140,967 | $3.4M | 0.0% |
|
Loading category breakdown...
|
|||||||
| R&D | HQ HOB / Other | 0 | 52 | 52 | 52 | $1.8K | 0.0% |
|
Loading category breakdown...
|
|||||||
| Safeworks, LLC (Spider)-60008-C&I | Northeast | 0 | 488 | 488 | 488 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| St.Louis RDC | NA HQ | 0 | 18,463 | 18,463 | 18,463 | $7.5M | 0.0% |
|
Loading category breakdown...
|
|||||||
| Louisville Fulfillment Center | Southeast & Specialty | 0 | 6,701 | 6,701 | 6,751 | $4.8M | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - NEW ORLEANS | Gulf | 0 | 2 | 2 | 2 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| USD Region Offices | NA HQ | 0 | 723,990 | 723,990 | 723,990 | $4.9M | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - ELEVATOR | Southeast & Specialty | 0 | 1 | 1 | 1 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| SW St Louis | Northeast | 0 | 75 | 75 | 75 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - DALLAS | Gulf | 0 | 178 | 178 | 178 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| Jasper Materials | HQ HOB / Other | 0 | 44,642 | 44,642 | 45,980 | $376.7K | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - CHARLOTTE | Southeast & Specialty | 0 | 10 | 10 | 14 | $10.9K | 0.0% |
|
Loading category breakdown...
|
|||||||
| Carolina Commercial | Southeast & Specialty | 0 | 6,917 | 6,917 | 6,930 | $3.6M | 0.0% |
|
Loading category breakdown...
|
|||||||
| Saskatchewan | Canada | 0 | 267 | 267 | 267 | $17.5K | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - PENSACOLA | Southeast & Specialty | 0 | 0 | 0 | 0 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| B&H Athens | Northeast | 0 | 68,788 | 68,788 | 68,788 | $23.8M | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - NEW YORK | Northeast | 0 | 115 | 115 | 115 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - VANCOUVER | Canada | 0 | 39 | 39 | 39 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| Pittsburgh Maintenance | Corp Affairs | 0 | 2,358 | 2,358 | 2,358 | $209.0K | 0.0% |
|
Loading category breakdown...
|
|||||||
| West RDC | Northeast | 0 | 256,375 | 256,375 | 256,375 | $8.2M | 0.0% |
|
Loading category breakdown...
|
|||||||
| Technocraft | HQ HOB / Other | 0 | 1,126 | 1,126 | 1,126 | $104.7K | 0.0% |
|
Loading category breakdown...
|
|||||||
| Bil-Jax | HQ HOB / Other | 0 | 1,102 | 1,102 | 1,318 | $76.6K | 0.0% |
|
Loading category breakdown...
|
|||||||
| GREENWOOD STORAGE | West | 0 | 477 | 477 | 477 | $51.8K | 0.0% |
|
Loading category breakdown...
|
|||||||
| Safeworks, LLC (Spider)-60006-C&I | Northeast | 0 | 105 | 105 | 105 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - DETROIT | Northeast | 0 | 3 | 3 | 3 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - ORLANDO | Southeast & Specialty | 0 | 266 | 266 | 266 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
| SPIDER - ST. LOUIS | Northeast | 0 | 37 | 37 | 37 | $0 | 0.0% |
|
Loading category breakdown...
|
|||||||
These branch-category positions have more than 60% of inventory sitting idle in yards.
Unlike "rent ready" equipment awaiting dispatch, these items are occupying yard space,
accumulating depreciation, and generating zero return. Each row is a candidate for
inter-branch rebalancing, resale, or strategic write-off.
| Branch | Region | Category | In Yard | On Site | Total | Yard Value | Yard % |
|---|---|---|---|---|---|---|---|
| B&H Athens | Northeast | Construction Elevator | 56,536 | 0 | 56,536 | $22.3M | 100.0% |
|
Loading category breakdown...
|
|||||||
| SA Carlstad | Northeast | Construction Elevator | 283,191 | 164,043 | 447,234 | $14.8M | 63.3% |
|
Loading category breakdown...
|
|||||||
| Houston F&S | Gulf | Formwork Accessories | 556,539 | 28,390 | 584,982 | $8.9M | 95.1% |
|
Loading category breakdown...
|
|||||||
| Bridge New York | NA HQ | Scaffolding System | 135,394 | 2,170 | 137,909 | $7.5M | 98.2% |
|
Loading category breakdown...
|
|||||||
| Linden | Northeast | Grid and Decking | 106,633 | 8,204 | 115,270 | $6.9M | 92.5% |
|
Loading category breakdown...
|
|||||||
| Great Lakes CC | Northeast | Shoring System | 336,595 | 96,855 | 443,783 | $6.2M | 75.8% |
|
Loading category breakdown...
|
|||||||
| West RDC | Northeast | Scaffolding System | 181,323 | 0 | 181,323 | $5.5M | 100.0% |
|
Loading category breakdown...
|
|||||||
| Seattle F&S | West | Grid and Decking | 121,872 | 13,716 | 176,035 | $5.1M | 69.2% |
|
Loading category breakdown...
|
|||||||
| Sacramento Main | West | Grid and Decking | 84,820 | 1,296 | 111,174 | $5.0M | 76.3% |
|
Loading category breakdown...
|
|||||||
| Florida Fulfillment Center | Southeast & Specialty | Mast Climber | 5,030 | 0 | 5,056 | $4.9M | 99.5% |
|
Loading category breakdown...
|
|||||||
| Houston F&S | Gulf | Grid and Decking | 60,611 | 7,296 | 68,057 | $4.7M | 89.1% |
|
Loading category breakdown...
|
|||||||
| St.Louis RDC | NA HQ | Mast Climber | 2,343 | 0 | 2,343 | $4.7M | 100.0% |
|
Loading category breakdown...
|
|||||||
| Louisville Fulfillment Center | Southeast & Specialty | Suspended | 6,476 | 0 | 6,526 | $4.6M | 99.2% |
|
Loading category breakdown...
|
|||||||
| Wisconsin Rapids - Brace | Northeast | Scaffolding System | 101,438 | 41,465 | 142,903 | $4.5M | 71.0% |
|
Loading category breakdown...
|
|||||||
| Miami Fulfillment Center | Southeast & Specialty | Construction Elevator | 5,990 | 0 | 5,990 | $4.3M | 100.0% |
|
Loading category breakdown...
|
|||||||
| Great Lakes CC | Northeast | Grid and Decking | 51,129 | 992 | 52,121 | $4.1M | 98.1% |
|
Loading category breakdown...
|
|||||||
| SC TORONTO | Canada | SITE INFRASTRUCTURE & SAFETY | 52,159 | 1,079 | 53,238 | $4.0M | 98.0% |
|
Loading category breakdown...
|
|||||||
| Paraiso | FS LATAM | Scaffolding System | 138,196 | 37,336 | 175,532 | $4.0M | 78.7% |
|
Loading category breakdown...
|
|||||||
| NE RDC | Northeast | Construction Elevator | 30,450 | 0 | 30,450 | $3.9M | 100.0% |
|
Loading category breakdown...
|
|||||||
| TERREBONNE | Canada | Construction Elevator | 22,665 | 9,249 | 31,914 | $3.7M | 71.0% |
|
Loading category breakdown...
|
|||||||
| Engel Holdings - Union City | West | Construction Elevator | 10,189 | 5,166 | 15,368 | $3.6M | 66.3% |
|
Loading category breakdown...
|
|||||||
| Engel Holdings - Stanwood | West | Mast Climber | 1,735 | 0 | 1,735 | $3.5M | 100.0% |
|
Loading category breakdown...
|
|||||||
| SW Boston | Northeast | Suspended | 9,648 | 4,508 | 14,156 | $3.3M | 68.2% |
|
Loading category breakdown...
|
|||||||
| Great Lakes CC | Northeast | Climbing Formwork | 96,964 | 14,107 | 111,923 | $3.3M | 86.6% |
|
Loading category breakdown...
|
|||||||
| San Antonio Commercial | Gulf | Scaffolding System | 98,718 | 51,325 | 150,043 | $3.2M | 65.8% |
|
Loading category breakdown...
|
|||||||
| SC TORONTO | Canada | Mast Climber | 8,963 | 5,310 | 14,273 | $3.2M | 62.8% |
|
Loading category breakdown...
|
|||||||
| Carolina Commercial | Southeast & Specialty | Mast Climber | 6,251 | 0 | 6,264 | $3.0M | 99.8% |
|
Loading category breakdown...
|
|||||||
| SW SAN DIEGO | West | Construction Elevator | 14,459 | 1,727 | 16,186 | $2.9M | 89.3% |
|
Loading category breakdown...
|
|||||||
| SA Chicago | Northeast | Construction Elevator | 19,584 | 3,930 | 23,514 | $2.8M | 83.3% |
|
Loading category breakdown...
|
|||||||
| Edmonton F&S | Canada | Grid and Decking | 62,978 | 5,727 | 69,176 | $2.7M | 91.0% |
|
Loading category breakdown...
|
|||||||
When the same equipment is tracked in multiple ERP systems with different item codes and costs,
it creates a hidden tax: inflated procurement costs, inconsistent pricing to customers,
and inventory planning blind spots. The cost spread column shows the percentage difference
between the cheapest and most expensive allocation cost for the same item across systems.
Click any row to see branch-by-branch breakdown.
| Item Description | Systems | Branches | Total Qty | Total Value | Min Cost | Max Cost | Cost Spread |
|---|---|---|---|---|---|---|---|
| ProfieldAGF | 3 | 7 | $1.2K | $0.01 | $403.10 | 4030900.0% | |
|
Loading branch breakdown...
|
|||||||
| ProfieldBAS | 59 | 44,611 | $1.9M | $0.01 | $49.30 | 492900.0% | |
|
Loading branch breakdown...
|
|||||||
| ProfieldBASAGF | 4 | 152 | $3.1K | $0.51 | $48.65 | 9520.3% | |
|
Loading branch breakdown...
|
|||||||
| BASAGF | 3 | 1,036 | $6.7K | $0.66 | $46.30 | 6933.3% | |
|
Loading branch breakdown...
|
|||||||
| ORACLEProfield | 6 | 4,103 | $4.7K | $0.60 | $36.25 | 5941.9% | |
|
Loading branch breakdown...
|
|||||||
| ProfieldBAS | 19 | 307 | $251.0K | $20.25 | $1221.60 | 5932.6% | |
|
Loading branch breakdown...
|
|||||||
| BASProfield | 3 | 19 | $1.5K | $6.41 | $200.00 | 3020.1% | |
|
Loading branch breakdown...
|
|||||||
| ProfieldBAS | 15 | 36,040 | $8.8K | $0.01 | $0.30 | 2900.0% | |
|
Loading branch breakdown...
|
|||||||
| BASProfieldORACLE | 64 | 9,700 | $1.2M | $127.37 | $2275.91 | 1686.9% | |
|
Loading branch breakdown...
|
|||||||
| ORACLEProfield | 11 | 12,614 | $174.9K | $13.94 | $237.12 | 1601.0% | |
|
Loading branch breakdown...
|
|||||||
| BASProfield | 32 | 519 | $43.9K | $6.78 | $105.60 | 1457.5% | |
|
Loading branch breakdown...
|
|||||||
| BASProfield | 75 | 40,116 | $1.9M | $4.11 | $61.80 | 1403.6% | |
|
Loading branch breakdown...
|
|||||||
| BASProfield | 47 | 1,424 | $229.8K | $12.94 | $192.20 | 1385.3% | |
|
Loading branch breakdown...
|
|||||||
| ProfieldBAS | 8 | 16 | $4.6K | $33.51 | $482.90 | 1341.1% | |
|
Loading branch breakdown...
|
|||||||
| BASProfieldORACLE | 13 | 7,353 | $84.6K | $11.55 | $156.31 | 1253.4% | |
|
Loading branch breakdown...
|
|||||||
| ProfieldBAS | 11 | 156 | $52.8K | $27.03 | $360.00 | 1231.9% | |
|
Loading branch breakdown...
|
|||||||
| ProfieldBAS | 42 | 2,241 | $31.4K | $1.81 | $23.10 | 1176.2% | |
|
Loading branch breakdown...
|
|||||||
| BASAGF | 3 | 37 | $7.2K | $32.83 | $405.80 | 1136.1% | |
|
Loading branch breakdown...
|
|||||||
| BASProfield | 14 | 297 | $92.3K | $32.63 | $392.00 | 1101.3% | |
|
Loading branch breakdown...
|
|||||||
| BASProfield | 21 | 140 | $39.8K | $25.38 | $300.00 | 1082.0% | |
|
Loading branch breakdown...
|
|||||||
These items have PL rates that differ by more than 50% across regions.
This means the same piece of equipment earns vastly different rental revenue depending on where it's deployed.
While some regional variation is expected (market rates differ), spreads over 100% suggest
rate card misalignment rather than genuine market pricing — and a margin leak when customers compare quotes.
Click any row to see regional rate breakdown.
| Item | Category | Regions | Min Rate | Max Rate | Avg Rate | Spread | Qty | Value |
|---|---|---|---|---|---|---|---|---|
| Suspended | $20.25 | $1221.60 | $789.43 | 5933% | 307 | $251.0K | ||
|
Loading regional breakdown...
|
||||||||
| Shoring System | $0.06 | $2.70 | $0.67 | 4400% | 291,239 | $40.3K | ||
|
Loading regional breakdown...
|
||||||||
| Universal | $0.01 | $0.30 | $0.20 | 2900% | 36,040 | $8.8K | ||
|
Loading regional breakdown...
|
||||||||
| Universal | $127.37 | $2275.91 | $153.29 | 1687% | 9,700 | $1.2M | ||
|
Loading regional breakdown...
|
||||||||
| Universal | $278.75 | $4684.52 | $469.88 | 1581% | 750 | $198.0K | ||
|
Loading regional breakdown...
|
||||||||
| Shoring System | $15.18 | $246.20 | $32.10 | 1522% | 11,550 | $165.6K | ||
|
Loading regional breakdown...
|
||||||||
| Universal | $209.51 | $3352.67 | $531.99 | 1500% | 130 | $26.1K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $6.78 | $105.60 | $79.70 | 1458% | 519 | $43.9K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $4.11 | $61.80 | $37.51 | 1404% | 40,116 | $1.9M | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $12.94 | $192.20 | $149.18 | 1385% | 1,424 | $229.8K | ||
|
Loading regional breakdown...
|
||||||||
| Shoring System | $14.92 | $215.48 | $33.68 | 1344% | 15,628 | $200.5K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $33.51 | $482.90 | $370.55 | 1341% | 16 | $4.6K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $27.03 | $360.00 | $299.46 | 1232% | 156 | $52.8K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $1.81 | $23.10 | $14.87 | 1176% | 2,241 | $31.4K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $32.63 | $392.00 | $263.65 | 1101% | 297 | $92.3K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $25.38 | $300.00 | $273.85 | 1082% | 140 | $39.8K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $0.99 | $10.78 | $8.23 | 989% | 5,867 | $53.7K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $3.93 | $41.60 | $24.86 | 959% | 138 | $3.2K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $3.75 | $37.50 | $25.36 | 900% | 1,092 | $29.9K | ||
|
Loading regional breakdown...
|
||||||||
| Suspended | $55.81 | $516.00 | $391.62 | 825% | 1,342 | $585.2K | ||
|
Loading regional breakdown...
|
||||||||
Fleet right-sizing compares each branch's fleet size against its utilization and impairment rate.
Branches with high fleet value but low utilization are over-capitalized — they hold more equipment than
their market demands. Branches with high utilization and high impairment are under-serviced —
their equipment is wearing out faster than it's being repaired or replaced.
| Branch | Region | SKUs | Fleet Value | On Site | Rent Ready | Repair | Damaged | Utilization | Impaired | Assessment |
|---|---|---|---|---|---|---|---|---|---|---|
| Woodland LayDown | West | 46 | $74.4K | 0 | 6,641 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| USD Region Offices | NA HQ | 246 | $4.9M | 0 | 723,990 | 0 | 0 | 0.0% | 0.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| VANCOUVER ILS FGI | Canada | 2 | $11.5K | 0 | 226 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| DSS | HQ HOB / Other | 18 | $475.7K | 0 | 10,810 | 104 | 0 | 0.0% | 1.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Virginia Fulfillment Center | Southeast & Specialty | 123 | $2.8M | 0 | 3,902 | 2 | 0 | 0.0% | 0.1% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| SPIDER - DALLAS | Gulf | 2 | $0 | 0 | 178 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| B&H Athens | Northeast | 210 | $23.8M | 0 | 68,788 | 0 | 0 | 0.0% | 0.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Manitoba | Canada | 22 | $56.6K | 0 | 1,809 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| Bil-Jax | HQ HOB / Other | 23 | $76.6K | 0 | 1,102 | 216 | 0 | 0.0% | 16.4% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| Safeworks, LLC (Spider)-60008-C&I | Northeast | 16 | $0 | 0 | 488 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| Miami Fulfillment Center | Southeast & Specialty | 50 | $5.3M | 0 | 6,551 | 0 | 0 | 0.0% | 0.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Louisville Fulfillment Center | Southeast & Specialty | 281 | $4.8M | 0 | 6,701 | 50 | 0 | 0.0% | 0.7% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Carolina Commercial | Southeast & Specialty | 121 | $3.6M | 0 | 6,917 | 13 | 0 | 0.0% | 0.2% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| GREENWOOD STORAGE | West | 16 | $51.8K | 0 | 477 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| SPIDER - ORLANDO | Southeast & Specialty | 4 | $0 | 0 | 266 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| SPIDER - SEATTLE | West | 3 | $0 | 0 | 251 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| Saskatchewan | Canada | 21 | $17.5K | 0 | 267 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| SW SAN FRANCISCO | West | 2 | $2.4K | 0 | 130 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| Safeworks, LLC (Spider)-60013-E&I | Gulf | 2 | $0 | 0 | 175 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| West RDC | Northeast | 781 | $8.2M | 0 | 256,375 | 0 | 0 | 0.0% | 0.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| VANCOUVER FGI | Canada | 4 | $80.0K | 0 | 2,100 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| St.Louis RDC | NA HQ | 202 | $7.5M | 0 | 18,463 | 0 | 0 | 0.0% | 0.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| EI HQ N | Gulf | 284 | $3.0M | 0 | 74,367 | 0 | 0 | 0.0% | 0.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Corporate Maintenance | CFO | 329 | $3.4M | 0 | 139,026 | 1,941 | 0 | 0.0% | 1.4% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Houston Fulfillment Center | Southeast & Specialty | 5 | $32.6K | 0 | 937 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| SPIDER - NEW YORK | Northeast | 1 | $0 | 0 | 115 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
| Birmingham RDC | NA HQ | 549 | $4.7M | 0 | 123,492 | 0 | 0 | 0.0% | 0.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Technocraft | HQ HOB / Other | 10 | $104.7K | 0 | 1,126 | 0 | 0 | 0.0% | 0.0% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Jasper Materials | HQ HOB / Other | 104 | $376.7K | 0 | 44,642 | 1,338 | 0 | 0.0% | 2.9% | OVER-CAPITALIZED |
|
Loading category breakdown...
|
||||||||||
| Safeworks, LLC (Spider)-60006-C&I | Northeast | 4 | $0 | 0 | 105 | 0 | 0 | 0.0% | 0.0% | REVIEW NEEDED |
|
Loading category breakdown...
|
||||||||||
This 90-day action plan targets $55.5M in trapped capital,
$95.8M in rebalancing opportunity, and
$161.2M in dead capital across 198 branches.
Each initiative has specific branch targets, financial impact, and measurable KPIs.
Capital Efficiency Transformation — 90-Day Action Plan
1
Repair Queue Blitz (Week 1-4) → Click for details
$55.5M trapped in repair ($49.9M) and damage ($5.6M) queues — 2.7% of total fleet.
Priority Branches (Top 5)
Toronto F&S
$13.6M repair + $197.8K damage
Seattle F&S
$5.8M repair + $1.3M damage
Fontana
$6.3M repair + $662.9K damage
Great Lakes CC
$6.6M repair + $309.4K damage
Sacramento Main
$3.9M repair + $482.5K damage
Actions: (1) Audit items in repair >60 days — evaluate write-off vs. repair economics
(2) Set 30-day repair SLA with vendor penalty clauses
(3) Expedite high-value items (>$5K unit cost) to front of queue
Target: Reduce trapped capital by 40% ($5,528,456 → $5,528,456) within 30 days
Target: Reduce trapped capital by 40% ($5,528,456 → $5,528,456) within 30 days
$55.5M
2
Fleet Rebalancing Sprint (Week 2-6) → Click for details
69 branches operate below 20% utilization with $319.4M in surplus inventory. Meanwhile, 63 branches exceed 70% utilization and are capacity-constrained.
Transfer FROM (Surplus)
Great Lakes CC (16.4% util)
B&H Athens (0.0% util)
Toronto F&S (12.4% util)
Transfer TO (Constrained)
Auburn (100.0% util)
CLAC (99.9% util)
Pascagoula (99.9% util)
Actions: (1) Match surplus branches with constrained branches by category
(2) Prioritize Scaffolding System, Universal, Shoring — highest demand categories
(3) Execute transfers for items with >$1K unit value and >30 days idle
Target: Improve fleet utilization from 44.4% → 52% (+8pp) through $95.8M in strategic transfers
Target: Improve fleet utilization from 44.4% → 52% (+8pp) through $95.8M in strategic transfers
$95.8M
3
Rate Card Harmonization (Week 4-8) → Click for details
20 items worth $5.2M have >50% rate spread across regions — same equipment priced differently, creating margin leakage and customer confusion.
Highest Spread Items
5933% spread
4400% spread
2900% spread
Actions: (1) Audit rate cards for top 25 items by spread %
(2) Implement 4-zone pricing: Metro, Urban, Rural, Remote
(3) Set floor rates at 80% of highest-performing region
Target: Reduce rate spread from >50% to <20% on top 100 SKUs — capture estimated 5-8% margin improvement
Target: Reduce rate spread from >50% to <20% on top 100 SKUs — capture estimated 5-8% margin improvement
$5.2M
4
System Consolidation Roadmap (Week 6-12) → Click for details
20 items worth $6.1M are tracked across multiple ERPs (Profield, BAS, AGF, ORACLE) with >20% cost variance — a hidden procurement tax.
Highest Cost Variance Items
4030900% cost spread
492900% cost spread
9520% cost spread
Actions: (1) Designate system of record per category (Profield for scaffolding, BAS for formwork)
(2) Standardize allocation costs to lowest-cost source
(3) Build unified inventory dashboard across ERPs
Target: Single source of truth for top 200 SKUs — reduce procurement variance by 15%
Target: Single source of truth for top 200 SKUs — reduce procurement variance by 15%
$6.1M
5
Dead Capital Liquidation (Week 8-12) → Click for details
30 branch-category positions with >60% yard idle rate, totaling $161.2M in dead capital (7.9% of fleet).
Highest Dead Capital Positions
B&H Athens / Construction Elevat…
$22.3M idle
SA Carlstad / Construction Elevat…
$14.8M idle
Houston F&S / Formwork Accessories
$8.9M idle
Actions: (1) Physical audit of items idle >90 days
(2) Triage: transfer to high-demand branch, list for resale, or write-off
(3) Set quarterly fleet review cadence with branch managers
Target: Redeploy or liquidate 30% of dead capital (61,220,499 × 0.30 = recovery target)
Target: Redeploy or liquidate 30% of dead capital (61,220,499 × 0.30 = recovery target)
$161.2M
90-Day Financial Impact Summary
Trapped Capital Recovery
$55.5M
40% target = 5528456 recovery
Rebalancing Value
$95.8M
From 69 surplus branches
Dead Capital Liquidation
$161.2M
30% target from 30 positions
Total Non-Earning
$62.8M
3.1% of $2.0B fleet