Loading...
06-08-2010 CC Rpt A05 COUNCIL AGENDA STAFF REPORT cmrlf KO ONLY Meeting Date: June 8. 2010 Public Hearing: It-tr.•:12.1.,....„ Discussion Item: r; C1-11H0 HIL .Citl:TMTh:Ti;i1Jttc, Consent Item: i':1:lt.j`t.Mlit); L IC! Cgct_ JUNE 1 , 2010 TO: HONORABLE MAYOR AND CITY COUNCIL MEMBERS FROM: CITY MANAGER SUBJECT: MONTHLY FINANCIAL REPORT RECOMMENDATION: Receive and file the Financial Report for April 2010. BACKGROUND/ANALYSIS: The Financial Report for April 2010 is attached for your review. The purpose of the monthly Financial Report is to inform the City Council, the City's citizens, and the City's staff about the financial progress of the City in meeting its service mission. The information includes the budgetary information for the City's annual financial plan as well as the actual resources received and the use of these resources in fulfilling the financial plan. The monthly Financial Report format was designed to present comparative information for the current fiscal year as well as the prior fiscal year: Current Fiscal Year: This section reports the original budget, the revised budget which includes any approved changes made during the fiscal year, and a proration of the reviewed budget based on the number of months that have lapsed during the fiscal year. Following the budget presentation columns, the year-to-date actual expenditures for the fiscal year are reported and the dollar and percentage amounts that the year-to-date actual expenditures varied from the pro-rated (year-to-date) revised budget. Any variance of 10 percent or more is explained in the footnotes that are attached to the Financial Report. The footnote legend appears at the right of the column that reports the percentage variance. Prior Fiscal Year: This section reports the year-to-date prior fiscal year actual expenditures and the dollar and percentage amounts that the year-to-date prior year actual expenditures varied from the year-to-date current year actual expenditures. Please note that the percentage variance footnotes relate only to the variance of the current year actual expenditures vs. the current year budget; the footnotes do not explain the prior year percentage variances. jII /— K)-‘ AGENDA DATE: JUNE 8, 2010 SUBJECT: MONTHLY FINANCIAL REPORT PAGE TWO Another design feature of the report is the schedule of revenues and expenditures by major fund types that are listed down the left margin of the report. The principal discretionary resource fund, the General Fund, is listed first and discloses its major revenue categories and the City functions for which these revenues are a financing resource. Following the General Fund, the non-discretionary enterprise and non-enterprise funds are reported showing their respective revenue and expenditures in a consolidated format. The report also will show each fund's "bottom line". That is, the net revenues and expenditures for the governmental type funds (such as the General Fund, Development Fee Funds, and Lighting and Landscaping District Funds), and the net profit for the enterprise funds (such as the Water Fund and Sewer Fund). All accruals are made at the end of the fiscal year. Therefore, the amounts reported could be subject to significant adjustments, upward or downward, at the end of the fiscal year. FISCAL IMPACT: Refer to the financial information presented in the report. Respectfully submitted, Recommended by, r-1/7/47/ "rn CL-41 'DR Michael S. Fler, -City Manager Ju0 Fk. Lfincasfer, Finance Director MSF:JRL:PS:gm Attachment City of Chino Hills Revenues,Expenditures,and'EDI nsters Budget nod Aetna(Corn partitive Analysis fur the Month Ending ApH.30,220(0 CURRENT YI(AR l'ItIOR YEAR Your to Date friar Year Horth: 1(1 Year Revised Budget Actual vs Dogma( Revised 11 Date Year vs Year Current Yeas Annual Annual Revised to Dale Actual Percentage to Date Actual Percentage 1l od er Budget Budget Actual Variance Variance Actual Variance Vanance C(I_t 3 ,F(IN2 KEVI Nt;S Property taxes 5,770,500 1.770,300 1,1.11.117 2.660,014 (481,902) (15.3480) (I) 3,88,083 (1-158.069) (30.33%) l'ropenlylaxes-Triplc Flip 1,445,600 1,491,700 1,213,083 827--572 (415,511) (3343%) (I) 050,454 177.118 2723% Property axes-VLF Swap 6,394.800 6,152,400 5.127,1100 3,076219 ((2,050,7811 (40,00%) (I) 3,134,718 (58,199) (1.87%) Sales taxes 4,336,890 4,336,860 3,614,000 3.07551; (537.489) )14.87%) (2) 3,002,134 74-377 148% Ul her taxes 1,127,901) 1,127,900 939.917 645.579 1294,3371 (11.32%) (2) 552,973 92,006 16,75% Total taxes i 7.075,400 16,87,100 14,065,917 10,285.896 (3,780,020) (20.87%) 11,158)62 (872,466) (7.82%) Motor schicic nn-lieu Ices 190100 190,000 158,333 12.1.7.5.5 (34,579) (21.84%) (2) 172.262 (48,507) (28.16%) Pl nes and Penalties 680,600 680.000 567,167 491,1)24 (76,142) (13.4)7') (2) 492.638 (1,614) (0.33%) Interest income and franchise fees 1,250,000 3,153,300 2,627,750 1147,974 (-179.776) 118.26%) (3) 2,925,908 (777,934) (26,5970) Community Development lees 2,401,900 2,4015)00 2.001,583 4658,973 (342,610) (17.12%) (4) 1,936,500 (277,327) (14.34!) Cost rcnnbursementa 142300 343,300 286,083 1,612,306 856,222 299.29% (5) 740,622 401.684 5424% Other revenues .5(-02949) 6,677900 5364917 4,976,925 (587,992) 110.57%1 (5) 4,236,259 740,666 17.48% Orelating transient 1,766500 2.487,600 2,073.000 1,238,662 (83.1338) (10.25%) (6) 32,237 1206425 WA Total revenues 52309100 32,813,7011 27.344,750 22065,513 (5279,235) (1931%) 21,695088 370.427 1 71% 1 xIIINIX IRI,i Legy5kluve City Council 206,100 266,100 221,756 180,988 40,762 18.38% (7) 202,581 (21,593) (111,66%) City Moine). 350,000 353,401) 298,667 370,135 (80,469) (26.94%) (1) 240.889 132,246 5357/0 City Clerk 814,800 (1(14,800 570.667 506,490 04,176 9,57% 614,516 (8,026) 11.31%) CnvManage' Adminnalrmion 1.398,960 (,935,7911 1,613,083 1,567,367 45,716 2.81% 1,388,074 179,293 12.92% Contract Swvices 189,1110 189300 157,7.50 123,230 34.520 21,88% (7) 122,783 -417 0.36% Community Relations 546.402 547,200 450,04)0 370.157 85.843 18.83% (7) 333,616 36,511 10,95% lhlman Resources 356,800 367.100 305,917 225,596 80)19 26.16% (7) 243,235 (17,637) (72536 Risk Management 37-1.700 881,900 7.34,033 897,809 (163,726) (22.30%) (7) 881,112 16.697 1,90% C_9mnlunty 17ev±00.196( ,Administration 1,107900 723,250 771259 151,981 1646% (7) 859,1011 (87,831) (1(1,22%) h i 3.5.201 Building Sci vices 1.000,300 937,000 780.833 728,901 5(932 6,65% .413,947 (35,046) (10.15''='n) Development Services 106,500 972200 810,167 460,74) 319,4226 43.13% (7) 303,622 (342,881) (42.67) Economic Development 7.1,300 93,300 77,750 24.731 53.0 t9 68.19% (7) 49,331 (24,600) (49!87'%^) Cgmlpunijy_Sen Ice; Administrative 857,200 962,100 801,750 722.094 79,057 9,94% 628,7.83 93,811 14,931. Neighborhood Services and Code i,misrremenl 1,223,7f"-) 1,235,700 1.929,750 888,806 140,944 13 69% (7) 371,644 17,162 1,97% Public gaiety 10,373,100 10,378,000 8,648,333 8,339.003 309,326 7.58% 8,401.793 (622,785) (0.75%) Recreation Sen ices 7,5530070 2,573,500 2,144,583 1,918,071 226,512 1056% (7) 1047.792 (129,721) (633%) ('age 101 3 CURRENT YEAR PRIOR YEAR Year to Date Prior Year Month: 10 Year Revised Budget .Animal vs Original Revised to Date Year vs Year Current Year Annual Annual Revised to Date Actual Percentage to Dale Actual Percentage Budget 13udeet Budget Actual Variance Variance Actual Variance Variance GENERAL Ft IND l cont'truer)) EXP);1,NPIT(1R48(cnminnd} Engineering. Administrative 765,500 705,500 637,917 564,291 738,25 11.34% 17) 711,974 047,683) (20.741) Engineering Serra:es 1,076,100 1,076,300 896,917 705,290 191,627 21 37% (7) 730,284 (24.994) {342%) Finance Administrative 2,089,800 2.091,900 1,743,250 1639,988 103.262 5 92% 1553 991 85,995 5,53% Nom Departmental 02 9Q 94.300 78.583 39,484 29_!00 4076% (7) 176,540 (137.056) (77.63%) Development Program 1308,400 1,708,400 1,423.667 1.515,46(1 (91,793) (6.45%) (7) 1,732,390 (216,930) (12.52%) t'pblic,lacdiues and()renames Administrative 789,600 792,100 660.083 591,615 68,1613 10371 (7) 652,098 (60,483) (9.28%) Facility and Equipment Maintenance :,236,40: 1,236,400 1.030.333 945,7:5 34,617 8.21% 911.032 34.684 2 81% Other Maintenance 904,600 034,000 778,333 660,553 117,780 15.13% (1) 726,131 (65,578) (9.037) Pfi_e(tmd Tmn_f_r'< Copilot improvement Protects 1,859,300 2,668,200 2,223,500 292,516 1.930,984 86.34% (7) 17,173,278 (30,880,762) 098.30%) Operation Transfers 486,200 436,200 405,167 313,987 91,179 22,50% (61 182,500 111,487 72.05"/ Total expenditures 15834,800 35,462,500 29.552,083 25,473295 4.078,788 13 80% 43,058,538 (17,5852443} (40.84°%) Net revenues overi(undcr) expenditures (3.5252001 (2,648,800) (2,207,333) _(3407,780) - (1,200.447) (5438%) (21,363,450) 17,)55,670 84.05% WATER FL'Nt) }{EYfNi_F..S Water sales 17,852.000 17,852,000 14,576,667 13,343,421 (1,533,246) ;10.31%)(10) 12,898,767 444,654 3,45% Other revenue 773,600 725,800 604.833 2,691710 2.086.886 345 09% (5) 4,230,051 (1,538,332) (36 37%) Total revenues 18,625.600 18,577,800 15,481,500 16.035,139 553,639 3 53% 17,128,813 (1.093,679) (6 39r,) lixpl:N, URC3 ..__or 5 . _ cost Water cods ;?_(yin,1l;ii 8,630.100 7191.750 7,946.245 {754.495} (1449'%) (8) 6;962,745 484,100 14,14% Power costs 926.200 926200 771,833 549,476 222,357 28.81% (8) 744,688 (195,212) (26.21%) Unearned Transfers 2,268,500 2,156,100 1,796,750 36,091 1.760.659 97991 (6) 670.540 (634,440) (94.62%) Other costs 13,783,300 14,059,600 11716,333 5,139,606 6.576,727 5613.• (9) 5,884,390 (744,784) (12.66%) 1041 expenditures 25,008,100 2.5772,000 21,476,667 13,671.418 7.805.249 36 34% 14,261.763 (590,345) (4.14%) Net profit(loss) _ (6,982,5017) _17,194.200) _.(5,995.167) 2,363,721 8 358,888 130 43% 2,867,054 (503334) (17.561) S$.W[RU D. Revenues 6.109,900 6.1 10,000 5,091,667 4,536,453 (.555,211) (10.90%)(10) 6,237,770 (1,701,317) (27.27%) Expenditures 6.370,800 6445,+00 5,371,083 3,234,087 2.136,996 3979% (9) 3.39.5,299 (161,212) (4.75%) Net proft(loss) (200.000) (335.300) (279,417) 1,302,366 1,581.783 566,10% 2,842,471 (1.540,10.5) 04,18%). 11)1;(13 WAJTU 1)ND Revenues 3,996,900 3,996,900 3,330,750 3,1.49243 (181507) (5,45641 3,123,764 25.479 082% Hvp:n(111nm% 3,996 000 3,996,900 3,330,750 2,511,724 819,026 24 59%(I 1) 2,462,767 48,957 1.991 Net revenues and expenditures __ - _6;_,519 637.519 N/A 660,997 {23,478) (355%) Page 2 of3 CURRENT YEAR PR FOR Y EAR Year to Date Prior Ycat Month: I0 Year Revised tiudoet Actual vs r)rtginal Revised to Date Year vs Year Current Yeat Annual Annual Revised to Date Actual Percentage to Date Actual Percentaoe I Indeer Rudttet Budget Actual Variance Variance Actual Variance Variance D1 Vt_LQPM0N I_itti_DS(131 Revenues 2.334.600 2261,000 1,884,167 1431,436 (752,731) (39.95%)(12) 2,053,63.1 (922.199) (4491%) Expenditures 9,708,500 11,849,200 9,874333 1,224,322 8,650.011 87,60%(12) 2,052,619 (828,297) (4035%) Net revenues and expendtiunts (7.373.900) (9.588.200) ___ 17 990,1611 (92,887) _ 7,897280 08,84% 1,015 (93.902) (925139%) C()NS;'I2UCTDON FINDS Revenues 34818,500 35,753.310 29,794,417 6,750.442 (23,043975) (77.34%) (6) 25,945.184 (19,194,742) (73.98%) 1:xpenditures 32,633,100 36571,000 30.475.833 3,7893100 26.685,934 87.56% (6) 253(63,894 (22,073,994) (85.35°%) Net revenues and expenditures (815.400) _ (317.700) (681,417) 2.960.542 __ 3,641,959 534 47% 81747 2,879,252 . (3591 95%) LANDSCAPE AND L1GI{UNG 015 rgtcr FUNDS Revenues 9,025,400 9,007,700 7,502,250 6.924.416 1577,834) (7.70%) 7,880,001 (955,585) 1,12,13%) Expenditures 10,989.400 11 792,700 9.493,917 8,145,960 1,347,957 14.20°% (7) 7324,319 821,6*41 1122% Net revenues and expenditure (7964,000) (2390.000) (2001667) (1,2221.544' _ 1 770,122 38.67% _ 555,682 (1,777„226) 32283'8., A,.SSi3SLMEN3'(DISTRICT,FUNUS Revenues 1,150,200 1,132,700 943,917 890,163 (53,754) (5.69%7 1,603,164 (713,001) (44 47%) Expenditures 1,118,300 1.118300 931,917 t 252.380 (320,444) (34.39%) (6) 1,376,991 (124,61(1 (905%) Net revenues and expenditures 3190 _ 14,400 12,0(X) (362..218) _,_.�, £371,2181. —, NVA __ 226,173 (588,3911 _ 260.15_'0 COMMUNITY FACILITIES DISI'RICIS FUNDS Revenues 11.366.100 11,285,000 9,404,167 8,075,155 (1,329,072) (14.13%) (4) 1545.3,318 (7,378,163) (47,74%) Expenditures 11575,400 11,553,000 9.627,500 8.491,437 1.136,063 11 80% (7) 10,504.861 (11,013,424) (56.47%) Net revenues and expenditures (209.300) _ 1268,000)_ (223,3331 �,(416.283i (19x949) (86.40N (4,051,543) 3,635,260 89.73% ,MISCELI.ANEQUS IUNPS114) Revenues 11,850,000 17,667,800 14,723,167 5.883,892 (8,839,274) (60.01%)(15) 7,165,117 (1,281,225) (17.58%) Expenditures 16,771,900 20,718.400 17,265,333 7,594,034 9,671,299 56.02% (7) 5,558,374 2.035,660 36+62% Net revenues and expenditures 13,921,900) (3,0511,600) __. (2,542,167) __ (1,710,142) 83 025 32.73% 1606,743 (3.316,885) , 206,41% Page 5 of 3 less are received at the beginning of the fiscal year. taxes, e due. FOOTNOTES. ion of property and special assessments collected at different intervals April when the two property'tax installments become creat namenature of the collection and forfeitures are c t, Due to the cyclical from December through AP transfer tax,and Fines there is an Inc license tax,property recorded on an annual basis. sales tax,business and the franchise fees are ear, end of each calendar quarter, 2, Motor houtthefscalyeu e throughout which vary lion fees are cyclical in nature. as donations (located and recorded alcor the leinterest is a Its and engineering inspection miscellaneous revenues such g, Investmentalso, building perm different sources: It depending m the cost reimbursements from or annually semi-annually. q.The collection of bothvariety of semi-annually, usually paid semi-a accounts anon a generally made quarterly'sem istrical bonds are year. 5,These aro ar to year. rs are 9 Community Facilities D bout the fiscal Y greatly from year cls andended evenly throughout s for the Assessment Dis.nnot expended principal reason coEr this variance is that interfund trans debt service (Risk Management), encs. 6.The of the transfer,and enditures or cyclical m nature and are out payments. insurance Premiums( ending r one-time exp. rendered and the City s expenditures are erocessing costs(Finance), budgeted P data P invoices for services 7. Selective audit and resenting Examples include the en vendors P difference between for the Period. recorded on an annual basis. collected B. This depreCe is due to the timing expenses aretime between when the and amortization exp is caused by the lag recration a } s were sent out and the actual revenue q, The deP when the utility bllinSvariance caused by ice timing ears that the when the variance is depends on tp, This n behalf ofe contractor. It appears in nature and P collects the solid waste fees o the contractor. menl fees is cyclical t t.The tidy • the foes and when it paysFacilities, City collects is that the collection of the tacllities development clure.General City Traffic Signal Fee,Existing Infrastructure,12.1The silts al reason for this variance ermils for construction- Quimby in Lieu, Fee Funds. Local law developers obtain P Rec Facilities Fee. Fee,Water Facilities OpIn public Safety•. Park& Sewer Facilities Tax, Citizens an Equipment Maintenance, of the following= Drain Facilities,Sew Trans Sales Improv,Misc.Grant, 13 Consists Storm Protect' Measure I Road Imp stat Traffic Facilities Fee, Gas Tax,Entitlement. Quality SleePY Hollow R int Agency. _Special sweeping, lated to several cap Gpgo uhori y, H Foundation and Federal Emerg Mg rent, eligible to draw down various Federal Grants re t 15. The C onsists ciofpl reason to anos variance ty, is Enforcement Herm when the City Data Processing,Tres due to the liming The principle for this variance is improVement protects. Pe9v 1 vi