City of Lawrence
Special Alcohol Fund   5/2/2008 14:20
Actual Actual Actual Actual Preliminary
Revenues 2003 2004 2005 2006 2007 2008 2009 2010 2011
Liquor Tax       518,024     530,786   530,707      543,415       548,596  575,000  603,750   633,938   665,634 5% increase
Total Revenue       518,024     530,786   530,707      543,415       548,596  575,000  603,750   633,938   665,634
 
Expenditures
Contractual Services       461,166     514,362   569,136      611,360       644,839  653,154  610,000   635,000   650,000  
Revenue over Expenditures         56,858      16,424    (38,429)       (67,945)        (96,243)  (78,154)     (6,250)     (1,063)     15,634
Beginning Balance       217,873     274,731   291,155      252,726       184,781   88,538    10,384      4,134      3,072
End Balance       274,731     291,155   252,726      184,781         88,538   10,384      4,134      3,072     18,706
Assumptions
Revenues increase 5%, expenditures 100% of budget in 2008