Inventory & Payables Management Using Excel
Item Code
ITM001
ITM002
ITM003
ITM004
ITM005
ITM006
ITM007
ITM008
ITM009
ITM010
ITM011
ITM012
ITM013
ITM014
ITM015
Item Name
Category
Mouse
Electronics
Keyboard
Electronics
Laptop
Electronics
Notebook
Stationery
Pen
Stationery
Detergent
Cleaning
Mop
Cleaning
Printer
Electronics
Scanner
Electronics
Extension CableElectronics
Stapler
Stationery
Whiteboard
Stationery
Projector
Electronics
Paper Pack
Stationery
USB Drive
Electronics
Quantity In Stock-
Unit Price
Reorder Level Quantity Issued Total Value Quantity Balance-
-
Value of Remaining Stock-
Item Code
ITM003
ITM013
ITM008
ITM009
ITM015
ITM002
ITM001
ITM012
ITM010
ITM006
ITM004
ITM011
ITM005
ITM007
ITM014
Item Name
Laptop
Projector
Printer
Scanner
USB Drive
Keyboard
Mouse
Whiteboard
Extension Cable
Detergent
Notebook
Stapler
Pen
Mop
Paper Pack
Category
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Stationery
Electronics
Cleaning
Stationery
Stationery
Stationery
Cleaning
Stationery
Quantity In Stock-
Unit Price
Reorder Level Quantity Issued
Total Value
Quantity Balance-
-
Value of Remaining Stock-