Spreadsheet: 0b573ce3-b436-4ba8-aac6-0abf6041b206
Sheet: Planning Calculator

School Year 2013-2014 Spring Surveys |  |  |  |  |  |  |  |  |  |  |  |  | SY 2013-2014 Estimated Entitlement:
Regular USDA Foods Planning Calculator |  |  |  |  |  |  |  |  |  |  |  |  | Amount Used By These Surveys:
 |  |  |  |  |  |  |  |  |  |  |  |  | Estimated Remaining Entitlement:
CLiCS 1 Survey Number | USDA Category /Available List | WBSCM ID | Description | Cost per Case | August | September | October | November | December | January | February | March | Total Number of Cases Surveyed | Cost of Cases Surveyed
1 | Cheese | 100012 | CHEESE CHED RDU FAT YEL SHRED BAG-6/5 LB | 65.06
1 | Cheese | 100018 | CHEESE PROCESS YEL SLC LVS-6/5 LB | 61.13
1 | Cheese | 100021 | CHEESE MOZ LM PART SKM SHRD FRZ BOX-30LB | 64.83
1 | Cheese | 100036 | CHEESE BLEND AMER SKM YEL SLC LVS-6/5 LB | 57.22
1 | Grains/Flour | 100410 | FLOUR WHOLE WHEAT BAG-8/5 LB | 12.74
1 | Grains/Flour | 100427 | WHOLE GRAIN SPAGHETTI CTN-20 LB | 8.62
1 | Grains/Flour | 100434 | WHOLE GRAIN PASTA ROTINI MAC CTN-20 LB | 9.27
1 | Grains/Flour | 100466 | OATS ROLLED PKG-12/3 LB | 16.12
1 | Grains/Flour | 100494 | RICE US#1 LONG GRAIN PARBOILED BAG-25 LB | 10
1 | Grains/Flour | 100496 | [NAME] MEDIUM GRAIN BAG-25 LB | 12.71
1 | Grains/Flour | 100500 | RICE BRN US#1 LONG PARBOILED PKG-24/2 LB | 30.11
1 | Grains/Flour | 100919 | WHOLE GRAIN PASTA MACARONI CTN-20 LB | 8.8
1 | Grains/Flour | 100937 | WHOLE WHEAT PANCAKES FZN-144 COUNT | 8.36
1 | Grains/Flour | 100938 | WHOLE WHEAT TORTILLA 8" CTN-12/24 1.5 | 20.35
1 | Grains/Flour | 110146 | FLOUR ALL PURP ENRCH UNBLCH BAG-8/5 LB | 12.26
1 | Grains/Flour | 110147 | FLOUR BREAD ENRCH BLCH BAG-8/5 LB | 17.62
1 | Nuts/Seeds | 100396 | PEANUT BUTTER SMOOTH JAR-6/5 LB | 32.18
1 | Nuts/Seeds | 100935 | SUNFLOWER SEED BUTTER 6-5#'S | 62.58
1 | Oil | 100442 | OIL SOYBEAN LOW SAT FAT BTL-6/1 GAL | 37.87
2 | Fruit | 100206 | APPLE SLICES CAN-6/10 | 32.5
2 | Fruit | 100208 | APPLESAUCE CAN-6/10 | 30.08
2 | Fruit | 100214 | CRANBERRY SAUCE CAN-6/10 | 24.91
2 | Fruit | 100241 | PEACH FREESTONE DICED FRZ CUP-96/4.4 OZ | 28.51
2 | Fruit | 100244 | BLUEBERRY CULTIVATED FRZ CTN-30 LB | 42.57
2 | Fruit | 100253 | STRAWBERRY FRZ CTN-30 LB | 30.06
2 | Fruit | 100254 | STRAWBERRY SLICES FRZ CTN-30 LB | 30.16
2 | Fruit | 100256 | STRAWBERRY FRZ CUP-96/4.5 OZ | 35.29
2 | Fruit | 100258 | APPLE SLICES FRZ CTN-30 LB | 26.03
2 | Fruit | 100261 | APRICOT FRZ CUP-96/4.5 OZ | 34.92
2 | Fruit | 100277 | ORANGE JUICE SINGLE CTN-70/4 OZ | 8.86
2 | Fruit | 100293 | RAISINS BOX-144/1.33 OZ | 20.24
2 | Fruit | 100299 | CHERRIES DRIED PKG-4/4 LB | 62.13
2 | Fruit | 110161 | FRUIT MIX DRIED PKG-5/5 LB | 52.73
2 | Fruit | 110230 | APRICOTS DICED EX LT SUCROSE CAN 6/10 | 26.56
2 | Fruit | 110231 | APRICOTS HALVES EX LT SUCROSE CAN-6/10 | 23.99
2 | Fruit | 110233 | MIXED FRUIT EX LT SUCROSE CAN-6/10 | 24.92
2 | Fruit | 110234 | PEACHES CLING DICED EXLTSUCROSE CAN-6/10 | 21.69
2 | Fruit | 110237 | PEARS DICED EX LT SUCROSE CAN-6/10 | 24.95
2 | Fruit | 110238 | PEARS HALVES EX LT SUCROSE CAN-6/10 | 27.54
2 | Fruit | 110239 | PEARS SLICES EX LT SUCROSE CAN-6/10 | 22.32
3 | Legumes | 100307 | BEANS GREEN CAN-6/10 | 14.32
3 | Legumes | 100351 | BEANS GREEN FRZ CTN-30 LB | 17.02
3 | Legumes | 100359 | BEANS BLACK TURTLE CAN-6/10 | 15.04
3 | Legumes | 100360 | BEANS GARBANZO CAN-6/10 | 15.94
3 | Legumes | 100362 | BEANS REFRIED CAN-6/10 | 19.4
3 | Legumes | 100365 | BEANS PINTO CAN-6/10 | 15.82
3 | Legumes | 100368 | BEANS BLACKEYE CAN-6/10 | 15.51
3 | Legumes | 100370 | BEANS RED KIDNEY CAN-6/10 | 17.29
3 | Legumes | 100371 | BEANS BABY LIMA CAN-6/10 | 18.48
3 | Legumes | 100373 | BEANS GREAT NORTHERN CAN-6/10 | 15.8
3 | Legumes | 100381 | BEANS GREAT NORTHERN DRY BAG-25 LB | 14.56
3 | Legumes | 110089 | BEANS GARBANZO DRY BAG-25 LB | 8.19
3 | Vegetable | 100309 | CARROTS CAN-6/10 | 17.25
3 | Vegetable | 100313 | CORN WHOLE KERNEL(LIQ) CAN-6/10 | 16.5
3 | Vegetable | 100315 | PEAS CAN-6/10 | 20.29
3 | Vegetable | 100317 | SWEET POTATOES W/ SYRUP CAN-6/10 | 24.79
3 | Vegetable | 100334 | TOMATO SAUCE CAN-6/10 | 12.21
3 | Vegetable | 100336 | SPAGHETTI SAUCE MEATLESS CAN-6/10 | 12.6
3 | Vegetable | 100348 | CORN FRZ CTN-30 LB | 17.38
3 | Vegetable | 100350 | PEAS GREEN FRZ CTN-30 LB | 19.79
3 | Vegetable | 100352 | CARROTS FRZ CTN-30 LB | 17.91
3 | Vegetable | 100353 | SWEET POTATOES RANDOM CUT FRZ PKG-6/5 LB | 17.17
3 | Vegetable | 100354 | SWEET POTATOES MASHED FRZ PKG-6/5 LB | 19.3
3 | Vegetable | 100356 | POTATOES WEDGE FAT FREE FRZ PKG-6/5 LB | 16.3
3 | Vegetable | 100357 | POTATOES OVENS FRY PKG-6/5 LB | 14.59
3 | Vegetable | 100358 | POTATOES ROUNDS FRZ PKG-6/5 LB | 14.6
3 | Vegetable | 110185 | TOMATO DICED POUCH-6/102 OZ | 17.5
3 | Vegetable | 110186 | TOMATO SALSA POUCH-6/106 OZ | 17.16
3 | Vegetable | 110189 | TOMATO PASTE POUCH-6/111 OZ | 26.39
3 | Vegetable | 110282 | BROCCOLI FRZ PKG-6/5 LB | 28.5
4 | Beef | 100127 | BEEF CAN-24/24 OZ | 125.94
4 | Beef | 100134 | BEEF CRUMBLES W/SPP PKG-4/10 LB | 103.34
4 | Beef | 100158 | BEEF FINE GROUND FRZ CTN-40 LB | 89.12
4 | Beef | 110322 | BEEF SPP PTY HSTYLE CKD 2.0MMA CTN-40 LB | 102.44
4 | Beef | 110346 | BEEF 100% PTY 90/10 FRZ 2.0MMA CTN-40 LB | 107.5
4 | Egg | 100046 | EGGS WHOLE FRZ CTN-6/5 LB | 24.97
4 | Fish | 100201 | CATFISH STRIPS BRD OVN RDY PKG-4/10 LB | 171.14
4 | Pork | 100173 | PORK ROAST LEG FRZ CTN-32-40 LB | 55.48
4 | Pork | 100184 | PORK HAM WATERAD FRZ PKG 4/10 LB | 56.08
4 | Pork | 100187 | PORK HAM WATERAD SLC FRZ PKG-8/5 LB | 69.74
4 | Pork | 100188 | PORK HAM WTRADCBEDFRZ PKG-4/10 OR 8/5 LB | 78.96
4 | Poultry | 100101 | CHICKEN DICED CTN-40 LB | 96.44
4 | Poultry | 100117 | CHICKEN FAJITA STRIPS CTN-30 LB | 63.58
4 | Poultry | 100119 | TURKEY TACO FILLING CTN-30 LB | 55.2
4 | Poultry | 100121 | TURKEY BREAST DELI FRZ CTN-40 LB | 81.04
4 | Poultry | 100125 | TURKEY ROASTS FRZ CTN-32-48 LB | 79.75
4 | Poultry | 100126 | [NAME] CTN-40 LB | 49.78
 |  |  |  | Number of Cases to be Delivered per Month