Check your food and labour costs every week

The problem

Many cafés find out they lost money months later. A weekly look at sales, food cost and wages shows trouble while you can still fix it.

What AI does

AI sets up a simple weekly spreadsheet that compares your sales with what you spend on food, drink and wages, so you can see the trend. You or your accountant set the targets, and the decisions are yours.

Time

The steps, in short

1. Decide which weekly figures you will record from your till, invoices and payroll.
2. Have AI build the sheet with formulas, once.
3. Add one row each week.
4. Look at the trend over several weeks before you make any change.

A short sample prompt

Build a simple weekly spreadsheet for my café that compares sales (excluding VAT) with food and drink purchases and wages, as a share of sales, plus a running average. Highlight any week over my target of [your target]. Give the formulas.