Spreadsheet: 788509d1658503815-inventory-control-spreadsheet-excel-demo
Sheet: Inventory

 | Product Name | Description | Size | Color |  | Quantity of Items after this order |  | Reorder Point | Cost Price | [NAME] | Retail Price | Total # Orders | Orders waiting to be fufilled | Stock waiting to be received | Stock on hand
 | Airplane (Foam Super Glider) |  |  |  | 10 |  |  |  | 2
 | Backpack (Ladies Grey w/ Buttons) |  |  |  | 15 |  |  |  | 75 |  | 2
 | Backpack (Black & Grey) |  |  |  | 15 |  |  |  | 25 |  | 2
 | Backpack (Men's Black) |  |  |  | 15 |  |  |  | 75 |  | 2
 | Balloons (Green, White, Black) |  |  |  | 10 |  |  |  | 1 |  | 2
 | Beach Ball |  |  |  | 5 |  |  |  | 2 |  | 2
 | Binoculars |  |  |  | 6 |  |  |  | 6 |  | 2
 | Binoculars (Cardboard) |  |  |  | 7 |  |  |  | 2 |  | 2
 | Blanket |  |  |  | 8 |  |  |  | 26 |  | 2
 | Business Card Holder (Black) |  |  |  | 9 |  |  |  | 8 |  | 2
 | [NAME] |  |  |  | 5 |  |  |  | 2 |  | 2
 | [NAME] ([NAME]) |  |  |  |  |  |  |  | 15 |  | 2
 | Cell Buckle |  |  |  |  |  |  |  | 3 |  | 2
 | Cell [NAME] |  |  |  |  |  |  |  | 3 |  | 2
 | Cell Mount ( Clip-it Vent) |  |  |  |  |  |  |  | 4 |  | 2
 | Cell Phone Cover (Waterproof) |  |  |  |  |  |  |  | 3 |  | 2
 | Cell Suction Holder |  |  |  |  |  |  |  | 5 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 8 |  | 2
 | Cleaning Cloth |  |  |  |  |  |  |  | 2 |  | 2
 | Coaster ( Black Leather - Each) |  |  |  |  |  |  |  | 4 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 9 |  | 2
 | [NAME] (6-pack) |  |  |  |  |  |  |  | 12 |  | 2
 | [NAME] (Insulated Large) |  |  |  |  |  |  |  | 50 |  | 2
 | Cup (Large) |  |  |  |  |  |  |  | 2 |  | 2
 | [NAME] ( High End w/Mesh) |  |  |  |  |  |  |  | 8 |  | 2
 | [NAME] ( Clear Plastic) |  |  |  |  |  |  |  | 5 |  | 2
 | [NAME] (Black or Gray Cloth) |  |  |  |  |  |  |  | 5 |  | 2 |  |  |  |  |  |  |  | (T8=Orders!B16,F8-Orders!C16,")")
 | Earbuds |  |  |  |  |  |  |  | 5 |  | 2
 | Folder (Gusset) |  |  |  |  |  |  |  | 2 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 0.5 |  | 2 |  |  |  |  |  |  |  | IF(Orders!B16="","",(HLOOKUP(Orders!B16,Data3[[DESCRIPTION]:[QUANTITY]],1,FALSE)))
 | Folder - Green Pocket Glossy Letter |  |  |  |  |  |  |  | 1 |  | 2
 | Folder - Green Pocket Matte Letter |  |  |  |  |  |  |  | 1 |  | 2
 | Folder - White Pocket Glossy Legal |  |  |  |  |  |  |  | 2 |  | 2
 | Folder - White Pocket Glossy Letter |  |  |  |  |  |  |  | 2 |  | 2
 | Frisbee ([NAME]) |  |  |  |  |  |  |  | 2 |  | 2
 | Frisbee Hard Style (Grey) |  |  |  |  |  |  |  | 2 |  | 2
 | Football |  |  |  |  |  |  |  | 3 |  | 2
 | [NAME] (White Paper) |  |  |  |  |  |  |  | 2 |  | 2
 | Golf Balls (Callaway HEX per sleeve) |  |  |  |  |  |  |  | 10 |  | 2
 | [NAME] (Grey) |  |  |  |  |  |  |  | 6 |  | 2
 | [NAME] (Green) |  |  |  |  |  |  |  | 4 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 5 |  | 2
 | Hand [NAME] (1/2 oz. Bottle) |  |  |  |  |  |  |  | 2 |  | 2
 | Hand [NAME] (2 oz. Bottle) |  |  |  |  |  |  |  | 4 |  | 2
 | Key Carabiner |  |  |  |  |  |  |  | 3 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 1 |  | 2
 | Koozie |  |  |  |  |  |  |  | 3 |  | 2
 | Lanyard |  |  |  |  |  |  |  | 2 |  | 2
 | Laptop bag |  |  |  |  |  |  |  | 8 |  | 2
 | Laptop Bag (Black_ |  |  |  |  |  |  |  | 26 |  | 2
 | Laptop Bag (Foam Black) |  |  |  |  |  |  |  | 6 |  | 2
 | Laptop Bag (New Gray) |  |  |  |  |  |  |  | 18 |  | 2
 | Laptop Bag ( Leather) |  |  |  |  |  |  |  | 100 |  | 2
 | [NAME] (Ball) |  |  |  |  |  |  |  | 2 |  | 2
 | [NAME] (Regular) |  |  |  |  |  |  |  | 2 |  | 2
 | Light Bar |  |  |  |  |  |  |  | 3 |  | 2
 | Luggage Tag |  |  |  |  |  |  |  | 3 |  | 2
 | Magnetic Clip (White and Black) |  |  |  |  |  |  |  | 2 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 2 |  | 2
 | Note Pad (Small, Medium, Large) |  |  |  |  |  |  |  | 1 |  | 2
 | Note Book (Spiral 3x5) |  |  |  |  |  |  |  | 2 |  | 2
 | Note Book (Spiral 6x9) |  |  |  |  |  |  |  | 7 |  | 2
 | Note Pad (Black Cover with Pen) |  |  |  |  |  |  |  | 5 |  | 2
 | Pen (Black) |  |  |  |  |  |  |  | 1 |  | 2
 | Phone Ring |  |  |  |  |  |  |  | 3 |  | 2
 | Phone Wedge |  |  |  |  |  |  |  | 9 |  | 2
 | Plastic Bag (Black Small) |  |  |  |  |  |  |  | 1 |  | 2
 | Plastic Bag (White Large) |  |  |  |  |  |  |  | 1 |  | 2
 | Polo Shirt (M & W - Nike and Ogio) |  |  |  |  |  |  |  | 35 |  | 2
 | Polo Shirt (M & W - Other Brand) |  |  |  |  |  |  |  | 20 |  | 2
 | Pop Socket |  |  |  |  |  |  |  | 2 |  | 2
 | Portfolio |  |  |  |  |  |  |  | 10 |  | 2
 | Post-It Note |  |  |  |  |  |  |  | 1 |  | 2
 | Post-It Note Booklet |  |  |  |  |  |  |  | 2 |  | 2
 | Screen Cleaners (Adhesive Back) |  |  |  |  |  |  |  | 2 |  | 2
 | Screwdrivers |  |  |  |  |  |  |  | 2 |  | 2
 | [NAME] .5 oz. |  |  |  |  |  |  |  | 2 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 1 |  | 2
 | Sunshade |  |  |  |  |  |  |  | 5 |  | 2
 | T-Shirt (Men's and Women's) |  |  |  |  |  |  |  | 10 |  | 2
 | Tape Measure |  |  |  |  |  |  |  | 5 |  | 2
 | Thank You Card/Envelope (Large) |  |  |  |  |  |  |  | 1 |  | 2
 | Thank You Card/Envelops (Small) |  |  |  |  |  |  |  | 1 |  | 2
 | [NAME] (Black Cloth) |  |  |  |  |  |  |  | 2 |  | 2
 | Tumbler (Black Yeti Style) |  |  |  |  |  |  |  | 18 |  | 2
 | Tumbler ([NAME]) |  |  |  |  |  |  |  | 12 |  | 2
 | Tumbler |  |  |  |  |  |  |  | 8 |  | 2
 | USB Charger Cube |  |  |  |  |  |  |  | 2 |  | 2
 | [NAME] (Various Styles and Colors) |  |  |  |  |  |  |  | 7 |  | 2
 | Wallet Ninja |  |  |  |  |  |  |  | 3 |  | 2
 | Water |  |  |  |  |  |  |  | 10 |  | 2
 | Wet Wipes |  |  |  |  |  |  |  | 2 |  | 2
 | [NAME] (Black) |  |  |  |  |  |  |  | 4 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 5 |  | 2
 | [NAME] ([NAME]) |  |  |  |  |  |  |  | 5 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 0.5 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 5 |  | 2
 | [NAME] |  |  |  |  |  |  |  | 4 |  | 2