SoStocked alternatives

Overview

Every product across Shopify, Amazon and your warehouses, as of 5 Dec. Recalculated each morning.

• Buy list$9,421What the suggested orders cost, at each supplier’s price.
• Products to order this week4Products whose order-by date is in the next 7 days.
• In-stock rate91%Share of selling days each product was in stock, weighted by its sales. Last 90 days.
• Sales lost to stockouts$24,800Sold-out days × in-stock daily sales × price. An estimate. Last 90 days.
• Stock on order$10,310Open purchase orders not yet received, at cost.
• Overstock$5,240Cost of stock with more than 180 days of cover, or unsold for 90 days.
• Forecast accuracy87.0%1 − (units forecast wrong ÷ units sold), per product, last 3 months.
• Days of cover51 days(On hand + on order) ÷ in-stock daily sales. Median across products.
• Stock turns5.2×Cost of goods sold in the last 12 months ÷ average stock at cost.
• Supplier delay10 daysAverage days the last 3 orders arrived after the supplier’s quoted date.

Needs you today

✕Order 840 insulated bottles today.Ningbo has taken 38 days, not 25. Ordering later than today means a sell-out around 9 Jan, in the January sale.

✕Order cold brew jars and black mugs by 8 Dec.One Jingdezhen order for both, so the mugs ride in the same shipment.

▸3 purchase orders are late.The 200 bottles and 400 mugs are already counted, at their new dates. Chase the 200 straw packs Ningbo didn’t ship.

▸Black mugs at Amazon drop under 28 days this week.Send 90 from New Jersey before Amazon starts its low-inventory fee.

✓Gift boxes are covered for the peak.650 arrive from Leeds on 9 Dec, before the last week of Christmas orders.

Buy list

What to order, how many and by when. The order-by date allows for each supplier’s real lead time plus 7 days of safety stock.

Sold a day leaves out the days a product was sold out, and counts every bundle sale on each product inside it. Quantities round up to the supplier’s minimum and the bottle’s case of 24. Change any quantity and the purchase order follows.

Forecast

One model per product, picked by which would have forecast its last 12 months best. Every forecast shows its range, and you can change any month.

Insulated bottle, 750 ml, units a month

Solid: sold last year. Red: units it would have sold in September and October if it hadn’t sold out, which the forecast counts as demand. Dashed: the forecast, with the shaded range it expects to land in 9 months out of 10.

Every product’s forecast

Accuracy compares the last 3 months’ forecast with what sold. Your changes stay on the forecast, labelled, until you remove them.

Purchase orders

Every purchase order from draft to received. Expected dates use each supplier’s real lead time, not the date they quoted.

Drafts are ready to check and send as a PDF or email, in the supplier’s currency. Receive in part or in full; a short delivery stays open until you close it.

Suppliers

The buy list plans with the real lead time. When a supplier speeds up, the next three orders bring the figure back down.

Locations

Stock and days of cover at each place you sell from. Each location is forecast from the orders it ships.

Suggested transfers

Approve a transfer and Kerno writes the transfer order, or the inbound shipment for ShipMonk. A transfer is suggested only when it costs less than ordering more.

Amazon FBA

Amazon FBA, from Amazon’s inventory, restock, inventory-planning and storage-capacity reports. Amazon’s own restock suggestion sits beside Kerno’s.

• Ready to ship674Units Amazon can sell now.
• Reserved96In customer orders, moving between warehouses, or being checked.
• To send this week90Units Kerno suggests sending from your own stock.
• Storage used182 of 300Cubic feet against your limit for standard-size items.
• Aged surcharge$168Amazon’s estimate for next month, on stock over 180 days old.

✕Send 90 black travel mugs to Amazon this week.Send 90 from New Jersey this week. Under 28 days, Amazon adds a low-inventory fee to every unit.

▸210 sage travel mugs are 271–365 days old.Amazon estimates a $168 surcharge next month. A removal order at about $0.97 a unit costs less, or run a coupon first.

Stock at Amazon

Amazon’s suggestion assumes you can send any amount at any time. Kerno’s counts what is in your own warehouse, what is on order from the supplier, and the next send date.

Units by age at Amazon

After this week’s send, storage use is 191 of 300 cubic feet. Inbound shipments are planned to avoid Amazon’s placement fee where splitting the shipment costs less than the fee.

Bundles

Bundles are built from stock of their parts, so Kerno forecasts each part from every listing it sells in.

Where each part’s demand comes from

A spreadsheet that only counts lids sold on their own sees 4 a day and orders less than half of what you need.

Overstock

Stock with more than 180 days of cover, or nothing sold in 90 days. $5,240 at cost, kept off the buy list until it sells down.

The sage mug includes 210 units at Amazon, where it also costs an aged surcharge. See the Amazon FBA tab.

Budget

Your buying plan by month: stock arriving, what you pay and when (deposits included), against the budget you set.

▸March is $4,400 over budget.Spring stock for the 1 l bottle launch lands then. Move its second order to April, or raise March’s budget; the forecast shows what each choice does to stock.

Plan to a sales target

Set a target and Kerno shows the stock it takes. To reach $650,000 from December to May, 8% over the forecast, you’d buy about $8,400 more, mostly bottles and gift boxes, and pay $2,600 of it in March.