nova-logo-final2

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

Alameda Unified

2021-22 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

$404,359

$433,179 93.35% $433,179 93.35% $28,820
2000 - Non-Instructional Salaries

$180,890

$190,890 94.76% $190,890 94.76% $10,000
3000 - Employee Benefits

$153,557

$153,557 100% $153,557 100% $0
4000 - Supplies and Materials

$58,350

$58,350 100% $58,350 100% $0
5000 - Other Operating Expenses and Services

$46,251

$46,251 100% $46,251 100% $0
6000 - Capital Outlay

$0

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

$0

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

$42,170

$42,170 100% $42,170 100% $0
Totals $885,577 $924,397 95.8% $924,397 95.8% $38,820
Not Entered

Berkeley City College

2021-22 Q4

Submitted by Lisa Cook
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

$8,453

$8,000 105.66% $8,000 105.66% -$453
2000 - Non-Instructional Salaries

$134,077

$145,000 92.47% $145,000 92.47% $10,923
3000 - Employee Benefits

$46,906

$43,000 109.08% $43,000 109.08% -$3,906
4000 - Supplies and Materials

$750

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

$40,717

$58,966 69.05% $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 $230,903 $263,466 87.64% $263,466 87.64% $32,563
Not Entered

Berkeley Unified

2021-22 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,533,410

$1,551,277 98.85% $1,825,032 84.02% $291,622
2000 - Non-Instructional Salaries

$593,189

$495,063 119.82% $582,427 101.85% -$10,762
3000 - Employee Benefits

$495,541

$564,661 87.76% $664,307 74.6% $168,766
4000 - Supplies and Materials

$194,833

$444,307 43.85% $522,714 37.27% $327,881
5000 - Other Operating Expenses and Services

$317,551

$517,166 61.4% $608,431 52.19% $290,880
6000 - Capital Outlay

$0

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

$0

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

$156,726

$178,623 87.74% $210,145 74.58% $53,419
Totals $3,291,250 $3,751,098 87.74% $4,413,056 74.58% $1,121,806
Not Entered

College of Alameda

2021-22 Q4

Submitted by Dr. Tina Vasconcellos
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

$16,126

$8,206 196.52% $13,676 117.91% -$2,450
2000 - Non-Instructional Salaries

$99,518

$61,424 162.02% $102,373 97.21% $2,855
3000 - Employee Benefits

$73,366

$42,668 171.94% $71,114 103.17% -$2,252
4000 - Supplies and Materials

$0

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

$43,143

$4,200 1,027.21% $7,000 616.33% -$36,143
6000 - Capital Outlay

$4,009

$22,199 18.06% $36,999 10.84% $32,990
7000 - Other Outgo

$0

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

$0

$0 100% $0 100% $0
Totals $236,162 $141,697 166.67% $236,162 100% $0
Not Entered

Laney College

2021-22 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

$8,153

$104,000 7.84% $104,000 7.84% $95,847
2000 - Non-Instructional Salaries

$57,360

$119,640 47.94% $119,640 47.94% $62,280
3000 - Employee Benefits

$17,503

$62,097 28.19% $62,097 28.19% $44,594
4000 - Supplies and Materials

$100

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

$134,000

$0 100% $0 100% -$134,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 $217,116 $317,278 68.43% $317,278 68.43% $100,162
Not Entered

Merritt College

2021-22 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

$20,149

$40,000 50.37% $40,000 50.37% $19,851
2000 - Non-Instructional Salaries

$103,865

$145,000 71.63% $145,000 71.63% $41,135
3000 - Employee Benefits

$58,184

$43,000 135.31% $43,000 135.31% -$15,184
4000 - Supplies and Materials

$0

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

$135,914

$56,613 240.08% $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 $318,112 $319,613 99.53% $319,613 99.53% $1,501

Based on the fiscal agent final report, the Director is submitting on their behalf as no one from the college submitted the report.

Oakland Unified

2021-22 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,344,894

$1,673,705 80.35% $1,673,705 80.35% $328,811
2000 - Non-Instructional Salaries

$273,768

$356,447 76.8% $356,447 76.8% $82,679
3000 - Employee Benefits

$636,613

$914,281 69.63% $914,281 69.63% $277,668
4000 - Supplies and Materials

$88,704

$63,727 139.19% $63,727 139.19% -$24,977
5000 - Other Operating Expenses and Services

$302,224

$177,190 170.56% $177,190 170.56% -$125,034
6000 - Capital Outlay

$24,739

$0 100% $0 100% -$24,739
7000 - Other Outgo

$111,670

$125,392 89.06% $125,392 89.06% $13,722
Indirect Costs

$0

$0 100% $0 100% $0
Totals $2,782,612 $3,310,742 84.05% $3,310,742 84.05% $528,130
Not Entered

Peralta CCD

2021-22 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

$270,217

$272,915 99.01% $272,915 99.01% $2,698
3000 - Employee Benefits

$134,266

$136,943 98.05% $136,943 98.05% $2,677
4000 - Supplies and Materials

$103

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

$340,095

$372,438 91.32% $372,438 91.32% $32,343
6000 - Capital Outlay

$2,229

$0 100% $0 100% -$2,229
7000 - Other Outgo

$0

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

$32,924

$32,595 101.01% $32,595 101.01% -$329
Totals $779,834 $814,891 95.7% $814,891 95.7% $35,057

Per CAEP TAP office, we must under report this year to reconcile over reporting from prior years.  NOVA carry-over has always inaccurately reflected from the fiscal agent books once the system switched over from MIS.  The budget loaded in this system of 814,891 was inaccurate, the actual loaded budget on the fiscal agent side was $891,084 which is a $76,193 discrepancy.  In order to ensure the accurate carry-over from 21/22 properly reflects fiscal agency books with NOVA system, TAP directed the under-reporting of expenditures to true up our books moving forward.  The actual 21/22 expenditures a/o 9/16/22 fiscal agent report is $856,026.  Therefore the 21/22 actual loaded budget minus the 21/22 actual expenditures carry-over is $35,057 which is reflected in NOVA.

Piedmont City Unified

2021-22 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

$117,579

$155,000 75.86% $155,000 75.86% $37,421
2000 - Non-Instructional Salaries

$110,413

$110,000 100.38% $110,000 100.38% -$413
3000 - Employee Benefits

$102,806

$100,000 102.81% $100,000 102.81% -$2,806
4000 - Supplies and Materials

$1,117

$20,000 5.59% $20,000 5.59% $18,883
5000 - Other Operating Expenses and Services

$50,639

$40,000 126.6% $40,000 126.6% -$10,639
6000 - Capital Outlay

$0

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

$0

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

$19,128

$20,000 95.64% $20,000 95.64% $872
Totals $401,682 $466,543 86.1% $466,543 86.1% $64,861
Not Entered