Fuel Inventory Management System & Variance Checker

Ph-SRP Financial Auditing & Industry-Standard UST Order Forecasting.

📊 System Framework Definitions (Ph-SRP Auditing & UST Forecasting)

Philippine SRP Financial Auditing Framework

Retail stations across the Philippines operate under a dynamic Suggested Retail Price (SRP) matrix controlled by local market adjustments. Because inventory is purchased in advance but sold at volatile pump rates, this framework performs real-time financial audits on "wet stock" losses.

Every liter of variance caused by thermal contraction, tank sludging, or high-pressure nozzle delivery error is calculated against the currently active board rate to safeguard station net revenue margins from processing leaks.

Industry-Standard UST Order Forecasting

Underground Storage Tanks (UST) require proactive order cycles due to supply terminal travel times. This dashboard implements an automated safety threshold set at 30% remaining volume.

When real-time dip records drop to or below this safety boundary, the system shifts out of "Stock Secure" mode to trigger a Priority Order Alert. This protects the station from "running dry"—an issue that stalls operations, clogs lines with tank debris, and causes immediate revenue loss.

⛽ Live SRP Board Price Configuration (Tuesday Adjustments)
📡 Market Reference Comparator
ProductIndicative SRP
⚠️ Not a live feed. There is no free public real-time API for Philippine pump prices, so these figures are a manually-sourced reference snapshot (see date/source below), not an auto-sync. Prices move weekly (usually Tuesdays) and vary ₱1–3 by location. Always cross-check against the DOE's official Oil Monitor advisory before applying to your own board, and update this snapshot manually — or ask the developer to refresh it — when it goes stale.
💡 Why "Tuesday Adjustments"? View Local Ph Operational Context

1. The Monday Night "Routine"

In the Philippines, oil companies (Shell, Petron, Caltex, CleanFuel, etc.) announce fuel price movements every Monday afternoon. These structured price hikes or cuts officially take effect across fuel stations nationwide the next day, Tuesday morning at exactly 6:00 AM.

2. How This App Fits into the Real-World Workflow

The "(Tuesday Adjustments)" label mirrors standard field operations:

  • Monday Night / Tuesday Pre-dawn: The manager references current energy announcements and opens this Price Configuration panel.
  • The Action: Input the incoming market board updates and click "Save Price Matrix".
  • The Result: When the Tuesday morning shifts clock in, inventory asset calculations, book reconciliations, and financial variances immediately track accurately against true running pump rates.

Real-Time Tank Asset & Order Forecasting Monitor

Shift Reconciliation Input

💡 How Shift Reconciliation Input Works

1. The Daily Closing Audit Routine

At the end of an operational shift or business day, station managers process a reconciliation workflow to cross-examine computer sales with the actual wet stock resting inside the Underground Storage Tanks (UST).

2. How This App Fits into the Real-World Workflow

The Reconciliation Input handles field metrics step-by-step:

  • Opening Balance Stock: Automatically fetches the current stock data from your dashboard database as your baseline running volume (editable if a manual correction is needed).
  • Inbound Replenishment: Input bulk fuel drops received from fuel lorries.
  • Registered Pump Sales: Input the cumulative volumes drawn from totalizer logs.
  • Physical Dipstick Reading: Manual measurement verification value.
  • The Audit Engine Result: Balanced sheet vs wet logs. Variance above 0.5% trips a critical flag indicator.

Station Audit Ledgers & Reconciliations

Date Product Line Throughput Vol Variance Vol Estimated Value Discrepancy Audit Status Actions

🧭 Nearest Fuel Station Locator

Uses your device's location plus live OpenStreetMap data (no API key required) to find real fuel stations nearby.