Spreadsheet: 127739d1320515125-averaging-inventory
Sheet: Period Totals

PERIOD | Inventory Summary Report
11
CELINA
CATEGORY 1 |  | count |  | Amounts Used by Week |  |  |  |  | Average
CHICKEN | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
PURPLE 8PC CUT | head | 18 |  | 457 | 221 | 0 | 0 |  | 169.5
[NAME] | head | 16 |  | 108 | 38 | 0 | 0 |  | 36.5
DARK MEAT CHICKEN | head | 21 |  | 107 | 54 | 0 | 0 |  | 40.25
CATEGORY 2 |  | count |  | Amounts Used by Week |  |  |  |  | Average
LIV & GIZ | count | per bag |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
5LB BAG OF GIZZARDS | pound | 5 |  | 75 | 35 | 0 | 0 |  | 27.5
5LB BAG OF LIVERS | pound | 5 |  | 75 | 35 | 0 | 0 |  | 27.5
CATEGORY 3 |  | count |  | Amounts Used by Week |  |  |  |  | Average
[NAME] | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
[NAME] PATTIES 40/4OZ | each | 40 |  | 278 | 240 | 0 | 0 |  | 129.5
WHITE GRAVY | each | 48 |  | 33 | 54 | 0 | 0 |  | 21.75
CATEGORY 4 |  | count |  | Amounts Used by Week |  |  |  |  | Average
WINGS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
HOT WINGS | pound | 40 |  | 18 | 50 | 0 | 0 |  | 17
CATEGORY 5 |  | count |  | Amounts Used by Week |  |  |  |  | Average
SANDWICH | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
PAPER SNACK WRAP | sleeve | 2 |  | 0.09999999999999998 | 0.9 | 0 | 0 |  | 0.25
MULTIPURPOSE BAGS | case | 1 |  | 0 | 0.25 | 0 | 0 |  | 0.0625
SNACKER BUNS | box | 12 |  | 13 | 13 | 0 | 0 |  | 6.5
KFC CHICKEN BREAST FILET | pound | 40 |  | 47 | 60 | 0 | 0 |  | 26.75
COLONELS SPECIAL SAUCE | bag | 12 |  | 2 | 19 | 0 | 0 |  | 5.25
[NAME] | each | 4 |  | 0.75 | 5.5 | 0 | 0 |  | 1.5625
[NAME] | each | 12 |  | 3 | 15 | 0 | 0 |  | 4.5
YUM QUILT WRAP | case | 1 |  | 0.09999999999999998 | 0.25 | 0 | 0 |  | 0.0875
HAWIIAN BUNS | pkg | 8 |  | 5 | 7 | 0 | 0 |  | 3
CATEGORY 6 |  | count |  | Amounts Used by Week |  |  |  |  | Average
SHORTENING | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
SHORTNENING 35LBS | case | 1 |  | 14 | 10 | 0 | 0 |  | 6
CATEGORY 7 |  | count |  | Amounts Used by Week |  |  |  |  | Average
SEASONINGS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
BREADING FLOUR | bag | 2 |  | 14 | 12 | 0 | 0 |  | 6.5
BREADING SALT | box | 12 |  | 7 | 13 | 0 | 0 |  | 5
GRILLED SEASONING | each | 36 |  | 18 | 57 | 0 | 0 |  | 18.75
CRISPY SEASONING | each | 12 |  | 7 | 15 | 0 | 0 |  | 5.5
MILK AND EGG MIX | each | 48 |  | 7 | 12 | 0 | 0 |  | 4.75
ORGINAL RECIPIE SEASONING | each | 16 |  | 7 | 13 | 0 | 0 |  | 5
CATEGORY 8 |  | count |  | Amounts Used by Week |  |  |  |  | Average
[NAME] | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
COLE SLAW DRESSING | bag | 8 |  | 18 | 26 | 0 | 0 |  | 11
GREEN BEANS | can | 6 |  | 18 | 19 | 0 | 0 |  | 9.25
MACARONI AND CHEESE | tin | 6 |  | 20 | 20 | 0 | 0 |  | 10
MACARONI SALAD | box | 3 |  | 4 | 3 | 0 | 0 |  | 1.75
POTATO SALAD | box | 3 |  | 3.25 | 5 | 0 | 0 |  | 2.0625
PRECHOP CABBAGE W O AND C | box | 1 |  | 6 | 6 | 0 | 0 |  | 3
PREPARED COLE SLAW | gallon | 1 |  | 21 | 2 | 0 | 0 |  | 5.75
SLICED CARRORTS | case | 12 |  | 0.75 | 3.5 | 0 | 0 |  | 1.0625
STABILIZER MIX | bag | 6 |  | 1 | 4.5 | 0 | 0 |  | 1.375
VEGETABLE SEASONING | case | 1 |  | 0.05000000000000004 | 0.6 | 0 | 0 |  | 0.1625
CATEGORY 9 |  | count |  | Amounts Used by Week |  |  |  |  | Average
BISCUITS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
BISCUIT LINERS | sleeve | 4 |  | 0.5999999999999996 | 3.5 | 0 | 0 |  | 1.025
BISCUITS | case | 1 |  | 11 | 4 | 0 | 0 |  | 3.75
BUTTER SAVORY | jug | 2 |  | 2 | 4 | 0 | 0 |  | 1.5
GRAPE JELLY PKTS | case | 1 |  | 0.6499999999999999 | 3.1 | 0 | 0 |  | 0.9375
HONEY SAUCE PKTS | case | 1 |  | 2.3 | 4.2 | 0 | 0 |  | 1.625
MARGARINE PACKETS | box | 1 |  | 0.3999999999999999 | 1.1 | 0 | 0 |  | 0.375
CATEGORY 10 |  | count |  | Amounts Used by Week |  |  |  |  | Average
DESSERTS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
CHOCOLATE CHIP CAKES | each | 18 |  | 7 | 18 | 0 | 0 |  | 6.25
COOKIE DOUGH | each | 1 |  | 0.3 | 0.8 | 0 | 0 |  | 0.275
OREO COOKIE CREAM PIE | each | 24 |  | 17 | 32 | 0 | 0 |  | 12.25
REESES PEANUT BCUP PIE | each | 24 |  | 24 | 40 | 0 | 0 |  | 16
CATEGORY 11 |  | count |  | Amounts Used by Week |  |  |  |  | Average
BUFFET | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
6" WHITE PLATE 8 sleeves | sleeve | 8 |  | 5 | 5 | 0 | 0 |  | 2.5
9" WHITE BUFFET PLATE | sleeve | 4 |  | 9 | 10 | 0 | 0 |  | 4.75
APPLE FILLING 10 pkgs | pkg | 10 |  | 6 | 10 | 0 | 0 |  | 4
APPLESAUCE | can | 6 |  | 3 | 9 | 0 | 0 |  | 3
ASSORTED RED GELATIN | pkg | 12 |  | 0 | 0 | 0 | 0 |  | 0
ASSTORTED CITRUS GELATIN | pkg | 12 |  | 0 | 0 | 0 | 0 |  | 0
BANANA PUDDING | can | 6 |  | 0 | 2 | 0 | 0 |  | 0.5
BROCCOLI CUTS FROZEN | case | 1 |  | 0 | 0 | 0 | 0 |  | 0
BROCCOLI NORMANDY | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0
CHEESE SAUCE | pkg | 16 |  | 0 | 0 | 0 | 0 |  | 0
CHERRY FILLING 10 pkgs | pkg | 10 |  | 6 | 10 | 0 | 0 |  | 4
CHICKEN SOUP MIX | bag | 12 |  | 11 | 19 | 0 | 0 |  | 7.5
CHOCOLATE MOUSSE | box | 1 |  | 0 | 0.5 | 0 | 0 |  | 0.125
CHOCOLATE PUDDING | can | 6 |  | 5 | 2 | 0 | 0 |  | 1.75
CINNANON DESSERT MIX | bag | 8 |  | 8 | 10 | 0 | 0 |  | 4.5
CLUB CRACKERS | bag | 2 |  | 0 | 0 | 0 | 0 |  | 0
CREAM CHICKEN BASE | bag | 16 |  | 11 | 20 | 0 | 0 |  | 7.75
CRUMB TOPPING | tub | 1 |  | 0.5 | 0.5 | 0 | 0 |  | 0.25
GRAM CRACKER CRUST | box | 1 |  | 0.3999999999999999 | 1.1 | 0 | 0 |  | 0.375
[NAME] | each | 16 |  | 2 | 6 | 0 | 0 |  | 2
ICE BOX LEMON FILLING | bag | 8 |  | 0 | 0 | 0 | 0 |  | 0
KEY LIME MIX | bag | 8 |  | 2 | 10 | 0 | 0 |  | 3
LEMON PUDDING CAKE | bag | 12 |  | -7 | 7 | 0 | 0 |  | 0
LIGHT BROWN SUGAR | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0
MIXED VEGETABLES | case | 1 |  | 0 | 0 | 0 | 0 |  | 0
OKRA | bag | 4 |  | 0 | 0 | 0 | 0 |  | 0
PRECOOKED EGG NOODLES | bag | 6 |  | 16 | 10 | 0 | 0 |  | 6.5
PEACH FILLING 10 pkgs | bag | 10 |  | 2 | 8 | 0 | 0 |  | 2.5
PEACHES | can | 6 |  | 3 | 4 | 0 | 0 |  | 1.75
PEARS | pkg | 8 |  | 2 | 9 | 0 | 0 |  | 2.75
PEAS | pkg | 12 |  | 0 | 0 | 0 | 0 |  | 0
PISTACHIO WHIP | case | 1 |  | 0 | 0 | 0 | 0 |  | 0
POWERRD SUGAR 10 bags | bag | 12 |  | 2 | 7 | 0 | 0 |  | 2.25
SLICED POTATOES | can | 6 |  | 0 | 0 | 0 | 0 |  | 0
SLICED YAMS | can | 6 |  | 0 | 0 | 0 | 0 |  | 0
STRAWBERRY WHIP | box | 1 |  | 0.4 | 0 | 0 | 0 |  | 0.1
[NAME] CORN | bag | 12 |  | 31 | 52 | 0 | 0 |  | 20.75
TWICED BAKED POTATO MIX | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0
VANILLA MOUSSE | box | 1 |  | 0 | 1 | 0 | 0 |  | 0.25
VANILLA PUDDING | can | 6 |  | 0 | 4 | 0 | 0 |  | 1
WHIP TOPPING | bag | 12 |  | 4 | 13 | 0 | 0 |  | 4.25
[NAME] SQUASH | bag | 4 |  | 0 | 0 | 0 | 0 |  | 0
CATEGORY 12 |  | count |  | Amounts Used by Week |  |  |  |  | Average
DRINKS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
PEPSI MAX | gallon | 5 |  | -0.5 | 9 | 0 | 0 |  | 2.125
COFFEE DECAF | bag | 42 |  | 14 | 27 | 0 | 0 |  | 10.25
COFFEE REGULAR | bag | 42 |  | 15 | 39 | 0 | 0 |  | 13.5
SWEET TEA | gallon | 5 |  | 2.75 | 6 | 0 | 0 |  | 2.1875
FRUIT PUNCH | gallon | 5 |  | -4 | 13 | 0 | 0 |  | 2.25
PEPSI | gallon | 5 |  | 8 | 12 | 0 | 0 |  | 5
DIET PEPSI | gallon | 5 |  | 6 | 12 | 0 | 0 |  | 4.5
MT DEW | gallon | 5 |  | 5.5 | 6 | 0 | 0 |  | 2.875
SIERRA MIST | gallon | 5 |  | 0 | 9 | 0 | 0 |  | 2.25
ROOT BEER | gallon | 5 |  | 2 | 5 | 0 | 0 |  | 1.75
DR PEPPER | gallon | 5 |  | 3.5 | 6 | 0 | 0 |  | 2.375
PINK LEMONADE | gallon | 5 |  | 2 | 8 | 0 | 0 |  | 2.5
CATEGORY 13 |  | count |  | Amounts Used by Week |  |  |  |  | Average
O FOODS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
BACON PRE DICED | bag | 2 |  | 4 | 14 | 0 | 0 |  | 4.5
BROWN GRAVY  - ONE STEP | bag | 45 |  | 67 | 131 | 0 | 0 |  | 49.5
FOOD SPRAY | can | 6 |  | 8 | 4 | 0 | 0 |  | 3
HOT SAUCE PKTS | case | 1 |  | 0 | 1 | 0 | 0 |  | 0.25
KETCHUP PKTS | case | 1 |  | 0 | 1 | 0 | 0 |  | 0.25
LEMON JUICE PACKETS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0
MAYONNAISE PACKETS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0
NON DAIRY CREAMER PKTS | case | 1 |  | 0.09999999999999998 | 0.4 | 0 | 0 |  | 0.125
PEPPER PKTS | case | 3 |  | 0.5 | 4 | 0 | 0 |  | 1.125
SALT PKTS | case | 3 |  | 0.5 | 4.5 | 0 | 0 |  | 1.25
SUGAR PKTS | case | 1 |  | 0 | 1 | 0 | 0 |  | 0.25
SWEET N LOW PKTS | case | 1 |  | 0 | 1 | 0 | 0 |  | 0.25
TRIPLE BLEND CHEESE | bag | 6 |  | 5 | 13 | 0 | 0 |  | 4.5
CAPRI SUN | each | 40 |  | 11 | 24 | 0 | 0 |  | 8.75
CATEGORY 14 |  | count |  | Amounts Used by Week |  |  |  |  | Average
POTATOES | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
POTATO WEDGES | bag | 6 |  | 27 | 36 | 0 | 0 |  | 15.75
MASHED POTATOES | each | 24 |  | 160 | 156 | 0 | 0 |  | 79
CATEGORY 15 |  | count |  | Amounts Used by Week |  |  |  |  | Average
PAPER | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
10" BLACK 3 COMP PLATE | sleeve | 4 |  | 0.7999999999999998 | 3.2 | 0 | 0 |  | 1
12 COFFEE CUP | sleeve | 40 |  | 0 | 41 | 0 | 0 |  | 10.25
12 LB [NAME] | bundle | 2 |  | 1 | 3 | 0 | 0 |  | 1
12 OZ COFFEE CUP LID | sleeve | 10 |  | 0 | 6.5 | 0 | 0 |  | 1.625
12 OZ DRINK CUP | sleeve | 20 |  | 1 | 10 | 0 | 0 |  | 2.75
16 OZ CUP | sleeve | 24 |  | 12 | 27 | 0 | 0 |  | 9.75
16 OZ FOAM CONTAINER | sleeve | 20 |  | 34 | 36 | 0 | 0 |  | 17.5
16/22 OZ LIDS | sleeve | 24 |  | 11 | 35 | 0 | 0 |  | 11.5
22 OZ CUP | sleeve | 24 |  | 7 | 41 | 0 | 0 |  | 12
32 OZ DRINK CUP LIDS | sleeve | 15 |  | 1 | 0 | 0 | 0 |  | 0.25
32 OZ PLASTIC CUP | sleeve | 20 |  | 2 | 2 | 0 | 0 |  | 1
4 CUP CARRIERS | case | 1 |  | 0.09999999999999998 | 0.8 | 0 | 0 |  | 0.225
4 LB [NAME] | bundle | 4 |  | 0.5 | 4.5 | 0 | 0 |  | 1.25
4 OZ CONICAL CUPS | box | 25 |  | 2 | 16 | 0 | 0 |  | 4.5
85 BUCKET | case | 1 |  | 0.75 | 1 | 0 | 0 |  | 0.4375
6 LB BUCKET LID | case | 1 |  | 0.3 | 0.7 | 0 | 0 |  | 0.25
64 OZ MEGA JUGS | sleeve | 5 |  | -1 | 9 | 0 | 0 |  | 2
8 LB BUCKET LID | case | 1 |  | 0.3 | 0.7 | 0 | 0 |  | 0.25
8 OZ FOAM CONTAINER | sleeve | 20 |  | 6 | 12 | 0 | 0 |  | 4.5
130 BUCKET | case | 1 |  | 0.95 | 0.3 | 0 | 0 |  | 0.3125
9" PAPER PLATE | sleeve | 4 |  | 2 | 9 | 0 | 0 |  | 2.75
BIG BOX | case | 1 |  | 0.2000000000000001 | 0.6 | 0 | 0 |  | 0.2
BOWL LIDS 16OZ | sleeve | 4 |  | 16.5 | 0.5 | 0 | 0 |  | 4.25
BOWLS 16OZ BLACK | sleeve | 4 |  | 7.5 | 10 | 0 | 0 |  | 4.375
CATERING CARTON | case | 1 |  | 0.7 | 1.1 | 0 | 0 |  | 0.45
CLAMSHELL - PAPER | sleve | 4 |  | 1 | 1.5 | 0 | 0 |  | 0.625
COFFEE STIRRER 5" | box | 1 |  | 0 | 0 | 0 | 0 |  | 0
DIVIDER FOR BUCKET | case | 1 |  | 0.1000000000000001 | 1.9 | 0 | 0 |  | 0.5
FORKS | case | 1 |  | 0.8999999999999999 | 1.9 | 0 | 0 |  | 0.7
KIDS MEAL BOXES | case | 1 |  | 0.4 | 0.6 | 0 | 0 |  | 0.25
KNIFES | case | 1 |  | 0.3 | 0.8 | 0 | 0 |  | 0.275
LARGE POPCORN CARTON | case | 1 |  | 0.05000000000000004 | 0.95 | 0 | 0 |  | 0.25
NAPKINS | bag | 12 |  | 13 | 16 | 0 | 0 |  | 7.25
NON-VENTED LIDS | sleeve | 10 |  | 2 | 6 | 0 | 0 |  | 2
PAN - HALF SIZE | each | 100 |  | 0 | 84 | 0 | 0 |  | 21
PAN- FULL SIZE | each | 50 |  | 1 | 17 | 0 | 0 |  | 4.5
PARTY POPCORN CARTON | case | 1 |  | 0.1 | 0 | 0 | 0 |  | 0.025
PREPAK'S | case | 1 |  | 1 | 1.9 | 0 | 0 |  | 0.725
SMALL FRY WEDGE CARTON | sleeve | 16 |  | 4 | 11 | 0 | 0 |  | 3.75
SMALL POPCORN CARTON | case | 1 |  | 0.2 | 1 | 0 | 0 |  | 0.3
SNACK CARTON | case | 1 |  | 1.5 | 0.75 | 0 | 0 |  | 0.5625
SPOONS WRAPPED | case | 1 |  | 0.8 | 1 | 0 | 0 |  | 0.45
STAIN LINERS | box | 12 |  | 2 | 20 | 0 | 0 |  | 5.5
[NAME] | sleeve | 2 |  | 1.25 | 3.25 | 0 | 0 |  | 1.125
STRAWS | bag | 12 |  | 3 | 14 | 0 | 0 |  | 4.25
SUPER BOX | case | 1 |  | 0.75 | 1 | 0 | 0 |  | 0.4375
TRAYLINERS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0
T-SHIRT BAGS | case | 1 |  | 0.6500000000000001 | 1.7 | 0 | 0 |  | 0.5875
VENTED LIDS | sleeve | 10 |  | 8.5 | 16 | 0 | 0 |  | 6.125
WET NAPS | case | 1 |  | 0 | 1 | 0 | 0 |  | 0.25
4.6 oz CONTAINER | sleeve | 40 |  | 20 | 10 | 0 | 0 |  | 7.5
LID  FOR 4.6oz CONTAINER | sleeve | 20 |  | 9.5 | 7.5 | 0 | 0 |  | 4.25
CATEGORY 16 |  | count |  | Amounts Used by Week |  |  |  |  | Average
STRIPS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Per Wk
[NAME] POPCORN CHKN | pound | 40 |  | 212 | 48 | 0 | 0 |  | 65
CRISPY STRIPS | pound | 40 |  | 94 | 92 | 0 | 0 |  | 46.5
HBBQ CUPS | tray | 8 |  | 5 | 4 | 0 | 0 |  | 2.25
HONEY MUSTARD CUPS | tray | 6 |  | 2 | 6 | 0 | 0 |  | 2
RANCH SAUCE CUPS | tray | 6 |  | 1 | 7 | 0 | 0 |  | 2
SWEET & SOUR CUPS | tray | 8 |  | -2.5 | 3.5 | 0 | 0 |  | 0.25