The URL can be used to link to this page

Home My WebLink AboutFS 2013-08-20 Item 2D - Review - Financial Planning Model - Attachment ATO: City of Tukwila Jim Haggerton, Mayor INFORMATIONAL MEMORANDUM Mayor Haggerton Finance and Safety Committee FROM: Peggy McCarthy, Finance Director DATE: August 14, 2013 SUBJECT: Financial Planning Model, Attachment A- Format ISSUE Review Attachment A of the Financial Planning Model for line item groupings and other formatting issues; include a key to give visibility to the account groupings of certain revenue line items pursuant to Council input at the July 17, 2013 Finance and Safety Committee meeting. BACKGROUND Attachment A is used as a planning and forecasting tool. The formatting and design objective of the Attachment is to present governmental financial data in a logical and easily understandable manner that assists analysis and highlights items that are of particular interest to the Council and other readers. A discussion of the presentation and format occurred at the July 17, 2013 Finance and Safety Committee meeting and a request was made to include a key on the face of the Attachment to give visibility to the account groupings of certain revenue line items. DISCUSSION The revised format more closely aligns the revenue line items and account groupings with those used in the City's internal quarterly financial reports and those prescribed by the Washington State Budgeting Accounting and Reporting System (BARS). A supporting schedule named "Attachment A — Revenue Detail" provides additional information on the components of each revenue line item. RECOMMENDATION For information only. ATTACHMENTS Attachment A, 2013 -2018, Reformatted August 2013 Attachment A - Revenue Detail, 2013 -2018 75 76 REFORMATTED AUGUST 2013 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 31 32 33 CITY OF TUKWILA ATTACHMENT A REVENUES & EXPENDITURES GOVERNMENTAL FUNDS 2013 - 2018 Analysis in 000's REVENUES (See A -1) BUDGET PROJECTIONS Totals 2013 -2018 2013 2014 2015 2016 2017 2018 General Revenues Sales and Use Taxes $ 15,299 $ 15,680 $ 15,915 $ 16,393 $ 16,884 $ 17,391 $ 97,562 Property Taxes 13,814 14,322 14,680 15,047 15,423 15,808 89,094 Utility Taxes 4,288 4,357 4,488 4,623 4,761 4,904 27,422 Interfund Utility Tax 1,486 1,586 1,665 1,748 1,835 1,927 10,247 Gambling and other taxes 2,709 2,819 2,861 2,903 2,947 2,991 17,230 RGRL 1,750 1,768 1,812 1,857 1,903 1,951 11,041 Licenses & permits 1,597 1,626 1,673 1,721 1,772 1,826 10,215 SCL Agreement, franchise fees 2,476 2,520 2,596 2,674 2,754 2,837 15,858 Intergovernmental 2,605 2,262 2,283 2,305 2,327 2,349 14,130 Charges for Services 2,954 3,036 3,127 3,221 3,317 3,417 19,072 Indirect cost allocation 2,036 2,085 2,148 2,212 2,279 2,347 13,106 One -time revenue 8,500 4,355 3,500 2,000 18,355 Sub -total 59,515 56,416 56,747 56,703 56,203 57,748 343,332 Dedicated Revenues (Capital) 881 837 823 845 870 897 5,153 TOTAL REVENUES 60,396 57,252 57,570 57,548 57,073 58,645 348,484 EXPENDITURES Operating & Maintenance (see Attachment B) 48,142 48,924 50,722 51,990 53,290 54,622 307,690 Debt Service 5,964 3,026 2,859 2,632 2,634 2,628 19,744 Reserve Fund 1,500 2,200 3 119 146 150 4,118 Operating transfers 475 675 323 329 316 283 2,401 Adm /Engineering 414 429 440 451 463 474 2,672 Subtotal Available 3,900 1,998 3,223 2,027 224 488 11,860 Capital Projects (Attachment C) Residential Street 551 255 2,380 500 500 500 4,686 Arterial Street 4,561 2,178 2,901 1,981 2,067 2,166 15,854 Land & Park Acquisition 147 97 147 38 40 41 510 Governmental Facilities 580 - - - - 580 General Government 478 200 200 200 200 200 1,478 Fire Improvements (50) (50) (50) (50) (50) (50) (300) Sub total Capital 6,267 2,680 5,578 2,669 2,757 2,857 22,808 Change in fund balance (2,367) (682) (2,355) (642) (2,533) (2,369) (10,948) Beginning fund balance 11,289 8,922 8,240 5,885 5,242 2,710 11,289 Ending Fund Balance $ 8,922 $ 8,240 $ 5,885 $ 5,242 $ 2,710 $ 341 $ 341 Reserve fund balance $ 3,000 $ 5,203 $ 5,206 $ 5,325 $ 5,470 $ 5,620 $ 5,620 Sales and Use Taxes - includes retail sales and use tax, natural gas use tax and criminal justice sales tax Gambling and other taxes - includes gambling tax, admission tax and leasehold excise tax Licenses & permits - icludes business licenses, residential rental licenses, building and other permits Intergovernmental - includes streamlined sales tax mitigation, grants, state shared revenues and entitlements Dedicated Revenues (Capital) - includes REET, Greenbelt property tax levy, parking tax, motor vehicle tax, investment income earned in the capital funds 2013 - 2018 Financial Planning Model VIII 08/Tif2013 78 2 3 4 5 6 7 8 9 10 11 12 13 14 15 ATTACHMENT A - REVENUE DETAIL, 2013 -2018 Analysis in 000's REVENUES (See A -1) BUDGET PROJECTIONS Totals 2013 -2018 2013 2014 2015 2016 2017 2018 General Revenues Sales and Use Taxes $ 15,299 $ 15,680 $ 15,915 $ 16,393 $ 16,884 $ 17,391 $ 97,562 Retail sales and use tax 14,629 15,010 15236 15,693 16,163 16,648 93,379 Natural gas use tax 290 290 294 303 312 321 1,808 Criminal justice 380 380 386 397 409 421 2,374 Other - - Property Taxes 13,814 14,322 14,680 15,047 15,423 15,808 89,094 Utility Taxes 4,288 4,357 4,488 4,623 4,761 4,904 27,422 Electric 1,620 1,669 1,719 1,770 1.,821 1,878 10,480 Gas 689 7111 731 753 775 799 4,456 Sold waste 149 349 :159 370 381 395 2,202 Cable 230 330 237 244 251 259 1,451 Telephone 1,400 1,400 1,442 1,483 1,530 1,576 8,833 Other - Interfund Utility Tax 1,486 1,586 1,665 1,748 1,835 1,927 10,247 Water 523 553 581 610 641 673 3,580 Sewer 578 609 639 671 705 740 3,942 Surface water 385 423 445 467 490 515 2,724 Gambling and other taxes 2,709 2,819 2,861 2,903 2,947 2,991 17,230 Gambling 2,038 2,148 2,170 2,191 2,213 2,236 12,997 Admissions 612 612 630 649 669 689 3,861 Leasehold 59 59 61 63 64 66 377 Other 0 0 0 (1 0 0 0 RGRL 1,750 1,768 1,812 1,857 1,903 1,951 11,041 Licenses & permits 1,597 1,626 1,673 1,721 1,772 1,826 10,215 Licenses 457 465 477 489 504 519 2,911 Business Licenses 422 410 441 452 465 479 2,690 Residential rental license 35 35 So 37 38 39 221 Permits 1,140 1,161 1,196 1,232 1,269 1,307 7,304 Eire permits 80 80 82 85 87 90 505 Building permit 615 627 646 666 685 706 3,945 Electrical permit 297 3(13 312 321 331 341 1,905 Mechanicalpermits 114 111.6 120 123 127 131 731. Plumbing and other permits 34 35 36 37 38 39 218 SCL Agreement, franchise fees 2,476 2,520 2,596 2,674 2,754 2,837 15,858 Seattle City Light agreement 2,206 2,250 2,318 2,388 2,459 2,533 14,154 Franchise fees, 270 270 278 286 295 304 1,703 Intergovernmental 2,605 2,262 2,283 2,305 2,327 2,349 14,130 Streamlined sales tax mitigation 1,166 1,200 1,200 1,200 1,200 1,200 7,166 Grants, State Shared Revenue 1,439 1,062 1,083 1,105 1,127 1,149 6,965 KC Basic Life. Safety Emergency 380 380 388 195 403 411 2,358 Fed grant - Transit Oriented Develc 143 - - - - 143 DOJ -COPS grant 20.2 32 32 33 34 34 368 State Liquor fees 218 181 183 189 '192 196 1,161 State Criminal justice 93 149 152 1.55 158 161 869 Law enforcement services 45 45 46 47 48 49 279 Commute trip reduction 66 45 46 47 48 49 320 Homeland Security EMPG 82 5-4 55 56 57 58 363 Other 188 176 180 183 187 191 1,105 Charges for Services 2,954 3,036 3,127 3,221 3,317 3,417 19,072 Security 580 605 623 642 661 681. 3,790 Transportation 167 169 174 179 185 190 1,064 Plan check fees 619 629 647 667 687 707 3,955 Culture, Rec fees 520 520 �.. ?J :2 757 365 545 Rents & concessions 405 405 417 430 443 456 2,557 Other 604 799 730 752 774 798 4,426 Indirect cost allocation 2,036 2,085 2,148 2,212 2,279 2,347 13,106 One -time revenue 8,500 4,355 3,500 2,000 18,355 Other - - 11,041 Sub -total 59,515 56,416 56,747 56,703 56,203 57,748 343,332 Dedicated Revenues (Capital) 881 837 823 845 870 897 5,153 REET 260 260 268 276 284 293 1,641 Prop Tax Greenbelt levy 34 - - - 34 Parking tax 151 151 156 160 '165 170 953 Motor Vehicle tax :374 :377 388 400 412 424 2,373 Investment income 21 9 9 9 9 10 67 Other 41 40 2 - - 83 TOTAL REVENUES 60,396 57,252 57,570 57,548 57,073 58,645 348,484 2013 - 2018 Financial Planning Model VIII 08/14/2013