Loading...
HomeMy WebLinkAboutWS Item 04 - Monthly Financial Report . � � ��C MONTHLY FINANCIAL REPORT DECEMBER � � � ��I C FY 2011 FY 2010 FY 2009 General Fund [3ud et Actual Nercenta e Bud et Actual Percenta e Bud et Actual Percenta e Ad Valorem'I'axes 6,286,740 1,472,796 23.4% 7,567,717 2,246,864 29.7% 7,567,717 1,668,225 22.0% Sales Taxes 20,900,000 1,775,269 8.5% 21,250,000 I,575,26I 7.4% 23,400,000 I,691,987 7.2% Mixed Beverage Taxes 1,200,000 - 0.0% 1,202,000 - 0.0% 1,300,000 - 0.0% Franchise Fees 6,245,000 1,019,494 I 63% 6,179,086 939,943 I 5.2% 6,225,000 999,328 I6.I% Licenses& Permits 1,074,381 236,980 22.1% 1,003,821 199,225 19.8% 1,385,931 282,725 20.4% Charges for Services 7,550,010 689,932 9.1% 7,572,069 339,845 4.5% 7,547,575 815,190 10.8% Intergovernmental 78,639 4,980 63% 78,639 4,380 5.6% 78,552 3,780 4.8% Fines& Forfeitures 2,263,910 466,424 20.6% 2,243,528 428,683 19.I% 2,057,625 439,143 213% Transfers In 2,900,324 - 0.0% 3,105,975 - 0.0% 3,046,684 - 0.0% Miscellaneous 809,079 667,792 82.5% 956,309 304,154 31.8% 690,082 83,122 12.0% Total Revenues 49,308,083 6,333,666 12.8% 51,159,144 6,038,356 11.8% 53,299,166 5,983,499 1 L2% Personnel 24,840,208 5,514,165 22.2% 24,993,444 5,664,078 22.7% 24,648,980 5,533,477 22.4% Supplies 2,265,798 448,400 19.8% 2,366,763 600,196 25.4% 2,440,120 523,124 21.4% Maintenance 692,246 140,671 20.3% 693,269 171,965 24.8% 709,496 152,079 21.4% Services 6,736,956 1,181,905 17.5% 6,923,130 1,151,799 16.6% 7,297,871 1,228,745 16.8% Insurance 7,528,208 2,346,874 31.2% 7,728,453 2,445,248 31.6% 7,818,653 2,738,700 35.0% Transfers Out 7,244,667 - 0.0% 8,454,085 376 0.0% 9,887,450 - 0.0% Ca italOutla 0 - 0.0% 0 - 0.0% 45,000 1,672 3.7% Total Expenditures 49,308,083 9,632,014 19.5% 51,159,144 10,033,663 19.6% 52,847,570 10,177,796 19.3% MONTHLY FINANCIAL REPORT DECEMBER FY 2011 FY 2010 FY 2009 Utilit Enter rise Fund I3ud et Actual Percenta e Bud et Actual Percenta e l3ud et Actual Nercenta e Water Sales 1 1,698,848 2,470,554 21.1% 1 1,745,665 1,890,985 16.1% 11,745,665 2,000,865 17.0% Raw Water Sales 192,464 20,525 10.7% 192,464 5,557 2.9% 179,503 21,563 12.0% Water Tap Fees 25,000 5,875 23.5% 25,000 850 3.4% 50,000 2,325 4.7% Utility Inspection Fees 10,000 13,408 134.1% 13,000 5,487 42.2% 25,000 2,298 9.2% Reconnect&Transfer Charges 225,000 50,896 22.6% 225,755 55,661 24.7% 225,755 68,543 30.4% WastewaterSales 6,583,141 1,308,974 19.9% 6,901,150 1,294,965 18.8% 6,901,150 1,149,149 16.7% Wastewater Tap Fees 13,000 1,175 9.0% 13,367 - 0.0% 13,367 1,045 7.8% Sprinkler Service Fee - 4,410 NA - 15,392 NA - 11 1,331 NA lnterestonlnvestments 250,000 (13,202) -53% 472,191 (30,348) -6.4% 472,191 (27,685) -5.9% SaleofSalvage I,500 781 52.1% 1,500 1,311 87.4% 1,500 504 33.6% Sale of Material, Labor - - 0.0% 750 0.0% 750 1,826 243.4% Transfers In 63,012 - 0.0% 63,O12 0.0% 63,012 - 0.0% Miscellaneous 375,000 14,549 3.9% 375,000 2,909 0.8% 250,000 5,092 2.0% Total Revenues 19,436,965 3,877,944 20.0% 20,028,854 3,242,769 16.2% 19,927,893 3,336,856 16.7% Personnel 2,986,967 627,853 21.0% 2,939,933 674,173 22.9% 2,839,96 I 622,514 21.9% Supplies 843,357 113,993 13.5% 891,607 108,605 12.2% 931,111 131,783 14.2% Maintenance 414,778 117,577 28.3% 414,078 148,738 35.9% 414,078 93,921 22.7% Services 11,355,947 1,645,625 14.5% 10,733,027 1,309,045 12.2% 10,984,488 1,339,256 12.2% Debt Service 2,009,920 600 0.0% 2,749,318 (72,3 I S) -2.6% 2,737,954 (76,579) -2.8% Transfers Out 1,457,772 - 0.0% 2,068,05'7 - 0.0% 1,832,399 - 0.0% Permanent Capital Maint. 750,000 320,004 42.7% 750,000 42,599 5.7% 750,000 55,036 73% CapitalOutlay 368,700 - 0.0% 125,400 - 0.0% 125,400 - 0.0% Total Expenditures 20,187,441 2,825,651 14.0% 20,671,420 2,210,845 10.7% 20,615,391 2,165,930 10.5% Monthly Sales Tax Receipts General Fund $3,00O,OOU $2,500,000 _ _ ___ _ _- __ .-- _ _ __ $2,000,000 ------ _ . - — __ __ — II �ry< $1,SOO,UUO - - —- -- � i �'�$1,OOO,UOU � ��� — �� �� - — � �� I � � � $SOO,ODU — ;�� . . - t * 511 I __. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■2007 ■2008 ❑2009 ❑2010 ■201 1 I Updated Thru January 2011 Allocation _ . _ _ _ — - - - --- - - - - - - - - - - — - - I Top 20 Sales Taxpayer's 1,800,000 1,600,000 - - --- — _- -— _ - 1,400,000 - 1,200,000 - - — 1,000,000 - -- - - -- —_-- 800,000 600,000 400,000 , 200,000 ■February 2009 -January 2010 ■February 2010 -January 2011 � Sales Tax Strength Index 12-Month Average % Above / Below 36-Month Average 50.00% � � 40.00% 30.00% ' 20.00% 10.00% I 0.00% I -10.00% ' 00 O� O .r N M 7 � �O [� 00 O� O .-� N try R V) �O [� 00 O� O ap Op � � p� p� p� p� p� O� O� O� O O O O O O O O O O �--� u c� u u N u u u N c� u u u u u c� u u V u u N u C� C� CJ C� 0� C� C� Y W L N CJ N CJ CJ 6� 6� 0I C� 0� 0J Y 0� A A A A A A A L A A A A A A A A A A A A A A A Grapevine Unemployment Rate Nov 2009 - Nov 2010 ' Not Seasonally Adjusted I 8% 7% _ _ _ _ _ _ _ ___ _ I o _ __ __ __ _ __ _ _ - - _ __ 5 �o _ -_ 4% _ __ __ _ __ _ __._ _ _--__ _ ____ _ __ _ 3% _ _ _ _ ____ 1% _ _ __--- -- ' �% Nov-09 Dec-09 Jan-10 Feb-]0 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 i —�—Rate 6.1% '� 6.1% 6.7% 6.5% 6.4% , 6.4% 6.2% 6.6% 6.4% 6.3% 6.0% 6.3% 6.3% �, Grapevine Unemployment Rate �,, Jan 2005 - Present Not Seasonall Ad'usted g% , 7% _ _ -- _ _ __ . - II 5% _ __ ___ - 4% _ _ ___ II 3% _ __ __ _- 1% _ _ - _ --- _ ___ _ - -- �% I Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- , � OS OS OS OS 06 06 06 06 07 07 07 07 08 08 08 08 09 09 09 09 10 10 10 10 �'