Loading...
Resolution No. 17-44 CITY OF TIGARD, OREGON TIGARD CITY COUNCIL RESOLUTION NO. 17-If t f A RESOLUTION TO ADOPT THE FY 2018 FIRST QUARTER BUDGET SUPPLEMENTAL INCLUDING BUDGET ADJUSTMENTS TO PUBLIC WORKS, POLICY AND ADMINISTRATION, AND COMMUNITY SERVICES. WHEREAS,the city acknowledges those items that were unknown at the time the FY 2018 budget was adopted; and WHEREAS, the city recognizes approximately $1,281,651 of unanticipated budget in operations and transfers; and WHEREAS, the increase in budget is offset by unanticipated fund balance, miscellaneous revenue, and contingency. NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that: SECTION 1: The FY 2017-18 Budget is hereby amended as detailed in Exhibit A. SECTION: This resolution is effective immediately upon passage. PASSED: This qday of ekk ber 2017. � 0 of� Mayor-City of Tigard ATTEST: ':Ke-" - Kelly Burgoyne,Deputy City Recorder RESOLUTION NO. 17- Page 1 Exhibit A (Q1CD02- Change position funding split for Permit Tech Assistant Use revenue from the Building Division to fund the majority of the Permit Technician Assistant position.This would result in a change from the current 20/80 split with General Fund so that the Building Fund supports 80 percent of that position,while General Fund would support 20 percent. The position will handle more Building related activities including balancing cash drawer and intake of building permits. Fund 1 of 2 FY 2018 Q1 Revised Q1 General Fund Budget Amendment Budget Resources Beginning Fund Balance $ 14,755,111 $ - $ 14,755,111 Property Taxes $ 15,359,468 $ - $ 15,359,468 Franchise Fees $ 6,238,652 $ - $ 6,238,652 Special Assessments $ - $ - $ - Licenses&Permits $ 2,328,630 $ - $ 2,328,630 Intergovernmental $ 6,074,334 $ - $ 6,074,334 Charges for Services $ 2,783,381 $ - $ 2,783,381 Fines &Forfeitures $ 692,476 $ - $ 692,476 Interest Earnings $ 103,722 $ - $ 103,722 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 48,392,206 $ - $ 48,392,206 Requirements Community Development $ 3,863,116 $ (42,500) $ 3,820,616 Community Services $ 23,905,436 $ - $ 23,905,436 Policy and Administration $ 866,598 $ - $ 866,598 Public Works $ 4,914,851 $ - $ 4,914,851 Program Expenditures Total $ 33,550,001 $ (42,500) $ 33,507,501 Debt Service $ - $ - $ - Loan to CCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426 Contingency $ 1,295,000 $ 42,500 $ 1,337,500 Total Budget $ 36,759,427 $ - $ 36,759,427 Reserve For Future Expenditure $ 11,632,779 $ - $ 11,632,779 Total Requirements $ 48,392,206 $ - $ 48,392,206 Exhibit A Q1CD02- Change position funding split for Permit Tech Assistant Fund 2 of 2 FY 2018 Q1 Revised Q1 Building Fund Budget Amendment Budget Resources Beginning Fund Balance $ 5,368,306 $ - $ 5,368,306 Property Taxes $ - $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses&Permits $ 3,442,378 $ - $ 3,442,378 Intergovernmental $ 8,281 $ - $ 8,281 Charges for Services $ 7,035 $ - $ 71035 Fines&Forfeitures $ - $ _ $ _ Interest Earnings $ 19,782 $ - $ 19,782 Miscellaneous $ 932 $ - $ 932 Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 300,000 $ - $ 300,000 Total Resources $ 9,146,714 $ - $ 9,146,714 Requirements Community Development $ 2,309,303 $ 42,500 $ 2,351,803 Community Services $ - $ - $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ 2,309,303 $ 42,500 $ 2,351,803 Debt Service $ _ $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ _ Transfers to Other Funds $ _ $ _ $ _ Contingency $ 250,000 $ (42,500) $ 207,500 Total Budget $ 2,559,303 $ - $ 2,559,303 Reserve For Future Expenditure $ 6,587,411 $ - $ 6,587,411 Total Requirements $ 9,146,714 $ - $ 9,146,714 Exhibit A Q1CD03 - Increase of 0.5 FTE for Community Engagement Assistant With the Building Division supporting 80 percent of the Permit Technician Assistant position, the resulting savings to the General Fund would be used to expand the half-time Community Engagement Assistant position to a full-time position. For past 9 months, the increasing popularity of the community engagement efforts pushed the staff to work overtime. Additionally,the staff will add more community engagement events to the schedule. FY 2018 Q1 Revised Q General Fund Budget Amendment Budget Resources Beginning Fund Balance $ 14,755,111 $ - $ 14,755,111 Property Taxes $ 15,359,468 $ - $ 15,359,468 Franchise Fees $ 6,238,652 $ - $ 6,238,652 Special Assessments $ - $ - $ - Licenses &Permits $ 2,328,630 $ - $ 2,328,630 Intergovernmental $ 6,074,334 $ - $ 6,074,334 Charges for Services $ 2,783,381 $ - $ 2,783,381 Fines & Forfeitures $ 692,476 $ - $ 692,476 Interest Earnings $ 103,722 $ - $ 103,722 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ - $ - $ - Total Resources $ 48,392,206 $ - $ 48,392,206 Requirements Community Development $ 3,863,116 $ 37,000 $ 3,900,116 Community Services $ 23,905,436 $ - $ 23,905,436 Policy and Administration $ 866,598 $ - $ 866,598 Public Works $ 4,914,851 $ - $ 4,914,851 Program Expenditures Total $ 33,550,001 $ 37,000 $ 33,587,001 Debt Service $ - $ - $ - Loan to CCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426 Contingency $ 1,295,000 $ (37,000) $ 1,258,000 Total Budget $ 36,759,427 $ - $ 36,759,427 Reserve For Future Expenditure $ 111632,779 $ - $ 11,632,779 Total Requirements $ 48,392,206 $ - $ 48,392,206 Exhibit A Q1CM01- Increase of 1.0 FTE for City Attorney Each department budgeted legal fees in the adopted FY17-18 budget. In October,the City Council approved the hiring of an in-house city attorney(1.0 FTE).The legal fees in the FY 17-18 budget will be transferred to pay for the city attorney position in a newly established division. Costs transfer will include items such as salary, benefits, training, office set up,and contractual professional services. FY 2018 Q1 Revised Q1 Central Services Fund Budget Amendment Budget Resources Beginning Fund Balance $ 1,030,995 $ - $ 1,030,995 Property Taxes $ - $ _ $ _ Franchise Fees $ _ $ _ $ Special Assessments $ _ $ _ $ _ Licenses &Permits $ 37,344 $ - $ 37,344 Intergovernmental $ 45,000 $ - $ 45,000 Charges for Services $ 8,030,785 $ 240,151 $ 8,270,936 Fines &Forfeitures $ _ $ _ $ Interest Earnings $ 22,593 $ - $ 22,593 Miscellaneous $ 13,400 $ - $ 13,400 Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ 580,775 $ - $ 580,775 Total Resources $ 9,760,892 $ 240,151 $ 10,001,043 Requirements Community Development $ _ $ _ $ _ Community Services $ _ $ _ $ Policy and Administration $ 8,760,290 $ 240,151 $ 9,000,441 Public Works $ _ $ _ $ Program Expenditures Total $ 8,760,290 $ 240,151 $ 9,000,441 Debt Service $ _ $ _ $ Loan to CCDA $ _ $ _ $ Work-In-Progress $ _ $ _ $ Transfers to Other Funds $ _ $ _ $ Contingency $ 250,000 $ - $ 250,000 Total Budget $ 9,010,290 $ 240,151 $ 9,250,441 Reserve For Future Expenditure $ 750,602 $ - $ 750,602 Total Requirements $ 9,760,892 $ 240,151 $ 10,001,043 Exhibit A Q1PD01- TPOA Contract Costs As per the TPOA contract provisions effective July 1, 2017,the Police Department must increase appropriation to accommodate the increased costs. FY 2018 Q1 Revised Q General Fund Budget Amendment Budget Resources Beginning Fund Balance $ 14,755,111 $ - $ 14,755,111 Property Taxes $ 15,359,468 $ - $ 15,359,468 Franchise Fees $ 6,238,652 $ - $ 6,238,652 Special Assessments $ _ $ _ $ _ Licenses &Permits $ 2,328,630 $ - $ 2,328,630 Intergovernmental $ 6,074,334 $ - $ 6,074,334 Charges for Services $ 2,783,381 $ - $ 2,783,381 Fines &Forfeitures $ 692,476 $ - $ 692,476 Interest Earnings $ 103,722 $ - $ 103,722 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 48,392,206 $ - $ 48,392,206 Requirements Community Development $ 3,863,116 $ - $ 3,863,116 Community Services $ 23,905,436 $ 228,000 $ 24,133,436 Policy and Administration $ 866,598 $ - $ 866,598 Public Works $ 4,914,851 $ - $ 4,914,851 Program Expenditures Total $ 33,550,001 $ 228,000 $ 33,778,001 Debt Service $ _ $ $ Loan to CCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ - $ _ $ Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426 Contingency $ 1,295,000 $ (228,000) $ 1,067,000 Total Budget $ 36,759,427 $ - $ 36,759,427 Reserve For Future Expenditure $ 11,632,779 $ - $ 11,632,779 Total Requirements $ 48,392,206 $ - $ 48,392,206 Exhibit A Q1PD02-Vehicle replacement Police Vehicle#14-825 was totaled during an incident. An officer was responding to an emergency "in-progress" crime. While en route to the scene,the patrol vehicle and a civilian vehicle collided in an intersection. No one was hurt. FY 2018 Q1 Revised Q General Fund Budget Amendment Budget Resources Beginning Fund Balance $ 14,755,111 $ - $ 14,755,111 Property Taxes $ 15,359,468 $ - $ 15,359,468 Franchise Fees $ 6,238,652 $ - $ 6,238,652 Special Assessments $ - $ _ $ - Licenses &Permits $ 2,328,630 $ - $ 2,328,630 Intergovernmental $ 6,074,334 $ - $ 6,074,334 Charges for Services $ 2,783,381 $ - $ 2,783,381 Fines &Forfeitures $ 692,476 $ - $ 692,476 Interest Earnings $ 103,722 $ - $ 103,722 Miscellaneous $ 56,432 $ 34,000 $ 90,432 Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ _ $ _ $ _ Total Resources $ 48,392,206 $ 34,000 $ 48,426,206 Requirements Community Development $ 3,863,116 $ - $ 3,863,116 Community Services $ 23,905,436 $ 34,000 $ 23,939,436 Policy and Administration $ 866,598 $ - $ 866,598 Public Works $ 4,914,851 $ - $ 4,914,851 Program Expenditures Total $ 33,550,001 $ 34,000 $ 33,584,001 Debt Service $ _ $ _ $ _ Loan to CCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ _ $ _ $ - Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426 Contingency $ 1,295,000 $ - $ 1,295,000 Total Budget $ 36,759,427 $ 34,000 $ 36,793,427 Reserve For Future Expenditure $ 11,632,779 $ - $ 11,632,779 Total Requirements $ 48,392,206 $ 34,000 $ 48,426,206 Exhibit A Q1PW01- CIP 92052 Bull Mountain Park Trail- request for additional funding This request covers internal costs that went over estimate. Fund 1 of 2 FY 2018 Q1 Revised Q Parks Capital Fund Budget Amendment Budget Resources Beginning Fund Balance $ 434,066 $ - $ 434,066 Property Taxes $ _ $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ _ $ _ $ _ Intergovernmental $ 1,513,627 $ - $ 1,513,627 Charges for Services $ - $ _ $ - Fines & Forfeitures $ - $ _ $ _ Interest Earnings $ 3,015 $ - $ 3,015 Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 3,508,372 $ 17,000 $ 3,525,372 Total Resources $ 5,459,080 $ 17,000 $ 5,476,080 Requirements Community Development $ _ $ - $ - Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ 5,358,627 $ 17,000 $ 5,375,627 Transfers to Other Funds $ _ $ _ $ _ Contingency $ _ $ - $ _ Total Budget $ 5,358,627 $ 17,000 $ 5,375,627 Reserve For Future Expenditure $ 100,453 $ - $ 100,453 Total Requirements $ 5,459,080 $ 17,000 $ 5,476,080 Exhibit A Q1PW01- CIP 92052 Bull Mountain Park Trail- request for additional funding Fund 2 of 2 FY 2018 Q1 Revised Q Parks SDC Fund Budget Amendment Budget Resources Beginning Fund Balance $ 6,186,941 $ - $ 6,186,941 Property Taxes $ _ $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ 2,969,431 $ - $ 2,969,431 Intergovernmental $ - $ _ $ - Charges for Services $ _ $ _ $ _ Fines & Forfeitures $ _ $ _ $ _ Interest Earnings $ 19,782 $ - $ 19,782 Miscellaneous $ - $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 9,176,154 $ - $ 9,176,154 Requirements Community Development $ _ $ _ $ - Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ - Transfers to Other Funds $ 1,616,455 $ 17,000 $ 1,633,455 Contingency $ 80,000 $ (17,000) $ 63,000 Total Budget $ 1,696,455 $ - $ 1,696,455 Reserve For Future Expenditure $ 7,479,699 $ - $ 7,479,699 Total Requirements $ 9,176,154 $ - $ 9,176,154 Exhibit A Q1PW02- CIP 97013-01,02 Saxony Properties additional funding request for CCDA High construction bid. Request approved by City Finance,funds will only be used if all other funding is exhausted. FY 2018 Q1 Revised Q General Fund Budget Amendment Budget Resources Beginning Fund Balance $ 14,755,111 $ - $ 14,755,111 Property Taxes $ 15,359,468 $ - $ 15,359,468 Franchise Fees $ 6,238,652 $ - $ 6,238,652 Special Assessments $ - $ _ $ - Licenses &Permits $ 2,328,630 $ - $ 2,328,630 Intergovernmental $ 6,074,334 $ - $ 6,074,334 Charges for Services $ 2,783,381 $ - $ 2,783,381 Fines & Forfeitures $ 692,476 $ - $ 692,476 Interest Earnings $ 103,722 $ - $ 103,722 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ - $ _ $ _ Total Resources $ 48,392,206 $ - $ 48,392,206 Requirements Community Development $ 3,863,116 $ - $ 3,863,116 Community Services $ 23,905,436 $ - $ 23,905,436 Policy and Administration $ 866,598 $ - $ 866,598 Public Works $ 4,914,851 $ - $ 4,914,851 Program Expenditures Total $ 33,550,001 $ - $ 33,550,001 Debt Service $ _ $ _ $ _ Loan to CCDA $ 1,000 $ 40,000 $ 41,000 Work-In-Progress $ _ $ - $ - Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426 Contingency $ 1,295,000 $ (40,000) $ 1,255,000 Total Budget $ 36,759,427 $ - $ 36,759,427 Reserve For Future Expenditure $ 11,632,779 $ - $ 11,632,779 Total Requirements $ 48,392,206 $ - $ 48,392,206 Exhibit A Q1PW03 - CIP 93009 Fanno Creek Slope Stabilization (Arthur Court Field conditions changed design requirements, request is for updated design requirements. Fund 1 of 2 FY 2018 Q1 Revised Q Sanitary Sewer Fund Budget Amendment Budget Resources Beginning Fund Balance $ 3,479,552 $ - $ 3,479,552 Property Taxes $ - $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ - Licenses &Permits $ 42,200 $ - $ 42,200 Intergovernmental $ 1,145,000 $ - $ 1,145,000 Charges for Services $ 2,753,696 $ - $ 2,753,696 Fines & Forfeitures $ - $ _ $ _ Interest Earnings $ 10,333 $ - $ 10,333 Miscellaneous $ 13,091 $ - $ 13,091 Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 193,500 $ - $ 193,500 Total Resources $ 7,637,372 $ - $ 7,637,372 Requirements Community Development $ - $ _ $ - Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ - Public Works $ 2,471,239 $ - $ 2,471,239 Program Expenditures Total $ 2,471,239 $ - $ 2,471,239 Debt Service $ _ $ _ $ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ 2,074,000 $ 15,000 $ 2,089,000 Transfers to Other Funds $ 593,866 $ - $ 593,866 Contingency $ 400,000 $ (15,000) $ 385,000 Total Budget $ 5,539,105 $ - $ 5,539,105 Reserve For Future Expenditure $ 2,098,267 $ - $ 2,098,267 Total Requirements $ 7,637,372 $ - $ 7,637,372 Exhibit A Q1PW03 - CIP 93009 Fanno Creek Slope Stabilization (Arthur Court) Fund 2 of 2 FY 2018 Q1 Revised Q Stormwater Fund Budget Amendment Budget Resources Beginning Fund Balance $ 4,892,381 $ - $ 4,892,381 Property Taxes $ _ $ _ $ Franchise Fees $ _ $ _ $ Special Assessments $ _ $ _ $ Licenses &Permits $ _ $ _ $ Intergovernmental $ _ $ - $ Charges for Services $ 2,755,890 $ - $ 2,755,890 Fines &Forfeitures $ _ $ _ $ Interest Earnings $ 7,936 $ - $ 7,936 Miscellaneous $ 3,100 $ - $ 3,100 Other Financing Sources $ _ $ - $ - Transfers In from Other Funds $ 558,000 $ - $ 558,000 Total Resources $ 8,217,307 $ - $ 8,217,307 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ Policy and Administration $ _ $ _ $ Public Works $ 2,329,116 $ - $ 2,329,116 Program Expenditures Total $ 2,329,116 $ - $ 2,329,116 Debt Service $ _ $ $ Loan to CCDA $ _ $ _ $ Work-In-Progress $ 1,619,500 $ 15,000 $ 1,634,500 Transfers to Other Funds $ 255,807 $ - $ 255,807 Contingency $ 200,000 $ (15,000) $ 185,000 Total Budget $ 4,404,423 $ - $ 4,404,423 Reserve For Future Expenditure $ 3,812,884 $ - $ 3,812,884 Total Requirements $ 8,217,307 $ - 1 8,217,307 Exhibit A Q1PW04 - CIP 91020 Civic Center Visioning Plan Prior year appropriation- unable to carry forward in technical adjustment. MWA contract is active. FY 2018 Q1 Revised Q Facilities Capital Projects Fund Budget Amendment Budget Resources Beginning Fund Balance $ 860,000 $ 204,000 $ 1,064,000 Property Taxes $ _ $ _ $ Franchise Fees $ _ $ $ Special Assessments $ _ $ _ $ Licenses &Permits $ _ $ _ $ Intergovernmental $ _ $ _ $ Charges for Services $ _ $ _ $ Fines &Forfeitures $ _ $ _ $ Interest Earnings $ 3,212 $ - $ 3,212 Miscellaneous $ _ $ $ Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ 100,000 $ - $ 100,000 Total Resources $ 963,212 $ 204,000 $ 1,167,212 Requirements Community Development $ _ $ - $ - Community Services $ _ $ _ $ Policy and Administration $ _ $ _ $ Public Works $ _ $ $ Program Expenditures Total $ _ $ _ $ Debt Service $ _ $ $ Loan to CCDA $ _ $ $ Work-In-Progress $ 100,000 $ 204,000 $ 304,000 Transfers to Other Funds $ - $ _ $ Contingency $ 50,000 $ - $ 50,000 Total Budget $ 150,000 $ 204,000 $ 354,000 Reserve For Future Expenditure $ 813,212 $ - $ 813,212 Total Requirements $ 963,212 $ 204,000 $ 1,167,212 Exhibit A Q1PW05 - CIP 93013 East Tigard Sewer Replacement $158,500- Prior year appropriation requested.Appropriation does not increase total project cost.CWS has appropriated this reimbursement in the current year. Criteria to reimburse this request has been met, reimbursement is received as project progresses. $450,000-Request addresses higher than anticipated construction bid. Request has been evaluated and reviewed by CWS and City Finance. Of the total,$370k will be reimbursed by CWS. CWS has appropriated this reimbursement in the current year. Criteria to reimburse this request has been met, reimbursement is received as project progresses. FY 2018 Q1 Revised Q Sanitary Sewer Fund Budget Amendment Budget Resources Beginning Fund Balance $ 3,479,552 $ - $ 3,479,552 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 42,200 $ - $ 42,200 Intergovernmental $ 1,145,000 $ 528,500 $ 1,673,500 Charges for Services $ 2,753,696 $ - $ 2,753,696 Fines &Forfeitures $ - $ - $ - Interest Earnings $ 10,333 $ - $ 10,333 Miscellaneous $ 13,091 $ - $ 13,091 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 193,500 $ - $ 193,500 Total Resources $ 7,637,372 $ 528,500 $ 8,165,872 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 2,471,239 $ - $ 2,471,239 Program Expenditures Total $ 2,471,239 $ - $ 2,471,239 Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress $ 2,074,000 $ 608,500 $ 2,682,500 Transfers to Other Funds $ 593,866 $ - $ 593,866 Contingency $ 400,000 $ (80,000) $ 320,000 Total Budget $ 5,539,105 $ 528,500 $ 6,067,605 Reserve For Future Expenditure $ 2,098,267 $ - $ 2,098,267 Total Requirements $ 7,637,372 $ 528,500 $ 8,165,872 Exhibit A Q1PW06 - CIP 96047 Canterbury Pump Station request for carryforward Prior year appropriation of$40,000 needed to completed project design. FY 2018 Q1 Revised Q Water Fund Budget Amendment Budget Resources Beginning Fund Balance $ 15,704,833 $ 40,000 $ 15,744,833 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 74,986 $ - $ 74,986 Intergovernmental $ - $ - $ - Charges for Services $ 20,496,907 $ - $ 20,496,907 Fines & Forfeitures $ - $ - $ - Interest Earnings $ 30,644 $ - $ 30,644 Miscellaneous $ 10,933 $ - $ 10,933 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 58,751 $ - $ 58,751 Total Resources $ 36,377,054 $ 40,000 $ 36,417,054 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 6,898,886 $ - $ 6,898,886 Program Expenditures Total $ 6,898,886 $ - $ 6,898,886 Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress $ - $ 40,000 $ 40,000 Transfers to Other Funds $ 17,457,159 $ - $ 17,457,159 Contingency $ 500,000 $ - $ 500,000 Total Budget $ 24,856,045 $ 40,000 $ 24,896,045 Reserve For Future Expenditure $ 11,521,009 $ - $ 11,521,009 Total Requirements $ 36,377,054 $ 40,000 $ 36,417,054 Exhibit A O1PW07- CIP 95049 Commercial Street Sidewalk(Lincoln Avenue to 95th Avenue) CDBG $54,000-Request to cover additional cost resultant from receipt of second bid over engineers estimate. Overage will be split 50/50 with CDBG if overage is approved by CDBG in mid-October 2017. $68,500-Prior year appropriation of$68,320; 100%reimbursable by CDBG grant.Grant compliance has been met,grant can be billed for reimbursement. Project has been rebid twice. Project came in over engineer's estimate in both bids.Second bid was more favorable than first. Request relies on approval of$54,000 in additional appropriation requested to cover bid overage. Fund 1 of 2 FY 2018 Q1 Revised Q Gas Tax Fund Budget Amendment Budget Resources Beginning Fund Balance $ 2,374,799 $ - $ 2,374,799 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ 68,974 $ - $ 68,974 Intergovernmental $ 3,105,614 $ 95,500 $ 3,201,114 Charges for Services $ - $ - $ - Fines &Forfeitures $ - $ - $ - Interest Earnings $ 55,732 $ - $ 55,732 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 150,000 $ - $ 150,000 Total Resources $ 5,817,937 $ 95,500 $ 5,913,437 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ - $ - $ - Public Works $ 2,331,702 $ - $ 2,331,702 Program Expenditures Total $ 2,331,702 $ - $ 2,331,702 Debt Service $ 585,000 $ - $ 585,000 Loan to CCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ 1,375,987 $ 122,500 $ 1,498,487 Contingency $ 200,000 $ (27,000) $ 173,000 Total Budget $ 4,492,689 $ 95,500 $ 4,588,189 Reserve For Future Expenditure $ 1,325,248 $ - $ 1,325,248 Total Requirements $ 5,817,937 $ 95,500 $ 5,913,437 Exhibit A Q1PW07- CIP 95049 Commercial Street Sidewalk(Lincoln Avenue to 95th Avenue) CDBG Fund 2 of 2 FY 2018 Q1 Revised Q Transportation CIP Fund Budget Amendment Budget Resources Beginning Fund Balance $ 293,630 $ - $ 293,630 Property Taxes $ _ $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses&Permits $ _ $ _ $ _ Intergovernmental $ 2,110,500 $ - $ 2,110,500 Charges for Services $ _ $ _ $ _ Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ _ $ _ $ _ Miscellaneous $ 1,378,000 $ - $ 1,378,000 Other Financing Sources $ _ $ _ $ - Transfers In from Other Funds $ 2,521,000 $ 122,500 $ 2,643,500 Total Resources $ 6,303,130 $ 122,500 $ 6,425,630 Requirements Community Development $ _ $ - $ _ Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ 6,009,500 $ 122,500 $ 6,132,000 Transfers to Other Funds $ _ $ - $ _ Contingency $ _ $ _ $ _ Total Budget $ 6,009,500 $ 122,500 $ 6,132,000 Reserve For Future Expenditure $ 293,630 $ - $ 293,630 Total Requirements $ 6,303,130 $ 122,500 $ 6,425,630 Exhibit A Q1PW08 - Risk Assessment Corrections -Ash Building Work is needed to bring this building up to code and to prevent accidents.Work includes installation of A/C, updated stairway to comply with code, etc. Fund 1 of 1 FY 2018 Q1 Revised Q Fleet/Property Management Fund Budget Amendment Budget Resources Beginning Fund Balance $ 215,186 $ - $ 215,186 Property Taxes $ - $ - $ - Franchise Fees $ - $ - $ - Special Assessments $ - $ - $ - Licenses &Permits $ - $ - $ - Intergovernmental $ - $ - $ - Charges for Services $ 1,942,585 $ - $ 1,942,585 Fines &Forfeitures $ - $ - $ - Interest Earnings $ 2,000 $ - $ 2,000 Miscellaneous $ 29,686 $ - $ 29,686 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 150,999 $ - $ 150,999 Total Resources $ 2,340,456 $ - $ 2,340,456 Requirements Community Development $ - $ - $ - Community Services $ - $ - $ - Policy and Administration $ 2,180,910 $ 30,000 $ 2,210,910 Public Works $ - $ - $ - Program Expenditures Total $ 2,180,910 $ 30,000 $ 2,210,910 Debt Service $ - $ - $ - Loan to CCDA $ - $ - $ - Work-In-Progress $ - $ - $ - Transfers to Other Funds $ - $ - $ - Contingency $ 75,000 $ (30,000) $ 45,000 Total Budget $ 2,255,910 $ - $ 2,255,910 Reserve For Future Expenditure $ 84,546 $ - $ 84,546 Exhibit A 1PW09 - L C Project-Tigard Access Trails Approved LQC project for Tigard Access Trails. This project will implement the AccessRecreation Guidelines for providing trail information to people with disabilities for Tigard's community parks. FY 2018 Q1 Revised Q General Fund Budget Amendment Budget Resources Beginning Fund Balance $ 14,755,111 $ - $ 14,755,111 Property Taxes $ 15,359,468 $ - $ 15,359,468 Franchise Fees $ 6,238,652 $ - $ 6,238,652 Special Assessments $ _ $ - $ _ Licenses &Permits $ 2,328,630 $ - $ 2,328,630 Intergovernmental $ 6,074,334 $ - $ 6,074,334 Charges for Services $ 2,783,381 $ - $ 2,783,381 Fines & Forfeitures $ 692,476 $ - $ 692,476 Interest Earnings $ 103,722 $ - $ 103,722 Miscellaneous $ 56,432 $ - $ 56,432 Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ _ $ _ $ Total Resources $ 48,392,206 $ - $ 48,392,206 Requirements Community Development $ 3,863,116 $ - $ 3,863,116 Community Services $ 23,905,436 $ - $ 23,905,436 Policy and Administration $ 866,598 $ - $ 866,598 Public Works $ 4,914,851 $ 10,000 $ 4,924,851 Program Expenditures Total $ 33,550,001 $ 10,000 $ 33,560,001 Debt Service $ - $ _ $ Loan to CCDA $ 1,000 $ - $ 1,000 Work-In-Progress $ _ $ _ $ _ Transfers to Other Funds $ 1,913,426 $ - $ 1,913,426 Contingency $ 1,295,000 $ (10,000) $ 1,285,000 Total Budget $ 36,759,427 $ - $ 36,759,427 Reserve For Future Expenditure $ 11,632,779 $ - $ 11,632,779 Total Requirements $ 48,392,206 $ - $ 48,392,206 Exhibit A FTE Changes with No Budget Iml2act Q1CD01 -Increase of 0.25 FTE for the half-time Assistant Planner Use the currently budgeted funds for Temporary Project Planning Assistant position and some additional funds from the consulting budget to add to the half-time (20hr per week)Assistant Planner position to make the Assistant Planner a 30 hour position. The additional hours will allow the Permit Counter to realign priorities and resources in order to keep up with the increased workload. EXHIBIT B Total All Funds FY 2018 Q1 Revised Q1 Total All Funds Budget Amendment Budget Resources Beginning Fund Balance $ 91,752,307 $ 244,000 $ 92,240,307 Property Taxes $ 17,571,473 $ - $ 17,571,473 Franchise Fees $ 6,238,652 $ - $ 6,238,652 Special Assessments $ 60,000 $ - $ 60,000 Licenses &Permits $ 18,305,022 $ - $ 18,305,022 Intergovernmental $ 14,621,867 $ 624,000 $ 16,398,367 Charges for Services $ 38,770,279 $ 240,151 $ 39,250,581 Fines &Forfeitures $ 735,476 $ - $ 735,476 Interest Earnings $ 436,639 $ - $ 436,639 Miscellaneous $ 1,673,556 $ 34,000 $ 1,775,556 Other Financing Sources $ - $ - $ - Transfers In from Other Funds $ 29,744,243 $ 139,500 $ 30,023,243 Total Resources $ 219,909,514 $ 1,281,651 $ 223,035,316 Requirements Community Development $ 6,172,419 $ 265,000 $ 6,967,419 Community Services $ 24,055,436 $ 34,000 $ 24,157,436 Policy and Administration $ 11,857,482 $ 270,151 $ 12,397,784 Public Works $ 21,565,988 $ 10,000 $ 21,595,988 Program Expenditures Total $ 63,651,325 $ 579,151 $ 65,118,627 Debt Service $ 11,665,000 $ - $ 11,665,000 Loan to CCDA $ 1,000 $ 40,000 $ 121,000 Work-In-Progress $ 29,435,973 $ 1,022,000 $ 32,088,473 Transfers to Other Funds $ 29,744,243 $ 139,500 $ 30,023,243 Contingency $ 4,525,000 $ (499,000) $ 3,132,000 Total Budget $ 139,022,541 $ 1,281,651 $ 142,148,343 Reserve For Future Expenditure $ 80,886,973 $ - $ 80,886,973 Total Requirements $ 219,909,514 $ 1,281,651 $ 223,035,316 General Fund FY 2018 Revised Q1 General Fund Budget Q1CD02 Q1CD03 Q1PD01 Q1PD02 Q1PW02 Q1PW09 Budget Resources Beginning Fund Balance $ 14,755,111 $ - $ - $ - $ - $ - $ - $ 14,755,111 Property Taxes $ 15,359,468 $ - $ - $ $ - $ - $ - $ 15,359,468 Franchise Fees $ 6,238,652 $ - $ - $ - $ - $ - $ $ 6,238,652 Special Assessments $ - $ $ $ - $ - $ - $ - $ - Licenses&Permits $ 2,328,630 $ - $ - $ $ - $ - $ $ 2,328,630 Intergovernmental $ 6,074,334 $ - $ - $ - $ - $ - $ - $ 6,074,334 Charges for Services $ 2,783,381 $ $ $ - $ - $ - $ - $ 2,783,381 Fines&Forfeitures $ 692,476 $ $ - $ $ - $ - $ $ 692,476 Interest Earnings $ 103,722 $ - $ - $ - $ - $ - $ $ 103,722 Miscellaneous $ 56,432 $ - $ $ - $ 34,000 $ - $ $ 90,432 Other Financing Sources $ - $ $ - $ - $ - $ - $ - $ - Transfers In from Other Funds $ - $ $ - $ - $ - $ - $ - $ - Total Resources $ 48,392,206 $ - $ - $ - $ 34,000 $ - $ - $ 48,426,206 Requirements Community Development $ 3,863,116 $ (42,500) $ 37,000 $ 228,000 $ - $ - $ $ 4,085,616 Community Services $ 23,905,436 $ - $ - $ - $ 34,000 $ - $ - $ 23,939,436 Policy and Administration $ 866,598 $ - $ - $ - $ - $ - $ $ 866,598 Public Works $ 4,914,851 $ - $ - $ - $ - $ - $ 10,000 $ 4,924,851 Program Expenditures Total $ 33,550,001 $ (42,500) $ 37,000 $ 228,000 $ 34,000 $ - $ 10,000 $ 33,816,501 Debt Service $ - $ - $ - $ - $ - $ $ - $ - Loan to CCDA $ 1,000 $ - $ - $ - $ - $ 40,000 $ - $ 41,000 Work-In-Progress $ - $ - $ - $ - $ - $ - $ - $ - Transfers to Other Funds $ 1,913,426 $ - $ - $ - $ - $ - $ - $ 1,913,426 Contingency $ 1,295,000 $ 42,500 $ (37,000) $ (228,000) $ - $ (40,000) $ (10,000) $ 1,022,500 Total Budget $ 36,759,427 $ - $ - $ - $ 34,000 $ - $ - $ 36,793,427 Reserve For Future Expenditure $ 11,632,779 $ - $ - $ - $ - $ - $ - $ 11,632,779 Total Requirements $ 48,392,206 $ - $ - $ - $ 34,000 $ - $ - $ 48,426,206 Gas Tax Fund FY 2018 Revised Q1 Gas Tax Fund Budget Q1PW07 Budget Resources Beginning Fund Balance $ 2,374,799 $ - $ 2,374,799 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ Special Assessments $ _ $ _ $ - Licenses&Permits $ 68,974 $ - $ 68,974 Intergovernmental $ 3,105,614 $ 95,500 $ 3,201,114 Charges for Services $ - $ _ $ _ Fines&Forfeitures $ - $ _ $ _ Interest Earnings $ 55,732 $ $ 55,732 Miscellaneous $ 62,818 $ - $ 62,818 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 150,000 $ - $ 150,000 Total Resources $ 5,817,937 $ 95,500 $ 5,913 437 Requirements Community Development $ - $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ _ $ $ _ Public Works $ 2,331,702 $ - $ 2,331,702 Program Expenditures Total $ 2,331,702 $ - $ 2,331,702 Debt Service $ 585,000 $ - $ 585,000 Loan to CCDA $ $ _ $ _ Work-In-Progress $ _ $ _ $ - Transfers to Other Funds $ 1,375,987 $ 122,500 $ 1,498,487 Contingency $ 200,000 $ (27,000) $ 173,000 Total Budget $ 4,492,689 $ 95,500 $ 4,588,189 Reserve For Future Expenditure $ 1,325,248 $ - $ 1,325,248 Total Requirements $ 5,817,937 $ 95,500 $ 5,913,437 Transportation CIP Fund FY 2018 Revised Q1 Transportation CIP Fund Budget Q1PW07 Budget Resources Beginning Fund Balance $ 293,630 $ - $ 293,630 Property Taxes $ - $ $ Franchise Fees $ _ $ $ Special Assessments $ _ $ $ Licenses &Permits $ _ $ $ Intergovernmental $ 2110 500 $ - $ 2,110,500 Charges for Services $ - $ _ $ Fines &Forfeitures $ _ $ _ $ Interest Earnings $ _ $ $ Miscellaneous $ 1,378,000 $ - $ 1,378,000 Other Financing Sources $ _ $ _ $ Transfers In from Other Funds $ 2,521,000 $ 122,500 $ 2,643,500 Total Resources $ 6,303,130 $ 122,500 $ 6,425,630 Requirements Community Development $ - $ _ $ Community Services $ _ $ - $ Policy and Administration $ _ $ - $ Public Works $ _ $ $ Program Expenditures Total $ _ $ _ $ Debt Service $ _ $ $ Loan to CCDA $ _ $ $ Work-In-Progress $ 6,009,500 $ 122,500 $ 6,132,000 Transfers to Other Funds $ _ $ _ $ Contingency $ _ $ $ Total Budget $ 6,009,500 $ 122,500 $ 6,132,000 Reserve For Future Expenditure $ 293,630 $ - $ 293,630 Total Requirements $ 6,303,130 $ 122,500 $ 6,425,630 Fleet/PropgM Management Fund FY 2018 Revised Q1 Fleet/Property Management Fund Budget Q1PW08 Budget Resources Beginning Fund Balance $ 215,186 $ - $ 215,186 Property Taxes $ - $ _ $ Franchise Fees $ _ $ _ $ Special Assessments $ _ $ _ $ Licenses &Permits $ _ $ _ $ Intergovernmental $ _ $ _ $ _ Charges for Services $ 1,942,585 $ - $ 1,942,585 Fines &Forfeitures $ _ $ _ $ Interest Earnings $ 2,000 $ - $ 2,000 Miscellaneous $ 29,686 $ - $ 29,686 Other Financing Sources $ _ $ _ $ - Transfers In from Other Funds $ 150,999 $ - $ 150,999 Total Resources $ 2,340,456 $ - $ 2,340,456 Requirements Community Development $ _ $ _ $ _ Community Services $ - $ _ $ - Policy and Administration $ 2,180,910 $ 30,000 $ 2,210,910 Public Works $ _ $ _ $ Program Expenditures Total $ 2,180,910 $ 30,000 $ 2,210,910 Debt Service $ _ $ _ $ Loan to CCDA $ _ $ _ $ Work-In-Progress $ _ $ _ $ Transfers to Other Funds $ _ $ _ $ Contingency $ 75,000 $ (30,000) $ 45,000 Total Budget $ 2,255,910 $ - $ 2,255,910 Reserve For Future Expenditure $ 84,546 $ - $ 84,546 Total Requirements $ 2,340,456 $ - $ 2,340,456 Building Fund FY 2018 Revised Q1 Building Fund Budget Q1CD02 Budget Resources Beginning Fund Balance $ 5,368,306 $ - $ 5,368,306 Property Taxes $ _ $ $ Franchise Fees $ _ $ $ Special Assessments $ - $ _ $ Licenses &Permits $ 3,442,378 $ - $ 3,442,378 Intergovernmental $ 8,281 $ - $ 8,281 Charges for Services $ 7,035 $ - $ 7,035 Fines &Forfeitures $ - $ _ $ Interest Earnings $ 19,782 $ - $ 19,782 Miscellaneous $ 932 $ - $ 932 Other Financing Sources $ _ $ _ $ Transfers In from Other Funds $ 300,000 $ - $ 300,000 Total Resources $ 9,146,714 $ - $ 9,146,714 Requirements Community Development $ 2,309,303 $ 42,500 $ 2,351,803 Community Services $ _ $ - $ Policy and Administration $ _ $ _ $ Public Works $ _ $ $ Program Expenditures Total $ 2,309,303 $ 42,500 $ 2,351,803 Debt Service $ _ $ $ Loan to CCDA $ _ $ $ Work-In-Progress $ _ $ _ $ Transfers to Other Funds $ _ $ _ $ Contingency $ 250,000 $ (42,500) $ 207,500 Total Budget $ 2,559,303 $ - $ 2,559,303 Reserve For Future Expenditure $ 6,587,411 $ - $ 6,587,411 Total Requirements $ 9,146,714 $ - $ 9,146,714 Parks Capital Fund FY 2018 Revised Q1 Parks Capital Fund Budget Q1PW01 Budget Resources Beginning Fund Balance $ 434,066 $ - $ 434,066 Property Taxes $ - $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ - $ _ $ _ Intergovernmental $ 1,513,627 $ - $ 1,513,627 Charges for Services $ - $ _ $ _ Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 3,015 $ - $ 3,015 Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ - Transfers In from Other Funds $ 3,508,372 $ 17,000 $ 3,525,372 Total Resources $ 5,459,080 $ 17,000 $ 5,476,080 Requirements Community Development $ - $ - $ _ Community Services $ - $ - $ _ Policy and Administration $ - $ _ $ _ Public Works $ _ $ - $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ 5,358,627 $ 17,000 $ 5,375,627 Transfers to Other Funds $ - $ - $ _ Contingency $ _ $ - $ _ Total Budget $ 5,358,627 $ 17,000 $ 5,375,627 Reserve For Future Expenditure $ 100,453 $ - $ 100,453 Total Requirements $ 5,459,080 $ 17,000 $ 5,476,080 Parks SDC Fund FY 2018 Revised Q1 Parks SDC Fund Budget Q1PW01 Budget Resources Beginning Fund Balance $ 6,186,941 $ - $ 6,186,941 Property Taxes $ - $ _ $ _ Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ _ Licenses &Permits $ 2,969,431 $ - $ 2,969,431 Intergovernmental $ _ $ _ $ _ Charges for Services $ _ $ _ $ _ Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 19,782 $ - $ 19,782 Miscellaneous $ _ $ _ $ _ Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ _ $ _ $ _ Total Resources $ 9,176,154 $ - $ 9,176,154 Requirements Community Development $ _ $ _ $ _ Community Services $ _ $ _ $ _ Policy and Administration $ _ $ _ $ _ Public Works $ _ $ _ $ _ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ _ $ - Transfers to Other Funds $ 1,616,455 $ 17,000 $ 1,633,455 Contingency $ 80,000 $ (17,000) $ 63,000 Total Budget $ 1,696,455 $ - $ 1,696,455 Reserve For Future Expenditure $ 7,479,699 $ - $ 7,479,699 Total Requirements $ 9,176,154 $ - $ 9,176,154 Sanitary Sewer Fund FY 2018 Revised Q1 Sanitary Sewer Fund Budget Q1PW03 QlPW05 Budget Resources Beginning Fund Balance $ 3,479,552 $ - $ - $ 3,479,552 Property Taxes $ - $ - $ - $ - Franchise Fees $ - $ - $ - $ - Special Assessments $ - $ - $ - $ - Licenses&Permits $ 42,200 $ - $ - $ 42,200 Intergovernmental $ 1,145,000 $ - $ 528,500 $ 1,673,500 Charges for Services $ 2,753,696 $ - $ - $ 2,753,696 Fines&Forfeitures $ - $ - $ - $ - Interest Earnings $ 10,333 $ - $ - $ 10,333 Miscellaneous $ 13,091 $ - $ - $ 13,091 Other Financing Sources $ - $ - $ - $ - Transfers In from Other Funds $ 193,500 $ - $ - $ 193,500 Total Resources $ 7,637,372 $ - $ 528,500 $ 8,165,872 Requirements Community Development $ - $ - $ - $ - Community Services $ - $ $ $ - Policy and Administration $ - $ - $ - $ - Public Works $ 2,471,239 $ - $ $ 2,471,239 Program Expenditures Total $ 2,471,239 $ - $ - $ 2,471,239 Debt Service $ - $ - $ - $ - Loan to CCDA $ - $ - $ - $ - Work-In-Progress $ 2,074,000 $ 15,000 $ 608,500 $ 2,697,500 Transfers to Other Funds $ 593,866 $ - $ - $ 593,866 Contingency $ 400,000 $ (15,000) $ (80,000) $ 305,000 Total Budget $ 5,539,105 $ - $ 528,500 $ 6,067,605 Reserve For Future Expenditure $ 2,098,267 $ - $ - $ 2,098,267 Total Requirements $ 7,637,372 $ - $ 528,500 $ 8,165,872 Stormwater Fund FY 2018 Revised Q1 Stormwater Fund Budget Q1PW03 Budget Resources Beginning Fund Balance $ 4,892,381 $ - $ 4,892,381 Property Taxes $ _ $ $ Franchise Fees $ _ $ $ Special Assessments $ _ $ $ Licenses &Permits $ _ $ $ Intergovernmental $ _ $ $ Charges for Services $ 2,755,890 $ - $ 2,755,890 Fines &Forfeitures $ _ $ $ Interest Earnings $ 7,936 $ - $ 7,936 Miscellaneous $ 3,100 $ - $ 3,100 Other Financing Sources $ _ $ _ $ Transfers In from Other Funds $ 558,000 $ - $ 558,000 Total Resources $ 8,217,307 $ - $ 8,217,307 Requirements Community Development $ _ $ _ $ Community Services $ _ $ $ Policy and Administration $ _ $ _ $ Public Works $ 2,329,116 $ - $ 2,329,116 Program Expenditures Total $ 2,329,116 $ - $ 2,329,116 Debt Service $ _ $ $ Loan to CCDA $ _ $ $ Work-In-Progress $ 1,619,500 $ 15,000 $ 1,634,500 Transfers to Other Funds $ 255,807 $ - $ 255,807 Contingency $ 200,000 $ (15,000) $ 185,000 Total Budget $ 4,404,423 $ - $ 4,404,423 Reserve For Future Expenditure $ 3,812,884 $ - $ 3,812,884 Total Requirements $ 8,217,307 $ - $ 8,217,307 Facilities Capital Projects Fund FY 2018 Revised Q1 Facilities Capital Projects Fund Budget Q1PW04 Budget Resources Beginning Fund Balance $ 860,000 $ 204,000 $ 1,064,000 Property Taxes $ _ $ _ $ _ Franchise Fees $ _ $ _ $ Special Assessments $ _ $ _ $ Licenses &Permits $ _ $ _ $ _ Intergovernmental $ _ $ _ $ Charges for Services $ _ $ _ $ Fines &Forfeitures $ _ $ _ $ Interest Earnings $ 3,212 $ - $ 3,212 Miscellaneous $ _ $ _ $ Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ 100,000 $ - $ 100,000 Total Resources $ 963,212 $ 204,000 $ 1,167,212 Requirements Community Development $ _ $ _ $ _ Community Services $ _ $ _ $ Policy and Administration $ _ $ _ $ Public Works $ _ $ _ $ Program Expenditures Total $ _ $ _ $ _ Debt Service $ _ $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ 100,000 $ 204,000 $ 304,000 Transfers to Other Funds $ _ $ _ $ _ Contingency $ 50,000 $ - $ 50,000 Total Budget $ 150,000 $ 204,000 $ 354,000 Reserve For Future Expenditure $ 813,212 $ - $ 813,212 Total Requirements $ 963,212 $ 204,000 $ 1,167,212 Water Fund FY 2018 Revised Q1 Water Fund Budget Q1PW06 Budget Resources Beginning Fund Balance $ 15,704,833 $ 40,000 $ 15,744,833 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ _ Special Assessments $ _ $ _ $ - Licenses &Permits $ 74,986 $ - $ 74,986 Intergovernmental $ - $ _ $ _ Charges for Services $ 20,496,907 $ - $ 20,496,907 Fines &Forfeitures $ _ $ _ $ _ Interest Earnings $ 30,644 $ - $ 30,644 Miscellaneous $ 10,933 $ - $ 10,933 Other Financing Sources $ - $ _ $ _ Transfers In from Other Funds $ 58,751 $ - $ 58,751 Total Resources $ 36,377,054 $ 40,000 $ 36,417,054 Requirements Community Development $ _ $ _ $ - Community Services $ _ $ _ $ _ Policy and Administration $ - $ _ $ _ Public Works $ 6,898,886 $ - $ 6,898,886 Program Expenditures Total $ 6,898,886 $ - $ 6,898,886 Debt Service $ - $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ - $ 40,000 $ 40,000 Transfers to Other Funds $ 17,457,159 $ - $ 17,457,159 Contingency $ 500,000 $ - $ 500,000 Total Budget $ 24,856,045 $ 40,000 $ 24,896,045 Reserve For Future Expenditure $ 11,521,009 $ - $ 11,521,009 Total Requirements $ 36,377,054 $ 40,000 $ 36,417,054 Central Services Fund FY 2018 Revised Q1 Central Services Fund Budget Q1CM01 Budget Resources Beginning Fund Balance $ 1,030,995 $ - $ 1,030,995 Property Taxes $ _ $ _ $ - Franchise Fees $ _ $ _ $ Special Assessments $ _ $ _ $ - Licenses &Permits $ 37,344 $ - $ 37,344 Intergovernmental $ 45,000 $ - $ 45,000 Charges for Services $ 8,030,785 $ 240,151 $ 8,270,936 Fines &Forfeitures $ - $ _ $ Interest Earnings $ 22,593 $ - $ 22,593 Miscellaneous $ 13,400 $ - $ 13,400 Other Financing Sources $ _ $ _ $ _ Transfers In from Other Funds $ 580,775 $ - $ 580,775 Total Resources $ 9,760,892 $ 240,151 $ 10,001,043 Requirements Community Development $ - $ - $ _ Community Services $ _ $ - $ - Policy and Administration $ 8,760,290 $ 240,151 $ 9,000,441 Public Works $ _ $ _ $ Program Expenditures Total $ 8,760,290 $ 240,151 $ 9,000,441 Debt Service $ _ $ _ $ _ Loan to CCDA $ _ $ _ $ _ Work-In-Progress $ _ $ _ $ _ Transfers to Other Funds $ _ $ _ $ _ Contingency $ 250,000 $ - $ 250,000 Total Budget $ 9,010,290 $ 240,151 $ 9,250,441 Reserve For Future Expenditure $ 750,602 $ - $ 750,602 Total Requirements $ 9,760,892 $ 240,151 $ 10,001,043