1 / 13

Simplifying YQ Analysis for Airlines with Pregem's Comprehensive Solution

Understand the challenges airlines face with YQ charges and how Pregem's IT solution streamlines rate maintenance, liability calculation, and reporting. Enhance YQ data management with secure rates, accurate liability calculation, and customizable UI. Benefit from cross-departmental usage, user-level security, and daily/weekly/monthly reporting options. Explore Pregem's proven approach for efficient YQ analysis and upgrade your airline operations seamlessly.

pules
Download Presentation

Simplifying YQ Analysis for Airlines with Pregem's Comprehensive Solution

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. YQ Analysis from Pregem The solution to your airline’s problems

  2. YQ Analysis: Overview • What is YQ? • Problems airlines face with YQ • Pregem has the best solution • Our approach to YQ • Rate maintenance • Liability calculation • Reporting • Summary Pregem - your trusted IT partner www.pregem.com

  3. YQ Analysis: What is YQ? • A ticket level charge applied by airlines • It is not a ‘government’ tax • It is also called ‘YR’ or ‘fuel surcharge’ • Often shown separately to base fare on TKTS • Accounts for millions ($,£,€) each week • Is highly sensitive commercial data Pregem - your trusted IT partner www.pregem.com

  4. YQ Analysis: The Challenges • Rates often set by Commercial but impact Finance • Rates may be frequently updated • Accompanying rules can be complex • May include many exception conditions e.g. via points, POC, POS, class, dates • Conditions often in word form • Master rate data may not be secure • Data may be held in a local Excel copies Pregem - your trusted IT partner www.pregem.com

  5. YQ Analysis: More Challenges • Exception conditions may apply based on: • Via points • POC/POS • Class/Cabin • Booking/Issue/Travel dates • Staff/Crew pos./Training/FF’s • Currency Pregem - your trusted IT partner www.pregem.com

  6. YQ Analysis: Still More Challenges • Airline may only have ticket level YQ data • Can be difficult to calculate full YQ liability e.g. • Online flown • Offline flown • OAL flown • Sold not flown, refunded or exchanged • Difficulty auditing YQ to coupon level • Can result in different versions of the truth Pregem - your trusted IT partner www.pregem.com

  7. YQ Analysis: Pregem’s solution Pregem YQ Analysis enables you to: 1. Consolidate YQ rate rules & maintenance 2. Calculate & cross check all YQ liabilities 3. Analyse YQ data with BI style reports 4. Maintain full historical Sold v Flown YQ liability reports 5. Enable audit of Expected v Actual YQ One YQ source for both Finance & Commercial Pregem - your trusted IT partner www.pregem.com

  8. YQ Analysis: Secure YQ Rates • Rates stored in our secure DB • Maintained through user interface • Accessible to authorised users only • Rates can be imported from Excel directly • Rates validated based on defined rules • Flexible structure to support new rules Pregem - your trusted IT partner www.pregem.com

  9. YQ Analysis: Calculate YQ Liability • Options for Flown, OAL, Offline & Flown not Sold • Uses your ticket, schedule and class data • Daily, weekly or monthly processing • Output in range of formats • Browser based analysis, drill-down & reporting • Multiple GUI analysis points including: Route, date, cabin, POC/POS, ticket/coupon Pregem - your trusted IT partner www.pregem.com

  10. YQ Analysis: Customisable UI Pregem - your trusted IT partner www.pregem.com

  11. YQ Analysis: Summary • Supports complex YQ rates & maintenance • Handles all modes of YQ (Flown, Unflown, Offline etc.) • Audit expected YQ v actual YQ collected • Even a 0.5% error rate could be you costing millions • Supports cross departmental use • Security and access defined down to user level • Daily, weekly or monthly reporting options • GUI browser based reports all with Excel support • Range of output data streams can be provided Pregem - your trusted IT partner www.pregem.com

  12. YQ Analysis: Delivery Steps • Available as hosted service or in house system • Pregem already host systems for several airlines • Ticket data can be extracted from your existing system • YQ rate maintenance via Excel • Configure rules, run schedule and output streams • Reports supplied in QlikView (or your preferred BI tool) • No obligation trial under NDA available Pregem - your trusted IT partner www.pregem.com

  13. if you think all IT companies are the samethink again your trusted IT partner www.pregem.comor contact us on +44 (0)1420 544 514

More Related