Spreadsheet: 6e29a37e-4210-49c4-b3bd-ccd4b193c032
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
School Year (SY) 2012-13 Paid Lunch Equity (PLE) Tool Instructions
Note: Users may want to print the instructions and use them to guide users through the PLE Tool.
The PLE Tool (Tool) was created to help School Food Authorities (SFAs) calculate their paid lunch
price increase requirement and non-Federal source contributions to meet the requirements in Section
205 of the Healthy, Hunger-Free Kids Act of 2010.   If the pricing requirements calculated by the
Tool are not met or are exceeded, the Tool will also calculate any amounts carried over into
the next year. Note, the weighted average prices calculated in the Tool are the weighted average
of all paid lunch prices charged in the SFA.
For more information on amounts carried over please refer to SP 39-2011
This version of the PLE tool is only applicable to SY 2012-2013.  A new version of the tool will be issued for SY 2013-2014 |  |  |  |  |  |  |  | This version of the PLE tool is only applicable to SY 2012-2013.  A new version of the tool will be issued for SY 2013-2014
The SY 2012-13 PLE Tool consists of 6 tabs:
Hyperlinks are also placed throughout the tool to navigate to the different tabs
Tab 1: | SY 2011-12 Price Requirement
[NAME]: | SY 2012-13 Price Calculator
Tab 3: | SY 2012-13 Non-Federal Calculator
[NAME]: | SY 2010-11 Price Calculator
Tab 5: | SY 2011-12 Price Calculator
Tab 6: | SY2012-2013 REPORT
 | Cells shaded this color designate data entry cells. The SFA must enter the applicable data in these cells for the tool to calculate the requirements
SFAs need the following data to calculate the Weighted Average Price for SY 2012-13:
1.) SY 2010-11 Weighted Average Price
2.) All paid lunch prices for October 2011
3.) Number of paid lunches served associated with each paid lunch price in October 2011
SFAs who have opted to contribute non-Federal sources for SY 2012-13 need:
1.) SY2010-11 Weighted Average Price
2.) SY2011-12 Weighted Average Price (if different from SY2010-11 Weighted Average Price)
2.) Total number of paid lunches served in SY 2010-11
3.) The total dollar amount of SY 2011-12 non-Federal contribution
SY 2012-13 WEIGHTED AVERAGE PAID LUNCH PRICE CALCULATION
These instructions are for SFAs increasing their weighted average prices to meet the SY 2012-13 paid lunch price requirement
Step 1
Tab 1: | SY 2011-12 Price Requirement
1. Enter SY 2010-11 Weighted Average Price in the orange box.  If the SY 2010-11 weighted average price needs to be calculated click on the SY 2010-11 Price Calculator tab
This figure sets the pricing requirements throughout the Tool and helps determine any amounts carried forward. This figure was calculated through the SY 2011-12 PLE Tool.
After calculating the SY 2011-12 weighted average price requirement for paid lunches, click on the link labeled "Click here to go to SY 2012-13 Price Calculator"
Step 2
[NAME]: | SY 2012-13 Price Calculator
The box at the top of this tab displays the SY2012-13 Weighted Average Price Requirement
To calculate the SY 2011-12 Weighted Average Price the SFA must:
1.   Enter the paid lunch count for October 2011 associated with each paid meal price in the Monthly # of Paid Lunches column.
2.    Enter each paid lunch price in the SFA (including all schools – elementary, middle, high, etc) for October 2011 in the Paid Lunch Price column.
Using the SY2011-12 weighted average price, the tool calculates any amounts necessary to meet the SY2012-13 weighted average price requirements and any amounts carried forward to SY2013-14.
Tab 6: | SY2012-2013 REPORT
 | This report is generated for use in the SY2013-14 PLE tool and displays the SY2012-2013 requirements and any amount carried forward determined on the SY2012-2013 Price Calculator
Select the SY 2012-2013 method used to ensure sufficient funds are provided for PAID lunches
<OPTIONAL> Step 3
Pricing Estimation Calculator
Once an SFA has calculated the SY 2012-13 average paid lunch price requirement, they can
use the PLE tool to determine how they want to distribute the price increase within the SFA to
reach the new average paid lunch price.  To do this an SFA must:
1.   Enter the paid lunch count for October associated with each paid meal price in the Monthly # of Paid Lunches column.
2.    Change individual paid lunch prices until the average paid lunch price reaches the new average paid lunch price requirement.  This amount will appear in the Weighted Average Price box.
Many price combinations can be used to reach the new weighted average paid lunch price.
SFAs have the flexibility to raise individual prices as long as the weighted average price equals the new SY2012-2013 required level.
Go to SY 2012-13 Price Calculator
SY 2012-13 NON-FEDERAL SOURCE CONTRIBUTION CALCULATION
Step 1
Tab 1: | SY 2011-12 Price Requirement
1. Enter SY 2010-11 Weighted Average Price in the orange box.  If the SY 2010-11 weighted average price needs to be calculated click on the SY 2010-11 Price Calculator tab
This figure sets the pricing requirements throughout the Tool and helps determine any amounts carried forward. This figure was calculated through the SY 2011-12 PLE Tool.
After calculating the SY 2011-12 weighted average price requirement for paid lunches, go to SY 2012-13 Non-Federal Source Calculator tab
 | The box at the top of this tab displays the SY2012-13 Weighted Average Price Requirement
SY 2012-13 Non-Federal Source Contribution Requirement
1). Enter the current weighted average paid lunch price. This price may be the same as the SY 2010-2011 weighted average price determined on the SY2011-2012 Price Requirement tab if the SFA did not raise the weighted average price in SY 2011-2012. To determine the most current average weighted price go to the SY2011-2012 Price Calculator tab.
2.) Enter the paid lunch count for the entire 2010-2011 School Year in the
orange Annual # of Paid Lunches box in the Non-Federal Source Contribution Calculator
for SY 2012-13.
The Tool will calculate the annual non-Federal source contribution for SY 2012-13 with and will apply the 10 cent cap if applicable
2.) Enter the actual amount of the SY 2011-12 non-Federal source contribution in the orange box
labeled Amount of Non-Federal Source Funds Contributed for SY 2011-12.
Based on the actual amount contributed for SY 2011-12, the tool calculates the following:
 | ∙ [NAME] Non-Federal Source Contribution for SY 2012-13
 | ∙ [NAME] Non-Federal Source Contribution carried forward to SY 2013-14
 | ∙ [NAME] carried forward to SY 2013-14
Tab 6: | SY2012-2013 REPORT
 | This report is generated for use in the SY2013-14 PLE tool and displays the SY2012-2013 requirements and any amount carried forward determined on the SY2012-2013 Price Calculator
Select the SY 2012-2013 method used to ensure sufficient funds are provided for PAID lunches
[NAME]: | SY 2010-11 Price Calculator
To calculate the SY 2010-11 Weighted Average Price, an SFA must:
1.   Enter the paid lunch count for October 2010 associated with each paid meal price in the Monthly # of Paid Lunches column.
2.    Enter each paid lunch price in the SFA (including all schools – elementary, middle, high, etc) for October 2010 in the Paid Lunch Price column.
Tab 5: | SY 2011-12 Price Calculator
To calculate the SY 2010-11 Weighted Average Price, an SFA must:
1.   Enter the paid lunch count for October 2011 associated with each paid meal price in the Monthly # of Paid Lunches column.
2.    Enter each paid lunch price in the SFA (including all schools – elementary, middle, high, etc) for October 2011 in the Paid Lunch Price column.