The URL can be used to link to this page

Home My WebLink About4.04 FinancialRpt 2-97 !,'~'; CITY- 'CLERK File # D~Bl[lj-[5j[Q] :'. AGENDA STATEMENT CITY COUNCIL MEETING DATE: (March 19, 1997) SUBJECT: Financial Report For the Month of February 1997 ~eport Prepared by: Paul S. Rankin, Assistant City Manager Balance Sheet and Income Statements for the Period Ending February 28, 1997 EXHIBITS A TT ACHED: RECOMMENDATION: 1l!'fY Accept and file the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the monthly financial statements for the month of February. Consistent with prior reports the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. The budget changes in the Mid Year report approved at the City Council meeting on February 4, 1997 are included in the February 1997 fmancial report. ':. Analysis of February 1997 Revenue and Expenditure Report " Through the first eight months of the fiscal year the revenue collections and expenses have been tracking similar to the previous fiscal year. During this period total revenue in the General Fund exceeded total General Fund expenditures by $541,250, which was an 8% increase over the same period in the prior year due to the receipt of significant one time credits from PERS as discussed below. As previously noted there is not an even distribution of revenues and expenditures on a monthly ,basis. For example, in the revenue category, the City receives significant property tax revenue in the months of December and April, and the expenditures for major contracts such as as Police Services lag since the City is billed on a quarterly basis. A more detailed analysis of General Fund Revenue and Expenditures follows. General Fund Revenues Total General Fund Revenues collected through February are comparable to what occurred in the first eight months of the previous Fiscal Year. The City had collected through February 1997 approximately 61 % of the total budgeted General Fund Revenues compared to approximately 57% in the prior Fiscal Year. Taxes: Property Taxes to date are comparable to the amount received in the same period in the prior year. Although Sales Tax is tracking at levels ahead of the prior year, a major portion of the sales tax collected . is a result of the Christmas retail sales season. The City will not receive reports of sales for that period .: until March of 1997. At this point in the Fiscal Year the sales of new and used automobiles have ------------------------------------------------------------------- COPIES TO: ITEM NO. 4.4 G\llgenda \llgfinrpt\fy97\0297 ag.dol: remained strong and contributed towards offsetting any declines in other retail sectors. Transient Occupancy Taxes are up from the amount reported for the previous fiscal year due to increased business at the hotel and the collection of taxes on a monthly versus a quarterly basis for the current fiscal year. Licenses and Permits: The largest part of the Licenses & Permits category is Building Permits. As of., February 1997 the City had collected 67% of the amount budgeted for this category. Most of the revenues remaining to be collected relate to major projects which may not occur until the Spring Construction season. This category also includes Business Licenses which have a renewal date of October 1, 1996. As of February 28, 1997 the City had collected $75,246 in Business License Revenue. This was a 2% increase over the amount collected for the same period in the previous Fiscal Year. Charges for Services: Charges for Services to date are 54% of Budget compared to 57% in the prior Fiscal Year. This is due to lower than expected plan checking fee revenue due to delays in the implementation of development projects in East Dublin. Other Revenues:' : Other Revenues received to date are 107% of Budget compared to 79% in the prior Fiscal Year. This 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. General Fund Expenditures Overall, through the month of February expenditures in the General Fund totaled $9,389,570 and represented approximately 58% of the total budgeted expenditures in the General Fund. Of this amount, a total of $628,568 was related to Capital Improvement Projects and the remainder was related to Operating Costs reported in the General Fund. Capital Project expenditures typically do not follow an even distribution due to differences in project timing. '. In looking at only General Fund Operating Expenditures, the activity through February 1997 was below the amounts expended for the same period in the prior Fiscal Year. As of February 28, 1996, the City had expended 57% of the General Fund Operating Budget compared to 62% in the prior Fiscal Year. The following areas contributed to the differences: Civic Center Lease: Expenditures to date are recorded at approximately 93% of the budget compared to 100% in the same period of the prior Fiscal Year. This is due to the fact that the City is required to budget the gross debt service payment, even though part of the payment is offset by funds held by the Trustee. As of the February report the City has recorded the full amount of the debt service payment to be made by the General Fund. Public Safety: Expenditures to date are ,at 51% of Budget compared to 56% in the prior Fiscal Year. This was due largely to a difference in timing of the monthly DRF A payment. 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. Health & Welfare Expenditures to date are at 47% of budget compared to 0% in the prior year as there '. were no expenditures in this category in the prior year. -)- ~..; ,. Culture & Leisure: Expenditures to date are 51 % of Budget compared to 59% in the prior Fiscal Year. This was due in large part to timing differences in the payment of invoices. In the prior fiscal year contract Park Maintenance and Water charges were both processed earlier than in the current year. .:::-", Capital Improvement Projects: : Expenditures to date are 70% of Budget compared to 22% in the prior .,.. Fiscal Year. This is due to completion of a significant portion of work on the projects relating to the Dougherty Hills Slope Repair and the Annual Street Overlay during the first half of Fiscal Year 1996-97. I t is recommended that the City Council receive and file these reports as authorized by Section 41004 of the California Government Code. :;',. ,.:,. -:3- 7, . . . CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF FEBRUARY 1997 Prepared by The Finance Department March 10, 1997 I EXHIBIT 1 City of Dublin 1996-97 YTD Revenues and Budget Comparison For the Period Ending February 28, 1997- Unaudited Total General Fund Revenues ~~~~~~~~ 61% 7% Transient Occupancy Taxes Property Taxes Sales Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Senices Other Revenues 0% 20% 40% 60% 67% of Year Complete 80% 100% . .FY 96/97 .FY 95/96 ,'. 107% FY 96/97 FY 96/97 %of FY 95/96 % of Totalfor " Budget YTO Actual Budget YTO Actual FY 95/96 Property Taxes 4,042,000 2,225,732 55% 2,187,135 56% Sales Taxes 6,480,000 4,286,379 66% 4,090,838 61% Transient Occupancy Taxes 176,000 142.921 81% 91.357 46% Franchise Taxes 709,800 345,554 49% 247,633 41% Licenses and Pennits 873,400 583,702 67% 250,063 54% Interest and Rentals 1,259,600 705,092 56% 539,835 43% Intergovernmental from State 1,085,650 729,250 67% 669,284 61% .. Charges for Services 1,393,510 750,928 54% 786,325 57% ,. Other Revenues 150,660 161,262 107% 117,893 79% .' Total General Fund Revenues 16,170,620 9,930,820 61% 8,980,363 57% 3/10/97 15:07 g:\fred\Iy97\exceNs.xls ).. City of Dublin 1996-97 YTD Expenses and Budget Comparison For the Period Ending February 28, 1997 - Unaudited General Government Civic Center Lease 100% . . FY 96/97 . FY 95/96 Other Public Safety Transportation Health and Welfare . Culture & Community Services Community Development Capital Improv. Projects 70% 0% 20% 40% 60% 67% of Year Complete 80% 100% FY 96/97 FY 96/97 % of FY 95/96 % of Total for Budget YTD Actual Budget YTD Actual FY 95/96 General Government 1,724,111 1,028,769 60% 913,355 61% Civic Center Lease 1,601,985 1,496,713 93% 1,499,418 100% Pollee 4,016,642 1,898,204 47% 1,792,494 51% Fire 3,195,294 1,840,349 58% 1,960,152 66% other Public Safety 256,071 60,286 24% 26,150 13% Transportation 697,277 338,217 49% 318,808 46% Health and Welfare 14,000 6,634 47% 0 0% Culture and Community Services 2,000,640 1,020,259 51% 1,087,913 59% Community Development 1,798,334 1,071,571 60% 1,045,217 59% .' Capital Improvement Projects 895,908 628,568 70% 69,586 22% Total General Fund Expenses 16,200,262 9,389,570 58% 8,713,093 61% 3/1019715:16 g:lfred\ly97\eXceNs.xl. j Gl102 3/06!97 ASSETS CASH CASH ~ITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABlES:TAXES ACCOONTS (NET) INTEREST ASSESSMENTS RENTS NOTES JUE FROM OTHERS INVENTORY AT COST ~REPAID ITEMS 'IXED ASSETS \MOUNTS TO BE PROVIDED TOTAL ASSETS ,lAB, FND BAl, RETND EARNINGS 'EPOSITS FOR PRIVATE DEVElPMNT JEPOSITS FOR AB1600 FEES :EPOSITS OTHERS 'AYABLES:ACCOONTS INTEREST PAYROLL UE TO OTHERS EBT INSTRUMENTS PAYABLE TOTAL LIABI l TIES JND BALANCES TOTAL FUND EQUITY CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/96 THROUGH 2/97 GENERAL REVENUE FUNDS SPECIAL REVENUE FUNDS SPECIAL ASSESSMENT FUNDS CAPITAL IMPROVEMENT FUNDS TRUST! AGENCY FUND 3018145.10- 1655573.67 313929.26 615648.94 50017.93 132608.16 25828006.89 169903.57 37760.05 98536.69 21596.01 5347.73 2090500.00 22985113.09 1714929.73 313929.26 714185.63 2273126.09 401391.61- 974823.42' 566379.71- 98536.69- 184403.30- 120555.85- 722.20- 43069.32- 22771.30- 2208000.00' 1218015.24- 120555.85' 722.20- 1073360.11- 2208000.00- 21767097.85- 1594373.88- 313207.06- 359174.48 65126.09- 21767097.85- 1594373.88- 313207.06- 359174.48 65126.09- JTAL lIAB,FND BAl, RETD EARNS 22985113.09- 1714929.73- 'I 313929.26- 714185.63- 2273126.09- PAGE 1 15.49.13 TOTALS. --- MEMORANDUM ONLY" CURRENT JUNE 30, 1996 382975 .30- 132608. 16 475390.25- 125579.24 25828006.89 2269764 7 .50 306200.31 437477.67 21596.01 5967.43 5347.73 6292.67 2090500.00 2090500.00 28001283.80 24888074 . 26 401391.61- 149544:::,':'. 974823.42- 291271.48: 664916.40- 631234.20- .' : 305681.35- 253507.28- ,', 43069.32- 1530.50 " " 22771.30- 345.00- ,. 2208000.00- 2208000.00- .. 4620653.40' 3532372.16- 23380630.40- 21355702.10- " '., 23380630.40- 21355702.10- .-:: 28001283.80- 24888074.26- .. .-;: -:". .'. " ' . - . - . . . . . . .-. . .. - . . - . . - .. .' GL102 3/06/97 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7196 THROUGH 2/97 .' INTERNAL SERVICE FUND ASSETS CASH CASH ~ITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 430989.05 INVESTMENTS AT COST RECEIVABLES:TAXES ACCOONTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIDED 451187.86 TOTAL ASSETS .~ND BAL, RETND EARNINGS D . ,~.TS 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 882176.91 532105.46- 350071.45- 882176.91- ENTERPRISE FUNDS 1011.14- 1733737.80 20084069.28 21816795.94 16265000.00- 16265000.00- 441905.94- 5109890.00- 882176.91- 21816795.94- 5551795.94- TOTAL LIAB,FND BAL, RETD EARNS . 5 FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOONTS ACCOUNT GROUP 510205.13 510205.13 510205.13- 510205.13- 5327970.26 5327970_26 5327970.26- 5327970.26- 510205.13- 5327970.26- PAGE 1 15.49.28 TOT A L S MEMORANDUM ONLY --- CURRENT JUNE 30, 1996 429977.91 1733737.80 21045462.27 5327970.26 28537148.24 21592970.26- 21592970.26- 974011.40- 5459961.45- 510205.13- 6944177.98- 321155.65 1757988.45 21361185.01 2855403.88 26295732.99 19825403.88- 19825403.88- 630091.06- 5347612.75- 492625.30- 28537148.24- 26295732.99- 6470329.11- l104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/06/97 REVENUES VERSUS EXPENDITURE 14.39.42 FOR THE PERloo 7196 THROUGH 2/97 GENERAL REVENUE FUND .:. CURRENT PERIoo PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D '.*****REVENUES*.****. ~OPERTY TAXES 3968400.00- 2158152.60- 54.4 1810247.40- 3867613 .84- 2150485.68- 55.6 1717128.16- _lES TAX 6480000.00- 4286379.37- 66.1 2193620.63- 6760413.09- 4090838.43- 60.5 2669574.66- :AL PROPERTY TRANSfERS 73600.00- 67579.33- 91.8 6020.67- 60181.18- 36649.68- 60.9 23531.50- :ANSIENT OCCUPANCY TAX 176000.00- 142921.09- 81.2 33078.91- 195284.00- 91357.00- 46.1 106927.00- "ANCHISE TAXES 709800.00- 345553.88- 48.7 364246.12- 607146.84- 247632.35- 40.8 359514.49- CENSES & PERMITS 873400.00- 583702.49- 66.8 289697.51- 466195.72- 250063.14- 53.6 216135.58- NES & fORFEITURES 36000.00- 28384.68- 78.8 7615.32- 38792.80- 25653.76- 66.1 13139.04- :ES OF MONEY AND PROPERTY 1259600.00- 705091.90- 56.0 554508.10- 1268885.15- 539834.87- 42.5 729050.28- TERGOVERNMENTAL FROM STATE 1085650.00- 729250.39- 67.2 356399.61- 1102495.65 - 669283.95- 60.7 433211.70- ARGES FOR SERVICES 1393510.00- 750928.45- 53.9 642581.55- 1372959.58- 786324.66- 57.3 586634.92- HER SOURCES OF REVENUE 114659.75- 132877.13- 115.9 18217.38 110803.95- 92239.41- 83.2 18564.54- TOTAL REVENUE 16170619.75- 9930821.31- 61.4 6239798.44- 15853774.80- 8980362.93- 56.6 6873411. 87, *.***EXPENDI TURES....... NERAl GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 75051.00 .00 75051.00 .00 12.50 12.50- CITY COUNCIL 1010 128264.00 88618.78 69.1 39645.22 127389.95 83845.23 65.8 43544.72 CITY MNAGER 1020 297973.00 183165.78 61.5 114807.22 275833.29 169501.39 61.5 106331. 90 CITY ATTORNEY 1030 154181.00 91930.06 59.6 62250.94 161933.22 68915.74 42.6 93017.48 ~DMIN SERVICES 1040 607227.00 362550.12 59.7 244676.88 495172.80 287366.79 58.0 ~~~~::~:. ,'. 3UILDING MNAGEMENT 1050 321500.00 179557.46 55.8 141942.54 334374.72 207078.07 61.9 ~.' .' ,ACILITY RENTAL 1050-719 1601985.00 1496712.41 93.4 105272.59 1499521.58 1499417.58 100.0 104.00 INSURANCE COST CENTER 1060 133550.00 116107.85 86.9 17442.15 101710.52 96072.30 94.5 5638.22 oLECTIONS COST CENTER 1070 6365.00 6838.88 107.4 473.88- 563.52 563.52 100.0 .00 .' ACTIVITY TOTAL 3326096.00 2525481.34 75.9 800614.66 2996499.60 2412m.12 80.5 583726.48 3LIC SAFETY: 'OLI CE 2010 4016642.00 1898204.07 47.3 2118437.93 3540387.58 1792494.06 50.6 1747893.52 :ROSSING GUARDS COST 2020 43000.00 18899.46 44.0 24100.54 43292.88 22778.28 52.6 20514.60 \NIML CONTROL 2030 180286.00 21918.00 12.2 158368.00 126363.14 .00 126363.14 lISASTER PREAPREDNESS 2050 32785.00 19469.16 59.4 13315.84 27045.45 3371. 80 12.5 23673.65 'IRE SERVICES JPA 2060 3195294.00 1840349.47 57.6 1354944.53 29m19.09 1960152.00 65.8 1017567.09 ACTIVITY TOTAL 7468007.00 3798840.16 50.9 3669166.84 6714808.14 3778796.14 56.3 2936012.00 ,NSPORTATION: 'UBLI C \JORKS 3010 320887.00 193545.82 60.3 127341.18 304830.22 184452.14 60.5 120378.08 ;TREET MINTENANCE 3020 128200.00 28894.37 22.5 99305.63 140949.59 458.81 .3 140490.78 :TREET TREE MAINTENANCE 3040 48580.00 20339.15 41.9 28240.85 48192.39 17278.41 35.9 30913.98 ;TREET LANDSCAPE MAINT. 3050 199610.00 95438.08 47.8 104171. 92 197364.32 116618.86 59.1 80745.46 ACTIVITY TOTAL 697277.00 338217.42 48.5 359059.58 691336.52 318808.22 46.1 372528.30 ,LTH & \JELFARE: IASTE MNAGEMENT 5020 2000.00 633.50 31.7 1366.50 .00 .00 .00 :HILD CARE 5030 12000.00 6000.00 50.0 6000.00 .00 .00 .00 ACTIVITY TOTAL 14000.00 6633.50 47.4 7366.50 .00 .00 .00 TURE & lEISURE SERVICES: ,I BRARY SERVI CES 8010 205874.00 102937.00 50.0 102937.00 194188.00 97094.00 50.0 97094.00 :ULTURAL ACTIVITIES 8011 12500.00 10000.00 80.0 2500.00 17500.00 10000.00 57.1 7500.00 IERITAGE CENTER 8012 51960.00 30379.54 58.5 21580.46 41860.33 23771.58 56.8 18088.75 'UBLl N CEMETERY 8013 17160.00 7875.91 45.9 9284.09 16075.33 10540.94 65.6 5534.-::,. , GL1 O4C THE CITY OF DUBLIN STATEMENT SHOYING PAGE 2 3/06/97 REVENUES VERSUS EXPENDITURE 14.39.42 FOR THE PERIOO 7/96 THROUGH 2/97 . GENERAL REVENUE FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FI SCAL YR Y-T-D PARK MAINTENANCE 8020 573868.00 199272.51 34.7 374595.49 554536.91 335057.67 60.4 219479_24 COHHUNITY CABLE TV 8030 33916.00 25116.72 74.1 8799.28 23736.00 21236.00 89.5 2500.00 RECREATION ADHIN. 8040 242784.00 149561. 77 61.6 93222.23 190175.44 114382.26 60.1 75793.18 PLAYGROUNDS 8045 109528.00 66601.47 60.8 42926.53 99908.83 62460.87 62.5 37447.96 SHANNON CENTER 8050 134604 .00 82061. 70 61.0 52542.30 128665.35 76853.42 59.7 51811.93 PRESCHOOL 8055 52070.00 32224.93 61.9 19845.07 48241.56 2m 1. 24 57.5 20510.32 TEENS PROGRAM 8060 35294.00 16289.30 46.2 19004.70 29512.30 18432.25 62.5 11080.05 ADULT SPORTS 8065 62718.00 31589.81 50.4 31128.19 59974.79 34532.56 57.6 25442.23 YOOTH SPORTS 8066 37176.00 26927.93 72.4 10248.07 33593.09 22647.53 67.4 10945.56 SPECIAL EVENTS 8070 38930.00 21353.08 54.8 17576.92 33694.49 13518.97 40.1 20175.52 SEN I OR CENTER 8080 112578.00 52300.10 46.5 60277.90 101733.54 63024.32 62.0 38709.22 RECREATION INSTRUCTION 8090 80763.00 51554.44 63_8 29208.56 76940.68 44298.41 57.6 32642.27 AQUATICS 8100 198917.00 114212.67 57.4 84704.33 196m.22 112330.85 57.1 84442.37 ACTIVITY TOTAL 2000640.00 1020258.88 51.0 980381.12 1847109.86 1087912.87 58.9 759196.99 C~JNITY DEVELOPMENT: PLANNING 9010 732994.00 427351.32 58.3 305642.68 838445.66 476487.63 56.8 361958.03 BUILDING SAFETY 9020 385919.00 218543.24 56.6 167375.76 263771.36 151599.46 57.5 112171.90 ENGINEERING 9030 563425.00 351564.42 62.4 211860.58 569323.23 348776.67 61.3 220546.56 ECONOMIC DEVELOPMENT 9040 115996.00 74112.48 63.9 41883.52 106703.40 68353.47 64.1 38349.93 ACTIVITY TOTAL 1798334.00 1071571.46 59.6 726762.54 1778243.65 1045217.23 58.8 733026.42 ~L IMPROVEMENT PROJECTS: RAL CIP PROJECTS 93NN 116113.00 30505.38 26.3 85607.62 73453.55 16800.95 22.9 56652.60 w~."'UN ITY IMPROVEMENT S 94NN 61300.00 1116.18 1.8 60183.82 84890.76 52508.31 61.9 32382.45 PARKS 95NN 488645.00 412270.98 84.4 76374.02 59292.04 276.48 .5 59015.56 STREET CONSTRC/IMPROVMT 96NN 229850.00 184675.34 80.3 45174.66 104607.01 .00 104607.01 ACTIVITY TOTAL 895908.00 628567.88 70.2 267340.12 322243.36 69585.74 21.6 252657.62 T D TAL EXPENDITURES 16200262.00 9389570.64 58.0 6810691.36 14350241.13 8713093.32 60.7 5637147.81 EXCESS [REVENUE>EXPENDITURES 29642.25 541250.67- 1825.9- 570892.92 1503533.67- 267269.61- 17.8 1236264.06- TRANSFERS IN FROM OTHER FUNDS .00 .00 .DO 38508.75- 1015.00- 2.6 37493.75- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 18673.28 .00 18673.28 EXCESS [REVENUE> EXPENDITURE 29642.25 541250.67- 1825.9- 570892.92 1523369.14- 268284.61 - 17.6 1255084.53- . '1 Gl104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 3/06/97 REVENUES VERSUS EXPENDITURE 14.43.19 FOR THE PERIOO 7/96 THROOGH 2/97 SPECIAL REVENUE FUNDS . CURRENT PERlOO PREVIOOS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* SALES TAX 136000. 00- 100869.10' 74.2 35130.90- 141116.52- 90637. 19- 64.2 50479.33- FINES & FORFEITURES 24500.00- 13748.04- 56.1 10751.96- 24330.57- 16195.15- 66.6 8135.42- USES OF MONEY AND PROPERTY 76830.00' .00 76830.00- 89945.79- .00 89945.79- INTERNGOVERNMENTAl FROM STATE 523290.00- 368996.95- 70.5 154293.05- 536724.31- 307478.49- 57.3 229245.82- INTERGOVERNMENTAL FROM COUNTY 102655.00- 82630.00- 80.5 20025.00- 126726.00- 97483.00- 76.9 29243.00- INTERGOVERNMENTAL FROM FEDERAL 369757.00- .00 369757.00- 1908174.78. 800624.51- 42.0 1107550.27- :HARGES FOR SERVICES 764600.00- 398719.32- 52.1 365880.68- 820879.80- 417178.19- 50.8 403701.61- OTHER SOORCES OF REVENUE 130350.00- 36549.00- 28.0 93801.00- 568753.12- 566875.59- 99.7 1877.53- TOTAL REVENUE 2127982.00- 1001512.41- 47.1 1126469.59- 4216650.89- 2296472.12- 54.5 1920178.77- '******EXPENDITURES******* ,ENERAl GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT .00 .00 .00 244.70 .00 244.70 ACTIVITY TOTAL .00 .00 .00 244.70 .00 244 . 70 'UBlIC SAFETY: POll CE 66061. 00 11732.43 17.8 54328.57 5899.29 1635.26 27.7 4264 . 03 TRAFF I C SIGNALS 109327.00 34724.83 31.8 74602.17 85416.04 37354.40 43.7 48061.64 ACTIVITY TOTAL 175388.00 46457.26 26.5 128930.74 91315.33 38989.66 42.7 52325.67 RANSPORTATlON: 107414:". PUBLIC WORKS 321.00 .00 321.00 1.45 1.45 100.0 STREET MAINTENANCE 198960.00 55682.13 28.0 143277.87 163324 .71 55909.94 34.2 STREET SIlEEPING 75600.00 38590.38 51.0 37009.62 69954. 11 41215.16 58.9 28738.95 ACTIVITY TOTAL 274881.00 94272.51 34.3 180608.49 233280.27 97126.55 41.6 136153.72 ::AlTH & IlElFARE: IlASTE MANAGEMENT 743135.00 372093.25 50.1 371041. 75 1183933.08 347941.44 29.4 835991.64 ACTIVITY TOTAL 743135.00 372093.25 50.1 371041. 75 1183933.08 347941. 44 29.4 835991. 64 JlTURE & lEISURE SERVICES: JMMUNITY DEVELOPMENT: PLANNING 1275.00 .00 1275.00 .00 .00 .00 ENGINEERING 98102.00 23823.42 24.3 74278.58 51425.60 20293 .70 39.5 31131.90 ACTIVITY TOTAL 99377.00 23823 . 42 24.0 75553.58 51425.60 20293.70 39.5 31131.90 ,PITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS .00 .00 .00 7089.00 .00 7089.00 COMMUNITY IMPROVEMENTS 168510.00 5968.10 3.5 162541. 90 80111.16 46517.16 58.1 33594.00 PARKS 537148.00 24109.07 4.5 513038.93 211220.20 201344.42 95.3 9875 . 78 STREET CONSTRUCT I ON/I MPROVMT 620540.00 273685 .85 44.1 346854. 15 1967504.82 919280.01 46.7 1048224.81 ACTIVITY TOTAL 1326198.00 303763.02 22.9 1022434.98 2265925. 18 1167141.59 51.5 1098783.59 o TAL EXPENDITURES 2618979.00 840409.46 32.1 1778569.54 3826124.16 1671492.94 43.7 2154631.22 :ESS rREVENUE>EXPENDITURE 490997.00 161102.95- 32.8- 652099.95 390526.73- 624979.18- 160.0 234452.45 ~NSFERS IN FROM OTHER FUNDS .00 .00 .00 19860.59- 14897.00- 75.0 4963.59- ~NSFERS OOT TO OTHER FUNDS .00 .00 .00 28838.30 15912.00 55.2 12926.30 " :ESS [REVENUE> EXPENDITURE 490997.00 161102.95- 32.8. 652099.95 381549.02- 623964.18- 163.5 242415.16 </ ,'. GL1 04C THE CITY OF OUBLIN STATEMENT SHOWING PAGE 1 3[06[97 REVENUES VERSUS EXPENDITURE 15.00.51 FOR THE PER I 00 7[96 THROUGH 2[97 . SPECIAL ASSESSMENT FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* 5PECIAL BENEFITS ASSESSMENTS 234660.00- 122270.01- 52.1 112389.99- 318115.75- 150936.34- 47.4 167179.41- JSES OF MONEY AND PROPERTY 20280.00- 1672.49- 8.2 18607.51- 17813.47- .00 17813.47- JTHER SOURCES OF REVENUE 4000.00- .00 4000,00- .00 .00 .00 TOTAL REVENUE 258940.00- 123942.50- 47.9 134997.50- 335929.22- 150936.34- 44.9 184992.88- '******EXPENDI TURES******* 3ENERAl GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 ,00 .00 .00 .00 'UBLl C SAFETY: TRFC SIGS[STREET lIGHTING 130569.00 40567.27 31.1 90001.73 180611.18 112716.70 62.4 67894.48 ACTIVITY TOTAL 130569.00 40567.27 31.1 90001. 73 180611.18 112716.70 62.4 67894.48 ,RANSPOR T A Tl ON : PUBLl C \JORKS 7688.00 2080.40 27.1 5607.60 3947.86 2019.60 51.2 1928.26 STREET TREE MAINTENANCE 8470.00 1172.49 13.8 7297.51 8867.39 3254.98 36.7 5612,41 STREET LANDSCAPE MAINTENANCE 1 13800. DO 39581.45 34.8 74218,55 105578,03 61127.13 57.9 44450.90 ACTIVITY TOTAL 129958.00 42834.34 33.0 87123.66 118393.28 66401. 71 56,1 51991.57 ~EAlTH & WELFARE: :UlTURE & LEISURE SERVICES: :. TY DEVELOPMENT: EERING 3560.00 3023.44 84.9 536.56 3085.26 3027.96 98.1 57.30 '. ,,' ACTIVITY TOTAL 3560.00 3023.44 84.9 536.56 3085.26 3027.96 98,1 57.30 :APITAl IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 10000.00 8067.92 80.7 1932.08 27505.63 25461.64 92.6 2043.99 STREET CONSTRUCTION[IMPROVMT 103000.00 103106.75 100.1 106.75- 7649.54 636.53 8.3 7013.01 ACTIVITY TOTAL 1 13000.00 111174.67 98.4 1825.33 35155.17 26098.17 74.2 9057.00 , 0 TAL EXPENDITURES 377087.00 197599.72 52.4 179487.28 337244,89 208244.54 61.7 129000,35 :XCESS[REVENUE>EXPENDITURE 118147,00 73657.22 62.3 44489.78 1315.67 57308.20 4355.8 55992.53- ,XCESS [REVENUE> EXPENDITURE 118147.00 73657.22 62.3 44489.78 1315.67 57308,20 4355.8 55992.53- . q L104C THE CITY OF DUBLIN STATEMENT SHOUING PAGE 1 3/06/97 REVENUES VERSUS EXPENDITURE 15.24.27 FOR THE PERIOD 7/96 THROUGH 2/97 CAP IT AL IMPROVEMENT FUND ". CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D '******REVENUES******* "HER SOURCES OF REVENUE 870421.00- 70429.55' 8.1 799991.45- 839611.07- .00 839611.07- TOTAL REVENUE 870421.00- 70429.55' 8.1 799991.45- 839611.07- .00 839611. 07- .*****EXPENDI TURES******* NERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 'BLl C SAFETY: ANSPORTATION: ALTH & IJELFARE: LTURE & LEISURE SERVICES: " ~MUNITY DEVELOPMENT: PITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 108500.00 5938.75 5.5 102561.25 8021.77 4218.00 52.6 3803.77 STREET CONSTRUCTION/IMPROVMT 789421.00 254699.04 32.3 534721.96 707259.92 263459.87 37.3 443800.05 ACTIVITY TOTAL 897921.00 260637.79 29.0 63TZ83.21 715281.69 267677.87 37.4 447603.82 ~ TAL EXPENDITURES 897921.00 260637.79 29.0 637283.21 715281.69 267677 .87 37.4 447603.82 :ESS[REVENUE>EXPENDITURE 27500.00 190208.24 691.7 162708.24- 124329.38' 267677.87 215.3' 392007.25- ~NSFERS OUT TO OTHER FUNDS .00 .00 .00 29531.04 .00 29531.04 362476.~:~. :ESS [REVENUE> EXPENDITURE 27SDO.00 190208.24 691.7 162708.24- 94798.34. 267677 .87 282.4- .'. . /D ,;,;. j' GL1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/06/97 REVENUES VERSUS EXPENDITURE 15.29.10 FOR THE PERIOO 7/96 THROUGH 2/97 . TRUST/AGENCY FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS .00 117654.79- 117654.79 234629.50- 117314.75- 50.0 117314.75- USES OF MONEY AND PROPERTY .00 2690.94- 2690.94 11997.60- 2675.55- 22.3 9322.05- TOTAL REVENUE .00 120345.73- 120345.73 246627.10- 119990.30- 48.7 126636.80- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-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: TRANSPORTATION: HEALTH & WELFARE: 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 112123.77 112123.77- 14042.60- 112594.20 801.8- 126636.80- EXCESS (REVENUE) EXPENDITURE .00 112123.77 112123.77- 14042.60- 112594.20 801.8- 126636.80- . . /I GL104C 3/06/97 '***--REVENUES******* ISES OF MONEY AND PROPERTY HARGES FOR SERVICES THER SOURCES OF REVENUE TOTAL REVENUE *...........EXPENDI TURES******* :NERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL JBLlC SAFETY: ~NSPORTATlON: :ALTH & UELFARE: JLTURE & LEISURE SERVICES: ~NITY DEVELOPMENT: ~PITAL IMPROVEMENT PROJECTS: o TAL EXPENDITURES {CESS[REVENUE>EXPENDITURE :CESS [REVENUE> EXPEND ITURE /).. THE CITY OF DUBLIN STATEMENT SHOUING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 2/97 BUDGET 16300.00- 216315.00- 12100.00- 244715.00- 288082.00 288082.00 288082.00 43367.00 43367.00 INTERNAL SERVICE CURRENT PERIOO ACTUAL PERCENT .00 250945.92- 1122.70- 252068.62- 96180.16 96180.16 116.0 9.3 103.0 33.4 33.4 96180.16 33.4 155888.46- 359.5- FUND VARIANCE 16300.00- 34630.92 10977.30- 7353.62 191901.84 191901.84 191901.84 199255.46 155888.46- 359.5- 199255.46 PAGE 1 15.12.55 '. ACTUAL FI SCAL YR PREVIOUS YEAR ENDING JUNE 30, 1996 ACTUAL PERCENT VARIANCE Y-T-D 15884.33- 184255.91- 29894.08- 230034.32- 184660.68 184660.68 184660.68 45373.64- 45373.64- .00 123050.17- 29505.92- 152556.09- 119006.18 119006.18 119006.18 64.4 33549.91- 73.9 33549.91- 73.9 66.8 98.7 66.3 64.4 64.4 15884.33- 61205.74- 388.16- 77478.23- 65654.50 65654.50 65654.50 11823.73- 11823.~. ...~ ., '. GL1 04C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 3/06/97 REVENUES VERSUS EXPENDITURE 15.1B.43 FOR THE PERIOO 7/96 THROUGH 2/97 . ENTERPRISE FUNDS CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* JSES OF MONEY AND PROPERTY 17092B5.00- 1555B95.19- 91.0 153389.81- 1594060.99- 1558500.02- 97.8 35560.97- JTHER SOURCES OF REVENUE .00 5.82- 5.82 .00 .00 .00 TOTAL REVENUE 1709285.00- 1555901.01- 91.0 153383.99- 1594060.99- 1558500.02- 97.8 35560.97- *******EXPENDITURES******* 3ENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1602005.00 1231286.22 76.9 370718.78 1388507. 17 1222327.25 88.0 166179.92 ADMIN SERVICES 4365.00 1000.00 22.9 3365.00 6948.40 3254.20 46.8 3694.20 ACTIVITY TOTAL 1606370.00 1232286.22 76.7 374083.78 1395455.57 1225581.45 87.8 169874.12 "UBLlC SAFETY: DISASTER PREAPREDNESS .00 .00 .00 1226.33 .00 1226.33 ACTIVITY TOTAL .00 .00 .00 1226.33 .00 1226.33 TRANSPORT A TI ON: iEALTH & UELFARE: :ULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION .00 .00 .00 10125.56 5820.26 57.5 4305.30 SENIOR CENTER .00 .00 .00 200.00 200.00 100.0 .00 ACTIVITY TOTAL .00 .00 .00 10325.56 6020.26 58.3 4305.30 :~TY DEVELOPMENT: : IMPROVEMENT PROJECTS: , ~ . ~ L EXPENDITURES 1606370.00 1232286.22 76.7 374083.78 1407007.46 1231754.62 87.5 175252.84 :XCESS[REVENUE>EXPENDITURES 102915.00- 323614.79- 314.4 220699.79 187053.53- 326745.40- 174.7 139691.87 "RANSFERS IN FROM OTHER FUNDS .00 .00 .00 18673.28- .00 18673.28- :XCESS [REVENUE> EXPENDITURE 102915.00- 323614_79- 314.4 220699.79 205726.81- 326745.40- 158.8 121018.59 . /2>