For Grocery Department Managers ·
What you'll accomplish
By the end of this guide, you'll be able to take your raw weekly shrink data — a table of items, quantities, and dollar amounts — and get a clear, actionable analysis in under 3 minutes. You'll know which products are costing you the most, which patterns indicate a specific problem, and what to do about it. No more spending an hour staring at a spreadsheet trying to find the story in the numbers.
What you'll need
Go to claude.ai and sign in. Click New Chat to start a fresh conversation.
What you should see: A clean chat interface with a text input box at the bottom.
Get your shrink log — this might be a printout from your chain's reporting system, a table you keep in Excel/Sheets, or even handwritten notes. You need: item name, type of shrink (damage / spoilage / theft / unknown), quantity lost, and dollar value if available.
If your data is in a spreadsheet, select and copy the cells. If it's handwritten, type it quickly as a simple list.
In the Claude chat box, type the following (then paste your data below):
Here is my department shrink log for the past [1 week / 2 weeks].
Please:
1. Identify the top 5 items by total shrink value
2. Note any patterns by day, shift, or category
3. Suggest 3 possible root causes based on the data
4. Recommend one specific action item for each cause
[Paste your data here]
Press Enter or click the send button.
What you should see: Claude reads your data and generates a structured analysis within 15–20 seconds. Troubleshooting: If Claude says the data is unclear, format it more simply — one item per line, like: "Strawberries: 8 pints damaged, $24 loss"
After the initial analysis, you can dig deeper:
Copy Claude's summary. Paste it into an email to your store director, your own notes, or your department performance tracker. This becomes your weekly shrink report.
Weekly shrink summary for management: "Summarize this week's shrink data in 3 sentences suitable for a store director report: [paste data]"
Root cause investigation: "My [item] shrink has been high 3 weeks in a row. Based on this data, what are the most likely causes? [paste data]"
Year-over-year comparison: "Compare these two weeks of data and tell me if things are getting better or worse and why: [paste week 1 data] vs [paste week 2 data]"
Pre-audit review: "I have a health/loss prevention audit next week. Review this shrink log and tell me what I need to address before the auditor arrives: [paste data]"
New employee coaching: "Based on this shrink pattern, write a coaching point I can use in my next team meeting to address the issue without calling out specific employees."