24/7 Gas Station Convenience Store Financial Model

Description

The model integrates a 24/7 fuel retail station with a full-scale convenience store. It captures dual revenue streams: fuel sales with daily rack-to-retail pricing across regular, midgrade, premium, and diesel, and C-store sales spanning high-margin perishables, beverages, tobacco, and lottery. Each fuel grade has its own cost base and margin dynamically linked to spot price inputs, while C-store margins are modelled by product category reflecting real-world purchasing and spoilage patterns.

Operational complexity is addressed through a multi-layer shift schedule covering 24/7 operations with peak/off-peak differentials, overnight premiums, and statutory breaks. The C-store segment includes dynamic inventory management with restocking cycles, seasonal demand curves, and theft/shrinkage that varies by store hours and product type. Card processing fees are calculated per transaction for pay-at-pump and in-store, distinguishing fuel and merchandise payments.

Capital expenses cover underground storage tanks, dispensers, canopy, store build-out, and initial inventory loads. The model incorporates environmental compliance amortization (UST integrity testing, vapour recovery), tank ullage and temperature-adjusted wet stock losses, and working capital for fuel inventory, C-store stock, and cash float. The total investment order-of-magnitude is presented for high-level validation.

Modeling specifics

• Rack-to-retail fuel margin logic with daily spot price input for multiple grades (regular, midgrade, premium, diesel) and ethanol blending adjustments.
• Wet stock management modelling ullage, delivery scheduling, temperature-induced volume correction, and evaporative losses.
• 24/7 staff scheduling engine with shift blocks, coverage by demand hour, statutory break compliance, and overnight/weekend wage premiums.
• C-store inventory broken into ambient, chilled, frozen, and duty-paid categories, each with distinct margin, turnover days, and shrinkage rates.
• Integrated card payment fee calculator separating pay-at-pump (lower interchange) and in-store transactions, allocated to fuel vs. C-store revenue.
• Environmental cost amortization schedule for UST testing, vapour recovery maintenance, and spill insurance.
• Demand sensitivity module allowing volume response to pump price changes, with separate elasticity for each fuel grade and C-store footfall.
• Lottery and ATM commission tracking with pass-through revenue modelling.

What's included in the base version

• Fuel revenue model (up to four grades) with daily rack-to-retail pricing and excise/sales tax logic.
• C-store revenue model by category (ambient, chilled, frozen, tobacco, lottery) with dynamic inventory and spoilage.
• 24/7 shift labour schedule with wage differentials and full-time/part-time mix.
• Capital expenditure schedule (underground tanks, dispensers, canopy, building, initial inventory).
• Operating expense detail (utilities, maintenance, security, insurance, card fees).
• Working capital schedule (fuel stock, C-store inventory, cash in tills/ATMs).
• Loan amortization and debt service with flexible terms.
• Integrated financial statements (P&L, cash flow, balance sheet) on monthly and annual basis.
• Scenario manager for fuel volume, margin, and C-store sales sensitivity.

Common modeling mistakes

• Applying a single C-store gross margin instead of category-specific margins (tobacco ~15% vs. food ~40%) — C-store gross profit overstated by 15–25%.
• Ignoring card processing fees that differ for pay-at-pump and in-store — net income overestimated by 1.5–2.5%.
• Modelling all labour at a flat hourly rate without overnight/weekend premiums — labour cost understated by 8–12%.
• Assuming zero fuel temperature expansion loss — fuel inventory shrinkage understated by 1.5–2% of volume, reducing fuel margin.
• Omitting environmental compliance amortization and tank testing — annual operating expense understated by 5–7%.
• Neglecting shrinkage in high-theft C-store categories (tobacco, alcohol) — gross margin inflated by 3–5%.
• Failing to differentiate fuel demand elasticity by grade when raising pump prices — throughput overestimated by 10–15%.