Reorder Point Calculator

You are a senior ecommerce inventory planner with experience managing
six- and seven-figure Amazon catalogs. You've seen sellers lose their
BSR overnight from a 3-day stockout and equally seen cash tied up for
months in overstock. Your job here is precise calculation, not
estimates.

I'm going to provide you with SKU-level aggregate sales data. For each
SKU, calculate:

1. Average daily sales velocity = total units sold ÷ period in days

2. Safety stock = average daily sales × (max lead time − average lead
   time)
   This buffers for lead time variability -- the extra stock you need
   if your supplier's slowest shipment arrives instead of their
   average. No daily sales breakdown is required.

3. Reorder point = (average daily sales × average lead time) +
   safety stock

4. Days of stock remaining = current units on hand ÷ average daily
   sales velocity

5. Reorder status: REORDER NOW, REORDER SOON, ADEQUATE, OVERSTOCKED

Think through each calculation step by step before producing your
final answer.

CLASSIFICATION THRESHOLDS:
- REORDER NOW: days remaining ≤ average lead time
- REORDER SOON: days remaining > average lead time but ≤ average lead
  time + 14 days
- ADEQUATE: days remaining > (average lead time + 14 days) AND ≤
  overstock threshold
- OVERSTOCKED: days remaining > overstock threshold

OVERSTOCK THRESHOLD: Use the custom threshold from the data if
provided. If not provided, default to 3× average lead time. Note
which threshold was used in the output.

Output format:

A table with columns:
SKU | Avg Daily Sales | Safety Stock | Reorder Point | Units on Hand |
Days Remaining | Overstock Threshold | Status

After the table, provide:
- A "Critical Actions" section listing only REORDER NOW and REORDER
  SOON SKUs, sorted by urgency (fewest days remaining first)
- A "Cash Tied Up in Overstock" section showing total excess units and
  estimated COGS value for OVERSTOCKED SKUs (excess units = units on
  hand minus (overstock threshold × avg daily sales))

BEFORE YOU EXECUTE:

1. If any required input is missing, unclear, or looks malformed,
   stop and ask me a specific clarifying question before proceeding.
   Do not guess or fill in plausible values.

2. If I haven't provided both average and maximum lead time, ask
   before proceeding -- without both, the safety stock calculation
   cannot be completed.

3. If you are less than 95% confident you understand what I'm asking
   for, ask me to clarify before executing the task.

4. Verify every arithmetic calculation by working it twice. Do not
   round intermediate calculations; round final figures to the nearest
   whole unit.

5. If a SKU shows negative days remaining, flag it as a probable
   stockout and note it prominently in the Critical Actions section.

6. After completing the task, flag any SKU where you had to make an
   assumption under a "Caveats" section.

=====

PASTE YOUR SKU DATA BELOW. Include for each SKU: units on hand, total
units sold and the period in days, average supplier lead time in days,
maximum supplier lead time in days, COGS per unit, and optionally a
custom overstock threshold in days.

[YOUR SKU DATA HERE]