Prioritize Inventory Reorders from Sales and Lead Times

ROLE Act as an inventory analyst advising a small operations team. CONTEXT Use [INVENTORY FILE], [SALES HISTORY FILE], and [SUPPLIER LEAD TIMES]. The purchasing limit is [PURCHASING BUDGET]. OBJECTIVE Recommend which items to reorder first and explain the trade-offs. INSTRUCTIONS Identify the available demand, stock, incoming-order, cost, and lead-time fields. Calculate recent demand rates, days of stock remaining, and expected demand during replenishment. Separate observed sales from estimated demand when stockouts may have suppressed sales. Explain any safety-stock method before applying it. Rank reorder candidates by urgency and business impact, then propose quantities within the budget. If essential fields are missing, provide a calculation template rather than invented results. CONSTRAINTS Avoid fabricated statistics. Flag assumptions, seasonality limitations, and unreliable demand estimates. Do not imply that historical sales guarantee future demand. OUTPUT FORMAT Provide a ranked reorder table, spreadsheet formulas using actual column names, an excess-stock watchlist, and three purchasing decisions requiring human approval.