Scribd
Upload
5 views2 pages

Office Supplies Inventory List

The document lists various office supplies with details including ItemID, ItemName, Category, Quantity, and UnitPrice. It also includes a formula for calculating the TotalValue based on Quantity and UnitPrice, along with corresponding PurchaseDates for each item. The items range from writing instruments to hardware and accessories, indicating a diverse inventory.

Uploaded by

mahendersingh125000
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
5 views2 pages

Office Supplies Inventory List

The document lists various office supplies with details including ItemID, ItemName, Category, Quantity, and UnitPrice. It also includes a formula for calculating the TotalValue based on Quantity and UnitPrice, along with corresponding PurchaseDates for each item. The items range from writing instruments to hardware and accessories, indicating a diverse inventory.

Uploaded by

mahendersingh125000
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

ItemID ItemName Category Quantity UnitPrice

501 Pen Writing 120 15


502 Notebook Paper 60 55
503 USB Drive 32GB Accessories 40 350
504 Stapler Tools 15 180
505 A4 Paper Pack Paper 50 300
506 Marker Writing 55 25
507 Highlighter Writing 30 20
508 Mousepad Accessories 25 120
509 Keyboard Hardware 10 1800
510 Mouse Hardware 18 800
511 Sticky Notes Paper 45 45
512 Folder File Storage 35 60
513 Whiteboard Tools 5 2500
514 HDMI Cable Accessories 20 350
515 Ethernet Cable Accessories 30 220
516 Power Strip Electrical 12 600
517 Laptop Stand Hardware 8 1500
518 Printer Ink Black Printer Supply 6 1800
519 Printer Ink Color Printer Supply 7 2200
520 Pen Drive 64GB Accessories 25 450
TotalValue (apply
formula) PurchaseDate
=D2*E2 1/15/2025
=D3*E3 1/20/2025
=D4*E4 2/1/2025
=D5*E5 2/5/2025
=D6*E6 2/8/2025
=D7*E7 2/10/2025
=D8*E8 2/12/2025
=D9*E9 2/14/2025
=D10*E10 2/18/2025
=D11*E11 2/18/2025
=D12*E12 2/20/2025
=D13*E13 2/21/2025
=D14*E14 2/22/2025
=D15*E15 2/25/2025
=D16*E16 2/25/2025
=D17*E17 2/26/2025
=D18*E18 2/27/2025
=D19*E19 2/28/2025
=D20*E20 3/1/2025
=D21*E21 3/2/2025

You might also like