What This Report Is
This report gives you a detailed list of all inventory items by department, showing how much each item costs, how much it sells for, and how many units are in stock. It calculates the total value (price × quantity) and profit margins, helping you manage your inventory more effectively.
Why It Matters
- Shows the real dollar value of your current inventory
- Helps you check if you’re making a profit on each item
- Useful for spotting incorrect prices or costs
- Helps you decide what to restock or remove from shelves
What to Do
- Check margins: If the margin is too low (or negative), you might be losing money
- Fix pricing: Raise prices on low-margin items if possible
- Watch for 0 QOH with high value: If items are out of stock but high value, reorder them
- Spot data issues: If cost is higher than price, fix your price or cost entries
- Use filters: Search by department or product name to find what matters most to you
- Track trends: Compare Last Cost vs. Avg Cost to see if supplier prices are increasing