The URL can be used to link to this page

Home My WebLink AboutItem 4.04 PrelimFinRpt&Final (2) .. CITY CLERK FILE # D~[j[Q]-~[Q] AGENDA STATEMENT CITY COUNCIL MEETING DATE: (August 22,1995) . SUBJECT: Preliminary Financial Report For the Month of June 1995 and Final Budget Adjustments For Fiscal Year 1994/95 It\ n / ( Report Prepared by: Paul S. Rankin, Assistant City Manager / W...... Administrative Services Director) EXHIBITS ATTACHED: I 1. Pro Forma Balance Sheet and Income Statements for the Period Ending June 30, 1995 /2. Budget Change Form Identifying Year End Budget Adjustments Necessary to Complete Annual Financial Report. RE~OMMENDATIO%~ 1. Accept and file the report. 2. Authorize the Mayor to execute the Budget Change Forms and direct Staff to make the appropriate adjustments to the City's Financial Records. FINANCIAL STATEMENT: See Report. The adjustments required can be covered by reducing the amount appropriated to Reserves as well as transfers of unexpended appropriations. · DESCRIPTION: This item provides the monthly financial statement for the month of June 1995, which represents the final month of the Fiscal Year. Staffhas also completed a review of those budget accounts which require an adjustment prior to the preparation of the annual financial report. FINANCIAL STATEMENTS The Financial Statements are considered preliminary due to the fact that additional financial entries are required before the books for Fiscal Year 1994/95 are fully closed. The report does reflect various billings and receipts processed subsequent to June 30, 1995, but recorded appropriately in the 1994/95 Fiscal Year. The report will highlight significant trends, which differ from information presented in earlier reports. The final results for the year appear to be largely consistent with the projections included in the Fiscal Year 1995/96 Preliminary Budget and Financial Plan. Given the fact that the General Fund comprises the greatest portion of the City's operations, the analysis in the Staff Report will focus on activities within this fund. General Fund Revenues Overall, General Fund Revenues are approximately 8.22% greater than General Fund Revenues collected in the previous Fiscal Year. As noted in previous reports increased interest earnings as well as improved sales taxes have contributed to the City Financial base. The property tax category has shown very little growth. Licenses and Permits, which is primarily Building Permits fiiiished the year at slightly less than .the amount collected in Fiscal Year 1993/94. ------------------------------------------------------------------- COPIES TO: A II ITEM NO.~ H1cc-forms/as-J.doc This report also includes adjustments made to "Interest Revenue" category to allocate pooled interest earnings between the funds. Included in the City's pooled investment portfolio are various securities which pay interest twice each year. As required by accounting rules, Staffhas recorded the appropriate share of these iriterest payments in Fiscal Year 1994/95 as Interest Receivable. General Fund Expenditures Total Fiscal Year 1994/95 General Fund Expenditures are projected to be approximately 95.7% of the amount budgeted. This figure will fluctuate as Staff makes the final accounting entries. For example, it is projected that there may be a final adjustment to the expense reflected for the Dougherty Regional Fire Authority, since payments to date were based upon budget estimates. Typically, the Authority issues a final reconcilement in early September. The following sections describe specific deviations by Program Area. . General Government: (95.0% of Budgeted Expenditures) This reflects favorable results from Insurance claims expense; reduced charges by Alameda County for General Election Services; salary savings from a vacant position for a portion of the year in Administrative Services; and a requirement to budget the Gross Civic Center Lease Payment even though a portion of the payment is paid for by interest income from reserve investments held by the Trustee. Public Safety: (94.0% of Budgeted Expenditures) As previously noted this amount may change once fmal costs related to DRF A are posted. The City also experienced a vacancy in the Community Safety Assistant position for a portion of the year. Animal Control Field Service costs reflect the hours of service received, which were less than the budget accommodated. Crossing Guard hours were less than originally anticipated. Recreation: (94.8% of Budgeted Expenditures For All Recreation Administration and Program . Activities) Expenditures were impacted by the need to cancel some Adult Sports programs due to weather. Staffing for these programs is typically part-time and expenses are reduced when programs are canceled. Community Development: (106.9% of Budgeted Expenditures) The Planning activity exceeded the original budget due to increased development applications which resulted in higher than anticipated costs for Contract Professional Services. These costs are billed to the applicant. The Engineering Budget was impacted by a delay in construction on major CIP projects. This resulted in more Staff time being absorbed by the General Fund instead of being expensed to projects. Capital Projects: (87.6% of Budgeted Expenditures) It is not uncommon to experience a deviation with Capital Projects since they may span more than one fiscal year. The exact timing of payments and progress towards completion varies. The selection and procurement of a Police Evidence Tracking software package was delayed as well as contributions towards the multi- agency aerial mapping project. In addition final work under the Heritage Center Renovation Contract has extended into Fiscal Year 1995/96. YEAR END BUDGET ADJUSTMENTS Staffhas reviewed the Preliminary Financial Reports and is requesting year end adjustments at this time. This will allow the Staff to deliver a clean set of records to the Auditors when they begin their final work at the end of the month. Current City policies only allow the City Manager to make budget adjustments . between line items which are within the same activity (Le. Department). The City Council must approve all other adjustments to appropriations. . .Proposed Adjustments Many of the adjustments discussed in this section of the report were anticipated in the information presented in the Preliminary 1995/96 Fiscal Year Budget and Financial Plan. For example, the increased Mngineering Staff time funded by the General Fund was fully anticipated. This was due to the delay in the .onstruction schedule of Capital Projects which would have absorbed certain Staff costs with special revenue funds associated with the specific project financing. GENERAL FUND ADmSTMENTS GENERAL FUND (001) Leial Services (1 030): $13.337 Attributable to greater than anticipated expenses associated with the implementation of East em Dublin Specific Plan. Public Works Administration (3010): $ 2.850 Overruns were attributable primarily to contract supervision and postage accounts. The Preliminary 1995/96 Budget also projected a Budget overrun. Street Landscape Maintenance (3050): $ 961 This was due to higher than anticipated water utility charges.. The Preliminary 1995/96 Budget also projected a Budget overrun. . Dublin Cemete:r:y (8013): $ 175 The small overrun is attributable to contract services associated with maintenance and burial excavations. Park Maintenance (8020) $4.427 In order to prevent unauthorized entry to the Swim Center the doors were replaced. In addition, the Maintenance Staff renovated softball fields at the Sports Grounds in order to accommodate League play and eliminate potential hazards. Plannin~ (9010): $37.056 Overruns were primarily attributable to the Contract Professional Services category. This was caused by the Schaeffer Heights General Plan Study and the Homart Project. Consultant services are billed to the applicant as a cost of processing the application. The Preliminary 1995/96 Budget also projected a Budget overrun. Eniineerini (9030): $57.452 As previously indicated this was due to limited Staff time being charged to Capital projects due to a delay in the construction schedules. This was offset by a savings from a vacant Staff position. Engineering did utilize a contract position which inflated expenses for General Engineering. In addition, contract expenses associated with private development applications were higher than the budget. . Sidewalk Repair Project (9425): $726 The final Staff costs for inspection salary and benefits have been allocated to this project and an adjustment is necessary. The total additional appropriations in the General Fund for all activities is $104,984. GAS TAX FUND QOli) Street Maintenance (3020): $11.630 Two categories contributing to the total overrun are Storm Patrol ($8,687) and . Weed Control ($3,537), both would have been affected by the unusual winter rains. The Preliminary 1995/96 Budget also projected a Budget overrun. CIP Project 9655 (Dougherty Rd Sierra Siinal): $ 288 The City Council approved a Budget Change on August 8, 1995 at the time of acceptance of this project. The budget change reduced the Gas Tax Appropriation by more than the final expenses allocated to this fund. The total additional appropriations in the Gas Tax Fund are $11,918. DII FUND (601) Recreation Admin (8040): $857 1bis account was impacted by an unanticipated postage increase for the non-profit category and increased paper costs associated with printing the brochure. Funds for a transfer are available in 601-1041-716-000 (Administrative Services: Printing- 011 Fund) since a City Newsletter was not produced. The Budget Change Form provides for a Transfer from the unexpended Administrative Services Account. SAN RAMON RD (712) CIP Protect 9646 (Signal Equipment Up wade ): $1.102 This project involved upgrading signal electronic components at various existing . intersections in the City. The work was performed by Alameda County Public Works, which maintain the signals under an agreement with the City. The original budget would be funded entirely by Gas Tax monies. Staffhave allocated the cost of the signal at Amador Valley Boulevard and San Ramon Road to the San Ramon Road Specific Plan Maintenance Fund. An additional appropriation from Reserves in this Fund would be appropriate. . DOUGHERTY RD (713) Landscape Maintenance (3050): $7.061 Water utility costs associated with this District exceeded the Budget. An additional appropriation from reserves is appropriate. Attached are Budget Change forms which will allow for amendments to the budget consistent with this . report. Staff recommends that the City Council receive and file this report and authorize the Mayor to execute the Budget Changes. . . CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JUNE 1995 (Pre.Audit) ~- . Prepared by The Finance Department August 14, 1995 . GL102 CITY OF DUBLIN PAGE 1 8/14/95 BALANCE SHEET 13.48.23 FOR THE PERIOD 7/94 THROUGH 6/95 GENERAL SPECIAL SPECIAL CAPITAL TRUSTI TOTALS. REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONLY-- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1 ASSETS CASH 1714627.98- 597162.64 425061.39 133187.62- 156894.88 668696.69- 444667.88- CASH WITH FISCAL AGENT 122903.69 122903.69 121210.04 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 21993120.38 21993120.38 19015041.49 RECEIVABLES:TAXES 39966.33 39966.33 37974.26 ACCOUNTS (NET) 423174.51 96185.18 110795.71 630155.40 654458.17 INTEREST 352694.69 352694.69 306633.19 ASSESSMENTS 5142.01 1746.62 908.69 7797.32 9121.44 RENTS NOTES DUE FROM OTHERS 118159.84 118159.84 653605.71 INVENTORY AT COST PREPAID ITEMS 4716.20 4716.20 11980.68 FIXED ASSETS AMOUNTS TO BE PROVIDED 2158500.00 2158500.00 2232500.00 TOTAL ASSETS 21099044.13 816649.67 426808.01 22391.91- 2439207.26 24759317.16 22597857.10 LIAB, FND BAL, RETND EARNINGS ",10 DEPOSITS FOR PRIVATE DEVELPMNT 66223.55 66223.55 36873.. OEPOSITS FOR AB1600 FEES 296276.00- 296276.00- 216850. .","0 DEPOSITS OTHERS 358885.62- 110795.71- 469681.33- 528722.95- PAYABLES:ACCOUNTS 1046455.41- 85476.98- 41315.39- 29195.48- 1202443.26- 597298.10- INTEREST PAYROLL 55066.78- 55066.78- 63762.54- DUE TO OTHERS 235.00- 235.00' 387824.01- DEBT INSTRUMENTS PAYABLE 2276000.00- 2276000.00- 2350000.00- TOTAL LIABILTIES 1394419.26- 85476.98- 41315.39- 436267.19- 2276000.00. 4233478.82- 4181331.36- FUND BALANCES 19704624.87- 731172.69- 385492.62- 458659.10 163207.26- 20525838.34' 18416525.74- TOTAL FUND EQUITY 19704624.87- 731172.69- 385492.62- 458659.10 163207.26- 20525838.34' 18416525.74- TOTAL LIAB,FND BAL, RETD EARNS 21099044.13- 816649.67- 426808.01- 22391.91 2439207.26- 24759317 .16- 22597857.10- . .L1 02 8/14/95 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/94 THROUGH 6/95 . INTERNAL SERVICE FUND ASSETS :ASH :ASH WITH FISCAL AGENT lNAMORTIZED BOND DISCOUNT 307190.16 :NVESTMENTS AT COST ~ECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES IUE FROM OTHERS NVENTORY AT COST 'REPAID ITEMS 'IXED ASSETS .MOUNTS TO BE PROVIDED 572B.28 78673.27 TOTAL ASSETS 391591.71 .lAB, FND BAL, RETND EARNINGS EP _OR PRIVATE DEVELPMNT EPI... THERS AYABl :ACCOUNTS INTEREST PAYROLL UE TO OTHERS EBT INSTRUMENTS PAYABLE TOTAL LIABILITIES UNO BALANCE ONTRI BUTlONS NVESTMENTS IN FIXED ASSETS ETAINED EARNINGS TOTAL FUND EQUITY 15712.34- 15712.34- 283010.81- 177338.56- 375879.37- 391591.71- 22388501.89- 5048842.39- OTAL LIAB,FND BAL, RETD EARNS . ENTERPRISE FUNDS FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP 1744947.62 46354.57 20597199.70 22388501.89 153.75- 17339505.75- 17339659.50- 61047.61 5109890.00- 479805.26 479805.26 479805.26- 479805.26- 2855403.88 2855403.88 2855403.88- 2855403.88- 479805.26- 2855403.88- PAGE 1 13.49.01 TOT A L S --- MEMORANDUM ONLY --- CURRENT JUNE 30, 1994 307190.16 1744947.62 46354.57 5728.28 21155678.23 2855403.88 26115302.74 15866.09- 20194909.63- 20210775.72- 221963.20- 5287228.56- 479805.26- 5904527.02- 349263.09 1732248.07 46954.43 2878.60 21743799.35 2713930.44 26589073.98 15226.45- 20707573.69- 20722800.14- 99240.02- 5287228.56- 479805.26- 26115302.74- 26589073.98- 5866273.84- GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 8/14/95 REVENUES VERSUS EXPENDITURE 13.04.18 FOR THE PER IOD 7/94 THROUGH 6/95 GENERAL REVENUE FUND PREVIOUS YEAR ENDING JUNE 30, 1~ CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* PROPERTY TAXES 3849500.00- 3892863.51- 101. 1 43363.51 3853101.60- 3853101.60- 100.0 .00 SALES TAX 5892000.00- 6470287.39- 109.8 578287.39 5969342.43- 5969342.43- 100.0 .00 REAL PROPERTY TRANSFERS 68500.00- 58070.83- 84.8 10429.17- 65258.80- 65258.80- 100.0 .00 TRANSIENT OCCUPANCY TAX 90000.00- 112580.00- 125.1 22580.00 88318.00- 88318.00- 100.0 .00 FRANCHISE TAXES 479800.00- 481155.78- 100.3 1355.78 481162.79- 481162.79- 100.0 .00 LICENSES & PERMITS 361350.00- 337550.69- 93.4 23799.31- 340994.82- 340994.82- 100.0 .00 FINES & FORFEITURES 37500.00- 35668.12- 95.1 1831.88- 34316.48- 34316.48- 100.0 .00 USES OF MONEY AND PROPERTY 986100.00- 1134343.55- 115.0 148243.55 935615.38- 935615.38- 100.0 .00 INTERGOVERNMENTAL FROM STATE 970325.00- 1044001.82- 107.6 73676.82 945713.40- 945713 .40- 100.0 .00 CHARGES FOR SERVICES 758180.00- 1057402.95- 139.5 299222.95 580737.55 - 580737.55 - 100.0 .00 OTHER SOURCES OF REVENUE 121157.00- 161587.88- 133.4 40430.88 275567.69- 275567.69- 100.0 .00 TOTAL REVENUE 13614412.00- 14785512.52- 108.6 1171100.52 13570128.94- 13570128.94- 100.0 .00 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES; NON-DEPARTMENTAL 5756.00 .00 5756.00 815.04 815.04 100.0 .00 CITY COUNCIL 1010 120014.00 106613.42 88.8 13400.58 102612.23 102612.23 100.0 .00 CITY MANAGER 1020 260109.00 255861.89 98.4 4247.11 240219.95 240219.95 100.0 .00 CITY ATTORNEY 1030 174670.00 188007.10 107.6 13337.10- 235554.62 235554.62 100.0 .00 ADMIN SERVICES 1040 469941. 00 445264.08 94.7 24676.92 410536.74 410536.74 100.0 :. .BUILDING MANAGEMENT 1050 326490.00 317163.30 97.1 9326.70 313411.43 313411.43 100.0 ~ FACILITY RENTAL 1050-719 1553744.00 1461448.88 94.1 92295.12 1458593.27 1458593.27 100.0 INSURANCE COST CENTER 1060 134000.00 124851.39 93.2 9148.61 149792.07 149792.07 100.0 .00 ELECTIONS COST CENTER 1070 12475.00 6078.72 48.7 6396.28 10817.83 10817.83 100.0 .00 ACTI VITY TOTAL 3057199.00 2905288.78 95.0 151910.22 2922353.18 2922353.18 100.0 .00 PUBLI C SAFETY; POLI CE 2010 3280472.00 3117873.83 95.0 162598.17 2970615.78 2970615.78 100.0 .00 CROSSING GUARDS COST 2020 48340.00 36333.77 75.2 12006.23 .00 .00 .00 ANIMAL CONTROL 2030 103750.00 70885.70 68.3 32864.30 92215.39 92215.39 100.0 .00 DISASTER PREAPREDNESS 2050 31817.00 14798.56 46.5 17018.44 25728.27 25728.27 100.0 .00 FIRE SERVICES JPA 2060 2797315.00 2646144.00 94.6 151171. 00 2632168.71 2632168.71 100.0 .00 ACTIVITY TOTAL 6261694.00 5886035.86 94.0 375658.14 5720728.15 5720728.15 100.0 .00 TRANSPORTATION; PUBLIC WORKS 3010 294390.00 297240.13 101.0 2850.13- 282508.50 282508.50 100.0 .00 STREET MAINTENANCE 3020 33959.00 31902.53 93.9 2056.47 877 .22 877.22 100.0 .00 STREET TREE MAINTENANCE 3040 50040.00 41872.72 83.7 8167.28 45767.70 45767.70 100.0 .00 STREET LANDSCAPE MAINT. 3050 167960.00 168920.81 100.6 960.81- 158297.22 158297.22 100.0 .00 ACTIVITY TOTAL 546349.00 539936.19 98.8 6412.81 487450.64 487450.64 100.0 .00 HEALTH & WELFARE: WASTE. MANAGEMENT 5020 27100.00 17411.78 64.3 9688.22 75.84 75.84 100.0 .00 ACTIVITY TOTAL 27100.00 17411.78 64.3 9688.22 75.84 75.84 100.0 .00 CULTURE & LEISURE SERVICES; LIBRARY SERVICES 8010 177536.00 177536.00 100.0 .00 165000.00 165000.00 100.0 .00 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 8000.00 8000.00 100.0 .00 HERITAGE CENTER 8012 26563.00 6737.62 25.4 19825.38 2234.23 2234.23 100.0 .00 DUBLIN CEMETERY 8013 16680.00 16854.77 . 101.0 174. n- 8068.33 8068.33 100.0 .00 PARK MAINTENANCE 8020 579619.00 584045.96 100.8 4426.96- 562328.40 562328.40 100.0 .00 . GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2 8/14/95 REVENUES VERSUS EXPENDITURE 13.04.18 FOR THE PERIOD 7/94 THROUGH 6/95 GENERAL REVENUE FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D COMMUNITY CABLE TV 8030 23893.00 22n9.27 95.3 1113.73 20279.00 20279.00 100.0 .00 RECREATION ADMIN. 8040 1m79.00 178485.58 100.6 1106.58- 175746.19 175746.19 100.0 .00 PLAYGROUNDS 8045 93149.00 95612.89 102.6 2463.89- 72270.89 72270.89 100.0 .00 SHANNON CENTER 8050 113540.00 107202.90 94.4 6337.10 116563.54 116563.54 100.0 .00 PRESCHOOL 8055 38972.00 37414.34 96.0 1557.66 34319.22 34319.22 100.0 .00 TEENS PROGRAM 8060 29446.00 27525.50 93.5 1920.50 27928.80 27928.80 100.0 .00 ADULT SPORTS 8065 92961. 00 66278.32 71.3 26682.68 76349.88 76349.88 100.0 .00 YOUTH SPORTS 8066 34886.00 31761.14 91.0 3124.86 28570.n 28570.n 100.0 .00 SPECIAL EVENTS 8070 31928.00 30612.01 95.9 1315.99 28749.94 28749.94 100.0 .00 SENIOR CENTER 8080 109422.00 108674.38 99.3 747.62 98858.25 98858.25 100.0 .00 RECREATION INSTRUCTION 8090 81736.00 75381.16 92.2 6354.84 78626.11 78626.11 100.0 .00 AQUA TI CS 8100 197008.00 189089.80 96.0 7918.20 205324.75 205324.75 100.0 .00 ACTIVITY TOTAL 1834718.00 1765991.64 96.3 68726.36 1709218.30 1709218.30 100.0 .00 COMMUNITY DEVELOPMENT: PLANNING 9010 611170.00 648225.61 106.1 37055.61- 511179.82 511179.82 100.0 .00 BU I LD I NG SAFETY 9020 266000.00 261521.53 98.3 4478.47 252992.23 252992.23 100.0 .00 ENGINEERING 9030 219072.00 276524.24 126.2 57452.24- 215790.71 215790.71 100.0 .00 ECONOMIC DEVELOPMENT 9040 73132.00 63493.94 86.8 9638.06 6328.57 6328.57 100.0 .00 ACTIVITY TOTAL 1169374.00 1249765.32 106.9 80391.32- 986291.33 986291.33 100.0 .00 :APITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 93NN 65320.00 49443.40 75.7 15876.60 .00 .00 .00 COMMUNITY IMPROVEMENTS 94NN 99457.00 89836.41 90.3 9620.59 48603.17 48603.17 100.0 .00 .F 95NN 7940.00 7939.49 100.0 .51 12423.92 12423.92 100.0 .00 ~ !> .CONSTRCIIMPROVMT 96NN 32500.00 32500.00 100.0 .00 281695.66 281695.66 100.0 .00 ACTIVITY TOTAL 205217.00 179719.30 87.6 25497.70 342722.75 342722.75 100.0 .00 rOT A L EXPENOITURES 13101651.00 12544148.87 95.7 557502.13 12168840.19 12168840.19 100.0 .00 ,XCESS [REVENUE>EXPENDITURES 512761.00- 2241363.65- 437.1 1728602.65 1401288.75- 1401288.75- 100.0 .00 rRANSFERS IN FROM OTHER FUNDS .00 46410.04- 46410.04 n093.25- n093.25- 100.0 .00 rRANSFERS OUT TO OTHER FUNDS .00 294854.69 294854.69- 41883.81 41883.81 100.0 .00 ,XCESS [REVENUE> EXPENDITURE 512761.00- 1992919.00- 388.7 1480158.00 1436498.19- 1436498.19. 100.0 .00 . GL104c THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 8/14/95 REVENUES VERSUS EXPENDITURE 13.12.48 FOR THE PERIOD 7/94 THROUGH 6/95 SPECIAL REVENUE FUNDS PREVIOUS YEAR ENDING JUNE 30, 1~ CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ........REVENUES....... SALES TAX 116000.00- 120823.92- 104.2 4823.92 117622.52- 117622.52- 100.0 .00 FINES & FORFEITURES 31900.00- 24556.82- 77.0 7343.18- 33963.62- 33963.62- 100.0 .00 SPECIAL BENEFITS ASSESSMENTS .00 45.00- 45.00 .00 .00 .00 USES OF MONEY AND PROPERTY 35800.00- 49056.30- 137.0 13256.30 35095.85- 35095.85- 100.0 .00 INTERNGOVERNMENTAL FROM STATE 611854.00- 656834.32- 107.4 44980.32 609800.83- 609800.83- 100.0 .00 INTERGOVERNMENTAL FROM COUNTY 150000.00- 151127.00- 100.8 1127.00 125984.50- 125984.50- 100.0 .00 INTERGOVERNMENTAL FROM FEDERAL 2329428.00- 367667.91- 15.8 1961760.09- 116540.21- 116540.21- 100.0 .00 CHARGES FOR SERVICES 697356.00- 735905.78- 105.5 38549.78 742458.70- 742458.70- 100.0 .00 OTHER SOURCES OF REVENUE 16000.00- 286592.73- 1791.2 270592.73 11993.19- 11993.19- 100.0 .00 TOTAL REVENUE 3988338.00- 2392609.78- 60.0 1595728.22- 1793459.42- 1793459.42- 100.0 .00 .......EXPENOITURES....... GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: POLI CE 12230.00 9360.94 76.5 2869.06 12067.48 12067.48 100.0 .00 TRAFFIC SIGNALS 90790.00 80108.52 88.2 10681.48 82277.35 82277.35 100.0 .00 ACTIVITY TOTAL 103020.00 89469.46 86.8 13550.54 94344.83 94344.83 100.0 .00 TRANSPORTATION: PUBLIC WORKS 526.00 .00 526.00 .00 .00 .00 . STREET MAINTENANCE 205893.00 214599.03 104.2 8706.03- 158820.98 158820.98 100.0 . - .STREET SWEEPING 73360.00 70518.94 96.1 2841.06 69985.83 69985.83 100.0 ACTIVITY TOTAL 279779.00 285117.97 101.9 5338.97- 228806.81 228806.81 100.0 HEALTH & WELFARE: WASTE MANAGEMENT 685704.00 679404.95 99.1 6299.05 542622.00 542622.00 100.0 .00 CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 113450.00 101497.21 89.5 11952.79 117649.45 117649.45 100.0 .00 ACTIVITY TOTAL 113450.00 101497.21 89.5 11952.79 117649.45 117649.45 100.0 .00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 17269.00 17266.00 100.0 3.00 .00 .00 .00 COMMUNITY IMPROVEMENTS 205207.00 181692.50 88.5 23514.50 58968.45 58968.45 100.0 .00 PARKS 33045.00 2280.00 6.9 30765.00 133793.53 133793.53 100.0 .00 STREET CONSTRUCTION/IMPROVMT 2544954.00 541486.63 21.3 2003467.37 364376.28 364376.28 100.0 .00 ACTIVITY TOTAL 2800475.00 742725.13 26.5 2057749.87 557138.26 557138.26 100.0 .00 TOT A L EXPENDITURES 3982428.00 1898214.72 47.7 2084213.28 1540561.35 1540561.35 100.0 .00 EXCESS [REVENUE>EXPENDITURE 5910.00- 494395.06- 8365.4 488485.06 252898.07- 252898.07- 100.0 .00 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 32728.18- 32728.18- 100.0 .00 TRANSFERS OUT TO OTHER FUNDS .00 3600.00 3600.00- 9451.83 9451.83 100.0 .00 EXCESS [REVENUE> EXPENDITURE 5910.00- 490795.06- 8304.5 484885.06 276174.42- 276174.42- 100.0 .00 . GL104C THE CITY OF DUBLIN STATEMENT SHOYING PAGE 1 8/14/95 REVENUES VERSUS EXPENDITURE 13.20.36 FOR THE PERIOD 7/94 THROUGH 6/95 . SPECIAL ASSESSMENT FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D .*******REVENUES******* SPECIAL BENEFITS ASSESSMENTS 288265.00- 360782.45- 125.2 72517.45 533098.91- 533098.91- 100.0 .00 JSES OF MONEY AND PROPERTY 15000.00- 21115.14- 140.8 6115.14 22974.46- 22974.46- 100.0 .00 JTHER SOURCES OF REVENUE 5725.00- 3944.45- 68.9 1780.55- 14269.21- 14269.21- 100.0 .00 TOTAL REVENUE 308990.00- 385842.04- 124.9 76852.04 570342.58- 570342.58- 100.0 .00 ~******EXPENDITURES******* ;ENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL .00 .00 .00 210730.75 210730.75 100.0 .00 ACTIVITY TOTAL .00 .00 .00 210730.75 210730.75 100.0 .00 'UBllC SAFETY: TRFC SIGS/STREET LIGHTING 199025.00 192530.11 96.7 6494.89 190210.84 190210.84 100.0 .00 ACTIVITY TOTAL 199025.00 192530.11 96.7 6494.89 190210.84 190210.84 100.0 .00 rRANSPORTATlON: PUBll C YORKS 5632.00 3507.43 62,3 2124.57 2736.26 2736.26 100.0 .00 STREET TREE MAINTENANCE 9890.00 5350.84 54.1 4539.16 6807.10 6807.10 100.0 .00 STREET LANDSCAPE MAINTENANCE 109940.00 110650.86 100.6 710.86- 105133.50 105133.50 100.0 .00 ACTIVITY TOTAL 125462.00 119509.13 95.3 5952.87 114676.86 114676.86 100.0 .00 lEALTH & YELFARE: ;ULTURE & LEISURE SERVICES: ;OMMUNITY DEVELOPMENT: ,r ~RING 4120.00 3216.97 78.1 903.03 3828.40 3828.40 100.0 .00 ~ ACTIVITY TOTAL 4120.00 3216.97 78.1 903.03 3828.40 3828.40 100.0 .00 :APITA IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS .00 .00 .00 4500.00 4500.00 100.0 .00 STREET CONSTRUCTION/IMPROVMT 400000.00 5470.89 1.4 394529.11 .00 .00 .00 ACTIVITY TOTAL 400000.00 5470.89 1.4 394529.11 4500.00 4500,00 100.0 .00 i 0 TAL EXPENDITURES 728607.00 320727.10 44.0 407879.90 523946.85 523946.85 100.0 .00 ;XCESS[REVENUE>EXPENDITURE 419617.00 65114.94- 15.5- 484731.94 46395.73- 46395.73- 100.0 .00 'RANSFERS IN FROM OTHER FUNDS .00 .00 .00 123895.44- 123895.44- 100.0 .00 'RANSFERS OUT TO OTHER FUNDS .00 42810.04 42810.04- 110995.44 110995.44 100.0 .00 ,XCESS [REVENUE> eXPENDITURE 419617.00 22304.90- 5.3- 441921.90 59295.73- 59295.73- 100.0 .00 . GL104C THE CITY OF DUBLIN STATEMENT SHOYING PAGE 1 8/14/95 REVENUES VERSUS EXPENOITURE 13.43.52 FOR THE PERIOD 7/94 THROUGH 6/95 CAPITAL IMPROVEMENT FUNO PREVIOUS YEAR ENDING JUNE 30, 1~ CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-O ********REVENUES******* USES OF MONEY AND PROPERTY .00 6647.92- 6647.92 2058.46- 2058.46- 100.0 .00 OTHER SOURCES OF REVENUE 711509.00- .00 711509.00- 73214.23- 73214.23- 100.0 .00 TOTAL REVENUE 711509.00- 6647.92- .9 704861.08- 75272.69- 75272.69- 100.0 .00 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 10500.00 7119.43 67.8 3380.57 .00 .00 .00 STREET CONSTRUCTION/IMPROVMT 464931.00 306865.88 66.0 158065.12 214021.33 214021.33 100.0 .00 ACTIVITY TOTAL 475431.00 313985.31 66.0 161445.69 214021.33 214021.33 100.0 .00 TOT A L EXPENDITURES 475431.00 313985.31 66.0 161445.69 214021.33 214021.33 100.0 .00 EXCESS [REVENUE>EXPENDITURE 236078.00- 307337.39 130.2- 543415.39- 138748.64 138748.64 100.0 .00 TRANSFERS IN FROM OTHER FUNDS .00 276446.78- 276446.78 .00 .00 .00 .TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 83393.92 83393.92 100.0 .. 222142.56 EXCESS [REVENUE> EXPENDITURE 236078.00- 30890.61 13.1- 266968.61- 222142.56 100.0 .00 . GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 8/14/95 REVENUES VERSUS EXPENDITURE 14.22.02 FOR THE PERIOD 7/94 THROUGH 6/95 TRUST/AGENCY FUNO . CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-O ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS .00 222337.10- 222337. 10 .00 .00 .00 USES OF MONEY AND PROPERTY .00 7111.65- 7111.65 .00 .00 .00 TOTAL REVENUE .00 229448.75- 229448.75 .00 .00 .00 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL .00 242864.50 242864.50- .00 .00 .00 ACTIVITY TOTAL .00 242864.50 242864.50- .00 .00 .00 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOTAL EXPENDITURES .00 242864.50 242864.50- .00 .00 .00 EXCESS(REVENUE)EXPENDITURE .00 13415.75 13415.75- .00 .00 .00 EXCESS (REVENUE) EXPENDITURE .00 13415.75 13415.75- .00 .00 .00 -. . " GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 8/14/95 REVENUES VERSUS EXPENDITURE 13.24.38 FOR THE PERIOD 7194 THROUGH 6/95 INTERNAL SERVICE FUND PREVIOUS YEAR ENDING JUNE 30, 1~ CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY 11600.00- 18553.23- 159.9 6953.23 15381.72- 15381. 72- 100.0 .00 CHARGES FOR SERVICES 124608.00- 128050.00- 102.8 3442.00 128214.28- 128214.28- 100.0 .00 OTHER SOURCES OF REVENUE 1090.00- 2128.54- 195.3 1038.54 7615.50- 7615.50. 100.0 .00 TOTAL REVENUE 137298.00- 148731. 77- 108.3 11433.77 151211.50- 151211.50- 100.0 .00 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 180367.00 178701.68 99.1 1665.32 127280.78 127280.78 100.0 .00 ACTIVITY TOTAL 180367.00 178701.68 99.1 1665.32 127280.78 127280.78 100.0 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 84470.00 84470.00 100.0 .00 .00 .00 .00 ACTIVITY TOTAL 84470.00 84470.00 100.0 .00 .00 .00 .00 TOT A L EXPENDITURES 264837.00 263171.68 99.4 1665.32 127280.78 127280.78 100.0 .00 EXCESS [REVENUE>EXPENDITURE 127539.00 114439.91 89.7 13099.09 23930.72- 23930.72- 100.0 .00 fXCESS [REVENUE> EXPENDITURE 127539.00 114439.91 89.7 13099.09 23930.72- 23930.72- 100.0 .. . :;L 104C' THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 8/14/95 REVENUES VERSUS EXPENDITURE 13.39.02 FOR THE PERIOD 7/94 THROUGH 6/95 ENTERPRISE FUNDS . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1994 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D '*******REVENUES******* JSES OF MONEY AND PROPERTY 1658112.00- 1565843.45- 94.4 92268.55- 1564715.31- 1564715.31- 100.0 .00 TOTAL REVENUE 1658112.00- 1565843.45- 94.4 92268.55- 1564715.31- 1564715.31- 100.0 .00 '******EXPENDITURES******* jENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1553784.00 1412754.98 90.9 141029.02 1436774.32 1436n4.32 100.0 .00 ADMIN SERVICES 13870.00 7346.35 53.0 6523.65 1635.85 1635.85 100.0 .00 ACTIVITY TOTAL 1567654.00 1420101.33 90.6 147552.67 1438410.17 1438410.17 100.0 .00 'UBLIC SAFETY: DISASTER PREAPREDNESS 1150.00 .00 1150.00 .00 .00 .00 ACTIVITY TOTAL 1150.00 .00 1150.00 .00 .00 .00 'RANSPORTATlON: lEAL TH & WELFARE: :ULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 10180.00 11036.94 108.4 856.94- 10864.05 10864.05 100.0 .00 SENIOR CENTER 463.00 420.00 90.7 43.00 338.14 338.14 100.0 .00 ACTIVITY TOTAL 10643.00 11456.94 107.6 813.94- 11202.19 11202.19 100.0 .00 :OMMUNITY DEVELOPMENT: :APITAL IMPROVEMENT PROJECTS: . 0 T 4 L EXPENDITURES 1579447.00 1431558.27 90.6 147888.73 1449612.36 1449612.36 100.0 .00 XC~VENUE>EXPENDITURES 78665.00- 134285.18- 170.7 55620.18 115102.95- 115102.95- 100.0 .00 'RA IN FROM OTHER FUNDS .00 18407.91- 18407.91 12008.13- 12008.13- 100.0 .00 XCESS [REVENUE> EXPENDITURE 78665.00- 152693.09- 194.1 74028.09 127111.08- 127111.08- 100.0 .00 . III "- .;. C' CITY OF DUBLIN BUDGET CHANGE FORM CHANGE FORM # . New Appropriations (City Council Approval Required): yyyy From Unappropriated Reserves Budget Transfers: From Budgeted Contingent Reserve (l080-799.000) Within Same Department Activity Between Departments (City Council Approval Required) Other =w..._...._........&'_z::..l<i~'n:I:::r:~l'..?ilim"::i!:'...~J:::r:..........'.0~xm.'<*:;1,?:lann!lk'}l2Ii:*w..,.'.....'*'~-t!lk'}'~i;1ti:tlt:~f:~:'Rniii.m::;:~:WA~~:&f.r..............w....,w.....W..::itiKft'i:*~1~""W..::W WA#D.EGS~~~::D.u.y.G~~~kG""'uit.n4tfti$>$~mit..:M~:!!:iti$:~~f$ltfu:WA~w.Mao:4.QhM9:~I:L~oo~~:>~:tgl'Wm1ffiiWul.(iQt!'I':I::::l'M1{::1i From New Revenues . . ......:.............. ..'-"'-'" . ..... ...-x-...-:-..... ...-....;......: ...........0:.....;.-_.,.-...;.........:..........:.:... ..:-:-..... ......:;-:::........... ........:. .:;...- :- '+;::::+:. .. .:.... ...._.....-._...............:.................. ..... ........:..:..................:.........o:.......:..-~..."....;........ ..:-....;.:.. .. ....:..... x............_..._......--_-....:..._.....:...:.....;.;.......;....;.>> Name: Name: GENERAL FUND - LEGAL PROFESSIONAL SERVICES Account #: Account#: 001-1030-729-000 $ 13,337 Name: Name:PUBLIC WORKS ADMIN CC ~0~o~~~-88I:~818:5!b:8~~ U;~H Account #: Account #: GENERAL FUND Name: Name: ~Ts~~RSCAPE MAINTENANCE- fJATER Account #: Account #: 001-3050-725-010 $ 961 Name: Name:DUBL IN CEMETERY CONTRACT SVC-GENERAL FUND Account #: Account #: 001-8013-740-000 $ 175 Name: Name: GEN FUND PK MAl NT , IMPVTS NOT BLDGS ccount #: Account #: 001-8020-750-050 $4.427 Name: Name:GEN FUND- PLANNING PROFESSIONAL SERVICES Account #: Account #: 001- 9 010- 729-000 $ 37,056 REASON FOR BUDGET CHANGE ENTRY: YEAR END ENTRIES AS DESCRIBED IN STAFF REPORT PRESENTED TO CITY COUNCIL 8/22/95. '8 Ol\.L .-C. Two City Manager: Date: Signature .Mayor: Date: Signature Posted By: Date: fimn.lbudll"lu,g Signature CITY OF DUBLIN BUDGET CI-IANGE FORM . . " CHANGE FORM ff New ApPI'oJu'iations (City Council Approval Rcquired): Budget Transfers: . xxxxxx From Unappropriated Reserves (EXCEPT DIl) From Budgeted Contingent Reserve (1080-799.000) Within Same Department Activity From New Revenues nTT Between Departments (City Council Approval Required) Other ......ww.N~..........:m:a::...........,....:....'fi:m."'.....~;l;..,........,N.,'l'.......~~WW.."^"""'.,.....;r..;;.~'.j(~......N~,"'>>.....~;W..'itl"..W~%~<w,'Wt.:f....~~~.'<?l':nw.~"'~:li;.'iffil%?.w''''^'''':::l:::M' ~:i:li\:f~m....,.::::" l%lMQll>GR~~S;l%.ulJ,n~:lSI:ll~~emii:v.lNT:::t:#tl:~pM::m~:tiI:k-:i!rnW@til1b1Ik1(:aJ.m:a'OJli~D~R.~~:l::~1ti**u,ilil:~(,0(?'mJ.%q{d .': :v.:.0:~:tl':#i1tM ..........................-..-.............................................:.;... .............-:-.....;.............-.-......;.:......;.........;.-+;......:..-:......:-:.:....:-;.;...:.:-:... .:-:-x.:.;...-...................-:..._..._;.,.;.....:....x.........;.;.. ......: ...........'.....:......................_............. ;.;......... ........................_.,... ................-.-.......... .............-.......... ..............._-...-.-............ .....-................. Name: Name: GENERAL FUND ENGINEERING CONTRACT GEN ENG 001-9030-740-070 $24,389 Account #: CONTRACT ~SP. fRIV DEV ccount : 001-9030-740-072 $33,063 Namc: NameGEN FUND SIDEWALK REPAIR PROJECT - RETIREMENT Account #: A~ou~#p01-9425-701-004 $726 Namc: Namc: GAS TAX FUND 8T MAINT STORM PATROL 206-3020-740-022 $ 8,867 WEED CONTROL 206-3020-740-027 $ 2.763 Account #: Account #: Name: Name: GAS TAX DOUGHERTY/SIERRA E IGNAL IMPVTS NOT BLDGS Account #: Account #: 206-9655-750--050 $ 288 Name: DII- ADMIN SERVICES I Name: DII RECREATION PRINTING & BINDING POSTAGE 601-8040-711-000 $ 163 601-1041-716-000 $857 PRINTING 601-8040-716-000 $ 694 Account #: Account #: Name: 8~r~g RAMON RD FUND-SIGNAL SVC 712-9646-740-000 $ 362 EQUIPMENT 712-9646-750-070 $ 740 Account #: Account #: REASON FOR BUDGET CHANGE ENTRY: YEAR END BUDGET ADJUSTMENTS AS DESCRIBED COUNCIL 8/22/95 k%~~TCfrt~T~!NT. DOUGHERTY RD WATER & SEWER 713-3050-725-010 $ CONTRCT SVC 713-3050-740-000 $ IN THE STAFF REPORT PRESENTED TO TH ~ l..) 0 o.p. T~o City Manager: Date: Signature Mayor: Date: . Signature Posted By: Date: lor"'Jlbllt/~hlltr Signature