Home

TPG manual

1. 25 Figure 43 TPG results before copying 26 Figure 44 TPG results after prices were copied 26 Figure 45 Margit CUIVG gt 27 Figure 46 Original Margi T ooo aE 27 Figure 4 Updated Margi TTL 28 Figure 48 Update Margin hansasemesetease a i 28 Figure 49 Updated Margin Curve s ssssssssssassssnnsnnnnnnnsnnsnsnnnnnsnnnnsnnsnnsasnnsnnnannnnn 29 FOUG LOAF 30 Figure 51 Prices loaded against the Individual Tour 30 Figure 52 TPG DIlce QUgE wamak kaa PEE 31 Figure 53 Example price type Set UD sas ak awawwqapquwapa taqwasqa 32 Figure 54 Example of Price Type Matrix 4 32 Figure 55 Example of Tour Costs screen set 4 2 33 Figure 56 Example 1 TPG Tour Modeling 2 22 04 0 2 4 33 Figure 57 Example 1 TPG Margin CUVE u u uuu suyaspa sssi aka RSINUERESFE EE 34 Figure 58 Example 1 TPG RESUNS u ul usu skusasnapakhussahas
2. Tour Date Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100 9 Jan 2008 100 16 1 2008 100 23 1 2008 100 30 Jan 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 COTON Display Tour Dates tick this box if you want to use the tour departure dates Passenger Total Control 10 Save Please note all values must match the occupancy of the pricing type All rows must match the control total Figure 13 Tour name and File name 5 6 Delete Existing File This link allows the user to delete a selected file Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator iud Delete Existinq File Load Existing File 1 Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Tour Date Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100 99 Jan 2008 100 16 Jan 2008 100 23 Jan 2008 100 30 Jan 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 HIDE EO HEIDE EE a COCOCCECE Display Tour Dates tick this box if you want to use the tour departure dates e Passenger Total Control Save Figure
3. 16 Figure 27 Departure Dates in Margin 22022222222 2 2 16 Figure 28 Margin Curve screen completed 6 17 FOUE Q OIE TPG 18 30 MU qe in 18 Figure 31 Standard price types in Tours Set Up 20 Figure 32 TPG results for Standard Price 20 Figure 33 LO FI price types in Tours Set Up ss 21 Figure 34 TPG Results for LO FI price 21 Figure 35 Adult Child LO FI price types in Tours Set Up 22 Figure 36 TPG Results for Adult Child LO FI price types n 22 Figure 37 Adult Child LO FI Twin Single price 23 Copyright Comtec Group Limited 2008 Page II Tour Price Generator TPG Manual Figure 38 TPG Results for Adult Child LO FI Twin Single price types 23 Figure 39 Load Price check box in TPG results 24 Figure 40 TPG Audit screen exclude 254 4 24 Figure 41 Apparent Air uu u u den same dan need s acces HERE I MENU MEE 25 Figure 42 Apparent Alr CMO dense de
4. Figure 44 TPG results after prices were copied Note If price types have been copied in the View Calculation Breakdown screen the figures displayed in the Summary on the top of the screen will not match with the Breakdown calculations 5 11 Update Margin Users of the TPG will manually amend the price results This manual amendment will update the margin column in the results tables If the user then runs TPG again a re price later in the year it is set that the same updated margin is used rather than the original margin Copyright Comtec Group Limited 2008 Page 26 Tour Price Generator TPG Manual Tour Price Generator Microsoft Internet Explorer Tour Modelling Margin Curve Results Departure From Departure To FI LO Amount Percent ge Amount 1 2008 2008 FI M o Delete re 1 Apr 2008 11 2008 LO 0 0 Delete 8 Apr 2008 8 2008 FI 10 0 Delete 8 Apr 2008 8 2008 Lo 0 0 Delete UR mmm 1 15 Apr 2008 15 Apr 2008 FI 0 0 Delete 15 2008 15 2008 Lo 0 0 Delete 22 Apr 2008 22 Apr 2008 FI 0 Delete 22 Apr 2008 22 Apr 2008 Lo 0 0 Delete 29 Apr 2008 29 2008 FI 0 Delete 29 2008
5. Overall Calculation k Tour Date Cost for Cost for Cost for Cost for Cost for Margin Margin Margin twin Sell twin Sell single Sell single Sell single Sell single Sell profit for 5 Price Amount Sell Price Sell Price z for profit for Margin Breakdown ithe Tour Adult FI Child FI Adult LO Child LO Amount Price Price Price Price Price Price departure departure departure 10 2008 80842 86 22710 72 19210 72 20710 7218210 7210480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 91942 101053 58 20210 72 252 63 20 00 View 0 8 Oct 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 252 63 20 00 View 15 Oct 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 252 63 20 00 View 22 Oct 2008 80842 8622710 7219210 7220710 7218210 7210480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 91942 101053 58 20210 72 252 63 20 00 View v 29 Oct 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 252 63 20 00 View v 5 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 973
6. 798 87 23496 35 4699 35 78 32 20 29 Apr 2008 18797 00 14473 69 4323 31 3618 51 798 87 23496 35 4699 35 78 32 20 Totals 93985 00 126878 35 32893 35 _ 25 Note All values are shown in currency GBP Update Margin This will copy the margin in th results table to the margin curve table toad pres 7 Click on the Update Margin button the above message will come up Click OK Figure 48 Update Margin button The values in the margin column are copied into the margin curve and saved Copyright Comtec Group Limited 2008 Page 28 Tour Price Generator TPG Manual Tour Price Generator Microsoft Internet Explorer c a Season all IN m 7 Travelink Country 0 v Tour Prague Tour v Tours Setup Add Mew File Delete Existing File Master Product All v Load Existing File 1 Edit Clone Existing File Product Prague Tour File 1 Tour Modelling Margin Curve Results Departure From Departure To Type Amount j The Margin Curve now shows the new updated margin 1 2008 1 2008 CR 0 Delete i Apr 2008 1 2008 Lo 0 0 Delete 8 2008 8 2008 0 0 Delete 8 Apr 2008 8 2008 Lo o 0 Delete 15 Apr 2008 15 2008 FI 0 0 Delete 15 Ap
7. BETA VERSION Microsoft Internet Explorer Tour Price Generator Dr i S all v T Test t T Add New File a d LISE four worse Delete Existing File Load Existing File 1 v Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Departure From Departure FI LO Amount Percentage 1 Jan 2008 1 2008 0 Delete 1 Jan 2008 1 2008 Lo 0 Delete fo Margin Calculation use the percentage as total margin rather than markup when generating prices Include Supplements include mandatory conditional supplements in accom cost calculations Booked Date From 1 Jan 1900 Booked Date To 1 1 2020 Round Prices by s D Use 1 10 positive or negative values to round to nearest pound Enter 0 for no rounding Selling Currency GBP Comments Pull departure Dates from Tour Modelling Figure 62 Example 2 TPG Margin Curve Copyright Comtec Group Limited 2008 Page 37 Tour Price Generator TPG Manual Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator me Seaso All T Test v Add New File f L ST Delete Existing File Load Existing File 1 Edit Clone Existing File Test tour File 1 Release 39
8. Extras Care Set up LO FI Prices Price Type Matrix Price Components Separately Commission Group Select Documentation Y Search Attributes M Prices Audit Adult FI AdultLO AdultFI Adult Lo Twin Twin Single Single Recher 2 2007 1 Jan 2009 1 3an 1900 13an2020 fb fb pelete 1 1 ur teeta TTRY 1 2 w j 1 Jan 1900 1 2 2020 GBP Ml Add MORS o issen 2020 ce 1 1 Figure 19 Price types in Tour Setup Actions Departure From Departure To Booking From Booking Currency Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator nace Season all v Add New File 1 Lo T Testt v T t EB 25 00 Delete Existing File Load Existing File 1 v Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results u TourDate Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100 9 1 2008 100 16 Jan 2008 100 23 1 2008 100 30 1 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 Figure 20 Price types in Tour Modeling The left axis of the Tour Modelling grid shows either Individual Tour Dates or Date
9. 29 2008 Lo 0 0 Delete m BIB 0 Add Margin Calculation Booked Date From Booked Date To Include Supplements use the percentage as total margin rather than markup when generating prices v include mandatory conditional supplements in accom cost calculations 1 Jan 1900 1 2020 2 Ti li k Season All v raveiin Country y Tour Prague Tour v Tours Setup Add New File Delete Existing File Master Product All v Load Existing File 1 v Edit Clone Existing File Product All Le Prague Tour File 1 This is an examle of the original margin curve table Round Prices by lo Use 1 10 positive or negative values to round to nearest pound Enter 0 for no rounding Figure 45 Original Margin Curve Tour Price Generator Microsoft Internet Explorer of a Season All v 1 M Travelink Country 0 Tour Prague Tour Tours Setup Add New File E Delete Existing File Master Product All v Load Existing File 1 M Edit Clone Existing File Product All v File 1 Prague Tour Tour Modelling Margin Curve Results Run TPG In this example the original margin was 20 Total Total Per Total Cost Total Total FI FI LO LO Adult FI Adult LO Adult FI Adult LO Total x 2 3 revenue 2
10. 9 Hidden Jungle Extension Select v Eurocar Group Select Update All Individual Tour Dates Tour Master Set up Microsoft Internet Explorer Thailand tour Component Quick Select Hilton Hotel single room Select Hilton Hotel twin room Select LHR BKK ee KF British Airways BA100 alloc Select M BKK LHR j British Airways BA101 alloc Select Select Jungle Extension Eurocar Group Select Update All Individual Tour Dates Mandatory Default Optional Hidden Mandatory Default Optional Hidden Tour Thailand tour FI Twin Hidden Mandatory LO Twin Mandatory Default optional 9 Hidden Mandatory Default optional Hidden Mandatory O Default O Optional 20 Hidden O Mandatory Default optional 9 Hidden O Mandatory Default optional Hidden Mandatory Default optional Hidden LO Twin Hidden Mandatory 9 Mandatory Hidden Mandatory 9 Optional 9 Hidden 9 Hidden 9 Optional 9 Hidden Figure 4 Example price type matrix completed 4 3 Tour Costs separate user manual Costs can be set up in two ways 1 In the component which is attached to the tour e g the hotel contract 2 As a tour cost Validated E view Suppressed Tours FI Single LO Single Valid
11. This field defaults to 1 1 1900 1 1 2020 The user can amend the booked dates and separate TPG files can be created for different booking periods Copyright Comtec Group Limited 2008 Page 16 Tour Price Generator TPG Manual 59 5 Round Prices The Round Prices by field allows the user to enter figures between 1 10 Positive Negative Enter zero for no rounding E g If Round prices by is set up to 9 and TPG calculates the price to be 503 84 the final price will show as 509 00 5 9 6 Selling Currency The default selling currency which will be used by the TPG when creating selling prices will be the system base currency as set in Business Rules This is in the Accounts section and is called Default currency for prices this will be Sterling for most UK operators but will be other currencies for non UK Tour operators 5 97 Comments A free type comments field allows text to be typed and saved up to a 10000 character limit Z Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator damen Se all Testt v Tours Set AME NEW fisvelik dl tour MENS Delete Existing File Load Existing File 1 Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Departure From Departure To Type FI LO Amount Percentage 1 Jan 2008 1 2008 FI
12. 00 0 0 00 Total LO 0 00 0 00 0 00 0 Total FI 23322 86 29160 00 5837 14 20 02 Grand Total 23322 86 29160 00 5837 14 20 02 Note margin is calculated as profit price 100 BreakDown SingleLo Cost Type Component Adult Child Comment Hilton Hotel single 02 01 2008 for 7 nights Per Person Based On X Sharing Occupancy 1 UnitCost 420 eur Adult Conditional supps 0 Adult Accommodation room LO 300 0000 150 0000 Mandatory Supps 0 Child Conditional Supps 0 Child Mandatory Supps 0 Accommodation Hilton Hotel twin LO 0 0000 0 0000 Not selected on Matrix Flights 2008 LHR BKK o 0 0000 0 0000 Not selected on Matrix Flights 8 2008 BKK LHR o 0 0000 0 0000 Not selected on Matrix Per Person Excursion profit LO 10 0000 10 0000 Supplier Cost 10 00 GBP LO Per Person Marketing LO 27 0000 27 0000 Supplier Cost 27 00 GBP LO Per Person National Express LO 1 5000 1 5000 Supplier Cost 1 50 GBP LO Per Person Regional Flights LO 11 0000 11 0000 Supplier Cost 11 00 GBP LO Per Person VAT LO 8 0000 8 0000 Supplier Cost 8 00 GBP LO Per Tour Airport Rep LO 2 0000 2 0000 Supplier Cost 80 00 GBP Tot Occupancy 40 Per Person 2 00 GBP Supplier Cost 2 00 GBP LO Per Tour Coach LO 53 5714 53 5714 Supplier Cost 3 000 00 eur Tot Occupancy 40 Per Person 75 00 eur Supplier Cost 75 00 eur LO Per Tour Tour Manager LO 10 0000 10 0000 Supplier Cost 400 00 GBP Tot Occupancy 40 Per Person 10 00 GBP Supplier Cost 10 00 GBP LO LO 403
13. 02 51 02 51 02 Airport rep 80 GBP total LO 1 91 1 91 1 91 1 91 Passenger load 30 10 1 1 42 Total cost pp 579 95 349 95 629 95 399 95 21927 9 Add 20 margin 724 94 437 44 787 44 499 94 Selling price round 9 729 00 439 00 789 00 509 00 27558 Margin 20 45 20 28 20 16 21 42 20 43 Profit per person 149 05 89 05 159 05 109 05 Figure 63 Example 2 TPG Results Note When modeling tour prices it is useful to see how booked passengers affect the margin of a tour as bookings increase E g 5 pax is a negative margin but 8 or more is a positive margin Using the TPG results screen it is possible to edit prices and passengers to see the effect on margin Thus it is possible to derive the minimum passenger required number from this screen It is not possible to model a mix of adults and children in the same price type in the TPG Only adults or children can be modeled in a room e g 2 adults or 2 children not 1 adult and 1 child Copyright Comtec Group Limited 2008 Page 38 COMTEC Tour Price Generator TPG Manual 7 Appendix 1 Acronyms used in this Document Flight Inclusive Copyright Comtec Group Limited 2008 Page 39 Contact Us Comtec Group Limited 6 Floor Gwent House Gwent Square Cwmbran SouthWales NP44 T 44 0 1633 627500 F 44 0 1633627501 E info comtec group com W www comtec group com Sun von
14. 0714 253 0714 Adult COST 403 0714 Child COST2253 0714 I Markup Amount 0 Percent 20 Margin Adult Price 503 8392 Child Price 316 3392 Rounding 9 Adult Price 509 Child Price 319 SingleF1 Cost Type Cornponent Adult Child Comment Hilton Hotel single 02 01 2008 for 7 nights Per Person Based On X Sharing Occupancy 1 UnitCost 420 eur Adult Conditional Supps 0 Adult Accommodation room FI 500 0000 150 0000 Mandatory Supps 0 Child Conditional Supps 0 Child Mandatory Supps 0 Accommodation Hotel twin FI 0 0000 0 0000 Not selected on Matrix m Flights a LHR BKK 230 0000 115 0000 Contract Type alloc Adult2230 0000GBP Child 115 0000GBP Adult Supps 0 0000 Child Supps 0 0000 Flights 8 2008 BKK LHR rr 0 0000 0 0000 Contract Type alloc Adult 0 0000GBP Child 0 0000GBP Adult Supps 0 0000 Child Supps 0 0000 Per Person Excursion profit FI 10 0000 10 0000 Supplier Cost 10 00 GBP LO Per Person Marketing FI 27 0000 27 0000 Supplier Cost 27 00 GBP LO Per Person National Express FI 1 5000 1 5000 Supplier Cost 1 50 GBP LO Per Person Regional Flights FI 11 0000 11 0000 Supplier Cost 11 00 GBP LO Per Person VAT FI 8 0000 8 0000 Supplier Cost 8 00 GBP LO Per Tour Airport Rep FI 2 0000 2 0000 Supplier Cost 80 00 GBP Tot Occupancy 40 Per Person 2 00 GBP Supplier Cost 2 00 GBP LO Per Tour Coach FI 53 5714 53 5714 Supplier Cost 3 000 00 eur Tot Occupancy 40 Per Person 75 00 eur Supplier Cost 75 00 eur LO Per
15. 14 Delete Existing File Clicking on the Delete Existing File link will display a warning check Copyright Comtec Group Limited 2008 Page 10 Tour Price Generator TPG Manual Microsoft Internet Explorer 2 j Are vou sure you wish to delete this File i Cancel Figure 15 Delete Existing file warning message Note It will not be possible to delete the existing file if the Load Prices program was already run for this file See Section 5 12 Load Prices 5 7 Clone Existing File This link will allow a user to clone details from the selected file into a new file At first it will also show a warning Are you sure you wish to clone this file If the user clicks all data stored in Tour Modelling and Margin Curve will get copied into the new cloned record and the new cloned file will be displayed The user can then make any necessary amendments and then re run the TPG It will not clone any details in the Results Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator gone S vw T Testt v T Set Add New File eason All our est tour ours Setup Delete Existing File Load Existing File 1 v Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Tour Date Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100
16. 3087 14 1987 29 574 86 6883 93 20 00 640 54 20 00 764 02 385 89 414 02 179 64 37622 32 1752447 12541 20 00 View 9 Jan 2008 27597 86 22448 57 2587 14 1987 29 574 86 6258 93 20 00 640 54 20 00 701 52 323 39 414 02 179 64 34497 32 689947 114 99 20 00 View 16 Jan 2008 27597 86 22448 57 2587 14 1987 29 574 86 6258 93 20 00 640 54 20 00 701 52 323 39 414 02 179 64 34497 32 689947 114 99 20 00 View 23 Jan 2008 27597 86 22448 57 2587 14 1987 29 574 86 6258 93 20 00 640 54 20 00 701 52 323 39 414 02 179 64 34497 32 689947 114 99 20 00 View 30 Jan 2008 27597 86 22448 57 2587 14 1987 29 574 86 6258 93 20 00 640 54 20 00 701 52 323 39 414 02 179 64 34497 32 689947 114 99 20 00 View 6 Feb 2008 27597 86 22448 57 2587 14 1987 29 574 86 6258 93 20 00 640 54 20 00 701 52 323 39 414 02 179 64 34497 32 689947 114 99 20 00 View 13 Feb 2008 27597 86 22448 57 2587 14 1987 29 574 86 6258 93 20 00 640 54 20 00 701 52 323 39 414 02 179 64 3449732 689947 114 99 20 00 view 20 Feb 2008 27597 86 22448 57 2587 14 1987 29 574 86 6258 93 20 00 640 54 20 00 701 52 323 39 414 02 179 64 34497 32 689947 114 99 20 00 View 27 Feb 2008 27597 86 22448 57 2587 14 1987 29 574 86 6258 93 20 00 640 54 20 00 701 52 323 39 414 02 179 64 34497 32 689947 114 99 20 00 View Totals 250880 74 313600 88 62720 14 20 00 Audit Figure 36 TPG Results for Adult Child LO FI price types Where user defined pr
17. 350 7143 30 Jan 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 06 Feb 2008 Twin GBP 441 3393 206 9643 728 86393 350 7143 06 Feb 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 13 Feb 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 13 Feb 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 20 Feb 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 20 Feb 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 27 Feb 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 27 Feb 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 18 01 2008 11 44 07 Administrator Tour Date Type Currency AdultLO ChildLO AdultFI ChildFI 02 Jan 2008 Twin GBP 441 3393 206 9643 791 3393 413 2143 02 Jan 2008 Single GBP 503 8393 316 3393 853 8393 522 5893 09 Jan 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 09 Jan 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 16 Jan 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 16 Jan 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 23 Jan 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 23 Jan 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 30 Jan 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 30 Jan 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 06 Feb 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 06 Feb 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 13 Feb 2008 Twin GBP 441 3393 206 96
18. 86 0 00 This will delete and reload prices for this booking date range all Individual Tour Dates 29153 57 5830 72 145 77 20 00 View 20 Feb 2008 23322 86 23322 86 0 00 29153 57 5830 72 145 77 20 00 View 27 Feb 2008 23322 86 23322 86 0 00 29153 57 5830 72 145 77 20 00 View Totals 211905 74 264882 13 52976 39 20 00 Pis Click OK here the system will display the message below when j J udi prices loading completed A asd M Microsoft Internet Explorer Price loading is complete Figure 50 Load Prices E Individual Tour Dates Set up Microsoft Internet Explorer aaga Fie Edit View Favorites Tools Help Ej gt Individual Tour Date Use Case Scenario One 02 01 2008 Release 39 BETA Version 1 Details Set up Child Prices Tour Prices Set up LO FI Prices M Tour Costs Price Components Separately 1 Price Type Matrix FS M e Booked From Booked To Currency Adult FI Twin Adult LO Twin Adult FI Single Adult LO single 1 1 1900_ 1 2020 cBP Delete 1 3 1900_ 1 2020 0 J DL jJ L J at Figure 51 Prices loaded against the Individual Tour Date 5 13 Audit All prices loaded will write to the tour audit trail within tour set up On the TPG the audit link will detail each occasion that load prices has been used detailing tour dates affected tour name pric
19. 92 1231 92 pj 15 9ct 2008 80842 86 22710 7219210 7220710 7218210 7210480 36 20 00 9730 36 20 00 1481 92 141942 1356 92 1356 92 1356 92 981 92 1231 92 pj 22 0 2008 80842 8622710 7219210 72220710 7218210 7210480 36 20 00 9730 36 20 00 1481 92 141942 1356 92 1366 02 1356 92 981 92 1231 92 29 Oct 2008 80842 86 22710 72 19210 72 20710 7218210 7210480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 5 2008 80842 86 22710 72 19210 72 20710 72 18210 72 1480 36 20 00 9730 36 20 00 1481 92 141942 1356 92 1356 92 135692 98192 1231 92 12 2008 80842 86 22710 72 19210 72 20710 7218210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 19 Nov 2008 80842 86 22710 7219210 72 20710 72 18210 7210480 36 20 00 9730 36 20 00 1481 92 141942 1356 92 1356 92 1356 92 981 92 1231 92 26 Nov 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 141942 1356 92 1356 92 1356 92 981 92 1231 9z Select All DeSelect All Note All values are shown in currency GBP Base price type is twin 7 Copy Prices From Wal BN When tour prices are loaded only the checked departure dates will be repriced In this example the tour prices for tours departing on the 8th 15 and 22nd October will not be affected Update Margin ff copy the margin in the results table to t
20. BETA Version 1 Tour Modelling Margin Curve Results Run TPG Total Per Total Cost Total Total FI FI LO LO Adult FI Adult LO Adult FI Adult LO Total Total 4 0 A I Person Overall Calculation Tour Date for the Cost for Costfor Margin Margin Margin Margin Twin Sell Twin Sell Single Sell Single Sell revenue for profit for j profit for Margin Breakdown Tour Adult FI Adult LO Amount Yo Amount Price Price Price departure departure departure 2 Jan 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 769 00 509 00 27548 00 562014 133 81 20 40 View 9 Jan 2008 21927 86 18028 42 3899 44 4630 58 2044 989 56 2024 729 00 439 00 789 00 509 00 27548 00 5620 14 13381 2040 View 16 Jan 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 L 789 00 509 00 27548 00 5620 14 133 81 20 40 View Nights Exchange rate Twin Standard LO Twin Standard Fl Single Standard LO Single Standard Components ___ RS Lo Hotel twin 50 Euros pppn 7 1 4 Hotel single 60 Euros pppn 7 1 4 300 00 Flights 230 GBP pp Regional flight 11 GBP pp Per person costs 444 Marketing 27 GBP total VAT 8 GBP total 8 00 National express 1 5 GBP total Excursion profit 10 GBP total 10 00 10 00 10 00 10 00 517 50 287 50 567 50 337 50 Per tour costs per Tour manager 50 GBP day 8 LO 9 52 9 52 9 52 9 52 Coach 3000 Euros total 1 4 LO 51 02 51
21. File I z Delete Existing File Master Product All Load Existing File 1 v Edit Clone Existing File Product All v Prague Tour File 1 Tour Modelling Margin Curve Results Prices were manual amended therefore the margin Run has also changed Total Total Per Total Cost Total Total FI 40 LO Adult FI Adult LO Adult FI Adult LO otal st 7 revenue Person Over Tour Date forthe Cost for Cost for Margin Margin Margin Margin Twin Sell Twin Sell Single Sell Single Sell f profit for rofit f or profit for Marc Tour Adult FI Adult LO Amount Amount Price Price Price Price departu departure departure 1 4pr 2008 18797 00 14473 69 4323 31 7260 51 1671 04 420 00 200 00 986 84 798 87 27728 55 8931 55 148 86 32 8 Apr 2008 18797 00 14473 69 4323 31 7260 51 1671 04 420 00 200 00 986 84 798 87 27728 55 8931 55 148 86 32 15 Apr 2008 18797 00 14473 69 4323 31 4460 51 5 1171 04 350 00 150 00 986 84 798 87 24428 55 5631 55 93 86 23 22 Apr 2008 18797 00 14473 69 4323 31 3618 51 20 00 1080 84 20 00 328 95 140 98 986 84 798 87 23496 35 4699 35 78 32 20 29 Apr 2008 18797 00 14473 69 4323 31 3618 51 20 00 1080 84 20 00 328 95 140 98 986 84 798 87 23496 35 4699 35 78 32 20 22 Totals 93985 00 126878 35 32893 35 25 Mote All values are shown in currency GBP Update Margin This will copy the margin in the results table to the margin curve
22. Generator TPG Manual 5 2 User Security Switches There are two user security switches related to the TPG 3 hitp testing1 travelink admin asp Microsoft Internet Explorer File Edit View Favorites Tools Help Q Bak x a Search 2 Favorites 2 wj rel Address http 1 jtravelink admin asp iM Go Links gt Snagit Home Booking Search Quote Search New Booking Brochure Request Clients Reports Tools Set Up Support f T ON Soe lt Travelin SDFTWARE FOR TOUR OPERATDRS Click To Return To Index Access Level 1 enabled Connection Test ICP Transaction Stats 1 mille Security Set p gt Administer Remote Scheduler Basic Data Checks Data Dictionary Configure Style Sheet Log File Viewer Report Error Show Logged In Users Documents S WoW Wy dE gt Figure 8 Link to Security Set Up Tour Price Generator Setup Only users with sufficient security level will be able to access the TPG link under Travelink Set Up Tour Price Generator Load Prices The Load Prices button will be disabled for users with insufficient security Copyright Comtec Group Limited 2008 Page 7 Tour Price Generator TPG Manual C COMTEC Goto Users Section Goto Groups Section Admin Hold Client Search View Booking View Cost
23. Person Over Tour Date forthe Cost for Cost for Margin Margin Margin Margin Twin Sell Twin Sell Single Sell Single Sell profit for fit f rofit for Marc Tour Adult FI Adult LO Amount Yo Amount Yo Price Price Price Price departure j H departure departure 1 Apr 2008 18797 00 14473 69 4323 31 3618 42 20 0041080 83 328 95 140 98 986 84 798 87 23496 25 4699 25 78 32 20 8 Apr 2008 18797 00 14473 69 4323 31 3618 42 20 00 1080 53 328 95 140 98 986 84 798 87 23496 25 4699 25 78 32 20 15 Apr 2008 18797 00 14473 69 4323 31 3618 42 20 00 1080 83 328 95 140 98 986 84 798 87 23496 25 4699 25 78 32 20 a PRES 22 Apr 2008 18797 0014473 69 4323 31 3518 42 20 00 080 83 328 95 140 98 986 84 798 87 23496 25 4699 25 78 32 20 29 Apr 2008 18797 00 14473 69 4323 31 3618 42 20 00 41080 83 328 95 140 98 986 84 798 87 23496 25 4699 25 78 32 20 Totals 93985 00 117481 25 23496 25 Note All values are shown in currency GBP Update Margin This will copy the margin in the results table to the margin curve table audi Figure 46 Original Margin Copyright Comtec Group Limited 2008 Page 27 Tour Price Generator TPG Manual Tour Price Generator Microsoft Internet Explorer Ti li k Season All v 4 Country 0 Tour Prague Tour v Tours Setup Add New
24. Tour Tour Manager FI 10 0000 10 0000 Supplier Cost 400 00 GBP Tot Occupancy 40 Per Person 10 00 GBP Supplier Cost 10 00 GBP LO 633 0714 368 0714 Adult COST 633 0714 Child 5 368 0714 Markup Amount 0 Percent 20 Margin Adult 791 3392 Child 460 0892 Rounding 9 Adult Price 799 Child Price 469 TwinLO Cost Type Component Adult Child Comment Accommodation Hotel single LO 0 0000 0 0000 Not selected on Matrix Hilton Hotel twin 02 01 2008 for 7 nights Per Person Based On X Sharing Occupancy 2 UnitCost 700 eur Adult Conditional Supps 0 Adult Accommodation room Lo 250 0000 62 5000 Mandatory Supps 0 Child Conditional Supps 0 Child Mandatory Supps 0 Flights 1 2 2008 LHR BKK 9 0000 0 0000 Not selected on Matrix Flights 2608 BKK LHR 0 0 0000 0 0000 Not selected on Matrix Per Person Excursion profit LO 10 0000 10 0000 Supplier Cost 10 00 GBP LO Per Person Marketing LO 27 0000 27 0000 Supplier Cost227 00 GBP LO Per Person National Express LO 1 5000 1 5000 Supplier Cost 1 50 GBP LO Per Person Regional Flights LO 11 0000 11 0000 Supplier Cost 11 00 GBP LO Per Person VAT LO j8 0000 8 0000 Supplier Cost 8 00 GBP LO Per Tour Airport Rep Lo 12 0000 2 0000 Supplier Cost 80 00 GBP Tot Occupancy 40 Per Person 2 00 GBP Supplier Cost 2 00 GBP LO Per Tour Coach LO 53 5714 53 5714 Supplier Cost 3 000 00 eur Tot Occupancy 40 Per Person 75 00 eur Supplier Cost 75 00 eur LO Per Tou
25. ae Cait Set Child P s et up Chi rices Flight Series Sectors 3 Set up LO FI Prices E d Accommodation Extras Price Components Separately Ff Car Hire Commission Group Select v Cruise Price Type Matrix Prices Documentation v 6 gt o gt s lt s D q i Adult FI Child FI Adult LO Child LO Departure From Departure To Booking From Booking To Currency Search Attributes tandard Standard Standard Standard 1 2007 1 2 2009 1 1900 1 2020 M Delete Figure 35 Adult Child LO FI price types in Tours Set Up E Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator fisveli k Season All Tour Asia Tour Tours Setup cash cit Load Existing File 1 Edit Clone Existing File Asia Tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Run TPG Total Per Total Total Total Total FI FI LO LO Adult FI Child FI Adult LO Child LO Total Total Total Cost x Person Overall Calculation Tour Date Cost for Cost for Cost for Cost for Margin Margin Margin Margin Standard Standard Standard Standard revenue for profit for for the Tour j N profit for Margin Breakdown Adult FI Child FI Adult LO Child LO Amount Amount Sell Price Sell Price Sell Price Sell Price departure departure d 2 eparture 2 Jan 2008 30097 86 24448 57
26. as per components data set up This is only relevant to components flagged in the Price Type Matrix as tour Mandatory and tour Default components Any Optional or Hidden components will not be included Where a price type has an occupancy attributed to it the component cost will be based on that occupancy for that price type E g If price type twin has occupancy 2 then cost will be 2 adults in that room Mixing adults and children in rooms is out of scope of this functionality This occupancy factor is relevant for accomm and car hire but not for flights and extras The local currency costs will be converted to base currency using the exchange rate table so that base currency costs for each component are calculated Copyright Comtec Group Limited 2008 Page 18 COMTEC Tour Price Generator TPG Manual e Tour costs 1 Per Person Tour Costs Simple per person costs will be calculated Also the passenger range function if set up will calculate the per person cost based on the uptake predicted in the modeling section Adult and child values will also be respected where set up The local currency costs will be converted to base currency using the exchange rate table so that base currency costs for each cost are calculated 2 Per Tour Costs Simple per tour costs will be calculated Also the passenger range function if set up will calculate the per tour cost based on the uptake predicted in the modeling section For
27. o 20 Delete 1 Jan 2008 1 Mar 2008 0 0 fzo Delete Margin Calculation use the percentage as total margin rather than markup when generating prices Include Supplements include mandatory conditional supplements in accom cost calculations Booked Date From 1 Jan 1900 Booked Date To 1 Jan 2020 Round Prices by 9 Use 1 10 positive or negative values to round to nearest pound Enter 0 for no rounding Selling Currency GBP Comments Pull departure Dates from Tour Modelling Figure 28 Margin Curve screen completed 5 10 Results It is now be possible to run the calculation to generate prices The Run TPG button will calculate costs based on the Tour Modeling and produce a display of results for each individual tour departure date This function will be used to run a calculation which marks up costs into prices Copyright Comtec Group Limited 2008 Page 17 Tour Price Generator TPG Manual Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Delete Existing File Load Existing File 1 v Edit Clone Existing File tema f Season All Tour Test tour Tours Setup Add New File Traveli Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results eal Click TP G button the system will display the message below Tour Total Cost for Total Cos
28. places on the tour it is expected that 30 passengers will be Adult FI Twin 10 passengers will be Adult LO Twin 1 passenger will be FI Adult FI Single and so on Populate the first row of these fields and then use the Copy button to copy the values down to all other rows Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator wk i retour Tours setup s sn e Load Existing File i Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 I Tour Modelling Margin Curve Results Tour Date Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single mans i G m 1 9 Jan 2008 100 16 Jan 2008 100 23 Jan 2006 100 30 Jan 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 poggogog TOO Microsoft Internet Explorer The occupancy figures will be copied to all date bands Co CON Display Tour Dates v tick this box if you want to use the tour departure dates Passenger Total Control 42 Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Tr velifk Sessor Lal Test tour 2 Tours Setup pelea File Load Existing File 1 x Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Mar
29. results screen will show a column Apparent Air Adult If FI LO and Child prices exist the TPG results screen will also show an Apparent Air Child column If FI and LO prices don t exist these columns will not show Copyright Comtec Group Limited 2008 Page 24 CONTEC Tour Price Generator TPG Manual This will take the price types marked as Base and calculate the difference for adults and children as follows FI adult base price LO adult base price Apparent Air Adult value Season all v of Travelink psum RI Add New File Y Tour Prague Test Tour Tours Setup k Delete Existing File Master Product All _ Load Existing File 1 v Edit Clone Existing File Product All v Prague Test Tour File 1 Tour Modelling Margin Curve Results Adult FI twin Adult LO twin Apparent Air Adult twin Run TPG 1481 92 1356 92 125 Total Total Total Total Total Total FI 2 Adult LO Child Lo Adult FI Child F1 Adult LO Child Lo pparent Load FI Margin 3 Adult FI twin Child FI twin revenue 5 Overall Calculation Tour Date Cost for Cost for Cost for Cost for Cost for Margin Margin Margin b twin Sell twin Sell single Sell single Sell single Sell single Sell profit for Air Adult Child Price Amount Sell Price Sell Pri
30. table iii Figure 47 Updated margin The user is now able to click on the Update Margin button updated margin into the Margin Curve Table which will copy the Tour Price Generator Microsoft Internet Explorer Season Travelink Master Product all Product All w Tours Setup Add New File Delete Existing File v Edit Clone Existing File Tour Prague Tour Load Existing File 1 lt lt lt lt File 1 Prague Tour Tour Modelling Margin Curve Results Run TPG Total Total Per Total Cost Total Total FI FI LO LO Adult FI Adult LO Adult FI Adult LO Total A xs revenue Person Over Tour Date forthe Cost for Cost Margin Margin Margin Margin Twin Sell Twin Sell Single Sell Single Sell profit for ft f profit for Marc Tour Adult FI Adult LO Amount Amount Price Price Price Price departure D departure 1 2008 18797 0014473 69 4323 31 7260 51 Microsoft Internet Explorer 798 87 27728 55 8931 55 148 86 32 8 2008 18797 00 14473 69 4323 31 7260 51 798 87 27728 55 8931 55 148 86 32 n n 15 Apr 2008 18797 00 14473 69 4323 31 4460 51 3 TNE FR di EU ID Cove Sable 79887 2442855 5631 55 93 86 23 22 Apr 2008 18797 0014473 69 4323 31 3618 51 lt
31. the purpose of modeling each per tour cost will be equally divided between the predicted passengers for display in the results section The local currency costs will be converted to base currency using the exchange rate table so that base currency costs for each cost are calculated e Mark ups Once the costs have been calculated the Margin Curve will apply the mark up to the individual tours A different mark up may exist for LO and FI and date bands The Calculation Breakdown View link will show a summary and also detailed breakdown of all costs and calculations of how exactly prices are arrived at The Amount and Percentage fields under Margin Curve screen can be either or both populated and will thus give a calculation of add base currency amount if not populated then adds zero then apply a mark up or margin percentage Prices for all price types set up for that tour will then be generated Using the rounding field when positive the tour prices will round up E g if a 9 is in the rounding field then a tour price of 2341 64 will round up to 2349 00 Using the rounding field when negative the tour prices will round down E g if a 9 is in the rounding field then a tour price of 2341 64 will round down to 2339 00 Where the component and tour cost are attributed to Adult Child FI or LO then the calculation needs to use the correct data E g If a per person tour cost is set to and then the TPG will
32. use that cost for both Adult and Child prices for the FI price type only The same applies for the price which is attributed to each cost and component The results section will be shown in a grid Individual tour departure dates will run down the left axis the column headers will show the following data in the following order left to right Note All values in the results screen will show in the system base currency GBP in this examp Where one Standard price type is used Total Cost for the Tour a component tour costs modeling value Total Costs for Adult a adult component adult tour costs all adult value Margin Amount Total revenue for departure Total Cost for the Tour Copyright Comtec Group Limited 2008 Page 19 COMTEC Tour Price Generator TPG Manual Margin Margin Amount Total Revenue 100 Adult Standard Price Editable Total revenue for departure Tota Cost for the Tour plus Mark up or Margin Total profit for departure Tota revenue for dept Total Cost for the tour Total per person profit for departure Tota profit for dept modeling value Overall Margin Tota profit for departure Total revenue for dept 100 Tour Master Set up Microsoft Internet Explorer Season All Tour Surf Adventure v view Suppressed Tours 20 Recent Tours a Surf Adventure Release 39 BETA Version 1
33. 0 0 0 9 Jan 2008 100 0 p 16 Jan 2008 100 0 p 23 2 2008 100 0 p 30 2 2008 100 0 p 6 Feb 2008 100 p p p 13 Feb 2008 100 p n p 20 2008 100 p p 27 Feb 2008 100 p D p Display Tour Dates tick this box if you want to use the tour departure dates Paccenner Control isn Figure 16 Clone Existing File Copyright Comtec Group Limited 2008 Page 11 Tour Price Generator TPG Manual Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator mane All v Test t Add New File fisvelilk Season Tour Test tour Tours Setup Delete Existing File Load Existing CLONE M Est gt Clone Existing File Test tour File 1 CLONE Release 39 BETA Version 1 cX nu Tour Modelling Margin Curve Results Tour Date Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100 F New Cloned file is displayed Use the Edit link to amend the File name 9 Jan 2008 100 16 Jan 2008 100 23 1 2008 100 30 Jan 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 EIC iK Display Tour Dates v tick this box if you want to use
34. 0 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 252 63 20 00 view 12 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 252 63 20 00 View y 19 Nov 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 91942 101053 58 20210 72 252 63 20 00 View 26 Nov 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 252 63 20 00 View Select All DeSelect All Note All values are shown in currency GBP Base price type is twin Copy Prices From M to M Figure 42 Apparent Air Child The column headers will also include the base price type twin 5 10 3 Copy prices Sometimes tour operators use the base tour price as twin and they pass the cost of having a single room on to the client but do not pass on the savings of having a triple room The copy prices functionality in TPG results screen allows the user to copy all prices from one price type to another price type in this example it would set all triple prices to be the same as twins Copyright Comtec Group Limited 2008 Page 25 Tour Price Generator TPG Manual Trave
35. 00 44964 00 37433 15 353 14 130 00 60 00 83 25 View 29 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 18122 17 71 58 19310 98 98 28 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 339 00 269 00 209 00 209 00 44964 00 37433 15 353 14 130 00 60 00 83 25 View gj S Nov 2008 82397 15 21898 28 21539 90 18998 28 19960 70 1812217 71 58 19310 98 98 28 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 339 00 269 00 209 00 209 00 44964 00 37433 15 35314 13000 60 00 83 25 View 12 2008 82397 15 21898 28 21539 90 18998 28 19960 70 18122 17 71 58 19310 98 98 28 339 00 269 00 209 00 20900 959 00 589 00 900 519 00 339 00 269 00 209 00 209 00 44964 00 37433 15 35344 130 00 60 00 83 25 view 19 2008 8239715 21898 28 21539 90 18998 28 19960 70 18122 17 71 58 19310 98 98 28 339 00 269 00 209 00 209 00 959 00 s89 00 839 00 519 00 339 00 269 00 209 00 209 00 44964 00 37433 15 353 14 130 00 60 00 83 25 View 26 Nov 2008 82397 15 21898 28 21539 90 18998 28 19960 70 18122 17 71 58 19310 98 98 28 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 339 00 269 00 209 00 209 00 44964 00 37433 15 353 14 130 00 60 00 83 25 View Select DeSelect Note All values are shown in currency GBP Base price type is twin Update Margin This will copy the margin in the results table to the margin curve table Load Prices Audit
36. 07 403 07 23322 9 Add 2096 margin 728 84 441 34 791 34 503 84 Selling price round 9 729 00 449 00 799 00 509 00 29160 00 Margin 20 02 21 36 20 77 20 81 20 02 Profit per person 145 93 95 93 165 93 105 93 Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator p son All Ww T Testt M t Add New File Tisvelik Season our i jest our 9 ours Setup Delete Existing File Load Existing File 1 x Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Run TPG Total Per Total Cost Total Total FI FI LO LO Adult FI Adult LO Adult FI Adult LO Total Total Person Overall Calculation Tour Date for the Costfor Costfor Margin Margin Margin Margin Twin Sell Twin Sell Single Sell Single Sell revenue for profit for profit for Margin Breakdown Tour Adult FI Adult LO Amount Amount departure departure departure 2 Jan 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 o 729 00 449 00 509 00 29160 00 5837 14 145 93 20 02 View 9 2008 23322 86 2332286 0 00 5837 14 20 02 0 00 729 00 44900 799 00 509 00 29160 00 583714 145 93 20 02 View 16 Jan 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View Figure 60 Example 1 TPG Results Copyrigh
37. 08 23477 86 19578 42 3899 44 4940 58 20 15 989 56 20 24 789 00 439 00 649 00 499 00 29408 00 5930 14 141 19 20 17 View 9 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 789 00 499 00 2754800 562014 13381 2040 View 16 Jan 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 789 00 499 00 27548 00 5620 14 133 81 20 40 View 23 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 769 00 499 00 27548 00 5620 14 133 81 20 40 View 30 Jan 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 789 00 499 00 27548 00 5620 14 133 81 20 40 View 6 Feb 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 789 00 499 00 27548 00 5620 14 133 81 20 40 View 13 Feb 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 789 00 499 00 2754800 562014 13381 20 40 View 20 Feb 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 72900 439 00 789 00 499 00 2754800 562014 133 81 20 40 View 27 Feb 2008 21927 86 18028 42 3899 44 4630 58 20 44 989 56 20 24 729 00 439 00 789 00 499 00 27548 00 5620 14 133 81 20 40 View Totals 198900 74 __249792 00 50891 26 20 37 Jad Prices Audit Figure 30 TPG Results The calculation principle is Using the pax uptake values in the Tour Modelling section work out Component costs Component costs will be calculated
38. 08 Marketing Lo S j 123456 2 1 27 00 27 00 27 00 Can remove s Delete Flight Series Sectors Py Z 1 06 1 2008 LO v A v 123456 LI 1 0 Delete Accommodation PY Z Ca 1 3 1 2008 National Express LO Al w 123456 1 1 50 1 50 1 50 Delete Extras py P 4 Copy 1 7 0 2008 1 2008 Excursion profit LO AU v 123456 D 1 10 00 10 00 10 00 Remove after Delete Car Hire Co 1 Jan 2008 1 Mar 2008 Coach v 123456 1 0 3000 00 Delete Cruise ye et Gon a 3 Ca 1 Jan 2008 1 2008 Tour Manager LO v 123456 g 8 50 00 400 00 400 00 Delete Price Type Matrix E C a Copy 1 Jan 2008 1 2008 Airport Rep O Lo 1234567 1 00 80 00 Delete Documentation PP 1123456 D Search Attributes b Save Update All Individual Tour Dates Audit Figure 55 of Tour Costs screen set up Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator i fiaveliffk sd Tour Test tour F Tours Setup NN Load Existing File 1 Edit Clone Existing File Test tour File 1 Tour Modelling Margin Curve Results Tour Date Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100 9 Jan 2008 100 0 p 16 2 2008
39. 09 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 60 00 20 36 View 26 Nov 2008 82397 15 21898 28 21539 90 18998 28 19960 70 11127 83 20 39 9939 02 20 33 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 60 00 20 36 View Select All DeSelect All Note All values are shown in currency GBP Base price type is twin Copy Prices From Figure 43 TPG results before copying prices Select the price type you wish to copy from e g twin and the price type you wish to copy to e g triple then click the button Adult Child LO and FI price types will be copied and the copy from and to fields selected will remain on the screen upon saving CTravelink 5 Country All v Add New File L our ragus ost Tours Setup Delete Existing File Master Product Mi Load Existing File 3 x Edit Clone Existing File Product All Prague Test To File 3 Tour Modelling Margin Curve Results Run TPG Total Total Per Total Total Total Total Total FI LO Adult LO Child LO Adult FI Child FI Adult LO Child LO Adult FI Child FI Adult LO Child LO Total Apparent Apparent Load FI Margin LO Margin Adult FI twin Child FI twin R 2 revenue Person Overall Calculation Tour Date Cost for Cost
40. 10 Product M L10 Product Level 5 110 Product L10 Product M L10 Product L10 Product L10 Product Level 9 L10 Product Level 5 L4 Accounts 110 Product L4 Accounts L4 Accounts L4 Accounts iii Li Hidden Li Hidden lt L4 Accounts 1 Tour Price Generator Load Prices Li Hidden v Level 5 Home Booking Search Quote Search New Booking Brochure Request Clients Reports Tools Set Up Support Page 8 Tour Price Generator TPG Manual When the screen is first opened the user will be presented with the following options 5 3 Tour Master Search It is possible to search for a tour master Season and Tour Name Search fields are in the form of drop down menus Selecting a Season will narrow down the list of tours Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Add New File v Aie i Delete Existing File Edit Clone Existing File Load Existing Season Winter 07 v Tour fravelifk Adventure Test Test tour Thailand tour Release 39 BETA Version 1 Figure 10 Tour Master Search 5 4 Add New File The Add New File link allows the user to create a new TPG file for the selected Tour Click on this link and a new field will become available Type the f
41. 100 23 Jan 2008 100 n 30 2 2008 100 6 Feb 2008 100 0 13 2008 100 20 2008 100 p 27 Feb 2008 100 E 0 Display Tour Dates Mt tick this box if you want to use the tour departure dates Passenger Total Control 40 Figure 56 Example 1 TPG Tour Modeling Copyright Comtec Group Limited 2008 Page 33 Tour Price Generator TPG Manual Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Season A x Tour Test tour w Tours Setup File Load Existing File 1 Edit Clone Existing File Test tour File 1 telease 39 BETA Version 1 Tour Modelling Margin Curve Results Departure From Departure FI LO Amount Percentage 1 2an 2008 1 2008 FI 0 Delete 1 Jan 2008 1 2008 Lo 0 20 Delete 1181 El Margin Calculation use the percentage as total margin rather than markup when generating prices Include Supplements include mandatory conditional supplements in accom cost calculations Booked Date From 1 Jan 1900 Booked Date To 1 2 2020 Round Prices by Use 1 10 positive or negative values to round to nearest pound Enter 0 for no rounding Selling Currency GBP M Comments Pull departure Dates from Tour Modelling Figure 57 Example 1
42. 29160 00 5837 14 145 93 20 02 View 6 Feb 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View 13 Feb 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View 20 Feb 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View 27 Feb 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View Totals 209905 74 262440 00 52534 26 20 02 Figure 58 Example 1 TPG Results Copyright Comtec Group Limited 2008 Page 34 TPG Calculatio n Breakdown Tour Price Generator TPG Manual Use Case Scenario One File 1 Jan 2 2008 Individual Tour Date Setup Summary Price COSTS PRICES OCCUPANCIES Adult LO Adult FI Adult Lo Adult FI Adult Lo Adult F1 Single 403 0714 633 0714 509 0000 799 0000 0 0 Twin 353 0714 583 0714 449 0000 729 0000 0 40 Totals Cost Profit margin Adult LO 0 00 0 00 0 00 0 Adult FI 23322 86 29160 00 5837 14 20 02 Child LO 0 00 0 00 0 00 0 Child FI 0 00 0
43. 39 02 20 33 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 60 00 20 36 View 15 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 11127 83 20 39 9939 02 20 33 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 60 00 20 36 View 22 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 11127 83 20 39 9939 02 20 33 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 60 00 20 36 View 2 29 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 11127 83 20 39 9939 02 20 33 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 60 00 20 36 View 5 2008 82397 15 21898 28 21539 90 18998 28 19960 70 11127 83 20 39 9939 02 20 33 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 60 00 20 36 View 7 12 2008 8239715 21898 28 21539 90 18998 28 19960 7011127 83 20 39 9939 02 20 33 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 60 00 20 36 View v 19 Nov 2008 82397 15 21898 28 21539 90 18998 28 19960 70 11127 83 20 39 9939 02 20 33 339 00 269 00 2
44. 4 5 93 0 80 View 23 Jan 2008 29322 86 29322 86 237 14 0 80 739 00 29560 00 237 14 5 93 0 80 View 30 Jan 2008 29322 86 29322 86 237 14 0 80 739 00 29560 00 237 14 5 93 0 80 View 6 Feb 2008 29322 86 29322 86 237 14 0 80 739 00 29560 00 237 14 5 93 0 80 View 13 Feb 2008 29322 86 29322 86 237 14 0 80 739 00 29560 00 237 14 5 93 0 60 View 20 Feb 2008 29322 86 29322 86 237 14 0 80 739 00 29560 00 237 14 5 93 0 80 View 27 Feb 2008 29322 86 29322 86 237 14 0 80 739 00 29560 00 237 14 5 93 0 80 View Totals 265905 74 268040 00 2134 26 0 80 Audit Figure 32 TPG results for Standard Price Types Where LO and FI are used Total Cost for the Tour Total Cost for FI Total Cost for LO Total Cost for FI Total Cost for LO FI Margin Amount Total FI price for the Tour Total FI Cost for the Tour FI Margin FI Margin Amount Total FI price 100 LO Margin Amount Total LO price for the tour Total LO Cost for the Tour LO Margin LO Margin Amount Total LO price 100 FI Price Editable LO Price Editable Total revenue for departure Total Cost for the Tour Mark up or Margin as per Margin Curve set up Total profit for departure Total revenue for dept Total Cost for the tour Copyright Comtec Group Limited 2008 Page 20 COMTEC Tour Price Generator TPG Manual Total per person profit for departure Total profit for dept total of modeling values Overall Margin Total profit for depa
45. 43 728 8393 350 7143 13 Feb 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 20 Feb 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 20 Feb 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 27 Feb 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 27 Feb 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 Figure 52 TPG price audit 6 Use Case Scenarios 6 1 Scenario 1 This is a simple scenario using typical components The tour is modeled on 40 adults all sharing a standard twin room and all taking the international flights However price types for LO and Single are still required Child pricing is not required on this tour The price types set up are thus Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single Copyright Comtec Group Limited 2008 Page 31 Tour Price Generator TPG Manual Tour Master Set up Microsoft Internet Explorer File Edit View Favorites Tools Help ay em i ix 2 Search Se Favorites 57 Se jw 4 3 Address http testingl travelink ComponentSetUpjTours TourSeries TourSeries aspx TMcode 1074 v Edo E mane Season 1 v Tour Test tour view Suppressed Tours 20 Recent Tours Travelink us Test tour Release 39 BETA Version 1 Inventory Price Types Summary Tour Prices Ga Tour Costs 2 Delete EST gre Single i L
46. 730 36 20 04 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View z 19 Nov 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View y 26 Nov 2008 80842 86 22710 7219210 7220710 7218210 7210480 36 20 00 9730 36 20 00 1461 92 1419 42 V 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View Select all DeSelect All Note All values are shown in currency GBP Base price type is tw vj Copy Prices From x to Figure 41 Apparent Air Adult FI child base price LO child base price Apparent Air Child value f a Season all Travelink Add New File Country all M Tour Prague Test Tour Tours Setup Js gt Delete Existing File Master Product all v Load Existing File 1 x Edit Clone Existing File Product all v Prague Test Tour File 1 Tour Modelling Margin Curve Results Child FI twin Child LO twin Apparent Air Child twin Run TPG 1419 42 1356 92 62 50 4 Total Total Total Total Total Total Total FI LO LO Adult LO Child LO Adult FI Child FI Adult LO Child LO Total Load FI Margin jAdult FI twiniChild FI twin revenue
47. Inventory Summar Price Types wy Tour Prices Tour Costs Standard maag O select v C ada Flights I Set up Child Prices O Flight Series Sectors MNA HN Set up LO FI Prices F Extras Price Cornponents Separately L Car Hire Commission Group Select Price Type Matrix Documentation b Prices Search Attributes Sy Adult Departure From Departure To Booking From Booking To Currency Standard Audit 1 2007 1 2 2009 1 1 1900 1 2020 GBP Delete Figure 31 Standard price types in Tours Set Up Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator d 5 all v wl T Add New File fiavelifk iid s EE aS Ree Delete Existing File Load Existing File 1 Edit Clone Existing File Surf Adventure File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Total Cost for the Total Cost for Margin Adult Standard Sell Total revenue for Total profit for Total Per Person profit Overall Calculation Tour Adult Amount Price departure departure for departure Margin Breakdown 2 Jan 2008 31322 86 31322 86 237 14 0 75 789 00 31560 00 237 14 5 93 0 75 View 9 Jan 2008 29322 86 29322 86 237 14 0 80 739 00 29560 00 237 14 5 93 0 80 View 16 Jan 2008 29322 86 29322 86 237 14 0 80 739 00 29560 00 237 1
48. Level 5 Level 5 L10 Product lt Level 5 Level 15 L4 Accounts L20 Guests i L10 Product lt Level 5 L4 Accounts L4 Accounts 14 Accounts Level 5 lt lt e lt lt Level 5 i L4 Accounts Level 5 L10 Product Level 5 Level 5 L1 Hidden 110 Product L10 Product L10 Product L10 Product L10 Product L4 Accounts L4 Accounts Level 5 v L10 Product L10 Product lt L10 Product L10 Product i L10 Product 110 Product Level 5 L10 Product L10 Product D ji L10 Product L10 Product L4 Accounts La Hidden Li Hidden L4 Accounts L4 Accounts lt lt lt lt L1 Hidden Level 5 Li Hidden III L1 Hidden lt L4 Accounts lt Figure 9 Security Set Up Copyright Comtec Group Limited 2008 Booking Search Make Booking Edit Costs in Booking Form Edit Prices in Booking Form View Bonding in Booking Form Remove Flight from Booking Client Add Agent View Agent Update Waitlist Actions Reports SetUp Display Grids Change Flight Contract Details Update Flight Details View Costings in Quote View Accounts Add New Comment Type Amend Comment Sales By
49. Price Generator Season All v Add New File Fe FRS Delete Existing File Load Existing File 1 v Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Run TPG Total Cast Total Cost LO Adult FI AdultLo Total Total profit Total Per Total Cost Adult FI Twin Adult LO Twin Overall Calculation 2444 FI Margin y _ n Tour Date for Adult for Adult Margin Margin Margin 3 Single Sell Single Sell revenue for for Person profit 5 for the Tour Amount Sell Price Sell Price 2 Margin Breakdown FI LO Amount Price Price departure departure for departure 2 Jan 2008 25322 86 25322 86 0 00 6330 72 20 00 0 00 0 791 34 441 34 853 84 503 84 31653 57 6330 72 158 27 20 00 View 9 Jan 2008 23322 86 23322 86 0 00 5830 72 20 00 0 00 0 728 84 441 34 791 34 503 84 29153 57 5830 72 145 77 20 00 View 16 Jan 2008 23322 86 23322 86 0 00 5830 72 20 00 0 00 728 84 441 34 791 34 503 84 29153 57 5830 72 145 77 20 00 View 23 Jan 2008 23322 86 23322 86 0 00 5830 72 20 00 0 00 0 728 84 441 34 791 34 503 84 29153 57 5830 72 145 77 20 00 View 30 Jan 2008 23322 86 23322 86 0 00 Microsoft Internet Explorer 29153 57 5830 72 145 77 20 00 View 6 Feb 2008 23322 86 23322 86 0 00 29153 57 5830 72 145 77 20 00 View 13 Feb 2008 23322 86 23322
50. Price Price Price Price Price Price Price Price departure departure departure 2 Jan 2008 23477 86 1957842 0 00 3899 44 0 0011981 58 37 96 3899 44 789 00 409 00 43900 209 00 849 00 519 00 499 00 319 00 31560 00 8082 14 202 05 25 61 View 9 Jan 2008 21927 86 1802842 0 00 3899 44 0 0011131 58 38 17 3899 44 o 729 00 349 00 439 00 209 00 789 00 459 00 499 00 319 00 29160 00 723214 180 80 24 80 View 16 Jan 2008 21927 86 1802842 0 00 3899 44 0 0011131 58 38 17 3899 44 729 00 349 00 43900 20900 789 00 459 00 499 00 319 00 29160 00 723214 180 80 24 80 View 23 Jan 2008 21927 86 18028 42 0 00 3899 44 0 0011131 58 38 17 3899 44 o 729 00 349 00 439 00 209 00 789 00 459 00 499 00 319 00 29160 00 723214 180 80 24 80 View Figure 38 TPG Results for Adult Child LO FI Twin Single price types All editable fields in the results grid when edited will re calculate results immediately E g changing FI adult twin price will update FI margin and amount and total revenue and total profit and overall margin A breakdown of the calculation is viewable for each line of results 5 10 1 Exclude dates from TPG The column called Load Price in the TPG results screen allows the user to exclude dates so that only chosen tour departures can be repriced The Load Price column shows a check box against each tour departure date and it is defaulted as checked in for all dates There are also options t
51. Reg ligh L i v 1234567 i r1 1 11 1 n Delete Flight Series Sectors Spi a WO LA M 123456 4 1 0 Delet Accommodation a All A 123456 4 a 1 00 Delet Extras 1 Jan 2008 1 Mar 2008 National Express LO Al w 123456 1 1 5 Delet Car Hire Copy 1 2 201 1 M E f Al M A M 123456 1 1 R after Delet Cruise IN O M 123456 1 3000 00 Delete Price Type Matrix Copy 1 3 2008 1 Mar 2008 Tour Manager All ow v 234567 8 50 00 4 00 00 Del 2 RE Copy 1 2 2008 1 2008 Airport Rep Al 1234567 Z 1 80 00 80 00 80 00 Delete Documentation E ko 1123456 Add Search Attributes Save Update All Individual Tour Dates Audit Figure 5 Example Tour Costs For information on how these costs are used please see Section 5 10 Results Copyright Comtec Group Limited 2008 Page 5 Tour Price Generator TPG Manual 5 The Tour Price Generator 5 1 Business rule CON TEC To switch in the TPG in Business Rules under the Tours tab the switch for Advanced Tours must be activated Business Rules Microsoft Internet Explorer gt Accommodation Enable use of tours v gt Accounts Batch File Multi Currency on Tours Booking Form Pop up tour filter before availability search v gt Browser gt Clients Agents Use Commission on Tours NB Th
52. Source Report Change Booking Pricing Type View CSC In NonTransacted Report Allow Document Delete Business Rules Amendments Report Flight Manifest On Request Report Rooming List 1 Supplier Report Tours Manifest Accommodation Bookings Report Daily Bookings Report Extras Revenue Report Component Sales Analysis Accommodation Analysis Report Booking Sales Report PNR Release Agents Exception Travelink Generic Errors Extras Use Accommodation Setup Report Fares Setup Report Resorts To Airports Report Tour Setup Extract Quote Reports Menu Selective Comment Payment Details E mail Audit Trail Change Booked By Sabre Flight Manifest Misc Accommodation Misc Extra Misc Car Hire Alt Room Names Cancel Receipt Manually Change Booking Product Accommodation Manual Load Screen Link Clients Agents To Products Change Agency Group Edit Receipt v dd Coach Setup Override Amend Deposit Security Level Level 5 L1 Hidden L10 Product Level 5 Level 3 L20 Guests L10 Product L4 Accounts 120 Guests L4 Accounts L4 Accounts L10 Product L2 Admin 4 Level 5 Level 5 Li Hidden Level 5 Hidden Li Hidden Level 5 L10 Product L10 Product L10 Product ii L10 Product L10 Product L10 Product Level 5 L4 Accounts i Level 5 L
53. TPG Margin Curve 34 Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator T all v 99 New File SER TRE ll Tours setup Delete Existing File Load Existing File 1 Edit Clone Existing File 39 BETA Version 1 Tour Modelling Margin Curve Results Run TPG Total Per Total Cost Total Total FI FI LO LO Adult FI Adult LO Adult FI Adult LO Total Total i 1 Person Overall Calculation Tour Date forthe Costfor Costfor Margin Margin Margin Margin Twin Sell Twin Sell Single Sell Single Sell revenue for profit for 4 profit for Margin Breakdown Tour Adult FI Adult LO Amount Amount Price Price Price Price departure departure departure 2 Jan 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View 9 Jan 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View 16 Jan 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View 23 Jan 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00 29160 00 5837 14 145 93 20 02 View 30 Jan 2008 23322 86 23322 86 0 00 5837 14 20 02 0 00 0 729 00 449 00 799 00 509 00
54. This accurate basic data is setup via the Advanced Tours interface allowing input of Tour Prices and Costs 4 1 Tours Setup UI separate user manual The Travelink user interface for the loading and management of data for Tours the Advanced Tours UI is a clear simple to use and intuitive UI with abundant functionality There is a separate user manual for the Advanced Tours UI and this should be consulted for understanding the use of it and the full extent of the functionality it provides 4 2 Tour Prices separate user manual This feature is a separate development but it is important to understand it before understanding the TPG Sufficient detail for process understanding is included as follows Travelink has previously held tour prices for just 4 price types Adult Ad Child Ch Flight Inclusive FI and Land Only LO In conjunction with the need for more sophisticated pricing functions on tours and the new Tour Price Generator TPG the following functions have been developed 1 LO and FI prices set up function was enhanced so that tour components accomm extras etc are each flagged as either LO or FI 2 A feature in Tour Prices allows user defined price types to be set up e g single twin luxury etc These price types also need to be attributed to tour components Each tour component needs to have a price type and it needs to be mandatory default optional or hidden Each component can have more than one p
55. Tour Dates TI 1 0 2007 1 2 2009 1 1900 1 0 2020 0 B EB FB Delete 1 19 0 J J L 1 add Note please add a band first and then add the prices to it Not currently able to add prices in the footer Update All Individual Tour Dates Figure 2 Tour Prices Examples Copyright Comtec Group Limited 2008 Page 3 Tour Price Generator TPG Manual Tour Master Set up Microsoft Internet Explorer Inventory summary Tour Prices Tour Costs Flights Accommodation Extras Car Hire Price Type Matrix Season All v Documentation Search Attributes Actions Leaders Individual Tour Dates Figure 3 Example price type matrix Inventory Summary Tour Prices Tour Costs Flights Accommodation Extras Car Hire Price Type Matrix Season All v Documentation Thailand tour Component Quick Select Hilton Hotel single room Hilton Hotel twin room Select Tour Thailand tour FI Twin Mandatory Default optional Hidden Mandatory Default Optional Hidden Mandatory LHR BKK 2 select M Default British Airways BA100 alloc Select O Optional Hidden O Mandatory BKK LHR select British Airways BA101 alloc Select 4 Default optional
56. VY COMTEC Tour Price Generator TPG Manual C Travelink Release 47 E un Y Arjun Microsoft Tour Price Generator TPG Manual Copyright Comtec Group Limited 2008 Tour Price Generator TPG Manual PP c N 5 7 Table of Contents Document Objective Summary of Document Changes 8 C pP S ra etes sed en poU used HU ddnde Br e naerlqe JC 4 1 Tours Setup UI separate user manual 4 2 Tour Prices separate user manual 4 3 Tour Costs separate user manual The Tour Price Generdtol 5 1 BUSINESS Ie ec Rd 5 2 User Security Switches eee 5 3 Tour Master u uuu 5 4 Ada NEW ses ete resserre 5 5 Existing ses 5 6 Delete Existing tou 5 7 Clone EXISEIDO FIG eri nas een nr 5 8 Tour MoOGSllIng euros ques 5 9 Maroli 5 9 1 D3I GS vasmkimuaz hadas Robo 5 9 2 Mark up Margin Calculations 5 9 3 Include Supplements ec n n aca 5 9 4 Booked Dates From 5 9 5 Round PACES eee eue
57. ated Mandatory O Mandatory Default Default n O optional optional Hidden Hidden Mandatory Mandatory Default Default optional optional Hidden Hidden Mandatory Mandatory Default O Default optional optional Hidden Hidden Mandatory Mandatory Default Default Optional O Optional Hidden Hidden Mandatory Mandatory Default Default optional optional Hidden Hidden Mandatory Mandatory Default Default optional optional Hidden Hidden view Suppressed Tours FI Single LO Single Mandatory Mandatory Hidden Hidden Mandatory Hidden _ Mandatory Hidden Optional Optional Hidden Hidden 1 oo COMTEC 20 Recent Tours Release 39 BETA Version 1 Jl IEJ 20 Recent Tours Release 39 BETA Version 1 Component costs can be configured according to the contract terms This rich area of functionality has evolved to satisfy the most demanding of FIT operators in the UK Tour costs in Travelink can be configured to be per person or per tour and can also be aligned to quantities of passengers booked on the tour passenger ranges This is used during the booking process to select correct costs and update previous bookings as more bookings are made The Tour Sales Analysis Report TSAR accurately reports margins on this basis Additiona
58. bands From and To When the Tour Modelling screen is first loaded the default is to display all individual tour dates for the selected Tour Master record This default is controlled via the Display Tour Dates tick box See Figure 21 Display Individual Tour Dates in Tour Modelling When the Display Tour Dates tick box is switched in showing individual tour dates as each date is a tour date it cannot be removed or edited 34 Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator mane b Season v Add New File v e Tour 2 Tours Setup Delete Existing File Load Existing File 1 Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 l Tour Modelling Margin Curve Results Tour Date Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100 9 1 2008 100 16 1 2008 100 23 Jan 2008 100 30 Jan 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 TOGO OO Display Tour Dates v tick this box if you want to use the tour departure dates Passenger Total Control T gt This tick box is switched in by default It populates the Tour Modelling N screen with all individual tour dates as per Tour Setup Switch this out if you wish to enter tour date bands instead Save Please note all values must match th
59. ce 3 3 for p 5 Margin Breakdown the Tour Adult FI Child FI Adult LO Child LO Amount Price Price Price Price Price departure twin departure d y 1 09 2008 80842 86 22710 7219210 7220710 7218210 7210480 36 20 00 9730 36 20 00 11481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View S Oct 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View 15 Oct 2008 80842 8622710 7219210 7220710 7218210 7210480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View 22 Oct 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 04 1481 92 141942 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View y 29 Oct 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 04 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View 5 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 92 919 42 101053 58 20210 72 62 50 20 00 View 12 Nov 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9
60. cific price type then it should only be applied to bookings and TPG calculation for that price type Day of week column 1234567 This is validated when calculating bookings costs and the TPG For example if a cost only occurs on a Tuesday then this cost will only apply if the tour duration includes Tuesday Quantity duration This is a field in the cost line that allows the user to enter quantity or number of days Next to the QTY there is a Unit Amount field for the value of the one quantity and and also an Estimated Amount and Actual Amount fields that show the total for the cost line This could be per person or per tour The Actual Amount field will be the value used in TPG and booking process Tour Master Set up Microsoft Internet Explorer x File Edt Yew Favorites Tools Heb rd q d 4 aj Back x a Search Favorites e y las ad 3 http testingt feravelink Component Setup Tours TourSeries TourSeries aspx TMcode 1074 Go Links Snagit ty Season All Tour Test tour v El view Suppressed Tours 20 Recent Tours Inventory 5 Tour Costs Q ummary Days Tour Prices Departure Departure LO 2 Supplier 4 Unit Estimated Actual Descnption UK of Supplier Range Range Quantity Tour Costs From To PT FI ch Type 4227 Rang Amount m Amount ve Flights Copy 1 2 2008 1
61. de a 5 9 6 Selina Crassi cc ERI DUIS 5 9 7 5 510 aa sean 5 10 1 Exclude dates from TPG rares Mri yk asas D402 sJADDOFODE APT u ee Se RIDE IAO COPY DAS eoim cau Mee P EIE 5 11 Bleue o aea aa 512 LLOSG PICOS u Sio RES Use Case SCAN GI iOS vei s a n At Rl R 6 1 OO Fa EET REDI LE DUE 6 2 SCC LS Appendix 1 Acronyms used in this Document Copyright Comtec Group Limited 2008 COMTEC Page I COMTEC Tour Price Generator TPG Manual Table of Figures Figure 1 High level workflow of Tours 27 2 1 Figure our Prices ExamiplBS DEEREE LEE NU LE E ERPRERMDES 3 Figure 3 Exdmple price MatriX mU UINEEMENKRESENEXERETYT ERE 4 Figure 4 Example price type matrix completed mmn nnn 4 Figure Example TOU COSTS ns O ustus Dee IU qas a wapu a Sak 5 Figure 6 Advanced Tours Business rule sise 6 Figure 7 TPG i Travelin SCUD uuu u saxea semet nne a qawa 6 Figure g Link to Security Set UD uuu usua Ero A a 7 F
62. e occupancy of the pricing type All rows must match the control total Figure 21 Display Individual Tour Dates in Tour Modelling Copyright Comtec Group Limited 2008 Page 13 Tour Price Generator TPG Manual When the Display Tour Dates tick box is switched out date bands can be manually entered When date bands are used rows are editable and the user is able to add and remove rows Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Season All Tour Test tour Tours Setup File Load Existing File 1 w Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Tour Date From Tour Date To Places Adult FI Twin Adult LO Twin t FI Single Adult LO Single 1 2 2018 1 3an 2009 100 0 Delete L Jj I IJ ti IE ij Display Tour Dates Cle tick this box if you want to use the tour departure dates Passenger Total Control Please note all values must match the occupancy of the pricing type All rows must match the control total Figure 22 Use Date Bands in Tour Modeling Under each of the price type results is a blank field large enough to take 2 digits This is repeated for each date band These empty fields are used to enter expected passenger uptake numbers on the tour E g if there are 100
63. es loaded date and time and the user who performed the action If prices are manually edited and saved on the TPG these are also audited with tour dates affected tour name prices changed from and to date and time and user who performed the action all being recorded Copyright Comtec Group Limited 2008 Page 30 Tour Price Generator TPG Manual TPG Audit Microsoft Internet Explorer File Edit View Favorites Tools Help B pu e E gt Lx f Search Se Favorites 257 ju 33 Address http testing1 travelink ComponentSetUp Tours TourPriceGenerator ViewAudit aspx TPGmasterID 177 v Go Links gt snagit TPG Audit Use Case Scenario One File 1 Prices were loaded to the individual tours at the following times 18 01 2008 11 32 48 Administrator Tour Date Type Currency AdultLO ChildLO AdultFI ChildFI 02 Jan 2008 Twin GBP 441 3393 206 9643 791 3393 413 2143 02 Jan 2008 Single GBP 503 8393 316 3393 853 8393 522 5893 09 Jan 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 09 Jan 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 16 Jan 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 16 Jan 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 23 Jan 2008 Twin GBP 441 3393 206 9643 728 8393 350 7143 23 Jan 2008 Single GBP 503 8393 316 3393 791 3393 460 0893 30 Jan 2008 Twin GBP 441 3393 206 9643 728 8393
64. final accruals e Excursion profit This is a flat negative cost which is allocated to all passengers thus LO used to predict a profit on optional extras on the tour and thus build it into the TPG function this will be removed from tour set up after generating tour prices as it is not a valid accrual the actual accrual will be determined on each booking as extras are booked Tour manager coach and airport rep These are per tour costs for all passengers LO and FI the calculation in Figure 55 Example of Tour Costs screen set up shows that these are divided equally between the passengers modeled The accrual will be later held at tour level for bookings finance management Tour Master Set up Microsoft Internet Explorer File Edt View Favorites Tools a AG x Favorites 29 3 a Lua Address http Jtestingt ftravelink Component SetUp Tours TourSeries TourSeries aspx TMcode 1074 v Be Links p Tra Season Tour est tour ET View Suppressed Tours Inventory Tour Cost Summary v y Days Pa e Tour Prices Departure Departure PP LO AD Price Supplier Pax Estimated Descript u of Suppl Range Range antity Tour Costs From To PT FI ch Type Currency Ranges Amount Amount Amount Week Lower pper Flights 1 Jan 2008 1 2008 Regional Flights E 0 jal A 1123456 1 11 00 11 00 11 00 Remove after Delete 1 Jan 2008 1 20
65. for Cost for Cost for Cost for Margin Margin twin Sell twin Sell single Sell single Sell single Sell single Sell triple Sell triple Sell triple Sell triple Sell profit for 3 Air Adult Air Child Price Amount Amount SellPrice Sell Price for profit for Margin Breakdown the Tour Adult FI Child FI Adult LO Child LO departure twin twin departure departure 1 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 18122 17 71 58 19310 98 98 28 339 00 269 00 209 00 209 00 959 00 589 00 839 00 s19 00 339 00 269 00 209 00 209 00 44964 00 37433 15 35314 130 00 60 00 83 25 View 8 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 18122 17 71 58 19310 98 98 28 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 339 00 269 00 209 00 209 00 44964 00 37433 15 353 14 130 00 60 00 83 25 View 15 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 1812217 71 58 19310 98 98 28 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 339 00 269 00 209 00 209 00 44964 00 37433 15 353 14 130 00 60 00 83 25 View 22 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 18122 17 71 58 19310 98 98 28 339 00 26900 209 00 209 00 959 00 569 00 839 00 519 00 339 00 269 00 209 00 209
66. gin Curve Results Tour Date Places Adult FI Twin Adult LO Twin 2 Jan 2008 100 gt a ult I Single Adult LO Single e p EM 7 7 w 7 9 Jan 2008 100 16 1 2008 100 23 Jan 2008 100 30 2 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 eo co Co co lt gt Display Tour Dates tick this box if you want to use the tour departure dates Passenger Total Control 42 Figure 23 Copy button in Tour Modeling Copyright Comtec Group Limited 2008 Page 14 L COMTEC Tour Price Generator TPG Manual Data validation operates on these fields Numbers entered need to match against set E g If a twin price type has been assigned an occupancy of 2 then only multiples of 2 may be entered in that field Where occupancy 1 then any number if occupancy 3 then only multiples of 3 and so on If validation rejects a number then the system will display a message stating the occupancy amount and numbers allowed 23 Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator k 8 Taur Tours Setup DRE LUI File Load Existing File 1 Edit Clone Existing File Test tour Fi
67. he margin curve table Figure 39 Load Price check box in TPG results When tour prices are loaded only checked departure dates will be repriced The audit screen will only show those departures that have been updated TPG Audit Prague Test Tour File 1 Prices were loaded to the individual tours at the following times The audit screen confirms that prices were only loaded for tour departure dates that were previously selected in the Load Price column 30 09 2008 10 02 39 2 Currency ChildLo AdultFI Child FI 01 2008 twin SBP 1356 9198 1356 9198 1481 9198 1419 4198 01 2009 single 1231 9198 819 4198 1356 9198 1981 9198 28 oct 2008 Itwin SBP 1356 9198 1356 9198 1481 9198 1419 4198 28 oct 2008 single SBP 1231 9198 219 4198 1356 9198 281 9188 05 2008 twin SBP 1356 9198 1356 9198 1481 9198 1419 4198 05 2008 single GBP 1231 9198 219 4198 1356 9198 081 9198 12 2009 twin GBF 1356 9198 1356 9196 1461 9198 1419 4198 12 2009 single SBP 1231 9198 219 4198 1356 9198 281 9188 19 2006 twin SBP 1356 9198 1356 9198 1481 9198 1419 4198 19 2008 single GBP 1231 9198 219 4198 1356 9198 981 9198 26 2008 twin SBP 1356 9198 1356 9198 1481 9198 1419 4198 26 2009 single GBF 1231 9198 819 4198 1356 9198 351 9196 Figure 40 TPG Audit screen exclude dates 5 10 2 Apparent Air Where FI and LO prices exist the TPG
68. ice types are set up more price columns will display Total Cost for the Tour Total Cost for Adult FI Total Cost for Child FI Total Cost for Adult LO Total Cost for Child LO FI Margin Amount FI price for the Tour Total FI Cost for the Tour FI Margin FI Margin Amount Total FI price 100 LO Margin Amount Total LO price for the tour Total LO Cost for the Tour LO Margin LO Margin Amount Total LO price 100 Adult FI Twin Price Editable Child FI Twin Price Editable Adult LO Twin Price Editable Child LO Twin Price Editable Copyright Comtec Group Limited 2008 Page 22 COMTEC Tour Price Generator TPG Manual Adult FI Single Price Editable Child FI Single Price Editable Adult LO Single Price Editable Child LO Single Price Editable Total revenue for departure Total Cost for the Tour Mark up or Margin as per Margin Curve set up Total profit for departure Total revenue for dept Total Cost for the tour Total per person profit for departure Total profit for dept total of modeling values Overall Margin Total profit for departure Total revenue for dept 100 Tour Master Set up Microsoft Internet Explorer aAA L smne Season All v Tour Testtour _ O view Suppressed Tours 20 Recent Tours Travelink Test tour Release 39 BETA Version 1 Inventory Price Types Summary Tour Prices Base TA Type Occupancy Tou
69. igure 9 Security Set ANAR 8 Figure 10 Tour Master imi en E 9 Figure NON aan 9 Figure 12 Loa ECS CAES a a ae TT 9 Figure 13 Tour Pile Name u esse 10 Figure 14 Delete Existing en ER UIS 10 Figure 15 Delete Existing file warning message 11 Figure 16 Clone Existing k uya seen ss menti ele sinus 11 Figure 17 Clone Existing File Edit the File 1 1 12 Foure TPO D 12 Figure 19 Price types 13 Figure 20 Price types Tour 2 2 4 2 2 4 13 Figure 21 Display Individual Tour Dates in Tour 0 0 13 Figure 22 Use Date Bands in Tour Modeling 14 Figure 23 Copy button in Tour Modeling ss 14 Figure 24 Occupancy validation message 2 2 2 2 2 0202 2 15 Figure 25 Passenger Total CONTO uu uuu etui sens a siemens 15 Figure 26 Passenger Total Control Warning
70. ile name into it and click Save 2 Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator lt 4 damen 4 Season All 3 Traveli k New File Name File i Save Cancel Release 39 BETA Version 1 Type the name of the file here and hit Save Figure 11 Add New File 5 5 Load Existing File Any files that were previously saved will appear in the Load Existing dropdown 23 Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Jaane S All v T Test t SE Tours Set Add New File cason ni Bis Delete Existing File Load Existing Select Edit Clone Existing File Release 39 BETA Version 1 Figure 12 Load Existing File When the Tour Master and the File is selected the Tour name and the file name will then be clearly displayed on the screen so that it is obvious which tour is being price modeled Copyright Comtec Group Limited 2008 Page 9 LCOMTEC Tour Price Generator TPG Manual Tour Price Generator BETA VERSION Microsoft Internet Explorer q n Tour Price Generator all v Add New File fsvelifk Season Tour Test tour Tours Setup Delete Existing File Load Existing File 1 Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results
71. is will override any commission set up against the individual Agent on Tour Bookings ia Dynamic p tasse Use Tour Date as the departure date for tour bookings gt Extras Medical Certificate Age 70 gt General Products Flight Contracts Against Tours 9 nable individual tour comments pop up during tour booking gt R gional Enable individual t t d tour book gt TMT Tours Car hire comments pop up when booking ow pricing tours by componen gt Transport All t b Display Accom DB Comments On Tours Update Close Tour Date Banded Comments C HM AN displayed on tours Show Tour Flags menu and enable in searches v Allow Passenger Ranges for Costs on Tours Shaw Book Option and Waitlist buttons in tours booking process Advanced Tours v Default Margin Calculation in TPG margin curve v Default Set up LO FI Prices on Tour Setup Default Set up Child Prices on Tour Setup Figure 6 Advanced Tours Business rule A link to the TPG screen will appear in the general Travelink Set up under the Commercial column Setup Microsoft Internet Explorer File Edit View Favorites Tools Help Back 2 ix 2 Search Favorites e 5 jw Y a 3 Address http f testing1 travelink Setup DirectoryListing asp Select M Set Up gt Import Accommodation Prices gt Counties gt insurance Countries gt Pac
72. kage Setup gt Credit Card Details gt gt Tour Combinations gt Flight Contract Types gt gt Tours Setup gt Ground Handlers gt gt Tours Setup Advanced gt ICP XML Accounts gt gt Transfers gt Job Titles gt gt Multiple Products gt Languages gt Home Booking Search Quote Search New Booking Brochure Request Clients Components u ees 211 ir ROC eee E Configuration Commercial gt Accommodation Availability gt Accommodation Types gt Amadeus gt Agency Groups gt Accommodation Master gt Airline gt Bulletin Board gt Agency Regions gt Accommodation gt Airports gt Business Rules Setup gt Cancellation Codes gt Car Hire Setup gt Bank Accourits gt Currency Conversion Rates gt Commission Groups gt Coach Setup gt Car Types gt Currency Exchange Rate gt Distribution Channels gt Extras gt Categories gt Email Setup gt Master Agency Groups gt Flight Series gt Comment Type Setup gt Extract Rules Suppliers gt Flight Setup gt Company Setup Flight Manager Insurance Policy Versions Invoice Notes Itinerary Notes Link Users To Products New Quote Popup Booking Popup New Option Popup Package Adjustments Figure 7 TPG in Travelink Setup Copyright Comtec Group Limited 2008 ar Snagit ps Reports Tools Set Up support Maintenance Data Checks gt Security UserGroup Setup Page 6 M CONTEC Tour Price
73. l Delete 1 a Flights O Select __ _ B Add Flight Series Sectors _ m Set up Child Prices Accommodation eue Set up LO FI Prices v 4 Car Hire Price Components Separately g Cruise Commission Group Select M Price Type Matrix Documentation Y Prices Search Attributes m Adult FI Adult LO Adult FI AdultLo N Departure From Departure To Booking From Booking To Currency Twin Twin Single Single 1 2 2007 1 2009 1 1900 1 2020 GBP Delete Actions lI mnoo ee I D LL add Leaders Individual Tour Dates Figure 53 Example price type set up The components used on the tour are OB and IB flights Twin and Single rooms These are mandatory for the relevant price type Tour Master Set up Microsoft Internet Explorer File Edit View Favorites Tools Help z gt i GO B Q Back lt 2 f D Search Se Favorites 27 iw ing e X Address http jtestingiJtravelink ComponentSetUp Tours TourSeries TourSeries aspx TMcode 1074 Links SnagIt J Tour Test tour view Suppressed Tours 20 Recent Tours Travelink Test tour Release 39 BETA Version 1 Inventory Surnmary Component Quick Select FI Twin LO Twin Validated Select M Hidden Hidden 9 Mandatory Mandatory Taur Prices EUR Select Ml Mandatory Mandat
74. l data is required on each cost line which will be used by the TPG when price modeling The following high level details relate to Tour Costs The full user manual is separate but these specific items relate to the TPG calculation and are thus detailed in this document See Figure 5 Example Tour Costs A field for the selection of LO FI A field must be populated with LO or FI If a cost is LO it will always apply to both LO and FI If it is FI it will only apply to FI Each cost line defaults to LO The concept is that an FI booking will take both the land and flight elements whereas the LO booking just Copyright Comtec Group Limited 2008 Page 4 Tour Price Generator TPG Manual takes the Land elements This cost validation will work for both booking costs and the Tour Price Generator field to select Adult or Child when per person true If per tour cost flag is selected this field is greyed out If per person flag is selected then this field must default to Pax It may be changed to Adult or Child The booking cost function and the TPG need to use the correct cost relevant to adults children or all pax A field for pricing type The user defined pricing type is also a field on each cost line The field is set to all by default but it will contain the list of pricing types as set up in Tour Prices against the tour master e g single twin etc So that if a cost relates to a spe
75. le 1 Tour Modelling Margin Curve Results Tour Date epa FI Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100 9 Jan 2008 100 16 1 2008 100 23 1 2008 100 30 Jan 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 00009000700 c o tick this Display Tour Dates Passenger Total Control Please note all values must match the occupancy of the pricing type All rows must match the control total Figure 24 Occupancy validation message There is also a Passenger Total Control feature on this screen which will ensure that the total number of passengers required for modeling is correct on each departure date see Figure 25 Passenger Total Control gt Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator n s Mo o TE Tes Au E Tours Setup Do Es sta File Load Existing File 1 w Edit Clone Existing File Test tour File 1 Version 1 Tour Modelling Margin Curve Results Tour Date Places Adult FI Twin Adult LO Twin Adult FI Single Adult LO Single 2 Jan 2008 100 9 Jan 2008 100 16 Jan 2008 100 23 1 2008 100 30 Jan 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 e Ele fe ollollolilsilsilsilslilslls Co oo eo Co Co tick this box if you wan
76. link Season All Country All v T TestT al Ti Add New File our rague Test Tour ours Setup Delete Existing File Master Product All v Load Existing File 3 w Edit Clone Existing File Product All v Prague Test File 3 Tour Modelling Margin Curve Results Run TPG Total Total Per Total Total Total Total Total FI Lo Adult LO Child Lo Adult FI Child FI Adult LO Child Lo Adult FI Child FI Adult LO Child Lo Total Apparent Apparent Load FI Margin y Adult FI twin Child FI twin revenue Overall Calculation Tour Date Cost for Cost for Cost for Cost for Cost for Margin Margin Margin twin Sell twin Sell single Sell single Sell single Sell single Sell triple Sell triple Sell triple Sell triple Sell prafit for Air Adult Air Child Price Amount Sell Price Sell Price 5 4 4 for profit for Margin Breakdown the Tour Adult FI Child FI Adult LO Child LO Amount Price Price Price Price Price Price Price Price departure twin twin departure departure 1 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 11127 83 20 39 9939 02 20 33 339 00 269 00 209 00 209 00 959 00 589 00 839 00 519 00 1619 00 2239 00 1489 00 2179 00 103464 00 21066 85 198 74 130 00 50 00 20 36 View 8 Oct 2008 82397 15 21898 28 21539 90 18998 28 19960 70 11127 83 20 39 99
77. lone Existing File Test tour File 1 Tour Modelling Margin Curve Results Departure From Departure Type FI LO Amount Percentage Lo o fo Margin Calculation use the percentage as total margin rather than markup when generating prices Include Supplements include mandatory conditional supplements in accom cost calculations Booked Date Fram 14 Jan 1900 Either type Date Bands in manually or use the Get ina E 1 1an 2020 Dates button to pull Dates from the Tour Modelling Round Prices by 0 Use 1 10 positive or negative values to round to nearest pound Enter 0 for no rounding Selling Currency GBP v Comments Pull departure Dates from Tour Modelling Figure 27 Departure Dates in Margin Curve Each date band will need to be listed twice once for LO and once for FI Each date band also allows the user to enter Amount and Percentage 5 9 2 Mark up or Margin Calculations The figure entered under the Percentage field will be the mark up calculation unless the user ticks the Margin Calculation tick box underneath the grid If the Margin Calculation tick box is switched in the Percentage field will use margin percentage calculation instead of markup 59 3 Include Supplements When this is ticked the system will also include mandatory and conditional supplements in the accommodation cost calculation 5 9 4 Booked Dates From To
78. ng and tour dates mapped out for the next season This is not a Travelink software feature but is usually performed on paper and Excel 2 Contracts and allocations Flight and ground allocations are loaded into Travelink See separate user manual 3 Tour Set Up Travelink Tours are set up with components costs dates and rules See separate user manual 4 TPG price modeling Passenger predictions and margin curves are loaded and tweaked for modeling This is the TPG functionality featured in this user manual 5 TPG price loading Finalized prices are loaded onto the tours This is the TPG functionality featured in this user manual 6 Sell tours Everything is ready for multi channel selling Copyright Comtec Group Limited 2008 Page 1 COMTEC Tour Price Generator TPG Manual The above process is a typical route to market for many tour operators It is common for tour operators to use disparate systems or even Excel to manage the costing and price modeling after which the reservations system is often manually loaded The key aim of the TPG is to drive accuracy and efficiency through loading and modeling in one system Travelink allows contracts and costs to be loaded and then used for selling purposes the TPG functionality provides an area of price modeling Note The TPG UI recommended screen resolution is 1152 x 864 4 Dependencies The TPG relies on accurate data to be loaded into Travelink in the first instance
79. o select all or deselect all Copyright Comtec Group Limited 2008 Page 23 CON TEC Tour Price Generator TPG Manual Tour Price Generator Microsoft Internet Explorer E 4 Season All 2 Travel 1 nk m 771 3 Add New File Country All v Tour Prague Test Tour Tours Setup Delete Existing File Master Product all gt Load Existing File 1 E Edit Clone Existing File Product all v Prague Test Tour File 1 Tour Modelling Margin Curve Results Run TPG Total Total Total Total Total FI LO LO Adult LO Child LO Adult FI Child FI Adult LO Margin i _ Adult FI twin Child FI twin Tour Date Cost for Cost for Cost for Cost for Cost for Margin Margin Margin Ses twin Sell twin Sell single Sell single Sell single Sel moun the Tour Adult FI Child FI Adult LO Child LO Amount 95 Price Price Price Price Price 1 Oct 2008 80842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981 92 1231 9z pj 8 9ct2008 60842 86 22710 72 19210 72 20710 72 18210 72 10480 36 20 00 9730 36 20 00 1481 92 1419 42 1356 92 1356 92 1356 92 981
80. ory Hidden 9 Hidden OOE O RER ways BA100 alloc Select 4 Mandatory Hidden Mandatory midden Flights ortish Airways 101 alloc Select v Mandatory Hidden Mandatory Hidden Flight Series Sectors Accommodation Extras Update All Individual Tour Dates Car Hire Cruise Price Type Matrix Figure 54 Example of Price Type Matrix The costs are set up in the components The hotel costs are 50 Euros per person per night based on 2 adults sharing for a twin room 60 Euros per person per night for a single room The flights are 230 Pounds per person on the OB flight and zero Pounds on the IB flight Tour costs are set up to cover e Regional flights This is a flat cost which is allocated to all passengers thus LO for TPG modeling this will be removed from tour set up after generating tour prices as it is nota valid accrual the actual accrual will be determined on each booking as regional flights are booked e Marketing and VAT These are flat costs which is allocated to all passengers thus LO for TPG modeling this may or may not be removed from the tour set up depending on Copyright Comtec Group Limited 2008 Page 32 CONTEC Tour Price Generator TPG Manual margin analysis requirements it is likely that this cost should not go to the general ledger e National Express This is a flat cost which is allocated to all passengers thus LO for TPG modeling and
81. ost mm Y LO Adult FI AdultLO Total profit Total Per Total Cost FI Margin Margin Total revenue Overall Calculation Tour Date for Adult for Adult Margin Margin Standard Sell Standard Sell for Person profit forthe Tour Amount Amount for departure Margin Breakdown FI LO Price departure for departure 2 Jan 2008 28197 86 24798 28 339957 6199 57 20 00 849 89 20 00 774 95 424 95 35247 32 7049 46 140 99 20 00 View 9 2008 26197 86 22798 28 3399 57 5699 57 20 00 849 89 20 00 712 45 424 95 32747 32 6549 46 130 99 20 00 View 16 Jan 2008 26197 86 22798 28 3399 57 5699 57 20 00 849 89 20 00 712 45 424 95 32747 32 6549 46 130 99 20 00 View 23 Jan 2008 26197 86 22798 28 3399 57 5699 57 20 00 849 89 20 00 712 45 424 95 32747 32 6549 46 130 99 20 00 View 30 Jan 2008 26197 86 22798 28 3399 57 5699 57 20 00 849 89 20 00 712 45 424 95 32747 32 6549 46 130 99 20 00 View 6 Feb 2008 26197 86 22798 28 3399 57 5699 57 20 00 849 89 20 00 712 45 424 95 32747 32 6549 46 130 99 20 00 View 13 Feb 2008 26197 86 22798 28 3399 57 5699 57 20 00 849 89 20 00 712 45 424 95 32747 32 6549 46 130 99 20 00 View 20 Feb 2008 26197 86 22798 28 3399 57 5699 57 20 00 849 89 20 00 712 45 424 95 32747 32 6549 46 130 99 20 00 View 27 Feb 2008 26197 86 22798 28 3399 57 5699 57 20 00 849 89 20 00 712 45 424 95 32747 32 6549 46 130 99 20 00 View Totals 237780 74 297225 88 59445 14 20 00 si SEL Hes
82. qaqupuqakakakusqusasqhassqkuskkaskauma 34 Figure 59 Example 1 TPG Calculation Breakdown 35 Figure 60 Example 1 TPG 36 Figure 61 Example 2 TPG Tour Modeling 37 Figure 62 Example 2 TPG Margin Curve 2 22 2 2 2 1 37 Figure 63 Example 2 TPG RESUS nas a cn Un repr ERES 38 Copyright Comtec Group Limited 2008 Page III COMTEC Tour Price Generator TPG Manual 1 Document Objective This manual is designed to introduce the functionality and features of the Tour Price Generator TPG within the Advanced Tours section of Travelink 2 Summary of Document Changes Load Changed Description of Changes b 1 28 03 08 New section added 5 11 Update Margin 2 30 09 08 KM Version New sections added 5 10 1 Exclude dates from TPG 5 10 3 Copy prices 08 12 08 JAA Version Manual rewrite 47 3 Overview This section describes the main functions that constitute the Tour price Generator TPG This document assumes at least some working knowledge of the tours industry pricing model and the Travelink product Contracts Figure 1 High level workflow of Tours modeling 5 TPG Price Loading 1 Tour Planning Brainstormi
83. r 2008 15 Apr 2008 Lo 0 o Delete 22 Apr 2008 22 2008 lo 12000 0 Delete 22 2008 22 2008 Lo 0 20 00 Delete 29 Apr 2008 29 2008 Fr 0 20 00 Delete 29 Apr 2008 29 2008 Lo 0 2000 0 Delete 1 8 0 Margin Calculation use the percentage as total margin rather than markup when generating prices Include Supplements include mandatory conditional supplements in accom cost calculations Booked Date From 14 Jan 1900 Booked Date To 1 Jan 2020 Round Prices by Use 1 10 positive or negative values to round to nearest pound Enter 0 for no rounding Figure 49 Updated Margin Curve 5 12 Load Prices The Load Prices button will load the resulting prices into the individual tours see Figure 51 Prices loaded against the Individual Tour Date Loading a second time will overwrite existing prices Note Prices will not show in the Tour Master screen prices are against individual tours not the tour master The Load prices button has its own user security level see Section 5 2 A prompt will warn the user that existing prices will be overwritten The system will also display a message when price loading is completed Copyright Comtec Group Limited 2008 Page 29 Tour Price Generator TPG Manual Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour
84. r Costs E v E Delete D v E Delete Flights E select v Ll Add Flight Series Sectors i Set up Child Prices 4 Accommodation Extras Set up LO FI Prices d Car Hire Price Components Separately Cruise Commission Group Select Price Type Matrix Documentation Y Prices Search Attributes P Adult FI Child FI Adult LO Child LO Adult FI Child FI Adult LO Child LO Departure From Departure To Booking From Booking To Currency 2 Twin Twin Twin Twin Single Single Single Single a a a a A a Figure 37 Adult Child LO FI Twin Single price types Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Tour Fr D TASSE Delete Load Existing File 1 Edit Clone Existing File Test tour File 1 Tour Modelling Margin Curve Results Run TPG j Total Total Per Total Cost Total Total Total Total FI FI LO LO Adult FI Child FI Adult LO Child LO Adult FI Child FI Adult LO Child Lo Total 2 2 2 2 2 3 revenue Person Overall Calculation Tour Date for the Cost for Cost for Cost for Costfor Margin Margin Margin Margin Twin Sell Twin Sell Twin Sell Twin Sell Single Sell Single Sell Single Sell Single Sell profit far j j t for profit for Margin Breakdown Tour Adult FI Child FI Adult LO Child LO Amount Amount
85. r Tour Manager LO 10 0000 10 0000 Supplier Cost 400 00 GBP Tot 40 Per Person 10 00 GBP Supplier Cost 10 00 GBP LO LO 353 0714 165 5714 Adult COST 353 0714 Child COST 165 5714 Markup Amount 0 Percent 20 Margin Adult Price 441 3392 Child 206 9642 Rounding 9 Adult Price 449 Child Price 209 TwinF1 Cost Type Component Adult Child Comment Accommodation Hotel single Er 6 0000 0 0000 Not selected on Matrix Hilton Hotel twin 02 01 2008 for 7 nights Per Person Based On Sharing Occupancy 2 UnitCost 700 eur Adult Conditional Supps 0 Adult Accommodation room FI 250 0000 62 5000 Mandatory Supps 0 Child Conditional Supps 0 Child Mandatory Supps 0 Flights 1 2 2008 LHR BKK 230 0000 115 0000 Contract Type alloc Adult 230 0000GBP Child 115 0000GBP Adult Supps 0 0000 Child Supps 0 0000 Flights 8 2008 BKK LHR 0 0000 0 0000 Contract Type alloc Adult 0 0000GBP Child 0 0000GBP Adult Supps 0 0000 Child Supps 0 0000 Per Person Excursion profit FI 10 0000 10 0000 Supplier Cost 10 00 GBP LO Per Person Marketing FI 27 0000 27 0000 Supplier Cost 27 00 GBP LO Per Person National Express FI 1 5000 1 5000 Supplier Cost 1 50 GBP LO Per Person Regional Flights FI 11 0000 11 0000 Supplier Cost 11 00 GBP LO Per Person VAT FI 8 0000 8 0000 Supplier Cost 8 00 GBP LO Per Tour Airport Rep FI 2 0000 2 0000 Supplier Cost 80 00 GBP Tot Occupancy 40 Per Person 2 00 GBP Supplier Cos
86. rice type in this way so for example if a tour has a luxury room component the price type luxury could be default but the price type twin could be optional but no single price type would be attached to it When hidden it means the component is not available to that price type See Figure 4 Example price type matrix completed Each price type needs to have an occupancy attributed to it e g single 1 twin 2 luxury 2 etc This will be used when price modeling in the TPG One of the price types must be flagged as base This is used in the tour search results screen The price types are tour master specific they will populate each individual tour when loaded or modified Copyright Comtec Group Limited 2008 Page 2 Tour Price Generator TPG Manual 3 Set up LO FI Prices and Set up Child prices switches are selectable Selecting these price types will populate the prices grid If none are selected then there will be just one price type called Adult Standard A new business rule allows default for LO FI and Child Prices in each new tour Tour Master Set up Microsoft Internet Explorer A Season All v Tour Test tour view Suppressed Tours 20 Recent Tours Travelink Test tour Release 39 BETA Version 1 Inventory Price Types Summary v Tour Prices Base Type Occupancy Tour Costs Standard Delete M
87. rture Total revenue for dept 100 E Tour Master Set up Microsoft Internet Explorer g Ta i season an Tour Thailand Adventure view Suppressed Tours 20 Recent Tours fivelifk Thailand Adventure Release 39 BETA Version 1 Inventory Summary Price Types Tour Prices Base Occupancy Tour Costs Standard Delete FI Select add Flights Set up Child Prices O Flight Series Sectors Accommodation Set up LO FI Prices a Extras Price Components Separately Car Hire Commission Group Select v Cruise Price Type Matrix Le Prices Documentation Y Adult FI Adult LO Departure From Departure To Booking From Booking To Currency Search Attributes Y tandard Standard 1 2007 Audit ms Actions Leaders 1 2009 1 2 1900 1 3 2020 GBP wj Delete i Add i 3an 1900 i 3an 2020 GBP M Individual Tour Dates Figure 33 FI price types in Tours Set Up Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator aee Season All Tour Thailand Adventure 1 Tours Setup Add New File Traveli k a Delete Existing File Load Existing File 1 Edit Clone Existing File Thailand Adventure File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Run TPG Total Cost Total C
88. s Audit Figure 34 TPG Results for LO FI price types Where Adult and Child and LO and FI price types are used Total Cost for the Tour Total Cost for Adt FI Child FI Adult LO Child LO Total Cost for Adult FI Total Cost for Child FI Total Cost for Adult LO Total Cost for Child LO FI Margin Amount Total FI price for the Tour Total FI Cost for the Tour FI Margin FI Margin Amount Total FI price 100 LO Margin Amount Total LO price for the tour Total LO Cost for the Tour LO Margin LO Margin Amount Total LO price 100 Adult FI Price Editable Child FI Price Editable Adult LO Price Editable Copyright Comtec Group Limited 2008 Page 21 COMTEC Tour Price Generator TPG Manual Child LO Price Editable Total revenue for departure Total Cost for the Tour Mark up or Margin as per Margin Curve set up Total profit for departure Total revenue for dept Total Cost for the tour Total per person profit for departure Total profit for dept total of modeling values Overall Margin Total profit for departure Total revenue for dept 100 E Tour Master Set up Microsoft Internet Explorer Jemne d Season Tour Asia Tour view Suppressed Tours 20 Recent Tours Travelink oe Asia Tour Release 39 BETA Version 1 Inventory Price Types Summary v Tour Prices Base Type Occupancy Tour Costs Standard v Delete gt ss
89. s in Booking Form View Prices in Booking Form Change Client on Confirmed Bookings Client View Client Update Agent Add Option Expiry Crystal Batch File Marketing Suppliers SetUp Change Flight Contract Allocations Run magic wand on flights Edit Costings in Quote Hide costs and margins in costing screen in quote Modify Availability Delete Comment Batch Modify accommodation availability Change flight Schedules Override Change Over Day Amend Manual Entry history items Sales Analysis Report Security Users Car Hire Manifest Extras Manifest Resort Report Rooming List 2 Transfer Manifest Extras By Supplier And Date Accommodation Bookings Report by Resort Flight Analysis Component Cost Analysis Chalet Sales Analysis Agent Sales Analysis Tour Sales Analysis Mail Status Changed Deleted Flight Contracts Report Agents With Mo credit limit Fares Period Summary Accommodation Control Report Fluid Accommodation Price Adjustments Resorts To Countries Report Consortium Incentives Report Quote Conversion Report Voucher Dispatch Travelink Tools View Setup in Quote Linx Report Misc Flight Misc Transfer Misc Extra Type Misc Another Dynamic Package Search Edit Credit Card Surcharge field Remove All Booking Components Link Users To Products Generic Comment Checkbox Security Commission Update Report Tours Setup our Price Generator Setup Edit Booking Flight Confirmation Number LL LUPDATE Security Level L4 Accounts
90. selec Add Flights i i Set up Child Prices F Accommodation Estas Set up LO FI Prices g Car Hire Price Components Separately Price Type Matrix Commission Group Select v Documentation M Search Attributes Piic s Actions Leaders Departure From Departure To Booking From Booking Currency 1 2 1900 2 2020 1 2 1900 1 2020 cer yal our patas 1 Jan 1900 1 2020 cae add Note please add band first and then add the prices to it Not currently able to add prices in the footer Update All Individual Tour Dates Tour Master Set up Microsoft Internet Explorer 4 Season all kal Tour Testtour L view Suppressed Tours 20 Recent Tours Travelink Test tour Release 39 BETA Version 1 Inventory Price Types Summary o Tour Prices Base Type Occupancy Tour casts FM Twin NR Delete Q Single v Delete Flights Accommodation 3 e pom Set up Child Prices E Extras dint n z 1 v Car Hire Set up LO FI Prices Price Type Matrix Price Components Separately 1 Commission Group Select hl Documentation M Search Attributes Y Prices Actions Leaders lAdultLO Adult FI Adult Lo Departure From Departure To Booking From Booking To Currency sinal Single Individual
91. t 2 00 GBP LO Per Tour Coach FI 53 5714 53 5714 Supplier Cost 3 000 00 eur Tot Occupancy 40 Per Person 75 00 eur Supplier Cost 75 00 eur LO Per Tour Tour Manager FI 10 0000 10 0000 Supplier Cost 400 00 GBP Tot 40 Per Person 10 00 GBP Supplier Cost 10 00 GBP LO 583 0714 280 5714 Adult COST 583 0714 Child COST2280 5714 Markup Amount 0 Percent 20 Margin Adult 728 8392 Child Price2350 7142 Rounding 9 Adult Price 729 Child Price 359 Figure 59 1 TPG Calculation Breakdown Copyright Comtec Group Limited 2008 COMTEC Page 35 Tour Price Generator TPG Manual The calculation was run and the spreadsheet in Figure 60 below represents the workings Nights Exchange rate LO Twin Standard Fl Single Standard LO Single Standard Components Hotel twin 50 Euros pppn 7 1 4 LO Hotel single 60 Euros pppn 7 1 4 LO 300 00 300 0 Flights 230 FI 230 00 230 00 Regional flight 11GBP pp LO 11 00 11 00 11 00 11 00 Per person costs S __ Marketing 27GBP total LO 27 0 VAT 8GBP total LO 8 0 National express 1 5GBP total LO 1 0 150 1 50 Excursion profit 10GBP total LO 10 00 10 00 10 00 517 50 287 50 567 50 337 50 Per tour costs Tour manager 50 GBP per day 8 LO 10 00 Coach 3000 Euros total 1 4LO 53 57 Airport rep 80GBP total LO 2 00 Passenger load 40 0 0 0 40 Total cost pp 583 07 353 07 633
92. t Comtec Group Limited 2008 Page 36 Tour Price Generator TPG Manual 6 2 Scenario 2 Using the same example as scenario 1 this example has a different modeling in that 42 passengers are predicted and are itemised across price types as follows The difference here is compared to scenario 1 tour costs are now divided by 42 Passengers are split across price types and thus the calculation is using each price type The final prices and revenue totals are different Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Season All v Tour Test tour w Tours Setup Add New File erc f i I Delete Existing File Traveli k Load Existing File 1 w Edit Clone Existing File Release 39 BETA Version 1 Test tour File 1 Tour Modelling Margin Curve Results I Single Adult LO Single E a ult mn Tour Date Places Adult FI Twin Adult LO Twin 2 Jan 2008 100 430 9 Jan 2008 100 16 1 2008 100 23 Jan 2008 100 30 Jan 2008 100 6 Feb 2008 100 13 Feb 2008 100 20 Feb 2008 100 27 Feb 2008 100 w fo fo fo fo fo fo Display Tour Dates tick this box if you want to use the tour departure dates Passenger Total Control 42 5 at Figure 61 Example 2 TPG Tour Modeling Tour Price Generator
93. t for Total Cost for FI Margin FI Margin LO Margin LO Total revenue for Total profit for Total Per Person profit Overall Calculation Date the Tour Adult FI Adult LO Amount Amount Margin departure departure for departure Margin Breakdown Totals 0 00 0 00 0 00 0 Microsoft Internet Explorer jJ This will remove all existing results on this file Do you wish to continue Click the system will come up with a message Completed before the gt results are displayed a Figure 29 Run TPG Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator E 5 v T Testt AXI T S Add New File c i xd CET dii Delete Existing File Load Existing File 1 w Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Total Per Total Cost Total Total FI FI LO LO Adult FI Adult LO Adult FI Adult LO Total Total j J j Person Overall Calculation Tour Date forthe Cost for Cost Margin Margin Margin Margin Twin Sell Twin Sell Single Sell Single Sell revenue for profit for profit for Margin Breakdown Tour Adult FI Adult LO Amount Amount Price Price Price Price departure departure departure 2 Jan 20
94. t to use the tour departure dates 5 _ Display Tour Dates LA m Passenger Total Control Eg The Passenger Total Control is set to 42 Therefore the passenger numbers on each departure date must add to 42 Please note all values must match the occupancy of the pricing type All rows must match the control total Figure 25 Passenger Total Control If the passenger total numbers do not add up to the number entered in Passenger Total Control the system will display the following message Copyright Comtec Group Limited 2008 Page 15 Tour Price Generator TPG Manual Microsoft Internet Explorer 4 Can not save grid The number passengers in each band must match Ehe control total 423 Figure 26 Passenger Total Control Warning message 5 9 Margin Curve The Margin Curve section gives the ability to apply seasonal mark ups or margins to the costs The user will need to work through the screen from top to bottom and hit Save at the end 5 9 1 Departure Dates The user can either enter the departure date bands in manually or pull the Departure Dates automatically from the Tour Modeling section by using the Get Dates button Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator emm 7 Season All Add New File 2 1 Bi Testt v t J Traveli k L bx TON EUR Delete Existing File Load Existing File 1 Edit C
95. the tour departure dates e Passenger Total Control 50 Save Please note all values must match the occupancy of the pricing type All rows must match the control total Figure 17 Clone Existing File Edit the File name The TPG screen contains the following main sections separated into 3 tabs e Tour Modelling Margin Curve e Results Tour Price Generator BETA VERSION Microsoft Internet Explorer Tour Price Generator Season All Add New File lt lt v ne IE Tours Setup Delete Existing File Load Existing File 1 Edit Clone Existing File Test tour File 1 Release 39 BETA Version 1 Tour Modelling Margin Curve Results Figure 18 TPG tabs 5 8 Tour Modelling The modelling section is setup in a grid style All price types that have been set up in Tour Setup will be displayed in the tour modeling section as column headers Copyright Comtec Group Limited 2008 Page 12 Tour Price Generator TPG Manual Tour Master Set up Microsoft Internet Explorer a A Season al Tour Test tour v C view Suppressed Tours 20 Recent Tours Travelink Test tour Release 39 BETA Version 1 Inventory Price Types Summary v Tour Prices Base Type Occupancy Tour Costs Twin _____ Delete Single v Delete Flights O select Accommodation dm Set up Child Prices

TPG manual

Contents

Download Pdf Manuals

Related Search

Related Contents