Loading...
HomeMy WebLinkAboutItem 4.05 Financial Rpt NovCITY CLERK ~~~f DU~~~ File # ^©©©"~® ~~~ ~~~ $~ AGENDA STATEMENT ~~ ~ CITY COUNCIL MEETING DATE: January 20, 2009 O~LIFOR~1~ SUBJECT: Preliminary Financial Reports for the Month of November 2008 Report Prepared by: Paul S. Rankin, Administrative Services ~-' Director and Vivian Gong, Finance Manager ATTACHMENTS: l.YTD (Year To Date) Revenues and Budget Comparison 2.YTD Expenditures and Budget Comparison 3.November 30, 2008 Financial Statements RECOMMEND N: Receive the reports as authorized by Section 41004 of the California ~• Government Code. FINA ~CIAL S ENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the month of November 2008. The report includes a Balance Sheet format identifying summary information based on the "fund type". The reports also include Budget to Actual comparison for the following Fund Types: General Revenue; Special Revenue; Special Assessment; Capital Improvement; Trust & Agency; Internal Service Funds; and Enterprise Funds. Consistent with prior reports, the focus will be on the General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. In addition to the narrative discussion below, the focus on the General Fund Revenue and Expenditures are highlighted in Attachment 1 (Year to Date Revenues and Budget Comparison) and Attachment 2 (Year to Date Expenses and Budget Comparison) to this report. Analysis of November 2008 Revenue and Expenditure Reports The November report represents the reporting of revenues and expenditures for five months of Fiscal Year 2008/2009 (July 1, 2008 through November 30, 2008). This represents the completion of 42% of the Fiscal Year. It should also be noted that there is not an even distribution of revenues and expenditures on a monthly basis. There is also a lag with the reporting of expenditures due to the significant amount of services provided to the City by outside independent contractors, including Police and Fire Services. Some services, such as Police Services and Fire Services, are billed to the City on a quarterly basis and therefore, payment for the expenditures may have not been recorded. General Fund Revenues Total General Fund Revenues collected through November 2008 represented 19% of the budgeted amount. In the first five months of the previous Fiscal Year the City collected 18% of its total General Fund revenue for the year. The revenue collected in 2008 was approximately $643,158 more than the total collected in July through November of 2007 (See Attachment 1). There were deviations in terms of dollars collected in several categories and the following Table summarizes some of the more significant deviations compared to the same reporting period in the prior year. ------------------------------------------------------------------------------------------------------------- COPIES TO: Page 1 of 5 G:1Mnnfhly Financials\FY OR-09\Nnv 200R.dnc ><TFM N(1_ ~ _~ In order to place the year to date trends in context this Table also includes the Current Year Budget, Prior Fiscal Year Total and the Difference. This can be important given that in Fiscal Year 2008/09 not all revenue categories were expected to increase. Therefore a decrease in year to date collections may be consistent with the adopted Fiscal Year 2008/2009 Budget and Financial Plan. Summary of Significant General Fund Revenue Differences For Amounts Collected July -November 2007 vs. July -November 2008 REVENUE YTD YTD DIFFERENCE November November FY 08/09 More / EXPLANATION 2008 2007 (Less) FY 07/08 Property Tax $1,247,242 $792,484 $454,758 The increase is due primarily as a result of timing differences. In the current year the County has distributed Supplemental Taxes as well as Prior Year Taxes and penalties. In 2007, the first month these payments appeared was in December. Also the amount of Unsecured Property Taxes distributed is $61,188 higher than in 2007. The County initially makes distributions based on estimates and then adjusts for actual collections throughout the year. ANNUAL ANNUAL ACTUAL BUDGET BUDGET PRIOR YR DIFFERENCE $22,920,050 $22,098,429 $ 821,621 The variance is due to: 1) Timing Sales Tax/In- $2,474,599 $2,889,711 ($415,112) differences in when the Sales Tax In-lieu Lieu Sales Tax revenue is received. Each year the State estimates the amount owed. In the prior year, a payment of $261,411 was recorded as a July 1, 2007 accrual. This year the first payment will occur in December 2008. 2) A decrease of $153,700 of current year revenues compared to the collection in the first five months of prior year. Sales Taxes are initially advanced by the State and then an adjustment is made on a quarterly basis to true-up the total taxes allocated. ANNUAL ANNUAL ACTUAL BUDGET BUDGET PRIOR YR DIFFERENCE $13,863,628 $14,225,661 ($362,033) Fewer real estate sale transactions have Real Property $124,924 $241,343 ($116,418) occurred in Fiscal Year 2008/09 compared Transfer Tax to Fiscal Year 2007/08. The 2008/09 Budget also estimated less revenue from Transfer Tax. ANNUAL ACTUAL ANNUAL BUDGET PRIOR YR DIFFERENCE BUDGET $322,000 $493,175 $171,175 Page 2 of 5 REVENUE YTD YTD DIFFERENCE November November FY 08/09 More / EXPLANATION 2008 2007 (Less) FY 07/08 Transient $242,748 $313,522 ($70,774) The collections through November 2008 Occupancy were approximately 23% less than the same Taxes period in the previous year. The decrease is due to a lower hotel occupancy rates. As previously reported to the City Council this tax revenue typically declines in economic downturns and it is unlikely that the Fiscal Year 2008/09 budgeted amount will be achieved. ANNUAL ACTUAL ANNUAL BUDGET PRIOR YR DIFFERENCE BUDGET $796,000 $789,397 6,603 The variance largely reflects a slight increase in building permits (up License and $785,904 $740,669 $45,235 approximately $37,300) and Fire Permits Permits (up approximately $18,800), which were offset by decreases in Encroachment Permits, Construction/Demolition Permits, and Business Licenses. Since the Fiscal Year 2008/09 Budget projected some larger projects obtaining permits prior to June 30, 2009, this activity is being closely monitored. ANNUAL ANNUAL ACTUAL BUDGET BUDGET PRIOR YR DIFFERENCE $2,304,675 $1,784,644 520,031 This category includes investment interest Interest and $883,431 $1,055,457 ($172,026) as well as facility rental income. Interest Rentals revenue has decreased as interest rates have declined. Among the sources of facility rental income in Fiscal Year 2007/08 was tenant rent from the Dublin Square property. In the current year only the US Bank facility remains as a tenant. As previously reported to the City Council the decrease in interest rates may require a further reduction in the annual projected budget for this revenue. ANNUAL ACTUAL ANNUAL BUDGET PRIOR YR DIFFERENCE BUDGET $2,555,078 $2,955,280 ($400,202 Page 3 of 5 REVENUE YTD YTD DIFFERENCE November November FY 08/09 More / EXPLANATION 2008 2007 (Less) FY 07/08 Intergovern- $62,057 $449,583 ($387,525) This revenue source includes one-time grant mental funds. For example, the City received $336,422 in Fiscal Year 2007/08 as a Workforce Housing grant for the Shannon Community Center reconstruction Project. The Budget for Fiscal Year 2008/09 includes a potential grant for Storm water projects of $605,700. If that grant is not finalized the City will not have the associated capital expenditures. Through November 2008 there has also been a decrease in State Vehicle License Fees. The total budget in Fiscal Year 2008/09 for ANNUAL ACTUAL Vehicle License fees is $207,000. ANNUAL BUDGET PRIOR YR DIFFERENCE BUDGET $1,015,700 $1,079,088 $63,388) The deviation in this revenue category Charges for $2,823,881 $2,171,323 $652,558 occurred primarily due to a timing Services difference. A receipt of $660,054 from the County for Santa Rita Fire Services was collected in October 2008. In the prior year the payment occurred in the third quarter of Fiscal Year 2007/08 (March 2008). Development related processing charges are included in this category which is why the overall budgeted revenue is projected to be less, based on the reduction in development activity. ANNUAL ACTUAL ANNUAL BUDGET PRIOR YR DIFFERENCE BUDGET $5,779,709 $6,482,093 ($702,384) This category of revenue typically includes Other $1,078,394 $394,369 $684,025 payments such as contributions, donations, Revenue or one-time reimbursements that may not occur consistently from year to year. In October 2008, the City received a deposit of $1 million as a Community Benefit Payment for the Wallis Ranch development, which created the year-to-date deviation. This was not part of the adopted budget. The largest factor in the adopted budget of $1.285 million is $934,932 in reimbursements associated with work on the Fallon Interchange. ANNUAL ACTUAL ANNUAL BUDGET PRIOR YR DIFFERENCE BUDGET $1,285,139 $866,992 ($418147) Page 4 of 5 General Fund Expenditures Overall, through the month of November 2008, expenditures in the General Fund totaled approximately $9.9 million and represented approximately 16% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $1,058,951 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. An examination of only the General Fund eratin Expenditures (Attachment 2) indicates that through November 2008, expenditures totaled 18% of the Budgeted General Fund expenses. In the same period of the previous year the City expended 20% of the actual total General Fund Expenditures for the year. It should be noted that the lag in billing for contract Police and Fire service payments results in minimal expenditures reported for these activities during this reporting period. The total amount of General Fund Operating expenditures in the first five months of Fiscal Year 2008/09 were $30,266 higher than the amounts expended for the same period in the prior Fiscal Year. All expenditures are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. Page 5 of 5 .: °~~~.t City of Dublin 2008-2009 YTD Revenues and Budget Comparison Total General Fund Revenues Property Taxes 19% 18% I ~ %v 4 °/v Sales Taxes x,18%° 20% Real Property Transfer Tax 49% Transient Occupancy Taxes ~;~~% ° ___ 40 /o Franchise Taxes ~ 9°~° _~1 /v Licenses and Permits 4% Interest and Rentals ~ °/ ~~°~ lntergovernmental from State . ~.~~" --142 Charges for Services ° 49% ____ 33 /o Fines and Forfeitures 37% _ 32% $4% Other Revenues 4S% ~ FY 2008/09 FY 2007/08 0% 30% 60% 90% 120% 150% 42% of Year Complete FY 2008/09 FY 2008/09 % of FY 2007/08 % of Total for Budget YTD Actual Budget YTD Actual FY 2007/08 Property Taxes 22,920,050 1,247,242 5% 792,484 4% Sales Taxes 13,863,628 2,474,599 18% 2,889,711 20% Real Property Transfer Tax 322,000 124,924 39% 241,343 49% Transient Occupancy Taxes 796,000 242,748 30% 313,522 40% Franchise Taxes 2,237,700 428,660 19% 462,152 21 Licenses and Permits 2,304,675 785,904 34% 740,669 42% Interest and Rentals 2,555,078 883,431 35% 1,055,457 36% Intergovernmental 1,015,700 62,057 6% 449,583 42% Charges for Services 5,779,709 2,823,881 49% 2,171.,323 33% Fines and Forfeitures 138,900 51,535 37% 49,605 32% Other Revenues 1,285,139 1,078,394 84% 394,369 45% Total General Fund Revenues 53,218,579 10,203,376 19% 9,560,218 18% Date Printed. ti9/009 9.59 AM ATTACHMENT1 _ "~t~__ City of Dublin 2008-2009 YTD Expenses and Budget Comparison For the Period Ending November 30, 2008 Total General Fund 16% Expenses 22% General Government 35% 38% Police ~ 4% 4% Fire 20% ~2/0 Other Public Safety ~ 16% 9% Transportation 320% 31 /o Health and Welfare ~- 25% __ 24% Culture & Community 34% Services _- 35% Community 33% Development -- __ ~ 39% Capital Improv. ~ 7%s__ _ Projects __ _ ~ 40% ^ FY 2008/09 D FY 2007/08 0% 20% 2008/2009 Budget General Government 6,365,761 Police 13,542,747 Fire 10,053,362 Other Public Safety 652,838 Transportation 2,298,841 Health and Welfare 65,425 Culture and Community Services 7,758,835 Community Development 7,077,206 Capital Improvement Projects 14,682,402 Total General Fund Expenses 62,497,417 General Fund Operating Expenses 47,815,015 40% 60% 80% 100% 120% 42% of Year Complete 2008/2009 % of FY 2007/08 % of Total for YTD Actual Budget YTD Actual FY 2007/08 2,197,810 35% 1,983,720 38% 608,348 4% 555,118 4% 186,102 2% 184,429 2% 106,820 16% 44,297 9% 725,494 32% 623,474 31 16,600 25% 12,147 24% 2,651,354 34% 2,526,389 35% 2,340,386 33% 2,873,076 39% 1,058,951 7% 2,059,217 40% 9,891,865 16% 10,861,865 22% 8,832,914 18% 8,802,648 20% o•~.P„~~.~:,,~~~959AM ATTACHMENT 2 ~~,~ CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF NOVEMBER 2008 Prepared by The Finance Department January 9, ?009 ATTACHMENT 3 GENERAL SPECIAL SPECIAL REVENUE REVENUE ASSESSMENT FUNDS FUNDS FUNDS ASSETS CASH (52,351.840) 4,811,371 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST 112,143,222 RECEIVABLES: TAXES ACCOUNTS 203.678 2,500 INTEREST 619.653 ASSESSMENTS DUE FROM OTHERS 4,966,620 INVENTORY AT COST PREPAID ITEMS 7,291 FIXED ASSETS LOANS RECEIVABLE AMOUNT TO BE PROVIDED TOTAL ASSETS 65,588.623 4.813,871 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (991,433) DEPOSITS FOR AB1600 FEES (6.872) DEPOSITS OTHERS (910,117) PAYABLES: ACCOUNTS (337,902) (9,171) INTEREST PAYROLL (4,858) DUE TO OTHERS (11,714) DEFERRED REVENUE (216,009) DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (2,478.905) (9,171) FUND BALANCES (63,109,719) (4,804.701) TOTAL FUND E (63,109.719) (4,804,701) TOTAL LIABILITIES/EQUITY (65,588,623) (4,813.871) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Nov2008 CAPITAL TRUST/ IMPROVEMENT AGENCY FUNDS FUND ~~~. TOTALS- ---MEMORANDUM ONLY--- CURRENT PRIOR 420.667 40,289.447 (6.617) (6,836,972) (6,206,604) 180,062 180,062 175,219 158.658 158.658 149,943 112,143.222 98,455,537 60,158 266.336 690.427 619,653 612.632 4,966,620 5,232.955 7,291 2.757 4,747,135 4,747.135 6,586,880 792.500 792,500 943.500 420,667 46,027,290 965,946 117,816,398 107,150,429 (11,808) (1,003,241) (912,006) (30,260) (37,132) (1.140,431) (447.060) (1,357,177) (393.023) (616,768) (963,840) (526,681) (4,858) (222,203) (1,837,021) (1,848,735) (1.965,071) (5,519,028) (5,735.037) (4,217,425) (910,000) (910,000) (1,061,000) (8,461,944) (910,000) (11,860.019) (10.437,840) (420.667) (37.565,346) (55,946)(105,956,378)( .102,017,980) (420,667) (37.565.346) (55.946)(105,956,378)( 102,017.980) (420,667) (46,027,290) (965,946)(117,816,398)(112.455.820) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Nov2008 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUND GROUP OF TERM DEBT FUNDS ACCOUNTS ACCOUNT GROUP ASSETS CASH 7,539,952 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS 102.132 INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 51,306.938 359.885,309 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 71.485.183 TOTAL ASSETS 58.949.022 359,885,309 71,485.183 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (227,288) (71.485,183) TOTAL LIABILITIES (227.288) (71,485,183) FUND BALANCES (58.721,734) (359.885.309) TOTAL FUND E (58.721,734) (359.885,309) TOTAL LIABILITIES/EQUITY (58,949.022) (359.885,309) (71.485.183) ~-~ TOTALS ---MEMORANDUM--- CURRENT PRIOR 7,539,952 6,828,255 102.132 3,966 411.192,247 399,631,407 71,485.183 61,862,464 490.319,514 468,326.091 (71.712,471) (62.091,921) (71,712.471) (62.091,921) (418.607,043)(405,866.781) (418.607,043)(405,866.781) (490.319,514)(467,958,702) THE CITY OF DUBLIN STATEMENT SHOWING +~ ~;~~ ~;; REVENUES VERSUS EXPENDITURES ~ r FOR THE PERIOD 07/01/2008 THROUGH 11/30/2008 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 22.920,050.00 1.247.241.89 21,672.808.11 22,098.429.20 792,484.31 21 305 944 89 SALES TAX 13,863.628.00 2,474,599.00 11,389,029.00 14,225,660.61 2.889,711.31 , . . 11 335 949 30 REAL PROPERTY TRANSFER TAX 322,000.00 124,924.43 197,075.57 493,175.01 241,342.76 , . . 251 832 25 HOTEL TRANSIENT OCCUPANCY TAX 796,000.00 242,748.15 553,251.85 789,397.41 313.522.41 , . 475 875 00 FRANCHISE TAXES 2,237,700.00 428,660.27 1,809.039.73 2,221,929.73 462,151.96 . . 1 759 777 77 LICENSES & PERMITS 2,304.675.00 785,904.12 1,518,770.88 1.784.643.77 740,669.27 , , . 1 043 974 50 FINES & FORFEITURES 138,900.00 51,534.77 87,365.23 156,520.17 49,604.63 , , . 106 915 54 USE/MONEY & PROP-INTEREST 2,336,137.00 774,059.01 1,562.077.99 2,620,128.17 909,885.93 . . 1.710 242 24 USE/MONEY & PROP-RENTALS 218.941.00 109,372.13 109,568.87 335.151.45 145.571.03 , . 189 580 42 INTERGOVERNMENTAL 1.015,700.00 62,057.43 953,642.57 1,079,087.97 449,582.73 , . 629 505 24 CHARGES FOR SERVICES 5,779,709.00 2,823,880.92 2.955,828.08 6,482,093.07 2,171,322.76 . . 4 310 770 31 OTHER SOURCES OF REVENUE 1.285.139.00 1,078.394.00 206.745.00 866.991.80 394,369.12 , , . 472 622 68 TOTAL REVENUE 53.218.579.00 10,203.376.12 43.015,202.88 53.153.208.36 9.560.218.22 . . 43,592,990.14 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 292,096.00 78,851.04 213,244.96 262,987.19 98,916.91 164 070 28 CITY MANAGER 1,231,303.00 470,658.26 760.644.74 1.052.588.57 450.129.94 , . 602 458 63 CENTRAL SERVICES 606,646.00 209,263.03 397,382.97 495.825.93 194,823.55 , . 301 002 38 CITY ATTORNEY 714.979.00 244,053.26 470,925.74 733,479.11 126,833.24 . . 606 645 87 ADMIN SERVICES 1,877,827.00 726,645.45 1,151.181.55 1.600.978.71 596,510.18 , . 1 004 468 53 BUILDING MANAGEMENT 897.909.00 253,399.40 644,509.60 699,948.45 253,887.85 , , . 446 060 60 INSURANCE COST CENTER 527,781.00 210,628.96 317,152.04 386,652.28 249,927.15 . . 136 725 13 ELECTIONS COST CENTER 106,120.00 1,056.40 105,063.60 1.124.24 425.00 , . 699 24 NON-DEPARTMENTAL 111,100.00 3,254.32 107,845.68 19.754.72 12,266.66 . 7.488.06 ACTIVITY TOTAL 6.365,761.00 2,197,810.12 4,167.950.88 5.253.339.20 1,983,720.48 3 269 618 72 PUBLIC SAFETY , , . POLICE 13,542,747.00 608,348.19 12,934,398.81 12,720,342.53 555,117.69 12 165 224 84 CROSSING GUARDS 100.622.00 21.625.65 78.996.35 97,662.78 21,468.78 , . . 76 194 00 ANIMAL CONTROL 400,670.00 52.646.52 348,023.48 311,991.99 . . 311 991 99 TRAFFIC SIGNALS & STREET LIGHTIN 13,845.00 4,315.28 9,529.72 12,023.37 5,089.73 , . 6 933 64 DISASTER PREPAREDNESS 137,701.00 28.232.33 109,468.67 92.050.23 17,738.19 . . 74 312 04 FIRE SERVICES 10,053.362.00 186.101.77 9,867.260.23 9,430,762.41 184,428.50 , . 9.246 333 91 ACTIVITY TOTAL 24.248,947.00 901.269.74 23,347.677.26 22.664.833.31 783,842.89 . . 21 880 990 42 TRANSPORTATION . . . PUBLIC WORKS 1,144,148.00 413,806.40 730,341.60 986,198.88 351.477.31 634 721 57 STREET MAINTENANCE 34,921.00 67.30 34.853.70 462.72 , . 462 72 STREET SWEEPING 145,605.00 34,526.92 111,078.08 134,374.05 31,438.22 . 102 935 83 STREET TREE MAINTENANCE 124,847.00 32.017.58 92,829.42 78.680.52 19,950.46 . . 58 730 06 STREET LANDSCAPING MAINTENAN 849,320.00 245.076.06 604,243.94 817.367.33 220,607.65 . . 596 759 68 ACTIVITY TOTAL 2,298,841.00 725.494.26 1,573,346.74 2,017,083.50 623,473.64 , . 1 393 609 86 HEALTH & WELFARE , , . WASTE MANAGEMENT 7.390.58 7.190.58 200.00 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 11/30/2008 a. ~ ~.; GENERAL REVENUE FUND CURRENT BUDGET CURRENT PRIOR PRIOR ACTUAL VARIANCE FISCAL YEAR Y.T.D. 4,330.75 14,169.25 18,500.00 4,956.26 12,269.33 34.655.67 25,413.00 VARIANCE CHILD CARE 18,500 .00 SOCIAL SERVICES 46,925 .00 HOUSING PROGRAMS ACTIVITY TOTAL 65.425. 00 CULTURE & LEISURE SERVICES LIBRARY SERVICES 868.401. 00 CULTURAL ACTIVITIES 238,281. 00 HERITAGE CENTER 251.713. 00 DUBLIN CEMETERY 46,750. 00 PARK MAINTENANCE 2,074,027. 00 COMMUNITY TV 78,445. 00 RECREATION ADMIN 766.613. 00 PLAYGROUNDS 389,872. 00 SHANNON CENTER 344,555. 00 PRESCHOOL 126.887. 00 TEENS PROGRAM 161,187. 00 ADULT SPORTS 187,182. 00 YOUTH SPORTS 238,806. 00 COMMUNITY GYM 47,937. 00 EMERALD GLEN ACTIVITY CENTER 13,543.74 25,413.00 16,600 .08 48,824 .92 51,303 .58 12.146 .84 39,156 .74 210,209 .38 658.191. 62 802,695 .43 205,022 .98 597,672 .45 114,969 .87 123.311. 13 217.296 .55 104.674 .51 112,622 .04 95,335 .82 156.377. 18 234,222 .38 91,365 .49 142,856. 89 8,159 .03 38,590. 97 36,692 .31 5.473 .80 31.218. 51 580,004. 46 1,494,022. 54 1,943,588 .26 599,388 .23 1.344,200. 03 36,606. 45 41,838. 55 117,348 .36 30,748 .00 86,600. 36 287.201. 85 479,411. 15 724,768. 91 286,256 .84 438.512. 07 122.894. 46 266,977. 54 292,470. 16 112,584 .28 179,885. 88 112,691. 79 231,863. 21 276,775. 62 125,560 .61 151,215. 01 57,515. 31 69,371. 69 108,501. 41 42,457 .13 66,044. 28 55,171. 12 106,015. 88 124.796. 04 45.424 .92 79,371. 12 67.378. 78 119,803. 22 160,687. 23 45,758. 07 114.929. 16 110,121. 45 128,684. 55 222,307. 17 82,014. 13 140,293. 04 8,329. 12 39,607. 88 43,936. 22 12,937. 84 30,998. 38 SPECIAL EVENTS 440,889 .00 171.629 .13 269,259 .87 403.148 .41 160,085 .84 243,062 .57 SENIOR CENTER 604,477 .00 204,236 .90 400.240 .10 541,942 .56 186,914 .04 355,028 .52 RECREATION INSTRUCTION 193,304 .00 81,085 .86 112.218 .14 183,565 .98 73.002 .49 110.563 .49 AQUATICS 478.246 .00 214,282 .81 263,963 .19 458.574 .88 188,916 .11 269,658 .77 PARKS/FACILITIES MANAGEMENT 221,263 .00 113,530 .62 107,732 .38 311,975 .20 127.803 .22 184.171 .98 ACTIVITY TOTAL 7,758.835 .00 2.651.354 .21 5,107,480 .79 7,205,293 .08 2,526,388 .53 4.678,904 .55 COMMUNITY DEVELOPMENT PLANNING 2,747,757 .00 900,664 .22 1,847.092 .78 2,479,866 .71 904.732. 19 1.575.134 .52 BUILDING SAFETY 2,241,503 .00 657,059 .81 1.584.443 .19 2,515,366 .57 1,050,441. 23 1.464,925 .34 ENGINEERING 1.796,437. 00 683,120 .16 1.113.316 .84 2,054,482 .25 825.138. 57 1,229.343 .68 ECONOMIC DEVELOPMENT 291,509. 00 99,541 .49 191,967. 51 255,829 .71 92,764. 10 163,065 .61 ACTIVITY TOTAL 7,077.206. 00 2,340.385 .68 4,736,820. 32 7.305,545 .24 2,873,076. 09 4,432,469 .15 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 5.594,057. 00 24.119. 91 5,569,937. 09 384,619 .81 39,875. 71 344,744. 10 COMMUNITY IMPROVEMENTS 328,570. 00 2.534. 54 326,035. 46 218.057 .69 83,626. 15 134.431. 54 PARKS 7,080.791. 00 545,638. 31 6,535,152. 69 4,249,293. 53 1.895,870. 66 2,353,422. 87 STREET CONSTRC/IMPROVEMENTS 1,678,984. 00 486,658. 69 1.192,325. 31 271,116. 67 39.844. 13 231,272. 54 ACTIVITY TOTAL 14.682,402. 00 1.058,951. 45 13.623.450. 55 5,123,087. 70 2.059.216. 65 3.063,871. 05 TOTAL EXPENDITURES 62,497.417. 00 9,891,865. 54 52,605.551. 46 49,620,485. 61 10,861,865. 12 38,758,620. 49 EXCESS REVENUE (EXPENDITURES) (9.278,838. 00) 311.510. 58 (9,590,348. 58) 3.532,722. 75 (1,301.646. 90) 4,834,369. 65 TRANSFERS IN FROM OTHER FUNDS 70,927. 77 70,927. 77 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (9,278.838. 00) 311.510. 58 (9.590,348. 58) 3,603,650. 52 (1,301,646. 90) 4,905,297. 42 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 11/30/2008 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ********REVENUES******** PROPERTY TAXES 134,025 .00 SALES TAX/OTHER TAXES 439,234 .00 FINES & FORFEITURES 197,000 .00 USES/MONEY & PROPERTY 134,360 .00 INTERGOVERNMENTAL FROM STATE 1,509.854 .00 INTERGOVERNMENTAL FROM COUNTY 366,575 .00 INTERGOVERNMENTAL FROM FEDERAL 1.450,900 .00 CHARGES FOR SERVICES 1.615,400 .00 OTHER SOURCES OF REVENUE 6,500 .00 TOTAL REVENUE 5,853.848 .00 *******EXPENDITURES******* PUBLIC SAFETY: POLICE 111,940 .00 TRAFFIC SIGNALS & STREET LTG 306,670 .00 DISASTER PREPAREDNESS FIRE SERVICES 374,014. 00 ACTIVITY TOTAL 792,624. 00 TRANSPORTATION: STREET MAINTENANCE 387,651. 00 STREET LANDSCAPE MAINTENANCE ACTIVITY TOTAL. 387,651. 00 HEALTH & WELFARE: WASTE MANAGEMENT 1.796.701. 00 SOCIAL SERVICES 59,708. 00 HOUSING PROGRAMS ACTIVITY TOTAL 1.856,409. 00 COMMUNITY DEVELOPMENT: ENGINEERING 6,000. 00 ACTIVITY TOTAL 6,000. 00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS PARKS 229.591. 00 STREET CONSTRUCTION/IMPROVEMENT 3,381.533. 00 ACTIVITY TOTAL 3,611,124. 00 T O T A L EXPENDITURES 6.653,808.00 EXCESS REVENUE (EXPENDITURES) (799.960.00) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (799,960.00) 1,342.73 132.682.27 130,609.95 79,000.49 360,233.51 458,429.22 64,666.61 132,333.39 203.975.65 59,120.87 75,239.13 196,387.20 421,464.61 1,088,389.39 1,639,303.16 41.643.83 324,931.17 359,383.45 10,719.82 1,440,180.18 353,538.54 15,662.42 1,599,737.58 1,497,236.92 1,044.76 5,455.24 34,499.24 694,666.14 5.159.181.86 4,873,363.33 1.031.46 110.908.54 102,652.11 38,360.40 268.309.60 259,283.22 1.285.12 372,728.88 287,483.00 40,676.98 751,947.02 649,418.33 40.301.07 347.349.93 271,408.11 6,407.67 40,301.07 347,349.93 277,815.78 22,292.16 1.774,408.84 1,602.667.69 23,580.41 36,127.59 52,944.65 45.872.57 1,810,536.43 1,655.612.34 6,000.00 6,000.00 6,000.00 6.000.00 10,926.00 118,821.04 110,769.96 61,729.05 112.320.14 3,269.212.86 1,998,211.85 231,141.18 3,379.982.82 2,070,866.90 357,991.80 6,295.816.20 4,659,713.35 336,674.34 (1,136,634.34) 213.649.98 77,527.77 336.674.34 (1.136.634.34) 136,122.21 ~~.~~ ~ PRIOR Y.T.D. VARIANCE 286.76 130,323.19 76,756.41 381,672.81 64,156.43 139,819.22 70,904.69 125,482.51 393,902.71 1,245,400.45 40.430.75 318,952.70 3,728.76 349,809.78 4,327.42 1,492,909.50 34,499.24 654,493.93 4.218,869.40 1,355.00 101,297.11 95.768.05 163.515.17 1,541.65 285,941.35 98.664.70 550,753.53 49,095.98 222,312.13 6,407.67 49,095.98 228.719.80 22,325.12 1,580,342.57 15.416.40 37,528.25 37,741.52 1,617,870.82 2,472.00 3.528.00 2.472.00 3.528.00 10,926.00 61.729.05 647,820.35 1.350.391.50 647.820.35 1,423.046.55 835,794.55 3.823.918.80 (181,300.62) 394,950.60 77,527.77 (181,300.62) 317.422.83 ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG ACTIVITY TOTAL TRANSPORTATION PUBLIC WORKS STREET TREE MAINTENANCE STREET LANDSCAPE MAINTENANCE ACTIVITY TOTAL COMMUNITY DEVELOPMENT ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT ACTIVITY TOTAL T O T A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) REVENUES OVER (UNDER) EXPENDITURES THE CITY OF DUBLIN STATEMENT SHOWING '~,~ " " ~'" '° ,~;~' REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 11/30/2008 S PE CIAL ASS ESSMENT FUN DS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL Y EAR Y.T.D . VARIANCE 831,987. 00 815,381.08 16,605.92 797,519 .80 16.405. 94 781,113 .86 22,931. 00 33,352.57 (10,421.57) 26.739 .60 7,420. 42 19,319 .18 5,000. 00 578.00 4,422.00 578 .00 578. 00 859,918. 00 849,311.65 10.606.35 824,837 .40 24.404. 36 800.433. 04 362,960 .00 404,424 .57 (41,464. 57) 315.699 .72 126,238. 65 189,461 .07 362,960 .00 404.424 .57 (41,464. 57) 315.699 .72 126.238. 65 189,461 .07 40,430. 00 77,700 .19 (37,270. 19) 72,355. 91 5,307. 88 67,048 .03 410,969. 00 462,696. 60 (51,727. 60) 352,276. 33 98.467. 35 253,808 .98 451,399. 00 540,396. 79 (88.997. 79) 424,632. 24 103,775. 23 320.857. 01 16,135. 00 21,701. 79 (5,566. 79) 16,032. 94 7,282. 94 8,750. 00 16.135. 00 21,701. 79 (5.566. 79) 16,032. 94 7,282. 94 8.750. 00 830.494. 00 966,523 .15 (136,029. 15) 29,424. 00 (117,211 .50) 146,635. 50 29,424. 00 (117,211 .50) 146,635. 50 756.364 .90 237.296 .82 519,068. 08 68.472 .50 (212.892 .46) 281,364. 96 68,472. 50 (212,892. 46) 281.364. 96 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 11/30/2008 CAPITAL IMPROVEMENT FUNDS ********REVENUE******** USES OF MONEY & PROPERTY INVESTMENT INTEREST LOAN REPAYMENT-PRINCIPAL LOAN REPAYMENT-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL CITY ATTORNEY ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS ACTIVITY TOTAL CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR ~~~,°' PRIOR Y.T.D. VARIANCE 1,427,074.00 553,011.68 874,062.32 1,749,574.46 593.149.30 1,156,425.16 750.000.00 (750,000.00) 1,500.000.00 1,500.000.00 90,000.00 90.000.00 11.037,971.00 124.276.47 10.913,694.53 18,353,827.13 1.270,479.90 17.083,347.23 12,465.045.00 1.427,288.15 11,037,756.85 21,693,401.59 1.863.629.20 19,829.772.39 180,373.31 189.900 .00 25,359 .30 164,540 .70 156,534 .86 189,900. 00 25,359. 30 164.540 .70 336,908 .17 3.942,094. 00 493.372. 60 3,448.721. 40 1,007,526. 67 3.942.094. 00 493,372. 60 3,448,721. 40 1,007,526. 67 180.373.31 24,170.46 132,364.40 24,170.46 312,737.71 493,932.16 513,594.51 493.932.16 513,594.51 ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 150,896 .00 3,600. 00 147,296 .00 29,278 .01 29 278 01 COMMUNITY IMPROVEMENTS 250,000 .00 5,285. 60 244,714 .40 . . PARKS 7,811.302 .00 2,512.442. 08 5,298,859 .92 4,509.205. 57 587 126.74 3 922 078 83 STREET CONSTRUCTION/IMPROVEMENT 20.148,343. 00 3,449.906. 07 16,698.436. 93 8,762,562. . 03 4.273,334.34 , , . 4 489 227 69 ACTIVITY TOTAL 28,360,541. 00 5.971.233. 75 22.389.307. 25 13,407,852. 01 4.860,461.08 , , . 8,547.390. 93 T 0 T A L EXPENDITURES 32,497,535.00 6,489.965.65 26.007.569.35 14,645.480.45 5.378.563.70 9.266,916.75 EXCESS REVENUE (EXPENDITURES) (20,032.490.00) (5.062,677.50)(14,969.812.50) 7.047,921.14 (3,514.934.50) 10,562,855.64 TRANSFER IN FROM OTHER FUNDS 6.600.00 6,600.00 TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES(20,032.490.00) (5,062,677.50)(14.969,812.50) 7,054.521.14 (3,514,934.50) 10,569,455.64 ********REVENUES******** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T O T A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) REVENUES OVER (UNDER) EXPENDITURES THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 11/30/2008 TRUST/AGENCY FUND CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR 202,985.34 (567,540.62) 567,540.62 (201,809.72) (340,252.79) 340,252.79 517,841.22 203.931.18 (203,931.18) 236,480.04 306,062.92 (306,062.92) 446,924.16 306,062. 92 (306.062 .92) 446,924. 16 (646,315. 71) 646,315. 71 70.917. 06 (646,315. 71) 646.315. 71 70.917. 06 ~~~~ PRIOR Y.T.D. VARIANCE 1,340.50 201,644.84 128,553.07 (330,362.79) 129,893.57 387,947.65 41,965.85 41,965.85 41,965.$5 87,927.72 87,927.72 194.514.19 404,958.31 404.958.31 (17,010.66) (17,010.66) THE CITY OF DUBLIN STATEMENT SHOWING ~ E .. REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 11/30/2008 INTERNAL SERVICE FUNDS 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 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 260,403.00 93,202.73 1.125,184.00 827,979.92 36,000.00 114,532.47 1,421,587.00 1,035,715.12 3,839,554.00 3,839.554.00 T O T A L EXPENDITURES 3.839,554.00 EXCESS REVENUE (EXPENDITURES) (2,417,967.00; TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 167,200.27 286.586.87 297,204.08 1.968,529.47 (78,532.47} 5,259,344.46 385,871.88 7,514,460.80 663.368.33 3,176,185.67 3,249,414.38 663,368.33 3.176,185.67 3,249,414.38 663,368.33 3.176,185.67 3.249,414.38 372,346.79 (2,790.313.79) 4,265.046.42 108,148.05 178,438.82 602,419.70 1,366.109.77 250.00 5.259,094.46 710,817.75 6,803.643.05 214,866.95 3.034,547.43 214,866.95 3,034,547.43 214,866.95 3.034.547.43 495,950.80 3,769,095.62 REVENUES OVER (UNDER) EXPENDITURES (2,417,967.00) 372,346.79 (2,790,313.79) 4,265,046.42 495.950.80 3,769.095.62 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2008 THROUGH 11/30/2008 ENTERPRISE CURRENT CURRENT BUDGET ACTUAL ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 20.00 FINANCE ACTIVITY TOTAL 20.00 PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: FUND PRIOR PRIOR VARIANCE FISCAL YEAR Y.T.D. VARIANCE 20.00 20.00 T O T A L EXPENDITURES 20.00 EXCESS REVENUE (EXPENDITURES) (20.00) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 20.00 (20.00) REVENUES OVER (UNDER) EXPENDITURES (20.00) (20.00)