HomeMy WebLinkAbout4.02 FinRpt 2-96
~ ~-
CITY CLERK
. File # n~~~-[6J[Q]
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (March 26, 1996)
- ___ ___ - . I ,
____ ___ ~~ _ - l i ... .'
. ~'~ .
"
tI
Financial Report For the Month of February 1996
Report Prepared by: Paul S. Rankin, Assistant City Manager
SUBJECT:
Balance Sheet and Income Statements for
the Period Ending February 29, 1996
RECOMMENDATION: ~ Accept and file the reports.
1.
EXIllBITS ATTACHED:
FINANCIAL STATEMENT:
See reports for detail of monthly fmancial activity.
DESCRIPTION: This item provides the report of the monthly fmancial statements
"'r the month of February. Consistent with prior reports the focus will be on General Fund Revenues and
~xpenditures, which represent the most significant portion of the City's operations.
ANALYSIS OF FEBRUARY 1996 REVENUE AND EXPENDITIJRE REPORT
Through the first seven months of the fiscal year the revenue collections and expenses have been tracking
similar to the previous fiscal year. During this period total revenue in the General Fund exceeded total
General Fund expenditures by approximately $501,195. This figure has decreased by approximately
$350,000 from the amount reported as of January 31, 1996. As previously noted there is not an even
distribution of revenues and expenditures on a monthly basis. For example, in the revenue category, the
City receives significant property tax revenue in the months of December and April, and the expenditures
for major contracts such as Police Services lag since the City is billed on a quarterly basis. The following
sections discuss in more detail significant trends among the major General Fund revenue and expenditure
categories.
GENERAL FUND REVENUES
Total General Fund Revenues collected from July through February are only slightly more than what
occurred in the same period of the previous Fiscal Year. The City had collected through February 1995,
58.1 % of the total General Fund Revenues collected in Fiscal Year 1994/95. Through February 29, 1996,
approximately 60.1 % of the Budgeted General Fund Revenue had been collected.
~~-----------~~~~~~~---~--------------------------------------------------------------------------------------------------~----
COPIES TO:
ITEMNO.~
..' ~
Although Sales Tax is tracking at levels slightly ahead of the prior Fiscal Year, the outcome of the
Christmas retail sales season will not be fully reported until the March fmancial report. Through February.
1996, the City had recorded sales tax collections equal to approximately 66.8% of the Budget compared to -
approximately 62.2% for the same period of the previous Fiscal Year. At this point in the Fiscal Year the
sales of new and used automobiles have remained strong and contributed towards offsetting any declines
in other retail sectors. The City will also need to evaluate the full impact of new regional retail centers
and the loss of Paper Corporation of America on the existing base. Several of these impacts did not
transpire until the second half of calendar year 1995. Due to-the lag jn..sales.: ~ ~p~~g analysis of
these impacts cannot occur until later in the Fiscal Year. .
T~ient Occupancy Taxes continue to remain strong through the current period. The City has seen
growth in this revenue since the operator changed to a Best Western affiliation. Through the current
period the City has already exceeded its 1995/96 budgeted revenue projection for this revenue.
As diScussed in the Mid- Year report the Licenses and Permits category is below the level achieved for the
same period in Fiscal Year 1994/95. This category typically fluctuates due to the nature of Building
permits. It is anticipated that the City will receive less in Building Permit Revenue in the current Fiscal
Year, however, it is also anticipated that the City will have decreased contract service expenditures due to
a corresponding reduction in the need for inspection services.
It is important to note that the category for interest revenue (Use of Money & Property) is typically not
allocated to individual funds until the end of the fiscal year. All interest revenue collected to date is
pooled in the General Fund and then allocated at year end between the various funds. The allocation is .
based upon the proportionate share of the monthly cash balance in each fund, compared to the total pooled
cash which is invested.
GENERAL FUND EXPENDITIJRES
Overall, Expenditures through the month of February in the General Fund totaled $ 8,713,257 and
represented 58.0% of the total budgeted expenditures in the General Fund. Of this amount, a total of
approximately $69,586 was related to Capital Improvement Projects and the remainder was related to
Operating Costs reported in the General Fund. Capital Project expenditures typically do not follow an
even distribution due to differences in project timing.
In looking at only General Fund Qperatine Expenditures, the activity through February 1996 was very
close to the amount expended for the same period in the prior Fiscal Year. As of February 29, 1996, the
City had expended 59.1% of the General Fund Qperatini Budget. Operating Expenditures in July 1994
through February of 1995 accounted for approximately 63.6% of the total 1994/95 General Fund
Operatine Expenditures. The areas of any significant deviation have been previously discussed in reports
submitted in prior months.
It is recommended that the City Council receive and file these reports as authorized by Section 41004 of
the California Government Code.
.
.
'j"l"." ""
L If
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF FEBRUARY 1996
.
Prepared by
The Finance Department
March 18, 1996
.
EXHIBIT 1
.
. GL 102 CITY OF DUBLIN PAGE I
3/18/96 BALANCE SHEET 11.27.36
FOR THE
PERIOD 1/95 THROUGH 2196
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY - h MEMORANDUM ONLY ---
FUNDS FUND S FUNOS FUNDS FUND CURRENT JUNE 30, 1995
'=- ;
ASSETS
CASH 2241181.60- 1753549.31 198234.35 231276.78- 42533 .82 478140.90- 1141855.19-
CASH ~ITH FISCAL AGENT 125579.24 125579.24 121210.04
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST 22697647.50 22697647.50 19855322.74
RECEIVABLES:TAXES
ACCOUNTS (NET) 173713.09 263764.58 437477.67 333144.10
INTEREST
ASSESSMENTS
RENT S
NOTES
DUE FROM OTHERS 5967.43 5967.43
INVENTORY AT COST
PREPAID ITEMS 6292.67 6292.67 4211.48
FIXED ASSETS
AMOUNTS TO BE PROVIDED 2158500.00 2158500.00 2232500.00
TOTAL ASSETS 206364 71 .66 1759516.74 198234.35 32487.80 2326613.06 24953323.61 21404533.17
. LIAS, FND BAL, RETND EARNINGS
DEPOSITS FOR PRIVATE OEVELPMNT 149544.70- 149544.70- 7931.10
DEPOSITS FOR AB1600 FEES 291271.48- 291271.48- 242746.00-
DEPOS ITS OTHERS 367469.62- 263764.58- 631234.20. 491423.15.
PAYABLES:ACCOUNTS 152630.84. 90114.15- 1051.60- 9710.69. 253507.28- 3917.00.
INTEREST
PAYROLL 1530.50 1530.50 13136.64
DUE TO OTHERS 345.00- 345.00.
DEBT INSTRUMENTS PAYABLE 2276000.00. 2276000.00- 2350000.00-
TOTAL.LIABILTIES 668459.66- 90114.15- 1051.60- 564746.75- 2276000.00- 3600372.16- 3067018.41-
FUND BALANCES 19968012.00- 1669402.59- 197182.75- 532258.95 50613.06- 21352951.45- 18337514.76-
TOTAL FUND EQUITY 19968012.00- 1669402.59- 197182.75- 532258.95 50613.06- 21352951.45- 18337514.76-
TOTAL LIAB,FND BAL, RETD EARNS 20636471.66- 1759516.74- 198234.35- 32487.80- 2326613.06- 24953323.61- 21404533.17.
.
GL102 CITY OF DUBLIN PAGE 1 .
3/18/96 BALANCE SHEET 11.28.27
FOR THE
PERIOD 7/95 THROUGH 2196
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S
SERVICE FUNDS GROUP OF TERM DEBT h - MEMORANDUM ONLY ..-
FUND ACCOUNTS ACCOUNT GROUP CURRENT JUNE 30. 1995
-=---.- ._-=-"'- - " "
ASSETS
CASH 330756.01 6499.13- 324256.88 288922.84
CASH WITH FISC~L A~ENt 1757988.45 1757988.45 1743428.27
UNAHORTIZEO;~OND,DISCOUNT
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOONTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 151.00
FIXED ASSETS 254838.58 20597199.70 492625.30 21344663.58 21743799.35
AHOONTS TO BE PROVIDED 2855403.88 2855403.88 2713930.44
TOTAL ASSETS 585594.59 22348689.02 492625.30 2855403.88 26282312.79 26490231.90
LIAS. FND BAL, RETND EARNINGS .
DEPOSITS FOR PRIVATE OEVELPMNT
DEPOSITS OTHERS
PAYABLES:ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE 16970000.00- 28554D3.88- 19825403.88- 20328930.44-
TOTAL LIABILITIES 16970000.00- 2855403.88- 19825403.88- 20328930.44-
FUND BALANCE 364393.27- 268799.02- 633192.29- 478737.64-
COIHRIBUTlONS 23m2.75- 5109890.00- 5347612.75- 5287228.56-
INVESTMENTS IN FIXED ASSETS 16521.43 492625.30- 476103.87- 479805.26-
RETAINED EARNINGS
TOTAL FUND EQUITY 585594.59- 5378689.02- 492625.30- 6456908.91- 6161301.46-
TOTAL LIAB.FNO BAL, RETD EARNS 585594.59- 22348689.02- 492625.30- 2855403.88- 26282312.79- 26490231.90-
-'
.
. Gll04C THE CITY OF OUBLIN STATEMENT SHOUING PAGE 1
3/1 8/96 REVENUES VERSUS EXPENOITURE 10.18.12
FOR THE
PERIOO 7/95 THROJGH 2/96
GENERAL REVENUE FUNO
CURRENT PERIOD PREVIOUS YEAR ENOING JUNE 30, 1995
BUOGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VAR lANCE
- fjSt;AL ,YR Y-T-O
-*******REVENUES*******
PROPERTY TAXES 3968100.00- 2150485.68- 54.2 1817614.32- 3944284.28- 2244645.05- 56.9 1699639.23-
SALES TAX 6400000.00- 4273237.20 - 66.8 2126762.80-" --w0287.39c ' 4026297.07- 62.2 2443990.32-
REAL PROPERTY TRANSFERS 78000.00- 43111.10- 55.3 34888.90- 58070.83- 37969.67- 65.4 20101.16-
TRANSIENT OCCUpANCY TAX 112000.00- 128422.00- 114.7 16422.00 112580.00- 83459.00- 74.1 29121. 00-
FRANCHISE, TAXES 615500.00- 255221.11- 41.5 360278.89- 481155.78- 217316.66- 45.2 263839.12-
LICENSES & PERMITS 565650.00- 250789.81- 44.3 314860.19- 337550.69- 243390.06- 72.1 94160.63-
FINES & FORFEITURES 35000.00- 25653.76- 73.3 9346.24- 35668.12- 24878.22- 69.7 10789.90-
USES OF MONEY AND PROPERTY 1124850.00- 539834.87- 48.0 585015.13- 1140713.87- 471282.03- 41.3 669431.84-
INTERGOVERNMENTAL FROM STATE 1031450.00- 669283.95- 64.9 362166.05- 1044001.82- 648008.03- 62.1 395993.79-
CHARGES FOR SERVICES 1272630.00- 789273.99- 62.0 483356.01- 1053715.45- 532096.75- 50.5 521618.70-
OTHER SOURCES OF REVENUE 132738.00- 89138.18- 67.2 43599.82- 163462.88- 99322.44- 60.8 64140.44-
TOTAL REVENUE 15335918.00- 9214451.65- 60.1 6121466.35- 14841491.11- 8628664.98- 58.1 6212826.13-
*~***.EXPENOITURES*.**...
GENERAL GOVERNMENT ACTIVITIES:
NON'OEpARTMENTAL 95880.00 12.50 95867.50 137210.00 .00 137210.00
CITY COUNCIL 1010 138945.00 83845.23 60.3 55099.77 106703.42 66696.53 62.5 40006.89
CITY MANAGER 1020 281336.00 169501.39 60.2 111834.61 255861.89 158030.88 61.8 97831.01
. CITY ATTORNEY 1030 152388.00 68915.74 45.2 83472.26 188007.10 132009.07 70.2 55998.03
ADMIN SERVICES 1040 547130.00 287366.79 52.5 259763.21 445264.08 273087.09 61.3 172176.99
BUILDING MANAGEMENT 1050 332950.00 207078.07 62.2 125871.93 317163.30 185758.66 58.6 131404.64
FACILITY RENTAL 1050-719 1604480.00 1499417.58 93.5 105062.42 1461448.88 1461344.88 100.0 104.00
INSURANCE COST CENTER 1060 119800.00 96072.30 80.2 23727.70 124851.39 113593.54 91.0 11257.85
ELECTIONS COST CENTER 1070 660.00 563.52 85.4 96.48 6078.72 6078.72 100.0 .00
ACT I V ITY TOTAL 3273569.00 2412m.12 73.7 860795.88 3042588.78 2396599.37 78.B 645989.41
PUBLIC SAFETY:
POll CE 2010 3580781.00 1792494.06 50.1 1788286.94 3119865.40 1612024.78 51.7 1507840.62
CROSSING GUAROS COST 2020 47749.00 22778.28 47.7 24970.72 36333.77 18272.66 50.3 18061. 11
ANIMAL CONTROL 2030 182440.00 .00 182440.00 70885.70 16144.00 22.8 54741. 70
DISASTER PREAPREDNESS 2050 43460.00 3371. 80 7.8 40088.20 14798.56 3815.31 25.8 10983.25
FIRE SERVICES JPA 2060 3062737.00 1960152.00 64.0 1102585.00 2801337.13 1984608.00 70.8 816729.13
ACT I VITY TOTAL 6917167.00 3778796.14 54.6 3138370.86 6043220.56 3634864.75 60.1 2408355.81
TRANSPORTATION:
PUBLI C IIORI:S 3010 312060.00 184452.14 59.1 127607.86 297240.13 180304.79 60.7 116935.34
STREET MAINTENANCE 3020 159460.00 23.01 159436.99 31902.53 31831.43 99.8 71.10
STREET TREE MAINTENANCE 3040 48615.00 17278.41 35.5 31336.59 41872.72 20936.59 50.0 20936.13
STREET LANDSCAPE MAINT. 3050 180m.oo 116618.86 64.5 64158.14 168920.81 99725.67 59.0 69195.14
ACTIVITY TOTAL 700912.00 318372.42 45.4 382539.58 539936.19 332798.48 61.6 207137.71
HEALTH & UELFARE:
WASTE MANAGEMENT 5020 .00 .00 .00 17411.78 4493.31 25.8 12918.47
ACTIVITY TOTAL .00 .00 .00 17411.78 4493.31 25.8 12918.47
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES 8010 194188.00 97094.00 50.0 97094.00 lm36.od 88768.00 50.0 88768.00
CULTURAL ACTIVITIES 8011 20000.00 10000.00 50.0 10000.00 10000.00 10000.00 100.0 .00
HERITAGE CENTER 8012 40561.00 23771. 58 58.6 16789.42 6737.62 2636.63 39.1 4100.99
DUBLI N CEMETERY 8013 22100.00 10540.94 47.7 11559.06 16854.77 10539.11 62.5 6315.66
PARI: MAINTENANCE 8020 600037.00 335057.67 55.8 264979.33 584045.96 326829.56 56.0 257216.40
.
GL1 04C THE CITY Of DUBLIN STATEMENT SHOWING PAGE 2 .
3/18/96 REVENUES VERSUS EXPENDITURE 10.18.12
FOR THE
PERIOD 7/95 THROUGH 2/96
GENERAL REVENUE FUND
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1995
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
,
COMMUNITY CABLE TV 8030 , 33836.00 21236.00 62.8 12600.00 22779.27 21143.00' , 92.8 1636.27
RECREATION ADMIN. "8040" 191356.00 114382.26 59.8 76973.74 178485.58 111649.07 62.6 66836.51
PLAYGROUNDS 8045 101916.00 62460.87 61.3 39455.13 95612.89 58323.01 61.0 3n89.88
SHANNON Ce~TER 8050 . 123348.00 76853.42 62.3 46494.58 10n02.90 64771.14 60.4 42431.76
PRESCHOOL 8055 48258.00 2ml.24 57.5 20526.76 37414.34 22838.45 61.0 14575.89
TEENS PROGRAM 8060 36982.00 18432.25 49.8 18549.75 27525.50 16789.84 61.0 10735.66
ADULT SPORTS 8065 81399.00 34532.56 42.4 46866.44 66278.32 43841.32 66.1 22437.00
YCXJTH SPORTS 8066 35792.00 22647.53 63.3 13144.47 31761.14 20151.52 63.4 11609.62
SPECIAL EVENTS 8070 34410.00 13518.97 39.3 20891.03 30612.01 14782.11 48.3 15829.90
SENIOR CENTER 8080 109176.00 63090.85 57.8 46085.15 108674.38 64496.75 59.3 44177.63
RECREATION INSTRUCTION 8090 82691. 00 44298.41 53.6 38392.59 75381.16 43360.35 57.5 32020.81
AQUATICS 8100 206762.00 112330.85 54.3 94431.15 189089.80 112643.14 59.6 76446.66
ACTI V ITY TOTAL 1962812.00 1087979.40 55.4 874832.60 1765991.64 1033563.00 58.5 732428.64
COMMUNITY DEVELOPMENT:
PLANNING 9010 850903.00 476584.53 56.0 374318.47 648241.27 346677.61 53.5 301563.66
BUILDING SAfETY 9020 304219.00 151599.46 49.8 152619.54 261521.53 155280.20 59.4 106241. 33
ENGINEERING 9030 540530.00 349212.47 64.6 191317.53 276569.24 137196.33 49.6 1393n.91
ECONOMIC DEVELOPMENT 9040 103508.00 68353.47 66.0 35154.53 63749.94 12852.98 20.2 50896.96
ACTIVITY TOTAL 1799160.00 1045749.93 58.1 753410.07 1250081.98 652007.12 52.2 598074.86
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 93NN 94741.00 16800.95 17.7 77940.05 49443.40 48961. 97 99.0 481.43
COMMUNITY IMPROVEMENTS 94NN 116340.00 52508.31 45.1 63831.69 89836.41 7780.56 8.7 82055.85 .
PARKS 95NN 43600.00 276.48 .6 43323.52 7939.49 7939.49 100.0 .00
STREET CONSTRC/IMPROVMT 96NN 110039.00 .00 110039.00 32500.00 32500.00 100.0 .00
ACTI VITY TOTAL 364720.00 69585.74 19.1 295134.26 179719.30 97182.02 54.1 82537.28
TOT A L EXPENDITURES 15018340.00 8713256.75 58.0 6305083.25 12838950.23 8151508.05 63.5 4687442.18
EXCESS [REVENUE>EXPENDITURES 317578.00. 501194.90- 157.8 183616.90 2002540.88- 477156.93- 23.8 1525383.95-
TRANSfERS IN FROM OTHER FUNOS .00 1015.00- 1015.00 46410.04- 40469.22- 87.2 5940.82-
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 294854.69 276446.78 93.8 18407.91
EXCESS [REVENUE> EXPENDITURE 317578.00- 502209.90- 158.1 184631. 90 1754096.23- 241179.37- 13.7 1512916.86-
.
. all 04C THE CITY OF DUBLIN STATEMENT SHOYING PAGE 1
3/18/96 REVENUES VERSUS EXPENDITURE 10.24.16
FOR THE
PERIOD 7/95 THROUGH 2/96
SPECIAL REVENUE FUND S
CURRENT PERIOIl PREVIOUS YEAR ENDING JUNE 3D. 1995
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
-...--- - . ~1~CAL YR Y-T-o
***.****REVENUES...***.
SALES TAX 126000.00- 90637.19- 71.9 35362,81- 120823.92- 79669.94- 65.9 41153,98-
FINES & FORFE ITURES 26000.00- 16195.15- 62.3 9804.85- ------z45S6.82- . .13424.08- 54.7 11132,74-
SPECIAL BENEFITS ASSESSMENTS .00 .00 .00 .00 2815.96- 2815.96
USES OF MONEY AND PROPERTY 61735.00- .00 61735.00- 49056.30- .00 49056.30-
INTERNGOVERNMENTAL FROM STATE 629748.00- 307478.49- 48.8 322269.51- 656834.32- 310998.24- 47.3 345836.08-
INTERGOVERNMENTAL FROM COUNTY 102000.00- 97483.00- 95.6 4517.00- 151127.00- 115951.00- 76.7 35176.00-
INTERGOVERNMENTAL FROM FEDERAL 2558171.00- 800624.51- 31.3 1757546.49' 523412.91- .00 523412,91-
CHARGES FOR SERVI CES 819070.00- 417178.19- 50.9 401891.81 - 744626.00- 371606.97- 49.9 373019.03-
OTHER SOURCES OF REVENUE 621500.00- 566875.59- 91.2 54624.41- 286592.73- 3251.42- 1.1 283341.31 -
TOTAL REVENUE 4944224.00- 2296472.12- 46.4 2647751.88- 2557030.00- 897717.61 - 35.1 1659312.39-
~****EXPENoITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00 .00 .00 .00
PUBLI C SAFETY:
POLICE 6000.00 1635.26 27.3 4364 . 74 9360.94 4185.36 44.7 5175.58
TRAFFIC SIGNALS 102277.00 37354.40 36.5 64922.60 80108.52 43121.49 53.8 36987.03
ACTIVITY TOTAL 108277.00 38989.66 36.0 69287.34 89469.46 47306.85 52.9 42162.61
TRANSPORTATION:
. PUBLI C IIORKS 298.00 1.45 .5 296.55 .00 .00 .00
STREET MAINTENANCE 164740.00 55909.94 33.9 108830.06 214599.03 178542.17 83.2 36056.86
STREET SIIEEPING 73655.00 41215.16 56.0 32439.84 70518.94 41692.32 59.1 28826.62
ACTlVI TY TOTAL 238693.00 97126.55 40.7 141566.45 285117.97 220234.49 77.2 64883.48
HEALTH & \/ELFARE:
IIASTE MANAGEMENT 1223345.00 347941. 44 28.4 875403.56 679404.95 301182.16 44.3 378222,79
CULTURE & LEISURE SERVICES:
COMMUN I TY DEVELOPMENT:
ENGINEERING 107992.00 20293.70 18.8 87698.30 101497.21 35417 .41 34.9 66079.80
ACTIVITY TOTAL 107992.00 20293.70 18.8 87698.30 101497.21 35417.41 34.9 66079.80
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS .00 .00 .00 17266.00 17266.00 100.0 .00
COMMUNITY IMPROVEMENTS 74319.00 46517.16 62.6 27801.84 181692.50 52754.50 29.0 128938.00
PARKS 237416.00 201344.42 84.8 36071.58 2280.00 .00 2280.00
STREET CONSTRUCTION/IMPROVHT 2701592.00 919280.01 34.0 1782311.99 697231.63 148691.47 21.3 548540.16
ACTIVITY TOTAL 3013327.00 1167141.59 38.7 1846185.41 898470.13 21871 1.97 24.3 679758.16
TOT A L EXPENDITURES 4691634.00 1671492.94 35.6 3020141.06 2053959.72 822852.88 40.1 1231106.84
EXCESS [REVENUE>EXPENDITURE 252590.00- 624979.18- 247.4 372389. 18 503070.28- 74864,73- 14.9 428205.55-
TRANSFERS IN FROM OTHER FUNDS .00 14897.00- 14897.00 .00 .00 .00
TRANSFERS OUT TO OTHER FUNDS .00 15912.00 15912.00- 3600.00 .00 3600.00
EXCESS [REVENUE> EXPENDITURE 252590.00- 623964,18- 247.0 371374.18 499470.28- 74864.73- 15.0 424605.55-
.
GL 1 04C THE CITY OF OUBLIN STATEMENT SHOWING PAGE 1 .
3/18/96 REVENUES VERSUS EXPENDITURE 10.39.16
FOR THE
PERIOO 7/95 THROUGH 2/96
SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1995
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VAR lANCE
FISCAL YR Y-T-O
***....*REVENUES****-**
SPECIAL BENEFITS ASSESSMENTS 296105.00- 150936.34- 51.0 145168.66- 363469.78- 193651.83- 53.3 169817.95-
USES OF MONEY AND PROPERTY 17130.00- .00 17130.00- 21115.14- .00 21115.14-
OTHER SOUR~ES OF REVENUE 4000.00- .00 4000.00- 3944.45- 3944.45- 100.0 .00
TOTAL REVeNUE 317235.00- 150936.34- 47.6 166298.66- 388529.37- 197596.28- 50.9 190933.09-
WT*****EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
'ACTIVITY TOTAL .00 .00 .00 .00 .00 .00
PUBLl C SAFETY:
TRFC SIGS/STREET LIGHTING 196374.00 112716.70 57.4 83657.30 192530.11 107645.61 55.9 84884.50
ACTIVITY TOTAL 196374.00 112716.70 57.4 83657.30 192530.11 107645.61 55.9 84884.50
TRANSPORTATION:
PUBLl C IJORICS 5054.00 2019.60 40.0 3034.40 3507.43 1134.86 32.4 2372.57
STREET TREE MAINTENANCE 9107.00 3254.98 35.7 5852.02 5350.84 2361.28 44.1 2989.56
STREET LANDSCAPE MAINTENANCE 113010.00 61127.13 54.1 51882.87 110650.86 67300.89 60.8 43349.97
ACTI VITY TOTAL 127171.00 66401. 71 52.2 60769.29 119509.13 70797.03 59.2 48712.10
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
ENGINEERING 3570.00 3027.96 84.8 542.04 3216.97 3203.40 99.6 13.57 .
ACTIVITY TOTAL 3570.00 3027.96 84.8 542.04 3216.97 3203.40 99.6 13.57
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 3mO.00 25461.64 67.4 12308.36 .00 .00 .00
STREET CONSTRUCTION/IMPROVMT 431000.00 636.53 .1 430363.47 5470.89 1959.59 35.8 3511.30
ACTIVITY TOTAL 468nO.00 26098.17 5.6 442671.83 5470.89 1959.59 35.8 3511.30
TOT A L EXPENDITURES 795885.00 208244.54 26.2 587640.46 320727.10 183605.63 57.2 137121.47
EXCESS(REVENUE>EXPENOITURE 478650.00 57308.20 12.0 421341.80 67802.27- 13990.65- 20.6 53811.62-
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 42810.04 40469.22 94.5 2340.82
EXCESS (REVENUE> EXPENDITURE 478650.00 57308.20 12.0 421341. 80 24992.23- 26478.57 105.9- 51470.80-
.
. GL1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
3/18/96 REVENUES VERSUS EXPENDITURE 10.18.12
FOR THE
PERIOD 7/95 THROUGH 2/96
GENERAL REVENUE FUND
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1995
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
'FISCALYR Y-T-O
********REVENUES*******
PROPERTY TAXES 3968100.00- 2150485.68- 54.2 1817614.32- 3944284.28- 2244645.05- 56.9 1699639.23-
~' . SALEs TAX 6400000.00- 4273237.20- 66.8 2126762.80--' -647ti287.39~ ' 4026297.07- 62.2 2443990.32-
REAL PROPERTY TRANsFERS 78000.00- 43111. 10- 55.3 34888.90- 58070.83- 37969.67- 65.4 20101.16-
TRANsiENT OCCUPANCY TAX 112000.00- 128422.00- 114.7 16422.00 112580.00- 83459.00- 74.1 29121.00-
FRANCHIse TAXES 615500.00- 255221.11- 41.5 360278.89- 481155.78- 217316.66- 45.2 263839.12-
LICENSES & PERMITS 565650.00- 250789.81- 44.3 314860.19- 337550.69- 243390.06- 72.1 94160.63-
FINEs & FORFEITURES 35000.00- 25653.76- 13.3 9346.24- 35668.12- 24878.22- 69.7 10789.90-
USES OF MONEY AND PROPERTY 1124850.00- 539834.87- 48.0 585015.13- 1140713.87- 471282.03- 41.3 669431.84-
INTERGOVERNMENTAL FROM STATE 1031450.00- 669283.95- 64.9 362166.05- 1044001.82- 648008.03- 62.1 395993.79-
CHARGES FOR SERVICES 1272630.00- 789273.99- 62.0 483356.01- 1053715.45- 532096.75- 50.5 521618.70-
OTHER sOURCES OF REVENUE 132138.00. 89138.18- 67.2 43599.82- 163462.88- 99322.44- 60.8 64140.44-
TOTAL REVENUE 15335918.00- 9214451.65- 60.1 6121466.35- 14841491. 1 1- 8628664.98- 58.1 6212826.13-
*******EXPENDI TURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON'OEPARTMENTAL 95880.00 12.50 95867.50 137210.00 .00 137210.00
CITY COUNCIL 1010 138945.00 83845.23 60.3 55099.77 106703.42 66696.53 62.5 40006.89
crTY MANAGER 1020 281336.00 169501.39 60.2 111834.61 255861.89 158030.88 61.8 97831.01
CITY ATTORNEY 1030 152388.00 68915.74 45.2 83472.26 188007.10 132009.07 70.2 55998.03
. ADMIN SERVICES 1040 547130.00 287366.79 52.5 259763.21 445264.08 213087.09 61.3 172176.99
BUILDING MANAGEMENT 1050 332950.00 207078.07 62.2 125871.93 317163.30 185758.66 58.6 131404.64
FACILITY RENTAL 1050-719 1604480.00 1499417.58 93.5 105062.42 1461448.88 1461344.88 100.0 104.00
INSURANCE COST CENTER 1060 119800.00 96072.30 80.2 23727.70 124851.39 113593.54 91.0 11257.85
ELECTIONS COST CENTER 1070 660.00 563.52 85.4 96.48 6078.72 6078.72 100.0 .00
ACTIVITY TOTAL 3273569.00 2412m.12 13.7 860795.88 3042588.78 2396599.37 78.8 645989.41
PUBLIC SAFETY:
POL I CE 2010 3580781.00 1792494.06 50.1 1788286.94 3119865.40 1612024.78 51.7 1507840.62
CROSSING GUARDS COST 2020 47749.00 22778.28 47.7 24970.72 36333.77 18272.66 50.3 18061. 1 1
ANIMAL CONTROL 2030 182440.00 .00 182440.00 70885 .70 16144.00 22.8 54741.70
DISASTER PREAPREDNESS 2050 43460.00 3371.80 7.8 40088.20 14798.56 3815.31 25.8 10983.25
FIRE SERVICES JPA 2060 3062737.00 1960152.00 64.0 1102585.00 2801337.13 1984608.00 70.8 816729.13
ACTI VITY TOTAL 6917167. DO 3778796.14 54.6 3138370.86 6043220.56 3634864.75 60.1 2408355.81
TRANSPORTATION:
PUBLI C IIORKS 3010 312060.00 184452.14 59.1 127607.86 297240.13 180304.79 60.7 116935.34
STREET MAINTENANCE 3020 159460.00 23.01 159436.99 31902.53 31831.43 99.8 71.10
STREET TREE MAINTENANCE 3040 48615.00 17278.41 35.5 31336.59 41872.72 20936.59 50.0 20936.13
STREET LANDSCAPE MAINT. 3050 180m. 00 116618.86 64.5 64 158.14 168920.81 99725.67 59.0 69195.14
ACTIVITY TOTAL 700912.00 318372.42 45.4 382539.58 539936.19 332798.48 61.6 207137.71
HEALTH & WELFARE:
WASTE MANAGEMENT 5020 .00 .00 .00 17411.78 4493.31 25.8 12918.47
ACTIVITY TOTAL .00 .00 .00 17411.78 4493.31 25.8 12918.47
CULTURE & LEISURE sERVICES:
LIBRARY SERVICES 8010 194188.00 97094.00 50.0 97094.00 1m36.00 88768.00 50.0 88768.00
CULTURAL ACTIVITIES 8011 20000.00 10000.00 50_0 10000.00 10000.00 10000.00 100.0 .00
HER IT AGE CENTER 8012 40561.00 23771. 58 58.6 16789.42 6737.62 2636.63 39.1 4100.99
DUBLIN CEMETERY 8013 22100.00 10540.94 47.7 11559.06 16854.77 10539.11 62.5 6315.66
PARK MAINTENANCE 8020 600037.00 335057.67 55.8 264979 .33 584045.96 326829.56 56.0 257216.40
.
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2 .
3/18/96 REVENUES VERSUS EXPENDITURE 10.18.12
FOR THE
PERIOD 7/95 THROUGH 2/96
GENERAL REVENUE FUND
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1995
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-O
i
.- --------- .
COMMUNITY CABLE TV 8030 33836.00 21236.00 62.8 12600.00 22779.27 21143.00 92.8 1636.27
RECREATION ADMIN. 8040 191356.00 114382.26 59.8 76973.74 178485.58 111649.07 62.6 66836.51
PLAYGROUl/OS 8045 101916.00 62460.87 61.3 39455.13 95612.89 58323.01 61.0 37289.88
SHANNON CENTER 8050 123348.00 76853.42 62.3 46494.58 107202.90 64771.14 60.4 42431.76
PRESCHOOL 8055 48258.00 2ml.24 57.5 20526.76 37414.34 22838.45 61.0 14575.89
TEENS PROGRAM ' 8060 36982.00 18432.25 49.8 18549.75 27525.50 16789.84 61.0 10735.66
ADULT SPORTS 8065 81399.00 34532.56 42.4 46866.44 66278.32 43841.32 66.1 22437.00
YOUTH SPORTS 8066 35792.00 22647.53 63.3 13144.47 31761.14 20151.52 63.4 11609.62
SPEC I AL EVENTS 8070 34410.00 13518.97 39.3 20891.03 30612.01 14782.11 48.3 15829.90
SENIOR CENTER 8080 109176.00 63090.85 57.8 46085.15 108674.38 64496.75 59.3 44177.63
RECREATION INSTRUCTION 8090 82691. 00 44298.41 53.6 38392.59 75381.16 43360.35 57.5 32020.81
AQUATICS 8100 206762.00 112330.85 54.3 94431.15 189089.80 112643.14 59.6 76446.66
ACTIVITY TOTAL 1962812.00 1087979.40 55.4 874832.60 1765991.64 1033563.00 58.5 732428.64
COMMUNITY DEVELOPMENT:
PLANNING 9010 850903.00 476584.53 56.0 374318.47 648241 .27 346677.61 53.5 301563.66
BUILOING SAFETY 9020 304219.00 151599.46 49.8 152619.54 261521.53 155280.20 59.4 106241.33
ENGINEERING 9030 540530.00 349212.47 64.6 191317.53 276569.24 137196.33 49.6 139372.91
ECONOMIC OEVELOPMENT 9040 103508.00 68353.47 66.0 35154.53 63749.94 12852.98 20.2 50896.96
ACTIVITY TOTAL 1799160.00 1045749.93 58.1 753410.07 1250081.98 652007.12 52.2 598074.86
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 93NN 94741.00 16800.95 17.7 77940.05 49443.40 48961. 97 99.0 481. 43
COMMUNITY IMPROVEMENTS 94NN 116340.00 52508.31 45.1 63831.69 89836.41 7780.56 8.7 82055.85 .
PARKS 95NN '43600.00 276.48 .6 43323.52 7939.49 7939.49 100.0 .00
STREET CONSTRC/IMPROVHT 96NN 110039.00 .00 110039.00 32500.00 32500.00 100.0 .00
ACTIVITY TOTAL 364720.00 69585.74 19.1 295134.26 179719.30 97182.02 54.1 82537.28
TOT A l EXPENOITURES 15018340.00 8713256.75 58.0 6305083.25 12838950.23 8151508.05 63.5 4687442.18
EXCESS [REVENUE>EXPENOITURES 317578.00- 501194.90- 157.8 183616.90 2002540.88- 477156.93- 23.8 1525383.95-
TRANSFERS IN FROM OTHER FUNOS .00 1015.00- 1015.00 46410.04- 40469.22- 87.2 5940.82-
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 294854.69 276446.78 93.8 18407.91
EXCESS [REVENUE> EXPENOITURE 317578.00- 502209.90- 158.1 184631.90 1754096.23- 241179.37- 13.7 1512916.86-
.
.
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 .
3/18/96 REVENUES VERSUS EXPENDITURE 11.30.05
FOR THE
PERIOO 7/95 THROUGH 2/96
TRUST/AGENCY FUND
CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1995
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
U~CAL_YR , Y;.1-D= " .'
**.*.***REVENUES****~**
SPECIAL BENEFITS ASSESSMENTS 234630.00- 117314.75- 50.0 117315.25- 222337.10- 111168.55- 50.0 111168.55-
USES OF MONEY AND PROPERTY 14000.00- 2675.55- 19.1 11324.45- 7111.65- .00 7111.65-
TOTAL REVENue" 248630.00- 119990.30- 48.3 128639.70- 229448.75- 111168.55- 48.5 118280.20-
*******EXPENDI TURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-OEPARTMENTAL 229585.00 232584.50 101.3 2999.50- 242864.50 242864.50 100.0 .00
ACTIVITY TOTAL 229585.00 232584.50 101.3 2999.50- 242864.50 242864.50 100.0 .00
PUBLI C SAFETY:
TRANSPORTATION:
HEALTH & ~LFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOTAL EXPENDITURES 229585.00 232584.50 101.3 2999.50- 242864.50 242864.50 100.0 .00
EXCESS(REVENUE)EXPENOITURE 19045.00- 112594.20 591.2- 131639.20- 13415.75 131695.95 981. 7 118280.20-
EXCESS (REVENUE) EXPENDITURE 19045.00- 112594.20 591.2- 131639.20- 13415.75 131695.95 981. 7 118280.20-
.
.
. GL104C THE CITY OF OUBLIN STATEMENT SH~ING PAGE 1
3/18/96 REVENUES VERSUS EXPENOITURE 11.08.20
FOR THE
PERIoo 7/95 THROUGH 2/96
ENTERPRISE FUNDS
CURRENT PERIoo PREVIOUS YEAR ENDING JUNE 30, 1995
BUOGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
fJSCAL YR. Y-T-D
........REVENUES.......
USES OF MONEY AND PROPERTY 1709280.00- 1558601.25- 91.2 150678.75- 1565843.45- 1517969.53- 96.9 47873.92-
OTHER SOURCES OF REVENUE .00 3000.00- 3000.00 . .00' .00 .00
TOTAL REVENUE 1709280.00- 1561601.25- 91.4 147678.75- 1565843.45- 1517969.53- 96.9 47873.92-
.......EXPENDITURES.......
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 1604505.00 1222327.25 76.2 3821n.75 1412754.98 1175118.81 83.2 237636.17
ADMIN SERVICES 4845.00 3254.20 67.2 1590.80 7346.35 3811.10 51.9 3535.25
ACTIVITY TOTAL 1609350.00 1225581.45 76.2 383768.55 1420101.33 1178929.91 83.0 241171.42
PUBLI C SAFETY:
DISASTER PREAPREDNESS 1225.00 .00 1225.00 .00 .00 .00
ACTIVITY TOTAL 1225.00 .00 1225.00 .00 .00 .00
TRANSPORTATION:
HEALTH & ~LFARE:
CULTURE & lEISURE SERVICES:
RECREATION ADMINISTRATION 11240.00 5820.26 51.8 5419.74 11036.94 6389.92 57.9 4647.02
SENIOR CENTER 462.00 200.00 43.3 262.00 420.00 420.00 100.0 .00
ACTIVITY TOTAL 11702.00 6020.26 51.4 5681.74 11456.94 6809.92 59.4 4647.02
COMMUNITY DEVELOPMENT:
. CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 1622277.00 1231754.62 75.9 390522.38 1431558.27 1185739.83 82.8 245818.44
EXCESS [REVENUE>EXPEND ITURES 87003.00- 329846.63- 379.1 242843.63 134285.18' 332229.70- 247.4 197944.52
TRANSFERS IN FROM OTHER FUNOS .00 .00 .00 18407.91 - .00 18407.91-
EXCESS [REVENUE> EXPENDITURE 87003.00' 329846.63- 379.1 242843.63 152693.09- 332229.70- 217.6 179536.61
.