Panca Maha Butha Resort & Hotel Room Budget Analy

No Items Sub Items Size

1 Furniture
Bed set 200x200cm
Chair Sofa
Sun Lounge
Living Room Chair
(kursi di working desk)
Wooden Leisure Arm
Chair (Black)
Table/ Working Desk
Ottoman
Door 2-Drawer
100 x 57 x 180 cm
wardrobe Wardrobe

Column Open Wardrobe 177 x 48 x 200cm

Doors living room door set

sliding door next to pool

main door

Bathroom Sliding Door 12m2

Bathroom Door
Mirror
side table

Oypla 5 Piece Kitchen Canister Storage Tin Set

Tea/ Coffee Set

Green Yiko Heat Resistant Elegant Glass Tea Pot Set

bed mosquito net

TV Cabinet HEMNES
Round Table (coffe table)
2 Toilet
modern Toilet Bowl
Bathtub
Towel Hanger
soap, shampoo, contioner
dispenser with sensor
toothbrush Dispenser
 Vanity
shower box
shower tap
Traditional Wall Hung Framed
Mirror
bathroom shelf storage rack
tissue hanger
Salviken, Hand Towel, White

Washable 100% Organic

Cover Support Neck Head
Memory Foam Petite Bolster
Roll Round Pillow

3 Miscellaneous
Rugs vedbak 2mx3m
Machine Made Tufted
Nylon Home Carpet 3mx4m
doormat 44cmx75cm
60cmx100cm
Slippers
SDB
Hanger wooden suit hanger
Vase
Paintings
Air Freshener
tissue box
4 Linen
Round Neck Pillow
Dedicated Sofa for Hotel
Pillow
Pillow GULKAVLE
Round Neck Pillow
Dedicated Sofa for Hotel
(2x Rp. 63.000)
Bed Sheet NATTJASMIN
Duffet
Towel
Bathrobe
Bed Cover / Duvlet
Bed Cover set SMASPORRE
curtain set
5 Plants/ Foliages
 plam tree ouside
6 Electronics
MCB 4 kutub (63A)
fridge
tv 43inch
keycard
Ac Daikin Urusara 7 1pk Ftxz25
telephone
7 Lightings
bed lamp
Crystal Glass Decorative Table
Lamp (working desk)
Marble Iron Standing Floor
Lamp

Searchlight Popular 69cm

Chrome T5 Oblong Wall Light
With Tubular White Glass

TOTAL
8 Materials
Cat Tembok Dulux
Flooring Kayu Jumbo
Flooring Statuario slab
Astrantia Walpaper 1,37mx50m
Lemparquet Merbau (pool) tebal 1cmxlebar 5cm x
Batu Alam Riverstone (pool)
Total Material

Misal
Investasi

harga kamar

Investasi

harga kamar
Investasi

harga kamar

Investasi

harga kamar
rt & Hotel Room Budget Analysis

Qty1 Qty2 Price Sub Total

1 set Rp 25,000,000 Rp 25,000,000

1 buah Rp 12,000,000 Rp 12,000,000
1 buah Rp 5,099,150 Rp 5,099,150
Rp 8,386,000 Rp 8,386,000
1 buah
Rp 5,334,000 Rp 5,334,000
1 buah
1 buah Rp 2,530,000 Rp 2,530,000
1 buah Rp 1,400,000 Rp 1,400,000
Rp 3,156,000 Rp 3,156,000
1 buah
Rp 2,565,000 Rp 2,565,000
1 buah
1 set Rp 46,704,000 Rp 46,704,000
Rp 36,960,000 Rp 36,960,000
1 set
1 set Rp 3,560,000 Rp 3,560,000

Rp 33,600,000 Rp 33,600,000
1 set
1 set Rp 3,100,000 Rp 3,100,000
2 buah Rp 250,000 Rp 500,000
2 buah Rp 799,000 Rp 1,598,000

Rp 280,000 Rp 280,000
1 set

Rp 308,000 Rp 308,000
1 set
1 set Rp 5,000,000 Rp 5,000,000
1 buah Rp 12,497,000 Rp 12,497,000
1 buah Rp 1,890,000 Rp 1,890,000

1 set Rp 6,790,000 Rp 6,790,000

1 set Rp 13,042,879 Rp 13,042,879
1 set Rp 532,000 Rp 532,000
Rp 5,222,000 Rp 5,222,000
1 set
1 set Rp 210,000 Rp 210,000
1 set Rp 13,857,655 Rp 13,857,655
1 set Rp 5,980,000 Rp 5,980,000
2 set Rp 1,260,000 Rp 2,520,000
Rp 1,675,001 Rp 1,675,001
1 buah
1 buah Rp 1,000,000 Rp 1,000,000
1 buah Rp 168,000 Rp 168,000
Rp 79,900 Rp 159,800
2 buah

Rp 74,495 Rp 74,495
1 buah

1 buah Rp 1,500,000 Rp 1,500,000

Rp 3,150,000 Rp 3,150,000
1 buah
2 buah Rp 266,000 Rp 532,000
1 buah Rp 308,000 Rp 308,000
2 pairs Rp 56,000 Rp 112,000
1 buah Rp 616,000 Rp 616,000
6 buah Rp 52,500 Rp 315,000

1 buah Rp 2,646,000 Rp 2,646,000

1 buah Rp80,000 Rp80,000
2 buah Rp 126,000 Rp 252,000

Rp 63,000 Rp 189,000
3 buah
4 buah Rp 799,000 Rp 3,196,000

Rp 63,000 Rp 126,000
2 buah
1 buah Rp 249,000 Rp 249,000

2 buah Rp 149,000 Rp 298,000

2 buah Rp 294,000 Rp 588,000
Rp 500,000 Rp 500,000
1 set
2 set Rp 1,500,000 Rp 3,000,000
 1 buah Rp 182,000 Rp 182,000

1 buah Rp 1,442,100 Rp 1,442,100

1 buah Rp 3,000,000 Rp 3,000,000
1 buah Rp 8,140,000 Rp 8,140,000
1 buah Rp 225,000 Rp 225,000
Rp 20,199,000 Rp 20,199,000
1 buah Rp 938,000 Rp 938,000

2 buah Rp 499,000 Rp 998,000

1 buah
Rp 442,000 Rp 442,000
2 buah
Rp 1,220,000 Rp 2,440,000
3 buah
Rp 1,870,766 Rp 5,612,298

Rp 323,894,378

10 buah Rp 300,000 Rp 3,000,000

100 buah Rp 420,000 Rp 42,000,000
15 buah Rp 3,550,450 Rp 53,256,750
150 buah Rp 115,000 Rp 17,250,000
70 buah Rp 180,000 Rp 12,600,000
200 buah Rp 117,000 Rp 23,400,000
Rp 151,506,750
Total Rp 475,401,128
Occupancy 25%
1 tahun 144 hari
5 tahun 144x5 720 hari

1tahun Rp 3,301,397
5tahun Rp 660,279

misal
occ 50%
1 tahun 96 hari
5 tahun 96x5 480 hari

1 tahun Rp 4,952,095
5tahun Rp 990,419
misal
occ 75%
1 tahun 77 hari
5 tahun 77x5 385 hari

1 tahun Rp 6,174,041
5 tahun Rp 1,234,808

misal
occ 100%
1 tahun 48 hari
5 tahun 48x5 240 hari

1 tahun Rp 9,904,190
5 tahun Rp 1,980,838
 ALLOTMENT
1 Tahun OCC %
Weekday Senin - Rabu 3 hari x 4 144 25%
Kamis - jumat 2 hari x 4 96 50%
Weekend Minggu 1 hari x 4 48 75% (48+22=
Libur Nasional 29 77 hari)
Sabtu 1 hari x 4 48 100%

Total 365 hari

 Skenario re-investasi 1 tahun
Rate Grid
Weekday Weekend
25% 50% 75% 100%
Rp 3,301,397 Rp 4,952,095 Rp 6,174,041 Rp 9,904,190

Skenario re-investasi 5 tahun

Rate Grid
25% 50% 75% 100%
Rp 660,279 Rp 990,419 Rp 1,234,808 Rp 1,980,838
 Guest Rate Discount Rate Room Rate OCC%
Online Travel Agent :
Traveloka 15% 5,170,491 50% - 75%
Booking.com 15% 5,170,491
Agoda 15% 5,170,491
Tiket.com 15% 5,170,491
Pegi-pegi.com 15% 5,170,491

Agen Tour Travel :

Panorama Destinastion 20% 4,866,345 25% - 50%
MMBC 20% 4,866,345
Darmawisata Indonesia 20% 4,866,345

Airline :
Garuda Indonesia 30% 4,258,052 25% - 50%
Citilink Airlines 30% 4,258,052
Lion Air 30% 4,258,052
Air Asia 30% 4,258,052
Batik Air 30% 4,258,052

Coorporate/Company :
Bank Central Asia 35% 3,953,905 25% - 50%
Bank Negara Indonesia 35% 3,953,905
Bank Mandiri 35% 3,953,905
PT. Mayora 35% 3,953,905
PT. Mitra Global 35% 3,953,905
 Base Rate
Rp 24,331,723
Rp 6,082,931
 AVAILABILITY

ROOM RATE 1

1,708,825

30%

ROOM TYPE Room Available Supplement 1

Deluxe 150 6,704,909
Suite 100 8,834,655

ROOM TYPE Room Available Supplement 1

Deluxe 150 2 Pax 7,404,909
Suite 100 2 Pax 9,534,655
*ADD BREAKFAST +200.000/ADULTS, 100.000/KIDS

Selain Room, fasilitas lain yang dapat dijual ialah :

No Fasilitas Qty Price
1 Ballroom 1 70,000,000
Meeting Room Halfday/Pax 500,000
2 (Kapasitas 30-50 Pax) 5 Fullday/Pax 800,000
Fullboard/Paax 1,000,000
3 SPA 30 750,000
 Mon Tue Wed
X X X
2 3 4 5 6
Base Rate
1,367,060 911,373 569,608 227,843

24% 16% 10% 4%

Room Only
2 3 4 5 6
6,363,144 5,907,457 5,565,692 5,223,927 4,996,084
8,492,890 8,037,203 7,695,438 7,353,673 7,125,830

Breakfast Inclusive
2 3 4 5 6
7,063,144 6,607,457 6,265,692 5,923,927 5,696,084
9,192,890 8,737,203 8,395,438 8,053,673 7,825,830
Thu Fri Sat Sun
X X X X
7 8 9 10

-284,804 -569,608 -854,413 -1,139,217

-5% -10% -15% -20%

7 8 9 10
4,711,280 4,426,476 4,141,671 3,856,867
6,841,026 6,556,222 6,271,417 5,986,613

7 8 9 10
5,411,280 5,126,476 4,841,671 4,556,867
7,541,026 7,256,222 6,971,417 6,686,613
STATISTICS
April Mei
ROOM
# of Days 30 31
Occupancy (%) 20% 40%
Average Room Rate 5,696,084 5,696,084
# of Room 250 250
Room Available 7,500 7,750
Room Occupied 1,500 3,100
Room Revenue 8,544,126,000 17,657,860,400
RevPar 1,139,217 2,278,434

WEDDING VENUE
Ballroom
# of Weekend 8 8
Balroom rate 70,000,000 70,000,000
Occupied 3 2
Ballroom Revenue 210,000,000 140,000,000

MEETING ROOM
# of Days 30 31
Occupied 3 4
Meeting room occupied/month 90 124
Guest/meeting room 90 120
Guest 8,100 14,880
Halfday 500,000 500,000
Fullday 800,000 800,000
Fullboard 1,000,000 1,000,000
Average meeting room rate 766,667 766,667
Meeting Room Revenue 6,210,002,700 11,408,004,960

SPA
# of Days 30 31
Spa room 30 30
Occupied 350 400
Spa rate 750,000 750,000
Spa Revenue 262,500,000 300,000,000

TOTAL REVENUE 15,226,628,700 29,505,865,360

 DRAFT FORECASTING YEAR 1

Juni Juli Agustus September

30 31 31 30
60% 70% 70% 80%
5,696,084 5,696,084 5,696,084 5,696,084
250 250 250 250
7,500 7,750 7,750 7,500
4,500 5,425 5,250 6,200
25,632,378,000 30,901,255,700 29,904,441,000 35,315,720,800
3417650 3,987,259 3,987,259 4,556,867

8 8 10 8
70,000,000 70,000,000 70,000,000 70,000,000
4 5 8 2
280,000,000 350,000,000 560,000,000 140,000,000

30 31 31 30
4 2 5 3
120 62 155 90
100 60 150 80
12,000 3,720 23,250 7,200
500,000 500,000 500,000 500,000
800,000 800,000 800,000 800,000
1,000,000 1,000,000 1,000,000 1,000,000
766,667 766,667 766,667 766,667
9,200,004,000 2,852,001,240 17,825,007,750 5,520,002,400

30 31 31 30
30 30 30 30
280 300 600 800
750000 750000 750,000 750000
210,000,000 225,000,000 450,000,000 600,000,000

35,322,382,000 34,328,256,940 48,739,448,750 41,575,723,200

Oktober November Desember TOTAL

31 30 31 275
80% 80% 80% 64%
5,696,084 5,696,084 5,696,084 5,696,084
250 250 250 250
7,750 7,500 7,750 68,750
6,000 6,200 6,000 44,175
34,176,504,000 35,315,720,800 34,176,504,000 251,624,510,700
4,556,867 4,556,867 4,556,867 33,037,287

9 8 8 75
70,000,000 70,000,000 70,000,000 70,000,000
1 3 7 35
70,000,000 2,100,000,000 490,000,000 4,340,000,000

31 30 31 275
3 2 5 31
93 60 155 949
120 60 150 930
11,160 3,600 23,250 107,160
500,000 500,000 500,000 500,000
800,000 800,000 800,000 800,000
1,000,000 1,000,000 1,000,000 1,000,000
766,667 766,667 766,667 766,667
8,556,003,720 2,760,001,200 17,825,007,750 82,156,035,720

31 30 31 275
30 30 30 30
750 670 900 5050
750,000 750,000 750,000 750,000
562,500,000 502,500,000 675,000,000 3,787,500,000

43,365,007,720 40,678,222,000 53,166,511,750 341,908,046,420

Harga Kompetitor
·        Jambuluwuk Oceano Gili Trawangan Resort Include Breakfast
Premier Lumbung Triple Rp4,000,000
Premiere Suite Rp4,800,000
·        Pondok Santi Estate Resort
Bungalow Garden View Rp5,998,936
Deluxe Bungalow Private Pool Rp7,999,026
·        The Lombok Lodge
Black Lodge ocean View Rp7,089,315
Luxury Suite Ocean View Rp10,678,465
 Deluxe Suite
Rp17,088,251 Rp23,477,491
Base Rate Rp5,696,084 Rp7,825,830
Room Only Rp4,996,084 Rp7,125,830

Breakfast Pack 2 Person 700

Harga Base rate ini masuk kedalam skenario re-investasi occ 75%-100%