OP just needs to ensure they are comparing apples to apples.
If they want to include tuition, books, transportation and “other fees”, then they have to do that for all colleges. Playing football adds in “other fees” for shoes, etc. If one is going to include “gas” to get somewhere, then add that to all fees.
Agreed that airfare and such needs to be factored in to considerations. If hes playing football, OP likely needs to consider losing versus winning teams as well if that matters.
Nothing much to consider here.