In this lesson you will learn how to:

Create a new season chart
Attach a season chart to a price chart
Create a purchase price chart
Create a sales price chart
Attach a Purchase price chart to a Booking Code
Attach a Sales price chart to a Booking Code

Introduction

Discussion
A Price Chart is where all the prices, surcharges and discounts are created. The purchase prices are created in the Purchase price chart and the Sales prices are created in the Sales price chart.

Create a Purchase Price Chart

Discussion
To complete the setup of the Blue Horizons Garden Resort we need to create and attach the purchase and sales prices. Once the purchase and sales prices have been set up a booking for this hotel can be made through the booking system.
Step-by-Step: Creating a Purchase price chart
To Create a Purchase Price Chart:

Select Travel>Purchasing Prices. Alternatively select the icon.
Select Production&Procurement > The Americas > Caribbean.
Right click on the Grenada folder.
Select Create new price chart.

The Price Chart (Purchase) screen will open.

Enter GNDHBLUHOR/ASE/Y11

The Purchase Price Chart naming convention is as follows:

G D H B L U H O R / A S E / Y 1 1
Booking CodePOS Season & Year

Alphanumeric Position	Code	Examples
1-10	Booking Code	SSHHMOVPIC - Movenpick Sharm el Sheikh
11	/
12-14	POS	Point of sale code
15	/
16	Season	*Y -	Year S --* Summer W -- Winter
17-19	Year	11 - 2011

Select stay related in the Price Calculation field.

To ensure the price chart is available in all catalogues:

Select Price chart enable in all catalogues.

Select the button to the right of the Season Chart field.

The Season Dates screen will be displayed:

Select the Production&Procurement catalogue in the Catalog field.
Select Purchase under Season chart.
Select New on the left side.

The Season Chart screen will be displayed.

Enter GNDHBLUHOR/ASE/Y11 in the Description field.
Ensure Purchase is selected in the Permitted field.


	Purchase + Sales: the price chart is valid for Sales and Purchase price charts. Purchase: the price chart is valid for Purchase price charts only. Sales: the price chart is valid for Sales price charts only.

Select OK to save the Season Chart.

The GNDHBLUHOR/ASE/Y11 Season Chart is now visible.

Select GNDHBLUHOR/ASE/Y11
Select New on the right side.

The GNDHBLUHOR/ASE/Y11 is now visible.
The Season Period screen will open.
The Season Period screen is used to define a season's from date and to date.

Enter A in the Description field.
Enter A in the Season code field.


	The same character in the Description and Season code fields is used to identify the seasons. The coding structure has not yet been defined.

Enter 01.11.2012 in the Date from field.
Enter 31.10.2013 in the till field.
Select OK to save the period.

The Season Date is now visible on the right side of the screen.

Select OK to save the Season Chart.
Select the drop down box to the right of the Season Chart field.
Double click on the GNDHBLUHOR/ASE/Y11 Season Chart.
Select OK to save the Purchase Price Chart.

The Purchase price chart is now visible on the left side of the screen.

New price codes will now be created.
This is necessary in order to view the seasons.

Select the + to the left of the price chart.
Right click on Main price chart.
Select Create New Price code.

The Price code (Purchase) screen will be displayed.

Ensure the following are selected:

Basis: (Calculation): Night

Basis: (Calculation):
Night: if the calculation is per night.
Once: if there is one price for the entire stay, for example a tour.
Calculation type: Participants


	Select Participants in the Calculation type field to calculate the sales price on a per person basis. Select Unit in the Calculation type field to calculate the sales price per unit, for example, a cruise or an hotel room.

Price Charts always relate to a certain room type. It is necessary to define which type of room at the Blue Horizons Garden Resort hotel this Price Chart applies to. In this example a standard double room (DS20) will be selected:

Select the drop down box in the Code combination field.
Select No catalog assignment > Hotel > Room Types folder.
Select the DS20 room type.
Enter Double Room Standard Garden View in the Price description.
Select OK to save the price code.


	The Code Combination for the Price code must be the same as the Code Combination for the Service types. This also applies to the Sales Price chart.

The Standard Double room price code is now visible.
To specify the price calculation for this room type:

Right click on Double Room Standard Garden View.
Select Properties.

The Price code (Purchase) window will open.

Select Unit in the Calculation type field.


	The calculation type can vary dependant on the agreement. To calculate the purchase price per person select Participants To calculate the purchase price per room select Unit

Select OK to save.

The starting date of the season is displayed but the end date is not visible, (as discussed earlier in the Create a Sales Price section of this document).
Step-by-Step: Display Season Start and End Dates
The starting date of the season is displayed but the end date is not visible. This is confusing as the end user cannot tell when the season ends.
To display the seasons end date:

Right click on GNDHBLUHOR/ASE/Y11
Select Design.
Select Seasons.
Select All season terms.

Navigate to the price chart and the season start and end dates will now be visible

Select the + left from GNDHBLUHOR/ASE/Y11.
Select the + left from Main price chart.
Select the + left from Standard Double room.

.
BEFOREAFTER

Enter Purchase Prices in the Season Chart

Discussion
Now that the Season Charts have been created, the Purchase prices must be entered indicating the purchase price for a standard double room in the Blue Horizons Garden resort for the selected season.

	In the illustrated example only one season has been setup 1^st November 2012 to 31^st October 2013. It is however, still necessary to enter a season price otherwise it will not be possible to book this room in the booking system.

Right click on the season.
Select Create New Price.

The Saison code / Prices (Sale) window will open.

Select Basic price in the Basis field.
Enter 78 (*the purchase price) in the *Amount field.
Select Basic price in the Product type field.


	The Product type field is used to define cancellation conditions, commission paid to a travel agency etc. For example a travel agency may receive 5% commission on flights and 10% commission on hotel rooms.

Select OK to save the new price.

The price is now visible on the right side of the screen. The purchase price chart is now created.

Create a Sales Price and Season Chart

Discussion
A Sales Price chart will now be created. In the One Instance approach Sales Price charts will reside within the POS Catalogue. As the POS folder structure already references the Tour Operator and Year, for example Apollo Sweden 2010/11 (ASE2010/11), there is no need to reference this information in the Sales Price Chart title.


	Once a Purchase Price chart has been created it is possible to make a copy and paste it into the Sales Price chart where it can be edited.

	Please note, if the Booking Ability field in the Booking Code is set to Bookable the system will allow the service to be booked irrespective of whether sales and purchase prices have been set up. This is extremely dangerous as the service could effectively be sold free of charge.

To create a Sales Price chart:
Step-by-Step: Creating a Sales Price Chart

Select Travel>Selling Prices. Alternatively select the icon.

The Selling Prices menu is displayed.

Select BEWO12/13> The Americas > Caribbean .
Right click on the Grenada folder.

Select Create new price chart.

The Price Chart (Sale) screen will open.


	The relevant POS catalogue appears in the Catalog field.

Enter GNDHBLUHOR/ ASE/Y11 in the Name field.

The Sales Price Chart naming convention is as follows:
G D H B L U H O R / A S E / Y 1 1
Booking CodePOS Season & Year

Alphanumeric Position	Code	Examples
1-10	Booking Code	SSHHMOVPIC - Movenpick Sharm el Sheikh
11	/
12-14	POS	related point of sale
15	/
16	Season	*Y -	Year S --* Summer W -- Winter
17-19	Year	11 - 2011

Select Stay related in the Price calculation field.
Select Price chart enable in all catalogues.

The option selected in the Price Calculation field determines the price a customer is charged.

If Stay Related is selected a customer might be charged, for example, 100 Euros per night for the first week of their stay and 120 Euros per night for the second week of their stay, because the second week falls into a higher season.

If Departure Related is selected their entire stay will be calculated as at the rate on the date of departure. For example, if their room rate is 100 Euros per night for the first week and 120 Euros per night for the second week, 120 Euros per night will be charged for their entire stay.

As pricing is season dependent before any prices can be entered into DaVinci a Season Chart must be created and the dates for each season defined. To create the Season Chart:

Select the button to the right of the Season Chart field.

The Season Dates screen will be displayed:

Select the BEWO12/13catalogue in the Catalog field.
Select Sales under Season chart.
Select New on the left side.

The Season Chart screen will be displayed.

Enter GNDHBLUHOR/ASE/Y11 in the Description field.


	The Season Chart name entered in the Description field should have the same name as that used for the Booking Code.

Ensure Sales is selected in the Permitted field.


	Purchase + Sales: the price chart is valid for Sales and Purchase price charts. Purchase: the price chart is valid for Purchase price charts only. Sales: the price chart is valid for Sales price charts only.

Select OK to save the Season Chart.

The GNDHBLUHOR/ASE/Y11 Season Chart is now visible.

Select GNDHBLUHOR/ASE/Y11
Select New on the right side.

The GNDHBLUHOR/ASE/Y11 is now visible.
The Season Period screen will open.
The Season Period screen is used to define a season's from date and to date.

Enter A in the Description field.
Enter A in the Season code field.


	The same character in the Description and Season code fields is used to identify the seasons. The coding structure has not yet been defined.

Enter 01.11.2012 in the Date from field.
Enter 31.10.2013 in the till field.
Select OK to save the period.

The Season Date is now visible on the right side of the screen.

Select OK to save the Season Chart.
Select the drop down box to the right of the Season Chart field.
Double click on the GNDHBLUHOR/ASE/Y11 Season Chart.
Select OK to save the Sales price chart.

Price chartThe Sales price chart is now visible on the left side of the screen.

New price codes will now be created. This is necessary in order to view the seasons.

Select the + to the left of the price chart.
Right click on Main price chart.
Select Create New Price code.

The Price code (Sale) screen will be displayed.

Ensure the following are selected:

Basis: (Calculation): Night



Basis: (Calculation):
Night: if the calculation is per night.
Once: if there is one price for the entire stay, for example a tour.
Calculation type: Participants


	Select Participants in the Calculation type field to calculate the sales price on a per person basis. Select Unit in the Calculation type field to calculate the sales price per unit, for example, a cruise or an hotel room.

Price Charts always relate to a certain room type. It is necessary to define which type of room at the Blue Horizons Garden Resort hotel this Price Chart applies to. In this example a standard double room (DS20) will be selected:

Select the drop down box in the Code combination field.
Select No catalog assignment > Hotel > Room Types folder.
Select the DS20 room type.
Enter Double Room Standard Garden View in the Price description.
Select OK to save the price code.


	The Code Combination for the Price code must be the same as the Code Combination for the Service types. This also applies to the Purchase Price chart.

The Standard Double room price code is now visible.
To display the seasons end date:

Right click on GNDHBLUHOR/ASE/Y11
Select Design.
Select Seasons.
Select All season terms.
Open GNDHBLUHOR/ASE/Y11
Open the Main price chart.
Open the Standard Double room.

The season end date is now visible on the right side of the screen. The Purchase price for this season now needs to be entered.

Enter Sales Prices in the Season Chart

Discussion
Now that the Season Charts have been created, the Sales price must be entered indicating the sales price for a standard double room in the Blue Horizons Garden resort for the selected season.

	In the illustrated example only one season has been setup 1^st November 2012 to 31^st October 2013. It is however, still necessary to enter a season price otherwise it will not be possible to book this room in the booking system.

Right click on the season.
Select Create New Price.

The Saison code / Prices (Sale) window will open.

Select Basic price in the Basis field.
Enter 178 (*the selling price) in the *Amount field.
Select Basic price in the Product type field.


	The Product type field is used to define cancellation conditions, commission paid to a travel agency etc. For example a travel agency may receive 5% commission on flights and 10% commission on hotel rooms.

Select OK to save the new price.

The price is now visible on the right side of the screen. The Sales price chart is now created.


	A Season Chart and Price Chart must be stored in the same catalogue otherwise they cannot be linked.

Attach a Sales/Purchase Price Chart to a Booking Code

Discussion
The Sales and Purchase Price charts have been created they now need to be attached to the Blue Horizons Resort hotel booking code. To attach the Sales/Purchase charts follow these steps:
Step-by-Step: Attaching a Sales price chart and a Purchase price chart to the Booking Code.
The Sales and Purchase price charts are attached to the booking code located in the master catalogue. To access the booking code:

Select Travel>Services.
Select Master > The Americas > Caribbean > Grenada
Open the Blue Horizons Garden Resort Booking Code.
Select the Booking Code tab.

To attach the Sales Price Chart to the Booking Code:

Select BEWO12/13from the Catalog field.

Click in the BEWO12/13row in the Sales column.
Select BEWO12/13> The Americas > Caribbean > Grenada
Select GNDHBLUHOR/ASE/Y11

To attach the Purchase Price Chart to the Booking Code;

Click in the BEWO12/13row in the Purchase Price field.
Select Production&Procurement > The Americas > Caribbean > Grenada > Blue Horizons Garden Resort > BEWO12/13>
Select GNDHBLUHOR/ASE/Y11


	Once sales prices and allotments have been assigned the booking ability field is updated to Bookable to ensure this service can be booked through the booking front end.

Now the Purchase and Sales prices have been attached to the booking code this hotel is bookable.

Select Bookable in the Booking Ability field.

Currency

Discussion
The local currency is normally the default currency of the DaVinci database. Hotel contracts are normally in the currency of the supplier or in US dollars. To change the currency of a price chart.

Right Click on the Main Price Chart of a booking code.
Select Properties.

The Price Subchart screen is displayed:

Select the required currency from the SP Currency field.
Select OK.

The Main Price Chart displays the selected currency.

Exercise 5

Each student will create a Season Chart, Sales Price and Purchase Price Charts.
Create four seasons as follows:

Season one:01 Jan 2012 to 31 Mar 2012
Season two: 01 April 2012 to 30 Jun 2012
Season three: 01 Jul 2012 to 30 Sep 2012
Season four:01 Oct 2012 to 31 Dec 2012
With reference to the table below:

Create Sales and Purchase Price Charts for the relevant hotel.

	Destination and IATA	Hotel name and address	Sales Price	Purchase Price
Student 1	Bahama's (NAS) BS	Compass Point West Bay Street 10 Nassau, Bahama's E: res@compasspoint.com	€170 per night €180 per night €200 per night €190 per night	€100 per night €110 per night €120 per night €110 per night
Student 2	Barbados (BGI) BB	Tamarind Cove Paynes Bay 54 St. James, Barbados P: 9546 253 700	€250 per night €260 per night €320 per night €300 per night	€175 per night €190 per night €250 per night €230 per night
Student 3	St. Lucia (SLU) LC	Coco Palm Rodney Bay Boulevard 45 Rodney Bay Village, St. Lucia F: 1758 452 0766	€175 per night €185 per night €210 per night €200 per night	€110 per night €120 per night €140 per night €140 per night
Student 4	St. Martin (SXM)	Divi Little Bay Little Bay Road 89 Philipsburg, St. Martin P: 599 542 2333	€290 per night €320 per night €350 per night €320 per night	€220 per night €240 per night €270 per night €240 per night
Student 5	Jamaica (MBJ) JM	Coyaba Beach Resort Mahoe Bay 4 Montego Bay, Jamaica E: coyabares@cwjamaica.com	€250 per night €260 per night €320 per night €300 per night	€175 per night €190 per night €250 per night €230 per night
Student 6	Antigua (ANU) AG	Blue Waters Dickinson Bay 5 St. John's, Antigua F: 0044 870 360 1246	€290 per night €320 per night €350 per night €320 per night	€220 per night €240 per night €270 per night €240 per night
Student 7	Suriname (PBM) SR	Royal Torarica Small Waterstreet 10 Paramaribo, Suriname P: 00 597 471500	€175 per night €185 per night €210 per night €200 per night	€110 per night €120 per night €140 per night €140 per night
Student 8	Tobago (TAB) TT	Blue Waters Inn Batteaux Bay Speyside, Tobago P: 868 660 4341	€170 per night €180 per night €200 per night €190 per night	€100 per night €110 per night €120 per night €110 per night

Exercise 6

In Exercise 1 booking codes for the following hotels were created:

Student	Hotel Details	Room type
Student 1	Hotel Palmtree Hill	BS Bungalow Standard
Student 2	Hotel Coconut Grove	BD Bungalow Delux
Student 3	Coyaba Beach Resort	BE Bungalow Executive
Student 4	Calabash Hotel and Villas	BT Bungalow Suite
Student 5	Maca Bana Villa	VE Villa Executive
Student 6	Sandals Coyaba Beach	VC Villa Club
Student 7	Grand Braco Resort and Spa	VU Villa Suite
Student 8	Coco Palm	VO Villa Superior

Assign the Room Type shown in the table above to the booking code.
Create an Allotment from 1 Jan 2012 to 31 Dec 2012.
Create the following 3 Season Charts:

Season one:01 Jan 2012 to 30 Jun 2012
Season two: 01 Jul 2012 to 30 Sep 2012
Season three: 01 Oct 2012 to 31 Dec 2012

Create Sales and Purchase Price Charts.
Create a booking for the relevant hotel in Genesis.

DaVinci Dokumentationen

Lesson 7 - Price charts