Filetype Excel XLSX | Posted on 08 Aug 2022 | 4 years ago
Authentication
digital resources
420x Filetype XLSX File size 0.07 MB Source: www.smartsheet.com
Sheet 1: Inventory - Stock Control
| INVENTORY - STOCK CONTROL | TOTAL INVENTORY VALUE | GRID KEY | |||||||||||
| $13,550.00 | *Based upon TOTAL VALUE fields below | DISCONTINUED | REORDER | ||||||||||
| REORDER (auto-fill) | ITEM NO. | DATE OF LAST ORDER | ITEM NAME | VENDOR | STOCK LOCATION | DESCRIPTION | COST PER ITEM | STOCK QUANTITY | TOTAL VALUE | REORDER LEVEL | DAYS PER REORDER | ITEM REORDER QUANTITY | ITEM DISCONTINUED? |
| OK | A123 | 5/20/2018 | ITEM A | Cole | Store Room A, Shelf 2 | Item A Description | $10.00 | 200 | $2,000.00 | 50 | 14 | 100 | Yes |
| OK | B123 | 5/20/2018 | ITEM B | Cole | Outdoor Pallet | Item B Description | $20.00 | 100 | $2,000.00 | 50 | 30 | 20 | |
| REORDER | C123 | 5/20/2018 | ITEM C | Cole | Basement, Shelf 4 | Item C Description | $30.00 | 45 | $1,350.00 | 50 | 2 | 50 | |
| REORDER | D123 | 5/20/2018 | ITEM D | Cole | Store Room A, Shelf 2 | Item D Description | $10.00 | 25 | $250.00 | 50 | 14 | 10 | |
| OK | E123 | 5/20/2018 | ITEM E | Cole | Outdoor Pallet | Item E Description | $20.00 | 200 | $4,000.00 | 50 | 30 | 100 | |
| OK | F123 | 5/20/2018 | ITEM F | Cole | Basement, Shelf 4 | Item F Description | $30.00 | 100 | $3,000.00 | 50 | 2 | 20 | |
| REORDER | G123 | 5/20/2018 | ITEM G | Cole | Store Room A, Shelf 2 | Item G Description | $10.00 | 45 | $450.00 | 50 | 14 | 50 | Yes |
| REORDER | H123 | 5/20/2018 | ITEM H | Cole | Basement, Shelf 4 | Item H Description | $20.00 | 25 | $500.00 | 50 | 30 | 10 | |
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| OK | $0.00 | ||||||||||||
| CLICK HERE TO CREATE THIS TEMPLATE IN SMARTSHEET | |||||||||||||
| INVENTORY - STOCK TRACK SHEET | |||||||||||
| DATE | EMPLOYEE SIGNATURE | ||||||||||
| ITEM | STOCK LOCATION | PURCHASE | INVENTORY | ||||||||
| ITEM NO. | ITEM NAME | DESCRIPTION | AREA | SHELF / BIN | VENDOR | VENDOR ITEM NO. | UNIT | QTY | ITEM AREA | ITEM SHELF / BIN | |
| A123 | ITEM A | Item A Description | Store Room A | Shelf 2 | Cole | VA123 | Each | 10 | Store Room A | Shelf 2 | |
| f | B123 | ITEM B | Item B Description | Outdoor Pallet | Pallet 5 | Cole | VB123 | Pkg of 10 | 20 | Outdoor Pallet | Pallet 5 |
| C123 | ITEM C | Item C Description | Basement | Shelf 4 | Cole | VC123 | 5 lbs | 50 | Basement | Shelf 4 | |
| D123 | ITEM D | Item D Description | Store Room A | Bin 7 | Cole | VD123 | Each | 100 | Store Room A | Bin 7 | |
| E123 | ITEM E | Item E Description | Outdoor Pallet | Shelf 2 | Cole | VE123 | Pkg of 10 | 10 | Outdoor Pallet | Shelf 2 | |
| F123 | ITEM F | Item F Description | Basement | Pallet 5 | Cole | VF123 | 5 lbs | 20 | Basement | Pallet 5 | |
| G123 | ITEM G | Item G Description | Store Room A | Shelf 4 | Cole | VG123 | Each | 50 | Store Room A | Shelf 4 | |
| H123 | ITEM H | Item H Description | Outdoor Pallet | Bin 7 | Cole | VH123 | Pkg of 10 | 100 | Outdoor Pallet | Bin 7 | |
| INVENTORY - ITEM STOCK SHEET | |||||
| Your Company Name | |||||
| ITEM INFO | |||||
| ITEM NAME | ITEM A | ||||
| ITEM NO. | A123 | ||||
| LOCATION | Store Room A, Shelf 2 | ||||
| PRICE | $10.00 | ||||
| ITEM QUANTITY | 200 | ||||
| MATERIAL | - | ||||
| DESCRIPTION | Item A Description | ||||
| EMPLOYEE INFO | |||||
| COUNTED BY | CHECKED BY | ||||
| EMPLOYEE NAME | John Smith | EMPLOYEE NAME | Chris Johnson | ||
| EMPLOYEE ID | XY123 | EMPLOYEE ID | XY456 | ||
| DATE | EMPLOYEE SIGNATURE | ||||
no reviews yet
Please Login to review.
