Loading...
HomeMy WebLinkAboutItem 4.03 PrelimFinRpt 6-96 ,. CITY CLERK , File # D@][ill~-@J(Q] . AGENDA STATEMENT CITY COUNCIL MEETING DATE: (October 1,1996) ::- .. . , SUBJECT: mn J Preliminary Financial Report For the Month of June 1996 \VA -- ( Report Prepared by: Paul S. Rankin, Assistant City Manager / Administrative Services Director) EXHIBITS ATTACHED: 1. Pro Forma Balance Sheet and Income Statements for the Period Ending June 30, 1996 RECOMMENDATION: 0. Accept and file the report. FINANCIAL STATEMENT: See Report. :-: DESCRIPTION: This item provides the monthly financial statement for the month of .June 1996, which represents the final month of the Fiscal Year. The report includes the final budget , adjustments as approved by the City Council on September 17, 1996. FINANCIAL STATEMENTS The Financial Statements are considered preHminary due to the fact that additional financial entries are required before the books for Fiscal Year 1995/96 are fully closed. The report does reflect various billings and receipts processed subsequent to June 30, 1996, but recorded appropriately in the 1995/96 Fiscal Year. Due to recent changes in accounting standards there will be some changes which will be booked at the time of the final audit. Specifically the accrual of Sales Tax is treated differently and it will be discussed in this report. " : ~ " " " The report will highlight significant trends, which differ from infonnationpresented in earlier reports. The'fiD81 rcswtS~ for'the year appear to be largely consistent 'With the iiiojeCtions'iJlCluded in the Fiscal Year 1996/97 Preliminary Budget and Financial Plan, which was presented to the City Council last June. Given the fact that the Genem1 Fund comprises the greatest portion of the City's operations, the analysis in the Staff Report will focus on activities within this fund. ;: General Fund Revenues Overall, General Fund Revenues as shown on the report are approximately 4.09€'1'o greater than General Fund Revenues collected in the previous Fiscal Year. It should be noted that this difference will increase once the final accrual of sales tax is posted as part of the Audit. An additional $405,906 in sales tax is .being booked in Fiscal Year 1995/96 as part of the Audit. COPIES TO: .ITEMNO.~ ~:. . " ------------------------------------------------------------------- This late entry is due to a change in the accounting requirements for the recognition of revenue. This change also affected other revenues, however, the Sales Tax category is the affected to the largest degree. The data necessary to calculate the sales tax entry was not released by the State until the week of September 17, 1996. The change affects how the City records estimated sales tax payments received in . July ~ September, related to sales transactions occurring prior to the previous June 30th. This will create problems ~ comparing certain 1995/96 recorded revenues, directly with the amount recorded for the previous year, since the accrual method used for the two years is different. Staffhas provided revised comparisons where the differences were the most significant. The following areas contributed to the increase in General Fund Revenues over the prior Fiscal Year: Sales Tax The Automobile Retail Sales through out the State were up from prior years. In addition, the UnisoUI'Ce facility did not relocate until the second quarter and the City received a share of the sales prior to the moving of the facility. Staffhas attempted to compare the actual sales tax figure to an adjusted amount for the 1994/95 Fiscal Year. The adjusted amount was derived at by using the same accrual methodology. In this scenario the 1995/96 amount will be 5.19% ($333,692) more than 1994/95(Adjusted For Accruals). Transient Occupancy Tax , As noted in previous reports this revenue has been increasing due to a change in the affiliation of the hotel, as well as increased business travel throughout the region. This revenue was also affected by the accounting change. When it is compared with an adjusted figure for the prior year the 1995/96 revenue is 57.15% ($72,110) more than the amount attributable to Fiscal Year 1994/95. Licen!;es & Permits The amount of revenue in this category for 1995/96 is 38.11 % ($128,648) more than the amount collected . in Fiscal Year 1994/95. This is primarily attributable to increased building permits due to increased construction activity. Use of Money & PrQ~ The 1995/96 General Fund Interest Revenue is approximately 11.24% ($128,171) more than the amount recorded in the previous Fiscal Year. This difference is primarily due to a larger fund balance available for investment. The average rate ofreturn for both years was very similar 5.76% in Fiscal Year 1995/96 and 5.75% in Fiscal Year 1994/95. Interaovernmental (Sta~) This category relates primarily to Motor Vehicle In Lieu Fees and Homeowner Property Tax Relief. The increase in vehicle sales statewide resulted in additional monies available for distribution by the State. The 1995/96 Revenue in this category is approximately 5.6% ($58,494) more than the amount recorded in the previous Fiscal Year. Chat:~es F 9r Services Amounts collected in this category are affected by items similar to the License & Pennit category. The increase in development activity resulted in increased revenues over the previous year. An increase of approximately 30.3% ($319,245) when compared to the previous year. Included in this figure is approximately $135,000 related to Annexation Area Service Fees collected as part of an agreement with a ,.c major Eastern Dublin landowner. J In analyzing revenue trends in the General Fund, it is worth noting that a decline occurred in the Property Tax category. In Fiscal Year 1995/96 total revenue in this category decreased by approximately -1.94% ($76,670) This reflects similar trends county wide due to appeals of assessed values and refunds. . General F.und Expenditures Total Fiscal Year 1995/96 General Fund Expenditures are projected to be approximately 94.2% of the amount budgeted. The following sections describe specific deviations by Program Area. General Government: (91.2% of Budgeted Expenditures) This reflects favorable results from Insurance claims expense; salary savings from a vacant position as well as a delay in obtaining contract accounting services for a portion of the year in Administrative Services; and a requirement to budget the Gross Civic Center Lease Payment even though a portion of the payment is paid for by interest income from reserve investments held by the Trustee. Public Safety: (96.8% of Budgeted Expenditures) The City Council approved additional Police Services related to development plan processing. The level of additional services required were less than originally anticipated, due to withdrawal of a major development application; a vacancy was experienced in the Community Safety Assistant position for a portion of the year; Animal Cop.trol Field Service costs reflect the hours of service received, which were less than the budget accommodated; and Fire Service costs were less than expected due to a delay in the need to open Station No.3. . Transportation: (96.4% of Budgeted Expenditures) In the Street Maintenance Category, a larger percentage of the scope of work was accomplished with special grant funds, instead of General Funds. Cuiture & Leisure Services: (93.6% of Budgeted Expenditures) Expenditures in the Program Area were impacted by the need to cancel some Adult Sports programs due to weather. Staffing for these programs is typically part-time City Staff and/or contract staff. Expenses in these areas are reduced when programs are canceled. In the Park Maintenance area expenditures were also affected by the weather. The longer rainy season resulted in reduced mowing frequency and maintenance costs. In addition there was a decrease in vandalism related repairs within the parks. Community Development: (94.6% of Budgeted Expenditures) The Planning activity was affected by Staff turnover and vacancies. The Budget for the Building & Safety division assumed that the increase in development activity would necessitate an additional inspector. This workload did not materialize until later than anticipated in the Fiscal Year. Capital Projects: (73.6% of Budgeted Expenditures) It is not uncommon to experience a deviation with Capital Projects since they may span more than one fiscal year. The exact timing of payments and progress towards completion varies. Any required adjustments in the Fiscal Year 1996/97 Budget, to accommodate projects which were carried over, will be presented at a later date. Staff recommends that the City Council receive and file this report as authorized by Section 41004 of the . California Government Code. The complete and final information will be presented as part of the Comprehensive Annual Financial Report (CAFR), once the independent audit report has been prepared. ;.- j CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JUNE 1996 Prepared by The Finance Department September 16, 1996 EXHmIT 1 . . . il GL1 02 CITY OF DUBLIN PAGE 1 9/16/96 BALANCE SHEET 9.18.56 FOR THE PERIOD 7/95 THROUGH 6/96 . GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY - - - MEMORANDUM ONLY _u FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1995 ASSETS CASH 2899340.87- 1503877.71 256748.40 2n066.59 164832.64 701815.53- 668696.69- CASH YITH FISCAL AGENT 129917.22 129917.22 122903.69 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 24618006.89 24618006.89 22006245.38 RECEIVABLES:TAXES 74334.65 74334.65 91387.10 ACCOUNTS (NET) 282253.77 63278.52 168966.24 514498.53 783124.27 INTEREST 398353.32 398353.32 345940.01 ASSESSMENTS 8218.15 22739.57 30957.n 19159.87 RENTS NOTES DUE FROM OTHERS 432106.39 539053.80 971160.19 901658.84 INVENTORY AT COST PREPAID ITEMS 5609.57 5609.57 4716.20 FIXED ASSETS AMOUNTS TO BE PROVIDED 2090500.00 2090500.00 2158500.00 TOTAL ASSETS 22911323.n 2114428.18 279487.97 441032.83 2385249.86 28131522.56 25764938.67 L~ND BAL, RETND EARNINGS o S FOR PRIVATE DEVELPMNT 82994.30- 82994.30- 62536.05 DE TS FOR AB1600 FEES 210233.11- 210233.11- 168652.48- OEPOSITS OTHERS 384265.48- 168966.24- 553231. n- 620775.20- PAYABLES:ACCOUNTS 1556558.36- 266410.04- 26312.69- 231616.22- 2080897.31- 1497154.62- INTEREST : PAYROLL 61671.05- 61671.05- 55156.78- DUE TO OTHERS 7162.30- 421030.71- 428193.01- 627989.00- DEBT INSTRUMENTS PAYABLE 2208000.00- 2208000.00- 2276000.00- TOTAL L1ABILTIES 2092651.49- 687440.75- 26312.69- 610815.57- 2208000.00- 5625220.50- 5183192.03- FUND BALAHCES 208186n.23- 1426987.43- 253175.28- 169782.74 1m49.86- 22506302.06- 20581746.64- TOTAL FUND EQUITY 208186n.23- 1426987.43- 253175.28- 169782.74 1m49.86- 22506302.06- 20581746.64- TOTAL LIAB,FND BAL, RETD EARNS 22911323.n- 2114428.18- 279487.97- 441032.83- 2385249.86- 28131522.56- 25764938.67- .. . GL102 CITY OF DUBLIN PAGE l' 9/16/96 BALANCE SHEET 9.23.45 FOR THE PERIOD 7/95 THRWGH 6/96 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOT A L S ~ SERVICE FUNDS GRWP OF TERM DEBT --- MEMORANDUM ONLY --- FUND ACCWNTS ACCWNT GRWP CURRENT JUNE 30, 1995 ASSETS CASH 276432. 19 276432. 19 307190.16 CASH YITH FISCAL AGENT 1719601.80 1719601.80 1744947.62 UNAMORTIZED BOND DISCWNT INVESTMENTS AT COST RECEIVABLES: TAXES ACCWNTS (NET) INTEREST 47559.57 47559.57 46354.57 ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS' 5n8.28 FIXED ASSETS 574365.04 20084069.28 513348.70 21171783.02 213650n.67 AMOUNTS TO BE PROVIDED 5327970.26 5327970.26 2855403.88 TOTAL ASSETS 850797.23 21851230.65 513348.70 5327970.26 28543346.84 26324697.18 LIAB, FND BAL, RETND EARNINGS ~ DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:ACCWNTS 1331.60- 1331.60- 15866.09- INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 16623049.50- 5327970.26- 21951019.76- 20194909.63- TOTAL LIABILITIES 1331.60- 16623049.50- 5327970.26- 21952351.36- 20210775.n- FUND BALANCE 503648.60- 118291.15- 621939.75- 279627.86- CONTRIBUTIONS 345817.03- 5109890.00- 5455707.03- 5347612.75- INVESTMENTS IN FIXED ASSETS 513348.70- 513348.70- 496512.96- RETAINED EARNINGS TOTAL FUND EQUITY 849465.63- 5228181.15- 513348.70- 6590995.48- 6113921.46- TOTAL LIAB,FND BAL, RETD EARNS 850797.23- 21851230.65- 513348.70- 5327970.26- 28543346.84- 26324697.18- ~ :>L104c THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/16196 REVENUES VERSUS EXPENDITURE 9.28.34 FOR THE PERIOD 7195 THROUGH 6/96 . GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1995 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ******--REVENUES******* .. 'ROPERTY TAXES 3968100.00- 3867613.84-' 97.5 100486.16- 3944284.28- 3944284.28- 100.0 .00 SALES TAX 6400000.00- 6354506.63- ' 99.3 45493.37- 6470287.39- 6470287.39- 100.0 .00 ~EAL PROPERTY TRANSFERS 78000.00- 60181.18- 77.2 17818.82- 58070.83- 58070.83- 100.0 .00 TRANSIENT OCCUPANCY TAX 112000.00- 198284.00- 177.0 86284.00 112580.00- 112580.00- 100.0 .00 FRANCHISE TAXES 615500.00- 607146.84- 98.6 8353.16- 481155.78- 481155.78- 100.0 .00 liCENSES & PERMITS 565650.00- 466198.n- 82.4 99451.28- 337550.69- 337550.69- 100.0 .00 FINES & FORFEITURES 35000.00- 38792.80- 110.8 3792.80 35668.12- 35668.12- 100.0 .00 ~ES OF MONEY AND PROPERTY 1124850.00- 1268885.15- 112.8 144035.15 1140713.87- 1140713.87- 100.0 .00 INTERGOVERNMENTAL FROM STATE 1031450.00- 1102495.65- 106.9 71045.65 1044001.82- 1044001.82- 100.0 .00 :HARGES FOR SERVICES 1322561.00- 13n959.58- 103.8 50398.58 1053715.45- 1053715.45- 100.0 .00 JTHER SOURCES OF REVENUE 135875.00- 110803.95- 81.5 25071.05- 163462.88- 163462.88- 100.0 .00 TOTAL REVENUE 15388986.00- 15447868.34- 100.4 58882.34 14841491.11- 14841491.11- 100.0 .00 *******EXPENOITURES******* ~ENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 91693.00 .00 91693.00 13n10.00 13n10.00 100.0 .00 CITY COUNCIL 1010 138945.00 127389.95 91.7 11555.05 106703.42 106703.42 100.0 .00 CITY MANAGER 1020 281336.00 275833.29 98.0 5502.71 255861.89 255861.89 100.0 .00 CITY ATTORNEY 1030 161933.00 161933.22 100.0 .22- 188007.10 188007.10 100.0 .00 ~ SERVICES 1040 547130.00 4951n.80 90.5 51957.20 445264.08 445264 . 08 100.0 .00 ING MANAGEMENT 1050 339874.00 335485.57 98.7 4388.43 317163.30 317163.30 100.0 .00 LITY RENTAL 1050-719 1604480.00 1499521.58 93.5 10495S.42 1461448.88 1461448.88 100.0 .00 INSURANCE COST CENTER 1060 119800.00 101710.52 84.9 18089.48 124851.39 124851.39 100.0 .00 ELECTIONS COST CENTER 1070 660.00 563.52 85.4 96.48 6078.n 6078.n 100.0 .00 ACTIVITY TOTAL 3285851.00 2997610.45 91.2 288240.55 3042588.78 3042588.78 100;0 .00 llUBLI C SAFETY: POll CE 2010 3599781.00 3540387.58 98.4 59393.42 3119865.40 3119865.40 100.0 .00 CROSSING GUARDS COST 2020 47749.00 43292.88 90.7 4456.12 36333.77 ..36333.77 100.0 .00 ANIMAL CONTROL 2030 182440.00 126363.14 69.3 56076.86 70885.70 70885 .70 100.0 .00 DISASTER PREAPREDNESS 2050 43460.00 27045.45 62.2 16414.55 14798.56 14798.56 100.0 .00 fIRE SERVICES JPA 2060 3062737.00 2978987.58 97.3 83749.42 2801337.13 2801337.13 100.0 .00 ACTIVITY TOTAL 6936167.00 6716076.63 96.8 220090.37 6043220.56 6043220.56 100.0 .00 TRANSPORTATION : PUBLI C I.IORKS 3010 312060.00 304830.22 97.7 n29.78 29n40.13 29n40.13 100.0 .00 STREET MAINTENANCE 3020 159460.00 140949.59 88.4 18510.41 31902.53 31902.53 100.0 .00 STREET TREE MAINTENANCE 3040 48615.00 48192.39 99.1 422.61 418n.n 41Sn.n 100.0 .00 STREET LANDSCAPE MAINT. 3050 197367.00 197364.32 100.0 2.68 168920.81 168920.81 100.0 .00 ACTIVITY TOTAL 717502.00 691336.52 96.4 26165.48 539936.19 539936.19 100.0 .00 HEALTH & ~LFARE: WASTE MANAGEMENT 5020 .00 .00 .00 17411.78 17411.78 100.0 .00 ACTIVITY TOTAL .00 .00 .00 17411.78 17411. 78 100.0 .00 :ULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 194188.00 194188.00' 100.0 .00 177536.00 177536.00 100.0 .00 CULTURAL ACTIVITIES 8011 20000.00 17500.00' 87.5 2500.00 10000.00 10000.00 100.0 .00 HERITAGE CENTER 8012 42561.00 41860.33/ 98.4 700.67 6737.62 6737.62 100.0 .00 OUBLlN CEMETERY 8013 22100.00 16075.33/ n.7 6024.67 16854.77 16854.77 100.0 .00 PARK MAINTENANCE 8020 600037.00 554536.91'" 92.4 45500.09 584045 .96 584045.96 100.0 .00 . GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2' 9/16/96 REVENUES VERSUS EXPENDITURE 9.28.34 FOR THE PERIOD 7/95 THRooGH 6/96 GENERAL REVENUE FUND . CURRENT PERIOD PREVlooS YEAR ENDING JUNE 30, 1995 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-O ,. COMMUNITY CABLE TV 8030 33836.00 23736.00/' 70.2 10100.00 22779.27 22779.27 100.0 .00 RECREATION ADMIN. 8040 197556.00 190175.44 96.3 7380.56 178485.58 178485.58 100.0 .00 PLAYGRooNDS 8045 102066.00 99908.83 97.9 2157.17 95612.89 95612.89 100.0 .00 SHANNON CENTER 8050 123348.00 128665.35 104.3 5317.35- 107202.90 107202.90 100.0 .00 PRESCHOOL 8055 48840.00 48241.56 98.8 598.44 37414.34 37414.34 100.0 .00 TEENS PROGRAM 8060 36982.00 29512.30 19.8 7469.70 27525.50 27525.50 100.0 .00 ADULT SPORTS 8065 81399.00 59974.19 73.7 21424.21 66218.32 66218.32 100.0 .00 yooTH SPORTS 8066 35192.00 33593.09 93.9 2198.91 31761.14 31761.14 100.0 .00 .. SPECIAL EVENTS 8070 34410.00 33694.49 97.9 715 .51 30612.01 30612.01 100.0 .00 SENIOR CENTER 8080 109176.00 100622.69 92.2 8553.31 108674.38 108674.38 100.0 .00 RECREATION INSTRUCTION 8090 82691.00 76940.68 93.0 5750.32 75381.16 75381.16 100.0 .00 AQUATICS 8100 207167.00 196m.22 95.0 10393.78 189089.80 189089.80 100.0 .00 ACTJVITY TOTAL 1972149.00 1845999.01 93.6 126149.99 1765991.64 1765991 .64 100.0 .00 COMMUNITY DEVELOPMENT: PLANNING 9010 897848.00 838445.66 93.4 59402.34 648241 .27 648241.27 100.0 .00 BUILDING SAFETY 9020 304219.00 263171.36 8677 40447.64 261521.53 261521.53 100.0 .00 ENGINEERING 9030 569323.00 569323.23 100.0 .23- 276569.24 276569.24 100.0 .00 ECONOMIC DEVELOPMENT 9040 107695.00 106703.40 99.1 991.60 63749.94 63749.94 100.0 .00 ACTIVITY TOTAL 1879085.00 1178243.65 94.6 100841.35 1250081.98 1250081.98 100.0 .00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 93NN 94741.00 73453.55 17.5 21287.45 49443.40 49443.40 100.0 .00 COMMUNITY IMPROVEMENTS 94NN 155340.00 124136.78 19.9 31203.22 89836.41 89836.41 100.0 :. PARKS 95NN 63600.00 20046.02 31.5 43553.98 1939.49 1939.49 100.0 STREET CONSTRC/IMPROVMT 96NN 123857.00 104607.01 84.5 19249.99 32500.00 32500.00 100.0 ACTIVITY TOTAL 437538.00 322243.36 73.6 115294.64 119719.30 119719.30 100.0 .00 TOT A L EXPENDITURES 15228292.00 14351509.62 94.2 876782.38 12838950.23 12838950.23 100.0 .00 EXCESS [REVENUE>EXPENDITURES 160694.00- 1096358.72- 682.3 935664.72 2002540.88- 2002540.88- 100.0 .00 TRANSFERS IN FROM OTHER FUNDS .00 38508.75- 38508.75 46410.04- 46410.04- 100.0 .00 .. TRANSFERS ooT TO OTHER FUNDS .00 18673.28 18673.28- 294854.69 294854.69 100.0 .00 : " EXCESS [REVENUE> EX~ENDITURE 160694.00- 1116194.19- 694.6 955500.19 1754096.23- 1754096.23- 100.0 .00 . "I. GL 1 B4C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/16/96 REVENUES VERSUS EXPENDITURE 9.34.08 FOR THE PERIOO 7/95 THRooGH 6/96 . SPECIAL REVENUE FUNDS .. CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1995 ,- BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D .......*REVENUES*..**** SALES TAX 126000.00- 141116.52- 112.0 15116.52 120823.92- 120823.92- 100.0 .00 FINES & FORFEITURES 26000.00- 24330.57- 93.6 1669.43. 24556.82- 24556.82- 100.0 .00 USES OF MONEY AND PROPERTY 61735.00- 89945.79- 145.7 28210.79 49056.30- 49056.30- 100.0 .00 '. INTERNGOVERNMENTAL FROM STATE 629748.00- 536724.31- 85.2 93023.69- 656834.32- 656834.32- 100.0 .00 INTERGOVERNMENTAL FROM COUNTY 102000.00- 126726.00. 124.2 24726.00 151127.00- 151127.00. 100.0 .00 INTERGOVERNMENTAL FROM FEDERAL 2563963.00- 1908174.78- 74.4 655788.22- 523412.91- 523412.91- 100.0 .00 CHARGES FOR SERVICES 819070.00- 820879.80- 100.2 1809.80 744626.00- 744626.00- 100.0 .00 OTHER SOURCES OF REVENUE 625700.00- 568753.12- 90.9 56946.88. 286592.73- 286592.73- 100.0 .00 TOTAL REVENUE 4954216.00- 4216650.89- 85.1 737565.11- 2557030.00- 2557030.00- 100.0 .00 '- **.....EXPENDI TURES******* -- GENERAL GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT 245.00 244.70 99.9 .30 .00 .00 .00 " ACTIVITY TOTAL 245.00 244.70 99.9 .30 .00 .00 .00 PUBLI C SAFETY: POll CE 6000.00 5899.29 98.3 100.71 9360.94 9360.94 100.0 .00 TRAFFIC SIGNALS 102277.00 85416.04 83.5 16860.96 80108.52 80108.52 100.0 .00 ACTIVITY TOTAL 108277.00 91315.33 84.3 16961.67 89469.46 89469.46 100.0 .00 TRANSPORTATION: IIC \lORKS 298.00 1.45 .5 296.55 .00 .00 .00 T MAINTENANCE 167055.00 163324.71 97.8 3730.29 214599.03 214599.03 100.0 .00 T SWEEPING 73655.00 69954.11 95.0 3700.89 70518.94 70518.94 100.0 .00 ACTIVITY TOTAL 241008.00 233280.27 96.8 m7.73 285117.97 285117.97 100.0 .00 HEALTH & WELFARE: WASTE MANAGEMENT 1223345.00 1183933.08 96.8 39411.92 679404.95 679404.95 100.0 .00 .' CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ;, ENGINEERING 107992.00 51425.60 47.6 56566.40 101497.21 101497.21 100.0 .00 ACTIVITY TOTAL 107992.00 51425.60 47.6 56566.40 101497.21 101497.21 100.0 .00 CAPITAL IMPROVEMENT PROJECTS: " GENERAL CIP PROJECTS 7493.00 7089.00 94.6 404.00 rn66.00 17266.00 100.0 .00 ' . COMMUNITY IMPROVEMENTS 80111.00 80111.16 100.0 .16- 181692.50 181692.50 100.0 .00 " PARKS 237416.00 211220.20 89.0 26195.80 2280.00 2280.00 100.0 .00 STREET CONSTRUCTION/IMPROVMT 2701592.00 1967504.82 72.8 734087. 18 697231.63 697231 .63 100.0 .00 ACTIVITY TOTAL 3026612.00 2265925.18 74.9 760686.82 898470.13 898470.13 100.0 .00 '. TOT A L EXPENDITURES 4707479.00 3826124.16 81.3 881354.84 2053959.72 2053959.72 100.0 .00 ~XCESS [REVENUE>EXPENDITURE 246737.00- 390526.73- 158.3 143789.73 503070.28- 503070.28- 100.0 .00 ,. TRANSFERS IN FROM OTHER FUNDS .00 19860.59- 19860.59 .00 .00 .00 TRANSFERS ooT TO OTHER FUNDS .00 28838.30 28838.30- 3600.00 3600.00 100.0 .00 ~XCESS [REVENUE> EXPENDITURE 246737.00- 381549.02- 154.6 134812.02 499470.28- 499470.28- 100.0 .00 . GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE /" I 9116/96 REVENUES VERSUS EXPENDITURE 9.43.50 FOR THE PERIOO 7195 THROUGH 6/96 SPECIAL ASSESSMENT FUNDS . CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1995 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ........REVENUES....... SPECIAL BENEFITS ASSESSMENTS 296105.00- 318115.75- 107.4 22010.75 363469.78- 363469.78- 100.0 .00 USES OF MONEY AND PROPERTY 17130.00- 17813.47- 104.0 683.47 21115.14- 21115.14- 100.0 .00 OTHER SOURCES OF REVENUE 4000.00- .00 4000.00- 3944.45- 3944.45- 100.0 .00 TOTAL REVENUE 317235.00- 335929.22- 105.9 18694.22 388529.37- 388529.37- 100.0 .00 .......EXPENDITURES....... GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING 196374.00 180611. 18 92.0 15762.82 192530.11 192530.11 100.0 .00 ACTIVITY TOTAL 196374.00 180611.18 92.0 15762.82 192530.11 192530.11 100.0 .00 TRANSPORTATION: PUBLIC IMJRKS 5054.00 3947.86 78.1 1106.14 3507.43 3507.43 100.0 .00 STREET TREE MAINTENANCE 9107.00 8867.39 97.4 239.61 5350.84 5350.84 100.0 .00 STREET LANDSCAPE MAINTENANCE 113010.DO 105578.03 93.4 7431.97 110650.86 110650.86 100.0 .00 ACTIVITY TOTAL 127171.00 118393.28 93.1 8m. 72 119509.13 119509.13 100.0 .00 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 3570.00 3085.26 86.4 484.74 3216.97 3216.97 100.0 :. ACT1VITY TOTAL 3570.00 3085.26 86.4 484.74 3216.97 3216.97 100.0 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 40335.00 27505.63 68.2 12829.37 .00 .00 .00 STREET CONSTRUCTION/IMPROVMT 431000.00 7649.54 1.8 423350.46 5470.89 5470.89 100.0 .00 ACTIVITY TOTAL 471335.00 35155.17 7.5 436179.83 5470.89 5470.89 100.0 .00 TOT A L EXPENDITURES 798450.00 337244.89 42.2 461205.11 320727.10 320727. 10 100.0 .00 EXCESS [REVENUE>EXPEND I TURE 481215.00 1315.67 .3 479899.33 67802.27- 67802.27- 100.0 .00 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 42810.04 42810.04 100.0 .00 EXCESS [REVENUE> EXPENDITURE 481215.00 1315.67 .3 479899 . 33 24992.23- 24992.23- 100.0 .00 . JL 1 04C 9/16/96 . ***-****REVENUES******* JTHER SOURCES OF REVENUE TOTAL REVENUE *******EXPENDITURES******* JENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL JUBLI C SAFETY: TRANSPORTATION : iEALTH & ~LFARE: :ULTURE & LEISURE SERVICES: :OMMUNITY DEVELOPMENT: :API TAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPROVMT ACTIVITY TOTAL rOT A L EXPENDITURES :XCESS[REVENUE>EXPENDITURE r.s I N FROM OTHER FUNDS r S OUT TO OTHER FUNDS :XCESS [REVENUE> EXPENDITURE . THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/95 THROUGH 6/96 PAGE 1 10.13.24 CAPITAL IMPROVEMENT FUND BUDGET CURRENT PERIOD ACTUAL PERCENT PREVIOUS YEAR ENDING JUNE 30, 1995 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D VARIANCE 686621.00- 686621.00- 839611.07- 122.3 839611.07- 122.3 152990.07 152990.07 134271.44- 134271.44- 134271.44- 100.0 134271.44- 100.0 .00 .00 ". .00 .00 .00 .00 .00 .00 25000.00 .00 25000.00 .00 .00 .00 11006.00 8021.77 n.9 2984.23 7119.43 7119.43 100.0 .00 913109.00 7On59.92 77.5 205849.08 280120.88 280120.88 100.0 .00 949115.00 715281.69 75.4 233833.31 28n40.31 28n40.31 100.0 .00 949115.00 715281.69 75.4 233833.31 28n40.31 28n40.31 100.0 .00 262494.00 124329.38- 47.4- 386823.38 152968.87 152968.87 100.0 .00 .00 .00 .00 276446.78- 276446.78- 100.0 .00 .00 29531.04 29531.04- .00 .00 .00 262494.00 94798.34- 36.1- 35n92.34 123477.91- 123477.91- 100.0 .00 '.-: ',' :-." ,", .", :.-.. " , '. -, " ,'"0 '. GL 1 O4C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/16/96 REVENUES VERSUS EXPENDITURE 10.22.42 FOR THE PERIOD 7/95 THROOGH 6/96 TRUST/AGENCY FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1995 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ........REVENUES....... SPECIAL BENEFITS ASSESSMENTS 234630.00- 234629.50- 100.0 .50- 222337 .10~ 222337.10- 100.0 .00 USES OF MONEY AND PROPERTY 14000.00- 11997.60- 85.7 2002.40- 7111.65~ 7111.65- 100.0 .00 TOTAL REVENUE 248630.00- 246627.10- 99.2 2002.90- 229448. 75 ~ 229448.75- 100.0 .00 "'.."EXPENDI TURES....... GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 229585.00 232584.50 101.3 2999.50- 242864.50 242864.50 100.0 .00 ACTIVITY TOTAL 229585.00 232584.50 101.3 2999.50- 242864.50 242864.50 100.0 .00 PUBLIC SAFETY: TRANSPORTATION : HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOTAL EXPENDITURES 229585.00 232584.50 101.3 2999.50- 242864.50 242864.50 100.0 .00 EXCESS(REVENUE)EXPENDITURE 19045.00- 14042.60- 73.7 5002.40- 13415.75 13415.75 100.0 .00 EXCESS (REVENUE) EXPENDITURE 19045.00- 14042.60- 73.7 5002.40- 13415.75 13415.75 100.0 .00 . . GL1d4C 9/16/96 . ...***..REVENUES....... USES OF MONEY AND PROPERTY CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE .......EXPENDITURES~...*.* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL PUBL! C SAFETY: TRANSPORTATION: HEALTH & ~LFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS ACTIVITY TOTAL TOT A L EXPENDITURES E~REVENUE>EXPENOITURE EX~ [REVENUE> EXPENDITURE . THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/95 THROUGH 6/96 INTERNAL SERVICE BUDGET CURRENT PERIOO ACTUAL PERCENT 18375 .00- 183656.00- 15200.00- 217231.00- 15884.33- 184255.91- 29894.08- 230034.32- 275604.00 275604.00 57229.08 57229.08 86.4 100.3 196.7 105.9 20.8 20.8 FUND VARIANCE 2490.67- 599.91 14694.08 12803.32 218374.92 218374.92 PAGE 1 10.01.53 PREVIOUS YEAR ENDING JUNE 3D, 1995 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D 18553.23- 128050.00- 2128.54- 148731.77- 18553.23- 100.0 128050.00- 100.0 2128.54- 100.0 148731.77- 100.0 121037.02 121037.02 121037.02 121037.02 100.0 100.0 .00 .00 .00 9832.11 9832.11 100.0 .00 .00 .00 9832.11 9832.11 100.0 275604.00 57229.08 20.8 218374.92 130869.13 130869.13 100.0 58373 . 00 172805.24- 296.0- 231178.24 17862.64- 17862.64- 100.0 58373 . 00 172805.24- 296.0- 231178.24 17862.64- 17862.64- 100.0 ".; .00 .00 .00 .00 -' .. .00 .00 : .00 .00 .00 .00 .00 : ".; ,. ,. " " -. '~ " GL1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/16/96 REVENUES VERSUS EXPENDITURE 10.06.52 FOR THE PERIlXl 7195 THROJGH 6/96 ENTERPRISE FUNDS . CURRENT PERIlXl PREVIOJS YEAR ENDING JUNE 30, 1995 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY 1709280.00- 1594060.99- 93.3 115219.01- 1565843.45- 1565843.45- 100.0 .00 TOTAL REVENUE 1709280.00- 1594060.99- 93.3 115219.01- 1565843.45- 1565843.45- 100.0 .00 ***--**EXPENDITURES*--**** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1604505.00 1388507. 17 86.5 215997.83 1412754.98 1412754.98 100.0 .00 ADMIN SERVICES 7708.00 6948.40 90.1 759.60 7346.35 7346.35 100.0 .00 ACTIVITY TOTAL 1612213.00 1395455.57 86.6 216757.43 1420101.33 1420101.33 100.0 .00 PUBLIC SAFETY: DISASTER PREAPREDNESS 1225.00 1226.33 100.1 1.33- .00 .00 .00 ACTIVITY TOTAL 1225.00 1226.33 100.1 1.33- .00 .00 .00 TRANSPORTATION: HEALTH & YELFARE: CULTURE & LEISURE .SERVICES: RECREATION ADMINISTRATION 11240.00 10125.56 90.1 1114.44 11036.94 11036.94 100.0 .00 SEN I OR CENTER 462.00 200.00 43.3 262.00 420.00 420.00 100.0 .00 ACTIVITY TOTAL 11702.00 10325.56 88.2 1376.44 11456.94 11456.94 100.0 .00 -, COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT'PROJECTS: .- TOT A L EXPENDITURES 1625140.00 1407007.46 86.6 218132.54 1431558.27 1431558.27 100.0 :. .' EXCESS[REVENUE>EXPENDITURES 84140.00- 187053.53- 222.3 102913.53 134285.18- 134285.18- 100.0 TRANSFERS IN FROM OTHER FUNDS .00 18673.28- 18673.28 18407.91- 18407.91- 100.0 .00 EXCESS [REVENUE> EXPENDITURE 84140.00- 205726.81- 244.5 121586.81 152693.09- 152693.09- 100.0 .00 .. " .. .. : . }<;