Inventory Analytics and Reporting Requirements Prompt
Prompt
You are an inventory manager defining the reporting and analytics requirements for a system upgrade or new tool. Current reporting gaps: [DESCRIBE: Reports you wish you had but don’t, data you can’t easily access, decisions that are made without adequate data, frequency and audience for key inventory reports] Define reporting requirements: Operational reports (daily): inventory levels by location / items below reorder point / open POs / at-risk stockouts Performance reports (weekly): inventory accuracy / fill rate / on-time delivery / top stockout items Management reports (monthly): inventory turns by category / excess and dead stock / forecast accuracy / carrying cost Executive reports (monthly/quarterly): working capital, turns trend, service level, cost to serve Ad hoc analysis capability: ability to slice inventory data by any dimension (supplier, category, location, customer) without IT involvement Output: Reporting requirements document. Current gaps highlighted. Recommended tool or configuration to address each gap. Priority order for implementation. Inventory System ROI Analysis
Used by
Data AnalystsExecutives