F&B Recipe Cost Control — Excel + BEUP Canvas

• Raw Materials – Key raw material price list. Update purchase prices, automatically calculate cost of goods sold per unit.
• Formulas Recipe quantities for each item. Automatically calculate ingredient cost, ingredient cost percentage and gross margin.
• Menu Engineering Automatic classification using the Kasavana & Smith method: Stars, Puzzles, Plowhorses and Dogs, with suggested actions.
• Purchases – Record inventory receipts, automatic unit conversion, linked to raw material price lists.
• Sales Record daily sales. Automatically pull selling prices from Recipes, then calculate revenue and COGS.
• Inventory Ledger Stock movement ledger, tracking inventory in real time with: Opening stock + Purchases - Usage.
• Stock Count – Reconcile system inventory vs actual inventory. Detect discrepancies early.
• Forecasting – Forecast inventory demand, alert for low stock levels.
• P&L Report – Automatic profit and loss reporting from sales and purchase data. No manual entry required.
• Dashboard Core KPIs: revenue, COGS, gross profit, ingredient cost ratio, top-selling items, inventory alerts and analysis charts.
• Suppliers – Manage suppliers, purchase prices, and order history.
• Settings System configuration, dropdown lists and named ranges.
• Cover, Guide, Chart Data – Cover page, detailed user guide, chart data.

Design: 15 connected sheets inside the workbook. Change an ingredient purchase price and every item-level ingredient cost ratio updates automatically. Enter sales, inventory decreases automatically and the P&L report recalculates.

• Restaurant, eatery and cafe owners Control COGS and profit for each menu item.
• F&B managers Track recipes, inventory and ingredient cost ratio.
• Central kitchens / cloud kitchens Manage multiple menus in one system.
• Catering services Track profit by event and by menu.
• Operations teams that need quick reporting Use Canvas to view the dashboard without opening Excel on mobile.

Scale: Suitable for teams of 5-50 staff and menus with 10-200+ items. Typical food cost benchmark: 28-35%.

• Template file (.xlsx) - blank structure, ready to use.
• Sample file (.xlsx) - includes cafe sample data for reference.
• 15 professionally linked sheets.
• Prebuilt and optimized Google Sheets template.
• Detailed instructions inside the Guide sheet.
• Access to the demo and companion dashboard on BEUP Canvas.
• Includes both English and Vietnamese versions.

1. Download the .xlsx file and open it in Excel, or copy it to Google Sheets.
2. Enter ingredients, recipes, selling prices and sales data.
3. The workbook calculates COGS, COGS%, profit and inventory alerts automatically.
4. Use the workbook dashboard for daily operations.
5. When you need a quick web view, open the BEUP Canvas demo or connect Google Sheets using the guide in the file.

• Minimum: Microsoft Excel 2016+ (Windows or Mac).
• Recommended: Excel 2021 or Microsoft 365.
• Google Sheets: compatible with the optimized Google Sheets template.
• BEUP Canvas: use a modern browser. If viewing the live dashboard from Google Sheets, the sheet must be published/shared as instructed in the workbook.

Does BEUP Canvas replace the Excel file?
No. Canvas is a companion dashboard for quick review and presentation. Excel / Google Sheets remains the place for data entry and operational records.

Is sales data sent to BEUP?
No. The dashboard processes the file/sheet in the browser. BEUP only serves the dashboard app and does not store your sales data.

Does a small shop with under 10 staff need this?
Yes. The smaller the shop, the thinner the margin - a 5% food cost variance can be the difference between profit and loss.

How is this different from POS software?
POS records sales transactions. This system controls COGS - calculating ingredient cost by item, analyzing profit and controlling inventory. The two systems complement each other.

Is there an English version?
Yes. Choose the English or Vietnamese version when ordering. The Bundle includes both.

Are formulas protected?
Sheets are protected, but you can unprotect them without a password to inspect or edit.