Spreadsheet: 140471d1328761758-averaging-weeks-before-all-weeks-are-complete-inventory
Sheet: Period Totals

PERIOD | Inventory Summary Report
2
Celina
CATEGORY 1 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
CHICKEN | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
PURPLE 8PC CUT | head | 18 |  | 170 | 56 | 0 | 0 |  | 226 | 18.66666666666667
[NAME] | head | 16 |  | 48 | 0 | 0 | 0 |  | 48 | 0
DARK MEAT CHICKEN | head | 21 |  | 42 | 0 | 0 | 0 |  | 42 | 0
CATEGORY 2 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
LIV & GIZ | count | per bag |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
5LB BAG OF GIZZARDS | pound | 5 |  | 40 | 0 | 0 | 0 |  | 40 | 0
5LB BAG OF LIVERS | pound | 5 |  | 40 | 0 | 0 | 0 |  | 40 | 0
CATEGORY 3 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
[NAME] | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
[NAME] PATTIES 40/4OZ | each | 40 |  | 80 | 0 | 0 | 0 |  | 80 | 0
WHITE GRAVY | each | 48 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATEGORY 4 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
WINGS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
HOT WINGS | pound | 40 |  | 40 | 0 | 0 | 0 |  | 40 | 0
CATEGORY 5 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
SANDWICH | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
PAPER SNACK WRAP | sleeve | 2 |  | 0 | 0 | 0 | 0 |  | 0 | 0
MULTIPURPOSE BAGS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SNACKER BUNS | box | 12 |  | 12 | 0 | 0 | 0 |  | 12 | 0
KFC CHICKEN BREAST FILET | pound | 40 |  | 0 | 0 | 0 | 0 |  | 0 | 0
COLONELS SPECIAL SAUCE | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
[NAME] | each | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
[NAME] | each | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
YUM QUILT WRAP | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
HAWIIAN BUNS | pkg | 8 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATEGORY 6 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
SHORTENING | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
SHORTNENING 35LBS | case | 1 |  | 2 | 0 | 0 | 0 |  | 2 | 0
CATEGORY 7 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
SEASONINGS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
BREADING FLOUR | bag | 2 |  | 4 | 0 | 0 | 0 |  | 4 | 0
BREADING SALT | box | 12 |  | 2 | 0 | 0 | 0 |  | 2 | 0
GRILLED SEASONING | each | 36 |  | 36 | 0 | 0 | 0 |  | 36 | 0
CRISPY SEASONING | each | 12 |  | 12 | 0 | 0 | 0 |  | 12 | 0
MILK AND EGG MIX | each | 48 |  | 0 | 0 | 0 | 0 |  | 0 | 0
NEW MILK AND EGG MIX | each | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
ORGINAL RECIPIE SEASONING | each | 16 |  | 16 | 0 | 0 | 0 |  | 16 | 0
CATEGORY 8 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
[NAME] | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
COLE SLAW DRESSING | bag | 8 |  | 8 | 0 | 0 | 0 |  | 8 | 0
GREEN BEANS | can | 6 |  | 6 | 0 | 0 | 0 |  | 6 | 0
MACARONI AND CHEESE | tin | 6 |  | 12 | 0 | 0 | 0 |  | 12 | 0
MACARONI SALAD | box | 3 |  | 3 | 0 | 0 | 0 |  | 3 | 0
POTATO SALAD | box | 3 |  | 3 | 0 | 0 | 0 |  | 3 | 0
PRECHOP CABBAGE W O AND C | box | 1 |  | 3 | 0 | 0 | 0 |  | 3 | 0
PREPARED COLE SLAW | gallon | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SLICED CARRORTS | case | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
STABILIZER MIX | bag | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
VEGETABLE SEASONING | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATEGORY 9 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
BISCUITS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
BISCUIT LINERS | sleeve | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
BISCUITS | case | 1 |  | 4 | 0 | 0 | 0 |  | 4 | 0
BUTTER ALTERNATIVE | jug | 2 |  | 2 | 0 | 0 | 0 |  | 2 | 0
GRAPE JELLY PKTS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
HONEY SAUCE PKTS | case | 1 |  | 1 | 0 | 0 | 0 |  | 1 | 0
MARGARINE PACKETS | box | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATEGORY 10 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
DESSERTS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
CHOCOLATE CHIP CAKES | each | 18 |  | 0 | 0 | 0 | 0 |  | 0 | 0
COOKIE DOUGH | each | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
OREO COOKIE CREAM PIE | each | 24 |  | 0 | 0 | 0 | 0 |  | 0 | 0
REESES PEANUT BCUP PIE | each | 24 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATEGORY 11 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
BUFFET | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
6" WHITE PLATE 8 sleeves | sleeve | 8 |  | 0 | 0 | 0 | 0 |  | 0 | 0
9" WHITE BUFFET PLATE | sleeve | 4 |  | 8 | 0 | 0 | 0 |  | 8 | 0
APPLE FILLING 10 pkgs | pkg | 10 |  | 0 | 0 | 0 | 0 |  | 0 | 0
APPLESAUCE | can | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
ASSORTED RED GELATIN | pkg | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
BANANA PUDDING | can | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
BROCCOLI CUTS FROZEN | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CHEESE SAUCE | pkg | 16 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CHERRY FILLING 10 pkgs | pkg | 10 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CHICKEN SOUP MIX | pkg | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CHOCOLATE MOUSSE | box | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CHOCOLATE PUDDING | can | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CINNANON DESSERT MIX | bag | 8 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CLUB CRACKERS | bag | 2 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CREAM CHICKEN BASE | bag | 16 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CRUMB TOPPING | tub | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
GRAM CRACKER CRUST | box | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
[NAME] | each | 16 |  | 0 | 0 | 0 | 0 |  | 0 | 0
KEY LIME MIX | bag | 8 |  | 0 | 0 | 0 | 0 |  | 0 | 0
LEMON PUDDING CAKE | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
LIGHT BROWN SUGAR | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
ORTH BAKED CRISP TOPPING | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
OKRA | bag | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
PRECOOKED EGG NOODLES | bag | 6 |  | 6 | 0 | 0 | 0 |  | 6 | 0
PEACH FILLING 10 pkgs | bag | 10 |  | 0 | 0 | 0 | 0 |  | 0 | 0
PEACHES - SLICED | can | 6 |  | 6 | 0 | 0 | 0 |  | 6 | 0
PEARS | pkg | 8 |  | 0 | 0 | 0 | 0 |  | 0 | 0
PEAS | pkg | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
POWERRD SUGAR 10 bags | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SLICED POTATOES | can | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SLICED YAMS | can | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
STRAWBERRY WHIP | box | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
[NAME] CORN | bag | 12 |  | 12 | 0 | 0 | 0 |  | 12 | 0
TWICED BAKED POTATO MIX | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
VANILLA MOUSSE | box | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
VANILLA PUDDING | can | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
WHIP TOPPING | bag | 1 |  | 11 | 0 | 0 | 0 |  | 11 | 0
[NAME] SQUASH | bag | 4 |  | 0 | 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 |  | Totals | Totals
PEPSI MAX | gallon | 5 |  | 0 | 0 | 0 | 0 |  | 0 | 0
COFFEE DECAF | bag | 42 |  | 42 | 0 | 0 | 0 |  | 42 | 0
COFFEE REGULAR | bag | 42 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SWEET TEA | gallon | 5 |  | 0 | 0 | 0 | 0 |  | 0 | 0
FRUIT PUNCH | gallon | 5 |  | 0 | 0 | 0 | 0 |  | 0 | 0
PEPSI | gallon | 5 |  | 10 | 0 | 0 | 0 |  | 10 | 0
DIET PEPSI | gallon | 5 |  | 5 | 0 | 0 | 0 |  | 5 | 0
MT DEW | gallon | 5 |  | 5 | 0 | 0 | 0 |  | 5 | 0
SIERRA MIST | gallon | 5 |  | 0 | 0 | 0 | 0 |  | 0 | 0
ROOT BEER | gallon | 5 |  | 0 | 0 | 0 | 0 |  | 0 | 0
DR PEPPER | gallon | 5 |  | 0 | 0 | 0 | 0 |  | 0 | 0
PINK LEMONADE | gallon | 5 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATEGORY 13 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
O FOODS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
BACON PRE DICED | bag | 2 |  | 0 | 0 | 0 | 0 |  | 0 | 0
BROWN GRAVY  - ONE STEP | bag | 45 |  | 45 | 0 | 0 | 0 |  | 45 | 0
WHITE CAP BAKE RELEASE | can | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
HOT SAUCE PKTS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
KETCHUP PKTS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
LEMON JUICE PACKETS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
MAYONNAISE PACKETS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
NON DAIRY CREAMER PKTS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
PEPPER PKTS | case | 3 |  | 0 | 0 | 0 | 0 |  | 0 | 0
POT PIE BASE | tin | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
POT PIE CRUST | each | 48 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SALT PKTS | case | 3 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SUGAR PKTS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SWEET N LOW PKTS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
TRIPLE BLEND CHEESE | bag | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CAPRI SUN | each | 40 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATEGORY 14 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
POTATOES | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
POTATO WEDGES | bag | 6 |  | 12 | 0 | 0 | 0 |  | 12 | 0
BASIC POTATOES | each | 24 |  | 96 | 0 | 0 | 0 |  | 96 | 0
CATEGORY 15 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
PAPER | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
10" BLACK 3 COMP PLATE | sleeve | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
12 COFFEE CUP | sleeve | 40 |  | 0 | 0 | 0 | 0 |  | 0 | 0
12 LB [NAME] | bundle | 2 |  | 0 | 0 | 0 | 0 |  | 0 | 0
12 OZ COFFEE CUP LID | sleeve | 10 |  | 0 | 0 | 0 | 0 |  | 0 | 0
12 OZ DRINK CUP | sleeve | 20 |  | 0 | 0 | 0 | 0 |  | 0 | 0
16 OZ CUP | sleeve | 24 |  | 0 | 0 | 0 | 0 |  | 0 | 0
16 OZ FOAM CONTAINER | sleeve | 20 |  | 20 | 0 | 0 | 0 |  | 20 | 0
16/22 OZ LIDS | sleeve | 24 |  | 0 | 0 | 0 | 0 |  | 0 | 0
22 OZ CUP | sleeve | 24 |  | 0 | 0 | 0 | 0 |  | 0 | 0
30 OZ DRINK CUP LIDS | sleeve | 15 |  | 0 | 0 | 0 | 0 |  | 0 | 0
30 OZ PLASTIC CUP | sleeve | 20 |  | 0 | 0 | 0 | 0 |  | 0 | 0
4 CUP CARRIERS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
4 LB [NAME] | bundle | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CONE CUP 4 OZ | box | 25 |  | 0 | 0 | 0 | 0 |  | 0 | 0
85 BUCKET | case | 1 |  | 2 | 0 | 0 | 0 |  | 2 | 0
6 LB BUCKET LID | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
64 OZ MEGA JUGS | sleeve | 5 |  | 0 | 0 | 0 | 0 |  | 0 | 0
8 LB BUCKET LID | case | 1 |  | 1 | 0 | 0 | 0 |  | 1 | 0
8 OZ FOAM CONTAINER | sleeve | 20 |  | 0 | 0 | 0 | 0 |  | 0 | 0
130 BUCKET | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
8.5" WHITE PLATE SOLO | sleeve | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
BIG BOX | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
BOWL LIDS 16OZ | sleeve | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
BOWLS 16OZ BLACK | sleeve | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATERING CARTON | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CLAMSHELL - PAPER | sleve | 4 |  | 0 | 0 | 0 | 0 |  | 0 | 0
COFFEE STIRRER 5" | box | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
DIVIDER FOR BUCKET | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
FILET BITES SMALL CONT. | sleeve | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
FILET BITES LARGE CONT. | sleeve | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
FORKS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
KIDS SUPERBOX | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
KNIFES | case | 1 |  | 1 | 0 | 0 | 0 |  | 1 | 0
LARGE POPCORN CARTON | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
DISPENSER NAPKIN | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
NON-VENTED LIDS | sleeve | 10 |  | 0 | 0 | 0 | 0 |  | 0 | 0
HALF SIZE STEAM PAN | each | 100 |  | 0 | 0 | 0 | 0 |  | 0 | 0
FULL SIZE STEAM PAN | each | 50 |  | 0 | 0 | 0 | 0 |  | 0 | 0
PARTY POPCORN CARTON | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
PREPAK'S | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
POT PIE CARTON | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
POT PIE TINS | each | 500 |  | 0 | 0 | 0 | 0 |  | 0 | 0
MEDIUM FRY WEDGE | sleeve | 16 |  | 16 | 0 | 0 | 0 |  | 16 | 0
SMALL POPCORN CARTON | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SNACK CARTON | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
TEASPOON WRAPPED | case | 1 |  | 1 | 0 | 0 | 0 |  | 1 | 0
STAIN LINERS | box | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
[NAME] | sleeve | 2 |  | 0 | 0 | 0 | 0 |  | 0 | 0
STRAWS | bag | 12 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SUPER BOX | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
TRAYLINERS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
T-SHIRT BAGS | case | 1 |  | 1 | 0 | 0 | 0 |  | 1 | 0
VENTED LIDS | sleeve | 10 |  | 0 | 0 | 0 | 0 |  | 0 | 0
WET NAPS | case | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
4.6 oz CONTAINER | sleeve | 40 |  | 0 | 0 | 0 | 0 |  | 0 | 0
LID  FOR 4.6oz CONTAINER | sleeve | 20 |  | 0 | 0 | 0 | 0 |  | 0 | 0
CATEGORY 16 |  | count |  | Amounts Used by Week |  |  |  |  |  | Average
STRIPS | count | per case |  | Week 1 | Week 2 | Week 3 | Week 4 |  | Totals | Totals
DICED [NAME] FRITTERS | pound | 40 |  | 40 | 0 | 0 | 0 |  | 40 | 0
CRISPY STRIPS | pound | 40 |  | 40 | 0 | 0 | 0 |  | 40 | 0
FILET BITES | 0 | 1 |  | 0 | 0 | 0 | 0 |  | 0 | 0
HBBQ CUPS | tray | 8 |  | 0 | 0 | 0 | 0 |  | 0 | 0
HONEY MUSTARD CUPS | tray | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
RANCH SAUCE CUPS | tray | 6 |  | 0 | 0 | 0 | 0 |  | 0 | 0
SWEET & SOUR CUPS | tray | 8 |  | 0 | 0 | 0 | 0 |  | 0 | 0