AlexanderData Solutions
Live

WIP Command Center

Where your cash is sitting — by shop, by age bucket.

AI Summary
Generated from fleet data · ~2.3s · claude-4.7-opus✨ AI

Total cash sitting in shops

$450K

Across 181 open repair orders

0-7 days

171

$426K at risk

8-14 days

10

$24K at risk

15-30 days

0

$0K at risk

30+ days

0

$0K at risk

WIP heatmap
Shops × age buckets
Shop0-7 d8-14 d15-30 d30+ d
Phoenix West
10
1
0
0
Phoenix North
16
0
0
0
Tucson Central
10
1
0
0
Dallas North
17
2
0
0
Dallas South
17
0
0
0
Houston East
5
0
0
0
Austin West
11
1
0
0
Denver Metro
6
0
0
0
Salt Lake Central
8
0
0
0
Las Vegas Strip
10
1
0
0
Albuquerque
17
0
0
0
Oklahoma City
8
0
0
0
Tulsa
12
1
0
0
San Antonio
10
0
0
0
Amarillo
14
3
0
0
Oldest open ROs
Top 25 longest-open
RO #ShopCarrierStatusDays OpenEst. Revenue
ro-013836Las Vegas StripState Farmestimate8.7$2K
ro-013842TulsaGeicoin progress8.6$2K
ro-013848AmarilloState Farmestimate8.6$2K
ro-013823Dallas NorthGeicoestimate8.4$2K
ro-013851Phoenix WestGeicoqa7.7$2K
ro-013870Austin WestGeicoin progress7.6$3K
ro-013857Tucson CentralGeicoqa7.5$3K
ro-013859Dallas NorthState Farmestimate7.4$4K
ro-013877AmarilloLiberty Mutualestimate7.4$2K
ro-013880AmarilloAllstatewaiting parts7.3$2K
ro-013889Houston EastAllstatewaiting parts6.7$2K
ro-013883Tucson CentralUSAAestimate6.7$2K
ro-013887Dallas SouthState Farmestimate6.7$3K
ro-013901San AntonioNationwidewaiting parts6.7$3K
ro-013898TulsaState Farmestimate6.6$2K
ro-013890Houston EastState Farmwaiting parts6.5$1K
ro-013894AlbuquerqueProgressiveqa6.5$2K
ro-013895AlbuquerqueNationwideqa6.5$2K
ro-013888Dallas SouthState Farmwaiting parts6.5$3K
ro-013892Salt Lake CentralProgressiveqa6.5$3K
ro-013886Dallas NorthUSAAwaiting parts6.4$2K
ro-013891Denver MetroState Farmestimate6.4$3K
ro-013897Oklahoma CityState Farmestimate6.4$1K
ro-013916Austin WestState Farmqa5.7$3K
ro-013913Dallas NorthState Farmqa5.6$3K