CITY OF DOUGLAS BUDGET SUMMARY Expense 2011 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 $ GENERAL FUND CAPITAL $ MATCHING FUNDS (GRANTS) $ GENERAL FUND $ Net Rev. vs. Exp. $ 449,025 35,000 60,890 41,714 554,657 645,044 586,477 569,673 88,183 377,522 123,384 113,699 602,090 141,797 263,734 227,244 438,977 314,539 1,068,235 1,044,552 383,867 2,265,108 1,155,992 162,871 329,569 199,829 12,243,673 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2011-2012 Difference 451,161 35,000 75,700 43,938 547,140 500,413 732,218 740,215 85,609 332,546 97,084 76,203 583,355 114,842 285,036 196,425 465,756 264,259 1,101,133 1,068,622 317,307 2,176,429 1,366,920 155,167 236,200 159,281 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 2,136 14,809 2,225 (7,517) (144,631) 145,741 170,541 (2,575) (44,976) (26,300) (37,496) (18,736) (26,955) 21,302 (30,819) 26,779 (50,280) 32,898 24,070 (66,560) (88,678) 210,928 (7,703) (93,369) (40,548) $ 12,207,958 $ (35,715) 2012 2011 Budgeted 2012 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp 0.48% 0.00% 24.32% 5.33% -1.36% -22.42% 24.85% 29.94% -2.92% -11.91% -21.32% -32.98% -3.11% -19.01% 8.08% -13.56% 6.10% -15.99% 3.08% 2.30% -17.34% -3.91% 18.25% -4.73% -28.33% -20.29% -0.29% $ 11,838,938 $ 11,796,595 $ (411,363) (411,363) 16,000 300,000 95,363 - Auction Police Reserve GF Reserve CDAR Equipment Expense 2012Budget One Time Amounts/Tranfers to the General Fund PW Sanitation $300,000 (0) 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 1 - Page 1 CITY OF DOUGLAS BUDGET SUMMARY 2011 Budget 2011-2012 Difference 2012 Budget 2012 2012 2011 Budgeted 2012 Budgeted Comparison of % Change Revenues Revenues Rev vs. Exp H. U. R. F.* $ 1,445,350 $ 1,380,914 $ (64,436) -4.46% $ 1,445,350 $ 1,380,914 $ LTAF $ 28,000 $ 16,589 $ (11,411) -40.75% $ - $ - $ (16,589) SPEC. PROJECTS $ 3,451,056 $ 2,830,164 $ (620,892) -17.99% $ 3,451,056 $ 2,830,164 $ (0) CALL CENTER $ 1,414,349 $ 1,383,964 $ (30,385) 100.00% $ 1,399,674 $ 1,383,965 $ 0 RICO $ 160,000 $ 155,000 $ (5,000) -3.13% $ 160,000 $ 155,000 $ - JCEF $ 9,500 $ 18,312 $ 8,812 100.00% $ 9,500 $ 10,500 $ GRANTS $ 7,459,207 $ 5,698,293 7,259,378 $ 5,698,293 $ HOUSING $ 329,251 $ 337,946 TOTAL SPECIAL REVENUE FUNDS $ 14,296,712 SANITATION $ WATER WATER OFFICE WATER FIELD WATER CAPITAL REINVESTMENT WATER TOTAL $ (1,760,914) $ -23.61% 8,695 0 (7,812) - 2.64% $ 319,251 $ 304,946 $ (33,000) -17.32% $ 14,044,209 $ 11,763,782 $ (57,400) $ 11,821,182 $ (2,475,530) 1,142,000 $ 1,380,100 $ 238,100 20.85% $ 1,142,000 $ 1,230,100 $ (150,000) $ $ $ $ 229,086 1,204,330 2,127,584 3,561,000 $ $ $ $ 276,592 1,105,593 2,001,472 3,383,656 $ $ $ $ 47,505 (98,737) (126,112) (177,344) 20.74% -8.20% -5.93% -4.98% $ 3,561,000 $ 3,383,656 $ (0) WASTE WATER SEWER CAPITAL REINVESTMENT SEWER TOTAL $ $ $ 1,264,155 4,756,804 6,020,959 $ $ $ 1,533,727 981,272 2,515,000 $ 269,572 $ (3,775,531) $ (3,505,959) 21.32% -79.37% -58.23% $ 6,082,804 $ 2,515,000 $ 0 AIRPORT $ 111,680 $ 247,300 $ 135,620 121.44% $ 111,680 $ 206,300 $ GOLF COURSE ** BAR & RESTAURANT $ $ $ 512,932 29,797 542,729 $ $ $ 441,601 233,523 675,124 $ 132,395 25.81% $ 477,776 $ 675,124 $ TOTAL ENTERPRISE FUNDS $ 11,378,367 $ 8,201,180 $ (3,177,187) -27.92% $ 11,375,260 $ 8,010,180 $ (191,000) GRAND TOTALS $ 37,918,752 $ 32,230,320 $ (5,688,432) -15.00% $ 37,258,407 $ 31,570,557 $ (659,763) (41,000) - * HURF is being subsidized $240,000 by the General Fund ** Golf Course/Bar & Restaurant is being subsidized $254,705 by the General Fund and $82,719 by Special Projects 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 1 - Page 2 REVENUE BUDGET 2011 - 2012 GENERAL FUND Account 31100 31102 31301 31302 31801 31802 31803 32101 32102 32103 32104 32201 32202 32301 32302 32303 33111 33211 33231 33501 33502 33503 33702 33704 33705 34101 34102 34104 34105 34106 34107 34108 34501 34502 34503 34701 34702 34703 34704 34705 34706 34707 34720 34723 Description PROPERTY TAX-CURRENT PROPERTY TAX-DELINQ. CITY SALES TAX / USE TAX 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 HAZ MATERIALS GRANT STATE SHARED SALES TAX STATE URBAN REV SHARING VEHICLE LICENSE TAX COCHISE COLLEGE IGA HUMANE COUNTY IGA HOUSING IGA CASAS & PIONEER PARKING LOT FEES CEMETERY FEES ANIMAL SHELTER REVENUE LEAD INSPECTIONS IMPOUND FEES IMPOUND ADM FEES FINGERPRINTS 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 FLAG FOOTBALL LEAGUE FEES 2008 Actual $ 443,904 35,918 3,992,430 32,417 162,514 135,807 51,123 43,006 9,370 1,080 3,955 75,284 33,888 2,785 329 2009 Actual $ 479,079 41,791 4,315,431 38,437 167,876 122,338 51,488 45,699 9,730 300 3,045 49,592 17,299 200 359 419,778 57,166 28,651 1,585,995 2,419,853 842,594 35,000 14,612 424,223 2,679 1,387,008 2,575,571 755,546 18,467 63,320 48,730 25,066 54,855 109,418 20,797 642,820 7,250 35,648 6,328 873 100 760,669 7,070 5,005 37,468 3,367 1,853 486 2010 Actual 2011 Budget 499,803 $ 27,609 4,123,716 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 0 1,265,384 2,220,055 771,141 30,274 0 44,993 65,795 9,065 0 3,000 671,753 5,968 1,170 23,955 7,152 0 846 860 1,530 761 4,182 250 2011 9-month Actual 480,000 35,000 4,600,000 45,000 175,000 120,000 55,000 60,000 10,000 500 3,500 45,000 15,000 4,000 500 516,000 1,290,008 1,673,386 750,446 35,000 93,845 55,000 70,000 12,000 4,200 20,000 800,000 7,000 2,000 16,000 5,000 500 1,500 700 19,000 1,000 2,000 250 $ 312,150 23,984 3,476,853 30,215 99,706 40,777 25,731 65,134 8,075 3,095 2,585 42,119 1,512 2,950 225 900 263,714 885 961,056 1,255,228 567,569 19,254 23,611 20,795 52,429 7,546 10,976 40 595,811 4,505 11,971 2,213 301 1,044 1,345 626 2,143 - 2012 Projected $ 490,000 30,000 4,450,000 45,000 175,000 120,000 55,000 80,000 12,000 3,500 3,500 50,000 5,000 4,000 500 1,200 516,000 1,314,757 1,466,777 802,933 35,000 95,035 37,000 70,000 10,000 4,200 15,000 5,000 1,000 900,000 6,500 2,000 16,000 5,000 1,500 1,500 1,000 10,000 1,000 2,000 250 2012 % Change 2.08% -14.29% -3.26% 0.00% 0.00% 0.00% 0.00% 33.33% 20.00% 600.00% 0.00% 11.11% -66.67% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% 1.92% -12.35% 6.99% 0.00% 0.00% 1.27% -32.73% 0.00% -16.67% 0.00% -25.00% 100.00% 100.00% 12.50% -7.14% 0.00% 0.00% 0.00% 200.00% 0.00% 42.86% -47.37% 0.00% 0.00% 0.00% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 3 REVENUE BUDGET 2011 - 2012 GENERAL FUND (Continued) Account 34730 34750 34751 35101 35102 35103 35201 36101 36201 36211 36401 36403 36406 36431 38001 38005 38201 38202 39104 39110 39112 39113 39301 Description 2008 Actual RAMADA RESERVATION FEES DUSD AQUATIC CENTER REIMB DUSD RECREATION REIMB COURT FINES & FORFEITURES RESTITUTION PAYMENTS LIBRARY FINES & FEES FORFEITED PROPERTY SALE INVESTMENT EARNINGS RENTAL PAYMENTS VISITOR CENTER RESV FEES MUSEUM SHOP SPECIAL EVENTS REVENUE 4TH OF JULY REVENUE YOUTH ACTIVITY REVENUE LIBRARY GRANT E-RATE MISCELLANEOUS REVENUE NPF XII BOND PROCEEDS SALE SURPLUS PROPERTY/LAND EXPLORER REVENUE TRANSFER FROM SPECIAL PROJECTS TRANSFER FROM ENTERPRISE FUNDS TRANSFER FROM GRANTS TRANSFER FROM COURTS - Reimb TRANSFER FROM SP GADA CAPITAL LEASE PROCEEDS TOTAL REVENUE 2009 Actual 35,000 20,000 114,745 632 18,765 124,852 3,821 320 35,000 20,000 111,606 1,099 18,250 55,331 11,396 3,271 - 1,697 810 173,990 1,495 450 87,253 (1,463) 1,800 506,517 131,005 - 300 181,908 162,083 - 534,170 $ 12,924,255 2010 Actual $ 12,196,607 2011 Budget 0 35,000 20,000 126,776 1,566 16,679 37,330 9,031 3,181 380 855 997 0 58,162 53,820 0 0 0 133,520 323,107 3,745 0 0 2 20 $ 11,745,818 2011 9-month Actual $ 2012 Projected 35,000 20,000 110,000 500 18,000 83,265 15,000 20,300 500 940 105,540 493 13,132 29,632 2,751 11,851 2,350 1,500 3,000 1,000 50,000 865 675 76,152 40,746 5,000 2,000 70,061 380,477 - 13,295 300 75,214 315,032 - 11,838,938 $ 2,000 35,000 20,000 130,000 500 18,000 88,000 8,000 20,300 2,000 4,000 2,000 3,000 1,000 44,654 50,000 2012 % Change - 5,000 1,000 38,143 479,846 - 100.00% 0.00% 0.00% 18.18% 0.00% 0.00% 5.69% -46.67% 0.00% 300.00% 100.00% 33.33% 0.00% 0.00% 100.00% 0.00% 0.00% 0.00% -50.00% -45.56% 26.12% 0.00% 0.00% 0.00% 0.00% 8,628,038 $ 11,796,595 -0.36% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 4 REVENUE BUDGET 2011 - 2012 pg 28 HIGHWAY USER REVENUE FUND Account 33504 38001 38002 38003 39101 39104 Description 2008 Actual HIGHWAY USERS - STATE MISCELLANEOUS SALES REIMBURSEMENT CITIZEN PAYS POLICY TRANSFER FROM GENERAL FUND TRANSFER FROM SP PROJECTS $ TOTAL REVENUE $ 2009 Actual 1,469,404 2,834 11,604 93,652 300,000 - $ 1,877,494 $ 2010 Actual 1,305,627 1,320 84,487 103,873 1,495,307 $ 2011 9-month Actual 2011 Budget 2012 Projected 2012 % Change 1,202,711 37,713 109 120,000 - $ 1,245,350 30,000 170,000 - $ 899,829 29,557 11,016 127,500 62,425 $ 1,105,914 30,000 5,000 240,000 - -11.20% 0.00% 0.00% 100.00% 41.18% 0.00% 1,360,533 $ 1,445,350 $ 1,130,327 $ 1,380,914 -4.46% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 5 REVENUE BUDGET 2011 - 2012 pg 30 LOCAL TRANSPORTATION ASSIST. (LOTTERY) Account 33505 Description 2008 Actual 2009 Actual LOTTERY LTAF II GRANT $ 81,068 28,289 $ 76,758 32,673 TOTAL REVENUE $ 109,357 $ 109,431 2010 Actual $ 2011 9-month Actual 2011 Budget 2012 Projected 2012 % Change 43,965 25,267 $ - $ 14,258 $ - 0.00% 0.00% 69,232 $ - $ 14,258 $ - 0.00% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 6 REVENUE BUDGET 2011 - 2012 pg 80 SPECIAL PROJECTS (1/2 CENT SALES TAX) Account 31301 33705 34751 36101 36104 36201 38007 38008 39302 Description 2008 Actual SALES TAX-CITY $ DUSD IGA TRAFFIC CONTROL BORDER PROJECT INVESTMENT EARNINGS INT-GOLF COURSE DEV RENTAL PAYMENTS (uofa) 3rd Street Project Revenue VENDING MACHINE PROCEEDS GOV'T PLAZA FINANCING TOTAL REVENUE $ 1,017,478 2009 Actual $ 30,611 25,257 36,000 $ $ 87,017 247 36,000 1,562 - 936,877 2,046,223 1,098,136 2010 Actual $ 1,222,962 1,030,940 52,788 2011 Budget $ $ 34,861 $ 1,118,589 2011 9-month Actual 1,149,977 115,579 $ $ $ 35,000 500 550,000 1,600,000 $ 3,451,056 2012 Projected 868,980 34,526 49,660 4,415 - $ $ $ 957,581 $ 1,112,478 62,686 2012 % Change 5,000 550,000 1,100,000 - -3.26% -45.76% 0.00% -85.71% -100.00% 0.00% 0.00% 0.00% -31.25% 0.00% 2,830,164 -17.99% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 7 REVENUE BUDGET 2011 - 2012 CALL CENTER Account 31301 36102 36202 39303 Description 2008 Actual 1 1/3 Cent Sales Tax (call center IT) INVESTMENT EARNINGS Call Center CALL CENTER Lease CALL CENTER FINANCING TOTAL REVENUE 2009 Actual 270,407 2011 Budget 2012 Projected 2012 % Change $ 421,556 217 483,499 8,729,593 $ 617,834 2,446 704,620 - $ 689,986 2,000 707,688 - $ 509,005 986 534,759 - $ 667,487 1,000 715,478 - -3.26% -50.00% 1.10% 0.00% $ 9,634,865 $ 1,324,900 $ 1,399,674 $ 1,044,751 $ 1,383,965 -1.12% 270,407 $ 2010 Actual 2011 9-month Actual 2,443,489 2,002,331 4,214,129 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 8 REVENUE BUDGET 2011 - 2012 RICO Account 33241 33242 33243 39112 Description 2008 Actual RICO-ST ATTY GENERAL RICO-COUNTY ATTY RICO-COUNTY ATTY-TOWING TRANFER FROM GRANTS $ TOTAL REVENUE $ 2009 Actual 354,777 8,000 4,000 - $ 366,777 $ 2010 Actual 111,982 27,507 $ 139,489 2011 Budget 20,496 16,500 $ $ 2011 9-month Actual 36,996 160,000 - $ $ 160,000 2012 Projected 6,000 $ $ 6,000 $ 2012 % Change 155,000 - -3.13% 0.00% 0.00% 0.00% 155,000 -3.13% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 9 REVENUE BUDGET 2011 - 2012 JCEF Account 35104 35105 35110 Description 2008 Actual 2009 Actual LOCAL JCEF TIME PAYMENTS FILL THE GAP RESTRICTED MCEF SUSPENSION FEE $ 6,374 716 - $ 5,933 2,893 533 TOTAL REVENUE $ 7,090 $ 9,358 2010 Actual $ 2011 9-month Actual 2011 Budget 2012 Projected 2012 % Change 6,346 $ 648 (66) 5,000 2,000 2,500 $ 4,951 363 - $ 6,000 2,000 2,500 20.00% 0.00% 0.00% 6,928 9,500 $ 5,314 $ 10,500 10.53% $ 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 10 REVENUE BUDGET 2011 - 2012 pg 93 HOUSING 33212 33703 39101 39112 HOUSING REIMB $ CASAS PIONEER REIMB TRANSFER FROM GF (Lead) TRANSFER FROM SPECIAL PROJECTS TRANFER FROM GRANTS 118,468 TOTAL REVENUE 226,406 $ $ 138,679 $ 198,214 107,938 - - - 106,008 39,501 $ 244,687 $ 237,715 $ 268,843 50,408 $ 319,251 2011 9-month $ 129,796 23,083 - $ 37,806 $ 190,685 $ 2012 279,757 2012 4.06% 25,189 100.00% 100.00% -50.03% 304,946 -4.48% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 11 REVENUE BUDGET 2011 - 2012 WATER FUND Account Description 2008 Actual 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 2009 Actual 431,106 1,358,775 332,452 5,600 8,043 20,000 85,547 15 - 1,365,493 329,833 62,283 53,797 (83) $ 1,811,323 2010 Actual $ 2,241,537 $ 2011 Budget 1,444,657 333,438 34,767 10,996 1,430,000 331,000 20,000 10,000 89,312 267 865,124 40,000 2,778,561 2011 9-month Actual 3,561,000 289,656 1,500,000 331,000 20,000 3,000 1,096,309 249,082 22,557 2,111 34,181 42 - 1,730,000 $ 2012 Projected $ 1,404,281 1,200,000 100.00% 4.90% 0.00% 0.00% -70.00% 0.00% 0.00% 0.00% -30.64% 3,383,656 -4.98% 40,000 $ 2012 % Change 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 12 REVENUE BUDGET 2011 - 2012 WASTE WATER FUND Account 33301 34602 34602 1 36101 37001 38001 38006 39101 39107 Description 2008 Actual NAD BANK GRANT SEWER SERVICE FEES CIP SURCHARGE IMPACT FEE CHANGE INVESTMENT EARNINGS WIFA STUDY GRANT MISCELLANEOUS WIFA WW Loan Proceeds TRANSFER FROM GEN FUND TRANSFER FROM WATER TOTAL REVENUE 2009 Actual 97,774 547,902 335,240 24,112 12,500 40,903 185,103 109,007 $ 1,352,541 $ 2010 Actual 2011 9-month Actual 2011 Budget 1,922,380 552,740 338,924 8,400 11,971 664,668 340,861 36,878 2,263 1,080,000 336,000 20,000 5,000 984,368 255,350 39,824 242 9,778 - 2,147 2,374,365 15,000 4,626,804 - - - 2,780 2,683,359 - 2,844,193 $ 3,421,182 $ 6,082,804 $ 3,965,922 2012 Projected 2012 % Change - 0.00% 29.63% 0.89% 0.00% -60.00% 0.00% -73.33% -83.79% 0.00% 0.00% 2,515,000 -58.65% 1,400,000 339,000 20,000 2,000 4,000 750,000 $ 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 13 REVENUE BUDGET 2011 - 2012 SANITATION 31301 34603 36101 38001 39104 39301 2011 9-month 2012 2012 SALES TAX - CITY SUBSIDY GARBAGE COLLECTION FEE INVESTMENT EARNINGS MISCELLANEOUS TRANSFER-SPEC PROJ CAPITAL LEASE PROCEEDS $ 224,968 659,805 12,866 4,782 108,000 - $ 77,114 815,351 1,286 687 10,613 - $ 1,059,088 947 975 - $ 1,140,000 2,000 - $ 890,986 57 59 - $ 1,230,000 100 - 0.00% 7.89% -95.00% 0.00% 0.00% 0.00% TOTAL REVENUE $ 1,013,857 $ 905,050 $ 1,061,011 $ 1,142,000 $ 891,101 $ 1,230,100 7.71% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 14 REVENUE BUDGET 2011 - 2012 AIRPORT FUND Account 33221 34880 34880 36201 36201 36201 38001 39103 39104 39299 Description FEDERAL GRANTS 1 FUEL SALES (100 LL) 2 FUEL SALES (JET A) RENTAL PAYMENTS 5 SMALL HANGAR 10 TRAILER RENT MISCELLANEOUS REVENUE TRANSFER FROM LTAF TRANSFER FROM SPEC PROJ FBO LEASE PAYMENT TOTAL REVENUE 2008 Actual $ $ 2009 Actual 37,328 16,004 - 28,650 50,381 3,984 200 2,200 12,000 15,268 2,700 12,000 - 83,300 2010 Actual 2011 9-month Actual 2011 Budget $ $ 97,415 31,054 135,452 7,734 7,105 1,200 550 12,000 $ 195,095 32,000 56,430 17,250 6,000 $ 111,680 $ 2012 Projected 22,818 97,750 3,741 9,650 1,600 135,558 2012 % Change - 0.00% -6.25% 174.68% -72.17% 100.00% 100.00% 0.00% 0.00% 0.00% -100.00% 206,300 84.72% 30,000 155,000 4,800 14,100 2,400 $ pg 32 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 15 REVENUE BUDGET 2011 - 2012 GOLF COURSE Account 6001 6002 6004 6011 6012 6013 6021 6022 6023 6024 6031 6032 6040 6045 6046 6047 36201 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 PRO SHOP SALES PRO SHOP FOOD & DRINK RV PARK SPACE RENTALS COUNTRY CLUB EVENTS BEVERAGE SALES FOOD SALES COUNTRY CLUB RENT MISCELLANEOUS 2008 Actual $ $ 32,816 329,533 48,836 500 12,379 6,153 1,093 26,745 3,479 34,903 15,585 7,652 8,420 44,791 655 1,969 3,786 6,275 320 36,927 2,315 33,826 16,909 8,716 7,270 51,656 14,612 10,315 2,931 9,774 2,394 154,679 $ 2010 Actual 38,185 6,525 2,249 TRANSFER FROM SPECIAL PROJECTS SUBSIDY FROM GEN FUND CAPITAL LEASE PROCEED TOTAL REVENUE 39,571 35,985 8,293 30,139 16,505 9,296 2009 Actual $ 489,357 2011 Budget $ $ 358,191 44,500 500 1,500 4,500 7,000 500 32,500 2,500 35,500 15,000 8,000 6,000 $ 269,400 183,242 337,700 74,087 75,572 82,719 254,705 - -24.52% 157.84% 0.00% 675,124 41.31% 477,776 $ 332,902 $ $ 44,500 500 3,500 5,000 1,600 500 32,500 2,500 35,500 15,000 8,000 27,000 1,000 40,000 15,600 39,000 65,000 1,000 2012 % Change 20,400 1,000 109,593 98,783 $ 2012 Projected 24,149 232 2,983 4,430 2,900 260 20,440 2,199 20,015 11,837 4,448 5,611 1,263 29,391 8,998 28,043 12,750 2,750 543 75,000 15,000 114,918 - 266,735 - 2011 9-month Actual 0.00% 0.00% 133.33% 11.11% -77.14% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 350.00% 100.00% -46.67% 4.00% 100.00% 100.00% -100.00% 0.00% 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 2 - Page 16 GENERAL FUND ADMINISTRATION 001-51001-413 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1004 1005 2001 2002 2004 2005 2006 Salaries Sal - Limited Sal - Overtime OASI State Retire Health Ins Income Protect State Comp $ 404,136 8,419 1,181 30,108 35,909 24,766 799 775 $ 356,245 1,033 25,435 32,556 21,353 812 656 Personnel Expense $ 506,093 $ 438,091 Operating Expense 3001 4104 4105 4301 4303 5401 5801 6001 6201 6401 6501 Contractual serv Telephone Utilities Auto & Eq Maintenance Computer Maintenance Adv/Printing/Reproduction Travel/training Office supplies Postage Books/Dues/Subscrip Gas/Oil/Lube 6,922 6,178 3,553 588 13,539 12,012 8,295 1,315 10,075 696 2010 Actual 2011 Budget $ 2,045 43 282 12,030 8,330 7,322 1,240 11,474 434 2011 YTD 03/31/11 2012 Requested 2012 % Change 337,952 847 24,085 30,649 19,287 1,950 557 $ 332,772 25,457 31,946 25,792 1,584 584 $ 232,757 603 17,467 23,625 20,071 1,264 364 $ 332,772 25,457 32,845 28,410 1,445 563 0.00% 0.00% 0.00% 0.00% 2.81% 10.15% -8.79% -3.57% 415,327 $ 418,135 $ 296,151 $ 421,491 0.80% 2,168 1,200 5,000 7,780 6,000 500 9,710 700 2,598 20,793 3,823 3,822 230 6,998 310 2,000 5,000 6,000 6,000 500 9,470 700 66.67% 0.00% 0.00% 0.00% 0.00% 0.00% -22.88% 0.00% 0.00% -2.47% 0.00% 29,670 -3.95% $ 451,161 0.48% 6,663 7,901 6,313 1,035 8,942 333 Operating Expense $ 63,173 $ 43,199 $ 33,354 Total Expenses $ 569,266 $ 481,290 $ 448,681 $ 30,890 $ 449,025 $ 38,573 $ 334,725 $ pg 3 CAPITAL OUTLAY Item 0 0 Total Budget 2012 Final EMAIL 2012 Requested $ 2012 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 1 08/02/2011 2:28 PM GENERAL FUND ECONOMIC DEVELOPMENT 001-51003-465 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 YTD 03/31/11 2012 Requested Personnel Expense 1001 2001 2002 2004 2005 2006 Salaries OASI State Retire Health Ins Income Protect Workman's Comp $ 69,704 5,203 6,691 2,649 173 155 $ 76,110 5,694 7,191 2,649 173 168 66,254 4,966 4,998 1,987 328 157 $ - $ - $ - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Personnel Expense $ 84,575 $ 91,985 78,690 $ - $ - $ - 0.00% 25,000 10,000 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Operating Expense 3001 4104 4301 5801 6001 6201 6401 6501 8009 Contractual Telephone Auto/equip Travel/training Office supplies Postage Books/dues/subscrip Gas/oil/lube Marketing/Promotions 635 3,606 893 6,594 4,103 465 755 2,062 - Operating Expense $ Total Expenses 19,113 $ 1,338 4,520 1,875 330 1,595 2,077 16,031 $ 562 25,000 10,000 1,575 759 42 324 486 25,116 200 42,471 2012 % Change 27,765 $ 28,864 $ 35,000 $ 42,671 $ 35,000 0.00% $ 103,688 $ 119,750 $ 107,554 $ 35,000 $ 42,671 $ 35,000 0.00% 2012 Requested 2012 Approved* *Budgeted in GF Department 1801 pg 4 CAPITAL OUTLAY Items 0 Total Budget 2012 Final EMAIL $ - $ - Section 3 - Page 2 08/02/2011 2:28 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 2008 Actual 2009 Actual 2010 Actual 33,855 36,280 18,102 7,539 7,182 6,018 2,649 125 208 34,588 43,820 5,386 4,435 6,637 4,150 2,649 126 191 10,647 45,870 9 5,449 545 441 34 315 $ Operating Expense 3001 4104 4105 4302 5801 6001 6201 6401 6601 Contractual serv Telephone Utilities Building Maintenance Travel/training Office supplies Postage Books/Dues/Subscrip Uniforms Museum Collections Museum ProShop 8009 Marketing/Promotions 111,958 $ 11,676 1,449 11,293 3,329 101,982 156 17,277 13,546 2,437 2,447 309 13,917 545 - 5,224 3,822 107 $ 63,310 2011 YTD 03/31/11 2011 Budget 18,442 0 9,194 43 756 408 11 28 1,411 1,770 114 36 $ 8,867 21,773 2012 Requested $ 10,440 10,076 1,126 922 108 6,959 202 8,000 10,000 1,500 2,500 200 13,917 - 5,132 5,917 1,433 121 2,611 82 10,438 19 1,087 3,000 - 18,442 $ 2012 % Change pg 5 1,411 1,820 93 33 0.00% 0.00% 0.00% 0.00% 0.00% 2.81% 0.00% -18.14% -7.21% 21,800 0.12% 10,000 10,000 3,000 1,000 3,500 200 15,000 200 5,000 3,000 3,000 25.00% 0.00% 0.00% 100.00% 100.00% 40.00% 0.00% 7.78% 100.00% 100.00% 100.00% 0.00% Operating Expense $ 31,832 $ 55,701 $ 29,346 $ 39,117 $ 25,752 $ 53,900 37.79% Total Expense $ 143,790 $ 157,683 $ 92,656 $ 60,890 $ 36,192 $ 75,700 24.32% CAPITAL OUTLAY Item Floor Replacement Total Budget 2012 Final EMAIL 2012 Requested 5,000 $ 5,000 2012 Approved* *Budgeted in GF Department 1801 5,000 $ 5,000 Section 3 - Page 3 08/02/2011 2:28 PM GENERAL FUND PARKING LOT 001-51007-419 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget Personnel Expense 1003 Sal - Temp 2001 OASI 2006 State Comp Personnel Expense Operating Expense 3001 4105 4302 6001 6601 2011 YTD 03/31/11 36,500 2,792 71 $ Contractual Services Utilities Building Maintenance Office supplies Uniforms - $ - - $ - $ $10 - - 39,364 25,075 2,030 44 $ 250 1,000 500 500 100 Operating Expense $ - $ - $ 10 $ 2,350 Total Expense $ - $ - $ 10 $ 41,714 2012 Requested 27,149 $ $90 2,286 100 315 63 $2,853 $ $ 30,001 $ 2012 % Change pg 5 36,500 2,792 66 0.00% 0.00% -7.21% 39,358 -0.01% 180 3,300 500 500 100 -28.00% 230.00% 0.00% 0.00% 0.00% 4,580 94.89% 43,938 5.33% CAPITAL OUTLAY Item Floor Replacement Total Budget 2012 Final EMAIL 2012 Requested 5,000 $ 5,000 2012 Approved* *Budgeted in GF Department 1801 5,000 $ 5,000 Section 3 - Page 4 08/02/2011 2:28 PM GENERAL FUND FINANCE 001-51201-415 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 Salaries Sal - Temp Sal - Ltd Sal - Overtime OASI State Retire Health Ins Income Protect State Comp $ 222,945 7,562 34,721 4,460 19,350 25,409 27,779 663 596 $ 269,097 616 2,076 363 19,440 25,657 30,526 834 600 Personnel Expense $ 343,485 $ 349,209 Operating Expense 3001 4104 4303 5401 5801 6001 6201 6401 Contractual serv Telephone Computer Maintenance Advertising Travel/training Office supplies Postage Books/Dues/Subscrip 33,759 5,973 740 547 2,312 11,169 2,262 6,520 2011 YTD 03/31/11 2010 Actual 2011 Budget $ 40,644 118 2,275 9,392 2,389 3,133 2012 Requested 2012 % Change pg 6 288,604 207 20,750 26,125 31,165 1,920 546 $ 308,920 23,632 29,656 37,517 1,768 603 $ 215,997 366 551 16,432 21,935 25,757 1,418 375 $ 314,533 24,062 31,044 36,667 1,529 570 1.82% 0.00% 0.00% 0.00% 1.82% 4.68% -2.27% -13.52% -5.53% 369,317 $ 402,097 $ 282,832 $ 408,405 1.57% 129,490 500 5,000 10,600 6,400 570 107,149 1,194 2,869 8,477 7,841 534 116,140 750 3,125 10,000 8,100 620 -10.31% 0.00% 0.00% 50.00% -37.50% -5.66% 26.56% 8.77% 51,981 722 2,500 7,004 2,114 1,426 Operating Expense $ 63,282 $ 57,951 $ 65,747 $ 152,560 $ 128,064 $ 138,735 -9.06% Total Expenses $ 406,767 $ 407,159 $ 435,064 $ 554,657 $ 410,896 $ 547,140 -1.36% CAPITAL OUTLAY 2012 Requested Items 0 0 Total Budget 2012 Final EMAIL $ - 2012 Approved* *Budgeted in GF Department 1801 $ - Section 3 - Page 5 08/02/2011 2:28 PM GENERAL FUND HUMAN RESOURCES 001-51301-415 Account Description 2008 Actual 2009 Actual 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 $ 127,160 6,869 20,727 369 11,438 15,936 9,176 336 344 14,844 27,766 2,772 3,200 2,200 - $ 149,110 209 12,813 4 11,946 15,300 10,305 400 358 7,550 7,013 2,714 3,000 2,400 - Personnel Expense $ 243,137 $ 223,122 2010 Actual 2011 YTD 03/31/11 2011 Budget 2012 Requested 2012 % Change pg 7 Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2008 2009 2010 2011 Operating Expense 2012 2013 2015 3001 4104 4303 5201 5202 5401 5801 6001 6201 6401 Awards Program Safety/Wellness Prog HRA Claims Contractual serv Telephone Computer Maint/Supply Liability Insurance Insurance Claims Advertising Travel/training Office supplies Postage Books/Dues/Subscrip 7,184 12,659 5,058 3,379 492 164,933 29,847 611 5,526 3,471 903 1,234 $ 5,714 7,409 3,261 168,725 14,387 1,898 3,827 1,730 475 1,134 155,798 8,315 7 12,012 14,094 10,283 975 310 10,390 5,224 1,601 3,300 2,400 - $ 155,585 7,700 12,491 14,936 17,154 819 319 10,000 15,000 3,700 3,000 2,000 - $ 111,216 1,955 1,758 9,061 11,446 7,622 676 198 6,555 2,319 1,318 2,475 1,725 - $ 166,054 6,095 13,169 16,991 13,854 793 312 10,000 15,000 3,000 3,000 2,000 - 6.73% -100.00% 100.00% 0.00% 5.43% 13.76% -19.24% -3.18% -2.18% 0.00% 0.00% -18.92% 0.00% 0.00% 224,710 $ 242,704 $ 158,325 $ 250,268 3.12% 4,800 3,300 31,910 150,000 50,000 500 5,800 2,000 300 1,535 37.14% 65.00% -100.00% 59.31% 0.00% 0.00% -16.67% -16.67% 0.00% -22.67% -20.00% -33.33% 78.49% 3,767 4,149 60,008 13,691 3,500 2,000 125,000 20,030 180,000 60,000 500 7,500 2,500 450 860 123,132 19,254 432 5,785 1,806 464 626 4,319 289 39,566 12,008 100,342 33,443 4,547 1,015 260 973 Operating Expense $ 235,297 $ 208,558 $ 233,114 $ 402,340 $ 196,760 $ 250,145 -37.83% Total Expense $ 478,434 $ 431,681 $ 457,824 $ 645,044 $ 355,086 $ 500,413 -22.42% Section 3 - Page 6 Budget 2012 Final EMAIL 08/02/2011 2:28 PM GENERAL FUND HUMAN RESOURCES 001-51301-415 CAPITAL OUTLAY 2012 Requested Item 0 0 Total $ 2012 Approved* - $ *Budgeted in GF Department 1801 - Section 3 - Page 6 Budget 2012 Final EMAIL 08/02/2011 2:28 PM MANAGEMENT INFORMATION SYSTEMS 001-51401-419 Account Description Personnel Expense 1001 Salaries 1003 Sal - Temp 1004 Sal - Limited 1005 Sal - Overtime 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp Personnel Expense 2008 Actual 2009 Actual $ $ $ $ $ 147,873 2,305 12,489 36 11,836 15,156 17,997 460 354 $ 208,505 80,829 1,488 590 6,256 7,816 5,578 280 184 $ Operating Expense 3001 Contractual serv 4104 Telephone 4301 Auto/Equip Maint 4303 Computer Maint/Supp 5801 Travel/training 6001 Office supplies 6201 Postage 6401 Books/Dues/Subscrip 6501 Gas/oil/lube 103,021 60,584 24,721 273 233 2,430 3,946 315 199 2010 Actual $ 97,119 208,198 6,375 283 2,446 46 498 2011 Budget 2011 YTD 03/31/11 2012 2012 Requested % Change $ 158,353 $ 7,450 $ 39,412 15,699 19,519 21,835 873 177 2.33% 100.00% 58.64% 0.00% 14.27% 13.22% 13.41% -5.74% 0.98% 153,505 26,931 298 12,743 16,343 19,253 1,119 159 $ 154,743 $ 24,844 13,738 17,240 19,253 927 175 $ 105,407 $ 2,031 $ 21,385 408 9,314 12,898 14,456 734 118 230,352 $ 230,920 $ 166,753 $ 263,318 14.03% 192,525 130,832 20,000 7,800 3,000 100 500 800 98,603 125,773 8,858 600 1,174 28 697 257,025 171,475 30,000 5,200 3,000 100 500 1,600 33.50% 31.07% 0.00% 50.00% -33.33% 0.00% 0.00% 0.00% 100.00% 160,696 158,968 37,069 5,377 3,110 70 569 Operating Expense $ 92,701 $ 314,965 $ 365,859 $ 355,557 $ 235,733 $ 468,900 31.88% Total Expense $ 195,722 $ 523,470 $ 596,211 $ 586,477 $ 402,486 $ 732,218 24.85% pg 8 CAPITAL OUTLAY Items 31 Desktops Replacement 8 Notebooks 9 Printers 1 UPS for Police TOTAL Budget 2012 Final EMAIL 2012 Requested 60,000 1,500 12,400 50,000 $ 123,900 Section 3 - Page 7 2012 Approved* *Budgeted in GF Department 1801 60,000 1,500 12,400 $ 73,900 08/02/2011 2:28 PM GENERAL FUND GENERAL GOVERNMENT 001-51501-413 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1006 2001 2006 2014 Salaries Vac/Sick Leave Pay-outs OASI State Comp $ 19,000 1,454 42 - $ 18,214 1,394 41 5,277 Personnel Expense $ 20,496 $ 24,925 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 Contingency/Reserve Fireworks DARC-Utilities Economic Development Employee Reward Program Special Events Mariachi Festival/Event Winter Visitor Expense 4th of July Expense Youth Activity Expense League of Cities Event Transfer to HURF Transfer to Enterprise Transfer to Housing Golf Course Subsidy Transfer to Grants $ 62,816 24,391 2,295 10,724 6,150 1,599 32 1,422 1,910 2,737 1,807 $ 20,910 1,336 5,141 3,816 3,373 1,361 663 1,520 747 1,761 1,806 Operating Expense $ 1,117,997 $ 378,506 Total Expenses $ 1,138,493 $ 403,431 Operating Expense 3001 3004 3005 3101 3102 3103 3104 3105 3106 3107 3108 6401 8003 8004 8005 8006 8008 8101 8102 8103 8104 8106 8109 9902 9910 9911 9913 9915 Budget 2012 Final EMAIL Retirement Incentives 5,515 20,030 13,000 32,427 2011 Budget 2011 YTD 03/31/11 18,589 1,424 35 23,775 $ 18,000 91,378 1,377 35 - $ 12,911 1,045 22 3,470 $ 18,000 50,000 1,377 33 - 0.00% -45.28% 0.00% -7.21% 0.00% 43,824 $ 110,790 $ 17,448 $ 69,410 -37.35% 58,333 $ 10,080 52,398 4,031 3,520 958 (113) 1,985 26 1,233 996 18,868 20,000 13,000 774 13,344 5,108 1,673 120,000 114,918 6,245 17,000 5,000 3,000 3,000 1,000 1,000 1,000 1,000 1,000 1,000 20,150 100,000 20,000 2,500 2,150 1,000 8,000 1,000 1,300 170,000 $ 3,131 315 108,548 1,553 1,624 693 51 333 988 708 1,082 16,384 1,196 4,483 1,844 127,500 - $ 31,000 5,000 3,000 3,000 1,300 1,300 1,300 1,300 1,300 1,300 21,250 70,000 20,000 1,000 2,150 1,000 8,000 1,000 1,900 240,000 98,783 - 74,087 - 254,705 - 0.00% 82.35% 0.00% 0.00% 0.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 5.46% -30.00% 0.00% 0.00% 0.00% -60.00% 0.00% 0.00% 0.00% 0.00% 0.00% 46.15% 41.18% 0.00% 0.00% 157.84% 0.00% $ 447,376 $ 458,883 $ 344,519 $ 670,805 46.18% $ 491,200 $ 569,673 $ 361,967 $ 740,215 29.94% 2010 Actual $ 20,068 13,000 490 3,805 - 9,550 1,740 3,423 - 7,781 11,445 - 300,000 335,103 107,938 154,679 18,709 266,735 12,750 Section 3 - Page 8 2012 Requested 2012 % Change pg 9 08/02/2011 2:28 PM SPECIAL EVENTS SUPPORT FY 10/11 EVENT AMOUNT REQUESTED DOUGLAS SENIOR CITIZENS TOTAL SPECIAL EVENTS Budget 2012 Final EMAIL AMOUNT RECOMMENDED 2,100 $ 2,100 Section 3 - Page 8A $ 2,150 2,150 AMOUNT APPROVED $ - 08/02/2011 2:28 PM GENERAL FUND MAGISTRATE 001-51601-412 Account Description 2008 Actual Personnel Expense 1001 1003 1005 2001 2002 2004 2005 2006 Salaries Sal - Temp Sal - Overtime OASI Retirement Health Ins Income Prot. State Comp $ 65,797 5,003 383 5,246 6,353 7,574 242 157 $ 67,577 6,952 22 5,507 6,388 7,759 247 164 Personnel Expense $ 90,755 $ 94,617 Operating Expense 3001 4104 5801 6001 6201 6401 Contractual Services Telephone Travel/Training Office Supplies Postage Books/Dues/Subscr. 2009 Actual 18,158 1,742 1,108 2,345 780 283 2010 Actual $ 19,709 29 801 653 157 2011 YTD 03/31/11 2011 Budget 2012 Requested 2012 % Change 67,179 479 26 4,989 6,071 7,525 498 129 $ 53,398 4,085 5,126 7,528 331 104 $ 33,414 2,581 3,370 2,514 238 57 $ 52,748 4,035 5,206 8,257 267 96 -1.22% 0.00% 0.00% -1.22% 1.56% 9.69% -19.13% -8.34% 86,895 $ 70,571 $ 42,175 $ 70,609 0.05% 15,000 - -7.52% 0.00% -100.00% -100.00% -100.00% -100.00% 19,712 16,220 152 640 440 160 35 480 628 - 11,250 41 208 467 25 Operating Expense $ 24,416 $ 21,349 $ 20,855 $ 17,612 $ 11,991 $ 15,000 -14.83% Total Expense $ 115,171 $ 115,966 $ 107,750 $ 88,183 $ 54,166 $ 85,609 -2.92% pg 10 CAPITAL OUTLAY 2012 Requested Items 0 Total Budget 2012 Final EMAIL $ 2012 Approved* - $ Section 3 - Page 9 *Budgeted in GF Department 1801 - 08/02/2011 2:28 PM GENERAL FUND LIBRARY 001-51701-412 Account Description 2008 Actual 2009 Actual 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 $ $ Personnel Expense $ Operating Expense 3001 4104 4105 4302 4303 5401 5801 6001 6005 6201 6401 199,491 41,520 60 17,940 18,832 14,337 634 605 Contract Serv Telephone Utilities Building Maintenance Computer Maintenance Advertising & Printing Travel/training Office supplies Library Materials Postage Books/Dues/Subscrip 293,419 $ 2010 Actual 182,518 39,210 187,381 36,065 105 16,369 17,256 14,667 646 879 16,452 16,953 14,198 1,307 858 271,650 $ 273,213 2011 YTD 03/31/11 2011 Budget $ 192,243 38,000 291,587 15,300 2,792 26,974 11,080 2,492 14,388 27,049 5,366 - 12,384 33,134 3,369 - 12,435 30,000 5,000 - 546 7,776 27,231 2,221 160 130 9,364 25,996 1,661 60 7,366 25,547 953 - 7,500 30,000 1,000 - 2012 % Change $ 108,753 21,500 10,302 69 11,115 12,305 9,528 765 595 $ 122,012 38,000 25,043 14,157 14,514 17,493 676 335 -36.53% 0.00% 100.00% 0.00% -19.63% -21.35% -26.17% -40.23% -25.42% $ 174,932 $ 232,230 -20.36% 8,463 26,075 6,982 5,490 12,186 615 - 15.13% 0.00% 33.33% 10.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% -11.91% 17,614 18,455 23,694 1,131 450 $ 2012 Requested Operating Expense $ 96,572 $ 84,014 $ 82,753 $ 85,935 $ 59,811 14,316 40,000 5,500 2,000 7,500 30,000 1,000 $ 100,316 Total Expenses $ 389,991 $ 355,664 $ 355,966 $ 377,522 $ 234,743 $ 332,546 pg 11 16.73% CAPITAL OUTLAY 2012 Requested Items 1 Replacement A/C Unit 0 Total Budget 2012 Final EMAIL $ 12,000 12,000 2012 Approved* $ Section 3 - Page 10 *Budgeted in GF Department 1801 - 08/02/2011 2:28 PM GENERAL FUND COMMUNITY DEVELOPMENT NEIGHBORHOODS/GRANTS 001-52001-419 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget Personnel Expense 1001 1005 2001 2002 2004 2005 2006 Salaries Salaries/OT OASI State Retire Health Ins Income Protect Workman's Comp $ 264,858 551 19,211 25,135 29,870 826 4,448 $ 224,519 43 16,000 21,220 28,587 721 4,766 Personnel Expense $ 344,899 $ 295,855 2,566 4,650 2,057 471 563 - 4,362 5,159 934 1,779 4,916 - Operaitng Expense 3001 4104 4301 4303 5401 5801 6001 6201 6301 6401 6500 6601 Contractual Services Telephone Auto/equip Computer Maintenance Advertising Travel/training Office supplies Postage Small Tools & Equipment Books/dues/subscrip Gas/oil/lube Uniform Operating Expense $ 26,894 Total Expenses $ 371,793 $ 2011 YTD 03/31/11 2012 Requested 2012 % Change 71,972 62 5,000 6,518 10,664 503 1,600 $ 86,763 6,637 8,329 14,452 537 2,265 $ 38,483 2,759 3,928 5,076 258 973 $ 68,006 5,202 6,712 10,847 345 1,707 -21.62% 0.00% -21.62% -19.41% -24.94% -35.83% -24.63% 96,319 $ 118,984 $ 51,478 $ 92,819 -21.99% 646 4,024 497 691 3 483 1,773 384 - 900 500 1,200 500 865 500 1,000 700 826 2,703 - 1,600 - 100 1,000 200 1,000 200 0.00% 0.00% 0.00% 0.00% -3.89% 0.00% -16.67% 40.00% 0.00% -100.00% 0.00% 0.00% 9,258 $ 305,113 $ $ 4,934 $ 101,253 $ 3,912 895 376 120 1,008 95 4,400 $ 6,407 $ 4,265 -3.07% $ 123,384 $ 57,885 $ 97,084 -21.32% pg 14 CAPITAL OUTLAY Items Total Budget 2012 Final EMAIL 2012 Requested 0 0 $ - 2012 Approved* *Budgeted in GF Department 1801 $ - Section 3 - Page 11 08/02/20112:28 PM GENERAL FUND CEMETERY 001-52021-452 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 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 $ 137,481 $ 138,459 64,422 4,374 9,845 13,618 21,902 499 5,951 3,405 10,001 13,294 18,879 415 5,073 305 4,404 5,856 12,835 460 2,454 Personnel Expense $ 193,670 $ 189,528 Operating Expense 3001 4104 4105 4301 4302 5501 5801 6001 6002 6021 6301 6501 6601 6701 Contractual Services Telephone Utilities Auto/equip Building Maintenance DOC Labor Travel/training Office supplies Operating supplies Chemicals Small tools & Eq Gas/oil/lube Uniforms Construction materials $ 27,525 Total Expense $ 221,195 90,736 65,481 $ 500 5,048 6,334 12,835 407 2,794 $ 93,399 42,199 2012 Requested 61,452 pg 15 $ $ 29,267 10,920 500 3,113 4,016 7,278 175 1,235 -55.31% 100.00% 0.00% -38.34% -36.60% -43.29% -57.07% -55.81% $ 56,503 -39.50% -80.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 50.00% 0.00% 949 2,820 4,353 9,244 306 1,580 $ 2012 % Change 430 3,324 1,424 2,734 122 417 1,825 2,335 1,114 2,467 552 5,130 $1,000 3,500 1,500 2,500 150 250 2,000 2,500 500 2,000 400 4,000 3,106 1,364 1,716 107 2,286 500 577 2,399 434 3,005 $200 3,500 1,500 2,500 150 250 2,000 2,500 500 2,000 600 4,000 21,874 $20,300 $15,627 $19,700 -2.96% $ 211,620 $ 112,610 $ 113,699 76,203 -32.98% 2012 Requested 5,000 1,500 2,000 1,200 $ 9,700 2012 Approved* *Budgeted in GF Department 1801 $ - 332 4,205 3,587 1,176 2,024 1,032 2,395 2,009 674 3,586 827 5,678 Operating Expense $ $ 2011 YTD 03/31/11 3,839 1,126 1,982 92 279 2,051 3,052 162 3,260 1,192 5,058 $ 22,092 $ $135 $ 77,078 $ CAPITAL OUTLAY Items Remodel Public Restrooms Roof repairs to main building Chain Link fencing Push Mowers TOTAL Budget 2012 Final EMAIL Section 3 - Page 12 08/02/2011 2:28 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 Budget 2012 Final EMAIL 2012 Requested 2012 % Change 238,517 94,296 500 25,498 32,898 50,245 1,348 8,053 -11.89% 0.00% 31.15% 0.00% -2.85% -0.12% -16.23% -26.97% -14.98% 306,897 317,466 307,534 270,706 4,099 22,843 29,844 35,406 1,117 8,103 2,653 23,211 30,247 45,886 1,172 8,802 910 21,900 27,915 51,899 2,219 8,588 71,901 500 26,248 32,938 59,979 1,845 9,472 179,981 2,431 31,212 1,123 15,620 20,067 33,747 1,310 5,200 $ 408,309 $ 429,438 $ 420,965 $ 473,590 $ 290,690 $ 451,355 -4.70% 499 31,987 1,031 45,227 3,574 28 17,333 39,950 8,699 3,627 181 2,318 8,348 1,576 4,157 75 22,322 2,997 17,644 882 35,427 896 23,998 47 36 633 39,571 7,865 1,315 204 4,033 12,377 1,872 14,475 3,202 14,943 74 37,336 1,131 46,201 31,249 10,437 1,092 57 766 7,900 607 13,809 3,162 7,685 3,000 25,000 40,000 15,000 7,000 1,000 500 10,000 7,000 1,000 14,000 2,000 3,000 24,161 923 29,600 18,428 7,758 216 6,982 2,888 87 12,017 2,138 2,053 25,000 1,000 40,000 6,500 10,000 1,000 500 19,500 7,500 1,000 14,000 3,000 3,000 -100.00% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% -56.67% 42.86% 0.00% 0.00% 95.00% 7.14% 0.00% 0.00% 0.00% 0.00% 50.00% 0.00% Operating Expense $ 211,573 $ 161,776 $ 161,505 $ 128,500 $ 107,252 $ 132,000 2.72% Total Expenses $ 619,882 $ 591,213 $ 582,470 $ 602,090 $ 397,941 $ 583,355 -3.11% Personnel Expense Operating Expense 3001 4101 4102 4103 4104 4105 4301 4302 5501 5801 6001 6002 6021 6025 6301 6401 6501 6601 6701 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 YTD 03/31/11 Contractual Services Electric Gas Water/Sewer/Sanitation Telephone Utilities Auto/equip Building Maintenance DOC Labor Travel/training Office supplies Operating supplies Supplies/Chemicals Rye Grass Seed Small tools Books/dues/subscrip Gas/oil/lube Uniforms Construction materials Section 3 - Page 13 pg 16 08/02/2011 2:28 PM GENERAL FUND PARKS 001-52023-452 CAPITAL OUTLAY Items 1 Ride Mowers Motor for liner Power Washer Gator Utility Vehicle Playground replacement equipment Roofing Materials for Airport Park Ramadas Roof for Paseo and Airport Pump House Utility Vehicle for Herbicide Sprayer Total Budget 2012 Final EMAIL 2012 Requested 11,500 3,000 4,000 9,000 10,000 5,000 20,000 12,000 $ 74,500 2012 Approved* *Budgeted in GFDepartment 1801 11,500 3,000 4,000 10,000 5,000 $ 33,500 Section 3 - Page 13 08/02/2011 2:28 PM GENERAL FUND RECREATION 001-52031-451 Account Descriptions 2008 Actual 2009 Actual 2010 Actual 2011 Budget 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 $ Personnel Expense Operating Expense 4104 4105 4301 4302 4303 5401 5801 6001 6007 6008 6201 6401 6501 6601 68,051 40,679 1,913 2,317 8,563 5,998 4,821 193 1,320 27,288 47,482 10,275 1,149 6,369 4,342 6,104 270 2,423 $ 184,782 $ 133,855 7,900 10,206 505 5,318 3,926 2,184 7,459 25,568 1,354 52 595 1,364 1,308 42 16,837 10 6,640 683 4,083 16,408 10 75 1,176 53 Telephone Utilities Auto & Equipment Building Maintenance Computer Maintenance Advertising & Printing Travel & Training Office Supplies Recreation Cost Basketball League Postage Books/Dues/Subscriptions Gas/Oil/Lubricants Uniforms 70,550 53,259 18,430 10,426 11,600 9,530 9,066 255 1,666 67,739 $ $ 46,018 $ 2011 YTD 03/31/11 2012 Requested 2012 % Change 13,805 50,000 23,515 500 6,718 3,631 3,209 146 2,424 $ 10,805 28,193 9,441 341 3,736 2,017 2,409 102 1,200 $ 17,639 48,000 500 5,060 1,790 3,639 91 1,598 27.78% -4.00% -100.00% 0.00% -24.69% -50.69% 13.41% -37.76% -34.09% $ 105,702 $ 103,947 $ 58,244 $ 78,317 -24.66% 11,754 3,816 971 - 12,000 4,000 1,400 1,000 1,500 16,000 100 250 900 700 12,000 3,700 2,000 1,500 15,000 50 375 1,000 900 0.00% 0.00% 0.00% -7.50% 0.00% 42.86% -100.00% 0.00% -6.25% 0.00% -50.00% 50.00% 11.11% 28.57% 2,136 5,581 6 635 693 $ 25,593 Operating Expense $ Total Expenses $ 252,521 $ 179,873 2012 Requested 2012 Approved* *Budgeted in GF Department 1801 $ 131,295 $ 9,269 2,289 36 375 659 6,301 369 516 37,850 $ 19,814 $ 36,525 -3.50% $ 141,797 $ 78,057 $ 114,842 -19.01% pg 18 CAPITAL OUTLAY Items 0 0 Total Budget 2012 Final EMAIL $ - $ - Section 3 - Page 14 08/02/2011 2:28 PM GENERAL FUND AQUATICS 001-52035-451 Account Description 2008 Actuals 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 4104 4105 4106 4301 4304 5401 5801 6001 6007 6011 6012 6013 6201 6501 6601 Budget 2012 Final EMAIL 86,761 124,509 2009 Actual $ 13,577 Contractual Services Telephone Utilities Utilities-Aquatic Center Auto Equipment & Repair Maint.Cost-Aquatic Center Advertising & Printing Travel/training Office supplies Recreation Cost Swimming Pool Aquatic Center Concession Aquatic Center-Pro Shop Postage Gas/oil/lube Uniforms 96,832 83,704 1,851 13,846 14,516 6,927 13,568 353 5,398 16,824 10,026 12,005 319 5,087 269,108 2010 Actual $ 2,682 5,530 94,936 1,826 17,557 1,787 2,871 3,377 3,203 23,108 1,511 948 126 4,487 2,882 236,994 $ 2011 Budget 72,776 74,062 13,208 333 3,276 11,949 5,607 13,019 473 4,654 $ 66,571 61,000 5,963 500 19,000 11,707 4,361 12,835 413 4,754 199,358 $ 187,104 127 8,225 71,535 6,526 78,279 10,624 233 2,734 1,320 591 24,906 1,194 1,506 2,252 1,781 14,521 794 1,838 1,421 11,222 373 1,540 1,885 1,931 180 2,000 50,000 10,000 500 500 10,000 500 500 50 1,000 1,400 $76,630 Operating Expense $ 166,831 $ 131,946 $ 115,411 Total Expenses $ 435,939 $ 368,940 $ 314,768 Section 3 - Page 15 $ 263,734 2011 YTD 03/31/11 $ 37,743 44,891 5,254 1,103 291 7,015 4,078 5,211 273 2,179 2012 Requested 64,606 70,000 500 10,000 11,101 6,426 9,236 329 4,409 -2.95% 14.75% -100.00% 0.00% -47.37% -5.18% 47.36% -28.04% -20.51% -7.27% $ 108,036 $ 176,606 $0.58 -5.61% $135 3,234 30,331 13,281 103 2,779 659 76 6,974 2,940 1,513 580 $ 2012 % Change 180 2,000 70,000 13,000 1,000 700 1,500 1,000 13,500 1,000 1,000 50 1,500 2,000 0.00% 0.00% 0.00% 40.00% 0.00% 30.00% 100.00% 40.00% 200.00% 100.00% 35.00% 100.00% 100.00% 0.00% 50.00% 42.86% $62,605 $ 108,430 41.50% $ 170,641 $ 285,036 pg 19 8.08% 08/02/2011 2:28 PM GENERAL FUND AQUATICS 001-52035-451 CAPITAL OUTLAY 2012 Requested Items Office Roof Replacement Tile Replacement ADA Compliance Hydraulic Chairs Total Budget 2012 Final EMAIL 2012 Approved* 2,000 5,500 7,000 $ 14,500 *Budgeted in GF Dept 1801 2,000 7,000 $ Section 3 - Page 15 9,000 08/02/2011 2:28 PM GENERAL FUND PUBLIC WORKS ADMINISTRATION 001-54001-431 Account Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1004 Sal-Ltd 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp Personnel Expense 2008 Actual 2009 Actual $ 39,933 3,778 79,515 448 9,419 11,606 1,945 84 3,256 $ 60,562 76,215 397 10,301 12,959 2,740 136 3,863 $ 149,984 $ 167,174 Operating Expense 3001 Contractual serv 4104 Telephone 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 725 3,004 673 563 49 4,799 4,175 6,038 633 1,235 435 729 283 3,939 2,868 2,196 354 368 359 670 656 - - 2010 Actual $ 2011 YTD 03/31/11 2011 Budget 2012 Requested 2012 % Change pg 20 258,085 18,530 22,100 27,199 1,603 5,948 $ 161,094 12,324 15,465 20,869 964 4,178 $ 107,700 6,041 8,337 10,600 14,940 701 68 $ 131,975 3,770 10,384 13,026 20,575 669 3,376 -18.08% 100.00% 0.00% 0.00% -15.74% -15.77% -1.41% -30.58% -19.20% 333,464 $ 214,894 $ 148,386 $ 183,775 -14.48% 700 350 3,000 2,700 500 600 450 90 1,820 2,200 240 - -22.22% 0.00% 0.00% -12.50% 0.00% -14.29% 0.00% 0.00% -14.29% 0.00% 0.00% 193.55% -2.22% 0.00% 0.00% 0.00% 5,931 1,928 3,482 5,314 2,116 420 41 317 1,823 362 2,034 8,983 900 400 3,500 2,700 500 700 450 90 620 2,250 240 - 29 4 2,465 3,002 628 362 1,013 738 92 2,699 1,704 Operating Expense $ 22,729 $ 12,020 $ 32,751 $ 12,350 $ 12,734 $ 12,650 2.43% Total Expenses $ 172,713 $ 179,194 $ 366,215 $ 227,244 $ 161,121 $ 196,425 -13.56% CAPITAL OUTLAY Items Rivera Building Remodel 0 Total Budget 2012 Final EMAIL 2012 Requested $ 2012 Approved* - $ Section 3 - Page 16 *Budgeted in GF Department 1801 - 08/02/2011 2:28 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 Budget 2012 Final EMAIL 2008 Actual 150,371 2009 Actual $ $ 154,731 2,200 2,623 11,478 15,075 21,902 556 5,450 $ 214,016 9,295 11,444 15,328 21,902 541 4,550 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 213,431 14,951 34,465 6,481 15,224 35,017 3,601 1,708 20,205 3,185 284 278 380 2,968 26 5,302 528 1,087 5,478 - 13,751 4,392 323 105 1,180 473 745 3,809 1,238 3,853 - 2010 Actual $ 2011 YTD 03/31/11 2011 Budget 2012 Requested 2012 % Change 160,040 82,417 988 17,685 22,011 21,902 1,436 16,608 $ $ 187,838 57,694 1,000 18,860 23,667 26,781 1,310 14,177 $ $ 115,506 51,800 1,096 12,834 17,059 16,353 953 10,258 $ $ 187,544 65,641 1,000 19,445 25,088 28,410 1,104 17,174 -0.16% 13.77% 0.00% 3.10% 6.00% 6.08% -15.72% 21.14% 323,086 $ 331,327 $ 225,859 $ 345,406 4.25% 15,000 27,000 4,500 2,500 10,000 35,000 450 1,350 450 450 4,000 450 1,500 3,200 4,500 10,000 7.53% 0.00% 0.00% 0.00% 0.00% 122.22% 16.67% 0.00% 0.00% 0.00% 0.00% 0.00% 26.98% 0.00% 25.00% 0.00% 0.00% 0.00% 14,593 35,273 2,659 3,143 13,950 27,000 4,500 2,500 4,500 30,000 450 1,350 450 450 3,150 450 1,200 3,200 4,500 10,000 14,506 31,183 558 3,114 523 4,268 1,678 851 - 17,165 26,144 2,535 1,329 9,052 31,733 2,937 258 1,403 415 603 3,697 1,168 52 643 5,683 Operating Expense $ 97,326 $ 83,711 $ 112,349 $ 107,650 $ 104,815 $ 120,350 11.80% Total Expenses $ 310,757 $ 297,727 $ 435,435 $ 438,977 $ 330,675 $ 465,756 6.10% Section 3 - Page 17 pg 17 08/02/2011 2:28 PM GENERAL FUND PW CONSTRUCTION 001-54018-431 CAPITAL OUTLAY Items City Hall Boiler Replacement (1st floor) City Hall AHU Heating unit (1st floor) City Hall Chiller (1st floor) Total Budget 2012 Final EMAIL 2012 Requested $ 45,000 40,000 80,000 165,000 Section 3 - Page 17 2012 Approved* $ *Budgeted in GF Department 1801 - 08/02/2011 2:28 PM GENERAL FUND PUBLIC WORKS FLEET MAINTENANCE 001-54031-431 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1005 2001 2002 2004 2005 2006 Salaries Sal-OT OASI State Retire Health Ins Income Protect State Comp $ 150,906 1,445 10,958 14,626 18,133 536 3,763 $ 153,702 107 11,079 14,533 18,133 548 4,066 Personnel Expense $ 200,367 $ 202,167 Operating Expense 3001 4104 4105 4301 5801 6001 6002 6301 6302 6401 6501 6601 Contractual Services Telephone Utilities Auto/Equip Travel/training Office supplies Operating supplies Small tools Safety Equipment Books/Dues/Subscrip Gas/oil/lube Uniforms Operating Expense Total Expenses 2010 Actual $ 2011 YTD 03/31/11 2011 Budget 2012 Requested 2012 % Change 161,882 11,596 14,646 18,133 1,132 3,965 $ 161,199 500 12,370 15,523 21,473 977 3,746 $ 99,248 7,809 9,529 11,174 660 2,219 $ 123,241 500 9,466 12,213 13,854 626 2,659 -23.55% 0.00% -23.47% -21.32% -35.48% -35.92% -29.03% 211,354 $ 215,789 $ 130,639 $ 162,559 -24.67% 2,822 5,214 4,512 304 2,279 3,301 2,532 215 2,733 5,832 1,204 $1,545 85 4,717 90,217 92 1,271 1,961 2,815 3,584 6,184 1,227 662 6,930 87,164 565 4,038 3,221 2,027 4,873 1,168 $450 4,500 80,000 450 900 2,700 2,700 450 1,800 4,000 800 $180 4,477 70,446 21 803 2,723 1,648 2,084 5,702 722 $800 6,750 80,000 400 900 2,700 2,500 450 2,000 4,300 900 77.78% 0.00% 50.00% 0.00% -11.11% 0.00% 0.00% -7.41% 0.00% 11.11% 7.50% 12.50% $30,948 $113,697 $110,647 $98,750 $88,807 $101,700.00 2.99% 219,447 $ $ 231,315 $ 315,865 $ 322,001 $ 314,539 $ 264,259 pg 22 -15.99% CAPITAL OUTLAY 2012 Requested Items 0 Total Budget 2012 Final EMAIL 2012 Approved - $ - *Budgeted in GF Department 1801 $ Section 3 - Page 18 - 08/02/2011 2:28 PM GENERAL FUND PUBLIC WORKS STREET MAINTENANCE 001-4021-433 2011 YTD 04/30/10 Description 2008 Actual 2009 Actual 2010 Actual Personnel Expense 1001 1005 2001 2002 2004 2005 2006 Salaries Sal-OT OASI State Retire Health Ins Income Protect State Comp $ 148,261 5,325 11,317 15,031 22,971 528 5,747 $ 145,787 4,179 10,822 14,170 21,902 527 6,412 $ - Personnel Expense $ 209,180 $ 203,797 $ - Telephone Utilities Auto/Equip Building Maintenance DOC Labor Travel/training Office supplies Operating supplies Small tools Safety Books/Dues/Subscript Gas/oil/lube Diesel/Oil/Lube Uniforms Construction Materials Signage Graffiti Abatement Supplies DOC Supplies 2,385 5,242 17,889 1,622 11,860 26 209 1,125 680 14,286 7,750 831 14,551 8,167 4,760 - Operating Expense $ 91,383 $ 93,356 $ - $ - $ - Total Expenses $ 300,563 $ 297,153 $ - $ - $ - Operating Expense 3001 4104 4105 4301 4302 5501 5801 6001 6002 6301 6302 6401 6501 6502 6601 6701 6702 6703 Budget 2012 Final EMAIL 4,475 586 59 20,719 374 1,030 528 10,028 6,818 1,008 28,205 5,284 3,573 10,669 2011 Budget 2012 Requested Account $ - Section 3 - Page 22 - $ - $ - - 2012 % Change pg 21 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! $ - #DIV/0! - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! $ - #DIV/0! $ - #DIV/0! - 08/02/2011 2:28 PM GENERAL FUND PUBLIC WORKS STREET MAINTENANCE 001-4021-433 CAPITAL OUTLAY Items Total Budget 2012 Final EMAIL 2012 Requested $ 2012 Approved* - $ Section 3 - Page 22 *Budgeted in GF Department 1801 - 08/02/2011 2:28 PM GENERAL FUND FIRE 001-55001-422 Account Description 2008 Actual Personnel Expense 1001 1003 1005 2001 2002 2003 2004 2005 2006 Salaries Temporary Sal-OT OASI State Retirement State Retire/PS Health Ins Income Protect Workman's Comp $ 112,250 11,039 3,151 137,988 68,856 2,281 23,475 86,850 11,403 3,267 211,323 72,595 2,315 20,251 Personnel Expense $ 1,024,581 $ 1,063,460 6,846 7,408 2,089 8,288 18,913 11,819 5,357 349 5,597 1,247 3,757 8,631 91 1,730 734 4,747 6,686 757 19,591 9,833 471 - 12,610 4,226 941 18,686 1,148 5,440 15,760 1,093 5,574 2,859 357 897 1,357 2,945 4,128 648 12,385 12,723 700 151 Operating Expense 3001 3401 3402 4104 4105 4301 4302 5301 5801 5802 6001 6002 6201 6301 6302 6303 6304 6401 6501 6601 Contract. Serv. Community Training Public Education Telephone 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 665,541 Operating expense $ 124,941 Total Expense $ 1,149,522 2009 Actual $ $ 2010 Actual 655,456 104,628 $ 1,168,088 $ 2011 Budget 2012 Requested 2012 % Change 555,892 27,204 55,154 10,961 2,709 181,125 53,602 2,195 22,289 $ $ 608,189 4,500 50,000 12,083 3,399 207,569 78,113 2,466 26,686 $ $ 378,740 48,328 35,485 8,661 2,558 137,030 48,297 1,774 16,233 $ $ 615,015 7,000 50,000 12,373 3,494 221,812 83,990 2,426 28,599 1.12% 55.56% 0.00% 2.40% 2.81% 6.86% 7.52% -1.61% 7.17% 911,133 $ 993,005 $ 677,106 $ 1,024,711 3.19% 12,617 2,151 1,407 14,964 5,000 2,500 15,000 4,500 500 2,300 250 1,500 2,000 300 300 500 1,000 500 1,000 11,000 12,708 100 500 3.49% 0.00% 66.67% 0.00% 0.00% 0.00% 0.00% 0.00% -41.03% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -66.67% 0.00% 0.00% 0.00% 34.90% 0.00% 0.00% 76,422 1.58% $ 1,101,133 3.08% 15,725 2,449 1,767 14,460 5,000 1,500 15,000 4,500 500 3,900 250 1,500 2,000 300 300 500 3,000 500 1,000 11,000 9,420 100 500 19,921 10,098 9,242 567 4,069 3,085 606 973 311 2,210 718 13,110 10,549 1,420 $ 2011 YTD 03/31/11 96,820 $ 1,007,952 $ 15,325 7,017 656 4,810 645 2,261 2,615 316 1,817 238 1,991 115 653 10,636 5,300 181 75,230 $ 70,752 $ 1,068,235 $ 747,858 $ pg 23 Section 3 - Page 19 Budget 2012 Final EMAIL 08/02/2011 2:28 PM GENERAL FUND EMS 001-55052-422 Account Description 2008 Actual Personnel Expense 1001 1003 1005 2001 2002 2003 2004 2005 2006 Salaries Sal-temp Sal-OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp $ Personnel Expense $ Operating Expense 3001 4101 4301 4302 5301 5801 5802 6001 6002 6201 6301 6302 6401 6501 6601 Contract. Services Telephone 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 2009 Actual 2010 Actual 2011 Budget 551,982 1,020 118,935 10,844 3,847 158,482 56,695 2,037 20,414 $ 592,922 115,942 11,844 3,388 204,373 59,633 2,131 18,773 647,996 82,067 8,183 187,885 64,595 2,074 26,672 $ 924,256 $ 1,009,007 $ 1,019,471 $ 10,231 670 11,147 782 11,190 325 2,321 25,854 2,828 43 1,703 150 15,557 1,914 21,454 1,437 46 11 1,786 1,807 30,898 2,589 409 13,077 364 39,763 57 618 110 2,166 33,735 426 405 707 12,672 660 Operating Expense $ 84,715 Total Expenses $ 1,008,971 $ 73,878 $ 1,082,885 $ 91,318 $ 1,110,789 2011 YTD 03/31/11 636,849 50,000 9,959 189,969 73,606 2,074 29,145 $ 454,919 38,139 5,698 142,322 51,571 1,728 18,349 0.44% 0.00% 0.00% 0.41% 0.00% 6.49% 8.71% 0.00% 7.20% 991,602 $ 712,726 $ 1,015,272 2.39% 7,200 - 10,154 140 1,521 53 926 19,937 46 45 11,756 1,054 800 400 1,200 250 4,500 30,000 300 200 150 1,550 14,000 - -88.89% 0.00% 0.00% 0.00% 0.00% -50.00% 0.00% 200.00% 7.14% 0.00% 0.00% 0.00% 0.00% 27.27% 0.00% 53,350 0.76% $ 1,068,622 2.30% 52,950 $ 1,044,552 $ 45,631 $ 758,358 $ 2012 % Change 639,635 50,000 10,000 202,301 80,020 2,074 31,242 400 2,400 250 1,500 28,000 300 200 150 1,550 11,000 $ 2012 Requested $ pg 24 Section 3 - Page 20 Budget 2012 Final EMAIL 08/02/2011 2:28 PM GENERAL FUND EMS 001-55052-422 CAPITAL OUTLAY Items 3 Cardiac Monitors New Office Furniture Type 2 EMS Ambulance Ladder Truck TOTAL 2012 Requested 60,300 5,000 90,000 1,000,000 450,000 $ 1,605,300 2012 Approved* $ *Budgeted in GF Department 1801 - Section 3 - Page 20 Budget 2012 Final EMAIL 08/02/2011 2:28 PM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1002 1003 1005 1006 2001 2002 2003 2004 2005 2006 Salaries Salaries-Civilian Salaries-Temp Sal-OT Sal - Reimbursed OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp $ $ Personnel Expense $ Operating Expense 3001 4104 4105 4301 4302 4303 5501 5801 6001 6002 6201 6401 6501 6601 8108 109,851 133,006 11,208 5,111 15,680 13,260 16,352 532 3,968 Contract. Serv. Telephone 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 308,968 $ 71,154 12,025 33,383 2,661 3,928 547 2010 Actual 109,560 141,985 1,388 2,576 4,769 19,066 11,853 350 17,537 556 4,086 313,723 $ 48,437 34,715 126 5,254 6,021 2,323 7,217 6,982 1,099 1,444 2,709 785 169 5,328 4,697 7,807 963 828 5,196 1,253 2,171 2011 Budget 146,733 70,422 1,008 12,334 14,320 7,306 9,576 20,413 852 5,066 $ 288,031 $ 156,790 38,794 500 $ 11,952 3,724 13,715 19,385 587 5,759 54,494.13 251,206 $ 74,581 28,500 6,000 1,000 2,800 1,000 5,500 7,000 600 420 2,500 760 2,000 38,593.51 5,268.33 3,122.73 2,391.00 2,557.95 6,548.74 7,635.08 834.07 582.50 3,970.61 1,695.21 - 2012 Requested 109,815 26,327 1,272 9,645 8,441 3,444 10,944 14,566 496 3,686 $ 188,636 $ 61,967 32,214 5,893 1,857 1,816 1,626 6,011 9,676 891 780 2,631 625 - 107,615 37,594 - 2012 % Change 11,108 3,711 3,566 14,612 363 3,745 -31.36% -3.09% 0.00% -100.00% 0.00% -7.05% -0.37% -74.00% -24.62% -38.10% -34.96% 182,314 -27.42% 72,543 35,000 6,000 1,000 2,400 1,000 6,000 7,000 600 390 1,300 760 1,000 -2.73% 0.00% 22.81% 0.00% 0.00% 0.00% -14.29% 0.00% 9.09% 0.00% 0.00% -7.14% -48.00% 0.00% -50.00% Operating Expense $ 151,941 $ 117,283 $ 127,694 $ 132,661 $ 125,988 $ 134,993 1.76% Total Expenses $ 460,909 $ 431,007 $ 415,725 $ 383,867 $ 314,623 $ 317,307 -17.34% Section 3 - Page 21 Budget 2012 Final EMAIL 2011 YTD 03/31/11 pg 25 08/02/2011 2:28 PM GENERAL FUND POLICE ADMINISTRATION 001-56001-421 CAPITAL OUTLAY 2012 Items Requested 2 Patrol Vehicles 88,000 12 Ballistic Vest 10,800 2 AC/Heaters 16,000 12 Office Chairs for Patrol Briefing Room 4,000 2 Office Chairs for Dispatch 1,000 20 Conference Room Chairs 8,000 Total $ 114,800 2012 Approved* *Budgeted in GF Department 1801 88,000 10,800 16,000 $ 114,800 Section 3 - Page 21 Budget 2012 Final EMAIL 08/02/2011 2:28 PM GENERAL FUND POLICE OPERATIONS 001-56041-421 2011 YTD 03/31/11 2012 Requested 2012 % Change pg 26 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 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 $ 1,183,098 67,636 244,299 187,603 29,019 9,889 232,235 159,729 4,622 50,305 $ 1,207,233 50,339 185,626 167,004 24,523 5,131 327,837 155,895 4,490 50,539 1,234,902 53,393 86,345 272,763 24,771 4,874 344,201 155,767 4,732 55,919 $ 1,212,483 53,970 70,000 280,000 26,785 5,181 324,067 164,371 4,654 58,402 $ 838,094 37,290 64,633 185,222 17,787 4,001 273,411 103,312 3,809 36,913 $ 1,169,292 17,030 70,000 280,000 23,333 1,681 321,655 146,738 4,234 52,497 -3.56% -68.45% 0.00% 0.00% -12.89% -67.56% -0.74% -10.73% -9.04% -10.11% Personnel Expense $ 2,168,435 $ 2,178,619 $ 2,237,666 $ 2,199,913 $ 1,564,472 $ 2,086,459 -5.16% 23,815 32 8,933 75,016 22,710 - - - - 4,713 68,564 24,739 3,237 72,323 21,991 3,000 50,900 11,295 141 3,656 57,283 6,951 2,500 68,700 18,770 0.00% 0.00% -16.67% 34.97% 66.18% 89,970 38.00% $ 2,176,429 -3.91% Operating Expense 4301 4302 5801 6501 6601 Budget 2012 Final EMAIL Auto/equip Maintenance Cost Travel/training Gas/oil/lube Uniforms Operating Expense $ 130,506 Total Expenses $ 2,298,941 $ 98,016 $ 2,276,635 $ 97,550 $ 2,335,217 Section 3 - Page 22 $ 65,195 $ 2,265,108 $ 68,031 $ 1,632,503 $ 08/02/2011 2:28 PM GENERAL FUND POLICE SUPPORT 001-56071-421 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1002 1005 1006 2001 2002 2003 2004 2005 2006 Salaries Salaries-Civil Sal-OT Sal - Reimbursed OT OASI State Retire State Retire-PS Health Ins Income Protect Workman's Comp $ 274,890 240,182 79,693 88,009 22,054 24,918 44,225 64,778 1,701 10,176 $ 342,476 258,114 83,411 62,037 26,205 28,281 88,640 76,072 2,064 14,320 395,629 265,494 72,503 93,489 27,253 28,120 110,412 79,599 3,255 17,685 $ 850,626 $ 981,619 4,126 10,704 6,562 Operating Expense 4301 5801 6501 6601 Budget 2012 Final EMAIL Auto/equip Travel/training Gas/oil/lube Uniforms 4,084 3,873 13,741 6,678 Operating Expense $ 28,376 Total Expenses $ 879,002 $ 21,392 $ 1,003,011 2010 Actual 2011 YTD 03/31/11 2011 Budget 2012 % Change 367,583 306,917 45,000 120,000 41,432 29,464 113,914 92,651 3,110 19,841 $ 262,025 208,518 59,325 71,265 23,275 24,639 101,864 64,493 2,581 11,589 $ 466,517 335,245 45,000 120,000 45,033 33,089 152,688 117,500 3,255 23,353 26.91% 9.23% 0.00% 0.00% 8.69% 12.30% 34.04% 26.82% 4.65% 17.70% $ 1,093,440 $ 1,139,912 $ 829,573 $ 1,341,680 17.70% 2,257 14,164 6,207 2,500 10,000 3,580 3,344 8,501 1,630 2,000 13,800 9,440 0.00% -20.00% 38.00% 163.69% 25,240 56.97% $ 1,366,920 18.25% $ 22,628 $ 1,116,068 Section 3 - Page 23 $ 2012 Requested $ 16,080 $ 13,476 $ 1,155,992 $ 843,050 $ pg 27 08/02/2011 2:28 PM GENERAL FUND POLICE HUMANE 001-56091-421 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 58,073 78,802 7,081 6,225 8,115 8,475 288 1,786 82,437 2,622 6,063 7,700 8,331 599 1,650 82,983 1,000 6,425 8,062 12,896 516 1,853 Personnel Expense 1002 Salaries-Civilian 1003 Salaries-Temp 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2205 Income Protect 2006 Workman's Comp Personnel Expense 14,299 5,265 6,948 6,489 204 1,006 $ Operating Expense 3001 Contractual Services 4104 Telephone 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 92,284 $ 110,772 30,080 353 53 592 10 1,605 4,492 31,445 940 1,042 5,766 80 424 2,199 232 $ 109,402 $ 38,285 113,736 2011 YTD 01/31/11 49,971 1,689 3,772 5,217 6,110 362 905 $ 40,620 1,000 750 4,500 35 2,000 230 1,122 428 4,182 2,520 415 2012 Requested 68,025 $ 30,240 810 678 3,385 2,129 92 2012 % Change 67,061 11,000 1,000 6,048 6,718 11,896 342 1,487 -19.19% 100.00% 0.00% -5.86% -16.68% -7.75% -33.72% -19.74% 105,552 -7.20% 40,620 1,000 500 4,500 35 2,500 460 0.00% 0.00% 0.00% 0.00% 0.00% -33.33% 0.00% 0.00% 25.00% 100.00% Operating Expense $ 37,689 $ 41,624 $ 46,952 $ 49,135 $ 37,333 $ 49,615 0.98% Total Expenses $ 129,973 $ 152,396 $ 156,353 $ 162,871 $ 105,358 $ 155,167 -4.73% Budget 2012 Final EMAIL Section 3 - Page 24 08/02/2011 2:28 PM GENERAL FUND CAPITAL EXPENDITURES 001-51801-419 Account Description 7701 7702 7703 7704 7705 7706 7707 7708 7709 7710 7711 7712 7713 7714 7715 7716 7717 7718 7719 7723 Budget 2012 Final EMAIL ADMINISTRATION FINANCE MANAGEMENT INFO SYSTEMS HUMAN RESOURCES MAGISTRATE COURT CEMETERY FIRE POLICE COMMUNITY DEVELOPMENT ECONOMIC DEVELOPMENT RECREATION PARKS AQUATICS PW ADMINISTRATION PW STREET MAINTENANCE PW FLEET MAINTENANCE LIBRARY CD CONSTRUCTION VISITOR CENTER MIS - COMPUTER REPLACEMENT 2008 Actual 2009 Actual 11,069 83,807 229,030 2,325 635 58,042 440,843 4,706 13,884 49,807 18,211 6,354 26,946 11,943 2,246 8,500 - 2,590 36,466 137,542 23,942 4,002 78 15,940 5,764 2,806 59,059 578 - $ 968,348 $ 288,766 2010 Actual 2011 Budget 2011 YTD 03/31/11 34,669 45,000 1,600 6,100 148,000 6,200 58,000 30,000 - 49,711 43,199 8,082 3,871 66,566 79,124 - 329,569 $ 250,553 0 11,455.90 31,079.45 970.98 0 0 11,823.52 16,556.66 0 0 2,613.95 0 5,929.02 13,140.00 0 63,090.07 0 0 - $ 156,660 Section 3 - Page 25 $ 2012 Requested $ 2012 Requested % Change 73,900 114,800 33,500 9,000 5,000 - #DIV/0! -100.00% 64.22% 0.00% 0.00% -100.00% -100.00% -22.43% 0.00% 0.00% 0.00% 440.32% -84.48% 0.00% 0.00% 0.00% 0.00% -100.00% 0.00% 0.00% 236,200 -28.33% 08/02/2011 2:28 PM SPECIAL REVENUE FUNDS SUMMARY EXPENDITURES 2011 Budget REVENUES 2012 Budgeted Difference 2012 Budget 2012 Budgeted % Change 2011 Comparison of Revenues VARIANCE 2012 Revenues 2012 Rev vs. Exp H. U. R. F. $ 1,445,350 $ 1,380,914 $ (64,436) -4.46% $ 1,445,350 $ 1,380,914 $ LTAF $ 28,000 $ 16,589 $ (11,411) -40.75% $ - $ - $ (16,589) SPEC. PROJECTS $ 3,451,056 $ 2,830,164 $ (620,892) -17.99% $ 3,451,056 $ 2,830,164 $ (0) CALL CENTER $ 1,414,349 $ 1,383,964 $ (30,385) 100.00% $ 1,399,674 $ 1,383,965 $ 0 HOUSING $ 329,251 $ 337,946 $ 8,695 2.64% $ 319,251 $ 304,946 $ RICO $ 160,000 $ 155,000 $ (5,000) -3.13% $ 160,000 $ 155,000 $ JCEF $ 9,500 $ 18,312 $ 8,812 100.00% $ 9,500 $ 10,500 $ GRANTS $ 7,459,207 $ 5,698,293 $ (1,760,914) -23.61% $ 7,259,378 $ 5,698,293 $ GRAND TOTALS $ 14,296,712 $ 11,821,182 $ (2,475,530) -17.32% $ 14,044,209 $ 11,763,782 $ Budget 2012 Final EMAIL Section 4 - Page 1 0 (33,000) (7,812) - (57,400) 08/02/2011 2:28 PM HIGHWAY USERS REVENUE FUND 101-54041-433 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1004 1005 2001 2002 2004 2005 2006 2007 2008 Salaries Sal-Limited Sal-OT OASI State Retire Health Ins Income Protect State Comp Unemployment Ins. HR Processing $ 382,222 51,306 5,067 31,423 40,659 57,733 1,340 27,229 375 $ 334,975 46,175 3,121 28,166 34,370 44,435 1,117 30,308 317 Personnel Expense $ 597,354 $ 522,985 Operating Expense 3001 3002 4104 4105 4107 4301 4311 4312 4701 4702 4703 5201 5801 6002 6301 6302 6501 6502 6601 6701 6702 6704 Budget 2012 Final EMAIL Contractual serv Auditor Telephone Utilities St. Lts-Electric/O&M Auto/Equip Heavy Equipment Repair Asphalt Plant Repairs Bond Pay (MPC) Bond Pay (HURF) 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 4,705 2,125 4,688 2,194 67,763 180,669 10,587 43,910 12,312 16,044 39,452 25,364 1,791 4,587 71 563 37,829 45,118 4,208 307,520 78,054 179,518 3,610 33,479 11,408 47,974 163,111 39,452 24,911 100 1,072 80 531 30,216 26,109 3,125 389,359 5,148 - - 2010 Actual $ 2011 YTD 03/31/11 2011 Budget 2012 Requested 2012 % Change pg 29 407,109 36,428 2,012 31,973 40,239 68,245 3,011 27,908 5,977 1,755 $ 427,460 5,000 33,083 41,516 76,453 2,637 27,691 3,000 1,000 $ 263,308 11,415 3,180 20,629 28,198 43,207 1,896 15,301 175 $ 422,130 5,000 32,675 42,158 82,123 2,151 25,935 3,000 1,000 -1.25% 0.00% 0.00% -1.23% 1.55% 7.42% -18.41% -6.34% 0.00% 0.00% 624,655 $ 617,840 $ 387,308 $ 616,172 -0.27% 10,860 2,700 1,800 58,500 150,000 6,000 30,000 13,000 159,673 12,520 32,100 850 2,000 800 850 25,000 25,000 3,300 157,923 6,000 23,000 38.17% 0.00% 28.21% 0.00% 0.00% -14.29% 50.00% -13.33% #DIV/0! -0.33% -61.18% -9.01% -15.00% 0.00% -20.00% -5.56% 0.00% 0.00% 50.00% -25.01% 0.00% 0.00% 13,351 2,272 1,304 52,390 181,024 2,897 44,788 8,375 211,439 27,246 12,786 200 897 575 1,510 27,000 21,164 3,200 198,360 12,628 30,179 Section 4 - Page 2 7,860 2,700 1,404 58,500 150,000 7,000 20,000 15,000 160,207 32,250 35,280 1,000 2,000 1,000 900 25,000 25,000 2,200 210,601 6,000 23,000 8,619 2,700 1,083 47,531 133,273 775 28,092 6,602 3,524 11,981 7,520 19,804 130 1,762 56 283 19,780 14,859 2,222 212,899 8,433 - 08/02/2011 2:28 PM HIGHWAY USERS REVENUE FUND 101-54041-433 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 20,061 - - 19,075 - - 824,679 $ 1,044,137 872,659 32,096 39,710 42,411 40,607 $ 1,454,129 $ 1,606,831 $ 1,539,725 $ 1,445,350 2012 Requested 2012 Approved 7401 Capital Outlay 7531 St Light Trpl Res Operating Expense 9901 Gen Fund Reimb Total Expenses $ $ 786,902 2011 YTD 03/31/11 2012 Requested - $ $ 2012 % Change pg 29 2,400 - 100.00% 0.00% 724,276 -7.96% 37,132 40,465 -0.35% 956,367 $ 1,380,914 -4.46% 531,927 $ CAPITAL OUTLAY Items 2 backhoe Street Sweeper 1 printer & 1 computer Suburban Total Budget 2012 Final EMAIL $ 180,000 229,000 2,400 50,000 461,400 $ 2,400 2,400 Section 4 - Page 2 08/02/2011 2:28 PM LOCAL TRANSPORATION ASSISTANCE FUND (LTAF) 102-54042-433 Account Description Operating Expense 5231 5235 6701 9906 Cultural Purposes LTAF II Grant Construction material Transfer to Airport Total Expense Budget 2012 Final EMAIL 2008 Actual 2009 Actual 2010 Actual 2011 Budget 7,000 30,000 12,000 5,000 30,971 45,919 12,000 4,500 18,268 73,141 12,000 28,000 - $ 49,000 $ 93,889 $ 107,909 Section 4 - Page 3 $ 28,000 2011 YTD 03/31/11 2012 Requested 9,750 $ 9,750 $ 2012 % Change 16,589 - 0.00% -40.75% 0.00% 0.00% 16,589 -40.75% pg 31 08/02/2011 2:28 PM CULTURAL FUNDS Other LTAF Funding Requests (non-cultural) Catholic Community Services DARC Transportation-Reserve-a-ride Meals on Wheels $ 15,000 $ 13,000 $ 28,000 - $ - 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 4 - Page 3A SPECIAL PROJECTS FUND 103-51081-419 Account Description 7101 7601 7602 7604 7610 7621 7626 7628 7629 7630 9901 9906 9909 Land Repurchase Misc. Council Projects Bus. Dist. Impr. Traffic Control Border Project 3rd Street Extension Demolition Program Government Plaza City Hall Improvements Rivera Building Proj DUSD Infra Improvement Transfer to General Fund Transfer to Airport Transfer to Sanitation Transfer to Golf Course 9912 Transfer to Aquatic Center Total Expenses Budget 2012 Final EMAIL 2008 Actual 2009 Actual 157 32,006 46,470 9,750 2,334 3,333 4,395 20,000 57,499 6,217 6,312 933,803 3,074 42,505 49,651 337,330 2,016 13,917 160,853 198,486 64,275 133,520 - 550,000 25,000 1,535,885 64,115 - 109,593 - 506,517 15,268 108,000 181,908 10,613 10,000 - $ 1,938,231 $ 636,106 2010 Actual $ 2011 Budget 578,778 Section 4 - Page 4 2011 YTD 03/31/11 4,854 6,119 116,417 32,467 504 325,731 26,730 115,579 70,061 - $ 2,547,732 2012 Requested 20,000 55,624 605,922 1,934,172 -24.08% 62,686 38,143 - $ 82,719 - 0.00% 0.00% -3.26% 0.00% 0.00% 0.00% -28.38% -100.00% 0.00% -45.76% -45.56% 0.00% 0.00% -24.52% 0.00% 550,000 25,000 1,100,000 - 23,039 70,061 - $ 2012 % Change pg 33 08/02/2011 2:28 PM DEBT SERVICE FUND 103-51547-419 Account 4701 4705 4706 4709 4710 Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget MPC Bond Payment Lease/Purchase St Lights PW Facility (Phase I) IT Upgrades Lease GADA Loan Cardiac Monitors Equipment $ $ $ Total Expenses $ 4711 Call Center Equipment 4712 Call Center Building Total Expenses 32,575 26,877 - $ 59,452 $0 268,653 26,877 26,946 197,871 102,572 270,167 26,877 26,946 264,283 198,298 $ 622,920 40,040 144,503 $184,543 $ 786,571 573,579 511,680 $1,085,259 325,268 26,877 26,946 264,283 234,950 2011 YTD 03/31/11 $ 25,000 $ 903,324 554,666 525,356 $1,080,022 2012 Requested 20,333 20,157 13,473 198,553 130,150 $ 324,184 26,877 13,473 264,283 236,175 21,000 10,000 -0.33% 0.00% -50.00% 0.00% 0.52% 100.00% -60.00% $ 895,992 -0.81% 533,824 550,378 $1,084,202 -3.76% 4.76% 0.39% $ 382,667 72,987 364,145 $437,132 2012 % Change pg 33 $1,980,194 Budget 2012 Final EMAIL Section 4 - Page 4A 08/02/2011 2:28 PM CALL CENTER 103-57081-419 Account Description Personnel Expense 1003 1004 1005 2001 2002 2005 2006 Salaries Temp Salaries - Limited Salaries O/T OASI State Retire Income Protect State Comp Personnel Expense Operating Expense 3001 4104 4105 4301 4302 5201 5501 6002 6201 6301 6501 6701 7101 7828 7829 7830 7831 8512 8901 2008 Actual 2009 Actual 2010 Actual 2011 Budget - 17,408 - - 800 1,392 366 153 - - $ Contract Serv Telephone Utilities Auto & Equipment Maint Building Maintenance Liability Insurance DOC Labor Operating Supplies Postage Small tools and Equipment Gas/Oil/Lube Construction Materials Land Building Design/Engineer Building Construction IT Design/Engineer IT Equipment Grant Match Depreciation - 20,120 - 118,483 317 10,202 3,046 46,700 4,914 1,227 5,202 104 1,537 4,866 89,762 750,656 367,933 3,781,065 514,462 2,975,286 - - $ - $ $ 9,638 100.00% -36.83% 0.00% 0.00% 0.00% 135.29% 156.36% 0.00% 100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% -10.34% - $ 8,675,762 $ 239,867 $ 334,327 $ 110,396 Total Expenses $ - $ 8,695,882 $ 239,867 $ 334,327 $ 110,396 $ 299,762 Section 4 - Page 5 8,516 35,200 20,277 1,058 3,592 41,752 $ 0.00% 100.00% 0.00% 100.00% 100.00% 100.00% 100.00% $ - 198,234 8,500 11,000 - - - 116,593 - - 2012 % Change 7,947 608 784 40 259 Operating Expense - 104,390 461 23,099 23,441 142 56,398 31,936 - - 2012 Requested 125,231 20,000 28,200 100 116,593 $ 290,124 Budget 2012 Final EMAIL - $ 2011 YTD 03/31/11 pg 37 -13.22% 08/02/2011 2:28 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 2008 Actual 2009 Actual $ 303,646 12,000 - $ 315,646 $ $ 2,794 3,424 1,014 13,797 2,356 708 18,005 14,174 14,499 20,834 - 91,604 2011 YTD 03/31/11 2010 Actual 2011 Budget 3,177 5,967 296 289 8,804 4,853 5,407 14,500 - $ 43,293 $ $ 3,000 1,000 1,000 10,000 $ 80,000 5,000 20,000 20,000 20,000 - 160,000 $ 2012 Requested 396 0 0 11,121 $ 381 3,500 10,299 4,378 845 13,500 *** 44,420 $ 3,000 1,000 1,000 10,000 80,000 20,000 20,000 20,000 - 155,000 2012 % Change pg 90 0.00% 0.00% 0.00% 0.00% 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% ***Budgeted expenses will only be expended if the money is available Section 4 - Page 6 08/02/20112:28 PM JCEF 105-51603-412 Account Description 1015 3003 8007 8010 9901 Project Related Salaries County Trainer Cost SHR JCEF Court Approved Exp MCEF court approved ex Transfer to General Fund Total Expenses 2008 Actual 2009 Actual $ 1,337 2,107 $ - $ 3,444 1,511 3,295 $ - $ 2011 YTD 03/31/11 2010 Actual 2011 Budget 4,806 $ 582 1,688 5,538 6 - $ 7,815 $ Section 4 - Page 7 2,000 5,000 2,500 2012 % Change pg 90 $ 716 5,135 190 - $ 2,000 13,812 2,500 - 0.00% 0.00% 176.24% 0.00% 0.00% 0.00% $ 6,041 $ 18,312 92.76% - 9,500 2012 Requested 08/02/20112:28 PM HOUSING 501-51101-463 PERSONNEL EXPENSE Account Description 1001 1003 1004 1005 2001 2002 2004 2005 2006 Salaries Salaries - Temp Salaries - Ltd Salaries-Overtime O.A.S.I. Retirement-State Health Ins Income Protect Ins Workman's Comp 2008 Actual 2009 Actual $ 176,638 $ $ 896 12,982 17,043 15,550 606 2,690 7402 Capital Outlay Total Expenses 194,567 180 153 14,154 17,746 21,116 640 3,105 124,865 17,400 33,783 62 12,964 12,958 14,852 979 2,845 ($0) $ 226,405 $ 251,661 2011 YTD 03/31/11 2010 Actual 2011 Budget $ $ $15,937 $ 236,645 192,292 13,111 34,699 18,368 21,791 32,692 1,310 4,987 $ $ $10,000 $ 329,251 84,310 20,639 48,362 556 11,633 13,333 9,552 854 2,832 2012 Requested $ $ $10,000 $ 202,071 $ 2012 % Change 118,453 24,031 91,031 17,864 20,676 27,502 1,117 4,272 -38.40% 83.30% 162.34% 0.00% -2.74% -5.12% -15.88% -14.73% -14.35% $33,000 100.00% 337,946 2.64% pg 90 CAPITAL OUTLAY 2012 Requested 1 vehicle 1 copier 1 printer for checks Total $ 20,000 10,500 2,500 33,000 2012 Approved $ Funded from Special Projects 20,000 10,500 2,500 33,000 Section 4 - Page 8 08/02/20112:28 PM ENTERPRISE FUNDS SUMMARY EXPENSES 2011 Budget REVENUES 2012 Budgeted Difference 2012 Budget 2012 Budgeted % Change 2011 Comparison of Revenues SANITATION $ 1,142,000 $ 1,380,100 $ 238,100 20.85% $ WATER WATER OFFICE WATER FIELD $ $ 229,086 1,204,330 $ $ 276,592 1,105,593 $ $ 47,505 (98,737) 20.74% -8.20% WATER CAPITAL REINVESTMENT WATER TOTAL $ $ 2,127,584 3,561,000 $ $ 2,001,472 3,383,656 $ $ (126,112) (177,344) WASTE WATER TOTAL SEWER CAPITAL REINVESTMENT $ $ 1,264,155 4,756,804 $ $ 1,533,727 981,272 $ $ 269,572 (3,775,531) 21.32% -79.37% $ 6,020,959 $ 2,515,000 $ (3,505,959) AIRPORT $ 111,680 $ 247,300 $ GOLF GOLF COURSE BAR & RESTAURANT $ $ 512,932 29,797 $ $ 441,601 233,523 $ $ 542,729 $ 675,124 $ 11,378,367 $ 8,201,180 GRAND TOTALS $ VARIANCE 2012 Revenues 2012 Rev vs. Exp 1,142,000 $ 1,230,100 $ (150,000) 3,561,000 $ 3,383,656 $ (0) -58.23% $ 6,082,804 $ 2,515,000 $ 0 135,620 121.44% $ 111,680 $ 206,300 $ 132,395 25.81% $ 477,776 $ 675,124 $ -27.92% $ 11,375,260 $ 8,010,180 $ (3,177,187) -5.93% -4.98% $ (41,000) - (191,000) 08/02/2011 2:28 PM Budget 2012 Final EMAIL Section 5 - Page 1 WATER OFFICE 410-54051-432 Account Description Personnel Expense 1001 Salaries 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp Personnel Expense 2008 Actual 2009 Actual $ 68,941 3,377 5,364 6,930 6,370 240 159 $ 71,716 952 5,386 6,866 6,371 253 160 $ 91,381 $ 91,704 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 11,207 3,974 4,597 6,328 75 20,434 3,876 8,506 20,610 Operating Expense $ 7401 Capital Outlay 8001 Bad Debt Expense 9901 Gen. Fund Reimb. 79,607 2010 Actual $ 10,497 3,949 383 6,299 19,976 5,348 20,596 $ 684 34,061 67,047 2011 Budget 42,141 2012 Requested 2012 % Change pg 83 79,184 25 5,815 7,195 5,909 546 148 $ 48,312 500 3,734 4,686 7,528 300 95 $ 33,163 2,496 3,351 4,558 226 59 $ 47,753 500 3,691 4,763 8,257 243 87 -1.16% 0.00% -1.14% 1.64% 9.69% -19.04% -8.28% 98,821 $ 65,155 $ 43,854 $ 65,295 0.21% 43,309 4,000 2,000 6,600 500 64,200 2,150 17,701 35,561 6.65% -11.11% 0.00% 0.00% 0.00% 125.88% 7.50% 0.00% 5.76% 176,021 29.47% 2,400 5,000 27,876 100.00% 100.00% -0.35% 6,753 4,089 53 7,439 21,255 2,035 12,098 30,557 $ 2011 YTD 03/31/11 84,279 40,609 4,500 2,000 6,600 500 28,422 2,000 17,701 33,625 $ 45,008 135,957 29,811 4,500 52 5,675 38,604 9,642 30,569 $ 27,974 118,853 $ 36,476 25,580 Other $ 34,745 $ 42,141 $ 45,008 $ 27,974 $ 62,056 $ 35,276 26.10% Total Expenses $ 205,733 $ 200,892 $ 228,108 $ 229,086 $ 224,763 $ 276,592 20.74% CAPITAL OUTLAY 2012 Requested 1 computer & 1 printer 2,400 0 0 Total Budget 2012 Final EMAIL 2012 Approved $ 2,400 2,400 0 $ 2,400 Section 5 - Page 2 08/02/2011 2:28 PM WATER FIELD 410-54053-432 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2008 Salaries Salaries-Temporary Salaries-Limited Sal-OT OASI State Retire Health Ins Income Protect State Comp Unemployment Ins. HR Processing $ 325,260 630 38,308 27,232 28,033 37,534 40,163 1,113 14,826 218 $ 351,076 25,684 14,004 28,697 35,139 37,303 1,030 13,420 58 Personnel Expense $ 513,317 $ 506,412 Operating Expense 3001 4104 4105 4301 4302 4303 4321 4322 4323 4703 5202 5301 5401 5801 6001 6002 6301 6302 6401 6501 6502 6601 6701 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 Communications 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 Budget 2012 Final EMAIL $ 2010 Actual $ $ 119,664 30,842 9,306 12,355 16,109 20,037 946 4,473 28 $ 280,533 1,257 7,947 10,000 22,930 29,460 58,429 1,463 7,727 3,000 1,000 12.47% 100.00% 100.00% 0.00% 15.54% 18.29% 10.68% -6.76% -6.29% 0.00% 0.00% 314,617 $ 370,779 $ 213,760 $ 423,745 14.28% 14,800 5,400 243,000 11,000 1,500 23,760 57,600 30,600 40,040 153,640 2,000 2,000 1,800 1,170 1,350 585 900 1,530 25,000 4,200 1,200 - 5,105 2,215 237,097 6,002 145 5 25,540 37,925 18,390 7,520 11,256 - 14,800 5,400 290,000 11,000 1,500 23,760 57,600 30,600 12,520 139,098 2,000 1,500 1,800 1,170 1,200 500 900 1,300 25,000 4,200 2,100 - 0.00% 0.00% 19.34% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -68.73% -9.46% 0.00% 0.00% -25.00% 0.00% 0.00% -11.11% -14.53% 0.00% -15.03% 0.00% 0.00% 75.00% 0.00% 623,075 $ 370,375 627,948 0.78% 135 - 1,704 1,788 2,730 447 807 1,687 27,021 10,246 2,913 - 961 1,982 743 580 542 78 23,290 5,684 2,862 - 22,013 980 1,590 241 582 106 78 14,049 11,037 1,784 $ Section 5 - Page 3 2012 % Change 249,422 10,000 19,846 24,905 52,790 1,570 8,246 3,000 1,000 4,464 2,720 310,993 7,472 914 10,920 54,818 47,929 15,040 530,118 2012 Requested $ 6,169 3,141 312,792 9,393 350 23,381 54,002 49,914 34,254 $ 2011 YTD 03/31/11 174,574 50,885 6,122 16,901 20,043 36,065 1,364 7,982 681 17,754 11,743 291,730 12,745 930 14,331 68,638 36,569 57,929 561,847 2011 Budget 507,729 $ 597 1,868 141 369 375 12,955 1,546 1,325 $ pg 84 08/02/2011 2:28 PM WATER FIELD 410-54053-432 Account Description 7401 7525 7826 8901 9907 9908 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 YTD 03/31/11 4,133 9,375 24,282 - 109,007 - 9,138 - 29,500 20,000 160,976 - 12,876 - Capital Outlay Capital Impr. Program CIP Impact Fees Depreciation Transfer to Water CIP Transfer to Sewer Total Capital Outlay $ 122,515 Total Expenses $ 1,197,679 $ 24,282 $ 9,138 $ 1,060,812 $ 831,484 $ 210,476 $ 1,204,330 $ 12,876 $ 597,010 2012 Requested 2012 % Change 33,900 20,000 - 14.92% 0.00% 0.00% -100.00% 0.00% 0.00% 53,900 -74.39% $ 1,105,593 -8.20% $ pg 84 CAPITAL OUTLAY Items Chlorinator Equipment Hydrant Replacement Program Valve Replacement Program Meter Replacement Program 3 computers & 2 printers 2 Shortbed trucks Total Budget 2012 Final EMAIL 2012 Requested $ 3,000 10,000 10,000 6,500 4,400 40,000 73,900 2012 Approved $ Section 5 - Page 3 3,000 10,000 10,000 6,500 4,400 33,900 08/02/2011 2:28 PM Water Capital Reinvestment 410-54055-432 Account Description Personnel Expense 1001 Salaries- Regular 1003 Salaries- Temp 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Insurance 2005 Income Protection 2006 State Comp Personnel Expense 2008 Actual $ $ Operating Expense 3001 Contractual Services 4301 Auto/Equip 4713 WIFA Loan 5301 Communications 5801 Travel & Training 6001 Office supplies 6002 Operating Expenses 6301 Small tools 6302 Safety Equipment 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 9901 Gen. Fund Reimb 8003 Contingency Operating Expense 7401 7802 7808 7809 7810 7811 7813 7814 7815 7816 4,105 29,139 3,406 2,756 3,413 1,473 41 1,331 45,664 $ $ 2011 YTD 03/31/11 2011 Budget (643) $ 63 $ - 2,204 2,006 18,996 - 23,502 - $ 103,326 9,047 1,800 8,734 10,376 15,055 574 2,904 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ - $ 151,816 0.00% $ 27,241 572,466 1,182 - 23,202 - 450 1,800 450 900 7,000 4,500 5,400 5,500 1,800 31,473 - 100.00% 100.00% 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 0.00% 88,481 $94,656 199.70% 65,145 45 89 25,100 $ 25,100 16,620 - Section 5 - Page 4 31,584 $ 31,584 41,000 230,000 50,000 2012 % Change - 1,341 392 2012 Requested $ 0 63 (18) 356 22,451 2010 Actual (472) (62) (41) (50) 895 Water CIP Capital Outlay SCADA Control System 25,435 Pressure Reducing Station 3rd. St. Water Line Extension Misc. Projects-Master Plan 30,310 Rehabilitation Reservoir Water Lines - Geronimo Trail 4,940 Irvine St. 12 Water Line Upgrade Pirtleville 109,887 N Douglas 12", SR 80 to Pirtle 58,340 Franklin St, 8" Inrvine-Ash Ave 21,740 Budget 2012 Final EMAIL 2009 Actual $ 26,295 - 27,883 7,500 230,000 50,000 pg 85 pg 85 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 08/02/2011 2:28 PM Water Capital Reinvestment 410-54055-432 Account Description 7818 7820 7821 7822 7824 7825 7827 7828 7829 7830 2008 Actual 2010 Actual 2011 Budget 54,498 478,392 34,768 27,518 19,593 9,404 - 13,031 399,318 33 442 978 25,000 50,000 200,000 500,000 66,257 1,000,000 - 229 216,558 317,352 28,855 344,733 1,197,821 496,679 2,096,000 412,848 $ 1,224,419 521,843 $ 2,127,584 Fairview Water (BECC) 87,871 Well 16 Equiping (Arsenic Compliance) 6,210 Rehab Existing Wells Arsenic Compliance 300K Gallon Elevated Tanks-Rehab 16" Geronimo Trail Tansmission Main Replacement W & WW System Improvements, Phase II A Avenue Main Replacement Well 17 (Arsenic Compliance) Sunnyside Improve Capital Projects Total Expenses Budget 2012 Final EMAIL $ 2011 YTD 03/31/11 2009 Actual $ Section 5 - Page 4 64,176 $ 2012 Requested 25,000 50,000 2012 % Change 600,000 - 0.00% 0.00% 0.00% 0.00% 0.00% 20.00% 0.00% 0.00% -40.00% 100.00% 653,464 1,755,000 -16.27% 741,946 $ 2,001,472 -5.93% 200,000 600,000 pg 85 pg 85 08/02/2011 2:28 PM WASTEWATER 420-54061-432 Account Description Personnel Expense 1001 Salaries 1003 Sal-Temp 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Ins 2005 Income Protect 2006 State Comp 2007 Unemployment Ins. 2008 HR Processing 2008 Actual 2009 Actual $ 322,008 2,518 19,945 24,903 32,887 42,255 1,122 9,411 114 $ 338,603 12,165 25,417 33,145 42,674 1,178 10,062 141 $ 455,163 $ 463,385 2010 Actual $ 2011 YTD 03/31/11 2011 Budget 2012 Requested 2012 % Change 360,573 4,206 26,363 32,986 36,294 2,499 10,138 849 $ 336,796 8,000 26,377 33,100 45,422 2,067 9,604 1,000 1,000 $ 230,198 4,019 17,613 23,286 27,801 1,560 5,617 3,730 53 $ 292,204 5,026 8,000 23,958 30,414 44,468 1,518 7,692 1,000 1,000 -13.24% 100.00% 0.00% -9.17% -8.11% -2.10% -26.57% -19.91% 0.00% 0.00% 473,908 $ 463,367 $ 313,877 $ 415,281 -10.38% 45,000 2,800 2,000 90,000 5,400 17,005 54,254 350,000 51,300 2,500 450 40,000 1,800 800 8,000 90,000 800 1,000 450 9,000 3,000 2,100 2,500 -4.28% 21.74% 100.00% 9.76% 0.00% 0.00% -21.94% 174.51% 46.57% 0.00% 0.00% 100.00% 0.00% 0.00% -11.11% 5.88% -11.11% 0.00% 0.00% 0.00% 11.11% 50.00% -7.41% 780,159 54.66% 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 Contractual serv Auditing Services Telephone Utilities Auto/Equip Building Maintenance Lease/Purchase Bldg/Equip Debt Service Insurance-Liability Insurance-Claims Communications Transfer Expense Travel/training Office supplies Operating supplies Chemicals Small tools Safety Equipment Books/Dues/Subscrip Gas/oil/lube Diesel/oil/lube Uniforms Construction Materials Operating Expense Budget 2012 Final EMAIL 14,649 2,240 2,251 87,973 9,211 2,639 26,112 24,844 2,194 1,250 72,820 6,891 818 2,507 18,441 2,272 1,462 74,319 3,111 142 2,507 26,601 416 26,086 - 3,837 1,700 9,454 3,182 1,414 295 549 15,861 1,350 666 5,634 1,690 524 418 8,094 3,323 2,165 1,117 2,083 719 $ 211,186 $ 162,391 $ 29,808 - 47,012 2,300 1,000 82,000 5,400 17,005 69,507 127,500 35,000 2,500 450 28,421 2,300 1,420 51,319 4,151 309 1,253 31,985 33,867 0 0 753 349 3,724 1,427 197 152 7,872 1,604 1,954 370 1,800 800 9,000 85,000 900 1,000 450 9,000 2,700 1,400 2,700 240 120 5,306 8,068 480 148 375 6,919 2,395 1,382 73 150,463 $ Section 5 - Page 5 504,424 $ 180,531 $ 08/02/2011 2:28 PM WASTEWATER 420-54061-432 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 20,061 - - 24,236 44,297 29,985 29,985 32,025 32,025 20,000 252,000 24,364 296,364 656,396 $ 1,264,155 7401 Capital Outlay Impact Fee 8001 Bad Debt Expense Depreciation 9901 Gen. Fund Reimb. Total Capital Outlay Total Expenses $ 710,646 $ 655,761 $ 2011 YTD 03/31/11 14,663 $ 2012 Requested 2012 % Change 27,958 42,621 2,400 20,000 5,000 286,608 24,279 338,287 100.00% 0.00% 100.00% 13.73% -0.35% 14.15% 537,029 $ 1,533,727 21.32% pg 87 CAPITAL OUTLAY Items Sewer Cleaning Vac-Con Truck 2 computers Truck Total Budget 2012 Final EMAIL 2012 Requested 250,000 2,400 20,000 $ 272,400 2012 Approved $ Section 5 - Page 5 2,400 2,400 08/02/2011 2:28 PM Sewer Capital Reinvestment 420-54065-432 pg 88 Account Description Personnel Expense 1001 Salaries - Regular 1003 Salaries- Temp 1004 Salaries- Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2004 Health Insurance 2005 Income Protection 2006 State Comp Personnel Expense Operating Expense 3001 Contractual Services 4301 Auto/Equip 5301 Communications 5801 Travel & Training 6001 Office supplies 6002 Operating Supplies 6301 Small tools 6302 Safety Equipment 6501 Gas/oil/lube 6502 Diesel/Oil/Lube 6601 Uniforms 9901 Gen. Fund Reimb Operating Expense Budget 2012 Final EMAIL 2008 Actual 2009 Actual $ $ 54,335 150,079 15,106 16,258 20,679 16,425 453 7,021 $ 280,356 2010 Actual 80,788 225,875 6,721 23,216 29,620 20,890 747 9,868 $ 397,725 $ 2011 Budget 257,075 54,401 4,207 23,538 46,653 20,147 2,383 10,214 $ 418,619 $ 205,162 30,682 3,000 18,272 22,929 26,434 1,300 7,470 315,249 7,834 68 1,209 494 1,586 6,035 1,418 6,490 6,650 3,163 - 15,836 807 1,433 693 779 8,000 2,987 5,047 917 2,376 - 12,129 320 284 665 6,110 1,639 5,185 4,806 2,004 - $46,471 8,000 450 2,000 450 900 7,000 4,500 5,400 3,600 1,200 31,584 34,947 38,874 33,143 $111,555 Section 5 - Page 6 2011 YTD 03/31/11 $ $ $ 2012 Requested 136,407 $ 25,681 3,248 12,646 15,475 12,686 373 4,359 210,875 $22,896 4,033 504 168 159 3,371 3,288 5,281 1,173 28,881 $69,754 $ 68,884 2012 % Change 6,032 1,200 5,823 6,917 10,037 383 1,936 -66.42% 0.00% -80.34% -60.00% -68.13% -69.83% -62.03% -70.58% -74.09% 101,211 -67.89% 18,588 31,473 $50,061 pg 88 -60.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -100.00% -0.35% -55.12% WIFA 08/02/2011 2:28 PM Sewer Capital Reinvestment 420-54065-432 7401 7850 7851 7852 7854 7860 7862 7864 7865 7868 7869 7871 7872 7873 Sewer CIP Capital Outlay 21,496 WWMP Phase I(City) 3,075 WWMP Phase I(Contract) Bonita Interceptor-3rd to 19th Midtown Sewer Upgrades 107,535 Phase I, WWTP Improvements 192,769 Root Intrusion-City Repairs Sulphur Springs Sewer 7,775 DOC-Lift Station Improvements 14th & 15th Street from A Ave to Dolores Ave9,945 CIP Impact Fees-Study 3,125 W & WW System Improvements, phase II Phase II, WWTP Improvements Southwest Interceptor (City) Southwest Interceptor (Contract) $345,720 Total Expenses $ 661,023 50 583 156,120 2,226,281 - 50,000 - 15,000 30,000 $0 $0 $424,250 $105,243 $0 $1,676,062 $0 $0 $0 - 545,349 451,731 150,000 73,225 3,408 - 3,000,000 500,000 550,000 45,000 1,415 89,213 - 2,310,171 - 35,000 $2,383,034 $3,383,883 $4,330,000 $2,341,184 $ 2,819,633 $ 3,835,645 $ 4,756,804 $ 2,621,813 2012 Requested 2012 Approved - 35,000 15,000 30,000 750,000 $830,000 $ 981,272 -100.00% 0.00% 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -75.00% -100.00% -100.00% WIFA WIFA -80.83% -79.37% CAPITAL OUTLAY Items Heavy Fleet Vehicle Replacement Program 1 Backhoe Total Budget 2012 Final EMAIL 50,000 90,000 $ 140,000 $ - Section 5 - Page 6 08/02/2011 2:28 PM SANITATION 430-54071-432 Account Description 2008 Actual 2009 Actual Personnel Expense 1001 1003 1004 1005 2001 2002 2004 2005 2006 2007 2008 Salaries Sal-Temp Sal-Limited Sal-OT OASI State Retire Health Ins Income Protect State Comp Unemployment Ins. HR Processing $ $ Personnel Expense $ Operating Expense 3001 3002 4104 4105 4301 4302 4311 4703 5201 5501 5502 5503 5801 6001 6002 6201 6301 6302 6501 6502 6601 6705 3,661 21,426 27,409 46,122 961 18,532 441 Contractual Services Auditing services Telephone Utilities Auto/Equip Maintenance cost Heavy Equipment Repair Lease/Purchase PW Bldg Insurance-Liability DOC Labor-Clean up Transfer Expense Recycling Program Travel/training Office supplies Operating supplies Postage Small tools Safety Equipment Gas/oil/lube Diesel/Oil/Lube Uniforms DOC Supplies Operating Expense $ 7402 Capital Outlay 8001 Bad Debt Expense 8901 Depreciation (Expense Savings) Budget 2012 Final EMAIL 279,331 15,433 413,316 2010 Actual 250,753 2,221 18,455 22,426 34,331 800 11,598 449 $ 341,033 $ 2011 YTD 03/31/11 2011 Budget 190,120 28,680 52 15,787 19,810 24,501 1,403 8,603 4,560 663 $ 294,179 $ 225,652 6,000 $ 1,000 17,798 21,759 41,009 1,400 12,573 2,000 500 329,690 $ 123,349 4,939 27,326 11,462 15,269 20,510 932 7,671 1,680 1,138 $ 214,274 $ 1,012 1,167 1,316 432 1,363 440 10,224 1,500 - 5,037 1,500 361 5,894 780 19,846 35,959 12,347 17,913 266,025 2,717 126 3,101 65 1,215 7,290 32,968 2,294 1,244 14,590 622 2,464 35,959 11,985 3,907 268,286 66 84 3,971 12 598 4,113 26,132 2,037 42 10,234 101 8,268 35,959 3,277 300,944 285 1,314 2,859 26,443 1,563 - 2,000 1,000 12,000 46,610 15,300 264,000 400 400 1,000 450 900 3,000 30,000 1,200 - 14,038 28 17,980 3,421 196,676 40 38 978 1,523 23,781 1,255 - 411,963 - $ 376,618 $ - Section 5 - Page 7 393,052 - $ 389,984 121,000 76,961 $ 2012 Requested 266,656 5,018 14,304 $ 230,890 6,000 2012 % Change 1,000 18,199 22,887 48,846 1,173 12,465 2,000 1,200 2.32% 0.00% 0.00% 0.00% 2.25% 5.19% 19.11% -16.22% -0.86% 0.00% 140.00% 344,659 4.54% 10,224 3,000 500 5,000 2,000 19,000 4,067 5,100 300,000 300 500 1,000 450 2,000 35,000 2,100 - 0.00% 100.00% 100.00% 100.00% -100.00% 100.00% 58.33% -91.27% -66.67% 0.00% 13.64% 0.00% -25.00% 25.00% 0.00% 0.00% 0.00% 122.22% -100.00% 16.67% 75.00% 0.00% 390,241 0.07% 171,000 10,000 139,921 41.32% 100.00% 81.81% pg 90 08/02/2011 2:28 PM SANITATION 430-54071-432 Account Description 9901 Gen. Fund Reimb Total Expenses 2008 Actual 21,616 2009 Actual 26,744 2010 Actual 178,563 2011 Budget 224,364 $ $ $ $ 1,142,000 846,895 744,394 865,793 $ 2011 YTD 03/31/11 172,279 2012 Requested 324,279 2012 % Change 44.53% 672,532 $ 1,380,100 20.85% pg 90 CAPITAL OUTLAY Items 2012 Requested Radios GarbageTruck $ Budget 2012 Final EMAIL 1,000 170,000 171,000 2012 Approved $ Section 5 - Page 7 1,000 170,000 171,000 08/02/2011 2:28 PM AIRPORT 310-54103-431 Account Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget Personnel Expense 1004 Sal-Limited 1005 Sal-OT 2001 OASI 2002 State Retire 2005 Income Protect 2006 State Comp Personnel Expense Operating Expenses 3001 Contractual Services 4104 Telephone 4105 Utilities 4301 Auto/Equip 4302 Facilities Maintenance 5201 Liability Insurance 6001 Office Supplies 6002 Operating Supplies 6501 Gas/oil/lube 6503 Fuel (100 LL) 6504 Fuel (JET A) FBO (100LL) Profit Dist FBO (Jet A) Profit Dist - - $ - $ - $ 34,532 9,887 29 5,186 3,152 12,431 37,141 $ 2,471 2,116 9,511 70 7,745 4,776 74 121 374 40,915 48,692 $ 2011 YTD 03/31/11 2012 Requested 8,178 113 700 879 23 238 22,395 400 1,744 2,250 116 744 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% - 2012 % Change - $ - $ 10,130 $ 27,648 100.00% $ 1,560 7,200 6,000 5,300 2,700 26,100 45,900 4,176 7,344 $ $ 3,850 1,709 6,830 27 551 4,776 9 262 678 12,419 70,088 $ - 7,000 1,652 8,000 500 7,000 5,300 700 3,000 1,500 24,000 120,000 - 100.00% 5.90% 11.11% 100.00% 16.67% 0.00% 100.00% 11.11% 100.00% -8.05% 161.44% -100.00% -100.00% 68.10% - - 8,832 1,964 10,005 94 5,744 5,248 2,549 857 30,115 116,166 - Operating Expenses 102,358 116,864 181,574 106,280 101,200 178,652 Total Expenses before Capital 102,358 116,864 181,574 106,280 111,330 206,300 7301 Capital Outlay/Projects - - 194 - - 41,000 100.00% 8512 Grant Match - - - 5,400 - - 100.00% $ 102,358 $ 116,864 $ 181,768 $ 111,680 $ 111,330 $ 247,300 121.44% Total Expenses Budget 2012 Final EMAIL Section 5 - Page 8 pg 81 08/02/2011 2:28 PM AIRPORT 310-54103-431 CAPITAL OUTLAY Item Repair runway 0 Total Budget 2012 Final EMAIL 2012 Requested 2012 Approved* 41,000 41,000 41,000 41,000 $ $ Section 5 - Page 8 08/02/2011 2:28 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 Operating Expense 3001 4101 4102 4103 4104 4145 4301 4302 4303 4703 5201 5245 5401 5501 5801 6001 6002 6021 6031 6201 6301 6401 6501 6601 47,314 40,340 46,290 11,346 11,022 11,879 2,649 171 2,019 $ 22,161 49,603 73,275 510 11,120 7,000 441 29 2,172 Personnel Expense $ 173,030 $ 166,311 Contractual Services Electric Gas Water Telephone RV Park Utilities Auto/equip Building Maintenance Computer Maintenance Lease/Purchase Liab/Property Insurance RV Park Insurance Advertising/Printing DOC Labor Travel/training Office supplies Operating supplies Supplies /Chemicals Pro Shop Items for Resale Postage Small tools Books/dues/subscrip Gas/oil/lube Uniforms $ $ 11,806 49,464 6,786 7,104 1,126 11,025 7,602 10,119 18,572 284 8,154 236 498 20,232 8,810 7,537 64 71 13,904 1,872 Operating Expense $ 205,546 $ 185,265 7750 Capital Outlay 8050 Prior Expense - DGSC Budget 2012 Final EMAIL 2008 Actual 2009 Actual $ 14,820 55,337 4,470 12,214 1,244 15,243 17,654 20,700 3,721 4,967 254 2,953 13,633 8,041 13,884 54 91 215 14,323 1,728 17,199 - 2010 Actual $ $ 2011 Budget 2011 YTD 03/31/11 704 45,990 69,449 632 8,927 6,778 271 1,833 $ 72,101 50,000 45,237 500 12,839 11,313 8,577 426 2,679 10,862 37,715 46,768 467 7,621 5,913 2,409 206 1,488 134,584 $ 203,672 $ 113,450 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 $ 8,566 45,000 5,000 11,000 800 14,000 9,000 10,000 200 109,593 8,500 3,200 800 6,000 500 1,200 20,000 19,000 4,000 100 1,000 11,000 800 4,292 27,054 2,304 7,244 3,001 12,164 9,614 6,471 2,307 19,651 2,606 754 6,320 4,700 240 1,396 13,434 26,863 3,202 56 701 12,746 1,784 226,056 $ 289,259 20,000 - 150,776 - Section 5 - Page 9 2,607 - 2012 Requested $ 2012 % Change 17,639 50,000 66,601 500 10,308 8,364 3,639 244 2,023 -75.54% 0.00% 47.23% 0.00% -19.72% -26.07% -57.57% -42.83% -24.50% $ 159,318 -21.78% $ 6,533 45,000 5,000 11,450 3,980 14,000 9,000 10,000 300 32,719 2,100 2,000 7,000 6,000 500 1,200 20,000 19,000 20,000 100 1,000 401 14,000 1,000 -23.74% 0.00% 0.00% 4.09% 397.50% 0.00% 0.00% 0.00% 50.00% -70.14% -75.29% -37.50% 775.00% 0.00% 0.00% 0.00% 0.00% 0.00% 400.00% 0.00% 0.00% 100.00% 27.27% 25.00% $ 168,903 $ 232,283 -19.70% 91,428 - 50,000 - 190.71% pg 88 08/02/2011 2:28 PM Golf Course 450-52045-451 Total Expenses $ 395,775 *CAPITAL OUTLAY 2012 2012 Requested Approved 25,000 0 6,500 0 30,000 30,000 200,000 0 120,000 20,000 1,200 $ 382,700 $ 50,000 Golf Cart Path Restroom for 14th hole RV Outlet upgrade Proposed RV Clubhouse Improvements to Country Club 1 computer Total Budget 2012 Final EMAIL $ 502,352 $ 363,247 Section 5 - Page 9 $ 512,932 $ 373,781 $ 441,601 -13.91% 08/02/2011 2:28 PM Restaurant Lounge 450-52055-451 Account Description 2008 Actual 2009 Actual Personnel Expense 1003 Sal-Temp 1004 Sal-Limited 1005 Sal-OT 1008 Tips 2201 OASI 2002 State Retire 2005 Income Protect 2006 Workman's Comp Operating Expense 3001 4101 4102 4103 4104 4302 4303 5401 6001 6002 6301 6508 6509 6601 2011 YTD 03/31/11 2011 Budget - - - - - - 15,830 10,500 2,014 1,008 26 419 Personnel Expense $ - $ - $ - $ 29,797 Contractual Services Electric Gas Water/Sewer/Sanitation Telephone Building Maintenance Computer Maintenance Advertising/Printing Office supplies Operating supplies Small tools Beverages Food Uniforms $ - $ - $ - $ - Operating Expense $ - 7750 Capital Outlay 8101 Special Events Total Expenses Budget 2012 Final EMAIL 2010 Actual - $ $ - - $ $ - - $ Section 5 - Page 10 - 24,753 10,869 1,376 837 3,214 976 25 541 $ $ $ - 2012 Requested $ 15,000 76,691 - 2012 % Change 7,014 7,569 176 1,377 -5.24% 630.39% 0.00% 0.00% 248.28% 650.93% 571.96% 228.56% 42,590 $ 107,828 261.87% 7,167 6,609 2,069 334 299 2,185 710 1,784 3,811 22,453 310 21,071 21,378 1,313 $ 10,171 14,400 4,000 840 984 4,000 500 5,000 2,000 3,000 500 26,000 52,000 300 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 91,492 $ 123,695 100.00% 2,000 0.00% 100.00% 233,523 683.71% - 11,256 125 29,797 $ 145,464 $ pg 88 08/02/2011 2:28 PM GRANTS 2011-2012 Total Grant Award Housing and Community Development Home Grant 314-07 ADOH CDBG Curbing & Drainage 111-09 ADOH CDBG Lead Abatement 113-09 Dept of HUD Family Self Sufficiency Owner Occ Housing Emerg Repair 303-09 Housing CDBG Grant SSP ADOH Owner Occupied Housing Rehab CDBG Curbing & Drainage CDBG Curbing & Drainage 2 Fire FEMA AFG- Turn Out Gear CDAP Haz Mat BECC Haz Mat AZDEM ERF 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 Overtime GIITEM Salary & Overtime Public Works ADOT Chino Road Chino Road Realignment ADOT Paseo de la Amistad ADOT RR Depot Fountains ADOT A Ave Transportation Enhance ADOT Safe Route to School EECBG Energy Grant NADBANK ADOT Road Widening Library E-Rate Grant Wal Mart Library Literacy Grant Hometown Competitiveness TOTALS * * * * ** 2012 Max Revenue 2012 Max Expense 2012 Total Expenditure 2012 Match 660,000 286,404 40,500 68,000 115,500 300,000 300,000 286,404 331,028 2,387,836 7,313 102,524 27,632 68,000 34,137 300,000 300,000 29,651 331,028 1,200,284 7,313 48,797 27,632 68,000 30,761 300,000 300,000 29,651 331,028 1,143,181 60,000 50,000 70,000 8,000 31,000 1,500 2,000 222,500 60,000 50,000 70,000 8,000 31,000 2,000 2,000 223,000 60,000 50,000 70,000 8,000 31,000 4,247 2,000 225,247 616,000 36,000 2,000 26,000 36,000 150,000 866,000 616,000 36,000 2,000 26,000 36,000 150,000 866,000 616,000 36,000 2,000 26,000 36,000 150,000 866,000 2,000,000 1,168,000 550,000 120,000 301,754 300,000 100,000 625,134 275,000 5,439,888 2,000,000 1,168,000 20,000 120,000 300,000 300,000 100,000 625,134 183,407 4,816,541 2,000,000 1,168,000 20,000 120,000 300,000 300,000 100,000 625,134 183,407 4,816,541 114,000 17,100 122,305 1,000 10,000 133,305 122,305 1,000 1,279 124,584 122,305 1,000 1,279 124,584 12,231 12,231 9,049,529 7,230,409 7,175,553 275,874 7,321,395 5,593,868 Total Grant Match from the GF 5,539,012 - 7,313 48,797 27,632 68,000 30,761 300,000 300,000 29,651 343,978 1,156,131 12,950 12,950 3,000 3,000 63,000 50,000 70,000 8,000 31,000 4,247 2,000 228,247 - 616,000 36,000 2,000 26,000 36,000 150,000 866,000 - 116,593 *** 247,693 159,281 - 2,114,000 1,168,000 20,000 120,000 317,100 300,000 100,000 625,134 300,000 5,064,234 134,536 1,000 1,279 136,815 7,451,427 5,698,293 159,281 *Grants Accounted for in General Fund Rev & Exp **Grant Accounted for in the Water & Sewer CIP Rev and Exp *** This match is included in Call Center Budget 2012 Final EMAIL Section 6 - Page 1 08/02/2011 2:28 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2011-2012 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL AMOUNT APPROVED DEPT. APPROVED FUNDING SOURCE ADMINISTRATION DEPARTMENT TOTAL $0 $ - $ - FINANCE DEPARTMENT TOTAL $ - MIS 31 Desktops Replacement 8 Notebooks 9 Printers 1 UPS for Police DEPARTMENT TOTAL 60,000 1,500 12,400 50,000 60,000 1,500 12,400 $ 123,900 Special Projects GF Reserve GF Reserve $ 73,900 $ - $ - HUMAN RESOURCES DEPARTMENT TOTAL $ - $ - MAGISTRATE DEPARTMENT TOTAL FIRE/EMS 3 Cardiac Monitors New Office Furniture Type 2 EMS Ambulance Chief's Vehicle Ladder Truck Fire Pumper DEPARTMENT TOTAL POLICE 2 Patrol Vehicles 12 Ballistic Vest 2 AC/Heaters 12 Office Chairs for Patrol Briefing Room 2 Office Chairs for Dispatch 20 Conference Room Chairs DEPARTMENT TOTAL 60,300 5,000 90,000 40,000 1,000,000 450,000 $ 1,645,300 $ 88,000 10,800 16,000 4,000 1,000 8,000 88,000 10,800 16,000 $ 127,800 $ - $ 5,000 Will be leased - Auction/Amount will only be used if rev come in as bud GF Reserve Auction $ 114,800 $ - $ 5,000 $ - ECONOMIC DEVELOPMENT $ DEPARTMENT TOTAL VISITOR CENTER Floor Replacement DEPARTMENT TOTAL 5,000 CEMETERY Remodel Public Restrooms Roof repairs to main building Chain Link fencing Push Mowers DEPARTMENT TOTAL 5,000 1,500 2,000 1,200 - 5,000 GF Reserve 0 0 0 0 $ 9,700 COMMUNITY DEVELOPMENT - Budget 2012 Final EMAIL Section 7 - Page 80 - 08/02/2011 2:28 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2011-2012 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL DEPARTMENT TOTAL $ PARKS 1 Ride Mowers Motor for liner Power Washer Gator Utility Vehicle Playground replacement equipment Roofing Materials for Airport Park Ramadas Roof for Paseo and Airport Pump House Utility Vehicle for Herbicide Sprayer DEPARTMENT TOTAL AMOUNT APPROVED DEPT. APPROVED - 11,500 3,000 4,000 9,000 10,000 5,000 20,000 12,000 $ FUNDING SOURCE - 11,500 3,000 4,000 10,000 5,000 - GF Reserve GF Reserve GF Reserve GF Reserve GF Reserve $ 74,500 $ 33,500 $ - $ - RECREATION DEPARTMENT TOTAL AQUATICS Office Roof Replacement Tile Replacement ADA Compliance Hydraulic Chairs DEPARTMENT TOTAL PUBLIC WORKS/ADMINISTRATION Rivera Building Remodel $ 2,000 5,500 7,000 $ $ 14,500 30,000 DEPARTMENT TOTAL PW CONSTRUCTION City Hall Boiler Replacement (1st floor) City Hall AHU Heating unit (1st floor) City Hall Chiller (1st floor) DEPARTMENT TOTAL 2,000 7,000 GF Reserve GF Reserve $ 9,000 $ - $ - $ - $ - $ 30,000 45,000 40,000 80,000 $ 165,000 $ - PUBLIC WORKS/FLEET MAINTENANCE DEPARTMENT TOTAL LIBRARY 1 Replacement A/C Unit - 12,000 DEPARTMENT TOTAL $ TOTAL GENERAL FUND REQUESTS 12,000 TOTAL REQUESTED TOTAL AMOUNT APPROVED $ 2,207,700 $ 236,200 Capital Outlay Funding GADA Funds JCEF Funds Seized Vehicle Auction Funds (net of expenses) Special Projects - (new revenue) General Fund TOTAL ALL FUNDING SOURCES Budget 2012 Final EMAIL $ $ $ 104,000 $ 38,143 $ 94,057 $ 236,200 Section 7 - Page 81 08/02/2011 2:28 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2011-2012 DEPT ITEM/PROJECT AMOUNT REQUESTED DEPT. TOTAL BALANCE Budget 2012 Final EMAIL AMOUNT APPROVED DEPT. APPROVED $ Section 7 - Page 82 FUNDING SOURCE - 08/02/2011 2:28 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2011-2012 DEPT ITEM/PROJECT AMOUNT REQUESTED SANITATION Radios GarbageTruck DEPARTMENT TOTAL 1,000 170,000 STREETS (HURF) 2 backhoe Street Sweeper 1 printer & 1 computer Suburban DEPARTMENT TOTAL 180,000 229,000 2,400 50,000 250,000 2,400 20,000 $ $ $ $ $ $ HOUSING 1 vehicle 1 copier 1 printer for checks DEPARTMENT TOTAL $ $ $ $ 2,400 2,400 Water Fund $ 2,400 73,900 Water Fund Water Fund Water Fund Water Fund Water Fund $ 33,900 $ - $ 240,000 2,400 272,400 25,000 6,500 30,000 200,000 120,000 1,200 Will be leased $ 2,400 30,000 20,000 $ 382,700 20,000 10,500 2,500 Transfer from Special Projects Transfer from Special Projects $ 50,000 20,000 10,500 2,500 $ $ HURF 3,000 10,000 10,000 6,500 4,400 - $ GOLF COURSE Golf Cart Path Restroom for 14th hole RV Outlet upgrade Proposed RV Clubhouse Improvements to Country Club 1 computer DEPARTMENT TOTAL 171,000 2,400 - $ WASTEWATER Sewer Cleaning Vac-Con Truck 2 computers Truck DEPARTMENT TOTAL Sanitation Fund Under Depreciation $ 461,400 3,000 10,000 10,000 6,500 4,400 40,000 50,000 100,000 90,000 FUNDING SOURCE 1 to be leased along with other divisions $ WATER/SEWER - CAPITAL REINVESTMENT PROGRAM Heavy Fleet Vehicle Replacement Program 1 Dump truck 1 Backhoe DEPARTMENT TOTAL Budget 2012 Final EMAIL 171,000 2,400 0 WATER FIELD Chlorinator Equipment Hydrant Replacement Program Valve Replacement Program Meter Replacement Program 3 computers & 2 printers 2 Shortbed trucks DEPARTMENT TOTAL DEPT. APPROVED 2,400 $ DEPARTMENT TOTAL AMOUNT APPROVED 1,000 170,000 $ WATER OFFICE 1 computer & 1 printer AIRPORT Repair runway DEPT. TOTAL 33,000 41,000 Section 7 - Page 83 Housing Fund Reserves Housing Fund Reserves Housing Fund Reserves $ 41,000 33,000 Reserve 08/02/2011 2:28 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2011-2012 DEPT ITEM/PROJECT DEPARTMENT TOTAL Budget 2012 Final EMAIL AMOUNT REQUESTED DEPT. TOTAL $ 41,000 Section 7 - Page 84 AMOUNT APPROVED DEPT. APPROVED $ FUNDING SOURCE 41,000 08/02/2011 2:28 PM CITY OF DOUGLAS CAPITAL IMPROVEMENT PROGRAM 2011-2012 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 $1,677,800 AMOUNT APPROVED DEPT. APPROVED TOTAL AMOUNT APPROVED $336,100 $ 33,000 $ 50,000 $ 253,100 Sanitation Fund HURF Water Fund Sewer Fund Water/Sewer CIP HUD Golf Course Airport $ $ $ $ $ $ $ $ $ 171,000 2,400 36,300 2,400 33,000 50,000 41,000 - Total Enterprise Funds CIP 11/12 $ 212,100 TOTAL GENERAL FUND REQUESTS: TOTAL ENTERPRISE FUND REQUESTS: $ 2,207,700 $ 1,677,800 $ 236,200 $ 336,100 TOTAL CAPITAL OUTLAY REQUESTS: $ 3,885,500 $ 572,300 LESS: FUNDED BY SPECIAL FUNDING $ 137,000 $ 137,000 TOTAL CITY FUNDED CAPITAL OUTLAY: $ 3,748,500 $ 435,300 Budget 2012 Final EMAIL Section 7 - Page 85 FUNDING SOURCE 08/02/2011 2:28 PM REIMBURSEMENTS GENERAL FUND REIMBURSEMENT FROM ENTERPRISE FUNDS $ Description HURF SANITATION WATER SEWER WATER/SEWER - CIP Total reimbursement % 22.50% 13.50% 15.50% 13.50% 35.00% 100.00% $ 179,846 * 2012 Projected 40,465 324,279 **Includes an additional $300,000 transfer to the General Fund 27,876 24,279 62,946 479,846 *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 Budget 2012 Final EMAIL 451,161 516,140 530,743 300,413 1,798,457 Section 2 - Page 2A 08/02/20112:28 PM