₦airaland Forum

The Vehicle Maintenance Solution is a user
friendly Spreadsheet designed to assist with logging & tracking Maintenance Activities | Fuel Purchases for multiple Vehicles.

Who needs this?
This is useful for commercial fleet businesses who operate & maintain multiple vehicles.

Every time you repair or have maintenance work done on a Vehicle it's important to document it:

- Which Vehicle from your fleet
- What the repair entailed
- How much you spent
- Who performed the repair activity

Keeping this maintenance log is very important as it helps you measure the cost of owning the vehicle - the profitability or otherwise.

Features:

1) Vehicle Database:
Create a Register for all Vehicle with fields to store Model, Brand, VIN Number, Plate Number, etc.

2) Maintenance Log:
Log repair work performed on an individual Vehicle:
- Repair Date
- Repair Part: Air Filters, Brakes, Coolant Levels, Engine, etc.
- Technician
- Cost

3) Fuel Purchase Log:
Track Fuel expenses by Vehicle - Daily Purchases & Generate Monthly Summary.

Add On Features:
1) Preventive Maintenance (PM):

Prepare a PM Schedule for each Vehicle. It’s easy to forget when your next oil change is due when you manage multiple vehicles, this feature enables you :
- Define frequency of Routine Service (Oil Change, Plug Change, etc.)

E.g. Change oil every 2 months.

- Generate Monthly PM Reminder Calendar
- Document Defects and Pending Repairs

2) Vehicle & License Renewals

- Assign Drivers to Vehicles
- Track Driver Licence Renewals
- Generate Renewal Reminder Calendar
- Monitor Annual Vehicle Documents Renewals

Demo Video:

https://www.youtube.com/watch?v=-7PVuAd4_VU


Learn More:
http://www.designvat.com/Fleet-Management-Spreadsheet.html