RFP 4007 - Attachment I - Vehicle Financial Summary 02.21.18.xlsx

This Vehicle Financial Summary document is an attachment supporting a Request for Proposal (RFP 4007) for commercial property and casualty insurance services for a Wisconsin school district. The document provides a comprehensive inventory of the district's fleet assets, including approximately 150 vehicles and equipment currently in service and on lease. The fleet comprises a diverse range of assets including dump trucks, cargo vans, food service vehicles, tractors, mowers, pickup trucks, trailers, and specialized equipment such as skid loaders and chippers. The vehicles are distributed across multiple departments including Grounds, Building Services, Maintenance, Food Services, Mail Services, and various specialty shops such as HVAC, Plumbing, and Electrical. The assets are stored and operated at multiple locations throughout the district, with some vehicles designated for specific plow routes. Many vehicles are actively in service with recorded mileage, while others are pending operational status.

The financial summary details initial purchase prices, maintenance costs as of September 2016, replacement values, and projected five-year lease payments for each asset. Initial prices range from approximately $6,576 for a John Deere tractor to $102,079 for a Ford F750 food service vehicle, with total fleet replacement values reaching over $4 million. The document indicates maintenance cost allocations and prioritizes vehicles for replacement based on age, condition, and operational necessity, with priority rankings from 1 to 59 assigned to assets under lease schedules. The summary provides critical valuation data necessary for underwriting commercial property and casualty insurance coverage, enabling the insurance provider to assess total insurable values, coverage limits, and premium calculations for the district's extensive mobile and stationary equipment fleet.