I have read many a thread concerning ticket prices here, but it appears that no-one is yet to try calculating the optimal price for them. Thence, I decided to start constructing a formula that, when ready, could give the player a better idea about the attendance of the next match. Now, I am certainly not a mathematical genius, and the project is still very much in the beginning, but (to my own astonishment) the formula in its present form has already helped me in adjusting the ticket price with increased confidence.
Due to the fact that I do not know the factors that have an effect on the match attendances, I currently have several versions of the formula which all are used to make predictions.
The base value:The fans/ticket price ratio:Code:a*(b/c)*d*(e/f)Form excluded:Code:a*(e/f)Teams excluded:Code:a*(b/c)*(e/f)a = Competition (League = 1; Champions League = 1.1; Cup = 1.2)Code:a*d*(e/f)
b = Opponent Quality
c = Own Quality
d = Own Form
e = Fans
f = Ticket Price
The form is calculated with this formula:x = the number of winsCode:([x+0.5y]/5)+0.5
y = the number of draws
PLEASE NOTE: If you have played less than five matches in the season, make sure to change the number "5" to the number of matches you have had so far.
These are the results so far (I will keep updating the table on a regular basis).
BOLD match attendance indicates a sold out stadium.
Date Competition Opponent Quality Own Quality Own Form Fans Ticket Price Value Fans/Ticket Price Form Excluded Teams Excluded De Facto Attendance Income 11.4.2013 19:26 Champions League Group Stage 14.1 15.6 1.3 1,806 $8 291.781875 248.325 224.447596153846 322.8225 922 $7,736 12.4.2013 13:38 Cup Second Round 15.7 15.7 1.4 1,878 $8 394.38 281.7 281.7 394.38 1,000 $8,000 13.4.2013 12:50 League 2 18.3 15.2 1.4 2,004 $6 562.965789473684 334 402.118421052632 467.6 1,000 $6,000 15.4.2013 12:09 League 2 16.4 16 1.2 2,184 $7 383.76 312 319.8 374.4 954 $6,678 15.4.2013 19:04 Champions League Group Stage 18.2 17.1 1.2 2,238 $9 349.35485380117 273.533333333333 291.129044834308 328.24 800 $7,200
As you can see, the most recent match is the only one where the scores and the match attendance are in contradiction. I am suspecting that the reason is in how the ticket price's effect on the match attendance is calculated, but I have not yet done any testing regarding it.
Thank you for taking time to read about my experiment! If you wish to help, you can give me the information used in the table of your home matches for me to use (no need to tell me the match income) and tell me if you allow me to publish the data as a part of this table, or you can make suggestions how the formula could be improved.
As this is also my first post on this forum, I feel compelled to tell something about myself. I am a level-two manager whose team was founded on the 23rd of March.