Inventory Reorder Package: Your Store

Summary: I analyzed 5 SKUs over 61 days of sales (Apr 1 – May 31, 2024). 2 SKUs need ordering at your next Monday check: both T-shirt sizes, at 25 units each from PrintHouse (about $325 total). Mugs and candles are covered for now. The most important finding is that candles are your top seller. In the two weeks before Mother's Day they sold about 87% faster than usual. Totes are the opposite problem: your 30 on hand is roughly 5 years of stock, so don't reorder them.

Part 1: Demand Analysis

Avg/day = units ÷ 61 days. Std dev counts the days with zero sales. Trend compares the last 20 days (May 12–31) with the first 41 days (Apr 1 – May 11).

Insights

• Candles and mugs are your business. They make up 78% of units sold (115 of 147) and 73% of the cost value you sold.
• The Mother's Day bump is real. Mother's Day fell on Sunday, May 12, 2024 (US). From Apr 28 to May 11, candles sold 1.71/day. The rest of the window averaged 0.91/day. Candle sales also come in big lumps (7–10 units in one day), which is why their safety stock is high.
• Mugs slowed down in May. You sold 30 in April and 18 in May. The last 20 days ran 0.45/day against 0.95/day before that. I kept the full-window average because you said "never run out" of mugs. Using recent demand would cut the safety buffer. Watch this for another month before trimming.
• T-shirt sizes are swapping, not shrinking. M fell from 11 to 5 units and L rose from 6 to 9 (April to May). Combined shirt sales are fairly steady. With only 6 sales per size, part of this is probably noise.
• Totes are dead stock. There was one sale on Apr 12 and none in the 49 days since. The 30 on hand would last about 1,830 days at this rate.
• No stockouts detected. None of the gaps in your sales look like you ran out, so demand doesn't appear understated.

Part 2: Reorder-Point Model

Review period R = 7 days (you check every Monday).

How each number was calculated

• CNDL-LAV
  • Safety stock: 2.05 × 2.64 × √(7+7) = 20.3, rounded up to 21.
  • Reorder point: 1.098 × 7 + 21 = 28.7, rounded up to 29.
  • Order-up-to: 1.098 × 14 + 21 = 36.4, rounded up to 37.
  • EOQ: √(2 × 401 × $25 ÷ ($5.25 × 0.25)) = 123.6, rounded up to 11 cases = 132.
• MUG-BLU
  • Safety stock: 2.05 × 1.69 × √21 = 15.9, rounded up to 16.
  • Reorder point: 0.787 × 14 + 16 = 27.0, rounded up to 28.
  • Order-up-to: 0.787 × 21 + 16 = 32.5, rounded up to 33.
  • EOQ: √(2 × 287 × $25 ÷ ($4.10 × 0.25)) = 118.4, rounded up to 5 cases = 120.
• TEE-M
  • Safety stock: 1.28 × 0.83 × √28 = 5.7, rounded up to 6.
  • Reorder point: 0.262 × 21 + 6 = 11.5, rounded up to 12.
  • Order-up-to: 0.262 × 28 + 6 = 13.3, rounded up to 14.
• TEE-L
  • Safety stock: 1.28 × 0.81 × √28 = 5.5, rounded up to 6.
  • Reorder point: 0.246 × 21 + 6 = 11.2, rounded up to 12.
  • Order-up-to: 0.246 × 28 + 6 = 12.9, rounded up to 13.
  • If you use the recent rising rate (0.35/day), the reorder point becomes 14. You'd still order now either way.
• TOTE-NAT has only 1 sale, so I used the low-data fallback for safety stock.
  • Safety stock: 0.0164 × (0.5 × 30) = 0.25, rounded up to 1.
  • Reorder point: 0.0164 × 30 + 1 = 1.5, rounded up to 2.

Why EOQ and Lean are both shown: EOQ uses an assumed $25 cost per order, and it favors big, infrequent orders. Since cash is tight, I recommend the Lean quantity for candles and mugs. Lean means about 30 days of cover, rounded up to full cases. If you learn your real ordering cost is high (for example, steep shipping per order), switch to the EOQ quantity.

Part 3: Google Sheets Setup (formulas)

Tab "Sales": paste your data as-is. Columns: A = date, B = sku, C = product, D = qty.

Tab "Settings":

Tab "Daily" (needed so zero-sale days count in the std dev):

• A2: =SEQUENCE(Settings!B3,1,Settings!B1) (format column A as dates)
• B1, C1, D1…: one SKU per column (CNDL-LAV, MUG-BLU, …)
• B2, then fill down and right: =SUMIFS(Sales!$D:$D,Sales!$A:$A,$A2,Sales!$B:$B,B$1,Sales!$D:$D,">0")

Tab "Model": one row per SKU, starting in row 2.