The URL can be used to link to this page

Home My WebLink About4.08 Mid-Year Budget Report & Monthly Report CITY CLERK File # DL3~[Q]-[5]C AGENDA STATEMENT CITY COUNCIL MEETING DATE: March 20,2007 SUBJECT: ATTACHMENTS: RECOMMENDATION: -? '1'->'t1 FINANCIAL STATEMENT: Fiscal Year 2006-2007 Mid-Year Budget Report and December 2006 Monthly Report of Financial Activities Report Prepared by: Paul S. Rankin, Administrative Services Dir P#v 1. 2. 3. YTD Revenues and Budget Comparison YTD Expenses and Budget Comparison Financial Statements for the Month of December 2006 Budget Change Forms 4. 1. 2. 3. Receive the Report Approve Budget Changes Approve an Operating Transfer of$1,097 from the FEMA Disaster Fund to the Gas Tax Fund. See Below DESCRIPTION: Attached is the monthly report of financial activities for December 2006. This report combines the typical monthly financial statements for December with a more detailed "Mid-Year Budget Review." It is important to note that some of the data is limited due to a lag in the time when bills for contract services are received. Prior year trends have been used to assess whether the current revenue and expenditures are tracking as expected in the adopted 2006/2007 Budget. Departments will be developing more precise estimates as the Fiscal Year 2007/2008 Budget is prepared. For the purpose of a mid-year review the focus is on major trends in the General Fund. REVENUE ESTIMATES UPDATE - GENERAL FUND Overall, the General Fund Revenues are currently projected to exceed the Budget estimate. The following Table summarizes the key adjustments expected to occur in General Fund Revenue Accounts. A narrative description of major deviations will be provided based on Revenue Type. COPY TO: G:\Mid Year Reports\FY 2006-07\AgStmt_midyr_rpt_07.DOC Page 1 of6 Lt. 8 ITEM NO. u SUMMARY OF PROJECTED CHANGES IN 2006/2007 BUDGETED REVENUE PRESENTED BY MAJOR CATEGORY Property Taxes Sales Taxes Taxes Other Than Property/ Sales (Franchise) Licenses & Permits Interest & Rentals Intergovernmental (VLF) Charges For Services Fines & Forfeiture Other Revenue NET PROJECTED CHANGE REVENUE $1,150,000 (890,000) o (150,000) o o 586,900 o o $696,900 The following provides additional analysis about the trends in the major categories. It is not proposed to adjust the actual revenue budgets as a result of mid-year analysis, for the items outlined above. The general budget trends are presented in order to identify any deficiencies which would require an adjustment to operating expenses in order to balance the Budget. Although based on the projections the General Fund Revenue will be approximately $696,900 more than the Budget, this represents less than a two percent (1.37 percent) deviation from the Total General Fund Budgeted Revenue of $50.9 million and six months remain in the Fiscal Year. Property Taxes (Category represents approximately 34% of budgeted General Fund Revenues) The County Auditor Controller has issued a statement to the City containing the amount of assessments placed on the Property Tax Roll for Fiscal Year 2006-2007. The projected increase is due to two factors. 1) In 2006/07 the voter approved Constitutional Amendment 1a took effect and eliminated the transfer from local property taxes to the State Education Fund (ERAF III). The original budget estimate did not account for the elimination of the transfer which was approximately $900,000 in Fiscal Year 2005/06. 2) The net assessed values levied are higher than assumed in the budget. This is expected to generate approximately $250,000 in additional property tax. Revised Estimate Property Tax Category: (+)lncrease $1,150,000 Sales Taxes (Category represents approximately 30% of budgeted General Fund Revenues) Currently, sales tax collected to date, when adjusted for timing differences, compared to the same period as last year is showing an increase of only $8,314. The amounts through December of each year (adjusted for timing) are as follows: · 2005/06 July 2005 -December 2005 Adjusted Amount = $5,042,220 (The comparison in the financial statement only shows approximately $3.7 million. However, there was $1.3 million recorded in the City financial records on January 3,2006, which actually represented remittances received in December 2005). · 2006/07 (July 2006 - December 2007) Amount = $5,050,534 2~0 ~ The retail sales tax data recorded to date only includes actual sales occurring prior to October 1, 2006 (i.e. first quarter of Fiscal Year 2006-2007) and the advances of sales taxes by the State for the period of October 2006 through December 2006. It does not include the retail holiday season reporting, which typically represents a larger percentage of sales tax revenue. This data is not typically available until the end of March. The 2006/07 Budget assumed increased sales tax revenue would occur. In addition to higher revenue from existing outlets it was also assumed that new sales tax generators would be open for part of the year. Based on the data available the City has continued to see a deterioration of new car sales in the first quarter. In addition some of the expected new establishments have been delayed in opening. Preliminary projections indicate that sales tax is estimated to be approximately $890,000 below the original budget. The projection assumes: 1) Total general retail sales remain flat. (An adjustment was made for a one-time negative adjustment last year). 2) Further deterioration of automobile dealership sales similar to the first quarter of data. 3) A delay in new outlets opening compared to when the Budget had originally projected. It is important to note that these projections are based on very limited data. Revised Estimate Sales Tax Category: (-) Decrease) $890,000 Taxes Other Than Property and Sales Tax (i.e. Franchise Tax / TOT) (Category represents approximately 5% of budgeted General Fund Revenues) It currently appears that the revenue to be received will meet the original budgeted forecast. Revised Estimate Taxes Other Than Property Category: No Change Licenses & Permits (Category represents approximately 6% of budgeted General Fund Revenues) Revenues in this category are often difficult to predict since Building Permits 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 $150,000. Factors which have contributed to this include: . Projects originally anticipated to obtain permits in Fiscal Year 2006/07 obtained permits in June 2006. . Permits for commercial projects originally projected for 2006/07 including Blake Hunt- Emerald Place; and Gateway Medical Center Garage will not be issued this fiscal year. Revised Estimate Licenses & Permits Category: (-) Decrease $ 150,000 34Cb Interest & Rentals (Category represents approximately 4% of budgeted General Fund Revenues) Interest Revenue represents 92% 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 was slightly higher in the first two quarters than assumed in the budget estimate. The analysis of interest revenue is impacted by government accounting rules which require adjustments to revenue based on the year end market value of investments held in the City portfolio. The final earnings may be affected by any significant changes that could occur in interest rates and changes in market value on the City's investments during the remainder of the Fiscal Year. In comparison to past years it is currently anticipated that the market value adjustment will be positive. Since the City does not liquidate investments prior to maturity, for this analysis Staff has not considered the impact of the market value adjustment. There are no significant trends suggesting a change in the rental revenue category at this time. Revised Estimate Interest & Rentals Category: No Change Intergovernmental Revenues (Category represents approximately 2% of budgeted General Fund Revenues) Approximately 63% of this category relates to a Workforce Housing Grant programmed for use on the Shannon Center Reconstruction project. The grant funds are received after the City begins incurring costs on the project, which will not occur prior to the final quarter of the Fiscal Year. Overall, no changes are expected in this category. Revised Estimate Intergovernmental Category: No Change Charges for Services (Category represents approximately 13% of budgeted General Fund Revenues) Overall the net change to this category is projected to result in an increase of $586,900. Planning, Zoning and Subdivision Fees are projected to be below budget by approximately $253,000. This is primarily due to a general slow down in the number of development applications. This will be more than offset, by collections of past due amounts from Alameda County related to Fire Service to the Sheriffs Department property. This had a positive impact of $719,900. Booking Fee Revenues include an increase of approximately $120,000 over the amount budgeted. This was due the State Budget including a payment, which was not expected when the City Budget was prepared. The State will not include any payments in 2007/2008. Revised Estimate Charges For Services Category: (+) Increase $586,900 Fines & Forfeitures (Category represents less than 1 % of budgeted General Fund Revenues) It currently appears that the revenue to be received from fines and forfeitures will meet the original budgeted forecast. Revised Estimate Fines & Forfeitures Category: No Change L.{ Other Revenues (Category represents approximately 4% of budgeted General Fund Revenues) Approximately 93% of the revenue in this budgeted category represents reimbursements to the General Fund associated with Capital Projects (BART Mitigation - St Patrick Way 1 Fallon Road 1 Utility Undergrounding). It is likely that revenues in this category will be below the budget estimate due to timing changes on these 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. Revised Estimate Other Revenues Category: No Change This data is provided to Council for information purposes only; Staff is not recommending any budget changes for the City's revenue appropriations at this time. REVISIONS TO EXPENDITURE ESTIMATES - GENERAL FUND Staff has reviewed expenditures through December 2006 for all accounts that affect the City's General Fund. The following discussion highlights those areas where the need for an increase in the budget appropriation is recommended at this time. The analysis assumes that all other expenditures will be in accordance with the adopted budget. Insurance (10600-717.001): + $91,000 A Budget change of $91,000 is being recommended based on billings to date from Alameda County Sherriff s Department. In addition to the cost of City contracts with Alameda County Sherriff s Department the City pays a separate billing for contributions to the County for their self insured insurance expenditures. The billings for the first two quarters are substantially more than III pnor years. Proposed Additional Insurance Expenditures: Increase $91,000 Fire (20600-740.10) Dougherty Regional Fire Authority (DRFA) Obligations: + $40,870 A Budget change of $40,870 is being recommended to allow for the elimination of the Public Employees Retirement System (PERS) side fund. The City of Dublin shares close-out expenses for DRF A with the City of San Ramon. Dublin's share of the expenses are 57.51 % and San Ramon pays 42.49%. The City of San Ramon included funding in their budget to fully eliminate the side fund obligation in the current fiscal year. The side fund obligation resulted from a change in the PERS methodology used to track Employer liabilities. The total side fund can be eliminated with a payment of $72,335 provided the payment is made by March 30, 2007. If DRFA were to pay over the six year amortization schedule the cities would pay a total of approximately $91,450 or 26% more than making a pre-payment at this time. Dublin's share over the six years would total approximately $52,600. Proposed Additional Fire Services Expenditures: Increase $40,870 s Community Facility Operations (80500) + $11,500 A Budget change of $11,500 is being recommended to fund an unanticipated electrical repair required at the Emerald Glen Activity Center. In addition this budget has experienced costs not anticipated related to vandalism repairs required to secure the Shannon Community Center as a closed facility. Proposed Additional Culture & Leisure Services Expenditures: Increase $11,500 In summary, the total recommended increases in General Fund Expenditure Appropriations are $143,370. The Operating Expenditure adjustments are less than one-half of one percent (0.32%) of the total adopted General Fund expenditures. With the preliminary projections of adjusted General Fund Revenue it is projected that the additional appropriations will not negatively impact the reserves. PROPOSED OPERATING TRANSFER - (From FEMA Disaster Fund To Gas Tax Fund) The 2006107 Budget did not anticipate any revenue in the FEMA Disaster Assistance Fund (#212). The City received reimbursements in 2005/06 based on storm events in December 2005. The amount received last year was less than the cost of storm clean-up activities. The expenses were split between Gas Tax Funds and the FEMA Disaster Assistance Fund. In 2006107 the City was notified that the allocation of Disaster Assistance funds was being increased and $1,097 in additional assistance was received. It is requested that the City Council authorize these funds to be transferred to the Gas Tax Fund, which is where the unreimbursed 2005 expenditures were originally recorded. Recommendation Staff recommends that the City Council (1) Receive the Report and Staff Presentation (2) Approve the Budget Changes (3) Approve the Operating Transfer. J W J!1l "t i I i City of Dublin 2006-2007 YTD Revenues and Budget Comparison Total General Fund Revenues c:~e ~:;;ng neCemhctiUr P 51.% roperty Taxes 41 % I Sales Taxes 45%1 Real Property Transfer Tax Transient Occupancy Taxes I I_ FY 2006/07 I L_~FY 2005/06 Franchise Taxes Licenses and Permits Interest and Rentals I Intergovernmental from State 70% Charges for Services Fines and Forfeitures Other Revenues 0% 30% 60% 90% 120% 150% 50% of Year Complete I _.~_._. ___~__~_J FY 2006/07 FY 2006/07 %of FY 2005/06 % of Total for Budget YTD Actual Budget YTD Actual FY 2005/06 Property Taxes 17,470,288 8,939,500 51% 6,948,784 41% Sales Taxes 15,283,000 6,952,455 45% 3,732,869 26% Real Property Transfer Tax 712,000 268,618 38% 334,018 48% Transient Occupancy Taxes 685,000 352,723 51% 275,150 38% Franchise Taxes 1,921,000 507,828 26% 326,838 18% Licenses and Permits 2,901,819 1,833,709 63% 1,875,266 60% Interest and Rentals 2,037,738 1,153,479 57% 480,161 31% Intergovernmental 1,083,021 144,866 13% 715,641 70% Charges for Services 6,740,407 2,936,836 44% 2,553,575 44% Fines and Forfeitures 143,560 62,547 44% 64,131 43% Other Revenues 1,952,195 225,083 12% 210,167 76% Total General Fund Revenues 50,930,028 23,377,644 46% 17,516,600 38% 3-20-07 4.'3 Date Printed: 3/13/20078:36 PM ATTACHMENT 1 ;;< v:k I w ....__.._~~-~ Total General Fund Expenses City of Dublin 2006-2007 YTD Expenses and Budget Comparison For the Period Ending December 31,2006 I I General Government 43% ~w--'c*.-'^"""~,,, i.~}:.;*Jf.::r.";!it.'~.';{~k.:.jfi}~i~.:t.11.;:\f.',.:~?(~.:~;it\*.t;.'~~1~.::j~J'.:~%.i;.'.::.:0t.:~{.:l~,,'1iF.:?-'m.'.~. 480/0 r;i~~'~,~1;fj0~;'~i1] ~",;',,,,,',,o<,,)M.i.~,,:;,;,,)-;,;';:,c:,',,,,;,,,-,,<',',;"",,-:;f>>N IC -j Police '. . ....?O% 11'i!'!i':iill~ft(t~lllttllllflf!llt{1 230/0 Fire 25% [rr;C~ ',,;;.'"'j 27% 1'11I, FY 200-cii()711 FY 2005/06 . --.I Other Public Safety Transportation i 29% I I I 36% s}~\t;!\::":~:i:.;;!;" ' '.., ,:,\ 42% I Health and Welfare ;hiWhV'\' I, ',' i!h1.~0/~) ihWh_' CUltu'"s~~::m.nity ~.Itt- ..r~5% 63% Community Development Capital Improv. Projects 42% * *"'~~ ~if""}l~*Y<'iV*",,~1ti:W."'%\1t)>"1 4401 ~'''~~46':' ';~:t:w ~ ,10 0% 20% 40% 60% 80% 100% ,..~ 120% 50% of Year Complete ------ "....._-~ 2006/07 2006/07 % of FY 2005/06 % of Total for Budget YTD Actual Budget YTD Actual FY 2005/06 General Government 5,623,678 2,428,945 43% 2,342,539 48% Police 12,171,938 2,488,568 20% 2,463,782 23% Fire 9,253,613 2,308,969 25% 2,358,377 27% Other Public Safety 463,056 83,786 18% 108,489 29% Transportation 2,057,857 747,508 36% 752,060 42% Health and Welfare 46,500 20,625 44% 15,003 63% Culture and Community Services 7,004,411 2,710,683 39% 2,700,335 45% Community Development 8,604,270 3,582,010 42% 3,462,647 44% Capital Improvement Projects 5,970,962 1,127,995 19% 1,419,449 46% Total General Fund Expenses 51,196,285 15,499,089 30% 15,622,681 36% General Fund Operating Expenses 45,225,323 14,371,094 32% 14,203,232 35% Date Printed 2/12/2007 9:50 AM ATTACHMENT 2 ?:>Vb I ~ CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF DECEMBER 2006 Prepared by The Finance Department February 12,2007 ATTACHMENT 3 if 1'-'1- ~1 ,.vb CITY OF DUBLI N BALANCE SHEET FOR THE PERIOD ENDING 31Dec2006 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR ASSETS CASH (58,935,931) 4,976,566 651, 082 42,269,530 152,103 (10,886,650) (10,592,034) CASH WITH FISCAL AGENT 167,898 167.898 178.349 AMOUNT HELD IN ESCROW 1, 762,000 1, 762,000 4,177,500 INVESTMENTS AT COST 116,281, 630 116,281, 630 104,602,683 RECEIVABLES TAXES ACCOUNTS 1,499,678 52,884 1, 552,561 491, 364 INTEREST 671,287 671 ,287 ASSESSMENTS DUE FROM OTHERS 1, 901, 086 1, 901, 086 2,206,558 INVENTORY AT COST PREPAID ITEMS 6,581 6,581 2,346 FIXED ASSETS LOANS RECEIVABLE 6,613,862 6,613,862 4,596.534 AMOUNT TO BE PROVIDED 1, 083,500 1, 083,500 1, 213,500 TOTAL ASSETS 61,424.330 5.029,450 651, 082 50.645,391 1, 403,500 119.153,753 106,876,801 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (684,711) (684,711) (726,033) DEPOSITS FOR AB1600 FEES (986493) (986,493) (763,358 ) DEPOSITS OTHERS (522.698) (522,698) (2,518,865) PAYABLES ACCOUNTS (356,785) (8,677) (365,462) (782,006 ) INTEREST PAYROLL (3130) (3.130) (615,244) DUE TO OTHERS (4,792) (7.488) (1,893,598) (1,905,877) (2.528.780) DEFERRED REVENUE (163,165 ) (2,363,862) (2,527,026) (127,768) DEBT INSTRUMENTS PAYABLE (1,201, 000) (1,201, 000) (1,331, 000) TOTAL LIABILITIES (2,721,774) (7,488) (4,266,136) (1.201, 000) (8,196,399) (9.393.054) FUND BALANCES (58.702,556) (5,021,962) (651, 082) (46.379.255) (202,500)(110.957.355) (97.483,747) TOTAL FUND E (58,702,556) (5,021,962) (651,082) (46,379.255) (202,500)(110,957,355) (97.483.747) TOTAL LIABILITIES/EQUITY (61,424,330) (5,029450) (651, 082) (50,645.391) (1,403,500)(119,153,753)(106,876,801) S 14 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Dec2006 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOT A L S SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 11,120,432 11,120.432 9.658.628 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES. TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 49,264,248 338.623.896 387.888,144 383.667.186 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 61.607.623 61.607,623 63,728.304 TOTAL ASSETS 60.384.681 338,623.896 61,607.623 460.616,200 457,054.118 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES. ACCOUNTS INTEREST PA YROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (518.366) (61.607.623) (62.125.989) (63.728,304) TOTAL LIABILITIES (518,366) (61. 607 ,623) (62.125.989) (63.728.304) FUND BALANCES (59.866.315) (338,623,896) (398.490.210)(393.325,814) TOTAL FUND E (59.866,315) (338.623.896) (398.490.210)(393.325.814) TOTAL LIABILITIES/EQUITY (60.384,68]) (338.623.896) (61.607.623) (460.616.200)(457.054.118) THE CITY OF DUBLIN STATEMENT SHOWING La ph I REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 12/31/2006 G ENE R A L REV E N U E FUN D CURRENT CURRENT PRIOR PR lOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 17,470,288.00 8,939,499.86 8,530,788.14 16,775,905.94 6,948,783.60 9,827,122.34 SALES TAX 15,283,000.00 6,952,45538 8,330.544.62 14,363,863.47 3,732,868.87 10,630.994.60 REAL PROPERTY TRANSFER TAX 712,000.00 268,618.30 443,381.70 690,404.35 334.018.49 356,385.86 HOTEL TRANSIENT OCCUPANCY TAX 685.000.00 352,722.51 332,277.49 727,611.60 275,149.97 452,46163 FRANCHISE TAXES 1921000.00 507.827.71 1413,17229 1789,355.75 326.838.02 1,462,517.73 LICENSES & PERMITS 2,90181900 1833.708.70 1068,11030 3,142,22322 1875,265.99 1.266,957,23 FINES & FORFEITURES 143,560.00 62,54748 81. 012 52 149.467,45 64,13073 85,336.72 USE/MONEY & PROP-INTEREST 1.864,164.00 1121. 88910 742.274.90 1447,812.35 441. 316.06 1. 006 ,496.29 USE/MONEY & PROP-RENTALS 173,57400 31589.85 141984.15 123,154.10 38,844.47 84,309.63 INTERGOVERNMENTAL 1083,02100 144,865.92 938,155.08 1.020,574.22 715,640.91 304.933.31 CHARGES FOR SERVICES 6,740,407.00 2 , 936 , 836 . 10 3,803.570.90 5,774,668.80 2,553,575.45 3.221.093.35 OTHER SOURCES OF REVENUE 1. 952 ,195 . 00 225,082.88 1. 727,112.12 275.245.24 210.166.77 65,078.47 TOTAL REVENUE 50,930,028.00 23,377,643.79 27,552,384.21 46,280,286.49 17,516,599.33 28,763,687.16 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 358.156.00 107,090.77 251,065.23 246,713.83 121. 354.80 125,359.03 CITY MANAGER 1. 045 , 943.00 503,246.87 542,696.13 939.434.70 452,425.48 487,009.22 CENTRAL SERVICES 453,571 00 195,525.57 258,045.43 429,560,48 207,092.92 222.467.56 CITY ATTORNEY 750,395.00 287,416.29 462,97871 623,049.58 270,138.46 352,911.12 ADMIN SERVICES 1. 708,96100 760,320,92 948,64008 1.544,223.93 743,51666 800,707.27 BUILDING MANAGEMENT 762.909.00 268,124 86 494.784.14 709,411.15 286,883.29 422,527.86 INSURANCE COST CENTER 443,659.00 299,335.26 144,323.74 353,414.23 256,176.31 97,237.92 ELECTIONS COST CENTER 21. 815.00 4.31425 17.500.75 2,244.10 1. 072. 08 1.17202 NON-DEPARTMENTAL 78.26900 3,57062 74.698.38 10,230.71 3,879.08 6,35163 ACT! V ITY TOTAL 5,623,678.00 2,428,945.41 3,194.732.59 4,858,28271 2.342,539.08 2,515,743.63 PUBLI C SAFETY POll CE 12.171 ,938.00 2.488,56801 9.683,369.99 10,519.026.18 2.463,78188 8,055,244.30 CROSSING GUARDS 88,511.00 27.525.47 60,985.53 79.55858 23,670.01 55,888.57 ANIMAL CONTROL 255,100.00 27,922.00 227,17800 225,853.07 53,428.29 172.42478 TRAFFIC SIGNALS & STREET LIGHTIN 16.315.00 8,04190 8,273.10 12,608.33 6,890.46 5,717.87 DISASTER PREPAREDNESS 103,130.00 20,297.01 82,83299 59,51344 24,499.89 35,013.55 FIRE SERVICES 9,253,61300 2.308,968.92 6,944,644.08 8,896.548.07 2,358,376.95 6,538 , 171 . 12 ACT! V ITY TOTAL 21. 888,607.00 4,881.323.31 17.007,28369 19.793,107.67 4.930.647,48 14.862,460.19 TRANS PORT A T! ON PUBLIC WORKS 975,320.00 424,967.25 550,352,75 783,632.70 366,974.87 416,657.83 STREET MAINTENANCE 33.440.00 366.31 33,073.69 30,31400 30,314.00 STREET SWEEPING 145,400.00 42,37284 103,027.16 135,923.35 45,724.29 90,199.06 STREET TREE MAINTENANCE 103.529.00 23,957.50 79,571.50 119,576.15 29,046.84 90,529.31 STREET LANDSCAPING MAINTENAN 800,168.00 255,844.35 544,323.65 709,557.73 310,314.18 399,243.55 ACT! V ITY TOTAL 2,057,857.00 747,508.25 1. 310,348,75 1. 779 , 003.93 752.060.18 1.026,943.75 HEALTH & WELFARE WASTE MANAGEMENT 18,000.00 2,124.76 15,875.24 8,829.31 2.58 8,826.73 CHILD CARE 18,50000 18.500.00 15.000.00 15,000.00 SOCIAL SERVICES 10.00000 10,000.00 HOUSING PROGRAMS THE CITY OF DUBLIN STATEMENT SHOWING I U"'b \ ~ REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 12/31/2006 G ENE R A L REV E N U E FUN D CURRENT CURRENT PR lOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ACTI V ITY TOTAL 46,500.00 20,624.76 25,875.24 23,829.31 15,002.58 8,826.73 CULTURE & LEISURE SERVICES LIBRARY SERVICES 830,642,00 203.561.11 627,080.89 618,993.45 179,956.58 439,036.87 CULTURAL ACTIVITIES 265,457.00 129,168.81 136.288.19 233,515.51 133,582.80 99,932,71 HERITAGE CENTER 180,402.00 90,320.44 90,081. 56 158,806.33 72,687.74 86,118,59 DUBLI N CEMETERY 49,060.00 15,482.95 33,577.05 36,321. 70 11 ,652.25 24,669.45 PARK MAINTENANCE 1.846.074.00 542,971.36 1. 303 . 102 . 64 1. 390 ,353.67 619,176.20 771,177 .47 COMMUN ITY TV 67,591. 00 60,351. 00 7,240.00 63,060.91 59,545.58 3,515.33 RECREATION ADMIN 740,553.00 332,744.95 407,808.05 686,496.76 328,219.74 358,277.02 PLAYGROUNDS 280.051.00 121,796.25 158,254.75 243,464.19 118,370 95 125,093.24 SHANNON CENTER 303,829.00 178,514.49 125,314.51 328.750.40 158,709.87 170,040.53 PRESCHOOL 121,504.00 46,020.78 75,483.22 108,039.36 48,836.23 59,203,13 TEENS PROGRAM 150,581.00 62,32938 88,251. 62 143,225.92 61.217.59 82,008.33 ADULT SPORTS 136.873.00 42,813.36 94,059.64 83,918.06 39,028.29 44,88977 YOUTH SPORTS 170,700 00 76.273.30 94,426.70 142,237.92 61. 943.02 80,294.90 COMMUNITY GYM 43,969.00 20,256.06 23,712.94 40,42940 19,050.40 21. 379 . 00 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 369.636.00 148,024.84 221. 611.16 377.607.25 186,869.17 190,738.08 SENIOR CENTER 485,216.00 210,782.02 274,433.98 421,034.20 195.355.42 225,678.78 RECREATION INSTRUCTION 189,417.00 87.715.27 101. 701. 73 166,976.26 75,818.87 91.157.39 AQUATICS 446,642.00 193,132.26 253,509.74 411,688.61 185,982.98 225,705.63 PARKS/FACILITIES MANAGEMENT 326,214.00 148,424.75 177,789.25 293,642.66 144,331. 74 149,310.92 ACTIVITY TOTAL 7,004.411.00 2,710,683.38 4,293,727.62 5,948,562.56 2,700,335,42 3,248,227.14 COMMUNITY DEVELOPMENT PLANNING 2,920,013.00 988,425.88 1. 931. 587 .12 2,218,620.09 1.073,143.89 1.145,476.20 BUILDING SAFETY 3,205,667.00 1. 319 , 930 , 87 1.885,736.13 2,908.309.60 1. 177 , 982 . 25 1. 730 , 327.35 ENGINEERING 2,215,848.00 1.122,701. 02 1. 093,146 98 2,380,371.77 1.025.476.81 1. 354 , 894 . 96 ECONOMIC DEVELOPMENT 262,742.00 150,95217 111,789.83 291.110.11 186,043.68 105.066.43 ACTIVITY TOTAL 8,604,270.00 3.582,009,94 5,022,260.06 7,798.411.57 3,462,646.63 4,335.764.94 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1.186,520.00 53,91474 1.132,605 26 606,778.83 102,124.28 504,654,55 COMMUNITY IMPROVEMENTS 261,044.00 19,518.79 241. 525.21 780,954.81 587,106.76 193,848,05 PARKS 3.826,163.00 685,968.07 3,140,194.93 1. 037 , 007.51 572,510.10 464,497,41 STREET CONSTRC/IMPROVEMENTS 697,235.00 368,593.35 328.641. 65 660,581.62 157,708.32 502,873.30 ACTIVITY TOTAL 5.970,96200 1.127,994.95 4,842,967.05 3,085,322.77 1.419,449.46 1.665,873.31 TOTAL EXPENDITURES 51.196,285.00 15,499.090.00 35.697,195.00 43,286,520.52 15,622,680.83 27,663,839.69 EXCESS REVENUE (EXPENDITURES) (266,257.00) 7,878,55379 (8,144.81079) 2,993,765.97 1,893.918.50 1. 099 , 847 .47 TRANSFERS IN FROM OTHER FUNDS 39,525.20 (39.525.20) 15,188,59 15,188,59 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (266,257.00) 7,918,078.99 (8.184,335.99) 3,008,954.56 1.893.918.50 1.115,036.06 THE CITY OF DUBLIN STATEMENT SHOWING 1; T)'b I 'f REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 12/31/2006 S P E C I A L REV E N U E FUN D S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 119.96000 61. 237 46 58.722.54 115.763.98 58.866.64 56.897.34 SALES TAX/OTHER TAXES 426.421.00 156.91069 269.51031 443.195 51 159.812.90 283.382.61 FINES & FORFEITURES 177.000 DO 66.29761 110.70239 190.869.24 73.826.76 117 . 042 .48 USES/MONEY & PROPERTY 120.002 DO 94.038.96 25.963.04 108.314.70 46.829.50 61. 485.20 INTERGOVERNMENTAL FROM STATE 1. 084.313 DO 724.547.54 359.765.46 1. 094.513.46 491. 802.81 602.710.65 INTERGOVERNMENTAL FROM COUNTY 370.913.00 85.808.30 285.104.70 355.919.00 79.255.00 276.664.00 INTERGOVERNMENTAL FROM FEDERAL 482.198.00 2.81317 479.384.83 122.330.00 37.404.53 84.925.47 CHARGES FOR SERVICES 1.462.058.00 735.276.64 726.781.36 1. 315.435.57 670.163.35 645.272.22 OTHER SOURCES OF REVENUE 29.000.00 29.000.00 420.867.00 390.000.00 30.867.00 TOTAL REVENUE 4.271.865.00 1. 926.930.37 2.344.934.63 4.167.208.46 2.007.961.49 2.159.246.97 *******EXPENDITURES******* PUBLIC SAFETY POLICE 103.710.00 100.370.70 3.339.30 105.670.43 101. 033.88 4.636.55 TRAFFIC SIGNALS & STREET LTG 265.922.00 99.680.93 166.241. 07 225.650.30 120.069.36 105.580.94 DISASTER PREPAREDNESS FIRE SERVICES 276.973.00 78.390.10 198.582.90 267.350.23 76.109.59 191.240.64 ACT I V ITY TOTAL 646.605.00 278.441. 73 368.163.27 598.670.96 297.212.83 301. 458.13 TRANSPORTATION: STREET MAINTENANCE 379.294.00 70.771.49 308.522.51 335.939.86 104.376.38 231.563.48 STREET LANDSCAPE MAINTENANCE 5.822.00 5.822.00 4.823.96 4.823.96 ACTI V ITY TOTAL 385.116. DO 70.771.49 314.344.51 340.763.82 104.376.38 236.387.44 HEALTH & WELFARE: WASTE MANAGEMENT 1.570.978.00 16.188.65 1.554.789.35 1. 822.693.60 451.336.81 1. 371. 356 . 79 SOCIAL SERVICES 61. 804 00 13.769.84 48.034.16 60.427.00 9.168.62 51. 258.38 HOUSING PROGRAMS ACTI V ITY TOTAL 1.632.782.00 29.958.49 1.602.823.51 1.883.120.60 460.505.43 1.422.615.17 COMMUNITY DEVELOPMENT: ENGINEERING 6.000.00 840.00 5.160.00 6.000.00 6.000.00 ACTI V ITY TOTAL 6.000.00 840.00 5.160.00 6.000.00 6.000.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS 17.581. DO 17 . 581. DO 39.556.00 29.791. 00 9.765.00 PARKS 136.587.00 75.525.71 61. 061. 29 50.349.43 50.349.43 STREET CONSTRUCTION/IMPROVEMENT 1.204.569.00 34.074.77 1.170.494.23 1.257.617.38 517.924.91 739.692.47 ACTI V ITY TOTAL 1.358.737.00 109.600.48 1. 249 .136 . 52 1.347.522.81 547.715.91 799.806.90 TOT A L EXPENDITURES 4.029.24000 489.612.19 3.539.627.81 4.176.078.19 1.415.810.55 2.760.267.64 EXCESS REVENUE (EXPENDITURES) 242.625.00 1. 437.318.18 0.194.693.18) (8.869.73) 592.150.94 (601. 020.67) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 21. 788.59 21. 788.59 REVENUES OVER (UNDER) EXPENDITURES 242.625.00 1.437.318.18 0.194.693.18) (30.658.32) 592.150.94 (622.809.26) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 12/31/2006 0trb \~ S P E C I A L ASS E SSM E N T FUN D S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 737.49400 364.945.60 372. 548.40 645.230.59 324.983.90 320.246.69 USES/MONEY & PROP-INTEREST 17.137.00 10.232.00 6.905.00 17.139.71 6.615.42 10.524.29 OTHER SOURCES OF REVENUE 9.700.00 9.700.00 5.603.48 2.578.84 3.024.64 TOTAL REVENUE 764.331. 00 375.177.60 389.153.40 667.973.78 334.178.16 333.795.62 *******EXPENDITURES******* PUBLI C SAFETY: TRAFFIC SIGNALS & STREET LIG 319,000.00 134.43830 184.561.70 262.370.43 94.208.39 168.162.04 ACTIVITY TOTAL 319,000.00 134.438.30 184.561.70 262.37043 94.208.39 168.162.04 TRANS PORT A T! ON PUBLI C WORKS 2,470.00 1.277.11 1.192.89 2.095.50 739.03 1. 356 47 STREET TREE MAINTENANCE 31.173 00 6.817.06 24.355.94 19.407.11 6.214.54 13.192.57 STREET LANDSCAPE MAINTENANCE 404.790.00 119 . 686 . 68 285.103.32 329.352.28 136.476.13 192.876.15 ACT! V ITY TOTAL 438.43300 127.780.85 310.652.15 350.854.89 143.42970 207.425.19 COMMUNITY DEVELOPMENT ENGINEERING 13.10000 358.50 12.741.50 11.357.60 11.357.60 ACT! V ITY TOTAL 13.10000 358.50 12.741. 50 11.357.60 11.35760 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 18.106.69 18.106.69 STREET CONSTRUCTION/IMPRVMNT 75,000.00 75,000.00 ACT! V ITY TOTAL 93.106.69 18,106.69 75,000.00 TOT A L EXPENDITURES 770,533.00 262,577.65 507,955.35 717.689.61 267,102.38 450,587.23 EXCESS REVENUE (EXPENDITURES) (6,20200) 112,599.95 (118,801.95) (49.715.83) 67,075.78 (116,791.61) REVENUES OVER (UNDER) EXPENDITURES (6,202.00) 112,599.95 (118,801.95) (49,715.83) 67,075.78 (116,791.61) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 12/31/2006 CAP I TAL IMP R 0 V E MEN T FUN 0 S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PR lOR Y.T.D. VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 1.444.942.00 21. 267.707.00 22.712.649.00 1.012.741.70 432.200.30 1,286.165.31 6.466.130.71 14.801.576.29 17.143.271.43 7.478.872.41 15.233.776.59 18.429.436.74 468.841. 91 9.208.026.75 9,676.868.66 817.323.40 7.935.244.68 8.752.568.08 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 39.52520 (39.525.20) 75.050.34 75.05034 CITY ATTORNEY 52.25000 34,963,91 17,286.09 56.509.63 20.562.79 35.946.84 ACTI V ITY TOTAL 52.25000 74.489.11 (22.23911) 131.559.97 20.562.79 110.997.18 PUBLl C SAFETY: TRANSPORTATION HEALTH & WELFARE: HOUSING PROGRAMS 864.07000 117.571.47 746.498.53 327.654.70 141.037.41 186.617.29 ACTI V ITY TOTAL 864.070.00 117.571.47 746.498.53 327.654.70 141. 037.41 186.617.29 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 29.12000 16.751. 50 12,36850 59.380.81 59.38081 COMMUNITY IMPROVEMENTS PARKS 1. 322 . 794.00 321. 515.64 1. 001.278.36 9.102.130.25 3.092.398.33 6.009.731.92 STREET CONSTRUCTION/IMPROVEMENT 35.842.832.00 2.857,555.69 32.985,276.31 5.109.251.49 220.819.01 4.888.432.48 ACTI V ITY TOTAL 37.194.746.00 3.195,822.83 33.998.923.17 14.270.762.55 3.313.217.34 10.957.545.21 TOT A L EXPENDITURES 38.111. 066.00 3.308.833.01 34.802.232.99 14,729.977.22 3.474 . 817 . 54 11.255,159.68 EXCESS REVENUE (EXPENDITURES) (15.398.417 00) 4,170.03940 (19.568.456.40) 3.706.059.52 6.202.051.12 (2.495.991.60) TRANSFER IN FROM OTHER FUNDS 6.600.00 6.600.00 TRANSFERS OUT TO OTHER FUNDS 39.52520 (39.52520) REVENUES OVER (UNDER) EXPENDITURES(15.398.417.00) 4.130.514.20 (19.528.931. 20) 3.706.059.52 6.202.051.12 (2.495.991.60) ----- --------- THE CITY OF DUBLIN STATEMENT SHOWING \ltrbl~ REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 12/31/2006 T R U S T / AGE N C Y FUN D CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR YT.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 108,515.05 (108,515 05) 242,044.14 117 ,292.54 124,751.60 USES/MONEY & PROP-INTEREST 5,966.03 (5,966.03) 9,505.83 3,402.26 6,103.57 TOTAL REVENUE 114,481. 08 (114,481.08) 251,549.97 120,694.80 130.855.17 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 230,503.00 187,007.50 43,495.50 231,731.25 183,498.75 48,232.50 ACTI V ITY TOTAL 230,503.00 187,007.50 43.495.50 231,731,25 183,498.75 48,232.50 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 230.503.00 187,007.50 43,495.50 231,731.25 183.498.75 48,232.50 EXCESS REVENUE (EXPENDITURES) (230.503.00) (72.52642) (157,976 58) 19,818.72 (62,803,95) 82,622.67 REVENUES OVER (UNDER) EXPENDITURES (230,50300) ( 72 , 526 42) (157,976.58) 19,818.72 (62,803.95) 82,622.67 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 12/31/2006 1'1 N T ERN A L S E R V ICE FUN 0 S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 407,294.00 216,458.88 190.835.12 267,035.82 113,324.31 153,711.51 CHARGES FOR SERVICES 1. 784,731. 00 892.703.70 892,027.30 1. 790,982.80 893,723.71 897,259.09 OTHER SOURCES OF REVENUE 19,80000 8,434.20 11,365.80 939,048.36 14,525.00 924,52336 TOTAL REVENUE 2,211,825 00 1.117,596.78 1. 094 , 228 . 22 2,997,066.98 1. 021. 573 02 1. 975 ,493.96 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2,043.020.00 271,535.05 1.771.484 95 2.908,427.37 291,706.80 2,616,720.57 ACTIVITY TOTAL 2,043,020.00 271.535.05 1,771,484.95 2,908.42737 291. 706.80 2.616,720.57 PUBLIC SAFETY. FIRE ACTI VITY TOTAL TRANSPORTATION HEALTH & WELFARE. CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT. CAPITAL IMPROVEMENT PROJECTS. TOT A L EXPENDITURES 2,043,020.00 271,535.05 1 ,771 ,484.95 2.908.427.37 291,706.80 2,616,720.57 EXCESS REVENUE (EXPENDITURES) 168,805.00 846,061.73 (677,256.73) 88,639,61 729,866.22 (641. 226.61) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES 168,805.00 846, 061 .73 (677,256.73) 88,639.61 729,866.22 (641. 226.61) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 12/31/2006 E N T E R P R I S E FUN D CURRENT BUDGET PRIOR FISCAL YEAR CURRENT ACTUAL VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 20.00 20.00 FINANCE ACTI V ITY TOTAL 20.00 20.00 PUBLI C SAFETY HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 20.00 20.00 EXCESS REVENUE (EXPENDITURES) (20.00) (20.00) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (20.00) (20.00) PRIOR YT.D. 13 VARIANCE CITY OF DUBLIN BUDGET CHANGE FORM I / I i 1..,..1 . 'iO'b 1. CHANGE FORM # New Appropriations (City Council Approval Required): Budget Transfers: _K_ From Unappropriated Reserves From New Revenues From Budgeted Contingent Reserve (1080-799.000) Within Same Department Activity Between Departments (City Council Approval Required) Other ....... .......... ..... I. Name: Name: General Fund - Insurance - County Contract $91,000 Account #: Account#: 001.10600.717.001 Name: Name: General Fund - Fire Services - DRF A Obligations $40,870 Account #: Account #: 001.20600.740.010 Name: Name: General Fund - Community Facility Operations - Contract Services $11,500 Account #: Account #: 001.80500.740.000 Name: Name:OPERA TING TRANSFER OUT Disaster Assistance Fund $ 1,097 Account #: Account #: 212.599.000 Name: Name: OPERATING TRANSFER IN Gas Tax Fund $ 1,097 Account #: Account #: 206.10000.799.099 City Manager: Date: ASD/Fin Mgr ~~ ~rure Signature Date: 3If/U:c:t' REASON FOR BUDGET CHANGE ENTRY: Budget Changes designated in Mid Year Report for Fiscal Year 2006 1 2007 as presented to the City Council March 20, 2007. Mayor: Date: 3/20/2007 Signature Posted By: Date: Signature G:\FINANCE\Mid Year ReportslFY lOaO-OIIFORM-budget changeA4lDyr.doc Attachment 4