Loading...
HomeMy WebLinkAboutItems Distributed at the Meerting . , ~ - ~ crrY oF -Y * Interoffice Memorandum ~ * y ~ WASHINGTON To: City Council From: Shelley Coleman, Finance Director CC: Pete Lewis, Mayor Date: June 21, 2010 Re: Budget Amendment Summary Worksheet Attached is the 2010 Summary Worksheet of Budget Amendments that presents the , original adopted budget by fund and the impact of each budget amendment to date. Each ofi the budget amendments include changes that are necessary as new grants are awarded and to budget for any unanticipated revenues and expenses that arise, but the main focus fior each are as follows: The Midterm correction (BA #4) was made to adjust the original budget to reflect the s economic changes that have occurred since the biennial budget was adopted in December 2008. Budget Amendment 45 was pnmarily to carry forward capital expenditures and corresponding revenues. The proposed Budget Amendment #6 main focus is to adjust the estimated beginning fund balance or working capital of all funds to correspond to the actual fund balances after the completion of the City's finaneial report audit. riVBURN * MORE THAN YOU IMAGINED 2010 Budget Adjustments Summary Beg. Fund 2010 Ending Fund Balance 2010 Revenues Expenditures Balance General Fund Adopted Budget 10,844,270 52,522,400 57,184,700 6,181,970 BA # 4 197,837 (3,416.601) (3,179,015) (39,749) BA # 5 220,350 (484,650) 705.000 Proposed BA # 6 2,195.745 540.000 491,900 2,243,845 Adjusted Budget 13.237,852 49.866,149 54,012.935 9,091.066 Arterial Street Fund Adopted Budget 383,062 16,730,000 16,753,000 360,062 BA # 4 1,590,100 (2,977,000) 4,567,100 BA # 5 108,800 2,322,500 2,431,300 Proposed BA # 6 748,801 (6,974,300) (2,305,700) (3,919,799) Adjusted Budget 1,240.663 13,668,300 13,901,600 1,007,363 Local Street Fund Adopted Budget 604,641 2.363,600 2.200,000 768,241 BA # 4 (704,600) (700,000) (4,600) BA # 5 703,800 703,800 Proposed BA # 6 180,165 180,165 ' Adjusted Budget. 1,488,606 1,659,000 2,203,800 943,806 Hotel/Motel Fund Adopted Budget 32,600 85,700 85,500 32,800 BA # 4 (100) (100) BA # 5 68,000 48,540 85,880 30.660 Proposed BA # 6 76 76 Adjusted.Budget 100.676 134.140 171,380; , 63;436 Arterial Street Preservation Fund Adopted Budget 27,000 1,527,500 1,500,000 54,500 BA # 4 (22,500) (22,500) BA # S 105,000 105,000 Proposed BA # 6 4,589 4,589 Adjusted Budget 136,589 1,505,000 1,605,000 36.589 DruQ Forfeiture Fund Adopted Budget 414,107 215,000 237,300 391,807 BA # 4 (10,000) (10,000) Proposed.BA # 6 331,640 153,600 178,040 Adjusted Budget . , . 745,747 _ 205,000 _ _ _39D,900 559.847 ' 1 2010 Budget Adjustments Summary Beg. Fund 2010 Ending Fund Balance 2010 Revenues Expenditures Balance Local Law Enforcement Block Grant Fund Adopted Budget 12,261 11,100 11,100 12,261 Proposed BA # 6 3,157 3,157 Adjusted Budget _ 15,418 11,100 11.100 15,418` Housing & Communitv Development Grant Fund Adopted Budget 10.231 600,900 600,900 10.231 BA # 4 (6,500) 6.500 Proposed BA # 6 23.578 23,578 Adjusted Budget 33,809 600,900 594,400 40,309 Recreational Trails Fund Adopted Budget 45,294 7,900 - 53,194 BA # 4 (500) (500) BA # 5 44,000 (44,000) Proposed BA # 6 (317) (317) Adjusted Budget 44,977 7,400 44,000 8,377 Business Improvement Area Fund Adopted Budget 70,958 55,100 54,000 72,058 BA # 4 (1,700) (1,700) Proposed BA # 6 (25.662) (25,662) Adjusted Budget 45,296: 53,400 54,000 44,696 Cumulative Reserve Fund Adopted Budget 5,371,268 146,000 - 5.517,268 BA # 4 (106,000) 388,000 (494.000) BA # 5 65.500 (65,500) Proposed BA # 6 (10.581) (10.584) Adjusted Budget. ; 5,360.687 `40,000 453.500 : 4,947,187 Mitigation Fees Fund Adopted Budget 4.588.145 910,000 2.508,500 2,989.645 BA # 4 (106,000) (758,700) 652,700 BA # S 722,800 722,800 Proposed BA # 6 660.649 1,186,900 (526.251) Adjusted Budget 5,971,594 804,000 3,659,500 3,116,094 2 2010 Budget Adjustments Summary Beg. Fund 2010 Ending Fund Balance 2010 Revenues Expenditures Balance 1998 Library Fund Adopted Budget 43.310 305.300 304,300 44,310 BA # 4 (4,800) (4.800) Proposed BA # 6 (5,564) 2,301,500 2,301,500 (5,564) Adjusied Budget 37,746 2,602,000 2,605,800 33,946 LlD Guarantee Fund Adopted Budget 51,823 1,200 11,000 42,023 BA # 4 (900) (900) Proposed BA # 6 776 65,801 44,300 22,277 Adjusted Budgei 52.599 66,101 55,300 63,400 Municipal Park Construction Fund Adopted Budget 2,728,979 868,100 3.569,700 27.379 BA # 4 (1,854,950) 6.293,200 3,699,000 739,250 BA # 5 108,500 259.300 367,800 Proposed BA # 6 (330,861) 425,200 433,000 (338,661) Adjusted Budget 651,668 7.845,800 8,069.500 427,968 Capital lmprovements Fund Adopted Budget 4,968,834 2,314,600 1.130,100 6,153,334 BA # 4 24,883.190 29,682.253 (4,799,063) BA # 5 1,298,900 33,200 1,292,100 40,000 Proposed BA # 6 3,502,959 201,400 2,058,100 1,646,259 'Ad)usfied Budget 9,770,693: 27.432;390 34;162.553 3;040530 Local Revitalization Fund Adopted Budget - - - - . Proposed BA # 6 10.963,500 10,355,300 608,200 Adjusted Budget „ - 10,963,500 10;355,300 608.200- Water Fund Adopted Budget 1,506,766 14,462,900 14.613,100 1,356,566 BA # 4 5,007,500 (180.000) 5,013.680 (186,180) BA # 5 1,567,200 1,523,200 44.000 Proposed BA # 6 1,634,013 46,000 600,000 1,080,013 Ad,jjusted Budget 9,715,479 14,328,900 21749,980 ' 2.294,399 3 2010 Budget Adjustments Summary Beg. Fund 2010 Ending Fund Balance 2010 Revenues Expenditures Balance Sewer Fund Adopted Budget 5,618,692 15,887,800 19,846,300 1,660,192 BA # 4 5,252,500 (65.000) 2,403,280 2,784,220 BA # 5 1.347,200 1,288,900 58,300 Proposed BA # 6 (1,467,368) (1,467,368) Adjusted Budget 10,751.024 15,822,800 23,538,480 3,035,344 Storm Drainage Fund Adopted Budget 1,530,347 8,589,000 8,702,500 1,416,847 BA # 4 2,037,230 (35,000) 2,172,205 (169,975) BA # 5 682,300 566,200 116,100 Proposed BA # 6 1,508,310 1,142,700 365,610 Adjusted Budget 5,758,187 8,554,000 12,583,605 1,728,582 Solid Waste Fund Adopted Budget 1,389,385 11,954.400 12,246.100 1,097,685 BA # 4 (60,000) (305) (59,695) BA # 5 (500,000) (500.200) 200 Proposed BA # 6 10,516 (2,256,100) (2,007,800) (237,784) Adjusted Budget 1,399,901 9,138,300 9,737,795 800,406 Airport Fund Adopted Budget 717,186 704.900 667,100 754,986 BA # 4 (28,000) (2,400) (25,600) Proposed BA # 6 220,756 50,000 170,756 Adjusted Budget ' 937,94~ : 670;900 794,700- _ 900,142 Cemetery Fund Adopted Budget 404,465 968,300 995,400 377.365 BA # 4 (17,700) (34,130) 16,430 BA # 5 5,500 5,500 Proposed BA # 6 (93.467) (93,467) Adjusted Budget 316.498 9509600. 966.770 300,328 Golf Course Fund Adopted Budget 61,900 2,098,000 2,141,700 18,200 BA # 4 (1,400) (81,835) 80,435 BA # 5 133,500 (100,000) (76,500) 1109000 Proposed BA # 6 33 33 Acljusted 195,4.31 1,995,600 1.983,365 . 2bg,C6$ , 4 2010 Budget Adjustments Summary Beg. Fund 2010 Ending Fund Balance 2010 Revenues Expenditures Balance Commercial Retail Fund Adopted Budget 141,424 - - 141,424 Proposed BA # 6 508,853 508,853 Adjusted Budget 650,277 - - 650,277 Insurance Fund Adopted Budget 2.649,918 78.400 78,000 2,650,318 BA # 4 (70,400) (70.400) BA # 5 238,600 238.600 Proposed BA # 6 (415.449) (415,449) Adjusted Budget 2,234,469 246,600 78,000 2,403,069 Facilities Fund Adopied Budget 162,100 2,591,200 2,425,500 327,800 BA # 4 173,310 210,110 (36,800) BA # 5 (44,200) 25,400 (69,600) Proposed BA # 6 86,139 86.139 Adjusted Budget 248,239 2,720,310 2,661.010 307,539 lnformation Services Fund Adopted Budget 2,136,910 5.270.900 5,546,500 1,861,310 BA # 4 (1.346,300) (1,129.820) (216.480) BA # 5 58,800 (96,300) (155,100) Proposed BA # 6 1,762,347 15.700 1,746,647 Adjusted Budget _ 3,899,257 3,983.400 , 4,336,080 3,546,577:. , Equipment Rental Fund Adopted Budget 3,845,356 3.337,500 4,009.800 3.173,056 BA # 4 (840.400) (126,625) (713.775) BA # 5 12.900 (115.600) 128,500 Proposed BA # 6 1,433,673 (519.200) 1,952,873 Adjusted Budget 5,291,929 2,497;100 3,248,375 4,540,654 Fire Pension Fund Adopted Budget 2.850.268 147,000 169.600 2.827.668 BA # 4 (57,000) (40,200) (16,800) Proposed BA # 6 (21,626) (21,626) ;Adlusted Budget 2.$28,642 : . . . 90,000 129,400 _2,7$9,242 5 2010 Budget Adjustments Summary Beg. Fund 2010 Ending Fund Balance. 2010 Revenues _Expenditures Balance Cemetery Endowment Fund Adopted Budget 1,570,050 127,000 30,300 1,666,750 BA # 4 (50,000) (50,000) Rroposed BA # 6 (63,688) (63,688) Adjusted Budget ' 1 506".367 ; ir 77 000 30 300,- 1 553,`,062, ~..x.,.,_ . . Total Budget 84:668.259 178,546,690 214,108,428 49,106,521 6 21'2-,al C) . . Near Term Funding Puyallup River General Investigation New Start Distribution of Local Match Fixed Contributions Annual Revenue Target: $500;000_ % of Total Not to Exceed , Pierce Couni $250,000 50.0% $1,500,000.00 WSDOT $50,000 10.0% $300,000.00 Pori of Tacoma $50,000 10.0% $300,000.00 Pu allu Tribe of Indians FCAAP GraMs . Rail Roads , Remainder for City Contributlan: $ 150,000 Floodplain Taxable Value 8 Major Public Distributed Contributions Assets Annual General Fund Budget Population** Overall 00 .p e n axa e Value &'Major Puhlic Wefghted Annual General Weighted _ Weighted Weighted Community Assets % of Tutal % Fund 8udget °k of Total % Population*" % of Total °h Share Contribution AUbUrrl . $ ; 0i00% 0100°k $ 61;591;270 16.75% 6.70% 6,605 2.41% 0.48% 7.18% 1$ 10,775 2.2% $64,652.21 BuCkle $ 728,500 0.02% 0101% $ 4,112;543' 1.12% 0.45% 4;560 1:87% 0.33°k 0.79% 1,183 0.2% $7,099.93 Fife $ 1,470,668,814 40:80% 1632°k $ 14;274,056 3.88% 1.55°k 7,525 2:75% 0;55% 18:42%'$ - 27,634 . 5.5% $165,802.15 Ortin $ 302,691,192 8.40% 3.36% $ 3,236,866 0.88% 0.35% 6,075 2.22°k 0.44% 4:16%.$ 6,233 1:2% $37,396.16 PaCIfIC $ 704,900 0.02°k 0:01% $ 3;559,640 0.97% 0.39% 105 0.04% 0.01% 0.40% $ 604 0.1% $3,624.86 Pu allu $ 429,067,476 11:90% 4.76% $ 56,461,596 15.90% 6.36°k 36,930 1150% 2.70%. 13:82% $ 20,732 4.1% $124,392.04 Sumner 1$ 597,127,785 16:57°k 6.63% $ 7;857,305` 2.14% 0.85% 9,060 3.31% 0.66°/u 8.14% $ 12,295 ' 2.4% $73,289.44 TaCOma $ 803,725,872 22.30% 8.92% $ 214,578,100 58.36% 23.34°k 202700 74.10% 14:82% 47:08% $ 70,624 14.1% $423,743.21 Total $ 3,604,714,539 100% 40% $ 367,871,378, 100°h 40% 273;660 100% 20%; 100%`S 160,000 30.0% $900,000.00 Wei htin Factors Notes: $3,900,000.00 Flood lain Texable'Value 90:09°l0 2008 Values ' General'Fund 40.00% "2008 Census Po ulation 20.00% This distribulion is only for tfie near term costs associated with the local match for the initial Corps:siudy: 100.00% Distribuiion of the long term Flood control.capifal costs wiil use a differeni distri6ution, potentially County-wide, including contnbutions from additional municipalities GI Local Funding Distribution v2 w percent'of total:xis 6/2112010