Cities Index.
View Supplemental Spreadsheet - 7/22/2022

Oakland City Council
July 11, 2022

Document
View Supplemental Spreadsheet - 7/22/2022
Meeting
July 11, 2022
Body
Oakland City Council
Original file
482 KB
Text extracted from the city's file for reading and search. Open the original on oakland.legistar1.com. That file is the official record.

Exhibit 2
Item # Fund Dept. Description FY 2022-23
Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
Subtotal Revenue Adjustments - - - Item # Fund Dept. Description (Include Job Class & FTE) FY 2022-23 Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
Vacancy Rate Savings/ Available Fund
Balance
(see Funds & Amounts below)
(3,381,710) (3,381,710)
Subtotal of Expenditure Reductions (3,381,710) - (3,381,710) FY 2022-23
Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
3,381,710 - 3,381,710 Item # Fund Dept. Description (Include Job Class & FTE) FY 2022-23 Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
D1 1030 All Labor MOU's 1,393 1,393 Balance needed to fully fund D2 1150 All Labor MOU's 693 693 Balance needed to fully fund D3 1610 All Labor MOU's 150 150 Balance needed to fully fund D4 1700 All Labor MOU's 2,585 2,585 Balance needed to fully fund D5 1710 All Labor MOU's 1,069 1,069 Balance needed to fully fund D6 1720 All Labor MOU's 80,723 80,723 Balance needed to fully fund D7 1750 All Labor MOU's 2,095 2,095 Balance needed to fully fund D8 1760 All Labor MOU's 610 610 Balance needed to fully fund D9 1770 All Labor MOU's 115 115 Balance needed to fully fund D10 1780 All Labor MOU's 327 327 Balance needed to fully fund D11 1820 All Labor MOU's 5,442 5,442 Balance needed to fully fund D12 1870 All Labor MOU's 7,634 7,634 Balance needed to fully fund D13 1885 All Labor MOU's 162 162 Balance needed to fully fund D14 2103 All Labor MOU's 51 51 Balance needed to fully fund D15 2108 All Labor MOU's 1,198 1,198 Balance needed to fully fund D16 2109 All Labor MOU's 110 110 Balance needed to fully fund D17 2120 All Labor MOU's 64 64 Balance needed to fully fund FY 2022-23 COUNCIL AMENDMENTS - ADOPTED MIDCYCLE BUDGET 7-26-22 Non-General Purpose Funds
REVENUE ADDITIONS (POSITIVE #) & REDUCTIONS (NEGATIVE #) EXPENDITURE REDUCTIONS (NEGATIVE #)

FUNDS AVAILABLE FOR PROGRAMMING
EXPENDITURE ADDITIONS (POSITIVE #)
C1 All All

SUB TOTAL CITYWIDE INVESTMENTS
1 of 4
Exhibit 2
FY 2022-23 COUNCIL AMENDMENTS - ADOPTED MIDCYCLE BUDGET 7-26-22 Non-General Purpose Funds
D18 2123 All Labor MOU's 234 234 Balance needed to fully fund D19 2124 All Labor MOU's 7,754 7,754 Balance needed to fully fund D20 2128 All Labor MOU's 18,341 18,341 Balance needed to fully fund D21 2138 All Labor MOU's 2,074 2,074 Balance needed to fully fund D22 2139 All Labor MOU's 71 71 Balance needed to fully fund D23 2144 All Labor MOU's 23 23 Balance needed to fully fund D24 2152 All Labor MOU's 157 157 Balance needed to fully fund D25 2159 All Labor MOU's 25,848 25,848 Balance needed to fully fund D26 2160 All Labor MOU's 130 130 Balance needed to fully fund D27 2172 All Labor MOU's 367 367 Balance needed to fully fund D28 2195 All Labor MOU's 142 142 Balance needed to fully fund D29 2215 All Labor MOU's 2,257 2,257 Balance needed to fully fund D30 2218 All Labor MOU's 268,232 268,232 Balance needed to fully fund D31 2219 All Labor MOU's 365 365 Balance needed to fully fund D32 2220 All Labor MOU's 568 568 Balance needed to fully fund D33 2230 All Labor MOU's 53,660 53,660 Balance needed to fully fund D34 2232 All Labor MOU's 33,451 33,451 Balance needed to fully fund D35 2241 All Labor MOU's 99,587 99,587 Balance needed to fully fund D36 2243 All Labor MOU's 29,234 29,234 Balance needed to fully fund D37 2244 All Labor MOU's 55,964 55,964 Balance needed to fully fund D38 2250 All Labor MOU's 234 234 Balance needed to fully fund D39 2252 All Labor MOU's 38,126 38,126 Balance needed to fully fund D40 2261 All Labor MOU's 94 94 Balance needed to fully fund D41 2270 All Labor MOU's 63,591 63,591 Balance needed to fully fund D42 2310 All Labor MOU's 9,584 9,584 Balance needed to fully fund D43 2331 All Labor MOU's 9 9 Balance needed to fully fund D44 2332 All Labor MOU's 1,406 1,406 Balance needed to fully fund D45 2411 All Labor MOU's 6,838 6,838 Balance needed to fully fund D46 2412 All Labor MOU's 44,304 44,304 Balance needed to fully fund D47 2413 All Labor MOU's 3,217 3,217 Balance needed to fully fund D48 2415 All Labor MOU's 1,502,221 1,502,221 Balance needed to fully fund D49 2416 All Labor MOU's 206 206 Balance needed to fully fund D50 2419 All Labor MOU's 23 23 Balance needed to fully fund 2 of 4
Exhibit 2
FY 2022-23 COUNCIL AMENDMENTS - ADOPTED MIDCYCLE BUDGET 7-26-22 Non-General Purpose Funds
D51 2990 All Labor MOU's 53 53 Balance needed to fully fund D52 3100 All Labor MOU's 214,375 214,375 Balance needed to fully fund D53 3200 All Labor MOU's 241 241 Balance needed to fully fund D54 4100 All Labor MOU's 11,897 11,897 Balance needed to fully fund D55 4200 All Labor MOU's 1,606 1,606 Balance needed to fully fund D56 4210 All Labor MOU's 23 23 Balance needed to fully fund D57 4300 All Labor MOU's 904 904 Balance needed to fully fund D58 4400 All Labor MOU's 24,459 24,459 Balance needed to fully fund D59 4450 All Labor MOU's 47 47 Balance needed to fully fund D60 4500 All Labor MOU's 94 94 Balance needed to fully fund D61 4550 All Labor MOU's 684 684 Balance needed to fully fund D62 4600 All Labor MOU's 7,322 7,322 Balance needed to fully fund D63 5322 All Labor MOU's 182 182 Balance needed to fully fund D64 5333 All Labor MOU's 333 333 Balance needed to fully fund D65 5505 All Labor MOU's 47 47 Balance needed to fully fund D66 5610 All Labor MOU's 788 788 Balance needed to fully fund D67 5638 All Labor MOU's 14 14 Balance needed to fully fund D68 5643 All Labor MOU's 53 53 Balance needed to fully fund D69 5650 All Labor MOU's 13 13 Balance needed to fully fund D70 5656 All Labor MOU's 131 131 Balance needed to fully fund D71 5671 All Labor MOU's 174 174 Balance needed to fully fund D72 5999 All Labor MOU's 211 211 Balance needed to fully fund D73 7100 All Labor MOU's 229 229 Balance needed to fully fund D74 7760 All Labor MOU's 745,096 745,096 Balance needed to fully fund Subtotal of Expenditure Additions 3,381,710 - 3,381,710 FY 2022-23
Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
- - - SURPLUS / (DEFICIT) 3 of 4
Exhibit 2
Item # Fund Dept. Description FY 2022-23
Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
Subtotal Revenue Adjustments - - - Item # Fund Dept. Description (Include Job Class & FTE) FY 2022-23 Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
A1 1010 Non-Departmental OACCA Debt Service Reduction (2,500,000) (2,500,000) From Admin A2 1010 Fire EOC Carryforward (2,285,085) (2,285,085) From Admin A3 1010 Police Salary Savings (2,397,725) (2,397,725) From Admin A4 1010 Human Resources Reimagining Recruitment and Retention (150,000) (150,000) From Admin A5 1010 Housing
Reallocate anti-displacement/emergency
rental assistance funds to Oakland Housing
Secure
(250,000) (250,000)Clarify Item C4, Exhibit 2 of the June 30, 2022 Council Budget Amendments
Subtotal of Expenditure Reductions - (7,582,810) (7,582,810) FY 2022-23
Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
- 7,582,810 7,582,810 Item # Fund Dept. Description (Include Job Class & FTE) FY 2022-23 Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
7,147,810 435,000 7,582,810 B1 1010 All Labor MOU's 7,147,810 7,147,810 Balance needed to fully fund B2 1010 Non-DepartmentalPLACE (People Linking Art Community& Ecology) for Sustainable Living 10,000 10,000 CM Kalb B3 1010 Human Services Plumbing for the City's E 12th Lakepoint Homeless Intervention Project 75,000 75,000 CP Bas B4 1010 Human Services Summer Food Program 100,000 100,000 Year Round lunch program for school children
offered through City's Department of Human
Services----'CM Kaplan
B5 1010 Housing Oakland Housing Secure (for direct rental assistance) 250,000 250,000 Clarify Item C4, Exhibit 2 of the June 30, 2022 Council Budget Amendments
Subtotal of Expenditure Additions 7,147,810 435,000 7,582,810 FY 2022-23
Ongoing
FY 2022-23
One-Time
FY 2022-23
Total Notes
(7,147,810) 7,147,810 - FY 2022-23 COUNCIL AMENDMENTS - ADOPTED MIDCYCLE BUDGET 7-26-22 FUND 1010 - GENERAL PURPOSE FUND
REVENUE ADDITIONS (POSITIVE #) & REDUCTIONS (NEGATIVE #) EXPENDITURE REDUCTIONS (NEGATIVE #)

FUNDS AVAILABLE FOR PROGRAMMING
EXPENDITURE ADDITIONS (POSITIVE #)

SUB TOTAL CITYWIDE INVESTMENTS

SURPLUS / (DEFICIT)
4 of 4

← All documents from this meeting