COFFEE SHOP Profitability Calculator (Editable Excel Spreadsheet)
COFFEE SHOP Profitability Calculator (Editable Excel Spreadsheet)
COFFEE SHOP Profitability Calculator (Editable Excel Spreadsheet)
COFFEE SHOP Profitability Calculator (Editable Excel Spreadsheet)

COFFEE SHOP Profitability Calculator (Editable Excel Spreadsheet)

Regular price £5.00
Unit price  per 
Tax included.

Customisable Excel spreadsheet download.

This document lets you forecast your profitability based on footfall and expected daily, weekly & monthly transactions. 

Values you are able to customise: 

-Yearly footfall

-Spend per transaction

-Cost of goods %

-Operational cost %

-VAT %

DISCLAIMER: This document is just a guide, the notes are just guidance based on industry averages and personal experience. All coffee shops/ restaurants numbers will vary and you can customise these important values highlighted in blue in the below table.
YEARLY FOOTFALL section is customisable: Having an overarching footfall figure of the area you are looking at can give you a goal on what percentage of people you can impact.
Notes: Average coffees sold vs footfall at train station locations is between 1-3%, this model can loosely be replicated on the high street but factor in competition and local population.
COST OF GOODS section is customisable: Average COGs in a UK Cafe is c25%
Notes: This may vary widely depending on what you offer, if you prepare food in house or roast your own beans your margins may be higher, consider factoring wastage up to 5-15% of food.
SPEND PER TRANSACTION section is customisable: Drinks only UK average is £3.50 - £5.00 per transaction, to include food the average spend per transaction is between £8.00 & £10.00
Notes: This is an average, factor in that many people will buy more than one drink/ food item per transaction, this is not a per head value but per transaction.
OPERATIONAL COST section is customisable: Average operational costs make up c40% of revenue (not including COGs). This may vary with rent prices and staffing mostly, depending on location.
Notes: Rent should make up around 10% of revenue. COGS and operational costs together, which includes salaries, should make up a total of around 65% of revenue.
Notes: Assuming you expect to turn over more than £90k PA, VAT will take up around 20% of your revenue. Do note that some items you sell will not be applicable for VAT, so this figure may be less overall
Data assumes an average net margin of c15%, this can fluctuate with operational efficiency
Max Coffee Making Output Per hour on a 2 group machine: 175-200
Max Coffee output per 8 hour day on a 2 group machine: 1400-2400
Notes: This is assuming 2 baristas working flat out on a typical professional grade 2 group machine