HomeMy WebLinkAboutItem 4.03 FinRpt April2002 CITY CLERK
File # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: May 21, 2002
SUBJECT: Financial Reports For the Month of April 2002
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 April 2002
RECOMMENDATION: ~ Receive the reports.
FINANCIAL STATEMENT: See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the financial statements for the month of April.
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 April 2002 Revenue and Expenditure Report
The April report represents the reporting of revenues and expenditures for the first ten 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 April are lower than occurred in the ten months of the
previous Fiscal Year. The City had collected through April 2002 approximately 77% of the total budgeted
General Fund Revenues compared to approximately 82% in the prior Fiscal Year.
Real Property Transfer Tax is lower than in the same period of the prior year as the valuation from the
sales of new and existing residential properties in the City had dropped significantly in comparison to the
prior year. Transient Occupancy Tax is lower than in the same period of the prior year due to a decline in
occupancy rates for the City's hotels. Franchise Taxes are higher than in the same period of the prior year
due to higher than expected revenues from gas and electric franchise fees resulting from the significant
increase in gas and electric rates that occurred over the prior Fiscal Year.
Licenses and Permits are lower than in' the same period of the prior year due to a decline in the valuation
of building permits issued on new residential and commercial projects. Interest and RentalS are lower
COPIES TO:
G:~4onthly Financials\042002 agenda statement monthly financials'd°c ITEM'NO.~ - ~
than in the same period of the prior year due to a higher than expected drop in interest rates that has
occurred during the current Fiscal Year.
Fines and Forfeitures are higher than in the prior year due to an increase in the number of traffic citations
issued over the prior year. Other Revenue is lower than in the same period of the prior year due to a one
time contribution received from a developer in the prior Fiscal Year to assist with funding construction of
the City's new library.
General Fund Expenditures
Overall, through the month of April expenditures in the General Fund totaled $20.9 million and
represented approximately 58% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $4.7 million 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 only at General Fund Operating Expenditures, the activity through April 2002 was comparable
to the amounts expended for the same period in the prior Fiscal Year. Thru the end of April 2002, the
City had expended 58% of the General Fund Operating Budget compared to 53% in the prior Fiscal Year.
As previously noted there are some timing differences with payment for contract services, which
complicate comparisons between Fiscal Years. Fire is higher than in the same period Of the prior year due
to higher costs incurred to date for contract fire personnel. Police is higher than in the same period in the
prior year due to timing differences in payments for contract personnel. Health and Welfare is lower than
in the same period of the prior year as the review of the City's housing element is expected to be
completed later in the current Fiscal Year.
Community Development is lower than in the same period of the prior year due to delays' in filling staffing
vacancies in the Planning Division. The amount spent on Capital Projects is higher than in the same
period of the prior year due to expenditures incurred in the initial stages of construction of the City's new
library. 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 April 30, 2002
Total General Fund Revenues
Property Taxes
Sales Taxes [] FY 2001/2002
FY 2000/2001
Real Property Transfer Tax ~%
Transient Occupancy Taxes
Franchise Taxes 91%
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Services
Fines and Forfeitures
Other Revenues
I I
0% 30% 60% 90% 120% 150%
83% of Year Complete
FY 2001102 FY 2001102 % of FY 2000101 % of Total for
Budget YTD Actual Budget YTD Actual FY 2000101
Property Taxes 8,258,100 7,801,405 94% 6,874,391 96%
Sales Taxes 13,200,000, 9,740,301 74% 9,925,371 76%
Real Property Transfer Tax 450,000 327,224 73% 487,637 85%
Transient Occupancy Taxes 1,035,000 606,067 59% 717,043 71%
Franchise Taxes 1,254,830 1,146,512 91% 988,532 75%
Licenses and Permits 2,957,140 1,994,753 67% 2,702,165 89%
Interest and Rentals 1,787,578 1,166,680 65% 2,059,358 78%
Intergovernmental 1,948,150 1,615,206 83% 1,655,797 83%
Charges for Services 4,773,691 3,239,178 68% 2,558,323 69%
Fines and Forfeitures 102,000 97,028 95% 84,415 79%
Other Revenues 880,972 421,176 48% 2,340,599 86%
Total General Fund Revenues 36,647,461 28,155,530 77% 30,393,631 82%
ATTACHMENT
Date pr;nted: 5/t 3/02 9:35 AM
For the Period Ending April 30, 2002
Total General Fand ~~oi'8%
Expenses
General Government ~~ 68%
Fire ~ / 539 ~
~48%
Other Public Safety 7 ¥o · FY 2001/02
/68% ~ FY 2000/01
Transportation ~~ 69%
Health and Welfare ~~~ 5 ¥o
Culture & Community ~ ~ ~ 677/o
Services
Community ~~~' 63%
Development
Capital Improv. ~ ~ 7 ~l~llll 53~/
Projects
0% 20% 40% 60% 80% 100%
83% of Year Complete
FY 2001/02 FY 2001102 % of FY 2000101 % of Total for
Budget YTD Actual Budget Y'rD Actual FY 2000101
General Government 4,210,768 2,826,663 67% 2,092,985 68%
Poi ice 6,804,324 3,530,983 52% 1,468,133 25%
Fire 4,672,577 2,474,826 53% 2,070,371 48%
Other Public Safety 292,463 130,019 44% 106,587 · 47%
Transportation 1,127,147 772,044 68% 659,506 69%
Health and Welfare 64,495 27,786 43% 8,716 65%
Culture and Community Services 4,354,294 2,931,088 67% 2,391,255 72%
Community Development 5,594,915 3,497,086 63% 3,462,453 77%
Capital Improvement Projects 8,807,889 4,704,686 53% 987,852 37%
Total General Fund Expenses 35,928,872 20,895,181 58% 13,247,858 53%
General Fund Operating Expenses 27,120,983 16,190,495 60% 12,260,006 55%
ATTACHMENT 2
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF APRIL 2002
Prepared by
The Finance Depathaent
May 13, 2002
ATTACHMENT 3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2002
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUND FUND CURRENT PRIOR
ASSETS
CASH (44,131,039) 2,281,241 557.598 42.801,808 151.424 1.592.083 (24.052.805)
CASH WITH FISCAL AGENT 167,304 167.304 166.814
AMOUNT HELD IN ESCROW 109.300 109.300 109,300
INVESTMENTS AT COST 88.291.267 88.291.267 76.149,328
RECEIVABLES: TAXES
ACCOUNTS (NE 157,651 157.651 3.517.725
INTEREST 312,860 312,860 744.407
ASSESSMENTS
DUE FROM OTHERS 550.856
INVENTORY AT COST
PREPAID ITEMS 8.094 8,094 5.175
FIXED ASSETS
AMOUNT TO BE PROVIDED 1,652,500 1.652,500 1,652.500
TOTAL ASSETS 44,638.832 2,281.241 557.598 42:911.108 1.971.228 92,291,058 58,843,299
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (941.283) (941,283) (512,334)
DEPOSITS FOR AB1600 FEES (27.973) (45.223.984) (45,251,957) (11.556,340)
DEPOSITS OTHERS (857.160) (857.160) (414,923)
PAYABLES: ACCOUNTS (142,808) (87,513) (12,089) (201.081)~ (5.323,868)
INTEREST
PAYROLL (322.687) (322,687) (547,869)
DUE TO OTHERS (149.877) (149.877) (603.122)
DEFERRED REVENUE (146.433) (146.433) (147,203)
DEBT INSTRUMENTS PAYABLE (1,770,000) (1.770.000) (1.770,000)
TOTAL LIABILITIES (2,588,220) (87.513) (45,236,073) (1,770.000) (49.640.477) (20.875,659)
FUND BALANCES (42.050.612) (2.193.728) (557.598) 2.324.966 (201,228) (42.650.581) (37.967.640)
TOTAL FUND E (42,050.612) (2.193.728) (557.598) 2,324.966 (201.228) (42,650,581) (37.967,640)
TOTAL LIAB. FND BAL. RETD (44.638,832) (2.281.241) (557.598) (42,911.108) (1,971.228) (92.291.058) (58,843.299)
CITY OF DUBLIN
BALANCE SHEET
FORTHE
PERIOD ENDING 30Apr2002
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 6,071,033 3,065,540 2.694,870
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE 6,495
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 22,149,264 15,987,209~ 38,136,473 38,136,473
41,477,363
41,688,500
AMOUNT TO BE PROVIDED 41,477,36~
TOTAL ASSETS 28,220,297 15,987,209 41,477,363 82,679,376 82,526,337
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (1) (1) (4.446)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (41,477,363) (41,477,363) (41,688,500)
TOTAL LIABILITIES (1) (41,477,363) (41,477,363) (41,692.946)
FUND BALANCES (28,220.296) (15,987,209) (41,202,012) (40.833,391)
TOTAL FUND E (28,220,296) (15,987,209) (41,202.012) (40,833,391)
TOTAL LIAB. FND BAL. RETD (28,220,297) (15,987,209) (41,477,363) (82,679,376) (82,526,337)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITdRES
FOR THE PERIOD
07/01/2001 THROUGH 04/30/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY TAXES 8,258,100.00 7.801,404.71 456,695.29 7,174,289.56 6,874,390.92 299,898.64
SALES TAX 13,200,000.00 9,740,301.30 3.459,698.70 12.985,986.39 9,925,371.27 3,060,615.12
REAL PROPERTY TRANSFER TAX 450,000.00 . 327,224.47 122,775.53 575,281.78 487.637.36 87,644.42
HOTEL T~NSIENT OCCUPANCY TAX 1,035.000.00 606,066.72 428,933.28 1,010,799.01 717,042.82 293,756.19
F~NCHISE TAXES 1,254,830.00 1,146,512.23 108,317.77 1,313,086.74 988,532.17 324,554.57
LICENSES & PERMITS 2,957,140.00 1,994,753.46 962,386.54 3.028,655.28 2,702,164.89 326,490.39
FINES & FORFEITURES 102,000.00 97,027.85 4,972.15 106,233.99 84,414.87 21,819.12
USE/MONEY & PROP-INTEREST 1,688,988.00 1,103,488.58 585,499.42 2,512,223.69 1,982,778.10 529,445.59
USE/MONEY & PROP-RENTALS 98,590.00 63,191.35 35,398.65 114,614.48 76,579.82 38,034.66
INTERGOVERNMENTAL FROM STATE 1,948,150.00 1,615,205.69 332,944.31 2,006.116.43 1,655,796.50 350,319.93
INTERGOVERNMENTAL FROM COUNTY
CHARGES FOR SERVICES 4,773,691.00 3,239,'177.63 1,534,513.37 3,719,568.13 2,558,322.76 1,161,245.37
OTHER SOURCES OF REVENUE 880,972.00 421.175.91 459,796.09 2,715,619.50 2,340,598.58 375,020.92
TOTAL REVENUE 36,647.461.00 28,155,529.90 8,491,931.10 37,262,474.98 30,393,630.06 6.868,844.92
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 266,439.00 201,075.20 65,363.80 157,649.46 130,638.29 27,011.17
CITY MANAGER 684.838.00 399,931.03 284.906.97 451,460.84 345,583.03 105,877.81
CENT~L SERVICES 311,657.00 255,852.70 55,804.30' 254,490.40 194,327.36 60,163.04
CITY A-rTORNEY 749,339.00. 530,641.72 218,697.28 566,876.47 323,505.07 243,371.40
ADMIN SERVICES 958,814.00 716,572.07 242,241.93 755.484.16 583.008.13 172,476.03
BUILDING MANAGEMENT 681,962.00 456,943.04 225,018.96 561.347.95 376,346.41 185,001.54
INSURANCE COST CENTER 389,315.00 253,153.56 136,161.44 273,267.70 127,387.52 145,880.18
ELECTIONS COST CENTER 22,532.00 2,493.50 20,038.50 12,013.21 12,013.21
NON-DEPARTMENTAL 145,872:00 10,000.00 135,872.00 53,136.03 176.10 52,959.93
ACTIVITY TOTAL 4,210,768.00 2.826,662.82 1,384,105.18 3,085,726.22 2,092,985.12 992,741.10
PUBLIC SAFETY
POLICE 6,804,324.~00 3,530,983.31 3,273,340.69 5,842,597.93 1,468,132.54 4,374,465.39
CROSSING GUARDS 63,495.00 39,624.59 23,870.41 49,327.13 33,565.50 15,761.63
ANIMAL CONTROL 180,757.00 53,835.87 126,921.13 136,903.24 38,868.24, 98,035.00
DISASTER PREPAREDNESS 48,211.00 36,558.24 11,652.76 41,743.47 34,153.03 7,590.44
FIRE SERVICES 4,672,577.00 2.474,825.87 2,197.751.13 4,331,237.29 2,070,371.42 2,260,865.87
ACTIVITY TOTAL 11.769,364.00 6,135,827.88 5,633,536.12 10,401,809.06 3,645,090.73 6,756,718.33
TRANSPORTATION
PUBLIC WORKS 574,025.00 441,049.24 132,975.76 504,545.32 388,522.43 116.022.89
STREET MAINTENANCE 6,406.00 1,970.19 4,435.81 79.88 79.88
STREET SWEEPING 139,200.00 90,352.04 48,847.96 105,015.72 72,099.13 32,916.59
STREET TREE MAINTENANCE 55,629.00 36,611.76 19,017.24 52,929.17 28,013.33 24,915.84
STREET LANDSCAPING MAINTENAN 351,887.00 202,060.98 149,826.02 297,191.50 170,790.75 126,400.75
ACTIVITY TOTAL 1,127.147.00 772,044.21 355,102.79 959,761.59 659,505.52 300,256.07
HEALTH & WELFARE
THE CITY OF DUBLINSTATEMENTSHOWING ~ o,~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 04/30/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
WASTE MANAGEMENT 8,395.00 96.38 8.298.62 1,483.29 1,469.88 13.41
CHILD CARE 15,000.00 8,369.00 6,631.00 12,000.00 7,246.00 4,754.00
HOUSING PROGRAMS 41,100.00 19,320.50 21.779.50
ACTIVITY TOTAL 64,495.00 27,785.88 36.709.12 13,A83.29 8,715.88 4,767.41
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 400,725.00 300,543.75 100,181.25 362,922.00 272,191.50 90,730.50
CULTURAL ACTIVITIES 149,328.00 111,817.49 37,510.51 48,979.05 43,160.12 5,818.93
HERITAGE CENTER 84,170.00 52,204.52 31,965.48 64,337.03 48,694.37 15,642.66
DUBLIN CEMETERY 39,687.00 17,865.05 21,821.95 35,168.63 21,832.11 13,336.52
PARK MAINTENANCE 1,142.023.00 . 705,910.74' 436,112.26 863,488.51 518,914.29 344,574.22
COMMUNITY TV 90,982.00 60,887.12 3b,094.88 65,376.81 60,204.35 5,172.46
RECREATION'ADMIN 398,810.00 289,581.66 109,228.34 299,517.33 239,459.45 60,057.88
PLAYGROUNDS 236,890.00 158,288.25 78,601.75 179,746.06 142,302.80 37,443.26
SHANNON CENTER 265,856.00 182,439.61 83,416.39 223,534.64 168,146.30 55,388.34
PRESCHOOL 58,975.00 45,010.24 13,964.76 54,261.57 43,491.00 10,770.57
TEENS PROGRAM 108,839.00 72,710.92 36,128.08 95,263.42 74,953.50 20.309.92
ADULT SPORTS 80,704.00 52,494.02 28,209.98 74,298.29 . 48,991.27 25,307.02
YOUTH SPORTS 93,023.00 64,281,41 28,741.59 76,437.85 62,583.01 13,854.84
COMMUNITY GYM 37,990.00 12,819.71 25,170.29 37,226.81 15,020.48 22,206.33
SPECIAL EVENTS 320.247.00 266,483.41 53,763.59 200,963.28 166,250.30 34,712.98
SENIOR CENTER 167,065.00 109,815.79 57,249.21 137,807.83 107,577.00 30,230.83
RECREATION INSTRUCTION 130,122.00 106,035.05 24,086.95 116,758.13 88,008.86 28,749.27
AQUATICS 368,051.00 217,948.95 150,102.05 300,625.35 193,188.48 107,436.87
PARKS/FACILITIES MANAGEMENT 180,807.00 103,950.21 76,856.79 95,707.64 76,286.03 19,421.61
ACTIVITY TOTAL 4,354,294.00 2,931,087.90 1,423,206.10 3,332,420.23 2,391,255.22 941,165.01
COMMUNITY DEVELOPMENT
PLANNING 1,689,970.00 1,145,203.47 544,766.53 1,330,195.42 1,020,887.07 309,308.35
BUILDING SAFETY 1,622,000.00 899,852.50 722,147.50 1,334,934.18 976,207.96 358,726.22
ENGINEERING 1,999.416.00 1,217,560.68 781,855.32 1,606,493.94 1,236,092.79 370,401.15
ECONOMIC DEVELOPMENT 283,529.00 234,468.85 49.060.15 254.453.24 229,264.76 25,188.48
ACTIVITY TOTAL 5,594,915.00 3,497,085.50 2,097,829.50 4,526,076.78 3,462.452.58 1,063,624.20
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 6,095,010.00 3,858,585.95 2,236,424.05 1,435,693.51 320,461.80 1,115,231.71
COMMUNITY IMPROVEMENTS 1,198,376.00 158,193.11 1,040,182.89 180,763.51 116,687.55 64,075.96
PARKS 665,863.00 349,673.74 316,189.26 462,208.60 391,065.23 71,143.37
STREET CONSTRC/IMPROVEMENTS 848,640.00 338,233.17 510,406.83 603;894.29 159,636.93 444,257.36
ACTIVITY TOTAL 8.807,889.00 4;704,685.97 4,103,203.03 2,682,559.91 987,851.51 1,694,708.40
TOTAL EXPENDITURES 35,928,872~00 20,895,180.16 15,033,691.84 25.001.837.08 13,247,856.56 11,753,980.52
EXCESS REVENUE (EXPENDITURES) 718,589.00 7,260,349.74 (6,541,760.74) 12,260,637.90 17,145,773.50 (4,885,135.60)
TRANSFERS IN FROM OTHER FUNDS 438.00 (438.00) 17,201.67 17,201.67
TRANSFERS OUT FROM OTHER FUNDS (2,400,000.00) (2,400,000.00)
REVENUES OVER(UNDER) EXPENDITURES 718.589.00 7,260,787.74 (6,542,198.74) 9,877,839.57 17,145,773.50 (7,267,933.93)
THE CITY OF DUBLIN STATEMENTSHOWING ~ ~
REVENUESVERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 04/30/2002
SPECIAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
PROPERTY TAXES 90,175.00 83,308.48 6,866.52 81,587.21 75,000.93 6,586.28
SALES TAX/OTHER TAXES 230,500.00 163,053.40 67,446.60 218,443.36 180,849.41 37,593.95
FINES & FORFEITURES 145,155.00 98,286.35 46,868.65 136,129.03 89,617.18 46,511.85
USES/MONEY & PROPERTY 110.312.00 63,876.34 46,435.66 186,396.07 87,213.13 99,182.94
INTERGOVERNMENTAL FROM STATE 3.457,849.00 836,284.31 2,621,564.69 1,401,011.82 938,689.81 462,322.01
INTERGOVERNMENTAL FROM COUNTY 234,000.00 156.410.25 77,589.75 235,575.00 128,820.00 t06,755.00
INTERGOVERNMENTAL FROM FEDERAL 1,122,338.00 46,904.50 1,075,433.50 486,386.87 64,286.02 422,100.85
CHARGES FOR SERVICES 876,760.00 803,827.35 72,932.65 766,872.19 714,741.38 52,130.81
OTHER SOURCES OF REVENUE 5,000.00 15,525.13 (10,525.13) 17,930.25 5.259.25 12,671.00
TOTAL REVENUE 6.272,089.00 2,267,476.11 4,004,612.89 3,530,331.80 2.284,477.11 1,245,854.69
*******EXPENDITURES*******
PUBLIC SAFETY:
POLICE 304.065.00 158,391.60 145,673.40 163.769.23 62,998.79 100,770.44
TRAFFIC SIGNALS & STREET LTG 175,041.00 80,765.78 94,275.22 87,789.56 57,844.41 29,945.15
FIRE SERVICES 177.100.00 124,720.27 52,379.73 188,299.58 131.419.58 56,880.00
ACTIVITY TOTAL 656,206.00 363.877.65 292.328.35 439,858.37 252,262.78 187,595.59
TRANSPORTATION:
STREET MAINTENANCE 175,084.00 124,927.46 50,156.54 348,601.71 136,302.66 212,299.05
STREET SWEEPING
ACTIVITY TOTAL 175,084.00 124,927.46 50.156.54 348,601.71 136,302.66 212,299.05
HEALTH & WELFARE:
WASTE MANAGEMENT 1,049,577.00 521.014.70 528.562.30 1,108,496.91 660,632.56 447,864.35
SENIOR SUPPORT CARE 7.500.00 3,750.00 3.750.00 7,500.00 3,750.00 3,750.00
HOUSING PROGRAMS 10.000.00 2,496.40 7,503.60 9,918.66 6,202.30 3,716.36
ACTIVITY TOTAL 1.067,077.00 527,261.10 539,815.90 1,125,915.57 670,584.86 455,330.71
COMMUNITY DEVELOPMENT:
ENGINEERING 6,000.00 2,398.50 3,601.50 4,999.00 4,999.00
ACTIVITY TOTAL 6,000.00 2,398.50 3,601.50 4,999.00 4,999.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
COMMUNITY PROJECTS 80,373.00 19,958.55 60,414.45 86,648.98 53,851.22 32.797.76
PARKS 411,119.00 411,119.00
STREET CONSTRUCTION/IMPROVEMENT 4.898.421.00 1,777,275.47 3,121,145.53 760,517.95 550,347.86 210,170.09
ACTIVITY TOTAL 5,389.913.00 1,797,234.02 3,592,678.98 847,166.93 604,199.08 242,967.85
T 0 T A L EXPENDITURES 7,294.280.00 2,815.698.73 4,478,581.27 2,766,541.58 1.663,349.38 1,103,192.20
EXCESS <REVENUE>EXPENDITURE 1,022,191.00 548,222.62 473,968.38 (763,790.22) (621,127.73) (142.662.49)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 438.00 (438.00) 15,061.59 15,061.59
EXCESS <REVENUE> EXPENDITURE 1,022,191.00 548,660.62 473,530.38 (748.728.63) (621,127.73) (127,600.90)
FOR THE PERIOD
07J0112001 ~HROU~ 04J3012002
SPECIAL ASSESSMENT FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
***********************
SPECIAL BENEFITS ASSESSMENTS 429,448.00 397,355.99 32,092.01 384,648.76 345,216.36 39,432.40
USES/MONEY & PROP-INTEREST 20,187.00 9.125.20 11,061.80 26,456.80 10,955.35 15,501.45
OTHER SOURCES OF REVENUE 6,000.00 1,995.50 4,004.50 2,300.37 2,300.37
TOTAL REVENUE 455,635.00 408,476.69 47,158.31 413,405.93 358,472.08 54,933.85
*******EXPENDITURESw******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 230,635.00 132,147.24 98,487.76 119,085.13 76,802.47 42,282.66
ACTIVITY TOTAL 230,635.00 132,147.24 98,487.76 119,085.13 76,802.47 42,282.66
TRANSPORTATION
PUBLIC WORKS 4,807.00 2,639.87 2,167.13 2,753.02 1,867.10 885.92
STREET TREE MAINTENANCE 15,065.00 5,609.64 9,455.36 4,175.26 2,495.99 1,679.27
STREET LANDSCAPE MAINTENANCE 280,667.00 146.281.49 134,385.51 130,649.00 91,403.02 39.245.98
ACTIVITY TOTAL 300,539.00 154,531.00 146,008.00 137,577.28 95,766.11 41,811.17
COMMUNITY DEVELOPMENT
ENGINEERING 7,115.00 14,751.46 (7,636.46) 11,050.38 4,300.08 6,750.30
ACTIVITY TOTAL 7,115.00 14,751.46 (7,636.46) 11,050.38 4,300.08 6,750.30
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 2,519.14 2,519.14
STREET CONSTRUCTION/IMPRVMNT
ACTIVITY TOTAL 2,519.14 2,519.14
T 0 T A L EXPENDITURES 538,289.00 301,429.70 236,859.30 270,231.93 179,387.80 90,844.t3
EXCESS <REVENUE>EXPENDITURE 82,654.00 (107,046.99) 189,700.99 (143,174.00) (179,084.28) 35,910.28
EXCESS <REVENUE>EXPENDITURE 82,654.00 (107,046.99) 189,700.99 (143,174.00) (179,084.28) 35,910.28
THE CITY OF DUBLIN STATEMENT SHOWING /~C]) ~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 04/30/2002
CAPITAL IMPROVEMENT FUND
CURRENT CURRENT · PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*********************
USES/MONEY & PROP-INTEREST 1,640,682.00 766,333.51 874,348.49 789,214.44 (789,214.44)
OTHER SOURCES OF REVENUE 37,719,269.00 37,719,269.00 8,882,376.17 8,882,376.17
TOTAL REVENUE: 39,359,951.00 766,333.51 38,593,617.49 8,882,376.17 789,214.44 8,093,161.73
**************************
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 1,854,726.00 50,008.18 1,804,717.82
CULTURE & LEISURE SERVICES: ·
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING 8,398.57 (8,398.57) 30,854.96 26,460.81 4,394.15
ACTIVITY TOTAL 8,398.57 (8,398.57) 30,854.96 26,460.81 4,394.15
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 12,869,967.00 1,016,210.86 11,853,756.14 936,862.45 627,111.96 309,750.49
COMMUNITY IMPROVEMENTS
PARKS 1,422,224.00 66,051.28 1,356,172.72 18,854.85 17.881.46 973.39
STREET CONSTRUCTION/IMPROVEMENT 15,659,638.00 2,371,172.10 13,288,465.90 7,890,520.72 6,717,994.27 1,172,526.45
ACTIVITY TOTAL 29,951,829.00 3,453,434.24 26,498,394.76 8,846,238.02 7,362,987.69 1.483,250.33
T 0 T A L EXPENDITURES 31,806,555.00 3,511,840.99 28,294,714.01 8,877,092.98 7,389,448.50 1,487,644.48
EXCESS <REVENUE>EXPENDITURE (7,553,396.00) 2,745,507.48 (10,298,903.48) 5,283.19) 6,600,234.06 (6,605,517.25)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO' OTHER FUNDS 1,140.08 1,140.08
EXCESS <REVENUE>EXPENDITURE (7,553,396.00) 2,745,507.48 (10,298,903.48) 4,143.11) 6,600,234.06 (6,604,377.17)
THE CITY OF DUBLIN STATEMENT SHOWING // ~' /~-~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 04/30/2002
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
· **********************
SPECIAL ASSESSMENTS 202,227.39 (202,227.39) 237,172.56 206,511.07 30,661.49
USES/MONEY & PROP-INTEREST 1,767.78 (1,767.78) 16,539.29 5,939.51 10,599.78
TOTAL REVENUE 203,995.17 (203,995.17) 253,711.85 212,450.58 41,261.27
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 232,578.00 231,6,67.20 910.80 234,093.57 233,093.57 1,000.00
ACTIVITY TOTAL 232,578.00 231,667.20 910.80 234.093.57 233,093.57 1,000.00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES 232,578.00 231,667.20 910.80 234,093.57 233,093.57 1,000.00
EXCESS <REVENUE>EXPENDITURE 232,578.00 27,672.03 204,905.97 (19,618.28) 20,642.99 (40,261.27
EXCESS <REVENUE>EXPENDITURE 232,578.00 27,672.03 204,905.97 (19,618.28) 20,642.99 (40,261.27
THE CITY OF DUBLIN STATEMENT EXPENDITURES SHOWING
REVENUES VERSUS
FOR THE PERIOD
07/01/2001 THROUGH 04/30/2002
INTERNAL SERVICE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
USES/MONEY & PROP-INTEREST 298,835.00 121,730.05 177,104.95 205,273.76 96,664.80 108,608.96
CHARGES FOR SERVICES 1,171,448.00 916,077.00 255,371.00 944,535.35 767,650.32 176.885.03
OTHER SOURCES OF REVENUE 17.000.00 19,744.05 (2,744.05) 6,495.00 6,495.00
TOTAL REVENUE 1,487,283.00 1,057,551.10 429,731.90 1,156,304.11 864,3~5.12 291,988.99
*******EXPENDITURES*******
GENEP~AL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 1,140,046.00 333,712.41 806,333.59 1,018,788.52 298,084.35 720,704.17
ACTIVITY TOTAL 1,140,046.00 333,712.41 806,333.59 1,018,788.52 298,084.35 720,704.17
PUBLIC SAFETY:
FIRE 45,828.00 21,390.09 24,437.91 40,700.28 19,237.63 21,462.65
ACTIVITY TOTAL 45,828.00 21,390.09 24,437.91 40.700.28 19,237.63 21,462.65
TP, ANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS: 189,750.00 189.750.00 20,576.74 (20,576.74)
T 0 T A L EXPENDITURES- 1,375,624.00 355,102.50 1,020,521.50 1,059,488.80 337,898.72 721,590.08
EXCESS<REVENUE>EXPENDITURE (111,659.00) (702,448.60) 590,789.60 (96,815.31) (526,416.40) 429,601.09
TP, ANSFER IN FROM OTHER FUNDS 2,400,000.00 2,400,000.00
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE (111,659.00) (702,448.60) 590,789.60 (2,496,815.31) (526,416.40) (1,970,398.91)
~-,-,~- c~--,-¥ o~ o~,~_~,,, ~A~-~,~,,,-,- s,o,~'~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 04/30/2002
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 20.00 20,00
FINANCE
ACTIVITY TOTAL 20.00 20.00
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 20.00 20.00
EXCESS <REVENUE>EXPENDITURE 20.00 20.00
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 20.00 20.00