ABCDEFGHJKLMNOPQRSTUVWXYZ
1
2
3
School Year (SY) 2015-16 Paid Lunch Equity (PLE) Tool Instructions
4
Note: Users may want to print the instructions and use them to guide users through the PLE Tool.
5
6
The PLE Tool (Tool) was created to help School Food Authorities (SFAs) calculate their paid lunch
7
price increase requirement and non-Federal source contributions to meet the requirements in Section
8
205 of the Healthy, Hunger-Free Kids Act of 2010. If the pricing requirements calculated by the
9
Tool are not met or are exceeded, the Tool will also calculate any amounts carried over into
10
the next year. Note, the weighted average prices calculated in the Tool are the weighted average
11
of all paid lunch prices charged in the SFA.
12
13
For more information on amounts carried over please refer to SP 39-2011
14
15
This version of the PLE tool is only applicable to SY 2015-2016. A new version of the tool will be issued for SY 2016-2017
16
17
18
The SY 2015-16 PLE Tool consists of 5 tabs:
19
Hyperlinks are also placed throughout the tool to navigate to the different tabs
20
Tab 1:Tab 1: SY 2011-12 Price Requirement
21
Tab 2:Tab 2: SY 2012-13 Price Requirement
22
Tab 3:Tab 3: SY 2012-13 Non-Federal Calculator
23
Tab 4:SY 2010-11 Price Calculator
24
 Tab 5: SY 2011-12 Price Calculator
25
* The last two tabs (SY 14-15 and SY 10-11 Price Calculators) are for reference only
26
27
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
28
29
30
SFAs need the following data to calculate the Weighted Average Price for SY 2015-16:
31
32
1.) SY 2010-11 Weighted Average Price
33
2.) All paid lunch prices for October 2014
34
3.) Number of paid lunches served associated with each paid lunch price in October 2014
35
36
SFAs who have opted to contribute non-Federal sources for SY 2015-16 need:
37
1.) SY 2010-11 Weighted Average Price
38
2.) SY 2014-15 Weighted Average Price (if different from SY 2010-11 Weighted Average Price)
39
2.) Total number of paid lunches served in SY 2013-14
40
3.) The total dollar amount through SY 2014-15 non-Federal contribution
41
42
SY 2015-16 WEIGHTED AVERAGE PAID LUNCH PRICE CALCULATION
43
These instructions are for SFAs increasing their weighted average prices to meet the SY 2015-16 paid lunch price requirement
44
45
Step 1
46
Tab 1:Tab 1: SY 2011-12 Price Requirement
47
48
1. Enter SY 2014-15 Weighted Average Price in the orange box.
If the SY 2014-15 weighted average price is not known then use the unrounded requirement finder.
49
50
This figure sets the pricing requirements throughout the Tool and helps determine any amounts carried forward. This figure was calculated through the SY 2014-15 PLE Tool.
51
52
53
54
55
After calculating the SY 2013-14 weighted average price requirement for paid lunches, click on the link labeled "Click here to go to SY 2014-15 Price Calculator"
56
57
Step 2
58
Tab 2:Tab 2: SY 2012-13 Price Requirement
59
The box at the top of this tab displays the SY2013-14 Weighted Average Price Requirement
60
61
To calculate the SY 2014-15 Weighted Average Price the SFA must:
62
63
1.   Enter the paid lunch count for October 2013 associated with each paid meal price in the Monthly # of Paid Lunches column.
64
65
2.    Enter each paid lunch price in the SFA (including all schools – elementary, middle, high, etc) for October 2013 in the Paid Lunch Price column.
66
67
68
Using the SY2013-14 weighted average price, the tool calculates any amounts necessary to meet the SY2014-15 weighted average price requirements and any amounts carried forward to SY2015-16.
69
70
71
Tab 5: SY2012-2013 REPORT
72
This report is generated for use in the SY2016-17 PLE tool and displays the SY2015-2016 requirements and any amount carried forward determined on the SY2015-2016 Price Calculator
73
74
Select the SY 2015-2016 method used to ensure sufficient funds are provided for PAID lunches
75
76
<OPTIONAL> Step 3
77
Pricing Estimation Calculator
78
Once an SFA has calculated the SY 2015-156 average paid lunch price requirement, they can
79
use the PLE tool to determine how they want to distribute the price increase within the SFA to
80
reach the new average paid lunch price. To do this an SFA must:
81
82
1.   Enter the paid lunch count for October associated with each paid meal price in the Monthly # of Paid Lunches column.
83
84
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.
85
86
87
Many price combinations can be used to reach the new weighted average paid lunch price.
88
SFAs have the flexibility to raise individual prices as long as the weighted average price equals the new SY2014-2015 required level.
89
90
91
Go to SY 2014-15 Price Calculator
92
SY 2015-16 NON-FEDERAL SOURCE CONTRIBUTION CALCULATION
93
94
Step 1
95
Tab 1:Tab 1: SY 2011-12 Price Requirement
96
97
1. Enter SY 2014-15 Weighted Average Price in the orange box.
If the SY 2014-15 weighted average price is not known then use the unrounded requirement finder
98
99
This figure sets the pricing requirements throughout the Tool and helps determine any amounts carried forward. This figure was calculated through the SY 2014-15 PLE Tool.
100