Scribd
Upload
223 views2 pages

Stock Inventory Management Template

The document is an inventory register that tracks 24 products with details like quantity purchased, current stock level, reorder level, quantity sold, and whether the product has been discontinued. It shows that half the products have stock levels below the reorder point and should be reordered, and two products in particular have very low stock levels of only 2 and 0 units remaining.

Uploaded by

sabs_chaks
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
223 views2 pages

Stock Inventory Management Template

The document is an inventory register that tracks 24 products with details like quantity purchased, current stock level, reorder level, quantity sold, and whether the product has been discontinued. It shows that half the products have stock levels below the reorder point and should be reordered, and two products in particular have very low stock levels of only 2 and 0 units remaining.

Uploaded by

sabs_chaks
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 Register

Check this Box to

Inventory Register ✘
Highlight Items to
reorder

Inventory Product Detail Quantity Price/Unit Quantity in Value Stock in Reorder Reorder Quantity Discontinued
Control ID Purchased Stock Hand Level Quantity Sold Product
Col
ABC001 Product 1 100 ₹ 100.00 50 ₹ 5,000.00 25 100 50
ABC002 Product 2 50 ₹ 200.00 25 ₹ 5,000.00 50 50 25
ABC003 Product 3 50 ₹ 250.00 0 ₹ 0.00 25 50 50
ABC004 Product 4 50 ₹ 500.00 0 ₹ 0.00 50 50 50
ABC005 Product 5 100 ₹ 110.00 52 ₹ 5,720.00 25 100 48
ABC006 Product 6 100 ₹ 120.00 75 ₹ 9,000.00 50 100 25
ABC007 Product 7 100 ₹ 150.00 50 ₹ 7,500.00 25 100 50
ABC008 Product 8 50 ₹ 135.00 0 ₹ 0.00 50 50 50
ABC009 Product 9 100 ₹ 110.00 50 ₹ 5,500.00 25 100 50
ABC010 Product 10 100 ₹ 100.00 65 ₹ 6,500.00 50 100 35
ABC011 Product 11 100 ₹ 200.00 50 ₹ 10,000.00 25 100 50
ABC012 Product 12 100 ₹ 110.00 50 ₹ 5,500.00 50 100 50
ABC013 Product 13 100 ₹ 250.00 50 ₹ 12,500.00 25 100 50
ABC014 Product 14 50 ₹ 350.00 0 ₹ 0.00 50 50 50
ABC015 Product 15 100 ₹ 400.00 50 ₹ 20,000.00 25 100 50
ABC016 Product 16 100 ₹ 150.00 50 ₹ 7,500.00 25 100 50
ABC017 Product 17 100 ₹ 135.00 50 ₹ 6,750.00 25 100 50 Yes
ABC018 Product 18 100 ₹ 170.00 50 ₹ 8,500.00 25 100 50
ABC019 Product 19 100 ₹ 125.00 50 ₹ 6,250.00 50 100 50
ABC020 Product 20 100 ₹ 180.00 50 ₹ 9,000.00 25 100 50
ABC021 Product 21 100 ₹ 230.00 50 ₹ 11,500.00 50 100 50
ABC022 Product 22 100 ₹ 220.00 50 ₹ 11,000.00 25 100 50
ABC023 Product 23 100 ₹ 100.00 2 ₹ 200.00 50 100 98 Yes
ABC024 Product 24 100 ₹ 250.00 50 ₹ 12,500.00 25 100 50
ABC025 Product 25 50 ₹ 110.00 0 ₹ 0.00 25 50 50

You might also like