Фин-модель кафе и ресторана — Excel: выручка, food cost, точка безубыточности

Фин-модель кафе и ресторана — Excel: выручка, food cost, точка безубыточности

📦 FORMAT · VERSION · GUARANTEE — the essentials before you buy
• Contents: ZIP: XLSX with live formulas + INSTRUKCIYA-RU.pdf
• Version: September 2026
• Requirements: Excel 2016+ or Google Sheets; no macros
• Delivery: automatic, sent to your e-mail right after payment
• Guarantee: the product matches its description. If something is wrong — send a private message, we will sort it out or refund you.
• Terms: for personal use; resale is prohibited.

A READY-MADE CAFE AND RESTAURANT FINANCIAL MODEL IN EXCEL — change the yellow cells, profit calculates itself

Check whether the venue is viable before signing the lease: revenue by day of the week, food cost, payroll with taxes, fixed costs, net profit and the break-even point in guests per day. All formulas are live — 5 sheets recalculate instantly.

WHAT´S INSIDE:
• "Parameters" sheet — 13 input numbers (average check, traffic, food cost, staff, rates, rent, marketing, tax)
• "Revenue" sheet — the monthly plan: weekdays / Friday / weekends, guests and rubles
• "Costs" sheet — variable and fixed, payroll with 30% social contributions
• "P&L" sheet — gross margin, net profit/loss, profitability + break-even calculation in guests per day
• "Dashboard" sheet — 7 key numbers for your morning briefing
• PDF instructions: how to fill it in in 10 minutes and what to do with the result

WHO IT´S FOR:
• Opening a cafe, coffee shop or restaurant — check the economics before you invest
• Already operating — see where you lose money: food cost, payroll or traffic
• Preparing a business plan for a partner or a bank

HOW TO START:
1. Pay — the file arrives automatically
2. Fill in the yellow cells on the "Parameters" sheet (10 minutes, numbers from your till)
3. Watch the P&L sheet and the Dashboard — profit and break-even recalculate on their own
4. Run scenarios: raise the average check by 50 ₽ — see the effect on profit

Standard formulas: Excel, Google Sheets, LibreOffice. Guarantee: replacement or refund. Updates free forever.


⟶ THE WHOLE SYSTEM: this product is part of the RESTAURANT OS bundle (30 SOPs + financial model + weekly management cycle) for 299 ₽ instead of 448 ₽ — plati.market/itm/6097348
⟶ 30 SOP regulations for cafes and restaurants: plati.market/itm/6094065
⟶ Checklist for launching a product on Plati.Market: plati.market/itm/6095487

SEE ALSO:
• Food Cost Calculator PRO: dish costing, food cost and pricing (Excel + HTML) — plati.market/itm/6197070