The URL can be used to link to this page

Home My WebLink AboutItem 4.11 Financial Report May 08 CITY CLERK File # D[2]~[Q]-[5]~ AGENDA STATEMENT CITY COUNCIL MEETING DATE: July 15, 2008 SUBJECT: Financial Reports for the Month of May 2008 Report Prepared by: Paul S. Rankin. Administrative Services Director and Vivian Gong, Finance Manager ATTACHMENTS: Period Ending May 31,2008 a. YTD (Year To Date) Revenues and Budget Comparison b. YTD Expenditures and Budget Comparison c. May 31,2008 Financial Statements RECOMMENDATION: ~ FINANCIAL STATEMENT: Receive the reports. See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the month of May 2008. Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Analvsis of Mav 2008 Revenue and Expenditure Reports The May report represents the reporting of revenues and expenditures for the eleventh month (91 %) of the Fiscal Year (July 1, 2007 through May 31, 2008). 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. General Fund Revenues The total percentage of General Fund Revenues collected through May 2008 was slightly lower compared to what occurred through the same period of the previous Fiscal Year. Through May 2008, the City had collected approximately 86% of the total budgeted General Fund Revenues, which was 1 % less than the percentage collected in the same period of the prior Fiscal Year. Major decreases in revenue categories compared to last year receipts were Licenses I Pennits and Charge for Services which include building pennits, zoning and subdivision fees, engineering, fire and plan checking fees and were partially offset by the increase in property tax revenue. It should be note that pennit revenues are tracking to the cunent budget. Collections thm May 2008 were at 99% of the revised budget. As explained in previous monthly reports, the deviation in Sales Tax revenue is substantially attributable to the reporting changes to accommodate audit requirements. lfthe sales tax collections were reported on the same basis in both 2007 and 2008 the revenue collections to date would show a slight negative variance of $67,761. The following section of the repoli highlights significant deviations in tem1S of dollars collected in several categories, compared to the same reporting period in the prior year. ------------------------------------------------------------------------------------------------------------- COPIES TO: Page 10f3 G:\;\lonthlv Financials\FY 07-08\Mav 2008.doc ITEM NO. if./I or Amounts o lected Jul' - May 2008 vs. July - May 2007 GENERAL FUND YTD YTD DIFFERENCE REVENUE May 2008 May 2007 FY 07/08 More / EXPLANATION (Less) FY 06-07 Property Tax 20,250,217 18,501,619 1,748,598 The increase is due to the general increase in the assessed valuation of property on the tax roll and an increase in the assessment of penalty for late payment of $75,000. Sales Tax 11,553,484 12,993,154 (1,439,670) As noted above, the difference is distorted due to a change in the accounting for year end payments. If the May 2007 amount was presented on the same basis as the cunent year, the amount for 2007 would have been $ 11,621,245. This would result in a negative variance of $67,761. Real Property 363,471 426,145 (62,674) Fewer real estate transactions occurred Transfer Tax in the current fiscal year. Franchise Tax 1,847,654 1,712,614 135,040 Cable TV and waste franchise taxes are above level collected in 2007 due to the increases in number of subscribers as well as increased rates. Licenses and 1,559,936 2,372,676 (812,740) Consistent with previous reports, the Permits deviation reflects the decline in building permit activity. Interest and 2,390,147 2,185,831 204,316 The difference is attributed to: 1) the Rentals increase in rentals of City facilities ($63,600) 2) the collection of monthly tenant rents in connection with the purchase of the Dublin Square property ($88,100) 3) increase of investment eamings ($52,600). Intergovernunental 701,187 250,777 450,410 A major factor in the difference is due to one- time revenues such as 2007/08 Workforce Housing reimbursement grant funds of approximately $409,000. There is also a timing difference in receipt of $88,000 for the Home Owner Property Tax Relief. The positive variances were offset by a reduction in Vehicle License Fee receipts, which were $72,000 less. Summary of Significant General Fund Revenue Differences F CI Page 2 of3 GENERAL FUND YTD YTD DIFFERENCE REVENUE May 2008 May 2007 FY 07/08 More 1 EXPLANATION (Less) FY 06-07 Charges for 5,623,581 7,027,716 (1,404,135) Significant decreases due to: Services 1) Decreased development activity in: Zoning and Subdivision Fees; Engineering 1 Plan Check and Inspection Fees; and Fire Plan Check Fees. 2) The amount received in FY 2006/07 for Santa Rita Fire Services was larger than normal since it included payments for prior fiscal years. 3) Booking Fee revenue decreased by approximately $132,000, due to a change in State Law. Other Revenues 675,229 901,046 (225,817) This category of revenue typically includes payments such as contributions, donations, or one time reimbursements that may not occur consistently from year to year. General Fund Expenditures Overall, through the month of May expenditures in the General Fund totaled approximately $37 million and represented approximately 67% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $4.5 million was related to Capital Improvement Projects and the remainder was related to Operating Costs. Capital Project expenditures typically do not follow an even distribution due to differences in project timing. A closer examination of only General Fund Operating Expenditures indicates that the activity through May 2008 for all Program Areas was approximately $3.7M (or 4%) higher than the amount expended for the same period in the prior Fiscal Year. The variance is partially due to a timing difference in the quarter 3 payment to Alameda County fire services of approximately $2.1 M. In the prior year this payment did not occur until June. Although there are both positive and negative variances, Program Areas where expenditures for the period July - May were higher than in the previous Fiscal Year include: contract Police Services and Fire services; Park Maintenance (addition of the Dougherty Hills Dog Park; Sports field renovations; and increased utilities); additional support to Community Television; Recreation Special Events (expanded Day on the Glen Event for 25th Anniversary); and Heritage Center improvements and increased Stafftime to support additional programs. All expenditures are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the Califomia Govemment Code. Page 3 of3 13 ---~-~___~_m.____..._____)_ ?t-. City of Dublin 2007-2008 YTD Revenues and Budget Comparison TForthePeriodEnding .. May 31 ,2008 Total General Fund Revenues 1.}III.i_l~lljjjjl,jjll~iljl:jllljjllii,lil,I~~~ Property Taxes 91% 92% Sales Taxes ~.}}_fi:lj!}}il11!~jj}iii,\I~*(tlillj.t.lji~i~93 % + Real Property Transfer Tax ~\lI.}II}I,I.llt_jlllllljlllll'l~jll'lli~r% ] + Transient Occupancy Taxes Franchise Taxes . FY 2007/08 FY 2006/07 . 'I"]ifi~:J!<'\":'< . 81 ~8 ,"Jf. r_M! LI Yo % Licenses and Permits l'jliIIJiill}!I~~~I!llllljlljjll:ljii!i.ll.liil"flljji111111:192 ~~O % T Interest and Rentals ~)II~ll)jllrflJlllli.1JII'IIIII]lllllljljll: 58% 100% +- Intergovernmental from State 11_ 2~% 67% -r Charges for Services Jlllil1fIIJJI1!llllfllli11111Ij'Jli:1Imjii1111*IIIJ isO~o Fines and Forfeitures Other Revenues 0% 94% 30% 60% 90% 120% 150% 92% of Year Complete FY 2007/08 % of FY 2006/07 % of Total for YTO Actual Budget YTO Actual FY 2006/07 20,250,217 91% 18,501,619 92% 11,553,484 80% 12,993,154 93% 363,471 67% 426,145 71% 670,675 87% 656,295 82% 1,847,654 88% 1,712,614 81% 1,559,936 100% 2,372,676 92% 2,390,147 100% 2,185,831 58% 701,187 67% 250,777 22% 5,623,581 90% 7,027,716 88% 134,627 94% 106,110 76% 675,229 41% 901,046 97% 45,770,209 86% 47,133,983 87% :r+e~4'1J 1/ Lr/O<f ATTACHMENT 1 Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Fines and Forfeitures Other Revenues FY 2007/08 Budget 22,194,200 14,390,000 540,000 775,000 2,095,635 1,564,645 2,387,671 1,049,669 6,262,056 143,000 1,651,012 Total General Fund Revenues 53,052,888 Date Printed: 6/24/2008 906 AM ;;? ~~-~- City of Dublin 2007-2008 YTD Expenses and Budget Comparison For the Period Ending May 31, 2008 Total General Fund Expenses ll!fifi:ii~jillli!li~!,I'il~'llllillllljjl~'lil;i_.lli.111111...... ~~~ 1'11Iillll'll'1'illl!I.t._lllliilllll'illlli1l1IJIII'11'111 .i JW@Mi.!tJIi!' Police IIIj'llli1lIi..I.,llil.!II.III'Jillllll'....!Jlt. Jtl 51 ~1% 77% '11@; 82% General Government Fire 111111B'41tI1liI1lfililflilil'.'!illliJililll'lllll ,i.!l 50% 75% . FY 2007/08 FY 2006/07 Other Public Safety ~tl:!iIJi ffi"lllllllillllllill_Jlillllil~I~7% Trans po rta tio n J!IW'I... ........... >i....II.....(..'..I..I..'.~.t.I.Iii.IF.F.....t.?I.i.11ii.1.I.f.,.I.II.J.I'.II.I,.I.I.I.I,.,.',II.!.I.',11',1.,"",1.1',....,.,.....,.>.".1.1.1."';;' N. ..I.'...i.I.,..,...........i.I.IU.,i.i,..,.i,_,,,,.ii!!l%,..1iI.,f.P.I.';].i.!.I..'..I..'.I..I..'..I.....'..'.....'.....'..'..'..'..1..1..1.....'..'..1.. 1.'.1.,'.1.1.,..,.,....,..,.,.,..,...,..,.,1.'.,..1,..,..,.,..,.i'.'....~...I.I.'.I.R."..O...i.V<<.',>.i.i..,1,1.0780/0 li{\':\1tf0t~~l':ti~;~~!;.,;;";:;::,';:::;::::::::::::::::~::::::::::::::::::::::~~::"::::::::;:::~~'"JWL,@~*gdW@~:::;::;:~::m:;:':!::,;;<';\:~;;;;:);.;:>:;.;,:::~' ' " ',',/ ,:"" ,:,,' " ." I( Health and Welfare lilf' ilill'II'1I1.1.l111,111...".51% Culture & ~ommunity 1111111i!'liIIIHmmw......." ,,:w....lJINiilll*_Jl\Ii' :.~:lIi0Jlq,.ji'l" .......%\,vY!i!ipwiI.l.l7788:{0 ServIces .".""."........"..................,........".....1""....,""""""@""'..".."....,......:,,..."", wm",,,,,,,,dlMi#l ."iwmwh,,,E,,,m.,,, 10 88% Community U ,ii' fJR(.Jiii!!l%" il:{~}' " ,":4.jWrM!Jf'i,',....,.ii'~4i'JW5'1iY!?0/0 8601 Dev e lop men t !{Jy~~jl~~; ;l,:'~,+,':"y~~iJ::~:(n:;III\+Hm~~;1!:~:ti(:@~k '., '_~ _~ .c. - -~-'-:tBtiMfbtllif?;JTh{fH0&:;,;tMW.;;fM01w;m%:?{@u}@Xt- 10 Capital Improv. Projects )Ic'.. ~ : ~\t\TJ{~:~:~~: ;I:,,{ izY1;'JlJ';~:u:j.!=~Ye;Mi;:~:~;~\ 71 % 0% 20% 40% 60% 80% 100% 120% 92% of Year Complete -'_.._----~-_.~------ 2007/08 2007/08 % of FY 2006/07 % of Total for Budget YTO Actual Budget YTO Actual FY 2006/07 General Government 5,844,224 4,499,453 77% 4,490,097 82% Police 12,558,821 6,863,629 55% 5,924,462 51% Fire 9,468,930 7,059,390 75% 4,634,963 50% Other Public Safety 563,028 287,236 51% 245,963 57% Transportation 2,239,419 1,580,125 71% 1,567,203 78% Health and Welfare 52,004 45,800 88% 20,720 51% Culture and Community Services 7,529,844 5,878,749 78% 5,336,505 78% Community Development 8,218,211 6,317,990 77% 6,590,167 86% Capital Improvement Projects 9,011,577 4,509,561 50% 2,397,306 71% Total General Fund Expenses 55,486,058 37,041,933 67% 31,207,385 67% General Fund Operating Expenses 46,474,481 32,532,372 70% 28,810,079 66% Dille Printed 6/24120089:13 AM ATTACHMENT 2 3~J3 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF MAY 2008 Prepared by The Finance Department June 24, 2008 ATTACHMENT 3 if o;f 13 CITY OF DUBLI N BALANCE SHEET FOR THE PERIOD ENDING 31May2008 GENERAL SPECIAL SPECIAL CAP IT AL TRUST/ TOT A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR ASSETS CASH (60.845.295) 4.890.830 744.717 48.477.136 322.183 (6.410.429) (11.421.553) CASH WITH FISCAL AGENT 177.719 177.719 169.862 AMOUNT HELD IN ESCROW 12.458 12.458 1. 556 . 500 INVESTMENTS AT COST 124.919.772 124.919.772 117.599.499 RECEIVABLES: TAXES ACCOUNTS 106.525 106.525 1. 552 . 561 INTEREST 666.589 666.589 671.287 ASSESSMENTS DUE FROM OTHERS 5.078.847 5.078.847 1. 901. 086 INVENTORY AT COST PREPAID ITEMS 9.101 9.101 7.695 FIXED ASSETS LOANS RECEIVABLE 5.117.250 5.117 .250 6.750.316 AMOUNT TO BE PROVIDED 943.500 943.500 1.083.500 TOTAL ASSETS 69.935.540 4.890.830 744.717 54.212.754 1. 443 . 402 131.227.243 119.870.753 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (830.396) 06.860) (847.255) (756.093) DEPOSITS FOR AB1600 FEES (2.429) 0.138.242) 0.140.671) 0.017.750) DEPOSITS OTHERS (664.055) (447.060) 0.111.115) (574.042) PAYABLES: ACCOUNTS (406.983) (387.114) 051. 000) (945.097) (376.972) INTEREST PAYROLL (6.477) (6.477) (2.835) DUE TO OTHERS (690.618) 0.791. 762) (2.482.380) 0.965.713) DEFERRED REVENUE (253.671 ) (5.723.160) (5.976.832) (2.505.153) DEBT INSTRUMENTS PAYABLE 0.061. 000) 0.061. 000) 0.201. 000) TOTAL LIABILITIES (2.854.628) (9.504.199) (1.212.000) (13.570.827) (8.399.558) FUND BALANCES (67.080.912) (4.890.830) (744 . 717) (44.708.555) (231.402)(117.656.416) (97.418.816) TOTAL FUND f (67.080.912) (4.890.830) (744 . 717) (44.708.555) (231.402)(117.656.416) (97.418.816) TOTAL LIABILITIES/EQUITY (69.935.540) (4.890.830) (744 . 717) (54.212.754) (1.443.402)(131.227.243)(105.818.374) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2008 G~113 INTERNAL SERVICE FUNDS ENTERPRISE FIXED ASSETS GENERAL LONG FUND GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP TOT A L S -.-MEMORANDUM--- CURRENT PRIOR ASSETS CASH 7.152.563 7.152.563 11.776.989 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS 56.847 56.847 INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 3.966 FIXED ASSETS 48.289.121 351.342.286 399.631.407 387.888.144 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 62.053.336 62.053.336 62.216.048 TOTAL ASSETS 55.498.531 351.342.286 62.053.336 468.894.153 461.885.147 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 (78.645) TOTAL LIABILITIES (78.645) FUND BALANCES (55.419.885) TOTAL FUND E (55.419.885) (62.053.336) (62.053.336) (62.131.982) (62.734.414) (62.131.982) (62.734.414) (406.762.171)(397.644.149) (406.762.171)(397.644.149) (351. 342.286) (351. 342.286) TOTAL LIABILITIES/EQUITY (55.498.531) (351.342.286) (62.053.336) (468.894.153)(460.378.562) 6~ /3 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 05/31/2008 G ENE R A L REV E N U E FUN 0 CURRENT CURRENT PR lOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 22.194.200.00 20.250.217.35 1. 943 . 982 . 65 20.146.742.78 18.501.618.60 1.645.124.18 SALES TAX 14.390.000.00 11.553.483.50 2.836.516.50 14.025.868.73 12.993.154.13 1.032.714.60 REAL PROPERTY TRANSFER TAX 540.000.00 363.471.30 176.528.70 596.532.87 426.145.06 170.387.81 HOTEL TRANSIENT OCCUPANCY TAX 775.000.00 670.674.63 104.325.37 800.772.57 656.294.91 144.477.66 FRANCHISE TAXES 2.095.635.00 1.847.653.87 247.981.13 2.111. 281. 26 1.712.613.80 398.667.46 LICENSES & PERMITS 1. 564 . 645. 00 1. 559 . 936 . 33 4.708.67 2.572.067.54 2.372.676.11 199.391. 43 FINES & FORFEITURES 143.000.00 134.626.90 8.373.10 140.234.79 106.110.40 34.124.39 USE/MONEY & PROP-INTEREST 2.096.744.00 2.113.649.46 (16.905.46) 3.575.137.21 2.061.003.89 1.514.133.32 USE/MONEY & PROP-RENTALS 290.927.00 276.497.99 14.429.01 203.240.52 124.827.20 78.413.32 INTERGOVERNMENTAL 1.049.669.00 701.186.83 348.482.17 1.149.759.30 250.776.56 898.982.74 CHARGES FOR SERVICES 6.262.056.00 5.623.581. 28 638.474.72 8.015.064.77 7.027.716.19 987.348.58 OTHER SOURCES OF REVENUE 1.651.012.00 675.229.10 975.782.90 928.704.12 901. 046.36 27.657.76 TOTAL REVENUE 53.052.888.00 45.770.208.54 7.282.679.46 54.265.406.46 47.133.983.21 7.131.423.25 *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 304.891.00 244.379.71 60.511.29 320.924.20 283.338.59 37.585.61 CITY MANAGER 1.128.643.00 950.435.77 178.207.23 1.042.480.01 916.080.83 126.399.18 CENTRAL SERVICES 573.400.00 413.500.03 159.899.97 438.786.38 352.413.81 86.372.57 CITY ATTORNEY 615.723.00 503.158 56 112.564.44 867.874.77 657.230.50 210.644.27 ADMIN SERVICES 1.844.459.00 1.421.633.13 422.825.87 1. 593 . 027 .81 1. 346 . 526 . 68 246.501.13 BUILDING MANAGEMENT 796.873.00 546.654.86 250.218.14 707.316.31 544 . 77 0 . 63 162.545.68 INSURANCE COST CENTER 538.541. 00 401.417.89 137.123.11 474.542.39 356.367.90 118.174.49 ELECTIONS COST CENTER 2.500.00 977.39 1.522.61 25.554.79 25.554.79 NON-DEPARTMENTAL 39.194.00 17.295.36 21. 898.64 9.858.11 7.812.90 2.045.21 ACTI V ITY TOTAL 5.844.224.00 4.499.452.70 1. 344.771. 30 5.480.364.77 4.490.096.63 990.268.14 PUBLIC SAFETY POll CE 12.558.821. 00 6.863.628.88 5.695.192.12 11.662.394.30 5.924.461.89 5.737.932.41 CROSSING GUARDS 98.648.00 78.883.20 19.764.80 86.639.21 65.295.00 21. 344.21 ANIMAL CONTROL 351.192.00 138.138.90 213.053.10 251.956.53 116.402.22 135.554.31 TRAFFIC SIGNALS & STREET LIGHTIN 13.300.00 8.943.57 4.356.43 15.424.08 12.920.70 2.503.38 DISASTER PREPAREDNESS 99.888.00 61.270.76 38.617.24 79.826.64 51. 345.20 28.481. 44 FIRE SERVICES 9.468.930.00 7.059.389.67 2.409.540.33 9.178.765.31 4.634.962.74 4.543.802.57 ACTIVITY TOTAL 22.590.779.00 14.210.254.98 8.380.524.02 21. 275.006.07 10.805.387.75 10.469.618.32 TRANSPORT A TI ON PUBLI C WORKS 1.094.762.00 846.642.36 248.119.64 907.511.91 774.645.64 132.866.27 STREET MAINTENANCE 33.147.00 397.40 32.749.60 13.221. 64 7.467.59 5.754.05 STREET SWEEPING 138.000.00 102.755.46 35.244.54 139.992.31 106.050.29 33.94202 STREET TREE MAINTENANCE 106.917.00 38.25999 68.657.01 131.391.84 41. 205.86 90.185.98 STREET LANDSCAPING MAINTENAN 866.593.00 592.07024 274.522.76 811.550.20 637.833.81 173.716.39 ACTIVITY TOTAL 2.239.419.00 1. 580 .125.45 659.293.55 2.003.667.90 1.567.203.19 436.464. 71 HEALTH & WELFARE WASTE MANAGEMENT 8.091. 00 7.390.58 700.42 22.055.21 2.219.78 19.835.43 1~, ) '2, <..-./ THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 05/31/2008 G ENE R A L REV E N U E FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE CHILD CARE 18.500.00 16.414.69 2.08531 18.500.00 18.500.00 SOCIAL SERVICES 25.413.00 21. 994 . 94 3.418.06 HOUSING PROGRAMS ACT! V ITY TOTAL 52.004.00 45.800.21 6.203.79 40.555.21 20.719.78 19.835.43 CULTURE & LEISURE SERVICES LIBRARY SERVICES 836.571. 00 600.927.43 235.643.57 809.628.89 602.965.64 206.663.25 CULTURAL ACTIVITIES 239.530.00 199.410.62 40.119.38 251. 944.51 192.797.53 59.146.98 HERITAGE CENTER 238.752.00 198.472.57 40.279.43 181.827.65 157.098.55 24.729.10 DUBLI N CEMETERY 48.458.00 25.681. 05 22.776.95 43.94265 26.122.78 17.819.87 PARK MAINTENANCE 2.016.692.00 1.374.535.05 642.156.95 1. 808.688.78 1.135.897.31 672.791.47 COMMUNITY TV 127.980.00 116.258.36 11.721. 64 128.881.00 125.921.00 2.960.00 RECREATION ADMIN 759.339.00 649.253.65 110.085.35 702.189.94 613.036.14 89.153.80 PLAYGROUNDS 320.073.00 244.372.53 75.700.47 260.228.97 214.807.19 45.421. 78 SHANNON CENTER 286.982.00 245.988.70 40.993.30 342.407.56 298.134.43 44.273.13 PRESCHOOL 115.643.00 99.550.75 16.09225 105.844.87 89.445.31 16.399.56 TEENS PROGRAM 146.164.00 107.666.49 38.497.51 135.910.40 113.615.59 22.294.81 ADULT SPORTS 183.056.00 137.536.42 45.519.58 106.532.29 88.874.13 17.658.16 YOUTH SPORTS 204.177 . 00 191.872.12 12.304.88 174.520.06 160.171.23 14.348.83 COMMUNITY GYM 46.187.00 37.141.13 9.045.87 44.662.71 33.981. 33 10.681. 38 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 403.471.00 384.815.03 18.655.97 354.952.30 324.890.37 30.061. 93 SENIOR CENTER 549.653.00 462.941. 68 86.711.32 472.926.09 405.483.69 67.442.40 RECREATION INSTRUCTION 209.545.00 166.297.24 43.247.76 198.529.01 163.771.60 34.757.41 AQUA T! CS 467.488.00 353.365.09 114.122.91 445.981.03 322.367.96 123.613.07 PARKS/FACILITIES MANAGEMENT 330.083.00 282.662.91 47.420.09 304.996.60 267.123.14 37.873.46 ACT! V ITY TOTAL 7.529.844.00 5.878.748.82 1. 651. 095 .18 6.874.595.31 5.336.504.92 1. 538. 090 . 39 COMMUNITY DEVELOPMENT PLANNING 2.893.306.00 2.110.279.98 783.026.02 2.152.189.29 1. 851.189 .12 301. 000 .17 BUILDING SAFETY 2.708.274.00 2.181. 726.93 526.547.07 2.886.668.83 2.436.259.81 450.409.02 ENGINEERING 2.321. 911. 00 1. 828.690.31 493.220.69 2.407.540.23 2.073.853.39 333.686.84 ECONOMIC DEVELOPMENT 294,720.00 197.292.61 97.427 . 39 252.495.57 228.864.49 23.631. 08 ACT! V ITY TOTAL 8.218.211.00 6.317.989.83 1. 900.221.17 7.698.893.92 6.590.166.81 1.108.727.11 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1. 561. 994.00 290.278.18 1.271.715.82 377.025.76 269.050.56 107.975.20 COMMUNITY IMPROVEMENTS 328.57800 150.622.07 177.955.93 95,671.93 35.726.22 59.94571 PARKS 5.976.648.00 3.893.356.37 2.083.291.63 2.619.196.45 1. 786 . 259 . 03 832.937.42 STREET CONSTRC/IMPROVEMENTS 1.144.357.00 175.30433 969.052.67 308.244.43 306.269.88 1. 974.55 ACT! V ITY TOTAL 9.011.577.00 4.509.560.95 4.502.016.05 3.400.138.57 2.397.305.69 1,002.832.88 TOTAL EXPENDITURES 55.486.05800 37.041.932.94 18.444.125.06 46.773.221. 75 31.207,384.77 15.565.836.98 EXCESS REVENUE (EXPENDITURES) (2.433.170.00) 8.728.275.60 (11,161.445.60) 7.492.184.71 15.926.598.44 (8.434.413 73) TRANSFERS IN FROM OTHER FUNDS 52.883.57 (52.883.57) 59.196.81 39.525.20 19.671.61 TRANSFERS OUT FROM OTHER FUNDS (23.505.65) (23.505.65) REVENUES OVER(UNDER) EXPENDITURES . (2. 433 . 170 00 ) 8.781.159.17 (11.214.329.17) 7.527.875.87 15.942.617.99 (8,414.742.12) THE CITY OF DUBLIN STATEMENT SHOWING 8~, )~j REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 05/31/2008 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 125.760.00 119.716.70 6.043.30 119.472.73 110.168.80 9.303.93 SALES TAX/OTHER TAXES 460.862.00 342.866.69 117.995.31 433.043.17 323.489.54 109.553.63 FINES & FORFEITURES 195.000.00 167.201.26 27 .798.74 201.862.59 171.565.80 30.296.79 USES/MONEY & PROPERTY 216.249.00 173.469.07 42.779.93 194.816.32 162.115.69 32.700.63 INTERGOVERNMENTAL FROM STATE 1. 972.487.00 1. 440 . 098.80 532.388.20 1.174.710.84 1. 039 . 611. 63 135.099.21 INTERGOVERNMENTAL FROM COUNTY 397.023.00 235.563.55 161.459.45 376.594.90 246.832.60 129.762.30 INTERGOVERNMENTAL FROM FEDERAL 459.471.00 215.800.17 243.670.83 144.868.47 38.547.83 106.320.64 CHARGES FOR SERVICES 1.513.762.00 1. 405.278.20 108.483.80 1. 430.805.72 1.349.179.08 81.626.64 OTHER SOURCES OF REVENUE 9.000.00 9.205.00 (205.00) 25.467.40 25.467.40 TOTAL REVENUE 5.349.614.00 4.109.199.44 1.240.414.56 4.101.642.14 3.466.978.37 634.663.77 *******EXPENDITURES******* PUBLIC SAFETY: POll CE 104.810.00 102.640.36 2.169.64 101. 780.53 100.420.70 1.359.83 TRAFFIC SIGNALS & STREET LTG 279.525.00 191. 040 97 88.484. 03 249.275.06 201. 408.84 47.866.22 DISASTER PREPAREDNESS FIRE SERVICES 287.483.00 220.016.18 67.466.82 196.755.84 181. 355.86 ]5.399.98 ACT! V!TY TOTAL 671. 818.00 513.697.51 158.120.49 547.811.43 483.185.40 64.626.03 TRANSPORT A T! ON: STREET MAINTENANCE 398.986.00 173.862.59 225.123.41 305,088.60 179.829.79 125.258.81 STREET LANDSCAPE MAINTENANCE 6.038.00 6.038.00 7.563.43 7.563.43 ACT! V!TY TOTAL 405.024.00 173.862.59 231.161. 41 312.652.03 187.393.22 125.258.81 HEALTH & WELFARE: WASTE MANAGEMENT 1.663.490.00 1. 582 . 465 . 90 81. 024 .10 1. 525 . 606.71 1.497.566.09 28.040.62 SOCIAL SERVICES 52.945.00 44.316.16 8.628.84 60.035.35 43,491.36 16.543.99 HOUSING PROGRAMS ACT! V!TY TOTAL 1. 716.435.00 1.626.782.06 89.652.94 1. 585 .642.06 1.541.057.45 44.584.61 COMMUNITY OEVELOPMENT: ENGINEERING 6.000.00 2.472. 00 3.52800 6.000.00 6.000.00 ACT! V!TY TOTAL 6.000.00 2.472.00 3.528.00 6.000.00 6.000.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 10.853.00 10.853.00 COMMUNITY PROJECTS 17.580.62 17.580.62 PARKS 109.822.00 321.34 109.500.65 132.238.71 75.525.71 56./13.00 STREET CONSTRUCT! ONIIMPROVEMENT 2.788.562.00 1.180.254.97 1.608.307.03 726,185.12 84.521.81 641.66331 ACT! V!TY TOTAL 2.909.237.00 1.180.576 31 1.728.660.69 876.004.45 160.047.52 715.956 93 TOT A L EXPENDITURES 5.708.514.00 3,497.390.47 2.211.123.53 3.328.109.97 2.377.683.59 950.426.38 EXCESS REVENUE (EXPENDITURES) (358.900.00) 611.808.97 (970.708.97) 773.532.17 1. 089 . 294.78 (315.762 61) TRANSFER IN FROM OTHER FUNDS (l .097 . 00) (1. 097 . 00) TRANSFERS OUT TO OTHER FUNDS 52.88357 (52.883S7) Z7 .368.61 1. 097.00 26.27161 REVENUES OVER (UNDER) EXPENDITURES (358.90000) 558.925 40 (917.825.40) 747.260.56 1. 089 . 294 .78 (342.034.22) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 05/31/2008 (1 ~ /3 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 785.567.00 720.660.31 64.906.69 716.143.96 645.143.96 71.000.00 USES/MONEY & PROP-INTEREST 26.106.00 21. 558.71 4.547.29 26.363.45 19.562.82 6.800.53 OTHER SOURCES OF REVENUE 5.000.00 578.00 4.422.00 3.219.91 3.219.91 TOTAL REVENUE 816.673.00 742.797.02 73.875.98 745.727.32 667.926.69 77.800.63 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 376.400.00 250.935.89 125.464.11 325.491.81 268.088.28 57.403.53 ACTI V ITY TOTAL 376.400.00 250.935.89 125.464.11 325.491. 81 268.088.28 57.403.53 TRANSPORT A TI ON PUBLIC WORKS 100.00 100.00 1. 640 . 07 1.640.07 STREET TREE MAINTENANCE 65.910.00 44.274.32 21. 635.68 39.305.46 10.485.57 28.819.89 STREET LANDSCAPE MAINTENANCE 393.678.00 227.215.38 166.462.62 369.334.70 237.160.74 132.173. 96 ACTI V ITY TOTAL 459.688.00 271 .489.70 188.198.30 410.280.23 249.286.38 160.993.85 COMMUNITY DEVELOPMENT ENGINEERING 15.500.00 13.532.94 1.967.06 10.558.50 10.558.50 ACTI V ITY TOTAL 15.500.00 13.532.94 1.967.06 10.558.50 10.558.50 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT ACTIVITY TOTAL TOT A L EXPENDITURES 851. 588.00 535.958.53 315.629.47 746.330.54 527.933.16 218.397.38 EXCESS REVENUE (EXPENDITURES) (34.915.00) 206.838.49 (241.753.49) (603.22) 139.993.53 (140.596.75) REVENUES OVER (UNDER) EXPENDITURES (34.915.00) 206.838.49 (241.753.49) (603.22) 139.993.53 (140.596.75) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 05/31/2008 )O~/S CAP I TAL IMP R 0 V E MEN T FUN D S CURRENT CURRENT PRIOR PR lOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUE******** USES OF MONEY & PROPERTY INVESTMENT INTEREST 1.709.300.00 1.557.479.75 151.820.25 2.044.630.85 1.714.076.41 330.554.44 LOAN REPAYMENT-PRINCIPAL 1. 500.000.00 (1.500.000.00) LOAN REPAYMENT-INTEREST 90.000.00 (90.000.00) OTHER SOURCES OF REVENUE 17.447.972.00 17.768.180.87 (320 .208.87) 8.652.525.77 7.220.315.03 1.432.210.74 TOTAL REVENUE: 19.157.272.00 20.915.660.62 (1.758.388.62) 10.697.156.62 8.934.391. 44 1. 762 .765.18 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 78.785.62 78.785.62 CITY ATTORNEY 49.400.00 123.830.33 (74.430.33) 59.936.48 57.794.59 2.141.89 ACT!VITY TOTAL 49.400.00 123,830.33 (74.430.33 ) 138,722.10 57.794.59 80.927.51 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 3.994,884.00 789.641. 36 3.205.242.64 458.257.23 274.690.91 183.566.32 ACT! V ITY TOTAL 3,994,884.00 789.641.36 3.205,242.64 458.257.23 274.69091 183.566.32 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACT! V ITY TOTAL COMMUNITY DEVELOPMENT PLANNING 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 2.895.233.46 5.347.349.54 7.993.412.28 7.676.88370 316.528.58 STREET CONSTRUCTION/IMPROVEMENT 29.417.820.00 7.971.902.40 21.445.917.60 4.497.678.86 3.973.744.06 523.934.80 ACT! V ITY TOTAL 38.105.953.00 10.867.13586 27.238.817.14 12.515.996.31 11.667.379.26 848.617.05 TOT A L EXPENDITURES 42.150.237.00 11.780.607.55 30.369.629.45 13.112.975.64 11.999.86476 1.113.110.88 EXCESS REVENUE (EXPENDITURES) (22.992.965.00) 9.135.053.07 (32.128.018.07) (2.415.819.02) (3.065.473.32) 649.65430 TRANSFER IN FROM OTHER FUNDS 30.105.65 23.505.65 6.600.00 TRANSFERS OUT TO OTHER FUNDS 39.525.20 39.525.20 REVENUES OVER (UNDER) EXPENDITURES(22.992.965.00) 9.135.053.07 (32.128.018.07) (2.425.238.57) (3.081.492.87) 656.254.30 THE CITY OF DUBLIN STATEMENT SHOWING 11~}3 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 05/31/2008 T R U S T / AGE N C Y FUN D CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 178.644.03 (178.644.03) 217.030.10 182,466.78 34,563.32 USES/MONEY & PROP-INTEREST (95.040.31) 95.040.31 14.825.42 10.259.43 4,565.99 TOTAL REVENUE 521.990.83 (521. 990.83) 5.929.923.59 192.726.21 5.737.197.38 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 236.396.70 (236.396.70) 231.940.00 230.715.00 1. 225.00 ACTI V!TY TOTAL 422.885.73 (422.885.73) 231,940.00 230.715.00 1. 225.00 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 422.885.73 (422.885.73) 231.940.00 230.715.00 1. 225 00 EXCESS REVENUE (EXPENDITURES) 99.105.10 (99.105.10) 5.697.983.59 (37.988.79) 5.735,97238 REVENUES OVER (UNDER) EXPENDITURES 99.105. 10 (99.105.10) 5.697,983.59 (37.988.79) 5.735.972.38 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2007 THROUGH 05/31/2008 1c1 ~ 13 I 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 214.19200 258.654.74 (44.462.74) 477.640.72 393.941.27 83.699.45 CHARGES FOR SERVICES 1.682.057.00 1.811.707.19 (129.650.19) 1.786.972.00 1. 635 . 080 . 20 151.891.80 OTHER SOURCES OF REVENUE 22.80000 218.704.23 (195.904.23) 1.475.321.69 12.951. 05 1. 462.370.64 TOTAL REVENUE 1. 919.049.00 2.289.066.16 (370.017.16) 3.739.934.41 2.041. 972 .52 1. 697.961.89 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 3.787.454.00 1.111.006.75 2.676.447.25 11.472.708.13 535.388.27 10.937.319.86 ACTI V ITY TOTAL 3.787.454.00 1.111.006.75 2.676.447.25 11.472.708.13 535.388.27 10.937.319.86 PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 3.787.454.00 1.111.006.75 2.676.447.25 11.472.708.13 535.388.27 10.937.319.86 EXCESS REVENUE (EXPENDITURES) (1.868.405.00) 1.178.059.41 (3.046.464.41) (7.732.773.72) 1. 506 . 584.25 (9.239.357.97) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (1.868.405.00) 1.178.059.41 (3.046.464.41) (7.732.773.72) 1.506.584.25 (9.239.357.97) ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACTI V ITY TOTAL PUBLI C SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT 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 05/31/2008 E N T E R P R I S E FUN D CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. )3 9f {3 VARIANCE