Finance & Administration Committee Meeting
August 29, 2019
Administration Committee Meeting August 29, 2019 Table of - - PowerPoint PPT Presentation
Finance & Administration Committee Meeting August 29, 2019 Table of Contents 1) 2019-2020 Student Enrollment Update 2) 2020-2021 Proposed Budget Development Calendar 3) Agenda Items for September Board of Trustees Meeting - Budget
August 29, 2019
1) 2019-2020 Student Enrollment Update 2) 2020-2021 Proposed Budget Development Calendar 3) Agenda Items for September Board of Trustees Meeting - Budget Related 4) FY19 Financial Report – Update 5) FIRST Preliminary Report 6) FY19 – 4th Quarter Investment Report 7) Administration Office Updates – a) Employee Benefits - Open Enrollment Update 8) 2019-2020 Finance & Administration Committee Meeting Calendar 9) Travel Report – Superintendent/Cabinet/Board of Trustees – as of June 30, 2019
2
– Nov 2019
mal Adoption of Budge t De ve lopme nt Cale ndar – Se p 2019
2020
BUDGET DEVELOPMENT CALENDAR 2020 - 2021
Approved by Board of Trustees - PENDING
*Dates Subject To Change As NeededT IME E VE NT RE SPONSIBL E PART Y N/ A F inanc e & Administratio n Co mmitte e BOT and Superintendent 25 Chief Appraiser Certifies Rolls for Taxing Entities EP Central Appraisal District and Treasury Office N/ A F inanc e & Administratio n Co mmitte e BOT and Superintendent 20 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 29 930 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 17 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 20 6-Week Student Enrollment (for Projections) Office of Accountability, Strategy, Assessment & PEIMS 2 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 15 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 22 AM & PM 2020-2021 Budget Development Workshop - Departments Budget & External Financial Management Office and Department Heads 23 AM & PM 2020-2021 Budget Development Workshop - Departments Budget & External Financial Management Office and Department Heads Distribution of Department Allocations Budget & External Financial Management Office 2020-2021 PEIMS Snapshot Date Texas Education Agency 28-30 Training - Campus Staffing Review Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 1 Training - Campus Staffing Review Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 6 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent Board of Trustee - Regular Meeting BOT and Superintendent Adopt the 2020-2021 Academic Calendar Academics Office 18-22 Department Budget Hearings Budget & External Financial Management Office and Department Heads 2 Initiate Revenue Projections Treasury Office 3-13 Department Budget Hearings Budget & External Financial Management Office and Department Heads 4 AM & PM 2020-2021Budget Development Workshop - Secondary & Specialty Campuses Budget & External Financial Management Office and Campus Principals 5 AM & PM 2020-2021 Budget Development Workshop - Elementary Campuses Budget & External Financial Management Office and Campus Principals 9 Distributions of Campus Per Capita Budget Allocations Budget & External Financial Management Office 4 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 13 AM & PM 2020-2021Budget Development Workshop - Elementary Campuses Budget & External Financial Management Office and Campus Principals 16 Distributions of Campus Per Capita Budget Allocations Budget & External Financial Management Office 17 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 9-27 Campus Staffing Review Meetings - Elementary Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 15 9:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 21 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 17 Budget Data Entry Deadline - for Departments Department Heads 3-6 Campus Staffing Review Meetings - Middle School Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 5 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 18 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 13-27 Campus Staffing Review Meetings - High School & Specialty Campuses Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 14 Budget Data Entry Deadline - Elementary Campuses Campus Principals T BD 8:30 a.m. Bo ard o f T ruste e - Budg e t Wo rksho p Superintendent, Finance and Operations Office and BOT TBD 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 13 Budget Data Entry Deadline - High School & Specialty Campuses Campus Principals Bo ard o f T ruste e - Budg e t Wo rksho p Superintendent, Finance and Operations Office and BOT Supe rinte nde nt's 2020-2021 Pro po se d Budg e t Pre se nte d Superintendent, Finance and Operations Office and BOT Pro po se d Co mpe nsatio n Pac kag e Pre se ntatio n to BOT Superintendent, Finance and Operations Office, Human Resource Office and BOT 21 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 24 Trustee Initiated Revision to Budget Due to Superintendent's Office BOT Districtwide Principal - Budget Review Meeting Budget & External Financial Management Office Chief Appraiser Prepares Estimate of the Taxable Value of Property EP Central Appraisal District and Treasury Office 6 8:30 a.m. Bo ard o f T ruste e - Budg e t Wo rksho p Superintendent, Finance and Operations Office and BOT Post Proposed 2020-2021Budget Summary on District's Website Budget & External Financial Management Office Public Notice in Newspaper to Discuss the Budget Treasury Office Board of Trustee - Regular Meeting BOT and Superintendent Adopt 2020-2021 Compensation Package BOT and Superintendent Public Meeting and Adoption of 2020-2021 Budget BOT and Superintendent 20 Po st 2020-2021 Ado pte d Budg e t Summary o n Distric t's We b site Budget & External Financial Management Office 3 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 16 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 30 Provide Campuses and Departments with Adopted Budget Account Detail Budget & External Finacial Management Office Ma r c h July Aug ust 5:00 p.m. DAT E 25 Oc tobe r Nove mbe r De c e mbe r Ja nua r y F e br ua r y #NAME ? June 8 May 19 5:00 p.m. Apr il 19 8:30 a.m. 30 8
3
MEETING DATE: 9/17/2019 AGENDA ITEM NO.: U.1. APPROVAL OF BUDGET AMENDMENTS CONSENT AGENDA
Board of Trustees Executive Summary of Board Agenda Item TITLE: Approval of Budget Amendment for Funding for Capital Project Costs for 20192020 School Year JUSTIFICATION STATEMENT: Amendment will provide proper funding for previously encumbered purchase orders. PURPOSE OF AGENDA ITEM: Action TO BE HELD IN: Open Session AUTHORITY FOR ACTION: Other STAFF RESPONSIBLE: Carmen ArrietaCandelaria/Martha Aguirre DISTRICT IMPROVEMENT PLAN OBJECTIVE, GOAL OR NEED ADDRESSED: Increase student engagement in the classroom by 6% by 2021. SUMMARY: Pursuant to Board Policy CE (Local) – Annual Operating Budget, the Board shall amend the budget when a change is made increasing any one of the functional spending categories or increasing revenue object accounts and other resources. The budget amendment presented is to request the rollforward of budget to provide funding for payment of capital projects from previously restricted funds in the amount of $1,423,191. The expenditure budget will be allotted to the Maintenance Tax Notes – Fund 176, QSC Maintenance Tax Notes – Fund 177 and General Operating Fund 199. The funding will come from the District’s Restricted Fund Balance as follows: MAINTENANCE TAX NOTES – FUND 176 81 – Facilities Acquisition and Construction $387,598 TOTAL $387,598 QSC MAINTENANCE TAX NOTES – FUND 177 81 – Facilities Acquisition and Construction $31,749 TOTAL $31,749 GENERAL OPERATING – FUND 199 81 – Facilities Acquisition and Construction $1,003,844 TOTAL $1,003,844 ADMINISTRATIVE RECOMMENDATION/MOTION: It is recommended that the Board of Trustees approve this budget amendment to the 20192020 fiscal year budget in the amount of $387,598 to the Maintenance Tax Notes, $31,740 to the QSC Maintenance Tax Notes and $1,003,844 to the General Operating Fund. The funding will come from the District’s Restricted Fund Balance. FUNDING SOURCE: Restricted Fund Balance Funds 176, 177, 199 ACCOUNT NO.: Various Accounts FISCAL IMPACT AND COST: IMMEDIATE: 1,423,191 FUTURE/ONGOING: IMPACT ON OTHER FUNCTIONS/OPERATIONS: N/A CONSEQUENCES OF NONAPPROVAL: Program objectives will be delayed.
4
TO/FROM FUND FUNCTION AMOUNT FROM
FUND 176
3470 RESTRICTED FUND BALANCE - 2017 MTN 387,598 $
FUND 177
3470 RESTRICTED FUND BALANCE - QSC MTN 31,749 $
FUND 199
3590 ASSIGNED FUND BALANCE - PROCEEDS FROM SALE OF LAND 1,003,844 $ 1,423,191 $ TO MAINTENANCE TAX NOTES 176 81 - FACILITIES ACQUISITION AND CONSTRUCTION 387,598 $ 387,598 $ QUALITY SCHOOL CONSTRUCTION FUND 177 81 - FACILITIES ACQUISITION AND CONSTRUCTION 31,749 $ 31,749 $ TO GENERAL OPERATING FUND - FUND 199 199 81 - FACILITIES ACQUISITION AND CONSTRUCTION 1,003,844 $ 1,003,844 $ FUND 176 - MAINTENANCE TAX NOTES FUND 387,598 $ FUND 177 - QUALITY SCHOOL CONSTRUCTION FUND 31,749 $ FUND 199 - GENERAL OPERATING FUND 1,003,844 $ 1,423,191 $ 1,423,191 $ 1,423,191 $ TOTAL BY DEPARTMENT
Budget Amendment - Roll-Forward Requests for Capital Projects 09.17.2019
BUDGET AMENDMENT BY DEPARTMENT FACILITIES & CONSTRUCTION - FUNDS 176, 177 & 199
5
FY19 ROLL FOWARD REQUESTS Sorted by Category/Project
Updated: 8/25/20199:37 PM MTN - Relocation of Depts 387,598 $ Fund 176 Restricted Fund Balance QSC - Stanton Building 31,749 $ Fund 177 Restricted Fund Balance Capital Projects - Stanton Building 1,003,844 $ Fund 199 Restricted Fund Balance 1,423,191 $ DEPARTMENT/CAMPUS PO CREATED DATE PO VENDOR PO AMOUNT ROLL FORWARD AMOUNT ACCOUNT NUMBER Facilities & Construction 1/28/2019 1911582 Elevator Systems of El Paso $6,700.00 $508 176.81.6625.911.99.642.635 Facilities & Construction 2/28/2019 1913753 El Paso Steel Doors & Frames $15,978.00 $15,978 176.41.6211.932.99.100.932 Facilities & Construction 5/7/2019 1917475 Keystone Contractors and Engineers $99,840.23 $99,840 176.81.6625.932.99.100.932 Facilities & Construction 5/31/2019 1918619 NBS $3,720.00 $3,720 176.81.6625.932.99.100.635 Facilities & Construction 6/4/2019 1918780 Desert Communications Inc $17,855.10 $17,855 176.81.6624.932.99.100.635 Facilities & Construction 6/4/2019 1918781 Desert Communications Inc $82,696.01 $82,696 176.81.6625.911.99.642.635 Facilities & Construction 6/4/2019 1918782 Desert Communications Inc $16,991.70 $16,992 176.41.6211.932.99.100.932 Facilities & Construction 6/4/2019 1918788 Graybar Electric $1,297.67 $1,298 176.81.6625.911.99.642.635 Facilities & Construction 6/4/2019 1918798 Keystone Contractors and Engineers $88,809.39 $88,809 176.41.6211.932.99.100.932 Facilities & Construction 6/4/2019 1918803 Pyrocom Systems $13,939.41 $13,939 176.81.6625.932.99.100.932 Facilities & Construction 6/26/2019 1919158 Accents and Accessories $13,942.00 $13,942 176.81.6625.932.99.100.635 Facilities & Construction 6/27/2019 1919202 Keystone Contractors and Engineers $10,836.44 $10,836 176.81.6624.932.99.100.635 Facilities & Construction 6/27/2019 1919199 Keystone Contractors and Engineers $10,491.73 $10,492 176.81.6625.911.99.642.635 Facilities & Construction 6/30/2019 Restricted Fund Balance $10,693.00 $10,693 176.81.6625.XXX.99.XXX.XXX TOTAL $387,598 Facilities & Construction 6/30/2019 Capital Projects $31,749.00 $31,749 177.81.6625.XXX.99.XXX.XXX TOTAL $31,749 Facilities & Construction 6/30/2019 Capital Projects $1,003,844.00 $1,003,844 199.81.6625.XXX.99.XXX.XXX TOTAL $1,003,844
SUMMARY
MTN - Relocation of Departments - Fund 176 Restricted Fund Balance QSC - Stanton Building - Fund 177 Restricted Fund Balance Capital Project - Stanton Building - Fund 199 Restricted Fund Balance
6
MEETING DATE: AGENDA ITEM NO.: CONSENT ITEMS
Board of Trustees Executive Summary of Board Agenda Item TITLE: Approval of the 20202021 Budget Development Calendar JUSTIFICATION STATEMENT: The budget development calendar will set timelines for the adoption of the District’s budget. PURPOSE OF AGENDA ITEM: Action TO BE HELD IN: Open Session AUTHORITY FOR ACTION: Other STAFF RESPONSIBLE: Carmen ArrietaCandelaria/Martha Aguirre DISTRICT IMPROVEMENT PLAN OBJECTIVE, GOAL OR NEED ADDRESSED: Increase student engagement in the classroom by 6% by 2021. SUMMARY: Pursuant to Board Policy CE (Local) – The chief financial officer shall direct the development of a budget calendar and a plan for budget preparation for Board review and approval by no later than April 15 each year. ADMINISTRATIVE RECOMMENDATION/MOTION: It is recommended that the Board of Trustees approve the 20202021 Budget Development Calendar as presented by Administration. FUNDING SOURCE: General Operating, Debt Service and Food Service Funds ACCOUNT NO.: N/A FISCAL IMPACT AND COST: IMMEDIATE: N/A FUTURE/ONGOING:N/A IMPACT ON OTHER FUNCTIONS/OPERATIONS: N/A CONSEQUENCES OF NONAPPROVAL: Program objectives will be delayed. IMPLEMENTATION TIMELINE: Upon Approval COMMENTS RECEIVED, IF ANY: N/A ATTACHMENTS: Description 20202021 Budget Development Calendar REVIEWERS: Department Reviewer Date
No Reviewers Available
7
BUDGET DEVELOPMENT CALENDAR 2020 - 2021
Approved by Board of Trustees - PENDING
*Dates Subject To Change As NeededT IME E VE NT RE SPONSIBL E PART Y N/ A F inanc e & Administratio n Co mmitte e BOT and Superintendent 25 Chief Appraiser Certifies Rolls for Taxing Entities EP Central Appraisal District and Treasury Office N/ A F inanc e & Administratio n Co mmitte e BOT and Superintendent 20 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 29 930 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 17 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 20 6-Week Student Enrollment (for Projections) Office of Accountability, Strategy, Assessment & PEIMS 2 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 15 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 22 AM & PM 2020-2021 Budget Development Workshop - Departments Budget & External Financial Management Office and Department Heads 23 AM & PM 2020-2021 Budget Development Workshop - Departments Budget & External Financial Management Office and Department Heads Distribution of Department Allocations Budget & External Financial Management Office 2020-2021 PEIMS Snapshot Date Texas Education Agency 28-30 Training - Campus Staffing Review Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 1 Training - Campus Staffing Review Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 6 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent Board of Trustee - Regular Meeting BOT and Superintendent Adopt the 2020-2021 Academic Calendar Academics Office 18-22 Department Budget Hearings Budget & External Financial Management Office and Department Heads 2 Initiate Revenue Projections Treasury Office 3-13 Department Budget Hearings Budget & External Financial Management Office and Department Heads 4 AM & PM 2020-2021Budget Development Workshop - Secondary & Specialty Campuses Budget & External Financial Management Office and Campus Principals 5 AM & PM 2020-2021 Budget Development Workshop - Elementary Campuses Budget & External Financial Management Office and Campus Principals 9 Distributions of Campus Per Capita Budget Allocations Budget & External Financial Management Office 4 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 13 AM & PM 2020-2021Budget Development Workshop - Elementary Campuses Budget & External Financial Management Office and Campus Principals 16 Distributions of Campus Per Capita Budget Allocations Budget & External Financial Management Office 17 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 9-27 Campus Staffing Review Meetings - Elementary Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 15 9:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 21 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 17 Budget Data Entry Deadline - for Departments Department Heads 3-6 Campus Staffing Review Meetings - Middle School Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 5 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 18 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 13-27 Campus Staffing Review Meetings - High School & Specialty Campuses Office of Accountability, Strategy, Assessement & PEIMS and Campus Principals 14 Budget Data Entry Deadline - Elementary Campuses Campus Principals T BD 8:30 a.m. Bo ard o f T ruste e - Budg e t Wo rksho p Superintendent, Finance and Operations Office and BOT TBD 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 13 Budget Data Entry Deadline - High School & Specialty Campuses Campus Principals Bo ard o f T ruste e - Budg e t Wo rksho p Superintendent, Finance and Operations Office and BOT Supe rinte nde nt's 2020-2021 Pro po se d Budg e t Pre se nte d Superintendent, Finance and Operations Office and BOT Pro po se d Co mpe nsatio n Pac kag e Pre se ntatio n to BOT Superintendent, Finance and Operations Office, Human Resource Office and BOT 21 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 24 Trustee Initiated Revision to Budget Due to Superintendent's Office BOT Districtwide Principal - Budget Review Meeting Budget & External Financial Management Office Chief Appraiser Prepares Estimate of the Taxable Value of Property EP Central Appraisal District and Treasury Office 6 8:30 a.m. Bo ard o f T ruste e - Budg e t Wo rksho p Superintendent, Finance and Operations Office and BOT Post Proposed 2020-2021Budget Summary on District's Website Budget & External Financial Management Office Public Notice in Newspaper to Discuss the Budget Treasury Office Board of Trustee - Regular Meeting BOT and Superintendent Adopt 2020-2021 Compensation Package BOT and Superintendent Public Meeting and Adoption of 2020-2021 Budget BOT and Superintendent 20 Po st 2020-2021 Ado pte d Budg e t Summary o n Distric t's We b site Budget & External Financial Management Office 3 8:30 a.m. F inanc e & Administratio n Co mmitte e BOT and Superintendent 16 5:00 p.m. Board of Trustee - Regular Meeting BOT and Superintendent 30 Provide Campuses and Departments with Adopted Budget Account Detail Budget & External Finacial Management Office Ma r c h July Aug ust 5:00 p.m. DAT E 25 Oc tobe r Nove mbe r De c e mbe r Ja nua r y F e br ua r y #NAME ? June 8 May 19 5:00 p.m. Apr il 19 8:30 a.m. 30 8
8
MEETING DATE: AGENDA ITEM NO.: CONSENT ITEMS
Board of Trustees Executive Summary of Board Agenda Item TITLE: Approval of Revisions to 20192020 Extra Performance Pay/Instructional Stipends JUSTIFICATION STATEMENT: Provide compensation for EPISD employees. PURPOSE OF AGENDA ITEM: Action TO BE HELD IN: Open Session AUTHORITY FOR ACTION: Other STAFF RESPONSIBLE: Carmen ArrietaCandelaria/Martha Aguirre DISTRICT IMPROVEMENT PLAN OBJECTIVE, GOAL OR NEED ADDRESSED: Increase student engagement in the classroom by 6% by 2021. SUMMARY: Administration is seeking to amend the approved Extra Performance Pay/Instructional Stipends schedule for 20192020 school year. Under the Fine Arts Stipend section, the addition of eligibility for the stipend as reflected below is presented for your consideration. FINE ARTS Instrumental Music HS Band Director $10,000 HS Assistant Band Director $5,000 MS Band Director $3,700 MS Assistant Band Director $2,500 HS Orchestra $5,000 MS Orchestra $3,700 ES Orchestra $1,000 Guitar $2,500 Mariachi $1,000 · Itinerant personnel would receive only the highest extra performance pay for their specific
187 days required by assignment. · A teacher that is assigned to two (2) secondary campuses OR assigned to two (2) Fine Arts programs at the same secondary campus will receive one full stipend amount of the first assignment and onehalf of the second assignment stipend. Example, a teacher assigned to MS Band and MS Assistant Band will receive the following stipend amounts: $3,700 + $1,250 ($2,500/2) ADMINISTRATIVE RECOMMENDATION/MOTION: It is recommended that the Board of Trustees approve the revisions to the 20192020 Extra Performance Pay/Instructional Stipends. FUNDING SOURCE: General Operating Fund ACCOUNT NO.: Various Accounts FISCAL IMPACT AND COST: IMMEDIATE: FUTURE/ONGOING: IMPACT ON OTHER FUNCTIONS/OPERATIONS: N/A CONSEQUENCES OF NONAPPROVAL:
9
2019 - 2020 EXTRA PERFORMANCE PAY – INSTRUCTIONAL STIPENDS
Dual Credit Teacher 1 Period $600
(i.e. math and science stipends)
EXTRA DUTY PAY Extra Teaching Period $1,500 P/SEMESTER
Grants and Personnel Council (GAPC) for approval.
numbers will be evaluated to identify master schedule conflicts – Campus Funded
Extended Schedule $1,500
Program (DAEP) campus and are required to extend their schedule to supervise students before or after school per semester.
Delta Fine Arts $1,000
Personnel Council (GAPC) for approval.
FINE ARTS Instrumental Music HS Band Director $10,000 HS Assistant Band Director $5,000 MS Band Director $3,700 MS Assistant Band Director $2,500 HS Orchestra $5,000 MS Orchestra $3,700 ES Orchestra $1,000 Guitar $2,500 Mariachi $1,000
Extra performance pay includes allowed salary for those days in excess of 187 days required by assignment.
the same secondary campus will receive one full stipend amount of the first assignment and one-half of the second assignment stipend. Example, a teacher assigned to MS Band and MS Assistant Band will receive the following stipend amounts: $3,700 + $1,250 ($2,500/2)
Performing Arts One Act Play Director $1,000 Performing Dance Group $2,500 HS Theater Director $5,000 Kick Dance $2,500
10
Financial Reporting to the Board Finance & Administration Committee
November Board Finance and Administration Committee meeting. Thereafter, monthly financial reports will be submitted.
timelines.
Funds, Capital Project Funds and Internal Service Funds.
Agenda, for the Board of Trustees meetings.
Finance and Administration Committee and a full report is presented to the Board of Trustees at the October Board Meeting.
external auditors will present a draft Comprehensive Annual Financial Report (CAFR) at the October Board Finance and Administration Committee meeting. A final CAFR presentation is presented to the Board of Trustees at the November Board meeting, as an action item for approval.
EXHIBIT G-1 EL PASO ISD SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL - GENERAL FUND FOR THE YEAR ENDED JUNE 30, 2019
Control Data Codes Original Final (GAAP BASIS) (Negative) Positive or Final Budget Variance With Actual Amounts Budgeted Amounts
REVENUES:
192,507,438 176,666,120 194,980,751 2,473,313 Total Local and Intermediate Sources $ $ $ $ 5700 312,014,562 304,552,954 310,071,979 (1,942,583) State Program Revenues 5800 14,757,348 15,954,348 16,428,826 1,671,478 Federal Program Revenues 5900
Total Revenues
5020 497,173,422 519,279,348 521,481,556 2,202,208
EXPENDITURES: Current:
309,667,182 286,245,588 291,955,790 17,711,392 Instruction 0011 8,324,112 7,468,343 8,221,036 103,076 Instructional Resources and Media Services 0012 19,345,903 19,102,872 17,323,176 2,022,727 Curriculum and Instructional Staff Development 0013 4,781,398 4,665,762 4,042,193 739,205 Instructional Leadership 0021 37,309,146 34,589,359 37,404,495 (95,349) School Leadership 0023 18,618,160 17,458,387 18,719,830 (101,670) Guidance, Counseling and Evaluation Services 0031 4,162,509 4,010,929 4,093,427 69,082 Social Work Services 0032 6,789,127 6,709,955 6,392,607 396,520 Health Services 0033 12,243,822 12,920,657 11,368,983 874,839 Student (Pupil) Transportation 0034 14,304,514 13,158,745 13,284,127 1,020,387 Extracurricular Activities 0036 14,291,873 13,720,247 13,690,283 601,590 General Administration 0041 56,990,471 52,817,553 52,257,141 4,733,330 Facilities Maintenance and Operations 0051 7,581,689 5,907,149 7,172,072 409,617 Security and Monitoring Services 0052 8,596,427 9,506,647 7,328,127 1,268,300 Data Processing Services 0053 139,833 102,343 54,564 85,269 Community Services 0061
Debt Service:
579,777 579,777 579,777
0071 712,282 748,579 663,685 48,597 Interest on Long-Term Debt 0072 42,297 6,000 42,297
0073
Capital Outlay:
39,276,778 2,952,597 13,029,975 26,246,803 Facilities Acquisition and Construction 0081
Intergovernmental:
2,877,905 2,877,905 2,540,161 337,744 Other Intergovernmental Charges 0099
Total Expenditures
6030 495,549,394 566,635,205 510,163,746 56,471,459 1100 Expenditures 1,624,028 (47,355,857) 11,317,810 58,673,667 Excess (Deficiency) of Revenues Over (Under)
OTHER FINANCING SOURCES (USES):
3,716,282
7912 10,847,034
7913 (2,361,267) (1,311,267) (2,361,267)
8911 (312,761) (312,761) (312,761)
8949
Total Other Financing Sources (Uses)
7080 (1,624,028) 11,889,287 11,889,288 1 1200 Net Change in Fund Balances
23,207,098 58,673,668 0100 Fund Balance - July 1 (Beginning) 119,991,349 119,991,349 119,991,349
$ 119,991,349 $ 84,524,779 $ 143,198,447 $ 58,673,668
11
As of 8.14.19
EXHIBIT J-4 EL PASO ISD SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL - CHILD NUTRITION PROGRAM FOR THE YEAR ENDED JUNE 30, 2019
Control Data Codes Original Final (GAAP BASIS) (Negative) Positive or Final Budget Variance With Actual Amounts Budgeted Amounts
REVENUES:
3,100,000 3,100,000 3,304,720 204,720
Total Local and Intermediate Sources
$ $ $ $
5700
175,000 175,000 163,224 (11,776)
State Program Revenues
5800
30,095,546 29,769,935 30,078,334 (17,212)
Federal Program Revenues
5900
Total Revenues
5020
33,044,935 33,370,546 33,546,278 175,732
EXPENDITURES: Current:
30,372,570 30,372,570 28,216,186 2,156,384
Food Services
0035
1,672,365 1,672,365 1,611,279 61,086
Facilities Maintenance and Operations
0051
Total Expenditures
6030
32,044,935 32,044,935 29,827,465 2,217,470
1200 Net Change in Fund Balances
1,000,000 1,325,611 3,718,813 2,393,202
0100 Fund Balance - July 1 (Beginning)
5,881,427 5,881,427 5,881,427
$
6,881,427 $ 7,207,038 $ 9,600,240 $ 2,393,202
12
As of 8.14.19
EXHIBIT J-5 EL PASO ISD SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL - DEBT SERVICE FUND FOR THE YEAR ENDED JUNE 30, 2019
Control Data Codes Original Final (GAAP BASIS) (Negative) Positive or Final Budget Variance With Actual Amounts Budgeted Amounts
REVENUES:
39,108,849 39,108,849 23,659,529 (15,449,320)
Total Local and Intermediate Sources
$ $ $ $
5700
6,360,930 6,360,930 6,258,940 (101,990)
State Program Revenues
5800
Total Revenues
5020
45,469,779 45,469,779 29,918,469 (15,551,310)
EXPENDITURES: Debt Service:
17,283,593 17,283,593 18,094,154 (810,561)
Principal on Long-Term Debt
0071
28,152,062 28,152,062 22,065,608 6,086,454
Interest on Long-Term Debt
0072
300,000 300,000 224,633 75,367
Bond Issuance Cost and Fees
0073
Total Expenditures
6030
45,735,655 45,735,655 40,384,395 5,351,260
1100 Excess (Deficiency) of Revenues Over (Under)
Expenditures
(265,876) (265,876) (10,465,926) (10,200,050)
OTHER FINANCING SOURCES (USES):
1,311,267 1,311,267 1,311,267
7915
(48,230) (48,230) (48,230)
8949
Total Other Financing Sources (Uses)
7080
1,263,037 1,263,037 1,263,037
997,161 997,161 (9,202,889) (10,200,050)
0100 Fund Balance - July 1 (Beginning)
37,513,208 37,513,208 37,513,208
$
38,510,369 $ 38,510,369 $ 28,310,319 $ (10,200,050)
13
As of 8.14.19
School FIRST Preliminary Report
1.
The 2019 FIRST Rating is based on fiscal year 2017-18 data.
2.
The District must hold a Public Hearing and a Notice must be
3.
There are 15 indicators. 5 are pass or fail, and the other 10 are worth 10 points each.
4.
EPISD scored 96 out of the maximum 100 points, and received a “Superior” rating.
5.
EPISD has received the highest rating of ”Superior” Achievement for 16 years, with the exception of the 2018 rating of “Above Standard”.
6.
EPISD lost points on one of the indicators:
6 points out of a possible 10 points. If our days of cash on hand had been at 90 days we would have received 10 points.
7.
EPISD received perfect scores on all other indicators.
8.
EPISD received 10 points for the Administrative Cost Ratio indicator. In 2017-2018, the ratio was 4.91%. In 2016-2017, the ratio was 4.81%.
9.
The final report will include spending disclosures for the Superintendent and the Board of Trustees.
14
Inve stm e nt Re po rting to the Bo a rd o f T ruste e s
Inve stm e nt re po rting is do ne in a c c o rda nc e with the Pub lic Funds Inve stm e nt Ac t, a nd Bo a rd Po lic ie s C DA (L e g a l) a nd C DA (L
ending: September 30, December 31, March 31, and June 30.
at a Board Meeting, and it is presented as an Annual Investment Report. It is an item in the Consent Agenda.
the Investment Policy Review Resolution per CDA (Legal):
The board shall review its investment policy and investment strategies not less than
resolution stating that it has reviewed the investment policy and investment strategies and that the written instrument so adopted shall record any changes made to either the investment policy or investment strategies. Gov’t Code 2256.005(e).
Authorized Sellers of Investments, Providers of Investment Officer Training, and Authorized Third Party Custodians of District Investments”.
Board Meeting on September 17, 2019.
Investment Report.
15
GF MTNs DSF CPF ISF Total 2017-18 76.5 21.0 30.7 215.9 10.4 354.5 2018-19 117.8 20.6 19.1 414.8 9.8 582.1 100 200 300 400 500 600
$ Millions
YEAR END INVESTMENT BALANCES 2018 and 2019
16
Texpool $68,239,797 LOGIC $119,419,228 Lone Star $113,295,902 Texas TERM $10,509,616 Texas CLASS $252,297,388 TexStar $11,998,579 Bank of Oklahoma $6,368,375
17
GF MTN DSF CPF ISF Total 2017-18 1,611.6 225.9 397.4 3,679.7 173.2 6,088.0 2018-19 2,858.1 506.9 448.7 7,067.2 244.8 11,125.7 2,000 4,000 6,000 8,000 10,000
$ Thousands
INTEREST REVENUE FY-2018 vs. FY-2019
18
2.466% 2.359% 2.233% 2.305% 2.518% 1.565% 1.421% 1.387% 1.435% 1.925% 0.00% 0.50% 1.00% 1.50% 2.00% 2.50%
EPISD Yield Investment Pools Fed Funds Rate 90 Day T-Bill 2 Year T- Note
YTD Average Yield 2018-19 YTD Average Yield 2017-18
19
$7,694,326 $3,398,732 $2,065,844 $1,771,329 $4,628,619 $10,150,956 $11,946,852 $12,003,907 $9,149,436 $2,320,683 $680,190 $572,006 $542,982 $378,423 $319,340 $789,203 $2,576,741 $6,087,977 $11,125,675 $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
Historical Interest Earnings per Fiscal Year (All Funds)
20
3 mth 1 yr 2 yr 5 yr 10 yr 30 yr 6/30/18 1.93% 2.33% 2.52% 2.73% 2.85% 2.98% 6/30/19 2.12% 1.92% 1.75% 1.76% 2.00% 2.52% 8/15/19 1.91% 1.72% 1.48% 1.42% 1.52% 1.98% 0.00% 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% 3.50%
21
2.1500% 2.2500% 2.3500% 2.4500% 2.5500% 2.6500% 2.7500% 1 9 17 25 33 41 49 57 65 73 81 89 97 105 113 121 129 137 145 153 161 169 177 185 193 201 209 217 225 233 241 249 257 265 273 281 289 297 305 313 321 329 337 345 353 361
Investment Pool Daily Yields
Texpool LOGIC LSIP CLASS
22
$2,057,656 $(435,934) $16,559,522 $2,177,806 $(1,728,115) $52,941,443 $26,142,259 $6,389,534 $(28,769,245) $(12,958,466) $(28,488,761) $7,386,001 $(40,000,000) $(30,000,000) $(20,000,000) $(10,000,000) $‐ $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 Jul‐18 Aug‐18 Sep‐18 Oct‐18 Nov‐18 Dec‐18 Jan‐19 Feb‐19 Mar‐19 Apr‐19 May‐19 Jun‐19
GENERAL FUND CASH FLOW
23
Online Open Benefit Enrollment Began June 24 and Closed July 31, 2019 Health Plan Changes Available through August 23, 2019 5,369 – Enrolled in Cigna*
3,165 – Consumer Driven Health Plan (CDHP) 2,204 – Traditional PPO
1,377 – Enrolled in TRS*
676 – Active Care 1 High Deductible (HD) 130 – Active Care Select 22 – Active Care 2 549 – Passive Enrollment (Employees did not take any action from 2018-2019, unable to identify tiers
664 – Flexible Spending Account (FSA) Enrollment * 2,506 – Health Savings Account (HSA) Enrollment * 2,403 – Cigna 103 – UMB
*Enrollment Numbers Reflect Enrollment as of August 22, 2019*
24
25
2019-2020 Finance & Administration Committee Meeting - Agendas
Updated: 8.23.2019
Finance & Administration Committee Meeting materials must be submitted to the Superintendent’s office for review at least 2 weeks prior to a scheduled meeting.
Me e ting time : 8:30 a .m. – 9:30 a .m.
Wednesday, two weeks prior to the Regular Board Meeting.
minute session for business information and 20-minute session for administration Information.
2018-2019 school year. Agenda items may be revised as requested by the Superintendent, F&A Committee and Administration.
consider what needs to be communicated to the Board of Trustees with brief presentations and main points summarized.
Committe e Cha irpe rson: Al Velarde Committe e Me mbe rs: Joshua Acevedo F &A Committe e / Budg e t Workshop* Boa rd Me e ting
08.29.2019 09.17.2019 10.02.2019 10.15.2019 11.06.2019 11.19.2019 12.04.2019 12.17.2019 01.15.2020 01.21.2020 02.05.2020 02.18.2020
02.26.2020 – Budg e t Workshop
03.10.2020
04.08.2020 – Budg e t Workshop
04.21.2020
05.06.2020 – Budg e t Workshop
05.19.2020 06.03.2020 06.16.2020
SEPTEMBER 2019
1) 2019-2020 Enrollment Update 2) 2020-2021 Proposed Budget Development Calendar 3) Finance & Administration Committee – FY20 Meeting Schedule 4) FY19 - 4th Quarter Investment Report 5) Fiscal Year 2020 Financial Statements – as
6) FY19 Financial Report 7) FIRST Preliminary Report 8) Administration Office Updates a. Human Resources Report 9) FY19 – 4th Quarter Travel Report – Supt/Cabinet/Board of Trustees
OCTOBER 2019
1) 6-Wk Enrollment Update 2) Five-Year Financial Projection- Update 3) Fiscal Year 2020 Financial Statements – as
4) Administration Office Updates a) Leveling Results b) Employee Benefits Enrollment Update 5) 2020-2021 Proposed Budget Development Calendar
NOVEMBER 2019
1. Fiscal Year 2019 Audited Financial Report 2. Fiscal Year 2020 Financial Statements – as
3. Agenda Items for November Board of Trustees Meeting – Budget Related 4. Administration Office Updates –
26
2019-2020 Finance & Administration Committee Meeting - Agendas
Updated: 8.23.2019 a. Substitute Teacher Update b. Athletics Department Highlights 5. Discussion on District vs Cooperative Pricing 6. Fiscal Year 2021 Budget Development Calendar
7.
First Quarter Travel Report – Superintendent/Cabinet/BOT
DECEMBER 2019
1) Fiscal Year 2021 Budget Development - Update 2) Agenda Items for December Board of Trustees Meeting – Budget Related 3) Discussion on District vs Cooperative Pricing 4) Fiscal Year 2021 Budget Development Calendar
JANUARY 2020
1) Workers Compensation – Actuarial Report 2) 2020-2021 Budget Development – Update 3) Agenda Items for January Board of Trustees Meeting – Budget Related 4) Fiscal Year 2020 Financial Statements – as
5) Second Quarterly Travel Report – Superintendent/Cabinet/BOT 6) Fiscal Year 2021 Budget Development Calendar
FEBRUARY 2020
1) 2020-2021 Budget Development – Update a. Overlapping Tax Debt Impact – Report b. Budget Challenges & Considerations c. FY21 Revenue Projections 2) Agenda Items for February Board of Trustees Meeting – Budget Related 3) Fiscal Year 2020 Financial Statements – as
4) Fiscal Year 2020Financial Forecast 5) Fiscal Year 2021 Budget Development Calendar
MARCH 2020
1) 2020-2021Budget Development a. Revenue Projections b. Revenue & Expense Snapshot c. Debt Service Fund Projections d. Capital Replacement & Additional Budget Requests e. Budget Challenges & Considerations 2) Agenda Items for March Board of Trustees Meeting – Budget Related 3) Calendar – Review a. 2020 Truth In Taxation Calendar b. Fiscal Year 2021 Budget Development Calendar
APRIL 2019
1) 2020-2021 Budget Development a. General Fund - Revenue Projections b. General Fund - Budget Snapshot c. Budget Challenges & Considerations d. Debt Service Fund – Budget Snapshot e. Food Service Fund – Budget Snapshot f. Capital Replacement & Additional Budget Requests – Proposed 2) Administration Office Updates – a) 2020-2021 Compensation Review - TASB b) 2020-2021 Campus Staffing Results c) Health Care/TRS Active Care Update d) Compensation Summary - Miscellaneous Pay, Extra Performance Pay, Substitute Pay Rates 3) Fiscal Year 2020 Financial Statements – as
4) Fiscal Year 2021 Budget Development Calendar 5) Quarterly Travel Report – Superintendent/Cabinet/BOT
MAY 2020
1) 2020-2021 Budget Development a) General Fund - Revenue Projections b) General Fund - Budget Snapshot c) Budget Challenges & Considerations d) Debt Service Fund – Budget Snapshot e) Food Service Fund – Budget Snapshot f) Capital Replacement & Additional Budget Requests – Proposed 2) Administration Office Updates –
27
2019-2020 Finance & Administration Committee Meeting - Agendas
Updated: 8.23.2019 e) 2020-2021 Compensation Review - TASB f) Health Care/TRS Active Care Update g) Compensation Summary - Miscellaneous Pay, Extra Performance Pay, Substitute Pay Rates 3) Fiscal Year 2020 Financial Forecast 4) Fiscal Year 2020Financial Statements – as of March 31, 2020
JUNE 2020
1) Agenda Items for June Board of Trustees Meeting – Budget Related 2) Fiscal Year 2020Financial Statements – as of April 30, 2020
28
El Paso ISD Travel Report Superintendent, Board of Trustees, Cabinet Fourth Quarter - April 1, 2019 - June 30, 2019
CC-Paid using employee issued District card * Paid by outside agency, partial or 100% The activity listed on this Travel Report represents trips taken during the reporting period and could be pending final expenditure amounts
DESTINATION DEPART RETURN Conference FARE HOTEL CAR MEALS MISC REGISTRATION TOTAL SUBMIT FOR PAYMENT Superintendent, Juan Cabrera New York/Washington/Austin 05/05/19 05/09/19 NY Schools/CGCS/TSA 2,169.96 1,097.93 0.00 247.60 327.93 0.00 3,843.42 06/11/19 Austin/Georgetown 05/20/19 05/23/19 Legislative Meeting/Texas Quality Strategic Plan 713.96 0.00 242.83 69.11 35.42 700.00 1,761.32 06/25/19 Austin/San Antonio 06/12/19 06/16/19 TASB Summer Leadership Institute 710.96 282.60 0.00 34.56 38.92 395.00 1,462.04 06/25/19
06/20/19 06/22/19 TASB Summer Leadership Institute 364.98 491.00 0.00 0.00 64.96 395.00 1,315.94 06/30/19 Austin/San Antonio 06/22/19 06/25/19 TALAS/UT-TASA Summer Conference/TUC/TQE Luncheon 0.00 788.88 0.00 99.18 47.34 310.00 1,245.40 06/30/19 San Antonio/Austin 06/26/19 06/27/19 SGS Summit 2019/Commissioner's TASA Cabinet of Superintendents 356.98 0.00 312.31 8.23 71.25 0.00 748.77 06/30/19 TOTALS $4,316.84 $2,660.41 $555.14 $458.68 $585.82 $1,800.00 $10,376.89 Board of Trustees Bob Geske, President - District 1 FARE HOTEL CAR MEALS MISC REGISTRATION TOTAL SUBMIT FOR PAYMENT San Antonio 06/12/19 06/15/19 Summer Leadership Institute 550.16 802.24 0.00 44.02 27.00 395.00 1,818.42 6/30/2019 Al Velarde, Secretary - District 2 San Antonio 06/12/19 06/15/19 Summer Leadership Institute 538.66 821.73 171.58 0.00 0.00 395.00 1,926.97 06/30/19 San Antonio 06/25/19 06/28/19 System of Greater Schools Summit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 None Vacant-Trustee - District 3 None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 None Diane Dye, Trustee - District 4 Fort Worth 06/22/19 06/25/19 Summer Leadership Institute 0.00 390.05 0.00 0.00 0.00 395.00 785.05 6/30/2019 Chuck Taylor, Trustee - District 5 None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 None Freddy Khlayel, Trustee - District 6 None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 None Daniel Call, Trustee - District 7 None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 None TOTALS $1,088.82 $2,014.02 $171.58 $44.02 $27.00 $1,185.00 $4,530.44
29
El Paso ISD Travel Report Superintendent, Board of Trustees, Cabinet Fourth Quarter - April 1, 2019 - June 30, 2019
CC-Paid using employee issued District card * Paid by outside agency, partial or 100% The activity listed on this Travel Report represents trips taken during the reporting period and could be pending final expenditure amounts
DESTINATION DEPART RETURN Conference FARE HOTEL CAR MEALS MISC REGISTRATION TOTAL SUBMIT FOR PAYMENT Executive Cabinet Carmen Arrieta-Candelaria, Deputy Superintendent of Finance & Operations FARE HOTEL CAR MEALS MISC REGISTRATION TOTAL SUBMIT FOR PAYMENT Los Angeles 05/19/19 05/22/19 GFOA 113th Annual Conference 0.00 917.76 0.00 169.00 112.40 465.00 1,664.16 06/11/19 Austin 06/12/19 06/12/19 Texas School Alliance TSA Post Session 103.28 0.00 0.00 0.00 0.00 0.00 103.28 CC Austin 06/22/19 06/24/19 Texas Urban Council Meeting 416.96 472.61 0.00 85.75 79.86 0.00 1,055.18 06/30/19 Jeanne "Cezy" Collins, Legal Counsel None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 None Jose Lopez, Chief of Staff Austin 04/10/19 04/10/19 TSA Superintendent & Lead Staff Meeting 659.96 0.00 0.00 0.00 35.63 0.00 695.59 05/10/19 Austin 04/23/19 04/25/19 ACET Conference 582.96 318.56 141.18 152.50 37.00 425.00 1,657.20 06/06/19 Austin 05/08/19 05/09/19 TSA Superintendent & Lead Staff Meeting 505.96 305.80 91.50 87.00 990.26 06/06/19 Georgetown 05/20/19 05/23/19 Texas Quality Strategic Plan 592.96 330.63 204.51 181.00 58.33 700.00 2,067.43 06/18/19 Austin/San Antonio 06/12/19 06/15/19 TSA Post Legislative Session/Summer Leadership Institute 366.96 527.82 309.55 139.50 96.85 395.00 1,835.68 06/30/19
06/20/19 06/25/19 Summer Leadership Institute/TASB/Texas Urban Council/TQE 158.98 800.38 0.00 273.75 110.34 545.00 1,888.45 06/30/19 San Antonio 06/26/19 06/28/19 Systems of Great Schools Summit 171.00 0.00 0.00 52.75 69.78 0.00 293.53 06/30/19 Melissa Martinez, Executive Director of Community Engagement Austin 06/12/19 06/13/19 TSPRA COMMITTEE MEETING 305.96 195.11 0.00 91.50 48.90 0.00 641.47 CC Austin 06/21/19 06/24/19 UT/TASA SUMMER CONFERENCE 348.96 455.76 0.00 112.50 79.72 0.00 996.94 06/30/19 Elizabeth Saenz, Deputy Superintendent of Academics & School Leadership None 0.00 0.00 0.00 0.00 0.00 0.00 0.00 None Vince Sheffield, Deputy Superintendent of Administration Austin 06/23/19 06/24/19 Texas Urban Council Meeting 448.96 432.66 0.00 112.50 37.00 0.00 1,031.12 06/30/19 Alan Wiernicki, Chief Quality Officer Georgetown 05/20/19 05/23/19 Texas Quality Strategic Plan 669.96 330.63 0.00 156.00 0.00 700.00 1,856.59 06/05/19 Austin/San Antonio 06/22/19 06/25/19 Texas Urban Council Meeting/Texas Quality Strategic Plan 343.96 521.45 29.53 138.75 15.20 425.00 1,473.89 06/30/19 $5,676.82 $5,609.17 $684.77 $1,757.00 $868.01 $3,655.00 $18,250.77 TOTALS
30