Forecourt Operator Pack - Fuel P&L, Stocktake, 13-Week Cash – Document Bundle

DESCRIPTION

Forecourt Operator Pack - Fuel P&L, Stocktake, 13-Week Cash is a Document Bundle available for immediate download upon purchase.

The Forecourt Operator Pack brings together the three Basecase models a service station operator reaches for most: the Service Station / Fuel Retail Model, the Retail Stocktake Variance Model and the 13-Week Rolling Cash Flow Forecast. Each answers a different question about the same site at a different time horizon: what the site earns and is worth over three years, what is leaking out of the shop at each stocktake, and whether the bank account gets through the next thirteen weeks.

What it does: the Fuel Retail Model builds a three-year P&L with Year 1 month by month, keeping fuel gross profit (litres x cents per litre) separate from shop gross profit (sales x GP%), then capitalises free cash flow to equity into an indicative business value with a KPI dashboard and two sensitivity grids on that value: fuel margin vs shop GP%, and fuel margin vs fuel volume. The Retail Stocktake Variance Model takes your counted lines and values the variance at both cost and retail, separates count noise from real loss with a tolerance band, benchmarks shrinkage as a percentage of sales and ranks lines by ABC class. The 13-Week Rolling Cash Flow Forecast projects weekly receipts and payments and models a working-capital facility that draws when cash is short and repays when it is long, showing closing cash and facility headroom every week.

How the models connect: they are three separate workbooks with no links between files, so you carry a handful of figures across by hand. The shop revenue in the fuel model and the annual retail sales on the stocktake Assumptions sheet describe the same shop. The stocktake's lost margin on missing stock shows how far your achieved shop margin sits below the GP% you planned with, which you can then test in the fuel model's fuel margin vs shop GP% sensitivity grid. Monthly wages, rent and overheads from the fuel model's operating-cost inputs become the recurring payments in the 13-week forecast, and its supplier-purchase percentage and payment lag let you model supplier terms against weekly takings.

Main features: 1,264 live formulas across the three files; fuel and shop margins modelled separately; an FCFE capitalisation valuation with two two-way sensitivity grids; shrinkage at cost and retail with eleven integrity checks; draw-and-sweep revolver logic with weekly headroom; and a worked example preloaded in every model.

How to work with it: open each workbook and overwrite the blue input cells, starting with the yellow-filled key drivers. Everything else is a visible formula. The 13-week model's worked example is a fictional food wholesaler, so replace its inputs with your own site's figures.

Why you need it: a forecourt runs on thin fuel margins, a shop margin that leaks, and supplier terms that leave little slack in the bank. Looking at all three together is how you tell whether a problem is margin, shrinkage or timing. The pack is priced below the three models bought separately, and each workbook is identical to its individual listing.

Every file is fully unlocked, every formula visible, with a plain-English cover sheet. Currency-agnostic; treat $ as your currency. For analysis and planning only, not financial or investment advice.

Source: Forecourt Operator Pack - Fuel P&L, Stocktake, 13-Week Cash () Document, g59076599o70