Loading...
HomeMy WebLinkAboutWS Item 01 - Monthly Financial Update � ��� `���G /�� MONTHLY FINANCIAL REPORT � OCTOBER FY 2011 FY 2010 FY 2009 General Fund Bud et Actual Percenta e Bud et Actual Percenta e Budget Actual Percenta e Ad Valorem Ta�ces 6,286,740 100,562 1.6% 7,567,717 2,126 0.0% 7,567,717 50,830 0.7% 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 (7,303) -0.1% 6,179,086 815,299 13.2% 6,225,000 866,083 13.9% Licenses&Permits 1,074,381 81,701 7.6% 1,003,821 68,669 6.8% 1,385,931 154,800 11.2% Charges for Services 7,550,010 176,683 2.3% 7,572,069 155,484 2.1% 7,547,575 157,145 2.1% Intergovernmental 78,639 2,160 2.7% 78,639 540 0.7% 78,552 - 0.0% Fines&Forfeitures 2,263,910 175,162 7.7% 2,243,528 162,059 7.2% 2,057,625 112,197 5.5% Transfers In 2,900,324 - 0.0% 3,105,975 - 0.0% 3,046,684 - 0.0% Miscellaneous 809,079 112,592 13.9% 956,309 57,567 6.0% 690,082 5,855 0.8% Total Revenues 49,308,083 641,557 1.3% 51,159,144 1,261,744 2.5% 53,299,166 1,346,9ll 2.5% Personnel 24,840,208 1,460,483 5.9% 24,993,444 1,698,029 6.8% 24,648,980 1,576,469 6.4% Supplies 2,265,798 59,158 2.6% 2,366,763 175,637 7.4% 2,440,120 152,765 6.3% Maintenance 692,246 46,236 6J% 693,269 39,715 5.7% 709,496 33,535 4.7% Services 6,736,956 196,077 2.9% 6,923,130 196,391 2.8% 7,297,871 160,791 2.2% Insurance 7,528,208 387,555 5.1% 7,728,453 834,701 10.8% 7,818,653 954,291 12.2% 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 2,149,509 4.4% 51,159,144 2,944,850 5.8% 52,847,570 2,877,852 5.4°/a � � MONTHLY FINANCIAL REPORT OCTOBER FY 2011 FY 2010 FY 2009 Utilit Enter rise Fund Bud et Actual Percenta e Bud et Actual Percenta e Bud et Actual Percenta e Water Sales 11,698,848 627,234 5.4% 11,745,665 461,669 3.9% 11,745,665 162,090 1.4% Raw Water Sales 192,464 - 0.0% 192,464 1,337 OJ% 179,503 9,436 5.3% Water Tap Fees 25,000 2,600 10.4% 25,000 - 0.0% 50,000 900 1.8% Utility Inspection Fees 10,000 - 0.0% 13,000 1,512 11.6% 25,000 1,195 4.8% Reconnect&Transfer Charges 225,000 21,032 9.3% 225,755 25,016 11.1% 225,755 24,257 l OJ% WastewaterSales 6,583,141 292,634 4.4% 6,901,150 301,820 4.4% 6,901,150 85,207 1.2% Wastewater Tap Fees 13,000 120 0.9% 13,367 0.0% 13,367 765 5.7% Sprinkler Service Fee - 1,602 NA - 1,863 NA - 77,944 NA Interest on Investments 250,000 - 0.0% 472,191 (30,348) -6.4% 472,191 (27,685) -5.9% Sale of Salvage 1,500 - 0.0% 1,500 591 39.4% 1,500 271 18.1% 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 513 0.1% 375,000 870 0.2% 250,000 1,260 0.5% Total Revenues 19,436,965 945,735 4.9% 20,028,854 764,331 3.8% 19,927,893 335,642 1.7% Personnel 2,986,967 172,100 5.8% 2,939,933 198,619 6.8% 2,839,961 172,173 6.1% Supplies 84.i,357 13,821 1.6% 891,607 21,938 2.5% 9�1,111 48,859 5.2% Maintenance 414,778 24,303 5.9% 414,078 81,606 19.7% 414,078 22,862 5.5% Services 11,355,947 103,800 0.9% 10,733,027 148,919 1.4% 10,984,488 282,215 2.6% 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 3,270 0.2% 1,832,399 - 0.0% Permanent Capital Maint. 750,000 - 0.0% 750,000 - 0.0% 750,000 9,602 13% Ca ital Outla 368,700 - 0.0% 125,400 - 0.0% 125,400 - 0.0% Total Expenditures 20,187,441 314,623 1.6% 20,671,420 382,037 1.8% 20,615,391 459,133 2.2% r � Monthly Sales Tax Receipts General Fund $3,000,000 $2,500,000 - __- _ $2,000,000 _ __ _ _ i « $1,>00,000 — _ �- � j �. I$1,000,000 i r - . $500,000 ,. '' – + I I 5 1 ���� ��f . _ � � �, _._ -� . _ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■Zoo6 s 200� ❑Zoos ❑Zoo9 ■Zo 10 . ; Sales Tax Strength Index 12-Month Average % Above / Below 36-Month Average 50.00% 40.00% � ; I ,ry 30.00% `� 20.00% 4 r.��� �' 10.00% ��-? � � �_ 0.00% ,��� ,: -10.00% -- - O� O N M '7 �!1 �O l� 00 O� O �-• N M V' �1 �O I� 00 O� O pp p� O� p� p� Q� O� O� Q❑� Q� O� O O O O O O O O O O �--� C C Q � G � cd � cd � cd cd � � cC C cct cd � � cC c�i cd cd c0 cC cO cd cO a3 cC cd ai cC �--, i-y �. �. ti �. �. �-. �--. �. �. �-. ti ti r-. r-o '-.. ti �-. ►� �. ti I � Sales Tax Moving Averages $Zs,000,000 •T - �Zo,000,000 — _ _ _ _-- ---- — -_ i $15,000,000 _ _ _ -_ _ -- _ . $10,000,000 - - . _ - --_ __ --- - - $5,000,000 -- -__- _--- •D O O� O �+ N M � v� �O [� 00 O� O N M � v"� �O l� 00 O� O pp p� p� p� p� p� p� O� O� O� O� O O O O O O O O O O c�0 � cC � c�C cd c�d c�d cCd R l�d c�d N fd � cd � c0 � c�d cd � �-s ti ti �. �. � �, ti �. ti ti �--. �. �-> ti �-. ti �. �, �-�• �-, �12-Month Avg —36-Month Avg ! � 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 �__ _-_ --- .-- ----_ _ _ r._.. _ _._ ._ __ _,.- _ .._ . _ , -� �`��,� ���� `��� ��G,� P��� ��� ,�.�� ,��� �o'���. ����t G�°��t ����t O�G� �a ���o �` Q� ����, p o� � � December 2008 - November 2009 ■ December 2009 - November 2010 , , Sales Tax History on Seven Selected Restaurants 25,000 20,000 --- _-- - -------- ---------------- - ' � -+-#1 1 15,000 -------------- ------------------ -: #2 � - ------ --- -- . _ ------ -- _-----___------ --- #4 �-#5 ' -e-#6 10,000 - - — - - � -+-#7 ___ _, --__,,: _. , , _ '' - ---__.-" ''-,.,�_ ____ � ,,...�, � .��' , ^-'-. - 5,000 O� O� O� O� O� O� O� O� O� O� O� O� O°� O� O°� O� O� O� �O ,�O �O r�0 �O ��'o PQ�� ��� �o, p�'` O�° ��'° Q'Qt ���� P�� QG�' O�G ���° Q,Q�� ���� Q.J� OG� QQ'G ���° PQ� ��� Q,�°� �°�. P I � Grapevine Unemployment Rate Jan 2005 - Present g% Not Seasonally Adjusted 7% _ _ _ -- _ __ ---_ --- _ __. 5% _ -- _ . . _ _ ___ _ _ _ _ __ __ 4% - - --- - -- __ ___ _ ------- _ - - - _ ---- _ _ _ 3% - _ _- -- _ 1% - _ _--- ------ - -- - - - 0% Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- Jan- Apr- Jul- Oct- Jan- Apr- Jul- OS OS OS OS 06 06 06 06 07 07 07 07 08 08 08 08 09 09 09 09 10 10 10 I � . � Average Revenue Per Available Room Aug 2009 - Aug 2010 $150.00 $125.00 -- ---- -__- -- ---- $100.00 __ __ _-- . _ _ -- --- ----- -__ _ __-- �-_._ $75.00 _ _ --- - __ ___ _ __ i �, $50.00 _ _ __ - --- -- . _ - - _-- - -__ _ __ __ _ $25.00 _ . --- - ____ _ ------- __- - $0.00 Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug tAvg Rev PAR $86.74 $84.66 $93.12 $81.82 $81.45 $91.41 $100.83 $106.66 $90.15 $91.25 $113.11 $106.83 $94.09