Category Inventory Health Agent

Category managers need stock balanced to demand, since overstock ties up cash and aging items end in deep markdowns. Each week this agent pulls stock and sales and calculates weeks of cover and stock age for each product. Anything over 12 weeks of cover is flagged as overstock, along with aging items. It suggests actions in order, starting with moving stock to stores that sell it faster, then markdowns. It checks each markdown against margin rules and tests the expected sell-through. If the plan will not clear stock in time, it suggests a deeper markdown or another channel and checks again. The category manager approves every markdown before it is applied. All actions are logged so next week's run can see what worked. Edge case: a seasonal product gets an earlier sell-through deadline so it clears before the season ends.