All projects

Finance · Pricing

Fuel Surcharge Analysis

ExcelPythonDAXPower BI
Financial analytics visualization with trend lines comparing fuel price indices and surcharges

Business Problem

Fuel surcharges must track volatile fuel price indices — misalignment quietly impacts margin and billing accuracy.

Trend and variance analysis of surcharge schedules against fuel price indices, with dashboards that highlight gaps and forecast exposure.

Approach

  1. 01

    Aligned surcharge schedules with published fuel price indices in a unified time-series dataset.

  2. 02

    Quantified variance between billed surcharges and index-based expectations.

  3. 03

    Developed a monitoring dashboard to flag misalignment and margin exposure.

Results & Findings

Detailed findings and dashboard walkthrough are being documented and will be published soon.