| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||
2 | ASSET INVENTORY TEMPLATE | ||||||||||
3 | |||||||||||
4 | Inventory ID | Name | Description | Unit Price | Quantity in Stock | Inventory Value | Reorder Level | Reorder Time (Days) | Quantity in Reorder | Discontinued? | Status |
5 | INVENTORY 1 | ​ | |||||||||
6 | Item 1 | Desc 1 | $51.00 | 5 | $255.00 | 29 | 13 | 50 | Low Stock | ||
7 | Item 2 | Desc 2 | $51.00 | 4 | $204.00 | 25 | 10 | 50 | Low Stock | ||
8 | Item 3 | Desc 3 | $51.00 | 1 | $51.00 | 20 | 7 | 50 | Reordering | ||
9 | INVENTORY 2 | ​ | |||||||||
10 | Item 4 | Desc 4 | $19.00 | 186 | $3,534.00 | 158 | 6 | 100 | In Stock | ||
11 | Item 5 | Desc 5 | $75.00 | 62 | $4,650.00 | 39 | 12 | 50 | In Stock | ||
12 | Item 6 | Desc 6 | $11.00 | 5 | $55.00 | 13 | 5 | 100 | Reordering | ||
13 | INVENTORY 3 | ​ | |||||||||
14 | Item 7 | Desc 7 | $56.00 | 58 | $3,248.00 | 109 | 7 | 100 | Yes | Discontinued | |
15 | Item 8 | Desc 8 | $38.00 | 101 | $3,838.00 | 162 | 3 | 100 | Low Stock | ||
16 | Item 9 | Desc 9 | $59.00 | 122 | $7,198.00 | 82 | 3 | 100 | In Stock | ||
17 | Item 10 | Desc 10 | $50.00 | 175 | $8,750.00 | 283 | 8 | 100 | Low Stock | ||
18 | INVENTORY 4 | ​ | |||||||||
19 | Item 11 | Desc 11 | $59.00 | 176 | $10,384.00 | 229 | 1 | 100 | Low Stock | ||
20 | Item 12 | Desc 12 | $18.00 | 22 | $396.00 | 36 | 12 | 100 | Reordering | ||
21 | Item 13 | Desc 13 | $26.00 | 72 | $1,872.00 | 102 | 9 | 100 | Low Stock | ||
22 | Item 14 | Desc 14 | $42.00 | 62 | $2,604.00 | 83 | 2 | 100 | Low Stock | ||
23 | INVENTORY 5 | ​ | |||||||||
24 | Item 15 | Desc 15 | $32.40 | 46 | $1,472.00 | 23 | 5 | 100 | In Stock | ||
25 | Item 16 | Desc 16 | $90.00 | 96 | $8,640.00 | 180 | 3 | 50 | Low Stock | ||
26 | Item 17 | Desc 17 | $97.00 | 57 | $5,529.00 | 98 | 12 | 50 | Yes | Discontinued | |
27 | Item 18 | Desc 18 | $45.00 | 88 | $3,960.00 | 50 | 6 | 75 | In Stock | ||
28 | Item 19 | Desc 19 | $120.00 | 40 | $4,800.00 | 35 | 9 | 60 | In Stock | ||
29 | Item 20 | Desc 20 | $15.50 | 210 | $3,255.00 | 90 | 4 | 100 | Yes | Discontinued | |