Loading...
HomeMy WebLinkAboutAGENDA REPORT 2011 1116 CC REG ITEM 10DMOORPARK CITY COUNCIL AGENDA REPORT ITEM 10.1). City Council 1v,eetina TO: The Honorable City Council FROM: Ron Ahlers, Finance Director By: Irmina Lumbad, Budget and Finance Manager' DATE: October 31, 2011 (CC Meeting of November 16, 2011) EV SUBJECT: Consider Resolution Amending the Fiscal Year 2011/2012 Budget and Authorizing the Transfer of Gas Tax and General Funds to Cover Fiscal Year 2010/2011 Year -End Deficits in Certain Funds for the City's Landscaping and Lighting Assessment Districts BACKGROUND On June 1, 2011, the City Council approved the assessments for the City's Landscaping and Lighting Districts for fiscal year (FY) 2011/2012. In the staff report accompanying that action, it was mentioned that certain Assessment District Funds were projected to show a FY 2010/2011 year -end deficit. Continuing the policy from last year, the projected FY 2010/2011 deficits were funded in the adopted budget for the succeeding FY 2011/2012. It was also mentioned in the report that, when the actual FY 2010/2011 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 201012011 Year -End Deficits Attachment 2 (Pages 1 & 2) is a schedule showing the Fund Activity for the Assessment District Funds for FY 2010/2011. Certain Funds show a year -end deficit, summarized as follows: 41 Honorable City Council November 16, 2011 Page 2 Total ($491,623) $491,623 $493,052 $888,982 ($395,930) Note: ' Landscaping deficits B. Proposed Adjustments During the budget development for FY 2011/2012, assessment districts were projected to have an aggregate deficit of $455,732 and budgeted transfers from the General Fund and Gas Tax were estimated to be: FY 10/11 From From Total FY 10/11 Transferred to Fund: Beginning Transfer In Projected Deficit 2300: Ending Fund Balance Dec -2010 Revenue Expenses Balance 2300: Citywide - Street Lighting ($186,418) $186,418 $246,661 $381,279 ($134,618) 2300: Citywide- Landcaping ($208,418) $208,418 $181,543 $372,934 ($191,391) 2303: Dist 3 Buttercreek/Peppermill' ($6,181) $6,181 $3,100 $5,742 ($2,642) 2304: Dist 4 Williams Ranch Road' ($9,395) $9,395 $6,500 $13,975 ($7,475) 2305: Dist 5 Pheasant Run Area' ($33,789) $33,789 $23,500 $44,655 ($21,155) 2306: Dist 6 Inglewood Street' ($5,165) $5,165 $1,220 $4,781 ($3,561) 2307: Dist 7 Moorpark Business Park' ($11,526) $11,526 $12,304 $22,299 ($9,995) 2308: Dist 8 Home Acres Buffer' ($19,097) $19,097 $15,300 $32,718 ($17,418) 2309: Dist 9 Moorpark Industrial Park' ($6,509) $6,509 $1,400 $5,786 ($4,386) 2314: Dist 14 Wilshire Builders' ($5,126) $5,126 $1,524 $4,813 ($3.289) Total ($491,623) $491,623 $493,052 $888,982 ($395,930) Note: ' Landscaping deficits B. Proposed Adjustments During the budget development for FY 2011/2012, assessment districts were projected to have an aggregate deficit of $455,732 and budgeted transfers from the General Fund and Gas Tax were estimated to be: Note: ' Landscaping deficits C>Vi From From Total To be Transferred to Fund: Gas Tax Fund General Fund Projected Deficit 2300: Citywide - Street Lighting ($140,700) $0 ($140,700) 2300: Citywide - Landcaping ($110,848) ($101,548) ($212,396) 2303: Dist 3 Buttercreek/Peppermili' ($2,665) ($2,665) ($5,329) 2304: Dist 4 Williams Ranch Road' ($4,065) ($4,065) ($8,129) 2305: Dist 5 Pheasant Run Area' ($16,612) ($16,612) ($33,224) 2306: Dist 6 Inglewood Street' ($1,902) ($1,902) ($3,804) 2307: Dist 7 Moorpark Business Park' ($6,777) ($6,777) ($13,554) 2308: Dist 8 Home Acres Buffer' ($10,106) ($10,106) ($20,211) 2309: Dist 9 Moorpark Industrial Park' ($2,475) ($2,475) ($4,949) 2310: Dist 10 Mountain Meadows' ($5,089) ($5,089) ($10,177) 2314: Dist 14 Wilshire Builders' ($1.630) ($1,630) ($3,259) Total ($302,866) ($152,866) ($455,732) Note: ' Landscaping deficits C>Vi Honorable City Council November 16, 2011 Page 3 Based on the budgeted transfers, the Gas Tax Fund is expected to have a fund balance surplus of $105,685 at the end of FY 2011/2012. Customarily, the street lighting deficit is funded by the Gas Tax Fund, and the deficits in the various landscaping districts are funded 50 -50 by the General Fund and the Gas Tax Fund. However in FY 2010/2011 when we eliminated the actual FY 2009/10 deficits, we modified the funding scheme to prevent the Gas Tax Fund from incurring a deficit fund balance. The lighting district's shortfall was subsidized similar to the landscaping deficits. The actual FY 2010/2011 gap is $59,802 less than expected. The appropriations will be adjusted accordingly; the Gas Tax Fund will be reduced by $37,592 while General Fund will be decreased by $22,210. Using the traditional funding policy, the FY 2010/2011 assessment districts' actual deficit of $395,930 will require the transfers from the Gas Tax Fund and General Fund as follows: To be Transferred to Fund: 2300: Citywide - Street Lighting 2300: Citywide - Landcaping 2303: Dist 3 Buttercreek /Peppermill' 2304: Dist 4 Williams Ranch Road' 2305: Dist 5 Pheasant Run Area' 2306: Dist 6 Inglewood Street' 2307: Dist 7 Moorpark Business Park' 2308: Dist 8 Home Acres Buffer' 2309: Dist 9 Moorpark Industrial Park' 2314: Dist 14 Wilshire Builders' Note: ' Landscaping deficits From From Total Gas Tax Fund General Fund Actual Deficit ($134,618) $0 ($134,618) ($95.696) ($95,696) ($191.391) ($1,321) ($1,321) ($2.642) ($3,737) ($3,737) ($7,475) ($10,578) ($10,578) ($21,155) ($1,781) ($1,781) ($3,561) ($4,997) ($4,997) ($9,995) ($8,709) ($8,709) ($17,418) ($2,193) ($2,193) ($4,386) ($1,644) ($1,644) ($3,289) Total ($265,274) ($130,656) ($395,930) 43 Honorable City Council November 16, 2011 Page 4 C. FY 2011/2012 Projected Deficits Compared to FY 2010/2011, it is anticipated that the Landscaping and Lighting Maintenance District Funds will show a higher deficit amount at the end of FY 2011/2012, from $395,930 to $610,900. This projection already factored in the reduced landscaping contract rates. On June 1, 2011 the City awarded the districts' landscaping contract to the lowest bidder, Azteca Landscape. Pending any other changes to the spending plan, staff expects to realize an aggregate savings of $363,506 from all districts or a reduced transfer of $125,585 as shown in the FY 2011/2012 Fund Activity chart Attachment 3 (Pages 1 & 2). The estimated amounts are summarized as follows: Total ($386,486) $395,930 $693,200 $1,313,544 ($610,900) Note: ' Landscaping deficits 2 Expenses reflect reduced landscaping contract rates It is likely that the Gas Tax Fund will not have enough fund balance to support the projected FY 2011/2012 year -end deficit. Thus, the $610,900 will need to be funded by General Fund transfers in FY 2012/2013 or further service or cost reductions will need to be implemented. lrxl FY11/12 FY11/12 Beginning Transfer In Ending Fund Balance Dec -2011 Revenue ExpensesZ Balance 2300: Citywide - Street Lighting ($134,618) $134,618 $244,300 $395,000 ($150,7001 2300: Citywide - Landcaping ($191,391) $191,391 $180,600 $431,508 ($250,908) 2301: Dist 1 Pecan Ave T -2851 $3,899 $0 $9,700 $18,113 ($4,514) 2303: Dist 3 Buttercreek /Peppermill' ($2,642) $2,642 $3,100 $9,401 ($6,301) 2304: Dist 4 Williams Ranch Road' ($7,475) $7,475 $6,500 $11,896 ($5,396) 2305: Dist 5 Pheasant Run Area' ($21,155) $21,155 $23,500 $72,456 ($48,956) 2306: Dist 6 Inglewood Street' ($3,561) $3,561 $1,000 $3,801 ($2,801) 2307: Dist 7 Moorpark Business Park' ($9,995) $9,995 $11,300 $24,731 ($13,431) 2308: Dist 8 Home Acres Buffer' ($17,418) $17,418 $15,300 $48,054 ($32,754) 2309: Dist 9 Moorpark Industrial Park' ($4,386) $4,386 $1,400 $6,097 ($4,697) 2310: Dist 10 Mountain Meadows' $5,544 $0 $195,000 $287,967 ($87,423) 2314: Dist 14 Wilshire Builders' ($3,289) $3,289 $1,500 $4,519 ($3,019) Total ($386,486) $395,930 $693,200 $1,313,544 ($610,900) Note: ' Landscaping deficits 2 Expenses reflect reduced landscaping contract rates It is likely that the Gas Tax Fund will not have enough fund balance to support the projected FY 2011/2012 year -end deficit. Thus, the $610,900 will need to be funded by General Fund transfers in FY 2012/2013 or further service or cost reductions will need to be implemented. lrxl Honorable City Council November 16, 2011 Page 5 FISCAL IMPACT The attached Resolution amends the FY 2011/2012 budget by revising the appropriated amounts of the fund fransfers to equal the actual FY 2010/2011 year -end deficits. There will an aggregate appropriation decrease of $59,802 as described below: Gas Tax Fund General Fund TOTAL FY 2011/2012 Budget $302,866 $152,866 $455,732 FY 2010/2011 Actual $265,274 $130,656 $395,930 Budget Adjustment ($37,592) ($22,210) ($59,802) As stated in this report, combined Gas Tax and TDA Article 8 fund balance will probably not be available to fund these deficits beginning next FY 2012/2013 due to other street expenditures. This will require more funding from the General Fund Reserve unless assessment revenue is increased or services reduced. STAFF RECOMMENDATION (Roll Call Vote) Adopt Resolution No. 2011 - Attachments: 1: Resolution 2: FY 2010/2011 Actual Fund Activity 3: FY 2011/2012 Estimated Fund Activity 45 ATTACHMENT 1 RESOLUTION NO. 2011 - A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF MOORPARK, CALIFORNIA, AMENDING THE FISCAL YEAR 2011/2012 BUDGET TO APPROVE CERTAIN APPROPRIATIONS AND FUND TRANSFERS FROM THE GENERAL FUND (1000) AND THE GAS TAX FUND (2605) REQUIRED TO FUND FISCAL YEAR 2010/2011 YEAR -END DEFICITS FOR CERTAIN ASSESSMENT DISTRICT FUNDS AND TO APPROVE REVENUE BUDGET INCREASE FOR NEW ASSESSMENT DISTRICTS AS DEFINED HEREIN WHEREAS, on June 1, 2011, the City Council adopted Resolution No. 2011 -3029 approving the Engineer's Report; confirming diagram and assessment; and ordering the levy of assessments for fiscal year (FY) 2011/2012 for the City Landscaping and Lighting Maintenance and Assessment Districts (AD); and WHEREAS, on the same meeting date, the City Council adopted the Operating and Capital Improvement Budget for FY 2011/2012, which includes $455,732 in Gas Tax and General Funds, to cover the FY 2010/2011 deficits in certain AD Funds; and WHEREAS, a staff report has been presented to the City Council summarizing the actual FY 2010/2011 fund deficits of $395,930 in various Assessment District Funds; and the same report is requesting an aggregate appropriations decrease of $59,802 in the Gas Tax and General Funds to match the required fund fransfers 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 $395,930; and WHEREAS, Exhibit "A ", attached hereto and made a part hereof, describes said budget amendments and the resultant impact to the budget line items. NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF MOORPARK DOES HEREBY RESOLVE AS FOLLOWS: SECTION 1. That a Budget Amendment in the aggregate appropriation decrease of $59,802, as more particularly described in Exhibit "A ", is hereby approved. SECTION 2. That a fund transfer in the aggregate amount of $395,930 as particularly described in Exhibit "A °, is hereby approved. OR SECTION 3. 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 16th day of November, 2011. Janice S. Parvin, Mayor ATTEST: Maureen Benson, City Clerk Attachment: Exhibit'A': Budget Amendment and Fund Transfer Detail 47 Exhibit A Budget Amendment for Gas Tax and General Funds to Adjust Transfers Required to Fund FY 2010/2011 Year -End Deficits In Certain Assessment District Funds FY 2011/2012 A. Fund Allocation Fund No. Fund Description Amount 1000 General Fund $22,210 2605 Gas Tax Fund $37,592 $152,866 Total $59,802 B. Fiscal Year 2011/12 Budget Appropriation Budget Number Adopted Budget Budget Revised Budget FROM: Fund 2605 Fund 1000 Total 1000 - 7900 - 000 -9820 $152,866 $95,696 $130, 656 2605- 7900 - 000 -9820 $302,866 $1,321 $265,274 Total $455,732 $5, $395,930 2305 -3720 $10,578 $10,578 $21,155 TO: $1,781 $1,781 $3,561 2300 -3720 (Lighting) $140,700 $6,082 $134,618 2300 -3720 (Landscaping) $212,396 $21,005 $191,391 2303 -3720 $5,329 ($2,687 ) $2,642 2304 -3720 $8,129 $654) $7,475 2305 -3720 $33,224 $12,069 $21,155 2306 -3720 $3,804 $243 $3,561 2307 -3720 $13,554 $3,559 $9,995 2308 -3720 $20,211 $2,793) $17,418 2309 - 3720 $4,949 $563 $4,386 2310 -3720 $10,177 $10,177 $0 2314 -3720 $3,259 $30 $3,289 Totall $455,732 $59,802 $395,930 C. Appropriation Allocation To Be Transferred to: From From Fund Fund 2605 Fund 1000 Total 2300 -3720 $230,314 $95,696 $326,009 2303 -3720 $1,321 $1,321 $2,642 2304 -3720 $3,737 $3,737 $7,475 2305 -3720 $10,578 $10,578 $21,155 2306 -3720 $1,781 $1,781 $3,561 2307 - 3720 $4,997 $4,997 $9,995 2308 -3720 $8,709 $8,709 $17,418 2309 -3720 $2,193 $2,193 $4,386 2310 -3720 $0 $0 $0 2314 -3720 $1,644 $1,644 $3,289 Total $265,274 $130,656 $395,930 • IN M.e • M SE ATTACHMENT S T,nanceOon FoldenAssessment Distnct12011 -2012 Assessment 0,SmOwLMDVAD_1 G 11 ACTUAL ✓i 11 12ESTIMATE c2fU11 /11201!,Page 1 oft rage 1 or z CITY OF MOORPARK ;A i a _ _ Fund Activity:.._ A_ 7/2011) _ . _.. .... ._ _ . . _- ..:._.. ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL AD Fund - Description Fund Balance, Rev Assmt Levy ; FY 10/11 Interest Others Total I EIP Expenditures Net Revenue I Fund Proposed Fund Beginning code Transfers In Revenue Code (Expenditure) Balance, Transfers in Balance, for FY 09110 I I Ending FY 11112 Ending After before Transfers 84 -2 2300 _ L�( hung (186,418 12) 3100 246,660.62 186,418.12 -- 433,078.74 8901 I 381,278.51 ---L- 51,800.23 f X34,617.89) _ 134,61789 000. 84 -2 2300 ILandsca In Landscaping (208.418.34) 3102 rt 181,094.69 - 208,418.34 447 82 _.. __ .__ 389,960.85 . -. 7901 _ 372,933.84 -. 17.027.01 -. (191,391.33) 191,391.33 0 00 -T- 2300 otal -_ (394,836 46)' 3100 427,755 31 ' - 394,836 46 - - - 0 00 447.82 823 039 59 .7902.: 754,212 35 68 827.24 X326,009 22) 326,009 22 060 84 -2 2301 . D1: Pecan Ave T -2851 _ -- 9,212 18 3,oz 9,930 52 79.12 10 009.64 7501 15,322.70 (5,313 06�r 3,899.12 3.899 12 2301 Total - - 9:212 18 ° 9,930 52 0 00 79 12 0 00 10,009 64 15,322 70 _ (5 313.06 _ 3,899 12 0 0C 3.899 12 84-2 2302 D2 Steeple Hill Area T -2865 95,796.22 3102 - 72,500.00 - _ 1,614_.52 74,114 52 _ 7901 76.546.94 (2,432.42 93.363 80 84 -2 2302 D2 Steeple Hill Area T -2865 Drains 16,048.35 7103 1,406-66 1,40060 89° 2 433 14 66 9.86 ' _93,363.80 17,015.21 17,015 21 2302 Total 111,844.57 C 73,900.00 ' _ 0 00 1--l-,614,-52 000 75,514 52 76,980 08 (1,465,561 110,379 01 000 110.379 01 84 -2 2303 D3. Buttercreek/Peppermill T -3023 - (6,180 60) 3102 3 100.00 6,180 60 , 9,280 60 7901 5,742 00 3 538.60 (2,642.00) 2.642 00 0 00 ,2303 Total (6,180 60) _ 0 0. 3,100 00 - 6,180.60 0._00 000 9,280.60 5,74200 . _ 3,538.6_0 ^ (2,642.00): 2.642.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 13,974 98 1.91_9 77 X7,474 98) 7,47498 000 2304 Total (9,394.75) 0 6,500 00 9,39435 0.00 0.00 15,894.75 13,974.98 1,91917 (7_474 98 7.474.98 0.00 84-2 2305 D5: Pheasant Run Area T- 3019/3525 - (33,789.22) 3102 23,500.00 _ 33,789 22 - 57 289 22 7901 44,655 38 12,633 84 l x,155 38), 21,155 38 0.00 84 -2 2305 65 Pheasant Run Area T- 3019/3525 1,712 67 3103 500.00 - . 500.00 eeoz 433.14 -. 66.86 1,779.53 1.779.53 Drains •2305 Total (32,076.55) ° 24 000.00 33,789.22 0.00 0.00 57,789.22 45.088.52 12 700.70 j 21,155 38 1,779.53 84 -2 2306 D6. Inglewood St T -3306_ (5,165 12) 31 °2 1 000 00 5,165.12 22008 6,385.20 r 7901 4,781 43 1,60377 _C19,375.85) 3,561 35) 3 561 35 0.00 2306 Total (5.165.12) 0 - 1,000.00 - - 5,165.12 0.00 22008 6.385.20 4,781.43 1,603.77 _ X3,561 35), 3,561.35 000 84 -2 2307 D7 Moorpark Business Park (LA Ave (11,525 76) 3' °2 12,304.40 11,525.76. 23,830.16 7901 22,299.06 1,531.10 (9,994.66) 9.99466 000 2307 Total _ (11,525.76)_ ° 12 304.40 i - - 11,525 76 0.00 _. 0 00 23,830 16 22.299 06 1,531.10 I (9.994 66)_ 9.99466 . 000 84-2 2308 D8 Home Acres Buffer _. (19.097.06) 3••02 _ 15 300.00 19,097.06 -- - - - 34 397.06 7901 - 32,717.64 1,679.42 (17,417 64) 17,417.64 000 2308 Total - - -- (19.097.06) 0 15,300.00: . 19,097.06. 0 00 0.00 34,397.06 32,717 64 1,679.42 X17,417 64) 17.417 64 000 84 -2 •2309 .D9 Moorpark Industrial Park (Condor (6,508 52) 3102 1,400.00 6,508.52 ! - 7,908.52 7901 5.785 93 2.122.59 (4,385 93) 4,385.93 000 Drivel 2309 Total (6,508.52) 0 1,400.00 6,508.52 000 0.00 7,908.52. 5,785 93 . 2,122.59 4,385.93)_ 4,38593 000 84 -2 2310 D10: Mountain Meadows PC -3 14,026 32 3t02 194.000.00: 616 18 1.31493 195,931.11 79p1 204,412.99 (8.481 88)� 5,54444 5.54444 84 -2 2310 •D10: Mountain Meadows PC -3 34,56527 3103 7,500 00 7,500.00. 8902 5,219.34 2,280.66 36,845.93 36.845 93 Drains 2310 Total 48,591.59 0 20.1,500.00 0.00 616.18 1.31493 203,431.11 209,632.33 (6.201.22) 42;390.37 000 42,390.37 84 -2 2311 'D11: Alyssas Ct T -4174 -- 2498 16 31 oz 3,000.00 _ 24.45 3 024.45 7901 3.857.17 (832.72) 1,665.46 1,66546 - 2311 Total - - 2,49818 0 3,000.00 _ .. _ 0.00 ' 24.45 0.00 3,024 45 3,857.17 (832 72L 1,665.46_ 0 00 1.665 a6 84 -2 2312 'D12 CalrsbersSpecific Plan Area 417,093.46. 3102 266,800.00 6,488.98 273 288 98 7901 166,425 24 106,863.74 523,957.20 523,957.20 2312 Total _ 417,093 46 0 266,800.00 0.00 -. ...- 98 0 00 273 288.M 166,425.24 106,863 74 523,957.20 000 523,957 20 84 -2 2313 D13 unassigned - - 0.00 _6,4.88. _ 0.00 - - 0.00 - - _ 0.00 000 2313 Total 6 00 0 0 00 I 0.00 000 000 0 00 0.00 0.00 _ _ 0 00 000 000 01-1 2314 D14: Wilshire Builders T -5201 - (5.125.75)' 3102 1,524.36 5,125 75 _ 6,650,11 7901 4,81297 1,837 14 (3,28_8 61). 3.288.61 000 2314 Total - (5,125.75) 0 1,524413 5,125 75 000 000 6,650 11 i. 4,812'97 _ 1 837 14 j x,288 61) 3. 288 61 0.00 01 -2 2315 D15 Toll Brothers T-4928 - - 1,931,111.96 - 3102 62,113 99 -.. - 25,293 72 87 407.71 790' 142.411.82 X55 004.11) 1,876,1_07.85 1,876 10765 2315 Total 1,931.111.96 0 62,113.99: 0.06 ; 25,293.72 000 87,407.71 142,411.82 (55,004.11)1 1,876,107.85 000 1,876.107 85 01 -3 2316 D16 Cabrillo T -5161 40,291.72 31oz 2,797.92 _ _. _ 1 086.05 3,883.97 7901 10,909 14 (7.025 17) 33,266.55 33,266 55 01 -3 Cabrillo 2316 D16 Cabrillo T -5161 Drains 46.273 99 3103 0.00 8902 000 0.00 -- - 46,273.99 46,273 99 2316 Total - 86,565.71 0 2,797_.92 0.00 1,08605 000 3,88.3.97 10,909 14 (7,025 17). 79_540.54 000 79,540 54 2317 D17 unassigned -- - 0.00 _ .. 0.00 0.00 0 00 0 00 _2317 Total - 06b 0 0.00 . 0.00 0.00 000 - - 0.00 000 0 00 00 000 000 64 -1 2318 D18 Colmer T -5307 - 31,920.77 3102 2,375.39 - _ 606.36 2,9__81.75 79 °1 10,846.93 _ (7,865.1_8) _0 24,055.59 24,055 59 04 -1 2318 D18 Colmer T -5367 Drains -- 18.727.43 3703 -_ .. 0 00 8902 000 000 ; 18,727.43 18,72743 23 Total 50,648 20 0 2,375.39 0.00 606 36 000 2,981.75 • 10,846.93 (7,865 18)� 42,783.02 000 42,783 02 05-61'23,19 D19 M &M PM -5264 (Back -up) 37,192.18 3102 492.25 492.25 7901 0.00 492.25_ 37,684.43 37,684 43 2.319 Total 37.192 18 0 0.00 0.00 492.25 0.00 _: 492.25 000 492 25 37,684 43 000 37,684 43 07 -2 320 D20 Lyon Homes T -5187 1 027 387.69 3102 58 421.22 13 947.79 72,36901 7901 11,40362 60 965 39 1.088 353.08 1.088 353 08 S T,nanceOon FoldenAssessment Distnct12011 -2012 Assessment 0,SmOwLMDVAD_1 G 11 ACTUAL ✓i 11 12ESTIMATE c2fU11 /11201!,Page 1 oft ATTACHMENT tz or A CITY OF MOORPARK I 1,027,387.69 _0 - . _.. _......_.... -_ _... Assessment District- Lighting and Landscape 6,709.81 2321 Total - 39,589.66 0 Fund Activity: FY 2010/2011 (ACTUAL as of 10/27/2011) - - AcruAC 176,875 32 - Fund Balance, , ACTUAL ACTUAL - ACTUAL ACTUAL Assmt Levy FY 10/11 Interest Others Total a I Expenditures Net Revenue / Fund -- Proposed Fund AD Fund Description � 4 101.02 Revenue (Expenditure) Balance, Transfers in Balance, i Beginning Transfers In Ending FY 11/12 Ending After 2323 D23: Suncal/Vistas T -5130 (not for FY 09/10: before Transfers 2320 Total I 1,027,387.69 _0 58,421 22 06 -01 2321 .D21: Shea Homes T -5133 39,589.66 1 3102 6,709.81 2321 Total - 39,589.66 0 6,709.81 07-01'2M D22 Pardee Homes T -5045 3,121,002.83 3102 176,875 32 Landscape 11 403.62 _ 60,965.39 7-01'M2 D22 Pardee Homes T -5045 Park 32,187.53 3104 4 101.02 Maint r _ _ 2322 Total 3,15.3,190.36 _ 6 180.976.34 2323 D23: Suncal/Vistas T -5130 (not 5,324.87 3102 44.546 47 completed) 551 46 0.00 - 2323 Total 5,324.87: ° 0.00. OT-04'M4 D24: Casino Storage (Back -up) 21,865 44 3102 - - 44,546 47 2324 Total 21 865 44 0 x162 0.00 07- 032325 D25 Nearon Village at Moorpark 6,643.35 I (300,798 41) (Back -up) 2.820,204 42 2325 Total 6,643.35 0 0.00 09-01­2306 D26 Warehouse Discount Center 3,814.43 1 500.23 _.. - 2326 Total _3,814_43+ ° - 500.23 10 -01 2331 D31 Tuscany Square Park Lane & 11.88 50623 Moorpark Ave CPD2005 -02 (Back - - 516,934.39 (296,697.39) up) - - -- -= - - 2331 11.88 ! °_ 50023 _Total 10 -02 2332 2 HFR 145 Park Lane CPD2005- D3 11.88 250.23 03 (Back -up) 5,39534 2332 Total _ _11.88' ° _ 250.23 Grand Total 6,462,687.02 J100 1,362,659,95 49 U'l CD S T,nanceVRon FowenAssessment 0,stca',2011 -2012 Assessment C�sncts�MUwD_1C 11ACTUAL 6 11.12ESTIN1ATE_araf7t 1nrO1Image 2 02 I 0.00 13,947 79 0.00 72,369 01 - 11 403.62 _ 60,965.39 1,.088,353.08-. 0.00 1,088,353 08 y __ 551 46 7,261.27 7901 2 304.46 4 956 81 44,546 47 44.546 47 0 00 551 46 0.00 _ 7,261 27 , - - 2 304.46 4 956 81 44,546 47 r 0.00 44,546 47 _ 39,260.66 216,135.98 �so1 516,934.39 (300,798 41) 2.82004_42 2.820,204 42 4,101.02 4,101 02 36,288 55 36.288 55 0.00 39,260.66 0.00 _ - 220,237.00 ' - 516,934.39 (296,697.39) 2.856,492.97_: 0.00 2,856,4 _ -- _ 70.47 ' _ ._.... _ - 70.47 . - 7047 5,395.34 5,39534 0.00 47 0 00 . 70.47 - _. .__0.00 70.47 5.395 34 000 5.09534 22,147.96 _70 282 52 282 52 282 52 22,147.96 0.00 __ _ 28252 0 00 282.52 I 0.00 282.52 22,147_96- _ 0.00. 22,147:9 _ ,_- 87.93 - , __ 87.93 87.93 6,731.28 6,731.28 0.00 87.93 0 00 87.93 0 00 87 93 6,731 28 000 6,731 28 54.37 '- 554.60 _ _ _.- I 55 4 60 4 369 03 4 _ • 369 0 000 _. ..._. 54.37_ .._ .. 0_.00 _. . 554.60_ 554.60 , 4,369.03 , . 0.00 4,369_ . _ 32.09 _ _ 53232 - ' _0.00 _ - I 532 32 54420 544.20 0.00 ... 32.0 .. 9 _. 000 532.32: 0.00. 532 32 _ 544:20. 000 544.20_ - 40.63 290.86 29086 30274 : 302.74 , 00 6203 24 90,6 2955 1 982 803 442076 1 946 895 57 Y 2 056 0189) (109.547 6,353,139 83 395 929 707 6 749,06960 S T,nanceVRon FowenAssessment 0,stca',2011 -2012 Assessment C�sncts�MUwD_1C 11ACTUAL 6 11.12ESTIN1ATE_araf7t 1nrO1Image 2 02 AtIAGHMtN13 Page 1 of 2 CITY OF MOORPARK ... - - - -- - Assessment District - Lighting and Landscape . -- - ..... _ : . - -- - . - - - - - - Fund Activity: FY 201112012 (ESTIMATE as of 10/31/20111_. BUDGET PROPOSED BUDGET BUDGET BUDGET ESTIMATED AD Fund Description Fund Balance,' Oil' Assmt Levy FY 11/12 Interest Others Total I EsP Expenditures Landscape Net Revenue / Fund Balance, Proposed 1 Fund Beginning ceea Transfers In Revenue coda Savings (Expenditure) Ending before: Transfers In' Balance, (Adjusted) for FY 10111 Transfers FY 12/13 Ending After 1 Transfers 84 -2 2300 tinq (134,617_89) 3100 244,300 00 134,617.89 378,917.89 B901_ 1 _ 395.00000 (16,082.11): (150,700.00)! 150,700.00 _ ---.0 00 84-2 .Lig_t __ _ .. . . . 2300 Landscaping (191,391.33) , 3i02 .. ._.. 180,600 00 .. • - 191,391.33 -- -- . . . - -- --------- 371,991.33 7901 521,058.00 89,550.04 (59,516 63) (250,907.96) 250,907.96 0.00 2300 Total (326.009 22) - - t 424,900 0 - -- 326,009 22 0.00 0.00 750,909 22 916,058.00 89,550 04 J75,59874) (401.607.96) 401.60796 0 00 84-2 _ _ 2301 D1 Ave T -2851 3,899 12 _ J102 9,70000 9,700.00 7901 21,109_00 2,995.84 (8,41116) (4 514.04) 4,514.0.4____ 0 00 _Pecan 2301 Total 3,899.12 9,700.00 000 000 000 9,700.00 21,109.00 2,99584 (8,413 16) (4,514.04). 4,514.04 0.00 84 -2 2302 02 Steeple Hill Area T -2865 93,363.80 3102 72,500 00 1,000 00 73,500.00 _7901 145_,520.00 _ 2,554.72 (69,465 28) 23.898._52 23,898 52 84 -2 2302 D2 Steeple Hill Area T -2865 Drains 17,015.21 J101 1,40000 1,400.00 1902 435.00 96500 17,980 21 17,980 21 2302 Total 110,379 01 73,900 00 0.00 1,000.00 0.00 7.4,900 00 . 1-45,955.00 2,554.72 (68,500 28) 41,878.73 , 0.00_ 41,878 73 84 -2 Buttercreek/Peppermill T -3023 3,02 3,10000 2,6420 5 J�2 06 2303 Total . (2,642.00) 3 100.00_• 2,642.00 0.00 0.00 5,742.00 _790 11,097 00 1,695.56 (3.659 44) (6.301.4-4) 6,30144 1 _ _ 000 84 -2 2304 D4 W lllams Ranch R_ d_T_ -3274 (7 474 9�; 3102 6,500.00 _ 7,474 98 _ -. Y - 13,974.98 _..- 7901 .. 17,559.00 5,662.80 2,078 78 (5 396:20) 5,396.20 000 _ 2304 Total (7,474.98) 15.500.00 7,474.98 0.00 r 0.00 13374 98 17 559.00 5,662.80 2,07878 (5.396 - 20 5,396.20 i 000 84 -2 2305 D5: Pheasant Run Area T- 3019/3525 (21,155.38) _.__ 31 °2 23_,500.00 21,155 38 44,655.36 -.790 7901 75 621.00 3,165._20 (27,800.42) (48,955 0): 48 95.5_._80 0 00 84 -2 _. ---T- 2305 05' Pheasant Run Area T- 3019/3525 - 1,779.53 3107 . 50000 500.00 8902 43500 65.00 1,844.53 1.84453 Drains 2305 Total {19 375 85). 24,000 00 21.155 38 0 00 _ 0.00 45,155 38 - 76,056.00 3,16520 (27,735.42) (47 111.27) 48,955.80 1.844 53 84-2 2306 D6 Inglewood St T -3306 - .- (31561.35 J102 _ 1.00000 _ 3,561.35 4,561 35 7901 5,147.00 1.34&28 76063 (2,800 72).. 2,800 72 _ 0.00 _ 2306 Total (3,561.35) 1,000.00 3,561.35: 0.00_ 000 4,561.35 5,147.00 1,34628 760.63 (2,800.72). - _2,800_72 -j_ ___.. - 000 84 -2 2307 D7 Moorpwk Business Park (LA Ave (9,994.66) 3102 11,300 00 9,994.66 21,294 66 7901 31,671.00 6,940.48 (3,435 86) (13,430.52): 000 & Gabbert) 2307 Total (9,994 66). 11,300.00 9,994 66 0.0.0 0 00 21,294.66 i 31,671 00 _ _6,940 48 (3,435.86) (13,430:52)• 13,430.52 - 0 00 84 -2 2308 D8 Home Acres Buffer_ (17 417.64), 1102 15,300 00 17,417 64 32,717.64 7901 50,051.00 1 996.80 (15,336 56) (32,754 20) 32,754.20 _ _ 0 00 _ _ 2308 Total (17,41264)_ 15,300.00 17,417 64 : 0.00 0 0.0_ 32,717.64 - -. 50,051.00 1,996.80 (15,336 56) (32,754.20) +_ 32,75420 000 84 -2 2309 D9- Moorpark Industrial Park (Condor .... - (4,385.93) 3103 1,400.00 4,385.93 - 5,785.93 7901 7,537.00 1,440.24 (310 83) (4,69636) 4,696 76 000 Drive) _ _ _ 2309 Total (4 385 93)- 1,400.00 4,385.93 _ 0 00 0.00 r 5,785 93 --- -- 7,537 00 _... 1,440 24 __. (310.83)_ (4 696 76) 4,696.76 I 0.00 84-2 - - 2310 010 Mountain Meadows PC -3 - 5 544.44 3102 194,000.00 -- 1,000.00 195 000.00 7901 _ _ _297,972.00 10,004 52 (92,967.48) (87,423.04) 87,423 04 000 84 -2 2310 010: Mountain Meadows PC -3 Drains 36,845.93 3103 7,500.00 7,500.00 6902 5,232.00 2,268 00 39.113.93 i 39,113.93 2310 Total 42,390.37 201,500 00 000 1,00000 0.00 202,500.00 303,204.00 10,004.52 (90,699.48) (48,309.11) _ 87,423.04 39,113.93 84 -2 2311 611 Alyssas Ct T-4174 1,665.46 3 02 3,000.00 1 3,000.00 ' 7901 4,44700 692.56 _ (754 44) 911.02 - 911.02 2311 Total 1,665.46 3.00000 0 00 . 0.00 0.00 3,000.00 4,447.00 .69256 A.754 44) 911 02 0.00 911 02 84-2 2312 D12. CaIrsberg Specific Plan Area 523,957.20 7102 266.800 00 6,000.00 272,800.00 7901 315,58100 22,034.48_ (20,748.52). 503,208 68 503,208 68 2312 Total -.- 523 957.20 266,800 00 0 00 6,000,00 0 00 272,800.00 315,583 00 22,034.48 (20,748.52) 503 208.68 0.00 - 503,208 68 84 -2 - -._ 2313 D13. unassigned _ 0.00 0.00 0.00 0.00 - 0.00 2313 To_ tal 0.00 0.00 0.00 0 00 0.00 Om 0._00 000 0.00 0..0 - 0 0 -- 0.00 01 -1 2314 614 Wilshire Builders T -5201 (3,288.61), 3102 1,500.00 3,288.61 4,788 61 7901 5,307-00 787.68 26929 (3,019.32 3,019 32 0.00 2314 Total (3,288_61) 1,500.00 3,288 61 0.00 0 00 4,788 61 5,307.00 787.68 269.29 (3 019:32), 3 019.32 000 01 -2 2315 615. Toll Brothers T -4928 _ 1,876 107.85 7102_ 24 000.00 -_. _._ 83,400 00 7901 242,008 00 42,830.52 _ (115,777.48) 1,760 330.37 1,760.330 37 - 2315 Total 1,876,107.85 _ _59,400.00 59.400 00 0.00 ' 24,000.00 _. -._ r 0.00: 83,400.00 242,008.00 42,830.52 (115,777 48) 1,760,330.37 0 -00....: 1,7601330 37 01 -3 2316 D16: Cabrillo T -5161 - -. _.. 33,266.55 3t02 2,600 00 1,000 00 3,600.00 7907 16,297.00 3,77024 (8.926 76) 24,339 79 _ 24,339 79 01-3 2316 016: Cabrillo T -5161 Drains 46 273.99 31 °3 - 0 00 . °902 5 000.00 (5,000 00) 41.27199 99 41,273 99 . 2316 Total _ 79,540.54 2,600.00 000 1,000.00 0 00 3,600.00 21 297.00 3,770.2.4 (13,926 76) 65 613.78 1 00.0 . 65,613 78 -- 2317 D17 unassigned 000 _ 000 000 0.00 000 2317 Total 0.00 000 000 0.00 000 000 0 00 000 000 0.00 000 0.00 04 -1 2318 D18 Colmer T -5307 24,055.59 3102 2.30000 1,000.00 330000 ; 7901 1.7,187.00 3,05280 (10,834 20) 13,221 39 13,221 39 04 -1 2318 618. Colmer T -5307 Drains 18,727.43 1107 _ _ _ 0.00 6902 0.00 0.00 18,727.43. 18,727 43 2318 Total 42,783.02 2,30000 0.00 1,0.00.00 0_ 3,300.00 17,_18.7.0.0 3,052.80_ (10,834 20) 31,948 82 0.00. 31,948 82 05 -01 2319 D19 M &M PM -5264 (Back -up) 37,684.43 3102 _0.0_ 0.00 7901 000 37,684 43 37,684 43 2319 Total 37,684 43 0 00 0.00 0.00 000 0:00 0.00 0 00 000 37.68.4A3 0 00 _ _37,684.43 07 -2 020 Lyon Homes T -5187 1,088,353 08 3102 58,200.00 13,000.00 71,200 00 7901 234,770 00 30,65600 (132,914.00). 955 439.08 955.439 08 _2320 . 2320 Total _. 1,088,353.08 58,200 00 0.00 13,000.00 0_00 71,200.00 234,770.00 30,656.00 (132,914.00) 955 439.08 0 00 955,439.08 06 -01 2321 D21 Shea Homes T -5133 44,546._47 1102 6,100.00 _ 6,100.00 7901 19,647.00 1,442.00 (12,105.00). 32,441.47 32,441 47 0321 Total 44.5415 47 6,10000 0 00 000 000 6,10000 19 647 00 1,44200 (12 105.00) 32.441.47 000 32,441 47 I--1 S 1F- -eV3on Foldengssessment Dmtrut12011 2012 Assessmem Dt.V�WLLMCWD_10 11ACTUAL 6 11 12ESTIMATE drah/111: 20: 1 !Page 1 02 CITY OF MOORPARK Assessment District - Lighting and Landscape Fund FY 2011/2012 (ESTIMATE asof1013112011) I F BUDGET PROPOSED - - - - --------------- Fund Fund Balance, Re' Assmt Levy FY 11/12 Code Beginning -4-D- 1-- T Description Transfers In (Adjusted) for FY 10/11 67 -_0_1 12322 171,500.00 Pardee Homes T-5045 2,820,204.42 1 3102 � I Landscape 07 -01' 2 322 D_2_2P.ide.H.mesT-5045 Park F 36,288.55 3114 ---iMaint 2322 T otal 2,856,4_92_.97 12323 D23: SuncalNistas T-5130 (not 5,395.34 3102 completed) 2323 Total 5,395.34. 07 -04 .2324 D24: Casino Storage (Back-up) 22,147.96 3102 Total 22,147,96 07-03 2325 1125: at Moorpark 6,731.28 �(Back -up ) 2325 Total 6,731.28 09-01 232D26: 6 Warehouse Discount Center 4,369.03 2326 Total 4,369.03 10-01 2331 ;D31: Tuscany Square Park Lane& 544.20 Moorpark Ave CPD2005-02 (Back- up) 2331 Total 544_20_:____ -------- 10-02,2332 �D32: HFR 145 Park Lane CPD2005- 302.74 !03 (Back-up) 2332 Total 302.74 Total 13,353,1WV L.ri 110 ATTACHMENT 3 rage Z OT Z BUDGET I BUDGET BUDGET ESTIMATED Interest Others Total i Exp nce, Proposed Fund I Expenditures Landscape! Net Revenue Fund Bala Code I Revenue i Savings (Expenditure) Ending before Transfers in Balance, Transfers FY 12/13 Ending After i Transfers 38,000.00 209,500.00 1 7901 905,873.00 1 131,186.88 1! (565,186.12) 2,255,018.30 2,255,018.30 -- --- -- .55 --- 4 36,288.55 0.00 0.00 36,288 0.00 0_0636_,0_6_0L00 OOrt_ 905,873.00, 131,186.88 (565JW12) 2,291 306 85 0.00 85 0.00 F 0.00 5,395.34 5,395.34 0._00_ 6-60-! -0.0-0 _0._0_0 __0___. 0-0- 0.00 0.00 0.00 5,395.34 0.00 5,39534 ------ I---- - I ­ 11 1- 0.00 22,147.96 22,147.96 0.00 0.00 1 0,00 0.00 0.00 0.00 0.00 0.00 0.00 .22,147.96 0.00 22,147:96 0 00 0.00 6,731.28 6,731.28 0.00 T_ 0.00 6,731.28 0.00 0.00 0.00 0-00_!_ 0.00 6,73118. 0.00 E�_:0*07 -'I_ - - -_ - - - I 0.00 4,369.03 4,369.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00_:__ 0.00 ___4�369.93 0.00 4,369.03 - 544.20 0.00 0.00 544.20 0._0_0_1 544.20 0.00 544.20 0.00 000 0 0.00 0.00 0.00 (5.00 302.74 302.74 L -00 0.00 1 0.00 0.00 0.00 ____0.00 0-00 302.74 0.00 3U.34 29-77 M.00 1 395,929.77 85.000.00 .00 3:361,563.06 363,805.64 (1,162,827.59)1 5,190,312.24 610,900.00 5,801,212.24 S \FonanceMRon FoldeeA--M Dma 02011-2012 A-mem DistnctslLMMAD_l 0 -11 ACTUAL& 11 -1 2ESTIMATEdraft/1 111 f201 1 Mage 2 OU