Marjorie Curada

INVENTORY DASHBOARD Total Number of Products Total Inventory Value Number of Products to Reorder Most Valuable Product Highest Product Value (Amount) Avarage Unit Price Row Labels Accessories Bags Clothing Electronics Footwear Furniture Home & Kitchen Grand Total 30 ₱775,139.00 7 Laptop ₱73,749.00 ₱237.83 Prepared by: Marjorie Curada Sum of Stock Quantity Sum of Total Value Average of Unit Price 312 ₱92,523.00 ₱- ₱180,636.00 ₱- ₱73,904.00 ₱- ₱238,512.00 ₱- ₱74,778.00 ₱- ₱20,016.00 ₱- ₱94,770.00 ₱- ₱775,139.00 ₱237.83 Inventory Summary: Total inventory value is ₱775,139.00 across 30 products. 7 products need reordering (items hitting the reorder threshold). Top category by value is Electronics. I recommend reordering the items listed under Reorder Needed within 7–14 days to prevent stockouts. Product ID- Product Name Laptop Belt Handbag Tablet Vacuum Cleaner Sunglasses Camera Coffee Maker Boots Sofa Laptop Laptop Bag Jacket Wallet Jacket Jeans Microwave Laptop Bag Cookware Set Jeans Blender Backpack Sofa Sneakers Smartphone Laptop Bag Boots Vacuum Cleaner Headphones Smartphone INVENTORY SHEET Category Electronics Accessories Bags Electronics Home & Kitchen Accessories Electronics Home & Kitchen Footwear Furniture Electronics Bags Clothing Bags Clothing Clothing Home & Kitchen Bags Home & Kitchen Clothing Home & Kitchen Bags Furniture Footwear Electronics Bags Footwear Home & Kitchen Electronics Electronics Stock Quantity- Unit Price ₱354.00 ₱375.00 ₱171.00 ₱309.00 ₱133.00 ₱176.00 ₱38.00 ₱82.00 ₱437.00 ₱60.00 ₱403.00 ₱331.00 ₱186.00 ₱146.00 ₱290.00 ₱125.00 ₱188.00 ₱133.00 ₱195.00 ₱136.00 ₱484.00 ₱243.00 ₱196.00 ₱388.00 ₱80.00 ₱414.00 ₱172.00 ₱226.00 ₱277.00 ₱387.00 Total Value ₱23,718.00 ₱70,875.00 ₱23,940.00 ₱22,866.00 ₱3,591.00 ₱21,648.00 ₱6,384.00 ₱2,132.00 ₱35,834.00 ₱7,080.00 ₱73,749.00 ₱33,762.00 ₱25,668.00 ₱17,958.00 ₱5,510.00 ₱16,750.00 ₱25,756.00 ₱25,137.00 ₱9,555.00 ₱25,976.00 ₱33,396.00 ₱6,561.00 ₱12,936.00 ₱11,252.00 ₱3,840.00 ₱73,278.00 ₱27,692.00 ₱20,340.00 ₱44,874.00 ₱63,081.00 Reorder Status In Stock In Stock In Stock In Stock Reorder Needed In Stock In Stock Reorder Needed In Stock In Stock In Stock In Stock In Stock In Stock Reorder Needed In Stock In Stock In Stock Reorder Needed In Stock In Stock Reorder Needed In Stock Reorder Needed Reorder Needed In Stock In Stock In Stock In Stock In Stock