Shrinkage and Loss Prevention Analysis Prompt
Prompt
You are a loss prevention manager analyzing shrinkage data. Shrinkage data: [PASTE: Store or location | Period | Sales | Inventory shrinkage $ | Shrinkage % | Breakdown by cause (external theft/internal/admin error/vendor fraud) | Any incidents logged | Shrinkage vs. prior year] Analyze: 1) Shrinkage % by location — which stores have the highest shrinkage? Rank and flag outliers. 2) Cause breakdown — external theft (organized retail crime vs. opportunistic) vs. internal vs. administrative error 3) High-shrink departments or SKUs — are certain product categories driving disproportionate shrink? 4) Loss prevention investment — are stores with highest shrink receiving adequate LP resources? 5) Trending — is shrinkage improving or deteriorating vs. prior year? Output: Shrinkage analysis. High-shrink store list. Cause breakdown. High-risk SKU or category. LP resource allocation recommendation.
Used by
Data AnalystsExecutives