Loading...
HomeMy WebLinkAbout4.02 FinRpt 2-98 CITY CLERK File # D[ill~~-~[9J . AGENDA STATEMENT CITY COUNCIL MEETING DATE: (April 7, 1998) SUBJECT: Financial Report For the Month of February 1998 ~eport Prepared by: Paul S. Rankin, Assistant City Manager EXHIBITS ATTACHED: 1. Chart - General Fund Revenues and Budget Comparison 2. Chart - General Fund Expenses and Budget Comparison 3. Balance Sheet and Income Statements for the Period Ending February 28, 1998 RECOMMENDATION: 1;JI 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. . Analysis of February 1998 Revenue and Expenditure Report TIrrough the first eight months of the fiscal year the revenue collections and expenses have been tracking similar to the previous fiscal year. It should be noted that 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 Police Services lag since the City is billed on a quarterly basis. A more detailed analysis of General Fund Revenue and Expenditures is shown on the attached graphs and discussed below. 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 1998 approximately 62% of the total budgeted General Fund Revenues compared to approximately 57% in the prior Fiscal Year. Sales Tax is higher than in the same period in the previous year as the State has increased the amount of the monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily related to autos. However, it should be noted that a major portion of the annual sales tax is a . ---~--------------~------------------------------------------~----- COPIES TO: ITEM NO. 4... 2, G :\1\1 OJ\"THFS\FY98\298AG.DOC result of the Christmas retail season, which will be reflected in the sales tax numbers reported on the . March 1998 Financial Statements. Real Property Transfer Taxes have increased over the same period in the prior year due to an increase in assessed value and sales activity, primarily for residential units within the City. In addition, the initi. sale oflarge parcels in Eastern Dublin resulted in an increased amount of Transfer Taxes. As of February the City had collected $112,002, which is approximately 57% of the Fiscal Year 1997/98 budget for this revenue category. In the prior fiscal year the total collected for the entire year was only $138,062. Licenses and Permits are higher than in the same period in the prior year, due to the issuance of several building permits and building plan check fees for several projects in the Eastern Dublin. Typically building permit revenue does not follow an even distribution. Also, the expenditures associated with performing the inspections do not necessarily fall in the same fiscal year as the permit fee is paid. Interest and Rentals are higher than in the same period in the prior year due to a higher cash balance. The current report is somewhat skewed due to adjustments which will be made at the end of the fiscal year. Initially all interest revenue is recorded in the General Fund. At year end a portion of this revenue is allocated to other funds on a pro rata basis. Intergovernmental revenues are higher than in the same period in the prior year due to an increase in the amount of State Motor Vehicle in Lieu Fees collected to date. Charges for services are lower than in the same period in the prior year, primarily related to projected revenues for planning and engineering services associated with increased development activity in Eastern Dublin. The balance of the projected revenues are expected to be collected during the spring construction season. In addition, there is a lag in the posting of revenues directly related to contract engineering. services. The City does not post these revenues until the contractor billing is processed. Based upon the limited information available there were not any areas with significant deviations from the current budget projections, as presented in the midyear financial report. General Fund Expenditures Overall, through the month of February expenditures in the General Fund totaled $9,629,874 and represented approximately 53% of the total budgeted expenditures in the General Fund. Of this amount, a total of $556,497 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 from year to year. In looking at only General Fund Operating Expenditures, the activity through February 1998 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of February 1998, the City had expended 53% of the General Fund Operating Budget, compared to 61% in the prior Fiscal Year. As previously noted there are some timing differences with payments for contract services, which complicate comparisons between one year to the next. The following analysis identifies the basis for significant deviations: Civic Center Lease expenditures to date are 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 tbe 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 approximately 43% of Budget compared to 57% in the prior . Fiscal Year. This was largely due to a difference in the timing of the 2nd quarter police services payment. Culture and Community Services is higher than the same period in the prior year primarily due to timing differences related to water utility services in the Park Maintenance and Aquatics Center activities. Capital Improvement Projects are less than the same period in the prior year, due to expenditures incurred in the prior year on the Dublin Blvd. Widening and Dougherty Hill Slope Repair project. All expenditures to date are within the authorized budget. It is recommended that the City Council receive and file these reports as authorized by Section 41004 of the California Govenunent Code. . . - :?- Exhibit 1 cd' J ~ . City of Dublin 1997-98 YTD Revenues and Budget Comparison For the Period Ending February 28, 1998 - Unaudited I - - - -- - -- - - - - -- --- --- Total General Fund Revenues Property Taxes Sales Taxes Transient Occupancy Taxes .FY 97/98 II FY 96/97 Franchise Taxes I I Licenses and Permits I I Interest and Rentals I Intergovernmental from State 90% . Charges for Services Other Revenues 0% 30% 60% 90% 120% 150% 67% of Year Complete FY 97/98 FY 97/98 %of FY 96/97 % of Total for Budget YTC Actual Budget YTC Actual FY 96/97 Property Taxes 4,482,700 2,386,257 53% 2,225,732 55% Sales Taxes 7,150,000 4,697,126 66% 4,286,379 60% Transient Occupancy Taxes 281,000 150,253 53% 142,921 54% Franchise Taxes 755,000 375,992 50% 345,554 48% Licenses and Permits 1,043,350 937,700 90% 583,702 53% Interest and Rentals 1,428,450 984,710 69% 705,480 51% . Intergovernmental 1,160,620 777,118 67% 729,250 63% Charges for Services 2,175,358 1,137,895 52% 753,116 54% Other Revenues 486,889 229,796 47% 152,310 56% Total General Fund Revenues 18,963,367 11,676,847 62% 9,924,444 57% 3117/98 11;49 g:lmonthfsIfy98lfscolor.xls Exhibit 2 tJtf / ~ City of Dublin 1997-98 YTD Expenses and Budget Comparison For the Period Ending February 28, 1998 - Unaudited Total General Fund Expenses ~~-~ - - --- - - - - - --- - -- - --- Yo 61% Fire .FY 97/98 . FY 96/97 General Government Civic Center Lease Police Other Public Safety Transportation Health and Welfare Culture & Community Services . Community Development Capital Improv. Projects 0% 30% 60% 67% of Year Complete 90%. 120% FY 97/98 FY 97/98 % of FY 96/97 % of Total for Budget YTD Actual Budget YTD Actual FY 96/97 General Government 1,829,529 1,073,001 59% 1,027,379 61% Civic Center Lease 1,599,919 1,493,244 93% 1,496,712 100% Police 4,283,274 1,146,680 27% 1,898,204 50% Fire 3,598,953 2,289,221 64% 1,840,349 67% Other Public Safety 283,202 61,491 22% 60,287 34% Transportation 667,372 348,461 52% 338,217 54% Health and Welfare 17,320 6,215 36% 6,634 43% Culture and Community Services 2,211,775 1,223,512 55% 1,022,385 51% Community Development 2,572,035 1,431,552 56% 1,071,571 58% Capital Improvement Projects 1,212,348 556,497 46% 625,739 61% 61. Total General Fund Expenses 18,275,727 9,629,874 53% 9,387,477 General Fund Operating Expenses 17,063,379 9,073,377 53% 8,761,738 61% 3/17/9811:49 g:\monthfsIfy98\fscolor .xis 3 06 /0 . CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF FEBRUARY 1998 . Prepared by The Finance Deparonent March 10, 1998 . EXHIBIT 3 if. ~ 15. GL102 CITY OF DUBLIN PAGE 1 3/10/98 BALANCE SHEET 14.32.35 FOR THE PERIOD 7/97 THROUGH 2/98 S. GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A l REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONLY --- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30. 1997 ASSETS CASH 7175789.33- 1611084.42 222125.12 4890082.07 58237.85 394259.87- 363914.12- CASH ~ITH FISCAL AGENT 140476.37 140476.37 132608.16 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 33674321.17 33674321.17 25828006.89 RECEIVABlES:TAXES ACCOUNTS (NET) 175302.42 175302.42 306200.31 INTEREST 175681.50 175681.50 ASSESSMENTS RENTS NOTES JUE FROM OTHERS 248261.35 85226.76 333488.11 21596.01 INVENTORY AT COST "REPAID ITEMS 3865.76 3865.76 5347.73 FIXED ASSETS ~MOUNTS TO BE PROVIDED 2018500.00 2018500.00 2090500.00 TOTAL ASSETS 27101642.87 1696311.18 222125.12 4890082.07 2217214.22 36127375.46 28020344.98 ~IAB. FNO BAL. RETND EARNINGS 41687. JEPOSITS FOR PRIVATE DEVElPMNT 578410.56- 578410.56- JEPOSITS FOR AB1600 FEES 5033109.06- 5033109.06- 974823.42- JEPOSITS OTHERS 780133.15- 3547.89- 248261.35- 1031942.39- 673916.40- 'AYABlES:ACCOUNTS 352711.19- 7507.91- 317.65- 360536. 75- 305681.35- INTEREST PAYROLL 44912.90- 44912.90- 43069.32- JUE TO OTHERS 51921.54- 51921.54- 22921.30- lEBT INSTRUMENTS PAYABLE 2136000.00- 2136000.00 - 2208000.00- TOTAL LIABI L TIES 1808089.34- 11055.80- 5281688.06- 2136000.00- 9236833.20- 4645288.15- 'UNO BALANCES 25293553.53- 1685255.38- 222125.12- 391605.99 81214.22- 26890542.26- 23375056.83- TOTAL FUND EeUITY 25293553.53- 1685255.38- 222125.12- 391605.99 81214.22- 26890542.26- 23375056.83- OTAl lIAB/FND BAL. RETD EARNS 27101642.87- 1696311.18- 222125.12- 4890082.07- 2217214.22- 36127375.46- 28020344.98- . GL102 3/1 0/98 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/97 THROUGH 2/98 . INTERNAL SERVICE FUND ENTERPRISE FUNDS FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP ASSETS CASH CASH ~ITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 494024.01 1076.56" 1674517.12 INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES 46896.00 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIDED 350034.76 19616208.27 TOTAL ASSETS 844058.77 21336544.83 .FND BAL, RETNO EARNINGS S FOR PRIVATE OEVELPMNT JEPOSITS OTHERS ?AYABLES:ACCOUNTS INTEREST PAYROLL JUE TO OTHERS JEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES =UND BALANCE :ONTRIBUTIONS ,NVESTMENTS IN FIXED ASSETS ~ETAINED EARNINGS TOTAL FUND EQUITY 15535000.00- 15535000.00- 454889.08- 691654.83- 389169.69- 5109B90.00" 844058.77" 5801544.83" 844058.77- 21336544.83" 4066689.17" 18717381.42- .OTAL LIAB.FNO BAL. RETD EARNS . 4066689. 17 4066689.17 18717381.42 18717381.42 4066689.17" 4066689.17" 18717381.42- 18717381.42- S c-6 /!p PAGE 1 14.32.53 TOT A L S MEMORANDUM ONLY""" CURRENT JUNE 30. 1997 492947.45 1674517.12 46896.00 24032932.20 18717381.42 44964674.19 34252381.42" 34252381.42" 1146543.91- 5499059.69" 4066689.17" 10712292.77" 317072.09 1734321. 88 21045462.27 5327970.26 28424826.50 21592970.26- 21592970.26- 861689.66- 5459961.45- 510205.13- 44964674.19- 28424826.50- 6831856.24- b d6 jt) . GL104C THE CITY OF DUBLIN STATEMENT SHO~ING PAGE 1 3/1 0/98 REVENUES VERSUS EXPENOITURE 13.46.39 FOR THE PERIOD 7/97 THROUGH 2/98 . GENERAL REVENUE FUNO CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30. 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* PROPERTY TAXES 4286000.00- 2274254.87- 53.1 2011745.13- 3920897.29- 2158152.60- 55.0 1762744.69- SALES TAX 7150000.00- 4697125.64- 65.7 2452874.36- 7108598.19- 4286379.37- 60.3 2822218.82- REAL PROPERTY TRANSFERS 196700.00- 112001.67- 56.9 84698.33- 138062.47- 67579.33- 48.9 70483.14- TRANSIENT OCCUPANCY TAX 281000.00- 150253.00- 53.5 130747.00- 267007.09- 142921.09- 53.5 124086.00- FRANCHISE TAXES 755000.00- 375992.39- 49.8 379007.61- 723384.60- 345553.88- 47.8 377830.72- LICENSES & PERMITS 1043350.00- 937700.12- 89.9 105649.88- 1092182.95- 583702.49- 53.4 508480.46- FINES & FORFEITURES 33200.00- 22801.60- 68.7 10398.40- 38492.21- 28234.68- 73.4 10257.53- USES OF MONEY AND PROPERTY 1428450.00- 984710.30- 68.9 443739.70- 1388948.66- 705479.84- 50.8 683468.82- INTERGOVERNMENTAL FROM STATE 1160620.00- m117.55- 67.0 383502.45- 1151275.49- 729250.39- 63.3 422025.10- CHARGES FOR SERVICES 2175358.00- 1137894.92- 52.3 1037463.08- 1386418.59- 753115.67- 54.3 633302.92- OTHER SOURCES OF REVENUE 453689.25- 206994.01- 45.6 246695.24- 223207.32- 124075.73- 55.6 99131.59- TOTAL REVENUE 18963367.25- 11676846.07- 61.6 7286521.18- 17438474.86- 9924445.07- 56.9 7514029.79- *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 9215.00 586.14 6.4 8628.86 27346.97 .00 27346.97 CITY COUNCIL 1010 139834.00 83782.46 59.9 56051. 54 127472.84 88618.78 69.5 38854.06 CITY MANAGER 1020 334487.00 203871. 95 61.0 130615.05 291093.65 183165.78 62.9 107927.87 CITY ATTORNEY 1030 234794.00 118332.22 50.4 116461. 78 201718.85 91930.06 45.6 1097. ADMIN SERVICES 1040 647675.00 388280.23 59.9 259394.77 569247.12 361160.12 63.4 2080 BUILDING MANAGEMENT 1050 315955.00 176604.44 55.9 139350.56 331517.40 179557.46 54.2 151959.94 FACILITY RENTAL 1050-719 1599919.00 1493243.61 93.3 106675.39 1496816.41 1496712.41 100.0 104.00 INSURANCE COST CENTER 1060 146803.00 101167.72 68.9 45635.28 122m.83 116107.85 94.6 6669.98 ELECTIONS COST CENTER 1070 766.00 375.91 49.1 390.09 20511. 92 6838.88 33.3 13673.04 ACTIVITY TOTAL 3429448.00 2566244.68 74.8 863203.32 3188502.99 2524091.34 79.2 664411.65 PUBLIC SAFETY: POll CE 2010 4283274.00 1146680.39 26.8 3136593.61 3794625.12 1898204.07 50.0 1896421. 05 CROSSING GUARDS COST 2020 49048.00 21518.74 43.9 27529.26 40926.26 18899.46 46.2 22026.80 ANIMAL CONTROL 2030 200124.00 29390.00 14.7 170734.00 110514.00 21918.00 19.8 88596.00 DISASTER PREAPREDNESS 2050 34030.00 10581.90 31.1 23448.10 25992.10 19469.16 74.9 6522.94 FIRE SERVICES 2060 3598953.00 2289221.26 63.6 1309731.74 2751796.45 1840349.47 66.9 911446.98 ACTIVITY TOTAL 8165429.00 3497392.29 42.8 4668036.71 6723853.93 3798840.16 56.5 2925013.77 -RANSPORTATION: PUBLI C lJORKS 3010 366732.00 217338.94 59.3 149393.06 319005.00 193545.82 60.7 125459.18 STREET MAINTENANCE 3020 55770.00 2811.86 5.0 52958.14 31593.44 28894.37 91.5 2699.07 STREET TREE MAINTENANCE 3040 47700.00 15335.40 32.1 32364.60 48375.71 20339.15 42.0 28036.56 STREET LANDSCAPE MAINT. 3050 197170.00 112975 .27 57.3 84194.73 230289.60 95438.08 41.4 134851.52 ACTIVITY TOTAL 667372.00 348461.47 52.2 318910.53 629263.75 338217.42 53.7 291046.33 lEALTH & WELFARE: WASTE MANAGEMENT 5020 5320.00 .00 5320.00 3595.87 633.50 17.6 2962.37 CHILD CARE 5030 12000.00 6215.34 51.8 5784.66 12000.00 6000.00 50.0 6000.00 ACTIVITY TOTAL 17320.00 6215.34 35.9 11104.66 15595.87 6633.50 42.5 8962.37 ;ULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 216994.00 108498.50 50.0 108495.50 205874.00 102937.00 50.0 102937.00 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 12500.00 10000.00 80.0 2500.00 HERITAGE CENTER 8012 55930.00 33393.45 59.7 22536.55 54291.08 30379.54 56.0 2391. DUBLIN CEMETERY 8013 16690.00 8666.36 51.9 8023.64 15749.25 8625.91 54.8 712 ? ci /'?J GL104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 2 3/10/98 REVENUES VERSUS EXPENDITURE 13.46.39 FOR THE PERIOD 1/97 THROUGH 2/98 . GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-O PARK MAINTENANCE 8020 589455.00 288952.62 49.0 300502.38 594119.19 199272.51 33.5 394846.68 COMMUNITY CABLE TV 8030 37051.00 28429.00 76.7 8622.00 34256.72 25116.72 73.3 9140.00 RECREATION ADMIN. 8040 256353.00 156164.01 60.9 100188.99 234707.54 150937.52 64.3 83770.02 PLAYGROUNDS 8045 128003.00 75062.32 58.6 52940.68 108257.69 66601.47 61.5 41656.22 SHANNON CENTER 8050 148006.00 93572.83 63.2 54433.17 136660.43 82061.70 60.0 54598.73 PRESCHOOL 8055 54333.00 33648.21 61.9 20684.79 51629.57 32224.93 62.4 19404.64 TEENS PROGRAM 8060 45296.00 18321.42 40.4 26974.58 25445.93 16289.30 64.0 9156.63 ADULT SPORTS 8065 65350.00 34516.64 52.8 30833.36 61034.72 31589.81 51.8 29444.91 YOUTH SPORTS 8066 52406.00 32766.42 62.5 19639.58 39910.77 26927.93 67.5 12982.84 SPECIAL EVENTS 8070 83617.00 37930.07 45.4 45686.93 40133.97 21353.08 53.2 18780.89 SENIOR CENTER 8080 105471.00 60438.19 57.3 45032.81 80392.97 52300.10 65.1 28092.87 RECREATION INSTRUCTION 8090 123555.00 74741.03 60.5 48813.97 89684.89 51554.44 57.5 38130.45 AQUATICS 8100 223265.00 128410.79 57.5 94854.21 215910.85 114212.67 52.9 101698.18 ACTIVITY TOTAL 2211775.00 1223511.86 55.3 988263. 14 2000559.57 1022384.63 51.1 978174.94 COMMUNITY DEVELOPMENT: PLANNING 9010 850121.00 475182.99 55.9 374938.01 659318.79 427351.32 64.8 231967.47 BUILDING SAFETY 9020 593826.00 307956.94 51.9 285869.06 386171. 15 218543.24 56.6 167627.91 ENGINEERING 9030 981875.00 538831.01 54.9 443043.99 684913.30 351564.42 51.3 333348.88 ECONOMIC DEVELOPMENT 9040 146213.00 109581.31 74.9 36631. 69 108155.26 74112.48 68.5 34042.78 ACTIVITY TOTAL 2572035.00 1431552.25 55.7 1140482.75 1838558.50 1071571.46 58.3 766987.04 CAPITAL IMPROVEMENT PROJECTS: ~RAL CIP PROJECTS 93NN 587250.00 188624.06 32.1 398625.94 80137.74 27676.96 34.5 52460.78 UNITY IMPROVEMENTS 94NN 68187.00 3521.49 5.2 64665.51 51771.12 1116.18 2.2 50654.94 PARKS 95NN 196989.00 103124.82 52.4 93864.18 497423.22 412270.98 82.9 85152.24 STREET CONSTRC/IMPROVMT 96NN 359922.00 261226.97 72.6 98695.03 403724.50 184675.34 45.7 219049.16 ACTIVITY TOTAL 1212348.00 556497.34 45.9 655850.66 1033056.58 625739.46 60.6 407317.12 TOT A L EXPENDITURES 18275 727 .00 9629875.23 52.7 8645851.77 15429391.19 9387477.97 60.8 6041913.22 ~XCESS <REVENUE>EXPENDITURES 687640.25- 2046970.84- 297.7 1359330.59 2009083.67- 536967.10- 26.7 1472116.57- TRANSFERS IN FROM OTHER FUNDS .00 10785.46- 10785.46 5077.54- .00 5077.54- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 4211. 16 .00 4211.16 =XCESS <REVENUE> EXPENDITURE 687640.25- 2057756.30- 299.2 1370116.05 2009950.05- 536967.10- 26.7 1472982.95- . if ~/0 GL104C THE CITY OF DUBLIN STATEMENT SHO~ING PAGE 1 3/10/98 REVENUES VERSUS EXPENDITURE 13.59.06 FOR THE PERIOD 7/97 THROUGH 2/98 . SPECIAL ASSESSMENT FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******. SPECIAL BENEFITS ASSESSMENTS 274407.00- 129820.85- 47.3 144586.15- 243986.94- 122270.01- 50.1 121716.93- USES OF MONEY AND PROPERTY 13395.00- .00 13395.00- 18795.26- 1672.49- 8.9 17122.77- JTHER SOURCES OF REVENUE 2000.00- .00 2000.00- .00 .00 .00 TOTAL REVENUE 289802.00- 129820.85- 44.8 159981.15- 262782.20- 123942.50- 47.2 138839.70- *******EXPENDITURES******* ~ENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 ~UBLIC SAFETY: TRFC SIGS/STREET LIGHTING 121705.00 49907.44 41.0 71797.56 103293.98 40567.27 39.3 62726.71 ACTIVITY TOTAL 121705.00 49907.44 41.0 71797.56 103293.98 40567.27 39.3 62726.71 ~RANSPORTATlON: PUBLI C ~ORKS 1300.00 2057.15 158.2 757.15- 4247.66 2080.40 49.0 2167.26 STREET TREE MAINTENANCE 11410.00 2223.53 19.5 9186.47 5697.32 1172.49 20.6 4524.83 STREET LANDSCAPE MAINTENANCE 139420.00 72091.49 51.7 67328.51 138868.81 39581.45 28.5 99287.36 ACTIVITY TOTAL 152130.00 76372.17 50.2 75757.83 148813.79 42834.34 28.8 105979.45 iEALTH & WELFARE: :ULTURE & LEISURE SERVICES: ;OMMUNITY DEVELOPMENT: eEERING 4650.00 3465.00 74.5 1185.00 3185.96 3023.44 94.9 162.52 ACTIVITY TOTAL 4650.00 3465.00 74.5 1185.00 3185.96 3023.44 94.9 162.52 ;APITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 31815.00 7815.00 24.6 24000.00 16488.87 8067.92 48.9 8420.95 STREET CONSTRUCTION/IMPROVMT 47438.00 45000.00 94.9 2438.00 103000.00 103106.75 100.1 106.75- ACTIVITY TOTAL 79253.00 52815.00 66.6 26438.00 119488_87 111174.67 93.0 8314.20 . 0 TAL EXPENDITURES 35m8.00 182559.61 51.0 175178.39 374782.60 197599.72 52.7 177182.88 .XCESS<REVENUE>EXPENDITURE 67936.00 52738.76 77.6 15197.24 112000.40 73657.22 65.8 38343.18 XCESS <REVENUE> EXPENDITURE 67936.00 52738.76 77.6 15197.24 112000.40 73657.22 65.8 38343.18 . (0 ./ /;3 -D <- GL104C THE CITY OF DUBLIN STATEMENT SHO~ING PAGE 1 3/10/98 REVENUES VERSUS EXPENDITURE 14.20.31 FOR THE PERIOD 7/97 THROUGH 2/98 CAPITAL IMPROVEMENT FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D .....***REVENUES******* OTHER SOURCES OF REVENUE 2889412.00- 51796.03- 1.8 2837615.97- 328497.84- 70429.55- 21.4 258068.29- TOTAL REVENUE 2889412.00- 51796.03- 1.8 2837615.97- 328497.84- 70429.55- 21.4 258068.29- **.****EXPENOI TURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & ~ELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: PLANNING 12850.00 .00 12850.00 .00 .00 .00 ACTIVITY TOTAL 12850.00 .00 12850.00 .00 .00 .00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 100000.00 21120.39 21.1 78879.61 12823.75 7228.75 56.4 5595.00 COMMUNITY IMPROVEMENTS 42063.00 10668.58 25.4 31394.42 .00 .00 .00 PARKS 247410.00 30808.68 12.5 216601.32 .00 .00 .00 STREET CONSTRUCTION/IMPROVMT 2515167.00 65312.02 2.6 2449854.98 449732.20 254699.04 56.6 195033.16 ACTIVITY TOTAL 2904640.00 127909.67 4.4 2776730.33 .~ 462555.95 261927.79 56.6 200628.16 TOT A L EXPENDITURES 2917490.00 127909.67 4.4 2789580.33 462555.95 261927.79 56.6 2006. EXCESS<REVENUE>EXPENOITURE 28078.00 76113.64 271.1 48035.64- 134058.11 191498.24 142.8 57440.13- TRANSFERS OUT TO OTHER FUNDS .00 10785.46 10785.46- 1682.54 .00 1682.54 EXCESS <REVENUE> EXPENDITURE 28078.00 86899.10 309.5 58821.10- 135740.65 191498.24 141. 1 55757.59- . II 4 13 ~L 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/10/98 REVENUES VERSUS EXPENDITURE 14.25.57 FOR THE PERIOD 7/97 THROUGH 2/98 . TRUST/AGENCY FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D '*******REVENUES******* ;PECIAL BENEFITS ASSESSMENTS .00 117248.56- 117248.56 236036.28- 117654.79- 49.8 118381.49- JSES OF MONEY AND PROPERTY .00 4089.31- 4089.31 11962.96- 2690.94- 22.5 9272.02- TOTAL REVENUE .00 121337.87- 121337.87 247999.24- 120345.73- 48.5 127653.51- "******EXPENDITURES******* ;ENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL .00 232903.25 232903.25- 232469.50 232469.50 100.0 .00 ACTIVITY TOTAL .00 232903.25 232903.25- 232469.50 232469.50 100.0 .00 'UBL I C SAFETY: RANSPORTATION: lEALTH & IlELFARE: :ULTURE & LEISURE SERVICES: ;OMMUNITY DEVELOPMENT: :APITAL IMPROVEMENT PROJECTS: OTAL EXPENDITURES .00 232903.25 232903.25- 232469.50 232469.50 100.0 .00 :XCESS(REVENUE)EXPENDITURE .00 111565.38 111565.38- 15529.74- 112123.77 722.0- 127653.51- :XCESS (REVENUE) EXPENDITURE .00 111565.38 111565.38- 15529.74- 112123.77 722.0- 127653.51- . . /,~ r j- "P I, < GL104C THE CITY OF DUBLIN STATEMENT SHO~ING PAGE 1 3/10/98 REVENUES VERSUS EXPENDITURE 14.03.49 FOR THE PERIOO 7/97 THROUGH 2/98 INTERNAL SERVICE FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT . VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY 13750.00- .00 13750.00- 18137.65- .00 18137.65- CHARGES FOR SERVICES 243411.00- 161407.90- 66.3 82003.10- 211049.81- 138045.92- 65.4 73003.89- OTHER SOURCES OF REVENUE 500.00- 50.00- 10.0 450.00- 21901.75- 1122.70- 5.1 20779.05- TOTAL REVENUE 257661.00- 161457.90- 62.7 96203.10- 251089.21- 139168.62- 55.4 111920.59- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 266250.00 71860.58 27.0 194389.42 262014.45 96180.16 36.7 165834.29 ACTIVITY TOTAL 266250.00 71860.58 27.0 194389.42 262014.45 96180.16 36.7 165834.29 ;>UBlIC SAFETY: TRANSPORTATION: iEAlTH & ~ElFARE: :ULTURE & lEISURE SERVICES: :OHMUNITY DEVELOPMENT: :APITAl IMPROVEMENT PROJECTS: TOT A l EXPENDITURES 266250.00 71860.58 27.0 194389.42 262014.45 96180.16 36.7 165834.29 ~XCESS<REVENUE>EXPENDITURE 8589.00 89597.32- 1043.2- 98186.32 10925.24 42988.46- 393.5- 53913.70 :XCESS <REVENUE> EXPENDITURE 8589.00 89597.32- 1043.2- 98186.32 10925.24 42988.46- 393.5- 5391. . I '?J ~q) 1/ - GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3{10/98 REVENUES VERSUS EXPENDITURE 14.12.02 FOR THE PERIOD 7/97 THROUGH 2/98 . ENTERPRISE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY 1708264.00- 1545637.44- 90.5 162626.56- 1592321.83- 1556479.27- 97.7 35842.56- TOTAL REVENUE 1708264.00- 1545637.44- 90.5 162626.56- 1592321.83- 1556479.27- 97.7 35842.56- *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1599939.00 1248836.32 78.1 351102.68 1314726.23 1231286.22 93.7 83440.01 ADMIN SERVICES 4260.00 1050.00 24.6 3210.00 4194.20 1000.00 23.8 3194.20 ACTlVI TY TOTAL 1604199.00 1249886.32 77.9 354312.68 1318920.43 1232286.22 93.4 86634.21 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 1604199.00 1249886.32 77.9 354312.68 1318920.43 1232286.22 93.4 86634.21 EXCESS<REVENUE>EXPENDITURES 104065.00- 295751.12- 284.2 191686.12 273401.40- 324193.05- 118.6 50791.65 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 4211.16- .00 4211.16- EXCESS <REVENUE> EXPENDITURE 104065.00- 295751.12- 284.2 191686.12 277612.56- 324193.05- 116.8 46580.49 . .