The URL can be used to link to this page

Home My WebLink AboutAgenda Report - February 7, 2007 K-01A4AQEI+�A I'iEM 10 �'Y OF LAY COUNCIL COMMUNICATION TM AGEi A 'TITLE: Mid-y4r budget review and resolution to revise 2006-07 budget approprtions MEE*G►WE: Febru*ry 7, 2007 igtEt Rt BY- Kirk J.''Evans, Budget Mang REC4*M6NW0 ACTION: Approve the mid -year budget adjustments and adopt a resolution devising the 2006-07 budged appropriations. SACIORGLOW INFORMASM, City Council adopted the Budget for Fiscal Year 2006-07 in June, 2006. Although assumptions matte relative to revenues to be received and expenditures to be incurred are conservative, they have resulted in some differences between projected fund balances for some City funds when compared to amounts approved in the adopted City Budget. There are several funds 4or which adjustments to both the revenue estimates and budgeted expenditures should be made in order to more appropriately reflect projected operating results for Fiscal Year 2006-07. Following are recommended adjustments and a brief explanation of reasons for each of the adjustments: T) Gerwrat Fuad- Totai budgeted expenditures, which include mid -year budget adjustments, are projected to decrease by $129,804 from the amount stated in the adopted budget. This has been achieved through tho efforts of many departments to keep costs under control, which includes maintaining several vacancies in non-public safety departments. In addition, current revenue projections for FY 2006-07 are greater than budgeted amounts by $50,712. This combination of favorable events allows for the reestablishment of an Economic Development Co#rdinator position in Administration. This position was eliminated several years ago as a cost saving measure. Restoring this position will cost $29,225 for the remainder of FY 2006-07. The City Budget/Finance Committee reviewed this item and recommends its approval. The recent failure:of Measure J to pass by the requisite two-thirds majority vote necessitates a decision regardir4 how the Seniors Fixed Income and SHARE discount rate prograrns are to be restructured. Staff recommends funding these program at a 50% level out of the General Fund. Total anryal cost of these programs, with no change in rates, is estimated to be $255,000. Therelbre the impact of these programs on the General Fund, with new nates set at a 501/6 level, for the remainder of FY 2006-07 will be $63,750. The City Budget/Finance Committee reviewed this item and did not recommend its approval. • Hutchins Street Square's Division of Arts & Culture provides grants for arts and cultural projects from local nonprofit organizations. This program offers financial support for promising APP*OVED: Blair King, City Mader Mid -Year Buioet Review and Rosoiadlon to Revise 2006-07 Budget Appropriations FebruMi 7,2M Page 2 projects that serve the arts and cultural interests of the people of Lodi. Priority is given to projects on the basis of project merit, implementation capacity and public benefit to citizens. Past projects fumed include: theatre projects, musical events, poetry/literary projects and the Sandhill Crane Festival. The timing of the budget adoption in June means that applicants with summer programs have very little time to order materials and implement their programs. They also cannot assess the financial viability of their program until grant awards are announced. Staff recommends increasing the current budget by $50,000 to accommodate an earlier application and grant award timeline. The Parks & Recreation Department provides after school programs at all twelve public elementary schools in the City of Lodi. Of these twelve sites, four operate primarily on a State grant basis. The Lodi Unified School District (LUSD) was recently awarded State grant funds to operate their own after school programs at seven of these schools - which include the four grant funded sites. These programs will replace seven of the City operated programs, leaving the Parks & Recreation Department responsible for five. LUSD is expected to begin operations in February 2007. The impact of this change on Parks & Recreation may be: o Grant funds and fees received total $256,200 while direct program expenditures are $207,770 resulting in a net loss of approximately $48,430 annually. These monies will be received by LUSD as it operates programs at Washington, Lawrence, Heritage, and Needham schools. o In addition, there may be a net loss of approximately $16,700 annually from user fees by LUSD operating programs at Beckman, Nichols, and Borchardt schools. At this time, no budget adjustment is recommended for this program. The expected unreserved General Fund ending fund balance will be $3,228,951. This includes additional expenditures for the Economic Development Coordinator position, revised low-income water and wastewater rate programs and HSS grants for arts projects for the remainder of FY 2006-07. Fogowing are recommended adjustments: Anyrapdaligins Increese A nistration (Personnel Services) $ 29,225 Increase Tralinsfers-Shit (Low Income Discount) $ 63,750 Increase Hutchins Street Square (Special Payments) $ 50,000 2) Community Development Fund- Workload created by new residential and commercial developments that wall soon be coming on-line in the City of Lodi necessitate the establishment of an additional Permit Technician position. The expected unreserved Community Development Fund ending fund balance will be $6,600, which includes the additional expenditure for the Permit Technician position for the remainder of FY 2006-07. The City Budget/Finance Committee reviewed this item and recommends its approval. Following are recommended adjustments: Acari t' s Increase unity Development (Personnel Services) $16,290 7Zglow mad ibsotillon to RwAo 200e47 rpt #ppropdaftm Baso 3 3) R 1ltilio of Tr OW. In and W- The cost of services transfers for eaginleering support for they W ter, r, Police, Fire, and Parks Impact fees (IMF Fundi!!) were inadverlontly combirerd w4h and #ansferred out of the Streets Fund (Measure K - 325 Fund). Following are recommended adjus#nents to bring the Measure K Fund back into alignment: Inorsfte 1 #ncreoe 1 Ilneremse 1 mcre0se 1 tncre"e 1 Incre6se I Reve es arm Expelndltur" tflkie"utp K Transfer Out $ 222,656 OF Waoevwter Transhr Out $ 30,740 IF WaW TranOw Out $ 52,796 IMF PaSce Transfer Out $ 25,924 IMIF Fin Transfer Out $ 34,543 IMF Peeks Tradefwr Out $ 52,913 IMF Gm Facilities Ackmin Transfer Out $ 25,6!0 Tax Re venuos- SaTax revenues are projected to be approximately a net of $151,040 less then budgeted. Pro%rty taxes and other taxes are projected to be as budgeted. Property texas and Sables taxes wer# estimated using prior year actual results. Police Department Overtime- The Police Department has expended a greeter percents of its overtime budget than anticipated. As of the end of December, the department had spent 64% of its overtime budget. It is recommended that the budget not be adjusted to reflect the overtime budget variance. if current trends continue, overtime expenditures are projected to be approximately $15800 over budget but will be offset by salary savings realized through vacancies in regular positions. Management will review methods to reduce planned overtime with Pc4ice Department a#ministration. Fire Department Overtime- The Fire Department has expended a greater percentage of its overtirne budget than anticipated. As of the end of December, Fire Operations had spent 70% of its overtime budget. It is recommended that the budget not be adjusted to reflect the overtime budget variance. If current trends continue, overtime expenditures are projected to be approximately $186;000 over budget but will be offset by salary savings realized through vacancies in regular positions. Management will review methods to reduce planned overtime with Fire Department administration. • Expenditures in other departments- Most departments are projected to have savings in personnel services costs due to work force attrition. The Police and fire Departments continue to experience high overtime expenditures. Departments with greater than expected attrition may need to fill some of their positions. Hardest hit are Electric Utility and Public Works Water Services. i=—T— . • Revenues - revenueq are expected to increase slightly by $283,000 in the current year throughout the various Eiectric Wlity revenue line items. This represents a 0.4% increase over the budgeted amount. foY�lawy Paso 4 •CIpewift expenses - Pue to position vacancies in several divisions and savings in services and atm, it is expect than there will be approximately $463,860 projected savings in oxpemes. A ate, bulk powe# costs are pfd to fail below the amount budgeted by $487,908 which negates a total expenditures savings of $951,768. 5t�ets ice: • nd Salience - The bined rrsserved/unreserved begirtning fund balance is $3,635,7833 greater an budgeted as a rM&AIt of timing differences in capital expenditures in relation to the funder of of The ending lance is projected to be $1,143,475 less n expecited in comparison11D wed amount. calDital &MUM FMd: • Mind Ince - The b d reserved/unreserved beginning fund balance is $83,585 less than WidoeWas a result aiming dNferences in capital experxlitures in rotation to the fund of them *ojwts. Consequent*the ending balance is projected to be $230,010 less than expected in nrin to the bueted amount. • Fund Balance - Theinning unreserved fund balance is $615,397 less than budgeted as s cult of Gh-dng diffe zs in cootal expenditures in reiadon to the funding of these projects. The preserved ending ba*nce is projected to be $28,418 greater than expected in comparison to the Wdgeted-arnount. ThO reserved cash balance must be used for PCEITCE cleanup. A tau er . od: Find Balance - The b4onning unreserved fund balance is $2,983,693 greater than budgeted as a r6suk of timing diffe anc:es in capital expenditures in relation to the funding of projects. l onMKK*nVy the unr rved ending balance is projected to be $2,424,526 greater than expecteld A comparison to the budgeted amount. Reserves remain at a very good level; however the remaining amount of r6served fund balance is to be used for future White Slough Treatment Plant Waproven►ents. CgVmAi -&JkN1&SMt Fu I*: • *v - Ptojecteo revenues for permit fees and planning fees show leas than expected ildkng activity in itsyew 2006-07. Community Devek prpent staff con1hue to work tor*rds cc rw sotf�ustair with fees and charges for services. This fiscal year the Gene M. Fund Is pportin0 their effort with a transfer -in of $300,000 which may need to be Increased because of the projected shortfall 1h revenues. Transit §jA • I rnd Balance - The -ling fund balance is $705,728 less than budgeted ars a result of capit6l pe"'dib"s which utake place in the current year, leaving an enc$ng fund balance of 58;672. The TransFund is not expected to build up significant reserves liven that the Federal ansit Administration requires grant awards to be expended in a timely manner. 7, s P"W 5 Ulf l ww • Rev*nU es - The revs Lues in this fund come from transfers made from all operating budgets. • Evendiltures - Clairos experience in FY 2006-07 for workers compensation and general liability has been as sxpecteo. • Fund Bolance - As arresult of the expected claims experience the fund balance is projected to be approxiona tefy $592, 00 more than the amount budgeted. The FY 2006-G7 Budget do*ument envisioned 491 positions total with 42 mandaW vacancies, leaving a balani; of 449 posilons to !,be filled. As of the end of December, the number filled was 400 position. This iindicatift of projected salary savings that will be realized in many City departments. 1. - 177 .k Staffill continue to monit revenues and expenditures through the end of the fiscal year and updaie pro,**d prd fund balances. he projected fund balances will be used as the budgeted beginning fund balar>es for fire year 2001-08. The projected expenditures for fiscal year 2006-07 will be used as the base to amount to establish the budgeted expenditures for aK departments. FfSC*L WWACT. The fiscal effects of the adjustrnents are incorporated within the expianalions above. Attachnmbnts cc: city0morney Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Page 1 Audited Estimated Budget to Budget to 2005-06 2006-07 2006-07 Est Actuals Est Actuals Actuals Budget Actuals Variance $ Variance % General Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved 488,246 1,506,926 3,048,435 1,541,509 Beginning Fund Balance (Reserved/Designated) 1,506,926 667,196 661,483 (5,713) Revenues 42,873,053 44,023,530 44,074,242 50,712 0.1% Expenditures 41,158,307 44,023,530 43,893,726 129,804 0.3% Year-end Audit Adjustments/Other Net Difference 1,714,746 180,516 180,516 Fund Balance (Net Assets) Ending Fund Balance Unreserved 3,048,435 1,506,926 3,228,951 1,722,025 Ending Fund Balance (Reserved/Designated) 661,483 667,196 661,483 (5,713) Total Fund Balance 3,709,918 2,174,122 3,890,434 1,716,312 Page 1 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Fund Balance (Cash) Beginning Cash Unreserved 7,469,037 1,704,200 3,631,402 1,927,202 Beginning Cash Reserved 11,873,387 10,529,239 10,529,239 Revenues 61,065,568 70,563,297 70,856,435 293,138 0.4% Expenditures 66,688,116 70,553,889 69,602,121 951,768 1.4% Accrual to Cash Basis Adjustment 440,765 (3,678,440) Net Difference (5,181,783) 9,408 (2,424,126) (2,433,534) Fund Balance (Cash) Ending Cash Unreserved Ending Cash Reserved 3,631,402 10,529,239 1,713,608 4,885,716 6,850,799 3,172,108 6,850,799 Total Fund Balance 14,160,641 1,713,608 11,736,515 10,022,907 Accrual to Cash Basis Adjustments- In accordance with Generally Accepted Accounting Principles revenues are recognized when earned and expenditures are recognized when they become an obligation. On a cash basis, which is not in accordance with Generally Accepted Accounting Principles, revenues are not recognized until cash is received and expenditures are not recognized until cash is disbursed. FY 2005-06 Audited Beginning Fund Balance includes cash $4,896,603, NCPA General Operating Reserve (GOR) $1,955,896 and a transfer from restricted cash of $616,538. Page 2 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Revenues Expenditures Accrual to Cash Basis Adjustment Net Difference Fund Balance (Cash) Ending Cash Unreserved Ending Cash Reserved Audited Budget to 2005-06 2006-07 Actuals Wastewater Fund Actuals Fund Balance (Cash) 1,268,007 Beginning Cash Unreserved 4,658,764 Beginning Cash Reserved 16,247,795 Revenues Expenditures Accrual to Cash Basis Adjustment Net Difference Fund Balance (Cash) Ending Cash Unreserved Ending Cash Reserved Budget to Est Actuals Variance % 9,869,971 39,252,900 Estimated Budget to 2006-07 2006-07 Est Actuals Budget Actuals Variance $ 1,268,007 4,251,700 2,983,693 1,688,947 14,627,909 12,938,962 Budget to Est Actuals Variance % 9,869,971 39,252,900 16,596,584 (22,656,316) -136.5% 9,636,745 40,657,024 17,658,032 22,998,992 130.2% (2,260,176) (7,172,258) (2,026,950) (1,404,124) (8,233,706) (6,829,582) 4,251,700 765,726 3,190,252 2,424,526 14,627,909 787,104 7,455,651 6,668,547 Total Fund Balance 18,879,609 1,552,830 10,645,903 9,093,073 Accrual to Cash Basis Adjustments- In accordance with Generally Accepted Accounting Principles revenues are recognized when earned and expenditures are recognized when they become an obligation. On a cash basis, which is not in accordance with Generally Accepted Accounting Principles, revenues are not recognized until cash is received and expenditures are not recognized until cash is disbursed. Page 3 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Fund Balance (Cash) Ending Cash Unreserved 213,603 779,001 807,419 28,418 Ending Cash Reserved 8,844,424 6,056,155 7,351,264 1,295,109 Total Fund Balance 9,058,027 6,835,156 8,158,683 1,323,527 Accrual to Cash Basis Adjustments- In accordance with Generally Accepted Accounting Principles revenues are recognized when earned and expenditures are recognized when they become an obligation. On a cash basis, which is not in accordance with Generally Accepted Accounting Principles, revenues are not recognized until cash is received and expenditures are not recognized until cash is disbursed. Page 4 Audited Estimated Budget to Budget to 2005-06 2006-07 2006-07 Est Actuals Est Actuals Actuals Budget Actuals Variance $ Variance % Water Fund Fund Balance (Cash) Beginning Cash Unreserved 3,140,369 829,000 213,603 (615,397) Beginning Cash Reserved 300,711 8,700,000 8,844,424 144,424 Revenues 15,669,738 10,341,000 10,766,887 425,887 4.0% Expenditures 9,218,231 13,034,844 11,666,231 1,368,613 11.7% Accrual to Cash Basis Adjustment (834,560) Net Difference 5,616,947 (2,693,844) (899,344) 1,794,500 Fund Balance (Cash) Ending Cash Unreserved 213,603 779,001 807,419 28,418 Ending Cash Reserved 8,844,424 6,056,155 7,351,264 1,295,109 Total Fund Balance 9,058,027 6,835,156 8,158,683 1,323,527 Accrual to Cash Basis Adjustments- In accordance with Generally Accepted Accounting Principles revenues are recognized when earned and expenditures are recognized when they become an obligation. On a cash basis, which is not in accordance with Generally Accepted Accounting Principles, revenues are not recognized until cash is received and expenditures are not recognized until cash is disbursed. Page 4 Page 5 Budget to Statement of Changes in Fund Balance Est Actuals For the Fiscal Year Ended June 30, 2007 Variance $ With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 30,485 Audited Estimated 83,527 2005-06 2006-07 2006-07 Actuals Budget Actuals Library Fund 114,012 Fund Balance (Net Assets) 114,012 Beginning Fund Balance Unreserved 697,158 628,538 659,023 Beginning Fund Balance (Reserved/Designated) Revenues 1,487,299 1,622,670 1,622,670 Expenditures 1,525,434 1,711,336 1,627,809 Year-end Audit Adjustments/Other Net Difference (38,135) (88,666) (5,139) Fund Balance (Net Assets) Ending Fund Balance Unreserved 659,023 539,872 653,884 Ending Fund Balance (Reserved/Designated) Total Fund Balance 659,023 539,872 653,884 Page 5 Budget to Budget to Est Actuals Est Actuals Variance $ Variance % 30,485 83,527 5.1% 83,527 114,012 114,012 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Audited 2005-06 Actuals Capital Outlay Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved 974,842 Beginning Fund Balance (Reserved/Designated) 5,649,770 Revenues Expenditures Year-end Audit Adjustments/Other Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated) Total Fund Balance Estimated Budget to 2006-07 2006-07 Est Actuals Budget Actuals Variance $ 5,663,370 5,663,370 6,549,902 802,947 (5,746,955) Budget to Est Actuals Variance % 749,552 1,845,000 1,845,000 372,999 1,557,836 1,704,261 (146,425) -8.6% (534,848) (158,295) 287,164 140,739 (146,425) 5,663,370 6,837,066 802,947 6,466,317 6,837,066 Page 6 5,804,109 802,947 (1,032,957) 802,947 6,607,056 (230,010) Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Page 7 Audited Budget to 2005-06 2006-07 Actuals Community Development Fund Est Actuals Fund Balance (Net Assets) Actuals Beginning Fund Balance Unreserved Variance % Beginning Fund Balance (Reserved/Designated) 47,310 Revenues 1,672,190 Expenditures 1,846,498 Year-end Audit Adjustments/Other 253,000 Net Difference 78,692 Fund Balance (Net Assets) -3.4% Ending Fund Balance Unreserved 47,310 Ending Fund Balance (Reserved/Designated) 31,382 Total Fund Balance 78,692 Page 7 47,700 (40,709) Estimated Budget to Budget to 2006-07 2006-07 Est Actuals Est Actuals Budget Actuals Variance $ Variance % 47,310 47,310 31,382 31,382 2,175,651 2,105,000 (70,651) -3.4% 2,127,951 2,145,709 (17,758) -0.8% 47,700 (40,709) (88,409) 47,700 6,601 (41,099) 31,382 31,382 47,700 37,983 (9,717) Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Fund Balance (Net Assets) Beginning Fund Balance Unreserved Beginning Fund Balance (Reserved/Designated) Revenues 1,248,738 3,347,646 3,347,646 100.0% Expenditures 1,248,738 3,347,646 (3,347,646) -100.0% Year-end Audit Adjustments/Other Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated otal Fund Balance Page 8 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Fund Balance (Net Assets) Beginning Fund Balance Unreserved 3,035 (72,736) (72,736) Beginning Fund Balance (Reserved/Designated) Revenues Expenditures Accrual to Cash Basis Adjustment Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated otal Fund Balance Accrual to Cash Basis Adjustments- In accordance with Generally Accepted Accounting Principles revenues are recognized when earned and expenditures are recognized when they become an obligation. On a cash basis, which is not in accordance with Generally Accepted Accounting Principles, revenues are not recognized until cash is received and expenditures are not recognized until cash is disbursed. 5,187,909 6,588,522 6,154,294 (434,228) -7.1% 5,288,803 6,034,652 5,849,598 185,054 3.2% 25,123 (553,870) 553,870 (75,771) 304,696 304,696 (72,736) (72,736) Page 9 231,960 231,960 231,960 231,960 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Page 10 Audited Budget to 2005-06 2006-07 Actuals Vehicle & Equipment Replacement Fund Est Actuals Fund Balance (Net Assets) Actuals Beginning Fund Balance Unreserved 150,175 Beginning Fund Balance (Reserved/Designated) 2,141 Revenues 14,579 Expenditures 63,670 Year-end Audit Adjustments/Other 187,500 Net Difference 138,409 Fund Balance (Net Assets) 26.5% Ending Fund Balance Unreserved 288,584 Ending Fund Balance (Reserved/Designated) 2,141 Total Fund Balance 290,725 Page 10 478,317 590,021 833,133 878,605 2,141 833,133 880,746 111,704 45,472 2,141 47,613 Estimated Budget to Budget to 2006-07 2006-07 Est Actuals Est Actuals Budget Actuals Variance $ Variance % 354,816 288,584 (66,232) 2,141 2,141 838,317 1,140,488 302,171 26.5% 360,000 550,467 (190,467) -34.6% 478,317 590,021 833,133 878,605 2,141 833,133 880,746 111,704 45,472 2,141 47,613 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Audited Estimated 2005-06 2006-07 2006-07 Actuals Budget Actuals Self Insurance Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved 3,258,384 4,439,332 4,133,152 Beginning Fund Balance (Reserved/Designated) Revenues Expenditures Accrual to Cash Basis Adjustment Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated) Total Fund Balance Accrual to Cash Basis Adjustments- In accordance with Generally Accepted Accounting Principles revenues are recognized when earned and expenditures are recognized when they become an obligation. On a cash basis, which is not in accordance with Generally Accepted Accounting Principles, revenues are not recognized until cash is received and expenditures are not recognized until cash is disbursed. Budget to Est Actuals Variance $ (306,180) Budget to Est Actuals Variance % 2,400,194 2,586,900 2,586,900 1,515,449 2,933,518 2,340,815 592,703 25.3% (9,977) 874,768 (346,618) 246,085 592,703 4,133,152 4,092,714 4,379,237 4,133,152 4,092,714 4,379,237 Page 11 286,523 286,523 Page 12 Budget to Statement of Changes in Fund Balance Est Actuals For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Variance % Audited Estimated 2005-06 2006-07 2006-07 100.0% Actuals Budget Actuals Public Safety Special Revenue Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved 283,516 408,206 383,040 Beginning Fund Balance (Reserved/Designated) Revenues 254,805 229,260 Expenditures 176,983 44,258 Year-end Audit Adjustments/Other 21,702 Net Difference 99,524 185,002 Fund Balance (Net Assets) Ending Fund Balance Unreserved 383,040 408,206 568,042 Ending Fund Balance (Reserved/Designated) Total Fund Balance 383,040 408,206 568,042 Page 12 Budget to Budget to Est Actuals Est Actuals Variance $ Variance % (25,166) 229,260 100.0% (44,258) -100.0% 185,002 159,836 159,836 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Audited 2005-06 Actuals Streets Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved 3,965,554 Beginning Fund Balance (Reserved/Designated) 1,009,182 Revenues Expenditures Year-end Audit Adjustments/Other Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated) Total Fund Balance Budget to Est Actuals Variance % 9,543,264 10,786,988 6,302,120 (4,484,868) -71.2% 6,817,404 8,295,118 8,589,508 (294,390) -3.4% (1,662,686) 1,063,174 2,491,870 (2,287,388) (4,779,258) 5,737,407 300,503 6,037,910 Page 13 3,819,853 1,074,144 Estimated Budget to 2006-07 2006-07 Est Actuals Budget Actuals Variance $ 1,327,983 5,737,407 4,409,424 1,074,144 300,503 (773,641) Budget to Est Actuals Variance % 9,543,264 10,786,988 6,302,120 (4,484,868) -71.2% 6,817,404 8,295,118 8,589,508 (294,390) -3.4% (1,662,686) 1,063,174 2,491,870 (2,287,388) (4,779,258) 5,737,407 300,503 6,037,910 Page 13 3,819,853 1,074,144 3,450,019 300,503 (369,834) (773,641) 4,893,997 3,750,522 (1,143,475) Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Fund Balance (Cash) Ending Cash Unreserved 851,427 1,264,400 558,672 (705,728) Ending Cash Reserved Total Fund Balance 851,427 1,264,400 558,672 (705,728) Accrual to Cash Basis Adjustments- In accordance with Generally Accepted Accounting Principles revenues are recognized when earned and expenditures are recognized when they become an obligation. On a cash basis, which is not in accordance with Generally Accepted Accounting Principles, revenues are not recognized until cash is received and expenditures are not recognized until cash is disbursed. Page 14 Audited Estimated Budget to Budget to 2005-06 2006-07 2006-07 Est Actuals Est Actuals Actuals Budget Actuals Variance $ Variance % Transit Fund Fund Balance (Cash) Beginning Cash Unreserved (1,688,947) 824,323 851,427 27,104 Beginning Cash Reserved Revenues 4,314,035 5,162,005 5,420,115 258,110 4.8% Expenditures 3,643,035 4,721,928 5,712,870 (990,942) -17.3% Accrual to Cash Basis Adjustment 1,869,374 Net Difference 2,540,374 440,077 (292,755) (732,832) Fund Balance (Cash) Ending Cash Unreserved 851,427 1,264,400 558,672 (705,728) Ending Cash Reserved Total Fund Balance 851,427 1,264,400 558,672 (705,728) Accrual to Cash Basis Adjustments- In accordance with Generally Accepted Accounting Principles revenues are recognized when earned and expenditures are recognized when they become an obligation. On a cash basis, which is not in accordance with Generally Accepted Accounting Principles, revenues are not recognized until cash is received and expenditures are not recognized until cash is disbursed. Page 14 Page 15 Budget to Statement of Changes in Fund Balance Est Actuals For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Variance % Audited Estimated 2005-06 2006-07 2006-07 Actuals Budget Actuals Transportation Development Act Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved 108,909 179,909 102,878 Beginning Fund Balance (Reserved/Designated) 2,850 Revenues 49,434 51,000 51,000 Expenditures 52,615 288,780 74,850 Year-end Audit Adjustments/Other Net Difference (3,181) (237,780) (23,850) Fund Balance (Net Assets) Ending Fund Balance Unreserved 102,878 (57,871) 81,878 Ending Fund Balance (Reserved/Designated) 2,850 Total Fund Balance 105,728 (57,871) 81,878 Page 15 Budget to Budget to Est Actuals Est Actuals Variance $ Variance % (77,031) 2,850 213,930 285.8% 213,930 139,749 139,749 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Revenues Expenditures Year-end Audit Adjustments/Other Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated) Total Fund Balance 77,925 255,000 255,000 12,862 255,000 255,000 65,063 1,286,808 1,074,001 1,286,808 1,074,001 Page 16 1,286,808 1,286,808 Budget to Est Actuals Variance $ (1,074,001) 1,286,808 212,807 212,807 Budget to Est Actuals Variance % Audited Estimated 2005-06 2006-07 2006-07 Actuals Budget Actuals Trust and Agency Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved 1,221,745 1,074,001 Beginning Fund Balance (Reserved/Designated) 1,286,808 Revenues Expenditures Year-end Audit Adjustments/Other Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated) Total Fund Balance 77,925 255,000 255,000 12,862 255,000 255,000 65,063 1,286,808 1,074,001 1,286,808 1,074,001 Page 16 1,286,808 1,286,808 Budget to Est Actuals Variance $ (1,074,001) 1,286,808 212,807 212,807 Budget to Est Actuals Variance % Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Page 17 Audited Estimated Budget to Budget to 2005-06 2006-07 2006-07 Est Actuals Est Actuals Actuals Budget Actuals Variance $ Variance % Debt Service Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved Beginning Fund Balance (Reserved/Designated) Revenues 1,780,598 1,771,653 1,873,294 101,641 5.4% Expenditures 1,780,598 1,771,653 1,873,294 (101,641) -5.4% Year-end Audit Adjustments/Other Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated) Total Fund Balance Page 17 Statement of Changes in Fund Balance For the Fiscal Year Ended June 30, 2007 With Actuals for Fiscal Year 2005-06 and Comparative Budget Fiscal Year 2006-07 Fleet Services Internal Service Fund Fund Balance (Net Assets) Beginning Fund Balance Unreserved Beginning Fund Balance (Reserved/Designated) Revenues Expenditures Year-end Audit Adjustments/Other Net Difference Fund Balance (Net Assets) Ending Fund Balance Unreserved Ending Fund Balance (Reserved/Designated) Total Fund Balance Audited Estimated Budget to Budget to 2005-06 2006-07 2006-07 Est Actuals Est Actuals Actuals Budget Actuals Variance $ Variance % Page 18 1,771,653 1,771,653 1,771,653 1,707,700 63,953 3.7% 63,953 63,953 63,953 63,953 63,953 63,953 RESOLUTION NO. 2007-24 A RESOLUTION OF THE LODI CITY COUNCIL REVISING THE ADOPTED 2006-07 OPERATING AND CAPITAL IMPROVEMENT BUDGET FOR THE FISCAL YEAR BEGINNING JULY 1, 2006 AND ENDING JUNE 30, 2007 WHEREAS, the City Manager submitted the 2006-07 balanced Operating and Capital Improvement Budget to the City Council on May 31, 2006; and WHEREAS, the 2006-07 Operating and Capital Improvement Budget was prepared in accordance with the City Council's goals, budget assumptions, and policies; and WHEREAS, the City Council conducted public budget meetings on May 31, June 6, June 7, and June 20, 200% at the Carnegie Forum; and WHEREAS, the City Council approved the 2006-07 Operating and Capital. Improvement Budget as passed and ackipted in Resolution 2006-133 at a regular meeting of the City Council of the,Oity of Lodi on July 5, 2006; and WHEREAS, revisions in the 2006-07 Operating and Capital Improvement Budget as approved by the City of Lodi City Council on July 5, 2006, are necessary as a result of changes in revenue estimates and projected changes in operating expenditures. follows: NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Lodi as That the 2006-07 Operating and Capital Improvement Budget, as approved by the City of Lodi City Coundl proposed by the City Manager and amended by the City Council (with the exclusion of the Lodi Conference and Visitors Bureau element, voted on separately and reflected in Resolution 2006-132), be revised as follows: Dated: February 7, 2007 City council Approved Adjustments city council Revved General Fund - Hutchins Street Square 1,433,542 50,000 1,483,542 Community Development Fund 2,127,951 16,290 2,144,241 325 Measure K - Transfer Out 426,082 (222,606) 203,476 173 1141F Wastewater - Transfer Out -0- 30,740 30,740 182 IMF Water - Transfer Out -0- 52,796 52,796 1215 IMF Police - Transfer Out -0- 25,924 25,924 1216 IMF Fire - Transfer Out 115,130 34,543 149,673 1217 WF Parks - Transfer Out -0- 52,913 52,913 1218 IMF Gen Facilities Admin - Transfer Out 1,162,106 25,690 1,187,796 Dated: February 7, 2007 Fesafuban No. 2007--24 February 7, 2007 Page Two I hereby certify that Resolution No. 2007-24 was passed and adopted by the City Count l of the City of Lodi in a regular meeting held February 7, 2007, by the following vote: AYES: COUNCIL MEMBERS — Hansen, Hitchcock, Katzakian, and Mayor Johnson NOES: COUNCIL MEMBERS — Mounce ABSENT: COUNCIL MEMBERS — None ABSTAIN: COUNCIL MEMBERS — None a_ RANDIJOHL City Cleric 2007-24 Position Control CITYWIDE - 491 Total Positions 411 Filled 42 Mandatory Vacancies 38 Recruitment in Process Vacant (Gland.) 42 8% Vacant (in recruit.) 38 Bolo Page 12 Filed 411 84% Position Control ADMINISTRATION -- 56 Total Positions City Manager 3 Filled 0 Mandatory Vacancies 1 Recruitment in Process Human Resources 3 Filled 1 Mandatory Vacancies 1 Recruitment in Process Finance 20 Filled 6 Mandatory Vacancies 5 Recruitment in Process City Attorney 3 Filled 0 Mandatory Vacancies 0 Recruitment in Process Information Systems 8 Filled 1 Mandatory Vacancies 0 Recruitment in Process Page 13 Vacart pand.) B 14% City Clerk 4 Filled 0 Mandatory Vacancies 0 Recruitment in Process Vacart (1n.) 7 13% Filled 41 73% Position Control POLICE -117 Tota! Positions 112 Filled 2 Mandatory Vacancies 3 Recruitment in Process Page 14 vacant vacm (mart!.) (in recrtuit.) 2 3 2% 3% FIRE - 64 Total Positions 61 Filled 0 Mandatory Vacancies 3 Recruitment in Process Position Control Page 15 Vacant Vacart (in remit) (Mand.) 3 0 3% 0% led 61 99% Position Control ELECTRIC UTILITY - 64 Total Positions 37 Filled 19 Mandatory Vacancies 8 Recruitment in Process Page 16 Vacant (marl.) 19 30% Vacant (,n re".) 8 13% Flied 37 .58% Position Control PUBLIC WORKS -114 Total Positions Administration 5 Filled 0 Mandatory Vacancies 0 Recruitment in Process Engineering 15 Filled 2 Mandatory Vacancies 2 Recruitment in Process Fleet and Facilities 13 Filled 3 Mandatory Vacancies 1 Recruitment in Process Streets 28 Filled 2 Mandatory Vacancies 1 Recruitment in Process WaterfWastewater 33 Filled 0 Mandatory Vacancies 8 Recruitment in Process Page 17 Transit 1 Filled 0 Mandatory Vacancies 0 Recruitment in Process vacart p n react) 12 11% Vaeart (Mand.) 7 6% Flied ss Position Control COMMUNITY DEVELOPMENT -1l Total Positions 15 Filled 0 Mandatory Vacancies 2 Recruitment in Process Vacart (Mand.) 10 Q% Vacart (lnreaut.) 2 12% Filed t5 88% Poen Control PARKS AND RECREATION - 33 Total Positions 28 Filled 3 Mandatory Vacancies 2 Recruitment in Process Vacart (mend.) 3 9°16 Vacart (in reit.) 2 6% Flied 28 86% Position Control COMMUNITY CENTER -10 Total Positions 8 Filled 1 Mandatory Vacancies 1 Recruitment in Process vacant pand.) 10% Vacart (m remo.) 10% F1W 8 80% Position Control LIBRARY - 16 Total Positions 14 Filled 2 Mandatory Vacancies 4 Recruitment in Process Page 21 vacwt Vacart (inrecrult.) Paw-) 0 2 0% 1396 Filed 14 88% FT CC Community Cut" DVOG or 1 FT CD INAIWft OMCW 1 FT EU tic UmnalnlLinewanaan 2 FT EU Electrical Technician 1 FT EU EneV Speciast 1 FT EU Manager EkxAric Services 1 FT EU Senior Power Engineer 1 FT FID -OW 1 FT FD Fire Division Chief 1 FT FI AomurMV Clerk 1 FT FI Customer Service Representative Ifil 3 FT FI Finance Technician 1 FT PD Police Officer (Liberal) 2 FT PD Police Records Clerk 1 1 FT PR Park Maintenance Worker I 1 FT PR Park Maintenance Worker III 1 FT PW FaciWas Supervisor 1 FT PW Wastewater Plant Operator IIllll 1 FT CD Plan Check Engineer 1 FT CM %anagerno t Analyst 11 1 FT FD Fire Fighter 1 FT FD Fire Engineer 1 FT PD Police Officer (Academy Grad) 1 FT PD Police Officer (Entry) 1 FT PW f1 aIntemanee Worker 1 FT PW Ekx*igan 1 FT PW Wafter Services Technician 1 FT PW Plant and Equipment Mechanic 1 FT EU Senior Electrical Estimator 1 Total recruitments in process 33