Scribd Logo
Upload

Welcome to Scribd!

  • 313 views

    Frequent Flier

    Uploaded by

    Suman Nayak
    1) The document describes an Indian Airlines frequent flyer scheme that offers free travel based on earned mileage points. It provides a table with cities and required points for different classes (Economy, Executive). 2) The customer's earned points, desired travel class, and city are given. Formulas are to be entered to determine if the points are adequate for travel, the farthest possible city, and remaining points after that trip. 3) Formulas are developed referring to the customer's data and mileage table to address the questions. An extension addresses modifying the solutions if additional classes are considered.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Frequent Flier

    Uploaded by

    Suman Nayak
    313 views2 pages
    1) The document describes an Indian Airlines frequent flyer scheme that offers free travel based on earned mileage points. It provides a table with cities and required points for different classes (Economy, Executive). 2) The customer's earned points, desired travel class, and city are given. Formulas are to be entered to determine if the points are adequate for travel, the farthest possible city, and remaining points after that trip. 3) Formulas are developed referring to the customer's data and mileage table to address the questions. An extension addresses modifying the solutions if additional classes are considered.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) The document describes an Indian Airlines frequent flyer scheme that offers free travel based on earned mileage points. It provides a table with cities and required points for different classes (Economy, Executive). 2) The customer's earned points, desired travel class, and city are given. Formulas are to be entered to determine if the points are adequate for travel, the farthest possible city, and remaining points after that trip. 3) Formulas are developed referring to the customer's data and mileage table to address the questions. An extension addresses modifying the solutions if additional classes are considered.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    313 views2 pages

    Frequent Flier

    Uploaded by

    Suman Nayak
    1) The document describes an Indian Airlines frequent flyer scheme that offers free travel based on earned mileage points. It provides a table with cities and required points for different classes (Economy, Executive). 2) The customer's earned points, desired travel class, and city are given. Formulas are to be entered to determine if the points are adequate for travel, the farthest possible city, and remaining points after that trip. 3) Formulas are developed referring to the customer's data and mileage table to address the questions. An extension addresses modifying the solutions if additional classes are considered.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    4.

    Frequent Flyer Scheme of IA

    The frequent flyer scheme of Indian Airlines (IA) offers free travel to IA customers for
    mileage points earned by them through earlier travels. The cities and mileage points
    required to avail a free ticket to those cities are given in the IAFF Mileage Points Table on
    the IA website. A segment of the table is rearranged (in the ascending order of points
    required) and reproduced in columns A to C (rows 1-14) of the spreadsheet below.

    A B C D E F G H
    IA Frequent Flyer Mileage Points Table (Ahmedabad Segment)
    1

    2 Points required for


    3 To City Executive Economy Flying Points 12000 ----------
    Accrued:
    4 Vadodara 2880 1920 Class of Interest: Economy ----------
    5 Mumbai 8280 5520 Free travel to city: Delhi ----------

    6 Jaipur 9840 6560


    7 Delhi 14160 9540 Farthest Possible ----------
    City

    8 Hyderabad 16290 10860 Balance Pts: ----------

    9 Muscat 17600 13000


    10 Sharjah 17660 13040
    11 Kuwait 20100 14900
    12 Bangalore 23220 15480
    13 Bhubaneswar 26220 17480
    14 Kolkata 35160 23440

    The flying points earned by a customer are given in cell G3. Also the class and city to
    which the customer is interested to travel using free entitlement is given in cells G4 and G5
    respectively. The formulae you develop for the questions below should work with any valid
    data entered in these cells.

    Questions

    Enter a formula in cell H4 to obtain the column number in the table A3:C14 of the class in
    cell G4. For example, if the class given in G4 is Economy, the value in H4 should be 3. Use
    this result in subsequent questions, to simplify the formulae where ever possible.

    Formula:
    Enter a formula in cell H5 Yes No
    whether the points given in G3 are adequate (Yes) or not adequate (No) to travel by the class
    in G4 to the city in G5. For example, with 12000 points, the customer can travel free by
    Economy class to the desired city Delhi (required points 9540) and therefore the output

    4
    should be Yes for this data. Formula:

    Enter a formula in cell G7 to obtain the farthest possible city the customer can travel free
    with the points accrued (given in G3), by the class given in G4. For example, with 12000
    points, the farthest city the customer can travel free by Economy class is Hyderabad.
    Formula:

    Enter a formula in cell G8 to obtain the balance mileage points; i.e. the difference of points
    accrued and points required to travel by the class in G4 to the farthest city obtained in G7.
    For example, with 12000 points, after travelling to the farthest city (Hyderabad) in
    Economy class, the balance is 1140 (12000- 10860).
    Formula:
    Extension: Re-develop solutions to the above, if more than two classes are to be
    considered.

    You might also like