Loading...
HomeMy WebLinkAboutWS Item 01 - Monthly Financial Update r , /0//a /�� �! MONTHLY FINANCIAL REPORT /, � �� SEPTEMBER �v FY 2010 FY 2009 FY 2008 Utilit Enter rise Fund Bud et Estimate Percenta e Bud et Actual Percenta e Budget Actual Percentage Water Sales 11,745,665 10,708,729 91.2% ll,745,665 11,107,330 94.6% 12,425,259 11,687,149 94.1% Raw Water Sales 192,464 117,490 61.0% 179,503 147,701 82.3% 176,407 131,459 74.5% Water Tap Fees 25,000 31,496 126.0% 50,000 17,915 35.8% 75,000 46,315 61.8% Utility Inspection Fees 13,000 38,313 294.7% 25,000 13,761 55.0% 48,000 54,149 112.8% Reconnect&Transfer Charges 225,755 200,695 88.9% 225,755 215,770 95.6% 262,000 233,893 893% Wastewater Sales 6,901,150 5,991,096 86.8% 6,901,150 6,293,932 91.2% 6,753,878 6,429,801 95.2% Wastewater Tap Fees 13,367 3,120 233% 13,367 7,100 53.1% 25,000 8,845 35.4% Sprinkler Service Fee - 29,416 NA - - NA - - NA Interest on Investments 472,191 140,000 29.6% 472,191 238,852 50.6% 230,000 460,394 200.2% Sale of Salvage 1,500 3,821 254.7% 1,500 1,983 132.2% 1,500 2,797 186.5% Sale of Material,Labor 750 1,270 1693% 750 3,507 467.6% 750 4,644 619.2% Transfers In 63,012 63,012 100.0% 63,012 63,012 100.0% - 63,012 NA Miscellaneous ** 375,000 270,203 72.1% 250,000 550,517 220.2% 25,000 175,416 701.7% Total Revenues 20,028,854 17,598,661 87.9% 19,927,893 18,661,380 93.6% 20,022,794 19,297,874 96.4% Personnel 2,939,933 2,858,052 97.2% 2,839,961 2,794,390 98.4% 2,623,409 2,511,001 95.7% Supplies 891,607 587,718 65.9% 931,111 704,911 75.7% 721,980 825,143 1143% Maintenance 414,078 357,446 86.3% 414,078 373,579 90.2% 402,321 369,690 91.9% Services 10,883,027 9,647,432 88.6% 10,984,488 9,737,817 88.7% 10,154,805 10,081,269 99.3% Debt Service 2,749,318 2,765,470 100.6% 2,737,954 3,173,190 115.9% 2,325,585 2,406,624 103.5% Transfers Out 2,068,057 1,952,053 94.4% 1,832,399 1,730,138 94.4% 2,505,032 1,519,790 60.7% Permanent Capital Maint. 750,000 363,578 48.5% 750,000 387,285 51.6% 1,000,000 388,727 38.9% Ca italOutla 125,400 91,394 72.9% 125,400 - 0.0% 114,000 - 0.0% Total Expenditures 20,821,420 18,623,143 89.4% 20,615,391 18,901,310 91.7% 19,847,132 18,102,244 91.2% ** Includes TRA Refunds of$240,968 received in June 2010; $527,478 received in June 2009 and$98,7011 received in July 2008. MONTHLY FINANCIAL REPORT SEPTEMBER FY 2010 FY 2009 FY 2008 General Fund Bud et Estimate Percenta e Bud et Actual Percenta e Bud et Actual Percenta e Ad Valorem Taxes 7,567,717 8,654,014 114.4% 7,567,717 7,615,206 100.6% 7,382,764 7,491,597 101.5% Sales T�es *** 21,250,000 21,290,000 100.2% 23,400,000 20,595,865 88.0% 21,500,000 22,922,623 106.6% Mixed Beverage Taxes 1,202,000 1,225,967 102.0% 1,300,000 1,188,431 91.4% 1,000,000 1,294,801 129.5% Franchise Fees 6,179,086 6,115,585 99.0% 6,225,000 6,318,671 101.5% 6,240,000 6,295,317 100.9% Licenses&Permits 1,003,821 1,115,146 111.1% 1,385,931 1,079,178 77.9% 1,602,311 1,220,657 76.2% Charges for Services 7,572,069 7,799,862 103.0% 7,547,575 7,433,671 98.5% 6,745,631 7,322,278 108.5% Intergovernmental 78,639 78,914 1003% 78,552 77,157 98.2% 76,526 246,105 321.6% Fines&Forfeitures 2,243,528 2,121,707 94.6% 2,057,625 2,208,111 1073% 1,663,080 2,197,098 132.1% Transfers In 3,105,975 2,713,139 87.4% 3,046,684 2,928,488 96.1% 3,398,873 2,997,567 88.2% Miscellaneous 956,309 1,379,594 144.3% 690,082 996,354 144.4% 518,000 1,44'7,793 279.5% Total Revenues 51,159,144 52,493,929 102.6% 53,299,166 50,441,132 94.6% 50,127,185 53,435,836 106.6% Personnel 24,993,444 24,430,682 97.7% 24,648,980 23,870,555 96.8% 22,968,400 22,393,316 97.5% Supplies 2,366,763 2,367,339 100.0% 2,440,120 2,184,285 89.5% 1,955,446 2,194,098 112.2% Maintenance 693,269 675,573 97.4% 709,496 620,864 87.5% 651,761 836,135 128.3% Services 6,923,130 7,780,210 112.4% 7,297,871 7,144,129 97.9% 5,450,343 7,100,960 130.3% Insurance 7,728,453 8,184,692 105.9% 7,818,653 8,149,704 104.2% 7,178,279 8,065,866 112.4% Transfers Out 8,454,085 9,004,085 106.5% 9,887,450 8,537,732 863% 11,922,956 12,117,745 101.6% Ca ital Outla 0 5,996 NA 45,000 114,444 2543% - 38,212 NA Total Expenditures 51,159,144 52,448,577 102.5% 52,847,570 50,621,713 95.8% 50,127,185 52,746,332 105.2% *** Sales ta�c estimate for FY 2010 includes projected September collections of$2.2 million which will be received in November. Monthly Sales Tax Receipts General Fund $3,000,000 ', I'� II I $2,500,000 --------- _ _ � $2,000,000 -- — $1,500,000 - – i $1,000,000 1I $500,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■2006 ■2007 �2008 ❑2009 ■2010 Grapevine Unemployment Rate Jan 2005 - Present g% Not Seasonall Ad'usted �% F 4 5 o ------- ____ ____— --- ----- �o ----_ ��� � I 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 _ c� sA cs� rs� c�i� o ci o cn'i� 0 0 0 0 0 ' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Jan-06 ' Mar-06 May-06 '� Jul-06 Sep-06 Nov-06 Jan-07 Mar-07 ' May-07 Jul-07 '� !� � O � � � Sep-07 i ' � I � � Nov-07 � D , C� Jan-08 o n o � Mar-08 � � ; � b A� May-08 ' i � � Jul-08 � � � y Sep-08 � Nov-08 � � Jan-09 , I Mar-09 ; � May-09 , �, Jul-09 � Sep-09 I ; Nov-09 � I � i Jan-10 Mar-10 '! ' May-10 I! Jul-10 ! i ; Hotel Occupancy Taxes ! Jan 2008 - Present $25,000,000 i$20,000,000 -- ----- -- --- _ _--_- -- -- - - _;' �I � $15,000,000 -- __ - _ __ _ � $10,000,000 � I $5,000,000 � $0 , , 00 00 00 00 00 0o ao 00 0o ao 00 00 0, o, c, o� o, o� o� o, a o, o, o, o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .� � � �-. � � .� � � � � � � _ � � � � � � � � � � � _ � � � � � � � � � � � _ c°e � e a ea � ° � � � o � e°e � c�"e o. e�'a � ° � a�i � o � � � e a. �c � o I ti G:, � Q � h � � r� O z A � w � Q � ti "' Q v� O z A ti �, � � � �, '� Mixed Beverage Tax Strength Index 12-Month Average % Above / Below 24-Month Average Zo.00�io is.00�io -- -- 1 o.00�ro s.00�io o.00�ro -s.00�io M M R � v� �n �O �O t� 1� 00 W O� O� O O N N M �"1 � R �n �n �O �O 1� l� oo ao O� O� O O O� O� O� O� Q� O� O� O� O� O� T Q� Q� O� O O OC O O O O O O O O O O O O O O O O O � � � � F � � 3 � 3 � � � � � � cd � � � � � � � � 3 � 3 � � � 3 � � � � ^. '"' � '"'' ^. '� '-. '""' '-. "' '� " �--. '_' ^� '"' � '_' ^-. '""' '—. ^ "'y ^ �+ `-' '--, ^' ^. ^' '-y ^' ^. ^' '--� ^ Average Revenue Per Available Room July 2009 - July 2010 $150.00 $125.00 � I $100.00 __--- --------- ----__ - I� $75.00 - -- - $50.00 $25.00 $0.00 , '�� Jul � Aug ' Sep Oct Nov Dec ��� Jan Feb Mar Apr May �, Jun Jul -�Avg Rev PAR $101.31 $86.74 $84.66 $93.12 $81.82 $81.45 $91.41 $100.83 $106.66 $90.15 $91.25 $113.11 $106.83 CITY OF GRAPEVINE,TEXAS FY 2009-10 FISCAL YEAR BUDGETARY COMPARISON SCHEDULE Funds 115,215&216 Fund 116 Fund 117 Fund 119 Convention&Visitors Bureau Stormwater Drainage Utility Crime Control&Prevention Lake Parks Special Revenue REVENUES Budaet Estimate PctQ. Budeet Estimate Pcta. Budaet Est�mate Pcta. BudQet Estimate Pcta. AND OTHER FINANCING SOURCES: Property Taxes Sales&Use Taxes 10,625,000 ]0,100,000 95.I% OccupancyTaxes 11,519,136 9,813,034 852% Licenses,Fees&Permits 1,348,559 1,305,185 96.8% 1,165,000 1,183,953 101.6% Charges for Sernces 5,794,648 4,883,528 84.3% 20,000 27,107 135.5% InterestIncome 26,000 ]0,209 39.3% 18,000 12,736 70.8% 25,000 3,779 15.]% Transfers In 270,553 287,422 106.2% 1,450,000 2,016,134 139.0% Miscellaneous 197,105 748,583 379.8% 78,756 NA 11,943 NA 2,000 9,873 493 7% TotalRevenues 17,807,442 15,742,776 884% 1,366,559 1,396,677 102.2% 12,100,000 12,131,855 ]003% 1,187,000 1,220,933 102.9% EXPENDITURES Budaet Estimate PCYE. Budaet Estimate Pct¢. Budaet Est�mate Pcte. Budeet Est�mate Pcta AND OTHER FINANCING USES. Personnel 4,849,143 5,179,489 106.8% 431,074 430,407 99.8% 9,358,376 9,201,247 983% 129,196 126,993 98.3% Supplies 3,853,762 3,113,574 80.8% 59,700 35,351 59.2% 639,452 618,675 96.8% 79,000 145,627 184.3% Maintenance 162,152 97,267 60.0% 105,000 61,300 58.4% 122,800 83,375 67.9% 26,000 42,686 1642% Services 6,406,518 5,470,919 85.4% 273,970 268,497 98.0% 2,164,433 2,087,408 96.4% 732,866 701,336 95.7% Intergovemmental Debt Service Transfers Out 2,830,024 2,020,118 71.4% 467,677 469,454 100.4% 155,800 155,800 100.0% 219,250 219,250 ]00.0% PCMF/PSMF 30,000 14,960 49.9% CapitalOutlay 745,051 NA 300,000 60,000 20.0% 45,500 36,163 79.5% Total Expenditures 18,131,599 16,641,378 91.8% 1,637,421 1,325,009 80.9% 12,486,361 12,182,669 97.6% 1,186,312 1,235,893 104.2% NOTE Yeaz-end estimates aze incomplete as all receivables and payables have not yet been recorded. Page 1 of 2 CITY OF GRAPEVINE,TEXAS FY 2009-10 FISCAL YEAR BUDGETARY COMPARISON SCHEDULE Funds 120&122 Fund 130 Fund 174 Fund 210 4B Economic Development Debt Service Permanent Capital/Street Maintenance Lake Enterprise(Gol� REVENUES Budaet Estimate Pcta. BudQet Estimate PCtg, Budeet Estimate Pctu Budaet Estimate Pcts. AND OTHER FINANCING SOURCES: Property Taxes 10,523,916 11,771,292 111 9% Sales&Use Taxes 10,625,000 10,549,796 99.3% Occupancy Taxes L�censes,Fees&Permits 220,000 143,193 65.1% Charges for Services 3,150,461 2,171,268 68 9% Interestlncome 92,500 45,177 48.8% 175,000 46,313 26.5% 15,155 NA 3,600 986 27.4% Transfers In 2,419,341 1,747,277 72 2% 2,315,000 2,315,000 ]00 0% Miscellaneous 6,899,001 NA 20,000 21,613 ]08.1% Total Revenues ]0,717,500 ]0,�94,973 98.9% 13,118,2�7 2Q463,883 156.0% 2,315,000 2,330,155 ]00.7% 3,394,061 2,337,060 68.9% EXPENDITURES Budeet Estimate Pcta. BudQet Estimate PCtg Bud¢et Estimate PCig. Bud et Est�mate PCYg AND OTHER FINANCING USES. Personnel 1,447,976 1,385,107 95.7% Supplies 235,323 186,746 79.4% Maintenance 82,681 75,018 90.7% Services 75,000 50,710 67.6% 7,000 121,563 1736.6% 702,032 645,283 91.9% Intergovemmental 7,950,639 7,053,503 88.7% Debt Service 13,653,688 19,606,970 143.6% 425,888 432,270 101.5% Transfers Out 469,752 483,697 103.0% 290,139 210,985 72.7% PCMF/PSMF 2,315,000 2,156,580 932% CapitalOutlay 24,017 NA Total Expenditures 8,495,390 7,611,927 89.6% 13,660,688 19,728,533 144.4% 2,315,000 2,156,580 932% 3,184,039 2,935,409 92.2% NOTE: Year-end estimates aze incomplete as all receivables and payables have not yet been recorded. Page 2 of 2