# Inventory Report — Small Retail Store ## 1. Inventory Matrix | Product Name | Current Stock | Unit Cost | Retail Price | Total Inventory Cost | Gross Profit per Unit | Gross Profit Margin | Stock Status | |---|---:|---:|---:|---:|---:|---:|---| | Bottled Water | 50 | $0.30 | $0.75 | $15.00 | $0.45 | 60.00% | Above minimum | | Rice 1kg | 20 | $1.20 | $1.75 | $24.00 | $0.55 | 31.43% | Above minimum | | Cooking Oil 1L | 8 | $2.50 | $3.25 | $20.00 | $0.75 | 23.08% | Below minimum | | Canned Beans | 15 | $0.80 | $1.25 | $12.00 | $0.45 | 36.00% | Above minimum | ## 2. Inventory Value Summary - Listed products: 4 - Total units in stock: 93 - Total inventory cost: $71.00 - Highest inventory cost: Rice 1kg ($24.00) - Lowest inventory cost: Canned Beans ($12.00) - Weighted gross profit margin on listed inventory: 36.24% These figures represent inventory cost and potential gross profit at the listed retail prices, not realized sales or net profit. ## 3. Restocking Alerts **Priority review: Cooking Oil 1L** - Current stock: 8 units - Minimum stock level: 12 units - Difference: 4 units below the stated minimum - Suggested action: Review purchasing needs and supplier availability. The other three products are currently above their stated minimum stock levels. ## 4. Inventory and Cost Optimization 1. **Review cooking oil replenishment:** Its stock is below the supplied minimum level. Confirm supplier availability and purchasing requirements before ordering. 2. **Monitor rice inventory investment:** Rice has the highest total inventory cost in this snapshot. Compare future stock levels with actual sales data before making changes. 3. **Track product-level margins:** Cooking oil has the lowest gross profit margin among the listed products. Review pricing and acquisition costs before considering any adjustment. ## 5. Missing Information - Sales history and product demand: Not specified. - Supplier lead times: Not specified. - Purchasing budget: Not specified. - Currency is shown as dollars, but the specific currency is not identified. - Storage costs and operating expenses: Not specified. ## 6. Action Checklist - [ ] Review the cooking oil stock shortage. - [ ] Confirm supplier availability and purchasing requirements. - [ ] Compare inventory levels with actual sales history when available. - [ ] Review the cost and margin of each product. - [ ] Update inventory records after any stock movement. Review the findings and verify the figures before making purchasing or pricing decisions.