spreadsheet-trip to France - report

There were a lot of other sites found but I have chosen the best options and the airlines which are very reliable and famous. In the first web site - www.easyjet.com I went to the flight select on the left side of the site. I chose from and where to I want to fly, the date of flying out to London and the date of returning to Belfast and number and group of age of passengers. At first I booked the flight for one adult person which was looking as shown below.

The price of one ticket for an adult was £59.98. This ticket does not include the insurance but it does include the taxes and other charges. The date of departure was 10th of June and the returning date was ten days later - 20th of June. As I finished booking flight for one adult I started to book the ticket for the same fight but for a child. I have done all the same steps as during booking ticket for an adult apart from choosing the age. At this stage I have chosen a child in group of age selection. The ticket after booking was looking as shown below.

The price of this ticket is £26.99 but it only includes taxes and charges per child. I didn't need any insurance for this ticket because I wanted to make the price as low as it was possible. That was all thing that I have been doing on this website. Another website that I visited to book the tickets for an adult and child was a www.bmi.co.uk site. Almost every site looks very similar. The booking bar was on left hand side of the website as in easy jet site. The steps of booking are also the same so I have chosen the departure and returning back place and dates of flights, the age of passenger and pressed "Submit" which was meant "Search". The booked ticket was looking as shown below.

Then I have done the same thing with the child i.e. I have chosen all the same thing

apart from the group of age, as I needed the price for a ticket for one child. And finally the last airline's website that I visited was www.flybe.com . As I mentioned before almost each airline's website looks very similar. I have made all the same steps as with the tickets in previous airlines. The booked tickets for an adult and for a child were looking as shown below.

For an adult:

The "flybe" airline does not have an option on its website, to book a ticket only for a child. As I read in the instruction of doing this assignment, if the airline don't allow to fly a child himself who, then I have to calculate the price of this ticket by myself. To do this task I just have to take 80% of the adult's ticket. I did this by using a formula in the spreadsheet where all the prices are located.

Formula used

I used formulas to calculate all the prices for the trip per one pupil and the whole group in the spreadsheet where the prices were shown.

Firstly I made a table that shows all the prices that has been given by each pupil per month. The maximum price that could be given by pupil in one month was £100. I had to make a validation in range in each month which would not allow teacher to get more than £100 per months. To make this I clicked Data --> Validation... and chose the option Decimal. I also chose less than and the maximum 100 as it was maximum price that could be paid in one month. Then if I put more than £100 the alert message appears. It looks like shown below:

Solution obtained

Airline

easy Jet

BMI

FlyBe

Price for one pupil

£32.99

£67.95

£48.58

I would recommend the easy Jet airline to go with to the London from Belfast as the costs of the flight are cheapest of all the three airlines that I have been trying to buy ticket.

FARE TAX TOTAL

FARE TAX TOTAL

FARE TAX TOTAL

From those graphs I can see that the cheapest airline from those three is easy Jet. Despite easy Jet hasn't the cheapest fare for the ticket, when we add tax this will be the cheapest ticket.