HomeMy WebLinkAbout4.08 FinRptJuly2002 CITY CLERK FILE #330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: September 3, 2002
SUBJECT: Preliminary Financial Reports For the Month of July 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 .
~e'~l~ 3. Financial Statements for the Month of July 2002
REcOMMENDATION~~NT~ 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 July. The final audited results for Fiscal Year 2001/2002 are not yet available; therefore, this report is
presented as "preliminary" at this time. Preliminary Financial Results for Fiscal Year 2001-2002 (subject
to adjustments from the City's annual audit) will be presented at the October 15, 2002 Council meeting.
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, Reportinl~ of Information
In September 2002, the auditors will start the final phase of thc fieldwork necessary for the 2001/2002
audit. The final audit results will impact the reported Fund Balance presented in the attached monthly
reports. Staff has not yet made the final year-end accrual for sales tax, but anticipates the final entries will
occur by thc time the October report is presented. The scope of any remaining final entries will not be
significant when compared to all general fund revenues and expenses.
Analysis of Preliminary July 2002 Revenue and Expenditure Report
Given that this is only the first month of the 2002/2003 Fiscal Year, there is extremely 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.
General Fund Revenues
Total General Fund Revenues collected through July are comparable to what occurred in the first month of
the previous Fiscal Year. Through July 2002, the City had collected approximately 4% of the total
budgeted General Fund Revenues, which was similar to the percentage collected in the prior Fiscal Year.
COPIESTO: ~. ~
G:\Monthly Financials~FY 2001-02\072002 agenda statement monthly financials.doc ITEM
General Fund Expenditures
Overall, through the month of July expenditures in the General Fund totaled $387,260 and represented
approximately 1% of the total budgeted expenditures in the General Fund. Of this amount, a total'of
$2,451 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 July 2002 was comparable
to the amounts expended for the same period in the prior Fiscal Year. As of July 31, 2002, the City had
expended 1% of the General Fund Operating Budget compared to 2% in the prior Fiscal Year. As
previously noted there are some timing differences with payment for contract services, which complicate
comparisons from one year to the next. 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 July 31, 2002
Total General Fund Revenues 14%~
Property Taxes 0%
0%
· FY 2002/2003
0% [] FY 2001/2002
Real Pr. operty Transfer Tax 0%
Transient Occupancy Taxes 0%
0%
Franchise Taxes
Licenses and Permits 111~ol/3%
/7%
Interest and Rentals i1~o°
Intergovernmental from State ~7%
Charges for Services
Fines and Forfeitures
Other ReVenues
0% 30% 60% 90% 120% 150%
8% of Year Complete
FY 2002~03 FY 2002~03 % of FY 2001102 % of Total for
Budget ' YTD Actual Budget YTD Actual FY 2001/02
Property Taxes 9,892,843 0 0% 0 0%
Sales Taxes 12,702,000 868,000 7% 860,500 7%
Real Property Transfer Tax 415,000 0 0% 0 0%
Transient Occupancy Taxes 858,000 0 0% 0 0%
Franchise Taxes 1,493,900 0 0% 0 0%
Licenses and Permits 1,622,404 214,897 13% 168,702 7%
Interest and Rentals 1,373,538 18,125 1% 45,449 1%
Intergovernmental 2,073,765 171,349 8% 133,232 7%
Charges for Services 4,752,535 149,045 3% 112,697 3%
Fines and Forfeitures 114,000 5,177 5% 6,709 6%
Other Revenues 742,768 594 0% 29,284 6%
Total General Fu nd Revenues 36,040,753 1,427,187 4% 1,356,573 4%
Date Pi'i,.: 8/20/2002 10:35AM ATTACHMENT I
City of Dublin 2002-2003 YTD Expenses and Budget Comparison
For the Period Ending July 31, 2002
Total General Fund 11%
Expenses 1 2%
General Government l]2;~o
0%
Police ]1%
0%
Fire 0%
11%
Other Public Safety J 1% · FY 2002/03
L1% [] FY 2001/02
Transportation / 2%
O%
Health and Welfare 0%
Culture & Community 12%
Services--A.__j 4 ~
Community 1~2;~°
Development
Capital Improv. 0%
Projects 1%
0% 20% 40% 60% 80% 100%
8% of Year Complete
FY 2002103 FY 2002~03 % of FY 2001102 % of Total for
Budget YTD Actual Budget YTD Actual FY 2001102
General Government 4,393,521 104,146 2% 114,296 3%
Police 7,876,674 19,751 0% 41,642 1%
Fire 5,108,279 18,797 0% 17,925 0%
Other Public Safety 313,858 1,891 1% 2,666 1%
Transportation 1,337,221 18,204 1% 27,279 2%
Health and Welfare 69,001 39 0% 0 0%
Culture and Community services 4,740,119 106,123 2% 166,336 4%
community Development 5,713,241 115,858 2% 144,304 3%
Capital Improvement Projects 11,139,216 2,451 0% 47,709 1%
Total General Fu nd Expenses 40,691,130 387,260 1% 562,157 2%
General Fund Operating Expenses 29,551,914 384,809 1% 514,448 2%
o ............. ATTACHMENT 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF JULY 2002
Prepared by
The Finance Department
August 20, 2002
ATTACHMENT 3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Ju12002
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 (50,301,614) 2,344.591 462,867 42,457,146 184,777 (4,852,233) (25,845,735)
CASH WITH FISCAL AGENT 170,522 170,522 170,522
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST 95,195,187 95,1~95,187 94,923,499
RECEIVABLES: TAXES
ACCOUNTS (NE 149,114 59,897 209,011 939,953
INTEREST 542,481 542.481 823,625
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 15.744 15,744 15,759
FIXED ASSETS
AMOUNT TO BE PROVIDED 1,553,500 1,553,500 1,553,500
TOTAL ASSETS 45.600.911 2.404,488 462,867 42.457,146 1,908,799 92,834,212 72,581,123
· LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (870.779) (870,779) (662.961)
DEPOSITS FOR AB1600 FEES (6,870) (47,278,687) (47,285,557) (24,790.232)
DEPOSITS OTHERS (899,302) (899.302) (893,712)
PAYABLES: ACCOUNTS (4,883,741) (571,687) (34,876) (1,137,600) (6,627,904) (7,604,761)
INTEREST
PAYROLL (406,574) (406.574) (652,884)
DUE TO OTHERS (149,855) (149,855) (51,144)
DEFERRED REVENUE (127,768) (127,768) (146,433)
DEBT INSTRUMENTS PAYABLE (1,671,000) (1,671,000) (1,671,000)
TOTAL LIABILITIES (7,344,889) (571.687) (34,876) (48,416,287) (1.671,000) (58,038,739) (36,473,128)
FUND BALANCES (38,256,023) (1,832.801) (427,991) 5,959,141 (237,799) (34,795,472) (36,107,994)
TOTAL FUND E (38,256,023) (1,832,801) (427,991) 5,959,141 (237,799) (34,795,472) (36,107,994)
TOTAL LIAB. FND BAL. RETD (45.600,911) (2,404,488) (462,867) (42,457,146) (1,908,799) (92,834,212) (72,581,123)
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Ju12002
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,243,892 6,243,892 6,230,889
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE 1,191
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 22,149,264 15,987,209 38,136,473 38,136,473
AMOUNT TO BE PROVIDED 41,191,031 41,191,031 41,191,031
TOTAL ASSETS 28,393,156 15,987,209 41,191,031 85,571,396 85.559,585
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (18,025) (18,025) (40,026)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (41,191,031) (41,191,031) (41,191,031)
TOTAL LIABILITIES (18,025) (41,191,031) (41,209,057) (41,231,057)
FUND BALANCES (28,375,131) (15,987,209) (44,362,339) (44,328,527)
TOTAL FUND E (28,375,131) (15,987,209) (44,362,339) (44,328,527)
TOTAL LIAB. FND BAL. RETD (28,393,156) (15,987,209) (41,191,031) (85.571,396) (85,559~585)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 07/31/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY TAXES 9,892,843.00 9,892,843.00 8,534,344.98 8,534,344.98
SALES TAX 12,702,000.00 868,000.00 11,834,000.00 12,042,175.86 860,500.00 11,181,675.86
REAL PROPERTY TRANSFER TAX 415,000.00 415 000.00 434,832.20 434,832.20
HOTEL TRANSIENT OCCUPANCY TAX 858,000.00 858 000.00 810,219.79 810,219.79
FRANCHISE TAXES 1,493,900.00 1,493 900.00 1,385,815.52 ' 1,385,815.52
LICENSES & PERMITS 1,622,404.00 214,897.37 1,407 506.63 2,327,250.77 168,701.81 2,158,548.96
FINES & FORFEITURES 114,000.00 5,177.39 108 822.61 118,190.93 6,708.92 111,482.01
USE/MONEY & PROP-INTEREST 1.244.226.00 10,708.37 1,233 517.63 3,045,456.98 29,729.10 3,005,727.88
USE/MONEY & PROP-RENTALS 129,312.00 7,417.05 121 894.95 85,936.82 5,719.95 80,216.87
INTERGOVERNMENTAL 2,073,765.00 171,349.28 1:902 415.62 1,992.383.50 133,231.52 1,859,151.98
CHARGES FOR SERVICES 4,752,535.00 149,045.40 4,603 489.60 4,438,862.97 112,696.85 4,326,166.12
OTHER SOURCES OF REVENUE 742,768.00 594.42 742 173.58 493,613.32 29,283.81 464,329.51
TOTAL REVENUE 36,040.753.00 1,427,189.38 34,613 563.62 35,709,083.64 1,356,571.96 34,352,511.68
**************************
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 212,932.00 12,410.42 200,521.58 237,205.60 12,257.18 224,948.42
CITY MANAGER 739,518.00 29,380.14 710,137.86 560,167.97 27,063.21 533,104.66
CENTRAL SERVICES 319,600.00 12,574.90 307,025.10 296,797.94 14.308.90 282.489.04
CITY ATTORNEY 659,076.00 481.62 658,594.38 764,454.52 764,454.52
ADMIN SERVICES 1,038,223.00 34,749.78 1,003,473.22 921,274.72 50,760.22 870,514.50
BUILDING MANAGEMENT 731,567.00 14,549.05 717,017.95 657,227.17 9,369.17 647,958.00
INSURANCE COST CENTER 386,665.00 386,665.00 371,825.68 537.55 371,288.13
ELECTIONS COST CENTER 20,940.00 20,940.00 14,507.57 14,507.57
NON-DEPARTMENTAL 285,000.00 285,000.00 109,981.56 109,981.56
ACTIVITY TOTAL 4,393,521.00 104,145.91 4,289,375.09 3,933,542.73 114,296.33 3,819,246.40
PUBLIC SAFETY
POLICE 7,876,674.00 19,751.10 7,856,922.90 6,668.245.51 41,641.73 6,626,603.78
CROSSING GUARDS 71,462.00 71,462.00 56,677.08 56,677.08
ANIMAL CONTROL 181,437.00 181,437.00 111,543.64 111,543.64
DISASTER PREPAREDNESS 60,959.00 1,891.07 59,067.93 46.296.56 2,665.70 43,630.86
FIRE SERVICES 5,108,279.00 18,797.46 5,089,481.54 4,712,110.22 17,925.04 4,694,185.18
ACTIVITY TOTAL 13,298,811.00 40,439.63 13,258,371.37 11,594,873.01 62,232.47 11,532,640.54
TRANSPORTATION
PUBLIC WORKS 616,631.00 18,203.64 598,427.36 557,030.88 27,279.48 529,751.40
STREET MAINTENANCE 10,427.00 10,427.00 10,782.69 10,782.69
STREET SWEEPING 132,100.00 132,100.00 132,383.34 132,383.34
STREET TREE MAINTENANCE 70,237.00 70,337.00 51,079.02 51,079.02
STREET LANDSCAPING MAINTENAN 507,726.00 507,726.00 347,022.86 347,022.86
ACTIVITY TOTAL 1.337,221.00 18,203.64 1,319.017.36 1,098,298.79 27,279.48 1,071,019.31
HEALTH &'WELFARE
WASTE MANAGEMENT 8,242.00 39.00 8,203.00 444,976.68 444,976.68
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
fOR THE PERIOD
07/01/2002 THROUGH' 07/31/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
CHILD CARE 15,000.00 15,000.00 15,134.00 15,134.00
SOCIAL SERVICES 6,000.00 6,000.00
HOUSING PROG~MS 39,759.00 39,759.00 35,209.87 35,209.87
ACTIVITY TOTAL 69,001.00 39.00 68,962.00 495,320.55 495,320.55
CULTURE & LEISURE SERVICES
LIB~RY SERVICES 496 219.00 496,219.00 376,276.00 376,276.00
CULTU~L ACTIVITIES 137 153.00 2,164.41 134,988.59 119,409.29 50,136.31 69,272.98
HERITAGE CENTER 90 771.00 2,795.12 87,975.88 69,056.56 2,144.57 66,911.99
DUBLINCEMETERY 37 418.00 37,418.00 30,077.98 30,077.98
PARK MAINTENANCE 1,263 230.00 1,263,230.00 1,083,462.48 1,083,462.48'
COMMUNITY TV 70 906.00 70,906.00 78,460.21 78,460.21
RECREATION ADMIN 453 444.00 17,322.03 436,121.97 374,078.21 18,729.49 355,348.72
PLAYGROUNDS 261 690.00 10,895.75 250,794.25 207,341.75 13,303.39 194,038.36
SHANNON CENTER 270 182.00 6,978.58 263,203.42 251,159.62 8,633.48 242,526.14
PRESCHOOL 79,421.00 2,248.89 77,172.11 57,008.25 3,154.63 53,853.62
TEENS PROG~M 113,854.00 3,867.25 109,986.75 106,063.36 5,426.11 100,637.25
ADULT SPORTS 95,061.00 2,549.73 92.511.27 74,518.54 2,681.05 71,837.49
YOUTH SPORTS 96,743.00 2,120.58 94,622.42 82,392.72 2.710.01 79,682.71
COMMUNITY GYM 35,167.00 1,094.61 34,072.39 23,572.33 1,212.05 22,360.28
SPECIAL EVENTS 349,589.00 16,173.28 333,415.72 314,227.68 18,216.27 296,011.41
SENIOR CENTER 190,215.00 5,485.56 184,729.44 146,354.60 8,541.25 137,813.25
RECREATION INSTRUCTION 143,005.00 2,589.37 140,415.63 145,812.50 3,696.26 142,116.24
AQUATICS 332,691.00. 22,057.11 310,633.89 322,216.86 21,470.89 300.745.97
PARKS/FACILITIES MANAGEMENT 223,360.00 7,780.95 215,579.05 141,953.78 6,280.60 135,673.18
ACTIVITY TOTAL 4,740,119.00 106,123.22 4,633,995.78 4;003,442.72 166,336.46 3,837,106.26
COMMUNITY DEVELOPMENT
PLANNING 2,011,188.00 45,299.64 1,965,888~36 1,483,053.95 62,268.18 1,420,785.77
BUILDING SAFETY 1,563,701.00 22,325.73 1,541,375.27 1,276,106.10 23,749.47 1,252,356.63
ENGINEERING 1,852,477.00 42,275.02 1,810,201.98 1,604,117.58 50,989.45 1,553,128.13
ECONOMIC DEVELOPMENT 285.875.00 5,957.59 '279,917.41 271,136.53 7,296.81 263,839.72
ACTIVITY TOTAL 5,713,241.00 115,857.98 5,597,383.02 4,634.414.16 144,303.91 4,490,110.25
CAPITAL IMPROVEMENT PROJECTS
GENE~L CIP PROJECTS 6,939,521.00 967.04 6,938,553.96 6,318,782.88 46,932.82 6,271,850.06
COMMUNITY IMPROVEMENTS 1,774,943.00 127.28 1,774,815.72 273,283.82 273,283.82
PARKS 1,433,135.00 1,433,135.00 351,854.08 251.60 351,602.48
STREET CONSTRC/IMPROVEMENTS 991,617.00 1,356.68 990,260.32 580,489.68 524.41 579,965.27
ACTIVITY TOTAL 11,139,216.00 2,451.00 11,136,765.00 7,524,410.46 47,708.83 7,476,701.63
TOTAL EXPENDITURES 40.691,130.00 387,260.38 40,303,869.62 33,284,302.42 562,157.48 32,722,144.94
EXCESS REVENUE (EXPENDITURES) (4,650,377.00) 1,039.929.00 (5,690,306.00) 2,424,781.22 794,414.48 1,630,366.74
TRANSFERS IN FROM OTHER FUNDS 1,488.54 1,488.54
TF~ANSFERS OUT FROM OTHER FUNDS.
REVENUES OVER(UNDER) EXPENDITURES (4,650,377.00) 1,039,929.00 (5,690,306.00) 2,426,269.76 794,414.48 1,631,855.28
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 07/31/2002
SPECIAL REVENUE ,FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
PROPERTY TAXES 93,610.00 93.610.00 89,809.03 89 809.03
SALES TAX/OTHER TAXES 317,700.00 18,347.59 299,352.41 201,273.17 15,439.75 185 833.42
FINES & FORFEITURES 153,000.00 153,000.00 149,023.41 149 023.41
USES/MONEY & PROPERTY 50,995.00 50,995.00 65.404.41 65 404.41
INTERGOVERNMENTAL FROM STATE 4,516,742.00 4,516,742.00 1.148,613.90 1,148 613.90
INTERGOVERNMENTAL FROM COUNTY 240,909.00 240,909.00 216,782.25 216 783.25
INTERGOVERNMENTAL FROM FEDERAL 222,809.00 222,809.00 289,566.21 289 566.21
CHARGES FOR SERVICES 885,779.00 885,779.00 852,087.78 852 087.78
OTHER SOURCES OF REVENUE 5,000.00 5,000.00 30,997.14 30 997.14
TOTAL REVENUE 6,486,544.00 18,347.59 6,468,196.41 3,043,558.30 15,439.75 3,028 118.55
*******EXPENDITURES*******
PUBLIC SAFETY:
POLICE 205.727.00 205,727.00 371,297.61 1.338.34 369,959.27
TRAFFIC SIGNALS.& STREET LTG 145,900.00 145,900.00 145.399.20 145,399.20
FIRE SERVICES 213,873.00 212,873.00 193,800.29 193,800.29
ACTIVITY TOTAL 565,500.00 565,500.00 710,497.10 1,338.34 709.158.76
TRANSPORTATION:
STREET MAINTENANCE 219,619.00 219,619.00 198,638.05 198.638.05
STREET SWEEPING
ACTIVITY TOTAL 219,619.00 219,619.00 198,638.05 198,638.05
HEALTH & WELFARE:
WASTE MANAGEMENT 1,079,569.00 1,079,569.00 587,638.07 587,638.07
SENIOR SUPPORT CARE 28,427.00 28,427.00 7,500.00 7,500.00
HOUSING PROGP, AMS 9,999.54 9,999.54
ACTIVITY TOTAL 1,107,996.00 1,107,996.00 605,137.61' 605,137.61
COMMUNITY DEVELOPMENT:
ENGINEERING 6,000.00 6,000.00 3,322.30 1,001.00 2,321.30
ACTIVITY TOTAL 6,000.00 6,000.00 3,322.30 1,001.00 2,321.30
CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS
COMMUNITY PROJECTS 36,782.00 36,782.00 73,425.55 73,425.55
PARKS 426,095.00 426,095.00
STREET CONSTRUCTION/IMPROVEMENT 3,932,073.00 3,268.12 3,928,804.88 2,381,255.78 288.20 2,380,967.58
ACTIVITY TOTAL 4,394,950.00 3,268.12 4,391,681.88 2,454,681.33 288.20 2,454,393.13
T 0 T A L EXPENDITURES 6,294,065.00 3,268.12 6,290,796.88 3,972,276.39 2,627.54 3,969,648.85
EXCESS <REVENUE>EXPENDITURE (192,479.00) (15,079.47) (177,399.53) 928,718.09 (12,812.21) 941,530.30
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 1,488.54 1,488.54
EXCESS <REVENUE> EXPENDITURE (192,479.00) (15,079.47) (177,399.53) 930,206.63 (12,812.21) 943,018.84
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 07/21/2002
SPECIAL ASSESSMEN FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
***********************
SPECIAL BENEFITS ASSESSMENTS 536,364.00 536,364.00 427,577.38 427,577.38
USES/MONEY & PROP-INTEREST 13,888.00 13,888.00 9,818..32 9,818.32
OTHER SOURCES OF REVENUE 4,000.00 4.000.00 1,995.50 1,995.50
TOTAL REVENUE 554,252.00 554,252.00 439,391.20 439,391.20
**************************
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 274,300.00 1,200.00 273,100.00 198,138.51 1.200.00 196,938.51
ACTIVITY TOTAL 274,300.00 1,200.00 273,100.00 198,138.51 1,200.00 196,928.51
TRANSPORTATION
PUBLIC WORKS 4,754.00 90.60 4,663.40 3,279.23 196.15 3,083.08
STREET TREE MAINTENANCE 14,734.00 14,734.00 7,713.24 7,713.24
STREET LANDSCAPE MAINTENANCE 292,861.00 292,861.00 231,458.24 221,458.34
ACTIVITY TOTAL 312,349.00 90.60 312,258.40 242,450.81 196.15 242,254.66
COMMUNITY DEVELOPMENT
ENGINEERING 16,250.00 16,250.00 20,071.01 20,071.01
ACTIVITY TOTAL 16,250.00 16,250.00 20,071.01 20,071.01
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 704,899.00 1,290.60 703.608.40 460,660.33 1,396.15 459,264.18
EXCESS <REVENUE>EXPENDITURE 150,647.00 1,290.60 149,356.40 21,269.13 1,396.15 19,872.98
EXCESS <REVENUE>EXPENDITURE 150,647.00 1,290.60 149,356.40 21,269.13 1,396.15 19,872.98
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2002 THROUGH 07/31/2002
CAPITAL IMPROVEMEN FUND
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 766,333.51 766,333.51
OTHER SOURCES OF REVENUE 11,180,405.00 11,180,405.00
TOTAL REVENUE: 12,284,490.00 12,284,490.00 766,333.51 766,333.51
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY ATTORNEY 12,950.00 12,950.00
ACTIVITY TOTAL 12,950.00 12,950.00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 214,797.00 3,829.46 210,967.54 96,133.06 336.92 95,796.14
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING 8,585.61 816.83 7,768.78
ACTIVITY TOTAL 8,585.61 816.83 7,768.78
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 10,679,999.00 369,943.49 10,310,055.51 2,572,869.22 2,573,869.22
COMMUNITY IMPROVEMENTS
PARKS 3,348,169.00 3,348,169.00 125,589.57 125,589.57
STREET CONSTRUCTION/IMPROVEMENT 19,756,297.00 666.73 19,755,630.27 3,967,399.16 2,340.46 3,965,058.70
ACTIVITY TOTAL 33,784,465.00 370,610.22 33,413,854.78 6,666,857.95 2,340.46 6,664,517.49
T 0 T A L EXPENDITURES 34.012,212.00 374,439.68 33,637,772.32 6,771,576.62 3,494.21 6,768,082.41
EXCESS <REVENUE>EXPENDITURE 211727,722.00 374,439.68 21,353,282.32 6,005,243.11 3,494.21 6,001,748.90
TRANSFER .IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 21,727,722.00 374,439.68 21,253,282.32 6,005,243.11 3.494.21 6,001,748.90
THE CITY OF DUBLIN STATEMENT SHOWING -
REVENUES VERSUS EXPENDITURES // Z~ /~
FOR THE PERIOD
07/01/2002 THROUGH 07/31/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 5,367.69 490.25 4,877.44
TOTAL REVENUE 242,632.11 490.25 242,141.86
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 229,828.00 229,828.00 233,733.29 232,733.39
ACTIVITY TOTAL 229,828.00 229,828.00 233,733.39 232.733.39
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES 229,828.00 229,828.00 233,733.39 233,733.39
EXCESS <REVENUE>EXPENDITURE 229,828.00 229,828.00 (8,898.72) (490.25) (8,408.47)
EXCESS <REVENUE>EXPENDITURE 229.828.00 229,828.00 (8,898.72) (490.25) (8,408.47)
THE CITY OF DUBLIN STATEMENT SHOWING ~2~
REVENUES VERSUS EXPENDITURES ~~,,
FOR THE PERIOD
07/01/2002 THROUGH 07/31/2002
INTERNAL SERVICE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
******************--**
USES/MONEY & PROP-INTEREST 227,059.00 227,059.00 121,730.05 121,730.05
CHARGES FOR SERVICES 1,367.,268.00 55,151.16 1,312,116.84 1,123,051.14 93,454.87 1,029,596.27
OTHER SOURCES OF REVENUE 20,000.00 20,000.00 22,267.13 22,267.13
TOTAL REVENUE 1,614,327.00 55,151.16 1,559,175.84 1.267,048.32 93,454.87 1,173.593.45
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 1,741,280.00 21,339.17 1,719,940.83 401,677.32 29,366.38 372,310.94
ACTIVITY TOTAL 1,741,280.00 21,339.17 1,719,940.83 401,677.32 29,366.38 372,310.94
PUBLIC SAFETY:
FIRE 51,818.00 51,818.00 41,899.88 41,899~88
ACTIVITY TOTAL 51,818.00 51,818.00 41.899.88 41,899.88
TP~ANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES 1,793,098.00 21,339.17 1,771,758.83 443,577.20 29,366.38 414,210.82
EXCESS <REVENUE>EXPENDITURE 178,771.00 (33,811.99) 212,582.99 (823,471.12) (64,088.49) (759,382.63)
TRANSFER IN FROM OTHER FUNDS
TP~ANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE 178,771.00 (33,811.99) 212,582.99 (823,471.12) (64,088.49) (759,382.63)
THE CITY OF DUBLIN STATEHENT SHOWING
REVENUES VERSUS EXPENDITURES 73 ~
FOR THE PERIOD
07/01/2002 THROUGH 07/31/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
FINANCE
ACTIVITY TOTAL
PUBLIC SAFETY:'
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE