Loading...
HomeMy WebLinkAboutItem 4.07 FinRpt 12/98-1/99 . CITY CLERK File # DraJ~[Q]-[tfl[Q] AGENDA STATEMENT CITY COUNCIL MEETING DATE: (February 16, 1999) SUBJECT: Financial Reports for December 1998 and January 1999 ~eport Prepared by: Paul S. Rankin, Assistant City Manager ATTACHMENTS: 1. Comparison of General Fund Revenue Collections In Current Period To Previous Year and Budget 2. Comparison of General Fund Revenue Expenditures In Current Period To Previous Year and Budget 3. Balance Sheets and Income Statements for the Periods Ending December 31, 1998 and January 31, 1999 RECOMMENDA TION: / qf Accept and file the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the financial statements for the months of December 1998 and January 1999. 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. Although two months of data are induded, the discussion will focus on the most recent month. . Staff will provide an in depth mid-year analysis of Revenues and Expenditures as part of the Budget Study Session on March 18, 1999. The report will identify any necessary mid-year adjustments and current revenue and expenditure trends. Analvsis of January 1999 Revenue and Expenditure Report The January report represents the reporting of revenues and expenditures for the seven months of the Fiscal Year. Major property tax revenues were received in December. In the expenditure category, the January report does not yet include contract expenses for the second quarter of contract Police Services. 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 January were collected at a rate ahead of the first seven months of the previous Fiscal Year. The City had collected through January 1999 approximately 57% of the total budgeted General Fund Revenues compared to approximately 49% 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 . result of the Christmas retail season, for which the City will not receive data until ApriL -------------_~.._______________________________.w__________________________________________________~_~______ COPIES TO: G:\MO!'\1HFS\199 Financial Reports.doc ITEM NO. 4.1 Franchise Taxes are lower than in the same period in the previous year due to timing differences in the receipt of Cable Franchise Taxes. Licenses and Permits are higher than in the same period in the prior year due to an increase in the number of building permits issued. Permits issued during July through January 1999 represented improvements valued at over $135 million. . The data presented regarding Interest and Rental revenue is somewhat skewed in the current report. Finance Staff have implemented a change in the timing of the adjustments necessary to accrue interest earnings to the various funds. As of December 31,1998 this is now being done on a quarterly basis. This will limit the ability to make comparisons to the prior year column, since past practice was to wait until June 30th and accrue once per year. A second factor relates to the.need for additional adjustments which correct an overstatement of the General Fund Interest Revenue. There will need to be an adjustment for revenues previously posted as Interest Receivable, which will reduce the reported interest revenue to date. In any case, due to cash flow timing with the payment of large expenditures, the City has had more cash available in the first six months for investment, than was assumed in the budget calculations. Factors effecting General Fund Interest in the future include: 1) A smaller proportion of the total interest earned on the portfolio in the next few months will be attributable to the General Fund. This is due to the prepayment of the Civic Center Certificates of Participation, which took place on February 1, 1999. This prepayment significantly reduced the amount of available cash that the City will have available for investment through the remainder of the Fiscal Year. 2) Recent declines in interest rates are expected to produce a lower yield than was achieved in the first half of the year. Charges for Services are higher than revenues collected during the same period of the prior year, primarily due to revenues received for planning and engineering services associated with increased development activity in Eastern Dublin and the establishment of the Eastern Dublin Specific Plan Implementation Fee,. which was not included in the adopted budget. Other Revenues are lower than the Other Revenues collected during the same period in the prior year, due to a decrease in the 1998 equity distribution payment received from ABAG PLAN. The insurance program has reduced equity distributions in order to fund higher coverage limits. In Fiscal Year 1998-99 the City will have liability coverage of $7 million per occurrence, which is an increase from a $5 million limit. This category is also affected by the sale of a 1994 fire truck for a new replacement unit, budgeted for Fiscal Year 1998-99. As of this date this transaction has not occurred. General Fund Expenditures Overall, through the month of January expenditures in the General Fund totaled $10,003,021 and represented approximately 44% of the total budgeted expenditures in the General Fund. Of this amount, a total of $495,606 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. General Fund Operating Expenditures through January 1999 were comparable to the amounts expended for the same period in the prior Fiscal Year. Civic Center Lease expenditures to date are approximately 94% of 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 January report the City has recorded the full amount of the debt . service payment to be made by the General Fund for Fiscal Year 1998/99. --;L.- . . . Animal Control expenditures are higher than in the same period in the prior Fiscal Year, due to timing difrerences in the payment of the City's pro rata share of the debt service on the East County Animal Shelter building. Transportation expenditures are lower than in the same period in the prior Fiscal Year due to lower charges incurred to date for water and sewer services. Health and Welfare expenditures are lower than in the same period of the prior Fiscal Year due to timing differences in the payment of the Child Care grant. Culture and Community Services are lower than in the same period in the prior Fiscal Year due to a delay in the recruitment and appointment of Staff to vacant positions. Community Development expenditures are higher than in the same period in the prior year due to higher development related contract expenditures incurred in the Engineering Activity. Capital Improvement Projects are only at 16% of budget to date as the majority of work on several capital projects, such as the purchase of a new fire apparatus, as well as improvements at the Swim Center and the Dublin Elementary Sports Field, are not scheduled to take place until later in the year. In addition, the City will be making the first of its four annual installment payments to the School District for the construction of the Gym at Valley High. 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 Government Code. -) - - ::; I 06 ;L t.f City of Dublin 1998-99 YTD Revenues and Budget Comparison For the Period Ending January 31,1998 - Unaudited . Total General Fund Revenues Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals . Intergovernmental from State Charges for Services . FY 98/99 :;l FY 97/98 45% 90% Other Revenues 8% 0% 30% 60% 90% 120% 150% 58% of Year Complete FY 98/99 FY 98/99 %of FY 97/98 % of Total for Budget YTD Actual Budget YTD Actual FY 97/98 Property Taxes 4.966,100 2.635,429 53% 2,380,469 52% Sales Taxes 7.900,000 4,347,194 55% 3,982,726 50% Transient Occupancy Taxes 370,000 163,981 44% 132,204 43% Franchise Taxes 782,000 216,434 28% 343,620 45% Licenses and Permits 1,826,755 1,279,774 70% 755,867 54% Interest and Rentals 1,225.530 1,103,085 90% 868,623 57% . Intergovernmental 1,258,420 701,614 56% 672,589 55% Charges for Services 2,592,503 1,664,079 64% 886,419 36% Other Revenues 680,645 174,932 26% 208,451 38% Total General Fund Revenues 21.601,953 12,286,522 57% 10,230,968 49% Date Printed: 219/99 17;26 ATTACHMENT 1 . -- .--. - -- ~. ~.,,,. '-. ....- _.,.~ ~~,.~_.-.......-"" ~ a{ ;'Y T Total General Fund Expenses 44% 48% J I I 54r General Government S4 0 f 94% Civic Center Lease 100% t 2f7% Police 210/0 f . FY 98/99 S2~ Fire 51% ~ FY 97/98 f Other Public Safety t:::::::=:::II 22O~ 0 f Transportation 40% 47% ~% I Health and Welfare 31% f Culture & Community Services 43% SI% t Community Development S % '-/0 + Capital Improv. Projects 16% 47% I , City of Dublin 1998-99 YTD Expenses and Budget Comparison For the Period Ending January 31, 1998 - Unaudited . . 0% 30% 60% 900/0 120% 58% of Year Complete FY 98/99 FY 98/99 %of FY 97/98 % of Total for Budget YTD Actual Budget YTD Actual FY 97/98 General Government 2,158,775 1,161,750 54% 946,143 54% Civic Center Lease 1,719,374 1,614,407 94% 1,493,244 100% Police 4,456,863 1,217,443 27% 1,110,483 26% Fire 4,210,354 2,205,016 52% 2,030,868 56% Other Public Safety 272,131 60,466 22% 26,474 10% Transportation 794,440 320,102 40% 308,125 47% Health and Welfare 18,160 727 4% 5,282 31% Culture and Community Services 2.580,711 1,105,271 43% 1,107,202 51% Community Development 3,263,127 1 ,822,233 56% 1,216,351 44% Capital Improvement Projects 3,014,363 495,606 16% 468,787 47% Total General Fund Expenses 22,488,298 10,003,021 44% 8,712,959 48. General Fund Operating Expenses 19,473,935 9,507,415 49% 8,244,172 48% Date Printed: 219/99 17:26 ATTACHMENT 2 . CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JANUARY 1999 . Prepared by The Finance Department February 9, 1999 . 3 <--) ?<I ATTACHMENT 3 GLl02 CITY DF DUBLIN PAGE 1 2/09/99 BAlANCE SHEET 17.16.20 FOR THE V ~ ;.1 PERIOD 7/98 THROUGH 1/99 GENERAL SPECIAL SPECIAL CAP IT AL TRUST I TOT A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONLY --~ FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30. 1 ASSETS CASH 13596873.10- 2264136.93 305281.35 10221316.82 141374.62 664763.38- 1339545.10- CASH WITH FISCAL AGENT 147088.59 147088.59 140476.37 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 30917864.17 30917864.17 34039321.17 RECEIVABLES:TAXES ACCOUNTS (NET) 192879.79 56552.15 249431. 94 175302.42 INTEREST 219840.71 219840.71 175681. 50 ASSESSMENTS RENTS NOTES DUE FROM OTHERS 248048.16 106990.01 355038.17 333488.11 INVENTORY AT COST PREPAID ITEMS 6147.54 6147.54 4868.35 FIXED ASSETS AMOUNTS TO BE PROVIDED 1941500.00 1941500.00 2018500.00 TOTAL ASSETS 17987907.27 2427679.09 305281.35 10221316.82 2229963.21 33172147.74 35548092. LIAS. FND BAL. RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 634292.18- 634292.18- 599774.91- DEPOSITS FOR AB1600 FEES 252444.00- 10144424.75- 10396868.75- 4913551.92- DEPOSITS OTHERS 741401.69- 3547.89- 248048.16- 992997.74- 898528.39- PAYABLES:ACCOUNTS 150596.80- 29785.88- 628.35 179754.33- 452390.02- INTEREST PAYROLL 39337.70- 39337.70- 41789.32- DUE TO OTHERS 89152.89- 89152.89- DEBT INSTRUMENTS PAYABLE 2059000.00- 2059000.00- 2136000.00- TOTAL LIABILTIES 1654781.26- 285777.77- 10391844.56- 2059000.00- 14391403.59- 9042034.56- FUND BAlANCES 16333126.01- 2141901. 32- 305281. 35- 170527.74 170963.21- 18780744.15- 26506058.26- TOTAL FUND EQUITY 16333126.01- 2141901.32- 305281.35- 170527.74 170963.21- 18780744.15- 26506058.26- TOTAL LIAB.FND BAL. RETD EARNS 17987907.27- 2427679.09- 305281.35- 10221316.82- 2229963.21- 33172147.74- 35548092.82- . GLl 02 2/M/99 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/98 THROUGH 1/99 . INTERNAL SERVICE FUNDS ENTERPRISE FIXED ASSETS GENERAL LONG FUNDS GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT . " 744903.16 17.46- 46348.74- 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 . TOTAL ASSETS LIAS. FND BAL. RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYASLES:ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCE CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 1645067.31 19163436.42 6380137.99 24626383.86 2389970.47 19163966.22 6380137.99 24626383.86 14770000.00- 24626383.86- 14770000.00- 24626383.86- 580560.92- 715923.78 1809409.55- 5109890.00- 6380137.99- 2389970.47- 4393966.22- 6380137.99- TOTAL LIAB.FND BAL. RETD EARNS 2389970.47- 19163966.22- 6380137.99- 24626383.86- . PAGE 1 17.16.29 ~cj';LY TOT A L S --- MEMORANDUM ONLY --- CURRENT JUNE 30. 1998 744885.70 483498.67 46348.74- 1674517.12 46896.00 46896.00 27188641.72 24032932.20 24626383.86 18410635.11 52560458.54 44648479.10 39396383.86- 39396383.86- 135362.86 6919299.55- 6380137.99- 33945635.11- 33945635.11- 1137095.13- 5499059.69- 4066689.17- 13164074.68- 10702843.99- 52560458.54- 44648479.10- GLl04C 2/09/99 AAAAAAAAREVENUES******* PROP~RTY TAXES SALES TAX REAL PROPERTY TRANSFERS TRANSIENT OCCUPANCY TAX FRANCHISE TAXES LICENSES & PERMITS FINES & FORFEITURES USES OF MONEY AND PROPERTY INTERGOVERNMENTAL FROM STATE CHARG~S FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL CITY COUNCIL 1010 CITY MANAGER 1020 CITY ATTORNEY 1030 ADMIN SERVICES 1040 BUILDING MANAGEMENT 1050 FACILITY RENTAL 1050-719 INSURANCE COST CENTER 1050 ELECTIONS COST CENTER 1070 ACTIVITY TOTAL PUBLIC SAFETY: POLICE 2010 CROSSING GUARDS COST 2020 ANIMAL CONTROL 2030 DISASTER PREAPREDNESS 2050 FIRE SERVICES 2060 ACTIVITY TOTAL TRANSPORTATION: PUBLIC WORKS 3010 STREtT MAINTENANCE 3020 STREET TREE MAINTENANCE 3040 STREET LANDSCAPE MAINT. 3050 ACTIVITY TOTAL HEALTH & WELFARE: WASTE MANAGEMENT CHILD CARE 5020 5030 ACTI V ITY TOTAL CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 CULTURAL ACTIVITIES 8011 HERITAGE CENTER 8012 DUBLIN CEMETERY 8013 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 1/99 BUDGET ~ 4731100.00- 7900000.00- 235000.00- 370000.00- 782000.00- 1826755.00- 45950.00- 1225530.00- 1258420.00- 2592503.00- 634695.00- 21601953.00- 40000.00 145373.00 350365.00 203340.00 732965.00 537270.00 1719374.00 143047.00 6415.00 3878149.00 4456863.00 52887.00 180700.00 38544.00 4210354.00 8939348.00 393130.00 141720.00 44990.00 214600.00 794440.00 6160.00 12000.00 18160.00 258848.00 20000.00 55272.00 21624.00 GENERAL REVENUE CURRENT PERIOD ACTUAL PERCENT 2494015.33- 4347193.57 - 141413.67- 163980.62- 216434.00- 1279773.72- 36016.77- 11 03085. 02- 701613.50- 1664079.47- 138914.52- 12286520.19- .00 83897.72 189217.93 122313.07 368282.79 306583.17 1614407.09 85150.35 6305.27 2776157.39 1217442.82 19475.25 21864.50 19126.26 2205015.77 3482924.60 209013.08 114.30 14163.74 96811.35 320102.47 726.50 .00 726.50 56061.75 20000.00 24669.10 3585 . 42 52.7 55.0 60.2 44.3 27.7 70.1 78.4 90.0 55.8 64.2 21. 9 56.9 57.7 54.0 60.2 50.2 57.1 93.9 59.5 98.3 71.6 27.3 36.8 12.1 49.6 52.4 39.0 53.2 .1 31.5 45.1 40.3 11.8 21. 7 100.0 44.6 16.6 FUND VARIANCE 2237084.67- 3552806.43- 93586.33- 206019.38- 565566.00- 546981.28- 9933.23- 122444.98- 556806.50- 928423.53- 495780.48- 9315432.81- 40000.00 61475.28 161147.07 81026.93 364682.21 230686.83 104966.91 57896.65 109.73 1101991.61 3239420.18 33411.75 158835.50 19417.74 2005338.23 5456423.40 184116.92 141605.70 30826.26 117788.65 474337.53 4.0 5433.50 12000.00 17433.50 202786.25 .00 30602.90 18038.58 PAGE 1 17.J.3.17 / I.:> ;/ .., '/ ~ ::7' . PREVIOUS YEAR ENDING JUNE 30. 1998 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D 4351858.66- 8025447.79- 231331.24- 306318.00- 759803.34- 1398676.76- 40421. 45- 1556181.29- 1233812.25- 2483860.91- 507052.04- 20894763.73- 300.15 120445.28 316766.51 220439.41 623479.37 315482.27 1493347.61 164079.95 650.04 3254990.59 4313328.45 48727.64 191931. 21 22300.28 3628257.63 8204545.21 355586.01 55741.35 43164.47 196217.21 650709.04 5039.06 12000.00 17039.06 216997.00 10000.00 53873.76 36931.78 2273879.87- 39827.25.64 - 106589.34- 132204.00- 343620.39- 755866.83- 19301. 74- 868623.16- 672589.05- 886418.51- 189148.99- 10230967.52- 187.40 70526.64 179471. 67 96495.37 345274.23 152974.09 1493243.61 100838.33 375.91 2439387.25 1110482.51 18583.34 .00 7890.66 2030868.37 3167824.88 191161.34 2794.43 11260.11 102909.38 308125.26 .00 5282.06 5282.06 108498.50 10000.00 30019.75 7562.96 62.4 58.6 56.7 43.8 55.4 48.5 100.0 61.5 57.8 74.9 35.4 56.0 38.6 53.8 5.0 26.1 52.4 47.4 44.0 31.0 50.0 100.0 55.7 20.5 52.3 49.6 46.1 43.2 45.2 54.0 47.8 55.8 54.5 35.7 37.3 49.0 2077978.79- 4042722.15- 124741.90- 174114.00- 416182.95- 642809.93- 21119.71- 687558.13- 561223.20- 1597442.40- 317903:05- 10663796.21- 112.75 49918.64 137294. 123944. 278205.14 162508.18 104.00 63241.62 274.13 815603.34 25.7 38.1 3202845.94 30144.30 191931.21 14409.62 - 1597389.26 5036720.33 164424.67 52946.92 31904.36 93307.83 342583.78 5039.06 6717.94 11757.00 , 108498. .00 23854.01 29368.82 GLl04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2 2/139/99 REVENUES VERSUS EXPENDITURE 17.13.17 FOR THE r; c;j d. tj PERIOD 7/98 THROUGH 1/99 . GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D PARK MAINTENANCE 8020 619429.00 237637.56 38.4 381791.44 551611.39 262156.10 47.5 289455.29 COMMUNITY CABLE TV 8030 71141. 00 46854.20 65.9 - 24286.80 36347.00 28429.00 78.2 7918.00 RECREATION ADMIN. 8040 290509.00 148900.21 51.3 141608.79 247461.23 136528.32 55.2 11 0932.91 PLAYGROUNDS 8045 137665.00 76284.81 55.4 61380.19 119477 . 39 67790.49 56.7 51686.90 SHANNON CENTER B050 153998.00 79996.51 51.9 74001.49 145355.49 81072.12 55.8 64283.37 PRESCHOOL 8055 56878.00 29000.66 51. 0 27877.34 52096.88 29385.57 56.4 22711.31 TEENS PROGRAM 8060 52028.00 21248.91 40.8 30779.09 34249.32 15202.85 44.4 19046.47 ADULT SPORTS 8065 84219.00 29673.04 35.2 54545.96 57312.65 31678.80 55.3 25633.85 YOUTH SPORTS 8066 99301.00 30489.71 30.7 68811.29 45215.51 27820.25 61.5 17395.26 SPECIAL EVENTS 8070 130591.00 41094.56 31.5 89496.44 98680.81 27279.86 27.6 71400.95 SENIOR CENTER 8080 124610.00 52665.91 42.3 71944.09 96151.47 51239.58 53.3 44911.89 RECREATION INSTRUCTION 8090 122588.00 66062.48 53.9 56525.52 136049.81 70025.04 51.5 66024.77 AQUA T! CS 8100 255751.00 141046.66 55.1 114704.34 231182.41 122512.86 53.0 108569.55 PARKS/FACILITIES MGMT 8200 26259.00 .00 26259.00 .00 .00 .00 ACTIVITY TOTAL 2580711.00 1105271.49 42.8 1475439.51 2168993.90 11 07202.05 51.0 1061791. 85 COMMUNITY DEVELOPMENT: PLANNING 9010 944988.00 504969.41 53.4 440018.59 814255.37 419889.03 51.6 394366.34 BUILDING 9020 880947.00 393596.88 44.7 487250.12 606011.10 299514.77 49.4 306496.33 ENGINEERING 9030 1253161.00 823223.65 65.7 429937.35 1186462.85 394290.93 33.2 792171. 92 ~NOMIC DEVELOPMENT 9040 184031.00 100342.62 54.5 83688.38 154403.41 102656.42 66.5 51746.99 ACT! V ITY TOTAL 3263127.00 1822232.56 55.8 1440894.44 2761132.73 1216351.15 44.1 1544781.58 CAPITAL IMPROVEMENT PPROJECTS: GENERAL CIP PROJECTS 93NN 100.00 .00 100.00 .00 .00 .00 COMMUNITY IMPROVEMENTS 94NN 72994.00 9048.19 12.4 63945.81 62322.25 1195.56 1.9 61126.69 PARKS 95NN 1249385.00 188990.32 15.1 1060394.68 146393.97 17918.80 12.2 128475.17 STREET CONSTRC/IMPRVMT 96NN 364062.00 230818.21 63.4 133243.79 366233.78 261073.47 71.3 105160.31 ACTIVITY TOTAL 3014363.00 495606.24 16.4 2518756.76 987200.17 468787.37 47.5 518412.80 TOT A L EXPENDITURES 22488298.00 10003021.25 44.5 12485276.75 18044610.70 8712960.02 48.3 9331650.68 EXCESS (REVENUE)EXPENDITURES 886345.00 2283498.94- 257.6- 3169843.94 2850153.03- 1518007.50- 53.3 1332145.53- TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 24136.65- 10785.46- 44.7 13351.19- TRANSFERS OUT TO OTHER FUNDS 2531. 00 12134212.45 9423.6 12131681.45. 8384.92 .00 8384.92 EXCESS (REVENUE)/EXPENDITURES 888876.00 9850713.51 1108.2 8961837.51- 2865904.76- 1528792.96- 53.3 1337111.80- . Gl104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/09/99 REVENUES VERSUS EXPENDITURE 17.13.44 FOR THE 'to ~ j. tf PERIOD 7/98 THROUGH 1/99 SPECIAL REVENUE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. tIIIIt BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D AAAAAAAAREVENUES******* PROPERTY TAXES 76680.00- 38986.96- 50.8 37693.04- 74722.51- 37965.32- 50.8 36757.19- SALES TAX 175500.00- 99623.98- 56.8 75876.02- 166074.24- 93820.34- 56.5 72253.90- FINES & FORFEITURES 42400.00- 33011.22- 77.9 9388.78- 30595.76- 14891.75- 48.7, 15704.01- SPECIAL 8ENEFITS ASSESSMENTS .00 .00 .00 .00 405.23- 405.23 USES OF MONEY AND PROPERTY 97330.00- 42225.77- 43.4 55104.23- 99595.22- .00 99595.22- INTERNGoVERNMENTAL FROM STATE 1474121.00- 347463.65- 23.6 1126657.35- 650748.42- 370238.42- 56.9 280510.00- INTERGOVERNMENTAL FROM COUNTY 145065.00- 54778.00- 37.8 90287.00- 143024.00- 54492.00- 38.1 88532.00- INTERGOVERNMENTAL FROM FEDERAL 327557.00- 2398.79- .7 325158.21- 136885.41- 10736.26- 7.8 126149.15- CHARGES FOR SERVICES 698080.00- 357709.07- 51.2 340370.93- 715254.01- 353797.10- 49.5 361456.91- OTHER SOURCES OF REVENUE 139810.00- 16177.51- 11.6 123632.49- 244641.83- .00 244641. 83- TOTAL REVENUE 3176543.00- 992374.95- - 31. 2 2184168.05- 2261541. 40- 936346.42- 41.4 1325194.98- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT .00 .00 .00 175.00 .00 175.00 ACTIVITY TOTAL .00 .00 .00 175.00 .00 175.00 PUBU C SAFETY: PoU CE 77844. DO 22250.40 28.6 55593.60 87354.31 21594.27 24.7 65760' TRAFFI C SIGNALS 104750.00 32967.35 31.5 71782.65 80070.46 33196.71 41.5 46873 FIRE SERVICES 81745.00 38986.96 47.7 42758.04 79808.20 37965.32 47.6 41842. ACTIVITY TOTAL 264339.00 94204.71 35.6 170134.29 247232.97 92756.30 37.5 154476.67 TRANSPORT A TI ON : STREET MAINTENANCE 245020.00 55091.77 22.5 189928.23 249796.03 52427.51 21.0 197368.52 STREET SWEEPING 90070.00 39356.94 43.7 50713.06 78539.83 31158.51 39.7 47381. 32 ACTIVITY TOTAL 335090.00 94448. 71 28.2 240641. 29 328335.86 83586.02 25.5 244749.84 HEALTH & WELFARE: WASTE MANAGEMENT 859499.00 2997.55 .3 856501.45 740895.48 367987.53 49.7 372907.95 SENIOR SUPPORT CARE 7044.00 3522.00 50.0 3522.00 7044.00 2958.32 42.0 4085.68 ACTIVITY TOTAL 866543.00 6519.55 .8 860023.45 747939.48 370945.85 49.6 376993.63 CULTURE & LEISURE SERVICES: PARK MAINTENANCE .00 .00 .00 3329.51 .00 3329.51 ACTIVITY TOTAL .00 .00 .00 3428.52 .00 3428.52 COMMUNITY DEVELOPMENT: ENGINEERING 38900.00 6049.79 15.6 32850.21 56396.92 12166.25 21.6 44230.67 ACTIVITY TOTAL 38900.00 6049.79 15.6 32850.21 56396.92 12166.25 21.6 44230.67 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 57611.00 9067.50 15.7 48543.50 233611. 81 103452.81 44.3 130159.00 PARKS 185523.00 52191.80 28.1 133331.20 95432.22 87404.08 91.6 8028.14 STREET CoNSTRUCTION/IMPRoVMT 1385073.00 406762.59 29.4 978310.41 286937.98 33973.07 11.8 252964.91 ACTIVITY TOTAL 1628207.00 468021.89 28.7 1160185.11 615982.01 224829.96 36.5 391152.05 TOT A L EXPENDITURES 3133079.00 669244.65 21.4 2463834.35 1999490.76 784284.38 39.2 1215206.38 EXCESS <REVENUE>EXPENDITURE 43464.00- 323130.30- 743.4 279666.30 262050.64- 152062.04- 58.0 . 109988. TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 9468.29 .00 9468 EXCESS <REVENUE> EXPENDITURE 43464.00- 323130.30- 743.4 279666.30 252582.35- 152062.04- 60.2 100520.31- GLl04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/09/99 REVENUES VERSUS EXPENDITURE 17.14.22 FOR THE ::f ~( PERIOD 7/9B THROUGH 1/99 9 . SPECIAL ASSESSMENT FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D. 1998 8UDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ........REVENUES******* SPECIAL BENEFITS-ASSESSMENTS 254580.00- 128526.65- 50.5 126053.35- 276342.55- 129820.85- 47.0 146521.70- USES OF MONEY AND PROPERTY 10300.00- 4691.75- 45.6 5608.25- 15100.80- .00 15100.80- OTHER SOURCES OF REVENUE 2000.00- .00 2000.00- 2026.04- .00 2026.04- TOTAL REVENUE 266880.00- 133218.40- 49.9 133661.60- 293469.39- 129820.85- 44.2 163648.54- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLI C SAFETY: TRFC SIGSISTREET LIGHTING 130987.00 31961. 93 24.4 99025.07 114852.44 42988.66- 37.4 71863.78 ACTIVITY TOTAL 130987.00 31961. 93 24.4 99025.07 114852.44 42988.66 37.4 71863.78 TRANSPORTATION: PUBLIC WORKS 4229.00 1188.74 28.1 3040.25 3578.12 1825.88 51.0 1752.24 STREET TREE MAINTENANCE 9600.00 2733.02 28.5 6865.98 4084.90 1992.25 48.8 2092.64 STREET LANDSCAPE MAINTENANCE 128770.00 51812.24 40.2 76957.76 103582.99 65419.46 64.1 37163.53 ACTIVITY TOTAL 142599.00 55734.00 39.1 86855.00 111246.01 70237.60 63.1 41008.41 HEALTH & WELFARE; ~RE & LEISURE SERVICES: NITY DEVELOPMENT: ENGINEERING 3980.00 2957.04 74.3 1022.96 3465.00 3465.00 100.0 .00 ACTIVITY TOTAL 3980.00 2957.04 74.3 1022.96 3465.00 3465.00 100.0 .00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS .00 .00 .00 27115.00 7815.00 28.8 19300.00 STREET CONSTRUCTIONIIMPROVMT .00 .00 .00 48938.90 45000.00 92.0 3938.90 ACTIVITY TOTAL .00 .00 .00 76053.90 52815.00 69.4 23238.90 TOT A L EXPENDITURES 277566.00 90652.97 32.7 186913.03 305617.35 169506.26 55.5 136111. 09 EXCESS<REVENUE>EXPENDITURE 10686.00 42565.43- 398.3- 53251.43 12147.96 39685.41 326.7 27537.45- EXCESS <REVENUE> EXPENDITURE 10686.00 42565.43- 398.3- 53251.43 12147.96 39685.41 326.7 27537.45- . GU04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE '1 2/09/99 REVENUES VERSUS EXPENDITURE 17.15.39 FOR THE --~ <; j PERIOD 7/98 THROUGH 1/99 It) CAP IT AL IMPROVEMENT FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. ~ BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D kkkkkkkAREVENUES******* USES OF MONEY AND PROPERTY .00 176098.41- 176098.41 .00 .00 .00 OTHER SOURCES OF REVENUE 10808817.00- 317394.34- 2.9 10491422.66- 615328.94- 51796.03- 8.4 563532.91- TOTAL REVENUE 10808817.00- 493492.75- 4.6 10315324.25- 615328.94- 51796.03- 8.4 563532.91- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES; ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE; CULTURE & LEISURE SERVICES; RECREATION ADMINISTRATION 14500.00 14737.06 101. 6 237.05- .00 .00 .00 ACTIVITY TOTAL 14500.00 14737.06 101.6 237.06- .00 .00 .00 COMMUNITY DEVELOPMENT; PLANNING 16226.00 145.14 .9 16080.86 3248.58 .00 3248.58 ACTIVITY TOTAL 16226.00 145.14 .9 16080.86 3248.58 .00 3248.58 CAPITAL IMPROVEMENT PROJECTS; GENERAL CIP PROJECTS 982334.00 102919.38 10.5 B79414.52 22818.06 17421.55 76.3 5396.51 COMMUNITY IMPROVEMENTS 94024.00 .00 94024.00 12000.62 9970.62 83.1 203_ PARKS 2768475.00 139724.01 5.0 2628750.99 86242.07 18005.34 20.9 68236. STREET CONSTRUCTION/IMPROVMT 6936789.00 158446.74 2.3 6778342.26 419692.52 60830.00 14.5 358862.52 ACTIVITY TOTAL 10781622.00 401090.13 3.7 10380531.87 540753.27 106227.51 19.6 434525.76 TOT A L EXPENDITURES 10812348.00 415972.33 3.8 10396375.67 544001.85 106227.51 19.5 437774.34 EXCESS<REVENUE>EXPENDITURE 3531.00 77520.42- 2195.4- 81051.42 71327.09- 54431.48 76.3- 125758.57- TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 27964.95- .00 27964.95- TRANSFERS OUT TD OTHER FUNDS .00 .00 .00 42633.31 10785.46 25.3. 31847.85 EXCESS <REVENUE> EXPENDITURE 3531.00 77520.42- 2195.4- 81051.42 56658.73- 65216.94 115.1- 121875.67- . GLl04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/o~/99 REVENUES VERSUS EXPENDITURE 17.16.00 FOR THE // ~ ;1 PERIOD 7/98 THROUGH 1/99 -"'..J e TRUST/AGENCY FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ........REVENUES******* SPECIAL BENEFITS ASSESSMENTS .00 116107.32- '116107.32 234497.12- 11724B.56- 50.0 117248.56- USES OF MONEY AND PROPERTY .00 4863.09- 4863.09 13367.83- 4089.31- 30.6 9278.52- TOTAL REVENUE .00 120970.41- 120970.41 247864.95- 121337.87- 49.0 126527.08- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL .00 157748.50 157748.50- 232903.25 156154.75 67.0 76748.50 ACTIVITY TOTAL .00 157748.50 157748.50- 232903.25 156154.75 67.0 76748.50 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOTAL EXPENDITURES .00 157748.50 157748.50- 232903.25 156154.75 67.0 76748.50 EXCESS(REVENUE)EXPENDITURE .00 36778.09 36778.09- 14961.70- 34816.88 232.7- 49778.58- eS (REVENUE) EXPENDITURE .00 36778.09 36778.09- 14961. 70- 34816.88 232.7- 49778.58- e GLl 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/09/99 REVENUES VERSUS EXPENDITURE 17.14.44 FOR THE . PERIOD 7/98 THROUGH 1/99 ;el- ~ ~tj J INTERNAL SERVICE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1~ BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D AAAAAAAAREVENUES******* USES OF MONEY AND PROPERTY 39604.00- 11928.19- . 30.1 27675.81- 26288.45- .00 26288.45- CHARGES FOR SERVICES 737923.00- 385805.44- 52.3 352117.56- 241988.51- 141699.95- 58.6 100288.56- OTHER SOURCES OF REVENUE 30000.00- 895.06- 3.0 29104.94- 6782.95- 50.00- .7 6732.95- TOTAL REVENUE 807527.00- 398628.69- 49.4 408898.31- 275059.91- 141749.95- 51.5 133309.96- *******EXPENOITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 728134.00 222942.65 30.6 505191.35 235476.79 61611.41 26.2 173865.38 ACTIVITY TOTAL 728134.00 222942.65 30.6 505191.35 235476.79 61611.41 26.2 173865.38 PUBLI C SAFETY: TRANSPORT A TI ON: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 728134.00 222942.65 30.6 505191.35 235476.79 61611.41 26.2 173865.38 EXCESS<REVENUE>EXPENDITURE 79393.00- 175686.04- 221. 3 96293.04 39583.12- 80138.54- 202.5 40555.42 EXCESS <REVENUE> EXPENDITURE 79393.00- 175686.04- 221.3 96293.04 39583.12- 80138.54- 202.5 40555.. . GLl04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/09/99 REVENUES VERSUS EXPENDITURE 17.15.18 FDR THE ...../ ~ tj PERIOD 7/98 THROUGH 1/99 ." /2 -J - . ENTERPRISE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D !. A A A A A A A REVENUES******* USES OF MONEY AND PROPERTY 1827244.00- 1666990.36- 91.2 160253.64- 1590062.53- 1545637.44- 97:2 44425-.09- TOTAL REVENUE 1827244.00- 1666990.36- 91.2 160253.64. 1590062.53- 1545637.44- 97.2 44425.09- ~EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1719394.00 15234638.82 886.0 13515244.82- 1272423.93 1248826.32 98.1 23597.61 ADMIN SERVICES 3435.00 .00 3435.00 4415.00 1050.00 23.8 3365.00 ACTIVITY TOTAL 1722829.00 15234638.82 884.3 13511809.82- 1276838.93 1249876.32 97.9 26962.61 PUBLl C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 1722829.00 15234638.82 884.3 13511809.82- 1276838.93 1249876.32 97.9 26962.61 EXCESS<REVENUE>EXPENDITURES 104415.00- 13567648.46 2994.0- 13672063.45- 313223.60- 295761.12- 94.4 17462.48- TRANSFERS IN FROM OTHER FUNDS .00 12134212.45- 12134212.45 8384.92- .00 8384.92- ~ <REVENUE> EXPENDITURE 104415.00- 1433436.01 1372.8- 1537851. 01- 321608.52- 295761.12- 92.0 25847.40- . CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF DECEMBER 1998 Prepared by The Finance Department February 9, 1999 /1/ J' "".J ;21 . . . GLl 02 CITY OF DUBLIN PAGE 1 2/e9/99 BAlANCE SHEET 16.54.08 FOR THE 15 ~ c?- '/ PERIOD 7/9B THROUGH 12/9B . GENERAL SPECIAL SPECIAL CAPITAL TRUST I T 0 T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- M::MORANDUM ONL Y --- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30. 1998 ASSETS CASH 14314042.83- 2397597.34 315473.16 10812508.72 141374.62 647088.99- 809228.45 CASH WITH FISCAL AGENT 147088.59 147088.59 139866.37 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 44377864.17 44377854.17 32309321.17 RECEIVABLES:TAXES ACCOUNTS (NET) 192879.79 56552.15 249431.94 179704.41 INTEREST 219840.71 219340.71 175681.50 ASSESSMENTS RENTS NOTES DUE FROM OTHERS 248048.16 106990.01 355033.17 333488.11 INVENTORY hT COST ?REPAID ITEMS 8135.75 8135.75 7014.75 rIXED ASStTS A~OUNTS TO BE PROVIDED 1941500.00 1941500.00 2018500.00 . TOTAL ASSETS 30732725.75 2561139.50 315473.16 10812508.72 2229963.21 46651810.34 35972804.76 LIAB. FND BAL. RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 512898.28- 512898.28- 446022.56- DEPOSITS FOR AB1600 FEES 252444.00- 10622364.93- 108748oB.93- 4775995.12- DEPOSITS OTHERS 752382.96- 3547.89- 248048.16- 1003979.01- 903261. 52- PAYABLES:ACCOUNTS 158943.45- 61796.68- 644.65- 221384.78- 447016.97 - INTEREST PAYROLL 2859.33- 2859.33- 3194.12- DUE TO OTHERS 82450.79- 82450.79- DEBT INSTRUMENTS PAYABLE 2059000.00- 2059000.00- 2136000.00- TOTAL LIABILTIES 1509534.81- 317788.57- 10871057.74- 2059000.00- 14757381.12- 8711490.29- FUND BALANCES 29223190.94- 2243350.93- 315473.16- 58549.02 170963.21- 31894429.22- 27261314.47- TOTAL FUND EQUITY 29223190.94- 2243350.93- 315473.16- 58549.02 170963.21- 31894429.22- 27261314.47- TOTAL LlAB.FND BAL. REID EARNS 30732725.75- 2561139.50- 315473.16- 10812508.72- 2229963.21- 46651810.34- 35972804.76- . GLl 02 CITY OF DUBLIN PAGE 2/()9/99 BALANCE SHEET 1q,.54.: FOR THE Ib _7 J-Y PERIOD 7/98 THROUGH 12/9B -:J INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOT A L S~ SERVICE FUNDS GROUP OF TERM DEBT --- MEMORANDUM ONLY FUNDS ACCOUNTS ACCOUNT GROUP CURRENT JUNE 30. 1998 ;IS S ETS CASH 688864.02 7.46- 688856.56 463992.68 CASH WITH FISCAL AGENT 1719342.09 1719342.09 1676928.71 UNA~JRiIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVA8LES:TAXES ACCOUNTS (NET) INTEREST 46896.00 46896.00 46896.00 ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID IEMS FIXED ASSETS 1645067.31 19163436.42 6380137.99 27188541.72 24032932.20 A~OUNTS TO BE PROVIDED 24952008.98 24952008.98 18410635.11 TOTAL ASSETS 2333931.33 20929667.05 6380137.99 24952008.98 54595745.35 446313. LIAS. FNO 8AL. RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYASLES:ACCOUNTS I t\'TEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 14770000.00- 24952008.98- 39722008.98- 33945635.46- TOTAL LIABILITIES 14770000.00- 24952008.98- 39722008.98- 33945635.46- FUND BALANCE 524521.78- 1049777.05- 1574298.83- 1120000.38- CONTRIBUTIONS 1809409.55- 5109890.00- 6919299.55- 5499059.69- INVESTMENTS IN FIXED ASSETS 6380137.99- 6380137.99- 4066689.17- RETAINED EARNINGS TOTAL FUND EQUITY 2333931. 33- 6159667.05- 6380137.99- 14873736.37- 10685749.24- TOTAL LIAS.FND 8AL. RETD EARNS 2333931.33- 20929667.05- 6380137.99- 24952008.98- 54595745.35- 44631384.70- ~ GLl04C THE CITY OF OUBLIN'STATEMENT SHOWING PAGE 1 2/09/99 REVENUES VERSUS EXPENDITURE 15.50.30 FOR THE ~'I PERIOD 7/98 THROUGH 12/98 /? ----' "-'J . GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ;,;,;.".l J.;'.l REVENUES"""'***** PRDDERTY TAXES 4731100.00- 2494015.33- 52.7 2237084.67- 4351858.66- 2221095.92- 51. 0 2130762.74~ S.~LES TAX 7900000.00- 3723093.57- 47.1 4175906.43- 8025447.79- 3446925.64- 42.9 4578522.15- REAL PROPERTY TRANSFERS 235000.00- 113645.03- 48.4 121354.97- 231331.24- 85561.16- 37.0 1115770.05- TRANSIENT OCCUPANCY TAX 370000.00- 143546.79- 38.8 226453.21- 306318.00- 132204.00- 43.2 174114.00- FR~NCHISE TAXES 782000.00- 179593.00- 23.0 602407.00- 759803.34- 168684.83- 22.2 591118.51- LICENSES & PERMITS 1826755.00- 1212613.14- 66.4 614141.86- 1398576.76- 709244.68- 50.7 689432. os- FINES & FORFEITURES 45950.00- 32210.84- 70.1 13739.16- 40421. 45- 18433.43- 45.6 21933.02- USES OF MONEY AND PROPERTY 1225530.00- 580237.75- 47.3 645292.25- 1556181. 29- 679359.77- 43.7 876821. 52- INTERGOVERNMENTAL FROM STATE 1258420.00- 606098.54- 48.2 652321.46- 1233812.25- 557154.78- 45.2 676657.47- CHARGES FOR SERVICES 2592503.00- 1391583.16- 53.7 1200919.84- 2483860.91- 766061. 32- 30.8 1717799.59- OTHER SOURCES OF REVENUE 634625.00- 112268.50- 17.7 522356.50- 507052.04- 162129.35- 32.0 344922.68- TOTAL REVENUE 21601883.00- 10588905.65- 49.0 11012977 .35- 20894753.73- 8946854.89- 42.8 11947908.84- ~EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 45000.00 .00 45000.00 300.15 187.40 62.4 112.75 _n COUNCIL 1010 140373.00 76220.65 54.3 64152.34 120445.28 63623.40 52.8 55821.89 TY MANAGER 1020 350365.00 152302.12 43.5 198062.88 316756.51 142715.08 45.1 174051.43 ITY ATTORNEY 1030 203340.00 90044.67 44.3 113295.33 220439.41 96004.33 43.6 124435.08 ADMIN SERVICES 1040 732965.00 298210.49 40.7 434754.51 623479.37 283344.20 45.4 340135.17 BUILDING MANAGEMENT 1050 537270.00 248989.39 46.3 288280.61 315482.27 144733.32 45.9 170748.95 FACIUTY RENTAL 1050-719 1719374.00 346063.49 20.1 1373310.51 1493347.61 367126.85 24.6 1126220.75 INSURANCE COST CENTER 1060 143047.00 84308.66 58.9 58738.34 164079.95 100377 .47 61.2 63702.48 ELECTIONS COST CENTER 1070 6415.00 1048.16 16.3 5356.84 650.04 375.91 57.8 274 .13 ACTIVITY TOTAL 3878149.00 1297187.64 33.4 2580961.36 3254990.59 1198487.97 36.8 2056502.62 PUBLl C SAFETY; POll CE 2010 4456863.00 1174610.35 26.4 3282252.65 4313328.45 1070036,77 24.8 3243291.68 CROSSING GUARDS COST 2020 52887.00 15072.15 28.5 37814.85 48727.64 15986.64 32.8 32741. 00 ANIMAL CONTROL 2030 180700.00 21864.50 _ 12.1 158835.50 191931.21 .00 191931.21 DISASTER PREAPREDNESS 2050 38544.00 15232.71 39.5 23311.29 22300.28 4122.87 18.5 18177.41 FIRE SERVICES 2060 4210354.00 1908405.53 45.3 2301948.47 3628257.63 2030100.30 56.0 159B157.33 ACTIVITY TOTAL 8939348.00 3135185.24 35.1 5804162.76 8204545.21 3120246.58 38.0 5084298.63 TRANSPORT A TI ON : PUBU C WORKS 3010 393130.00 170010.57 43.2 223119.43 355586.01 162037.42 45.6 193548.59 STREET ~A1NTENANCE 3020 141720.00 114.30 .1 141605.70 55741.35 2794.43 5.0 52946.92 STREET TREE MAINTENANCE 3040 44990.00 11892.42 26.4 33097.58 43164.47 11260.11 25.1 31904.36 STREET LANDSCAPE MA1NT. 3050 214600.00 82133.01 38.3 132466.99 196217.21 93657.88 47.7 102559.33 ACTIVITY TOTAL 794440.00 264150.30 33.2 530289.70 650709.04 269749.84 41.5 380959.20 HEALTH & WELFARE: WASTE MANAGEMENT 5020 6160.00 726.50 11.8 5433.50 5039.06 .00 5039.06 CHILD CARE 5030 12000.00 .00 12000.00 12000.00 4425.32 36.9 7574.68 ~ ACTIVITY TOTAL 18160.00 726.50 4.0 17433.50 17039.06 4425.32 26.0 12613.74 RE & LEISURE SERVICES: IBRARY SERVICES 8010 258848.00 56061. 75 21.7 202785.25 216997.00 54249.25 25.0 162747.75 CULTURAL ACTIVITIES 8011 20000.00 20000.00 100.0 .00 10000.00 10000.00 100.0 .00 HERITAGE CENTER 8012 55272.00 19083.80 34.5 36188.20 53873.76 26338.72 48.9 27535.04 DUBLl N CEMETERY 8013 21624.00 3136.61 14.5 18487.39 36931.78 7479.85 20.3 29451. 93 GLlC!.C THE CITY OF DUBLIN STATEMENT SHOWING PAGE - 2/09/99 REVENUES VERSUS EXPENDITURE 160.50.3C FOR THE PERIOD 7/98 THROUGH 12/98 /? if:ZV GENERAL REVENUE FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1998 8UDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D P.A,~K tliAINTEN4NCE 8020 619429.00 191526,66 30.9 427902.34 551611.39 244756.32 44.4 306855.07 CO~~UNITY CABLE TV 8030 71141. 00 46854.20- 65.9 24285.80 36347.00 26823.00 73.8 9524.0C RECREATION ADMIN. 8040 290509.00 122868.85 42.3 167640.15 247461. 23 112758,88 45.6 134702.35 PLAYGROUNDS 8045 137665.00 66169.69 48.1 71495.31 119477 . 39 59663 .4 0 -49.9 59813.99 SHANNON CENER 8050 153998.00 64787.62 42.1 89210.38 145355.49 72109.51 49.6 73245.93 PRESCHOOL 8055 56878.00 24341,41 42.8 32536.59 52096.88 24251,68 46.6 27845.20 TEENS PROGRA~ 8060 52028.00 16152.31 31.0 35875.69 34249.32 10984.04 32.1 23265.28 ADULT SPORTS 8065 84219.00 25789.64 30.6 58429.36 57312.65 28646,94 50.0 28565.71 YOUTH SPORTS 8056 99301.00 23082.37 23.2 76218.63 45215.51 20154.65 44.6 25060.85 SPECIAL EVENTS 8070 130521.00 14959.02 11.5 115561.98 98580.81 15897.34 16.1 82783,47 SENIOR CENTER 8080 124610.00 43899.53 35.2 80710.47 96151.47 44552.39 46.3 51599.03 RECREATION INSTRUCTION 8090 122588.00 60886.11 49.7 61701.29 136049.81 64450.68 47.4 71599.13 AQUATICS 8100 255751.00 127041.73 49.7 128709.27 231152,41 117459.97 50.6 113722.~':; PARKS/FACILITIES MGMT 8200 26259.00 .00 26259.00 .00 .00 .00 ACTI V ITY TOi.!l.L 2580541,00 925541.30 35.9 1653999.70 2168993.90 940576.63 43.4 1228417.27 COMMUNITY DEVELO?MENT: PLANNING 9010 944988.00 395633.56 41.9 549354,.<14 814255.37 348772.37 42.8 465483.00 BUILDING 9020 880947.00 326932.66 37.1 554014.34 606011.10 245542.65 40.5 360468,45 ENGINEERING 9030 1253161.00 653872.21 52.2 599288.79 1186462.85 332307.91 28.0 854154 , C':; ECONOMIC DEV~LOPMENT 9040 184031.00 89513.10 48.6 94517.90 154403.41 85243,17 55.2 6916. ACTI V!TY TOTAL 3263127.00 1465951. 53 44,9 1797175.47 2761132.73 1011866.10 36.6 1749266. _ CAPITAL IMPROVEM:NT PPROJECTS: GENERAL CIP PROJECTS 93NN 100.00 .00 100.00 .00 .00 .00 COMMUNITY IMPROVEMENTS 94NN 72994.00 8478.79 11.6 64515.21 62322.25 1195.55 1.9 61126.69 PARKS 95NN 1079695.00 155962.31 14.4 923732.69 146393.97 17116,08 11.7 129277.89 STREET CONSTRC/IMPRVHT 96NN 364062,00 229808.71 63.1 134253.29 366233.78 7607.64 2.1 358626.14 ACTIVITY TOTAL 2844673.00 459711.72 16.2 2384961.28 987200.17 214503.93 21.7 772696.24 TOTAL EXPENDITURES 22318538.00 7549554.23 33.8 14768983.77 18044610.70 6759856,37 37.5 11284754,33 EXCESS (REVENUE)EXPENDITURES 716655,00 3039351.42- 424.1- 3756006.42 2850153.03- 2186998.52- 76.7 663154.51- TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 24136.65- 10785.46- 44.7 13351.19- TRANSFERS OUT TO OTHER FUNDS 2531.00 .00 2531.00 8384.92 .00 8384.92 EXCESS (REVENUE)/EXPENDITURES 719186.00 3039351. 42- 422.6- 3758537.42 2865904.76- 2197783.98- 76.7 668120.78- . GLl Q4C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/0'9199 REVENUES VERSUS EXPENDITURE 16.50.58 FOR THE ~'/ PERIOD 7/98 THROUGH 12/98 /i -/ -V . SPECIAL REVENUE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D. 1998 8UDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D A^A~'~~'REVENUES******* PROPERTY TAXES 76580.00- 38986.96- 50.8 37693.04- 74722.51- 37965.32- 50.8 36757.19- SALES TAX 175500.00- 87309.68- 49.7 88190.32- 166074.24- 82108.65- 49.4 83965.59- FINES & FORFEITURES 42400.00- 28123.13- 65.3 14276.87- 30595.76- . 12733.91- 41.6 17861. 85- USES OF MONEY AND PROPERTY 97330.00- 42225'.77- 43.4 55104.23- 99595.22- .00 99595.22- INTERNGOVERNMENTAL FROM STATE 1474121. 00- 347463.65- 23.6 1126657.35- 650748.42- 333069.78- 51.2 317678.64- INTERGOVERNMENTAL FROM COUNTY 145065.00- 54778.00- 37.8 90287.00- 143024.00- 54492.00- 38.1 88532.00- INTERGOVERNMENTAL FROM FEDERAL 327557.00- 2398.79- .7 325158.21- 136885.41- 10736.26- 7.8 126149.15- CHARGES FOR SERVICES 598080.00- 357709.07- 51.2 340370.93- 715254.01- 347338.67- 48.6 367915.34- OTHER SOURCES OF REVENUE 139810.00- 14241. 00- 10.2 125569.00- 244641.83- .00 244641. 83- TOTAL REVENUE 3176543.00- 973236.05- 30.6 2203306.95- 2261541.40- 878444.59- 38.8 1383095.81- ****'***EXPENDITURESi. i... ..... GENER~L GOVERN~ENT ACTIVITIES: BUILDING MAN~GEMENT .00 .00 .00 175.00 .00 175.00 ACTIVITY TOTAL .00 .00 .00 175.00 .00 175.00 PUBLI C SAFETY: ~CE 77844.00 22250.40 28.6 55593.60 87354.31 21215.39 24.3 66138. 92 rFIC SIGNALS 104750.00 29415.89 28.1 75334.11 80070.46 29351.70 35.7 50718.76 RE SERVICES 81745.00 975.00 1.2 80770.00 79808.20 37965.32 47.6 41842.88 ACTIVITY TOTAL 264339.00 52641.29 19.9 211697.71 247232.97 88532.41 35.8 158700.56 TRANSPORT AT ION: STREET MAINTENANCE 245020.00 27294.67 11.1 217725.33 249796.03 52427.51 21.0 197368.52 STREET SWEEPING 90070.00 26237.96 29.1 63832.04 78539.83 31158.51 39.7 47381.32 ACTIVITY TOTAL 335090.00 53532.63 16.0 281557.37 328335.86 83586.02 25.5 244749.84 HEALTH & WELFARE: WASTE MANAGEMENT 859499.00 2997.55 .3 856501. 45 740895.48 367987.53 49.7 372907.95 SENIOR SUPPORT CARE 7044.00 2935.00 41.7 4109.00 7044.00 2958.32 42.0 4085.68 ACTIVITY TOTAL 866543.00 5932.55 .7 860610.45 747939.48 370945.85 49.6 376993.63 CULTURE & LEISURE SERVICES: PARK MAINTENANCE .00 .00 .00 3329.51 .00 3329.51 ACTIVITY TOTAL .00 .00 .00 3428.52 .00 3428.52 COMMUNITY DEVELOPMENT: ENGINEERING 38900.00 6049.79 15.6 32850.21 56396.92 11073.46 19.6 45323.46 ACTI V IiY TOTAL 38900.00 6049.79 15.6 32850.21 56396.92 11073.46 19.6 45323.46 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 57611.00 9067.50 15.7 48543.50 233611.81 53881.74 23.1 179730.07 PARKS 185523.00 16104.30 8.7 169418.70 95432.22 87334.08 91.5 8098.14 STREET CONSTRUCTIoN/IMPROVMT 1385073.00 405328.08 29.3 979744.92 286937.98 31663.07 11.0 255274.91 ACTIVITY TOTAL 1528207.00 430499.88 26.4 1197707.12 615982.01 172878.89 28.1 443103.12 TOT A L EXPENDITURES 3133079.00 548656.14 17.5 2584422.86 1999490.76 727016.63 36.4 1272474.13 ~ <REVENUE>EXPENDITURE 43464.00- 424579.91- 976.9 381115.91 262050.64- 151427.96- 57.8 110622.68- ERS OUT TO OTHER FUNDS .00 .00 .00 9468.29 .00 9468.29 EXCESS <REVENUE> EXPENDITURE 43464.00- 424579.91- 976.9 381115.91 252582.35- 151427.96- 60.0 101154.39- GLI04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2/D9/99 REVENUES VERSUS EXPENDITURE 16.51. .: . FOR THE ;1 PERIOD 7/98 THROUGH 12/98 C?-O ::7'- :..I SPECIAL ASSESSMENT FUNDS PREVIOUS YEAR ENDING JUNE 30~ CURRENT PERIOD BUDGET ACTUAL PC:RCENT VARIANCE ACTUAL ACTUAL PERCC:NT VARIANCE FISCAL YR Y-T-D ........REVENUES******* SPECIAL BC:NEFITS ASSESSMENTS 254580.00- 128526.65. 50.5 126053.35. 276342.55- 128321.78- 46.4 148020.i7- USES OF MONEY AND PROPERTY 10300.00- 4691.75. 45.6 5608.25- 15100.80- .00 15100.80- OTHER SOURCES OF REVENUE 2000.00- .00 2000.00- 2026.04- .00 2026.04. TOTAL REVENUE 266880.00- 133218.40- 49.9 133651.60- 293469.39- 128321.78- 43.7 165147.61- ~EXPENDITURES'" ..;. J. J. J. GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLI C SAFETY: TRFC SIGS/STRC:ET LIGHTING 130987.00 31931.00 24.4 99056.00 114852.44 36046.00 31.4 78806.44 ACTIVITY TOTAL 130987.00 31931.00 24.4 99055.00 114852.44 36046.00 31.4 78305.t.4 TRANSPORTATION: PUBLI C WQRKS 4229.00 937.40 22.2 3291.50 3578.12 1552.01 43.7 2015.2 STREET TREE M~INTENANCE 9600.00 2713.17 28.3 6885.83 4084.90 1992.26 48_8 2092.6... STRC:ET LANDSCAPE MAINTENANCE 128770.00 41922.55 32.6 86847.45 103582.99 59549.83 57.5 44033.15 ACTI V I1Y TOTAL 142599.00 45573.12 32.0 97025.88 111246.01 63104.10 56.7 48141.91 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: . COMMUNITY DEVELOPMENT: ENGINEERING 3980.00 2957.04 74.3 1022.96 3465.00 3465.00 100.0 .00 ACTIVITY TOTAL 3980.00 2957.04 74.3 1022.96 3465.00 3465.00 100.0 .00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS .00 .00 .00 27115.00 7815.00 28.8 19300.00 STREET CoNSTRUCTION/IMPROVMT .00 .00 .00 48938.90 .00 48938.90 ACT! VITY TOTAL .00 .00 .00 76053.90 7815.00 10.3 68238.90 TOT A L EXPENDITURES 277566.00 80461.16 29.0 197104.84 305617.35 110430.10 36.1 195187.25 EXCESS<REVENUE>EXPENDITURE 10686.00 52757.24- 493.7- 63443.24 12147.96 17891.68- 147.3- 30039.64 EXCESS <REVENUE> EXPENDITURE 10686.00 52757.24- 493.7- 63443.24 12147.96 17891.68- 147.3- 30039.64 . GLl OLC THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/C9/99 REVENUES VERSUS EXPENDITURE 15.53.06 FOR THE PERIOD 7/98 THRDUGH 12/98 ;2/ .-" 11 ..- .0.- ./ . CAPITAL IMPROVEMENT FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30. 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D AA^^^~~AREVENUES******* USES OF MONEY AND PROPERTY .00 189499.14- 189499.14 .00 .00 .00' OTH~R SOURCES OF REVENUE 10808817.00- 311344.98- 2.9 10497472.02- 615328.94- 51796.03- 8.4 563532.91- TOTAL REVENUE 10808817,00- 500844.12- 4.6 10307972.88- 615328.94- 51796.03- 8.4 563532.91- ~EX?ENoITURES******* GENE~4L GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUSLI C SAFETY: TRANSPORT A TI ON: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 14500.00 14737.06 101. 6 237.06- .00 .00 .00 ACTIVITY TOTAL 14S00.00 14737.06 101.6 237.06- .00 .00 .00 COMMUNITY DEVELOPMENT: PLANNING 16226.00 14S.14 .9 16080.86 3248.58 .00 3248.53 ACTI V ITY TOTAL 16225.00 145.14 .9 16080.86 3248.58 .00 3248.58 ~41 IK'RDVE"ENT PROJECTS, '~RAL CIP PROJECTS 982334.00 87782.68 8.9 894551.32 22818.06 17421. 55 76.3 5396.51 OMMUNITY IMPROVEMENTS 94024.00 .00 94024.00 12000.62 180.00 1.5 11820.62 PARKS 2768475.00 67003.93 2.4 2701471.07 86242.07 9168.78 10.6 77073.29 STREET CoNSTRUCTIoN/IMPRoVMT 6936789.00 141676.17 2.0 6795112.83 419692.52 49525.00 11.8 370167.52 ACTIVITY TOTAL 10781622.00 296462.78 2.7 10485159.22 540753.27 76295.33 14.1 464457.94 TOT A L EXPENDITURES 10812348.00 311344.98 2.9 10501003.02 544001.85 7629S.33 14.0 467706.52 EXCESS<REVENUE>EXPENDITURE 3531.00 189499.14- 5366.7- 193030.14 71327.09- 24499.30 34.3- 95826.39- TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 27964.95- .00 27964.95- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 42633.31 10785.45 25.3 31847.85 EXCESS <REVENUE> EXPENDITURE 3531.00 189499.14- 5356.7- 193030.14 _ 566S8.73- 35284.76 62.3- 91943.49- . . GLl 04C THE'CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/09/99 ' REVENUES VERSUS EXPENDITURE 16.52.20 FOR THE ,. /./ PERIOD 7/98 THROUGH 12/98 /'/ .-/ 0.) c.-', I -.J , . INTERNAL SERVICE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D. 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D .....A.AREVENUES******* USES OF MONEY AND PROPERTY 39604.00- 11928.19- 30.1 27675:81- 26288.45- .00 26288.45- CH4RGES FOR SERVICES 737923.00- 324091. 80- 43.9 413831. 20- 241988.51- 121297.84- 50.1 120690.67- OTHER SOURCES OF REVENU~ 30000.00- 895.06- 3.0 29104.94- 6782.95- 50.00- .7 6732.95- TOTAL REVENUE 807527.00- 336915.05- 41.7 470611. 95- 275059.91- 121347.84- 44.1 153712.07- ~EXPENDITURESA.A;,;-;.A GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 728134.00 217268.15 29.8 510865.85 235476.79 60715.29 25.8 174761.50 ACTIVITY TOTAL 728134.00 21726B.15 29.8 510865.85 235476.79 60715.29 25.8 174761.50 PUBU C SAFDY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IM?ROVEMENT PROJECTS: TOT A L EXPENDITURES 728134.00 21726B.15 29.8 510855.85 235476.79 60715.29 25.8 174761.50 ~S<R'V'NUE>EXPENDjT"?~ 79393.00- 119646.90- 150.7 40253.90 39583.12- 60632.55- 153.2 21049.43 55 <REVENUE> EXPENDITURE 79393.00- 119646.90- 150.7 40253.90 39583.12- 60632.55- 153.2 21049.43 . . GLl04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2/09/99 REVENUES VERSUS EXPENDITURE 16.5V:: FOR THE PERIOD' 7/98 THROUGH 12/98 ;2'/ ~ c:ztj ENTERPRISE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30~ BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D AAAA-AAAREVENUES******* USES OF M~NEY AND PROPERTY 1827244.00-" 398646.76- 21.8 1428597.24- 1590062.53- 368354.65- 23.2 1221707.88- TOTAL REVENUE 1827244.00- 398646.76- 21.8 1428597.24- 1590062.53- 368354.65- 23.2 1221707.88- ~EXPENDITURES~ GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1719394.00 66381. 94 3.9 1653012.06 1272423.93 69132.29 5.4 1203291.64 AD~IN SERVICES 3435.00 .00 3435.00 4415.00 1050.00 23.8 3365.00 ACTIVITY TOTAL 1722829.00 66381.94 3.9 1656447.06 1276838.93 70182.29 5.5 1206556.64 PUBU C SArETY: TRANSPORT A TI ON: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IM?ROVEMENT PROJECTS: TOT A L EXPENDITURES 1722829.00 66381.94 3.9 1656447.06 1276838.93 70182.29 5.5 1206656.64 EXCESS<REVENUE>[XPENDITURES 104415.00- 332264.82- 318.2 227849.82 313223.60- 298172.35- 95.2 15051. 24. TRANSrERS IN FROM OTHER FUNDS .00 .00 .00 8384.92- .00 8384.92- EXCESS <REVENUE> EXPENDITURE 104415.00- 332264.82- 318.2 227849.82 321608.52- 298172.36- 92.7 234. .