Simulation by Ejiro Inije
Simple decision tool for finding where fuel ordering, storage, delivery and stock-control money may be leaking — and showing what to do about it.
💡 What this is: The actual quantity of fuel you currently order in a single tanker truck or compartment (e.g., 33,000 L, 45,000 L, or 60,000 L).
🎯 Why it matters: Tests whether your planned tanker truck capacity is over-ordering (wasting storage capital) or under-ordering (wasting freight trips).
💡 What this means: The average quantity of fuel motorists buy from your pumps every day.
📊 How to measure: Take total pump sales from the last 30 days and divide by 30.
Includes: Tanker freight charge, depot waybill fees, driver stipends, and offloading fees.
Includes: Bank loan interest on tied-up money, tank maintenance, insurance, and underground evaporation loss.
Includes: Lost profit margin per liter + penalty of customers leaving to rival stations permanently.
Advanced market shock and scarcity risk modeling are reserved for paid consulting clients.
Unlock via Consultation with Ejiro InijeDetailed multi-tank shrinkage audits and emergency delivery modeling are reserved for paid client engagements.
Unlock via Consultation with Ejiro Inije🟡 Yellow Line: How your tank drains using your planned order size.
🔵 Blue Dashed Line: How your tank drains using the mathematically perfect batch size (EOQ).
🟢 Green Line: Reorder point line. Order immediately when fuel hits this mark!
💡 How to read this graph: The exact bottom point of the blue curve is your target Economic Order Quantity (EOQ). It is where storage holding costs equal delivery freight costs.
What to do: This is the order size that gives the lowest combined ordering and storage cost under the numbers you entered.
What to do: When the tank reaches this level, start the next order so the truck has time to arrive before fuel gets too low.
What to do: Think of this as emergency fuel. It helps the station survive when sales rise or the truck arrives late.
What to do: The extra yearly ordering and storage cost caused by using your chosen order size instead of the cost-minimizing target. This is not your total freight bill.
This section turns the numbers into simple business answers. It does not assume that every difference is theft or guaranteed loss.
Calculating the value of the fuel represented by your current order.
Checking whether small orders are forcing unnecessary tanker trips.
Checking whether large orders are keeping too much fuel in storage.
Checking whether dry-tank days are creating a meaningful sales risk.
Checking whether rushed deliveries are adding unnecessary cost.
Checking whether the reported stock difference is large enough to investigate.