Restaurant Financial Model: All-You-Can-Eat Buffet Restaurant

Connect buffet admission, complimentary guests, repeat portions, food losses and replenishment labor to revenue, investment and monthly cash.

  • Excel (.xlsx)
  • Footprint: 3,200 sq ft / 90 seats
  • Schedule: Nine hours Tuesday–Sunday
  • Opening: March 2027 / six-month demand ramp
  • Billing and production: Paid admission / prepared food kilograms

Planning several types? Compare 17 restaurant formats

Workbook preview, read-onlyr01
All-You-Can-Eat Buffet Restaurant workbook: dashboard.
Dashboard

Base-case scenario controls, annual financial results and charts for 2027–2031. Financial report amounts are shown in thousands of USD; percentage measures retain their own units.

Enlarge image in a new tab

8 selected worksheet views. Figures show this workbook’s starting case.

Workbook availability

What is inside the Excel model

Plan fixed admission alongside repeat portions, complimentary guests and staffed buffet capacity. Trace separate food losses, paid labor and opening investment through monthly profit and cash.

Selected worksheets from the documented workbook. Forecast period: January 2027–December 2031. Model reference: PHY001-08.

Inputs you control. Results you can inspect.

On a small screen, scroll within the table to read every column.

Inputs and outputs for the all-you-can-eat buffet restaurant workbook.
Planning areaInputs you reviewHow they connectResults to inspect
Guest mix220 adult, 55 paid-child and 20 complimentary mature daily requests.Calendar dates and a 60% initial launch factor determine requests.Paid and free visits before shared capacity limits.
Admission$22 adult and $11 child inclusive starting prices.Fulfilled paid visits earn their tariff once.Admission revenue; refills earn no separate sale.
Food consumptionAdult 0.80 kg; child 0.45 kg; complimentary guest 0.25 kg.First and repeat portions create total consumed food.Consumption across all guest classes.
Food losses90% preparation yield; 10% holding/plate loss; $6/raw-equivalent kg.Consumption is grossed up through distinct loss stages once.Prepared output, ingredient withdrawal and stock.
Staffed capacity50 prepared kg/hour kitchen and buffet; two replenishment minutes/kg.Seats, productive cooks and funded replenishment constrain all classes.Whole fulfilled visits and workload.
Cash funding$553,300 initial CAPEX; $551,000 equity; $250,000 debt.Monthly spending and cash generation establish the funding trough.Reserve coverage and project recovery.

Is this the right model for your business?

Check the starting case before changing the assumptions.

The starting operation

  • An independent buffet charging fixed adult and child admission for unlimited included food.
  • A planning team separating paid attendance from the consumption and capacity used by complimentary guests.
  • An operator evaluating cooking, replenishment, dining time and food losses together.

Check the boundary

This case excludes pay-by-weight sales, takeout, delivery, alcohol, franchise royalties, tips and separately billed refills.

Compare the other restaurant types

How this business makes money

Connect the unit sold to the resources required by this operating case.

Analysis

Revenue logic
Paid adult and child visits multiplied by their inclusive admission tariffs.

Admission earns revenue once; refills and complimentary guests consume resources without another sale.

What customers pay for

Parties pay for admission; card fees use paid-party transactions rather than all guest visits.

What limits sales

  • Every guest uses seat time, including complimentary visitors
  • Cooking equipment and productive cooks limit prepared kilograms
  • Installed buffet throughput and paid replenishment limit food service

Costs to plan for

  • Ingredients for first portions, refills and complimentary guest consumption
  • Separate preparation loss and holding or plate loss allowances
  • Paid owner, cooks, replenishment, floor and warewashing staff
  • Consumables for all guests and processing fees on paid receipts
  • Rent, utilities, maintenance and other recurring premises costs

Scope and expansion

  • Test admission tariffs alongside consumption and guest mix
  • Fund replenishment and cooking capacity before serving more guests
  • Check seating time and loss rates as attendance increases

Why does a buffet need separate attendance and food-consumption drivers?

Admission prices determine revenue from paid guests, while food consumption comes from everyone served. Repeat portions and free visits can raise kitchen, replenishment and ingredient requirements without adding another admission. This design therefore tests seats and prepared kilograms together rather than multiplying one average check by unlimited physical capacity.

Paid admission
Adult and child tariffs; no refill revenue
Consumption
First/repeat portions plus complimentary guests
Capacity
Seat-minutes, kitchen output and staffed replenishment

What to establish for your own operation

  1. Measure repeat portions and loss stages separately instead of applying a single unexplained food percentage.
  2. Include complimentary guests in seating, food and consumables.
  3. Match the replenishment crew to prepared kilograms, then test the effect of longer visits.

Follow the plan from demand to cash

Open each section for the assumptions, calculations, and limits of this workbook’s starting case.

Earn admission once and serve every guest's portionsRevenue

The restaurant starts with $22 adult and $11 child admission, including dessert and soft drinks. Complimentary visits generate no revenue but occupy seats and consume food. Adults request 0.50 kg first portions plus 0.30 kg repeats; children use 0.30 plus 0.15 kg. Free guests consume 0.25 kg. These are selected food-equivalent quantities, not measured customer appetites.

All classes share seat-minutes, kitchen output and buffet replenishment. Adult visits use 65 seat/reset minutes; children and complimentary visits use 55. Prepared-food demand accounts for holding loss before applying the installed and paid-labor limits. One proportional fulfillment fraction allocates visits across the three groups.

  • Nine-hour service runs Tuesday–Sunday; Monday is closed.
  • March demand begins at 60% and reaches 100% in the sixth active month.
  • Whole-visit rounding can leave capacity unused; there is no peak-queue or individual-serving simulation.
Keep food loss and replenishment labor visiblePayroll

The initial $6/raw-equivalent kg basket allocates $3.40 to protein, $1.60 to grains/vegetables and $1 to dessert/drink ingredients. Preparation yield of 90% and holding/plate loss of 10% apply at different stages. Raw withdrawal equals consumption plus those two losses. Plate leftovers are already included in the holding/plate allowance.

Paid staffing starts at 12.5 FTE and grows to 14.7. Three production cooks and two replenishment FTE initially supply distinct resource budgets; dining attendants, cashier/host and dishwashing are paid separately. Owner pay begins in January at $74,880 annually. The 10.65% employer load and $1,800 monthly welfare pool both enter costs.

  • All visits use $0.20 starting consumables; free guests do not create a payment transaction.
  • Card processing assumes 2.4 paid visits per party, 90% card share and a gross-tender cost multiplier.
  • Initial rent/CAM is $8,000/month and utilities $3,840/month; both are planning allowances.
Fund the buffet line, warewashing and cash reserveCAPEX

Initial CAPEX is $553,300, including $50,300 spent contingency on $503,000 base capital. The selected reused-shell fitout is $256,000. Cooking, hot/cold holding, refrigeration, ventilation, warewashing, tableware and the admission counter are separate assets. Replacement investment is $20,000 in January 2030. The installed budgets require supplier and premises validation.

January financing totals $801,000: $551,000 equity plus $250,000 conventional debt. The assumed loan is 10% fixed over 84 monthly annuity payments, without grace; the $7,500 fee is expensed. A −$440,191 cash trough without equity already includes debt service, capital, startup losses and working capital. Equity covers it plus a $110,000 reserve, rounded up to $1,000.

  • The reserve remains a cash balance; the spent capital contingency is a separate item.
  • The physical stock supplement targets seven calendar days of raw withdrawal.
  • Financial inventory retains the existing allocated-food-cost method, so physical and financial stock can differ slightly.
Compare early operating progress with capital recoveryCF

Base 2027 revenue is $1,256,200 from 68,056 total visits, including 4,612 complimentary guests. EBITDA is $79,228, but net income is −$18,928 after depreciation and interest. Positive EBITDA therefore does not establish an accounting profit in the launch year.

Monthly EBITDA and operating cash become sustainably nonnegative in May 2027; EBIT follows in June. Project payback is May 2029, month 29, using cumulative undiscounted unlevered free cash flow from January 2027. The 60-month EBITDA total is $2,453,026, dependent on the selected attendance growth and staffing efficiency.

  • Minimum funded Base cash is $110,809 in May 2027.
  • Low monetary stress produces $46,607 minimum cash with funding unchanged.
  • Project recovery excludes financing and terminal proceeds; no shareholder distributions are scheduled.

Selected results from the starting case

Modeled results in USD unless stated otherwise. These describe the selected inputs, not an estimate for your location or a guaranteed outcome.

Modeled case
2027 revenue
$1,256,200USD, Base case; paid adult and child admissions after March opening.
2027 all guest visits
68,056Includes 50,756 adults, 12,688 paid children and 4,612 complimentary guests.
2027 net income
−$18,928Base accounting loss despite positive $79,228 annual EBITDA.
Minimum cash
$110,809Funded Base monthly balance in May 2027.
Project payback
May 2029 / month 29First cumulative undiscounted unlevered project FCF crossing; no later reversal.
Low-case minimum cash
$46,60760-month monetary price/cost stress, retaining original financing and physical visits.

Make the case your own

Work from the operating plan toward the cash requirement.

  1. Replace tariffs, guest mix and first/repeat food quantities with the intended offer.

  2. Validate seat times, cooking output and replenishment workload under real service conditions.

  3. Quote the buffet line, warewashing, premises and staffing commitments.

  4. Review food-mass movements, monthly cash and the distinct operating and payback milestones.

Interpretation and scope
  • National planning assumptions do not establish a local tariff, code-approved layout or demand forecast.
  • Food-equivalent kilograms do not provide item-level recipes, spoilage tracking or food-safety instructions.
  • Annual expense shares reconcile yearly unit costs but can approximate monthly costs when guest mix changes.
  • The 25% blended tax assumption specifies no jurisdiction and carries no losses forward. Later margins are scenario outputs.

The workbook is an Excel file for local planning. Learn how to interpret assumptions and evidence.

Each operating type calls for its own financial structure.

Compare all 17

Questions

Do repeat portions earn more revenue?

No. Included refills increase consumption and workload; the paid guest's admission is recognized once.

Are complimentary guests free to serve?

No. They occupy seats and consume food and supplies, even though they generate no admission or direct payment fee.

Are the two 10% loss assumptions duplicates?

No. Preparation loss affects raw ingredients; holding/plate loss affects prepared food. Each stage is applied once.

Why is replenishment a capacity limit?

Food must move through the buffet during service. The model limits output by installed holding throughput and a separately paid replenishment crew.

Is all food purchased immediately expensed twice through inventory?

No. The physical stock supplement tracks withdrawal and replenishment. It does not create a second ingredient expense.

Why can 2027 EBITDA be positive while net income is negative?

Depreciation and interest sit below EBITDA. The saved Base results are $79,228 EBITDA and −$18,928 net income.

Does payback in May 2029 describe a dividend?

No. It is project cash recovery before financing, without terminal proceeds. The case retains cash and schedules no distributions.

Can I buy this model now?

No. Purchasing and workbook downloads are not available on this site.

Which software does the workbook use?

The documented file is an Excel workbook (.xlsx). Compatibility with other spreadsheet applications is not established by the file extension.

Evidence and scope

Primary operator examples support only the operating features described in the source registry. This full configuration, all formulas, local feasibility and numerical economics remain analyst-authored and unverified.

The links below provide operating-format context; they do not verify the workbook’s selected inputs or calculated returns.

The workbook guide and figures describe model PHY001-08, revision r01, for January 2027–December 2031. These are a documented planning case, not observed results for a particular business.

Read our methodology and how to read financial assumptions.