0% found this document useful (0 votes)
51 views47 pages

F&B Revenue Analysis - Jan-Feb 2022

Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
51 views47 pages

F&B Revenue Analysis - Jan-Feb 2022

Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

FO

TODAY REVENUE - 31 JAN 2022


NO OUTLET
FOOD BEVERAGE
1 SWISS CAFÉ- ALA CARTE
2 SWISS CAFÉ - BREAKFAST 0
3 SWISS DELI 0
4 SAWAK LOUNGE
5 IN ROOM DINNING
6 BANQUET 0
TOTAL 0 0
0

F&B ACTUAL VS B

NO OUTLET REV VS BUDGET

ACTUAL SWISS CAFÉ - ALA CARTE 0


1
BUDGET SWISS CAFÉ - ALA CARTE 34,372,285

ACTUAL SWISS CAFÉ-ROOM BREAKFAST 0


2
BUDGET SWISS CAFÉ- ROOM BREAKFAST 165,754,675

ACTUAL - SWISS DELI 0


3
BUDGET - SWISS DELI 0

ACTUAL - SAWAK LOUNGE 48,565,698


4
BUDGET -SAWAK LOUNGE 88,963,870

ACTUAL - IN ROOM DINNING 0


5
BUDGET - IN ROOM DINNING 57,226,706

ACTUAL-BANQUETE 202,603,308
6
BUDGET - BANQUETE 255,625,000
ACTUAL-FB OTHER 20,578,513
7
BUDGET-FB OTHER 25,000,000
F & B ACTUAL REVENUE 271,747,519
F&B MONTHLY BUDGET 626,942,536

ACTUAL MTD-FB SERVICE CHARGE 65,463,630


8
BUDGET MONTHLY -FBSERVICE CHARGE 62,694,254
2,769,376

WHOLE BUDGET 689,636,790


ACTUAL 337,211,149
DIFF -352,425,641

48.90%
-51.1%
FB OUTLET FORECAST
1 SWISS CAFÉ- ALA CARTE 0
2 #REF! 0
3 #REF! 1,942,628

4 #REF! 0

TOTAL 1,942,628
FORECAST 11,655,768
TOTAL TARGET 60,221,466
FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - AUG 20
UE - 31 JAN 2022 MTD REVENUE
TOTAL FOOD BEVERAGE
0
0 0
0 0
0 20,266,116 28,299,582
0
0 199,876,035 2,727,273
0 220,142,151 31,026,855
0 RENTAL 2,314,050

F&B ACTUAL VS BUDGET REVENUE - FEB 2022


MTD AUG 2022 - HOTE
DESCRIPTION % ACT ACTUAL
ROOM 67.66% 1,037,281,719
FB 16.38% 251,169,006
LAUNDRY 1.26% 19,329,174
SPA 1.43% 21,923,133

BISNIS CENTER 0.03% 465,692


TELECOMUNICATION 0.00% 0
OTHER 1.59% 24,439,896
SERVICE CHARGE 11.64% 178,417,469
TOTAL 100.00% 1,533,026,089

180,562,861
REVENUE ANALYSIS - AUG 2022 SWISS-BELHOTEL MERAUKE
EVENUE MTD BUDGET REVENUE
TOTAL FOOD BEVERAGE TOTAL
0 0
0 0 0
0 0 0 0
48,565,698 0
0 0
202,603,308 0
251,169,006 0 0 0
MTD AUG 2022 - HOTEL REVENUE
BUDGET % BUDGET VAR ACHIEVEMENT
966,568,640 81.40% 70,713,079 107.32%
0 0.00% 251,169,006 #DIV/0!
19,723,226 1.66% -394,052 98.00%
24,145,735 2.03% -2,222,602 90.80%

201,613 0.02% 264,079 230.98%


161,290 0.01% -161,290 0.00%
25,000,000 2.11% -560,104 97.76%
151,639,932 12.77% 26,777,537 117.66%
1,187,440,436 100.00% 345,585,653 129.10%

FB MTD VS BUDGET (ACHIEVEMENT) 40.1%


F&B - ACT YTD VS BUDGET YTD #REF!
ROOM - ACT YTD VS BUDGET YTD 6,354,033,315
HOTEL- ACTUAL YTD VS BUDGET YTD 13,308,340,946
E
VAR
FOOD BEVERAGE DIFF
0 0 0
0 0 0
0 0 0
20,266,116 28,299,582 48,565,698
0 0 0
199,876,035 2,727,273 202,603,308
220,142,151 31,026,855 251,169,006

OUTLET DAILY BUDGET MONTHLY BUDGET


SWISS CAFE - ALA CARTE 1,108,783 34,372,285
SWISS CAFÉ- ROOM BREAKFAST 5,346,925 165,754,675
SWISS DELI 0 0
SAWAK LOUNGE 2,869,802 88,963,870
ROOM SERVICE 1,846,023 57,226,706
FB OUTLET 11,171,533 346,317,536
BANQUET 8,245,968 255,625,000
FB-OTHER 806,452 25,000,000
TOTAL 9,052,419 280,625,000
DAILY BUDGET 20,223,953 626,942,536
.

SERVICE CHARGE 2,022,395 62,694,254

GRAND TOTAL 22,246,348 689,636,790

ACTUAL 337,211,149
VAR -352,425,641
DAY LEFT 6
TARGET TO ACHIEVE PER DAY -58,737,607

DIFF
7.3%
#DIV/0!
-2.0%
-9.2%

131.0%
-100.0%
-2.2%
17.7%
29.1%

-59.94% VAR ACTUAL VS BUDGET (%)

#REF! #REF! #REF!


7,635,492,438 -1,281,459,123 83.2%
14,396,783,221 -1,088,442,275 92.4%
FO
TODAY REVENUE - 28 FEB 2022
NO OUTLET
FOOD BEVERAGE
1 SWISS CAFÉ- ALA CARTE
2 SWISS CAFÉ - BREAKFAST 0
3 SWISS DELI 0
4 SAWAK LOUNGE
5 IN ROOM DINNING
6 BANQUET 0
TOTAL 0 0
0
F&B ACTUAL VS B
400,000,000
NO OUTLET REV VS BUDGET

350,000,000

ACTUAL SWISS CAFÉ - ALA CARTE 0


1 300,000,000
BUDGET SWISS CAFÉ - ALA CARTE 34,372,285

ACTUAL SWISS CAFÉ-ROOM BREAKFAST 0 250,000,000


2
BUDGET SWISS CAFÉ- ROOM BREAKFAST 165,754,675
200,000,000
ACTUAL - SWISS DELI 0 1
3 150,000,000
BUDGET - SWISS DELI 0

ACTUAL - SAWAK LOUNGE 27,330,823 100,000,000


4 34,372,285
BUDGET -SAWAK LOUNGE 88,963,870 44,341,699
50,000,000
ACTUAL - IN ROOM DINNING 0
5
BUDGET - IN ROOM DINNING 57,226,706 0
E

E
RT
RT

ACTUAL-BANQUETE 212,929,755
CA

CA

6
EA
LA

LA

BR
-A

-A

BUDGET - BANQUETE 255,625,000


M

OO
CA

CA

-R

ACTUAL-FB OTHER 4,958,678


ISS

ISS


W

SW

CA

7
CA
LS

ET

ISS

25,000,000
ISS

BUDGET-FB OTHER
A

DG
TU

SW

SW
AC

BU

AL

ET

F & B ACTUAL REVENUE 245,219,256


TU

DG
AC

BU
F
W

SW

CA

CA
LS

ET

ISS

ISS
A

DG
TU

SW
AC

LS
BU

ET
A
TU

DG
AC

BU
F&B MONTHLY BUDGET 626,942,536

ACTUAL MTD-FB SERVICE CHARGE 65,463,630


8
BUDGET MONTHLY -FBSERVICE CHARGE 62,694,254
2,769,376

WHOLE BUDGET 689,636,790


ACTUAL 310,682,886
DIFF -378,953,904

45.05%
-54.9%
FB OUTLET FORECAST
1 SWISS CAFÉ- ALA CARTE 0
2 #REF! 0
3 #REF! 1,093,233

4 #REF! 0

TOTAL 1,093,233
FORECAST 6,559,398
TOTAL TARGET 33,890,221
FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - AUG 20
UE - 28 FEB 2022 MTD REVENUE
TOTAL FOOD BEVERAGE
0
0 0
0 0
0 11,072,562 16,258,261
0
0 211,483,474 1,446,281
0 222,556,036 17,704,542
0 0 4,958,678
F&B ACTUAL VS BUDGET REVENUE - FEB 2022
0,000,000 381,879,3

0,000,000

0,000,000

0,000,000

0,000,000
165,754,675
157,054,003
0,000,000

100,850,211 88,963,870
0,000,000
34,372,285 57,226,706
44,341,699
0,000,000
36,063,422
3,505,620 0
0
E
G
G
LI

GE
E

T
E

GE
T

LI

ET
IN
IN
DE
RT
RT

AS
AS

DE

UN
UN

QU
NN

NN
CA

CA

KF
KF

ISS
ISS

LO
LO

AN

AN
DI

DI
EA
EA

W
LA

SW
AL

OM

OM
BR
BR

AK
AK

L-B

-B
-S
-A

É-

AW

AW
M
M

A
ET

ET
RO
RO

AL

TU
F

OO
OO

DG

DG
CA

CA

-S
-S
TU

N
N

AC
BU

BU
-I
-I
-R
-R

ET
AL
AC
ISS

ISS

AL

ET

DG
TU
W

SW

CA

DG
TU
CA

BU
AC

AC

BU
ET

ISS

ISS
DG

SW

SW
BU

AL

ET
TU

DG
AC

BU
F
W

SW

D
CA

DG
TU
T
CA

BU
AC

AC

BU
ET

ISS

ISS
DG

SW
LS
BU

ET
A
TU

DG
AC

BU

MTD AUG 2022 - HOTE


DESCRIPTION % ACT ACTUAL
ROOM 68.15% 1,037,281,719
FB 15.78% 240,260,578
LAUNDRY 1.27% 19,329,174
SPA 1.44% 21,923,133

BISNIS CENTER 0.03% 465,692


TELECOMUNICATION 0.00% 0
OTHER 1.61% 24,439,896
SERVICE CHARGE 11.72% 178,417,469
TOTAL 100.00% 1,522,117,661

180,562,861
REVENUE ANALYSIS - AUG 2022 SWISS-BELHOTEL MERAUKE
EVENUE MTD BUDGET REVENUE
TOTAL FOOD BEVERAGE TOTAL
0 0
0 0
0 0
27,330,823 0
0 0
212,929,755 0
240,260,578 0 0 0

381,879,336

255,625,000

0,211 88,963,870

57,226,706
36,063,422 25,000,000
20,578,513
E

E
G
G

R
GE
E

R
ET

ET

HE
IN
IN
NG

HE
UN

QU

QU
NN

NN

OT
OT
LO

AN

AN
DI

DI

B
B

-F
OM

OM

L-F
AK

L-B

-B

ET
A
W

ET

DG
RO
RO

TU
TU
SA

DG

BU
AC
N
IN

AC

BU
-I
L-

ET
A

DG
TU
AC

BU
DG
TU
AC

BU

MTD AUG 2022 - HOTEL REVENUE


BUDGET % BUDGET VAR ACHIEVEMENT
966,568,640 81.40% 70,713,079 107.32%
0 0.00% 240,260,578 #DIV/0!
19,723,226 1.66% -394,052 98.00%
24,145,735 2.03% -2,222,602 90.80%

201,613 0.02% 264,079 230.98%


161,290 0.01% -161,290 0.00%
25,000,000 2.11% -560,104 97.76%
151,639,932 12.77% 26,777,537 117.66%
1,187,440,436 100.00% 334,677,225 128.18%

FB MTD VS BUDGET (ACHIEVEMENT) 38.3%


F&B - ACT YTD VS BUDGET YTD #REF!
ROOM - ACT YTD VS BUDGET YTD 6,354,033,315
HOTEL- ACTUAL YTD VS BUDGET YTD 13,308,340,946
E
VAR
FOOD BEVERAGE DIFF
0 0 0
0 0 0
0 0 0
11,072,562 16,258,261 27,330,823
0 0 0
211,483,474 1,446,281 212,929,755
222,556,036 17,704,542 240,260,578

OUTLET DAILY BUDGET MONTHLY BUDGET


SWISS CAFE - ALA CARTE 1,108,783 34,372,285
SWISS CAFÉ- ROOM BREAKFAST 5,346,925 165,754,675
SWISS DELI 0 0
SAWAK LOUNGE 2,869,802 88,963,870
ROOM SERVICE 1,846,023 57,226,706
FB OUTLET 11,171,533 346,317,536
BANQUET 8,245,968 255,625,000
FB-OTHER 806,452 25,000,000
TOTAL 9,052,419 280,625,000
DAILY BUDGET 20,223,953 626,942,536
.

SERVICE CHARGE 2,022,395 62,694,254

GRAND TOTAL 22,246,348 689,636,790

ACTUAL 310,682,886
VAR -378,953,904
DAY LEFT 6
TARGET TO ACHIEVE PER DAY -63,158,984

DIFF
7.3%
#DIV/0!
-2.0%
-9.2%

131.0%
-100.0%
-2.2%
17.7%
28.2%

-61.68% VAR ACTUAL VS BUDGET (%)

#REF! #REF! #REF!


7,635,492,438 -1,281,459,123 83.2%
14,396,783,221 -1,088,442,275 92.4%
FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - MARCH 2022 SWISS-BELHOTEL MERAUKE
TODAY REVENUE -30 MARCH 2022 MTD REVENUE BUDGET REVENUE VAR
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL
1 SWISS CAFÉ-ALA CARTE 7,384,298 7,351,240 14,735,538 40,070,405 28,107,438 68,177,843 20,720,147 13,323,659 34,043,806 19,350,258 14,783,779 34,134,037
2 SWISS CAFÉ-BREAKFAST 5,404,958 0 5,404,958 110,623,967 0 110,623,967 136,846,090 0 0 -26,222,123 0 -26,222,123
3 SWISS DELI 182,645 0 182,645 7,997,107 0 7,997,107 0 0 0 7,997,107 0 7,997,107
4 SAWAK LOUNGE 2,334,711 2,531,405 4,866,116 24,825,207 50,364,845 75,190,052 24,030,330 24,954,330 48,984,660 794,877 25,410,515 26,205,392
5 IN ROOM DINNING 512,397 148,760 661,157 14,631,240 6,005,785 20,637,025 27,514,533 18,842,464 46,356,997 -12,883,293 -12,836,679 -25,719,972
6 BANQUET 0 0 0 434,771,707 13,615,703 448,387,410 190,200,000 8,525,000 198,725,000 244,571,707 5,090,703 249,662,410
TOTAL 15,819,009 10,031,405 25,850,414 632,919,633 98,093,771 731,013,404 399,311,100 65,645,453 328,110,463 233,608,533 32,448,318 266,056,851
FOOD 12,881,003 31 399,311,100
NO OUTLET % REVENUE 61.3% BUDGET BEVERAGE 2,117,595 31 65,645,453
70.0%
BUDGET DAILY 14,998,598 31 464,956,553
60.0%
1 SWISS CAFÉ-ALA CARTE 9.3% 68,177,843 50.0%
464,956,571
2 SWISS CAFÉ-BREAKFAST 15.1% 110,623,967 40.0%
MTD BUDGET MONTHLY BUDGET
15.1%
3 SWISS DELI 1.1% 7,997,107 30.0% 10.3% ACTUAL 731,013,404 ACTUAL 731,013,404
4 SAWAK LOUNGE 10.3% 75,190,052 9.3% BUDGET MTD 328,110,463 BUDGET MARCH 464,956,553
20.0% 1.1%
5 IN ROOM DINNING 2.8% 20,637,025 10.0% 2.8% 0.0% DIFF 402,902,941 DIFF 266,056,851
6 BANQUET 61.3% 448,387,410 0.0% DAY LEFT 0
7 MINI BAR 0.0% 0 NOTE

TOTAL 100.0% 731,013,404 DESC PAX NET ALOCATION TOTAL REV


BREAKFAST 92 53,719 4,942,149

NO DESCRIPTION PERCENTAGE REVENUE MARCH OUTLET BUDGET -2022


1 ROOM 46.02% 838,830,682 2 0 1 9.15% FB OUTLET BUDGET DAILY BUDGET MONTHLY %
. . .
2 F&B 40.11% 731,013,404 2 0 0.66%2 SWISS CAFÉ 5,512,577 170,889,896 64.19%
2 3 9
3 TOBACCO 0.03% 494,421 % % 0.53% %
SAWAK LOUNGE 1,580,150 48,984,660 18.40%
4 LAUNDRY 0.66% 11,958,430 ROOM SERVICE 1,495,388 46,357,017 17.41%
5 SPA,FITNES & SWIM 2.22% 40,517,342 SWISS DELI 0 0 0.00%
6 BUSSINES CENTER 0.53% 9,623,967 46.02% TOTAL 8,588,115 266,231,573 49.40%
7 TELECOMUNICATIONS 0.00% 0
8 OTHER REVENUE 1.29% 23,509,091 BANQUET 6,410,484 198,725,000 36.87%
40.
11
9 OTHER REV SC 9.15% 166,681,454 %
FB OTHER REV 806,452 25,000,000 4.64%
TOTAL 100.0% 1,822,628,791 FB SERVICE CHARGE 1,580,505 48,995,657 9.09%
GRAND TOTAL 14,998,599 538,952,230 100.00%
75,157,297
ACTUAL BUDGET 1,822,628,791
VS MONTHLY BUDGET 1,747,471,494 MONTH DESCRIPTION ACTUAL MONTHLY BUDGET VAR
FOOD AND BEVERAGE REV 731,013,404 464,956,553 266,056,851
FB OTHER REV 20,247,934 25,000,000 -4,752,066
F&B MARCH 2022
FB SERVICE CHARGE 75,175,553 48,995,657 26,179,896
TOTAL 826,436,891 538,952,210 287,484,681
FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - APRIL 2022 SWISS-BELHOTEL MERAUKE
TODAY REVENUE -30 APRIL 2022 MTD REVENUE BUDGET REVENUE VAR
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL
1 SWISS CAFÉ- ALA CARTE 8,346,199 1,948,760 10,294,959 239,276,608 67,737,603 307,014,211 143,874,640 92,310,670 236,185,310 95,401,968 -24,573,067 70,828,901
2 SWISS CAFÉ - BREAKFAST 2,086,776 0 2,086,776 101,391,738 0 101,391,738 118,785,800 0 118,785,800 -17,394,062 0 -17,394,062
3 SWISS DELI 680,992 0 680,992 7,512,810 0 7,512,810 0 0 0 7,512,810 0 7,512,810
4 SAWAK LOUNGE 876,859 1,871,901 2,748,760 30,638,017 66,544,625 97,182,642 21,140,395 21,960,035 43,100,430 9,497,622 44,584,590 54,082,212
5 IN ROOM DINNING 200,000 200,000 11,281,569 8,402,479 19,684,048 23,860,190 16,339,783 40,199,973 -12,578,621 -7,937,304 -20,515,925
6 BANQUET 0 0 0 101,378,098 1,685,950 103,064,048 264,000,000 11,000,000 275,000,000 -162,621,902 -9,314,050 -171,935,952
TOTAL 12,190,826 3,820,661 16,011,487 491,478,840 144,370,657 635,849,497 571,661,025 141,610,488 713,271,513 -80,182,185 2,760,169 -77,422,016

F&B ACTUAL VS BUDGET REVENUE - APRIL 2022 OUTLET DAILY BUDGET MONTHLY BUDGET
SWISS CAFE - ALA CARTE 7,872,910 236,187,310
NO OUTLET REV VS BUDGET SWISS CAFÉ- ROOM BREAKFAST 3,959,527 118,785,797
350,000,000
SWISS DELI 0 0
307,014,211
ACTUAL SWISS CAFÉ - ALA CARTE 307,014,211 SAWAK LOUNGE 1,436,681 43,100,430
1 300,000,000
BUDGET SWISS CAFÉ - ALA CARTE 236,187,310 275,000,000 ROOM SERVICE 1,339,999 40,199,971
ACTUAL SWISS CAFÉ-ROOM BREAKFAST 101,391,738
250,000,000
236,187,310 FB OUTLET 14,609,117 438,273,508
2
BUDGET SWISS CAFÉ- ROOM BREAKFAST 118,785,797 BANQUET 9,166,667 275,000,000
ACTUAL - SWISS DELI 7,512,810 200,000,000 FB-OTHER 833,333 25,000,000
3
BUDGET - SWISS DELI 0 TOTAL 10,000,000 300,000,000
ACTUAL - SAWAK LOUNGE 97,182,642 150,000,000
118,785,797 103,064,048 DAILY BUDGET 24,609,117 738,273,508
4 101,391,738
BUDGET -SAWAK LOUNGE 43,100,430 97,182,642
100,000,000
ACTUAL - IN ROOM DINNING 19,684,048 SERVICE CHARGE 2,460,905 73,827,151
5
BUDGET - IN ROOM DINNING 40,199,971
43,100,430 40,199,971 25,000,000
50,000,000
ACTUAL-BANQUETE 103,064,048 7,512,810 19,684,048 21,157,025 GRAND TOTAL 27,070,022 812,098,664
6
BUDGET - BANQUETE 275,000,000 0
0
ACTUAL-FB OTHER 21,157,025 ACTUAL 657,006,522
7
BUDGET-FB OTHER 25,000,000 VAR -81,266,986
F & B ACTUAL REVENUE 657,006,522 DAY LEFT 2
F&B MONTHLY BUDGET 738,273,508 TARGET TO ACHIEVE PER DAY -40,633,493
VAR -81,266,986
APRIL 2022 - HOTEL REVENUE
ACTUAL-FB SERVICE CHARGE 67,621,090 DESCRIPTION % ACT ACTUAL BUDGET % BUDGET VAR
8
BUDGET-FBSERVICE CHARGE 73,827,151 ROOM 47.80% 789,472,847 809,677,783 45.97% -20,204,936
-6,206,061 FB 38.50% 635,882,556 713,271,513 40.49% -77,388,957
LAUNDRY 0.90% 14,925,289 17,525,600 0.99% -2,600,311
WHOLE BUDGET 812,100,659 SPA 2.05% 33,851,186 29,940,712 1.70% 3,910,474
ACTUAL 724,627,612 BISNIS CENTER 0.09% 1,477,686 250,000 0.01% 1,227,686
DIFF -87,473,047 TELECOMUNICATION 0.00% 200,000 0.01% -200,000
OTHER 1.42% 23,474,149 31,000,000 1.76% -7,525,851
SERVICE CHARGE 9.24% 152,689,080 159,586,560 9.06% -6,897,480
TOTAL 100.00% 1,651,772,793 1,761,452,168 100.00% -109,679,375
FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - MAY 2022 SWISS-BELHOTEL MERAUKE
TODAY REVENUE - 31 MAY 2022 MTD REVENUE BUDGET REVENUE VAR
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 520,662 267,769 788,431 56,477,822 54,927,272 111,405,094 25,568,215 16,427,458 41,995,673 30,909,607 38,499,814 69,409,421
2 SWISS CAFÉ - BREAKFAST 3,173,553 0 3,173,553 118,797,509 0 118,797,509 140,421,785 0 140,421,785 -21,624,276 0 -21,624,276
3 SWISS DELI 102,479 0 102,479 10,087,603 0 10,087,603 0 0 0 10,087,603 0 10,087,603
4 SAWAK LOUNGE 636,364 497,521 1,133,885 47,258,595 82,330,982 129,589,577 25,362,526 26,345,195 51,707,721 21,896,069 55,985,787 77,881,856
5 IN ROOM DINNING 458,678 132,231 590,909 20,361,157 11,892,562 32,253,719 28,302,814 19,382,998 47,685,812 -7,941,657 -7,490,436 -15,432,093
6 BANQUET 0 0 0 413,326,445 18,640,496 431,966,941 286,599,991 13,825,008 300,424,999 126,726,454 4,815,488 131,541,942
TOTAL 4,891,736 897,521 5,789,257 666,309,131 167,791,312 834,100,443 506,255,331 75,980,659 582,235,990 160,053,800 91,810,653 251,864,453

F&B ACTUAL VS BUDGET REVENUE - MAY 2022 OUTLET DAILY BUDGET MONTHLY BUDGET

450,000,000
431,966,941 SWISS CAFE - ALA CARTE 1,354,699 41,995,670
NO OUTLET REV VS BUDGET SWISS CAFÉ- ROOM BREAKFAST 4,529,735 140,421,785
400,000,000
SWISS DELI 0 0
ACTUAL SWISS CAFÉ - ALA CARTE 111,405,094 350,000,000 SAWAK LOUNGE 1,667,991 51,707,710
1
41,995,670 300,425,000
BUDGET SWISS CAFÉ - ALA CARTE ROOM SERVICE 1,538,252 47,685,808
300,000,000
ACTUAL SWISS CAFÉ-ROOM BREAKFAST 118,797,509 FB OUTLET 9,090,677 281,810,973
2
250,000,000
BUDGET SWISS CAFÉ- ROOM BREAKFAST 140,421,785 BANQUET 9,691,129 300,425,000
ACTUAL - SWISS DELI 10,087,603 200,000,000 FB-OTHER 806,452 25,000,000
3
BUDGET - SWISS DELI 0
150,000,000
140,421,785
129,589,577 TOTAL 10,497,581 325,425,000
111,405,094 118,797,509
ACTUAL - SAWAK LOUNGE 129,589,577 DAILY BUDGET 19,588,257 607,235,973
4 100,000,000 51,707,710
BUDGET -SAWAK LOUNGE 51,707,710 41,995,670 47,685,808
32,314,049
.
10,087,603 32,253,719
50,000,000
ACTUAL - IN ROOM DINNING 32,253,719 25,000,000
SERVICE CHARGE 1,958,826 60,723,597
5 0
BUDGET - IN ROOM DINNING 47,685,808 0
E E T T LI LI GE GE G G E E R R
RT RT AS AS DE DE IN IN ET ET HE HE
6
ACTUAL-BANQUETE 431,966,941 CA CA KF KF ISS ISS LO
UN
LO
UN
DI
NN
DI
NN QU QU OT OT GRAND TOTAL 21,547,083 667,959,570
LA LA R EA REA W SW K K BAN BAN -FB -FB
BUDGET - BANQUETE 300,425,000 -A -A B B S - A A OM OM - - AL ET
FÉ FÉ
- ET AL ET DG
OM OM AL AW AW RO RO TU TU
CA CA RO RO TU DG -S -S DG AC BU
ACTUAL-FB OTHER 32,314,049 ISS ISS FÉ- F É- AC BU AL GET L -I
N
T -I
N AC BU ACTUAL 866,414,492
7 U D A E
SW SW CA CA T
BU TU DG
BUDGET-FB OTHER 25,000,000 AL ET ISS AC VAR 259,178,519
ISS AC BU
TU DG W SW
AC BU LS
F & B ACTUAL REVENUE 866,414,492 TU
A
DG
ET DAY LEFT 0
AC BU
F&B MONTHLY BUDGET 607,235,973 TARGET TO ACHIEVE PER DAY #DIV/0!

ACTUAL-FB SERVICE CHARGE 86,770,128


8
BUDGET-FBSERVICE CHARGE 60,723,597 MTD MAY 2022 - HOTEL REVENUE
26,046,531 DESCRIPTION % ACT ACTUAL BUDGET % BUDGET VAR
ROOM 43.15% 847,790,652 977,633,871 54.15% -129,843,219
WHOLE BUDGET 667,959,570 FB 42.46% 834,100,442 582,235,973 32.25% 251,864,469
ACTUAL 953,184,620 LAUNDRY 0.76% 14,936,281 20,717,600 1.15% -5,781,319
DIFF 285,225,050 SPA 2.64% 51,889,822 29,940,712 1.66% 21,949,110
BISNIS CENTER 0.07% 1,326,446 250,000 0.01% 1,076,446
TELECOMUNICATION 0.00% 0 200,000 0.01% -200,000
OTHER 1.78% 35,037,520 31,000,000 1.72% 4,037,520
SERVICE CHARGE 9.14% 179,563,230 163,597,816 9.06% 15,965,414
TOTAL 100.00% 1,964,644,393 1,805,575,972 100.00% 159,068,421
FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - JUNE 2022 SWISS-BELHOTEL MERAUKE
TODAY REVENUE - 30 JUNE 2022 MTD REVENUE MTD BUDGET REVENUE VAR
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 330,579 231,405 561,984 35,936,399 11,953,388 47,889,787 22,339,115 14,359,115 36,698,230 13,597,284 -2,405,727 11,191,557
2 SWISS CAFÉ - BREAKFAST 5,161,157 0 5,161,157 123,946,245 0 123,946,245 150,300,400 0 150,300,400 -26,354,155 0 -26,354,155
3 SWISS DELI 203,802 0 203,802 2,553,719 0 2,553,719 0 0 0 2,553,719 0 2,553,719
4 SAWAK LOUNGE 537,190 33,058 570,248 28,464,876 43,078,182 71,543,058 35,543,275 36,924,355 72,467,630 -7,078,399 6,153,827 -924,572
5 IN ROOM DINNING 371,074 185,950 557,024 10,600,000 4,519,008 15,119,008 30,167,009 20,659,887 50,826,896 -19,567,009 -16,140,879 -35,707,888
6 BANQUET 12,809,917 413,223 13,223,140 519,342,971 16,033,057 535,376,028 503,200,000 22,900,000 526,100,000 16,142,971 -6,866,943 9,276,028
TOTAL 19,413,719 863,636 20,277,355 720,844,210 75,583,635 796,427,845 741,549,799 94,843,357 836,393,156 -20,705,589 -19,259,722 -39,965,311

F&B ACTUAL VS BUDGET REVENUE - JUNE 2022 OUTLET DAILY BUDGET MONTHLY BUDGET

600,000,000
SWISS CAFE - ALA CARTE 1,223,274 36,698,230
NO OUTLET REV VS BUDGET 535,376,028 SWISS CAFÉ- ROOM BREAKFAST 5,010,013 150,300,400
526,100,000
500,000,000
SWISS DELI 0 0
ACTUAL SWISS CAFÉ - ALA CARTE 47,889,787 SAWAK LOUNGE 2,412,921 72,387,630
1
BUDGET SWISS CAFÉ - ALA CARTE 36,698,230 ROOM SERVICE 1,817,425 54,522,740
400,000,000
ACTUAL SWISS CAFÉ-ROOM BREAKFAST 123,946,245 FB OUTLET 10,463,633 313,909,000
2
BUDGET SWISS CAFÉ- ROOM BREAKFAST 150,300,400 BANQUET 17,536,667 526,100,000
300,000,000
ACTUAL - SWISS DELI 2,553,719 FB-OTHER 833,333 25,000,000
3
BUDGET - SWISS DELI 0 200,000,000 TOTAL 18,370,000 551,100,000
150,300,400
ACTUAL - SAWAK LOUNGE 71,543,058 123,946,245 DAILY BUDGET 28,833,633 865,009,000
4
72,387,630
BUDGET -SAWAK LOUNGE 72,387,630 100,000,000 71,543,058 .
54,522,740
47,889,787 35,041,322
36,698,230
ACTUAL - IN ROOM DINNING 15,119,008
2,553,719
15,119,008 25,000,000 SERVICE CHARGE 2,778,690 86,139,394
5 0
BUDGET - IN ROOM DINNING 54,522,740 0
E E ST ST LI LI GE GE G G TE TE R R
RT RT DE DE IN IN UE UE HE HE
6
ACTUAL-BANQUETE 535,376,028 CA CA AK
FA
AK
FA
ISS ISS LO
UN
LO
UN
DI
NN
DI
NN NQ NQ OT OT GRAND TOTAL 31,612,323 951,148,394
LA LA E E
SW W BA BA -F
B FB
BUDGET - BANQUETE 526,100,000 -A -A BR BR - - S AK AK M M L- - L ET-
ET O O A ET A
FÉ FÉ OM OM AL AW AW RO RO TU TU DG
CA CA RO RO TU DG -S -S AC DG AC BU
ACTUAL-FB OTHER 35,041,322 ISS ISS É- É- AC BU AL ET -I
N
-I
N
BU ACTUAL 914,556,084
7 SW SW CAF AF TU UDG U AL GET
C C
BUDGET-FB OTHER 25,000,000 AL ET ISS ISS
A B
AC
T
BU
D VAR 36,592,310
TU DG W W
AC BU LS TS
F & B ACTUAL REVENUE 831,469,167 T UA
D GE DAY LEFT
AC BU
F&B MONTHLY BUDGET 865,009,000 TARGET TO ACHIEVE PER DAY #DIV/0!

ACTUAL MTD-FB SERVICE CHARGE 83,086,917


8
BUDGET MONTHLY -FBSERVICE CHARGE 86,139,394 MTD JUNE 2022 - HOTEL REVENUE
-3,052,477 DESCRIPTION % ACT ACTUAL BUDGET % BUDGET VAR ACHIEVEMENT DIFF
ROOM 48.18% 998,886,649 1,087,508,657 49.26% -88,622,008 91.85% -8.1%
WHOLE BUDGET 951,148,394 FB 38.42% 796,427,846 836,393,936 37.89% -39,966,090 95.22% -4.8%
ACTUAL 914,556,084 LAUNDRY 0.90% 18,574,876 22,176,800 1.00% -3,601,924 83.76% -16.2%
DIFF -36,592,310 SPA 1.54% 31,826,443 29,940,712 1.36% 1,885,731 106.30% 6.3% 20705589
BISNIS CENTER 0.02% 491,736 250,000 0.01% 241,736 196.69% 96.7% 19260501
TELECOMUNICATION 0.00% 0 200,000 0.01% -200,000 0.00% -100.0% 39966090
OTHER 1.81% 37,474,545 31,000,000 1.40% 6,474,545 120.89% 20.9%
SERVICE CHARGE 9.14% 189,389,421 200,147,011 9.07% -10,757,590 94.63% -5.4%
TOTAL 100.00% 2,073,071,516 2,207,617,116 100.00% -134,545,600 93.91% -6.1%
FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - JULY 2022 SWISS-BELHOTEL MERAUKE
TODAY REVENUE - 31 JULY 2022 MTD REVENUE MTD BUDGET REVENUE VAR
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 1,586,777 0 1,586,777 33,022,152 8,787,603 41,809,755 21,003,417 13,398,394 34,401,811 12,018,735 -4,610,791 7,407,944
2 SWISS CAFÉ - BREAKFAST 1,557,851 0 1,557,851 84,360,492 0 84,360,492 157,936,630 0 157,936,630 -73,576,138 0 -73,576,138
3 SWISS DELI 174,380 0 174,380 3,033,058 0 3,033,058 0 0 0 3,033,058 0 3,033,058
4 SAWAK LOUNGE 2,022,727 701,653 2,724,380 51,623,612 42,209,091 93,832,703 37,882,330 39,345,620 77,227,950 13,741,282 2,863,471 16,604,753
5 IN ROOM DINNING 664,463 675,207 1,339,670 10,255,372 4,780,992 15,036,364 32,359,806 22,162,934 54,522,740 -22,104,434 -17,381,942 -39,486,376
6 BANQUET 0 0 0 485,123,635 26,027,942 511,151,577 485,000,000 20,625,000 505,625,000 123,635 5,402,942 5,526,577
TOTAL 6,006,198 1,376,860 7,383,058 667,418,321 81,805,628 749,223,949 734,182,183 95,531,948 829,714,131 -66,763,862 -13,726,320 -80,490,182
5,825,207 7,048,500
F&B ACTUAL VS BUDGET REVENUE - JULY 2022 OUTLET DAILY BUDGET MONTHLY BUDGET
SWISS CAFE - ALA CARTE 1,109,736 34,401,811
600,000,000
NO OUTLET REV VS BUDGET SWISS CAFÉ- ROOM BREAKFAST 5,094,730 157,936,630
511,151,577 505,625,000
SWISS DELI 0 0
500,000,000
ACTUAL SWISS CAFÉ - ALA CARTE 41,809,755 SAWAK LOUNGE 2,491,224 77,227,950
1
BUDGET SWISS CAFÉ - ALA CARTE 34,401,811 ROOM SERVICE 1,758,798 54,522,740
400,000,000
ACTUAL SWISS CAFÉ-ROOM BREAKFAST 84,360,492 FB OUTLET 10,454,488 324,089,131
2
BUDGET SWISS CAFÉ- ROOM BREAKFAST 163,486,876 BANQUET 16,310,484 505,625,000
300,000,000
ACTUAL - SWISS DELI 3,033,058 FB-OTHER 806,452 25,000,000
3
BUDGET - SWISS DELI 0 200,000,000 163,486,876 TOTAL 17,116,935 530,625,000
ACTUAL - SAWAK LOUNGE 93,832,703 DAILY BUDGET 27,571,424 854,714,131
4 84,360,492 93,832,703
BUDGET -SAWAK LOUNGE 72,227,950 100,000,000
72,227,950
34,401,811 54,522,740 .
41,809,755 25,000,000
ACTUAL - IN ROOM DINNING 15,036,364
3,033,058 0 15,036,364 7,851,240 SERVICE CHARGE 2,757,142 85,471,413
5
BUDGET - IN ROOM DINNING 54,522,740 0
E E T T LI LI GE GE G G TE TE R R
RT RT AS AS DE DE IN IN UE UE HE HE
6
ACTUAL-BANQUETE 511,151,577
LA
CA
LA
CA
EA
KF
EA
KF
W
ISS W
ISS LO
UN
LO
UN
DI
NN
DI
NN
A NQ ANQ
FB
OT
FB
OT GRAND TOTAL 30,328,566 940,185,544
R R S K K -B - -
505,625,000 -A -A B B S - A A OM OM -B AL ET
BUDGET - BANQUETE
FÉ FÉ
- ET AL ET DG
OM OM AL AW AW RO RO TU TU
CA CA RO RO TU DG -S -S N N AC DG AC BU
ACTUAL-FB OTHER 7,851,240 ISS ISS F É- F É- AC BU
UAL
D GET
AL -I
ET -I BU ACTUAL 832,467,708
7 SW SW CA CA T
BU TU DG
AL ET ISS AC
BUDGET-FB OTHER 25,000,000
TU DG W W
ISS AC BU VAR 107,717,836
AC BU LS TS
F & B ACTUAL REVENUE 757,075,189 TU
A
DG
E DAY LEFT 0
AC BU
F&B MONTHLY BUDGET 855,264,377 TARGET TO ACHIEVE PER DAY #DIV/0!

ACTUAL MTD-FB SERVICE CHARGE 75,392,519


8
BUDGET MONTHLY -FBSERVICE CHARGE 85,471,413 MTD JUNE 2022 - HOTEL REVENUE
-10,078,894 DESCRIPTION % ACT ACTUAL BUDGET % BUDGET VAR ACHIEVEMENT DIFF
ROOM 42.65% 711,764,050 1,124,919,510 50.16% -413,155,460 63.27% -36.7%
WHOLE BUDGET 940,185,544 FB 44.90% 749,223,949 829,714,131 37.00% -80,490,182 90.30% -9.7%
ACTUAL 832,467,708 LAUNDRY 0.88% 14,747,521 23,301,660 1.04% -8,554,139 63.29% -36.7%
DIFF -107,717,836 SPA 1.77% 29,566,789 29,940,712 1.34% -373,923 98.75% -1.2%
BISNIS CENTER 0.09% 1,428,926 250,000 0.01% 1,178,926 571.57% 471.6%
TELECOMUNICATION 0.00% 0 200,000 0.01% -200,000 0.00% -100.0%
OTHER 0.58% 9,701,818 31,000,000 1.38% -21,298,182 31.30% -68.7%
SERVICE CHARGE 9.13% 152,276,654 203,332,595 9.07% -51,055,941 74.89% -25.1%
TOTAL 100.00% 1,668,709,707 2,242,658,608 100.00% -573,948,901 74.41% -25.6%

FB MTD VS BUDGET (ACHIEVEMENT) 87.7% -12.34% VAR ACTUAL VS BUDGET (%)

F&B - ACT YTD VS BUDGET YTD 4,483,212,904 4,335,728,395 147,484,509 103.4%

ROOM - ACT YTD VS BUDGET YTD 5,316,751,596 6,668,923,798 -1,352,172,202 79.7%

HOTEL- ACTUAL YTD VS BUDGET YTD 11,353,539,192 12,723,905,255 -1,370,366,063 89.2%


FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - AUG 2022 SWISS-BELHOTEL MERAUKE
TODAY REVENUE - 30 AUG 2022 MTD REVENUE MTD BUDGET REVENUE VAR
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 560,331 0 560,331 34,133,104 10,208,595 44,341,699 20,986,905 13,385,366 34,372,271 13,146,199 -3,176,771 9,969,428
2 SWISS CAFÉ - BREAKFAST 6,020,661 0 6,020,661 157,054,003 0 157,054,003 165,754,675 0 165,754,675 -8,700,672 0 -8,700,672
3 SWISS DELI 99,008 0 99,008 3,505,620 0 3,505,620 0 0 0 3,505,620 0 3,505,620
4 SAWAK LOUNGE 1,615,703 966,116 2,581,819 60,279,132 40,571,079 100,850,211 43,652,991 45,310,871 88,963,862 16,626,141 -4,739,792 11,886,349
5 IN ROOM DINNING 1,088,339 912,397 2,000,736 22,203,422 13,860,000 36,063,422 33,966,049 23,260,664 57,226,713 -11,762,627 -9,400,664 -21,163,291
6 BANQUET 0 0 0 329,719,005 52,160,331 381,879,336 245,000,006 10,625,002 255,625,008 84,718,999 41,535,329 126,254,328
TOTAL 9,384,042 1,878,513 11,262,555 606,894,286 116,800,005 723,694,291 509,360,626 92,581,903 601,942,529 97,533,660 24,218,102 121,751,762
3,124,001 5,241,894 6,342,692
ACTUAL YTD BUDGET YTD VAR YTD
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 501,740,214 214,921,073 716,661,287 296,069,691 189,928,907 485,998,598 205,670,523 24,992,166 230,662,689
2 SWISS CAFÉ - BREAKFAST 810,956,015 0 810,956,015 1,091,799,075 0 1,091,799,075 -280,843,060 0 -280,843,060
3 SWISS DELI 39,081,342 0 39,081,342 0 0 0 39,081,342 0 39,081,342
4 SAWAK LOUNGE 274,428,116 369,656,646 644,084,762 232,199,455 241,131,395 473,330,850 42,228,661 128,525,251 170,753,912
5 IN ROOM DINNING 109,386,478 58,204,628 167,591,106 220,668,840 151,123,568 371,792,408 -111,282,362 -92,918,940 -204,201,302
6 BANQUET 2,695,021,370 132,337,033 2,827,358,403 2,408,000,000 106,750,000 2,514,750,000 287,021,370 25,587,033 312,608,403
7 MINI BAR 1,174,281 0 1,174,281 0 0 0 1,174,281 0 1,174,281
TOTAL 4,431,787,816 775,119,380 5,206,907,196 4,248,737,061 688,933,870 4,937,670,931 183,050,755 86,185,510 269,236,265

F&B ACTUAL VS BUDGET REVENUE - AUG 2022 OUTLET DAILY BUDGET MONTHLY BUDGET
SWISS CAFE - ALA CARTE 1,108,783 34,372,285
400,000,000 381,879,336
NO OUTLET REV VS BUDGET SWISS CAFÉ- ROOM BREAKFAST 5,346,925 165,754,675
350,000,000 SWISS DELI 0 0
ACTUAL SWISS CAFÉ - ALA CARTE 44,341,699 SAWAK LOUNGE 2,869,802 88,963,870
1 300,000,000
BUDGET SWISS CAFÉ - ALA CARTE 34,372,285 ROOM SERVICE 1,846,023 57,226,706
255,625,000
ACTUAL SWISS CAFÉ-ROOM BREAKFAST 157,054,003 250,000,000
FB OUTLET 11,171,533 346,317,536
2
BUDGET SWISS CAFÉ- ROOM BREAKFAST 165,754,675 BANQUET 8,245,968 255,625,000
200,000,000
165,754,675
3,505,620 157,054,003
ACTUAL - SWISS DELI FB-OTHER 806,452 25,000,000
3 150,000,000
BUDGET - SWISS DELI 0
100,850,211
TOTAL 9,052,419 280,625,000
88,963,870
ACTUAL - SAWAK LOUNGE 100,850,211 100,000,000 DAILY BUDGET 20,223,953 626,942,536
4 34,372,285 57,226,706
BUDGET -SAWAK LOUNGE 88,963,870 44,341,699 25,000,000
50,000,000
36,063,422 .
20,578,513
ACTUAL - IN ROOM DINNING 36,063,422 3,505,620 0 SERVICE CHARGE 2,022,395 62,694,254
5
BUDGET - IN ROOM DINNING 57,226,706 0

E
G

E
LI

R
GE
E

GE
T

LI

R
ET

ET

HE
IN
IN
DE
RT
RT

AS
AS

HE
DE

GRAND TOTAL 22,246,348 689,636,790

UN
UN

QU

QU
381,879,336

NN

NN
ACTUAL-BANQUETE

OT
CA

CA

KF
KF

OT
ISS
ISS

LO
LO

AN

AN
DI

DI
6
EA
EA

B
W
LA

B
SW

-F
AL

OM

L-F
BR
BR

AK
AK

L-B

-B
-S
-A

255,625,000

ET
BUDGET - BANQUETE

OO
É-

A
AW

AW
M
M

A
ET

ET

DG
RO

TU
AL

TU
F

R
OO
OO

DG

DG
CA

CA

BU
-S
-S

AC
TU

N
N

AC
ACTUAL 818,229,685
BU

BU
-I
-I
-R
-R

20,578,513
ET
ACTUAL-FB OTHER
AL
AC
ISS

ISS

AL

ET

DG
TU
W

SW

CA

DG
TU
CA

BU
LS

AC

VAR 128,592,895
AC

BU
ET

ISS

25,000,000
ISS

BUDGET-FB OTHER
A

DG
TU

SW

SW
AC

BU

AL

DAY LEFT 1
ET

F & B ACTUAL REVENUE 744,272,804


TU

DG
AC

BU

F&B MONTHLY BUDGET 626,942,536 TARGET TO ACHIEVE PER DAY 128,592,895

ACTUAL MTD-FB SERVICE CHARGE 73,956,881


8
BUDGET MONTHLY -FBSERVICE CHARGE 62,694,254 2,057,851 MTD AUG 2022 - HOTEL REVENUE
11,262,627 DESCRIPTION % ACT ACTUAL BUDGET % BUDGET VAR ACHIEVEMENT DIFF
ROOM 54.42% 1,190,888,372 1,198,545,114 57.78% -7,656,742 99.36% -0.6%
WHOLE BUDGET 689,636,790 FB 33.07% 723,694,291 601,942,529 29.02% 121,751,762 120.23% 20.2%
ACTUAL 818,229,685 820,287,536 LAUNDRY 1.03% 22,542,149 24,456,800 1.18% -1,914,651 92.17% -7.8%
DIFF 128,592,895 SPA 1.18% 25,884,961 29,940,712 1.44% -4,055,751 86.45% -13.5%

118.65% BISNIS CENTER 0.04% 974,783 250,000 0.01% 724,783 389.91% 289.9%
18.6% TELECOMUNICATION 0.00% 0 200,000 0.01% -200,000 0.00% -100.0%
FB OUTLET FORECAST OTHER 1.13% 24,755,186 31,000,000 1.49% -6,244,814 79.86% -20.1%
1 SWISS CAFÉ- ALA CARTE 1,773,668 SERVICE CHARGE 9.12% 199,455,069 188,033,516 9.06% 11,421,553 106.07% 6.1%
2 SWISS DELI 140,225 TOTAL 100.00% 2,188,194,811 2,074,368,671 100.00% 113,826,140 105.49% 5.5%
3 SAWAK LOUNGE 4,034,008

4 IN ROOM DINNING 1,442,537 FB MTD VS BUDGET (ACHIEVEMENT) 115.4% 15.43% VAR ACTUAL VS BUDGET (%)

TOTAL 7,390,438 F&B - ACT YTD VS BUDGET YTD 5,206,907,196 4,937,670,931 269,236,265 105.5%
FORECAST 7,390,438 ROOM - ACT YTD VS BUDGET YTD 6,507,639,968 7,867,468,912 -1,359,828,944 82.7%
TOTAL TARGET 192,151,390 HOTEL- ACTUAL YTD VS BUDGET YTD 13,541,694,002 14,798,273,933 -1,256,579,931 91.5%
FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - SEPTEMBER 2022 SWISS-BELHOTEL MERAUKE
TODAY REVENUE - 30 SEPT 2022 MTD REVENUE MTD BUDGET REVENUE VAR
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 3,622,315 1,489,256 5,111,571 21,153,131 8,936,942 30,090,073 21,014,425 13,407,070 34,421,495 138,706 -4,470,128 -4,331,422
2 SWISS CAFÉ - BREAKFAST 8,582,644 0 8,582,644 159,004,117 0 159,004,117 169,875,815 0 169,875,815 -10,871,698 0 -10,871,698
3 SWISS DELI 0 0 0 2,291,893 0 2,291,893 0 0 0 2,291,893 0 2,291,893
4 SAWAK LOUNGE 860,331 819,669 1,680,000 59,277,687 40,831,901 100,109,588 44,889,560 46,589,150 91,478,710 14,388,127 -5,757,249 8,630,878
5 IN ROOM DINNING 332,893 111,570 444,463 16,468,926 13,036,859 29,505,785 34,769,588 23,811,704 58,581,292 -18,300,662 -10,774,845 -29,075,507
6 BANQUET 38,413,223 0 38,413,223 467,123,979 83,276,008 550,399,987 304,000,000 13,000,000 317,000,000 163,123,979 70,276,008 233,399,987
TOTAL 51,811,406 2,420,495 54,231,901 725,319,733 146,081,710 871,401,443 574,549,388 96,807,924 671,357,312 150,770,345 49,273,786 200,044,131

ACTUAL YTD BUDGET YTD VAR YTD


NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 522,893,345 223,858,015 746,751,360 317,084,116 203,335,977 520,420,093 205,809,229 20,522,038 226,331,267
2 SWISS CAFÉ - BREAKFAST 969,960,132 0 969,960,132 1,261,674,890 0 1,261,674,890 -291,714,758 0 -291,714,758
3 SWISS DELI 41,373,325 0 41,373,325 0 0 0 41,373,325 0 41,373,325
4 SAWAK LOUNGE 333,705,803 410,488,547 744,194,350 277,089,015 287,720,545 564,809,560 56,616,788 122,768,002 179,384,790
5 IN ROOM DINNING 125,919,792 71,188,595 197,108,387 255,438,428 174,935,272 430,373,700 -129,518,636 -103,746,677 -233,265,313
6 BANQUET 3,162,145,348 215,613,041 3,377,758,389 2,712,000,000 119,750,000 2,831,750,000 450,145,348 95,863,041 546,008,389
7 MINI BAR 1,174,281 0 1,174,281 0 0 0 1,174,281 0 1,174,281
TOTAL 5,157,172,026 921,148,198 6,078,320,224 4,823,286,449 785,741,794 5,609,028,243 333,885,577 135,406,404 469,291,981

F&B ACTUAL VS BUDGET REVENUE - SEPT 2022 OUTLET DAILY BUDGET MONTHLY BUDGET
SWISS CAFE - ALA CARTE 1,147,383 34,421,495
600,000,000
NO OUTLET REV VS BUDGET 550,399,987 SWISS CAFÉ- ROOM BREAKFAST 5,662,527 169,875,815
SWISS DELI 0 0
500,000,000
ACTUAL SWISS CAFÉ - ALA CARTE 30,090,073 SAWAK LOUNGE 3,049,290 91,478,710
1
BUDGET SWISS CAFÉ - ALA CARTE 34,421,495 ROOM SERVICE 1,907,557 57,226,706
400,000,000
ACTUAL SWISS CAFÉ-ROOM BREAKFAST 159,004,117 FB OUTLET 11,766,758 353,002,726
2 317,000,000
BUDGET SWISS CAFÉ- ROOM BREAKFAST 169,875,815 BANQUET 10,566,667 317,000,000
300,000,000
ACTUAL - SWISS DELI 2,291,893 FB-OTHER 833,333 25,000,000
3
BUDGET - SWISS DELI 0
200,000,000
169,875,815 TOTAL 11,400,000 342,000,000
159,004,117
ACTUAL - SAWAK LOUNGE 100,109,588
91,478,710 DAILY BUDGET 23,166,758 695,002,726
4 100,109,588
BUDGET -SAWAK LOUNGE 91,478,710 34,421,495
100,000,000
57,226,706 25,000,000 .
ACTUAL - IN ROOM DINNING 29,505,785 30,090,073 29,505,785 22,900,817 SERVICE CHARGE 2,246,314 69,635,731
5 2,291,893 0
BUDGET - IN ROOM DINNING 57,226,706 0
E E T T LI LI GE GE G G E TE R R
RT RT AS AS DE DE IN IN ET HE HE
6
ACTUAL-BANQUETE 550,399,987
CA CA KF KF ISS ISS LO
UN
LO
UN
DI
NN
DI
NN QU NQ
UE
OT OT GRAND TOTAL 25,413,071 765,993,043
A A EA EA W AN BA B -F
B
BUDGET - BANQUETE 317,000,000 AL AL BR BR SW -S AK AK OM OM -B -F ET
- - - ET A L
ET
- AL
FÉ FÉ M OM AL AW AW RO RO TU TU DG
CA CA OO TU DG -S -S DG AC BU
ACTUAL-FB OTHER 22,900,817
ISS ISS FÉ
-R É-
RO
AC BU A L ET L-
IN
ET
- IN AC BU ACTUAL 983,742,907
7
SW SW CA AF TU DG A
AC BU TU DG
BUDGET-FB OTHER 25,000,000 A L E T ISS
ISS
C
AC BU VAR 217,749,864
TU DG SW SW
F & B ACTUAL REVENUE 894,302,260 AC BU AL ET DAY LEFT
TU DG
AC BU
F&B MONTHLY BUDGET 695,002,726 TARGET TO ACHIEVE PER DAY 217,749,864

ACTUAL MTD-FB SERVICE CHARGE 89,440,647


8
BUDGET MONTHLY -FBSERVICE CHARGE 69,635,731 MTD SEPT 2022 - HOTEL REVENUE
19,804,916 DESCRIPTION % ACT ACTUAL BUDGET % BUDGET VAR ACHIEVEMENT DIFF
ROOM 49.83% 1,156,584,227 1,225,086,759 56.18% -68,502,532 94.41% -5.6%
WHOLE BUDGET 765,993,043 FB 37.54% 871,401,443 671,357,312 30.79% 200,044,131 129.80% 29.8%
ACTUAL 983,742,907 CIGARETE 0.02% 404,132 0 0.00%
DIFF 217,749,864 219.104.450 LAUNDRY 0.99% 23,011,322 25,064,800 1.15% -2,053,478 91.81% -8.2%

128.43% 128.65% SPA 1.34% 31,029,625 29,940,712 1.37% 1,088,913 103.64% 3.6%
28.4% BISNIS CENTER 0.03% 601,942 250,000 0.01% 351,942 240.78% 140.8%
FB OUTLET FORECAST TELECOMUNICATION 0.00% 0 200,000 0.01% -200,000 0.00% -100.0%
1 SWISS CAFÉ- ALA CARTE 2,006,005 OTHER 1.14% 26,513,197 31,000,000 1.42% -4,486,803 85.53% -14.5%
2 SWISS DELI 152,793 SERVICE CHARGE 9.12% 211,658,767 197,689,958 9.07% 13,968,809 107.07% 7.1%
3 SAWAK LOUNGE 6,673,973 TOTAL 100.0% 2,321,204,655 2,180,589,541 100.00% 140,210,982 106.45% 6.4%
4 IN ROOM DINNING 1,967,052 VAR ACTUAL VS BUDGET (%)

TOTAL 10,799,823 FB MTD VS BUDGET (ACHIEVEMENT) 125.4% 25.38% 469,291,981 108.4%


FORECAST 161,997,339 F&B - ACT YTD VS BUDGET YTD 6,078,320,224 5,609,028,243 -1,452,292,608 83.7%
TOTAL TARGET 323,994,678 ROOM - ACT YTD VS BUDGET YTD 7,476,918,162 8,929,210,770 -1,248,218,824 92.5%
HOTEL- ACTUAL YTD VS BUDGET YTD 15,439,899,378 16,688,118,202

-1,512,898,468 -504,299,489

FB YTD BUDGET 7,591,218,692 6,078,320,224


FOOD AND BEVERAGES DAILY REVENUE ANALYSIS - OCTOBER 2022 SWISS-BELHOTEL MERAUKE
TODAY REVENUE - 12 OCT 2022 MTD REVENUE MTD BUDGET REVENUE VAR
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 2,318,182 521,488 2,839,670 8,618,435 3,975,207 12,593,642 8,134,616 5,189,834 13,324,450 483,819 -1,214,627 -730,808
2 SWISS CAFÉ - BREAKFAST 3,520,661 0 3,520,661 62,061,978 0 62,061,978 70,520,760 0 70,520,760 -8,458,782 0 -8,458,782
3 SWISS DELI 88,430 0 88,430 1,571,488 0 1,571,488 0 0 0 1,571,488 0 1,571,488
4 SAWAK LOUNGE 2,711,818 3,152,066 5,863,884 17,116,198 14,902,107 32,018,305 17,057,489 17,704,634 34,762,123 58,709 -2,802,527 -2,743,818
5 IN ROOM DINNING 85,124 0 85,124 3,944,463 1,704,132 5,648,595 14,449,119 9,895,977 24,345,095 -10,504,656 -8,191,845 -18,696,500
6 BANQUET 0 0 0 420,635,447 6,446,281 427,081,728 94,141,935 4,025,806 98,167,742 326,493,512 2,420,475 328,913,986
TOTAL 8,724,215 3,673,554 12,397,769 513,948,009 27,027,727 540,975,736 204,303,919 36,816,250 241,120,169 309,644,090 -9,788,523 299,855,567
8,877,108 10,741,301
ACTUAL YTD BUDGET YTD VAR YTD
NO OUTLET
FOOD BEVERAGE TOTAL FOOD BEVERAGE TOTAL FOOD BEVERAGE DIFF
1 SWISS CAFÉ- ALA CARTE 528,848,143 227,149,750 755,997,893 323,862,963 207,660,838 531,523,801 204,985,180 19,488,912 224,474,092
2 SWISS CAFÉ - BREAKFAST 1,025,088,226 0 1,025,088,226 1,320,442,190 0 1,320,442,190 -295,353,964 0 -295,353,964
3 SWISS DELI 42,829,937 0 42,829,937 0 0 0 42,829,937 0 42,829,937
4 SAWAK LOUNGE 347,698,365 421,768,340 769,466,705 291,303,589 302,474,406 593,777,995 56,394,776 119,293,934 175,688,710
5 IN ROOM DINNING 129,365,908 72,611,735 201,977,643 267,479,360 183,181,919 450,661,279 -138,113,452 -110,570,184 -248,683,636
6 BANQUET 3,573,111,374 220,406,429 3,793,517,803 2,790,451,613 123,104,839 2,913,556,452 782,659,761 97,301,590 879,961,351
7 MINI BAR 1,174,281 0 1,174,281 0 0 0 1,174,281 0 1,174,281
TOTAL 5,648,116,234 941,936,254 6,590,052,488 4,993,539,715 816,422,002 5,809,961,717 654,576,519 125,514,252 780,090,771

F&B ACTUAL VS BUDGET REVENUE - OCT 2022 OUTLET DAILY BUDGET MONTHLY BUDGET
SWISS CAFE - ALA CARTE 1,110,371 34,421,495
450,000,000
NO OUTLET REV VS BUDGET 427,081,728 SWISS CAFÉ- ROOM BREAKFAST 5,876,730 182,178,630
400,000,000 SWISS DELI 0 0
ACTUAL SWISS CAFÉ - ALA CARTE 12,593,642 SAWAK LOUNGE 2,896,844 89,802,150
1 350,000,000
BUDGET SWISS CAFÉ - ALA CARTE 34,421,495 ROOM SERVICE 2,028,758 62,891,496
ACTUAL SWISS CAFÉ-ROOM BREAKFAST 62,061,978 300,000,000 FB OUTLET 11,912,702 369,293,771
2
BUDGET SWISS CAFÉ- ROOM BREAKFAST 182,178,630 BANQUET 8,180,645 253,600,000
250,000,000
ACTUAL - SWISS DELI 1,571,488 253,600,000 FB-OTHER 806,452 25,000,000
3
BUDGET - SWISS DELI 0 200,000,000 182,178,630 TOTAL 8,987,097 278,600,000
ACTUAL - SAWAK LOUNGE 32,018,305
150,000,000
DAILY BUDGET 20,899,799 647,893,771
4
BUDGET -SAWAK LOUNGE 89,802,150 .
89,802,150
100,000,000
5
ACTUAL - IN ROOM DINNING 5,648,595 62,061,978 62,891,496 64,789,377
55,544,055
SERVICE CHARGE 2,089,980 64,789,377
BUDGET - IN ROOM DINNING 62,891,496 34,421,495 32,018,305
50,000,000
12,593,642 14,338,84325,000,000
5,648,595
6
ACTUAL-BANQUETE 427,081,728 1,571,488 0 GRAND TOTAL 22,989,779 712,683,148
BUDGET - BANQUETE 253,600,000 0
E E T T LI LI GE GE G G E TE R R GE GE
RT RT AS AS DE DE IN IN ET UE HE HE
ACTUAL-FB OTHER 14,338,843 CA CA KF KF ISS ISS UN UN NN NN QU NQ OT OT CH
AR
CH
AR ACTUAL 610,858,634
7 LA LA EA EA LO LO DI DI AN B B
BR BR SW SW AK AK -B BA L-F -F E E
BUDGET-FB OTHER 25,000,000

-A

-A
M - ET
-
AW AW
O M O M
A L
ET
-
TU
A
DG
ET RV
IC
RV
IC VAR -101,824,514
OO OM AL DG
RO RO TU DG SE SE
CA CA -R RO TU -S -S
-I
N
-I
N AC AC BU B B
55,544,055 SI S SI S É - AC BU AL ET BU -F -F DAY LEFT 19
ACTUAL-FB SERVICE CHARGE F FÉ TU DG AL ET AL ET
8 SW SW CA CA AC BU TU DG TU D G
BUDGET-FB SERVICE CHARGE 64,789,377 AL ET ISS ISS AC BU AC BU -5,359,185
TU DG
TARGET TO ACHIEVE PER DAY
AC SW SW
BU AL ET
F & B ACTUAL REVENUE 610,858,634 TU
DG
AC BU
F&B MONTHLY BUDGET 712,683,148
VAR -101,824,514
ACHIVEMENT % 85.71% MTD OCT 2022 - HOTEL REVENUE
TARGET TO ACHIEVE -14.29% DESCRIPTION % ACT ACTUAL BUDGET % BUDGET VAR ACHIEVEMENT DIFF
ROOM 39.19% 426,385,497 430,521,855 56.21% -4,136,358 99.04% -1.0%
FB 49.73% 540,975,736 241,120,169 31.48% 299,855,567 224.36% 124.4%
CIGARETE 0.02% 185,950 0 0.00% 185,950 0.00%
LAUNDRY 0.38% 4,088,512 8,668,903 1.13% -4,580,391 47.16% -52.8%
SPA 0.97% 10,575,978 9,658,294 1.26% 917,684 109.50% 9.5%
BISNIS CENTER 0.02% 241,322 80,645 0.01% 160,677 299.24% 199.2%
TELECOMUNICATION 0.00% 0 64,516 0.01% -64,516 0.00% -100.0%
OTHER 0.84% 9,103,719 10,000,000 1.31% -896,281 91.04% -9.0%
SERVICE CHARGE 8.86% 96,375,461 65,799,221 8.59% 30,576,240 146.47% 46.5%
TOTAL 100.0% 1,087,932,175 765,913,603 100.00% 322,018,572 142.04% 42.0%

FB MTD VS BUDGET (ACHIEVEMENT) 83.5% -16.50% VAR ACTUAL VS BUDGET (%)

F&B - ACT YTD VS BUDGET YTD 6,590,052,488 5,809,961,717 780,090,771 113.4%


ROOM - ACT YTD VS BUDGET YTD 8,090,609,692 9,523,077,526 -1,432,467,834 85.0%
HOTEL- ACTUAL YTD VS BUDGET YTD 16,921,524,325 17,704,590,383 -783,066,058 95.6%

FB YTD BUDGET 7,591,218,692 6,590,052,488 -1,001,166,204 -400,466,482


72 -13,905,086
SAWAK LOUNGE - YTD ACTUAL VS BUDGET 2022
NO YTD - 2022 ACTUAL REVENUE FOOD BEVERAGE VAR
140,000,000
ACTUAL 48,565,698 20,266,116 28,299,582
1 JANUARY 4,899,078
BUDGET 43,666,620 21,425,550 22,241,070

ACTUAL 27,330,823 11,072,562 16,258,261


2 FEBRUARY -19,881,157
BUDGET 47,211,980 23,162,070 24,049,910
120,000,000

ACTUAL 75,190,052 24,825,207 50,364,845


3 MARCH 26,205,392
BUDGET 48,984,660 24,030,330 24,954,330

ACTUAL 97,182,642 30,638,017 66,544,625


4 APRIL 54,082,212
100,000,000 97,182
BUDGET 43,100,430 21,140,395 21,960,035

MTD ACTUAL 129,589,577 47,258,595 82,330,982


5 MAY 77,881,856
BUDGET 51,707,721 23,726,224 24,645,505

MTD ACTUAL 71,543,058 28,464,876 43,078,182 80,000,000


6 JUNE -924,572 75,190,052
MTD BUDGET 72,467,630 35,543,275 36,924,355

MTD ACTUAL 93,832,703 51,623,612 42,209,091


7 JULY 16,604,753
BUDGET 77,227,950 37,882,330 39,345,620
60,000,000
MTD ACTUAL 100,850,211 60,279,132 40,571,079
AUGUST 11,886,349 48,565,698
MTD BUDGET 88,963,862 43,652,991 45,310,871 48,984,660
47,211,980
43
MTD ACTUAL 100,109,588 59,277,687 40,831,901 43,666,620
SEPT 8,630,878
40,000,000

27,330,823
48,565,698

48,984,660
47,211,980
43
43,666,620
SEPT 8,630,878
BUDGET 91,478,710 44,889,560 46,589,150 40,000,000

MTD ACTUAL 32,018,305 17,116,198 14,902,107


OCT -57,783,845
BUDGET 89,802,150 44,065,180 45,736,970 27,330,823

MTD ACTUAL
NOV 0 20,000,000
BUDGET

MTD ACTUAL
DEC 0
BUDGET

YTD ACTUAL 644,084,764 274,428,117 369,656,647 0


TOTAL 170,753,911 JANUARY FEBRUARY MARCH APRIL
YTD BUDGET 473,330,853 230,563,165 239,431,696

ACTUAL YTD FOOD 274,428,117 42.6%


ACTUAL YTD BEVERAGE 369,656,647 57.4%
TOTAL 644,084,764 100.0%
129,589,577

100,850,211 100,109,588
97,182,642
93,832,703
91,478,710
89,802,150
88,963,862

77,227,950
0,052
72,467,630

71,543,058

51,707,721
8,984,660
43,100,430

32,018,305
51,707,721
8,984,660
43,100,430

32,018,305

CH APRIL MAY JUNE JULY AUGUST SEPT OCT


BUDGET 2022
NO FOOD AND BEVERAGE OUTLET BUDGET JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER
1 SWISS CAFFEE BREAKFAST 1,812,513,735 99,634,620 122,119,075 136,846,090 118,785,800 140,421,785 150,300,400 157,936,630 165,754,675 169,875,815 182,178,630 199,148,030 169,512,185
2 SWISS CAFEE ALA CARTE 631,678,678 34,174,412 34,126,294 34,043,806 236,185,310 41,995,670 36,699,010 34,401,811 34,372,285 34,421,495 34,421,495 38,418,545 38,418,545
3 SWISS DELI 0 0 0 0 0 0 0 0 0 0 0 0 0
4 SAWAK LOUNGE 818,409,000 43,666,620 47,211,980 48,984,660 43,100,430 51,707,710 72,467,630 77,227,950 88,963,870 91,478,710 89,802,150 82,769,560 81,027,730
5 ROOM SERVICE 620,642,279 33,684,555 41,288,713 46,357,017 40,199,973 47,685,808 50,826,896 54,522,740 57,226,706 58,581,292 62,891,496 68,795,791 58,581,292
6 BANQUET 3,407,975,000 198,750,000 254,500,000 198,725,000 275,000,000 300,425,000 526,100,000 505,625,000 255,625,000 317,000,000 253,600,000 130,625,000 192,000,000
7 FB OTHER 300,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000
8 SERVICE CHARGE 759,121,869 43,491,021 52,424,606 48,995,657 73,827,151 60,723,597 86,139,394 85,471,413 62,694,254 69,635,731 64,789,377 54,475,693 56,453,975
TOTAL 8,350,340,561 478,401,228 576,670,668 538,952,230 812,098,664 667,959,570 947,533,330 940,185,544 689,636,790 765,993,043 712,683,148 599,232,619 620,993,727

ACTUAL
FORECAST FORECAST FORECAST
NO FOOD AND BEVERAGE OUTLET ACTUAL YTD JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER FORECAST OCTOBER NOVEMBER DECEMBER OUTLET REV %

1 SWISS CAFFEE BREAKFAST 1,508,360,780 61,049,572 59,389,529 104,966,927 101,391,738 118,797,509 123,946,245 84,360,492 157,054,003 198,754,704 185,822,203 194,169,329 118,658,530 28.4%
2 SWISS CAFEE ALA CARTE 869,625,371 68,128,941 22,236,917 73,834,883 307,014,211 111,405,094 47,889,787 41,809,755 44,341,699 36,142,570 36,142,570 40,339,472 40,339,472
3 SWISS DELI 52,081,342 909,091 3,482,334 7,997,107 7,512,810 10,087,603 2,553,719 3,033,058 3,505,620 3,250,000 3,250,000 3,250,000 3,250,000
4 SAWAK LOUNGE 808,454,806 48,565,698 27,330,823 75,190,052 97,182,642 129,589,577 71,543,058 91,282,703 100,850,211 32,017,549 44,901,075 41,384,780 48,616,63810.3%
5 ROOM SERVICE 264,213,485 18,993,388 9,804,132 20,637,025 19,684,048 32,253,719 15,119,008 15,036,364 36,074,917 23,432,517 25,156,598 27,518,316 20,503,452 3.2%
6 BANQUET 3,886,989,780 202,603,308 188,863,636 448,387,410 107,314,044 431,966,941 535,376,028 511,151,577 381,879,336 339,190,000 304,320,000 195,937,500 240,000,00046.5%
7 FB OTHER 209,962,811 2,314,050 4,958,678 20,247,934 21,157,025 32,314,049 35,041,322 7,851,240 20,578,513 18,000,000 17,500,000 13,750,000 16,250,000 2.5%
8 SERVICE CHARGE 759,968,837 40,256,405 31,606,605 75,126,134 66,125,652 86,641,449 83,146,917 75,452,519 74,428,430 65,078,734 61,709,245 51,634,940 48,761,809 9.1%
TOTAL 8,359,657,212 442,820,453 347,672,654 826,387,472 727,382,170 953,055,941 914,616,084 829,977,708 818,712,729 715,866,072 678,801,690 567,984,338 536,379,901 100.0%
0.1% -7.4% -39.7% 53.3% -10.4% 42.7% -3.5% -11.7% 18.7% -6.5% -4.8% -5.2% -13.6%
ACTUAL VS BUDGET 22 9,316,651 -35,580,775 -228,998,014 287,435,242 -84,716,495 285,096,371 -32,917,246 -110,207,836 129,075,939 -50,126,971 -33,881,458 -31,248,281 -84,613,826
0.11%

BUDGET 2023
NO FOOD AND BEVERAGE OUTLET ACTUAL YTD JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER OUTLET REV % EXPENCES RATIO %
COMPARE WITH BSP
1 SWISS CAFFEE BREAKFAST 1,785,361,570 97,392,562 97,898,760 134,345,041 116,526,860 142,849,174 170,588,843 140,014,463 183,345,041 149,834,711 184,154,959 201,061,983 167,349,174 29.8% 196,104,752 1,785,361,570 1,785,361,570 0
2 SWISS CAFEE ALA CARTE 850,025,972 41,528,768 29,479,755 80,169,628 254,407,819 71,826,447 58,053,979 49,769,400 58,314,336 38,672,550 55,659,557 60,509,208 51,634,524 850,025,972 850,025,972 0
3 SWISS DELI 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 SAWAK LOUNGE 810,584,308 58,251,442 61,893,870 70,046,403 58,524,338 81,335,297 77,582,322 68,805,253 80,737,917 62,216,500 57,096,207 65,934,231 68,160,526 9.2% 60,317,290 810,584,308 810,584,308 0
5 ROOM SERVICE 313,896,830 27,212,189 24,476,032 20,528,347 27,281,498 28,604,917 25,850,165 26,448,678 29,817,609 24,643,041 27,674,774 26,410,979 24,948,601 3.5% 23,357,726 313,896,830 313,896,830 0
6 BANQUET 3,986,467,420 208,729,294 192,048,033 325,969,809 146,263,590 420,566,679 408,550,770 389,701,215 395,530,580 423,765,642 418,340,863 324,112,230 332,888,715 45.0% 296,641,459 3,986,467,420 3,986,467,420 0
7 FB OTHER 306,000,000 25,500,000 25,500,000 25,500,000 25,500,000 25,500,000 25,500,000 25,500,000 25,500,000 25,500,000 25,500,000 25,500,000 25,500,000 3.5% 22,770,106 306,000,000 306,000,000 0
8 SERVICE CHARGE 805,233,610 45,861,426 43,129,645 65,655,923 62,850,410 77,068,251 76,612,608 70,023,901 77,324,548 72,463,244 76,842,636 70,352,863 67,048,154 9.1% 59,919,133 805,233,610 805,233,610 0
TOTAL 8,857,569,710 504,475,681 474,426,095 722,215,151 691,354,514 847,750,765 842,738,687 770,262,911 850,570,033 797,095,688 845,268,996 773,881,496 737,529,695 100.0% 659,110,467 8,857,569,710 8,857,569,710 0
% 5.62% 12.22% 26.72% -14.42% -5.21% -12.42% -8.53% -7.75% 3.75% 10.19% 19.69% 26.61% 27.27%
DIFF 497,912,498 61,655,228 126,753,440 -104,172,321 -36,027,656 -105,305,176 -71,877,397 -59,714,797 31,857,304 81,229,616 166,467,306 205,897,158 201,149,793
659,110,467
REVENUE PERSENTAGE 100.00% 5.70% 5.36% 8.15% 7.81% 9.57% 9.51% 8.70% 9.60% 9.00% 9.54% 8.74% 8.33% 2

BUDGET 2022 507,229,149 6.07%


BUDGET 2023-COMPARE TO 0.45%
ACTUAL 2022 +FRC 497,912,498 5.62%
% ACHIEVEMENT BDT VS ACTUAL 22
FORECAST FORECAST FORECAST
NO FOOD AND BEVERAGE OUTLET ACTUAL YTD JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER FORECAST OCTOBER NOVEMBER DECEMBER
1 SWISS CAFFEE BREAKFAST -16.8% -39% -51% -23% -15% -15% -18% -47% -5% 17% 2% -3% -30%
2 SWISS CAFEE ALA CARTE 37.7% 99% -35% 117% 30% 165% 30% 22% 29% 5% 5% 5% 5%
3 SWISS DELI
4 SAWAK LOUNGE -1.2% 11% -42% 53% 125% 151% -1% 18% 13% -65% -50% -50% -40%
5 ROOM SERVICE -57.4% -44% -76% -55% -51% -32% -70% -72% -37% -60% -60% -60% -65%
6 BANQUET 14.1% 2% -26% 126% -61% 44% 2% 1% 49% 7% 20% 50% 25%
7 FB OTHER -30.0% -91% -80% -19% -15% 29% 40% -69% -18% -28% -30% -45% -35%
8 SERVICE CHARGE 0.1% -7% -40% 53% -10% 43% -3% -12% 19%
TOTAL 0.1% -7% -40% 53% -10% 43% -3% -12% 19% -7% -5% -5.21% -13.6%

ACTUAL EXPENCES - 2022


FORECAST FORECAST FORECAST
NO Other Expenses General FB GENERAL JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER FORECAST OCTOBER NOVEMBER DECEMBER AV SEPTEMBER OCTOBER NOVEMBER DECEMBER

1 Cleaning & Chemical 25,730,891 1,410,206 1,630,297 2,635,544 2,733,725 2,124,244 5,260,691 2,485,813 2,638,174 2,247,451 1,410,409 1,154,339 2,144,241 2,638,174 0.37% ### 2,247,451### 678,801,690 ### 0.25% 567,984,338 1,154,339 0.22% ###
2 Uniform Laundry 291,263 0 0 0 0 0 0 252,288 31,086 3,685 2,312 1,892 24,272 31,086 0.00% ### 3,685### 678,801,690 ### 0.00% 567,984,338 1,892 0.00% ###
3 Flower & Decoration 577,244 0 0 0 0 0 0 500,000 61,608 7,302 4,583 3,751 48,104 61,608 0.01% ### 7,302### 678,801,690 ### 0.00% 567,984,338 3,751 0.00% ###
4 Linen Laundry 5,009,391 289,583 289,583 189,809 289,809 0 1,441,834 1,182,171 523,171 375,228 235,478 192,725 417,449 523,171 0.07% ### 375,228### 678,801,690 ### 0.04% 567,984,338 192,725 0.04% ###
5 Operating Supplies 55,683,533 5,907,662 4,630,885 11,083,953 2,225,535 4,584,305 6,394,460 3,319,698 6,026,990 5,375,560 3,373,482 2,761,002 4,640,294 6,026,990 0.84% ### 5,375,560### 678,801,690 ### 0.59% 567,984,338 2,761,002 0.51% ###
6 KItchen Fuel 234,526,814 14,422,689 13,743,420 24,276,503 34,519,450 21,820,132 29,547,446 28,528,561 24,391,299 20,211,896 12,684,161 10,381,258 19,543,901 24,391,299 3.41% ### 20,211,896### 678,801,690 ### 2.23% 567,984,338 10,381,258 1.94% ###
7 License & Permit 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
8 Telephone & Fax 2,891,288 342,852 270,930 143,775 342,852 273,394 345,970 245,970 323,196 281,316 176,543 144,490 240,941 323,196 0.05% ### 281,316### 678,801,690 ### 0.03% 567,984,338 144,490 0.03% ###
9 Miscellaneous 11,127,863 1,033,125 628,941 225,546 1,113,834 2,377,726 1,291,086 1,216,331 1,157,477 973,201 610,741 499,856 927,322 1,157,477 0.16% ### 973,201### 678,801,690 ### 0.11% 567,984,338 499,856 0.09% ###
10 Music & Intertainment 63,685,594 5,500,000 7,600,000 8,600,000 4,500,000 5,500,000 6,400,000 7,500,000 5,202,779 6,016,688 3,775,828 3,090,299 5,307,133 5,202,779 0.73% ### 6,016,688### 678,801,690 ### 0.66% 567,984,338 3,090,299 0.58% ###
11 Printing & Stationary 21,962,484 995,206 755,495 2,391,015 3,025,058 5,654,562 1,215,793 1,835,774 2,142,159 1,843,572 1,156,951 946,898 1,830,207 2,142,159 0.30% ### 1,843,572### 678,801,690 ### 0.20% 567,984,338 946,898 0.18% ###
12 Chinaware, Glassware, Silverware 4,373,783 1,368,000 0 0 0 0 1,530,000 0 487,006 461,791 289,801 237,186 364,482 487,006 0.07% ### 461,791### 678,801,690 ### 0.05% 567,984,338 237,186 0.04% ###
13 Linen 7,083,785 601,074 671,345 735,606 417,000 792,793 830,146 887,126 773,148 642,425 403,160 329,963 590,315 773,148 0.11% ### 642,425### 678,801,690 ### 0.07% 567,984,338 329,963 0.06% ###
14 Uniforms 17,327,682 200,000 200,000 0 200,000 200,000 6,581,194 6,278,194 1,664,040 936,051 587,428 480,776 1,443,974 1,664,040 0.23% ### 936,051### 678,801,690 ### 0.10% 567,984,338 480,776 0.09% ###
15 Travel - Meals & Entertainment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
16 FB - Marketing Promotion 86,518,285 2,774,578 0 9,390,421 13,503,128 0 11,164,458 30,045,060 8,651,699 5,132,188 3,220,752 2,636,001 7,209,857 8,651,699 1.21% ### 5,132,188### 678,801,690 ### 0.57% 567,984,338 2,636,001 0.49% ###
17 Menu & Beverage List 4,032,502 0 0 0 0 352,000 2,663,550 0 335,592 318,217 199,700 163,443 336,042 335,592 0.05% ### 318,217### 678,801,690 ### 0.04% 567,984,338 163,443 0.03% ###
18 Food & Beverage Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
19 Courier & Postage 0 0 0 0 0 0 (0) 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
20 Complimentary Services & Gifts 1,231,347 155,000 140,000 0 0 0 0 609,000 152,015 81,885 51,388 42,058 102,612 152,015 0.02% ### 81,885### 678,801,690 ### 0.01% 567,984,338 42,058 0.01% ###
21 Contract Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
22 Paper & Plastic 52,934,616 4,420,216 2,006,349 7,206,892 6,507,156 8,190,268 6,286,665 2,743,193 5,337,508 4,780,713 3,000,181 2,455,476 4,411,218 5,337,508 0.75% ### 4,780,713### 678,801,690 ### 0.53% 567,984,338 2,455,476 0.46% ###
23 Dish Washing Supplies 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
24 Dues & Subscriptions 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
25 Rental Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
26 Flatware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
27 Glassware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
28 Silverware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
29 Ice 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
30 Training 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% ### 0### 678,801,690 0 0.00% 567,984,338 0 0.00% ###
31 Utensil 4,469,803 0 0 0 2,613,000 390,000 139,163 35,000 429,097 403,302 253,096 207,145 372,484 429,097 0.06% ### 403,302### 678,801,690 ### 0.04% 567,984,338 207,145 0.04% ###
TOTAL OTHER EXPENSES 599,458,169 39,420,191 32,567,244 66,879,063 71,990,547 52,259,423 81,092,455 87,664,178 0 60,328,044 50,092,473 31,435,993 25,728,556 49,954,847 264,764 8.43% ### 5.53% 4.80%

7.18%
FORECAST FORECAST FORECAST
NO Other Expenses General FB GENERAL JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER FORECAST OCTOBER NOVEMBER DECEMBER AV SEPTEMBER OCTOBER NOVEMBER DECEMBER

1 Cleaning & Chemical 3.74% 0.32% 0.47% 0.32% 0.38% 0.22% 0.58% 0.30% 0.00% 0.37% 0.33% 0.25% 0.22% 0.31% 1,523,377 0.37%
### ### 0.25% 0.22%
2 Uniform Laundry 0.04% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.03% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 21,024 0.00%
### ### 0.00% 0.00%
3 Flower & Decoration 0.07% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.06% 0.00% 0.01% 0.00% 0.00% 0.00% 0.01% 41,667 0.01%
### ### 0.00% 0.00%
4 Linen Laundry 0.72% 0.07% 0.08% 0.02% 0.04% 0.00% 0.16% 0.14% 0.00% 0.07% 0.06% 0.04% 0.04% 0.06% 306,899 0.07%
### ### 0.04% 0.04%
5 Operating Supplies 8.64% 1.33% 1.33% 1.34% 0.31% 0.48% 0.70% 0.40% 0.00% 0.84% 0.79% 0.59% 0.51% 0.72% 3,178,875 0.84%
### ### 0.59% 0.51%
6 KItchen Fuel 34.40% 3.26% 3.95% 2.94% 4.75% 2.29% 3.23% 3.44% 0.00% 3.41% 2.98% 2.23% 1.94% 2.87% 13,904,850 3.41%
### ### 2.23% 1.94%
7 License & Permit 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
8 Telephone & Fax 0.46% 0.08% 0.08% 0.02% 0.05% 0.03% 0.04% 0.03% 0.00% 0.05% 0.04% 0.03% 0.03% 0.04% 163,812 0.05%
### ### 0.03% 0.03%
9 Miscellaneous 1.64% 0.23% 0.18% 0.03% 0.15% 0.25% 0.14% 0.15% 0.00% 0.16% 0.14% 0.11% 0.09% 0.14% 657,216 0.16%
### ### 0.11% 0.09%
10 Music & Intertainment 10.12% 1.24% 2.19% 1.04% 0.62% 0.58% 0.70% 0.90% 0.00% 0.73% 0.89% 0.66% 0.58% 0.84% 3,800,000 0.73%
### ### 0.66% 0.58%
11 Printing & Stationary 3.05% 0.22% 0.22% 0.29% 0.42% 0.59% 0.13% 0.22% 0.00% 0.30% 0.27% 0.20% 0.18% 0.25% 1,322,742 0.30%
### ### 0.20% 0.18%
12 Chinaware, Glassware, Silverware 0.71% 0.31% 0.00% 0.00% 0.00% 0.00% 0.17% 0.00% 0.00% 0.07% 0.07% 0.05% 0.04% 0.06% 24,500 0.07%
### ### 0.05% 0.04%
13 Linen 1.09% 0.14% 0.19% 0.09% 0.06% 0.08% 0.09% 0.11% 0.00% 0.11% 0.09% 0.07% 0.06% 0.09% 411,257 0.11%
### ### 0.07% 0.06%
14 Uniforms 2.19% 0.05% 0.06% 0.00% 0.03% 0.02% 0.72% 0.76% 0.00% 0.23% 0.14% 0.10% 0.09% 0.18% 1,138,282 0.23%
### ### 0.10% 0.09%
15 Travel - Meals & Entertainment 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
16 FB - Marketing Promotion 11.48% 0.63% 0.00% 1.14% 1.86% 0.00% 1.22% 3.62% 0.00% 1.21% 0.76% 0.57% 0.49% 0.96% 5,573,137 1.21%
### ### 0.57% 0.49%
17 Menu & Beverage List 0.49% 0.00% 0.00% 0.00% 0.00% 0.04% 0.29% 0.00% 0.00% 0.05% 0.05% 0.04% 0.03% 0.04% 251,296 0.05%
### ### 0.04% 0.03%
18 Food & Beverage Testing 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
19 Courier & Postage 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
20 Complimentary Services & Gifts 0.20% 0.04% 0.04% 0.00% 0.00% 0.00% 0.00% 0.07% 0.00% 0.02% 0.01% 0.01% 0.01% 0.02% 75,333 0.02%
### ### 0.01% 0.01%
21 Contract Services 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
22 Paper & Plastic 7.66% 1.00% 0.58% 0.87% 0.89% 0.86% 0.69% 0.33% 0.00% 0.75% 0.70% 0.53% 0.46% 0.64% 3,113,395 0.75%
### ### 0.53% 0.46%
23 Dish Washing Supplies 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
24 Dues & Subscriptions 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
25 Rental Equipment 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
26 Flatware 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
27 Glassware 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
28 Silverware 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
29 Ice 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
30 Training 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0 0.00% 0 ### 0.00% 0.00%
31 Utensil 0.62% 0.00% 0.00% 0.00% 0.36% 0.04% 0.02% 0.00% 0.00% 0.06% 0.06% 0.04% 0.04% 0.05% 0 0.06% 0 ### 0.04% 0.04%
TOTAL OTHER EXPENSES 87.31% 8.90% 9.37% 8.09% 9.90% 5.48% 8.87% 10.56% 0.00% 8.43% 7.38% 5.53% 4.80% 7.28% 264,764 8.43%
### 264,764### 0 ### 5.53% 0 264,764 4.80% 0
60.45%
0.0863571428571429
FOOD AND BEVERAGE COMPARISON - BUDGET 2022, ACTUAL 2022 & BUDGET 2023
ACTUAL VS BUDGET 2023
NO OUTLET BUDGET 2022 ACTUAL + FORECAST 2022 BUDGET 2023
% ACHIEVEMENT
1 SWISS CAFÉ- ALA CARTE 631,678,678 755,514,898 779,369,614 3% 23,854,717
2 SWISS CAFÉ - BREAKFAST 1,812,513,735 1,600,864,152 1,604,881,005 0% 4,016,853
3 SWISS DELI 0 0 0
4 SAWAK LOUNGE 818,409,000 911,734,564 948,440,220 4% 36,705,657
5 IN ROOM DINNING 620,642,279 264,213,484 342,384,566 23% 78,171,082
6 BANQUET 3,407,975,000 3,819,204,923 3,919,741,737 3% 100,536,814
7 MINI BAR 0 0 0
8 OTHER FB REVENUE 300,000,000 244,462,809 300,000,000 19% 55,537,191
TOTAL 7,591,218,692 7,595,994,829 7,894,817,143 298,822,314
9 SERVICE 759,121,869 759,599,483 789,481,714 3.79%
328,704,546
TOTAL 8,350,340,561 8,355,594,311 8,684,298,857

BUDGET 2023 VS BUDGET 2022 3.846%


BUDGET 2022
1,000,000,000
NO DESCRIPTIONS REV

1 JAN 478,401,228 900,000,000


812,098,664
2 FEB 576,670,668 800,000,000
3 MAR 538,952,230 667,9
700,000,000
4 APR 812,098,664 576,670,668
600,000,000
5 MAY 667,959,570 538,952,230
478,401,228
6 JUN 947,533,330 500,000,000

7 JUL 940,185,544
400,000,000
8 AUG 689,636,790
300,000,000
9 SEP 765,993,043

10 OCT 712,683,148 200,000,000

11 NOV 599,232,619 100,000,000

12 DEC 620,993,727
0
TOTAL 8,350,340,561 JAN FEB MAR APR M

ACTUAL 2022 + FORCAST


1,000,000,000 953,05
NO DESCRIPTIONS REV
900,000,000
1 JAN 442,820,453 826,387,472

2 FEB 347,672,654 800,000,000


727,382,170
3 MAR 826,387,472 700,000,000

4 APR 727,382,170
600,000,000
5 MAY 953,055,941
500,000,000 442,820,453
6 JUN 914,616,084

7 JUL 829,977,708 400,000,000 347,672,654

8 AUG 818,712,729 300,000,000

200,000,000

100,000,000
400,000,000 347,672,654

300,000,000

9 SEP 715,866,072
200,000,000
10 OCT 678,801,690
100,000,000
11 NOV 567,984,338

12 DEC 536,379,901 0
JAN FEB MAR APR MA
TOTAL 8,359,657,212

BUDGET 2023
NO DESCRIPTIONS REV
900,000,000 847,7
JAN 504,475,681
1
800,000,000
FEB 474,426,095 722,215,151
2
700,000,000 691,354,514
MAR 722,215,151
3
APR 691,354,514 600,000,000
4
MAY 847,750,765
5 504,475,681
500,000,000
JUN 842,738,687
6
JUL 770,262,911
400,000,000 474,426,095
7
AUG 850,570,033 300,000,000
8
SEP 797,095,688
9 200,000,000
OCT 845,268,996
10
100,000,000
NOV 773,881,496
11
DEC 737,529,695 0
12 JAN FEB MAR APR M
TOTAL 8,857,569,710

BUDGET 2022 478,401,228


JANUARY ACTUAL 2022 442,820,453 1,000,000,000
BUDGET 2023 504,475,681
BUDGET 2022 576,670,668
FEBRUARY ACTUAL 2022 347,672,654 900,000,000
BUDGET 2023 474,426,095

800,000,000
900,000,000

BUDGET 2022 538,952,230


MARCH ACTUAL 2022 826,387,472 800,000,000
BUDGET 2023 722,215,151
BUDGET 2022 812,098,664
700,000,000
APRIL ACTUAL 2022 727,382,170
BUDGET 2023 691,354,514
BUDGET 2022 667,959,570 600,000,000
MAY ACTUAL 2022 953,055,941
BUDGET 2023 847,750,765
BUDGET 2022 947,533,330 500,000,000
JUNE ACTUAL 2022 914,616,084
BUDGET 2023 842,738,687
BUDGET 2022 940,185,544 400,000,000
JULY ACTUAL 2022 829,977,708
BUDGET 2023 770,262,911
BUDGET 2022 689,636,790 300,000,000
AUGUST ACTUAL 2022 818,712,729
BUDGET 2023 850,570,033
BUDGET 2022 200,000,000
765,993,043
SEPTEMBER ACTUAL 2022 715,866,072
BUDGET 2023 797,095,688
100,000,000
BUDGET 2022 712,683,148
OCTOBER ACTUAL 2022 678,801,690
BUDGET 2023 845,268,996
0
BUDGET 2022 599,232,619
BUDGET 2022
ACTUAL 2022
BUDGET 2023

BUDGET 2022
ACTUAL 2022
BUDGET 2023

BUDGET 2022
ACTUAL 2022
BUDGET 2023

BUDGET 2022
NOVEMBER ACTUAL 2022 567,984,338
BUDGET 2023 773,881,496
BUDGET 2022 620,993,727
JANUARY FEBRUARY MARCH A
DECEMBER ACTUAL 2022 536,379,901
BUDGET 2023 737,529,695

25,000,000
25000000
1 10,000,000
2 25,000,000
3 500,000 20000000
4 650,000
5 2,365,420 15000000

10,000,000
10000000

5000000 2,365,42
500,000 650,000
0
1 2 3 4 5
10000000

5000000 2,365,42
500,000 650,000
0
1 2 3 4 5
947,533,330
940,185,544

812,098,664
765,993,043
712,683,148
689,636,790
667,959,570
599,232,619 620,993,727

538,952,230

MAR APR MAY JUN JUL AUG SEP OCT NOV DEC

953,055,941
914,616,084

,387,472 829,977,708
818,712,729

727,382,170 715,866,072
678,801,690

567,984,338
536,379,901
MAR APR MAY JUN JUL AUG SEP OCT NOV DEC

847,750,765 850,570,033 845,268,996


842,738,687 797,095,688
770,262,911 773,881,496
22,215,151 737,529,695

691,354,514

MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
BUDGET 2022

000
ACTUAL 2022
BUDGET 2023

FEBRUARY

4
BUDGET 2022

650,000
ACTUAL 2022
BUDGET 2023

MARCH

5
BUDGET 2022
ACTUAL 2022

2,365,420
APRIL
BUDGET 2023

BUDGET 2022
ACTUAL 2022

MAY
BUDGET 2023

BUDGET 2022
ACTUAL 2022

JUNE
BUDGET 2023

BUDGET 2022
ACTUAL 2022

JULY
BUDGET 2023

BUDGET 2022
ACTUAL 2022
BUDGET 2023

AUGUST
BUDGET 2022
ACTUAL 2022
BUDGET 2023

SEPTEMBER
BUDGET 2022
ACTUAL 2022
BUDGET 2023

OCTOBER
BUDGET 2022
ACTUAL 2022
BUDGET 2023
NOVEMBER

BUDGET 2022
ACTUAL 2022
DE-
BER
CEM-

BUDGET 2023
2,365,420
000 650,000

4 5
19 620,993,727

DEC

38
536,379,901
DEC

6
737,529,695

DEC
BUDGET 2022
ACTUAL 2022
BUDGET 2023

NOVEMBER
BUDGET 2022
ACTUAL 2022

DE-
BER
CEM-
BUDGET 2023
FOOD AND BEVERAGE BUDGET - 2022 ACTUAL REVENUE (8 + 4 FOR
NO DESCRIPTION BUDGET % %
1 SWISS CAFFEE BREAKFAST 1,812,513,735 21.71% 18.04%
2 SWISS CAFEE ALA CARTE 631,678,678 7.56% 10.40%
3 SWISS DELI 0 0.00% 0.62%
4 SAWAK LOUNGE 818,409,000 9.80% 9.67%
5 ROOM SERVICE 620,642,279 7.43% 3.16%
6 BANQUET 3,407,975,000 40.81% 46.50%
7 FB OTHER 300,000,000 3.59% 2.51%
8 SERVICE CHARGE 759,121,869 9.09% 9.09%
TOTAL 8,350,340,561 100% 100%
ACTUAL REVENUE (8 + 4 FORECAST-2022) FOOD AND BEVERAGE BUDGET - 2023
ACTUAL DIFF NO DESCRIPTION BUDGET
1,508,360,780 -304,152,955 1 SWISS CAFFEE BREAKFAST 1,785,361,570
869,625,371 237,946,693 2 SWISS CAFEE ALA CARTE 850,025,972
52,081,342 52,081,342 3 SWISS DELI 0
808,454,806 -9,954,195 4 SAWAK LOUNGE 810,584,308
264,213,485 -356,428,794 5 ROOM SERVICE 313,896,830
3,886,989,780 479,014,780 6 BANQUET 3,986,467,420
209,962,811 -90,037,189 7 FB OTHER 306,000,000
759,968,837 846,968 8 SERVICE CHARGE 805,233,610
8,359,657,212 9,316,651 TOTAL 8,857,569,710

106.07% 507,229,149
6.07%
T - 2023
%
20.16%
9.60%
0.00%
9.15%
3.54%
45.01%
3.45%
9.09%
100%
BANQUET BREAKDOWN - EVENT 21 SEPT 2022

NO DESCRIPTION VENUE PAX

1 KEMINFO - THEMATIC ACADEMY A KIDUP 52

2 KEMINFO - THEMATIC ACADEMY B SAKIL B & KARAOKE 82

3 KEMINFO - THEMATIC ACADEMY A FULLBOARD RESMEET 2

4 KEMINFO - THEMATIC ACADEMY B FULLBOARD RESMEET 8

GRAND TOTAL 144


OWN - EVENT 21 SEPT 2022

FOOD BEV RENTAL TOTAL ++ TOTAL NET

13,000,000 2,250,000 2,250,000 14,462,810 17,500,000

22,960,000 2,520,000 2,520,000 23,140,496 28,000,000

560,000 462,810 560,000

2,240,000 1,851,240 2,240,000

38,760,000 4,770,000 4,770,000 39,917,355 48,300,000

TOTAL FB + RENTAL 39,917,355 48,300,000


DRR - 21 SEPT 2022 FB + RENTAL 39,917,356 48,300,001
VAR -1 -1

4000000

You might also like