Houston Amateur Golf Association - Prize Fund Regular Flights

For the past several years, the prize money for 1st, 2nd and 3rd was fixed at $115, $75 and $50 no matter how many players competed. Over the past several months, the board members developed a spreadsheet to determine how much we could pay based on the number of players in the tournament. We also developed a guideline for the number of flights and players in each flight. We also increased the amount paid to Low Gross and Low Net winners. The result is the table shown below. Our goal was to make the tournament income (tournament fees) match expenses(course fees, prize fund and administrative fees). Note: The prize fund is the number of players times the number of flights. The Prize Fund may not equal the sum of the individual prizes due to rounding.

Players Flights Prize Fund 1st 2nd 3rd Low Gross/Net Champ First Second Third Fourth Fifth Sixth Seventh
24 2 $480 $100 $60 $40 $50 12 12            
25 2 $500 $100 $60 $40 $50 12 13            
26 2 $520 $110 $60 $40 $50 13 13            
27 2 $540 $110 $70 $40 $50 13 14            
28 2 $560 $120 $70 $50 $50 14 14            
29 2 $580 $120 $70 $50 $50 14 15            
30 2 $600 $130 $80 $50 $50 15 15            
31 2 $620 $130 $80 $50 $50 15 16            
32 2 $640 $140 $80 $50 $50 16 16            
33 2 $660 $140 $80 $60 $50 16 17            
34 2 $680 $150 $90 $60 $50 17 17            
35 2 $700 $150 $90 $60 $50 17 18            
36 3 $720 $100 $60 $40 $60 12 12 12          
37 3 $740 $100 $60 $40 $60 12 12 13          
38 3 $760 $110 $60 $40 $60 12 13 13          
39 3 $780 $110 $70 $40 $60 13 13 13          
40 3 $800 $110 $70 $50 $60 13 13 14          
41 3 $820 $120 $70 $50 $60 13 14 14          
42 3 $840 $120 $70 $50 $60 14 14 14          
43 3 $860 $120 $70 $50 $60 14 14 15          
44 3 $880 $130 $80 $50 $60 14 15 15          
45 3 $900 $130 $80 $50 $60 15 15 15          
46 3 $920 $130 $80 $50 $60 15 15 16          
47 3 $940 $140 $80 $50 $60 15 16 16          
48 3 $960 $140 $80 $60 $60 16 16 16          
49 3 $980 $140 $90 $60 $60 16 16 17          
50 3 $1,000 $150 $90 $60 $60 16 17 17          
51 3 $1,020 $150 $90 $60 $60 17 17 17          
52 4 $1,040 $110 $70 $50 $70 13 13 13 13        
53 4 $1,060 $120 $70 $50 $70 13 13 13 14        
54 4 $1,080 $120 $70 $50 $70 13 13 14 14        
55 4 $1,100 $120 $70 $50 $70 13 14 14 14        
56 4 $1,120 $120 $70 $50 $70 14 14 14 14        
57 4 $1,140 $130 $80 $50 $70 14 14 14 15        
58 4 $1,160 $130 $80 $50 $70 14 14 15 15        
59 4 $1,180 $130 $80 $50 $70 14 15 15 15        
60 4 $1,200 $130 $80 $50 $70 15 15 15 15        
61 4 $1,220 $140 $80 $50 $70 15 15 15 16        
62 4 $1,240 $140 $80 $60 $70 15 15 16 16        
63 4 $1,260 $140 $80 $60 $70 15 16 16 16        
64 4 $1,280 $140 $90 $60 $70 16 16 16 16        
65 4 $1,300 $150 $90 $60 $70 16 16 16 17        
66 4 $1,320 $150 $90 $60 $70 16 16 17 17        
67 4 $1,340 $150 $90 $60 $70 16 17 17 17        
68 4 $1,360 $150 $90 $60 $80 17 17 17 17        
69 5 $1,380 $120 $70 $50 $80 13 14 14 14 14      
70 5 $1,400 $120 $70 $50 $80 14 14 14 14 14      
71 5 $1,420 $130 $80 $50 $80 14 14 14 14 15      
72 5 $1,440 $130 $80 $50 $80 14 14 14 15 15      
73 5 $1,460 $130 $80 $50 $80 14 14 15 15 15      
74 5 $1,480 $130 $80 $50 $80 14 15 15 15 15      
75 5 $1,500 $130 $80 $50 $80 15 15 15 15 15      
76 5 $1,520 $140 $80 $50 $80 15 15 15 15 16      
77 5 $1,540 $140 $80 $60 $80 15 15 15 16 16      
78 5 $1,560 $140 $80 $60 $80 15 15 16 16 16      
79 5 $1,580 $140 $90 $60 $80 15 16 16 16 16      
80 5 $1,600 $140 $90 $60 $80 16 16 16 16 16      
81 5 $1,620 $150 $90 $60 $80 16 16 16 16 17      
82 5 $1,640 $150 $90 $60 $80 16 16 16 17 17      
83 5 $1,660 $150 $90 $60 $80 16 16 17 17 17      
84 5 $1,680 $150 $90 $60 $80 16 17 17 17 17      
85 5 $1,700 $150 $90 $60 $80 17 17 17 17 17      
86 6 $1,720 $130 $80 $50 $90 14 14 14 14 15 15    
87 6 $1,740 $130 $80 $50 $90 14 14 14 15 15 15    
88 6 $1,760 $130 $80 $50 $90 14 14 15 15 15 15    
89 6 $1,780 $130 $80 $50 $90 14 15 15 15 15 15    
90 6 $1,800 $140 $80 $50 $90 15 15 15 15 15 15    
91 6 $1,820 $140 $80 $50 $90 15 15 15 15 15 16    
92 6 $1,840 $140 $80 $60 $90 15 15 15 15 16 16    
93 6 $1,860 $140 $80 $60 $90 15 15 15 16 16 16    
94 6 $1,880 $140 $90 $60 $90 15 15 16 16 16 16    
95 6 $1,900 $140 $90 $60 $90 15 16 16 16 16 16    
96 6 $1,920 $150 $90 $60 $90 16 16 16 16 16 16    
97 6 $1,940 $150 $90 $60 $90 16 16 16 16 16 17    
98 6 $1,960 $150 $90 $60 $90 16 16 16 16 17 17    
99 6 $1,980 $150 $90 $60 $90 16 16 16 17 17 17    
100 6 $2,000 $150 $90 $60 $90 16 16 17 17 17 17    
101 6 $2,020 $150 $90 $60 $90 16 17 17 17 17 17    
102 6 $2,040 $160 $90 $60 $90 17 17 17 17 17 17    
103 7 $2,060 $130 $80 $50 $100 14 14 15 15 15 15 15  
104 7 $2,080 $130 $80 $50 $100 14 15 15 15 15 15 15  
105 7 $2,100 $140 $80 $50 $100 15 15 15 15 15 15 15  
106 7 $2,120 $140 $80 $50 $100 15 15 15 15 15 15 16  
107 7 $2,140 $140 $80 $60 $100 15 15 15 15 15 16 16  
108 7 $2,160 $140 $80 $60 $100 15 15 15 15 16 16 16  
109 7 $2,180 $140 $80 $60 $100 15 15 15 16 16 16 16  
110 7 $2,200 $140 $90 $60 $100 15 15 16 16 16 16 16  
111 7 $2,220 $140 $90 $60 $100 15 16 16 16 16 16 16  
112 7 $2,240 $150 $90 $60 $100 16 16 16 16 16 16 16  
113 7 $2,260 $150 $90 $60 $100 16 16 16 16 16 16 17  
114 7 $2,280 $150 $90 $60 $100 16 16 16 16 16 17 17  
115 7 $2,300 $150 $90 $60 $100 16 16 16 16 17 17 17  
116 7 $2,320 $150 $90 $60 $100 16 16 16 17 17 17 17  
117 7 $2,340 $150 $90 $60 $100 16 16 17 17 17 17 17  
118 7 $2,360 $150 $90 $60 $100 16 17 17 17 17 17 17  
119 7 $2,380 $160 $90 $60 $100 17 17 17 17 17 17 17  
120 8 $2,400 $140 $80 $60 $100 15 15 15 15 15 15 15 15