Scribd
Upload
34 views6 pages

Basic Inventory Control with Smartsheet

The document outlines an inventory control system with information on 8 items, including item numbers, names, manufacturers, descriptions, costs, current stock quantities, inventory values, reorder levels, days between reorders, reorder quantities, and whether items have been discontinued. It provides a template for tracking basic inventory information to manage reorder levels.

Uploaded by

tehtehteh
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
34 views6 pages

Basic Inventory Control with Smartsheet

The document outlines an inventory control system with information on 8 items, including item numbers, names, manufacturers, descriptions, costs, current stock quantities, inventory values, reorder levels, days between reorders, reorder quantities, and whether items have been discontinued. It provides a template for tracking basic inventory information to manage reorder levels.

Uploaded by

tehtehteh
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

INVENTORY - BASIC CONTROL

REORDER
ITEM NO. NAME MANUFACTURER
(auto-fill)

OK A123 ITEM A Cole


OK B123 ITEM B Cole
OK C123 ITEM C Cole
REORDER D123 ITEM D Cole
OK E123 ITEM E Cole
OK F123 ITEM F Cole
OK G123 ITEM G Cole
REORDER H123 ITEM H Cole
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK

Create a Basic Invento


COST PER STOCK iNVENTORY
DESCRIPTION
ITEM QUANTITY VALUE

Item A description $10.00 200 $2,000.00


Item B description $20.00 100 $2,000.00
Item C description $30.00 50 $1,500.00
Item D description $10.00 20 $200.00
Item E description $20.00 200 $4,000.00
Item F description $30.00 100 $3,000.00
Item G description $10.00 50 $500.00
Item H description $20.00 20 $400.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00

Basic Inventory Control Template with Smartsheet


REORDER DAYS PER iTEM REORDER ITEM
LEVEL REORDER QUANTITY DISCONTINUED?

50 14 100 Yes
50 30 20
50 2 50
50 14 10
50 30 100
50 2 20
50 14 50 Yes
50 30 10

Smartsheet

You might also like