CITY OF DOUGLAS BUDGET SUMMARY Expense 2016 Budget GENERAL FUND ADMIN $ ECONOMIC DEV $ VISITOR CENTER $ PARKING LOT $ FINANCE $ HUMAN RESOURCES $ MIS $ GEN GOVT $ MAGISTRATE $ LIBRARY $ COM DEV $ CEMETERY $ PARKS $ RECREATION $ AQUATICS $ PW ADMIN $ PW CONSTRUCTION - FACILITIES MAINT $ P. W. FLEET MAINT $ FIRE $ EMS $ POLICE ADMIN $ POLICE OPER $ POLICE SUP $ POLICE HUMANE $ CALL CENTER $ GENERAL FUND CAPITAL $ MATCHING FUNDS (GRANTS) $ GENERAL FUND $ Net Rev. vs. Exp. $ Expense 2017Budget 481,769 70,872 554,346 529,987 419,132 2,475,985 77,568 415,633 154,914 553,816 93,135 306,374 157,227 421,724 161,730 1,311,189 1,482,026 617,735 2,849,411 2,019,274 211,047 65,057 80,000 15,509,950 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2016-2017 Difference 482,327 68,211 63,925 517,123 513,988 439,745 1,787,051 414,072 137,776 515,280 178,871 282,917 131,721 399,277 125,886 1,354,020 1,635,083 472,434 3,122,745 1,866,068 215,693 48,516 234,700 $ 15,007,430 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 558 68,211 (6,947) (37,223) (15,998) 20,613 (688,934) (77,568) (1,561) (17,137) (38,536) 85,736 (23,457) (25,506) (22,446) (35,845) 42,831 153,057 (145,301) 273,333 (153,206) 4,646 (16,541) (80,000) - $ (737,221) 2017 2016 Budgeted 2017 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp 0.12% 0.00% -9.80% 0.00% -6.71% -3.02% 4.92% -27.82% -100.00% -0.38% 0.00% -11.06% -6.96% 92.06% -7.66% -16.22% -5.32% -22.16% 3.27% 10.33% -23.52% 9.59% -7.59% 2.20% -25.43% -100.00% -3.24% $ 15,509,950 $ 15,007,429 $ (0) (0) - GF Reserve $ - $ (0) 0 7/21/2016 1:23 PM BUD17 FINAL Section 1 - Page 1 CITY OF DOUGLAS BUDGET SUMMARY 2016 Budget 2017 2017 2016 Budgeted 2017 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp 2016-2017 Difference 2017 Budget H. U. R. F. $ 1,307,411 $ 1,961,700 $ 654,289 50.04% $ 1,307,411 $ 1,311,700 $ (650,000) TRANSIT TRANSIT BISBEE TRANSIT TOTAL $ $ $ 930,670 930,670 $ $ $ 885,094 115,637 1,000,731 $ $ $ (45,576) 115,637 70,060 -4.90% 100.00% 7.53% $ 930,670 $ 979,728 $ (21,003) LTAF $ - $ - $ - 0.00% $ - $ - $ CAPITAL PROJECTS $ 472,121 $ 650,000 $ 177,879 37.68% $ 89,167 $ - $ DEBT SERVICE FUND $ 1,315,624 $ 1,303,560 $ (12,064) -0.92% $ 1,315,624 $ 1,303,560 $ - MPC FUND $ - $ - $ - 0.00% $ - $ - $ - RICO $ 175,450 $ 203,276 $ 27,826 15.86% $ 175,450 $ 203,276 $ - JCEF $ 19,292 $ 30,000 $ 10,708 55.50% $ 8,150 $ - $ (30,000) GRANTS $ 2,516,285 $ 2,274,369 $ (241,916) 2,486,285 $ 2,267,869 $ (6,500) HOUSING $ 236,288 $ 171,915 $ (64,373) TOTAL SPECIAL REVENUE FUNDS $ 6,973,142 $ 7,595,551 $ SANITATION $ 1,202,700 $ 2,017,721 WATER WATER OFFICE WATER FIELD WATER CAPITAL REINVESTMENT WATER TOTAL $ $ $ $ 244,910 1,418,418 442,337 2,105,666 $ $ $ $ WASTE WATER SEWER CAPITAL REINVESTMENT SEWER TOTAL $ $ $ 1,647,545 1,312,455 2,960,000 AIRPORT* $ GOLF COURSE ** LOUNGE -9.61% (650,000) -27.24% $ 236,288 $ 171,915 $ (0) 622,410 8.93% $ 6,549,046 $ 6,238,048 $ (1,357,504) $ 815,021 67.77% $ 1,202,700 $ 1,214,500 $ (803,221) 245,971 1,566,029 210,000 2,022,000 $ $ $ $ 1,061 147,610 (232,337) (83,665) 0.43% 10.41% -52.52% -3.97% $ 2,105,666 $ 2,022,000 $ (0) $ $ $ 1,780,500 285,000 2,065,500 $ 132,955 $ (1,027,455) $ (894,500) 8.07% -78.28% -30.22% $ 2,960,000 $ 2,065,500 $ (0) 159,762 $ 147,093 $ (12,669) -7.93% $ 159,762 $ 147,093 $ - $ $ $ - $ $ $ 93,938 71,062 165,000 $ 165,000 0.00% $ - $ 165,000 $ - TOTAL ENTERPRISE FUNDS $ 6,428,128 $ 6,417,314 $ (10,813) -0.17% $ 6,428,128 $ 5,614,093 $ (803,221) GRAND TOTALS $ 28,911,220 $ 29,020,295 $ (125,625) -0.43% $ 28,487,124 $ 26,859,570 $ (2,160,725) * Airport is being subsidized $51,293 by the General Fund ** Golf Course is being subsidized $165,000 by the General Fund 7/21/2016 1:23 PM BUD17 FINAL Section 1 - Page 2 REVENUE BUDGET 2016 - 2017 GENERAL FUND Account 31100 31102 31301 31301 31302 31801 31802 31803 32101 32102 32103 32104 32201 32202 32301 32302 32303 33111 33211 33211 33211 33501 33502 33503 33704 33705 33705 34101 34102 34103 34104 34106 34107 34108 34109 34110 34501 34502 34503 34701 34702 34703 34704 34705 34706 34707 34720 34721 Description PROPERTY TAX-CURRENT PROPERTY TAX-DELINQ. CITY SALES TAX / USE TAX SALES TAX-CITY $ TRANSIENT OCCUPANCY TAX FRANCHISE-ELECTRIC FRANCHISE-GAS FRANCHISE-CABLE BUSINESS LICENSES LIQUOR LICENSES OPERATOR/VEH. PERMITS YARD/SIDEWALK SALES PERMIT BUILDING PERMITS ZONING FEES & PERMITS DOG LICENSES BURNING PERMITS ALARM PERMITS POLICE OPER. REIMB. GRANT ADM REIMB 1 LIBRARY GRANT BTOP 2 TRANSIT GRANT REIMB TRANSIT PARTNERSHIPS STATE SHARED SALES TAX STATE URBAN REV SHARING VEHICLE LICENSE TAX HUMANE COUNTY IGA HOUSING IGA CASAS & PIONEER DUSD IGA $ PARKING LOT FEES CEMETERY FEES DOUGLAS PROMO SALES ANIMAL SHELTER REVENUE IMPOUND FEES IMPOUND ADM FEES FINGERPRINTS TRANSIT FARES PASSPORT FEES AMBULANCE FEES COMMUNITY TRAINING FIRE RESPONSE REIMB TRAINING REIMB AQUATIC CENTER FEES 8TH STREET POOL FEES AQUATIC CONCESSIONS AQUATIC PRO SHOP SALES RACQUETBALL COURT FEES AQUATIC CENTER EVENT FEES AQUATIC LOCKER RENTALS RECREATION PROGRAM FEES BASKETBALL LEAGUE FEES 2013 Actual 2014 Actual 2015 Actual 2016 10-month Actual 2016 Budget 528,103 28,354 3,811,528 952,502 39,480 179,761 85,955 48,365 85,701 10,750 2,935 3,920 52,890 1,395 3,645 225 1,110 858,200 0 26,912 213,476 0 1,419,048 1,775,125 757,402 43,162 98,539 19,646 71,293 0 6,060 19,200 2,800 1,349 25,408 544,964 33,487 3,914,860 979,280 38,967 177,617 83,981 49,421 86,394 8,775 1,860 3,630 94,473 1,200 3,705 170 1,020 837,448 10,425 0 343,304 544,019 $ 34,686 3,984,724 961,492 $ 47,018 174,232 93,648 49,730 83,035 9,450 450 3,195 63,174 1,230 3,370 80 1,020 709,134 22,364 0 298,145 1,545,589 1,976,038 736,085 41,950 94,723 42,865 0 82,913 600 5,140 19,650 5,000 1,276 37,290 1,600,126 2,119,573 776,774 40,418 87,061 18,360 $ 0 82,187 2,019 8,111 16,200 5,150 1,395 35,288 530,000 30,000 4,445,833 999,980 40,000 190,000 85,000 48,000 88,000 10,000 4,000 70,000 2,000 4,000 250 1,000 1,066,623 1,672,689 2,108,081 840,934 47,400 59,374 70,000 8,000 21,000 5,200 1,400 - 895,111 13,905 7,765 1,069,174 7,220 0 1,225,314 9,605 6,660 1,100,000 7,000 2,000 17,762 5,818 21 1,845 691 16,776 3,322 5,356 0 15,546 7,036 685 885 578 16,323 3,975 6,421 0 11,942 4,824 1,906 551 1,174 18,404 3,140 8,613 0 18,000 5,000 100 2,000 1,000 7,000 2,000 2,000 $ $ $ 345,028 47,938 4,076,182 246,879 40,594 136,810 71,592 24,710 66,680 6,425 525 2,235 55,215 1,501 3,295 130 1,140 477,985 4,496 1,227,553 1,756,734 637,829 25,019 33 82,003 99 7,180 14,827 5,350 1,495 3,576 1,187,068 8,560 40,356 9,203 3,213 800 242 492 3,435 569 530 - 2017 Projected $ $ $ 540,000 30,000 5,445,813 45,000 190,000 85,000 48,000 88,000 10,000 4,000 70,000 2,000 4,000 250 1,000 1,087,023 1,562,733 2,031,209 841,255 40,200 61,880 75,000 8,000 21,000 5,200 1,400 5,000 1,300,000 11,000 2,000 15,000 18,000 5,000 100 2,000 1,000 7,000 2,000 2,000 2017 % Change 1.89% 0.00% 22.49% -100.00% 12.50% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1.91% 0.00% 0.00% 0.00% 0.00% -6.57% -3.65% 0.04% -15.19% 4.22% 0.00% 0.00% 7.14% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% 18.18% 57.14% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 3 REVENUE BUDGET 2016 - 2017 GENERAL FUND (Continued) Account 34730 34750 34751 35101 35102 35103 35104 35201 36101 36201 36202 36211 36401 36403 36406 36407 36431 38001 38001 38201 38202 39103 39104 39110 39112 39113 39301 Description 2013 Actual RAMADA RESERVATION FEES 1,720 DUSD AQUATIC CENTER REIMB 56,959 DUSD RECREATION REIMB 0 COUNTY REIMB FOR LIBRARY COURT FINES & FORFEITURES 150,048 RESTITUTION PAYMENTS 1,001 LIBRARY FINES & FEES 18,443 COURT FINE OFFICER SA 6,832 FORFEITED PROPERTY SALE 89,664 INVESTMENT EARNINGS 27,007 RENTAL PAYMENTS 26,221 CALL CENTER Lease 715,478 VISITOR CENTER RESV FEES 2,290 SPECIAL EVENTS REVENUE 2,431 4TH OF JULY REVENUE 50 YOUTH ACTIVITY REVENUE 0 DONATIONS/MISC 551 LIBRARY GRANT E-RATE 62,130 MISCELLANEOUS REVENUE 50,701 1 CASH OVER/SHORT -327 SALE SURPLUS PROPERTY/LAND 356,860 EXPLORER REVENUE 0 TRANSFER FROM LTAF 0 TRANSFER FROM SPECIAL PROJECTS 0 TRANSFER FROM ENTERPRISE FUNDS 201,283 TRANSFER FROM GRANTS 200,655 TRANSFER FROM COURTS - Reimb 0 TRANSFER FROM RICO CAPITAL LEASE PROCEEDS 1,205,910 TOTAL REVENUE $ 15,318,515 2014 Actual 2015 Actual 1,735 60,734 0 1,630 46,902 0 137,124 828 16,094 5,819 145,965 11,691 99,444 692,372 2,120 2,059 150 0 12 65,313 102,641 -32 297,088 669 0 0 237,393 0 0 112,957 1,113 14,661 4,726 22,590 10,225 123,331 669,266 890 1,708 20 0 136,881 33,877 271,047 -181 20,480 895 0 0 211,004 0 0 2016 Budget 2,000 66,387 20,000 135,000 1,500 17,000 5,000 80,000 6,400 118,516 669,266 1,000 2,000 500 1,000 33,093 50,000 510,000 1,000 195,424 1,041,474 - - $ 15,852,635 $ 14,853,010 $ 15,509,950 2016 10-month Actual 2017 Projected 1,120 66,387 93,012 211 12,681 3,651 78,575 10,328 95,282 501,950 1,080 1,220 631 25,049 59,801 48 150,560 68 - 125,000 0.00% -50.12% 0.00% -100.00% -100.00% 0.00% -11.76% 0.00% 0.00% 56.25% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 4.27% 0.00% 0.00% -98.04% 0.00% 0.00% 0.00% -7.91% 0.00% 0.00% 0.00% 0.00% $ 11,892,747 $ 15,007,429 -3.24% 165,566 - 2,000 33,111 2017 % Change 1,500 15,000 5,000 80,000 10,000 118,516 669,266 1,000 2,000 500 1,000 34,507 50,000 10,000 1,000 179,967 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 4 REVENUE BUDGET 2016 - 2017 HIGHWAY USER REVENUE FUND Account 33504 38001 38002 38003 39101 39103 39104 Description 2013 Actual HIGHWAY USERS - STATE MISCELLANEOUS SALES REIMBURSEMENT CITIZEN PAYS POLICY TRANSFER FROM GENERAL FUND TRANSFER FROM LTAF TRANSFER FROM SP PROJECTS 1,103,680 15 17,230 211,937 - TOTAL REVENUE 1,332,862 $ 2014 Actual 2015 Actual 1,159,673 1,085 56,100 2,548 $ 1,219,406 $ 2016 10-month Actual 2016 Budget 1,235,743 30,240 911 4,186 - $ 1,271,080 $ 1,272,411 30,000 5,000 - $ 1,307,411 2017 Projected 921,094 21,700 8,937 12,581 - $ $ 964,312 $ 2017 % Change 1,276,700 30,000 5,000 - 0.34% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1,311,700 0.33% 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 5 REVENUE BUDGET 2016 - 2017 TRANSIT Account 33200 33211 33702 33706 33707 34109 34111 38008 39101 Description 2013 Actual 2014 Actual 2015 Actual GRANTS TRANSIT GRANT REVENUE COCHISE COLLEGE IGA SEAGO BISBEE CONTRACT TRANSIT FARES 2016 Budget - TOTAL REVENUE - $ $ - - 2017 % Change 20,000 638,829 18,000 33,650 40,000 10,000 15,840 154,351 $ 185,430 11,388 28,042 116,365 16,483 10,329 - $ 65,000 585,807 20,000 38,000 209,271 36,000 10,000 15,650 - 225.00% -8.30% 11.11% 12.93% 100.00% -10.00% 0.00% -1.20% -100.00% $ 930,670 $ 368,037 $ 979,728 5.27% $ 2017 Projected $ ADVERTISING REVENUE ACT ROUTE TRANSFER FROM GENERAL FUND 2016 10-month Actual 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 6 REVENUE BUDGET 2016 - 2017 LOCAL TRANSPORTATION ASSIST. (LOTTERY) Account 33505 Description 2013 Actual LOTTERY LTAF II GRANT TOTAL REVENUE 2014 Actual - $ - 2015 Actual - $ - $ 2016 10-month Actual 2016 Budget 2017 Projected 2017 % Change - $ - $ - $ - 0.00% 0.00% - $ - $ - $ - 0.00% 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 7 REVENUE BUDGET 2016 - 2017 CAPITAL PROJECTS Account 36104 31301 36101 36102 36201 38001 38007 38008 38201 38201 39101 39114 39301 39302 Description 2013 Actual INT-GOLF COURSE DEV 1 1/3 Cent Sales Tax (Capital) INVESTMENT EARNINGS INVEST EARN - CALL CENTER RENTAL PAYMENTS (uofa) MISCELLANEOUS 3rd Street Project Revenue VENDING MACHINE PROCEEDS SALE SURPLUS PROPERTY / LAND SALE SURPLUS PROPERTY / LAND TRANSFER FROM GF TRANSFER FROM DEBT FUND CAPITAL LEASE PROCEEDS GOV'T PLAZA FINANCING TOTAL REVENUE $ 2014 Actual 12,295 63,619 - 481,015 12,458 20,254 600,000 31,757 75,915 2015 Actual 587,270 13,179 176,998 304,077 - $ 1,145,484 $ 1,081,524 2016 10-month Actual 2016 Budget $ $ 89,167 $ 2017 Projected 145,715 2,096 - 6,000 - 5,639 - 89,167 $ 159,449 - - 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - -100.00% - - $ 2017 % Change $ 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 8 REVENUE BUDGET 2016 - 2017 DEBT SERVICE FUND Account 31301 36101 39101 39104 39110 Description 2013 Actual 1 1/3 Cent Sales Tax (call center IT) INVESTMENT EARNINGS TRANSFER FROM GENERAL FUND TRANSFER FROM CAPITAL TRANSFER FROM ENTERPRISE TOTAL REVENUE $ 2014 Actual 560,802 777 1,147,062 64,099 8,699 1,781,439 2015 Actual 96,100 390 1,357,254 88,312 $ 1,542,056 2016 Budget $ 1,280,066 82,057 $ 1,362,123 2016 10-month Actual 1,233,567 $ 82,057 $ 1,315,624 $ 2017 Projected 631 999,937 68,381 $ 1,068,948 $ 1,221,503 2017 % Change 82,057 0.00% 0.00% -0.98% 0.00% 0.00% 1,303,560 -0.92% 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 9 REVENUE BUDGET 2016 - 2017 MPC Account 39101 39102 39104 Description 2013 Actual TRANSFER FROM GF TRANSFER FROM HURF TRANSFER FROM SPEC PROJECTS 325,691 160,415 - TOTAL REVENUE 486,106 $ 2014 Actual 2015 Actual 326,160 160,646 $ 486,806 $ 2016 10-month Actual 2016 Budget 2017 Projected 2017 % Change 325,922 160,529 - $ - $ - $ - 0.00% 0.00% 0.00% 486,450 $ - $ - $ - 0.00% 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 10 REVENUE BUDGET 2016 - 2017 RICO Account 33241 33242 33243 36106 39101 39112 Description 2013 Actual RICO-ST ATTY GENERAL RICO-COUNTY ATTY RICO-COUNTY ATTY-TOWING INTEREST RICO TRANSFER FROM GF TRANSFER FROM GRANTS $ TOTAL REVENUE $ 2014 Actual 147,624 77,322 2,878 - $ 227,824 $ 2015 Actual 232,894 34,731 4,725 - $ 272,351 $ 2016 10-month Actual 2016 Budget 98,694 1,185 2,928 - $ 102,807 $ 175,450 - $ 175,450 2017 Projected 31,640 6,000 $ $ 37,640 $ 2017 % Change 203,276 - - 15.86% 0.00% 0.00% 0.00% 0.00% 0.00% 203,276 15.86% 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 11 REVENUE BUDGET 2016 - 2017 JCEF Account 35104 35105 35110 Description 2013 Actual LOCAL JCEF TIME PAYMENTS FILL THE GAP RESTRICTED TRANSFER FROM GF MCEF SUSPENSION FEE TOTAL REVENUE $ 2014 Actual 2015 Actual 6,964 523 5,545 - 4,824 - - 75 - 7,487 $ 5,620 $ 4,824 2016 10-month Actual 2016 Budget $ $ 7,000 1,000 150 $ 8,150 $ 2017 Projected 3,443 1,170 87 $ 4,700 $ 2017 % Change - -100.00% -100.00% 0.00% -100.00% - -100.00% 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 12 REVENUE BUDGET 2016 - 2017 GRANTS Account Description 2013 Actual HOUSING & COMM DEVELOPMENT FIRE POLICE PUBLIC WORKS LIBRARY TRANSFER FROM GENERAL FUND TRANSFER FROM HURF TRANSFER FROM CAPITAL PROJ TRANSFER FROM AIRPORT 186,434 3,859 50,817 383,953 1,060 62,703 74,651 - TOTAL REVENUE 763,477 $ 2014 Actual 2015 Actual 144,334 4,988 151,899 166,042 11,932 153,371 $ 632,565 $ 2016 10-month Actual 2016 Budget 881,673 62,087 71,417 7,652 46,530 16,410 - $ 1,085,770 $ 1,309,212 73,789 174,200 850,000 77,500 1,584 $ 2,486,285 2017 Projected 16,488 17,148 3,150 $ 1,309,212 371,436 78,421 450,000 52,500 6,300 0.00% 403.38% -54.98% -47.06% -32.26% 297.61% 0.00% 0.00% 0.00% $ 2,267,869 -8.78% $ 36,787 2017 % Change 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 13 REVENUE BUDGET 2016 - 2017 HOUSING Account 33212 33701 33703 38008 39101 39112 Description 2013 Actual HOUSING REIMB $ COUNTY/HOUSING IGA CASAS PIONEER REIMB SUN RAY APT REIMB TRANSFER FROM GF (Lead) TRANSFER FROM GF (TRANSIT) TRANFER FROM GRANTS 287,404 - TOTAL REVENUE 356,719 $ 2014 Actual $ 45,780 23,535 2015 Actual 302,629 - $ $ 302,629 340,764 - 2016 Budget $ $ 340,764 2016 10-month Actual 236,288 - $ $ 236,288 $ 2017 Projected 171,868 2,017 - $ 173,886 $ 2017 % Change 171,915 - - -27.24% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 171,915 -27.24% 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 14 REVENUE BUDGET 2016 - 2017 SANITATION Account 31301 34603 36101 38001 38201 39104 39301 Description 2013 Actual 2014 Actual 2015 Actual 2016 10-month Actual 2016 Budget 2017 Projected 2017 % Change SALES TAX - CITY SUBSIDY GARBAGE COLLECTION FEE INVESTMENT EARNINGS MISCELLANEOUS SALE SURPLUS PROPERTY TRANSFER-SPEC PROJ CAPITAL LEASE PROCEEDS $ - $ 1,205,675 3,383 (834) - 1,202,756 2,460 51 - $ 1,211,989 3,107 101 - $ 1,200,000 2,700 - $ 1,005,931 4,182 104 - $ 1,210,000 4,500 - 0.00% 0.83% 66.67% 0.00% 0.00% 0.00% 0.00% TOTAL REVENUE $ 1,208,225 1,205,266 $ 1,215,196 $ 1,202,700 $ 1,010,217 $ 1,214,500 0.98% $ 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 15 REVENUE BUDGET 2016 - 2017 WATER FUND Account 33201 33301 34601 34601 34601 34601 34601 36101 37001 38001 38001 38005 38006 39110 Description 2013 Actual GRANT REIMBURSEMENT NAD BANK WATER SERVICE FEES WATER USAGE FEES 1 CIP SURCHARGE 2 IMPACT FEE 3 RECONNECT FEE 4 CONTRACT FEE INVESTMENT EARNINGS WIFA Study Grant MISCELLANEOUS 1 CASH OVER/SHORT NPF XII BOND PROCEEDS WIFA Water Loan Proceeds TRANSFER FROM ENTERPRISE TOTAL REVENUE 2014 Actual 19,578 211 1,635,925 1,626,990 328,665 7,980 327,703 44,800 15,828 6,325 53,296 (113) $ 2,067,694 2015 Actual 2016 Budget 1,549,369 1,635,000 328,246 10,500 4,482 2,475 8,027 84,303 (66) - 8,212 1,320 70,734 104 $ 2,079,864 $ 1,987,335 2016 10-month Actual 1,263,010 273,520 25,200 21,046 9,690 10,404 25,520 (164) - 330,000 20,000 21,000 13,000 7,000 21,000 58,666 $ 2,105,666 2017 Projected $ 1,628,226 2017 % Change 910,000 690,000 330,000 20,000 25,000 12,000 12,000 - 0.00% 0.00% -44.34% 100.00% 0.00% 0.00% 19.05% -7.69% 71.43% 0.00% 9.52% 0.00% 0.00% 0.00% -100.00% 2,022,000 -3.97% 23,000 $ 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 16 REVENUE BUDGET 2016 - 2017 WASTE WATER FUND Account 33301 34602 34602 1 36101 38001 38006 39101 39107 Description 2013 Actual NAD BANK GRANT SEWER SERVICE FEES CIP SURCHARGE IMPACT FEE CHANGE INVESTMENT EARNINGS MISCELLANEOUS WIFA WW Loan Proceeds BECC Grant TRANSFER FROM GEN FUND TRANSFER FROM WATER TOTAL REVENUE $ 2014 Actual 2015 Actual 1,660 1,486,503 327,966 6,800 4,259 14,502 - 1,487,530 328,757 59,935 11,405 4,184 - 1,502,065 331,036 14,088 7,098 5,307 - - - - 1,841,690 $ 1,891,810 $ 1,859,593 2016 10-month Actual 2016 Budget 1,253,794 276,473 34,475 7,221 60,585 1,157,857 1,500,000 328,000 20,000 8,000 4,000 550,000 550,000 2,960,000 $ 2,790,404 2017 % Change - 0.00% 0.13% 0.61% 0.00% 6.25% 25.00% -63.64% -100.00% 0.00% 0.00% 2,065,500 -30.22% 1,502,000 330,000 20,000 8,500 5,000 200,000 0 - $ 2017 Projected $ 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 17 REVENUE BUDGET 2016 - 2017 AIRPORT FUND Account 33221 34880 34880 36201 36201 36201 38001 39103 39104 39299 39300 Description 2013 Actual 2014 Actual FEDERAL GRANTS 7,377 FUEL SALES (100 LL) 32,126 FUEL SALES (JET A) 47,200 RENTAL PAYMENTS 9,769 5 SMALL HANGAR 14,400 10 TRAILER RENT 2,550 MISCELLANEOUS REVENUE 12,722 TRANSFER FROM LTAF TRANSFER FROM GENERAL FUND 22,265 FBO LEASE PAYMENT CATHOLIC COMMUNITY SERVICES LEASE PAYMENT 1 2 TOTAL REVENUE $ 148,409 $ 2015 Actual 14,108 23,718 77,611 8,170 14,980 4,056 15,933 158,576 2016 Budget 840 22,448 64,854 7,455 14,700 4,067 80 15,996 $ 130,441 2016 10-month Actual $ 21,960 51,600 8,500 14,700 2,700 60,302 $ 159,762 $ 2017 Projected 48,420 10,908 42,130 7,325 12,398 3,972 121 8,987 134,261 51,293 - 0.00% -16.67% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -14.94% 0.00% 0.00% 0.00% 147,093 -7.93% 18,300 51,600 8,500 14,700 2,700 $ 2017 % Change 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 18 REVENUE BUDGET 2016 - 2017 GOLF COURSE Account 6001 6002 6004 6011 6012 6013 6014 6021 6022 6023 6024 6025 6031 6032 6040 6045 6046 6047 6048 36201 36203 38001 38001 39101 39301 Description 2013 Actual GREEN FEES TRAIL FEES TOURNAMENT FEES QTR PASS-INDIVIDUAL QTR PASS-FAMILY QTR PASS-STUDENT PUNCH PASS LOCKER RENTALS PUBLIC CART RENTALS PRIVATE CART RENTALS RANGE BALL RENTAL GOLF CLINICS PRO SHOP SALES PRO SHOP FOOD & DRINK RV PARK SPACE RENTALS COUNTRY CLUB EVENTS BEVERAGE SALES FOOD SALES TIPS CREDIT CARD COUNTRY CLUB RENT LEASE PAYMENTS MISCELLANEOUS 1 cash over/short 27,250 667 4,656 7,505 330 17,570 1,777 20,860 12,495 4,603 234 12,358 3,073 32,760 10,547 68,830 22,260 3,155 (45) SUBSIDY FROM GEN FUND CAPITAL LEASE PROCEED TOTAL REVENUE 2014 Actual $ 2015 Actual 2016 Budget 1,762 315 317 30 252,648 180,432 190,263 - 37,141 - 318,755 - 174,665 - 133,190 - - - 165,000 - 0.00% 0.00% 165,000 0.00% 355,127 $ 323,454 - $ - $ - 9,093 938 1,508 2,385 145 945 1,946 723 1,008 840 1,835 15,292 484 - $ 2017 % Change 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ $ 2017 Projected 26,366 374 4,187 6,648 338 17,865 931 12,706 7,455 3,263 6,184 1,458 23,890 12,695 64,031 49 1,312 512 0 571,718 23,202 1,384 3,878 5,974 478 16,480 1,862 14,199 9,011 3,850 115 7,811 2,880 27,983 6,805 51,563 61 653 1,925 2016 10-month Actual - - $ 37,141 - $ 7/21/2016 1:23 PM BUD17 FINAL Section 2 - Page 19 GENERAL FUND ADMINISTRATION 001-51001-413 Account Description 2013 Actual 2014 Actual 2015 Actual Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2016 Salaries Sal - Temp Sal - Limited Sal - Overtime OASI State Retire Health Ins Income Protect State Comp Self Fund Ins Claims 384,587 1,527 28,088 42,052 7,415 1,485 829 25,195 375,777 0 0 4,008 26,818 41,295 7,336 1,424 894 29,712 357,389 $ 344,186 0 0 2,326 26,044 26,330 41,293 39,065 6,398 5,256 829 980 774 750 21,267 23,261 $268,833 44 382 922 19,086 30,323 3,979 683 598 13,739 $ 341,519 5,023 26,511 39,298 4,863 1,098 624 21,451 -0.77% 100.00% 0.00% 0.00% 0.68% 0.60% -7.48% 12.06% -16.84% -7.78% ####### $ 439,829 $ 338,589 $ 440,387 0.13% 3,000 4,750 1,000 1,500 5,000 12,000 6,670 500 6,820 700 3,132 3,911 505 282 5,680 15,486 5,704 317 794 231 3,000 4,750 1,000 1,500 5,000 12,000 6,670 500 6,820 700 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ 41,940 $ 36,041 $ 41,940 0.00% ####### $ 481,769 $ 374,630 $ 482,327 0.12% Personnel Expense Operating Expense 3001 4104 4301 4303 5401 5801 6001 6201 6401 6501 Contractual serv Telephone Services Auto & Eq Maintenance Computer Maintenance Adv/Printing/Reproduction Travel/training Office supplies Postage Books/Dues/Subscrip Gas/Oil/Lube $ 491,178 3,948 14,523 15,175 7,770 337 1,633 1,529 $ 487,263 3,983 0 978 0 9,523 16,780 6,187 243 340 379 Operating Expense $ 44,915 $ 38,414 Total Expenses $ 536,093 $ 525,677 3,592 4,465 280 2,400 6,794 22,875 6,287 272 1,449 210 $ 48,625 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change CAPITAL OUTLAY 2017 2017 Requested Approved* City Website Development & Design 20,000 20,000 Total $ 20,000 $ 20,000 Item 0 BUD17 FINAL Section 3 - Page 1 *Budgeted in Capital Projects 7/21/2016 1:23 PM GENERAL FUND ECONOMIC DEVELOPMENT 001-51003-465 Account Description Personnel Expense 1001 1005 2001 2002 2004 2005 2006 Salaries Salaries/OT OASI State Retire Health Ins Income Protect Workman's Comp Personnel Expense Operating Expense 3001 4301 5801 6001 6201 6401 6501 8009 2013 Actual 2014 Actual $ Contractual Auto/equip Travel/training Office supplies Postage Books/dues/subscrip Gas/oil/lube Marketing/Promotions - 2015 Actual $ - $ 2016 2016 YTD 2017 2017 Budget 4/30/2016 Requested % Change - $ - $ - $ 51,876 3,968 5,883 151 216 116 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - $ - $ - $ 62,211 0.00% - 2,000 500 2,000 1,000 500 2,000 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 12,500 - - 2,513 7,103 2,000 Operating Expense $ 15,013 $ 7,103 $ 2,000 $ - $ 2,000 $ 6,000 0.00% Total Expenses $ 15,013 $ 7,103 $ 2,000 $ - $ 2,000 $ 68,211 0.00% CAPITAL OUTLAY BUD17 FINAL Items 2017 2017 Requested Approved* *Budgeted in GF Department 1801 Total $ - $ - Section 3 - Page 2 7/21/2016 1:23 PM GENERAL FUND VISITOR CENTER 001-51005-419 Account Description 2013 Actual Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2016 Salaries Sal - Temp Sal - Limited Sal - Overtime OASI State Retire Health Ins Income Protect State Comp Self Fund Ins Claims 26,687 1,313 2,146 2,964 1,482 130 77 2,280 Personnel Expense Operating Expense 3001 4104 4105 4302 4303 5801 6001 6014 6015 6201 6401 6601 8009 2014 Actual 2015 Actual 20,407 2,670 0 141 1,781 2,396 701 109 145 1,402 21,305 2,917 298 20 1,882 2,386 1,389 75 107 1,018 2016 Budget 17,004 2,000 1,454 1,930 1,134 67 43 1,573 2016 YTD 2017 2017 4/30/2016 Requested % Change 18,277 1,039 378 1,496 1,654 915 59 138 1,005 14,910 2,000 1,294 1,691 165 62 32 4,305 -12.31% 0.00% 0.00% 0.00% -11.02% -12.39% -85.46% -7.89% -25.80% 173.61% $ 37,078 $ 29,752 $ 31,397 $ 25,205 $ 24,962 $ 24,458 -2.96% 9,268 209 2,347 179 89 13,917 1,526 7,957 6,588 4,499 909 2,325 242 13,917 7,285 8,001 406 5,536 1,097 305 1,552 153 13,917 2,842 8,550 450 7,600 1,500 250 600 2,500 200 13,917 100 10,000 3,513 372 5,460 4,793 138 221 149 10,438 1,051 2,350 450 7,600 1,500 250 600 2,500 200 13,917 100 10,000 -72.51% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 35,774 $ 43,722 $ 33,809 $ 45,667 $ 26,134 $ 39,467 -13.58% Total Expense $ 72,852 $ 73,474 $ 65,206 $ 70,872 $ 51,096 $ 63,925 -9.80% Contractual serv Telephone Services Utilities Building Maintenance Computer Maintenance Travel/training Office supplies Museum Collections Museum ProShop Postage Books/Dues/Subscrip Uniforms Marketing/Promotions 7,390 848 CAPITAL OUTLAY Item 0 0 Total BUD17 FINAL 2017 2017 Requested Approved* *Budgeted in Capital Projects $ - $ - Section 3 - Page 3 7/21/2016 1:23 PM GENERAL FUND PARKING LOT 001-51007-419 Account Description Personnel Expense 1003 2001 2002 2005 2006 Sal - Temp OASI State Retirement Inc Protection State Comp Personnel Expense Operating Expense 3001 4105 4302 6001 6601 2013 Actual 2015 Actual 2016 2016 YTD 2017 2017 Budget 4/30/2016 Requested % Change 27,242 2,084 2,128 27 61 $ 31,542 Contractual Services Utilities Building Maintenance Office supplies Uniforms $ 135 1748 216 46 71 Operating Expense Total Expense 2014 Actual $ 884 95 $2,216 $ 33,757 - $ - $ 995 0 - - $ 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% - 0.00% 0.00% 0.00% 0.00% 0.00% 832 $832 $ - 0.00% 832 $ - 0.00% - $979 $995 $ - 995 $ - $ $ - - - 979 - $ CAPITAL OUTLAY BUD17 FINAL Item 2017 2017 Requested Approved* *Budgeted in GF Department 1801 Total $ - $ - Section 3 - Page 4 7/21/2016 1:23 PM GENERAL FUND FINANCE 001-51201-415 Account Description Personnel Expense 1001 Salaries 1003 Sal - Temp 1004 Sal - Ltd 1005 Sal - Overtime 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self Fund Ins Claims Personnel Expense 2013 Actual 2014 Actual 2015 Actual 2016 Budget 253,174 0 0 74 18,365 27,314 11,884 1,197 862 25,979 284,142 0 0 0 20,527 32,114 13,923 1,389 718 40,137 309,042 $ 300,776 0 0 0 22,303 23,009 33,670 34,138 12,602 6,423 936 1,128 655 673 35,228 40,228 2016 YTD 2017 2017 4/30/2016 Requested % Change $ 196,891 258 30 13,992 22,350 6,740 679 450 20,240 $ 264,598 20,242 30,005 5,564 1,021 494 29,487 -12.03% 0.00% 0.00% 0.00% -12.03% -12.11% -13.38% -9.54% -26.65% -26.70% $ 338,850 $ 392,949 $ 414,434 $ 406,376 $ 261,629 $ 351,410 -13.53% 128,143 129 2,141 10,635 11,231 1,437 - 129,482 774 1,118 $21 11,409 487 - 140,375 5,579 432 403 1,229 $9,665 13,211 1,285 - 122,855 5,700 1,500 500 1,220 8,200 7,050 765 180 112,420 4,124 624 2,946 4,152 10,441 486 - 142,743 4,950 1,500 500 1,200 6,900 7,050 740 130 16.19% -13.16% 0.00% 0.00% -1.64% -15.85% 0.00% -3.27% -27.78% Operating Expense $ 153,717 $ 143,291 $ 172,180 $ 147,970 $ 135,194 $ 165,713 11.99% Total Expenses $ 492,567 $ 536,240 $ 586,614 $ 554,346 $ 396,823 $ 517,123 -6.71% Operating Expense 3001 Contractual serv 4104 Telephone Services 4303 Computer Maintenance 5401 Advertising 5801 Travel/training 6001 Office supplies 6201 Postage 6401 Books/Dues/Subscrip 6601 Uniforms CAPITAL OUTLAY Items 2017 2017 Requested Approved* *Budgeted in GF Department 1801 1 Inventory Control Program w/ scanners 12,000 Total BUD17 FINAL $ 12,000 $ Section 3 - Page 5 - 7/21/2016 1:23 PM GENERAL FUND HUMAN RESOURCES 001-51301-415 2013 Actual 2014 Actual 2015 Actual 175,982 926 45 13,287 19,893 2,761 776 448 14,818 15,291 1,276 1,600 1,250 3,304 183,645 183 13,946 21,105 3,604 507 411 2,914 11,215 1,610 1,550 1,200 2,612 $ 200,793 6,341 15,846 23,510 6,486 693 464 10,000 15,000 2,500 9,440 $ 154,757 11,738 17,565 2,891 449 347 303 8,851 1,252 1,733 $ 187,738 6,436 14,854 22,019 5,930 715 362 10,000 15,000 2,500 9,603 -6.50% 0.00% 1.50% 0.00% -6.26% -6.34% -8.58% 3.16% -21.84% 0.00% 0.00% 0.00% 0.00% 0.00% 1.74% $ 242,457 $ 251,657 $ 244,501 $ 291,072 $ 199,885 $ 275,158 -5.47% 5,296 1,907 32,598 111,491 27,227 1,093 2,729 3,622 348 1,830 5,476 1,252 35,275 124,845 15,376 380 2,800 1,613 379 1,877 6,109 3,192 33,647 3,775 242 131,149 11,324 771 6,974 809 324 1,220 6,000 3,200 33,510 4,000 900 132,300 50,000 1,000 4,000 1,700 300 2,005 3,946 689 18,867 3,159 84 131,171 12,671 1,928 2,356 730 242 2,968 6,000 3,200 30,710 4,000 900 134,120 50,000 2,000 4,000 1,500 300 2,100 0.00% 0.00% 0.00% -8.36% 0.00% 0.00% 1.38% 0.00% 100.00% 0.00% -11.76% 0.00% 4.74% Operating Expense $ 188,141 $ 189,272 $ 199,534 $ 238,915 $ 178,812 $ 238,830 -0.04% Total Expense $ 430,598 $ 440,929 $ 444,035 $ 529,987 $ 378,697 $ 513,988 -3.02% Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2008 2009 2010 2011 2016 Salaries 169,777 Sal - Temp Sal - Ltd 4,771 Sal - OT OASI 13,234 State Retire 19,000 Health Ins 4,694 Income Protect 753 State Comp 386 Unempl. Ins 14,565 HR Processing 7,673 SF Terrorism Premium 2,073 Cancer Insurance-Police 1,600 Cancer Insurance-Fire 1,200 Self-funding Ins Claims/fees 2,731 Personnel Expense Operating Expense 2012 2013 2015 3001 4104 4303 5201 5202 5401 5801 6001 6201 6401 Awards Program Safety/Wellness Prog HRA Claims Contractual serv Telephone Services Computer Maintenance Liability Insurance Insurance Claims Advertising Travel/training Office supplies Postage Books/Dues/Subscrip 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change CAPITAL OUTLAY Item 0 Total 2017 2017 Requested Approved* *Budgeted in GF Department 1801 $ - $ Section 3 - Page 6 BUD17 FINAL 7/21/2016 1:23 PM MANAGEMENT INFORMATION SYSTEMS 001-51401-419 Account Description Personnel Expense 1001 Salaries 1003 Sal - Temp 1004 Sal - Limited 1005 Sal - Overtime 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self Fund Ins Claims 2013 Actual 2014 Actual 2015 Actual 2016 Budget 2016 YTD 4/30/2016 2017 2017 Requested % Change 60,507 12,479 55,795 532 9,325 14,075 2,328 465 184 8,122 86,168 60,527 187 10,779 16,599 3,436 597 177 13,184 91,977 63,022 715 11,442 17,874 3,123 388 159 10,592 $ 140,344 $ $ 21,441 12,377 18,363 7,070 583 138 17,923 $ $ $ 75,690 50,258 696 9,267 14,374 5,649 469 108 10,974 $ 144,228 $ $ 29,160 13,264 19,662 6,806 642 108 18,186 2.77% 0.00% 36.00% 0.00% 7.17% 7.08% -3.72% 10.18% -21.81% 1.47% $ 163,811 $ 191,654 $ 199,292 $ 218,237 $ 167,483 $ 232,056 6.33% 149,438 168,770 1,170 17,615 5,488 2,551 1,317 - 127,227 142,415 975 524 23,471 2,786 54 229 1,230 - 146,888 6,451 403 79 13,229 9,279 2,138 30 774 855 162,370 5,550 1,200 500 15,000 10,725 3,500 50 2,000 - 158,419 4,339 627 6,038 11,896 914 111 407 233 168,089 5,550 1,200 3,000 15,000 10,500 3,500 50 800 - 3.52% 0.00% 0.00% 500.00% 0.00% -2.10% 0.00% 0.00% 0.00% -60.00% 0.00% Operating Expense $ 346,349 $ 298,910 $ 180,127 $ 200,895 $ 182,985 $ 207,689 3.38% Total Expense $ 510,160 $ 490,563 $ 379,420 $ 419,132 $ 350,468 $ 439,745 4.92% Personnel Expense Operating Expense 3001 Contractual serv 4104 Telephone 4301 Auto & Eq Maintenance 4302 Build Maintenance 4303 Computer Maint/Supp 5801 Travel/training 6001 Office supplies 6201 Postage 6401 Books/Dues/Subscrip 6501 Gas/oil/lube 6502 Diesel/oil/lube CAPITAL OUTLAY BUD17 FINAL Items Backup Hardware 2017 2017 Requested Approved* *Budgeted in Capital Projects 26,000 - TOTAL $ 26,000 Section 3 - Page 7 $ - 7/21/2016 1:23 PM GENERAL FUND GENERAL GOVERNMENT 001-51501-413 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Sal Temporary 1006 Vac/Sick Leave Pay-outs 2001 OASI 2006 State Comp 2014 Retirement Incentives Personnel Expense Operating Expense 3001 Contractual Services 3004 Elections 3005 Legal Services 3006 ADOR Tax Administration 3101 Council Expenses 3102 Mayor Expense 3103 Ward 1 Expense 3104 Ward 2 Expense 3105 Ward 3 Expense 3106 Ward 4 Expense 3107 Ward 5 Expense 3108 Ward 6 Expense 4104 Telephone Services 6401 Books Due & Subscription 7601 Misc. Council Projects 7602 Bus. Dist. Impr. 7621 Demolition Program 7630 DUSD Infra Improvement 8003 Reserve 8004 Fireworks 8008 Employee Reward Program 8101 Special Events 8104 4th of July Expense 8106 Youth Activity Expense 8109 League of Cities Event 8110 Douglas Days 9904 Transfer to Capital Projects 9906 Transfer to Airport 9911 Transfer to Housing 9913 Transfer to Golf Course 9915 Transfer to Grants 9916 Transfer to Bonds Transfer to Transit 9917 Transfer to Debt Service BUD17 FINAL 2014 Actual 18,045 1,232 41 $ 19,317 2015 Actual 18,428 1,248 47 $ 19,723 $ 2016 Budget 18,156 1,091 40 - $ 18,000 19,286 $ 19,417 $ 2016 YTD 4/30/2016 $ $ 2017 Requested 14,089 1,020 31 - $ $ 15,141 $ 19 1,721 264 51,336 5,662 2,546 1,390 1,519 1,495 1,394 1,274 527 1,294 20,388 15,738 20,791 15,840 16,450 3,384 10 2,947 7,076 5,639 8,987 - 1,377 40 - 18,000 2017 % Change 1,377 34 - 0.00% 0.00% 0.00% 0.00% -16.37% 0.00% $ 19,411 -0.03% $ 999,937 24,000 5,000 38,029 3,000 4,000 2,000 2,000 2,000 2,000 2,000 2,000 1,370 19,650 4,000 48,623 3,566 104,856 15,000 1,000 15,250 6,000 1,000 2,200 15,000 51,293 165,000 6,300 1,221,503 0.00% -20.00% 0.00% -25.92% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -60.00% -2.75% -58.05% 0.00% -83.50% 0.00% 0.00% -6.15% 0.00% 0.00% 0.00% 0.00% 0.00% -14.94% 0.00% 37.50% 297.61% 0.00% -100.00% -0.98% 3,143 7,371 3,777 1,483 1,818 1,252 1,623 2,939 1,606 20,844 9,462 9,697 3,604 22,001 20,000 303 17,050 2,768 2,067 15,537 8,238 14,307 4,917 1,308 1,679 423 825 2,156 2,395 18,973 10,760 6,812 1,402 42,865 17,778 15,840 986 16,000 3,066 3,394 22,265 45,780 318,755 62,703 325,691 31,757 15,933 174,665 153,371 326,160 1,136 8,499 6,702 1,069 1,028 1,346 1,492 1,268 2,706 1,329 20,551 111,094 14,051 498 18,360 191 15,000 567 16,500 3,460 310 2,854 18,258 176,998 15,996 133,190 16,410 325,922 1,147,062 1,357,254 1,280,066 30,000 5,000 51,336 3,000 4,000 2,000 2,000 2,000 2,000 2,000 2,000 1,370 19,650 10,000 49,999 8,500 635,458 15,000 1,000 16,250 6,000 1,000 2,200 15,000 60,302 120,000 1,584 154,351 1,233,567 Operating Expense $ 2,055,067 $ 2,248,802 $ 2,196,850 $ 2,456,568 $ 1,187,629 $ 1,767,640 -28.04% Total Expenses $ 2,074,384 $ 2,268,524 $ 2,216,136 $ 2,475,985 $ 1,202,770 $ 1,787,051 -27.82% Section 3 - Page 8 7/21/2016 1:23 PM SPECIAL EVENTS SUPPORT FY 16/17 EVENT ROTARY - 5th ANNUAL FLY IN DOUGLAS SENIOR CITIZENS DARC DOUGLAS YOUTH FOOTBALL AND CHEER TOTAL SPECIAL EVENTS BUD17 FINAL AMOUNT REQUESTED $ 750 1,500 13,000 1,500 16,750 Section 3 - Page 8A AMOUNT RECOMMENDED $ 750 1,500 13,000 15,250 AMOUNT APPROVED $ - 7/21/2016 1:23 PM GENERAL FUND MAGISTRATE 001-51601-412 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Sal - Temp 1004 Sal - Lim 1005 Sal - Overtime 2001 OASI 2002 Retirement 2004 Health Ins 2005 Income Prot. 2006 State Comp 2016 Self Fund Ins Claims 2014 Actual 2015 Actual $ 3,439 4,828 1,579 227 116 2,670 38,992 4,450 1,003 3,384 4,487 2,218 134 187 2,795 $ 58,837 $ 58,555 $ 57,650 $ 15,000 - 15,000 47 - 15,000 462 - Operating Expense $ 15,000 $ 15,047 $ 15,462 Total Expense $ 73,837 $ 73,602 $ 73,112 Personnel Expense Operating Expense 3001 Contractual Services 5801 Travel/Training 6001 Office Supplies 6201 Postage 6401 Books/Dues/Subscr. 46,222 - 43,672 2,025 3,446 5,032 1,821 238 103 1,975 2016 Budget 39,078 6,500 2016 YTD 2017 2017 4/30/2016 Requested % Change $ 3,487 4,435 327 155 102 8,484 $ 31,235 411 5,018 2,805 3,579 1,790 120 133 1,965 - -100.00% -100.00% 0.00% 0.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% 62,568 $ 47,056 $ - -100.00% 15,000 - 12,500 349 - - -100.00% 0.00% 0.00% 0.00% 0.00% $ 15,000 $ 12,849 $ - -100.00% $ 77,568 $ 59,905 $ - -100.00% CAPITAL OUTLAY 2017 2017 Requested Approved* *Budgeted in JCEF Items 0 Total BUD17 FINAL $ - $ Section 3 - Page 9 - 7/21/2016 1:23 PM GENERAL FUND LIBRARY 001-51701-412 Account 2016 YTD 4/30/2016 2017 2017 Requested % Change $ 131,429 74,000 15,715 14,917 8,819 522 460 12,586 $ 62,254 35,143 50,718 11,268 12,717 4,525 232 409 5,223 $ 133,401 55,000 14,413 15,128 8,635 556 352 12,769 1.50% -25.68% 0.00% 0.00% -8.29% 1.41% -2.08% 6.61% -23.53% 1.46% $ 216,223 $ 258,448 $ 182,488 $ 240,254 -7.04% 896 381 12,255 20,998 1,179 204 - 20,415 48,890 12,127 9,159 25 1,010 11,375 24,398 1,908 438 104 - 35,092 51,904 39,516 3,389 1,650 467 849 7,399 25,819 1,457 - 28,625 38,310 42,450 7,500 3,000 1,000 1,200 6,400 27,000 1,700 - 33,214 32,594 31,248 3,549 1,384 473 1,065 2,537 21,989 1,203 60 - 55.18% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 25.00% 0.00% -3.70% 0.00% 0.00% 0.00% 100.00% Operating Expense $ 101,852 $ 129,849 $ 167,542 $ 157,185 $ 129,316 44,419 38,310 42,450 7,500 3,000 1,000 1,500 6,400 26,000 1,700 239 1,300 $ 173,818 Total Expenses $ 308,610 $ 327,470 $ 383,765 $ 415,633 $ 311,805 $ 414,072 -0.38% Description Personnel Expense 1001 Salaries 1003 Salaries Temp 1004 Salaries Limited 1005 Salaries O/T 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self Fund Ins Claims Personnel Expense Operating Expense 3001 Contract Serv 4104 Telephone 4105 Utilities 4109 Utilities Gov Center 4302 Building Maintenance 4303 Computer Maintenance 5401 Advertising & Printing 5801 Travel/training 6001 Office supplies 6005 Library Materials 6201 Postage 6301 Small Tools & Eq 6401 Books/Dues/Subscrip 6601 Uniforms 2013 Actual 2014 Actual 2015 Actual 98,224 73,403 190 13,006 9,721 6,189 446 578 5,000 115,765 40,732 26 11,805 11,975 6,515 522 615 9,665 106,812 51,716 22,363 596 13,799 12,200 3,637 320 776 4,005 $ 206,758 $ 197,621 14,773 42,247 8,919 2016 Budget 10.58% CAPITAL OUTLAY Items Inventory Device 2 Automatic Doors for North and South Entrance Upgrade Lighting Roofing Materials Upgrade Tech and circulation areas Microfilm machine Library Furniture Upgrades and Additions Marketing/Branding Exterior Painting Purchase of Building Furnishing and Equipping Building Total BUD17 FINAL 2017 2017 Requested Approved* *Budgeted in Capital Projects 7,070 15,000 15,000 7,000 5,000 5,000 9,000 5,000 12,000 5,000 25,000 25,000 275,000 100,000 $ 465,070 $ 45,000 Section 3 - Page 10 7/21/2016 1:23 PM GENERAL FUND COMMUNITY DEVELOPMENT NEIGHBORHOODS/GRANTS 001-52001-419 pg 14 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Salaries Temp 1005 Salaries/OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Fund Ins Claims Personnel Expense 2014 Actual 58,510 2015 Actual 2,540 4,104 6,558 1,341 284 1,948 8,149 18,582 3,017 1,558 2,100 1,262 121 747 1,538 $ 83,434 $ 28,925 1,320 211 35 248 124 1,401 292 18 20 6 223 Operaitng Expense 3001 Contractual Services 5401 Advertising 5801 Travel/training 6001 Office supplies 6201 Postage 6301 Small Tools & Equipment 6401 Books/dues/subscrip 6500 Gas/oil/lube 6601 Uniform Operating Expense $ 3,631 Total Expenses $ 87,066 $ $ 2016 2016 YTD 2017 2017 Budget 4/30/2016 Requested % Change - $ - $ - $ - $ $ 11,433 875 26 - - $ 12,334 $ - - 1,795 - - - - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - 267 $ - $ - $ 1,795 $ - 0.00% $ 29,192 $ - $ - $ 14,129 $ - 0.00% CAPITAL OUTLAY BUD17 FINAL Items 2017 2017 Requested Approved* *Budgeted in GF Department 1801 Total $ - $ - Section 3 - Page 11 7/21/20161:23 PM GENERAL FUND CEMETERY 001-52021-452 Account Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Lim 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Fund Ins Claims 2013 Actual 2015 Actual 2016 Budget $ 23,299 500 6,927 10,277 4,409 293 5,019 6,293 $ 69,699 $ 6,279 $ 500 5,851 7,961 4,318 291 4,344 6,385 4.42% 0.00% -100.00% 0.00% -15.54% -22.54% -2.08% -0.75% -13.46% 1.46% $ 120,571 $ 123,764 $ 78,642 $ 105,626 -14.65% 3,832 122 532 5,762 1,804 485 9,848 865 6,966 3,681 3,361 3,678 2,864 344 732 3,808 2,454 677 7,091 2,036 1,052 3,930 1,037 400 3,220 3,187 3,231 527 1,995 219 394 2,614 3,224 954 4,615 2,285 1,041 3,683 $900 $400 3,500 3,000 2,500 400 2,500 300 250 2,500 3,000 700 5,000 1,500 700 4,000 $887 $332 3,209 2,505 1,635 2,091 823 294 2,565 3,406 637 2,565 1,842 692 3,141 $1,150 $400 3,500 3,000 2,500 400 2,500 500 250 4,350 3,000 700 3,500 1,700 700 4,000 27.78% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 66.67% 0.00% 74.00% 0.00% 0.00% 0.00% -30.00% 13.33% 0.00% 0.00% Operating Expense $ 41,475 $ 36,621 $ 32,627 $31,150 $26,623 $32,150 3.21% Total Expense $ 101,023 $ 155,604 $ 153,198 $ 154,914 $ 105,264 $ 137,776 -11.06% Operating Expense 3001 Contractual Services 4104 Utilities/Telephone 4105 Utilities 4301 Auto/equip 4302 Building Maintenance 4303 Computer Maintenance 5501 DOC Labor 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6021 Chemicals 6301 Small tools & Eq 6401 Books/dues/subscrip 6501 Gas/oil/lube 6502 Diesel/oil/lube 6601 Uniforms 6701 Construction materials 73,691 12,301 4,323 6,869 9,513 4,276 254 3,992 5,352 $ 66,746 10,466 487 2,870 4,539 1,007 181 2,283 6,986 51,312 869 34,101 2,783 6,711 10,062 3,487 359 4,677 4,623 $ 59,548 $ 118,984 505 914 7,173 3,582 2016 YTD 2017 2017 4/30/2016 Requested % Change $ 51,607 $ $ 274 4,932 4,317 6,443 3,676 216 3,117 4,060 Personnel Expense 30,730 2014 Actual CAPITAL OUTLAY Items Trees Chip Seal project TOTAL BUD17 FINAL 2017 2017 Requested Approved* *Budgeted in Capital Projects 8,000 40,000 20,000 $ 48,000 $ 20,000 Section 3 - Page 12 7/21/2016 1:23 PM GENERAL FUND PARKS 001-52023-452 pg 16 Account Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Lim 1005 Sal-OT 2201 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Fund Ins Claims 2014 Actual 2015 Actual 2016 Budget 213,058 95,714 1,041 22,682 33,711 10,256 1,321 10,184 29,128 189,122 876 65,339 1,841 18,796 29,031 8,821 1,160 9,278 33,943 190,202 7,774 41,299 3,513 18,084 26,843 8,370 668 8,093 18,781 239,747 $ 417,095 $ 358,208 35,466 1,397 31,269 2016 YTD 2017 2017 4/30/2016 Requested % Change 34,949 500 21,052 31,235 14,075 955 9,006 35,847 154,209 3,857 18,570 6,966 13,692 20,169 9,168 663 6,034 14,779 233,527 16,744 500 17,903 26,539 13,347 974 6,932 27,763 -2.59% 0.00% -100.00% 0.00% -14.96% -15.03% -5.17% 2.03% -23.03% -22.55% $ 323,627 $ 387,366 $ 248,107 $ 344,230 -11.14% 10,192 744 934 30,623 8,629 1,170 22,378 2,702 3,441 95 34,757 1,284 44,013 10,638 15,687 9,844 928 269 26,315 7,708 1,146 16,810 2,101 3,080 1,210 280 34,321 1,047 38,588 1,016 9,032 11,861 206 9,090 762 196 23,957 8,101 2,177 14,732 2,286 2,223 1,800 500 35,000 1,000 35,000 800 9,000 14,000 400 10,000 1,000 300 26,000 10,000 3,000 13,000 2,000 2,450 3,000 31,271 618 27,498 880 7,828 10,696 5,908 2,493 769 14,490 3,173 1,763 9,286 2,033 2,371 8,993 500 37,000 1,000 38,000 1,050 9,000 14,000 400 10,000 1,600 700 25,000 9,000 3,000 13,000 2,000 2,800 3,000 0.00% 5.71% 0.00% 8.57% 31.25% 0.00% 0.00% 0.00% 0.00% 60.00% 133.33% -3.85% -10.00% 0.00% 0.00% 0.00% 14.29% 0.00% Operating Expense $ 165,579 $ 175,884 $ 161,674 $ 166,450 $ 130,068 $ 171,050 2.76% Total Expenses $ 582,674 $ 534,092 $ 485,301 $ 553,816 $ 378,175 $ 515,280 -6.96% Personnel Expense Operating Expense 3001 Contractual Services 4101 Electric 4102 Gas 4103 Water/Sewer/Sanitation 4104 Telephone Services 4301 Auto/equip 4302 Building Maintenance 4303 Computer Maintenance 5501 DOC Labor 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6021 Supplies/Chemicals 6301 Small tools 6501 Gas/oil/lube 6502 Diesel/Oil 6601 Uniforms 6701 Construction materials BUD17 FINAL 2013 Actual 16,636 Section 3 - Page 13 7/21/2016 1:23 PM GENERAL FUND PARKS 001-52023-452 CAPITAL OUTLAY 2017 2017 Items Requested Approved* *Budgeted in Capital Projects 4 Bleachers 7,000 Ground Leveling of Lower Fields at Airport13,000 Park Electrical Pedestals @ Airport Park 20,000 Ramada for Stage @ Airport Park 5,800 Additional lightning for lower fields @ Airport 440,000 Park Ramada Replacement Program 18,200 18,200 Total $ 504,000 $ 18,200 BUD17 FINAL Section 3 - Page 13 7/21/2016 1:23 PM GENERAL FUND RECREATION 001-52031-451 Account Description Personnel Expense 1001 Salaries 1003 Salaries/Temp 1004 Salaries LTD 1005 Salaries Overtime 2001 O.A.S.I. 2002 Retire-State 2004 Health Insurance 2005 Income Protection 2006 Workman's Compensation 2016 Self Fund Ins Claims 2013 Actual 2014 Actual 17,852 40,540 17,066 691 5,657 4,553 503 136 2,471 3,493 9,514 48,718 18,035 919 5,811 3,321 302 105 2,716 2,264 $ 92,963 $ 91,705 8,809 3,374 3,593 1,406 13,383 4 566 461 2,862 230 1,492 2,312 50 817 25,548 11 253 315 Operating Expense $ 31,596 $ 33,889 Total Expenses $ 124,559 $ 125,594 Personnel Expense Operating Expense 4104 Telephone 4105 Utilities 4301 Auto & Equipment 4302 Building Maintenance 4303 Computer Maintenance 5401 Advertising & Printing 5801 Travel & Training 6001 Office Supplies 6007 Recreation Cost 6201 Postage 6301 Small Tools & Equipment 6401 Books/Dues/Subscriptions 6501 Gas/Oil/Lubricants 6601 Uniforms 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change - $ 24,639 30,000 25,188 22,550 298 500 3,843 4,058 2,418 3,307 2 2,269 25 28 1,617 1,736 (110) 3,147 $ 57,920 $ 67,595 $ 49,958 $ 142,321 110.55% 893 3,511 184 2,953 1,948 309 450 13,575 12 183 179 950 3,000 250 1,800 400 2,000 250 700 15,000 50 390 250 500 769 3,303 130 1,531 2,681 1,117 19,147 63 515 356 1,118 950 4,000 350 1,800 400 3,000 1,600 1,000 21,850 50 200 350 1,000 0.00% 33.33% 40.00% 0.00% 0.00% 50.00% 540.00% 42.86% 45.67% 0.00% 0.00% -48.72% 40.00% 100.00% $ 24,196 $ 25,540 $ 30,730 $ 36,550 43.11% $ 82,116 $ 93,135 $ 80,688 $ 178,871 92.06% $ 13,003 29,284 1,068 3,316 1,733 53 56 1,438 6 $ 79,501 100.00% 30,000 0.00% - -100.00% 500 0.00% 8,415 107.35% 9,830 197.21% 4,318 90.32% 332 1100.90% 3,041 75.15% 6,385 102.91% CAPITAL OUTLAY Items 2017 2017 Requested Approved* *Budgeted in GF Department 1801 PA System 9,000 Tables & Chairs with Cart for Events 5,000 Total $ 14,000 BUD17 FINAL $ 5,000 5,000 Section 3 - Page 14 7/21/2016 1:23 PM GENERAL FUND AQUATICS 001-52035-451 pg 19 Account Description Personnel Expense 1001 Salaries 1003 Salaries/Temp 1004 Salaries/Lim 1005 Salaries/OT 1006 Salaries/Reimbursement 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Fund Ins Claims 2015 Actual 70,588 83,027 5,788 307 8,250 12,839 9,510 4,648 397 5,924 7,315 60,192 72,385 11,280 972 10,893 11,994 6,862 3,187 178 4,959 3,746 $ 215,423 $ 208,591 1,021 2016 Budget $ 26,447 80,000 500 10,000 8,946 3,056 4,318 111 4,335 6,385 -33.55% 0.00% -100.00% 0.00% 0.00% -20.32% -52.57% -2.08% -30.03% -30.74% 1.46% $ 186,647 $ 181,554 $ 119,756 $ 144,097 -20.63% 16,819 442 916 2,416 597 11,376 277 667 2,344 2,330 972 5,340 52,311 9,051 996 18,716 1,288 1,308 14,042 727 366 2,783 2,309 8,279 1,708 2,542 61,931 8,026 654 33 20,354 908 668 1,546 2,029 11,100 1,062 358 1,360 1,829 22,570 2,200 4,000 45,000 10,000 1,000 900 20,000 1,000 1,350 1,500 2,000 8,500 800 500 1,500 2,000 $12,427 $1,453 2,570 48,196 7,327 244 860 11,666 498 2,570 1,519 129 2,918 743 422 670 22,570 2,200 4,000 60,000 10,000 500 400 20,000 1,000 1,350 1,500 2,000 8,500 800 500 1,500 2,000 0.00% 0.00% 0.00% 33.33% 0.00% -50.00% -55.56% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 102,089 $ 110,208 $ 124,387 $124,820 $94,214 $ 138,820 11.22% Total Expenses $ 317,513 $ 318,799 $ 311,034 $ 306,374 $ 213,970 $ 282,917 -7.66% 5,691 49,100 8,091 - Section 3 - Page 15 $ 2016 YTD 2017 2017 4/30/2016 Requested % Change $ 30,108 54,316 11,970 409 4,184 7,718 3,871 1,792 118 3,305 1,965 Operaitng Expense 3001 Contractual Services 4104 Telephone Services 4105 Utilities 4106 Utilities-Aquatic Center 4108 Utilities-8th Street 4301 Auto & Eq Maintenance 4303 Computer Maintenance 4304 Maint.Cost-Aquatic Center 5401 Advertising & Printing 5801 Travel/training 6001 Office supplies 6007 Recreation Cost 6011 Swimming Pool 6012 Aquatic Center Concession 6013 Aquatic Center-Pro Shop 6201 Postage 6401 Books/dues/subscrip 6501 Gas/oil/lube 6601 Uniforms 67,168 99,080 (1,820) 13,339 13,589 7,998 4,531 354 5,731 5,455 2014 Actual 39,801 80,000 16,464 500 10,000 11,228 6,443 4,409 159 6,258 6,293 Personnel Expense BUD17 FINAL 2013 Actual 7/21/2016 1:23 PM GENERAL FUND AQUATICS 001-52035-451 CAPITAL OUTLAY Items ADA Doors POS System Automation System for Main Pool 8th Street Pump Upgrade Baby Pool replaster @ 8th Street Artificial Grass for Outdoor play area Facility Furniture Shading over whale tail splash pad Total BUD17 FINAL 2017 2017 Requested Approved* *Budgeted in Capital Projects 5,000 5,000 12,000 10,000 20,000 18,000 18,000 12,000 12,000 12,000 30,000 15,000 $ 125,000 $ 44,000 Section 3 - Page 15 7/21/2016 1:23 PM GENERAL FUND PUBLIC WORKS ADMINISTRATION 001-54001-431 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Ltd 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self Fund Ins Claims 2014 Actual 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 66,351 10,266 7 5,559 7,231 1,766 320 1,954 7,341 73,245 1,437 486 5,648 8,456 3,706 372 2,500 6,374 96,166 611 7,077 11,106 4,943 327 2,225 6,649 $ 101,590 7,772 11,530 5,104 403 2,321 7,456 $ 59,657 1,453 916 4,698 5,372 2,609 181 1,469 2,792 $ 85,019 6,504 9,641 4,995 354 1,742 7,565 -16.31% 0.00% 0.00% 0.00% -16.31% -16.38% -2.13% -12.09% -24.96% 1.46% $ 100,796 $ 102,225 $ 129,104 $ 136,177 $ 79,146 $ 115,821 -14.95% - - 779 2,813 3,976 798 376 372 435 1,864 159 1,833 1,209 1,043 229 2,274 2,854 758 227 47 503 2,021 360 1,865 - 3,691 2,104 296 2,225 2,060 255 506 2,401 462 512 71 3,300 1,000 2,600 1,000 3,600 4,000 500 600 450 200 1,000 2,200 600 - 7 1,946 28 154 1,411 825 4 144 228 781 129 - 2,750 1,000 1,000 1,000 3,000 2,000 500 600 450 200 1,000 2,000 400 - 0.00% -16.67% 0.00% -61.54% 0.00% -16.67% -50.00% 0.00% 0.00% 0.00% 0.00% 0.00% -9.09% -33.33% 0.00% 0.00% Operating Expense $ 14,614 $ 12,181 $ 14,583 $ 21,050 $ 5,659 $ 15,900 -24.47% Total Expenses $ 115,410 $ 114,406 $ 143,688 $ 157,227 $ 84,805 $ 131,721 -16.22% Personnel Expense Operating Expense 3001 Contractual serv 4104 Telephone Services 4301 Auto/Equip 4303 Computer Maintenance 5401 Advertising & Printing 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6201 Postage 6301 Small Tools 6302 Safety equip 6401 Books/Dues/Subscrip 6501 Gas/oil/lube 6601 Uniforms 6703 Graffiti Abatement Supplies 6705 DOC Supplies CAPITAL OUTLAY 2017 2017 Requested Approved* *Budgeted in Capital Projects Items 0 0 Total BUD17 FINAL $ - $ Section 3 - Page 16 - 7/21/2016 1:23 PM GENERAL FUND PW CONSTRUCTION 001-54018-431 pg 17 Account 2013 Actual 2014 Actual 2015 Actual 187,754 3,980 154 13,710 19,746 8,830 912 10,316 21,983 191,497 4,326 2,526 14,340 21,994 8,660 1,011 11,626 21,004 178,561 774 12,980 20,589 8,089 616 7,491 16,876 $ 211,381 $ 1,000 16,247 24,105 10,001 840 11,362 21,856 $ 119,373 $ 168 8,590 14,366 5,054 455 5,222 10,364 $ 203,467 $ 1,000 15,642 23,187 8,634 850 9,028 20,581 -3.74% 0.00% 0.00% -3.73% -3.81% -13.68% 1.13% -20.54% -5.84% $ 267,386 $ 276,984 $ 245,976 $ 296,794 $ 163,591 $ 282,387 -4.85% 55,482 30,152 2,490 1,829 25,258 12,982 697 49 568 706 260 6,350 1,921 31 385 7,504 29,365 30,332 2,519 1,738 2,941 19,726 20,979 365 563 754 259 6,758 2,669 1,890 422 314 6,179 3,693 29,554 2,943 1,602 1,070 3,190 18,255 12,903 616 65 136 689 5,772 41 1,406 1,710 984 8,017 18,480 28,000 3,000 2,500 1,750 4,500 15,000 20,000 1,500 5,350 3,000 500 6,000 450 1,400 3,000 2,500 8,000 25,280 2,491 1,045 1,003 3,222 19,455 120 75 772 2,178 113 4,056 265 1,426 1,406 930 6,213 21,590 30,000 3,000 2,000 1,300 4,300 15,000 10,000 2,500 500 1,000 3,000 1,000 6,000 450 1,750 3,000 2,500 8,000 16.83% 7.14% 0.00% -20.00% -25.71% -4.44% 0.00% -50.00% 66.67% 100.00% -81.31% 0.00% 100.00% 0.00% 0.00% 25.00% 0.00% 0.00% 0.00% Operating Expense $ 146,664 $ 127,773 $ 92,648 $ 124,930 $ 70,051 $ 116,890 -6.44% Total Expenses $ 414,049 $ 404,757 $ 338,624 $ 421,724 $ 233,643 $ 399,277 -5.32% Description Personnel Expense 1001 Salaries 1004 Salaries - Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self Fund Ins Claims Personnel Expense Operating Expense 3001 Contractual services 4101 Utilities-Electric (City Hall) 4102 Utilites-Gas (City Hall) 4103 Utilites-Water/Sewer/San 4104 Telephone Services 4301 Auto/Equip 4305 City Hall Maintenance 5501 DOC Labor 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6301 Small tools/Equipment 6302 Safety Equipment 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 6699 Construction Materials 6703 Graffiti Abatement Supplies 6705 DOC Supplies CAPITAL OUTLAY Items Roof on 7th Street Building Total BUD17 FINAL 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 2017 2017 Requested Approved* *Budgeted in GF Department 1801 30,000 25,000 $ 30,000 $ 25,000 Section 3 - Page 17 7/21/2016 1:23 PM GENERAL FUND PUBLIC WORKS FLEET MAINTENANCE 001-54031-431 Account Description Personnel Expense 1001 Salaries 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self Fund Ins Claims 2013 Actual 2014 Actual 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 74,506 1,159 5,554 8,253 2,746 375 2,164 7,598 60,286 405 4,583 6,859 2,910 317 1,998 5,299 52,065 1,441 4,078 6,142 3,338 186 1,618 3,643 $ 98,030 1,000 7,576 11,240 3,859 390 2,956 13,204 $ 42,893 1,047 3,347 4,987 2,598 170 1,312 2,730 $ 70,682 1,000 5,484 8,129 3,664 296 1,708 13,398 -27.90% 0.00% -27.62% -27.68% -5.04% -24.14% -42.23% 1.47% $ 102,356 $ 82,657 $ 72,510 $ 138,254 $ 59,084 $ 104,360 -24.52% 2,246 71 1,105 2,727 2,606 289 275 3,292 850 2,460 5,243 2,947 85 442 1,823 882 163 1,563 892 973 1,181 5,125 1,569 32 16 255 3,621 468 1,802 1,051 $2,126 $1,150 5,500 3,000 400 500 900 2,500 1,500 500 2,000 2,000 1,400 $601 $1,057 4,524 2,521 238 2,899 963 93 1,474 1,043 $2,126 $1,150 5,500 3,000 400 500 900 1,700 2,100 500 250 2,000 1,400 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -32.00% 40.00% 0.00% -87.50% 0.00% 0.00% Operating Expense $104,331 $16,502 $16,093 $23,476 $15,413 $21,526.00 -8.31% Total Expenses $ 206,687 $ 99,159 $ 88,604 $ 161,730 Personnel Expense Operating Expense 3001 Contractual Services 4104 Telephone Services 4105 Utilities 4301 Auto/Equip 4303 Computer Maintenance 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6301 Small tools 6302 Safety Equipment 6401 Books/Dues/Subscrip 6501 Gas/oil/lube 6601 Uniforms 4,853 86,018 $ 74,497 $ 125,886 -22.16% CAPITAL OUTLAY BUD17 FINAL Items 2017 2017 Requested Approved *Budgeted in GF Department 1801 Vehicle Code Scanner Alignment Machine Total 5,000 25,000 $ 30,000 5,000 $ 5,000 Section 3 - Page 18 7/21/2016 1:23 PM GENERAL FUND FIRE 001-55001-422 pg 23 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Temporary 1004 Limited 1005 Sal-OT 2001 OASI 2002 State Retirement 2003 State Retire/PS 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2011 Cancer Insurance-Fire 2016 Self Fund Ins Claims Personnel Expense 2014 Actual 2015 Actual 618,428 11,612 92,304 13,115 3,913 288,259 25,419 2,122 29,073 649,207 94,429 12,471 4,147 299,661 25,724 2,390 40,813 62,114 86,458 648,014 14,090 118,220 14,177 4,313 253,674 22,727 1,796 43,137 65,621 $ 1,146,362 $ 1,215,300 24,624 10,814 2,875 Operating Expense 3001 Contract. Serv. 3401 Community Training 3402 Public Education 4104 Telephone Services 4105 Utilities 4301 Auto/equip 4302 Building Maintenance 4303 Computer Maintenance 5301 Communication Equip. 5801 Travel/training 5802 Incident Meal Money 6001 Office supplies 6002 Operating Supplies 6201 Postage 6301 Small tools 6302 Safety Equip 6303 Structural PPE 6304 Tactics and Rescue Wildland 6401 Books/dues/subscrip 6501 Gas/oil/lube 6601 Uniforms Honor Guard Uniform 6701 Construction materials 2016 Budget 50,000 13,299 4,097 321,836 19,138 2,217 33,957 1,500 72,928 514,316 50,306 195 167,072 15,395 5,384 346,053 14,203 1,594 25,815 1,250 45,284 $ 1,185,769 $ 1,152,000 679 17,219 1,142 6,533 6,210 459 2,121 782 3,306 1,052 26,153 6,941 3,064 20,490 12,059 11,173 24,656 552 7,995 3,296 304 2,248 282 906 579 22,716 3,453 4,069 16,424 20,999 20,595 4,321 470 31,783 1,260 6,223 7,997 145 6,749 1,219 2,245 762 23,226 7,000 4,000 17,730 18,000 20,000 4,500 1,500 500 25,900 250 2,500 3,000 300 300 500 3,000 500 1,469 20,499 11,717 115 89 1,467 18,615 10,077 786 - 1,002 14,338 8,059 334 - 1,025 14,000 10,458 500 500 18,882 12,357 Operating expense $ 142,943 Total Expense $ 1,289,305 $ 151,643 $ 1,366,943 $ 175,163 $ 1,360,932 $ $ $ 626,527 6,500 2016 YTD 4/30/2016 159,189 $ 1,311,189 $ $ $ 2017 2017 Requested % Change 50,000 16,439 10,192 319,538 14,038 2,137 30,751 1,500 76,227 -2.43% 669.23% 0.00% 0.00% 23.61% 148.73% -0.71% -26.65% -3.60% -9.44% 0.00% 4.52% $ 1,186,868 $ 1,182,131 2.62% 23,139 5,174 4,026 14,931 18,560 15,266 6,204 603 5,392 33,199 686 5,307 5,330 244 2,452 4,755 809 8,313 19,086 - 25,276 9,000 4,000 17,730 20,000 20,000 4,500 1,500 500 33,500 500 2,500 4,000 300 300 500 3,000 500 1,025 12,000 10,458 800 - 8.83% 28.57% 0.00% 0.00% 11.11% 0.00% 0.00% 0.00% 0.00% 29.34% 100.00% 0.00% 33.33% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -14.29% 0.00% 60.00% -100.00% 171,889 7.98% $ 1,354,020 3.27% $ 173,477 $ 1,360,345 $ $ $ 611,310 50,000 Section 3 - Page 19 BUD17 FINAL 7/21/2016 1:23 PM GENERAL FUND EMS 001-55052-422 pg 24 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Sal-temp 1005 Sal-OT 2001 OASI 2002 State Retire 2003 State Retire-PS 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Fund Ins Claims Personnel Expense 2014 Actual 2015 Actual 2016 Budget 659,325 103,937 9,386 286,491 17,928 1,751 42,244 59,014 641,741 137,102 10,661 343,647 17,884 1,957 55,620 80,776 667,944 136,144 11,095 342,124 16,334 1,567 48,207 66,147 $ 1,180,077 $ 1,289,386 $ 1,289,562 $ 1,376,848 7,745 7,960 8,165 8,651 103 6,559 55,634 44 57 87 50 15,840 81 6,978 1,067 12,913 5,106 312 1,354 54,210 28 10 50 13,056 - 15,578 1,100 Operating Expense 3001 Contract. Services 4104 Telephone Services 4105 Utilities 4301 Auto/equip 4302 Building Maintenance 5301 Communication Equip. 5801 Travel/training 5802 Incident Meal Money 6001 Office supplies 6002 Operating supplies (Med) 6201 Postage 6301 Small tools 6302 Safety Equip 6401 Books/dues/subscrip 6501 Gas/oil/lube 6601 Uniforms 25 3,998 228 788 58,526 26 648 63 50 16,651 - Operating Expense $ 88,749 Total Expenses $ 1,268,826 $ 103,231 $ 1,392,617 $ 95,084 $ 1,384,646 $ 694,217 50,000 11,567 483,071 18,132 2,246 39,350 78,265 2016 YTD 4/30/2016 $ 761,629 50,000 12,412 549,116 17,218 2,419 37,081 88,028 9.71% 0.00% 0.00% 7.31% 0.00% 13.67% -5.04% 7.69% -5.77% 12.47% $ 1,390,223 $ 1,517,905 10.24% 12,516 889 20,773 2,569 2,912 72,566 49 13 23,482 - 11,978 1,100 400 5,150 250 2,500 60,000 300 200 1,000 2,300 20,000 - -23.11% 0.00% 0.00% 100.00% 0.00% 0.00% -7.21% 0.00% -16.67% 9.09% 0.00% 0.00% 0.00% 27.78% 33.33% 0.00% 117,178 11.41% $ 1,635,083 10.33% 6,000 400 5,550 250 3,000 55,000 300 200 1,000 1,800 15,000 $ 105,178 $ 1,482,026 $ 581,830 5,904 214,111 11,655 475,182 10,991 1,507 42,371 46,673 2017 2017 Requested % Change 135,770 $ 1,525,993 $ 12,000 $ Section 3 - Page 20 BUD17 FINAL 7/21/2016 1:23 PM GENERAL FUND EMS 001-55052-422 CAPITAL OUTLAY 2017 Items Requested Multi Use Vehicle (pull Haz-Mat, air and light Trailer) 125,000 Type 6 Quick Attack Vehicle 80,000 New Roof 25,000 2 Rescue Tools (Jaws of Life) 30,000 New Fire Station 6,000,000 3 Air conditioner replacement 20,000 SCBA Replacement (22 harnesses and 44 tanks) 260,000 Fire Truck 400,000 2 ambulances 250,000 SCBA Air filling cascade system 45,000 2 Cardiac monitors 65,000 TOTAL $ 7,300,000 2017 Approved* *Budgeted in Capital Projects 80,000 25,000 15,000 13,800 250,000 45,000 65,000 $ 493,800 Section 3 - Page 20 BUD17 FINAL 7/21/2016 1:23 PM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 pg 25 Account Description Personnel Expense 1001 Salaries 1002 Salaries-Civilian 1005 Sal-OT 1006 Sal - Reimbursed OT 2001 OASI 2002 State Retire 2003 State Retire-PS 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2010 Cancer Insurance-Police 2016 Self Fund Ins Claims 2013 Actual 2014 Actual 2015 Actual $ 65,368 31,314 705 11,264 3,773 4,913 36,965 617 271 2,251 1,550 10,172 $ 91,057 39,882 20,000 5,901 6,791 56,027 1,018 367 2,524 2,000 17,219 3.42% 2.01% 0.00% 0.00% 1.79% 1.24% 9.89% -19.78% 4.29% -16.78% 0.00% 1.48% $ 142,853 $ 234,252 $ 169,165 $ 242,786 3.64% 1,898 1,473 12,661 16,725 1,536 1,286 1,697 917 - 87,980 37,591 918 6,296 3,683 3,582 11,808 4,593 992 1,652 4,162 882 66 60,630 27,975 31,266 2,085 6,385 7,572 980 6,756 6,745 19,789 953 4,650 1,096 1,030 387 257,113 29,750 35,000 500 8,850 1,000 6,500 1,300 1,000 8,000 16,700 1,806 10,204 4,000 760 1,000 64,614 23,618 26,742 86 5,296 6,015 10,237 650 1,798 5,939 17,373 921 8,675 898 115 - 106,209 29,000 35,600 500 8,850 1,000 6,500 1,300 1,000 7,000 18,050 1,806 8,573 2,500 760 1,000 -58.69% -2.52% 1.71% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -12.50% 8.08% 0.00% -15.98% -37.50% 0.00% 0.00% Operating Expense $ 181,912 $ 164,206 $ 178,299 $ 383,483 $ 172,977 $ 229,648 -40.12% Total Expenses $ 306,107 $ 243,236 $ 321,151 $ 617,735 $ 342,142 $ 472,434 -23.52% Operating Expense 3001 Contract. Serv. 4104 Telephone Services 4105 Utilities 4301 Auto/equip 4302 Building Maintenance 4303 Auction-related expenses 4304 Computer Maintenance 5501 DOC Labor 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6201 Postage 6401 Books/dues/subscrip 6501 Gas/oil/lube 6601 Uniforms 8108 Explorer Program 38,946 219 13,455 3,595 5,950 1,112 248 133 9,382 15,372 46,126 39,147 480 13,086 4,125 6,048 18,470 1,268 229 1,776 12,097 $ 124,195 $ 79,030 82,827 35,017 13,776 12,099 Section 3 - Page 21 BUD17 FINAL $ 2016 YTD 2017 2017 4/30/2016 Requested % Change 88,042 39,098 20,000 5,798 6,708 50,985 1,269 352 3,032 2,000 16,968 Personnel Expense 46,392 38,570 327 13,648 6,907 5,719 1,565 281 1,403 2016 Budget 7/21/2016 1:23 PM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 CAPITAL OUTLAY 2017 2017 Items Requested Approved* 2 replacement vehicles 1 patrol 1 invest 80,000 80,000 *Budgeted in RICO 2 replacement vehicles 1 patrol 1 invest 80,000 80,000 *Budgeted in GF Department 1801 12 Tablets w/docking station 51,276 51,276 *Budgeted in RICO 1 Interview Room 14,000 14,000 *Budgeted in RICO 17 Ballistic Vests 17,000 17,000 Gym Equipment 7,100 7,100 Taser 5,600 5,600 Total $ 249,376 $ 249,376 Section 3 - Page 21 BUD17 FINAL 7/21/2016 1:23 PM GENERAL FUND POLICE OPERATIONS 001-56041-421 pg 26 Account 2013 Actual Description Personnel Expense 1001 Salaries 1002 Salaries-Civilian 1005 Sal-OT 1006 Sal - Reimbursed OT 2001 OASI 2002 State Retire 2003 State Retire-PS 2004 Health Ins 2205 Income Protect 2006 Workman's Comp 2016 Self Fund Ins Claims Personnel Expense 2015 Actual 2016 Budget 2016 YTD 4/30/2016 2017 Requested 2017% Change 1,179,343 17,948 62,116 304,776 22,581 1,954 505,812 37,352 3,670 44,533 130,862 1,109,217 18,798 63,645 251,169 21,066 2,129 523,217 40,815 3,705 38,573 154,609 1,151,447 7,606 55,323 230,910 20,697 873 522,289 41,333 3,098 49,487 117,581 $ 1,195,498 29,964 70,000 315,341 25,214 3,401 846,997 37,226 4,266 53,059 148,733 $ 959,379 23,877 67,597 191,091 18,555 3,028 616,811 31,613 2,982 40,347 82,192 $ 1,302,936 30,415 70,000 315,341 26,807 3,449 1,000,334 40,645 4,620 45,525 153,463 8.99% 1.51% 0.00% 0.00% 6.32% 1.42% 18.10% 9.18% 8.29% -14.20% 3.18% $ 2,310,945 $ 2,226,944 $ 2,200,645 $ 2,729,701 $ 2,037,473 $ 2,993,535 9.67% 24,773 8,549 78,369 19,762 27,015 237 10,227 69,829 20,607 22,500 33,471 533 5,503 50,789 14,802 25,000 1 4,656 86,668 20,787 10,000 71,500 22,710 11.11% 0.00% 300.00% -4.67% 15.22% 105,098 $ 129,210 7.94% $ 2,142,571 $ 3,122,745 9.59% Operating Expense 4301 Auto/equip 4302 Maintenance Cost 5801 Travel/training 6501 Gas/oil/lube 6601 Uniforms BUD17 FINAL 2014 Actual Operating Expense $ 112,112 Total Expenses $ 2,423,058 $ 131,453 $ 2,358,397 $ 127,915 $ 2,328,560 Section 3 - Page 22 2,500 75,000 19,710 $ 119,710 $ 2,849,411 $ 7/21/2016 1:23 PM GENERAL FUND POLICE SUPPORT 001-56071-421 pg 27 Account 2013 Actual Description Personnel Expense 1001 Salaries 1002 Salaries-Civil 1005 Sal-OT 1006 Sal - Reimbursed OT 2001 OASI 2002 State Retire 2003 State Retire-PS 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Fund Ins Claims 2015 Actual 2016 Budget 452,690 330,674 117,783 186,278 40,205 46,095 246,528 26,403 3,148 19,756 90,509 484,480 339,032 30,367 232,832 39,782 47,231 266,641 28,433 3,571 21,790 127,094 434,179 306,723 32,982 182,329 34,906 42,470 227,114 24,049 2,238 21,281 85,660 $ 1,560,069 $ 1,621,253 $ 1,393,931 $ 1,986,834 4,032 28,840 9,027 6,318 1,661 27,282 8,733 4,441 2,983 22,037 8,011 5,000 2,000 16,000 9,440 Operating Expense 4301 Auto/equip 5801 Travel/training 6501 Gas/oil/lube 6601 Uniforms BUD17 FINAL 2014 Actual Operating Expense $ 41,899 Total Expenses $ 1,601,968 $ 43,994 $ 1,665,247 $ 37,473 $ 1,431,404 Section 3 - Page 23 $ $ 484,330 361,649 45,000 340,000 43,061 41,047 498,797 26,151 2,991 30,653 113,156 32,440 $ 2,019,274 2016 YTD 4/30/2016 $ -20.34% 1.61% 0.00% 0.00% -2.28% 1.52% -5.63% 6.26% -8.32% -27.95% -23.32% $ 1,021,994 $ 1,832,148 -7.79% 6,372 2,728 14,083 6,071 5,000 5,000 16,000 7,920 0.00% 150.00% 0.00% -16.10% 33,920 4.56% $ 1,866,068 -7.59% 29,255 $ 1,051,248 $ 2017 % Change 385,799 367,483 45,000 340,000 42,079 41,673 470,728 27,788 2,742 22,085 86,772 $ 251,771 264,631 29,474 133,330 28,436 36,264 201,596 14,054 1,825 13,365 47,248 2017 Requested $ 7/21/2016 1:23 PM GENERAL FUND POLICE HUMANE 001-56091-421 Account Description Personnel Expense 1002 Salaries-Civilian 1003 Salaries-Temp 1004 Salaries-Lim 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2205 Income Protect 2006 Workman's Comp 2016 Self Fund Ins Claims 2014 Actual 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 61,499 16,604 1,679 5,539 8,690 3,125 353 1,541 9,486 63,877 18,363 3,684 6,068 9,710 3,436 398 2,126 13,184 54,536 25,660 3,199 5,916 8,438 1,453 195 1,982 9,593 68,775 25,807 1,500 7,350 10,905 1,366 306 2,089 25,451 34,034 20,628 1,543 4,017 5,869 4,129 199 1,279 5,079 69,192 26,193 1,500 7,412 10,987 990 327 1,516 25,828 0.61% 0.00% 1.50% 0.00% 0.84% 0.75% -27.56% 7.03% -27.46% 1.48% $ 108,516 $ 120,845 $ 110,973 $ 143,550 $ 76,777 $ 143,944 0.27% 42,017 586 5,540 3,079 918 41,805 901 880 586 3,447 3,305 711 44,803 514 700 956 1,596 751 3,880 3,006 800 52,822 1,350 1,500 1,500 500 1,200 500 4,900 35 2,500 690 67,046 437 595 756 175 1,065 576 2,872 2,805 471 54,774 1,350 1,500 1,500 500 3,500 500 4,900 35 2,500 690 3.70% 0.00% 0.00% 0.00% 0.00% 191.67% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 53,769 $ 51,635 $ 57,005 $ 67,497 $ 76,796 $ 71,749 6.30% Total Expenses $ 162,285 $ 172,480 $ 167,978 $ 211,047 $ 153,574 $ 215,693 2.20% Personnel Expense Operating Expense 3001 Contractual Services 4104 Telephone Services 4301 Auto/equip 4302 Maintenance Cost 4303 Computer Maintenance 5801 Travel/training 6001 Office Supplies 6002 Operating Supplies 6401 Books/dues/subscrip 6501 Gas/oil/lube 6601 Uniforms BUD17 FINAL 2013 Actual 1,629 Section 3 - Page 24 7/21/2016 1:23 PM GENERAL FUND CALL CENTER 001-57081-419 pg 37 Account Description Personnel Expense 1001 Salaries 1004 Salaries - Limited 1005 Salaries O/T 2001 OASI 2002 State Retire 2004 Health Insurance 2005 Income Protect 2006 State Comp 2016 Self Fund Ins Claims 2014 Actual 2015 Actual 2016 Budget 4,060 3,980 615 875 239 29 311 284 8,642 25 663 979 581 46 405 885 8,714 667 1,000 539 30 364 695 9,114 697 1,034 599 36 389 787 $ 10,394 $ 12,225 $ 12,009 $ 12,657 22,741 8,872 17,785 829 - 15,071 8,440 14,946 1,994 - 4,439 8,215 16,193 - Operating Expense $ 50,227 $ 40,451 Total Expenses $ 60,620 $ 52,676 Personnel Expense Operating Expense 3001 Contract Serv 4105 Utilities 4302 Building Maintenance 4303 Computer Maintenance 5201 Liability Insurance 6002 Operating Supplies 6501 Gas/Oil/Lube 6502 Diesel/Oil 6701 Construction Materials 7831 IT Equipment 8512 Grant Match 8901 Depreciation BUD17 FINAL 2013 Actual 2016 YTD 2017 2017 4/30/2016 Requested % Change 7,056 540 801 447 27 304 491 9,252 708 1,049 588 39 343 798 1.51% 0.00% 0.00% 1.51% 1.42% -1.91% 6.62% -11.76% 1.46% $ 9,666 $ 12,776 0.94% 16,000 11,000 21,300 100 4,000 - 12,348 5,390 10,128 1,585 - -25.00% 0.00% 0.00% 0.00% -50.05% 0.00% 0.00% -50.00% 0.00% 0.00% 0.00% 0.00% $ 28,847 $ 52,400 $ 29,451 12,000 11,000 10,640 100 2,000 $ 35,740 $ 40,855 $ 65,057 $ 39,117 $ 48,516 -25.43% - Section 3 - Page 25 -31.79% 7/21/2016 1:23 PM GENERAL FUND CAPITAL EXPENDITURES 001-51801-419 Account Description 7701 7702 7703 7704 7705 7706 7707 7708 7711 7712 7713 7714 7716 7717 7718 7719 7720 7721 7723 BUD17 FINAL ADMINISTRATION FINANCE MANAGEMENT INFO SYSTEMS HUMAN RESOURCES MAGISTRATE COURT CEMETERY FIRE POLICE RECREATION PARKS AQUATICS PW ADMINISTRATION PW FLEET MAINTENANCE LIBRARY CD CONSTRUCTION VISITOR CENTER TRANSIT CALL CENTER MIS - COMPUTER REPLACEMENT 2013 Actual 2014 Actual 2015 Actual 531 20,413 7,649 1,100,060 23,479 7,400 - 2,364 974,855 60,000 89,819 - 20,799 141,564 1,963 10,830 4,922 - - - $ 1,334,688 $ 1,131,961 Section 3 - Page 26 $ 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 123,328 42,884 13,055 20,699 16,177 - 80,000 - 2,262 25,098 458 14,536 79 125,000 109,700 - - - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 37.13% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 216,143 $ 80,000 $ 42,434 $ 234,700 193.38% 7/21/2016 1:23 PM SPECIAL REVENUE FUNDS SUMMARY EXPENDITURES 2016 Budget BUD17 FINAL REVENUES 2017 Budgeted Difference 2017 Budget 2017 Budgeted % Change 2016 Comparison of Revenues VARIANCE 2017 Revenues 2017 Rev vs. Exp H. U. R. F. $ 1,307,411 $ 1,961,700 $ 654,289 50.04% $ 1,307,411 $ 1,311,700 $ (650,000) TRANSIT TRANSIT BISBEE TRANSIT TOTAL $ $ $ 930,670 930,670 $ $ $ 885,094 115,637 1,000,731 $ 70,060 7.53% $ 930,670 $ 979,728 $ (21,003) LTAF $ - $ - $ - 0.00% $ - $ - $ CAPITAL PROJECTS $ 472,121 $ 650,000 $ 177,879 37.68% $ 89,167 $ - $ DEBT FUND $ 1,315,624 $ 1,303,560 $ (12,064) -0.92% $ 1,315,624 $ 1,303,560 $ - MPC FUND $ - $ - $ - $ - $ - $ - RICO $ 175,450 $ 203,276 $ 27,826 15.86% $ 175,450 $ 203,276 $ - JCEF $ 19,292 $ 30,000 $ 10,708 100.00% $ 8,150 $ - $ (30,000) GRANTS $ 2,516,285 $ 2,274,369 $ (241,916) -9.61% $ 2,486,285 $ 2,267,869 $ (6,500) HOUSING $ 236,288 $ 171,915 $ (64,373) -27.24% $ 236,288 $ 171,915 $ (0) GRAND TOTALS $ 6,973,142 $ 7,595,551 $ 622,410 8.93% $ 6,549,046 $ 6,238,048 $ (1,357,504) Section 4 - Page 1 (650,000) 7/21/2016 1:23 PM HIGHWAY USERS REVENUE FUND 101-54041-433 pg 29 Account 2013 Actual Description Personnel Expense 1001 Salaries 1004 Sal-Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2007 Unemployment Ins. 2008 HR Processing 2016 Self-funding Ins Claims/fees Personnel Expense Operating Expense 3001 Contractual serv 3002 Auditor 4104 Telephone 4105 Utilities 4107 St. Lts-Electric/O&M 4301 Auto/Equip 4311 Heavy Equipment Repair 4312 Asphalt Plant Repairs 4703 Lease/Purchase Paymnt 5201 Insurance-Liability 5501 DOC Labor 5801 Travel/training 6002 Operating supplies 6301 Small tools 6302 Safety Equipment 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 6701 Construction material 6702 Signage 6704 Constr. Material Sales BUD17 FINAL $ 2014 Actual 360,935 2,536 26,000 37,721 14,298 1,737 25,870 384 46,996 516,477 2015 Actual 313,765 3,017 22,455 35,474 12,531 1,650 24,792 188 59,456 $ 473,328 $ 2016 Budget 2016 YTD 4/30/2016 2017 Requested 2017 % Change 235,469 3,278 17,387 24,998 9,518 755 15,504 180 26,021 $ 313,460 3,000 24,209 35,918 10,897 1,248 23,029 1,000 1,000 46,521 $ 181,216 1,948 13,298 20,789 7,047 694 11,686 305 17,215 $ 339,798 3,000 26,224 38,873 15,044 1,421 23,706 1,000 1,000 37,969 8.40% 0.00% 0.00% 8.32% 8.23% 38.06% 13.87% 2.94% 0.00% 0.00% -18.38% 333,112 $ 460,282 $ 254,200 $ 488,036 6.03% 19,360 2,430 1,200 50,000 180,000 10,000 10,000 8,000 24,080 8,000 2,000 1,000 2,500 1,500 12,000 9,500 2,100 346,562 10,000 20,000 -48.40% 0.87% -33.33% 0.00% 0.00% -33.33% -33.33% 0.00% 0.00% -16.39% 100.00% 300.00% 0.00% 66.67% 0.00% 0.00% -26.92% -25.00% -8.53% 0.00% 0.00% 9,113 2,357 2,473 39,672 179,411 7,767 18,343 9,954 22,291 18,191 2,409 2,591 48,421 183,196 7,952 5,539 21,122 25,000 7,953 2,490 2,034 41,402 170,664 8,289 9,794 6,330 24,830 37,522 2,409 1,800 50,000 180,000 15,000 15,000 8,000 28,800 386 1,126 610 676 11,626 16,690 4,901 112,493 5,434 - 235 15,355 140 332 12,471 12,170 2,676 173,516 6,826 56,170 750 1,494 1,186 9,873 9,698 1,516 60,318 10,665 1,574 500 1,000 1,500 1,500 12,000 13,000 2,800 378,899 10,000 20,000 Section 4 - Page 2 25,540 2,430 1,787 34,320 153,385 4,502 3,439 (24,551) 22,922 7,989 424 155 2,605 1,028 8,614 5,736 2,266 98,644 9,909 47,029 7/21/2016 1:23 PM HIGHWAY USERS REVENUE FUND 101-54041-433 pg 29 Account Description 7401 Capital Outlay 7531 St Light Trpl Res 9901 9915 9916 9917 2013 Actual 2014 Actual 2015 Actual - - 14,545 1,504 Operating Expense 445,326 594,313 386,908 Gen Fund Reimb Transfer to Grants Transfer to MPC Transfer to Debt Service 45,289 74,651 160,415 2,485 282,840 42,136 160,646 14,425 217,207 $ 1,244,643 $ 1,284,848 Total Expenses $ 2016 Budget 2016 YTD 4/30/2016 2017 Requested 2017 % Change 18,000 - 15,996 - 797,730 $ 424,169 $ 1,425,232 78.66% 34,153 160,529 13,592 208,274 35,808 34,841 -2.70% 13,592 49,399 26,032 11,327 37,359 13,592 48,432 0.00% 0.00% -1.96% 928,294 $ 1,307,411 $ 715,728 $ 1,961,700 50.04% $ 705,000 3816.67% 0.00% CAPITAL OUTLAY Items 2017 Requested 1 Paint Stripping Machine 6,000 2 UPS Inverter Battery Pack for Traffic Signals 12,000 Street Improvements 650,000 Dump Truck 37,000 Total $ 705,000 BUD17 FINAL 2017 Approved $ 6,000 12,000 650,000 37,000 705,000 Section 4 - Page 2 7/21/2016 1:23 PM TRANSIT 102-52009-419 pg 18 Account Description Personnel Expense 1001 Salaries 1003 Salaries/Temp 1004 Salaries LTD 1005 Salaries Overtime 2001 O.A.S.I. 2002 Retire-State 2004 Health Insurance 2005 Income Protection 2006 Workman's Compensation 2007 Unemployment Insurance 2008 HR Processing 2016 Self Funding Ins Claims/Fees Personnel Expense Operating Expense 3001 Contractual Services 4104 Telephone 4105 Utilities 4301 Auto & Equipment 4302 Building Maintenance 4303 Computer Maintenance 5201 Liability Insurance 5401 Advertising & Printing 5801 Travel & Training 6001 Office Supplies 6002 Operating Supplies 6201 Postage 6401 Books/Dues/Subscriptions 6501 Gas/Oil/Lubricants 6601 Uniforms Operating Expense 7401 7402 8003 8901 Machinery Vehicles Contingency Depreciation Total Expenses 2013 Actual 2014 Actual 59,751 11,522 94,353 2,268 12,396 17,016 14,922 668 5,294 58,812 24,321 112,747 1,793 14,381 20,181 12,329 867 5,804 941 11,642 2015 Actual 2016 Budget $ 110,013 197,880 5,988 24,012 35,626 17,422 1,229 6,665 238 30,313 71,224 19,866 113,823 3,060 15,090 21,492 9,541 619 5,375 444 910 30,953 $ 230,773 $ 281,784 $ 292,399 $ 449,324 8,199 5,016 226 7,636 44 4,534 688 3,214 1,098 791 147 11,985 5,832 2,702 11,599 1,034 6,361 425 5,916 550 360 28 11,000 6,500 3,500 18,000 1,778 1,500 8,000 8,000 4,500 1,500 4,000 100 29,287 1,247 - 44,541 858 - 9,838 5,653 2,622 15,699 84 108 6,672 1,958 2,977 713 1,565 117 42,361 1,571 - $62,127.83 $0.00 $0.00 $ $ 92,190 $0.00 2016 YTD 4/30/2016 2017 % Change 73,014 112,618 1,432 13,928 22,715 10,940 626 3,741 2,400 515 17,999 $ 139,703 248,134 5,988 30,128 44,660 22,054 1,625 6,926 4,392 45,642 26.99% 0.00% 25.40% 0.00% 25.47% 25.36% 26.59% 32.22% 3.92% 0.00% 205.00% -6.95% 259,928 $ 549,252 22.24% 6,021 6,480 2,412 17,000 3,000 1,500 7,692 5,000 1,400 1,020 8,150 150 46,000 2,000 - $4,332 4,911 1,962 10,676 99 313 6,663 2,729 2,638 498 963 154 28,421 344 - 55,000 2,040 - -45.26% -0.31% -31.09% -5.56% 68.73% 0.00% -3.85% -37.50% -68.89% -32.00% 103.75% 50.00% 0.00% 19.57% 2.00% 0.00% 91,937 $ 116,378 $64,701.61 $ 116,865 0.42% $0.00 $ 177,086 $ 176,084 $ 11,798 $ $364,968 $1,295.63 $1,295.63 $ 49,866 $ 147,000 $ 22,111 $ $218,977 -71.84% -16.52% 87.41% 0.00% -40.00% $ 384,335 $ 930,670 325,925 $ 885,094 -4.90% $ $ $ 2017 Requested 1,440 49,050 $ $ 292,901 $ 373,974 $ Items 2017 Requested 2017 Approved* *Budgeted in GF Department 1801 6 Bicycle Racks 6 Bus Wraps 6 Mobile Base System 1 Bus Total 12,690 15,000 22,176 147,000 $ 196,866 12,690 15,000 22,176 147,000 $ 196,866 CAPITAL OUTLAY BUD17 FINAL Section 4 - Page 3 7/21/2016 1:23 PM TRANSIT BISBEE 102-52010-419 pg 18 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Salaries/Temp 1004 Salaries LTD 1005 Salaries Overtime 2001 O.A.S.I. 2002 Retire-State 2004 Health Insurance 2005 Income Protection 2006 Workman's Compensation 2007 Unemployment Insurance 2008 HR Processing 2016 Self Funding Ins Claims/Fees Personnel Expense $ Operating Expense 3001 Contractual Services 4104 Telephone 4105 Utilities 4301 Auto & Equipment 4302 Building Maintenance 4303 Computer Maintenance 5201 Liability Insurance 5401 Advertising & Printing 5801 Travel & Training 6001 Office Supplies 6002 Operating Supplies 6201 Postage 6401 Books/Dues/Subscriptions 6501 Gas/Oil/Lubricants 6601 Uniforms 8003 Contingency - $ 2015 Actual $ - Operating Expense Total Expenses 2014 Actual - 2016 Budget $ - - 2016 YTD 4/30/2016 2017 2017 Requested % Change $ 994 50,871 2,067 3,867 6,008 1,196 157 1,150 599 6,403 $ 17,219 0.00% 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 0.00% 0.00% 100.00% 73,313 $ 111,387 100.00% - $0 960 304 172 116 260 119 1 895 - 1,700.00 600.00 250.00 200.00 400.00 200.00 900.00 - 0.00% 100.00% 100.00% 0.00% 0.00% 100.00% 0.00% 0.00% 100.00% 100.00% 100.00% 0.00% 0.00% 0.00% 100.00% 0.00% $2,827 $ 4,250 100.00% 76,140 $ 115,637 100.00% $ - - $0.00 $ - $ - $ - - $ - $ - $ - $ $ 75,852 1,000 5,879 8,715 404 318 2,000 CAPITAL OUTLAY BUD17 FINAL Items 2017 2017 Requested Approved* Total $ - $ - Section 4 - Page 4 7/21/2016 1:23 PM LOCAL TRANSPORATION ASSISTANCE FUND (LTAF) 102-54042-433 pg 31 Account Description Operating Expense 5231 Cultural Purposes 5235 LTAF II Grant 6701 Construction material 9901 Transfer to GF 9902 Transfer to HURF 9906 Transfer to Airport Total Expense BUD17 FINAL 2013 Actual 2014 Actual 211,937 $ 211,937 2015 Actual $ - 2016 Budget $ Section 4 - Page 5 - $ 2016 YTD 2017 2017 4/30/2015 Requested % Change - - - - - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% - $ - $ 7/21/2016 1:23 PM CAPITAL PROJECTS FUND 103-51081-419 pg 33 Account 7402 7603 7606 7608 7609 7610 7614 7615 7616 7622 7623 7624 7626 7627 7628 7629 7631 7632 7633 8099 9915 9917 Description Vehicles Park Ramadas PW Facility Parks Lighting Program Parks Improvements 3rd Street Extension Douglas Apartments Street Paving Sidewalks Capital Outlay Purchase Airport Improvements Police Building Improvement Government Plaza Call Center City Hall Improvements Rivera Building Proj Port of Entry Health Dept Bldg Impr Probation Building Reserve Funding Transfer to Grants Transfer to Debt Serv Total Expenses BUD17 FINAL 2013 Actual $ 2014 Actual 2015 Actual 2016 Budget - - 47,396 - - - - 199,087 4,175 114,421 14,163 472 636,476 108,737 14,716 64,133 12,831 15,940 47,992 44,096 4,219 14,637 66,615 176,285 - 64,099 - - 203,174 $ 112,247 $ 1,335,068 Section 4 - Page 6 2016 YTD 4/30/2016 - - 47,449 3,833 1,900 40,278 24,024 6,708 3,719 9,037 2,200 5,945 22,615 253 64 - 472,121 $ 168,026 - 472,121 - $ 2017 2017 Requested % Change - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 37.68% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 650,000 37.68% - 650,000 - $ 7/21/2016 1:23 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2016-2017 AMOUNT AMOUNT REQUESTED RECOMMENDED TYPE $25,000 $25,000 Facilities $7,000 $7,000 Facilities $5,000 $5,000 Facilities $20,000 $20,000 Facilities $28,400 $0 Facilities $7,000 $7,000 Facilities $15,000 $15,000 Facilities $107,400 $79,000 DEPT Administration Fire Visitor Center Public Works Airport Parks Parks ITEM/PROJECT City Hall Bathroom Renovation Exterior Wall repair and paint Doors Barn Facility Removal of Bldgs Airport Park Ramadas Airport Park Walkway Extension Fire Fire Fire Fire Fire Fire Fire Cemetery Parks Parks Parks Recreation Aquatics Aquatics Aquatics Aquatics PW Construction Fleet Maint. Library Library Library Library Library Administration New Roof 25,000 2 Rescue Tools (Jaws of Life) 30,000 SCBA Air filling cascade system $45,000 2 Cardiac monitors $65,000 Ambulance $125,000 Type 6 Quick Attack Vehicle $80,000 A/C Replacement $20,000 Chip Seal project $40,000 4 Bleachers $7,000 Ground Leveling Lower Fields at Airport Park $13,000 Ramada Replacement $0 Tables & Chairs with Cart for Events $5,000 ADA Doors $5,000 Artificial Grass for Outdoor play area $18,000 Facility Furniture $12,000 Shading over whale tail splash pad $30,000 Roof on 7th Street Building $30,000 Vehicle Code Scanner $5,000 2 Automatic Doors for North and South Entrance $15,000 Roofing Materials $5,000 Exterior Painting $25,000 Purchase Chase Building $275,000 Furnishing and Equipping Building $100,000 City Website Development & Design $20,000 $995,000 TOTAL BUD17 FINAL $1,102,400 Section 4 - Page 6A $25,000 $15,000 $45,000 $65,000 $125,000 $80,000 $13,800 $20,000 $7,000 $13,000 $18,200 $5,000 $5,000 $12,000 $12,000 $15,000 $25,000 $5,000 $15,000 $5,000 $25,000 $0 $0 $20,000 $571,000 Carryover from FY 2015/2016 Carryover from FY 2015/2016 Carryover from FY 2015/2016 Carryover from FY 2015/2016 Carryover from FY 2015/2016 Carryover from FY 2015/2016 Carryover from FY 2015/2016 Facilities Equipment Equipment Equipment Vehicles Vehicles Equipment Infrastructure Equipment Facilities Facilities Equipment Facilities Facilities Equipment Facilities Facilities Equipment Facilities Facilities Facilities Facilities *Down payment, rest will be leased Equipment Other $650,000 7/21/2016 1:23 PM DEBT SERVICE FUND 108-51547-419 pg 33 2013 Actual Account Description Leases/Loans 4703 4705 4706 4709 4710 4713 4714 4703 Lease/Purchase 11,184 Lease/Purch Ambulance/Chase Bldg PW Facility (Phase I) IT Upgrades Lease 264,283 GADA Loan 236,264 Fire Ladder Truck 9,792 IDA 40,000 IT Upgrades Lease 2013 Total Leases/Loans Call Center Loans 4711 Call Center Equipment 4712 Call Center Building Total Expenses Total Leases & Call Center $ 561,523 2014 Actual 2015 Actual 22,369 281,941 234,974 170,586 40,000 $ 749,870 2016 Budget 22,369 215,530 235,172 170,586 60,000 $ 703,656 $ 2016 YTD 4/30/2016 22,369 233,925 170,586 20,000 215,530 215,530 51,960 170,586 - 662,410 $ 460,444 2017 2017 Requested % Change 22,369 $ 22,369 30,000 233,725 170,586 215,530 0.00% 100.00% 0.00% 0.00% -0.09% 0.00% -100.00% 0.00% 672,210 1.48% 500,878 595,927 $1,096,805 696,086 $696,086 674,680 $674,680 653,214 $653,214 139,988 $139,988 631,350 $631,350 0.00% -3.35% -3.35% $1,658,328 $1,445,956 $1,378,337 $1,315,624 $600,432 $1,303,560 -0.92% Transfers 9904 Transfer to Capital Projects Total Debt Service Fund Bond Payments 4701 MPC Bond Payment New Bond Total Bonds TOTAL DEBT SERVICE BUD17 FINAL 304077.01 $ - $ 1,658,328 $ 1,445,956 $ 1,682,414 $ 1,315,624 $ $ $ $ $ $ $ $ 486,106 - 1,047,629 486,806 - 1,236,676 Section 4 - Page 7 486,450 - 1,190,106 - 1,315,624 304,077 $ $904,509 $ $ - 460,444 - 0.00% $ 1,303,560 100.00% $ 1,303,560 0.00% 0 -0.92% 7/21/2016 1:23 PM RICO 104-56003-421 pg 90 Account Description 2008 3001 4301 5801 7402 7403 7404 8003 Human Resources Processing Contractual Services Auto & Equipment Maintenance Travel & Training Vehicles Furniture & Fixtures Equipment Contingencies Transfer to GF 8201 RICO St Atty General 8202 RICO-County Attorney 8203 RICO-Towing Services Total Expenses 2013 Actual 2014 Actual 2,951 1,518 10,726 7,647 9,908 82,689 43,995 173 2,250 23,847 65,325 2,996 21,617 25,968 8,412 18,000 - 40,106 9,662 - $ 185,845 $ 191,945 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 170 0 0 4,550 1,000 5,269 1,000 3,314 1,000 $ 1,000 20,413 $ 10,000 22,388 $ 10,000 165,678 80,000 80,000 18,770 37,450 27,296 65,276 (769) 26,000 8,631 26,000 0 2,195 6,000 20,000 6,535 20,000 - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 74.30% 0.00% 0.00% 0.00% 0.00% 0.00% *** $ 203,276 15.86% $ 218,125 $ 175,450 $ 72,315 ***Budgeted expenses will only be expended if the money is available Section 4 - Page 8 7/21/20161:23 PM JCEF 105-51603-412 pg 90 Account 2013 Actual Description 1015 3003 8005 8007 8010 Project Related Salaries County Trainer Cost SHR JCEF - Allowable expenses JCEF Court Approved Exp MCEF court approved ex Court Consolidation 9901 Transfer to General Fund Total Expenses $ 2014 Actual 1,638 11,952 381 $ 2015 Actual 1,748 220 11,739 126 $ 2016 Budget 1,572 575 10,670 3,562 $ 2,000 - - - 14,792 2,500 - $ 13,971 $ 13,833 $ 16,379 $ 19,292 Section 4 - Page 9 2016 YTD 2017 4/30/2016 Requested $ 931 9,439 82 - $ 10,452 $ - 2017 % Change 30,000 - 0.00% -100.00% 0.00% -100.00% -100.00% 100.00% 0.00% 0.00% $ 30,000 55.50% 7/21/20161:23 PM GRANTS 106 pg 33 Account 2013 Actual Description Housing & Comm Development Fire Police Public Works Library Transfer to GF Transfer to Housing Total Expenses Grants Requiring Match BUD17 FINAL $ 2014 Actual 2015 Actual 2016 Budget 2016 YTD 4/30/2016 2017 Requested 2017 % Change 317,834 11,700 56,443 286,171 882 200,655 23,535 134,788 3,232 151,899 319,953 2,224 873,511 63,810 71,417 17,631 46,137 1,309,212 75,373 174,200 880,000 77,500 9,466 7,973 6,716 106,069 1,489 1,309,212 384,236 78,421 450,000 52,500 - - - - - 0.00% 409.78% -54.98% -48.86% -32.26% 0.00% 0.00% 897,219 $ 612,097 $ 1,072,507 $ 2,516,285 $ 131,714 $ 2,274,369 -9.61% Match Amount AFG - Equipment $ 6,300 TOTAL MATCH $ 6,300 Section 4 - Page 10 7/21/2016 1:23 PM HOUSING 501-51101-463 PERSONNEL EXPENSE pg 90 Account 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2016 Description 2013 Actual 2014 Actual 2015 Actual Salaries Salaries - Temp Salaries - Ltd Salaries-Overtime O.A.S.I. Retirement-State Health Ins Income Protect Ins Workman's Comp Unemployment Insurance Self-funding Ins Claims/fees 148,815 13,545 62,236 1,067 15,958 23,903 (34) 927 6,100 (25) 23,054 137,710 13,421 59,356 812 14,871 23,600 4,503 981 6,176 31,533 129,897 $ 119,886 2,769 $ 13,373 46,325 41,704 768 12,743 13,385 20,274 19,496 4,691 5,411 540 657 5,039 5,054 (180) 20,851 17,322 $10,972 $3,004 $0 $ 306,518 $ 295,968 $ 243,717 2016 Requested 2016 Approved Funded from Special Projects 7402 Capital Outlay Total Expenses 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change $ 93,570 $ 16,704 160 8,018 12,194 2,951 357 3,307 8,878 $ 104,474 $ 4,186 18,591 9,735 13,956 3,061 519 3,009 14,384 -12.86% -68.70% -55.42% 0.00% -27.27% -28.42% -43.42% -21.06% -40.47% 0.00% -16.96% $0 $0 $0 100.00% $ 236,288 $ 146,139 $ 171,915 -27.24% CAPITAL OUTLAY 0 0 Total $ - $ - Section 4 - Page 11 7/21/20161:23 PM ENTERPRISE FUNDS SUMMARY EXPENSES 2016 Budget REVENUES 2017 Budgeted Difference 2017 Budget 2017 Budgeted % Change 2016 Comparison of Revenues SANITATION $ 1,202,700 $ 2,017,721 $ 815,021 67.77% $ WATER WATER OFFICE WATER FIELD $ $ 244,910 1,418,418 $ $ 245,971 1,566,029 $ $ 1,061 147,610 0.43% 10.41% WATER CAPITAL REINVESTMENT WATER TOTAL $ $ 442,337 2,105,666 $ $ 210,000 2,022,000 $ $ (232,337) (83,665) WASTE WATER TOTAL SEWER CAPITAL REINVESTMENT $ $ $ 1,647,545 1,312,455 2,960,000 $ $ $ 1,780,500 285,000 2,065,500 $ $ $ AIRPORT $ 159,762 $ 147,093 GOLF GOLF COURSE BAR & RESTAURANT $ $ - $ $ 93,938 71,062 $ - $ 165,000 $ 6,428,128 $ 6,417,314 GRAND TOTALS VARIANCE 2017 Revenues 2017 Rev vs. Exp 1,202,700 $ 1,214,500 $ (803,221) -52.52% -3.97% $ 2,105,666 $ 2,022,000 $ (0) 132,955 (1,027,455) (894,500) 8.07% -78.28% -30.22% $ 2,960,000 $ 2,065,500 $ (0) $ (12,669) -7.93% $ 159,762 $ 147,093 $ - $ 165,000 0.00% $ - $ 165,000 $ - $ (10,813) -0.17% $ 6,428,128 $ 5,614,093 $ (803,221) 7/21/2016 1:23 PM BUD17 FINAL Section 5 - Page 1 WATER OFFICE 410-54051-432 pg 83 Account 2013 Actual Description Personnel Expense 1001 Salaries 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self Funding Ins Claims/Fees 2014 Actual 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 48,706 153 3,536 5,321 3,072 248 110 4,263 50,417 839 3,854 5,826 2,443 272 151 6,711 51,946 217 3,749 5,687 2,376 180 117 5,383 $ 53,010 500 4,094 6,073 2,560 211 120 7,388 $ 41,909 60 3,036 4,763 1,650 161 94 3,516 $ 55,636 500 4,294 6,366 2,452 233 105 7,497 4.95% 0.00% 4.91% 4.81% -4.24% 10.26% -12.53% 1.47% 65,410 $ 70,514 $ 69,655 $ 73,957 $ 55,189 $ 77,082 4.23% 36,972 4,540 129 6,913 26,797 26 16,393 30,717 - 47,518 4,598 74 6,960 437 34,783 181 11,464 37,495 - 46,127 4,796 2,564 6,868 950 36,974 16 19,659 40,662 - 16,800 4,800 2,600 7,000 2,300 34,800 2,000 23,600 40,700 540 22,781 4,709 1,726 5,883 331 34,117 852 2,057 11,164 30,670 21,800 4,800 2,100 7,500 800 34,800 2,000 12,300 16,040 390 29.76% 0.00% -19.23% 7.14% -65.22% 0.00% 0.00% -47.88% -60.59% -27.78% Operating Expense $ 122,487 $ 143,511 $ 158,617 $ 135,140 $ 114,291 $ 102,530 -24.13% 7401 Capital Outlay 8001 Bad Debt Expense 9901 Gen. Fund Reimb. 12,381 19,174 31,199 11,756 36,692 5,000 30,813 19,310 25,560 5,000 61,359 100.00% 0.00% 99.13% Personnel Expense $ Operating Expense 3001 Contractual services 3002 Auditing Services 4104 Telephone 4105 Utilities 4303 Computer Maintenance 5201 Insurance-Liability 5801 Travel/training 6001 Office Supplies 6601 Postage 6601 Uniforms 5,009 (1,128) 32,583 Other $ 62,753 $ 48,448 $ 36,465 $ 35,813 $ 44,870 $ 66,359 85.29% Total Expenses $ 250,650 $ 262,473 $ 264,736 $ 244,910 $ 214,349 $ 245,971 0.43% 2017 Requested 2017 Approved CAPITAL OUTLAY Payment Kiosk Total BUD17 FINAL $ 30,000 30,000 $ 0 - Section 5 - Page 2 7/21/2016 1:23 PM WATER FIELD 410-54053-432 pg 84 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Salaries-Temporary 1004 Salaries-Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2007 Unemployment Ins. 2008 HR Processing 2016 Self-Fundung Ins Claims/Fees Personnel Expense 265,156 3,980 11,109 20,579 30,637 17,773 1,389 9,683 1,214 24,258 $ Operating Expense 3001 Contractual services 4104 Telephone 4105 Utilities 4301 Auto/Equip 4302 Building Maintenance 4303 Computer Maintenance 4311 Heavy Equipment Repairs 4321 Water Production Maintenance 4322 Water Distribution Maintenance 4323 Water Quality Maintenance 4703 Lease/Purchase Bldg/Equip Debt Service 5202 Insurance Claims 5401 Advertising/Printing 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6301 Small tools 6302 Safety Equipment 6401 Books/Dues/Subscrip 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 6701 Construction material Operating Expense BUD17 FINAL 2014 Actual $ 385,778 2015 Actual 276,596 92 7,746 21,733 33,152 16,554 1,504 9,917 267 33,094 $ 400,656 $ 2016 Budget 2016 YTD 4/30/2016 $ 304,630 10,000 24,069 35,711 16,056 1,221 21,841 3,000 1,000 32,945 $ 197,387 10,813 7,040 15,616 24,225 8,813 777 14,785 300 225 18,724 $ 395,438 11,000 31,093 46,090 18,006 1,664 20,621 3,000 1,000 46,680 29.81% 0.00% 0.00% 10.00% 29.18% 29.07% 12.14% 36.27% -5.59% 0.00% 0.00% 41.69% 399,320 $ 450,474 $ 298,705 $ 574,591 27.55% 8,773 6,000 360,000 8,000 1,000 3,000 60,000 70,000 40,000 99,098 2,000 1,500 5,000 1,000 1,200 2,500 3,000 1,300 19,000 4,000 3,150 - -27.13% 20.00% 9.09% 14.29% 0.00% 0.00% 100.00% 0.00% 9.38% 0.00% -100.00% 0.00% 0.00% 0.00% 42.86% 0.00% 0.00% 400.00% 100.00% 0.00% 0.00% 300.00% 28.57% 0.00% 699,521 -5.61% 7,980 4,626 411,146 5,791 1,375 4,835 5,928 364,217 5,773 17 877 12,040 5,000 330,000 7,000 1,000 40,697 57,264 24,648 33,653 525 922 3,531 1,200 3,038 497 1,042 2,199 19,815 640 2,359 - 29,406 54,388 37,862 33,111 1,027 2,966 1,227 616 463 521 443 20,559 986 2,738 - 89,846 51,329 26,233 32,513 2,996 879 783 1,012 1,154 195 14,577 495 2,783 - 60,000 64,000 40,000 88,000 99,098 2,000 1,500 3,500 1,000 1,200 500 1,500 1,300 19,000 1,000 2,450 - 5,638 4,357 302,651 7,950 298 71 40,113 42,444 11,243 15,204 360 705 847 696 575 1,063 380 9,768 301 2,658 - 741,088 $ 447,322 $ 617,233 $ 2017 % Change 287,488 7,857 21,839 31,562 14,999 958 9,015 175 25,426 11,376 2,818 332,782 5,445 1,260 - 545,711 2017 Requested 606,442 Section 5 - Page 3 $ $ 7/21/2016 1:23 PM WATER FIELD 410-54053-432 pg 84 Account 2013 Actual Description 7401 7826 7997 8901 9901 9915 9917 Capital Outlay CIP Impact Fees CONTRA Interest Depreciation Transfer to GF Transfer to Grants Transfer to Debt Service 2014 Actual 5,810 (33,653) 430,217 2,485 Total Capital Outlay $ 404,859 Total Expenses $ 1,336,348 2015 Actual 29,921 455,506 52,240 $ 537,667 2016 Budget 14,545 488,095 48,077 $ 550,717 $ 1,555,555 $ 1,556,479 2017 Requested 2017 Approved $ 2016 YTD 4/30/2016 2017 Requested 2017 % Change 5,000 - 3,040 - 15,400 - 173,780 - 228,440 48,077 40,064 48,077 208.00% 0.00% 0.00% 31.45% 0.00% 0.00% 0.00% 291,917 28.68% $ 1,566,029 10.41% 226,857 $ 1,418,418 $ 43,104 $ 789,130 $ CAPITAL OUTLAY Items 1 Chlorine Building Safety Barricades 0 Total BUD17 FINAL $ 10,400 5,000 15,400 $ Section 5 - Page 3 10,400 5,000 15,400 7/21/2016 1:23 PM Water Capital Reinvestment 410-54055-432 pg 85 Account Description Personnel Expense 1001 Salaries- Regular 1003 Salaries- Temp 1004 Salaries- Lim 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Insurance 2005 Income Protection 2006 State Comp 2016 Self-Funding Ins Claims/Fees Personnel Expense Operating Expense 3001 Contractual Services 4104 Utilities/Telephone 4301 Auto/Equip 4311 Heavy Equipment Repair 5301 Communications 5801 Travel & Training 6001 Office supplies 6002 Operating Expenses 6301 Small tools 6302 Safety Equipment 6401 Books/Dues/Subscriptions 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 9901 Gen. Fund Reimb 8003 Contingency Operating Expense 7401 7802 7809 7810 7811 7818 BUD17 FINAL Water CIP Capital Outlay SCADA Control System 3rd. St. Water Line Extension Misc. Projects-Master Plan Rehabilitation Reservoir Fairview Water (BECC) 2013 Actual 2014 Actual 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 79,255 - 66,947 - 72,624 - $ 80,343 - $ 1,800 6,406 9,504 3,655 327 4,430 6,624 $ 30,186 2,615 1,447 2,578 3,681 1,625 113 2,190 1,771 - -100.00% 0.00% 0.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% 1,222 6,153 8,424 4,559 395 2,524 1,664 957 5,152 7,852 3,501 344 2,189 6,534 621 5,359 7,745 3,297 229 1,933 5,469 $ 104,195 $ 93,477 $ 97,276 $ 113,090 $ 46,207 $ - -100.00% 29,138 30,956 7,854 9,943 188 2,444 97 481 7,804 4,799 5,945 5,910 1,256 35,225 - 1,225 449 493 3,007 2,780 5,609 4,678 1,037 41,547 - 31,472 811 7,127 919 2,594 95 328 2,882 2,853 5,336 1,096 1,046 36,930 - 0 - -100.00% 0.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% 0.00% -100.00% -100.00% -100.00% -100.00% 0.00% 5,500 4,500 1,050 34,886 - $ 101,141 $ 101,725 $ 93,489 $ 84,248 $ 61,972 - -100.00% 2,953 - 5,616 - 9,088 - - - -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 18,262 3,000 5,000 1,000 2,000 450 600 3,500 4,500 5,000 Section 5 - Page 4 - 13,323 757 6,685 90 208 77 267 589 3,446 2,734 4,171 649 28,978 - - 7/21/2016 1:23 PM Water Capital Reinvestment 410-54055-432 pg 85 Account Description 7820 7821 7822 7824 7825 7827 7829 7830 2014 Actual 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change Well 16 Equiping (Arsenic Compliance) Rehab Existing Wells 16,944 46,683 Arsenic Compliance 300K Gallon Elevated Tanks-Rehab364,096 16" Geronimo Trail Tansmission Main Replacement W & WW System Improvements, Phase II Well 17 (Arsenic Compliance) 550,408 8,064 Sunnyside Improve - 26,144 - 180,000 - - 30,844 - Capital Projects 245,000 $ 442,337 7999 Fixed Assets 8003 Contingency Total Expenses BUD17 FINAL 2013 Actual 934,401 60,363 35,233 (990,961) (103,491) (35,233) (9,448) $ 148,777 $ 152,074 $ 181,318 Section 5 - Page 4 60,000 30,000 - 0.00% -50.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 30,844 210,000 -14.29% $ 139,022 $ 210,000 -52.52% 180,000 7/21/2016 1:23 PM WASTEWATER 420-54061-432 pg 87 2013 Actual Account Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Lim 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2007 Unemployment Ins. 2008 HR Processing 2016 Self Funding Ins Claims/Fee 2014 Actual 251,368 3,980 4,262 18,302 27,308 13,646 1,251 7,725 28 23,985 $ 351,856 2015 Actual 282,411 3,906 19,888 32,037 10,488 1,453 9,481 243 50,981 $ 410,889 $ 2016 Budget 2016 YTD 4/30/2016 2017 Requested 2017 % Change 280,177 1,948 2,767 20,510 29,720 10,149 903 8,489 1,267 32,321 $ 289,496 8,000 22,758 33,766 9,935 1,159 9,709 1,000 1,000 41,040 $ 197,232 13,432 2,586 15,515 24,032 8,317 781 7,532 300 30 19,568 $ 305,651 8,000 23,994 35,568 11,253 1,286 7,145 1,000 1,000 37,519 5.58% 0.00% 0.00% 0.00% 5.43% 5.34% 13.27% 10.95% -26.41% 0.00% 0.00% -8.58% 388,253 $ 417,862 $ 289,325 $ 432,416 3.48% 20,596 2,498 2,500 90,000 5,000 2,000 27,738 2,535 3,055 78,122 6,632 1,200 21,360 50,472 30,227 63,169 0 0 84,595 324 200 4,575 15,246 0 612 1,075 137 6,327 6,207 22,387 2,583 3,500 60,000 5,000 2,000 8.70% 3.40% 40.00% -33.33% 0.00% 0.00% 0.00% 0.00% 0.00% -46.85% -14.59% 0.00% -100.00% 0.00% 0.00% 132.11% 0.00% -14.29% 100.00% 0.00% 0.00% 2444.44% -9.09% -15.38% Requesting Reclass of Cloo Te Operating Expense 3001 3002 4104 4105 4301 4302 4303 4324 4703 5201 5202 5301 5502 5801 6001 6002 6021 6201 6301 6302 6401 6501 6502 BUD17 FINAL Contractual serv Auditing Services Telephone Utilities Auto/Equip Building Maintenance Computer Maintenance Sewer System Maint Lease/Purchase Bldg/Equip Debt Service Insurance-Liability Insurance-Claims Communications Transfer Expense Travel/training Office supplies Operating supplies Chemicals Postage Small tools Safety Equipment Books/Dues/Subscrip Gas/oil/lube Diesel/oil/lube 44,288 2,445 2,504 100,836 10,620 16,815 38,894 2,446 3,800 99,071 8,320 108 33,234 6,015 92,918 68,207 150 133,762 1,558 2,740 5,764 25,905 38,786 2,582 2,877 89,371 4,313 490 474 32,074 5,512 68,985 66,392 118,912 3,017 1,042 9,275 25,988 38,272 2,955 85,547 60,944 69,401 3,356 666 19,983 19,142 40,000 81,260 640,260 77,700 2,500 1,000 100,000 3,000 2,541 8,000 35,000 1,267 1,247 756 11,729 10,131 114 221 361 11,230 11,255 945 924 374 10,506 10,422 800 950 450 11,000 13,000 Section 5 - Page 5 40,000 81,260 340,289 66,360 2,500 100,000 3,000 5,898 8,000 30,000 14,895 800 950 11,450 10,000 11,000 7/21/2016 1:23 PM WASTEWATER 420-54061-432 pg 87 2013 Actual 1,808 1,289 $ 506,001 Account Description 6601 Uniforms 6701 Construction Materials Operating Expense 7401 7826 7997 8001 8903 8901 9901 9917 Capital Outlay Impact Fee CONTRA Interest Bad Debt Expense Contingency Depreciation Gen. Fund Reimb. Transfer to Debt Service Transfer to Water Total Capital Outlay Total Expenses 2014 Actual 1,730 194 $ 547,997 291,384 (85,547) 4,136 119,744 12,817 468,582 27,173 2,485 708,213 506,020 39,603 14,435 692,619 $ 1,566,070 $ 1,651,505 2015 Actual 1,419 653 $ 495,335 2016 2016 YTD 2017 2017 Budget 4/30/2016 Requested % Change 2,100 1,938 2,100 0.00% 2,000 172 2,000 0.00% $ 1,144,155 $ 405,917 $ 825,972 -27.81% 4,848 2,894 (18,939) 518,974 37,411 13,592 558,780 - 4,635 32,967 13,592 29,333 85,527 16,773 29,868 11,327 57,968 $ 1,442,367 $ 1,647,545 $ 753,210 2017 Requested 25,000 $ 25,000 2017 Approved 25,000 $ 25,000 5,000 25,000 - 100.00% 0.00% 5,000 0.00% 416,104 62,416 13,592 522,112 8877.43% 89.33% 0.00% 0.00% 510.46% $ 1,780,500 8.07% CAPITAL OUTLAY Items Work Truck 0 0 Total BUD17 FINAL Section 5 - Page 5 7/21/2016 1:23 PM Sewer Capital Reinvestment 420-54065-432 pg 88 pg 88 Account 2013 Actual Description Personnel Expense 1001 Salaries - Regular 1003 Salaries- Temp 1004 Salaries- Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Insurance 2005 Income Protection 2006 State Comp 2016 Self Funding Ins Claims/Fees Personnel Expense Operating Expense 3001 Contractual Services 4104 Utilities/Telephone 4301 Auto/Equip 5801 Travel & Training 6001 Office supplies 6002 Operating Supplies 6301 Small tools 6302 Safety Equipment 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 9901 Gen. Fund Reimb Operating Expense BUD17 FINAL 2014 Actual 53,422 133 4,050 5,542 3,022 259 1,661 1,087 $ 2015 Actual 2016 Budget 45,469 266 3,407 5,193 2,322 228 1,439 4,414 48,416 351 3,568 5,156 2,213 152 1,287 3,612 $ 62,737 $ 64,756 $ 19,350 20,858 1,919 43 27 77 33 522 417 2,297 35,225 81 16 774 41,547 21,245 550 8 244 36,930 69,176 $59,908 $ $63,277 $58,977 2016 YTD 4/30/2016 53,562 1,200 4,271 6,336 2,351 218 2,954 4,416 75,308 17,262 34,886 $52,148 Section 5 - Page 6 $ $ $ 2017 Requested 20,124 $ 1,743 965 1,719 2,454 1,085 76 1,460 1,180 30,806 $ $8,882 $505 5 31 1,155 28,978 $39,555 $ - 2017 % Change - -100.00% 0.00% 0.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% - -100.00% 0 - -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -100.00% - -100.00% 7/21/2016 1:23 PM Sewer Capital Reinvestment 420-54065-432 7401 7851 7852 7860 7862 7865 7869 7871 7872 7873 7874 Sewer CIP Capital Outlay WWMP Phase I(Contract) Bonita Interceptor-3rd to 19th Phase I, WWTP Improvements Root Intrusion-City Repairs DOC-Lift Station Improvements 51,441 CIP Impact Fees-Study W & WW System Improvements, phase II37,789 Phase II, WWTP Improvements Southwest Interceptor (103) Solar Project $89,127 7999 Contra Exp/Fix As Total Expenses BUD17 FINAL 3,805 1,707 33,698 - 93,034 $37,502 $94,742 5,000 80,000 $0 $0 $0 $0 $0 $3,119 5,000 80,000 1,100,000 - 280,299 1,219,758 200,000 - $1,185,000 $1,503,176 $ 1,312,455 $ 1,573,537 $285,000 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -81.82% 0.00% 0.00% -75.95% ($408,975) ($180,608) ($100,171) $ (190,765) $ (17,093) $ 118,303 Section 5 - Page 6 $ 285,000 -78.28% 7/21/2016 1:23 PM SANITATION 430-54071-432 pg 90 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2007 Unemployment Ins. 2008 HR Processing 2016 Self Funding Ins Claims/Fees Personnel Expense $ Operating Expense 3001 Contractual Services 3002 Auditing services 4104 Telephone 4105 Utilities 4301 Auto/Equip 4302 Maintenance cost 4311 Heavy Equipment Repair 4703 Lease/Purchase 5201 Insurance-Liability 5501 DOC Labor-Clean up 5502 Transfer Expense 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6201 Postage 6301 Small tools 6302 Safety Equipment 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 6705 DOC Supplies Operating Expense BUD17 FINAL $ 2014 Actual 2015 Actual 212,395 17,549 15,572 1,193 18,058 24,507 15,403 1,094 16,841 709 21,143 248,122 7,743 35,236 2,500 21,040 32,316 12,612 1,390 17,880 1,130 701 44,424 229,547 48,852 53,601 2,344 24,020 31,078 9,560 918 20,670 893 34,051 $ 344,463 $ 425,094 $ 455,535 $ 15,255 2,619 553 4,533 6,715 664 15,374 3,320 337 281,903 815 225 824 22 741 1,438 1,319 37,528 2,306 2,687 20,830 2,677 487 4,911 2,328 552 28,525 2,026 2,174 1,815 324,314 280 2,582 680 1,179 2,240 3,688 38,482 1,209 - 18,052 2,767 716 4,817 1,265 4,751 23,887 3,404 1,349 4,944 294,124 553 80 762 19 1,336 2,008 38,755 3,232 - 379,177 $ 440,978 $ 406,823 Section 5 - Page 7 2016 Budget $ 342,814 6,000 2016 YTD 4/30/2016 2017 Requested $ 1,000 26,761 39,023 15,443 1,362 24,698 2,000 1,200 52,152 $ 192,826 22,341 67,448 1,514 20,463 31,302 9,820 977 17,901 300 723 25,615 512,451 $ 391,231 $ 6,683 2,677 900 5,000 5,000 8,000 30,000 41,776 4,200 10,000 300,000 1,000 1,000 1,000 450 2,000 5,000 40,000 2,800 - 12,431 2,717 542 4,271 1,324 1,213 20,013 41,776 1,866 5,197 275,902 162 962 462 904 1,219 26,228 3,050 - 467,486 $ 400,238 $ 344,336 6,000 2017 % Change 1,000 26,877 39,161 17,284 1,437 18,047 2,000 1,200 44,634 0.44% 0.00% 0.00% 0.00% 0.44% 0.35% 11.93% 5.51% -26.93% 0.00% 0.00% -14.42% 501,977 -2.04% 12,127 2,769 900 5,000 3,000 8,000 30,000 41,776 1,960 10,000 300,000 1,000 4,398 1,000 9,848 450 2,000 5,000 40,000 2,800 - 81.46% 3.44% 0.00% 0.00% -40.00% 0.00% 0.00% 0.00% -53.33% 0.00% 0.00% 0.00% 339.80% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 482,028 3.11% 7/21/2016 1:23 PM SANITATION 430-54071-432 pg 90 Account 7402 7403 7999 8001 8003 8901 9901 9917 2013 Actual 218,374 Description Capital Outlay Automated Program Fixed Assets (218,374) Bad Debt Expense 5,326 Other Expense/Conti 1,018 Depreciation (Expense Savings) 54,972 Gen. Fund Reimb 27,173 Transfer to Debt Service 1,243 Transfer to Water 89,732 Total Expenses $ 813,372 2014 Actual 198,595 7,022 (205,617) 2,303 87,610 35,867 7,212 132,992 2015 Actual 32,440 (22,744) 2,026 (4,663) 61,351 32,997 6,796 108,204 $ 999,064 $ 970,562 2017 Requested 2017 Approved 4800 96Gallon cans 240,000 2 Automated Garbage Trucks 600,000 1-Residential Container Delivery & Service Truck45,000 100 300Gallon cans 30,000 $ 915,000 240,000 600,000 45,000 30,000 $ 915,000 2016 Budget 70,000 80,569 26,064 6,796 29,333 222,763 2016 YTD 4/30/2016 12,694 26,151 5,664 44,509 $ 1,202,700 $ 835,977 10,000 2017 2017 Requested % Change 915,000 1207.14% 10,000 80,569 21,351 6,796 1,033,716 0.00% 0.00% 0.00% -18.08% 0.00% -100.00% 364.04% $ 2,017,721 67.77% CAPITAL OUTLAY Items BUD17 FINAL Section 5 - Page 7 7/21/2016 1:23 PM AIRPORT 310-54103-431 pg 81 Account Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self funding Ins Claims/Fees Personnel Expense Operating Expenses 3001 Contractual Services 4104 Telephone 4105 Utilities 4301 Auto/Equip 4302 Facilities Maintenance 5201 Liability Insurance 5801 Travel & Training 6001 Office Supplies 6002 Operating Supplies 6302 Safety Equipment 6401 Books Dues & Subscriptions 6501 Gas/oil/lube 6503 Fuel (100 LL) 6504 Fuel (JET A) 6601 Uniforms Operating Expenses Total Expenses before Capital 7301 Capital Outlay/Projects 7948 Contra Exp-Fixed Assets 8512 Grant Match Total Expenses 2013 Actual 2014 Actual 2015 Actual 2016 Budget 2016 YTD 2017 2017 4/30/2016 Requested % Change 11,172 11,169 402 1,736 2,479 1,270 81 881 720 28,071 907 1,918 2,810 2,324 131 1,100 3,687 24,858 874 1,969 2,930 2,218 88 1,066 2,788 $ 25,688 400 1,996 2,961 2,205 104 1,112 3,147 $ 8,962 478 731 1,072 875 39 386 703 $ 26,073 400 2,025 3,002 2,159 110 981 3,192 1.50% 0.00% 0.00% 0.00% 1.47% 1.39% -2.08% 6.59% -11.79% 1.46% $ 29,911 $ 40,948 $ 36,790 $ 37,612 $ 13,247 $ 37,943 0.88% 4,141 1,598 7,983 76 2,447 5,738 376 599 489 438 2,024 26,287 39,410 300 5,252 1,499 7,655 215 5,354 5,222 137 519 15 1,163 18,214 60,074 120 4,544 1,709 10,875 708 2,297 5,222 5 136 1,701 900 18,961 45,382 133 $ $ $ $ 91,907 105,438 121,818 4,600 1,500 8,000 500 6,000 5,300 500 500 1,500 400 2,000 18,000 43,000 350 3,389 1,298 7,795 102 1,964 5,222 5 73 345 9,171 30,416 353 92,572 92,150 146,385 129,362 230 29,709 - 11,760 933 $ 92,137 $ 158,145 $ 130,295 4,600 1,500 9,000 500 5,000 5,300 500 500 1,500 400 2,000 15,000 43,000 350 0.00% 0.00% 12.50% 0.00% -16.67% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -16.67% 0.00% 0.00% 60,134 89,150 -3.26% 129,762 73,381 127,093 -2.06% - - 0.00% 30,000 34 57,706 - 20,000 -33.33% $ 159,762 $ 131,121 $ 147,093 -7.93% CAPITAL OUTLAY Item 0 Total BUD17 FINAL 2017 2017 Requested Approved* $ - $ - Section 5 - Page 8 7/21/2016 1:23 PM Golf Course 450-52045-451 pg 88 Description 2013 Actual 2014 Actual Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Limited 1005 Sal-OT 2201 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Funding Ins Claims/fees Personnel Expense 17,852 51,886 79,663 2,071 11,417 10,838 1,700 340 3,409 4,136 $ 183,311 30,300 40,171 27,861 674 7,312 6,533 1,228 242 2,611 8,368 $ 125,300 $ $ 33,582 15,709 16,241 570 5,029 5,796 1,924 142 1,834 2,191 83,016 Operating Expense 3001 Contractual Services 4101 Electric 4102 Gas 4103 Water 4104 Telephone 4145 RV Park Utilities 4301 Auto/equip 4302 Building Maintenance 4303 Computer Maintenance 4703 Lease/Purchase 5201 Liab/Property Insurance 5245 RV Park Insurance 5401 Advertising/Printing 5501 DOC Labor 5801 Travel/training 6001 Office supplies 6002 Operating supplies 6021 Supplies /Chemicals 6031 Pro Shop Items for Resale 6201 Postage 6301 Small tools 6401 Books/dues/subscrip 6501 Gas/oil/lube 6601 Uniforms Operating Expense 6,141 42,577 121 16,729 1,931 14,082 6,647 5,911 184 34,247 1,186 678 3,791 455 23,374 12,215 14,804 62 1,701 506 14,374 1,065 $ 202,782 4,295 30,866 17,748 694 12,406 7,466 1,756 34,008 1,630 3,888 429 15,778 8,447 5,375 122 3,947 10,377 690 $ 159,922 9,064 22,509 14,044 504 10,974 3,408 13,628 34,022 3,646 75 4,606 144 14,573 7,147 2,508 1,531 10,144 173 $ 152,699 $ 3,703 - 28 - $ 389,796 $ 285,249 Account 7750 Capital Outlay 7751 RV Hidden Treasures 8050 Prior Expense - DGSC Total Expenses *CAPITAL OUTLAY Total BUD17 FINAL 2015 Actual 2016 Budget $ $ (4,118) $ 231,598 $ 2016 YTD 2017 2017 4/30/2016 Requested % Change - $ $ 6,016 101 3,635 78 713 1,455 579 46 313 302 13,237 - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - 19,547 32,025 13,988 5 13,159 875 2,074 169 22,044 8,842 3,994 159 3,145 1,479 0 366 1,845 2,240 217 $ 126,172 $ 1,529 37,025 16,786 1,080 14,554 18,172 4,792 $ 93,938 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - - 0.00% - 40 - - $ 139,449 $ 93,938 $ 0.00% 2017 2017 Requested Approved 0 0 0 $ - $ - Section 5 - Page 9 7/21/2016 1:23 PM Lounge 450-52055-451 pg 88 Account 2013 Actual Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Limited 1005 Sal-OT 1008 Tips 2201 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Funding Ins Claims/fees Personnel Expense $ Operating Expense 3001 Contractual Services 4101 Electric 4102 Gas 4103 Water/Sewer/Sanitation 4104 Telephone 4302 Building Maintenance 4303 Computer Maintenance 5401 Advertising/Printing 5501 DOC Labor 5801 Travel & Training 6001 Office supplies 6002 Operating supplies 6301 Small tools 6501 Gas/Oil 6508 Beverages 6509 Food 6601 Uniforms Operating Expense BUD17 FINAL $ 2014 Actual 2015 Actual 7,328 9,564 17,231 236 2,908 3,147 2,558 1,309 79 715 699 2,916 9,528 190 497 1,029 142 367 14 271 1,775 45,772 $ 16,729 $ 33,750 12,446 12,792 2,366 936 2,038 2,008 97 625 3,013 86 103 30,695 27,540 617 7,594 12,259 1,597 1,014 1,579 160 193 2,968 22,579 3,190 - 95,361 53,133 7750 Capital Outlay 8101 Special Events 441 Total Expenses $ 141,574 - $ 16,358 9,508 2,356 1,070 2,243 1,390 76 13 760 (24) $ 69,862 2016 2016 YTD 2017 2017 Budget 4/30/2016 Requested % Change $ - 3,457 5,078 1,201 785 831 1,384 8 277 - $ - $ 13,022 5,087 12,432 2,311 1,230 1,652 894 1,597 60 22,924 4,200 - $ - - 3,264 12,003 2,906 1,843 1,211 1,308 492 2,271 19,361 3,725 - 52,385 $ - Section 5 - Page 10 - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ - 0.00% $ 3,643 14,571 3,117 2,056 1,852 45,823 - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ 48,383 $ 71,062 0.00% - - - 0.00% 0.00% - $ 61,405 $ 71,062 0.00% - 150 $ 86,285 - $ $ - 7/21/2016 1:23 PM GRANTS 2016-2017 Total Grant Award Housing and Community Development Section 8 Housing Vouchers Dept of HUD Family Self Sufficiency ADOH Owner Occupied Housing Rehab Transit & Tourism ADOT Transit Grant 5311 Admin, Oper & Capital *** Freeport McMoran Transit Grant * Fire AFG - Equipment (SCBAs) AFG - Fire Truck Type 3 Engine IAFC HAZ MAT Conference MAHMT Conference Continuing Challenge HAZ MAT Conference AZDEM ERF SSHGP (Radios) SSHGP Fire Christmas Drive APS Police Operation Stonegarden OT Operation Stonegarden Mileage Operation Stonegarden Equipment Governor's Office of Highway Safety Governor's Office of Highway Safety DUI Detail ICE/FBI Overtime DEA/ SAMIT Grant Public Works ADOT Safe Route to School CDBG Grant BECC WasteWater Project Development ADOT Airport Master Plan Update ADOT Airport Security Fencing Library E-Rate Grant LSTA Grant Tohono O'odham - Library Improvements Cochise Community Foundation ACT Call Center Dollar General Literacy Grant Wal Mart Library Literacy Grant TOTALS REQUESTED TOTALS APPROVED * * * * * ** *** * 2017 Total Expenditure 2017 Max Revenue 2017 Max Expense 1,000,000 34,212 275,000 1,309,212 1,000,000 34,212 275,000 1,309,212 1,000,000 34,212 275,000 1,309,212 585,807 65,000 650,807 585,807 65,000 650,807 585,807 65,000 650,807 300,004 246,000 444,892 5,000 5,000 5,000 6,000 64,000 30,936 4,500 5,000 816,328 246,000 444,892 5,000 5,000 5,000 6,000 64,000 30,936 4,500 5,000 816,328 246,000 444,892 5,000 5,000 5,000 6,000 64,000 30,936 4,500 5,000 816,328 6,300 22,245 1,109,297 80,850 51,276 27,145 35,000 45,000 22,000 1,370,568 1,109,297 80,850 51,276 27,145 35,000 45,000 22,000 1,370,568 1,109,297 80,850 51,276 27,145 35,000 45,000 22,000 1,370,568 150,000 300,000 150,000 300,000 150,000 300,000 20,000 200,000 200,000 20,000 220,000 470,000 650,000 650,000 20,000 670,000 43,118 30,000 15,000 5,000 500 1,500 500 95,618 43,118 30,000 15,000 5,000 500 1,500 500 95,618 43,118 30,000 15,000 5,000 500 1,500 500 95,618 4,712,533 4,892,533 4,892,533 4,267,641 4,447,641 4,447,641 Total Grant Match from the GF Requested Total Grant Match from the GF Approved 2017 Match - 300,004 - 28,545 - 1,000,000 34,212 275,000 1,309,212 885,811 65,000 950,811 252,300 467,137 Not Recommended 5,000 5,000 5,000 6,000 64,000 30,936 11,000 5,000 851,373 1,109,297 80,850 51,276 27,145 35,000 45,000 22,000 1,370,568 150,000 300,000 8,611 * 8,611 51,729 30,000 15,000 5,000 500 1,500 500 104,229 357,160 5,256,192 - 334,915 4,789,056 37,156 14,911 *Grants Accounted for in General Fund Rev & Exp **Grant Accounted for in the Water & Sewer CIP Rev and Exp BUD17 FINAL Section 6 - Page 1 7/21/2016 1:23 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2016-2017 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL AMOUNT APPROVED DEPT. APPROVED FUNDING SOURCE ADMINISTRATION City Website Development & Design DEPARTMENT TOTAL FINANCE 1 Inventory Control Program w/ scanners DEPARTMENT TOTAL 20,000 20,000 $20,000 12,000 $ 20,000 $ - $ - $ 12,000 MIS Backup Hardware 26,000 DEPARTMENT TOTAL $ 26,000 HUMAN RESOURCES DEPARTMENT TOTAL $ - $ - $ - $ - MAGISTRATE DEPARTMENT TOTAL FIRE/EMS Multi Use Vehicle (pull Haz-Mat, air and light Trailer) Type 6 Quick Attack Vehicle New Roof 2 Rescue Tools (Jaws of Life) New Fire Station 3 Air conditioner replacement SCBA Replacement (22 harnesses and 44 tanks) Fire Truck 2 ambulances SCBA Air filling cascade system 2 Cardiac monitors DEPARTMENT TOTAL POLICE 2 replacement vehicles 1 patrol 1 invest 2 replacement vehicles 1 patrol 1 invest 12 Tablets w/docking station 1 Interview Room 17 Ballistic Vests Gym Equipment Taser DEPARTMENT TOTAL 125,000 80,000 25,000 30,000 6,000,000 20,000 260,000 400,000 250,000 45,000 65,000 80,000 25,000 15,000 13,800 250,000 45,000 65,000 $ 7,300,000 80,000 80,000 51,276 14,000 17,000 7,100 5,600 One for lease the other capital projects $ 493,800 80,000 80,000 51,276 14,000 17,000 7,100 5,600 RICO Auction RICO RICO GF-OSE/BVP Grant GF-OSE GF-OSE $ 254,976 $ 254,976 $ - $ - $ 20,000 $ 38,200 VISITOR CENTER DEPARTMENT TOTAL CEMETERY Trees Chip Seal project DEPARTMENT TOTAL PARKS 4 Bleachers Ground Leveling of Lower Fields at Airport Park Electrical Pedestals @ Airport Park Ramada for Stage @ Airport Park Additional lightning for lower fields @ Airport Park Ramada Replacement Program DEPARTMENT TOTAL BUD17 FINAL 8,000 40,000 0 20,000 $ 48,000 7,000 13,000 $20,000 $5,800 440,000 18,200 7,000 13,000 18,200 $ 485,800 Section 7 - Page 80 7/21/2016 1:23 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2016-2017 DEPT ITEM/PROJECT AMOUNT REQUESTED RECREATION PA System Tables & Chairs with Cart for Events AMOUNT APPROVED 9,000 5,000 DEPARTMENT TOTAL AQUATICS ADA Doors POS System Automation System for Main Pool 8th Street Pump Upgrade Baby Pool replaster @ 8th Street Artificial Grass for Outdoor play area Facility Furniture Shading over whale tail splash pad DEPARTMENT TOTAL DEPT. TOTAL FUNDING SOURCE 5,000 $ $ $ $ $ $ $ $ $ DEPT. APPROVED 14,000 5,000 12,000 10,000 20,000 18,000 18,000 12,000 30,000 $ 5,000 $ 44,000 $ - $ 25,000 $ 5,000 $ 45,000 5,000 12,000 12,000 15,000 $ 125,000 PUBLIC WORKS/ADMINISTRATION DEPARTMENT TOTAL PW CONSTRUCTION Roof on 7th Street Building $ 30,000 DEPARTMENT TOTAL PUBLIC WORKS/FLEET MAINTENANCE Vehicle Code Scanner Alignment Machine DEPARTMENT TOTAL LIBRARY Inventory Device 2 Automatic Doors for North and South Entrance Upgrade Lighting Roofing Materials Upgrade Tech and circulation areas Microfilm machine Library Furniture Upgrades and Additions Marketing/Branding Exterior Painting Purchase of Building Furnishing and Equipping Building DEPARTMENT TOTAL - 25,000 $ 30,000 5,000 25,000 5,000 $ 30,000 7,070 15,000 7,000 5,000 9,000 5,000 12,000 5,000 25,000 275,000 100,000 TOTAL GENERAL FUND REQUESTS 15,000 5,000 25,000 $ 465,070 TOTAL REQUESTED TOTAL AMOUNT APPROVED $ 8,810,846 $ 950,976 $ $ 145,276 29,700 $ $ 80,000 571,000 $ $ 125,000 950,976 $ - Capital Outlay Funding RICO GFOSE Grants Seized Vehicle Auction Funds (net of expenses) General Fund JCEF Lease/Purchase TOTAL ALL FUNDING SOURCES BALANCE BUD17 FINAL Section 7 - Page 81 $ 80,000 $ (28,400) 7/21/2016 1:23 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2016-2017 DEPT ITEM/PROJECT AMOUNT REQUESTED SANITATION 4800 96Gallon cans 2 Automated Garbage Trucks 1-Residential Container Delivery & Service Truck 100 300Gallon cans DEPARTMENT TOTAL 240,000 600,000 45,000 30,000 STREETS (HURF) 1 Paint Stripping Machine 2 UPS Inverter Battery Pack for Traffic Signals Street Improvements Dump Truck DEPARTMENT TOTAL 6,000 12,000 650,000 37,000 DEPT. TOTAL 915,000 705,000 30,000 0 $ 915,000 $ 705,000 $ - $ 15,400 $ - $ 25,000 $ - $ - $ - $ WATER FIELD 1 Chlorine Building Safety Barricades FUNDING SOURCE 6,000 12,000 650,000 37,000 $ DEPARTMENT TOTAL DEPT. APPROVED 240,000 600,000 45,000 30,000 $ WATER OFFICE Payment Kiosk AMOUNT APPROVED 30,000 10,400 5,000 10,400 5,000 - DEPARTMENT TOTAL $ 15,400 WATER/SEWER - CAPITAL REINVESTMENT PROGRAM DEPARTMENT TOTAL $ WASTEWATER Work Truck - 25,000 DEPARTMENT TOTAL 25,000 $ 25,000 GOLF COURSE $ - - DEPARTMENT TOTAL $ - HOUSING DEPARTMENT TOTAL $ - AIRPORT DEPARTMENT TOTAL TRANSIT 6 Bicycle Racks 6 Bus Wraps 6 Mobile Base System 1 Bus DEPARTMENT TOTAL BUD17 FINAL $ - 12,690 15,000 22,176 147,000 12,690 15,000 22,176 147,000 $ 196,866 Section 7 - Page 82 Grant/Match Required Grant/Match Required Grant/Match Required Grant/Match Required $ 196,866 $ 19,686.60 7/21/2016 1:23 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2016-2017 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL TOTAL REQUESTED TOTAL ENTERPRISE FUND REQUESTS Requests funded from HUD Requests funded from Golf Course NET FUNDED FROM ENTERPRISE FUNDS AMOUNT APPROVED DEPT. APPROVED TOTAL AMOUNT APPROVED $ $ $ $1,857,266 1,857,266 Sanitation Fund HURF Water Fund Sewer Fund Water/Sewer CIP HUD Golf Course Airport Transit $ $ $ $ $ $ $ $ $ 915,000 705,000 15,400 25,000 196,866 Total Enterprise Funds CIP 16/17 $ 1,660,400 $1,887,266 TOTAL GENERAL FUND REQUESTS: TOTAL ENTERPRISE FUND REQUESTS: $ 8,810,846 $ 1,887,266 $ $ 950,976 1,857,266 TOTAL CAPITAL OUTLAY REQUESTS: $ 10,698,112 $ 2,808,242 LESS: FUNDED BY SPECIAL FUNDING $ 225,276 $ 225,276 TOTAL CITY FUNDED CAPITAL OUTLAY: $ 10,472,836 $ 2,582,966 BUD17 FINAL Section 7 - Page 83 FUNDING SOURCE 7/21/2016 1:23 PM