Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
237x Filetype XLSX File size 0.04 MB Source: msofficegeek.com
Sheet 1: Master Inventory
| www.MSOfficeGeek.com | |||||||||
| Inventory Template | |||||||||
| (Excel, OpenOffice Calc & Google Sheet) | |||||||||
| Product ID | Product Name | Inward Quantity | Outward Quantity | Quantity In Stock | Rate | Amount | Reorder Level | Status | |
| MSG001 | Item 1 | 150 | 125 | 25 | $1,500.00 | $37,500.00 | 25 | Reorder | |
| MSG002 | Item 2 | 100 | 100 | 0 | $1,100.00 | $0.00 | 10 | Out of Stock | |
| MSG003 | Item 3 | 200 | 100 | 100 | $1,550.00 | $155,000.00 | 50 | ||
| MSG004 | Item 4 | 150 | 125 | 25 | $1,000.00 | $25,000.00 | 25 | Reorder | |
| MSG005 | Item 5 | 100 | 100 | 0 | $1,050.00 | $0.00 | 10 | Out of Stock | |
| MSG006 | Item 6 | 200 | 100 | 100 | $1,200.00 | $120,000.00 | 50 | ||
| MSG007 | Item 7 | 150 | 125 | 25 | $1,250.00 | $31,250.00 | 25 | Reorder | |
| MSG008 | Item 8 | 100 | 100 | 0 | $1,300.00 | $0.00 | 10 | Out of Stock | |
| MSG009 | Item 9 | 200 | 100 | 100 | $1,350.00 | $135,000.00 | 50 | ||
| MSG010 | Item 10 | 150 | 125 | 25 | $1,530.00 | $38,250.00 | 25 | Reorder | |
| MSG011 | Item 11 | 100 | 100 | 0 | $1,520.00 | $0.00 | 10 | Out of Stock | |
| MSG012 | Item 12 | 200 | 100 | 100 | $500.00 | $50,000.00 | 50 | ||
| MSG013 | Item 13 | 150 | 125 | 25 | $700.00 | $17,500.00 | 25 | Reorder | |
| MSG014 | Item 14 | 100 | 100 | 0 | $800.00 | $0.00 | 10 | Out of Stock | |
| MSG015 | Item 15 | 200 | 100 | 100 | $850.00 | $85,000.00 | 50 | ||
| MSG016 | Item 16 | 150 | 125 | 25 | $750.00 | $18,750.00 | 25 | Reorder | |
| MSG017 | Item 17 | 100 | 100 | 0 | $250.00 | $0.00 | 10 | Out of Stock | |
| MSG018 | Item 18 | 200 | 100 | 100 | $350.00 | $35,000.00 | 50 | ||
| MSG019 | Item 19 | 150 | 125 | 25 | $500.00 | $12,500.00 | 25 | Reorder | |
| MSG020 | Item 20 | 100 | 100 | 0 | $1,350.00 | $0.00 | 10 | Out of Stock | |
| 0 | $0.00 | Out of Stock | |||||||
| 0 | $0.00 | Out of Stock | |||||||
| 0 | $0.00 | Out of Stock | |||||||
| Total | Err:508 | Err:508 | Err:508 | $760,750.00 | |||||
| www.MSOfficeGeek.com | |||||||||
| Inventory Inward Register | |||||||||
| (Excel, OpenOffice Calc & Google Sheet) | |||||||||
| Inventory Inward Register | |||||||||
| Date | Product ID | Product | Inward Quantity | Vendor | Product ID | Product | Vendor | ||
| 1/1/2021 | MSG001 | Item 1 | 100 | ABC Ltd 1 | MSG001 | Item 1 | ABC Ltd 1 | ||
| 1/5/2021 | MSG008 | Item 8 | 50 | ABC Ltd 1 | MSG002 | Item 2 | ABC Ltd 2 | ||
| 1/11/2021 | MSG011 | Item 11 | 20 | ABC Ltd 2 | MSG003 | Item 3 | ABC Ltd 3 | ||
| 1/15/2021 | MSG002 | Item 2 | 150 | ABC Ltd 4 | MSG004 | Item 4 | ABC Ltd 4 | ||
| 1/18/2021 | MSG004 | Item 4 | 200 | ABC Ltd 4 | MSG005 | Item 5 | ABC Ltd 5 | ||
| 2/1/2021 | MSG004 | Item 4 | 100 | ABC Ltd 5 | MSG006 | Item 6 | ABC Ltd 6 | ||
| 2/8/2021 | MSG001 | Item 1 | 50 | ABC Ltd 2 | MSG007 | Item 7 | ABC Ltd 7 | ||
| 2/15/2021 | MSG008 | Item 8 | 100 | ABC Ltd 1 | MSG008 | Item 8 | ABC Ltd 8 | ||
| MSG009 | Item 9 | ABC Ltd 9 | |||||||
| MSG010 | Item 10 | ABC Ltd 10 | |||||||
| MSG011 | Item 11 | ABC Ltd 11 | |||||||
| MSG012 | Item 12 | ABC Ltd 12 | |||||||
| MSG013 | Item 13 | ABC Ltd 13 | |||||||
| MSG014 | Item 14 | ABC Ltd 14 | |||||||
| MSG015 | Item 15 | ABC Ltd 15 | |||||||
| MSG016 | Item 16 | ABC Ltd 16 | |||||||
| MSG017 | Item 17 | ABC Ltd 17 | |||||||
| MSG018 | Item 18 | ABC Ltd 18 | |||||||
| MSG019 | Item 19 | ABC Ltd 19 | |||||||
| MSG020 | Item 20 | ABC Ltd 20 | |||||||
| Total | Err:508 | ||||||||
no reviews yet
Please Login to review.
