Tessa Halstead

Buying packaging against a sales forecast

The cheapest unit price isn’t always the cheapest order.

The situation

  • Our chocolates needed packaging to match a luxury product: rigid linen boxes and printed containers that felt like a gift before they were opened.
  • Made locally, that quality was cost-prohibitive, so I sourced overseas, which meant large minimum orders.
  • Before the shop had a single month of sales, we committed to all four sizes at once: 5,000 small, 5,000 medium and 2,500 large boxes, plus printed containers.
  • The delivery didn’t fit in the shop, so we rented a nearby storage unit and split it between the two.
  • The largest box took more than three years to sell through, tying up cash and storage space.

What I did

  • Tracked sales by size and channel, then built inventory and seasonality models: a growth assumption, stock on hand and the shortfall by size.
  • Planned around 10–12 week lead times, so December stock was ordered by early fall.
  • Once we had a proven box and sales history, qualified a U.S.-based supplier with minimums from 1,000 units instead of 2,500 or more.
  • Reordered only the sizes the model showed running short.
  • Result: peak stock of 6-piece boxes fell by more than half, from about 7,100 after the 2016 bulk order to about 3,600 and 2,800 after the 2018 and 2019 refills.

What I learned

  • A U.S.-based supplier became an option once we had a proven prototype and sales to back it up.
  • The modest per-unit increase paid for itself in less time and labor hauling packaging from storage.
  • Smaller, forecast-sized orders kept stock in step with sales as we added a second location.
Exhibit

Forecast-sized orders cut peak stock by more than half.

Inventory of our 6-piece box, a best-seller. Bars are monthly sales (December in blue); the dotted line is boxes on hand after each delivery.

How the exhibit was built →

Monthly sales come from our point-of-sale reports: exact where a monthly report exists, and otherwise the year's total spread across the missing months in the same pattern as 2018. The 2017–18 Domain pop-up and December 2019 come from their own registers. Boxes on hand start from each delivery (5,000 in October 2014, 6,000 in December 2016, 3,000 in December 2018, 1,500 in November 2019) and step down with sales. The line is matched to my two physical counts (1,797 boxes in February 2018 and 1,940 in May 2019), which also accounts for boxes used for corporate orders, wholesale and events that don't show up as retail sales.