THE FLEET MANAGER'S PLANNING HANDBOOK

Take Control of Fleet Costs, Vehicle Utilization, and Daily Operations

10 Auto-Calculating Excel Tools. 40 Practical Chapters. 50 Realistic Planning Scenarios. One Complete Fleet Management Toolkit.

Managing a fleet involves more than tracking vehicles and recording fuel expenses.

You need to know which vehicles are profitable, what each kilometre costs, when maintenance is due, which documents are expiring, how effectively your fleet is being utilized, and where operational problems are affecting performance.

When these details are scattered across spreadsheets, paper records, and messages, it becomes harder to make confident decisions.

The Fleet Manager's Planning Handbook and Fleet Operations Pack bring these activities together in one practical management toolkit.

Get 10 connected Excel tools, a sample-data workbook, and a comprehensive planning handbook that explains the methods behind the numbers and shows how to apply them through 50 worked scenarios.

Know Your Costs. Improve Utilization. Manage Your Fleet with Confidence.

GET THE COMPLETE FLEET MANAGEMENT TOOLKIT — $10.99

Digital download · Two Excel workbooks · Interactive planning handbook

YOUR FLEET SHOULD TELL YOU WHETHER IT IS MAKING MONEY

Every vehicle generates costs. Every trip produces revenue or fulfills an operational requirement. Every maintenance event affects availability. Every idle day represents an opportunity to investigate how effectively your assets are being used.

But recording this information is not enough. You need a system that helps you understand what it means.

The Fleet Operations Pack turns your routine fleet records into a more organized view of operational and financial performance.

Track revenue, fuel, maintenance, driver expenses, vehicle utilization, insurance, permits, and monthly profitability through connected tools and a centralized dashboard.

Then use the Fleet Manager's Planning Handbook to understand the decisions behind those numbers.

Three Questions Every Fleet Manager Should Be Able to Answer

What does each vehicle cost to operate?

Calculate cost per kilometre using relevant expenses, including fuel, maintenance, insurance, driver pay, and lease or finance costs.

Which trips and vehicles are contributing to profitability?

Review trip revenue, operating expenses, margins, vehicle utilization, and monthly fleet performance.

What needs attention right now?

Identify overdue maintenance, upcoming document renewals, loss-making trips, open repairs, and vehicles with low utilization.

The goal is to replace guesswork with a clearer, more structured view of fleet operations.

10 EXCEL TOOLS TO MANAGE YOUR FLEET

The Fleet Operations Pack includes 10 practical tools designed to support common fleet-management activities.

1. Vehicle Register

Maintain a central record of your vehicles, including identification details, make and model, registration, odometer, status, home base, purchase date, and purchase cost.

The register serves as the main reference point for connected tools.

2. Trip and Revenue Log

Record trip revenue alongside fuel, driver pay, tolls, and other operating costs.

Review trip-level profit and margin, with an automatic loss indicator to help flag trips that require further investigation.

3. Fuel and Mileage Log

Record fuel purchases and odometer readings to monitor fuel efficiency and cost per kilometre.

Use the resulting information to identify unusual consumption patterns and investigate possible causes.

4. Maintenance Planner

Monitor preventive maintenance using distance-based and calendar-based intervals.

Review remaining kilometres, days until service, and status indicators for overdue or upcoming maintenance.

5. Repair and Downtime Log

Record breakdowns, workshop visits, parts, labour, repair costs, and days off the road.

Build a clearer picture of maintenance expenditure and vehicle availability.

6. Cost per KM Analyzer

Review monthly vehicle operating costs, including fuel, maintenance, driver pay, insurance, lease or finance payments, and other expenses.

Calculate cost per kilometre and examine how fixed and variable costs contribute to your operating cost structure.

7. Driver and Compliance Register

Maintain relevant driver and document information, including licence details, expiry dates, medical due dates, assigned vehicles, and contact information.

Use expiry indicators to help prioritize administrative follow-ups.

8. Insurance and Permits Tracker

Organize insurance renewals, road tax, inspections, and other relevant renewal dates.

Review upcoming deadlines and identify documents that need attention.

9. Utilization Tracker

Compare available days with days spent on trips and in the workshop.

Review idle days, utilization percentage, revenue, and revenue per working day to identify vehicles that may require operational review.

10. Monthly Fleet P&L

Consolidate monthly revenue and major fleet expenses into a financial overview.

Review profit, margin, year-to-date totals, and stronger or weaker months to support more informed fleet planning.

A DASHBOARD THAT SHOWS WHAT NEEDS ATTENTION

The included dashboard brings key fleet indicators together in one place.

Review eight headline measures:

• Total fleet size.
• Active vehicles.
• Year-to-date revenue.
• Year-to-date margin.
• Average cost per kilometre.
• Average vehicle utilization.
• Overdue maintenance count.
• Upcoming renewals and expiring documents.

The dashboard also provides a directory of the 10 tools, with counts highlighting items that may require attention.

This gives you a convenient starting point for your daily or weekly fleet review without having to inspect every worksheet individually.

The dashboard reflects the information entered into the workbook. Accurate results depend on maintaining complete and correct records.

TWO WORKBOOK EDITIONS — START FROM SCRATCH OR LEARN BY EXAMPLE

Your purchase includes two editions of the Fleet Operations Pack.

Blank Edition

Ready for your own fleet data.

Enter your vehicle details, trips, fuel purchases, repairs, driver information, and expenses to begin organizing your fleet operations.

Sample-Data Edition

Explore a populated demonstration fleet with 50 vehicles, 12 drivers, 40 trips, fuel records, repair jobs, and a 12-month profit-and-loss view.

The sample workbook demonstrates how the tools, calculations, and dashboard indicators work together.

Use it to understand the workflow before entering your own information.

The sample data is illustrative and should not be interpreted as actual fleet performance or a forecast of your business results.

THE PLANNING HANDBOOK: KNOW WHAT TO DO WITH THE NUMBERS

A spreadsheet can calculate costs, but good fleet management also requires a sound operational process.

The Fleet Manager's Planning Handbook complements the Excel tools with structured guidance on planning, dispatch, cost control, utilization, performance measurement, and operational problem-solving.

40 Chapters Across Six Parts

Explore the fundamentals of fleet planning, daily dispatch operations, cost and efficiency, fleet optimization, performance management, and practical planning templates.

Each chapter is designed to connect operational decisions with the information needed to make them.

13 Reusable Planning Templates

Learn how to structure common fleet-planning activities, with templates defined field by field so you can understand the information each process requires.

50 Worked Planning Scenarios

Explore practical situations such as:

• A capacity shortage against the next day's workload.
• A vehicle breakdown shortly before dispatch.
• A driver calling in sick when priority loads are scheduled.
• A vehicle consistently operating with low load utilization.
• A maintenance issue affecting fleet availability.
• Operational decisions that require balancing cost, capacity, and service commitments.

Each scenario provides a structured way to examine the situation, determine the appropriate response, and connect the decision to the relevant handbook chapters and templates.

The purpose is to help you develop a repeatable approach to fleet-management problems rather than relying entirely on instinct or last-minute decisions.

WHO IS THIS TOOLKIT FOR?

Owner-Operators and Small Fleet Businesses

Understand vehicle operating costs, trip profitability, maintenance requirements, and fleet utilization in a more organized way.

Fleet Managers and Supervisors

Bring vehicle records, expenses, maintenance schedules, compliance dates, and performance indicators into a connected workflow.

Transport Operators and Dispatch Teams

Evaluate trip economics, monitor vehicle availability, and organize operational planning.

Logistics and Distribution Managers

Develop a clearer view of fleet performance and how transportation assets contribute to service delivery and operating costs.

Finance and Operations Teams

Use consistent cost definitions and monthly summaries to support budgeting, performance reviews, and operational discussions.

Consultants and Fleet Trainers

Use the handbook's worked scenarios and planning templates to support fleet-management learning and process reviews.

The workbook is preformatted for 50 vehicles, making it a practical starting point for smaller fleets. Additional rows can be added by extending the formulas as needed.

DESIGNED FOR PRACTICAL, EVERYDAY USE

Connected Vehicle Information

Enter vehicle details once in the register and use the linked information across supported tools.

Automatic Calculations

Reduce repetitive calculations for supported metrics such as trip profit, fuel efficiency, cost per kilometre, and utilization.

Maintenance and Renewal Alerts

Use status indicators to identify upcoming service requirements and expiring documents.

Financial and Operational Visibility

Review trip-level performance alongside monthly fleet costs and revenue.

A Working Demonstration

Explore the sample-data edition to see the calculations and dashboard before using your own data.

Flexible Spreadsheet Compatibility

The workbooks are designed for use with Microsoft Excel, Google Sheets, and LibreOffice. Some formatting or formula behavior may vary by application.

No Macros Required

The workbooks do not rely on macros, so you do not need to enable macro execution to use the spreadsheet tools.

WHAT YOU RECEIVE

Your purchase includes:

• Fleet Operations Pack — blank Excel workbook.
• Fleet Operations Pack — sample-data Excel workbook.
• 10 fleet-management tools.
• A centralized dashboard with eight key performance indicators.
• A 40-chapter Fleet Manager's Planning Handbook.
• Six structured learning sections.
• 13 reusable planning templates.
• 50 worked fleet-planning scenarios.
• A Read Me sheet explaining the workbook workflow, status colors, row limits, and operating tips.

PRODUCT: The Fleet Manager's Planning Handbook + Fleet Operations Pack

PRICE: $10.99

FORMAT: Two Excel workbooks (.xlsx) and one HTML handbook.

DELIVERY: Digital download through Payhip.

The handbook opens in a compatible web browser and can be printed to A4. No separate fleet-management subscription is required.

FREQUENTLY ASKED QUESTIONS

Do I need to install special software?

No dedicated installation is required. Download the Excel workbooks and HTML handbook. A compatible spreadsheet application and web browser are needed to use them.

Can I use the tools with my own vehicles?

Yes. The blank edition is designed for your own fleet records. Keep a backup before making significant changes to formulas or layouts.

How many vehicles can the workbook handle?

The workbook is preformatted for 50 vehicles. You can extend it by inserting additional rows and copying the appropriate formulas and formatting.

Does the dashboard update automatically?

The dashboard uses built-in formulas to reflect the data entered in the workbook. It is not connected to live vehicle telematics, fuel cards, GPS systems, or external fleet software.

Can I use my local currency?

Yes. The financial fields use numerical values that can be adapted to your currency and preferred display format.

Is the sample fleet real?

No. The sample-data edition is a demonstration dataset intended to show how the workbook operates.

Does this replace a fleet-management system?

No. It is a standalone spreadsheet-based toolkit for organizing and analyzing fleet information. It does not provide live GPS tracking, automated vehicle data feeds, or integrations with external systems.

Can I use this for client work?

The product licence permits use for your own business and client work. Reselling or redistributing the original files is not permitted.

BUILD A FLEET THAT YOU CAN MEASURE AND MANAGE

Effective fleet management starts with knowing your numbers and understanding the operational decisions behind them.

Which vehicles are profitable? What does each kilometre cost? Where is capacity being underused? Which maintenance tasks or renewals need attention? What should be prioritized tomorrow?

The Fleet Operations Pack helps organize the data. The Fleet Manager's Planning Handbook helps you understand the methods and decisions behind it.

Together, they provide a practical foundation for managing fleet costs, improving visibility, and making more informed operational decisions.

GET THE COMPLETE FLEET MANAGEMENT TOOLKIT TODAY

ONLY $10.99

10 Excel tools · 40 handbook chapters · 50 worked scenarios · 13 planning templates

Important Disclaimer: This toolkit is intended for operational planning and educational use. Financial calculations depend on the accuracy and completeness of the data entered. Maintenance, driver licensing, insurance, and regulatory requirements should always be verified against applicable local rules and professional guidance.