Preview How to Analyze and Calculate the Breakeven Point for the Hospitality Industry

Course Intro to Breakeven Point Analysis

What is Breakeven Point

Practical Example to Understand Formula and Calculation

Putting Calculations in Excel and Scenario Planning

What are assumptions of Breakeven and how they can go wrong

Sensitivity Analysis of Breakeven Point assumptions

Gather Data for Hotel P&L

Establish Relation ship in P&L Items to understand Business better

Starting Model with revenue segregation and setup

Modelling Cost of Sale and Payroll Expenses for Rooms, F&B and others

Modelling Other department expenses, Common shared expenses and other items

Other Hotel expenses, depreciation and Tax

Playing around to calculate Breakeven points with different combinations