Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
8.2 Financial Report Format Revised
CITY OF DUBLIN AGENDA STATEMENT CITY COUNCIL .MEETING DATE: ; November 14, 1988 SUBJECT Financial Report - Suggested Format Revisions EXHIBITS ATTACHED : Memorandum, and Attachments from Finance Director dated October 21 , 1988; Sample of Pre-Computerized Finance Report Format for Period ending March 31 , 1988 RECOMMENDATION A Discuss Financial Report Formats and Select Format(s) FINANCIAL STATEMENT: None DESCRIPTION During the last several months, Staff and members of the Council Audit Committee have discussed the possibility of revising the format of the City' s Financial Reports to the City Council. The Committee indicated it was interested in a report that was streamlined, easy to understand and provided a good comparision of actual expenses and revenues versus budget. Since the City is in the process of converting its manual accounting system to a computerized system, it appears that this would be an opportune time to change our financial report format, if a change is to be made. Attached are portions of sample financial reports, which have been prepared by the Finance Director `for your review and consideration. With any of the sample formats, the Finance 'Department will be producing a more detailed report for the City Manager and Department Heads to use for day-to-day Administration of operations. The two major components to ' the attached- reports are the Balance Sheet and Income Statement (i .e. Revenues and Expenditures) . Balance Sheets Two sample Balance Sheets have been prepared, Report IA and IIA. Report . Sample IIA is similar to our current Balance Sheet report, with the exception that it includes the year end Balance Sheet numbers for the previous Fiscal Year for comparative purposes. Sample Report IA has been simplified, in that funds have ' been consolidated by fund type. For example, the column titled "Special! Revenue Funds" consolidates information from the following funds: Traffic Safety, Gas Tax, ' CDBG and others. With either report format, Staff proposes that the previous year comparision be for a comparable period of time i.e. September 30, 1988 to September 30, 1987 rather than June 30, 1988. This change will involve some additional. programming time. Options : 1 Consolidate funds by fund type (IA) 2 Show all funds as previously shown (IIA) Income Statement Several sample Income Statements have been enclosed for Council consideration. All of the sample report formats provided present revenues by major revenue category. This is different than the old format which is shown in the sample of the March 31 , 1988 report. The old format identified each individual revenue source. In addition, all of the revised reports show comparative numbers for the previous Fiscal Year. Once again Staff proposed that this comparision be shown for a comparable period of time. The sample reports do not provide current month data as the old March 31 , 1988 report provided. On the revised formats, the column labeled current period actually refers to cumulative year-to-date figures. For example, the ---------------------------------------------------------------------------- Z COPIES TO: ITEM N0. v September 30th report would show all activity from July 1st through September 30th in this category. With respect to expenditures, Reports IB(a) and IB(b) show expenditures at the Department level consolidated by fund type or by fund respectively. Reports IIB (a) and IIB(b) show expenditures broken down within each department by object classification (i .e. Personnel, Services & Supplies, Contract Services, Capital Overlay) . Report IIB(a) shows the above level of detail consolidated by fund type, Report IIB(b) shows the detail by fund. Report IIIB consolidates all funds as does our current consolidated statement of revenue and expenditures. However, it does provide comparative historical information which the March 31 , 1988 report does not show. This last report can be used on its own or in conjunction with reports IB(a) , IB(b) , IIB(a) , or IIB(b) . The final format shown is labeled IC. This represents a very detailed analysis of revenues and expenses. Although this level of detail may be used by Staff in administering department activities, .it may provide greater detail than the City Councilmembers feel is necessary for their use. This format remains an option if desired by the City Council. It is appropriate to note that the sample provided represents only one department. If the total report were produced, it would total 22 pages. The following summarizes the options .available: Options 1a. Consolidate funds by fund type [IB(a) ] b. Show all funds as previously shown [IB(b) ] Option 2a. Show expenditures by Department [IIB(a) ] b. Show expenditures by Department and by object classification [IIB(b) ] C. Show expenditure by Department, object classification, and by line items, as previously shown (March 31 , 1988 Report) Option 3a. Use Report combining all funds [IIIB] alone b. Use Report combining all funds in conjuction with reports in Option 1 and 2 above C. Do not use Report IIIB Option 4a. Show Revenue by major revenue category (all reports) b. Show Revenue by specific source (March 31 , 1988 Report) Option 5 . Provide all details of revenue and expenses (IC) It is recommended that the City Council review the sample reports and provide direction to Staff. Based on the recommendation, Staff will complete the computerization of the City' s financial reports. October 21, 1988 TO: City Manager Richard Ambrose FROM: Phillip S. Molina SUBJECT: Financial reports comparisons Attached are the seven different financial reports: IA is the Balance sheets for fund types, IIA is the Balance sheets by fund, IB (a) is the Income versus Expenditures no detail. by type, IB(b) is the Income Statement no detail by fund, IIB(a) is the Income Statement details by type, IIB(b) is the Income Statement details by fund, IIIB is the Income Statement all funds combined. r I A Set IA shows the balance sheet information organized by type of fund. For example, all the special revenue funds are combined into the column called Special Revenue Funds. This provides you a condensed view of the City' s financial condition. .102 CITY OF DUBLIN BALANCE SHEET 18.01.00 FOR THE p 1, PERIOD 7/88 THROUGH 9/88 ----IA---- 1 GENERAL SPECIAL SPECIAL CAPITAL ENTERPRISE T O T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS --- MEMORANDUM ONLY --- FUNDS FUNDS FUNDS FUNDS CURRENT JUNE 30, 1988 I ASSETS "Sp 4055591.02- 3142866.63 502673.20 2994574.02- 1819630.77 1584994.44- 47205.04 1MORTIZED BOND DISCOUNT NESITENTS AT COST 13549623.73 7454664.49 21004288.22 20528088.89 ;CEIVABLES:TAXES ACCOUNTS (NET) 383370.15- 3190.05- 12264.48- 3228.44- 402053.12- 289.58- INTEREST ASSESSMENTS 575971.43 575971.43 575971.43 RENTS 140TES 7E FROM OTHERS 510166.10 460497.75 2093692.56 3064356.41 3064356.41 NENTORY AT COST :EPAlb ITEMS 8480.65 8480.65 10070.39 :M ASSETS 8132437.68 8132437.68 8132437.68 IOU27TS TO BE PROVIDED TOTAL ASSETS 9629309.31 3603364.38 1075454.58 913145.94- 17403504.50 30798486.83 32357840.26 .AB, FND BAL, RETND EARNINGS .POSITS FOR PRIVATE DEVELPMNT 498932.89- 498932.89- 406167.97- :POSITS OTHERS 411.00 2200.00 3125.00- 514.00- 1997.00- YABLFS:A000UNTS 343948.89 33944.22 8858.99 155485.49 16694889.19- 16152651.60- 17233164.35- INTEREST PAYROLL 16091.33 16091.33 10340.72- E TO OTHERS 4509.84 484758.00- 1500.00- 2112038.95- 2593787.11- 2593787.11- 3i' INSTRUMENTS PAYABLE 857869.00- 857869.00- 857869.00- TOTAL LIABILTIES 133971.83- 448613.78- 853635.01- 1956553.46- 16694889.19- 20087663.27- 21103326.15- JND BALANCES 9495337.48- 3154750.60- 221819.57- 2869699.40 708615.31- 10710823.56- 11254514.11- NTRIBUTIONS NESIMENTS IN FIXED ASSETS ;TAINED EARNINGS TOTAL FUND EQUITY 9495337.48- 3154750.60- 221819.57- 2869699.40 708615.31- 10710823.56- 11254514.11- ITAL LIAB,FND BAL, RETD EARNS 9629309.31- 3603364.38- 1075454.58- 913145.94 17403504.50- 30798486.83- 32357840.26- P �Co�So�: c�o• eS -� nc�S Fo c J &-Nmi.ve. 'F,>c4 5 tmaiaes Tco` So.-���� � G-as TQ,,c, GL102 CITY OF DUBLIN J 11/u9/08 BALANCE SHEET 17.55.21 FOR THE .� PERIOD 7/88 THROUGH 9/88 ----IA(continued)-- INTERNAL TRUST/AGENCY FIXED ASSETS T 0 T A L S SERVICE FUND GROUP OF --- MEMORANDUM ONLY --- FUND ACCOUNTS CURRENT JUNE 30, 1988 I ASSETS CASH 68726.33 146054.43 / 214780.76 236493.08 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DOE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 8616.00 8616.00 8616.00 FIXED ASSETS 146686.81 143910.63 290597.44 290597.44 AMOUNTS TO BE PROVIDED TOTAL ASSETS 224029.14 146054.43 143910.63 513994.20 535706.52 LIAB, END BAL, RETND EARNDiGS DEPOSITS FOR PRIVATE DEVELMrl DEPOSITS OTHERS 138623.75- 133623.75- 151703.75- PAYABLES:AC000NTS 2681.48 2681.48 INTEREST PAYROLL DUE TO OTHERS 63309.00- 63309.00- 63309.00- DEBT INSTRUMENTS PAYABLE I'0'i'AL LIABILITIES 60627.52- 138623.75- 199251.27- 215012.75- FUND BALANCE 163401.62- 7430.68- 170832.30- 176783.14- CO)FTRIBUTIONS INVESTMENTS IN FIXED ASSETS 143910.63- 143910.63- 143910.63- RETAINED EARNINGS TOTAL FUND EQUITY 163401.62- 7430.68- 143910.63- 314742.93- 320693.77- TOTAL LIAB,FND BAL, RETD EARNS 224029.14- 146054.43- 143910.63- 513994.20- 535706.52- GL,STR1*1 II A Set. II A shows the balance sheet information for the City, on a fund by fund manner. Each fund is represented by its own columnar information. Notice that this set consists of five pages whereas the Previou:s set consists of two pages. GL102 CITY OF DUBLIN fdi*-+ 11/09,'53 BALANCE SHEET 17.56.14 FOR THE --IIA---- ' PERIOD 7/88 THROUGH 9/88 GENERAL TRAFFIC STATE REVENUE CDBG T 0 T A L S REVENUE SAFETY GAS TAX SHARING FUND --- MEMORANDUM ONLY --- FUND FUND FUND FUND CURRENT JUNE 30, 1988 ASSETS CASH 4055591.05- 65065.43 404712.10 , .03 3585813.49- 1751318.05- UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 1354%23.73 13549623.73 12148623.73 RECEIVABLES:TAXES ACCOUNTS (NET) 383370.15- 383370.15- 289.58- INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS 510166.10 510166.10 510166.10 DW:NTORY AT COST PREPAID ITEMS 8480.65 8480.65 10070.39 FIXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS 9629309.28 65065.43 404712.10 .03 10099086.84 10917252.59 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPHNT 498932.89- 498932.89- 406167.97- DEPOS1TS OTHERS 411.00 411.00 1128.00 PAYABLES:A000UNTS 343948.89 9160.80 24783.42 377893.11 3164.35- INTEREST PAYROLL 16091.33 16091.33 10340.72- DUE TO OTHERS 4509.84 8660.00- 4150.16- 4150.16- DEBT INSTRUMENTS PAYABLE TOTAL LIABILTIES 133971.83- 9160.80 24783.42 8660.00- 108687.61- 422695.20- FUND BALANCES 9495337.45- 74226.23- 429495.52- .03- 8660.00 9990399.23- 10494557.39- CON'1MUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 9495337.45- 74226.23- 429495.52- .03- 8660.00 9990399.23- 10494557.39- TOTAL LIAB,FND BAL, RETD EARNS 9629309.28- 65065.43- 404712.10- .03- 10099086.84- 10917252.59- T"to Ls-xtw,7,\ at' +0 ou - see, I/allso. reeoCi-, Pco.t:�,e5 n�c� oJ► o t1 or, Pill F rj 53 GL102 CITY OF DUBLIN 11/09/88 BALANCE SHEET 17.56.35 FOR THE PERIOD 7/88 THROUGH 9/88 ---IIA2---- R Z F.A.U. TRANSPRTATION STATE PARK SENIOR CITIZN PARR T 0 T A L S FUND DEVELOPMENT BOND ACT BOND ACT DEDICATION --- MEMORANDUM ONLY --- FUND FUND FUND FUND CURRENT JUNE 30, 1988 I ASSETS r CASH 1422955.88 4177.95 73650.00 1068317.74 2569101.57 2495451.57 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS 460497.75 460497.75 460497.75 INVEh9ORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS 1883453.63 4177.95 73650.00 1068317.74 3029599.32 2955949.32 LIAR, FND BAL, RETND EARTINGS De:POSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:A000UNTS INTEREST PAYROLL DUE TO OTHERS 460498.00— 15600.00— 476098.00— 476098.00— DEBT INSTRUMENTS PAYABLE TOTAL LIABILTIES 460498.00— 15600.00— 476098.00— 476098.00— FUND BALANCES 1422955.63— 11422.05 73650.00— 1068317.74— 2553501.32— 2479851.32— CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 1422955.63— 11422.05 73650.00— 1068317.74— 2553501.32— 2479851.32— TOTAL LIAB,FND BAL, RETD EARNS 1883453.63— 4177.95— 73650.00— 1068317.74— 3029599.32— 2955949.32— �L, ST93, Y (1102 CITY OF DUBLIN Z==R i 11/09/83 BALANCE SHEET T IA ---- 17.57.01 FOR THE 3 PERIOD 7/88 THROUGH 9/88 / "? J COMMUNITY SALES TAX FETSIM STREET LIGHT LANDSCAPE T O T A L S PARKLANDS ACT MEASURE B GRANT ASSESSMENT ASSESSMENT --- MEMORANDUM ONLY --- FUND FUND FUND DISTRICT FUND DISTRICT FUND CURRENT JUNE 30, 1988 ASSETS r CASH 103987.53 47008.02 24310.30- 126685.25 149258.44 UNP.I")RTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) 2943.55- 66.50- 3010.05- 114TEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS 103987.53 44064.47 24376.80- 123675.20 149258.44 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS 2200.00 2200.00 PAYABLES:A000UNTS 213.25 8383.15 8596.40 INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILTIES 2200.00 213.25 8383.15 10796.40 FEW, BALANCES 106187.53- 44277.72- 15993.65 134471.60- 149258.44- CONTRIBUTIONS IITVESTME M IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 106187.53- 44277.72- 15993.65 134471.60- 149258.44- TWAL LIAB,FND BAL, RETD EARNS 103987.53- 44064.47- 24376.80 123675.20- 149258.44- F' i, i Y GLIG- CITY OF DUBLIN 11/09/88 BALANCE SHEET 17.57.25 FOR THE --- A4---- PERIOD 7/88 THROUGH 9/88 ea- q SAN RAMON RD SAN RAMON RD DOUGHERTY RD DUBLIN BLVD TRUST/AGENCY T 0 T A L S SPC PLAN ASMT BOND RESERVE LIGHT ASMENT EXTENSN ASMNT FUND FOR --- MEMORANDUM ONLY --- DISTRICT FUND FUND DISTRICT FUND DISTRICT FUND DEPOSITS CURRENT JUNE 30, 1988 1 ASSETS =1 CASH 352629.71 72355.62 54949.20 40.95 146054.43 626029.91 726298.75 UNAMORTIZED BOND DISCOUNT DIVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) 180.00- 180.00- INTEREST ASSESSMENTS 575971.43 575971.43 575971.43 RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOWTS TO BE PROVIDED TOTAL ASSETS 928601.14 72355.62 54769.20 40.95 146054.43 1201821.34 1302270.18 LIAR, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPHNT DEPOSITS OTHERS 3125.00- 138623.75- 141748.75- 154828.75- PAYABLES:A000UNTS 262.59 262.59 INTEREST PAYROLL DUE TO OTHERS 1500.00- 1500.00- 1500.00- DEBT INSTRUMENTS PAYABLE 857869.00- 857869.00- 857869.00- TOTAL LIABILTIFS 860994.00- 262.59 1500.00- 138623.75- 1000855.16- 1014197.75- FUND BALANCES 67607.14- 72355.62- 55031.79- 1459.05 7430.68- 200966.18- 288072.43- ; CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 67607.14- 72355.62- 55031.79- 1459.05 7430.68- 200966.18- 288072.43- TOTAL LIAB,FND BAL, RETD EARNS 928601.14- 72355.62- 54769.20- 40.95- 146054.43- 1201821.34- 1302270.18- ; ��. s T�1 s'�`�) • H GL102 CITY OF DUBLIN 11/09/88 BALANCE SHEET 17.57.53 FOR THE ----IIAS---- PERIOD 7/88 THROUGH 9/88 Pr pa INTERNAL FIXED ASSET SUMMARIZED DUBLIN DII 1988 COP T O T A L S SERVICE GROUP OF CAPITAL PROJS INFORMATION CONSYUCTIOH --- MEMORANDUM ONLY --- FUND ACCOUNTS FUND INC. FUND FUND CURRENT JUNE 30, 1988 ASSETS CASH 68726.33 2994574.02- ,1690660.28 128970.49 1106216.92- 1335992.59- UNAMORTIZED BOND DISCOUNT IN4 w i?[ENPS FT COST 5630800.25 1823864.24 7454664.49 8379465.16 RECEIVABLES:TAXES ACCOUNTS (NET) 12264.48- 3228.44- 15492.92- INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS 2093692.56 2093692.56 2093692.56 INVEN`WRY AT COST PREPAID ITEMS 8616.00 8616.00 8616.00 FLXED ASSETS 146686.81 143910.63 8132437.68 8423035.12 8423035.12 AMOUNTS TO BE PROVIDED TOTAL ASSETS 224029.14 143910.63 913145.94- 15453898.21 1949606.29 16858298.33 17568816.25 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:A000UNTS 2681.48 155485.49 17227832.30- 532943.11 16536722.22- 17230000.00- INTEREST PAYROLL DUE TO OTHERS 63309.00- 2112038.95- 2175347.95- 2175347.95- DEBT INSTRUMENTS PAYABLE TOTAL LIABILTIES 60627.52- 1956553.46- 17271832.30- 532943.11 18712070.17- 19405347.95- :011U BALANCES 163401.62- 143910.63- 2869699.40 1773934.09 2482549.40- 1853771.84 1836531.70 CONTRIBUTIONS IN4 rSTr1ENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 163401.62- 143910.63- 2869699.40 1773934.09 2482549.40- 1853771.84 1836531.70 TCIPAL LIAB,FND BAL, RETD EARNS 224029.14- 143910.63- 913145.94 15453898.21- 1949606.29- 16858298.33- 17568816.25- s t: E. t 1 I B Beginning with this set, the Income versus Expenditure Statements are presented. This first set of Income Statements shows the funds organized by fund type and could be used with the balance sheet in set IA to provide a complete picture of the City' s financial activities. Revenues and expenditures are summarized in this statement set. Each major activity of expense is, however, separated into the specific cost centers or departments. t I B (a) These reports are prepared by fund type. .GL104 • E CITY OF DUBLIN STATEMENT SW3iING 10/21/88 REVENUES VERSUS EXPENDITURE .•JJJ 13.23.37 FOR THE PERIOD 7/88 THROUGH 9/88 ----IB(a)---- GENERAL REVENUE FUNDS CURRENT PERIOD I PREVIOUS YEAR ENDING JUNE 30, 1938 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE ****A*A*REVENUES******* ' PROPERTY TAXES 2741700.00- .00 2741700.00- 722500.00- 779607.20- 107.9 57107.20 SALES TAX 5164000.00- 1050538.15- 20.3 4113461.85- .00 .00 .00 REAL PROPERTY TRANSFERS 92140.00- 10489.33- 11.4 81650.67- .00 .00 .00 TRANSIENT OCCUPANCY TAY 100000.00- 25366.77- 25.4 74633.23- .00 .00 .00 FRANCHISE TAXES 301850.00- 13322.50- 4.4 288527.50- .00 .00 .00 PENALTIES AND INTEREST ON DELI .00 .00 .00 .00 .00 .00 LICENSES & PERMITS 355250.00- 40339.50- 11.4 314910.50- 547350.00- 530602.98- 96.9 16747.02- FINES & FORFEITURES 20000.00- 2874.25- 14.4 17125.75- 16500.00- 18813.64- 114.0 2313.64 SPECIAL BENEFITS ASSESSMENTS .00 .00 .00 .00 .00 .00 USES OF MONEY AND PROPERTY 747500.00- 123547.63- 16.5 67.3952.37- 637170.00- 1197190.92- 188.0 560620.92 INTERNGOVERNMENTAL FROM STATE 790600.00- 228975.91- 29.0 561624.09- 755800.00- 716387.56- 94.8 39412.44- INTERGOVERNMENTTAL FROM COUNTY .00 .00 .00 .00 .00 .00 INTERGOVERNMENTAL FROM FEDERAL .00 .00 .00 .00 .00 .00 CHARGES FOR SERVICES 810300.00- 75616.51- 9.3 734683.49- 129740.00- 426833.72- 58.5 302906.28- OTHER SOURCES OF REVENUE 4000.00- 1248.03- 31.2 2751.97- 59700.00- 49932.98- 83.6 9767.02- TOTAL REVENUE 11127340.00- 1572318.58- 14.1 9555021.42- 3468760.00- 3719969.00- 107.2 251209.00 *******EYPENDITURFS******* GENERAL GOVERNMENT ACTIVITFS NON-DEPARTMENTAL 442500.00 118.00 442382.00 250000.00 250000.00 100.0 .00 CITY COUNCIL 83490.00 17243.79 20.7 66246.21 89130.00 62010.31 69.6 27119.69 CITY MANAGER 350335.00 54570.03 15.6 295764.97 273438.00 232136.61 84.9 41301.39 CITY ATTORNEY 118700.00 17159.86 14.5 101540.14 109000.00 103263.47 94.7 5736.53 FINANCE DEPARTMENT 159280.00 25597.58 16.1 133682.42 138970.00 125364.11 90.2 13605.89 BUILDING MANAGEMENT 1380150.00 33463.38 2.4 1346686.62 1398490.00 1082153.32 77.4 316336.68 INSURANCE COST CENTER 213125.00 151883.89 71.3 61241.11 136600.00 100293.93 73.4 36306.07 ELECTIONS COST CENTER 2650.00 24.94 .9 2625.06 5000.00 1924.88 38.5 3075.12 ***ACTIVITY TOTAL 2750230.00 300061.47 10.9 2450168.53 2400628.00 1957146.63 81.5 443481.37 PUBLIC SAFETY POLICE 1891910.00 114292.92 4 6.0 1777617.08 184 9634.00 1576100.49 85.2 273533.51 CROSSING GUARDS COST .00 .00 .00 22200.00 24613.95 110.9 2413.95- ANIMAL CONTROL 43000.00 .00 43000.00 42000.00 30216.97 71.9 11783.03 TRAFFIC SIGNALS .00 .00 .00 9500.00 .00 9500.00 DISASTER PREAPREDNESS 17300.00 354.49 2.0 16945.51 20250.00 9221.81 45.5 11028.19 FIRE SERVICES OF THE JPA 1864904.00 769328.00 41.3 1095576.00 .00 .00 .00 ***ACTIVITY TOTAL 3817114.00 883975.41 23.2 2933138.59 1943584.00 1640153.22 84.4 303430.78 TRANSPORTATION PUBLIC WORKS 198300.00 30519.34 15.4 167780.66 159318.00 90718.28 56.9 68599.72 STREET MAINTENANCE 42100.00 225.00 .5 41875.00 96400.00 48250.56 50.1 48149.44 STREET SWEEPING 52800.00 4236.83 8.0 48563.17 52500.00 44077.81 84.0 8422.19 STREET LANDSCAPE 80600.00 7503.21 9.3 73096.79 67500.00 45661.57 67.6 21838.43 STREET LANDSCAPE MAINTENANCE 158560.00 25420.91 16.0 133139.09 224050.00 133391.43 59.5 90658.57 PARATRANSIT SERVICES 2000.00 .00 2000.00 14586.00 15544.43 106.6 958.43- ***ACTIVITY TOTAL 534360.00 67905.29 12.7 466454.71 614354.00 377644.08 61.5 236709.92 HEALTH & WELFARE VECTOR CONTROL 20500.00 305.08 1.5 20194.92 15500.00 3879.04 25.0 11620.% 6 L S 70! 6 Ise Poi' `a� Con sod-%1ss Ill '4s� '�,►j �, , GL104 THE CITY OF DUBLIN STATEMENT SHORING 2 ..�► 10%21/88 , REVENUES VERSUS EXPENDITURE 13.23.37 FOR THE �0.\ PERIOD 7/88 THROUGH 9/88 J ----IB(a)---- GENERAL REVENUE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE ***ACTIVITY TOTAL 20500.00 305.08 1.5 20194.92 15500.00 3879.04 25.0 11620.96 CULTURE & LEISURE SERVICES LIBRARY SERVICES 110315.00 .00 110315.00 346180.00 278776.32 80.5 67403.68 PARK MAINTENANCE 368600.00 47359.37 12.8 321240.63 16720.00 12904.52 77.2 3815.48 COMMUNITY CABLE TV 28500.00 .00 28500.00 .00 .00 .00 RECREATION 119603.00 23448.72 19.6 96154.28 .00 .00 .00 PLAYGROUNDS 60148.00 13202.16 21.9 46945.84 .00 .00 .00 SHANNON CENTER 60823.00 10376.36 17.1 50446.64 .00 .00 .00 PRESCHOOL 32708.00 2737.75 8.4 29970.25 .00 .00 .00 TEENS PROGRAM 16398.00 2838.21 17.3 13559.79 2100.00 583.44 27.8 1516.56 FIELD SCHEDULING 3668.00 451.22 12.3 3216.78 .00 .00 .00 SPECIAL EVENTS 28532.00 3253.25 11.4 25278.75 1600.00 1446.80 90.4 153.20 SENIOR CENTER 69580.00 9101.98 13.1 60478.02 8500.00 .00 8500.00 RECREATION INSTRUCTION 49787.00 9421.41 18.9 40365.59 33900.00 31075.84 91.7 2824.16 AQUATICS 104543.00 27552.17 26.4 76990.83 41500.00 18004.41 43.4 23495.59 ***ACTIVITY TOTAL 1053205.00 149742.60 14.2 903462.40 450500.00 342791.33 76.1 1OT708.67 COMMUNITY DEVELOPMENT PLANNING 739010.00 72159.80 9.8 666850.20 521530.00 327732.21 62.8 193797.79 BUILDING SAFETY 334385.00 50151.08 15.0 284233.92 329892.00 292789.24 88.8 37102.76 ENGINEERING 301500.00 33560.22 11.1 267939.78 469350.00 377982.97 80.5 91367.03 ***ACTIVITY TOTAL 1374895.00 155871.10 11.3 1219023.90 1320772.00 998504.42 75.6 322267.58 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 63000.00 .00 63000.00 .00 .00 .00 COMMUNITY IMPROVEMENTS 625590.00 151373.55 24.2 474216.45 .00 .00 .00 PARKS 502350.63 123675.37 24.6 378675.26 .00 .00 .00 STREET CONSPRUCTION/IMPROVMT 1166786.15 187109.56 16.0 979676.59 .00 .00 .00 ***ACITIVITY TOTAL 2357726.78 462158.48 19.6 1895568.30 .00 .00 .00 TOTAL E X P E N D I T U R E S 11908030.78 2020019.43 17.0 9888011.35 6745338.00 5320118.72 78.9 1425219.28 EXCESS <REVENUD EXPENDITURES 780690.78 447700.85 57.3 332989.93 3276578.00 1600149.72 48.8 1676428.28 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 .00 955.00- 955.00 TRANSFERS OUT TO OTHER FUNDS 172579.37 1622811.00 940.3 1450231.63- 2297.00 867176.00 7752.5 864879.00- EXCESS <TXVENUES> OR EXPENSES 953270.15 2070511.85 217.2 1117241.70- 3278875.00 2466370.72 75.2 812504.28 co �So�: mss � « � 5 'Fo 1 T THE CITY OF DUBLIN STATEMENT SHOWING ----IB(a)---- S A M P L E REVENUES VERSUS EXPENDITURE SAMPLE FOR THE PERIOD 7/88 THROUGH 9/88 SPECIAL REVENUE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE ***"***REVENUES******** PROPERTY TAXES .00 (17,246.00) 0 17,246.00 .00 .00 0 .00 SALES TAX (83,000.00) .00 0 (83,000.00) (81,300.00) (83,401.00) 102.6 2,101.00 REAL PROPERTY TRANSFERS .00 .00 0 .00 .00 .00 0 .00 TRANSIENT OCCUPANCY TAX .00 .00 0 .00 .00 .00 0 .00 FRANCHISE TAXES .00 .00 0 .00 .00 .00 0 .00 PENALTIES AND INTEREST ON DELI .00 .00 0 .00 .00 .00 0 .00 LICENSES & PERMITS .00 .00 0 .00 .00 .00 0 .00 FINES & FORFIETURES (85,000.00) (21,770.16) 25.6 (63,229.84) (80,000.00) (75,770.34) 94.7 (4,229.66) SPECIAL BENEFITS ASSESSMENTS .00 0 .00 .00 .00 0 .00 USFS OF MONEY AND PROPERTY (40,000.00) .00 0 (40,000.00) (33,200.00) (190,605.34) 574.1 157,405.34 tN1'e.RGOVERNMENTAL FROM STATE (402,100.00) (128,025.50) 31.8 (274,074.50) (494,933.33) (470,638.00) 95.1 (24,295.33) INTERGOVERNMENTAL FROM COUNTY .00 .00 0 .00 .00 .00 0 .00 INT-i.RGOVERNMENTAL FROM FEDERAL (1,090,000.00) .00 0 (1,090,000.00)(1,396,86 .00) (616,086.47) 44.1 (780,773.53) ZHAP,GES FOR SERVICES .00 .00 0 .00 .00 .00 0 .00 OTHER SOURCES OF REVENUE (288,000.00) .00 0 (288,000.00) (50,000.00) (307,644.00) 615.3 257,644.00 TOTRL REVENUE (1,988,100.00) (167,041.66) 8.4 (1,821,058.34)(2,136,293.33)(1,744,145.15) 81.6 (392,148.18) ****x****EXPENDITDRFS******** GENERAL GOVERNMENTAL ACTIVITIES NON-DEPARTMENTAL PUBLIC SAFETY POLICE 11,550.00 .00 0 11,550.00 .00 .00 0 .00 CROSSING GUARDS COST 22,950.00 .00 0 22,950.00 .00 .00 0 .00 ANIMAL CONTROL .00 .00 0 .00 .00 .00 0 .00 TRAFFIC SIGNALS 78,100.00 6,918.57 8.9 71,181.43 80,000.00 66,693.23 83.4 13,306.77 DISASTER PREPAREDNESS .00 .00 0 .00 .00 .00 0 .00 eIRES SERVICES OF THE 3PA .00 .00 0 .00 .00 .00 0 .00 ***ACTIVIT"f TOTAL 112,600.00 6,918.57 6.1 105,681.43 80,000.00 66,693.23 83.4 13,306.77 TRANSPORTATION PUBLIC WORKS ,00 ,00 STREET MAINTENANCE .00 .00 (GL.STO1 46) Ole,& � �� �J n•o�S Q,,i F,),,"b T+ e. I B (b) These reports are prepared on a fund by fund basis. ;s THE CITY OF DUBLIN STATEMENT SHOWING ----IB(b)---- a A M P L E REVENUES VERSUS EXPENDITURE S A H P L E FOR THE PERIOD 7/88 THROUGH 9%88 FUND 200 SPECIAL CRDO)aL ACTIVITY FUND fie` e. CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE **■****REVENUES******** PROPERTY TAXES .00 .00 0 .00 .00 .00 0 .00 SALES TAX .00 .00 0 .00 .00 .00 0 .00 i.•-.AL PROPERTY TRANSFERS .00 .00 0 .00 .00 .00 0 .00 TRANSIENT OCCUPANCY TAX .00 .00 0 .00 .00 .00 0 .00 FRANCHISE TAXES .00 .00 0 .00 .00 .00 0 •00 PENALTIES AND INTEREST ON DELI .00 .00 0 .00 .00 .00 0 .00 LICENSES & PERKETS .00 .00 0 .00 .00 .00 0 .00 FINES & FORFIETURES .00 .00 0 .00 .00 .00 0 .00 SPECIAL BENEFITS ASSESSMENTS .00 .00 0 .00 .00 .00 0 .00 -'a OF MONEY AND PROPERTY .00 .00 0 .00 .00 (322.54) 0 322.54 lN7ERGOVERNMENTAL FROM STATE .00 .00 0 .00 .00 .00 0 .00 INTERGOVERNMENTAL FROM COUNTY .00 .00 0 .00 .00 .00 0 .00 11-TERGOVERNMEATAL FROM FEDERAL .00 .00 0 .00 .00 .00 0 .00 CHARGES FOR SERVICES .00 .00 0 .00 .00 .00 0 •00 TITHER SOURCES OF REVENUE .00 (987.85) 0 987.85 .00 (25,581.00) 0 25,581.00 TOTAL REVENUE .00 (987.85) 0 987.85 .00 (25,903.54) 0 25,903.54 *********EXPENDITURES******** GENERAL GOVERNMENTAL ACTIVITIES NON-DEPARTMENTAL PUBLIC SAFETY POLICE 11,550.00 .00 0 11,550.00 .00 CO. 0 .00 CROSSING GUARDS COST .00 .00 0 .00 .00 .00 0 .00 ANI)4AL CONTROL .00 .00 0 .00 .00 .00 0 .00 TRAFFIC SIGNALS .00 .00 0 .00 .00 .00 0 .00 DISASTER PREPAREDNESS .00 .00 0 .00 .00 .00 0 .00 FIRES SERVICES OF THE JPA .00 .00 0 .00 .00 .00 0 .00 **ACTIVITY TOTAL 11,550.00 .00 0 11,550.00 .00 .00 0 .00 TR.RiSPORTATION PUBLIC WORKS .00 .00 :jfREET MAINTENANCE .00 •00 (GL.ST01 46) (5ee, 3 3i sea oc�) Tl.;5 e Ce�c'e�c�J e, ���� eac�r.. �-�� c�.�► aces THE CITY OF DUBLIN STATEMENT SHOWING ----IB(b)---- S A M P L E REVENUES VERSUS EXPENDITURE S A M P L E FOR THE PERIOD 7/88 THROUGH 9/88 FUND 205 TRAFFIC SAFETY FUND \e 04 ,, \\ •CC,o�� t G So--k eit Forj CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE *******REVENUES******** PROPERTY TAXES .00 .00 0 .00 .00 .00 0 .00 SALES TAX .00 .00 0 .00 .00 .00 0 .00 REAL PROPERTY TRANSFERS .00 .00 0 .00 .00 .00 0 .00 TRANSIENT OCCUPANCY TAX .00 .00 0 .00 .00 .00 0 .00 FRANCHISE TAXES .DO .00 0 .00 .00 .00 0 .00 rLHALTIES AND INTEREST ON DELI .00 .00 0 .00 .00 .00 0 .00 TICENSES & PERMITS .00 .00 0 .00 .00 .00 0 .00 FD,ES & FORFIETURES (85,000.00) (29,984.40) 35.3 (55,015.60) (80,000.00) (75,770.34) 94.7 (4,229.66) SPECIAL BENEFITS ASSESSMENTS .00 .00 0 .00 .00 .00 0 .00 USLS OF MONEY AND PROPERTY .00 .00 0 .00 .00 (4,106.44) 0 4,106.44 INTERGOVERNMENTAL FROM STATE .00 .00 0- .00 .00 .00 0 .00 INTERGOVERNMENTAL FROM COUNTY .00 .00 0 .00 .00 .00 0 .00 L.iM- GOVERNMENTAL FROM FEDERAL .00 .00 0 .00 .00 .00 0 .00 CHARGES FOR SERVICES .00 .00 0 .00 .00 .00 0 .00 THER SOURCES OF REVENUE .00 .00 0 .00 .00 .00 0 .00 TOTAL REVENUE (85,000.00) (29,984.40)' 0 (55,015.60) (80,000.00) (79,876.78) 0 (123.22) a *********EXPENDITURES******** uENLRAL GOVERNMENTAL ACTIVITIES t:vtl-DEPARTMENTAL PUBLIC SAFETY POLICE .00 .00 0 .00 .00 .00 0 .00 CROSSING GUARDS COST 22,950.00 .00 0 22,950.00 .00 .00 0 .00 ANIMAL CONTROL .00 .00 ' .0 .00 .00 .00 0 .00 } TRAFFIC SIGNALS 78,100.00 6,918.57 8.9 71,181.43 80,000.00 66,693.23 83.4 13,306.77 DISASTER PREPAREDNESS .00 .00 0 .00 .00 .00 0 .00 FIRES SERVICES OF THE JPA .00 .00 0 .00 .00 .00 0 .00 ***ACTIVITY TOTAL 101,050.00 6,918.57 6.8 94,131.43 80,000.00 66,693.23 83.4 13,306.77 TRANSPORTATION PUBLIC WORKS •ED .00 STREET MAINTENANCE •00 W (GL.STO1#6) �s S�.ov�s QX e�5� 0.nd II e P c-�Je.nv� w���� Q,ac�- ��� �t•.d oboe s vvoA Z om.) n r IIB These reports show the Income versus Expenditures for the City, but the expenditures reflect a greater level of detail than the first set of forms. IIB(a) This report summarizes the funds in fund types. THE CITY OF DUBLIN STATEMENT SHOWING ----IIB(a)---- S A M P L E REVENUES VERSUS EXPENDITURE SAMPLE FOR THE PERIOD 7/88 THROUGH 9/88 SPECIAL REVENUE FUNDS S e'S l�5� � QJ►�� 1 O V�. � e S , �o s CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE PROPERTY TAXES .00 (17,246.00) 0 17,246.00 .00 .00 0 .00 SALES TAX (83,000.00) .00 0 (83,000.00) (81,300.00) (83,401.00) 102.6 2,101.00 KEAL PROPERTY TRANSFERS .00 .00 0 .00 .00 .00 0 .00 TRANSIENT OCCUPANCY TAX .00 .00 0 .00 .00 .00 0 .00 FR"CHISE TAXES .00 .00 0 .00 .00 .00 0 .00 PENALTIES AND INTEREST ON DELI .00 .00 0 .00 .00 .00 0 .00 LIC-tNSES & PERMITS .00 .00 0 .00 .00 .00 0 .00 FINES & FORFIETURES (85,000.00) (21,770.16) 25.6 (63,229.84) (80,000.00) (75,770.34) 94.7 (4,229.66) SPECIAL BENEFITS ASSESSNEM .00 .00 0 .00 .00 .00 0 .00 USES OF MONEY AND PROPERTY (40,000.00) .00 0 (40,000.00) (33,200.00) (190,605.34) 574.1 157,405.34 INTERGOVERNMENTAL FROM STATE (402,100.00) (128,025.50) 31.8 (274,074.50) (494,933.33) (470,638.00) 95.1 (24,295.33) INTERGOVERNMENTAL FROM COUNTY .00 .00 0 .00 .00 .00 0 .00 IN'TERGOVERM04TAL FROM FEDERAL (1,090,000.00) .00 0 (1,090,000.00)(1,396,860.00) (616,086.47) 44.1 (780,77/3.53) CHARGES FOR SERVICES .00 .00 0 .00 .00 :00 0 .00 OTHER SOURCES OF REVENUE (288,000.00) .00 0 (288,000.00) (50,000.00) (307,644.00) 615.3 257,644.00 TOTAL REVENUE (1,988,100.00) (167,041.66) 8.4 (1,821,058.34)(2,136,293.33)(1,744,145.15) 81.6 (392,148.18) ********* ENDITi1RES�******* GENERAL GOVERNMENTAL ACTIVITIES NON-DEPARTMENTAL PUBLIC SAFETY POLICE 11,550.00 .00 0 11,550.00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL 6,200.00 .00 0 6,200.00 .00 .00 0 .00 CONTRACT SERVICES 500.00 .00 0 500.00 . .00 .00 0 .00 CAPTIAL OUTLAY 4,850.00 .00 0 4,850.00 .00 .00 0 .00 CROSSING GUARDS COST 22,950.00 .00 0 22,950.00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES 22,950.00 .00 0 22,950.00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 AKIMAL CONTROL .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 •00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 TRAFFIC SIGNALS 78,100.00 6,917.97 8.9 71,182.03 80,000.00 66,693.23 83.4 13,306.77 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL 33,500.00 6,900.00 20.6 26,600.00 26,500.00 28,830.33 108.8 (2,330.33) CONTRACT SERVICES 44,600.00 17.97 .0 44,582.03 53,500.00 37,862.90 70.8 15,637.10 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 DISASTER PREPAREDNESS .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 `.00 .00 .00 0 .00 FARES SERVICES OF THE JPA .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 *x*ACTIVITY TOTAL 112,600.00 6,917.97 6.1 105,682.03 80,000.00 66,693.23 83.4 13,306.77 TRANSPORTATION PUBLIC WORKS .00 •00 STREET MAINTENANCE •00 '00 (GL.ST0146) i s. r !I: S .. ___..__...- ._..W_............J��...................._.., .•... ».....-. .,.,.,,......� ..c.r.a. m,-r-s..s. ....,;». ..»....,.-....T... T"_, .^�a^nwmr«.e,� ...J�"�f'„n6.,.., i:rx � 7,�,�,.. .c,R:iC.?r bL1U4 THE (AT'Y OF DUBLIN STAT'Et"r 5H(.MlW 'Numurr-l- 11/09/33 THE INCOME VERSUS EXPENDITURES 15.11.06 SUMMARIZED BY 1ITY, DEPARTMENTS, AND BUDGET CATAGORIES ? / PERIOD 7/88 THROUGH 91188 ----I I B(a) S � GENERAL REVENUE FUNDS nS e.s CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1983 1 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE *****-*k***REVENUES********* PROPERTY TAXES 2741700.00- .00 2741700.00- 722500.00- 779607.20- 107.9 57107.20 SALES 'TAXES 5164000.00- 1050538.15- 20.3 4113461.85- .00 .00 .00 REAL PROPERTY TRANSFERS 92140.00- 10489.33- 11.4 81650.67- .00 .00 .00 TRANSCIENT OCCUPANCY TAX .00 .00 .00 .00 .00 .00 FRNACHISE TAXES 301850.00- 13322.50- 4.4 288527.50- .00 .00 .00 PENALTIES AND INTEREST ON DELI .00 .00 .00 .00 .00 .00 LICENSES & PERMITS 355250.00- 40339.50- 11.4 314910.50- 547350.00- 530602.98- 96.9 16747.02- FINES & FORFEITURES 20000.00- 2874.25- 14.4 17125.75- 16500.00- 18813.64- 114.0 2313.64 SPECIAL BENEFITS ASSESSMENTS .00 .00 .00 .00 .00 .00 USES OF IIOENY AND PROPERTY 747500.00- 123547.63- 16.5 623952.37- 637170.00- 1197790.92- 188.0 560620.92 INTERGOVERNMENTAL FROM STATE 790600.00- 228975.91- 29.0 561624.09- 755800.00- 716387.56- 94.8 39412.44- INTERGOVERNMENTAL FROM COUNTY .00 .00 .00 .00 .00 .00 INTERGOVERNMENTAL FROM FEDERAL 00 .00 .00 .00 .00 .00 CHARGES FOR SERVCCES 810300.00- 75616.51- 9.3 734683.49- 729740.00- 426833.72- 58.5 302906.28- OTHER SOURCES OF REVENUE 4000.00- 1248.03- 31.2 2751.97- 59700.00- 49932.98- 83.6 9767.02- TOTAL REVENUE 11027340.00- 1546951.81- 14.0 9480388.19- 3468760.00- 3719969.00- 107.2 251209.00 *******EXPENDITURES******* G E N E R A L GOVERN10n NON-DEPARTMENTAL 615079.37 118.00 614961.37 252297.00 250000.00 99.1 2297.00 CITY COUNCIL 83490.00 17243.79 20.7 66246.21 89130.00 62010.31 69.6 27119.69 2ERSONNEL 35550.00 6933.25 19.5 28616.75 32308.00 29029.67 89.9 3278.33 SERVICES,SUPPLIFS,HATERIAL 47190.00 10060.54 21.3 37129.46 51072.00 32480.64 63.6 18591.36 CAPITAL OUTLAYS 750.00 250.00 33.3 500.00 5750.00 500.00 8.7 5250.DO CIT'i MANAGER 350335.00 54570.03 15.6 295764.97 273438.00 232136.61 84.9 41301.39 PERSONNEL 271270.00 39433.34 14.5 231836.66 211308.00 192064.82 90.9 19243.18 SERVICES,SUPPLIES,MATERIAL 42910.00 5596.60 13.0 37313.40 35730.00 26632.66 74.5 9097.34 _,NTRACT SERVICES 29120.00 4623.64 15.9 24496.36 25500.00 11403.00 44.7 14097.00 CAPITAL OUTLAYS 7035.00 4916.45 69.9 2118.55 900.00 2036.13 226.2 1136.13- CITY ATTORNEY 118700.00 17159.86 14.5 101540.14 109000.00 103263.47 94.7 5736.53 PERSONNEL 3400.00 42.36 �.2 3357.64 3400.00 1351.38 39.7 2048.62 SERVICES,SUPPLIES,MATERIAL 115300.00 16955.00 14.7 98345.00 103400.00 99806.31 96.5 3593.69 CONTRACT SERVICES .00 162.50 162.50- .00 .00 .00 CAPITAL 09TALYS .00 .00 .00 2200.00 2105.78 95.7 94.22 FINANCE DEPARTMENT 159280.00 25597.58 16.1 133682.42 138970.00 125364.11 90.2 13605.89 PERSONNEL 122410.00 18409.44 15.0 104000.56 94730.00 82187.15 86.8 12542.85 SERVICES,SUPPLIES,MATERIAL 15470.00 1663.66 10.8 13806.34 17040.00 10792.38 63.3 6247.62 CONTRACT SERVICES 19150.00 4951.50 25.9 14198.50 25750.00 31462.35 122.2 5712.35- CAPITAL OUTLAYS 2250.00 572.98 25.5 1677.02 1450.00 922.23 63.6 527.77 BUILDING MANAGEMENT 1380150.00 33463.38 2.4 1346686.62 1398490.00 1082153.32 77.4 316336.68 SERVICES,SUPPLIFS,MATERIAL 1351950.00 33327.42 2.5 1318622.58 1389700.00 1076785.38 77.5 312914.62 CONTRACT SERVICES 26200.00 135.96 .5 26064.04 2420.00 1812.55 74.9 607.45 CAPITAL OUIUYS 2000.00 .00 2000.00 6370.00 3555.39 55.8 2814.61 INSURANCE COST CENTER 213125.00 151883.89 71.3 61241.11 136600.00 100293.93 73.4 36306.07 SERVICES,SUPPLIFS,MATERIAL 213125.00 151883.89 71.3 61241.11 136600.00 100293.93 73.4 36306.07 ELECTIONS COST CENTER 2650.00 24.94 .9 2625.06 5000.00 1924.88 38.5 3075.12 SERVICES,SUPPLIES,MATERIAL 650.00 24.94 3.8 625.06 2000.00 .00 2000.00 CONTRACT SERVICES 2000.00 .00 2000.00 3000.00 1924.88 64.2 1075.12 UL.h"t THE CITY OF DUBLIN STATEMENT SHOWING e 11/09!83 mHE INCOME VERSUS EXPENDITURES 15.11.06 SUMMARIZED L IVITY, DEPARTMENTS, AND BUDGET CATAGORIES ----IIB(a)---- PERIOD 7/88 THROUGH 9/88 -� GENERAL REVENUE FUNDS s Cad CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE ***ACTIVITY TOTAL 2750230.00 300061.47 10.9 2450168.53 2400628.00 1957146.63 81.5 443481.37 PUBLIC SAFETY POLICE 1891910.00 114292.92 6.0 1777617.08 1849634.00 1576100.49 85.2 273533.51 PERSONNEL 15030.00 2450.00 16.3 12580.00 13470.00 12353.37 91.7 1116.63 SERVICES,SUPPLIES,MATERIAL 128370.00 3655.32 2.8 124714.68 117639.00 47601.16 40.5 70037.84 CONTRACT SERVICES 1740460.00 103187.60 6.2 1632272.40 1710785.00 1509571.37 88.2 201213.63 CAPITAL OUTLAY 8050.00 .00 8050.00 7740.00 6574.59 84.9 1165.41 CROSSING GUARDS COST .00 .00 .00 22200.00 24613.95 110.9 2413.95- CONTRACT SERVICES .00 .00 .00 22200.00 24613.95 110.9 2413.95- AkIMAL CONTROL 43000.00 .00 43000.00 42000.00 30216.97 71.9 11783.03 CONTRACT SERVICES 43000.00 .00 43000.00 42000.00 30216.97 71.9 11783.03 TRAFFIC SIGNALS .00 .00 .00 9500.00 .00 9500.00 SERVICES,SUPPLIES,MATERIAL .00 .00 .00 9500.00 .00 9500.00 DISASTER PREAPREDNESS 17300.00 354.49 2.0 16945.51 20250.00 9221.81 45.5 11028.19 FIRE SERVICES OF THE JPA 1864904.00 769328.00 41.3 1095576.00 .00 .00 .00 CONTRACT SERVICES 1864904.00 769328.00 41.3 1095576.00 .00 .00 .00 ***ACTIVITY TOTAL 3817114.00 883975.41 23.2 2933138.59 1943584.00 1640153.22 84.4 303430.78 .TRANSPORTATION PUBLIC WORKS 198300.00 30519.34 15.4 167780.66 159318.00 90718.28 56.9 68599.72 PERSONNEL 111180.00 15446.24 13.9 95733.76 81430.00 26254.61 32.2 55175.39 SERVICES,SUPPLIES,HATERAIL 12270.00 1602.97 13.1 10667.03 9738.00 3009.27 30.9 6728.73 CONTRACT SERVICES 73800.00 13226.40 17.9 60573.60 66000.00 61454.40 93.1 4545.60 CAPITAL OUTLAYS 1050.00 243.73 23.2 806.27 2150.00 .00 2150.00 STREET MAINTENANCE 42100.00 225.00 .5 41875.00 96400.00 48250.56 50.1 48149.44 SERVICES,SUPPLIFS,MATERAIL .00 .00 .00 1000.00 .00 1000.00 CONTRACT SERVICES 42100.00 225.00 .5 41875.00 95400.00 48250.56 50.6 47149.44 STREET SWEEPING 52800.00 4236.83 8.0 48563.17 52500.00 44077.81 84.0 8422.19 CONTRACT SERVICES 105300.00 4236.83 4.0 101063.17 52500.00 44077.81 84.0 8422.19 STREET LANDSCAPE 80600.00 7503.21 9.3 73096.79 67500.00 45661.57 67.6 21838.43 CONTRACT SERVICES 80600.00 7503.21 9.3 73096.79 67500.00 45661.57 67.6 21838.43 STREET LANDSCAPE MAINTENANCE 158560.00 25420.91 16.0 133139.09 224050.00 133391.43 59.5 90658.57 SERVICES,SUPPLIFS,MATERAIL 19660.00 1110.34 5.6 18549.66 14350.00 13527.59 94.3 822.41 CONTRACT SERVICES 138900.00 24310.57 17.5 114589.43 209700.00 119863.84 57.2 89836.16 PARATRANSIT SERVICES 2000.00 .00 2000.00 14586.00 15544.43 106.6 958.43- CONTRACT SERVICES 2000.00 .00 2000.00 14586.00 15544.43 106.6 958.43- ***ACTIVITY TOTAL 534360.00 67905.29_ 12.7 466454.71 614354.00 377644.08 61.5 236709.92 HEALTH & WELFARE VECtUR CONTROL 20500.00 305.08 1.5 20194.92 15500.00 3879.04 25.0 11620.96 CONTRACT SERVICES 20500.00 305.08 1.5 20194.92 15500.00 3879.04 25.0 11620.96 ***ACTIVITY TOTAL 20500.00 305.08 1.5 20194.92 15500.00 3879.04 25.0 11620.96 C U L T U R E & L E I S U R E LIBRARY SERVICES 110315.00 .00 110315.00 346180.00 278776.32 80.5 67403.68 CONTRACT SERVICES 110315.00 .00 110315.00 .00 .00 .00 PPM MAINTENANCE 368600.00 47359.37 12.8 321240.63 16720.00 12904.52 77.2 3815.48 ' Ullivf 1116 11111 U[ UUDLIN bTA'16mmr bHuw11117 Qmzxwob 11/09/88 THE INCOME VERSUS EXPENDITURES 15.11.06 SUMMARIZED F TVITY, DEPARTMENTS, AND BUDGET CATAGORIES ---IIB(a)---- Zj r..rJOD 7/88 THROUGH 9/88 GENERAL REVENUE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE SERVICES,SUPPLIES,MATERAIL 60500.00 4841.40 8.0 5565$.60 .00 .00 .00 CONTRACT SERVICES 308100.00 42517.97 13.8 265582.03 16720.00 12904.52 77.2 3815.48 COMMUNITY CABLE TV 28500.00 .00 28500.00 .00 .00 .00 CONTRACT SERVICES 28500.00 .00 28500.00 .00 .00 .00 RECREATION 119603.00 23448.72 19.6 96154.28 .00 .00 .00 ':.RSONEL 96738.00 19302.39 20.0 77435.61 .00 .00 .00 SERVICES,SUPPLIES,MATERAIL 22865.00 4146.33 18.1 18718.67 .00 .00 .00 PLAYGROUNDS 60148.00 13202.16 21.9 46945.84 .00 .00 .00 PERSONNEL 52928.00 12591.81 23.8 40336.19 .00 .00 .00 SERVICES,SUPPLIES,MATERAIL 6645.00 610.35 9.2 6034.65 .00 .00 .00 CON'T'RACT SERVICES 575.00 .00 575.00 .00 .00 .00 SHAKNON CENTER 60823.00 10376.36 17.1 50446.64 .00 .00 .00 PERSONNEL 29583.00 5244.71 17.7 24338.29 .00 .00 .00 SERVICES,SUPPLIES,MLTERAIL 9540.00 1583.06 16.6 7956.94 .00 .00 .00 CONTRACT SERVICES 14500.00 2539.90 17.5 11960.10 .00 .00 .00 CAPITAL OUTLAY 3700.00 282.23 7.6 3417.77 .00 .00 .00 PRESCHOOL 32708.00 2737.75 8.4 29970.25 .00 .00 .00 PERSONNEL 30128.00 2618.38 8.7 27509.62 .00 .00 .00 SERVICES,SUPPLIES,MATERAIL 2150.00 119.37 5.6 2030.63 .00 .00 .00 CAPITAL OUTLAY 430.00 .00 430.00 .00 .00 .00 TEENS PROGRAM 16398.00 2838.21 17.3 13559.79 2100.00 583.44 27.8 1516.56 PERSONNEL 11023.00 1770.56 16.1 9252.44 .00 .00 .00 SERVICES,SUPPLIES,MATERAIL 750.00 68.61 9.1 681.39 .00 .00 .00 C0h`TRACT SERVICES 4625.00 999.04 21.6 3625.96 2100.00 583.44 27.8 1516.56 FIELD SCHEDULING 3668.00 451.22 12.3 3216.78 .00 .00 .00 PERSONNEL 3668.00 451.22 12.3 3216.78 .00 .00 .00 SPECIAL EVENTS 28532.00 3253.25 11.4 25278.75 1600.00 1446.80 90.4 153.20 PERSONNEL 17907.00 2583.73 14.4 15323.27 .00 .00 .00 ziERVICES,SUPPLIES,MATERAIL 4800.00 402.02 8.4 4397.98 .00 .00 .00 CONTRACT SERVICES 5475.00 .00 5475.00 1600.00 1446.80 90.4 153.20 CAPITAL OUTLAY 350.00 267.50 76.4 82.50 .00 .00 .00 SENIOR CENTER 69580.00 9101.98 13.1 60478.02 8500.00 .00 8500.00 PERSONNEL 25485.00 4982.24 19.5 20502.76 .00 .00 .00 SERVICES,SUPPLIES,MATERIAL 20035.00 1704.24 8.5 18330.76 .00 .00 .00 CONTRACT SERVICES 22700.00 2415.50 10.6 20284.50 8500.00 .00 8500.00 CAPITAL OUTLAY 1360.00 .00 1360.00 .00 .00 .00 RECREATION INSTRUCTION 49787.00 9421.41 18.9 40365.59 33900.00 31075.84 91.7 2824.16 PERSONNEL 19337.00 2909.16 15.0 16427.84 .00 .00 .00 SERVICES,SUPPLIES,MATERIAL 1450.00 .00 1450.00 .00 .00 .00 CONTRACT SERVICES 29000.00 6512.25 22.5 22487.75 33900.00 31075.84 91.7 2824.16 AQUATICS 104543.00 27552.17 26.4 76990.83 41500.00 18004.41 43.4 23495.59 PERSONNEL 45053.00 18850.11 41.8 26202.89 13350.00 3664.38 27.4 9685.62 SERVICES,SUPPLIES,MATERIAL 43290.00 8702.06 20.1 34587.94 650.00 425.93 65.5 224.07 CONTRACT SERVICES 16200.00 .00 16200.00 27000.00 13404.76 49.6 13595.24 CAPITAL OUTLAY .00 .00 .00 500.00 509.34 101.9 9.34- ***ACTIVITY TOTAL 1053205.00 149742.60 14.2 903462.40 592600.00 472483.23 79.7 120116.77 GL104 THE CITY OF DUBLIN STATEMENT SHOWING 11/09/88 THE INCOME VERSUS EXPENDITURES ----IIB(a)---- 15.11.06 SUMMARIZED BY VITY, DEPARTMENTS, AND BUDGET CATAGORIES Q 6 PERIOD 7/88 THROUGH 9/88 [ �� GENERAL REVENUE FUNDS ji� 19 col) CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCF BUDGET ACTUAL PERCENT VARIANCE C 0 M H U N I T Y DEVELOPMENT PLANNING 739010.00 72159.80 9.8 666850.20 521530.00 327732.21 62.8 193797.79 PERSONNEL 300020.00 57933.60 19.3 242086.40 278960.00 217769.62 78.1 61190.38 SERVICES,SUPPLIES,MATERIAL 343180.00 7733.70 2.3 335446.30 201930.00 48555.46 24.0 153374.54 CONTRACT SERVICES 94710.00 6492.50 6.9 88217.50 38500.00 60077.38 156.0 21577.38- CAPITAL OUTALY 1100.00 .00 1100.00 2140.00 1329.75 62.1 810.25 BUILDING SAFETY 334385.00 50151.08 15.0 284233.92 329892.00 292789.24 88.8 37102.76 PERSONNEL 38330.00 6456.43 16.8 31873.57 35415.00 29471.66 83.2 5943.34 SERVICES,SUPPLIES,MATERIAL 6555.00 20428.62 311.6 13873.62- 9477.00 6635.58 70.0 2841.42 CONTRACT SERVICES 289000.00 23098.00 8.0 265902.00 285000.00 256682.00 90.1 28318.00 CAPITAL OUTLAY 500.00 168.03 33.6 331.97 .00 .00 .00 ENGINEERING 301500.00 33560.22 11.1 267939.78 469350.00 377982.97 80.5 91367.03 SERVICES,SUPPLIES,MATERIAL 4300.00 192.97 4.5 4107.03 5950.00 2734.74 46.0 3215.26 CONTRACT SERVICES 294600.00 33367.25 11.3 261232.75 460700.00 373287.75 81.0 87412.25 CAPITAL OUTLAY 2600.00 .00 2600.00 2700.00 1960.48 72.6 739.52 ***ACTIVITY TOTAL 1374895.00 155871.10 11.3 1219023.90 1320772.00 998504.42 75.6 322267.58 C A P I T A L IMPROVEMENT G&IERAL CIP PROJECTS 63000.00 .00 63000.00 .00 .00 .00 COMMUNITY IMPROVEMENTS 625590.00 151373.55 24.2 474216.45 .00 .00 .00 PARRS 502350.63 123675.37 24.6 378675.26 .00 .00 .00 STREET CONSTRUCTION/IMPROVMT 1166786.15 187109.56 16.0 979676.59 .00 .00 .00 ACITIVITY TOTAL 235 7726.78 462158.48 19.6 1895568.30 .00 .00 .00 TOTAL E X P E N D I T U R E S 11908030.78 2020019.43 17.0 9888011.35 6887438.00 5449810.62 79.1 1437627.38 TRANSFERS OUT TO OTHER FUNDS 172579.37 1622811.00 940.3 1450231.63- 2297.00 867176.00 7752.5 864879.00- 7 O T 0 A'L DISBURSEMENTS 12080610.15 3642830.43 30.2 8437779.72 6889735.00 6316986.62 91.7 572748.38 I IIB(b) This report summarizes the funds on a fund by fund basis. (6� THE CITY OF DUBLIN STATEMENT SHOWING ----IIB(b)---- S A M P L E REVENUES VERSUS EXPENDITURE SAMPLE FOR THE SAMFIN6 PERIOD 7/88 THROUGH 9/88 ` S ce 0(:z� d O e,& FUND 200 CRIMINAL ACTIVITY FUND fu r1a CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE *x*****REVENUES******** PROPERTY TAXES .00 .00 0 .00 .00 .00 0 .00 SALES TAX .00 .00 0 .00 .00 .00 0 .00 REAL PROPERTY TRANSFERS .00 .00 0 .00 .00 .00 0 .00 1..;,vSIENT OCCUPANCY TAX .00 .00 0 .00 .00 .00 0 .00 FRANCHISE TAXES .00 .00 0 .00 .00 .00 0 .00 PENALTIES AND INTEREST ON DELI .00 .00 0 .00 .00 .00 0 .00 LICENSES & PERMITS .00 .00 0 .00 .00 .00 0 .00 FINES & FORFIETURES .00 .00 0 .00 .00 .00 0 .00 SPECIAL BENEFITS ASSESSMENTS .00 .00 0 .00 .00 .00 0 .00 USES OF MONEY AND PROPERTY .00 .00 0 .00 .00 (322.54) 0 322.54 INTERGOVERNMENTAL FROM STATE .00 .00 0 .00 .00 .00 0 .00 INTERGOVERNMENTAL FROM COUNTY .00 .00 0 .00 .00 .00 0 .00 DiTERGOVERNMENTAL FROM F-EDERAL .00 .00 0 .00 .00 .00 0 .00 CHARGES FOR SERVICES .00 .00 0 .00 .00 .00 0 .00 GTEER SOURCES OF REVENUE .00 (987.85) 0 987.85 .00 (25,581.00) 0 25,581.00 TOTAL REVENUE .00 (987.85) 0 987.85 .00 (25,903.54) 0 25,903.54 *********EXPENDITURES'******* GENERAL GOVERNMENTAL ACTIVITIES NON-DEPARTMENTAL PUBLIC SAFETY POLICE 11,550.00 1,546.15 . 13.4 10,003.85 .00 .00 0 .00 PERS01414EL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL 6,200.00 .00 0 6,200.00 .00 .00 0 .00 CONTRACT SERVICES 500.00 .00 0 500.00 .00 .00 0 .00 CAPTIAL OUTLAY 4,850.00 1,546.15 31.9 3,303.85 .00 .00 0 .00 c;ROSSING GUARDS COST .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 ANIMAL CONTROL .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 `1'kAFFIC SIGNALS .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 (.b) CAPIM OUTLAY .00 .00 0 .00 .00 •00 0 •00 DISASTER PREPAREDNESS .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERM. .00 .00 0 1 .00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 ,=.00 .00 .00 0 .00 FIRES SERVICES OF THE JPA .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIEL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 **'tACTIVITY TOTAL 11,550.00 1,546.15 13.4 10,003.85 .00 .00 0 •00 TRANSPORTATION PUBLIC WORKS .00 .00 STREET MAINTENANCE .00 .00 (GL.ST01#6) a' t t r ..,_- 7.7 " ✓z2n sari vZ -r THE CITY OF DUBLIN STATEMENT SHOWING ----IIB(b)---- S R M P L E REVENUES VERSUS EXPENDITURE SAMPLE FOR THE SAftilm PERIOD 7/88 THROUGH 9/88 FUND 205 TRAFFIC SAFETY FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE *******REVENUES******** PROPERTY TAXES .00 .00 0 .00 .00 .00 0 .00 SALES TAX .00 .00 0 .00 .00 .00 0 .00 PEAL PROPERTY TRANSFERS .00 .00 0 .00 .00 .00 0 .00 TRAASIENT OCCUPANCY TAX .00 .00 0 .00 .00 .00 0 .00 FRANCHISE TAXES .00 .00 0 .00 .00 .00 0 .00 PENALTIES AND INTEREST ON DELI .00 .00 0 .00 .00 .00 0 .00 LICENSES & PERMITS .00 .00 0 .00 .00 .00 0 .00 FINES & FORFIEI'URES (85,000.00) (29,984.40) 35.3 (55,015.60) (80,000.00) (75,770.34) 94.7 (4,229.66) SPECIAL BENEFITS ASSESSMENTS .00 .00 0 .00 .00 .00 0 .00 USES OF MONEY AND PROPERTY .00 .00 0 .00 .00 (4,106.44) 0 4,106.44 INTERGOVERNMENTAL FROM STATE .00 .00 0 .00 .00 .00 0 .00 INTERGOVERNMENTAL FROM COUNTY .00 .00 0 .00 .00 .00 0 .00 INTERGOVERNMENTAL FROM FEDERAL .00 .00 0 .00 .00 .00 0 .00 CHARGES FOR SERVICES .00 .00 0 .00 .00 .00 0 .00 CfiHER SOURCES OF REVENUE .00 .00 0 .00 .00 .00 0 .00 TOTAL REVENUE (85,000.00) (29,984.40) 0 (55,015.60) (80,000.00) (79,876.78) 99.8 (123.22) *********EXPENDITURES******** GENERAL GOVERNMENTAL ACTIVITIES NON-DEPARTMENTAL PUBLIC SAFETY POLICE .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 ,-kOSSING GUARDS COST 22,950.00 .00 0 22,950.00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES 22,950.00 .00 0 22,950.00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 ANIMAL CONTROL .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 TRAFFIC SIGNALS .00 10,500.25 0 (10,500.25) 80,000.00 66,693.23 83.4 13,306.77 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL 33,500.00 6,900.60 20.6 26,599.40 26,500.00 28,830.33 108.8 (2,330.33) CONTRACT SERVICES 44,600.00 3,599.65 8.1 41,000.35 53,500.00 37,862.90 70.8 15,637.10 r .•� •.•y.:.r, _...-. . , `Y.r':-;:-^-..w..._�.. --•�.srru ,_ st^.Zr•--•ter�':.-v..±,�,' rem ,','ry s:. ,. r x'i.•sr7'±.'^"... .. �.. r._ Yi ti:SM'l_I l,:": J����i�� . Si:"!���'•..... .:5�.�,x�/�`R'Y _ _ _ ... _ :-mot ��iT.C't '.. r ...... ,+ .. -3116 cl� CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 DISASTER PREPAREDNESS .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 DO .00 .00 0 .00 CONTRACT SERVICES .00 .00 0 _,100 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 , 00 .00 .00 0 .00 FIRES SERVICES OF THE JPA .00 .00 0 .00 .00 .00 0 .00 PERSONNEL .00 .00 0 .00 .00 .00 0 .00 SERVICES, SUPPLIES, MATERIAL .00 .00 0 .00 .00 .00 0 •00 CONTRACT SERVICES .00 .00 0 .00 .00 .00 0 .00 CAPTIAL OUTLAY .00 .00 0 .00 .00 .00 0 .00 x**ACTIVITY TOTAL 22,950.00 10,500.25 45.8 12,449.75 80,000.00 66,693.23 83.4 13,306.77 TRANSPORTATION PUBLIC WORKS •00 .00 SPREET MAINTENANCE •00 '00 (GL.STO1#6) ell III B These reports show the Income Statements summarizing all funds into one presentation format. ;t GL.IU4 THE CITY OF DUBLIN STATEMENT Slt-WING 10/21/88 REVENUF° "ERSUS EXPENDITURE 9.32.41 FOR: 1 c L,� PERIOD 7/85 THROUGH 9/88 1 \S �Q0 64 S ---::> ALL FUNDS COMBINED 0`- S o M mo-r� 0+ aio`. T o r o,,kk �v S CA S 11� . 4 L .�A CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1988 1 o c CkOW N � `^L BUDGET ACTUAL PERCENT VARIANCE BUDGET ACTUAL PERCENT VARIANCE X` ****�**REVENUES*****x* t ` , PROPERTY TAXES 2741700.00- .00 2741700.00- 722500.00- 779607.20- 107.9 57107.20 SALES TAX 5164000.00- 1067784.15- 20.7 4096215.85- .00 .00 .00 REAL PROPERTY TRANSFERS 92140.00- 10489.33- 11.4 81650.67- .00 .00 .00 TRANSIENT OCCUPANCY TAX 100000.00- 25366.77- 25.4 74633.23- .00 .00 .00 FRANCHISE TAXES 301850.00- 13322.50- 4.4 288527.50- .00 .00 .00 PENALTIES AND INTEREST ON DELI .00 .00 .00 .00 .00 .00 LICENSES & PERMITS 355250.00- 40339.50- 11.4 314910.50- 547350.00- 530602.98- 96.9 16747.02- FINES & FORFEITURES 105000.00- 24644.41- 23.5 80355.59- 96500.00- 94583.98- 98.0 1916.02- SPECIAL BENEFITS ASSESSMENTS 363140.00- .00 363140.00- 304912.00- 363604.04- 119.2 58692.04 USES OF MONEY AND PROPERTY 2233323.00- 145737.69- 6.5 2087585.31- 2373212.00- 2249053.02- 94.8 124158.98- INTERNGOVMMnAL FROM STATE 1155200.00- 357001.41- 30.9 798198.59- 1392686.00- 1047272.89- 75.2 345413.11- INTERGOVERNMENTAL FROM COUNTY .00 .00 .00 .00 .00 .00 INTERGOVERNMENTAL FROM FEDERAL 1191100.00- .00 1191100.00- 1396660.00- 625580.97- 44.8 771079.03- CHARGES FOR SERVICES 940360.00- 75616.51- 8.0 864743.49- 848599.00- 475898.12- 56.1 372700.88- OTHER SOURCES OF REVENUE 297000.00- 1248.03- .4 295751.97- 540260.00- 591544.48- 109.5 51284.48 TOTAL REVENUE 15040063.00- 1761550.30- 11.7 13278512.70- 8222679.00- 6757747.68- 82.2 1464931.32- *******E%PENDITURES******* GENERAL GOVERNMENT ACTIVITES NON-DEPARTMENTAL 10313390.37 1727834.09 16.8 8585556.28 11076421.07 7511887.85 67.8 3564533.22 CITY COUNCIL 83490.00 17243.79 20.7 66246.21 89130.00 62010.31 69.6 27119.69 CITY MANAGER 372210.00 54570.03 14.7 317639.97 273438.00 232136.61 84.9 41301.39 CITY ATTORNEY 118700.00 17159.86 14.5 101540.14 109000.00 162594.58 149.2 53594.58- FINANCE DEPARTMENT 169030.00 25597.58 15.1 143432.42 138970.00 125364.11 90.2 13605.89 BUILDING MANAGEMENT 1380150.00 33463.38 2.4 1346686.62 1398490.00 1082153.32 77.4 316336.68 INSURANCE COST CENTER 213125.00 151883.89 71.3 61241.11 136600.00 100293.93 73.4 36306.07 ELECTIONS COST CENTER 2650.00 24.94 .9 2625.06 5000.00 1924.88 38.5 3075.12 ***ACTIVITY TOTAL 12652745.37 2027777.56 16.0 10624967.81 13227049.07 9278365.59 70.1 3948683.48 PUBLIC SAFETY POLICE 1903460.00 114292.92 6.0 1789167.08 1849634.00 1576100.49 85.2 273533.51 CROSSING GUARDS COST 22950.00 .00 22950.00 22200.00 24613.95 110.9 2413.95- ANIMAL CONTROL 43000.00 .00 43000.00 42000.00 30216.97 71.9 11783.03 TRAFFIC SIGNALS 222600.00 28307.23 12.7 194292.77 225500.00 181157.63 80.3 44342.37 DISASTER PREAPREDNESS 17300.00 354.49 2.0 16945.51 20250.00 9221.81 45.5 11028.19 EIRE SERVICES OF THE JPA 1864904.00 769328.00 41.3 1095576.00 .00 .00 .00 ***ACTIVITY TOTAL 4074214.00 912282.64 22.4 3161931.36 2159584.00 1821310.85 84.3 338273.15 TRANSPORTATION PUBLIC WORKS 198300.00 30519.34 15.4 167780.66 159318.00 90718.28 56.9 68599.72 STREET MAINTENANCE 511800.00 19043.05 3.7 492756.95 519400.00 121488.10 23.4 397911.90 STREET SWEEPING 52800.00 4236.83 8.0 48563.17 52500.00 44077.81 84.0 8422.19 STREET LANDSCAPE 90900.00 7534.17 8.3 83365.83 67500.00 45661.57 67.6 21838.43 STREET LANDSCAPE MAINTENANCE 222810.00 34199.95 15.3 188610.05 290910.00 199157.62 68.5 91752.38 PARATRANSIT SERVICES 2000.00 .00 2000.00 26022.00 26002.48 99.9 19.52 ***ACTIVITY TOTAL 1078610.00 95533.34 8.9 983076.66 1115650.00 527105.86 47.2 588544.14 HEALTH & WELFARE VECTOR CONTROL 20500.00 305.08 1.5 20194.92 15500.00 3879.04 25.0 11620.96 GLI04 THE CITY OF DUBLIN STATEMENT SHOWING awszow 10/21/35 REVENUE'° VERSUS EXPENDITURE 9.32.41 FOR: PERIOD 7188 T1ll20UGH 9/83 � � Z-LLL ALL FUNDS COMBINED CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1983 BUDGET ACTUAL PERCENT ,VARIANCE BUDGET ACTUAL PERCENT VARIANCE ***ACTIVITY TOTAL 20500.00 305.08 1.5 20194.92 15500.00 3879.04 25.0 11620.96 CULTURE & LEISURE SERVICES LIBRARY SERVICES 110315.00 .00 110315.00 346180.00 278776.32 80.5 67403.68 PARK MAINTENANCE 382200.00 50133.10 13.1 332066.90 16720.00 12904.52 77.2 3815.43 COMMUNITY CABLE TV 28500.00 .00 28500.00 .00 DO .00 RECREATION 133378.00 25720.21 19.3 107657.79 .00 .00 .00 PLAYGROUNDS 60148.00 13202.16 21.9 46945.84 .00 .00 .00 SHANNON CENTER 60823.00 10376.36 17.1 50446.64 .00 .00 .00 PRESCHOOL 32703.00 2737.75 8.4 29970.25 .00 .00 .00 TEENS PROGRAM 16398.00 2838.21 17.3 13559.79 2100.00 583.44 27.8 1516.56 FIELD SCHEDULING 3668.00 451.22 12.3 3216.78 .00 .00 .00 SPECIAL EVENTS 28532.00 3253.25 11.4 25278.75 1600.00 1446.80 90.4 153.20 SENIOR CENTER 69580.00 9101.98 13.1 60478.02 8500.00 .00 8500.00 RECREATION INSTRUCTION 49787.00 9421.41 18.9 40365.59 33900.00 31075.84 91.7 2824.16 AQUATICS 104543.00 27552.17 26.4 76990.83 41500.00 18004.41 43.4 23495.59 ***AC IVITY TOTAL 1080580.00 154787.82 14.3 925792.18 450500.00 342791.33 76.1 107703.67 COMMUNITY DEVELOPMENT PLANKING 739010.00 72159.80 9.8 666850.20 521530.00 327732.21 62.8 193797.79 BUILDING SAFETY 334385.00 50151.08 15.0 284233.92 329892.00 292789.24 38.8 37102.76 ENGINEERING 320000.00 97092.96 30.3 222907.04 437350.00 1038431.96 213.1 551081.96- ***ACTIVITY TOTAL 1393395.00 219403.84 15.7 1173991.16 1338772.00 1658953.41 123.9 320181.41- CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 63000.00 .00 63000.00 .00 .00 .00 COWJNITY IMPROVEMENTS 726690.00 151373.55 20.8 575316.45 .00 .00 .00 PARRS 890448.63 123675.37. 13.9 766773.26 .00 .00 .00 S;P,EET CONSTRUCTION/IMPROVMT 2421086.15 187109.56 7.7 2233976.59 .00 .00 .00 *`PCITIVITY TOTAL 4101224.78 462158.48 11.3 3639066.30 .00 .00 .00 TOTAL E X P END I T U R E S 24401269.15 3872248.76 15.9 20529020.39 18307055.07 13632406.08 74.5 4674648.99 EXCESS <REVENUE> EXPENDITURES 9361206.15 2110698.46 22.5 7250507.69 10084376.07 6874658.40 68.2 3209717.67 TRANSFERS IN FROM OTHER FUNDS .00 1622811.00- 1622811.00 .00 4809809.00- 4809809.00 TRANSFERS OUT TO OTHER FUNDS 172579.37 1622811.00 %0.3 1450231.63- 2297.00 4809809.00 9395.3 4807512.00- EXCESS <REVENUES> OR EXPENSES 9533785.52 2110698.46 22.1 7423087.06 10086673.07 6874658.40 68.2 3212014.67 I ---IC--- This report shows the most detailed of any Revenue versus Expense report. I only produced the General fund Revenues and the expenses for one department because of the length of the entire report (the entire report is 22 pages long) . This report, however, can show each line item of revenue received and each line item of expenditure in each department that was spent. 1L370 TRIAL BI FOR FUND 1 GENERAL FUND@$�!� 11/10/88 A0. . BALANCES THRU 9/30/88 p 9.02.09 FUND 1 REVENUE SUMMARY L/Q���` Qo� T•+e REMAINING DEPT-OBJ-SUB DESCRIPTION RECEIVED ESTIMATE ESTIMATE %COMP 1000-510-001 PROPERTY TAXES CURRENT SECURED 2416000.00- 2416000.00- .0 % 1vW-510-002 PROPERTY TAXES CURRENT UNSECUED 244000.00- 244000.00- .0 % 1000-510-003 PROPERTY TAXES PRIOR SECURED , 7200.00- 7200.00- .0 % lOuO-510-004 PROPERTY TAXES PRIOR UNSECURED 3500.00- 3500.00- .0 % 1000-510-005 SUPPLEMENTAL PROPERTY TAXES 28000.00- 28000.00- .0 % 1000-510-006 HOUSING AUTHORITY PILOT TAX 43000.00- 43000.00- .0 % 1000-510 ---OBJECT TOTAL * 2741700.00-* 2741700.00-* .0 % 1000-515-000 SALES AND USE TAXES * * .0 1000-520-015 SALES & USE TAX 1050538.15- 5164000.00- 4113461.85- 20.3 % 1000-520-017 REAL PROPERTY TRANSFER TAX 20247.71- 92140.00- 71892.29- 22.0 % 1000-520-018 TRANSCIENT OCCUPANCY TAX 25366.77- 100000.00- 74633.23- 25.4 % 1000-520-019 ELECTRIC FRAACHISE TAX 121500.00- 121500.00- .0 % 1000-520-021 GAS FRANCHISE TAX 29700.00- 29700.00- .0 % 1000-520-022 GARBAGE FRAACCISE TAX 17190.75- 70350.00- 53159.25- 24.4 % 1000-520-023 CATV FRANHCISE TAX 80300.00- 80300.00- .0 % 1000-520 ---OBJECT TOTAL 1113343.38-* 5657990.00-* 4544646.62-* 19.7 % 1000-522-000 FRANCHISE TAX GARBAGE .40-* .40 * .0 % 1000-530-001 LICENSES & PERMITS BUILDING 38666.50- 340000.00- 301333.50- 11.4 % IUOO-530-002 LICENSES & PERMITS ANIMAL PERMITS 30.00- 6000.00- 5970.00- .5 % 1000-530-003 LICENSES & PERMITS BUS BENCH ADS 306.00- 150.00- 156.00 204.0 % 1000-530-004 LICENSES & PERMITS ENCROACHMENTS 2588.00- 9000.00- 6412.00- 28.8 % ;000-530-006 LICENSES & PERMITS RECYCLING TRANSP 100.00- 100.00- .0 °% 1000-530 ---OBJECT TOTAL 41590.50-* 355250.00-* 313659.50-* 11.7 % 1000-532-002 FINES & FORFEITURES OTHER COURT 4283.21-* 20000.00- 15716.79-* 21.4 % 1000-550-001 USES OF MONEY AND PROPERTY INTEREE4T 168302.67- 710500.00- 542197.33- 23.7 % 1000-550-003 USES OF MONEY AND PROPERTY RENTS 13485.75- 37000.00- 23514.25- 36.4 % 1000-550-004 USES OF MONEY AND PROP POOL RENTAL 84.00- 84.00 .0 % 1000-550 ---OBJECT TOTAL 181872.42-* 747500.00-* 565627.58-* 24.3 t luOO-555-001 INTRGVRN REV STATE MOTOR VEH N LIEU 203231.67- 663000.00- 459768.33- 30.7 % 1000-555-002 INTRGVRN REV STATE TRAILER COACH 4100.00- 4100.00- .0 % 10100-555-003 INTRGVRN REV STATE CIGARETTE 25492.41- 106700.00- 81207.59- 23.9 % 1000-555-004 INTRGVRN RVN STATE OFF HIGHWAY 251.83- 400.00- 148.17- 63.0 % 1000-555-005 D TRGVRN REV STATE PROP TAX RELIEF 16400.00- 16400.00- .0 % 1000-555 ---OBJECT TOTAL 228975.91-* 790600.00-* 561624.09-* 29.0 % 1000-565-001 CHARGES FOR SERVICES ZONING & SUBD 32934.69- 375000.00- 342065.31- 8.8 % 1000-565-002 CHARGES FOR SERVICES PLAN CHECKING 238000.00- 238000.00- .0 % 1000-565-004 CHARGES FOR SERVICES SALE MAPS ETC. 984.56- 7500.00- 6515.44- 13.1 % 1000-565-006 CHARGES FOR SERVICES SPE POLICE SER 1500.00- 9000.00- 7500.00- 16.7 % 1000-565-012 CHARGES FOR SERVICES PARKS/REC FEES 19088.66- 139900.00- 120811.34- 13.6 % 1000-*-015 CHARGES FOR SERVICES ADMIN FEES 4068.75- 18400.00- 14331.25- 22.1 % 1000-565-016 CHARGES FOR SERVICES BLDG USE INSR 1683.20- 3500.00- 1816.80- 48.1 % 1000-565-018 CHARGES FOR SERVICES ZONE 7 DRAINAG 52.55- 2000.00- 1947.45- 2.6 % 1000-565-019 CHARGES FOR SERVICES FIELD USE FEES 6395.00- 17000.00- 10605.00- 37.6 % 1000-565-020 CHARGES FOR SERVICES POOL USE FEE 20099.00- 20099.00 .0 % 1000-565-021 CHARGES FOR SERVICES SENIOR PROGRAM 620.15- 620.15 .0 % IUOO-565-022 CHARGES FOR SERVICE USE OF ALTAMONT 7003.64- 7003.64 .0 % 1000-565 ---OBJECT TOTAL 94430.20-* 810300.00-* 715869.80-* 11.7 % 1000-570-002 OTHER REVENUES CONTRIBUTIONS NONGOV 1000.00- 1000.00- .0 % :000-570-003 OTHER REVENUES MISCELLANEOUS 1210.11- 2000.00- 789.89- 60.5 % 1000-570-006 OTHER REVENUES REIMB. PUBLIC DAMAGE 925.28- 1000.00- 74.72- 92.5 % 1000-570 ---OBJECT TOTAL 2135.39-* 4000.00-* 1864.61-* 53.4 % 1000-------DEPARTMENT TOTAL 1666631.41-** 11127340.00-** 9460708.59-** 15.0 % -----------MAL REVENUE 1666631.41- 11127340.00-*** 9460708.59-*** 15.0 % ---------FUND 1 TOTAL 1666631.41- 11127340.00- 9460708.59- 15.0 % tGL370C TRIAL BALANCE C Z 11/10/88 Ac._ d BALANCES THRU 9/30/88 9,09,58 ,FUND 1 APPROPRIATION SU10IARY '�r 1 l•• L y- REMAINING DESCRIPTION BUDGET EXPENDITURES BUDGET %COMP 1050-713-000 OPERATING SUPPLIES 1000.00 * * 1000.00 * .0 % 1050-719-000 RENTALS & LEASES 1288850.00 * 36604.00 * 1252246.00 * 2.8 1050-725-005 GAS & ELECTRIC 16500.00 =43.54 16456.46 .3 $ 1050-725-010 WATER & SEWER 5300.00 ` 698.40 4601.60 13.2 $ 1050-725-020 TELEPHONE, 40000.00 4617.45 35382.55 11.5 1050-725 ---OBJECT TOTAL 61800.00 * 5359.39 * 56440.61 * 8.7 1050-740-000 CONTRACT SERVICES 26200.00 * 135.96 * 26064.04 * .5 $ ,1050-750-050 IMPROVEMENTS NOT BLDG 1000.00 1000.00 .0 % 1050-750-070 MACHINERY & EQUIPMENT 1000.00 1000.00 .0 % 1050-750 ---OBJECT TOTAL 2000.00 * * 2000.00 * .0 % ]050-------DEPARTMENT TOTAL 1380150.00 ** 42179.38 ** 1337970.62 ** 3.1 % 1060-700-000 INSURANCE COST CENTER: * * * ,0 % IU60-717-001 INSURANCE PREMIUMS 175625.00 151883.89 23741.11 86.5 % 1060-717-002 INSURANCE CLAIM PAID 37500.00 37500.00 .0 % 1060-717 ---OBJECT TOTAL 213125.00 * 151883.89 * 61241.11 * 71.3 % 1060-------DEPARTMENT TOTAL 213125.00 ** 151883.89 ** 61241.11 ** 71.3 % 1070-700-000 ELECTIONS COST CENTER: * * * .0 $ 1070-71D-000 OFFICE SUPPLY 100.00 * 24.94 * 75.06 * 24.9 $ 1070-715-000 ELECTIONS ADERTISING 50,00 * * 50,00 * .0 $ 1070-716-000 ELECTIONS PRINTING & BINDING $00,00 * * 500,00 * .0 $ 1070-740-000 ELECTIONS CONTRACT GENERAL 2000.00 * * 2000.00 * .0 $ 1070-------DEPARTMENT TOTAL 2650.00 ** 24.94 ** 2625.06 ** .9 1080-700-000 CITY-WIDE: * * * .0 % 1080-740-090 CITY-WIDE CONTR SERV PURCHASE FAD $ 442500.00 * * 442500.00 * .0 1080-799-000 CITY-WIDE CONTINGENT RESERVE 166579.37 * * 166579.37 * 0 $ 1080-------DEPARTMENT TOTAL 609079.37 ** ** 609079.37 ** .0 % 2010-700-000 POLICE DEPARTMENT: * * * 0 % 2010-701-002 SALARIES PART TIME 14420.00 3192.00 11228.00 22.1 % 2010-701-006 WORKERS COMPENSATION 610.00 610.00 .0 % _X0-701 ---OBJECT TOTAL 15030.00 * 3192.00 * 11838.00 * 21.2 % 2010-710-000 OFFICE SUPPLY .2400.00 * 411.43 * 1988.57 * 17.1 % 2010-711-000 POSTAGE 1750.00 * 913.37 * &36.63 * 52.2 % 2010-712-000 COPIER SUPPLIES 1200.00 * 450.87 * 749.13 * 37.6 % 2010-713-000 OPERATING SUPPLIES 12400.00 * 495.45 * 11904.55 * 4.0 % 2010-715-000 ADVERTISING 500.00 * * 500.00 * .0 % 2010-716-000 PRINTBIG & BNDING 2000.00 * 39.32 * 1960.68 * 2.0 % 2010-718-000 REPAIRS & MAINTENANCE 2000.00 * 535.09 * 1464.91 * 26.8 % 2010-719-000 RENTAL & LEASES 7380.00 * 268.68 * 7111.32 * 3.6 % 2010-720-000 BOORS & PUBLICATIONS 300.00 * 20.00 * 280.00 * 6.7 % 2010-721-000 MEMBERSHIPS 200,00 * 25,00 * 175.00 * 12.5 % 2010-723-000 TRAVEL & CONFERENCES 2500.00 * 816.11 * 1683.89 * 32.6 2010-724-000 TRAINING 1200.00 * * 1200.00 * 0 % 2010-739-000 INTERNAL SERVICE CHARGE 6340.00 6340.00 .0 % 2010-739-001 INTERNAL SERVICE CHARGE VEHI 88200,00 88200.00 .0 % ' 2010-739 ---OBJECT TOTAL 94540.00 * * 94540.00 * .0 % 2010-740-000 CONTRACT SERVICES GENERAL 14100.00 365.00 13735.00 2.6 % i' 2010-740-001 CONTRACT SERVICE PERSONNEL 1425950.00 100005.10 1325944.90 7.0 % 2010-740-002 CONTRACT SERVICES VEHICLES 15000.00 1261.42 13738.58 8.4 % t' 2010-740-003 CONTRACT SERVICES INDIRECT 78680.00 6556.08 72123.92 8.3 % i f' 'GL370C TRIAL BALANCE .Y 11/li)/c�8 ACCOUNT BALANCES THRU 9/30/88 9.10.00 FUND 1 APPROPRIATION SUMMARY *DQ+a:k C L1 ^e T,j.,,. c� Y•P J- f ' MMMM REMAINING DESCRIPTION BUDGET EXPENDITORES BUDGET %COMP 2010-740-004 CONTRACT SERVICES DISPATCH 146070.00 146070.00 .0 % 2uiO-740-005 CONTRACT SERVICES ADMiINISTRA 23750.00 23750.00 0 % 2010-740-006 CONTRACT SERVICES SERV/SUPPL 36910.00 r 36910.00 .0 % 2010-740 ---OBJECT TOTAL 1740460.00 * 108187.60 * 1632272.40 * 6.2 % 2010-750-070 MACHINERY & EQUIPMENT 8050.00 * * 8050.00 * .0 % 2010-------DEPARTMENT TOTAL 1891910.00 ** 115354.92 ** 1776555.08 ** 6.1 % .2020-700-000 CROSSING GUARDS COST CENTER: * * * .0 % 2020-------DEPARTMENT TOTAL ** ** ** .0 % 2030-700-000 ANIMAL CONTROL COST CENTER: * * * 0 °s 2030-740-060 ANIMAL CONTROL CONTR SER SHELTER 15000.00 15000.00 .0 % 2030-740-061 ANIMAL CONTROL CONTR SER FIELD SER 28000.00 28000.00 .0 % 2030-740 ---OBJECT TOTAL 43000.00 * * 43000.00 * .0 % 2030-------DEPARTMENT TOTAL 43000.00 ** ** 43000.00 ** .0 % 2040-700-000 TRAFFIC SIGNAL COST CENTER: * * * .0 $ 2040-------DEPARTMENT TOTAL ** ** ** 0 % 2050-700-000 DISASTER PREPAREDNESS COSTS: * * * 0 % 2050-714-000 CDMAiUMTICATIONS 850.00 * 85.13 * 764.87 * 10.0 % 050-716-000 PRINTING 400.00 * * 400.00 * .0 % 2050-720-000 BOOKS &PUBLICATIO 100.00 * * 100.00 * .0 % 2050-721-000 MEMBERSHIPS & DUE 100.00 * * 100.00 * .0 % 2050-724-000 TRAINING 850.00 * * 850.00 * .0 % 2050-740-000 CONTRACT SERVICES 15000.00 * 269.36 * 14730.64 * 1.8 % 2050-------DEPARTMENT TOTAL 17300.00 ** 354.49-** 16945.51 ** 2.0 % 2060-740-000 CONTRACT SERVICES GENERAL 1864904.00 * 769328.00 * 1095576.00 * 41.3 % 2060-------DEPARTMENT TOTAL 1864904.00 ** 769328.00 ** 1095576.00 ** 41.3 % 3010-700-000 PULBIC WORKS DEPARTMENT: * * * .0 % 3010-701-001 SALARIES FULL TIME 88975.00 17107.10 71867.90 19.2 % 3010-701-003 SALARIES OVERTIME 1450.00 97.62 1352.38 6.7 % 3010-701-004 RETIREMENT 9850.00 928.47 8921.53 9.4 % 3010-701-005 GROUP INSURANCE 7070.00 618.72 6451.28 8.8 % 3010-701-006 WORKERS COMPENSATION 2920.00 2920.00 .0 % 3010-701-008 MEDICARE PORTION FICA 915.00 164.87 750.13 18.0 % 3010-701 ---OBJECT TOTAL 111180.00 * 18916.78 * 92263.22 * 17.0 % 3010-710-000 OFFICE SUPPLY 1200.00 * 302.89 * 897.11 * 25.2 % 3010-711-000 POSTAGE 1630.00 * 643.62 * 986.38 * 39.5 % 3010-712-000 COPIER SUPPLIES 850.00 * 284.76 * 565.24 * 33.5-% 3010-726-000 PRINTING & BINDING * 63.23 * 63.73-* .0 % 3010-720-000 BOOKS & PULBICATIONS 500.00 * 25.00 * 475.00 * 5.0 % 3010-721-OOD MEMBERSHIPS 550.00 * * 550.00 * .0 % 3010-722-000 MILEAGE & AUTO ALLOWAHC 2460.00 * 429.10 * 2030.90 * 17.4 % 3010-723-000 TRAVEL CONF & MEETINGS 1900.00 * 74.37 * 1825.63 * 3.9 % 3010-724-000 TRAINING 1050.00 * * 1050.00 * .0 % 3010-739-000 INTERNAL SERVICE CHARGE 2130.00 * * 2130.00 * .0 % 3010-7,10-029 CONT SER SUPERVISION 73800.00 * 13226.40 * 60573.60 * 17.9 % 3010-750-060 FUR1TME & FIXTURES 850.00 243.73 606.27 28.7 % 3010-750-070 MACHINERY & EQUIPMENT 200.00 200.00 .0 % 3010-750 —OBJECT TOTAL 1050.00 * 243.73 * 806.27 * 23.2 % CITY OF DUBLIN BALANCE SHEEP FOR THE PERIOD ENDING MARCf1 31, 1988 TRAFFIC STATE ST PARK SR CIT7.N PARK CH"N FTSM GENFJ7AL SAFETY GAS TAR REVENUE CDBG fAU TRNSPTN BOND ACT BOND ACT DEDICATION PARKLANDS M-ASURE B GRANT FUND FUND FUND SHARE FND FUND MINI) DVLP FUND FUND FUND FUND FUND FUND FUND (#001) (#205) (#206) (#208) (#209) (#210) (#211) (#213) (#214) (#215) (#216) (#217) (#220) ASSETS Cash & Investments 8,728,753 61,523 346,334 1,412,506 (3,547) 1,068,318 62,631 Accounts Receivable (290) Amounts Due from Others 510,1(i ti 460,498 Prepaid Items (2,717) Fixed. Assets Other --------- ------- -------- ------- ------- ------- ------- ------- ------- , ------- 'DOTAL ASSETS 9,235,912 61,523 346,334 1 ,573,004 (3,547) 1,068,318 62,631 ---------- ------- -------- ------- ------- LIABILITIES Accounts Payable -� 40,514 15,600 Deposits from Others 88,265 Advances Due Others 8,6(10 460,498 Deferred Revenues 26,000 Bonds & Certificates Pyb1 Other Payables --------- ------- -------- ------- ------- ------- ------- ------- ------- ------- ------ ------- ------- TOTAL LIABILITIES 128,779 34,660 460,498 15,600 FUND EQUITY Fund Reserve 7,565,036 41.,1:37 168,1.28 (955) (34,660) 797,375 786,255 Fund Balance 2,381,116 20,386 178,206 615,131 (3,547) 15,202 282,063 62,631 Fund Transfers .(839,019) 955 (15,600) (15,202) --------- ------- -------- ------- ------- ------- ------- ------- ------- ------- ------ ------- ------- TOTAL FUND EQUITY 9,107,133 61,523 346,334 (34,660)1,412,506 (19,147) 1,068,318 62,631 TOTAL LIABILITIES & FUND EQUITY 9,235,912 61,523 346,334 1,873,004 (3,547) ------- 1,068,318 62,631 �....) Cam,�• �� � r/ CITY OF DUBLIN BALANCE SHEET FOR T11E PERIOD ENDING N%W1 31, 1.988 ASSESSMENT, CAPITAL & SPECIAL FUM)S ----------------------------------- ST LGifT LNDSCP SN RMN RD SR RD I.GHT/LND DB1.N BLVD TRUST INTERNAL FIXED CAPITAL DUBLIN DUBLIN INFO ASSMr DSTR AS." DST SPCF PLN BND RSRV MTC ASMr EXTN ASS`fr DEPOSIT SERVICE ASSET'S PROJECTS INFO INC INC. OXSTR TOTAL FUND FUND ASSMr FND FUND FUND FU'MD FUND FUND FUND FUND FUND FUND ALL FUNDS (#710) (#711) (#712) (#714) (#713) (#715) (#828) (#830) (#901) (#3XX) (#601) (=603) ASSETS Cash & Investments 46,933 4,579 380,042 72,356 35,050 1,500 172,650 87,359 (2,090,939) 7,665,511 (84,494) 17,967,065 Accounts Receivable (290) Amounts Due from Others 2,093,693 3,064,357 Prepaid Items 8,616 5,899 Fixed Assets 146,687 143,911 8,132,438 8,423,036 Other 575,971 q71 ------- ------- -------- ------- ------- ------- ------- ------- -------- --------- --------- --------- -- -- TOTAL ASSETS 46,933 4,579 956,013 72,356 35,050 1,500 172,650 242,662 143,911 2,754 15,797,949 184,494) 30,G_ ,.138 LIABILITIES } Accounts Payable 56,114 Deposits from Ot}iers 3,125 :63,21!3 256,609 Advances Due Others (13,:309 2,112,039 2,644,506 Deferred Revenues 575,971 601,971 Bonds & Certif.'i.cates Pybl 857,869 11,795,000 12,652,869 Other Payables 1,500 1,500 ------- ------- -------- ------- ------- ------- ------- ------- -------- --------- --------- --------- --------- TOTAL LIABILITIES 1,436,965 1,5;)0 165,219 63,309 2,112,039 11,795,000 16,213,569 FUND EQUITY Fund Reserve 16,919 24,208 (420,000) 72,356 7,431 164,349 143,911 (178,759) 5,038,143 14,220,874 Fund Balance 14 (19,629) (60,952) 35,050 15,004 (1,961,328)(1,873,258) (84,494) (398,405) Fund Transfers 30,802 838,064 ------- ------- -------- ------- ------- ------- ------- ------- -------- --------- --------- --------- --------- TOTAL FUND EQUITY 46,933 4,579 (480,952) 72,356 35,050 7,431 179,353 143,911 (2,109,285) 4,002,949 (84,494) 13,822,469 TOTAL LIABILITIES & FUND EQUITY 46,933 4,579 956,013 72,356 35,0.0 1,500 172,650 242,662 143,911 2,754 15,797,949 (84,494) 30,. 038 CITY of DUBLIN SUMMARY OF REVENUE & D.PENDITURES ALL FUNDS CONSOLIDATED FOR THE PERIOD FNIDED Mi CH 31, 1988 CURRENT YEAR TO PERCE;�T 01 BLT�ET MONTH DATE BALANCE BUDGET Yi REVT.NUL:S Property Tax 722,500 31,709 554,946 167,554 76.81% Other. Taxes 5,598,500 581,827 3,798,145 1,800,355 67.84% Licenses &. Permits 547,350 42,247 485,900 61,450 88.77% Fines & Forfeitures 96,500 8,164 76,232 20,268 79.000% Special Assessments 304,912 10,984 204,403 100,509 67.04% For Use of Toney & Property- 2,373,212 47,436 1,787,344 585,868 75.31% Intergovmmntl Rev - State 1,392,686 127,354 782,358 610,328 56.18`0 Intergo-v,mntl Rev - Federal 1,396,660 615,131 781,529 44 .0-1% Charges for Services 843,599 20,924 321,562 527,037 37.89% Other Revenue 540,260 42,933 578,175 (37,915) 107.02% ----------- ---------- ----------- ----------- ------ TOTAL. REVENUES 13,821,179 913,378 9,204,196 4,616,983 66.5 9% L PENDITURES General Government 101 City Council 89,130 5,004 42,983 46,142 48.23% 102 City Manager/Clerk 275,544 18,173 172,534 103,010 62.620'0' 103 Legal Services 109,000 8,620 73,730 35,270 67.64% 104 Finance 138,970 10,441 93,296 45,674 67.13% 105 Building ?Management 1,398,490 14,090 1,048,647 349,843 -14.98 106 Insurance 136,600 5,621 98,424 38,176 12.0:0 107 Elections 5,000 5,000 108 Non-Departmental 289,546 250,000 39,546 86.3-% ----------- ---------- ----------- ----------- ------ Total General Government 2,442,280 61,949 1,779,619 662,661 72.870 Public Safety 201 Police Services 1,849,634 123,155 959,560 890,074 51.8x% 202 Crossing Guards 22,200 5,791 13,853 8,347 62.40�', 203 Animal Control 42,000 20,082 21,918 47.81'- 204 Trfc S,'nls/Sft; Lghtg 2'25,500 15,056 123.313 102,187 54.680 205 Disaster Preparedness '20,'250 225 8,018 12,232 39.(;0'') ----------- ---------- ----------- ----------- ------ Total n- iblic Safety 2,159,584 144,227 1,121,826 1,034 ,758 52.0`. o Transportation 301 Public Works 159,318 7,826 66,990 92,323 12.05 302 Street `faintenance 519.400 4,190 87,013 432,387 16.750 303 Street Steeping 5'2,500 4,322 30,754 21 ,745 58.58:0 304 Street Tree Maintenance 67,500 2,316 29,706 31,794 44.01a 305 Street Landscape `ltc 290,910 14,797 152,497 138,413 52.4'20 306 Paratransi.t Service 26,022 2,135 23,289 2,733 59.500 ----------- ---------- ----------- ----------- ------ Total Transport:aion 1 , 11,0-,650 35,586 390,2-19 -125,401 3,1.95;5 Health & Welfare 501 Vector Control Service 1 15,500 1,855 13,645 11 .9 Summary Revenue &: Expenditure port CURRENT �R TO PERCE.LT 01 All Funds Consolidated - Page 2 BLTCET MONTH DATE BALANCE BUT E YTI Culture &. Leisure Services 701 Library Service 103,500 51,750 51,750 50.GO% 10.1> Park Maintenance 29,100 1,197 4,252 24,848 14.61% 70LI Community Cable Tv 21,000 10,000 21,000 100.0(1% 8XX Parks &. Recreation 450,500 32,623 240,334 210,166 5:3.35% ----------- ---------- ----------- ----------- ------ Total Culture &. Leisure Services 604,100 43,820 317,336 286,764 52.53% Community Development 901 Planning 521,530 30,060 250,662 270,863 48.06% 902 Building & Safety 329,892 24,386 222,759 107,133 67.52'0 903 Engineering 487,350 34,890 282,927 204,423 58.050 ----------- ---------- ----------- ----------- ------ Total Community Development 1,338,772 89,336 756,348 532,421 56.5G% Internal Service Fund Charges 118,859 6,141 34,060 84,799 28.66% TOTAL OPERATING EXPENDITURES 7,794,745 381,059 4,404,293 3,390,452 56.50% DEBT SERVICE -SR RD ASSMT DISTR 123,062 121,131 1,925 98.44% DUBLIN INIFOPMATION INC. =ENDITLRES Operating Expenditures 11,250 (649) 4,003 7,247 35.5E% Debt Service Expenditures 1,252,242 1,246,402 5,840 99.53% Civic Center E:\Tenditures 4,276,834 :379,284 1,576,286 2,700,548 36.86% ----------- ---------- ----------- ----------- ------ TOTAL DtBLIN INTGI`[:1TION INC. 5,540,326 378,635 2,826,691 2,713,635 51.02% DUBLIN INFO I :C CONSTRUCTION FLIT 84,494 84,494 (84,494) CAIPITAL I`IPROVDENT FUNDS EXPENDITLRES General Improvements 153,500 85,345 68,155 55.60% Community Improvements 868,855 5,374 110,486 758,369 12.72% Parks Improvements 1,693,308 206,595 1,041,948 651,360 61.53'/0 Street Improvements 2,298,057 50,431 928,204 1,369,853 40.39 o ----------- ---------- ----------- ----------- ------ TOTAL CAPITAL I`IPRVMINT FLITS 5,013,720 262,400 2,165,983 2,847,737 43.20% TOTAL ALL EKPENDITURES 18,471,853 1 ,106,588 9,602,598 8,6:69,255 51 .9co ----------- ---------- ----------- ----------- ------ �PPROPRIATIONS FRCh RESERVES (4,650,674) (19:3,210) (398,402) (4,252,272) 0.5 ----------- ---------- ----------- ----------- ------ ----------- ---------- ----------- ----------- ------ CITY OF DUBLIN STATEMENT OF REVENUE & EXPENDITURES FOR THE PERIOD ENDING MARCH 31, 1988 REVENUE REPORT Percent of ---------------------------------- Estimated Current Received Estimate GENERAL FUND W 001) Revenue Month Yr To Date Received ---------------------------------- --------- -------- ---------- ---------- PROPERTY TAY 510.01 Current Year Secured 495,000 (30,084) 320,679 64.78% 510.02 Current Year Unsecured 69,500 49,249 59,153 85.11% 510.03 Prior Year Secured 16,500 8,398 8,853 53.65% 510.04 Prior Year Unsecured 2,000 2,288 2,761 138.05% 510.05 Supplemental Property Tax 8,000 1,658 15,859 198.24% 510.06 Pilot Tam: 131,500 147,641 112.27% ----------- --------- ---------- ----- Total Property Tax 722,500 31,509 554,946 76.81% OTHER TAXES 515.00 Sales & Use Tax 5,050,000 570,232 3,476,224 68.84% 517.00 Real Property Transfer Tax 80,000 53,815 67.27% 518.00 Transient Occupancy- Tax 102,000 77,129 75.62% 519.00 Electric Franchise Tax 120,000 521.00 Gas Franchise Tax 30,000 522.00 Garbage Franchise Tax 63,000 3,810 50,062 79.46% 523.00 CATV Franchise Tax 72,200 78,284 108.43% ----------- --------- ---------- ----- Total Other Taxes 5,517,200 574,042 3,735,514 67.71% LICENSES & PERMITS 530.01 Building Permits 535,000 41,637 470,970 88.03% 530.02 Animal Licenses 7,000 4,686 66.94% 530.03 Bus Bench Ad Permits 300 306 102.00% 530.04 Encroachment Permits 5,000 610 9,888 197.76% 530.06 Recycling Transport Permits 50 50 100.00% ----------- --------- ---------- ----- Total Licenses & Permits 547,350 42,247 485,900 88.77% FIDES & FORFETILRES 532.02 Other Court Fines 16,500 1,132 14,466 87.67% REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest 596,000 40,545 798,985 134.06% 550.03 Rents & Concessions 40,970 6,891 49,176 120.03% ----------- --------- ---------- ----- Total Rev-Use of Money & Prpt.y 636,970 47,436 848,161 133.16% I.=GOVERN"MENTAL, REVENUES - STATE 555.01 Motor Vehicle in Lieu tax 628,000 67 ,367 442,942 70.53% 555.02 Trailer Coach in Lieu Tax 8,500 2, 124 24.99% 555.03 Cigarette Tax 103,400 6,002 76,812 74.29% 555.04 Off Hghwy Vehicle in Lieu Tat 400 152 38.00% 555.05 Homeowner's Prprty Tax Relief 15,500 9,684 62.48% ----------- --------- ---------- ----- Total Intergvnmt1 - State 755,800 73,369 531,714 70.35% Percent of Revenue Report - Page 2 Estimated Current .-_ceived Estimate Revenue Month Yr To Date Received --------- -------- ---------- ---------- CHARGES FOR SERVICES 565.01 Zoning & Subdivision Fees 200,000 675 39,797 19.90% 565.02 Plan Check & Inspection Fees 400,000 142,709 35.68% 565.04 Sales of Maps &. Documents 5,500 1,710 6,959 126.53% 565.06 Special Police Dept. Services 15,000 839 5,646 37.64% 565.12 Park & Recreation Fees 87,900 6,773 51,577 58.68% 565. 15 Other Charges for Services 12,000 6,291 12,696 105.80% 565.16 Building Use Insurance 5,000 396 3,578 71.56% 565. 18 Zone 7 Drainage Fees 2,000 125 1,852 92.60% 565.19 Field Use fees 2,340 4,115 7,684 328.38% ----------- --------- ---------- ----- Total Charges for Services 729,740 20,924 272,498 37.34% OTHER REVENUES 570.01 Sale of Real & Prsnl Prpty 41,200 31,842 53,423 129.67% 570.02 Non-Government Contribution 1,000 390 39.00% 570.03 Miscellaneous 2,000 1,838 91.90% 570.05 Reimbursements - General 5,000 570.06 Reimbursement for Public Dmg 5,000 995 1,923 38.46% 570.07 Trash Bag Program 5,500 405 3,770 68.55% ----------- --------- ---------- ----- Total Other Revenue 59,700 33,242 61,344 102.750% TOTAL GENERAL FUND 8,985,760 823,901 6,504,543 72.39% TRAFFIC SAFETY FU'-.\T ( 205) --------------------------------- FINES & FOREFEITURES 532.01 Vehicle Code Fines 80,000 7,032 61,766 77.21% REVENUE FROM USE OF MONEY & PRPTY 550.01 Interest 200 ----------- --------- ---------- ----- TOTAL, TRAFFIC SAFETY FUND 80,200 7,032 61,766 77.01% STATE GAS TAX FL:,\D ( 206) ------------------------------- RENtiNUE FRUI LSE OF MONEY & PRPTY 550.01 Interest 8,200 I\fiERGOVER'v�- IENTAL RE\1�1\iUES - STATE 555.07 State Gas Ta_x (2106) 100,000 17,503 76,545 76.55% 555.08 State Gas Tax (2107) 194,000 36,182 148,179 76.38% 555.09 State Gas Tax (2107.5) 4,000 5,000 125.0090 ----------- --------- ---------- ----- Total State Gas Tax 298,000 53,985 229,724 77.09% TOTAL STATE GAS TAX ICI)\1) 306,200 53,985 229,724 i CLANL`9UNITY DE\BLOP`IE\,7 BLOCK GR=\NT FUND ( 209) ---------------------------------------------------- IN'CERGOVE,,Wl NTAL RaWENUES - FEDER,\L 559.02 Community- Dvlpmnt Block Grant 34,660 Percent of Revenue Report - Page 3 Estimated Current eceived Estimate Revenue Month Yr To Date Received. --------- -------- ---------- ---------- FEDERAL AID URBAN FUND (K 2 10) ---------------------------------- INTF.RGOVERN"MNTAL REVENUES - FEDERAL 559.03 Federal Aid Urban Funds 1,362,000 615,131 45.16% TRANSPORTATION DaTLOPMENT ACT FUND (n 211) -------------------------------------------------- INTERGOVERN.NE\,7A_, REVE..\1UE - STATE 555. 10 Article 4.5 Fnds (Paratransit) 11,436 5,718 50.00% 555.11 Artcl 3 Fnds (Bicycle/Pedstrn) 145,000 ----------- --------- ---------- ----- TOTAL TRANSPORTATION DVLPMNT ACT FUND 156,436 5,718 3.66% STATE PARK BOND ACT FUND (# 213) --------------------------------------- INi'ERGOVERNM 7FAL REVENUE - STATE 555. 12 State Park Bond Funds 50,000 15,202 30.40% SENIOR CITIZENS BOND ACT FUND (T 214) --------------------------------------- INTERGOVERN`ENTAL REVENUE - STATE 555.13 Senior Citizen Bond Act Grant 73,650 PARK DEDICATION FUND (;;215) ---------------------------------- REVENU'E FROM USE OF MONEY" & PRPTY 550.01 Interest 25,000 OTHER REVENUE 570.04 Park Dedication Fees 50,000 282,063 564.13% ----------- --------- ---------- ----- TOTAL PARK DEDICATION FUND 75,000 282,063 376.08% CC`L`IUNITY PARIa.-\NDS ACT FUND (1 216) --------------------------------------- INTERGOVER.N`ff-\-T.AL REVENUE - STATE 555.14 CormnLmity Parklands Act Grant 48,000 t IE.LSURE B FUNS --------------------- T_1.L REVENUE 515.00 Sales &- Use TaN 81,300 7,785 62,631 77.04% FUEL EFFICIENT TRAFFIC �!NG�L\T GR=ANT FUINID 0220) -------------------------------------------------- INI'ERGOVERNMELTAL REVENUE - STATE 555.15 Fuel Efficient TSM Grant 10,800 STREET LIGHTING ASSESS`IE.NT DISTRICT FUND (. 710) -------------------------------------------------- 5:34.03 Special Assessments 144,500 4,93)9 85,087 58.88% 550.01 Interest 4,150 ----------- --------- ---------- ----- `l.'OTAL ST. LIGHT ASSMNT DISTR FUND 148,650 4,939 85,087 57.24% Percent of Revenue Report - Page 4 Estimated. Current Deceived Estimate Revenue Month Yr To Date Received --------- -------- ---------- ---------- L, DSCAPE ASSESSMN'T DISTRICT F%-'D ( ; 7 11 } --------------------------------------- 534.03 Special Assessments 41,200 465 24,081 58.45% 550.01 Interest 31300 570.02 Contributions from Others 15,860 15,860 100.00% ----------- --------- ---------- ----- TOTAL LANDSCAPE ASSMNT DISTR FL�.TD 60,2160 -165 39,941 66.17% SAN Ra."'10N RD SPC'FC PLN ASS`TI' DISTR (7 i 12) --------------------------------------- 534.03 Special assessments 119,21.2 60,185 50.49% 550.01 Interest 30,000 ----------- --------- ---------- ----- TOTAL SAN RAMON RD SPCFC PLN ASSHT 149,212 60,185 40.34% LVNDSCAPE/LGHTNG ASSMT DIS Tr'5511 (--r -1 13) ---------------------------------------- 534.03 Special Assessments 5,580 35,050 DUBLIN INFOR:`LITION, INC. FUND ( 601 ) --------------------------------------- 550.01 Interest 275,500 550.03 Rents S. Concessions 1,2521242 939,183 5.C000, 570.03 Miscellaneous Revenue 14,250 ----------- --------- ---------- ----- TOTAL DUBLIN INFO. , INC. FUND 1,527,742 903,433 62.41% I\'TERNAL SIRVICE FUND {x 8:30) ---------------------------------- 550.01 Interest 950 565. 17 Equipment Usage 118,859 49,064 41.28"0 ----------- --------- ---------- ----- TOTAL: I:v'IF7tiN:vL SE v-ICE FUND 119,809 49,064 -10.95% CAPITAL FROJECU FliND (= 3X1) ---------------------------------- 550.01 Interest 1.36,700 570.02 Contributions Non-Govt Sources '10.000 91691 204.658 2046.58°0 570.05 Reimbursements =104,100 ----------- --------- ---------- ----- TOTAL CAPITAL: PROJECTS FTD 551 ,400 9,691 204,658 :37.12% TOTa-Vtj R.EVE17E - ALL FUNDS 13,8'21,179 913,373 9,204,196 66.59% $LDGET TRANSFERS IN To General Fund 415,660 `I'o Re-venue Sharin ' Fiu1d 9553 955 To Dublin Information, .Inc. 893,T14 8:38,064 1,13.77% To C:?.p1tal Frojacts Fund 167,800 15,600 30,80'.: 18.36% ----------- --------- ---------- ----- TOTA(.., i3L!DGI-:T TRANSFERS IN 1 ,477,1741 16,555 869,821 58.85% ----------- --------- ---------- ----- CITY OF DUBLIN STATI TENT OF REVENUE AND F-�,-PEN1)IT1 RES FOR T JI PERIOD ENDING MARCH 31, 1988 r-XPENDI'111RE REPORT CIJ1RRFNT YEAR TO PM- CE\,'I' OF GDlER,'L FL110 BLTXIET MONTH DATE BAL.`u'vCE BT - --T1D 101 CITY" COUNCIL Personal Services 701.02 Salaries, Part Time 18,000 1,386 13, 167 4,833 73. 15% 701.04 Retirement 1, 100 84 802 298 72.91% 701.05 Group Insurance 13,098 6,983 6,115 53.31% 701.06 Worker's Compensation 110 60 50 54.15% ----------- ---------- ----------- ----------- ------ Total Personal Services 32,308 1,470 21,012 11,296 65.04% Services & Supplies 710.00 Office Supplies 375 37 99 276 26.4:5.': 711.00 Postage 185 3 83 102 44.86% 716.00 Printing & Binding 250 10 240 4.00% 718.00 Repairs & :Maintenance 1,200 1,200 720.00 Books & Publications 200 48 152 24.00% 721.00 Memberships & Dues 6,500 2,810 =1,271 2,229 65.71% 723.00 Travel & Conferences 10,900 559 6,040 4,860 55.41% 724.00 Training 5,O()0 5,0()0 728.00 Legal Notices 1,200 87 625 575 52.03% 729.00 Professional Services 5,500 5,000 500 90.91 731.00 Community Pormotions 19,762 38 5,300 14,462 26.82`0 ----------- ---------- ----------- ----------- ------ Total. Services & Supplies 511,072 3,5:34 21,476 29,596 42.0550 750.10 C'ptl aztla --Land 250 250 750.60 Cptl Outlay--Furn/Fxtrs 500 500 lOU.00`a 750.70 Cpt1 Outlay-`lchnry/Eqp 5,000 5,000 101 TOTAL CITY COUNCIL 89,130 5,004 42,988 46,142 48.23 102 CITY K.--WAGER / CLERK Personal Services 701.01 Salaries, Fuil. Time 170,905 12,732 126,072 44,833 73.71; 701 .02 Salaries, Part Time 701.03 Salaries, Overtime 2,450 41 616 1,834 25.14% 701 .04 Retirement 15,343 1,121 11 ,363 3,980 74.C6'1 701.05 Group Insurance 17 ,026 330 9,522 7 ,504 55.0:3 701 .06 Worker's C'om.pensation 5,21,4 1,716 3,-38 32.665a 701.08 `Iedicare FICA 330 24 223 107 67.511-11% ----------- ---------- ----------- ----------- ------ Total Personal Services 211,303 14,261 1-19,512 61,796 ;U.;60 710.00 Office Supplies 3,800 192 1,563 2,237 -11 .13% 711.00 Postage ?.,050 117 1,622 428 19 'a 712.00 Copier Supplies 2,550 984 1,566 38.709%, 715.00 Advertising 1,350 193 1,203 147 80.11 10211 715.00 JP_\ Fire Auth Advrtsng 277 277 (277) 716.00 Printing & Binding 21000 104 378 1 ,622 1.5.00% Expenditure Report - Page 2 CLRRENiT AR TO PERCEv1' O BUDGET MOI iT11 DATE BAL AINCE BLJDGET-iTO CITi' MANAGER / CLERK - Servcs & Su-pp (Continued) 71.8.00 Repairs & Mtc 340 276 64 81..1c//0 720.00 Books & Publications 1,300 86 262 1,038 20.15% 721.00 Memberships & Dues 670 80 651 19 91.16% 722.00 Auto Mileage & Allow. 5,210 355 3,044 2, 196 58.090/ 723.00 Travel & Conferences 5,900 2,274 5,386 514 91.29% 724.00 Training 3,250 1,401 1,849 43.11% 1021. 730.00 JPA Fire Auth File Fee 5 5 (5} 730.00 Internal Service Chrgs -1 ,280 3,640 3,640 50.00°/ ----------- ---------- ----------- ----------- ------ Total Services & Supplies 35,730 3,688 20,692 15,038 57.910 740.00 Contract Services 7,500 7,500 1021 740.00 JPA Fire Contract Srvc 18,000 18,000 750.60 Cptl Outlay-Furn/Fxtrs 500 224 224 276 44.80% 750.70 Cptl Outlay-Mchnry/Eqp 2,506 2,106 400 84.04% ----------- - ------ ----------- ----------- ------ Total Capital Outlay 3,006 224 2,330 676 77.510% 102 TOTAL CITY 1A AGER / CLERK 275,544 18,113 172,534 103,010 62.62% 103 LEGAL SERVICES 701.04 Prsnl Srvc - Retiremnt 3,400 162 933 2,46-1 27.44 00 729.00 Profs Srvcs - General 89,600 8;3138 63,869 25,731 11.28`0 729.01 Profs Srvcs - Litigatn 16,000 90 8,928 1 ,072 -5.80% ----------- ---------- ----------- ----------- ------ 10:3 TOT:1L: LEGAL SERVICES 109,000 8,620 73,730 35,270 67.64/o 104 FINANCE Personal Services 701.01 Salaries, Full Time 79,500 6, 115 55,139 24,361 69.36% 701.03 Salaries, Overtime 700 40 660 5.710 701.04 Retirement 4,840 316 3,357 1,483 69.36 701.05 Group Insurance 8,310 300 3,654 4,716 43.66` 701.06 Worker's Compensation 560 202 358 36.01;' 701.08 Medicare FICA "160 58 533 221 70. 13% ----------- ---------- ----------- ----------- ------ Total Personal Services 94,130 (3,909 62,925 31 ,305 66. 130 Services & Supplies 110.00 Office Supplies 1,-1�0 100 587 863 40.-18% 71.6.00 Printing & Binding 2,200 200 881 1,319 40.05;0 718.00 Repairs & Mtc 6,975 6,975 720.00 Books & Publications 1,400 1,188 212 84 .86% 7 21.00 Memberships & Dues 205 50 155 24.:;9 0 722.00 Auto 'Mileage & Allot:. 2,-100 183 1,739 661 72.46% 723.00 Travel & Conferences 500 125 :3-r5 25.000 724.00 Tr^ining 1„7.;0 951 806 54.20 739.00 Internal. Service Chrgs 150 75 75 15 0.00% ----------- ---------- ----------- ----------- ------ Total. Services & Supplies 117,040 -183 5,599 11,441 3 2.S6°i Expenditure Report - Page 3 CLRREINT 1A TO PERCENT OF FINANCE (CONTINUED? BLDC;)'r MONTH DATE BALANCE BLT)GET-N'IT Contract Services 740.00 City Accounting Srvcs 13,750 1,513 12,090 1,660 87.93% 740.30 LAVTA Accounting Srvcs 12,000 1,531 11,760 240 98.00% ----------- ---------- ----------- ----------- ------ Total Contract Services 25,750 3,044 23,850 1,900 92.62% 750.60 Cptl Outlay-Furn/Fxtrs 950 922 28 97.05% 750.70 Cptl Outlay-Mchnry/Eqp 500 500 ----------- ---------- ----------- =---------- ------ Total Capital Outlay 1 ,450 922 528 63.59% 104 TOTAL FINAA:CE 138,970 10,441 93,296 45,674 67.130/10 105 BUILDING ^� NIAGEIENT Services & Supplies 710.00 Office Supplies 300 19 139 161 46.330/: 713.00 Operating Supplies 100 100 719.00 Rentals 1,355,280 8,537 1,021,517 333,763 75.37% 725.05 Gas & Electric 220 24 195 25 88.64% 725.10 Water & Sewer 4,300 690 2,929 1,371 68.12% 725.20 Telephone 29,500 3,568 22,103 7,397 74.93% ----------- ---------- ----------- ----------- ------ Total Services & Supplies 1,389, 100 12,838 1,046,883 3=12,817 75.33% 740.00 Contract Services 2,420 1,252 1,679 741 69.38% 750.50 Impry Othr Thn Bldgs 4,570 4,570 750.70 Cptl Outlay-Mchnry/Eqp 1,800 85 1,715 4.720. ----------- ---------- ----------- ----------- ------ Total Capital Outlay 6,370 85 6,285 1.33% 105 TOTAL BUILDING 1MAGEIEN7 1 ,398,490 14,090 1,048,641 349,843 7=1.98% 106 INSURANCE 717.01 Insurance Premiums 99,100 2,621 95,324 3, 176 96.19 717.02 Insurance Claims E.1-pns 37,500 3,000 3,100 34,400 8.27% , ----------- ---------- ----------- ----------- ------ 106 TOTAL INSLRaivCE 136,600 5,621 98,42=1 38, 176 72.05% 107 ELECTIONS 711.00 Postage 1 ,000 1,000 715.00 Advertising 50 250 716.00 Printing & Binding 750 750 740.00 Registrar of Voters 3,000 3,000 ----------- ---------- ----------- ----------- ------ 107 TOTAL ELECTIONS 5,000 5,000 108 NON-DEPARD ENNTAL 749.00 Purchase of FAU Funds 250,000 250,000 100.00 799.00 Contingent Reserve 39,546 39,546 108 TOTAL NON-DEP.aMIENTAL, 1289,546 250,000 39,546 86.34 0 TOTAL GENM, L GMIMMENT 2,442,280 61,949 1,779,619 662,661 7 2.87% Expenditure Report - Page 4 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD PUBLIC SAFETY 201 POLICE SERVICES Personal Services 701.02 Salaries, Part Time 13,000 975 9,301 3,699 71.55% 701.06 Workers Compensation 470 187 283 39.79% ----------- ---------- ----------- ----------- ------ Total Personal Services 13,470 975 9,488 3,982 70.44% Services & Supplies 710.00 Office Supplies 2,000 133 1,327 673 66.35% 711.00 Postage 1,100 29 874 226 79.45% 712.00 Copier Supplies 1,750 637 1,113 36.40% 713.00 Operating Supplies 12,250 82 1,379 10,871 11.26% 716.00 Printing & Binding 1,675 60 268 1,407 16.00% 718.00 Repairs & Mtc 2,725 310 1,518 1,207 55.71% 719.00 Rentals 1,400 97 772 628 55.14% 720.00 Bookds & Publications 350 231 119 66.00% 721.00 Memberships & Dues 200 20 90 110 45.00'/. 723.00 Travel & Conferences 2,200 66 1,696 504 77.09% 724.00 Training 1,000 54 946 5.40% 728.00 Legal Notices 600 600 100.00% 739.00 Internal Srvc Chrgs 3,869 1,935 1,934 50.01% 739.01 Intrnl Srvc Fnd-Vhcles 86,520 32,902 53,618 38.03% ----------- ------ --- ----------- ----------- ------ Total Services & Supplies 117,639 797 44,283 73,356 37.64% Contract Services 740.00 General 22,170 534 20,125 2,045 90.78% 740.01 Personnel 1,393,009 112,391 739,487 653,522 53.09% 740.02 Vehicles 25,000 1,541 10,781 14,219 43.12% 740.03 Indirect 83,009 6,917 48,421 34,588 58.33% 740.04 Dispatch 129,035 55,261 73,774 42.83% 740.05 Administration 22,137 11,068 11,069 50.00% 740.06 Services & Supplies 36,425 14,071 22,354 38.63% ----------- ---------- ----------- ----------- ------ Total Contract Services 1,710,785 121,383 899,214 811,571 52.56% 750.60 Cptl Outlay-Furn/Fxtrs 1,200 1,041 159 86.75% 750.70 Cptl Outlay-Mchnr/Eqp 6,540 5,534 1,006 84.62% ----------- ---------- ----------- ----=------ ------ Total Capital Outlay 7,740 6,575 1,165 84.95% 201 TOTAL POLICE SERVICES 1,849,634 123,155 959,560 890,074 51.88% 202 CROSSING GUARDS 740.00 Contract Services 22,200 5,791 13,853 8,347 62.40% 203 XN- IMAL CONTROL 740.60 Cntrct Srvc-Shltr Srvc r= 15,000 6,958 8,042 46.39% 740.61 Cntrct Srvc-Field Srvc 27,000 13,124 13,876 48.61% t 203 TOTAL ANITLNL CONTROL 42,000 20,082 21,918 47.81% Expenditure Report - Page 5 CURRENT -AR TO PERCENT OF BUDGET MON°1 i DATE BALANCE BL x -STD 204 'I1?r1FFIC SIGNALS & STREET LIGHTI"4G 725.05 Gas & Electric 9,500 9,500 204 TOTAL TRFC SIGNALS & ST. LGHTNG 9,500 9,500 205 DISASTER PREPAREDNZSS 714.00 Communications 650 74 430 220 66.15% 716.00 Printing 500 500 720.00 Books & Publications 100 100 721.00 Memberships & Dues 100 100 724.00 Training 1,400 1,400 ----------- ---------- ----------- ----------- ------- Total Services & Supplies 2,750 74 430 2,320 15.64% 740.00 Contract Services 15,000 151 5,538 9,462 36.92% 750.70 Cptl Outlay-Mchnry/Eqp 2,500 2,050 450 82.00% 205 TOTAL, DISASTER PREPAREDNESS 20,250 225 8,018 12,232 39.60% TOTAL PUBLIC SAFETY 1,943,584 129,171 1,001,513 9.12,071 51.53°0 TRANSPORTATION 301 PUBLIC WORKS ADMINISTRATION Personal Services 701.01 Salaries, Full Time 66,610 1,892 17,367 49,243 26.07% 701.03 Salaries, Overtime 1,000 107 355 645 35.50% 701.04 Retirement 4,060 115 1,057 3,003 26.03% 701.05 Group Insurance 7,455 47 1,545 5,910 20.72% 701.06 Worker's Compensation 1,685 74 1,611 4.39 Expenditure Report - Page 6 CURRENT -AR TO PERCENT OF BUDGET M()N`nI DATE BALANCE BU]=-)711 STREET MAINTENANCE (CONTIN) 740.21. Drainage & Maintenance 18,500 10,318 8,182 55.77% 740.22 Storm Patrol 13,200 389 4,366 8,834 33.08% 740.23 Curbs Gutters Sidemalk 22,800 172 6,321 16,479 27.72% 740.24 Sion Rpr & Instllatn 22,400 2,028 11,476 10,924 51.23% 740.25 Striping &. Marking 5,800 5,800 740.26 Guardrail Repair 1,200 243 957 20.25% 740.27 Weed Control 5,300 1,702 3,598 32.11` 740.28 Bike Path Maintenance 6,200 393 1,069 5,131 17.24% ----------- ---------- ----------- ----------- ------ 302 TOTAL STREET MAINTE'AINCE 96,400 2,982 35,495 60,905 36.82% 303 STREET SWEEPING 740.00 Contract Services 52,500 4,322 30,754 21,746 58.58% 304 STREET TREE M,=,IINTYENANCE 740.00 Contract Services 61,500 2,316 29,706 37,794 44.01% 305 STREET LLNDSCAPE MAINTENANCE 725.05 PG & E 475 72 670 (195) 141.0501 725.10 Water 13,875 90 8,555 5,320 61.66% 740.00 Contract Srvc-Pblc Wks 209,700 13,915 86,568 123,132 41.280,0 ----------- ---------- ----------- ----------- ------ 305 TOTAL, STREET LANDSCAPE `'LN-rNCE 224,050 14,077 95,793 128,257 42.76% 306 PARATPLkNSIT SERVICE 740.00 Contract Services 14,586 1,196 14,024 562 96.15% TOTAL TRA SPORTATION 61-1,354 32,719 272,762 3-11,592 4=3.40% HEALTH & WELFARE SERVICES 501 VECTOR CO,\71ROL SERVICES 740.00 Contract Services 15,500 1,855 13,645 11.970 CUL'I2JRE & LEISURE SERVICES 7 O l LIBRARY SERA"ICS 740.00 Contract Services 103,500 51,750 51,750 -0.00014. 703 PARK t IAI\TENANCE 113.00 Operating Supplies 300 300 725.05 Gas & Electric 2,200 2,200 725.10 dater & Sewer 8,600 8,600 ----------- ---------- ----------- ----------- ------ Total Services & Supplies 11, iO0 11,100 740.00 Contract Services 6,500 2,409 4,091 37.06% 703 7`07ELU, PARIS �LaINTEN_A'N:CE 17,600 2,409 15,19-i 13.69`,0 70-1 CCMMUI dn' CABLI: TV 740.00 Contract Services 21,000 10,000 21,000 100.00% SKX R1:?CRE.ATION 801 Personal Services 701.01 Salaries, Fall Time 142,650 11,730 98,144 44,506 6S.30% 701.02 Salaries, Part Time 69,735 4,278 39,960 29,775 57.30% E.%jx-:nd.iture Report - Page 7 CURRENT "AR TO PERCENT OF. BUTfGEI` r!OVM jATE BALkNCE BUD:!E'r-`I77) 701.03 Salaries, Overtime 500 24 429 71 85.80% 701.04 Retirement: 8,685 714 5,973 2,712 68.77% 701.05 Group Insurance 21,865 644 8,271 13,594 37.83% 701.06 Worker's Compensation 7,525 4,513 3,012 59.97% 701.07 State Unemplymnt Insrnc 701.08 Medicare FICA 1,785 118 941 84-1 ----------- ---------- ----------- ----------- ------ 801 Total Personal Services 252,745 17,508 158,231 94,514 62.6000 801 Services & Supplies 710.00 Office Supplies 3, 150 347 2,024 1,126 64.250110 711.00 Postage 4,150 709 3,367 783 81. 13% 712.00 Copier Supplies 2,720 759 1,961 27.90% 713.00 Operating Supplies 19,000 699 6,793 12,207 35.75% 715.00 advertising 650 424 226 65.23% 716.00 Printing & Binding 14,850 2,309 7,675 7,175 51.68% 718.00 Repairs & Mtc 1,100 182 918 16.55% 719.00 Rentals 5,875 5,227 648 88.97% 720.00 Bookds & Publications 800 31 586 214 73.25% 721.00 Memberships & Dues 450 370 80 82.22% 722.00 Auto Mileage & Allow. 3,600 456 2,728 872 75.78% 723.00 Travel & Conferences 5,700 1,713 5,221 479 91.60% 724.00 Training 400 133 267 33.250,0 725.05 Gas & Electric 14,400 781 5,888 8,512 40.89% 725.10 Water & Sewer 1,200 243 957 20.25`0 725.20 Telephone 3,150 179 11428 1,722 45.33% 739.00 Internal S.rve Fnd Chrg 7,515 3,757 3,758 49.99% ----------- ---------- ----------- ----------- ------ 801 Total Services & Supplies 88,710 1,224 46,805 41,905 52.76% 801 Capital Outlay- 750.60 Cptl Outlay-Furn/Fttrs 1,625 1,159 466 71.32% 750. x0 Cptl Outlay-Mchnry/Eqp 3,100 668 2,132 21.550 ----------- ---------- ----------- ----------- ------ 801 Total Capital Outlay 4,725 1,827 2,898 38.67% Contract Services 802 740.00 Shannon Services 16,720 1,421 9,267 7,453 55.4''0 806 740.00 Teens 2,100 140 273 1,827 13.00% 807 740.00 Special Events 1 ,600 333 1,344 256 34.000 808 740.00 Senior (.enter Services 8,500 8,500 809 740.00 Recreation Instruction 33,900 5,747 22,337 11,563 65.89'0 ----------- ---------- ----------- ----------- ------ Total Contract Services 6'Z,S20 7,641 33,221 29,599 52.88o 810 Acquatic Program 701.02 Salaries, Part Time 11,909 11,909 701.06 Worker's Compensation 1,266 1,266 701.08 Medicare FICA 175 lxo 713.00 Operating Supplies 500 500 715.00 Advertising 150 220 220 (70) 146.670 740.00 Contract Services X27,000 27,000 750.60 Cptl Out lay-Furn/Fxtrs 750.70 Cptl Outlay-Mchnry/Eqp 500 30 30 470 6.00% ----------- ---------- ----------- ----------- ------ Total Acquatic Program 41,500 250 250 41,250 0.60% 81t TOTAL RECREATION 4:50,500 32,633 240,33.1 210,166 53.35% TOTAL, CULTURE & 11EISU ZE SERV'ICES 592,600 42,62") 315,493 277,10-1 5:3.2-1`.'o Expenditure Report - Page 8 CURRENT _.'.AR TO PERCENT OF BUDGET MONIM DATE BALANCE BUDGET-YTI: CONDIUNITY DEVELOT-SENT 901 PLANINING Persona]_ Services 701.01 Salaries, Full Time 224,530 12,088 152,407 72,123 67.88% 701.02 Salaries, Part Time 4,800 878 3,922 18.29% 701.03 Salaries, Overtime 3,550 28 938 2,612 26.42% 701.04 Retirement 13,670 736 9,156 4,514 66.980% 701.05 Group Insurance 24,950 386 10,261 14,689 41.13% 701.06 Worker's Compensation 6,520 531 5,989 8.14% 701.07 State Unemplymnt Insrnc 701.08 Medicare FICA 940 73 604 336 64.26% ----------- ---------- ----------- ----------- ------ Total Personal Services 278,960 13,311 174,775 104,185 62.65% Services & Supplies 710.00 Office Supplies 4,850 377 2,093 2,757 43.15'0 711.00 Postage 4,590 148 3,592 998 78.26% 712.00 Copier Supplies 2,100 906 1,194 43.14% 716.00 Printing & Binding 2,200 1,460 2,215 (15) 100.68% 718.00 Repairs & Mtc 1,000 450 550 45.00% 720.00 Books & Publications 1,200 1,101 99 91.75% 721.00 Memberships & Dues 400 321 79 80.25% 722.00 Auto Mileage & Allow. 2,500 1,595 905 63.80% 723.00 Travel & Conferences 5,900 1,952 5,142 758 87.15% 724.00 Training 1,100 2 574 526 52.18°0 725.20 Telephone 728.00 Legal Notices 3,700 223 1,580 2,120 42.ic% 729.00 Prcfessional Services 165,000 2,160 17,483 147,517 10.60 00 739.00 Internal Srvc Fnd Chrg 7,390 3,695 3,695 50.00% ----------- ---------- ----------- ----------- ------ Total Services & Supplies 201,930 6,322 40,747 161,183 20.18% 740.00 Contract Services 38,500 10,427 33,882 4,618 88.01: 750.60 Cptl Outlay-Furn/Fxtrs 2,140 1,258 882 58.7Q% 901 TOTAL, PLANNING 521,530 30,060 250,662 270,868 48.06;0 902 BUILDING &. SAFETY Personal Services 701.01 Salaries, Full Time 21,975 2,123 19,631 8,344 70.11°0 701 .03 Salaries, Ch-ert.ime 1,470 285 914 556 62.15% 701.04 Retirement 1,700 129 1,194 506 70.24% 701.05 Group Insurance 4, 100 49 1,464 2,636 35.710 701.06 Worker's Compensation 170 86 84 50.59% ----------- ---------- ----------- ----------- ------ Total Personal Services 35,415 2,556 23,289 12,126 65.760 Services & Supplies 710.00 office Supplies 1,100 411 1,007 93 91.55% 711.00 Postage 655 448 207 68.400 712.00 Copier Supplies 350 73 277 20.86; 716.00 Printing & Binding 1,400 364 77 1 629 55.07% E:Tendi.ture Report - Page 9 CURRENT .11 Am TO PERCaTP OF BUDGET MONTH DATE BALANCE BUW-,ET-YTD 720.00 Books & Publications 2,000 215 1,785 10.75% 721.00 Memberships & Dues 500 225 275 45.00% 722.00 Auto Mileage & Allow. 50 50 724.00 Training 1,000 175 825 17.50% 739.00 Internal Srvc Fnd Chrg 2,422 1,211 1,211 50.00% ----------- ---------- ----------- ----------- ------ Total Services & Supplies 9,477 775 4,125 5,352 43.,)'% 740.00 Contract Services 285,000 21,025 195,345 89,655 68.540% 902 TOTAL BUILDING & SAFETY 329,892 24,386 222,759 107,133 67.52% 903 ENGINEERING Services & Supplies 710.00 Office Supplies 750 15 261 489 34.80% 711.00 Postage 650 627 23 96.46% 716.00 Printing & Binding 2,000 36 283 1,717 14.1.5% 720.00 Books & Publications 300 51 147 153 49.00% 724.00 Training 750 750 726.00 Small Tools 500 500 739.00 Internal Srvc Fnd Chrg 1,000 500 500 50.00°% ----------- ---------- ----------- ----------- ------ Total Services & Supplies 5,950 102 1,818 4,132 30.55% Contract Services 740.70 General Engr/Inspctn 94,700 23,939 88,789 5,911 93.76°0 740.71 General Traffic Engr 46,000 (6,991) 15,703 30,297 34.14% 740.72 Prvt Dvlpmnt-Engr/Insp 310,000 17,840 171,260 138,740 55.25 00 740.73 Prvt Dvlpmnt-Trfc Engr 10,000 990 9,010 9.90% ----------- ---------- ----------- ----------- ------ Total Contract Services 460,700 34,788 276,742 183,958 60.07% 750.60 Cptl Outlay-Furn/Fxtrs 2,700 204 2,496 7.56% 903 TOTAL ENGINEERING 469,350 34,890 278,764 190,586 59.39% TOTAL COM1`ILNITY DEVELOP`IENT 1,320,772 89,336 752,185 568,587 56.95% TOTAL GEN'ER-�L FLXD 6,929,090 355,798 4,123,427 2,805,663 59.514 TRAFFIC SAFETY FLtiD ('r- '205) 204 TRAFFIC SIGNALS & STREET LIGHTING 725.05 Utilities-Gas & Electr 26,500 2,886 19,434 7,066 73.34% 740.00 Contract Services 53,500 1,804 21,946 31,554 41.02% ----------- ---------- ----------- ----------- ------ TOTAL TRAFFIC SAFETY FUND 80,000 4,690 41,380 38,620 51 .73`0 STATE GAS TXX RIND (#r 206) 302 STREET `IAIN'PENANCE Contract Services 740.20 Street Repair 335,100 68 20,533 314,567 6.13% 740.25 Striping & `larking 37,900 1,140 30,985 6,915 81.75% ----------- ---------- ----------- ----------- ------ Total Contract Services 373,000 1,208 51,518 321,482 13.81% Expenditure Report - Page 1( CURRENT >R TO PER(;ENT OF: BUT)GET MONTH jATE BALANCE BUDGET-YTD 750.50 Imprvmts Othr Thn Bldg 50,000 50,000 302 TOTAL STREET MAINTENANCE 423,000 1,208 51,518 371,482 12.18% 903 ENGINEERING 740.71 Trffc E:ngr. Cntrct Srvc 4,000 4,000 TOTAL STATE. GAS TAX FUND 427,000 11208 51,518 375,482 12.07`. TRANSPORTATION DEVELOR^lEN°T FUND (K 211) 306 PARATRANSIT SERVICE 740.00 Contract Service 11,436 939 9,265 2,171 81.02% TOTAL TRANSPORTATION DEVLP^LN'T FUND 11 ,436 939 9,265 2,171 81.02% STREET LIGHTING ASSESSMENT DISTR FUM) ( 710) 204 TRAFFIC SIGN?4L & STREET LIGHTING 725.05 Gas & Electric 136,000 10,366 81,933 54,067 60.24% 903 ENGINrEERING 740.74 Assmt Dstr Cntrct Srvc 8,500 3,140 5,360 36.9-Ir% TOTAL STREET LGHTNG ASSMT DSTR FUND 144,500 10,366 85,073 59,427 58.871. U,N"DSCAPE ASSESSMENT DISTR FLNR (- 711) 305 STREET LANDSCAPE MAINTENANCE 2 725.05 Gas L Electric ,000 26 190 1,810 9.50% 725.10 Water & Sewer 7,000 5,693 1,307 81.33% 740.00 Contract Services 57,860 694 50,821 7,039 87.53;, ----------- ---------- ----------- ----------- ------ 305 TOTAL, STREET LANTESCaPE WrNCE 66,860 720 56,704 10,156 84.S 1°0 703 PAR1i rL-1INTLNA\CE 725.05 Gas & Electric 200 200 725.10 Water & Sewer 900 900 740.00 Contract Services 10,400 1,197 1,843 8,557 17.72% ----------- ---------- ----------- ----------- ------ 70:3 TOTAL P.AFi `L-\IN TEM'NCE 11 ,500 1,197 1,843 9,657 16.03% 903 ENGINET-ZING 740.7-1 Assmt Dstr Cntrct Srvc 2,000 1,0',23 977 51. 15% TOTAL LANDSCAPE ASSN T DISTR FUND 80,360 1,917 59,570 20,790 74.13% L..\NT)SCaPE/LIGHTING WC ASS`NT DISTR FLINT) (TRACT 5511) (=-113) (Tract 5511) (FUND x713) 903 ENGINEERING 740.74 Assmt Dstr Cntrct Srvc 2,000 2,000 TOTAL LNDSCP/LGHTNG ASMT DSTRCT FND - 2,000 ,000 DUBLIN BLVD E\TL-11 AS;i rT DIST FLIT) 0'7'15) 90:3 E..NGINEERING 740.74 Assessment Dist Engnr 1 ,500 1,500 INTERNAL SER I E FUND (7f 830) 710.00 Office Supplies 1,000 47 398 602 39.80% 713.00 Operati.nj Supplies 29,31)0 1 ,935 15,13-1 1:1,163 51.66% 717.01 Insurance 10,800 10,800 - E:-,-panditure Report - Page I ClDlDINT /EAR TO P E5%J--�NT 011 BLJ}CE7 WITTE DATE BV-\N{E 8[3JCE[-fTD I>iI7�lNAl. SERVICE FljNID <CO>TIi'IE,1)> 718.00 Repairs & Maintenance 22,9U<) 4,159 18/525 55'3T57 77.5I� 764.00 Deprctu/ Replacement 5-j,858 53,8�S ----------- ---------- ----------- ----------- ------ I0T,kL INTERNAL SERVICE, I`U\-D 118,859 8,141 34/060 34,T89 28.68`0 TOT�- OPERATING FUND =F-Q}I'R]U-,S 7/784.745 381`059 4,404,203 3,390,452 ;5O.5U% SAN R&0N BD SPECIFIC PLAN ASSMT DISTR IUD� (�TI2) 732.00 interest Payments 68,062 66,137 I,9 25 87.I7% 733.00 Frinnipal Payments 55,000 55,000 100.00% I[TiV� SAN RV,11ON BD ASS}.N7T DISTIR F\3] l23'062 121,137 1`925 93 40� DUBLIN INFOR-H\TIC#. INC. E���) (� 50I) Operating Ezpeoditurea . 7II.00 Postage 1,250 (648) 1,740 (490) 139.280//0 715.00 Printing & Binding I0/000 8,263 T.737 22,63% ----------- ---------- ----------- ----------- ------ Total Operating Escpeoditurea I1.250 (649) 4'003 7.247 35.581'0' Debt Service 732,00 Interest Payments 1,072'242 I.066,402 5,840 99.46'. 733.00 1-1riuuipal Payments 18(}/0100 I80^000 I00.0001/. ----------- ---------- ----------- ----------- ------ Total Debt Service Ezpenditures 1,232,242 I.246.402 5,840 99.53% Civic Center Operating Expenditures T25.05 Gas 6 Electric 5,0()0 5/000 728.00 Legal Advertising 139 ( I39) 729,00 Professional Services 23/000 3,451 17/484 5'5I5 75.020,0' 730.00 Filing Fees (Zone 7) 32'27G 3,197 5,782 26/484 1-1 .9-5010, 740.00 Contract Services 4II/594 38,910 381,081 30,513 92.59W 740,3I Contract Services 2.100 2,I00 748.00 Property Ta�z -�2,300 l .I�l 1'I31 41,I69 2.61� ----------- ---------- ----------- ----------- ------ Total Civic Ctr Opt-- Ex-pa 5I6.2710 48,639 405,627 110,643 78.5�� Civic Center Capital f--qpeoditures 750. 10 Land 833.C6'1 838,U54 180.0i�� 750.50 -Lmpc�-.uta 0thr Than Bld 2,922,500 332.595 J32,595 2,589,905 II .38% ----------- ---------- ----------- ----------- ------ Total Civic Ctr Capital E-,,Io J,7U0,-554 J32.595 I, I70,659 2,589,905 3I .13%' TOT.-M. IX}BLINT IN-9t:LN, b\IION' INC' ET�N-D 5.510,326 378.535 2,825,69I 2,Tl3,035 �l,()21//0 DUBLIN" INFO INC [I)NSIRUCTIONN FT�D (�-603) , ^ 71.6.00 Printing & Binding 1/839 1,839 ( 1,839) 729.00 Profesoi000l Services 1 16.547 169547 (16/54-( ) 7-1().00 Contract Services 9/527 8,527 <8/527> I03 720,00 Le--aI ProfeoI Svcs 56/38I 5G,55O1 (55.581 ) ----------- ---------- ----------- ----------- ------ l\J7AJ. DUBLIN INFO INC CCNSTD �\}D 84,49� U4`494 (84'484 ) Expenditure Report - Page 12 CURRENT YEAR TO PERMIT T CAF BUDGET M1ONTH DATE BALANCE BUDGET-YTD CAPITAL PROJECTS FUNDS (r 3XX) General Improvements 315.00 Data Processing System 80,000 24,631 55,369 30.79% 316.00 Cable TV Eqp & Facilit 55,000 45,000 10,000 81.820% 330.00 Word Processing Eqp 13,000 10,927 2,073 84.05% 350.00 Copier Equipment 5,500 4,787 713 87.04% Total General Improvements ----- ----- ---------- ----------- --------- -----o 15"j,500 85,345 68,155 55.60/ Community Improvements 319.00 Major Artrl Soundwalls 491,500 2,542 60,793 430,707 12.37% 321.00 Bus Shelters 40,000 759 39,241 1 .90% 322.00 City Entrance Signs 28,000 28,000 325.00 Sdwlk Sfty/Bus Stp Pds 147,969 440 15,803 132,166 10.68% 326.00 Arroyo Vista Soundwall 128,000 2,247 10,196 117,804 7.9790 332.00 Downtown Imprvmnt Plan 6,886 5,424 1,462 78.77% 367.00 Dhrty Rd Fncng E. Side 26,500 145 17,511 8,989 66.08% 373.00 Community TV Grant ----------- ---------- ----------- ----------- ------ Total Community Improvements 868,855 5,374 110,486 758,369 12.72% Park Improvements 335.00 Kolb Park 676,570 79,936 611,551 65,019 90.39% 346.00 Shannon Center Renovtn 195,800 195,800 363.00 Dolan Park 596,570 113,806 326,082 270,488 51.66°o 365.00 Stagecoach Park 70,568 96 68,340 2,228 96.81w/o 369.00 Sr. Citizen Center 120,300 10,074 21,=137 38,863 17.829: 370.00 Dougherty Hills Park 8,000 8,000 375.00 Alamo Creek Park 25,500 2,683 14,538 10,962 57.01% ----------- ---------- ----------- ----------- ------ Total Park Improvements 1,693,308 206,595 1,041,948 651,360 61.53% Street Improvements 329.00 annual Street Overlay 204,000 612 2,229 201,771 1.0990 336.00 San Ramon Rd Phs II 987,251 853 703,863 283,394 71.29% 337.00 San Ramon Rd Phs III 600,000 3,381 26,981 57:3,019 4.50% 342.00 Traffic. Signal Intercn 40,000 14,735 25,265 36.34% 347.00 Trfc Sl Emr•gn Pre-Empt 7,000 7,000 356.00 Rehb/Lndscp AFB 46,200 1,131 12,677 33,523 27.4490 359.00 San Ramon Rd Phs IA' 30,000 25,191 4,809 83.9190 371.00 Dbin Blv N1W Frnt-Clrk 149,000 36,567 102,474 46,526 68.7790 372.00 Trfc SI-nls Addtn 120,000 6,147 113,853 5.12% 371.00 FETSIM 8,600 10,449 ( 1 ,849) 121.50% 376.00 Dbin Blvd Plan Line Up 1,000 3,638 5,638 1,362 80.54% 377.00 Amdr Plz to Rgnl Crulct 10,000 6'27 7,575 2,125 75.75% 378.00 Dougherty Rd Bile Path 75,000 3,622 10,2=15 64,755 13.66010 379.00 Dbin B1/Vlg Pk Trn Ln 5,000 5,000 380.00 Lane 3-Dbin Blvd/RgTnl •9,000 9,000 ----------- ---------- ----------- ----------- ------ Total Street Improvements 2,h 93,057 50,431 928,20-1 1,369,8533 =10.3990 TOTAL CAPITAL PROJECTS FUNDS 5,013,720 262,400 2,165,983 2,8-17,737 -13.'20% !AYTA1, ENTPENDIIIJRES - ALL FU11DS 18,471 ,853 1,106,583 9,602,598 8,869,255 51.09;0 ----------- ---------- ----------- ----------- ------ ----------- ---------- ----------- ----------- ------ ExTenditure Report - Page 13 CURRENT YEAR TO OF BUDGET MONTH DATE BALANCE BUDGET-YTD BUDGET TRANSFERS OUT From General Fund (# 001) 893,714 955 839,019 54,695 93.88% From Cmmnty Dvlpmt Blk Grnt (#209) 34,660 34,6.60 From Federal Aid Urban Fund (#210) 193,800 193,800 From Transprtatn Dvlpmt Fnd (#211) 15,600 15,600 (15,600) From State Park Bond Act Fnd (#213) 15,202 (15,202) From Fuel Effcnt Trfc Sgnl (#220) 2,200 2,200 From San Ramon Rd Spcf Pln (#712) 167,800 167,800 From Capital Projects Fund (n3XX) 185,000 185,000 ----------- ---------- ----------- ----------- ------ TOTAL BUDGET TRANSFERS OUT 1,477,171 16,555 869,821 607,353 58.889 ----------- ---------- ----------- ----------- ------ ----------- ---------- ----------- ----------- ------