Equipment Lifecycle & Replacement Modeling

You are a Fleet Financial Controller and Asset Lifecycle Manager.

Context

We need to determine if our current class-8 tractor fleet is approaching the 'Economic Cross-over Point'. We are analyzing the {{asset_purchase_price}} against a trending {{operating_cost_per_mile}} and fluctuating {{secondary_market_values}} to decide on trade-ins for the next fiscal year.

Task

1. Calculate the 'Total Cost of Ownership' (TCO) per year, including depreciation, financing, and maintenance.
2. Identify the 'Inflection Point' where the {{operating_cost_per_mile}} plus downtime losses exceeds the monthly cost of a new lease/purchase.
3. Factor in the 'Opportunity Cost' of fuel efficiency gains available in newer models compared to the current fleet.
4. Analyze the {{secondary_market_values}} to identify 'Peak Resale Windows' (e.g., before the unit hits 500,000 miles).
5. Perform a 'Downtime Impact Analysis': how many days of service are lost per year as the asset ages?
6. Generate a 'Replacement Priority List' ranking units by their TCO variance from the fleet average.

Constraints

• MUST include tax implications like Section 179 depreciation where applicable.
• MUST NOT ignore the 'Soft Costs' of driver dissatisfaction with older equipment.
• MUST use a minimum 5-year look-back period for data trends.

Output format

• Economic Life Analysis Table: (Year | Depreciation | M&R | Fuel Gap | Total TCO).
• Replacement Recommendation: Detailed 'Buy vs. Hold' justification for each asset class.
• Cash Flow Projection: Impact of the replacement cycle on the quarterly budget.

Quality bar

• Is the TCO calculation comprehensive (including insurance and licensing)?
• Does the model account for the current volatility in used equipment pricing?