Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017.07 July Monthly Report
Jan Feb Mar Apr May Jun Jul Aug Sept 2016 Unreserved Fund Balance 11,859,782 14,097,256 17,193,730 16,597,583 18,375,173 21,225,995 15,790,000 2017 Unreserved Fund Balance 15,453,984 17,244,431 19,734,012 18,292,843 17,839,404 14,612,957 13,603,487 2016 Cash Balance 3,656,830 2,587,845 8,182,090 7,808,208 7,101,333 12,919,440 10,046,315 2017 Cash Balance 6,338,271 6,393,110 11,561,044 10,901,398 10,376,936 6,169,276 7,179,518 2016 v 2017 Fund and Cash Balance-- General Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 2016 Unreserved Fund Balance 2017 Unreserved Fund Balance 2016 Cash Balance 2017 Cash Balance 2017 June YTD 2016 Budget 2017 Actual %Actual 28,639,628 5,132,831 20,182,192 27,302,687 49,402,274 3,994,358 27,299,941 55 44,156,868 5,496,150 100,927 1,852,443 34 6,851,422 11,648,000 500,261 2,897,028 25 11,012,646 115,500 2,878 95,548 83 70,395 3,810,000 257,933 1,781,806 47 3,611,901 640,000 53,333 395,547 62 687,835 5,650,895 453,802 4,126,705 73 5,401,563 2,642,500 139,606 1,473,122 56 2,687,897 7,705,774 627,310 4,391,168 56.99% 8,349,626 839,965 70,593 676,525 80.54% 988,785 2,138,046 55,198 388,186 18.16% 1,338,382 50,100 4,783 19,436 38.79% 30,285 REVENUE TOTAL - 118,778,832 11,393,813 65,579,647 55.21% 112,490,292 CITY COUNCIL 498,189.26 41,078.96 277,530.56 55.71%433,601.01 CITY CLERK 275,488.00 14,876.21 161,914.10 58.77%294,664.86 CITY MANAGER'S OFFICE 9,878,454.00 685,983.15 3,824,837.44 38.72%7,471,733.90 LAW 854,050.00 64,011.12 434,284.41 50.85%1,052,130.01 ADMINISTRATIVE SERVICES 9,700,879.00 738,258.48 5,116,775.94 52.75%9,164,946.70 COMMUNITY DEVELOPMENT 2,804,668.00 200,761.89 1,358,974.87 48.45%2,510,408.43 POLICE 38,223,842.00 4,391,553.08 23,706,709.85 62.02%37,817,627.43 FIRE MGMT & SUPPORT 24,294,001.00 3,270,924.27 15,180,357.62 62.49%23,235,713.69 HEALTH 3,582,312.00 269,046.28 1,755,510.11 49.00%3,097,350.98 PUBLIC WORKS .00 .00 .00 0.00%(1,475.00) PARKS, REC. AND COMMUNITY SERV.12,361,460.00 1,630,090.65 6,779,255.68 54.84%11,997,475.88 PUBLIC WORKS AGENCY 16,212,848.00 1,096,699.36 7,973,364.67 49.18%14,488,136.71 EXPENSE TOTAL - 118,686,191 12,403,283 66,569,515 56.09% 111,562,315 118,778,832 11,393,813 65,579,648 55.21% 112,490,292 118,686,191 12,403,283 66,569,515 56.09% 111,562,594 92,641 (1,009,470) (989,867) 927,698 Classification July 2017 Financial Report Through 07/31/17 Summary Listing Fund 100 - GENERAL FUND Permit Fee Fines and Forfeitures Property Taxes Other Taxes License Intergovernmental Revenue Other Revenue Interest Income Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Interfund Transfers REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Net Gain (Loss) Fund 100 - GENERAL FUND Totals 2017 June YTD 2016 Budget 2017 Actual %Actual - 300 1,850 0.00% 3,350 6,737,875 (325,371) 3,035,842 45.06% 6,340,992 65,000 - 56,000 86.15% 168,500 4,120,636 - 2,060,318 50.00% 3,711,768 12,125 - - 0.00% - 203,216 19,490 122,733 60.40% 195,895 35,070 5,549 28,073 80.05% 38,159 REVENUE TOTAL 11,173,922 (300,033) 5,304,816 47.47% 10,458,663 26,000 4,886 21,268 81.80% 26,465 1,117,119 87,044 588,569 52.69% 1,206,649 104,802 8,432 55,843 53.28% 229,588 3,222,411 227,782 1,738,920 53.96% 2,846,933 278,864 3,647 119,671 42.91% 237,610 3,020,000 321,739 948,172 31.40% (24,598) 524,102 46,180 309,183 58.99% 504,784 - - - 0.00% 2,836,672 11,000 - 2,222 20.20% 5,910 4,331,771 - 141,632 3.27% 390,235 304,000 11,717 148,409 48.82% 255,626 1,584,683 106,224 743,565 46.92% 1,303,783 EXPENSE TOTAL 14,524,752 817,650 4,817,453 33.17% 9,819,656 11,173,922 (300,033) 5,304,816 47.47% 10,458,663 14,524,752 817,650 4,817,453 33.17% 9,819,656 (3,350,830) (1,117,683) 487,362 639,007 Fund 505 - PARKING SYSTEM FUND Permit July 2017 Financial Report Through 07/31/17 Summary Listing Classification Other Revenue Interest Income Employee Pay Benefits Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Pensions Services Supplies REVENUE TOTALS EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net Gain Debt Service Miscellaneous Interfund Transfers Fund 505 - PARKING SYSTEM FUND Totals 2017 June YTD 2016 Budget 2017 Actual %Actual 70,000 6,631 54,263 77.52% 90,592 17,324,000 1,427,103 9,552,161 55.14% 15,851,052 36,000 4,570 27,803 77.23% 51,737 135,000 141,262 141,625 104.91% 168,482 6,828,400 5,514 628,003 9.20% 306,143 1,600 2,469 17,381 1086.32% 16,536 REVENUE TOTAL 24,395,000 1,587,548 10,421,236 42.72% 16,484,542 183,365 18,834 98,457 53.69% 193,328 4,037,387 310,035 2,291,515 56.76% 3,898,385 368,658 29,755 217,020 58.87% 888,372 2,250,760 138,490 970,186 43.10% 1,743,992 1,360,390 106,476 481,020 35.36% 876,885 14,982,119 637,711 1,321,960 8.82% 36,712 1,174,064 97,458 666,269 56.75% 1,110,835 - - - 0.00% 1,973,593 1,000 - - 0.00% 1,000 1,438,470 - 421,769 29.32% 633,708 62,980 - - 0.00% 238,468 3,502,313 291,859 2,043,016 58.33% 3,502,313 EXPENSE TOTAL 29,361,507 1,630,619 8,511,211 28.99% 15,097,591 24,395,000 1,587,548 10,421,236 42.72% 16,484,542 29,361,507 1,630,619 8,511,211 28.99% 15,097,591 (4,966,507) (43,071) 1,910,025 1,386,952 Fund 510 - WATER FUND Fee July 2017 Financial Report Through 07/31/17 Summary Listing Classification Interest Income Employee Pay Benefits Pensions Water Charges for Services Sewer Charges for Services Other Charges for Services Other Revenue Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Services Supplies EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Miscellaneous Interfund Transfers Fund 510 - WATER FUND Totals REVENUE TOTALS 2017 June YTD 2016 Budget 2017 Actual %Actual 12,501,500 935,715 7,509,790 60.07% 13,027,160 19,650 - - 0.00% 21,600 604,165 - - 0.00% 3,087 1,000 665 4,976 497.65% 4,450 REVENUE TOTAL 13,126,315 936,380 7,514,766 57.25% 13,056,297 57,040 4,335 22,237 38.99% 37,763 859,043 67,236 485,701 56.54% 862,355 73,398 6,562 46,459 63.30% 204,330 908,500 41,098 89,872 9.89% 109,493 92,300 13,348 33,427 36.22% 48,058 2,819,700 2,884 729,138 25.86% 15,370 432,953 35,555 249,576 57.65% 414,270 - - - 0.00% 3,461,103 8,370,946 364,699 4,222,025 50.44% 1,336,366 1,500 - - 0.00% 5,000 991,677 82,640 578,478 58.33% 773,873 EXPENSE TOTAL 14,607,057 618,357 6,456,914 44.20% 7,267,980 13,126,315 936,380 7,514,767 57.25% 13,056,297 14,607,057 618,357 6,456,914 44.20% 7,267,980 (1,480,742) 318,023 1,057,853 5,788,316 July 2017 Financial Report Through 07/31/17 Summary Listing Classification Fund 515 - SEWER FUND Other Revenue Interest Income Employee Pay Benefits Sewer Charges for Services Other Charges for Services Capital Outlay Insurance and Other Chargebacks Depreciation Expense Debt Service Pensions Services Supplies EXPENSE TOTALS Fund 515 - SEWER FUND Net Gain (Loss) Miscellaneous Interfund Transfers Fund 515 - SEWER FUND Totals REVENUE TOTALS 2017 June YTD 2016 Budget 2017 Actual %Actual 275,000 - 83,374 30.32% 170,144 3,632,394 296,853 2,089,471 57.52% 3,586,453 1,055,967 87,997 615,981 58.33% 1,055,967 238,000 14,007 56,707 23.83% 274,808 REVENUE TOTAL 5,201,361 398,857 2,845,532 54.71% 5,087,372 45,000 6,899 23,222 51.60% 43,025 644,768 40,094 318,115 49.34% 620,226 60,473 4,274 31,113 51.45% 151,916 3,679,126 100,125 1,722,995 46.83% 3,438,311 53,050 5,276 15,965 30.09% 54,768 25,750 2,736 13,386 51.98% 6,034 149,325 8,749 67,731 45.36% 138,618 21,046 - 920 4.37% 2,251 15,000 - 2,232 14.88% 12,232 504,807 42,067 294,471 58.33% 499,493 EXPENSE TOTAL 5,198,345 210,220 2,490,149 47.90% 4,966,872 5,201,361 398,857 2,845,532 54.71% 5,087,372 5,198,345 210,220 2,490,149 47.90% 4,966,872 3,016 188,637 355,382 120,500 Fund 520 - SOLID WASTE FUND Classification License July 2017 Financial Report Through 07/31/17 Summary Listing Employee Pay Benefits Pensions Other Charges for Services Interfund Transfers Other Revenue Debt Service Miscellaneous Interfund Transfers Fund 520 - SOLID WASTE FUND Totals Services Supplies Capital Outlay Insurance and Other Chargebacks REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain (Loss) July YTD 2016 2017 2017 Actuals 5,132,831 20,182,193 27,302,687 3,994,358 27,299,941 44,156,868 604,066 4,845,018 17,934,463 257,933 1,781,806 3,611,901 646,741 5,995,374 8,777,295 627,310 4,391,168 8,349,626 70,593 676,525 988,785 55,198 388,186 1,338,382 - - - - - - - - - 4,783 19,436 30,285 - - - - - - 11,393,813 65,579,648 112,490,292 4,894,751 35,000,661 61,447,382 1,571,135 6,245,286 11,768,857 34,435 168,802 159,648 4,911,614 19,844,654 28,043,325 - 80,444 94,695 - - - 397 1,801 51,836 - - - 309,482 457,587 2,166,129 681,469 4,770,282 7,830,722 12,403,283 66,569,515 111,562,594 11,393,813 65,579,648 112,490,292 12,403,283 66,569,515 111,562,594 (1,009,470) (989,867) 927,698 Starting Fund Balance 14,593,354 14,593,354 Net Change 92,641 (989,867) Ending Fund Balance 14,685,995 13,603,487 3,810,000 17,259,650 - 2,138,046 839,965 7,705,774 8,933,395 - - 50,100 - - - 204,568 30,321,297 499,000 13,716,790 118,686,191 9,909,626 1,200,481 - 213,519 92,641 118,686,191 118,778,832 REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Totals EXPENSE TOTALS Fund 100 - GENERAL FUND Totals Debt Service Miscellaneous Interfund Transfers Community Sponsored Organizations Depreciation Expense Contingencies Services and Supplies Capital Outlay Insurance and Other Chargebacks REVENUE TOTALS 118,778,832 EXPENSE Salary and Benefits 62,620,910 Interest Income Special Assessment Reappropriation of Surplus Workers Compensation and Liability Insurance Library Revenue Interfund Transfers Intergovernmental Revenue Other Revenue Licenses, Permits and Fees Fines and Forfeitures Charges for Services Fund 100 - GENERAL FUND REVENUE Property Taxes 28,639,628 Other Taxes 49,402,274 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 1 of 35 July YTD 2016 2017 2017 Actuals 206,525 663,718 827,615 - - - - - - - - - - - - - - - - - - 2,030 18,527 49,590 - - - - - - - - - 81 646 802 - - - - - - 208,636 682,891 878,006 21,606 154,891 246,916 53,207 334,435 529,013 - - - 3,558 24,018 26,205 - - - - - - - - - - - - - 110 2,723 - - - 78,371 513,454 804,857 208,636 682,891 878,006 78,371 513,454 804,857 130,265 169,437 73,149 Starting Fund Balance 586,388 586,388 Net Change (252,971) 169,437 Ending Fund Balance 333,417 755,825 REVENUE TOTALS 926,000 EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND (252,971) EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND Debt Service - Miscellaneous 7,000 Interfund Transfers - Community Sponsored Organizations - Depreciation Expense - Contingencies - Services and Supplies 858,900 Capital Outlay - Insurance and Other Chargebacks 30,968 REVENUE TOTALS 926,000 EXPENSE Salary and Benefits 282,103 Interest Income 1,000 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 25,000 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 900,000 Other Taxes - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 2 of 35 July YTD 2016 2017 2017 Actuals - - - 71,596 501,173 884,794 - - - - - - 71,596 501,173 884,794 - 121 61 - - - 203,375 481,547 849,333 - - - 203,375 481,669 849,394 71,596 501,173 884,794 203,375 481,669 849,394 (131,779) 19,504 35,400 Starting Fund Balance 70,806 70,806 Net Change - 19,504 Ending Fund Balance 70,806 90,310 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN - Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 859,153 Community Sponsored Organizations 92,098 Miscellaneous - EXPENSE TOTALS 859,153 EXPENSE Services and Supplies 767,055 Capital Outlay - Intergovernmental Revenue - Other Revenue - REVENUE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 859,153 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 3 of 35 July YTD 2016 2017 2017 Actuals - 1,000,000 1,000,000 - 1,000,000 1,000,000 83,333 583,333 1,000,000 83,333 583,333 1,000,000 - 1,000,000 1,000,000 83,333 583,333 1,000,000 (83,333) 416,667 (0) Starting Fund Balance - - Net Change - 416,667 Ending Fund Balance - 416,667 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 4 of 35 July YTD 2016 2017 2017 Actuals 936,315 4,316,254 6,136,248 - - 4,141 (161) 75,378 152,537 52 221 - - - 235,800 - 4,920 75,418 (1,120) 42,767 67,943 (39) 107,001 339,027 163 2,309 4,717 935,210 4,548,850 7,015,830 395,770 2,397,601 4,246,657 145,727 884,690 1,733,725 - 314 57,842 42,632 279,865 406,708 .00 .00 .00 - - - - - - 22 22 - 28,635 200,444 340,272 612,785 3,762,935 6,785,204 935,210 4,548,850 7,015,830 612,785 3,762,935 6,785,204 322,426 785,915 230,626 Starting Fund Balance 650,655 650,655 Net Change - 785,915 Ending Fund Balance 650,655 1,436,570 REVENUE TOTALS 7,250,345 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals - EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals Debt Service - Miscellaneous - Interfund Transfers 343,618 Insurance and Other Chargebacks 500,433 Depreciation Expense .00 Contingencies - Salary and Benefits 4,460,836 Services and Supplies 1,940,058 Capital Outlay 5,400 Interest Income 5,400 REVENUE TOTALS 7,250,345 EXPENSE Intergovernmental Revenue 57,418 Other Revenue 24,849 Library Revenue 386,020 Fines and Forfeitures 164,000 Charges for Services - Interfund Transfers 190,200 Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,376,358 Other Taxes 46,100 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 5 of 35 June YTD 2016 2017 2017 Actuals 232,742 232,742 364,827 - - 676,150 - - 1 232,742 232,742 1,040,978 - - 12,349 - - - - 38,227 385,696 - - - - - 650,000 - 38,227 1,048,044 232,742 232,742 1,040,978 - 38,227 1,048,044 232,742 194,515 (7,066) Starting Fund Balance 29,709 29,709 Net Change - 194,515 Ending Fund Balance 29,709 224,224 - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,955 Other Revenue Interest Income - REVENUE TOTALS 345,955 EXPENSE Services and Supplies - Capital Outlay - Debt Service 345,955 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 345,955 EXPENSE TOTALS 345,955 Fund 186 - LIBRARY DEBT - Fund 186 - LIBRARY DEBT REVENUE TOTALS 345,955 Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 6 of 35 June YTD 2016 2017 2017 Actuals - - - - - - - - - - - - 144,233 279,401 - - - - 144,233 279,401 - - - - 144,233 279,401 - (144,233) (279,401) - Starting Fund Balance - - Net Change - (279,401) Ending Fund Balance - (279,401) Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Property Taxes - REVENUE TOTALS 3,774,500 EXPENSE Other Revenue 3,774,500 Interest Income - Capital Outlay 3,774,500 Debt Service - EXPENSE TOTALS 3,774,500 EXPENSE TOTALS 3,774,500 Fund 187 - LIBRARY CAPITAL IMPROVEMENT - Fund 187 - LIBRARY CAPITAL IMPROVEMENT REVENUE TOTALS 3,774,500 Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 7 of 35 July YTD 2016 2017 2017 Actuals - - - - - 91,447 - - - 12 106 - 12 106 91,447 1,680 12,386 22,569 - 1,860 6,060 - 2,642 39,316 373 2,520 4,173 - - - - - 1,705 377 2,636 17,623 2,430 22,044 91,447 12 106 91,447 2,430 22,044 91,447 (2,418) (21,938) - Starting Fund Balance - - Net Change (303) (21,938) Ending Fund Balance (303) (21,938) EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD 40,601 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 139,500 Miscellaneous 50,000 Interfund Transfers 4,518 EXPENSE TOTALS 98,899 Capital Outlay 7,000 Insurance and Other Chargebacks 3,984 Debt Service - EXPENSE Salary and Benefits 28,297 Services and Supplies 5,100 Other Revenue - Interest Income - REVENUE TOTALS 139,500 Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 139,500 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 8 of 35 July YTD 2016 2017 2017 Actuals 131,310 1,101,126 1,896,461 - - - 1,607 8,090 6,613 - - - 132,917 1,109,216 1,903,074 - - - - - 130,789 - - - - - - - - - 71,499 500,494 2,189,000 71,499 500,494 2,319,789 132,916.87 1,109,215.61 1,903,073.96 71,499 500,494 2,319,789 61,418 608,721 (416,715) Starting Fund Balance 1,413,678 1,413,678 Net Change (327,990) 608,721 Ending Fund Balance 1,085,688 2,022,399 Fund 200 - MOTOR FUEL TAX FUND Totals (327,990) Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,921,000.00 EXPENSE TOTALS 2,248,990 Interfund Transfers 857,990 EXPENSE TOTALS 2,248,990 Contingencies - Debt Service - Miscellaneous - EXPENSE Services and Supplies - Capital Outlay 1,391,000 Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,921,000 Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,920,000 Other Revenue - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 9 of 35 July YTD 2016 2017 2017 Actuals 93,697 576,735 1,038,331 - - - - - - 617 3,433 2,472 94,314 580,168 1,040,803 38,914 270,434 509,028 13,729 168,723 263,105 - 21,142 423,493 8,230 52,683 91,628 - - - - - - - - - - - - 6,081 42,570 142,207 66,954 555,551 1,429,460 94,314 580,168 1,040,803 66,954 555,551 1,429,460 27,360 24,616 (388,657) Starting Fund Balance 163,061 163,061 Net Change (8,718) 24,616 Ending Fund Balance 154,343 187,677 Fund 205 - EMERGENCY TELEPHONE (8,718) Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,021,700 EXPENSE TOTALS 1,030,418 Interfund Transfers 72,977 EXPENSE TOTALS 1,030,418 Contingencies - Debt Service - Miscellaneous - Capital Outlay 55,000 Insurance and Other Chargebacks 102,517 Community Sponsored Organizations - EXPENSE Salary and Benefits 517,524 Services and Supplies 282,400 Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,021,700 Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,020,700 Intergovernmental Revenue - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 10 of 35 July YTD 2016 2017 2017 Actuals 51,847 230,294 321,266 - 1 2 51,847 230,295 321,268 - 164,500 323,000 - - - - - - - 164,500 323,000 51,847 230,295 321,268 - 164,500 323,000 51,847 65,795 (1,732) Starting Fund Balance (192,276) (192,276) Net Change - 65,795 Ending Fund Balance (192,276) (126,481) EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 320,000 Debt Service - Miscellaneous - EXPENSE TOTALS 320,000 REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 11 of 35 July YTD 2016 2017 2017 Actuals - - - - - - 95,299 95,299 2,016,478 - - 10,197 - - - 95,299 95,299 2,026,675 27,732 211,753 414,848 - 3,348 6,219 - 70,299 608,829 7,285 51,466 405,247 - 25,000 507,815 - - - - - - 40 6,998 61,555 729.75 5,108.25 17,937.75 35,787 373,971 2,022,452 95,299 95,299 2,026,675 35,787 373,971 2,022,452 59,512 (278,673) 4,224 Starting Fund Balance 64,106 64,106 Net Change (9,484) (278,673) Ending Fund Balance 54,622 (214,567) EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals (9,484) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,272,494 Miscellaneous 569,970 Interfund Transfers 829,458.00 EXPENSE TOTALS 2,281,978 Community Sponsored Organizations 175,500 Contingencies - Debt Service - Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 93,120 REVENUE TOTALS 2,272,494 EXPENSE Salary and Benefits 393,090 Intergovernmental Revenue 2,272,494 Other Revenue - Interest Income - Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 12 of 35 July YTD 2016 2017 2017 Actuals - - - 7,620 40,073 208,541 6 207 4,656 7,626 40,281 213,197 - - - - 24,700 160,641 - - - - - - - 24,700 160,641 7,626 40,281 213,197 - 24,700 160,641 7,626 15,581 52,555 Starting Fund Balance 210,921 210,921 Net Change - 15,581 Ending Fund Balance 210,921 226,502 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Interfund Transfers - EXPENSE TOTALS 293,000 Salary and Benefits - Services and Supplies 293,000 Miscellaneous - Interest Income - REVENUE TOTALS 293,000 EXPENSE Fund 220 - CDBG LOAN REVENUE Intergovernmental Revenue - Other Revenue 293,000 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 13 of 35 July YTD 2016 2017 2017 Actuals - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (100,000) - Ending Fund Balance 69,915 169,915 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (100,000) Fund 235 - NEIGHBORHOOD REVENUE TOTALS - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Services and Supplies - Capital Outlay - Debt Service - Interest Income - REVENUE TOTALS - EXPENSE Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes - Interfund Transfers - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 14 of 35 July YTD 2016 2017 2017 Actuals - 43,758 178,211 2,282 15,974 27,259 1 13 14 2,283 59,745 205,484 3,085 22,384 31,964 - 44,348 180,110 - - - 404 2,744 (4,297) - - - - - - - 126 100 - - - 3,489 69,602 207,876 2,283 59,745 205,484 3,489 69,602 207,876 (1,206) (9,857) (2,392) Starting Fund Balance 2,377 2,377 Net Change (831) (9,857) Ending Fund Balance 1,546 (7,480) EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals (831) Fund 240 - HOME FUND Totals REVENUE TOTALS 585,861 Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 586,692 Insurance and Other Chargebacks 4,987 Community Sponsored Organizations - Debt Service - Salary and Benefits 41,005 Services and Supplies 540,200 Capital Outlay - Interest Income - REVENUE TOTALS 585,861 EXPENSE Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 585,861 Other Revenue - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 15 of 35 July YTD 2016 2017 2017 Actuals - 20,000 106,780 - - - - - - 31,667 97,500 448,343 348 2,186 1,392 32,014 119,686 556,515 3,085 22,383 34,138 47,850 47,850 201 - - - 336 2,266 3,178 - - 735 - - - - 45,969 110,956 - - - 51,271 118,468 149,207 32,014 119,686 556,515 51,271 118,468 149,207 (19,256) 1,219 407,308 Starting Fund Balance 1,401,188 1,401,188 Net Change (1,071,422) 1,219 Ending Fund Balance 329,766 1,402,407 Fund 250 - AFFORDABLE HOUSING FUND (1,071,422) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 635,830 EXPENSE TOTALS 1,707,252 Interfund Transfers - EXPENSE TOTALS 1,707,252 Community Sponsored Organizations 455,000 Debt Service - Miscellaneous 102,500 Services and Supplies 1,077,500 Capital Outlay - Insurance and Other Chargebacks 8,800 REVENUE TOTALS 635,830 EXPENSE Salary and Benefits 63,452 Intergovernmental Revenue - Other Revenue 585,600 Interest Income 230 Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 16 of 35 July YTD 2016 2017 2017 Actuals 1,500,911 3,940,771 4,729,649 - - - - - - - - - 3,816 18,726 14,012 1,504,727 3,959,497 4,743,661 - - - - - 2,750 - - 4,473 - - - - 49,336 1,098,676 29,167 2,264,485 4,455,515 29,167 2,313,821 5,561,415 1,504,727 3,959,497 4,743,661 29,167 2,313,821 5,561,415 1,475,561 1,645,676 (817,754) Starting Fund Balance 5,624,676 5,624,676 Net Change (5,385,636) 1,645,676 Ending Fund Balance 239,040 7,270,352 EXPENSE TOTALS 10,540,636 Fund 300 - WASHINGTON NATIONAL TIF (5,385,636) Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,155,000 Miscellaneous 100,000 Interfund Transfers 9,940,636 EXPENSE TOTALS 10,540,636 Services and Supplies 500,000 Capital Outlay - Debt Service - REVENUE TOTALS 5,155,000 EXPENSE Salary and Benefits - Interfund Transfers - Other Revenue - Interest Income 10,000 Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 17 of 35 July YTD 2016 2017 2017 Actuals - - 1,233,675 - (45,325) - - 1,320 2,319 - (44,005) 1,235,994 - - 2,488 - - - - - - - - - - 599,668 129,192 - - 1,741,757 - 599,668 1,873,437 - (44,005) 1,235,994 - 599,668 1,873,437 - (643,672) (637,443) Starting Fund Balance 643,672 643,672 Net Change (513,865) (643,672) Ending Fund Balance 129,807 (0) REVENUE TOTALS - EXPENSE TOTALS 513,865 Fund 310 - HOWARD-HARTREY TIF Totals (513,865) EXPENSE TOTALS 513,865 Fund 310 - HOWARD-HARTREY TIF Totals Debt Service - Miscellaneous - Interfund Transfers 513,865 Services and Supplies - Capital Outlay - Community Sponsored Organizations - Interest Income - REVENUE TOTALS - EXPENSE Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes - Other Revenue - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 18 of 35 July YTD 2016 2017 2017 Actuals 2,006,437 7,953,782 10,438,928 256,961 1,798,725 2,999,879 - - 8,291,285 1,865 11,296 24,264 2,265,262 9,763,803 21,754,356 525 1,775 149,553 - 1,981,235 23,454,863 - (57) 57 - - - 525 1,982,953 23,604,473 2,265,262 9,763,803 21,754,356 525 1,982,953 23,604,473 2,264,737 7,780,850 (1,850,118) Starting Fund Balance 745,997 745,997 Net Change (305,500) 7,780,850 Ending Fund Balance 440,497 8,526,847 EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND Totals (305,500) Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS 14,125,637 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 14,431,137 EXPENSE Services and Supplies 120,250 Debt Service 14,310,887 Other Revenue - Interest Income 1,500 REVENUE TOTALS 14,125,637 Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,244,144 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 19 of 35 July YTD 2016 2017 2017 Actuals 47,950 334,486 533,105 50,000 81,500 282,307 0 2 374 97,950 415,987 815,787 18,116 305,821 679,056 - - - - - - - - - 53 531 693 - - - 5,000 35,000 107,500 23,168 341,352 787,249 97,950 415,987 815,787 23,168 341,352 787,249 74,781 74,635 28,537 Starting Fund Balance (84) (84) Net Change (13,200) 74,635 Ending Fund Balance (13,284) 74,551 Fund 330 - HOWARD-RIDGE TIF FUND (13,200) Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 1,585,400 EXPENSE TOTALS 1,598,600 Interfund Transfers 60,000 EXPENSE TOTALS 1,598,600 Community Sponsored Organizations - Debt Service 600 Miscellaneous - Services and Supplies 538,000 Capital Outlay 1,000,000 Insurance and Other Chargebacks - Interest Income 400 REVENUE TOTALS 1,585,400 EXPENSE Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 555,000 Other Revenue 1,030,000 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 20 of 35 July YTD 2016 2017 2017 Actuals 16,059 16,059 - 1,028 7,198 11,311 342 1,780 1,684 17,429 25,037 12,995 - - 507 - - (1,028) - - - - - - 647 6,532 8,519 - - - 2,500 17,500 30,000 3,147 24,032 37,998 17,428.73 25,036.79 12,994.87 3,147 24,032 37,998 14,281 1,005 (25,003) Starting Fund Balance 417,260 417,260 Net Change (39,850) 1,005 Ending Fund Balance 377,410 418,265 Fund 335 - WEST EVANSTON TIF FUND (39,850) Fund 335 - WEST EVANSTON TIF FUND REVENUE TOTALS 150.00 EXPENSE TOTALS 40,000 Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Contingencies - Debt Service 10,000 Miscellaneous - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Interest Income 150 REVENUE TOTALS 150 EXPENSE Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 21 of 35 July YTD 2016 2017 2017 Actuals - - - - - - - - - - - 971 - - - 2,158 39,268 28,444 2,158 39,268 29,415 - - - 2,158 39,268 29,415 (2,158) (39,268) (29,415) Starting Fund Balance (29,415) (29,415) Net Change - (39,268) Ending Fund Balance (29,415) (68,683) EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND 10,000 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE TOTALS 50,000 Capital Outlay - Debt Service 40,000 EXPENSE TOTALS 40,000 REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 22 of 35 July YTD 2016 2017 2017 Actuals - - - - 520,000 1,580,000 - 520,000 1,580,000 - - 437 - 580,000 1,740,000 - 14,030 16,556 - 594,030 1,756,993 - 520,000 1,580,000 - 594,030 1,756,993 - (74,030) (176,993) Starting Fund Balance 135,077 135,077 Net Change (60,000) (74,030) Ending Fund Balance 75,077 61,047 EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals (60,000) Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS - Capital Outlay - Debt Service 60,000 EXPENSE TOTALS 60,000 REVENUE TOTALS - EXPENSE Services and Supplies - Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes - Other Revenue - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 23 of 35 July YTD 2016 2017 2017 Actuals 36,064 153,261 223,296 - 2 2 36,064 153,264 223,298 - 116,356 145,003 - - - - 116,356 145,003 36,064 153,264 223,298 - 116,356 145,003 36,064 36,908 78,294 Starting Fund Balance 78,294 78,294 Net Change 500 36,908 Ending Fund Balance 78,794 115,202 Fund 350 - SPECIAL SERVICE AREA (SSA) 500 Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 220,500 EXPENSE TOTALS 220,000 Interfund Transfers - EXPENSE TOTALS 220,000 REVENUE TOTALS 220,500 EXPENSE Services and Supplies 220,000 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 220,000 Interest Income 500 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 24 of 35 July YTD 2016 2017 2017 Actuals - 359,706 - - 33,339 96,586 41,667 291,667 5,514,054 - 1,254 1,527,914 3,143 23,203 9,591,988 4,165 24,501 16,690 48,975 733,669 16,747,233 - - - 177,287 806,318 1,320,475 710,788 3,070,345 8,948,635 - - - - - - 41,667 291,667 490,000 929,742 4,168,330 10,759,111 48,975 733,669 16,747,233 929,742 4,168,330 10,759,111 (880,768) (3,434,661) 5,988,122 Starting Fund Balance 11,505,164 11,505,164 Net Change (8,583,512) (3,434,661) Ending Fund Balance 2,921,652 8,070,503 REVENUE TOTALS 21,925,000 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS (8,583,512) EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS Debt Service - Miscellaneous - Interfund Transfers 500,000 Salary and Benefits - Services and Supplies - Capital Outlay 30,008,512 Interest Income - REVENUE TOTALS 21,925,000 EXPENSE Interfund Transfers 7,710,000 Intergovernmental Revenue 1,920,000 Other Revenue 12,295,000 Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Licenses, Permits and Fees - Charges for Services - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 25 of 35 July YTD 2016 2017 2017 Actuals - - - - - - - - - - - - - - - - - - - - - - - 513,349 - - - - - - - - - 2,625 20,133 29,661 9,662 186,627 142,874 - - - 12,287 206,760 685,884 - - - - - 8,751 - - - - - - - - - - - - 21,952 153,666 360,698 21,952 153,666 369,449 12,287 206,760 685,884 21,952 153,666 369,449 (9,665) 53,094 316,435 Starting Fund Balance 2,999,216 2,999,216 Net Change (32,227) 53,094 Ending Fund Balance 2,966,989 3,052,310 REVENUE TOTALS 481,200 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND (32,227) EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND Debt Service - Miscellaneous - Interfund Transfers 513,427 Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 481,200 EXPENSE Salary and Benefits - Interest Income 51,033 Special Assessment 180,167 Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 26 of 35 July YTD 2016 2017 2017 Actuals - - - - - - 300 1,850 3,350 - - - (325,371) 3,091,842 6,509,492 - 2,060,318 3,711,768 - - - 19,490 122,733 195,895 5,549 28,073 38,159 (300,033) 5,304,816 10,458,663 100,362 665,680 1,462,702 231,429 1,858,591 3,084,543 321,739 948,172 (24,598) 46,180 309,183 504,784 .00 .00 .00 - - 2,836,672 - 2,222 5,910 - 141,632 390,235 11,717 148,409 255,626 106,224 743,565 1,303,783 817,650 4,817,453 9,819,656 (300,033) 5,304,816 10,458,663 817,650 4,817,453 9,819,656 (1,117,683) 487,362 639,007 Starting Fund Balance 7,752,664 7,752,664 Net Change (3,350,830) 487,362 Ending Fund Balance 4,401,834 8,240,026 Fund 505 - PARKING SYSTEM FUND Totals (3,350,830) Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 11,173,922 EXPENSE TOTALS 14,524,752 Interfund Transfers 1,584,683 EXPENSE TOTALS 14,524,752 Contingencies 11,000 Debt Service 4,331,771 Miscellaneous 304,000 Insurance and Other Chargebacks 524,102 Community Sponsored Organizations .00 Depreciation Expense - Salary and Benefits 1,247,921 Services and Supplies 3,501,275 Capital Outlay 3,020,000 Interest Income 35,070 REVENUE TOTALS 11,173,922 EXPENSE Interfund Transfers 4,120,636 Intergovernmental Revenue 12,125 Other Revenue 203,216 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,802,875 Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 27 of 35 July YTD 2016 2017 2017 Actuals - - - 6,631 54,264 90,592 1,572,934 9,721,589 16,071,271 - - - - - - 5,514 628,004 306,143 2,469 17,381 16,536 16,484,543 358,624 2,606,991 4,980,085 244,967 1,451,206 2,620,877 637,711 1,321,961 36,713 97,458 666,269 1,110,835 - - - - - 1,973,593 .00 .00 1,000.00 - 421,769 633,708 - - 238,468 291,859 2,043,016 3,502,313 1,630,619 8,511,212 15,097,592 1,587,548 10,421,237 16,484,543 1,630,619 8,511,212 15,097,592 (43,070) 1,910,026 1,386,951 Starting Fund Balance 7,536,078 7,536,078 Net Change (4,966,507) 1,910,026 Ending Fund Balance 2,569,571 9,446,104 10,421,237 EXPENSE TOTALS 29,361,507 Fund 510 - WATER FUND Totals (4,966,507) 1,587,548 Fund 510 - WATER FUND Totals REVENUE TOTALS 24,395,000 Miscellaneous 62,980 Interfund Transfers 3,502,313 EXPENSE TOTALS 29,361,507 Depreciation Expense - Contingencies 1,000.00 Debt Service 1,438,470 Capital Outlay 14,982,119 Insurance and Other Chargebacks 1,174,064 Community Sponsored Organizations - EXPENSE Salary and Benefits 4,589,411 Services and Supplies 3,611,150 Other Revenue 6,828,400 Interest Income 1,600 REVENUE TOTALS 24,395,000 Charges for Services 17,495,000 Interfund Transfers - Intergovernmental Revenue - Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 28 of 35 July YTD 2016 2017 2017 Actuals 935,715 7,509,790 13,048,760 - - - - - 3,087 665 4,976 4,450 936,380 7,514,767 13,056,297 78,134 554,397 1,104,448 54,446 123,299 157,551 2,884 729,138 15,370 35,555 249,576 414,270 - - 3,461,103 - - - 364,699 4,222,025 1,336,366 - - 5,000 82,640 578,478 773,873 618,357 6,456,914 7,267,980 936,380 7,514,767 13,056,297 618,357 6,456,914 7,267,980 318,023 1,057,853 5,788,316 Starting Fund Balance 4,612,098 4,612,098 Net Change (1,480,742) 1,057,853 Ending Fund Balance 3,131,356 5,669,951 Fund 515 - SEWER FUND Totals (1,480,742) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,126,315 EXPENSE TOTALS 14,607,057 Interfund Transfers 991,677 EXPENSE TOTALS 14,607,057 Contingencies - Debt Service 8,370,946 Miscellaneous 1,500 Capital Outlay 2,819,700 Insurance and Other Chargebacks 432,953 Depreciation Expense - EXPENSE Salary and Benefits 989,481 Services and Supplies 1,000,800 Other Revenue 604,165 Interest Income 1,000 REVENUE TOTALS 13,126,315 Fund 515 - SEWER FUND REVENUE Charges for Services 12,521,150 Interfund Transfers - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 29 of 35 July YTD 2016 2017 2017 Actuals - 83,374 170,144 296,853 2,089,471 3,586,453 87,997 615,981 1,055,967 - - - 14,007 56,707 274,808 - - - 398,857 2,845,532 5,087,372 51,267 372,450 815,166 105,400 1,738,960 3,493,078 2,736 13,386 6,034 8,749 67,731 138,618 - - - - - - - - - .00 919.68 2,250.59 - 2,232 12,232 42,067 294,471 499,493 210,220 2,490,149 4,966,872 398,857 2,845,532 5,087,372 210,220 2,490,149 4,966,872 188,637 355,382 120,500 Starting Fund Balance (972,783) (972,783) Net Change 3,016 355,382 Ending Fund Balance (969,767) (617,401) Fund 520 - SOLID WASTE FUND Totals 3,016 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,198,345 Interfund Transfers 504,807 EXPENSE TOTALS 5,198,345 Contingencies - Debt Service 21,046.00 Miscellaneous 15,000 Insurance and Other Chargebacks 149,325 Community Sponsored Organizations - Depreciation Expense - Salary and Benefits 750,241 Services and Supplies 3,732,176 Capital Outlay 25,750 Interest Income - REVENUE TOTALS 5,201,361 EXPENSE Interfund Transfers 1,055,967 Intergovernmental Revenue - Other Revenue 238,000 Fund 520 - SOLID WASTE FUND REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 30 of 35 July YTD 2016 2017 2017 Actuals 283,620 1,985,337 3,387,680 - - - - - - 612 11,416 14,415 - - - 284,231 1,996,753 3,402,094 74,104 536,087 897,673 173,885 1,067,888 1,912,423 - - - 16,085 106,904 167,952 - - 44 - - - - - - - - - 2,319.42 16,235.94 26,761.92 266,393 1,727,116 3,004,854 284,231 1,996,753 3,402,094 266,393 1,727,116 3,004,854 17,838 269,637 397,241 Starting Fund Balance 762,744 762,744 Net Change (248,021) 269,637 Ending Fund Balance 514,723 1,032,381 EXPENSE TOTALS 3,719,237 Fund 600 - FLEET SERVICES FUND Totals (248,021) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,471,216 Miscellaneous - Interfund Transfers 27,833.00 EXPENSE TOTALS 3,719,237 Depreciation Expense - Contingencies 450 Debt Service - Services and Supplies 2,380,057 Capital Outlay - Insurance and Other Chargebacks 239,630 REVENUE TOTALS 3,471,216 EXPENSE Salary and Benefits 1,071,267 Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,388,435 Interfund Transfers - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 31 of 35 July YTD 2016 2017 2017 Actuals 129,171 904,200 1,455,172 - - - - 45,994 63,430 129,171 950,193 1,518,602 3,570 47,660 102,765 4,294 277,416 - - - 1,624,064 - - - 7,863 325,077 1,726,829 129,171 950,193 1,518,602 7,863 325,077 1,726,829 121,308 625,117 (208,226) Starting Fund Balance 885,333 885,333 Net Change 229,853 625,117 Ending Fund Balance 1,115,186 1,510,450 Fund 601 - EQUIPMENT REPLACEMENT 229,853 Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,760,275 EXPENSE TOTALS 1,530,422 Miscellaneous - EXPENSE TOTALS 1,530,422 Services and Supplies 75,000 Capital Outlay 1,455,422 Depreciation Expense - Other Revenue 210,217 REVENUE TOTALS 1,760,275 EXPENSE Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,550,058 Interfund Transfers - Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 32 of 35 July YTD 2016 2017 2017 Actuals 13,534 94,740 441,246 68 478 - 909,669 6,120,362 9,995,502 85,868 635,840 89,822 342,466 3,207,376 6,546,063 36 163 218 1,351,641 10,058,958 17,072,851 47,974 311,852 448,109 57,094 643,768 4,704,399 - - - 1,378,041 9,456,983 14,539,279 - - - - - - - - - - - - - - 4,330 803 5,619 9,262 1,483,912 10,418,223 19,705,379 1,351,641 10,058,958 17,072,851 1,483,912 10,418,223 19,705,379 (132,271) (359,264) (2,632,528) Starting Fund Balance (2,997,025) (2,997,025) Net Change (224,815) (359,264) Ending Fund Balance (3,221,840) (3,356,289) Fund 605 - INSURANCE FUND Totals (224,815) Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 18,850,796 EXPENSE TOTALS 19,075,611 Interfund Transfers 9,632 EXPENSE TOTALS 19,075,611 Contingencies - Debt Service - Miscellaneous - Insurance and Other Chargebacks 16,146,290 Community Sponsored Organizations - Depreciation Expense - Salary and Benefits 534,441 Services and Supplies 2,385,248 Capital Outlay - Interest Income 1,000 REVENUE TOTALS 18,850,796 EXPENSE Other Revenue 11,237,646 Workers Compensation and Liability 1,030,815 Insurance 6,413,937 Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 4,987 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 33 of 35 July YTD 2016 2017 2017 Actuals - - - - - - - - - 3,891,742 12,138,057 10,902,978 43,682 768,684 1,559,737 3,935,424 12,906,740 12,462,715 725,145 5,030,486 8,429,695 - - - - - - - - - 21,226 68,338 174,111 746,371 5,098,824 8,603,806 3,935,424 12,906,740 12,462,715 746,371 5,098,824 8,603,806 3,189,053 7,807,916 3,858,910 Starting Fund Balance 70,599,998 70,599,998 Net Change 4,636,709 7,807,916 Ending Fund Balance 75,236,707 78,407,914 Fund 700 - FIRE PENSION FUND Totals 4,636,709 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 13,341,709 EXPENSE TOTALS 8,705,000 Miscellaneous - EXPENSE TOTALS 8,705,000 Services and Supplies - Community Sponsored Organizations - Debt Service - REVENUE TOTALS 13,341,709 EXPENSE Salary and Benefits 8,705,000 Interfund Transfers 43,000 Other Revenue 1,050,000 Interest Income 4,100,000 Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,868,709 Other Taxes 280,000 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 34 of 35 July YTD 2016 2017 2017 Actuals - - - - - - - - - 3,619,523 15,009,267 16,286,867 132,079 1,553,880 2,713,348 3,751,602 16,563,147 19,000,215 955,473 6,643,485 11,094,711 - - - - - - 41,479 153,908 272,795 996,952 6,797,393 11,367,506 3,751,602 16,563,147 19,000,215 996,952 6,797,393 11,367,506 2,754,650 9,765,754 7,632,708 Starting Fund Balance 106,191,545 106,191,545 Net Change 6,627,200 9,765,754 Ending Fund Balance 112,818,745 115,957,299 REVENUE TOTALS 18,444,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals 6,627,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals Services and Supplies - Debt Service - Miscellaneous - REVENUE TOTALS 18,444,200 EXPENSE Salary and Benefits 11,817,000 Interfund Transfers 57,000 Other Revenue 1,650,000 Interest Income 6,500,000 Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,912,200 Other Taxes 325,000 Budget by Organization Report Through 07/31/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Run by Kate LewisLakin on 08/28/2017 09:52:49 AM Page 35 of 35