Calculators
Current Paid Meal Price (weighted)
Utilize POS Reports to identify the # of Paid meals sold at each (current) paid meal price for a sample month. For example: Elementary 4000 meals @ $2.25, Middle 2500 meals @$2.50, High 3000 meals @ $2.75. Enter information into the YELLOW cells.
Breakfast
| Description | # of Paid Meals | Price |
|---|---|---|
|
|
|
|
| Paid Meal Price (Weighted) |
|
|
Lunch
| Description | # of Paid Meals | Price |
|---|---|---|
|
|
|
|
| Paid Meal Price (Weighted) |
|
|
Proposed Paid Meal Price (weighted)
Enter prices being considered here and view results on Summary.
Breakfast
| Description | # of Paid Meals | Price |
|---|---|---|
| {{x.name}} |
|
|
| Paid Meal Price (Weighted) |
|
|
Lunch
| Description | # of Paid Meals | Price |
|---|---|---|
| {{x.name}} |
|
|
| Paid Meal Price (Weighted) |
|
|
% of Meals Sold as Paid
This calculation is required for the Average Revenue per Meal calculation from the Summary Tab. Average Revenue Per Meal is also available on the Dashboard, but it will be very different in SY 22-23 due to the change back to F/R/P reimbursement rates.
Choose a sample month from a POS report and enter meals sold from each eligibility type. If your POS did not track this over the past school years, choose a reimbursement claim from the last school year this was reported and use that.
Breakfast
| Eligibility Type | Total # of Meals Sold | % of Total |
|---|---|---|
| Free |
|
|
| Reduced |
|
|
| Paid |
|
|
Lunch
| Eligibility Type | Total # of Meals Sold | % of Total |
|---|---|---|
| Free |
|
|
| Reduced |
|
|
| Paid |
|
|
Current and Future Projections
- Complete above sections first.
- Complete each YELLOW cell. Click on the cell to see notes (black upper right hand corner) to determine where to find this information.
- Utilize the "Projected Change" BLUE cells to determine what change you might expect given your district's current and future situation. Industry average predictions are pre-filled. Leave at 0 if you predict no change. Considerations might include changes in operating days, participation, attendance, and more. This is just an estimate to view/predict the "What If" Result (PURPLE). This allows you to make decisions you may be making now for next year (meal pricing, labor costs) using the best information you have available.
- See the end results of your budget in the "Profit/Loss Summary" sheet."
Breakfast
| Current | Projected Change % | Result | |
|---|---|---|---|
| Counts | |||
| Projected Annual # Sold |
|
|
|
| % of Meals Sold as Paid |
|
|
|
| Pricing & Reimbursement | |||
| Free Meal Reimbursement Rate |
|
|
|
| Paid Meal Reimbursement Rate |
|
|
|
| Paid Meal Price (Weighted) |
|
|
|
| Average Revenue Per Meal |
|
|
|
| Expenses | |||
| Food/Supply Cost Per Meal |
|
|
|
Lunch
| Current | Projected Change % | Result | |
|---|---|---|---|
| Counts | |||
| Projected Annual # Sold |
|
|
|
| % of Meals Sold as Paid |
|
|
|
| Pricing & Reimbursement | |||
| Free Meal Reimbursement Rate |
|
|
|
| Paid Meal Reimbursement Rate |
|
|
|
| Paid Meal Price (Weighted) |
|
|
|
| Average Revenue Per Meal |
|
|
|
| Expenses | |||
| Food/Supply Cost Per Meal |
|
|
|
Ala Carte
| Current | Projected Change % | Result | |
|---|---|---|---|
| Projected Annual Revenue |
|
|
|
| Projected Annual Expenses |
|
|
|
Labor & Overhead
| Current | Projected Change % | Result | |
|---|---|---|---|
| Projected Annual Labor Cost |
|
|
|
| Projected Annual Overhead Cost |
|
|
|
| Breakfast | |||
| Labor Cost Per |
|
|
|
| Overhead Cost Per |
|
|
|
| Lunch | |||
| Labor Cost Per |
|
|
|
| Overhead Cost Per |
|
|
|
| Ala Carte | |||
| Labor Cost Per |
|
|
|
| Overhead Cost Per |
|
|
Profit/Loss Summary
Total Annual
| Revenue | Meal |
|
|---|---|---|
| Ala Carte |
|
|
| Subtotal |
|
|
| Expenses | Food/Supply |
|
| Labor |
|
|
| Overhead |
|
|
| Subtotal |
|
|
| Profit/Loss |
|
|
| Profit Margin |
|
Per Meal/Ala Carte
| Lunch | Breakfast | Ala Carte | |
|---|---|---|---|
| Avg. Revenue |
|
|
|
| Food Supply |
|
|
|
| Labor |
|
|
|
| Overhead |
|
|
|
| Subtotal |
|
|
|
| Profit/Loss |
|
|
|
| Profit Margin |
|
|
|
| Weighted Paid Price Breakeven |
|
|
