The URL can be used to link to this page

2013, 06-18 Workshop Special Mtg AGENDA SPOKANE VALLEY CITY COUNCIL SPECIAL MEETING BUDGET Workshop Tuesday, June 18,2013 9:30 a.m.—4:30 p.m. City Hail Council Chambers 11707 E. Sprague, Spokane Valley, Washington Please Silence Your Cell Phones During the Meeting WELCOME: Mayor Towey Workshop Overview—Mike Jackson Budget Worksheet Overview—Mark Calhoun 1. Legislative—Mike Jackson; Council 2. General Government—Mark Calhoun 3. Executive and Legislative Support—Mike Jackson 4. City Attorney/Legal Support—Cary Driskell 5. Operations and Administration Services—Mike Jackson 6, Human Resources—John Whitehead 7. Finance and Information Technology—Mark Calhoun 8. Community Development—John Hohman LUNCH BREAK 12:00—12:30 (Note: Council&Staff will move to the 2"`t floor conference room for lunch, and reconvene back in the Council Chambers at 12:30 p.m) 9.Public Safety • Spokane Valley Police Department—Rick VanLeuven; Morgan Koudelka a Court,Jail and Other Public Safety Contracts—Morgan Koudelka 10. Parks and Recreation—Mike Stone 11. Public Works—Eric Guth 12. Supplemental Budget Requests--Mark Calhoun 13. Potential Capital Projects—Mike Jackson; Mark Calhoun 14. Financial Objectives—Mike Jackson BRAINSTORMING— Adjourn Note: There will be no public comments at Council Study Sessions or Workshops. During meetings held by the City of Spokane Valley Council,the Council reserves the right to take"action"on any item listed or subsequently added to the agenda. The term"action"means to deliberate,discuss,review,consider,evaluate,or make a collective positive or negative decision. NOTICE: Individuals planning to attend the meeting who require special assistance to accommodate physical,hearing,or other impairments, please contact the City Clerk at(509)921-1000 as soon as possible so that arrangements may be made, Workshop Agenda 06-18-13 Page I of 1 P:11.General Governance\Budget12014 BudgetlFinance Dept\budget summary 2013 06 18,xlsx CITY OF SPOKANE VALLEY,WA I 6/10/2013 1 General Fund#001 2014 Budget 2014 2013 Proposed $ % Budget Budget Inc(Dec) Inc(Dec), RECURRING ACTIVITY Revenues Property Tax 10,943,700 11,049,400 105,700 0.97% Sales Tax 15,250,000 16,260,000 1,010,000 6.62% Sales Tax-Criminal Justice 1,280,000 1,320,000 40,000 3.13% Sales Tax-Public Safety 750,000 740,000 (10,000) -1.33% Gambling Tax and Leasehold Excise Tax 612,500 619,400 6,900 1.13% Franchise Fees/Business Registration 1,135,000 1,213,000 78,000 6.87% State Shared Revenues 1,684,600 2,066,700 382,100 22.68% Fines and Forfeitures/Public Safety 1,632,300 1,470,800 (161,500) -9.89% Community Development 1,174,000 1,255,400 81,400 6.93% Recreation Program Revenues 571,500 579,800 8,300 1.45% Miscellaneous Department Revenue 0 85,500 85,500 #DIV/0! Miscellaneous&Investment Interest 158,000 115,600 (42,400) -26.84% Transfer-in -#101 (street admin) 39,700 39,700 0 0.00% Transfer-in -#105(h/rn tax-CP advertising) 30,000 0 (30,000) -100.00% Transfer-in -#402(storm admin) 13,400 13,400 0 0.00% Total Recurring Revenues 35,274,700 36,828,700 1,554,000 4.41% Expenditures City Council 390,111 413,850 23,739 6.09% City Manager 637,984 660,843 22,859 3.58% Legal 439,161 444,922 5,761 1.31% Public Safety 22,139,200 23,384,643 1,245,443 5.63% Deputy City Manager 609,706 626,215 16,509 2.71% Finance 1 IT 1,089,633 1,120,464 30,831 2.83% Human Resources 232,469 237,433 4,964 2.14% Public Works 876,443 885,228 8,785 1.00% _ Community Development-Administration 257,175 290,883 33,708 13.11% Community Development-Engineering 850,845 807,114 (43,731) -5.14% . 124,214 1 Community Development-Planning 899,743 928,906 29,163 3.24% 3.92% Community Development-Building 1,162,582 1,267,656 105,074 9.04% Parks&Rea-Administration 270,717 274,743 4,026 1.49% Parks&Rec-Maintenance 789,000 796,200 7,200 0.91% Parks&Rec-Recreation 231,321 229,152 (2,169) -0.94% 13,554 Parks&Rec-Aquatics 485,600 490,400 4,800 0.99% 0.51% Parks&Rec-Senior Center 88,143 89,882 1,739 1.97% Parks&Rec-CenterPlace 800,884 798,842 (2,042) -0.25% Pavement Preservation 855,857 888,823 32,966 3.85%, General Government 1,799,100 1,811,603 12,500 0.69% - 51,466 Transfers out-#502(insurance premium) 319,000 325,000 6,000 1.88%_ 1.73% Total Recurring Expenditures 35,224,674 36,772,799 1,548,125 4.40% Recurring Revenues Over(Under) Recurring Expenditures 50,026 65,901 NONRECURRING ACTIVITY Revenues Transfer in-#120(excess reserves) 50,787 0 (50,787) -100.00% Total Nonrecurring Revenues 50,787 0 (50,787) -100.00% Expenditures Transfers out-#309(park grant match) 50,000 100,000 50,000 100.00% Law Enforcement Contingency 0 350,000 350,000 #DIV/0! Transfers out-#312(Capital Reserve Fund) 7,826,207 0 (7,826,207) -100.00% Parks&Recreation related 56,962 0 (56,962) -100.00% Carpet at City Hall 25,000 0 (25,000) -100.00% Total Nonrecurring Expenditures _ 7,958,169 450,000 (7,508,169) -94.35% Nonrecurring Revenues Over(Under) Nonrecurring Expenditures (7,907,382) (450,000) Excess(Deficit)of Total Revenues Over(Under)Total Expenditures I (7,857,356) I (394,099) Beginning unrestricted fund balance 28,681,219 7 20,823,863 I Ending unrestricted fund balance 20,823,863! 20,429,764 Ending fund balance as a percent of recurring expenditures=[ 55,56% 001 P:11.General GovernancelBudget12014 Budget\Finance Deptthudget summary 2013 06 18.xlsx CITY OF SPOKANE VALLEY,WA 6/10/2013 Street Fund#101 2014 Budget 2014 2013 Proposed $ % Budget Budget Inc(Dec) Inc(Dec) (RECURRING ACTIVITY Revenues Motor Vehicle Fuel(Gas)Tax 1,861,100 1,860,000 (1,100) -0.06% Investment Interest 5,000 4,000 (1,000) -20.00% Utility Tax 2,900,000 2,750,000 (150,000) -5.17% Miscellaneous Revenue 0 0 0 #DIV/01 Total Recurring Revenues 4,766,100 4,614,000 (152,100) -3.190!0 Expenditures Wages/Benefits/Payroll Taxes 573,170 589,822 16,652 2.91% Supplies 72,200 91,500 19,300 26.73% Services&Charges 2,456,152 2,207,201 (248,951) -10.14% Snow Operations 469,000 520,000 51,000 10.87% Intergovernmental Payments 851,000 798,000 (53,000) -6.23% Interfund Transfers-out-#001 39,700 39,700 0 0.00% Interfund Transfers-out-#311 (pavement preserve 282,000 282,000 0 0,00% Interfund Transfers-out-#501 (plow replace.) 150,000 75,000 (75,000) -50.00% Interfund Transfers-out-#501 (non-plow vehicle 10,777 10,777 0 0.00% Total Recurring Expenditures 4,903,999 4,614,000 (289,999) -5.91% Recurring Revenues Over(Under) Recurring Expenditures (137,899) 0 NONRECURRING ACTIVITY Revenues N/A 0 0 0 #DIV/01 N/A 0 0 0 #DIV/0l Miscellaneous 0 0 0 #D1V/0! Total Nonrecurring Revenues 0 0 0 #DIV/0! Expenditures Capital 0 0 0 #DIV/01 Total Nonrecurring Expenditures 0 0 0 #DIV/01 Nonrecurring Revenues Over(Under) Nonrecurring Expenditures 0 0 Excess(Deficit)of Total Revenues Over(Under)Total Expenditures ; (137,899) I 0 Beginning fund balance 2,228,437 , 2,090,538 Ending fund balance 2,090,538�� 2,090,538 101 P:11.General GovernancelBudget12014 Budget\Finance Deptlbudget summary 2013 06 18.xlsx CITY OF SPOKANE VALLEY,WA 6110/2013 Pavement Preservation Fund#311 2014 Budget 2014 2013 Proposed $ % Budget Budget Inc(Dec) _ Inc(Dec) Revenues Transfers in-#101 282,000 282,000 0 0.00% Transfers in-#123 616,284 616,284 0 0.00% Transfers in-#301 150,000 182,966 32,966 21.98% Transfers in-#302 150,000 182,966 32,966 21.98% Total Revenues 1,198,284 1,264,216 65,932 5.50% Expenditures Pavement preservation 1,198,284 1,264,216 65,932 5.50% Total Expenditures 1,198,284 1,264,216 65,932 5.50% Revenues over(under)expenditures 0 l 0 Beginning fund balance 948,733 948,733 Ending fund balance 948,733 948,733 Computation of Pavement Preservation Commitment General Fund recurring expenditures prior to addition of pavement preservation 34,235,677 35,883,976 Amount equivalent to 6% 6.00% 6.00% Pavement preservation expenditures 2,054,141 2,153,039 - Components of Pavement Preservation Financing #001 General Fund 855,857 888,823 #101 Street Fund 282,000 282,000 #123 Civic Facilities Replacement Fund 616,284 616,284 #301 Capital Projects Fund 150,000 182,966 #302 Special Capital Projects Fund 150,000 182,966 2,054,141 2,153,039 311 P:11.General GovernancelBudget12014 Budget\Finance Deptlbudget summary 2013 06 18.xlsx CITY OF SPOKANE VALLEY,WA 6/10/2013 Stormwater Fund#402 2014 Budget 2014 2013 Proposed S % Budget L Budget no(Dec) Inc(Dec) 'RECURRING ACTIVITY Revenues Stormwater Management Fees 1,800,000 1,835,000 35,000 1.94% Investment Interest 1,800 2,500 700 38.89% Miscellaneous 0 0 0 #DIVl01 Total Recurring Revenues 1,801,800 1,837,500 35,700 1.98% Expenditures Wages 1 Benefits 1 Payroll Taxes 475,604 480,459 4,855 1.02% Supplies 16,300 15,900 (400) -2.45% Services&Charges 1,127,120 1,065,076 (62,044) -5.50% Intergovernmental Payments 27,000 26,500 (500) -1.85% Interfund Transfers-out-#001 13,400 13,400 0 0.00% Interfund Transfers-out-#501 1,567 1,567 0 0.00% Total Recurring Expenditures 1,660,991 - 1,602,902 (58,089) -3.50% Recurring Revenues Over(Under) Recurring Expenditures 140,809 234,598 NONRECURRING ACTIVITY Revenues Grant Proceeds 200,000 0 (200,000) -100.00% Miscellaneous 0 0 0 #DIV10l Total Nonrecurring Revenues 200,000 0 (200,000) -100.00% Expenditures Capital-various projects 350,000 900,000 550,000 157.14% Sullivan Bridge Drain Retrofit 267,000 0 (267,000) -100.00% UIC Retrofits on Pvmnt Pres Projects 430,000 0 (430,000) -100.00% Total Nonrecurring Expenditures 1,047,000 900,000 (147,000) -14.04% Nonrecurring Revenues Over(Under) Nonrecurring Expenditures (847,000) (900,000) Excess(Deficit)of Total Revenues Over(Under)Total Expenditures ; (706,191) 1 (665,402) Beginning working capital 2,697,333 .1,991,142 Ending working capital 1,991,142— 1,325,740 I 402 P:\1.General Governance\Budget\2014 Budget\City Manager Dept\CM DCM Operations budget worksheets 2014.xlsx 001 011 General Fund City Council Wanes/Payroll Taxes/Benefits 000.511.60.10.00 Wages 000.511.60.20.00 Payroll Taxes and Benefits Supplies 000.511.60.31.01 Office&Operating Supplies 000.511.60.31.03 Publications 000.511.60.31.05 Meeting Supplies 000.511.60.31.06 Safety Equipment 000.511.60.35.01 Small Tools&Minor Equipment Other Services&Cherries 000.511.60.41.05 Professional Services-Lobbyist 000.511.60.41.13 Professional Services-Broadcasting 000.511.60.41.17 Advertising 000.511.60.42.01 Postage 000.511.60.42.03 Cell Phones 000.511.60.43.11 Travel/Mileage Position 1 000.511.60.43.12 Travel/Mileage Position 2 000.511.60.43.13 Travel/Mileage Position 3 000.511.60.43.14 Travel/Mileage Position 4 000.511.60.43.15 Travel/Mileage Position 5 000.511.60.43.16 Travel/Mileage Position 6 000.511.60.43.17 Travel/Mileage Position 7 000.511.60.48.02 Copier Maintenance 000.511.60.48.03 Software Licenses and Maintenance 000.511.60.49.01 Subscriptions 000.511.60.49.02 Memberships 000.511.60.49.03 Printing&Binding 000.511.60.49.11 Registrations Position 1 000.511.60.49.12 Registrations Position 2 000.511.60.49.13 Registrations Position 3 000.511.60.49.14 Registrations Position 4 000.511.60.49.15 Registrations Position 5 000.511.60.49.16 Registrations Position 6 000.511.60.49.17 Registrations Position 7 Total City Council 2010 Actual 2011 Actual 2012 Actual 65,700 72,577 138,277 62,307 79,082 141,389 65,700 99,871 165,571 2013 Budget 65,700 123,168 188,868 2014 Proposed Budget 65,700 144,958 210,658 3,424 1,889 2,533 2,000 2,000 177 80 50 250 250 2,746 500 1,022 1,400 1,442 28 0 0 0 0 934 1,046 0 500 500 7,309 3,515 3,605 4,150 4,192 47,532 37,850 38,602 38,000 38,000 18,000 0 33,814 42,000 42,000 0 378 858 500 500 67 111 276 1,193 1,100 3,240 3,479 3,780 3,800 3,800 1,429 1,809 1,308 4,000 4,200 727 471 4,137 4,000 4,200 1,603 423 4,892 4,000 4,200 5,729 7,378 1,723 4,000 4,200 0 173 1,302 4,000 4,200 4,621 1,532 707 4,000 4,200 7,693 7,354 3,396 4,000 4,200 4,388 3,926 2,936 4,200 4,200 0 0 0 500 500 0 50 0 100 100 67,269 67,723 67,655 67,800 68,400 0 26 50 500 500 931 1,074 570 1,500 1,500 220 945 870 1,500 1,500 1,442 775 1,635 1,500 1,500 1,970 1,310 825 1,500 1,500 0 405 490 1,500 1,500 1,947 570 710 1,500 1,500 2,149 2,052 1,280 1,500 1,500 170,957 139,814 171,816 197,093 199,000 316,543 284,718 340,992 390,111 413 850 Budget Reduc on Exercise Does not reflect recommended course of action 2014 Bud.et with 3% Reduction 6% Reduction 9% Reduction 2014 Bud.at-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction /.,01111 909 09311 939 0e3. 9 93 00 3 1 ; 4 903 390 3 0 $ 9 , / ,, 7,t ,(0 09 99 �9 9 / �0. J.. `¢� 0k 93 09, 99 b9 98 � '39 � 60 Total budget Increase= 6.09% Combined nonpayroll increase= 0.97% ( (6.00%) (9.00%) P:11. General GovernancelBudget12014 Budget\City Manager Dept\CM DCM Operations budget worksheets 2014.xlsx General Fund 2014 City Council -Detail Proposed Budget Salaries &Wages 1 65,700 Payroll Taxes and Benefits 144,958 Office &Operating Supplies I 2,000 Paper, pens,files,folders, Retreat binders, ink cart, clips, sticky notes, labels. Publications ' I 250 Liberty Lake Splash$50; Spokesman Review$200 Meeting Supplies 1,442 Retreat(2) $700; Coffee$200; Water$92 Soda $100; Misc$350 Small Tools & Minor Equipment d 500 Eg: printer or new chair Professional Services I 38,000 Lobbyist Professeional Services 42,000 Broadcasting-Council Meetings Granicus $8400; Spokane Courier$1000;Twisted Pair record/broadcast$2.00/minute---48 mtgs©4.5 to 5.5 hours recording time$31,680 Postage 1,100 New Business Letters, etc. Cell Phones 3,800 $540/mo X7 Travel/Mileage 1($4,200 ea x 7 positions-Choose from the 29,400 following and/or share funds between eachother- Registration costs additional and noted below) National League of Cities(DC) (Spring) 2,500 National League of Cities(Fall) 5,000 Assoc.Wash. Cities Annual Conf. 1,000 Assoc.Wash. Cities Legislative Conf 1,000 Mileage-local average of all 5,000 Advertising 500 Lodging Tax Adivisory Notifications; Outside Agency Funding Notifications Copier Maintenance 4,200 Cost of copies annually Software Licenses and Maintenance 500 Subscriptions 100 For misc• government magazines/manuals, etc Memberships (dues determined by population size) 68,400 Assoc.Wash. Cities 61,703 National League of Cities 6,697 Printing & Binding 500 Letterhead, business cards, engraving Registrations ($1,500 ea x 7 positions- choose from the I 10,500 following:) National League of Cities-2 events; 700 450 Page 1 of 2 P:11. General GovernancelBudget12014 Budget\City Manager Dept\CM DCM Operations budget worksheets 2014.xlsx General Fund 2014 City Council -Detail Proposed Budget Assoc. of Wash. Cities-2 events 325 125 Chamber meetings 25 Convention Visitors Bureau 25 GS! 25 Total: 413,850 Page 2 of 2 001 General Fund 090 General Government Supplies 000.517.90.20.01 Employee Recognition&Safety Program 000.511.60.35.01 PEG COSV Small tools&Minor Equip 000.514.81.31.02 Business Registrations 000.517.90.31.04 Employee Recognition-Operating Supplies 000.518.85.31.01 Office&Operating Supplies 000.518.85.35.01 Small Tools&Minor Equipment 000.518.85.35.03 Non Capital Office Furniture&Equipment :000.518.85.35.11 Computer Hardware-Non Capital 0 0 0 0 23,000 :000.518.85.35.12 Computer Software-Non Capital J 0 0 0 0 31,800 :000.518.85.48.04 Non Capital Computer Software/Hardware 21,082 35,941 22,568 82.100 0 000518.90.32.01 Fuel 553 763 0 0 0 000.519.60.31.01 Office&Operating Supplies 13,822 9,229 7,496 15,000 15,000 P:11.General Governance\Budget\2014 Budget\Finance Dept\GenGov budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual 2,081 0 996 111 2,077 1,224 749 1,694 0 1,292 25 0 1,629 0 347 329 1,288 0 158 8,081 526 2013 Budget 5,000 0 2,000 0 0 1,700 0 2014 Proposed Budget 3,000 100 2,000 0 0 2,500 0 Other Services&Charges 000.511.60.41.01 Broadcasting Council Meeting 0 45,725 0 0 0 000,513.10.41.05 Contingency 0 0 0 150,000 150,000 000.514.23.41.01 Accounting&Auditing 67,061 68,336 69,161 90,000 90,000 000.514.23.41.41 Uncollectible Accounts Expense 0 2,054 2,288 0 0 000.514.23.49.09 Petty Cash Reimbursement 5 11 0 0 0 000.518.10.41.17 Advertising 212 169 0 0 0 000.518.10.42.01 Postage 2,611 3,626 3,993 5,000 5,000 000,518.10.42.02 Telephone/DSL Scrvico 29,022 23,845 29,196 30,900 18,500 000.518.10.42.08 Internet Service 0 0 0 0 18,100 000.518.10.49.00 City Wide Records Management 27,474 3,300 3,610 10,000 10,000 000.518.20.45.01 City Hall Rent 452,602 461,208 478,324 428,400 416,000 000.518.30.48.01 Facility Repairs&Maintenance 1,375 381 583 5,000 5,000 000.518.75.48.01 Equip Repair&Maint-Hardware Support 33,241 25,680 23,083 38,500 36,500 000.518.85.41.03 IT Support 78,521 96,059 75,225 105,000 98,500 000.518.85.48.03 Software Licenses&Maintenance 11,812 68,706 70,737 80,000 78,600 000.518.90.49.01 PEG Reimburse-CMTV 0 28,988 12,305 0 0 000.518.90.49.03 Printing&Binding 2,142 0 343 5,000 0 000.518.90.49.04 Registrations 788 0 0 0 0 000.518.90.49.06 Miscellaneous Services 1,154 10,872 7,045 15,000 15,000 000.519.90.41.01 Merchant Charges(Bankcard Fees) 18,255 9,927 1,492 10,000 2,500 000.519.90.41.15 EECBG Utilities Partnering Program 1,542 12,947 20,383 0 0 000.519.90.42.04 Web Site Services 3,000 0 0 0 0 000.519.90.49.09 Bank Statemetn Corrections&Errors (5) 0 0 0 0 000.548.66.45.01 Vehicle Rental 6,613 4,130 7,000 7,000 7,000 000.548.66.45.05 General Operating Leases:Computer 29,847 45,559 52,842 35,000 39,600 000.550.00.41.00 Economic Development-Site Selector 9,973 9,179 9,197 12,000 11,000 000.550.00.41.05 Professional Services-Economic Devel. 60,000 83,352 100,340 87,000 82,500 000.558.70.41.05 Community Survey 92 0 0 0 0 000.558.70.41.17 City Economic Development 0 1,375 88,230 200,000 200,000 000.560.00.41.05 Professional Services-Project Access 20,000 0 0 0 0 000.560.10.41.05 Professional Services-Social Services 53,985 67,961 49,095 63,000 67,500 000.566.10.41.05 Alcohol Treatment:Liquor Excise Tax 8,867 8,750 4,516 7,000 0 000.566.10.41.06 Alcohol Treatment:Liquor Profits 14,309 12,512 17,977 14,000 20,000 Page 1 of 3 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Budget with 6% Reduction 9% Reduction 2014 Bud.et-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction / i// // //f' 77///' /// //' / . 001 General Fund 090 General Government 000.588.80.00.00 Prior Period Adjustment Intergovernmental Services 000.514.40.51.01 000.514.90.51.03 000.518.90.44.03 000.543.10.51.02 000.553.70.51.01 Capital Outlays 000.594.11.64.01 000,594.11.64.02 000.594.11.64.04 000.594.18.64.00 000.594.18.64.01 000.594.18.64.02 000,594.18.64.11 000,594.18.64.12 000.595.30.63.00 Election Costs Voter Registration Taxes and assessments Memberships-SRTC Spokane County Air Pollution Authority PEG COSV Broadcast-Office Furn. PEG COSV Broadcast-Software/hardware PEG COSV Broadcast-Communication Copy Machine Office Furniture&Equipment Computer Software/Hardware Compuer Hardware-Capital Computer Software-Capital Construction-Pavement Preservation P:11.General Governance\Budget\2014 Budget\Finance Dept\GenGov budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual 0 0 57,736 4,923 34,300 115,084 0 0 0 18,502 0 0 (119,334) 50,184 79,252 8,536 0 114,941 13,330 47,095 5,357 0 0 0 86,132 6,006 0 115,569 2013 Budget 0 57,000 83,000 8,600 0 117,000 2014 Proposed Budget 0 57,000 87,000 8,600 0 117,000 0 0 0 0 33,300 0 0 2,000 20,000 3.500 0 24,232 0 21,523 0 6,898 0 0 22,121 0 0 3,063 0 0 24,400 0 0 40,000 0 0 Debt Service:Principal 000.592.19.82.01 Interest and Other Debt Service Costs Interfund Payments for Service 000.597.63.94.01 Interfund Transfer to:Capital Projects 000.597.63.95.63 Interfund Transfer to ST Cap 2011+ 000.597.30.00.30 Interfund Trf to#303-Street Capital 000.597.30.00.90 Interfund Trf to#309-Park Capital 000.597.31.00,10 Interfund Trf to#311-Pavement reservation 000.597.31.00.20 Interfund Trf to#312-Capital Reserve Fund 000.597.50.00.20 Interfund Trf to#502-Risk Management 10th Anniversary 010.513.10.31.01 Supplies-10th Anniversary Total Governmental Division 0 24 100,000 0 929,048 0 0 0 318,000 0 (952) 0 1,084,681 551,730 100,000 0 0 319,000 0 855,857 888,823 444 0 0 0 0 0 0 0 0 0 0 0 106,250 50,000 100,000 2,045,203 0 0 0 7,826,207 0 319,000 319,000 325,000 0 0 257 0 0 2,561,708 3,540,500 3,776,103 10,850,164 3,125,423 Combined nonpayroll increase(decrease)= (71.19%) Page 2 of 3 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction 2014 Budget-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction a# # / a 8 $ $ Waif,/'`°#9 i,,b,°�$ 8 S r///////6.:If.='„M$ OX.,.i.'L/% N (4.02%) (6.99%) (9.95%) 001 P:11.General Governance\Budget12014 Budget\Finance Dept\GenGov budget worksheets 2014.xlsx General Fund 090 General Government Recurring Nonrecurring Interfund Transfer to:Capital Projects Interfund Transfer to ST Cap 2011+ Interfund Trf to#309-Park Capital Interfund Trf to#311-Pavement reservation Interfund Trf to#312-Capital Reserve Fund Interfund Trf to#303-Street Capital 10th Anniversary Total General Government 2010 Actual 2011 Actual 2012 Actual 2013 Budget 2014 Proposed Budget 1,532,660 1,804,089 1,624,393 2,973,957 3,025,423 1.73% 100,000 0 0 0 0 0 1,084,681 0 0 0 0 100,000 106,250 50,000 100,000 0 0 2,045,203 0 0 0 0 0 7,826,207 0 929,048 551,730 0 0 0 0 0 257 0 0 1,029,048 1,736,411 2,151,710 7,876,207 100,000 2,561,708 3,540,500 3,776,103 10,850,164 3,125,423 Page 3 of 3 3% Reduction Budget Reduc ion Exercise (Does not reflect recommended course of action) 2014 Budget with 2014 Budget-Line Item Changes 6% 9% 3% 6% 9% Reduction Reduction Reduction Reduction Reduction /„„0.14.21,9'1 ;1,4,1k. a e/ //�1 a aii /%. /J'A,f aa.:4s /„ a e e s e e e a e y / /$ ' 4 @ i 9 j // a a a -� a' l a a a , a /' a tf s.fit& ,6. °`a i LA/2-- /�////%///i%//%r/aDffig8 AMR / °a4 /� 91,4058 //. 4 eaa i9�A c A .id P:11. General Governance\Budget12014 Budget\Finance Dept\GenGov budget worksheets 2014,xlsx General Fund_ I. General Government-Detail 2014 Proposed Budget I Supplies _ Employee Recognition &Safety Program 3,000 -I Employee recognition events;first aid boxes ,PEG CoSV Small tools&minor equipment 100 _ - video tripod Business Registrations 2,000 -I credit card fees;envelopes Small Tools& Minor Equjpment I _ 2,500 -I I T related supplies-laptop power supplies, styu s pens, e tc. Computer Hardware-Non Capital _ _ _ 23,000 --'Monitors, IP phones, Memory, Replace 3 UPSs, etc. Computer Software-Non Capital _ 31,800 -I Licenses-MS Office,MS Server, Mite!UCA,etc. Office& Operating Supplies - 15,000 - kitchen supplies, calendar, copy paper, letterhead, toner, etc. Other Services& Charges Contingency 150,000 . -I City Manager directed for professional service related tasks or to assist City Depts with line-item deficiencies Accounting &Auditing 90,0.00 -'Annual audit by State Auditor&assistance with technical issues Postage 5,000 _ - city mailings including AP checks, UPS,meter rental, etc. TelephonelDSL Service 18,500 - I Telephone — Internet Service 18,100 -I Internet access .City Wide Records Management 10,000 'Equipment and/or consultant City Hall Rent __T _ 416,000 -033,333.33 x 3 mo) + ($34,000.00 x 9 ma)+$10,000 CAM Facility Repairs & Maintenance _ 5,000 -'Sidewalk snow removal&de-icer;minor work T Equipment Repair& Maintenance-Hardware Support _ 36,500 -I Network servers, copiers, firewall,phone system, IT Support _ _ 98,500 -'monthly servermaint,help desk temp, infrastructure wiring Software Licenses&Maintenance 78,600 -'Annual maintenance fees on software (Eden, Laserfiehe, etc.) Miscellaneous Services 1.5,000 -I Shredding charges, WA State Purchasin Co-op,Bike helmets _ Merchant Charges (Bankcard Fees) _ 2,500 -1 Visa, mastercard fees Vehicle Rental 7,Q00 -1 Summer vehicles for inspectors General Operating Leases: Computer _ _ _ 39,600 - 'Lease of desk top and lap top PCs used by City staff Page 1 of 2 P:\1. General Governance\Budget12014 Budget\Finance Dept\GenGov budget worksheets 2014,xlsx General Fund General Government-Detail 2014 -- - Proposed Budget Economic Development 11,000 Spokane Regional Site Selector Professional Services- Economic Devel. 8.2,500 - I Outside agencies-Reflects amount of 2013 Awards City Economic Development 20.0,000 - JPromotion-Consultant/Study/Implementation Professional Services-Social Services 67,5.00 - I Outside agencies-Reflects amount of 2013 Awards Alcohol Treatment; Liquor Profits 20,000 - JPaid to Spokane County per State statute Intergovernmental Services Election Costs I 57,000 - 'Per ballot issue/per capita allocation by Spokane County Voter Registration 87,000 - I Per capita allocation by Spokane County Taxes and assessments _ _ _ 8,600 - 112.64%leasehold excise tax-precinct, bus benches Spokane County Air Pollution Authority 117,000 - 1 Air quality Capital Outlays PEG CoSV Broadcast Software& Hardware 33,300_ - 'Equipment needed to continue Council mtgs Cop Machine 20,000 - Replace copiers in Operations and Permit Center Computer Hardware-Capital _ 40,000 - (replace 3 servers and Storage Area Network(SAN) Co struction -Pavement Preservation 888,823 - I City pavement preservation projects — Interfund Payments for Service Interfund Transfer to Parks Capital Proj 100,000 - I For parks capital Interfund Risk Management Payment _ 325,000 - City insurance premium transferred to Fund 11501 3,125,423 Page 2 of 2 P:\1.General Governance\Budget\2014 Budget\City Manager Dept\CM DCM Operations budget worksheets 2014.xlsx 001 General Fund 013 Executive&Legislative Support 000 City Manager&City Clerk Wages/Payroll TaxeslBenefits 000.513.10.10.00 Wages 000.513.10.10.99 Overtime 000.513.10.20.00 Payroll Taxes and Benefits Supplies 000.513.10.31.01 000.513,10.31.03 000.513.10.31.05 000.513.10.35.01 Office&Operating Supplies Publications Meeting Supplies Small Tools&Minor Equipment 2010 Actual 2011 Actual 2012 Actual 646,82D 1,174 155,698 803,692 326,587 1,145 127,072 454,804 376,605 1,583 148,756 526,944 2013 Budget Other Services&Charges 000.513.10.41.05 Professional Services 000.513.10.41.17 Advertising(Clerk's notifications) 000.513.10.41.18 Legal Notices 000.513.10.42.01 Postage 000.513.10.42.02 Telephone Service 000.513.10.42.03 Cell Phones 000.513.10.43.01 Travel/Mileage 000.513.10.48.00 Equipment Rental Maintenance-Conti 000.513.10.48.02 Copier Maintenance 000.513.10.48.03 Software Licenses and Maintenance 000.513.10.49.01 Subscriptions 000.513.10.49.02 Memberships 000.513.10.49.03 Printing&Binding 000.513.10.49.04 Registrations/Training 000.513.10.49.05 Filing&Recording Fees 000.513.10.49,06 Miscellaneous Services Total City Manager 919 1,247 1,454 174 126 232 584 757 123 297 85 0 1,974 2,215 1,809 408,384 1,200 164,496 574,080 1,500 500 800 500 3,300 2014 Proposed Budget 419,700 1,200 175,400 596,300 1,500 550 800 500 3,350 14,389 24,883 24,916 18,364 22,000 8,594 6,893 5,148 7,000 7,070 0 0 0 0 0 2 330 829 1,000 1,000 0 0 80 0 0 0 540 540 540 540 3,912 6,361 7,091 14,000 14,000 0 0 0 500 0 7,261 6,808 5,789 7,000 7,000 0 74 824 1,300 1,233 1,416 645 0 800 500 390 687 1,756 2,000 2,000 4,094 2,400 5,372 2,500 1,000 2,074 2,883 1,984 3,000 3,000 0 D 168 2,000 1,000 466 505 0 600 850 42,598 53,010 54,497 60,604 61,193 848,264 510,029 583,250 637,984 660,843 Total budget increase= 3.58% Combined nonpayroll increase= 1.00% Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 3% Reduction 6% Reduction 9% Reduction e' /a as ae as . aaa sae e e • 2014 Bud.et-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction .59 " a /,/7- ,/7////, 9er q 6 �6 4 :o S �/ ' ,;'1,5 .�a ,i & 9 ((R 6 a e 3Afi /aae s$ �&' ^,aae aaa aa, JJA et / eAl a a✓a aa iJ iid / Yy /A Mi 11 6 � a m £ „ . saa , •e be , fig . (3.18%) (6.17%) (9.17%) P:11. General GovernancelBudget12014 Budget\City Manager DeptICM DCM Operations budget worksheets 2014.xlsx General Fund 2014 City Manager-Detail Proposed Budget I Salaries&Wages I 419,700 Overtime I I 1,200 Payroll Taxes and Benefits I I 175,400 Office&Operating Supplies I 1,500 Paper, pens,files,folders, binders,ink cart.,clips,sticky notes etc Publications 550 Books, Manuals&Reports re:city function-(International City/County Manangement Assoc., Nathionel League Cities, Assoc.Wash.Cities) Meeting Supplies I 800 Small Tools & Minor Equipment I 500 budgeted to replace desk printer, label maker,etc. Professional Services I I 22,000 Consultants,title searches,bond counsel, and Code _ Publishing services of—$3500-from Printing/Binding Postage I I I 1,000 Cell Phones I 540 Cell$500,Gov. Emergency Cell Card$40 Travel/Mileage I I 14,000 International City/County Management Assoc.-2 sponsored 2,740 events-Mileage/air,lodging, meals Assoc.Wash. Cities conf.; meals, lodging,air-2 events 2,740 Wash.Municipal Clerk Assoc.-clerk's conf,City Clerk(CC) 1,000 I /Dep.City Clk(DCC). International Institute of Municipal Clerks-flight, hotel,meals 2,100" for CC/DCC, Professional Development(Certifcation for DCC) I 1,8201 City Manager car allowance 3,600 Advertising 7,070 Free Press Publishing,Spokesman Review,Journal of Business Equipment Rental Maintenance-Contracted 0 Copier Maintenance I 7,000 Copying, paper,toner,mailing chgs pro-rated by Dept code I City produced reports/brochures Software Licenses and Maintenance I 1,233 I Adobe Creative Suite;MS Project; Subscriptions I I 500 manuals/periodicals pertaining to Gov.function Memberships I 2,000 I International City/County Manangement Assoc. 1,320 Wash.Municipal Clerk Assoc.x2 150 International Institute Municipal Clerks x2 2501 Wash.City/County Management Assoc.&Civic Org 187 Printing & Binding 1,000 letterhead;business cards,envelopes, (Code Publishing has moved to Professional Services) Page 1 of 2 P:11. General GovernancelBudget12014 Budget\City Manager Dept\CM DCM Operations budget worksheets 2014.xlsx General Fund I 2014 City Manager-Detail Proposed Budget Registrations/Training I 3,000 Wash.Municipal Clerk Assoc. 500 Wash.City/County Management Assoc. 500 International City/County Management Assoc. 500 International Institute Municipal Clerks I 600 Professional Dev. 4 725 Local registrations 175 Filing & Recording Fees I 1,000 City Clerk document filing fees Miscellaneous Services I f 850 Total Executive I 660,843 Page 2 of 2 001 General Fund 013 Executive and Legislative Support 015 Legal Wages/Payroll Taxes/Benefits 015.515.32,10.00 Wages 015.515.32.20.00 Payroll Taxes and Benefits 015.515.32.10.01 Intern Wages 015.515.32.20.01 Intern Payroll Taxes and Benefits Supplies 015.515.32.31.01 Office Supplies 015.515.32.31.03 Publications 015.515.32.31.05 Meeting Supplies 015.515.32.32.01 Fuel 015.515.32.35,01 Small Tools&Minor Equipment Other Services&Charges 015.515.32.41.03 Spokane County GIS 015.515.32.41.04 Legal 015.515.32.41.05 Professional Services 015.515.32.42.01 Postage 015.515.32.43.01 Travel/Mileage 015.515.32.48.02 Copier Maintenance 015.515.32.48.03 Software Licenses and Maintenance 015.515.32.49.01 Subscriptions 015.515.32.49.02 Memberships 015.515.32.49.04 Registrations 015.515.32.49.05 Filing&Recording Fees 015.515.32.49.07 Training Total Total Legal P:11.General Governance\Budget\2014 Budget\Legal Dept\Legal budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual 254,313 209,528 241,474 68,983 58,164 78,962 0 0 0 0 0 0 323,296 267,692 320,436 437 950 1,065 1,926 24 250 0 0 0 14 10 0 0 74 1,377 2,377 1,058 2,692 2013 Budget 246,036 90,795 24,000 1,980 362,811 1,200 700 0 0 500 2,400 2D14 Proposed Budget 247,992 93,840 24,000 1,980 367,812 1,200 700 0 0 500 2,400 0 0 0 0 0 30,805 145,398 102,698 50,150 50,610 47,631 885 130 2,100 2,100 575 510 192 500 500 978 1,541 2,146 5,000 5,000 1,539 2,308 1,623 1,500 1,500 0 0 0 0 0 6,130 8,418 8,504 9,000 9,000 650 1,280 1,221 1,000 1,010 0 797 1,283 1,800 1,990 1,297 776 2,148 2,500 3,000 2,871 819 10 400 0 92,476 162,732 119,955 73,950 74,710 418,149 431,482 443,083 439,161 444,922 3% Reduction Budget Reduc ion Exercise Does not reflect recommended course of action 2014 Bud•et with 6% Reduction 9% Reduction 2014 Budget-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction 8 @ 0 AM $„/„.,,-,/, 7/7. /7 7 / • i$ $ 9 r zee'¢ y, // S �$ 8° /./ 7' 8 0% eti y a # 8 $7 'LOLL '1,044 _VD 41Fic 8 d A 88 $0� b $/ $/N 88 �$$ �8 8 $ 8 $ 8 8 , kid'/, Atik/ ,',/,',,b,w/ Awflo,' ofi4,0 / 4tof 7 ,,,,..„,,,,, .e.A,,,c /, /.7,://4<,- "ire ,//4"7„/„ :9.sef4,/44' Total budget increase= 1.31% Combined nonpayroll increase= 1,00% (3.00%) (5.92%) (8.84%) P:11. General GovernancelBudget12014 Budget\Legal DeptlLegal budget worksheets 2014.xlsx General Fund 2014 Legal -Detail Proposed Budget Salaries &Wages (Includes two legal interns) 271,992 Overtime 0 Payroll Taxes and Benefits 95,820 -I FICA,medicare, L&1, PERS I Office&Operating Supplies { 1,200 -I Hanging files 30 -'File Folders — 40 -I Expand folders 20 -'Letterhead 60- -I Envelopes-Clasp 2 boxes 50 - Labels 4 rolls 90 - Avery labels and dividers _ 20 -'Pens-various types &Highlighters 90 - Name Plates/Business Cards 100 i -Tape, binder clips 40 -Print Cartridges 90 -13 ring binders 60 -Stamps/Refill in k 40 -I Index tabs i 40 -(Legal pads,post-its _ 50 -!Fasteners, staples 80 - Misc 300 Publications 700 - Revised Code of Washington 250 -I Washington Administrative Code 70 -'Federal and State Court Rules _ - 210 -I Supplements and Handbooks 170 Meeting Supplies Gas, Oil, &Tires Small Tools & Minor Equipment _ 500 - Desk equipment,scanner and miscellaneous office tools Non Capital Office Furniture& Equipment Legal I 51,110 -f Outside Counsel for things such as Shoreline Act adult i entertainment enforcement I Professional Services 2,100 -I Eastern Washington Attorney Service(Code Compliance) -I Private Investigators I -(First American Title Postage I 500 stamps Cell Phones TravellMileage-choose from: I 5,000 - Washington State Association of Municipal Attorneys 2900 f Conference(2 Attorneys)-air, mileage, hotel, workshops - Washington Cities insurance Authority Conference-hotel, 450 mileage, workshops - Labor Relations Conference-mileage, hotel, workshop I 750 Page 1 of 2 P:11. General GovernancelBudget12014 Budget\Legal Dept\Legal budget worksheets 2014.xlsx General Fund 2014 Legal - Detail Proposed Budget -I Courthouse, meetings incl. parking 900 I Copier Maintenance I 1,500 - Copying, paper, toner, mailing charges pro-rated by Dept code. Software Licenses and Maintenance I Subscriptions I -I Westlaw(Legal Research) I I 9000 Memberships I ' I 1,010 -I Washington State Bar Association ($370 per attorney) + 740 - Washington State Association of Municipal Attorneys ($30 per 60 attorney) -I Spokane Bar Association($100 per attorney) 210 Printing & Binding I I Registrations I I 1,990 -'Labor Relations Conference I 270 - Washington State Association of Municipal Attorneys 920 Conference(2 Attorneys in Fall($230 each)and 2 attorneys in spring($230 each) -I Washington Cities insurance Authority Conference I 50 -I Public Records Requests Seminar 250 - Miscellaneous Seminar-Example Shoreline issues, solid waste, 500 marijuana regulations, etc. Filing & Recording Fees I I 2,500 - Filing Complaints and recording judgments as liens(Code 2500 Enforcement is the majority of these)as welt as deeds, etc. (Current filing fee for cases is$240 per case. Could be increased to as much as$290 per case in the near future.) Training I I Total : 444,922 Page 2 of 2 P:\1.General Governance\Budget12014 Budget\City Manager Dept\CM DCM Operations budget worksheets 2014.xlsx 001 General Fund 018 Operations&Administrative Services 013 Deputy City Manager Wages/Payroll Taxes/Benefits 013.513.10.10.00 Wages 013.513.10.10.99 Overtime 013.513.1020.00 Payroll Taxes and Benefits Intern-Wages Intern-Payroll Taxes and Benefits Supplies 013.513.10.31.01 013.513.10.31.03 013.513.10.31.05 013.513.10.32.01 013.513.10.35.01 Office&Operating Supplies Publications Meeting Supplies Fuel Small Tools&Minor Equipment Other Services&Charon 013.513.10,41.03 IT Support 013.513.10.41.05 Professional Services 013.513.10.41,17 013.513.10,42.01 013.513.10.42.02 013.513.10.42.03 013.513.10.42.04 013,513.10.43.01 013.513.10.48.02 013.513.10.48.03 013.513.10.49.01 013.513.10.49.02 013.513.10.49.03 013.513.10.49.04 013.513.10.49.07 013.513.10.49.09 013,513.10.49.10 Total Advertising Postage Telephone Service Cell Phones Web Site Support Services&License Travel/Mileage Copier Maintenance Software Licenses and Maintenance Subscriptions Memberships Printing&Binding Registrations/Training Training-history Petty Cash Reimbursement Public Information Total Deputy City Manager 2010 Actual 2011 Actual 2012 Actual 321,462 326 93,481 0 0 415,269 327,581 356 97,016 0 0 424,953 312,025 476 92,184 0 0 404,685 1,665 714 939 0 0 0 0 238 0 164 105 125 0 323 664 1,829 1,380 1,728 2013 Budget 427,884 1,362 134,218 9,600 805 573,869 2014 Proposed Budget 1,000 400 350 100 500 2,350 435,732 0 143,887 9,600 806 590,025 1,000 200 200 150 500 2,050 2,793 2,400 3,958 2,500 2,500 0 63,160 7,629 0 0 0 0 842 0 0 271 33 139 100 100 0 0 120 0 0 540 540 540 580 780 9,392 0 1,440 16,000 16,000 609 41 535 1,000 1,000 (1,052) 0 2,853 5,000 5,000 7,440 8,930 824 1,000 1,000 0 0 23 200 200 1,602 0 725 506 750 20 98 88 500 500 466 41 716 500 760 85 0 149 100 0 17 30 0 0 0 5,504 4,102 3,070 5,500 5,550 27,687 79,375 23,651 33,486 34,140 444,785 505,708 430,064 609,705 626,215 Total budget increase= 2.71% Combined nonpayroll increase= 0.99% 3% Reduction ----------- € �f�'/ / I?5 •r' S s /5 A �s a r,v 4 ese gs � Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction 2014 Bud.et-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction 's $ /79S es a$ ss� e $ / sss a/ sr �/ rf $ a a s/ A i%�//iAAff /h I ey a�i,8.°.d b$ffi %//AIMS, 4,4%/0 6 /o ;AZ X59 F (3.06%) (6.05%) (9.00%) P:\1. General Governance\Budget12014 Budget\City Manager Dept\CM DCM Operations budget worksheets 2014.xlsx General Fund 2014 Deputy City Manager-Detail Proposed Budget Salaries&Wages' _ _A 435,732 Overtime I 0 Payroll Taxes and Benefits 143,887 Intern 9,600 Intern taxes 806 Office&Operating Supplies 1,000 I Hanging Files File Folders I Expand Folders Env Clasp 2bx;1 bxcoin Labels 4 rolls _ Avery labels and dividers Pens-various typos Batteries - – Tape reg/commercial Print Cartridges 3 ring binders Calendars-desk/wall Vinyl tabs Rolodex cards Misc Publications I 200 Books,manuals&reports re:functions of Gov.- (International City/County Mgmnt.Assoc.,Nantional League of Cities,Assoc.Wash.Cities) — Meeting Supplies 200 Developers Forums,etc. _ Gas,Oil&Tires 150 Small Tools&Minor Equipment 500 'Desk equipment,camera equipment(PIO),Misc. IT Support 2,500 'Spokane Co.Info Systems Dept Professional Services _ 0 'Citizen Survey eliminated _ Postage I — 100 Cell Phones/Emergency phone cards _ 780_ Cell$540,Gov.emrgncy phone cards$40;wireless card $200 — Web Site Support&License Fees - _ 16000 Qscend web software$1200/mo,E-gov$1400tyr Travel/Mileage 1 000 AWC Conf.(DCM)hotel,mileage,workshops Copier Maintenance (Copying,paper,toner,etc.and mailing machine chgs pro- 5,000 rated by dept code Software Licenses and Maintenance 1,000 Adobe Creative Suite purchase adrift user license Subscriptions 200 Public Info.Officer-SR online,Constant Contact Memberships I 750 Washington City/County Management Assn.,ICMA,Notary, Inland NW Partners Printing&Binding 500 city produced reports/brochures;letterhead;envelopes; business cards Registrations/Training ( 760 Page 1 of 2 P:11. General GovernancelBudget12014 Budget\City Manager Dept\CM DCM Operations budget worksheets 2014.xisx General Fund 2014 Deputy City Manager-Detail Proposed Budget Event fees:Valleyfest booth,Conferences:Assoc.Wash Cities and training costs Training 0 Public Information 5,550 -2 or 3 inserts in Spokesman&Valley News Herald;per Business Plan-update existing and develop new publications concerning City services;City's 10 year celebration;Economic Development marketing Total 626,215, Page 2 of 2 001 General Fund 018 Operations&Administrative Services 018 Human Resources Division Wages/Pavroll Taxes/Benefits 016.518.10.10.00 Wages 016.518.10.20.00 Payroll Taxes and Benefits Supplies 016.518.10.31.01 Office&Operating Supplies 016.518.10.31.03 Publications 016.518.10.32.01 Fuel Other Services&Charges 016.518.10.41.04 Legal 016.518.10,41.05 Professional Services 016.518.10.41.17 Advertising 016.518.10.42.01 016.518 10.43.01 016.518.10.48.02 016.518.10.48.03 016.518.10.49.02 016.518.10.49.03 016.518.10.49.04 016.518.10.49.06 016.518.10.49.07 016.518.10.49.09 016.518.10.49.13 Postage Travel/Mileage Copier Maintenance Software Licenses and Maintenance Memberships Printing&Binding Registrations Miscellaneous Services Training Petty Cash Reimbursement Employee Health&Wellness Total Human Resources Division P:\1.General Governance\Budget\2014 Budget\FIR Dept\HR budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual 133,437 43,745 177,182 139,989 42,615 182,604 140,083 47,256 187,339 1,052 0 0 1,052 596 0 0 596 454 0 7 461 2013 Budget 157,296 52,865 210,161 700 0 0 700 2014 Proposed Budget 158,652 56,253 214,905 700 700 0 250 7,089 1,000 2,000 4,497 6,706 8,230 7,428 7,428 4,516 5,239 1,520 4,900 1,990 103 79 83 50 50 1,885 2,366 3,970 2,500 2,500 756 1,014 782 1,100 1,000 167 60 0 0 0 360 1,792 560 700 965 18 0 0 0 0 335 160 0 560 560 184 17 0 0 0 2,547 1,634 814 2,500 4,465 2 0 0 0 0 838 1,997 1,230 870 870 16,208 21,314 24,278 21,608 21,828 194,442 204,514 212,078 232,469 237,433 Total budget increase= 2.14% Nonpayroll budget increase= 0.99% 3% Reduction Budget Reduc ion Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction ZrZ, /7/1/c et8 e B 6 00 i Be •a6 set B 7/ s at a t a ;,%/'>,,, ,///t/Dr/v,. ,/'4/04044„///4/ Y r' lets e B ttt 6 %10. //.! aaa oet a6 a 11 / /� % ate'° a a e s t< 2014 Budget-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction ✓•� ' <e set 6 9��6 a �! g y%%yt ,..; ye y1,„ y a y „>e,i. %,.-_ : A:4, as iel A�°a 4f:)- (2.99%) (5.98%) (8.99%) P:11. General GovernancelBudget12014 Budget\HR Dept\HR budget worksheets 2014.xlsx General Fund 2014 Human Resources - Details Proposed Budget Wages 158,652 Payroll Taxes and Benefits 56,253 -]FICA,medicare,L&!, PERS ��- Office &Operating Supplies -- 700 - File Folders 100 Expand folders 50 - Labels — 50 - Avery labels and dividers I 75 - Note Paper I 25 — -'Pens-various types 501 -13 ring binders 200 -IMisc 1501 - Publications _ I - Books, manuals&reports re:functions of City gov. {ICMA, 0 NLC, AWC) Other Services Legal I -ISummit Law I Professional Services 1 7,428 -� 1D Cards I 425] - Pre-employment Physicals 1,625 -I Drug and Alcohol Testing _ 200 -I CriminalHistory Checks I 750 __'Discovery Benefits Admin Fee 4,428 Postage 50 Travel/Mileage - _ I 2,500 -I To attend A_WC Fall HR Conference + 350 -I To attend Labor Relations Institute I 350 -I To attend WAPELRA Spring Training I 200 I -I To attend AWC Health Academy I _ 350 _ -]To attend Risk Management Training 350 - City Staff Travel to attend identified training 900 Advertising 1,990 -I Employee Recruitment Advertising Copier Maintenance I 1,000 Memberships I 965 -I Washington Emp. Public Relations Association _ 1801 -]Society for Human Resources Management 320 -I AWC Drug and Alcohol Consortium _ 200 -IEvergreeen Safely Council 2651 Training I 4,465 -10n-line Training Registrations 965 -I Blodd Borne Pathogens _ 1,000 -IDriving Safety 1,500 - - Global Hazardous Materials Labeling _ 1,00.0 Health and Wellness Events I 870 $10 per employee fee to participate in AWC Wellness _ Program. Result is an estimated$8,200 savings in Ihealth insurance premiums. Page lof2 P:11. General GovernancelBudget12014 Budget\HR Dept\HR budget worksheets 2014.xlsx General Fund 2014 Human Resources - Details Proposed Budget _Registrations 560 -IAWC Labor Relations Institute 2001 -IAWC Wellness Summit 1801 -IAWC WAPELRA Fall Labor Relations Conference 180 Total I - 237,433 Page 2 of 2 P:11.General Governance\Budget\2014 Budget\Finance Dept\Finance budget worksheets 2014.xlsx 001 General Fund 018 Operations&Administrative Services 014 Finance Division Wages/Pavroll TaxeslBenefits 014.514.23.10.00 Wages 014.514.23.10.99 Overtime 014.514.23.20.00 Payroll Taxes and Benefits Supplies 014.514.23.31.01 014.514.23.31,02 014.514.23.31.03 014.514.23.31.08 014.514.23.32.01 014.514.23.35.01 Office&Operating Supplies Forms Publications Repair&Maintenance Supplies Fuel Small Tools&Minor Equipment Other Services&Charges 014.514.23.02.01 Uncollectible Accounts Expense 014.514.23.41.05 Professional Services 014.514.23.41.17 014.514.23.42.01 014.514.23.42.03 014.514.23.43.01 014.51423.48.02 014.514.23.49.01 014.514.23.49.02 014.514.23.49.04 014.514.23.49.06 014.514.23.49.07 014.518.90.49.09 Advertising Postage Cell Phones Travel/Mileage Copier Maintenance Subscriptions Memberships Registrations Miscellaneous Services Training Bank Statement Corrections&Errors 2010 2011 2012 Actual Actual Actual 626,569 563 213,176 840,308 663,055 96 240,343 903,495 646,114 284 248,727 895,125 2,854 1,230 144 0 0 0 4,228 5,744 109 223 0 112 280 6,468 5,022 0 109 0 3 1,892 7,026 2013 Budget 751,008 1,000 303,525 1,055,533 85,983 2,240 125 915 540 5,323 2,940 384 1,460 460 713 6,435 (50) 0 21,011 0 1,442 540 4,234 3,818 310 890 1,348 86 12,863 1 0 0 0 1,604 540 3,041 3,620 688 1,265 1,937 83 5,885 107,468 46,543 18,664 3,000 0 500 0 0 0 3,500 0 7,800 0 1,500 600 5,400 3,800 300 1,000 10,200 0 0 0 2014 Proposed Budget 758,541 1,000 326,523 1,086,054 6,500 0 500 0 0 0 7,000 0 4,800 0 1,600 600 5,400 3,800 500 1,300 9,300 100 0 0 30,600 27,400 952,004 956,506 920,815 1,089,633 1,120,464 Total budget Increase= 2.83% Combined nonpayroll increase= 0.85% 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction 2014 Budget-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction e i/4„,,i /// a /y nk A// (3.00%) (6.00%) (9.00%) 9 8 & 417 /%,Oaf/ Afig P:11, General GovernancelBudget12014 Budget\Finance beptlFinance budget worksheets 2014,xlsx General Fund 2014 Finance- Detail Proposed l - - - - — Budget - - Wages 758,541 Overtime _ 1,000 Payroll Taxes and Benefits 326,523 -FICA, medicare, L&t, PERS Office& Operating Supplies 6,500 - Hanging files i 100+ -+File Folders 300 -I Expand folders I 200 -1 Env- Clasp 2 bx; 1 bx coin I 300 -(Tablets, envelopes 1,000 -IPens-venous types 200 -(Print Cartridges 500 -(Asset tags 200 -I Toner for copiers/printers I 200 -13 ring binders(OS Agency and Lodging Tax) 1 3001 -I Calendars-desk/wall I 3001 -I Chairs 1,3001 -(Check stock 500 -VII other I 1,1001 Publications _ I 500 Governmental Accounting,Auditing&Financial Reporting 250 _ (GAAFR) Update Assorted Governmental Accounting Standards Board 250 _ - publications Professional Services 1 4,800 help desk fill-in during annual PC lease deployment and return- - ($15/hrx 320 hours) Postage I 1,600 mailing Accounts Payable checks to vendors, outside agencies - and lodging tax correspondence Cell Phones I I 600 -1 One cell-phone for IT after hours support Travel 1 Mileage � 5,400 Washington Finance Officers Assoc(WFOA) conference-4 2,400 - employees @$600 ea -11T training-3 employees @ $100 ea 1 3001 -I Eden User Group-3 employees @$300 ea _ 900 Governmental Finance Officers Assoc(GFOA)classes-3 1,800 - employees @$600 ea Copier maintenance _ 3,800 -IFer copy fee for maintenance&toner Subscriptions 500 -IGovemment Officers Finance Assoc(GFOA)newsletter 1 250 -1 Govrnmental Acctng Standards Board newsletter 1 2501 Page 1 of 2 P:11. General GovernancelBudget12014 Budget\Finance DeptlFinance budget worksheets 2014.xlsx General Fund 2014 Finance-Detail Proposed — Budget Membership ' 1,300 Washington Finance Officers Assoc(WFOA)-2 memberships 100 - @$50 ea Governmental Finance Officers Assoc(GFOA) 2 memberships 300 - @950 ea -14/VA Society of CPAs-3 @$200 ea 6001 - American Institute of CPAs- 1 @$200 I 2001 -1ACCIS- 9 membership-@$100 I 1001 � r Registration 9,300 Washington Finance Officers Assoc(WFOA)conference-4 1,200 _ employees @$300 ea -1lT training-3 employees @$2,000 ea 6,000 -Eden User Group-3 employees @$100 ea I 300 Governmental Finance Officers Assoc(GFOA)on-line classes- 900 _ 6 employees @$150 ea Governmental Finance Officers Assoc(GFOA)classes-3 900 - employees @$300 ea Miscellaneous I ( 100 -1Miscellanoous bank fees I 1001 Total: I I 1,120,464 Page 2 of 2 001 General Fund 058 Community Development 050 Admin Division Wages/Payroll Taxes/Benefits 050.558.60.10.00 Wages 050.558.60.10.99 Overtime 050.558.60.20.00 Payroll Taxes and Benefits Supplies 050.558.60.31.01 050.558.60.31.03 050.558.60.31.05 050.558.60.35.01 P;\1.General Governance\Budget\2014 Budget\Community Development Dept\CD budget worksheets 2014.xlsx Office&Operating Supplies Publications Meeting Supplies Small Tools&Minor Equipment Other Services&Charges 050.558.50.42.03 Cell Phone(Ipad) 050.558.60.41.03 Spokane County GIS 050.558.60.42.01 050.558.60.43.01 050.558.60.48.02 050.558.60.48.03 050.558.60.49.01 050.558.60.49.02 050.558.60.49.04 050.558.60.49.07 Postage Travel/Mileage Copier Maintenance Software Licenses&Maintenance Subscriptions Memberships Registrations Training Intergovernmental Services 050.558.60.51.01 Spokane County Contracts Total Comm.Develop Admin Division 2010 Actual 2011 Actual 2012 Actual 208,461 4,219 65,333 278,013 209,432 4,130 66,666 280,228 192,309 6,919 70,000 269,228 2013 Budget 166,476 5,000 56,499 227,975 2014 Proposed Budget 1,554 1,405 1,823 0 0 0 0 67 181 956 16 1,850 2,510 1,488 3,854 1,500 200 400 1,000 3,100 172,800 5,000 54,883 232,683 1,500 200 400 1,000 3,100 0 0 0 600 600 0 16,808 29,206 0 35,000 0 0 8 100 100 1,921 4,511 548 3,500 3,500 524 1,385 1,793 4,000 4,000 0 1,076 580 5,500 9,500 425 0 148 200 200 160 713 766 700 700 582 2,910 1,885 1,500 1,500 98 0 0 0 3,710 27,403 34,934 16,100 55,100 27,366 10,645 0 10,000 0 311,599 319,764 308,016 257 175 290,883 Total budget increase= Combined nonpayroll increase= 13.11% 99.32% 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Budget with 6% Reduction 9% Reduction 2014 Bud.et-Line Item Chan•es 3% Reduction 6% Reduction 9% Reduction / ee ee 99 a a 9, 999 889 999 @ 8 �B/ ///C,'n: ':lid /H/H// / � 'S/H/e ,„A!,d/ , 0.00% 0.00% 0.00% P:11. General Governance\Budget12014 Budget\Community Development Dept\CD budget worksheets 2014.xlsx General Fund 2014 Community Development Proposed Administration Division .050.558 Budget Wages 1 Director, 1 Administrative Assistant- 172,800 Overtime administrative staff covers off hours meetings 5,000 Payroll Taxes and Benefits FICA,medicare, L&I, PERS 54,883 Office&Operating Supplies general office supplies 1,500 Publications .American Social Civil Engineers 150 200 Roberts Rules of Order-newest edition 25 Parliamentary Journal 25 Meeting Supplies Developer's Forum 200 400 Planning Commission 200 Small Tools&Minor Equipment Planning Commission Thank you awards x 300 1,000 Replacement chair 700 Cell Phone(Ipad) iPad connection for the director. New addition to assist director in being more productive 600 Spokane County GIS GIS Services, SCIMap,other contracted services with Spokane County 35,000 (Total paid to Spokane County for GIS is estimated at $150,000 including$140,000 in Community Development and$10,000 in Public Works) Postage Covers all required and necessary mailed correspondence 100 Travel/Mileage NW Economic Development Council 1,500 3,500 Northwest Regional Floodplain Conference 2 X 3 nights 1,500 Continuing Education Credits for Certification for CFM 500 Copier Maintenance Based on actual charges to repair department machines 4,000 Software Licenses&Maintenance SMARTGov Maintenance 7,500 9,500 upgrade to Adobe Creative Suite 2,500 Subscriptions Engineering Professional Journal, 150 200. Parliamentary Law Review 50 Memberships American Association of Civil Engineers(ASCE) 235 700, Inland Northwest Chapter of the National Association of Parliamentarians(INPLU) 25 American Institute of Parliamentarians(AIP)-Alyce Baker 10 Washington Association of Floodplain Managers(WAFM) 30 Northwest Regional Floodplain Managers Association (NORFMA)X 2 50 Association of State Floodplain Managers(ASFPM)X 2 250 International Association of Administrative Professionals 100 Registrations NORFMA(floodplain)conference x 2 800 1,500 Parliamentary Law conference 200 Economic Development Seminar 300 floodplain management training(CEC) 200 290,883 Page 1 of 1 P:\1.General Governance\Budget\2014 Budget\Community Development Dept\CD budget worksheets 2014.xlsx 001 General Fund 058 Community Development 055 Development Engineering Division Wages/Payroll Taxes/Benefits 055.558.50.10.00 Wages 055.558.50.10.99 Overtime 055.558.50.20.00 Payroll Taxes and Benefits Supplies 055.558.50.31.01 055.558.50.31.03 055.558.50.31.05 055.558.50.31,06 055.558.50.32.01 055.558.50.35.01 Office Supplies Publications Meeting Supplies Safety Equipment Fuel Small Tools&Minor Equipment Other Services&Charges 055.558.50.41.03 Spokane County GIS 055.558.50.41.05 Professional Services 055.558.50.41.18 055.558.50.42.01 055.558.50.42.03 055.558.50.43.01 055.558.50.48.01 055.558.50.48.02 055.558.50.48.03 055.558.50.49.02 055.558.50.49.03 055.558.50.49.04 055.558.50.49.05 055.558.50.49.06 055.558.50.49.07 055.558.70.49.09 Legal Notices Postage Cell Phones Travel/Mileage Equipment Repair&Maintenance-train Copier Maintenance Software Licenses&Maintenance Memberships Printing&Binding Registrations Filing&Recording Fees Miscellaneous Services Training Petty Cash Reimbursement Intergovernmental Services 055.558.50.51.01 Spokane County Contracts Total Development Engineering Division 2010 Actual 2011 Actual 2012 Actual 368,074 252 117,651 485,977 388,167 1,180 138,042 527,389 410,553 114 157,317 567,984 3,699 4,484 940 0 131 54 787 17 0 0 45 0 2,220 2,478 2,244 1,389 784 13 8,095 7,939 3,251 2013 Budget 2014 Proposed Budget 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud•etwith 6% Reduction 9% Reduction 2014 Budget-Line Item Chan.es 3% Reduction 6% Reduction 9% Reduction 544,884 501,408 / 'r b8 •8> 6 'r 6 e 1,000 1,000 / 8 r66 666 , / 6/ 219,011 207,556 6 �" 0 y6 "' // //%i / ,% vi mil, 764,895 709,964 7�AM, ?t1�s,'-�%o lffi °%////////0/%6 �$%� ? /,' /��.,®v 3,000 3,000 ®s 66 666 6s6 e �' 6 er 400 400 ///A '6 ^66 / 200 200 66 6 200 200 66 ,0 as 6 8/ 7,800 9,800 /4ii 3,000 5,000 0$6 648 666 $ 6 6 1,000 1,0008 ,,asp /4,,666 6 6 /e ooi: o 868 066 886 8 S 6'• 46 6#6 96 r88 98 r68 6 8 ''si��////& 0 29,414 50,691 0 35,000 18,376 17,640 42,589 30,000 30,000 0 0 0 200 200 3,700 3,243 2,674 400 400 9,552 2,578 461 1,000 1,000 1,839 1,952 4,167 4,000 3,700 0 60 1,329 1,000 1,000 900 2,423 2,145 1,000 1,000 1,218 4,472 4,521 8,500 8,500 711 360 897 1,300 1,300 57 0 0 500 500 4,536 2,195 2,527 5,000 4,500 0 0 0 250 250 0 0 20 0 0 0 0 478 0 0 31 9 0 0 0 40,920 64,346 112,499 53,150 87,350 66,479 37,410 7,764 25,000 0 601,471 637,084 691,498 850,845 807,114 Total budget increase= (5.14%) Combined nonpayroll increase= 13.03% 0.00% 0.00% i 0.00% 6 /d. 6 / /8/ P:11. General GovernancelBudget12014 Budget\Community Development Dept1CD budget worksheets 2014.xlsx General Fund 2014 Community Development Proposed Engineering Division .055.559 Budget 1 Dev Sery Manager, 1.5 Engineers, 1 Asst. Engineer, 0.5 Engineering Technicians, 1 Salaries &Wages Development Inspector, 1 ROW Inspector, 1 Office Assistant MOVED 1.0 Engineering Technician to BLDG 501,408 Overtime Construction Inspector to attend meetings with contractors and emergency call-outs 1,000 Payroll Taxes and Benefits FICA, medicare, L&I, PERS 207,556 Office Supplies standard office supplies 3,000 Publications AASHTO Standards 400 Meeting Supplies Developer's Forums 200 Safety Equipment Safety Yellow work shirts and Vests 100 200 caution tape, marking paint, hard hats 100 Fuel fuel for 2 vehicles 1 ROW inspector and 1 Construction Inspector 5,0Q0 This category includes items that are purchased to last longer periods of time than Small Tools& Minor Equipment traditional office supplies. Examples: tape measures, extra long levels, staplers and staples (construction grade for notices), GPS unit (shared), calculators, measuring wheels 1,000 Spokane County GIS GIS Services, SCIMap, other contracted services with Spokane County 35,000 (Total paid to Spokane County for GIS is estimated at $150,000 including$140,000 in Community Development and$10,000 in Public Works) Professional Services David Evans, survey Contract. (code requirement) 30,000 Postage Covers all required and necessary mailed correspondence 400 Cell Phones phone and lap top wireless connection for 2 Inspectors 1,000 Travel/Mileage 3,700 NORFMA Floodplain conference 800 Traffic Control 400 GIS Training BOO Stormwater- Detention Pond Design 100 Construction Inspection Training 600 Principals of Hot Mix Asphalt 200 Communications Training 200 Page 1 of 2 P:11. General GovernancelBudget12014 Budget\Community Development Dept\CD budget worksheets 2014,xlsx Minutes and Note Taking 100 Concrete Pavement Inspection 200 Flagger Training 50 Traffic Engineering Training 100 Project Inspection mileage 100 General meeting mileage 50 Legal notices are required for Development Legal Notices Engineering requirements, drainage easements, ROW easements 200 Equipment Rental Maint-Contract Vehicle Maintenance on 2 vehicles, one is and older S-10 PU and being driven considerable 1,000 Copier Maintenance Actual charges as the copier and plotter need to be maintained 1,000 Software Licenses & Maintenance SMARTGov Maintenance 7,500 8,500 FEMA floodplain software upgrade 1,000 Memberships Members of American Society of Civil Engineers (ASCE) 600 1,300 Association of State Floodplain Managers (ASFPM) 200 Washington Association of Floodplain Managers 100 Road Builders Association 200 Northwest Regional Floodplain Managers Association (NORFMA) 200 Printing & Binding printing new street standards and standard plan updates 500 Registrations 4,500 NORFMA Floodplain conference 400 Traffic Control 600 GIS Training 1,000 Stormwater- Detention Pond Design 500 Construction Inspection Training 600 Principals of Hot Mix Asphalt 400 Communications Training 150 Minutes and Note Taking 110 Concrete Pavement Inspection 500 Flagger Training 40 Misc Local Training 300 Filing & Recording Fees Filing & recording fees are the fees charged by Spokane County to record easements and requirements for Development Engineering 250 Total Engineering 807,114 Page 2 of 2 PM.General Governance\Budget\2014 Budget\Community Development Dept\CD budget worksheets 2014.xlsx 001 General Fund 058 Community Development 056 Planning Division/Code Enforcement Wartes!Pavroll Taxes/Benefits 056.558.60.10.00 Wages 056.558.60.10.99 Overtime 056.558.60.20.00 Payroll Taxes and Benefits Supplies 056.558.60.31.01 056.558.60.31.03 056.558.60.31.05 056.558.60.31.06 056.558.60.32.01 056.558.60.35.01 Office Supplies Publications Meeting Supplies Safety Equipment Fuel Small Tools&Minor Equipment Other Services&Charges 056.558.60.41.01 Accounting&Auditing 056.558.60.41.03 Spokane County GIS 056.558.60.41.05 Professional Services 056.558.60.41.18 Legal Notices 056.558.60.42.01 Postage 056.558.60.42.03 Cell Phones 056.558.60.43.01 Travel/Mileage 056.524.60.48.01 Equipment Repair and Maintenance 056.558.60.48.02 Copier Maintenance 056.558.60.48.03 Software Licenses&Maintenance 056.558.60.49.01 Subscriptions 056.558.60.49.02 Memberships 056.558.60.49.03 Printing&Binding 056.558.60.49.04 Registrations 056.558.60.49.05 Filing&Recording Fees 056.524.60.49.08 Code Enforcement Abatement 056.558.60,49.09 Petty Cash Reimbursement Intergovernmental Services 056.556.60.51.01 Spokane County Contracts Total Planning/Code Enforcement Division 2010 2011 2012 Actual Actual Actual 541,375 71 179,386 720,832 479,284 13 169,263 648,560 2013 Budget 514,355 552,708 0 1,000 182,741 205,163 697,096 758,871 1,547 3,073 1,311 152 368 192 216 738 0 0 90 0 0 9 4,848 940 2,080 6,763 5,119 3,682 2014 Proposed Budget 560,580 1,000 21 5,776 777,356 3,200 400 1,000 150 0 2,500 7,250 3,200 400 1,000 150 4,000 2,500 11,250 400 0 0 29,414 15,541 7,123 0 0 59,972 8,796 5 0 3,421 900 0 125 3,295 0 4,323 133 8,146 45 89,561 70,027 143,822 0 50,691 58,409 7,247 789 0 2,158 5,546 2,423 2,145 0 0 129 350 2,982 3,176 462 1,471 2,622 4,408 7,143 6,193 0 3,397 30 0 54,675 18,629 0 0 50,000 8,000 3,000 1,200 3,500 1,000 6,000 200 3,300 2,000 4,000 6,000 10,000 0 0 35,000 50,000 8,000 3,000 1,200 4,500 3,000 1,000 9,500 200 2,900 2,000 4,000 6,000 10,000 0 98,200 140,300 0 35,000 0 871,831 742,335 844,600 899,321 928,906 Total budget increase= Combined nonpayroll increase= 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction 2014 Bud•et-Line Item Chan•es 3% Reduction 6% Reduction 9% Reduction /� e 9 as a $$a eaa , 'oaa ///4„, a /// ,,,,,,?7,7/,/, ,;;,v, f ,to $$ ,89 $a 8 $r as 4 e$ 6 $ a% •• "y $$a �e aa9 a ga ae a$ ( $ 704, ) :/e/ 9 8� 8 89$ $889 s 44a a 8 /AA',/ 4/6,1 $99$ 9 $ 8/ s 9/ o r r : 6, "ye, / � r 4.T 9� 3.29% (5.72%) (17.16%) (26.42%) 7.90% P;11. General GovernancelBudget12014 Budget\Community Development DeptICD budget worksheets 2014.xlsx General Fund 2014 Community Development Proposed CD/Planning Division .056.558 Budget Salaries&Wages 1 Planning Manager, 2 Senior Planners, 2 Planners, 560,580, 2 Code Enforcement officers, 1 Office Assistant Overtime cover after hours meetings 1,000 Payroll Taxes and Benefits ',FICA, medicare, L&I, PERS 215,776 Office Supplies general office supplies 3,200 Publications Spokane County Real Estate Forum 75 400 New Urban News 195 f Congress of New Urbanism 130 Meeting Supplies Planning Commission Meetings 500 1,000 Shoreline Master Program Open Houses 500 Safety Equipment posting stakes, caution tape, gloves, inhalation filters, 100 150 breathing masks safety vests 50 Fuel Fuel for two Code Enforcement officers I 4,000 Small Tools & Minor Equipment 'replacement label maker 600 2,500! replacement chair 600 desk scanner 1,200 mist 100 Spokane County GIS GIS Services, SCIMap, other contracted services 35,000 with Spokane County (Total paid to Spokane County for GIS is estimated at $150,000 including$140,000 in Community Development and$10,000 in Public Works) Professional Services URS -SMP regulations 30,000 50,000 GordonDerr-SMP special counsel 20,000 Filing & recording fees are the fees charged by Spokane County to record such things as final short plats, long plats and binding site plans, This is a Legal Notices revenue/expenditure neutral item given the applicant 8,000 is responsible for the recording fees, which are paid to the City to cover all of the costs associated with filing or recording Covers all required and necessary mailed Postage correspondence- public meeting mailings- has been 3,000 3,000 charged to another division Cell Phones added code officers to planning -2 officers, phones 1,200 1,200 and laptop wireless connections Travel/Mileage State APA Conference 500 4,500 Inland Empire APA conference 1,000 Shoreline Conference 200 Page 1 of 2 P:11. General GovernancelBudget12014 Budget\Community Development Dept\CD budget worksheets 2014.xlsx WA State Planning Managers Conference 300 Attendance at 2 State Code Enforcement 1 000 Conferences 500 @ 'Spokane River Forum 200 Misc travel for PTAC, SCEO, Site Selector and other 1,300 local meetings Equipment Repair and Maintenanc Repair costs for the two vehicles driven by the code 3,000 enforcement officers Copier Maintenance actual charges to repair copier, plotters, desk printers 1,000 Software Licenses & Maintenance SMARTGov Maintenance 7,500 9,500 upgrade to Adobe Creative Suite 2,500 Subscriptions Planning Commissioners Journal 150 I 200 West zoning review 50 Memberships American Planning Association/AICP x 5 1,800 2,900 Planning Association of Washington 350 APA= planning commission 450 Washington Association of Code Enforcers two 300 individual memberships Printing & Binding Printing sign brochures, clearview brochures, 2,000 Registrations Inland Empire Section -APA x 4 1,000 4,000 State American Planning Association Conference 500 Code enforcement Customer Interface training: 350 WACE sponsored training-Code Enforcement 350 Shoreline Conference 400 WA State Planning Managers Conference 350 Spokane River Forum 200 APA Certification credits -seminars 500 Misc. Workshops such as: Complete Street , Bike 350 and Ped , Airport Compatibility , Sustainability, Filing & recording fees are the fees charged by Spokane County to record such things as final short plats, long plats and binding site plans. This is a Filing & Recording Fees revenue/expenditure neutral item given the applicant 6,000 is responsible for the recording fees, which are paid to the City to cover all of the costs associated with filing or recording Code Enforcement Abatement this amount could possibly cover 1 abatement per 10,000 year. Petty Cash Reimbursement Total Planning I 928,906 Page 2 of 2 001 General Fund 058 Community Development 057 Building Division Wages/Payroll Taxes/Benefits 057.519.70.19.00 Developer Mitigation Costs 057.558.5010.00 Wages 057.558.50.10.99 Overtime 057.558.50.20.00 Payroll Taxes and Benefits P:\1.General Governance\Budget12014 Budget\Community Development Dept\CD budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual 51,238 715,939 970 251,848 1,019,993 0 729,771 285 263,211 993,287 0 743,340 1,308 276,551 1,021,199 2013 Budget 0 734,274 500 301,508 1,036,282 2014 Proposed Budget 791,430 500 345,026 1,136,956 Supplies 057.558.50.31.01 Office&Operating Supplies 3,825 2,876 5,999 3,000 3,000 057.558.50.31.02 Forms 0 1,860 0 3,000 3,000 057.558.50.31.03 Publications 7,812 346 851 7,000 7,000 * 057.558.50.31.06 Safety Equipment 137 9 140 200 200 057.558.50.32.01 Fuel 12,595 16,902 10,992 18,000 12,000 057.558.50.35.01 Small Tools&Minor Equipment 1,738 522 1,511 3,000 3,000 057.558.70.35.03 Non Capital Office Furniture&Equipmet 0 0 2,152 0 0 26,107 22,515 21,645 34,200 28,200 Other Services&Charges 057.558.50.40.01 Credit Card&Bankcard Fees 057.558.50.41.03 Spokane County GIS 057.558.50.41.05 Professional Services 057.558.50,41.18 Legal Notices 057.558.50.42.01 Postage 057.558.50.42.03 Cell Phones 057.558.50.43.01 Travel/Mileage 057.558.50.45.07 Interfund Vehicle Lease 057.558.50.48.01 Equipment Repair&Maintenance 057.558.50.48.02 Copier Maintenance 057.558.50.48.03 Software Licenses&Maintenance 057.558.50.49.01 Subscriptions 057.558.50.49.02 Memberships 057.558.50.49.04 Registrations 057.558.50.49.05 Filing&Recording Fees 057.558.50.49.06 Miscellaneous Services Intergovernmental Services 057.558.50.51.01 Spokane County Contracts Capital Outlays 057.558.50.64.02 057.594.58.64.15 Computer Software/Hardware SmartGov Permit System Software Interfund Payments for Service 057.558.50.95.01 Workstation Costs Total Building Division 0 0 13,166 17,000 17,000 0 29,414 50,691 0 35,000 4,322 2,721 2,187 5,000 3,500 0 0 0 0 0 2,064 2,514 1,772 1,000 1,000 0 7,407 7,425 8,000 8,000 2,097 3,115 1,408 4,600 3,800 0 8,400 0 8,400 8,400 0 626 6,043 1,000 3,000 5,848 5,869 5,514 7,500 7,500 0 0 0 6,000 9,500 0 99 350 100 100 505 585 950 600 1,700 2,195 1,918 1,318 3,000 2,500 2 2 0 0 0 0 133 320 0 1,500 17,033 62,803 91,144 62,100 102,500 47,890 18,629 0 30,000 0 3% Reduction Budget Reduction Exercise (Does not reflect recommended course of action) 2014 Budget with 2014 Bud et-Line Item Changes 6% 9% 3% 6% 9% Reduction Reduction Reduction Reduction Reduction '66 68 9 gE 6 @ `&j� 1X3.°,b,1f1F .fa 62F 1/Z 1/i."o ii%/',R ,` 41@,2 i%//A.�`1:11. " c/@E8 000 a 000 @ a 0 6ea 666 o aea / 985 66@ ® 0 6 84 66 * @@ 66a 6 a bE8 6&6 866 8 6 6 @a,.,,,/,/ 8 @ 8 �� , ' 4 0 6 NW8 R gy S a i%%gL,yy�(�6 @ �// �/�/, 6 'y //y A6 6- 8 E 5 / //..,/ Q 6%io/i ,//,j n9 i 0 0 155 0 0 0 64,308 86,384 0 0 / 6 / p ' ', a / „" @ , / 0 0 3,666 C 6 a / / ,/ -@ / o6 %�'*¢.,rf..: 1,111,023 1,161,522 1,224,040 1,162.582 1,267,656 Total budget increase= Combined nonpayroll increase= 9.04% (3,96%) (3.96%) (3.96%) 3.48% P:11. General Governance\Budget12014 Budget\Community Development DeptICD budget worksheets 2014.xlsx General Fund 2014 Community Development Proposed Building Division .057.559 Budget 1 Building Official, 1 Sr Plans Examiner, 1-0.50 Plans Salaries &Wages Examiner, 3 Building Inspectors, 1 Dev Sery 791,430 Coordinator, 2 Permit Facilitators, 2 Planners, 1 Office Assistant, ADD 1 Engineering Technician Overtime inspectors to meet contractors at job site beyond hours 500 if necessary Payroll Taxes and Benefits FICA, medicare, L&I, PERS 345,026 Office & Operating Supplies general office supplies 3,000 Forms Inspection Tags 500 3,000 Target Date sheets 500 Permit Paper 2,000 Code books and update publications for 10 employees Publications this is not a code year, however next year is a code 7,000 year and new books will need to be purchased for everyone safety vests, safety glasses, hard hats, flashlights, Safety Equipment safety kits for the vehicles, yellow caution tape, dust 200 masks, water jugs for vehicles, Gas & Oil fuel for inspectors trucks 4 vehicles 12,000 Small Tools & Minor Equipmen Replacement chairs x 2 1,200 3,000 replacement label printer x 2 1,200 'caution tape, safety gloves, shoe covers, permit cover 600 bags, construction grade staplers. Credit card fees charged by banks-cannot calculate Credit Card & Bankcard Fees the amount, varies by bank, by card, by charge, by 17,000 bank holder state. Finance has not charged the CC fees however have said they will be doing so. Spokane County GIS GIS Services, SCIMap, other contracted services with 35,000 Spokane County (Total paid to Spokane County for GIS is estimated at $150,000 including$140,000 in Community Development and$10,000 in Public Works) Professional Services GPS Services -Seattle Public Utilities 1,000 3,500 Some projects require professional expertise that we do not have on staff Among these services we could need outside review by professionals such as engineers, architects, industrial hygienists or other 2,500 specialty professionals for projects proposing complex structural systems; or large important buildings like assemblies and hospitals; or alternate construction materials. Postage Covers all required and necessary mailed 1,000 correspondence, certified mail Page 1 of 2 P:11. General GovernancelBudget12014 Budget\Community Development Dept\CD budget worksheets 2014,xIsx Cell Phones 6 phones, 1 for GPS connection and 4 laptop wireless 8,000 connections Travel/Mileage WABO-four in-state technical/professional meetings; 1,000 3,800 one person each meeting, two-day meeting Planner to APA Conference 500 WSAPT Meetings- two in-state technical/professional 500 meetings; one person each meeting; one-day meeting Inland Empire APA conference 200 Certifications-one per year 500 Certification Renewals-one per year 500 Inland Empire Chapter in-state code training; one 500 person, three-day training AICP Certification 100 Vehicle Replacement Costs accrue to account for replacement of vehicles. Need 8,400 Equipment Repair and Mainten repair and maintenance of inspectors trucks x4 3,000 Copier Maintenance actual charges to maintain 2 printers, 2 large format 7,500 copier scanners, plotter Software Licenses& Maintenar SMARTGov Maintenance 7,500 9,500 update sign calculating software 2,500 Subscriptions Building Law Bulletin 100 Memberships International Code Conference (ICC) governmental 185 1,700 membership APA memberships for 2 planners 600 American Planning Association (APA), American Institute of Certified Planners (AICP), eng tech 500 Inland Empire Chapter, ICC-five individual 300 memberships Washington Association of Building Officials 40 governmental membership Washington Association of Permit Technicians three 75 individual memberships Registrations- WABO-four in-state technical/professional meetings; 1,000 2,500 one person each meeting, two-day meeting Inland Empire APA conference eng tech 200 AICP Certification 300 State Building Code Council meetings-four-eight per year state code development; one-day meeting; no 500 travel or meal charges to City Planner attend APA Conference 500 Miscellaneous Services rug service for Permit Center, shreading services 1,500 Total Building 1,267,656 Page 2 of 2 001 016 Non-Deoartmental 000.586,82.00.16 000.586.83.00.00 000.586.83.04.00 000.586,83.07.00 000.586.87.00.02 000.586.89.00.09 000.586.89.00.12 000.586.89.00.13 000.586.89.00.14 000.586.89.00.15 000.586.92.00.03 000.586.91.00.04 000.586.88.00.05 000.586.96.00.00 000.586.97.00.00 000.586.97.00.01 000.586.83.00.31 000.586.83.00.32 000.586.99.00.00 General Fund Public Safety State Remittance Vehicle License Fraud State Remittance-Emerg.Med.&Trauma Care Crime Victims Fund-Spokane County Law Library-Spokane County State Remit:Judicial Stabilization Trust State Remittance-WSP Hiway Account State Remittance-Accessible Communities State Remittance-Multimodal Transport. State Remittance-Highway Safety Acct State Remittance-Death Investigation State Remittance-PSEA 2 State Remittance-PSEA 1 State Remittance-PSEA 3 State Remittance-Crime Lab Analysis Fee State Remittance-Lab Breath/State Patrol State Remittance-Judicial IS Systems State Remittance-Auto Theft Prey State Remittance-Trauma Brain In] State Remittance-School Zone Safety Wages/Payroll Taxes/Benefits 000.521.50.10.00 Salaries&Wages 000.521.50.10.99 OT 000.521.50.20.00 Employee Benefits Supplies 000.521.20.31.01 000.521.20.31.08 000.521.20.31.09 000.521.20.32.01 000.521.20.35.01 000.521.20.35.04 000.521.20.35.05 Operating Supplies Repair&Maintenance Supplies Janitorial Supplies Fuel Small Tools&Minor Equipment Non-Capital Equipment for JAG Grant Non-Capital Equip for ARRA JAG Grant P:11,General GovernancelBudget\2014 Budget\Public Safety\Public safety budget worksheets 2014.xisx 2010 2011 2012 Actual Actual Actual 0 47,357 13,041 0 0 0 621 621 0 0 221,317 406,999 2,920 6,220 0 160,430 89,415 7,433 17,725 974,099 0 33,809 10,320 40 40 1,737 3,168 3,169 264 138 173,787 318,681 3,116 61 5,178 114,249 63,353 5,713 15,039 751,862 19 27,603 9,940 0 0 7,699 2,467 2,468 708 1,358 164,086 299,622 3,687 0 0 93,725 51,620 4,674 12,338 682,014 1,980 0 638 2,618 3,115 937 2,081 6,133 1,321 290 778 2,389 1,696 1,713 0 945 493 1,707 1,946 8,500 5,630 1,412 1,083 0 0 44,524 93,462 146,111 6,497 693 1,062 0 0 16,253 26,099 50,604 2013 Budget 0 45,450 13,130 100 100 3,030 3,535 3,535 307 303 202,000 388,850 3,030 152 5,656 298,266 60,600 7,070 15,150 1,050,264 2014 Proposed Budget 1,50 30,00 11,00 5,00 3,00 3,00 1,50 1,00 180,00 330,00 4,50 4,50 100,00 55,00 4,50 30,00 764,50 4,936 0 0 4,936 2,473 2,473 0 0 990 0 0 5,936 Page 1 of 2 2,50 1,00 3,50 3,50 3,50 20,00 27,00 3% Reduction Budget Reduc ion Exercise Does not reflect recommended course of action 2014 Budget with 6% Reduction 9% Reduction 2014 Budget-Line Item Chan•es 3% Reduction 6% Reduction 9% Reduction e gee 001 016 General Fund Public Safety Other Services&Charges 000.521.20.41.00 Professional Services 000.521.20.42.05 ARRA JAG-Wireless Cards 000.521.20.42.06 2009 JAG-Wireless Cards 000.521.20.42.07 2011 JAG-Wireless Cards 000.521.20.43.01 000.521.20.47.01 000.521.20.47.02 000.521.20.47.03 000.521.20.47.04 000.521.20.48.02 000.521.20.49.06 000.521.20.49.07 000.521.20.49.21 000.521.20.49.22 000.521.50.44.03 000.521.50.48.01 Travel/Mileage Electricity/Gas Water Sewer Waste Disposal Copier Maintenance Miscellaneous Srvs/Contingency Cry Wolf Charges&Fees Sterling Bank Fees CryWolf Refunds Taxes and Assessments Law Enforcement Building Repair&Maint Intergovernmental Services 000.512.50.51.02 District Court Contract 000.515.31,51.01 Public Defender 000.515.31.51.02 Prosecutor 000.515.31.51.03 Pretrail Services 000.515.31.51.04 Prosecutor-Funded by JAG Grant 000.515.91.52.00 000.521.20.51.01 000.521.71.52.01 000.521.71.52.02 000.521.71.52.03 000.521.71.52.05 000.521.71.52.06 000.521.71.52.07 000.521.71.52.08 000.521.71.52.09 000.523,20.51.04 000.523.60.51.02 000.523.60.51.04 000.525,60.51.03 000.528.60.51.05 000.554.30.54.02 Intergovernmental Payments Law Enforcement(Sheriff) Nighttime Seatbelt Patrol Overtime Hwy 27 Traffic Safety Overtime X-52 DUI Overtime Drive Hammered-get nailed grant Traffic Safety Emergency Child Car Seat Overtime Slow Down or Pay Up Stickman Knows Work Release(Geiger) Jail:Geiger County Contracted Services Jail-Geiger Corrections Center Emergency Management Communications Animal Control Interfund Payments for Service 000.597.20.95.04 Building Replacement Costs 000.597.12.00.30 Interfund Transfer to 123 Total Public Safety P:\1.General Governance\Budget\2014 Budget\Public Safety\Public safety budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual 2013 Budget 2014 Proposed Budget 0 1,765 0 0 0 0 498 488 0 0 0 9,964 6,334 0 0 0 0 3,213 0 0 212 0 0 0 0 23,866 29,266 21,603 33,880 30,000 2,080 1,804 1,385 2,541 1,750 754 847 849 847 900 3,423 3,423 3,504 2,964 4,000 0 0 0 0 0 0 0 0 367,735 500,000 36,616 33,314 45,568 45,450 48,000 4,316 4,365 5,057 0 7,000 1,360 1,769 0 0 2,000 0 0 358 0 400 52,730 50,940 59,194 74,153 77,400 125,357 137,955 147,553 527,570 671,450 814,284 1,098,465 792,455 898,375 891,304 485,456 705,375 769,295 672,894 852,965 396,151 484,799 421,087 393,219 406777 83,137 144,713 102,300 125,838 102,894 12,403 97 0 0 0 30,855 0 0 0 0 16,296,352 16,885,482 16,853,600 16,599,835 18,144,552 3,196 3,000 1,783 0 0 4,799 0 0 0 0 7,891 0 0 0 0 0 6,943 5,876 0 0 5,565 0 0 0 0 3,587 2,436 0 0 0 6,677 2,734 0 0 0 0 0 3,992 0 0 471,530 796,160 429,420 0 0 492,620 689,636 976,681 1,301,540 1,501,222 127,520 0 0 0 0 81,116 59,622 80,877 82,291 81,398 243,670 190,738 206,445 208,151 0 314,255 306,923 284,926 268,351 287,081 19,881,064 21,376,123 20,928,737 20,550,494 22,268,193 80,000 77,600 0 0 0 0 0 80,000 0 0 80,000 77,600 80,000 0 0 21,071,638 22,495,784 21,891,297 22,139,200 23,734,643 Page 2 of 2 3% Reduction Budget Reduction Exercise (Does not reflect recommended course of action) 2014 Budget with 2014 Budget-Line Item Changes 6% 9% 3% 6% 9% Reduction Reduction Reduction Reduction Reduction i 58b' ar sz -,; , , r , A /; ',iizapszyz " b®; 11 a s e f 8� / /4 / / /// /, ,r'% , i e a, a 7 bi � �i � is /ii � i 7.21% (100.00%) (100.00%) (100.00%) P:\1.General Governance\Budget\2014 Budget\Parks&Recreation Dept1P&R budget worksheets 2014.xlsx 001 General Fund 076 Parks&Recreation 000 Admin Division Wanes/Payroll Taxes/Benefits 000.576.80.10.00 Wages 000,576.80.10.01 Temporary/Seasonal Wages 000.576.80.10.99 Overtime 000.576.80.20.00 Payroll Taxes and Benefits 000.576.80,20.01 Temp/Seasonal Taxes&Benefits Supplies 000.576.80.31.01 Office&Operating Supplies 000.576.80.31.02 Forms 000.576.80.31.03 Publications 000.576.80.31.07 Clothing&Uniforms 000.576.80.31.08 Repair&Maintenance Supplies 000.576.80.32.01 Fuel 000.576.80.35.01 Small Tools&Minor Equipment Other Services&Chartres 000.576.80.41.03 000.576.80.41.04 000.576.80.41.05 000.576.80.41.17 000.576.80.42.01 000.576.80.42.02 000.576,80.43.01 000,576.80.48.01 000.576.80.48.02 000.576.80.49.01 000.576.80.49.02 000.576,80.49.03 000.576.80.49.04 000.576.80.49.06 IT Support Legal Notices Professional Services Advertising Postage Telephone Services Travel/Mileage Equipment Repair&Maint Copier Maintenance Subscriptions Memberships Printing&Binding Conference Registrations Miscellaneous Services Internovernmental Services 000.576.80.51.02 Stormwater Fees 000.597.10.95.05 IF Transfer to:ER&R Equipment Repl Total P&R Admits Division 2010 Actual 2011 Actual 2012 Actual 145,201 148,759 154,825 1,910 0 0 O 245 120 45,063 46,304 49,417 142 0 0 192,316 195,308 204,362 1,149 1,513 1,744 43 0 0 0 0 0 33 45 51 7 0 47 2,450 3,050 2,824 O 0 842 3,682 4,608 5,508 2013 Budget 159,936 0 0 61,781 0 221,717 1,800 0 0 0 2,500 3,000 1,000 8,300 2014 Proposed Budget 166,812 0 55,531 0 222,343 1,800 0 0 150 2,500 3,000 1,000 8,450 4,308 4,641 1,435 4,300 2,000 0 0 0 0 500 0 6,892 18,213 10,000 12,500 0 0 0 500 0 393 425 451 700 500 499 508 523 600 600 1,928 2,512 1,785 2,100 2,250 0 138 256 0 0 1,828 1,246 1,573 1,500 1,500 221 192 312 150 300 882 886 630 750 700 350 915 2,643 500 1,500 O 0 0 1,100 1,100 25 219 437 500 500 10,434 18,574 28,258 22,700 23,950 10,379 10,208 12,550 11,000 13,000 0 7,000 7,000 7,000 7,000 10,379 17,208 19,550 18,000 20,000 216,811 235,698 257,678 270,717 274 743 Total budget increase= 1.49% Combined nonpayroll increase= 6.94% 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction 2014 Budget-Line Item Chan.es 3% Reduction 777. 7/77, / 6% Reduction 9% Reduction 88$ f8i / 89 @$@ 8 8 @• ii B6 @fr 8@ 8 @ /' a @B *2; 8 @ B/ a4B9 & @j Ai r / ii''///�..0/f44/ b`°`JH�B % "pa/"4X $. i l/d,/'�i, �$ %y H 888 BBB 40/,7/ y48$� $ $B' B A sa{ ,41011$ iB /t/ ZAstgA ,0444.1 ,A4LOtift AV)) (4.55%) (4.55%) (4.55%) P:11.General GovernancelBudget12014 Budget\Parks&Recreation Dept1P&R budget worksheets 2014.x1sx General Fund 2014 P&R Detail Worksheet _ Proposed _ I Budget 76 ADMINISTRATION DIVISION - 000.576.80.10.00 Salaries&Wages 166,812 000.576.80.10.01 Temporary/Seasonal Wages 000.576.80.20.00 Payroll Taxes and Benefits 55,531 FICA,medicare,L8I,PERS - - 000.576.80.20.01 Temporary/Seasonal Payroll Taxes and Benefits 000.576.80.31.01 Office&Operating Supplies 1,800 Items printed&mounted 150 Office Depot and/or Staples: Punter Cartridges:22$86,2 @$68 288 Misc.Supplies: Post-It Notes,calendars, 1,362 labels,paper clips,binder caps,staples - — paper,letterhead,pens,pencils/leads, sheet protectors,binders,folders,etc. 000.576.80.31.08 Repair&Maintenance Supplies 2,500 Items not covered in Parks Maintenance Contract 2,500 000.576.80.32.01 Fuel 3,000 - - Department vehicles-3 3,000 000.576.80.31.07 Clothing&Uniforms _ 150 000.576.80.35.01 Small Tools&Minor Equipment 1,000_ - - Vabeter,printer,etc. 1,000 000.576.80.41.03 IT Support 2,000 JMaintenance cost ofregtstration freservationsoftware - - 2,000 000.576.80.41.04 Legal Notices 500 000.576,80,41,05 Professional Services 12,500 Consultant work for Sand Volleyball courts 7,500 Misc.consultant work 5,000 Postage 500 000.576.80.42.02 Telephone Services _ 600 [Alarm monitoring at Mira beau Meadows 600 000,5.76.80.43,01 Travel/Mileage 2,250 WRPA Conference April 8-11 Seattle 750 NRPA Conference Oct. 14-16 Charlotte 1,600 000.576.80.48.02 Copier Maintenance 1,500 000.576.80.49.01 Subscriptions 300 000.576.80.49.02 Memberships 700 Director WA Recreation and Parks Assoc(WRPA) 250 Director-Nal Recreation and Parks Assoc(NRPA) 250 - - - Administrative Staff - 200 — 000.576,80.49.03 Printing&Binding 1,500 �8rochures,fryers 1,500 000.578.80.49.04 Conference Registrations _ 1,100 Staff Training 200 NRPA Conference Oct.8-11 Houston 600 JWRPA Conference April 16-19 Vancouver 300 000.576.80.49.06 Miscellaneous Services _ _ 500 000.576.80.51.02 Stormwater Fees 13,000 000,597.10.95,05 IF Transfer to ER&R Equipment Replacement 7,000 Total - -- 274,743 Page 1 of 8 001 General Fund 076 Parks&Recreation 300 Maintenance Supplies 300.576.80.31.08 300.576.80.35.01 Repair&Maintenance Supplies Small Tools&Minor Equipment P:\1.General Governance\Budgeti2014 Budget\Parks&Recreation Dept\P&R budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual 2013 Budget 2014 Proposed Budget 18,916 27,801 6,881 25,000 5,000 170 65 5,252 2,500 5,000 19,086 27,866 12133 27,500 10,000 Other Services&Charges 300.576.80.41.05 Parks Maintenance Contract 597,419 606,478 701,060 710,000 735,000 300.576.80.44.03 Taxes and Assessments 0 0 0 1,000 3,200 300.576.80.47.01 Electricity 8,804 11,161 10,680 13,000 13,000 300.576.80.47.02 Water 15,702 17,075 18,976 18,000 19,000 300.576.80.47.03 Sewer 13,278 13,591 5,689 14,000 10,000 300.576.80.49.05 Miscellaneous Services 1,929 3,286 2,231 5,500 6,000 Capital Outlays 300.594.76.63.02 300.594.76.63.05 637,132 651,591 738,636 761,500 786,200 Discovery Playground Improvements 23,853 0 0 0 Park Structures-Capital 0 0 6,545 0 23,853 0 6,545 0 Total Maintenance 680,071 679,457 757,314 789 000 0 796,200 Total budget increase= 0.91% Combined nonpayroll increase= 0.91% 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction 2014 Budget-Line Item Chan.es 3% Reduction 6% Reduction YArAr s/ 4' e / G,bl,4,aL,$le // %YS.°l"�, e°.i, / //.. / e A / /a, 2w ///�aee f�s/a�, / ea� �a�s�a�a�e re ae di// aa /89 & a' / '8& 8 B® ab�ae ,a aaa a a ' YAXN ff a ///h ////I "/ ii J J /� ,j/7 /1 j � fla / / r / //ela /, , j /(//./ ' i /5i, ',, ,f �/// %%. / ./ / - //j#,;/ //// %7 4//A.k, ,B" f a �// f S a d .../_ 4ae'.a ;aA/� z a s 9% Reduction (1.26%) (1.26%) (1.26%) P,11.General Governance1Sudgetti2014 Budget\Parks&Recreation Dept\P&R budget worksheets 2014,xlsx _ General Fund 2014 P&R Detail Worksheet I Proposed r Budget 300 MAINTENANCE DIVISION 300.576.80.3.1.08 Repair&Maintenance Supplies 5,000 1ltems not covered under maintenance contract 5,000 300.576.80.35.01 Small Tools&Minor Equipment 5,000 Signage,kiosks,etc. 5,000 300.576.80.41.05 Park Maintenance Services 735,000 Manske Contract that Includes:mowing,watering, litter control,vegetation management,shelter& +resfroom maintenance,snow removal,play Iequpmentrepair,reservations,etc, 300.576.80.47.01 lElectricitY 13,000 300.576.80.47.02 Water —_ 19,000 300.576.80.47.03 Sewer I 1.0,000 300.576.80.49.08 Miscellaneous Services 6,000 Sullivan Park-water testing 500 Dept of Health-permits 300 Honey Buckets-Pdiradeau Trallhead 1,200 Spokane Regional Health-permits 3,000 Misc.Services 1,000 300.576.80.44.03 Taxes and Assessments 3,200 Aquifer Assessments 3,200 Total ff 796,200 Page 2 of 8 001 General Fund 078 Parks&Recreation 301 Recreation P.M.General Governance\Budget12014 Budget\Parks&Recreation Dept1P&R budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual Wanes/Payroll Taxes/Benefits 301.571.10.10.00 Wages 56,025 301.571.10.20.00 Payroll Taxes and Benefits 23,643 301.571.20.10.01 Temp/Seasonal-Wages 46,426 301.571.20.10.99 Overtime 37 301.571.20.20.01 Temp/Seasonal-Payroll Tax&Benef 4,193 130,324 Supplies 301.571.20.31.01 Office&Operating Supplies 301.571.20.31.06 Safety Equipment 301.571.20.31.07 Clothing&Uniforms Other Services&Chartres 301.571.10.49.01 Scholarship expense 301.571.10.49.23 Discount Expense 301.571.20.41.05 Professional Services 301.571.20.41.17 Advertising 301.571.20.42.01 Postage 301.571.20.42.03 Cell Phones 301.571.20.43.01 Travel/Mileage 301.571.20.48.02 Copier Maintenance 301.571.20.48.03 Software Licenses and Maintenance 301.571.20.49.02 Memberships 301.571.20.49.03 Printing and Binding 301.571.20,49.04 Conference Registrations 301.571.20.49.06 Miscellaneous Services 301.571.20.49.07 Training 301.586.10.01.00 State Remittance-Leasehold Excise' Total Recreation 57,455 59,008 27,198 29,356 48,066 38,377 236 246 4,424 4,231 137,379 131,218 3,047 150 854 4,051 3,372 501 815 4,688 2,722 128 1,370 4,220 2013 Budget 60,336 31,021 56,000 200 4,764 152,321 2014 Proposed Budget 5,550 250 900 6,700 62,856 32,882 56,000 200 4,764 156,702 4,200 250 900 5,350 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction 2014 Budget-Line Item Chan•es 3% Reduction 6% Reduction 9% Reduction a a s� sa` ess ss s s s a % / e & e t r 174111, ' ' a iwa / /✓///saa at ea is e s s :8 a @a8 8 t • Iyy°.9 t °yey8 / °a s / e9 S 8 ffY..°/S1' / d` fl.�.1.1/%I'/8"' s�ls /q.8" � /,/Xs saa sza c s e�4@ 8Affi 8'6 8 a'&$ '88 if a 160 895 464 1,000 1,000 0 0 1,876 0 0 22,123 27,184 28,770 25,200 27,500 8,430 9,919 10,341 300 800 1,578 2,378 2,069 2,400 2,000 656 745 499 800 300 564 2,540 2,151 1,800 700 1,830 1,246 1,573 1,400 1,400 0 0 2,813 0 0 226 220 120 500 500 0 0 0 11,900 8,000 0 199 0 2,000 700 11,403 11,175 11,864 16,000 14,200 627 0 1,691 0 6,654 8,586 10,038 9,000 10,000 54,251 65,087 74,269 72,300 67,100 188,626 207,154 209,707 231 321 229,152 Total budget increase= (0.94%) Combined nonpayroll increase= (8.29%) tt� ee • to sv / a tsa 8 888 /14:44,4.,/.4, r 9 44:,,,,,,„_/ f � / � et .� ss sa s (3.27%) (3.27%) (3.27%) P:\1.General GovernancelBudget12014 BudgetiParks&Recreation Dept\P&R budget worksheets 2014.xlsx General Fund 2014 P&R Detail Worksheet Proposed I _ Budget 301 RECREATION DIVISION 301.571.10.10.00 Salaries&Wages 62,856 301.571.10.20,00 Payroll Taxes and Benefits 32,882 — [FICA,medicare,L&t,PERS 301.571.20.10.01 Temporary/Seasonal Wages 56,000 Recreation Interns 2,000 Rec. Temp Seasonal Staff 52,000 301.571.20.10.99 Overtime 200 IRee.Temp Seasonal Staff 200 301.571.20.20.1 Temporary/Seasonal Benefits 4,764 301.571.20.20.99 Employee Benefits OT 301.571.20.31,01 Office&Operating Supplies - 4,200 Recreation Program Supplies 2,750 'Summer Camp T-shirts 1,050 I Rec.Coord.Office Supplies 300 'Business Cards 100 301.571.20.31.06 Safety Equipment _ 250 First Aid Supplies 250 301.571.20.31.07 Milling&Uniforms 900 Rec.Temp Seasona Staff T-shirts 600 301.571.10.49.01 Scholarship Expense 1,000 'Recreational program scholarships 1,000 301.571.20.41.05 Professional Services 27,500 First Student Field Trip Transportation for Camps 6,000 T Instructor/PresenterFees 14,000 Summer Oddoor Movies Screen&License 7,500 301.571.20.42,01 Postage 2,000 Rec guides,flyers,brochures,refunds,etc. 2,000 301.571.20.42.03 Ceti Phones 300 301.571.20.43.01 Travel/Mileage 700 I WPRA Annual Conference 700' 301.571.20.41.17 Advertising 800 'Newspaper Advertisements 800 301.571.20.48.02 Copier Maintenance 1,400 301.571.20.49.02 Memberships 500 WRPA Annual Membership NRPA Annual Membership 260 250 301.571,20.49.03 Printing&Binding 8,000 Recreation Brochure(2 times a year) 8,000 301.571.20.49.06 Miscellaneous Services 14,200 Summer Day Camp Field Trips 9,000 Program Scharships 700 Program Banners 500 —v Dog Swim/Parents Night 500 First Aid/CPR Training forSummer Staff 1,000 — Family Special Events 1,0001 Haunted House special event supplies 2,000 301.571.20.49.04 Conference Registrations 700 WRPA Annual Conference 700 301.586.10.01.00 State Remit-LH Excise Tax 10,000 I For SpiashDown&Western Dance Halt Total I 229,152 Page 3 of 8 001 General Fund 076 Parks&Recreation 302 Aquatics Supplies 302.576.20.31.01 302.576.20.31.02 302.576.20.35.01 Office&Operating Supplies Forms Small Tools&Minor Equipment P:\1.General Governance\Budget12014 Budget\Parks&Recreation Dept\P&R budget worksheets 2014.xlsx Other Services&Charges 302.576.20.41.01 Merchant Charges(Bankcard Fees) 302.576.20.41.05 302.576.20.41.17 302.576.20.42.01 302.576.20.42.02 302.576.20.44.03 302.576.20.47.01 302.576.20.47.02 302.576.20.47.03 302.576.20.48.01 302.576.20.49.03 302.576.20.49.06 302.57620.49.23 Professional Services Advertising Postage Telephone Service Taxes and Assessments Electricity Water Sewer Equipment Repair&Maintenance Printing&Binding Miscellaneous Services Scholarship Expense Total Aquatics 2010 2011 2012 Actual Actual Actual 914 1,947 31 0 0 0 945 1,947 0 0 5,053 5,053 2013 Budget 1,988 358,053 0 1,020 3,840 2,616 26,935 16,259 6,747 0 820 1,710 0 419,788 1,458 385,965 0 0 4,018 3,204 25,481 11,572 11,396 0 420 2,338 215 446,067 1,600 374,424 0 0 4,301 3,183 23,916 12,177 10,091 1,562 473 2,110 405 434242 2,000 0 500 2,500 1,500 385,000 500 0 4,100 0 26,000 16,500 11,000 35,000 500 2,500 500 483,100 2014 Proposed Budget 2,000 0 500 2,500 1,500 389,000 500 0 4,100 0 26,000 16,500 11,000 35,000 1,000 2,500 800 487,900 3% Reduction Budget Reduc ion Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction 2014 Budget-Line!tern Chan.es 3% Reduction 6% Reduction 9% Reduction %s $$ � $a �� 4$ bEE $$ R 8 $ $$ $$ a o.a# a;$E :$$ E 420,733 448,014 439,295 485,600 490,400 // ,0 9a? �' .. ^?$ � s_=g"t 4.°Ee m a0, 40 AA Total budget increase= Combined nonpayroll increase= 0.99% 0.99% (7.93%) (15.86%) (31.68%) P;11.General GovernancelBudget12014 Budget Parks&Recreation Oept\P&R budget worksheets 2014.xIsx General Fund _ 2014 P&R Detail Worksheet _ Proposed Budget I 302 AQUATICS DIVISION _ 302.576.20.31.01 Office&Operating Supplies 2 0170 302.576.20.35,01 Small Tools&Minor Equipment __ -- 500 302.576.20.41.01 MMerchant Charges(Bankcard Fees) 1,500 302.576.20.41,05 Professional Services 389,000 I YMCA Maintenance&Management contract 302.576.20.42.02 Telephone Service $4,100 1Phone&Data tines for three pools 302.576.20.41.17 Advertising — — 500 302.576.20.47.01 Electricity - 26,000 302.576.20.47.02 Water I 16,500 302.576,20.47.03 Sewer 1 _ 11,000 302.576.20.48.01 Equipment Repair&Maintenance 3.5,000 ]Repaint Park Road Pool Tank 35,4°O 302.576.20.49.03 Printing&Binding 1,000 De/elopment&printing of aquatics brochure 302.576.20.49.06 Miscellaneous Services 302.576.20.49.23 Scholarship Expense 800 ` Scholarships for swim lessons&swim teem 800 Total 490,400 Page 4 of 8 001 General Fund 076 Parks&Recreation 304 Senior Center WaneslPavroll Taxes/Benefits 304.575,50.10.00 Wages 304.575.50.10.01 Temporary/Seasonal Wages 304.575.50.10.99 Overtime 304.575.50.20.00 Payroll Taxes and Benefits 304.575.50.20.01 Temp/Seasonal Taxes&Benefits Supplies 304.575.50.31.01 304.575.50.31.08 304.575.50.35.01 Office&Operating Supplies Repair&Maintenance Supplies Small Tools&Minor Equipment Other Services&Charges 304.575.50.41.17 Advertising 304.575.50.42.01 Postage 304.575.50.43.01 TraveUMileage 304.575.50.48.01 304.575.50.48.02 304.575.50.48.03 304.575.50.49.02 304.575.50.49.04 304.575.50.49.06 304.575.50.49.07 P:\1.General Governance\Budget12014 Budget\Parks&Recreation Dept1P&R budget worksheets 2014.xisx Equipment Repair&Maintenance Copier Maintenance Software Licenses and Maintenance Memberships Conference Registrations Miscellaneous Services Training Total Senior Center 2010 Actual 2011 Actual 2012 Actual 55,873 57,408 59,070 0 0 2,564 0 83 0 13,975 15,110 16,174 0 0 401 69,848 72,601 78,209 2013 Budget 818 140 0 958 908 52 0 960 529 50 2,276 2,855 60,324 0 0 17,369 0 77,693 2014 Proposed Budget 62,832 0 18,850 0 81,682 1,000 500 2,000 3,500 500 0 2,000 2,500 452 463 446 1,000 500 0 0 0 200 100 0 0 0 500 500 O 0 0 1,000 1,000 1,830 1,246 1,573 1,500 1,500 400 600 0 600 0 55 80 45 100 100 O 20 20 1,050 500 O 0 3,049 1,000 1,500 O 370 0 0 2,737 2,779 5,133 6,950 5,700 73,543 76,340 86,197 88,143 89,882 Total budget increase= 1.97% Combined nonpayroll increase= (21.53%) 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud.et with 6% Reduction 9% Reduction ,0 "$ v0 d a0 0 $ 09 $ 0 / s e `3' 0 $ 8 $$0 00$ 1% %//' /i/j '/// //V %," 1/ "/ ' / / / $$ 2014 Budget-Line Item Chan•es 3% Reduction 6% Reduction 9% Reduction /l//./% %% /' //�/// %/////„T, e40 $ A/. kI ,. $fi ZI ® ea9 : (2.23%) (2.23%) (2.23%) P:11.General GovernancelBudget12014 Budget\Parks&Recreation DeptOP&R budget worksheets 2014.xlsx General Fund =2014 P&R Detail Worksheet _ 304 SENIOR CENTER DIVISION I 304.575.50.10.00 Salaries&Wages 62,832 304.575.50.20.00 Payroll Taxes and Benefits 18,850 (FICA,medicare,L&f,PERS 304.575.50.3.1,01 _Office&Operating Supplies 500 Paper,ink cartridges,folders,etc. 500 304.575,50.35.01 Small Tools&Mlnar Equipment 2,000 replace card tabfos and class room tables 2,000 304.575.50.42.01 Postage 100 304.575.50.43.01 Travel/Mileage 500 Value Summit,Doyle,etc. - 500 304.575.50.41.17 Advertising – - — 500 Spokesman Review,Senior Directory,Dex Directory 500 304.575.50.48.01 Equipment Repair&Maintenance 1,000 !Service Kilns&clean greenhouse windows 1,000 304.575.50.48.02 Copier Maintenance 1,500 304.575.50.48.03 Software Licenses and Maintenance 304.575.50.49,02 Memberships 100 WSASC Membership 100 304.575.50.49.04 Registrations 500 l Misc.Tratnings 450 304.575.50.49.06 'Miscellaneous Services 1,500 E Professional speakers/seminars 1500 Total I 89,882 Page 5of8 Phi.General Governance\Budget\2014 Budget/Parks&Recreation DeptlP&R budget worksheets 2014.xlsx 001 General Fund 076 Parks&Recreation 305 CenterPlace Wages/Payroll Taxes/Benefits 305.571.20.10.01 Temp/Seasonal-Wages 305.571.20,20.01 Temp/Seasonal-Payroll Tax&Benef 305.575.50.10.00 Wages 305.575.50.10.99 Overtime 305,575.50,20.00 Payroll Taxes and Benefits Supplies 305.575.50.31.01 305.575.50.31.02 305.575.50.31.04 305.575.50.31.05 305.575.50.31.06 305.575.50.31.07 305.575.50.31.08 305.576.50.31.09 305.575.50.35.01 305.575.50,35.03 Office&Operating Supplies Forms Linens Meeting Supplies Safety Equipment Clothing&Uniforms Repair&Maintenance Supplies Janitorial supplies Small Tools&Minor Equipment Non Capital Office Furniture&Equip Other Services&Charges 305.575.50.41.01 Merchant Charges(Bankcard Fees) 305,575.50.41.03 IT Support 305.575.50.41.05 Professional Services 305.575.50.41.06 Janitorial services 305.575.50.41.17 Advertising 305.575.50,42.01 Postage 305.575.50.42.02 Telephone Service 305.575.50.42.03 Cell Phones 305.575.50.43.01 Travel/Mileage 305.575.50.44.03 Taxes and Assessments 305.575.50,45.03 Equipment Rental 305.575.50.47.01 Electricity 305.575.50.47.02 Water 305.575.50.47.03 Sewer 305.575.50,47.04 Waste Disposal 305.575.50.48.00 Equip Rental Maint-Contracted 305.575.50.48,01 Equipment Repair&Maintenance 305.575.50.48.02 Copier Maintenance 305.575.50.48.03 Software Licenses and Maintenance 305.575.50.49.01 Subscriptions 305.575.50.49.02 Memberships 305.575.50.49.03 Printing&Binding 305.575,50.49.04 Registrations 305.575.5649.06 Miscellaneous Services 305.575.50.49.07 Training Capital Outlays 305.594.73.64,02 Computer Software/Hardware 305.594.73.64.07 Update sound system In great room Interfund Payments for Service 305.597,12.00.30 Interfund Transfer to 123 305.59760.95.01 Building Costs 305.597.50.95.02 Vehicle Replacement Costs Total CenterPlace 2010 Actual 2011 Actual 2012 Actual 43,201 3,169 212,161 1,551 83,516 343,598 42,876 3,767 200,431 2,200 90,670 339,744 49,949 6,022 227,942 3,938 131,696 389,547 2013 Budget 50,000 4,305 244,332 2,500 109,265 410,902 2014 Proposed Budget 50,000 4,305 248,076 2,500 115,234 420,115 10,638 43 7,864 1,889 0 996 11,522 22,179 15,080 0 70,411 7,512 0 7,284 835 111 1,781 10,121 26,026 5,905 221 59,758 8,416 68 15,743 176 0 246 17,384 15,205 25,664 0 82,900 8,175 0 12,000 735 1,000 2,066 12,000 28,546 6,425 0 68,947 8,256 0 15,975 735 1,000 2,066 13,300 18,755 4,100 0 64,187 5,935 0 10,382 91,777 102,668 4,444 9,896 1,460 1,093 0 0 86,339 3,903 526 8,916 0 11,783 1,829 1,200 790 1,451 500 6,012 478 351,362 5,348 133 14,865 77,464 31,540 5,177 8,194 1,538 912 0 0 84,566 506 1,997 8,910 0 10,621 1,246 1,200 790 1,750 1,145 3,098 0 260,998 6,400 0 13,852 92,702 56,485 242 11,012 960 1,041 452 377 90,762 2,890 2,162 9,547 230 14,786 1,673 4,663 0 2,485 1,225 3,937 896 318,679 6,000 6,000 250 250 11,945 14,055 85,000 91,590 60,000 33,000 5,200 5,200 9,000 10,600 1,700 900 2,050 6,000 0 0 0 0 85,000 85,000 10,000 15,000 10,500 10,500 9,725 9,495 500 500 11,000 11,000 1,500 1,500 1,200 1,200 800 800 2,275 2,275 1,155 1,155 2,450 3,870 6,070 2,855 321,535 314,540 17,332 0 17,332 0 11,311 11,311 0 0 0 0 0 317,000 0 317,000 317,000 0 0 0 0 0 0 317,000 317,000 317,000 0 1,099,703 986809 1,108,126 800.884 798,842 Total budget increase= (0.25%) Combined nonpayroll increase= 13.01%) 3% Reduction Budget Reduction Exercise (Does not reflect recommended course of action) 2014 Budget with 2014 Bud,9et-Line Item Changes 6% 9% 3% 6% 9% Reduction Reduction Reduction Reduction Reduction i f.taf s S 'a t s ss a a:toft f ty N i i y/ /j//////). da 4 f�a a/r /.a/aa ±Y ;gy %/. vLfx($ { / a % i a s i ///:' / %/ ////'/////�.J° /f////� t 9t %////" .�/ + /�i/' a/ �//////. ',/ 'L`/u�%/9'` • H (0.39%) (7.23%) (7.23%) P:'O.General Governance\Budget12014 Budget\Parks&Recreation Depl4P&R budget worksheets 2014,xlsx General Fund , 2014 P&R Detail Worksheet _ I Proposed Budget 305 CENTERPLACE DIVISION 305,571.20.10.01 Temporary/Seasonal Wages 50,000 305.571.20.20.01 Temporary/Seasonal Payroll Taxes and Benefits 4,305 305.575.50.10.00 Salaries&Wages _ 248,076 305.575.50.10.99 Overtime: 2,500 305.575.50.20.00 Payroll Taxes and Benefits 115,234 'FICA,medicare,L&1,PERS 305_575.50.31.01 'Office&Operating Supplies 8,256 File Folders(20 boxes @$15/box) 300 Hanging Fife Folders(2 boxes i@ 622/box) 44 Letterhead(100 sheets) 125 Envelopes(6 boxes @$50/box) 700. Pens(24 boxes @$6.50/box) 156 I Misc.office Supplies(white out,binders,post-it notes, 950 _ - - 'Kitchenware(pumper pots,water pitchers,dishrepla& 3,000 Coffee&Coffee Supplies(creamer,stir sticks,cups,s _ 1570 Kleenex(6 pack $9/pk) 140 Flags(4) 225 Labels(address labels,folder labels,etc) 125 'Batteries(for cordless microphones) 250 Tape 110 Business cards 280 I ReplecementAVEquipment 200 305.575.50.31.0.4 Linens 15,975 Table linens&napkins for over 234 events 15,975 305.575.50,31.05 'Meeting Supplies 735 `1 Easels,white board replacement, 135 'Projector bulbs 600 305.575.50.31.06 Safety Equipment 1,000 Servicing fire extinguishers 1000 305.575.50.31.07 Clothing&Uniforms 2,066 140 staff shirts(2 per person)@$36/shirt 1,440 115 staff zip jacket or pullover(1/pp)@ 41.71/ea 626 305.575.50.31.08 Repair&Maintenance Supplies _ 13,300 Fillers 4,300 Light bulbs 1,500 Misc.(nuts,bolts,glue,wood) 4,000 Paint&supplies 2,000 Elec trice,supplies 1,500 305.575.50.31.09 Janitorial supplies 16,755 Cleaning supplies 6900 Paper products&garbage bags 7855 _ Misc. ---- --- --- - - - -- - 600 - - Ciswasherlcleaning supplies 4,000 Carpet Cleaning 2,000 Floor waxing 1,500 305.575.50.35.01 Small Tools&Minor Equipment 4,100 Hand tools,extension cords 1,000 Thermal imager 3,100 305.575.50.41.01 Merchant Charges(Bankcard Fees) 6,000 305.575.50.41,03 I IT Support - 250 305.575.50.41.05 Professional Services _ 14,055 -_ 'Window washing 3,000 I Alarm(monitoring agreement),repair&keys 870 'Elevator 1,695 - Life Safety Testing(sprinklers,back laws) 2,300 Rotor Rooter I 500 Mist,services(answering service) 1,490 ` Event Catering to be reimbursed by customers 4,200 1- Page 6 of 8 • P.41.General Governance\Budget42014 Budget\Parks&Recreation Dept1P&R budget worksheets 2014.xlsx General Fund 2014 P&R Detail Worksheet Proposed Budget 305.575.50,41.06 Janitorial services 91,590 Contract with(SS Facility Services 85,000 Adoitonal Room Set Up - 6,590 305.575.50.42.01 Postage _ 5,200 Brochures,flyers,reservation quotes,refunds,etc. 5,200 305.575,50,42.02 Telephone Service 10,600 Five analog phone fines for alarms,fire,811, 10,800 elevator&credit card machine - 305.575.50.42.03 _Cell Phones _ 900 14 Cell phones(2 meta and host) 900 305.575.50,43.01 Travel/Mlteage 6,000 [Attend NRPA Venue Management School 2,000 'Attend WRPA Conference in Seattle 1,000 Mileage for various meetings 500 Misc.Trainings 1,000 Maintenance Training 1,500 305.575.50.41.17 Advertising 33,000 DexAdvertising 2,000 Brochures&other printed material 3,000 Marketing folders 1,600 Develop/Print ads 9,902 Website update&hosting renewal 600 Hagadone Black Book 865 Regional Advertising 12,000 305.575.50.47.01 Electricity 85,000 305.575.50.47.02 Water _ 15,000 305.575.50.47.03 _Sewer 10,500 305.575,50,47.04 Waste Disposal 9,495 Waste Disposal $925 Recycling 570 305.575.50.48.00 Equip Rental Maint-Contracted 500 305.575.50.48.01 (Equipment Repair&Maintenance 11,000 1HVAC contract 7,500 Misc.Equipment Repair 2,000 - - I ElevatorRepair/maintenance 500 I I Refrigeratorrepalr 1,000 305.575.50.48.02 (Copier Maintenance _ _ 1,500 305.575.50.48.03 Software Licenses and Maintenance , 1,200 305.575.50,49.01 Subscriptions 800 305.575_.50,49.02 Memberships 2,275 T 'Greater Spokane Incorporated 700 (Post Falls Chamber of Commerce 225 Spokane Valley Chamber of Commerce 320 National Park&Recreation Association 120 Washington Recreation&Park Association 110 I !AVM - 445 - - Moro 125 'Spokane Hotel Motel Association 300 J!nt'!Assoc.of Business&Travel Professionals 150 inland Northwest Business Alliance 150 305.575.50.49.03 Printing&Binding _ _ 1,155 'Brochures&otherprinted material 1,155 305.575.50.49.04 Registrations 2450 1NRPA Venue Management School Year 2 950 WRPA Conference in Seattle 500 Misc.Trainings 1.000 305.575_,50,49.06 Miscellaneous Services 6,070 [Motion Picture License 530 I Bridal Festival Booth(Jan&Sept) 1,700 Page 7 of 8 P:11.General GovernancelBudget12014 Budget\Parks&Recreation Dept\P&R budget worksheets 2014,xisx General Fund 1 2014 P&R Detail Worksheet Proposed 1 Budget Eventective leads for prospective business 300 Chamber Business Fair Booth 300 Spokane Valley Chamber meetings 200 Hotel Motel meetings 205 Piano Tuning _ 150 Elevator Permits 110 Boiling and operating permit-L&i C 500 Service call on AN equipment 750 INBTA Business Fair Booth 400 /NBA Business Fair Booth 300 GSl Business Fair Booth 450 Post Falls Business Fair Booth 175 305.597.12.00.30 11F Transfer.Civic Factl.Replac Fund ++Total 798,842 PR Budget Grand Total - -- 2,679,219 Page 8 of 8 P:11. General Governance\Budget12014 Budget\Public Works Dept1PW.ST.SW budget worksheets 2014.xlsx STORM WATER FUND #402 2014 Line Item Detail 1 Proposed Budget 000.531.36.10.00 'Wages I ; 329,520 000.531.36.20.00 ;Payroll Taxes and Benefits I 17,333 (FICA, medicare, L&I, PERS 000.531.36.10.99 Overtime 2,000 000.531.36.10.01 Temp/Seasonal -Wages 129,320 000.531,36.20.01 Temp/Seasonal-Payroll Tax& Benefits - _ 2,286 000.531.36.31.03 Publications 800 'Includes misc. items where the pubic will be ^p 'no iedpby newspaper -- 3,000_. 0.0 O 0.531.36.31.04 eratin Su tibyes 'Includes all testing equipment 000.531.36,31.06 �Safety Equipment I 60.0 'Safety equipment for personell and truck- items - - include any traffic control devices needed and safety devices for trucks. I 000.531.36.32.01 Fuel _ _I 6,500 _ T Fuel for 3.5 vehicles ' 6,500 000.531.36.35.01 Small Tools & Minor i guipment ' 5,000 Includes testing equipment,spill cleanup supplies,signs, 1 and mist tools ---( - 000.531.36.41.03 IT Support — _ 10,000 I GIS License(50%of city's co st for license) 5,500 I _Scimap$70 each per month(1 user, Brodwater) $52 i — I Contingency _ 1,148 Esri Online Mapping System 2,500 000.531.36.41.05 Professional Services 68,500 [Surveying 25,000 I 'Material Testing 25,000 IDesign — 18,5001 000.531.36.41.10 Contracted stormwater maintenance I 928,776 'Street Sweeping(2012 contract$490,199.94*96%) ' 470,592 I 'Poe Asphalt Street Repair&Maintenance I 100,000 _ Landscaping Right of Ways-Ace Landscaping 2012 63,750 $85,000 *75% =$ _ Emergency Callout(50%Street/50%storrnwater) 10,000 Vactoring(Drainage structure cleaning) 2. 00,000 jContingency(10%of total) _ 84,434 1 000.531.36.42.02 Telephone Service 1,200 1Fax Line-107.92 per month,50/50 street and storm 650 Internet - - - 550 000.531.36.42.03 Cell Phones 1,400 2 Phones Brant, SW Floating, data card $37.13 per phone+ 1 wireless access point 40.01 — I 000,531.36.43.01_ Trave Airfare($300 x 3) llMileagse 3,150 Car Rental($150 x 3) 1,500 ____ - 1Lodging and mels($250 x 3 x 2 nights) 750- 900 - -_� Software Licenses & Maintenance lEsri Online Mapping System I 2,500 000.531.36.47.04 Waste Disposal _ I _ 30,000 'Disposal of sweeping and vectoring debris from I Page 1 of 2 P;11. General GovernancelBudget12014 Budget\Public Works Dept\PW.ST.SW budget worksheets 2014.xlsx the AAA Sweeping and Vactoring Contract, This I - _ is for dumping fees associated with Graham Road 000.531.36.49.02 Memberships 1 Professional Licenses a 600 APWA(3 x$133) 399 Wastewater Operator Certificate 50 1 PE license Misc _ _ 109 000.531.36.49.04 'Conference Registrations 2,000 - GIS or Python Related Training Seminars)4 x$400) 1600 APWA Conference I_ 400 000.531.36.47.01_ Electricity- Euclid Facility �} 7,650 L_ This is a estimate of the charges for electricity — _ at the Maintenance Facility at 17002 E. Euclid. 12 month average of$1275 per month or$15,300 per year. This is paid by 1/2 Street and 1/2 Storm 000.531.36.47.03 Sewer- Euclid Facility _ 300 Sewer charges_at the Maintenance Facility located at 17002 E. Euclid. The cost is$50 per I I month and is paid for 1/2 by street and 1/2 by Stormwater I 000.531.36.48.01 !Equipment Repair& Maintenance I I 2,0__0_0_ _ 1750 Per vehicle-Oil changes+Misc repairs 000.531.36.48.04 Repair and Maintenance- Euclid Facility _7,000 All expenses are shared 50/50 with the Street Fund Building Cleaning 2X Monthly$300 per month 2100 Garbage Service _ 1068 Industrial Park Dues _ 1110 500 1 _ Yearly Furnace Cleaned Contingency _ 2222 000.531.36.44.01 Taxes and Assessments 500 -- 'Yearly Propetry taxes _ x00.531.36.51.20 Ecology Permit _ 26,000 _-__ Yearly cost of operating under the DOE _ 000.597.00.00.01 Interfund Transfer-General Fund OH 13,400 000.597.55.95.03 Vehicle Replacement Fund ' 1,567 Capital Outlays I I 000.594.38.63.05 (Stormwater Improve- Capital Outlay 1 700_,000 'This Is the estimate for the Small Works Projects I 48000.0 __ to be completed in 2013. This will repair multiple - drainage problems throughout the city based on SAREF score. _ _ Pavement Preservation Retrofit-Update SW I 'structures in current preservation projects 2200001 Stormwater Improvements-Small Works Design _200,000 ' - - _ 'Consultant design for the additional proposed 'small works projects —� I Property acquisition I Securing and Maintaining floodways or floodplainsl New truck- Stormwater 3 aff em two interns currently share 1 vehicle.stm Increasing bers and stromwater work will require the need for an additional vehicle for inspections etc. 'Variable Message System (VMS)Trailer I I This would be used for advanced warning notifications of upcoming projects or for emergency situations Total Stormwater 2,502,902 Page 2 of 2 001 General Fund 032 Public Works Department Wanes/Payroll Taxes/Benefits 000.543.10.10.00 Wages 000.543.10.10.99 Overtime 000.543.10.20.00 Payroll Taxes and Benefits Supplies 000.543.10.31.01 000.543.10.31.03 000.543.10.31.06 000.543.10.32.01 000.543.10.35.01 000.543.10.36.02 P:\1.General Governance\Budgett2014 Budget\Public Works Dept\PW.ST.SW budget worksheets 2014,xlsx 2010 Actual 2011 Actual 2012 Actual 460,515 418,066 393,702 5,317 2,515 1,521 144,562 129,436 121,534 610,394 550,017 516,757 2013 Budget 546,222 5,000 190,771 741,993 2014 Proposed Budget Office Supplies Publications Safety Equipment Fuel Small Tools&Minor Equipment Non Capital Computer Software/Hardwa Other Services&Charges 000.513.10.42.03 Cell Phones 000.534.10.48.01 Equipment Repair&Maintenance 000.543.10.41.02 Engineering&Architectural 000.543.10.41.03 Spokane County GIS 000.543.10.41.18 Legal Notices 000.543.10.42.01 000.543.10.42.03 000.543.10.43.01 000.543.10.44.17 000.543.10.45.03 000.543.10.48.02 000.543.10.48.03 000.543.10.49.01 000.543.10.49.02 000.543.10.49.03 000.543.10.49.04 000.543.10.49.05 000.543.10.49.06 000.543.10.49.07 000.543.50.45.03 Postage Cell Phones TraveVMileage Advertising Equipment Rental Copier Maintenance Software Licenses&Maintenance Subscriptions Memberships/Professional Licenses Printing&Binding Conference Registrations Filing&Recording Fees Miscellaneous Services Training Equipment Rental Capital Outlays 000.594.32.64.02 Computer Software/Hardware Vehicles 000.597.30.00.30 Interfund Transfer to 303 Total Public Works 4,451 4,740 5,412 715 1,928 448 168 1,647 2,125 2,631 2,639 3,511 538 6,000 4,385 5,231 0 0 13,734 16,954 15,881 5,000 2,000 3,000 3,500 6,000 6,000 25,500 0 540 135 0 0 0 3,385 0 28,871 46,716 51,213 48,000 13,539 22,319 12,868 23,000 0 0 157 0 574 616 558 550 1,773 2,175 4,539 3,000 5,965 4,110 5,197 6,800 0 0 430 0 564,126 2,000 195,777 761,903 6,000 1,000 2,000 5,500 5,000 0 19,500 3,400 48,000 10,000 0 600 2,800 7,000 0 0 4,400 15,425 0 4,000 0 8,200 0 0 0 0 103,825 3% Reduction Budget Reduction Exercise Does not reflect recommended course of action 2014 Bud•et with 6% Reduction 9% Reduction 2014 Budget-Line Item Chan•es 3% Reduction 6% Reduction 9% Reduction y:// , , /, s 9 9 @./,„ , , , /Q00 a @@ 089 @ @ /x/, /z i'i/7// z ; ?'/z/./,„Y /��9j 0@G 994 8 ,// 4998`; � $8 @ g /,;:.7/. 8 V 8 @ 9 a 0 iB 944, @ 9@ A: : o. 8 fsil-141.: j, a 9 @/ •8A 88 •&@ �9 8 a/ • $e / / ate. °�%! 808° "89/ / u e 009 aa@ 999 0 @0 8 9 9 @ s 9sa 4: : �9 @ 9 @ al/e 0 0 278 0 a @/ ems//// e �f% 9 3,812 3,896 5,371 4,000 @% 12,667 9,955 11,985 12,000 //549 235 0 0 0 / @ e @ 9 9 @/ 1,543 4,336 1,385 4,000 eaa @ @� a e @ e9 0 326 0 0 /9 @ a' 457 25 483 7,600 •e9 @ ea e@ ��sa 10 0 0 0 • � ""/ %m i i%�%/// 4,019 6,622 5,428 0 4 a ;//4/ @ @ a 19 0 0 0 e 4 9 a @/ 0 0 1,200 0 @ 9 a@ 73,484 101,646 104,612 108,950 • i ii�a ,,/,/,y4,040, //,:,,,,,,,,,/,:./... * pL. 2/ZAM 6,348 0 4,594 0 D a a a ¢ a p / a e a e @ s 0 0 64,750 0 04 s 4 @ ¢ ®/ fie/��// // (////yq�q�y�y// //iai 6,346 0 69,344 703,958 668,617 706,594 876,443 885,228 Total budget increase= 1.00% (8.27%) Combined nonpayroll increase= (3.02%) (6.02%) (9.05%) P:11. General GovernancelBudget12014 Budget\Public Works Dept\PW,ST.SW budget worksheets 2014.xlsx GENERAL FUND 2014 PUBLIC WORKS DEPARTMENT-DETAILS Proposed Budget 000.543.10.10.00 Wages 564,126 000.543.10.10.99 Overtime 2,000 000.543.10.20.00 Payroll Taxes and Benefits 195,777 FICA, medicare, L&l, PERS I 000.543.10.31.01 Office Supplies 6,000 Includes all regular office supplies,filing supplies for capital projects, plotter paper, engineering supplies 000.543.10.31.03 Publications 1,000 Misc. Public Notices-A recent Examples include Sullivan Bridge Weight Restriction Notices. 000.543.10.31.06 Safety Equipment 2,000 This includes all safety supplies such as Safety Vests, eye protection, hearing protection, hard hats, Saftey lights for vehicles,temporary traffic control equipment. 000.643.10.32.01 Fuel 5,500 3 vehicles plus 1.5 summer vehicles Taurus, Explorer, Dakota, 1.5 New vehicles 000.543.10.35.01 Small Tools & Minor Equipment 5,000 This includes tape measures, surveying equipment, levels, and other misc. devices that would be used to inspect contractors work. 000.543.10.36.02 Non Capital Computer Software/Hardware Phones, monitors, and other misc. supplies. 000.534.10.48.01 Equipment Repair& Maintenance 3,400 Oil Changes, Tires, Misc Repairs on 4.5 Vehicles at$750 per vehicle 000.543.10.41.02 Engineering &Architectural 48,000 TIP Management(.5 General Fund/.5 Street Fund) 40,000 Contingency 8,000 Recent examples have included contracts for the Sprague-Appleway Couplet Evaluation, Survey work, development of Right of way Polies and Procedures, planning level estimates for the new maintenance facility. 000.543.10.41.03 Spokane County GIS 10,000 Citrix-2 License support agreement$4.17/month 100 Skymap-8 users at$70 per month 6,720 Craig, Marcy, Steve, Ken, Intern, Kipp, Ingo,Torn, Shane GIS License Fee$100/month 1,200 Map requests would be performed by Spokane Co 2,000 (Total paid to Spokane County for GIS is estimated at $150,000 including$10,000 in PW and$140,000 in Community Development divisions) 000.543.10.42.01 Postage 600 Expense charged to PW for all outgoing mail Page 1 of 2 P:11. General GovernancelBudget12014 Budget\Public Works Dept1PW.ST,SW budget worksheets 2014.xlsx 000.543.10,42.03 Cell Phones 2,800 5 Phones-2 (pads $37.13 per phone, 40.01 per ipad Craig, temp inspector, pete, temp inspector erica, eric ipad 000.543.10.43.01 TravellMileage 7,000 Car Rental ($150 x 4) 600 Flights ($300 x 4) 1,200 Lodging& Meals($300 x 4 x 2) (average of 2 nights; 2,400 Misc training classes (12*$125) 1,500 Other Misc. 1,300 000.543.10.48.02 Copier Maintenance 4,400 Upkeep on copiers, 3 year averages 000.543.10.48.03 Software Licenses & Maintenance 15,425 Culvert, Flow Master, Pond Pack Support Renewal 1,825 TranSoft 3,000 AutoCad 7,003 Adobe Prof 500 Cartegraph 2,000 SRTC Visum 1,100 Support Renewals&other misc. 000.543,10.49.02 Memberships 1 Professional Licenses 4,000 Professional Engineer(6 X$120) 600 American Public Works Association(4 x$133) 532 International Municipal Signal Association ($40 x 1) 40 American Society of Civil Engineers ($235 x 2) 470 Contingency 2,358 000.543.10.49.04 Conference Registrations 8,200 Class Registration&Webinar fees (10 staff x 2 classes x$250) 5,000 4 staff($400 x 4)-APWA,WSDOT, Rd&St Confere 1,600 Other Misc, Training 1,600 Capital Outlays Autocad Licenses 1 new network license and upgrade current standalone to network license to make the program more available to all employees New vehicles - CIP inspections 1.5 new vehicles for CIP-This will help current staff that are currently using personal vehicles to visit project sites. Total PW: 885,228 Page 2 of 2 Public Works Department Fund#101-Street Fund RECURRING ACTIVITY Wages/Pavroll Taxes/Benefits 000.542.10.10.00 Wages 000.542.10.10.01 Temp/Seasonal-Wages P:\1.General Governance\Budget\2014 Budget\Public Works Dept\PW.ST.SW budget worksheets 2014.xlsx 2010 2011 2012 Actual Actual Actual 2013 Budget 2014 Proposed Budget 234,008 284,322 329,554 370,860 382,716 0 0 0 26,000 26,000 000.542.10.10.99 Overtime 7,826 10,906 5,847 15,000 10,000 000.542.10.20.00 Payroll Taxes and Benefits 77,236 112,200 128,456 158,360 168,157 000.542.10.20.01 Temp/Seasonal-Payroll Tax&Benefits 0 0 0 2,950 2,949 000.542.66.10.00 Snow Plow-Wages 0 18,056 64,391 0 0 000.542.66,10.99 SnowPlow-Overtime 0 3,664 17,544 0 0 000.542.66.20.00 Snow Plow-Payroll Taxes and Benefits 0 6,362 26,556 0 0 319,070 435,510 572,348 573,170 589,822 Supplies 000.542.10.31.04 Operating Supplies 1,186 3,285 1,410 1,200 1,500 000.542.10.32.01 Fuel 8,433 9,088 9,609 8,000 10,000 000.542.10.35.01 Small Tools&Minor Equipment 22,981 25,944 20,655 20,000 20,000 000.542.30.31.08 Repair&Maintenance Supplies 33,112 45,868 72,926 43,000 60,000 65,712 84,185 104,600 72,200 91,500 Other Services&Charges 000.542.10.41.02 Engineering&Architectural 263,148 248,547 179,287 320,000 220,000 000.542.10.41.05 Professional Services 10,663 0 0 0 0 000.542.10.42.02 Telephone Service 6,154 5,466 3,199 6,000 2,500 000.542.10.42.03 Cell Phones 3,967 2,424 3,505 2,000 3,300 000.542.10.45.03 Equipment Rental 0 0 5,620 0 1,000 000.542.10.47.04 Waste Disposal 3,348 3,108 395 3,600 3,000 000.542.10.48.01 Equipment Repair&Maintenance 0 0 547 0 3,000 000.542.20,43.01 Travel/Mileage 3,010 3,732 4,412 3,000 4,000 000.542.23.41.41 Uncollectible Accounts Expense 0 0 11,206 0 0 000.542.30.41.10 Contract street maintenance 1,303,501 1,487,133 1,647,810 1,500,000 1,353,899 000.542.30,41.11 Contract Street Maintenance-Ellen Rd 86 0 0 0 0 000.542.30.41.47 Utility Services 1,617 583 0 0 0 000.542.35.41.02 Non-Capital Computer Software/Hardware 0 250 400 0 0 000.542.50.48.01 Bridge/Street Maintenance&Preservation 0 213,758 11,027 118,000 118,000 000.542.83.47.01 Street Lighting 413,982 419,208 424,476 420,000 425,000 000.542.63.47.02 Water&Sprinkler 16,962 18,117 18,523 19,000 20,000 000.542.64.48.44 Traffic Control Devices-Repair&Maint. 14,848 2,000 0 0 0 000.542.64.49.03 Vehicle Replacement Costs 0 0 0 0 0 000.542.90.41.00 IT Support 0 0 85 0 0 000.542.90.49.00 Membership 190 1,943 1,000 0 0 000.542.90.49.01 Registrations 0 0 275 1,000 1,000 000.542.90.49.01 Conference Registrations 292 0 0 0 0 000.542.90.49.02 Membershlps-SRTC 0 37,195 35,107 37,552 37,552 000.543.50.45.50 Operating Facilities Rent 0 0 1,800 0 0 000.543.50.47.01 Electricity-Euclid Facility 0 126 0 6,600 7,650 000.543.50.47.03 Sewer-Euclid Facility 0 1,376 1,459 300 300 000.543.50.48.04 Repair and Maintenance-Euclid Facility 0 44,384 7,610 19,200 7,000 000.543.66.45.50 Facilities Operating Rent&Leases 25,187 25,023 2,098 0 0 2,066,955 2,514,371 2,359,841 2,456,152 2,207,201 Page 1 of 2 Public Works Department Fund#101-Street Fund P:\1.General Governance\Budget\2014 Budget\Public Works Dept\PW.ST.SW budget worksheets 2014.xlsx 2010 2011 2012 Actual Actual Actual 2013 Budget 2014 Proposed Budget Snow Operations 000.542.30.41.12 Winter Snow Services 483,111 351,102 1,702 469,000 000.542.66.31.04 Operating Supplies 0 133,095 263,146 0 220,000 000.542.66.31.08 Repair&Maintenance Supplies 0 45,080 98,841 0 50,000 000.542.66.32.01 Fuel 0 5,174 22,657 0 20,000 000.542.66.35.01 Small Tools&Minor Equipment 0 14,716 7,576 0 5,000 000.543.50.31.01 Office&Operating Supplies 0 0 5 0 0 000.542.66.41.12 Winter Snow Services 0 13,122 119,292 0 140,000 000.542.66.41.15 WSDOT Winter Snow Services 0 0 29,424 0 50,000 000.542.66.45.03 Equipment Rental 0 0 1,019 0 0 000.542.66.48.01 Equipment Repair&Maintenance 0 115 45,650 0 20,000 000.542.66.49.01 Subscriptions 0 0 1,920 0 15,000 000.542.66.49.18 Vehicle License&Registration 0 0 47 0 0 483,111 562,404 591,279 469,000 520,000 Intergovernmental Services 000.542.20,50.44.03 Taxes and Assessments 6,588 3,372 618 4,000 1,000 000.542.30.51.01 Street Maintenance-County 563,599 541,371 573,504 632,000 632,000 000.542.30.51.02 WSDOT Maintenance Contract 168,985 168,176 149,183 215,000 165,000 739,172 712,919 723,305 851,000 798,000 Interfund Payments for Service 000.542.66,90.45.07 Interfund Vehicle Lease 0 0 110,777 160,777 85,777 000.597.00.00.10 Transfer to General Fund-OH 39,675 25,000 39,600 39,700 39,700 000.597.31.00.10 Transfer to 311 0 0 0 282,000 282,000 000,597.43.95.01 Interfund Transfer-SRTC Membership 34,300 0 0 0 0 73,975 25,000 150,377 482,477 407,477 Total Recurring Activity 'NONRECURRING ACTIVITY Interfund Payments for Service 000.597.00.00.00 Transfer out 000,597.30.00.30 Interfund Transfer to 303 Supplies 000.542.10.35.02 School Zone Beacons 3,264,884 3,771,985 4,501,750 4,903,999 4,614,000 -5.91% 0 9,100 0 0 0 0 13,105 465,453 0 0 0 22,205 465,453 0 0 0 49,003 37,170 0 0 0 49,003 37,170 0 0 Capital Outlays 000.594.21.62.00 Building and Structures 0 474,091 0 0 0 000.594.32.63.03 Capital Improvements 0 49,513 0 0 0 000.594.42.63.03 Traffic Control Improvements 15,539 0 0 0 0 000.594.42.64.03 Transportation 19,553 16,900 18,000 0 0 Patch Trailer-Maintenance 0 0 0 0 0 CMAQ-SRTMC Software&Misc 0 0 0 0 0 000.594.42.64.07 Capital Equipment-Plow Truck 0 206,542 0 0 0 132-Blake Road Repair 226 0 0 0 0 133-Sprague Ave.ITS 83,563 323,609 69,378 0 0 135-Traffic Signal Phasing 30,461 0 0 0 0 136-Traffic Signal LED Replacement 15,957 67,864 1,402 0 0 147-Bike Lane Restriping 0 36,828 0 0 0 153-Broadway Ave.Resurfacing/SW Upgrade 0 330,278 167 0 0 165,299 1,505,625 88,947 0 0 Total Nonrecurring Activity 165,299 1,576,833 591,570 0 0 Total Street Fund 3,430,183 5,348,818 5,093,320 4,903,999 4,614,000 i Page 2 of 2 P:11. General Governance1Budget12014 Budget\Public Works Dept1PW.ST.SW budget worksheets 2014.xlsx STREET FUND#1011 I 2014 Line Item Detail I Proposed Budget 000.542.10.10.00 Wages 382,716 000.542.10.20.00 Payroll Taxes and Benefits I I 168,157 FICA, medicare, L&I, PERS 000.542.10.10.99 Overtime 10,000 000.542.10.10.01 Temp/Seasonal -Wages 26,000 000.542.10.20.01 Temp/Seasonal - Payroll Tax& Benefits I 2,949 000.542.10.31.04 Operating Supplies I 1,500 Misc supplies for maintenance crew, including marking paint and other supplies for marking jobsites. 000.542.10.32.01 Fuel 10,000 Fuel for 5 vehicles Shane,Traffic,Tom, .5 backhoe, .5 F550, .5 Bergan, .5 New 000.542.10.35.01 Small Tools & Minor Equipment 20,000 Tools to outfit a mechanic for winter snow operations, saws and weed eaters for city staffigeiger crews,welding equipment, etc. 000.542.30.31.08 Repair& Maintenance Supplies 60,000 Supplies including coldmix for potholes, rental equipment, street markers,welding gasses, cones, safety equipment,truck parts, crack sealing 000.542.66.31.04 Operating Supplies-Snow Removal 220,000 Mag, Sand Etc 85,000 Ice slicer 125,000 000.542.66.31.04 Repair& Maintenance Supplies-Snow Removal 50,000 Misc. items related to fixing snow plows 000.542.66.32.01 Fuel -Snow Removal 20,000 Fuel for 9 snow plows and 1 backhoe for an average snow fall winter 000.542.66.35.01 Small Tools & Minor Equipment-Snow Removal 5,000 Small tools needed to repair snow plow fleet 000.542.10.41.02 Engineering &Architectural 220,000 County Engineering Contract 25,000 TIP Management(.5 General Fund/.5 Street.Fund) 40,000 Contingency 0 Bridge Engineering Repair 50,000 Street Master Plan TIP 85,000 Street Master Plan Pavement Mgmt 20,000 000.542.10.42.02 Telephone Service 2,500 Columbia Fiber for Traffic Engineer Connection 1,272 Aircards for Miantenance Staff Fiber connections between City hall and the Maint. Shop Wind Wireless$84.95 per month Euclid 50150 550 Fax phone line @ Maint Facility 107.92 Per month 650 50%street/50% storm 000.542.10.42.03 Cell Phones 3,300 3 Cell Phones+ 2 Ipad + 2 Wireless access point Page 1 of 4 P:\1. General GovernancelBudget12014 Budget\Public Works Dept1PW.ST.SW budget worksheets 2014.xlsx STREET FUND#101 2014 Line Item Detail Proposed Budget $37.13 per cell phone, 40.01 per Ipad Mike,Tom, Shane, Shane 'pad, Traffic'pad Shane wireless access point 000.542.10.45.03 Rental Equipment 1,000 Rental Vehicles 000.542.10.47.04 Waste Disposal 3,000 Dumping fees at the local transfer stations for all garbage picked up by city crews. 2 year average of$3,228 000.542.10.48.01 Equipment Repair& Maintenance 3,000 Oil Changes,Tires, Misc Repairs on 4 Vehicles Estimated$750 per vehicles 000.542.20.43.01 Travel/Mileage 4,000 Airfare ($300 x 4) 1,200 Car Rental ($100 x 4) 400 Lodging & Meals ($200 x 4 x 3 nights) 2,400 000.542.30.41.10 Contracted Street Maintenance 1,353,899 AAA Sweeping (490199.94 *4%) 19,608 1,266,663 Street and Stormwater Maintenance Emergency Callout-Senske(50%Street 50% storm) 10,000 Landscaping Right of Ways-Ace Landscaping 2012 20,726 $82,902.72*25% =$20,725.68 Geiger Work Crew($60,000*25%) 15,000 Dead Animal Removal-City Streets 15,000 Contingency 6,902 000.542.30.41.12 Winter Snow Services Budgeted under specific line items in 2014 000.542.50.48.01 Bridge/Street Maintenance 118,000 The City has outstanding bridge maintenance repair that must be performed to keep bridges in safe condition. They are: Sullivan Rd Bridge over UPRR (NB)—hydro mill and overlay concrete deck=$150,000 Other miscellaneous repairs=$50,000 000.542.63.47.01 Street Lighting 425,000 increase due to higher costs of electricity and added street lights due to capital projects 000.542.63.47.02 Water& Sprinkler 20,000 This is the water services for all grassy areas that the city maintains such as Sprague, appleway Addition of Sprague Swales increased total 000.542.66.41.12 Winter Snow Services 140,000 Poe Asphalt Winter Contract Drivers 70,000 Road Graders (full city plow costs about$70k) 70,000 000.542.66.41.15 WSDOT Winter Snow Services 50,000 Page 2 of 4 P:11. General GovernancelBudget12014 Budget\Public Works Dept1PW.ST,SW budget worksheets 2014.xlsx STREET FUND#101 2014 Line Item Detail Proposed Budget Snow removal and treatment on Pines and Trent 000.542.66.48.01 Equipment Repair& Maintenance -Snow Removal 20,000 Outside shop repairs 000.542.66.49.01 Subscriptions - Snow Removal 15,000 Weather Reports& Misc 3,000 E-Road Track- Plow Tracking System 12,000 000.542.90.49.00 Memberships l Professional Licenses 37,552 Various Ecology, Chemical Handlers, Water Works 2,200 Operator, Flagging Certifications, Hazardous memberships Inland Empire Utility Dues 1,000 Institute of Traffic Engineers ($250 x 2) 500 American Society of Civil Engineers 250 SRTC Membership 18,000 SRTC Management Fees 15,000 2 PE Licenses 302 1 PTOE License 300 000.542.90.49.01 Conference Registrations 1,000 APWA Snow Conference 500 Misc. training in area (4 x$125) 500 Rd&St Conference,WSDOT, Flagging, Chemical, Street Safety, etc.,APWA Snow Conference 000.542.90.95.07 Plow Replacement 75,000 Money set aside each year to provide funding for a new Snow Plow each year. 000.597.60.95.03 Vehicle Replacement 10,777 Vehicle replacement program,yearly amount of money set aside for future replacement for all street fund vehicles 000.543.50.47.01 Electricity- Euclid Facility 7,850 This is a estimate of the charges for electricity at the Maintenance Facility at 17002 E. Euclid. 12 month average of$1275 per month or$15,300 per year. This is paid by 1/2 Street and 1/2 Storm 000.543.50.47.03 Sewer- Euclid Facility 300 Sewer charges at the Maintenance Facility located at 17002 E. Euclid. The cost is$50 per month and is paid for 112 by street and 1/2 by stormwater 000,543.50.48.04 Repair& Maintenance- Euclid Facility 7,000 All expenses are 50/50 with the Stormwater Fund Building Cleaning 2X Monthly$350 per month 2,100 Garbage Service 1,Q68 Industrial Park Dues 1,110 Yearly Furnace Cleaned 500 Contingency 2,222 000.543.50,44.03 Taxes&Assessments 1,000 Page 3 of 4 P:11. General GovernancelBudget12014 Budget\Public Works Dept\PW.ST.SW budget worksheets 2014.xIsx STREET FUND#101 2014 Line item Detail Proposed Budget 000.542.30.51.01 Street Maintenance-County 632,000 Traffic Signal Maintenance, Street signs, Pavement markings, 000.542,30.51,02 WSDOT Maintenance Contract 165,000 Signal Illumination 45,531 Roadway Maintenance 117,000 Reduced specific line item by$50,000 and put in snow Contingency 2,469 000.597.00.00,10 Transfer to General Fund - OH 39,700 000.597.31.00.10 Transfer to Fund 311 - Pavement Preservation 282,000 Capital Outlays New truck- Maintenance .5 Vehicle for Dana Haugen-CIP Inspector during summer and street repairs during winter Patch Trailer-2 ton Falcon Asphaly Hot Recycling Hot Patcher Equip used to heat up coldmix for better applications during cold weather operations. Pulled behind current vehicles CMAQ-SRTMC Software & Infrastructure Request from CMAQ-SRTMC to help upgrade software and infrastructure Mission/Splashdown -Traffic Upgrades Current street light does not meet current MUTDC standards. Upgrade to signal for materials only, installation done by Spokane County under current maintenance contract Total Street Fund 4,614,000 Page 4 of 4 Public Works Department Fund#402-Stormwater Management Fund (RECURRING ACTIVITY Wanes/Payroll Taxes/Benefits 000.531.36.10.00 Wages 000.531.36.10.01 Temp/Seasonal-Wages 000.531.36.10.99 Overtime 000.531.36.20.00 Payroll Taxes and Benefits 000.531.36.20.01 Temp/Seasonal-Payroll Tax&Benefits P:\1.General Governance\Budget\2014 Budget\Public Works Dept\PW.ST.SW budget worksheets 2014.xlsx 2010 2011 2012 2013 Actual Actual Actual Budget 2014 Proposed Budget 249,005 302,238 274272 325,836 329,520 0 0 0 17,333 17,333 5,146 7,457 1,683 8,000 2,000 82,904 108,179 97,939 122,149 129,320 0 0 0 2,286 2,286 337,055 417,874 373,894 475,604 480,459 Supplies 000.531.36.31.01 Office&Operating Supplies 0 0 5 0 000.531.36,31.03 Publications 129 792 0 800 800 000.531.36.31.04 Operating Supplies 0 2,656 5,074 3,000 3,000 000.531.36.31.06 Safety Equipment 402 183 0 1,000 600 000.531.36.31.08 Repair&Maintenance Supplies 1,025 122 20 0 000.531.36.32.01 Fuel 3,872 5,557 4,784 6,500 6,500 000.531.36.35.01 Small Tools&Minor Equipment 6,859 4,117 2,275 5,000 5,000 12,287 13,427 12,158 16,300 15,900 Other Services&Charges 000.531.36.41.03 IT Support 6,355 6,749 6,358 6,355 10,000 000.531.36.41.05 Professional Services 4,702 43,126 100,502 68,500 68,500 000.531.36.41.10 Contracted Stormwater Maintenance 821,551 769,758 846,816 990,000 928,776 000.531.36.41.17 Advertising 0 0 1,037 0 0 000.531.36.41.02 Telephone Service 0 0 0 0 1,200 000.531.36.42.03 Cell Phones 1,129 1,506 1,266 1,440 1,400 000.531.36.43.01 Travel/Mileage 694 2,804 3,049 3,000 3,150 000.531.36.45.03 Equipment Rental 0 0 5,274 0 0 000.531.36.47.01 Electricity-Euclid Facility 0 6 0 6,600 7,650 000.531.36.47.03 Sewer-Euclid Facility 0 0 93 300 300 000.531.36.47.04 Waste Disposal 24,451 27,012 38,837 30,000 30,000 000,531.36.47.06 Sweeping-Grant Reimbursed 0 50,000 0 0 0 000.531.36.48.01 Equipment Repair&Maintenance 0 0 96 0 2,000 Software Licenses&Maintenance 0 0 0 0 2,500 000.531.36.48.04 Repair and Maintenance-Euclid Facility 0 182 3,000 19,200 7,000 000.531.36.49.02 Memberships/Professional Licenses 256 155 139 425 600 000.531.36.49.04 Conference Registrations 116 0 130 1,300 2,000 000.531.36.49.07 Training 650 0 1,699 0 0 000.531.36.49.09 Petty Cash Reimbursment 227 110 20 0 0 000.531.36.49.50 Facilities Operating Rent&Leases Bldg 25,153 25,023 6,293 0 0 885,284 926,431 1,014,609 1,127,120 1,065,076 Intergovernmental Services 000.531.36.44.03 Taxes and Assessments 0 0 209 4,000 500 000.531.36.51.01 Spokane County-Contract Services 213 188 0 0 000.531.36.51.20 Ecology Permit 21,922 23,076 24,422 23,000 26,000 22,135 23,076 24,819 27,000 26,500 Interfund Payments for Service 000.531.30.45.07 Interfund Vehicle Lease 0 0 1,567 1,567 1,567 000.597.00.00.10 IF transfer-General Fund OH 13,386 13,386 15,000 13,400 13,400 Total Recurring Activity 13,386 13,386 16,567 14,967 14,967 1,270,147 1,394,194 1,442,047 1,660,991 1,602,902 -3.50% Page 1 of 2 lTotal Stormwater Fund 1,368,601 1,541,807 1,587,632 2,077,991 1 I 2,502,902 Public Works Department Fund#402-Stormwater Management Fund NONRECURRING ACTIVITY Capital Outlays 000.594.38.63.05 Stormwater Improve-Capital Outlay Stormwater Improvements-Capital Design Property Acquisition Vehicles VMS Trailer P:\1.General Governance\Budget\2014 Budget\Public Works Dept\PW.ST.SW budget worksheets 2014.xlsx 2010 Actual 2011 Actual 2012 Actual 2013 Budget 2014 Proposed Budget 0 0 0 150,000 700,000 0 0 0 0 200,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000.597.10.00.10 Interfund Transfer to:Street Fund 0 90,750 0 0 0 000.597.30.00.30 Interfund Transfer-Street Cap Proj 48,630 56,863 113,014 0 0 000.597.30.00.70 Interfund Transfer to Capital Grants 28,154 0 0 0 055-NPDES-Phase II Program Development 21,670 0 0 0 0 150-Sullivan Rd.Bridge Drain Retrofit 0 0 32,571 267,000 0 98,454 147,613 145,585 417,000 900,000 Total Nonrecurring Activity 98,454 147,613 145,585 417,000 900,000 Page 2 of 2 P:A1. General Governance\Budget\2014 Budget\Finance Dept\supplemental requests.xlsx CITY OF SPOKANE VALLEY,WA 6/6/2013 2014 Budget Supplemental Requests Account Number I Account Title I Description 1 Amount #001 -General Fund City Council r001.011.000,511,60.42.01 Postage welcome letter 1,100 Legal r 001.013.015.515.32.41.03 Spokane County GIS GIS services 2,500 r 001.013.015.515.32.49.05 Professional Services Service by publication 1,500 4,000 Finance r001.018.014.514.23.xx.xx Wage/PR Tax/Beneifts add a Help Desk Tech 65,000 x001.018.014,514.23.41.05 Professional Services reduce contracted help desk (4,800) 11001.090.000.518.85.41.03 IT Support reduce contracted IT support (70,000) (9,800) Human Resources x001.018.016.518.10.49.13 Employee Hlth &Wellness AWC Wellness grant 450 Public Works r 1001.032.000.543.10,xx.xx Wage/PR TaxlBeneifts add.375 FTE Planning Grants Engineer 37,500 r1001.032.000.543.10.41.02 Engineering &Architectural reduce contracted help (40,000) n1001.032.000.594.32.64.02 Computer Hrdwr/Sftvvr increase autocad network licenses 8,800 n1001.032.000.594.32.64.00 Equipment purchase 1.5 pickups(-$30,000 ea.) 45,000 51,300 Pa rks & Recreation 001.076.305.575.50.35.01 Small Tools/Minor Equip replace 50 chairs at CenterPlace ($227ea) 11,350 Police Precinct_ n1001,016 repaint building front 3,500 n1001.016 gate modification 3,500 .n 001.016 security cameras fornorth/south of bldg 12,000 n1001.016 new lockerroom floor 5,000 24,000 Total General Fund 82,400 recurring r' (6,750) nonrecurring n 89,150 82,400 Other Potential Ideas -Entry signs assume$70,000 each 70,000 -Park signs assume$2,500 each x 3 7,500 -Appleway landscaping Phase 1 250,000 -Enhanced Public Information Program 40,000 367,500 Page 1 of 2 P:\1. General Governance\Budget`2014 Budget\Finance Dept\supplemental requests.xlsx CITY OF SPOKANE VALLEY,WA 6/6/2013 2014 Budget Supplemental Requests Account Number I Account Title r Description I Amount #101 -Street Fund 101.000.000.542.10.xx.xx Wage/PR Tax/Beneifts add .375 FTE Planning Grants Engineer 37,500 101.000.000.542.10.41.02 Engineering &Architectural reduce contracted help (40,000) 101.000.000.594. Equipment purchase .5 pickups(—$30,000 ea.) 15,000 101.000.000.594. Equipment Hawk Signal at Splash Down (Mission Park) 25,000 101.000.000.594. Equipment purchase a patch trailer 30,000 101.000.000.594. Equipment CMAQ-SRTMC software infrastructure 6,750 Total Street Fund 74,250 I#309-Parks Capital Grants Fund 309.000.000.594. Capital outlay Sand volleyball courts (4)at Brown's Park 40,000 309.000.000.594. Capital outlay Edgecliff shelter replacement 65,000 309.000.000.594. Capital outlay New Discovery Playground equip 50,000 309.000.000.594. Capital outlay Add shade structure at Discovery Piaygrnd 15,000 Total Parks Capital Grants Fund 170,000 #402 - Stormwater Mgmt Fund 402.000.000.531,36.xx.xx Wage/PR TaxlBeneifts add .25 FTE Planning Grants Engineer 20,000 402.000.000.594. Equipment purchase 1.0 pickups (—$30,000 ea.) 30,000 402.000.000.594. Equipment variable messaging system (VMS) trailer 16,000 402.000.000.595. Capital Outlay property acquisitions 250,000 Total Stormwater Mgmt Fund 316,000 Page 2 of 2 BUD-I JUSTIFICATION FOR PERSONNEL OR WORK PROGRAM CHANGES Department Name Program Fund No. City Council Postage for"Welcome Letters" 000.511.60.42.01 Reason for changes in personnel or work program The City developed a "Welcome Letter"which is signed by the Mayor/City Manager and mailed to all newly registered business owners in the City of Spokane Valley. The number of letters per month is averaging between 150-250. In order to meet the demand for postage,the budget for 2013 was increased by 400% over previous usage which based on.46 cents X 200 X 12=$1100,is an accurate assessment. Normally,a budgeted amount of$250.00,based on previous history,would be allotted to this line-item. Total Cost of Change (Itemize by line-item detail only) Budget Personnel Services BARS Number Year Estimated Cost 2013 2014 2015 2016 2017 TOTAL Materials and Services 2013 postage 001.011.000.511.60.42.01 2014 1100 2015 2016 2017 TOTAL Equipment 2013 2014 2015 2016 2017 TOTAL Other 2013 2014 2015 2016 2017 TOTAL Revenue Offset Budget Year 2013 Total Cost $ - 2014 2015 Less Revenue Offset $ 2016 2017 Net Cost $ - I City of Spokane Valley 6/3/2013 BUD-1 JUSTIFICATION FOR PERSONNEL OR WORK PROGRAM CHANGES Department Name Program Fund No. Legal Reason for changes in personnel or work program To serve defendants by publication in the newspaper in code compliance cases who we are unable to locate or the owners of the property have deceased and we need to serve notice to any existing heirs of the suit. We have seen a significant increase in code compliance cases where the property owners have deceased and the title to the property is still in their name or they have walked away from the property and squatters have started living there. In order to properly effectuate service of the proceedings on all prospective defendants this is the most effeclent manner especially if we have to locate all possible heirs for proper service which includes all children and in some cases grandchildren. Service by publication is an effective way to serve several people with notice as well as any possible defendants who we are unaware may exist in a suit. Total Cost of Change (Itemize by tine-item detail only) Budget Personnel Services BARS Number Year Estimated Cost 2013 2014 2015 2016 2017 TOTAL ' Materials and Services 2013 Service by Publication(3 x approx.$500) 015.515.32.49.05 2014 1,500.00 Spokane County GIS 015.515.32.41.03 2015 2,500.00 2016 2017 TOTAL Equipment 2013 2014 2015 2016 2017 TOTAL Other 2013 2014 2015 2016 2017 TOTAL Revenue Offset Budget Year 2013 Total Cost 20081$ 2014 2015 Less Revenue Offset $ 2016 2017 Net Cost 2008 $ - City of Spokane Valley 6/3/2013 BUD-1 JUSTIFICATION FOR PERSONNEL OR WORK PROGRAM CHANGES Department Name: Program Fund No. Finance Information Technology 001 Reason for changes in personnel or work program The City typically expends roughly$100,000 per year for vendors to provide relatively routine maintenance work on our computer network. Cost for the vendor ranges between$130 and$150 per hour which averages out to approximtely 700 hours of service per year. Our existing IT staff is composed of 2 individuals who are technically capable of performing much of the work currently done by the outside vendor but are unable to do so because of time constraints resulting from being such a thinly staffed program. We believe we can hire a full-time Help Desk Technician in 2014 whose wages,benefits and payroll taxes would be approximately $65,000 per year to begin but would be a 2,080 hour per year presence who could handle the more routine IT functions during the course of the day thus allowing the IT Techs to do much of the technical work currently done by the vendor. The$65,000 cost of the additional employee would be offset with a corresponding reduction of$70,000 in the General Government portion of the budget that Is currently expended for the outside vendor as well as a$4,800 reduction in the Finance Department's professional services budget. We anticipate hiring this position would result in a General Fund savings of$9,800 in 2014. Assuming 4%per year employee increases and 0%vendor cost increases(which is unlikely)we would save money in the years 2014 through 2017 with an approximate break-even In 2018 and beyond. Total Cost of Change (Itemize by line-item detail only) Budget Personnel Services BARS Number Year Estimated Cost Help Desk Technician 001.018,014.514.23.xx.xx 2014 ' $65,000 Help Desk Technician 001.018,014.514.23.xx.xx 2015 $67,600 Help Desk Technician 001.018.014.514.23.xx.xx 2016 $70,300 Help Desk Technician 001.018.014.514.23.xx.xx 2017 $73,100 Help Desk Technician 001.018.014.514.23,xx.xx 2018 $76,000 TOTAL $352,000 Materials and Services IT Support 001.090.000.518.85.41.03 ' 2014 ($70,000) IT Support 001.090.000.518.85.41.03 2015 ($70,000) IT Support 001.090.000.518,85.41.03 2016 ($70,000) IT Support 001.090.000.518.85.41.03 2017 ($70,000) IT Support 001.090.000.518,85.41,03 2018 ($70,000) TOTAL ($350,000) Equipment 2014 2015 2016 2017 2018 TOTAL Other Professional Services 001.018.014,514.23,41.05 2014 ($4,800) Professional Services 001.018.014.514.23.41.05 2015 ($4,800) Professional Services 901.018,014.514.23.41.05 2016 ($4,800) Professional Services 001.018.014.514.23.41.05 2017 ($4,800) Professional Services 001.018.014.514.23,41.05 2018 ($4,800) TOTAL ($24,000) Revenue Offset Budget Year 2014 Total Cost 2014 $ 65,000.00 2015 2016 Expenditure Offset $ (74,800,00) 2017 2018 Net Cost 2014 $ 9,800.00) City of Spokane Valley 6/3/2013 BUD-1 JUSTIFICATION FOR PERSONNEL. OR WORK PROGRAM CHANGES Department Name Program Fund No. HR Wellness Reason for changes In personnel or work program Addition of line item to show the increase in HR expenditures of$450 that Is offsett by the AWC Mini-Grant in the same amount recieved from AWC. Total Cost of Change (Itemize by line-item detail only) Budget Personnel Services BARS Number Year Estimated Cost 2013 2014 2015 2016 2017 TOTAL Materials and Services { 2013 2014 2015 2016 2017 TOTAL Equipment 2013 2014 2015 2016 2017 • TOTAL Other 2013 AWC Wellness Grant Expenditure 2014 450 2015 2016 2017 , TOTAL Revenue Offset Budget Year 2013 Total Cost $ 450.00 AWC Mini-Grant 2014 450_ 2015 Less Revenue Offset $ 450.00 2016 2017 Net Cost $ - City of Spokane Valley 6/3/2013 BUD-1 JUSTIFICATION FOR PERSONNEL OR WORK PROGRAM CHANGES Department Name Program Fund No. -'ublic Works Planning/Grants 1001.032/101/402 Reason for changes in personnel or work program The Planning/Grants Engineer position would take the place of our current contracted consultant from Century West. The consultant employee has worked for the City in this position for the past seven years doing the same job. This position at the consultant rate costs about$80,000 per year and we get Brian about two days per week. Hiring this position at full time would cost the city about$100,000. For 20% more cost, the City would receive 70% more staff time available to pursue, track, plan and monitor grant funding for various city projects and to assist with other departmental duties as they come up. This position would be 37.5% GF, 37.2% Street and 25% SW. Total Cost of Change (Itemize by line-item detail only) Budget Personnel Services BARS Number Year Estimated Cost 2013 _Planning/Grants Engineer 2014 $ 100,000.00 2015 $ 100,000.00 2016 $ 100,000.00 2017 $ 100,000.00 TOTAL $ 400,000,00 Materials and Services 2013 2014 2015 2016 2017 TOTAL Equipment 2013 2014 2015 2016 2017 TOTAL • Other 2013 2014 2015 2016 2017 , TOTAL Revenue Offset Budget Year 2013 Total Cost 2014 $ 100,000.00 Reduce budget line items for consultants 2014 -80000 2015 -80000 Less Revenue Offset $ (80,000.00) 2016 -80000 2017 -80000 Net Cost 2014 $ 20,000.00 City of Spokane Valley 6/5/2013 BUD-2 CAPITAL OUTLAY REQUEST Department Name Program Fund No. ',ahlic Works Capital Improvement Projects 001 . 032 Description:We are requesting the purchase of 1.5 new vehicles. One pool vehicle for CIP and .5 for CIP Inspections. The other.5 vehicle would be paid from the street fund. Many employees are currently using personal vehicles, We currently have 3 vehicles for 11 staff to share. We are proposing to have the vehicle replacement fund purchase these vehicles. The additional autocad network license and conversion of standalone license to a network license will provide employees with better access to current programs that are used on a daily basis. Section 1: Capital Equipment Request Circle One Replacement Addition Unit Cost $30,000.00 X Quantity 1.5 = Total Cost $ 45,000.00 Unit Cost $ 8,800.00 X Quantity = Total Cost $ 8,800.00 Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost $45,000.00 $ 45,000.00 Personnel Cost $ - Materials&Svcs $ 8,800.00 $ 8,800.00 TOTALS $ - $53,800.00 $ - $ $ - $ - $ 53,800.00 Section 2: Capital Improvement Request Example: Building remodel, new sidewalks, parks benches, etc. Total Cost • impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost Personnel Cost _ Materials&Svcs TOTALS City of Spokane Valley 6/3/2013 BUD-2 CAPITAL OUTLAY REQUEST Department Name Program Fund No. ''arks & Recreation 'CenterPlace 076.305 Description We are requesting the replacement of 50 room chairs for use at CenterPlace. Currently we have approximately 650. The majority of our inventory is over 8 years old. When we have large events, we are short chairs and need to steal from the Senior Center or rent additional chairs. We should be replacing a portion of our chair inventory on an annual basis. Section 1: Capital Equipment Request Circle one Replacement Addition Unit Cost L $227 X Quantity 501 = Total Cost $11,350 Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS , ,Equipment Cost $11,350 $11,350 Personnel Cost Materials & Svcs TOTALS $11,350 $11,350 Section 2: Capital Improvement Request Example: Building remodel, new sidewalks, parks benches, etc. Total Cost Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost Personnel Cost _ Materials&Svcs TOTALS City of Spokane Valley 6/5/2013 BUD-2 CAPITAL OUTLAY REQUEST Department Name Program Fund No. Tiablic Works-Street Fund Street Fund 101 Description:We are requesting .5 new vehicles, This vehicle would be used by a Inspector in the winter for road repairs, This vehicle would be split half and half with CIP for summer inspections that the position is currently inspecting. The traffic control devices requested will upgrade the pedestrian signal at Splash Down (mission park) to meet current MUTDC standards. The patch trailer will be pulled behind current city vehicles and heat up cold mix for better applications during cold weather months. The software and infrastructure upgrades were requested by CMAQ-SRTMC Section 1: Capital Equipment Request Circle One Replacement Addition Vehicle Unit Cost $30,000.00 X Quantity 0.5 - Total Cost $ 15,000.00 Trailer Unit Cost $30,000.00 X Quantity 1 = Total Cost $ 30,000,00 Impact on Operating Budget _2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost $45,000.00 $ 45,000.00 Personnel Cost $ Materials&Svcs $ 6,750,00 $ 6,750.00 TOTALS $ - $51,750.00 $ - $ - $ - $ _ $ 51,750.00 action 2: Capital Improvement Request Example: Building remodel, new sidewalks, parks benches, etc. Total Cost $ 31,750.00 Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS _ Equipment Cost $25,000.00 $ 25,000.00 Personnel Cost $ - Materials &Svcs _ $ - TOTALS $ - $25,000.00 $ - $ - $ - $ - $ 25,000.00 City of Spokane Valley 6/3/2013 BUD-2 CAPITAL OUTLAY REQUEST Department Name Program Fund No. "arks&Recreation (Maintenance I 076.3001 Description We are requesting funding to begin the development of Browns Park as a sand volleyball venue. The potential exists to develop Browns Park as a northwest destination for hosting weekly sand volleyball tournaments. There has been tremendous interest in Brown's Park since we started working with the Evergreen Volleyball Association. The funding requested would construct four new sand volleyball courts. Utimtley we would be looking to have a total of twelve courts for the complex. Section 1: Capital Equipment Request Circle One Replacement Addition Unit Cost I X Quantity Total Cost Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost Personnel Cost Materials&Svcs TOTALS Section 2: Capital Improvement Request Example: Building remodel, new sidewalks, parks benches, etc. Total Cost $40,000 impact on Operating Budget _ 2013 2014 _ 2015 2016 2017 2018 TOTALS Equipment Cost Personnel Cost Materials & Svcs $40,000 $40,000 TOTALS $40,000 City of Spokane Valley 6/5/2013 BUD-2 CAPITAL OUTLAY REQUEST Department Name - Program Fund No. (''arks & Recreation Maintenance 076,300 Description We are requesting funding to replace the existing picnic shelter at Edgecliff. Currently,the shelter at Edgecliff is more than 25 years old and is in need of replacement. Edgecliff Park continues to be a very popular picnic location. This project would include an ADA accessible path from the north parking lot to the shelter. Section 1: Capital Equipment Request Circle One Replacement Addition Unit Cost r X Quantity = Total Cost Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost Personnel Cost Materials& Svcs TOTALS Section 2; Capital Improvement Request Example: Building remodel, new sidewalks, parks benches, etc. Total Cost $65,000 Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost $45,000 $45,000 Personnel Cost _ Materials&Svcs $20,000 $20,000 TOTALS $65,000 $65,000 City of Spokane Valley 6/5/2013 BUD-2 CAPITAL OUTLAY REQUEST Department Name Program Fund No. larks& Recreation 'Maintenance I 076,300 Description Discovery Playground continues to be a well used by the Community. It needs to be updated and improved from time to time to remain as one of Spokane Valley's best attractions and continue as a destination location. This funding request is to purchase and intall one new shade structure and one new playground element. The specific type of attraction will be determined during the 2013 summer season. The shade structure is estimated at $15,000 and the playground element at$50,000. Section 1: Capital Equipment Request Circle one Replacement Addition Unit Cost X Quantity - Total Cost Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost Personnel Cost Materials&Svcs TOTALS Section 2: Capital Improvement Request Example; Building remodel, new sidewalks, parks benches, etc. Total Cost $65,000 Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost $65,000 $65,000 Personnel Cost Materials&Svcs TOTALS $65,000 City of Spokane Valley 6/5/2013 BUD-2 CAPITAL OUTLAY REQUEST Department Name Program Fund No. i miblic Works -Stormwater Fund Stormwater 402 Description; We are requesting 1 new vehicle. This vehicle would be used by Stormwater staff and interns. Currently I vehicle is shared between 3 FTE and 2 Interns. The requested VMS trailer will be used for notification of construction and maintenance activities. The City will pay for the cost of these trailers under a construction project. Having our own VMS will reduce costs and be available for emergency situations, See attached for more detail. The$900,000 capital improvement requests are for additional small works projects to catch up on the current back log of stormwater problems. This includes design and construction dollars. $250,000 in property acquisitions for securing and maintaining floodways and floodplains. Section 1: Capital Equipment Request Circle One Replacement Addition Vehicle Unit Cost $30,000.00 X Quantity 1 Total Cost $ 30,000.00 VMS Unit Cost $16,000.00 i X Quantity 1 -- Total Cost $ 16,000.00 Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost $ 46,000.00 $ 16,000.00 $ 62,000.00 Personnel Cost $ _ Materials &Svcs TOTALS $ - $ 46,000.00 $ 16,000.00 $ - $ - $ - $ 62,000.00 Section 2: Capital Improvement Request Example: Building remodel, new sidewalks, parks benches, etc. Total Cost 1 $ 900,000.00 I Impact on Operating Budget 2013 2014 2015 2016 2017 2018 TOTALS Equipment Cost $ - Personnel Cost $ Property $ - Materials &Svcs $ 1,150,000.00 $ 1,150,000.00 TOTALS $ - $ 1,150,000,00 $ - $ - , $ - $ - $ 1,150,000.00 City of Spokane Valley 6/3/2013 P:\1.General Governance\Budget\2014 Budget\Finance Dept\potential and pending projects.xlsx CITY OF SPOKANE VALLEY,WA 6/12/2013 Pending/Potential Projects Worksheet Project Financing City Financed Unfunded Estimated Total Project Cost Grant Financed Secured Grants Potential/ Anticipated Grants Fund 310 Civic Buildings Capital Projects Fund 312 Capital Reserve Total Capital Protects -Sull -Balfour -Phase van Road West Bridge replacement 19,800,000 13,500,000 0 0 2,300,000 15,800,000 4,000,000 Park development(—$200,000 per acre) 2200,000 2,200,000 2,700,000 250,000 2,400,000 to 3,500,000 60,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 250,000 0 60,000 0 0 0 250,000 0 60,000 2,200,000 2,200,000 2,700,000 0 2,400,000 to 3,500,000 0 2-Appleway Trail-University to Evergreen -Phase 3-Appleway Trail-Evergreen to Corbin -Phase 1-Appleway Landscaping(Dora to Park) -Phase 2&3-Appleway Landscaping(Park to University) -Business Route Signage -Joint Site Design-Balfour Park/Library 42,150 14,000,000 0 0 10,000,000 0 ?? 0 0 11,600,000 2,500,000 ?? 0 1,100,000 0 0 0 42,150 0 0 0 ?? 42,150 1,100,000 21,600,000 2,500,000 ?? 0 12,900,000 5,400,000 -City Hall -Barker Road/BNSF Grade Separation* 27,000,000 10,500,000 ?? 8,000,000 ?? -Sewer and roads at industrial property east of Flora Rd. -Transfer Station Total of Capital Projects 81,152,150 to 82,252,1501 23,500,000 14,100,000 1,100,000 2,652,150 41,352,150 39,800,000 to 40,900,000 *also included in 6-year TIP Potential City Sources to Cover Cost -Fund#312-Capital Reserve Fund 5,173,850 ($7.826 million set aside in 2013. Of this amount,$2652 million has been committed) -Convert annual lease payment for City Hall to an LTGO 6,400,000 bond issue for the construction of a City Hall (assumes$400,000 annual lease payment for City Hall space is converted to a bond payment with bonds issued for 30-years at 4.5%with an issue cost of 2%) Future Potential Recurring General Fund Expenditures -'Balfour Park maintenance 211,000 (3 acres @$15,000 each+8.3 acres @$20,000 each) 30,000 30,000 9,500 -Appleway Trail maintenance(approximately$15,000 per mile) Phase 2-University to Evergreen(2 miles) Phase 3-Evergreen to Corbin(2 miles) -Appleway Landscaping maintenance (Per acre estimate) -Additional Police Officers 150,000 -Transfer (Estimated cost per officer including overhead support and equipment) Station/Solid Waste operations ?? 430,500 Future bond payments(cost per$1 million issued) 62,600 (assumes a 30-year LTGO issue at 4.5%with an issue cost of 2%)