I have found excel is a good tool.  Sit with your league offices and determine best prize fund for your league.  Leagues with mixed skill levels, it is best to reward everyone.  I found important to determine last place payouts and work upward.  Rewarding the weaker teams will coax them into returning year after year and believe it or not they are the teams that keep league attendance up.   Bowling is no longer a place where people are making a lot of money with lineage costs taking most of the league fees.  In NY, currently paying $18 in lineage which is more than half our league fees.   Good luck and good bowling.