Restaurant and café
Select a workbook for sample calculations and steps for using your own data.
50 workbooks
Restaurant and Café Pack
TRY 499 · One payment · 50 downloadable Excel workbooks
The price includes new workbooks added to this pack in the 12 months after purchase. You can still download the files added to your account during that period.
Purchase information- Menu item · Unit costing
Calculate direct input and labour cost per unit. Compare unit cost against target and contribution against net sales.
- Menu item · Capacity and bottlenecks
Combine cycle time, setup and downtime to find workload and the hours still uncovered after overtime.
- Menu item · Backlog and throughput
Reconcile new, completed and cancelled work. Find open workload and records at risk of missing deadlines.
- Menu item · Stock and replenishment
Find stock position from physical, inbound and reserved units. Round the replenishment order to full cases.
- Menu item · Scenario planning
Change volume, income and cost drivers. Compare base and alternative outcomes under loss and capacity constraints.
- Menu item · Budget and commitments
Forecast closing spend from the approved budget, actuals and commitments. Stress-test the uncommitted forecast.
- Menu item · Loss and rework
Separate first-pass yield, scrap and rework. Compare the cost of corrections and returns.
- Menu item · Receivables aging
Group outstanding balances using due dates and offsets. Identify priority records past the follow-up threshold.
- Menu item · Staffing and coverage
Find the gap between required and staffed hours. Review shift cost including breaks and added staffing costs.
- Menu item · Maintenance schedule
Track maintenance using calendar and meter thresholds. Review overdue assets and planned downtime costs.
- Menu item · Utilisation and yield
Read available capacity, utilisation and revenue per capacity unit together. Quantify unused capacity.
- Menu item · Energy and demand
Combine day, peak and night use with tariff rates and demand overage. Estimate the impact of load shifting.
- Menu item · Conversion funnel
Track enquiries, offers and wins for the same cohort. Compare the weighted value of open offers.
- Menu item · Retention and renewals
Separate churn, expansion and contraction in the existing base. Read closing revenue alongside retention.
- Menu item · Supplier comparison
Compare total acquisition cost, delivery and quality rates. Find records below the weighted-score threshold.
- Menu item · Service and delivery SLA
Measure first response and resolution against separate targets. Review elapsed time and the amount at risk at the reporting cut-off.
- Menu item · Cash flow calendar
Roll closing cash into each following week. See cash flow excluding financing and any reserve shortfall.
- Menu item · Investment appraisal
Discount cash benefits, residual value and working capital. Compare investments using net present value.
- Ingredient substitution and recipe yield
Compare alternatives when purchase price, usable yield, and serving weight change together.
- Batch shelf life and FEFO priority
Track remaining shelf life, expected consumption and stock rotation by batch.
- Interbranch inventory transfers
Balance receiving shortages against donor reserves, transport costs, and shelf life.
- Lot traceability and recall reconciliation
Reconcile received, used, quarantined, and recovered quantities for affected lots.
- Purchase order, receipt, and invoice matching
Find differences between ordered price, received quantity, and invoiced quantity before payment.
- Supplier terms and early-payment discounts
Compare prompt-payment discounts with the alternative cost of cash.
- Bank and card-terminal reconciliation
Match expected net deposits with bank transactions by settlement batch.
- Till handover and cash variance
Reconcile physical counts, POS activity and cash drops by shift.
- Delivery platform deduction audit
Check commissions, service fees, and merchant-funded promotions by order or settlement batch.
- Delivery contribution and basket threshold
Calculate order contribution and the minimum basket needed to earn a target contribution.
- Tip pool and shift allocation
Allocate each shift’s tip pool by eligible hours and role weights.
- Sales and labour by service interval
Compare sales, staffing load, and labour ratio by service interval.
- Reservation no-shows and seating capacity
Compare reservations and walk-ins with expected no-shows and seat turnover.
- Catering quote and contract margins
Compare event quotes with target margin, guaranteed attendance, and variable service costs.
- Bakery batch production planning
Plan daily demand, batch yield, carryover, and oven capacity together.
- Coffee dose and shot loss
Connect good shots, dial-in loss, and recipe dosage to bean cost.
- Bar stock and beverage yield reconciliation
Reconcile theoretical usage from served drinks against measured closing stock.
- Absence and shift cover costs
Estimate role coverage gaps and budget impact after expected absences.
- Card processing contract comparison
Compare two merchant agreements by fees, fixed charges, and settlement delays.
- Branch profit and loss variance bridge
Bridge budget to actual operating profit using volume, price, unit cost, and branch overhead.
- New branch opening budget and delays
Compare setup cost, actual spending, and delay costs with funding available for opening.
- Complaint resolution and recovery costs
Track resolution time, recovery spend, and the impact of recurrent complaints.
- Theoretical versus actual ingredient usage
Derive recipe usage from POS quantities and isolate unexplained variance after waste and transfers.
- Catering deposits, balances, and collections
Track deposits, interim collections, and paid supplier costs by event.
- Packaging use and replenishment
Plan packaging from order mix, case size, safety stock, and available stock.
- Digital campaign incremental contribution
Evaluate a campaign using incremental orders, coupons, and contribution.
- Critical equipment downtime decision
Compare expedited and standard repair with lost contribution for the same incident.
- Cold-chain exceptions and follow-up
Track measurement exceptions and open actions against the site’s own limits.