The URL can be used to link to this page

Home My WebLink AboutItem 8.1 Mid-Yr Budget Rpt CITY CLERK File # D[3][2]~-~~ AGENDA STATEMENT CITY COUNCIL MEETING DATE: MARCH 4, 2008 SUBJECT: Fiscal Year 2007-2008 Mid-Year Budget Report and December 2007 Monthly Report of Financial Activities Report Prepared by: Paul S. Rankin, Administrative Se;:ric!s Director and Vivian Gong, Finance Manager trt:rc... ATTACHMENTS: 1. 2. 3. 4. RECOMMENDATION: ,~: 2. YTD (Year to Date) Revenues and Budget Comparison YTD Expenditures and Budget Comparison December 31, 2007 Financial Statements TV30 Supplemental Funding Request Budget Change Forms Receive the reports. Approve the Budget Changes FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the financial statements for the month of December 2007 with a more detailed "Mid-Year Budget Review". It should 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. Prior year trends have been used to compare with current revenues and expenditures to assess tracking with the adopted Fiscal Year 2007-2008 Budget. Each Department will be developing more precise year end estimates as the Fiscal Year 2008-2009 Budget is prepared. The focus of the Mid Year review will be adjustments to the General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Also, adjustments are recommended to the projection of Development Impact Fees, based on fewer permits being issued. Revenue Estimates Update - General Fund Overall the total General Fund Revenues are projected to be less than the amount budgeted. Comparing the percentage of collection to what was reported through the same period of the previous Fiscal Year, the City has collected approximately 41 % or 2% less than, the percentage collected for the same period in the prevIOus year. Overall, revenues in the General Fund are expected to be over $2 million less than estimated in the 2007- 2008 Budget. This represents approximately 3.4% of the budgeted revenues. As will be discussed later in this report, some of the negative variance will be offset by reductions in expenditures. The 2007/2008 Budget was adopted with a projection that there would be a contribution to reserves. (i.e. General Fund ------------------------------------------------------------------------------------------------------------- COPIES TO: Page 10f7 ITEM NO. ~ .1 c Revenues and funding sources would exceed expenditures). The impact on the contribution to reserves is also discussed later in the report. The following provides additional analysis about the trends in the major categories. REVISIONS TO REVENUE ESTIMATES - GENERAL FUND . Property Taxes (Adopted Bud2et Estimate = $22.194.200) (Category represents approximately 40% of budgeted General Fund Revenues) As of December the City has only received the first advance of the 2007/2008 secured taxes. Based on historical trends and the amount collected for this period, Staff is projecting that no adjustment will be required. to the Budget. Staff will be meeting with Alameda County representatives near the end of March. If there is a significant increase in delinquency rates this will have a negative impact on these revenues. Revised Estimate Property Tax Category: No Chan2e . Sales Tax (Adopted Bud2et Estimate = $14.840.000) (Category represents approximately 27% of budgeted General Fund Revenues) This category is impacted significantly by automobile sales trends. More than 31 percent of the total Sales tax for the last four fiscal years has been related to New and Used Automobile sales and leases. Although the City has new dealers operating at the GM Auto Mall in 2007/08 (Saturn Saab Hummer), the general trend in automobile sales is downward. In addition, there has been a statewide decline auto sales as well as the Building and & Construction category. The City will not receive sales tax data for the period ending December 31, 2007 until late in March. Typically fourth quarter sales represent the largest quarter for many consumer retailers due to the holiday shopping season. Based on data currently available, Staff is recommending a reduction in the estimated Sales Tax Revenue by $450,000. Revised Estimate Sales Tax Category: (- ) Decrease) $450,000 · Taxes Other Than Property and Sales Tax (i.e. Franchise Tax / TOT) (Adopted Bud2et Estimate = $3.410.635) (Category represents approximately 6% of budgeted General Fund Revenues) Currently it appears that the revenue to be received will meet the original budgeted forecast. Revised Estimate Taxes Other Than Property Category: No Chan2e · Licenses & Permits (Adopted Bud2et Estimate = $2.306.445) (Category represents approximately 4% of budgeted General Fund Revenues) Revenues in this category are directly impacted by the activity associated with Building Permits, which account for the majority of this revenue. At this time the overall building and fire permit revenue is projected to be less than the budget at year end by approximately $741,800. A portion of this amount will be offset by decreased expenditures for contract inspection services, however, it does not completely offset the decrease. Factors which have contributed to this include: -Projects originally anticipated to obtain permits in Fiscal Year 2007/08 have not proceeded as expected and there has been a general decline in the Building Permits issued. Among the projects that have proceeded slower than expected are: Sorrento East (Neighborhoods 6-10); DR Horton Metropolitan; Windstar; Silvera Ranch Phase IV; Wallis Ranch; and the Blake Hunt Center. The decrease in Building permit activity is projected to decrease the revenue by $675,000. Page 2 of7 - Construction and Demolition Permits are less than originally projected. This activity accounts for a recommended adjustment of $40,000. -Fire Code Permits primarily for commercial projects originally projected for 2007/08 are not expected to be issued this fiscal year. This activity accounts for a recommended adjustment of $26,800. Revised Estimate Licenses & Permits Category: (-) Decrease $ 741,800 . Fines & Forfeitures (Adopted Bud2et Estimate = $143.000) (Category represents a very small percentage, 0.3% of budgeted General Fund Revenues) It currently appears that the revenue to be received from general fund fines and forfeitures will be near the original budgeted forecast. Revised Estimate Fines & Forfeitures Category: No Chan2e . Interest & Rentals (Adopted Bud2et Estimate = $2.964.212) (Category represents approximately 5% of budgeted General Fund Revenues) Interest Revenue represents 88% of the total budgeted revenue in this category. The remainder consists of rental income collected for the use of City facilities. The City's overall rate of return on its investments has been lower than was budgeted. In the first two quarters the interest averaged 4.5% and the budget estimate was based on a rate of 4.75%. There has also been a steep decline in interest rates, since the beginning of the year. This accounts for a projected decrease of $525,000. General rentals of City Facilities are expected to track at the budgeted amount with the exception of rental revenue for the Dublin Square Shopping Center, which was acquired by the City. As part of the relocation of tenants rent revenues will be less than projected by $51,541. Revised Estimate Interest & Rentals Category: (-)Decrease $ 576,541 · Inter20vernmental Revenues (Adopted Bud2et Estimate = $1.212.669) (Category represents approximately 2% of budgeted General Fund Revenues) This category is comprised of four primary components: 1) State Grant Funds (Workforce Housing Grant Budgeted at $493,609 and a Storm Water Project Grant budgeted at $249,060); 2) Vehicle License Fees, budgeted at $290,000; and 4) Homeowner Property Tax Relief budgeted at $180,000. A combination of factors will impact the projection which will result in overall a reduction in the budget. The City has received approximately $21,000 in reimbursements from the State Mandated Cost program which were not anticipated in the budget. This was offset by an estimated $100,000 reduction in the amount budgeted Vehicle License Fees. The Workforce Housing Grant programmed for use on the Shannon Center Reconstruction project is claimed as expenditures are made. Because more of the funds were received in 2006/07 than anticipated in the budget, the 2007/08 amount will need to be reduced. The 2007/08 budget for this grant was overstated by $84,000, since these funds were actually received in Fiscal Year 2006/07. All Work Force Housing Grants awarded have been claimed. Revised Estimate Intergovernmental Category: (- )Decrease $ 163,000 Page 30f7 . Char2es for Services (Adopted Bud2et Estimate = $6.362.056) (Category represents approximately 12% of budgeted General Fund Revenues) Overall the net change to this category is projected to result in a decrease of $100,000. Approximately 63% of the revenue in this category is related to the following activities: Zoning & Subdivision Fees; Engineering Plan Check Fees Planning; and Fire Plan Check Fees. The first two are expected to achieve the budget estimate. The Fire Plan Check and Inspection revenue is projected to be $100,000 less based on delays in development projects. Revised Estimate Charges For Services Category: (-) Decrease $100,000 . Other Revenues (Adopted Bud2et Estimate = $1.642.012) (Category represents approximately 3% of budgeted General Fund Revenues) Approximately 66% of the revenue in this budgeted category represents reimbursements to the General Fund associated with Capital Projects (BART Mitigation - St Patrick Way and Fallon Road Interchange). The timing for the receipt of these revenues may change based on the timing of the projects. This also means that expenses will not be incurred as originally planned and there would not be any net change in the financial impact. A small change is requested to reflect a pass- through grant of $5,000, which the Heritage Center will use to fund expenditures as described in the next section of this report. Revised Estimate Other Revenues Category: (+) Increase $5,000 The Budget Change attached to the Staff Report will adjust the individual General Fund Revenue accounts as described above. REVISIONS TO EXPENDITURE ESTIMATES - GENERAL FUND Staff has reviewed expenditures through December 2007 for all accounts that affect the City's General Fund. The following discussion highlights those areas where an increase or decrease in the budget appropriation is recommended at this time. The analysis assumes that all other expenditures will be in accordance with the adopted budget. GENERAL GOVERNMENT (Increase $11,000) . Building Management - Dublin Square (001.10500.740.009) The amount budgeted for operating costs associated with the Dublin Square property was estimated based on limited knowledge of the expenditure patterns and it was assumed that all activity would be completed in the first six months. A total of $26,000 was budgeted for property management coordination as well as utilities and other contract services. A budget change of $11,000 is being recommended to fund additional property management services to secure the site pending demolition ofthe shopping center structures which will be bid as a Capital Project. Proposed Additional Building Management Expenditures: (+) Increase $11,000 Page 4 of7 PUBLIC SAFETY (Decrease $100,000) . Disaster Preparedness (001.20500.740.001) The contract services costs incurred with Alameda County Fire Department are projected to be less than the amount budgeted. Proposed Reduction In Disaster Preparedness Expenditures: (-) Decrease $10,000 . Fire (001.20600.740.001) Staffing costs are estimated to be less than the amount budgeted. Proposed Reduction In Fire Services Expenditures: (-) Decrease $90,000 HEALTH & WELFARE (Increase $6,591) . Waste Management (001.50200.740.000) A Budget change of $6,591 is being recommended to fund consultant work initiated in Fiscal Year 2006/07 that was not complete as of June 30, 2007. This project involved the Garbage Company Rate Renewal and Model changes. Staff had anticipated the project would be completed by June 30, 2007 however, the services needed to be extended to September 2007 for completion. Proposed Additional Waste Management Expenditures: (+) Increase $6,591 CULTURE & LEISURE SERVICES (Increase $83,253) . Heritage Center (001.80120.740.000) A Budget change of $5,000 is being recommended to fund costs associated with a grant to digitize historical photos. Much of the work has been completed by the Library, however, there remains a need for shelving in a storage cabinet as well as preparation of a media package to advise interested parties of the availability of the photos. These additional costs would be offset by a pass-through grant from the Library resulting in no net impact on the City Budget. Proposed Additional Heritage Center Expenditures: (+) Increase $5,000 . Park Maintenance (001.80200.750.050) A Budget change of $8,000 is being recommended to fund costs associated with relocating art work and modifications to the Dougherty Hills Dog Park. Proposed Additional Park Maintenance Expenditures: (+) Increase $8,000 . Community Cable TV (001.80300.740.000) The non-profit Board of Directors which oversees Tri-Valley Community Television (TV30) has engaged in an effort to fully examine the operations and determine the best course for these services in the future. In order to accommodate this effort through the end of the fiscal year, a supplemental contribution of $52,953 has been requested from the City of Dublin. (See Attachment 4) TV30 has also requested $10,000 for capital equipment. This will be funded from funds already appropriated by the City Council in Capital Project #93135 TV30 Studio Remodel. A copy of the TV30 request is attached to this report. Proposed Additional Community Television Expenditures: (+) Increase $52,953 Page 5 of7 . Swim Center (001.81000.750.050) A Budget change of $17,300 is being recommended to fund costs associated repairs and maintenance including sewer line repairs at the swim center. Proposed Additional Swim Center Expenditures: (+) Increase $17,300 COMMUNITY DEVELOPMENT (Decrease $422,000) . Community Development Building & Safety (Various Accounts) Based on vacancies and staffing resources required for the reduced permits issued, the Building Department Division budgeted expenditures are recommended to be reduced. As previously discussed there is also a reduction in revenue from Building Department activities. Approximately $143,500 in salary and benefit savings are projected. In addition, approximately $278,500 in savings will occur based on reduced contract Inspection Staffing. Proposed Reduction In Building & Safety Expenditures: (-) Decrease $422,000 Combined Effect of Revenue & Expenditure Adjustments On General Fund Reserve Projection In summary, the total recommended decreases in General Fund Revenues total approximately $2 million, which is partially offset by approximately $421,156 in expenditure reductions. In addition Staff have estimated that the Heritage Park Acquisition Project is expected to be completed for $1.5 million less than the Budget. Therefore, is projected that the 2007/2008 Budget will be balanced. As shown in the Table below, the contribution to reserves will be slightly less than originally projected. SUMMARY NET IMPACT OF 2007/2008 MID-YEAR GENERAL FUND BUDGET ADJUSTMENTS (Presented March 4, 2008) Projected Contribution To Reserves In 2007108 Budget Adopted June 2007 REVENUE Property Taxes Taxes Other Than Property Licenses & Permits Fines & Forfeitures Use of Money & Property Intergovernmental Charges For Services Other Revenue Sub-Total Revenue Adjustments EXPENDITURES General Government Public Safety Health & Welfare Culture & Leisure Community Development Sub-Total Expenditure Adjustments $2,676,571 Mid- Year Adjustments $0 ($450,000) ($741,800) $0 ($576,541) ($163,000) ($100,000) $5,000 ($2,026,341) $11,000 ($100,000) $6,591 $83,253 ($422,000) ($421,156) IMPACT ON CONTRIBUTION TO RESERVES Original Contribution To Reserves $2,676,571 Adjustment Lower Revenues ($2,026,341) Adjustment Reduced Expenditures $421,156 REVISED PROJECTED RESERVE CONTRIBUTION PROJECT SAVINGS Projected Savings CIP # 95556 - Dublin Historic Park Acquisition NET CONTRIBUTION TO RESERVE Page 6 of7 $1,071 ,386 $1,500,000 $2,571,386 POTENTIAL IMPACTS FROM STATE BUDGET DEFICIT It is important to note that the estimated 2007/08 Projected Surplus of $2.5 million is a projection based on incomplete data. The State of California fiscal situation is not positive. The Governor has already enacted measures that will delay some Gas Tax payments to the City of Dublin. Next year the forecast at the State level is for continued deficits and there is a potential that the solution enacted may impact local government finances. The State has suggested the possibility of discontinuing the State COPS grant ($100,000) as well as changes that will result in the City paying Jail Booking Fees. In addition to the State Budget Impacts general economic trends may continue to result in a deterioration of local revenues such as sales tax and property tax. Currently the City only has actual retail sales data through September 2007. Although the budget estimate is based on decreases from the prior year, the precise amount remains largely unknown. For these reasons, caution should be used before assuming that the full $2.5 million can be relied upon for a specific use. REVISIONS TO REVENUE ESTIMATES - IMPACT FEE FUNDS The City has significant capital project activities that are funded from impact fees collected as development occurs. The slow-down in new development has had a major impact on the projected amount of fees to be collected. Each Year the Community Development Staff as part of the Budget process review planned construction projects. This includes interviews with developer representatives to determine possible project timing. Based on the activity to date and the information gathered by Staff, it is recommended that reductions be made to the budgeted revenue in the impact fee categories. The following are the proposed revisions: IMPACT FEE. MID- YEAR ADJUSTMENT 2007/2008 MID-YEAR DIFFERENCE BUDGET PROJECTION (Reduction) Traffic Impact Fees (Excluding Fallon $2,808,797 $1,700,091 ($1,108,706) Interchange Advance) Public Facility Fees $9,541,376 $2,527,095 ($7,014,281) Fire Impact Fees $260,825 $149,603 ($111,222) A Budget adjustment addressing the reduction in Impact Fees has been included. The significant difference in Public Facility Fees is largely due to the payment of certain Park Land Fees at the initial stage of a project when the Final Map is approved. Several projects are not expected to record their final map in Fiscal Year 2007/2008. It should be noted that Staff expects to be able to proceed with the capital projects scheduled for expenditure in the current Fiscal Year. As part of the 2008/2009 Budget Preparation Staffwill assess any impact on the timing of future projects. Recommendation Staff recommends that the City Council (1) Receive the Report and Staff Presentation (2) Approve the Budget Changes. Page 7 of7 I-~ I I Total General Fund Revenues ~______.._____..__..__~1 I I City of Dublin 2007-2008 YTD Revenues and Budget Comparison For the Period Ending December 31,2007 .......................................-.................................................,..................-.....................r......................_..................l---mm 41% 43% Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State , Charges for Services Fines and Forfeitures Other Revenues L Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Fines and Forfeitures Interest and Rentals Intergovernmental Charges for Services Other Revenues 0% FY 2007/08 Budget 22,194,200 14,840,000 540,000 775,000 2,095,635 2,306,445 143,000 2,964,212 1,212,669 6,362,056 1,642,012 Total General Fund Revenues 55,075,229 Date Printed: 2n/2008 4:53 PM I. FY 2007/08 I I FY 2006/07 71% 30% 60% 90% 120% 150% 50% of Year Complete FY 2007/08 %of FY 2006/07 % of Total for YTD Actual Budget YTD Actual FY 2006/07 10,505,671 47% 8,939,500 44% 5,464,584 37% 6,952,455 50% 241 ,343 45% 268,618 45% 340,822 44% 352,723 44% 552,366 26% 507,828 24% 825,270 36% 1,833,709 71% 60,677 42% 62,547 45% 1,220,467 41% 1,153,479 31% 455,285 38% 144,866 13% 2,615,298 41% 2,936,836 37% 450,032 27% 237,683 26% 22,731,815 41% 23,390,244 43% .J;!e""II~ ~,I ::,/ itl o.l '1 ATTACHMENT 1 d< ~JCj r---~-------_._-------.--.- ----~------ City of Dublin 2007-2008 YTD Expenses and Budget Comparison For the Period Ending December 31, 2007 Total General Fund Expenses General Government Police Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects Fire 0% 20% 40% 60% 80% 100% 50% of Year Complete 2007/08 2007/08 %of FY 2006/07 Budget YTD Actual Budget YTD Actual General Government 5,836,461 2,561,429 44% 2,429,179 Police 12,554,821 2,983,795 24% 2,488,499 Fire 9,558,930 2,387,402 25% 2,308,969 Other Public Safety 573,028 89,777 16% 83,786 Transportation 2,239,419 866,413 39% 747,653 Health and Welfare 45,413 15,367 34% 18,500 Culture and Community Services 7,446,591 3,345,513 45% 2,709,919 Community Development 8,640,211 3,519,276 41% 3,582,405 Capital Improvement Projects 8,806,386 3,043,851 35% 1,001,278 Total General Fund Expenses 55,701,260 18,812,823 34% 15,370,188 General Fund Operating Expenses 46,894,874 15,768,972 34% 14,368,910 Date Printed: 217120084:53 PM . FY 2007/08 . FY 2006/07 120% _I % of Total for FY 2006/07 44% 21% 25% 19% 37% 46% 39% 47% 29% 33% 33% ATTACHMENT 2 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF DECEMBER 2007 Prepared by TIle Finance Department February 7, 2008 311~ ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Dec2007 5';f J~ INTERNAL SERVICE FUNDS ENTERPRISE FIXED ASSETS GENERAL LONG FUND GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOT A L S ---MEMORANDUMu - CURRENT PRIOR ASSETS CASH 7.109.382 7.109.382 11.120.432 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 3.966 3.966 FIXED ASSETS 48.289.121 351. 342.286 399.631. 407 387.888.144 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 61. 862.464 61. 862.464 -62.246.041 TOTAL ASSETS 55.402.469 351. 342.286 61. 862 .464 468.607.218 461.254.618 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAY ABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (229.457) TOTAL LIABILITIES (229.457) FUND BALANCES (55.173.012) TOTAL FUND E (55.173.012) (61. 862 .464) (61.862.464) (62.091.921) (62.764.407) (62.091.921) (62.764.407) (406.515.298)(397.644.149) (406.515.298)(397.644.149) (351. 342.286) (351. 342.286) TOTAL LIABILITIES/EQUITY (55.402.469) (351.342.286) (61.862.464) (468.607.218)(460.408.556) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 12/31/2007 c,~A G ENE R A L REV E N U E FUN D CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR. PRIOR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 22.194.200.00 Hi .505 . 671. 48 11.688.528.52 20.146.742.78 8.939.499.86 11.207.242.92 J SALES TAX 14.840.000.00 5.464.583.78 9.375.416.22 14.025.868.73 6.952.455.38 7.073.413.35 REAL PROPERTY TRANSFER TAX 540.000.00 241.342.76 298.657.24 596.532.87 268.618.30 327.914.57 HOTEL TRANSIENT OCCUPANCY TAX 775.000.00 340.821. 78 434.178.22 800.772.57 352.722.51 448,050.06 FRANCHISE TAXES 2,095,635.00 552.365.50 1.543,269.50 2.111. 281. 26 507.827.71 1.603,453.55 LICENSES g, PERMITS 2,306.445.00 825.269.96 1. 481.175.04 2.572.067.54 1.833.708.70 738.358.84 FINES & FOR FE! TURES 143,000.00 60.677.31 82.322.69 .140.234.79 62,547.48 77.687,31 USE/MONEY & PROP-INTEREST 2,621. 744.00 1. 055.800.93 1. 565,943.07 3,575.137.21 1.121.889.10 2.453,248.11 USE/MONEY & PROP-RENTALS 342.468.00 160.844.09 181. 623.91 203.240.52 31. 589 . 85 171.650.67 INTERGOVERNMENTAL 1. 212 ,669.00 455.285.24 757.383.76 1.149,759.30 144.865.92 1. 004.893.38 CHARGES FOR SERVICES 6.362,056.00 2.615,297.73 3,746.758.27 8,015.064.77 2,936.836.10 5.078.228.67 OTHER SOURCES OF REVENUE 1. 642.012.00 450,032.37 1.191. 979.63 928.704.12 237.682.88 691.021.24 WTl\L REVENUE 55.075.229.00 22,727.992,93 32.347.236.07 54.265.406.46 23.390,243.79 30.875.162.67 *******EXPENDITURES******* GENERAL GOVERNMENT ACT! V ITI ES : CITY COUNCIL 304,891.00 150.049.78 154.841. 22 320.924.20 107,090.77 213.833.43 CITY MANAGER 1. 128 . 643 . 00 531.256.25 597,386.75 1.042,480.01 503.246.87 539,233.14 CENTRAL SERVICES 549.400.00 234.049.66 315.350.34 438.786.38 195.465.57 243.320.81 CITY /1.TTORNEY 615,723.00 273.377.10 342.345.90 867,874.77 287,416.29 580.458.48 ADMIN SERVICES 1. 844.459.00 748,337.92 1.096.121.08 1.593.027.81 760.320.92 832.706.89 BUILDING MANAGEMENT 785.873.00 324.438.92 461. 434.08 707.316.31 268.418.63 438.897.68 INSURANCE COST CENTER 538.541. 00 282.480.15 256.060.85 474.542.39 299.335.26 175.207.13 ELECT! ONS COST CENTER 2.500.00 425.00 2.075.00 25.554.79 4.314.25 21. 240.54 NON-DEPARTMENTAL 66,431. 00 13.191. 54 53.239 .46 9.858.11 3.570.62 6.287.49 ACT! V ITY WTAL 5.836,461.00 2.557.606.32 3.278.854.68 5,480.364.77 2.429.179.18 3.051.185.59 PUBLIC SAFETY PULICE 12,554.821. 00 2.983.794.61 9,571,026,39 11,662,394.30 2.488.499.01 9,173,895,29 CROSSING GUARDS 98.648.00 33.644.88 65.003.12 86.639.21 27,525.47 59.113.74 ANIMAL CONTROL 351.192.00 19,368.90 331.823.10 251. 956.53 27.922.00 224.034.53 TRAFFIC SIGNALS & STREET LlGHTIN 13.300.00 5.891.34 7.408.66 15.424.08 8.041. 90 7.382.18 DISASTER PREPAREDNESS 109.888.00 30.871.80 79,016.20 79,826.64 20.297.01 59.529.63 FIRE SERVICES 9.558.930.00 2.387,402.27 7 . 171 .527 .73 9.178,765.31 2.308.968.92 6,869,796.39 ACTIVITY WT AL 22,686,779.00 5.460,973. 80 17.225,805.20 21. 275.006.07 4.881.254.31 16,393,751. 76 TRANSPORTATION PURL! C \oJOR<S 1.094,762.00 460.962.94 633.799.06 907.511.91 424.572.25 482.939.66 STREET MAINTENANCE 33,147.00 397.40 32.749.60 13,221. 64 366,31 12.855.33 STREET SWEEPING 138,000.00 42,592.52 95,407.48 139.992,31 42.372,84 97,619.47 STREET TREE MAINTENANCE 106,917.00 27,429.34 79.487,66 131. 391. 84 23.957.50 107.434.34 STREET LANDSCAPI NG MAINTENAN 866,593.00 335.030.62 531. 562.38 811.550.20 256,384.35 555.165,85 ACTI V!TY TOTAL 2.239.419.00 866.412.82 1.373,006.18 2.003,667.90 747.653.25 1. 256 , 014.65 HEALTH & WELFARE WASTE ~iANAGEMENT 1.500.00 7.190.58 (5.69058) 22,055.21 22.055.21 CHILD CARE 18.50000 8.176.61 10,323.39 18.500.00 18,50000 SOCIAL SERVICES 25.413 25,413.00 HOUSING PROGRAMS '1 ';f 1'1 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 12/31/2007 G ENE R A L REV E N U E FUN D CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ,IICTI V ITY TOTAL 45.413.00 15.367.19 30.045.81 40.555.21 18.500.00 22.055.21 CULTURE & LEI SURE SERV ICES LI BRARY SERV ICES 836.571. 00 393.263.77 443.307.23 809.628.89 202.727.34 606.901. 55 CULTURAL ACTIVITIES 239.530.00 121. 458.87 118.071.13 251. 944.51 129.168.81 122.775.70 HERITAGE CeNTER 233.752.00 115.835.41 117.916.59 181.827.65 90.320.44 91.507.21 DUBL! N CEMETERY 48.458.00 13.417.61 35.040.39 43.942.65 15.482.95 28.459.70 PARK MAINTENANCE 2.008.692.00 907.174.96 1.101.517.04 1.808.688.78 542 .971 . 36 1.265.717.42 COMMUN ITY TV 75.027.00 31. 038.64 43.988.36 128.881. 00 60.351. 00 68.530.00 RECREATION ADMIN 759.339.00 346.108.94 413.230.06 702.189.94 332.744.95 369.444.99 PLAYGROUNDS 320.073.00 134.422.79 185.650.21 260.228.97 121. 796.25 138.432.72 SHANNON CENTER 286.982.00 150.728.64 136.253.36 342.407.56 178.583.49 163.824.07 PRESCHOOL 115.643.00 51. 886.57 63.756.43 105.844.87 46.020.78 59.824.09 TEENS PROGRN1 146.164.00 57.246.52 88.917 .48 135.910.40 62.329.38 73.581. 02 ADULT SPORTS 183.056.00 53.715.71 129.340.29 106.532.29 42.813.36 63.718.93 YOUTH SPORTS 204.177 .00 93.115.90 111. 061.10 174.520.06 76.273.30 98.246.76 COMMUNITY GYM 46.187.00 21. 069.01 25 .117 .99 44.662 . 71 20.256.06 24.406.65 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 403.471.00 174.945.02 228.525.98 354.952.30 148.024.84 206.927.46 SENIOR CENTER 549.653.00 239.556.29 310.096.71 472.926.09 210.782.02 262.144.07 RECREATION INSTRUCTION 209.545.00 86.026.14 123.518.86 198.529.01 87.715.27 110.813.74 AQUATICS 450.188.00 203.789.60 246.398.40 445.981.03 193.132.26 252.848.77 PARKS/FACILITIES MANAGEMENT 330.083.00 150.712.27 179.370.73 304.996.60 148.424.75 156.571.85 ACT! V ITY TOTAL 7.446.591.00 3.345.512.66 4.101.078.34 6.874.595.31 2.709.918.61 4.164.676.70 COMMUNITY DEVELOPMENT PLANN I NCi 2.893.306.00 1.115.045.21 1.778.260.79 2.152.189.29 988.210.88 1.163.978.41 BUILDING SAFETY 3.130.274.00 1. 265 . 228.79 1.865.045.21 2.886.668.83 1.319.930.87 1.566.737.96 ENGINEERING 2.321. 911.00 1.027.576.05 1.294.334.95 2.407.540.23 1.123.311. 02 1. 284.229.21 ECONOMIC DEVELOPMENT 294.720.00 111.425.69 183.294.31 252.495.57 150.952.17 101. 543.40 ACTIVITY TOTAL 8.640.211.00 3.519.275.74 5.120.935.26 7.698.893.92 3.582.404.94 . 4.116.488.98 CA,P IT AL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1.558.757.00 46.471.01 1.512.285.99 377 .025.76 53.914.74 323.111.02 COMMUNITY IMPROVEMENTS 328.578.00 106.805.43 221. 772.57 95.671.93 19.518.79 76.153.14 PARKS 5.776.648.00 2.834.719.65 2.941. 928.35 2.619.196.45 685.968.07 1.933.228.38 STREET CONSTRC/IMPROVEMENTS .1.142.403 00 55.856.56 1. 086.546.44 308.244.43 241. 876.35 66.368.08 ACTI VITY TOTAL 8.806.386.00 3.043.852.65 5.762.533.35 3.400.138.57 1.001.277 .95 2.398.860.62 TOTAL EXPENDITURES 55.701. 260.00 18.809.001.18 36.892.258.82 46.773.221.75 15.370.188.24 31. 403.033.51 EXCESS REVENUE (EXPENDITURES) (626.031.00) 3.918.99175 (4.545.022.75) 7.492.184.71 8.020.055.55 (527.870.84) TRANSFERS IN FROM OTHER FUNDS 59.196.81 39.525.20 19.671.61 TRANSFERS OUT FROM ClTHER m.IDS (23.505.65) (23.505.65) REVENUES OVER(UNDER) EXPENDITURES .031.00) 3.918,991.75 (4.545.02275) 7.527.875.87 8.059.580.75 (531. 704 .88) g~t~ THE CITY OF DUBLIN STATEMENT SHOWING . REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 12/31/2007 SPECIAL REV E N U E FUN D S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 125.760.00 66.330.87 59.429.13 119.472.73 61.237.46 58.235.27 SALES TAX/OTHER TAXES 460.862.00 119.463.75 341.398.25 433.043.17 156.910.69 276.132.48 FINES & FORFEITURES 195.000.00 80.341. 98 114.658.02 201. 862.59 66.297.61 135.564.98 USES/MONEY & PROPERTY 216.249.00 86.543.71 129.705.29 194.816.32 94.038.96 100.777.36 INTERGOVERNMENTAL FROM STATE 1.670.059.00 468.636.96 1. 201. 422.04 1. 174.71 0 . 84 724.547.54 450.163.30 INTERGOVERNMENTAL FROM COUNTY 397.023.00 85.103.75 311.919.25 376.594.90 85.808.30 290.786.60 INTERGOVERNMENTAL FROM FEDERAL 459,471.00 15,416.40 444.054.60 144.868.47 2.813.17 142.055.30 :HARGES FOR SERVICES 1.513.762.00 769.360.33 744.401.67 1.430.805.72 735.276.64 695.529.08 OTHER SOURCES OF REVENUE 9.000.00 16.901. 00 (7.901.00) 25.467.40 25.467.40 TOTAL REVENUE 5.047.186.00 1.708.098.75 3.339.087.25 4.101.642.14 1.926.930.37 2.174.711.77 *******EXPENDITURES******* PUBLIC SAFETY: POll CE 104,810.00 101. 355.00 3.455.00 101. 780.53 100.370.70 1.409,83 TRAFFIC SIGNALS & STREET LTG 279,525.00 111.739.79 167.785.21 249.275.06 99.680.93 149.594.13 DISASTER PREPAREDNESS FIRE SERVICES 287,483.00 116,276.63 171,206.37 196.755.84 78.390.10 118.365.74 ACTIVITY TOTAL 671.818.00 329.371.42 342.446.58 547.811.43 278.441.73 269.369.70 TRANSPORT A TI ON: STREET MAINTENANCE 398.986.00 103.237.78 295.748.22 305,088.60 70.771.49 234.317.11 STREET LANDSCAPE MAINTENANCE 6.038.00 6.038.00 7 .563 .43 7.563.43 ACT! V ITY TOTAL 405.024.00 103.237.78 301. 786.22 312.652.03 70.771.49 241.880.54 HEALTH & WELFARE: WASTE MANAGEMENT 1.663.490,00 799.806.48 863.683.52 1. 525 . 606 . 71 18.313.41 1.507.293.30 SOCIAL SERVICES 52.945.00 24.228..99 28.716.01 60.035.35 13.769.84 46.265.51 HOUSING PROGRAMS ACTI VITY TOTAL 1.716.435.00 824.035.47 892.399.53 1. 585 . 642 . 06 32.083.25 1.553.558.81 COMMUNITY DEVELOPMENT: ENGINEERING 6.000.00 2.472.00 3.528.00 6.000.00 840.00 5.160.00 ACT! VITY TOTAL 6.000.00 2.472. 00 3.528.00 6.000.00 840.00 5.160.00 CAPITAL IMPROVEMENT PROJECTS. GENERAL CIP PROJECTS 10.853 00 10.853.00 COMMUN ITY PRm ECTS 17.580.62 17.580.62 PARKS 62.050.00 62.050.00 132.238.71 75.525.71 56.713.00 STREET CONSTRUCTION/IMPROVEMENT 2,086.803.00 785.534.63 1. 301. 268 37 726.185.12 34.074.77 692.110.35 ACTI V ITY TOTAL 2.159.706.00 785.534.63 1. 374.171. 37 876.004.45 109.600.48 766.403.97 TOT A L EXPENDITURES 4.958.983.00 2. 044.651. 30 2.914.331. 70 3.328.109.97 491. 736.95 2.836.373.02 EXCESS REVENUE (EXPENDITURES) 88.203.00 (336.552.55) 424.755.55 773.532.17 1. 435 .193.42 (661. 661. 25) TRANSFER IN FROM OTHER FUNDS (1.097.00 ) (1.097.00 ) TRANSFERS OUT TO OTHER FUNDS 27.368.61 27.368.61 REVENUES OVER (UNDER) EXPENDITURES 88.203.00 (336.552.55) 424.755.55 747.260.56 1. 435 . 193.42 (687.932.86) 9~J1 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 12/31/2007 S P E C I A LAS S E SSM E N T FUN D S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 785.567.00 411.787.33 373.779.67 716.143.96 364.945.60 351.198.36 USES/MONEY & PROP-INTEREST 26.106.00 9.791.29 16.314.71 26.363.45 10.232.00 16.131.45 OTHER SOURCES OF REVENUE 5.000.00 578.00 4.422.00 3.219.91 3.219.91 TOTAL REVENUE 816.673.00 422.156.62 394.516.38 745.727.32 375.177.60 370.549.72 *******EXPENDI TURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 376.400.00 130.090.73 246.309.27 325.491. 81 134.438.30 191. 053.51 ACT! V I TY TOTAL 376.400.00 130.090.73 246.309.27 325.491. 81 134.438.30 191. 053.51 TRANS PORT A TI ON PLlBLI C WORKS 100.00 100.00 1.640.07 1.277.11 362.96 STREET TREE MAINTENANCE 65.910.00 21. 589 . 09 44.320.91 39.305.46 6.817.06 32.488.40 STREET LANDSCAPE MAINTENANCE 393.678.00 155.821.93 237.856.07 369.334.70 119.686.68 249.648.02 ACT! V ITY TOTAL 459.688.00 177.411.02 282.276.98 410.280.23 127.780.85 282.499.38 COMMUNITY DEVELOPMENT ENGINEERING 15.500.00 8.53294 6.967.06 10.558.50 358.50 10.200.00 ACT! V ITY TOTAL 15, ~JOO. 00 8 , EJ32 . 94 / 6.967.06 10.558.50 358.50 10:200.00 CAPITI>.L IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT ACT! V ITY TOTAL TOT A L EXPENDITURES 851.588.00 316.034.69 535.553.31 746.330.54 262.577.65 483.752.89 EXCESS REVENUE (EXPENDITURES) (34.915.00) 106.121. 93 041.036.93) (603.22) 112.599.95 013.203.17) REVENUES OVER (UNDER) EXPENDITURES (34.915.00) 106.121. 93 041.036.93) (603.22) 112.599.95 013.203.17) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 12/31/2007 10 ~ 11 CAP I TAL IMP R 0 V E MEN T FUN D S *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES' NON-DEPARTMENTAL 78.785.62 78.785.62 CITY ATTORNEY 49.400.00 37.393.25 12.006.75 59.936 A8 34.963.91 24.972.57 ACTI V ITY TOTAL 49.400.00 37.393.25 12.006.75 138,722.10 34.963.91 103.758.19 PUBLI C SAFETY TRANSPORTl'lTION: riEALTH & WELFARE: HOUSING PROGRAMS 3.994.884.00 550.221.48 3 . 444 . 662 . f,2 458,257.23 117,571A7 340.685,76 ACTI V I TY TOTAL 3.994.884.00 550.221. 48 3.444.662.52 458.257.23 117.571.47 340.685.76 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNH~G ACT! V ITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 195.550.00 195,550.00 24.905.17 16.751.50 8.153.67 COMMUNITY IMPROVEMENTS 250.000,00 250.000.00 PARKS 8,242.583.00 974.926,51 7.267.656A9 7.993.412,28 321.515.64 7.671.896,64 STREET CONSTRUCTlON/IMPROVEMENT 30.119.579.00 5 All. 905.98 24.707.673,02 4.497.678.86 2.944.747.49 1. 552 . 931. 37 ACTI V ITY TOTAL 38.807.712.00 6.386.832.49 32,420,87951 12.515.996.31 .3.283.014.63 9.232.981.68 TOT A L EXPENDITURES 42.851.996.00 6.974.447.22 35.877 .548. 78 13.112.975.64 3.435.55001 9.677A25,63 EXCESS REVENUE (EXPEND ITURES) (15,460,515.00) (3.601.086.15)(11.859.428.85) (2.415.819.02) 4.043.322.40 (6.459.141,42) TRANSFER IN FROM OTHER FUNDS 30,105.65 30.105.65 TRANSFERS OUT TO OTHER FUNDS 39.525,20 39.525,20 REVENUES OVER (UNDER) EXPENDITURES(15.460.515;00) (3.601.086.15)(11,859.428,85) (2.425.238,57) 4.003.797.20 (6.429.035,77) ********REVENUES******** SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTI V ITY TOTAL PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUN!TY DEVELOPMENT CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) REVENUES OVER (UNDER) EXPENDITURES CURRENT BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 12/31/2007 T R U S T / AGE N C Y CURRENT ACTUAL 101.539.85 130.170.29 490.098.81 42,00752. 42,007.52 42.007.52 448,091.29 448.091.29 VARIANCE (101. 539 . 85) (130.170.29) (490,098.81) (42,001.52) (42,007.52) (42.00752) (448,091. 29) FUN 0 PRIOR FISCAL YEAR 217,030.10 14,825.42 5,929,923.59 231,940.00 231,940.00 231,940.00 5.697,983.59 (448,091.29) 5,697.983.59 PRIOR Y.T.D. 108,515.05 5,966.03 114,481.08 187,007.50 187,007,50 1/ 1 /1 VARIANCE 108.515.05 8,859.39 5.815,442.51 44,932.50 44,932.50 187,007.50 44,932.50 (72,526.42) 5,770,510.01 (72,526.42) 5,770,510.01 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 12/31/2007 kQ .~ f~ rnERNAL S E R V I C E FUN D S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 214.192.00 134.201. 29 79.990.71 477 .640.72 216.458.88 261.181. 84 CHARGES FOR SERVICES 1. 682.057.00 724.634.51 957.422.49 1.786.972.00 892.703.70 894.268.30 OTHER SOURCES OF REVENUE 22.800.00 6.028.03 16.771. 97 1. 475,321. 69 8,434.20 1. 466,887.49 TOTAL REVENUE 1. 919,049.00 864.863.83 1. 054 .185 .17 3,739.934.41 1.117,596.78 2,622.337.63 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTI V ITY TOTAL PUBLI C SAFETY: FIRE 3.787.454.00 3.787.454.00 321. 862.81 321,862.81 3.465.591.19 11.472.708.13 3.465.591.19 11,472.708.13 271.535.05 11,201.173.08 271.535.05 11.201.173.08 ACTI V ITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 3.787.454.00 (1.868.405.00) 321,862.81 3.465.591.19 11.472,708.13 543.001.02 (2.411.406.02) (7.732.773.72) 271.535.05 11,201.173.08 846.061.73 (8,578.835.45) REVENUES OVER (UNDER) EXPENDITURES (1.868.405.00) 543.001.02 (2.411.406.02) (7,732.773.72) 846,061.73 (8,578.835.45) ******-HREVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* CiENERAL GOVERNMENT ACT! V ITI ES : NON-DEPARTMENTAL FINANCE ACT! V ITY TOTAL PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES E/CESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OLlT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES CURRENT BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 12/31/2007 E N T E R P R I S E CURRENT ACTUAL VARIANCE FUN D PRIOR FISCAL YEAR PRIOR Y.T.D. 13 <;f JCI VARIANCE TRI-V ALLEY COMMUNITY TELEVISION (TV30) 4663 BERNAL AVENUE, SUITE B /4 oe J 1 PLEASANTON, CALIFORNIA 94566 -1 February 25,2008 Mayor and City Councilmember's CitY of Dublin 100 Civic Plaza Dublin, California 94568 RE: Request For Supplemental Funding Dear Mayor Lockhart and Members ofthe City Council: The purpose of this communication is to advise you of an action taken at the February 21, 2008 Board of Directors meeting. After reviewing a report outlining the Mid-Year financial information and a projection of expenditures for the remainder of the year, the Tri-Valley Community Television Board of Directors, has requested that each City provide a supplemental contribution for the Fiscal Year 2007/2008 year. The Board of Directors has taken a proactive role in assessing the operation of the Community Television Corporation, which provides programming on channels 28, 29 and 30. The Budget for 2007/2008 was considered a "status - quo" budget and adopted unchanged from the previous year. In order to make informed decisions, this has required both time and additional resources. The efforts completed to date have included a 2005/06 Fiscal Year Financial Audit; Completion of a Management Study; and conducting a Board Workshop to discuss the mission of the organization and focus of the types of programming desired. In the next month the Corporation is expecting completion of the 2006/2007 Financial Audit as well as a professional survey of viewers. The survey along with financial information will be used to establish a plan for the future ofTV30. The required contribution is shown on the following page and is based on the Jollowing conditions: 1) Each City received more in Comcast Subscriber Fees than was identified in the original budget. The amount requested from each City reflects their 2007 Comcast Public Education Government (PEG) Fees. 2) Operating revenue for 2007/08 is projected to be less than the budget. With the economy some contributors such as the Board of Realtors have had to discontinue their production. Also increased expenditures needed to be funded. 3) General Operating Expenses are more than were budgeted. Time has been required to assess adjustments and the previous budget did not adequately appropriate funds for all base line obligations. 5) The Board identified Special Tasks and one time studies, necessary to proceed with informed decisions. 4) Capital Funds are requested to address immediate concerns which jeopardize the uninterrupted operation of the stations. On behalf of the Board of Directors I assure you that the decision to seek supplemental funding was not taken lightly. This will allow for an informed decision and the ability to structure proposals for the upcoming year. u:O ~.~ Paul S, Rankin TV30 Treasurer (City of Dublin Administrative Services Director) Cc: City Manager Cable TV Liaison M- f>o..e'" ff\e. ~~ L\ TRI-V ALLEY COMMUNITY TELEVISION (TV30} 4663 BERNAL AVENUE, SUITE B 15q: 11 PLEASANTON, CALIFORNIA 94566 1 FISCAL YEAR 2007/2008 SUPPLEMENTAL CONTRIBUTION SCHEDULE AND BACKGROUND INFORMATION (FEBRUARY 25, 2008) Dublin $ 8,647 $ 11,451 $ 18,309 $ 14,546 $ 10,000 $ 62,953 Livermore $ 7,606 $ 11,451 $ 18,309 $ 14,546 $ 10,000 $ 61,912 Pleasanton $ 8,122 $ 11,451 $ 18,309 $ 14,546 $ 10,000 $ 62,428 San Ramon $ 7,410 $ 11,451 $ 18,309 $ 14,546 $ 10,000 $ 61,716 TOTAL $31,785 $45,804 $ 73,236 $ 58,184 $ 40,000 $ 249,009 * NOTE: Each City has received Subscriber Fees from the cable and video service providers in excess of the budgeted amount. It is appropriate to equalize these payments made by Comcast to each City, with the amount each City contributes to TV30 for Education and Government Programming. It is recommended that the amount collected by each city in calendar year 2007 should be the amount provided to TV30 for Fiscal Year 2007/2008. Using this model, additional contributions for the current Fiscal Year are as shown below: Dublin $ 68,113 $ 59,466 $ 8,647 Livermore $ 131,944 $ 124,338 $ 7,606 Pleasanton $ 127,534 $ 119.412 $ 8,122 San Ramon $ 108,012 $ 100,602 $ 7,410 TOTAL $ 435,603 $ 403,818 $31,785 CITY OF DUBLIN MID-YEAR BUDGET CHANGEFORM FISCAL YEAR 200712008 It 1 J9 CHANGE FORM #: New Appropriations (City Council Approval Required): From Unappropriated Reserves From New Revenues Budget Transfers: PAGE I OF 4 Various Funds From Budgeted Contingent Reserve (1080-799.000) Within Same Department Activity Between Departments (City Council Approval Required) Other General Fund - REVENUE - Sales I NaTl1.~__~----.!~__~____________+~__ Account: 001-520-015 i $450,000 General Fund - REVENUE - 1'!:ame~_____!3_uiJding Permits_________-1- I Account: Name: Account: Name: Account: Name: Account: Name: Account: Name: Account: Name: Account: Name: Account: 001-530-00 I $675,000 General Fund - REVENUE - I Construction and Demolition i --- ~~~~~~-005--------~-+- $40,000 General Fund - REVENUE - Fire Permits 001-530-008 1------------- $26,800 General Fund - REVENUE - Interest 001-550-001 $525,000 General Fund - REVENUE - Dublin Rent 001-551-009 $51,54 ] GenCl-al Fund - REVENUE - Intergovernmental - Vehicle License Fees _...._.._-~._.~.._.. 001-555-001 General Fund - REVENUE - Intergovernmental - Mandated Name: Costs $100,000 Account: 001-555-016 $21,000 General Fund - REVENUE - Intergovernmental- Workforce Housing Grant 001-555-021 $84,000 General Fund - REVENUE - Charges For Services - Fire Plan Check & Inspection 001-565-033 $100,000 General Fund - REVENUE - Other Revenue - Heritage Center Pass Name: Through Library Grant Account: 001-570-003 $5,000 Reason for Budget Change: To reflect budget changes to Revenue Accounts proposed as part of the City's mid-year review of financial activity as of December 31,2007 for Fiscal Year 2007/08 - per the report to the City Council 3/4/2008. Fin Mgr / AS City Manager: Mayor: Posted By: Date: 2.: ~ 0$ Date: Date: Signature Date: Signature ATTACHMENT 5 CITY OF DUBLIN MID-YEAR BUDGET CHANGE FORM FISCAL YEAR 200712008 /1 CHANGE FORM #: New Appropriations (City Council Approval Required~ From Unappropriated Reserves From New Revenues Budget Transfers: PAGE 2 OF 4 Various Funds From Budgeted Contingent Reserve (1080-799.000) Within Same Department Activity Between Departments (City Council Approval Required) Other General Fund - Building Management - Dublin Sq Contract Name: Account: 001-1 0500-740~009 $11,000 Name: Account: General Fund Fund - Disaster . __l'r.eparedness - Contract Services__+- 001-20500-740-001 $10,000 Name: General Fund Fund - Fire Services - Contract Services Account: 001- 20600- 740-001 $90,000 General Fund - Waste Management Name: Contract Services Account: 001-50200-740-000 $6,591 General Fund - Heritage Center - Name: Contract Services Account. 001-80120-740-000 $5,000 General Fund - Park Maint - Nallle:... }mprovements _... Account: 001-80200-750-050 $8,000 General Fund - Community Cable Name: TV -lmprove11.1~~!~._.____ Account: 001-80300-740-000 _ _ --l-__~~~__.~__ $52,953 General Fund - Acquatics- l'J~I!1.~:.._..lInprovements I Rep~s_. Account: 001-8100-750-050 - --.-+--- i $17,300 Reason for Budget Change: To reflect budget changes to Expenditure Accounts proposed as part of the City's mid-year review of financial activity as of December 31,2007 for Fiscal Year 2007/08 - per the report to the City Council 3/4/2008. City Date: Fin Mgr I ASD: Date: r/2-7/'i3 Mayor: Date: Signature Posted By: Date: Signature CITY OF DUBLIN MID-YEAR BUDGET CHANGE FORM FISCAL YEAR 2007/2008 New Appropriations (City Council Approval Required): From Unappropriated Reserves From New Revenues Name: Account: Name: Account: Name: Account: Name: Account: 'Name: iA c-c-o~~~t: Name: -------. Account: General Fund - Building & Safety - Full-Time Salaries 001-90200-701-001 General Fund - Building & Safety - Retirement 001-90200-701-004 General Fund Fund - Building & I _ __ Safety_ - Group Insurance ____+ 001-90200-702-005 I I ----~ General Fund Fund - Building & Safety - Retiree Health 001-90200-702-010 General Fund Fund - Building & _ _u,safetY=J\(ledlcare~_______ 001-90200-70/-0 10 CHANGE FORM #: Budget Transfers: PAGE 3 OF 4 Various Funds From Budgeted Contingent Reserve (1080-799.000) Within Same Department Activity Between Departments (City Council Approval Required) Other $97,100 $21,900 ------..--.---~----------------.------1----.------- I I $16,200 $7,000 ----"$1300 ~------------- --_._------_._---_.._----"-_..__.,-----~-'--_._------~-_..__._,._-~ , , General Fund Fund - Building & ~,,-fety_=gontr~t Servi c_~__________ +__ 001-90/00-740-000 $278,500 Reason for Budget Change: To reflect budget changes to Building & Safety Expenditure Accounts proposed as part of the City's mid-year review of financial activity as of December 31,2007 for Fiscal Year 2007108 - per the report to the City Council 3/4/2008. Fin Mgr ! ASD: Signature ~ 1-.'A City Manager: Signa~~ r~9 ( - (10 Mayor: Posted By: Date: '2/ -z.; c> g Signature Signature Date: Date: CITY OF DUBLIN MID-YEAR BUDGET CHANGE FORM FISCAL YEAR 2007/2008 New Appropriations (City Council Approval Required): From Unappropriated Reserves From New Revenues Name: Account: Name: ----------..- Account: Name: Account: Name: ------------....- Account: Name: Account: Name: Account: Name: ------------ Account: CHANGE FORM #: Budget Transfers: PAGE 4 OF 4 Various Funds From Budgeted Contingent Reserve (1080-799.000) Within Same Department Activity Between Departments (City Council Approval Required) Other Traffic Impact Fee Fund - REVl!:~!1l!:~S~!~go_l)'l__ 300-580-023 Public Facility Impact Fee Fund - . _ __ Name: REVENUE-<::Ill~t:[.~k Impvts _ $500,331 Account: 310-580-034 Traffic Impact Fee Fund - .~Y!~!1J<:-=~~e~()D'! 300-580-024 Public Facility Impact Fee Fund - ___ ._ _ ____________~~1!l.~_ REVENUE - Cmmty Pk B1dgs , ___..__n_____ -----~..---------_._---t..- $269,849 Account: 310-580-035 i Traffic Impact Fee Fund - REVENUE - TVTD Fee 300-580-032 Public Facility Impact Fee Fund - Name: REVENUE - Libraries $180,271 Account: 310-580-036 Traffic Impact Fee Fund - REVENUE - Downtown 300-580-047 Public Facility Impact Fee Fund - Name: REVENUE - Civic Center $158,255 Account: 310-580-036 Public Facility impact Fee Fund - REVENUE - Aouatic 310-580-019 Name: $119,840 Account: 310-580-038 Public Facility Impact Fee Fund - REVENUE - Quimby Neigh Pk Land 310-580-020 Name: $1,097,712 Account: Public Facility Impact Fee Fund - REVENUE - Neighborhood Pk Land Eastern Dublin Public Facility Impact Fee Fund - REVENUE - Neighborhood Pk !Illpr(),,~~en.!s___. 310-580-039 Public Facility Impact Fee Fund - REVENUE - Cmmty Park Land - - -310=-580-021 ____~__n_________; Name: Fire Impact Fee Fund - REVENUE i .. .._-~- .. - - --.--------.-. . -------r- $1,289,185 Account: 320-580-028 ! ---(-- $1,603,130 $992,952 $410,850 $124,654 $917,560 $458,398 $111,222 Reason for Budget Change: To reflect budget reductions to the Impact Fee Accounts proposed as part of the City's mid- year review of financial activity as of December 31,2007 for Fiscal Year 2007/08 - per the report to the City Council 3/4/2008. City Manager: Mayor: Posted By: Signature Signature Date: Date: Date: