Forum Discussion
Solved
Having a problem with calculations
Hello All,
Having trouble with a formula for a basic calculation. Currently I am trying to calculate a fare based upon the trip in miles.
So I have the formula:
=(distance in miles) x (available seats) or =162 x .35 which would result in $56.70, however it results in 55.97 and the formula regardless of the distance for example even if the cell numbers are 199 x .28 which would equal $55.72 it is giving me a result of 55.97
Better Example of the Problem (I cannot upload screen shots)
Nautical Miles | # of Seats on aircraft | Available Seat Mile | Direct Operating Costs (DOC) | Fixed Costs | CASM |
| Fare |
400 | 9 | 3600 =[@[Nautical Miles]]*[@['# of Seats on aircraft]] | 404.58 | 99.12 |
.14
(=([@[Fixed Costs]]+[@[Direct Operating Costs (DOC)]])/[@[Available Seat Mile]]
| incorrect | 55.97
=[@[Nautical Miles]]*[@CASM] |
400 | 9 | 3600 =[@[Nautical Miles]]*[@['# of Seats on aircraft]] | 404.58 | 99.12 |
.14 (=([@[Fixed Costs]]+[@[Direct Operating Costs (DOC)]])/[@[Available Seat Mile]] | correct | 56.00
=[@[Nautical Miles]]*.14 (or the total of CASM) |
| 363 | 9 | 3267 | 404.58 | 99.12 | .15 | incorrect | 55.97 |
363 | 9 | 3267 | 404.58 | 99.12 | .15 | correct | 58.08 |
Ok I get it now! I appreciate the help very much Hans! Thank you I was getting confused about your response as well as others saying to round it off, as you have may already have seen in my other responses I thought that the other calculations would have been way more complex then the final fare, and I guess that is the point for this practice with excel...I will do other examples to make sure i have it down. Once again thanks!
In the first data row of your example, CASM isn't exactly 0.14, but 0.13991666666...
This causes the discrepancy.
By the way, your calculation divides by Nautical Miles, then multiplies with Nautical Miles again. That's superfluous. Fare is simply Total Cost/Number of Seats.
HansVogelaar Hi I know that isn't exactly .14 but we are dealing with currency as CASM is expressed in cents (rounded to the nearest cent).
Sorry, I don't understand what you mean by nautical miles are divided and then multipied? Nautical miles are first multiplied to get the ASM (available seat mile)
ASM = Total number of seats on aircraft x Distance of trip (NM)
3600 = 9 x 400
Then to get CASM
CASM = Direct Operating Cost + Fixed Costs / ASM
$ .14 (.1399....)= (404.58+99.12)/3600
Nautical Miles are then multiplied to get the fare cost.
FARE = CASM * NM
56.00 = .14*400
I'm sorry sort of new at doing more indepth formulas like this. Thanks for your response!
FARE = CASM * NM = TotalCost / ASM * NM = TotalCost / (Seats *
NM) *NM= TotalCost / SeatsIf you want CASM to be rounded to cents, change its formula to
=ROUND(([@[Fixed Costs]]+[@[Direct Operating Costs (DOC)]])/[@[Available Seat Mile]],2)
- I suspect that the values .35 and .28 are the result of a formula and the actual numbers are not exactly the values displayed.
Round the final calculation not the intermediate steps.
'---
Nothing Left to Lose- Hey Nothing left to lose! Thanks for your response, sorry i didn't respond! Appreciate your help.
