hi i have a question, i am not sure what formula i can use to calculate this
question, cause i am require to use the tier system for it:

Commissions for airline tickets are based on a tier system. Comfort gets 5%
commissions from the first $500,000 of ticket revenue, 5.5% from revenue
between $500,001 to $1,000,000 and 6% for revenue above $1,000,000, for
Corporate tickets revenue. As for Individuals tickets revenue, the
commissions structure is 4.5% for the first $500,000, 6% from revenue
between $500,001 to $1,000,000 and 7% for revenue above $1,000,000.
Commissions for packaged tours are projected at 12% of packaged revenue.