CITY OF DOUGLAS BUDGET SUMMARY Expense 2015 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 $ TRANSIT $ GENERAL FUND CAPITAL $ MATCHING FUNDS (GRANTS) $ GENERAL FUND $ Net Rev. vs. Exp. $ Expense 2016Budget 485,944 70,331 553,321 511,762 397,366 2,902,140 76,723 406,022 158,125 569,159 162,984 315,045 172,156 414,610 160,029 1,164,378 1,293,161 412,498 2,530,964 1,780,269 175,922 64,231 591,524 472,746 15,841,411 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 481,769 70,872 554,346 529,987 419,132 2,321,634 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 577,500 433,170 $ 16,286,270 2015-2016 Difference $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ (4,176) 541 1,025 18,225 21,766 (580,506) 846 9,611 (3,212) (15,343) (69,850) (8,670) (14,930) 7,113 1,702 146,812 188,865 205,237 318,447 239,005 35,125 825 (14,023) (39,576) - $ 444,859 2016 2015 Budgeted 2016 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp -0.86% 0.00% 0.77% 0.00% 0.19% 3.56% 5.48% -20.00% 1.10% 2.37% #DIV/0! -2.03% -2.70% -42.86% -2.75% -8.67% 1.72% 1.06% 12.61% 14.60% 49.75% 12.58% 13.43% 19.97% 1.28% -2.37% -8.37% $ 433,170 2.81% $ 15,841,411 $ 16,286,269 $ (0) (0) - GF Reserve $ - $ (0) 7/10/2015 9:52 AM Budget 16 Final for Website Section 1 - Page 1 CITY OF DOUGLAS BUDGET SUMMARY 2015 Budget 2016 2016 2015 Budgeted 2016 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp 2015-2016 Difference 2016 Budget H. U. R. F. $ 1,269,351 $ 1,307,411 $ 38,060 3.00% $ 1,269,351 $ 1,307,411 $ (0) LTAF $ - $ - $ - 0.00% $ - $ - $ - CAPITAL PROJECTS $ 1,697,000 $ 472,121 -72.18% $ 613,000 $ 89,167 $ DEBT SERVICE FUND $ 1,354,235 $ 1,315,624 $ (38,611) -2.85% $ 1,354,235 $ 1,315,624 $ - MPC FUND $ 486,450 $ - $ (486,450) -100.00% $ 486,450 $ - $ - RICO $ 158,000 $ 175,450 $ 17,450 11.04% $ 158,000 $ 175,450 $ - JCEF $ 100,840 $ 19,292 $ (81,548) -80.87% $ 45,150 $ 8,150 $ (11,142) GRANTS $ 5,523,258 $ 2,516,285 5,523,258 $ 2,486,285 $ (30,000) HOUSING $ 280,574 $ 236,288 TOTAL SPECIAL REVENUE FUNDS $ 10,869,708 $ SANITATION $ 1,201,200 WATER WATER OFFICE WATER FIELD WATER CAPITAL REINVESTMENT WATER TOTAL $ $ $ $ WASTE WATER SEWER CAPITAL REINVESTMENT SEWER TOTAL $ (1,224,879) (382,954) $ (3,006,973) -54.44% $ (44,286) -15.78% $ 276,574 $ 236,288 $ (0) 6,042,471 $ (4,827,237) -44.41% $ 9,726,019 $ 5,618,375 $ (424,096) $ 1,202,700 $ 1,500 0.12% $ 1,201,200 $ 1,202,700 $ (0) 262,989 1,337,135 523,542 2,123,666 $ $ $ $ 244,910 1,418,418 442,337 2,105,666 $ $ $ $ (18,079) 81,284 (81,205) (18,000) -6.87% 6.08% -15.51% -0.85% $ 2,113,666 $ 2,105,666 $ 0 $ $ $ 1,640,313 1,204,687 2,845,000 $ $ $ 1,647,545 1,312,455 2,960,000 $ $ $ 7,232 107,768 115,000 0.44% 8.95% 4.04% $ 2,845,000 $ 2,960,000 $ 0 AIRPORT* $ 151,338 $ 159,762 $ 8,424 5.57% $ 151,338 $ 159,762 $ - GOLF COURSE ** LOUNGE $ $ $ 100,000 100,000 $ $ $ - $ -100.00% $ 100,000 $ - $ - TOTAL ENTERPRISE FUNDS $ 6,421,204 $ 6,428,128 $ 0.11% $ 6,411,204 $ 6,428,128 $ 0 GRAND TOTALS $ 33,132,323 -13.21% $ 31,978,633 $ 28,332,773 $ $ 28,756,869 (100,000) 6,924 $ (4,375,454) (424,096) * Airport is being subsidized $60,302 by the General Fund ** Golf Course is being subsidized $120,000 by the General Fund 7/10/2015 9:52 AM Budget 16 Final for Website Section 1 - Page 2 REVENUE BUDGET 2015 - 2016 GENERAL FUND Account 31100 31102 31301 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 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 $ 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 AMBULANCE FEES COMMUNITY TRAINING FIRE RESPONSE 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 2012 Actual 2013 Actual 2014 Actual 2015 Budget 510,162 38,015 4,143,323 1,025,975 528,103 28,354 3,811,528 952,502 544,964 $ 33,487 3,914,860 979,280 $ 520,000 30,000 4,100,000 1,024,980 51,599 184,175 98,555 51,343 84,568 9,650 2,380 4,068 89,676 1,575 3,135 190 1,143 706,775 0 0 0 0 1,357,922 1,466,716 803,452 42,590 91,440 27,124 60,163 0 8,157 21,500 3,050 1,059 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 0 19,646 71,293 0 6,060 19,200 2,800 1,349 25,408 895,111 13,905 7,765 17,762 5,818 21 1,845 691 16,776 3,322 5,356 0 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 40,000 190,000 85,000 48,000 88,000 10,000 4,000 70,000 2,000 4,000 250 1,000 988,141 772,159 51,426 1,582,085 2,119,448 847,656 42,000 99,640 19,821 70,000 8,000 22,000 3,000 1,400 34,500 1,000,000 7,000 2,000 18,000 5,000 100 2,000 1,000 7,000 2,000 2,000 924,788 11,331 11,704 20,482 6,113 0 1,677 1,424 14,658 1,813 7,394 120 2015 10-month Actual 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,069,174 7,220 0 15,546 7,036 685 885 578 16,323 3,975 6,421 0 $ $ 372,781 33,635 3,304,899 823,517 2016 Projected $ $ $ 38,956 134,704 77,126 24,028 71,428 7,425 375 2,455 60,613 1,035 3,220 70 930 535,431 22,364 197,688 $ 1,304,722 1,766,311 602,782 28,178 74,915 65,286 1,994 7,106 15,000 4,800 1,250 30,795 945,206 8,365 1,211 7,782 2,898 1,068 377 368 3,094 2,928 4,863 - $ 530,000 30,000 4,000,000 999,980 445,833 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 692,479 43,840 1,672,689 2,108,081 840,934 47,400 59,374 70,000 8,000 21,000 5,200 1,400 40,000 1,100,000 7,000 2,000 18,000 5,000 100 2,000 1,000 7,000 2,000 2,000 2016 % Change 1.92% 0.00% -2.44% -2.44% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% #DIV/0! 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 7.94% 0.00% 0.00% -10.32% -14.75% 5.73% -0.54% -0.79% 12.86% -40.41% -100.00% 0.00% 0.00% #DIV/0! 0.00% -4.55% 73.33% 0.00% 15.94% 10.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 3 REVENUE BUDGET 2015 - 2016 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 2012 Actual RAMADA RESERVATION FEES 2,390 DUSD AQUATIC CENTER REIMB 35,000 DUSD RECREATION REIMB 20,000 COUNTY REIMB FOR LIBRARY COURT FINES & FORFEITURES 148,214 RESTITUTION PAYMENTS 3,223 LIBRARY FINES & FEES 17,279 COURT FINE OFFICER SA 4,509 FORFEITED PROPERTY SALE 137,387 INVESTMENT EARNINGS 25,580 RENTAL PAYMENTS 20,530 CALL CENTER Lease 715,478 VISITOR CENTER RESV FEES 2,660 SPECIAL EVENTS REVENUE 1,693 4TH OF JULY REVENUE 79 YOUTH ACTIVITY REVENUE 0 DONATIONS/MISC 2,520 LIBRARY GRANT E-RATE 112,581 MISCELLANEOUS REVENUE 93,389 1 CASH OVER/SHORT -102 SALE SURPLUS PROPERTY/LAND 52,021 EXPLORER REVENUE 0 TRANSFER FROM LTAF 26,001 TRANSFER FROM SPECIAL PROJECTS 0 TRANSFER FROM ENTERPRISE FUNDS 482,209 TRANSFER FROM GRANTS 111,231 TRANSFER FROM COURTS - Reimb 0 TRANSFER FROM RICO CAPITAL LEASE PROCEEDS - TOTAL REVENUE $ 13,904,854 2013 Actual 2014 Actual 1,720 56,959 0 1,735 60,734 0 150,048 1,001 18,443 6,832 89,664 27,007 26,221 715,478 2,290 2,431 50 0 551 62,130 50,701 -327 356,860 0 0 0 201,283 200,655 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 2015 Budget 2,000 46,902 20,000 148,000 1,500 18,000 5,000 80,000 6,000 115,800 669,266 1,000 2,000 500 1,000 41,950 50,000 510,000 1,000 190,887 1,205,910 1,041,474 6,000 - $ 15,318,515 $ 15,852,635 $ 15,841,411 2015 10-month Actual 2016 Projected 1,095 46,902 - 2016 % Change 2,000 66,387 0.00% 41.54% 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 - - 0.00% -8.78% 0.00% -5.56% 0.00% 0.00% 6.67% 2.35% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -21.11% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.38% 0.00% 0.00% 100.00% 0.00% $ 11,852,429 $ 16,286,269 2.81% 93,746 1,096 12,278 3,876 22,590 5,977 102,142 500,100 890 1,559 20 163 21,188 252,339 (194) 20,630 895 171,158 - 33,093 50,000 510,000 1,000 195,424 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 4 REVENUE BUDGET 2015 - 2016 HIGHWAY USER REVENUE FUND Account 33504 38001 38002 38003 39101 39103 39104 Description 2012 Actual HIGHWAY USERS - STATE MISCELLANEOUS SALES REIMBURSEMENT CITIZEN PAYS POLICY TRANSFER FROM GENERAL FUND TRANSFER FROM LTAF TRANSFER FROM SP PROJECTS 1,033,728 1,613 40,201 240,000 83,997 - TOTAL REVENUE 1,399,540 $ 2013 Actual 2014 Actual 1,103,680 15 17,230 211,937 $ 1,332,862 $ 2015 10-month Actual 2015 Budget 1,159,673 1,085 56,100 2,548 - $ 1,219,406 $ 1,234,351 30,000 5,000 - $ 1,269,351 2016 Projected 999,209 30,215 911 4,186 - $ $ 1,034,521 $ 2016 % Change 1,272,411 30,000 5,000 - 3.08% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1,307,411 3.00% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 5 REVENUE BUDGET 2015 - 2016 LOCAL TRANSPORTATION ASSIST. (LOTTERY) Account 33505 Description 2012 Actual LOTTERY LTAF II GRANT TOTAL REVENUE 2013 Actual - $ - 2014 Actual - $ - $ 2015 10-month Actual 2015 Budget 2016 Projected 2016 % Change - $ - $ - $ - 0.00% 0.00% - $ - $ - $ - 0.00% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 6 REVENUE BUDGET 2015 - 2016 CAPITAL PROJECTS Account 36104 31301 36101 36102 36201 38001 38007 38008 38201 38201 39101 39114 39301 39302 Description 2012 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 $ 2013 Actual 12,616 947 217,000 - 12,295 63,619 - 230,563 2014 Actual 481,015 12,458 20,254 600,000 31,757 $ 75,915 2015 Budget $ $ 1,145,484 2015 10-month Actual $ 550,000 $ 2016 Projected 485,941 1,944 - - 63,000 - 155,368 304,077 - 613,000 $ - $ 947,330 $ 2016 % Change 89,167 - #DIV/0! -83.79% 0.00% 0.00% #DIV/0! 0.00% 0.00% #DIV/0! #DIV/0! - -100.00% #DIV/0! #DIV/0! #DIV/0! 0.00% 89,167 100.00% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 7 REVENUE BUDGET 2015 - 2016 DEBT SERVICE FUND Account 31301 36101 39101 39104 39110 Description 2012 Actual 1 1/3 Cent Sales Tax (call center IT) INVESTMENT EARNINGS TRANSFER FROM GENERAL FUND TRANSFER FROM CAPITAL TRANSFER FROM ENTERPRISE TOTAL REVENUE $ 2013 Actual 604,506 430 1,149,223 60,000 18,082 1,832,242 2014 Actual 560,802 777 1,147,062 64,099 8,699 $ 1,781,439 $ 2015 10-month Actual 2015 Budget 96,100 390 1,357,254 88,312 $ 1,542,056 $ 1,272,178 $ 82,057 1,354,235 $ 2016 Projected 1,011 1,063,569 68,381 $ 1,132,961 $ 1,233,567 2016 % Change #DIV/0! 82,057 -3.04% 0.00% 0.00% 1,315,624 -2.85% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 8 REVENUE BUDGET 2015 - 2016 MPC Account 39101 39102 39104 Description 2012 Actual TRANSFER FROM GF TRANSFER FROM HURF TRANSFER FROM SPEC PROJECTS 321,547 162,910 TOTAL REVENUE 484,456 $ 2013 Actual 2014 Actual 325,691 160,415 $ 486,106 $ 2015 10-month Actual 2015 Budget 2016 Projected 2016 % Change 326,160 160,646 - $ 325,922 160,529 - $ 271,601 133,774 - $ - -100.00% -100.00% 0.00% 486,806 $ 486,450 $ 405,375 $ - -100.00% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 9 REVENUE BUDGET 2015 - 2016 RICO Account 33241 33242 33243 36106 39101 39112 Description 2012 Actual RICO-ST ATTY GENERAL RICO-COUNTY ATTY RICO-COUNTY ATTY-TOWING INTEREST RICO TRANSFER FROM GF TRANSFER FROM GRANTS $ TOTAL REVENUE $ 2013 Actual 370,310 79,688 2,591 - $ 452,589 $ 2014 Actual 147,624 77,322 2,878 - $ 227,824 $ 2015 10-month Actual 2015 Budget 232,894 34,731 4,725 - $ 272,351 $ 158,000 - $ 158,000 2016 Projected 119,125 68,899 $ $ 188,024 $ 2016 % Change 175,450 - - 11.04% 0.00% 0.00% 0.00% 0.00% 0.00% 175,450 11.04% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 10 REVENUE BUDGET 2015 - 2016 JCEF Account 35104 35105 35110 Description 2012 Actual LOCAL JCEF TIME PAYMENTS FILL THE GAP RESTRICTED TRANSFER FROM GF MCEF SUSPENSION FEE TOTAL REVENUE $ 2013 Actual 2014 Actual 7,050 1,632 6,964 523 5,545 - - - 75 8,682 $ 7,487 $ 5,620 2015 10-month Actual 2015 Budget 2016 Projected 2016 % Change $ 7,000 1,000 37,000 150 $ 3,962 - $ 7,000 1,000 150 0.00% 0.00% 100.00% 0.00% $ 45,150 $ 3,962 $ 8,150 -81.95% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 11 REVENUE BUDGET 2015 - 2016 GRANTS Account Description 2012 Actual HOUSING & COMM DEVELOPMENT FIRE POLICE PUBLIC WORKS LIBRARY TRANSFER FROM GENERAL FUND TRANSFER FROM HURF TRANSFER FROM CAPITAL PROJ TRANSFER FROM AIRPORT 10,098 16,075 37,288 637,465 548 82,331 TOTAL REVENUE 929,442 $ 2013 Actual 2014 Actual 186,434 3,859 50,817 383,953 1,060 62,703 74,651 - 127,181 18,456 $ 763,477 $ 2015 10-month Actual 2015 Budget 144,334 4,988 151,899 166,042 11,932 153,371 - $ 632,565 $ 326,750 107,717 187,650 4,652,248 75,422 158,471 $ 15,000 5,523,258 $ 2016 Projected 7,098 162,722 44,442 - 1,309,212 73,789 174,200 850,000 77,500 1,584 - - 300.68% -31.50% -7.17% -81.73% 2.76% -99.00% 0.00% 0.00% 0.00% 2,486,285 -54.99% 214,262 $ 2016 % Change $ 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 12 REVENUE BUDGET 2015 - 2016 HOUSING Account 33212 33701 33703 39101 39112 Description 2012 Actual 2013 Actual HOUSING REIMB $ COUNTY/HOUSING IGA CASAS PIONEER REIMB TRANSFER FROM GF (Lead) TRANSFER FROM GF (TRANSIT) TRANFER FROM GRANTS 312,977 40,188 $ TOTAL REVENUE 353,165 $ $ 2014 Actual 287,404 45,780 23,535 $ 356,719 $ 2015 7-month 10-month Actual 2015 Budget 302,629 - $ 302,629 $ 276,574 - $ 276,574 $ 2016 Projected 210,704 - $ 210,704 $ 2016 % Change 236,288 - -14.57% #DIV/0! 0.00% #DIV/0! 0.00% 0.00% 236,288 -14.57% 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 13 REVENUE BUDGET 2015 - 2016 SANITATION Account 31301 34603 36101 38001 38201 39104 39301 Description 2012 Actual 2013 Actual 2014 Actual 2015 10-month Actual 2015 Budget 2016 Projected 2016 % Change SALES TAX - CITY SUBSIDY GARBAGE COLLECTION FEE INVESTMENT EARNINGS MISCELLANEOUS SALE SURPLUS PROPERTY TRANSFER-SPEC PROJ CAPITAL LEASE PROCEEDS $ 1,237,376 385 73 - $ - $ 1,205,675 3,383 (834) - 1,202,756 2,460 51 - $ 1,200,000 1,200 - $ 1,010,870 2,263 - $ 1,200,000 2,700 - 0.00% 0.00% 125.00% 0.00% 0.00% 0.00% 0.00% TOTAL REVENUE $ 1,237,834 $ 1,208,225 1,205,266 $ 1,201,200 $ 1,013,132 $ 1,202,700 0.12% $ 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 14 REVENUE BUDGET 2015 - 2016 WATER FUND Account 33201 33301 34601 34601 34601 34601 34601 36101 37001 38001 38001 38005 38006 39110 Description 2012 Actual GRANT REIMBURSEMENT NAD BANK WATER SERVICE 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 2013 Actual 274,140 65,719 1,624,027 330,075 5,600 2,353,702 2015 Budget 1,626,990 327,703 44,800 1,650,000 330,000 20,000 8,212 1,320 70,734 104 - 5,000 19,578 211 1,635,925 328,665 7,980 3,836 9,605 40,692 8 $ 2014 Actual 15,828 6,325 53,296 (113) $ 2,067,694 $ 2,079,864 2015 10-month Actual 1,248,119 273,324 10,500 20 345 6,077 80,335 (46) - 50,000 58,666 $ 2,113,666 2016 Projected $ 1,618,674 1,635,000 330,000 20,000 21,000 13,000 7,000 58,666 0.00% 0.00% -0.91% 0.00% 0.00% 0.00% 0.00% 40.00% 0.00% -58.00% 0.00% #DIV/0! 0.00% 100.00% 2,105,666 -0.38% 21,000 $ 2016 % Change 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 15 REVENUE BUDGET 2015 - 2016 WASTE WATER FUND Account 33301 34602 34602 1 36101 38001 38006 39101 39107 Description 2012 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 $ 2013 Actual 2014 Actual 517,111 1,434,278 334,176 21,000 3,825 6,794 - 1,660 1,486,503 327,966 6,800 4,259 14,502 - 1,487,530 328,757 59,935 11,405 4,184 - - - - 2,317,183 $ 1,841,690 $ 1,891,810 2015 10-month Actual 2015 Budget 1,251,497 275,817 13,825 6,430 5,307 - 1,485,000 328,000 20,000 8,000 4,000 425,000 575,000 2,845,000 $ 1,552,877 2016 % Change - 0.00% 1.01% 0.00% 0.00% 0.00% 0.00% 100.00% 100.00% #DIV/0! 0.00% 2,960,000 4.04% 1,500,000 328,000 20,000 8,000 4,000 550,000 550,000 - $ 2016 Projected $ 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 16 REVENUE BUDGET 2015 - 2016 AIRPORT FUND Account 33221 34880 34880 36201 36201 36201 38001 39103 39104 39299 39300 Description 2012 Actual 2013 Actual FEDERAL GRANTS FUEL SALES (100 LL) 38,739 FUEL SALES (JET A) 61,979 RENTAL PAYMENTS 5,058 5 SMALL HANGAR 14,970 10 TRAILER RENT 2,400 MISCELLANEOUS REVENUE TRANSFER FROM LTAF TRANSFER FROM GENERAL FUND FBO LEASE PAYMENT CATHOLIC COMMUNITY SERVICES LEASE PAYMENT 1 2 TOTAL REVENUE $ 123,146 $ 2014 Actual 7,377 32,126 47,200 9,769 14,400 2,550 12,722 22,265 148,409 2015 Budget 14,108 23,718 77,611 8,170 14,980 4,056 15,933 $ 158,576 2015 10-month Actual $ 30,500 54,000 8,500 14,700 5,044 38,594 $ 151,338 $ 2016 Projected 19,278 51,991 3,151 12,250 3,617 15,136 105,423 60,302 - 0.00% -28.00% -4.44% 0.00% 0.00% -46.47% 0.00% 0.00% 56.25% #DIV/0! #DIV/0! 0.00% 159,762 5.57% 21,960 51,600 8,500 14,700 2,700 $ 2016 % Change 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 17 REVENUE BUDGET 2015 - 2016 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 2012 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 SUBSIDY FROM GEN FUND CAPITAL LEASE PROCEED TOTAL REVENUE $ 2013 Actual 2014 Actual 2015 Budget 38,631 (5) 1,762 315 317 30 384,808 252,648 180,432 75,000 160,251 - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.00% 0.00% 0.00% 100.00% #DIV/0! 0.00% 0.00% -100.00% 513,716 71,677 318,755 - 174,665 - 25,000 - 20,833 - - -100.00% 0.00% - -100.00% 571,718 $ 355,127 - $ 75,000 - $ 100,000 21,179 374 4,187 6,648 338 15,145 911 11,489 7,185 2,574 5,689 1,458 22,570 9,705 49,330 2 975 - $ 2016 % Change 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) $ $ 2016 Projected 32,631 603 6,268 6,489 25,125 1,880 26,219 14,002 6,414 715 17,982 3,982 46,810 12,873 87,601 50,982 5,602 - 970,195 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 2015 10-month Actual - 492 0 $ 181,084 - $ 7/10/2015 9:52 AM Budget 16 Final for Website Section 2 - Page 18 GENERAL FUND ADMINISTRATION 001-51001-413 Account Description 2012 Actual 2013 Actual 2014 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 331,942 19 15,457 514 24,436 32,027 23,656 1,164 540 - 384,587 0 0 1,527 28,088 42,052 7,415 1,485 829 25,195 375,777 $ 350,268 0 0 4,008 26,818 26,796 41,295 40,211 7,336 6,194 1,424 968 894 754 29,712 20,513 $285,382 1,819 20,717 32,972 5,426 691 617 15,573 $ 344,186 26,330 39,065 5,256 980 750 23,261 -1.74% 0.00% 0.00% 0.00% -1.74% -2.85% -15.14% 1.16% -0.43% 13.39% ####### $ 445,704 $ 363,199 $ 439,829 -1.32% 3,000 4,750 1,000 1,500 5,000 10,000 6,670 500 6,820 1,000 2,936 3,624 280 1,756 3,719 15,188 6,027 165 1,041 165 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% 20.00% 0.00% 0.00% 0.00% -30.00% $ 40,240 $ 34,901 $ 41,940 4.22% ####### $ 485,944 $ 398,100 $ 481,769 -0.86% 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 $ 429,756 3,849 $ 491,178 3,948 0 13,245 8,119 6,414 410 3,851 559 14,523 15,175 7,770 337 1,633 1,529 Operating Expense $ 36,447 $ 44,915 Total Expenses $ 466,203 $ 536,093 3,983 0 978 0 9,523 16,780 6,187 243 340 379 $ 38,414 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change CAPITAL OUTLAY 2016 2016 Item Requested Approved* Xerox DocuMate 4790 Document Scanner 4,500 Total $ 4,500 $ - Budget 16 Final for Website Section 3 - Page 1 *Budgeted in GF Department 1801 7/10/2015 9:52 AM 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 2012 Actual 2013 Actual $ Contractual Auto/equip Travel/training Office supplies Postage Books/dues/subscrip Gas/oil/lube Marketing/Promotions - 2014 Actual $ - $ 2015 2015 YTD 2016 2016 Budget 4/30/2015 Requested % 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% 25,000 12,500 - 3,000 2,513 7,103 Operating Expense $ 28,000 $ 15,013 $ 7,103 Total Expenses $ 28,000 $ 15,013 $ 7,103 - 2,000 $ - $ 2,000 $ - 0.00% $ - $ 2,000 $ - 0.00% CAPITAL OUTLAY Budget 16 Final for Website Items 2016 2016 Requested Approved* *Budgeted in GF Department 1801 Total $ - $ - Section 3 - Page 2 7/10/2015 9:52 AM GENERAL FUND VISITOR CENTER 001-51005-419 Account Description 2012 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 30,904 996 630 2,476 3,129 4,554 148 67 - Personnel Expense Operating Expense 3001 4104 4105 4302 4303 5801 6001 6014 6015 6201 6401 6601 8009 2013 Actual 2014 Actual 26,687 1,313 0 0 2,146 2,964 1,482 130 77 2,280 20,407 2,670 0 141 1,781 2,396 701 109 145 1,402 2015 Budget 16,670 2,000 1,428 1,914 1,148 66 42 1,396 2015 YTD 2016 2016 4/30/2015 Requested % Change 16,383 2,621 290 20 1,484 1,821 1,174 61 85 766 17,004 2,000 1,454 1,930 1,134 67 43 1,573 2.00% 0.00% 0.00% 0.00% 1.79% 0.84% -1.22% 2.00% 2.09% 12.73% $ 42,905 $ 37,078 $ 29,752 $ 24,664 $ 24,704 $ 25,205 2.19% 7,766 9,268 7,417 1,331 7,390 848 165 773 131 13,917 411 209 2,347 179 89 13,917 1,526 7,957 6,588 4,499 909 2,325 242 13,917 7,285 8,550 450 7,600 1,500 250 600 2,500 200 13,917 100 10,000 6,741 335 4,565 985 285 1,223 141 10,438 2,470 8,550 450 7,600 1,500 250 600 2,500 200 13,917 100 10,000 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% Operating Expense $ 31,911 $ 35,774 $ 43,722 $ 45,667 $ 27,183 $ 45,667 0.00% Total Expense $ 74,816 $ 72,852 $ 73,474 $ 70,331 $ 51,887 $ 70,872 0.77% Contractual serv Telephone Services Utilities Building Maintenance Computer Maintenance Travel/training Office supplies Museum Collections Museum ProShop Postage Books/Dues/Subscrip Uniforms Marketing/Promotions CAPITAL OUTLAY Item 0 0 Total Budget 16 Final for Website 2016 2016 Requested Approved* *Budgeted in Capital Projects $ - $ Section 3 - Page 3 7/10/2015 9:52 AM 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 2012 Actual 36,706 2,807 470 9 66 $ 40,059 Contractual Services Utilities Building Maintenance Office supplies Uniforms 2014 Actual 2015 2015 YTD 2016 2016 Budget 4/30/2015 Requested % Change 27,242 2,084 2,128 27 61 $ 31,542 $120 2,652 41 225 86 135 1748 216 46 71 $3,125 $2,216 $ 43,184 $ 33,757 Operating Expense Total Expense 2013 Actual $ - $ 884 95 - $ - $ - $ - 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% - 0.00% 0.00% 0.00% 0.00% 0.00% - 798 $798 $ - 0.00% 798 $ - 0.00% $979 $ - 979 $ - $ CAPITAL OUTLAY Budget 16 Final for Website Item 2016 2016 Requested Approved* *Budgeted in GF Department 1801 Total $ - $ - Section 3 - Page 4 7/10/2015 9:52 AM 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 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 2012 Actual 2013 Actual 2014 Actual 294,715 20,996 26,417 33,543 1,170 559 - 253,174 0 0 74 18,365 27,314 11,884 1,197 862 25,979 284,142 $ 294,859 0 0 0 20,527 22,557 32,114 33,850 13,923 9,643 1,389 1,105 718 658 40,137 30,770 $ 377,401 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change $ 231,912 16,713 26,629 10,706 774 518 25,322 $ 300,776 23,009 34,138 6,423 1,128 673 40,228 2.01% 0.00% 0.00% 0.00% 2.01% 0.85% -33.39% 2.13% 2.31% 30.74% $ 338,850 $ 392,949 $ 393,441 $ 312,573 $ 406,376 3.29% 124,819 128,143 979 3,346 13,047 10,865 945 - 129 2,141 10,635 11,231 1,437 - 129,482 774 1,118 $21 11,409 487 - 132,145 5,700 1,500 500 1,220 11,000 7,050 765 - 110,782 4,635 432 120 973 7,725 11,107 1,285 - 122,855 5,700 1,500 500 1,220 8,200 7,050 765 180 -7.03% 0.00% 0.00% 0.00% 0.00% -25.45% 0.00% 0.00% 100.00% Operating Expense $ 154,001 $ 153,717 $ 143,291 $ 159,880 $ 137,059 $ 147,970 -7.45% Total Expenses $ 531,402 $ 492,567 $ 536,240 $ 553,321 $ 449,632 $ 554,346 0.19% CAPITAL OUTLAY Items 2016 2016 Requested Approved* *Budgeted in GF Department 1801 1 Inventory Control Program w/ scanners 12,000 Total Budget 16 Final for Website $ 12,000 $ Section 3 - Page 5 - 7/10/2015 9:52 AM GENERAL FUND HUMAN RESOURCES 001-51301-415 2012 Actual 2013 Actual 2014 Actual 169,777 4,771 13,234 19,000 4,694 753 386 14,565 7,673 2,073 1,600 1,200 2,731 175,982 926 45 13,287 19,893 2,761 776 448 14,818 15,291 1,276 1,600 1,250 3,304 $ 181,496 6,217 14,360 21,549 6,570 638 419 10,000 15,000 2,500 2,500 1,500 8,373 $ 143,098 183 10,888 16,452 3,006 418 320 2,389 9,382 1,174 1,550 1,200 1,881 $ 200,793 6,341 15,846 23,510 6,486 693 464 10,000 15,000 2,500 9,440 10.63% 0.00% 2.00% 0.00% 10.35% 9.10% -1.28% 8.63% 10.68% 0.00% 0.00% 0.00% -100.00% -100.00% 12.73% $ 231,869 $ 242,457 $ 251,657 $ 271,122 $ 191,940 $ 291,072 7.36% 4,327 2,434 3,141 40,564 5,296 1,907 32,598 84,182 24,476 6,927 1,602 471 2,247 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 5,400 3,200 35,600 4,750 900 132,300 50,000 1,000 4,000 2,000 300 1,190 6,065 3,066 31,385 3,157 242 98,767 7,239 349 6,163 664 234 1,020 6,000 3,200 33,510 4,000 900 132,300 50,000 1,000 4,000 1,700 300 2,005 11.11% 0.00% 0.00% -5.87% -15.79% 0.00% 0.00% 0.00% 0.00% 0.00% -15.00% 0.00% 68.49% Operating Expense $ 170,371 $ 188,141 $ 189,272 $ 240,640 $ 158,351 $ 238,915 -0.72% Total Expense $ 402,240 $ 430,598 $ 440,929 $ 511,762 $ 350,291 $ 529,987 3.56% Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2008 2009 2010 2011 2016 Salaries 169,088 Sal - Temp 226 Sal - Ltd 5,352 Sal - OT 66 OASI 13,106 State Retire 17,368 Health Ins 10,400 Income Protect 683 State Comp 336 Unempl. Ins 7,559 HR Processing 6,378 SF Terrorism Premium 1,308 Cancer Insurance-Police Cancer Insurance-Fire Self-funding Ins Claims/fees 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 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change CAPITAL OUTLAY Item 0 Total 2016 2016 Requested Approved* *Budgeted in GF Department 1801 $ - $ Section 3 - Page 6 Budget 16 Final for Website 7/10/2015 9:52 AM 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 2012 Actual 2013 Actual 2014 Actual 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 94,651 12,122 80,069 476 11,060 16,846 11,518 541 175 - 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 $ 128,257 $ $ 21,441 11,452 17,185 5,426 535 153 13,048 $ $ $ 72,307 49,224 360 8,958 13,993 2,638 321 125 7,787 $ 140,344 $ $ 21,441 12,377 18,363 7,070 583 138 17,923 9.42% 0.00% 0.00% 0.00% 8.07% 6.85% 30.30% 8.97% -9.90% 37.37% $ 227,458 $ 163,811 $ 191,654 $ 197,496 $ 155,712 $ 218,237 10.50% 188,690 157,549 19,391 2,771 3,130 2,029 - 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 - 161,770 5,550 1,500 500 15,000 10,000 3,500 50 2,000 - 141,084 5,510 293 79 7,567 9,279 1,723 30 649 815 162,370 5,550 1,200 500 15,000 10,725 3,500 50 2,000 - 0.37% 0.00% -20.00% 0.00% 0.00% 7.25% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 373,560 $ 346,349 $ 298,910 $ 199,870 $ 167,029 $ 200,895 0.51% Total Expense $ 601,018 $ 510,160 $ 490,563 $ 397,366 $ 322,741 $ 419,132 5.48% 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 6501 Gas/oil/lube CAPITAL OUTLAY Budget 16 Final for Website Items Backup Hardware 2016 2016 Requested Approved* *Budgeted in Capital Projects 26,000 - TOTAL $ 26,000 Section 3 - Page 7 $ - 7/10/2015 9:52 AM GENERAL FUND GENERAL GOVERNMENT 001-51501-413 Account 2012 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 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 8005 ADOR Tax Administration 8008 Employee Reward Program 8101 Special Events 8104 4th of July Expense 8106 Youth Activity Expense 8109 League of Cities Event 8110 Douglas Days 9902 Transfer to HURF 9904 Transfer to Capital Projects 9906 Transfer to Airport 9911 Transfer to Housing 9913 Transfer to Golf Course Transfer to JCEF 9915 Transfer to Grants 9916 Transfer to Bonds 9917 Transfer to Debt Service Budget 16 Final for Website 2013 Actual 18,157 5,703 1,708 43 $ 25,610 2014 Actual 18,045 1,232 41 $ 19,317 $ 2015 Budget 18,428 1,248 47 - $ 18,000 19,723 $ 19,417 $ 2015 YTD 4/30/2015 $ $ 2016 Requested 14,214 854 31 - $ $ 15,099 $ 733 6,702 4,349 754 733 588 1,172 953 2,391 1,069 20,551 111,094 8,872 498 12,761 15,000 567 16,500 3,460 310 2,854 2,300 155,368 15,136 20,833 1,377 40 - 18,000 2016 % Change 1,377 40 - 0.00% 0.00% 0.00% 0.00% 0.30% 0.00% $ 19,417 0.00% $ 271,601 1,063,569 30,000 5,000 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 51,336 1,000 16,250 6,000 1,000 2,200 15,000 60,302 120,000 1,584 1,233,567 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -7.53% 0.00% -2.44% -15.00% -100.00% -17.49% 0.00% 0.00% 0.00% -1.52% 50.00% 0.00% 0.00% 0.00% 0.00% -100.00% 56.25% 0.00% 380.00% -100.00% -99.00% -100.00% -3.04% 2,925 28,112 25,422 4,126 5,158 1,676 640 321 972 3,181 878 20,081 8,659 11,497 1,384 598 162 789 8,532 1,940 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 240,000 513,716 22,265 45,780 318,755 82,331 321,547 1,149,223 62,703 325,691 1,147,062 31,757 15,933 174,665 153,371 326,160 1,357,254 5,000 3,000 4,000 2,000 2,000 2,000 2,000 2,000 2,000 1,370 21,250 10,000 51,249 10,000 19,821 770,168 15,000 1,000 16,500 4,000 1,000 2,200 15,000 63,000 38,594 25,000 37,000 158,471 325,922 1,272,178 Operating Expense $ 2,433,870 $ 2,055,067 $ 2,248,802 $ 2,882,722 $ 1,740,719 $ 2,302,217 -20.14% Total Expenses $ 2,459,481 $ 2,074,384 $ 2,268,524 $ 2,902,140 $ 1,755,818 $ 2,321,634 -20.00% Section 3 - Page 8 7/10/2015 9:52 AM SPECIAL EVENTS SUPPORT FY 15/16 EVENT ROTARY - 4th ANNUAL FLY IN DOUGLAS WILLIAMS HOUSE DARC DOUGLAS ART ASSOCIATION TOTAL SPECIAL EVENTS Budget 16 Final for Website AMOUNT REQUESTED $ 750 1,000 13,000 2,500 17,250 Section 3 - Page 8A AMOUNT RECOMMENDED $ 750 1,000 13,000 1,500 16,250 AMOUNT APPROVED $ - 7/10/2015 9:52 AM GENERAL FUND MAGISTRATE 001-51601-412 Account 2012 Actual Description Personnel Expense 1001 Salaries 1003 Sal - Temp 1005 Sal - Overtime 2001 OASI 2002 Retirement 2004 Health Ins 2005 Income Prot. 2006 State Comp 2016 Self Fund Ins Claims 2013 Actual 2014 Actual 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 46,312 3,388 4,606 3,121 204 83 - 46,222 3,446 5,032 1,821 238 103 1,975 43,672 2,025 3,439 4,828 1,579 227 116 2,670 $ 38,812 6,500 3,466 4,456 768 154 101 7,466 $ 30,603 4,136 2,645 3,521 1,858 111 128 2,012 $ 39,078 6,500 3,487 4,435 327 155 102 8,484 0.69% 0.00% 0.00% 0.59% -0.45% -57.39% 0.69% 0.89% 13.64% $ 57,715 $ 58,837 $ 58,555 $ 61,723 $ 45,013 $ 62,568 1.37% 15,000 - 15,000 - 15,000 47 - 15,000 - 12,500 363 - 15,000 - 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 15,000 $ 15,000 $ 15,047 $ 15,000 $ 12,863 $ 15,000 0.00% Total Expense $ 72,715 $ 73,837 $ 73,602 $ 76,723 $ 57,876 $ 77,568 1.10% Personnel Expense Operating Expense 3001 Contractual Services 5801 Travel/Training 6001 Office Supplies 6201 Postage 6401 Books/Dues/Subscr. CAPITAL OUTLAY 2016 2016 Requested Approved* *Budgeted in JCEF Items 0 Total Budget 16 Final for Website $ - $ Section 3 - Page 9 - 7/10/2015 9:52 AM GENERAL FUND LIBRARY 001-51701-412 Account 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 2012 Actual 2013 Actual 2014 Actual 2015 Budget 2015 YTD 4/30/2015 2016 2016 Requested % Change 89,435 56,004 5,290 292 11,385 9,452 10,323 411 453 - 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 $ 121,462 74,000 14,953 13,944 8,931 482 436 11,164 $ 85,715 45,556 9,091 596 10,706 9,283 3,264 257 553 3,194 $ 131,429 74,000 15,715 14,917 8,819 522 460 12,586 8.21% 0.00% 0.00% 0.00% 5.10% 6.98% -1.25% 8.21% 5.41% 12.73% $ 183,045 $ 206,758 $ 197,621 $ 245,371 $ 168,215 $ 258,448 5.33% 46,536 14,773 40,360 7,520 42,247 8,919 374 914 9,290 25,168 974 - 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 25,816 41,512 42,450 9,300 3,000 2,000 250 9,650 24,973 1,700 - 25,915 45,386 32,530 1,965 1,607 775 3,989 19,028 1,163 - 10.88% -7.71% 0.00% 0.00% -19.35% 0.00% -50.00% 380.00% -33.68% 8.12% 0.00% 0.00% 0.00% Operating Expense $ 131,135 $ 101,852 $ 129,849 $ 160,651 $ 132,356 28,625 38,310 42,450 7,500 3,000 1,000 1,200 6,400 27,000 1,700 $ 157,185 Total Expenses $ 314,180 $ 308,610 $ 327,470 $ 406,022 $ 300,571 $ 415,633 2.37% 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 -2.16% CAPITAL OUTLAY Budget 16 Final for Website Items 2016 2016 Requested Approved* *Budgeted in Capital Projects Inventory Device Library Furniture Upgrades and Additions Marketing/Branding to promote SP and Policies Exterior Painting 0 Total 5,500 15,000 25,000 $ 45,500 Section 3 - Page 10 $ - 7/10/2015 9:52 AM GENERAL FUND COMMUNITY DEVELOPMENT NEIGHBORHOODS/GRANTS 001-52001-419 pg 14 Account 2012 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 2013 Actual 2014 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 $ 63,737 $ 83,434 $ 28,925 $ 74 622 457 1,541 318 101 1,348 196 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 48,357 58,510 50 3,379 4,822 5,835 201 1,093 - 2015 2015 YTD 2016 2016 Budget 4/30/2015 Requested % Change Operating Expense $ 4,657 Total Expenses $ 68,394 $ 3,631 $ 87,066 $ - $ $ - $ - - $ - $ - - - - 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 $ - $ - $ - 0.00% $ 29,192 $ - $ - $ - 0.00% CAPITAL OUTLAY Budget 16 Final for Website Items 2016 2016 Requested Approved* *Budgeted in GF Department 1801 Total $ - $ - Section 3 - Page 11 7/10/20159:52 AM GENERAL FUND TRANSIT -- pg 18 Account 2012 Actual Description 2013 Actual 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 2008 HR Processing 2016 Self Funding Ins Claims/Fees Personnel Expense $ Total Expenses $ 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 59,751 11,522 94,353 2,268 12,396 17,016 14,922 668 5,294 941 11,642 58,812 24,321 112,747 1,793 14,381 20,181 12,329 867 5,804 238 30,313 $ 119,887 197,880 5,988 24,767 37,167 18,186 1,269 7,084 1,440 35,864 $ 55,003 16,339 87,386 2,711 11,742 16,574 7,886 499 4,153 812 21,063 $ 110,013 197,880 5,988 24,012 35,626 17,422 1,229 6,665 1,440 49,050 -8.24% 0.00% 0.00% 0.00% -3.05% -4.15% -4.20% -3.09% -5.92% 0.00% 36.77% $ 230,773 $ 281,784 $ 449,532 $ 224,167 $ 449,324 -0.05% 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,030 7,000 3,200 15,000 3,000 7,378 1,650 7,250 1,000 3,000 100 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 - 55,000 3,000 24,384 $8,391 4,708 2,196 14,165 84 108 36 1,620 2,930 598 834 117 34,685 1,198 - 46,000 2,000 11,798 -0.27% -7.14% 9.38% 20.00% -40.73% 0.00% 8.43% 384.85% -37.93% 50.00% 33.33% 0.00% 0.00% -16.36% -33.33% -51.62% $0.00 $ 62,128 $ 92,190 $ 141,992 $71,671.20 $ 128,176 -9.73% - $ 292,901 $ 373,974 $ 591,524 $ 577,500 -2.37% - 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 Operating Expense 2014 Actual $ 295,838 CAPITAL OUTLAY Items 2016 2016 Requested Approved* *Budgeted in GF Department 1801 1 40ft Passenger Bus 136,000 Bay & Lift 53,820 12 Bus Stops 52,676 14 Benches 7,350 Supervisor vehicle 40,084 Bus Cameras 16,416 12 Bus stops shelters / benches 46,824 0 Total $ 353,170 Budget 16 Final for Website 136,000 53,820 52,676 7,350 40,084 16,416 46,824 $ 353,170 Section 3 - Page 26 7/10/2015 9:52 AM GENERAL FUND CEMETERY 001-52021-452 Account 2012 Actual 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 $ 68,665 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 661 2,606 4,079 10,310 196 1,589 $ 59,838 $ 59,548 1,160 2015 YTD 2016 2016 4/30/2015 Requested % Change $ 66,746 $ 22,843 500 7,039 10,563 4,465 301 4,518 5,582 $ 23,299 500 6,927 10,277 4,409 293 5,019 6,293 -2.80% 0.00% 2.00% 0.00% -1.59% -2.70% -1.25% -2.35% 11.09% 12.73% $ 118,984 $ 124,475 $ 98,207 $ 123,764 -0.57% 505 914 $800 7,173 3,582 3,088 122 55 4,784 4,788 461 63 6,011 285 3,735 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 3,500 3,000 3,500 400 2,500 150 250 2,500 3,000 1,000 6,500 1,500 1,050 4,000 $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 12.50% 4,536 1,067 $959 $333 2,711 2,960 1,900 527 1,324 144 394 2,569 2,755 954 3,838 2,184 1,041 2,863 0.00% 0.00% -28.57% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% -30.00% 0.00% -23.08% 0.00% -33.33% 0.00% Operating Expense $ 30,155 $ 41,475 $ 36,621 $33,650 $27,457 $31,150 -7.43% Total Expense $ 89,993 $ 101,023 $ 155,604 $ 158,125 $ 125,664 $ 154,914 -2.03% 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 30,730 2015 Budget $ 59,423 $ $ 12,301 2,405 5,639 7,656 3,537 209 3,193 3,844 Personnel Expense 40,397 2014 Actual CAPITAL OUTLAY Items Sprayer Chip Seal project Trees 0 TOTAL Budget 16 Final for Website 2016 2016 Requested Approved* *Budgeted in Capital Projects 5,400 30,000 5,000 $ 40,400 $ Section 3 - Page 12 7/10/2015 9:52 AM 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 2013 Actual 2014 Actual 2015 Budget 213,710 2,186 80,754 913 21,305 27,239 36,299 1,096 7,026 - 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 184,662 $ 390,529 $ 417,095 36,389 1,737 44,415 35,466 1,397 31,269 11,741 16,636 11,066 723 611 27,748 6,773 472 23,444 2015 YTD 2016 2016 4/30/2015 Requested % Change 239,747 96,181 500 21,523 32,298 7,987 843 8,870 35,444 141,932 5,364 36,260 1,825 13,792 20,329 6,559 524 6,181 13,687 34,949 500 21,052 31,235 14,075 955 9,006 35,847 29.83% 0.00% -63.66% 0.00% -2.19% -3.29% 76.22% 13.23% 1.54% 1.13% $ 358,208 $ 388,309 $ 246,451 $ 387,366 -0.24% 2,698 3,215 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 500 35,000 1,000 42,000 800 9,000 14,000 400 10,000 1,500 500 26,000 10,000 3,000 18,000 2,000 3,150 4,000 280 26,482 924 28,205 841 8,052 4,983 32 6,968 537 196 16,904 5,801 2,177 11,525 2,184 2,074 1,767 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 0.00% 0.00% 0.00% -16.67% 0.00% 0.00% 0.00% 0.00% 0.00% -33.33% -40.00% 0.00% 0.00% 0.00% 0.00% 0.00% -27.78% 0.00% -22.22% -25.00% Operating Expense $ 171,031 $ 165,579 $ 175,884 $ 180,850 $ 119,931 $ 166,450 -7.96% Total Expenses $ 561,561 $ 582,674 $ 534,092 $ 569,159 $ 366,383 $ 553,816 -2.70% 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 6025 Rye Grass Seed 6301 Small tools 6401 Books/dues/subscrip 6501 Gas/oil/lube 6502 Diesel/Oil 6601 Uniforms 6701 Construction materials Budget 16 Final for Website 2012 Actual Section 3 - Page 13 7/10/2015 9:52 AM GENERAL FUND PARKS 001-52023-452 CAPITAL OUTLAY 2016 2016 Items Requested Approved* *Budgeted in Capital Projects Portable gas generator with elder 8,000 Playground upgrades 10,000 Plaground Canopy 10,000 Exercise Stations at Aiport Park Partnership 10,000 Total Budget 16 Final for Website $ 38,000 $ Section 3 - Page 13 - 7/10/2015 9:52 AM 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 2012 Actual 2013 Actual 2014 Actual 17,319 41,152 16,078 357 5,525 3,368 3,637 117 1,791 - 17,852 40,540 17,066 691 5,657 4,553 503 136 2,471 3,493 $ 89,343 $ 92,963 11,577 2,017 8,809 3,374 3,478 2,502 14,050 7 468 533 3,593 1,406 13,383 4 566 461 Operating Expense $ 34,633 $ 31,596 $ Total Expenses $ 123,976 $ 124,559 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 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 30,000 22,550 500 4,058 3,307 2,269 28 1,736 3,147 -100.00% -28.57% 2.00% 0.00% -49.80% -58.66% 100.00% -85.45% -47.89% -57.85% $ 39,695 $ 67,595 -49.42% 950 3,000 1,000 1,800 400 3,000 750 1,500 15,000 50 390 500 1,000 739 2,909 184 1,893 1,273 309 450 10,553 12 50 179 950 3,000 250 1,800 400 2,000 250 700 15,000 50 390 250 500 0.00% 0.00% -75.00% 0.00% 0.00% -33.33% -66.67% -53.33% 0.00% 0.00% 0.00% 0.00% -50.00% -50.00% 33,889 $ 29,340 $ 18,550 $ 25,540 -12.95% $ 125,594 $ 162,984 $ 58,245 $ 93,135 -42.86% $ 9,514 48,718 18,035 919 5,811 3,321 302 105 2,716 2,264 $ 41,068 42,000 22,108 500 8,084 8,001 896 190 3,332 7,466 $ 91,705 $ 133,644 2,862 230 1,492 2,312 50 817 25,548 11 253 315 18,369 15,992 2,631 1,600 18 1,084 - $ CAPITAL OUTLAY Items 2016 2016 Requested Approved* *Budgeted in GF Department 1801 Vehicle 20,000 PA System 9,000 Exercise Equipment for Senior CenterTotal $ 29,000 Budget 16 Final for Website $ - Section 3 - Page 14 7/10/2015 9:52 AM 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 Personnel Expense 64,771 84,369 229 10,407 12,194 6,467 4,605 295 3,827 - 2013 Actual 2014 Actual 67,168 99,080 (1,820) 13,339 13,589 7,998 4,531 354 5,731 5,455 70,588 83,027 5,788 307 8,250 12,839 9,510 4,648 397 5,924 7,315 2015 Budget $ 2015 YTD 2016 2016 4/30/2015 Requested % Change 71,906 75,000 16,464 500 10,000 13,301 10,202 4,465 286 6,858 5,582 $ 53,254 48,579 7,972 4,397 8,820 5,535 2,828 155 3,647 2,946 $ 39,801 80,000 16,464 500 10,000 11,228 6,443 4,409 159 6,258 6,293 -44.65% 6.67% 0.00% 0.00% 0.00% -15.59% -36.85% -1.25% -44.55% -8.75% 12.73% $ 187,165 $ 215,423 $ 208,591 $ 214,565 $ 138,134 $ 181,554 -15.38% 297 1,021 4,811 51,417 8,488 5,691 49,100 8,091 - 12,249 2,566 2,144 2,217 232 9,269 310 968 2,539 1,685 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 1,030 2,200 4,000 45,000 10,000 1,000 400 20,000 1,000 1,150 1,500 1,000 7,000 500 500 2,200 2,000 $3,887 $1,418 2,266 50,984 7,877 530 15,171 386 420 1,204 2,028 5,582 792 1,018 964 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 2091.26% 0.00% 0.00% 0.00% 0.00% 0.00% 125.00% 0.00% 0.00% 17.39% 0.00% 100.00% 21.43% 60.00% 0.00% 0.00% 0.00% -31.82% 0.00% Operating Expense $ 99,192 $ 102,089 $ 110,208 $100,480 $94,527 $ 124,820 24.22% Total Expenses $ 286,356 $ 317,513 $ 318,799 $ 315,045 $ 232,660 $ 306,374 -2.75% 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 Budget 16 Final for Website 2012 Actual Section 3 - Page 15 7/10/2015 9:52 AM GENERAL FUND AQUATICS 001-52035-451 CAPITAL OUTLAY Budget 16 Final for Website Items POS System Automation System for Main Pool ADA Doors 2 vehicles 0 2016 2016 Requested Approved* *Budgeted in Capital Projects 12,000 5,000 5,000 40,000 - Total $ 62,000 $ Section 3 - Page 15 - 7/10/2015 9:52 AM GENERAL FUND PUBLIC WORKS ADMINISTRATION 001-54001-431 Account 2012 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 2013 Actual 2014 Actual 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 126,501 3,526 4,053 80 9,246 12,427 18,103 537 3,352 - 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 $ 113,189 8,659 12,994 5,858 449 2,612 7,445 $ 75,702 611 5,574 8,763 4,176 271 1,754 4,801 $ 101,590 7,772 11,530 5,104 403 2,321 7,456 -10.25% 0.00% 0.00% 0.00% -10.25% -11.26% -12.86% -10.25% -11.13% 0.15% $ 177,827 $ 100,796 $ 102,225 $ 151,206 $ 101,653 $ 136,177 -9.94% - - - - - 1,805 3,739 6,014 727 479 177 3,194 1,634 33 - 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,300 1,000 1,500 1,000 3,600 5,000 500 600 450 200 1,000 2,200 600 - 3,062 2,104 226 2,205 1,443 172 506 2,128 462 512 71 3,300 1,000 2,600 1,000 3,600 4,000 500 600 450 200 1,000 2,200 600 - 0.00% 0.00% 0.00% 73.33% 0.00% 0.00% -20.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 17,802 $ 14,614 $ 12,181 $ 20,950 $ 12,891 $ 21,050 0.48% Total Expenses $ 195,629 $ 115,410 $ 114,406 $ 172,156 $ 114,544 $ 157,227 -8.67% 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 2016 2016 Requested Approved* *Budgeted in Capital Projects Items 4 passenger Vehicle 0 Total Budget 16 Final for Website 25,000 $ 25,000 $ Section 3 - Page 16 7/10/2015 9:52 AM GENERAL FUND PW CONSTRUCTION 001-54018-431 pg 17 Account 2012 Actual 2013 Actual 2014 Actual 193,680 34,985 1,404 16,473 22,821 28,197 947 13,446 - 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 $ 205,400 $ 1,000 15,790 23,695 10,561 817 11,091 19,328 $ 141,872 $ 51 10,271 16,295 6,795 507 5,928 12,313 $ 211,381 $ 1,000 16,247 24,105 10,001 840 11,362 21,856 2.91% 0.00% 0.00% 2.90% 1.73% -5.30% 2.91% 2.44% 13.08% $ 311,953 $ 267,386 $ 276,984 $ 287,680 $ 194,032 $ 296,794 3.17% 48,654 28,317 3,028 1,896 55,482 30,152 2,490 1,829 25,108 19,332 45 126 1,937 3,651 315 7,429 165 1,909 1,213 1,099 10,845 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 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 4,500 8,000 2,963 23,562 2,782 1,313 874 2,736 11,807 12,903 616 65 44 463 4,849 1,406 1,467 838 7,595 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 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% -44.44% 0.00% Operating Expense $ 155,069 $ 146,664 $ 127,773 $ 126,930 $ 76,285 $ 124,930 -1.58% Total Expenses $ 467,022 $ 414,049 $ 404,757 $ 414,610 $ 270,316 $ 421,724 1.72% 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 Utility Van Total Budget 16 Final for Website 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 2016 2016 Requested Approved* *Budgeted in GF Department 1801 35,000 $ 35,000 $ Section 3 - Page 17 7/10/2015 9:52 AM 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 2012 Actual 2013 Actual 2014 Actual 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 89,161 914 6,735 7,494 9,456 334 1,613 - 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 $ 95,012 1,000 7,345 11,022 4,341 378 2,902 11,652 $ 40,536 1,057 3,170 4,775 2,826 154 1,258 2,718 $ 98,030 1,000 7,576 11,240 3,859 390 2,956 13,204 3.18% 0.00% 3.14% 1.98% -11.12% 3.17% 1.86% 13.31% $ 115,706 $ 102,356 $ 82,657 $ 133,653 $ 56,495 $ 138,254 3.44% 38,580 2,246 4,983 86,512 4,853 86,018 140 1,261 2,392 2,588 386 800 4,087 724 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 $2,126 $550 5,500 4,000 400 1,000 900 3,500 2,500 500 2,000 2,000 1,400 $818 $983 4,364 1,072 32 16 213 595 368 1,509 1,051 $2,126 $1,150 5,500 3,000 400 500 900 2,500 1,500 500 2,000 2,000 1,400 0.00% 109.09% 0.00% -25.00% 0.00% -50.00% 0.00% -28.57% -40.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $142,453 $104,331 $16,502 $26,376 $11,022 $23,476.00 -10.99% Total Expenses $ 258,159 $ 206,687 $ 99,159 $ 160,029 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 $ 67,517 $ 161,730 1.06% CAPITAL OUTLAY Items 2016 2016 Requested Approved *Budgeted in GF Department 1801 Vehicle Code Scanner Total Budget 16 Final for Website 4,500 $ 4,500 $ Section 3 - Page 18 - 7/10/2015 9:52 AM GENERAL FUND FIRE 001-55001-422 pg 23 Account 2012 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 2013 Actual 2014 Actual 624,776 12,050 1,965 69,440 12,451 3,755 231,405 72,196 1,962 29,880 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 $ 1,059,881 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 6401 Books/dues/subscrip 6501 Gas/oil/lube 6601 Uniforms Honor Guard Uniform 6701 Construction materials 2015 Budget 50,000 12,347 4,144 213,875 22,124 2,217 38,100 86,458 64,331 48,549 50,000 13,299 4,097 321,836 19,138 2,217 33,957 1,500 72,928 $ 1,146,362 $ 1,215,300 $ 1,026,529 954,418 $ 1,152,000 12.22% 17,118 8,292 2,739 24,624 10,814 2,875 18,102 12,583 18,882 12,357 824 17,214 1,003 2,924 5,676 420 3,263 2,451 505 1,203 19,530 12,378 119 679 17,219 1,142 6,533 6,210 459 2,121 782 3,306 1,052 1,469 20,499 11,717 115 89 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 1,467 18,615 10,077 786 - 22,986 5,000 3,500 17,730 18,000 16,000 4,500 1,500 500 8,900 250 2,500 3,000 300 300 500 3,000 500 1,025 14,000 12,858 500 500 21,337 3,414 4,069 13,597 17,921 10,239 3,919 24,006 785 5,243 3,170 87 2,843 838 2,245 762 723 11,878 7,412 111 - 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,025 14,000 10,458 500 500 1.04% 40.00% 14.29% 0.00% 0.00% 25.00% 0.00% 0.00% 0.00% 191.01% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -18.67% 0.00% 0.00% 159,189 15.48% $ 1,311,189 12.61% $ 126,343 Total Expense $ 1,186,224 $ 142,943 $ 1,289,305 $ 151,643 $ 1,366,943 $ 612,890 6,500 137,849 $ 1,164,378 $ $ $ 2016 2016 Requested % Change 516,650 14,090 99,029 11,619 3,398 205,732 19,327 1,494 34,532 Operating expense $ $ 2015 YTD 4/30/2015 $ $ 134,598 $ 1,089,016 $ $ $ 626,527 6,500 2.23% 0.00% 0.00% 0.00% 7.70% -1.13% 50.48% -13.50% 0.00% -10.87% 13.36% Section 3 - Page 19 Budget 16 Final for Website 7/10/2015 9:52 AM GENERAL FUND EMS 001-55052-422 pg 24 Account 2012 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 2013 Actual 2014 Actual 2015 Budget 639,430 88,123 7,694 202,993 70,263 1,537 31,325 - 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 $ 1,041,365 $ 1,180,077 $ 1,289,386 $ 1,203,333 1,900 7,745 14,878 1,100 128 5,868 66 456 50,812 6 335 10 50 17,970 - 25 3,998 228 788 58,526 26 648 63 50 16,651 - 7,960 8,165 8,651 103 6,559 55,634 44 57 87 50 15,840 81 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 Operating Expense $ 77,601 Total Expenses $ 1,118,967 $ 88,749 $ 1,268,826 $ 103,231 $ 1,392,617 $ 681,266 50,000 10,603 324,329 21,542 2,246 44,340 69,005 2015 YTD 4/30/2015 $ 694,217 50,000 11,567 483,071 18,132 2,246 39,350 78,265 1.90% 0.00% 0.00% 9.08% #DIV/0! 48.95% -15.83% 0.00% -11.26% 13.42% $ 1,024,388 $ 1,376,848 14.42% 6,978 889 2,463 4,920 312 1,272 43,798 28 10 50 10,879 - 15,578 1,100 400 5,550 250 3,000 55,000 300 200 1,000 1,800 15,000 - 4.70% 0.00% 0.00% 0.00% 0.00% 0.00% 16.84% 0.00% 0.00% 30.95% 0.00% 0.00% 566.67% 0.00% 0.00% 0.00% 105,178 17.09% $ 1,482,026 14.60% 6,000 400 4,750 250 3,000 42,000 300 200 150 1,800 15,000 $ 89,828 $ 1,293,161 $ 527,677 109,517 8,753 277,399 13,699 1,276 38,159 47,908 2016 2016 Requested % Change 71,599 $ 1,095,987 $ 6,000 $ Section 3 - Page 20 Budget 16 Final for Website 7/10/2015 9:52 AM GENERAL FUND EMS 001-55052-422 CAPITAL OUTLAY 2016 Items Requested Multi Use Vehicle (pull Haz-Mat, air and light Trailer) 125,000 Fire Truck 400,000 Ambulance 175,000 Type 6 Quick Attack Vehicle 80,000 New Roof 25,000 2 Rescue Tools (Jaws of Life) 30,000 3 Air conditioner replacement 20,000 2 bathroom replacement 4,500 SCBA Replacement (22 harnesses and 44 tanks) 160,000 Fire Chief Car 30,000 6 Radio Communication replacement 10,900 TOTAL $ 1,060,400 2016 Approved* *Budgeted in Capital Projects - $ - Section 3 - Page 20 Budget 16 Final for Website 7/10/2015 9:52 AM 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 2012 Actual 2013 Actual 38,946 219 13,455 3,595 5,950 1,112 248 133 - 9,382 $ 192,546 2.00% 1.98% 0.00% 10.11% 4.01% 3.41% 45.20% -41.32% 1.51% -6.20% 8,063 $ 88,042 39,098 20,000 5,798 6,708 50,985 1,269 352 3,032 2,000 16,968 15,372 14,931 $ 124,195 $ 79,030 $ 210,664 $ 100,774 $ 234,252 11.20% 59,752 82,827 12,099 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 91,200 29,750 35,000 500 7,000 2,500 1,000 5,600 8,000 11,650 1,750 4,124 2,000 760 1,000 55,386 23,347 26,201 2,085 5,275 4,848 924 4,592 5,194 17,423 831 4,650 896 1,015 308 257,113 29,750 35,000 500 8,850 6,500 1,000 1,300 1,000 8,000 16,700 1,806 10,204 4,000 760 1,000 181.92% 0.00% 0.00% 0.00% 26.43% 160.00% 0.00% 0.00% -82.14% 0.00% 43.35% 3.20% 147.43% 100.00% 0.00% 0.00% 36,886 12,810 35,017 13,776 13,877 2,712 2,193 10,527 8,538 958 1,112 2,076 1,003 - Operating Expense $ 152,443 $ 181,912 $ 164,206 $ 201,834 $ 152,977 $ 383,483 90.00% Total Expenses $ 344,989 $ 306,107 $ 243,236 $ 412,498 $ 253,751 $ 617,735 49.75% Section 3 - Page 21 Budget 16 Final for Website $ 2015 YTD 2016 2016 4/30/2015 Requested % Change $ 29,714 30,813 480 9,587 3,114 4,691 11,966 1,010 174 1,161 Operating Expense 3001 Contract. Serv. 4104 Telephone Services 4105 Utilities 4301 Auto/equip 4302 Building Maintenance 4304 Computer Maintenance 4303 Auction-related expenses 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 46,392 38,570 327 13,648 6,907 5,719 1,565 281 1,403 2015 Budget 86,316 38,337 18,164 5,574 6,486 35,113 2,163 347 3,233 Personnel Expense 108,226 38,068 484 11,584 10,845 4,993 (372) 14,599 338 3,781 2014 Actual 13.64% 7/10/2015 9:52 AM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 CAPITAL OUTLAY 2016 2016 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 2 Surveillance Camera Investigation 19,700 - *Budgeted in RICO 1 Interview Room 14,000 - *Budgeted in RICO 1 ID Printer 3,750 - *Budgeted in RICO 0 Total $ 197,450 $ 160,000 Section 3 - Page 21 Budget 16 Final for Website 7/10/2015 9:52 AM GENERAL FUND POLICE OPERATIONS 001-56041-421 pg 26 Account 2012 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 2014 Actual 2015 Budget 2015 YTD 4/30/2015 2016 Requested 2016 % Change 1,144,164 17,858 61,399 243,711 21,733 1,776 370,997 149,893 3,250 50,685 - 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,175,031 18,780 70,000 298,784 23,822 2,156 581,088 37,325 4,222 56,239 144,569 $ 918,313 3,712 41,758 177,895 16,310 426 415,983 34,951 2,551 38,456 85,274 $ 1,195,498 29,964 70,000 315,341 25,214 3,401 846,997 37,226 4,266 53,059 148,733 1.74% 59.56% 0.00% 5.54% 5.85% 57.75% 45.76% -0.26% 1.05% -5.65% 2.88% $ 2,065,466 $ 2,310,945 $ 2,226,944 $ 2,412,014 $ 1,735,627 $ 2,729,701 13.17% 19,631 237 7,976 55,402 17,278 22,500 1 4,656 86,668 20,787 24,773 8,549 78,369 19,762 22,500 7,087 90,289 22,205 2,500 75,000 19,710 0.00% 0.00% 0.00% 0.00% 4.01% 100,523 $ 119,710 0.64% $ 1,836,151 $ 2,849,411 12.58% Operating Expense 4301 Auto/equip 4302 Maintenance Cost 5801 Travel/training 6501 Gas/oil/lube 6601 Uniforms Budget 16 Final for Website 2013 Actual Operating Expense $ 119,581 Total Expenses $ 2,185,047 $ 112,112 $ 2,423,058 $ 131,453 $ 2,358,397 Section 3 - Page 22 2,500 75,000 18,950 $ 118,950 $ 2,530,964 $ 7/10/2015 9:52 AM GENERAL FUND POLICE SUPPORT 001-56071-421 pg 27 Account 2012 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 2014 Actual 2015 Budget 437,385 330,038 150,345 134,903 35,978 38,123 192,930 106,510 2,719 24,121 - 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 $ 1,453,050 $ 1,560,069 $ 1,621,253 $ 1,745,829 2,435 27,196 8,599 4,032 28,840 9,027 6,318 1,661 27,282 8,733 5,000 2,000 18,000 9,440 Operating Expense 4301 Auto/equip 5801 Travel/training 6501 Gas/oil/lube 6601 Uniforms Budget 16 Final for Website 2013 Actual Operating Expense $ 38,230 Total Expenses $ 1,491,279 $ 41,899 $ 1,601,968 $ 43,994 $ 1,665,247 Section 3 - Page 23 $ $ 481,370 349,075 45,000 291,601 41,355 40,074 328,985 29,520 2,941 31,459 104,450 34,440 $ 1,780,269 2015 YTD 4/30/2015 $ 0.61% 3.60% 0.00% 16.60% 4.13% 2.43% 51.62% -11.41% 1.70% -2.56% 8.34% $ 1,107,638 $ 1,986,834 13.80% 2,270 1,602 17,507 6,179 5,000 2,000 16,000 9,440 0.00% 0.00% -11.11% 0.00% 32,440 -5.81% $ 2,019,274 13.43% 27,558 $ 1,135,196 $ 2016 % Change 484,330 361,649 45,000 340,000 43,061 41,047 498,797 26,151 2,991 30,653 113,156 $ 355,351 240,508 20,817 145,098 27,393 33,057 182,525 20,245 1,855 16,780 64,009 2016 Requested $ 7/10/2015 9:52 AM 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 2012 Actual 2014 Actual 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 6,433 5,905 6,558 8,460 282 1,478 - 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 62,667 25,301 1,000 6,806 10,214 3,321 280 2,102 10,257 35,963 19,897 2,995 4,183 6,724 1,264 156 1,405 6,783 68,775 25,807 1,500 7,350 10,905 1,366 306 2,089 25,451 9.75% 0.00% 2.00% 50.00% 8.00% 6.77% -58.86% 9.08% -0.58% 148.14% $ 107,371 $ 108,516 $ 120,845 $ 121,947 $ 79,369 $ 143,550 17.71% 42,200 42,017 1,827 1,629 1,127 270 5,821 2,982 712 586 5,540 3,079 918 41,805 901 880 586 3,447 3,305 711 39,300 1,350 1,500 1,500 500 1,200 500 4,900 35 2,500 690 35,630 427 663 527 1,596 483 3,433 2,248 618 52,822 1,350 1,500 1,500 500 1,200 500 4,900 35 2,500 690 34.41% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 54,939 $ 53,769 $ 51,635 $ 53,975 $ 45,624 $ 67,497 25.05% Total Expenses $ 162,310 $ 162,285 $ 172,480 $ 175,922 $ 124,993 $ 211,047 19.97% 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 Budget 16 Final for Website 65,353 12,901 2013 Actual Section 3 - Page 24 7/10/2015 9:52 AM 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 2012 Actual 2013 Actual 2015 Budget 4,060 3,980 615 875 239 29 311 284 8,642 25 663 979 581 46 405 885 8,510 651 977 606 34 355 698 $ 5,255 $ 10,394 $ 12,225 $ 11,831 38,016 9,344 20,320 592 3,759 22,741 8,872 17,785 829 - - - 15,071 8,440 14,946 1,994 - Operating Expense $ 72,031 $ 50,227 Total Expenses $ 77,286 $ 60,620 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 Budget 16 Final for Website 0 4,304 34 330 437 9 141 - 2014 Actual 2015 YTD 2016 2016 4/30/2015 Requested % Change 6,831 523 784 449 25 285 502 9,114 697 1,034 599 36 389 787 7.10% 0.00% 0.00% 7.10% 5.89% -1.15% 7.10% 9.37% 12.73% $ 9,399 $ 12,657 6.98% 16,000 11,000 21,300 100 4,000 - 997 4,999 12,815 - 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,451 $ 52,400 $ 18,810 16,000 11,000 21,300 100 4,000 $ 52,400 $ 52,676 $ 64,231 $ 28,209 $ 65,057 1.28% - Section 3 - Page 25 0.00% 7/10/2015 9:52 AM GENERAL FUND CAPITAL EXPENDITURES 001-51801-419 2016 Account Description 7701 7702 7703 7704 7705 7706 7707 7708 7711 7712 7713 7714 7716 7717 7718 7719 7720 7721 7723 Budget 16 Final for Website 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 2012 Actual 2013 Actual 0 0 75399 0 0 0 70732 212231 0 32859 6616 0 0 0 0 0 2014 Actual 2015 Budget 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 - - - $ 397,838 $ 1,334,688 2015 YTD 2016 2016 4/30/2015 Requested % Change 80,000 392,746 3,941 42,884 13,100 20,699 15,733 80,000 353,170 - - - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -10.08% #DIV/0! #DIV/0! 0.00% $ 1,131,961 $ 472,746 $ 96,357 $ 433,170 -8.37% Section 3 - Page 27 7/10/2015 9:52 AM SPECIAL REVENUE FUNDS SUMMARY EXPENDITURES 2015 Budget REVENUES 2016 Budgeted Difference 2016 Budget 2016 Budgeted % Change 2015 Comparison of Revenues VARIANCE 2016 Revenues 2016 Rev vs. Exp H. U. R. F. $ 1,269,351 $ 1,307,411 $ 38,060 3.00% $ 1,269,351 $ 1,307,411 $ (0) LTAF $ - $ - $ - 0.00% $ - $ - $ - CAPITAL PROJECTS $ 1,697,000 $ 472,121 $ (1,224,879) -72.18% $ 613,000 $ 89,167 $ DEBT FUND $ 1,354,235 $ 1,315,624 $ (38,611) -2.85% $ 1,354,235 $ 1,315,624 $ - MPC FUND $ 486,450 $ - $ (486,450) -100.00% $ 486,450 $ - $ - RICO $ 158,000 $ 175,450 $ 17,450 11.04% $ 158,000 $ 175,450 $ - JCEF $ 100,840 $ 19,292 $ (81,548) 100.00% $ 45,150 $ 8,150 $ (11,142) GRANTS $ 5,523,258 $ 2,516,285 $ (3,006,973) -54.44% $ 5,523,258 $ 2,486,285 $ (30,000) HOUSING $ 280,574 $ 236,288 $ (44,286) -15.78% $ 276,574 $ 236,288 $ (0) GRAND TOTALS $ 10,869,708 $ 6,042,471 $ (4,827,237) -44.41% $ 9,726,019 $ 5,618,375 $ (424,096) Budget 16 Final for Website Section 4 - Page 1 (382,954) 7/10/2015 9:52 AM HIGHWAY USERS REVENUE FUND 101-54041-433 pg 29 Account 2012 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 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 Budget 16 Final for Website $ 2013 Actual 421,040 4,760 29,936 42,365 62,949 1,871 25,431 694 589,045 10,022 2,757 1,979 51,009 189,532 6,250 28,249 9,734 13,151 23,051 231 1,879 350 591 18,445 20,172 3,194 86,459 8,962 37,868 2014 Actual 360,935 2,536 26,000 37,721 14,298 1,737 25,870 384 46,996 $ 516,477 9,113 2,357 2,473 39,672 179,411 7,767 18,343 9,954 22,291 386 1,126 610 676 11,626 16,690 4,901 112,493 5,434 - $ 2015 Budget 2015 YTD 4/30/2015 2016 2016 Requested % Change 313,765 3,017 22,455 35,474 12,531 1,650 24,792 188 59,456 $ 318,448 3,000 24,591 36,902 11,372 1,268 24,654 1,000 1,000 45,701 $ 191,986 2,750 14,199 19,948 8,187 635 12,495 180 19,957 $ 313,460 3,000 24,209 35,918 10,897 1,248 23,029 1,000 1,000 46,521 -1.57% 0.00% 0.00% -1.55% -2.67% -4.18% -1.56% -6.59% 0.00% 0.00% 1.79% 473,328 $ 467,935 $ 270,338 $ 460,282 -1.64% 30,522 2,409 1,800 50,000 180,000 15,000 15,000 8,000 28,800 500 1,000 1,500 1,500 14,000 15,000 2,800 179,479 10,000 20,000 7,798 2,490 1,694 33,867 138,545 7,895 7,927 4,028 19,649 386 595 395 8,234 9,144 1,516 36,422 8,457 - 37,522 2,409 1,800 50,000 180,000 15,000 15,000 8,000 28,800 500 1,000 1,500 1,500 12,000 13,000 2,800 378,899 10,000 20,000 22.93% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% #DIV/0! 0.00% 0.00% 0.00% 0.00% 0.00% -14.29% -13.33% 0.00% 111.11% 0.00% 0.00% 18,191 2,409 2,591 48,421 183,196 7,952 5,539 21,122 25,000 235 15,355 140 332 12,471 12,170 2,676 173,516 6,826 56,170 Section 4 - Page 2 7/10/2015 9:52 AM HIGHWAY USERS REVENUE FUND 101-54041-433 pg 29 Account 2012 Actual 646 - Description 7401 Capital Outlay 7531 St Light Trpl Res Operating Expense 9901 9915 9916 9917 Gen Fund Reimb Transfer to Grants Transfer to MPC Transfer to Debt Service Total Expenses 2013 Actual 2014 Actual - - 514,531 445,326 594,313 40,997 162,910 203,907 45,289 74,651 160,415 2,485 282,840 42,136 160,646 14,425 217,207 $ 1,307,482 $ 1,244,643 $ 1,284,848 2016 Requested 2016 Approved $ 2015 2015 YTD Budget 4/30/2015 15,000 1,699 $ 592,310 $ 290,742 34,985 2016 2016 Requested % Change 18,000 0.00% 0.00% $ 797,730 34.68% 35,808 2.35% 160,529 13,592 209,106 27,409 133,774 11,327 172,509 13,592 49,399 -100.00% 100.00% -76.38% $ 1,269,351 $ 733,588 $ 1,307,411 3.00% CAPITAL OUTLAY Items 1 Tamper 3,000 3 UPS Inverter Battery Pack for Traffic Signals18,000 0 Total $ 21,000 Budget 16 Final for Website $ 18,000 18,000 Section 4 - Page 2 7/10/2015 9:52 AM 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 Budget 16 Final for Website 2012 Actual 2013 Actual 16,589 26,001 83,997 - 211,937 - $ 126,587 $ 211,937 2014 Actual 2015 Budget $ Section 4 - Page 3 - $ 2015 YTD 2016 2016 4/30/2015 Requested % Change - - - - - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% - $ - $ 7/10/2015 9:52 AM CAPITAL PROJECTS FUND 103-51081-419 pg 33 Account 7402 7603 7606 7608 7610 7614 7615 7616 7622 7624 7626 7627 7628 7629 7631 7632 8099 9915 9917 Description Vehicles Park Ramadas PW Facility Parks Lighting Program 3rd Street Extension Douglas Apartments Street Paving Sidewalks Capital Outlay Purchase Police Building Improvement Government Plaza Call Center City Hall Improvements Rivera Building Proj Port of Entry Health Dept Bldg Impr Reserve Funding Transfer to Grants Transfer to Debt Serv Total Expenses Budget 16 Final for Website 2012 Actual 2013 Actual 2014 Actual 2015 Budget 2015 YTD 4/30/2015 - - - - 449,782 - 47,396 - - - 1,042,929 - 14,716 64,133 12,831 15,940 47,992 44,096 4,219 1,622,000 - 127,181 60,000 64,099 - - 186,149 2,259 16,655 769 487,673 106,278 6,881 9,166 154,731 637 - $ 1,679,891 $ 203,174 $ 112,247 $ 1,697,000 $ 971,198 Section 4 - Page 4 75,000 2016 2016 Requested % Change - #DIV/0! #DIV/0! - 0.00% #DIV/0! 472,121 - -70.89% #DIV/0! 0.00% #DIV/0! 0.00% #DIV/0! -100.00% 0.00% - $ - 0.00% 0.00% 472,121 -72.18% 7/10/2015 9:52 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2015-2016 DEPT Administration Fire Visitor Center Visitor Center Parks Aquatics AMOUNT REQUESTED ITEM/PROJECT City Hall Bathroom Renovation Exterior Wall repair and paint Facility Upgrades for Social Events Doors Lighting Improvements all parks AC & 8th Street Pool Canopies AMOUNT RECOMMENDED TYPE $25,000 $7,000 $6,000 $5,000 $58,292 $9,000 $110,292 $25,000 $7,000 $5,000 $5,000 $58,292 $5,000 $105,292 Public Works Barn Facility Various GF Dpts Council Directed Projects $125,000 $64,502 $189,502 $125,000 Other Capital Capital Projects $64,502 Other Capital Capital Projects $189,502 Streets $177,327 Street Improvements Facilities Facilities Facilities Facilities Facilities Facilities FUNDING SOURCE $177,327 Streets Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects . TOTAL Budget 16 Final for Website $477,121 Section 4 - Page 5 $472,121 7/10/2015 9:52 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2015-2016 DEPT AMOUNT REQUESTED ITEM/PROJECT AMOUNT RECOMMENDED TYPE Administration Fire Visitor Center Visitor Center Parks Aquatics Transit Transit Transit City Hall Bathroom Renovation Exterior Wall repair and paint Facility Upgrades for Social Events Doors Lighting Improvements all parks AC & 8th Street Pool Canopies Bay & Lift 12 Bus stops 14 Benches $25,000 $7,000 $6,000 $5,000 $58,292 $9,000 $53,820 $52,676 $7,350 $224,138 $25,000 $7,000 $6,000 $5,000 $58,292 $5,000 $53,820 $52,676 $7,350 $220,138 Transit 1 40ft Passenger Buse $136,000 $136,000 $136,000 Fleet $136,000 Public Works Various GF Dpts Barn Facility Council Directed Projects $125,000 $64,502 $189,502 $125,000 Other Capital Capital Projects $64,502 Other Capital Capital Projects $189,502 Streets Street Improvements $177,327 $177,327 Streets $726,967 TOTAL Budget 16 Final for Website Section 4 - Page 6 Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities FUNDING SOURCE Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Transit Grant Transit Grant Transit Grant Transit Grant Capital Projects $722,967 7/10/2015 9:52 AM DEBT SERVICE FUND 108-51547-419 pg 33 Account Description Leases/Loans 4703 4705 4706 4709 4710 4713 4714 4703 Lease/Purchase Lease/Purchase St Lights PW Facility (Phase I) IT Upgrades Lease GADA Loan Fire Ladder Truck IDA IT Upgrades Lease 2013 Total Leases/Loans Call Center Loans 4711 Call Center Equipment 4712 Call Center Building Total Expenses Total Leases & Call Center 2012 Actual 2013 Actual 11,184 264,283 236,264 9,792 40,000 - 40,153 41,644 264,283 233,775 60,000 $ 639,855 2014 Actual $ 561,523 2015 Budget 22,369 281,941 234,974 170,586 40,000 $ 749,870 $ 2015 YTD 4/30/2015 22,369 235,175 170,586 40,000 215,530 215,530 55,085 170,586 40,000 - 683,660 $ 503,570 2016 2016 Requested % Change 22,369 $ 22,369 233,925 170,586 20,000 215,530 0.00% 0.00% 0.00% #DIV/0! -0.53% 0.00% -50.00% 0.00% 662,410 -3.11% 521,870 569,440 $1,091,310 500,878 595,927 $1,096,805 696,086 $696,086 670,575 $670,575 151,072 $151,072 653,214 $653,214 0.00% -2.59% -2.59% $1,731,165 $1,658,328 $1,445,956 $1,354,235 $654,641 $1,315,624 -2.85% Transfers 9904 Transfer to Capital Projects Total Debt Service Fund Bond Payments 4701 MPC Bond Payment New Bond Total Bonds TOTAL DEBT SERVICE Budget 16 Final for Website $ - $ 1,731,165 $ 1,658,328 $ 1,445,956 $ 1,354,235 $ $ $ $ $ $ $ $ 484,456 - 1,124,311 486,106 - 1,047,629 Section 4 - Page 7 486,806 - 1,236,676 486,450 - 1,840,685 304,077 $ $958,718 $ $ 8,225 - 511,795 - $ 1,315,624 $ 1,315,624 #DIV/0! 100.00% -100.00% -28.53% 7/10/2015 9:52 AM 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 2012 Actual 2013 Actual 2014 Actual 5,909 24,108 65,789 3,223 49,231 44,925 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 1,584 21,000 - 8,412 18,000 - 40,106 9,662 - $ 215,771 $ 185,845 $ 191,945 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 0 170 0 1,000 4,550 1,000 1,000 $ 3,314 1,000 $ 10,000 13,918 $ 10,000 80,000 165,678 80,000 20,000 16,748 37,450 20,000 12,426 26,000 6,000 20,000 3,000 20,000 - $ 158,000 $ 219,804 *** $ 175,450 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 87.25% 30.00% -100.00% 0.00% 0.00% 0.00% 11.04% ***Budgeted expenses will only be expended if the money is available Section 4 - Page 8 7/10/20159:52 AM JCEF 105-51603-412 pg 90 Account Description 1015 3003 8005 8007 8010 Project Related Salaries County Trainer Cost SHR JCEF - Allowable expenses JCEF Court Approved Exp MCEF court approved ex Chambers Renovation 9901 Transfer to General Fund Total Expenses 2012 Actual $ 2013 Actual 1,632 1,580 13,524 112 $ 2014 Actual 1,638 11,952 381 $ 2015 Budget 1,748 220 11,739 126 $ 2,000 - - - 15,340 2,500 81,000 - $ 16,848 $ 13,971 $ 13,833 $ 100,840 Section 4 - Page 9 2015 YTD 2016 4/30/2015 Requested $ 1,572 198 9,719 3,429 $ 2,000 2016 % Change - 14,792 2,500 - 0.00% 0.00% 0.00% -3.57% 0.00% -100.00% 0.00% 0.00% $ 14,919 $ 19,292 -80.87% 7/10/20159:52 AM GRANTS 106 pg 33 Account 2012 Actual 2013 Actual 2014 Actual 2015 Budget 152,578 6,038 47,988 675,104 181 111,231 40,188 317,834 11,700 56,443 286,171 882 200,655 23,535 134,788 3,232 151,899 319,953 2,224 $ 1,033,309 $ 897,219 $ 612,097 Description Housing & Comm Development Fire Police Public Works Library Transfer to GF Transfer to Housing Total Expenses Grants Requiring Match Budget 16 Final for Website 2016 Requested 2016 % Change 326,750 109,301 187,650 4,821,822 77,735 20,589 1,068 51,045 1,309,212 75,373 174,200 880,000 77,500 - - - 300.68% -31.04% -7.17% -81.75% -0.30% 0.00% 0.00% $ 5,523,258 $ 72,701 $ 2,516,285 -54.44% Match Amount ADOT Airport Security Fencing Cochise Community Foundation $ $ $ $ $ $ 1,584 - TOTAL MATCH $ 1,584 AFG - Equipment ADOT Chino Road 2015 YTD 4/30/2015 Section 4 - Page 10 7/10/2015 9:52 AM HOUSING 501-51101-463 PERSONNEL EXPENSE pg 90 Account 2012 Actual Description 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2016 2013 Actual 2014 Actual 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 $ 141,966 $ 13,373 49,388 15,662 23,123 4,823 776 5,731 $10,972 $3,004 $0 $4,000 $0 $0 100.00% $ 329,580 $ 298,550 $ 292,964 $ 280,574 $ 202,581 $ 236,288 -15.78% 2016 Requested 2016 Approved Funded from Special Projects Salaries 148,383 Salaries - Temp 16,697 Salaries - Ltd 78,960 Salaries-Overtime 821 O.A.S.I. 17,377 Retirement-State 22,679 Health Ins 25,811 Income Protect Ins 885 Workman's Comp 4,833 Unemployment Insurance 2,160 Self-funding Ins Claims/fees - 7402 Capital Outlay Total Expenses 2015 Budget 21,735 2015 YTD 2016 2016 4/30/2015 Requested % Change $ 106,439 $ 119,886 $ 2,397 $ 13,373 40,902 41,704 586 10,632 13,385 16,983 19,496 4,127 5,411 469 657 4,214 5,054 (180) 16,013 17,322 -15.55% 0.00% -15.56% 0.00% -14.54% -15.69% 12.20% -15.23% -11.80% 0.00% -20.30% CAPITAL OUTLAY 0 0 Total $ - $ - Section 4 - Page 11 7/10/20159:52 AM ENTERPRISE FUNDS SUMMARY EXPENSES 2015 Budget REVENUES 2016 Budgeted Difference 2016 Budget SANITATION $ 1,201,200 $ 1,202,700 $ 1,500 WATER WATER OFFICE WATER FIELD $ $ 262,989 1,337,135 $ $ 244,910 1,418,418 $ $ (18,079) 81,284 WATER CAPITAL REINVESTMENT WATER TOTAL $ $ 523,542 2,123,666 $ $ 442,337 2,105,666 $ $ (81,205) (18,000) WASTE WATER TOTAL SEWER CAPITAL REINVESTMENT $ $ $ 1,640,313 1,204,687 2,845,000 $ $ $ 1,647,545 1,312,455 2,960,000 $ $ $ AIRPORT $ 151,338 $ 159,762 $ GOLF GOLF COURSE BAR & RESTAURANT $ $ 100,000 - $ $ - $ $ 100,000 $ - $ 6,421,204 $ 6,428,128 GRAND TOTALS 2016 Budgeted % Change 2015 Comparison of Revenues 2016 Revenues 2016 Rev vs. Exp 1,201,200 $ 1,202,700 $ (0) -15.51% -0.85% $ 2,113,666 $ 2,105,666 $ 0 7,232 107,768 115,000 0.44% 8.95% 4.04% $ 2,845,000 $ 2,960,000 $ 0 8,424 5.57% $ 151,338 $ 159,762 $ - -100.00% $ 100,000 $ - $ - 0.11% $ 6,411,204 $ 6,428,128 $ 0 (100,000) $ 6,924 0.12% $ VARIANCE -6.87% 6.08% 7/10/2015 9:52 AM Budget 16 Final for Website Section 5 - Page 1 WATER OFFICE 410-54051-432 pg 83 Account 2012 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 2013 Actual 2014 Actual 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 49,095 3,463 4,814 6,561 220 87 - 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,144 500 3,951 5,929 2,809 204 115 6,524 $ 40,692 187 2,937 4,694 2,015 148 91 3,895 $ 53,010 500 4,094 6,073 2,560 211 120 7,388 3.65% 0.00% 3.61% 2.44% -8.85% 3.64% 3.92% 13.25% 64,240 $ 65,410 $ 70,514 $ 71,175 $ 54,658 $ 73,957 3.91% 43,858 4,595 94 6,633 527 45,984 1,760 15,914 30,757 - 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 - 38,076 4,800 500 7,000 300 34,200 2,350 22,300 40,706 - 37,996 4,796 2,122 5,601 123 29,260 18,698 30,387 - 16,800 4,800 2,600 7,000 2,300 34,800 2,000 23,600 40,700 540 -55.88% 0.00% 420.00% 0.00% 666.67% 1.75% -14.89% 5.83% -0.01% 100.00% Operating Expense $ 150,121 $ 122,487 $ 143,511 $ 150,232 $ 128,984 $ 135,140 -10.05% 7401 Capital Outlay 8001 Bad Debt Expense 9901 Gen. Fund Reimb. 1,789 33,257 28,242 12,381 19,174 31,199 11,756 36,692 6,400 5,000 30,182 5,009 2,480 26,428 5,000 30,813 0.00% 0.00% 2.09% 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 Other $ 63,289 $ 62,753 $ 48,448 $ 41,582 $ 33,917 $ 35,813 -13.87% Total Expenses $ 277,649 $ 250,650 $ 262,473 $ 262,989 $ 217,559 $ 244,910 -6.87% 2016 Requested 2016 Approved CAPITAL OUTLAY 0 Total Budget 16 Final for Website $ 0 - $ 0 - Section 5 - Page 2 7/10/2015 9:52 AM WATER FIELD 410-54053-432 pg 84 Account 2012 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 285,339 965 4,304 9,854 20,129 27,423 35,870 1,197 7,223 7,469 232 $ Operating Expense 3001 Contractual services 4104 Telephone 4105 Utilities 4301 Auto/Equip 4302 Building Maintenance 4303 Computer Maintenance 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 Budget 16 Final for Website 2013 Actual 400,005 265,156 3,980 11,109 20,579 30,637 17,773 1,389 9,683 1,214 24,258 $ 52,193 3,212 298,121 6,098 386 374 25,906 56,950 15,031 32,598 1,138 4,342 1,330 2,925 293 340 1,317 21,365 551 2,970 $ 527,440 2014 Actual 385,778 $ 11,376 2,818 332,782 5,445 1,260 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 $ 545,711 2015 Budget 2016 2016 Requested % Change 276,596 92 7,746 21,733 33,152 16,554 1,504 9,917 267 33,094 $ 302,028 10,000 23,870 35,821 16,806 1,211 9,416 3,000 1,000 29,149 $ 225,486 5,955 17,118 25,918 12,465 783 6,955 155 18,306 $ 304,630 10,000 24,069 35,711 16,056 1,221 21,841 3,000 1,000 32,945 0.86% 0.00% 0.00% 0.00% 0.83% -0.31% -4.46% 0.85% 131.95% 0.00% 0.00% 13.02% 400,656 $ 432,301 $ 313,142 $ 450,474 4.20% 9,850 5,000 330,000 7,000 1,000 130,000 64,000 40,000 88,000 99,098 2,000 1,500 3,000 1,000 1,200 500 1,500 1,300 19,000 1,000 2,450 - 4,506 5,110 287,275 4,702 17 267 73,694 42,263 23,336 16,257 2,298 845 702 998 474 12,055 383 2,748 - 12,040 5,000 330,000 7,000 1,000 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 - 22.23% 0.00% 0.00% 0.00% 0.00% 0.00% -53.85% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 16.67% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 808,398 $ 477,928 741,088 -8.33% 7,980 4,626 411,146 5,791 1,375 29,406 54,388 37,862 33,111 1,027 2,966 1,227 616 463 521 443 20,559 986 2,738 $ 2015 YTD 4/30/2015 617,233 Section 5 - Page 3 $ $ 7/10/2015 9:52 AM WATER FIELD 410-54053-432 pg 84 Account 2012 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 2013 Actual 32,903 - 5,810 (33,653) 430,217 2,485 383,076 13,151 18,456 - Total Capital Outlay $ 447,586 Total Expenses $ 1,375,030 2014 Actual $ 404,859 2015 Budget 29,921 455,506 52,240 $ 537,667 $ 1,336,348 $ 1,555,555 2016 Requested 2016 Approved 2015 YTD 4/30/2015 2016 2016 Requested % Change 15,000 - - 5,000 - 33,359 - 173,780 48,077 40,064 48,077 -66.67% 0.00% 0.00% 420.94% 0.00% 0.00% 0.00% 96,436 $ 40,064 $ 226,857 135.24% $ 1,337,135 $ 831,135 $ 1,418,418 6.08% $ CAPITAL OUTLAY Items 0 Safety Barricades 0 Total Budget 16 Final for Website $ 5,000 5,000 $ Section 5 - Page 3 5,000 5,000 7/10/2015 9:52 AM Water Capital Reinvestment 410-54055-432 pg 85 Account Description Personnel Expense 1001 Salaries- Regular 1003 Salaries- Temp 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Insurance 2005 Income Protection 2006 State Comp 2016 Self-Funding Ins Claims/Fees 2014 Actual 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change 79,255 1,222 6,153 8,424 4,559 395 2,524 1,664 66,947 957 5,152 7,852 3,501 344 2,189 6,534 $ 80,343 1,800 6,284 9,430 3,780 321 2,185 5,865 $ 55,780 526 4,106 6,465 2,757 190 1,523 3,932 $ 80,343 1,800 6,406 9,504 3,655 327 4,430 6,624 0.00% 0.00% 0.00% 1.94% 0.78% -3.30% 1.97% 102.74% 12.94% $ 152,304 $ 104,195 $ 93,477 $ 110,008 $ 75,278 $ 113,090 2.80% 29,138 30,956 18,262 4,325 7,854 9,943 1,566 1,008 1,870 4,207 5,282 142 2,320 4,779 125 31,887 - 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 - 3,000 5,000 1,000 2,000 450 600 3,500 4,500 5,500 4,500 1,050 34,172 - $ 84,335 $ 101,141 $ 101,725 $ 83,534 Water CIP Capital Outlay SCADA Control System 3rd. St. Water Line Extension 28,853 Misc. Projects-Master Plan Rehabilitation Reservoir 1,951 Fairview Water (BECC) Well 16 Equiping (Arsenic Compliance) Rehab Existing Wells - 2,953 16,944 5,616 46,683 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 Budget 16 Final for Website 2013 Actual $ 111,019 7,394 1,967 8,508 10,653 9,407 461 2,895 - Personnel Expense 7401 7802 7809 7810 7811 7818 7820 7821 2012 Actual 26,826 10,000 Section 5 - Page 4 60,000 60,000 - 25,855 675 6,465 919 1,629 95 204 1,914 1,612 4,495 995 1,046 29,956 - 18,262 0.00% 3,000 5,000 1,000 2,000 450 600 3,500 4,500 5,500 4,500 1,050 34,886 - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.09% 0.00% $ 75,860 $84,248 0.85% 9,088 - 5,000 0.00% 0.00% 0.00% -100.00% -100.00% 0.00% 0.00% 0.00% 60,000 7/10/2015 9:52 AM Water Capital Reinvestment 410-54055-432 pg 85 Account Description 7822 7824 7825 7827 7829 7830 2013 Actual Arsenic Compliance 300K Gallon Elevated Tanks-Rehab227,796 364,096 16" Geronimo Trail Tansmission Main Replacement W & WW System Improvements, Phase II Well 17 (Arsenic Compliance) 27,511 550,408 Sunnyside Improve Capital Projects 7999 Fixed Assets Total Expenses Budget 16 Final for Website 2012 Actual 2014 Actual 2015 Budget - 200,000 8,064 - - - 330,000 $ 523,542 286,111 934,401 60,363 (385,028) (990,961) (103,491) $ 137,722 $ 148,777 2015 YTD 2016 2016 4/30/2015 Requested % Change $ 152,074 Section 5 - Page 4 - 0.00% 0.00% -10.00% 0.00% 0.00% 0.00% 9,088 245,000 -25.76% $ 160,227 $ 442,337 -15.51% 180,000 7/10/2015 9:52 AM WASTEWATER 420-54061-432 pg 87 2012 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 2013 Actual 266,606 3,860 4,304 3,350 20,044 26,753 35,879 1,188 6,508 317 $ 368,809 2014 Actual 251,368 3,980 4,262 18,302 27,308 13,646 1,251 7,725 28 23,985 $ 351,856 $ 2015 Budget 2015 YTD 4/30/2015 2016 Requested 2016 % Change 282,411 3,906 19,888 32,037 10,488 1,453 9,481 243 50,981 $ 288,388 8,000 22,674 34,025 10,171 1,154 9,148 1,000 1,000 40,870 $ 227,740 2,472 16,561 25,034 8,609 758 6,730 1,267 24,177 $ 289,496 8,000 22,758 33,766 9,935 1,159 9,709 1,000 1,000 41,040 0.38% 0.00% 0.00% 0.00% 0.37% -0.76% -2.33% 0.38% 6.14% 0.00% 0.00% 0.42% 410,889 $ 416,430 $ 313,346 $ 417,862 0.34% 34,148 2,582 2,315 73,459 2,031 400 474 8,115 50,472 34,492 52,539 0 0 95,519 2,435 776 8,680 19,858 828 829 299 8,806 9,441 1,419 20,596 2,498 2,500 90,000 5,000 2,000 -37.34% 0.00% 0.00% 0.00% -28.57% 0.00% 40,000 81,260 640,260 77,700 2,500 1,000 100,000 3,000 2,541 8,000 35,000 800 950 450 11,000 13,000 2,100 -16.67% 2.12% 15.36% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -30.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Requesting Reclass of Cloo Te Operating Expense 3001 3002 4104 4105 4301 4302 4303 4324 4703 5201 5202 5301 5502 5801 6001 6002 6021 6301 6302 6401 6501 6502 6601 Budget 16 Final for Website 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 Small tools Safety Equipment Books/Dues/Subscrip Gas/oil/lube Diesel/oil/lube Uniforms 64,644 2,800 1,523 107,842 11,417 1,711 44,288 2,445 2,504 100,836 10,620 16,815 38,894 2,446 3,800 99,071 8,320 108 32,871 2,498 2,500 90,000 7,000 2,000 93,585 36,826 34,498 2,430 885 17,270 26,466 925 515 393 10,759 12,629 1,602 38,272 2,955 85,547 60,944 69,401 3,356 666 19,983 19,142 1,267 1,247 756 11,729 10,131 1,808 33,234 6,015 92,918 68,207 150 133,762 1,558 2,740 5,764 25,905 114 221 361 11,230 11,255 1,730 48,000 79,576 555,000 77,700 2,500 1,000 100,000 3,000 2,541 8,000 50,000 800 950 450 11,000 13,000 2,100 Section 5 - Page 5 7/10/2015 9:52 AM WASTEWATER 420-54061-432 pg 87 2012 Actual 4,238 $ 432,956 Account Description 6701 Construction Materials Operating Expense 7401 7826 7997 8001 Capital Outlay Impact Fee CONTRA Interest Bad Debt Expense Depreciation 9901 Gen. Fund Reimb. 9917 Transfer to Debt Service Transfer to Water Total Capital Outlay 11,838 20,605 462,301 26,790 521,534 Total Expenses $ 1,323,299 2013 Actual 1,289 $ 506,001 291,384 (85,547) 4,136 468,582 27,173 2,485 708,213 $ 1,566,070 2014 Actual 194 $ 547,997 2015 2015 YTD 2016 2016 Budget 4/30/2015 Requested % Change 2,000 653 2,000 0.00% $ 1,094,486 $ 410,571 $ 1,144,155 4.54% 119,744 12,817 506,020 39,603 14,435 692,619 10,000 - - - -100.00% 0.00% 5,000 39,119 32,353 13,592 29,333 129,397 4,073 30,544 11,327 45,943 5,000 4,635 32,967 13,592 29,333 85,527 0.00% -88.15% 1.90% 0.00% 0.00% -33.90% $ 1,651,505 $ 1,640,313 $ 769,860 $ 1,647,545 0.44% 2016 Requested 25,000 $ 25,000 2016 Approved CAPITAL OUTLAY Items Work Truck 0 0 Total Budget 16 Final for Website $ Section 5 - Page 5 - 7/10/2015 9:52 AM Sewer Capital Reinvestment 420-54065-432 pg 88 pg 88 Account 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 Budget 16 Final for Website 2012 Actual 2013 Actual 67,182 4,631 1,283 5,484 6,881 6,271 307 1,865 $ 93,904 $19,464 9,607 243 436 110 1,577 3,048 1,224 1,499 31,887 $69,094 $ 2014 Actual 2015 Budget 53,422 133 4,050 5,542 3,022 259 1,661 1,087 45,469 266 3,407 5,193 2,322 228 1,439 4,414 $ 69,176 $ 62,737 $ 19,350 20,858 1,919 43 27 77 33 522 417 2,297 35,225 81 16 774 41,547 $59,908 $63,277 2015 YTD 4/30/2015 53,562 1,200 4,189 6,287 2,434 214 1,457 3,910 73,253 17,262 34,172 $51,434 Section 5 - Page 6 $ $ 2016 Requested 37,187 $ 288 2,733 4,303 1,853 126 1,013 2,620 $ 50,122 $17,435 $459 2 244 29,956 $48,096 $ 53,562 2016 % Change 1,200 4,271 6,336 2,351 218 2,954 4,416 0.00% 0.00% 0.00% 0.00% 1.94% 0.78% -3.41% 1.97% 102.74% 12.94% 75,308 2.80% 17,262 34,886 $52,148 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.09% 1.39% 7/10/2015 9:52 AM 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 1,600 DOC-Lift Station Improvements CIP Impact Fees-Study W & WW System Improvements, phase30,000 II Phase II, WWTP Improvements 9,460 Southwest Interceptor 3,038 Solar Project $44,098 7999 Contra Exp/Fix As Total Expenses Budget 16 Final for Website 51,441 3,805 37,789 (103) - 33,698 - $89,127 $37,502 15,000 65,000 $0 $0 $0 $0 $0 $687 5,000 80,000 1,000,000 - 22,754 1,100,000 - 0.00% 0.00% 0.00% 0.00% -66.67% 23.08% 0.00% 0.00% 10.00% 0.00% 0.00% $23,441 $1,185,000 9.72% $ 121,660 $ 1,312,455 8.95% $1,080,000 - ($157,744) ($408,975) ($180,608) $ 49,352 $ (190,765) $ (17,093) $ 1,204,687 Section 5 - Page 6 7/10/2015 9:52 AM SANITATION 430-54071-432 pg 90 Account 2012 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 Budget 16 Final for Website $ 2013 Actual 2014 Actual 219,006 2,324 93 16,221 21,832 39,479 1,003 11,154 1,298 - 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 $ 314,829 $ 344,463 $ 425,094 $ 10,587.44 3,000 461 4,598 4,936 1,255 23,041 3,580 286,500 21 236 1,279 981 498 4,599 36,218 1,798 - 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 - 369,088 $ 379,177 $ 440,978 Section 5 - Page 7 2015 Budget $ 2015 YTD 4/30/2015 2016 2016 Requested % Change $ 1,000 25,497 37,574 16,362 1,296 22,925 2,000 1,200 50,703 $ 179,501 37,409 40,144 1,463 18,547 25,349 8,089 754 15,910 691 24,744 490,853 $ 352,600 $ 15,979 2,677 500 5,000 1,000 8,000 25,000 45,000 4,200 10,000 300,000 1,000 1,000 1,000 450 2,000 2,000 37,000 2,450 - 14,774 2,767 599 4,103 874 3,341 18,711 41,776 1,068 241,665 519 50 664 19 897 1,948 30,972 3,012 - 464,256 $ 367,759 326,295 6,000 $ 342,814 6,000 1,000 26,761 39,023 15,443 1,362 24,698 2,000 1,200 52,152 5.06% 0.00% 0.00% 0.00% 4.96% 3.86% -5.62% 5.06% 7.73% 0.00% 0.00% 2.86% 512,451 4.40% 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 - -58.18% 0.00% 80.00% 0.00% 400.00% 0.00% 20.00% -7.16% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 150.00% 8.11% 14.29% 0.00% 467,486 0.70% 7/10/2015 9:52 AM SANITATION 430-54071-432 pg 90 Account 7402 7403 7999 8001 8003 8901 9901 9917 52,372 327,338 - (218,374) 5,326 1,018 54,972 27,173 1,243 2014 Actual 198,595 7,022 (205,617) 2,303 87,610 35,867 7,212 396,986 89,732 132,992 $ 1,080,903 $ 813,372 $ 999,064 Description Capital Outlay Automated Program Fixed Assets Bad Debt Expense Other Expense/Conti Depreciation (Expense Savings) Gen. Fund Reimb Transfer to Debt Service Transfer to Water Total Expenses 2012 Actual 17,276 2013 Actual 218,374 2015 2015 YTD Budget 4/30/2015 54,000 10,000 2,531 120,939 25,022 26,866 6,796 5,664 29,333 246,091 35,060 $ 1,201,200 $ 755,420 2016 2016 Requested % Change 70,000 29.63% 10,000 80,569 26,064 6,796 29,333 222,763 0.00% 0.00% -33.38% 4.16% 0.00% 0.00% -9.48% $ 1,202,700 0.12% CAPITAL OUTLAY 2016 2016 Requested Approved Items 0 Grant Match for 2 Automated Sanitation 96 Gallon Cans Budget 16 Final for Website - - 50,000 20,000 $ 70,000 50,000 20,000 $ 70,000 Section 5 - Page 7 7/10/2015 9:52 AM AIRPORT 310-54103-431 pg 81 Account Description 2012 Actual Personnel Expense 1001 Salaries $ 16 1003 Sal-Temp 1004 Sal-Limited 22,526 1005 Sal-OT 194 2001 OASI 1,730 2002 State Retire 2,258 2004 Health Ins 2005 Income Protect 52 2006 State Comp 738 2016 Self funding Ins Claims/Fees - 2013 Actual 2014 Actual 2015 Budget 2015 YTD 2016 2016 4/30/2015 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 $ 23,984 400 1,865 2,799 2,233 97 1,018 2,791 $ 19,235 797 1,533 2,276 1,858 72 828 2,012 $ 25,688 400 1,996 2,961 2,205 104 1,112 3,147 7.10% #DIV/0! 0.00% 0.00% 6.99% 5.78% -1.25% 6.99% 9.25% 12.73% $ 27,513 $ 29,911 $ 40,948 $ 35,188 $ 28,611 $ 37,612 6.89% 6,160 2,031 8,196 185 11,599 4,777 5,252 1,499 7,655 215 5,354 5,222 137 519 15 1,163 18,214 60,074 120 $ $ $ $ 1,881 39,627 50,627 - 4,141 1,598 7,983 76 2,447 5,738 376 599 489 438 2,024 26,287 39,410 300 Operating Expenses 130,410 91,907 Total Expenses before Capital 157,924 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 7301 Capital Outlay/Projects 7948 Contra Exp-Fixed Assets 8512 Grant Match Total Expenses Budget 16 Final for Website 2,000 25,000 45,000 350 3,360 1,324 9,698 654 660 5,222 74 1,550 757 16,398 37,380 133 105,438 101,150 121,818 146,385 230 - 230 29,709 - 11,760 $ 130,640 $ 122,048 $ 158,145 601 3,995 731 4,600 1,500 8,000 500 6,000 5,300 500 500 1,500 400 2,000 18,000 43,000 350 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -28.00% -4.44% 0.00% 77,211 92,150 -8.90% 136,338 105,822 129,762 -4.82% - - 0.00% 15,000 761 - 30,000 100.00% $ 151,338 $ 106,583 $ 159,762 5.57% Section 5 - Page 8 4,600 1,500 8,000 500 6,000 5,300 500 500 1,500 400 7/10/2015 9:52 AM AIRPORT 310-54103-431 CAPITAL OUTLAY Item 0 0 Total Budget 16 Final for Website 2016 2016 Requested Approved* $ - $ - Section 5 - Page 8 7/10/2015 9:52 AM Golf Course 450-52045-451 pg 88 Description 2012 Actual 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,319 53,697 84,913 1,221 11,709 10,221 3,637 275 2,495 $ 185,487 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 $ 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 8,175 32,662 1,746 10,094 3,804 19,217 8,480 2,786 827 31,181 1,698 22 11,202 5,436 828 2,262 27,721 16,209 18,455 27 1,577 363 15,936 709 $ 221,416 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 $ 76,904 37 - 3,703 - $ 483,807 $ 389,796 Account 7750 Capital Outlay 7751 RV Hidden Treasures 8050 Prior Expense - DGSC Total Expenses Budget 16 Final for Website 2015 Budget 2015 YTD 2016 2016 4/30/2015 Requested % Change - 30,731 15,693 13,606 537 4,584 5,139 1,825 133 1,672 1,950 $ 75,868 $ - 4,527 16,566 11,449 544 9,654 2,859 5,191 29,691 3,209 3,324 144 10,924 6,285 2,446 185 7,845 173 $ 115,015 $ 28 - 100,000 - 487 - $ 285,249 $ 100,000 $ 191,370 Section 5 - Page 9 $ $ $ $ - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! - #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! - 0.00% $ - -100.00% 7/10/2015 9:52 AM Golf Course 450-52045-451 *CAPITAL OUTLAY CIP Total Budget 16 Final for Website 2016 2016 Requested Approved 0 0 0 0 0 0 $ - $ - Section 5 - Page 9 7/10/2015 9:52 AM Lounge 450-52055-451 pg 88 Account Description 2012 Actual 2013 Actual Personnel Expense 1001 Salaries $ 1003 Sal-Temp 19,388 1004 Sal-Limited 37,206 1005 Sal-OT 6,146 1008 Tips 5,442 2201 OASI 5,352 2002 State Retire 4,604 2004 Health Ins 2005 Income Protect 107 2006 Workman's Comp 936 2016 Self Funding Ins Claims/fees - 2015 2015 YTD 2016 2016 Budget 4/30/2015 Requested % Change $ - 14,193 4,576 424 731 1,553 506 76 6 540 2 $ - $ 22,608 $ - 4,527 9,865 2,099 1,017 1,652 - 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 - - 734 932 60 18,283 3,540 - $ 145,542 $ 95,361 53,133 $ - $ 42,708 7750 Capital Outlay 8101 Special Events 45,279 375 441 - 150 - Total Expenses $ 270,376 $ 141,574 - $ 65,466 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 5801 Travel & Training 6001 Office supplies 6002 Operating supplies 6301 Small tools 6501 Gas/Oil 6508 Beverages 6509 Food 6601 Uniforms Operating Expense Budget 16 Final for Website 2014 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 $ $ 79,181 $ 45,772 $ 16,729 $ 18,207 14,101 1,284 807 393 1,149 8,251 12,446 12,792 2,366 936 2,038 2,008 174 2,354 6,576 214 685 39,902 50,389 1,057 $ 69,862 Section 5 - Page 10 $ - $ - 0.00% #DIV/0! 0.00% 0.00% 0.00% #DIV/0! 0.00% 0.00% 0.00% #DIV/0! 0.00% $ - #DIV/0! $ - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! - #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.00% #DIV/0! 0.00% #DIV/0! - #DIV/0! $ - $ - 0.00% 0.00% #DIV/0! 7/10/2015 9:52 AM GRANTS 2015-2016 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 AFG - Fire Truck Type 3 Engine IAFC HAZ MAT Conference MAHMT Conference Continuing Challenge HAZ MAT Conference AZDEM ERF SSHGP Fire Christmas Drive EMS Scholarship 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 Public Works ADOT Chino Road 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 - Laptops Tohono O'odham - Library Improvements Cochise Community Foundation Dollar General Literacy Grant Wal Mart Library Literacy Grant TOTALS REQUESTED TOTALS APPROVED * * * * ** * 2016 Total Expenditure 2016 Max Revenue 2016 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 653,632 20,000 673,632 653,632 20,000 673,632 653,632 20,000 673,632 371,659 31,689 419,361 6,000 6,000 6,000 2,600 15,000 4,500 2,000 493,150 31,689 419,361 6,000 6,000 6,000 2,600 15,000 4,500 2,000 493,150 31,689 419,361 6,000 6,000 6,000 2,600 15,000 4,500 2,000 493,150 1,584 20,968 1,089,807 103,188 162,650 11,550 25,000 45,000 1,089,807 103,188 162,650 11,550 25,000 45,000 1,089,807 103,188 162,650 11,550 25,000 45,000 1,437,195 1,437,195 1,437,195 - 1,437,195 150,000 200,000 500,000 300,000 200,000 1,350,000 150,000 200,000 500,000 300,000 200,000 1,350,000 150,000 200,000 500,000 300,000 200,000 1,350,000 - 150,000 200,000 1,100,000 330,000 200,000 1,980,000 33,093 25,000 50,000 1,500 1,000 110,593 33,093 25,000 50,000 1,500 1,000 110,593 33,093 25,000 50,000 1,500 1,000 110,593 5,373,782 5,373,782 5,373,782 4,954,421 4,954,421 4,954,421 Total Grant Match from the GF Requested Total Grant Match from the GF Approved 2016 Match - 371,659 22,553 1,000,000 34,212 275,000 1,309,212 1,025,290 20,000 1,045,290 33,273 440,329 Not Recommended 6,000 6,000 6,000 2,600 15,000 4,500 2,000 515,703 1,089,807 103,188 162,650 11,550 25,000 45,000 600,000 ** 30,000 630,000 5,217 * 5,217 38,310 25,000 50,000 1,500 1,000 115,810 1,029,428 6,403,210 - 1,008,460 5,962,881 429,428 408,460 *Grants Accounted for in General Fund Rev & Exp **Grant Accounted for in the Water & Sewer CIP Rev and Exp Budget 16 Final for Website Section 6 - Page 1 7/10/2015 9:52 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2015-2016 DEPT ITEM/PROJECT AMOUNT REQUESTED ADMINISTRATION Xerox DocuMate 4790 Document Scanner DEPT. TOTAL 4,500 DEPT. APPROVED FUNDING SOURCE - DEPARTMENT TOTAL FINANCE 1 Inventory Control Program w/ scanners DEPARTMENT TOTAL AMOUNT APPROVED $4,500 $ - $ 12,000 $ - $ 26,000 $ - 12,000 MIS Backup Hardware 26,000 DEPARTMENT TOTAL HUMAN RESOURCES DEPARTMENT TOTAL $ - $ - $ - $ - $ 1,060,400 $ - MAGISTRATE DEPARTMENT TOTAL FIRE/EMS Multi Use Vehicle (pull Haz-Mat, air and light Trailer) Fire Truck Ambulance Type 6 Quick Attack Vehicle New Roof 2 Rescue Tools (Jaws of Life) 3 Air conditioner replacement 2 bathroom replacement SCBA Replacement (22 harnesses and 44 tanks) Fire Chief Car 6 Radio Communication replacement DEPARTMENT TOTAL POLICE 2 replacement vehicles 1 patrol 1 invest 2 replacement vehicles 1 patrol 1 invest 2 Surveillance Camera Investigation 1 Interview Room 1 ID Printer 125,000 400,000 175,000 80,000 25,000 30,000 20,000 4,500 160,000 30,000 10,900 80,000 80,000 19,700 14,000 3,750 DEPARTMENT TOTAL 80,000 80,000 RICO Auction RICO RICO RICO $ 197,450 $ 160,000 $ - $ - $ 40,400 $ - $ 38,000 $ - VISITOR CENTER DEPARTMENT TOTAL CEMETERY Sprayer Chip Seal project Trees DEPARTMENT TOTAL PARKS Portable gas generator with elder Playground upgrades Plaground Canopy Exercise Stations at Aiport Park Partnership 5,400 30,000 5,000 8,000 10,000 $10,000 $10,000 DEPARTMENT TOTAL RECREATION Vehicle PA System Exercise Equipment for Senior Center Budget 16 Final for Website 20,000 9,000 Section 7 - Page 81 7/10/2015 9:52 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2015-2016 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPARTMENT TOTAL AQUATICS POS System Automation System for Main Pool ADA Doors 2 vehicles $ $ $ $ $ LIBRARY Inventory Device Library Furniture Upgrades and Additions Marketing/Branding to promote SP and Policies Exterior Painting $ - $ 62,000 $ - $ 25,000 $ - $ 35,000 $ - $ 4,500 $ - $ 45,500 $ - 4,500 5,500 15,000 25,000 DEPARTMENT TOTAL TRANSIT 1 40ft Passenger Bus Bay & Lift 12 Bus Stops 14 Benches Supervisor vehicle Bus Cameras 12 Bus stops shelters / benches 29,000 136,000 53,820 52,676 7,350 40,084 16,416 46,824 DEPARTMENT TOTAL TOTAL GENERAL FUND REQUESTS 136,000 53,820 52,676 7,350 40,084 16,416 46,824 $ 353,170 $ 353,170 Grant/ Match Required Grant/ Match Required Grant/ Match Required Grant/ Match Required Grant/ Match Required Grant/ Match Required Grant/ Match Required Grant/ Match Required $ 35,317.00 match by GF TOTAL REQUESTED TOTAL AMOUNT APPROVED $ 1,932,920 $ 513,170 Capital Outlay Funding RICO Grants Seized Vehicle Auction Funds (net of expenses) GF Transit Match General Fund JCEF For Fleet TOTAL ALL FUNDING SOURCES $ 80,000 $ 317,853 $ 80,000 $ 35,317 $ - $ $ $ $ $ $ $ 80,000 353,471 80,000 39,275 100,000 44,000 179,000 transfer to CP from RICO transfer to CP from GF transfer to CP from GF transfer to CP from GF transfer to CP from GF transfer to CP from JCEF For fleet $ 513,170 BALANCE Budget 16 Final for Website FUNDING SOURCE 35,000 DEPARTMENT TOTAL PUBLIC WORKS/FLEET MAINTENANCE Vehicle Code Scanner DEPARTMENT TOTAL DEPT. APPROVED $ 25,000 DEPARTMENT TOTAL PW CONSTRUCTION Utility Van AMOUNT APPROVED 12,000 5,000 5,000 40,000 DEPARTMENT TOTAL PUBLIC WORKS/ADMINISTRATION 4 passenger Vehicle DEPT. TOTAL $ Section 7 - Page 82 - 7/10/2015 9:52 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2015-2016 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL AMOUNT APPROVED DEPT. APPROVED FUNDING SOURCE SANITATION Grant Match for 2 Automated Sanitation 96 Gallon Cans DEPARTMENT TOTAL 50,000 20,000 50,000 20,000 $ STREETS (HURF) 1 Tamper 3 UPS Inverter Battery Pack for Traffic Signals 70,000 3,000 18,000 DEPARTMENT TOTAL $ 70,000 $ 18,000 $ - $ 5,000 18,000 $ 21,000 WATER OFFICE 0 0 DEPARTMENT TOTAL $ - WATER FIELD Safety Barricades 5,000 5,000 DEPARTMENT TOTAL $ WATER/SEWER - CAPITAL REINVESTMENT PROGRAM Saw 5,000 DEPARTMENT TOTAL WASTEWATER Work Truck 5,000 $ 5,000 $ 5,000 $ 25,000 $ - 25,000 DEPARTMENT TOTAL GOLF COURSE CIP 5,000 $ - - DEPARTMENT TOTAL $ - $ - $ - $ - HOUSING DEPARTMENT TOTAL $ - AIRPORT DEPARTMENT TOTAL Budget 16 Final for Website $ - Section 7 - Page 83 7/10/2015 9:52 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2015-2016 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL AMOUNT APPROVED TOTAL REQUESTED TOTAL ENTERPRISE FUND REQUESTS Requests funded from HUD Requests funded from Golf Course NET FUNDED FROM ENTERPRISE FUNDS DEPT. APPROVED TOTAL AMOUNT APPROVED $ $ $ $98,000 98,000 Sanitation Fund HURF Water Fund Sewer Fund Water/Sewer CIP HUD Golf Course Airport $ $ $ $ $ $ $ $ $ 70,000 18,000 5,000 5,000 - Total Enterprise Funds CIP 12/13 $ 98,000 $126,000 TOTAL GENERAL FUND REQUESTS: TOTAL ENTERPRISE FUND REQUESTS: $ 1,932,920 $ 126,000 $ 513,170 $ 98,000 TOTAL CAPITAL OUTLAY REQUESTS: $ 2,058,920 $ 611,170 LESS: FUNDED BY SPECIAL FUNDING $ 477,853 $ 477,853 TOTAL CITY FUNDED CAPITAL OUTLAY: $ 1,581,067 $ 133,317 Budget 16 Final for Website Section 7 - Page 84 FUNDING SOURCE 7/10/2015 9:52 AM