The URL can be used to link to this page

Home My WebLink AboutItem 4.03 May Finance Report CITY CLERK File # 0330-50 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (June 20, 2000) SUBJECT: Preliminary, Financial Report For the Month of May 2000 Report Prepared by: Fred Marsh, Finance Manager EXHIBITS ATTACHED: RECOMMENDATION: Pro Forma Balance Sheet and Income Statements for the Month of May 2000 ~/Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the financial statements for the month of May. Consistent with prior reports the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Analysis of May 2000 Revenue and Expenditure Report The May report represents the reporting of revenues and expenditures for the first eleven months of the fiscal year. It should be noted that there is not an even distribution of revenues and expenditures on a monthly basis. For example, expenditures for major contracts such as Police and Fire Services lag since the City is billed on a quarterly basis. A more detailed analysis of General Fund Revenue and Expenditures is shown on the attached reports and discussed below. General Fund Revenues Total General Fund Revenues collected through May are ahead of what occurred in the eleven months of the previous Fiscal Year. The City had collected through May 2000 approximately 93% of the total budgeted General Fund Revenues compared to approximately 88% in the prior Fiscal Year. Property Tax is higher than in the same period in the prior year as the City's assessed valuation was higher than what was anticipated in the budget due to residential and commercial growth occurring in Eastern Dublin, as well as a higher than expected increase in property values throughout the City. Sales Tax is higher than in the same period of the prior year. The State has raised the amount of the monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily related to autos. Transient Occupancy Taxes are higher than in the same period of the prior year due to additional revenues received from the City's three new hotels. The percentage of Franchise Fees collected is reflective of growth in the City. This report includes 100% of the Cable TV, Gas and Electric franchise taxes for the Fiscal Year, as well as Garbage franchise taxes received through the month ended April 2000. As the subscription to these services increase the total revenue also increases. Similar trends are also reflected in the issuance of building permits. Through the month of May permits issued represented improvements valued in excess of $260 million. COPIES TO: G:XMONTHFS\052000 agenda statement month finaneials.doe · ITEM NO. The data presented regarding Interest and Rental revenue is somewhat skewed in the current report as the interest earnings reported in the General Fund have not been allocated to all of the City's funds on a pro rata basis. This allocation is done on an annual basis. In addition, the City has had more cash available in the first eleven months for investment than was assumed in the budget calculations. Intergovernmental Revenue is higher than in the same period in the prior year due to an increase in the allocation of State Motor Vehicle In Lieu Fees from the State and the receipt of a one time ERAF repayment from the State of $63,700, out of a total of $150 million allocated by the State. The ERAF rebate was allocated to cities based upon each city's population. Charges for services are lower than in the same period in the prior year. This is due to a lower than expected amount of revenue for reimbursements received from developers for engineering plan checking services due to delays that have occurred on some development projects. The amount of the revenue recorded is based upon the payments made to date to outside contractors for these services. In the Other Revenue category, the amount budgeted to be received as reimbursement from PG&E for the undergrounding of utilities on Dublin Blvd from Village Parkway to Sierra Court is not expected to be received until Fiscal Year 2000-2001. General Fund Expenditures Overall, through the month of May expenditures in the General Fund totaled $15,720,661 and represented approximately 64% of the total budgeted expenditures in the General Fund. Of this amount, a total of $1,490,204 was related to Capital Improvement Projects and the remainder was related to Operating Costs reported in the General Fund. Capital Project expenditures typically do not follow an even distribution due to differences in project timing. In looking at only General Fund Operating Expenditures, activity through May 2000 was below the amounts expended for the same period in the prior Fiscal Year. Through May 2000, the City had expended 68% of the General Fund Operating Budget compared to 77% in the prior Fiscal Year. As previously noted there are some timing differences with payment for contract services, which complicate comparisons between one year to the next. General Government is lower than in the same period in the prior year due to staffing vacancies in the Finance Department. Police Services is higher than the same period in the prior year due to timing differences in payments for contract police services. Fire Services is lower than the same period in the prior year due to timing differences in payments for contract fire services. Parks and Community Services expenditures are lower than the same period in the prior year due to lower than expected expenditures to date for Park Maintenance. Community Development Expenditures are lower than in the prior Fiscal Year due to lower than expected expenditures incurred on new development for engineering professional services. Capital Improvements Projects expenditures are lower than in the same period of the prior year as the portion of the Civic Center Modification and Swim Center projects funded by the General Fund are expected to be substantially completed by the end of June. In addition, the Civic Center Roof Replacement Project and the Heritage Center Storage Building Projects, originally budgeted to be completed in Fiscal Year 1999-2000, will not be completed until Fiscal Year 2000-2001. All expenditures to date are within the authorized budget. It is recommended that the City Council receive and file these reports as authorized by Section 41004 of the California Government Code. City of Dublin 1999-2000 YTD Revenues and Budget Comparison For the Period Ending May 31, 2000 - Unaudited T°talRevenuesGeneral Fund llllll189o~% Sales Taxes ~lll~o 96% · FY 1999/2000 Transient Occupancy Taxes~l [] FY 1998/1999 Franchise Taxes ~ ~ ~ 99% i91% Licenses and ~~~ 1:[3% Permits Interest and Rentals /129% Intergovernmental ~~~ / 101% from State 89% Charges for Services ;7% !78% Other Revenues ~ ~:94O/o 0% 30% 60% 90% 120% 150% 92% of Year Complete Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Other Revenues Total General Fund Revenues FY 199912000 FY 199912000 % of FY 98199 % of Total for Budget YTD Actual Budget YTD Actual FY 98~99 5,643,600 5,709,323 101% 4,672,438 91% 9,200,000 8,872,201 96% 7,127,296 82% 580,000 585,867 101% 290,054 74% 872,400 862,597 99% 772,732 91% 3,041,520 3,444,777 113% 1,940,290 78% 1,223,214 1,583,284 129% 1,373,678 102% 1,439,880 1,449,505 101% 1,211,861 89% 4,142,844 2,355,321 57% 2,731,969 78% 1,454,641 727,104 50% 293,544 94% 27,598,099 25,589,980 93% 20,413,863 88% ATTACHMENT 1 City of Dublin 1999-2000 YTD Expenses and Budget Comparison For the Period Ending May 31, 2000 - Unaudited Total General Fund Expenses General Government Civic Center Lease Police Fire Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects I I I I ~lll___. · FY 1999/2000 [] FY 1998/1999 0% 20% 40% 60% 80% 100% 120% 92% of Year Complete General Government Civic Center Lease Police Fire Other Public Safety Transportation Health and Welfare Culture and Community Services Community Development Capital Improvement Projects Total General Fund Expenses General Fund Operating Expenses FY 199912000 FY 1999/2000 % of FY 98/99 Budget YTD Actual Budget YTD Actual 2,573,322 1,848,283 72% 1,772,749 1,614,407 4,992,384 3,720,782 75% 2,321,860 4,209,712 2,187,661 52% 3,650,430 208,427 138,025 66% 106,671 827,008 634,891 77% 520,518 19,360 7,963 41% 12,536 3,061,223 2,287,821 75% 1,756,440 5,188,683 3,405,030 66% 2,996,892 3,558,182 1,490,204 42% 1,368,185 24,638,301 15,720,661 64% 16,120,688 21,080,119 14,230,457 68% 14,752,503 % of Total for FY 98/99 83% 100% 52% 89% 56% 67% 74% 78% 83% 77% 77% 77% ATTACHMENT 2 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MAY 2000 Prepared by The Finance Department June 5, 2000 ATTACHMENT 3 GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2000 SPECIAL SPECIAL CAPITAL TRUST/ REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUND FUND TOTALS ---MEMORANDUM ONLY--- CURRENT PRIOR ASSETS CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW (20,214,107) INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS 48,703.002 149.497 205,076 DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 5,849 6.822 28.856,140 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL (723,385 DEPOSITS FOR AB1600 FEES (28,304 DEPOSITS OTHERS (545.083 PAYABLES: ACCOUNTS (164,245 INTEREST PAYROLL (208,481 DUE TO OTHERS (99,797 DEFERRED REVENUE (149,497 DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (1,918,792) FUND BALANCES (26,937.347) TOTAL FUND E (26.937,347) 2,459,247 311 667 2,460,225 (2,460.225) (2.460.225) 371,048 16.465,275 134,360 (784,177) 154.569 154,569 4,267,787 4.267,787 371,048 20,733.062 (29,025.835) (4,489) (136.576) 48,703,002 149,808 205.076 1.860,500 2,149,429 6.516 6.822 t.860,500 54,569.903 (723,385) (29.054,139) (545,083) (305,310) (208.481) (99,797) (5,849) (155,346) (1.978,000) (1,978.000) (4,489) (29,168.260) (1,978.000) (33.069,541) (366,559) 8,435.197 (171.429) (21,500,363) (366,559) 8,435.197 (171,429) (21,500,363) (8,211,129) 149,763 34,556,969 1.399.589 502,727 212,897 7,027 1,860,500 30,478,344 (498,812) (4.882,178) (468.866) (2.895,909) (309,574) (150,963) (155,346) (1.978,000) (11,339,647) (19,138,697) (19.138,697) TOTAL LIAB. FND BAL. RETD (28.856.140) (2.460.225) (371,048) (20.733.062) (2,149.429) (54,569.903) (30.478.344) INTERNAL SERVICE FUNDS ENTERPRISE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERI'OD ENDING 31May2000 FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOTALS ---MEMORANDUM--- CURRENT PRIOR /_5 ASSETS, CASH CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW 1,359.430 INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNT TO BE PROVIDED TOTAL ASSETS 19.491,955 20,851,385 LIAL/FND BAL/RETND ERNGS DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCES (20.851,385) TOTAL FUND E (20.851,385) (355) (355) 355 (6,388,993) 355 (6,388.993) 6,388,993 28.613.665 6,388,993 28.613,665 (28.613.665) (28,613.665) 1,359,076 1,023,507 25,880,948 25,880,948 28,613,665 29,519,398 55.853,689 56.423,853 (20,806) (28.613,665) (29,519,398) (28,613,665) (29,540,205) (27.240,024) (26,883.649) (27.240,024) (26,883.649) TOTAL LIAB. FND BAL. RETD (20,85t.385) 355 (6.388.993) (28,613.665) (55.853,689) (56,423.853) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 05/31/2000 GENERAL REVENUE FUND CURRENT CURRENT PRIOR. PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES SALES TAX REAL PROPERTY TRANSFER TAX HOTEL TRANSIENT OCCUPANCY TAX FRANCHISE TAXES LICENSES & PERMITS FINES & FORFEITURES USE/MONEY & PROP-INTEREST USE/MONEY & PROP-RENTALS INTERGOVERNMENTAL FROM STATE INTERGOVERNMENTAL FROM COUNTY CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 5,346 600.00 9,200 000.00 297 000.00 580 000.00 872 400.00 3,041 520.00 57200.00 1,128.154.00 95,060.00 1,437,181.15 2,699.00 4,142,844.00 1,397.440.50 27,598,098.65 5.403,433.77 (56,833.77) 4.866,093.29 4,429,935.26 436.158.03 8,872,201.27 327,798.73 8,687,090.90 7,127.296.41 1.559,794.49 305,888.83 (8,888.83) 282,732.72 242,502.54 40,230.18 585,867.42 (5,867.42) 389,662.83 290,054.16 99.609.67 862,596.84 9.803.16 849.959.28 772,732.28 77,227.00 3,444.776.96 (403.256.96) 2,472.217.26 1.940.290.30 531.926.96 65.620.28 (8,420.28) 60,875.88 53,365.28 7,510.60 1,514.463.60 (386,309.60) 1,262,400.02 1,308,397.55 (45,997.53) 68,820.58 26,239.42 90,539.48 65,280.23 25,259.25 1,449.505.02 (12,323.87) 1,356,234.32 1,211,861.36 144,372.96 2,699.00 2,355.321.30 1.787.522.70 3,482,982.60 2,731.968.74 751,013.86 661.483.98' 735,956.52 250,889.12 240,178.61 10,710.51 25.589,979.85 2.008,118.80 24,051,678.70 20.413.862.72 3,637.815.98 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 152,305.00 128.437.68 23.867.32 145,936.01 125,857.02 20.078.99 CITY MANAGER 376,735.00 314,627.83 62.107.17 331.427.26 295,699.33 35.737.93 CENTRAL SERVICES 222,712.00 168,t37.33 54,574.67 CITY ATTORNEY 370,140.00 225.292.99 144.847.01 310,557.97 247,807.72 62.750.25 ADMIN SERVICES 723,174.00 51t,986.75 211.187.25 687,654.23 571,888.03 115.766.20 BUILDING MANAGEMENT 550,831.00 364.346.11 186,484.89 531,817.85 439,322.46 92,495.39 FACILITY RENTAL 114.00 (114.00) 1.614,407.09 1,614,407.09 INSURANCE COST CENTER 152,185.00 134,413.49 17,771.51 125,621.86 85,866.28 39.755.58 ELECTIONS COST CENTER 940.00 849.00 91.00 6,335.24 6,308.27 26.97 NON-DEPARTMENTAL 24,300.00 77.83 24,222.17 377.71 377.71 ACTIVITY .TOTAL 2,573,322.00 1,848,283.01 725,038.99 3,754,145.22 3,387,156.20 366.989.02 PUBLIC SAFETY POLICE 4,992,384.00 3,720,782.28 1.271,601.72 4,505,598.49 2.321,860.48 2,183,738.01 CROSSING GUARDS 54,760.00 36,678.00 18,082.00 51,696.91 40.564.97 11.131.94 ANIMAL CONTROL 118,735.00 68,017.18 50,717.82 104,136.76 35,435.76 68.701.00 DISASTER PREPAREDNESS 34,932.00 33,330.09 1,601.91 35,021.96 30,670.01 4,351.95 FIRE SERVICES 4.209,712.00 2,t87,66t.23 2,022,050.77 4,109,003.33 3,650,429.83 458,573.50 ACTIVITY TOTAL 9.410,523.00 6,046,468.78 3,364,054.22 8.805,457.45~ 6,078,961.05 2,726,496.40 TRANSPORTATION PUBLIC WORKS 411,653.00 343,869.94 67,783.06 389,594.78 328,959.30 60.635.48 STREET MAINTENANCE 500.00 26.10 473.90 112.085.18 114.30 111.970.88 STREET SWEEPING 98,580.00 , 70,149.72 28,430.28 STREET TREE MAINTENANCE 46.220.00 27,095.69 19,224.31 49.394.83 27,688.74 21.706.09 STREET LANDSCAPING MAINTENAN 269,955.00 193,749.46 76,205.54 225.854.52 163,755.t6 62,099.36 ACTIVITY TOTAL 827,008.00 634.890.91 192,117.09 776,929.31 520,5t7.50 256.411.81 HEALTH & WELFARE THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 05/21/2000 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE WASTE MANAGEMENT CHILD CARE ACTIVITY TOTAL CULTURE & LEISURE SERVICES LIBRARY SERVICES CULTURAL ACTIVITIES HERITAGE CENTER DUBLIN CEMETERY PARK MAINTENANCE COMMUNITY TV RECREATION ADMIN PLAYGROUNDS SHANNON CENTER PRESCHOOL TEENS PROGPJ~M ADULT SPORTS YOUTH SPORTS COMMUNITY GYM SPECIAL EVENTS SENIOR CENTER RECREATION INSTRUCTION AQUATICS PARKS/FACILITIES MANAGEMENT ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING BUILDING SAFETY ENGINEERING ECONOMIC DEVELOPMENT ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENEPJNL CIP PROJECTS COMMUNITY IMPROVEMENTS PARKS STREET CONSTRC/tMPROVEMENTS ACTIVITY TOTAL TOTAL EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT FROM OTHER FUNDS 7.360.00 12,000.00 19,360.00 342,994.00 55,285.00 55,074.00 22.297.00 757.818.00 71.886.00 280.456.00 145.318.00 201.388.00 48.586.00 82.391.00 75.330.00 62.015.00 37,360.00 240,908.00 119.730.50 114.863.00 256,508.00 89,915.00 3,061,222.50 1,221,854.00 t.105.134.00 2.549.357.00 312.228.00 5,188,683.00 1.556.662.00 309.056.00 934.115.00 758.349.00 3.558.182.00 24.638,300.50 2.959,798.15 2.822.28 4,537.72 4,968.90 2.835.58 2.133.32 5.140.77 6.859.23 12.000.00 9.700.71 2.299.29 7.963.05 11,396.95 16.968.90 12.536.29 4.432.61 342.557.00 34.279.74 46.202.59 20.957.97 403.674.65 62,661.19 235 879.49 120 584.65 157 235.90 41 318.86 56 230.74 46 916.37 62 918.34 13 865.38 210 711.82 98 870.43 84 369.56 175 322.59 72 263.95 2,287,822.22 437.00 255.689.00 21.005.26 20.000.00 8.871.41 43.003.52 1.439.03 15.0t0.17 354.143.35 533.104.94 9.224.81 58.046.52 44,576.51 264.381.74 24,733.35 137,577.04 44,152.10 164,547.25 7.267.14 49,314.09 27.160.26 44.992.27 28.413.63 60,29!.18 (903.24) 63,720.01 22.494.62 30.196.18 105.169.65 20,860.07 99,728.89 20.493.44 115,191.14 81.185.41 218.801.73 16,651.05 773.401.28 2.248,580.14 182.326.75 73,362,25 20.000.00 37.371.67 5.631.85 11.433.21 3.576.96 370.170.35 162.934.59 51.908.52 6.138.00 232.160.06 32.221.68 114.279.04 23,298.00 130.439.13 24.108.12 44.090.72 5.223.37 39,299.73 5,593.54 45.745.79 14,545.39 51,123.41 12.606.60 83.642.93 21.526.72 86.087.70 13.641.19 96,718.91 18.472.23 159.541.66 59.260.07 1.756.439.58 492.140.56 1.054.094.08 167.759.92 1.0t0.015.03 830.192.75 179.822.28 863.716.45 241,417.55 795.024.53 662,511.81 132,512.72 1.187,772.79 1,361,584.21 1,685.599.49 1.389.617.01 295,982.48 299,446.60 12,891.40 115.762.34 114.670.63 1,191.71 3,405.029.92 1.783.653.08 3,606.401.39 2.996.892.20 609,509.19 843.195.87 713,466.13 252.012.63 221.470.07 30.542.56 182.358.70 126.697.30 63,272.48 12.685.45 50.587.03 391.991.35 542.123.65 1.110.303.64 889.951.50 220.352.14 72.658.32 685,690.68 353,570.03 244.078.38 109,491.65 1.490.204.24 2.067.977.76 1,779,158.78 1.368.185.40 410.973.38 !5.720,661.13 9.869.318.72 8.917.629.27 20,987.641.19 16.120.688.22 4.866.952.97 (6,909.520.57) 3,064,037.51 4.293.174.50 (1,229.136.99) 39.874.17 29.874.17 (12,219,722.58)(12.134.212.45) (85.510.13) REVENUES OVER(UNDER) EXPENDITURES 2.959,798.15 9.869,318.72 (6.909.520.57) (9,115.810.90) (7.841.037.95) (1.274.772.95) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 05/31/2000 SPECIAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES SALES TAX/OTHER TAXES FINES & FORFEITURES USES/MONEY & PROPERTY INTERGOVERNMENTAL FROM STATE INTERGOVERNMENTAL FROM COUNTY INTERGOVERNMENTAL FROM FEDERAL CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 82,965.00 72.296.16 10.668.84 76.684.53 70.116.13 183.800.00 170.958.78 12.841.22 172.561.75 156.263.74 59.000.00 79.410.15 (20,410.15) 65.857.76 53.902.36 90.160.00 24.019.31 66.140.69 93.371.12 29.979.50 2,515.457.00 563,526.48 1.951,930.52 753.103.27 581.746.87 136.650.00 98,120.00 38.530.00 149,244.00 149.244.00 402,336.00 27,554.07 374.781.93 374,449.92 18.153.08 729.650.00 676.015.01 53.634.99 706,992.33 653,002.17 30,000.00 31.609.31 (1.609.31) 22,439.87 22.439.87 4.230.018.00 1.743.509.27 2.486.508.73 2.414,704.55 1.734.847.72 6.568.40 16.298.01 1t.955.40 63.391.62 171,356.40 256,296.84 53.990.16 679.856.83 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 93.034.00 75,073.92 17,960.08 78.444.67 40.916.57 37.528.10 TRAFFIC SIGNALS & STREET LTG 128,770.00 94,578.11 34.191.89 72.476.39 56.731.71 15,744.68 FIRE SERVICES 88.142.00 40.698.75 47.444.25 81,444:13 38.986.96 42,457.17 ACTIVITY TOTAL 309.947.00 210.350.78 99.596.22 232,365.19 136.635.24 95,729.95 TRANSPORTATION: STREET MAINTENANCE 474,922.00 93,959.21 380.962.79 265.920.49 82.357.61 183.562.88 STREET SWEEPING 81,727.1t 69.081.85 12.645.26 ACTIVITY TOTAL 474.922.00 93.959.21 380.962.79 347,647.60 151.439.46 196.208114 HEALTH & WELFARE: WASTE MANAGEMENT 870.570.00 437.085.67 433,484.33 827.685.54 809,472.15 18,213.39 SENIOR SUPPORT CARE 7.044.00 5,283.00 1,761.00 ACTIVITY TOTAL 870.570.00 437.085.67 433,484.33 834.729.54 814.755.15 t9.974.39 COMMUNITY DEVELOPMENT: ENGINEERING 6.000.00 6.000.00 44,166.79 9.766.59 34.400.20 ACTIVITY TOTAL 6.000.00 6.000.00 44.166.79 9.766.59 34.400.20 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 17,665.00 17.665.00 COMMUNITY PROJECTS 189,895.00 24.107.64 165.787.36 56.548.31 13.184.31 43.364.00 PARKS 2t.119.00 12.569.66 8.549.34 51.300.97 39.853.57 11.447.40 STREET CONSTRUCTION/IMPROVEMENT 2,246,122.00 42,737.23 2,203.384.77 674.931.01 414.462.29 260.468.72 ACTIVITY TOTAL 2.474.801.00 79.414.53 2,395.386.47 782.780.29 467.500.17 315,280.12 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 4.136.240.00 826.810.19 3,309.429.81 (93,778.00) (916.699.08) 822,921.08 2.241,689.41 (173.0t5.14) (130.265.91) 62.370.78 1.580.096.61 (154.751.11) 661,592.80 (18.264.03) (130.265.91) 62,370.78 EXCESS <REVENUE> EXPENDITURE (93.778.00) (916,699.08) 822.921.08 (240.910.27) (t54.751.11) (86,159.16) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 05/31/2000 SPECIAL ASSESSMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ****~**REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 309,093.00 28t.554.49 27.538.51 253.175.40 225,494.50 27,680.90 15,027.00 3,797.92 11,229.08 16,381.44 4,691.75 11,689.69 2,500.00 668.85 1,831.15 2,736.05 2,736.05 326,620.00 286,021.26 40.598.74 272,292.89 232,922.30 29,370.59 *******EXPENDITURES***~*** PUBLIC SAFETY: TP. AFFIC SIGNALS & STREET LIG ACTIVITY TOTAL TPJ~NSPORTATION PUBLIC WORKS STREET TREE MAINTENANCE STREET LANDSCAPE MAINTENANCE ACTIVITY TOTAL HEALTH & WELFARE: ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE 145,005.00 80,266.63 64,738.37 107,525.57 67.726.36 39,799.21 t45,005.00 80,266.63 64.728.37 107,525.57 67.726.36 39,799.21 2,945.00 2,730.02 214.98 2.246.99 1.991.75 255.24 13,210.00 2,871.04 10,338.96 7,694.38 4,213.11 3,481.27 160,990.00 91,309.83 69.680.17 105,652.77 72,358.37 33,294.40 177,145.00 96.910.89 80,234.11 115.594.14 78.562.23 37.030.91 4,200.00 4,336.86 (136.86) 3,084.88 2,957.04 127.84 4,200.00 4,336.86 (t26.86) 3,084.88 2,957.04 127.84 27,972.00 27,972.00 82,600.00 46,752.16 35,847.84 110,572.00 46.752.16 63,819.84 436.922.00 228.266.54 208,655.46 226.204.59 149.246.63 76,957.96 110.302.00 (57.754.72) 168.056.72 (46.088.30) (83,675.67) 37,587.37 EXCESS <REVENUE>EXPENDITURE 110,302.00 (57.754.72) 168.056.72 (46.088.30) (83,675.67) 37,587.37 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 05/21/2000 CAPITAL IMPROVEMENT CURRENT CURRENT BUDGET ACTUAL VARIANCE FUND PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ~**REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 73,785.00 27.856,145.00 27,929.930.00 196,773.67 (122,988.67) 27,856,145.00 196,773.67 27,733,156.33 2,257.954.64 2.257,954.64 188,344.68 557,839.t0 746,183.78 (188,344.68) 1,700,115.54 1,511.770.86 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS COMMUNITY IMPROVEMENTS PARKS STREET CONSTRUCTION/IMPROVEMENT ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 61.886.00 8.514.68 53,371.32 61,886.00 8,514.68 53,371.32 16,915.01 16.915.01 145.14 145.14 15,507.06 15,507.06 145.14 145.14 1,407.95 1,407.95 2.206.938.00 1,476.155.84 730,782.16 124,753.27 105,380.44 t9.272.83 9,447.435.61 5,772.766.80 3,674,668.81 1.180,149.86 408,231.57 771,918.29 16,623,429.00 1,816.842.95 14,806,586.05 744,202.34 487,098.63 257,103.71 28.277.802.61 9,065,765.59 19,212,037.02 2,049.105.47 1,000.710.64 1.048,294.83 2,066.165.62 (191,789.02) 28.339.688.61 409.758.61 9,074,280.27 19,265,408.34 8,877,506.60 (8,467,747.99) 1,016,362.84 270,179.06 17.586.84 1,049,802.78 (461,968.08) 17.586.84 EXCESS <REVENUE>EXPENDITURE 409.758.61 8,877,506.60 (8,467.747.99) (174.202.18) 270.179.06 (444,381.24) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 05/31/2000 TRU S'T/ AG E N CY FUND CURRENT CURRENT 'PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. // VARIANCE ***~*REVENUES~ SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE 203,042.46 (203,042.46) 235,672.36 199,386.71 26,285.65 5,575.23 (5,575.23) t2,637.55 7,537.68 5,099.87 208,617.69 (208,617.69) 248,309.91 206,924.39 41,385.52 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE EXCESS <REVENUE>EXPENDITURE 261.375.75 (261,375.75) 231,864.50 231,864.50 261,375.75 (261,375.75) 231,864.50 231,864.50 261,375.75 (261,375.75) 231,864.50 231,864.50 52,758.06 (52,758.06) (16,445.41) 24,940.11 52,758.06 (52,758.06) (16,445.41) 24,940.11 (4t.385.52) (41,385.52) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THROUGH 05/31/2000 INTERNAL SERVICE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 56.822.00 14,165.24 42,666.76 40,084.94 11,928.19 28,156.75 589,275.00 517,710.38 71,564.62 726,998.50 666.911.73 60,086.77 25,700.00 42,214.73 (16,5i4.73) 17,455.06 17.455.06 671,807.00 574,090.35 97,716.65 784,538.50 696,294.98 88.243.52 ~***EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 723,983.00 211,770.88 512,212.12 794,802.16 308.835.61 485,966.55 723.983.00 217.360.88 506,622.12 794,802.16 308.835.61 485.966.55 T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 723,983.00 217,360.88 506.622.12 52,176.00 (356,729.47) 408,905.47 794.802.16 308,835.61 485.966.55 10.263.66 (387,459.37) 397.723.03 13,582.460.94 13.582.460.94 EXCESS <REVENUE>EXPENDITURE 52,176.00 (356.729.47) 408.905.47 (13,572,197.28) (387.459.37)(13,184,737.91) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/1999 THRUGH 05/31/2000 ENTERPRISE FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR PRIOR Y.T.D. VARIANCE **~**REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE 1,671,632.89 1,718,528.89 (46,896.00) 1,671,632.89 1,718,528.89 (46,896.00) ********EXPENDITURES******* GENEP4~L GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACTIVITY TOTAL PUBLIC SAFELY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 10.00 10.00 344.50 (344.50) 10.00 354.50 (344.50) 10.00 354.50 (344.50) 10.00 354.50 (344.50) 935,724.30 500.00 936,224.30 15,234,638.82 (14,298,914.52) 500.00 15,234,638.82 (14,298,414.52) 936,224.30 15,234,638.82 (14,298,414.52) (735,408.59) 13,516,109.93 (14,251,518.52) (12,134,212.45)(12,134,212.45) 13,587,133.27 13,587,133.27 EXCESS <REVENUE>EXPENDITURE 10.00 354.50 (344.50) 717.512.23 1,381,897.48 (664.385.25)