Spreadsheet: 027f768c-8b20-4585-ba33-4ce17782d2bb
Sheet: Sheet1

Instructions for CEP Monthly Federal Reimbursement Estimator
Step 1: Calculating the Identified Student Percentage (reflective of April 1)
1.1   Enter the total number of identified students reflective of April 1.  Identified students are defined as the students certified for free meals not through the submission of individual applications.  This definition includes students directly certified through SNAP, TANF, and FDPIR participation, and homeless on the liaison list, [NAME], pre-K Even Start, migrant youth, runaways, and non-applicants approved by local officials.  [NAME] children certified through means other than an application are also included. (7 CFR 245.6a(c)(2))
Students who are categorically eligible based on submission of a free and reduced price application (e.g., submitted an application with a SNAP number on it) are not included.
1.2   Enter the total student enrollment reflective of April 1
Step 2: Federal Reimbursement Rates
·         Use the drop down menus to select your current free and paid reimbursement rates for the NSLP and SBP.
o   The reimbursement rates table is unprotected and may be updated each year.
o   If you do not know your reimbursement rates, click on the link in the upper right corner of the worksheet for assistance.
o   If your reimbursement rate is not listed in the drop down menu, enter your reimbursement rate in the table in the lower left of the worksheet. Enter reimbursement rates in blank cells under "----OTHER----".  Once entered into the table, select your reimbursement rate from the drop down menu under the “OTHER” header.
·         If your School Food Authority is certified to receive the 6 cents performance-based reimbursement,
select $0.06 from the drop down menu.
Step 3: Monthly Meal Data
3.1 Enter the total number of lunches served in a month for the local educational agency, school, or
group of schools considering the Community Eligibility Provision.
3.2 Enter the total number of breakfasts served in a month for the local educational agency, school, or
group of schools considering the Community Eligibility Provision.
Step 4: Anticipated Participation Change Due to Serving All Free Meals
4.1 If you anticipate that participation will increase or decrease due to all meals being served free, enter
the estimated percent change in participation.  For more information regarding CEP impacts on student participation, see the
CEP Evaluation Study.
Results
The LIGHT GREEN box in the middle right hand side provides an estimate of monthly Federal reimbursements (monthly totals and per meal) under CEP, based on data entered in steps 1-4 above.
Optional Comparison:
Federal Reimbursement + Student Payments (non-CEP) vs. Federal Reimbursement under CEP
This section displays the estimated difference between the estimated Federal reimbursement operating under CEP and the current Federal reimbursements and student payments (if applicable).
Enter current monthly Federal reimbursements plus student payments (add together and enter a total) revenue for both breakfast and lunch.
Results
If the differences boxes in the lower right are bright green, then CEP is estimated to generate the same or more Federal revenue.  If the differences boxes in the lower right are red, then current procedures generate higher Federal revenue. LEAs will need to assess the availability of non-Federal sources to cover any meal costs above the Federal reimbursements.