Inconsistency between transported pax and revenue

[Tha_Ape]

Hi all,

maybe I'm missing something, but as I look at my figures, it seems a bit strange:
the transported pax curve keeps increasing over the last 3 months, but in 'Income statement", it says that my operational revenue is decreasing over the last 3 months.
And the answer is no, I didn't touch the pricing.

Would anybody have an idea?

[MikeS]

Probably above average number of your long haul, high revenue fleet in C/D checks (they do not move a lot of pax compared to short haul fleet).
Otherwise, blame it on the Rubel

Mike

[Tha_Ape]

I noted every single week's operational income, and it seems that the "problem" is in the weekly -> monthly calculation.

No matter where I set the exact beginning and end of the months, the monthly sum of weekly income was significantly higher in april and may than in march.
Still, when I switch to monthly view, it is significantly higher in march and june than in april and may.

The only possibility is that for the monthly income it takes whole weeks, and that thus half a week (or more) has been subtracted from april and allocated to march (week spreading over the 2 months), and that half a week has been subtracted from may and allocated to june.

Meaning that the monthly income is actually inaccurate, as it takes weeks into account, and not days. Thus, a month's "official" income could have 4 or 5 weeks, giving a 20-25% variance, and a difference of the same amount.

[Sami]

The data is stored on weekly basis (= one dataset value for entire week; in order to keep the database size reasonable) and since there are different number of days per month the values might differ at some points if you look let's say February vs. March. But all depends on the chart and chosen time settings etc.

[schro]

So, in short, if you want to do comparisons to prior periods, focus on weeks and not on other units of measure.

Another fun fact is that the months you see are not true months. They begin on the first Monday of that calendar month and end on the first Sunday of the next month (unless last day of month is a Sunday).

[Tha_Ape]

Yeah, it's absolutely that.
And if you want a graphic explanation, just put your monthly income into a curve, and it will give something like that.
An alternation of "small" and "big" months.