Loading...
HomeMy WebLinkAboutItem 4.16 FinRept May 2001 CITY CLERK File # 330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (June 19, 2001) SUBJECT: Financial Report For the Month of May 2001 Report Prepared by: Carole Perry, Administrative Services Director and Fred Marsh, Finance Manager ATTACHMENTS: 1. YTD Revenues and Budget Comparison 2. YTD Expenses and Budget Comparison 3. Financial Statements for the Month of May 2001 RECOMMENDATION:~I~ Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the preliminary financial statements for the month of May 2001. Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Analysis of May 2001 Revenue and Expenditure Report The May report represents the reporting of revenues and expenditures for the first eleven months of the Fiscal Year. It should be' noted that there is not an even distribution of revenues and expenditures on a monthly basis. For example, the expenditures for major contracts such as Police and Fire Services lag since the City is billed on a quarterly basis. A more detailed analysis of General Fund Revenue and Expenditures is shown on the attached reports and discussed below. General Fund Revenues Total General Fund Revenues collected through May are higher than what occurred in the eleventh month of the previous Fiscal Year. The City had collected through May 2001 approximately 100% of the total budgeted General Fund Revenues compared to approximately 83% in the prior Fiscal Year. Property Taxes are higher than in the same period of the prior year as the assessed valuation increased over the prior year, primarily due to the sales of properties and additions of several commercial and residential developments during the past year in Eastem Dublin. Sales Tax is higher than in the same period of the prior year. The State has raised the amount of monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily related to tax collections from motor vehicle sales. Real Property Transfer Tax is higher than the same period of the prior year due to increased sales of residential and commercial properties within the City. Transient Occupancy Taxes are higher than in the same period in the prior year due to higher room rates and higher than expected occupancy rates. COPIES TO: 4~~ Franchise Taxes are higher than in the same period in the prior year due to an increase in cable rates that occurred during the year as well as a larger than expected increase in the number of new residential customers in Eastern Dublin. Licenses and Permits are higher than in the same period in the prior year due to an increase in the valuation of building permits issued during the first eleven months of Fiscal Year 2000/2001. The data presented regarding Interest and Rental revenue is somewhat skewed in the current report as a portion of the interest earnings reported in the General Fund still needs to be allocated to all of the City's funds on a pro rata basis. This allocation will be done prior to the year end closing. In addition, the City has more cash available in the first eleven months of the year than was assumed in the budget calculations. Intergovernmental Revenue is higher than in the same period of the prior year due to an increase in the allocation of State Motor Vehicle In Lieu Fees and an increase in the amount of the ERAF repayment from the State. Charges for Services are higher than in the same period of the prior year as there were delays that occurred on some development projects during the same time period in the prior year, resulting in lower than expected year to date revenue for engineering plan checking services in the prior year. The amount of revenue recorded is based upon the payments made to date to outside contractors for these services. Fines and Forfeitures is higher than the prior year due to an increase in the number of traffic citations issued over the prior year. Other Revenue is lower than the same period in the prior year, as the City has not yet received any reimbursements from PG&E for the Dublin Boulevard Underground Utilities project. General Fund Ex!~enditures Overall, through the month of May expenditures in the General Fund totaled $16,716,661 and represented approximately 67% of the total budgeted expenditures in the General Fund. Of this amount, a total of $1,036,938 was related to Capital Improvement Projects and the remainder was related to Operating Costs reported in the General Fund. Capital Project expenditures typically do not follow an even distribution due to differences in project timing. In looking at only General Fund Operating Expenditures, the activity through May 2001 was lower than the amounts expended for the same period in the prior Fiscal Year. As of May 2001, the City had expended 59% of the General Fund Operating Budget compared to 72% in the prior Fiscal Year. As previously noted there are some timing differences with payment for contract services which complicate comparisons between one year to the next. General Govemmental is lower than in the prior year as the amount budgeted for technical support for "Computers for Our Schools" has not yet been spent. Police Services are lower than in the prior year due to timing differences in payments for contract police services. Other Public Safety is lower than in the prior year due to timing differences in payments for contract animal control services. Culture and Leisure Services are lower than in the same period of the prior year due to lower than expected personnel expense to date for Recreation Administration and Playgrounds, and timing differences in payments for contract services in the Special Events and Shannon Center events divisions. Community Development is lower than in the same period of the prior year due to timing differences in the payment of development related contract services in the Engineering division. Capital Improvement Project expenditures are lower than in the same period of the prior year as several of the capital projects funded by the General Fund in Fiscal Year 2000-2001 will not incur major expenditures until later in the Fiscal Year, including the DUSD Technology Project, Civic Center Library, there may be a delay in the Dublin Boulevard Undergrounding project due to a delay in the receipt of reimbursement funds. All expenditures to date are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. For the Period Ending May 31, 2001 Total General Fund Revenues I 181% 100% I I Property Taxes .90 % 111% Sales Taxes 97% · FY 2000/2001 Real Property Transfer Tax ~ FY 1999/2000 Transient Occupancy Taxes 93% Franchise Taxes 102% Licenses and Permits Interest and Rentals 137% Intergovernmental from State Charges for Services 91% Fines and Forfeitures 129% Other Revenues 0% 30% 60% 90% 120% 150% 92% of Year Complete FY 2000/2001 FY 2000/2001 % of FY 99~00 % of Total for Budget YTD Actual Budget YTD Actual FY 99~00 Property Taxes 6,168,350 6,874,391 111% 5,403,434 90% Sales Taxes 11,300,000 10,992,071 97% 8,872,201 77% Real Property Transfer Tax 288,000 527,437 183% 305,889 82% Transient Occupancy Taxes 910,000 841,921 93% 585,867 72% Franchise Taxes 1,017,840 1,038,653 102% 862,597 90% Licenses and Permits 3,124,088 2,911,043 93% 3,444,777 88% Interest and Rentals 1,513,259 2,077,246 137% 1,583,284 118% Intergovernmental 1,813,500 1,793,832 99% 1,449,505 89% Charges for Services 3,434,158 3,128,488 91% 2,355,666 71% Fines and Forfeitures 68,755 88,933 129% 65,620 78% Other Revenues 2,935,654 2,340,944 80% 661,484 91% Total General Fund Revenues 32,573,604 32,614,959 100% 25,590,325 83% ~. /~ ~l/~lD / City of Dublin 2000-2001 YTD Expenses and Budget Comparison For the Period Ending May 31, 2001 ] i Total General Fund Expenses 72% General Government % 81% Police 73% 171% Fire 52% Other Public Safety 72% [] FY 2000/2001 I% · FY 1999~2000 Transportation 82% Health and Welfare Culture & Community Services 102% Community Development 94% Capital Improv. Projects 84% 0% 20% 40% 60% 80% 100% 92% of Year Complete FY 2000/2001 FY 200012001 % of FY 99~00 % of Total for Budget YTD Actual Budget YTD Actual FY 99~00 General Government 3,067,557 2,362,193 77% 1,848,283 81% Police 6,125,924 2,892,585 47% 3,720,782 73% F ire 4,448,831 3, 161,560 71% 2, 187,661 52% Other Public Safety 283,619 114,263 40% 138,025 72% Transportation 960,383 751,942 78% 634,891 82% Health and Welfare 19,390 9,993 52% 7,963 47% Culture and Community Services 3,473,609 2,592,587 75% 2,287,821 102% Community Development 4,894,262 3,794,601 78% 3,405,030 94% Capital Improvement Projects 5,095,724 1,036,938 20% 1,490,204 84% Total General Fund Expenses 28,369,299 16,716,661 59% 15,720,661 72% General Fund Operating Expenses 23,273,575 15,679,723 67% 14,230,457 73% CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MAY 2001 Prepared by The Finance Department June 7, 2001 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2001 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUND FUND CURRENT PRIOR ASSETS CASH (32,089,396) 2,507°493 462,862 26,874,025 144,208 (2,100,807) (10,431,784) CASH WITH FISCAL AGENT 161,931 161,931 157,925 AMOUNT HELD IN ESCROW 515,300 515,300 4,267,787 INVESTMENTS AT COST 74,489,745 74,489,745 49,227,117 RECEIVABLES: TAXES ACCOUNTS (NE 149,497 20,646 170,143 2,365,857 INTEREST 302,286 302,286 718,499 ASSESSMENTS DUE FROM OTHERS 4,143 (114) 4,029 61,210 INVENTORY AT COST PREPAID ITEMS 6,817 6,817 13,144 FIXED ASSETS AMOUNT TO BE PROVIDED 1,745,500 1,745,500 1,745,500 TOTAL ASSETS 42,863,092 2,528,025 462,862 27,389,325 2,051,639 75,294,943 48,125,255 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL (806,805) (806,805) (663,000) DEPOSITS FOR AB1600 FEES (60,908) (33,356,290) (33,417,199) (12,455,564) DEPOSITS OTHERS (470,268) (470,268) (354,683) PAYABLES: ACCOUNTS (152,833) (35,803) (16,961) (205,596) (4,536,975) INTEREST PAYROLL (268,459) (268,459) (446,756) DUE TO OTHERS (144,216) (144,216) (233,477) DEFERRED REVENUE (149,497) (4,143) (153,640) (153,640) DEBT INSTRUMENTS PAYABLE (1,863,000) (1,863,000) (1,863,000) TOTAL LIABILITIES (2,052,986) (35,803) (33,377,394) (1,863,000) (37,329,184) (20,707,095) FUND BALANCES (40,810,106) (2,492,222) (462,862) 5,988,069 (188,639) (37,965,760) (27,418,160) TOTAL FUND E (40,810,106) (2,492,222) (462,862) 5,988,069 (188,639) (37,965,760) (27,418,160) TOTAL LIAB. FND BAL. RETD (42,863,092) (2,528,025) (462,862) (27,389,325) (2,051,639) (75,294,943) (48,125,255) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2001 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S SERVICE FUNDS GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 2.617.967 2.617.967 2.384.683 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 21.105.766 8,626.020 29.731.786 29,731.786 AMOUNT TO BE PROVIDED 48.187.180 48.187,180 48.653.563 TOTAL ASSETS 23.723.733 8.626.020 48.187.180 80.536,934 80.770.032 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (1) (1) (6.353) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (48.187,180) (48,187,180) (48.653.563) TOTAL LIABILITIES (1) (48.187,180) (48,187.181) (48.659.916 FUND BALANCES (23.723.733) (8.626.020) (32.349,753) (32.110.116 TOTAL FUND E (23.723.733) (8.626.020) (32.349,753) (32,110,116 TOTAL LIAB. FND BAL. RETD (23,723,733) (8.626,020) (48.187.180) (80,536.934) (80.770.032 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 05/31/2001 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 6,168 350.00 6,874,390.92 (706,040.92) 5,991,813.80 5,403,433.77 588 380.03 SALES TAX 11.300 000.00 10,992,071.27 307.928.73 11,548,901.00 8,872,201.27 2.676 699.73 REAL PROPERTY TRANSFER TAX 288 000.00 527,437.37 (239.437.37) 370,945.99 305,888.83 65 057.16 HOTEL TRANSIENT OCCUPANCY TAX 910 000.00 841,920.51 68,079.49 808,688.14 585,867.42 222 820.72 FRANCHISE TAXES 1,017 840.00 1,038,653.17 (20,813.17) 963,069.84 862,596.84 100 473.00 LICENSES & PERMITS 3,124 088.00 2,911,043.37 213,044.63 3,897,965.22 3,444,776.96 453 188.26 FINES & FORFEITURES 68 755.00 88.932.74 (20,177.74) 84,542.77 65,620.28 18 922.49 USE/MONEY & PROP-INTEREST 1,411 205.00 1,990,643.83 (579,438.83) 1,254,906.26 1,514,463.60 (259,557.34) USE/MONEY & PROP-RENTALS 102 054.00 86,601.97 15,452.03 85,831.12 68,820.58 i7.010.54 INTERGOVERNMENTAL FROM STATE 1,813 500.00 1.793.831.51 19,668.49 1,629,846.86 1.449,505.02 180,341.84 INTERGOVERNMENTAL FROM COUNTY 2,594.33 2,594.33 CHARGES FOR SERVICES 3,434,158.00 3,128,488.41 305,669.59 3.308,263.42 2.355,666.30 952,597.12 OTHER SOURCES OF REVENUE 2,935,654.00 2,340,943.74 594.710.26 726,524.45 661,483.98 65,040.47 TOTAL REVENUE 32,573,604.00 32,614,958.81 (41,354.81) 30,673,893.20 25,590,324.85 5,083,568.35 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 177905.00 137,740.70 40,164.30 144,214.76 128 437.68 15,777.08 CITY MANAGER 445805.00 385,909.94 59,895.06 368,092.08 314 627.83 53,464.25 CENT~L SERVICES 250000.00 213,537.73 36,462.27 202,489.29 168 137.33 34,351.96 CITY ATTORNEY 407 882.00 392,898.58 14,983.42 301,446.94 225 292.99 76,153.95 ADMIN SERVICES 889 601.00 639,013.21 250,587.79 606,030.20 511 986.75 94,043.45 BUILDING MANAGEMENT 516 021.00 421,802.06 94,218.94 482,597.30 364 460.11 118,137.19 INSURANCE COST CENTER 245 493.00 159,277.11 86,215.89 169,061.86 134 413.49 34,648.37 ELECTIONS COST CENTER 7,350.00 12,013.21 (4,663.21) 904.34 849.00 55.34 NON-DEPARTMENTAL 127,500.00 127,500.00 77.83 77.83 ACTIVITY TOTAL 3,067,557.00 2,362,192.54 705,364.46 2,274,914.60 1,848,283.01 426,631.59 PUBLIC SAFETY POLICE 6,125,924.00 2,892,585.20 3,233,338.80 5,106,215.64 3,720,782.28 1,385,433.36 CROSSING GUARDS 63,760.00 37,929.38 25,830.62 47,608.15 36,678.00 10,930.i5 ANIMAL CONTROL 177,595.00 38,868.24 138,726.76 107,720.18 68,017.18 39,703.00 DISASTER PREPAREDNESS 42,264.00 37,465.59 4,798.41 37,094.46 33,330.09 3,764.37 FIRE SERVICES 4,448,831.00 3,161,559.50 1,287,271.50 4,186,527.66 2,187,661.23 1,998,866.43 ACTIVITY TOTAL 10,858,374.00 6,168,407.91 4,689,966.09 9,485,166.09 6,046,468.78 3,438,697.31 TRANSPORTATION PUBLIC WORKS 508,071.00 430,901.00 77,170.00 406,083.23 343,869.94 62,213.29 STREET MAINTENANCE 861.00 79.88 781.12 11,513.70 26.10 11,487.60 STREET SWEEPING 107,031.00 79,752.13 27,278.87 82,440.23 70,149.72 12,290.51 STREET TREE MAINTENANCE 45,768.00 36,870.01 8,897.99 40,288.40 27,095.69 13,192.71 STREET LANDSCAPING MAINTENAN 298,652.00 204,338.59 94,313.41 286,816.64 193,749.46 93,067.18 ACTIVITY TOTAL 960,383.00 751,941.61 208,441.39 827,142.20 634,890.91 192,251.29 HEALTH & WELFARE THE CITY OF DUBLIN STATEMENT SHOWING ~ ( REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 05/31/2001 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE WASTE MANAGEMENT 7,390.00 1,469.88 5,920.12 7,085.81 2,822.28 4,263.53 CHILD CARE 12,000.00 8,523.00 3,477.00 12,000.00 5,140.77 6,859.23 ACTIVITY TOTAL 19,390.00 9,992.88 9,397.12 19,085.81 7,963.05 11,122.76 CULTURE & LEISURE SERVICES LIB~RY SERVICES 362 922.00 272,191.50 90,730.50 342,557.00 342,557.00 CULTUP-J~L ACTIVITIES 55 408.00 46,307.59 9,100.41 53,367.37 34 279.74 19,087.63 HERITAGE CENTER 67 861.00 53,088.33 14,772.67 56,071.79 46 202.59 9,869.20 DUBLIN CEMETERY 33 337.00 29,608.05 3,728.95 30,225.33 20 957.97 9,267.36 PARK MAINTENANCE 863 907.00 580,818.64 283,088.36 633,590.64 403 674.65 229,915.99 COMMUNITY TV 69 852.00 61,304.35 8,547.65 66,950.70 62 661.19 4,289.51 RECREATION ADMIN 312 313.00 260,945.94 51,367.06 269,725,81 235 879.49 33,846.32 PLAYGROUNDS 213 209.00 154,378.68 58,830.32 145,380.76 120 584.65 24,796.11 SHANNON CENTER 233 841.00 185,329.35 48,511.65 195,927.57 157 235.90 38,691.67 PRESCHOOL 55 790.00 47,780.38 8,009.62 47,479.90 41 318.86 6,161.04 TEENS PROGRAM 105 053.00 79,840.12 25,212.88 75,134.57 56 230.74 18,903.83 ADULT SPORTS 76562.00 53,686.48 22,875.52 63,823.38 46 916.37 16,907.01 YOUTH SPORTS 75044.00 65,279.44 9,764.56 67,900.31 62 918.34 4,981.97 COMMUNITY GYM 34035.00 15,778.42 18,256.58 28,795.78 13 865.38 14,930.40 SPECIAL EVENTS 265 144.00 180,705.28 84,438.72 218,102.49 210 711.82 7,390.67 SENIOR CENTER 145 236.00 116,811.22 28,424.78 115,715.37 98 870.43 16,844.94 RECREATION INSTRUCTION 129 585.00 95,471.99 34,113.01 102,256.75 84,369.56 17,887.19 AQUATICS 278 195.00 209,669.91 68,525.09 228,879.72 175,322.59 53,557.13 PARKS/FACILITIES MANAGEMENT 96,315.00 83,591.54 12,723.46 85,735.46 73,263.95 12,471.51 ACTIVITY TOTAL 3,473,609.00 2,592,587.21 881,021.79 2,827,620.70 2,287,821.22 539,799.48 COMMUNITY DEVELOPMENT PLANNING 1,376,095.00 1,112,321.45 263,773.55 1,252,774.61 1,054,094.08 198,680.53 BUILDING SAFETY 1,401,919.00 1,090,771.15 311,147.85 1,144,717.07 863,716.45 281,000.62 ENGINEERING 1,816,058.00 1,353,272.81 462,785.19 1,462,847.69 1,187,772.79 275,074.90 ECONOMIC DEVELOPMENT 300,190.00 238,235.67 61,954.33 255,690.44 299,446.60 (43,756.16) ACTIVITY TOTAL 4,894,262.00 3,794,601.08 1,099,660.92 4,116,029.81 3,405,029.92 710,999.89 CAPITAL IMPROVEMENT PROJECTS GENE~L CIP PROJECTS 2,646,604.00 341,145.33 2,305,458.67 1,297,739.34 843,195.87 454,543.47 COMMUNITY IMPROVEMENTS 381,901.00 131,465.57 250,435.43 234,272.83 182,358.70 51,914.13 PARKS 592,266.00 390,200.11 202,065.89 722,642.96 391,991.35 330,651.61 STREET CONSTRC/IMPROVEMENTS 1,474,953.00 174,127.15 1,300,825.85 111,551.69 72,658.32 38,893.37 ACTIVITY TOTAL 5,095,724.00 1,036,938.16 4,058,785.84 2,366,206.82 1,490,204.24 876,002.58 TOTAL EXPENDITURES 28,369,299.00 16,716,661.39 11,652,637.61 21,916,166.03 15,720,661.13 6,195,504.90 EXCESS REVENUE (EXPENDITURES) 4,204,305.00 15,898,297.42 (11,693,992.42) 8,757,727.17 9,869,663.72 (1,111,936.55) TRANSFERS IN FROM OTHER FUNDS 22,850.00 22,850.00 17,869.13 17,869.13 TRANSFERS OUT FROM OTHER FUNDS (2,400,010.00) (176.10) (2,399,833.90) (931,640.50) (931,640.50) REVENUES OVER(UNDER) EXPENDITURES 1,827,145.00 15,898,121.32 (14,070,976.32) 7,843,955.80 9,869,663.72 (2,025,707.92) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 04/30/2001 SPECIAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 82,850.00 75 000.93 7,849.07 78,715~14 72,296.16 6,418.98 SALES TAX/OTHER TAXES 194,000.00 199 323.12 (5,323.12) 192,662.02 170,958.78 21,703.24 FINES & FORFEITURES 89,475.00 102 831.20 (13,356.20) 113,370.96 79,410.15 33,960.81 USES/MONEY & PROPERTY 100,676.00 87 213.13 13,462.87 103,772.70 24,019.31 79,753.39 INTERGOVERNMENTAL FROM STATE 2,367,881.00 1,033 889.38 1,333,991.62 1,158,533.84 563,526.48 595,007.36 INTERGOVERNMENTAL FROM COUNTY 137,780.00 186 368.00 (48,588.00) 177,904.00 98,120.00 79,784.00 INTERGOVERNMENTAL FROM FEDERAL 1,026,394.00 93 840.87 932,553.13 87,679.67 27,554.07 60,125.60 CHARGES FOR SERVICES 763,302.00 714 741.38 48,560.62 733,208.99 676,015.01 57,193.98 OTHER SOURCES OF REVENUE 5,000.00 5 259.25 (259.25) 40,601.31 31,609.31 8,992.00 TOTAL REVENUE 4,767,358.00 2,498 467.26 2,268,890.74 2,686,448.63 1,743,509.27 942,939.36 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 210,840.00 87,578.30 123,261.70 88,258.42 75,073.92 13,184.50 TRAFFIC SIGNALS & STREET LTG 141,645.00 61,971.08 79,673.92 121,790.46 94,578.11 27,212.35 FIRE SERVICES 89,125.00 138,640.86 (49,515.86) 79,100.67 40,698.75 38,401.92 ACTIVITY TOTAL 441,610.00 288,190.24 153,419.76 289,I49.55 210,350.78 78,798.77 TRANSPORTATION: STREET MAINTENANCE 659,896.00 155,390.73 504,505.27 533,583.10 93,959.21 439,623.89 STREET SWEEPING ACTIVITY TOTAL 659,896.00 155,390.73 504',505.27 533,583.10 93,959.21 439,623.89 HEALTH & WELFARE: WASTE MANAGEMENT 1,I69,535.00 660,882.41 508,652.59 866,219.67 437,085.67 429,134.00 SENIOR SUPPORT CARE 7,500.00 5,625.00 1,875.00 HOUSING PROGRAMS lO,O00.O0 6,202.30 3,797.70 ACTIVITY TOTAL 1,187,035.00 672,709.71 514,325.29 866,219.67 437,085.'67 429,134.00 COMMUNITY DEVELOPMENT: ENGINEERING 6,000.00 4,999.00 1,OOl.O0 6,000.00 6,000.00 ACTIVITY TOTAL 6,000.00 4,999.00 1,OOi.O0 6,000.00 6,000.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 13,997.81 13,997.81 COMMUNITY PROJECTS 285,004.00 53,851.22 231,152.78 59,617.41 24,107.64 35,509.77 PARKS 8,820.00 8,820.00 20,517.41 12,569.66 7,947.75 STREET CONSTRUCTION/IMPROVEMENT 2,715,465.00 588,679.58 2,126,785.42 429,360.36 42,737.23 386,623.13 ACTIVITY TOTAL 3,009,289.00 642,530.80 2,366,758.20 523,492.99 79,414.53 444,078.46 T 0 T A L EXPENDITURES 5,303,830.00 1,763,820.48 3,540,009.52 2,218,445.31 826,810.19 1,391,635.12 EXCESS <REVENUE>EXPENDITURE 536,472.00 (734,646.78) 1,271,118.78 (468,003.32) (916,699.08) 448,695.76 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 22,850.00 22,850.00 17,869.13 17,869.13 EXCESS <REVENUE> EXPENDITURE 559,322.00 (734,646.78) 1,293,968.78 (450,134.19) (916,699.08) 466,564.89 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 05/31/2001 SPECIAL ASSESSMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 390,388.00 345,216.36 45,171.64 318,354.40 281,554.49 36,799.91 USES/MONEY & PROP-INTEREST 13,589.00 10,955.35 2,633.65 16,637.02 3,797.92 12,839.10 OTHER SOURCES OF REVENUE 6,000.00 2,300.37 3,699.63 668.85 668.85 TOTAL REVENUE 409,977.00 358,472.08 51,504.92 335,660.27 286,021.26 49,639.01 *******EXPENDITURES******* PUBLIC SAFETY: T~FFIC SIGNALS & STREET LIG 172,115.00 86,151.73 85,963.27 118,667.18 80,266.63 38,400.55 ACTIVITY TOTAL 172,115.00 86,151.73 85,963.27 118,667.18 80,266.63 38,400.55 T~NSPORTATION PUBLIC WORKS 4,480.00 1,874.00 2,606.00 3,613.20 2,730.02 883.18 STREET TREE MAINTENANCE 12,039.00 3,642.85 8,396.15 4,219.57 2,871.04 1,348.53 STREET LANDSCAPE MAINTENANCE 239,352.00 100,248.41 139,103.59 131,200.04 91,309.83 39,890.21 ACTIVITY TOTAL 255,871.00 105,765.26 150,105.74 139,032.81 96,910.89 42,121.92 HEALTH & WELFARE: ENGINEERING 4,760.00 8,550.38 (3,790.38) 4,495.98 4,336.86 159.12 ACTIVITY TOTAL 4,760.00 8,550.38 (3,790.38) 4,495.98 4,336.86 159.12 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 52,840.00 2,519.14 50,320.86 28,139.83 28,139.83 STREET CONSTRUCTION/IMPRVMNT 46,752.16 46,752.16 ACTIVITY TOTAL 52,840.00 2,519.14 50,320.86 74,891.99 46,752.16 28,139.83 T 0 T A L EXPENDITURES 485,586.00 202,986.51 282,599.49 337,087.96 228,266.54 108,821.42 EXCESS <REVENUE>EXPENDITURE 75,609.00 (155,485.57) 231,094.57 1,427.69 (57,754.72) 59,182.41 EXCESS <REVENUE>EXPENDITURE 75,609.00 (155,485.57) 231,094.57 1,427.69 (57,754.72) 59,182.41 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 05/31/2001 CAPITAL IMPROVEMENT FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST 789,214.44 (789,214.44) 196,773.67 (196,773.67) OTHER SOURCES OF REVENUE 19,244,416.75 19,244,416.75 10,337,149.24 10,337,149.24 TOTAL REVENUE: 19,244,416.75 789,214.44 18,455,202.31 10,337,149.24 196,773.67 10,140,375.57 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINIST~TION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING 37,834.00 28,319.15 9,514.85 12,389.68 8,514.68 3,875.00 ACTIVITY TOTAL 37,834.00 28,319.15 9,514.85 12,389.68 8,514.68 3,875.00 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1,747,473.75 672,210.52 1,075,263.23 1,859,640.67 1,476,155.84 383,484.83 COMMUNITY IMPROVEMENTS PARKS 1,412,999.00 18,854.85 1,394,144.15 6,057,184.37 5,772,766.80 284,417.57 STREET CONSTRUCTION/IMPROVEMENT 20,666,714.00 6,474,297.12 14,192,416.88 2,433,845.51 1,816,842.95 617,002.56 ACTIVITY TOTAL 23,827,186.75 7,165,362.49 16,661,824.26 10,350,670.55 9,065,765.59 1,284,904.96 T 0 T A L EXPENDITURES 23,865,020.75 7,193,681.64 16,671,339.11 10,363,060.23 9,074,280.27 1,288,779.96 EXCESS <REVENUE>EXPENDITURE 4,620,604.00 6,404,467.20 (1,783,863.20) 25,910.99 8,877,506.60 (8,851,595.61) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 4,620,604.00 6,404,467.20 (1,783,863.20) 25,910.99 8,877,506.60 (8,851,595.61) THE CITY OF DUBLIN STATEMENT SHOWING ~ REVENUES VERSUS EXPENDITURES ,// /"~ FOR THE PERIOD 07/01/2000 THROUGH 05/31/2001 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 206,511.07 (206,511.07) 233,189.54 203,042.46 30,147.08 USES/MONEY & PROP-INTEREST 5,939.51 (5,939.51) 13,281.66 5,575.23 7,706.43 TOTAL REVENUE 212,450.58 (212,450.58) 246,471.20 208,617.69 37,853.51 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 233,093.57 (233,093.57) 261,375.75 261,375.75 ACTIVITY TOTAL 233,093.57 (233,093.57) 261,375.75 261,375.75 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 233,093.57 (233,093.57) 261,375.75 261,375.75 EXCESS <REVENUE>EXPENDITURE 20,642.99 (20,642.99) 14,904.55 52,758.06 (37,853.51) EXCESS <REVENUE>EXPENDITURE 20,642.99 (20,642.99) 14,904.55 52,758.06 (37,853.51) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2000 THROUGH 05/31/2001 INTERNAL SERVICE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 187,672.00 96,664.80 91,007.20 65,324.17 14,165.24 51,158.93 CHARGES FOR SERVICES 919,498.00 866,861.86 52,636.14 580,974.63 517,710.38 63,264.25 OTHER SOURCES OF REVENUE 17,000.00 17,000.00 42,214.73 42,214.73 TOTAL REVENUE 1,124,170.00 963,526.66' 160,643.34 688,513.53 574,090.35 114,423.18 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,019,738.00 435,996.14 583,741.86 865,319.44 211,770.88 653,548.56 ACTIVITY TOTAL 1,019,738.00 435,996.14 583,741.86 865,319.44 211,770.88 653,548.56 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 28,825.00 20,576.74 8,248.26 5,590.00 (5,590.00) T 0 T A L EXPENDITURES 1,048,563.00 486,578.11 561,984.89 865,319.44 217,360.88 647,958.56 EXCESS.<REVENUE>EXPENDITURE (75,607.00) (476,948.55) 401,341.55 176,805.91 (356,729.47) 533,535.38 TRANSFER IN FROM OTHER FUNDS 2,400,000.00 2,400,000.00 931,286.00 931,286.00 TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE (2,475,607.00) (476,948.55) (1,998,658.45) (754,480.09) (356,729.47) (397,750.62) THE CITY OF DUBLIN STATEMENT SHOWING FOR THE PERIOD 07/01/2000 THROUGH 05/31/2001 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 10.00 10.00 10.00 10.00 FINANCE 344.50 344.50 ACTIVITY TOTAL 10.00 10.00 354.50 354.50 PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 10.00 10.00 354.50 354.50 EXCESS <REVENUE>EXPENDITURE 10.00 10.00 354.50 354.50 TRANSFERS IN FROM OTHER FUNDS (10.00) (10.00) (354.50) (354.50) TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 354.50 (354.50)