Loading...
HomeMy WebLinkAboutWS Item 01 - Administrative Services Department UpdateCity of Grapevine Monthly Financial Report April 2011 MONTHLY FINANCIAL REPORT MARCH FY 2011 FY 2010 FY 2009 General Fund Budget Actual Percentage Budget Actual Percentage Budget Actual Percentage Ad Valorem Taxes 6,286,740 8,018,587 127.5% 7,567,717 8,521,129 112.6% 40.1% 7,567,717 23,400,000 7,349,858 8,627,376 97.1% 36.9% Sales Taxes 20,900,000 9,545,818 45.7% 53.5% 21,250,000 11202,000 8,522,941 573,029 47.7% 1,300,000 609,205 46.9% Mixed Beverage Taxes 1,200,000 6,245,000 641,782 4,317,959 69.1% 6,179,086 4,306,576 69.7% 6,225,000 4,438,343 71.3% Franchise Fees Licenses & Permits 1,074,381 436,669 40.6% 1,003,821 497,344 49.5% 1,385,931 504,506 36.4% 73.0% Charges for Services 7,550,010 5,578,662 73.9% 7,572,069 55881,177 77.7% 6.9% 7,547,575 78,552 5,507,101 3,780 4.8% Intergovernmental 78,639 9,408 898,091 12.0% 39.7% 78,639 2,243,528 5,430 936,011 41.7% 2,057,625 1,051,405 51.1% Fines & Forfeitures 2,263,910 2,900,324 544,834 18.8% 3,105,975 845,756 27.2% 3,046,684 1,238,958 40.7% Transfers In Miscellaneous 809,079 49,308,083 842,184 30,833,993 104.1% 62.5% 956,309 51,159,144 483,711 30,573,104 50.6% 59.8% 690,082 53,299,166 246,232 29,576,764 35.7% 55.5% Total Revenues Personnel 24,840,208 11,021,196 44.4% 24,993,444 11,013,489 44.1% 49.8% 24,648,980 2,440,120 10,850,494 1,126,446 44.0% 46.2% Supplies 2,265,798 954,819 42.1% 2,366,763 693,269 1,177,823 351,884 50.8% 709,496 314,103 44.3% Maintenance 692,246 6,736,956 311,672 2,999,272 45.0% 44.5% 6,923,130 2,850,753 41.2% 7,297,871 2,797,417 38.3% Services 7,528,208 4,623,486 61.4% 7,728,453 4,361,288 56.4% 7,818,653 4,377,347 56.0% Insurance Transfers Out 7,244,667 4,444,667 61.4% 8,454,085 8,454,461 100.0% 9,887,450 3,887,450 39.3% 105.8% Ca italOutlay 0 1,065 24,356,179 0.0% 49.4% 0 51,159,144 23,639 28,233,338 NA 55.2% 45,000 52,847,570 47,630 23,400,888 44.3% Total Expenditures 49,308,083 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 4,618,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 50,000 39,025 8,300 21.7% 16.6%' Water Tap Fees 25,000 10,075 40.3% 25,000 13,000 23,071 12,836 92.3% 98.7% 25,000 5,568 22.3% Utility lnspection Fees Charges 10,000 225,000 14,191 89,707 141.9% 39.9% 225,755 100,073 44.3% 225,755 114,699 50.8% Reconnect & Transfer 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 145,063 23.4% NA Sprinkler Service Fee - 7,538 14,613 NA 5.8% - 472,191 20,596 30,788 NA 6.5% 472,191 104,152 22.1% Interest on Investments 250,000 1,500 1,453 96.9% 1,500 2,603 173.5% 1,500 866 57.7% Sale of Salvage 25,009 0.0% 750 20 2.7% 750 1,832 244.3% Sale of Material, Labor - 63,012 63,012 100.0% 63,012 63,012 100.0% 63,012 63,012 100.0% Transfers In 375,000 20,727 5.5% 375,000 5,469 1.5% 250,000 9,333 3.7% Miscellaneous 19,436,965 7,681,294 39.5% 20,028,854 6,726,735 33.6% 19,927,893 7,278,481 36.5% Total Revenues 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% 41.3% 414,078 10,984,488 318,129 4,340,786 76.8% 39.5% Services 11,355,947 4,928,073 43.4% 30.0% 10,733,027 2,749,318 4,434,150 587,941 21.4% 2,737,954 328,359 12.0% Debt Service 2,009,920 1,457,772 603,116 292,129 20.0% 2,068,057 986,472 47.7% 1,832,399 867,590 47.3% Transfers Out Permanent Capital Maint. 750,000 496,610 66.2% 750,000 377,080 50.3% 750,000 116,247 15.5% 72.7% Capital Outlay 169 700 20,187,441 - 8,007,113 0.0% 39.7% 125,400 20,671,420 19,758 8,283,718 15.8% 40.1% 125,400 20,615,391 91,218 7,654,915 37.1% Total Expenditures MID -YEAR FINANCIAL REPORT AS OF MARCH 31 Budget FY 2010 Actual Percentage Budget FY 2009 Actual Percentage Convention &Visitors FY 2011 Bureau Fund Budget Actual Percentage Occupancy Taxes 10,437,365 4,721,815 45.2% 11,519,136 4,047,275 35.1% 49.2% 13,149,434 802,000 4,171,690 376,297 31.7% 46.9% Facility Rental Income 837,830 393,755 47.0% 838,000 26,000 412,494 5,601 21.5% 35,000 14,293 40.8% Interest Income 5,500 270,536 1,558 166,518 28.3% 61.6% 350,000 154,276 44.1% 336,600 163,829 48.7% Sales & Merchandise Train Operations 1,323,800 727,517 55.0% 1,438,372 823,438 57.2% 1,380,090 849,368 61.5% 7.6% Festivals & New Vintage 3,105,902 34,797 1.1% 2,926,276 365,531 12.5% 2,750,000 0 209,595 0.0% Visitor Shuttle System 144,000 28,792 20.0% 242,000 4,479 1.9% 55.7% 0 _ 0.0% Transfers In 362,299 179,673 49.6% 67.4% 270,553 197,105 150,608 537,628 272.8% 208,900 133,131 63.7% Miscellaneous 182,518 122,959 17,807,442 6,501,330 36.5% 18,662,024 5,918,204 31.7% 16,669,750 6,377,385 38.3% Total Revenues Personnel 4,821,625 2,097,730 43.5% 4,849,143 2,319,642 47.8% 41.3% 4,734,565 5,588,942 2,178,476 1,464,143 46.0% 26.2% Supplies 3,132,105 1,114,800 35.6% 3,853,762 162,152 1,593,316 60,067 37.0% 267,852 158,722 59.3% Maintenance 144,067 2,746,673 47,272 1,233,440 32.8% 44.9% 2,911,615 1,190,043 40.9% 5,079,300 2,154,686 42.4% Services Festival & Train Operation 3,169,637 647,118 20.4% 3,494,903 1,072,727 1,543,486 30.7% 54.0% 0 3,201,443 2,022,189 0.0% 63.2% Transfers Out 2,655,643 2,047,608 77.1% 2,860,024 0 654,622 NA 141,000 13,554 9.6% Capital Outlay 0 0.0% 18,131,599 8,433,902 46.5% 19,013,102 7,991,770 42.0% Expenditures 16,669,750 7,187,968 43.1% Total MID -YEAR FINANCIAL REPORT AS OF MARCH 31 Crime Control and Prevention Fund Budget FY 2011 Actual Percentage Budget FY 2010 Actual Percentage Budget FY 2009 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% 12,486,361 6,694,051 53.6% 12,271,735 6,320,577 51.5% MID -YEAR FINANCIAL REPORT AS OF MARCH 31 Budget 1,370,010 15,700 0 0 1,385,710 FY 2011 Actual 625,313 1,270 - - 626,583 Percenta a 45.6% 8.1% 0.0% 0.0% 45.2% Budget FY 2010 Actual Percenta a Budget FY 2009 Actual Percentage Stormwater Drainage Utility Fund 1,348,559 623,238 46.2% 18,000 3,825 21.2% 0 - 0.0% 0 80,989 NA 1,334,831 569,691 55,000 21,173 0 - 0 - 42.7% 38.5% 0.0% 0.0% Drainage Utility Fees Interest Income Transfers In Miscellaneous 1,366,559 708,052 51.8% 1,389,831 590,864 42.5% Total Revenues Personnel Supplies Maintenance Services Transfers Out Capital Outla 444,155 54,700 105,000 238,852 325,162 900,000 2,067,869 202,401 22,957 61,646 229,139 109,943 - 626,084 45.6% 42.0% 58.7% 95.9% 33.8% 0.0% 30.3% 431,074 59,700 105,000 273,970 467,677 300,000 193,443 17,875 13,810 262,910 271,786 13,083 44.9% 29.9% 13.2% 96.0% 58.1% NA 417,440 96,719 0 266,102 609,570 0 184,375 15,324 57,875 258,672 547,877 - 44.2% 15.8% NA 97.2% 89.9% 0.0% 1,637,421 772,908 47.2% 1,389,831 1,064,123 76.6% Total Expenditures MID -YEAR FINANCIAL REPORT AS OF MARCH 31 Lake Enterprise (Golf) Fund Budget FY 2011 Actual Percentage Budget FY 2010 Actual Percentage Budget FY 2009 Actual Percentage Cart Rentals 770,816 289,671 37.6% 864,692 222,110 25.7% 816,625 3,500 306,667 1,450 37.6% 41.4% Tournament Fees 3,500 1,300 49,704 37.1% 49.7% 3,500 50,000 1,300 12,233 37.1% 24.5% 25,000 8,298 33.2% Driving Range Golf Merchandise Sales 100,000 220,000 51,519 23.4% 21,000 4,284 20.4% 21,000 5,545 26.4% Golf Course Green Fees 1,800,000 614,066 34.1% 2,149,269 499,871 23.3% 1,882,060 45,000 681,226 10,497 36.2% 23.3% Restaurant % of Sales 45,000 10,207 22.7% 45,000 17,000 8,404 1,628 18.7% 9.6% 17,000 2,801 16.5% Lesson Income 15,000 800 2,513 1,550 16.8% 193.8% 3,600 403 11.2% 10,250 1,854 18.1% Interest Income Golf Sub -Lease 200,000 58,656 29.3% 220,000 40,708 18.5% 230,000 68,150 29.6% Miscellaneous 20,000 3,175,116 25,853 1,105,039 129.3% 34.8% 20,000 3,394,061 15,926 806,867 79.6% 23.8% 20,000 3,070,435 14,880 1,101,369 74.4% 35.9% Total Revenues 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% 61.3% Services 792,928 455,343 57.4% 702,032 433,916 61.8% 659,400 404,357 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% 0.0% Capital Outlay 0 3,150,07, - 1,544,713 0.0% 49.0% 0 3,184,039 - 1,518,329 NA 47.7% 0 3,070,435 - 1,291,804 42.1% Total Expenditures MID -YEAR FINANCIAL REPORT AS OF MARCH 31 Lake Parks Special Revenue Fund Budget FY 2011 Actual Percenta a Budget FY 2010 Actual Percenta a Budget FY 2009 Actual Percentage Boat Ramp Fees 150,000 40,121 26.7% 150,000 30,761 20.5% 140,000 35,009 25.0% 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% Personnel 133,589 61,749 46.2% 129,196 58,163 45.0% 113,287 55,019 48.6% 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% Services 819,630 291,477 35.6% 732,866 251,867 34.4% 428,759 212,289 49.5% Transfers Out 400,144 400,144 100.0% 219,250 219,250 100.0% 217,222 217,222 100.0% Capital Outlay Total Expenditures 0 1,515,363 - 894,464 0.0% 59.0% 0 1,186,312 - 602,840 NA 50.8% 0 837,568 - 534,778 0.0% 63.8% Sales Tax Monthly Collections January 1986 - Present $3,500,000 i $3,000,000 - i i I i $1,500,000 $1,000,000 -- i $500,000 - - - - -- $0 %10,b� SIls S`°4 "IsI Sales Tax Moving Averages January 1990 - Present $25100,000 $20,000000 -- — -- $15,000,000 ----- $10,000,000 $5,000,000 $ 0 oo y N N N N N N N N N N Q Q Q Q Q Q Q Q_ Q- Q-Q - Q- Q- Q Q 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% IIVV V —,W�-W 0.00% -10.00% 00 o N M d ,n r oo c c c o 0 0 0 0 0 0 00 00 OO01 tT 01 01 OOC1 � 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 v�� Grapevine Unemployment Rate March 2010 - March 2011 Not Seasonally Adjusted 0% Mar-10 Apr-10 May-10 Jun-10 Ju1 0 Aug-10 Sep_10 Oct-10 Nov-10 —i—Rate 6.4% 6.4% j 6.2% 6.6% 6.4% 6.3% 6.0% 6.3% 6.3% Dec-10 - Jan- 11 Feb-11 Mar- 11 _ 6.2% 6.8% 6.5% 6.2%- Sales Tax Moving Averages January 1989 - Present $25,000,00o $20,000,000 - -- -- — $15,000,000 $10,000,000 --- — $5,000,000 — -- I i $0 C CA w CA CA o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 h 4 ti Q h 4 h 4 h 4 A 4 ti ti h h ti 4 4 4 h ti ti h �12-Month Avg 36-Month Avg Mixed Beverage Tax Moving Averages $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 r 00 00 r'cn cn In 00 00 Cl C, n q q p q q 0� 0, Cl C) C) 0 0 [,"36 Month —24 Month 12 Month-.1 20.00% 15.00% 10.00% 5.00% 0.00% Mixed Beverage Tax Strength Index 12-Month Averalle % Above / Below 24-Month Average 00 00 O, O, O o N N M M CD o, � o 0 0, o o rn rn o 0 0 0 0 o O O CD o CDO a O a a i d 0 0 0 0 O d Mixed Beverage Tax Strength Index 12-Month Average % Above / Below 36-Month Average 25.00% 0.00%i° ° -5.00 /o o o 00 00 O1 m O O o rn o 0 0 0 0 0 0 0 0 0 o O d O o 0 o a OU d OU O O O Qa O d O d O Q O d 0