The URL can be used to link to this page

Home My WebLink AboutItem 4.07 PrelimFinRpt 6-97 CITY CLERK File # 1II3l[3][Q]-~[Q] . AGENDA STATEMENT CITY COUNCIL MEETING DATE: (August 5,1997) Preliminary Financial Report For the Month of June 1997 W'Report Prepared by: Paul S. Rankin, Assistant City Manager Pro Forma Balance Sheet and Income Statements for the Period Ending June 30, 1997 RECOMMENDATION a t ~ Accept and file the reports. SUBJECT: EXHIBITS ATTACHED: FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the preliminary financial statements for the month of June, which represents the final month of the Fiscal Year. 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. . Analysis of Preliminary June 1997 Revenue and E:qtenditure Rqmrt The financial statements are considered prelimimny due to the fact that additional financial entries are required before the books for Fiscal Year 1996/97 are fully closed, including :final accruals for Sales Tax and the :final cleanup payment for police, :fire and animal control services for Fiscal Year 1996/97. The report does reflect various billings and receipts processed through July 28, 1997, but reported appropriately in the 1996/97 Fiscal Year. The report will highlight significant trends, which differ from information presented in earlier reports. This preliminary report will highlight deviations from the projections included in the 1997/98 Budget as well as the final amounts reported last.Fiscal Year. The final revenue results for the year appear to be largely consistent with the projections included in the Fiscal Year 1997/98 Prelimimny Budget and Financial Plan (1997/98 Plan), which was presented to the City Council last June. Currently expenditures are running lower than originally estimated in the Plan, as explained in more detail in this report. It is important to note that the information presented is preliminary and a final report will be presented with the Ann~ Audit Given the fact that the General Fund comprises the greatest portion of the City's .,~ operations, 'the analysis in the Staff Report will focus on activities within this fund. ~,: A more detailed analysis of General Fund Revenue and Expenditures follows. General Fund Rev~nues Overa]LGeneral Fund Revenues as shown on the report are approximately 6% 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, which is provided to the City by the State in September. ------------------------------------------------------------------- COPIES TO: G:\MONTHFS\FY'7\0697AG.DOC '" ITEM NO. 4.1 The following areas contributed to the increase in General Fund Revenues over the prior Fiscal Year: Property Taxes: Property Tax Revenue is approximately $54,353 (1 %) higher than in the prior year and approximately $83,000 more than estimated in the 1997/98 Plan. The increase primarily resulted :from higher Real ~roperty Documentary Tax Revenues resulting from an increase in the number of properties. sold. Regular Property Tax revenue remained relatively flat from the prior year, partially due to a correction by Alameda County related to the 1995/96 shift of property taxes to the Education Revenue Augmentation Fund. The amount of the correction is in excess of $50,000. In addition, Alameda County bas informed the City of an Unsecured 'Tax Refund related to assessments made against Viacom for the fiscal years 1987/88 through 1995/96. The City of Dublin portion of the refund is in excess of$28,000. Both oftbese items are one-time adjustments and should not reoccur in Fiscal Year 1997M98. Sales Tax , Sales Tax is approximately $280,000 under the amount estimated in the 1997/98 Plan for sales taxes collected through July 28, 1997 relating to Fiscal Year 1996/97. However, an accrual still needs to be made for sales taxes received in July through September that relate to the 1996/97 Fiscal Year. An adjustment of approximately $406,000 was made in the prior year for this pmpose, and based upon currently sales activity it is expected that the amount of the adjustment will be similar for Fiscal Year 1996/97, in which case the:final amount for Sales Tax would be approximately $126.000 (2%) over the amount estimAtP'-d in the 1997/98 Plan and approximately $216,000 (3%) more than the amount collected in the prior Fiscal Year. The higher than expected revenues are due to continued strong sales in the Autos and Transportation. Category, which have been: partially offset by declines in the Business & Industry, Building & Construction and Food & Drug categories due to increased regional competition. Transient Occupancy Taxes: are approximately $7,000 (3%) higher than the amount estimated in the 1997/98 Plan and approximately $40,000 (20%) higher than the amount reported for the previous fiscal year due to increased business at the hotel and an increase in the room rental rate by the botel. Franchise Taxes: are approximately $10,000 (1 %) higher than the amount estimated in the 1997/98 Plan and 'approximately $116,000 (190.10) higher than in the prior Fiscal Year due to an increase in the franchise fees collected from the garbage services franchise. Licenses and Permits: , The amomrt of revenue for this category is approximately $157,000 (17%) higher than estimated in the 1997/98 Plan.and approximately $629,000 (135%) higher than the amount reported in the previous fiscal year. The .increases resulted from permits issued for new residential projects in Eastern Dublin, 'Several of which -were processed -earlier than expected when calculating the estimate' for the 1997/98 Plan. Interest and Rentals: are approximately $91,000 (7%) higher than the amount estimated in the 1997/98 Plan and approximately $181,000 (15%) highertban the amount reported in tbepreviousPiscal Year. The difference is primarily due to a larger fund balance available for investment The average rate of retum declined slightly from 5.76% inFisca1 Year 1995/96 to 5.69% for Fiscal Year 1997/98. . Intergovernmental: was approximately $7,000 (< 1 %) higher than the amount estimated in the 1997/98 Plan and approximately $50,000 (5%) higher than the previous Fiscal Year. The increase in vehicle sales -;1.- . . . statewide resulted in additional monies available for distribution by the State for Motor Vehic1e In Lieu Fees, the main component of this revenue category. Charges for Services: were approximately $17,000 (1 %) lower than the amount estimated in the 1997/98 Plan and approximately $40,000 (3%) lower than the previous Fiscal Year. The decrease from the prior year resulted primarily from a reduction in Annexation Area Service Fees collected as part of an agreement with a major Eastern Dublin landowner. In addition, the variance from the amount reported in the 1997/98 Plan is due to lower than expected plan checking fee revenue due to delays in the implementation of commercial development projects in East Dublin. Other Revenues: are approximately $35,000 (15%) higher than the amount estimated in the 1997/98 Plan and approximately $156,000 (137%) higher than the previous Fiscal Year. The variance from the prior year is due to a one-time credit of approximately $100,000 from the Public Employees Retirement System (PERS). The credit relates to excess contributions that occurred during the past several years. In addition, the variance from the amount reported in the 1997/98 Plan is due to the wrlteoff of unclaimed deposit and receipt of unanticipated additional miscellaneous revenues. .' General Fond Ex:penditures Total Fiscal Year 1996/97 General Fund Expenditures are currently running at 91 % of budget. However, staff anticipates that :final expenditures to be at approximately 95% of budget due to the following items which will be posted to the City's financials prior to the audit a.) the City's wammt registers for August, estimated to be approximately $412,000 and b.) an accrual required for the City's final 96/97 payment to DRF A for Fiscal Year 1996-97 operating costs. General Government: (92% of Budgeted Expenditures) This reflects favorable results from Insurance claims expense; salary savings from a vacant position for part 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. .These savings were partially offset by higher than expected legal costs resulting from development work in Eastern Dublin. Public Safety: (87<<'.10 of Budgeted Expenditures) The current year costs for Fire Service are anticipated to be less than budgeted due to a decision by the DRF A Board to reduce the budget and not fund equipment replacement contributions in the final year of operation and a delay in the need for additional Police Personnel, due to the delay in the opening of BART. As noted above, this budget actual difference will change to approximately 91% once the final accrual of the cleanup payments to DRF A and Alameda County for Police and Animal Control Services are posted prior to the start of the audit Health & Welfare (111% of Budgeted Expenditures) In the Waste Management category, unanticipated general fund mailine costs were incurred as a result of the new noticing and public hearing requirements of State Proposition 218. Capital Improvement Projects: : (111 % of Budgeted Expenditures) The budget variance is due to an unbudgeted payment of approximately $196,000 for the purchase of street right of way along Dublin Boulevard, resulting from the settlement of a property condemnation case against the City. This budget will need to be adjusted when the final project report is submitted: It is recommended that the City Council receive and file these reports 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. -,,- . CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JUNE 1997 . Prepared by The Finance Deparnnent July 28. 1997 . / EXHIBIT 1 Gl102 CITY OF DUBll N PAGE 7/28/97 BALANCE SHEET 9.44.5: FOR THE PER 100 7/96 THROUGH 6/97 GENERAL SPECIAL SPECIAL CAPITAL TRUSTI TOT A L. REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONr FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 3D, 19~t ASSETS CASH 4400053.08- 1728337.62 341061.94 1489029.45 173892.54 66m1.53- 701815.53- CASH ~ITH FISCAL AGENT 135920.94 135920.94 129917.22 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 29180177.42 29180177.42 24618006.89 RECEIVABLES: TAXES 74334.65 ACCOUNTS (NET) 378833.94 43571 .92 98536.69 520942.55 920404 . 99 INTEREST 137448.17 137448.17 398353.32 ASSESSMENTS 30957.72 RENTS NoTfS DUE FROM OTHERS 27600.00 23442.60 51042.60 977731. 19 INVEIlTORY AT COST PREPAID ITEMS 4059.08 4059.08 5609.57 FIXED ASSETS AMOUNTS TO BE PROVIDED 2090500.00 2090500.00 2090500.00 TOTAL ASSETS 25328065.53 1795352.14 341061.94 1587566.14 2400313.48 31452359.23 28544000.02 LIAS, FND BAL, RETND EARNINGS 82.- DEPOSITS FOR PRIVATE DEVELPMNT 402659.17- 402659.17- DEPOSITS FOR AB1600 FEES 2008404.15- 2008404.15- 210233.11- DEPOSITS OTHERS 468503.89- 98536.69- 567040.58- 553231.72- PAYABLES:ACCOUNTS 1210070.91- 188523.36- 731.02- 3039.57- 1402364.86- 2079628.82- INTEREST PAYROLL 82693.80- 82693.80- 61671.05- DUE TO OTHERS 434764.01- DEST INSTRUMEIlTS PAYABLE 2208000.00- 2208000.00- 2208000.00- TOTAL lIABILTIES 2163927.n- 188523.36- 731.02- 2109980.41- 2208000.00- 6671162.56- 5630523.01 - FUND BALANCES 23164137.76- 1606828.78- 340330.92- 522414.27 192313.48- 24781196.67- 22913477.01- TOTAL FUND EQUITY 23164137.76- 1606828.78- . 340330.92- 522414.27 192313.48- 24781196.67- 22913477.0~- TOTAL lIAB,FND BAL, RETD EARNS 25328065.53- 1795352.14- 341061.94- 1587566.14- 2400313.48- 31452359.23- 28544000.02' . :< CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/96 THROUGH 6/97 197 . INTERNAL SERVICE FUND ASSETS 406298.12 ~ITH FISCAL AGENT JRT12ED BOND DISCOUNT STMENTS AT COST 1 VABLES : TAXES ACCOONTS (NET) INTEREST ASSESSMENTS RENTS NOTES FROM OTHERS ~NTORY AT COST :>AID ITEMS 3l ASSETS UNTS TO BE PROVIDED 451187.86 857485.98 TOTAL ASSETS ,A BAL, RETND EARNINGS ,Z' FOR PRIVATE DEVELPMNT 'OSITS OTHERS 'ABLES :ACCOONTS INTEREST PAYROLL :; TO OTHERS 3T INSTRUMENTS PAYABLE TOTAL LIABILITIES NO SALANCE IITRIBlITIONS VESTMENTS IN FIXED ASSETS TAINED EARNINGS TOTAL FUND EQUITY 1763.19- 1763.19- 505651.31.- 350071.45- 855722.79- 857485.98- 21347583.18- HAL LIAB,FND BAL, RETD EARNS ~ . :3 ENTERPRISE FUNOS FIXED ASSETS GENERAL LOIIG GROUP of TERM OEBT ACCOUIITS ACCOUNT GROUP 4211.16- 1735586.07 19616208.27 21347583.18 16265000.00- 16265000.00- 27306.82 5109890.00- 5082583.18- 510205.13 510205.13 510205.13- 510205.13- 5327970.26 5327970.26 5327970.26- 5327970.26- 510205.13- 5327970.26- PAGE 1 9.58.44 TOTALS MEMORANDUM ONLY -_. CURRENT JUNE 3D, 1996 402086.96 1735586.07 20577601.26 5327970.26 280L.324L..55 1763.19- 21592970.26- 21594733.L.5- 478344.52- 5459961.L.S- 51020S.13- 6448511. 10- 276432. 19 1719601.80 47559.57 210L.5462.27 5327970.26 28417026.09 1331.60- 21951019.76- 21952351.36- 49L.508.1S- 5L.59961.L.S- 510205.13- 646467L. _73- 280L.324L..55- 28417026.09- G;. i 04: THE CITY OF DUBLIN STATEMENT SH~ING PAGE 7/28/97 REVENUES VERSUS EXPENDITURE 8.57.. FOR THE PERIOO 7196 THROUGH 6/97 GENERAL REVENUE FUND PREVIOUS YEAR ENDING JUNE 3D~~ CURRENT PERIOO BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANC: FISCAL YR Y-T-D ****-**-REVENUES******* PRO?ERTY TAXES 3968400.00- 3876823.33- 97.7 91576.67- 3867613.84- 3867613.84- 100.0 .0, SALES TAX 6480000.00- 6570433.37- 101.4 90433.37 6760413.09- 676OJ.13.09- 100.0 .0: REAL PROPERTY TRANSFERS 13600.00- 114533.84- 155.6 40933.84 60181.18- 60181.18- 100.0 .O~ TRANSIENT OCCUPANCY TAX 176000.00- 237681 .09- 135.0 61681.09 198284.00- 198284.00- 100.0 .0: FRANCHISE TAXES 709800.00- 723384.60- 101.9 13584.60 607146.84- 607146.84- 100.0 or LICENSES & PERMITS 873400.00- 1095926.95- 125.5 222526.95 466198.72- 466198.72- 100.0 .0[, FINES & FORFEITURES 36000.00' 38742.21- 107.6 2742.21 38792.80- 38792.80- 100.0 .0: USES OF MONEY AND PROPERTY 1259600.00- 1374124.07- 109.1 114524.07 126BB85.15- 126BB85.15- 100.0 .oc INTERGOVERNMENTAL FROM STATE 1085650.00- 1151275.49- 106.0 65625.49 1102495.65- 1102495.65- 100.0 .OC INTERGOVERNMENTAL FROM FEDERAL .00 974.00- 974.00 .00 .00 . DC' CHARGES FOR SERVICES 1393510.00- 1332517.20- 95.6 60992.80- 1372959.58- 1372959.58- 100.0 .00 OTHER SOURCES OF REVENUE 116693.25- 232207.32- 199.0 115514.07 110803.95- 110803.95- 100.0 .oe TOTAL REVENUE 16172653.25- 16748623.47- 103.6 575970.22 15853774.80- 15853774.80- 100.0 .oc *******EXPENDITURES....*** GENERAL GOVERNMENT ACTIVITIES: NOlI-DEPARTMENTAL 102401.00 27346.97 26.7 75054.03 .00 .00 ..DC CITY COUNCIL 1010 128264.00 121472.84 94.7 6791.16 127389.95 127389.95 100.0 .or CITY MANAGER 1020 297973 . 00 286837.47 96.3 11135.53 275833.29 275833 . 29 100.0 .oc CITY ATTORNEY 1030 154181.00 199426.85 129.3 45245.85- 161933.22 161933.22 100.0 . AD/UN SERVICES 1040 607862.00 564648.12 92.9 43213.88 495172.80 495172.80 100.0 BUILDING MANAGEMENT 1050 321500.00 298512.00 92.8 22988.00 334374.72 334374.72 100.0 FACILITY RENTAL 1050-719 1601985.00 1496816.41 93.4 105168.59 1499521.58 1499521.58 100.0 .oc INSURANCE COST CENTER 1060 133550.00 117199.28 87.8 16350.72 101710.52 101710.52 100.0 .00 ELECTIONS COST CENTER 1070 21215.00 10360.67 48.8 10854.33 563.52 563.52 100.0 .00 ACTIVITY TOTAL 3368931. 00 3122620.61 92.7 246310.39 2996499 . 60 2996499.60 100.0 .00 PUBLIC SAFETY: POll CE 2010 4016642.00 3789028.45 94.3 227613.55 3540387.58 3540387.58 100.0 .00 CROSSING GUARDS COST 2020 43000.00 40926.26 95.2 2073.74 43292.88 43292.88 100.0 .00 ANIMAL CONTROL 2030 180286.00 86776.00 48.1 93510.00 126363.14 126363.14 100.0 .oc DISASTER PREAPREONESS 2050 32785.00 25992.10 79.3 6792.90 27045.45 27045.45 100.0 . or: FIRE SERVICES JPA 2060 3195294.00 2538829.95 79.5 656464.05 29m19.09 29m19.09 100.0 .OC ACTIVITY TOTAL 7468007.00 6481552.76 86.8 986454.24 6714808.14 6714808.14 100.0 .00 TRANSPORTATION: PUBLI C lI:)Rt::S 3010 320887.00 312633.40 97.4 8253.60 304830.22 304830.22 100.0 .00 STREET MAINTENANCE 3020 128200.00 29045.29 22.7 99154.71 140949.59 140949.59 100.0 .00 STREET TREE MAINTENANCE 3040 48580.00 35209.46 12.5 13370.54 48192.39 48192.39 100.0 .0:. STREET LANDSCAPE MAINT. 3050 199610.00 197834 . 68 99.1 1775.32 197364.32 197364_32 100.0 .oc ACTIVITY TOTAL 697277.00 574722.83 82.4 122554.17 691336.52 691336.52 100.0 .00 HEALTH & WELFARE: IJASTE MANAGEMENT 5020 2000.00 3595.87 179.8 1595.87- .00 .00 .00 CH I LO CARE 5030 12oDo.00 12000.00 100.0 .00 .00 .00 . DC' ACTIVITY TOTAL 14000.00 15595.87 111.4 1595.87' .00 .00 .00 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 205874.00 205874.00 100.0 .00 19..188. DO 194188.00 100.0 .00 CULTURAL ACTIVITIES 8011 12500.00 12500.00 100.0 .00 17500.00 17500.00 100.0 .00 HERIT AGE CENTER 8012 51960.00 53786.17 103.5 1826.17- 41860-33 41860.33 100.0 . l( Gl104C THE CITY OF DUBLIN STATEH=NT SHOWING PAGE 2 7/28/97 REVENUES VERSUS EXPENDITURE 8.57.47 FOR THE PERIOO 7/96 THROUGH 6/97 . GENERAL REVENUE FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FI SCAL YR Y-T-D DUBLIN CEMETERY 8013 17160.00 14900.57 86.8 2259.43 16075.33 16075 .33 100.0 .00 PAR( MAINTENANCE 8020 583418.00 484351.36 83.0 99066.64 554536.91 554536.91 100.0 .00 COMMUNITY CABLE TV 8030 33916.00 33161. 72 97.8 754.28 23736.00 23736. 00 100.0 .00 RECREATION ADMIN. 8040 242784.00 234481.53 96.6 8302.47 190175.44 190175 .44 100.0 .00 PLAYGROUNDS 8045 109528.00 108121.29 98.7 1406.71 99908.83 99908.83 100.0 .00 SHANNON CENTER 8050 134604.00 134187.44 99.7 416.56 128665.35 128665.35 100.0 .00 PRESCHOOL 8055 52070.00 51560.42 99.0 509.58 48241.56 48241. 56 100.0 .00 TEENS PROGRAM 8060 35294.00 25288.35 71.7 10005.65 29512.30 29512.30 100.0 .00 ADULT SPORTS 8065 62718.00 59194.76 94.4 3523.24 59974.79 59974.79 100.0 .00 YOOTH SPORTS 8066 37176.00 39910.77 107.4 2734.n- 33593.09 33593.09 100.0 .00 SPECIAL EVENTS 8070 40143.00 40111. n 99.9 31.23 33694.49 33694.49 100.0 .00 SENIOR CENTER 8080 112711.50 79726.57 70.7 32984.93 101733.54 101733.54 100.0 .00 RECREATION INSTRUCTION 8090 80763.00 89684.89 111.0 8921.89- 76940.68 76940.68 100.0 .00 AQUATICS 8100 198917.00 2omO.55 104.4 8803.55- 196m.22 196m.22 100.0 .00 ACTIVITY TOTAL 2011536.50 1874562.16 93.2 136974.34 1847109.86 1847109.86 100.0 .00 COMMUNITY DEVELOPMENT: PLANNING 9010 732994.00 657189.89 89.7 75804.11 838445.66 838445 .66 100.0 .00 BUILDING SAFETY 9020 385919.00 359675.65 93.2 26240.35 263771 .36 263771.36 100.0 .00 ENGINEERING 9030 563425.00 611267.05 108.5 47842.05- 569323.23 569323.23 100.0 .00 ECONOMIC DEVELOPMENT 9040 115996.00 106754.36 92.0 9241.64 106703.40 106703.40 100.0 .00 . ACTIVITY TOTAL 1798334.00 1734889.95 96.5 63444 . 05 1778243.65 1778243 .65 100.0 .00 TAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 93NN 134238.00 69042.81 51.4 65195.19 73453.55 73453.55 100.0 .00 COMMUNITY IMPROVEMENTS 94NN 61300.00 47898.29 75.1 13401 .71 84890.76 84890.76 100.0 .00 PAR(S 95NN 534210.00 497423.22 93.1 36786.75 59292.04 59292.04 100.0 .00 STREET CONSTRC/IMPROVMT 96NN 232611.00 394121.39 169.4 161510.39- 104607.01 104607.01 100.0 .00 ACTIVITY TOTAL 962359.00 1008485.71 104.8 46126.71- 322243.36 322243.36 100.0 .00 TOT A L EXPENDITURES 16320444.50 14812429.89 90.8 1508014.61 14350241 . 13 14350241.13 100.0 .00 EXCESS [REVENUE>EXPENDITURES 147791.25 1936193.58- 1310.1- 2083984.83 1503533.67- 1503533.67- 100.0 .00 TRANSFERS IN FROM OTHER FUNDS .00 2097.00- 2097.00 38508.75- 38508.75- 100.0 .00 TRANSFERS OOT TO OTHER FUNDS .00 .00 .00 18673.28 18673.28 100.0 .00 EXCESS [REVENUE> EXPENDITURE 147791.25 1938290.58- 1311.5- 2086081.83 1523369.14- 1523369.14- 100.0 .00 . 5 GL 1 04:: THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 7/2BI97 REVENUES VERSUS EXPENDITURE 9.05.03 FOR THE PERlOO 7196 THROUGH 6/97 SPECIAL REVENUE FUNDS . CURRENT PERlOO PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FI SCAL YR Y.T'D ~***REVENUES******* SALES TAX 136000.00- 152122.48- 111.9 16122.48 141116.52- 141116.52. 100.0 .00 FINES & FORFEITURES 24500.00- 22506.62- 91.9 1993.38- 24330.57- 24330.57. 100.0 .00 USES OF MONEY AND PROPERTY 76830.00- 98044.39. 127.6 21214_39 89945.79- 89945.79. 100.0 .00 INTERNGOVERNMENTAL FROM STATE 523290.00- 606015.48' 115.8 82725 .48 536724.31' 536724.31- 100.0 .00 INTERGOVERNMENTAL FROM COUNTY 102655.00- 143136.00- 139.4 40481.00 126726.00- 126726.00. 100.0 .00 INTERGOVERNMENTAL FROM FEDERAL 386481.00- 89148.90- 23.1 297332.10- 1908174.78' 1908174.7B- 100.0 .00 CHARGES FOR SERVICES 764600.00- 780801.05- 102.1 16201.05 820879.80. 820879.80- 100.0 .00 OTHER SClIRCES OF REVENUE 130350.00. 311205.00- 238.7 180855.00 568753.12' 568753.12- 100.0 .00 TOTAL REVENUE 2144706.00- 2202979.92- 102.7 58273.92 4216650.89- 4216650.89- 100.0 .00 .......EXPENDITURfSl...... GENERAL GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT .00 .00 .00 244.70 244 .70 100.0 .00 ACTIVITY TOTAL .00 .00 .00 244.70 244.70 100.0 .00 PUBLIC SAFETY: POll CE 66061. 00 62767.56 95.0 3293.44 5899 . 29 5899.29 100.0 .00 TRAFFIC SIGNALS 109327.00 75616.03 69.2 33710.97 85416.04 85416.04 100.0 .00 ACTIVITY TOTAL 175388.00 138383.59 78.9 37004.41 91315.33 91315.33 100.0 .00 TRANSPORT A T ION: . PUBLIC IJORICS 321.00 24.47 7.6 296_53 1.45 1.45 100.0 STREET MAINTENANCE 201960.00 98354.9S 48.7 103605 .05 163324.71 163324.71 100.0 .00 STREET SWEEPING 75600.00 61887.54 81.9 13712.46 69954.11 69954.11 100.0 .00 ACTIVITY TOTAL 277881.00 160266.96 57.7 117614_04 233280.27 233280.27 100.0 .00 HEALTH & llElFARE: WASTE MANAGEMENT 743135_00 718816.69 96.7 24318_31 1183933.08 1183933.08 100.0 .00 ACTIVITY TOTAL 743135.00 718816.69 96.7 24318.31 1183933.08 1183933.08 100.0 .00 CULTURE & lEISURE SERVICES: PARK: MAINTENANCE .00 7154.10 7154.10- .00 .00 .00 ACTIVITY TOTAL .00 7191.46 7191.46- .00 .00 .00 COMMUNITY DEVELOPMENT: PLANNING 1275.00 .00 1275.00 .00 .00 .00 ENGINEERING 98102.00 88980.07 90.7 9121.93 51425.60 51425.60 100.0 .00 ACTIVITY TOTAL 99377.00 88980.07 89.5 10396.93 51425.60 51425.60 100.0 .00 CAPITAL IMPROVEMENT PROJECTS: GENERAL tIP PROJECTS .00 .00 _00 7089.00 7089.00 100.0 .00 COMMUNITY IMPROVEMENTS 194335.00 140171.48 72.1 54163.52 80111.16 80111.16 100.0 .00 PARK:S 553872.00 441865.20 79.8 112006.80 211220.20 211220.20 100.0 .00 STREET CDNSTRUCTION/IMPROVMT 686635.00 331649.62 48.3 354985.38 1967504.82 1967504.82 100.0 .00 ACTIVITY TOTAL 1434842.00 913686.30 63.7 521155.70 2265925.18 2265925 . 18 100.0 .00 TOT A L EXPENDITURES 2730623.00 2027325 .07 74.2 703297.93 3826124.16 3826124.16 100.0 .00 EXCESS rREVENUE>EXPENDITURE 585917.00 175654.85- 30.0- 761571.85 390526.73- 390526.73- 100.0 .00 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 19860.59. 19860.59- 100.0 .00 TRANSFERS OUT TO OTHER FUNDS .00 2097.00 2097.00- 28838.30 28838.30 100.0 .00 EXCESS [REVENUE> EXPENDITURE 585917.00 173557.85. 29.6- 759474.85 381549.02- 381549.02- 100.0 . b Gl104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 7/2!/97 REVENUES VERSUS EXPENDITURE 9.28.47 FOR THE PERIOO 7/96 THROOGH 6/97 . CAP IT Al IMPROVEMENT FUND CURRENT PERIOO' PREVIOUS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ........REVENUE~....... USES OF MONEY AND PROPERTY .00 32293.87- 32293.87 .00 .00 .00 OTHER SOURCES OF REVENUE 870421. 00- 70429.55- 8.1 799991.45- 839611.07- 839611.07- 100.0 .00 TOTAL REVENUE 870421.00- 102723.42- 11.8 767697.58- 839611.07- 839611.07- 100.0 .00 .......EXPENDITURES....... GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 :: PUBLIC SAFETY: TRANSPORT A TI ON: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION .00 3250.00 3250.00- .00 .00 .00 ACTIVITY TOTAL .00 3250.00 3250.00- .00 .00 .00 COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GENERAL tIP PROJECTS 108500.00 9573.75 8.8 98926.25 8021.n 8021.n 100.0 .00 STREET CONSTRUCT I ON/I MPROVMT 789421.00 41.3347.70 56.2 346073.30 707259.92 707259.92 100.0 .00 ACTIVITY .,.OTAL 897921.00 452921.45 50.4 444999 .55 715281.69 715281.69 100.0 .00 . TAL EXPENDITURES 897921.00 456171.45 50.8 441749.55 715281.69 715281.69 100.0 .00 CESS IREVENUE>EXPENO ITURE 27500.00 35344B.03 1285.3 325948.03- 124329.38- 124329.38- 100.0 .00 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 29531.04 29531.04 100.0 .00 EXCESS IREVENUE> EXPEND ITURE 27500.00 35344B.03 1285.3 325948.03- 94798.34- 94798.34- 100.0 .00 . "l Gl104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 7/28/97 REVENUES VERSUS EXPENDITURE 9.35.53 FOR THE PERI 00 7/96 THROUGH 6/97 TRUST/AGENCY FUND . CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y*T-O ~~~~A~~~REVENUES~~~A~~~ SPECIAL BENEFITS ASSESSMENTS .00 236036.28- 236036.28 234629.50* 234629.50- 100.0 .00 USES OF MOHEY AND PROPERTY .00 11496.84- 11496.84 11997.60- 11997.60- 100.0 .00 TOTAL REVENUE .00 247533.12. 247533.12 246627.10- 246627.10- 100.0 .00 -EXPENDITURES-->-- GENERAL GOVERNMENT ACTIVITIES NOH*DEPARTMENTAL .00 232469.50 232469.50- 232584.50 232584.50 100.0 .00 ACTIVITY TOTAL .00 232469.50 232469.50- 232584.50 232584 . 50 100.0 .00 PUBLIC SAFETY: TIWlSPORTATIOH: HEAlTH & ~LFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOTAL EXPENDITURES .00 232469.50 232469.50- 232584.50 232584.50 100.0 .00 EXCESS(REVENUE)EXPENDITURE .00 15063.62- 15063_62 14042.60- 14042.60- 100.0 .00 EXCESS (REVENUE) EXPENDITURE .00 15063.62- 15063.62 14042.60- 14042.60- 100.0 .00 . ~ . GL104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE , 7/28/97 REVENUES VERSUS EXPENDITURE 9.19.09 FOR THE PERIOO 7/96 THROUGH 6/97 . INTERNAL SERVICE FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCEIIT VARIANCE FISCAL YR Y-T-D --REVENUES*-** USES OF HONEY AND PROPERTY 16300.00- 18137.65- 111.3 1837.65 15884.33- 15884.33- 100.0 .00 CHARGES FOR SERVI CES 216315.00- 211049.81 - 97.6 5265.19- 184255.91- 184255.91- 100.0 .00 OTHER SOORCES OF REVENUE 12100.00- 21901.'75- 181.0 9801.'75 29894.08- 29894.08- 100.0 .00 TOTAL REVENUE 244115.00- 251089.21- 102.6 6314.21 230034.32- 230034.32- 100.0 .00 ****-**EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 288082 . 00 121763.11 42.3 166318.89 184660.68 184660.68 100.0 .00 ACTIVITY TOTAL 288082.00 121763.11 42.3 166318.89 184660.68 184660.6B 100.0 .00 PUBLI C SAFETY: TRANSPORT A TI ON: HEALTH & lJELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 288082.00 121654.87 42.2 166421.13 184660 . 68 '84660.68 100.0 .00 EXCES$[REVENUE>EXPENDITURE 43367.00 129434.34- 298.5- 172801 .34 45373.64- 45373.64- 100.0 .00 .$ [REVENUE> EXPEND ITURE 43367.00 129434.34- 298.5- 172801.34 45373.64- 45373.64- 100.0 .00 . 7 Gl1 D4C THE CITY OF DUBLIN STATEMENT SH~ING PAGE '. 7/28/97 REVENUES VERSUS EXPENDITURE 9.24.17 FOR THE PER I 00 7/96 THROUGH 6/97 ENTERPRISE FUNDS . CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D **-**-**REVENUES******* USES OF MONEY AND PROPERTY 1709285.00- 155n43.46- 91.1 151541.54- 1594060.99- 1594060.99- 100.0 .Oc: TOTAL REVENUE 1709285.00- 155n43.46- 91.1 151541.54- 1594060.99- 1594060.99- 100.0 .00 ****-**EXPENDITURES******* GENERAl GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1602005.00 1699147.23 106.1 97142.23- 1388507.17 1388507. 17 100.0 .00 ADMIN SERVICES 4365.00 4194.20 96.1 170.80 6948.40 6948.40 100.0 .00 ACTIVITY TOTAL 1606370. DO 1703341.43 106.0 96971.43- 1395455_57 1395455.57 100.0 .00 PUBLIC SAFETY: DISASTER PREAPREDNESS .00 .00 .00 1226.33 1226.33 100.0 .00 ACTIVITY TOTAL .00 .00 .00 1226.33 1226.33 100.0 .0C TRANSPORTATION: HEALTH & WELFARE: CULTURE & lEISURE SERVICES: RECREATION ADMINISTRATION .00 .00 .00 10125.56 10125.56 100.0 .00 SENIOR CENTER .00 .00 .00 200.00 200.00 100.0 .00 ACTIVITY TOTAL .00 .00 .00 10325.56 10325_56 100.0 .00 COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: . TOT A L EXPENDITURES 1606370.00 1703341.43 106.0 96971.43- 1407007.46 1407007.46 100.0 EXCESS ou:vENUE>EXPEND I TURES 102915.00- 145597.97 141.5- 248512.97- 187053.53- 187053.53- 100.0 .00 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 18673.28- 18673.2S- 100.0 .00 EXCESS [REVENUE> EXPEND I TURE 102915.00- 145597.97 141.5- 248512.97- 205726.81- 205726.81- 100.0 .00 . 10 City of Dublin 1996~97 YTD Revenues and Budget Comparison For the Period Ending June 30, 1997- Unaudited . Total General Fund Revenues -- -- - -------- - ---------- - 104 'Yc 100% Sales Taxes . FY 96/97 . FY 95/96 Property Taxes Transient Occupancy Taxes i i Franchise Taxes I I I j I i Licenses and Permits ! 125% Interest and Rentals . Intergovernmental from State Charges for Services 177% Other Revenues 0% 30% 60% 90% 120% 150% 100% of Year Complete FY 96197 FY 96197 %of FY 95196 % of Total for Budget YTD Actual Budget YTD Actual FY 95196 Property Taxes 4,042,000 ' 3,991,357 99% 3,927,795 100% Sales Taxes 6,480,000 6,570,433 101% 6,760,413 100% Transient Occupancy Taxes 176,000 237,681 135% 198,284 100% Franchise Taxes 709,800 723,385 102% 607,147 100% Licenses and Penn its 873,400 1,095,927 125% 466,199 100% Interest and Rentals 1,259,600 1,374,124 109% 1,268,885 100% Intergovernmental 1,085,650 1,152,249 106% 1,102,496 100% . Charges for Services 1,393,510 1,332,517 96% 1;372,960 100% Other Revenues 152,693 270,950 177% 149,597 100% Total General Fund Revenues 16.172,653 16,748,623 104% 15,853,775 100% 7f3(J197 10:44 1/ g:\monIhfs\ty97\fs.xls City of Dublin 1996~97 YTD Expenses and Budget Comparison For the Period Ending June 30, 1997 ~ Unaudited . FY 96/97 . FY 95/96 Total General Fund Expenses - ----- -------- -------- -~-- --- - - --- ---- - 100% Fire 100% General Government Civic Center Lease Police Other Public Safety 100% Transportation 100% Health and Welfare 111 olc Culture & Community Services Community Development Capital Improv. Projects 0% 30% 60% 100% of Year Complete 90% 120% FY 96197 FY 96197 %of FY 95196 % of Total for Budget YTD Actual Budget YTD Actual FY 95196 General Government 1,766,946 1,625,805 92% 1,496,978 100% Civic Center Lease 1,601,985 1,496,816 93% 1,499,522 100% Police 4,016,642 3,789,028 94% 3,540,388 100% Fire 3,195,294 2,538,830 79% 2,977,719 100% Other Public Safety 256,071 153,694 60% 196,701 100% Transportation 697,277 574,723 82% 691,337 100% Health and Welfare 14,000 15,596 111% 0 0% Culture and Community Services 2,011,537 1,874,562 93% 1,847,110 100% Community Development 1,798,334 1,734,890 96% 1,778,244 100% Capital Improvement Projects 962,359 1,008,486 105% 322,243 100%. Total General Fund Expenses 16,320,445 14,812,430 91% 14,350,241 100% General Fund Operating Expenses 15,358,086 13,803,944 90% 14,027,998 100% 7130197 10:44 /:Z- g:\montllt.\fyll7\ela:eNs.>ds