I've searched around and done my homework and I feel like I'm missing something here. RPM is supposed to be (# of pax/tickets sold)*(length of route in miles) and ASM is supposed to be (# of seats on plane)*(length of route in miles), correct?
I've attached 2 screenshots and rpm1.png shows the LF, RPM, and ASM yields for 5 daily flights for the same route. The LF are all different and therefore the RPM and ASM values vary accordingly. However, rpm2.png also shows 6 daily flights for the same route (but different route than rpm1) and the LF varies, but the RPM remains constant at 20.00 for each route? There is a 5.3% range in LF values and the ASM values change by 1.05 cents, but the RPM doesn't even deviate by 1/100th of a cent? Am I going crazy or am I missing something here?
For reference, rpm1 is a ~2000nm route and rpm2 is ~750nm. I thought maybe it was the length of the route, but I also have 5 flights daily on a ~700nm route with an even smaller 2.2% LF range and there is still a delta of 0.11 cents on the RPM yields.
What am I missing here?
[attachment expired]
The most obvious explanation for me would be that either the routes were created at different times (resulting in a difference in price between the routes), or the amount of C/F seats sold.
The plane is an MD-88 with 150Y seats (2 planes, actually) and they all have the same ticket prices...