CRYSTAL LOTUS HOTEL YOGYAKARTA

ROOM DEPARTMENT

DESCRIPTION JANUARY FEBRUARY MARCH

BUDGET 2023 BUDGET 2023 BUDGET 2023
Amount % Amount % Amount %
STATISTIC :
Number of Day 31 28 31
# Of Rooms 139 139 139
Rooms Available 4,309 3,892 4,309
Room Paying 2,307 2,405 1,909
Percentage Occupancy 53.54% 61.79% 44.30%
Number of Guests 2,999 3,127 2,482
Avr Room rate 395,908 401,255 366,681

ROOM SALES
Room Revenue 913,359,561 100.00 965,018,757 100.00 699,993,648 100.00
No Show Revenue - 0.00 - 0.00 - 0.00
Rooms Other Extra Revenue - 0.00 - 0.00 - 0.00
Room Discount & Allowance - 0.00 - 0.00 - 0.00
TOTAL ROOM SALES 913,359,561 100.00 965,018,757 100.00 699,993,648 100.00

PAYROLL & RELATED

Salaries & Wages 57,066,534 6.25 57,304,134 5.94 57,304,134 8.19
Jamsostek 5,991,205 0.66 5,991,205 0.62 5,991,205 0.86
Daily Worker 7,946,883 0.87 7,946,883 0.82 7,946,883 1.14
Bonus/THR 5,500,168 0.60 5,500,168 0.57 5,500,168 0.79
Employee Meals 9,255,000 1.01 9,255,000 0.96 9,255,000 1.32
Tax Paid by Hotel 66,528 0.01 66,528 0.01 66,528 0.01
Medical Allowances 1,987,800 0.22 1,987,800 0.21 1,987,800 0.28
Transportation Allowances - 0.00 - 0.00 - 0.00
TOTAL PAYROLL & RELATED 87,814,118 9.61 88,051,718 9.12 88,051,718 12.58
OTHER EXPENSE
Uniform 1,612,500 0.18 1,612,500 0.17 1,612,500 0.23
Guest Supplies 30,876,888 3.38 32,188,520 3.34 25,550,056 3.65
Cleaning Supplies 3,163,793 0.35 3,291,095 0.34 2,646,791 0.38
Printing & Stationary 1,167,342 0.13 1,216,930 0.13 965,954 0.14
HK Linen 9,133,596 1.00 9,650,188 1.00 6,999,936 1.00
HK China & Glassware - 0.00 - 0.00 - 0.00
HK Silverware - 0.00 - 0.00 - 0.00
HK Transportation - 0.00 - 0.00 - 0.00
HK Laundry Linen 24,530,331 2.69 25,572,365 2.65 20,298,397 2.90
HK Service Contract Sanitatio 1,249,083 0.14 1,249,083 0.13 1,249,083 0.18
HK Ground & Landscaping for 433,150 0.05 467,679 0.05 512,047 0.07
HK Rental Extra Bed 11,952,567 1.31 12,460,305 1.29 -
HK Officer Check 500,000 0.05 500,000 0.05 500,000
Decoration & Florist 738,240 0.08 769,600 0.08 610,880 0.09
FO Guest Transportation 1,307,608 0.14 1,363,154 0.14 1,082,021 0.15
Traveling Expenses - 0.00 - 0.00 - 0.00
Subscription & Newspaper - 0.00 - 0.00 - 0.00
FO Admin Fee - 0.00 - 0.00 - 0.00
FO TA Admin (com) 11,628,168 1.27 11,088,464 1.15 8,291,816 1.18
Telephone & Facsimile 398,028 0.04 416,871 0.04 347,796 0.05
Postage & Courier 69,304 0.01 74,829 0.01 81,928 0.01
Licenses & Tax - 0.00 - 0.00 - 0.00
Laundry Uniform - 0.00 - 0.00 - 0.00
Entertaining 750,000 0.08 750,000 0.08 750,000 0.11
FO Music & Entertainment - 0.00 - 0.00 - 0.00
FO Welcome Drink 1,349,595 0.15 1,406,925 0.15 1,116,765 0.16
FO Fruit Basket 1,767,000 0.19 1,596,000 0.17 1,767,000 0.25
FO Contract Services 13,000,000 1.42 13,000,000 1.35 13,000,000 1.86
Printed Form 1,430,000 0.16 1,430,000 0.15 1,430,000 0.20
FO TV Channel 9,000,000 0.99 9,000,000 0.93 9,000,000 1.29
FO Officer Check 500,000 0.05 500,000 0.05 500,000 0.07
FO Beverage to Room - 0.00 - 0.00 - 0.00
FO Food to Room - 0.00 - 0.00 - 0.00
Loss & Damage 173,260 0.02 187,072 0.02 204,819 0.03
Miscellaneous 5,100,000 0.56 5,100,000 0.53 5,100,000 0.73
TOTAL OTHER EXPENSES 131,830,452 14.43 134,891,579 13.98 103,617,788 14.80
TOTAL EXPENSES 219,644,570 24.05 222,943,297 23.10 191,669,506 27.38

TOTAL EXPENSES 219,644,570 24.05 222,943,297 23.10 191,669,506 27.38

DEPARTMENT PROFIT (LOSS) 693,714,991 75.95 742,075,460 76.90 508,324,142 72.62

 APRIL MAY JUNE JULY
BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023
Amount % Amount % Amount % Amount %

30 31 30 31
139 139 139 139
4,170 4,309 4,170 4,309
2,123 2,712 3,289 2,985
50.91% 62.94% 78.87% 69.27%
2,760 3,526 4,276 3,881
430,342 404,019 412,506 405,336

913,616,579 100.00 1,095,698,221 100.00 1,356,731,679 100.00 1,209,928,893 100.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
913,616,579 100.00 1,095,698,221 100.00 1,356,731,679 100.00 1,209,928,893 100.00

57,304,134 6.27 57,304,134 5.23 57,304,134 4.22 57,304,134 4.74

5,991,205 0.66 5,991,205 0.55 5,991,205 0.44 5,991,205 0.50
7,946,883 0.87 7,946,883 0.73 7,946,883 0.59 7,946,883 0.66
5,500,168 0.60 5,500,168 0.50 5,500,168 0.41 5,500,168 0.45
9,255,000 1.01 9,255,000 0.84 9,255,000 0.68 9,255,000 0.76
66,528 0.01 66,528 0.01 66,528 0.00 66,528 0.01
1,987,800 0.22 1,987,800 0.18 1,987,800 0.15 1,987,800 0.16
- 0.00 - 0.00 - 0.00 - 0.00
88,051,718 9.64 88,051,718 8.04 88,051,718 6.49 88,051,718 7.28

1,612,500 0.18 1,612,500 0.15 1,612,500 0.12 1,612,500 0.13

28,414,232 3.11 36,297,408 3.31 44,019,976 3.24 39,951,240 3.30
2,924,777 0.32 3,689,888 0.34 4,439,411 0.33 4,044,515 0.33
1,074,238 0.12 1,372,272 0.13 1,664,234 0.12 1,510,410 0.12
9,136,166 1.00 10,956,982 1.00 13,567,317 1.00 12,099,289 1.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
22,573,859 2.47 28,836,696 2.63 34,971,937 2.58 31,739,505 2.62
1,249,083 0.14 1,249,083 0.11 1,249,083 0.09 1,249,083 0.10
366,366 0.04 552,994 0.05 559,370 0.04 663,183 0.05
14,050,872 17,040,309 15,465,285
500,000 500,000 500,000 500,000
679,360 0.07 867,840 0.08 1,052,480 0.08 955,200 0.08
1,203,316 0.13 1,537,162 0.14 1,864,205 0.14 1,691,898 0.14
- 0.00 - 0.00 - 0.00 - 0.00
- 0.00 - 0.00 - 0.00 - 0.00
- 0.00 - 0.00 - 0.00 - 0.00
 12,572,650 1.38 13,431,270 1.23 15,798,608 1.16 16,460,972 1.36
362,414 0.04 473,159 0.04 566,068 0.04 527,332 0.04
58,619 0.01 83,653 0.01 96,957 0.01 106,109 0.01
- 0.00 - 0.00 - 0.00 - 0.00
- 0.00 - 0.00 - 0.00 - 0.00
750,000 0.08 750,000 0.07 750,000 0.06 750,000 0.06
- 0.00 - 0.00 - 0.00 - 0.00
1,241,955 0.14 1,586,520 0.14 1,924,065 0.14 1,746,225 0.14
1,710,000 0.19 1,767,000 0.16 1,710,000 0.13 1,767,000 0.15
13,000,000 1.42 13,000,000 1.19 13,000,000 0.96 13,000,000 1.07
1,430,000 0.16 1,430,000 0.13 1,430,000 0.11 1,430,000 0.12
0.00 0.00 9,000,000 0.82 9,000,000 0.66 9,000,000 0.74
500,000 0.05 500,000 0.05 500,000 0.04 500,000 0.04
- 0.00 - 0.00 - 0.00 - 0.00
- 0.00 - 0.00 - 0.00 - 0.00
146,546 0.02 261,415 0.02 242,394 0.02 265,273 0.02
5,100,000 0.56 5,100,000 0.47 5,100,000 0.38 5,100,000 0.42
106,606,081 11.67 148,906,714 13.59 172,658,914 12.73 162,135,019 13.40
194,657,799 21.31 236,958,431 21.63 260,710,632 19.22 250,186,736 20.68

194,657,799 21.31 236,958,431 21.63 260,710,632 19.22 250,186,736 20.68

718,958,780 78.69 858,739,790 78.37 1,096,021,047 80.78 959,742,157 79.32

 AUGUST SEPTEMBER OCTOBER NOVEMBER
BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023
Amount % Amount % Amount % Amount %

31 30 31 30
139 139 139 139
4,309 4,170 4,309 4,170
2,588 2,712 2,607 3,437
60.06% 65.04% 60.51% 82.42%
3,364 3,526 3,389 4,468
416,947 411,950 402,492 407,642

1,079,059,318 100.00 1,117,207,234 100.00 1,049,368,237 100.00 1,401,064,954 100.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
1,079,059,318 100.00 1,117,207,234 100.00 1,049,368,237 100.00 1,401,064,954 100.00

57,482,057 5.33 57,662,474 5.16 57,884,234 5.52 57,884,234 4.13

5,991,205 0.56 5,991,205 0.54 5,991,205 0.57 5,991,205 0.43
7,946,883 0.74 7,946,883 0.71 7,946,883 0.76 7,946,883 0.57
5,500,168 0.51 5,500,168 0.49 5,500,168 0.52 5,500,168 0.39
9,255,000 0.86 9,255,000 0.83 9,255,000 0.88 9,255,000 0.66
66,528 0.01 66,528 0.01 66,528 0.01 66,528 0.00
1,987,800 0.18 1,987,800 0.18 1,987,800 0.19 1,987,800 0.14
- 0.00 - 0.00 - 0.00 - 0.00
88,229,641 8.18 88,410,058 7.91 88,631,818 8.45 88,631,818 6.33

1,612,500 0.15 1,612,500 0.14 1,612,500 0.15 1,612,500 0.12

34,637,792 3.21 36,297,408 3.25 34,894,497 3.33 46,000,808 3.28
3,528,812 0.33 3,689,888 0.33 3,553,727 0.34 4,631,663 0.33
1,309,528 0.12 1,372,272 0.12 1,319,233 0.13 1,739,122 0.12
10,790,593 1.00 11,172,072 1.00 10,493,682 1.00 14,010,650 1.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
27,518,204 2.55 28,836,696 2.58 27,722,145 2.64 36,545,621 2.61
1,249,083 0.12 1,249,083 0.11 1,249,083 0.12 1,249,083 0.09
688,136 0.06 642,947 0.06 632,864 0.06 777,801 0.06
13,408,428 14,050,872 13,507,800 17,807,097
500,000 500,000 500,000 500,000
828,160 0.08 867,840 0.08 834,298 0.08 1,099,840 0.08
1,466,878 0.14 1,537,162 0.14 1,477,750 0.14 1,948,092 0.14
- 0.00 - 0.00 - 0.00 - 0.00
- 0.00 - 0.00 - 0.00 - 0.00
- 0.00 - 0.00 - 0.00 - 0.00
 9,628,810 0.89 11,346,050 1.02 15,025,850 1.43 14,817,328 1.06
452,991 0.04 475,232 0.04 470,473 0.04 601,706 0.04
110,102 0.01 92,137 0.01 101,258 0.01 105,302 0.01
- 0.00 - 0.00 - 0.00 - 0.00
- 0.00 - 0.00 - 0.00 - 0.00
750,000 0.07 750,000 0.07 750,000 0.07 750,000 0.05
- 0.00 - 0.00 - 0.00 - 0.00
1,513,980 0.14 1,586,520 0.14 1,525,200 0.15 2,010,645 0.14
1,767,000 0.16 1,710,000 0.15 1,767,000 0.17 1,710,000 0.12
13,000,000 1.20 13,000,000 1.16 13,000,000 1.24 13,000,000 0.93
1,430,000 0.13 1,430,000 0.13 1,430,000 0.14 1,430,000 0.10
9,000,000 0.83 9,000,000 0.81 9,000,000 0.86 9,000,000 0.64
500,000 0.05 500,000 0.04 500,000 500,000
- 0.00 - 0.00 - 0.00 - 0.00
- 0.00 - 0.00 - 0.00 - 0.00
275,255 0.03 290,724 0.03 299,172 0.03 311,120 0.02
5,100,000 0.47 5,100,000 0.46 5,100,000 0.49 5,100,000 0.36
141,066,252 13.07 147,109,402 13.17 146,766,532 13.99 177,258,378 12.65
229,295,893 21.25 235,519,460 21.08 235,398,350 22.43 265,890,196 18.98

229,295,893 21.25 235,519,460 21.08 235,398,350 22.43 265,890,196 18.98

849,763,425 78.75 881,687,774 78.92 813,969,887 77.57 1,135,174,758 81.02

 DECEMBER TOTAL
BUDGET 2023 BUDGET 2023
Amount % Amount %

31 365
139 177
4,309 64,605
3,942 33,016
91.48% 51.10%
5,125 42,921
448,207 410,946

1,766,830,840 100.00 13,567,877,921 100.00 ###

- 0.00 - -
- 0.00 - -
- 0.00 - -
1,766,830,840 100.00 13,567,877,921 100.00

58,055,128 3.29 689,859,466 5.08

5,991,205 0.34 71,894,458 0.53
7,946,883 0.45 95,362,601 0.70
5,500,168 0.31 66,002,012 0.49
9,255,000 0.52 111,060,000 0.82
66,528 0.00 798,333 0.01
1,987,800 0.11 23,853,600 0.18
- 0.00 - -
88,802,712 5.03 1,058,830,471 7.80

1,612,500 0.09 19,350,000 0.14

52,759,728 2.99 441,888,553 3.26
5,287,658 0.30 44,892,018 0.33
1,994,652 0.11 16,706,187 0.12
17,668,308 1.00 135,678,779 1.00
- 0.00 - -
- 0.00 - -
- 0.00 - -
41,915,286 2.37 351,061,042 2.59
1,249,083 0.07 14,988,995 0.11
816,144 0.05 7,112,680 0.05
20,423,502 1.16 150,167,037 1.11
500,000 0.03 6,000,000 0.04
1,261,440 0.07 10,565,178 0.08
2,234,326 0.13 18,713,571 0.14
- 0.00 - -
- 0.00 - -
- 0.00 - -
 18,656,586 1.06 158,746,572 1.17
712,556 0.04 5,804,626 0.04
136,801 0.01 1,116,999 0.01
- 0.00 - -
- 0.00 - -
750,000 0.04 9,000,000 0.07
- 0.00 - -
2,306,070 0.13 19,314,465 0.14
1,767,000 0.10 20,805,000 0.15
13,000,000 0.74 156,000,000 1.15
1,430,000 0.08 17,160,000 0.13
9,000,000 0.51 99,000,000 0.73
500,000 6,000,000
- 0.00 - -
- 0.00 - -
388,640 0.02 3,045,689 0.02
5,100,000 0.29 61,200,000 0.45
201,470,279 11.40 1,774,317,391 13.08
290,272,991 16.43 2,833,147,862 20.88

290,272,991 16.43 2,833,147,862 20.88

1,476,557,849 83.57 10,734,730,059 79.12

CRYSTAL LOTUS HOTEL YOGYAKARTA
FRONT OFFICE DEPARTMENT

DESCRIPTION JANUARY FEBRUARY MARCH

BUDGET 2023 BUDGET 2023 BUDGET 2023
Amount % Amount % Amount
PAYROLL & RELATED
FO Salaries & Wages 37,462,331 4.10 37,462,331 3.88 37,462,331
FO Jamsostek 3,924,922 0.43 3,924,922 0.41 3,924,922
FO DAILY WORKER 0.00 0.00
FO Bonus / THR 3,165,964 0.35 3,165,964 0.33 3,165,964
FO Employee Meals 4,875,000 0.53 4,875,000 0.51 4,875,000
FO Tax Paid by Hotel 66,528 0.53 66,528 0.01 66,528
FO Medical Allowances 1,139,400 0.12 1,139,400 0.12 1,139,400
FO Transportation Allowances 0.00 0.00
TOTAL PAYROLL & RELATED 50,634,145 5.54 50,634,145 5.25 50,634,145
OTHER EXPENSE
FO Uniform 1,612,500 0.18 1,612,500 0.17 1,612,500
FO Guest Supplies 1,176,570 0.13 1,226,550 0.13 973,590
FO Cleaning Supplies 167,000 0.02 167,000 0.02 167,000
FO Printing & Stationary 994,317 0.11 1,036,555 0.11 822,779
FO Decoration & Florist 0.00 0.00
FO Guest Transportation 1,307,608 0.14 1,363,154 0.14 1,082,021
FO Traveling Expenses 0.00 0.00
FO Subscription & Newspaper - 0.00 - 0.00 -
FO Admin Fee 0.00 0.00
FO TA Admin (com) 11,628,168 1.27 11,088,464 1.15 8,291,816
FO Telephone & Facsimile 346,050 0.04 360,750 0.04 286,350
FO Postage & Courier - 0.00 - 0.00 -
FO Licenses & Tax 0.00 0.00
FO Laundry Uniform 0.00 0.00
FO Entertaining 300,000 0.03 300,000 0.03 300,000
FO Music & Entertainment 0.00 0.00
FO Welcome Drink 1,349,595 0.15 1,406,925 0.15 1,116,765
FO Fruit Basket 1,767,000 0.19 1,596,000 0.17 1,767,000
FO Contract Services 13,000,000 1.42 13,000,000 1.35 13,000,000
FO Printed Form 1,430,000 0.16 1,430,000 0.15 1,430,000
FO TV Channel 9,000,000 0.99 9,000,000 0.93 9,000,000
FO Officer Check 500,000 500,000 500,000
FO Beverage to Room 0.00 0.00
FO Food to Room 0.00 0.00
FO Loss & Damage 0.00 0.00
FO Miscellaneous 350,000 0.04 350,000 0.04 350,000
TOTAL OTHER EXPENSE 44,928,808 4.92 44,437,898 4.60 40,699,821
TOTAL EXPENSES 95,562,952 10.46 95,072,043 9.85 91,333,966
 MARCH APRIL MAY JUNE JULY AUGUST
BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023
% Amount % Amount % Amount % Amount % Amount %

5.35 37,462,331 4.10 37,462,331 3.42 37,462,331 2.76 37,462,331 3.10 37,640,254 3.49
0.56 3,924,922 0.43 3,924,922 0.36 3,924,922 0.29 3,924,922 0.32 3,924,922 0.36
0.00 0.00 0.00 0.00 0.00 0.00
0.45 3,165,964 0.35 3,165,964 0.29 3,165,964 0.23 3,165,964 0.26 3,165,964 0.29
0.70 4,875,000 0.53 4,875,000 0.44 4,875,000 0.36 4,875,000 0.40 4,875,000 0.45
0.01 66,528 0.01 66,528 0.01 66,528 0.00 66,528 0.01 66,528 0.01
0.16 1,139,400 0.12 1,139,400 0.10 1,139,400 0.08 1,139,400 0.09 1,139,400 0.11
0.00 0.00 0.00 0.00 0.00 0.00
7.23 50,634,145 5.54 50,634,145 4.62 50,634,145 3.73 50,634,145 4.18 50,812,068 4.71

0.23 1,612,500 0.18 1,612,500 0.15 1,612,500 0.12 1,612,500 0.13 1,612,500 0.15
0.14 1,082,730 0.12 1,383,120 0.13 1,677,390 0.12 1,522,350 0.13 1,319,880 0.12
0.02 167,000 0.02 167,000 0.02 167,000 0.01 167,000 0.01 167,000 0.02
0.12 915,013 0.10 1,168,872 0.11 1,417,559 0.10 1,286,535 0.11 1,115,428 0.10
0.00 0.00 0.00 0.00 0.00 0.00
0.15 1,203,316 0.13 1,537,162 0.14 1,864,205 0.14 1,691,898 0.14 1,466,878 0.14
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.00 0.00 0.00 0.00
1.18 12,572,650 1.38 13,431,270 1.23 15,798,608 1.16 16,460,972 1.36 9,628,810 0.89
0.04 318,450 0.03 406,800 0.04 493,350 0.04 447,750 0.04 388,200 0.04
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.00 0.00 0.00 0.00
0.04 300,000 0.03 300,000 0.03 300,000 0.02 300,000 0.02 300,000 0.03
0.00 0.00 0.00 0.00 0.00 0.00
0.16 1,241,955 0.14 1,586,520 0.14 1,924,065 0.14 1,746,225 0.14 1,513,980 0.14
0.25 1,710,000 0.19 1,767,000 0.16 1,710,000 0.13 1,767,000 0.15 1,767,000 0.16
1.86 13,000,000 1.42 13,000,000 1.19 13,000,000 0.96 13,000,000 1.07 13,000,000 1.20
0.20 1,430,000 0.16 1,430,000 0.13 1,430,000 0.11 1,430,000 0.12 1,430,000 0.13
1.29 9,000,000 0.99 9,000,000 0.82 9,000,000 0.66 9,000,000 0.74 9,000,000 0.83
0.07 500,000 0.05 500,000 500,000 500,000 500,000
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.00 0.00 0.00 0.00
0.05 350,000 0.04 350,000 0.03 350,000 0.03 350,000 0.03 350,000 0.03
5.81 45,403,614 4.97 47,640,244 4.35 51,244,677 3.78 51,282,230 4.24 43,559,676 4.04
13.05 96,037,759 10.51 98,274,388 8.97 101,878,822 7.51 101,916,375 8.42 94,371,744 8.75
SEPTEMBER OCTOBER NOVEMBER DECEMBER TOTAL
BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023
Amount % Amount % Amount % Amount % Amount %

37,820,672 3.39 37,820,672 3.60 37,820,672 2.70 37,991,566 2.15 451,330,155 3.33
3,924,922 0.35 3,924,922 0.37 3,924,922 0.28 3,924,922 0.22 47,099,063 0.35
0.00 0.00 0.00 - 0.00 - 0.00
3,165,964 0.28 3,165,964 0.30 3,165,964 0.23 3,165,964 0.18 37,991,566 0.28
4,875,000 0.44 4,875,000 0.46 4,875,000 0.35 4,875,000 0.28 58,500,000 0.43
66,528 0.01 66,528 0.01 66,528 0.00 66,528 0.00 798,333 0.01
1,139,400 0.10 1,139,400 0.11 1,139,400 0.08 1,139,400 0.06 13,672,800 0.10
0.00 0.00 0.00 0.00 - 0.00
50,992,485 4.56 50,992,485 4.86 50,992,485 3.64 51,163,379 2.90 609,391,917 4.49

1,612,500 0.14 1,612,500 0.15 1,612,500 0.12 1,612,500 0.09 19,350,000 0.14
1,383,120 0.12 1,329,662 0.13 1,752,870 0.13 2,010,420 0.11 16,838,252 0.12
167,000 0.01 167,000 0.02 167,000 0.01 167,000 0.01 2,004,000 0.01
1,168,872 0.10 1,123,695 0.11 1,481,347 0.11 1,699,002 0.10 14,229,974 0.10
0.00 0.00 0.00 0.00 - 0.00
1,537,162 0.14 1,477,750 0.14 1,948,092 0.14 2,234,326 0.13 18,713,571 0.14
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.00
11,346,050 1.02 15,025,850 1.43 14,817,328 1.06 18,656,586 1.06 158,746,572 1.17
406,800 0.04 391,077 0.04 515,550 0.04 591,300 0.03 4,952,427 0.04
- 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.00
300,000 0.03 300,000 0.03 300,000 0.02 300,000 0.02 3,600,000 0.03
0.00 0.00 0.00 0.00 - 0.00
1,586,520 0.14 1,525,200 0.15 2,010,645 0.14 2,306,070 0.13 19,314,465 0.14
1,710,000 0.15 1,767,000 0.17 1,710,000 0.12 1,767,000 0.10 20,805,000 0.15
13,000,000 1.16 13,000,000 1.24 13,000,000 0.93 13,000,000 0.74 156,000,000 1.15
1,430,000 0.13 1,430,000 0.14 1,430,000 0.10 1,430,000 0.08 17,160,000 0.13
9,000,000 0.81 9,000,000 0.86 9,000,000 0.64 9,000,000 0.51 108,000,000 0.80
500,000 500,000 500,000 500,000 6,000,000 0.04
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.00
350,000 0.03 350,000 0.03 350,000 0.02 350,000 0.02 4,200,000 0.03
45,498,024 4.07 48,999,733 4.67 50,595,332 3.61 55,624,204 3.15 569,914,261 4.20
96,490,509 8.64 99,992,219 9.53 101,587,817 7.25 106,787,583 6.04 1,179,306,177 8.69
451,330,155 -
47,099,063 -
-
37,991,566 -
58,500,000 -
798,333 -
13,672,800 -
-
609,391,917 -
CRYSTAL LOTUS HOTEL YOGYAKARTA
HOUSEKEEPING DEPARTMENT

DESCRIPTION JANUARY FEBRUARY MARCH APRIL

REMARKS
BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023
Amount % Amount % Amount % Amount %
PAYROLL & RELATED
HK Salaries & Wages 19,604,203 2.15 19,841,803 2.06 19,841,803 2.83 19,841,803 2.17
HK Jamsostek 2,066,283 0.23 2,066,283 0.21 2,066,283 0.30 2,066,283 0.23
HK Daily worker 7,946,883 0.87 7,946,883 0.82 7,946,883 1.14 7,946,883 0.87
HK Bonus / THR 2,334,204 0.26 2,334,204 0.24 2,334,204 0.33 2,334,204 0.26
HK Employee Meals 4,380,000 0.48 4,380,000 0.45 4,380,000 0.63 4,380,000 0.48
HK Tax Paid by Hotel - - - - - - -
HK Medical Allowances 848,400 0.09 848,400 0.09 848,400 0.12 848,400 0.09
HK Transportation Allowances - - - -
TOTAL PAYROLL & RELATED 37,179,973 4.07 37,417,573 3.88 37,417,573 5.35 37,417,573 4.10
OTHER EXPENSE
HK Linen 9,133,596 1.00 9,650,188 1.00 6,999,936 1.00 9,136,166 1.00
HK China & Glassware - - - - -
HK Silverware - - - - -
HK Uniform - - - -
HK Guest Supplies 12,874 29,700,318 3.25 30,961,970 3.21 24,576,466 3.51 27,331,502 2.99
HK Cleaning Supplies 1,299 2,996,793 0.33 3,124,095 0.32 2,479,791 0.35 2,757,777 0.30
HK Printing & Stationary 75 173,025 0.02 180,375 0.02 143,175 0.02 159,225 0.02
HK Decoration & Florist 320 738,240 0.08 769,600 0.08 610,880 0.09 679,360 0.07
HK Transportation - - - - -
HK Traveling Expenses - - - - -
HK Subscription & Newspaper - - - - -
HK Telephone & Facsimile 51,978 0.01 56,121 0.01 61,446 0.01 43,964 0.00
HK Postage & Courier 69,304 0.01 74,829 0.01 81,928 0.01 58,619 0.01
HK Licenses & Tax - - - - -
HK Laundry Uniform - - - - -
HK Entertaining 450,000 0.05 450,000 0.05 450,000 0.06 450,000 0.05
HK Printed Form - - - - -
HK Laundry Linen 10,633 24,530,331 2.69 25,572,365 2.65 20,298,397 2.90 22,573,859 2.47
HK Service Contract Sanitation Eco Care 1,249,083 0.14 1,249,083 0.13 1,249,083 0.18 1,249,083 0.14
HK Ground & Landscaping for Ro 433,150 0.05 467,679 0.05 512,047 0.07 366,366 0.04
HK Rental Extra Bed 5,181 11,952,567 12,460,305 - - -
HK Officer Check 500,000 500,000 500,000 0.07 500,000 0.05
HK Loss & Damage 173,260 0.02 187,072 0.02 204,819 0.03 146,546 0.02
HK Miscellaneous 4,750,000 0.52 4,750,000 0.49 4,750,000 0.68 4,750,000 0.52
TOTAL OTHER EXPENSES 86,901,645 9.51 90,453,681 9.37 62,917,967 8.99 70,202,467 7.68
TOTAL EXPENSES 124,081,618 13.59 127,871,254 13.25 100,335,540 14.33 107,620,040 11.78
 MAY JUNE JULY AUGUST SEPTEMBER OCTOBER
BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023 BUDGET 2023
Amount % Amount % Amount % Amount % Amount % Amount %

19,841,803 1.81 19,841,803 1.46 19,841,803 1.64 19,841,803 1.84 19,841,803 1.78 20,063,563 1.91
2,066,283 0.19 2,066,283 0.15 2,066,283 0.17 2,066,283 0.19 2,066,283 0.18 2,066,283 0.20
7,946,883 0.73 7,946,883 0.59 7,946,883 0.66 7,946,883 0.74 7,946,883 0.71 7,946,883 0.76
2,334,204 0.21 2,334,204 0.17 2,334,204 0.19 2,334,204 0.22 2,334,204 0.21 2,334,204 0.22
4,380,000 0.40 4,380,000 0.32 4,380,000 0.36 4,380,000 0.41 4,380,000 0.39 4,380,000 0.42
- - - - - - - - - - - -
848,400 0.08 848,400 0.06 848,400 0.07 848,400 0.08 848,400 0.08 848,400 0.08
- - - - - -
37,417,573 3.41 37,417,573 2.76 37,417,573 3.09 37,417,573 3.47 37,417,573 3.35 37,639,333 3.59

10,956,982 1.00 13,567,317 1.00 12,099,289 1.00 10,790,593 1.00 11,172,072 1.00 10,493,682 1.00
- - - - - -
- - - - - -
- - - - - -
34,914,288 3.19 42,342,586 3.12 38,428,890 3.18 33,317,912 3.09 34,914,288 3.13 33,564,835 3.20
3,522,888 0.32 4,272,411 0.31 3,877,515 0.32 3,361,812 0.31 3,522,888 0.32 3,386,727 0.32
203,400 0.02 246,675 0.02 223,875 0.02 194,100 0.02 203,400 0.02 195,539 0.02
867,840 0.08 1,052,480 0.08 955,200 0.08 828,160 0.08 867,840 0.08 834,298 0.08
- - - - - -
- - - - - -
- - - - - -
66,359 0.01 72,718 0.01 79,582 0.01 64,791 0.01 68,432 0.01 79,396 0.01
83,653 0.01 96,957 0.01 106,109 0.01 110,102 0.01 92,137 0.01 101,258 0.01
- - - - - -
 - - - - - -
450,000 0.04 450,000 0.03 450,000 0.04 450,000 0.04 450,000 0.04 450,000 0.04
- - - - - -
28,836,696 2.63 34,971,937 2.58 31,739,505 2.62 27,518,204 2.55 28,836,696 2.58 27,722,145 2.64
1,249,083 0.11 1,249,083 0.09 1,249,083 0.10 1,249,083 0.12 1,249,083 0.11 1,249,083 0.12
552,994 0.05 559,370 0.04 663,183 0.05 688,136 0.06 642,947 0.06 632,864 0.06
14,050,872 1.28 17,040,309 1.26 15,465,285 13,408,428 14,050,872 13,507,800
500,000 0.05 500,000 0.04 500,000 500,000 500,000 500,000
261,415 0.02 242,394 0.02 265,273 0.02 275,255 0.03 290,724 0.03 299,172 0.03
4,750,000 0.43 4,750,000 0.35 4,750,000 0.39 4,750,000 0.44 4,750,000 0.43 4,750,000 0.45
101,266,470 9.24 121,414,237 8.95 110,852,789 9.16 97,506,576 9.04 101,611,379 9.10 97,766,799 9.32
138,684,043 12.66 158,831,810 11.71 148,270,361 12.25 134,924,148 12.50 139,028,952 12.44 135,406,131 12.90
NOVEMBER DECEMBER TOTAL PTEB EXCEL
BUDGET 2023 BUDGET 2023 BUDGET 2023
Amount % Amount % Amount %

20,063,563 1.43 20,063,563 1.14 238,529,311 1.76 238,529,311 -

2,066,283 0.15 2,066,283 0.12 24,795,395 0.18 24,795,395 -
7,946,883 0.57 7,946,883 0.45 95,362,601 0.70 95,362,601 -
2,334,204 0.17 2,334,204 0.13 28,010,446 0.21 28,010,446 -
4,380,000 0.31 4,380,000 0.25 52,560,000 0.39 52,560,000 -
- - - - - - 0 -
848,400 0.06 848,400 0.05 10,180,800 0.08 10,180,800 -
- - - - -
37,639,333 2.69 37,639,333 2.13 449,438,554 3.31 449,438,554 -

14,010,650 1.00 17,668,308 1.00 135,678,779 1.00

- - - -
- - - -
- - - -
44,247,938 3.16 50,749,308 2.87 425,050,301 3.13
4,464,663 0.32 5,120,658 0.29 42,888,018 0.32
257,775 0.02 295,650 0.02 2,476,214 0.02
1,099,840 0.08 1,261,440 0.07 10,565,178 0.08
- - - -
- - - -
- - - -
86,156 0.01 121,256 0.01 852,199 0.01
105,302 0.01 136,801 0.01 1,116,999 0.01
- - - -
 - - - -
450,000 0.03 450,000 0.03 5,400,000 0.04
- - - -
36,545,621 2.61 41,915,286 2.37 351,061,042 2.59
1,249,083 0.09 1,249,083 0.07 14,988,995 0.11
777,801 0.06 816,144 0.05 7,112,680 0.05
17,807,097 20,423,502 150,167,037 1.11
500,000 500,000 6,000,000 0.04
311,120 0.02 388,640 0.02 3,045,689 0.02
4,750,000 0.34 4,750,000 0.27 57,000,000 0.42
126,663,046 9.04 145,846,076 8.25 1,213,403,130 8.94
164,302,379 11.73 183,485,409 10.39 1,662,841,685 12.26

140,489,475 11.58%