HomeMy WebLinkAboutItem 4.04 PrelFinRptNov2002 CITY CLERK
File # J IL II
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: December 17, 2002
SUBJECT: Preliminary Financial Reports For the Month of November 2002
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 November 2002
RECOMMENDATION: ~ Receive the reports.
FINANCIAL STATEMENT: See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report on the preliminary financial statements for the month
of November. The final audited results for Fiscal Year 2001/2002 are not yet available; therefore, this
report is presented as "preliminary" at this time. 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.
Preliminary, Reporting of Information
The auditors are completing the final phase of the fieldwork necessary for the 2001/2002 audit. The final
audit results will impact the reported Fund Balance presented in the attached monthly reports. The scope
of any remaining final entries will not be significant when compared to all general fund revenues and
expenses.
Analysis of Preliminary November 2002 Revenue and Expenditure Report
Given that this report encompasses only the first five months of the 2002/2003 Fiscal Year, there is
limited data on which to base any major projections or identify significant trends. For example, the
receipt of revenues does not typically follow an even distribution throughout the Fiscal Year. Major
amounts of Property Taxes and Sales Taxes are not received until later in the Fiscal Year. There is also a
lag with the reporting of expenditures due to the significant amount of services provided to the City by
independent contractors.
Additional Impacts resulting from Passage of State Budget for Fiscal Year 2002/2003
As previously reported in the preliminary financial reports for the month of October, and as currently
budgeted by the State, the City expects to receive the Gas Taxes, booking fee reimbursements and motor
vehicle in lieu fees from the Department of Motor Vehicles. It should be noted that the $100,000 revenue
budgeted for the Citizen's Option for Public Safety (COPS) grant for Fiscal Year 2002/2003 was received
at the end of October 2002.
COPIES TO: ITEM~O? 4
G:~Ionthly l~inaneials\112002 agenda statement monthly financialsREV, doc
The State budget situation is still precarious, Governor Davis has called the newly-elected legislature into
a rare special session beginning December 9th to review $5 billion of an estimated $21 to $30 billion
budget deficit (estimated over the next nineteen months). The Governor intends to propose program cuts
and other measures to reduce the state shortfall by $5 billion before the end of this year. Given the size of
the State Budget deficit, a combination of spending cuts and revenue enhancements will likely be required
to balance the budget. The Governor has spoken openly about curtailing spending at the State level and
has also mentioned re-visiting what is currently budgeted for Education. It is expected that more
definitive data will be available by the end of January 2003.
Therefore, due to the fact that the State may experience higher than estimated deficits for Fiscal Year
2002-2003, Staff will continue to monitor the status of the State's budget. Of critical importance
continues to be the motor vehicle in lieu fees (VLF). VLF comprises $1,937,000 million of the City's
General Fund revenue. About $1.3 million represents the "backfill" portion that is funded by the. State.
Since the final outcome for these items is still unknown, no budget adjustments are being proposed at this
time. Staff will remain vigilant and will report back to Council any subsequent adjustments to the State's
budget that have a direct financial impact to the City.
General Fund Revenues
Total General Fund Revenues collected through November are comparable to what occurred in the fifth
month of the previous Fiscal Year. Through November 2002, the City has collected approximately 30%
of the total budgeted General Fund Revenues compared to 28% in the prior Fiscal Year.
Real Property Transfer Tax is higher than in the same period of the prior year due to higher than expected
year to date proceeds from the sale of non residential properties. Transient Occupancy Taxes are lower
than in the same period of the prior year due to timing differences and lower than expected tax collections
at some of the City's hotels. 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, an increase in market value on the
City's investments, and a higher cash balance. Initially all interest revenue is recorded in the General
Fund and allocated to other funds on a pro rata basis twice a year.
Charges for Services is lower than in the same period of the prior year due to a receipt of one time monies
from AT&T for cable equipment in Fiscal Year 2001-2002. Fines and forfeitures are lower than in the
prior year due to a decrease in traffic citation collections over the prior year. Miscellaneous Revenues are
lower than in the prior year due to reimbursements received in the prior year from DSRSD for work
performed on the Dublin Boulevard Widening project.
General Fund Expenditures
Overall, through the month of November expenditures in the General Fund totaled approximately $8.8
million and represented approximately 22% of the total budgeted expenditures in the General Fund. Of
this amount, a total of approximately $2.8 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 November 2002 was
comparable to the amounts expended for the same period in the prior Fiscal Year. Through November
2002, the City had expended 22% of the General Fund Operating Budget, compared to 26% in the prior
Fiscal Year. Fire is lower than in the same period of the prior year due to timing differences for the
payment of contract fire services. Transportation is lower than in the same period of the prior year due to
timing differences for the payment of contract street sweeping services.
Health and Welfare is higher than in the same period of the prior year due to payment for contract senior
support services in the current year. 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
Planning and Engineering divisions. CaPital Improvement Projects are higher than in the same period of
the prior year due to expenditures incurred to date for construction of the City's new library. All
expenditures to date are within the authorized budget.
It is recommended that the City Cotmcil 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 November 30, 2002
lll~ 30%
Total General Fund Revenues ~,,,:: 1~8%
Property Taxes · 7% I
6O/o I
Sales Taxes · FY 2002/2003
31% [] FY 2001/2002
Real Property Transfer Tax 6%
Transient Occupancy Taxes ....
Franchise Taxes
Licenses and Permits
Interest and Rentals 94%
Intergovernmental from State
Charges fOr Services
Fines and Forfeitures
Other Revenues
0% 30% 60% 90% 120% 150%
42% of Year Complete
FY 2002/03 FY 2002/03 % of FY 200'1102 % of Total for
Budget YTD Actual Budget YTD Actual FY 2001102
Property Taxes 9,892,843 666,400 7% 527,038 6%
Sales Taxes 12,702,000 4,311,457 34% 4,432,533 35%
Real Property Transfer Tax 415,000 130,314 31% 111,104 26%
Transient Occupancy Taxes 858,000 268,370 31% 302,338 37%
Franchise Taxes 1,493,900 307,415 21% 318,558 23%
Licenses and Permits 1,622,404 1,368,582 84% 765,715 33%
Interest and Rentals 1,373,538 1,284,594 94% 506,179 26%
Intergovernmental 2,096,165 893,396 43% 811,337 41%
Charges for Services 4,815,035 1,625,358 34% 1,697,904 38%
Fines and Forfeitures 114,000 36,592 32% 47,782 40%
Other Revenues 742,768 65,504 9% 286,999 58%
Total General Fund Revenues 36,125,B53 10,957,982 30% 9,807,487 28%
City of Dublin 2002-2003 YTD Expenses and Budget Comparison
For the Period Ending November 30, 2002
Total General Fund lff~%
Expenses 26%
General Government 1333~
r
14%
Police 6%
Fire · 3%
I
126%
~_~o%
Other Public Safety 12%
~ · FY 2002/03
~ ~7% [] FY 200i/02
Transportation 32%
Health and Welfare ~ 28%
Culture & Community
Se~ces
Cemmu~i~ 3 ~%
~e~elepme~t 13{
Capital ]repros.
Projects
0% 20% 40% ~0% 80% ~ 00%
42% of Year Complete
FY 2002~03 FY 2002103 % of FY 2001/02 % of Total for
Budget YTD Actual Budget YTD Actual FY 2001102
General Government 4,393,521 1,590,722 36% 1,308,142 33%
Police 7,876,674 333,001 4% 432,690 6%
Fire 5,108,279 129,817 3% 1,239,179 26%
Other Public Safety 313,858 31,188 10% 28,215 12%
Transportation 1,337,221 354,770 27% 351,582 32%
Health and Welfare 69,001 19,187 28% 6,545 13%
Culture and Community Services 4,740,119 1,694,060 36% 1,407,913 35%
Community Development 5,774,070 1,855,518 32% 1,657,346 36%
Capital Improvement Projects 11,355,407 2,838,719 25% 1,727,321 30%
Total General Fund Expenses 40,968,150 8,846,982 22% 8,158,933 26%
General Fund Operating Expenses 29,612,743 6,008,263 20% 6,431,612 25%
ATTACHMENT 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF NOVEMBER 2002
Prepared by
The Finance Department
December 3, 2002
ATTACHMENT 3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Nov2002
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 (45,949.981) 1.437,833 283.645 38,421.303 17,489 (5.789.712) (22,080,354)
CASH WITH FISCAL AGENT 171.289 171.289 167,304
AMOUNT HELD IN ESCROW 109,300
INVESTMENTS AT COST 89,048,617 89,048,617 86.170,632
RECEIVABLES: TAXES
ACCOUNTS 138.985 357.705 496.691 157.651
INTEREST 542.48I 542.481 312,860
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 14.215 14,215 12,044
FIXED ASSETS
AMOUNT TO BE PROVIDED 1,553.500 1,553.500 1,652,500
TOTAL ASSETS 43.794.317 1.795,538 283.645 38,421.303 1,742,278 86.037.080 65,501,937
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (790.326) (790,326) (809.790)
DEPOSITS FOR AB1600 FEES (84.624) (2,862.692) (3.947,317) (23.428.282)
DEPOSITS OTHERS (909.196) (909,196) (401.353)
PAYABLES: ACCOUNTS (152.753) (102,571) (52,236) (307.561) (679.107)
INTEREST
PAYROLL (400.795) (400,795) (326.780)
DUE TO OTHERS (38.446) (38,446) (24.597)
DEFERRED REVENUE (127.768) (127,768) (146.433)
DEBT INSTRUMENTS PAYABLE (1.671.000) (1,671.000) (1.770.000)
TOTAL LIABILITIES (2.503.907) (102,571) (3,914,929) (1.671.000) (8.192,407) (27.586.342)
FUND BALANCES (41.290.409) (1.692,967) (283,645) (34.506,374) (71.278) (77,844,673) (37.915,595)
TOTAL FUND E (41,290.409) (1,692,967) (282,645) (34,506.374) (71.278) (77,844.673) (37.915,595)
TOTAL LIABILITIES/EQUITY (43,794,317) (1.795,528) (283',645) (38,421,303) (1.742.278) (86,037.080) (65.501.937)
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Nov2002
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,370,207 (20) 6,370,187 5,617,126
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 22,454,099 27,146,580 49,600,680 38,136,473
AMOUNT TO BE PROVIDED 41,183,864 41,183,864 41,566,827
TOTAL ASSETS 28,824,307 (20) 27,146,580 41,183,864 97,154,731 85,320,425
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (1)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (41,183,864) (41,183,864) (41,566,827)
TOTAL LIABILITIES (41,183,864) (41,183,864) (41,566,827)
FUND BALANCES (28,824,307) 20 (27,146,580) (55,970,867) (43,753,597)
TOTAL FUND E (28,824,307) 20 (27,146,580) (55,970,867) (43,753,597)
TOTAL LIABILITIES/EQUITY (28,824,307) 20 (27,146,580) (41,183,864) (97,154,731) (85,320,425)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH tl/30/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
PROPERTY TAXES 9,892,843.00 666,400.12 9,226 442.88 8,732,324.89 527,037.54 8,205,287.35
SALES TAX 12,702.000.00 4,311,457.30 8,390 542.70 12,813,111.10 4,432,532.98 8,380,578.12
REAL PROPERTY TRANSFER TAX 415,000.00 130,314.43 284 685.57 434,832.20 111.104.44 323,727.76
HOTEL TRANSIENT OCCUPANCY TAX 858,000.00 268 369.61 589 630.39 8t0,219.79 302,338.22 507,881.57
FRANCHISE TAXES 1,493,900.00 307 415.21 1,186 484.79 1,385,8t5.52 318,558.42 1,067,257.10
LICENSES & PERMITS 1,622,404.00 1,368 581.71 253 822.29 2,327,250.77 765,715.34 1,561,535.43
FINES & FORFEITURES 114,000.00 36 591.65 77 408.35 118,190.93 47,781.56 70,409.37
USE/MONEY & PROP-INTEREST 1,244,226.00 1,241 338.44 2 887.56 1.843,673.66 475,529.48 1,368.144.18
USE/MONEY & PROP-RENTALS 129,312.00 43 255.29 86,056.71 85,936.82 30,649.60 55,287.22
INTERGOVERNMENTAL 2,096,165.00 893 395.99 1,202~769.01 1,992,383.50 811,337,37 1,181,046.13
CHARGES FOR SERVICES 4,815,035.00 1,625 358.30 3,189,676.70. 4,464,259.66 1,697,904.25 2,766,355.41
OTHER SOURCES OF REVENUE 742,768.00 65 503.60 677,264.40' 493,722.65 286,999.48 206,723.17
TOTAL REVENUE 36,125,653.00 10.957 981.65 25,167,671.35 35,501,721.49 9,807,488.68 25,694,232.81
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 212,932.00 68,459.14 144.472.86 217.946.55 80,860.35 137,086.20
CITY MANAGER 739,518.00 278,449.32 461,068.68 560,359.16 186,086.98 374,272.18
CENTRAL SERVICES 319,600.00 104,648.19 214,951.81 297,049.71 109,653.00 187,396.71
CITY ATTORNEY 659,076.00 372,976.34 286,099.66 764,484.52 233,953.16 530,531.36
ADMIN SERVICES 1.038,223.00 375,932.98 662,290.02 922,865.72 358,947.02 563,918.70
BUILDING MANAGEMENT 731,567.00 235,914.73 495,652.27 657,327.17 195,382.03 461.945.14
INSURANCE COST CENTER 386,665.00 153,538.36 233,126.64 385,395.68 133,251.70 252,143.98
ELECTIONS COST CENTER 20,940.00 803.24 20,136.76 14,507.57 7.50 14,500.07
NON-DEPARTMENTAL 285,000.00 285,000.00 109,981.56 10,000.00 99,981.56
ACTIVITY TOTAL 4,393,521.00 1,590,722.30 2,802,798.70 3,929,917.64 1,308,141.74 2,621,775.90
PUBLIC SAFETY
POLICE 7,876.674.00 333,000.91 7,543,673.09 6,668,234.72 432,690.23 6,235,544.49
CROSSING GUARDS 71,462.00 11,636.50 59,825.50 56,677.08 10,478.65 46,198.43
ANIMAL CONTROL 181,437.00 t81,437.00 138,935.98 138,935.98
DISASTER PREPAREDNESS 60,959.00 19,551.19 ' 41,407.81 46,012.48 17,735.86 28,276.62
FIRE SERVICES 5,108,279.00 129,816.90 4,978.462.10 4,698,607.54 1,239,179.37 3,459,428.17
ACTIVITY TOTAL 13,298,811.00 494,005.50 12,804,805.50 11,608,467.80 1,700,084.11 9,908,383.69
TRANSPORTATION
PUBLIC WORKS 616,631.00 206,637.91 409,993.09 557,207.53 209,075.60 348,131.93
STREET MAINTENANCE 10,427.00 . 194.78 10,232.22 6,406.00 510.15 5,895.85
STREET SWEEPING 132,100.00 28,773.00 103,327.00 132,383.34 42,888.38 89.494.96
STREET TREE MAINTENANCE 70,337.00 14,519.99 55,817.01 51,079.02 10,111.06 40,967.96
STREET LANDSCAPING MAINTENAN 507,726.00 104,644.41 403,081.59 347,022.86 88,996.51 258,026.35
ACTIVITY TOTAL 1,337,221.00 354,770.09 982,450.91 1,094,098.75 351,581.70 742,517.05
HEALTH & WELFARE
WASTE MANAGEMENT 8,242.00 3,539.00 4,703.00 1,807.38 46.38 1,761.00
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 11/30/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
CHILD CARE 15,000.00 4,211.00 10,789.00 15,000.00 2,599.00 12,401.00
SOCIAL SERVICES 6,000.00 6,000.00
HOUSING PROG~MS 39,759,00 5,436.78 34,322.22 35,209.87 3,900.00 31.309.87
ACTIVITY TOTAL 69,001.00 19.186.78 49,814.22 52,017.25 6,545.38 45,471.87
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 496,219.00 119,829.50 376,389.50 376,276.00 100,18t.25 276.094.75
CULTURAL ACTIVITIES 137,153.00 69,792.93 67,360.07 119,409.29 80,619.87 38.789.42
HERITAGE CENTER 90,771.00 31,890.84 58,880.16 69,08t.56 20,217.04 48,864.52
DUBLIN CEMETERY 37,418.00 8 972.84 28,445.16 30,077.98 7,532.50 22,545.48
PARK MAINTENANCE 1,263,230.00 372 834.62 890,395.38 1,086,713.48 277,920.80 808,792.68
COMMUNITY TV 70,906.00 66 317.72 4,588.28 80,087.02 56,957.00 23,130.02
RECREATION ADMIN 453,444.00 163 730.34 289,713.66 374,416.72 124,322.27 250 094.45
PLAYGROUNDS 261,690.00 89 668.44 172,021.56 207,515.47 81,766.71 125 748.76
SHANNON CENTER 270,182.00 97 118,44 173,063.56 250,834.31 83,690.19 167 144.12
PRESCHOOL 79,421.00 29 552.07 49,868.93 57,470.25 21,632,85 35 837.40
TEENS PROGRAM 113,854.00 35 796.87 78.057.13 106,183.40 39 294,51 66 888.89
ADULT SPORTS 95,061.00 38 261.42 56,799.58 76,886.84 30 224.21 46 662.63
YOUTH SPORTS 96,743.00 32 489.63 64,253.37 82,402.67 26 883.1t 55 519.56
COMMUNITY GYM 35,167.00 9 170.61 25,996.39 23,572.33 5 762.50 17 809.83
SPECIAL EVENTS 349,589.00 157 947.82 191,641.18 314,735.18 148 766.82 t65 968.36
SENIOR CENTER 190,215.00 62,346.35 127,868.65 146,824.25 52 080.48 94,743.77
RECREATION INSTRUCTION 143,005.00 68,090.79 74,914.21 145,812.50 58 864.10 86.948.40
AQUATICS 332,691.00 162,335.86 170,355.14 322,391.18 147 937.41 174,453.77
PARKS/FACILITIES MANAGEMENT 223,360.00 77,913.22 145,446.78 142,041.19 43 259.00 98,782.19
ACTIVITY TOTAL 4,740.119.00 t,694,060.31 3,046,058.69 4,012,731.62 1,407,912.62 2,604,819.00
COMMUNITY DEVELOPMENT
PLANNING 2,011,188.00 595,919.71 1,415.268.29 1,486.541.67 545,651.10 940,890.57
BUILDING SAFETY 1,563,701.00 458,747.30 1,104,953.70 1,276,343.20 450,697.97 825,645.23
ENGINEERING 1,902,477'.00 649,833,36 1,252,643.64 1,609,544.48 523,533.01 1,086,011.47
ECONOMIC DEVELOPMENT 296,704.00 151,017.51 145,686.49 '271,222.90 137,463.91 133,758.99
ACTIVITY TOTAL 5,774,070.00 1,855,517.88 3,918,552.t2 4,643,652.25 1,657,345.99 2,986,306.26
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 6,952,517.30 2,584,388.98 4,368,128.32 4,582,889.35 1,393,128.57 3,189,760.78
COMMUNITY IMPROVEMENTS 1,814,645.00 134,182.95 1,680,462.05 273,283.82 41,433.78 231,850.04
PARKS 1,591,426.00 71,228.95 1.520,197.05 351,854.08 68,486.81 283,367.27
STREET CONSTRC/IMPROVEMENTS 996,819.00 48,917.62 947,901.38 580,008.92 224,271.53 355,737.39
ACTIVITY TOTAL 11,355,407.30 2,838,718.50 8,5'16,688.80 5,788,036.17 1,727,320.69 4,060,715.48
TOTAL EXPENDITURES 40,968,150.30 8,846,981.36 32,121,168.94 31,128,921.48 8,158,932.23 22,969,989.25
EXCESS REVENUE (EXPENDITURES) (4,842,497.30) 2,111.000.29 (6,953.497.59) 4,372.800.01 1,648,556.45 2,724,243.56
TRANSFERS IN FROM OTHER FUNDS 16,784.89 16,784.89
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES (4,842,497.30) 2,1t1,000.29 (6,953,497.59) 4,389,584.90 1,648,556.45 2,741,028.45
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 11/30/2002
SPECIAL REVENUE FUNDS
CURRENT 'CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D, VARIANCE
************************
PROPERTY TAXES 93,610.00 93,610.00 91.099.68 91,099.68
SALES TAX/OTHER TAXES 317,700.00 134,667.17 183,032.83 206,812.62 65,903.71 140 908.91
FINES & FORFEITURES 153,000.00 29,196.64 113,803.36 149,023.41 32.069.83 116 953.58
USES/MONEY & PROPERTY 50,995.00 50.995.00 135.432.87 135 432.87
INTERGOVERNMENTAL FROM STATE 4,516,742.00 1,348,550.84 3,168.191.16 1,601,090.43 431,032.92 1,170 057.51
INTERGOVERNMENTAL FROM COUNTY 240,909.00 52,711.25 188,197.75 241,589.50 54,082.00 187 507.50
INTERGOVERNMENTAL FROM FEDE~L '242,461.00 60,723.72 181,737.28 778,796.26 20,195.00 758 601.26
CHARGES FOR SERVICES 885,779.00 885,779.00 865,790.08 865 790.08
OTHER SOURCES OF REVENUE 5,000.00 5,000.00 30,997.14 7,570.13 23 427.01
TOTAL REVENUE 6,506,196.00 1,635,849.62 4,870,346.38 4,100,631.99 610,853.59 3.489 778.40
**************************
PUBLIC SAFETY:
POLICE 205,727.00 26,485.12 179,241.88 377,390.52 70,696.20 306,694.33
TRAFFIC SIGNALS & STREET LTG 145~900.00 37,600.70 108,299.30 145,399.20 18.294.76 127,104.44
FIRE SERVICES 213,873.00 254.88 213.618.12 193,800.29 55.413.89 138,386.40
ACTIVITY TOTAL 565,500.00 64,340.70 501,159.30 716,590.02 144,404.85 572,185.17
TRANSPORTATION:
STREET MAINTENANCE 219,619.00 37.344.14 182,274.86 209,801.34 20,430.16 189,371.18
STREET SWEEPING
ACTIVITY TOTAL 219,6t9.00 27,344.14 182,274.86 209,801.34 20,430.16 189,371.18
HEALTH & WELFARE:
WASTE MANAGEMENT 1,079,569.00 260.68 1,079,308.32 1.030,807.37 4,124.70 1,026,682.67
SOCIAL SERVICES 28,427.00 4,397.11 24,029.89 7,500.00 1,875.00 5,625.00
HOUSING PROGRAMS 9.999.54 2,496.40 7,503.14
ACTIVITY TOTAL 1,107,996.00 4,657.79 1,103,338.21 1,048,306.91 8,496.10 1,039,810.81
COMMUNITY DEVELOPMENT:
ENGINEERING 6,000.00 209.50 5,790.50 6,000.00 1,001.00 4,999.00
ACTIVITY TOTAL 6,000.00 209.50 5,790.50 6,000.00 1,001.00 4.999.00
CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS
COMMUNITY PROJECTS 36,782.00 36,782.00 73,425.55 18,688.96 54,736.59
PARKS 426,095.00 426,095.00
STREET CONSTRUCTION/IMPROVEMENT 4,838,395.00 1,498,516.80 3,339.878.20 2,259.994.81 722,277.75 1,537,717.06
ACTIVITY TOTAL 5,301.272.00 1,498,516.80 3,802,755.20 2,333,420.36 740,966.71 1,592,453.65
T 0 T A L EXPENDITURES 7,200,387.00 1.605,068.93 5.595,318.07 4,314,t18.63 9t5.298.82 3,398,819.81
EXCESS <REVENUE>EXPENDITURE 694,191.00 (30,780.69) 724,971.69 213,486.64 304,445.23 (90,958.59)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 849,931.16 (849,931.16) 16,784.89 16,784.89
EXCESS <REVENUE> EXPENDITURE 694,191.00 819,150.47 (124,959.47) 230,271.53 304,445.23 (74,173.70)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 11/30/2002
SPECIAL ASSESSMENT FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
************************
SPECIAL BENEFITS ASSESSMENTS 536,$64.00 (264.03) 536,628.03 431,564.21 431,564.21
USES/MONEY & PROP-INTEREST 13,888.00 13,888.00 20,738.74 20,738.74
OTHER SOURCES OF REVENUE 4,000.00 5,070.54 (1,070.54) 1,995.50 1,995.50
TOTAL REVENUE 554,252.00 4.806.51 549,445.49 454,298.45 454,298.45
**************************
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 274,300.00 61,419.22 212,880.78 198.t38.51 50,500.90 147,637.61
ACTIVITY TOTAL 274,300.00 61,419.22 212,880.78 198,138.51 50,500.90 147,637.61
TRANSPORTATION
PUBLIC WORKS 4,754.00 587.65 4,t66.35 3,277.32 1,445.63 1,831.69
STREET TREE MAINTENANCE 15,944.00 5,514.82 10,429.18 7,713.24 2,713.14 5.000.10
STREET LANDSCAPE MAINTENANCE 292,861.00 93,494.49 199,366.51 231,458.34 54,850.75 176,607.59
ACTIVITY TOTAL 313.559.00 99,596.96 213,962.04 242,448.90 59,009.52 183,439.38
COMMUNITY DEVELOPMENT
ENGINEERING 16,250.00 4,335.84 1t,914.16 20.071.01 10,220.76 9,850.25
ACTIVITY TOTAL 16,250.00 4,335.84 11,914.16 20,071.01 10,220.76 9,850.25
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 165,352.02 540,756.98 460,658.42 119731.18 340,927.24
EXCESS <REVENUE>EXPENDITURE 151,857.00 160,545.51 (8,688.51) 6,359.97 119,731.18 (113,371.21)
EXCESS <REVENUe>EXPENDITURE 151,857.00 160,545.51 (8,688.51) 6,359.97 119,731.18 (t13,371.21)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 11/30/2002
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,104,085.00 1,743,568.68 1,743,568.68
OTHER SOURCES OF REVENUE 11,180,405.00 11,180,405.00 19,685,683.29 19,685.683.29
TOTAL REVENUE: t2,284,490.00 12,284,490.00 21,429,251.97 21,429,251.97
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY ATTORNEY 12,950.00 3,964.92 8,985.08
ACTIVITY TOTAL 12,950.00 3,964.92 8,985.08
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 214,797.00 43,133.02 171,663.98 96,133.06 1,684.60 94,448.46
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING 2,561.31 (2,561.31) 8,585.61 8,049.60 536.01
ACTIVITY TOTAL 2,561.31 (2,56t.31) 8,585.61 8,049.60 536.01
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 10,722,986.43 1,132,664.35 9,590,322.08 4,324,162.75 202,193.84 4,121,968.91
COMMUNITY IMPROVEMENTS
PARKS 3,4t6,077.00 662,833.95 2,753,243.05 125,589.57 125,589.57
STREET CONSTRUCTION/IMPROVEMENT t9,770,575.00 3,967,236.46 15,803,338.54 4,085,145.94 1,353,394.86 2,731,751.08
ACTIVITY TOTAL 33,909,638.43 5,762,734.76 28,146,903.67 8,534,898.26 1,555,588.70 6,9791309.56
T 0 T A L EXPENDITURES 34,137,385,43 5,812,394.01 28,324,991.42 8,639,616.93 1,565,322.90 7,07&,294~03
EXCESS <REVENUE>EXPENDITURE 21,852,895.43 5,812,394.01 16,040,501.42 (12,789,635.04) 1,565,322.90 (14,354,957.94)
TRANSFER IN FROM OTHER FUNDS
T~NSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 21,852,895.43 5,812,394.01 16,040,501.42 (12,789,635.04) 1,565,322.90 (14,354,957.94)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 11/30/2002
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE' FISCAL YEAR Y.T.D. .VARIANCE
************************
SPECIAL ASSESSMENTS 237.264.42 237,264.42
USES/MONEY & PROP-INTEREST 767.13 (767,13) 8,099.29 490.25 7,609.04
TOTAL REVENUE 767.13 (767.13) 245,363.71 490.25 244,873.46
**************************
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 229,828.00 170,019.80 59,808.20 233,733.39 167,544.06 66,189.33
ACTIVITY TOTAL 229,828,00 170,019,80 59,808.20 233,733.39 167.544.06 66,189.33
PUBLIC SAFETY:
TPJNNSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES 229,828.00 170,019.80 59,808.20 233,733.39 167,544.06 66,189.33
EXCESS <REVENUE>EXPENDITURE 229,828.00 169,252.67 60.575.33 (11,630.32) 167,053.81 (178,684.13)
EXCESS <REVENUE>EXPENDITURE 229,828.00 169,252.67 60,575.33 (i1.630,32) 167,053.81 (178,684.13)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 11/30/2002
INTERNAL SERVICE FUNDS
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
************************
USES/MONEY & PROP-INTEREST 227,059.00 227,059.00 262,597.72 262,597.72
CHARGES FOR SERVICES 1,367,268.00 440,245.82 927,022.18 1,103,647.14 467.978.50 635,668.64
OTHER SOURCES OF REVENUE 20,000.00 13,560.00 6.440.00 22,267.13 12,802.54 9,464.59
TOTAL REVENUE 1,6t4,327.00 453,805.82 1,160,521.18 1,388,511.99 480,781.04 907,730.95
**************************
GENEP. AL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 1.741,280.00 384,347.07 1,356,932.93 1,092,881.67 232,239.66 860,642.01
ACTIVITY TOTAL 1,741,280.00 384,347.07 1,356,932.93 1,092,,881.67 232.239.66 860,642.01
PUBLIC SAFETY:
FIRE 5t,818.00 12,478.21 39,339.79 41.899.88 41,899.88
ACTIVITY TOTAL 51,818.00 12,478.21 39,339.79 41,899.88 41,899.88
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 1,793.098.00 396,825:28 1,396.272.72 1,134,781.55 232,239.66 902,541.89
EXCESS <REVENUE>EXPENDITURE 178,771.00 (56,980.54) 235,751.54 (253.730.44) (248,541.38) (5,189.06)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 178,771.00 (56,980.54) 235,751.54 (253,730.44) (248,541.38) (5,189.06)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2~02 THROUGH 11/30/2002
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)