The URL can be used to link to this page

Home My WebLink AboutItem 4.04 PrelimFinRptJuly&Aug1996CITY CLERK AGENDA STATEMENT CITY COUNCIL MEETING DATE: (October 1, 1996) SUBJECT: Preliminary Financial Report For the Months of July 1996 and August 1996 fit-1 Report Prepared by: Paul S. Rankin, Assistant City Manager EXHIBITS ATTACHED: 1. Preliminary Balance Sheet and Income Statements for the Period Ending July 31, 1996 2. Preliminary Balance Sheet and Income Statements for the Period Ending August 31, 1996 RECOMMENDATION: Accept and file the report. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides a preliminary report of the monthly financial statements for the months of July and August. The reason that the report is presented as "preliminary" is that the final audited results of Fiscal Year 1995/96 are not available. The analysis of information presented with the report will focus on the August 1996 Statements (Exhibit 2), as these reflect the most current information. 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. The Auditors recently concluded the majority of the field work necessary for the 1995/96 Audit. The final audit results will impact the reported Fund Balance presented in the attached monthly reports. For example, any General Fund Revenues which exceeded the 1995196 Expenditures have not been carried forward 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. Staff anticipates the final entries will occur by the October report. In addition there is a final accrual of Sales Tax for Fiscal Year 1995/96. The sales tax entry along with changes in the timing of revenue recognition, will create differences when comparing to the prior Fiscal Year data for July and August. Given that this is only the second month of the 1996/97 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 W- expenditures due to the significant amount of services provided to the City by independent contractors COPIES TO: ITEM NO. _4,v 4 r� Overall, the General Fund Revenues are performing comparable to what occurred in the first two months of the previous Fiscal Year. As previously noted direct comparisons of some revenue categories are not possible until the final audit adjustments are made. Changes in the timing of revenue recognition which are required by new accounting standards, complicate a year to year comparisons of Sales Tax and Transient Occupancy Tax. In the first two months of Fiscal Year 1996 -97 Kaufinan & Broad obtained several Building Permits for the California Highlands project. This is reflected in the increase in the License & Permit category, compared to the amount collected in the first two months of Fiscal Year 1995/96. Based upon the limited information available there were not any areas with significant deviations from the current budget projections. Overall, Expenditures through the month of August in the General Fund totaled $1,429,044 and represented 8.9% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $146,939 was related to Capital Improvement Projects (CIP) 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 tinting. For example, through August of the current fiscal year, 19.4% of the 1996/97 general fund budget associated with CIP projects had been expended. The amount expended in the first two months of the previous year represented only, 8.4% of total General Fund CIP expenditures for the year. In looking at only General Fund Operating Expenditures, the City had expended 8.4% of the General is Fund Operating Budget, through August 31, 1996. Operating Expenditures in July and August of 1995 accounted for approximately 12.8% of the total 1995 /96 General Fund Operating Expenditures. As previously noted there are some timing differences with payment for contract services, which complicate comparisons between one year to the next. For example, the City had made two DRFA contributions in the first two months of Fiscal Year 1995/96 and only one was recorded in the same period of the current .- Fiscal Year. All expenditures to date are within the authorized budget. It is recommended that the City Council receive and file these reports as authorized by Section 41004 of the California Government Code. 1-1 �! UA CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JULY 1996 Prepared by The Finance Department September 20, 1996 x:11130ail :. ti -J IL102 9/20/96 ASSETS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/96 THROUGH 7/96 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUNDS FUNDS FUND ;ASH 18D49D8.51- 1236632.42 240080.90 110141.42 164832.64 :ASH WITH FISCAL AGENT 11362.55 129917.22 JNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 24268006.89 RECEIVABLES:TAXES 74334.65 ACCOUNTS (NET) 194073.81 63278.52 168966.24 INTEREST 107209.14 ASSESSMENTS 8218.15 22739.57 RENTS NOTES DUE FROM OTHERS 406140.56 INVENTORY AT COST PREPAID ITEMS 4332.75 FIXED ASSETS AMOUNTS TO BE PROVIDED 2090500.00 TOTAL ASSETS 22843048.73 1714269.65 262820.47 279107.66 2385249.86 LIAR, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 178055.84 - DEPOSITS FOR AB160D FEES 210233.11 - DEPOSITS OTHERS 387243.48- 168966.24 - PAYABLES:A000UNTS 1323906.25- 218849.51- 10772.82- 70824.16 - INTEREST PAYROLL 5957.33 DUE TO OTHERS 477.50 - DEBT INSTRUMENTS PAYABLE 2208000.00 - TOTAL LIABILTIES 1863725.74- 218849.51- 10772.82- 450023.51- 2208000.00 - FUND BALANCES 20959322 -99- 1495420.14- 252047.65- 170915.85 177249.86 - TOTAL FUND EQUITY 20959322.99- 1495420.14- 252047.65- 170915.85 177249.86 - TOTAL LIAB,FND SAL, RETD EARNS 22843048.73- 1714269.65- 262820.47- 279107.66- 2385249.86- PAGE 1 16.54.31 T 0 T A L S - -- MEMORANDUM ONLY - -- CURRENT JUNE 30, 1996 53221.13- 12957.59- 129917.22 122908.73 24268006.89 20421120.38 74334.65 51420.77 426318.57 540902.39 107209.14 104509.39 30957.72 11362.55 406140.56 2739D4.84 4332.75 3934.60 2090500.00 2158500.00 27484496.37 23675606.06 178055.84- 73512.0 210233.11- 168652.4 - 5562D9.72- 616075.20- 1624352.74- 1123461.22- 5957.33 3612.34 - 477.50- 2208000.00- 2276000.00- 4771371.58- 4114286.63- 22713124.79- 19561317.43- 22713124.79- 19561317.43- 27484496.37- 23675606.06- • GL102 9/20/96 0 ASSETS CASH CASH WITH FISCAL AGENT UNA14DRTIZED BOND DISCOUNT 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 TOTAL ASSETS L ND BAL, RETND EARNINGS DEPOTS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:A000UNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCE CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY TOTAL LIAB,FND BAL, RETD EARNS K] CITY OF DUBLIN PAGE 1 BALANCE SHEET 16.54.50 FOR THE PERIOD 7/96 THROUGH 7/96 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S SERVICE FUNDS GROUP OF TERM DEBT - -- MEMORANDUM ONLY - -- FUND ACCOUNTS ACCOUNT GROUP CURRENT JUNE 30, 1996 267303.90 1000.00- 266303.90 287174.30 1719013.14 1719013.14 1743470.45 574365.04 20084069.28 513348.70 21171783.02 21365072.67 5327970.26 5327970.26 2855403.88 841668.94 21802082.42 513348.70 5327970.26 28485070.32 26251121.30 588.78- 588.78- 1441.46- 16265000.00- 5327970.26- 21592970.26- 19825403.88 -.- 588.78- 16265000.00- 5327970.26- 21593559.04- 19826845.34- 495263.13- 427192.42- 922455.55- 580150.25- 345817.03- 5109890.00- 5455707.03- 5347612.75- 513348.70- 513348.70- 496512.96- 841080.16- 5537082.42- 513348.70- 6891511.28- 6424275.96- 841668.94- 21802082.42- 513348.70- 5327970.26- 28485070.32- 26251121.30- 1040 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 7/20196 REVENUES VERSUS EXPENDITURE 16.13.58 FOR THE PERIOD 7/96 THROUGH 7/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 * * * * * ** RDPERTY TAXES 39684DO.00- .00 3968400.00- 3867613.84- .00 3867613.84 - 4LES TAX 648DD00.00- 456100.00- 7.0 60239DO.00- 6354506.63- 189000.00- 3.0 6165506.63 - EAL PROPERTY TRANSFERS 73600.00- .00 73600.00- 60181.18- 6461.42- 10.7 53719.76 - RANSIENT OCCUPANCY TAX 176000.00- .00 176000.00- 198284.00- 37065.00- 18.7 161219.00- RANCHISE TAXES 709800.00- .00 709800.00- 607146.84 - 7588.76- 1.2 599558.08 - ICENSES & PERMITS 873400.00- 127799.99- 14.6 745600.01- 466198.72- 27312.82- 5.9 438885.90 - INES & FORFEITURES 360DO.00- 2753.56- 7.6 33246.44- 38792.80- 4354.24- 11.2 34438.56 - SES OF MONEY AND PROPERTY 1259600.00- 9914.65- .8 1249685.35- 1268885.15- 16602.31- 1.3 1252282.84 - NTERGOVERNMENTAL FROM STATE 1085650.00- 85615.60- 7.9 1000034.40- 1102495.65- 95832.62- 8.7 1006663.03 - HARGES FOR SERVICES 1393510.00- 56135.04- 4.0 1337374.96- 1372959.58- 59689.76- 4.3 1313269.82 - THER SOURCES OF REVENUE 113595.75- 52054.68- 45.8 61541.07- 110803.95- 40746.00- 36.8 70057.95 - TOTAL REVENUE 16169555.75 - 790373.52- 4.9 15379182.73- 15447868.34- 484652.93- 3.1 14963215.41- - ***EXPENDITURES* * * * * ** ENERAL GOVERNMENT ACTIVITIES; NDN- DEPARTMENTAL 110000.00 .00 110000.00 .00 .OD .DO CITY COUNCIL 1010 125764.00 8327.90 6.6 117436.10 127389.95 10238.13 8.0 117151.82 CITY MANAGER 1020 297973.00 14716.64 4.9 283256.36 275833.29 15972.78 5.8 259860.51 CITY ATTORNEY 1030 154181.00 .00 154181.00 161933.22 532.32 .3 161400.90 ADMIN SERVICES 1D40 606360.00 26432.70 4.4 579927.30 495172.80 26503.88 5.4 468668.9 BUILDING MANAGEMENT 1050 321500.00 268D.14 .8 316819.86 335485.57 18434.43 5.5 317051.1 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 80212.09 60.1 53337.91 101710.52 .00 101710.52 ELECTIONS COST CENTER 1070 6365.00 .00 6365.00 $63.52 .00 563.52 ACTIVITY TOTAL 3357678.00 509250.02 15.2 2848427.98 2997610.45 462446.26 15.4 2535164.19 UBLIC SAFETY: POLICE 2010 4075978.OD 3374.33 .1 4072603.67 3540387.58 3365.47 .1 353702201 CROSSING GUARDS COST 2020 43000.00 .00 43000.00 43292.88 .00 43292.88 ANIMAL CONTROL 2030 180286.00 .DO 180286.00 126363.14 .00 126363.14 DISASTER PREAPREDNESS 2050 32785.00 1524.56 4.7 31260.44 27045.45 1541.79 5.7 25503.66 FIRE SERVICES JPA 2060 3195294.00 .00 3195294.00 2978987.58 490038.00 16.4 2488949.58 ACTIVITY TOTAL 7527343.00 4898.89 .1 7522444.11 6716076.63 494945.26 7.4 6221131.37 RANSPORTATION: PUBLIC WORKS 3010 320887.00 12757.32 4.0 308129.68 304830.22 19542.53 6.4 285287.69 STREET MAINTENANCE 3020 119450.00 .00 119450.00 140949.59 .00 140949.59 STREET TREE MAINTENANCE 3040 48580.00 .00 48580.00 48192.39 2319.94 4.8 45872.45 STREET LANDSCAPE MAINT. 3050 199610.00 .00 199610.00 197364.32 21988.40 11.1 175375.92 ACTIVITY TOTAL 688527.00 12757.32 1.9 675769.68 691336.52 43850.87 6.3 647485.65 EALTH & WELFARE: .ULTURE & LEISURE SERVICES; LIBRARY SERVICES 8010 205874.00 .00 205874.00 194188.00 .00 194188.00 CULTURAL ACTIVITIES 8011 12500.00 .00 12500.D0 17500.00 10000.00 57.1 7500.00 HERITAGE CENTER 8012 51960.00 596.56 1.1 51363.44 41860.33 1273.53 3.0 40586.80 DUBLIN CEMETERY 8013 17160.00 .00 17160.00 16075.33 285.01 1.8 15790.32 PARK MAINTENANCE 8020 573868.00 .00 573868.00 554536.91 62671.78 11.3 491865.13 COMMUNITY CABLE TV 8030 33916.00 .00 33916.00 23736.00 .00 23736.00 RECREATION ADMIN. BD40 242784.00 1D425.22 4.3 232358.78 190175.44 10928.65 5.7 179246 0 L104C 9/20/96 • PLAYGROUNDS 8045 SHANNON CENTER 8050 PRESCHOOL 8055 TEENS PROGRAM 8060 ADULT SPORTS 8065 YOUTH SPORTS 8066 SPECIAL EVENTS 8070 SENIOR CENTER 8080 RECREATION INSTRUCTION 8090 AQUATICS 8100 ACTIVITY TOTAL :OMMUNITY DEVELOPMENT: PLANNING 9010 BUILDING SAFETY 9020 ENGINEERING 9030 ECONOMIC DEVELOPMENT 9040 ACTIVITY TOTAL APITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 93NN COMMUNITY IMPROVEMENTS 94NN 95NN CONSTRC /IMPROVMT 96NN ACTIVITY TOTAL 0 T A L EXPENDITURES XCESS [REVENUE>EXPENDITURES RANSFERS IN FROM OTHER FUNDS RANSFERS OUT TO OTHER FUNDS XCESS [ REVENUE> EXPENDITURE • THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 7/96 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE 109528.00 9335.05 8.5 100192.95 134604.00 3621.57 2.7 130982.43 52070.00 2676.43 5.1 49393.57 35294.00 973.73 2.8 34320.27 62718.00 1933.86 3.1 60784.14 37176.00 1915.09 5.2 35260.91 38930.00 1366.71 3.5 37563.29 112578.00 4374.84 3.9 108203.16 80763.00 3000.10 3.7 77762.90 198853.00 22909.49 11.5 175943.51 2000576.00 63128.65 3.2 1937447.35 732994.00 29783.97 4.1 703210.03 365919.00 6879.40 1.9 359039.60 547425.00 16208.99 3.0 531216.01 106996.00 4958.24 4.6 102037.76 1753334.00 57830.60 3.3 1695503.40 105980.00 .00 101999.81 105980.00 389650.00 1857.28 .5 387792.72 60815.00 .00 73453.55 6DB15.DO 201850.00 .00 97276.18 201850.00 758295.00 1857.28 .2 756437.72 16085753.00 649722.76 4.0 15436030.24 83802.75- 140650.76- 167.8 56848.01 .00 .00 13116507.97 .00 .00 .00 1846707.44- .00 83802.75- 140650.76- 167.8 56848.01 PAGE 2 16.13.58 1116194.19 - 750348.72 67.2- 1866542.91- PREVIOUS YEAR ENDING JUNE 30, 1996 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D 99908.83 10561.18 10.6 89347.65 128665.35 6030.08 4.7 122635.27 48241.56 1723.24 3.6 46518.32 29512.30 1366.24 4.6 28146.D6 59974.79 3891.81 6.5 56082.98 33593.09 2275.76 6.8 31317.33 33694.49 1141.34 3.4 32553.15 100622.69 6328.33 6.3 94294.36 76940.68 5135.41 6.7 71805.27 196773.22 26725.46 13.6 170047.76 1845999.01 150337.82 8.1 1695661.19 838445.66 30314.51 3.6 808131.15 263771.36 3872.60 1.5 259898.76 569323.23 17670.14 3.1 551653.09 106703.40 4703.59 4.4 101999.81 1778243.65 56560.84 3.2 1721682.81 73453.55 .00 73453.55 124136.78 26860.60 21.6 97276.18 20046.02 .00 20046.02 104607.01 .00 104607.01 322243.36 26860.60 8.3 295382.76 14351509.62 1235001.65 8.6 13116507.97 1096358.72- 750348.72 68.4- 1846707.44- 38508.75- .00 38508.75- 18673.28 .00 18673.28 1116194.19 - 750348.72 67.2- 1866542.91- 3L104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/20/96 REVENUES VERSUS EXPENDITURE 16.18.50 FOR THE PERIOD 7/96 THROUGH 7/96 SPECIAL REVENUE FUNDS 0 CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * *-- *REVENUES * - * ** SALES TAX 136000.00- 9626.99- 7.1 126373.01- 141116.52 - 8329.91- 5.9 132786.61 - FINES & FORFEITURES 24500.00- 2105.03- 8.6 22394.97- 24330.57- .00 24330.57 - USES OF MONEY AND PROPERTY 76830.00- .00 76830.00- 89945.79- .00 89945.79 - INTERNGOVERNMENTAL FROM STATE 516000.00- 46614.52- 9.0 469385.48- 536724.31- .DO 536724.31 - INTERGOVERNMENTAL FROM COUNTY 90000.00- .OD 90000.00- 126726.00- .DO 126726.00 - INTERGOVERNMENTAL FROM FEDERAL 369757.00- .DO 369757.00- 19DB174.78- .00 1908174.78 - 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 2108037.00- 69740.54- 3.3 2038296.46- 4216650.89- 12654.50- .3 4203996.39- ** ** ***EXPENDITURES* * * * * ** GENERAL GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT .00 .00 .00 244.70 .DO 244.70 ACTIVITY TOTAL .00 .00 .00 244.70 .00 244.70 PUBLIC SAFETY: POLICE 5725.00 .00 5725.00 5899.29 .00 5899.29 TRAFFIC SIGNALS 109327.00 .00 109327.00 85416.04 473.45 .6 84942.59 ACTIVITY TOTAL 115052.00 .00 115052.00 91315.33 473.45 .5 90841.88 TRANSPORTATION: 321.00 321.00 1.45 .00 1.0 PUBLIC WORKS STREET MAINTENANCE 198960.00 .00 .00 198960.00 163324.71 8331.25 5.1 154993. STREET SWEEPING 75600.00 .00 75600.00 69954.11 5742.96 8.2 64211.15 ACTIVITY TOTAL 274881.00 .00 274881.00 233280.27 14074.21 6.0 219206.06 HEALTH & WELFARE: WASTE MANAGEMENT 742135.00 .00 742135.00 1183933.08 7933.20 .7 1175999.88 CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: PLANNING 1275.00 .00 1275 -00 .00 .00 .00 ENGINEERING 98102.00 1221.14 1.2 96880.86 51425.60 1448.67 2.8 49976.93 ACTIVITY TOTAL 99377.OD 1221.14 1.2 98155.86 51425.60 1448.67 2.8 49976.93 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS .00 .00 .DO 7089.00 .00 7089.00 COMMUNITY IMPROVEMENTS 168510.00 .00 168510.00 80111.16 7005.00 8.7 73106.16 PARKS 399795.00 .00 399795.00 211220.20 8088.00 3.8 203132.20 STREET CONSTRUCTION /IMPROVMT 613250.00 6370.19 1.0 606879.81 1967504.82 71850.95 3.7 1895653.87 ACTIVITY TOTAL 1181555.00 6370.19 .5 1175184.81 2265925.18 86943.95 3.8 2178981.23 T 0 T A L EXPENDITURES 2413000.00 7591.33 .3 2405408.67 3826124.16 110873.48 2.9 3715250.68 EXCESS [REVENUE>EXPENDITURE 304963.00 62149.21- 20.4- 367112.21 390526.73- 98218.98 25.2- 488745.71 - 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 [REVENUES EXPENDITURE 304963.00 62149.21- 2D.4- 367112.21 381549.02- 98218.98 25.7- 479768.00- • L1D4C THE CITY OF DUBLIN STATEMENT SHOWING 9/20/96 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 7/96 SPECIAL ASSESSMENT FUNDS PAGE 1 16.23.32 CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE *** ****REVENUES *** * *** .4 PECIAL BENEFITS ASSESSMENTS 234660.00 - SES OF MONEY AND PROPERTY 20280.00 - THER SOURCES OF REVENUE 4000.00 - TOTAL REVENUE 258940.D0- '*****EXPENDITURES******* 20280.00- ENERAL GOVERNMENT ACTIVITIES: .00 ACTIVITY TOTAL .00 UBL1C SAFETY: .00 TRFC SIGS /STREET LIGHTING 130569.00 ACTIVITY TOTAL 130569.00 RANSPORTATION: .00 PUBLIC WORKS 7688.00 STREET TREE MAINTENANCE 8470.00 STREET LANDSCAPE MAINTENANCE 113800.00 ACTIVITY TOTAL 129958.00 EALTH & WELFARE: 11287.75 :ULTURE & LEISURE SERVICES: 3085.26 DEVELOPMENT: 857.9 VY ERING 3560.00 ACTIVITY TOTAL 3560.00 :APITAL IMPROVEMENT PROJECTS: 7649.54 COMMUNITY IMPROVEMENTS 10000.00 STREET CONSTRUCTION /IMPROVMT 103000.00 ACTIVITY TOTAL 113000.00 0 T A L EXPENDITURES 377087.00 XCESSIREVENUE> EXPENDITURE 118147.00 XCESS IREVENUE> EXPENDITURE 118147.00 CJ .00 .4 FISCAL YR Y-T-D 1000.00 .00 234660.00- 318115.75- .00 318115.75- .00 20280.00- 17813.47- .00 17813.47- .00 4000.00- .00 .00 .00 .00 258940.00- 335929.22- .00 335929.22- .00 .4 .00 .00 1000.00 .8 129569.00 180611.18 1000.00 .8 129569.00 180611.18 127.63 1.7 7560.37 3947.86 .DO 107855.53 8470.DO 8867.39 .00 .00 113800.00 105578.03 127.63 .1 129830.37 118393.28 .00 7649.54 3560.00 3085.26 .00 11287.75 3560.00 3085.26 .00 857.9 10000.00 27505.63 .00 103000.00 7649.54 .00 11300O.DO 35155.17 1127.63 .3 375959.37 337244.89 1127.63 1.0 117019.37 1315.67 1127.63 1.0 117019.37 1315.67 .00 .00 750.00 .4 179861.18 750.00 .4 179861.18 484.93 12.3 3462.93 148.21 1.7 8719.18 9904.61 9.4 95673.42 10537.75 8.9 107855.53 .00 3D85.26 .00 3085.26 .00 27505.63 .00 7649.54 .00 35155.17 11287.75 3.3 325957.14 11287.75 857.9 9972.DB- 11287.75 857.9 9972.08- -,A iL1D4C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/20/96 REVENUES VERSUS EXPENDITURE 16.40.25 FOR THE PERIOD 7/96 THROUGH 7/96 CAPITAL IMPROVEMENT FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D °*** *** *REVENUES"* * **** )THER SOURCES OF REVENUE 870421.00- .00 870421.00- 839611.07- .00 839611.07 - TOTAL REVENUE 870421.00- .00 870421.00 - 839611.07- .00 839611.07- GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .DO .00 .00 .00 .00 .00 'UBL1C SAFETY: 'RANSPORTATION: iEALTH & WELFARE: XILTURE & LEISURE SERVICES: MIMIUNITY DEVELOPMENT: ;APITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 100000.00 .00 100000.00 .00 .00 .00 COMMUNITY IMPROVEMENTS 8500.00 .00 8500.00 8021.77 .00 8021.77 STREET CDNSTRUCTION /IMPRDVMT 789421.00 1949.61 .2 787471.39 707259.92 9309.05 1.3 697950.87 ACTIVITY TOTAL 897921.00 1949.61 .2 895971.39 715281.69 9309.05 1.3 705972.64 " O T A L EXPENDITURES 897921.00 1949.61 .2 895971.39 715281.69 9309.05 1.3 705972.64 _XCESSIREVENUE>EXPENDITURE 27500.DO 1949.61 7.1 25550.39 124329.38 - 9309.05 7.5- 133638.43 - "RANSFERS OUT TO OTHER FUNDS .00 .00 .00 29531.04 .00 29531 . EXCESS [REVENUES EXPENDITURE 27500.00 1949.61 7.1 25550.39 94798.34- 9309.05 9.8- 104107.39- 1104C 9/20/96 0 SPECIAL BENEFITS ASSESSMENTS 1SES OF MONEY AND PROPERTY TOTAL REVENUE -,*- EXPENDITURES * *** * ** GENERAL GOVERNMENT ACTIVITIES NON - DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: dEALTH & WELFARE: ZULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: :APITAL IMPROVEMENT PROJECTS: TOTAL EXPENDITURES EXCESS(REVENUE)EXPENDITURE EXCESS (REVENUE) EXPENDITURE 0 � 0 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 REVENUES VERSUS EXPENDITURE 16.51.20 FOR THE PERIOD 7/96 THROUGH 7/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 .00 .00 .00 234629.50- .00 234629.50- .00 .00 .00 11997.60- 5.04- 11992.56- .00 .00 .00 246627.10- 5.04- 246622.06- .00 .00 .00 232584.50 151269.75 65.0 81314.75 ,00 ,00 .00 232584.50 151269.75 65.0 81314.75 .00 .00 .00 232584.50 151269.75 65.0 81314.75 .00 .00 .00 14042.60- 151264.71 1077.2- 165307.31- .00 .00 .00 14D42.60- 151264.71 1077.2- 165307.31- J L104C THE CITY OF DUBLIN STATEMENT SHOWING ?/20/96 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 7/96 ***" **REVENUES * * * * * ** PAGE 1 16.44.28 INTERNAL SERVICE FUND 0 CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE SES OF MONEY AND PROPERTY 16300.00 - HARGES FOR SERVICES 216315.00 - THER SOURCES OF REVENUE 12100.00 - TOTAL REVENUE 244715.00 - *- *EXPENDITURES******* 184255.91- ENERAL GOVERNMENT ACTIVITIES: 121DO.OD- NON - DEPARTMENTAL 268082.00 ACTIVITY TOTAL 288082.00 'UBLIC SAFETY: 230034.32- RANSPORTATION: 230034.32- EALTH & WELFARE: ULTURE 8 LEISURE SERVICES: OMMUNITY DEVELOPMENT: APITAL IMPROVEMENT PROJECTS: 0 T A L EXPENDITURES 288082.00 'XCESSEREVENUE>EXPENDITURE 43367.00 XCESS [REVENUES EXPENDITURE 43367.00 FISCAL YR Y -T-D .00 16300.00- 15884.33- .00 15884.33- .00 216315.00- 184255.91- .00 184255.91- .00 121DO.OD- 29894.08- .00 29894.08- .00 244715.00- 230034.32- .00 230034.32- 8385.47 2.9 279696.53 57229.08 8385.47 2.9 279696.53 57229.08 8385.47 2.9 279696.53 57229.08 8385.47 19.3 34981.53 172805.24- 8385.47 19.3 34981.53 172805.24- 9116.91 15.9 48112.17 9116.91 15.9 48112.17 9116.91 15.9 48112.17 9116.91 5.3- 181922.15- 9116.91 5.3- 181922.15- •1 J L104C THE CITY OF DUBLIN STATEMENT SHOWING 9/20/96 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 7/96 • ENTERPRISE FUNDS PAGE 1 16.36.03 J CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T-D ** **** *REVENUES * ** * *** SES OF MONEY AND PROPERTY 1709285.00- 381511.15- 22.3 1327773.85- 1594060.99- 395575.14- 24.8 1198485.85 - TOTAL REVENUE 1709285.00- 381511.15- 22.3 1327773.85- 1594060.99- 395575.14- 24.8 1198485.85- ***** *EXPENDITURES * * * * * ** ENERAL GOVERNMENT ACTIVITIES: NON - DEPARTMENTAL 1602DD5.OD 71609.88 4.5 1530395.12 1388507.17 73901.13 5.3 1314606.04 ADMIN SERVICES 4365.OD 1DO0.00 22.9 3365.00 6948.40 1000.00 14.4 5948.40 _ ACTIVITY TOTAL 16D6370.00 72609.88 4.5 1533760.12 1395455.57 74901.13 5.4 1320554.44 USLIC SAFETY: DISASTER PREAPREDNESS .00 .OD .00 1226.33 .DO 1226.33 ACTIVITY TOTAL .00 .DO OD 1226.33 .00 1226.33 RANSPORTATION: EALTH & WELFARE: ULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION .DO .DO .00 10125.56 1202.60 11.9 8922.96 SENIOR CENTER .00 .DO .00 200.00 .00 200.00 ACTIVITY TOTAL .00 .00 .OD 10325.56 1202.60 11.6 9122.96 OMMUNITY DEVELOPMENT: A*CEVENUE>EXPENDITURES MPROVEMENT PROJECTS: EXPENDITURES 1606370.00 72609.88 4.5 1533760.12 1407007.46 76103.73 5.4 1330903.73 102915.00- 3D8901.27- 300.2 205986.27 187053.53- 319471.41- 170.8 132417.88 RANSFERS IN FROM OTHER FUNDS .00 .00 .00 18673.28- .00 18673.28 - XCESS [REVENUES EXPENDITURE 102915.00- 308901.27- 300.2 205986.27 205726.81- 319471.41- 155.3 113744.60 J CITY OF DUBLIN'S FINANCIAL STATEMENTS I a[INI THE MONTH OF AUGUST 1996 Prepared by The Finance Department September 20, 1996 I W4 .1.1: VIE C-1 Ll C` CITY OF DUBLIN PAGE 1 3L102 9.52.20 9/23/96 BALANCE SHEET FOR THE PERIOD 7/96 THROUGH 8/96 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S REVENUE REVENUE ASSESSMENT ENT IMPROVEMENT AGENCY -- MEMORANDUM ONLY --- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1996 ASSETS ;ASH 1528141.00- 1482172.89 257835.50 50669.25 11517.89 274054.53 85829.70 130456.16 130456.16 122925.57 SASH WITH FISCAL AGENT JNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 23378006.89 23378006.89 2D421120.38 2ECEIVABLES:TAXES ACCOUNTS (NET) 187513.09 63278.52 168966.24 419757.85 486300.97 INTEREST 68550.96 68550.96 68143.24 ASSESSMENTS RENTS NOTES )UE FROM OTHERS 27563.44 27563.44 5967.43 INVENTORY AT COST 5890.69 5995.75 'REPAID ITEMS 5890.69 =IXED ASSETS 2090500.00 2090500.00 2090500.00 AMOUNTS TO BE PROVIDEb TOTAL ASSETS 22111820.63 1573014.85 257835.50 219635.49 2232474.05 26394780.52 23286783.04 _I ND BAL, RETNb EARNINGS 158905.62- - 78979.54 ) FOR PRIVATE DEVELPMNT 158905.62- ]EP TS FOR A61600 FEES 210233.11- 210233.11- 170142.48 - )EPOSIT5 OTHERS 441335.48- 168966.24- 610301.72- 617375.20 - DAYABLES.ACCOUNTS 354662.38- 199549.35- 9710.82- 48598.38- 612520.937 337084.43 - INTEREST 36138.55- 174.06 PAYROLL 36138.55- )UE TO OTHERS 265.00- 265.00- $85.00- _ 2208000.00- 2208000.1)0- 2208000.00 - )EBT INSTRUMENTS PAYABLE TOTAL LIABILTIES 991307.03- 199549.35- 9710.82- 427797.73- 2208000.00- 3836364.93- 3254333.51 - =UND BALANCES 21120513.60- 1373465.5D- 248124.68- 208162.24 24474.05- 22558415.59- 20D32449.53- TOTAL FUND EQUITY 21120513.60- 1373465.50- 248124.68- 208162.24 24474,05- 22558415.59- 20032449.53 - 'OTAL LIAB,FND SAL, RETD EARNS 22111820.63- 1573014.85- 257835.50- 219635.49- 2232474,05- 26394780.52 - 23286783.04- K] J 102 /23/96 ASSETS 4H .SH WITH FISCAL AGENT IA14DRTIZED BOND DISCOUNT IVESTMENTS AT COST :CEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES )E FROM OTHERS 4VENTDRY AT COST ZEPAID ITEMS :XED ASSETS 4OUNTS TO BE PROVIDED TOTAL ASSETS IAB, FND BAL, RETND EARNINGS :POSITS FOR PRIVATE DEVELPMNT :POSITS OTHERS %YABLES:AC000NTS INTEREST PAYROLL JE TO OTHERS =_BT INSTRUMENTS PAYABLE TOTAL LIABILITIES JND BALANCE )NTRIBUTIONS 4VESTMENTS IN FIXED ASSETS TAINED EARNINGS TOTAL FUND EQUITY 3TAL LIAB,FND SAL, RETD EARNS CITY OF DUBLIN PAGE 1 BALANCE SHEET 9.53.03 FOR THE PERIOD 7/96 THROUGH 8/96 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S SERVICE FUNDS GROUP OF TERM DEBT - -- MEMORANDUM ONLY 0 ". FUND ACCOUNTS ACCOUNT GROUP CURRENT JUNE 30, 1996 266527.04 1000.00- 1719329.47 $74365.04 20084069.28 513348.70 5327970.26 840892.08 21802398.75 513348.70 5327970.26 265527.04 226191.05 1719329.47 1743699.44 21171783.02 21365072.67 5327970.26 2855403.88 28484609.79 26190367.D4 • -1 • i 16265000.00- 5327970.26- 21592970.26- 19825403.88- 16265000.00- 5327970.26- 21592970.26- 19825403.88- 495075.05- 427508.75- 922583.80- 520837.45- 345817.03- 5109890.00- 5455707.03- 5347612.75- 513348.70- 513348.70- 496512.96- 840892.08- 5537398.75- 513348 .70 - 6891639.53- 6364963.16- 840892.08- 21802398.75- 513348.70- 5327970.26- 28484609.79- 26190367.D4- • i -104C THE CITY OF DUBLIN STATEMENT SHOWING 7/23/96 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 8/96 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE PAGE 1 8.54.58 PREVIOUS YEAR ENDING JUNE 30, 1996 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D *******REVENUES******* 3968400.00- 3968400.00- 3667613.84- DD 3867613.84 - ROPERTY TAXES 6480000.00- .00 1064200.00- 16.4 5415800.00- 6354506.63- 747000.00- 11.8 5607506.63 - 4LES TAX :AL PROPERTY TRANSFERS 73600.00- 10299.89- 14.0 63300.11- 60181.18- 12705.87- 21.1 47475.31 - 2ANSIENT OCCUPANCY TAX 176000.00- 14028.00- 8.0 161972.00- 198284.00- 37065.00- 18.7 161219.00- 582250.06 - RANCHISE TAXES 709800.00- 28277.59- 4.0 681522.41- 607146.84- 24896.78- 4.1 ICENSES & PERMITS 873400 -00- 155011.98- 17.7 718388.02- 466198.72- 49482.43- 10.6 416716.29 - INES & FORFEITURES 36000,00- 4928.35- 13.7 31071.65- 38792.80- 8076.88- 20.8 30715.92 - SES OF MONEY AND PROPERTY 1259600,00- 49359.96 - 3.9 1210240.04- 1268885.15- 36492.30- 2.9 1232392.85 - NTERGOVERNMENTAL FROM STATE 1085650.00- 176917.83- 16.3 908732.17- 1102495.65- 177924.80- 16.1 924570.85 - HARGES FOR SERVICES 1393510.00- 162467.12- 11.7 1231042.88- 1372959.58- 152557.75- 11.1 1220401.83 - THER SOURCES OF REVENUE 113659.75- 65394.52- 57.5 48265.23- 110803.95- 47917.09- 43.2 62BB6.86- TOTAL REVENUE 16169619.75- 1730885.24- 10.7 14438734.51- 15447868.34- 1294118.90- 8.4 14153749.44- * * *** *EXPENDITURES*** * * ** HNERAL GOVERNMENT ACTIVITIES: 101250.00 26.00- 101276.00 .00 .00 .DO NDN-DEPARTMENTAL 1010 125764.00 15590.07 12.4 110173.93 127389.95 16111.38 12.6 111278.57 CITY COUNCIL CITY MANAGER 1020 297973.00 44517.85 14.9 253455.15 275833.29 35065.42 12.7 240767.87 CITY ATTORNEY 1030 154181.00 487.60 .3 153693.40 161933.22 532.32 .3 161400.90 SERVICES 1040 606360.00 75389.70 12.4 530970.30 495172 -80 53207.21 10.7 441965.59 NG MANAGEMENT 1050 321500.00 13332.91 4.1 308167.09 335485.57 30579.69 9.1 304905.88 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 80458.12 60.2 53091.88 101710.52 69734.76 68.6 31975.76 ELECTIONS COST CENTER 1070 6365.00 40.64 .6 6324.36 563.52 2997610.45 .OD 595995.50 19.9 563.52 2401614.95 ACTIVITY TOTAL 3348928.00 606671.44 18.1 2742256.56 UBLIC SAFETY: 2010 4075978.00 14430.52 .4 4061547.48 3540387.58 39728.11 1.1 35DO659.47 POLICE CROSSING GUARDS COST 2020 43000.00 .00 r 43000.00 43292.88 .00 43292.88 ANIMAL CONTROL 2030 180286.00 .00 180286.00 126363.14 .00 126363.14 DISASTER PREAPREDNESS 2050 32785.00 4372.05 13.3 28412.95 27045.45 3563.68 13.2 73481.77 FIRE SERVICES JPA 2060 3195294.00 229533.84 7.2 2965760.16 2978987.58 735057.00 24.7 2243930.58 ACTIVITY TOTAL 7527343.00 248336.41 3.3 7279OD6.59 6716076.63 778348.79 11.6 5937727.84 RANSPORTATION: PUBLIC WORKS 3010 320887.00 36448.66 11.4 284438.34 304830.22 34970.74 11.5 269859.48 STREET MAINTENANCE 3020 128200.00 20823.23 16.2 107376.77 140949.59 .00 140949.59 STREET TREE MAINTENANCE 3040 48580.00 .00 48580.00 48192.39 7319.94 4.8 45872.45 STREET LANDSCAPE MAINT, 3050 199610.00 147.38 .1 199462.62 197364.32 22056.38 11.2 175307.94 ACTIVITY TOTAL 697277.00 57419.27 8.2 639857.73 691336.52 59347.06 8.6 631989.46 '_ALTH & WELFARE: JLTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 205874.00 .00 205874.00 194188.00 .DD 144168.00 CULTURAL ACTIVITIES 8011 12500.00 10000.00 80.0 2500.00 17500.00 10000.00 57.1 7500.00 HERITAGE CENTER 8012 51960.00 2864.81 5.5 49095.19 41660.33 3651.65 8.7 38208.68 DUBLIN CEMETERY 8013 17160.00 750.00 4.4 16410.00 16075.33 285.01 1.8 15790.32 PARK MAINTENANCE 8020 573868.00 572.03 .1 573295.97 554536.91 63129.76 11.4 491407.15 COMMUNITY CABLE Tv BD30 33916.00 200.00 .6 33716.00 23736.DO .DO 23736.00 RE EATION ADMIN. 8040 242784.00 30724.53 12.7 212059.47 190175.44 23908.32 12.6 166267.12 16 . -1 L104C THE CITY OF DUBLIN STATEMENT SHOWING 9/23/96 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 8/96 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE PLAYGROUNDS 8045 109528.00 26628.56 24.3 82899.44 SHANNON CENTER 8050 134604.00 14966.18 11.1 119637.82 PRESCHOOL 8055 52070.00 7296.18 14.0 44773.82 TEENS PROGRAM 8060 35294.00 2801.48 7.9 32492.52 ADULT SPORTS 8065 62718.00 8408.80 13.4 54309.20 YOUTH SPORTS 8066 37176.00 6475.20 17.4 30700.80 SPECIAL EVENTS 8070 38930.00 7394.51 19.0 31535.49 SENIOR CENTER 8080 112578.00 11092.31 9.9 101485.69 RECREATION INSTRUCTION 8090 80763.00 8391.04 10.4 72371.96 AQUATICS 8100 198917.00 58070.86 29.2 140846.14 ACTIVITY TOTAL 2000640.00 196636.49 9.8 1804003.51 :OMMUNITY DEVELOPMENT: 106703.40 12351.20 11.6 94352.20 1778243.65 PLANNING 9010 732994.00 91185.17 12.4 641808.83 BUILDING SAFETY 9020 365919.00 18091.08 4.9 347827.92 ENGINEERING 9030 547425.00 45045.38 8.2 502379.62 ECONOMIC DEVELOPMENT 9D40 106996.00 18719.46 17.5 88276.54 ACTIVITY TOTAL 1753334.00 173041.09 9.9 1580292.91 :APITAL IMPROVEMENT.PROJECTS: 38508.75- .00 38508.75- GENERAL CIP PROJECTS 93NN 105980.00 2565.11 2.4 103414.89 COMMUNITY IMPROVEMENTS 94NN 389650.00 3515.02 .9 386134.98 PARKS 95NN 60815.00 1371.74 2.3 59443.26 STREET CONSTRC /IMPROVMT 96NN 201850.00 139487.30 69.1 62362.70 ACTIVITY TOTAL 758295.00 146939.17 19.4 611355.83 ' 0 T A L EXPENDITURES 16085817.00 1429043.87 8.9 14656773.13 XCESS EREVENUE> EXPENDITURES 83802.75- 301841.37- 360.2 218038.62 RANSFERS IN FROM OTHER FUNDS .00 .00 .00 -RANSFERS OUT TO OTHER FUNDS .00 .00 .00 =ESS EREVENUE> EXPENDITURE 83802.75- 301841.37- 360.2 218038.62 PAGE 2 8.54.58 1116194.19- 539517.90 48.3- 1655712.09- • PREVIOUS YEAR ENDING JUNE 30, 1996 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D 99908.83 23303.52 23.3 76605.31 128665.35 12887.38 10.0 115777.97 48241.56 4454.28 9.2 43787.28 29512.30 2748.91 9.3 26763.39 59974.79 7080.82 11.8 52893.97 33593.09 4444.43 13.2 29148.66 33694.49 2401.18 7.1 31293.31 100622.69 12493.25 12.4 88129.44 76940.68 10595.08 13.8 66345.60 196773.22 50810.41 25.8 145962.81 1845999.01 232194.00 12.6 1613805.01 838445.66 70971.77 8.5 767473.89 263771.36 22281.02 8.4 241490.34 569323.23 35197.68 6.2 534125.55 106703.40 12351.20 11.6 94352.20 1778243.65 140801.67 7.9 1637441.98 73453.55 68.20 .1 73385.35 124136.78 26881.58 21.7 97255.20 20046.02 .00 20046.02 104607.01 .00 1D4607.010 322243.36 26949.78 8.4 295293.5 14351509.62 1833636.80 12.8 12517872.82 1096358.72- 539517.90 49.2- 1635876.62- 38508.75- .00 38508.75- 18673.28 .00 18673.28 1116194.19- 539517.90 48.3- 1655712.09- • L104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/23/96 REVENUES VERSUS EXPENDITURE 9.00.55 FOR THE PERIOD 7/96 THROUGH 8/96 SPECIAL REVENUE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D ****** *REVENUES * * * * * ** ALES TAX 736000.00- 22462.91- 16.5 113537.09- 141116.52- 19436.33- 13.8 121680.19 - INES & FORFEITURES 24500.00- 2105.03- 8.6 22394.97- 24330.57- 1946.10- 8.0 22384.47 - SES OF MONEY AND PROPERTY 76830.00- .00 76830.00- 89945.79- .00 89945.79 - NTERNGOVERNMENTAL FROM STATE 523290.DD- 88655.79- 16.9 434634.21- 536724.31- 92105.00- 17.2 444619.31 - NTERGOVERNMENTAL FROM COUNTY 90000.00- 27739.00- 30.8 62261.00- 126726.00- 32382.00- 25.6 94344.00 - NTERGDVERNMENTAL FROM FEDERAL 369757.00- .00 369757.00- 1908174.78- 144587.60- 7.6 1763587.18 - HARGES FOR SERVICES 764600.00- .00 764600.00- 820879.80- .00 820879.80- THER SOURCES OF REVENUE 130350.00- 11394.00- 8.7 118956.00- 568753.12- 4324.59- .8 564428.53 - TOTAL REVENUE 2115327.00- 152356.73- 7.2 1962970.27- 4216650.89- 294781.62- 7.0 3921869.27- *** ***EXPENDITURES * * * * * ** ENERAL GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT .00 .00 .DO 244.70 .00 244.70 ACTIVITY TOTAL .00 .DD .DO 244.70 .00 244.70 UBL1C SAFETY: POLICE 5725.00 .00 5725.00 5899.29 .00 5899.29 TRAFFIC SIGNALS 109327.00 1703.08 1.6 107673 -92 85416 -D4 1395.58 1.6 84020.46 ACTIVITY TOTAL 115052.00 1703.08 1.5 113348.92 91315.33 1395.58 1.5 89919.75 RA TATION: 321.00 321.00 1.45 .OD 1.45 WORKS 5 MAINTENANCE 198960.00 .DO OD 198960.00 163324.71 8331.25 5.1 154993.46 STREET SWEEPING 75600.00 .DO 75600.00 69954.11 5742.96 8.2 64211.15 ACTIVITY TOTAL 274881.00 .00 274881.00 233280.27 14074.21 6.0 219206.06 EALTH & WELFARE: WASTE MANAGEMENT 742135.00 18786.48 2.5 723348.52 1183933.08 7933.20 .7 1175999.88 ULTURE & LEISURE SERVICES: OMMUNITY DEVELOPMENT: PLANNING 1275.00 .00 1275.00 .00 .00 .00 ENGINEERING 98102.00 3667.09 3.7 94434.91 51425.60 2864.11 5.6 48561.49 ACTIVITY TOTAL 99377.00 3667.09 3.7 95709.91 51425.60 2864.11 5.6 48561.49 APITAL IMPROVEMENT•PROJECTS: GENERAL CIP PROJECTS .00 .DO .00 7089.00 .DO 7089.00 COMMUNITY IMPROVEMENTS 168510.00 .00 168510.00 80111.16 7005.00 8.7 73106.16 PARKS 399795.00 .00 399795.00 211220.20 8D68.00 3.8 203132.20 STREET CONSTRUCTION /IMPROVMT 620540.00 188005.51 30.3 432534.49 1967504.82 116985.95 5.9 1850518.87 ACTIVITY TOTAL 1188845.00 188005.51 15.8 1000839.49 2265925.18 132078.95 5.8 2133846.23 0 T A L EXPENDITURES 2420290.00 212162.16 8.8 2208127.84 3826124.16 158346.05 4.1 3667778.11 KCESS [REVENUE>EXPENDITURE 304963.00 59805.43 19.6 245157.57 390526.73- 136435.57- 34.9 254091.16 - 2ANSFERS IN FROM OTHER FUNDS .00 .00 .00 19860.59- .00 19860.59 - 4ANSFERS OUT TO OTHER FUNDS .00 .00 .DO 28838.30 .00 28838.30 KCESS [REVENUES EXPENDITURE 304963.00 59805.43 19.6 245157.57 381549.02- 136435.57- 35.8 245113.45 - Iz ;L1D4C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/23/96 REVENUES VERSUS EXPENDITURE 9.25.13 FOR THE PERIOD 7/96 THROUGH 8/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 * ** * * ** +PECIAL BENEFITS ASSESSMENTS 234660.00- .00 734660.00- 318115.75- .00 318115.75 - ISES OF MONEY AND PROPERTY 20280.00- 1672.49- 8.2 18607.51- 17813.47- .00 17813.47 - ITHER 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 - r******EXPEND I TURES******* ;ENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 'UBLIC SAFETY: TRFC SIGS /STREET LIGHTING 130569.00 6039.62 4.6 124529.38 180611.18 794.73 .4 179816.45 ACTIVITY TOTAL 130569.00 6039.62 4.6 124529.38 180611.18 794.73 .4 179816.45 "RANSPDRTATION: PUBLIC WORKS 7688.00 384.57 5.0 7303.43 3947.86 858.53 21.7 3089.33 STREET TREE MAINTENANCE 8470.00 .00 8470.00 8867.39 148.21 1.7 8719.18 STREET LANDSCAPE MAINTENANCE 113800.00 7.34- 113807.34 105578.03 9972.96 9.4 95605.07 ACTIVITY TOTAL 129958.00 377.23 .3 129580.77 118393.28 10979.70 9.3 107413.58 MALTH & WELFARE: :ULTURE & LEISURE SERVICES: :OMMUNITY DEVELOPMENT: ENGINEERING 3560.00 306.24 8.6 3253.76 3085.26 221.76 7.2 2863.56 ACTIVITY TOTAL 3560.00 306.24 8.6 3253.76 3085.26 221.76 7.2 2863.5 :APITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 10000.00 .00 10000.00 27505.63 .00 27505.63 STREET CONSTRUCTION /IMPROVMT 103000.00 .00 103000.00 7649.54 .00 7649.54 ACTIVITY TOTAL 113000.00 .00 113000.00 35155.17 .00 35155.17 " 0 T A L EXPENDITURES 377087.00 6723.09 1.8 370363.91 337244.89 11996.19 3.6 325248.70 :XCESSIREVENUE> EXPENDITURE 118147.00 5050.60 4.3 113096.40 1315.67 11996.19 911.8 10680.52 - .XCESS IREVENUE> EXPENDITURE 118147.00 5050.60 4.3 113096.40 1315.67 11996.19 911.8 10680.52- !-; 1104C 9/23/96 0 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7196 THROUGH 8/96 CAPITAL IMPROVEMENT FUND PAGE 1 9.41.10 CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE I* I� FISCAL YR Y -T -D - * * * *** *REVENUES* * * * * ** 870421.00- 870421.00- 839611.07- 00 839611.07 - )THER SOURCES OF REVENUE 870421.00- .DO 870421.00- 839611.07- .00 839611.07- TOTAL REVENUE .00 - * * * ** *EXPENDITURES * * *** ** ;ENERAL GOVERNMENT ACTIVITIES: DD .00 ACTIVITY TOTAL .DO .00 .OD .DO 'UBLIC SAFETY: - RANSPORTATION: IEALTH & WELFARE: :ULTURE & LEISURE SERVICES: :OMMUNITY DEVELOPMENT: :APITAL IMPROVEMENT PROJECTS: 100000.00 .00 .OD .00 GENERAL CIP PROJECTS 100000.00 .00 8500.00 8021.77 .00 8021.77 COMMUNITY IMPROVEMENTS 8500.00 789421.00 .DO 39196.00 5.0 750225.00 707259.92 27770.72 3.9 679489.20 STREET CONSTRUCTION /IMPROVMT 897921.00 39196.00 4.4 858725.00 715281.69 27770.72 3.9 68751D.97 ACTIVITY TOTAL " 0 T A L EXPENDITURES 897921 -00 39196.00 4.4 858725.00 715281.69 27770.72 3.9 687510.97 - XCESSEREVENUE> EXPENDITURE 27300.00 39196.00 142.5 11696.00- 124329.38- 27770.72 22.3- 152130.14- - S OUT TO OTHER FUNDS .DO .DO .00 29531.04 .00 24531.04 :XCESS [ REVENUE> EXPENDITURE 27500.00 39196.00 142.5 11696.00- 94798.34- 27770.72 29.3- 122569.06- I* I� L104C THE CITY OF DUBLIN STATEMENT SHOWING 9/23/96 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 8/96 **** ***REVENUES * * * * * ** PECIAL BENEFITS ASSESSMENTS SES OF MONEY AND PROPERTY TOTAL REVENUE ***** *EXPENDITURES' * * * *** ENERAL GOVERNMENT ACTIVITIES NDN-DEPARTMENTAL ACTIVITY TOTAL UBLIC SAFETY: RANSPORTATION: EALTH & WELFARE: ULTURE & LEISURE SERVICES: OMMUNITY DEVELOPMENT: APITAL IMPROVEMENT.PROJECTS: OTAL EXPENDITURES XCESS(REVENUE)EXPENDITURE XCESS (REVENUE) EXPENDITURE PAGE 1 9.48.34 TRUST /AGENCY FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D .00 .00 .00 234629.50- .00 234629.50- .00 538.94- 538.94 11997.60- 21.88- .2 11975.72- .00 538.94- 538.94 246627.10- 21.88- 2466D5.22- .00 153314.75 .00 153314.75 .00 153314.75 .00 152775.81 .00 152775.81 153314.75 - 232584.50 151269.75 65.0 81314.75 153314.75 - 232584.50 151269.75 65.0 81314.75 153314.75 - 232584.50 151269.75 65.0 81314.75 152775.81- 14042.60- 151247.87 1077.1- 165290.47- 152775.81- 14042.60- 151247.87 1077.1- 165290.47 - L .1040 1/23/96 0 -**** *REVENUES *** * * ** THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 8/96 PAGE 1 9.19.31 INTERNAL SERVICE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE ;ES OF MONEY AND PROPERTY 16300.00 - iARGES FOR SERVICES 216315.00 - 'HER SOURCES OF REVENUE 12100.00 - TOTAL REVENUE 244715.00 - t **** *EXPENDITURES * ****** 216315.00- _NEPAL GOVERNMENT ACTIVITIES: .00 NON- DEPARTMENTAL 288082.00 ACTIVITY TOTAL 288082.00 JBLIC SAFETY: 29894.08- 1ANSPORTATION: 41.4 :ALTH & WELFARE: 1072.70- 1LTURE & LEISURE SERVICES: 243642.30- IMMUNITY DEVELOPMENT: 12365.92- tPITAL IMPROVEMENT PROJECTS: 217668.40- 0 T A L EXPENDITURES 288082.00 (CESSEREVENUE> EXPENDITURE 43367.00 (CESS EREVENUE> EXPENDITURE 43367.00 0 K-1 FISCAL YR Y -T -D .00 3.3 16300.00- 15884.33- .00 141.1 15884.33- .00 19.8 216315.00- 184255.91- .00 39.6- 184255.91- 1072.70- 8.9 11027.30- 29894.08- 12365.92- 41.4 17528.16- 1072.70- .4 243642.30- 230034.32- 12365.92- 5.4 217668.40- 9646.25 3.3 278435.75 57229.08 80746.71 141.1 23517.63- 9646.25 3.3 278435.75 57229.08 80746.71 141.1 23517.63- 9646.25 3.3 278435.75 57229.08 80746.71 141.1 23517.63- 8573.55 19.8 34793.45 172805.24 - 68380.79 39.6- 241186.03- 8573.55 19.8 34793.45 172805.24- 68380.79 39.6- 241186.03- 31.104C THE CITY OF DUBLIN STATEMENT SHOWING 9/23/96 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 8/96 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE PAGE 1 9.29.59 0 PREVIOUS YEAR ENDING JUNE 30, 1996 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T -D USES OF MONEY AND PROPERTY 1709285.00- 381827.48- 22.3 1327457.52- 1594060.99- 395804.13- 24.8 1198256.86 - TOTAL REVENUE 1709285.00- 381827.48- 22.3 1327457.52- 1594060.99- 395804.13- 24.8 1198256.86- ** * * ***EXPENDITURES ***" ** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1602005.00 ADMIN SERVICES 4365.00 ACTIVITY TOTAL 1606370.00 PUBLIC SAFETY: DISASTER PREAPREDNESS .00 ACTIVITY TOTAL .00 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION .00 SENIOR CENTER .00 ACTIVITY TOTAL .OD COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PRDJECTS: T O T A L EXPENDITURES EXCESS [REVENUE>EXPENDITURES TRANSFERS IN FROM OTHER FUNDS EXCESS [REVENUES EXPENDITURE 71609.88 4.5 1530395.12 1388507.17 1000.00 22.9 3365.00 6948.40 72609.88 4.5 1533760.12 1395455.57 .00 .00 1226.33 .00 .DO 1226.33 .00 .00 10125.56 .00 .00 200.00 .00 .00 10325.56 73901.13 5.3 1314606.04 1125.00 16.2 5823.40 75026.13 5.4 1320429.44 .00 1226.33 .00 1226.33 1202.60 11.9 8922.96 .00 200.00 1202.60 11.6 9122.96 1606370.00 72609.88 4.5 1533760.12 1407007.46 76381.64 5.4 1330625 102915.00- 309217.60- 300.5 206302.60 187053.53- 319422.49- 170.8 132368. .00 .00 .00 18673.28- .00 18673.2 102915.00- 309217.60- 300.5 206302.60 205726.81- 319422.49- 155.3 113695.68 I-] 17