HomeMy WebLinkAboutItem 4.05 PrelimFinRpt 9-96 (2)
~
..-:..
.'
...
'.
.: .
~{
.:\
."
.~.
. CITY CLERK
File #fOlf11~[6l-fSlfOl
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (October 15;1"996)
SUBJECT:
PreliIninary Financial Report For the Month of September 1996
Report Prepared by: Paul S. Rankin, Assistant City Manager
EXHIBITS ATTACHED: 1.
Pro Forma Financial Statement for the Period Ending
September 30,1996.
RECOMMENDATION: ~
Accept and file the report.
FINANCIAL STATEMENT:
See reports for detail of monthly. financial activity.
DESCRIPTION: This item provides a preliminary report ofille month1y'jh:umcial statements
for the month of September. The reason that the report is presented as uPro Forma" is that the audit
results of Fiscal Year 1995/96 changes in Fund Balance have not been posted. Consistent with prior
reports the focus of this analysis will be on General Fund Revenues and Expenditures, which represent the
most significant portion of the City's operations.
PRELIMINARY REPORTING OF FUND BALAN"CE INFOJU1A'I'!~ .
The Auditors recently concluded the field work necessary for the 1995/96 Auditand. Staffis reviewing the
Di'aftdocument. The final audit results will impactthe'reported Fund aalance presented in the attached
monthly reports. For example, any General Fund Revenues which exceeded the 1995/96 'Expenditures
have not been carried fotward to the 1996/97 Fund Balance. The computer program used by the City
requires that all posting entries to the prior year be complete, prior to posting the change in fund balance.
Staft' anticipates this will occur by the October report.
ANAL YSIS OF SEPTEMBER 1996 RE~ AND EXPRNDITIJRE REPORT
The September report represents the reporting of reVenues. and expenditures for the first quarter of the
Fiscal Ye!U'. The significance offirst quarter expenditure results, must be viewed with the understanding
. .qttb,ean1ouDt:0fservicc~ the City receives from contract serviceprovidex:s. .~ c:ontract arrangement
creates a lag 'between when the City receives the services and when the,expenditure is recorded. For
example, Sherifr s Department Police Services are billed quarterly and the City has not processed any
billing for the first quarter. Also, 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.
-------~-~------------------------------------~-~~~~-~.~----~------
COPIES TO:
'. ITEM NO. ~ 5
G\aatnda\agtadp.r.doc
. " ~. ":;.I.':' -.). "-.
GENERAL FUND REVENUES
Total General Fund Revenues are tracking very close to the same level as experienced in the last Fiscal
Year. Through September 30, 1996 the City has received approximately 15.7% of the budgeted General
Fund Revenues. During the same period in Fiscal Year 1995/96 the City collected approximately 15.0%.'~?::
of the actual General Fund Revenues collected during the Fiscal Year. .::.'
The Property Taxes collected to date reflect only Unsecured Property. The amount collected is
approximately $13,000 less than the amount received for the same period in Fiscal Year 1995/96. The
comparison of Sales Tax figures with the prior year are slightly skewed due to a change in the accrual
method. Therefore, any increase in the Sales Tax revenue category is most likely related to reporting
differences. Overall, General Fund Revenues appear to be tracking as would be anticipated in the first
quarter of the Fiscal Year.
GENERAL FUND EXPENDITURES
Total General Fund Expenditures in the first quarter are slightly below the pattern established the
previous Fiscal Year with 15.4 % of the Budget expended in July - September 1996, compared to 18.4%
expended in the same period of the prior Fiscal Year. If Operating Expenditures are examined (Le.
excludes Capital Projects) a similar difference is observed. In the current Fiscal Year 14.7% of the
Operating Budget has been expended, compared with 18.5% in the same period of Fiscal Year 1995/96.
Some of the differences in individual program areas are due to timing differences in Fiscal Year 1996/97
as compared to Fiscal Year 1995/96. This has been impacted by the change in the semi-monthly City
Council meeting date, which has affected the schedule for the processing of payments. For example, the
data for the fire expenses in the first quarter of 1995/96 reflected 4 months of contributions versus only
three months in Fiscal Year 1996/97. Overall, the expenditures are within budget for the time period .1\,::
under review. , <.;;
It is recommended that the City Council receive and file these reports as authorized by Section 41004 of
theCaluonllaGov~entCode.
,
, .,
.....
'..-
....
. . .. ~ -
, . ,~~.. '. ~.
....
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF SEPTEMBER 1996
e::,
Prepared by
The Finance Deparnnent
October 8, 1996
.:\-~,
EXHIBIT 1
GL1 02 CITY OF DUBLIN PAGE
10/07196 BALANCE SHEET 9.39.3
FOR THE
PERIOO 7196 THROUGH 9/96
.'
GENERAL SPECIAL SPECIAL CAP IT AL TRUST/ TOT A::'
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONL -;~
FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 199
ASSETS
CASH 1593692.32- 1441460.58 251979.79 390506.80 11517.89 501m.74 759813.70
CASH WITH FISCAL AGENT 130456.16 130456.16 122942.24
UNAMORTIZED BOND DISCOUNT
INVESTMENTS AT COST 23678006.89 23678006.89 21793120.38
RECEIVABLES:TAXES
ACCOUNTS (NET) 232193.37- 63278.52 239395.79 70480.94 437477.67
INTEREST 47163.90 47163.90 52135.04
ASSESSMENTS
RENTS
NOTES
DU: FROM OTHERS 27563.44 27563.44 5967.43
INVENTORY AT COST
PREPAID ITEMS 5718.37 5718.37 4915.n
FIXED ASSETS
AMOUNTS TO BE PROVIDED 2090500.00 2090500.00 2090500.00
TOTAL ASSETS 21905003.47 1532302.54 251979.79 629902.59 2232474.05 26551662.44 23747244.78
.
LIAS, FND BAL, RETNO EARNINGS 5S :.:
DEPOSITS FOR PRIVATE DEVELPMNT 244122.92- 244122.92- ,::14-
DEPOSITS FOR AB1600 FEES 525081.38- 525081.38- 231112.48-
DEPOSITS OTHERS 442399.23- 239395.79- 681795.02- 633167.20-
PAYABLES:ACCOUNTS 297090.04- 182095.67- 48598.38- 527784.09- 170150.37-
INTEREST
PAYROLL 38616.50- 38616.50- 32707.23-
DUE TO OTHERS 200.00- 200.00- 760.00-
DEBT INSTRUMENTS PAYABLE 2208000.00- 2208000.00- 2208000.00'
TOTAL LIABILTIES 1022428.69- 182095.67- 813075.55- 2208000.00- 4225599.91- 3281406.42
FUND BALANCES 20882574.78- 1350206.87- 251919.79- 1831n.96 24474.05- 22326062.53- 20465838.36'
TOTAL FUND EQUITY 20882574.78- 1350206.87- 251979.79- 1831n.96 24474.05- 22326062.53- 20465838.36.
TOTAL LIAB,FND BAL, RETD EARNS 21905003.47- 1532302.54- 251979.79- 629902.59- 2232474.05- 26551662.44- 23747244.78-
e::
GL102
10/07/96
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD 7/96 THROUGH 9/96
e.:.
INTERNAL
SERVICE
FUND
ASSETS
CASH
CASH WITH FISCAL AGENT
UNAMORTIZED BOND DISCOUNT
307600.31
INVESTMENTS AT COST
RECEIVABLES:TAXES
ACCOUNTS (NET)
INTEREST
ASSESSMENTS
RENTS
NOTES
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNTS TO BE PROVIDED
574365.04
TOTAL ASSETS
...:...B' FND BAL, RETND EARNINGS
~EPOSITS FOR PRIVATE DEVELPMNT
DEPOSITS OTHERS
PAYABLES:ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES
FUND BALANCE
CONTRIBUTIONS
INVESTMENTS IN FIXED ASSETS
RETAINED EARNINGS
TOTAL FUND EQUITY
881965.35
536148.32w
345817.03w
881965.35-
ENTERPRISE
FUNDS
FIXED ASSETS GENERAL LONG
GROUP OF TERM DEBT
ACCOUNTS . ACCOUNT GROUP
1000.00-
1719329.47
20084069.28
21802398.75
16265000.00w
16265000.00-
427508.75-
5109890.00-
881965.35- 21802398.75-
5537398.75-
TOTAL LIAB,FND BAL, RETD EARNS
e.:.:.
~
513348.70
513348.70
513348.70-
513348.70-
5327970.26
5327970.26
5327970.26-
5327970.26-
513348.70- 5327970.26-
PAGE 1
9.39.49
TOTALS
--- MEMORANDUM ONLY ---
CURRENT JUNE 30, 1996
306600.31
1719329.47
21171783.02
5327970.26
28525683.06
21592970.26-
21592970.26-
963657.07-
5455707.03-
513348.70-
6932712.80-
220706.32
1743704.59
213650n.67
2855403.88
26184887.46
19825403.88-
19825403.88-
515357.87-
5347612.75-
496512.96-
6359483.58-
28525683.06- 26184887.46-
GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE
10/07/96 REVENUES VERSUS EXPENDITURE 8.59.(
FOR THE
PERIOD 7/96 THROUGH 9/96
GENERAL REVENUE FUND .-
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
........REVENUES......*
PROPERTY TAXES 3968400.00- 300973.70- 7.6 3667426.30- 3867613.84- 314275.85- 8.1 3553337.99-
SALES TAX 6480000.00- 1262272.58- 19.5 521m7.42- 6354506.63- 11B3498.84- 18.6 5171007.79-
REAL PROPERTY TRANSFERS 73600.00- 19641.17- 26.7 5395B.83- 60181.18- 11740.89- 19.5 48440.29-
TRANSIENT OCCUPANCY TAX 176000.00- 14028.00- 8.0 161972.00- 198284.00- .00 198284.00-
FRANCHISE TAXES 709800.00- 57040.12- 8.0 652759.88- 607146.84- 24546.84- 4.0 5B2600.00-
LICENSES & PERMITS 873400.00- 212147.1B- 24.3 661252.82- 46619B.72- 78845.35- 16.9 387353.37-
FINES & FORFEITURES 36000.00- 7689.46- 21.4 28310.54- 38792.BO- 10112.56- 26.1 28680.24-
USES OF MONEY AND PROPERTY 125.9600.00- 91276.36- 7.2 1168323.64- 1268885.15- 56796.00- 4.5 1212089.15-
INTERGOVERNMENTAL FROM STATE 1085650.00- 266069.67- 24.5 B19580.33- 1102495.65- 301895.41- 27.4 B00600.24-
CHARGES FOR SERVICES 1393510.00- 247429.23- 17.B 1146080.77- 1372959.58- 279153.19- 20.3 1093806.39-
OTHER SOURCES OF REVENUE 114659.75- 67320.05- 58.7 47339.70- 110803.95- 50700.57- 45.8 60103.38-
TOTAL REVENUE 16170619.75- 2545887.52- 15.7 13624732.23- 15447868.34- 2311565.50- 15.0 13136302.84-
*******EXPENDITUREs*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 101250.00 26.00- 101276.00 .00 .00 .00
CITY CooNCI L 1010 125764.00 27499.00 21.9 98265.00 1273B9.95 24367.34 19.1 103022.61
CITY MANAGER 1020 297973.00 66144.15 22.2 231828.85 275B33.29 63649.31 23.1 212183.'9'(
CITY ATTORNEY 1030 1541B1.00 165B2.38 10.B 137598.62 161933.22 23670.70 14.6 138 . '
ADMIN SERVICES 1040 606360.00 120602.90 19.9 485757.10 495172.80 96619.56 19.5 ~:.>
BUILDING MANAGEMENT 1050 321500.00 37462.90 11.7 284037. 10 335485.57 6m5.52 20.2
FACILITY RENTAL 1050-719 1601985.00 376880.55 23.5 1225104.45 1499521.58 390764.72 26.1 1108756.86
INSURANCE COST CENTER 1060 133550.00 80632.48 60.4 52917.52 101710.52 69909.32 68.7 31801.20
ELECTIONS COST CENTER 1070 6365.00 74.12 1.2 6290.88 563.52 .00 563.52
ACTIVITY TOTAL 334892B.00 725B52.48 21.7 2623075.52 2997610.45 736706.47 24.6 2260903.98
PUBLI C SAFETY:
POll CE 2010 4076978.00 65743.49 1.6 4011234.51 3540387.5B 52476.61 1.5 3487910.97
CROSSING GUARDS COST 2020 43000.00 .00 43000.00 43292.88 .00 43292.88
ANIMAL CONTROL 2030 180286.00 .00 1B0286.00 126363.14 .00 126363.14
DISASTER PREAPREDNESS 2050 32785.00 7134.B9 21.B 25650.11 27045.45 6491.95 24.0 20553.50
FIRE SERVICES JPA 2060 3195294.00 691884.02 21.7 2503409.98 2978987.58 980076.00 32.9 1998911.5B
ACTIVITY TOTAL 752B343.00 764762.40 10.2 6763580.60 6716076.63 1039044.56 15.5 5677032.07
TRANSPORT A TI ON :
PUBLI C WORKS 3010 320BB7.00 64714.83 20.2 256172.17 304830.22 66251.96 21.7 23B578.26
STREET MAINTENANCE 3020 128200.00 20927.29 16.3 107272.71 140949.59 .00 140949.59
STREET TREE MAINTENANCE 3040 48580.00 1492.22 3.1 47087.7B 48192.39 4080.05 8.5 44112.34
STREET LANDSCAPE MAINT. 3050 199610.00 21075 .21 10.6 17B534.79 197364.32 36723.77 18.6 160640.55
ACTIVITY TOTAL 697277.00 108209.55 15.5 5B9067.45 691336.52 107055.78 15.5 584280.74
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
LIBRARY SERVICES B010 205874.00 .00 205874.00 194188.00 .00 194188.00
CULTURAL ACTIVITIES 8011 12500.00 10000.00 BO.O 2500.00 17500.00 10000.00 57.1 7500.00
HERITAGE CENTER 8012 51960.00 8124.89 15.6 43835.11 41860.33 666B.11 15.9 35192.22
DUBLIN CEMETERY 8013 17160.00 956.91 5.6 16203.09 16075.33 1694.37 10.5 14380.96
PARK MAINTENANCE 8020 573868.00 46021.49 8.0 527846.51 554536.91 102471.27 18.5 452065.64
COMMUNITY CABLE TV 8030 33916.00 22211.72 65.5 11704.28 23736.00 .00 23736.00
RECREATION ADMIN. 8040 242784.00 48513.64 20.0 194270.36 190175.44 42644.76 22.4 14~.<>..c,.i
f,..,
-'
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2
10/07/96 REVENUES VERSUS EXPENDITURE 8.59.47
FOR THE
PERIOD 7/96 THROUGH 9/96
" -
.;. GENERAL REVENUE FUND
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
PLAYGROUNDS 8045 109528.00 34362.03 31.4 75165.97 99908.83 31603.67 31.6 68305.16
SHANNON CENTER 8050 134604.00 23580.79 17.5 111023.21 128665.35 24945.90 19.4 103719.45
PRESCHOOL 8055 52070.00 112n.90 21.6 40797.10 48241.56 8788.99 18.2 39452.57
TEENS PROGRAM 8060 35294.00 4966.26 14.1 30327.74 29512.30 6207.48 21.0 23304 .82
ADULT SPORTS 8065 62718.00 14423.75 23.0 48294.25 59974.79 14m.65 24.6 45201.14
yooTH SPORTS 8066 37176.00 7632.58 20.5 29543.42 33593.09 7318.70 21.8 26274.39
SPECIAL EVENTS 8070 38930.00 90n.84 23.3 29857.16 33694.49 4039.86 12.0 29654.63
SENIOR CENTER 8080 112578.00 17435.22 15.5 95142.78 100622.69 23912.71 23.8 76709.98
RECREATION INSTRUCTION 8090 80763.00 20525.93 25.4 60237.07 76940.68 19067.84 24.8 57872.84
AQUATICS 8100 198917.00 80130.37 40.3 118786.63 196m.22 65m.48 33.4 130995.74
ACTIVITY TOTAL 2000640.00 359231.32 18.0 1641408.68 1845999.01 369914.79 20.0 1476084.22
COMMUNITY DEVELOPMENT:
PLANNING 9010 732994.00 153053.98 20.9 579940.02 838445.66 155946.03 18.6 682499.63
BUILDING SAFETY 9020 365919.00 47705.08 13.0 318213.92 263771.36 44005.04 16.7 219766.32
ENGINEERING 9030 547425.00 n447.10 13.2 474977.90 569323.23 132668.71 23.3 436654.52
ECONOMIC DEVELOPMENT 9040 106996.00 25980.08 24.3 81015.92 106703.40 22364.51 21.0 84338.89
ACTIVITY TOTAL 1753334.00 299186.24 17.1 1454147.76 1778243.65 354984.29 20.0 142325936
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 93NN 105980.00 3n1 .74 3.5 102258.26 73453.55 1658.80 2.3 71794.75
COMMUNITY IMPROVEMENTS 94NN 389650.00 48369.96 12.4 341280.04 124136.78 35072.39 28.3 89064.39
PAR~S 95NN 60815.00 1835.33 3.0 58979.67 20046.02 .00 20046.02
e::':'-REET CONSTRC/lMPROVMT 96NN 201850.00 170815.95 84.6 31034.05 104607.01 .00 104607.01
" ACTIVITY TOTAL 758295.00 224742.98 29.6 533552.02 322243.36 36731.19 11.4 285512.17
TOT A L EXPENDITURES 16086617.00 2481984.97 15.4 13604832.03 14351509.62 2644437.08 18.4 117070n.54
EXCESS [REVENUE>EXPENDITURES 83802.75- 63902.55- 76.3 19900.20- 1096358.n- 332871.58 30.4- 1429230.30-
TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 38508.75- .00 38508.75-
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 18673.28 .00 18673.28
EXCESS [REVENUE> EXPENDITURE 83802.75- 63902.55- 76.3 19900.20- 1116194.19- 332871.58 29.8- 1449065.77-
e::"
~
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE
10/07/96 REVENUES VERSUS EXPENDITURE 9.05.~,
FOR THE
PERIOO 7/96 THROUGH 9/96
."
SPECIAL REVENUE FUNDS ".":.
CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
SALES TAX 136000.00- 22462.91- 16.5 113537.09. 141116.52- 32914.39- 23.3 108202.13
FINES & FORFEITURES 24500.00. 3879.99- 15.8 20620.01- 24330.57. 3922.71- 16.1 20407.86
USES OF MONEY AND PROPERTY 76830.00- .00 76830.00. 89945.79- .00 89945.79
INTERNGOVERNMENTAL FROM STATE 523290.00- 88655.79- 16.9 434634.21- 536n4.31- 92105.00- 17.2 444619.31
INTERGOVERNMENTAL FROM COUNTY 90000.00- 2m9.00- 30.8 62261.00- 126n6.0o- 32382.00- 25.6 94344.00-
INTERGOVERNMENTAL FROM FEDERAL 369757.00- .00 369757.00- 1908174.78- 144587.60- 7.6 1763587.18.
CHARGES FOR SERVICES 764600.00- .00 764600.00. 820879.80. .00 820879.80-
OTHER SOURCES OF REVENUE 130350.00- 11394.00- 8.7 118956.00- 568753.12- 4324.59- .8 564428.53.
TOTAL REVENUE 2115327.00. 154131.69- 7.3 1961195.31. 4216650.89- 310236.29- 7.4 3906414.60.
*******EXPENDI TURES*******
GENERAL GOVERNMENT ACTIVITIES:
BUILDING MANAGEMENT .00 .00 .00 244.70 .00 244.70
ACTIVITY TOTAL .00 .00 .00 244.70 .00 244 . 70
PUBLI C SAFETY:
POLICE 5n5.00 .00 5n5.00 5899.29 .00 5899.29
TRAFFIC SIGNALS 109327.00 6501.30 5.9 102825.70 85416.04 7462.65 8.7 77953.39
ACTIVITY TOTAL 115052.00 6501.30 5.7 108550.70 91315.33 7462.65 8.2 83852.68
TRANSPORT A TI ON: ';-
PUBLI C WORKS 321.00 .00 321.00 1.45 .00
STREET MAINTENANCE 198960.00 5445.09 2.7 193514.91 163324.71 14365.48 8.8
STREET SWEEPING 75600.00 6173.47 8.2 69426.53 69954.11 11653.88 16.7 58300 . ,
ACTIVITY TOTAL 274881.00 11618.56 4.2 263262.44 233280.27 26019.36 11.2 20n60.9i
HEALTH & WELFARE:
WASTE MANAGEMENT 743135.00 19771.09 2.7 n3363.91 1183933.08 8908.20 .8 1175024.88
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
PLANNING 1275.00 .00 1275.00 .00 .00 .00
ENGINEERING 98102.00 8590.26 8.8 89511.74 51425.60 12467.82 24.2 38957.78
ACTIVITY TOTAL 99377.00 8590.26 8.6 90786.74 51425.60 12467.82 24.2 38957.78
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS .00 .00 .00 7089.00 .00 7089.00
COMMUNITY IMPROVEMENTS 168510.00 .00 168510.00 80111.16 16517.16 20.6 63594.00
PARKS 399795.00 .00 399795.00 211220.20 17152.01 8.1 194068.19
STREET CONSTRUCTION/IMPROVMT 620540.00 190714.54 30.7 429825.46 1967504.82 117358.95 6.0 1850145.87
ACTIVITY TOTAL 1188845.00 190714.54 16.0 998130.46 2265925.18 151028.12 6.7 2114897.06
TOT A L EXPENDITURES 2421290.00 237195.75 9.8 2184094.25 3826124.16 205886.15 5.4 3620238.01
EXCESS [REVENUE>EXPENDITURE 305963.00 83064.06 27.1 222898.94 390526.73. 104350.14- 26.7 286176.59'
TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 19860.59. .00 19860.59-
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 28838.30 .00 28838.30
EXCESS [REVENUE> EXPENDITURE 305963.00 83064.06 27.1 222898.94 381549.02- 104350.14- 27.3 277198.88-
.-:
~
GL'04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
10/07/96 REVENUES VERSUS EXPENDITURE 9.'0."
FOR THE
PER I OD 7/96 THROUGH 9/96
. SPECIAL ASSESSMENT FUNDS
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS 234660.00- .00 234660.00- 318115.75- .00 318115.75-
USES OF MONEY AND PROPERTY 20280.00- 1672.49- 8.2 18607.51- 17813.47- .00 17813.47-
OTHER SOURCES OF REVENUE 4000.00- .00 4000.00- .00 .00 .00
TOTAL REVENUE 258940.00- 1672.49- .6 257267.51- 335929.22- .00 335929.22-
*******EXPENDI TURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00 .00 .00 .00
PUBLIC SAFETY:
TRFC SIGS/STREET LIGHTING 130569.00 11480.79 8.8 119088.21 180611.18 31959.08 17.7 148652.10
ACTIVITY TOTAL 130569.00 11480.79 8.8 119088.21 180M 1.18 31959.08 17.7 148652.10
TRANSPORTATION:
PUBLI C WORI::S 7688.00 695.56 9.0 6992.44 3947.86 898.42 22.8 3049.44
STREET TREE MAINTENANCE 8470.00 64.98 .8 8405.02 8867.39 532.38 6.0 8335.01
STREET LANDSCAPE MAINTENANCE 1 13800 . 00 18243.71 16.0 95556.29 105578.03 1m8.63 16.8 87799.40
ACTIVITY TOTAL 129958.00 19004.25 14.6 110953.75 118393.28 19209.43 16.2 99183.85
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
~~MUNITY DEVELOPMENT:
"NGINEERING 3560.00 3023.44 84.9 536.56 3085.26 3027.96 98.1 57.30
... ACTIVITY TOTAL 3560.00 3023.44 84.9 536.56 3085.26 3027.96 98.1 57.30
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 10000.00 .00 10000.00 27505.63 5860.00 21.3 21645.63
STREET CONSTRUCTION/IMPROVMT 103000.00 103048.50 100.0 48.50- 7649.54 .00 7649.54
ACTIVITY TOTAL 113000.00 103048.50 91.2 9951.50 35155.17 5860.00 16.7 29295.17
TOT A L EXPENDITURES 377087.00 136556.98 36.2 240530.02 337244.89 60056.47 17.8 277188.42
EXCESS [REVENUE>EXPENOITURE 118147.00 134884.49 114.2 16737.49- 1315.67 60056.47 4564.7 58740.80-
EXCESS [REVENUE> EXPENDITURE 118147.00 134884.49 114.2 16737.49- 1315.67 60056.47 4564.7 58740.80-
e'.
".--,
&7
GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE
10/07/96 REVENUES VERSUS EXPENDITURE 9.29.1,
FOR THE
PERIOD 7/96 THROUGH 9/96 .~:~.
CAPITAL IMPROVEMENT FUND
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
OTHER SOURCES OF REVENUE 870421. 00- 70429.55- 8.1 799991.45- 839611.07- .00 839611.07-
TOTAL REVENUE 870421.00- 70429.55- 8.1 799991.45- 839611.07- .00 839611.07-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .00 .00 .00 .00 .00 .00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & YELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 100000.00 .00 100000.00 .00 .00 .00
COMMUNITY IMPROVEMENTS 8500.00 .00 8500.00 8021.n .00 8021.n
STREET CONSTRUCT I ON/I MPROVMT 789421.00 84636.27 10.7 704784.73 707259.92 36375. 11 5.1 670884.81
ACTIVITY TOTAL 897921.00 84636.27 9.4 813284.73 715281.69 36375.11 5.1 678906.:
TOT A L EXPENDITURES 897921.00 84636.27 9.4 813284.73 715281.69 36375 . 11 5.1 678906.5i
EXCESS [REVENUE>EXPENDITURE 27500.00 14206.72 51.7 13293.28 124329.38- 36375 . 11 29.3- 1.:~-
TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 29531.04 .00
;.,q S~:;;c.J/
EXCESS [REVENUE> EXPENDITURE 27500.00 14206.72 51.7 13293 .28 94798.34- 36375 . 11 38.4- 131173.45-
.::
1
GL1()i,C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1
10/07/96 REVENUES VERSUS EXPENDITURE 9.34.47
FOR THE
PERIOD 7/96 THROUGH 9/96
. TRUST/AGENCY FUND
CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
SPECIAL BENEFITS ASSESSMENTS .00 .00 .00 234629.50- .00 234629.50-
USES OF MONEY AND PROPERTY .00 538.94- 538.94 11997.60- 38.55- .3 11959.05-
TOTAL REVENUE .00 538.94- 538.94 246627.10- 38.55- 246588.55-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL .00 153314.75 153314.75- 232584.50 151269.75 65.0 81314.75
ACTIVITY TOTAL .00 153314.75 153314.75- 232584.50 151269.75 65.0 81314.75
PUBlI C SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COHHUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOTAL EXPENDITURES .00 153314.75 153314.75- 232584.50 151269.75 65.0 81314.75
EXCESS(REVENUE)EXPENDITURE .00 152775.81 152775.81- 14042.60- 151231.20 1076.9- 165273.80-
EXCESS (REVENUE) EXPENDITURE .00 152775.81 152775.81- 14042.60- 151231.20 1076.9- 165273.80-
e:.-;
e'.
,"--
ri
'"
..
GL 1 04C THE CITY OF DUBLIN STATEMENT SHOUING PAGE
10/07196 REVENUES VERSUS EXPENDITURE 9.15.3
FOR THE
PERlOO 7196 THROUGH 9196
INTERNAL SERVICE FUND .:',
CURRENT PERlOO PREVIOUS YEAR ENDING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
USES OF MONEY AND PROPERTY 16300.00- .00 16300.00- 15884.33- .00 15884.33-
CHARGES FOR SERVICES 216315.00- 47508.47- 22.0 168806.53- 184255.91- .00 184255.91-
OTHER SOURCES OF REVENUE 12100.00- 1on.7o- 8.9 11027.30- 29894.08- 22365.92- 74.8 7528.16-
TOTAL REVENUE 244715.00- 48581.17- 19.9 196133.83- 230034.32- 22365.92- 9.7 207668.40-
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 288082.00 16081.45 5.6 272000.55 5n29.08 94224.03 164.6 36994.95-
ACTIVITY TOTAL 288082.00 16081.45 5.6 2nooo.55 5n29.08 94224.03 164.6 36994 .95-
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 288082.00 16081.45 5.6 2nOOO.55 5n29.08 94224.03 164.6 36994.95-
EXCESS [REVENUE>EXPENDITURE 43367.00 32499.n- 74.9- 15866 . 72 172805.24- 71858.11 41.6- 244663.35-
EXCESS [REVENUE> EXPENDITURE 43367.00 32499.n- 74.9- 15866.n 172805.24- 71858.11 41.6- 2.;,;-
.'
. - ~ . .
1
GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1
10/07/96 REVENUES VERSUS EXPENDITURE 9.21.35
FOR THE
PERIOD 7196 THROUGH 9/96
.' ENTERPRISE FUNDS
CURRENT PERIOD PREVIOUS YEAR ENOING JUNE 30, 1996
BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE
FISCAL YR Y-T-D
********REVENUES*******
USES OF MONEY AND PROPERTY 1709285.00- 381827.48- 22.3 1327457.52- 1594060.99- 395809.28- 24.8 1198251.71 -
TOTAL REVENUE 1709285.00- 381827.48- 22.3 1327457.52- 1594060.99- 395809.28- 24.8 1198251. 71-
*******EXPENOITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 1602005.00 71609.88 4.5 1530395.12 1388507.17 73901.13 5.3 1314606.04
ADMIN SERVICES 4365.00 1000.00 22.9 3365.00 6948.40 1125.00 16.2 5823.40
ACTIVITY TOTAL 1606370.00 72609.88 4.5 1533760.12 1395455.57 75026.13 5.4 1320429.44
PUBLI C SAFETY:
DISASTER PREAPREDNESS .00 .00 .00 1226.33 .00 1226.33
ACTIVITY TOTAL .00 .00 .00 1226.33 .00 1226.33
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION .00 .00 .00 10125.56 3210.01 31.7 6915.55
SENIOR CENTER .00 .00 .00 200.00 .00 200.00
ACTIVITY TOTAL .00 .00 .00 10325.56 3210.01 31.1 7115.55
COMMUNITY DEVELOPMENT:
~'PITAL IMPROVEMENT PROJECTS:
,) TAL EXPEND ITURES 1606370.00 72609.88 4.5 1533760.12 1407007.46 78389.05 5.6 1328618.41
~XCESS[REVENUE>EXPENDITURES 102915.00- 309217.60- 300.5 206302.60 187053.53- 317420.23- 169.7 130366.70
TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 18673 .28- .00 18673.28-
EXCESS [REVENUE> EXPENDITURE 102915.00- 309217.60- 300.5 206302.60 205726.81- 317420.23- 154.3 111693.42
.,..:
IS