Docstoc

Inventory Control Excel Template

Document Sample
Inventory Control Excel Template Powered By Docstoc
					                      Perpetual Inventory Control
Use this template to record the inventory status of a given part or item. Because
there are relatively few formulas, this template can be used on paper as well as
electronically. Enter the sheet number. The amount that should be carried forward
to the next sheet and the next sheet number are at the bottom of the template.
To view the template, click the worksheet tab labeled Template at the bottom
of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are
protected. Use the Tab key to move from one unprotected cell to the next.

                            Copyright © KMT Software, Inc. All Rights Reserved.
                                 Perpetual Inventory Control
                                                      ITEM                               ITEM NUMBER            SHEET NUMBER


       ORDERED                           RECEIVED                                 SOLD
DATE   ORDER NO   VENDOR   QTY    DATE        QTY   BACKORDER   DUE DATE   DATE      ORDER NO      QTY     BALANCE      COMMENTS
                                                                                         BALANCE FORWARD




                                                                                   CARRIED TO NEXT SHEET

				
DOCUMENT INFO
Shared By:
Stats:
views:119
posted:12/1/2011
language:English
pages:2