Operations - Calculation Sheets - Calculation Sheet

The Calculation Sheet tab is used to display the prices calculated for the group based on the information entered in the preceding three tabs. This tab is also accessed to print the calculation sheet in a variety of formats.

Once the calculation sheet is approved, this tab is accessed to create a travel file based on the itinerary and prices of the tour.

This page includes the following sections:

Group Costs

These are costs that are divided among all the passengers in the group. Examples of group costs are bus transportation, guide services, staff services, and certain entrance fees.

Each column in this section presents the cost according to the number of paying and free passengers defined for the group.

The Net per person cost is the total cost per person (for group costs only) according to the number of paying and free passengers defined for the group.

Click by a group cost to expand the row and view more detailed information regarding the cost itself.

Individual Costs

These are costs that will be applied individually to each passenger participating in the tour. Examples of individual costs are hotel accommodations and restaurant meals.

Note in regards to a hotel accommodation: if the hotel contract does not include a season corresponding to the dates of the hotel reservation, the prices of the last season included in the contract will be those selected for the calculation sheet.

Each column in this section presents the cost according to the number of paying and free passengers defined for the group.

The Add for free cost indicates the cost paid by the passenger in order to enable adding a free passenger to the relevant paying/free combination.

The Total individual expenses represents the total cost price for all the individual expenses according to the number of paying and free passengers defined for the group.

Click by an individual cost to expand the row and view more detailed information regarding the cost itself. For example: clicking the hotel row will display the name of the hotel, the breakdown of the hotel price, and the dates of the accommodation.

To customize markup for an individual service, click the Add Markup link.

In the Totals Markup dialog box that appears, select Apply markup, and enter the markup percentage to apply.

The new markup is applied to the individual service, including board basis components. This percentage replaces, the total percentage applied to all other services.

Totals

The Cost per person is the sum of Net per person and Total individual expenses according to the number of paying and free passengers defined for the group.

The Markup is the markup defined for the calculation sheet in the Price Definitions tab.

To add an additional markup (if required)

  1. Click Add markup.

  2. In the Markup Type field, select the markup type.

  3. In the Amount field, enter the markup amount.

  4. Click OK.

To edit an existing markup (if required)

  1. Click in the markup row to expand the row.

  2. Click Edit by the markup value to edit.

  3. Edit the relevant markup details.

  4. Click OK.

The Total selling per person is the sum of Cost per person and the markup according to the number of paying and free passengers defined for the group. This is the price at which the tour will be sold to the customer.

Note that this sum is rounded off according to the rounding policy defined in Calculation Sheets Settings.

Supplements

These are the supplements that can be added to (or deducted from) the base price of the tour (adult in double occupancy).
The supplements appearing in this section relate to services included in the calculation sheet and are based on formulas defined in Calculation Sheets Settings.

Following each supplement in this section is the breakdown of the supplement price according to net cost, markup amount, and selling price.

To edit the markup of a tour supplement (if required)

  1. Click the supplement row.

  2. Edit the value in the Markup field or the Total field.

    The two above-mentioned fields - Markup and Total - are interdependent. Updating the value in one of the fields will automatically update the value in the other field.

  3. Click to save or to revert.

To print the calculation sheet

Click Print and select one of the following printout options:

Itinerary

  1. Select Itinerary. The Print Itinerary dialog box will be displayed.

  2. In the Services section, select the services to be included in the printed itinerary.

  3. In the Print Parameters section, select the parameters (related to the services) to be included in the printed itinerary.

    The remark name or contents will be printed in the itinerary when the Remark Name or Remark Contents print parameter is selected before printing.

    The Remark Name is the title of the itinerary entry. The Remark Contents is the itinerary text itself.

  4. Click Continue. The itinerary will be displayed.

  5. Click Send to send the itinerary via e-mail or Print to print the itinerary in PDF format.

Proposal

  1. Select Proposal. The Print Proposal dialog box will be displayed.

  2. In the Services section, select the services to be included in the printed proposal.

  3. In the Remarks section, select the remarks to be printed in the header and footer of the proposal. A new remark can be added by clicking <New Remark...> at the end of the Header and Footer drop-down lists.

  4. Click Continue. The proposal will be displayed. The prices displayed in the proposal are the selling prices of the tour. Prices are displayed per person, according to the amount of paying and free passengers.

  5. Click Send to send the proposal via e-mail or Print to print the proposal in PDF format.

Totals - for internal use

  1. Select Totals - for internal use. A summary of the calculation sheet will be displayed. This document displays both the group and individual costs as well as the total price per person. The total selling price per person is presented as the sum of the cost per person and markup.

  2. Click Send to send the document via e-mail or Print to print the document in PDF format.

Full calculation - for internal use

  1. Select Full calculation - for internal use. The document displayed will present the cost of each service included in the calculation sheet. Although the same service can be reserved for more than one day in the itinerary (e.g. hotel accommodation), every unique service will appear only once in this document. The cost of each service is displayed according to its price components.

  2. Click Send to send the document via e-mail or Print to print the document in PDF format.

To create a travel file based on the calculation sheet

  1. Click Create Travel File.

    The Number of Passengers/Rooms dialog box is displayed.

  2. Enter the required number of passengers or rooms and click OK. A group travel file will be created in the Reservation System and the travel file number will be displayed in the Travel File Number field.

    In the travel file itself, two transactions will be opened for each hotel accommodation: one for the staff and one for the group.

    Once a travel file has been created, click Update Travel File if services have been added to or removed from the itinerary.

    Click this button also to update the number of passengers or rooms in the Number of Passengers/Rooms dialog box. According to the new number of passengers or rooms, the transaction amounts will also be updated in the group travel file.