Loading...
HomeMy WebLinkAboutAGENDA REPORT 2010 1117 CC REG ITEM 10C ITEM 10.0 ,iq, Council iv-ee}inc MOORPARK CITY COUNCIL AGENDA REPORT Lh_. ate- TO: The Honorable City Council FROM: Ron Ahlers, Finance Director//D L By: Irmina Lumbad, Finance/Accounting Manager DATE: November 1, 2010 (CC Meeting of November 17, 2010) SUBJECT: Consider Resolution Amending the Fiscal Year 2010/2011 Budget and Authorizing the Transfer of Gas Tax and General Funds to Cover Fiscal Year 2009/10 Year-End Deficits in Certain Funds for the City's Landscaping and Lighting Assessment Districts BACKGROUND On June 2, 2010, the City Council approved the assessments for the City's Landscaping and Lighting Districts for FY 2010/11. In the staff report accompanying that action, it was mentioned that certain Assessment District Funds were projected to show a FY 2009/10 year-end deficit. Continuing the policy from last year, the projected FY 2009/10 deficits were funded in the adopted budget for the succeeding FY 2010/11. It was also mentioned in the report that, when the actual FY 2009/10 year-end figures were known, staff would present to the City Council, a budget amendment approving appropriations and fund transfers to "zero-out" the actual deficits. DISCUSSION A. Actual FY 2009/10 Year-End Deficits Attachment 2 (Pages 1 & 2) is a schedule showing the Fund Activity for the Assessment District Funds for FY 2009/10. Certain Funds show a FY 2009/10 year- end deficit, summarized as follows: 168 Honorable City Council November 17, 2010 Page 2 FY 09110 FY 09/10 Beginning Transfer In Ending Fund Balance Jan-10 Revenue Expenses Balance 2300: Citywide-Street Lighting ($42,936) $42,936 $251,377 $437,796 ($186,419) 2300:Citywide-Landcaping ($217,100) $217,100 $186,034 $394,452 ($208,417) 2303: Dist 3 Buttercreek/Peppermill' $459 $3,143 $9,782 ($6,181) 2304: Dist 4 Williams Ranch Road' ($1,290) $1,290 $6,515 $15,910 ($9,395) 2305: Dist 5 Pheasant Run Area' ($13,924) $13,924 $23,822 $57,611 ($33,789) 2306: Dist 6 Inglewood Street' ($2,894) $2,894 $1,210 $6,375 ($5,165) 2307: Dist 7 Moorpark Business Park' ($3,083) $3,083 $12,757 $24,283 ($11,526) 2308: Dist 8 Home Acres Buffer' ($16,739) $16,739 $15,558 $34,655 ($19,097) 2309: Dist 9 Moorpark Industrial Park' ($4,602) $4,602 $1,384 $7,893 ($6,509) 2314: Dist 14 Wilshire Builders' $224 $0 $1,501 $6,850 ($5,126) Total ($301,885) $302,567 $503,300 $995,606 ($491,623) Notes: ' Landscaping deficits 2 At the time of budget adoption in June 2010,this was estimated to be$471,288. B. Proposed Adjustments During the budget development for FY 2010/11, assessment districts were projected to have an aggregate deficit of $471,288 and budgeted transfers from the General Fund and Gas Tax were estimated to be: From From Total To be Transferred to Fund: Gas Tax Fund General Fund Projected Deficit 2300:Citywide-Street Lighting ($137,000) $0 ($137,000) 2300: Citywide- Landcaping ($103,849) ($103,849) ($207,699) 2303: Dist 3 Buttercreek/Peppermill' ($3,966) ($3,966) ($7,931) 2304: Dist 4 Williams Ranch Road' ($4,915) ($4,915) ($9,830) 2305: Dist 5 Pheasant Run Area' ($19,580) ($19,580) ($39,160) 2306: Dist 6 Inglewood Street' ($2,825) ($2,825) ($5,650) 2307: Dist 7 Moorpark Business Park' ($8,100) ($8,100) ($16,200) 2308: Dist 8 Home Acres Buffer' ($13,887) ($13,887) ($27,774) 2309: Dist 9 Moorpark Industrial Park' ($3,300) ($3,300) ($6,600) 2310: Dist 10 Mountain Meadows' ($4,424) ($4,424) ($8,848) 2314: Dist 14 Wilshire Builders' ($2,298) ($2,298) ($4,596) Total ($304,144) ($167,144) ($471,288) Note: ' Landscaping deficits 169 Honorable City Council November 17, 2010 Page 3 Based on the budgeted transfers, the Gas Tax Fund is expected to have a fund balance deficit of $56,477 at the end of FY 2010/11. If we continue to fund the street lighting and landscaping deficits according to prior year actions, the Gas Tax will require a net appropriation increase of$34,877 (an additional $49,418 for street lighting and a reduction of$14,541 for landscaping) and will cause the fund balance deficit to increase to $91,354. In order to prevent the Gas Tax Fund from incurring a deficit balance at the end of FY 2010/11, staff recommends the street lighting deficit to be funded similarly as the landscaping deficits, that is, 50-50 between the Gas Tax and General Fund. If City Council approves the modified funding scheme, the Gas Tax is anticipated to have a fund balance surplus of $1,856. Using the modified funding, the FY 2009/10 assessment districts' actual deficit of $491,623 will require the transfers from the Gas Tax Fund and General Fund as follows: From From Total To be Transferred to Fund: Gas Tax Fund General Fund Projected Deficit 2300: Citywide - Street Lighting ($93,209) ($93,209) ($186,418) 2300: Citywide- Landcaping ($104,209) ($104,209) ($208,418) 2303: Dist 3 Buttercreek/Peppermill' ($3,090) ($3,090) ($6,181) 2304: Dist 4 Williams Ranch Road' ($4,697) ($4,697) ($9,395) 2305: Dist 5 Pheasant Run Area' ($16,895) ($16,895) ($33,789) 2306: Dist 6 Inglewood Street' ($2,583) ($2,583) ($5,165) 2307: Dist 7 Moorpark Business Park' ($5,763) ($5,763) ($11,526) 2308: Dist 8 Home Acres Buffer' ($9,549) ($9,549) ($19,097) 2309: Dist 9 Moorpark Industrial Park' ($3,254) ($3,254) ($6,509) 2310: Dist 10 Mountain Meadows' $0 $0 $0 2314: Dist 14 Wilshire Builders' ($2,563) ($2,563) ($5,126) Total ($245,812) ($245,812) ($491,623) Note: ' Landscaping deficits 170 Honorable City Council November 17, 2010 Page 4 C. FY 2010/11 Projected Deficits It is anticipated that the Landscaping and Lighting Maintenance District Funds will again show a deficit at the end of FY 2010/11. FY 2010/11 Fund Activity chart is Attachment 3 (Pages 1 & 2). The estimated amounts are summarized as follows: FY10/11 FY10/11 Beginning Transfer In Ending Fund Balance Dec-10 Revenue Expenses Balance 2300: Citywide-Street Lighting ($186,418) $186,418 $244,300 $378,000 ($133,700) 2300: Citywide-Landcaping ($208,418) $208,418 $180,600 $408,230 ($227,630) 2303: Dist 3 Buttercreek/Peppermill' ($6,181) $6,181 $3,100 $10,360 ($7,260) 2304: Dist 4 Williams Ranch Road' ($9,395) $9,395 $6,500 $15,710 ($9,210) 2305: Dist 5 Pheasant Run Area' ($33,789) $33,789 $23,500 $64,556 ($41,056) 2306: Dist 6 Inglewood Street' ($5,165) $5,165 $1,000 $5,370 ($4,370) 2307: Dist 7 Moorpark Business Park' ($11,526) $11,526 $11,300 $27,160 ($15,860) 2308: Dist 8 Home Acres Buffer' ($19,097) $19,097 $15,300 $43,253 ($27,953) 2309: Dist 9 Moorpark Industrial Park' ($6,509) $6,509 $1,400 $7,540 ($6,140) 2314: Dist 14 Wilshire Builders' ($5,126) $5,126 $1,500 $5,410 ($3,910) Total ($491,623) $491,623 $488,500 $965,589 ($477,089) Note: ' Landscaping deficits It is projected that the actual FY 2010/11 year-end deficit will be funded by transfers in FY 2011/12, similar to the modified funding as requested herein. D. FY 2010/11 New Back-up Assessment Districts On June 2, 2010, the Council adopted the Resolutions 2010-2912 and 2010-2913 approving the landscaping and lighting maintenance and assessment districts AD10-01 Tuscany Square & AD10-02 HFR Investment. These districts are classified as "Back-up" districts. The developer and/or property managers are primarily responsible for the maintenance of improvements within the area. Conditions of Approval include provisions to allow the City to take over the responsibility for the maintenance of the improvement, should the City determine that the improvements are not being maintained properly. The Engineer's Report for each respective district stipulated the levy amount to be equal to the primary assessment, that is, the amount sufficient to fund the annual administration cost. For FY 2010/11, this amount is set at $500.00. The assessments revenues for AD10-01 and AD10-02 were not included in the FY 2010/11 adopted budget. 171 Honorable City Council November 17, 2010 Page 5 FISCAL IMPACT The attached Resolution amends the FY 2010/11 Budget by revising the appropriated amounts of the Fund Transfers to equal the actual FY 2009/10 year-end deficits. The net fiscal impact is a net appropriation increase in the amount of$20,335 as described below: Gas Tax Fund General Fund TOTAL FY 10/11 Budget $304,144 $167,144 $471,288 FY 09/10 Actual $245,812 $245,812 $491,623 Budget Adjustment ($58,332) $78,668 $20,335 As stated in this report, combined Gas Tax and TDA Article 8 fund balance is relatively small and will probably not be available to fund these deficits beginning next FY 2011/12 due to other street expenditures. This will require more funding from the General Fund Reserve unless assessment revenue is increased or services reduced. The Resolution also includes a $1,000 revenue amendment to account for the AD10-01 & AD 10-02 levied assessments for FY 2010/11. STAFF RECOMMENDATION (Roll Call Vote) Adopt Resolution No. 2010 - Attachments: 1: Resolution 2: FY 2009/10 Actual Fund Activity 3: FY 2010/11 Estimated Fund Activity 172 ATTACHMENT 1 RESOLUTION NO. 2010 - A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF MOORPARK, CALIFORNIA, AMENDING THE FISCAL YEAR 2010/11 BUDGET TO APPROVE CERTAIN APPROPRIATIONS AND FUND TRANSFERS FROM THE GENERAL FUND (1000) AND THE GAS TAX FUND (2605) REQUIRED TO FUND FISCAL YEAR 2009/10 YEAR-END DEFICITS FOR CERTAIN ASSESSMENT DISTRICT FUNDS AND TO APPROVE REVENUE BUDGET INCREASE FOR NEW ASSESSMENT DISTRICTS AS DEFINED HEREIN WHEREAS, on June 2, 2010, the City Council adopted Resolution Nos. 2010- 2912 and 2010-2913, approving the Landscaping and Lighting Maintenance and Assessment Districts (AD), AD10-01 Tuscany Partners and AD10-02 HFR Investments respectively; WHEREAS, on June 16, 2010, the City Council adopted the Operating and Capital Improvement Budget for fiscal year 2010/11, which includes $471,288 in Gas Tax and General Funds, to cover the fiscal year 2009/10 deficits in certain Assessment Districts Funds; and WHEREAS, said adopted budget excluded $1,000 of assessment revenues levied upon property owners of AD10-01 Tuscany Partners and AD10-02 HFR Investments; and WHEREAS, a staff report has been presented to the City Council summarizing the actual fiscal year 2009/10 fund deficits of $491,623 in various Assessment District Funds; and the same report is requesting a net appropriations increase of $20,335 in the Gas Tax and General Funds to match the required Fund Transfers to eliminate the mentioned deficits; and WHEREAS, said staff report has been presented to the City Council requesting fund transfer in the aggregate amount of$491,623; and WHEREAS, the same staff report is requesting an aggregate revenue budget adjustment of $1,000 in AD10-01 Tuscany Partners Fund (2331) and in AD10-02 HFR Investments Fund (2332); and WHEREAS, Exhibits "A" and "B", attached hereto and made a part hereof, describes said budget amendments and its resultant impacts to the budget line items. NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF MOORPARK DOES HEREBY RESOLVE AS FOLLOWS: 173 SECTION 1. That a Budget Amendment in the aggregate appropriation increase of$20,335, as more particularly described in Exhibit "A", is hereby approved. SECTION 2. That a fund transfer in the aggregate amount of $491,623 as particularly described in Exhibit "A", is hereby approved. SECTION 3. That a Budget Amendment with an aggregate revenue increase of $1,000, as more particularly described in Exhibit"B", is hereby approved. SECTION 4. The City Clerk shall certify to the adoption of this resolution and shall cause a certified resolution to be filed in the book of original resolutions. PASSED AND ADOPTED this 17th day of November, 2010. Janice S. Parvin, Mayor ATTEST: Deborah S. Traffenstedt, City Clerk Attachment: Exhibit 'A': Budget Appropriation and Fund Transfer Detail Attachment: Exhibit 'B': Budget Revenue Amendment 174 Exhibit A Budget Amendment for Gas Tax and General Funds to Adjust Transfers Required to Fund FY 2009/10 Year-End Deficits In Certain Assessment District Funds FY 2010/11 A. Fund Allocation Fund No. Fund Description Amount 1000 General Fund 78,668 2605 Gas Tax Fund 58,332 Total 20,335 B. Fiscal Year 2010/11 Budget Appropriation Budget Number Adopted Budget Budget Change Revised Budget FROM: 1000-7900-000-9820 $167,144 78,668 $245,812 2605-7900-000-9820 $304,144 58,332 $245,812 Total $471,288 20,335 $491,623 TO: 2300-3720 (Lighting) $137,000 49,418 $186,418 2300-3720(Landscaping) $207,699 719 $208,418 2303-3720 $7,931 (1,750 $6,181 2304-3720 $9,830 435 $9,395 2305-3720 $39,160 (5,371) $33,789 2306-3720 $5,650 485 $5,165 2307-3720 $16,200 4,674 $11,526 2308-3720 $27,774 8,677 $19,097 2309-3720 $6,600 91 $6,509 2310-3720 $8,848 8,848 $0 2314-3720 $4,596 530 $5,126 Totall $471,288 20,335 $491,623 C. Appropriation Allocation To Be Transferred to: From From Fund Fund 2605 Fund 1000 Total 2300-3720 $197,418 $197,418 $394,836 2303-3720 $3,090 $3,090 $6,181 2304-3720 $4,697 $4,697 $9,395 2305-3720 $16,895 $16,895 $33,789 2306-3720 $2,583 $2,583 $5,165 2307-3720 $5,763 $5,763 $11,526 2308-3720 $9,549 $9,549 $19,097 2309-3720 $3,254 $3,254 $6,509 2310-3720 $0 $0 $0 2314-3720 $2,563 $2,563 $5,126 Total $245,812 $245,812 $491,623 Approved as to Form: 175 Exhibit B Budget Amendment for AD10-01 Tuscany Partners & AD10-02 HFR Investments To Adjust Assessment Revenues FY 2010/11 A. Fund Allocation Fund No. Fund Description Amount 2331 AD 10-01 Tuscany Partners 500 2332 AD 10-02 HFR Investment 500 Total 1,000 B. Fiscal Year 2010/11 Revenue Allocation Budget Unit/Account Adopted Budget Adjustment Adjusted Budget 2331-3102 $ - $ 500 $ 500 2332-3102 $ - $ 500 $ 500 TOTAL $ - $ 1,000 $ 1,000 Approved as to Form: 176 ATTACHMENT Page 1 of 2 CITY OF MOORPARK Assessment District-Lighting and Landscape -- - _ Fund Activity_ FY 2009/2010(ACTUAL as of 10/28/2010) ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL - and Balance, Fund Fund Balance, FY 09/10 Ending Proposed Balance, Beginning Ref Transfers In Total Exp Net Revenue/ before Transfers in Ending After AD Fund Description - - (Adjusted) code Assmt Levy for FY 08/09 Interest Others Revenue cede Expenditures (Expenditure) Transfers FY 10/11 Transfers 84-2 2300 Lighting - X42,935.00) 3+ao 251,377 03 42,935.86_ _ 294,312 89 e9°t 437,796.01 (143,483.12). (186,418 12) 186,418 12 0.00 - - - 84-2 2300 Improvements 000 0.00 ' 0.00 000 0.00 84-2 2300 Landscaping (217,100 42) 3102 185,923 97 217,100.00 1100.0 403,133 97 799001 394,451.89 8,68208 (208,418.34) 208,418.34 0.00 2300 Total 000 6 . .. 94.---.._.__.. .- _ (260,035.42): 437,301.00_ _2.6.0,035.86 697,446.86 832,247.90 (134,801.04) (394,836.46)- .394,836 46 0.00 84-2 2301 D1 Pecan Ave T-2851 18,543 50 3102 9_902.31 139.98 10,042.29 7901 19,373.61 (9,331.32) 9,212.18_ 9,212.18 2301 Total 18,543.50 9,902.31 0.00 139 98 0.00 10,042 29 - 19,373.61 (9,331.32)' 9.2 12.18 7 -0.00 9,212.18 84-2 2302 152 Steeple Hill Area T-2865 101,953 20 3102 68.228 14 1,045.07 69,273.21 7901 75,430 19 (6,156.98) 95,796 22 95,796.22 84-2 2302 D2 Steeple Hill Area T-2865 Drains 9,34500 3103 7,135.34 7,135 34 8902 431 99 6.70335 16,048.35 16.048 35 2302 Total 111,298.20 75,363 48 0.00 . 1,04507 000 76.40&55 75,862.18± 546.37 111,844.57 0.00 111,844 57 84-2 2303 D3 Buttercreek/PeppermdlT-3023 458.62 3,02 3,142.56 012 3,14268 : 7so, 9,781.90 : (6,6392_2) (6,18060 6.180.60 000 2303 Total 458.62 3,142.56 0.00 012. 0.00 _3,142 68 9,781.90 (6,639 22) (6,180.60) 6.,-18.0-60 000 84-2 2304 D4 Williams Ranch Rd T-3274 1,290 34), 4 3102 6,514.78 . 1.296.34 7,805.12 79o1 15,909.53 8,104.41 9,394.75 9,39435 000 2304 Total (1,290.34) 6,514.78 1,290.34 0.0.0 0 00 7,805.12 15,909.53 (8,104 41) X9,394.75) 9,39475 0.00 _ - --- - --- ----- --..__._ - -_.... ) 84-2 2305 D5 Pheasant Run Area T-3019/3525 (13,924.00) 3102 23,821.88 13,924 00 37,745 88 7901 57,611.10 (19,865.22) (33,789.22 33,789.22 000 _. __.._.---- - -- -- - .. 84-2 2305 D5' Pheasant Run Area T-3019/3525 1,634 34 3103 510.32 510.32 8902 431.99 78.33 1,712.67 1.71267 Drains 2305 Total (12,289.66) 24,33Z20 20 13,924 00 0 00 000 38,256.20 58,043 09, (19,786 89L (32,076_55): 33,789.22 1,71267 84-2 2306 D6 Inglewood St T-3306 (2.893 97) 31 C2 943 07 2,893.98 266 85 4,103.90 7901 6,375.05 (2,271 15 5,165 12 5,165.12 000 2306 Total (2,893 97) 943 07 2,893.98 0.00_ 266.85 4,103 90 6,375 05 (2,271.15) (5,165 12) 5,16512 000 84-2 2307 D7.Moorpark Business Park(LA Ave (3.082 65) 7102 12,757 11 3,082.65 15.839 76 7901 24,282.87 (8,443 11) (11,525 76) 11,525 76 0.00 &Gabbert) -- -- - •2307 Total (3108.2.65)'- - - -• .. 12,757._11.•-_3,082.65 0.00 • 0.00 15,839 76 • 24,282.87- (8,443:11); (11,52536). -11,525.76 _.. O_oo. 84-2 2308 D8. Home Acres Buffer (16 738.60) 3102 15,557.72 16,738.60 32,296 32 7901 34,654.78 (2,35_8.46): (19,097_06) 19,097 06 000 2308 Total (16,738 60) 15.557.72 16,738.60 0 00 0 00 32,296 32 34,654.78 (2 358.46) (19,097.06) 19,097.06 000 84-2 2309 :D9 Moorpark Industrial Park(Condor (4,601 94) 3102 1,383.99 4,601.94 5,985.93 7901 7,892.51 (1,9065.8) (6,508.52). 6,508.52 000 Drive) 2309 Total _ (4.601 94) 1,383.99 4,601.94 000 0.00 5,985.93 7,892.51 (1,906.58) (6 508 521 6,508.52 000 84-2 2310 610 Mountain Meadows PC-3 27,763.79 3,02 198,291 13 435 10 1,565.50 200,291 73 7901 214,029 20 (13.737.47) 14,026.32 . 14.026 32 84-2 2310 :D10 Mountain Meadows PC-3 3103 7,401,72 8902 5.19045 Drains 32,354 00 7,401 72 2,211 27 34,565 27 34,565.27 2310 Total 60,117 79 205,692 85 0:0.0 435.10 1,565 50 207,69145 219 219.65 (11,526.20)- 48,591.59 0.00 48,591 59 84-2 2311 D11 AlyssasCtT-417.4 5,474.64 3102 3.102.76 42_94 _ 3,145.70 7901 6,12216 (29-7-6- 7646) 2,498.18 2,498.18 2311 Total 5,474 64 3,102,76 0 00 42 94 0 00 3,145 70 6,122.16 (2,976.46) 2,498.18 000 2,498 18 _ _...._. _.. - ..._. __...._-_._ ...._._.._.._.._ ..... __4 .... _._. .. 84-2 2312 :D12 Calrsberg Specific Plan Area 562,389 19 3102 29,709 99 6,876.12 36,586 11 7901 181,881.84 (145,295.73) 417,093.46 . 417,093.46 _.. _-.. ...__._.- ... - ..__ - - 2312 Total 562,389.19 29,709 99 0 00 6,876.12 0.00 36,586.11 f61_'68 184 (145,295 417,093 46 0 00 417,093.46 84-2 2313 .D13 unassigned 000 660 1 000 0.00 0.00 2313 Total 060 000 0.00 0.00 000 ____000_*:_ 00 ! 0.00 0.00 0.00 0.00 -6-66- 01-1 2314 D14 Wilshire_Builders T-5.201 _2235F 3102 1,500.93 0.09 1.501.02 ' 7901 6,850.35 5,349.33 5,125.75 5,125.75 . 000 2314 Total 223.58 1,500.93 0.00 : 0.09T 000 1,501.02_ _ _ 6,8_50.35 (5,34933) (5,125.75). 5_,_1.2.5_.75 0.00 01-2 2315 D15 Toll Brothers 28 T-49 1,986,017.48 3102 60.060 32 '24,2_38 90 ! 84,299 22 7901 23 139,204.74 (54,905.52)1,931,111.96 1,931,111.96 15 Total 1,986,017.48 60,060.32 000 24,238.90 0.00 84,299.22 139,204.74. (54 05 ,9 .52 ! 1,931,111.96 0.0.0 1,931,111 96 01-3 2316 D16 Cabrillo T-5161 46,92901 3102 5,670.17 1,104.51 6,774.68 7901 13,41197 (6,637.29)• 40,29172 4029172 01-3 2316 D16 Cabrillo T-5161 Drains 44,161 14 3103 2,112.85 : 2,112.85 8902 0.00 2,112.85 46,273 99 46,273.99 2316 Total 91,0.90 15 7,783.02 000 1,104.51 0.00 8,887.53 : 1-3,411 97 (4,524.44) -86,565.71 060 8.6,5.6.5.71 2317 D17 unassigned 0.00 000 000 0.00 0 00 2317 Total 0.00 0 00 , 0.00 0.00 000 0.00 0.00 0 00 0.00 000 0.00 04-1 2318 D18 Colmer T-5307 26,133 47 3102 19,736.04 Eiff 99 20.300 03 . 7901 14,512.73 5,787 30 31,920.77 31,920.77 04-1 2318 D18 Colmer T-5307 Drains 17,143 00 3103 1,584.43 1,584.43 esoz 00.0 1,584 43 r 18,727.43 18,7_27 43 2318 Total 43,276.47 21,320.47 : 0 00 563 99 0.00 21,884 46 j 14,512.73 7,371 73 50,648.20 000 50,648.20 05-01 2k19 Dig MW PM-5264 Back-u 36,936 35 3102 54.71 454.96 50967 7901 253.84 255.83 37,192 18 37,192.18 23 4�Total 36,936.35 54.71 0 00 454.96 0 00 509 67 : 253.84 255.83 37 192.18 0.00 37 19218 S T nance\Ror.FoldeMSSessment Dislnot\2010.2011 Assessment Dis1nas110 11 Estimate for FY 09 10 AcluanAC_09-10ACTUAL d 10-11 ESTIMATE/;1/12010/Page 1 oft ATTACHMENT 2 Page 2 of 2 CITY OF MOORPARK Assessment District-Lighting and Landscape Fund Activity: FY 200912010(ACTUAL as of 10/2812010) ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL Fund Balance, Fund Fund Balance, FY 09110 Ending Proposed Balance, Beginning Rev Transfers In Total Exp Net Revenue/ before Transfers in Ending After AD Fund Description (Adjusted) code Assmt Levy for FY 08/09 Interest Others Revenue code Expenditures (Expenditure) Transfers FY 10/11 Transfers 07-2 2320 D20:Lyon Homes T-518.7 971,456.95 3102 62,226.90 12,386.88 : 74,613.78 7901 18,683.04 55,930 74 1,027,387.69 1,027,387 69 2320 Total 971,456.95 62,226.90 0_.0.0_ '12,386.88 coo 74,613.78 18,683.04 55,930 74 1,0.27,387.69 000 1,0.27,387 69 06-01 2321 D21 Shea Homes T-5133 29,115.23 3102 14,590.54 401.92 14,992A.6 7901 4,518.03 10,474 43 39,589.66 39,589 66 2321 Total 29,115.23 14,590.54 . 0.00_ 401.92 000 14,992.46 4,518.03 10,474.43 39,589.66 0.00 39,589 66 07-01 2322 D22 Pardee Homes T-5045 Landscal 2,747.726.00 3102 2.02,836.81 36,205.76 172,044 00 4.11.086.57 7901 37,809 74 373,276.83 3.121,002._83 3,121.002 83 07-01 2322 D22 Pardee Home_s_T_-5045 Park Mai 28,160.15 3104 4,027.38 : 4,02738 4,027 38 32,187 53 32,187.53 _... . 2322 Total 2,775,886.15 2.0.6,864.19 0 00 36,205 76 172,044 00 4715.11195' - 3.7,809.74 377,304 21 3,153,190.36 000 3,153.190 36 2323 D23 SuncalN stas T-5130(not 5,259.11 : 3i02 65.76 65.76 606 5,324.87 5,32487 completed) 2323 Total 5,259.11 _ Goo _ 000 65.76 000 6576 0.00 65 76 5,324.87 0.00 5,32487 07-04 D2 2324 4 Casino Storage(Back-up) 21,599 76 • 3102 2.06 263 62 265.68 265.68 21,865.44 • 21.865.44 2324 Total 21,599 76 206 0.00 263.62 0.00 26568 0.00 265 68 21,865.44 006- 21,865 44 07-03 2325 D25 Nearon Village at Moorpark 6,557 09 3102 4.22 82.04 86.26 8626 6,64335 6,64335 (Back-up) 2325 Total 6,557.09 4.22 0.00 82.04 0.00 86 26 : 0.00 86 26 6,643.35 000 6,64335 - ---. .. . 09-01 2326 D26 Warehouse Discount Center 3,76732 47._11 47.11 47 11 3,814.43 . 3.814.43 2326 Total 3.767.32 0.00 0 00 47 11 0.00 47 11 _ 000 47.11 3,814.43 0 00 3,81443 10-01 2331 D31 Tuscany Square Park Lane& 000 11 88 11.88 11.88 11.88 11 88 Moorpark Ave CPD2005-02(Back- 2331 To_tal 0.00 0.00 0.00 : 11.88 0 00 11 88 0.00 11.88 11 88 000 11 88 10-02 2332 D32 HFR 145 Park Lane CPD2005- 11 88 03(Back-up) 0.00 11 88 11.88 11 88 : 11.88 2332 Total 0.00 0.00 0.00 11.88 000 , 11.88 0.00 11 88 11.88 0.00 11.88 Grand Total 6,428,535.00 : 1.200 111.18 302 567 37 84 378.63 1_73,986_M- 73 986 35 1,761,043 53 1,726,861_51 34,152 02 6,462,687.02 491,U3 24 6_,654,310 26 N J CD S%Finance\Ron FoldeMSSessment DiMno1201 0 2011 Assessment Dinncts110-11 Estimate for FY 0910 Actual'AD_09.10ACTUAL&10.11 ESTIMATE11111/2010/Page 2 of2 ATTACHMENT Page 1 of 2 CITY OF MOORPARK Assessment District-Lighting and Landscape F_and Activity: FY 201.0.12011 (ESTIMATE as of 10/28/2010) _ ESTIMATE PROPOSED ESTIMATE j ESTIMATE ESTIMATE - AD Fund Description Fund Balance, Re' Assmt Levy FY 10/11 Interest Others Total E"P Expenditures Net Revenue/ Fund Proposed Fund Beginning COe Transfers In Revenue Code (Expenditure) Balance, Transfers in Balance, (Adjusted) for FY 09/10 Ending FY 11/12 Ending After before Transfers - - • Transfers • 84-2 2300 Lighting (186,418.12). 3100 244,300.00 186,418 12 430,718.12 8901 378,000 00 52,718.12 (133,700 00) 133,700 00 000 84-2 2300 Improvements 0.00 - -_.. .. 0 00 0.00 0.00 . 000 - - � _. .. .. . . 84-2 2300 Landscaping (208,418.34) 31U -180,600.00 208,418.34 389,018.34 7901 408,230.00 (19,211.66)' (227,630.00) 227,630.00 0.00 7 02 2300 Total (394,836.46) 424,90&00 394,836 46 006 0.00 819.736 46 786,230.00_ 33,506 46 (361,330 00): 361,330 00 000- 84-2 2301 D1 Pecan Ave T-2851 9,212.18 3102 9,700.00 _9.70000 7901 18,760.00 (9,060 00) 152.18 152 18 __.. 2301 Total 9,212 18 9,700.00 000 0.00 0.00 9,700.00 18,760 00 9,060 0) 152 18 000 152.18 84-2 2302 D2.Steeple Hill Area T•2865 95,796.22 3,02 72,500.00 . 1,00000 ` 73 500 00 7901 84,996.00 (11,496.00) 84,300.22 84,300.22 84-2 2302 D2 Steeple Hill Area T-2865 Drains 16,048.35 3103 1,400.00 __ 1.40000 89 02 43400 96600 17,014.35 17,014 35 2302 Total 111,844.57 73,900 00 000 1,000 00 _0.00 74,900 00 85,430 00 (10,530 00 101,314 57 _ 0.00 ^ 101.31457 _. -- - - 84-2 2303 D3 Buttercreek/Peppermlll T-3023 (6,180.60). 3102 3,10000 6,18060 9.28060 7901 10 360.00 (1,079.40). (7,260 00) 7,26&00 0.00 2303 Total (6,18060) 3,100.00 6,180.60 0.00 : - 0.00 9,28060 10,360.00 (1,07940) (7,26000). 7,260.00 0.00 _. _ 84-2 2304 D4 Williams Ranch Rd T-3274 (9,394.75)' 3102 6,500 00 9,394 75 15,894 75 7901 15.710.00 18.475 (9,210.00) 9,210.00 660 ----- 2304 Total (9,394 75) 6,500.00 9,394.75 000 ! 0.0.0 15,894.75 15,710.00 184.75 (9,210.00 9,210 00 000 84-2 2305 D5: Pheasant Run Area T-3019/3525 (33,789 22) 3102 23.500 00 33,789.22 57,289.22 7901 64,556-0-0 (7,266.78) (41,056.00) 41,056 00 0.00 ---- _ 84-2 2305 D5 Pheasant Run Area T-3019/3525 1,712 67 3103 500.00 500.00 8902 434.00 6600 1,778.67 1,77867 Drains _ 2305 Total (32,076.55) 24,000 00 33,789.22 57,78922 64,990.00 (7,200 78)' 41,056.00 1,77867 84-2 2306 D6 Inglewood St T-3306 (5,165 12) 3t02 1,000.00 5,165.12 6.165.12 7901 5,370.00 79512 (4,370.00)' 4,370.00 000 -. - 2306 Total (5,16512) 1,000.00 5,165.12 000 0.00_ 6,16512 5,370.00 795.12 4,37000 4,37000 0.00 84-2 2307 07: Moorpark Business Park(LA Ave (11,525 76) 3102 11,300.00 11,525.76 22,825 76 7901 27,160 00 (4,334 24): (15,860.0) 15,860 00 0.00 &Gabbert) 2307 Total (11,525.76)_ - 11,300.00 76 0.00 0.00 22,825 76. 27,160.00 (4,334.24) (15,860.00). 15,860 00 0.00 84.2 2308 D8: Home Acres Buffer 19,097.06 3t02 15,300.00 19,097.06 34,397 06 7901 43,253.00 (8,855,94)_. 27,953.00 27,953.00 0.00 2308 Total (19,097 06L_ 15,300 00 19,097.06 0.00 0.00 34,397.06 43,253 00 _ (8,855.94) (27,953.00). 27,95300 000 84-2 2309 D9 Moorpark Industrial Park(Condor (6,508.52) 3102 1,400.00 6.50852 7,908.52 7901 7,540.00 368.52 (6,140.00) 6,140.00 0.00 Drive) 2309 Total --- - - -_ _ __... _ _(6,508 52) 1,400.00 _ 6.508 52 __ 0.00 0.00 7,908.52 7 540.00 368.52 (6,140.00): 6,140.00 _ 0.00 84-2 2310 D10 Mountain Meadows PC-3 14,026.32 3102 194,000 00 1,000.00 195,000.00 7901 237 330.00 (42,330.00) (28,303 68� (28 303.68) _.... - ------ ----- - 84-2 2310 D10 Mountain Meadows PC-3 Drains 34,565 27 3103 ' 7,500.00 7,500.00 8902 5,247.00 2,25300 36,818.27 36.818.27 2310 Total 48,591.59 201,500.00 0.00 1,000 00 0.00 202,500.00- 242,577.00 X40 077.00) 6_514-!591 U0 8,514.59 84-2 2311 D11 Alyssas Ct T-4174 2,498.18 3102 3,000.00 _ 3,000 00 7901 4,630.00 (1,630.00) 868.18 868.18 - 2311 Total_ 2,498.18 3,000.00 0.00 0.00 000 3,000.00 4,66-.6o __ 1.630.0) 86818 0.00_ 868.18_ 84-2 2312 D12 Calrsberg Specific Plan Area 417,093.46 : 31oz 266,800.00 6,000.00 272,800.00 7901 2- - - -..__... -- - -- 2312 Total 417,093 46 266,800.00 0 00 6,000.00 0.00 272,800 00 239,221.00 : 33,579.00 450,6.7.2 46__ 0 00_ 450,672.46 84-2 2313 D13 unassigned OAO 0.00_ 6-66 0.00 0.00 _ - 2313 Total 0 00 ado. 0.00 0.00 0.00 000 0.00 0.00 0.00 0 00 0.00 .. .--- ..._._. --3- -'-- ... - -----1--- ----- --- j--------.... _..... 01-1 2314 D14:Wilshire Builders T-5201 5,125 75 31°2 1,500.00 5,125.75 : 6,62575 79a1 5,410.00 ! 1,215 75 1 3,91_0.00 ! _3,910 00 . 0.00 2314 Total 5,125.75 1,500.00 5,125 75 0.00 000 : 6,625.75 5,410 00 i 1,215.75 3,910.00 3,910.00 0 00 _. . _._. ( __�. - -- - --.....__ - ( ._.. �. . 01-2 2315 D15:Toll Brothers T-4928 1,931,111.96 3102 59,400.00y 20,000.00 79,400.00 7901 145,32.2 X65,922 00) 1,865,189.96 1,86_5,189.96 - ----.. -11 - _ _.. -- 2315 Total 1,931,111.96 59,400.00 0.00 20_,000.00 L 0 00 79,400 00 _ 145,322.00 (65 922.00)1 1,865,189 96 0.00 i 1_,865,189.96 01.3 2316 D16 Cabrillo T-5161_ 40,291.72 3102 2600.00 _ 2,600.00 790' 16,010.00 X3,410._0_0) 26,881 72 _26,881.72 --- _.. _ _.... .. 01-3 2316 D16 Cabrillo T-5161 Drains 46,273.99 3103 ? -� 0 00 8902 5,000.00 (5,000 00)' 41,273.99 41,273.99 2316 Total 2.60000 _.- 86,565 71 0 00 0.00 ' _ 2,600.00 21,010.00 (18,410.00). 68,155.71 0.00 68 155.71 _ _ _ _.. . 2317 D17 unassigned 0 00 _ _ 0.00 0.00 0.00 0.00 2317 Total 0.00 0.00 0 00 0 00 0 00 0.00 0 00 0 00 0 00 000 0,00 ---._ ----...... 04-1 2318 D18 Colmer T-5307 31,920 77 3102 2,300.00 1,000.00 3,300.00 7901 16,370.00 _C13_,070.00) 18,850 77 1 18,850 77 04-1 2318 D18.Colmer T-5307 Drains 18,727.43 31.03 0 00 8902 0.00 000 18,727.43 18,727 43 2318 Total 50,648 20 2,300.00 000 1,00000 00 0 00 3,300.00 16,370.00 (13,070.0 37,578 20 000 37,578.20 05-01 261'9 1519:M&M PM-52.6.4(Back-up) 37,192.18 3102 _. . _ 0 00 7901 000 37,192.18 37 192.18 - _._. 2J4�Total 37,192 18 0.00 000 0 00 000 0.00 0.00 0.00 37 192.18 000 37,192 18 S TinanceVRon Foider%ssessment Oistnct\2010.2011 Assessment Distnct3110-11 Estimate for ry 09.10 ActuarAD_09-10ACTUAL&10-11ESTIMATE111/1/2010/Page 1 oft ATTACHMENT 3 Page 2 of 2 CITY OF MOORPARK Assessment District-Lighting and Landscape Fund Activity: FY 2010/2011 (ESTIMATE as of 10/28/2010) (. - ESTIMATE PROPOSED ESTIMATE i ESTIMATE ESTIMATE AD Fund Description Fund Balance, a• Assmt Levy FY 10111 Interest Others Total EaP Expenditures Net Revenue I Fund Proposed Fund Beginning code Transfers In Revenue ceae (Expenditure) Balance, Transfers in Balance, (Adjusted) for FY 09/10 Ending FY 11/12 Ending After before Transfers Transfers 07-2 2320 D20 Lyon Homes T-5187 1,027,387.69 J102 58,200 00 10,000 00 68,200 00 7901 201,599 00 (133,399.00) 893,988.69 893,988.69 2320 Total 1.027.387.69 58,200 00_ 0 00 _10,00.0 00 0.00 68,200.00 2.01,599 00 (133,399.00) 893,988 69 000 8.93,988 69 06-01 2321 D21 Shea Homes T-5133 39,589.66 7102 6,100 00 6.100 00 7901 18.160.00 (12,060 00) 27,529 66 27,529 66 -- 2321 Total 39,589.66 _ 6,100.00 _.00 000 0.00 j 0 00 6,100 00 18,160.00 (12,060 00) 27,529.66 boo 27,5_29 66 07-01 2322 D 50 22 Pardee Homes T- 45 3.121,002 83 3102 171,500 00 29,000.00 200.500 00 7901 534,775 86 .00 (334,275.00) 2.786,727.83 2.7N. 83 Landscape 07-01 2322 022 Pardee Homes T-5045 Park 32,187 53 310' 000 000 32,187 53 32,187 53 Maint 2322 Total 3,153,190.36 ' 171,500.00 0.00 29,000.00 000 200,500.00 534,775 00 (334,275 00).2,818,915 36 0 0.0-..2..818-,91.53.6 2323 D23 SuncalNistas T-5130(not 5,32467 3102 000 000 5,324.87 5,324.87 completed) 2323 Total 5,32487 &00 0.00 0100 0.00 000 0.00 -600 5,32487 0.00 5,32487 07-04 2324 _D24 Casino Storage(Back-up) 21,865.44 31 02 000 0.00 21,865.44 21,865.44 2324 Total 21,86544 0.00 0.00 0 00 0.00 0.00 0.00 0.00 21,865.44 0 00 : 21,865.44 07-03:2325 625 Nearon Village at Moorpark 6,643 35 7102 000 0.00 6,643.35 6,643.35 (Back-up) _. .._._ 2325 Total 6,643.35 0.00 0 00 066 0.00 0.00 0.00 ; 0.00 6,643.35 0._00_ 6,643.35 09-01 2326 .026 Warehouse D scount Center 3,814.43_ __ 0 00 0 00 3,81443 3.814-43 .2326 Total 3,81443 000 0.00 000 0.00 0.00 0.00 0.00 3,814.43 0.00 3,814.43 10-01 2331 631 Tuscany Square Park Lane& 11.88 0.00 . 0.00 11.88 11.88 Moorpark Ave CPD2005-02(Back- up) 2331.Total 11 88 0.00 0.00 0 004; 0 00 0 00 0.00 0.00 11.88 &00t 11.88 10-02.2332 1532 HFR 145 Park Lane CPD2005- 11.88 060 0.00 11.88 11.88 03(Back-up) 2332 Total- 11 88 0 00 0.00 0.00 __ _ 0 00 000 0,00 -0.00 11 88 0.00 11.88 Grand Total 6,462 687 02 1 344 000.00 491 623.24 68,6-6-6-661-- 8 000 00 0.00 1,903,623.24 2 493 877.00 (590,251T6) 5,872.433.26 477 089.00 6,349,522.26 DO O S%Financ\Ron FoideAAssessment Oistna12010-201�Assessment DistnCiWG I I Estimate for FV 09 10 ActuahA0 09 10ACTUAL&10-11ESTiMATE/11n2010/Page 2 o2