Loading...
HomeMy WebLinkAboutWS Item 03 - Monthly Financial Update � . -�-.�'-c,e� ����`lC� MONTHLY FINANCIAL REPORT � NOVEMBER FY 2011 FY 2010 FY 2009 General Fund Bud et Actual Percenta e Bud et Actual Percenta e Bud et Actual Percenta e Ad Valorem Taxes 6,286,740 256,639 4.1% 7,567,717 251,720 3.3% 7,567,717 176,290 2.3% Sales Taxes 20,900,000 - 0.0% 21,250,000 - 0.0% 23,400,000 - 0.0% Mixed Beverage Taxes 1,200,000 - 0.0% 1,202,000 - 0.0% 1,300,000 - 0.0% Franchise Fees 6,245,000 960,238 15.4% 6,179,086 939,943 15.2% 6,225,000 934,462 15.0% Licenses&Permits 1,074,381 179,372 16.7% 1,003,821 137,752 13.7% 1,385,931 226,235 16.3% Charges for Services 7,550,010 284,782 3.8% 7,572,069 250,594 3.3% 7,547,575 249,977 33% Intergovernmental 78,639 2,520 3.2% 78,639 630 0.8% 78,552 3,780 4.8% Fines&Forfeitures 2,263,910 315,395 13.9% 2,243,528 300,092 13.4% 2,057,625 247,820 12.0% Transfers In 2,900,324 - 0.0% 3,105,975 - 0.0% 3,046,684 - 0.0% Miscellaneous 809,079 598,632 74.0% 956,309 69,606 73% 690,082 15,827 23% Total Revenues 49,308,083 2,597,578 5.3% 51,159,144 1,950,338 3.8% 53,299,166 1,854,391 3.5% Personnel 24,840,208 3,576,027 14.4% 24,993,444 3,470,224 13.9% 24,648,980 3,351,712 13.6% Supplies 2,265,798 238,786 ]0.5% 2,366,763 386,490 163% 2,440,120 345,786 14.2% Maintenance 692,246 ]01,476 14.7% 693,269 121,098 17.5% 709,496 96,226 13.6% Services 6,736,956 645,527 9.6% 6,923,130 697,554 10.1% 7,297,871 664,701 9.1% Insurance 7,528,208 1,190,583 15.8% 7,728,453 1,436,963 18.6% 7,818,653 1,711,020 21.9% Transfers Out 7,244,667 - 0.0% 8,454,085 376 0.0% 9,887,450 - 0.0% Ca ital Outla 0 - 0.0% 0 - 0.0% 45,000 - 0.0% Total Expenditures 49,308,083 5,752,398 11.7% 51,159,144 6,112,706 11.9% 52,847,570 6,169,445 11.7% . . MONTHLY FINANCIAL REPORT NOVEMBER FY 2011 FY 2010 FY 2009 Utilit Enter rise Fund Bud et Actual Percenta e Bud et Actual Percenta e I3ud et Actual Percenta e Water Sales 11,698,848 1,638,923 14.0% 1 1,745,665 1,230,158 10.5% 1 1,745,665 1,218,406 10.4% Raw Water Sales 192,464 15,316 8.0% 192,464 3,872 2.0% 179,503 16,383 9.1% Water Tap Fees 25,000 5,775 23.1% 25,000 - 0.0% 50,000 1,050 2.1% Utility Inspection Fees 10,000 12,699 127.0% 13,000 1,512 11.6% 25,000 1,195 4.8% Reconnect&Transfer Charges 225,000 34,907 15.5% 225,755 37,947 16.8% 225,755 42,220 18.7% Wastewater Sales 6,583,141 798,147 12.1% 6,901,150 819,416 11.9% 6,901,150 649,264 9.4% Wastewater Tap Fees 13,000 810 6.2% 13,367 0.0% 13,367 805 6.0% Sprinkler Service Fee - 2,748 NA - 13,869 NA - 109,028 NA Interest on Investments 250,000 (13,202) -5.3% 472,191 (30,348) -6.4% 472,191 (27,685) -5.9% Sale of Salvage 1,500 - 0.0% 1,500 865 57.7% 1,500 311 20.7% Sale of Material, Labor - - 0.0% 750 0.0% 750 - 0.0% Transfers In 63,012 - 0.0% 63,012 0.0% 63,012 - 0.0% Miscellaneous 375,000 13,597 3.6% 375,000 1,919 0.5% 250,000 3,336 1.3% Total Revenues 19,436,965 2,509,721 12.9% 20,028,854 2,079,210 10.4% 19,927,893 2,014,313 10.1% Personnel 2,986,967 409,533 13.7% 2,939,933 409,983 13.9% 2,839,961 374,303 13.2% Supplies 843,357 71,733 8.5% 891,607 68,178 7.6% 931,111 100,059 10.7% Maintenance 414,778 81,413 19.6% 414,078 105,287 25.4% 414,078 55,639 13.4% Services 11,355,947 994,676 8.8% 10,733,027 772,671 7.2% 10,984,488 990,663 9.0% Debt Service 2,009,920 600 0.0% 2,749,318 (72,315) -2.6% 2,737,954 (76,579) -2.8% Transfers Out 1,457,772 - 0.0% 2,068,057 0.0% 1,832,399 - 0.0% Permanent Capital Maint. 750,000 8,146 1.1% 750,000 18,155 2.4% 750,000 26,978 3.6% Ca ital Outla 368,700 - 0.0% 125,400 - 0.0% 125,400 - 0.0% Total Expenditures 20,187,441 1,566,101 7.8% 20,671,420 1,301,959 6.3% 20,615,391 1,471,063 7.1% Sales Tax Strength Index 12-Month Average % Above / Below 36-Mooth Average 50.00% 40.00% 30.00% I 20.00% ' 10.00% 0.00% -10.00% 00 01 O N M � �l �D [� 00 O� O �--� N M 7 �'1 �O [� 00 O� O pp pp Q� p� p� p� Q� O� O� 01 O� T O O O O O O O O O O �--� U o o U U U U U U U U o U U c� o o U U o c� U U ai a� v a� v a� a� ai ai a� a� a� ai a� a� a� a� a� a� a� ai ai a� C� Ca �1 �1 Ca f� Ca f� (� Ll (� Ca (� Ca �1 (� (� f� �1 (� (� (� A , Monthly Sales Tax Receipts '� General Fund $3,00O,OOU $2,500,000 _-- - _ _ __ . _ _ _ _ _ ___ $2,000,000 ---___ - -_ _._ _ _ _ �I$1,500,000 -- +' $1,0OO,OU11 I I I I � i , $SOO,OUO I - � I I $U - Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■2006 ■2007 ❑2008 ❑2009 ■2010 , . I I Hotel Occupancy Taxes Jan 2008 - Present $25,000,000 $20,000,000 __ - ---- ___--___--_- _----- � $15,000,000 _ __ __ _ _ -- $10,000,000 -- -- - --- ---- -- ---_ _ � i I $5,000,000 ---- - -- �'' $0 � , I oc oc oc o0 00 0o c, o� o� a� o� a, o 0 0 0 o I 0 0 0 0 0 0 0 0 0 0 0 0 .� .� � � •� c �. �, -= a � c � � -� a > a � � -� c. � �' � � �' �' z �' � � �' `�' z �' � � � �' I . . Average Revenue Per Available Room 'I Oct 2009 - Oct 2010 I $150.00 $125.00 ----- -- --- ---------- !, $100.00 -_ --_ __ _ __ _ ----- --. __-- $75.00 -- -- -- - $50.00 _. _ __ _ _--- -- _ _---_ _ _ $25.00 -____ - - __ ,I $0.00 , Oct Nov Dec Jan Feb Mar Apr May Jun Jul ' Aug � Sep � Oct ' _ ___ - _ _ . _ _ - - lt Avg Rev PAR $93.12 � $81.82 , $81.45 $91.41 i $100.83 $106.66 i $90.15 , $91.25 $113.11 $106.83 � $94.09 i $90.11�$102.37