KWest Karz, LLC – Fleet Dashboard Metrics Specification - wwestlake/KwestKarz GitHub Wiki

📘 KWest Karz, LLC – Fleet Dashboard Metrics Specification

Overview

This specification outlines the key performance metrics and visual components to be implemented in the KWest Karz, LLC fleet management dashboard. The dashboard will provide real-time visibility into fleet operations, utilization, revenue, and maintenance status using data stored in the internal API and database system.


🎯 Tier 1: Core Operational Metrics

1. Fleet Utilization Status

  • Purpose: Display real-time vehicle availability
  • Metric Logic:
    • Green: Currently on trip
    • Yellow: Available for booking
    • Red: Idle > X days (e.g., 7+ days without booking)
  • Display: Stacked horizontal bar or donut chart

2. Total Monthly Earnings

  • Metric: Sum of earnings for all completed trips in the current calendar month
  • Display: Large KPI tile with trend sparkline

3. Utilization Rate

  • Metric: (Total Rented Days / Total Available Days) * 100
  • Granularity: Per vehicle and fleet-wide
  • Display: Table + heatmap coloring or radial gauge

4. Bookings (Week & Month)

  • Metric: Count of all trips starting in the current week/month
  • Display: KPI tiles with date range filters

5. Vehicles Below Target ROI

  • Logic: Flag vehicles where Cumulative Earnings < X% of Purchase Price
  • Display: List with progress bars toward ROI target

🛠️ Tier 2: Maintenance & Operations

6. Maintenance Due Soon

  • Trigger: Last service date + mileage
  • Logic: Due if > 5,000 miles since last oil change or > 6 months
  • Display: List view with due soon/overdue badges

7. Mileage Alerts

  • Metric: Vehicles approaching high mileage (e.g., 100K, 120K)
  • Use: Identify candidates for decommissioning
  • Display: Horizontal bar with threshold warnings

📈 Tier 3: Strategic Forecasting

8. Projected Monthly Revenue

  • Formula: Avg. Daily Rate × Projected Utilization Days
  • Forecast Input: Based on current booking trends
  • Display: Line chart or bar forecast graph

9. Top Performing Vehicles

  • Metric: Highest grossing vehicles this month
  • Display: Ranked cards or horizontal bar chart

10. Underperforming Vehicles

  • Metric: Lowest earning/utilized vehicles
  • Display: Side-by-side with top performers

💡 Optional Smart Metrics

Fleet Turnover Ratio

  • Metric: Total Revenue / Vehicle Purchase Price
  • Display: Ratio chart (greater than 1 = profitable)

Break-even Progress Meter

  • Metric: Revenue-to-cost percentage per vehicle
  • Display: Circular progress or segmented bar

Booking Gap Analysis

  • Metric: Average time between rentals
  • Display: Table with trend arrows

📌 Dashboard Components Summary

Metric Type Display Priority
Fleet Utilization Real-Time Status Stacked Bar High
Total Monthly Earnings KPI Tile + Sparkline High
Utilization Rate Efficiency Heatmap / Table High
Bookings Engagement KPI Tiles High
ROI Flags Financial Risk List View High
Maintenance Alerts Operational List Medium
Mileage Warnings Lifecycle Progress Bar Medium
Forecast Revenue Predictive Line Chart Medium
Top/Bottom Vehicles Performance Bar Charts Medium
Break-even Progress ROI Progress Circles Optional
Fleet Turnover Profitability Ratio Graph Optional
Booking Gaps Optimization Table Optional

✅ Next Steps

  • Review metric logic with dev team
  • Define API endpoints for each metric
  • Prioritize Tier 1 metrics for MVP dashboard
  • Wireframe UI layout and begin frontend integration