Stock Valuation

Enter PIN to continue

Stock Valuation

Logged daily at 7:00am
Total Free Stock Value
--
Liquidation Sale loading…
1. Orders with sale items in them
--
2. Sale stock sold off the shelf
--
Sale items bought in from suppliers
--
Profit vs cost (shelf stock)
--
Stock cleared
--
Still to clear (at cost)
--
Sale stock sold off the shelf, by day (net)
SKU Product Status Sale price Sold Off shelf Bought in Avg paid Net Profit Stock left Stock value
Campaign products = the 75% dead-stock sale list (on sale now, plus items whose own stock sold out and went back to full price). Sales are P4 order lines since the sale started, cancelled lines excluded. Profit uses each order line's cost; stock value uses P4 latest cost. Prices ex VAT. "Avg paid" above the sale price means some units were sold at the standard price (supplier stock).
1. Orders with sale items in them = the full value of every order that had at least one sale item, including the other products in the basket. 2. Sale stock sold off the shelf = only the sale units that were already on our shelf. Units that P4 had to order from a supplier to fill the order are counted separately as "bought in", because they were never dead stock.
Daily sales: off the shelf vs bought in loading…
or to
Net sales (ex VAT)
--
Off the shelf (allocated)
--
Bought in to fill orders
--
Not decided yet
--
Days in the period. Click a day to see just that day.
DateOrdersNet sales Off shelfBought inNot decided Split Shelf profitBought-in profit
Every P4 order line placed on that day, by order date, ex VAT, cancelled lines and quotes excluded. Off the shelf = units P4 allocated from stock we already held. Bought in = units P4 linked to a supplier order (or a shortage still to be ordered) to fill the customer's order, including direct deliveries. Not decided yet = lines still waiting to be allocated or assigned. A line can be part shelf and part bought in; its value is split by units.
Over-ordered stock loading…
Bought but not needed (at cost)
--
Still selling
--
Slow (no sale in 90 days)
--
Not selling (no sale in 12 months)
--
SKUProductSupplierSelling? Bought 12mSold 12m Sold 90dStock Months of stock Not neededNot needed £ On order Last soldLast received
Not needed = units received from suppliers in the last 12 months that are still in free stock over and above a full year of sales (the smaller of: units received in 12 months, or free stock minus units sold in 12 months). Valued at P4 latest cost. Sales count kits against their components. Sales of the 75% Black Friday products since the sale started are not counted as demand. Still on order, not needed = open supplier orders for products that already hold a year or more of stock. Rebuilt every night at 2:30am (takes about 6 minutes).
Daily Log (7:00am) Click a day to view its supplier breakdown  ·  Download history CSV
No snapshots yet. The first one is logged at 7:00am tomorrow.