Skip to main content

Transportation (freight)

Pack file: catalog/industries/transportation in ambient-core.

Workspace demo (screenshots) · Catalog consumption

Industry summary​

Industry code

ISIC Rev.4 4923

28 metrics · 19 data options

NAICS 2022
484110 (also 484122, 483111)
NACE Rev.2
49.41 (also 50.20)
GICS 2023
203040

Taxonomy tags from ambient-core pack.yaml / manifest v3 (analysis lens, not legal-entity self-classification). Coverage notes: catalog-industry-coverage.md.

Data options​

  • Vehicle telematics data (5tZAB2WLZbRDQdj6l7X6) — fields: date (date), vehicle_id (id), telematics_date (date), engine_performance (string), fuel_efficiency (string), maintenance_alerts (string), driver_behavior (string)
  • Accounts payable aging (Alltransportationds-ap-aging) — fields: date (date), supplier_name (string), bill_id (id), bill_date (date), due_date (date), amount_due (decimal), days_outstanding (string), aging_bucket (string), accounts_payable (decimal), cogs (string), days (string), days_inventory_outstanding (string)
  • Accounts receivable aging (Alltransportationds-ar-aging) — fields: date (date), customer_name (string), invoice_id (id), invoice_date (date), due_date (date), amount_due (decimal), days_outstanding (string), aging_bucket (string), accounts_receivable (decimal), total_credit_sales (decimal), days (string), days_inventory_outstanding (string)
  • Balance sheet (Alltransportationds-balance-sheet) — fields: date (date), period_end_date (date), inventory (string)
  • Bank statements (Alltransportationds-bank-statements) — fields: date (date), transaction_date (date), account_id (id), description (string), amount (decimal), direction (string), balance (string), currency (currency), net_income (string), non_cash_charges (string), increase_in_working_capital (string), cash_out (string)…
  • General ledger (Alltransportationds-general-ledger) — fields: date (date), account_code (id), account_name (decimal), journal_entry_id (id), debit (string), credit (string), period (enum), currency (currency)
  • Trial balance (Alltransportationds-trial-balance) — fields: date (date), account_code (id), account_name (decimal), debit_balance (string), credit_balance (string), period (enum)
  • Maintenance logs (DclVZaLbyz6Pwxt5Ctr1) — no typed fields defined
  • Fleet management systems (Ta6fK4eo9bymVVQGYEpl) — fields: date (date), fleet_id (id), vehicle_ids (string), maintenance_schedule (string), fuel_logs (string), insurance_details (string), fleet_time_in_use (string), fleet_available_time (string)
  • Delivery logs (i0N19s7GpHi9QTyG5dhM) — fields: date (date), delivery_date (date), vehicle_id (id), route_id (id), delivery_status (enum), delivery_address (string), customer_name (string), delivery_time (string)
  • GPS tracking data (jHscrlnM67xOUF1IXfos) — fields: date (date), vehicle_id (id), tracking_date (date), start_location (string), end_location (string), distance_travelled (string), average_speed (string), route_taken (string)
  • Accounting Software (transportation.core.accounting_software) — fields: date (date), period_start_date (date), period_end_date (date), revenue (decimal), cogs (decimal), cost_of_goods (decimal), operating_expenses (decimal), net_income (decimal), produce_revenue (decimal), total_production_cost (decimal), total_operational_cost (decimal)
  • Financial statements (transportation.core.financial_statements) — fields: date (date), statement_type (enum), period_start_date (date), period_end_date (date)
  • HR records (transportation.core.hr_records) — fields: date (date), headcount (decimal)
  • Payroll records (transportation.core.payroll_records) — fields: date (date), period_start_date (date), period_end_date (date), headcount (decimal), gross_pay (decimal), net_pay (decimal), employer_taxes (decimal), labor_cost (decimal), revenue (decimal), net_income (decimal), total_labor_costs (decimal), total_harvested_kg (decimal)…
  • Freight forwarding operations summary (transportation.freight_forwarding.operations_summary) — fields: date (date), shipments_handled (string), on_time_shipments (string), total_shipments (decimal)
  • Maritime fleet operations summary (transportation.maritime.operations_summary) — fields: date (date), operating_days (string), available_days (string), voyage_revenue (decimal), voyage_costs (decimal), on_hire_days (string), on_schedule_voyages (string), total_voyages (decimal)
  • Rail freight operations summary (transportation.rail_freight.operations_summary) — fields: date (date), loaded_train_miles (string), available_train_miles (string), total_operating_cost (decimal), ton_miles_moved (string), on_time_shipments (string), total_shipments (decimal)
  • Fuel logs (uRTkFZUmJC2BLwoRtJxL) — fields: date (date), vehicle_id (id), fuel_type (enum), fuel_date (date), fuel_quantity (string), fuel_cost (decimal), odometer_reading (string)

Metrics (28)​

Driver Turnover Rate​

  • Catalog key: DtBqsvp9S9HBlcxsvAgd
  • ID: 14
  • Type: Operational
  • Unit: %
  • Segment: road_freight
  • Methodology: (Number of drivers who left / Total number of drivers) * 100
  • Calculation: drivers_left / total_drivers * 100 — inputs: drivers_left, total_drivers

The percentage of drivers that leave the company within a specific period.

Fuel Efficiency​

  • Catalog key: SAZkxRxYFtf1EIxBXWMk
  • ID: 10
  • Type: Operational
  • Unit: Miles per Gallon (MPG)
  • Segment: road_freight
  • Methodology: Total miles driven / Total fuel used
  • Calculation: total_miles / total_fuel — inputs: total_miles, total_fuel

Average miles per gallon for the fleet.

On-Time Delivery Rate​

  • Catalog key: biA3oIK816fwfInBKg2e
  • ID: 12
  • Type: Operational
  • Unit: %
  • Segment: road_freight
  • Methodology: (Number of on-time deliveries / Total deliveries) * 100
  • Calculation: on_time_deliveries / total_deliveries * 100 — inputs: on_time_deliveries, total_deliveries

The percentage of deliveries made on or before the scheduled delivery time.

Fleet Utilization Rate​

  • Catalog key: iIaKhCCf0BGvHX1W1i7n
  • ID: 11
  • Type: Operational
  • Unit: Percentage
  • Segment: road_freight
  • Methodology: (Total time fleet in use / Total available fleet time) * 100
  • Calculation: fleet_time_in_use / fleet_available_time * 100 — inputs: fleet_time_in_use, fleet_available_time

The percentage of time the fleet is actively in use.

Monthly Burn Rate​

  • Catalog key: transportation.core.burn_rate
  • ID: 1000
  • Type: Financial
  • Unit: Currency/month
  • Segment: core
  • Methodology: Net Burn = Cash Out − Cash In (per month)
  • Calculation: cash_out - cash_in — inputs: cash_out, cash_in

Net cash consumed per month (negative net operating cash flow).

FP&A workflow: Runway management — paired with cash balance to govern the spend plan and fundraising timing.

Cash Conversion Cycle​

  • Catalog key: transportation.core.ccc
  • ID: 988
  • Type: Financial
  • Unit: Days
  • Segment: core
  • Methodology: CCC = DSO + Days Inventory Outstanding − DPO
  • Calculation: dso + days_inventory_outstanding - dpo — inputs: days_inventory_outstanding

Days to convert investments in inventory and receivables back into cash.

FP&A workflow: Cash-efficiency program — a north-star working-capital KPI tracked in the treasury review.

Current Ratio​

  • Catalog key: transportation.core.current_ratio
  • ID: 928
  • Type: Financial
  • Unit: Ratio
  • Segment: core
  • Methodology: Current Ratio = Current Assets / Current Liabilities
  • Calculation: current_assets / current_liabilities — inputs: current_assets, current_liabilities

Short-term liquidity: ability to cover current liabilities with current assets.

FP&A workflow: Liquidity & solvency review — feeds covenant monitoring and the monthly board liquidity pack.

Days Payable Outstanding (DPO)​

  • Catalog key: transportation.core.dpo
  • ID: 982
  • Type: Financial
  • Unit: Days
  • Segment: core
  • Methodology: DPO = (Accounts Payable / COGS) × Number of Days
  • Calculation: accounts_payable / cogs * days — inputs: accounts_payable, cogs, days

Average number of days the business takes to pay its suppliers.

FP&A workflow: Payables optimization — balances supplier terms against the cash-conversion cycle.

Days Sales Outstanding (DSO)​

  • Catalog key: transportation.core.dso
  • ID: 976
  • Type: Financial
  • Unit: Days
  • Segment: core
  • Methodology: DSO = (Accounts Receivable / Total Credit Sales) × Number of Days
  • Calculation: accounts_receivable / total_credit_sales * days — inputs: accounts_receivable, total_credit_sales, days

Average number of days to collect cash after a sale.

FP&A workflow: Receivables & collections review — directly improves the cash-conversion cycle and forecast accuracy.

EBITDA Margin​

  • Catalog key: transportation.core.ebitda_margin
  • ID: 952
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: EBITDA Margin = (EBITDA / Revenue) × 100
  • Calculation: ebitda / revenue * 100 — inputs: ebitda, revenue

Core operating cash profitability before interest, tax, depreciation and amortization.

FP&A workflow: Valuation & lender reporting — primary profitability proxy in models and covenant tests.

Gross Profit Margin​

  • Catalog key: transportation.core.gross_margin
  • ID: 940
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: Gross Margin = ((Revenue − COGS) / Revenue) × 100
  • Calculation: (revenue - cogs) / revenue * 100 — inputs: revenue, cogs

Share of revenue retained after the direct cost of goods sold.

FP&A workflow: Unit-economics and pricing review — anchors contribution-margin and budget-vs-actual analysis.

Headcount (FTE)​

  • Catalog key: transportation.core.headcount
  • ID: 1084
  • Type: Operational
  • Unit: Count
  • Segment: core
  • Methodology: Period-end count of active employees expressed as full-time equivalents (directly measured, not calculated).
  • Calculation: No machine-readable calc — directly reported or qualitative.

Period-end count of active full-time-equivalent employees. A directly measured input, not a derived ratio.

Net Profit Margin​

  • Catalog key: transportation.core.net_margin
  • ID: 958
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: Net Profit Margin = (Net Income / Revenue) × 100
  • Calculation: net_income / revenue * 100 — inputs: net_income, revenue

Bottom-line profitability after all costs, interest and tax.

FP&A workflow: Board P&L reporting — the headline profitability line for the monthly close pack.

Operating Cash Flow​

  • Catalog key: transportation.core.operating_cash_flow
  • ID: 994
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Segment: core
  • Methodology: Operating Cash Flow = Net Income + Non-Cash Charges − Increase in Working Capital
  • Calculation: net_income + non_cash_charges - increase_in_working_capital — inputs: net_income, non_cash_charges, increase_in_working_capital

Cash generated by core operations during the period.

FP&A workflow: Cash-flow forecasting — the anchor of the direct/indirect cash-flow statement.

Operating Margin (EBIT)​

  • Catalog key: transportation.core.operating_margin
  • ID: 946
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: Operating Margin = (Operating Income / Revenue) × 100
  • Calculation: operating_income / revenue * 100 — inputs: operating_income, revenue

Operating profitability after operating expenses (EBIT margin).

FP&A workflow: Opex efficiency review — drives the monthly variance bridge and cost-control actions.

Quick Ratio (Acid Test)​

  • Catalog key: transportation.core.quick_ratio
  • ID: 934
  • Type: Financial
  • Unit: Ratio
  • Segment: core
  • Methodology: Quick Ratio = (Current Assets − Inventory) / Current Liabilities
  • Calculation: (current_assets - inventory) / current_liabilities — inputs: current_assets, inventory, current_liabilities

Acid-test liquidity excluding inventory — most conservative short-term solvency view.

FP&A workflow: Liquidity stress testing — pairs with cash-flow forecasting for downside scenarios.

Revenue Growth Rate​

  • Catalog key: transportation.core.revenue_growth
  • ID: 964
  • Type: Financial
  • Unit: %
  • Segment: core
  • Methodology: Revenue Growth = ((Current Period Revenue − Prior Period Revenue) / Prior Period Revenue) × 100
  • Calculation: (revenue - revenue_prior) / revenue_prior * 100 — inputs: revenue, revenue_prior

Period-over-period revenue growth rate.

FP&A workflow: Growth planning — drives top-line forecast, hiring plan and the rolling re-forecast.

Cash Runway​

  • Catalog key: transportation.core.runway
  • ID: 1006
  • Type: Financial
  • Unit: Months
  • Segment: core
  • Methodology: Runway (months) = Current Cash Balance / Monthly Net Burn
  • Calculation: current_cash_balance / burn_rate — inputs: current_cash_balance

Number of months of cash remaining at the current net burn rate.

FP&A workflow: Board & investor reporting — the survival metric that gates hiring and spend decisions.

Working Capital​

  • Catalog key: transportation.core.working_capital
  • ID: 970
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Segment: core
  • Methodology: Working Capital = Current Assets − Current Liabilities
  • Calculation: current_assets - current_liabilities — inputs: current_assets, current_liabilities

Operating liquidity available to fund day-to-day operations.

FP&A workflow: Working-capital management — feeds the 13-week cash forecast and treasury planning.

Gross Margin per Shipment​

  • Catalog key: transportation.freight_forwarding.gross_margin_per_shipment
  • ID: 1871
  • Type: Financial
  • Unit: Currency
  • Segment: freight_forwarding
  • Methodology: Margin per Shipment = Gross Profit / Shipments Handled
  • Calculation: gross_profit / shipments_handled — inputs: gross_profit, shipments_handled

Average gross profit per shipment handled by the forwarder (aggregated).

FP&A workflow: 3PL unit economics — buy versus sell rate spread.

On-Time Delivery (Shipper SLA)​

  • Catalog key: transportation.freight_forwarding.on_time_delivery_shipper
  • ID: 1872
  • Type: Operational
  • Unit: %
  • Segment: freight_forwarding
  • Methodology: OTD = (On-Time Shipments / Total Shipments) × 100
  • Calculation: on_time_shipments / total_shipments * 100 — inputs: on_time_shipments, total_shipments

Share of forwarder-managed shipments delivered within customer SLA (aggregated).

FP&A workflow: Shipper-facing reliability — distinct from owned-fleet road OTD.

Schedule Reliability​

  • Catalog key: transportation.maritime_shipping.schedule_reliability
  • ID: 1867
  • Type: Operational
  • Unit: %
  • Segment: maritime_shipping
  • Methodology: Reliability = (On-Schedule Voyages / Total Voyages) × 100
  • Calculation: on_schedule_voyages / total_voyages * 100 — inputs: on_schedule_voyages, total_voyages

Share of port calls or voyages completed within published schedule window (aggregated).

FP&A workflow: Liner service quality — customer SLAs.

Time Charter Equivalent (TCE)​

  • Catalog key: transportation.maritime_shipping.time_charter_equivalent
  • ID: 1866
  • Type: Financial
  • Unit: Currency per day
  • Segment: maritime_shipping
  • Methodology: TCE = (Voyage Revenue − Voyage Costs) / On-Hire Days
  • Calculation: (voyage_revenue - voyage_costs) / on_hire_days — inputs: voyage_revenue, voyage_costs, on_hire_days

Daily revenue net of voyage costs per day chartered (aggregated).

FP&A workflow: Shipping yield — bunker and route economics.

Vessel Utilization​

  • Catalog key: transportation.maritime_shipping.vessel_utilization
  • ID: 1865
  • Type: Operational
  • Unit: %
  • Segment: maritime_shipping
  • Methodology: Vessel Utilization = (Operating Days / Available Days) × 100
  • Calculation: operating_days / available_days * 100 — inputs: operating_days, available_days

Operating days at sea or laden days relative to available vessel days (aggregated).

FP&A workflow: Fleet employment — dry dock and positioning time.

Cost per Ton-Mile​

  • Catalog key: transportation.rail_freight.cost_per_ton_mile
  • ID: 1861
  • Type: Financial
  • Unit: USD per ton-mile
  • Segment: rail_freight
  • Methodology: Cost per Ton-Mile = Total Operating Cost / Ton-Miles Moved
  • Calculation: total_operating_cost / ton_miles_moved — inputs: total_operating_cost, ton_miles_moved

Total rail freight operating cost per ton-mile moved (aggregated).

FP&A workflow: Unit economics — pricing versus truck and barge competition.

On-Time Train Performance​

  • Catalog key: transportation.rail_freight.on_time_train_performance
  • ID: 1862
  • Type: Operational
  • Unit: %
  • Segment: rail_freight
  • Methodology: OTP = (On-Time Shipments / Total Shipments) × 100
  • Calculation: on_time_shipments / total_shipments * 100 — inputs: on_time_shipments, total_shipments

Share of rail shipments arriving within contractual or service window (aggregated).

FP&A workflow: Service reliability — rail-specific definition.

Train Utilization​

  • Catalog key: transportation.rail_freight.train_utilization
  • ID: 1860
  • Type: Operational
  • Unit: %
  • Segment: rail_freight
  • Methodology: Train Utilization = (Loaded Train-Miles / Available Train-Miles) × 100
  • Calculation: loaded_train_miles / available_train_miles * 100 — inputs: loaded_train_miles, available_train_miles

Loaded train-miles or tonnage moved relative to available train capacity (aggregated).

FP&A workflow: Rail asset use — distinct from road fleet utilization.

Maintenance Cost per Mile​

  • Catalog key: vXlB5QC3mZJw1auWaIfK
  • ID: 13
  • Type: Operational
  • Unit: USD/mile
  • Segment: road_freight
  • Methodology: Total maintenance costs / Total miles driven
  • Calculation: total_maintenance_costs / total_miles — inputs: total_maintenance_costs, total_miles

Total maintenance costs divided by total miles driven.

Generated from ambient-core ref 10fb050 (digest 890f3d2011311128). Regenerate: npm run sync:catalog-wiki.