The URL can be used to link to this page

Home My WebLink About2014-05-05 Ordinance 5244ORDINANCE NO. 5244 ORDINANCE OF THE COUNCIL OF THE CITY OF PALO ALTO AMENDING THE BUDGET. FOR THE FISCAL YEAR 2014 TO ADJUST BUDGETED REVENUES AND EXPENDITURES IN ACCORDANCE WITH THE RECOMMENDATIONS IN THE MIDYEAR REPORT The City Council of the City of Palo Alto does ordain as follows: SECTION 1. The City Council of the City of Palo Alto finds and determines as follows: A. Pursuant to the provisions of Section 12 of Article III of the Charter of the City of Palo Alto, the Council on June 10, 2013 did adopt a budget for fiscal year 2014, including a Table of Organization describing the staffing for each department; and B. After reviewing the current budgeted revenues and expenditures for Fiscal Year 2014, adjustments to the budget are recommended to more accurately reflect year-end projections; and c. Various staffing adjustments require an amendment to the Table of Organization including the title change from Senior Financial Analyst to Senior Management Analyst, title change from Senior Financial Analyst to Manager Revenue Collections, title change from Administrator, Refuse to Management Analyst, title change from Senior Business Analyst to Principal Management Analyst, reclassify 1.0 FTE Administrative Associate II to Engineering Technician III (this change is to correct the Table of Organization only, funding was adjusted in the FY 2014 Adopted Budget); and D. City Council authorization is needed to amend the fiscal year 2014 budget as hereinafter set forth. SECTION 2. The General Fund Budget Stabilization Reserve is hereby increased by the sum of Four Million Six Hundred Seventy Nine Thousand Five Hundred Ninety-Five Dollars ($4,679,595), as described in Exhibit 1. As a result of this change, the Budget Stabilization Reserve will change to Thirty-Four Million Eight Hundred Fifty-Three Thousand Five Hundred Forty-Five Dollars ($34, 853, 545) . Page 1 of4 SECTION 3. The Capital Fund Infrastructure Reserve is hereby increased by the sum of Five Million Fifty-Four Thousand Twenty-Five Dollars ($5,054,025), as described in Exhibit 1. As a result of this change, the Infrastructure Reserve will change to Thirteen Million Thirty-Five Thousand Two Hundred Seventeen Dollars ($9,297,311). SECTION 4. The Supply Rate Stabilization Reserve in the Electric Fund is hereby decreased by the sum of One Million Two Hundred Sixty-Six Thousand Four Hundred Eighty-Three Dollars ($1,266,483) as described in Exhibit 1. SECTION 5. The Distribution Rate Stabilization Reserve in the Electric Fund is hereby increased by the sum of One Million One Hundred Twenty-Eight Thousand Four Hundred Fifty-Nine Dollars ($1,128,459) as described in Exhibit 1. SECTION 6. The Rate Stabilization Reserve in the Fiber Optics Fund is hereby decreased by the sum of Thirty Thousand Three Hundred Ninety-Three Dollars ($30,393) as described in Exhibit 1. SECTION 7. The Supply Rate Stabilization Reserve in the Gas Fund is hereby decreased by the sum of Four Thousand One Hundred Eighty-Three Dollars ($4,183) as described in Exhibit 1. SECTION 8. The Distribution Rate Stabilization Reserve in the Gas Fund is hereby increased by the sum of One Million One Hundred Twenty-Two Thousand Six Hundred Fifty-One Dollars ($1,122,651) as described in Exhibit 1. SECTION 9. The Rate Stabilization Reserve in the Wastewater Collection Fund is hereby decreased by the sum of Five Hundred Four Thousand Two Hundred Thirty Dollars ($504,230) as described in Exhibit 1. SECTION 10. The Rate Stabilization Reserve in the Water Fund is hereby decreased by the sum of One Million Six Hundred Nine Thousand One Hundred Sixty-Three Dollars ($1,609,163) as described in Exhibit 1. SECTION 11. The Rate Stabilization Reserve in the Refuse Fund is hereby increased by the sum of Two Million One Hundred Forty-Five Thousand Three Hundred Ninety Dollars ($2,145,390) as described in Exhibit 1. Page 2 of4 SECTION 12. The Rate Stabilization Reserve in the Storm Drainage Fund is hereby decreased by the sum of Sixty-One Thousand Twenty-Nine Dollars ($61,029) as described in Exhibit 1. SECTION 13. The Rate Stabilization Reserve Wastewater Treatment Fund is hereby increased by the Forty-Seven Thousand Seven Hundred Eighty-Eight ($47,788) as described in Exhibit 1. in the sum of Dollars SECTION 14. Adjustments to other funds are made as shown in Exhibit 1. These changes impact Special Revenue, Internal Service, and Other Funds Reserves as indicated in Exhibit 1. SECTION 15. Adjustments to decrease or increase amounts allocated to various Capital Improvement Projects are made as shown in Exhibit 2 . These changes impact the General Fund Budget Stabilization Reserve and the. Infrastructure Reserve and are reflected in the adjustments as shown in Exhibit 1. SECTION 16. The Council adopts the amendments to the Municipal Fee Schedule attached as Attachment B. SECTION 17. The Table of Organization is hereby amended to reflect the changes shown in Exhibit 3, which is attached hereto and incorporated herein by reference. These changes impact Reserves and are accounted for in the changes shown in Exhibit 1. SECTION 18. As specified in Section 2. 28. 080 of the Palo Alto Municipal Code, a two-thirds vote of the City Council is required to adopt this ordinance. SECTION 18. The Council of the City of finds that this midyear adjustment is not Section 21065 of the California Environmental Palo Alto hereby a project under Quality Act and, therefore, no environmental impact assessment is necessary. Capital improvement projects described in this ordinance will be assessed individually as appropriate. Page 3 of4 INTRODUCED _AND PASSED: May 5, 2014 AYES: NOES: BERMAN, BURT, HOLMAN, KLEIN, KNISS, PRICE, SCHARFF, SCHMID, SHEPHERD ABSTENTIONS: APPROVED: Page 4 of4 ! ; Categories l -~ Revenues & Other Sources Sales Tax Property Tax Transient Occupancy Tax Utility Users Tax Documentary Transfer Tax Motor Vehicle Tax, Penalties & Fines Charges for Services Permits & Licenses Return on Investment Rental Income From Other Agencies Charges To Other Funds Other Revenues Total Revenues Operating Transfers-In Encumbrances and Reappropriation From Infrastructure Reserve Total Sources of Funds Exl!enditures & Other Uses City Attorney City Auditor City Clerk City Council City Manager Administrative Services Community Services Public Safety People Strategy and Operations Library Planning and Community Environment Public Works Non-Departmental Cubberly lease Total Expenditures Operating Transfers-Out Transfer to Infrastructure Total Uses of Funds Net Surplus/(Deflclt) Budget Amendments Authorized by Council: CSD park maintenance (6/12/13} Election costs (9/9/13} Homeless Systems (11/18/13} Total Augmentations Authorized by Council Net Surplus/(Deflclt) Without _BAOs BSR Draw Mgmt. Comp Study (01/27/14} Net Surplus/(Deflclt) After BSR_ Drawdown BSR Balance as of12/31/13 BSR % ofTotal Use of Funds ATTACHMENT A, EXHIBIT 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR FINANCIAL REPORT GENERAL FUND (in thousands} ACJVALS ~ >/ 12/31/13} I Adopted I Adjusted I Midyear I Midyear I \ Pre I I I~" ~f ~~d~r J (ludg~et ~ ~ ~ j3u~dget _ Budget l=_h1!Qges J t~ "~11~~1!1b! ~ J:Q!:\lmllr ~ -~t:tual 23,846 23,846 27,352 3,506 ~ ~ 10,465 29,613 29,613 30,250 637 ~ 10,596 11,545 11,545 12,318 773 ~ 5,062 11,013 11,013 11,386 373 ~ . 5,583 5,699 5,699 7,395 1,696 . . 4,422 2,107 2,107 2,107 . . . 1,172 24,379 24,379 22,445 (1,934} . . 9,919 8,346 8,346 7,942 (404} . . 3,179 769 769 769 . . 466 12,891 12,891 14,010 1,119 . . 6,451 252 330 381 51 . . 47 10,574 10,574 10,604 30 . . 5,289 2,010 2,010 2,156 146 . . 965 143,044 143,122 149,115 5,993 . -63,616 17,529 17,529 17,910 381 . . 8,739 5,571 5,571 -. 160,573 166,222 172,596 6,374 -I -I 72,3551 2,453 2,956 2,967 11 49 464 1,284 1,088 1,099 1,110 11 5 136 436 1,258 1,271 1,283 12 -24 551 497 651 659 8 . 78 242 2,499 2,733 2,737 4 7 250 1,344 7,280 7,475 7,476 37 31 175 3,418 22,700 23,537 23,690 153 59 2,775 11,008 60,962 61,968 62,418 450 243 1,193 29,904 3,265 3,453 3,663 210 38 171 1,408 7,793 8,507 8,622 115 67 346 3,636 13,608 14,679 14,941 262 185 842 5,831 13,751 14,635 14,565 (71} 488 947 6,583 1,228 1,067 561 (506} . . 565 7,268 7,268 7,268 -. 3,858 145,650 151,299 151;995 696 1,1721 7,4011 70,0681 I 843 843 1,843 1,000 ~ 422 13,226 13,226 13,226 ~ . 6,613 159;719 165,368 167,064 1,696 1,1721 7,4011 77,103 I I 854 854 5,533 4,679 %Midyr J ~udgl!t* J 38% 35% 41% 49% 60% 56% 44% 40% 61% 46% 12% 50% 45% 43% 49% . . 43% 61% 52% 45% 49% 58% 48% 58% 50% 44% 47% 46% 55% 101% 53% 52% 23% 50% 51% • Including reappropriations and prior year encumbrances 227 227 585 585 125 125 -937 937 - 854 (83) 4,596 4,679 (98) 854 (83) 4,498 4,679 31,209 30,272 34,951 19.54% 18.95% 21.88% 4/30/2014 Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY ELECTRIC FUND (in thousands of dollars) BUDGET ACTUALS ~ f 12 3113) i I Adopted I Adjusted I Midyear I Midyear j' : Budget Budget Budget CIJ!i!lges , Pre-I I I % of I L Encumbr _Encumbr Actual MidY~!Ir Bu_dg:etJ Sources of Funds Net Sales 123,630 123,630 117,800 (5,830) 59,685 51% Interest Income 3,199 3,199 3,199 1,492 47% Other Income 8,426 8,426 9,815 1,389 5,860 60% Rea ro /Encumbrances 18,214 18,214. Total Sou.rces 135,255 153,469 149,028 4,441 67,037 51% •• Uses of Funds Utility Purchases 74,509 74,509 72,095 .(2,414) 70 35,613 49% Salaries & Benefits 12,122 12,105 12,202 97 5,042 41% Contract Services 4,704 4,621 4,621 501 2,073 1,232 82% Supplies and Materials 890 875 875 53 43 215 36% Facility and Equipment Purchases 38 38 38 0% General Expenses 4,269 4,214 4,214 301 886 1,354 60% Rent and Leases 4,034 4,034 4,075 41 2,001 49% Allocated Charges 8,821 8,821 8,874 53 3,196 36% Debt Service 9,127 9,127 9,127 4,512 49% Subtotal 118,514 118,344 116,121 (2,223) 855 3,072 53,165 49% 11,203 11,203 11,203 5,602 50% 123 123 '123 61 . 50% 8,605 20,631 18,551 138,445 150,301· 145.~98 (2,080) 1 ,864 2,791 6,263 59% ~~~~~~~~~------~~~~~~~--~~~--~(~4~,3~03~l~~2.~7~19rlr~5~,8~6~3~~6~s.~o9~1rl---~~-;so~o/c~. 3,168 3,030 138 Beginning Reserves 125,115 125,115 Proj~c~d·'.I:Widl!'lg R'servt~s 129,856 128,283 128,145 (138) •• Excludes encumbrances and reappropriation 4/30/2014 Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY FIBER OPTICS FUND (in thousands of dollars) •• Excludes encumbrances and reappropriation 4/30/2014 Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY GAS FUND (in thousands of dollars) 15,170 13,397 . 13,397 4,815 4,815 4,821 1,399 904 904 455 456 456 22 22 22 699 697 697 329 329 518 3,699 3,699 3,722 801 801 •• Excludes encumbrances and reappropriation 6 189 23 f 12 3113) i Pre-I I I % of 1 I Encumbr En(;Um~r Actual Midyear Bud_aet 1 1,767 1,361 18 1,811 1 116 47 14,430 335 347 4,124 3,223 2,268 277 4/30/2014 Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY WASTEWATER COLLECTION FUND (in thousands of dollars) BUDGET I I Adopted I Adjusted I Midyear I Midyear i L Budget Budget Budget Changes : 15,270 371 903 8,589 2,018 260 261 5 98 182 2,070 129 •• Excludes encumbrances and reappropriation 8,589 2,018 187 304 5 98 182 95 2,070 13 129 ACTUALS (; f 12-3113) l Pre-I I I % of l i Encmnbr Encu~br Actual Mit!YJ)ar ~udget! 16 92 107 7,274 159 1,252 4,295 1,005 55 129 62 87 722 87% 78% 0% 64% 31% 4/30/2014 Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY WATER FUND (In thousands of dollars) BUDGET : I Adopted I Adjusted I Midyear I Midyear 1 i Budget Budget Budget Changes l 36,891 682 1,806 ** Excludes encumbrances and reappropriation 36,891 6.82 88 ACTUALS f 12 3113) 1 Pre-I I I % of 1 f_Encumbr Encumbr Actual Midy~;~ar~_Budgetj 160 36 7,402 603 161 22,576 448 1,705 7,277 2,570 152 233 4/30/2014 Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY REFUSE FUND (in thousands of dollars) BUD ET ACTUALS (as of 12 3113) • 1 I Adopted I Adjusted I Midyear I Midyear i , Budget Budget Budget Changes 1 1 Pre-I I I % of 1 I Encumbr Encumbr Actual Midyear Budgetj • Sources of Funds Net Sales 26,961 26,961 26,961 13,466 Interest Income 192 192 192 121 Other Income 2,364 2,364 2,488 124 1,553 Rea ro /Encumbrances 1,600 1,60.0 Total Sources 29,517 31,117 31,241 124 Uses of Funds GreenWaste Hauling Contract 13,786 13,786 13,786 7,693 5,311 Salaries and Benefits 2,873 2,873 2,873 1,421 Contract Services 5,788 5,696 5;696 75 1,005 2,640 Supplies and Materials 130 137 137 10 51 Facility and Equipment Purchases 3 3 3 General Expenses 66 95 95 575 Rents and Leases 2,643 2,643 2,670 27 1,310 Allocated Charges 2,496 2,496 2,522 26 1,264 Debt Service 625 625 62!! Subtotal 28,410 28,354 28,4Q7 53 Operating Transfers Out 29 29 29 Capital Improvement Program 158 25 (2,()49) (2,074) Total Uses 28,597 28,408 26,387 (2,021) 920 2,709 4,854 2,145 Beginning Reserves 1,857 (1,807 1,807 Projected.EndinQ.Rt!s&rves (937) 902 3,1)47 2,145 •• Excludes encumbrances and reappropriation 4/30/2014 Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY STORM DRAINAGE FUND 5,803 156 80 1,109 391 95 8 18 6 715 948 •• Excludes encumbrances and reappropriation (in thousands of dollars) 14 33 6 36 84 20 3,020 79 7 530 234 27 188 278 52% 51% 7% 4/30/2014 ' ~- Sources of Funds Net Sales Interest Income Other Income Reapprop/Encumbrances Total Sources Uses of Funds Salaries and Benefits Contract Services Supplies and Materials Facility and Equipment Purchases General Expenses Rents and Leases Allocated Charges Debt Service Subtotal Operating Transfers Out Capital Improvement ProQram Total Uses ......... Net To (From) Reserves · Beginning Reserves ~rojected Endil'lg Reserves Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY WASTEWATER TREATMENT FUND (In thousands of dollars) BUDGET ACTUALS I Adopted I Adjusted Budget Budget I Midyear I Midyear ; Budget Qhal}g~;~s 1 i Pre-I I 1 E_!1CI.nnbr_ Encum~r 22,286 22,286 22,286 - 377 377 377 - 55 55 114 59 26,085 26,085 22,718 48;803 48,862 59 -- 9,836 9,836 9,836 1,899 1,862 1,862 34 1,150 1,624 1,602 1,602 8 294 7 2 2 443 443 '443 --- 4,596 4,596 4,607 11 818 818 818 19,223 19,159 19,170 11 42 1,444 · ... ---- 2,977 6,500 ··6,5Qo -550 1,750 22,200 25,659 25,670 11 592 3,194 518 23,144 2M92 48 10,169 10,500 10;50Q - 10,687 _33,644 33,692 48 ** Excludes encumbrances and reappropriation f 12-3113) Actual I %of j Midyear !3~u_!lge!J 10,937 49% 177 47% 101 89% - 11,215 49% 4,623 47% 662 99% 653 60% 0% 465 105% 0% 2,383 52% 0% 8,786 54% 0% 1,138 53% 9,924 53% 4/30/2014 I Attachment A, Exhibit 1 CITY OF PALO ALTO FISCAL YEAR 2014 MIDYEAR BUDGET SUMMARY AIRPORT FUND (in thousands of do/tatS) BUDGET ACTUALS f 12-3113) I I Adopted I Adjusted Budget Buclget I Midyear I Midyear ; Budget Cllanges ' , Pre-I I ! Enc!)m~br l::!l91.101~r _ A_ctual I %of i Mid~e.l!lr B!Jclg~!J Sources of Funds Net Sales ------ -0% Interest Income 3 3 3 ---2 67% Other Income 325 325 325 -- -163 50% Reapprop/Encumbrances 103 103 - Totai$(Jurces 328 431 431 -- - 165 50%. Uses of Funds Salaries and Benefits 177 177 177 ---96 54% Contract Services 150 150 150 -77 55 88% Supplies and Materials -------0% Facility and Equipment Purchases -------0% General Expenses ---- - --0% Rents and Leases -------0% Allocated Charges 113 113 113 -- -57 50% Debt Service ------ -0% Subtotal 440 440 440 --77 208 65% Operating Transfers Out -------0% Capital Improvement Program -------0% TotaiUs~s 440• 440 440 --77 208 65% Net To (Frorri) Reserves (112) {9) (9 - Beginning Reserves -(520) (520' - fcrpjectel:l.l;nding Reserves (112) (529) (529) - ** Excludes encumbrances and reappropriation 4/30/2014 Source Changes Changes Use Changes Sales Tax Property Tax Documentary Transfer Tax Transient Occupancy Tax Utility Users Tax Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Operating Transfers-In Salary & Benefits Contingent Account· Contingent Account Operating Transfers-Out Salary & Benefits General Expense Contract Services Allocated Charges Allocated Charges Allocated Charges ATIACHMENT A, EXHIBIT 1 3,506,000 637,000 1,696,000 773,000 373,000 224,280 223,813 189,249 154,440 107,797 95,366 40,956 33,102 26,606 22,973 431,887 8,535,469 Increase sales tax estimate Increase property tax estimate Increase documentary transfer tax estimate Increase transient occupancy tax estimate Increase utility users' tax estimate Increase rent from Information Technology Fund for space at City facilities owned by the General Fund. Increase rent from Water Fund for space at City facilities owned by the General Fund. Increase rent from Gas Fund increased for space at City facilities owned by the General Fund. Increase rent from Print/Mail Services Fund for space at City facilities owned by the General Fund. Increase rent from Vehicle Replacement Fund for space at City facilities owned by the General Increase rent from Wastewater Fund for space at City facilities owned by the General Fund. Increase rent from Electric Fund for space at City facilities owned by the General Fund. Increase rent from Storm Drain Fund for space at City facilities owned by the General Fund. Increase rent from Refuse Fund for space at City facilities owned by the General Fund. Increase rent from Fiber Optics Fund for space at City facilities owned by the General Fund. Increase the transfer from the Information Technology Fund to reflect the return of funding from Technology CIP TE-02013 Institutional Network. (602,000) Reallocate additional City Pension Contribution costs to departmental budgets from the Salary Reserve. In 2012, the CaiPERS Board approved lowering the earnings interest assumption rate from 7.75% to 7.5% and offered participating agencies to phase-in the impact to higher annual required contributions over two years. The City of Palo Alto chose to pay the higher cost in the first year. 103,600 Replenish the City Manager's Office Contingency Account for funds temporarily reallocated to the Administrative Services Department to fund a contract to review the City's Purchasing Review process, $61,600, and for the February through June 2014 costs of the new State legislative Advocate Contract, $42,000, as approved by the City Council on Feb. 24, 2014. These actions will restore the contingency account to $204,000 compared to an adopted amount of $250,000. (8,000) Decrease the City Council Contingency Accountto the City Council Budget for future travel expenses. This action will reduce the Contingency Account to $197,000 from an adopted amount of 1,000,000 Increase the transfer to the Technology Fund to move Technology Fee received and expected to be received by the General Fund to the Technology Fund in FY 2014. The Technology Fee is captured ---=,..-,:-:-through an increase to fees which was approved as part of the 2013 Municipal Fee Schedule. 493,600 39,581 Reallocate additional City Pension Contributions from the Salary Reserve. (21,000) Centralize management development funds for citywide training opportunities. Funds are moved to the People Strategy and Operations Department 10,000 Increase contract services to provide funding for a consultant to evaluate the City's current and forecasted property tax revenue, as requested by the City Council. The results of this study will be used during the development of the FY 2015 Proposed Budget. 6,646 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 927 Increase allocated charges for Information Technology {IT) services based on increased rent costs for space at City facilities owned by the General Fund, $5,592. This increase is partially offset by $4,665 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with budgeted costs in the Technology Fund. 717 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space ______ at City facilities owned by the General Fund. 36,871 4/30/2014 General Fund 2014 Use Changes Use Changes Use Changes Salary & Benefits Allocated Charges Allocated Charges Salary & Benefits Contract Services General Expense Allocated Charges Allocated Charges Salary & Benefits Allocated Charges Allocated Charges ATIACHMENT A, EXHIBIT 1 9,377 Reallocate additional City Pension Contributions from the Salary Reserve. 1,030 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 315 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $1,903. This increase is partially offset by $1,588 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment ____ 1 _ 0 ,...., 7 :- 2 :-: 2 :-with budgeted costs in the Technology Fund. 4,688 Reallocate additional City Pension Contributions from the Salary Reserve. 10,000 Increase contract services to provide funding for a consultant with telecommunications expertise to perform an audit of the Cable Franchise Fund, which was approved by the Council as part of the Auditor's Office's FY 2014 Work plan. City Auditor staff requires the additional expertise for auditing telecommunications. Once the work is completed, the City will be reimbursed SO% for the total cost of the audit. (5,000) Centralize management development funds for citywide training opportunities. Funds are moved to the People Strategy and Operations Department 791 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 125 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $754. This increase is partially offset by $629 to adjust for the reduction of a Technologist position approved as part ofthe FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with ______ budgeted costs in the Technology Fund. 10,604 5,991 Reallocate additional City Pension Contributions from the Salary Reserve. 5,299 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 201 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $1,217. This increase is partially offset by $1,016 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment ______ with budgeted costs in the Technology Fund. 11,491 4/30/2014 General Fund 2014 Changes Changes Source Changes Salary & Benefits General Expense Al.located Charges Allocated Charges General Expense Allocated Charges Charges for Services Other Revenues Other Revenues Other Revenues Other Revenues Other Revenues Salary & Benefits Contract Services General Expense General Expense ATIACHMENT A, EXHIBIT 1 9,950 Reallocate additional City Pension Contributions from the Salary Reserve. {7,555) Centralize management development funds for citywide training opportunities. Funds are moved to the People Strategy and Operations Department 2,053 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 333 Increase allocated charges for Information Technology {IT) services based on increased rent costs for space at City facilities owned by the General Fund, $2,014. This increase is partially offset by $1,681 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment ------:-with budgeted costs in the Technology Fund. 4,781 8,000 Increase City Council Budget for travel expenses from $21,000 to $27,000 with funding from the City Council Contingency Account. 36 Increase allocated charges for Printing and Mailing services based on increased rent costs for space ____ 8 ,....,.,.. 03 ,.... 6 :-at City facilities owned by the General Fund. {239,800) Decrease golf course fee revenue estimate due to the golf course reconfiguration project and aligning revenue with year-to-date trends {$240,000 reduction in green fees and a $19,000 reduction in driving range fees). These decreases are offset by a $19,200 increase in golf course cart fee and other golf fee revenues due to more customers opting to rent carts and an increase in golf class participation. 8,500 Grant to the Palo Alto Art Center to support general operations of the Art Center. The grant has no specific spending requirements and the Art Center will use the grant funding in the art exhibitions program to purchase furnishing and provide artistic support services. Artistic services may include honorariums for art lectures, workshops, and contribution of art. 6,000 Increase revenue {and corresponding expense increase) from contract with PAUSD for teaching dance at schools. Part of the Children's Theater outreach program to schools is where the Theater provides artistic dance instruction off-site at PAUSD. 8,150 Increase revenue {and corresponding expense increase) from contract with PAUSD for teaching Theatre at schools. A part of Children's Theatre outreach to the schools where the Theatre provides performing arts I theatre instruction off-site at PAUSD. This amount varies annually. 45,000 Increase revenue as a result of a contribution from Friends of Children's Theatre {and corresponding expense increase). The amount varies annually and is not built into the base budget as an on-going contribution. 11,300 Grant revenue from National Endowment for the Arts {NEA). This grant funds various programs depending on the year and NEAs goals for the year. These programs typically revolve around both education and performing arts, such as outreach to schools with assigned reading materials, guest author lectures and show productions based on popular novels. Generally the group reads a novel and produces a theater act based on their readings. This is a one-time adjustment as funding from ______ NEA is not always a yearly allotment. {160,850) 77,433 Reallocate additional City Pension Contributions from the Salary Reserve. {30,940) Decrease contract service expense to golf professional contracts as part of revenue sharing. 8,500 Grant to the Palo Alto Art Center to support general operations of the Art Center. The grant has no specific spending requirements and the Art Center will use the grant funding in the art exhibitions program to purchase furnishing and provide artistic support services. Artistic services may include honorariums for art lectures, workshops, and contribution of art. 45,000 Increase expenses for music, lighting, choreography, stage set building and materials, etc. offset with contributions from Friends of Children's Theatre. 4/30/2014 General Fund 2014 GENERAL FUND Use Changes Source Changes ATIACHMENT A, EXHIBIT 1 CITY OF PALO ALTO MIDYEAR ADJUSTMENTS TO THE CITY MANAGER'S 2014 ADOPTED BUDGET Category Amount Description General Expense General Expense General Expense General Expense Allocated Charges Allocated Charges Allocated Charges Charges for Services Permits & Licenses From Other Agencies Salary & Benefits Salary & Benefits Supplies & Material General Expense Allocated Charges Allocated Charges 11,300 Increase in expense for education and performing arts programs, such as outreach to schools with assigned reading materials, guest author lectures and show productions based on popular novels offset with National Endowment for the Arts grants. Generally the group reads a novel and produces a theater act based on their readings. This is a one-time adjustment as funding from NEA is not always a yearly allotment. 8,150 Increase expense to match service revenue from contract with PAUSD for teaching Theatre at schools. 6,000 Increase expense for teaching dance at schools offset with corresponding revenue from PAUSD. (3,105) Centralize management development funds for citywide training opportunities. Funds are moved to the People Strategy and Operations Department 7,659 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space at City facilities owned by the General Fund. 19,499 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 2,836 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $17,107. This increase is partially offset by $14,271 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with budgeted costs in the Technology Fund. ---:-15:::2:-:,3:-:-32:- (838,593) Decrease revenue from Stanford for fire services from $7.6 million to $6.8 million due to variance between budgeted and actual amounts. The primary contributor to the variance is additional revenue credited to Stanford of higher than budgeted revenue received by the City. Other actions within this report partially offset this reduction to the reimbursement from Stanford for Fire Services. Funding for Stanford's portion of the Thermal Imaging Infrared Long Range CCTV Cameras CIP (FD-12000) of $129,479 is recognized in General Fund Capital; the Radio Infrastructure Replacement CIP (TE-05000) of $16,483 and Computer Aided Dispatch Replacement CIP (TE-09000) of $37,387 is recognized in the Information Technology Fund; and replacement of Fire Apparatus of $19,155 is recognized in the Vehicle Replacement Fund. Overall the decrease to the reimbursement from Stanford for Fire Services across all funds is $636,089. (17,900) Decreases the revenue from permits issued by the Fire Department as a result of a cost of service study that determined several municipal fees needed to be aligned to a 100% cost recovery level. 50,542 Increases revenue from the California Office of Emergency Services for reimbursement for emergency fire services provided on overtime as part of mutual aid for the RIM Fire that happened ---,------.,..in August 2013. (805,951) 123,713 Reallocate additional City Pension Contributions from the Salary Reserve. 50,542 Increase overtime funding for reimbursement from the California Office of Emergency Services for emergency fire services provided as part of mutual aid for the RIM Fire that happened in August 2013. 68,000 Increase funding for Uniforms and Personal Protective Equipment (PPE) from $87,000 to $155,000 to fund the outfitting of nine new sworn Firefighter employees that will begin work with the City on March 18, 2014. PPE includes the employees' daily uniforms as well as turnouts, helmets, boots, gloves, and various other safety equipment needed to effectively put out both structure and wild- land fires. The Department's FY 2014 budget includes funding for PPE replacement for existing employe'es; however, no funding was assumed for PPE purchases for new employees. Including funding for new PPE purchases in FY 2015 will be determined as part of the budget process based on sworn fire personnel attrition projections. (5,500) Centralize management development funds for citywide training opportunities. Funds are moved to the Peop.le Strategy and Operations Department 12,827 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space at City facilities owned by the General Fund. 3,572 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $21,552. This increase is partially offset by $17,980 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment ·· with budgeted costs in the Technology Fund. 4/30/2014 General Fund 2014 GENERAL FUND Use Changes ATIACHMENT A, EXHIBIT 1 CITY OF PALO ALTO MIDYEAR ADJUSTMENTS TO THE CITY MANAGER'S 2014 ADOPTED BUDGET Category Amount Description Allocated Charges 3,101 Increase allocated charges for Printing and Mailing services based on increased rent costs for space ______ at City facilities owned by the General Fund. 256,255 Net Changes To (From) Reserves (1,062,206) LIBRARY Source Changes Use Changes ... Use Changes Other Revenues Salary & Benefits General Expense Allocated Charges Allocated Charges Allocated Charges Salary & Benefits Contract Services Contract Services General Expense Allocated Charges Allocated Charges 67,500 67,500 43,499 67,500 40 2,774 907 State grant under the library Services and .Technology Act. The funds are for the library Makerspace (MakeX) project, a project which engages local teens in learning to use tools and materials to develop creative projects that shape educational purposes and inspires creative goals. Reallocate additional City Pension Contributions from the Salary Reserve. State grant underthe library Services and Technology Act. The funds are for the library Makerspace (MakeX) project, a project which engages local teens in learning to use tools and materials to develop creative projects that shape educational purposes and inspires creative goals. Increase allocated charges for Vehicle Replacement services based on increased rent costs for space at City facilities owned by the General Fund. Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $5,467. This increase is partially offset by $4,560 to adjust for the reduction of a Technologist position apprqved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment ---~:-==-with budgeted costs in the Technology Fund. 114,720 16,670 Reallocate additional City Pension Contributions from the Salary Reserve. 25,000 New allocation for total compensation study as part of the 2014 contract negotiations with IAFF, POA and FCA. 90,000 Increase expenses for a labor negotiation consultant for 2014 IAFF, FCA and POA MOAs. 76,660 Centralize management development funds for citywide training opportunities. 1,231 Increases the allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 386 Increases the allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $2,330. This increase is partially offset by $1,944 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment ---==-=-=-with budgeted costs in the Technology Fund. 209,947 Net Changes To (From) Reserves (209,947) 4/30/2014 General Fund 2014 Changes Use Changes Charges for Services Permits & licenses Salary & Benefits Contract Services Contract Services Contract Services Contract Services General Expense Supplies & Material Contract Services Allocated Charges Allocated Charges Allocated Charges ATTACHMENT A, EXHIBIT 1 (380,500) Decrease Charges for Services to allow for revenues anticipated to be received at the end of FY 2014 to be deferred to FY 2015 in cases where the associated services are expected to be delivered in FY 2015. (380,500) Decrease Charges for Services to allow for revenues anticipated to be received at the end of FY 2014 to be deferred to FY 2015 in cases where the associated services are expected to be delivered in FY ---:--:--,-::-:-2015. (761,000) 51,417 Reallocate additional City Pension Contributions from the Salary Reserve. 13,000 Increases funding for a neutral third party review of construction guidelines. This effort comes at the request of the Development Center Advisory Group (DCAG) and will distinguish between code requirements and best management practices. This review is in support of the Blueprint initiative and is intended to aid in efforts to streamline and simplify the development process. 50,000 Increases funding for the City of Palo Alto's share of a regional nexus study as part of the state mandated Housing Element. This study will analyze the impact that development of market rate housing has on the demand for below market rate housing. The City currently requires 15.% of a residential development to be set aside for affordable housing. The nexus study will substantiate the validity of the percentage. 93,000 Increases funding to support unanticipated data needs in the Accella permitting system. Support has been provided to the various departments that comprise Development Services for the technical application of the Accela software, including training and report writing. This request will support not only those departments identified, but also outside agencies like the county that requires specific reports to track certain permit activity. 25,000 Increases contract services to fund the creation of a program in Accela for time studies. This study will allow staff to more precisely determine the activities related to the development services fees. This amount covers the cost of report preparation, staff training, and support. (11,000) Centralize management development funds for citywide training opportunities. Funds are moved to the People Strategy and Operations Department 10,000 Increases funding for new code books at the Development Center. Since the codes were changed effective 1/1/2014, full sets of new code books need to be purchased. 0 Net zero shift to redirect funds previously allocated for community engagement related to the 27 University Avenue Project to support the Housing Element ($85,000). The community engagement process related to the 27 University Avenue Project will now be folded under the Comprehensive Plan. The Housing Element update is required to be submitted to the State of California in January, 2015. If not completed on time, the City could face substantial penalties. 28,307 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 1,256 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space at City facilities owned by the General Fund. 1,439 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $8,682. This increase is partially offset by $7,243to adjust for the reduction of a Technologist position ·approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment _________ with budgeted costs in the Technology Fund. 262,419 4/30/2014 General Fund 2014 Changes Changes Changes Use Changes Charges for Services Permits & Licenses Salary & Benefits Allocated Charges Allocated Charges Allocated Charges Charges to Other Funds Operating Transfers-In Salary & Benefits General Expense Supplies & Material Allocated Charges Allocated Charges Allocated Charges ATIACHMENT A, EXHIBIT 1 (475,000) Decreases the revenue from Animal Services from $1.0 million to $525,000 due to vacancies in the veterinary positions that have caused the Spay and Neuter Clinic to remain closed in FY 2014. It is anticipated that the clinic will remain closed for the rest of FY 2014; however, if the veterinary positions are filled, the clinic could open and generate some revenue before the end of FY 2014. (5,300) Decreases the revenue from permits issued by the Police Department as a result of a cost of service study that determined several municipal fees needed to be aligned to a 100% cost recovery level. ----:----(480,300) 160,971 Reallocate additional City Pension Contributions from the Salary Reserve. 18,239 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space at City facilities owned by the General Fund. 9,342 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 4,188 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $25,264. This increase is partially offset by $21,076 to adjust fqr the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment ---==~with budgeted costs in the Technology Fund. 192,740 30,000 Increases the estimate for Street Cut Fees, which are paid by the Utilities Department. These fees are intended to mitigate the adverse impact on the life of city streets that are realized when the streets are cut as part of utility projects. The FY 2014 revenue estimate for street cut fees is $30,000 lower than the expenditure allocation in the Utilities Department, and this action will ensure that the revenues and expenditures for this program are in alignment. (51,022) This technical correction decreases an operating transfers-in from the Capital Fund. This transfer was originally supposed to fund a portion of a Project Manager. However, the FTE distribution for ---.,---:-:-the Project Manager is already allocated to the Capital Fund. (21,022) 58,710 Reallocate additional City Pension Contributions from the Salary Reserve. (23,500) Centralize management development funds for citywide training opportunities. Funds are moved to the People Strategy and Operations Department (124,500) Reduces the funding allocated for supplies and maintenance of the Mitchell Park Library and Community Center. The FY 2014 budget assumed that the facility would be open halfway through the fiscal year. As a result of delays in the project stemming from issues with the contractor, the completion date has been moved out and it is unlikely that the project will be complete before the end of the fiscal year. Consequently, the majority of the funds that were allocated for this purpose in FY 2014 can be returned to the General Fund for other purposes. Upon implementation of this recommendation, approximately $30,000 of the funding allocated for this purpose would remain in the Public Works Department's budget should the need arise in the final months of the fiscal year. 3,059 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 11,109 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space at City facilities owned by the General Fund. 4,855 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $13,947. This increase is partially offset by $9,092 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with budgeted costs in the Technology Fund. ---:----::-:::-(70,267) 4/30/2014 General Fund 2014 Source Changes Use Changes Transfer from Community Center Development Impact Fee Transfer from Stanford University Medical Center Fund Transferfrom University Avenue Parking Permit Fund Charges for Services CIP Transfer to Parks Developers Impact Fee Fund ATTACHMENT A, EXHIBIT 1 16,000 Transfer of funds from the Community Center Development Impact Fee Fund, for Fixtures, Furniture, and Equipment (FF&E) associated with the Mitchell Park Community Center (see Attachment A, Exhibit 2 for more detail). 1,200,000 Transferfrom the Stanford University Medical Center (SUMC) Fund for the Bicycle & Pedestrian Transportation Plan (see Attachment A, Exhibit 2 for more detail). 106,700 Transfer from the University Avenue Parking Permit Fund for improvements at the Cowper/Webster Garage (see Attachment A, Exhibit 2 for more detail). 129,479 Additional revenue to recognize reimbursement from Stanford based on the Fire Safety Services contract between Stanford and Palo Alto (see Attachment A, Exhibit 2 for more detail). 1,452,179 (3,861,742) Changes in CIP Projects (See Attachment A, Exhibit 2 for more detail) 259,896 An environmental analysis of the El Camino Dog Park project determined that the project was not viable. Funding for this project was originally transferred from the Parks Developers Impact Fee Fund, therefore the funds are recommended to be returned to that fund. ---:=-::=-::-::-:-:::-(3,601,846) Net Changes To {From) Reserves 5,054,025 Cap1tal Fund Infrastructure Reserve 4/30/2014 General Fund 2014 Revenue Revenue Source Changes Allocated Charged Allocated Charges ATTACHMENT A, EXHIBIT 1 24,216 Increase revenue from the various Utility Funds to recover the cost of allocated charges for Printing and Mailing Services. 14,071 Increase revenue from the various Utility Funds to recover the cost of allocated charges for Internet Technology (IT) Services. 38,287 24,216 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 14,071 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $84,887. This increase is partially offset by · $70,816 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with budgeted costs in the Technology Fund. -------,::-Use Changes ___ ....:3:::8:.<:,2::8:..:.7_ Net Changes To (From Fund Balancing Entrie Total Utilities Adminis ELECTRIC FUND Source Changes Revenue from Customer Sales Revenue from Surplus Energy Transfer from Technology Fund Revenue from Customer Connections Salary & Benefits Salary & Benefits Salary & Benefits Salary & Benefits Salary & Benefits (5,023,150) Decreases electricity customer sales revenue by $5.0 million due to lower than forecasted commercial sales. The Department originally budgeted approximately $113.6 million in electricity customer sales revenue in FY 2014; however, sales have been lower than forecasted due to a delay in new large commercial customers coming online and slightly lower usage overall by commercial customers. It is recommended to lower the estimated revenue to $108.6 million. (806,350) Decreases surplus energy revenue by approximately $800,000 million due to lower than forecasted hydro-electric power generation as a result of the dry weather. The Department originally budgeted approximately $2.3 million in surplus energy revenue in FY 2014; however, lower hydro-electric generation led to lower sales of surplus electric energy in the market and it is recommended to lower the estimated revenue to $1.5 million. 388,586 Return of funding from Technology CIPs TE-11005 Implementation of Restructured Tiered Rates on Bills ($103,4l1), TE-07000 Enterprise Application Infrastructure Upgrade ($235,675), and TE-02013 Institutional Network ($49,500) 1,000,000 Increases revenue for Electricity customer connections by $1.0 million one-time from $1.0 million to $2.0 million. The Department originally budgeted $1.0 million in FY 2014 based on historical service levels of approximately 200 connections; however, as a result of increased development and customer demand, the number of connections is anticipated to double to approximately 400 connections in FY 2014. !4,440,9141 9,909 5,362 4,387 6,012 5,044 Increase salaries and benefits in order to reclassify 3.00 FTE Electrician positions to Traffic and Fiber Technician positions based on a reclassification study conducted by the People Strategies and Operations Department. Increase salaries and benefits in order to reclassify 2.00 FTE Electrician-Lead positions to Traffic and Fiber Technician-Lead positions based on a reclassification study conducted by the People Strategies and Operations Department. Increase salaries and benefits in order to reclassify 0.50 FTE Electrician-Lead position to 0.50 FTE SCADA Technician position based on a reclassification study conducted by the People Strategies and Operations Department. Increase salaries and benefits in order to reclassify 0.50 FTE Electrician position to 0.50 FTE SCADA Technician posit!on based on a reclassification study conducted by the People Strategies and Operations Department. Increase salaries and benefits in order to reclassify 1.00 FTE Electrician-Lead position to an Electric Metering Technician -Lead position based on a reclassification study conducted by the People Strategies and Operations Department. 4/30/2014 Enterprtse Funds 2012 Use Changes Source Changes ATTACHMENT A, EXHIBIT 1 CITY OF PALO ALTO MIDYEAR ADJUSTMENTS TO THE CITY MANAGER'S 2014 ADOPTED BUDGET Category Amount Description Salary & Benefits Salary & Benefits Salary & Benefits CIP Commodity Purchases Allocated Charges Allocated Charges Allocated Charges Facilities Rent Transfer from Technology Fund Salary & Benefits Allocated Charges Facilities Rent 10,071 Increase salaries and benefits in order to reclassify 2.00 FTE Electrician positions to Electric Metering Technician positions based on a reclassification study conducted by the People Strategies and Operations Department. 36,626 Increase salaries and benefits in order to reclassify 5.90 FTE Electrician positions to Electric Substation Technician positions based on a reclassification study conducted by the People Strategies and Operations Department. 19,435 Increase salaries and benefits in order to reclassify 2.00 FTE Electrician-lead positions to Electric Substation Technician -lead positions based on a reclassification study conducted by the People Strategies and Operations Department. (2,080,000) Changes in CIP Projects (See Attachment A, Exhibit 2 for more detail) (2,413,400) Decreases funding for electricity commodities purchases by $2.4 million due to lower than estimated renewable energy and transmission costs, as well as lower than forecasted customer needs. The Department originally budgete.d $73.5 million in FY 2014 to purchase electricity from various sources; however, two renewable energy providers were replaced with lower cost providers. Also transmission charge costs did not increase as much as originally estimated, so it is recommended to lower the funding need to $71.4 million. 29,868 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 16,438 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space City facilities owned by the General Fund. 6,402 Increase allocated charges for Information Technology (IT) services to refund the Utilities Administration Fund. 40,956 Increases funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. (4,302,890) 204 204 6,606 1,018 22,973 Return offunding from Technology CIPs TE-11005 Implementation of Restructured Tiered Rates on Bills ($9) and TE-07000 Enterprise Application Infrastructure Upgrade ($195). Increase salaries and benefits in order to reclassify 2.00 FTE Electrician positions to Traffic and Fiber Technician positions based on a reclassification study conducted by the People Strategies and Operations Department. Increase allocated charges for Printing and Mailing services ($644) and Information Technology (IT) services ($374) to refund the Utilities Administration Fund. Increases funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. Use Changes 30,597 4/30/2014 Enterprise Funds 2012 Source Changes Use Changes Source Changes Transfer from Technology Fund Salary & Benefits Salary & Benefits Salary & Benefits CIP Allocated Charged Allocated Charged Allocated Charges Facilities Rent Revenue Revenue CIP Facilities Rent Allocated Charged Allocated Charged Allocated Charges Use Changes ATTACHMENT A, EXHIBIT 1 151,330 Return offunding from Technology CIPs TE-11005 Implementation of Restructured Tiered Rates on Bills ($42,756), TE-07000 Enterprise Application Infrastructure Upgrade ($86,074), and TE-02013 Institutional Network ($22,500). -------151,330 875 Increase salaries and benefits in order to reclassify 0.10 FTE Electrician-Lead position to SCADA Technician position based on a reclassification study conducted by the People Strategies and Operations Department. 4,069 Increase salaries and benefits in order to reclassify 0.10 FTE Electrician position to Electric Substation Technician position based on a reclassification study conducted by the People Strategies and Operations Department. 1,202 Increase salaries and benefits in order to reclassify 0.10 FTE Electrician position to SCADA·Technician position based on a reclassification study conducted by the People Strategies and Operations Department. (1,185,000) Changes in CIP Projects (See Attachment A, Exhibit 2 for more detail) 9, 742 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 9,773 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space City facilities owned by the General Fund. 2,952 Increase allocated charges for Information Technology (IT) services to refund the Utilities Administration Fund. 189,249 Increase funding for Facilities Rent for increased rent costs for space at City facilities owned by the -----::=-=~~General Fund. (967,138) 42,242 Return offunding from Technology CIPs TE-11005 Implementation of Restructured Tiered Rates on Bills ($5,849}, TE-07000 Enterprise Application Infrastructure Upgrade ($27,393), and TE-02013 Institutional Network ($9,000). · (588,000) Decreases Commercial Retail sales revenue by $588,000 as a result of the switch to winter-base billing for commercial customers in FY 2014. The Department originally budgeted approximately $6.7 million in Commercial Retail sales revenue in FY 2014 with a full year average-base; however, commercial sewer bills are now based on the previous winter's water consumption, so it is ------recommended to lower the estimated revenue to $6.2 million. (545,758) (150,000) Changes in CIP Projects (See Attachment A, Exhibit 2 for more detail) 95,366 Increase funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. 7,257 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space City facilities owned by the General Fund. 4,175 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 1,674 Increase allocated charges for Information Technology (IT) services to refund the Utilities Administration Fund. (41,528) Net Changes To (From) Reserves (504,230) 4/30/2014 Enterprise Funds 2012 Revenue Source Changes Salary & Benefits Salary & Benefits CIP Utility Purchases Allocated Charged Allocated Charged Allocated Charges Facilities Rent Use Changes Net Changes To (From Fund Balancing Entrie Total Water Fund REFUSE FUND Source Changes Transfer from Storm Drainage Fund Transfer from Technology Fund CIP Allocated Charged Allocated Charged Allocated Charges Facilities Rent ATTACHMENT A, EXHIBIT 1 87,888 Return of funding from Technology CIPs TE-11005 Implementation of Restructured Tiered Rates on Bills ($24,784), TE-07000 Enterprise Application Infrastructure Upgrade ($45,104), and TE-02013 Institutional Network ($18,000). -----87,888 3,502 Increase salaries and benefits in order to reclassify 0.40 FTE Electrician-lead position to SCADA Technician position based on a reclassification study conducted by the People Strategies and Operations Department. 4,809 Increase salaries and benefits in order to reclassify 0.40 FTE Electrician position to SCADA Technician position based on a reclassification study conducted by the People Strategies and Operations Department. 2,300,000 Changes in CIP Projects (See Attachment A, Exhibit 2 for more detail) (856,600) Decreases funding for water purchases by $856,000 due to a one-year discount on San Francisco Public Utilities Commission (SFPUC) bills for all Bay Area Water Supply and Conservation Agency (BAWSCA) agencies to return funds accumulated in an SFPUC balancing account. The Department originally budgeted $16.7 million in FY 2014 to purchase water; however, with this discount it is recommended to lower the funding need to $15.9 million. 11,331 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 7,527 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space City facilities owned by the General Fund. 2,669 Increase allocated charges for Information Technology (IT) services to refund the Utilities Administration Fund. 223,813 Increase funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. 1,697,051 35,615 Transfer of funding from the Storm Fund to account for debris that is collected from the cleaning of catch basins and streets. 88,572 Return of funding from Technology CIPs TE-11005 Implementation of Restructured Tiered Rates on Bills ($10,867), TE-07000 Enterprise Application Infrastructure Upgrade ($64,205), and TE-02013 Institutional Network ($13,500). ------124,187 (2,074,380) Changes in CIP Projects (See Attachment A, Exhibit 2 for more detail) 11,3S9 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 11,393 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space City facilities owned by the General Fund. 3,819 Increase the allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $10,971. This increase is partially offset by $7,152 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with budgeted costs in the Technology Fund. 26,606 Increase funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. 4/30/2014 Enterprise Funds 2012 N I F I T ATIACHMENT A, EXHIBIT 1 CITY OF PALO ALTO MIDYEAR ADJUSTMENTS TO THE CITY MANAGER'S 2014 ADOPTED BUDGET Category Use Changes Use Changes t) Reserves e Fund RAINAGE FUND Source Changes Use Changes Transfer from Technology Fund Transfer to Refuse Fund Allocated Charges Allocated Charges Allocated Charges Facilities Rent Amount Description ----- 2,145,390 2 145,390 Chan e in Fund Balance 2,145,390 13,723 Return of funding from Technology CIPs TE-11005 Implementation of Restructured Tiered Rates on Bills ($2,323), TE-07000 Enterprise Application Infrastructure Upgrade ($6,900), and TE-0213 Institutional Network ($4,500). -----:-::-=-::-13,723 35,615 Establishes a transfer to the Refuse Fund to account for disposal of debris that is collected from cleaning catch basins and streets. 1,427 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 2,227 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space City facilities owned by the General Fund. 2,381 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $6,838. This increase is partially offset by $4,457 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with budgeted costs in the Technology Fund. 33,102 Increase funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. ------~=--74,752 4/30/2014 Enterprise Funds 2012 Source Changes Use Changes Transfer from Technology Fund Allocated Charged Allocated Charged Allocated Charges ATTACHMENT A, EXHIBIT 1 58,660 Return of funding from Technology CIPs TE-07000 Enterprise Application Infrastructure Upgrade ($31,660) and TE-0213 Institutional Network ($27,000). ------58,660 2,157 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 1,168 Increase allocated charges for Vehicle Replacement services based on increased rent costs for space City facilities owned by the General Fund. 7,547 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $21,679. This increase is partially offset by $14,132 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with budgeted costs in the Technology Fund. ------=~=-10,872 4/30/2014 Enterprise Funds 2012 Source Changes Use Changes Use Changes Source Changes Use Changes Transferfrom CIP Fund Transfer to CIP Fund Contract Services Transfer to the Capital Contract Services Revenue Contract Services ATTACHMENT A, EXHIBIT 1 259,896 Close out of the El Camino Dog Park. As reported in the FY 2013 Year-End Capital improvement Program Projects Status matrix, presented to the Finance Committee on November 19, 2013, an environmental analysis of this project determined that the El Camino Dog Park project was not viable. Funds were initially transferred from this fund to the Capital improvement Fund for the project, and this action reflects the return of funds from the Capital improvement Fund. 259,896 16,000 Transfer to the Capital improvement Fund to cover cost overages associated with acquiring computer hardware. 16,000 (106,700) Technical adjustment to reduce the allocation for contract services. They FY 2014 budget included an allocation for fa~ade improvements at the Cowper/Webster Garage. The City Council approved this project in FY 2012, and directed the funding come from the Capital improvements Fund with a 50% reimbursement from this fund over FYs 2013 and 2014. The funding for this repayment was inadvertently allocated to contract services. This adjustment will reduce the allocation for contract services, and a corresponding adjustment in this report will establish a transfer to the Capital Improvements Fund. 106,700 Establishes a Transfer to the Capital improvements Fund in order to reimburse the fund for capital repairs at the Cowper/Webster Garage, as described above. (10,300) Reduces the allocation for contract services. When the budget for FY 2014 was developed, the budget for the lighting maintenance contract was not allocated correctly between this fund and the California Avenue Parking Permit Fund. This action adjusts the budget for contract services in this fund. A corresponding increase to the California Avenue Parking Permit Fund is recommended elsewhere in this report. -----:----:-(10,300) 6,000 Recognize revenue from the Downtown Business and Professional Association to fund street light banners for a Martin Luther King Jr. event that took place in August 2013. The funding was received earlier in FY 2014, and this clean-up action recognizes the revenue along with a corresponding increase to contract services expenses. ------6,000 6,000 Increase contract services funding for a vendor to hang streetlight banners for a Martin Luther King Jr. event that took place in August 2013. This clean-up action, along with a corresponding increase to revenue from the Downtown Business and Professional Association will allow the vendor costs to be charged to the Downtown Business Improvement District Fund. ------::-::-:-::-6,000 Net Changes To (From) Reserves - 4/30/2014 Other Funds 2012 Operating Transfer Use Changes Operating Transfer Source Changes Contract Services Use Changes Revenue Source Changes Allocated Charges Facilities Rent Use Changes ATTACHMENT A, EXHIBIT 1 (1,300,000) Technical correction to eliminate the budgeted transfer to the Stanford University Medicai.Center Fund. In FY 2013 a loan from the Stanford University Medical Center Fund to the Residential Housing Lieu Fee Fund was approved in the amount of $2.6 million for the Maybell project. The FY 2014 budget included the first of two $1.3 million loan repayments. These loan repayments will no longer be required, as the funding was never transferred from the Stanford University Medical Center Fund. (1,300,000) {1,300,000) Technical correction to eliminate the budgeted transfer from the Residential Housing In Lieu Fee Fund. (1,300,000) In FY 2013 a loan from the Stanford University Medical Center Fund to the Residential Housing In-Lieu Fee Fund was approved in the amount of $2.6 million for the Maybell project. The FY 2014 budget included the first of two $1.3 million loan repayments. These loan repayments will no longer be required, as the funding was never transferred to the Residential Housing In Lieu Fee Fund. 10,300 Increases the allocation for contract services. When the budget for FY 2014 was developed, the budget for the lighting maintenance contract was not allocated correctly between this fund and the University Avenue Parking Permit Fund. This action adjusts the budget for contract services in this fund. A corresponding decrease to the University Avenue Parking Permit Fund is recommended elsewhere in ______ this report. 10,300 154,440 154,440 1,129 154,440 155,569 Increase revenue from various departments' allocated charges for print and mail services to fund increased rent costs for space at City facilities occupied by Print and Mail staff and owned by the General Fund. Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund. Increase funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. Net Changes To {From) Reserves 1,129 4/30/2014 Other Funds 2012 Source Changes Use Changes Revenue Revenue from Stanford for Fire Svcs Facilities Rent Contract Services Allocated Charges Allocated Charges Contract Services Use Changes ATTACHMENT A, EXHIBIT 1 107,797 Increase revenue from various departments' allocated charges for vehicle replacement services to fund increased rent costs for space at City facilities occupied by fleet staff and owned by the General Fund. 19,155 Stanford's portion of the Fire Department Vehicle Replacement (VR-13000) 126,952 107,797 Increase funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. 32,100 Provides funding for an upgrade to the equipment management software program used to track all vehicle-related equipment. 268 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 2,172 Increase allocated charges for Information Technology (IT) services based on increased rent costs for space at City facilities owned by the General Fund, $6,238. This increase is partially offset by $4,066 to adjust for the reduction of a Technologist position approved as part of the FY 2014 Adopted Budget; however, the corresponding budgets for departmental charges were not adjusted at that time. These adjustments will ensure that the budget for allocated charges is in alignment with budgeted costs in ______ the Technology Fund. 142,337 ----=5~0:..:,0~0:.:::0_Replenish funds for Bartel Actuarial Contract 50,000 Net Changes To (From) Reserves (50,000) 4/30/2014 Other Funds 2012 Revenue Revenue from Stanford for Fire Source Changes Facilities Rent Allocated Charges Allocated Charges CIP Transfer to Electric Fund Transfer to Fiber Optics Fund Transfer to Gas Fund Transfer to Refuse Fund Transfer to Storm Fund Transfer to Wastewater Collection Fund Transfer to Wastewater Treatment Fund Transfer to Water Fund Transfer to General Fund Use Changes ATTACHMENT A, EXHIBIT 1 224,280 Increase revenue from various departments' allocated charges for Information Technology {IT) services to fund increased rent costs for space at City facilities occupied by IT staff and owned by the General Fund. 53,870 Stanford's portion ofthe Radio Infrastructure Replacement CIP (TE-05000} $16,483 and Computer Aided Dispatch Replacement CIP (TE-09000) $37,387 ---::--:c--=:-278,150 224,280 Increase funding for Facilities Rent for increased rent costs for space at City facilities owned by the General Fund. 302 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. 168 Increase allocated charges for Printing and Mailing services based on increased rent costs for space at City facilities owned by the General Fund. (1,265,991) Changes in CIP Projects (See Attachment A, Exhibit 2 for more detail) 388,586 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 {Institutional Network) 204 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 (Institutional Network) 151,330 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 (Institutional Network) 88,572 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 (Institutional Network) 13,723 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 (Institutional Network) 42,242 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 (Institutional Network) 58,660 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 (Institutional Network) 87,888 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 (Institutional Network) 431,887 Close TE-11005 (implementation of Restructured Tiered Rates on Bills), TE-07000 (Enterprise Application Infrastructure Upgrade), and TE-02013 {Institutional Network) -----221,851 Net Changes To (From) Reserves 56,299 4/30/2014 Other Funds 2012 Roofing Replacement PF-00006 Park and Open PG-09002 Golf Course Tree Maintenance PG-12002 Attachment A, Exhibit 2 FY 2014 CIP Mid-Year Adjustments $ Infrastructure Reserve $ Infrastructure Reserve $ Infrastructure Reserve $ (15,000) Infrastructure Reserve $ (79, 182) Infrastructure Reserve annually recurring project high level of carryover funds from prior No impacts are anticipated as a result of i 4/30/2014 Sign Reflectivity Upgrades Thermoplastic Lane Marking and Striping Adjustments Curb and Gutter Repairs 0 0 Baylands Interpretive Center Improvements and Boardwalk Repair Park Restroom Installation Police Building Project Cubberley Restroom Repairs P0-11000 P0-11001 P0-12001 PE-14018 PE-06007 PE-98020 PF-06004 Subtotal . Strategic Adjustments -----PROJECT CANCELLATIONS El Camino Dog Park PE-13007 Relocate Power Poles PG-12005 . . .. . . " 0 PF-07003 Attachment A, Exhibit 2 FY 2014 CIP Mid-Year Adjustments $ $ $ $ " $ $ " $ $ $ $ $ $ $ $ $ " $ $ (46,000) Infrastructure Reserve (150,000) Infrastructure Reserve (100,000) Infrastructure Reserve (1 ,095, 182) 20,000 Infrastructure Reserve (450,000) Infrastructure Reserve (61 ,452) Infrastructure Reserve (297,678) Infrastructure Reserve (789,130) (259,896) Transfer to Parks Development Impact Fee Fund (100,000) Infrastructure Reserve (359,896) (231,580) Infrastructure Reserve Reduces funding in this annually recurring project due to high level of carryover funds from prior years. No impacts are anticipated as a result of !hi action. Reduces funding in this annually recurring project due to high level of carryover funds from prior years. No impacts are anticipated as a result of thi action. Reduces funding in this annually recurring project due to high level of carryover funds from prior years. While fewer repairs may ultimately be completed, this portion of the current year funding was not yet dedicated to specific repairs and there is an ongoing funding source for these types of repairs. Increases funding in this project to begin preparation of a structural evaluation and feasibility study assessing boardwalk repair and/or replacement to inform whether future design and construction funding is needed. Removes remaining funding due to the completion of the Briones Park restroom. Additional funding was intended for future installations of restrooms in parks, however funding is recommended to be removed at this time as a prioritized list of parks that should have restrooms has yet to be developed as part of the Parks Master Plan process. The plan will prioritize the restroom needs along with other park infrastructure needs. · Removes remaining funding for this project, as the original scope of the project is complete or no longer applicable. New funding for planning and design of a public safety building will be requested as part of the current infrastructure funding process. Removes remaining funding as infrastructure improvements will be addressed as part of a broader assessment of Cubberley Community Center needs subsequent to the resolution of the Cubberley lease agreement. As reported in the FY 2013 Year-End Capital Improvement Program Projects Status matrix, presented to the Finance Committee on November 19, 2013, an environmental analysis of this project determined that the project was not viable. As a result, the project will be closed and the funds will be returned to the Parks Development Impact Fee Fund. Removes remaining funding for this non-recurring project. This project has been open since 2012 and has not had any expenses. Uncertainty remains on the future of the site for which this funding was added, and it is not currently known if the pole will need to be moved. Removes remaining funding in this project. No impacts are anticipated as funding for this project was included in the Lucie Stem Buildings Mechanical/Electrical Upgrades Project (PE-14015) as part of the FY 2014 Adopted Budget. 4/30/2014 ' Theatre Improvements LATP Site Development Subtotal -Project Consolidations REVENUE AND ALTERNATIVE FUNDING SOURCES Imaging Infrared Long Range CCTV Bicycle & PF-09000 3001 2002 PF-10002 LB-11000 Attachment A, Exhibit 2 FY 2014 CIP Mid-Year Adjustments $ $ Infrastructure Reserve $ 106,700 $ $ 16,000 $ 16,000 Infrastructure Reserve Removes remaining funding in this project. No impacts are anticipated as funding for this project included in the Lucie Stem Buildings Mechatnicai/E:Iectrical Upgrades Project (PE-14015) from the Community Center Fee Fund to cover cost overages ass.oci,ate•dl acquiring computer hardware. 4/30/2014 Attachment A, Exhibit 2 FY 2014 CIP Mid-Year Adjustments ~r -------w-P-rOiee-t !! ---a_--~---~---J! · -~--Mrr<ffn!r>L:-:'.:--,;;1f'"</;~, :-·~·----;··--·~ -· __ -;=--, '". -_·:"111 L. ___ ___ Jitlg _ _ _ _ Jl NQmbgr_L __ Reveny~ __ F __ <E~nense ~'-Jl_· --:.s~'lfrce; -=--~~-::Jrt:_::~~~~__'_~citi'ntmeri~ ___ :~--~-_'J;rj ELECTRIC FUND ADDITI~NAL APPROPRIATI~NS ~~~~~ Electric Customer Connections EL-89028 $ - $ E. Charleston 4/12 kV Conversion EL-08000 $ -$ El Camino Underground Rebuild EL-05000 $ -$ Communications System Improvements EL-89031 $ -$ SCADA System Upgrades EL-02010 $ -$ Total $ - $ -------REDUCTION IN APPROPRIATIONS/TO CLOSE PROJECTS 1,600,000 Electric Fund Distribution RSR 100,000 Electric Fund Distribution RSR 75,000 Electric Fund Distribution RSR 60,000 Electric Fund Distribution RSR 30,000 Electric Fund Distribution RSR 1,866,000 Increases the annual recurring project that funds new electric customer connections and upgrades to existing electrical services. The project has $2.3 million in FY 2014, but an additional $1.6 million is recommended due to higher customer demand for connection to electric services than originally anticipated. The Department assumed historical connection service levels in FY 2014; however, as result of increased development and customer demand, a higher number of connections are anticipated to be needed~ Increases the one-time projectto rebuild of the utility electric distribution system in the vicinity of Middlefield Road and East Charleston Road, The project has $314,000 in FY 2014, but field inspections determined that an additional $100,000 is needed to replace more equipment than original! anticipated in the project scope_ Increases the one-time project to rebuild the utility electric distribution system on El Camino Real from West Charleston to San Antonio Avenue. The project has $396,000 in FY 2014, but an additional $75,000 is recommended for additional substructure work needed to complete the project as designed. Increases the annual recurring project that funds the installation of communication lines (copper wire, coaxial cable, fiber optic cable, and related equipment) that support a variety of City Services. The project has $30,000 in FY 2014, but an additional 60,000 is recommended due to unanticipated work to replace the pilot wire communications between the Adobe Creek and Maybell substations. The pilot wire is necessary to ensure reliability of the electric transmission system as it provides the means to isolate outages on the transmission s stem. Increases the annual recurring project that funds hardware and software upgrades to the Supervise Control and Data Acquisition (SCADA) system that monitors the city's electric, water, and gas utility systems. The project has $149,000 in FY 2014, bu an additional $30,000 is recommended to cover internal staff time for contractor oversight, system troubleshooting, training, and miscellaneous materials. 4/30/2014 EL-10009 System Improvements 12kVTies Subdivision Rebuild Los Trances Road Total Attachment A, Exhibit 2 FY 2014 CIP Mid-Year Adjustments $ - $ (1 Fund Distribution RSR $ - $ $ - $ Decreases the funding for the StreeUight System Conversion Project, because there is adequate to complete Phase Ill of the project. This project was originally intended to convert the remaining 3,500 streeUights to LED fixtures streeUights; however, due to the different types of i streeUights, Phase Ill will only replace the "cobra head" fixtures. The scope of I is still to be determined as staff needs to viable retrofit options and work with the Department, the Architectural Review residents on acceptable designs. Staff I an1ticit1ate•s bringing that project forward as part of CIP development. Approximately will remain to finish Phase Ill. $ - $ 30,000 Gas Fund Distribution RSR Increases the Gas Main in order to fund close-out costs related to the gas meter replacement project. This project will be once these funds are 4/30/2014 Meters and Regulators Boring Machine GS-02013 Extensions -Unreimbursed Boring Equipment GS-03007 Attachment A, Exhibit 2 FY 2014 CIP Mid-Year Adjustments and closes out the This project was established to provide for a cooperatively owned back-up I ae,neo·atcor: however, the Environmental Protection granted an exemption on the I en1is!;ioros requirements for gas engines due to.low of operating hours, so this project is no Gas Fund Distribution RSR Decreases funding for the annual Gas $ $ $ Meters and Regulators Project. The Department estimated installing and replacing 1,200 gas and regulators in FY 2014; however, due to vacancies in the Gas Meter Shop, and increased for Gas Main Replacement CIPs, gas meter regulator installation and replacement will only place in emergency situations in FY 2014. recurring project that funds unplanned sewer system improvement i to ensure reliable system om11mman. but are not significant enough to qualify CIPs. Due to increased customer l,..nnn••"titm work and ongoing budgeted CIPs, the Department's staff does not have capacity to focus on these unplanned projects in FY 2014. 4/30/2014 Attachment A, Exhibit 2 FY 2014 CIP Mid-Year Adjustments Main Replacement Project 25 1000 $ - $ 2,000,000 Water Fund RSR $ - $ 500,000 Water Fund RSR Landfill Closure $ Increases the Water Main Replacement Project 25 has $3.4 million in FY 2014. A revised lenaineer·ina estimate based on current construction an additional $2.0 million to as designed. This project will funding for water meter , and replacement by $200,000 due to the having enough carryforward funding from to complete the estimated work in FY 2014. n""'"tmAnt estimated installation and renlar,em.entof 1,200 water meters in FY 2014, and this work. i lcoimpletiic tnofthe project, which resulted in State for the remediation of the contaminated Reduces the funding available for this project. The reduction in funding is attributable to anticipated cost savings for capping the landfill with soil. The City is not purchasing the soils, but rather receiving that are being generated by private Some of these soils, when subjected control tests, may fail specifications in a cost to excavate and remove these This reduction leaves approximately $1 million available for capping the landfill, however additional expenses may ultimately be required depending upon the level of soil excavation and mediation. Removes remaining of the project. due to the a fiber-optic network designed to connect all major City facilities, such as City Hall, Libraries, Community Centers, Fire Stations and Schools. project is recommended to be closed, with the retumed to the original funding sources, as objectives of the CIP have been met. 4/30/2014 Collections Software TE-10000 Implementation of Restructured Tiered Rates on TE-11 005 Bills Enterprise Application Infrastructure Upgrade TE-07000 Attachment A, Exhibit 2 FY 2014 CIP Mid-Year Adjustments $ $ $ (2,900) Technology Fund This project was created to purchase and implement an automated collection system for managing and collecting accounts receivable invoices. The objectives of the project have been met, and therefore the project is recommended to be closed. Remaining funds will be returned to the Information Technology Fund Balance. (190,000) Various Enterprise Funds The CIP was primarily designed to support time differentiated rate structures (on the invoice) in anticipation of interval meter data provided by Smart Grid technology. With the overall Smart Grid project still in the pilot phase, no clear direction has been determined and, therefore, long-term requirements cannot be addressed at this point. As a result, the project is recommended to be closed, with remaining funds being returned to the original funding sources. (497,204) Various Enterprise Funds This project was created to put into place the hardware, software, and training for web applications such as Customer Relationship Management, Employee Self Service, and Manage Self Service. The objectives of the project have been met, therefore the project is recommended to be closed, with remaining funds being returned to the original funding sources. TOTAL TECHNOLOGY FUND CIP MID-YEAR $ (1,265,991) ADJUSTMENTS 4/30/2014 Attachment B p to $1170 each incident or 100 Up to $1170 each incident or 100 percent cost recovery. percent cost recovery. l'-'115111" Company Second Re-inspection (After inspection $210.00/hour $210.00/hour re-inspection only) 1.~.u_.,.,,m•.•vu or Closure without approved plans and/or IP"·'uu•~ (Fire Protection/HazMat; double original fee) automatic fire extinguishing systems (hood and Inergen, C02) NOTE: If system has a release fire service line (includes inspection and re- IIm>pe•cticm - 1 each occurrence) Certificate of Occupancy City of Palo Alto $265.00-$785.00 average fee range $195.00-$1,622.00/hr minimum. charges apply after 2 false charges apply after 2 false in a 12 month period. I hour alarms in a 12 month period. I hour 1m1.mm1um charge minimum charge $244.00 $3.25/page blueprints $.30/page for calculations and $325.00 plus $7.00 per nozzle .00 plus $7.00 a device or point $325.00 each occurrence .00 plus $7.00 per nozzle 1 FY 2014 Municipal Fee Schedule 13-1 Attachment B $215.00/each occurrence $80.00/each occurrence City of Palo Alto 2 FY 2014 Municipal Fee Schedule 13-5 Attachment B City of Palo Alto 3 FY 2014 Municipal Fee Schedule 13-6 Attachment B City of Palo Alto 4 FY 2014 Municipal Fee Schedule 13-7 Attachment B POLICE DEPARTMENT FY 2013 FEE FY 2014 FEE Attendant Lot Parking Fee Structure 0-1 hours Free Free 1-3 hours $2.00 $2.00 3-4 hours $4.00 $4.00 Over 4 hours $9.00 $9.00 Daily Maximum $9.00 $9.00 The City Council may authorize the City Manager to establish parking validation programs that include accepting reduced fees. Emergency Response Fee $54.00-$12,000/incident $54.00-$12,000/incident Fingerprints Department of Justice (DOJ) Fingerprint and $56.00/individual $56.00/individual Rolling Fee FBI Fingerprint Fee $26.00/individual $26.00/individual Licenses Fees for licenses delinquent for 30 days or more are subject to a charge of 50% of the original fee, which charge shall be added to the fee collected. The minimum delinquent charge shall be $5.00. Palo Alto Municipal Code 4.04.080(b) Adult Entertainment Establishment Business location change $876.00/occurrence $876.00/occurrence New (non-refundable application fee) $1,936.00/year $1,936.00/year Renewal $876.00/year $876.00/year Billiard Room (non-refundable application $876.00/year $876.00/year fee) Bingo Establishment $54.00/year $54.00/year Bingo employee (Does not include DOJ $76.00/new $76.00/new Fingerprint and Rolling Processing Fee) $57 .00/renewal $57 .00/renewal Bowling Alley (non-refundable application $130.00/year $130.00/year fee) Carnival $2,433.00 plus bond, plus costs to provide $2,433.00 plus bond, plus costs to provide certain services certain services Circus $2,433.00 plus bond, plus costs to provide $2,433.00 plus bond, plus costs to provide certain services certain services Closing-out sale $66.00/up to 60 days $66.00/up to 60 days Renewal (maximum of2) $66.00/up to 30 days $66.00/up to 30 days Mechanical Amusement Device $80.00/year $80.00/year Establishment Noise Exception Permit $270.00/each l~lm7tU<Jl'~fifiL~~.qJ~~\~~~~~~Wl.{~;{t~[j~~-~~fi Firearms Dealer (all fees are non-refundable) Master Permit-New $2,271.00/year $2,271.00/year Master Permit-Renewal $865.00/year $865.00/year Background Investigation Fee: Each Owner, Officer, Agent, and Employee New (Does not include DOJ or FBI $147.00 $147.00 Fingerprint and Rolling Fee) Renewal $57.00 $57.00 Helicopter Landing Fee $260. DO/occurrence $~~1!QZ~J:§~lf~:l!fi'fjlii~Itwiti!~l City of Palo Alto 5 FY 2014 Municipal Fee Schedule 18-1 license (Does not include DOJ · and Rolling Fee.) City of Palo Alto Attachment B POLICE DEPARTMENT FY 2013 FEE FY 2014 FEE $750.00/year $277.00 daily or quarterly $277.00 daily or quarterly 6 FY 2014 Municipal Fee Schedule 18-2 Rodeo •"""""'""'rl~ go directly to a "non-profit" 1vi,0cuuL<Jmvu,· or events declared as co- the of Palo Alto. City of Palo Alto Attachment B POLICE DEPARTMENT FY 2013 FEE FY 2014 FEE $43.00/each $108.00-$1,363.00 plus costs to provide $108.00-$1,363.00 plus costs to provide certain services certain services 8 c A 8 $55.00/hour $74.00/hour $58.00/hour $55.00/hour 31.00/hour $1 06.00/hour $98.00/hour 5.00/hour $44.00/hour .00/hour 156.00/hour $124.00/hour 7 FY 2014 Municipal Fee Schedule 18-3 Attachment B POLICE DEPARTMENT FY 2013 FEE FY 2014 FEE print, $1.00 each additional City of Palo Alto 8 FY 2014 Municipal Fee Schedule 18-4 GENERAL FUND Administrative Services Accountant Acct Spec Acct Spec-Lead Administrative Assistant Administrative Associate Ill Assistant Director Administrative Services Budget Officer Business Analyst Buyer Chief Budget Officer Contracts Administrator Deputy Director Administrative Services Director Administrative Services/Chief Financial Officer Director Office of Management and Budget Graphic Designer Manager Accounting Manager Purchasing & Contract Administration Manager Real Property Manager Revenue Collections (2) Payroll Analyst Principal Management Analyst Senior Accountant Senior Business Analyst Senior Financial Analyst (1), (2) Senior Management Analyst {1) Storekeeper Storekeeper-L Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 d d d d FY 2014 A opte A opted Mi year Actuals Actuals Actuals Adjusted 2.00 8.00 5.00 0.93 0.96 0.60 0.00 0.10 1.95 1.00 2.00 0.80 0.50 0.00 1.00 1.00 1.00 1.00 0.00 2.00 0.00 3.00 0.20 6.91 0.00 0.00 1.00 2.00 7.00 5.00 0.93 0.00 0.60 0.00 0.00 1.95 1.00 1.40 0.80 0.50 0.00 1.00 1.00 1.00 1.00 0.00 2.00 0.00 3.00 0.00 5.81 0.00 0.00 1.00 2.00 7.00 5.00 0.93 1.00 1.50 1.00 0.00 1.95 1.00 1.40 0.00 0.50 0.00 0.00 1.00 1.00 1.00 0.00 2.00 0.00 3.00 0.00 4.91 0.00 0.00 1.00 Budget Budget Change 2.00 7.00 5.00 1.00 1.00 1.70 0.00 0.00 1.95 0.00 1.40 0.00 0.50 1.00 0.00 1.00 1.00 1.00 0.00 2.00 1.00 3.00 0.00 6.10 0.00 0.00 1.00 2.00 5.95 4.59 1.00 1.00 1.65 0.00 0.00 2.00 0.00 1.70 0.00 0.70 1.00 0.00 1.00 1.00 1.00 0.00 2.00 1.00 3.00 0.00 5.90 0.00 0.00 1.00 0.90 (5.90) 5.00 2.00 5.95 4.59 1.00 1.00 1.65 0.00 0.00 2.00 0.00 1.70 0.00 0.70 1.00 0.00 1.00 1.00 1.00 0.90 2.00 1.00 3.00 0.00 0.00 5.00 0.00 1.00 (1) Title change 8.60 FTE Senior Financial Analyst to Senior Management Analyst for various funds and departments {2) Title change 0.90 FTE Senior Financial Analyst to Manager Revenue Collections Library Administrative Assistant Assistant Director Library Services Business Analyst Coordinator Library Programs Director Libraries Division Head Library Services Librarian Library Associate Library Asst Manager Library Services Library Specialist Management Assistant Sr Librarian 1.00 1.00 1.00 1.00 1.00 1.00 5.00 4.00 5.50 4.00 8.00 1.00 8.75 1.00 1.00 1.00 1.00 1.00 1.00 5.00 4.00 5.50 4.00 8.00 1.00 7.75 1.00 1.00 1.00 1.00 1.00 1.00 5.00 4.00 5.50 4.00 8.00 1.00 7.75 1.00 1.00 1.00 1.00 1.00 1.00 5.00 5.00 5.50 4.00 7.00 1.00 7.75 1.00 1.00 1.00 1.00 1.00 1.00 5.00 5.00 5.50 4.00 7.00 1.00 8.25 1.00 1.00 1.00 1.00 1.00 1.00 5.00 5.00 5.50 4.00 7.00 1.00 8.25 Total Library 42.25 41.25 41.25 41.25 41.75 0.00 41.75 Public Safety 40-Hr Training Captain Administrative Assistant Administrative Associate II 1.00 2.00 7.00 1.00 1.00 7.00 1.00 1.00 7.00 1.00 1.00 7.00 1.00 2.00 6.00 1.00 2.00 6.00 Animal Control Off Animal Services Spec Animal Services Spec II Assistant Director Technical Services Assistant Chief of Police Battalion Chief 56-Hour Workweek Business Analyst Code Enforcement Off Comm Tech Community Serv Offer Deputy Director Technical Services Court liaison Officer Crime Analyst Deputy Chief/Fire Marshall Deputy Fire Chief Emergency Medical Svc Chief Director Office of Emergency Services EMS Data Specialist EMS Manager Fire Apparatus Op Fire Captain Fire Chief Fire Fighter Fire Fighter Emt Fire Inspector GIS Specialist Haz Mat Inspector Haz Mat Spec Office of Emergency Services Coordinator Police Agent Police Captain Police Chief Police lieut Police Officer Police Records Specialist-Lead Police Records Specialist II ·Police Sergeant Program Assistant Program Assistant I Program Assistant II Program Coordinator Property Evid Tech Public Safety Disp Public Safety Dispatcher-Lead Public Safety Dispatcher II Senior Management Analyst Superintendent Animal Services Supervisor Animal Services Supervisor Police Services Veterinarian Veterinarian Tech Volunteer Coord Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 FY 2014 Adopted Adopted Midyear Actuals Actuals Actuals Adjusted Budget Budget Change 4.50 1.00 1.00 0.00 1.00 3.00 1.00 1.50 1.00 9.00 1.00 1.00 2.00 0.84 2.00 0.00 0.00 0.00 1.00 30.00 27.00 1.00 45.00 0.00 3.00 0.00 1.90 0.95 1.00 19.00 2.00 1.00 5.00 50.00 1.00 7.00 14.00 0.00 0.00 1.00 1.00 2.00 2.00 5.00 14.00 1.00 1.00 1.00 3.00 1.00 2.00 0.50 4.50 1.00 1.00 0.00 1.00 3.00 1.00 1.00 1.00 8.50 1.00 1.00 1.00 0.84 2.00 0.00 0.00 0.00 1.00 30.00 27.00 1.00 45.00 0.00 3.00 0.00 1.90 0.00 1.00 19.00 2.00 1.00 5.00 49.00 1.00 6.00 14.00 0.00 0.00 1.00 0.00 2.00 2.00 5.00 14.00 1.00 1.00 1.00 3.00 1.00 2.00 0.50 4.50 0.00 2.00 0.00 1.00 3.00 1.00 1.00 1.00 8.50 1.00 1.00 1.00 0.84 2.00 0.00 1.00 0.00 1.00 30.00 27.00 1.00 45.00 0.00 3.00 0.00 1.90 0.00 1.00 19.00 2.00 1.00 5.00 49.00 1.00 6.00 14.00 0.00 0.00 1.00 0.00 2.00 2.00 5.00 14.00 1.00 1.00 1.00 3.00 1.00 2.00 0.50 4.50 0.00 2.00 0.00 1.00 3.00 1.00 1.00 1.00 8.50 1.00 1.00 1.00 0.84 2.00 0.00 0.00 1.00 1.00 30.00 21.99 1.00 40.99 0.00 4.00 1.00 1.90 0.00 0.00 19.00 2.00 1.00 5.00 49.00 1.00 6.00 14.00 0.00 0.00 1.00 0.00 2.00 2.00 5.00 14.00 1.00 1.00 1.00 3.00 1.00 2.00 0.50 4.00 0.00 2.00 0.00 1.00 3.00 2.00 1.00 1.00 8.50 1.00 1.00 1.00 0.84 2.00 0.00 1.00 1.00 1.00 30.00 22.00 1.00 41.00 0.00 4.00 1.00 1.90 0.00 1.00 19.00 2.00 1.00 5.00 50.00 1.00 6.00 14.00 1.00 0.00 1.00 0.00 2.00 2.00 4.00 14.00 2.00 1.00 0.00 3.00 1.00 2.00 0.00 4.00 0.00 2.00 0.00 1.00 3.00 2.00 1.00 1.00 8.50 1.00 1.00 1.00 0.84 2.00 0.00 1.00 1.00 1.00 30.00 22.00 1.00 41.00 0.00 4.00 1.00 1.90 0.00 1.00 19.00 2.00 1.00 5.00 50.00 1.00 6.00 14.00 1.00 0.00 1.00 0.00 2.00 2.00 4.00 14.00 2.00 1.00 0.00 3.00 1.00 2.00 0.00 Total Public Safety 284 19 277.24 278.24 270.22 273.24 0 00 273.24 Public Works Accountant Acct Spec Administrative Assistant Administrative Associate I Administrative Associate II Administrative Associate Ill Assoc Engineer Assistant Director Public Works Bldg Serviceperson Bldg Serviceperson-L Chief Sustainability Officer Director Public Works/City Engineer Electrician Engineer EngrTech Ill Equip Operator Facilities Carpenter Facilities Maint-L Facilities Mech Facilities Painter Heavy Equip Oper Heavy Equip Oper-L Inspector, Field Svc Management Analyst Managing Arborist Manager Facilities Maintenance and Projects Manager Maintenance Operations Planning Arborist Project Engineer Project Manager Senior Management Analyst (1) Senior Accountant Senior Engineer Senior Financial Analyst (1) Senior Project Manager Supervising Project Engineer Superintendent Public Works Operations Supervisor Facilities Management Supervisor Inspection and Surveying Surveying Assistant Surveyor, Public Works Traf Cont Maint I Traf Cont Maint II Traf Cont Maint-L Tree Maint Person Tree Trim/Ln Clr Tree Trim/Ln Clr-L Urban Forester Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 d d d d FY 2014 A opted A opte Mi year Actuals Actuals Actuals d Adjusted 0.02 0.04 1.00 1.70 1.80 0.00 0.10 1.10 4.00 2.00 0.00 1.00 1.00 0.30 3.30 3.46 1.00 2.00 6.00 2.00 1.90 0.85 1.00 0.00 1.00 0.80 0.12 0.00 0.20 1.75 0.90 0.02 0.30 0.16 1.00 1.00 0.60 1.95 0.80 0.78 0.78 1.94 3.00 1.00 2.00 7.00 1.00 0.00 0.02 0.04 1.00 1.70 1.80 0.00 0.10 1.10 1.00 2.00 0.00 1.00 1.00 0.30 3.30 3.46 1.00 2.00 6.00 2.00 1.90 0.85 1.00 0.00 1.00 0.80 0.12 0.00 0.20 1.75 0.90 0.02 0.20 0.16 1.00 0.00 0.60 1.95 0.80 0.78 0.78 1.94 2.00 1.00 2.00 7.00 1.00 0.00 0.02 0.04 1.00 0.70 1.80 0.00 0.10 1.10 1.00 2.00 0.00 1.00 1.00 0.30 3.30 3.46 1.00 2.00 6.00 2.00 1.90 0.85 1.00 0.55 0.00 0.00 1.72 1.00 0.20 0.75 0.90 0.02 0.20 0.16 1.00 0.00 0.00 0.00 0.80 0.78 0.78 1.94 2.00 1.00 2.00 7.00 1.00 1.00 Budget Bu get Change 0.00 0.00 1.00 0.50 2.85 0.00 0.10 1.30 1.00 2.00 0.00 1.00 1.00 0.30 3.30 3.46 1.00 2.00 6.00 2.00 1.90 0.85 1.00 0.60 0.00 0.00 2.10 1.00 0.20 1.25 0.95 0.00 1.10 0.16 0.10 0.00 0.00 0.00 0.80 0.78 0.78 1.94 2.00 1.00 1.00 7.00 1.00 1.00 0.00 0.00 1.00 0.60 2.65 0.00 0.30 1.30 1.00 1.80 0.00 1.00 0.80 0.30 3.20. 3.46 1.00 1.85 5.55 1.75 2.13 0.85 1.33 0.60 0.00 0.00 1.95 1.00 0.30 1.70 0.95 0.00 1.20 0.16 0.10 0.00 0.00 0.00 0.80 0.00 0.78 1.94 2.00 1.00 1.00 7.00 1.00 1.00 0.16 {0.16) 0.00 0.00 1.00 0.60 2.65 0.00 0.30 1.30 1.00 1.80 0.00 1.00 0.80 0.30 3.20 3.46 1.00 1.85 5.55 1.75 2.13 0.85 1.33 0.60 0.00 0.00 1.95 1.00 0.30 1.70 1.11 0.00 1.20 0.00 0.10 0.00 0.00 0.00 0.80 0.00 0.78 1.94 2.00 1.00 1.00 7.00 1.00 1.00 Total Public Works 63.67 58.57 56.37 57.32 56.35 0.00 56.35 {1) Title change 8.60 FTE Senior Financial Analyst to Senior Management Analyst for various funds and departments ENTERPRISE FUNDS Public Works -Enterprise Funds Accountant 0.23 0.23 0.23 0.40 0.40 0.40 Acct Spec Administrative Associate I Administrative Associate II · Administrative Associate Ill Administrator, Refuse (3) Manager Airport Assistant Director, Environmental Services Assoc Engineer Assoc Planner Assistant Director Public Works Assistant Manager Water Quality Control Plant Assistant to the City Manager Business Analyst Buyer Chemist Chief Sustainability Officer Coord Pub Wks Proj Coord Zero Waste Deputy Chief/Fire Marshall Electrician Electrician-Lead Eng Tech I Engineer EngrTech Ill Environmental Spec Equip Operator Executive Assistant Haz Mat Inspector Haz Mat Spec Heavy Equip Oper Heavy Equip Oper-L lnd Waste In spec lnd Waste lnvtgtr Laboratory Tech WQC Landfill Technician Maint Mech Management Analyst (3) Manager Environmental Control Program Manager Environmental Compliance Manager Laboratory Services Manager Maintenance Operations Manager Solid Waste Manager Water Quality Control Plant Program Assistant I Program Assistant II Project Engineer Project Manager Refuse Disp Atten Senior Management Analyst Sr Chemist Senior Industrial Waste Inspector Sr Mech Sr Operator WQC Senior Accountant Senior Business Analyst Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 d d d FY 2014 A opte A opted Midyear Actuals Actuals Actuals Adjusted 0.46 0.00 3.20 0.00 1.00 0.00 0.00 3.30 1.00 0.75 1.00 0.00 1.13 1.00 3.00 0.00 0.00 2.00 0.08 3.00 2.00 0.00 1.00 1.40 2.00 0.54 2.00 0.04 0.02 5.90 3.15 2.00 2.00 2.50 1.00 7.00 0.00 3.00 1.00 1.00 1.38 1.00 1.00 2.00 1.00 2.00 0.00 4.00 0.10 1.00 0.00 1.00 6.00 0.23 0.00 0.46 0.00 3.20 0.00 1.00 0.00 0.00 3.30 1.00 0.75 1.00 0.10 1.13 1.00 3.00 0.00 0.00 2.00 0.08 3.00 2.00 0.00 1.00 1.40 2.00 0.54 2.00 0.04 0.00 5.90 3.15 2.00 2.00 2.50 1.00 7.00 0.00 3.00 1.00 1.00 1.38 1.00 1.00 2.00 1.00 2.00 0.00 4.00 0.10 1.00 0.00 1.00 6.00 0.23 0.00 0.46 0.00 3.20 0.00 1.00 0.00 1.00 3.30 1.00 0.75 2.00 0.10 0.13 1.00 3.00 0.00 1.00 2.00 0.08 3.00 2.00 0.00 1.00 1.40 2.00 0.54 0.00 0.04 0.00 5.90 3.15 2.00 2.00 2.50 0.00 7.00 1.20 3.00 0.00 1.00 1.38 1.00 1.00 2.00 1.00 2.00 0.00 4.00 0.10 1.00 0.00 1.00 6.00 0.23 0.00 Budget Budget Change 0.45 0.00 2.15 0.00 1.00 1.00 1.00 3.00 1.00 0.30 2.00 0.10 0.00 1.00 3.00 0.00 1.00 2.00 0.08 3.00 2.00 0.00 1.00 1.30 2.00 0.54 0.00 0.04 0.00 1.90 2.15 2.00 2.00 2.50 1.00 7.00 1.20 3.00 0.00 1.00 1.00 1.00 1.00 2.00 1.00 2.00 0.00 0.00 0.05 1.00 0.00 1.00 6.00 0.30 0.13 0.45 0.10 2.15 0.10 1.00 1.00 1.00 1.50 0.00 0.30 2.00 0.00 0.13 1.00 3.00 0.10 1.00 2.00 0.08 3.00 2.00 0.00 1.00 0.30 2.00 0.54 0.00 0.04 0.00 1.61 1.86 3.00 2.00 2.50 1.00 7.00 1.30 3.00 1.00 1.00 0.96 1.00 1.00 1.00 2.00 1.85 0.35 0.00 0.05 1.00 1.00 1.00 6.00 0.30 0.00 (1.00) 1.00 0.45 0.10 2.15 0.10 0.00 1.00 1.00 1.50 0.00 0.30 2.00 0.00 0.13 1.00 3.00 0.10 1.00 2.00 0.08 3.00 2.00 0.00 1.00 0.30 2.00 0.54 0.00 0.04 0.00 1.61 1.86 3.00 2.00 2.50 1.00 7.00 2.30 3.00 1.00 1.00 0.96 1.00 1.00 1.00 2.00 1.85 0.35 0.00 0.05 1.00 1.00 1.00 6.00 0.30 0.00 Senior Engineer Senior Financial Analyst (1) Senior Industrial Waste Investigator Senior Management Analyst (1) Senior Technologist St Maint Asst St Sweeper Op Storekeeper Superintendent Public Works Operations Supervisor Public Works Supervisor Water Quality Control Operations Surveying Asst Surveyor, Public Wks Technologist Traf Cant Maint I Manager Watershed Protection WQC Pit Oper II Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 d FY 2014 Adopte Adopted Midyear Actuals Actuals Actuals Adjusted 2.45 0.16 0.00 0.00 0.13 2.00 7.00 1.00 0.20 1.00 5.00 0.11 0.11 0.00 0.06 0.00 16.00 2.75 0.16 0.00 0.00 0.13 2.00 7.00 1.00 0.20 1.00 5.00 0.11 0.11 0.00 0.06 0.00 16.00 2.25 0.16 0.00 0.00 1.13 2.00 7.00 1.00 0.00 1.00 3.00 0.11 0.11 0.00 0.06 1.00 17.00 Budget Budget Change 1.90 0.16 0.00 0.00 1.13 2.00 7.00 1.00 0.00 0.00 3.00 0.11 0.11 0.00 0.06 1.00 17.00 1.80 0.16 0.00 0.00 1.13 0.00 5.96 1.00 0.00 0.00 3.00 0.00 0.11 1.00 0.06 0.00 16.00 (0.16) 0.16 1.80 0.00 0.00 0.16 1.13 0.00 5.96 1.00 0.00 0.00 3.00 0.00 0.11 1.00 0.06 0.00 16.00 Total Public Works Enterpnse Funds 114.63 115.01 114.51 104.06 99.19 0.00 99.19 (1) Title change 8.60 FTE Senior Financial Analyst to Senior Management Analyst for various funds and departments (3) Title change 1.00 FTE Administrator, Refuse to Management Analyst Utilities Accountant Acct Spec Administrative Assistant Administrative Associate I Administrative Associate II (4) Assistant Director Utilities Engineering Assistant Director Utilities Operations Assistant Director Uti CustSupport Svs Assoc Engineer Assoc Res Planner Asst Dir Ut/Res Mgmt Assistant Director Administrative Services Assistant to the City Manager Business Analyst Cathodic Protection Technician Assistant Cathodic Tech Cement Finisher Chief Sustainability Officer Communications Manager Contracts Administrator Coord Util Saf & Sec Coord Utility Proj Cust Srv Specialist-L Cust Svc Represent Cust Svc Spec Deputy Chief/Fire Marshall Deputy Dir Adm Svcs Director Administrative Services/Chief Financial Officer Director Utilities Elec Asst I Elec Undgd lnspec Electric Project Engineer 0.75 2.50 1.00 2.00 7.00 1.00 1.00 1.00 0.00 2.00 1.00 0.00 0.00 2.87 1.00 1.00 1.00 0.00 0.00 1.00 1.00 4.00 2.00 5.00 . 2.00 0.08 0.20 0.15 1.00 5.00 2.00 1.00 0.75 2.50 1.00 2.00 7.00 1.00 1.00 1.00 0.00 0.00 1.00 0.00 0.35 2.87 1.00 1.00 1.00 0.00 1.00 1.00 1.00 5.00 2.00 5.00 2.00 0.08 0.20 0.15 1.00 5.00 2.00 2.00 0.75 2.50 1.00 2.00 7.00 1.00 1.00 1.00 0.00 0.00 1.00 0.10 0.35 4.87 1.00 1.00 1.00 0.00 1.00 1.00 1.00 4.00 2.00 5.00 2.00 0.08 0.00 0.15 1.00 5.00 2.00 2.00 0.60 2.55 1.00 2.00 7.00 1.00 1.00 1.00 0.00 0.00 1.00 0.00 0.35 5.87 1.00 1.00 1.00 0.00 1.00 1.00 1.00 4.00 2.00 5.00 2.00 0.08 0.00 0.25 1.00 4.00 2.00 2.00 0.60 2.55 1.00 1.00 6.00 1.00 1.00 1.00 0.50 0.00 1.00 0.25 0.00 5.87 1.00 1.00 1.00 0.35 0.00 0.70 1.00 6.00 2.00 6.00 2.00 0.08 0.00 0.20 1.00 4.00 2.00 2.00 (1.00) 0.60 2.55 1.00 1.00 5.00 1.00 1.00 1.00 0.50 0.00 1.00 0.25 0.00 5.87 1.00 1.00 1.00 0.35 0.00 0.70 1.00 6.00 2.00 6.00 2.00 0.08 0.00 0.20 1.00 4.00 2.00 2.00 Electric Underground Inspector-Lead Electrician Electrician-Lead Engineer Engineering Manager-Electric Engineering Manager-WGW Engr Tech Ill (4) Equip Operator Gas System Tech · Gas System Technician II Haz Mat Inspector Haz Mat Spec Heavy Equip Oper Inspector, Field Svc Lineper/Cable Spl Lineper/Cable Spi-L Maint Mech Maintenance Mechanic-Welding Manager Energy Risk Manager, Utilities Credit and Collection Marketing Eng Meter Reader Meter Reader-Lead Manager Customer Service & Meter Reading Manager Electric Operations Manager Utility Marketing Services Manager Utility Operations WGW Manager Utility Telecomm Offset Equip Op OH UG Troubleman Planner Power Engr Program Assistant I Project Engineer Project Manager Resource Planner Restoration Lead Senior Management Analyst (1) Sr Mech Sr Mkt Analyst Sr Util Field Svc Rep Sr Water Sys Oper Senior Accountant Senior Business Analyst Senior Deputy City Attorney Senior Electric Project Engineer Senior Financial Analyst (1) Senior Performance Auditor Senior Project Engineer Senior Resource Originator Senior Resource Planner Senior Technologist Storekeeper Supervising Electric Project Engineer Supervising Project Engineer Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 FY 2014 Adopted Adopted Midyear Actuals Actuals Actuals Adjusted Budget Budget Change 1.00 14.00 6.00 4.00 1.00 1.00 3.00 1.00 1.00 1.00 0.06 0.03 10.00 4.00 11.00 4.00 1.00 1.00 1.00 0.00 1.00 6.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 2.00 3.00 6.00 0.75 4.00 1.00 1.00 1.00 1.00 1.00 2.00 0.75 1.00 0.00 4.00 0.60 0.00 4.00 1.00 6.00 0.87 2.00 2.00 0.00 1.00 14.00 6.00 4.00 1.00 1.00 3.00 1.00 2.00 1.00 0.06 0.00 9.00 4.00 11.00 4.00 1.00 1.00 1.00 0.00 1.00 6.00 1.00 1.00 1.00 1.00 1.00 1.00 0.48 0.00 0.30 3.00 3.00 5.00 0.75 5.00 1.00 1.00 1.00 1.00 1.00 2.00 0.75 2.00 1.00 4.00 1.10 1.00 4.00 0.00 7.00 0.87 2.00 1.00 1.00 1.00 14.00 6.00 4.00 1.00 1.00 3.00 1.00 2.00 1.00 0.06 0.00 9.00 4.00 11.00 4.00 0.00 2.00 0.00 0.00 1.00 6.00 1.00 1.00 1.00 1.00 1.00 1.00 0.48 0.00 0.30 3.00 3.00 5.00 0.75 5.00 1.00 1.00 1.00 1.00 1.00 2.00 0.75 2.00 1.00 4.00 1.60 1.00 4.00 0.00 7.00 0.87 2.00 1.00 1.00 1.00 14.00 6.00 4.00 1.00 1.00 3.00 1.00 2.00 1.00 0.06 0.00 8.00 5.00 11.00 4.00 0.00 2.00 0.00 0.00 1.00 6.00 1.00 1.00 1.00 1.00 1.00 1.00 0.48 2.00 0.30 3.00 3.00 5.00 0.75 5.00 1.00 1.00 1.00 1.00 1.00 2.00 0.70 2.00 1.00 4.00 1.40 1.00 4.00 0.00 7.00 0.87 2.00 1.00 1.00 1.00 14.00 6.00 4.00 1.00 1.00 3.00 1.00 2.00 1.00 0.06 0.00 8.70 4.00 11.00 4.00 0.00 2.00 0.00 0.00 1.00 . 6.00 1.00 2.00 1.00 1.00 1.00 1.00 0.48 2.00 0.30 3.00 2.50 5.00 0.75 5.00 1.00 1.00 1.00 1.00 1.00 2.00 0.70 2.00 1.00 4.00 1.40 1.00 5.00 0.00 6.00 0.87 2.00 1.00 1.00 1.00 1.40 (1.40) 1.00 14.00 6.00 4.00 1.00 1.00 4.00 1.00 2.00 1.00 0.06 0.00 8.70 4.00 11.00 4.00 0.00 2.00 0.00 0.00 1.00 6.00 1.00 2.00 1.00 1.00 1.00 1.00 0.48 2.00 0.30 3.00 2.50 5.00 0.75 5.00 1.00 2.40 1.00 1.00 1.00 2.00 0.70 2.00 1.00 4.00 0.00 1.00 5.00 0.00 6.00 0.87 2.00 1.00 1.00 Supervisor, Inspection Services Supervisor Water Transportation Supervisor WGW Sustainability Manager Tree Maint Person Util Acct Rep Util Comp Tech Uti I Comp Tech-L Util Credit/Col Spec Util Engr Estimator Uti I Fld Svcs Rep Utillnstaii/Rep Utillnstaii/Rep Ast Utillnstaii/Rep-L Util Locator Utilities Supervisor Uti I Syst Oper Utilities Compliance Manager Utilities Supervisor Utility Key Account Rep Uti Install Repair Lead-Welding Cert Uti Install Repair-Welding Cert Warehouse Supv Water Sys Oper II Wtr Mtr Crs Cn Tee Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 d d d d .d FY 2014 A opte A opte M1 year Actuals Actuals Actuals d Adjusted Bu get Budget Change 0.00 1.00 5.00 0.00 1.00 3.00 2.00 1.00 1.00 6.00 5.00 11.00 1.00 5.00 3.00 0.00 5.00 0.00 5.00 3.00 2.00 3.00 0.00 4.00 2.00 0.00 1.00 5.00 0.00 1.00 3.00 2.00 1.00 1.00 5.00 5.00 12.00 1.00 5.00 3.00 0.00 5.00 1.00 5.00 3.00 2.00 3.00 0.50 4.00 3.00 0.00 1.00 5.00 0.00 1.00 4.00 2.00 1.00 1.00 4.00 5.00 12.00 1.00 5.00 3.00 0.00 5.00 1.00 5.00 3.00 2.00 3.00 0.50 4.00 3.00 0.00 1.00 5.00 0.00 1.00 4.00 2.00 1.00 1.00 5.00 5.00 12.00 1.00 5.00 3.00 0.00 5.00 1.00 5.00 3.00 2.00 3.00 0.50 4.00 3.00 1.00 0.00 0.00 0.00 1.00 4.00 2.00 1.00 2.00 5.00 5.00 12.00 1.00 5.00 3.00 0.00 5.00 1.00 11.00 3.00 2.00 3.00 0.50 4.00 2.00 1.00 0.00 0.00 0.00 1.00 4.00 2.00 1.00 2.00 5.00 5.00 12.00 1.00 5.00 3.00 0.00 5.00 1.00 11.00 3.00 2.00 3.00 0.50 4.00 2.00 Total Utillt1es 241.61 250.71 251.11 253.76 255.36 0.00 255.36 (1) Title change 8.60 FTE Senior Financial Analyst to Senior Management Analyst for various funds and departments · (4) Correction to Table of Organization-funding for this position was included in the FY 2014 Adopted Budget OTHER FUNDS Capital Administrative Associate I Administrative Associate Ill Assoc Engineer Assistant Director Public Works Cement Finisher Cement Finisher Lead Contracts Administrator Engineer EngrTech Ill Heavy Equip Oper Inspector, Field Services Landscape Architect/Pk Planner Management Analyst Manager Facilities Maintenance and Projects Manager Maintenance Operations Program Assistant I Project Engineer Project Manager Senior Engineer Senior Financial Analyst (1) Senior Management Analyst (1) Senior Project Manager Superintendent Public Works Operations 1.80 1.00 0.60 0.15 3.00 1.00 0.00 2.70 2.30 0.20 0.00 1.00 1.00 0.20 0.50 1.00 3.80 1.50 2.25 0.00 0.00 0.00 0.20 0.80 1.00 0.60 0.15 3.00 1.00 0.60 2.70 2.30 0.20 0.00 1.00 1.00 0.20 0.50 1.00 3.80 0.50 2.05 0.60 0.00 0.00 0.20 0.80 1.00 0.60 0.15 3.00 1.00 0.60 2.70 2.30 0.20 0.00 1.00 1.25 0.00 0.90 1.00 3.80 0.50 2.55 0.60 0.00 0.00 0.00 1.00 1.00 0.90 0.15 3.00 1.00 0.60 2.70 2.40 0.20 0.00 1.00 1.50 0.00 0.90 1.00 3.80 1.00 2.00 0.60 0.00 0.90 0.00 0.80 0.90 2.70 0.15 3.00 1.00 0.60 2.70 0.50 0.20 0.67 1.00 1.50 0.00 0.90 1.00 4.85 1.20 2.00 0.60 0.00 0.90 0.00 (0.60) 0.60 0.80 0.90 2.70 0.15 3.00 1.00 0.60 2.70 0.50 0.20 0.67 1.00 1.50 0.00 0.90 1.00 4.85 1.20 2.00 0.00 0.60 0.90 0.00 Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 FY 2014 Adopted Adopted Midyear Actuals Actuals Actuals Adjusted Budget Budget Change Supervisor Facilities Management Supervisor Inspection and Surveying Surveying Asst Surveyor, Public Wks 0.05 0.20 0.11 0.11 0.05 0.20 0.11 0.11 0.00 0.20 0.11 0.11 0.00 0.20 0.11 0.11 0.00 0.20 0.00 0.11 0.00 0.20 0.00 0.11 Total Capttal 24.67 23.67 24.37 26 07 27.48 0.00 27.48 (1) Title change 8.60 FTE Senior Financial Analyst to Senior Management Analyst for various funds and departments Information Technology Administrative Assistant 0,07 0.07 1.07 1.00 1.00 Administrative Associate II 1.00 1.00 0.00 o.oo 0.00 Administrative Associate Ill 0.04 0.00 0.00 0.00 0.00 Assistant Director Administrative Services 0.40 0.40 0.40 0.30 0.10 Business Analyst 0.90 1.00 1.00 1.00 1.00 Director Information Technology/Chief Information Officer 1.00 1.00 1.00 1.00 1.00 Desktop Technician s.oo 5.00 5.00 5.00 5.00 Director Administrative Services/Chief Financial Officer 0.35 0.35 0.35 0.25 0.10 Manager Information Technology Security 0.00 0.00 0.00 i.oo 1.00 Management Analyst 0.00 0.50 0.50 1.00 1.00 Manager Information Technology 3.00 3.00 3.00 4.00 4.00 Principal Management Analyst (4) 0.00 0.00 0.00 0.00 0.00 Senior Business Analyst (1) (4) 1.80 2.00 2.00 2.00 2.00 Senior Financial Analyst 0.09 0.09 0.09 0.00 0.00 Senior Management Analyst (1). 0.00 0.00 0.00 o.oo 0.00 Senior Technologist 13.00 13.00 13.00 12.00 12.00 (1) Title change 8.60 FTE Senior Financial Analyst to Senior Management Analyst for various funds and departments (4) Title change 1.00 FTE Senior Business Analyst to Principal Management Analyst Printing and Mailing Fund Buyer 0.05 0.05 0.05 0.05 Mailing Svcs Spec 1.00 0.00 0.00 o.oo Manager Revenue Collections (2) 0.00 0.00 0.00 0.00 Offset Equip Op 1.00 1.52 1.52 1.52 Offset Equip Op-Lead 1.00 0.00 0.00 0.00 Senior Financial Analyst (2) 0.00 0.00 0.10 (2) Title change 0.10 FTE Senior Financial Analyst to Manager Revenue Collections Special Revenue Acct Spec 0.00 0.50 0.50 0.50 Acct Spec-Lead 0.00 0.00 0.00 0.00 Administrative Associate II 0.20 0.20 0.20 0.20 Bldg Serviceperson-L 0.00 0.00 0.00 0.00 Chief Transportation Official 0.00 0.00 0.00 0.00 Community Serv Offer 0.00 0.50 0.50 0.50 Electrician 0.00 0.00 0.00 0.00 Facilities Maint-L 0.00 0.00 0.00 0.00 Facilities Mech 0.00 0.00 0.00 0.00 Facilities Painter 0.00 0.00 0.00 0.00 Heavy Equipment Operator 0.00 0.00 0.00 0.00 Heavy Equipment Operator-Lead 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.52 0.00 0.10 1.55 0.41 0.40 0.20 0.10 0.50 0.20 0.15 0.45 0.25 0.29 0.29 1.00 0.00 0.00 0.10 1.00 1.00 5.00 0.10 1.00 1.00 4.00 1.00 1.00 (2.00) 0.00 0.00 1.00 1.00 0.00 0.00 0.10 0.10 1.52. 0.00 (0.10) 0.00 1.55 0.41 0.40 0.20 0.10 0.50 0.20 0.15 0.45 0.25 0.29 0.29 Management Analyst Manager Maintenance Operations Planner Senior Financial Analyst {1) Senior Management Analyst (1) Street Maintenance Asst Street Sweeper Operator Attachment A, Exhibit 3 Table of Organization FY 2013 FY 2014 FY 2014 FY 2010 FY 2011 FY 2012 FY 2014 Adopted Adopted Midyear Actuals Actuals Actuals h Adjusted Budget Budget C ange 0.00 0.00 0.00 0.00 0.00 0.00 0.9S 0.9S 0.9S 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 o.so 0.00 0.95 0.00 0.00 0.00 0.00 0.00 0.19 0.95 0.20 0.00 2.00 1.04 (0.20) 0.20 0.00 0.19 0.95 0.00 0.20 2.00 1.04 Total SpeCial Revenue 1.15 2.15 2 15 2.65 9.17 0.00 9.17 {1) Title change 8.60 FTE Senior Financial Analyst to Senior Management Analyst for vario1,1s funds and departments Vehicle Replacement Fund Administrative Associate Ill Assistant Director Public Works Assistant Manager Fleet Equipment Maintenance Service Person Manager Fleet Fleet Services Coordinator Management Analyst Mobile Service Tech Motor Equipment Mechanic II Project Engineer Senior Fleet Services Coordinator Senior Engineer Senior Financial Analyst {1) Senior Management Analyst (1) 1.00 0.00 1.00 2.00 1.00 2.00 0.00 1.00 7.00 0.00 1.00 0.00 0.08 0.00 1.00 0.00 1.00 2.00 1.00 2.00 0.00 1.00 7.00 0.00 1.00 0.00 0.08 0.00 1.00 1.00 0.00 0.25 1.00 1.00 2.00 2.00 1.00 1.00 2.00 2.00 0.00 0.20 1.00 1.00 7.00 7.00 0.00 0.00 1.00 1.00 0.00 0.00 0.08 0.08 0.00 0.00 1.00 1.00 0.25 0.25 1.00 1.00 2.00 2.00 1.00 1.00 2.00 2.00 0.20 0.20 1.00 1.00 7.00 7.00 0.00 0.00 1.00 1.00 0.00 0.00 0.08 (0.08) 0.00 0.00 0.08 0.08 Total Veh1cle Replacement Fund 16.08 16.08 16.08 16.53 16.53 0.00 16.53 (1) Title change 8.60 FTE Senior Financial Analyst to Senior Management Analyst for various funds and departments