IT Asset Lifecycle & Refresh Planning: Laptops, TCO & Replacement Cycles

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Add each laptop's age in months, its warranty end date and a warranty status to the asset register, then count the devices that are out of warranty and past the refresh age.
• 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.
• Build the 4-year total cost of ownership of a standard laptop: expected repair and downtime cost per year, the running cost, and the TCO per device per year.
• Calculate, for every possible refresh age, the present value of owning a laptop and its equivalent annual cost, chart the curve and read off the best refresh cycle.
• Compare buying laptops with a 36-month lease that includes support: the present value of each option per device, the equivalent monthly cost and the yearly saving for all 500 laptops.
• Turn the register's purchase years into a 4-year refresh plan: laptops due each year, the price per laptop with inflation, the budget per year and the overdue backlog.
• Calculate what a batch of retired laptops brings back after data wipe, logistics and recycling costs, by age group and per laptop.
• Spread a laptop's embodied CO2e over different refresh cycles, add the use phase, scale it to the fleet and price the CO2e saved by moving from a 4- to a 5-year cycle.