Filetype Excel XLSX | Posted on 15 Aug 2022 | 4 years ago
Authentication
digital resources
288x Filetype XLSX File size 0.09 MB Source: dpi.wi.gov
Sheet 1: Instructions
| Nonprogram Foods Revenue Compliance Tool 7 CFR Part 210 | Using the Tool | ||||||||||||||||||
| Nonprogram Foods Section (Non-reimbursable Items) | |||||||||||||||||||
| Program Foods Section (Reimbursable Meals) | |||||||||||||||||||
| Instructions | |||||||||||||||||||
| NONPROGRAM FOODS REVENUE TOOL | Name of School Food Authority | ABC School District | |||||||||
| Peach cells indicate data entry from SFA | Reference Period (5 consecutive days) | September 17 to 21, 2018 | |||||||||
| NONPROGRAM FOODS - Food Costs and Revenues (Non-reimburseable Items) | Completed by and date | F.S. Director, 9/24/18 | |||||||||
| A. Nonprogram Food Item | B. Raw Food Cost | C. Recommend Selling Price* | D. Actual Selling Price | E. Actual vs. Recommend | F. Number Sold | G. Total Dollar Difference | H. Total Nonprogram Food Cost | I. Total Nonprogram Revenue | |||
| Whole Fresh Fruit | $0.26 | $0.68 | $0.75 | $0.07 | 50 | $3.50 | $13.00 | $37.50 | USDA Nonprogram Revenue Tool | ||
| Milk | $0.26 | $0.68 | $0.40 | -$0.28 | 350 | -$98.00 | $91.00 | $140.00 | |||
| Chips | $0.35 | $0.92 | $1.00 | $0.08 | 100 | $8.00 | $35.00 | $100.00 | Q. Cost for Reimbursable Meal Food | $953 | |
| Veggie Cup | $0.89 | $2.34 | $2.25 | -$0.09 | 30 | -$2.70 | $26.70 | $67.50 | R. Cost of Nonprogram Food | $373 | |
| Extra Entrée | $0.88 | $2.32 | $2.25 | -$0.07 | 20 | -$1.40 | $17.60 | $45.00 | S. Total Food Costs | $1,326 | |
| Snack Bars | $0.50 | $1.32 | $1.25 | -$0.07 | 50 | -$3.50 | $25.00 | $62.50 | T. Total Nonprogram Food Revenue | $913 | |
| Bottle Water | $0.35 | $0.92 | $1.50 | $0.58 | 40 | $23.20 | $14.00 | $60.00 | U. Total Revenue | $2,928 | |
| Adult Meals | $1.63 | $4.29 | $3.40 | -$0.89 | 25 | -$22.25 | $40.75 | $85.00 | Minimum percent of revenue from nonprogram funds | 28% | |
| Cookies | $0.30 | $0.79 | $1.00 | $0.21 | 125 | $26.25 | $37.50 | $125.00 | V. Minimum Revenue Required from the Sale of Nonprogram Foods | $823 | |
| Bottle Juice | $0.65 | $1.71 | $1.75 | $0.04 | 65 | $2.60 | $42.25 | $113.75 | W. Additional Revenue Needed to Comply | $- | |
| Bread/Dinner Roll | $0.18 | $0.47 | $0.50 | $0.03 | 40 | $1.20 | $7.20 | $20.00 | |||
| Fruit Cup | $0.91 | $2.39 | $2.25 | -$0.14 | 25 | -$3.50 | $22.75 | $56.25 | |||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| -$66.60 | $372.75 | $912.50 | |||||||||
| PROGRAM FOODS - Food Costs and Revenue (Reimburseable Meals) | |||||||||||
| J. Reimbursable Meal Type | K. Raw Food Cost | L. Actual Selling Price | M. USDA (federal only) Reimbursements | N. Number Sold | O. Total Reimbursable Food Cost | P. Total Reimbursable Food Revenue | |||||
| NSLP/CEP Free | $1.63 | $0.00 | $3.23 | 140 | $228.20 | $452.20 | |||||
| NSLP Reduced | $1.63 | $0.40 | $2.83 | 40 | $65.20 | $129.20 | |||||
| *NSLP Paid | $1.63 | $3.50 | $0.31 | 275 | $448.25 | $1,047.75 | |||||
| CEP Paid Lunch | $1.63 | $0.00 | $0.00 | ||||||||
| SB/CEP Free | $0.88 | $0.00 | $1.75 | 50 | $44.00 | $87.50 | |||||
| SB Reduced | $0.88 | $0.30 | $1.45 | 15 | $13.20 | $26.25 | |||||
| SNB/CEP Free | $0.88 | $0.00 | $2.09 | $0.00 | $0.00 | ||||||
| SNB Reduced | $0.88 | $0.30 | $1.79 | $0.00 | $0.00 | ||||||
| *Paid Breakfast | $0.88 | $1.50 | $0.30 | 100 | $88.00 | $180.00 | |||||
| CEP Paid Breakfast | $0.88 | $0.30 | $0.00 | $0.00 | |||||||
| Area El Snack & Free | $0.61 | $0.00 | $0.88 | 100 | $61.00 | $88.00 | |||||
| Reduced Snack | $0.61 | $0.15 | $0.44 | $0.00 | $0.00 | ||||||
| Paid Snack | $0.61 | $0.80 | $0.08 | $0.00 | $0.00 | ||||||
| SMP Pricing | $0.26 | $0.10 | $0.2075 | $0.00 | $0.00 | ||||||
| SMP Nonpricing | $0.26 | $0.00 | $0.2075 | 20 | $5.20 | $4.15 | |||||
| $953.05 | $2,015.05 | ||||||||||
| *if school has tiered prices, weighted average price must be used which may be obtained from PLE for NSLP. | |||||||||||
| NSLP (National School Lunch Program), CEP (Community Eligibility Provision), SB (School Breakfast Program), SNB (Severe Need Breakfast Program), | |||||||||||
| Area El (Area Eligible Snack Program, SMP (Special Milk Program), PLE (Paid Lunch Equity) |
no reviews yet
Please Login to review.
