See Inside the Products | TruckingToolCalc

Small Fleet Edition — $67

Buy this workbook

The Start Here tab that opens every workbook. A legend shows that blue-bordered cells are yours to type into, gray cells calculate on their own, and the yellow cell is your target. Below it, all seven Small Fleet tabs are listed with the question each one answers, plus a note that the numbers supplied are realistic examples to be replaced with your own. — Every workbook opens on this page: what each tab answers, how the cells work, and where to begin.

Per-Truck Cost Comparison tab with three trucks side by side costing 1.08, 1.13 and 1.14 dollars per mile against a fleet average of 1.12. Truck 1, an older truck with its loan nearly paid down, is named best performing truck at 1.08 per mile, meeting the operator's 1.10 target. — Three trucks side by side. The cheapest to run isn't always the one you'd guess.

Fleet Overview tab: four inputs, being 4 trucks, 76,500 dollars monthly revenue, 66,500 operating costs and 6,000 fixed overhead, produce 4,000 monthly profit, 1,000 profit per truck and a 5.2 percent fleet profit margin, which meets the 5 percent target. — Four numbers you already know, and what they say about the whole fleet.

Should We Take This Load tab: a 1,900 dollar load over 700 total miles taking 14 hours returns 481 dollars net profit, being 0.69 profit per mile and 34.36 dollars per hour. The 0.50 per-mile target is met but the 40 dollars per hour target is not, so the verdict is NO, below your target. — A load can look fine per mile and still be a poor use of your day. This checks both.

Truck Purchase & Lease Decision Calculator — $67

Buy this workbook

Total Cost of Ownership tab totalling a truck's full life cost at 405,029 dollars over 300,000 miles, combining purchase price, financing, fuel, maintenance, insurance and other costs less resale value. That works out at 1.35 dollars per mile, meeting the 1.50 target. — What a truck actually costs across its life, not the sticker price. The real number per mile.

Break-Even Mileage tab: 2,600 dollars a month of extra cost against 0.08 dollars per mile in savings means 32,500 miles a month are needed to break even, but only 9,000 are expected. The result is a 1,880 dollar monthly loss and the verdict NO, below target. — Here the answer is no. You'd need 32,500 miles a month and you expect 9,000.

Should I Buy This Truck tab weighing 750 dollars of monthly net revenue gain plus 900 dollars of cost-per-mile savings against the payment, giving a total monthly net benefit of 1,650 dollars against a 1,000 dollar minimum, and the verdict YES, buy it. — Extra revenue against extra cost, with your own minimum gain as the threshold.

Fuel Card & Telematics/ELD Comparison Calculator — $67

Buy this workbook

Provider Comparison tab across three fuel card providers. Provider B charges the lowest monthly platform fee at 40 dollars yet has the highest net monthly cost at 366, while Provider C charges the highest fee at 60 dollars and is cheapest overall at 119 dollars net per month once rebates are counted. — The cheapest monthly fee isn't the cheapest provider once rebates are counted.

Total Cost Comparison tab showing net annual cost of 2,004, 4,392 and 1,428 dollars for the same three providers. Provider C is cheapest at 1,428 dollars a year, within the 2,000 dollar target. — Over a year the ranking shifts again. This is the number that matters.

Multi-Truck Cost Calculator tab for a four-truck fleet at 15 dollars per truck plus a 50 dollar base platform fee, less a 10 percent volume discount, totalling 99 dollars a month and 1,188 dollars a year, within the 1,500 dollar target. — What a provider costs across your whole fleet, not one truck.

Every figure above is a live calculation from the actual product, using example inputs chosen to demonstrate each tab — they are not benchmarks, industry averages, or projections for your operation. Results depend entirely on the numbers you enter. For informational purposes only; verify with a qualified accountant before making pricing or business decisions. TruckingToolCalc accepts no liability for decisions made based on these calculations.