Failure Rates by Age: Repair Tickets per 100 Devices
This lesson is part of the course
In this lesson
You normalise repair tickets and hardware failures by the number of devices in each age year, calculate the fleet-wide rate and chart how repairs climb with age.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Asset Register: Age & Warranty Status with DATEDIF and EDATE Locked
- Failure Rates by Age: Repair Tickets per 100 Devices Locked
- TCO per Device per Year: Purchase, Support, Repairs & Downtime Locked
- Optimal Refresh Cycle: the Minimum Equivalent Annual Cost Locked
- Lease vs Buy for Laptops: PV and Equivalent Monthly Cost Locked
- Refresh Budget by Year: Devices Reaching the Refresh Age Locked
- Disposal & Residual Value: Resale, Data Wipe and Recycling Costs Locked
- Sustainability: Extending Laptop Life vs CO2 per Device Locked