Repair Data | Only models with >1,000 units sold showing in charts | All Models
✓ All models included • Only completed repairs (Order Received Date required) Unit Sales and Warranty Revenue are based on years only – Repairs are granular
-
Total Units Sold
-
Total Repairs
-
Overall Repair Rate
-
Total Repair Cost
-
Estimated Cost
-
Accidental Damage %
-
In Warranty %
-
Warranty Revenue
-
Repair Revenue (OOW)
-
Net Warranty P/L
🔧 Number of Repairs by Model (Highest to Lowest)
💡 Click on any bar to view detailed model information
💰 Repair Cost by Model
💡 Click on any bar to view detailed model information
🔧 Repair Type Distribution
💡 Click on any segment to view model breakdown
💥 Accidental vs Non-Accidental
💡 Click on any segment to view model breakdown
💵 Cost Breakdown by Repair Type
💡 Click on any segment to view model breakdown
⚠️ Accidental Damage Rate by Model (100+ repairs only)
💡 Click on any bar to view detailed model information
📋 Warranty Status Distribution
💡 Click on any segment to view model breakdown
💥 Accidental Damage Cost by Model (100+ repairs only)
💡 Click on any bar to view detailed model information
📋 Total Cost: In Warranty vs Out of Warranty
💡 Click on a segment to view model breakdown
🏷️ Warranty Repair Cost Distribution
💡 Click on a segment to view devices with that warranty code
💵 Repair Cost by Customer
💡 Click on a segment to view customer breakdown
🔍 Key Insights & Analysis
📊 Model Analysis Tables (click any box for details)
🏷️ Warranty Code Financial Summary (Revenue vs Cost by Warranty Code)
💡 Click on any bar to see all devices with that warranty code
Model
Item #
Units Sold
Total Repairs
Repair Rate
Cost
Model
Item #
Units Sold
Total Repairs
Repair Rate
Cost
Model
Item #
Total Repairs
Major
Minor
NPU/NPF
Actual Cost
Avg/Repair
Model
Item #
Total Repairs
Accidental
Non-Accidental
Accidental %
Model
Item #
Total Repairs
In Warranty
Out of Warranty
In Warranty %
Model
Repairs
Repair Cost
Warranty Rev
Repair Rev (OOW)
Net P/L
Model
Warranty Code
Units Sold
Sell Price
Repairs
Repair Cost
Warranty Rev
Repair Rev
Net P/L
Model ↕
Item # ↕
Units Sold ↕
Repairs ↕
Rate ↕
Major ↕
Minor ↕
NPU ↕
Accidental ↕
In Warranty ↕
Cost ↕
War. Rev ↕
Net P/L ↕
📋 Assumptions & Methodology▶
💰 Cost Calculations
Shipping cost: $10 added to each repair's actual cost only
Actual cost: "Costs" field from repair data + $10 shipping per repair
Estimated costs are based on repair type lookup (below) — shipping already included in estimates
Default estimated cost: $50 for any unlisted repair type
📦 Units Sold
Sourced from Sales CSV (Total Sales Qty), not from repair data
Filtered by date range (Year column in sales data)
Summed across all warranty codes per device
Models with ≤1,000 units sold are hidden from charts/tables (data still in KPI totals)
🔧 Repair Filtering
Only repairs with an Order Received Date are included
Rows with "No Match" for Model Name or Item Number are excluded
Date range filter applies to repair Order Received Date
All models included (no model exclusions)
💵 Revenue
Warranty Revenue: from Sales CSV (Total Sales column or Qty × Price)
Repair Revenue: from repair data "Repair Revenue" field (out-of-warranty)
Net P/L: Warranty Revenue + Repair Revenue − Actual Cost
📊 Repair Classification
NPU/NPF: repair name contains "NPU" or "NPF"
Major: "Major Repairs" field = "Yes" (and not NPU/NPF)
Minor: all other repairs
Accidental: "Accidental Damage" = "Yes" or "Liquid"
In Warranty: model-level count from repair data "In Warranty" field
🔖 Estimated Repair Costs
Estimated costs already include shipping — no additional $10 added