arrow_back
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