• Welcome to Intercity Airways Discussion Forums.
 

Airline statistics update

Started by Chris Hulme, Aug 19, 2014 11:09

Previous topic - Next topic

Chris Hulme (1003)

We've add some new information to the airline statistics page and updated the presentation layout.

Why not take a look by making busy with the clicky mouse button on this lovely blue text?

Sergio De Ceglie (1143)

Nice work Chris. Looks good. Interesting to see Dusseldorf is the most popular hub.

Now I have a silly question. Is there somewhere we can look to see our total flights made without having to count entries from the logbook? I assume it's there staring me in the face but I can't find it.

Cheers,
Serge

Chris Hulme (1003)

Quote from: Sergio De Ceglie on Aug 19, 2014 12:09
Nice work Chris. Looks good. Interesting to see Dusseldorf is the most popular hub.

Now I have a silly question. Is there somewhere we can look to see our total flights made without having to count entries from the logbook? I assume it's there staring me in the face but I can't find it.

Cheers,
Serge


Actually there isnt, however I have added it to the top of the logbooks now, it says Total Entries and then the number of reports youve filed!

Chris Liu (1001)

#3
Wow, 7 minutes from user feature request to implementation on the website! How many other virtual airlines do you know that do that!?

Quote from: Sergio De Ceglie on Aug 19, 2014 12:09
Interesting to see Dusseldorf is the most popular hub.
Yes, that took me by surprise somewhat too, but given that it has the most destinations and flights I suppose it makes sense. Information like this is important because it allows us to make more informed expansion decisions.

Paul Regimbal (1002)

Most traveled routes doesn't always equate to highest revenue per hub or even highest revenue per segment/per nm.  Now that, would be an impressive stat!

Sergio De Ceglie (1143)

Quote from: Chris Hulme on Aug 19, 2014 12:16
Actually there isnt, however I have added it to the top of the logbooks now, it says Total Entries and then the number of reports youve filed!

That's awesome Chris. Thanks for that.

Quote from: Chris Liu on Aug 19, 2014 12:20
Wow, 7 minutes from user feature request to implementation on the website! How many other virtual airlines do you know that do that!?

Fantastic service indeed.

Quote from: Paul Regimbal on Aug 19, 2014 12:31
Most traveled routes doesn't always equate to highest revenue per hub or even highest revenue per segment/per nm.  Now that, would be an impressive stat!

Out of curiosity, it there any financial modelling done at Intercity that we don't see?

Cheers,
Serge

Chris Liu (1001)

#6
Quote from: Sergio De Ceglie on Aug 19, 2014 14:40
Out of curiosity, it there any financial modelling done at Intercity that we don't see?
Like you wouldn't believe! There's load factor calculations (although these don't take in to account real life competition) and complete costs generated for almost every flight, so I get a profit and loss account for each route and aircraft, as well as accounts for the whole airline.

The financial model is far from perfect though because I haven't factored in all the A and B checks, set the ticket prices properly or hedged fuel costs; I didn't see the point since as the only person that sees the financials is me, the important bit is realistically scheduling flights as everyone sees and uses that. Also some of the costs in the model's database are only guesses because such information tends to be confidential, such as landing and handling fees, aircraft maintenance etc. And there are a few things missing, for example I can't vary a flight's cruising speed, I don't think airport slot availability is modeled (although parking is).

Having said all that, I believe our financial model is probably the most accurate and considered of any virtual airline, it certainly goes a lot further than VAFS for instance. The model includes costs of ground staff, gate facilities, industrial action, management wages, the lease of office premises, staff training, manpower requirements, seasonal variation, insurances, commission for agents, aircraft reliability and maintenance (both subcontracted and in-house), advertising, handling agents, revenue from in-flight service, partnerships with car hire firms and hotel chains. The list goes on and on and on.

Benjamin Hall (1007)

Any chance of a pay rise then?  :P

Sergio De Ceglie (1143)

That's pretty thorough Chris. Must have taken alot of effort and work. So I guess the costs (profit/loss) assume all flights on the schedule are flown rather than what is actually flown by us pilots? Do you do all this with spreadsheets or do you have some specialised software?

I hope you don't mind me prying. This just all sounds intriguing.

Regards,
Serge

Sergio De Ceglie (1143)

Quote from: Chris Hulme on Aug 19, 2014 12:16
Actually there isnt, however I have added it to the top of the logbooks now, it says Total Entries and then the number of reports youve filed!

Since you're so efficient Chris, can I add another suggestion?  :)

The total time at the bottom of the logbook includes previous hours. Would it be possible to add in another line which just shows Intercity hours? So we could have Previous Hours, then Intercity Hours and finally Total Time. Saves me from doing the math (and getting it wrong).

Cheers,
Serge

Chris Hulme (1003)

Quote from: Sergio De Ceglie on Aug 19, 2014 16:05
Quote from: Chris Hulme on Aug 19, 2014 12:16
Actually there isnt, however I have added it to the top of the logbooks now, it says Total Entries and then the number of reports youve filed!

Since you're so efficient Chris, can I add another suggestion?  :)

The total time at the bottom of the logbook includes previous hours. Would it be possible to add in another line which just shows Intercity hours? So we could have Previous Hours, then Intercity Hours and finally Total Time. Saves me from doing the math (and getting it wrong).

Cheers,
Serge


Not as quick this time, took the kids to Manchester to watch the planes!


Ive added it in now, shows as LOGGED HOURS above your previous hours!

Chris Liu (1001)

#11
Quote from: Sergio De Ceglie on Aug 19, 2014 15:59
I guess the costs (profit/loss) assume all flights on the schedule are flown rather than what is actually flown by us pilots? Do you do all this with spreadsheets or do you have some specialised software?
Yeah, the financial model is based off what's scheduled, not what you chaps actually fly. Since we opened over a year ago, 1163 flights have been logged in total, which is roughly 1.25 days of the flight schedule! I use a specialist (and rather pricey) piece of software, but it's old and relatively unknown (I shan't name it as I don't want to tip off the competition ;D ).

Sergio De Ceglie (1143)

Quote from: Chris Hulme on Aug 19, 2014 21:43
Not as quick this time, took the kids to Manchester to watch the planes!

Ive added it in now, shows as LOGGED HOURS above your previous hours!

Thanks again Chris. Much appreciated. Now what else can I think of.... ;)

Cheers,
Serge

Sergio De Ceglie (1143)

Quote from: Chris Liu on Aug 19, 2014 22:31
Yeah, the financial model is based off what's scheduled, not what you chaps actually fly. Since we opened over a year ago, 1163 flights have been logged in total, which is roughly 1.25 days of the flight schedule! I use a specialist (and rather pricey) piece of software, but it's old and relatively unknown (I shan't name it as I don't want to tip off the competition ;D ).

Thanks for a bit more insight.

Geez, we've only flown just over a days worth of the schedule in a year! Sounds like we need a few more pilots.  :)

Cheers,
Serge

Paul Regimbal (1002)

Quote from: Sergio De Ceglie on Aug 20, 2014 01:11
Quote from: Chris Liu on Aug 19, 2014 22:31
Yeah, the financial model is based off what's scheduled, not what you chaps actually fly. Since we opened over a year ago, 1163 flights have been logged in total, which is roughly 1.25 days of the flight schedule! I use a specialist (and rather pricey) piece of software, but it's old and relatively unknown (I shan't name it as I don't want to tip off the competition ;D ).

Thanks for a bit more insight.

Geez, we've only flown just over a days worth of the schedule in a year! Sounds like we need a few more pilots.  :)

Cheers,
Serge


And a lot more time in our day to day to fly  ;D