Wine Cellar Hotel Break-Even Analysis: $423K Monthly Revenue

Fixed costs $347.2K/mo monthly base

Contribution margin 94% after variable costs

Break-even revenue $369K/mo monthly target

Break-even timing Month 2 launch ramp

Break-even calculator

Test whether monthly room revenue and wine-driven income cover direct costs and fixed overhead.

Lean Base Full

Monthly revenue Revenue from rooms, wine sales, events, spa, and bar sales sets the margin available to cover fixed costs. $ Lower sales Higher sales Variable expenses These are the direct costs that rise with guest revenue, including wine inventory, food and beverage cost, commissions, and guest supplies. $ Lower direct cost Higher direct cost

Money available to cover fixed costs $629,117 $754,339 revenue - $125,222 variable expenses

Margin ratio

83%

Covers fixed costs

Yes

Fixed monthly costs This is the monthly overhead base that revenue has to cover before profit starts. $ Lower overhead Higher overhead

Break-even chart Revenue Total costs

Which hotel expenses are fixed, and which move with sales?

Cost classification

Break-even is only useful if fixed overhead stays separate from costs that rise with occupied rooms and guest spend. Treating wine inventory, guest supplies, and commissions as fixed overhead will overstate margin coverage.

Expense	Cost	Break-Even Treatment	Common Mistake
Property Lease Mortgage	Fixed	Use $150,000 per month in fixed overhead from Month 1 through Month 60.	Spreading it per room night and masking the true monthly hurdle.
Property Taxes Insurance	Fixed	Use $30,000 per month as fixed overhead in the operating break-even model.	Linking it to occupancy when the model gives a stable monthly amount.
IT Systems Software	Fixed	Use $10,000 per month as a fixed platform and systems expense.	Treating software as a booking-driven fee without model support.
Utilities	Semi-variable	Start with the $25,000 monthly base, then watch usage as occupancy rises from 55% to 82%.	Putting all utilities in fixed overhead and missing higher occupied-room usage.
Front Desk Staff and Restaurant Bar Staff	Semi-fixed	Model as staffing steps because front desk FTE rises from 4.0 to 5.0 and restaurant bar FTE rises from 8.0 to 10.0.	Assuming labor moves smoothly with every extra booking.
Wine Inventory Cost	Variable	Apply as 7.0% of revenue in the first year, falling to 5.0% by the fifth year.	Treating wine purchases as fixed overhead instead of sales-linked margin drag.
Marketing Sales Commissions	Variable	Apply as 3.0% of revenue in the first year, easing to 2.5% by the fourth year.	Budgeting commissions as a flat monthly line and overstating contribution margin.
Guest Amenities Supplies	Variable	Apply as 2.0% of revenue in the first year, falling to 1.5% in later years.	Classing guest supplies as fixed when higher occupancy drives more usage.

How does break-even change from a lean opening to a full launch at this wine cellar hotel?

Scenario table

Break-even improves as occupancy rises because room revenue and ancillary sales grow faster than fixed costs. The variable cost rate also falls from 18.0% to 15.2%, so the profit cushion widens.

Planning assumptions only; actual results will move with room mix, occupancy, and event demand.

Scenario	Monthly Revenue	Variable Costs	Fixed Costs	CM Ratio	Operating Profit	Break-Even Signal
Lean launch	$790,000	$142,200	$347,000	82.0%	$300,800	Clears fixed costs, but the cushion is the smallest.
Base case	$843,000	$139,938	$351,000	83.4%	$352,062	Stronger coverage, with less break-even risk.
Full launch	$1,011,000	$153,672	$364,000	84.8%	$493,328	Largest cushion if weekends and events stay strong.

What breaks the break-even plan if early demand softens or costs creep up?

Stress test

The base plan has a wide monthly cushion: about $675,000 in revenue versus roughly $423,000 to break even. The model only turns red when a slow opening month hits at the same time as higher fixed costs and weaker contribution margin.

Stress Case	Changed Assumption	Break-Even Revenue	Revenue Gap	Risk Signal
Current plan	Base monthly revenue stays around $675,000, with an 82% contribution margin and $347,000 in fixed costs.	$423,000	$252,000 cushion	The opening plan clears break-even by a wide margin.
Revenue shortfall	Monthly revenue falls 20% to about $540,000 while costs stay the same.	$423,000	$117,000 cushion	Demand softens, but the model still stays profitable.
Fixed-cost pressure	Fixed costs rise 10% to about $382,000 per month.	$465,000	$210,000 cushion	Overhead moves up, so the break-even line shifts higher.
Margin pressure	Variable costs rise 5 points, cutting contribution margin to 77%.	$451,000	$224,000 cushion	Cost inflation trims room, but the plan still has cover.
Combined pressure	Revenue falls 30%, variable costs rise 5 points, and fixed costs rise 10%.	$496,000	$24,000 gap	This is the first case that flips the month to about an $18,000 loss.

Can the 50-room hotel cover its fixed load before you sign the lease and buy wine inventory?

Founder checklist

Proceed only if the 50-room setup can hold the Year 1 55% occupancy plan and the $115K monthly ancillary target lands on time. If the $240.5K monthly fixed load or the Month 10 cash trough looks soft, delay the lease and stage the buildout.

1Occupancy Proof55% / 50 rooms

Verify the 50-room mix can support the Year 1 occupancy plan, because room nights have to show up before the lease is safe.

2Fixed Load$240.5K/mo

Confirm lease, utilities, taxes, maintenance, IT, security, and admin spend stay inside this monthly base so fixed costs do not outrun demand.

3Margin Stack82% CM

Check that wine inventory, food and beverage, marketing commissions, and guest amenities stay near model, because margin slips hit break-even fast.

4Ancillary Sales$115K/mo

Test restaurant bar, events, spa wellness, and wine sales against the Year 1 target so these add-ons help carry the monthly burn.

5Payroll Ramp$1.28M/yr

Lock the hiring plan to the opening-month demand curve so staffing supports service without getting ahead of guests.

6Cash TroughMonth 10

Keep cash through the $2.664M low point and stage the $5.375M capex plan so the $1.0M wine inventory buy does not squeeze launch liquidity.