CITY OF DOUGLAS BUDGET SUMMARY Expense 2014 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) $ Expense 2015Budget 510,129 73,352 530,293 502,391 503,102 2,647,272 71,494 309,834 2,369 129,873 574,056 99,996 308,725 160,239 461,744 203,916 1,191,511 1,286,490 284,300 2,503,046 1,527,169 174,910 68,142 506,453 415,000 - GENERAL FUND $ 15,045,805 Net Rev. vs. Exp. $ 0 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 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 2014-2015 Difference $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 15,841,411 $ 15,368,665 (24,185) (3,022) 23,029 9,371 (105,736) 254,868 5,229 96,189 (2,369) 28,252 (4,897) 62,988 6,320 11,917 (47,134) (43,888) (27,134) 6,671 128,198 27,918 253,100 1,012 (3,910) 85,071 57,746 - 2015 2014 Budgeted 2015 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp -4.74% 0.00% -4.12% 0.00% 4.34% 1.87% -21.02% 9.63% 7.31% 31.05% -100.00% 21.75% -0.85% 62.99% 2.05% 7.44% -10.21% -21.52% -2.28% 0.52% 45.09% 1.12% 16.57% 0.58% -5.74% 16.80% 13.91% $ 472,746 5.29% $ 15,045,807 795,605 $ 15,841,411 $ 0 - GF Reserve $ - $ 0 05/28/2014 10:55 AM Book1 Section 1 - Page 1 CITY OF DOUGLAS BUDGET SUMMARY 2014 Budget 2015 2015 2014 Budgeted 2015 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp 2014-2015 Difference 2015 Budget H. U. R. F. $ 1,196,303 $ 1,269,351 $ 73,048 6.11% $ 1,196,303 $ 1,269,351 $ (0) LTAF $ - $ - $ - 0.00% $ - $ - $ - CAPITAL PROJECTS $ 670,000 $ 1,697,000 $ 1,027,000 153.28% $ 670,000 $ 613,000 $ DEBT SERVICE FUND $ 1,563,854 $ 1,354,235 $ (209,620) -13.40% $ 1,563,854 $ 1,354,235 $ - MPC FUND $ 486,806 $ 486,450 $ (356) -0.07% $ 486,806 $ 486,450 $ - RICO $ 210,000 $ 158,000 $ (52,000) -24.76% $ 210,000 $ 158,000 $ - JCEF $ 18,572 $ 100,840 $ 82,268 442.97% $ 10,500 $ 45,150 $ GRANTS $ 5,108,376 $ 5,523,258 $ 414,882 8.12% 5,108,376 $ 5,523,258 $ HOUSING $ 283,071 $ 280,574 $ TOTAL SPECIAL REVENUE FUNDS $ 9,536,983 $ 10,869,709 $ SANITATION $ 1,273,748 $ 1,201,200 $ WATER WATER OFFICE WATER FIELD WATER CAPITAL REINVESTMENT WATER TOTAL $ $ $ $ 254,258 1,233,094 567,648 2,055,000 $ $ $ $ 262,989 1,337,135 513,542 2,113,666 WASTE WATER SEWER CAPITAL REINVESTMENT SEWER TOTAL $ $ $ 1,521,342 329,658 1,851,000 $ $ $ AIRPORT* $ 137,302 GOLF COURSE ** LOUNGE $ $ $ TOTAL ENTERPRISE FUNDS GRAND TOTALS (2,497) (1,084,000) (55,690) - -0.88% $ 283,071 $ 276,574 $ (4,000) 13.97% $ 9,528,911 $ 9,726,019 $ (1,143,690) (72,548) -5.70% $ 1,230,100 $ 1,201,200 $ 0 $ $ $ $ 8,731 104,041 (54,106) 58,665 3.43% 8.44% -9.53% 2.85% $ 2,055,000 $ 2,113,666 $ 0 1,640,313 1,204,687 2,845,000 $ $ $ 118,971 875,029 994,000 7.82% 265.44% 53.70% $ 1,851,000 $ 2,845,000 $ (0) $ 151,338 $ 14,036 10.22% $ 137,302 $ 151,338 $ - 323,070 88,641 411,711 $ $ $ 100,000 100,000 $ (311,711) -96.48% $ 411,711 $ 100,000 $ - $ 5,728,762 $ 6,411,204 $ 682,442 11.91% $ 5,685,113 $ 6,411,204 $ 0 $ 30,311,550 $ 33,122,323 $ 2,810,773 9.27% $ 30,259,831 $ 31,978,633 $ 1,332,726 (1,143,690) * Airport is being subsidized $38,594 by the General Fund ** Golf Course is being subsidized $25,000 by the General Fund 05/28/2014 10:55 AM Book1 Section 1 - Page 2 REVENUE BUDGET 2014 - 2015 GENERAL FUND Account 31100 31102 31301 31301 31302 31801 31802 31803 32101 32102 32103 32104 32201 32202 32301 32302 32303 33111 33211 33211 33211 33501 33502 33503 33704 33705 33705 34101 34102 34104 34105 34106 34107 34108 34109 34501 34502 34503 34701 34702 34703 34704 34705 34706 34707 34720 34721 34723 Description PROPERTY TAX-CURRENT PROPERTY TAX-DELINQ. CITY SALES TAX / USE TAX SALES TAX-CITY $ TRANSIENT OCCUPANCY TAX FRANCHISE-ELECTRIC FRANCHISE-GAS FRANCHISE-CABLE BUSINESS LICENSES LIQUOR LICENSES OPERATOR/VEH. PERMITS YARD/SIDEWALK SALES PERMIT BUILDING PERMITS ZONING FEES & PERMITS DOG LICENSES BURNING PERMITS ALARM PERMITS POLICE OPER. REIMB. GRANT ADM REIMB 1 LIBRARY GRANT BTOP 2 TRANSIT GRANT REIMB TRANSIT PARTNERSHIPS STATE SHARED SALES TAX STATE URBAN REV SHARING VEHICLE LICENSE TAX HUMANE COUNTY IGA HOUSING IGA CASAS & PIONEER DUSD IGA $ PARKING LOT FEES CEMETERY FEES ANIMAL SHELTER REVENUE LEAD INSPECTIONS 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 FLAG FOOTBALL LEAGUE FEES 2011 Actual 508,752 32,097 4,154,290 1,045,400 $ 48,656 181,792 103,687 51,550 82,451 11,300 3,440 3,570 65,284 1,947 3,305 225 1,080 777,308 885 1,316,667 1,673,637 762,824 39,083 89,542 34,526 $ 26,437 78,099 6,225 0 14,850 2,100 820 972,724 6,435 162 24,037 4,702 0 521 1,334 4,685 1,075 5,683 90 0 2012 Actual 2013 Actual 510,162 38,015 4,143,323 1,025,975 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 8,157 0 21,500 3,050 1,059 924,788 11,331 11,704 20,482 6,113 0 1,677 1,424 14,658 1,813 7,394 120 0 2014 10-month Actual 2014 Budget 528,103 $ 28,354 3,811,528 952,502 $ 39,480 179,761 85,955 48,365 85,701 10,750 2,935 3,920 52,890 1,395 3,645 225 1,110 858,200 0 26,912 213,476 0 1,419,048 1,775,125 757,402 43,162 98,539 0 $ 19,646 71,293 6,060 0 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 0 500,000 30,000 4,100,000 1,024,980 45,000 180,000 100,000 51,000 88,000 10,000 3,500 4,000 70,000 2,000 4,000 500 1,000 686,000 493,284 74,453 1,501,591 1,938,775 799,085 58,000 99,471 62,686 70,000 8,000 22,000 3,000 1,400 34,500 1,000,000 7,000 2,000 18,000 5,000 1,000 2,000 1,500 7,000 1,500 4,000 - $ $ $ 360,532 31,853 3,252,736 809,547 31,208 136,318 67,995 23,627 75,468 7,075 1,710 2,800 90,000 960 3,485 170 1,020 676,279 10,425 256,175 1,268,837 1,650,584 601,261 28,191 80,138 42,865 66,806 4,220 17,250 4,650 1,011 30,781 835,100 6,300 9,983 4,485 56 560 480 2,853 1,732 1,103 - 2015 Projected $ $ $ 2015 % Change 520,000 30,000 4,100,000 1,024,980 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 - 4.00% 0.00% 0.00% 0.00% -11.11% 5.56% -15.00% -5.88% 0.00% 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% -50.00% 0.00% 44.04% 0.00% 0.00% 56.53% -30.93% 5.36% 9.32% 6.08% -27.59% 0.17% -68.38% 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% -90.00% 0.00% -33.33% 0.00% 33.33% -50.00% 0.00% 0.00% 05/28/2014 10:55 AM Book1 Section 2 - Page 3 REVENUE BUDGET 2014 - 2015 GENERAL FUND (Continued) Account 34730 34750 34751 34751 34753 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 2011 Actual 2012 Actual RAMADA RESERVATION FEES 1,895 DUSD AQUATIC CENTER REIMB 35,000 DUSD RECREATION REIMB 20,000 COUNTY REIMB FOR LIBRARY 1 TRAFFIC CONTROL BORDER PROJECT $ 66,757 $ MUSEUM SHOP 0 COURT FINES & FORFEITURES 144,669 RESTITUTION PAYMENTS 2,325 LIBRARY FINES & FEES 17,694 COURT FINE OFFICER SA 0 FORFEITED PROPERTY SALE 29,632 INVESTMENT EARNINGS 58,170 RENTAL PAYMENTS 16,621 CALL CENTER Lease 715,478 VISITOR CENTER RESV FEES 3,320 SPECIAL EVENTS REVENUE 1,396 4TH OF JULY REVENUE 625 YOUTH ACTIVITY REVENUE 0 DONATIONS/MISC 0 LIBRARY GRANT E-RATE 147,975 MISCELLANEOUS REVENUE 65,427 1 CASH OVER/SHORT 0 SALE SURPLUS PROPERTY/LAND 16,145 EXPLORER REVENUE 300 TRANSFER FROM LTAF 0 TRANSFER FROM SPECIAL PROJECTS -4 TRANSFER FROM ENTERPRISE FUNDS 386,920 TRANSFER FROM GRANTS 0 TRANSFER FROM COURTS - Reimb 0 TRANSFER FROM RICO CAPITAL LEASE PROCEEDS - TOTAL REVENUE $ 13,873,619 2013 Actual 2,390 35,000 20,000 1,720 56,959 0 0 148,214 3,223 17,279 4,509 137,387 25,580 20,530 715,478 2,660 1,693 79 0 2,520 112,581 93,389 -102 52,021 0 26,001 0 482,209 111,231 0 0 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 2014 10-month Actual 2014 Budget 2,000 60,734 1,180 $ 148,000 1,500 18,000 3,000 120,000 10,000 91,200 715,478 2,500 2,000 1,000 1,000 46,411 180,000 310,000 1,000 216,760 2015 Projected 120,899 768 13,452 5,114 105,039 4,562 78,974 580,828 1,940 2,069 150 12 42,222 65,463 64 203,630 - 2015 % Change 2,000 46,902 0.00% -22.77% 20,000 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 66.67% -33.33% -40.00% 26.97% -6.46% -60.00% 0.00% -50.00% 0.00% 0.00% -9.61% -72.22% 0.00% 64.52% 0.00% 0.00% 0.00% -11.94% 0.00% 0.00% 100.00% 0.00% 5.29% 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 - - 6,000 - $ 13,904,854 $ 15,318,515 $ 15,045,807 $ 11,724,994 $ 15,841,411 05/28/2014 10:55 AM Book1 Section 2 - Page 4 REVENUE BUDGET 2014 - 2015 HIGHWAY USER REVENUE FUND Account 33504 38001 38002 38003 39101 39103 39104 Description 2011 Actual HIGHWAY USERS - STATE MISCELLANEOUS SALES REIMBURSEMENT CITIZEN PAYS POLICY TRANSFER FROM GENERAL FUND TRANSFER FROM LTAF TRANSFER FROM SP PROJECTS 1,227,579 290 63,381 170,000 TOTAL REVENUE 1,492,462 $ 2012 Actual 2013 Actual 1,033,728 1,613 40,201 240,000 83,997 - 31,213 $ 1,399,540 $ 2014 10-month Actual 2014 Budget 1,103,680 15 17,230 211,937 - $ 1,332,862 $ 1,161,303 30,000 5,000 - $ 1,196,303 2015 Projected 933,327 56,100 319 - $ $ 989,745 $ 2015 % Change 1,234,351 30,000 5,000 - 6.29% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1,269,351 6.11% 05/28/2014 10:55 AM Book1 Section 2 - Page 5 REVENUE BUDGET 2014 - 2015 LOCAL TRANSPORTATION ASSIST. (LOTTERY) Account 33505 Description 2011 Actual LOTTERY LTAF II GRANT TOTAL REVENUE 2012 Actual 14,258 $ 14,258 2013 Actual - $ - $ 2014 10-month Actual 2014 Budget 2015 Projected 2015 % Change - $ - $ - $ - 0.00% 0.00% - $ - $ - $ - 0.00% 05/28/2014 10:55 AM Book1 Section 2 - Page 6 REVENUE BUDGET 2014 - 2015 CAPITAL PROJECTS Account 31301 36101 36102 38001 38007 39101 39114 Description 2011 Actual 1 1/3 Cent Sales Tax (Capital) INVESTMENT EARNINGS INVEST EARN - CALL CENTER MISCELLANEOUS 3rd Street Project Revenue TRANSFER FROM GF TRANSFER FROM DEBT FUND 2012 Actual - 12,616 947 217,000 2,446 (607) - TOTAL REVENUE $ 1,839 2013 Actual 12,295 63,619 $ 230,563 $ 75,915 448,038 $ 120,000 101,962 - $ 2014 10-month Actual 2014 Budget $ 670,000 330,969 104 2015 Projected $ 20,254 49,291 $ 400,618 $ 550,000 2015 % Change 63,000 - 22.76% 0.00% 0.00% 0.00% 0.00% -47.50% -100.00% 0.00% 613,000 100.00% 05/28/2014 10:55 AM Book1 Section 2 - Page 7 REVENUE BUDGET 2014 - 2015 DEBT SERVICE FUND Account 31301 36101 39101 39104 39110 Description 2011 Actual 1 1/3 Cent Sales Tax (call center IT) INVESTMENT EARNINGS TRANSFER FROM GENERAL FUND TRANSFER FROM CAPITAL TRANSFER FROM ENTERPRISE TOTAL REVENUE $ 2012 Actual 705,653 604,506 430 1,149,223 60,000 18,082 1,035,372 13,095 1,754,120 2013 Actual $ 1,832,242 $ 2014 10-month Actual 2014 Budget 560,802 777 1,147,062 64,099 8,699 $ 1,781,439 $ 101,962 1,373,580 $ 88,312 1,563,854 $ 2015 Projected 146,908 328 1,144,650 73,593 $ 1,365,480 $ 1,272,178 2015 % Change -100.00% 82,057 -7.38% 0.00% -7.08% 1,354,235 -13.40% 05/28/2014 10:55 AM Book1 Section 2 - Page 8 REVENUE BUDGET 2014 - 2015 MPC Account 39101 39102 39104 Description 2011 Actual TRANSFER FROM GF TRANSFER FROM HURF TRANSFER FROM SPEC PROJECTS 213,610 272,467 TOTAL REVENUE 486,076 $ 2012 Actual 2013 Actual 321,547 162,910 $ 484,456 $ 2014 10-month Actual 2014 Budget 325,691 160,415 - $ 486,106 $ 324,537 162,269 486,806 2015 Projected 271,800.00 $ 133,871.70 $ 405,672 $ 2015 % Change 325,922 160,529 - 0.43% -1.07% 0.00% 486,450 -0.07% 05/28/2014 10:55 AM Book1 Section 2 - Page 9 REVENUE BUDGET 2014 - 2015 RICO Account 33241 33242 36106 39101 39112 Description 2011 Actual RICO-ST ATTY GENERAL RICO-COUNTY ATTY INTEREST RICO TRANSFER FROM GF TRANSFER FROM GRANTS $ TOTAL REVENUE $ 2012 Actual 53,975 47,530 763 407,673 - $ 509,941 $ 2013 Actual 370,310 79,688 2,591 - $ 452,589 $ 2014 10-month Actual 2014 Budget 147,624 77,322 2,878 - $ 227,824 $ 210,000 - $ 210,000 2015 Projected 159,842 9,662 $ $ 169,505 $ 2015 % Change 158,000 - -24.76% 0.00% 0.00% 0.00% 0.00% 158,000 -24.76% 05/28/2014 10:55 AM Book1 Section 2 - Page 10 REVENUE BUDGET 2014 - 2015 JCEF Account 35104 35105 35110 Description 2011 Actual LOCAL JCEF TIME PAYMENTS FILL THE GAP RESTRICTED TRANSFER FROM GF MCEF SUSPENSION FEE TOTAL REVENUE 2012 Actual 6,753 363 (75) $ 7,041 $ 2013 Actual 7,050 1,632 6,964 523 - - 8,682 $ 7,487 2014 10-month Actual 2014 Budget $ 6,000 2,000 $ 2,500 $ 10,500 4,827 - 2015 Projected $ 7,000 1,000 37,000 150 16.67% -50.00% 100.00% -94.00% $ 45,150 330.00% 75 $ 4,902 2015 % Change 05/28/2014 10:55 AM Book1 Section 2 - Page 11 REVENUE BUDGET 2014 - 2015 GRANTS Account Description 2011 Actual 2012 Actual HOUSING & COMM DEVELOPMENT FIRE POLICE PUBLIC WORKS LIBRARY TRANSFER FROM GENERAL FUND TRANSFER FROM HURF TRANSFER FROM CAPITAL PROJ TRANSFER FROM AIRPORT TOTAL REVENUE $ 2013 Actual 10,098 16,075 37,288 637,465 548 82,331 127,181 18,456 - $ 929,442 $ 2014 10-month Actual 2014 Budget 186,434 3,859 50,817 383,953 1,060 62,703 74,651 - $ 763,477 $ 919,464 31,500 108,369 3,859,518 1,000 188,525 $ 5,108,376 2015 Projected 16,526 3,488 61,751 166,042 138,017 - $ $ 385,825 $ 326,750 107,717 187,650 4,652,248 75,422 158,471 2015 % Change 15,000 -64.46% 241.96% 73.16% 20.54% 7442.20% -15.94% 0.00% 0.00% 0.00% 5,523,258 8.12% 05/28/2014 10:55 AM Book1 Section 2 - Page 12 REVENUE BUDGET 2014 - 2015 HOUSING Account 33212 33703 39112 Description 2011 Actual 2012 Actual HOUSING REIMB $ CASAS PIONEER REIMB TRANSFER FROM GF (TRANSIT) TRANFER FROM GRANTS 234,218 20,346 50,408 $ TOTAL REVENUE 304,972 $ $ 2013 Actual 312,977 40,188 $ 353,165 $ 2014 10-month Actual 2014 Budget 287,404 45,780 23,535 $ 356,719 $ 283,071 $ 283,071 $ 2015 Projected 259,471 - $ 259,471 $ 2015 % Change 276,574 - -2.30% 0.00% 0.00% 0.00% 276,574 -2.30% 05/28/2014 10:55 AM Book1 Section 2 - Page 13 REVENUE BUDGET 2014 - 2015 SANITATION Account 34603 36101 38001 39301 Description GARBAGE COLLECTION FEE INVESTMENT EARNINGS MISCELLANEOUS CAPITAL LEASE PROCEEDS TOTAL REVENUE 2011 Actual 1,203,481 (62) 82 $ 1,203,500 2012 Actual 1,237,376 385 73 $ 1,237,834 2013 Actual 1,205,675 3,383 (834) $ 1,208,225 2014 10-month Actual 1,002,820 1,342 51 - 2014 Budget 1,230,000 100 $ 1,230,100 $ 1,004,213 $ 2015 Projected 1,200,000 1,200 - 2015 % Change -2.44% 1100.00% 0.00% 0.00% 1,201,200 -2.35% 05/28/2014 10:55 AM Book1 Section 2 - Page 14 REVENUE BUDGET 2014 - 2015 WATER FUND Account Description 2011 Actual 33201 GRANT REIMBURSEMENT 33301 NAD BANK 34601 WATER SERVICE FEES 34601 1 CIP SURCHARGE 34601 2 IMPACT FEE 36101 INVESTMENT EARNINGS 37001 WIFA Study Grant 38001 MISCELLANEOUS 38001 1 CASH OVER/SHORT 38006 WIFA Water Loan Proceeds 39110 TRANSFER FROM ENTERPRISE TOTAL REVENUE 2012 Actual 1,556,385 332,180 31,982 1,113 274,140 65,719 1,624,027 330,075 5,600 3,836 9,605 40,692 8 - 44,925 47 $ 1,966,633 2013 Actual $ 2,353,702 2014 Budget 19,578 211 1,635,925 328,665 7,980 15,828 6,325 53,296 (113) $ 2,067,694 2014 10-month Actual 1,650,000 331,000 20,000 4,000 1,311,057 272,754 44,800 4,492 1,320 58,741 233 - 50,000 $ 2,055,000 2015 Projected $ 1,693,397 1,650,000 330,000 20,000 5,000 58,666 0.00% 0.00% 0.00% -0.30% 0.00% 25.00% 0.00% 0.00% 0.00% 0.00% 100.00% 2,113,666 2.85% 50,000 $ 2015 % Change 05/28/2014 10:55 AM Book1 Section 2 - Page 15 REVENUE BUDGET 2014 - 2015 WASTE WATER FUND Account 33301 34602 34602 1 36101 38001 38006 39107 Description 2011 Actual NAD BANK GRANT SEWER SERVICE FEES CIP SURCHARGE IMPACT FEE CHANGE INVESTMENT EARNINGS MISCELLANEOUS WIFA WW Loan Proceeds BECC Grant TRANSFER FROM WATER TOTAL REVENUE 2012 Actual 1,312,008 340,423 47,499 (70) 3,293 $ 1,703,154 $ 2013 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 - - - 2,317,183 $ 1,841,690 2014 10-month Actual 2014 Budget 1,240,093 273,318 59,850 6,476 3,953 - 1,480,000 337,000 20,000 10,000 4,000 0 0 $ 1,851,000 2015 Projected $ 1,583,689 $ 2015 % Change 1,485,000 328,000 20,000 8,000 4,000 425,000 575,000 - 0.00% 0.34% -2.67% 0.00% -20.00% 0.00% 100.00% 100.00% 0.00% 2,845,000 53.70% 05/28/2014 10:55 AM Book1 Section 2 - Page 16 REVENUE BUDGET 2014 - 2015 AIRPORT FUND Account 33221 34880 34880 36201 36201 36201 38001 39103 39104 Description 2011 Actual FEDERAL GRANTS FUEL SALES (100 LL) FUEL SALES (JET A) RENTAL PAYMENTS 5 SMALL HANGAR 10 TRAILER RENT MISCELLANEOUS REVENUE TRANSFER FROM LTAF TRANSFER FROM GENERAL FUND 1 2 TOTAL REVENUE $ 2012 Actual 45,108 117,429 9,479 11,750 2,000 225 185,991 2013 Actual $ 123,146 2014 Budget 7,377 32,126 47,200 9,769 14,400 2,550 12,722 22,265 - 38,739 61,979 5,058 14,970 2,400 $ 148,409 2014 10-month Actual $ 30,500 54,000 8,000 14,700 2,700 27,402 $ 137,302 $ 2015 Projected 20,285 69,419 7,654 12,187 3,215 11,855 124,615 38,594 - 0.00% 0.00% 0.00% 6.25% 0.00% 86.82% 0.00% 0.00% 40.84% 0.00% 151,338 10.22% 30,500 54,000 8,500 14,700 5,044 $ 2015 % Change 05/28/2014 10:55 AM Book1 Section 2 - Page 17 REVENUE BUDGET 2014 - 2015 GOLF COURSE Account 6001 6002 6004 6011 6012 6013 6021 6022 6023 6024 6025 6031 6032 6040 6045 6046 6047 6048 36201 38001 38001 39101 39301 Description 2011 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 MISCELLANEOUS LEASE PAYMENTS 1 cash over/short 33,279 397 3,541 5,935 2,900 260 27,640 2,784 27,600 15,962 6,250 283 12,413 2,163 37,810 12,823 48,275 24,302 2,418 3,100 587 $ 2013 Actual 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 38,631 2014 Budget 384,808 252,648 286,291 157,155 - 341,175 75,413 513,716 71,677 318,755 - 125,420 - 104,517 - 25,000 - -80.07% 0.00% 100,000 -75.71% (5) $ 970,195 33,000 500 6,000 8,500 659 132 25,000 2,500 26,000 14,000 7,000 1,000 11,000 3,000 45,000 15,000 87,000 - $ 1,000 315 $ 571,718 19,405 1,379 2,318 5,839 478 13,930 1,782 12,421 8,651 3,328 115 7,326 2,378 26,175 6,255 42,556 61 493 1,925 311 $ 2015 % Change 270,722 687,311 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) 1,762 2015 Projected -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% 0.00% 0.00% 0.00% -100.00% 100.00% 0.00% 0.00% -100.00% 2 SUBSIDY FROM GEN FUND CAPITAL LEASE PROCEED TOTAL REVENUE 2012 Actual 2014 10-month Actual 75,000 30 $ 411,711 $ 261,672 $ 05/28/2014 10:55 AM Book1 Section 2 - Page 18 GENERAL FUND ADMINISTRATION 001-51001-413 Account Description 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 Personnel Expense Operating Expense 3001 4104 4301 4303 5401 5801 6001 6201 6401 6501 2011 Actual 2012 Actual 333,184 902 23,783 32,095 26,492 1,581 523 - 331,942 19 15,457 514 24,436 32,027 23,656 1,164 540 - $ Contractual serv Telephone Services Auto & Eq Maintenance Computer Maintenance Adv/Printing/Reproduction Travel/training Office supplies Postage Books/Dues/Subscrip Gas/Oil/Lube 418,560 $ 4,054 429,756 2015 Requested 2015 % Change $ 318,829 2,766 22,501 34,658 6,191 1,206 714 22,420 $ 350,268 26,796 40,211 6,194 968 754 20,513 -4.78% 0.00% 0.00% 0.00% -4.78% -3.26% -22.42% -39.43% -16.37% -26.99% $ 476,139 $ 409,285 $ 445,704 -6.39% 3,948 3,000 2,970 0 1,000 552 14,523 15,175 7,770 337 1,633 1,529 5,000 10,000 6,670 500 6,820 1,000 5,457 12,421 5,195 187 223 329 3,000 4,750 1,000 1,500 5,000 10,000 6,670 500 6,820 1,000 0.00% 100.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 40,240 18.39% $ 485,944 -4.74% 384,587 $ 367,849 0 0 1,527 28,088 28,140 42,052 41,567 7,415 7,985 1,485 1,599 829 901 25,195 28,098 $ 3,849 26,480 8,413 5,257 327 10,356 543 2014 YTD 04/30/14 2013 Actual 2014 Budget 13,245 8,119 6,414 410 3,851 559 491,178 Operating Expense $ 55,428 $ 36,447 $ 44,915 Total Expenses $ 473,988 $ 466,203 $ 536,093 $ 33,990 $ 510,129 $ 27,333 $ 436,617 $ CAPITAL OUTLAY Item City Hall Doors City Hall Bathroom Renovation Total Book1 2015 Requested 30,000 $ 30,000 2015 Approved* $ *Budgeted in GF Department 1801 - Section 3 - Page 1 05/28/2014 10:55 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 2011 Actual 2012 Actual 2013. Actual 2014 Budget $ Contractual Auto/equip Travel/training Office supplies Postage Books/dues/subscrip Gas/oil/lube Marketing/Promotions - $ - $ 2014 YTD 04/30/14 2015 Requested 2015 % 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% 451 25,000 12,500 51,373 3,000 2,513 - 2,028 Operating Expense $ 51,824 $ 28,000 $ 15,013 $ - $ 2,028 $ - 0.00% Total Expenses $ 51,824 $ 28,000 $ 15,013 $ - $ 2,028 $ - 0.00% CAPITAL OUTLAY Book1 Items 2015 Requested 2015 Approved* *Budgeted in GF Department 1801 Total $ $ - - Section 3 - Page 2 05/28/2014 10:55 AM GENERAL FUND VISITOR CENTER 001-51005-419 Account Description 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 Personnel Expense Operating Expense 3001 4104 4105 4302 4303 5801 6001 6014 6015 6201 6401 6601 8009 2011 Actual 2012 Actual 12,352 900 43 1,017 719 18 39 - 30,904 996 630 2,476 3,129 4,554 148 67 - $ Contractual serv Telephone Services Utilities Building Maintenance Computer Maintenance Travel/training Office supplies Museum Collections Museum ProShop Postage Books/Dues/Subscrip Uniforms Marketing/Promotions 15,088 $ 42,905 2013 Actual 2014 Budget 26,687 1,313 0 0 2,146 2,964 1,482 130 77 2,280 $ 37,078 2014 YTD 04/30/14 19,458 2,000 - 17,223 2,121 69 1,488 1,955 453 92 109 1,193 1,642 2,199 1,453 101 54 1,480 $ 28,385 2015 Requested $ 24,702 8,308 7,766 9,268 8,550 6,634 8,022 1,560 7,417 1,331 7,390 848 7,600 1,500 4,912 3,167 173 3,253 110 20,876 19 - 165 773 131 13,917 411 209 2,347 179 89 13,917 1,526 600 2,500 200 13,917 100 10,000 732 1,942 192 13,917 4,179 16,670 2,000 - $ 2015 % Change 1,428 1,914 1,148 66 42 1,396 -14.33% 100.00% 0.00% 0.00% -12.99% -12.96% -20.96% -34.21% -22.83% -5.71% 24,664 -13.11% 8,550 450 7,600 1,500 250 600 2,500 200 13,917 100 10,000 0.00% 100.00% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 42,321 $ 31,911 $ 35,774 $ 44,967 $ 35,675 $ 45,667 1.56% Total Expense $ 57,409 $ 74,816 $ 72,852 $ 73,352 $ 60,377 $ 70,331 -4.12% CAPITAL OUTLAY Item Facility Upgrades for Social Events Doors Total Book1 2015 Requested 6,000 5,000 $ 11,000 2015 Approved* *Budgeted in Capital Projects 5,000 5,000 $ 10,000 Section 3 - Page 3 05/28/2014 10:55 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 2011 Actual 2012 Actual 35,591 2,732 - 36,706 2,807 470 9 66 62 $ Contractual Services Utilities Building Maintenance Office supplies Uniforms Operating Expense Total Expense $ 38,385 $ 40,059 2013 Actual 2014 Budget 27,242 2,084 2,128 27 61 $ 31,542 $120 3,016 180 756 63 $120 2,652 41 225 86 135 1748 216 46 71 $4,135 $3,125 $2,216 33,757 42,520 $ 43,184 $ 2014 YTD 04/30/14 $ - 2015 Requested $ - $ 2015 % Change - 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% - 0.00% 0.00% 0.00% 0.00% 0.00% - $0 697 95 - $ - $792 $ - 0.00% $ - 792 $ - 0.00% $ CAPITAL OUTLAY Item Total Book1 2015 Requested $ 2015 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 4 05/28/2014 10:55 AM GENERAL FUND FINANCE 001-51201-415 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2016 Salaries Sal - Temp Sal - Ltd Sal - Overtime OASI State Retire Health Ins Income Protect State Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 4104 4303 5401 5801 6001 6201 6401 2011 Actual 2012 Actual 310,606 1,000 551 22,370 29,888 34,451 1,767 540 - 294,715 20,996 26,417 33,543 1,170 559 - $ Contractual serv Telephone Services Computer Maintenance Advertising Travel/training Office supplies Postage Books/Dues/Subscrip 401,173 $ 377,401 2013 Actual 2014 Budget 253,174 $ 0 0 74 18,365 27,314 11,884 1,197 862 25,979 $ 338,850 $ 2014 YTD 04/30/14 2015 Requested 2015 % Change 286,753 21,937 32,403 11,421 1,439 727 23,316 $ 238,128 17,214 26,870 11,530 1,160 572 28,466 $ 294,859 22,557 33,850 9,643 1,105 658 30,770 2.83% 0.00% 0.00% 0.00% 2.83% 4.46% -15.57% -23.22% -9.50% 31.97% 377,997 $ 323,939 $ 393,441 4.09% 132,145 5,700 1,500 500 1,220 11,000 7,050 765 2.63% 100.00% 100.00% -33.33% 0.00% 2.80% -30.20% 0.00% 145,010 124,819 128,143 128,761 106,394 1,174 5,505 11,179 10,439 1,155 979 3,346 13,047 10,865 945 129 2,141 10,635 11,231 1,437 750 1,220 10,700 10,100 765 546 1,108 7,122 9,226 487 Operating Expense $ 174,461 $ 154,001 $ 153,717 $ 152,296 $ 124,883 $ 159,880 4.98% Total Expenses $ 575,634 $ 531,402 $ 492,567 $ 530,293 $ 448,821 $ 553,321 4.34% CAPITAL OUTLAY Items 2015 Requested 1 Inventory Control Program w/ scanners Total Book1 2015 Approved* *Budgeted in GF Department 1801 12,000 $ 12,000 Section 3 - Page 5 $ - 05/28/2014 10:55 AM GENERAL FUND HUMAN RESOURCES 001-51301-415 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2008 2009 2010 2011 2016 Salaries Sal - Temp Sal - Ltd Sal - OT OASI State Retire Health Ins Income Protect State Comp Unempl. Ins HR Processing SF Terrorism Premium 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 2014 YTD 04/30/14 2015 % Change 2012 Actual 2013 Actual 158,824 1,955 3,382 12,271 15,581 10,145 843 284 16,635 3,319 2,178 2,475 1,725 - 169,088 226 5,352 66 13,106 17,368 10,400 683 336 7,559 6,378 1,308 - 169,777 4,771 13,234 19,000 4,694 753 386 14,565 7,673 2,073 1,600 1,200 2,731 $ 181,496 6,217 14,360 21,212 7,438 863 476 10,000 15,000 3,000 3,000 2,000 2,339 $ 147,449 515 75 11,116 16,644 2,260 650 356 14,340 13,714 1,276 1,600 1,250 2,306 $ 181,496 6,217 14,360 21,549 6,570 638 419 10,000 15,000 2,500 2,500 1,500 8,373 0.00% 0.00% 0.00% 0.00% 0.00% 1.59% -11.68% -26.10% -11.99% 0.00% 0.00% -16.67% -16.67% -25.00% 257.98% 242,457 $ 267,401 $ 213,551 $ 271,122 1.39% 5,400 3,200 35,600 4,750 900 132,300 50,000 1,000 4,000 2,000 300 1,190 0.00% 0.00% 0.00% 0.00% 100.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ 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 229,617 $ 231,869 $ 2014 Budget 2015 Requested 2011 Actual 5,153 610 66,947 21,327 4,327 2,434 3,141 40,564 5,296 1,907 32,598 5,400 3,200 35,600 4,568 308 33,703 113,162 45,168 115 8,529 1,455 324 1,153 84,182 24,476 6,927 1,602 471 2,247 111,491 27,227 1,093 2,729 3,622 348 1,830 132,300 50,000 1,000 4,000 2,000 300 1,190 131,206 14,835 211 2,315 1,459 255 1,132 Operating Expense $ 263,941 $ 170,371 $ 188,141 $ 234,990 $ 189,994 $ 240,640 2.40% Total Expense $ 493,558 $ 402,240 $ 430,598 $ 502,391 $ 403,544 $ 511,762 1.87% CAPITAL OUTLAY 2015 Requested Item 0 Total $ 2015 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 6 Book1 05/28/2014 10:55 AM MANAGEMENT INFORMATION SYSTEMS 001-51401-419 Account Description 2014 YTD 04/30/14 2015 2015 Requested % Change 60,507 12,479 55,795 532 9,325 14,075 2,328 465 184 8,122 $ $ $ 128,257 19,756 11,323 16,725 5,761 710 180 10,156 $ $ $ 72,451 49,973 29 8,988 13,818 2,864 500 140 9,653 $ 128,257 $ $ 21,441 11,452 17,185 5,426 535 153 13,048 0.00% 0.00% 8.53% 0.00% 1.14% 2.75% -5.82% -24.72% -14.70% 28.47% 163,811 $ 192,868 $ 158,416 $ 197,496 2.40% 120,006 144,628 1,500 1,500 30,000 7,000 3,000 100 500 2,000 123,352 117,001 947 424 21,496 2,609 6 229 986 161,770 5,550 1,500 500 15,000 10,000 3,500 50 2,000 34.80% -96.16% 100.00% 100.00% -50.00% 42.86% 16.67% -50.00% -100.00% 0.00% 2012 Actual 2013 Actual 146,120 4,354 36,022 516 12,520 17,374 18,183 886 167 - 94,651 12,122 80,069 476 11,060 16,846 11,518 541 175 - 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 Personnel Expense 2014 Budget 2011 Actual $ 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 236,143 $ 227,458 186,832 172,441 188,690 157,549 19,570 5,844 3,372 34 1,173 19,391 2,771 3,130 2,029 $ 149,438 168,770 1,170 17,615 5,488 2,551 1,317 Operating Expense $ 389,266 $ 373,560 $ 346,349 $ 310,234 $ 267,049 $ 199,870 -35.57% Total Expense $ 625,408 $ 601,018 $ 510,160 $ 503,102 $ 425,465 $ 397,366 -21.02% CAPITAL OUTLAY Items 1 Generator Computer Replacement Program Data Retention system - Electronic Archiving Software Upgrades Security Management - Access Management GIS Mapping IP Phone Upgrade TOTAL Book1 2015 Requested 100,000 17,800 100,000 45,000 75,000 15,000 50,000 $ 402,800 Section 3 - Page 7 2015 Approved* *Budgeted in Capital Projects 100,000 $ 100,000 05/28/2014 10:55 AM GENERAL FUND GENERAL GOVERNMENT 001-51501-413 Account Description Personnel Expense 1001 1003 1006 2001 2006 2014 Salaries Sal Temporary Vac/Sick Leave Pay-outs OASI State Comp Contractual Services Elections Legal Services Council Expenses Mayor Expense Ward 1 Expense Ward 2 Expense Ward 3 Expense Ward 4 Expense Ward 5 Expense Ward 6 Expense Telephone Services Books Due & Subscription Misc. Council Projects Bus. Dist. Impr. Traffic Control Border Project Demolition Program DUSD Infra Improvement Reserve Fireworks DARC-Utilities Economic Development Employee Reward Program Special Events Mariachi Festival/Event Winter Visitor Expense 4th of July Expense Youth Activity Expense League of Cities Event Douglas Days Transfer to HURF Transfer to Capital Projects Transfer to Airport Transfer to Enterprise Transfer to Housing Transfer to Golf Course Transfer to JCEF 9914 Transfer to RICO 9915 Transfer to Grants 9916 Transfer to MPC Book1 2012 Actual 18,054 18,157 5,703 1,708 43 - 1,381 31 3,470 Retirement Incentives Personnel Expense Operating Expense 3001 3004 3005 3101 3102 3103 3104 3105 3106 3107 3108 4104 6401 7601 7602 7604 7621 7630 8003 8004 8005 8006 8008 8101 8102 8103 8104 8106 8109 8110 9902 9904 9906 9910 9911 9913 2011 Actual $ 22,935 $ 25,610 2013 Actual 2014 Budget $ 18,045 1,232 41 - $ 19,317 $ 19,423 $ 5,000 3,000 4,000 2,000 2,000 2,000 2,000 2,000 2,000 21,250 185,000 51,249 3,131 30,835 166,519 2,910 3,022 708 91 333 988 1,420 1,107 17,675 4,854 9,833 28,316 24,131 23,039 40,435 1,804 2,150 5,725 1,844 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 205,861 240,000 341,175 513,716 22,265 45,780 318,755 407,673 252,505 272,467 82,331 321,547 62,703 325,691 Section 3 - Page 8 18,000 2014 YTD 02/28/14 $ $ 15,000 1,024 36 - $ $ 16,060 $ 15,537 7,237 6,013 3,109 596 992 423 85 1,193 848 18,973 4,174 6,812 1,022 42,865 16,008 986 16,000 2,319 2,954 1,377 46 - 15,000 62,686 70,000 15,000 1,000 16,000 4,000 1,000 2,200 120,000 27,402 2015 Requested 125,420 49,291 11,855 104,517 188,525 324,537 271,800 18,000 2015 % Change 1,377 40 - 0.00% 0.00% 0.00% 0.00% -11.99% 0.00% $ 19,417 -0.03% $ 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 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% 0.00% -94.59% 0.00% 0.00% -33.33% -68.38% 1000.24% 0.00% 0.00% 0.00% 0.00% 3.13% 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% 100.00% -47.50% 40.84% 0.00% 0.00% -80.07% 100.00% 0.00% -15.94% 0.43% 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 05/28/2014 10:55 AM GENERAL FUND GENERAL GOVERNMENT 001-51501-413 9917 Transfer to Debt Service Book1 1,035,372 1,149,223 1,147,062 1,373,580 1,144,650 1,272,178 -7.38% Operating Expense $ 2,885,920 $ 2,433,870 $ 2,055,067 $ 2,627,849 $ 1,730,259 $ 2,882,722 9.70% Total Expenses $ 2,908,856 $ 2,459,481 $ 2,074,384 $ 2,647,272 $ 1,746,319 $ 2,902,140 9.63% Section 3 - Page 8 05/28/2014 10:55 AM SPECIAL EVENTS SUPPORT FY 12/13 EVENT ROTARY - 2ND ANNUAL FLY IN DOUGLAS SENIOR CITIZENS DARC DOUGLAS REGIONAL ECONOMIC COUNCIL TOTAL SPECIAL EVENTS Book1 AMOUNT REQUESTED $ 2,000 1,500 13,000 40,000 56,500 Section 3 - Page 8A AMOUNT RECOMMENDED $ 2,000 1,500 13,000 16,500 AMOUNT APPROVED $ - 05/28/2014 10:55 AM GENERAL FUND MAGISTRATE 001-51601-412 Account Description Personnel Expense 1001 1003 1005 2001 2002 2004 2005 2006 2016 Salaries Sal - Temp Sal - Overtime OASI Retirement Health Ins Income Prot. State Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 5801 6001 6201 6401 2014 YTD 04/30/14 2015 % Change 2012 Actual 2013 Actual 46,714 3,441 4,488 3,185 290 81 - 46,312 3,388 4,606 3,121 204 83 - 46,222 3,446 5,032 1,821 238 103 1,975 $ 37,689 6,490 3,380 4,259 2,325 195 112 2,045 $ 38,181 482 2,898 4,200 1,192 195 93 1,433 $ 38,812 6,500 3,466 4,456 768 154 101 7,466 2.98% 0.15% 0.00% 2.56% 4.62% -66.94% -20.93% -9.73% 265.06% 58,837 $ 56,494 $ 48,674 $ 61,723 9.26% 15,000 - 0.00% 0.00% 0.00% 0.00% 0.00% $ Contractual Services Travel/Training Office Supplies Postage Books/Dues/Subscr. 58,200 $ 15,000 41 208 647 25 57,715 $ 15,000 - 2014 Budget 2015 Requested 2011 Actual 15,000 - 15,000 - 12,500 47 - Operating Expense $ 15,922 $ 15,000 $ 15,000 $ 15,000 $ 12,547 $ 15,000 0.00% Total Expense $ 74,122 $ 72,715 $ 73,837 $ 71,494 $ 61,221 $ 76,723 7.31% CAPITAL OUTLAY Items Chambers Upgrades Total Book1 2015 Requested $ 81,000 81,000 2015 Approved* $ *Budgeted in JCEF 81,000 81,000 Section 3 - Page 9 05/28/2014 10:55 AM GENERAL FUND LIBRARY 001-51701-412 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2016 Salaries Salaries Temp Salaries Limited Salaries O/T OASI State Retire Health Ins Income Protect State Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 4104 4105 4109 4302 4303 5401 5801 6001 6005 6201 6301 6401 2014 YTD 04/30/14 2011 Actual 2012 Actual 2013 Actual 155,756 32,047 15,726 69 15,281 16,166 12,291 941 988 - 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 $ 127,438 38,000 12,656 14,400 9,298 659 420 4,738 $ 206,758 $ 207,609 $ $ Contract Serv Telephone Utilities Utilities Gov Center Building Maintenance Computer Maintenance Advertising & Printing Travel/training Office supplies Library Materials Postage Small Tools & Eq Books/Dues/Subscrip 249,265 $ 183,045 $ 2014 Budget 2015 Requested 2015 % Change 98,130 36,618 26 10,172 9,966 5,357 436 532 6,901 $ 121,462 74,000 14,953 13,944 8,931 482 436 11,164 -4.69% 94.74% 0.00% 0.00% 18.15% -3.17% -3.95% -26.81% 3.99% 135.63% 168,138 $ 245,371 18.19% 63.70% 100.00% 6.13% -100.00% 69.09% 100.00% 0.00% 100.00% 28.67% 2.12% 70.00% 0.00% 0.00% 31.05% 13,465 46,536 14,773 15,770 17,908 Operating Expense $ 94,110 $ 131,135 $ 101,852 $ 102,225 $ 99,485 25,816 41,512 42,450 9,300 3,000 2,000 250 9,650 24,973 1,700 $ 160,651 36,189 40,360 8,423 7,520 42,247 8,919 40,000 6,000 5,500 32,844 10,119 8,115 720 8,349 26,032 934 - 374 914 9,290 25,168 974 - 896 381 12,255 20,998 1,179 204 - 2,000 7,500 24,455 1,000 - 25 649 9,058 18,805 1,421 438 104 Total Expenses $ 343,375 $ 314,180 $ 308,610 $ 309,834 $ 267,623 $ 406,022 57.15% CAPITAL OUTLAY 2015 Requested Items Shelving Carpet DVD/CD Repair and Cleaner Machine 2 Handicap Automatic Door Openers for Publc Bathrooms Inventory Device/Wand Elevator RFID System Wand Total Book1 $ Section 3 - Page 10 12,500 26,852 5,000 4,100 5,500 50,000 6,500 110,452 2015 Approved* $ *Budgeted in Capital Projects 5,000 5,500 10,500 05/28/2014 10:55 AM GENERAL FUND COMMUNITY DEVELOPMENT NEIGHBORHOODS/GRANTS 001-52001-419 Account Description Personnel Expense 1001 1003 1005 2001 2002 2004 2005 2006 2016 Salaries Salaries Temp Salaries/OT OASI State Retire Health Ins Income Protect Workman's Comp Self Fund Ins Claims Personnel Expense Operaitng Expense 3001 5401 5801 6001 6201 6301 6401 6500 6601 2011 Actual 2012 Actual 2013 Actual 2014 Budget $ Contractual Services Advertising Travel/training Office supplies Postage Small Tools & Equipment Books/dues/subscrip Gas/oil/lube Uniform 55,674 48,357 58,510 281 3,787 5,377 6,758 321 1,417 - 50 3,379 4,822 5,835 201 1,093 - 2,540 4,104 6,558 1,341 284 1,948 8,149 73,615 $ 3,675 1,536 449 120 1,527 246 63,737 $ 83,434 74 622 457 1,541 318 101 1,348 196 $ - 2014 YTD 04/30/14 $ $ 2,369 $ 1,320 211 35 248 124 1,401 292 2,369 $ - 2015 Requested 22,330 3,017 1,006 1,914 2,495 1,262 121 823 1,549 $ 34,517 $ 49 20 6 223 - - - 2015 % Change - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -100.00% - -100.00% - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Operating Expense $ 7,552 $ 4,657 $ 3,631 $ - $ 298 $ - 0.00% Total Expenses $ 81,167 $ 68,394 $ 87,066 $ 2,369 $ 34,815 $ - -100.00% pg 14 CAPITAL OUTLAY Book1 Items 2015 Requested 2015 Approved* *Budgeted in GF Department 1801 Total $ $ - - Section 3 - Page 11 05/28/201410:55 AM GENERAL FUND TRANSIT -- Account Descriptions Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2008 2016 Salaries Salaries/Temp Salaries LTD Salaries Overtime O.A.S.I. Retire-State Health Insurance Income Protection Workman's Compensation HR Processing Self Funding Ins Claims/Fees Personnel Expense Operating Expense 3001 4104 4105 4301 4302 4303 5201 5401 5801 6001 6002 6201 6301 6401 6501 6601 8003 2011 Actual 2012 Actual 2013 Actual 2014 Budget 59,751 11,522 94,353 2,268 12,396 17,016 14,922 668 5,294 941 11,642 $ - $ - 90,163 $ 2015 Requested 2015 % Change 143,015 17,838 26,349 15,872 1,205 7,862 1,700 25,668 50,660 20,963 92,015 1,051 11,979 16,892 10,810 728 4,836 87 21,623 $ 119,887 197,880 5,988 24,767 37,167 18,186 1,269 7,084 1,440 35,864 32.97% 0.00% 0.00% 0.00% 38.84% 41.06% 14.58% 5.24% -9.90% -15.29% 39.73% $ 230,773 $ 329,673 $ 231,645 $ 449,532 36.36% 8,199 5,016 226 7,636 44 4,930 6,400 3,250 30,000 10,500 15,500 500 3,750 950 4,500 50 - $9,882.51 4,804 2,441 9,696 1,008 425 4,374 447 130 27 11,030 7,000 3,200 15,000 3,000 7,378 1,650 7,250 1,000 3,000 100 - Contractual Services Telephone Utilities Auto & Equipment Building Maintenance Computer Maintenance Liability Insurance Advertising & Printing Travel & Training Office Supplies Operating Supplies Postage Small Tools & Equipment Books/Dues/Subscriptions Gas/Oil/Lubricants Uniforms Contingency $ 2014 YTD 04/30/14 29,287 1,247 - 75,000 2,000 19,450 35,318 326 - 55,000 3,000 24,384 123.73% 9.38% -1.54% -50.00% -71.43% #DIV/0! -52.40% 230.00% 93.33% 5.26% -33.33% 100.00% #DIV/0! #DIV/0! -26.67% 50.00% 25.37% 4,534 688 3,214 1,098 791 147 Operating Expense $ - $ - $ 62,128 $ 176,780 $68,880.03 $ 141,992 -19.68% Total Expenses $ - $ - $ 292,901 $ 506,453 $ 300,525 $ 591,524 16.80% pg 18 CAPITAL OUTLAY Book1 Items 2015 Requested 2015 Approved* *Budgeted in GF Department 1801 2 36 passenger bus Bay & Lift 5 PCs w/ software licenses 12 Bus stops 14 Benches Total 272,000 53,820 6,900 52,676 7,350 $ 392,746 272,000 53,820 6,900 52,676 7,350 $ 392,746 Section 3 - Page 26 05/28/2014 10:55 AM GENERAL FUND CEMETERY 001-52021-452 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2016 Salaries Sal-Temp Sal-Lim Sal-OT OASI State Retire Health Ins Income Protect Workman's Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 4105 4301 4302 4303 5501 5801 6001 6002 6021 6301 6401 6501 6502 6601 6701 2011 Actual $ Contractual Services Utilities Auto/equip Building Maintenance Computer Maintenance DOC Labor Travel/training Office supplies Operating supplies Chemicals Small tools & Eq Books/dues/subscrip Gas/oil/lube Diesel/oil/lube Uniforms Construction materials 2012 Actual 2013 Actual 2014 Budget 59,428 40,397 30,730 $ 33,095 661 2,606 4,079 10,310 196 1,589 - 10,466 487 2,870 4,539 1,007 181 2,283 6,986 $ 1,005 3,776 5,807 12,441 374 2,122 - 45,685 500 6,065 8,959 1,112 282 2,057 2,369 59,548 $ 100,123 84,953 $ 59,838 $ 2014 YTD 04/30/14 2015 Requested 2015 % Change $ $ $ 39,349 608 31,346 2,144 5,531 8,289 2,712 290 3,741 3,431 $ 68,665 $ 22,843 500 7,039 10,563 4,465 301 4,518 5,582 107.48% 0.00% -50.00% 0.00% 16.05% 17.90% 301.58% 6.61% 119.66% 135.63% $ 97,443 $ 124,475 24.32% 0.00% 0.00% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 25.00% 0.00% 0.00% 0.00% 30.00% 100.00% 0.00% 0.00% 230 4,322 2,191 1,160 4,536 1,067 505 7,173 3,582 $800 3,500 3,000 3,500 $865 3,171 2,789 3,407 2,900 107 3,075 1,461 577 3,326 3,088 122 55 4,784 4,788 461 63 6,011 2,500 150 250 2,000 3,000 1,000 5,000 434 3,871 285 3,735 3,832 122 532 5,762 1,804 485 9,848 865 6,966 1,050 4,000 2,100 568 3,265 2,326 677 5,915 1,593 1,052 2,490 $800 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 Operating Expense $ 22,265 $ 28,995 $ 41,475 $29,750 $30,218 $33,650 13.11% Total Expense $ 107,218 $ 88,833 $ 101,023 $ 129,873 $ 127,660 $ 158,125 21.75% CAPITAL OUTLAY Items 1 Ride Mower Chip Seal project Restroom Upgrade Gator TOTAL Book1 2015 Requested 12,000 30,000 6,000 9,000 $ 57,000 2015 Approved* *Budgeted in Capital Projects 12,000 6,000 9,000 $ 27,000 Section 3 - Page 12 05/28/2014 10:55 AM GENERAL FUND PARKS 001-52023-452 Account Description Personnel Expense 1001 1003 1004 1005 2201 2002 2004 2005 2006 2016 Salaries Sal-Temp Sal-Lim Sal-OT OASI State Retire Health Ins Income Protect Workman's Comp Self Fund Ins Claims Book1 2014 YTD 04/30/14 2015 Requested 2015 % Change 184,662 96,181 500 21,523 32,298 7,987 843 8,870 35,444 -15.32% 0.00% 31.15% 0.00% -3.62% -2.08% -30.07% -33.67% -14.68% 26.15% 242,407 3,276 51,217 1,333 20,839 26,405 41,767 1,578 7,219 - 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 218,065 73,339 500 22,331 32,985 11,421 1,271 10,396 28,098 163,858 158 55,369 1,084 16,099 24,853 7,489 995 7,507 25,652 $ 396,041 $ 390,529 $ 417,095 $ 398,406 $ 303,065 $ 388,309 -2.53% 35,931 1,231 43,010 36,389 1,737 44,415 35,466 1,397 31,269 500 35,000 1,000 42,000 95 27,151 1,096 34,989 23,157 11,741 16,636 9,000 14,000 7,493 14,040 12,368 825 451 15,886 4,818 87 17,720 11,066 723 611 27,748 6,773 472 23,444 2,138 3,961 2,698 3,215 10,192 744 934 30,623 8,629 1,170 22,378 2,702 3,441 10,000 1,500 500 26,000 8,000 3,000 16,000 2,000 3,150 4,000 7,443 189 269 16,171 6,717 1,146 14,007 1,658 3,080 1,161 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 0.00% 0.00% 0.00% 0.00% 100.00% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 25.00% 0.00% 0.00% 0.00% 12.50% 0.00% 0.00% 0.00% Operating Expense $ 161,584 $ 171,031 $ 165,579 $ 175,650 $ 136,706 $ 180,850 2.96% Total Expenses $ 557,625 $ 561,561 $ 582,674 $ 574,056 $ 439,771 $ 569,159 -0.85% Personnel Expense Operating Expense 3001 4101 4102 4103 4104 4301 4302 4303 5501 5801 6001 6002 6021 6025 6301 6401 6501 6502 6601 6701 2011 Actual 2012 Actual 2013 Actual 2014 Budget Contractual Services Electric Gas Water/Sewer/Sanitation Telephone Services Auto/equip Building Maintenance Computer Maintenance DOC Labor Travel/training Office supplies Operating supplies Supplies/Chemicals Rye Grass Seed Small tools Books/dues/subscrip Gas/oil/lube Diesel/Oil Uniforms Construction materials Section 3 - Page 13 pg 16 05/28/2014 10:55 AM GENERAL FUND PARKS 001-52023-452 CAPITAL OUTLAY 2015 Items Requested 9 weedeater and Blowers 5,000 Portable gas generator with elder 8,000 Playground upgrades 10,000 Desert Landscape - W area of Veteran's Park 5,000 Lighting Improvements all parks 90,000 Parking lot for baseball field - Veteran's Park 10,000 Playground Solar Lighting - Veterans 5,000 Ramadas 30,000 Roofing 8th St. Park shop roof and bathrooms 5,000 Tennis court flooring Veteran's Park 5,000 Tractor w Front Loader 30,000 Walkway Repair East side - Veteran's Park 10,000 Walkway Repair South side - Veteran's Park 10,000 Walkway Repair West side - Veteran's Park 10,000 Ride Mower 72" 16,000 Playground replacement equipment 12,000 Basketball court NEW- Causey Park 15,000 Field Groomer 13,000 Restroom Causey Park 25,000 Basketball court NEW- Causey Park 15,000 Truck 17,000 Line Cutter 9,000 Total $ 289,000 Book1 2015 Approved* *Budgeted in Capital Projects 35,500 $ Section 3 - Page 13 35,500 05/28/2014 10:55 AM GENERAL FUND RECREATION 001-52031-451 Account Descriptions Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2016 Salaries Salaries/Temp Salaries LTD Salaries Overtime O.A.S.I. Retire-State Health Insurance Income Protection Workman's Compensation Self Fund Ins Claims Personnel Expense Operating Expense 4104 4105 4301 4302 4303 5401 5801 6001 6007 6201 6301 6401 6501 6601 2011 Actual 2012 Actual 2013 Actual 2014 Budget 15,533 44,346 9,522 459 5,150 2,459 3,209 121 1,683 $ Telephone Utilities Auto & Equipment Building Maintenance Computer Maintenance Advertising & Printing Travel & Training Office Supplies Recreation Cost Postage Small Tools & Equipment Books/Dues/Subscriptions Gas/Oil/Lubricants Uniforms 82,481 17,319 41,152 16,078 357 5,525 3,368 3,637 117 1,791 $ 89,343 $ 2014 YTD 04/30/14 $ 38,000 22,108 500 4,636 3,246 54 2,158 3,893 $ 10,206 39,889 14,891 826 4,933 3,028 302 97 2,198 2,280 $ 41,068 42,000 22,108 500 8,084 8,001 896 190 3,332 7,466 100.00% 10.53% 0.00% 0.00% 74.36% 146.50% 100.00% 250.43% 54.35% 91.77% 92,963 $ 74,596 $ 78,651 $ 133,644 79.16% 950 3,000 1,000 1,800 400 3,000 750 1,500 15,000 50 390 500 1,000 0.00% 0.00% 0.00% 20.00% 11,577 2,017 8,809 3,374 3,000 1,000 1,500 2,442 230 1,124 2,050 375 2,846 10,602 8 541 652 3,478 2,502 14,050 7 468 533 3,593 1,406 13,383 4 566 461 2,000 750 1,000 15,000 50 500 600 2,172 50 394 10,256 93 315 $ 34,633 $ 2015 % Change 17,852 40,540 17,066 691 5,657 4,553 503 136 2,471 3,493 11,507 3,758 32,340 2015 Requested Operating Expense $ Total Expenses $ 114,821 $ 123,976 Items 2015 Requested 2015 Approved* *Budgeted in GF Department 1801 Workout Equipment Total $ 50.00% 0.00% 50.00% 0.00% 0.00% 0.00% 0.00% 0.00% 66.67% 31,596 $ 25,400 $ 17,076 $ 29,340 15.51% $ 124,559 $ 99,996 $ 95,727 $ 162,984 62.99% CAPITAL OUTLAY Book1 5,000 5,000 $ - Section 3 - Page 14 05/28/2014 10:55 AM GENERAL FUND AQUATICS 001-52035-451 Account Description Personnel Expense 1001 1003 1004 1005 1006 2001 2002 2004 2005 2006 2016 Salaries Salaries/Temp Salaries/Lim Salaries/OT Salaries/Reimbursement OASI State Retire Health Ins Income Protect Workman's Comp Self Fund Ins Claims Personnel Expense Operaitng Expense 3001 4104 4105 4106 4108 4301 4303 4304 5401 5801 6001 6007 6011 6012 6013 6201 6401 6501 6601 Book1 2011 Actual 2012 Actual 56,821 75,800 5,254 1,446 291 10,447 5,690 6,296 348 3,405 - 64,771 84,369 229 10,407 12,194 6,467 4,605 295 3,827 - $ Contractual Services Telephone Services Utilities Utilities-Aquatic Center Utilities-8th Street Auto & Eq Maintenance Computer Maintenance Maint.Cost-Aquatic Center Advertising & Printing Travel/training Office supplies Recreation Cost Swimming Pool Aquatic Center Concession Aquatic Center-Pro Shop Postage Books/dues/subscrip Gas/oil/lube Uniforms 165,796 $ 187,165 2013 Actual 2014 Budget 67,168 $ 99,080 (1,820) 13,339 13,589 7,998 4,531 354 5,731 5,455 $ 215,423 $ 71,606 75,000 16,464 500 10,000 13,278 10,008 4,649 371 7,730 4,738 2014 YTD 04/30/14 $ 59,495 67,092 2,995 397 6,200 10,409 7,985 3,873 333 4,569 4,969 2015 Requested $ 2015 % Change 71,906 75,000 16,464 500 10,000 13,301 10,202 4,465 286 6,858 5,582 0.42% 0.00% 100.00% 0.00% 0.00% 0.17% 1.94% -3.95% -22.98% -11.28% 17.82% 214,345 $ 168,317 $ 214,565 0.10% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 100.00% 17.65% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 230 297 1,021 1,030 $753 4,349 43,376 4,811 51,417 8,488 5,691 49,100 8,091 - 4,000 45,000 10,000 1,000 4,772 41,743 8,237 233 17,399 1,361 3,573 1,353 1,004 12,783 248 2,940 2,899 1,488 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 17,000 500 1,150 1,500 1,000 7,000 500 500 2,200 2,000 12,136 1,045 397 4,391 317 (96) 2,115 1,864 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 $94,380 $77,907 $ 100,480 6.46% 308,725 $ 246,224 $ 315,045 2.05% Operating Expense $ 93,004 $ 99,192 $ 102,089 Total Expenses $ 258,800 $ 286,356 $ 317,513 Section 3 - Page 15 $ pg 19 05/28/2014 10:55 AM GENERAL FUND AQUATICS 001-52035-451 CAPITAL OUTLAY 2015 2015 Items Requested Approved* *Budgeted in Capital Projects Canopies - 8th Street Baby Pool, AC Play Area, Kiddie 9,000 Pool 5,000 Diving Board Replacement 12,000 Filter and Sand Replacement 10,000 Municipal Pool Repairs Roof & Ceiling 8,000 Municipal Pool Repairs and bathroom upgrades 5,000 Patch and paint pool walls and gutthers both pools 5,000 Roof for Equipment Room 8,000 Roofing & ceiling of facility 10,000 Deck resurfacing 22,000 Dehumidifier Engineering assessment 8,000 Parking lot Chip Seal 10,000 Replaster Baby Pool 15,000 Restroom equipment - stalls, lockers, dividers,etc. 10,000 Roof repair/replacement office 14,000 Solar Lighting for backyard 5,000 POS System 9,000 Total Book1 $ 160,000 $ Section 3 - Page 15 5,000 05/28/2014 10:55 AM GENERAL FUND PUBLIC WORKS ADMINISTRATION 001-54001-431 Account Description 2015 % Change 2013 Actual 150,800 11,841 11,332 14,228 19,790 866 3,680 - 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 $ 111,909 8,561 12,646 3,386 579 3,822 2,606 $ 57,931 1,437 493 4,450 6,594 2,874 294 1,875 4,087 $ 113,189 8,659 12,994 5,858 449 2,612 7,445 1.14% 0.00% 0.00% 0.00% 1.14% 2.75% 72.99% -22.34% -31.66% 185.69% 100,796 $ 143,509 $ 80,034 $ 151,206 5.36% 3,300 1,000 1,500 1,000 3,600 5,000 500 600 450 200 1,000 2,200 600 - 0.00% 100.00% -33.33% 100.00% 0.00% 20.00% 0.00% 0.00% 0.00% 0.00% 122.22% -44.13% 0.00% 0.00% 0.00% 0.00% $ 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 212,536 $ 177,827 $ 2014 Budget 2015 Requested 2012 Actual 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 Personnel Expense 2014 YTD 04/30/14 2011 Actual 888 - - - - - - - 1,500 1,043 642 4,034 4,862 669 395 71 1,058 1,181 213 477 972 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,000 3,000 5,000 500 600 450 90 1,790 2,200 600 - 229 1,771 2,066 715 168 47 458 1,665 360 1,865 - Operating Expense $ 15,462 $ 17,802 $ 14,614 $ 16,730 $ 10,388 $ 20,950 25.22% Total Expenses $ 227,998 $ 195,629 $ 115,410 $ 160,239 $ 90,421 $ 172,156 7.44% CAPITAL OUTLAY 2015 Requested Items New Barn Facility 0 Total Book1 $ 125,000 125,000 2015 Approved* $ Section 3 - Page 16 *Budgeted in Capital Projects - 05/28/2014 10:55 AM GENERAL FUND PW CONSTRUCTION 001-54018-431 Account Description Personnel Expense 1001 1004 1005 2001 2002 2004 2005 2006 2016 Salaries Salaries - Limited Sal-OT OASI State Retire Health Ins Income Protect State Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 4101 4102 4103 4104 4301 4305 5501 5801 6001 6002 6301 6302 6501 6502 6601 6699 6703 6705 170,778 69,236 1,572 17,466 23,214 22,913 1,205 14,862 $ Contractual services Utilities-Electric (City Hall) Utilites-Gas (City Hall) Utilites-Water/Sewer/San Telephone Services Auto/Equip City Hall Maintenance DOC Labor Travel/training Office supplies Operating supplies Small tools/Equipment Safety Equipment Gas/oil/lube Diesel/Oil/Lube Uniforms Construction Materials Graffiti Abatement Supplies DOC Supplies 321,246 193,680 34,985 1,404 16,473 22,821 28,197 947 13,446 $ 311,953 $ 2015 Requested 2015 % Change 187,754 3,980 154 13,710 19,746 8,830 912 10,316 21,983 $ $ 231,110 1,000 17,756 26,228 10,334 1,197 14,512 15,486 $ $ 165,108 4,220 2,572 12,490 18,823 7,215 861 9,947 15,195 $ $ 205,400 1,000 15,790 23,695 10,561 817 11,091 19,328 -11.12% 0.00% 0.00% -11.08% -9.66% 2.19% -31.79% -23.58% 24.81% 267,386 $ 317,625 $ 236,430 $ 287,680 -9.43% 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 -60.32% 3.70% -33.33% 0.00% 100.00% 100.00% 50.00% 0.00% -25.00% 0.00% 296.30% 200.00% 11.11% 0.00% 0.00% -33.33% -6.25% 0.00% 0.00% 20,122 33,794 2,801 2,148 48,654 28,317 3,028 1,896 55,482 30,152 2,490 1,829 46,569 27,000 4,500 2,500 28,489 22,262 2,387 1,193 13,546 44,319 2,937 268 1,403 2,224 603 5,894 1,168 2,491 3,341 8,567 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 4,500 10,000 20,000 2,000 1,350 1,000 450 6,000 450 2,100 3,200 4,500 8,000 2,889 16,467 15,753 345 545 754 106 5,517 2,669 1,890 144 314 5,868 Operating Expense $ 145,626 $ 155,069 $ 146,664 $ 144,119 $ 107,592 $ 126,930 -11.93% Total Expenses $ 466,872 $ 467,022 $ 414,049 $ 461,744 $ 344,022 $ 414,610 -10.21% CAPITAL OUTLAY Items Fleet Total Book1 2014 YTD 04/30/14 2011 Actual 2012 Actual 2013 Actual 2014 Budget 2015 Requested 179,000 $ 179,000 pg 17 2015 Approved* *Budgeted in GF Department 1801 179,000 $ 179,000 Section 3 - Page 17 05/28/2014 10:55 AM GENERAL FUND PUBLIC WORKS FLEET MAINTENANCE 001-54031-431 Account Description Personnel Expense 1001 1005 2001 2002 2004 2005 2006 2016 Salaries Sal-OT OASI State Retire Health Ins Income Protect State Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 4104 4105 4301 4303 5801 6001 6002 6301 6302 6401 6501 6601 Operating Expense Total Expenses 2015 % Change 2013 Actual 135,842 10,211 12,604 14,397 801 3,080 - 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 $ 136,243 1,000 10,499 15,508 6,317 707 4,540 2,206 $ 53,124 902 4,061 6,091 2,356 273 1,686 4,123 $ 95,012 1,000 7,345 11,022 4,341 378 2,902 11,652 -30.26% 0.00% -30.04% -28.93% -31.27% -46.46% -36.08% 428.20% 102,356 $ 177,019 $ 72,617 $ 133,653 -24.50% -5.38% 100.00% -18.52% 0.00% 100.00% 0.00% 0.00% 29.63% 0.00% 11.11% 100.00% -53.49% 33.33% $ 115,706 $ 2014 Budget 2015 Requested 2012 Actual $ 176,935 Contractual Services Telephone Services Utilities Auto/Equip Computer Maintenance Travel/training Office supplies Operating supplies Small tools Safety Equipment Books/Dues/Subscrip Gas/oil/lube Uniforms 2014 YTD 04/30/14 2011 Actual 487 38,580 2,246 $2,247 $1,520 6,484 96,174 4,983 86,512 4,853 86,018 6,750 4,000 3,987 2,310 21 1,351 3,674 1,685 2,084 8,031 722 140 1,261 2,392 2,588 386 800 4,087 724 71 1,105 2,727 2,606 289 275 3,292 850 1,000 900 2,700 2,500 450 1,000 4,300 1,050 85 468 1,535 882 163 1,289 892 $2,126 $550 5,500 4,000 400 1,000 900 3,500 2,500 500 2,000 2,000 1,400 $120,714 $142,453 $104,331 $26,897 $13,132 $26,376.00 -1.94% 160,029 -21.52% $ 297,649 $ 258,159 $ 206,687 $ 203,916 $ 85,748 $ CAPITAL OUTLAY 2015 Requested Items 0 Total Book1 2015 Approved - $ - *Budgeted in GF Department 1801 $ Section 3 - Page 18 - 05/28/2014 10:55 AM GENERAL FUND FIRE 001-55001-422 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2003 2004 2005 2006 2016 Salaries Temporary Limited Sal-OT OASI State Retirement State Retire/PS Health Ins Income Protect Workman's Comp Self Fund Ins Claims Personnel Expense 2011 Actual 2012 Actual 549,302 65,536 52,639 11,773 3,616 187,731 65,543 2,165 23,662 - 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 62,114 961,967 $ 1,059,881 13,554 2,829 1,619 $ Operating Expense 3001 3401 3402 4104 4105 4301 4302 4303 5301 5801 5802 6001 6002 6201 6301 6302 6303 6304 6401 6501 6601 Contract. Serv. Community Training Public Education Telephone Services Utilities Auto/equip Building Maintenance Computer Maintenance Communication Equip. Travel/training Incident Meal Money Office supplies Operating Supplies Postage Small tools Safety Equip Structural PPE Tactics and Rescue Books/dues/subscrip Gas/oil/lube Uniforms Honor Guard Uniform 6701 Construction materials 2013 Actual 2014 YTD 04/30/14 2014 Budget 50,000 12,071 4,079 272,053 22,335 2,260 44,213 71,089 547,099 71,457 10,407 3,500 249,137 21,404 1,991 40,112 62,922 $ 1,146,362 $ 1,080,108 17,118 8,292 2,739 24,624 10,814 2,875 19,888 18,102 8,370 656 4,299 1,500 5,953 4,951 442 3,066 238 3,395 349 688 15,768 7,504 238 Operating expense $ 95,308 Total Expense $ 1,057,275 $ 50,000 12,347 4,144 213,875 22,124 2,217 38,100 64,331 $ 1,008,028 $ 1,026,529 -4.96% 21,170 5,000 3,000 24,470 3,542 3,064 12,583 18,882 12,357 18,000 14,000 4,500 16,938 8,876 4,936 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 500 8,000 250 1,500 3,000 300 300 500 2,000 500 1,025 14,000 12,858 500 500 17,193 406 6,131 3,296 156 1,589 161 906 87 1,372 14,919 8,758 - 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 8.58% 0.00% 16.67% 100.00% 0.00% 14.29% 0.00% 100.00% 0.00% 11.25% 0.00% 66.67% 0.00% 0.00% 0.00% 0.00% 50.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 137,849 23.74% $ 1,164,378 -2.28% $ 1,186,224 $ 142,943 $ 1,289,305 $ 595,901 6,106 111,403 $ 1,191,511 $ $ $ $ 116,799 $ 1,124,826 $ $ $ 612,890 6,500 2015 % Change 2.85% 6.45% 0.00% 0.00% 2.29% 1.59% -21.38% -0.95% -1.92% -13.83% -9.51% 126,343 $ $ 2015 Requested pg 23 Section 3 - Page 19 Book1 05/28/2014 10:55 AM GENERAL FUND EMS 001-55052-422 Account Description Personnel Expense 1001 1003 1005 2001 2002 2003 2004 2005 2006 2016 Salaries Sal-temp Sal-OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 4104 4105 4301 4302 5301 5801 5802 6001 6002 6201 6301 6302 6401 6501 6601 2011 Actual 2012 Actual 2013 Actual 642,711 56,530 7,714 193,089 68,585 2,074 26,655 - 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 997,358 $ 1,041,365 14,123 178 2,082 53 1,002 26,312 46 138 16,670 1,996 $ Contract. Services Telephone Services Utilities Auto/equip Building Maintenance Communication Equip. Travel/training Incident Meal Money Office supplies Operating supplies (Med) Postage Small tools Safety Equip Books/dues/subscrip Gas/oil/lube Uniforms Operating Expense $ 62,600 Total Expenses $ 1,059,958 $ 2014 Budget 2015 Requested 2015 % Change 681,179 50,000 10,602 324,359 22,386 2,246 52,886 63,982 $ 547,875 107,786 8,980 287,544 15,093 1,645 44,483 59,334 $ 681,266 50,000 10,603 324,329 21,542 2,246 44,340 69,005 0.01% 0.00% 0.00% 0.01% #DIV/0! -0.01% -3.77% 0.00% -16.16% 7.85% $ 1,180,077 $ 1,207,640 $ 1,072,740 $ 1,203,333 -0.36% 1,900 7,745 11,500 7,960 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 - 400 4,750 250 3,000 42,000 300 200 150 1,800 15,000 - 29.37% 100.00% 0.00% 100.00% 0.00% 0.00% -13.64% 0.00% 0.00% 20.00% 0.00% 0.00% 0.00% 16.13% 0.00% 0.00% 89,828 13.92% $ 1,293,161 0.52% 77,601 $ 1,118,967 $ 88,749 $ 1,268,826 $ 2014 YTD 04/30/14 6,801 6,186 103 6,617 47,796 44 57 87 50 13,040 81 6,000 400 5,500 250 3,000 35,000 300 200 150 1,550 15,000 $ 78,850 $ 1,286,490 $ 88,820 $ 1,161,560 6,000 $ pg 24 Section 3 - Page 20 Book1 05/28/2014 10:55 AM GENERAL FUND EMS 001-55052-422 CAPITAL OUTLAY 2015 Items Requested Multi Use Vehicle (pull Haz-Mat, air and light Trailer)125,000 Fire pumper 450,000 Fire Hose 8,000 Office Furniture 6,000 New Roof 20,000 Exterior Wall repair and paint 7,000 New Fire Station 6,000,000 Fire Chief Car 30,000 Radio Communication replacement 323,398 TOTAL $ 6,969,398 2015 Approved* *Budgeted in Capital Projects 8,000 5,000 7,000 - $ 20,000 Section 3 - Page 20 Book1 05/28/2014 10:55 AM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 Account Description Personnel Expense 1001 1002 1005 1006 2001 2002 2003 2004 2005 2006 2016 Salaries Salaries-Civilian Sal-OT Sal - Reimbursed OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 4104 4105 4301 4302 4303 4303 5501 5801 6001 6002 6201 6401 6501 6601 8108 2011 Actual 2012 Actual 155,691 37,597 1,519 12,397 11,424 4,661 14,618 19,385 605 5,213 $ Contract. Serv. Telephone Services Utilities Auto/equip Building Maintenance Computer Maintenance Auction-related expenses DOC Labor Travel/training Office supplies Operating supplies Postage Books/dues/subscrip Gas/oil/lube Uniforms Explorer Program 263,111 2013 Actual 108,226 38,068 484 11,584 10,845 4,993 (372) 14,599 338 3,781 $ 192,546 $ 46,392 38,570 327 13,648 6,907 5,719 1,565 281 1,403 9,382 $ 124,195 $ 43,158 38,337 - $ 3,559 4,332 17,030 1,693 371 1,929 7,787 118,196 $ 2015 Requested 32,885 219 11,809 3,080 5,067 927 206 108 12,592 $ 66,893 $ 72,106 59,752 82,827 91,484 82,842 40,981 36,886 7,126 12,810 35,017 13,776 35,000 500 7,000 25,690 911 5,588 1,993 2,842 2,143 9,165 13,873 1,428 975 3,589 965 - 13,877 2,712 2,193 10,527 8,538 958 1,112 2,076 1,003 - 12,099 1,898 1,473 12,661 16,725 1,536 1,286 1,697 917 - 1,000 5,500 8,000 11,650 1,000 1,210 2,000 760 1,000 335 3,129 10,318 3,918 861 1,542 2,456 404 - 2015 % Change 86,316 38,337 18,164 5,574 6,486 35,113 2,163 347 3,233 14,931 100.00% 0.00% 0.00% 0.00% 56.63% 49.73% 106.18% 27.78% -6.53% 210,664 78.23% 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 -0.31% 100.00% 0.00% 100.00% 0.00% 100.00% 0.00% 0.00% 1.82% 0.00% 0.00% 75.00% 240.83% 0.00% 0.00% 0.00% pg 25 91.74% Operating Expense $ 157,188 $ 152,443 $ 181,912 $ 166,104 $ 137,992 $ 201,834 21.51% Total Expenses $ 420,299 $ 344,989 $ 306,107 $ 284,300 $ 204,885 $ 412,498 45.09% Section 3 - Page 21 Book1 2014 YTD 04/30/14 2014 Budget 05/28/2014 10:55 AM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 CAPITAL OUTLAY 2015 Items Requested 2 1/2 ton trucks for Humane 50,000 2 replacement vehicles 1 patrol 1 invest 80,000 2 replacement vehicles invest 80,000 2 HVAC for west side 16,000 Total $ 226,000 2015 Approved* $ 80,000 *Budgeted in RICO 80,000 *Budgeted in GF Department 1801 16,000 *Budgeted in Capital Projects 176,000 Section 3 - Page 21 Book1 05/28/2014 10:55 AM GENERAL FUND POLICE OPERATIONS 001-56041-421 Account Description Personnel Expense 1001 1002 1005 1006 2001 2002 2003 2004 2205 2006 2016 Salaries Salaries-Civilian Sal-OT Sal - Reimbursed OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp Self Fund Ins Claims Personnel Expense Operating Expense 4301 4302 5801 6501 6601 Book1 2014 YTD 04/30/14 2015 Requested 2015 % Change pg 26 2011 Actual 2012 Actual 2013 Actual 2014 Budget 1,196,300 52,264 84,110 271,957 24,005 5,325 365,929 135,620 4,527 52,239 - 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,182,215 19,136 70,000 280,000 23,681 2,162 579,627 37,596 4,246 65,854 115,118 $ 935,316 15,824 53,796 221,119 17,897 1,790 425,175 33,900 3,067 48,433 110,880 $ 1,175,031 18,780 70,000 298,784 23,822 2,156 581,088 37,325 4,222 56,239 144,569 -0.61% -1.86% 0.00% 6.71% 0.60% -0.30% 0.25% -0.72% -0.57% -14.60% 25.58% $ 2,192,277 $ 2,065,466 $ 2,310,945 $ 2,379,636 $ 1,867,198 $ 2,412,014 1.36% 22,500 7,087 90,289 22,205 1 4,656 86,668 20,787 20,559 6,050 63,738 16,895 22,500 141 3,363 83,078 9,671 2,500 75,000 18,950 100.00% 0.00% 0.00% -5.66% 0.21% 118,950 -3.61% $ 2,530,964 1.12% Auto/equip Maintenance Cost Travel/training Gas/oil/lube Uniforms Operating Expense $ 96,254 Total Expenses $ 2,288,530 $ 119,581 $ 2,185,047 $ 112,112 $ 2,423,058 Section 3 - Page 22 2,500 79,500 18,910 $ 123,410 $ 2,503,046 $ 107,242 $ 1,974,440 $ 05/28/2014 10:55 AM GENERAL FUND POLICE SUPPORT 001-56071-421 Account Description Personnel Expense 1001 1002 1005 1006 2001 2002 2003 2004 2005 2006 2016 Salaries Salaries-Civil Sal-OT Sal - Reimbursed OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp Self Fund Ins Claims Operating Expense 4301 5801 6501 6601 Book1 2011 Actual 2012 Actual 2013 Actual 376,811 299,809 80,091 106,388 31,783 33,698 140,133 85,955 3,169 16,803 - 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 $ 1,174,639 $ 1,453,050 $ 1,560,069 $ 1,492,729 3,699 16,293 2,767 2,435 27,196 8,599 4,032 28,840 9,027 5,000 2,000 18,000 9,440 Auto/equip Travel/training Gas/oil/lube Uniforms Operating Expense $ 22,759 Total Expenses $ 1,197,398 $ 38,230 $ 1,491,279 $ 41,899 $ 1,601,968 Section 3 - Page 23 2014 YTD 04/30/14 2014 Budget $ $ 478,297 347,190 45,000 120,000 46,118 39,233 250,369 31,281 3,350 29,655 102,236 34,440 $ 1,527,169 $ 0.64% 0.54% 0.00% 143.00% -10.33% 2.14% 31.40% -5.63% -12.21% 6.08% 2.17% $ 1,375,770 $ 1,745,829 16.96% 4,189 1,384 21,815 7,519 5,000 2,000 18,000 9,440 0.00% 0.00% 0.00% 0.00% 34,440 0.00% $ 1,780,269 16.57% 34,906 $ 1,410,676 $ 2015 % Change 481,370 349,075 45,000 291,601 41,355 40,074 328,985 29,520 2,941 31,459 104,450 $ 410,782 294,896 27,645 200,802 34,496 41,317 218,496 23,986 3,021 24,840 95,489 2015 Requested $ pg 27 05/28/2014 10:55 AM GENERAL FUND POLICE HUMANE 001-56091-421 Account Description 2011 Actual 2012 Actual 2013 Actual 2014 Budget 69,178 2,518 65,353 12,901 3,085 5,239 6,940 7,892 441 1,298 - 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 62,667 25,301 1,000 6,806 10,053 3,436 387 2,158 10,156 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 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 Book1 96,591 $ 107,371 $ 108,516 $ 121,965 2014 YTD 02/28/14 2015 Requested 53,903 19,266 3,170 5,405 8,613 2,864 342 1,772 9,653 $ 104,988 40,020 42,200 42,017 41,720 32,353 1,679 1,827 1,629 1,500 1,500 901 622 890 4,453 3,188 115 1,127 270 5,821 2,982 712 586 5,540 3,079 918 500 4,500 35 2,500 690 586 3,329 2,753 686 $ 2015 % Change 62,667 25,301 1,000 6,806 10,214 3,321 280 2,102 10,257 0.00% 0.00% 0.00% 0.00% 0.00% 1.59% -3.36% -27.58% -2.62% 0.99% 121,947 -0.01% 39,300 1,350 1,500 1,500 500 1,200 500 4,900 35 2,500 690 -5.80% 100.00% 0.00% 0.00% 100.00% 100.00% 0.00% 8.89% 0.00% 0.00% 0.00% Operating Expense $ 50,345 $ 54,939 $ 53,769 $ 52,945 $ 41,230 $ 53,975 1.95% Total Expenses $ 146,935 $ 162,310 $ 162,285 $ 174,910 $ 146,218 $ 175,922 0.58% Section 3 - Page 24 05/28/2014 10:55 AM GENERAL FUND CALL CENTER 001-57081-419 Account Description Personnel Expense 1001 1004 1005 2001 2002 2004 2005 2006 2016 Salaries Salaries - Limited Salaries O/T OASI State Retire Health Insurance Income Protect State Comp Self Fund Ins Claims Personnel Expense Operating Expense 3001 4105 4302 5201 6002 6501 6502 6701 7831 8512 8901 Book1 2011 Actual 2012 Actual - Contract Serv Utilities Building Maintenance Liability Insurance Operating Supplies Gas/Oil/Lube Diesel/Oil Construction Materials IT Equipment Grant Match Depreciation - 2014 Budget 4,060 3,980 615 875 239 29 311 284 8,510 651 962 581 44 401 593 0 4,304 34 330 437 9 141 - - $ 2013 Actual $ 5,255 $ 10,394 77,404 20,255 20,772 1,058 3,592 38,016 9,344 20,320 592 3,759 22,741 8,872 17,785 829 - - - - $ 11,742 2014 YTD 04/30/14 2015 Requested 2015 % Change 8,510 651 977 606 34 355 698 0.00% 0.00% 0.00% 0.00% 1.59% 4.31% -23.21% -11.31% 17.67% $ 11,831 0.76% -20.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -5.74% 7,270 25 558 823 484 38 324 632 $ 20,000 11,000 21,300 100 4,000 - 10,154 Operating Expense $ 123,081 $ 72,031 $ 50,227 $ 56,400 $ 37,664 $ 16,000 11,000 21,300 100 4,000 52,400 Total Expenses $ 123,081 $ 77,286 $ 60,620 $ 68,142 $ 47,817 $ 64,231 Section 3 - Page 25 14,759 5,965 14,946 1,993.86 - pg 37 -7.09% 05/28/2014 10:55 AM GENERAL FUND CAPITAL EXPENDITURES 001-51801-419 Account Description 7701 7702 7703 7704 7705 7706 7707 7708 7711 7712 7713 7714 7716 7717 7718 7719 7720 7721 7723 Book1 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 2011 Actual 2012 Actual 17 53995 45020 0 0 2261 4695 10998 0 6287 66753 0 0 97032 0 0 2013 Actual 0 0 75399 0 0 0 70732 212231 0 32859 6616 0 0 0 0 0 2015 2014 YTD 2015 Requested 2014 Budget 04/30/14 Requested % Change 531 20,413 7,649 1,100,060 23,479 7,400 - 65,000 173,000 10,000 7,000 160,000 20,799 141,564 1,963 10,830 - - - $ 287,058 $ 397,838 $ 1,334,688 Section 3 - Page 27 2,462 52,563 404 60,000 89,819 - 80,000 392,746 - - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -100.00% -53.76% 0.00% -100.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 145.47% 0.00% 0.00% 0.00% 415,000 $ 253,239 $ 472,746 13.91% 47,992 $ 05/28/2014 10:55 AM SPECIAL REVENUE FUNDS SUMMARY EXPENDITURES 2014 Budget Book1 REVENUES 2015 Budgeted Difference 2015 Budget 2015 Budgeted % Change 2014 Comparison of Revenues VARIANCE 2015 Revenues 2015 Rev vs. Exp H. U. R. F. $ 1,196,303 $ 1,269,351 $ 73,048 6.11% $ 1,196,303 $ 1,269,351 $ (0) LTAF $ - $ - $ - 0.00% $ - $ - $ - CAPITAL PROJECTS $ 670,000 $ 1,697,000 $ 1,027,000 153.28% $ 670,000 $ 613,000 $ DEBT FUND $ 1,563,854 $ 1,354,235 $ (209,620) -13.40% $ 1,563,854 $ 1,354,235 $ - MPC FUND $ 486,806 $ 486,450 $ (356) -0.07% $ 486,806 $ 486,450 $ - RICO $ 210,000 $ 158,000 $ (52,000) -24.76% $ 210,000 $ 158,000 $ - JCEF $ 18,572 $ 100,840 $ 82,268 100.00% $ 10,500 $ 45,150 $ GRANTS $ 5,108,376 $ 5,523,258 $ 414,882 8.12% $ 5,108,376 $ 5,523,258 $ HOUSING $ 283,071 $ 280,574 $ -0.88% $ 283,071 $ 276,574 $ (4,000) GRAND TOTALS $ 9,536,983 $ 10,869,709 $ 13.97% $ 9,528,911 $ 9,726,019 $ (1,143,690) (2,497) 1,332,726 Section 4 - Page 1 (1,084,000) (55,690) - 05/28/2014 10:55 AM HIGHWAY USERS REVENUE FUND 101-54041-433 Account Description Personnel Expense 1001 1004 1005 2001 2002 2004 2005 2006 2007 2008 2016 Salaries Sal-Limited Sal-OT OASI State Retire Health Ins Income Protect State Comp Unemployment Ins. HR Processing Self-funding Ins Claims/fees 387,427 11,415 3,697 28,351 38,676 56,710 2,383 22,402 204 - Personnel Expense 551,265 Operating Expense 3001 3002 4104 4105 4107 4301 4311 4312 4703 5201 5801 6002 6301 6302 6501 6502 6601 6701 6702 6704 Book1 Contractual serv Auditor Telephone Utilities St. Lts-Electric/O&M Auto/Equip Heavy Equipment Repair Asphalt Plant Repairs Lease/Purchase Paymnt Insurance-Liability Travel/training Operating supplies Small tools Safety Equipment Gas/oil/lube Diesel/Oil/Lube Uniforms Construction material Signage Constr. Material Sales 2011 Actual $ 12,404 2,700 1,560 59,046 189,789 6,640 28,846 6,622 9,524 19,804 455 3,005 598 283 27,366 30,164 2,222 257,289 12,703 - 2014 YTD 04/30/14 2015 % Change 2013 Actual 421,040 4,760 29,936 42,365 62,949 1,871 25,431 694 - 360,935 2,536 26,000 37,721 14,298 1,737 25,870 384 46,996 $ 301,403 5,000 23,440 34,624 11,977 1,570 25,250 2,000 1,000 34,165 $ 262,697 2,807 18,812 29,977 10,444 1,387 20,971 123 43,302 $ 318,448 3,000 24,591 36,902 11,372 1,268 24,654 1,000 1,000 45,701 5.66% 0.00% -40.00% 4.91% 6.58% -5.05% -19.26% -2.36% -50.00% 0.00% 33.77% 516,477 $ 440,428 $ 390,520 $ 467,935 6.25% 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 -0.09% 0.00% -25.00% 0.00% 0.00% 50.00% -25.00% -20.00% #DIV/0! 0.00% 0.00% 0.00% 200.00% 76.47% -30.00% -25.00% 0.00% 32.09% 66.67% 0.00% $ 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 $ 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 - Section 4 - Page 2 2014 Budget 2015 Requested 2012 Actual 30,549 2,409 2,400 50,000 180,000 10,000 20,000 10,000 28,800 500 1,000 500 850 20,000 20,000 2,800 135,879 6,000 20,000 10,405 2,409 2,166 38,360 132,670 7,533 4,082 19,181 25,000 235 14,859 332 10,372 9,313 2,676 147,488 5,849 56,170 pg 29 05/28/2014 10:55 AM HIGHWAY USERS REVENUE FUND 101-54041-433 Account 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 2011 Actual - 2012 Actual 646 - 2013 Actual - 671,020 514,531 445,326 41,599 40,997 213,610 255,209 162,910 203,907 45,289 74,651 160,415 2,485 282,840 162,269 14,425 214,188 $ 1,477,494 $ 1,307,482 $ 1,244,643 $ 1,196,303 2015 Requested 2015 Approved $ 2014 YTD 04/30/14 2014 Budget $ 541,687 $ 37,494 $ 489,102 2015 Requested 15,000 $ 2015 % Change 0.00% 0.00% 592,310 9.35% 36,419 133,872 12,021 182,312 34,985 -6.69% 160,529 13,592 209,106 -1.07% 100.00% -2.37% 1,061,934 $ 1,269,351 6.11% pg 29 CAPITAL OUTLAY Items 2 Connex Boxes for Eq & Tool Storage 0 0 Total Book1 $ 15,000 15,000 $ 15,000 15,000 Section 4 - Page 2 05/28/2014 10:55 AM LOCAL TRANSPORATION ASSISTANCE FUND (LTAF) 102-54042-433 Account Description Operating Expense 5231 5235 6701 9901 9902 9906 Cultural Purposes LTAF II Grant Construction material Transfer to GF Transfer to HURF Transfer to Airport Total Expense Book1 2014 YTD 04/30/14 2015 Requested 2015 % Change 2011 Actual 2012 Actual 2013 Actual 2014 Budget 28,000 - 16,589 26,001 83,997 - 211,937 - - - - - - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% $ 28,000 $ 126,587 $ 211,937 Section 4 - Page 3 $ - $ - $ pg 31 05/28/2014 10:55 AM CAPITAL PROJECTS FUND 103-51081-419 Account Description 7610 7626 7628 7631 7632 8900 9915 9917 2012 Actual 41,670 276,017 65,754 449,782 1,042,929 - - 127,181 60,000 383,442 $ 1,679,891 3rd Street Extension Government Plaza City Hall Improvements Port of Entry Health Dept Bldg Impr Capital Projects Transfer to Grants Transfer to Debt Serv Total Expenses Book1 2011 Actual $ 2013 Actual 47,396 14,716 64,133 12,831 64,099 $ 203,174 Section 4 - Page 4 2014 YTD 04/30/14 2014 Budget 120,000 2015 Requested 15,940 44,096 3,545 75,000 550,000 670,000 - 0.00% 0.00% 0.00% -37.50% 0.00% 194.91% 0.00% 0.00% 1,697,000 153.28% 1,622,000 $ 2015 % Change $ 63,581 $ pg 33 05/28/2014 10:55 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2014-2015 DEPT AMOUNT REQUESTED ITEM/PROJECT AMOUNT RECOMMENDED TYPE FUNDING SOURCE Administration MIS Fire Fire Police Visitor Center Visitor Center Cemetery Parks Aquatics Library Library City Hall Bathroom Renovation 1 Generator Office Furniture Exterior Wall repair and paint 2 HVAC for west side Facility Upgrades for Social Events Doors Restroom Upgrade Lighting Improvements all parks AC & 8th Street Pool Canopies DVD/CD Repair and Cleaner Machine RFID System Wand $25,000 $100,000 $6,000 $7,000 $16,000 $6,000 $5,000 $6,000 $90,000 $9,000 $5,000 $5,500 $280,500 $25,000 $100,000 $5,000 $7,000 $16,000 $5,000 $5,000 $6,000 $35,500 $5,000 $5,000 $5,500 $220,000 Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Fire Cemetery Cemetery Various GF Dpts Fire Hose 1 Ride Mower Gator Vehicles $8,000 $12,000 $9,000 $179,000 $208,000 $8,000 $12,000 $9,000 $179,000 $208,000 Fleet Fleet Fleet Fleet Capital Projects Capital Projects Capital Projects Capital Projects Public Works Barn Facility General Gov Port of Entry Various GF Dpts Council Directed Projects $125,000 $75,000 $404,000 $604,000 $125,000 Other Capital Capital Projects $75,000 Other Capital Capital Projects $404,000 Other Capital Capital Projects $604,000 Streets $665,000 Street Improvements $665,000 Streets Capital Projects . TOTAL Book1 $1,757,500 Section 7 - Page 57 $1,697,000 05/28/2014 10:55 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2014-2015 DEPT AMOUNT RECOMMENDED TYPE FUNDING SOURCE Administration MIS Fire Fire Police Visitor Center Visitor Center Cemetery Parks Aquatics Library Library Transit Transit Transit Transit Court/Admin City Hall Bathroom Renovation 1 Generator Office Furniture Exterior Wall repair and paint 2 HVAC for west side Facility Upgrades for Social Events Doors Restroom Upgrade Lighting Improvements all parks AC & 8th Street Pool Canopies DVD/CD Repair and Cleaner Machine RFID System Wand Bay & Lift 5 PCs w/ software licenses 12 Bus stops 14 Benches Chambers Upgrades $25,000 $100,000 $6,000 $7,000 $16,000 $6,000 $5,000 $6,000 $90,000 $9,000 $5,000 $5,500 $53,820 $6,900 $52,676 $7,350 $81,000 $482,246 $25,000 $100,000 $5,000 $7,000 $16,000 $5,000 $5,000 $6,000 $35,500 $5,000 $5,000 $5,500 $53,820 $6,900 $52,676 $7,350 $81,000 $421,746 Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Facilities Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Capital Projects Transit Grant Transit Grant Transit Grant Transit Grant JCEF/GF Fire Cemetery Cemetery Various GF Dpts Police Police Transit Fire Hose 1 Ride Mower Gator Vehicles 1 Patrol 1 Investigation Vehicle 2 Patrol Vehicles 2 36 Passenger Buses $8,000 $12,000 $9,000 $179,000 $80,000 $80,000 $272,000 $640,000 $8,000 $12,000 $9,000 $179,000 $80,000 $80,000 $272,000 $640,000 Fleet Fleet Fleet Fleet Fleet Fleet Fleet Capital Projects Capital Projects Capital Projects Capital Projects RICO Police Auction Transit Grant Public Works General Gov Various GF Dpts Barn Facility Port of Entry Council Directed Projects $125,000 $75,000 $404,000 $604,000 $125,000 Other Capital Capital Projects $75,000 Other Capital Capital Projects $404,000 Other Capital Capital Projects $604,000 Streets Street Improvements $665,000 $665,000 Streets TOTAL Book1 AMOUNT REQUESTED ITEM/PROJECT $2,391,246 Section 7 - Page 58 Capital Projects $2,330,746 05/28/2014 10:55 AM DEBT SERVICE FUND 108-51547-419 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 2011 Actual 2012 Actual 26,877 30,159 264,283 251,024 40,153 41,644 264,283 233,775 80,000 - 60,000 - $ 652,341 543,575 558,201 $1,101,776 Total Leases & Call Center $ 639,855 2013 Actual 2014 Budget 11,184 264,283 236,264 9,792 40,000 - 22,369 66,411 232,275 170,586 40,000 236,346 $ 561,523 $ 767,987 2014 YTD 04/30/14 2015 Requested 22,369 281,941 57,488 170,586 40,000 $ 572,383 $ 2015 % Change 22,369 235,175 170,586 40,000 215,530 0.00% 0.00% 0.00% -100.00% 1.25% 0.00% 0.00% -8.81% 683,660 -10.98% 521,870 569,440 $1,091,310 500,878 595,927 $1,096,805 693,905 $693,905 161,863 $161,863 670,575 $670,575 0.00% -3.36% -3.36% $1,731,165 $1,658,328 $1,461,892 $734,246 $1,354,235 -7.36% - -100.00% $ 1,354,235 100.00% pg 33 Transfers 9904 Transfer to Capital Projects $ Total Debt Service Fund Bond Payments 4701 MPC Bond Payment TOTAL DEBT SERVICE Book1 101,962 0 $ $ 1,563,854 $ 486,076 $ 484,456 1,124,311 $ 486,106 1,047,629 Section 4 - Page 5 $ 486,806 1,254,793 $734,246 $ 15,903 588,286 $ 486,450 -0.07% 1,170,110 -6.75% 05/28/2014 10:55 AM RICO 104-56003-421 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 2014 YTD 04/30/14 2011 Actual 2012 Actual 2013 Actual 2014 Budget 843 13,529 633 3,921 24,816 36,470 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 1,010 19,500 - 1,584 21,000 - 8,412 18,000 - $ 100,721 $ 215,771 $ 185,845 $ $ 2015 Requested 0 1,000 1,000 10,000 $ 80,000 78,000 20,000 173 2,250 0 15,744 $ 65,325 2,996 19,789 7,794 20,000 - 40,106 9,662 - 210,000 $ 163,839 *** $ 0 1,000 1,000 10,000 80,000 20,000 20,000 6,000 20,000 - 158,000 2015 % Change pg 90 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -74.36% 0.00% 100.00% 0.00% 0.00% 0.00% -24.76% ***Budgeted expenses will only be expended if the money is available Section 4 - Page 6 05/28/201410:55 AM JCEF 105-51603-412 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 2014 YTD 04/30/14 2011 Actual 2012 Actual 2013 Actual 2014 Budget $ $ 1,098 8,664 220 1,632 1,580 13,524 112 - - 9,982 $ $ 16,848 $ 1,638 11,952 381 $ - $ 13,971 Section 4 - Page 7 $ 2,000 14,072 2,500 1,316 154 10,754 126 - - 18,572 $ 2015 Requested $ 12,351 $ 2,000 15,340 2,500 81,000 - $ 100,840 2015 % Change pg 90 0.00% 0.00% 0.00% 9.01% 0.00% 0.00% 0.00% 442.97% 05/28/201410:55 AM GRANTS 106 Account Description 2011 Actual 2012 Actual Housing & Comm Development Fire Police Public Works Library Transfer to GF Transfer to Housing Total Expenses Grants Requiring Match Book1 2013 Actual 152,578 6,038 47,988 675,104 181 111,231 40,188 $ - $ 1,033,309 317,834 11,700 56,443 286,171 882 200,655 23,535 $ 897,219 2014 YTD 04/30/14 2014 Budget $ 2015 Requested 2015 % Change 919,464 32,025 108,369 4,047,518 1,000 3,232 62,196 172,947 135,049 326,750 109,301 187,650 4,821,822 77,735 - - - -64.46% 241.30% 73.16% 19.13% 7673.50% 0.00% 0.00% 5,523,258 8.12% 5,108,376 $ 373,424 $ pg 33 Match Amount AFG - Equipment ADOT Chino Road ADOT RR Depot Fountains HSIP Sign Replacement ADOT Airport Security Fencing Cochise Community Foundation $ 1,584.45 $ 150,574.00 $ 4,000.00 $ $ 15,000.00 $ 2,313.00 TOTAL MATCH $ 173,471.45 Section 4 - Page 8 05/28/2014 10:55 AM HOUSING 501-51101-463 PERSONNEL EXPENSE Account Description 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2016 Salaries Salaries - Temp Salaries - Ltd Salaries-Overtime O.A.S.I. Retirement-State Health Ins Income Protect Ins Workman's Comp Unemployment Insurance Self-funding Ins Claims/fees 7402 Capital Outlay Total Expenses 2014 YTD 04/30/14 2011 Actual 2012 Actual 2013 Actual 2014 Budget 120,764 29,827 68,619 728 15,897 18,168 12,705 1,060 4,050 - 148,383 16,697 78,960 821 17,377 22,679 25,811 885 4,833 2,160 - 148,815 $ 13,545 $ 62,236 1,067 15,958 23,903 (34) 927 6,100 (25) 23,054 $15,937 $10,972 $3,004 $ 287,754 $ 329,580 $ 298,550 2015 Requested 2015 Approved $ 130,371 13,373 58,236 15,451 22,468 7,106 1,007 6,325 22,735 119,755 12,438 50,077 1,202 12,983 20,131 3,484 822 5,272 23,757 $6,000 $0 283,071 $ $ $ 249,920 2015 Requested $ $ $ 141,966 13,373 49,388 15,662 23,123 4,823 776 5,731 2015 % Change 21,735 8.89% 0.00% -15.19% 0.00% 1.36% 2.91% -32.13% -22.98% -9.39% 0.00% -4.40% $4,000 100.00% 280,574 -0.88% pg 90 CAPITAL OUTLAY Front Counter / Glass replacement Designated File/ storage space Total $ 4,000 1,500 5,500 $ Funded from Special Projects 4,000 4,000 Section 4 - Page 9 05/28/201410:55 AM ENTERPRISE FUNDS SUMMARY EXPENSES 2014 Budget REVENUES 2015 Budgeted Difference 2015 Budget SANITATION $ 1,273,748 $ 1,201,200 $ (72,548) WATER WATER OFFICE WATER FIELD $ $ 254,258 1,233,094 $ $ 262,989 1,337,135 $ $ 8,731 104,041 WATER CAPITAL REINVESTMENT WATER TOTAL $ $ 567,648 2,055,000 $ $ 513,542 2,113,666 $ $ (54,106) 58,665 WASTE WATER TOTAL SEWER CAPITAL REINVESTMENT $ $ $ 1,521,342 329,658 1,851,000 $ $ $ 1,640,313 1,204,687 2,845,000 $ $ $ AIRPORT $ 137,302 $ 151,338 GOLF GOLF COURSE BAR & RESTAURANT $ $ 323,070 88,641 $ $ 100,000 - $ 411,711 $ 100,000 $ 5,728,762 $ 6,411,204 GRAND TOTALS 2015 Budgeted % Change 2014 Comparison of Revenues -5.70% $ VARIANCE 2015 Revenues 2015 Rev vs. Exp 1,230,100 $ 1,201,200 $ 0 -9.53% 2.85% $ 2,055,000 $ 2,113,666 $ 0 118,971 875,029 994,000 7.82% 265.44% 53.70% $ 1,851,000 $ 2,845,000 $ (0) $ 14,036 10.22% $ 137,302 $ 151,338 $ - $ (311,711) -96.48% $ 411,711 $ 100,000 $ - $ 682,442 11.91% $ 5,685,113 $ 6,411,204 $ 0 3.43% 8.44% 05/28/2014 10:55 AM Book1 Section 5 - Page 1 WATER OFFICE 410-54051-432 Account Description 47,577 3,391 4,550 6,067 282 84 - 49,095 3,463 4,814 6,561 220 87 - 48,706 153 3,536 5,321 3,072 248 110 4,263 $ 50,350 500 3,890 5,746 2,880 261 129 5,227 $ 42,794 841 3,134 4,923 2,037 229 132 4,946 $ 51,144 500 3,951 5,929 2,809 204 115 6,524 1.58% 0.00% 1.56% 3.18% -2.49% -22.13% -10.61% 24.81% 65,410 $ 68,984 $ 59,036 $ 71,175 3.18% 38,076 4,800 500 7,000 300 34,200 2,350 22,300 40,706 2.42% 3.45% 0.00% 0.00% 0.00% 0.00% 0.00% -6.88% 11.02% 150,232 2.35% 6,400 5,000 30,182 0.00% 0.00% -9.89% Operating Expense 3001 Contractual services 3002 Auditing Services 4104 Telephone 4105 Utilities 4303 Computer Maintenance 5201 Insurance-Liability 5801 Travel/training 6001 Office Supplies 6201 Postage Operating Expense 2015 % Change 2013 Actual $ 61,950 $ 43,682 4,500 72 7,292 38,604 110 16,811 40,877 $ 7401 Capital Outlay 8001 Bad Debt Expense 9901 Gen. Fund Reimb. 151,949 64,240 $ 43,858 4,595 94 6,633 527 45,984 1,760 15,914 30,757 $ 36,263 26,570 150,121 2014 Budget 2015 Requested 2012 Actual 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 Personnel Expense 2014 YTD 04/30/14 2011 Actual 36,972 4,540 129 6,913 26,797 26 16,393 30,717 $ 1,789 33,257 28,242 122,487 37,176 4,640 500 7,000 300 34,200 2,350 23,948 36,666 $ 12,381 19,174 31,199 146,780 38,092 4,598 62 5,250 437 34,783 181 11,300 30,787 $ 5,000 33,494 125,491 $ 6,450 31,476 Other $ 62,833 $ 63,289 $ 62,753 $ 38,494 $ 37,926 $ 41,582 8.02% Total Expenses $ 276,732 $ 277,649 $ 250,650 $ 254,258 $ 222,453 $ 262,989 3.43% pg 83 CAPITAL OUTLAY 2015 Requested 4 Scanners Total Book1 $ 6,400 6,400 $ 2015 Approved 6,400 6,400 Section 5 - Page 2 05/28/2014 10:55 AM WATER FIELD 410-54053-432 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2008 2016 Salaries Salaries-Temporary Salaries-Limited Sal-OT OASI State Retire Health Ins Income Protect State Comp Unemployment Ins. HR Processing Self-Fundung Ins Claims/Fees Personnel Expense Operating Expense 3001 4104 4105 4301 4302 4303 4321 4322 4323 4703 5202 5401 5801 6001 6002 6301 6302 6401 6501 6502 6601 6701 Book1 2015 % Change 2013 Actual 195,096 62 30,842 12,024 17,003 22,304 27,271 1,224 6,517 54 - 285,339 965 4,304 9,854 20,129 27,423 35,870 1,197 7,223 7,469 232 - 265,156 3,980 11,109 20,579 30,637 17,773 1,389 9,683 1,214 24,258 $ 301,400 10,000 23,822 35,188 16,985 1,582 10,979 3,000 1,000 25,952 $ 240,143 92 6,656 18,332 27,880 13,767 1,263 8,390 267 24,175 $ 302,028 10,000 23,870 35,821 16,806 1,211 9,416 3,000 1,000 29,149 0.21% 0.00% 0.00% 0.00% 0.20% 1.80% -1.05% -23.46% -14.23% 0.00% 0.00% 12.32% 385,778 $ 429,908 $ 340,967 $ 432,301 0.56% 31,150 5,000 290,000 9,000 1,500 130,000 60,000 35,000 99,098 2,000 1,500 3,000 1,000 1,200 500 1,500 1,300 20,000 3,500 2,450 - 3,154 3,822 313,101 4,234 1,394 21,279 39,490 21,461 86,631 1,011 2,359 1,221 328 463 411 398 15,514 279 2,716 - 698,698 $ 519,267 Contractual services Telephone Utilities Auto/Equip Building Maintenance Computer Maintenance Water Production Maintenance Water Distribution Maintenance Water Quality Maintenance Lease/Purchase Bldg/Equip Debt Service Insurance Claims Advertising/Printing Travel/training Office supplies Operating supplies Small tools Safety Equipment Books/Dues/Subscrip Gas/oil/lube Diesel/Oil/Lube Uniforms Construction material Operating Expense 2015 Requested 2012 Actual $ 312,396 $ 10,938 3,072 341,866 6,440 145 5 30,176 50,886 29,228 - 501,123 $ 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 - 831 982 2,731 463 614 155 859 18,860 1,546 1,325 $ 400,005 $ 527,440 2014 Budget 2014 YTD 04/30/14 2011 Actual 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 $ Section 5 - Page 3 545,711 $ 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 $ 808,398 pg 84 -68.38% 0.00% 13.79% 107.97% -22.22% 0.00% -33.33% 0.00% 6.67% 14.29% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -5.00% -71.43% 0.00% 0.00% 15.70% 05/28/2014 10:55 AM WATER FIELD 410-54053-432 Account 7401 7826 7997 8901 9901 9915 9917 Description Capital Outlay CIP Impact Fees CONTRA Interest Depreciation Transfer to GF Transfer to Grants Transfer to Debt Service 2011 Actual 21,662 - 2012 Actual 32,903 - 327,014 9,524 - 383,076 13,151 18,456 - 2013 Actual 2014 Budget 5,810 30,000 (33,653) 430,217 22,248 2,485 52,240 Total Capital Outlay $ 447,586 $ Total Expenses $ 1,171,719 358,200 $ 404,859 $ 1,375,030 $ 1,336,348 2015 Requested 2015 Approved $ 104,488 $ 1,233,094 2014 YTD 04/30/14 29,921 - 2015 Requested 15,000 - - 33,359 43,533 48,077 2015 % Change 100.00% 0.00% 0.00% 49.94% 0.00% 0.00% 0.00% 96,436 -7.71% $ 1,337,135 8.44% $ 73,454 $ 933,688 $ pg 84 CAPITAL OUTLAY Items 1 Connex box Safety Barricades New Barn Facility Total Book1 $ 10,000 5,000 125,000 140,000 $ Section 5 - Page 3 10,000 5,000 15,000 05/28/2014 10:55 AM Water Capital Reinvestment 410-54055-432 Account Description 2011 Actual 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 Personnel Expense 7401 7802 7809 7810 7811 7818 7820 7821 7822 7824 Book1 $ 111,019 7,394 1,967 8,508 10,653 9,407 461 2,895 - $ 152,304 0 $ Operating Expense 3001 Contractual Services 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 2012 Actual 0 2013 Actual $ 45 227 89 27,719 $ 28,079 Water CIP Capital Outlay SCADA Control System 3rd. St. Water Line Extension 70,567 Misc. Projects-Master Plan Rehabilitation Reservoir Fairview Water (BECC) Well 16 Equiping (Arsenic Compliance) 52,255 Rehab Existing Wells Arsenic Compliance 300K Gallon Elevated Tanks-Rehab 216,558 $ 81,007 1,800 6,335 9,357 4,184 423 2,730 3,863 $ 57,435 813 4,332 6,581 2,914 288 1,853 4,763 $ 80,343 1,800 6,284 9,430 3,780 321 2,185 5,865 -0.82% 0.00% 0.00% -0.80% 0.78% -9.67% -24.11% -19.97% 51.82% 104,195 $ 109,700 $ 78,979 $ 110,008 0.28% 30,062 5,000 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 - 450 2,000 450 600 7,000 4,500 28,853 1,951 227,796 $ 2015 % Change $ 29,138 7,854 84,335 2015 Requested 79,255 1,222 6,153 8,424 4,559 395 2,524 1,664 4,325 26,826 2014 YTD 04/30/14 2014 Budget 101,141 2,953 16,944 364,096 Section 5 - Page 4 25,422 9,023 4,400 4,500 1,050 37,936 $ 97,948 60,000 100,000 - $ 18,262 3,000 5,000 1,000 2,000 450 600 3,500 4,500 59 390 320 2,491 2,082 4,770 4,536 1,037 35,638 - 5,500 4,500 1,050 34,172 - -39.25% -40.00% 100.00% 122.22% 0.00% 0.00% 0.00% -50.00% 0.00% 0.00% 25.00% 0.00% 0.00% -9.92% 0.00% 85,768 $83,534 -14.72% 5,616 46,683 - 10,000 0.00% 0.00% 0.00% 0.00% -40.00% 0.00% 0.00% 0.00% 0.00% 0.00% 60,000 60,000 - pg 85 05/28/2014 10:55 AM Water Capital Reinvestment 410-54055-432 Account Description 7825 7827 7829 7830 2011 Actual 2012 Actual 16" Geronimo Trail Tansmission Main Replacement W & WW System Improvements, Phase II Well 17 (Arsenic Compliance) 446,969 Sunnyside Improve 28,855 Capital Projects 815,204 7999 Fixed Assets Total Expenses Book1 $ 843,283 $ 2013 Actual 2014 Budget - - 200,000 27,511 - 550,408 - 286,111 934,401 (385,028) (990,961) 522,751 $ 148,777 Section 5 - Page 4 $ 2014 YTD 04/30/14 2015 Requested 2015 % Change 200,000 - 8,064 - - 0.00% 0.00% 0.00% 0.00% 360,000 60,363 320,000 -11.11% 513,542 -9.53% 567,648 $ 225,110 $ pg 85 05/28/2014 10:55 AM WASTEWATER 420-54061-432 Account Description 2014 YTD 04/30/14 2015 % Change 2012 Actual 2013 Actual 336,787 249 4,778 23,310 30,334 35,856 1,885 7,682 4,041 108 - 266,606 3,860 4,304 3,350 20,044 26,753 35,879 1,188 6,508 317 - 251,368 3,980 4,262 18,302 27,308 13,646 1,251 7,725 28 23,985 $ 289,136 8,000 22,731 33,576 11,407 1,514 10,524 1,000 1,000 32,509 $ 236,144 3,840 16,871 27,074 8,741 1,224 8,059 58 37,178 $ 288,388 8,000 22,674 34,025 10,171 1,154 9,148 1,000 1,000 40,870 -0.26% 0.00% 0.00% 0.00% -0.25% 1.34% -10.83% -23.75% -13.08% 0.00% 0.00% 25.72% $ 351,856 $ 411,397 $ 339,188 $ 416,430 1.22% $ 44,288 2,445 2,504 100,836 10,620 16,815 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 1,289 506,001 33,271 2,498 1,500 90,000 8,000 2,000 48,000 79,576 500,000 77,700 2,500 450 85,000 3,000 800 8,000 49,500 800 950 450 12,000 13,347 2,100 2,250 $ 1,023,692 $ 34,876 2,446 3,283 73,993 4,872 108 23,235 50,471 448,629 68,207 150 0 98,554 1,553 2,750 5,298 22,773 114 210 134 8,732 8,926 1,730 134 861,178 32,871 2,498 2,500 90,000 7,000 2,000 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 2,000 $ 1,094,486 -1.20% 0.00% 66.67% 0.00% -12.50% 0.00% 0.00% 0.00% 11.00% 0.00% 0.00% 122.22% 17.65% 0.00% 217.63% 0.00% 1.01% 0.00% 0.00% 0.00% -8.33% -2.60% 0.00% -11.11% 6.92% 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 $ 445,030 $ 368,809 Contractual serv Auditing Services Telephone Utilities Auto/Equip Building 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 Construction Materials Operating Expense $ 37,646 2,300 2,042 78,013 7,084 309 64,644 2,800 1,523 107,842 11,417 1,711 - 93,585 36,826 34,498 2,430 885 17,270 26,466 925 515 393 10,759 12,629 1,602 4,238 432,956 2014 Budget 2015 Requested 2011 Actual pg 87 Requesting Reclass of C Operating Expense 3001 3002 4104 4105 4301 4302 4703 5201 5202 5301 5502 5801 6001 6002 6021 6301 6302 6401 6501 6502 6601 6701 Book1 33,867 8,651 1,175 675 9,289 12,848 840 1,738 519 10,389 5,258 1,382 2,435 216,461 $ Section 5 - Page 5 05/28/2014 10:55 AM WASTEWATER 420-54061-432 Account Description 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 Total Expenses 2011 Actual 2012 Actual - 11,838 - 14,607 316,953 31,356 362,915 20,605 462,301 26,790 521,534 $ 1,024,406 $ 1,323,299 2013 Actual 2014 Budget 291,384 (85,547) 4,136 468,582 27,173 2,485 708,213 2014 YTD 04/30/14 2015 Requested 2015 % Change 30,000 - 26,170 - 10,000 - 100.00% 0.00% 5,000 36,818 14,435 86,253 2,149 33,786 12,029 74,134 5,000 39,119 32,353 13,592 29,333 129,397 0.00% 100.00% -12.13% -5.84% 100.00% 50.02% $ 1,566,070 $ 1,521,342 $ 1,274,500 $ 1,640,313 7.82% 2015 Requested 10,000 125,000 $ 135,000 2015 Approved 10,000 $ 10,000 pg 87 CAPITAL OUTLAY Items 1 Connex Box New Barn Facility 0 Total Book1 Section 5 - Page 5 05/28/2014 10:55 AM Sewer Capital Reinvestment 420-54065-432 pg 88 Account Description 2011 Actual 2012 Actual 2013 Actual 192,590 298 25,681 3,685 15,813 19,569 16,824 578 5,700 - 67,182 4,631 1,283 5,484 6,881 6,271 307 1,865 - 53,422 133 4,050 5,542 3,022 259 1,661 1,087 $ 69,176 $ 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 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 Book1 $ 280,739 $ 93,904 $44,875 6,643 1,182 377 549 5,523 1,539 4,799 5,281 1,399 36,715 $19,464 9,607 243 436 110 1,577 3,048 1,224 1,499 31,887 $108,880 $69,094 $ 2014 YTD 04/30/14 2014 Budget 54,005 1,200 4,223 6,238 2,789 282 1,820 2,576 19,350 1,919 43 27 77 33 522 417 2,297 35,225 $59,908 Section 5 - Page 6 73,133 18,588 37,936 $56,525 $ $ $ 2015 Requested 38,290 $ 205 2,863 4,349 1,931 191 1,216 3,146 52,191 $17,102 81 12 774 35,638 $53,608 $ 53,562 2015 % Change 1,200 4,189 6,287 2,434 214 1,457 3,910 -0.82% 0.00% 0.00% 0.00% -0.80% 0.78% -12.73% -24.11% -19.97% 51.82% 73,253 0.16% 17,262 34,172 $51,434 pg 88 -7.14% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -9.92% -9.01% 05/28/2014 10:55 AM Sewer Capital Reinvestment 420-54065-432 7401 7851 7852 7860 7862 7865 7869 7871 7872 7873 Sewer CIP Capital Outlay WWMP Phase I(Contract) 394,547 Bonita Interceptor-3rd to 19th 99,938 Phase I, WWTP Improvements 1,811,370 Root Intrusion-City Repairs DOC-Lift Station Improvements CIP Impact Fees-Study W & WW System Improvements, phase II 65,000 Phase II, WWTP Improvements 4,246 Southwest Interceptor (City) 95,215 Southwest Interceptor (Contract) $2,470,316 7999 Contra Exp/Fix As Total Expenses Book1 $ 2,859,936 1,600 51,441 30,000 9,460 3,038 - 37,789 (103) - $44,098 $89,127 ($157,744) ($408,975) $ 207,096 $ (190,765) $ Section 5 - Page 6 15,000 65,000 $0 $0 $0 $0 $0 $3,805 15,000 65,000 120,000 - 33,698 - 1,000,000 - $200,000 329,658 $37,502 $ 143,302 - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 733.33% 0.00% 0.00% $1,080,000 440.00% $ 1,204,687 265.44% 05/28/2014 10:55 AM SANITATION 430-54071-432 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2008 2016 Salaries Sal-Temp Sal-Limited Sal-OT OASI State Retire Health Ins Income Protect State Comp Unemployment Ins. HR Processing Self Funding Ins Claims/Fees Personnel Expense Operating Expense 3001 3002 4104 4105 4301 4302 4311 4703 5201 5501 5502 5801 6001 6002 6201 6301 6302 6501 6502 6601 6705 2012 Actual 2013 Actual 202,886 4,939 27,326 15,538 20,855 28,047 1,193 10,865 1,920 1,261 - 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 $ 344,463 $ $ Contractual Services Auditing services Telephone Utilities Auto/Equip Maintenance cost Heavy Equipment Repair Lease/Purchase Insurance-Liability DOC Labor-Clean up Transfer Expense Travel/training Office supplies Operating supplies Postage Small tools Safety Equipment Gas/oil/lube Diesel/Oil/Lube Uniforms DOC Supplies Operating Expense Book1 2011 Actual 314,829 $ 9,872.50 1,500 516 369,088 $ 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 - 17,375 28 1,201 3,421 294,082 430 1,390 1,086 3,506 33,427 1,254 $ 312,410 $ 383,588 Section 5 - Page 7 379,177 333,293 6,000 $ 1,000 26,032 37,775 18,657 1,725 25,069 2,000 1,200 46,597 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 $ 2014 YTD 04/30/14 2014 Budget 499,348 $ 15,979 2,677 500 5,000 8,000 19,000 45,000 4,200 300,000 1,000 500 1,000 450 2,000 2,000 37,000 2,800 $ 447,106 2015 Requested 203,358 7,090 29,942 2,372 17,418 26,597 10,269 1,146 14,975 549 32,205 $ 345,922 $ 16,419 2,677 445 3,734 2,328 552 25,191 41,774 2,174 1,214 249,519 217 2,618 651 1,179 2,084 2,417 31,262 1,209 $ 387,663 $ 326,295 6,000 2015 % Change 1,000 25,497 37,574 16,362 1,296 22,925 2,000 1,200 50,703 -2.10% 0.00% 0.00% 0.00% -2.06% -0.53% -12.30% -24.86% -8.55% 0.00% 0.00% 8.81% 490,853 -1.70% 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 - 0.00% 0.00% 0.00% 0.00% 100.00% 0.00% 31.58% 0.00% 0.00% 100.00% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -12.50% 0.00% 464,256 3.84% pg 90 05/28/2014 10:55 AM SANITATION 430-54071-432 Account 7402 7999 8001 8003 8901 9901 9917 Description 2011 Actual Capital Outlay 5,018 Fixed Assets Bad Debt Expense Other Expense/Conti Depreciation (Expense Savings) 52,373 Gen. Fund Reimb 226,532 Transfer to Debt Service Transfer to Water 283,924 2012 Actual - Total Expenses $ 1,092,983 $ 967,840 17,276 52,372 327,338 - 2013 Actual 2014 Budget 218,374 277,000 (218,374) 5,326 10,000 1,018 54,972 27,173 33,082 1,243 7,212 396,986 $ 89,732 327,294 813,372 $ 1,273,748 2014 YTD 04/30/14 7,022 2015 Requested 54,000 2015 % Change 100.00% 943 - 10,000 44,647 120,939 25,022 6,796 29,333 246,091 0.00% 0.00% 100.00% -24.36% 100.00% 100.00% -24.81% 778,233 $ 1,201,200 -5.70% 30,672 6,010 $ pg 90 CAPITAL OUTLAY Items 2015 Requested 30,000 lb Vehicle Lift New PW Barn Facility Connex box 96 Gallon Cans $ Book1 24,000 125,000 10,000 20,000 179,000 2015 Approved $ Section 5 - Page 7 24,000 10,000 20,000 54,000 05/28/2014 10:55 AM AIRPORT 310-54103-431 Account Description 2011 Actual 2012 Actual 2013 Actual 2014 Budget Personnel Expense 1001 Salaries $ 1004 Sal-Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2016 Self funding Ins Claims/Fees Personnel Expense $ Operating Expenses 3001 Contractual Services 4104 Telephone 4105 Utilities 4301 Auto/Equip 4302 Facilities Maintenance 5201 Liability Insurance 5801 Travel & Training 6001 Office Supplies 6002 Operating Supplies 6302 Safety Equipment 6401 Books Dues & Subscriptions 6501 Gas/oil/lube 6503 Fuel (100 LL) 6504 Fuel (JET A) 6601 Uniforms $ 16 22,526 194 1,730 2,258 52 738 - 18,124 $ 27,513 $ 2015 Requested 2015 % Change 11,172 11,169 402 1,736 2,479 1,270 81 881 720 $ 23,984 400 1,865 2,755 2,325 126 1,148 2,146 $ 20,435 726 1,619 2,365 1,937 110 930 2,674 $ 23,984 400 1,865 2,799 2,233 97 1,018 2,791 0.00% 0.00% 0.00% 0.00% 1.59% -3.95% -23.21% -11.31% 30.04% 29,911 $ 34,750 $ 30,797 $ 35,188 1.26% $ 4,600 1,652 8,000 500 6,000 5,300 500 700 2,500 450 $ $ $ 4,600 1,500 8,000 500 6,000 5,300 500 500 1,500 400 2,000 25,000 45,000 350 4,119 1,279 6,469 112 5,085 5,222 45 519 15 928 14,896 54,111 120 2,000 25,000 45,000 350 0.00% -9.20% 0.00% 0.00% 0.00% 0.00% 0.00% -28.57% -40.00% -11.11% 0.00% 0.00% 0.00% 0.00% 0.00% 7,738 2,336 9,008 92 551 4,776 6,160 2,031 8,196 185 11,599 4,777 36 1,104 19 601 3,995 731 1,010 44,875 91,063 - 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 162,607 130,410 91,907 102,552 92,921 101,150 -1.37% Total Expenses before Capital 180,731 157,924 121,818 137,302 123,718 136,338 -0.70% - 230 - 230 29,709 - - 550 - - 0.00% 15,000 0.00% 151,338 10.22% 7301 Capital Outlay/Projects 7948 Contra Exp-Fixed Assets 8512 Grant Match Total Expenses Book1 14,941 113 1,152 1,447 36 435 - 2014 YTD 04/30/14 $ 162,607 $ 158,154 $ 151,757 $ 137,302 Section 5 - Page 8 $ 124,268 $ pg 81 05/28/2014 10:55 AM AIRPORT 310-54103-431 CAPITAL OUTLAY Book1 Item 2015 Requested 2015 Approved* 0 0 Total - - $ $ Section 5 - Page 8 05/28/2014 10:55 AM Golf Course 450-52045-451 Account Description 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 15,503 51,856 71,561 821 10,593 8,499 3,209 274 2,185 $ 164,500 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 10,640 39,839 673 11,731 4,363 18,491 11,282 6,746 2,344 24,830 2,741 821 10,524 7,160 240 2,105 22,734 28,126 11,567 96 1,002 925 15,009 1,858 $ 235,847 7750 Capital Outlay 7751 RV Hidden Treasures 8050 Prior Expense - DGSC Total Expenses Book1 2014 YTD 04/30/14 2015 Requested 37,783 45,000 23,515 500 8,170 6,983 1,112 253 2,638 6,161 132,115 23,061 35,869 26,022 553 6,336 5,480 1,032 199 2,213 5,572 $ 106,337 $ 6,533 39,000 11,450 660 16,000 5,000 8,000 300 32,711 1,500 1,500 4,000 1,000 800 20,000 16,000 10,000 100 1,000 401 14,000 1,000 190,955 3,688 20,381 13,994 684 10,892 7,362 1,513 29,678 1,630 3,172 354 14,023 6,592 4,583 106 805 9,825 659 $ 129,941 $ - 2011 Actual 2012 Actual 2013 Actual 2014 Budget $ 17,319 53,697 84,913 1,221 11,709 10,221 3,637 275 2,495 185,487 $ 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 105,751 $ $ 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 76,904 37 - $ 506,097 $ $ 17,852 51,886 79,663 2,071 11,417 10,838 1,700 340 3,409 4,136 183,311 $ 483,807 $ $ 3,703 $ 389,796 Section 5 - Page 9 $ 2015 % Change - -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% - -100.00% -100.00% 0.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% 0.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% 100,000 0.00% - 28 - 323,070 $ 236,306 $ 100,000 $ $ pg 88 -69.05% 05/28/2014 10:55 AM Golf Course 450-52045-451 *CAPITAL OUTLAY CIP Total Book1 2015 2015 Requested Approved 100,000 100,000 0 0 0 0 $ 100,000 $ 100,000 Section 5 - Page 9 05/28/2014 10:55 AM Lounge 450-52055-451 Account Description 2011 Actual 2012 Actual 2013 Actual 2014 Budget Personnel Expense 1001 Salaries $ 1003 Sal-Temp 1004 Sal-Limited 1005 Sal-OT 1008 Tips 2201 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 Workman's Comp 2016 Self Funding Ins Claims/fees Personnel Expense Operating Expense 3001 Contractual Services 4101 Electric 4102 Gas 4103 Water/Sewer/Sanitation 4104 Telephone 4302 Building Maintenance 4303 Computer Maintenance 5401 Advertising/Printing 5801 Travel & Training 6001 Office supplies 6002 Operating supplies 6301 Small tools 6501 Gas/Oil 6508 Beverages 6509 Food 6601 Uniforms Operating Expense Book1 29,646 26,152 2,868 2,348 4,717 2,598 63 870 - $ $ 69,262 $ 79,181 $ 10,959 10,407 3,175 624 426 3,385 730 5,334 $ 4,632 31,173 310 396 31,225 33,126 1,219 $ 137,122 7750 Capital Outlay 8101 Special Events 11,220 417 Total Expenses $ 218,020 $ $ 19,388 37,206 6,146 5,442 5,352 4,604 107 936 - 7,328 9,564 17,231 236 2,908 3,147 2,558 1,309 79 715 699 $ 45,772 $ 16,518 18,207 14,101 1,284 807 393 1,149 8,251 174 2,354 6,576 214 685 39,902 50,389 1,057 12,446 12,792 2,366 936 2,038 2,008 97 625 3,013 86 103 30,695 27,540 617 $ 2,379 10,000 2,500 1,340 504 3,000 500 3,000 300 1,000 3,000 500 145,542 95,361 $ 45,279 375 441 270,376 $ $ 141,574 Section 5 - Page 10 15,000 - 2014 YTD 04/30/14 $ 1,148 370 $ 43,500 600 72,123 $ $ 88,641 2015 Requested 3,656 6,616 474 857 239 367 14 204 1,775 $ 14,201 - 0.00% -100.00% 0.00% 0.00% 0.00% -100.00% 0.00% 0.00% 0.00% -100.00% 0.00% $ - -100.00% 6,347 8,925 1,424 853 888 193 2,626 17,649 2,578 - $ - -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% 0.00% -100.00% 0.00% -100.00% 41,483 $ - -100.00% - 0.00% 0.00% - -100.00% $ 2015 % Change 55,684 $ - pg 88 05/28/2014 10:55 AM GRANTS 2014-2015 Total Grant Award Housing and Community Development 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 GIITEM Salary & Overtime Public Works ADOT Chino Road ADOT RR Depot Fountains ADOT Safe Route to School HSIP Sign Replacement CDBG Grant SSP Grant BECC WasteWater Project Development ADOT Airport Taxi Way ADOT Airport Security Fencing Library E-Rate Grant LSTA Grant - RFID Conversion Tohono O'odham - Shelving & Upstairs Improv Cochise Community Foundation Wal Mart Library Literacy Grant TOTALS REQUESTED TOTALS APPROVED * * * * * 2015 Total Expenditure 2015 Max Revenue 2015 Max Expense 2015 Match 51,750 275,000 326,750 51,750 275,000 326,750 51,750 275,000 326,750 666,453 65,000 731,453 666,453 65,000 731,453 666,453 65,000 731,453 154,116 31,689 419,361 6,000 6,000 6,000 2,600 49,928 3,500 2,000 527,078 31,689 419,361 6,000 6,000 6,000 2,600 49,928 3,500 2,000 527,078 31,689 419,361 6,000 6,000 6,000 2,600 49,928 3,500 2,000 527,078 1,584 20,968 799,332 114,311 162,650 25,000 30,000 40,000 120,809 1,292,102 799,332 114,311 162,650 25,000 30,000 40,000 120,809 1,292,102 799,332 114,311 162,650 25,000 30,000 40,000 120,809 1,292,102 3,264,248 3,264,248 3,264,248 300,000 300,000 300,000 200,000 300,000 575,000 300,000 288,000 5,227,248 200,000 300,000 575,000 300,000 288,000 5,227,248 200,000 300,000 575,000 300,000 288,000 5,227,248 41,950 39,422 30,000 5,000 1,000 117,372 41,950 39,422 30,000 5,000 1,000 117,372 41,950 39,422 30,000 5,000 1,000 117,372 8,222,003 8,222,003 8,222,003 - 154,116 22,553 - 150,574 4,000 - ** * 7,802,642 7,802,642 7,802,642 Total Grant Match from the GF Requested Total Grant Match from the GF Approved 425,000 ** 15,000 594,574 4,661 * 51,750 275,000 326,750 820,569 65,000 885,569 33,273 440,329 Not Recommended 6,000 6,000 6,000 2,600 49,928 3,500 2,000 549,631 799,332 114,311 162,650 25,000 30,000 40,000 120,809 1,292,102 3,414,822 4,000 300,000 200,000 300,000 1,000,000 300,000 303,000 5,821,822 2,313 6,974 46,611 39,422 30,000 7,313 1,000 124,346 778,217 9,000,220 757,249 8,559,891 353,217 332,249 *Grants Accounted for in General Fund Rev & Exp **Grant Accounted for in the Water & Sewer CIP Rev and Exp Book1 Section 6 - Page 1 05/28/2014 10:55 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2014-2015 ITEM/PROJECT AMOUNT REQUESTED ADMINISTRATION City Hall Doors City Hall Bathroom Renovation 30,000 25,000 DEPT DEPT. TOTAL DEPT. APPROVED FUNDING SOURCE 25,000 DEPARTMENT TOTAL FINANCE 1 Inventory Control Program w/ scanners DEPARTMENT TOTAL AMOUNT APPROVED $55,000 $ 25,000 12,000 $ - $ 100,000 $ - $ 81,000 $ 20,000 12,000 $ MIS 1 Generator Computer Replacement Program Data Retention system - Electronic Archiving Software Upgrades Security Management - Access Management GIS Mapping IP Phone Upgrade 100,000 17,800 100,000 45,000 75,000 15,000 50,000 DEPARTMENT TOTAL 100,000 $ 402,800 HUMAN RESOURCES DEPARTMENT TOTAL MAGISTRATE Chambers Upgrades DEPARTMENT TOTAL FIRE/EMS Multi Use Vehicle (pull Haz-Mat, air and light Trailer) Fire pumper Fire Hose Office Furniture New Roof Exterior Wall repair and paint New Fire Station Fire Chief Car Radio Communication replacement DEPARTMENT TOTAL POLICE 2 1/2 ton trucks for Humane 2 replacement vehicles 1 patrol 1 invest 2 replacement vehicles invest 2 HVAC for west side CEMETERY 1 Ride Mower Chip Seal project Restroom Upgrade Gator DEPARTMENT TOTAL Book1 - $ 81,000 81,000 81,000 125,000 450,000 8,000 6,000 20,000 7,000 6,000,000 30,000 323,398 JCEF(44)/GF(37) 8,000 5,000 7,000 $ 6,969,398 50,000 80,000 80,000 16,000 DEPARTMENT TOTAL VISITOR CENTER Facility Upgrades for Social Events Doors DEPARTMENT TOTAL $ 80,000 80,000 16,000 $ 226,000 6,000 5,000 RICO Auction $ 176,000 $ 10,000 $ 27,000 5,000 5,000 $ 11,000 12,000 30,000 6,000 9,000 12,000 6,000 9,000 $ 57,000 Section 7 - Page 82 05/28/2014 10:55 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2014-2015 DEPT ITEM/PROJECT AMOUNT REQUESTED PARKS 9 weedeater and Blowers Portable gas generator with elder Playground upgrades Desert Landscape - W area of Veteran's Park Lighting Improvements all parks Parking lot for baseball field - Veteran's Park Playground Solar Lighting - Veterans Ramadas Roofing 8th St. Park shop roof and bathrooms Tennis court flooring Veteran's Park Tractor w Front Loader Walkway Repair East side - Veteran's Park Walkway Repair South side - Veteran's Park Walkway Repair West side - Veteran's Park Ride Mower 72" Playground replacement equipment Basketball court NEW- Causey Park Field Groomer Restroom Causey Park Basketball court NEW- Causey Park Truck Line Cutter RECREATION Workout Equipment Event Chairs, Tables and Tents DEPT. APPROVED FUNDING SOURCE 35,500 $ 355,000 $ 35,500 $ 10,000 $ - $ 5,000 5,000 5,000 DEPARTMENT TOTAL AQUATICS Canopies - 8th Street Baby Pool, AC Play Area, Kiddie $ Pool 9,000 Diving Board Replacement $ 12,000 Filter and Sand Replacement $ 10,000 Municipal Pool Repairs Roof & Ceiling $ 8,000 Municipal Pool Repairs and bathroom upgrades $ 5,000 Patch and paint pool walls and gutthers both pools$ 5,000 Roof for Equipment Room $ 8,000 Roofing & ceiling of facility $ 10,000 Deck resurfacing $ 22,000 Dehumidifier Engineering assessment $ 8,000 Parking lot Chip Seal $ 10,000 Replaster Baby Pool $ 15,000 Restroom equipment - stalls, lockers, dividers,etc. 10,000 Roof repair/replacement office 14,000 Solar Lighting for backyard 5,000 POS System 9,000 DEPARTMENT TOTAL $ 5,000 $ 160,000 125,000 DEPARTMENT TOTAL PW CONSTRUCTION Fleet AMOUNT APPROVED 5,000 8,000 10,000 $5,000 $90,000 $10,000 $5,000 $30,000 $5,000 $5,000 $30,000 10,000 $10,000 $10,000 16,000 12,000 15,000 13,000 25,000 15,000 17,000 9,000 DEPARTMENT TOTAL PUBLIC WORKS/ADMINISTRATION New Barn Facility DEPT. TOTAL $ 125,000 179,000 DEPARTMENT TOTAL Will be leased $ - 179,000 Various GF Depts $ 179,000 $ 179,000 $ - $ - PUBLIC WORKS/FLEET MAINTENANCE DEPARTMENT TOTAL LIBRARY Shelving Book1 12,500 Section 7 - Page 83 05/28/2014 10:55 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2014-2015 DEPT ITEM/PROJECT AMOUNT REQUESTED Carpet 26,852 DVD/CD Repair and Cleaner Machine 5,000 2 Handicap Automatic Door Openers for Publc Bathrooms4,100 Inventory Device/Wand 5,500 Elevator 50,000 RFID System Wand 6,500 DEPARTMENT TOTAL TRANSIT 2 36 passenger bus Bay & Lift 5 PCs w/ software licenses 12 Bus stops 14 Benches DEPARTMENT TOTAL DEPT. TOTAL AMOUNT APPROVED 5,500 $ 110,452 $ 10,500 272,000 53,820 6,900 52,676 7,350 $ 392,746 $ 392,746 Grant/ Match Required Grant/ Match Required Grant/ Match Required Grant/ Match Required Grant/ Match Required $ 39,274.60 match by GF TOTAL REQUESTED TOTAL AMOUNT APPROVED $ 9,146,396 $1,061,746 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 $ 353,471 $ 80,000 $ 39,275 $ 286,000 $ 44,000 $ 179,000 $1,061,746 BALANCE Book1 FUNDING SOURCE 5,000 272,000 53,820 6,900 52,676 7,350 TOTAL GENERAL FUND REQUESTS DEPT. APPROVED $ Section 7 - Page 84 $ $ $ $ $ $ $ 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 - 05/28/2014 10:55 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2014-2015 DEPT ITEM/PROJECT AMOUNT REQUESTED SANITATION 30,000 lb Vehicle Lift New PW Barn Facility Connex box 96 Gallon Cans DEPARTMENT TOTAL DEPT. TOTAL AMOUNT APPROVED 24,000 125,000 10,000 20,000 Will be leased 10,000 20,000 179,000 15,000 DEPARTMENT TOTAL 15,000 6,400 0 DEPARTMENT TOTAL 54,000 $ 15,000 $ 6,400 6,400 $ WATER FIELD 1 Connex box Safety Barricades New Barn Facility $ 15,000 $ WATER OFFICE 4 Scanners FUNDING SOURCE 24,000 $ STREETS (HURF) 2 Connex Boxes for Eq & Tool Storage DEPT. APPROVED 6,400 10,000 5,000 125,000 10,000 5,000 Will be leased - DEPARTMENT TOTAL $ WATER/SEWER - CAPITAL REINVESTMENT PROGRAM 1 Connex Box 10,000 DEPARTMENT TOTAL GOLF COURSE CIP 10,000 10,000 125,000 DEPARTMENT TOTAL 15,000 $ 10,000 10,000 Will be leased $ $ $ 10,000 $ WASTEWATER 1 Connex Box New Barn Facility 140,000 135,000 100,000 $ 10,000 $ 100,000 $ 4,000 $ - 100,000 - DEPARTMENT TOTAL HOUSING Front Counter / Glass replacement Designated File/ storage space DEPARTMENT TOTAL $ $ $ 100,000 4,000 1,500 4,000 $ 5,500 AIRPORT DEPARTMENT TOTAL Book1 $ - Section 7 - Page 85 05/28/2014 10:55 AM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2014-2015 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 $590,900 DEPT. APPROVED TOTAL AMOUNT APPROVED $214,400 $ 4,000 $ 100,000 $ 110,400 Sanitation Fund HURF Water Fund Sewer Fund Water/Sewer CIP HUD Golf Course Airport $ $ $ $ $ $ $ $ $ 54,000 15,000 21,400 10,000 10,000 4,000 100,000 - Total Enterprise Funds CIP 12/13 $ 110,400 TOTAL GENERAL FUND REQUESTS: TOTAL ENTERPRISE FUND REQUESTS: $ 9,146,396 $ 590,900 $1,061,746 $ 214,400 TOTAL CAPITAL OUTLAY REQUESTS: $ 9,737,296 $1,276,146 LESS: FUNDED BY SPECIAL FUNDING $ 517,471 $ 517,471 TOTAL CITY FUNDED CAPITAL OUTLAY: $ 9,219,825 $ 758,675 Book1 Section 7 - Page 86 FUNDING SOURCE 05/28/2014 10:55 AM