Spreadsheet: 269505d1381177292-dynamic-file-paths-help-collated-report-2262-vancouver-mall-dr-vancouver-wa-week-35-2013
Sheet: Inventory

INVENTORY (V2)
Week Ending: | 2013-09-03 00:00:00
Adjusted Sales: | 4088.21
Store Location: | 2262 - Vancouver Mall Dr, Vancouver, WA
Store #: | 2262
Item | Units OF | BI |  | Unit Purchases |  |  | Total | On Hand | EI | Unit | EI | Usage
 | Measure | Units | 1 | 2 | 3 | 4 | Purc | Counts | Units | Cost | $'s | Units
Bread 4311
Mini Loaf | ea | 1459 | 0 | 0 | 0 | 0 | 0 |  | 1154 | 0.4094 | 472.4476 | 305
Wheat | ea | 81.333333 | 0 | 0 | 0 | 0 | 0 |  | 78 | 1.3131 | 102.4218 | 3.333332999999996
Beginning Inventory $'s |  | 704.1134000000001 | Purchases $'s |  | 0 | Ending Inventory $'s |  | 574.8694 | COS $'s | 129.244 | COS % | 0.03161383588416447
Item | Units OF | BI |  | Unit Purchases |  |  | Total | On Hand | EI | Unit | EI | Usage
 | Measure | Units | 1 | 2 | 3 | 4 | Purc | Counts | Units | Cost | $'s | Units
Food 4312
Capicola | lb | 74.70050223945553 | 0 | 0 | 0 | 0 | 0 |  | 66.83 | 4 | 267.32 | 7.870502239455533
[NAME] | lb | 76.67580209015847 | 0 | 0 | 0 | 0 | 0 |  | 69.33 | 2.510999567286889 | 174.0876 | 7.345802090158472
Ham | lb | 214.9020866310811 | 0 | 0 | 0 | 0 | 0 |  | 185.1 | 2.231299837925446 | 413.0136 | 29.80208663108115
Turkey | lb | 155.732858830968 | 0 | 0 | 0 | 0 | 0 |  | 118.79 | 2.8 | 332.612 | 36.94285883096801
Beef | lb | 118.6587061864352 | 0 | 0 | 0 | 0 | 0 |  | 104.3 | 4.226200383509108 | 440.7927 | 14.3587061864352
Bacon | ea | 1809 | 0 | 0 | 0 | 0 | 0 |  | 1369 | 0.16 | 219.04 | 440
Cheese | lb | 140.7593630316557 | 0 | 0 | 0 | 0 | 0 |  | 108.25 | 2.2528 | 243.8656 | 32.50936303165565
Cut Vito | lb | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Mayonnaise | gal mayo | 38.94534598214285 | 0 | 0 | 0 | 0 | 0 |  | 35.5 | 9.35 | 331.925 | 3.445345982142847
Oil | gal oil | 11.85664523670368 | 0 | 0 | 0 | 0 | 0 |  | 11.52 | 1.63 | 18.7776 | 0.3366452367036814
Vinegar | gal vinegar | 3.6898127925117 | 0 | 0 | 0 | 0 | 0 |  | 3.57 | 5.04 | 17.9928 | 0.1198127925117003
Avocado | avo can | 47.27955357142857 | 0 | 0 | 0 | 0 | 0 |  | 44.13 | 3.25 | 143.4225 | 3.149553571428569
Peppers Cherry | Gal Peppers | 15.98604120002116 | 0 | 0 | 0 | 0 | 0 |  | 14.7 | 7.44 | 109.368 | 1.286041200021165
[NAME] | jar dijon | 16.72588235294118 | 0 | 0 | 0 | 0 | 0 |  | 16.59 | 5.13 | 85.1067 | 0.1358823529411772
[NAME] | gal soy | 3.98995487364621 | 0 | 0 | 0 | 0 | 0 |  | 3.93 | 0 | 0 | 0.05995487364620944
Tuna | can tuna | 17.46253490870032 | 0 | 0 | 0 | 0 | 0 |  | 16 | 9.45 | 151.2 | 1.462534908700324
Pam Spray | ea | 5.87 | 0 | 0 | 0 | 0 | 0 |  | 5.87 | 2.6 | 15.262 | 0
Salt (round) | cont salt | 0.96 | 0 | 0 | 0 | 0 | 0 |  | 0.96 | 0 | 0 | 0
Oregano | cont oregano | 3 | 0 | 0 | 0 | 0 | 0 |  | 3 | 19.65 | 58.95 | 0
Basil | cont basil | 6 | 0 | 0 | 0 | 0 | 0 |  | 6 | 4.76 | 28.56 | 0
Sugar | lb | 19.8 | 0 | 0 | 0 | 0 | 0 |  | 19.8 | 0 | 0 | 0
Mayo Packets | Box 204 | 1.949803921568627 | 0 | 0 | 0 | 0 | 0 |  | 1.94 | 0 | 0 | 0.009803921568627416
Lt Mayo Packets | Box 204 | 2 | 0 | 0 | 0 | 0 | 0 |  | 2 | 18.1862 | 36.3724 | 0
[NAME] | Box 200 | 0.85 | 0 | 0 | 0 | 0 | 0 |  | 0.85 | 5.13 | 4.3605 | 0
Mustard Packets | Box 500 | 1.964 | 0 | 0 | 0 | 0 | 0 |  | 1.96 | 20.89 | 40.9444 | 0.004000000000000004
Sugar Packets | Case  3000 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Sweet n Low Packets | Case  3000 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Beginning Inventory $'s |  | 3624.941699999999 | Purchases $'s |  | 0 | Ending Inventory $'s |  | 3132.973399999999 | COS $'s | 491.9683 | COS % | 0.1203383143233836
Item | Units OF | BI |  | Unit Purchases |  |  | Total | On Hand | EI | Unit | EI | Usage
 | Measure | Units | 1 | 2 | 3 | 4 | Purc | Counts | Units | Cost | $'s | Units
Sides 4313
Pickles | ea | 200 | 0 | 0 | 0 | 0 | 0 |  | 182 | 0.26 | 47.32 | 18
[NAME] | ea | 219 | 0 | 0 | 0 | 0 | 0 |  | 162 | 0.35 | 56.7 | 57
Chip JJ BBQ | ea | 107 | 0 | 0 | 0 | 0 | 0 |  | 80 | 0.35 | 28 | 27
[NAME] | ea | 170 | 0 | 0 | 0 | 0 | 0 |  | 156 | 0.35 | 54.60000000000001 | 14
Chip JJ S&V | ea | 166 | 0 | 0 | 0 | 0 | 0 |  | 152 | 0.35 | 53.2 | 14
Chip JJ Skinny | ea | 107 | 0 | 0 | 0 | 0 | 0 |  | 105 | 0.42 | 44.1 | 2
Cookie JJ Triple Choc Chip | ea | 212 | 0 | 0 | 0 | 0 | 0 |  | 193 | 0.55 | 106.15 | 19
Cookie Oatmeal Raisin | ea | 173 | 0 | 0 | 0 | 0 | 0 |  | 167 | 0.51 | 85.17 | 6
Beginning Inventory $'s |  | 533.47 | Purchases $'s |  | 0 | Ending Inventory $'s |  | 475.2400000000001 | COS $'s | 58.22999999999996 | COS % | 0.01424339747713546
Item | Units OF | BI |  | Unit Purchases |  |  | Total | On Hand | EI | Unit | EI | Usage
 | Measure | Units | 1 | 2 | 3 | 4 | Purc | Counts | Units | Cost | $'s | Units
Paper 4314
22oz Promotional Cups and Lids | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Cup Plas 12oz Trans Soft - Paper Cat | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Cup 22oz JJ | ea | 1937 | 0 | 0 | 0 | 0 | 0 |  | 1781 | 0.03 | 53.43 | 156
Lid 22oz JJ | ea | 329 | 0 | 0 | 0 | 0 | 0 |  | 173 | 0.01 | 1.73 | 156
Cup 30oz JJ | ea | 745 | 0 | 0 | 0 | 0 | 0 |  | 692 | 0.06 | 41.52 | 53
Lid 30oz JJ | ea | 992 | 0 | 0 | 0 | 0 | 0 |  | 939 | 0.02 | 18.78 | 53
[NAME] | Pack 567 | 10.6 | 0 | 0 | 0 | 0 | 0 |  | 10.6 | 1.44 | 15.264 | 0
[NAME] 8# JJ | Box 1000 | 1.474 | 0 | 0 | 0 | 0 | 0 |  | 0.9 | 36.91 | 33.219 | 0.5740000000000004
Wrap Sandwich | Box 1000 | 5.86 | 0 | 0 | 0 | 0 | 0 |  | 5.3 | 19.09 | 101.177 | 0.5600000000000005
[NAME]. | Box 500 | 32.07599999999999 | 0 | 0 | 0 | 0 | 0 |  | 29.75 | 4.09 | 121.6775 | 2.325999999999986
Straws | Box 300 | 23.44666666666667 | 0 | 0 | 0 | 0 | 0 |  | 22.75 | 1.866 | 42.4515 | 0.418000000000001
Pan Liners | Box 1000 | 0.8 | 0 | 0 | 0 | 0 | 0 |  | 0.8 | 26.96 | 21.568 | 0
Mylar | roll 5280 | 0.8 | 0 | 0 | 0 | 0 | 0 |  | 0.8 | 49.5 | 39.6 | 0
Bag Plas Party Tray | Box 50 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Cup Foam 12oz | each | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
[NAME] | Roll | 0.6060000000000004 | 0 | 0 | 0 | 0 | 0 |  | 0 | 5.25 | 0 | 0.6060000000000004
Beginning Inventory $'s |  | 546.7899 | Purchases $'s |  | 0 | Ending Inventory $'s |  | 490.417 | COS $'s | 56.37289999999996 | COS % | 0.01378913999036252
Item | Units OF | BI |  | Unit Purchases |  |  | Total | On Hand | EI | Unit | EI | Usage
 | Measure | Units | 1 | 2 | 3 | 4 | Purc | Counts | Units | Cost | $'s | Units
Produce 4315
Lettuce | Head Let | 80.34698925952556 | 72 | 0 | 0 | 0 | 72 |  | 123 | 0.7896 | 97.1208 | 29.34698925952557
Tomatoes | lb | 67.99019251645296 | 75 | 0 | 0 | 0 | 75 |  | 116.5 | 0.9089004291845494 | 105.8869 | 26.49019251645296
Onions | lb | 42.35134296782751 | 0 | 0 | 0 | 0 | 0 |  | 33.25 | 0.23 | 7.6475 | 9.101342967827506
Celery | stalk | 4.69635761589404 | 2 | 0 | 0 | 0 | 2 |  | 5.25 | 1.03 | 5.4075 | 1.44635761589404
Cucumbers | ea | 45.80535616340352 | 0 | 0 | 0 | 0 | 0 |  | 39 | 0.6097 | 23.7783 | 6.805356163403516
Beginning Inventory $'s |  | 158.7631 | Purchases $'s |  | 126.41 | Ending Inventory $'s |  | 239.841 | COS $'s | 45.33209999999997 | COS % | 0.0110884959432123
Item | Units OF | BI |  | Unit Purchases |  |  | Total | On Hand | EI | Unit | EI | Usage
 | Measure | Units | 1 | 2 | 3 | 4 | Purc | Counts | Units | Cost | $'s | Units
Beverage 4316
Cans Soda | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Coke (can) | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Diet Coke (can) | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Dr. [NAME] (12oz Can) | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Sprite (can) | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Syrup Coke | gal | 8.052734375 | 0 | 0 | 0 | 0 | 0 |  | 8 | 12.24 | 97.92 | 0.052734375
Syrup Diet Coke | gal | 8 | 0 | 0 | 0 | 0 | 0 |  | 8 | 12.24 | 97.92 | 0
Syrup Lemonade Light | gal | 3.75 | 0 | 0 | 0 | 0 | 0 |  | 3.75 | 12.24 | 45.9 | 0
Syrup Sprite | gal | 9 | 0 | 0 | 0 | 0 | 0 |  | 9 | 12.24 | 110.16 | 0
Syrup Dr. Pepper | gal | 7.521484375 | 0 | 0 | 0 | 0 | 0 |  | 7.5 | 12.24 | 91.8 | 0.021484375
[NAME] | gal | 8.75 | 0 | 0 | 0 | 0 | 0 |  | 8.75 | 12.73 | 111.3875 | 0
Syrup Root Beer | gal | 1.79296875 | 0 | 0 | 0 | 0 | 0 |  | 1.75 | 12.24 | 21.42 | 0.04296875
FUZE Tea Iced Conc Rasp 5.5+1 | gal | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 12.24 | 0 | 0
[NAME] | ea | 20 | 0 | 0 | 0 | 0 | 0 |  | 20 | 0 | 0 | 0
Water (bottle) | bottle | 75 | 0 | 0 | 0 | 0 | 0 |  | 72 | 0 | 0 | 3
CO2 Tank - Beverage | tank | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Beginning Inventory $'s |  | 577.9419 | Purchases $'s |  | 0 | Ending Inventory $'s |  | 576.5074999999999 | COS $'s | 1.434400000000096 | COS % | 0.0003508626024592905
Item | Units OF | BI |  | Unit Purchases |  |  | Total | On Hand | EI | Unit | EI | Usage
 | Measure | Units | 1 | 2 | 3 | 4 | Purc | Counts | Units | Cost | $'s | Units
Catering 4320
Pickle Container | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
JJ [NAME] | ea | 125 | 0 | 0 | 0 | 0 | 0 |  | 125 | 0.29 | 36.25 | 0
[NAME] 12" w / dome lid | each | 25 | 0 | 0 | 0 | 0 | 0 |  | 24 | 0.9199999999999999 | 22.08 | 1
[NAME] 16" w / dome lid | each | 25 | 0 | 0 | 0 | 0 | 0 |  | 25 | 1.73 | 43.25 | 0
Party [NAME] | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Pickle Container w/Lid | ea | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0.24 | 0 | 0
Beginning Inventory $'s |  | 102.5 | Purchases $'s |  | 0 | Ending Inventory $'s |  | 101.58 | COS $'s | 0.9200000000000017 | COS % | 0.0002250373635405231
Additional Discounts/Charges |  |  |  |  | 3 |  |  |  |  |  | COS % | 0.000733817489806052
 |  |  |  |  |  | SubTotal COS $'s |  |  |  | 783.5016999999992
 |  |  |  |  |  | SubTotal COS % |  |  |  | 0.1916490835842579
 |  |  |  |  |  | Total With Discounts/Charges COS $'s |  |  |  | 786.5016999999992
 |  |  |  |  |  | Total With Discounts/Charges COS % |  |  |  | 0.192382901074064