Scribd
Upload
17 views3 pages

Basic Inventory Control Template Excel

The document presents a basic inventory control template in Excel format, detailing items with their respective reorder levels, stock quantities, and values. It highlights specific items that need reordering and provides a structure for tracking inventory. Additionally, it includes a disclaimer regarding the accuracy and reliability of the information provided by Smartsheet.

Uploaded by

tepuqureshi27
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
17 views3 pages

Basic Inventory Control Template Excel

The document presents a basic inventory control template in Excel format, detailing items with their respective reorder levels, stock quantities, and values. It highlights specific items that need reordering and provides a structure for tracking inventory. Additionally, it includes a disclaimer regarding the accuracy and reliability of the information provided by Smartsheet.

Uploaded by

tepuqureshi27
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Excel Basic Inventory Control Template Example

Reorder Stock Inventory Item Reorder


Item No. Name Manufacturer Description Cost Per Item Reorder Level Days Per Reorder Last Sold Date Notes
(auto-fill) Quantity Value Quantity

OK A123 ITEM A Cole Item A description $10.00 200 $2,000.00 50 14 100


OK B123 ITEM B Cole Item B description $20.00 100 $2,000.00 50 30 20
OK C123 ITEM C Cole Item C description $30.00 50 $1,500.00 50 2 50
REORDER D123 ITEM D Cole Item D description $10.00 20 $200.00 50 14 10
OK E123 ITEM E Cole Item E description $20.00 200 $4,000.00 50 30 100
OK F123 ITEM F Cole Item F description $30.00 100 $3,000.00 50 2 20
OK G123 ITEM G Cole Item G description $10.00 50 $500.00 50 14 50
REORDER H123 ITEM H Cole Item H description $20.00 20 $400.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

CLICK HERE TO CREATE IN SMARTSHEET


Basic Inventory Control Template
Reorder. Stock Inventory Item Reorder
Item No. Name Manufacturer Description Cost Per Item Reorder Level Days Per Reorder Last Sold Date Notes
(auto-fill) Quantity Value Quantity

OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
OK $0.00 $0.00
Any articles, templates, or information provided by Smartsheet on the website are for reference
only. While we strive to keep the information up to date and correct, we make no representations
or warranties of any kind, express or implied, about the completeness, accuracy, reliability,
suitability, or availability with respect to the website or the information, articles, templates, or
related graphics contained on the website. Any reliance you place on such information is
therefore strictly at your own risk.

You might also like