Restaurant Profitability Excel Spreadsheet

I own a restaurant and need a clean, well-structured Microsoft Excel workbook that tells me, at a glance, how many menu items I must sell each day to cover costs and turn a profit. The model has to let me enter or update my fixed costs (rent, payroll, utilities, marketing), variable costs per dish, and selling prices. From those inputs it should automatically calculate and clearly display the daily break-even point as well as projected profit or loss for any sales volume I type in.

Day-to-day I want to track three core metrics—Daily sales, Cost of goods sold, and Net profit—so the sheet should keep those figures front and center. A simple dashboard or summary tab with colour-coded indicators and a couple of charts would be ideal. I’m still on the fence about full inventory tracking; if you can propose a lightweight section or plug-in sheet that can be toggled on or off, I’m open to that.