| ● |
PB038 |
Coil spring walking toy |
4,000 |
$1.42 |
$1.42 |
held |
$5,680 |
100 |
12.40 |
Aug 26 |
4,000 |
0 |
| ● |
PB345 |
Light-up rubber duck, 3-pack |
2,400 |
$3.06 |
$2.88 |
+6.3% |
$7,344 |
100 |
8.60 |
Aug 26 |
2,400 |
0 |
|
A 6.3% increase on one line is the number this screen exists to surface. It is $432 on this order and about $5,200 a year at current velocity, and on a PDF from a supplier it is invisible — you would have to remember what you paid in March. The comparison is against the last PO for the same UID rather than an average, because that is the conversation: the price changed since the last time we bought it, and nobody mentioned it.
|
| ● |
PB224 |
Therapy putty, 4-pack |
3,200 |
$2.18 |
$2.24 |
−2.7% |
$6,976 |
80 |
11.20 |
Aug 26 |
3,200 |
0 |
| ● |
PB211 |
Sensory bin scoops, 6-pack |
1,680 |
$4.10 |
$4.10 |
held |
$6,888 |
70 |
11.40 |
Aug 26 |
1,680 |
0 |
| ● |
PB077 |
Wobble cushion |
1,200 |
$6.85 |
$6.85 |
held |
$8,220 |
60 |
9.20 |
Aug 28 |
1,140 |
−60 |
| ● |
PB512 |
Christmas light-up snowman |
1,800 |
$7.40 |
— |
first buy |
$13,320 |
90 |
14.80 |
not given |
— |
— |
|
Two rows are doing something the totals cannot show. PB077 arrived 60 units short against a full carton count, which is a packing problem at the factory rather than a shipping loss, and it reconciles against the packing list rather than the invoice. PB512 has no ready date at all: it is a first buy from this supplier on this item, so nothing was quoted, and until somebody asks, that line cannot be ranked into a container — it is the supplier board’s missing-date problem arriving on a specific order.
|
|
One row per UID, enforced at write time. Thirty duplicated purchase-order lines once inflated committed spend and double-counted coverage, because the same product arrived twice on one order under two keys. The authoritative key is the supplier’s item number, the guard is a uniqueness constraint on the pair rather than a nightly report, and the figure at the top says zero because zero is the only acceptable number.
|