Heavy Duty Trucking Logo
MenuMENU
SearchSEARCH

Crunching the Numbers: What Do You Do With All That Data?

Since April 2008, wholesale distributor J.T. Davenport & Sons has cut its idle time from 20-30 percent to 3 percent.

by Staff
November 3, 2010
6 min to read


Since April 2008, wholesale distributor J.T. Davenport & Sons has cut its idle time from 20-30 percent to 3 percent.
The fleet's speeding rate has gone from 18-20 percent down to 0.2 percent, and the company has saved more than 30,000 gallons of fuel in one year, all through the use of Xata Corp.'s software.

Concord, N.C.-based Cardinal Logistics was able to eliminate cell phone usage by its drivers. That's because OTS, which provides tax technologies and tax solutions for the trucking industry, teamed up with Sprint to get access to Cardinal's drivers' phone records and audit those time-stamped records against their driver logs.

Meanwhile, truckload carrier Central Refrigerated Service realized a 15 percent drop in deadhead mileage on average per month, using TMW Systems' optimization solutions.
What do these fleets have in common? They've all used data to improve their operations and be more profitable.

Trucking companies are capturing and collecting all sorts of data from a variety of sources, from the engine control module and tracking/communica- tions system to fuel purchases and driver logs.

But what's important is what you do with that data, says Barry Craven, J.T. Davenport's transportation manager. If you're just sitting on data, it just takes up room on your hard drive, Craven says.

"If you don't use it, don't collect it," he says. "If the company invests money in technology for the transportation department, it is my job to make sure I get an ROI on that investment."

The playbook

J.T. Davenport uses Xata's software to measure key performance indicators, or KPIs, which are quantifiable measurements that drive fleet - and corporate - performance. "Typically tied to an organization's goals, KPIs provide everyone in the organization a clear picture of what success looks like," says Christian Schenk, vice president of marketing at Xata. "KPIs also clearly state what's going to be measured and how."

Xata's system offered J.T. Davenport the ability to run hundreds of reports, but Craven gets the ones he wants, based on what the company wants to accomplish. J.T. Davenport chose to look at idle time, speeding and mpg.

The company set goals, or targets, for how much they wanted these KPIs to improve. The Xata system then started tracking these, and the company awarded drivers and teams of drivers for meeting these goals.

McLeod Software's Randy Seals, customer advocate, says KPIs give fleets an actual playbook. KPIs allow fleet management to set up goals and see how their efforts are contributing to those goals. He compares it to the scoreboards at a baseball game: The players can look up at the scoreboard and see how they're doing and what they need to do to meet their goals.

"Trucking, for a long time, didn't have that," he says.

McLeod has a powerful suite of reporting capabilities within its LoadMaster software, which allows a fleet manager to observe, react and manipulate the success of his business in real time. It will help a fleet not only survive, but also monitor, execute and adjust their business plan by seeing what the key indicators are, Seals says.

For example, by viewing customer volumes by month, the system can predict what will happen for the rest of the year. That way, fleets can adjust the playbook to maximize their effort, Seals says. The system allows you to refine your dispatch and operations, identify weaknesses and correct those.

Analyzing key performance indicators specific to an operation can help a trucking company be competitive in real time, Seals says. The key is acting on the data. "Pondering long sometimes is pondering wrong."

Costing and profitability

Fleets can also crunch the numbers to perform activity-based cost analysis and profitability forecasting. These types of tools help fleets analyze their freight mix to determine what lanes and customers maximize their profitability.

Ashland City, Tenn.-based R.E. West Inc. implemented Transportation Costing Group's ProfitVision solution, which provides an itemized view of what it costs to run its business. An understanding of costs and profitability was needed to quantify successful freight and freight lanes and to fix those areas of the business that were underperforming.

R.E. West improved its bottom line by 10 percent in 18 months.

"These profits are the result of pricing potential lanes more efficiently by looking at accurate, historical cost data to make better informed decisions about lanes, loads and customers, and to communicate more effectively about costs and profitability," explains Jenny West, chief financial officer of R.E. West. "The TCG software ties to our general ledger so every dollar spent correlates to a dollar spent in the real world. TCG has helped us quantify costs and identify areas of success and where we can make improvements. It helps everyone here make more informed decisions that are backed up by hard numbers."

TCG President Ken Manning says the company can drill down into a fleet's data by anything that's in the freight or dispatch record. They analyze data such as freight bills, tolls, fuel records, general ledger, operating statistics, payroll, driver settlements, payments to interline carriers and dispatch data.

Once they've got the data, TCG sits down with the carrier and constructs a model of their operation over a certain time period, assigning a cost to every shipment or load in that period, Manning says.

But TCG doesn't just look at a load in isolation; it analyzes cost on a roundtrip basis, then isolates the loads. TCG's system also accounts for everything that happens to the load, from liftgate delivery and refrigerated moves to stop-offs. That way, the costing is very accurate, Manning says.

TMW Systems also has a suite of software products aimed at optimization and maximizing profitability. These software tools allow carriers to better understand their business and see efficiencies and inefficiencies in greater detail.

One of these offerings, IDSC MatchAdvice, works in real time to give planners and dispatchers suggested load and power matchups that are calculated to generate the highest profits and improve asset placement throughout the carrier's freight network.

Evans Equipment of Butler, Ind., uses TMW's IDSC ExpertFuel, which automatically generates an optimal travel route and a specific plan for fueling along the way. The fuel purchasing plan includes the location and amount of fuel to purchase at each stop to reduce the fleet's fuel spending.

Using the ExpertFuel tool, Evans Equipment is saving $50,000 to $70,000 a year. The tool uses the carrier's data to map out the most cost-effective fuel stops.

These tools are designed to help fleets take inefficiencies out and put efficiencies back into their operations, says Mike August, vice president and general manager of TMW's optimization group.

Custom reporting

Some technology providers work with fleets to customize the type of reporting and data capabilities that fit the fleet's specific needs.

Among them is Operating Tax Systems in Ohio. Al Uritis, CEO and founder of OTS, says the company takes a consultative approach to crunching data, and it's not limited to tax information.
OTS takes data from GPS, paper trip records, dispatch, the ECM, or anything that has an electronic thumbprint. The company then sits down with the fleet, slices, dices and massages that data to see how the information can be used to add value in other areas, outside of fuel taxes and driver logs. "How can we create and add value in other areas?" Uritis asks.

This type of customizable reporting is exactly what the company did for Cardinal Logistics. Cardinal's drivers were banned from using cell phones while driving, but the company needed a way to enforce that.

By taking drivers' cell phone records from Sprint and auditing them against driver l

Subscribe to Our Newsletter

More Fleet Management

HDT Cyber Stop graphic pairing a laptop displaying binary code with a person using a clipboard to inspect a truck chassis, against a background of padlock icons.
Fleet Management•November 2, 2026

Give Your Trucking Fleet a Cybersecurity Walkaround

Your fleet's cybersecurity policies may look good on paper. These seven checks can help you find out whether they’re working.

Read More →
Red Kodiak-branded autonomous tractor with Charger-branded trailer backed up to warehouse
Fleet Management•October 30, 2026

Kodiak Lines Up Fleets for Driverless Trucking

An agreement for 75 trucks, a new Texas freight lane, and progress on safety validation move Kodiak closer to its planned driverless highway launch.

Read More →
Illustration with Star of David and EEOC logo
Fleet Management•by News/Media Release•October 28, 2026

ITS Logistics Settles Religious Harassment Case

The Nevada-based logistics firm agreed to pay more than $396,000 to settle a religious harassment charge involving an employee's Jewish identity.

Read More →
Ad Loading...
Truck on divided interstate highway driving toward sunrise
Fleet Management•October 27, 2026

Your Trucks Are Busy. That Doesn’t Mean They’re Winning.

High utilization doesn’t always mean strong margins. Looking beyond the current load can help fleets make better dispatch decisions and get more value from each truck’s time.

Read More →
ATA economist Bob Costello speaking beside a graph showing truckload operating costs rising as freight revenue per mile declined after 2022.
Fleet Management•by Deborah Lockridge•October 22, 2026

Why This Trucking Recovery Is Different

Freight demand remains sluggish, but rising costs and tougher enforcement have taken enough capacity out of the market to change the outlook for motor carriers.

Read More →
PS Coach tablet interface showing a driver’s coaching inbox, safety event video and coaching advice for a harsh-braking event.
Fleet Management•by News/Media Release•October 21, 2026

Platform Science Adds Dispatch and Safety Tools

Four additions to PS Fleet help fleets monitor loads, manage driver coaching, share truck locations and adjust video system settings.

Read More →
Ad Loading...
Screen capture showing PrePass Intelligence data on tolls
Fleet Management•by News/Media Release•October 21, 2026

PrePass Intelligence Mines Fleet Bypass, Toll and Safety Data

PrePass Intelligence helps fleets measure bypass savings, flag potential toll overcharges, and spot suspicious transactions by combining data from separate systems.

Read More →
Computer screen showing examples of what fleets could ask Motive AI Agents to do
Fleet Management•by Staff•October 20, 2026

Motive Adds AI Agents for Fleet Operations

New tools automate follow-up on fleet data, from maintenance work orders to driver alerts, with two-way voice conversations planned for later this year.

Read More →
Graphic art with a heavy-duty tractor trailer and a work truck with the words "trivia lunch"
Fleet Management•by Lauren Fletcher•October 19, 2026

Can You Beat Our Trucking Trivia Challenge?

Test your truck knowledge with 19 trivia questions from Heavy Duty Trucking Exchange. Can you keep up with the fleet pros?

Read More →
Ad Loading...
Four horizontal and two vertical video screens show different aspects of BeyondTruck's new compatibility engine
Fleet Management•by Deborah Lockridge•October 19, 2026

BeyondTrucks Adds Rules Checks to Dispatch

New Compatibility Engine checks driver qualifications, equipment requirements and fleet policies before loads are dispatched.

Read More →