PERFORMANCE MTD
Nov-24
DESCRIPTION BUDGET % ACTUAL %
STATISTIC Nov-24 Nov-24
Average Room Rate 328,399 327,275
Room Available 1,950 1,950
Occupied Room 1,583 1,316
% Occupancy 81.18% 67.49%
Paying Room 1,548 1,285
% Occupancy of Paying Room 79.38% 65.90%
House Use 30 30
Compliment Room 5 1
Out Of Order Room - 2
No of Total Guest 2,940 2,596
REVENUE
Room 508,362,237 55.10 420,548,861 68.84
Food & Beverage 385,285,064 41.76 183,571,479 30.77
Other Operating Department 28,949,059 3.14 4,110,879 0.39
TOTAL REVENUE 922,596,359 100.00 608,231,219 100.00
FRONT OFFICE
Payroll & Related 22,547,725 3.25 26,091,918 2.47
Other Expenses 16,456,694 2.21 13,930,259 1.87
TOTAL FRONT OFFICE 39,004,419 5.46 40,022,177 4.35
HOUSEKEEPING
Payroll & Related 29,100,627 4.19 20,611,855 2.67
Other Expenses 38,261,470 3.81 27,305,475 10.10
TOTAL HOUSEKEEPING 67,362,097 8.00 47,917,330 12.77
FOOD & BEVERAGE
Cost food & Beverage 137,720,146 38.16 66,201,690 36.25
Payroll & Related 55,730,750 8.03 40,656,096 6.86
Other Expenses 32,749,632 4.36 43,608,217 5.15
TOTAL FOOD & BEVERAGE 226,200,528 28.32 150,466,003 23.17
OTHER INCOME DEPARTEMENT
Cost of Minor Departement 205,371 2.35 240,000 35.76
TOTAL OTHER INCOME DEPARTEMENT 205,371 0.07 240,000 0.14
ADMIN & GENERAL
Payroll & Related 56,476,785 8.13 51,568,947 6.51
Other Expenses 11,245,481 1.61 13,248,172 1.46
TOTAL ADMIN & GENERAL 67,722,266 9.75 64,817,119 7.97
HUMAN RESOURCE
Payroll & Related 9,867,470 1.42 7,087,596 0.98
Other Expenses 16,277,216 2.19 14,472,310 1.88
TOTAL HUMAN RESOURCE 26,144,686 3.61 21,559,906 2.86
SALES MARKETING
Payroll & Related 22,403,696 3.23 9,758,224 2.19
Other Expenses 34,032,633 3.24 9,261,556 2.50
TOTAL SALES MARKETING 56,436,329 6.46 19,019,780 4.69
POMEC
Payroll & Related 13,828,703 1.99 15,718,947 1.45
Other Expenses 21,726,090 2.74 7,093,574 2.46
Energy Cost 67,051,359 8.81 49,854,822 7.31
TOTAL POMEC 102,606,152 13.54 72,667,343 11.22
TOTAL ALL EXPENSES 585,681,848 75.21 416,709,658 67.16
GROSS OPERATING PROFIT (LOSS) 336,914,511 24.79 191,521,562 32.84
OTHER DEDUCTION
Replacement For FFnE - 0.00 - 0.00
Incentive Fee - 0.00 - 0.00
Depresiasi & Amortisasi 190,961,600 27.50 192,074,400 24.56
Other Insurance - 0.00 - 0.00
Other Deduction Expense - 0.00 - 0.00
Owner Expense - 0.00 24,781,682 1.08
Owner Legal Expense - 0.00 - 0.00
Owner Salary Expense - 0.00 - 0.00
TOTAL OTHER DEDUCTION 190,961,600 27.50 216,856,082 25.64
NETT OWNER SHARE PROFIT (LOSS) 145,952,911 -2.71 (25,334,520) 7.21
VARIANCE LAST MONTH % VARIANCE LAST YEAR % VARIANCE
Act Nov to Act NOv 24
Act to Bud Oct-24 Nov-23
Okt 24 to Nov 23
-0.34% 289,355 291,393 -10.96%
0.00% 2,015 3.33% 1,950 0.00%
-16.87% 1,922 46.05% 1,529 16.19%
-16.87% 95.38% 41.34% 78.41% 16.19%
-16.99% 1,889 47.00% 1,501 16.81%
-16.99% 93.75% 42.26% 76.97% 16.81%
0.00% 31 3.33% 22 -26.67%
-80.00% 2 6
- -
-11.70% 3,802 46.46% 3,018 16.26%
-17.27% 546,591,431 66.25 29.97% 437,380,588 58.87 4.00%
-52.35% 283,232,621 33.47 54.29% 321,475,738 38.27 75.12%
-85.80% 2,717,695 0.28 -33.89% 19,986,994 2.86 386.20%
-34.07% 832,541,747 100.00 36.88% 778,843,320 100.00 28.05%
15.72% 29,178,381 2.61 11.83% 20,351,015 3.28 -22.00%
-15.35% 13,227,525 1.87 -5.04% 16,104,890 2.44 15.61%
2.61% 42,405,906 4.48 5.96% 36,455,905 5.72 -8.91%
-29.17% 22,175,347 3.75 7.59% 26,776,623 4.03 29.91%
-28.63% 28,731,337 3.39 5.22% 39,051,819 4.36 43.02%
-28.87% 50,906,684 7.14 6.24% 65,828,442 8.39 37.38%
-51.93% 89,277,456 45.05 34.86% 123,341,312 39.60 86.31%
-27.05% 47,299,062 6.76 16.34% 44,679,856 7.52 9.90%
33.16% 52,602,633 1.96 20.63% 32,727,244 4.46 -24.95%
-33.48% 189,179,151 23.80 25.73% 200,748,412 27.13 33.42%
16.86% 496,000 11.41 106.67% 815,000 1.64 239.58%
16.86% 496,000 0.03 106.67% 815,000 0.05 239.58%
-8.69% 55,417,387 5.36 7.46% 49,646,858 8.02 -3.73%
17.81% 15,908,258 1.43 20.08% 11,724,967 1.64 -11.50%
-4.29% 71,325,646 6.79 10.04% 61,371,825 9.66 -5.32%
-28.17% 7,466,262 0.30 5.34% 9,423,643 1.63 32.96%
-11.09% 14,928,374 1.92 3.15% 14,907,603 2.69 3.01%
-17.54% 22,394,635 2.21 3.87% 24,331,245 4.31 12.85%
-56.44% 17,016,181 2.39 74.38% 18,474,297 2.59 89.32%
-72.79% 24,894,544 2.38 168.79% 63,356,495 3.36 584.08%
-66.30% 41,910,725 4.77 120.35% 81,830,793 5.95 330.24%
13.67% 14,598,839 1.76 -7.13% 12,675,354 1.64 -19.36%
-67.35% 5,804,662 3.68 -18.17% 22,972,613 3.64 223.85%
-25.65% 62,190,110 7.42 24.74% 63,971,611 9.36 28.32%
-29.18% 82,593,612 12.86 13.66% 99,619,578 14.64 37.09%
-28.85% 501,212,359 62.10 20.28% 571,001,200 75.86 37.03%
-43.15% 331,329,388 37.90 73.00% 207,842,120 24.14 8.52%
- 0.00 - 0.00
4,784,067 0.00 - 0.00
0.58% 192,074,400 26.50 0.00% 190,961,600 30.90 -0.58%
- 0.00 - 0.00
- -2.17 - 0.00
- 0.00 - 0.00
- 0.00 - 0.00
- 0.00 - 0.00
13.56% 196,858,467 24.32 -9.22% 190,961,600 30.90 -11.94%
134,470,921 13.58 16,880,520 -6.76
PERFORMANCE YTD
Nov-24
DESCRIPTION YTD BUDGET % YTD ACTUAL %
STATISTIC 2024 2024
Average Room Rate 311,700 313,724
Room Available 21,775 21,775
Occupied Room 15,556 15,954
% Occupancy 71.44% 73.27%
Paying Room 15,166 15,689
% Occupancy of Paying Room 69.65% 72.05%
House Use 335 242
Compliment Room 55 23
Out Of Order Room - 32
No of Total Guest 28,816 31,565
REVENUE
Room 4,727,244,716 55.10 4,922,022,755 68.84
Food & Beverage 3,582,755,090 41.76 2,508,990,419 30.77
Other Operating Department 269,196,403 3.14 46,706,134 0.39
TOTAL REVENUE 8,579,196,209 100.00 7,477,719,308 100.00
FRONT OFFICE
Payroll & Related 245,495,261 3.25 243,671,316 2.47
Other Expenses 165,619,174 2.21 151,845,000 1.87
TOTAL FRONT OFFICE 411,114,435 5.46 395,516,316 4.35
HOUSEKEEPING
Payroll & Related 312,149,866 4.19 279,333,299 2.67
Other Expenses 341,572,958 3.81 348,897,659 10.10
TOTAL HOUSEKEEPING 653,722,823 8.00 628,230,958 12.77
FOOD & BEVERAGE
Cost food & Beverage 1,333,596,764 38.16 1,044,319,081 36.25
Payroll & Related 565,693,659 8.03 516,960,824 6.86
Other Expenses 268,154,881 4.36 277,509,571 5.15
TOTAL FOOD & BEVERAGE 2,167,445,304 28.32 1,838,789,475 23.17
OTHER INCOME DEPARTEMENT
Cost of Minor Departement 14,809,430 2.35 8,662,500 35.76
TOTAL OTHER INCOME DEPARTEMENT 14,809,430 0.07 8,662,500 0.14
ADMIN & GENERAL
Payroll & Related 612,000,266 8.13 586,512,896 6.51
Other Expenses 124,218,618 1.61 122,732,759 1.46
TOTAL ADMIN & GENERAL 736,218,884 9.75 709,245,655 7.97
HUMAN RESOURCE
Payroll & Related 113,451,259 1.42 96,168,864 0.98
Other Expenses 170,865,760 2.19 162,882,671 1.88
TOTAL HUMAN RESOURCE 284,317,019 3.61 259,051,535 2.86
SALES MARKETING
Payroll & Related 224,758,050 3.23 193,374,739 2.19
Other Expenses 316,240,393 3.24 256,734,160 2.50
TOTAL SALES MARKETING 540,998,443 6.46 450,108,899 4.69
POMEC
Payroll & Related 138,852,554 1.99 134,991,566 1.45
Other Expenses 199,739,978 2.74 154,777,215 2.46
Energy Cost 668,981,193 8.81 609,889,951 7.31
TOTAL POMEC 1,007,573,725 13.54 899,658,732 11.22
TOTAL ALL EXPENSES 5,816,200,062 75.21 5,189,264,069 67.16
GROSS OPERATING PROFIT (LOSS) 2,762,996,148 24.79 2,288,455,239 32.84
OTHER DEDUCTION
Replacement For FFnE - 0.00 - 0.00
Incentive Fee - 0.00 4,784,067 0.00
Depresiasi & Amortisasi 2,100,577,600 27.50 2,102,803,200 24.56
Other Insurance - 0.00 - 0.00
Other Deduction Expense - 0.00 (113,432,405) 0.00
Owner Expense - 0.00 148,178,887 1.08
Owner Legal Expense - 0.00 - 0.00
Owner Salary Expense - 0.00 - 0.00
TOTAL OTHER DEDUCTION 2,100,577,600 27.50 2,142,333,749 25.64
NETT OWNER SHARE PROFIT (LOSS) 662,418,548 -2.71 146,121,489 7.21
VARIANCE YTD LAST YEAR % VARIANCE
ytd 2024 to
Act to Bud 2023
ytd 2023
0.65% 305,496 -2.62%
0.00% 21,710 -0.30%
2.56% 15,013 -5.90%
2.56% 69.15% -5.62%
3.45% 14,710 -6.24%
3.45% 67.76% -5.96%
-27.76% 241 -0.41%
-58.18% 62 ###
19 ###
9.54% 28,985 -8.17%
4.12% 4,493,842,687 66.25 -8.70%
-29.97% 3,149,445,066 33.47 25.53%
-82.65% 271,856,378 0.28 482.06%
-12.84% 7,915,144,131 100.00 5.85%
-0.74% 221,203,524 2.61 -9.22%
-8.32% 169,307,584 1.87 11.50%
-3.79% 390,511,109 4.48 -1.27%
-10.51% 245,277,239 3.75 -12.19%
2.14% 334,659,187 3.39 -4.08%
-3.90% 579,936,426 7.14 -7.69%
-21.69% 1,183,205,063 45.05 13.30%
-8.61% 516,154,950 6.76 -0.16%
3.49% 307,104,793 1.96 10.66%
-15.16% 2,006,464,805 23.80 9.12%
-41.51% 3,962,000 11.41 -54.26%
-41.51% 3,962,000 0.03 -54.26%
-4.16% 533,266,730 5.36 -9.08%
-1.20% 113,042,770 1.43 -7.90%
-3.66% 646,309,500 6.79 -8.87%
-15.23% 106,985,609 0.30 11.25%
-4.67% 164,619,941 1.92 1.07%
-8.89% 271,605,549 2.21 4.85%
-13.96% 177,614,288 2.39 -8.15%
-18.82% 299,884,159 2.38 16.81%
-16.80% 477,498,448 4.77 6.09%
-2.78% 106,554,971 1.76 -21.07%
-22.51% 185,735,239 3.68 20.00%
-8.83% 630,403,052 7.42 3.36%
-10.71% 922,693,262 12.86 2.56%
-10.78% 5,298,981,099 62.10 2.11%
-17.17% 2,616,163,031 37.90 14.32%
- 0.00 ###
- 0.00 ###
0.11% 2,100,577,600 26.50 -0.11%
- 0.00 ###
- -2.17 ###
- 0.00 ###
- 0.00 ###
- 0.00 ###
1.99% 2,100,577,600 24.32 -1.95%
515,585,431 13.58 ###
ACCOUNT RECEIVABLE REPORT
Accounting Period: NOVEMBER 2024
Days
No. Company Customer Name Total
1-30 31 - 60 61 - 90 OVER 90 Current
1 F&B BCA Card - - - - - -
2 F/O BCA Card 9,720,000.00 9,720,000.00 - - - -
3 F&B BRI Card - - - - - -
4 F/O BRI Card - - - - - -
5 F&B Mandiri Card - - - - - -
6 F/O Mandiri Card - - - - - -
7 F&B Bank Transfer 493,910.00 493,910.00 - - - -
8 F/O Bank Transfer 2,138,195.00 2,138,195.00 - - - -
9 GLOBAL JET EXPRESS, PT 7,140,000.00 7,140,000.00 - - - -
10 INDONESIA BTR NEW ENERGY MATERIAL 71,275,000.00 - 71,275,000.00 - -
11 MAS ARYA SEMARANG, PT 8,652,500.00 8,652,500.00 - - - -
12 MATAHARI TIRE INDONESIA, PT 203,755,000.00 203,755,000.00 - - - -
13 HARYONO, TOUR AND TRAVEL 5,530,000.00 5,135,000.00 395,000.00 - - -
14 TRAVELOKA, T&T 7,572,920.00 7,572,920.00 - - - -
GRAND TOTAL Rp 316,277,525 Rp 244,607,525.00 Rp 71,670,000 Rp - Rp - Rp -
RATIOS 100.00% 77.34% 22.66% 0.00% 0.00% 0.00%
ACCOUNT PAYABLE AGING REPORT
Account Period: NOVEMBER 2024
Days
No. Vendor's Name Total
1-30 Days 31-60 Days 61-90 Days Over 90 Days
1 515 Snack 2,215,000.00 2,215,000.00 - - -
2 57 MEDIA 460,000.00 460,000.00 - - -
3 ABIMANTRANA .CV 360,000.00 360,000.00 - - -
4 ADIT TEKNIK AC 800,000.00 800,000.00 - - -
5 AFIKA JAYA UD 3,875,000.00 3,875,000.00 - - -
6 AMANAH PRIMA INDONESIA 248,000.00 248,000.00 - - -
7 ASTIKA JAYA 1,050,000.00 1,050,000.00 - - -
8 CV WIDHI WASA 7,202,255.00 7,202,255.00 - - -
9 CV. PELITA HATI 1,309,274.00 1,309,274.00 - - -
10 [Link] Mas 1,096,031.00 1,096,031.00 - - -
11 DJP-PAJAK PPH 25 3,010,006.00 3,010,006.00 - - -
12 DNA TAPE 1,080,000.00 1,080,000.00 - - -
13 DPKAD SEMARANG 68,009,385.00 68,009,385.00 - - -
14 ECOCARE INDO PASIFIK 434,000.00 434,000.00 - - -
15 FASTRATA BUANA .PT 3,200,000.00 3,200,000.00 - - -
16 Fawwaz Rice 5,975,000.00 5,975,000.00 - - -
17 [Link] 29,577,840.00 29,577,840.00 - - -
18 HALO 3,000,000.00 3,000,000.00 - - -
19 HATI BERSATU MAJU .CV 420,000.00 420,000.00 - - -
20 HOUSEBANK GENERAL CASHIER 5,450,000.00 5,450,000.00 - - -
21 HOUSEBANK PURCHASING 1,260,830.00 1,260,830.00 - - -
22 IBU WENI AYAM 6,626,700.00 6,626,700.00 - - -
23 JOKO GROCERIES 825,000.00 825,000.00 - - -
24 MAHARAYA SANDANA .CV 500,000.00 500,000.00 - - -
25 Minasa 1,990,000.00 1,990,000.00 - - -
26 MITRA SEJATI 1,350,000.00 1,350,000.00 - - -
27 MONASTRI .CV 132,000.00 132,000.00 - - -
28 NANOK AC 1,100,000.00 1,100,000.00 - - -
29 NNS PLASTIK 1,761,000.00 1,761,000.00 - - -
30 PDAM SEMARANG 1,505,000.00 1,505,000.00 - - -
31 PLN HOTEL 34,544,575.00 34,544,575.00 - - -
32 PLN RESTO 12,564,447.00 12,564,447.00 - - -
33 PRIMA JAYA 200,000.00 200,000.00 - - -
34 PT PRAMA NASIONAL TELECOM 2,128,550.00 2,128,550.00 - - -
35 RESTU .UD 700,000.00 700,000.00 - - -
36 SATURASI PRINTING 300,000.00 300,000.00 - - -
37 SINNAR LUCIANA JAYA ,CV 1,800,002.00 1,800,002.00 - - -
38 SPRINT Printing 266,000.00 266,000.00 - - -
39 [Link] 182,000.00 182,000.00 - - -
40 TIRTA MAKMUR 2,838,000.00 1,914,000.00 924,000.00 - -
41 Toasty Deli Cake & Bakery 225,000.00 225,000.00 - - -
42 TUNGGAL JAYA 1,243,200.00 1,243,200.00 - - -
43 Wijaya Sterno 680,000.00 680,000.00 - - -
GRAND TOTAL 213,494,095.00 212,570,095.00 924,000.00 - -