MichiganEliteFightLeague
New Member
- Joined
- Jul 30, 2015
- Messages
- 2
Hello, We run a MMA company out of Michigan and I had a question on how to set up a spreadsheet to help with ticket figuring. Here is the scenario I need help with. We sell the tickets for $20. Tickets are signed out to fighters and they sell them to make a cut. If they sell 1 ticket through 20 tickets they receive a $5 kickback and we receive $15. We have different commission points. 1-20 is $5, 21-30 is $6, #31-40 is $7, 41-50 is $8 and 50 tickets plus is $9 back to the fighter. This is where I get lost. The commission varies on the quantity of tickets sold and needs to adjust as needed. Example: When a fighter sells 33 tickets they would get a $7 ticket commission on ticket 31,32,and 33. Then drop to $6 a ticket for 21-30, and then on ticket 1-20 go to $5.
My biggest concern is I need something for speed as we collect money and leftover tickets the day before. I would like something that for example a fighter signs out 20 tickets at $20 a piece. He sells 5 tickets, he keeps a $25 cut and we get $75. For the sake of speed I would need something where I type in how many they signed out and how many tickets they returned. Which in turn tells me they sold 5 tickets, owe $75 and they get a $25 cut. Are ticket prices are $20 for general admission and $30 for VIP. The same cut is for both ticket styles. Any help would be greatly appreciated.
My biggest concern is I need something for speed as we collect money and leftover tickets the day before. I would like something that for example a fighter signs out 20 tickets at $20 a piece. He sells 5 tickets, he keeps a $25 cut and we get $75. For the sake of speed I would need something where I type in how many they signed out and how many tickets they returned. Which in turn tells me they sold 5 tickets, owe $75 and they get a $25 cut. Are ticket prices are $20 for general admission and $30 for VIP. The same cut is for both ticket styles. Any help would be greatly appreciated.
