Loading...
HomeMy WebLinkAboutWS Item 03 - Monthly Financial Report * V� ��� l Ci of Grapevine � Monthl Financial Report y August 2011 . ' . MONTHLY FINANCIAL RCPORT AucusT FY 2011 FY 2010 FY 2009 General Fund Bud et Actual Percenta e [3ud et Actual Percenta e Bud et Actual Percenta e Ad Valorem Taxes 6,286,740 8,169,956 130.0% 7,567,717 8,662,728 114.5% 7,567,717 7,558,800 99.9% Sales Taxes 20,900,000 17,257,683 82.6% 21,250,000 15,643,512 73.6% 23,400,000 15,574,337 66.6% Mixed Beverage Taxes 1,200,000 974,573 81.2% 1,202,000 928,832 77.3% 1,300,000 914,306 70.3% Franchise Fees 6,245,000 5,620,340 90.0% 6,179,086 5,664,672 91.7% 6,225,000 5,847,025 93.9% Licenses&Permits 1,074,381 960,976 89.4% 1,003,821 1,015,418 101.2% 1,385,931 1,017,536 73.4% Charges for Services 7,550,010 7,326,301 97.0% 7,572,069 7,556,957 99.8% 7,547,575 7,149,371 94.7% lntergovernmental 78,639 137,341 174.6% 78,639 78,734 100.1% 78,552 75,627 96.3% Fines& Forfeitures 2,263,910 1,531,010 67.6% 2,243,528 1,893,094 84.4% 2,057,625 1,981,366 96.3% Transfers [n 2,900,324 1,708,176 58.9% 3,105,975 2,321,181 74.7% 3,046,684 2,623,422 86.1% Miscellaneous 809,079 1,266,710 (56.6% 956,309 1,204,168 125.9% 690,082 786,635 114.0% Total Revenues 49,308,083 44,953,OGS 91.2% 51,159,14a 44,969,296 87.9% 53,299,166 43,528,426 81.7% Personnel 24,840,208 21,157,855 85.2% 24,993,444 21,178,032 84.7% 24,648,980 20,825,836 84.5% Supplies 2,265,798 1,921,407 84.8% 2,366,763 2,064,373 87.2% 2,440,120 2,019,661 82.8% Maintenance 692,246 578,002 83.5% 693,269 610,247 88.0% 709,496 560,785 79.0% Services 6,736,956 6,303,499 93.6% 6,923,130 6,010,504 86.8% 7,297,871 5,691,390 78.0% lnsurance 7,528,208 8,464,714 112.4% 7,728,453 7,869,639 101.8% 7,818,653 7,344,617 93.9% Transfers Out 7,244,667 4,444,667 61.4% 8,454,085 8,457,761 100.0% 9,887,450 3,887,450 393% Ca italOuNay 0 1,065 0.0% 0 34,813 NA 45,000 88,182 196.0% Total Expenditures 49,308,083 42,871,208 8G9% S1,159,144 46,225,37U 90.4% 52,847,570 40,417,922 76.5% MONTHLY FINANCIAL REPORT AUGUST FY 2011 FY 2010 FY 2009 Utility Enter rise Fund Bud et Actual Percentage l3udget Actual Percentage Bud et Actual Percenta e Water Sales 11,698,848 10,625,093 90.8% 11,745,665 9,177,586 78.1% ll,745,665 9,295,287 79.1% Raw Water Sales 192,464 123,572 64.2% 192,464 1 17,490 61.0% 179,503 135,771 75.6% Water Tap Fees 25,000 15,250 61.0% 25,000 30,896 123.6% 50,000 16,000 32.0% Utility lnspection Fees 10,000 21,597 216.0% 13,000 38,313 294.7% 25,000 9,334 37.3% Reconnect&Transfer Charges 225,000 171,755 763% 225,755 179,012 79.3% 225,755 194,918 863% Wastewater Sales 6,583,141 5,668,911 86.1% 6,901,150 5,405,907 783% 6,901,150 5,464,769 79.2% Wastewater Tap Fees 13,000 7,675 59.0% 13,367 2,155 16.1% 13,367 5,255 39.3% Sprinkler Service Fee - I 1,942 NA - 27,987 NA - 25,871 NA Interest on Inves[ments 250,000 35,768 14.3% 472,191 89,535 19.0% 472,191 185,747 39.3% Sale of Salvage 1,500 3,564 237.6% 1,500 3,227 215.1% 1,500 1,688 112.5% Sale of Material,Labor - 59,734 0.0% 750 1,270 1693% 750 2,757 367.6% TransfersIn 63,012 63,012 100.0% 63,012 63,012 100.0% 63,O12 63,012 100.0% Miscellaneous 375,000 745,590 198.8% 375,000 268,063 71.5% 250,000 542,435 217.0% Total Revenues 19,436,965 17,553,463 90.3% 20,028,854 15,404,455 76.9% 19,927,893 15,942,843 80.0% Personnel 2,986,967 2,363,570 79.1% 2,939,933 2,505,438 85.2% 2,839,961 2,452,711 86.4% Supplies 843,357 494,706 58.7% 891,607 528,710 59.3% 931,111 577,167 62.0% Maintenance 414,778 497,141 ll9.9% 414,078 570,497 137.8% 414,078 587,140 141.8% Services 11,355,947 8,462,520 74.5% 10,733,027 8,393,766 78.2% 10,984,488 8,151,602 74.2% Debt Service 2,009,920 2,011,477 100.1% 2,749,318 828,617 30.1% 2,737,954 465,021 17.0% Transfers Out 1,457,772 795,845 54.6% 2,068,057 1,695,438 32.0% 1,832,399 1,484,875 81.0% Permanent Capital Maint. 750,000 1,300,597 173.4% 750,000 1,953,888 260.5% 750,000 699,456 933% Ca ital Outlay 368,700 252,538 68.5% 125,400 19,758 15.8% 125,400 108,780 86.7% Total Expenditures 20,187,441 16,178,394 50.1% 20,G71,420 16,496,112 79.8% 20,615,391 14,526,751 70.5°/a Monthly Sales Tax Receipts General Fund $3,U00,000 $2,SUO,U00 _ _ --. _ _ ... $2,000,000 -- - — -- -_-- -- — __ --- - - ---- $1,SOO,OOU — — — - - - — j ` � ; $1,OOU,OUO - �' , � _ --- $SOO,U00 �, � .i , --_ ___.__ $0 � � , Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec [■2007 ■2008 ❑2009 ❑2010 ■201� Sales Tax Strength Index 12-Month Average % Above / Below 36-Month Average 50.00% 40.00% 30.00% � Z0.00% 10.00% 0.00% -10.00% OO 01 O �--� N M 7 � �D l� 00 01 O e-r N M 7 Vl �D l� 00 O� O �--I � � � � � � p� � p� � Q� O� O O O O O O O O O O � � cJ �J U V U N N U cJ N N c� tJ N V G u u V c�J t� U u G L V 6� 6� C� N V 6� CJ N 0J GJ 01 d 0l 0J CJ N Y Y N C� C7 C7 A A A A A A A A A A A A A A A A A A A Ca A A A A Grapevine Unemployment Rate August 2010 - August 2011 Not Seasonally Adjusted 8% 6% ----- ------- __ __ __ _ _ _ _ _ __ __ -- - _ _ . _ 4% -- -- - _ --- - _ 2% __ -_----- - --- ---------_ _ _ __ _. 0 � o Aug-10 Sep-10 ! Oct-10 Nov-10 Deo-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 �--�—Rate 6.3% 6.0% 6.3% 6.3% 6.2% 6.8% 6.5% 6.2% 5.8% 5.9% 6.4% 6.5% 6.4% Grapevine Unemployment Rate Jan 2005 - Present g% Not Seasonally Adjusted 6% __ _ __ __ _ _ _ _ -- - __ - _ - _ - 4% . _ ----- --_ _ -- ----_ __ _ _ 2% - -- -- __----- 0% � � � � � � � � � � � � � Jan- May- Sep- Jan- May- Sep- Jan- May- Sep- Jan- May- Sep- Jan- May- Sep- Jan- May- Sep- Jan- May- Sep- OS OS OS 06 06 06 07 07 07 08 08 08 09 09 09 10 10 10 11 11 11 Average Revenue Per Available Room July 2010 - July 2011 $150.00 $125.00 - __ --__ __ __-- __ __ _ - -___ _ ___ _ ----____ _ __-------- $100.00 - --___-------- - --_ ---- --- - __ - -- __ -- - $75.00 - -- -- - _ _ _ _ ----- _ - $50.00 - __- _ _ ____ __ __ ____- _ _ _ __ I �25.00 _ _ __ _ _ _ $0.00 Jul Aug �' Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul t Avg Rev PAR $106.83 $94.09 $90.11 $102.37 $97.00 $88.85 $89.73 $131.23 $117.73 $101.54 $103.04 $123.51 $118.42