CITY OF DOUGLAS BUDGET SUMMARY Expense 2013 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 2014Budget 482,868 35,000 93,173 45,217 498,323 1,075,886 566,006 2,496,593 68,826 358,727 89,037 71,979 572,647 108,189 275,810 186,849 452,456 255,687 1,116,955 1,093,317 336,187 2,264,930 1,367,129 162,418 66,958 410,982 636,050 - GENERAL FUND $ 15,188,198 Net Rev. vs. Exp. $ 0 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2013-2014 Difference 482,031 71,873 506,977 1,004,950 492,946 2,647,272 69,449 305,096 127,504 545,958 96,103 303,987 157,633 446,258 201,710 1,120,422 1,222,508 276,513 2,387,928 1,424,933 164,754 67,549 506,453 415,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ (837) (35,000) (21,300) (45,217) 8,654 (70,936) (73,060) 150,679 623 (53,631) (89,037) 55,525 (26,689) (12,086) 28,176 (29,216) (6,198) (53,977) 3,467 129,191 (59,674) 122,998 57,804 2,336 591 95,472 (221,050) - $ 15,045,807 $ (142,391) 2014 2013 Budgeted 2014 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp -0.17% -100.00% -22.86% -100.00% 1.74% -6.59% -12.91% 6.04% 0.91% -14.95% -100.00% 77.14% -4.66% -11.17% 10.22% -15.64% -1.37% -21.11% 0.31% 11.82% -17.75% 5.43% 4.23% 1.44% 0.88% 23.23% -34.75% -0.94% $ 14,953,422 $ 15,045,807 $ 0 - GF Reserve $ - $ 0 06/14/2013 3:14 PM Book5 Section 1 - Page 1 CITY OF DOUGLAS BUDGET SUMMARY 2013 Budget 2014 2014 2013 Budgeted 2014 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp 2013-2014 Difference 2014 Budget H. U. R. F. $ 1,388,477 $ 1,196,303 $ (192,174) LTAF $ - $ - $ - CAPITAL PROJECTS $ 600,000 $ 670,000 $ DEBT SERVICE FUND $ 1,671,117 $ 1,563,854 $ MPC FUND $ 477,967 $ 486,806 $ RICO $ 155,000 $ 210,000 JCEF $ 18,560 $ GRANTS $ 3,977,942 HOUSING $ TOTAL SPECIAL REVENUE FUNDS -13.84% $ 1,388,477 $ 1,196,303 $ (0) $ - $ - $ - 70,000 11.67% $ - $ 670,000 $ - (107,263) -6.42% $ 1,831,621 $ 1,563,854 $ - 8,839 1.85% $ 477,967 $ 486,806 $ - $ 55,000 35.48% $ 155,000 $ 210,000 $ - 18,572 $ 12 0.06% $ 10,500 $ 10,500 $ $ 5,108,376 $ 1,130,434 4,184,427 $ 5,108,376 $ - 346,684 $ 283,071 $ (63,614) -18.35% $ 346,684 $ 283,071 $ 0 $ 8,635,748 $ 9,536,983 $ 901,235 10.44% $ 8,394,676 $ 9,528,911 $ (8,072) SANITATION $ 1,000,716 $ 1,273,748 $ 273,032 27.28% $ 1,230,100 $ 1,230,100 $ (43,648) WATER WATER OFFICE WATER FIELD WATER CAPITAL REINVESTMENT WATER TOTAL $ $ $ $ 248,355 1,314,767 1,049,224 2,612,345 $ $ $ $ 254,258 1,233,094 567,648 2,055,000 $ $ $ $ 5,903 (81,673) (481,575) (557,345) 2.38% -6.21% -45.90% -21.34% $ 2,105,206 $ 2,055,000 $ (0) WASTE WATER SEWER CAPITAL REINVESTMENT SEWER TOTAL $ $ $ 1,569,687 367,979 1,937,665 $ $ $ 1,521,342 329,658 1,851,000 $ $ $ (48,345) (38,320) (86,665) -3.08% -10.41% -4.47% $ 1,937,665 $ 1,851,000 $ 0 AIRPORT* $ 183,702 $ 137,302 $ (46,400) -25.26% $ 183,702 $ 137,302 $ - GOLF COURSE ** BAR & RESTAURANT $ $ $ 376,093 178,643 554,736 $ $ $ 323,070 88,641 411,711 $ (143,025) -38.03% $ 554,736 $ 411,711 $ - TOTAL ENTERPRISE FUNDS $ 6,289,164 $ 5,728,762 $ (560,402) -8.91% $ 6,011,409 $ 5,685,113 $ (43,648) GRAND TOTALS $ 30,113,109 $ 30,311,551 $ 198,442 0.66% $ 29,359,507 $ 30,259,831 $ (51,720) #DIV/0! 28.42% (8,072) * Airport is being subsidized $27,402 by the General Fund ** Golf Course/Bar is being subsidized $125,420 by the General Fund 06/14/2013 3:14 PM Book5 Section 1 - Page 2 REVENUE BUDGET 2013 - 2014 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 2010 Actual 499,803 27,609 4,123,716 1,030,940 30,593 178,910 120,970 51,755 77,915 10,649 1,165 3,535 89,918 4,922 3,980 145 80 567,872 - 1,265,384 2,220,055 771,141 30,274 52,788 44,993 65,795 9,065 3,000 671,753 5,968 1,170 23,955 7,152 846 860 1,530 761 4,182 250 2011 Actual $ $ 2012 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 2013 10-month Actual 2013 Budget 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 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 490,000 30,000 4,480,000 1,119,978 52,000 175,000 120,000 55,000 88,000 10,000 3,500 4,000 70,000 2,000 4,000 500 1,000 686,000 21,890 508,750 171,044 1,453,152 1,774,964 796,122 58,000 96,207 62,686 30,000 70,000 8,000 4,200 24,000 5,000 1,200 972,724 6,435 162 24,037 4,702 0 521 1,334 4,685 1,075 5,683 90 0 924,788 11,331 11,704 20,482 6,113 0 1,677 1,424 14,658 1,813 7,394 120 0 1,000,000 7,000 2,000 18,000 5,000 1,000 2,000 1,500 5,000 1,500 4,000 250 $ $ $ 352,874 25,482 3,188,457 796,967 35,379 136,491 71,359 24,520 74,519 9,075 2,630 3,210 33,665 1,140 3,460 205 990 372,080 18,040 122,768 1,161,331 1,479,271 594,595 32,911 61,613 19,646 62,800 5,320 16,050 2,100 1,239 19,465 787,109 7,755 7,621 11,689 4,105 752 558 5,590 1,222 4,088 - 2014 Projected $ $ $ 2014 % Change 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 - 2.04% 0.00% -8.48% -8.48% -13.46% 2.86% -16.67% -7.27% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -100.00% -3.04% -56.47% 3.33% 9.23% 0.37% 0.00% 3.39% 0.00% -100.00% 0.00% 0.00% -100.00% -8.33% -40.00% 16.67% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 40.00% 0.00% 0.00% 0.00% -100.00% 06/14/2013 3:14 PM Book5 Section 2 - Page 3 REVENUE BUDGET 2013 - 2014 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 39301 Description 2010 Actual RAMADA RESERVATION FEES DUSD AQUATIC CENTER REIMB 35,000 DUSD RECREATION REIMB 20,000 1 TRAFFIC CONTROL BORDER PROJECT MUSEUM SHOP COURT FINES & FORFEITURES 126,776 RESTITUTION PAYMENTS 1,566 LIBRARY FINES & FEES 16,679 COURT FINE OFFICER SA FORFEITED PROPERTY SALE 37,330 INVESTMENT EARNINGS 43,712 RENTAL PAYMENTS 3,181 CALL CENTER Lease 704,620 VISITOR CENTER RESV FEES 380 SPECIAL EVENTS REVENUE 855 4TH OF JULY REVENUE 997 YOUTH ACTIVITY REVENUE DONATIONS/MISC LIBRARY GRANT E-RATE 58,162 MISCELLANEOUS REVENUE 53,820 1 CASH OVER/SHORT SALE SURPLUS PROPERTY/LAND EXPLORER REVENUE TRANSFER FROM LTAF TRANSFER FROM SPECIAL PROJECTS 133,520 TRANSFER FROM ENTERPRISE FUNDS 323,107 TRANSFER FROM GRANTS 3,745 CAPITAL LEASE PROCEEDS 2 TOTAL REVENUE $ 13,568,847 2011 Actual $ 2012 Actual 1,895 35,000 20,000 66,757 $ 0 144,669 2,325 17,694 0 29,632 58,170 16,621 715,478 3,320 1,396 625 0 0 147,975 65,427 0 16,145 300 0 -4 386,920 0 - $ 13,873,619 2,390 35,000 20,000 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 - $ 13,904,854 2013 10-month Actual 2013 Budget 2,000 40,000 20,000 2014 % Change 216,760 - 167,228 - - 0.00% 51.83% -100.00% 0.00% -100.00% 0.00% 0.00% -10.00% 0.00% -25.00% 0.00% 349.26% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 4.39% 260.00% 0.00% 3000.00% 0.00% 0.00% 0.00% 24.76% 0.00% 0.00% $ 14,953,422 $ 11,027,602 $ 15,045,807 0.62% $ 4,000 148,000 1,500 20,000 3,000 160,000 10,000 20,300 715,478 2,500 2,000 1,000 1,000 44,461 50,000 10,000 1,000 173,740 1,160 56,959 126,249 793 15,542 5,753 49,694 7,352 19,151 594,398 2,110 2,171 50 351 34,905 26,964 (230) 356,860 - 2014 Projected 2,000 60,734 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 14,329,047 06/14/2013 3:14 PM Book5 Section 2 - Page 4 REVENUE BUDGET 2013 - 2014 HIGHWAY USER REVENUE FUND Account 33504 38001 38002 38003 39101 39103 39104 Description 2010 Actual 2011 Actual HIGHWAY USERS - STATE $ MISCELLANEOUS SALES REIMBURSEMENT CITIZEN PAYS POLICY TRANSFER FROM GENERAL FUND TRANSFER FROM LTAF Q TRANSFER FROM SP PROJECTS 1,202,711 37,713 109 120,000 1,227,579 290 63,381 170,000 - 31,213 TOTAL REVENUE 1,360,533 $ $ 1,492,462 2012 Actual $ 2013 10-month Actual 2013 Budget 1,033,728 1,613 40,201 240,000 83,997 - $ 1,399,540 $ 1,178,000 30,000 5,000 175,477 $ 1,388,477 2014 Projected 897,011 15 17,230 146,231 $ $ 1,060,487 $ 2014 % Change 1,161,303 30,000 5,000 - -1.42% 0.00% 0.00% 0.00% -100.00% 0.00% 0.00% 1,196,303 -13.84% 06/14/2013 3:14 PM Book5 Section 2 - Page 5 REVENUE BUDGET 2013 - 2014 LOCAL TRANSPORTATION ASSIST. (LOTTERY) Account 33505 Description 2010 Actual LOTTERY LTAF II GRANT $ 43,965 25,267 TOTAL REVENUE $ 69,232 2011 Actual 2012 Actual 14,258 $ 14,258 $ 2013 10-month Actual 2013 Budget 2014 Projected 2014 % Change - $ - $ - $ - 0.00% 0.00% - $ - $ - $ - 0.00% 06/14/2013 3:14 PM Book5 Section 2 - Page 6 REVENUE BUDGET 2013 - 2014 CAPITAL PROJECTS Account 31301 36101 36102 38001 38007 39101 39114 Description 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 2010 Actual $ 2011 Actual - - 2,446 - $ 2,446 12,616 947 217,000 2,446 (607) - TOTAL REVENUE 2012 Actual $ 1,839 $ 230,563 - $ - $ 2013 10-month Actual 2013 Budget $ - 2014 Projected 5,350 - $ $ 5,350 $ 448,038 2014 % Change 120,000 101,962 - 100.00% 0.00% 0.00% 0.00% 0.00% 100.00% 100.00% 0.00% 670,000 100.00% 06/14/2013 3:14 PM Book5 Section 2 - Page 7 REVENUE BUDGET 2013 - 2014 DEBT SERVICE FUND Account 31301 36101 39101 39104 39110 Description 2010 Actual 1 1/3 Cent Sales Tax (call center IT) $ INVESTMENT EARNINGS TRANSFER FROM GENERAL FUND TRANSFER FROM CAPITAL TRANSFER FROM ENTERPRISE TOTAL REVENUE $ 2011 Actual 617,834 2012 Actual 705,653 1,035,372 617,834 13,095 $ 1,754,120 $ 2013 10-month Actual 2013 Budget 604,506 430 1,149,223 60,000 18,082 $ 1,832,242 $ 671,987 1,500 1,158,134 $ 1,831,621 2014 Projected 468,270 650 929,021 $ $ 1,397,942 $ 101,962 1,373,580 2014 % Change 88,312 -84.83% -100.00% 18.60% 0.00% 100.00% 1,563,854 -14.62% 06/14/2013 3:14 PM Book5 Section 2 - Page 8 REVENUE BUDGET 2013 - 2014 MPC Account 39101 39102 39104 Description 2010 Actual 2011 Actual TRANSFER FROM GF $ TRANSFER FROM HURF TRANSFER FROM SPEC PROJECTS - TOTAL REVENUE - $ 2012 Actual 213,610 272,467 $ 486,076 $ 2013 10-month Actual 2013 Budget 2014 Projected 2014 % Change 321,547 162,910 $ 319,912 158,055 - $ 266,865 131,441 - $ 324,537 162,269 - 1.45% 2.67% 0.00% 484,456 $ 477,967 $ 398,306 $ 486,806 1.85% 06/14/2013 3:14 PM Book5 Section 2 - Page 9 REVENUE BUDGET 2013 - 2014 RICO Account 33241 33242 36106 39101 39112 Description 2010 Actual RICO-ST ATTY GENERAL RICO-COUNTY ATTY INTEREST RICO TRANSFER FROM GF TRANSFER FROM GRANTS $ TOTAL REVENUE $ 2011 Actual 20,496 16,500 $ 36,996 $ 2012 Actual 53,975 47,530 763 407,673 - $ 509,941 $ 2013 10-month Actual 2013 Budget 370,310 79,688 2,591 - $ 452,589 $ 155,000 - $ 155,000 2014 Projected 169,221 21,000 $ $ 190,221 $ 2014 % Change 210,000 - 35.48% 0.00% 0.00% 0.00% 0.00% 210,000 35.48% 06/14/2013 3:14 PM Book5 Section 2 - Page 10 REVENUE BUDGET 2013 - 2014 JCEF Account 35104 35105 35110 Description 2010 Actual LOCAL JCEF TIME PAYMENTS FILL THE GAP RESTRICTED MCEF SUSPENSION FEE $ 6,346 648 (66) TOTAL REVENUE $ 6,928 2011 Actual 2012 Actual 6,753 363 (75) $ 7,041 $ 2013 10-month Actual 2013 Budget 2014 Projected 2014 % Change 7,050 1,632 - $ 6,000 2,000 2,500 $ 6,434 523 - $ 6,000 2,000 2,500 0.00% 0.00% 0.00% 8,682 $ 10,500 $ 6,957 $ 10,500 0.00% 06/14/2013 3:14 PM Book5 Section 2 - Page 11 REVENUE BUDGET 2013 - 2014 GRANTS Account Description 2010 Actual 2011 Actual 2012 Actual HOUSING & COMM DEVELOPMENT FIRE POLICE PUBLIC WORKS LIBRARY TRANSFER FROM GENERAL FUND TRANSFER FROM CAPITAL PROJ TRANSFER FROM WATER TOTAL REVENUE $ - $ - $ 2013 10-month Actual 2013 Budget 10,098 16,075 37,288 637,465 548 82,331 127,181 18,456 $ 929,442 $ 1,252,525 1,201,500 38,000 1,596,687 1,000 94,715 $ 4,184,427 2014 Projected 118,627 3,645 56,156 128,614 113 76,635 $ $ 383,790 $ 2014 % Change 919,464 31,500 108,369 3,859,518 1,000 188,525 - -26.59% -97.38% 185.18% 141.72% 0.00% 99.04% 0.00% 0.00% 5,108,376 22.08% 06/14/2013 3:14 PM Book5 Section 2 - Page 12 REVENUE BUDGET 2013 - 2014 HOUSING Account 33212 33703 39112 Description 2010 Actual HOUSING REIMB $ CASAS PIONEER REIMB TRANSFER FROM GF (TRANSIT) TRANFER FROM GRANTS 198,214 TOTAL REVENUE 237,715 $ 2011 Actual $ 39,501 $ 2012 Actual 234,218 20,346 50,408 $ 304,972 $ 2013 10-month Actual 2013 Budget 312,977 40,188 $ 353,165 $ 292,369 $ 45,780 8,535 346,684 $ 2014 Projected 185,815 38,150 19,613 $ 243,577 $ 2014 % Change 283,071 - -3.18% 0.00% -100.00% -100.00% 283,071 -18.35% 06/14/2013 3:14 PM Book5 Section 2 - Page 13 REVENUE BUDGET 2013 - 2014 SANITATION Account 34603 36101 38001 39301 Description GARBAGE COLLECTION FEE INVESTMENT EARNINGS MISCELLANEOUS CAPITAL LEASE PROCEEDS TOTAL REVENUE 2010 Actual 1,059,088 947 975 $ 1,061,011 2011 Actual 1,203,481 (62) 82 $ 1,203,500 2012 Actual 1,237,376 385 73 $ 1,237,834 2013 10-month Actual 1,005,449 572 - 2013 Budget 1,230,000 100 $ 1,230,100 $ 1,006,021 $ 2014 Projected 1,230,000 100 - 2014 % Change 0.00% 0.00% 0.00% 0.00% 1,230,100 0.00% 06/14/2013 3:14 PM Book5 Section 2 - Page 14 REVENUE BUDGET 2013 - 2014 WATER FUND Account Description 2010 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 TOTAL REVENUE $ 2011 Actual 1,444,657 333,438 34,767 10,996 1,556,385 332,180 31,982 1,113 89,312 267 865,124 44,925 47 - 2,778,561 $ 1,966,633 2012 Actual 2013 Budget 274,140 65,719 1,624,027 330,075 5,600 3,836 9,605 40,692 8 - 206 1,700,000 331,000 20,000 4,000 $ 2,353,702 2013 10-month Actual 19,578 211 1,298,351 273,817 5,600 4,201 6,325 47,246 (132) - 50,000 $ 2,105,206 2014 Projected $ 1,655,197 2014 % Change 1,650,000 331,000 20,000 4,000 - #DIV/0! -100.00% -2.94% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2,055,000 -2.38% 50,000 $ 06/14/2013 3:14 PM Book5 Section 2 - Page 15 REVENUE BUDGET 2013 - 2014 WASTE WATER FUND Account 33301 34602 34602 1 36101 38001 38006 39107 Description 2010 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 2011 Actual 664,668 340,861 36,878 2,263 2,147 2,374,365 1,312,008 340,423 47,499 (70) 3,293 - $ 3,421,182 2012 Actual $ 1,703,154 2013 Budget 517,111 1,434,278 334,176 21,000 3,825 6,794 - - 1,665 1,485,000 337,000 20,000 10,000 4,000 0 80,000 - $ 2,317,183 2013 10-month Actual $ 1,937,665 2014 Projected 1,660 1,238,918 273,390 6,800 7,246 13,877 - 1,480,000 337,000 20,000 10,000 4,000 0 0 - $ 1,541,891 $ 1,851,000 2014 % Change -100.00% -0.34% 0.00% 0.00% 0.00% 0.00% #DIV/0! -100.00% 0.00% -4.47% 06/14/2013 3:14 PM Book5 Section 2 - Page 16 REVENUE BUDGET 2013 - 2014 AIRPORT FUND Account 33221 34880 34880 36201 36201 36201 38001 39103 39104 Description 2010 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 $ 2011 Actual 2012 Actual 2013 Budget 38,739 61,979 5,058 14,970 2,400 - 42,180 78,000 6,000 14,100 2,400 2013 10-month Actual $ 31,054 135,452 7,734 7,105 1,200 550 12,000 195,095 45,108 117,429 9,479 11,750 2,000 225 $ 185,991 $ 123,146 41,022 $ 183,702 $ 2014 Projected 1,990 27,207 35,306 8,190 12,220 2,100 12,522 99,535 27,402 - 0.00% -27.69% -30.77% 33.33% 4.26% 12.50% 0.00% 0.00% -33.20% 0.00% 137,302 -25.26% 30,500 54,000 8,000 14,700 2,700 $ 2014 % Change 06/14/2013 3:14 PM Book5 Section 2 - Page 17 REVENUE BUDGET 2013 - 2014 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 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 1 cash over/short 2010 Actual $ 44,791 655 1,969 3,786 6,275 320 36,927 2,315 33,826 16,909 8,716 10,315 2,931 $ 2012 Actual 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 2 7,270 51,656 14,612 - SUBSIDY FROM GEN FUND CAPITAL LEASE PROCEED TOTAL REVENUE 2011 Actual 2013 10-month Actual 2013 Budget 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 (5) 35,000 500 5,000 6,045 659 132 30,000 2,500 30,000 15,000 7,000 1,000 27,000 1,000 45,000 15,600 61,250 18,750 $ 1,000 2014 Projected 23,067 $ 657 3,790 7,370 330 15,190 1,647 17,371 11,550 3,902 226 9,251 2,415 28,965 8,262 59,424 22,153 3,027 (45) 1,109 461 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 2014 % Change -5.71% 0.00% 20.00% 40.62% 0.00% 0.00% -16.67% 0.00% -13.33% -6.67% 0.00% 0.00% -59.26% 200.00% 0.00% -3.85% 42.04% -100.00% 0.00% 0.00% 0.00% 243,273 270,722 384,808 302,436 220,122 286,291 114,918 - 341,175 75,413 513,716 71,677 252,300 - 210,250 - 125,420 - -50.29% 0.00% 411,711 -25.78% 358,191 $ 687,311 $ 970,195 $ 554,736 $ 430,372 $ 06/14/2013 3:14 PM Book5 Section 2 - Page 18 GENERAL FUND ADMINISTRATION 001-51001-413 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 Salaries Sal - Temp Sal - Limited Sal - Overtime OASI State Retire Health Ins Income Protect State Comp Personnel Expense Operating Expense 3001 4301 5401 5801 6001 6201 6401 6501 2010 Actual 2011 Actual 337,952 847 24,085 30,649 19,287 1,950 557 333,184 902 23,783 32,095 26,492 1,581 523 $ Contractual serv Auto & Eq Maintenance Adv/Printing/Reproduction Travel/training Office supplies Postage Books/Dues/Subscrip Gas/Oil/Lube 415,327 $ 418,559 2012 Actual 2013 Budget $ 2013 YTD 04/30/13 2014 Requested 2014 % Change 331,942 19 15,457 514 24,436 32,027 23,656 1,164 540 $ 371,858 28,447 40,533 5,971 1,655 814 $ 352,480 1,088 25,858 35,665 6,118 1,248 692 $ 367,849 28,140 41,567 7,985 1,599 901 -1.08% 0.00% 0.00% 0.00% -1.08% 2.55% 33.73% -3.39% 10.69% 429,755 $ 449,278 $ 423,150 $ 448,041 -0.28% 3,000 5,000 10,900 6,670 500 6,820 700 2,621 7,414 11,565 6,797 307 1,624 1,292 3,000 1,000 5,000 10,000 6,670 500 6,820 1,000 0.00% 100.00% 0.00% -8.26% 0.00% 0.00% 0.00% 42.86% 33,990 1.19% $ 482,031 -0.17% 2,168 4,054 3,849 6,663 7,901 6,313 1,035 8,942 333 26,480 8,413 5,257 327 10,356 543 13,245 8,119 6,414 410 3,851 559 Operating Expense $ 33,354 $ 55,428 $ 36,447 Total Expenses $ 448,681 $ 473,988 $ 466,203 $ 33,590 $ 482,868 $ 31,620 $ 454,770 $ CAPITAL OUTLAY Item 0 0 Total Book5 2014 Requested $ 2014 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 1 06/14/2013 3:14 PM GENERAL FUND ECONOMIC DEVELOPMENT 001-51003-465 Account Description Personnel Expense 1001 2001 2002 2004 2005 2006 Salaries OASI State Retire Health Ins Income Protect Workman's Comp 2010 Actual 2011 Actual 2012 Actual 66,254 4,966 4,998 1,987 328 157 Personnel Expense Operating Expense 3001 5801 6001 6201 6401 6501 8009 $ Contractual Travel/training Office supplies Postage Books/dues/subscrip Gas/oil/lube Marketing/Promotions 78,690 $ 562 1,575 759 42 324 486 25,116 - $ 451 51,373 2013 Budget 2013 YTD 04/30/13 2014 Requested 2014 % Change - $ - $ - $ - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - $ - $ - $ - 0.00% - -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% -100.00% 25,000 3,000 25,000 10,000 12,500 2,263 Operating Expense $ 28,864 $ 51,824 $ 28,000 $ 35,000 $ 14,763 $ - -100.00% Total Expenses $ 107,554 $ 51,824 $ 28,000 $ 35,000 $ 14,763 $ - -100.00% 2014 Requested 2014 Approved* *Budgeted in GF Department 1801 CAPITAL OUTLAY Items 0 Total Book5 $ - $ - Section 3 - Page 2 06/14/2013 3:14 PM GENERAL FUND VISITOR CENTER 001-51005-419 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 Salaries Sal - Temp Sal - Limited Sal - Overtime OASI State Retire Health Ins Income Protect State Comp Personnel Expense Operating Expense 3001 4105 4302 5801 6001 6014 6015 6201 6401 6601 8009 2010 Actual 2011 Actual 10,647 45,870 9 5,449 545 441 34 315 12,352 900 43 1,017 719 18 39 $ Contractual serv Utilities Building Maintenance Travel/training Office supplies Museum Collections Museum ProShop Postage Books/Dues/Subscrip Uniforms Marketing/Promotions 63,310 $ 8,867 10,076 1,126 922 15,088 2012 Actual 2013 Budget 30,904 996 630 2,476 3,129 4,554 148 67 $ 8,308 8,022 1,560 173 3,253 110 20,876 19 - 108 6,959 202 1,087 42,904 2013 YTD 04/30/13 31,444 - 22,616 1,284 1,831 2,520 1,637 113 68 2,405 3,427 1,762 163 71 $ 7,766 7,417 1,331 165 773 131 13,917 411 39,273 2014 Requested $ 10,000 10,000 3,000 1,000 3,500 5,000 3,000 200 15,000 200 3,000 30,068 19,458 2,000 - $ 7,994 5,639 755 146 2,287 179 65 13,917 1,309 2014 % Change 1,642 2,199 1,453 101 54 -38.12% 100.00% 0.00% 0.00% -31.76% -35.85% -17.55% -38.12% -23.80% 26,906 -31.49% 8,550 7,600 1,500 600 2,500 200 13,917 100 10,000 -14.50% -24.00% -50.00% -40.00% -28.57% -100.00% -100.00% 0.00% -7.22% -50.00% 233.33% Operating Expense $ 29,346 $ 42,321 $ 31,911 $ 53,900 $ 32,291 $ 44,967 -16.57% Total Expense $ 92,656 $ 57,409 $ 74,816 $ 93,173 $ 62,359 $ 71,873 -22.86% CAPITAL OUTLAY Item 0 Total Book5 2014 Requested $ 2014 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 3 06/14/2013 3:14 PM GENERAL FUND PARKING LOT 001-51007-419 Account Description Personnel Expense 1003 2001 2002 2005 2006 Sal - Temp OASI State Retirement Inc Protection State Comp Personnel Expense Operating Expense 3001 4105 4302 6001 6601 2010 Actual 2011 Actual 2012 Actual 2013 Budget 35,591 2,732 - 36,706 2,807 470 9 66 62 $ - $ 38,385 $ 40,059 Contractual Services Utilities Building Maintenance Office supplies Uniforms $10 - $120 3,016 180 756 63 $120 2,652 41 225 86 Operating Expense $10 $4,135 $3,125 43,184 Total Expense $ 10 $ 42,520 $ 2013 YTD 04/30/13 36,500 2,792 1,261 83 $ 40,637 2014 Requested 28,652 2,192 2,193 27 63 $ 33,128 $ 2014 % Change - -100.00% -100.00% -100.00% 0.00% -100.00% - -100.00% - -100.00% -100.00% -100.00% -100.00% -100.00% 180 3,000 800 500 100 $135 1,534 103 46 71 $ 4,580 $1,889 $ - -100.00% $ 45,217 35,017 $ - -100.00% $ CAPITAL OUTLAY Item Total Book5 2014 Requested $ 2014 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 4 06/14/2013 3:14 PM GENERAL FUND FINANCE 001-51201-415 Account Description Personnel Expense 1001 1003 1005 2001 2002 2004 2005 2006 Salaries Sal - Temp Sal - Overtime OASI State Retire Health Ins Income Protect State Comp Personnel Expense Operating Expense 3001 5401 5801 6001 6201 6401 2010 Actual 2011 Actual 288,604 207 20,750 26,125 31,165 1,920 546 310,606 1,000 551 22,370 29,888 34,451 1,767 540 $ Contractual serv Advertising Travel/training Office supplies Postage Books/Dues/Subscrip 369,317 $ 51,981 722 2,500 7,004 2,114 1,426 2013 YTD 04/30/13 2012 Actual 2013 Budget 401,173 $ 145,010 1,174 5,505 11,179 10,439 1,155 2014 Requested 2014 % Change 294,715 20,996 26,417 33,543 1,170 559 $ 282,119 21,582 30,751 8,418 1,413 641 $ 211,851 74 15,374 22,810 9,782 990 763 $ 286,753 21,937 32,403 11,421 1,439 727 1.64% 0.00% 0.00% 1.64% 5.37% 35.68% 1.85% 13.49% 377,401 $ 344,923 $ 261,644 $ 354,681 2.83% 132,350 750 1,220 9,000 9,100 980 106,841 129 2,141 8,527 10,123 1,397 128,761 750 1,220 10,700 10,100 765 -2.71% 0.00% 0.00% 18.89% 10.99% -21.94% 124,819 979 3,346 13,047 10,865 945 Operating Expense $ 65,747 $ 174,461 $ 154,001 $ 153,400 $ 129,159 $ 152,296 -0.72% Total Expenses $ 435,064 $ 575,634 $ 531,402 $ 498,323 $ 390,803 $ 506,977 1.74% CAPITAL OUTLAY 2014 Requested Items 0 0 Total Book5 $ 2014 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 5 06/14/2013 3:14 PM GENERAL FUND HUMAN RESOURCES 001-51301-415 Account Description 2010 Actual 2011 Actual 2012 Actual 155,798 8,315 7 12,012 14,094 10,283 975 310 10,390 5,224 1,601 3,300 2,400 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 - - - - 2013 YTD 04/30/13 2013 Budget 2014 Requested 2014 % Change 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 5201 5202 5401 5801 6001 6201 6401 $ Awards Program Safety/Wellness Prog HRA Claims Contractual serv Liability Insurance Insurance Claims Advertising Travel/training Office supplies Postage Books/Dues/Subscrip 224,710 $ 3,767 4,149 60,008 13,691 123,132 19,254 432 5,785 1,806 464 626 229,617 $ 231,869 5,153 610 66,947 21,327 113,162 45,168 115 8,529 1,455 324 1,153 $ 172,180 6,095 13,638 19,432 5,742 830 405 10,000 15,000 3,000 3,000 2,000 589,573 - $ 143,340 4,619 11,223 16,101 3,859 632 322 10,334 5,622 1,704 1,600 1,200 337,905 - $ 181,496 6,217 14,360 21,212 7,438 863 476 10,000 15,000 3,000 3,000 2,000 504,898 - 5.41% 0.00% 2.00% 0.00% 5.29% 9.16% 29.54% 3.94% 17.57% 0.00% 0.00% 0.00% 0.00% 0.00% -14.36% $ 840,896 $ 538,463 $ 769,960 -8.44% 5,400 3,200 35,600 132,300 50,000 1,000 4,000 2,000 300 1,190 -22.86% -3.03% 0.00% 8.17% 0.00% 0.00% 0.00% -11.11% 0.00% 0.00% -29.17% 4,327 2,434 3,141 40,564 84,182 24,476 6,927 1,602 471 2,247 7,000 3,300 32,910 132,300 50,000 1,000 4,500 2,000 300 1,680 4,856 1,907 821 30,617 142,104 15,714 444 2,212 3,568 282 1,339 Operating Expense $ 233,114 $ 263,941 $ 170,371 $ 234,990 $ 203,863 $ 234,990 0.00% Total Expense $ 457,824 $ 493,558 $ 402,240 $ 1,075,886 $ 742,325 $ 1,004,950 -6.59% Section 3 - Page 6 Book5 06/14/2013 3:14 PM GENERAL FUND HUMAN RESOURCES 001-51301-415 CAPITAL OUTLAY 2014 Requested Item 0 0 Total $ 2014 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 6 Book5 06/14/2013 3:14 PM MANAGEMENT INFORMATION SYSTEMS 001-51401-419 Account Description 2013 YTD 04/30/13 2014 2014 Requested % Change 94,651 12,122 80,069 476 11,060 16,846 11,518 541 175 $ $ $ 163,117 12,190 13,411 19,108 2,838 872 209 $ $ $ 46,143 10,911 51,171 532 7,730 11,835 1,752 377 142 $ 128,257 $ $ 19,756 11,323 16,725 5,761 710 180 -21.37% 0.00% 62.07% 0.00% -15.57% -12.47% 102.98% -18.57% -13.93% 227,458 $ 211,746 $ 130,593 $ 182,712 -13.71% -33.43% 1.01% 100.00% 100.00% 50.00% 34.62% 0.00% 0.00% 0.00% 0.00% 2011 Actual 2012 Actual 153,505 26,931 298 12,743 16,343 19,253 1,119 159 146,120 4,354 36,022 516 12,520 17,374 18,183 886 167 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 Personnel Expense 2013 Budget 2010 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 230,352 $ 236,143 $ 160,696 158,968 186,832 172,441 188,690 157,549 180,281 143,179 123,739 114,764 37,069 5,377 3,110 70 569 19,570 5,844 3,372 34 1,173 19,391 2,771 3,130 2,029 20,000 5,200 3,000 100 500 2,000 1,170 14,955 5,488 2,413 1,055 120,006 144,628 1,500 1,500 30,000 7,000 3,000 100 500 2,000 Operating Expense $ 365,859 $ 389,266 $ 373,560 $ 354,260 $ 263,585 $ 310,234 -12.43% Total Expense $ 596,211 $ 625,408 $ 601,018 $ 566,006 $ 394,178 $ 492,946 -12.91% CAPITAL OUTLAY Items Network Upgrade Computer Replacement (15) Printer Replacement (1) Battery Replacement (8) TOTAL Book5 2014 Requested 1,034,256 16,350 1,000 6,800 $ 1,058,406 Section 3 - Page 7 2014 Approved* $ *Budgeted in GF Department 1801 - 06/14/2013 3:14 PM 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 Book5 2011 Actual 2012 Actual 18,589 18,054 $ 1,424 35 23,775 1,381 31 3,470 18,157 5,703 1,708 43 25,610 $ 69,418 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 240,000 $ 8,000 5,000 3,000 4,000 2,500 2,500 2,500 2,500 2,500 2,500 21,250 20,000 55,999 13,917 64,275 20,000 13,000 774 13,344 5,108 1,673 120,000 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 205,861 - - - 114,918 - 341,175 407,673 252,505 272,467 1,035,372 Retirement Incentives Personnel Expense Operating Expense 3001 3004 3005 3101 3102 3103 3104 3105 3106 3107 3108 6401 7601 7602 7604 7621 7630 8003 8004 8005 8008 8101 8103 8104 8106 8109 9902 9904 9911 9912 9913 9914 9915 9916 9917 2010 Actual $ 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 Books Due & Subscription Misc. Council Projects Bus. Dist. Impr. Traffic Control Border Project Demolition Program DUSD Infra Improvement Reserve Fireworks DARC-Utilities Employee Reward Program Special Events Winter Visitor Expense 4th of July Expense Youth Activity Expense League of Cities Event Transfer to HURF Transfer to Capital Projects Transfer to Housing Transfer to Airport Transfer to Golf Course Transfer to RICO Transfer to Grants Transfer to MPC Transfer to Debt Service 43,824 58,333 10,080 52,398 4,031 3,520 958 (113) 1,985 26 1,233 996 18,868 3,333 4,395 6,245 $ 22,935 $ 2013 YTD 01/31/13 2013 Budget 18,000 $ $ 2014 Requested 15,025 1,026 33 - $ $ 16,084 $ 3,061 5,040 2,712 978 1,118 536 871 2,143 645 20,844 9,462 7,257 3,604 20,400 303 15,550 1,899 2,067 146,231 50,000 1,377 41 - 18,000 2014 % Change 1,377 46 - 0.00% 0.00% -100.00% 0.00% 11.33% 0.00% $ 19,423 -72.02% $ 5,000 3,000 4,000 2,000 2,000 2,000 2,000 2,000 2,000 21,250 185,000 51,249 513,716 82,331 321,547 1,149,223 45,780 41,022 252,300 210,250 15,000 62,686 70,000 15,000 1,000 16,000 4,000 1,000 2,200 120,000 27,402 125,420 94,715 319,912 1,158,134 266,865 929,021 188,525 324,537 1,373,580 0.00% -100.00% 0.00% 0.00% 0.00% -20.00% -20.00% -20.00% -20.00% -20.00% -20.00% 0.00% 825.00% -8.48% 0.00% -40.00% 0.00% 0.00% -25.00% 0.00% 0.00% -5.88% -100.00% -50.00% 0.00% 15.79% -100.00% 0.00% -100.00% -33.20% -50.29% 0.00% 99.04% 1.45% 18.60% 25,000 62,686 70,000 20,000 1,000 17,000 1,000 8,000 1,000 1,900 175,477 38,150 Operating Expense $ 533,295 $ 2,885,920 $ 2,433,870 $ 2,427,175 $ 1,689,009 $ 2,627,849 8.27% Total Expenses $ 577,119 $ 2,908,856 $ 2,459,481 $ 2,496,593 $ 1,705,093 $ 2,647,272 6.04% Section 3 - Page 8 06/14/2013 3:14 PM SPECIAL EVENTS SUPPORT FY 12/13 EVENT ROTARY - 2ND ANNUAL FLY IN DOUGLAS ART ASSOCIATION DARC TOTAL SPECIAL EVENTS Book5 AMOUNT REQUESTED $ 2,000 1,812 13,000 16,812 Section 3 - Page 8A AMOUNT RECOMMENDED $ 2,000 1,000 13,000 16,000 AMOUNT APPROVED $ - 06/14/2013 3:14 PM GENERAL FUND MAGISTRATE 001-51601-412 Account Description Personnel Expense 1001 1003 1005 2001 2002 2004 2005 2006 Salaries Sal - Temp Sal - Overtime OASI Retirement Health Ins Income Prot. State Comp Personnel Expense Operating Expense 3001 5801 6001 6201 6401 2013 YTD 04/30/13 2014 % Change 2011 Actual 2012 Actual 67,179 479 26 4,989 6,071 7,525 498 129 46,714 3,441 4,488 3,185 290 81 46,312 3,388 4,606 3,121 204 83 $ 36,629 7,757 3,395 3,993 1,762 189 101 $ 38,983 2,908 4,242 1,504 198 86 $ 37,689 6,490 3,380 4,259 2,325 195 112 2.90% -16.33% 0.00% -0.47% 6.67% 31.92% 2.90% 11.14% 57,715 $ 53,826 $ 47,921 $ 54,449 1.16% 15,000 - 0.00% 0.00% 0.00% 0.00% 0.00% $ Contractual Services Travel/Training Office Supplies Postage Books/Dues/Subscr. 86,895 $ 19,712 35 480 628 - 58,200 $ 15,000 41 208 647 25 2013 Budget 2014 Requested 2010 Actual 15,000 - 15,000 - 12,500 9 - Operating Expense $ 20,855 $ 15,922 $ 15,000 $ 15,000 $ 12,509 $ 15,000 0.00% Total Expense $ 107,750 $ 74,121 $ 72,715 $ 68,826 $ 60,430 $ 69,449 0.91% CAPITAL OUTLAY 2014 Requested Items 0 Total Book5 $ 2014 Approved* - $ Section 3 - Page 9 *Budgeted in GF Department 1801 - 06/14/2013 3:14 PM GENERAL FUND LIBRARY 001-51701-412 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 Salaries Salaries Temp Salaries Limited Salaries O/T OASI State Retire Health Ins Income Protect State Comp 2011 Actual 2012 Actual 187,381 36,065 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 $ 153,199 58,300 16,180 16,699 6,852 792 480 $ 183,045 $ 252,502 $ 16,452 16,953 14,198 1,307 858 Personnel Expense 2013 YTD 04/30/13 2010 Actual $ Operating Expense 3001 Contract Serv 4105 Utilities Utilities Gov Center 4302 Building Maintenance 5401 Advertising & Printing 5801 Travel/training 6001 Office supplies 6005 Library Materials 6201 Postage 6301 Small Tools & Eq 6401 Books/Dues/Subscrip 273,213 $ 249,264 $ 12,384 33,134 13,465 36,189 46,536 40,360 3,369 8,423 720 8,349 26,032 934 - 7,520 374 914 9,290 25,168 974 - 2013 Budget 2014 % Change 82,887 61,539 60 10,938 8,035 5,058 364 396 $ 127,438 38,000 12,656 14,400 9,298 659 420 -16.82% -34.82% 0.00% 0.00% -21.78% -13.76% 35.70% -16.82% -12.66% 169,278 $ 202,871 -19.66% 11,670 34,037 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -14.06% 0.00% 0.00% 0.00% -14.95% Operating Expense $ 82,753 $ 94,110 $ 131,135 $ 106,225 $ 80,146 15,770 40,000 6,000 5,500 2,000 7,500 24,455 1,000 $ 102,225 Total Expenses $ 355,966 $ 343,375 $ 314,180 $ 358,727 $ 249,424 $ 305,096 7,366 25,547 953 - 15,770 40,000 6,000 5,500 2,000 7,500 28,455 1,000 - 2014 Requested 7,994 13 381 9,537 15,367 943 204 - -3.77% CAPITAL OUTLAY 2014 Requested Items 0 Total Book5 $ 2014 Approved* - $ Section 3 - Page 10 *Budgeted in GF Department 1801 - 06/14/2013 3:14 PM GENERAL FUND COMMUNITY DEVELOPMENT NEIGHBORHOODS/GRANTS 001-52001-419 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 Operaitng Expense 3001 5401 5801 6001 6201 6301 6401 6500 6601 2010 Actual 2011 Actual 2012 Actual 2013 Budget 71,972 62 5,000 6,518 10,664 503 1,600 $ Contractual Services Advertising Travel/training Office supplies Postage Small Tools & Equipment Books/dues/subscrip Gas/oil/lube Uniform 96,319 55,674 281 3,787 5,377 6,758 321 1,417 $ 691 483 1,773 384 - 73,615 $ 2014 Requested 2014 % Change 48,357 50 3,379 4,822 5,835 201 1,093 $ 67,608 5,172 7,369 1,546 349 2,177 $ 49,196 1,378 3,366 5,539 1,126 243 1,617 $ - -100.00% 0.00% -100.00% -100.00% -100.00% -100.00% -100.00% 63,737 $ 84,222 $ 62,464 $ - -100.00% - - 0.00% -100.00% -100.00% -100.00% -100.00% 0.00% -100.00% -100.00% -100.00% 3,675 1,536 449 120 1,527 246 1,600 - 2013 YTD 04/30/13 74 622 457 1,541 318 101 1,348 196 865 500 1,000 700 500 1,000 250 1,108 211 35 186 113 1,322 197 - Operating Expense $ 4,931 $ 7,552 $ 4,657 $ 4,815 $ 3,172 $ - -100.00% Total Expenses $ 101,251 $ 81,167 $ 68,394 $ 89,037 $ 65,636 $ - -100.00% pg 14 CAPITAL OUTLAY Items Total Book5 2014 Requested 0 0 $ - 2014 Approved* *Budgeted in GF Department 1801 $ - Section 3 - Page 11 06/14/20133:14 PM GENERAL FUND CEMETERY 001-52021-452 Account Description Personnel Expense 1001 1003 1005 2001 2002 2004 2005 2006 Salaries Sal-Lim Sal-OT OASI State Retire Health Ins Income Protect Workman's Comp 2010 Actual Personnel Expense Operating Expense 3001 4105 4301 4302 5501 5801 6001 6002 6021 6301 6401 6501 6601 6701 $ Contractual Services Utilities Auto/equip Building Maintenance DOC Labor Travel/training Office supplies Operating supplies Chemicals Small tools & Eq Books/dues/subscrip Gas/oil/lube Uniforms Construction materials 2011 Actual 2012 Actual 2013 Budget 64,422 59,428 40,397 305 4,404 5,856 12,835 460 2,454 1,005 3,776 5,807 12,441 374 2,122 661 2,606 4,079 10,310 196 1,589 90,736 $ 430 3,324 1,424 2,734 122 417 1,825 2,335 1,114 2,467 552 5,130 Operating Expense $ 21,443 Total Expense $ 112,179 84,953 $ 230 4,322 2,191 2,900 107 3,075 1,461 577 3,326 434 3,871 $ 59,838 2013 YTD 04/30/13 2014 Requested 2014 % Change $ $ 27,903 10,920 500 3,008 4,286 783 172 1,607 $ $ 25,839 1,757 286 1,860 3,034 834 137 1,500 $ $ 33,095 45,685 500 6,065 8,959 1,112 282 2,057 18.60% 318.36% 0.00% 101.61% 109.01% 42.03% 64.24% 28.00% $ 49,179 $ 35,249 $ 97,754 98.77% 1,160 4,536 1,067 3,088 122 55 4,784 4,788 461 63 6,011 285 3,735 $800 3,500 3,500 2,500 150 250 3,000 1,500 500 2,500 600 4,000 $425 6,573 2,537 3,228 72 385 4,883 1,804 485 8,638 865 5,535 $800 3,500 3,000 3,500 2,500 150 250 2,000 3,000 1,000 5,000 1,050 4,000 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% -33.33% 100.00% 100.00% 0.00% 100.00% 75.00% 0.00% $22,800 $35,430 $29,750 30.48% 70,679 $ 127,504 77.14% 22,265 $ 30,155 $ 107,218 $ 89,993 2014 Requested 10,000 2,000 6,000 375,000 $ 393,000 2014 Approved* *Budgeted in GF Department 1801 $ - $ 71,979 $ CAPITAL OUTLAY Items 0 Ride Mower Chain Link fencing Upgrade Restrooms Chip Seal Project TOTAL Book5 Section 3 - Page 12 06/14/2013 3:14 PM GENERAL FUND PARKS 001-52023-452 Account Description Personnel Expense 1001 1003 1004 1005 2201 2002 2004 2005 2006 Salaries Sal-Temp Sal-Lim Sal-OT OASI State Retire Health Ins Income Protect Workman's Comp Book5 2014 Requested 2014 % Change 218,065 73,339 500 22,331 32,985 11,421 1,271 10,396 -10.60% 0.00% -23.00% 0.00% -14.06% -10.90% 24.14% -9.64% -8.71% 243,908 910 21,900 27,915 51,899 2,219 8,588 213,710 2,186 80,754 913 21,305 27,239 36,299 1,096 7,026 95,239 500 25,983 37,022 9,201 1,407 11,387 179,763 86,739 1,006 19,614 29,113 8,500 1,119 8,662 $ 420,965 $ 396,041 $ 390,529 $ 424,647 $ 334,515 $ 370,308 -12.80% 74 37,336 1,131 46,201 31,249 10,437 1,092 57 766 7,900 607 13,809 35,931 1,231 43,010 23,157 12,368 825 451 15,886 4,818 87 17,720 36,389 1,737 44,415 11,741 11,066 723 611 27,748 6,773 472 23,444 500 30,000 1,000 42,000 12,000 10,000 1,000 500 21,000 8,000 1,000 14,000 28,036 1,182 23,816 13,531 7,968 390 801 22,656 8,629 1,097 18,673 3,162 7,685 2,138 3,961 2,698 3,215 3,000 4,000 2,702 3,441 500 35,000 1,000 42,000 9,000 14,000 10,000 1,500 500 26,000 8,000 3,000 16,000 2,000 3,150 4,000 0.00% 16.67% 0.00% 0.00% 100.00% 16.67% 0.00% 50.00% 0.00% 23.81% 0.00% 200.00% 14.29% 100.00% 5.00% 0.00% Operating Expense $ 161,505 $ 161,584 $ 171,031 $ 148,000 $ 132,921 $ 175,650 18.68% Total Expenses $ 582,470 $ 557,625 $ 561,561 $ 572,647 $ 467,436 $ 545,958 -4.66% Contractual Services Electric Gas Water/Sewer/Sanitation Auto/equip Building Maintenance DOC Labor Travel/training Office supplies Operating supplies Supplies/Chemicals Small tools Gas/oil/lube Diesel/Oil Uniforms Construction materials 307,534 2013 YTD 04/30/13 242,407 3,276 51,217 1,333 20,839 26,405 41,767 1,578 7,219 Personnel Expense Operating Expense 3001 4101 4102 4103 4301 4302 5501 5801 6001 6002 6021 6301 6501 6502 6601 6701 2010 Actual 2011 Actual 2012 Actual 2013 Budget Section 3 - Page 13 pg 16 06/14/2013 3:14 PM GENERAL FUND PARKS 001-52023-452 CAPITAL OUTLAY Items 2 Ride Mowers 54" Cut - motors 2 Gator Utility Vehicle Roof for Paseo and Airport Pump House 11 radios 18 weed eaters Total Book5 2014 Requested 20,000 18,000 6,000 6,000 5,400 $ 50,000 2014 Approved* *Budgeted in GFDepartment 1801 10,000 $ Section 3 - Page 13 10,000 06/14/2013 3:14 PM GENERAL FUND RECREATION 001-52031-451 Account Descriptions Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 Salaries Salaries/Temp Salaries LTD Salaries Overtime O.A.S.I. Retire-State Health Insurance Income Protection Workman's Compensation 2010 Actual 2011 Actual 2012 Actual 2013 Budget 27,288 47,482 10,275 1,149 6,369 4,342 6,104 270 2,423 Personnel Expense Operating Expense 4105 4301 4302 5401 5801 6001 6007 6201 6401 6501 6601 $ 105,702 Utilities Auto & Equipment Building Maintenance Advertising & Printing Travel & Training Office Supplies Recreation Cost Postage Books/Dues/Subscriptions Gas/Oil/Lubricants Uniforms 15,533 44,346 9,522 459 5,150 2,459 3,209 121 1,683 $ 11,754 3,816 971 $ 11,507 3,758 2,050 375 2,846 10,602 8 541 652 2,136 5,581 6 635 693 25,593 82,481 $ 32,340 2014 Requested 2014 % Change 17,319 41,152 16,078 357 5,525 3,368 3,637 117 1,791 $ 17,816 32,000 12,927 500 4,838 4,097 391 124 2,120 $ 15,070 32,397 14,441 506 4,635 3,882 417 114 1,963 $ 38,000 22,108 500 4,636 3,246 54 2,158 -100.00% 18.75% 71.02% 0.00% -4.17% -20.77% -100.00% -56.36% 1.80% 89,343 $ 74,814 $ 73,426 $ 70,703 -5.50% 3,000 1,000 1,500 2,000 750 1,000 15,000 50 500 600 -70.00% 100.00% -50.00% 0.00% -25.00% -44.44% 11.11% 0.00% -100.00% -33.33% -33.33% 11,577 2,017 3,478 2,502 14,050 7 468 533 $ 2013 YTD 04/30/13 34,633 10,000 3,000 2,000 1,000 1,800 13,500 50 375 750 900 Operating Expense $ Total Expenses $ 131,295 $ 114,821 2014 Requested 2014 Approved* *Budgeted in GF Department 1801 $ 123,976 $ 7,410 1,936 3,170 1,152 9,386 394 461 33,375 $ 23,910 $ 25,400 -23.90% $ 108,189 $ 97,336 $ 96,103 -11.17% CAPITAL OUTLAY Items 0 0 Total Book5 $ - $ - Section 3 - Page 14 06/14/2013 3:14 PM GENERAL FUND AQUATICS 001-52035-451 Account Description Personnel Expense 1001 1003 1004 1005 1006 2001 2002 2004 2005 2006 Salaries Salaries/Temp Salaries/Lim Salaries/OT Salaries/Reimbursement OASI State Retire Health Ins Income Protect Workman's Comp Personnel Expense Operaitng Expense 3001 4105 4106 4108 4301 4304 5401 5801 6001 6007 6011 6012 6013 6501 6601 Book5 2010 Actual 2011 Actual 2012 Actual 72,776 74,062 13,208 333 3,276 11,949 5,607 13,019 473 4,654 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 $ 69,181 70,000 500 10,000 11,451 7,595 3,524 359 5,621 187,165 $ 178,230 $ Contractual Services Utilities Utilities-Aquatic Center Utilities-8th Street Auto & Eq Maintenance Maint.Cost-Aquatic Center Advertising & Printing Travel/training Office supplies Recreation Cost Swimming Pool Aquatic Center Concession Aquatic Center-Pro Shop Gas/oil/lube Uniforms 199,358 $ 165,796 $ 2013 Budget 2013 YTD 04/30/13 $ 56,715 78,617 247 7,958 10,972 6,577 3,756 293 4,484 3.51% 7.14% 100.00% 0.00% 0.00% 15.96% 31.77% 31.92% 3.49% 37.53% $ 169,619 $ 209,607 17.60% 1,030 4,000 45,000 10,000 1,000 17,000 500 1,150 1,500 1,000 7,000 500 500 2,200 2,000 41.10% 14.29% -10.00% 0.00% 100.00% 6.25% -50.00% 0.00% 0.00% 0.00% 0.00% -50.00% -50.00% 29.41% 0.00% 94,380 -3.28% $ 303,987 10.22% 230 4,349 43,376 297 4,811 51,417 8,488 730 3,500 50,000 10,000 $921 4,526 38,180 7,618 14,521 794 1,838 1,421 11,222 373 1,540 1,885 1,931 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,000 1,000 1,150 1,500 1,000 7,000 1,000 1,000 1,700 2,000 13,017 140 1,883 452 5,162 62 1,776 1,856 $97,580 $75,592 275,810 $ 245,211 $ 115,411 $ 93,004 $ 99,192 Total Expenses $ 314,768 $ 258,800 $ 286,356 Section 3 - Page 15 $ $ 2014 % Change 71,606 75,000 16,464 500 10,000 13,278 10,008 4,649 371 7,730 127 8,225 71,535 Operating Expense 2014 Requested $ pg 19 06/14/2013 3:14 PM GENERAL FUND AQUATICS 001-52035-451 CAPITAL OUTLAY Items 2014 Requested Roof repairs Baby pool coverage/roof POS System Total Book5 2014 Approved* 7,000 6,500 8,750 $ 22,250 *Budgeted in GF Dept 1801 7,000 $ Section 3 - Page 15 7,000 06/14/2013 3:14 PM GENERAL FUND PUBLIC WORKS ADMINISTRATION 001-54001-431 Account Description 2014 % Change 2012 Actual 258,085 18,530 22,100 27,199 1,603 5,948 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 $ 133,908 3,770 10,532 14,596 2,544 692 4,236 $ 60,219 123 10,817 5,186 6,622 1,464 277 1,732 $ 111,909 8,561 12,646 3,386 579 3,822 -16.43% -100.00% 0.00% 0.00% -18.72% -13.36% 33.08% -16.43% -9.76% 177,827 $ 170,279 $ 86,441 $ 140,903 -17.25% 1,500 1,000 3,000 5,000 500 600 450 90 1,790 2,200 600 - -100.00% 100.00% 0.00% 0.00% -25.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 150.00% 0.00% 0.00% $ Operating Expense 3001 Contractual serv 4301 Auto/Equip 5401 Advertising & Printing 5501 DOC Labor 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 333,464 $ 5,931 1,928 3,482 5,314 2,116 420 41 317 1,823 362 2,034 8,983 212,536 $ 888 642 4,034 4,862 669 395 71 1,058 1,181 213 477 972 2013 Budget 2014 Requested 2011 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 Personnel Expense 2013 YTD 04/30/13 2010 Actual 1,805 3,739 6,014 727 479 177 3,194 1,634 33 - 700 1,000 4,000 5,000 500 600 450 90 1,790 2,200 240 - 602 1,930 3,029 758 291 331 435 1,387 159 1,530 1,209 Operating Expense $ 32,751 $ 15,462 $ 17,802 $ 16,570 $ 11,662 $ 16,730 0.97% Total Expenses $ 366,215 $ 227,998 $ 195,629 $ 186,849 $ 98,103 $ 157,633 -15.64% CAPITAL OUTLAY 2014 Requested Items 0 0 Total Book5 $ 2014 Approved* - $ Section 3 - Page 16 *Budgeted in GF Department 1801 - 06/14/2013 3:14 PM GENERAL FUND PW CONSTRUCTION 001-54018-431 Account Description Personnel Expense 1001 1004 1005 2001 2002 2004 2005 2006 Salaries Salaries - Limited Sal-OT OASI State Retire Health Ins Income Protect State Comp Personnel Expense Operating Expense 3001 4101 4102 4103 4301 4305 5501 5801 6001 6002 6301 6302 6501 6502 6601 6699 6703 6705 2013 YTD 04/30/13 2010 Actual 2011 Actual 2012 Actual 2012 Budget 160,040 82,417 988 17,685 22,011 21,902 1,436 16,608 $ Contractual services Utilities-Electric (City Hall) Utilites-Gas (City Hall) Utilites-Water/Sewer/San Auto/Equip City Hall Maintenance DOC Labor Travel/training Office supplies Operating supplies Small tools Safety Equipment Gas/oil/lube Diesel/Oil/Lube Uniforms Construction Materials Graffiti Abatement Supplies DOC Supplies 323,086 170,778 69,236 1,572 17,466 23,214 22,913 1,205 14,862 $ 321,246 $ 2014 Requested 2014 % Change 193,680 34,985 1,404 16,473 22,821 28,197 947 13,446 $ $ 216,703 1,000 16,654 23,730 7,309 1,123 12,330 $ $ 157,031 4,286 11,519 16,991 7,518 772 8,454 $ $ 231,110 1,000 17,756 26,228 10,334 1,197 14,512 6.65% 0.00% 0.00% 6.62% 10.53% 41.40% 6.63% 17.69% 311,953 $ 278,848 $ 206,571 $ 302,139 8.35% 46,569 27,000 4,500 2,500 4,500 10,000 20,000 2,000 1,350 1,000 450 6,000 450 2,100 3,200 4,500 8,000 -27.07% 0.00% 0.00% 0.00% 100.00% 0.00% -42.86% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 16.67% 0.00% 0.00% -20.00% 14,593 35,273 2,659 3,143 20,122 33,794 2,801 2,148 48,654 28,317 3,028 1,896 63,858 27,000 4,500 2,500 46,209 24,221 2,367 1,713 14,506 31,183 558 3,114 523 4,268 1,678 851 - 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 10,000 35,000 2,000 1,350 1,000 450 6,000 450 1,800 3,200 4,500 10,000 20,859 11,234 100 49 568 633 260 5,105 1,921 110 4,299 Operating Expense $ 112,349 $ 145,626 $ 155,069 $ 173,608 $ 119,648 $ 144,119 -16.99% Total Expenses $ 435,435 $ 466,872 $ 467,022 $ 452,456 $ 326,219 $ 446,258 -1.37% pg 17 CAPITAL OUTLAY Items Generator Air Handler Total Book5 2014 Requested 58,221 57,000 $ 115,221 Section 3 - Page 17 2014 Approved* $ *Budgeted in GF Department 1801 - 06/14/2013 3:14 PM GENERAL FUND PUBLIC WORKS FLEET MAINTENANCE 001-54031-431 Account Description Personnel Expense 1001 1005 2001 2002 2004 2005 2006 Salaries Sal-OT OASI State Retire Health Ins Income Protect State Comp Personnel Expense Operating Expense 3001 4105 4301 5801 6001 6002 6301 6302 6401 6501 6601 Contractual Services Utilities Auto/Equip Travel/training Office supplies Operating supplies Small tools Safety Equipment Books/Dues/Subscrip Gas/oil/lube Uniforms Operating Expense Total Expenses 2013 YTD 04/30/13 2014 % Change 2011 Actual 2012 Actual 161,882 11,596 14,646 18,133 1,132 3,965 135,842 10,211 12,604 14,397 801 3,080 89,161 914 6,735 7,494 9,456 334 1,613 $ 88,668 500 6,821 9,719 3,785 460 2,585 $ 62,293 731 4,652 6,875 2,414 311 1,768 $ 136,243 1,000 10,499 15,508 6,317 707 4,540 53.65% 100.00% 53.91% 59.56% 66.89% 53.78% 75.65% 115,706 $ 112,538 $ 79,044 $ 174,813 55.34% $ 211,354 $ 176,935 $ 2013 Budget 2014 Requested 2010 Actual 662 6,930 87,164 565 4,038 3,221 2,027 4,873 1,168 487 6,484 96,174 21 1,351 3,674 1,685 2,084 8,031 722 38,580 4,983 86,512 140 1,261 2,392 2,588 386 800 4,087 724 $41,649 6,750 80,000 1,000 900 2,700 2,500 450 2,000 4,300 900 $2,009 3,704 72,917 1,052 2,390 2,502 279 275 2,751 850 $2,247 6,750 4,000 1,000 900 2,700 2,500 450 1,000 4,300 1,050 -94.60% 0.00% -95.00% 0.00% 0.00% 0.00% 0.00% 0.00% -50.00% 0.00% 16.67% $110,647 $120,714 $142,453 $143,149 $88,729 $26,897.00 -81.21% 201,710 -21.11% $ 322,001 $ 297,649 $ 258,159 $ 255,687 $ 167,773 $ CAPITAL OUTLAY Items 2014 Requested Replace Four Post Lift Total Book5 2014 Approved 17,000 $ 17,000 *Budgeted in GF Department 1801 $ Section 3 - Page 18 - 06/14/2013 3:14 PM GENERAL FUND FIRE 001-55001-422 Account Description Personnel Expense 1001 1003 1004 1005 2001 2002 2003 2004 2005 2006 Salaries Temporary Limited Sal-OT OASI State Retirement State Retire/PS Health Ins Income Protect Workman's Comp Personnel Expense 2010 Actual 2011 Actual 555,892 27,204 549,302 65,536 55,154 10,961 2,709 181,125 53,602 2,195 22,289 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 961,967 $ 1,059,881 $ 1,022,566 15,725 2,449 1,767 19,921 13,554 2,829 1,619 19,888 17,118 8,292 2,739 18,102 10,098 9,242 567 4,069 3,085 606 973 311 2,210 718 13,110 10,549 1,420 8,370 656 4,299 1,500 5,953 4,951 442 3,066 238 3,395 349 688 15,768 7,504 238 12,583 824 17,214 1,003 2,924 5,676 420 3,263 2,451 505 1,203 19,530 12,378 119 20,770 5,000 3,000 18,000 4,500 500 6,536 250 1,500 3,000 300 300 500 2,000 500 1,025 13,000 12,708 500 500 $ Operating Expense 3001 3401 3402 4105 4301 4302 5301 5801 5802 6001 6002 6201 6301 6302 6303 6304 6401 6501 6601 Contract. Serv. Community Training Public Education Utilities Auto/equip Building 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 911,133 Operating expense $ 96,820 Total Expense $ 1,007,952 $ $ 95,308 $ 1,057,275 2012 Actual $ 126,343 $ 1,186,224 2013 YTD 04/30/13 2013 Budget $ $ 621,417 7,000 $ $ $ 50,000 12,845 3,859 265,663 22,387 2,429 36,966 $ 94,389 $ 1,116,955 $ $ 2014 Requested 534,289 5,988 77,694 10,878 3,313 240,227 21,589 1,816 32,689 $ $ 50,000 12,071 4,079 272,053 22,335 2,260 44,213 -4.11% -12.77% 0.00% 0.00% -6.02% 5.71% 2.41% -0.23% -6.96% 19.61% 928,483 $ 1,009,019 -1.32% 23,191 9,501 2,875 15,564 11,601 679 15,892 727 5,573 1,075 399 1,607 782 2,949 913 1,143 17,065 10,130 115 89 21,170 5,000 3,000 18,000 14,000 4,500 500 8,000 250 1,500 3,000 300 300 500 2,000 500 1,025 14,000 12,858 500 500 1.93% 0.00% 0.00% 0.00% 100.00% 0.00% 0.00% 22.40% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 7.69% 1.18% 0.00% 0.00% 111,403 18.03% $ 1,120,422 0.31% 121,872 $ 1,050,354 $ 595,901 6,106 2014 % Change pg 23 Section 3 - Page 19 Book5 06/14/2013 3:14 PM GENERAL FUND EMS 001-55052-422 Account Description Personnel Expense 1001 1005 2001 2003 2004 2005 2006 Salaries Sal-OT OASI State Retire-PS Health Ins Income Protect Workman's Comp Personnel Expense Operating Expense 3001 4301 4302 5301 5801 5802 6001 6002 6201 6301 6302 6401 6501 6601 2010 Actual 2011 Actual 2012 Actual 647,996 82,067 8,183 187,885 64,595 2,074 26,672 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 997,358 14,123 178 2,082 53 1,002 26,312 46 138 16,670 1,996 $ 1,019,471 Contract. Services 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 $ 39,763 57 618 110 2,166 33,735 426 405 707 12,672 660 Operating Expense $ 91,318 Total Expenses $ 1,110,789 $ 62,600 $ 1,059,958 2012 Budget 2014 Requested 2014 % Change 645,985 50,000 10,481 267,415 13,916 2,074 40,346 $ 535,671 84,089 7,722 235,685 14,619 1,436 34,546 $ 681,179 50,000 10,602 324,359 22,386 2,246 52,886 5.45% 0.00% 1.16% 21.29% 60.86% 8.33% 31.08% $ 1,041,365 $ 1,030,217 $ 913,768 $ 1,143,658 11.01% 1,900 128 5,868 66 456 50,812 6 335 10 50 17,970 - 7,800 - 7,113 3,593 186 556 48,641 26 394 63 50 13,988 - 11,500 6,000 400 5,500 250 3,000 35,000 300 200 150 1,550 15,000 - 47.44% 100.00% 0.00% 0.00% 0.92% 0.00% 0.00% 16.67% 0.00% 0.00% 0.00% 0.00% 7.14% 0.00% 78,850 24.96% $ 1,222,508 11.82% $ 77,601 $ 1,118,967 $ 2013 YTD 04/30/13 400 5,450 250 3,000 30,000 300 200 150 1,550 14,000 $ 63,100 $ 1,093,317 $ 74,611 $ 988,379 $ pg 24 Section 3 - Page 20 Book5 06/14/2013 3:14 PM GENERAL FUND EMS 001-55052-422 CAPITAL OUTLAY Items Multi use vehicle or Fire/HazMat/EMS Type 2 EMS Unit Fire Pumper Fire Hose Office Furniture New Roof Exterior Paint TOTAL 2014 Requested 65,000 230,000 450,000 5,000 5,000 20,000 5,000 $ 780,000 2014 Approved* $ *Budgeted in GF Department 1801 60,000 5,000 65,000 Section 3 - Page 20 Book5 06/14/2013 3:14 PM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 Account Description Personnel Expense 1001 1002 1005 1006 2001 2002 2003 2004 2005 2006 Salaries Salaries-Civilian Sal-OT Sal - Reimbursed OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp Personnel Expense Operating Expense 3001 4105 4301 4302 4303 5501 5801 6001 6002 6201 6401 6501 6601 8108 2010 Actual 2011 Actual 146,733 70,422 1,008 12,334 14,320 7,306 9,576 20,413 852 5,066 155,691 37,597 1,519 12,397 11,424 4,661 14,618 19,385 605 5,213 $ Contract. Serv. Utilities Auto/equip Building Maintenance Auction-related expenses DOC Labor Travel/training Office supplies Operating supplies Postage Books/dues/subscrip Gas/oil/lube Uniforms Explorer Program 288,031 $ 263,111 2012 Actual 108,226 $ 38,068 484 11,584 10,845 4,993 (372) 14,599 338 3,781 $ 192,546 54,494 38,594 72,106 40,981 59,752 36,886 5,268 3,123 2,391 2,558 6,549 7,635 834 583 3,971 1,695 - 7,126 1,993 2,842 2,143 9,165 13,873 1,428 975 3,589 965 - 12,810 13,877 2,712 2,193 10,527 8,538 958 1,112 2,076 1,003 - $ 89,942 37,967 - $ 4,209 4,138 32,460 1,616 369 3,705 174,407 $ 90,670 35,000 6,000 1,000 2,400 1,000 8,000 12,650 600 700 2,000 760 1,000 2014 Requested 50,523 32,690 327 11,248 6,649 4,816 1,349 244 1,525 $ 109,371 $ 78,496 27,810 12,890 3,817 1,490 1,018 10,276 15,104 1,423 1,180 1,406 917 - 43,158 38,337 - 2014 % Change pg 25 3,559 4,332 17,030 1,693 371 1,929 -52.02% 0.97% 0.00% 0.00% -15.45% 4.68% -47.54% 4.76% 0.52% -47.93% 110,409 -36.69% 91,484 35,000 500 7,000 1,000 5,500 8,000 11,650 1,000 1,210 2,000 760 1,000 0.90% 0.00% 100.00% 16.67% 0.00% -100.00% 450.00% 0.00% -7.91% 66.67% 72.86% 0.00% 0.00% 0.00% Operating Expense $ 127,694 $ 157,188 $ 152,443 $ 161,780 $ 155,827 $ 166,104 2.67% Total Expenses $ 415,725 $ 420,299 $ 344,989 $ 336,187 $ 265,198 $ 276,513 -17.75% Section 3 - Page 21 Book5 2013 YTD 04/30/13 2013 Budget 06/14/2013 3:14 PM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 CAPITAL OUTLAY Items 50 Portable Battery Replacement 3 2014 Tahoes 2 AC/Heaters Roof Repair 37 Level IV Ballistic Carriers Metal Building for Evidence Total 2014 Requested 10,000 120,000 35,000 18,000 18,000 40,000 $ 165,000 2014 Approved* $ Section 3 - Page 21 Book5 *Budgeted in GF Department 1801 120,000 17,000 18,000 18,000 137,000 06/14/2013 3:14 PM GENERAL FUND POLICE OPERATIONS 001-56041-421 Account Description Personnel Expense 1001 1002 1005 1006 2001 2002 2003 2004 2205 2006 Salaries Salaries-Civilian Sal-OT Sal - Reimbursed OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp Personnel Expense Operating Expense 4301 4302 5801 6501 6601 Book5 2010 Actual 2011 Actual 2012 Actual 2013 Budget 2013 YTD 04/30/13 2014 Requested 1,234,902 53,393 86,345 272,763 24,771 4,874 344,201 155,767 4,732 55,919 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,182,737 17,198 70,000 280,000 23,540 1,875 494,443 25,874 4,236 62,358 $ 1,003,416 15,137 49,316 250,443 18,983 1,580 406,185 31,049 3,071 51,912 $ 1,182,215 19,136 70,000 280,000 23,681 2,162 579,627 37,596 4,246 65,854 -0.04% 11.27% 0.00% 0.00% 0.60% 15.35% 17.23% 45.31% 0.24% 5.61% $ 2,237,666 $ 2,192,277 $ 2,065,466 $ 2,162,260 $ 1,831,093 $ 2,264,518 4.73% 22,500 3,237 72,323 21,991 141 3,363 83,078 9,671 7,087 90,289 22,205 2,500 79,500 20,670 1 4,064 68,568 17,994 2,500 79,500 18,910 100.00% 0.00% 0.00% 0.00% -8.51% 123,410 20.20% $ 2,387,928 5.43% Auto/equip Maintenance Cost Travel/training Gas/oil/lube Uniforms Operating Expense $ 97,550 Total Expenses $ 2,335,217 $ 96,254 $ 2,288,530 $ 119,581 $ 2,185,047 Section 3 - Page 22 $ 102,670 $ 2,264,930 $ 90,627 $ 1,921,719 $ 2014 % Change pg 26 06/14/2013 3:14 PM GENERAL FUND POLICE SUPPORT 001-56071-421 Account Description 2010 Actual 2011 Actual 2012 Actual 2013 YTD 04/30/13 2013 Budget 2014 Requested 2014 % Change pg 27 . Personnel Expense 1001 1002 1005 1006 2001 2002 2003 2004 2005 2006 Operating Expense 4301 5801 6501 6601 Book5 Salaries Salaries-Civil Sal-OT Sal - Reimbursed OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp 395,629 265,494 72,503 93,489 27,253 28,120 110,412 79,599 3,255 17,685 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 $ 1,093,440 $ 1,174,639 $ 1,453,050 $ 1,337,689 2,257 14,164 6,207 3,699 16,293 2,767 2,435 27,196 8,599 2,000 18,000 9,440 Auto/equip Travel/training Gas/oil/lube Uniforms Operating Expense $ 22,628 Total Expenses $ 1,116,068 $ 22,759 $ 1,197,398 $ 38,230 $ 1,491,279 Section 3 - Page 23 $ $ 464,382 344,002 45,000 120,000 45,672 37,496 227,144 23,162 3,333 27,498 29,440 $ 1,367,129 $ 478,297 347,190 45,000 120,000 46,118 39,233 250,369 31,281 3,350 29,655 3.00% 0.93% 0.00% 0.00% 0.98% 4.63% 10.23% 35.05% 0.49% 7.85% $ 1,230,179 $ 1,390,493 3.95% 1,538 22,263 7,300 5,000 2,000 18,000 9,440 100.00% 0.00% 0.00% 0.00% 34,440 16.98% $ 1,424,933 4.23% $ 379,224 274,098 110,629 146,077 33,257 37,842 200,876 21,594 2,588 23,994 31,101 $ 1,261,280 $ $ 06/14/2013 3:14 PM GENERAL FUND POLICE HUMANE 001-56091-421 Account Description 2010 Actual 2011 Actual 2012 Actual 2013 Budget 82,437 - 69,178 2,518 65,353 12,901 2,622 6,063 7,700 8,331 599 1,650 3,085 5,239 6,940 7,892 441 1,298 6,433 5,905 6,558 8,460 282 1,478 62,257 26,045 1,000 6,832 9,734 2,545 387 2,173 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 Personnel Expense $ Operating Expense 3001 Contractual Services 4301 Auto/equip 4302 Maintenance Cost 5801 Travel/training 6001 Office Supplies 6002 Operating Supplies 6401 Books/dues/subscrip 6501 Gas/oil/lube 6601 Uniforms Book5 109,402 $ 96,591 $ 107,371 $ 110,973 2013 YTD 04/30/13 2014 Requested 50,955 667 11,738 1,498 4,492 6,991 2,565 290 1,276 $ 80,473 38,285 40,020 42,200 41,720 35,317 1,122 428 4,182 2,520 415 1,679 890 4,453 3,188 115 1,827 1,127 270 5,821 2,982 712 1,500 500 4,500 35 2,500 690 1,398 549 4,804 $ 2,406 796 2014 % Change 62,667 25,301 1,000 6,806 10,053 3,436 387 2,158 0.66% 0.00% -2.86% 0.00% -0.37% 3.28% 35.03% 0.09% -0.69% 111,809 0.75% 41,720 1,500 1,500 500 4,500 35 2,500 690 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense $ 46,952 $ 50,345 $ 54,939 $ 51,445 $ 45,270 $ 52,945 2.92% Total Expenses $ 156,353 $ 146,935 $ 162,310 $ 162,418 $ 125,743 $ 164,754 1.44% Section 3 - Page 24 06/14/2013 3:14 PM GENERAL FUND CALL CENTER 001-57081-419 Account Description Personnel Expense 1001 1004 1005 2001 2002 2004 2005 2006 Salaries Salaries - Limited Salaries O/T OASI State Retire Health Insurance Income Protect State Comp Personnel Expense Operating Expense 3001 4105 4302 5201 6002 6501 6502 6701 7831 8512 8901 Book5 2010 Actual $ Contract Serv Utilities Building Maintenance Liability Insurance Operating Supplies Gas/Oil/Lube Diesel/Oil Construction Materials IT Equipment Grant Match Depreciation 2011 Actual - - - - - $ - 2012 Actual 0 4,304 34 330 437 9 141 $ 5,255 104,390 461 23,099 23,441 - 77,404 20,255 20,772 1,058 3,592 38,016 9,344 20,320 592 3,759 142 56,398 31,936 - - - 2013 YTD 04/30/13 2013 Budget 8,427 645 919 196 44 328 $ 10,558 2014 Requested 2014 % Change 8,510 651 962 581 44 401 0.99% 0.00% 0.00% 0.99% 4.69% 196.92% 0.99% 22.11% $ 11,149 5.60% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.88% 2,501 4,286 519 739 156 22 259 $ 20,000 11,000 21,300 100 4,000 - 8,481 Operating Expense $ 239,867 $ 123,081 $ 72,031 $ 56,400 $ 49,868 $ 20,000 11,000 21,300 100 4,000 56,400 Total Expenses $ 239,867 $ 123,081 $ 77,286 $ 66,958 $ 58,349 $ 67,549 Section 3 - Page 25 21,911 5,709 22,211 37 - pg 37 0.00% 06/14/2013 3:14 PM GENERAL FUND TRANSIT -- Account Descriptions 2010 Actual 2011 Actual 2012 Actual 2013 Budget 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 5201 5401 5801 6001 6002 6201 6501 6601 8003 $ - $ - $ Contractual Services Telephone Utilities Auto & Equipment Building Maintenance Liability Insurance Advertising & Printing Travel & Training Office Supplies Operating Supplies Postage Gas/Oil/Lubricants Uniforms Contingency - 35 2013 YTD 04/30/13 2014 Requested 2014 % Change pg 18 $ 192,085 14,695 20,937 5,872 993 6,502 1,700 48,715 $ 46,530 7,607 75,636 1,291 9,710 13,362 10,736 535 4,080 811 $ 233,178 17,838 26,349 15,872 1,205 7,862 1,700 25,668 21.39% 0.00% 0.00% 0.00% 21.39% 25.85% 170.32% 21.39% 20.92% 0.00% -47.31% $ 291,499 $ 170,299 $ 329,673 13.10% 4,600 5,300 17,000 6,000 10,000 1,000 1,500 500 3,500 50 50,000 1,500 18,533 $5,993.04 3,788 6,171 37 583 3,052 817 743 136 22,229 753 - 4,930 6,400 3,250 30,000 10,500 15,500 500 3,750 950 4,500 50 75,000 2,000 19,450 7.17% 20.75% 100.00% 76.47% 75.00% 55.00% -50.00% 150.00% 90.00% 28.57% 0.00% 50.00% 33.33% 4.95% Operating Expense $ - $ - $ 35 $ 119,483 $44,301.53 $ 176,780 47.95% Total Expenses $ - $ - $ 35 $ 410,982 $ 214,600 $ 506,453 23.23% CAPITAL OUTLAY Items 2 Buses 0 Total Book5 2014 Requested 2014 Approved* *Budgeted in GF Department 1801 160,000 $ 160,000 160,000 $ 160,000 Section 3 - Page 26 06/14/2013 3:14 PM GENERAL FUND CAPITAL EXPENDITURES 001-51801-419 Account Description 7701 7702 7703 7704 7705 7706 7707 7708 7709 7710 7711 7712 7713 7714 7716 7717 7718 7719 7721 7722 ADMINISTRATION FINANCE MANAGEMENT INFO SYSTEMS HUMAN RESOURCES MAGISTRATE COURT CEMETERY FIRE POLICE COMMUNITY DEVELOPMENT ECONOMIC DEVELOPMENT RECREATION PARKS AQUATICS PW ADMINISTRATION PW FLEET MAINTENANCE LIBRARY CD CONSTRUCTION VISITOR CENTER CALL CENTER MIS - COMPUTER REPLACEMENT TRANSIT 2010 Actual 2011 Actual 11,456 31,079 971 11,824 16,557 2,614 5,929 13,140 2013 Budget 2014 Requested 2014 Requested % Change 63,090 - 17 53995 45020 0 0 2261 4695 10998 0 0 0 6287 66753 0 0 97032 0 0 0 0 75399 0 0 0 70732 212231 0 0 0 32859 6616 0 0 0 0 0 45,000 8,000 5,000 212,250 14,000 10,000 30,000 - 4,329 23,479 20,799 32,513 11,621 65,000 173,000 10,000 7,000 - - 0 0 311,800 1,963 160,000 0.00% 0.00% -100.00% 0.00% 0.00% -100.00% 1200.00% -18.49% 0.00% 0.00% 0.00% -28.57% 100.00% 0.00% 0.00% -100.00% -100.00% 0.00% 0.00% 0.00% -48.69% 415,000 -34.75% $ 156,660 Book5 2012 Actual 2013 YTD 01/31/13 $ 287,058 $ Section 3 - Page 27 397,838 $ 636,050 $ 94,705 $ 06/14/2013 3:14 PM SPECIAL REVENUE FUNDS SUMMARY EXPENDITURES 2013 Budget REVENUES 2014 Budgeted Difference 2014 Budget H. U. R. F. $ 1,388,477 $ 1,196,303 $ LTAF $ - $ - $ CAPITAL PROJECTS $ 600,000 $ 670,000 DEBT FUND $ 1,671,117 $ MPC FUND $ 477,967 RICO $ JCEF 2014 Budgeted % Change 2014 Revenues 2014 Rev vs. Exp -13.84% $ 1,388,477 $ 1,196,303 $ (0) - 0.00% $ - $ - $ - $ 70,000 11.67% $ - $ 670,000 $ - 1,563,854 $ (107,263) -6.42% $ 1,831,621 $ 1,563,854 $ - $ 486,806 $ 8,839 1.85% $ 477,967 $ 486,806 $ - 155,000 $ 210,000 $ 55,000 35.48% $ 155,000 $ 210,000 $ - $ 18,560 $ 18,572 $ 12 100.00% $ 10,500 $ 10,500 $ GRANTS $ 3,323,808 $ 5,108,376 $ 1,784,568 53.69% $ 3,269,153 $ 5,108,376 $ - HOUSING $ 346,684 $ 283,071 $ -18.35% $ 346,684 $ 283,071 $ 0 GRAND TOTALS $ 7,981,614 $ 9,536,983 $ 19.49% $ 7,479,402 $ 9,528,911 $ Book5 (192,174) 2013 Comparison of Revenues VARIANCE (63,614) 1,555,369 Section 4 - Page 1 (8,072) (8,072) 06/14/2013 3:14 PM 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 407,109 36,428 2,012 31,973 40,239 68,245 3,011 27,908 5,977 1,755 - Personnel Expense 624,655 Operating Expense 3001 3002 4104 4105 4107 4301 4311 4312 4703 5201 5801 6002 6301 6302 6501 6502 6601 6701 6702 6704 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 7401 Capital Outlay Book5 2010 Actual $ 2013 YTD 04/30/13 2014 % Change 2012 Actual 387,427 11,415 3,697 28,351 38,676 56,710 2,383 22,402 204 - 421,040 4,760 29,936 42,365 62,949 1,871 25,431 694 - $ 421,223 5,000 32,606 46,458 13,351 2,189 34,697 3,000 1,000 67,016 $ 318,481 2,262 23,012 33,064 12,053 1,491 22,458 355 27,350 $ 301,403 5,000 23,440 34,624 11,977 1,570 25,250 2,000 1,000 34,165 -28.45% 0.00% 0.00% -28.11% -25.47% -10.29% -28.29% -27.23% -33.33% 0.00% -49.02% 589,045 $ 626,541 $ 440,526 $ 440,428 -29.70% $ 551,265 $ 2013 Budget 2014 Requested 2011 Actual 13,351 2,272 1,304 52,390 181,024 2,897 44,788 8,375 27,246 12,786 200 897 575 1,510 27,000 21,164 3,200 198,360 12,628 30,179 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 - 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 12,360 2,700 1,800 50,000 161,000 10,000 20,000 13,000 5,000 28,800 500 1,000 500 850 20,000 22,000 3,300 182,980 6,000 23,000 6,757 2,357 1,915 32,808 133,534 7,050 15,386 4,795 27,837 386 1,033 213 676 10,049 12,736 4,901 37,094 4,698 - 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 147.16% -10.78% 33.33% 0.00% 11.80% 0.00% 0.00% -23.08% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -9.09% -15.15% -25.74% 0.00% -13.04% 19,075 - 646 - - - 0.00% Section 4 - Page 2 pg 29 06/14/2013 3:14 PM HIGHWAY USERS REVENUE FUND 101-54041-433 Account Description 7531 St Light Trpl Res Operating Expense 9901 Gen Fund Reimb 9916 Transfer to MPC 9917 Transfer to Debt Service Total Expenses 2010 Actual - 2011 Actual - $ $ 661,220 2012 Actual - 2013 YTD 04/30/13 2013 Budget - 671,020 514,531 $ 564,790 39,710 211,439 251,149 41,599 213,610 255,209 40,997 162,910 203,907 39,092 158,055 197,147 $ 1,537,024 $ 1,477,494 $ 1,307,482 $ 1,388,477 2014 Requested 2014 Approved $ $ 304,226 2014 Requested $ 2014 % Change 0.00% 541,687 -4.09% 37,626 131,441 169,067 37,494 162,269 14,425 214,188 -4.09% 2.67% 100.00% 8.64% 913,819 $ 1,196,303 -13.84% pg 29 CAPITAL OUTLAY Items 0 0 0 0 Total Book5 $ - $ - Section 4 - Page 2 06/14/2013 3:14 PM 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 Book5 2013 YTD 04/30/13 2014 Requested 2014 % Change 2010 Actual 2011 Actual 2012 Actual 2013 Budget 4,500 18,268 73,141 28,000 - - - - 12,000 - 16,589 26,001 83,997 - - - - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% $ 107,909 $ 28,000 $ 126,587 Section 4 - Page 3 $ - $ - $ pg 31 06/14/2013 3:14 PM CAPITAL PROJECTS FUND 103-51081-419 Account Description 7610 7626 7628 7631 8099 8900 9915 9917 Book5 2010 Actual 3rd Street Extension Government Plaza City Hall Improvements Port of Entry Capital Projects Reserve Funding Capital Projects Transfer to Grants Transfer to Debt Serv 160,853 198,486 Total Expenses 359,338 $ 2011 Actual 2012 Actual 41,670 276,017 65,754 2013 YTD 04/30/13 2013 Budget 449,782 1,042,929 - - 2014 Requested 47,396 14,647 308 44,752 120,000 550,000 - - 0.00% 0.00% 0.00% 100.00% -100.00% 100.00% 0.00% 0.00% 670,000 11.67% 600,000 - 127,181 60,000 $ 383,442 $ 1,679,891 Section 4 - Page 4 $ 600,000 $ 2014 % Change 107,104 $ pg 33 06/14/2013 3:14 PM DEBT SERVICE FUND 108-51547-419 Account Description Leases/Loans 4705 4706 4709 4710 4713 4714 4703 4703 Lease/Purchase St Lights PW Facility (Phase I) IT Upgrades Lease GADA Loan Fire Ladder Truck IDA Lease/Purchase IT Upgrades Lease 2013 Total Leases/Loans Call Center Loans 4711 Call Center Equipment 4712 Call Center Building Total Expenses 2010 Actual 2011 Actual 2012 Actual 2013 Budget 26,877 26,946 264,283 198,298 26,877 30,159 264,283 251,024 40,153 41,644 264,283 233,775 80,000 60,000 - - 13,438 264,283 231,775 40,000 40,000 5,000 - $ 516,404 573,579 511,680 $1,085,259 $ 652,341 $ 543,575 558,201 $1,101,776 Total Leases & Call Center 639,855 $ 594,496 2013 YTD 04/30/13 2014 Requested 198,553 59,788 9,792 40,000 11,184 $ 319,317 $ 2014 % Change 66,411 232,275 170,586 40,000 22,369 236,346 -100.00% 0.00% -74.87% 0.22% 326.47% 0.00% 347.37% 100.00% 767,987 29.18% 521,870 569,440 $1,091,310 512,983 563,638 $1,076,621 10,525 169,344 $179,869 693,905 $693,905 -100.00% 23.11% -35.55% $1,731,165 $1,671,117 $499,186 $1,461,892 -12.52% 101,962 100.00% $ 1,563,854 100.00% pg 33 Transfers 9904 Transfer to Capital Projects $ Total Debt Service Fund Bond Payments 4701 MPC Bond Payment TOTAL DEBT SERVICE Book5 $ 270,167 $ 486,076 $ 484,456 1,124,311 Section 4 - Page 5 $ 477,967 1,072,463 $ 23,053 342,370 $ 486,806 1.85% 1,254,793 17.00% 06/14/2013 3:14 PM RICO 104-56003-421 Account Description 2008 3001 4301 5801 7402 7403 7404 8003 8201 8202 8203 Human Resources Processing Contractual Services Auto & Equipment Maintenance Travel & Training Vehicles Furniture & Fixtures Equipment Contingencies RICO St Atty General RICO-County Attorney RICO-Towing Services Total Expenses 2013 YTD 04/30/13 2010 Actual 2011 Actual 2012 Actual 2013 Budget $ 3,177 5,967 296 289 8,804 4,853 5,407 14,500 - 843 13,529 633 3,921 24,816 36,470 1,010 19,500 - 5,909 24,108 65,789 3,223 49,231 44,925 1,584 21,000 - 43,293 $ 100,721 $ 215,771 $ $ 3,000 1,000 1,000 10,000 $ 80,000 20,000 20,000 20,000 - 155,000 $ 2014 Requested 1,795 1,518 0 8,227 $ 7,647 9,908 75,412 11,852 8,412 18,000 - 142,771 *** $ 0 1,000 1,000 10,000 80,000 78,000 20,000 20,000 - 210,000 2014 % Change pg 90 -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 290.00% 0.00% 0.00% 0.00% 0.00% 35.48% ***Budgeted expenses will only be expended if the money is available Section 4 - Page 6 06/14/20133:14 PM JCEF 105-51603-412 Account Description 1015 3003 8005 8007 8010 9901 2013 YTD 04/30/13 2010 Actual 2011 Actual 2012 Actual 2013 Budget Project Related Salaries County Trainer Cost SHR JCEF - Allowable expenses JCEF Court Approved Exp MCEF court approved ex Transfer to General Fund $ Total Expenses $ 582 1,688 $ 5,538 6 - 7,815 1,098 $ 8,664 220 - $ 9,982 $ 1,632 1,580 13,524 112 - $ 16,848 $ Section 4 - Page 7 2,000 $ 14,060 2,500 - 18,560 $ 2014 Requested 1,638 11,056 381 - $ 13,075 $ 2,000 2014 % Change 14,072 2,500 - 0.00% 0.00% 0.00% 0.09% 0.00% 0.00% 0.00% 18,572 0.06% pg 90 06/14/20133:14 PM GRANTS 106 Account Description 2010 Actual 2011 Actual 2012 Actual Housing & Comm Development Fire Police Public Works Library Transfer to GF Transfer to Housing Total Expenses Grants Requiring Match Book5 152,578 6,038 47,988 675,104 181 111,231 40,188 $ - $ - $ 1,033,309 2013 YTD 04/30/13 2013 Budget $ 2014 Requested 2014 % Change 1,265,475 1,204,000 38,000 1,460,932 1,000 120,034 1,989 56,970 204,684 113 919,464 32,025 108,369 4,047,518 1,000 8,535 19,613 - -27.34% -97.34% 185.18% 177.05% 0.00% 0.00% -100.00% 5,108,376 28.42% 3,977,942 $ 403,403 $ pg 33 Match Amount AFG - FS&P Grant - Capital & OT ADOT Chino Road ADOT RR Depot Fountains HSIP Sign Replacement $ 525.00 $ 155,000.00 $ 27,000.00 $ 6,000.00 TOTAL MATCH $ 188,525.00 Section 4 - Page 8 06/14/2013 3:14 PM HOUSING 501-51101-463 PERSONNEL EXPENSE Account Description 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2016 2013 YTD 04/30/13 2010 Actual 2011 Actual 2012 Actual 2013 Budget 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 124,865 17,400 33,783 62 12,964 12,958 14,852 979 2,845 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 - $15,937 $10,972 $22,890 $ 236,645 $ 282,790 $ 341,498 2014 Requested 2014 Approved $ $ 162,865 13,111 81,987 19,734 27,822 6,032 1,297 7,198 $ $ 26,639 $0 $ 346,684 2014 Requested 122,334 $ 10,976 $ 59,674 414 13,604 20,689 748 804 5,274 (25) 14,063 $3,004 $ 251,561 $ 130,371 13,373 58,236 15,451 22,468 7,106 1,007 6,325 2014 % Change 22,735 -19.95% 2.00% -28.97% 0.00% -21.70% -19.24% 17.81% -22.37% -12.13% 0.00% -14.66% $6,000 100.00% 283,071 -18.35% pg 90 CAPITAL OUTLAY Market Study 0 Total $ 6,000 6,000 $ Funded from Special Projects 6,000 6,000 Section 4 - Page 9 06/14/20133:14 PM ENTERPRISE FUNDS SUMMARY EXPENSES 2013 Budget REVENUES 2014 Budgeted Difference 2014 Budget 2014 Budgeted % Change 2013 Comparison of Revenues SANITATION $ 1,000,716 $ 1,273,748 $ 273,032 27.28% $ WATER WATER OFFICE WATER FIELD $ $ 248,355 1,314,767 $ $ 254,258 1,233,094 $ $ 5,903 (81,673) 2.38% -6.21% WATER CAPITAL REINVESTMENT WATER TOTAL $ $ 1,049,224 2,612,345 $ $ 567,648 2,055,000 $ $ (481,575) (557,345) WASTE WATER TOTAL SEWER CAPITAL REINVESTMENT $ $ $ 1,569,687 367,979 1,937,665 $ $ $ 1,521,342 329,658 1,851,000 $ $ $ AIRPORT $ 183,702 $ 137,302 GOLF GOLF COURSE BAR & RESTAURANT $ $ 376,093 178,643 $ $ 323,070 88,641 $ 554,736 $ 411,711 $ 6,289,164 $ 5,728,762 GRAND TOTALS VARIANCE 2014 Revenues 2014 Rev vs. Exp 1,230,100 $ 1,230,100 $ (43,648) -45.90% -21.34% $ 2,105,206 $ 2,055,000 $ (0) (48,345) (38,320) (86,665) -3.08% -10.41% -4.47% $ 1,937,665 $ 1,851,000 $ 0 $ (46,400) -25.26% $ 183,702 $ 137,302 $ - $ (143,025) -38.03% $ 554,736 $ 411,711 $ 0 $ (560,402) -8.91% $ 6,011,409 $ 5,685,113 $ (43,648) 06/14/2013 3:14 PM Book5 Section 5 - Page 1 WATER OFFICE 410-54051-432 Account Description 79,184 25 5,815 7,195 5,909 546 148 - 47,577 3,391 4,550 6,067 282 84 - 49,095 3,463 4,814 6,561 220 87 - $ 48,977 500 3,785 5,393 2,154 254 112 6,043 $ 41,171 2,981 4,480 2,632 207 91 2,703 $ 50,350 500 3,890 5,746 2,880 261 129 5,227 2.80% 0.00% 2.77% 6.55% 33.76% 2.79% 14.75% -13.51% 64,240 $ 67,219 $ 54,265 $ 68,984 2.63% 37,176 4,640 500 7,000 300 34,200 2,350 23,948 36,666 -0.13% -10.77% 0.00% 0.00% 0.00% 0.00% 104.35% 14.81% 1.47% 146,780 2.95% 5,000 33,494 -100.00% 0.00% 24.38% 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 98,821 $ 6,753 4,089 53 7,439 21,255 2,035 12,098 30,557 Operating Expense 2014 % Change 2012 Actual $ $ 7401 Capital Outlay 8001 Bad Debt Expense 9901 Gen. Fund Reimb. 84,279 61,950 $ 43,682 4,500 72 7,292 38,604 110 16,811 40,877 $ 45,008 151,949 2013 Budget 2014 Requested 2011 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 2013 YTD 04/30/13 2010 Actual 43,858 4,595 94 6,633 527 45,984 1,760 15,914 30,757 $ 36,263 26,570 150,121 37,226 5,200 500 7,000 300 34,200 1,150 20,858 36,136 $ 1,789 33,257 28,242 142,570 29,496 4,540 106 5,638 33,464 13,498 30,498 $ 6,636 5,000 26,930 117,240 $ 12,381 (1,453) 25,920 Other $ 45,008 $ 62,833 $ 63,289 $ 38,566 $ 36,848 $ 38,494 -0.19% Total Expenses $ 228,108 $ 276,732 $ 277,649 $ 248,355 $ 208,353 $ 254,258 2.38% pg 83 CAPITAL OUTLAY 2014 Requested 0 0 Total Book5 2014 Approved 0 0 $ - 0 0 $ - Section 5 - Page 2 06/14/2013 3:14 PM 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 Book5 2014 % Change 2012 Actual 174,574 50,885 6,122 16,901 20,043 36,065 1,364 7,982 681 - 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 - $ 308,701 1,257 10,000 24,477 34,738 12,442 1,620 10,856 3,000 1,000 48,905 $ 224,552 41 4,286 9,759 17,374 25,927 15,277 1,169 8,126 648 14,712 $ 301,400 10,000 23,822 35,188 16,985 1,582 10,979 3,000 1,000 25,952 -2.37% -100.00% 0.00% 0.00% -2.67% 1.29% 36.51% -2.33% 1.13% 0.00% 0.00% -46.93% 400,005 $ 456,996 $ 321,872 $ 429,908 -5.93% 39,800 5,000 290,000 9,000 1,500 95,000 50,000 35,000 5,000 99,098 2,000 1,500 3,000 1,000 1,200 500 1,500 1,300 20,000 3,500 2,100 - 11,259 1,396 235,222 4,326 461 29,669 53,044 9,062 85,690 525 2,482 1,147 2,841 100 501 2,109 15,515 640 2,359 - 666,998 $ 458,348 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 2014 Requested 2011 Actual $ $ 314,617 $ 312,396 4,464 2,720 310,993 7,472 914 10,920 54,818 47,929 15,040 10,938 3,072 341,866 6,440 145 5 30,176 50,886 29,228 - 22,013 980 1,590 241 582 106 78 14,049 11,037 1,784 - 831 982 2,731 463 614 155 859 18,860 1,546 1,325 - 507,729 $ 501,123 $ 2013 Budget 2013 YTD 04/30/13 2010 Actual 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 $ Section 5 - Page 3 527,440 $ 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 $ 698,698 pg 84 -21.73% 0.00% 0.00% 81.11% 0.00% 0.00% 0.00% 36.84% 20.00% 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 16.67% 0.00% 4.75% 06/14/2013 3:14 PM WATER FIELD 410-54053-432 Account 7401 7826 8901 9901 9915 9917 Description Capital Outlay CIP Impact Fees Depreciation Transfer to GF Transfer to Grants Transfer to Debt Service 2010 Actual 9,138 - Total Capital Outlay $ 9,138 Total Expenses $ 831,484 - 2011 Actual 21,662 327,014 9,524 - 2012 Actual 32,903 383,076 13,151 18,456 - 2013 Budget 190,773 2013 YTD 04/30/13 5,810 - 2014 Requested 30,000 22,248 - - 52,240 2014 % Change 100.00% 0.00% -88.34% 0.00% 0.00% 0.00% $ $ $ 104,488 -45.23% $ 1,233,094 -6.21% 358,200 447,586 $ 1,171,719 $ 1,375,030 2014 Requested 2014 Approved 190,773 $ 1,314,767 $ 5,810 $ 786,030 $ pg 84 CAPITAL OUTLAY Items Utility Vehicle 3/4 ton . 0 0 0 Total Book5 $ 30,000 30,000 $ Section 5 - Page 3 30,000 30,000 06/14/2013 3:14 PM Water Capital Reinvestment 410-54055-432 Account Description 2010 Actual 2011 Actual 0 63 - 0 - 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 $ Operating Expense 3001 Contractual Services 4301 Auto/Equip 5301 Communications 5801 Travel & Training 6001 Office supplies 6002 Operating Expenses 6301 Small tools 6302 Safety Equipment 6401 Books/Dues/Subscriptions 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 9901 Gen. Fund Reimb 8003 Contingency Operating Expense 7401 7802 7809 7810 7811 7818 7820 7821 7822 7824 Book5 63 $ 0 111,019 7,394 1,967 8,508 10,653 9,407 461 2,895 - $ 121,944 9,047 1,800 10,251 13,620 4,616 688 4,458 12,052 $ 70,989 296 912 5,504 7,458 4,048 342 2,211 5,395 $ 81,007 1,800 6,335 9,357 4,184 423 2,730 3,863 -33.57% -100.00% 0.00% -38.21% -31.30% -9.36% -38.48% -38.75% -67.95% $ 152,304 $ 178,478 $ 97,154 $ 109,700 -38.54% 45 29,942 5,000 450 2,000 450 600 7,000 4,500 1,566 1,008 1,870 4,207 5,282 142 2,320 4,779 125 31,887 - 227 89 25,100 Water CIP Capital Outlay SCADA Control System 16,620 3rd. St. Water Line Extension Misc. Projects-Master Plan Rehabilitation Reservoir Fairview Water (BECC) 13,031 Well 16 Equiping (Arsenic Compliance) 399,318 Rehab Existing Wells 33 Arsenic Compliance 442 300K Gallon Elevated Tanks-Rehab - 27,719 $ 28,079 70,567 52,255 216,558 2014 % Change $ 26,826 $ 2014 Requested 2013 Budget 4,325 25,100 - 2013 YTD 04/30/13 2012 Actual $ 84,335 28,853 1,951 227,796 Section 5 - Page 4 24,257 6,175 358 7 441 3,504 1,164 4,400 4,500 1,500 30,405 $ 90,746 60,000 100,000 50,000 100,000 $ 30,062 5,000 450 2,000 450 600 7,000 4,500 4,769 5,800 1,256 29,265 - 4,400 4,500 1,050 37,936 76,996 $97,948 71 159 257,298 60,000 100,000 - pg 85 pg 85 0.40% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -30.00% 24.77% 0.00% 7.94% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -100.00% 0.00% -100.00% 06/14/2013 3:14 PM Water Capital Reinvestment 410-54055-432 Account Description 7825 7827 7829 7830 2010 Actual 2011 Actual 2012 Actual 2013 Budget 16" Geronimo Trail Tansmission Main Replacement 978 W & WW System Improvements, Phase II Well 17 (Arsenic Compliance) Sunnyside Improve 66,257 - - 70,000 446,969 28,855 27,511 - Capital Projects 815,204 286,111 496,679 7999 Fixed Assets Total Expenses Book5 2013 YTD 04/30/13 2014 Requested 2014 % Change 200,000 400,000 - 329,455 - - 185.71% 0.00% -100.00% 0.00% 780,000 586,983 360,000 -53.85% 567,648 -45.90% pg 85 pg 85 (385,028) $ 521,843 $ 843,283 $ 522,751 Section 5 - Page 4 $ 1,049,224 $ 761,133 $ 06/14/2013 3:14 PM WASTEWATER 420-54061-432 Account Description 2013 YTD 04/30/13 2014 % Change 2011 Actual 2012 Actual 360,573 - 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 - $ 326,796 5,026 8,000 25,996 36,493 10,779 1,709 10,977 1,000 1,000 36,697 $ 206,047 164 4,286 3,126 15,291 22,590 11,781 1,024 6,254 28 16,385 $ 289,136 8,000 22,731 33,576 11,407 1,514 10,524 1,000 1,000 32,509 -11.52% -100.00% 0.00% 0.00% -12.56% -7.99% 5.83% -11.39% -4.13% 0.00% 0.00% 100.00% 368,809 $ 464,474 $ 286,977 $ 411,397 -11.43% 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 -53.11% -10.79% 0.00% 0.00% 0.00% 0.00% 0.00% 12.08% 11.11% 0.00% 0.00% 0.00% 6.25% 0.00% 0.00% 0.00% -38.13% 0.00% 0.00% 0.00% 33.33% -33.27% 0.00% 0.00% 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 4,206 26,363 32,986 36,294 2,499 10,138 849 $ 473,908 $ 445,030 $ 2013 Budget 2014 Requested 2010 Actual pg 87 Operating Expense 3001 3002 4104 4105 4301 4302 4703 5201 5202 5301 5502 5801 6001 6002 6021 6301 6302 6401 6501 6502 6601 6701 Book5 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 18,441 2,272 1,462 74,319 3,111 142 37,646 2,300 2,042 78,013 7,084 309 64,644 2,800 1,523 107,842 11,417 1,711 2,507 - 29,808 - 33,867 8,651 1,175 675 9,289 12,848 840 1,738 519 10,389 5,258 1,382 2,435 93,585 36,826 34,498 2,430 885 17,270 26,466 925 515 393 10,759 12,629 1,602 4,238 753 349 3,724 1,427 197 152 7,872 1,604 1,954 370 Section 5 - Page 5 70,961 2,800 1,500 90,000 8,000 2,000 48,000 71,000 450,000 77,700 2,500 450 80,000 3,000 800 8,000 80,000 800 950 450 9,000 20,000 2,100 2,250 41,092 2,445 1,329 80,886 9,946 9,113 34,404 0 444,690 76,108 0 0 40,553 1,764 612 19,526 11,761 848 1,001 706 9,465 6,183 1,808 893 06/14/2013 3:14 PM WASTEWATER 420-54061-432 Account Description Operating Expense 2011 Actual $ 216,461 2012 Actual $ 432,956 32,025 32,025 14,607 316,953 31,356 362,915 11,838 20,605 462,301 26,790 521,534 5,000 44,497 23,455 72,952 656,396 $ 1,024,406 $ 1,323,299 $ 1,569,687 2014 Requested 9,000 30,000 190,297 $ 229,297 2014 Approved 7401 Capital Outlay Impact Fee 8001 Bad Debt Expense Depreciation 9901 Gen. Fund Reimb. 9917 Transfer to Debt Service Total Capital Outlay Total Expenses 2013 YTD 2013 Budget 04/30/13 $ 1,032,261 $ 795,134 2010 Actual $ 150,463 $ 2014 Requested $ 1,023,692 2014 % Change -0.83% 22,576 21,394 30,000 5,000 36,818 14,435 86,253 100.00% 0.00% 0.00% -100.00% 56.97% 100.00% 18.23% $ 1,103,504 $ 1,521,342 -3.08% (1,181) pg 87 CAPITAL OUTLAY Items 1 AC Unit I Pickup Truck 3/4 ton Generator Total Book5 $ Section 5 - Page 5 30,000 30,000 06/14/2013 3:14 PM Sewer Capital Reinvestment 420-54065-432 pg 88 Account Description 2010 Actual 2011 Actual 2012 Actual 257,075 54,401 4,207 23,538 46,653 20,147 2,383 10,214 - 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 - $ 93,904 $ 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 Book5 $ 418,619 $ 280,739 $ 2013 YTD 04/30/13 2013 Budget 81,296 6,032 1,200 6,834 9,080 3,078 458 2,972 8,035 118,985 $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 $18,588 12,129 320 284 665 6,110 1,639 5,185 4,806 2,004 33,143 $108,880 $69,094 $48,993 Section 5 - Page 6 30,405 $ $ $ 2014 Requested 47,325 $ 197 82 3,629 4,915 2,682 225 1,458 3,596 64,110 $16,095 1,967 43 77 33 522 417 2,297 29,265 $50,715 $ 54,005 2014 % Change 1,200 4,223 6,238 2,789 282 1,820 2,576 -33.57% 0.00% -100.00% 0.00% -38.21% -31.30% -9.36% -38.48% -38.75% -67.95% 73,133 -38.54% 18,588 37,936 $56,525 pg 88 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 24.77% 15.37% 06/14/2013 3:14 PM Sewer Capital Reinvestment 420-54065-432 7401 7851 7852 7860 7862 7865 7869 7871 7872 7873 Sewer CIP Capital Outlay WWMP Phase I(Contract) 545,349 Bonita Interceptor-3rd to 19th 451,731 Phase I, WWTP Improvements 2,310,171 Root Intrusion-City Repairs DOC-Lift Station Improvements CIP Impact Fees-Study W & WW System Improvements, phase II 73,225 Phase II, WWTP Improvements Southwest Interceptor (City) 3,408 Southwest Interceptor (Contract) $3,383,883 394,547 99,938 1,811,370 1,600 65,000 4,246 95,215 - 30,000 9,460 3,038 - $2,470,316 - $44,098 7999 Contra Exp/Fix As 15,000 65,000 $0 $0 $0 $0 $0 $49,296 15,000 65,000 120,000 - 30,289 (103) - 120,000 - $200,000 - $79,481 $200,000 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% ($157,744) Total Expenses $ 3,835,645 $ 2,859,936 $ 207,096 $ 367,979 $ 194,307 $ 329,658 -10.41% CAPITAL OUTLAY 2014 Requested Items 0 0 0 Total Book5 2014 Approved $ - $ - Section 5 - Page 6 06/14/2013 3:14 PM 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 190,120 28,680 52 15,787 19,810 24,501 1,403 8,603 4,560 663 - Personnel Expense 294,179 Operating Expense 3001 3002 4104 4105 4301 4302 4311 4703 5201 5501 5502 5801 6001 6002 6201 6301 6302 6501 6502 6601 6705 Book5 $ 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 7402 8001 8003 8901 2010 Actual 2011 Actual 2012 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 - $ 312,410 $ $ 314,829 1,363 440 9,872.50 1,500 516 10,234 101 8,268 35,959 3,277 300,944 285 1,314 2,859 26,443 1,563 - 17,375 28 1,201 3,421 294,082 430 1,390 1,086 3,506 33,427 1,254 $ 369,088 $ 454,360 $ $ 15,979 3,000 500 5,000 8,000 19,000 2,500 4,200 50,000 300,000 1,000 500 1,000 450 2,000 35,000 2,400 10,000 $ 393,052 Capital Outlay Bad Debt Expense Other Expense/Conti Depreciation (Expense Savings) - 5,018 14,235 17,276 10,000 - 52,373 52,372 52,372 Section 5 - Page 7 383,588 301,348 6,000 1,000 23,589 32,956 11,437 1,560 22,011 2,000 1,200 51,259 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 $ 2013 YTD 04/30/13 2013 Budget $ 460,529 2014 Requested 181,736 17,549 9,044 893 15,213 20,193 13,608 910 14,027 681 22,811 $ 296,664 $ 12,686 2,619 308 3,435 6,518 664 14,365 4,146 337 212,417 15 225 731 22 741 1,110 1,319 31,007 1,688 404 $ 294,756 204,854 (939) 1,018 $ 2014 % Change 333,293 6,000 1,000 26,032 37,775 18,657 1,725 25,069 2,000 1,200 46,597 10.60% 0.00% 0.00% 0.00% 10.36% 14.62% 63.13% 10.58% 13.89% 0.00% 0.00% -9.10% 499,348 9.90% 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 - 0.00% -10.77% 0.00% 0.00% 0.00% 0.00% 0.00% 1700.00% 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% 5.71% 16.67% 0.00% 447,106 -2.91% 277,000 10,000 100.00% 0.00% 0.00% -100.00% - pg 90 06/14/2013 3:14 PM SANITATION 430-54071-432 Account Description 9901 Gen. Fund Reimb 9917 Transfer to Debt Service Total Expenses 2010 Actual 178,563 178,563 2011 Actual 226,532 298,158 2012 Actual 327,338 396,986 2013 Budget 23,455 85,827 $ $ $ 1,092,983 $ 1,000,716 865,793 982,075 $ 2013 YTD 04/30/13 22,576 227,509 2014 Requested 33,082 7,212 327,294 2014 % Change 41.04% 100.00% 281.34% 818,929 $ 1,273,748 27.28% pg 90 CAPITAL OUTLAY Items 2014 Requested Street Sweeper Sanitation Truck 4 post lift for Sanitation Trucks $ Book5 193,062 260,000 17,000 470,062 2014 Approved $ Section 5 - Page 7 260,000 17,000 277,000 06/14/2013 3:14 PM AIRPORT 310-54103-431 Account Description 2010 Actual 2011 Actual 2012 Actual 2013 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 6501 Gas/oil/lube 6503 Fuel (100 LL) 6504 Fuel (JET A) 6601 Uniforms 2014 Requested 2014 % Change - $ 14,941 113 1,152 1,447 36 435 - $ 16 22,526 194 1,730 2,258 52 738 - $ 34,095 400 2,639 3,760 548 178 1,343 4,547 $ 6,933 12,030 172 1,463 2,086 947 62 731 2,036 $ 23,984 400 1,865 2,755 2,325 126 1,148 2,146 -29.65% 0.00% 0.00% -29.31% -26.72% 324.17% -29.31% -14.52% -52.79% - $ 18,124 $ 27,513 $ 47,510 $ 26,459 $ 34,750 -26.86% $ 4,790 1,652 8,000 500 7,000 5,300 $ $ 3,111 1,230 6,762 76 970 5,738 $ -3.97% 0.00% 0.00% 0.00% -14.29% 0.00% 100.00% 0.00% -16.67% 0.00% 33.33% -34.21% -30.77% 16.67% 8,832 1,964 10,005 94 5,744 5,248 7,738 2,336 9,008 92 551 4,776 6,160 2,031 8,196 185 11,599 4,777 2,549 857 30,115 116,166 - 36 1,104 19 1,010 44,875 91,063 - 601 3,995 731 1,881 39,627 50,627 - 700 3,000 450 1,500 38,000 65,000 300 366 571 70 1,635 21,725 31,292 300 4,600 1,652 8,000 500 6,000 5,300 500 700 2,500 450 2,000 25,000 45,000 350 Operating Expenses 181,574 162,607 130,410 136,192 73,846 102,552 -24.70% Total Expenses before Capital 181,574 180,731 157,924 183,702 100,305 137,302 -25.26% 194 - 230 - 29,259 - 0.00% - - - - - - 0.00% 137,302 -25.26% 7301 Capital Outlay/Projects 8512 Grant Match Total Expenses Book5 2013 YTD 04/30/13 $ 181,768 $ 180,731 $ 158,154 $ 183,702 Section 5 - Page 8 $ 129,564 $ pg 81 06/14/2013 3:14 PM AIRPORT 310-54103-431 CAPITAL OUTLAY Book5 Item 2014 Requested 2014 Approved* 0 0 Total - - $ $ Section 5 - Page 8 06/14/2013 3:14 PM 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 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 7750 Capital Outlay 7751 RV Hidden Treasures 8050 Prior Expense - DGSC Book5 2010 Actual 2011 Actual 2012 Actual 2013 Budget 704 45,990 69,449 632 8,927 6,778 271 1,833 $ 134,584 15,503 51,856 71,561 821 10,593 8,499 3,209 274 2,185 $ 13,030 52,588 5,062 15,615 3,103 16,690 10,651 12,256 14,021 8,495 3,197 1,580 7,026 122 1,940 23,494 19,627 3,266 146 1,843 11,143 1,162 $ 226,056 164,500 $ 17,319 53,697 84,913 1,221 11,709 10,221 3,637 275 2,495 - $ 38,714 50,000 46,369 500 10,372 9,329 587 255 2,933 4,872 15,070 45,372 70,474 1,898 10,024 9,515 1,310 281 2,921 2,172 185,487 $ 163,930 $ 159,039 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 $ 8,513 30,000 2,000 11,450 1,488 16,000 9,000 10,000 300 32,711 1,500 5,000 6,000 1,500 1,200 20,000 19,000 20,000 100 1,000 401 14,000 1,000 17,767 29,553 9,977 1,278 11,577 3,154 5,708 184 16,699 1,481 678 2,931 434 19,352 11,285 9,698 22 1,701 13,195 1,065 221,416 $ 212,163 - 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 2,607 105,751 - - $ 2013 YTD 04/30/13 Section 5 - Page 9 76,904 37 - - 2014 Requested $ 2014 % Change 37,783 45,000 23,515 500 8,170 6,983 1,112 253 2,638 6,161 -2.40% -10.00% -49.29% 0.00% -21.23% -25.14% 89.37% -0.92% -10.06% 26.48% $ 132,115 -19.41% $ 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 -23.26% 30.00% -100.00% 0.00% -55.65% 0.00% -44.44% -20.00% 0.00% 0.00% 0.00% 0.00% -70.00% -33.33% -33.33% -33.33% 0.00% -15.79% -50.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ 157,738 $ 190,955 -10.00% 3,406 - - 0.00% pg 88 06/14/2013 3:14 PM Golf Course 450-52045-451 Total Expenses *CAPITAL OUTLAY Restroom for 14th/15th hole Tee Mower Golf Cart Path Total Book5 $ 363,247 $ 506,097 $ 483,844 $ 376,093 $ 320,182 $ 323,070 -14.10% 2014 2014 Requested Approved 10,000 0 8,000 0 25,000 0 0 0 0 0 0 0 0 $ 43,000 $ - Section 5 - Page 9 06/14/2013 3:14 PM Lounge 450-52055-451 Account Description 2010 Actual 2011 Actual 2012 Actual 2013 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 Book5 $ - 29,646 26,152 2,868 2,348 4,717 2,598 63 870 - $ 19,388 37,206 6,146 5,442 5,352 4,604 107 936 - $ 45,196 15,000 10,250 - - $ 69,262 $ 79,181 $ 88,996 $ - $ 10,959 10,407 3,175 624 426 3,385 730 5,334 $ 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 $ 7,859 10,000 1,500 840 1,248 4,000 500 5,000 600 2,000 3,000 500 145,542 $ - 4,632 31,173 310 396 31,225 33,126 1,219 $ - $ $ - 137,122 $ 11,220 417 $ 218,020 270,376 Section 5 - Page 10 $ 35,000 15,000 600 45,279 375 $ $ 5,389 6,044 587 134 1,524 4,872 $ 7750 Capital Outlay 8101 Special Events Total Expenses - 2013 YTD 04/30/13 $ 87,647 $ 2014 Requested 3,701 10,328 18,725 236 3,114 3,068 2,296 984 60 668 2,188 $ 45,368 2014 % Change 1,148 370 - -100.00% 0.00% -100.00% 0.00% 0.00% -78.71% -100.00% -100.00% -100.00% -75.69% -100.00% $ 16,518 -81.44% 10,404 9,255 2,176 788 1,188 2,008 97 625 2,205 86 103 27,536 25,846 617 $ 2,379 10,000 2,500 1,340 504 3,000 500 3,000 300 1,000 3,000 500 43,500 600 -69.73% 0.00% 66.67% 59.52% -59.62% -25.00% 0.00% -40.00% -50.00% -50.00% 0.00% 0.00% 0.00% 24.29% -100.00% 0.00% 82,931 $ 72,123 -17.71% - 0.00% -100.00% 88,641 -50.38% 2,000 - 178,643 $ 128,299 $ 15,000 - pg 88 06/14/2013 3:14 PM GRANTS 2013-2014 Total Grant Award Housing and Community Development Dept of HUD Family Self Sufficiency Housing CDBG Grant SSP ADOH Owner Occupied Housing Rehab 306-11 ADOH Owner Occupied Housing Rehab ADOT Transit Grant disabled & Job Training * ADOT Transit Grant 5311 Match & Vehicle Insurance * Freeport McMoran Transit Grant * CDBG Regional Curbing & Drainage Fire AFG - Sprinkler System AFG - Fire Truck Type 3 Engine AZSERC - Haz Mat AFG - FS&P Grant - Capital & OT BECC Haz Mat AZDEM ERF USDA Rural Fire Assistance SHGGP Fire Christmas Drive EMS Scholarship Police Operation Stonegarden OT 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 Paseo de la Amistad ADOT RR Depot Fountains ADOT Safe Route to School HSIP Sign Replacement BECC WasteWater Bay Acres BECC WasteWater Project Development Airport Master Plan Update ADOT Airport Runway ADOT Airport Taxi Way ADOT Airport Security Fencing Library E-Rate Grant Wal Mart Library Literacy Grant TOTALS REQUESTED TOTALS APPROVED * * * * ** ** * 2014 Max Revenue 2014 Max Expense 69,000 300,000 330,000 300,000 10,000 480,360 65,000 170,697 1,725,057 69,000 300,000 79,767 300,000 10,000 480,360 65,000 170,697 1,474,824 69,000 300,000 79,767 300,000 10,000 480,360 65,000 170,697 1,474,824 103,600 621,000 4,000 10,500 2,000 9,000 65,000 1,500 2,500 2,000 821,100 103,600 621,000 4,000 10,500 2,000 9,000 65,000 1,500 2,500 2,000 821,100 103,600 621,000 4,000 10,500 2,000 9,000 65,000 1,500 2,500 2,000 821,100 656,434 67,150 41,219 38,000 40,000 150,000 992,803 656,434 67,150 41,219 38,000 40,000 150,000 992,803 656,434 67,150 41,219 38,000 40,000 150,000 992,803 3,264,248 215,020 437,355 300,000 90,000 250,000 80,000 275,000 350,000 300,000 200,000 5,761,623 2,564,298 2,564,298 437,355 300,000 57,865 250,000 80,000 275,000 350,000 300,000 200,000 4,814,518 437,355 300,000 57,865 250,000 80,000 275,000 350,000 300,000 200,000 4,814,518 46,411 1,000 47,411 46,411 1,000 47,411 46,411 1,000 47,411 9,347,994 8,150,657 8,150,657 8,726,994 7,529,657 7,529,657 Total Grant Match from the GF Requested Total Grant Match from the GF Approved 2014 Total Expenditure 2014 Match 10,000 96,072 106,072 5,180 31,050 525 26,000 62,755 - 155,000 27,000 6,000 250,000 ** 40,000 ** 27,500 15,000 520,500 5,157 * 5,157 694,484 663,434 69,000 300,000 79,767 300,000 20,000 576,432 65,000 170,697 1,580,896 108,780 Not Recommended 652,050 Not Recommended 4,000 11,025 2,000 9,000 91,000 Not Recommended 1,500 2,500 2,000 883,855 656,434 67,150 41,219 38,000 40,000 150,000 992,803 2,719,298 464,355 300,000 63,865 500,000 120,000 302,500 Not Recommended 365,000 Not Recommended 300,000 200,000 5,335,018 51,568 1,000 52,568 8,845,141 8,193,091 404,484 299,754 *Grants Accounted for in General Fund Rev & Exp **Grant Accounted for in the Water & Sewer CIP Rev and Exp Book5 Section 6 - Page 1 06/14/2013 3:14 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2013-2014 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL AMOUNT APPROVED DEPT. APPROVED FUNDING SOURCE ADMINISTRATION DEPARTMENT TOTAL $0 $ - $ - FINANCE DEPARTMENT TOTAL $ - MIS Network Upgrade Computer Replacement (15) Printer Replacement (1) Battery Replacement (8) Generator DEPARTMENT TOTAL 1,034,256 16,350 1,000 6,800 133,535 $ 1,058,406 New Debt Service Not Recommended Not Recommended Not Recommended Not Recommended $ - HUMAN RESOURCES DEPARTMENT TOTAL $ - $ - $ - $ - MAGISTRATE DEPARTMENT TOTAL FIRE/EMS Multi use vehicle or Fire/HazMat/EMS Type 2 EMS Unit Fire Pumper Fire Hose Office Furniture New Roof Exterior Paint DEPARTMENT TOTAL POLICE 50 Portable Battery Replacement 3 2014 Tahoes 2 AC/Heaters Roof Repair 37 Level IV Ballistic Carriers Metal Building for Evidence Generator DEPARTMENT TOTAL 65,000 230,000 450,000 5,000 5,000 20,000 5,000 60,000 5,000 $ 780,000 10,000 120,000 35,000 18,000 18,000 40,000 149,584 $ 390,584 $ - $ - Not Recommended GF Not Recommended GF Not Recommended Not Recommended Not Recommended $ 65,000 - GF 120,000 Auction/Amount will only be used if rev come in as bud 17,000 GF 18,000 GF 18,000 RICO - Not Recommended Not Recommended $ 173,000 ECONOMIC DEVELOPMENT $ DEPARTMENT TOTAL $ - $ - VISITOR CENTER DEPARTMENT TOTAL CEMETERY Ride Mower Chain Link fencing Upgrade Restrooms Chip Seal Project DEPARTMENT TOTAL 10,000 2,000 6,000 375,000 0 0 0 0 $ 393,000 Not Recommended Not Recommended Not Recommended Not Recommended $ - COMMUNITY DEVELOPMENT DEPARTMENT TOTAL Book5 $ - Section 7 - Page 80 $ - 06/14/2013 3:14 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2013-2014 DEPT ITEM/PROJECT AMOUNT REQUESTED PARKS 2 Ride Mowers 54" Cut - motors 2 Gator Utility Vehicle Roof for Paseo and Airport Pump House 11 radios 18 weed eaters Tires for Gators and Mowers DEPARTMENT TOTAL DEPT. TOTAL AMOUNT APPROVED 20,000 18,000 6,000 6,000 5,400 2,000 DEPT. APPROVED 10,000 $ 50,000 $ - FUNDING SOURCE GF Not Recommended Not Recommended Not Recommended Half the amount approved under operating supplies Approved under operating supplies $ 10,000 RECREATION DEPARTMENT TOTAL AQUATICS Roof repairs Baby pool coverage/roof POS System DEPARTMENT TOTAL $ 7,000 6,500 8,750 $ 7,000 $ 22,250 - GF Not Recommended Not Recommended $ 7,000 PUBLIC WORKS/ADMINISTRATION DEPARTMENT TOTAL PW CONSTRUCTION Generator Air Handler $ 58,221 57,000 DEPARTMENT TOTAL PUBLIC WORKS/FLEET MAINTENANCE Replace Four Post Lift DEPARTMENT TOTAL - $ $ 115,221 $ 17,000 17,000 Not Recommended Not Recommended $ - - - Not Recommended $ - LIBRARY DEPARTMENT TOTAL TRANSIT 2 Buses $ - 160,000 DEPARTMENT TOTAL TOTAL GENERAL FUND REQUESTS 160,000 $ 160,000 - Grant - Matching Amount GF $ 160,000 TOTAL REQUESTED TOTAL AMOUNT APPROVED $ 2,986,461 $ 415,000 Capital Outlay Funding RICO Grants Seized Vehicle Auction Funds (net of expenses) General Fund Book5 $ $ 18,000 $ 128,000 $ 120,000 $ 149,000 TOTAL ALL FUNDING SOURCES $ 415,000 BALANCE $ Section 7 - Page 81 - 06/14/2013 3:14 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2013-2014 DEPT ITEM/PROJECT AMOUNT REQUESTED SANITATION Street Sweeper Sanitation Truck 4 post lift for Sanitation Trucks DEPARTMENT TOTAL DEPT. TOTAL AMOUNT APPROVED 193,062 260,000 17,000 $ 470,062 DEPT. APPROVED FUNDING SOURCE Approved under debt 260,000 17,000 Sanitation $ 277,000 STREETS (HURF) DEPARTMENT TOTAL $ - $ - $ - $ - WATER OFFICE 0 DEPARTMENT TOTAL WATER FIELD Utility Vehicle 3/4 ton . - 30,000 30,000 Water Fund DEPARTMENT TOTAL $ 30,000 $ 30,000 $ - WATER/SEWER - CAPITAL REINVESTMENT PROGRAM DEPARTMENT TOTAL $ WASTEWATER 1 AC Unit I Pickup Truck 3/4 ton Generator DEPARTMENT TOTAL GOLF COURSE Restroom for 14th/15th hole Tee Mower Golf Cart Path 9,000 30,000 190,297 $ $ $ $ DEPARTMENT TOTAL $ $ 30,000 - Not Recommended Sewer Fund Not Recommended $ 30,000 - Not Recommended Not Recommended Not Recommended 229,297 10,000 8,000 25,000 DEPARTMENT TOTAL HOUSING Market Study - 43,000 6,000 $ - 6,000 Housing Reserves $ 6,000 $ 6,000 $ - AIRPORT DEPARTMENT TOTAL Book5 $ - Section 7 - Page 82 06/14/2013 3:14 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2013-2014 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL TOTAL REQUESTED TOTAL ENTERPRISE FUND REQUESTS Requests funded from HUD Requests funded from Golf Course NET FUNDED FROM ENTERPRISE FUNDS Book5 $778,359 AMOUNT APPROVED DEPT. APPROVED TOTAL AMOUNT APPROVED $343,000 $ 6,000 $ $ 337,000 Sanitation Fund HURF Water Fund Sewer Fund Water/Sewer CIP HUD Golf Course Airport $ $ $ $ $ $ $ $ $ 277,000 30,000 30,000 6,000 - Total Enterprise Funds CIP 12/13 $ 337,000 TOTAL GENERAL FUND REQUESTS: TOTAL ENTERPRISE FUND REQUESTS: $ 2,986,461 $ 778,359 $ 415,000 $ 343,000 TOTAL CAPITAL OUTLAY REQUESTS: $ 3,764,820 $ 758,000 LESS: FUNDED BY SPECIAL FUNDING $ 272,000 $ 272,000 TOTAL CITY FUNDED CAPITAL OUTLAY: $ 3,492,820 $ 486,000 Section 7 - Page 83 FUNDING SOURCE 06/14/2013 3:14 PM REIMBURSEMENTS GENERAL FUND REIMBURSEMENT FROM ENTERPRISE FUNDS FLEET REIMBURSEMENT 201,710 37.00% Description HURF SANITATION WATER SEWER WATER/SEWER - CIP Total reimbursement Fleet % 17.40 3.80 7.10 8.70 $ Adm % 22.50% 13.50% 15.50% 13.50% 35.00% 100.00% $ 166,639 $74,633 * 50,121 2013 Projected 37,494 33,082 33,494 36,818 75,873 216,760 *Note: Percentages based on analysis study of personnel assigned to each fund as well as checks issued, purchase orders and check requisitions processed. Administrative overhead reimbursement calculated on Administration, Finance, Management Information Systems, and Human Resource Departments. Admin Finance MIS HR Total Book5 482,031 480,110 315,318 388,934 1,666,393 Section 2 - Page 2A 06/14/20133:14 PM