F&B Revenue Analysis - Jan-Feb 2022
F&B Revenue Analysis - Jan-Feb 2022
F&B ACTUAL VS B
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
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
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%
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%
350,000,000
E
RT
RT
ACTUAL-BANQUETE 212,929,755
CA
CA
6
EA
LA
LA
BR
-A
-A
FÉ
OO
CA
CA
-R
ISS
FÉ
FÉ
W
SW
CA
7
CA
LS
ET
ISS
25,000,000
ISS
BUDGET-FB OTHER
A
DG
TU
SW
SW
AC
BU
AL
ET
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
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
FÉ
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
FÉ
AL
ET
FÉ
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
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
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%
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!
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!
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
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
FÉ
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
FÉ
AL
ET
FÉ
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
DG
AC
BU
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
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
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 (%)
-1,512,898,468 -504,299,489
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
FÉ
-A
FÉ
-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%
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
NOV 0 20,000,000
BUDGET
MTD ACTUAL
DEC 0
BUDGET
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
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
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
7 JUL 940,185,544
400,000,000
8 AUG 689,636,790
300,000,000
9 SEP 765,993,043
12 DEC 620,993,727
0
TOTAL 8,350,340,561 JAN FEB MAR APR M
4 APR 727,382,170
600,000,000
5 MAY 953,055,941
500,000,000 442,820,453
6 JUN 914,616,084
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
800,000,000
900,000,000
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
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
4000000