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

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
Paid and complimentary guests, included food consumption, seating and buffet replenishment limits. Monetary inputs and sales use USD; operating volumes retain their labelled units. Forecast years are 2027–2031.
Enlarge image in a new tab
Food and other direct-cost categories, variable expense shares and fixed operating expenses. Monetary inputs are USD; the annual percentage columns are cost shares of revenue.
Enlarge image in a new tab
Monthly income statement for 2027–2031, in USD. This is an income statement view; it does not show payroll setup inputs. Enlarge to inspect the wide monthly table.
Enlarge image in a new tab
Asset categories, purchase dates and spending assumptions in USD. The total includes every scheduled purchase shown, including later replacements where present.
Enlarge image in a new tab
Excerpt from Returns: cumulative project free cash flow and first payback, if reached. 2027–2031 base case; dollar amounts in thousands.
Open full Returns view in a new tab
Excerpt from Returns: revenue, annual and monthly break-even revenue, and EBITDA. 2027–2031 base case; dollar amounts in thousands.
Open full Returns view in a new tab
Six annual financial-driver charts for All-You-Can-Eat Buffet Restaurant, 2027–2031 (Base scenario). Dollar amounts are in thousands; margins and cost mix are percentages.
Enlarge image in a new tab8 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.
| Planning area | Inputs you review | How they connect | Results to inspect |
|---|---|---|---|
| Guest mix | 220 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 consumption | Adult 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 losses | 90% 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 capacity | 50 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 typesHow this business makes money
Connect the unit sold to the resources required by this operating case.
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.
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
- Measure repeat portions and loss stages separately instead of applying a single unexplained food percentage.
- Include complimentary guests in seating, food and consumables.
- 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.
- 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.
Replace tariffs, guest mix and first/repeat food quantities with the intended offer.
Validate seat times, cooking output and replenishment workload under real service conditions.
Quote the buffet line, warewashing, premises and staffing commitments.
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.
Other restaurant types
Each operating type calls for its own financial structure.
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.

