Industry Use Cases

Logistics Spreadsheet Analysis With Jolene.pro: Transit Times, Exceptions and Carrier Costs

Two carriers can report the same average transit time while giving customers very different experiences. One is usually consistent. The other is quick on most shipments and very late on a few. A monthly average can make them look like twins. The milestone records tell a more useful story.

For logistics and transport analysts, Jolene.pro can help examine shipment, milestone, exception and cost exports in Excel or CSV format. It supports questions across workbook tables, charts and source references. With the right records, the analysis can connect service performance to lanes, shipment characteristics and recorded costs.

Build a shipment-level analytical view

Useful fields include shipment ID, customer, carrier, origin, destination, service level, booked date, pickup time, promised delivery time and actual delivery time. Add shipment weight or volume, milestone events, exception codes and carrier charge lines. Preserve timestamp timezones and the units used for weight and distance.

A shipment can contain many milestones and charges. Summarize those tables separately before combining them with the shipment master. Ask Jolene.pro to check shipment counts and totals before and after matching. Keep split deliveries, canceled shipments and missing timestamps visible under agreed reporting rules.

1. Compare reliability beyond the average

Ask: “Compare median and 90th-percentile pickup-to-delivery time by lane, carrier and service level for completed shipments. Show shipment counts, missing timestamps and the source records. Keep different service commitments separate.”

The median describes a typical completed shipment; the upper percentile helps reveal the slower tail. Neither includes the eventual transit time of shipments still open. Show overdue open shipments alongside completed-shipment statistics so a carrier does not look faster simply because its most delayed loads have not arrived.

For on-time performance, define the eligible population and promised cutoff. Past-due undelivered shipments belong in the review, while shipments not yet due should not be counted as failures. Specify whether the metric concerns complete delivery or the first part of a split shipment.

2. Locate delay stages and recurring exceptions

Ask Jolene.pro to calculate recorded intervals such as pickup-to-depot, depot dwell and destination-to-delivery where corresponding events exist. Request the largest delay stages by lane and a breakdown of exception categories, including records without a reason.

Define which event marks each stage and how repeated scans are handled. An exception recorded after a missed delivery can describe the outcome rather than its cause. Examine the original event sequence and compare similar services before attributing delays to a depot, carrier or customer. The output should identify shipments for investigation.

3. Compare carrier charges on a matching basis

With charge codes and shipment characteristics, ask: “Summarize recorded base, fuel, accessorial and adjustment charges by shipment. Compare costs within similar lanes, service levels and weight bands. Show missing cost coverage and unusually large changes.”

State whether weights are actual, volumetric or chargeable. Normalize currencies under an agreed conversion rule. A lower average cost can reflect a lighter shipment mix rather than better pricing. Use contracts or rate cards with effective dates if you want a billed-versus-expected comparison; charge history alone cannot establish the agreed price.

4. Examine customer workload and concentration

Ask for each customer’s share of shipments, weight or volume, recorded exceptions and delivery attempts over the same period. Compare that workload with recorded revenue and included transport costs where those records exist. Report contribution only after naming the costs included.

A customer generating many small deliveries may create a different operating burden from one sending fewer large loads. Request both totals and per-shipment measures. Do not allocate depot overhead or handling costs without an explicit method. The view supports service and pricing discussions rather than automatically deciding which customers to keep.

Bring the shipment evidence to the service review

Inspect the calculation steps and source rows, save recurring analyses and pin the charts useful to operations. A compact dashboard can show lane reliability, overdue open shipments, exception stages and comparable costs. Re-run it with the next export after checking coverage and timestamp definitions.

Start with one lane and one complete reporting window in Jolene.pro. Ask a question that a planner can follow back to actual shipments. These are analysis workflows for supplied records, not a claim that the tool has tracked live vehicles or optimized dispatch routes.

Leave a comment