California Adult Education Program
Fiscal Reporting

Produced: Sep 26, 2023, 08:24 PM UTC - By Fareha Bakre

Alameda Co. Office of Education

2022-23 Q4

Submitted by Tracey Burns
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$13,810

$0
100%
$0
100%
-$13,810
2000 - Non-Instructional Salaries

$0

$0
100%
$0
100%
$0
3000 - Employee Benefits

$3,445

$0
100%
$0
100%
-$3,445
4000 - Supplies and Materials

$0

$422
0%
$1,689
0%
$1,689
5000 - Other Operating Expenses and Services

$3,460

$5,000
69.2%
$20,001
17.3%
$16,541
6000 - Capital Outlay

$0

$0
100%
$0
100%
$0
7000 - Other Outgo

$2,059

$0
100%
$0
100%
-$2,059
Indirect Costs

$0

$271
0%
$1,084
0%
$1,084
Totals $22,774 $5,694 400% $22,774 100% $0

The school originally place all of the funding in object code 5000 (other operating expenses and services) because there was no plan indicating how the funding was to be spent. According to the trial balance worksheet, the breakdown of the expenditures will align to what is being reported and verifies that all funding has been spent for the 2022-23 school year. 

Alameda Unified

2022-23 Q4

Submitted by Joy Chua
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$399,856

$105,178
380.17%
$420,711
95.04%
$20,855
2000 - Non-Instructional Salaries

$199,840

$53,768
371.67%
$215,071
92.92%
$15,231
3000 - Employee Benefits

$177,134

$49,479
358%
$197,916
89.5%
$20,782
4000 - Supplies and Materials

$35,943

$8,755
410.53%
$35,021
102.63%
-$922
5000 - Other Operating Expenses and Services

$50,308

$6,127
821.05%
$24,509
205.26%
-$25,799
6000 - Capital Outlay

$0

$0
100%
$0
100%
$0
7000 - Other Outgo

$43,278

$10,680
405.22%
$42,720
101.31%
-$558
Indirect Costs

$0

$0
100%
$0
100%
$0
Totals $906,359 $233,987 387.35% $935,948 96.84% $29,589
Not Entered

Berkeley City College

2022-23 Q4

Submitted by Lilia Celhay
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$2,401

$0
100%
$0
100%
-$2,401
2000 - Non-Instructional Salaries

$124,153

$176,500
70.34%
$176,500
70.34%
$52,347
3000 - Employee Benefits

$51,815

$41,332
125.36%
$41,332
125.36%
-$10,483
4000 - Supplies and Materials

$1,478

$1,550
95.35%
$1,550
95.35%
$72
5000 - Other Operating Expenses and Services

$25

$10,023
0.25%
$10,023
0.25%
$9,998
6000 - Capital Outlay

$3,433

$0
100%
$0
100%
-$3,433
7000 - Other Outgo

$0

$0
100%
$0
100%
$0
Indirect Costs

$0

$0
100%
$0
100%
$0
Totals $183,305 $229,405 79.9% $229,405 79.9% $46,100

For the 1000 series, we got a one-time funding from the consortium to look at retention of non-credit ESOL students. For the 3000 series, there were salary increases due to COLA adjustments in Peralta. For the 6000 series, the seven-year old  laptop for the project manager broke, so a replacement had to be purchased. 

Berkeley Unified

2022-23 Q4

Submitted by Thomas Reid
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$1,547,121

$2,669,763
57.95%
$2,669,763
57.95%
$1,122,642
2000 - Non-Instructional Salaries

$710,876

$595,067
119.46%
$595,067
119.46%
-$115,809
3000 - Employee Benefits

$587,773

$984,576
59.7%
$984,576
59.7%
$396,803
4000 - Supplies and Materials

$287,940

$93,376
308.37%
$93,376
308.37%
-$194,564
5000 - Other Operating Expenses and Services

$240,512

$240,128
100.16%
$240,128
100.16%
-$384
6000 - Capital Outlay

$20,443

$0
100%
$0
100%
-$20,443
7000 - Other Outgo

$168,711

$170,917
98.71%
$170,917
98.71%
$2,206
Indirect Costs

$0

$0
100%
$0
100%
$0
Totals $3,563,376 $4,753,827 74.96% $4,753,827 74.96% $1,190,451

2000 Underestimated impact of raises on classified staff expenditures.

4000 Purchased technology to enhance student access to learning, not in initial budget submitted to NOVA.

5000 Went over a tiny bit here.

6000 Purchase of classroom technology, Promethean Boards, per-unit price makes them classified as capital outlay.

College of Alameda

2022-23 Q4

Submitted by Kawanna Rollins
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$0

$0
100%
$0
100%
$0
2000 - Non-Instructional Salaries

$105,281

$63,547
165.68%
$105,911
99.41%
$630
3000 - Employee Benefits

$74,062

$44,899
164.95%
$74,831
98.97%
$769
4000 - Supplies and Materials

$526

$600
87.67%
$1,000
52.6%
$474
5000 - Other Operating Expenses and Services

$1,627

$8,086
20.12%
$13,477
12.07%
$11,850
6000 - Capital Outlay

$1,665

$974
170.98%
$1,623
102.59%
-$42
7000 - Other Outgo

$0

$0
100%
$0
100%
$0
Indirect Costs

$0

$0
100%
$0
100%
$0
Totals $183,161 $118,105 155.08% $196,842 93.05% $13,681
Not Entered

Laney College

2022-23 Q4

Submitted by Elizabeth Maher
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$5,990

$45,000
13.31%
$45,000
13.31%
$39,010
2000 - Non-Instructional Salaries

$50,294

$165,000
30.48%
$165,000
30.48%
$114,706
3000 - Employee Benefits

$29,154

$61,338
47.53%
$61,338
47.53%
$32,184
4000 - Supplies and Materials

$0

$5,000
0%
$5,000
0%
$5,000
5000 - Other Operating Expenses and Services

$754

$20,666
3.65%
$20,666
3.65%
$19,912
6000 - Capital Outlay

$0

$0
100%
$0
100%
$0
7000 - Other Outgo

$0

$0
100%
$0
100%
$0
Indirect Costs

$0

$0
100%
$0
100%
$0
Totals $86,192 $297,004 29.02% $297,004 29.02% $210,812
Not Entered

Merritt College

2022-23 Q4

Submitted by Victor Littles
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$0

$0
100%
$0
100%
$0
2000 - Non-Instructional Salaries

$115,161

$105,000
109.68%
$105,000
109.68%
-$10,161
3000 - Employee Benefits

$66,016

$70,000
94.31%
$70,000
94.31%
$3,984
4000 - Supplies and Materials

$6,335

$3,343
189.5%
$3,343
189.5%
-$2,992
5000 - Other Operating Expenses and Services

$0

$20,000
0%
$20,000
0%
$20,000
6000 - Capital Outlay

$0

$0
100%
$0
100%
$0
7000 - Other Outgo

$0

$0
100%
$0
100%
$0
Indirect Costs

$0

$0
100%
$0
100%
$0
Totals $187,512 $198,343 94.54% $198,343 94.54% $10,831
Not Entered

Oakland Unified

2022-23 Q4

Submitted by Kim Jones
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$1,490,258

$1,556,400
95.75%
$1,556,400
95.75%
$66,142
2000 - Non-Instructional Salaries

$577,856

$331,484
174.32%
$331,484
174.32%
-$246,372
3000 - Employee Benefits

$769,932

$983,089
78.32%
$983,089
78.32%
$213,157
4000 - Supplies and Materials

$49,435

$42,000
117.7%
$42,000
117.7%
-$7,435
5000 - Other Operating Expenses and Services

$245,620

$166,190
147.79%
$166,190
147.79%
-$79,430
6000 - Capital Outlay

$0

$0
100%
$0
100%
$0
7000 - Other Outgo

$78,927

$128,526
61.41%
$128,526
61.41%
$49,599
Indirect Costs

$0

$0
100%
$0
100%
$0
Totals $3,212,028 $3,207,689 100.14% $3,207,689 100.14% -$4,339

The expenditures for object 2000 were entered incorrectly in a previous quarter and now I am unable to enter the correct dollar amount for Q4...

Kim



Peralta CCD

2022-23 Q4

Submitted by Shemila Johnson
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$0

$0
100%
$0
100%
$0
2000 - Non-Instructional Salaries

$295,352

$294,111
100.42%
$294,111
100.42%
-$1,241
3000 - Employee Benefits

$151,946

$155,246
97.87%
$155,246
97.87%
$3,300
4000 - Supplies and Materials

$0

$8,459
0%
$8,459
0%
$8,459
5000 - Other Operating Expenses and Services

$269,168

$241,341
111.53%
$241,341
111.53%
-$27,827
6000 - Capital Outlay

$0

$0
100%
$0
100%
$0
7000 - Other Outgo

$0

$0
100%
$0
100%
$0
Indirect Costs

$26,483

$0
100%
$0
100%
-$26,483
Totals $742,949 $699,157 106.26% $699,157 106.26% -$43,792
Not Entered

Piedmont City Unified

2022-23 Q4

Submitted by Ms. Shannon Fierro
Approved by Fareha Bakre
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$158,259

$42,768
370.04%
$171,071
92.51%
$12,812
2000 - Non-Instructional Salaries

$117,341

$26,186
448.11%
$104,742
112.03%
-$12,599
3000 - Employee Benefits

$126,150

$34,804
362.46%
$139,215
90.62%
$13,065
4000 - Supplies and Materials

$4,628

$250
1,851.2%
$1,000
462.8%
-$3,628
5000 - Other Operating Expenses and Services

$57,536

$9,069
634.46%
$36,274
158.61%
-$21,262
6000 - Capital Outlay

$0

$0
100%
$0
100%
$0
7000 - Other Outgo

$11,806

$5,861
201.42%
$23,445
50.36%
$11,639
Indirect Costs

$0

$0
100%
$0
100%
$0
Totals $475,720 $118,937 399.98% $475,747 99.99% $27
Not Entered