Loading...
HomeMy WebLinkAboutAgenda Report - June 1, 2016 I-01TM CITY OF LODI COUNCIL COMMUNICATION AGENDA TITLE: Adopt Resolution Approving the City of Lodi Financial Plan and Budget for the Fiscal Year Beginning July 1, 2016 and Ending June 30, 2017 and Approving the Fiscal Year 2016/17 Appropriation Spending Limit MEETING DATE: June 1, 2016 PREPARED BY: Deputy City Manager RECOMMENDED ACTION: Adopt resolution approving the City of Lodi Financial Plan and Budget for the Fiscal Year (FY) beginning July 1, 2016 and ending June 30, 2017 and approving the Fiscal Year 2016/17 appropriation spending limit. BACKGROUND INFORMATION: The City Council will continue to receive the budget presentation and the public is invited to comment on the FY 2016/17 budget. Staff presented information to Council regarding this budget at the Shirtsleeve meetings on April 26, May 10, 24 and 31, 2016. Staff published a draft budget document on May 12, 2016. The General Fund Budget for FY 2016/17 reflects a draw on reserves of $1,564,090. This draw is part of a planned reduction in reserves related to a partial return of prior employee concessions. Council approved a General Fund Reserve Policy in June 2010 that sets aside 8 percent of General Fund revenues for a Catastrophic Reserve and 8 percent of General Fund revenues for an Economic Reserve. Total General Fund reserves are projected to be $8.8 million. This level of reserve will fully fund both the Catastrophic Reserve and the Economic Reserve at about $3.75 million each, and fund additional costs associated with labor agreements through December 2017 in the amount of $943,000. The General Fund also has a restricted reserve of about $345,000 associated with the Digital Infrastructure and Video Competition Act (DIVCA). There are no uncommitted, undesignated reserves in the General Fund in this budget. General Fund revenues are $46,916,020, an increase of $207,760 over the 2015/16 initially adopted budget. General Fund expenditures are $48,480,110, an increase of $689,660 over the prior year adjusted budget. The All -Funds expense/expenditure budget is $193,050,540, a decrease of $40 million from the previous year. The decrease is primarily related to reductions in capital projects, debt service and internal cost transfers. All bargaining unit agreements expire on December 31, 2017. This budget incorporates all of the provisions of those agreements. Funding for the General Fund portion of these agreements is provided by reserves in excess of the reserve target established by the City Council. APPROVED: wan phe c wares ► ty Manager The budget proposes 397 full time positions; a net increase of four over the prior year. The additions and deletions are shown in the table below: Classification Department Number Electric Distribution Operator Electric 1 Electric Lineman/Linewoman Electric 1 Metering Technician Electric 1 Library Assistant Library (1) Park Maintenance Worker I/II PRCS (1) Police Records Clerk Police 1 Public Works Inspector I/II Public Works 1 Plant and Equipment Mechanic Public Works 1 Net positions added 4 Total cost of the additional positions to the enterprise funds is about $598,000. General Fund additional costs are a net increase of $26,300. Savings associated with position deletions in the Library ($74,320) and in PRCS ($82,350) will remain in those funds. It should be noted that the positions being deleted are currently vacant. Significant capital projects included in the budget are: • Wastewater System Maintenance/Improvements ($9.85 million) o Electrical upgrades, SCADA upgrades, coarse screen design and installation, recycled water storage facility, corrosion repairs, and storm drain system improvements ■ Street Maintenance ($1.4 million) o Sealing and striping, signal maintenance, sidewalk repairs and pavement maintenance • Water System Improvements ($1.2 million) o Continuing design and construction of the meter installation program, water well rehabilitation, and PCE/TCE projects • Electrical System Maintenance ($4.3 million) o Overhead and underground maintenance, streetlight grounding and fusing, LED decorative streetlight installation and transformer replacement A resolution adopting the Financial Plan and Budget is attached. Included in the budget resolution is the adoption of the Appropriation Spending Limit for the 2016/17 fiscal year. This limit represents the maximum spending authority for the City based upon population and inflation changes over the last year. The 2016/17 Appropriation Limit is $95,607,750, an increase of $5,512,162 from the prior year. Details of the calculations are attached as Attachment 1 and Exhibits A through G. FISCAL IMPACT: The 2016/17 budget provides an expenditure plan for all funds. The All -Funds budget is $193,050,540, a decrease of about $40.0 million from the prior year. As noted earlier, this decrease is primarily related to a reduction in budget capital projects, debt service and internal fund transfers. The General Fund budget reflects a draw on reserves of $1,564,090, based upon revenues of $46,916,020 and expenditures of $48,480,110. Jord n Ayers, Deputy Cir;✓ j Manager Attachments 2016-17 FINANCIAL PLAN AND BUDGET ATTACHMENT 1 APPROPRIATIONS SPENDING LIMIT 2016-17 APPROPRIATIONS SPENDING LIMIT Last Year's Limit Adjustment Factors 1 2 Inflation % 1.0071 Population % 1.0537 Total Adjustment % Annual Adjustment Adjustments Total Adjustments ROPRIA;TI0NS SP 90,095,588 1.06118 5,512,162 None 5,512,162 2016-17 APPROPRIATIONS SUBJECT TO LIMITATION PROCEEDS OF TAXES EXCLUSIONS APPROPRIATIONS SUBJECT TO LIMITATION CURRENT YEAR LIMIT 37,281,365 37,281,365 95,607,750 EXHIBIT A City of Lodi Appropriations Spending Limit Fiscal Year 2016-17 Moen Sgi[rfir'F��s • • • • A. Last Year's Limit B. Adjustments Factors 1 Population % 2 Inflation % Total Adjustment % C. Annual Adjustment D. Other Adjustments E. Total Adjustments F. This Year's Limit 90,095,588 1.0537 1.0071 1.06118 5,512,162 None 5.512,162 95,607,750 (Exhibit B) (State Finance) (B1*B2) (B*A) (C+D) (A+E) City of Lodi Appropriations Spending Limit Growth Factors/Calculations GROWTH FACTORS: lte 87-88 3.47 88-89 4.66 89-90 5.19 90-91 4.21 91-92 4.14 92-93 -0.64 EXHIBIT B %Increase %Increase VItY : Co it Of Pupn1AE(4h :=: Fapliieiiop . . 5.72 3.33 4.96 3.32 2.52 2.20 2.26 2.23 1.19 2.64 0.97 2.41 93-94 2.72 0.73 2.13 94-95 0.71 95-96 4.72 96-97 4.67 97-98 4.67 98-99 4.15 0.51 1.57 1.31 1.59 1.68 1.85 0.70 1.21 1.16 1.47 99-00 4.53 1.94 1.44 00-01 4.91 01-02 7.82 02-03 -1.27 1.29 1.78 1.90 2.71 2.14 3.07 03-04 2.31 1.69 2.86 04-05 3.28 0.75 2.54 05-06 5.26 0.96 2.65 06-07 3.96 07-08 4.42 0.30 2.00 0.90 1.73 08-09 4.29 0.68 1.59 09-10 0.62 0.42 1.07 10-11 -2.54 0.61 0.97 11-12 2.51 0.61 0.97 12-13 3.77 0.77 1.05 13-14 5.12 14-15 -0.23 15-16 3.82 16-17 5.37 CALCULATIONS: 0.57 0.95 0.66 0.35 0.71 1.10 1.43 1.27 It iniio it 87-88 1.0347 x 1.0572 = 1.0939 1.0939 x 822,654,797 88-89 89-90 90-91 91-92 1.0466x1.0496=1.0985 1.0985 x $24,782,072 1.0519 x 1.0252 = 1.0784 1.0784 x $27,223,106 1.0421 x 1.0226 =1.0657 1.0657 x $29,357,398 1.0414 x 1.0264 =1.0689 p�f�inhdi;i;i;d ��$ht[$�E�E�E'•E $24,782,072 $27,223,106 $29,357,398 $31,286,179 1.0689 x $31,286,179 92-93 .9936 x 1.0241 =1.0175 1.0175 x 33,441,797 93-94 10272 x 1.0213 = 1.0491 1.0491x 34,027,028 94-95 1.0071 x 1.0157 = 1.0229 1.0229 x 35,697,755 95-96 1.0472 x 1.0131 =1.0609 1.0609 x 36,515,234 96-97 1.0467x1.0168=1.0643 1.0643 x 38739012 $33,441,797 $34,027,028 535,697,755 $36,515,234 538,739,012 $41,229,332 97-98 1.0467x1.0070=1.0540 1.0540x 41,229,332 - 543,456,825 98-99 1.0415x1.01160=1.0536 1.0536x 43,456,825 $45,785,303 99-00 1.0453x1.0194=1.0656 1.0656x45,785,303 548,787,849 00-01 1.0491x1.0129=1.0626 1.0626x48,787,849 551,843,597 01-02 1.0782x1.0190=1.0987 556,959,824 1.0986858 02-03 .9873x1.0214=1.00843 557,439,894 1.00842822 03-04 1.0231x1.0169=1.0404 $59,759,913 1.04039039 04-05 1.0328x1.0075=1.040546 562,182,939 1.040546 05-06 1.0526x1.0096=1.06270496 $66,082,118 1.06270496 06-07 1.0396x1.0030=1.0427188 $68,905,066 1.0427188 07-08 1.0442x1.0090=1.0535978 872,598,226 1.0535978 08-09 1.0429x1.0068=1.0499917 $76,227,535 1.0499917 09-10 1.0062x1.0042=1.01042604 $77,022,286 1.01042604 10-11 .9746x1.0061=.98054506 575,523,822 0.98054506 11-12 1.0251x1.0061=1.03135311 $77,891,729 1.03135311 12-13 1.0377x1.0077=1.04569029 $81,450,625 1.04569029 13-14 1.0512"1.0057=1.05719184 $86,108,936 1.05719184 14-15 0.9977x1.0066=1.00428482 $86,477,897 1.00428482 15-16 1.0382x1.0035=1.04183370 $90,095,588 1.04183370 16-17 1.0537x1.0071=1.06118127 595,607,750 1.06118127 16-17 Appropriations Subject to Limit: 837.281.765 $95.607,750 38.99° o APPROPRIATIONS SUBJECT TO LIMITATION City of Lodi Fiscal Year 2016-17 • EXHIBIT C A. PROCEEDS OF TAXES B. EXCLUSIONS C. APPROPRIATIONS SUBJECT TO LIMITATION D. CURRENT YEAR LIMIT E. OVER(UNDER) LIMIT 37.281.365 = 95,607,750 37,281,365 0 37,281,365 95.607.750 (58,326,385) 38.99% (Exhibit F) (Exhibit D) (A -B) (Exhibit A) (C -D) EXCLUDED APPROPRIATIONS City of Lodi Fiscal Year 2016-17 EXHIBIT D CATEGOR COURT ORDERS FEDERAL MANDATES Subtotal Subtotal QUALIFIED CAPITAL OUTLAYS Subtotal QUALIFIED DEBT SERVICE Subtotal TOTAL EXCLUDABLE (Copy to Exhibit C & G) None None None None None City of Lodi Schedule to Match User Fees to Costs Fiscal Year 2016-17 EXHIBIT E �kl��int i111 '�ce.S Alii se :fees Public Safety Fees 379,750 Parks and Rec/Cultural Fees 1,799,370 Community Development Fees 529,300 PW Engineering Fees 558,310 Library Fees 35,000 Total 31,425,050 6,292,640 1,870,120 1,291,990 1,362,400 0 0 0 0 0 3,301,730 42,242,200 0 194,251,880 J Calculation - Proceeds of Taxes City of Lodi Fiscal Year 2016-17 EXHIBIT F TAXES: Property Taxes Sales & Use Tax Business License Tax Franchise Tax Transient Occupancy Tax Real Property -Documentary Tax In -Lieu Franchise Tax FROM STATE Motor Vehicle In Lieu State H -way Maintenance Gas Tax Cigarette tax Transportation Development Act TDA -Pedestrian/Bike Path SB 300 Transportation Partnership Measure K Funds State Reimbursements -POST Public Library grants PERS Rebate SB90 Reimbursements Asset Seizure Funds/Auto Theft Drug Suppression Grant State special grants Traffic Congestion Relief State STIP reimbursement LOCALLY RAISED Fines, Forfeitures, Penalties Licenses and permits Rent of City Property Development Fees USER FEES (from Exhibit E) OTHER MISCELLANEOUS Sale of Property Restitution -Damage to Property Other revenue Interfund Transfers SUB -TOTAL (for Exhibit G) INTEREST EARNINGS (from Exhibit G) TOTAL REVENUE (use for Exhibit C) RESERVE WITHDRAWALS (Including appropriated Fund Balance) TOTAL OF THESE FUNDS OTHER FUNDS NOT INCLUDED GRAND TOTAL BUDGET QP •:.-M9.5.4 I? E f 9.496,810 1,457,500 9,496,810 11.526,070 367.730 11,893,800 1.470.000 1,307,450 1,470:000 1,906,000 1.607.160 1,906,000 650,000 3,650,000 650,000 160,000 47,100 160,000 7.131.330 0 7,131,330 4.896.230 1,457,500 4,896,230 11,400 11,400 1,307,450 1,307,450 1.607.160 0 3,650,000 3,650,000 47,100 47.100 0 0 930,000 930,000 35,000 35,000 15.000 15,000 0 0 50,000 50,000 0 0 301.410 301,410 361,980 361,980 0 0 0 0 0 3,301,730 3,301,730 1 1,457,500 1,457,500 1,298,480 1,298,480 1,988,000 1,988,000 1.607.160 1,607,160 0 3,301,730 3,301,730 1 4,000,000 4,000,000 37,236,440 22,060,560 59,297,000 44,925 1 26,615 1 71,540 37,281,365 1 22,087,175 1 59,368,540 1 0 59,368,540 L 134,883,340 t: 1 402,000 402,000 0 0 928.620 928,620 4,000,000 4,000,000 37,236,440 22,060,560 59,297,000 44,925 1 26,615 1 71,540 37,281,365 1 22,087,175 1 59,368,540 1 0 59,368,540 L 134,883,340 t: 1 44,925 I Interest Earnings Produced by Taxes City of Lodi Fiscal Year 2016-17 EXHIBIT G A. NON-INTEREST TAX PROCEEDS B. MINUS EXCLUSIONS C. NET INVESTED TAXES D. TOTAL NON-INTEREST BUDGET E. TAX PROCEEDS AS PERCENT OF BUDGET F. INTEREST EARNINGS G. AMOUNT OF INTEREST EARNED FROM TAXES H. AMOUNT OF INTEREST EARNED ON NON -TAXES I. Take the result of steps #G & H Copy on to Exhibit F 37,236,440 0 L 37,236,440 59,297,000 62.80% 71,540 26.615 ^(Exhibit F) (Exhibit D) (A -B) "(Exhibit F) (C/D) (E*F) (F -G) RESOLUTION NO. 2016-91 A RESOLUTION OF THE LODI CITY COUNCIL ADOPTING THE CITY OF LODI FINANCIAL PLAN AND BUDGET FOR THE FISCAL YEAR BEGINNING JULY 1, 2016 AND ENDING JUNE 30, 2017, AND APPROVING THE 2016/17 APPROPRIATIONS SPENDING LIMIT WHEREAS, the City Manager submitted the 2016/17 Financial Plan and Budget to the City Council on May 12, 2016; and WHEREAS, the 2016/17 Financial Plan and 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 April 26, May 10, May 24, May 31, and June 1, 2016, at the Carnegie Forum; and WHEREAS, the City Council is required to adopt the Appropriations Spending Limit for 2016/17; and WHEREAS, the Appropriations Spending Limit and the annual adjustment factors selected to calculate the Limit are part of the Financial Plan and Budget. follows: NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Lodi as 1. That the 2016/17 Financial Plan and Budget, as proposed by the City Manager, be approved as follows: Budget General Fund Police $19,872,500 Fire $11,552,550 Public Works $2,177,750 City Clerk $686,170 City Manager $477,810 City Attorney $530,830 Internal Services $3,826,830 Economic Development $589,910 Non -Departmental $8,765,760 Total General Fund $48,480,110 Other Funds Electric Utility $73,705,900 Water Utility $11,632,580 Wastewater Utility $20,965,390 Transit $5,894,270 Streets $3,887,610 Community Development $2,192,120 Parks, Rec & Cultural Services $6,292,640 Library $1,362,400 Transportation Development Act $30,000 Community Dev Block Grant $1,128,620 Public Safety Special Revenue $464,790 Capital Outlay $984,740 Equip & Vehicle Replacement $584,000 Debt Service $1,756,780 Benefits $8,118,440 Self Insurance $3,620,720 Trust and Agency $62,500 Fleet Services $1,886,930 Total Other Funds $144,570,430 (1) (1) Park Maintenance Worker I/II Grand Total $193,050,540 2. That the funds for the 2016/17 Financial Plan and Budget are appropriated as summarized in the document on file in the City Clerk's Office; 3. That position additions and deletions be approved as shown in the table below effective July 1, 2016: Classification Department Number Electric Distribution Operator Electric 1 Electric Lineman/Linewoman Electric 1 Metering Technician Electric 1 Library Assistant Library (1) (1) Park Maintenance Worker I/II PRCS Police Records Clerk Police 1 Public Works Inspector I/ll Public Works 1 Plant and Equipment Mechanic Public Works 1 Net positions added 4 and; 4. That the Appropriations Spending Limit be increased by $5,512,162 from the 2015/16 level of $90,095,588 to the 2016/17 level of $95,607,750 in accordance with the calculations on Attachment 1 and Exhibits A through G. Dated: June 1, 2016 I hereby certify that Resolution No. 2016-91 was passed and adopted by the City Council of the City of Lodi in a regular meeting held June 1, 2016, by the following votes: AYES: COUNCIL MEMBERS — Johnson, Kuehne, Mounce, and Nakanishi NOES: COUNCIL MEMBERS — None ABSENT: COUNCIL MEMBERS — Mayor Chandler ABSTAIN: COUNCIL MEMBERS — None NIFER in FERRAIOLO fty Clerk 2016-91 2016-17 FINANCIAL PLAN AND BUDGET ATTACHMENT 1 APPROPRIATIONS SPENDING LIMIT 2016-17 APPROPRIATIONS SPENDING LIMIT Last Year's Limit Adjustment Factors 1 2 Inflation % 1.0071 Population % 1.0537 Total Adjustment % Annual Adjustment Adjustments Total Adjustments ROPRIA;TI0NS SP 90,095,588 1.06118 5,512,162 None 5,512,162 2016-17 APPROPRIATIONS SUBJECT TO LIMITATION PROCEEDS OF TAXES EXCLUSIONS APPROPRIATIONS SUBJECT TO LIMITATION CURRENT YEAR LIMIT 37,281,365 37,281,365 95,607,750 EXHIBIT A City of Lodi Appropriations Spending Limit Fiscal Year 2016-17 Moen Sgi[rfir'F��s • • • • A. Last Year's Limit B. Adjustments Factors 1 Population % 2 Inflation % Total Adjustment % C. Annual Adjustment D. Other Adjustments E. Total Adjustments F. This Year's Limit 90,095,588 1.0537 1.0071 1.06118 5,512,162 None 5.512,162 95,607,750 (Exhibit B) (State Finance) (B1*B2) (B*A) (C+D) (A+E) City of Lodi Appropriations Spending Limit Growth Factors/Calculations GROWTH FACTORS: lte 87-88 3.47 88-89 4.66 89-90 5.19 90-91 4.21 91-92 4.14 92-93 -0.64 EXHIBIT B %Increase %Increase VItY : Co it Of Pupn1AE(4h :=: Fapliieiiop . . 5.72 3.33 4.96 3.32 2.52 2.20 2.26 2.23 1.19 2.64 0.97 2.41 93-94 2.72 0.73 2.13 94-95 0.71 95-96 4.72 96-97 4.67 97-98 4.67 98-99 4.15 0.51 1.57 1.31 1.59 1.68 1.85 0.70 1.21 1.16 1.47 99-00 4.53 1.94 1.44 00-01 4.91 01-02 7.82 02-03 -1.27 1.29 1.78 1.90 2.71 2.14 3.07 03-04 2.31 1.69 2.86 04-05 3.28 0.75 2.54 05-06 5.26 0.96 2.65 06-07 3.96 07-08 4.42 0.30 2.00 0.90 1.73 08-09 4.29 0.68 1.59 09-10 0.62 0.42 1.07 10-11 -2.54 0.61 0.97 11-12 2.51 0.61 0.97 12-13 3.77 0.77 1.05 13-14 5.12 14-15 -0.23 15-16 3.82 16-17 5.37 CALCULATIONS: 0.57 0.95 0.66 0.35 0.71 1.10 1.43 1.27 It iniio it 87-88 1.0347 x 1.0572 = 1.0939 1.0939 x 822,654,797 88-89 89-90 90-91 91-92 1.0466x1.0496=1.0985 1.0985 x $24,782,072 1.0519 x 1.0252 = 1.0784 1.0784 x $27,223,106 1.0421 x 1.0226 =1.0657 1.0657 x $29,357,398 1.0414 x 1.0264 =1.0689 p�f�inhdi;i;i;d ��$ht[$�E�E�E'•E $24,782,072 $27,223,106 $29,357,398 $31,286,179 1.0689 x $31,286,179 92-93 .9936 x 1.0241 =1.0175 1.0175 x 33,441,797 93-94 10272 x 1.0213 = 1.0491 1.0491x 34,027,028 94-95 1.0071 x 1.0157 = 1.0229 1.0229 x 35,697,755 95-96 1.0472 x 1.0131 =1.0609 1.0609 x 36,515,234 96-97 1.0467x1.0168=1.0643 1.0643 x 38739012 $33,441,797 $34,027,028 535,697,755 $36,515,234 538,739,012 $41,229,332 97-98 1.0467x1.0070=1.0540 1.0540x 41,229,332 - 543,456,825 98-99 1.0415x1.01160=1.0536 1.0536x 43,456,825 $45,785,303 99-00 1.0453x1.0194=1.0656 1.0656x45,785,303 548,787,849 00-01 1.0491x1.0129=1.0626 1.0626x48,787,849 551,843,597 01-02 1.0782x1.0190=1.0987 556,959,824 1.0986858 02-03 .9873x1.0214=1.00843 557,439,894 1.00842822 03-04 1.0231x1.0169=1.0404 $59,759,913 1.04039039 04-05 1.0328x1.0075=1.040546 562,182,939 1.040546 05-06 1.0526x1.0096=1.06270496 $66,082,118 1.06270496 06-07 1.0396x1.0030=1.0427188 $68,905,066 1.0427188 07-08 1.0442x1.0090=1.0535978 872,598,226 1.0535978 08-09 1.0429x1.0068=1.0499917 $76,227,535 1.0499917 09-10 1.0062x1.0042=1.01042604 $77,022,286 1.01042604 10-11 .9746x1.0061=.98054506 575,523,822 0.98054506 11-12 1.0251x1.0061=1.03135311 $77,891,729 1.03135311 12-13 1.0377x1.0077=1.04569029 $81,450,625 1.04569029 13-14 1.0512"1.0057=1.05719184 $86,108,936 1.05719184 14-15 0.9977x1.0066=1.00428482 $86,477,897 1.00428482 15-16 1.0382x1.0035=1.04183370 $90,095,588 1.04183370 16-17 1.0537x1.0071=1.06118127 595,607,750 1.06118127 16-17 Appropriations Subject to Limit: 837.281.765 $95.607,750 38.99° o APPROPRIATIONS SUBJECT TO LIMITATION City of Lodi Fiscal Year 2016-17 • EXHIBIT C A. PROCEEDS OF TAXES B. EXCLUSIONS C. APPROPRIATIONS SUBJECT TO LIMITATION D. CURRENT YEAR LIMIT E. OVER(UNDER) LIMIT 37.281.365 = 95,607,750 37,281,365 0 37,281,365 95.607.750 (58,326,385) 38.99% (Exhibit F) (Exhibit D) (A -B) (Exhibit A) (C -D) EXCLUDED APPROPRIATIONS City of Lodi Fiscal Year 2016-17 EXHIBIT D CATEGOR COURT ORDERS FEDERAL MANDATES Subtotal Subtotal QUALIFIED CAPITAL OUTLAYS Subtotal QUALIFIED DEBT SERVICE Subtotal TOTAL EXCLUDABLE (Copy to Exhibit C & G) None None None None None City of Lodi Schedule to Match User Fees to Costs Fiscal Year 2016-17 EXHIBIT E �kl��int i111 '�ce.S Alii se :fees Public Safety Fees 379,750 Parks and Rec/Cultural Fees 1,799,370 Community Development Fees 529,300 PW Engineering Fees 558,310 Library Fees 35,000 Total 31,425,050 6,292,640 1,870,120 1,291,990 1,362,400 0 0 0 0 0 3,301,730 42,242,200 0 194,251,880 J Calculation - Proceeds of Taxes City of Lodi Fiscal Year 2016-17 EXHIBIT F TAXES: Property Taxes Sales & Use Tax Business License Tax Franchise Tax Transient Occupancy Tax Real Property -Documentary Tax In -Lieu Franchise Tax FROM STATE Motor Vehicle In Lieu State H -way Maintenance Gas Tax Cigarette tax Transportation Development Act TDA -Pedestrian/Bike Path SB 300 Transportation Partnership Measure K Funds State Reimbursements -POST Public Library grants PERS Rebate SB90 Reimbursements Asset Seizure Funds/Auto Theft Drug Suppression Grant State special grants Traffic Congestion Relief State STIP reimbursement LOCALLY RAISED Fines, Forfeitures, Penalties Licenses and permits Rent of City Property Development Fees USER FEES (from Exhibit E) OTHER MISCELLANEOUS Sale of Property Restitution -Damage to Property Other revenue Interfund Transfers SUB -TOTAL (for Exhibit G) INTEREST EARNINGS (from Exhibit G) TOTAL REVENUE (use for Exhibit C) RESERVE WITHDRAWALS (Including appropriated Fund Balance) TOTAL OF THESE FUNDS OTHER FUNDS NOT INCLUDED GRAND TOTAL BUDGET QP •:.-M9.5.4 I? E f 9.496,810 1,457,500 9,496,810 11.526,070 367.730 11,893,800 1.470.000 1,307,450 1,470:000 1,906,000 1.607.160 1,906,000 650,000 3,650,000 650,000 160,000 47,100 160,000 7.131.330 0 7,131,330 4.896.230 1,457,500 4,896,230 11,400 11,400 1,307,450 1,307,450 1.607.160 0 3,650,000 3,650,000 47,100 47.100 0 0 930,000 930,000 35,000 35,000 15.000 15,000 0 0 50,000 50,000 0 0 301.410 301,410 361,980 361,980 0 0 0 0 0 3,301,730 3,301,730 1 1,457,500 1,457,500 1,298,480 1,298,480 1,988,000 1,988,000 1.607.160 1,607,160 0 3,301,730 3,301,730 1 4,000,000 4,000,000 37,236,440 22,060,560 59,297,000 44,925 1 26,615 1 71,540 37,281,365 1 22,087,175 1 59,368,540 1 0 59,368,540 L 134,883,340 t: 1 402,000 402,000 0 0 928.620 928,620 4,000,000 4,000,000 37,236,440 22,060,560 59,297,000 44,925 1 26,615 1 71,540 37,281,365 1 22,087,175 1 59,368,540 1 0 59,368,540 L 134,883,340 t: 1 44,925 I Interest Earnings Produced by Taxes City of Lodi Fiscal Year 2016-17 EXHIBIT G A. NON-INTEREST TAX PROCEEDS B. MINUS EXCLUSIONS C. NET INVESTED TAXES D. TOTAL NON-INTEREST BUDGET E. TAX PROCEEDS AS PERCENT OF BUDGET F. INTEREST EARNINGS G. AMOUNT OF INTEREST EARNED FROM TAXES H. AMOUNT OF INTEREST EARNED ON NON -TAXES I. Take the result of steps #G & H Copy on to Exhibit F 37,236,440 0 L 37,236,440 59,297,000 62.80% 71,540 26.615 ^(Exhibit F) (Exhibit D) (A -B) "(Exhibit F) (C/D) (E*F) (F -G) CL Fiscal Year 2016/17 Budget City Council Meeting June 1, 2016 [Overview General Fund summary Significant issues Major capital projects [All Funds Total revenue of $203,577,710 Total appropriation of $193,050,540 Increase in reserves of $10,527,170 o General Fund ($1,564,090) o Enterprise funds ($19,970) o Special Revenue $11,137,470 o Others $973,760 [General Fund Statement of Estimated Changes in Fund Balance For the Fiscal Year Ended June 30, 2017 With Audited Actuals for FY 2013-14 and FY 2014-15 and Comparative Budget FY 2015-16 General Fund Fund Balance Beginning Fund Balance Unreserved 7,559,467 8,950,876 10,692,396 11,842,218 10,359,298 Audited Audited 2013-14 2014-15 Actuals Actuals 2015-16 Budget Estimated 2015-16 Actuals 2016-17 Budget Revenues 43,428,188 46,181,151 46,708,260 46,307,530 46,916,020 Expenditures 42,036,779 43,289,809 47,790,450 47,790,450 48,480,110 Net Difference (Revenues Less Expenditures) 1,391,409 2,891,342 (1,082,190) (1,482,920) (1,564,090) Fund Balance Ending Fund Balance Unreserved* 8,950,876 11,842,218 9,610,206 10,359,298 8,795,208 *Composed of Catastrophic & Economic reserve ($3,753,282 each); DIVCA reserve ($345,294); 4 designated for settled labor agreements ($943,350) [General Fund Drawing down reserves by $1,564,090 o Partial restoration of employee concessions Reserve Target met No uncommitted, undesignated reserves Labor 397 funded positions o 4 more than prior year All employee groups under contract through December 2017 o Designated reserves fund labor agreements thru December 2017 [Positions Recommended position changes Classification Department Number Electric Distribution Operator Electric 1 Electric Lineman/Linewoman Electric 1 Metering Technician Electric 1 Library Assistant Library (1) Park Maintenance Worker I/11 PRCS (1) Police Records Clerk Police 1 Public Works Inspector 1/11 Public Works 1 Plant and Equipment Mechanic Public Works 1 Net positions added 4 7 [PERS Projections 2016/17 2017/18* 2018/19* 2019/20* 2020/21* 2021/22* Vlscellaoeous 21.797/ 23.1% 25.6% 27.4% 27.7/ 283% Safety 44.154% 47.7% 50.7% 533% 54.5% 55.2% Estimated Cost $9.2V $10.2V $11,2V $12.3V $12,8V $134V *Projected rates from PERS actuarial report [Major Capital Projects Wastewater System Maintenance ($9.85M) Electric System Maintenance ($4.3M) Road Maintenance/Resurfacing ($1.4M) Water System Improvements ($1.2M) [Action Requested Adopt resolution approving the City of Lodi Financial Plan and Budget for FY 2016/17 and approving the FY 2016/17 Appropriation Spending Limit CQuestions?