HomeMy WebLinkAboutItem 4.08 May 2003 FinRpts CI'TY CLERK
File 330-50
AGENDA STATEMENT
CI'TY COUNCIL MEETI'NG DATE: July 2003
SUBJECT: Financial Reports For the Month of May 2003
Report Prepared by: Carole A. 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 2003
RECOMMENDATIO~ ~z~Receive the reports.
FINANCIAL STAT~_~_~ENT: See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report on the preliminary financial statements for the month
of May. 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 2003 Revenue and Expenditure Report
The May report represents the reporting of revenues and expenditures for 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 somewhat,
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 in a subsequent section of this report.
Additional Impacts resulting from Passage of State Budget for Fiscal Year 2002/2003
As previously reported to Council in the April Financial Reports on May 20th, and as currently budgeted
by the State, the City continues to receive Gas Taxes and Motor Vehicle in Lieu Fees from the Department
of Motor Vehicles. It should be noted that, for Fiscal Year 2002-2003, the $100,000 revenue budgeted for
the Citizen's Option for Public Safety (COPS) grant was received at the end of October 2002 and that
$60,748 was received from the State for the City's Booking Fee Reiml>ursements in November 2002.
The State budget condition remains unsettled. As of the date that this report was prepared, the State has
yet to adopt a final budget for Fiscal Year 2003-2004. Therefore, Staff has no confirmed information
regarding the fate of revenue streams critical to the City, such as the Motor Vehicle in Lieu Fees (VLF).
As reported previously, VLF comprises $1,937,000 million of the City's General Fund revenue for Fiscal
Year 2002-2003. About $1.4 million represents the "backfill" portion that is funded by the State. There
is scant optimism that the State will bring in a budget soon. However, Staff will continue to monitor the
situation and will report back to Council on any subsequent modifications to the State's budget that have a
direct financial impact on the City.
COPIES TO: 4~
G:\Monthly Financials\5-2003 agenda statement monthly financials, doc ITEM NO.
General Fund Revenues
· Total General Fund Revenues collected through May have exceeded what was collected in the eleventh
month of the previous Fiscal Year. Through May 2003, the City has collected approximately 90% of the
total budgeted General Fund Revenues compared to 86% in the prior Fiscal Year.
Property Taxes are higher than in the same period in the prior year due to timing differences related to
deductions of property tax receipts for monies due to the Alameda County Surplus Property Authority
under its revenue sharing agreement with the City.
The amount of sales tax reported through the end of May includes actual sales taxes received through
December 2002. Real Property Transfer Tax is lower than in the same period of the prior year due to
lower than expected year to date proceeds from the sale of non residential properties.
Transient Occupancy Taxes (TOT) are lower than in the same period of the prior year due to lower than
expected occupancy rates at some of the City's hotels. In addition, there has been an increase in the
amount of exemptions claimed by two of the local hotels. These exemptions are the result of hotel
bookings by federal and state employees, who are exempt from paying this tax under the City's TOT
ordinance. Franchise Taxes are lower than in the same period of the prior year due to the success
achieved from the City's new commercial recycling programs, which have reduced the amount of garbage
collected in the City, thereby reducing the Franchise Taxes received from the City's contract waste
management provider.
Licenses and Permits are higher than in the same period of the prior year due to an increase in the number
of permits pulled for new residential projects. Interest and Rentals is higher than in the same period of the
prior year due to timing differences in the receipt of interest payments from federal securities and a higher
year to date cash balance in the General Fund than originally estimated in the budget. Initially all interest
revenue is recorded in the General Fund and is then allocated quarterly to other funds on a pro rata basis.
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. Charges for Services is lower than in the same period of
the prior year due to the receipt of one time monies from AT&T (now Comcast) for cable equipment in
Fiscal Year 2001-2002. Fines and forfeitures are higher than in the same period of the prior year due to an
increase in the dollar amount of court convictions from previous outstanding court cases relating to arrests
occurring within the City. Other Revenues are lower than in the prior year due to reimbursements
received in the prior year from Dublin San Ramon Services District (DSRSD) for work performed on the
Dublin Boulevard Widening project.
General Fund Expenditures
Overall, through the month of May, expenditures in the General Fund totaled approximately $23.9 million
and represented approximately 65% of the total budgeted expenditures in the General Fund. Of this
amount, a total of approximately $3.2 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 May 2003 was similar to the
amounts expended for the same period in the prior Fiscal Year. Through May 2003, the City had
expended 70% of the General Fund Operating Budget, compared to 69% in the prior Fiscal Year. Fire is
higher than in the same period of the prior year due to timing differences for the payment of contract fire
services. Other Public Safety was lower than in the same period in the prior year due to timing differences
for the payment of contract animal control services.
Health and Welfare is lower than in the same period of the prior year due to delays in the completion of
the non residential affordable housing fee study. Culture and Community Services are lower than in the
same period of the prior year due to timing differences in the payments for partial funding of library
services. Community Development is lower than in the same period of the prior year due to lower than
expected use of development related contract services in the Planning and Engineering divisions due to
delays in development projects.
Capital Improvement Projects are lower than in the same period of the prior year. Several of the capital
projects funded by the General Fund in Fiscal Year 2002-2003 will not incur major expenditures until
later in the Fiscal Year and/or will be carried over into future years, including the Downtown
Improvement Implementation, Freeway Underpass Art at Dublin Boulevard and Amador Valley
Boulevard, Shannon Community Center Decking & Exterior Painting, Senior Center and Dublin
Boulevard Undergrounding of Utilities. In addition, the expenditures for some capital projects are
anticipated to come in significantly under budget during the year, including the Geographic Information
System and Civic Center HVAC Project. 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.
City of Dublin 2002-2003 YTD Revenues and Budget Comparison
For the Period Ending May 31, 2003
Total General Fund Revenues ',6%
Property Taxes
Sales Taxes :7%
· FY 2002/2003
[] FY 2001/2002
Real Property Transfer Tax 91%
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Services 87%
Fines and Forfeitures 95%
Other Revenues ]92 %
0% 30% 60% 90% 120% 150%
92% of Year Complete
FY 2002~03 FY 2002~03 % of FY 2001/02 % of Total for
Budget YTD Actual Budget YTD Actual FY 2001/02
Property Taxes 9,892,843 9,700,313 98% 7,801,405 89%
Sales Taxes 12,702,000 11,095,595 87% 10,794,201 84%
Real Property Transfer Tax 415,000 277,165 67% 395,438 91
Transient Occupancy Taxes 858,000 548,981 64% 677,117 84%
Franchise Taxes 1,493,900 1,205,899 81% 1,198,419 86%
Licenses and Permits 1,622,404 2,293,049 141% 2,166,978 93%
Interest and Rentals 1,373,538 1,299,551 95% 1,270,262 66%
Intergovernmental 2,096,165 1,875,833 89% 1,747,202 84%
Charges for Services 4,815,035 3,866,246 80% 3,872,171 87%
Fines and Forfeitures 114,000 108,816 95% 107,451 91
Other Revenues 755,839 342,099 45% 453,026 92%
Total General Fund Revenues 36,138,724 32,613,547 90% 30,483,670 86%
D ....... ed: ~,~®~ ~:.~ ~,~ ATTACHMENT
City of Dublin 2002-2003 YTD Expenses and Budget Comparison
For the Period Ending May 31, 2003
Total General Fund
Expenses 750/°
General Government 79
111111153~
Police 54
! i o
Fire ! 172%
i, 0
~,8
Other Public Safety
~8 ¥o · FY 2002~03
~~7% [] FY 2001/02
Transportation 80%
Health and Welfare 70o/,
Culture & Community ~/
'8_.°/_o
Services
Community 75 o
0
Development 83
Capital Improv. l/lllll~~ I ] 43°/~/ ~95'
Projects I I ! I I ] I ] I
0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
92% of Year Complete
FY 2002103 FY 2002103 % of FY 2001/02 % of Total for
Budget YTD Actual Budget YTD Actual FY 2001/02
General Government 4,334,621 3,444,813 79% 3,102,445 79%
Police 7,900,174 4,201,030 53% 3,627,582 54%
Fire 5,114,779 3,693,393 72% 2,522,732 54%
Other Public Safety 315,058 181,708 58% 197,712 82%
Transportation 1,337,221 1,034,099 77% 872,921 80%
Health and Welfare 69,001 34,538 50% 36,500 70%
Culture and Community Services 4,812,790 3,738,249 78% 3,312,068 83%
Community Development 5,893,670 4,438,669 75% 3,871,455 83%
Capital Improvement Projects 7,321,648 3,166,310 43% 6,471,607 95%
Total General Fund Expenses · 37,098,962 23,932,809 65% 24,015,022 75%
General Fund Operating Expenses 29,777,314 20,766,499 70% 17,543,415 69%
ATTACHMENT 2
Date P~nted: 6,t20f2003 5:01 PM
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF MAY 2003
Prepared by
The Finance Department
June 3, 2003
ATTACHMENT 3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31May2003
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (40.487.813) 2,854.691 539,549 30.605,412 164,758 (6.323.403) (24.890.008)
CASH WITH FISCAL AGENT 172,101 172,101 167,304
AMOUNT HELD IN ESCROW 109,300
INVESTMENTS AT COST 90,247,099 90,247,099 93,738,874
RECEIVABLES: TAXES
ACCOUNTS 138,985 361,702 500,688 157,651
INTEREST 542,481 542,481 312,860
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 17.321 17.321 7,256
FIXED ASSETS
AMOUNT TO BE PROVIDED 1,553,500 1,553,500 1,652,500
TOTAL ASSETS 50,458,073 3,216,393 539,549 30,605,412 1,890,360 86,709,787 71,255,737
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (761,790) (761,790) (986,607)
DEPOSITS FOR AB1600 FEES (34,901) (7,742,861) (7,777.763) (24.669,965)
DEPOSITS OTHERS (851,098) (851,098) (874.922)
PAYABLES: ACCOUNTS (216,428) (140,012) (212,833) (569,273) (257.628)
INTEREST
PAYROLL (403,757) (403,757) (327,107)
DUE TO OTHERS (48,928) (48,928) (98,751)
DEFERRED REVENUE (127,768) (127,768) (146,433)
DEBT INSTRUMENTS PAYABLE (1,671,000) (1,671,000) (1,770,000)
TOTAL LIABILITIES (2.444,671) (140,012) (7,955,694) (1,671,000) (12,211,377) (29,131,412)
FUND BALANCES (48,013,402) (3,076,381) (539,549) (22,649,718) (219,360) (74,498,410) (38,211,664)
TOTAL FUND E (48,013,402) (3,076,381) (539,549) (22,649,718) (219,360) (74.498,410) (38,211,664)
TOTAL LIABILITIES/EQUITY (50,458,073} (3,216,393) (539,549) (30,605,412) (1,890.360) (86,709,787) (67,343,076)
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31May2003
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S
SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM---
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 6,731,076 (20) 6,731,056 6,144,493
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 36,183,959 12,492,387 48,676,346 38,136,473
AMOUNT TO BE PROVIDED 50,612,604 50,612,604 41.464,568
TOTAL ASSETS 42,915,035 (20) 12,492,387 50.612,604 106,020,006 85,745,534
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (50,612,604) (50.612,604) (41,464,568)
TOTAL LIABILITIES (50,612,604) (50,612,604) (41,464,568)
FUND BALANCES (42.915.035) 20 (12,492,387) (55,407,402) (43,505,056)
TOTAL FUND E (42,915,035) 20 (12,492,387) (55,407,402) (43,505,056)
TOTAL LIABILITIES/EQUITY (42,915,035) 20 (12,492,387) (50.612.604) (106,020,006) (84,969,625)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 05/31/2003
GENERA REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D~ VARIANCE
**********************
PROPERTY TAXES 9,892,843.00 9,700,313.05 192,529.95 8,794,710.89 7,801,404.71 993,306.18
SALES TAX 12,702,000.00 11,095,595.04 1,606,404.96 12,813,111.10 10,794,201.30 2,018,909.80
REAL PROPERTY TRANSFER TAX 415,000.00 277,165.46 137,834.54 434,832.20 395,437.89 39,394.31
HOTEL TRANSIENT OCCUPANCY TAX 858.000.00 548,981.46 309,018.54 810,219.79 677,117.01 133,102.78
FRANCHISE TAXES 1,493,900.00 1,205,899.27 288,000.73 1,385,815.52 1,198,419.23 187,396.29
LICENSES & PERMITS 1,622,404.00 2,293,049.39 (670,645.39) 2,327,250.77 2,166.977.98 160,272.79
FINES & FORFEITURES 114,000.00 108,816.44 5,183.56 118,190.93 107,451.10 10,739.83
USE/MONEY & PROP-INTEREST 1,244,226.00 1,187,719.92 56,506.08 1,843,673.66 1,198,126.60 645,547.06
USE/MONEY & PROP-RENTALS 129,312.00 111,831.52 17,480.48 85,936.82 72,135.80 13.801.02
INTERGOVERNMENTAL 2,096,165.00 1,875,833.22 220,331.78 2,076,~48.50 1,747,201.99 329,446.51
CHARGES FOR SERVICES 4,815,035.00 3,866,246.10 948,788.90 4,464,259.66 3,872,171.42 692,088.24
OTHER SOURCES OF REVENUE 755,839.00 342.099.12 413,739.88 493,722.65 453,026.04 40,696.61
TOTAL REVENUE 36,138,724.00 32.613,549.99 3,525,174.01 35,648,372.49 30,483,671.07 5,164,701.42
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 218,332.00 176,620.99 41,711.01 217,946.55 204,220.79 13,725.76
CITY HANAGER 757,318.00 639,388.99 117,929.01 560,359.16 460,376.94 99,982.22
CENTRAL SERV*CES 320,800.00 248,966.69 71,833.31 297,049.71 272,390.28 24,659.43
CITY ATTORNEY 686,076.00 651,722.14 34,353.86 764,484.52 595,152.08 169,332.44
ADMIN SERVICES 1,038,223.00 843,699.02 194,523.98 922,865.72 787,083.98 135,781.74
BUILDING MANAGEMENT 731,567.00 584,555.07 147.011.93 657,327.17 501,286.26 156,040.91
INSURANCE COST CENTER 386,665.00 269,691.14 116,973.86 385,396.68 257,449~41 127,946.27
ELECTIONS COST CENTER 20,940.00 10,668.84 10,271.16 14,507.57 14,485.59 21.98
NON-DEPARTMENTAL 174,700.00 19,500.00 155,200.00 109,981.56 10,000.00 99,981.56
ACTIVITY TOTAL 4,334,621.00 3,444,812.88 889,808.12 3,929,917.64 3,102,445.33 827,472.31
PUBLIC SAFETY
POLICE 7,900,174.00 4,201,029.94 3,699,144.06 6,668,234.72 3,627,581.82 3,040,652.90
CROSSING GUARDS 71.462.00 50,242.30 21,219.70 56,677.08 44,370.24 12,306.84
ANIMAL CONTROL 181,437.00 87,887.97 93,549.03 138,935.98 111,543.64 27,392.34
DISASTER PREPAREDNESS 62,159.00 43,577.71 18,581.29 46,012.48 41,798.12 4,214.36
FIRE SERVICES 5,114,779.00 3,693,392.52 1,421,386.48 4,698,607.54 2,522,731.58 2,175,875.96
ACTIVITY TOTAL 13,330,011.00 8,076,130.44 5,253,880.56 11,608,467.80 6,348,025.40 5,260,442.40
TRANSPORTATION
PUBLIC WORKS 616,631.00 531,023.98 85,607.02 557,207.53 483,551.29 73,656.24
STREET MAINTENANCE 10,427.00 7,927.19 2,499.81 6,406.00 1,970.19 4,435.81
STREET SWEEPING 132,100.00 92,542.87 39,557.13 132,383.34 100,727.25 31,656.09
STREET TREE MAINTENANCE 70,337.00 51,342.07 18,994.93 51,079.02 37,890.51 13,188.51
STREET LANDSCAPING MAINTENAN 507,726.00 351,263.12 156.462.88 347,022.86 248,781.43 98,241.43
ACTIVITY TOTAL 1,337,221.00 1,034,099.23 303,121.77 1,094,098.75 872,920.67 221,178.08
HEALTH & WELFARE
WASTE MANAGEMENT 8,242.00 182.78 8,059.22 1,807.38 46.38 1,761.00
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 05/31/2003
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
CHILD CARE 15,000.00 13,603.00 1,397.00 15,000.00 11,845.00 3,155.00
SOCIAL SERVICES 6,000.00 6,000.00
HOUSING PROGRAMS 39,759.00 14,751.74 25,007,26 35,209.87 24,608.77 10,601.10
ACTIVITY TOTAL 69,001.00 34,537.52 34,463,48 52,017,25 36,500.15 15,517.10
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 496,219.00 373,839.97 122,379.03 376,276.00 376,276.00
CULTURAL ACTIVITIES 137,153.00 104,566.67 32,586.33 119,409.29 113,999.44 5.409.85
HERITAGE CENTER 93,371.00 80.417.09 12,953.91 69,081.56 57,429.97 11,651.59
DUBLIN CEMETERY 37,418.00 21,029.43 16,388.57 30,077.98 20,976.67 9,101.31
PARK MAINTENANCE 1,263,230.00 862,347.76 400,882.24 1,086,713.48 782,359.07 304,354.41
COMMUNITY TV 83,906.00 74,500.07 9,405.93 80,087.02 70,355.12 9,731.90
RECREATION AOMIN 453,444.00 385,341.42 68,102.58 374,416.72 321,065.23 53,351.49
PLAYGROUNDS 261,690.00 191,383.88 70,306.12 207,515.47 172,121.38 35,394.09
SHANNON CENTER 270,182.00 228,985.53 41,196.47 250,834.31 213,725.76 37,108.55
PRESCHOOL 79,421.00 64,664.63 14,756.37 57,470.25 49,669.07 7,801.18
TEENS PROGRAM 113,854.00 80,326.70 33,527.30 106,183.40 81,994.43 24,188.97
ADULT SPORTS 95,061.00 78,760.40 16,300.60 76,886.84 61,840.92 15,045.92
YOUTH SPORTS 96,743.00 82,973.55 13,769.45 82,402.67 69,230.30 13,172.37
COMMUNITY GYM 35,167.00 41,499.89 (6,332.89) 23,572.33 15,504.99 8.067.34
SPECIAL EVENTS 349,589.00 337,335.41 12,253.59 314,735.18 290,502.78 24,232.40
SENIOR CENTER 247,286.00 153,457.29 93,828.71 146,824.25 124,614.31 22,209.94
RECREATION INSTRUCTION 143,005.00 139,075.72 3,929.28 145,812.50 127,883.52 17,928.98
AQUATICS 332,691.00 258,054.55 74,636.45 322,391.18 244,915.65 77,475.53
PARKS/FACILITIES MANAGEMENT 223,360.00 179,688.73 43,671.27 142,041.19 117,603.58 24,437.61
ACTIVITY TOTAL 4,812,790.00 3,738,248.69 1,074,541.31 4,012,731.62 3,312,068.19 700,663.43
COMMUNITY DEVELOPMENT
PLANNING 2,107,588.00 1,473,829.90 633,758.10 1,486,541.67 1,281,831.99 204,709.68
BUILDING SAFETY 1,585,701.00 1,175,307.94 410,393.06 1,276,343.20 1,013,701.72 262,641.48
ENGINEERING 1,902,477.00 1,534,889.31 367,587.69 1,609,544.48 1,329.892.50 279,651.98
ECONOMIC DEVELOPMENT 297,904.00 254,642.06 43,261.94 271,222.90 246,028.35 25,194.55
ACTIVITY TOTAL 5,893,670.00 4,438,669.21 1,455~000.79 4,643,652.25 3,871,454.56 772,197.69
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 2,911,288.30 2,057,857.97 853,430.33 4,582,889.35 5,434,286~54 (851,397.19)
COMMUNITY IMPROVEMENTS 1,825,317.00 400,470.55 1,424,846.45 273,283.82 237,418.97 35,864.85
PARKS 1,598,896.00 445,295.94 1,153,600.06 351,854.08 349,673.74 2,180.34
STREET CONSTRC/IMPROVEMENTS 986,147.00 262,685.21 723,461.79 580,008.92 450,228.00 129,780.92
ACTIVITY TOTAL 7,321,648.30 3,166,309.67 4,155,338.63 5,788,036.17 6,471,607.25 (683,571.08)
TOTAL EXPENDITURES 37,098,962.30 23,932,807.64 13,166,154.66 31,128,921.48 24,015,021.55 7,113,899.93
EXCESS REVENUE (EXPENDITURES) (960,238.30) 8,680,742.35 (9,640,980.65) 4,519,451.01 6,468,649.52 (1,949,198.51)
TRANSFERS IN FROM OTHER FUNDS 6,600,00 (6,600.00) 16,784.89 438,00 16,346.89
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES (960,238.30) 8,687,342.35 (9,647,580.65) 4,536,235.90 6,469,087.52 (1,932,851.62)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 05/31/2003
SPECIAL REVENUE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D, VARIANCE
************************
PROPERTY TAXES 93,610.00 96,049.33 (2,439.33) 91,099.68 83,308.48 7,791.20
*ALE* TAX/OTHER TAXES 317,700.00 300,163.26 17,536.74 206,812.62 180,182.93 26,629.69
FINE* & FORFEITURES 153,000.00 98,313.06 54,686.94 149,023.41 112,260.83 36,762.58
U,ES/MONEY & PROPERTY 50,995.00 72,893.73 (21,898.73) 135,432.87 63,876.34 71,556.53
INTERGOVERNMENTAL FROM *TATE 4,518,386.00 6,109,970.63 (1,591,584.63) 1,601,090.43 894,472.95 706,617.48
INTERGOVERNMENTAL FROM COUNTY 240,909.00 147,542.00 93.367.00 241.589.50 156,410.25 85,179.25
INTERGOVERNMENTAL FROM FEDERAL 249,461.00 184,537.72 64,923.28 782,793.26 57,304.62 725,488.64
CHARGE* FOR *ERVICE* 885,779.00 875,768.87 10,010.13 865,790.08 803,827.35 61,962.73
OTHER *OURCE* OF REVENUE 5,000.00 12,315.28 (7,315.28) 30,997.14 16,025.14 14,972.00
TOTAL REVENUE 6,514,840.00 7,897,553.88 (1,382,713.88) 4,104,628.99 2,367,668.89 1,736,960.10
**************************
PUBLIC SAFETY:
POLICE 205,727.00 90,243.93 115,483.07 377,390.53 167,916.36 209,474.17
TRAFFIC SIGNALS & STREET LTG 145,900.00 102,616.00 43,284.00 145,399.20 89,796.30 55,602.90
FIRE SERVICES 213,873.00 217,119.80 (3,246.80) 193,800.29 124,972.23 68,828.06
ACTIVITY TOTAL 572,500.00 409.979.73 162,520.27 716,590.02 382,684.89 333,905.13
TRANSPORTATION:
STREET MAINTENANCE 219,619.00 120,913.37 98.705.63 209.801.34 138,356.46 71,444.88
STREET SWEEPING
ACTIVITY TOTAL 219,619.00 120,913.37 98,705.63 209,801.34 138,356.46 71,444.88
HEALTH & WELFARE:
WASTE MANAGEMENT 1,079,569.00 512,501,72 567,067.28 1,030,807.37 521,316.66 509,490.71
SOCIAL SERVICES 28,427.00 23,382.38 5,044.62 7,500.00 5,625.00 1,875.00
HOUSING PROGRAMS 9,999.54 4,681.46 5,318.08
ACTIVITY TOTAL 1,107,996.00 535,884.10 572,111.90 1,048,306.91 531,623.12 516,683.79
COMMUNITY DEVELOPMENT:
ENGINEERING 6,000.00 6,000.00 6,000.00 2,398.50 3,601.50
ACTIVITY TOTAL 6,000.00 6,000.00 6,000.00 2,398.50 3,601.50
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
COMMUNITY PROJECTS 36,782.00 36,200.00 582.00 73,425.55 29,458.55 43,967.00
PARKS 426,095.00 254,440.00 171,655.00
STREET CONSTRUCTION/IMPROVEMENT 4,995,626.00 2,311,458.62 2,684,167.38 2,259,994.81 1,821.975.59 438,019.22
ACTIVITY TOTAL 5,458,503.00 2,602,098.62 2,856,404.38 2,333,420.36 1,851,434.14 481,986.22
T 0 T A L EXPENDITURES 7.364,618.00 3,674,875.82 3,689,742.18 4,314.118.63 2.906,497.11 1,407,621.52
EXCESS <REVENUE>EXPENDITURE 849,778.00 (4,222,678.06) 5,072,456.06 209,489.64 538,828.22 (329,338.58)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 3,662,410.97 (3,662,410.97) 16,784.89 438.00 16,346.89
EXCESS <REVENUE> EXPENDITURE 849,778.00 (560,267.09) 1,410,045.09 226,274.53 539,266.22 (312,991.69)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 05/31/2003
SPECIAL ASSESSMENT FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
************************
SPECIAL BENEFITS ASSESSMENTS 536.364.00 457,610.11 78,753.89 431,564.21 397,355.99 34,208.22
USES/MONEY & PROP-INTEREST 13,888.00 11,341.69 2,546.31 20,738.74 9,125.20 11,613.54
OTHER SOURCES OF REVENUE 4,000.00 6,863.08 (2,863.08) 1,995.50 1,995.50
TOTAL REVENUE 554,252.00 475,814.88 78,437.12 454,298.45 408,476.69 45,821.76
**************************
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 274,300.00 158,874.27 115,425.73 198,138.51 160,355.60 37,782.91
ACTIVITY TOTAL 274,300.00 158,874.27 115,425.73 198,138.51 160,355.60 37,782.91
TRANSPORTATION
PUBLIC WORKS 4,754.00 1,224.71 3,529.29 3,277.32 2,760.97 516.35
STREET TBEE MAINTENANCE 15,944.00 8,390.99 7,553.01 7,713.24 5,654.24 2,059.00
STREET LANDSCAPE MAINTENANCE 292,861.00 200,214.34 92,646.66 231,458.34 162,243.61 69,214.73
ACTIVITY TOTAL 313,559.00 209,830,04 103,728.96 242,448.90 170,658.82 71,790.08
COMMUNITY DEVELOPMENT
ENGINEERING 16,250.00 11,752.20 4,497.80 20,071.01 19,037.56 1,033.45
ACTIVITY TOTAL 16,250.00 11,752.20 4,497.80 20,071.01 19,037.56 1,033.45
CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT 102,000.00 102,000.00
ACTIVITY TOTAL 102,000.00 102,000.00
T 0 T A L EXPENDITURES 706.109.00 380,456.51 325,652.49 460,658.42 350,051.98 110,606.44
EXCESS <REVENUE>EXPENDITURE 151,857.00 (95.358.37) 247.215.37 6,359.97 (58,424.71) 64,784.68
EXCESS <REVENUE>EXPENDITURE 151,857.00 (95,358.37) 247,215.37 6,359.97 (58.424.71) 64,784.68
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/20~2 THROUGH 05/31/2003
CAPITAL IMPROVEMENT FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D. VARIANCE
***********************
USES/MONEY & PROP-INTEREST 1,104,085.00 1,041,798.88 62,286.12 1,743,568.68 766,333.51 977,235.17
OTHER SOURCES OF REVENUE 11,180,405.00 11,180,405.00 19,685,683.29 19,685,683.29
TOTAL REVENUE: 12,284,490.00 1,041,798.88 11,242,691.12 21,429,251.97 766,333.51 20,662,918.46
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY ATTORNEY 12,950,00 18,691.06 I5,741.06)
ACTIVITY TOTAL 12,950.00 18,691.06 (5,741.06)
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 494,797.00 144,280.53 350,516.47 96,133.06 65,392.33 30,740.73
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING 2,561.31 (2,561.31) 8,585,61 8,398.57 187.04
ACTIVITY TOTAL 2,561.31 (2,561.31) 8,585.61 8,398.57 187.04
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 14,764,215.43 8.776,442.66 5,987,772.77 4,324,162.75 1,322,726.10 3,001,436.65
COMMUNITY IHPROVEMENTS
PARKS 3,416,077.00 1,081,790.90 2,334,286.10 125,589.57 106,117.02 19,472.55
STREET CONSTRUCTION/IMPROVEMENT 19,770,575.00 8,687,082.09 11,083,492.91 4,085,145.94 2,421,344.86 1,663,801.08
ACTIVITY'TOTAL 37,950,867.43 18,545,315.65 19,405,551.78 8,534,898.26 3,850,187.98 4,684,710.28
T 0 T A L EXPENDITURES 38,458,614.43 18,710,848.55 19,747,765.88 8,639,616.93 3,923,978.88 4,715,638.05
EXCESS <REVENUE>EXPENDITURE 26,174,124.43 17,669,049.67 8,505,074.76 (12,789,635.04) 3,157,645.37 (15,947,280.41)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 26,174,124.43 17,669,049.67 8,505,074.76 (12,789,635.04) 3,157,645.37 (15,947,280,41)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/0t/2002 THROUGH 05/31/2003
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
************************
SPECIAL ASSESSMENTS 207,689.64 (207,689.64) 237,264.42 202,227.39 35,037.03
USES/MONEY & PROP-INTEREST 3,698.90 (3,698.90) 8,099.29 1,767.78 6,331.51
TOTAL REVENUE 211,388.54 (211,388.54) 245,363.71 203,995.17 41,368.54
**************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 229,828.00 232,559.42 (2,731.42) 233,733.39 232,733.39 1.000.00
ACTIVITY TOTAL 229,828.00 232,559.42 (2,731.42) 233,733.39 232,733.39 1,000.00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES 229,828.00 232,559.42 (2,731.42) 233,733.39 232,733.39 1,000.00
EXCESS <REVENUE>EXPENDITURE 229,828.00 21,170.88 208,657.12 (11,630.32) 28,738.22 (40,368.54)
EXCESS <REVENUE>EXPENDITURE 229,828.00 21,170.88 208,657.12 {11,630.32) 28,738.22 (40,368.54)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 05/31/2003
INTERNAL SERVICE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D. VARIANCE
************************
USES/MONEY & PROP-INTEREST 227,059.00 178,599.72 48,459.28 262,597.72 121.730.05 140,867.67
CHARGES FOR SERVICES 1,367,268.00 1,070,321.60 296,946.40 1,103,647.14. 1,029,015.30 74,631.84
OTHER SOURCES OF REVENUE 20,000.00 17,630.53 2,369.47 22,267.13 21,076.05 1,191.08
TOTAL REVENUE 1,614,327.00 1,266,551.85 347,775.15 1,388,511.99 1,171,821.40 216,690.59
**************************
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 1,741,280.00 808,141.90 933.138.10 1,092.881.67 362,235.75 730,645.92
ACTIVITY TOTAL 1,741,280.00 808,141.90 933,138.10 1,092,881.67 362,235.75 730,645.92
PUBLIC SAFETY:
FIRE 51,818.00 40,560.59 11,257.41 41,899.88 33,676.47 8,223.41
ACTIVITY TOTAL 51,818.00 40,560.59 11,257.41 41,899.88 33,676.47 8,223.41
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 1,793,098.00 848,702.49 944,395.51 1,134,781.55 395,912.22 738,869.33
EXCESS <REVENUE>EXPENDITURE 178,771.00 (417,849.36) 596,620.36 {253~730.44) (775,909.18) 522,178.74
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 178,7~1.00 (417,849.36) 596,620.36 (253,730.44) (775,909.18) 522,178.74
THECITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES .
FOR THE PERIOD
07/01/2002 THROUGH 05/31/2003
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
************************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
***************************
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)