AVIS

Fleet Management System

DNS ICS Performance Analytics Dashboard

Fleet Mgmt

Excel Metrics: Start/Idle

● Operational

James - Your Daily Actions Are Ready

5 critical actions will generate +$485K this week

Actions Today

4hrs

Time Needed

$485K

Revenue Impact

NOW

Start Time

FLEET SIZE

16.9K

Total vehiclescomplete

LOCATIONS

CO & WYregions

UTILIZATION

78.5%

↑ 3.2%efficiency

START/IDLE

18 Critical

< 1.0 rationeed vehicles

NEW: Complete 16-Metric Optimization Engine

Now using ALL DNS ICS Excel metrics for comprehensive fleet optimization

Start/Idle (25%)Utilization (15%)Revenue (15%)+ 13 More

Total Fleet Inventory - August 19, 2025

442

Total vehicles across all locations

LOCATIONS ACTIVE

All operational

VEHICLE CLASSES

F through XZ

AVG PER LOCATION

442 ÷ 17 locations

DAILY RECORDS

7,072

17×26×16 metrics/day

Fleet Size & Data Processing

Fleet: 16,922 total vehicles across 17 locations × 26 classes. Daily data: 16,922 vehicles × 16 metrics = 270,752 data points tracked per day

Critical Start/Idle Ratios - 7 Day Analysis (Problem Areas Only)Critical Start/Idle Ratios

Showing vehicles with Start/Idle ratio ≤ 1.0 requiring immediate attention | Data from DNS ICS Excel importVehicles with ratio ≤ 1.0

● ≤1 Critical● 3-5 Warning● >5 Good

≤1 Critical3-5 Warning>5 Good

Location	Class	Daily Start/Idle Ratios							Avg	Required Action
Location	Class	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Avg	Required Action
Denver APODenver	F	0.68	0.81	0.82	0.75	0.92	1.10	0.95	0.86	To: EGE APO
Denver APODenver	H	0.69	0.72	0.78	0.85	0.91	0.96	0.99	0.84	To: DEN DT
Denver APODenver	K	0.81	0.85	0.89	0.93	0.97	1.01	1.05	0.93	To: EGE APO
Denver APODenver	L	0.82	0.86	0.89	0.92	0.95	0.98	1.02	0.92	To: DEN DT
Denver APODenver	XA	0.89	0.92	0.95	0.98	1.01	1.04	1.07	0.98	To: ASE APO
Denver APODenver	XK	0.53	0.56	0.59	0.62	0.65	0.68	0.71	0.62	To: DEN DT
Denver APO ADenver A	P	0.81	0.84	0.87	0.90	0.93	0.96	0.99	0.90	To: DEN DT
Denver APO ADenver A	XD	0.84	0.87	0.90	0.93	0.96	0.99	1.02	0.93	To: DEN DT
Denver APO ADenver A	XG	0.67	0.70	0.73	0.76	0.79	0.82	0.85	0.76	To: ASE APO
Denver APO BDenver B	L	0.74	0.77	0.80	0.83	0.86	0.89	0.92	0.83	To: ASE APO
Denver APO BDenver B	V	0.79	0.82	0.85	0.88	0.91	0.94	0.97	0.88	To: ASE APO
Denver APO BDenver B	W	0.84	0.87	0.90	0.93	0.96	0.99	1.02	0.93	To: ASE APO
Denver APO BDenver B	XA	0.68	0.71	0.74	0.77	0.80	0.83	0.86	0.77	To: ASE APO
Denver APO BDenver B	XC	0.90	0.93	0.96	0.99	1.02	1.05	1.08	0.99	To: ASE APO
Denver APO BDenver B	XH	0.90	0.93	0.96	0.99	1.02	1.05	1.08	0.99	To: DEN DT
COS APOCOS	V	0.81	0.84	0.87	0.90	0.93	0.96	0.99	0.90	To: ASE APO
COS APOCOS	W	0.67	0.70	0.73	0.76	0.79	0.82	0.85	0.76	To: ASE APO
COS APOCOS	XD	0.67	0.70	0.73	0.76	0.79	0.82	0.85	0.76	To: EGE APO
COS APOCOS	XG	0.62	0.65	0.68	0.71	0.74	0.77	0.80	0.71	To: ASE APO
COS APOCOS	XH	0.52	0.55	0.58	0.61	0.64	0.67	0.70	0.61	To: EGE APO
COS LMCOS LM	G	0.70	0.73	0.76	0.79	0.82	0.85	0.88	0.79	To: DEN DT
COS LMCOS LM	L	0.73	0.76	0.79	0.82	0.85	0.88	0.91	0.82	To: DEN DT
COS LMCOS LM	P	0.57	0.60	0.63	0.66	0.69	0.72	0.75	0.66	To: ASE APO
COS LMCOS LM	W	0.58	0.61	0.64	0.67	0.70	0.73	0.76	0.67	To: DEN DT
COS LMCOS LM	X	0.61	0.64	0.67	0.70	0.73	0.76	0.79	0.70	To: ASE APO
COS LMCOS LM	XF	0.60	0.63	0.66	0.69	0.72	0.75	0.78	0.69	To: EGE APO
COS LMCOS LM	XG	0.68	0.71	0.74	0.77	0.80	0.83	0.86	0.77	To: DEN DT
COS LMCOS LM	XH	0.51	0.54	0.57	0.60	0.63	0.66	0.69	0.60	To: DEN DT
DEN DTDEN DT	F	0.51	0.54	0.57	0.60	0.63	0.66	0.69	0.60	To: EGE APO
DEN DTDEN DT	L	0.80	0.83	0.86	0.89	0.92	0.95	0.98	0.89	To: EGE APO
DEN DTDEN DT	P	0.70	0.73	0.76	0.79	0.82	0.85	0.88	0.79	To: DEN DT
DEN DTDEN DT	S	0.82	0.85	0.88	0.91	0.94	0.97	1.00	0.91	To: EGE APO
DEN DTDEN DT	XD	0.80	0.83	0.86	0.89	0.92	0.95	0.98	0.89	To: DEN DT
DEN DTDEN DT	XG	0.61	0.64	0.67	0.70	0.73	0.76	0.79	0.70	To: DEN DT
DT HUBDT	K	0.87	0.90	0.93	0.96	0.99	1.02	1.05	0.96	To: EGE APO
DT HUBDT	S	0.87	0.90	0.93	0.96	0.99	1.02	1.05	0.96	To: EGE APO
DT HUBDT	W	0.78	0.81	0.84	0.87	0.90	0.93	0.96	0.87	To: ASE APO
DT HUBDT	XE	0.90	0.93	0.96	0.99	1.02	1.05	1.08	0.99	To: ASE APO
DT HUBDT	XG	0.78	0.81	0.84	0.87	0.90	0.93	0.96	0.87	To: EGE APO
DT HUBDT	XH	0.54	0.57	0.60	0.63	0.66	0.69	0.72	0.63	To: EGE APO

Data Analysis Summary

Total Records Expected:13,280

Calculation:17 × 26 × 16 × 30

Date Range:7/23/2025 - 8/21/2025

Last Update:5:27:49 AM

Critical Locations: 8Critical: 8

Immediate transfers required

Target: Same-day action

Problem Classes: 41Problems: 41

Schedule optimization within 48hrs

Monitor daily trends

Potential Savings: $48.5KSave: $48.5K

Weekly savings from optimization

ROI: 312% annually

Efficiency Target: 85%Target: 85%

Current: 78.5% utilization

Gap: 6.5% improvement needed

Fleet Distribution

Denver

87%

Denver APO: 53 vehicles • 87% utilization

Denver A

66%

Denver APO A: 48 vehicles • 66% utilization

Denver B

83%

Denver APO B: 17 vehicles • 83% utilization

COS

61%

COS APO: 49 vehicles • 61% utilization

COS LM

83%

COS LM: 18 vehicles • 83% utilization

DEN DT

89%

DEN DT: 52 vehicles • 89% utilization

82%

DT HUB: 15 vehicles • 82% utilization

South

61%

South HUB: 28 vehicles • 61% utilization

North

67%

North HUB: 16 vehicles • 67% utilization

Wyoming

91%

Wyoming: 25 vehicles • 91% utilization

DEN MT

90%

DEN MT: 53 vehicles • 90% utilization

EGE

72%

EGE APO: 50 vehicles • 72% utilization

GJT

85%

GJT APO and LM: 52 vehicles • 85% utilization

HDN

71%

HDN APO: 16 vehicles • 71% utilization

ASE

66%

ASE APO: 42 vehicles • 66% utilization

MTJ

71%

MTJ APO: 45 vehicles • 71% utilization

GUC

81%

GUC APO: 44 vehicles • 81% utilization

Low (<70%)<70%

Medium (70-80%)70-80%

High (80-90%)80-90%

Critical (>90%)>90%

Immediate Revenue OpportunitiesRevenue Actions

Potential This Week

+$485K

$125K

Weekend Surge Pricing

25% price increase Fri-Sun

Impact: 312 rentalsDeploy: 2 hoursSuccess: 92%

$95K

Fleet Rebalancing

Move 85 vehicles immediately

Vehicles: 85Routes: 4ROI: 3.2x

$85K

Lost Reservations

SMS/email to 423 cancellations

Targets: 423Convert: 35%Instant

$75K

Corporate Accounts

3 contracts ready to sign

Companies: 3Monthly: 125 rentals12-month

$105K

Counter Hertz 20%

Match loyalty discount

Protect: 185 bookingsMargin: 18%Win rate: 78%

Actions

Impact

+$485K

Time

4 hrs

Critical Idle Rate Intelligence - Executive Action Required

AI Analysis: 47% of locations experiencing critical idle rates (>35%) | $2.3M weekly revenue at risk

8 Locations Critical

AI Pattern Recognition - Critical Findings

TUESDAY CRISIS PATTERN

11 locations hit >35% idle

Corporate travel gap identified

Lost revenue: $385K

WEEKEND WASTE PATTERN

Saturday: 41% avg idle rate

Pricing too high for leisure

Lost revenue: $520K

LOCATION IMBALANCE

DEN locations: 38% vs 21%

Mountain resorts underserved

Opportunity: $290K

ACTION 1Tuesday Corporate Blitz

Deploy NOW for next Tuesday

+$385K

• Launch B2B flash sale: 30% off+145 rentals

• Corporate direct outreach+89 rentals

• Transfer 65 vehicles to airports+78 rentals

ACTION 2Weekend Revenue Capture

Price optimization for leisure

+$520K

• Reduce weekend rates 25%+198 rentals

• Family package deals+167 rentals

• Social media campaign+125 rentals

Location-Specific Emergency Actions (Based on Heatmap Analysis)

Denver APO

Avg idle: 37%

Transfer out: 45 units

GUC APO

Avg idle: 38%

Price cut: 30%

ASE APO

Avg idle: 31%

Add premium: 25 units

DEN DT

Avg idle: 29%

Corporate push needed

Total Weekly Revenue Recovery Potential:

Based on reducing idle rates to industry standard 15%

+$2.3M

QUICK ACTIONS

PROFIT LEAKAGE ALERTS

Turndown Rate18% ⚠️

Lost revenue: $145K/week

No-Show Rate12% ⚠️

Lost revenue: $92K/week

Below Market Rate23% fleet

Revenue gap: $178K/week

Total Weekly Leakage:-$415K

TOP PERFORMING LOCATIONS

#1Denver APO

$892K+12%

#2DEN DT

$756K+8%

#3ASE APO

$634K+15%

#4EGE APO

$589K+6%

#5HDN APO

$512K+9%

DNS ICS Excel Data Processing Statistics - 30 Day Summary

LOCATIONS

Active Sites

VEHICLE CLASSES

F to XZ

METRICS

Per Class

DATE RANGE

Days

TOTAL RECORDS

13,280

17×26×16×30 = 211,680 cells

Formula: Locations (17) × Vehicle Classes (26) × Metrics (16) × Days (30) = 211,680 data points

Processing 3528 data points per minute | Last sync: 8/21/2025, 5:27:49 AM

System Online

Last Sync: 8/21/2025, 5:27:49 AM

Data Points: 39,780

Quick Navigation

Vehicle Inventory

AI Analytics

Start/Idle

Reports

Upload Excel

Executive Reports

Settings