CAEP Consortium Fiscal Reporting 13 Morongo Basin AEBG Consortium (Copper Mountain)
Year: 2019-20
CAEP Consortium Fiscal Reporting 13 Morongo Basin AEBG Consortium (Copper Mountain)
2019-20 Fiscal Year
Fiscal Report Submittal Status
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | |
---|---|---|---|---|
Copper Mountain CCD | Submitted | Submitted | Submitted | Submitted |
Morongo Unified | Submitted | Submitted | Submitted | Submitted |
Copper Mountain CCD
Copper Mountain CCD Q1 Report (7/1 - 9/30)
Object Code | Year to Date (YTD) Expenditure | YTD Forecast | % Expended of YTD Forecast | Project Budget | % Expended of Overall Budget | Budget Remaining |
---|---|---|---|---|---|---|
1000 - Instructional Salaries | $1,787 | $6,208 | 28.79% | $38,581 | 4.63% | $36,794 |
2000 - Non-Instructional Salaries | $25,154 | $27,614 | 91.09% | $110,456 | 22.77% | $85,302 |
3000 - Employee Benefits | $18,031 | $18,471 | 97.62% | $73,884 | 24.4% | $55,853 |
4000 - Supplies and Materials | $0 | $4,250 | 0% | $17,000 | 0% | $17,000 |
5000 - Other Operating Expenses and Services | $44,513 | $85,446 | 52.1% | $341,782 | 13.02% | $297,269 |
6000 - Capital Outlay | $0 | $3,314 | 0% | $16,299 | 0% | $16,299 |
7000 - Other Outgo | $0 | $5,013 | 0% | $20,053 | 0% | $20,053 |
Indirect Costs | $0 | $0 | 100% | $0 | 100% | $0 |
Totals | $89,485 | $150,315 | 59.53% | $618,055 | 14.48% | $528,570 |
Corrective Action Plan
Progress of expenditures are increased in Q2.- Status
- Submitted
Copper Mountain CCD Q2 Report (10/1 - 12/31)
Object Code | Year to Date (YTD) Expenditure | YTD Forecast | % Expended of YTD Forecast | Project Budget | % Expended of Overall Budget | Budget Remaining |
---|---|---|---|---|---|---|
1000 - Instructional Salaries | $4,469 | $12,416 | 36% | $38,581 | 11.58% | $34,112 |
2000 - Non-Instructional Salaries | $47,799 | $55,228 | 86.55% | $110,456 | 43.27% | $62,657 |
3000 - Employee Benefits | $35,742 | $36,942 | 96.75% | $73,884 | 48.38% | $38,142 |
4000 - Supplies and Materials | $1,644 | $8,500 | 19.34% | $17,000 | 9.67% | $15,356 |
5000 - Other Operating Expenses and Services | $138,152 | $170,891 | 80.84% | $341,782 | 40.42% | $203,630 |
6000 - Capital Outlay | $456 | $6,628 | 6.88% | $16,299 | 2.8% | $15,843 |
7000 - Other Outgo | $419 | $10,027 | 4.18% | $20,053 | 2.09% | $19,634 |
Indirect Costs | $0 | $0 | 100% | $0 | 100% | $0 |
Totals | $228,681 | $300,631 | 76.07% | $618,055 | 37% | $389,374 |
- Status
- Submitted
Allocation Year Closeout: 2017-18
- I have reviewed the financial reports for my agency and confirm that all funds for this allocation year have been spent.
- 2017-18 Reverted Funds:
- $0
- 2017-18 Status
- Closed
- Submitting Authority
- Meredith Plummer, Chief Business Officer
- Jane Abell, Vice President of Student Services
Copper Mountain CCD Q3 Report (1/1 - 3/31)
Object Code | Year to Date (YTD) Expenditure | YTD Forecast | % Expended of YTD Forecast | Project Budget | % Expended of Overall Budget | Budget Remaining |
---|---|---|---|---|---|---|
1000 - Instructional Salaries | $6,073 | $25,498 | 23.82% | $38,581 | 15.74% | $32,508 |
2000 - Non-Instructional Salaries | $70,179 | $82,842 | 84.71% | $110,456 | 63.54% | $40,277 |
3000 - Employee Benefits | $53,030 | $55,413 | 95.7% | $73,884 | 71.77% | $20,854 |
4000 - Supplies and Materials | $10,602 | $12,750 | 83.15% | $17,000 | 62.36% | $6,398 |
5000 - Other Operating Expenses and Services | $244,862 | $256,337 | 95.52% | $341,782 | 71.64% | $96,920 |
6000 - Capital Outlay | $456 | $11,463 | 3.98% | $16,299 | 2.8% | $15,843 |
7000 - Other Outgo | $419 | $15,040 | 2.79% | $20,053 | 2.09% | $19,634 |
Indirect Costs | $0 | $0 | 100% | $0 | 100% | $0 |
Totals | $385,621 | $459,343 | 83.95% | $618,055 | 62.39% | $232,434 |
- Status
- Submitted
Copper Mountain CCD Q4 Report (4/1 - 6/30)
Object Code | Year to Date (YTD) Expenditure | YTD Forecast | % Expended of YTD Forecast | Project Budget | % Expended of Overall Budget | Budget Remaining |
---|---|---|---|---|---|---|
1000 - Instructional Salaries | $35,824 | $38,581 | 92.85% | $38,581 | 92.85% | $2,757 |
2000 - Non-Instructional Salaries | $99,504 | $110,456 | 90.08% | $110,456 | 90.08% | $10,952 |
3000 - Employee Benefits | $73,792 | $73,884 | 99.88% | $73,884 | 99.88% | $92 |
4000 - Supplies and Materials | $11,440 | $17,000 | 67.29% | $17,000 | 67.29% | $5,560 |
5000 - Other Operating Expenses and Services | $291,937 | $341,782 | 85.42% | $341,782 | 85.42% | $49,845 |
6000 - Capital Outlay | $3,435 | $16,299 | 21.07% | $16,299 | 21.07% | $12,864 |
7000 - Other Outgo | $419 | $20,053 | 2.09% | $20,053 | 2.09% | $19,634 |
Indirect Costs | $0 | $0 | 100% | $0 | 100% | $0 |
Totals | $516,351 | $618,055 | 83.54% | $618,055 | 83.54% | $101,704 |
I certify that our agency did not exceed the allowed indirect rate as directed in the Adult Education Program Guidance: Yes
- Status
- Submitted
Morongo Unified
Morongo Unified Q1 Report (7/1 - 9/30)
Object Code | Year to Date (YTD) Expenditure | YTD Forecast | % Expended of YTD Forecast | Project Budget | % Expended of Overall Budget | Budget Remaining |
---|---|---|---|---|---|---|
1000 - Instructional Salaries | $0 | $13,645 | 0% | $54,580 | 0% | $54,580 |
2000 - Non-Instructional Salaries | $0 | $0 | 100% | $0 | 100% | $0 |
3000 - Employee Benefits | $0 | $0 | 100% | $0 | 100% | $0 |
4000 - Supplies and Materials | $15,000 | $16,250 | 92.31% | $105,000 | 14.29% | $90,000 |
5000 - Other Operating Expenses and Services | $0 | $9,000 | 0% | $82,080 | 0% | $82,080 |
6000 - Capital Outlay | $0 | $14,362 | 0% | $21,447 | 0% | $21,447 |
7000 - Other Outgo | $0 | $0 | 100% | $0 | 100% | $0 |
Indirect Costs | $0 | $0 | 100% | $0 | 100% | $0 |
Totals | $15,000 | $53,257 | 28.17% | $263,107 | 5.7% | $248,107 |
Corrective Action Plan
Progress of expenditures are increased in Q2.- Status
- Submitted
Morongo Unified Q2 Report (10/1 - 12/31)
Object Code | Year to Date (YTD) Expenditure | YTD Forecast | % Expended of YTD Forecast | Project Budget | % Expended of Overall Budget | Budget Remaining |
---|---|---|---|---|---|---|
1000 - Instructional Salaries | $0 | $27,290 | 0% | $54,580 | 0% | $54,580 |
2000 - Non-Instructional Salaries | $0 | $0 | 100% | $0 | 100% | $0 |
3000 - Employee Benefits | $0 | $0 | 100% | $0 | 100% | $0 |
4000 - Supplies and Materials | $15,000 | $32,500 | 46.15% | $105,000 | 14.29% | $90,000 |
5000 - Other Operating Expenses and Services | $35,021 | $18,000 | 194.56% | $82,080 | 42.67% | $47,059 |
6000 - Capital Outlay | $18,000 | $17,024 | 105.74% | $21,447 | 83.93% | $3,447 |
7000 - Other Outgo | $0 | $0 | 100% | $0 | 100% | $0 |
Indirect Costs | $0 | $0 | 100% | $0 | 100% | $0 |
Totals | $68,021 | $94,814 | 71.74% | $263,107 | 25.85% | $195,086 |
- Status
- Submitted
Allocation Year Closeout: 2017-18
- I have reviewed the financial reports for my agency and confirm that all funds for this allocation year have been spent.
- 2017-18 Reverted Funds:
- $0
- 2017-18 Status
- Closed
- Submitting Authority
- Amy Woods, Director of Secondary Education
- Sharon Flores, Assistant Superintendent, Business Services
Morongo Unified Q3 Report (1/1 - 3/31)
Object Code | Year to Date (YTD) Expenditure | YTD Forecast | % Expended of YTD Forecast | Project Budget | % Expended of Overall Budget | Budget Remaining |
---|---|---|---|---|---|---|
1000 - Instructional Salaries | $54,580 | $40,935 | 133.33% | $54,580 | 100% | $0 |
2000 - Non-Instructional Salaries | $0 | $0 | 100% | $0 | 100% | $0 |
3000 - Employee Benefits | $0 | $0 | 100% | $0 | 100% | $0 |
4000 - Supplies and Materials | $105,000 | $68,750 | 152.73% | $105,000 | 100% | $0 |
5000 - Other Operating Expenses and Services | $81,675 | $50,040 | 163.22% | $82,080 | 99.51% | $405 |
6000 - Capital Outlay | $18,000 | $18,785 | 95.82% | $21,447 | 83.93% | $3,447 |
7000 - Other Outgo | $0 | $0 | 100% | $0 | 100% | $0 |
Indirect Costs | $0 | $0 | 100% | $0 | 100% | $0 |
Totals | $259,255 | $178,510 | 145.23% | $263,107 | 98.54% | $3,852 |
- Status
- Submitted
Morongo Unified Q4 Report (4/1 - 6/30)
Object Code | Year to Date (YTD) Expenditure | YTD Forecast | % Expended of YTD Forecast | Project Budget | % Expended of Overall Budget | Budget Remaining |
---|---|---|---|---|---|---|
1000 - Instructional Salaries | $54,580 | $54,580 | 100% | $54,580 | 100% | $0 |
2000 - Non-Instructional Salaries | $0 | $0 | 100% | $0 | 100% | $0 |
3000 - Employee Benefits | $0 | $0 | 100% | $0 | 100% | $0 |
4000 - Supplies and Materials | $105,000 | $105,000 | 100% | $105,000 | 100% | $0 |
5000 - Other Operating Expenses and Services | $81,764 | $82,080 | 99.62% | $82,080 | 99.62% | $316 |
6000 - Capital Outlay | $18,000 | $21,447 | 83.93% | $21,447 | 83.93% | $3,447 |
7000 - Other Outgo | $0 | $0 | 100% | $0 | 100% | $0 |
Indirect Costs | $0 | $0 | 100% | $0 | 100% | $0 |
Totals | $259,344 | $263,107 | 98.57% | $263,107 | 98.57% | $3,763 |
I certify that our agency did not exceed the allowed indirect rate as directed in the Adult Education Program Guidance: Yes
- Status
- Submitted
2020 © California Community Colleges
NOVA Site Version: 4.22.1