Loading...
HomeMy WebLinkAboutItem 4.03 FinRptSept&Octt CITY OF DUBLIN AGENDA STATEMENT CITY COUNCIL MEETING DATE: November 28, 1994 SUBJECT: Monthly Financial Reports: September and October 1994. Prepared by: Paul S. Rankin, Assistant City Manager) EXHIEBITS ATTACHED: 1. /Balance Sheet and Income Statements for the Period Ending September 30, 1994 2. /Balance Sheet and Income Statements for the Period Ending October 31, 1994 RECOMMENDATION: Accept and file the reports. FINANCIAL: See reports for monthly financial activity. DESCRIPTION: This item provides reports of the monthly financial statements for both the month of September and October 1994. The final entries to close out the previous fiscal year have been made and any residual funds have been carried forward in the Fund Balance figures shown. The balances reported reflect all posted activities in the prior Fiscal Year. It is anticipated that in the next month _a Final Audit Report along with the Final June 30, 1994 Financial Statements will be presented to the City Council. CHANGE IN REPORT FORMAT The format of this report has been changed slightly to be consistent with the annual audit reports. The Auditors classify as Agency /Trust Funds, the monies associated with the Dublin Boulevard Assessment District. In reality these are not assets of the City of Dublin. The City merely acts as the Agent to collect the monies and make payments on behalf of the bondholders. In previous reports these monies were classified with the Maintenance Assessment Funds. In the revised format they are shown in a separate Agency /Trust column on page one of the Balance Sheet. ANALYSIS OF REVENUE AND EXPENDITURE REPORT Consistent with previous reports, the analysis which follows will focus on General Fund Revenues and Expenditures,, which represent the most significant elements of the City's operations. In addition the discussion will focus on the October 1994 Statements (Exhibit 2), as these reflect the most current information. GENERAL FUND REVENUES Overall, the General Fund Revenues are performing comparable to the experience in the previous Fiscal Year. The City has collected approximately 23.5% of its 1994/95 budget as compared to 22.0% collected through October of 1993. Certain categories of Revenues have increased while others have decreased. Overall, the total revenues collected are relatively consistent with the prior year. The following revenue data may be of particular interest at this time: Sales Tax advances have increased based upon the improving economic climate. Total General Fund Sales Tax is up $131,581 over the same period in the prior year. Charges For Services Revenue is up from the prior year. This is teffleative of increased activity in processing planning applications. ITxit%L'wzt eam2ings appear at this time to be less than in the previous yer.. This is caused by the fact that a significant portion of the pow 'im was. moved in the last year, from LAIF to individual Federal Agency 't ,. : LAIF makes interest payments four times `a year. COPIES TO. ITEM NO. CITY CLERK FILE 1:51-3101-M The more recent investments make interest payments :twice each year. Therefore, the apparent lag in interest revenue should reverse once more of the fiscal year has lapsed and the semi- annual interest revenue is received. GENERAL MW TXPIWDITURES Overall, through the month of October General 'Fund operating expenditures were 23 -9% of the General Fund Budget and totalled $3,088,846.- In comparison through October 1993, the City expended only $2,159,753 in General Fund operating expenses, which represented approximately- 17.7% of the total .General Fund operating expenditures for the year. The difference can be mostly attributed to expenditures in two categories.` (1) The 1993 Civic Center Certificate of Participation (COP) financing provided for the deposit in July 1994 of a semi annual interest payment. The first COP payment of Fiscal Year 1993 /94 was not due until January 1994. (2) In Fiscal Year 1993/94 there was a delay in receipt of contribution billings from the Dougherty Regional Fire Authority. The current expenditures through October continue to be affected by billing lags related to contract service expenditures. For example, the City has not recorded any expense for Police Services, Animal Control, or the Supplemental Library Service. Modest budgetary savings have occurred in Community Development activities due to a lag in filling personnel vacancies. It is recommended that the City Council receive and file these reports as authorized by section 41004 of the California Government Code. CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF SEPTEMBER 1994 Prepared by The Finance Department (November 17, 1994) 19Rf �YP�� BGL102 i CITY OF DUBLIN S PAGE 1 11/17/94 BALANCE SHEET 14.21.54 FOR THE PERIOD 7/94 THROUGH 9/94 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T O T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY - -- MEMORANDUM ONLY - -- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1994 ASSETS CASH 900276.46- 419059.71 311450.22 172673.51 - 19569.50 322870.54- 202225.24- CASE WITH FISCAL AGENT 121210.04 121210.04 121210.04 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 18708041.49 18708041.49 18107360.59 RECEIVABLES:TAXES ACCOUNTS (NET) 234161.06 117993.21 110795.71 462949.98 324262.45 INTEREST 46775.00 46775.00 8601.00 ASSESSMENTS RENTS NOTES DUE FROM OTHERS 32951.01 29859.02 62810.03 280523.06 INVENTORY AT COST PREPAID ITEMS 12636.49 12636.49 2680.97 FIXED ASSETS ACOUNTS TO BE PROVIDED 2232500.00 2232500.00 2232500.00 TOTAL ASSETS 18134288.59 566911.94 311450.22 61877.80 - 2373279.54 21324052.49 20874912.87 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 14472.84 14472.84 49448.44 - DEPOSITS FOR AB1600 FEES 233260.00- 233260.00- 108508.46 - DEPOSITS OTHERS 160982.18- 3125.00- 164107.18- 169392.66 - PAYABLES:A000UNTS 950.63- 14006.28- 14956.91- 261682.38 - INTEREST PAYROLL 47068.84- 47068.84- 22458.72 - DUE TO OTHERS 390.00- 390.00- 391733.64 - DEBT INSTRUMENTS PAYABLE 2350000.00- 2350000.00- 2790000.00 - TOTAL LIABILTIES 194918.81- 14006.28- 3125.00- 233260.00- 2350000.00- 2795310.09- 3793224.30 - FUND BALANCES 17939369.78- 552905.66- 308325.22- 295137.80 23279.54- 18528742.40- 17081688.57 - TOTAL FUND EQUITY 17939369.78- 552905.66- 308325.22- 295137.80 23279.54- 18528742.40- 17081688.57 - TOTAL LIAB,FND BAL, RETD EARNS 18134288.59- 566911.94- 311450.22- 61877.80 2373279.54- 21324052.49- 20874912.87- BGL102 CITY OF DUBLIN PAGE 1 11/17/94 BALANCE SHEET 14.22.15 FOR THE PERIOD 7/94 THROUGH 9/94 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, 1994 ASSETS CASH 355048.87 3202.74- 351846.13 279321.48 CASH WITH FISCAL AGENT 1730761.91 1730761.91 1726901.55 UNAHORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST 46871.38 ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 153663.97 21110330.12 479805.26 21743799.35 22259445.26 AMOUNTS TO BE PROVIDED 2713930.44 2713930.44 2548360.41 TOTAL ASSETS 508712.84 22837889.29 479805.26 2713930.44 26540337.83 26860900.08 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:A000UIITS 25603.30 - INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 17615000.00- 2713930.44- 20328930.44- 21151212.29 - TOTAL LIABILITIES 17615000.00- 2713930.44- 20328930.44- 21176815.59 - FUND BALANCE 331374.28- 112999.29- 444373.57- 64077.87 CONTRIBUTIONS 177338.56- 5109890.00- 5287228.56- 5278147.74 - INVESTMENTS III FIXED ASSETS 479805.26- 479805.26- 470014.62 - RETAINED EARNINGS TOTAL FUND EQUITY 508712.84- 5222889.29- 479805.26- 6211407.39- 5684084.49 - TOTAL LIAB,FND BAL, RETD EARNS 508712.84- 22837889.29- 479805.26 - 2713930.44- 26540337.83- 26860900.08- BGL104C CITY OF DUBLIN STATEMENT SHOWING i PAGE 1 11/17/94 REVENUES VERSUS EXPENDITURE 13.57.35 FOR THE PERIOD 7/94 THROUGH 9/94 GENERAL REVENUE FUND * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: 11011- DEPARTMEIPTAL CURRENT PERIOD 15601.00 PREVIOUS YEAR ENDING JUNE 30, 1994 .00 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE 17.0 99557.26 102612.23 17951.68 17.5 FISCAL YR Y -T -D 1020 260109.00 * * * * * ** *REVENUES * * * * * ** 23.4 199133.40 240219.95 55456.23 23.1 184763.72 CITY ATTORNEY 1030 PROPERTY TAXES 3849500.00- 287292.70- 7.5 3562207.30- 3853101.60- 345594.44- 9.0 3507507.16 - SALES TAX 5892000.00- 1331154.13- 22.6 4560845.87- 5969342,43- 1222473.37- 20.5 4746869.06- REAL PROPERTY TRANSFERS 68500.00- 10050.98- 14.7 58449.02- 65258.80- 19606.02- 30.0 45652.78 - TRANSIENT OCCUPANCY TAX 90000.00- 23471.00 - 26.1 66529.00- 88318.00- 22546.00- 25.5 65772.00 - FRANCHISE TAXES 479800.00- 28454.50- 5.9 451345.50- 481162.79- 19178.02- 4.0 461984.77 - LICENSES & PERMITS 361350.00- 72588.83- 20.1 288761.17- 340994.82- 109786.90- 32.2 231207.92 - FINES & FORFEITURES 37500.00- 7224.58- 19.3 30275.42- 34316.48- 8226.01- 24.0 26090.47 - USES OF 140HEY AND PROPERTY 986100.00- 53580.95- 5.4 932519.05- 935615.38- 27004.17- 2.9 908611.21 - INTERGOVERNMENTAL FROM STATE 970325.00- 275502.03- 28.4 694822.97- 945713.40- 229451.13- 24.3 716262.27 - CHARGES FOR SERVICES 758180.00- 194352.59- 25.6 563827.41- 580737.55- 158118.23- 27.2 422619.32 - OTHER SOURCES OF REVENUE 120200.00- 94080.23- 78.3 26119.77- 275567.69- 51402.58- 18.7 224165.11 - TOTAL REVENUE 13613455.00- 2377752.52- 17.5 11235702.48- 13570128.94- 2213386.87- 16.3 11356742.07- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: 11011- DEPARTMEIPTAL 15601.00 .00 15601.00 815.04 .00 815.04 CITY COUNCIL 1010 120014.00 20456.74 17.0 99557.26 102612.23 17951.68 17.5 84660.55 CITY MANAGER 1020 260109.00 60975.60 23.4 199133.40 240219.95 55456.23 23.1 184763.72 CITY ATTORNEY 1030 127170.00 31030.13 24.4 96139.87 235554.62 21204.02 9.0 214350.60 ADMIN SERVICES 1040 451641.00 92423.35 20.5 359217.65 410536.74 82589.75 20.1 327946.99 BUILDING MANAGEMENT 1050 326490.00 53459.03 16.4 273030.97 313411.43 51715.43 16.5 261696.00 FACILITY RENTAL 1050 -719 1553744.00 401726.34 25.9 1152017.66 1458593.27 .00 1458593.27 INSURANCE COST CENTER 1060 134000.00 107565.31 80.3 26434.69 149792.07 127449.14 85.1 22342.93 ELECTIONS COST CENTER 1070 12475.00 37.46 .3 12437.54 10817.83 27.87 .3 10789.96 ACTIVITY TOTAL 3001244.00 767673.96 25.6 2233570.04 2922353.18 356394.12 12.2 2565959.06 PUBLIC SAFETY: POLICE 2010 3268352.00 44227.99 1.4 3224124.01 2970615.78 44163.21 1.5 2926452.57 CROSSING GUARDS COST 2020 38495.00 83.30 .2 38411.70 .00 .00 .00 ANIMAL CONTROL 2030 103750.00 .00 103750.00 92215.39 .00 92215.39 TRAFFIC SIGNALS 2040 .00 .00 .00 .00 5969.69 5969.69 - DISASTER PREAPREDNESS 2050 31817.00 .00 31817.00 25728.27 6094.46 23.7 19633.81 FIRE SERVICES JPA 2060 2756398.00 882048.00 32.0 1874350.00 2632168.71 653808.48 24.8 1978360.23 ACTIVITY TOTAL 6198812.00 926359.29 14.9 5272452.71 5720728.15 710035.84 12.4 5010692.31 TRANSPORTATION: PUBLIC WORKS 3010 294390.00 65839.23 22.4 228550.77 282508.50 56986.93 20.2 225521.57 STREET MAINTENANCE 3020 66459.00 9506.26 14.3 56952.74 877.22 355.01 40.5 522.21 STREET TREE MAINTENANCE 3040 50040.00 2821.83 5.6 47218.17 45767.70 9316.81 20.4 36450.89 STREET LANDSCAPE MAINT. 3050 165860.00 31319.82 18.9 134540.18 158297.22 27785.16 17.6 130512.06 ACTIVITY TOTAL 576749.00 109487.14 19.0 467261.86 487450.64 94443.91 19.4 393006.73 HEALTH & WELFARE: WASTE MANAGEMENT 5020 27100.00 .00 27100.00 75.84 .00 75.84 ACTIVITY TOTAL 27100.00 .00 27100.00 75.84 .00 75.84 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 177536.00 .00 177536.00 165000.00 .00 165000.00 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 8000.00 8000.00 100.0 .00 HERITAGE CENTER 8012 26563.00 61.82 .2 26501.18 2234.23 .00 2234.23 DUBLIN CEMETERY 8013 16680.00 2320.59 13.9 14359.41 8068.33 .00 8068.33 GL104C CITY OF DUBLIN STATEMENT SHOWING 11/17/94 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/94 THROUGH 9/94 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE PARK MAINTENANCE 8020 COMMUNITY CABLE TV 8030 RECREATION ADMIN. 8040 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 COMMUNITY DEVELOPMENT: PLANNING 9010 BUILDING SAFETY 9020 ENGINEERING 9030 ECONOMIC DEVELOPMENT 9040 ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 93NN COMMUNITY IMPROVEMENTS 9411H PARKS 95NN STREET CONSTRC /IMPROVMT 96NN ACTIVITY TOTAL T O T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURES TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS < REVENUE> EXPENDITURE 579619.00 22393.00 177379.00 93149.00 113540.00 38615.00 29446.00 92961.00 34886.00 31328.00 109422.00 81736.00 197008.00 1832261.00 611170.00 266000.00 204072.00 75132.00 1156374.00 57015.00 50000.00 .00 .00 107015.00 12899555.00 .713900.00- .00 .00 713900.00- 91833.49 .00 43019.42 30090.19 23652.78 8744.29 4126.91 17085.72 8622.10 4340.37 24433.09 19351.10 73783.72 361465.59 110772.40 50250.03 37846.05 10.88 198879.36 204.50 3564.39 2815.44 .00 6584.33 2370449.67 7302.85- .00 .00 7302.85- 0 15.8 487785.51 22393.00 24.3 134359.58 32.3 63058.81 20.8 89887.22 22.6 29870.71 14.0 25319.09 18.4 75875.28 24.7 26263.90 13.9 26987.63 22.3 84988.91 23.7 62384.90 37.5 123224.28 19.7 1470795.41 18.1 500397.60 18.9 215749.97 18.5 166225.95 75121.12 17.2 957494.64 .4 56810.50 7.1 46435.61 2815.44 - .00 6.2 100430.67 18.4 10529105.33 1.0 706597.15 - .00 .00 1.0 706597.15- PAGE 2 13.57.35 1436498.19- 474388.50- 33.0 962109.69- PREVIOUS YEAR ENDING JUNE 30, 1994 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T -D 562328.40 105174.06 18.7 457154.34 20279.00 .00 20279.00 175746.19 38596.55 22.0 137149.64 72270.89 22659.96 31.4 49610.93 116563.54 22876.06 19.6 93687.48 34319.22 6053.11 17.6 28266.11 27928.80 4054.57 14.5 23874.23 76349.88 22656.45 29.7 53693.43 28570.77 5092.81 17.8 23477.96 28749.94 3731.61 13.0 25018.33 98858.25 17889.20 18.1 . 80969.05 78626.11 16829.11 21.4 61797.00 205324.75 74276.15 36.2 131048.60 1709218.30 347889.64 20.4 1361328.66 511179.82 98533.81 19.3 412646.01 252992.23 46582.99 18.4 206409.24 215790.71 48294.07 22.4 167496.64 6328.57 93.00 1.5 6235.57 986291.33 193503.87 19.6 792787.46 .00 .00 .00 48603.17 1143.70- 2.4- 49746.87 12423.92 .00 12423.92 281695.66 8449.83 3.0 273245.83 342722.75 7306.13 2.1 335416.62 12168840.19 1709573.51 14.0 10459266.68 1401288.75- 503813.36- 36.0 897475.39 - 77093.25- .00 77093.25 - 41883.81 29424.86 70.3 12458.95 1436498.19- 474388.50- 33.0 962109.69- BGL104C CITY OF DUBLIN STATEMENT SNOWING PAGE 1 11/17/94 REVENUES VERSUS EXPENDITURE 14.01.27 FOR THE PERIOD 7/94 THROUGH 9/94 SPECIAL REVENUE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * * * * ** *REVENUES * * * * * ** SALES TAX 116000.00- 31516.35- 27.2 84483.65- 117622.52- 27899.16- 23.7. 89723.36 - FINES & FORFEITURES 31900.00- 3964.63- 12.4 27935.37- 33963.62- 5215.42- 15.4 28748.20 - SPECIAL BENEFITS ASSESSMENTS .00 895.38- 895.38 .00 .00 9.2 .00 USES OF MONEY AND PROPERTY 35800.00- .00 8.1 35800.00- 35095.85 - .00 2.5 35095.85 - INTERHGOVERNMENTAL FROM STATE 611854.00- 130474.19- 21.3 481379.81- 609800.83- 91880.07- 15.1 517920.76 - INTERGOVERNMENTAL FROM COUNTY 150000.00- 37978.00- 25.3 112022.00- 125984.50- .00 125984.50 - INTERGOVERNMENTAL FROM FEDERAL 2329428.00- .00 2329428.00- 116540.21- .00 116540.21 - CHARGES FOR SERVICES 697356.00- 239.11- 42.3 697116.89- 742458.70- 2015.91- .3 740442.79 - OTHER SOURCES OF REVENUE 16000.00- 3251.42- 20.3 12748.58- 11993.19- 6587.32- 54.9 5405.87 - TOTAL REVENUE 3988338.00- 208319.08- 5.2 3780018.92- 1793459.42- 133597.88- 7.4 1659861.54- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: POLICE 12350.00 .00 12350.00 12067.48 1111.42 9.2 10956.06 TRAFFIC SIGNALS 90790.00 7387.69 8.1 83402.31 82277.35 2038.87 2.5 80238.48 ACTIVITY TOTAL 103140.00 7387.69 7.2 95752.31 94344.83 3150.29 3.3 91194.54 TRANSPORTATION: PUBLIC WORKS 526.00 .00 526.00 .00 .00 .00 STREET MAINTENANCE 215050.00 90960.01 42.3 124089.99 158820.98 6845.85 4.3 151975.13 STREET SWEEPING 73360.00 5312.53 7.2 68047.47 69985.83 10244.26 14.6 59741.57 ACTIVITY TOTAL 288936.00 96272.54 33.3 192663.46 228806.81 17090.11 7.5 211716.70 HEALTH & WELFARE: WASTE MANAGEMENT 640137.00 8475.48 1.3 631661.52 542622.00 2200.00 .4 540422.00 CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 113450.00 12415.50 10.9 101034.50 117649.45 8368.42 7.1 109281.03 ACTIVITY TOTAL 113450.00 12415.50 10.9 101034.50 117649.45 8368.42 7.1 109281.03 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 17269.00 .00 17269.00 .00 .00 .00 COMMUNITY IMPROVEMENTS 177525.00 4967.69 2.8 172557.31 58968.45 569.67 1.0 58398.78 PARKS 29895.00 .00 29895.00 133793.53 9914.52 7.4 123879.01 STREET CONSTRUCTION /IMPROVMT 2473466.00 78146.15 3.2 2395319.85 364376.28 13548.55 3.7 350827.73 ACTIVITY TOTAL 2698155.00 83113.84 3.1 2615041.16 557138.26 24032.74 4.3 533105.52 T 0 T A L EXPENDITURES 3843818.00 207665.05 5.4 3636152.95 1540561.35 54841.56 3.6 1485719.79 EXCESS <REVENUE>EXPENDITURE 144520.00- 654.03- .5 143865.97- 252898.07- 78756.32- 31.1 174141.75 - TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 32728.18- 29424.86- 89.9 3303.32 - TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 9451.83 .00 9451.83 EXCESS < REVENUE> EXPENDITURE 144520.00- 654.03- .5 143865.97- 276174.42- 108181.18- 39.2 167993.24 - 'BGL104C . CITY OF DUBLIN STATEMENT SHOWING • PAGE 1 11/17/94 REVENUES VERSUS EXPENDITURE 14.05.18 FOR THE PERIOD 7/94 THROUGH 9/94 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * * * * ** *REVENUES * * * * * ** SPECIAL BENEFITS ASSESSMENTS 288265.00- 303.35- .1 287961.65- 533098.91 - 3198.61- .6 529900.30 - USES OF MONEY AND PROPERTY 15000.00- .00 15000.00- 22974.46- .00 22974.46 - OTHER SOURCES OF REVENUE 5725.00- .00 5725.00- 14269.21- 4727.89- 33.1 9541.32 - TOTAL REVENUE 308990.00- 303.35- .1 308686.65- 570342.58- 7926.50- 1.4 562416.08- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: 11011- DEPARTMENTAL .00 .00 .00 210730.75 565406.00 268.3 354675.25 - ACTIVITY TOTAL .00 .00 .00 210730.75 565406.00 268.3 354675.25 - PUBLIC SAFETY: TRFC SIGS /STREET LIGHTING 199025.00 31111.36 15.6 167913.64 190210.84 16125.70 8.5 174085.14 ACTIVITY TOTAL 199025.00 .31111.36 15.6 167913.64 190210.84 16125.70 8.5 174085.14 TRANSPORTATION: PUBLIC WORKS 5632.00 811.50 14.4 4820.50 2736.26 1444.56 52.8 1291.70 STREET TREE MAINTENANCE 9890.00 181.13 1.8 9708.87 6807.10 673.55 9.9 6133.55 STREET LANDSCAPE MAINTENANCE 109940.00 19858.46 18.1 90081 54 105133.50 17255.90 16.4 87877.60 ACTIVITY TOTAL 125462.00 20851.09 16.6 104610.91 114676.86 19374.01 16.9 95302.85 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 4120.00 3203.40 77.8 916.60 3828.40 3458.52 90.3 369.88 ACTIVITY TOTAL 4120.00 3203.40 77.8 916.60 3828.40 3458.52 90.3 369.88 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS .00 .00 .00 4500.00 4500.00 100.0 .00 STREET CONSTRUCTION /IMPROVMT 400000.00 .00 400000.00 .00 .00 .00 ACTIVITY TOTAL 400000.00 .00 400000.00 4500.00 4500.00 100.0 .00 T 0 T A L EXPENDITURES 728607.00 55165.85 7.6 673441.15 523946.85 608864.23 116.2 84917.38 - EXCESS <REVENUE>EXPENDITURE 419617.00 54862.50 13.1 364754.50 46395.73- 600937.73 1295.2- 647333.46 - TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 123895.44- .00 123895.44 - TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 110995.44 .00 110995.44 EXCESS < REVENUE> EXPENDITURE 419617.00 54862.50 13.1 364754.50 59295.73- 600937.73 1013.5- 660233.46- 11 IBGL104C 11/17/94 CITY OF DUBLIN STATEMENT SHOWING � PAGE 1 REVENUES VERSUS EXPENDITURE 14.17.29 FOR THE PERIOD 7/94 THROUGH 9/94 CAPITAL IMPROVEMENT FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * * * * ** *REVENUES * * * * * ** USES OF MONEY AND PROPERTY .00 .00 .00 2058.46- .00 2058.46 - OTHER SOURCES OF REVENUE 711509.00- .00 711509.00- 73214.23- .00 73214.23 - TOTAL REVENUE 711509.00- .00 711509.00- 75272.69- .00 75272.69- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 31521.66 .00 .00 PUBLIC SAFETY: 14.7 182499.67 31521.66 22.7 107226.98 TRANSPORTATION: 83393.92 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: STREET CONSTRUCTION /IMPROVMT 431509.00 18691.02 4.3 412817.98 214021.33 ACTIVITY TOTAL 431509.00 18691.02 4.3 412817.98 214021.33 T O T A L EXPENDITURES 431509.00 18691.02 4.3 412817.98 214021.33 EXCESS<REVENUE> EXPENDITURE 280000.00- 18691.02 6.7- 298691.02- 138748.64 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 83393.92 EXCESS < REVENUE> EXPENDITURE 280000.00- 18691.02 6.7- 298691.02- 222142.56 0 .00 .00 31521.66 14.7 182499.67 31521.66 14.7 182499.67 31521.66 14.7 182499.67 31521.66 22.7 107226.98 .00 83393.92 31521.66 14.2 190620.90 tGL104C 11/17/94 •CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/94 THROUGH 9/94 INTERNAL SERVICE FUND iPAGE 1 14.09.15 CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * * * * ** *REVENUES * * * * * ** USES OF MONEY AND PROPERTY 11600.00- .00 11600.00- 15381.72- .00 15381.72 - CHARGES FOR SERVICES 124608.00- 31255.16- 25.1 93352.84- 128214.28- 31541.60 - 24.6 96672.68 - OTHER SOURCES OF REVENUE .00 .00 .00 7615.50- .00 7615.50 - TOTAL REVENUE 136208.00- 31255.16- 22.9 104952.84- 151211.50- 31541.60- 20.9 119669.90- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: 11011- DEPART14ENTAL 230233.00 12861.60 5.6 217371.40 127280.78 48952.49 38.5 78328.29 ACTIVITY TOTAL 230233.00 12861.60 5.6 217371.40 127280.78 48952.49 38.5 78328.29 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: C01414U11ITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 230233.00 12861.60 5.6 217371.40 127280.78 48952.49 38.5. 78328.29 EXCESS<REVENUE>EXPENDITURE 94025.00 18393.56- 19.6- 112418.56 23930.72- 17410.89 72.8 - 41341.61 - EXCESS < REVENUE> EXPENDITURE 94025.00 18393.56- 19.6- 112418.56 23930.72- 17410.89 72.8- 41341.61- BGL104C OITY OF DUBLIN STATEMENT SHOWING • PAGE 1 11/17/94 REVENUES VERSUS EXPENDITURE 14.13.18 FOR THE PERIOD 7/94 THROUGH 9/94 ENTERPRISE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JULIE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T -D * * * * * ** *REVENUES * * * * * ** 1436774.32 410.00 25.1 1225.85 410.00 1438000.17 USES OF MONEY AND PROPERTY 1658112.00- 405931.29- 24.5 1252180.71- 1564715.31 - TOTAL REVENUE 1658112.00- 405931.29- 24.5 1252180.71- 1564715.31- * * * * ** *EXPENDITURES * * * * * ** 2.1- 129827.28- GENERAL GOVER104ENT ACTIVITIES: 11011- DEPARTMEIITAL 1553784.00 75728.63 4.9 1478055.37 1436774.32 ADMIN SERVICES 13870.00 2245.00 16.2 11625.00 1635.85 ACTIVITY TOTAL 1567654.00 77973.63 5.0 1489680.37 1438410.17 PUBLIC SAFETY: DISASTER PREAPREDNESS 1150.00 .00 1150.00 .00 ACTIVITY TOTAL 1150.00 .00 1150.00 .00 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 10180.00 967.67 9.5 9212.33 10864.05 SENIOR CENTER 463.00 250.00 54.0 213.00 338.14 ACTIVITY TOTAL 10643.00 1217.67 11.4 9425.33 11202.19 C014MUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1579447.00 79191.30 5.0 1500255.70 1449612.36 EXCESS<REVEHUE> EXPENDITURES 78665.00- 326739.99- 415.4 248074.99 115102.95 - TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 12008.13 - EXCESS < REVENUE> EXPENDITURE 78665.00- 326739.99- 415.4 248074.99 127111.08- 866.61- .1 1563848.70- 866.61- .1 1563848.70- .00 1436774.32 410.00 25.1 1225.85 410.00 1438000.17 .00 .00 .00 .00 2934.67 27.0 7929.38 238.14 70.4 100.00 3172.81 28.3 8029.38 3582.81 .2 1446029.55 2716.20 2.4- 117819.15- .00 12008.13- 2716.20 2.1- 129827.28- GL370 TRIAL BALANCE FOR FUND 515 DUBLIN BLVD EXT TRUST /AG 11/17/94 ACCOUNT BALANCES THRU 9/30/94 FUND 515 ASSET SU94ARY DEPT- OBJ-SUB DESCRIPTION 1000 - 101 -002 OPERATING ACCOUNT 1000-102 -000 CASH WITH FISCAL AGENT 1000 - 222 -000 AMOUNTS TO BE PROVIDED 1000 - - - -- --DEPARTMENT TOTAL ---- - - - --- -TOTAL ASSETS FUND 515 LIABILITY SUMMARY DEPT-OBJ-SUB DESCRIPTION 1000 - 384 -002 BONDS PAYABLE LONG TERM SP ASSNNTS 1000- - - - - -- DEPARTMENT TOTAL ---- - - - - -- -TOTAL LIABILITIES FUND 515 EQUITY SUMMARY DEPT -OBJ -SUB DESCRIPTION 1000 - 402 -000 FUND BAL DESIGNATED: DEBT SERVICE 1000 - - - - -- -DEPARTMENT TOTAL ---- - - - - -- -TOTAL EQUITY FUND 515 REVENUE SUMMARY DEPT -OBJ -SUB DESCRIPTION 1000-534 -012 SPECIAL ASSESSMENTS- PENALTIES 1000- -- - --- DEPARTMENT TOTAL ---- - - ---- -TOTAL REVENUE FUND 515 APPROPRIATION SUMMARY DEPT -OBJ -SUB DESCRIPTION 1000 - 732-000 INTEREST PAYMENTS 1000 - 733 -000 PRINCIPAL PAYMENTS 1000 -734 -000 BOND PREMIUM 1000- - -- -- -DEPARTMENT TOTAL ---- - - - - -- -TOTAL APPROPRIATIONS ---- --- - -FUND 515 TOTAL PAGE 1 14.30.09 .0 % REMAINING DEBIT /CREDIT BUDGET BUDGET $COMP 19569.50 * * 19569.50 -* .0 % 121210.04 * * 121210.04 -* .0 % 2232500.00 * * 2232500.00 -* .0 $ 2373279.54 ** ** 2373279.54 - ** .0 $ 2373279.54 * ** 2373279.54 - * ** .0 $ REMAINING DEBIT /CREDIT BUDGET BUDGET $COMP 2350000.00 -* * 2350000.00 * .0 % 2350000.00- ** ** 2350000.00 ** .0 $ 2350000.00- * ** 2350000.00 * ** .0 $ REMAINING DEBIT /CREDIT BUDGET BUDGET %COMP 176623.01 -* * 176623.01 * .0 % 176623.01 - ** ** 176623.01 ** .0 % 176623.01- * ** 176623.01 * ** .0 % REMAINING RECEIVED ESTIMATE ESTIMATE %COMP 6251.28-* 6251.28 * .0 % 6251.28 - * ** 6251.28 ** .0 % 6251.28- * ** 6251.28 * ** .0 % REMAINING EXPENDITURES BUDGET BUDGET $COMP 85324.75 * * 85324.75 -* .0 % 74000.00 * * 74000.00 -* .0 % 270.00 * * 270.00 -* .0 % 159594.75 ** ** 159594.75 - ** .0 % 159594.75 * ** 159594.75 - * ** .0 % .0 % CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF OCTOBER 1994 Prepared by The Finance Department (November 17, 1994) 1 �• yi � V � `� Q.-4 BGL102 CITY OF DUBLIN PAGE 1 11/17/94 BALANCE SHEET 15.28.26 FOR THE PERIOD 7/94 THROUGH 10/94 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY - -- MEMORANDUM ONLY - -- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1994 ASSETS CASH 532968.62- 350475.68 286052.95 177634.70- 19569.50 54505.19- 95745.02 CASH WITH FISCAL AGENT 121210.04 121210.04 121210.04 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 18376322.74 18376322.74 17899729.88 RECEIVABLES: TAXES ACCOUNTS (NET) 220361.06 117993.21 110795.71 449149.98 324262.45 INTEREST 28462.50 28462.50 8601.00 ASSESSMENTS RENTS NOTES DUE FROM OTHERS 32951.01 29859.02 62810.03 280523.06 INVENTORY AT COST PREPAID ITEMS 6473.13 6473.13 2538.72 FIXED ASSETS AMOUNTS TO BE PROVIDED 2232500.00 2232500.00 2232500.00 TOTAL ASSETS 18131601.82 498327.91 286052.95 66838.99- 2373279.54 21222423.23 20965110.17 LIAB, FND BAL, RETND EARNINGS - ^� DEPOSITS FOR PRIVATE DEVELPMNT 46955.36 46955.36 46034.39 - DEPOSITS FOR AB1600 FEES 233260.00- 233260.00- 108508.46 - DEPOSITS OTHERS 161047.18- 3125.00- 164172.18- 171822.66 - PAYABLES:A000UNTS 6415.29- 19873.45- 26288.74- 261682.38 - INTEREST PAYROLL 1867.21- 1867.21- 5266.50 - DUE TO OTHERS 390.00- 390.00- 266806.79 - DEBT INSTRUMENTS PAYABLE 2350000.00- 2350000.00- 2790000.00 - TOTAL LIABILTIES 122764.32- 19873.45- 3125.00- 233260.00- 2350000.00- 2729022.77- 3650121.18 - FUND BALANCES 18008837.50- 478454.46- 282927.95- 300098.99 23279.54- 18493400.46- 17314988.99 - TOTAL FUND EQUITY 18008837.50- 478454.46- 282927.95- 300098.99 23279.54- 18493400.46- 17314988.99 - TOTAL LIAB,FND BAL, RETD EARNS 18131601.82- 498327.91- 286052.95- 66838.99 2373279.54- 21222423.23 - 20965110.17- BGL102 11/17/94 ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED 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 LIAB, FND BAL, RETND EARNINGS DEPOSITS 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 TOTAL LIAB,FND BAL, RETD EARNS • CITY OF DUBLIN • PAGE 1 BALANCE SHEET 15.29.16 FOR THE PERIOD 7/94 THROUGH 10/94 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T O T A L S SERVICE FUNDS GROUP OF TERM DEBT - -- MEMORANDUM ONLY - -- FUND ACCOUNTS ACCOUNT GROUP CURRENT JUNE 30, 1994 365343.85 3500.23- 1730761.91 361843.62 285012.11 1730761.91 1726901.55 46871.38 151.00 151.00 153663.97 21110330.12 479805.26 21743799.35 22259445.26 2713930.44 2713930.44 2548360.41 519158.82 22837591.80 479805.26 2713930.44 26550486.32 26866590.71 25603.30- 17615000.00- 2713930.44- 20328930.44- 21151212.29- 17615000.00- 2713930.44- 20328930.44- 21176815.59 - 341820.26- 112701.80- 454522.06- 58387.24 177338.56- 5109890.00 - 5287228.56- 5278147.74 - 479805.26- 479805.26- 470014.62- 519158.82- 5222591.80- 479805.26- 6221555.88- 5689775.12- 519158.82- 22837591.80 - 479805.26- 2713930.44- 26550486.32 - 26866590.71- BGL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 11/17/94 REVENUES VERSUS EXPENDITURE 15.05.29 FOR THE PERIOD 7/94 THROUGH 10/94 GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T-D * * * * * ** *REVENUES * * * * * ** PROPERTY TAXES 3849500.00- 328578.63- 8.5 3520921.37- 3853101.60- 345594.44- 9.0 3507507.16 - SALES TAX 5892000.00- 1741654.13- 29.6 4150345.87- 5969342.43- 1610073.37- 27.0 4359269.06 - REAL PROPERTY TRANSFERS 68500.00- 18770.45- 27.4 49729.55- 65258.80- 23378.44- 35.8 41880.36- TRANSIENT OCCUPANCY TAX 90000.00- 54550.00- 60.6 35450.00- 88318.00- 22546.00- 25.5 65772.00 - FRANCHISE TAXES 479800.00- 35298.07- 7.4 444501.93- 481162.79- 32435.42- 6.7 448727.37 - LICENSES & PERMITS 361350.00- 140460.62- 38.9 220889.38- 340994.82- 157362.25- 46.1 183632.57 - FINES & FORFEITURES 37500.00- 9682.81- 25.8 27817.19- 34316.48- 9474.11- 27.6 24842.37 - USES OF MONEY AND PROPERTY 986100.00- 137775.99- 14.0 848324.01- 935615.38- 188720.35 - 20.2 746895.03 - INTERGOVERNMENTAL FROM STATE 970325.00- 339716.44- 35.0 630608.56- 945713.40- 294145.51 - 31.1 651567.89 - CHARGES FOR SERVICES 758180.00- 264655.40- 34.9 493524.60- 580737.55- 187539.23- 32.3 393198.32 - OTHER SOURCES OF REVENUE 120200.00- 94473.61- 78.6 25726.39- 275567.69- 113575.10- 41.2 161992.59- TOTAL REVENUE 13613455.00- 3165616.15- 23.3 10447838.85- 13570128.94- 2984844.22- 22.0 10585284.72- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 15601.00 .00 15601.00 815.04 .00 815.04 CITY COUNCIL 1010 120014.00 28084.20 23.4 91929.80 102612.23 25475.34 24.8 77136.89 CITY MANAGER 1020 260109.00 80197.63 30.8 179911.37 240219.95 76138.85 31.7 164081.10 CITY ATTORNEY 1030 127170.00 49253.92 38.7 77916.08 235554.62 34327.43 14.6 201227.19 ADMIN SERVICES 1040 451641.00 138578.40 30.7 313062.60 410536.74 116781.38 28.4 293755.36 BUILDING MANAGEMENT 1050 326490.00 83595.17 25.6 242894.83 313411.43 81790.69 26.1 231620.74 FACILITY RENTAL 1050 -719 1553744.00 401726.34 25.9 1152017.66 1458593.27 .00 1458593.27 INSURANCE COST CENTER 1060 134000.00 108200.39 80.7 25799.61 149792.07 127719.90 85.3 22072.17 ELECTIONS COST CENTER 1070 12475.00 37.46 .3 12437.54 10817.83 546.87 5.1 10270.96 ACTIVITY TOTAL 3001244.00 889673.51 29.6 2111570.49 2922353.18 462780.46 15.8 2459572.72 PUBLIC SAFETY: POLICE 2010 3268352.00 54977.78 1.7 3213374.22 2970615.78 83909.02 2.8 2886706.76 CROSSING GUARDS COST 2020 38495.00 2912.15 7.6 35582.85 .00 .00 .00 ANIMAL CONTROL 2030 103750.00 .00 103750.00 92215.39 .00 92215.39 DISASTER PREAPREDNESS 2050 31817.00 .00 31817.00 25728.27 9131.73 35.5 16596.54 FIRE SERVICES JPA 2060 2797315.00 1102560.00 39.4 1694755.00 2632168.71 653808.48 24.8 1978360.23 ACTIVITY TOTAL 6239729.00 1160449.93 18.6 5079279.07 5720728.15 746849.23 13.1 4973878`.92 TRANSPORTATION: PUBLIC WORKS 3010 294390.00 89231.09 30.3 205158.91 282508.50 80887.49 28.6 201621.01 STREET MAINTENANCE 3020 33959.00 31652.82 93.2 2306.18 877.22 449.98 51.3 427.24 STREET TREE MAINTENANCE 3040 50040.00 7883.53 15.8 42156.47 45767.70 12417.08 27.1 33350.62 STREET LANDSCAPE MAINT. 3050 165860.00 54354.68 32.8 111505.32 158297.22 41135.10 26.0 117162.12 ACTIVITY TOTAL 544249.00 183122.12 33.6 361126.88 487450.64 134889.65 27.7 352560.99 HEALTH & WELFARE: WASTE MANAGEMENT 5020 27100.00 .00 27100.00 75.84 .00 75.84 ACTIVITY TOTAL 27100.00 .00 27100.00 75.84 .00 75.84 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 177536.00 .00 177536.00 165000.00 41250.00 25.0 123750.00 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 8000.00 8000.00 100.0 .00 HERITAGE CENTER 8012 26563.00 454.90 1.7 26108.10 2234.23 .00 2234.23 DUBLIN CEMETERY 8013 16680.00 2924.19 17.5 13755.81 8068.33 .00 8068.33 PARK MAINTENANCE 8020 579619.00 1,86485.67 32.2 393133.33 562328.40 142325.90 25.3 420002.50 4RE • GL104C CITY OF DUBLIN STATEMENT SHOWING PAGE 2 11/17/94 REVENUES VERSUS EXPENDITURE 15.05.29 FOR THE PERIOD 7/94 THROUGH.10 /94 GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T -D COMMUNITY CABLE TV 8030 22393.00 .00 22393.00 20279.00 9000.00 44.4 11279.00 RECREATION ADMIN. 8040 177379.00 56162.97 31.7 121216.03 175746.19 52548.27 29.9 123197.92 PLAYGROUNDS 8045 93149.00 37087.94 39.8 56061.06 72270.89 27896.04 38.6 44374.85 SHANNON CENTER 8050 113540.00 31144.30 27.4 82395.70 116563.54 32649.82 28.0 83913.72 PRESCHOOL 8055 38615.00 11863.92 30.7 26751.08 34319.22 9534.32 27.8 24784.90 TEENS PROGRAM 8060 29446.00 6652.11 22.6 22793.89 27928.80 7103.72 25.4 20825.08 ADULT SPORTS 8065 92961.00 26707.09 28.7 66253.91 76349.88 27735.05 36.3 48614.83 YOUTH SPORTS 8066 34886.00 10829.08 31.0 24056.92 28570.77 6872.30 24.1 21698.47 SPECIAL EVENTS 8070 31328.00 5723.04 18.3 25604.96 28749.94 5137.40 17.9 23612.54 SENIOR CENTER 8080 109422.00 31721.39 29.0 77700.61 98858.25 27786.59 28.1 71071.66 RECREATION INSTRUCTION 8090 81736.00 25999.36 31.8 55736.64 78626.11 21113.67 26.9 57512.44 AQUATICS 8100 197008.00 87965.00 44.7 109043.00 205324.75 89035.69 43.4 116289,06 ACTIVITY TOTAL 1832261.00 531720.96 29.0 1300540.04 1709218.30 507988.77 29.7 1201229.53 COMMUNITY DEVELOPMENT: PLANNING 9010 611170.00 156151.98 25.5 455018.02 511179.82 159086.55 31.1 352093.27 BUILDING SAFETY 9020 266000.00 71526.90 26.9 194473.10 252992.23 67767.08 26.8 185225.15 ENGINEERING 9030 204072.00 53520.31 26.2 150551.69 215790.71 66091.11 30.6 149699.60 ECONOMIC DEVELOPMENT 9040 75132.00 350.88 .5 74781.12 6328.57 5035.00 79.6 1293.57 ACTIVITY TOTAL 1156374.00 281550.07 24.3 874823.93 986291.33 297979.74 30.2 688311.59 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 93NN 57015.00 1277.00 2.2 55738.00 .00 .00 .00 COMMUNITY IMPROVEMENTS 94NN 50000.00 3564.39 7.1 46435.61 48603.17 1143.70- 2.4- 49746.87 PARKS 95NN .00 4987.60 4987.60- 12423.92 .00 12423.92 STREET CONSTRC /IMPROVMT 96NN 32500.00 32500.00 100.0 .00 281695.66 10408.60 3.7 271287.06 ACTIVITY TOTAL 139515.00 42328.99 30.3 97186.01 342722.75 9264.90 2.7 333457.85 T 0 T A L EXPENDITURES 12940472.00 3088845.58 23.9 9851626.42 12168840.19 2159752.75 17.7 10009087.44 EXCESS <REVENUE>EXPENDITURES 672983.00- 76770.57- 11.4 596212.43- 1401288.75- 825091.47- 58.9 576197.28 - TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 77093.25- .00 77093.25 - TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 41883.81 29424.86 70.3 12458.95 EXCESS < REVENUE> EXPENDITURE 672983.00- 76770.57 - 11.4 596212.43- 1436498.19- 795666.61- 55.4 640831.58- BGL104C OHE CITY OF DUBLIN STATEMENT SHOWING • PAGE 1 11/17/94 REVENUES VERSUS EXPENDITURE 15.08.34 FOR THE PERIOD 7/94 THROUGH 10/94 SPECIAL REVENUE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * * * * * ** REVENUES******* SALES TAX 116000.00- 40004.89- 34.5 75995.11- 117622.52- 35702.27- 30.4 81920.25 - FINES & FORFEITURES 31900.00- 8208.38- 25.7 23691.62- 33963.62- 10587.48- 31.2 23376.14 - SPECIAL BENEFITS ASSESSMENTS .00 895.38- 895.38 .00 .00 .00 USES OF MONEY AND PROPERTY 35800.00- .00 35800.00- 35095.85- .00 35095.85 - INTERNGOVERNMENTAL FROM STATE 611854.00- 130474.19 - 21.3 481379.81- 609800.83 - 134629.03- 22.1 475171.80 - INTERGOVERNMENTAL FROM COUNTY 150000.00- 37978.00 - 25.3 112022.00- 125984.50- .00 125984.50 - INTERGOVERNMENTAL FROM FEDERAL 2329428.00- .00 2329428.00- 116540.21- .00 116540.21- CHARGES FOR SERVICES 697356.00- 239.11- 697116.89- 742458.70- 2015.91- .3 740442.79 - OTHER SOURCES OF REVENUE 16000.00- 3251.42- 20.3 12748.58- 11993.19- 6587.32- 54.9 5405.87 - TOTAL REVENUE 3988338.00- 221051.37- 5.5 3767286.63- 1793459.42- 189522.01- 10.6 1603937.41- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: POLICE 12350.00 50.00 .4 12300.00 12067.48 1387.57 11.5 10679.91 TRAFFIC SIGNALS 90790.00 13476.23 14.8 77313.77 82277.35 12515.75 15.2 69761.60 ACTIVITY TOTAL 103140.00 13526.23 13.1 89613.77 94344.83 13903.32 14.7 80441.51 TRANSPORTATION: PUBLIC WORKS 526.00 .00 526.00 .00 .00 .00 STREET MAINTENANCE 215050.00 134790.17 62.7 80259.83 158820.98 94291.95 59.4 64529.03 STREET SWEEPING 73360.00 16363.19 22.3 56996.81 69985.83 15971.88 22.8 54013.95 ACTIVITY TOTAL 288936.00 151153.36 52.3 137782.64 228806.81 110263.83 48.2 118542.98 HEALTH & WELFARE: WASTE MANAGEMENT 640137.00 8485.63 1.3 631651.37 542622.00 2200.00 .4 540422.00 CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 113450.00 16397.32 14.5 97052.68 117649.45 14089.92 12.0 103559.53 ACTIVITY TOTAL 113450.00 16397.32 14.5 97052.68 117649.45 14089.92 12.0 103559.53 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 17269.00 .00 17269.00 _ .00 .00 .00 CORMUNITY IMPROVEMENTS 177525.00 5586.34 3.1 171938.66 58968.45 26764.60 45.4 32203.85 PARKS 29895.00 .00 29895.00 133793.53 11009.28 8.2 122784.25 STREET CONSTRUCTION /IMPROVMT 2486696.00 99699.66 4.0 2386996.34 364376.28 13883.63 3.8 350492.65 ACTIVITY TOTAL 2711385.00 105286.00 3.9 2606099.00 557138.26 51657.51 9.3 505480.75 T 0 T A L EXPENDITURES 3857048.00 294848.54 7.6 3562199.46 1540561.35 192114.58 12.5 1348446.77 EXCESS <REVENUE >EXPENDITURE 131290.00- 73797.17 56.2- 205087.17- 252898.07- 2592.57 1.0- 255490.64 - TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 32728.18- 29424.86- 89.9 3303.32 - TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 9451.83 .00 9451.83 EXCESS < REVENUE> EXPENDITURE 131290.00- 73797.17 56.2- 205087.17- 276174.42- 26832.29 - 9.7 249342.13- BGL104C 11/17/94 * * * * * ** *REVENUES * * * * * ** OTHE CITY OF DUBLIN STATEMENT SHOWING • REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/94 THROUGH 10/94 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D PAGE 1 15.12.17 SPECIAL BENEFITS ASSESSMENTS 288265.00- 303.35- .1 287961.65- 533098.91- 3198.61- .6 529900.30 - USES OF MONEY AND PROPERTY 15000.00- .00 15000.00- 22974.46- .00 22974.46 - OTHER SOURCES OF REVENUE 5725.00- .00 5725.00- 14269.21- 4727.89- 33.1 9541.32 - TOTAL REVENUE 308990.00- 303.35- .1 308686.65- 570342.58- 7926.50- 1.4 562416.08- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL .00 .00 .00 210730.75 565406.00 268.3 354675.25 - ACTIVITY TOTAL .00 .00 .00 210730.75 565406.00 268.3 354675.25 - PUBLIC SAFETY: TRFC SIGS /STREET LIGHTING 199025.00 33744.91 17.0 165280.09 190210.84 16165.60 8.5 174045.24 ACTIVITY TOTAL 199025.00 33744.91 17.0 165280.09 190210.84 16165.60 8.5 174045.24 TRANSPORTATION: PUBLIC WORKS 5632.00 993.07 17.6 4638.93 2736.26 1444.56 52.8 1291.70 STREET TREE MAINTENANCE 9890.00 292.61 3.0 9597.39 6807.10 1142.13 16.8 5664.97 STREET LANDSCAPE MAINTENANCE 109940.00 42329.13 38.5 67610.87 105133.50 22845.42 21.7 82288.08 ACTIVITY TOTAL 125462.00 43614.81 34.8 81847.19 114676.86 25432.11 22.2 89244.75 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 4120.00 3203.40 77.8 916.60 3828.40 3458.52 90.3 369.88 ACTIVITY TOTAL 4120.00 3203.40 77.8 916.60 3828.40 3458.52 90.3 369.88 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS .00 .00 .00 4500.00 4500.00 100.0 .00 STREET CONSTRUCTION /IMPROVMT 400000.00 .00 400000.00 .00 .00 .00 ACTIVITY TOTAL 400000.00 .00 400000.00 4500.00 4500.00 100.0 .00 T 0 T A L EXPENDITURES 728607.00 80563.12 11.1 648043.88 523946.85 614962.23 117.4 91015.38 - EXCESS<REVENUE>EXPENDITURE 419617.00 80259.77 19.1 339357.23 46395.73- 607035.73 1308.4- 653431.46 - TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 123895.44- .00 123895.44 - TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 110995.44 .00 110995.44 EXCESS < REVENUE> EXPENDITURE 419617.00 80259.77 19.1 339357.23 59295.73- 607035.73 1023.7- 666331.46- BGL104C *THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 11/17/94 REVENUES VERSUS EXPENDITURE 15.24.26 FOR THE PERIOD 7/94 THROUGH 10/94 CAPITAL IMPROVEMENT FUND 11 CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * * * * ** *REVENUES * * * * * ** USES OF MONEY AND PROPERTY .00 .00 .00 2058.46- .00 2058.46 - OTHER SOURCES OF REVENUE 711509.00- .00 711509.00- 73214.23- .00 73214.23 - TOTAL REVENUE 711509.00- .00 711509.00- 75272.69- .00 75272.69- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: STREET CONSTRUCTION /IMPROVMT 431509.00 23652.21 5.5 407856.79 214021.33 32052.46 15.0 181968.87 ACTIVITY TOTAL 431509.00 23652.21 5.5 407856.79 214021.33 32052.46 15.0 181968.87 T 0 T A L EXPENDITURES 431509.00 23652.21 5.5 407856.79 214021.33 32052.46 15.0 181968.87 EXCESS <REVENUE>EXPENDITURE 280000.00- 23652.21 8.4- 303652.21- 138748.64 32052.46 23.1 106696.18 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 83393.92 .00 83393.92 EXCESS < REVENUE> EXPENDITURE 280000.00- 23652.21 8.4- 303652.21- . 222142.56 32052.46 14.4 190090.10 11 • BGL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 11/17/94 REVENUES VERSUS EXPENDITURE 15.16.08 FOR THE PERIOD 7/94 THROUGH 10/94 INTERNAL SERVICE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * * * * ** *REVENUES * * * * * ** USES OF MONEY AND PROPERTY 11600.00- .00 11600.00- 15381.72- .00 15381.72 - CHARGES FOR SERVICES 124608.00- 41821.04- 33.6 82786.96 - 128214.28- 43590.25- 34.0 84624.03 - OTHER SOURCES OF REVENUE .00 1038.54- 1038.54 7615.50- .00 7615.50 - TOTAL REVENUE 136208.00- 42859.58- 31.5 93348.42- 151211.50- 43590.25- 28.8 107621.25- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 230233.00 14020.04 6.1 216212.96 127280.78 55310.51 43.5 71970.27 ACTIVITY TOTAL 230233.00 14020.04 6.1 216212.96 127280.78 55310.51 43.5 71970.27 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 230233.00 14020.04 6.1 216212.96 127280.78 55310.51 43.5 71970.27 EXCESS<REVENUE> EXPENDITURE 94025.00 28839.54- 30.7- 122864.54 23930.72- 11720.26 49.0- 35650.98 - EXCESS < REVENUE> EXPENDITURE 94025.00 28839.54- 30.7- 122864.54 23930.72- 11720.26 49.0 - 35650.98- BGL1O4C 11/17/94 Ilk CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/94 THROUGH 10/94 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE * * * * * ** *REVENUES * * * * * ** USES OF MONEY AND PROPERTY 1658112.00 - TOTAL REVENUE 1658112.00- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 1553784.00 ADMIN SERVICES 13870.00 ACTIVITY TOTAL 1567654.00 PUBLIC SAFETY: 5.0 1489382.88 DISASTER PREAPREDNESS 1150.00 ACTIVITY TOTAL 1150.00 TRANSPORTATION: 1150.00 HEALTH & WELFARE: .00 CULTURE & LEISURE SERVICES: 12008.13- RECREATION ADMINISTRATION 10180.00 SENIOR CENTER 463.00 ACTIVITY TOTAL 10643.00 COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1579447.00 EXCESS<REVENUE> EXPENDITURES 78665.00 - TRANSFERS IN FROM OTHER FUNDS .00 EXCESS < REVENUE> EXPENDITURE 78665.00- 0 PAGE 1 15.20.19 PREVIOUS YEAR ENDING JUNE 30, 1994 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D 405931.29- 24.5 1252180.71- 1564715.31- 405931.29- 24.5 1252180.71 1564715.31- 75747.37 4.9 1478036.63 1436774.32 2523.75 18.2 11346.25 1635.85 78271.12 5.0 1489382.88 1438410.17 .00 1150.00 .00 .00 1150.00 .00 967.67 9.5 9212.33 10864.05 250.00 54.0 213.00 338.14 1217.67 11.4 9425.33 11202.19 79488.79 5.0 1499958.21 1449612.36 326442.50- 415.0 247777.50 115102.95- .00 .00 12008.13- 326442.50- 415.0 247777.50 127111.08- 866.61- .1 1563848.70- 866.61- .1 1563848.70- .00 1436774.32 410.00 25.1 1225.85 410.00 1438000.17 .00 .00 .00 .00 2934.67 27.0 7929.38 238.14 70.4 100.00 3172.81 28.3 8029.38 3582.81 .2 1446029.55 2716.20 2.4- 117819.15- .00 12008.13- 2716.20 2.1- 129827.28- GL370 TRIAL BALANCE FOR FUND 515 DUBLIN BLVD EXT TRUST /AGENCY 11/17/94 ACCOUNT BALANCES THRU 10/31/94 FUND 515 ASSET SUMMARY PAGE 1 15.36.12 REMAINING DEPT-OBJ-SUB DESCRIPTION DEBIT /CREDIT BUDGET BUDGET %COMP 1000 - 101 -002 OPERATING ACCOUNT 19569.50 * * 19569.50 -* .0 % 1000- 102-000 CASH WITH FISCAL AGENT 121210.04 * * 121210.04 -* .0 % 1000 - 222 -000 AMOUNTS TO BE PROVIDED 2232500.00 * * 2232500.00 -* .0 % 1000- - -- - -- DEPARTMENT TOTAL 2373279.54 ** ** 2373279.54 - ** .0 ---- - - - - -- -TOTAL ASSETS 2373279.54 * ** 2373279.54- * ** .0 % FUND 515 LIABILITY SUMMARY REMAINING DEPT -OBJ -SUB DESCRIPTION DEBIT /CREDIT BUDGET BUDGET %COMP 1000 - 384 -002 BONDS PAYABLE LONG TERM SP ASSMNTS 2350000.00-* * 2350000.00 * .0 % 1000- - - - - -- DEPARTMENT TOTAL 2350000.00 - ** ** 2350000.00 ** .0 % ---- - - - - -- -TOTAL LIABILITIES 2350000.00- * ** 2350000.00 * ** .0 % FUND 515 EQUITY SUMMARY REMAINING DEPT-OBJ -SUB DESCRIPTION DEBIT /CREDIT BUDGET BUDGET %COMP 1000-402 -000 FUND BAL DESIGNATED: DEBT SERVICE 176623.01-* * 176623.01 * .0 1000- - - -- -- DEPARTMENT TOTAL 176623.01 - ** ** 176623.01 ** .0 ---- - - ---- -TOTAL EQUITY 176623.01- * ** 176623.01 * ** .0 % FUND 515 REVENUE SUMMARY REMAINING DEPT -OBJ -SUB DESCRIPTION RECEIVED ESTIMATE ESTIMATE %COMP 1000 - 534 -012 SPECIAL ASSESSMENTS- PENALTIES 6251.28 -* 6251.28 * .0 % 1000- - - - - -- DEPARTMENT TOTAL 6251.28 - ** ** 6251.28 ** .0 % ---- - - - - -- -TOTAL REVENUE 6251.28- * ** 6251.28 * ** .0 % FUND 515 APPROPRIATION SUMMARY REMAINING DEPT- OBJ-SUB DESCRIPTION EXPENDITURES BUDGET BUDGET %COMP 1000 - 732 -000 INTEREST PAYMENTS 85324.75 * * 85324.75 -* .0 % 1000 - 733 -000 PRINCIPAL PAYMENTS 74000.00 * * 74000,00-* .0 % 1000 - 734-000 BOND PREMIUM 270.00 * * 270.00 -* .0 % 1000 ---- - -- DEPARTMENT TOTAL 159594.75 ** ** 159594.75 - ** .0 % ---- - - - - -- -TOTAL APPROPRIATIONS 159594.75 * ** 159594.75 - * ** .0 % -- - - - - -- -FUND 515 TOTAL .0 %