Breakeven Point for Hotels

Description Amount

Revenues

Rooms 787,500

Food revenue 500,000

Beverage revenue 150,000

M.O.D 179,550

Rentals & Other income 10,000

Total revenue 1,627,050

Cost of sales

Food 180,000

Beverage 120,000

M.O.D 71,820

Total cost of sales 371,820

Cost of staff 420,000

Other expenses

Rooms 55,125

Food & Beverage 195,000

M.O.D 26,933

Total other expenses 277,058

Overhead other expenses

A & G 70,000

Sales & marketing 50,000

POMEC 100,000

Energy cost 185,000

Management fees 16,271

Total overhead other expenses 421,271

G . O . P 556,902

F.F&E 32,541

Incentive fees 55,690

Marketing fees 8,135

Francise fees 8,135

Net profit 484,941

No. of rooms in hotel 350 All inclusive/guest/day No. of days in month 30 OKNo. of rooms available 10500 Curruncy EURO

Occupancy % 30.0% Exch. RateNo. of rooms occupied 3150

Average room rate L.E 250 L.E

Duble Occupancy 1.9 Room 0.00

No. of guest 5985

20000

OR Food 0.00

17955

Average Check 25 Beverage 0.00% of bevere to food 30.0%

M.O.D Revenue per Occ. Room 30Rent & O. income Rev. /Occ. Room 0 M.O.D 0.00

OR Rent & O. income fixed amount 10,000

Cost of sales food % 36.0%

Cost of sales beverage % 80.0%

Cost of sales M.O.D % 40.0%

Staff / room 0.8

ORNo. of staff 300Cost / employee / month 1500

Rooms other expenses 7.0%

F&B other expenses 30.0%

M.O.D other expenses 15.0%

Fixed amount

70,000

No. of covers fixed number

No. of covers = # guest X 3

% of revenue OR 50,000

% for A&G other expenses 3.0% 100,000

% for sales other expenses 1.5% 100,000

% for POMEC other expenses 5.0% 85,000

Electricity consumption / available room 8

Water consumption / available room 10management fees % of total revenue 1.0%

F.F&E % of total revenue 2.0%

Incentive fees % G.O.P 10.0%

Marketing fees % of total revenue 0.5%

Francise fees % of total revenue 0.5%

Francise fees Fixed amount

Total Room Food Beverage Recriation Altra

0 0 0 0 00

7.35

EURO Ex. Rate

0.00 7.35

0.00 7.35

0.00 7.35

0.00 7.35

Breakeven Point for Hotels

Description Amount

Revenues

Rooms 227,700.00

Food revenue 284,985.18

Beverage revenue 72,839.16

M.O.D 24,463.26

Rentals & Other income 30,000.00

Total revenue 639,987.60

Cost of sales

Food 96,894.96

Beverage 54,629.37

M.O.D 19,570.61

Total cost of sales 171,094.94

Cost of staff 176,900.00

Other expenses

Rooms 31,878.00

Food & Beverage 21,469.46

M.O.D 10,763.83

Total other expenses 64,111.29

Overhead other expenses

A & G 70,398.64

Sales & marketing 12,799.75

POMEC 33,463.29

Energy cost 95,220.00

Management fees 3,199.94

Total overhead other expenses 215,081.61

G . O . P 12,799.75

F.F&E 12,799.75

Incentive fees -

Marketing fees -

Francise fees -

Net profit 0.00

0.00%

No. of rooms in hotel 138 All inclusive/guest/day No. of days in month 30 OKNo. of rooms available 4140 Curruncy EURO

Occupancy % 50.0% Exch. RateNo. of rooms occupied 2070

Average room rate L.E 110.00 L.E

Duble Occupancy 1.9 Room 55.00

No. of guest 3933

OR Food 72.46

0

Average Check 0 Beverage 18.52% of bevere to food 0.0%

M.O.D Revenue per Occ. Room 3

0 M.O.D 3.22

OR -

Cost of sales food % 34.0%

Cost of sales beverage % 75.0%

Cost of sales M.O.D % 80.0%

Staff / room 0.88

ORNo. of staff 122Cost / employee / month 1450

Rooms other expenses 14.0%

F&B other expenses 6.0%

M.O.D other expenses 44.0%

% of revenue OR Fixed amount

% for A&G other expenses 11.0% -

% for sales other expenses 2.0% -

% for POMEC other expenses 5.2% -

Electricity consumption / available room 15 -

No. of covers fixed number

No. of covers = # guest X 3

Rent & O. income Rev. /Occ. Room

Rent & O. income fixed amount

Water consumption / available room 8 - management fees % of total revenue 0.5%

2.00%

F.F&E % of total revenue 2.0%

Incentive fees % G.O.P 0.0%

Marketing fees % of total revenue 0.0%

Francise fees % of total revenue 0.0%

Francise fees Fixed amount

Total Room Food Beverage Recriation Altra

149.2 55 72.46 18.52 3.22149.2

0

EURO Ex. Rate