IT Asset Lifecycle & Refresh Planning: Laptops, TCO & Replacement Cycles
Track laptop age and warranty with DATEDIF and EDATE, measure failure rates by age, build TCO per device, find the best refresh cycle by equivalent annual cost, compare lease and buy, budget refreshes by year, price disposal and weigh longer life against CO2, every cell checked. Fictional 500-person company, illustrative figures.
The first lesson is free — no account needed.
About this course
An IT asset lifecycle course that plans the laptop fleet of one fictional 500-person company in a spreadsheet, for IT asset managers, IT and procurement leads, finance business partners and IT management students. You add device age and warranty status to the asset register with DATEDIF and EDATE, normalise repair tickets per 100 devices by age year and chart the rise, build the total cost of ownership per laptop per year including repairs and downtime, find the refresh cycle with the lowest equivalent annual cost, compare buying with a 36-month lease by present value and equivalent monthly cost, turn purchase years into a refresh budget by year with inflation and the overdue backlog, net resale value against data-wipe and recycling costs, and weigh a longer device life against embodied CO2e per laptop. Fictional company, illustrative figures. The first lab is free.
Lessons
- Asset Register: Age & Warranty Status with DATEDIF and EDATEFree
- Failure Rates by Age: Repair Tickets per 100 Devices Pro
- TCO per Device per Year: Purchase, Support, Repairs & Downtime Pro
- Optimal Refresh Cycle: the Minimum Equivalent Annual Cost Pro
- Lease vs Buy for Laptops: PV and Equivalent Monthly Cost Pro
- Refresh Budget by Year: Devices Reaching the Refresh Age Pro
- Disposal & Residual Value: Resale, Data Wipe and Recycling Costs Pro
- Sustainability: Extending Laptop Life vs CO2 per Device Pro