Scribd
Upload

Basic Inventory Control Template

36 views8 pages
This document contains an inventory control template with information on various items including item number, name, manufacturer, description, stock quantity, reorder level, days per reorder…

Uploaded by

Sky Walker
  • Inventory - Basic Control
  • Inventory Description and Pricing
  • Stock and Reorder Details
  • Inventory Discontinuation and Reorder Keys

INVENTORY - BASIC CONTROL

REORDER
(auto-fill)

ITEM NO.

NAME

OK

A123

ITEM A

OK
OK

B123
C123

ITEM B
ITEM C

REORDER

D123

ITEM D

OK
OK

E123
F123

ITEM E
ITEM F

OK
REORDER

G123
H123

ITEM G
ITEM H

OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK
OK

OK

Create a Bas

MANUFACTURER

DESCRIPTION

Cole

Item A description

Cole
Cole

Item B description
Item C description

Cole

Item D description

Cole
Cole

Item E description
Item F description

Cole
Cole

Item G description
Item H description

COST PER ITEM

$10.00
$20.00
$30.00

$10.00
$20.00
$30.00

$10.00
$20.00

Create a Basic Inventory Control Template

STOCK
QUANTITY

iNVENTORY
VALUE

REORDER LEVEL DAYS PER REORDER

200

Err:509

50

14

100
50

Err:509
Err:509

50
50

30
2

20

Err:509

50

14

200
100

Err:509
Err:509

50
50

30
2

50
20

Err:509
Err:509

50
50

14
30

Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509
Err:509

Err:509

ol Template with Smartsheet

GRID KEY
DISCONTINUED

REORDER

iTEM REORDER
QUANTITY

ITEM DISCONTINUED?

100

Yes

20
50

10
100
20

50
10

Yes

INVENTORY - BASIC CONTROL ITEM NO. NAME OK A123 ITEM A OK B123 ITEM B OK C123 ITEM C REORDER D123 ITEM D OK E123 ITEM E OK F1
OK Create a Ba
MANUFACTURER DESCRIPTION COST PER ITEM Cole Item A description $10.00 Cole Item B description $20.00 Cole Item C description
Create a Basic Inventory Control Templat
REORDER LEVEL DAYS PER REORDER 200 Err:509 50 14 100 Err:509 50 30 50 Err:509 50 2 20 Err:509 50 14 200 Err:509 50 30 100 E
Err:509 ol Template with Smartsheet
GRID KEY DISCONTINUED REORDER ITEM DISCONTINUED? 100 Yes 20 50 10 100 20 50 Yes 10 iTEM REORDER QUANTITY

You might also like