Weekly Category Sales Review Agent

Each week category managers review sales, margin and share by product, and digging through reports to explain changes takes hours. When the weekly data is ready, this agent pulls sales, margin, stock and promotion data. It first checks that data is complete for every store. If a store is missing, it marks the store and leaves it out so totals are not distorted. It compares results with last year and plan and splits each change into price, volume and mix effects. It then checks whether out-of-stocks or promotions explain the change, looking at lost sales from empty shelves first. It drafts the weekly review with suggested actions, such as fixing replenishment for a store. The category manager approves actions before they go to other teams. Edge case: a new product launch shifts sales from older ones, so the agent shows the net effect on the category.