Loading...
HomeMy WebLinkAboutWS Item 01 - Administrative Services Department Update Ci'EGrapevineof Monthly Financial Report April 2011 MONTHLY FINANCIAL REPORT MARCH FY 2011 FY 2010 FY 2009 General Fund Budget Actual Percentage Budget Actual Percentage Budg et Actual Percentage Ad Valorem Taxes 6,286,740 8,018,587 127.5% 7,567,717 8,521,129 112.6% 7,567,717 7,349,858 97.1% Sales Taxes 20,900,000 9,545,818 45.7% 21,250,000 8,522,941 40.1% 23,400,000 8,627,376 36.9% Mixed Beverage Taxes 1,200,000 641,782 53.5% 11202,000 573,029 47.7% 1,300,000 609,205 46.9% Franchise Fees 6,245,000 4,317,959 69.1% 61179,086 4,306,576 69.7% 6,225,000 4,438,343 71.3% Licenses&Permits 1,074,381 436,669 40.6% 11003,821 497,344 49.5% 1,385,931 504,506 36.4% Charges for Services 7,550,010 5,578,662 73.9% 7,572,069 5,881,177 77.7% 7,547,575 5,507,101 73.0% Intergovernmental 78,639 9,408 12.0% 78,639 5,430 6.9% 78,552 3,780 4.8% Fines&Forfeitures 2,263,910 898,091 39.7% 2,243,528 936,011 41.7% 2,057,625 1,051,405 51.1% Transfers In 2,900,324 544,834 18.8% 3,105,975 845,756 27.2% 3,046,684 1,238,958 35.7% Miscellaneous 809,079 842,184 104.1% 956,309 483,711 50.6% 690,082 246,232 . % Total Revenues 49,308,083 30,833,993 62.5% 51,159,144 30,573,104 59.8% 53,299,166 29,576,764 555% Personnel 24,840,208 11,021,196 44.4% 24,993,444 11,013,489 44.1% 24,648,980 10,850,494 44.0% Supplies 2,265,798 954,819 42.1% 2,366,763 1,177,823 49.8% 2,440,120 1,126,446 46.2% Maintenance 692,246 311,672 45.0% 693,269 351,884 50.8% 709,496 314,103 44.3% Services 6,736,956 2,999,272 44.5% 6,923,130 2,850,753 41.2% 7,297,871 2,797,417 38.3% Insurance 7,528,208 4,623,486 61.4% 7,728,453 4,361,288 56.4% 7,818,653 4,377,347 56.0% 61.4% 8,454,085 8,454,461 100.0% 9,887,450 3,887,450 39.3% Transfers Out 7,244,667 4,444,667 Ca italOutlay 0 1,065 0.0% 0 23,639 NA 45,000 47,630 105.8% Total Expenditures 49,308,083 24,356,179 49.4% 51,159,144 28,233,338 55.2%1 52,847,570 23,400,888 44.3% i r. E'= MONTHLY FINANCIAL REPORT MARCH FY 2011 FY 2010 FY 2009 Utility Enterprise Fund Budget Actual Percentage Budget Actual Percentage Budget Actual Percentage Water Sales 11,698,848 49618,648 39.5% 11,745,665 3,724,293 31.7% 11,745,665 4,127,733 35.1% Raw Water Sales 192,464 42,535 22.1% 192,464 8,991 4.7% 179,503 3 ,300 21.6% 8 Water Tap Fees 25,000 10,075 40.3% 25,000 23,071 92.3% 50,000 , 00 16. % Utility Inspection Fees 10,000 14,191 141.9% 13,000 12,836 98.7% 25,000 5,568 22.3% Reconnect&Transfer Charges 225,000 89,707 39.9% 225,755 100,073 44.3% 225,755 114,699 50.8% Wastewater Sales 6,583,141 2,771,081 42.1% 6,901,150 2,733,513 39.6% 6,901,150 2,655,768 38.5% Wastewater Tap Fees 13,000 2,705 20.8% 13,367 1,470 11.0% 13,367 3,130 23.4% Sprinkler Service Fee - 7,538 NA - 20,596 NA 145,063 NA Interest on Investments 250,000 14,613 5.8% 472,191 30,788 6.5% 472,191 104,152 22.1% Sale of Salvage 1,500 1,453 96.9% 1,500 2,603 173.5% 1,500 866 57.7% Sale of Material,Labor - 25,009 0.0% 750 20 2.7% 750 1,832 244.3% Transfers In 63,012 63,012 100.0% 63,012 63,012 100.0% 63,012 63,012 100.0% Miscellaneous 375,000 20,727 5.5% 375,000 5,469 1.5% 250,000 9,333 3.7% Total Revenues 19,436,965 7,681,294 39.5% 20,028,854 6,726,735 33.6% 19,927,893 7,278,481 36.5% Personnel 2,986,967 1,248,489 41.8% 2,939,933 1,331,638 45.3% 2,839,961 1,269,184 44.7% Supplies 843,357 209,658 24.9% 891,607 252,324 28.3% 931,111 323,403 34.7% Maintenance 414,778 229,039 55.2% 414,078 294,355 71.1% 414,078 318,129 76.8% Services 11,355,947 4,928,073 43.4% 10,733,027 4,434,150 41.3% 10,984,488 4,340,786 39.5% Debt Service 2,009,920 603,116 30.0% 2,749,318 587,941 21.4% 2,737,954 328,359 12.0% Transfers Out 1,457,772 292,129 20.0% 2,068,057 986,472 47.7% 1,832,399 867,590 47.3% Permanent Capital Maint. 750,000 496,610 66.2% 750,000 377,080 50.3% 750,000 116,247 15.5% Ca italOutlay 368,700 - 0.0% 125,400 19,758 15.8% 125,400 91,218 72.7% 8,283,718 40.1% 20,615,391 7,654,915 Total Expenditures 20,187,441 8,007,113 39.7% 20,671,420 37.1% j'; MID-YEAR FINANCIAL REPORT AS OF MARCH 31 Convention&Visitors FY 2011 FY 2010 FY 2009 Bureau Fund Budget Actual Percentage Budget Actual Percentage Budget Actual Percentage Occupancy Taxes 10,437,365 4,721,815 45.2% 11,519,136 4,047,275 35.1% 13,149,434 4,171,690 31.7% 393,755 47.0% 838,000 412,494 49.2% 802,000 376,297 46.9% Facility Rental Income 837,830 Interest Income 5,500 1,558 28.3% 26,000 5,601 21.5% 35,000 14,293 40.8% Sales&Merchandise 270,536 166,518 61.6% 350,000 154,276 44.1% 336,600 163,829 48.7% Train Operations 1,323,800 727,517 55.0% 1,438,372 823,438 57.2% 1,380,090 849,368 61.5% 1.1% 2,926,276 365,531 12.5% 2,750,000 209,595 7.6% Festivals&New Vintage 3,105,902 34,797 Visitor Shuttle System 144,000 28,792 20.0% 242,000 4,479 1.9% 0 0.0% Transfers In 362,299 179,673 49.6% 270,553 150,608 55.7% 0 0.0% Miscellaneous 182,518 122,959 67.4% 197,105 537,628 272.8% 208,900 133,131 63.7% Total Revenues 16,669,750 6,377,385 38.3% 17,807,442 6,501,330 36.5% 18,662,024 5,918,204 31.7% Personnel 4,821,625 2,097,730 43.5% 4,849,143 2,319,642 47.8% 4,734,565 2,178,476 46.0% Supplies 3,132,105 1,114,800 35.6% 3,853,762 1,593,316 41.3% 5,588,942 1,464,143 26.2% Maintenance 144,067 47,272 32.8% 162,152 60,067 37.0% 267,852 158,722 59.3% Services 2,746,673 1,233,440 44.9% 2,911,615 1,190,043 40.9% 5,079,300 2,154,686 42.4% 1,072,727 30.7% 0 0.0% Festival&Train Operation 3,169,637 647,118 20.4% 3,494,903 Transfers Out 2,655,643 2,047,608 77.1% 2,860,024 1,543,486 54.0% 3,201,443 2,022,189 63.2% Capital Outlay 0 0.0% 0 654,622 NA 141,000 13,554 9.6% Total Expenditures 16,669,750 7,187,968 43.1% 18,131,599 8,433,902 46.5% 19,013,102 7,991,770 42.0% E! Ii; MID-YEAR FINANCIAL REPORT AS OF MARCH 31 Crime Control and FY 2011 FY 2010 FY 2009 Prevention Fund Budget Actual Percentage Budget Actual Percentage Budget Actual Percentage Sales Taxes 10,450,000 4,462,148 42.7% 10,625,000 4,066,355 38.3% 11,700,000 4,102,514 35.1% Interest Income 5,000 2,284 45.7% 25,000 1,675 6.7% 66,016 13,629 20.6% Transfers In 2,185,000 2,100,000 96.1% 1,450,000 1,462,284 100.8% 0 - 0.0% Miscellaneous 0 (132) NA 0 9,949 NA 0 - 0.0% Total Revenues 12,640,000 6,564,300 51.9% 12,100,000 5,540,263 45.8% 11,766,016 4,116,143 35.0% Personnel 9,374,015 4,277,642 45.6% 9,358,376 4,322,503 46.2% 9,324,302 4,168,711 44.7% Supplies 506,137 194,056 38.3% 639,452 270,797 42.3% 675,218 251,226 37.2% Maintenance 120,800 55,631 46.1% 122,800 75,334 61.3% 134,400 75,378 56.1% Services 2,126,995 1,847,590 86.9% 2,164,433 1,855,414 85.7% 2,016,015 1,745,462 86.6% Transfers Out 0 - 0.0% 155,800 155,800 100.0% 79,800 79,800 100.0% Capital Outlay 109,080 18,170 0.0% 45,500 14,204 NA 42,000 - 0.0% Total Expenditures 12,237,027 6,393,088 52.2%1 12,486,361 6,694,051 53.6% 12,271,735 6,320,577 51.5% F MID-YEAR FINANCIAL REPORT AS OF MARCH 31 Stormwater Drainage FY 2011 FY 2010 FY 2009 Utility Fund Budget Actual Percentage Budget Actual Percentage Budget Actual Percentage Drainage Utility Fees 1,370,010 625,313 45.6% 1,348,559 623,238 46.2% 1,334,831 569,691 42.7% Interest Income 15,700 1,270 8.1% 18,000 3,825 21.2% 55,000 21,173 38.5% Transfers In 0 - 0.0% 0 - 0.0% 0 - 0.0% Miscellaneous 0 - 0.0% 0 80,989 NA 0 - 0.0% Total Revenues 1,385,710 626,583 45.2% 1,366,559 708,052 51.8% 1,389,831 590,864 42.5% Personnel 444,155 202,401 45.6% 431,074 193,443 44.9% 417,440 184,375 44.2% Supplies 54,700 22,957 42.0% 59,700 17,875 29.9% 96,719 15,324 15.8% Maintenance 105,000 61,646 58.7% 105,000 13,810 13.2% 0 57,875 NA Services 205,000 229,1396146 95.9% 273,970 262,910 96.0% 266,102 258,672 97.2% Transfers Out 325,162 109,943 33.8% 467,677 271,786 58.1% 609,570 547,877 89.9% Capital Outlay 900,000 - 0.0% 300,000 13,083 NA 0 - 0.0% 1,389,831 1,064,123 76.6% Total Expenditures 2,067,869 626,084 30.3% 1,637,421 772,908 47.2% 1- MID-YEAR FINANCIAL REPORT AS OF MARCH 31 Lake Enterprise FY 2011 FY 2010 FY 2009 (Golf)Fund Budget Actual Percentage Budget Actual Percentage Budget Actual Percentage Cart Rentals 770,816 289,671 37.6% 864,692 222,110 25.7% 816,625 306,667 37.6% 1,300 37.1% 3,500 1,300 37.1% 3,500 1,450 41.4% Tournament Fees 3,500 Driving Range 100,000 49,704 49.7% 50,000 12,233 24.5% 25,000 8,298 33.2% 23.4% 21,000 4,284 20.4% 21,000 5,545 26.4% Golf Merchandise Sales 22Q000 51,519 Golf Course Green Fees 1,800,000 614,066 34.1% 2,149,269 499,871 23.3% 1,882,060 681,226 36.2% Restaurant%of Sales 45,000 10,207 22.7% 45,000 8,404 18.7% 45,000 10,497 23.3% Lesson Income 15,000 2,513 16.8% 17,000 1,628 9.6% 17,000 2,801 16.5% Interest Income 800 1,550 193.8% 3,600 403 11.2% 10,250 1,854 18.1% Golf Sub-Lease 200,000 58,656 29.3% 220,000 40,708 18.5% 230,000 68,150 29.6% Miscellaneous 20,000 25,853 129.3% 20,000 15,926 79.6% 20,000 14,880 74.4% Total Revenues 3,175,116 1,105,039 34.8% 3,394,061 806,867 23.8% 3,070,435 1,101,369 35.9% Personnel 1,351,234 580,609 43.0% 1,447,976 584,013 40.3% 1,413,882 601,380 42.5% Supplies 238,158 81,185 34.1% 235,323 57,704 24.5% 249,184 67,913 27.3% Maintenance 101,481 26,931 26.5% 82,681 26,987 32.6% 75,481 65,346 86.6% Services 792,928 455,343 57.4% 702,032 433,916 61.8% 659,400 404,357 61.3% Debt Service 428,175 358,893 83.8% 425,888 333,687 78.4% 453,959 70,313 15.5% Transfers Out 238,096 41,752 17.5% 290,139 82,022 28.3% 218,529 82,497 37.8% Capital Outlay 0 - 0.0% 0 - NA 0 - 0.0% Total Expenditures 3,150,072 1,544,713 49.0% 3,184,039 1,518,329 47.7% 3,070,435 1,291,804 42.1% k? I MID-YEAR FINANCIAL REPORT AS OF MARCH 31 Lake Parks Special FY 2011 FY 2010 FY 2009 Revenue Fund Budget Actual Percenta a Budget Actual Percenta a Budget Actual Percentage 150,000 30,761 20.5% 140,000 35,009 25.0% Boat Ramp Fees 150,000 40,121 26.7% Pavilion Fees 55,000 22,556 41.0% 55,000 19,085 34.7% 25,000 16,036 64.1% Camping Fees 1,050,000 516,413 49.2% 730,000 420,516 57.6% 590,000 443,497 75.2% Entrance Fees 270,000 54,214 20.1% 230,000 44,526 19.4% 30,000 8,270 27.6% Transfers In 0 - 0.0% 0 - 0.0% 0 - 0.0% Interest&Miscellaneous 30,000 20,667 68.9% 22,000 8,827 40.1% 123,610 5,375 4.3% Total Revenues 1,555,000 653,972 42.1% 1,187,000 523,715 44.1% 908,610 508,188 55.9% 129,196 58,163 45.0% 113,287 55,019 48.6% Personnel 133,589 61,749 46.2% Supplies 113,000 96,951 85.8% 79,000 47,178 59.7% 60,800 32,659 53.7% Maintenance 49,000 44,143 90.1% 26,000 26,383 101.5% 17,500 17,589 100.5% 732,866 251,867 34.4% 428,759 212,289 49.5% Services 819,630 291,477 35.6% Transfers Out 400,144 400,144 100.0% 219,250 219,250 100.0% 217,222 217,222 100.0% Capital Outlay 0 - 0.0% 0 - NA 0 - 0.0% 50.8% 837,568 534,778 63.8% Total Expenditures 1,515,363 894,464 59.0% 1,186,312 602,840 Sales Tax Monthly Collections January 1986 - Present $3,500,000 $3,000,000 - - il I $1,500,000 - - _- --- - _ - $1,000,000 -- - -- - ---- - $500,000 - - - - -- $0 Sales Tax Moving Averages January 1990 - Present $25,000,000 $20,000,000 -- — -- $15,000,000 ----- $10,000,000 $5,000,000 -- — $0 v-, oo�o rn o .-, N m v -n �o r oo rn o p� p .-. N M ItC� O� p O O O O O O O O O y N N N N N N N N N N N N N N N N N N N --.Q__ Q Q_ Q Q Q Q 12-Month Avg 24-Month Avg 36-Month Avg 48-Month Avg J - -- — Sales Tax Strength Index 12-Month Average % Above / Below 36-Month Average 50.00% � 40.00% 30.00% i 20.00% 10.00% 0.00% -10.00% 00 o N M d ,n r 00 c c c o 0 0 0 0 0 0 00 00 O� O� 01 tT 01 01 O O O I V u U U y d d Y Y d aui d A A A A A A A A A A A A A A A A A A A AA A A i Monthly Sales Tax Receipts General Fund $3,000,000 $2,500,000 I r $2,000,000 i $1,500,000 ` $1,000,000 $500,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2007 2008 02009 02010 ■201� • f i11 Ill • i1 / 11 —Pt � 11 � 1 y 10 If ,tIN IN � h l / 111 a - % y I Grapevine Unemployment Rate March 2010 - March 2011 Not Seasonally Adjusted 7% - S% - 4% - 3% - 1% LRate�� � Far-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 6.4% 6.4% 6.2 6.3% 6.0% 6.3% 6.3% 6.2% 6.8% 6.5%% 6.6% 6.4% 6.2% Grapevine Unemployment Rate Jan 2005 - Present Not Seasonall Ad'usted �8% 7% S% �4% 3% 1% 0% ay-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 Jan-OS May-OS Sep-OS Jan-06 May-06 Sep-06 Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 M Sales Tax Moving Averages January 1989 - Present $25,000,000 r $20,000,000 - -- -- — $15,000,000 $10,000,000 --- — $5,000,000 — -- I i $0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Hj y h 73 h h ti h ti ti h h h h ti h h ti ti h [i 2 Month Avg 36-Month Avgj Average Revenue Per Available Room Feb 2010 - Feb 2011 $150.00 $125.00 $100.00 $75.00 $50.00 $25.00 $0.00 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb $90.11 $102.37 $97.00 $88.85 $89.73 $13L23 r-w —Avg Rev PAR $100.83 $106.66� $90.15 $91.25 $113.11 $106.83 1 $94.09 Mixed Beverage Tax Moving Averages $1,400,000 $1,200,000 $1,000,000 - -- $800,000 - - i $400,000 $0 r t� o0 0o rn rn o 0 <n I v InN o o r' 0O 00 °, °, o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 rn rn rn C, o 0 0, rn rn rn o, T C, c o o 7� o a a p O O Q O Q O Q O d O O O Q O O O Q O Q O Q O -0 Q Q O Q O Q "36 Month 24 Month 12 Month Mixed Beverage Tax Strength Index 12-Month Average % Above / Below 24-Month Average 20.00% 00,�\ ............... ............ . . . . . . . . . . . . . . . 0.00% -5.00% N N f�1 M d' V' V1 �A �O �O l� [� 00 00 Q, � O O 0 00 00 C, 0, O O o rn rn rn rn 00 00 o, rn o 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 CC 4 Mixed Beverage Tax Strength Index 12-Month Average % Above / Below 36-Month Average 25.00% 0.00% -s.00 i° n r 00 a0 O� O� O O ON C o o 0 0 0 0 0 0 0 0 0 o O d O CD 0 o a OU d OU O O J O Q O O Q O d 0 d O O Qa O d O d 0 Q 0 d