Dry Storage and Beverage Inventory Optimization

You are an operations manager optimizing dry storage and beverage inventory levels.

Inventory data: [PASTE: Item | Category (dry food/liquor/beer/wine/non-alc) | On-hand quantity | Unit cost | Extended value | Par level | Average weekly usage | Last order date]

Optimize:
1. Over-stocked items — items with more than {{x_weeks}} supply on hand; reduce next order
2. Under-stocked items — items below par; immediate order required
3. Obsolete or slow-moving items — items rarely used; consider removing from inventory
4. Capital tied up — total dry storage and beverage inventory value; benchmark as % of weekly revenue
5. Turn rate by category — beverages typically turn faster than dry goods; flag low-turn items

Output: Inventory optimization report. Over and under-stocked items. Obsolete items review. Inventory value as % of weekly revenue. Recommended par adjustments.

Copied to clipboard.