HOTEL BUDGETING
ACCUPANCY ROOM FOR APRIL
| DATE | ROOM AVAILABLE | ROOM OCCUPAID | TOTAL GUESTS | OCCUPANCY |
| 1 APRIL | 100 | 41 | 77 | 41% |
| 2 APRIL | 100 | 47 | 94 | 47% |
| 3 APRIL | 100 | 47 | 89 | 47% |
| 4 APRIL | 100 | 51 | 100 | 51% |
| 5 APRIL | 100 | 52 | 104 | 52% |
| 6 APRIL | 100 | 50 | 95 | 50% |
| 7 APRIL | 100 | 67 | 132 | 67% |
| 8 APRIL | 100 | 68 | 136 | 68% |
| 9 APRIL | 100 | 70 | 140 | 70% |
| 10 APRIL | 100 | 100 | 188 | 100% |
| 11 APRIL | 100 | 100 | 173 | 100% |
| 12 APRIL | 100 | 100 | 190 | 100% |
| 13 APRIL | 100 | 100 | 200 | 100% |
| 14 APRIL | 100 | 100 | 185 | 100% |
| 15 APRIL | 100 | 100 | 195 | 100% |
| 17 APRIL | 100 | 76 | 152 | 76% |
| 18 APRIL | 100 | 76 | 152 | 76% |
| 19 APRIL | 100 | 75 | 150 | 75% |
| 20 APRIL | 100 | 80 | 160 | 80% |
| 21 APRIL | 100 | 71 | 140 | 71% |
| 22 APRIL | 100 | 35 | 70 | 48% |
| 23 APRIL | 100 | 40 | 78 | 40% |
| 24 APRIL | 100 | 40 | 80 | 40% |
| 25 APRIL | 100 | 43 | 80 | 43% |
| 26 APRIL | 100 | 97 | 97 | 97% |
| 27 APRIL | 100 | 99 | 190 | 99% |
| 28 APRIL | 100 | 98 | 196 | 98% |
| 29 APRIL | 100 | 72 | 144 | 72% |
| 30 APRIL | 100 | 72 | 142 | 72% |
Total 3.929 tamu 2520
Total Occupancy for April : Total room Occupancy per nite / total nite
2520% / 30 hari = 84 %
I. FRONT OFFICE DEPARTEMENT FOR APRIL
- Occupancy : 84 %
- Room Available : 100 room / nite
100 room x 30 = 3000 room / month
- Room rate : Rp. 375.000 / room
- Total employee : 23 persons
· TOTAL ROOM OCCUPIED FOR APRIL
Accupancy X Room Available = 84 X 3000 = 2.520 ROOM NIGHT
100 100
· ROOM REVENUE FOR APRIL
Room rate X room Occupaid : Rp. 375.000 X 2.520 = Rp.945.000.000
| ITEM | (Rp) | (Rp) |
| PAYROLL EXPENSES: | | |
| 1. SALARIES | 35.200.000 | |
| 2. SERVICE CHARGE | 14.490.000 | |
| 3. EMPLOYEE MEALS | 6.012.000 | |
| TOTAL PAYROLL EXPENSES | | 55.702.000 |
| | | |
| •OTHER EXPENSES: | | |
| 1. MAINTENANCE COMPUTER | 200.000 | |
| 2. DECORATION (FLOWERS) | 144.000 | |
| 3. GUEST TRANSPORTATION | 765.000 | |
| 4. LAUNDRY | 1.520.000 | |
| 5. OPERATING SUPPLIES | 4.174.000 | |
| 6. PRINTING | 358.500 | |
| 7. TELECOMUNICATIONS | 4.800,000 | |
| 8. CLEANING | 49.000 | |
| TOTAL OTHER EXPENSES | | 12.010.500 |
| TOTAL EXPENSES | | 67.712.000 |
KETERANGAN :
- FOM dan Night Manager = 6 hari kerja 1 hari libur
Selama april 26 hari kerja
4 hari libur
- Supervisor = 5 hari kerja 1 hari libur
Selama April 25 hari kerja
5 hari libur
- Staff = 5 hari kerja 1 hari libur
Selama april 25 hari kerja
5 hari libur.
· SALARIES
1. FOM : 1 x Rp 4.000.000 = Rp.4.000.000
2. NIGHT MANAGER : 1 x Rp 3.000.000 = Rp.3.000.000
3. SUPERVISOR : 3 x Rp.2.000.000 = Rp.6.000.000
4. FDA : 6 x Rp.1.500.000 = Rp.9.000.000
5. TO : 6 x Rp.1.200.000 = Rp.7.200.000
6. BELLBOY : 6 x Rp.1.000.000 = Rp.6.000.000
TOTAL = Rp.35.200.000.
· SERVICE CHARGE
Rp. 945.000.000 X 10% = Rp. 94.500.000 / total seluruh jumlah karyawan
94.500.000 / 150 karyawan = Rp.630.000
Rp. 630.000 X 23 staff front office = Rp.14.490.000
· EMPLOYEE MEALS APRIL
EMPLOYEE : 23 PERSONS
MEALS : Rp.12.000
- FOM : 26 DAYS x RP. 12.000 = RP. 312.000
- NIGTH MANAGER : 25 DAYS X RP.12.000 = RP.300.000
- TO : 6 X 25 DAYS X RP.12.000 = RP. 1.800.000
- FDA : 6 X 25 DAYS X RP.12.000 = RP.1.800.000
- BELLBOY : 6 X 25 DAYS X RP.12.000 = RP.1.800.000
TOTAL EMPLOYEE MEALS APRIL =Rp. 6.012.000.
· MAINTENANCE COMPUTER
Biaya refill tinta printer 1 X dalam 1 bulan
1 warna = Rp. 25.000
1 Hitam = Rp.25.000
4 printer X Rp. 50.000 = Rp. 200.000
· DECORATION
Bunga Melati Rp. 2000 / pertangkai
- Counter reception ( Dalam 1 bulan 4 X ganti )
1 Vas bunga total 3 tangkai = 3XRp.2000 = Rp.6000
6000 X 4 = Rp.24.000
- Meja Manager FO : 1 Vas bunga = 3 X Rp.2000 = Rp.6000
6000 X 4 = Rp. 24.000
- Lobby 4 Vas bunga = 4 vas X Rp.6000 X 4 = Rp. 96.000
TOTAL Rp. 144.000
· GUEST TRANSPORTATION APRIL
- Antar – Jemput tamu
Antar jemput tamu dalam 1 minggu ada 3 kali.
Dalam 1 bulan 3 X 4 = 12 kali.
1 liter bensin Rp. 4.500.
1 kali perjalanan ( pulang pergi ) = 3 liter Bensin
Total pemakaian 3 liter X 12 kali X Rp.4.500 = Rp. 486.000
- Shuttle
1 kali perjalanan 2 Liter
31 Hari X 2 liter X Rp.4500 = Rp. 279.000
· LAUNDRY
- Cold towel for Welcoming Guest.
Biaya Laundry untuk 1 towel Rp, 500
Jumlah tamu pada Bulan April = 3.929 tamu X Rp.500 = Rp.1.964.500
- Uniform
Setiap karyawan biaya laundry uniform Rp.10.000 & Rp. 5000
Laundry 2 hari kerja 1 kali Laundry.
1. FOM = 26 hari kerja / 2 X Rp. 10.000 = Rp.130.000
2. Night Manager = 26 / 2 X Rp.10.000 = Rp. 130.000
3. Supervisor & Staff = 25/2 X Rp. 5000 X 21orang = Rp.1.260.000
Total Rp. 1.520.000
· OPERATING SUPPLIES
- Welcome Drink
Biaya 1 gelas Welcome drink Rp. 1000
Sunquick 1 liter Rp. 12.000
Gula Rp.3000
Dapat 15 Gelas.
Tamu bulan April 3.929 X Rp.1.000 = Rp.3.929.000
- Paper for Operational
1 Bulan menghabiskan 5 Rim kertas
1 Rim X Rp. 35.000 = 5 X Rp.35.000 = Rp. 175.000
- Forms reservations
Biaya form selama 1 bulan = Rp.50.000
- Pen
1 Dos Rp. 20.000
1 Bulan X 1 dos = 1 X Rp. 20.000 = Rp. 20.000
TOTAL = Rp. 4.174.000.
· PRINTING
- Brousur
Dalam 1 bulan menghabiskan 150 Brousur
1 Brousur = Rp, 1500 = 150 X Rp. 1500 = Rp. 225.000.
- Price List
Dalam 1 bulan pakai 150 Price list = Rp. 750 = 150 X 750 = Rp.112.500.
- Welcome Letter.
Dalam 1 bulan sekitar 5 Orang Tamu Special Chek In.
5 X Rp,1500 = Rp.7500
Dalam 1 bulan 1 orang yang Ulang Tahun.
1 X Rp.1500 = Rp. 1500
Dalam 1 Bulan sekitar 6 Tamu VIP yang Check In.
6 X Rp.2000 = Rp.12.000
Total = Rp. 358.500.
· TELECOMUNICATIONS
- Biaya Telephone per bulan Rp. 3.500.000
- Biaya fax per bulan Rp. 300.000
- Biaya Internet per bulan Rp. 1.000.000
TOTAL Rp. 4.800.000
· OTHERS
- Bayfresh (Pengaharum ruangan) Rp.12.000
1 bulan 2 pcs = 2 X Rp.12.000 = Rp.24.000
- Dll biaya tak terduga = Rp. 25.000
TOTAL = Rp.49.000
Jadi :
TOTAL EXPENSES FRONT OFFICE RP. 67.712.000
TOTAL ROOM REVENUE – TOTAL EXPENSES =REVENUE
RP. 945.000.000 – 67.712.000 = RP. 877.288.000
Tidak ada komentar:
Posting Komentar