nova-logo-final2

California Adult Education Program Fiscal Reporting 42 Northern Alameda Consortium for Adult Education

Alameda Unified

2021-22 Q2

Submitted by Dr. Lisa Gonzalves
Approved by Adil Ahmed
Object Code Year to Date (YTD) Expenditure YTD Forecast % Expended of YTD Forecast Project Budget % Expended of Project Budget Budget Remaining
1000 - Instructional Salaries

$138,517

$173,272 79.94% $433,179 31.98% $294,662
2000 - Non-Instructional Salaries

$69,902

$76,356 91.55% $190,890 36.62% $120,988
3000 - Employee Benefits

$57,721

$61,423 93.97% $153,557 37.59% $95,836
4000 - Supplies and Materials

$5,155

$23,340 22.09% $58,350 8.83% $53,195
5000 - Other Operating Expenses and Services

$21,769

$18,500 117.67% $46,251 47.07% $24,482
6000 - Capital Outlay

$0

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

$0

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

$0

$16,868 0% $42,170 0% $42,170
Totals $293,064 $369,759 79.26% $924,397 31.7% $631,333
Not Entered

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0

Berkeley City College

2021-22 Q2

Submitted by Shemila Johnson
Approved by Adil Ahmed
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,263

$4,000 56.58% $8,000 28.29% $5,737
2000 - Non-Instructional Salaries

$75,239

$72,500 103.78% $145,000 51.89% $69,761
3000 - Employee Benefits

$24,226

$21,500 112.68% $43,000 56.34% $18,774
4000 - Supplies and Materials

$750

$4,250 17.65% $8,500 8.82% $7,750
5000 - Other Operating Expenses and Services

$40,717

$29,483 138.1% $58,966 69.05% $18,249
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 $143,195 $131,733 108.7% $263,466 54.35% $120,271
Not Entered

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0

Berkeley Unified

2021-22 Q2

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

$508,884

$584,010 87.14% $1,825,032 27.88% $1,316,148
2000 - Non-Instructional Salaries

$254,194

$186,377 136.39% $582,427 43.64% $328,233
3000 - Employee Benefits

$207,648

$212,578 97.68% $664,307 31.26% $456,659
4000 - Supplies and Materials

$12,389

$167,268 7.41% $522,714 2.37% $510,325
5000 - Other Operating Expenses and Services

$127,025

$194,698 65.24% $608,431 20.88% $481,406
6000 - Capital Outlay

$0

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

$0

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

$55,507

$67,246 82.54% $210,145 26.41% $154,638
Totals $1,165,647 $1,412,178 82.54% $4,413,056 26.41% $3,247,409

Our practice is to spend down federal WIOA title II funds first, and then pick up a greater portion of our total cost using CAEP funds. the second half of the year will show an increase in the rate of CAEP spending.

Not Entered

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0

College of Alameda

2021-22 Q2

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

$12,706

$4,103 309.69% $13,676 92.91% $970
2000 - Non-Instructional Salaries

$53,096

$30,712 172.88% $102,373 51.87% $49,277
3000 - Employee Benefits

$38,786

$21,334 181.8% $71,114 54.54% $32,328
4000 - Supplies and Materials

$0

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

$43,143

$2,100 2,054.43% $7,000 616.33% -$36,143
6000 - Capital Outlay

$0

$11,100 0% $36,999 0% $36,999
7000 - Other Outgo

$0

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

$0

$0 100% $0 100% $0
Totals $147,731 $70,849 208.52% $236,162 62.55% $88,431
Not Entered

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0

Laney College

2021-22 Q2

Submitted by Shemila Johnson
Approved by Adil Ahmed
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

$52,000 0% $104,000 0% $104,000
2000 - Non-Instructional Salaries

$34,953

$59,820 58.43% $119,640 29.22% $84,687
3000 - Employee Benefits

$10,635

$31,049 34.25% $62,097 17.13% $51,462
4000 - Supplies and Materials

$100

$15,771 0.63% $31,541 0.32% $31,441
5000 - Other Operating Expenses and Services

$133,705

$0 100% $0 100% -$133,705
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 $179,393 $158,639 113.08% $317,278 56.54% $137,885
Not Entered

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0

Merritt College

2021-22 Q2

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

$3,920

$20,000 19.6% $40,000 9.8% $36,080
2000 - Non-Instructional Salaries

$63,830

$72,500 88.04% $145,000 44.02% $81,170
3000 - Employee Benefits

$16,434

$21,500 76.44% $43,000 38.22% $26,566
4000 - Supplies and Materials

$0

$17,500 0% $35,000 0% $35,000
5000 - Other Operating Expenses and Services

$135,914

$28,307 480.15% $56,613 240.08% -$79,301
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 $220,098 $159,807 137.73% $319,613 68.86% $99,515

Per District Office Finance, I updated the Q2 expenditures based on Peoplesoft expenditures report with Fareha on 9/1/22.

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0

Oakland Unified

2021-22 Q2

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

$974,043

$836,853 116.39% $1,673,705 58.2% $699,662
2000 - Non-Instructional Salaries

$162,005

$178,224 90.9% $356,447 45.45% $194,442
3000 - Employee Benefits

$466,497

$457,141 102.05% $914,281 51.02% $447,784
4000 - Supplies and Materials

$38,869

$31,864 121.99% $63,727 60.99% $24,858
5000 - Other Operating Expenses and Services

$130,113

$88,595 146.86% $177,190 73.43% $47,077
6000 - Capital Outlay

$0

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

$70,628

$62,696 112.65% $125,392 56.33% $54,764
Indirect Costs

$0

$0 100% $0 100% $0
Totals $1,842,155 $1,655,371 111.28% $3,310,742 55.64% $1,468,587
Not Entered

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0

Peralta CCD

2021-22 Q2

Submitted by Shemila Johnson
Approved by Adil Ahmed
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

$133,760

$109,166 122.53% $272,915 49.01% $139,155
3000 - Employee Benefits

$66,479

$54,777 121.36% $136,943 48.55% $70,464
4000 - Supplies and Materials

$0

$0 100% $0 100% $0
5000 - Other Operating Expenses and Services

$130,831

$148,975 87.82% $372,438 35.13% $241,607
6000 - Capital Outlay

$0

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

$0

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

$0

$13,038 0% $32,595 0% $32,595
Totals $331,070 $325,956 101.57% $814,891 40.63% $483,821
Not Entered

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0

Piedmont City Unified

2021-22 Q2

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

$55,015

$77,500 70.99% $155,000 35.49% $99,985
2000 - Non-Instructional Salaries

$58,025

$55,000 105.5% $110,000 52.75% $51,975
3000 - Employee Benefits

$49,014

$50,000 98.03% $100,000 49.01% $50,986
4000 - Supplies and Materials

$324

$10,000 3.24% $20,000 1.62% $19,676
5000 - Other Operating Expenses and Services

$22,580

$20,000 112.9% $40,000 56.45% $17,420
6000 - Capital Outlay

$0

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

$0

$10,772 0% $21,543 0% $21,543
Indirect Costs

$0

$10,000 0% $20,000 0% $20,000
Totals $184,958 $233,272 79.29% $466,543 39.64% $281,585
Not Entered

Allocation Year 2019-20 Closeout

I have reviewed the fiscal reports for my agency and confirmed that all funds for this allocation year have been spent.

2019-20 Reverted Funds:
$0