Scribd
Upload
20 views10 pages

Bandung City Tour - 54

The document is a tour quotation form detailing transportation, accommodation, entrance fees, meals, and other costs for a group trip scheduled from January 24-28, 2024. It includes fixed and variable costs for different hotel options and provides a breakdown of expenses per person. The total estimated cost for the tour is presented alongside potential profits and fees.

Uploaded by

anya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
20 views10 pages

Bandung City Tour - 54

The document is a tour quotation form detailing transportation, accommodation, entrance fees, meals, and other costs for a group trip scheduled from January 24-28, 2024. It includes fixed and variable costs for different hotel options and provides a breakdown of expenses per person. The total estimated cost for the tour is presented alongside potential profits and fees.

Uploaded by

anya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

TOUR QUOTATION FORM

Name of Group : -
Destination

DESCRIPTION BASIC RATE UNIT TIMES

TRANSPORTATION
Medium Bus 31 Seats Dalam Kot 2,300,000 1 1
Medim Bus 31 seats Luar Kota 2,600,000 1 4
Tol 200,000 1 3
Parkir 300,000 1 5
Driver / co driver tips 250,000 1 5

HOTEL - ACCOMMODATION
Savoy Homann 665,000 1/2 2
Grand Dafam 700,000 1/2 2
Aston Hotel 750,000 1/2 2
Royal Safari Garden Resort 975,000 1/2 1
Orchardz Jayakarta 500,000 1/2 1

ENTRANCE FEES / PACKAGES


Tangkuban Perahu 310,000 1 1
FLOATING MARKET 50,000 1 1
SAUNG ANGKLUNG UDJO 150,000 1 1
Nicole Park 70,000 1 1
Taman Sari 450,000 1 1

MEALS
Breakfast - 1 1
Lunch 100,000 1 5
Dinner 125,000 1 4
Mineral water 50,000 1 3

TOUR LEADER / GUIDE PORTI


Guide / TL Fee 500,000 1 5

OTHERS
Tipping Guide/ TL 30,000 13 5
Inap Crew 500,000 1 2
Runner - 1 3
Stand by money 100,000 13 5

FOC PORTION
FOC FOR TL - 1 1
HT FOC FOR TL 1,487,500 1 1

Nett Fixed
Nett Variable
Basic Fare
Mark Up / profit per pax
Marketing fee
Employeement Welfare Fund
Pajak PPH 23
Selling Price
SS

Estimation Profit official

Price per pax Rounded Up


Invoicing 13
Employeement Welfare Fund

Quoted by
TOUR QUOTATION FORM

Travel Period : 24-28 Januari 2024


Total Pax Payment : 13

FIXED COST VARIABLE COST


Savoy Homann Grand Dafam Orchardz Jayakarta

2,300,000
10,400,000
600,000
1,500,000
1,250,000

665,000
700,000
750,000
487,500 487,500 487,500
250,000 250,000 250,000

310,000 310,000 310,000


50,000 50,000 50,000
150,000 150,000 150,000
70,000 70,000 70,000
450,000 450,000 450,000

- - -
500,000 500,000 500,000
500,000 500,000 500,000
150,000

2,500,000

1,950,000
1,000,000
-
6,500,000

-
1,487,500
29,637,500 3,432,500 3,467,500 3,517,500

2,279,808 2,279,808 2,279,808


3,432,500 3,467,500 3,517,500
5,712,308 5,747,308 5,797,308
10% 571,231 574,731 579,731
0% - - -
1% 57,123 57,473 57,973
11% 62,835 63,220 63,770
6,403,497 6,442,732 6,498,782
1,402,500 1,437,500 1,487,500

7,426,000 7,471,500 7,536,500

6,405,000 6,445,000 6,500,000


83,265,000 83,785,000 84,500,000
1% 832,650 837,850 845,000

Approved by,

Theodorus P Jodimarlo
yakarta
TOUR QUOTATION FORM

Name of Group : -
Destination

DESCRIPTION BASIC RATE UNIT TIMES

TRANSPORTATION
Medium Bus 31 Seats Dalam Kot 2,300,000 1 1
Medim Bus 31 seats Luar Kota 2,600,000 1 4
Tol 200,000 1 3
Parkir 300,000 1 5
Driver / co driver tips 250,000 1 5

HOTEL - ACCOMMODATION
Savoy Homann 665,000 1/2 2
Grand Dafam 700,000 1/2 2
Aston Hotel 750,000 1/2 2
Royal Safari Garden Resort 975,000 1/2 1
Orchardz Jayakarta 500,000 1/2 1

ENTRANCE FEES / PACKAGES


Tangkuban Perahu 310,000 1 1
FLOATING MARKET 50,000 1 1
SAUNG ANGKLUNG UDJO 150,000 1 1
Nicole Park 70,000 1 1
Taman Sari 450,000 1 1

MEALS
Breakfast - 1 1
Lunch 100,000 1 5
Dinner 125,000 1 4
Mineral water 50,000 1 3

TOUR LEADER / GUIDE PORTI


Guide / TL Fee 500,000 1 5

OTHERS
Tipping Guide/ TL 30,000 20 5
Inap Crew 500,000 1 2
Runner - 1 3
Stand by money 100,000 20 5

FOC PORTION
FOC FOR TL - 1 1
HT FOC FOR TL 1,487,500 1 1

Nett Fixed
Nett Variable
Basic Fare
Mark Up / profit per pax
Marketing fee
Employeement Welfare Fund
Pajak PPH 23
Selling Price
SS

Estimation Profit official

Price per pax Rounded Up


Invoicing 20
Employeement Welfare Fund

Quoted by
TOUR QUOTATION FORM

Travel Period : 24-28 Januari 2024


Total Pax Payment : 20

FIXED COST VARIABLE COST


Savoy Homann Grand Dafam Orchardz Jayakarta

2,300,000
10,400,000
600,000
1,500,000
1,250,000

665,000
700,000
750,000
487,500 487,500 487,500
250,000 250,000 250,000

310,000 310,000 310,000


50,000 50,000 50,000
150,000 150,000 150,000
70,000 70,000 70,000
450,000 450,000 450,000

- - -
500,000 500,000 500,000
500,000 500,000 500,000
150,000

2,500,000

3,000,000
1,000,000
-
10,000,000

-
1,487,500
34,187,500 3,432,500 3,467,500 3,517,500

1,709,375 1,709,375 1,709,375


3,432,500 3,467,500 3,517,500
5,141,875 5,176,875 5,226,875
10% 514,188 517,688 522,688
0% - - -
1% 51,419 51,769 52,269
11% 56,561 56,946 57,496
5,764,042 5,803,277 5,859,327
1,402,500 1,437,500 1,487,500

10,283,750 10,353,750 10,453,750

5,765,000 5,805,000 5,860,000


115,300,000 116,100,000 117,200,000
1% 1,153,000 1,161,000 1,172,000

Approved by,

Theodorus P Jodimarlo
yakarta

You might also like