Exercise Basic Formulas blank(1) (2) - Excel sahil tiwari ST File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do 2. Share Calibri - 12 == 2 Wrap Text AutoSum - General 47 X out Copy * Format Painter Paste BIU - A = = = E Merge & Center - Insert Delete Format Conditional format as Cell Formatting Table Styles Styles Olcar Sort & Find & Filter Select Eciting Font Alignment Nume 331 B G H D Key RM Calculations AQUARIUS HOTEL FORMULAS Revenue: Profit: ROI: ADR: Occi RevPar: 600 260 120 at the F.0.) 500 $185 3 70% of revenue 1 $60 65 90% of revenue 10,00,00,000 Number of units sold x unit price Revenue expenses Return / original investment Total room revenue / total rooms sold Total number rooms sold / total rooms available for sale x 100 Total room revenue / total available rooms for sale *%E55EU FACTS INumber of rooms Number of employees 10 Number of rooms sold daily 11 ADR 12 Rooms Ooo - Out of order Overall room expenses 14 Number of restaurants 15 Restauant average check 16 Number of daily covers sold 17 Overall restaurant expenses 18 Initial owner investment 19 Please indicate for 92 91 days) 21 Occ% 22 Room revenue 23 RevPar 24 Room Profit 25 Number of covers suld 26 Restaurant revenue 27 Restaurant Profit 28 Overall Hotel Profit 30 311 Sheet1 Read LO ENG IN 05:38 PM 25-01-202209