The URL can be used to link to this page

Home My WebLink About4.05 FinRpt 3-97 ':.= ." :CITY CLERK File # DBJ[3J[Q]-0[Q] ", .... . AGENDA STATEMENT CITY COUNCIL MEETING DATE: (April 15, 1997) SUBJECT: Financial Report For the Month of March 1997 fsJ.Report Prepared by: Paul S. Rankin, Assistant City Manager EXJITBITS ATTACHED: Balance Sheet and Income Statements for the Period Ending March 31, 1997 RECOMMENDATION: ~~ccePt 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 March. 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 March 1997 Revenue and Expenditure Report Through the first nine 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 $672,829, which was an approximately $132,000 increase over the prior month due to the collection of final sales tax receipts from the Christmas season. 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 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 March are comparable to what occurred in the first nine months of the previous Fiscal Year. The City had collected through March 1997 approximately 67% of the total budgeted General Fund Revenues compared to approximately 62% in the prior Fiscal Year. Taxes: Property Taxes to date are comparable to the amount received in the same period in the prior year. Through March 1997, the City had collected approximately 76% of the budgeted sales tax revenues compared to approximately 69% for the same period of the previous fiscal year. The City has received preliminary data for the sales tax collected during the Christmas Quarter. A review of specific categories of retail and commercial businesses displays some of the factors which have . .. impacted total Sales Tax revenue. The Autos and Transportation Category has remained strong with sales :. ~~~~~~~~~~~~:~~~~~~~e~~i~:~~~~~~~o~~e_s~~:~~e~~~~~~_b:_~~~~a~~~~~~!: COPIES TO: ITEM NO. 4., G\montbfs\fy97\0397 ag.doc addition, sales in the General Consumer Goods Category increased by 6% from the Fourth Quarter of 1995 due to strong Christmas sales. These were offset by declines in the Business & Industry, Building & Construction and Food & Drug categories. Some of the declines in categories such as Food & Drug are probably attributable to increased regional competition. Staff will be meeting in the near future wi,th the City's sales tax consultant to discuss the current trends. .. 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 Pemlits. As of March 1997 the City had collected 69% 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 March 31, 1997 the City had collected $76,807 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 62% of Budget compared to 65% 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 131 % of Budget compared to 84% 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 paste_ several years. General Fund Expenditures Overall, through the month of March expenditures in the General Fund totaled $10,234,167 and represented approximately 63% of the total budgeted expenditures in the General Fund. Of this amount, a total of $660,625 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 March 1997 was close the amounts expended for the same period in the prior Fiscal Year. As of March 31, 1996, the City had expended 62% of the General Fund Operating Budget compared to 66% 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 March 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 55% of Budget compared to 61 % in the prior Fiscal Year. The .e 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 56% 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 63% of Budget compared to 66% 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 charges were processed earlier than in the current year. Capital Improvement Projects: : Expenditures to date are 74% of Budget compared to 31 % 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. It is recommended that the City Council receive and file these reports as authorized by Section 41004 of the California Government Code. :. .. -3- City of Dublin 1996-97 YTD Revenues and Budget Comparison For the Period Ending March 31, 1997- Unaudited . I ------~~---~ --~--- Total General Fund Revenues 67% 2% Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals -. Intergovernmental from State Charges for Services .FY 96/97 eFY 95/96 Other Revenues 0% 20% 40% 60% 80% 100% 75% of Year Complete FY 96197 FY 96197 %of FY 95196 % of Total for Budget YTD Actual Budget YTD Actual FY 95196 Property Taxes 4,042,000 2,225,732 55% 2,190,117 56% Sales Taxes 6,480,000 4,922,161 76% 4,696,504 69% Transient Occupancy Taxes 176,000 142,921 81% 91,357 46% Franchise Taxes 709,800 371,740 52% 267,734 44% Licenses and Permits 873,400 601,099 69% 272,449 58% Interest and Rentals 1,259,600 775,313 62% 617,177 49% Intergovernmental from State 1,085,650 808,110 74% 743,685 67% -. Charges for Services 1,393,510 862,004 62% 887,071 65% Other Revenues 150,660 197,916 131% 125,305 84% Total General Fund Revenues 16,170,620 10,906,996 67% 9,891,399 62% 4/8/97 13:49 g:\monthfsfy97\exceiVs.xls I I General Government J Civic Center Lease 100% Police . FY 96/97 Fire 74% &I FY 95/96 Other Public Safety Transportation Health and Welfare Culture & Community Services . Community Development Capital Improv. Projects 740 .- .. 0% 20% 40% 60% 80% 100% 75% of Year Complete 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,766,311 1,158,736 66% 1,047,047 70% Civic Center Lease 1,601,985 1,496,712 93% 1,499,418 100% Police 4,016,642 1,935,109 48% 1,827,477 52% Fire 3,195,294 2,066,461 65% 2,205,171 74% Other Public Safety 256,071 80,103 31% 32,151 16% Transportation 697,277 398,501 57% 365,731 53% Health and Welfare 14,000 7,901 56% 0 0% Culture and Community Services 2,000,640 1,256,473 63% 1,216,046 66% Community Development 1,798,334 1,173,546 65% 1,215,227 68% Capital Improvement Projects 895,908 660,625 74% 99,224 31% -. ":- - . Total General Fund Expenses 16,242,462 10,234,167 63% 9,507,492 66% . -. 418/97 13:49 g:\monlhfs\fy97\excelVs.lds ;J, } . CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 1997 . Prepared by The Finance Department April 8, 1997 . 3 EXHIBIT 1 GL102 CITY OF DUBLIN PAGE 1 4/08/97 BALANCE SHEET 12.27.33 FOR THE PERIOD 7/96 THROUGH 3/97 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOTALS. REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONLY --- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 3D, 1 ASSETS :ASH 3139099.98- 1700785.08 261233.51 569197.70 50017.93 557865.76- 548241.45- :ASH ~ITH FISCAL AGENT 132608.16 132608. 16 12664 1. 25 JNAMORTIZED BOND DISCOUNT NVESTMENTS AT COST 25974435.46 25974435.46 22726218.93 :ECEIVABLES:TAXES ACCOUNTS (NET ) 169903.57 37760.05 98536.69 306200.31 437477.67 INTEREST ASSESSMENTS RENTS NOTES UE FROM OTHERS 21596.01 21596.01 5967.43 NVENTORY AT COST REPAID ITEMS 4237.15 4237.15 8305.45 IXED ASSETS MOUNTS TO BE PROVIDED 2090500.00 2090500.00 2090500.00 TOTAL ASSETS 23009476.20 1760141.14 261233.51 66m4.39 2273126.09 27971711.33 24846869.28 lAB, FND BAL, RETND EARNINGS 184703.S. :POSITS FOR PRIVATE DEVELPMNT 414896.36- 414896.36- :POSITS FOR AB1600 FEES 975571.42- 975571.42- 291271.48- . :POS ITS OTHERS 566995.71- 98536.69- 665532.40- 632934.20- ~YABLES:ACCOUNTS 184403.30- 115810.85- 722.20- 300936.35- 254764.25- INTEREST PAYROLL 46438. 03- 46438.03- 40052.19- JE TO OTHERS 150.00- 150.00- 74902.34- ,8T INSTRUMENTS PAYABLE 2208000.00- 220800o.00~ 2208000.00- TOTAL L1ABILTIES 1212883.40- 115810.85- 722.20- 1074108.11- 2208000.00- 4611524.56- 3686628.44- JND BALANCES 21796592.80- 1644330.29- 260511 .31- 406373.72 65126.09- 23360186.77- 21160240.84- TOTAL FUND EQUITY 21796592.80- 1644330.29- 260511.31- 406373.72 65126.09- 23360186.77- 21160240.84- JTAL L1AB, FNO BAL, RETD EARNS 23009476.20- 1760141.14- 261233.51- 66m4.39- 2273126.09- 27971711.33- 24846869.28- :. .. l{ GL102 4/013/97 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7196 THROUGH 3/97 . INTERNAL SERVICE FUND ASSETS CASH CASH ~ITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 330699.94 INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES JUE FROM OTHERS INVENTORY AT COST ;>REPAIO ITEMS ~IXED ASSETS ~MOUNTS TO BE PROVIDED 451187.86 TOTAL ASSETS _:.0 BAL, RETND EARNINGS 1I::,.. ." S FOR PRIVATE DEVELPMNT )EPOS I TS OTHERS 'AYABLES:ACCOUNTS INTEREST PAYROLL lUE TO OTHERS lEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES 'UNO BALANCE :ONTRIBUTlONS NVESTMENTS IN FIXED ASSETS .ETAINED EARNINGS TOTAL FUND EQUITY 781887.80 431816.35- 350071.45- 781887.80- ENTERPRISE FUNDS 1016.96- 1734321.88 20084069.28 21817374.20 16265000.00- 16265000.00- 442484.20- 5109890.00- 781887.80- 21817374.20- 5552374.20- -OTAL LIAB,FND BAL, RETD EARNS . 5 FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP 510205.13 510205.13 510205.13- 510205.13- 5327970.26 5327970.26 5327970.26- 5327970.26- 510205.13- 5327970.26- PAGE 1 10.30.03 TOT A L S MEMORANDUM ONLY --- CURRENT JUNE 3D, 1996 329682.98 1734321.88 21045462.27 5327970.26 28437437.39 21592970.26- 21592970.26- 874300.55- 5459961.45- 510205.13- 6844467.13- 329815.01 1758638.80 21361185.01 2955726.35 26405365.17 19925726.35- 19925726.35- 639400.77- 5347612.75- 492625.30- 28437437.39- 26405365.17- 6479638.82- ~L 1 O4C 4/08/97 *******REVENUES******* ROPERTY TAXES ALES TAX ~AL PROPERTY TRANSFERS ~A~SIENT OCCUPANCY TAX ~ANCHISE TAXES ICE~SES & PERMITS INES & FORFEITURES 3ES OF MONEY AND PROPERTY ,TERGOVERNMENTAL FROM STATE IARGES FOR SERVICES ~HER SOURCES OF REVENUE TOTAL REVENUE "*****EXPENDITURES******* NERAL 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 1060 ELECTIONS COST CENTER 1070 ACTIVITY TOTAL all C SAFETY: ~OLICE 2010 :ROSSING GUARDS COST 2020 \NIMAL CONTROL 2030 )ISASTER PREAPREDNESS 2050 'IRE SERVICES JPA 2060 ACTIVITY TOTAL ,NSPORTATlON: 'UBLIC WORKS 3010 ;TREET MAINTENANCE 3020 ;TREET TREE MAINTENANCE 3040 ~TREET LANDSCAPE MAINT. 3050 ACTIVITY TOTAL LTH & IJELFARE: 'ASTE MANAGEMENT HILD CARE 5020 5030 ACTIVITY TOTAL TURE & LEISURE SERVICES: IBRARY SERVICES 8010 ULTURAL ACTIVITIES 8011 ERITAGE CENTER 8012 UBLIN CEMETERY 8013 t:, THE CITY OF DUBLIN STATEMENT SHOIJING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/96 THROUGH 3/97 BUDGET 3968400.00- 6480000.00- 73600.00- 176000.00- 709800.00- 873400.00- 36000.00- 1259600.00- 1085650.00- 1393510.00- 114659.75- 16170619.75- 102401.00 128264.00 297973.00 154181.00 607227.00 321500.00 1601985.00 133550.00 21215.00 3368296.00 4016642.00 43000.00 180286.00 32785.00 3195294.00 7468007.00 320887.00 128200.00 48580.00 199610.00 697277.00 2000.00 12000.00 14000.00 205874.00 12500.00 51960.00 17160.00 GENERAL REVENUE CURRENT PERIOD ACTUAL PERCENT 2158152.60- 4922161.18- 67579.33- 142921.09- 371739.58- 601098.63- 30954.67- m312.84- 808110.27- 862003.76- 166961.23- 10906995.18- 27346.97 95757.52 195333.20 127580.48 384359.89 205411.00 1496712.41 1 16107.85 6838.88 2655448.20 1935109.40 23155.79 36152.00 20794.58 2066460.81 4081672.58 210479.18 28894.37 22191. 70 136935.90 398501. 15 1900.50 6000.00 7900.50 102937.00 10000.00 32721.28 10899.45 54.4 76.0 91.8 81.2 52.4 68.8 86.0 61.6 74.4 61.9 145.6 67.4 26.7 74.7 65.6 82.7 63.3 63.9 93.4 86.9 32.2 78.8 48.2 53.9 20.1 63.4 64.7 54.7 65.6 22.5 45.7 68.6 57.2 95.0 50.0 56.4 50.0 80.0 63.0 63.5 FUND VARIANCE 1810247.40- 1557838.82- 6020.67- 33078.91- 338060.42- 272301.37- 5045.33- 484287.16- 2m39.73- 531506.24- 52301.48 5263624.57 - 75054.03 32506.48 102639.80 26600.52 222867.11 116089.00 105272.59 17442.15 14376.12 712847.80 2081532.60 19844.21 144134.00 11990.42 1128833.19 3386334.42 110407.82 99305.63 26388.30 62674.10 298m.85 99.50 6000.00 6099.50 102937.00 2500.00 19238.72 6260.55 ACTUAL FISCAL YR 3867613.84- 6760413.09- 60181.18- 198284.00- 607146.84- 466198.72- 38792.80- 1268885.15- 1102495.65- 1372959.58- 110803.95- 15853774.80- .00 127389.95 275833.29 161933.22 495172.80 334374.72 1499521.58 101710.52 563.52 2996499.60 3540387.58 43292.88 126363.14 27045.45 29m19.09 6714808.14 304830.22 140949.59 48192.39 197364.32 691336.52 .00 .00 .00 194188.00 17500.00 41860.33 16075 .33 PAGE 1 9.49.1~ e PREVIOUS YEAR ENDING JUNE 30, 1996 ACTUAL PERCENT VARIANCE Y-T-D 2150485.68- 4696503.53- 39630.69- 91357.00- 26m4.01- 272449.39- 28048.01- 617177.21- 743685.29- 887071.47- 97257.34- 9891399.62- 12.50 91651.82 199310.38 85211.06 343556.21 230669.16 1499417.58 96072.30 563.52 2546464.53 1827477.15 25006.59 - .00 7144.48 2205171.00 4064799.22 217499.90 458.81 21720.94 126051.65 365731.30 .00 .00 .00 97094.00 10000.00 26829.26 11868.93 55.6 69.5 65.9 46.1 44.1 58.4 72.3 48.6 67.5 64.6 87.8 62.4 71.9 72.3 52.6 69.4 69.0 100.0 94.5 100.0 85.0 51.6 57.8 26.4 74.1 60.5 71.4 .3 45.1 63.9 52.9 50.0 57.1 64.1 73.8 1717128.16- 2063909.56- 20550.49- 106927.00- 339412.83- 193749.33- 10744.79- 651707.94- 358810.36- 485888.11- 13546.61- 5962375.18- 12.50- 35738. 13 76522.91 76722.16 151616.5re 103705.5 .. 104.00 5638.22 .00 450035.07 1712910.43 18286.29 126363.14 19900.97 m548.09 2650008.92 87330.32 140490.78 26471.45 71312.67 325605.22 .00 .00 .00 97094.00 7500.00 15031.07. 4206.40 "T " -. GU04C THE CITY OF DUBLIN STATEHENT SH~ING PAGE 2 4/08/97 REVENUES VERSUS EXPENDITURE 9.49.18 FOR THE PERIOD 7/96 THROUGH 3/97 . .- GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D PARK MAINTENANCE 8020 573868.00 344037.37 60.0 229830.63 554536.91 358659.56 64.7 195877.35 COMMUNITY CABLE TV 8030 33916.00 26576.72 78.4 7339.28 23736.00 21236.00 89.5 2500.00 R=CREATION ADMIN. 8040 242784.00 167509.22 69.0 75274.78 190175.44 133566.87 70.2 56608.57 PLAYGROUNDS 8045 109528.00 71660.60 65.4 37867.40 99908.83 72379.93 72.4 27528.90 SHANNON CENTER 8050 134604.00 95245.60 70.8 39358.40 128665.35 89200.85 69.3 39464 .50 PRESCHOOL 8055 52070.00 34500.64 66.3 17569.36 48241.56 34116.70 70.7 14124.86 EENS PROGRAM 8060 35294.00 18953.74 53.7 16340.26 29512.30 21919.75 74.3 7592.55 ADULT SPORTS 8065 62718.00 35499.41 56.6 27218.59 59974.79 40822.58 68.1 19152.21 YOOTH SPORTS 8066 37176.00 30811.37 82.9 6364.63 33593.09 28558.20 85.0 5034.89 SPECIAL EVENTS 8070 38930.00 24338.00 62.5 14592.00 33694.49 20337.77 60.4 13356.72 SEt/lOR CENTER 8080 112578.00 59572.77 52.9 53005.23 101733.54 72613.01 71.4 29120.53 RECREATION INSTRUCTION 8090 80763.00 62355.21 77.2 18407.79 76940.68 57394.08 74.6 19546.60 ACUATICS 8100 198917.00 128854.51 64.8 70062.49 196m.22 119448.80 60.7 m24.42 ACTIVITY TOTAL 2000640.00 1256472.89 62.8 744167.11 1847109.86 1216046.29 65.8 631063.57 COMMUNITY DEVELOPMENT: PLANNING 9010 732994.00 457884.94 62.5 275109.06 838445.66 594367.57 70.9 244078.09 BUILDING SAFETY 9020 385919.00 241363.86 62.5 144555.14 263771 .36 158789.27 60.2 104982.09 ENGINEERING 9030 563425.00 396523.56 70.4 166901.44 569323.23 384207.77 67.5 185115.46 ECONOMIC DEVELOPMENT 9040 115996.00 m73.33 67.0 38222.67 106703.40 77862.59 73.0 28840.81 ACTI VITY TOTAL 1798334.00 1173545.69 65.3 624788.31 1778243.65 1215227.20 68.3 563016.45 ~L IHPROVEMENT PROJECTS: RAL CIP PROJECTS 93NN 116113.00 30706.69 26.4 85406.31 73453.55 23970.06 32.6 49483.49 ~~UNITY IMPROVEMENTS 94NN 61300.00 7928.39 12.9 53371.61 84890.76 68330.30 80.5 16560.46 PARKS 95NN 488645.00 436858.81 89.4 51786.19 59292.04 6923.29 11.7 52368.75 STREET CONSTRC/IMPROVMT 96NN 229850.00 185130.80 80.5 44719.20 104607.01 .00 104607.01 ACTIVITY TOTAL 895908.00 660624.69 73.7 235283.31 322243.36 99223.65 30.8 223019.71 TOT A L EXPENDITURES 16242462.00 10234165.70 63.0 6008296.30 14350241.13 9507492.19 66.3 4842748.94 EXCESS [REVENUE>EXPENDITURES 71842.25 672829.48- 936.5- 744671.73 1503533.67- 383907.43- 25.5 1119626.24- TRAt/SFERS IN FROM OTHER FUNDS .00 .00 .00 38508.75- 1015.00- 2.6 37493.75- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 18673.28 .00 18673.28 EXCESS [REVENUE> EXPENDITURE 71842.25 672829.48- 936.5- 744671. 73 1523369.14- 384922.43- 25.3 1138446.71- . '.,--"" " 1 GL1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/08/97 REVENUES VERSUS EXPENDITURE 12.20.21 FOR THE PERIOD 7/96 THROUGH 3/97 SPECIAL REVENUE FUNDS . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D '*******REVENUES******* .ALES TAX 136000.00- 115449.86- 84.9 20550.14- 141116.52- 104956.10- 74.4 36160.42- INES & FORFEITURES 24500.00- 15674.15- 64.0 8825.85- 24330.57- 16195.15- 66.6 8135.42- SES OF MONEY AND PROPERTY 76830.00- 39.84- .1 76790.16- 89945.79- .00 89945.79- NTERNGOVERNMENTAL FROM STATE 523290.00- 406214.51- 77.6 117075.49- 536724.31- 358575.37- 66.8 178148.94' NTERGOVERNMENTAL FROM COUNTY 102655.00- 117693.00- 114.6 15038.00 126726.00- 97483.00- 76.9 29243.00- NTERGOVERNMENTAL FROM FEDERAL 386481.00- 14514.28- 3.8 371966.72- 1908174.78- 800624.51- 42.0 1107550.27- KARGES FOR SERVICES 764600.00- 398156.32' 52.1 366443.68- 520879.80- 416842.37' 50.8 404037.43- THER SOURCES OF REVENUE 130350.00- 36549.00' 28.0 93801. DO. 568753.12- 568753.12- 100.0 .00 TOTAL REVENUE 2144706.00- 1104290.96- 51.5 1040415.04 - 4216650.89- 2363429.62- 56.0 1853221.27' -*****EXPENOITURES******* ,NERAL GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT .00 .00 .00 244.70 244.70 100.0 .00 ACTIVITY TOTAL .00 .00 .00 244.70 244.70 100.0 .00 IBlI C SAFETY: POLICE 66061. 00 11805.39 17.9 54255.61 5899.29 1760.26 29.8 4139.03 TRAFFIC SIGNALS 109327.00 43905.72 40.2 65421.28 85416.04 44801.70 52.5 40614.34 ACTIVITY TOTAL 175388.00 55711. 1 1 31.8 119676.89 91315.33 46561.96 51.0 44753.37 ANSPORTATlON: PUBLIC \JORKS 321. 00 .00 321.00 1.45 1.45 100.0 0<. STREET MAINTENANCE 198960.00 71518.75 35.9 127441.25 163324.71 65420.51 40.1 97904: {;:, STREET S\JEEPING 75600.00 44804 .29 59.3 30795.71 69954.11 46663.30 66.7 23290.81 .', ACTIVITY TOTAL 274881.00 116323.04 42.3 158557.96 233280.27 112085.26 48.0 121195.01 ALTH & \JELfARE: ~ASTE MANAGEMENT 743135.00 381259.75 51.3 361875.25 1183933.08 347941.44 29.4 835991 .64 ACTIVITY TOTAL 743135.00 381259.75 51.3 361875.25 1183933.08 347941. 44 29.4 835991.64 .. cTURE & LEISURE SERVICES: ~ARK MAINTENANCE .00 6437.41 6437.41- .00 .00 .00 .' ACTIVITY TOTAL .00 6474.77 6474.77- .00 .00 .00 ~MUNITY DEVELOPMENT: ., .- : 'LANN I NG 1275.00 .00 1275.00 .00 .00 .00 eNGINEERING 98102.00 24797.48 25.3 73304.52 51425.60 45438.70 88.4 5986.90 ., ACTIVITY TOTAL 99377.00 24797.48 25.0 74579.52 51425.60 45438.70 88.4 5986.90 .' 'ITAL IMPROVEMENT PROJECTS: .. " - ,ENERAL CIP PROJECTS .00 .00 .00 7089.00 .00 7089.00 :OMMUNITY IMPROVEMENTS 168510.00 7936.41 4.7 160573.59 80111.16 46517.16 58.1 33594.00 . . )ARKS 553872.00 26274.75 4.7 527597.25 211220.20 203981.38 96.6 7238.82 .. ; :TREET CONSTRUCTION/IMPROVMT 635540.00 274454.29 43.2 361085.71 1967504.82 1180589.84 60.0 786914.98 ACTIVITY TOTAL 1357922.00 308665.45 22.7 1049256.55 2265925.18 1431088.38 63.2 834836.80 ) TAL EXPEND ITURES 2650703.00 893231.60 33.7 1757471.40 3826124.16 1983360.44 51.8 1542763.72 ESS [REVENUE>EXPENOITURE 505997.00 211059.36- 41.7- 717056.36 390526.73- 380069.18- 97.3 10457.55' NSFERS IN FROM OTHER FUNDS .00 .00 .00 19860.59- 14897.00- 75.0 4963.59- NSFERS OUT TO OTHER FUNDS .00 .00 .00 28838.30 15912.00 55.2 12926.30 -, ESS [REVENUE> EXPENDITURE 505997.00 211059.36- 41. 7- 717056.36 381549.02- 379054.18- 99.3 2494.~.-. -. fj '. GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/06/97 REVENUES VERSUS EXPENDITURE 9.59.45 FOR THE PERIOO 7/96 THROUGH 3/97 :. SPECIAL ASSESSMENT FUNDS CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ~----*-*REVENUES-**--** ;PECIAL 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--****- ,ENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 'UBU C SAFETY: TRFC SIGS/STREET LIGHTING 130569.00 51997.09 39.8 78571.91 180611.18 128007.70 70.9 52603.48 ACT I V ITY TOTAL 130569.00 51997.09 39.8 78571.91 180611.18 128007.70 70.9 52603.48 -RAN SPORT AT! ON: PUBLIC \.laRKS 7688.00 2398.48 31.2 5289.52 3947.86 2766.61 70.1 1181.25 STREET TREE MAINTENANCE 8470.00 1723.32 20.3 6746.68 8867.39 3269.04 36.9 5598.35 STREET LANDSCAPE MAINTENANCE 113800 . 00 79831.65 70.2 33968.35 105578.03 64209.63 60.8 41368.40 ACTIVITY TOTAL 129958.00 83953.45 64.6 46004.55 115393.28 70245.28 59.3 48148.00 IEALTH & \.lELFARE: :. :ULTURE & LEISURE SERVICES: ~Y DEVELOPMENT: "". . ERING 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 26205.62 95.3 1300.01 STREET CONSTRUCTION/IMPROVMT 103000.00 103106.75 100.1 106.75- 7649.54 636.53 8.3 7013.01 : ACTIVITY TOTAL 113000.00 111174.67 98.4 1825.33 35155.17 26842.15 76.4 8313.02 " o TAL EXPENDITURES 377087. DO 250148.65 66.3 126938.35 337244.89 228123.09 67.6 109121.80 XCESS[REVENUE>EXPENDITURE 118147.00 126206.15 106.8 8059.15- 1315.67 77186.75 5866.7 75871.08- : XCESS [REVENUE> EXPENDITURE 118147.00 126206.15 106.8 8059.15- 1315.67 77186.75 5866.7 75871.08- .,. .' .-. ... . q GL1 O4C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/08/97 REVENUES VERSUS EXPENDITURE 10.12.3Q FOR THE PERIOO 7/96 THROUGH 3/97 CAPITAL IMPROVEMENT FUND -. CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D '*******REVENUES******* iTHER 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- ******EXPENDITURES******* ENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 JBLI C SAFETY: 'l.ANSPORT A TI ON: :ALTH & WELFARE: JLTURE & LEISURE SERVICES: JMMUNITY DEVELOPMENT: \PITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 108500.00 7978.75 7.4 100521.25 8021.77 4218.00 52.6 3803.77 STREET CONSTRUCTION/IMPROVMT 789421.00 299858.28 38.0 489562.72 707259.92 311832.41 44.1 395427.51 ACTIVITY TOTAL 897921.00 307837.03 34.3 590083.97 715281.69 316050.41 44.2 399231.28 o TAL EXPENDITURES 897921.00 307837.03 34.3 590083.97 715281.69 316050.41 44.2 399231. 28 .CESS[REVENUE>EXPENDITURE 27500.00 237407.48 863.3 209907.48- 124329.38- 316050.41 254.2- 440379.79- ANSFERS OUT TO OTHER FUNDS .00 .00 .00 29531.04 .00 29531.04 410848.7-:. :ESS [REVENUE> EXPENDITURE 27500.00 237407.48 863.3 209907.48- 94798.34- 316050.41 333.4- ..'. . ~ .- "~ e.:.-:-. . . - . - - . -, - . , '0 Gl104C " THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/00/97 REVENUES VERSUS EXPENDITURE 10.16.45 FOR THE PER I 00 7/96 THROUGH 3/97 .. TRUST/AGENCY FUND CURRENT PERloo PREVIOUS YEAR ENDING JUNE 30, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FI SCAl 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- 3737.56- 31.2 8260.04- TOTAL REVENUE .00 120345.73- 120345.73 246627.10- 121052.31- 49.1 125574.79- *******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: TRANSPORT A TI ON: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY OEVELOPMENT: 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- 111532.19 794.2- 125574.79- EXCESS (REVENUE) EXPENDITURE .00 112123.77 112123.77- 14042.60- 111532.19 794.2- 125574.79- .. . II ~L1 04C THE CITY OF DUBLIN STATEMENT SHOUING PAG,E 1 4/08/97 REVENUES VERSUS EXPENDITURE 10.03:50 FOR THE <; PERIOO 7/96 THROUGH 3/97 INTERtlAL SERVICE FUND PREVIOUS YEAR EtlDING JUNE 30, 19. CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE Fl SCAL YR Y-T-D *******REVENUES******* SES OF MONEY AND PROPERTY 16300.00- .00 16300.00- 15884.33- .00 15884.33- HARGES FOR SERVICES 216315.00- 156093.63- 72.2 60221.37- 184255.91- 140848.96- 76.4 43406.95- THER SOURCES OF REVENUE 12100.00- 1122.70- 9.3 10977.30- 29894.08- 29894.08- 100.0 .00 TOTAL REVENUE 244715.00- 157216.33- 64.2 87498.67 - 230034.32- 170743.04- 74.2 59291.28- t*****EXPENDITURES******* :NERAL GOVERNMENT ACTIVITIES: NOtl-DEPARTMENTAL 288082.00 101616.98 35.3 186465.02 184660.68 125287.99 67.8 59372.69 ACTIVITY TOTAL 288082.00 101616.98 35.3 186465.02 184660.68 125287.99 67.8 59372.69 JBL I C SAFETY: :ANSPORT A TI ON: ,ALTH & IJELFARE: JLTURE & LEISURE SERVICES: ~MUNITY DEVELOPMENT: PITAL IMPROVEMENT PROJECTS: o TAL EXPENDITURES 288082.00 101616.98 35.3 186465.02 184660.68 125287.99 67.8 59372.69 .CESSrREVENUE~EXPENDITURE 43367.00 55599.35- 128.2- 98966.35 45373.64- 45455.05" 100.2 81.41 CESS rREVENUE~ EXPENDITURE 43367.00 55599.35- 128.2- 98966.35 45373.64- 45455.05- 100.2 81.41 ". -eo:. .. . /;- GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/00/97 REVENUES VERSUS EXPENDITURE 10.08.13 FOR THE PERIOD 7196 THROUGH 3/97 . ENTERPRISE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D, 1996 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY 1709285.00- 15564 79.27- 91.1 152805.73- 1594060.99- 1559150.37- 97.8 34910.62- TOTAL REVENUE 1709285.00- 1556479.27- 91.1 152805.73- 1594060.99- 1559150.37- 97.8 34910.62- *******EXPENDITURES******* GENERAL 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 5448.40 78.4 1500.00 ACTIVITY TOTAL 1606370.00 1232286.22 76.7 374083.78 1395455.57 1227775.65 88.0 167679.92 PUBLI C SAFETY: DISASTER PREAPREDNESS .00 .00 .00 1226.33 .00 1226.33 ACTIVITY TOTAL .00 .00 .00 1226.33 .00 1226.33 TRANSPORTA TI ON: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION .00 .00 .00 10125.56 6871.84 67.9 3253.72 SEN I OR CENTER .00 .00 .00 200.00 200.00 100.0 .00 ACTIVITY TOTAL .00 .00 .00 10325.56 7071.84 68.5 3253.72 COMMUNITY DEVELOPMENT: C~ IMPROVEMENT PROJECTS: ~ L EXPENDITURES 1606370.00 1232286.22 76.7 374083.78 1407007.46 1235000.40 87.8 172007.06 t. [REVENUE>EXPENDITURES 102915.00- 324193.05- 315.0 221278.05 187053.53- 324149.97- 173.3 137096.44 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 18673.28- .00 18673.28- EXCESS [REVENUE> EXPENDITURE 102915.00- 324193.05- 315.0 221278.05 205726.81- 324149.97- 157.6 118423.16 .. 1'7;