Cardlock FIFO Visualizer
All Locations /
Volume (L)
WAC / L
Layers
Inv. Value
Oldest Layer
Last Delivery
Cost Spread
FIFO Tank
Oldest at bottom · newest at top
Low
High Transfer Pending
Layer Detail
Sort by column · = pending
Recent Activity
Latest movements
Inventory Health
Age Distribution
Layer Sources
Consumption
Period
Cost / Litre Trend
Delivery cost per litre over time
Inflow & Outflow
Volume movements by week
Locations
Loading…
FIFO Layer Window
First N Layers
Next N Litres
📋
Select locations to build the report.
FIFO Layer — Cost Basis
Select a location & product
Landed Cost Detail
📦
Pick a location & product to see FIFO landed cost.
Net landed cost by layer oldest → newest · bar height = $/L · colour = age · ▦ = WAC
Pick a location & product.
Net landed cost ($/L) is authoritative — straight from the FIFO layers (what the fuel actually cost AFD). * Rack = the product's OPIS rack as-of each layer's purchase date and * Rebate = Rack − Net are derived from the pricing config (the discount below rack AFD achieved). The layer (or weighted-avg) selected here is the cost basis used by the Pricing tab. Site cost adders (SHR freight · tank · commission · OPEX · credit cards) are static per-location values from the cardlock pricing workbook. Net landed cost (all-in) = net FIFO cost + these adders (margin is excluded — it is applied on the Pricing tab).
Cost Basis
Select a layer on the Costing tab
← Change cost basis on Costing
Pricing Components ($/L)
Taxes
Customer Price Groups
Pick a location & product…
Customer price per the BC Component Pricing Calculator: rack − discount + rmod + margin + freight + FSC + commission + tank + BCLCFS = price w/o tax, + carbon + excise + provincial fuel tax = price w/o GST, + GST = customer price. Rack is seeded from the layer chosen on Costing; only the per-group discount differs between the 8 groups. Margin (w/o tax) = price w/o tax − net landed cost all-in (net FIFO + freight · tank · commission · OPEX · credit cards from the Costing tab).
🧮
Pick a location & product to build landed costs by customer group.
Market Benchmarks
Nearby Competitor Prices
Select a cardlock site to see nearby competitor prices.
Site Weather
Select a location to see conditions.
AFD Cardlock — Overview
Largest customer groups (registered)
Top sites by spread $/L last 12 mo · fuel
Market benchmarks
6 12 24
Spread $/L by Customer Group
Spread $/L by Site
Realized $/L = fuel sales ÷ litres (posted invoices; includes road fuel taxes). Landed cost $/L = FIFO weighted-avg cost (current snapshot). Spread = realized − landed cost — price over landed cost (covers margin, freight, tank, commission, taxes), not net profit. Fuel only (diesel + gasoline).
Customers Volume Sales
6 12 24
Mix by group (period)
Loading…
Monthly Mix — Customers share by group
Loading…