Loading...
HomeMy WebLinkAboutWS Item 03 - Monthly Financial Report '- * ^ ���� /% MONTHLY FINANCIAL REPORT AUGUST //J� � � (�t/ FY 2010 FY 2009 I+Y 2008 Ceneral Fund Budget Actual Yercentage 13udget Actual Yercentage [3udget Actual Percenta e Ad Valorem Taxes 7,567,717 8,662,728 I 14.5% 7,567,717 7,558,800 99.9% 7,382,764 7,465,110 101.l% Sales Taxes 21,250,000 17,396,862 81.9% 23,400,000 17,210,597 73.5% 21,500,000 19,122,520 88.9% Mixed Beverage Taxes 1,202,000 928,832 773% 1,300,000 914,306 70.3% I,000,000 979,311 97.9% Franchise Fees 6,179,086 5,664,672 91.7% 6,225,000 5,847,025 93.9% 6,240,000 5,722,842 91.7% Licenses&Permits 1,003,821 1,015,418 101.2% 1,385,931 1,017,536 73.4% 1,602,31 l 1,170,391 73.0% Charges for Services 7,572,069 7,414,323 97.9% 7,547,575 7,149,371 94.7% 6,745,631 7,058,430 104.6% Intergovernmental 78,639 78,734 100.1% 78,552 75,627 96.3% 76,526 70,946 92.7% Fines&Forfeitures 2,243,528 1,893,094 84.4% 2,057,625 1,981,366 96.3% 1,663,080 1,933,542 116.3% Transfers In 3,105,975 2,026,966 653% 3,046,684 2,623,422 �6.1% 3,398,873 2,498,292 73.5% Miscellaneous 956,309 1,196,694 125.1% 690,082 7£�6,635 114.0% 518,000 1,203,707 232.4% Total Revenues 51,159,144 46,278,324 90.5% 53,299,166 45,1G4,686 84.7% 50,127,185 47,225,090 94.2% Personnel 24,993,444 21,178,032 84.7% 24,648,980 20,825,836 84.5% 22,968,400 19,451,974 84.7% Supplies 2,366,763 2,032,995 85.9% 2,440,120 2,019,661 82.8°/u 1,955,446 1,936,314 99.0% Maintenance 693,269 606,467 87.5% 709,496 560,785 79.0% 651,761 734,954 112.8% Services 6,923,130 6,009,542 86.8°/a 7,297,871 5,691,390 78.0% 5,450,343 5,682,607 104.3% Insurance 7,728,453 7,869,639 101.8% 7,818,653 7,344,617 93.9% 7,178,279 7,182,224 100.1% Transfers Out 8,454,085 8,457,761 100.0% 9,887,450 3,887,450 39.3% 11,922,956 3,617,745 30.3°/a CapitalOutlay 0 8,585 NA 45,000 88,182 196.0% - 11,400 NA Total Cxpenditures 51,159,144 46,163,021 90.2% 52,847,570 40,417,922 76.5% 50,127,185 38,617,219 77.0% �. MONTHLY FINANCIAL REPORT AucusT FY 2010 [+Y 2009 FY 2008 Utility Enterprise Fund t3udget Actual Percentage Badget Actual Percentage Bud et Actual Percenta e Water Sales 11,745,665 9,177,586 78.1% 11,745,665 9,295,287 79.1% 12,425,259 9,479,157 763% Raw Water Sales 192,464 117,490 61.0% 179,503 135,771 75.6% 176,407 117,770 66.8% Water Tap Fees 25,000 30,896 123.6% 50,000 16,000 32.0% 75,000 46,215 61.6% Utility Inspection Fees 13,000 33,313 294.7% 25,000 9,334 373% 48,000 49,453 103.0% Reconnect&Transfer Charges 225,755 179,012 793% 225,755 194,918 86.3% 262,000 213,168 81.4% WastewaterSales 6,901,150 5,405,907 78.3% 6,901,150 5,464,769 79.2% 6,753,878 5,400,559 80.0% WastewaterTapFees 13,367 2,155 16.1% 13,367 5,255 393% 25,000 8,845 35.4% Sprinkler Service Fee - 27,987 NA - 25,871 NA - - NA Interest on Investments 472,191 77,587 16.4% 472,191 185,747 39.3% 230,000 401,452 174.5% Sale of Salvage 1,500 3,227 215.1% 1,500 1,688 112.5% 1,500 2,797 186.5% Sale of Material, Labor 750 1,270 1693% 750 2,757 367.6% 750 3,519 4692% Transfers In 63,012 63,012 100.0% 63,012 63,012 100.0% - 63,012 NA Miscellaneous ** 375,000 267,976 7 LS% 250,000 542,435 217.0% 25,000 314,805 1259.2% Total Revenues 20,028,854 15,392,420 76.9% 19,927,893 15,942,843 �0.0% 20,022,794 16,100,751 80.4% Personnel 2,939,933 2,505,438 85.2% 2,839,961 2,452,71 1 86.4% 2,623,409 2,191,177 83.5% Supplies 891,607 526,338 59.0% 931,111 577,167 62.0% 721,980 674,409 93.4% Maintenance 414,078 568,490 137.3% 414,078 587,140 141.8% 402,321 456,568 113.5% Services 10,883,027 8,384,389 77.0% 10,984,488 8,151,602 742% ]0,154,805 8,734,505 86.0% Debt Service 2,749,318 82�,617 30.1% 2,737,954 465,021 17.0% 2,325,585 500,139 21.5% Transfers Out 2,068,057 1,535,426 74.2% 1,832,399 1,484,875 81.0% 2,505,032 1,280,731 51.1% Permanent Capital Maint. 750,000 1,953,888 260.5% 750,000 699,456 93.3% 1,000,000 2,669,526 267.0% CapitalOutlay 125,400 19,758 15.8% 125,400 108,780 86.7% I14,000 97,074 85.2% Total Gxpenditures 20,821,420 16,322,345 78.4% 20,615,391 14,526,751 70.5% 19,847,132 16,G04,130 83.7% ** Includes TRA Refunds of$240,968 received in June 2010, $527,478 received in June 2009 and$98,701 received 'ui July 2008. Monthly Sales Tax Receipts General Fund $3,000,000 ------- ----- ----- --- —----- -- --- $2,SOU,ODU $2,000,000 I $1,500,000 � — � a: i - n � ', ���UUU�UU�) _ .�' i I� i i $500,0011 ; � i I ! $0 � - - _ __ , - r Jan Feb Mar Apr May Jun Jul nub Sep Uct Nov Dec - -- - �■Zoo� s Zoo� o Zoog ❑Zoo9 ■Zo i o __ _ ----- - _ ___ I _ __ —__ -------- --- -- - - _ ----- - -— _ - -- -- _ _ _ _ --_ - ___ - Sales Tax Moving Averages i $25,000,00o January 1989 - Present $20,000,000 I $15,000,000 �$10,000,000 $5,000,000 $0 - O� O �--� N M 7 v'1 �O l� 00 T O .-. � � �p � �❑ � � � � � �C Q� O O O O O O�+ O O O O � r-�, r�, .-�-, � � � ❑ C ❑ td cd p ~ ti � � y y � � y � � y � y � � � �12-Month Avg —36-Month Avg Grapevine Unemployment Rate Jan 2006 - Present Not Seasonally Adjusted g% - --- __ 7% 6% 5% 4% 3% - 2% - ____ _ 1% _ _ _ �% � , � , , , , , Jan-06 Apr-06 Jul-06 Oct-06 Jan-07 Apr-07 Jul-07 Oct-07 Jan-08 Apr-08 Jul-08 Oct-08 Jan-09 Apr-09 Jul-09 Oct-09 Jan-10 Apr-10 Jul-10 -- -- --- - - i ��.+ ��-+ N N C�j� O CI� O C!� �I p O O C C ' i p O O O � il p O O O O p O O O O O Jan-06 Mar-06 May-06 ; � Jul-06 � Sep-06 Nov-06 'I Jan-07 I�Mar-07 May-07 � , Jul-07 � ! I j Sep-07 � ' I' � O I Nov-07 , ( o n Jan-08 � � i I Mar-08 ' �' b � i 'May-08 � � i Jul-08 `� I�] �' � I �'� Sep-08 � i I Nov-08 � ' i Jan-09 Mar-09 May-09 I� Jul-09 � Sep-09 I ; ', Nov-09 ' � � i Jan-10 I Mar-10 ' May-10 ' � Average Revenue Per Available Room June 2009 - June 2010 $iso.00 $125.00 _ _ _ _ - -- —-_ ___ $100.00 - _ -- -- - $75.00 _ - _ _ _ __ $50.00 $25.00 $0.00 Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun —_ -- — -- - --- -- - - - - — — -- — —♦--Avg Rev PAR $99.42 $101.31 $86.74 $84.66 $93.12 $81.82 $81 45 $91.41 $100.83 $106.66 $90.15 $91 25 $113.11 Mixed Beverage Tax Moving Averages $1,400,000 $1,200,000 $1,000,000 ." ,°�,�� $800,000 $600,000 $400,000 $200,000 •Dv �t�l 7 V vl Vl �O �O 1� [� 00 00 U O� O O ^ ^-� N N <*1 M V V Vl v1 �D �O [� l� 00 00 O� Q� O � � � � � � � p� � p� p� p� p� O O O O O O O O O O O O O O O O O O O O �--� � � � Q � � � Q � Q Q Q� � Q � Q Q Q� � � � � � � � Q � Q � Q � Q � � ��36 Month —�24 Month �"'12 Month