Customer file order · Kingsway Academy
SO-52559
ConfirmedOld price stoppedCustomer file KAT-PO-20931.csv from Kingsway Academy Trust’s own system today at 09:12, read and mapped to the Contract Master in 6 s. For Mon 16 Nov by DPD next day once decorated. Owner Hannah Price. Kingsway Academy Trust, education, price band B, 3 contract lines.
Website
Portal
Customer file
KAT-PO-20931.csv, mapped in 6 s
Phone or email
Net, ex VAT
£168.30
£201.96 inc VAT
Margin
27.6%
GP floor 26% a line
About this order
The trust’s buying system still carries last year’s £9.20 for the plain grey GD057 hoodie. The garment cost went up on 2 November, so at £9.20 the line would sit well under the 26% floor. The floor stopped it and priced it at the trust’s Band B rate.
Lines at Kingsway Academy Trust’s own prices
Contract price first, then any promotion, then their band; GP (profit / sell price) flagged when under 26%
| Product | Qty | Price | Source | Margin | Line |
|---|---|---|---|---|---|
UC101 Uneek Classic Polo, Royal KAT101ROY · plain UC101-ROY · Sizes XS to 4XL · Contract Master | 6 | £6.95 | Contract Master | 32.4% ✓ | £41.70 |
SizeXSSMLXL2XL3XL4XLTotal Ordered012210006 Blanks free1528545331440189 On hand1659118125712240415 DecorationKAT101ROY: left chest embroidery (KINGSWAY ACADEMY) | |||||
GD057 Gildan Heavy Blend Hoodie, Sport Grey GD057-SGY · Sizes S to 3XL · GP floor Carried £9.20, under the 26% floor (£10.55 at the new £7.80 cost): priced at the floor | 12 | £10.55 £11.55 was £9.20 | GP floor | 26.1% ✓ | £126.60 +£16.20 kept |
SizeSMLXL2XL3XLTotal Ordered23421012 Free1321007 On hand36631019 Plain: supplier code, ships with no logo | |||||
Goods, ex VAT£168.30
Delivery, DPD next dayFree
Net, ex VAT£168.30
VAT at 20%£33.66
Total£201.96
Free delivery over £100 ex VAT.
Margin 27.6% on the order; no line under the 26% GP floor.
Checked as it landed
price, stock and credit, before anyone touched it£price
Old price stopped
One line carried a price under the margin floor and was priced at the account’s rate instead. 1 from the Contract Master, 1 at Band B.
▦stock
Stock kept by size
Every size was available or due in next day, and kept for this order as it was read.
✓credit
Within the limit
£11,485 of the £17,250 limit in use with this order.
As it arrived
CSV from the customer’s own ordering app or buying system; their codes mapped to Contract Master lines, no retypingFromPurchasing, Kingsway Academy Trust
Toinfo@cwear.co.uk
SubjectOrder file KAT-PO-20931
Today 09:12
KAT-PO-20931.csv1 file, 2 rows
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | KAT101ROY | ROYAL | S:1 M:2 L:2 XL:1 | 6 |
| 3 | GD057-SGY | SPORT GREY | S:2 M:3 L:4 XL:2 2XL:1 | 12 |
£9.20 is under the 26% floor price (£10.55 at £7.80 cost): their buying system still carries an old price.
How it was mapped
- KAT101ROY x S 1, M 2, L 2, XL 16 x UC101-ROY
- GD057 Gildan Heavy Blend Hoodie, Sport Grey x S 2, M 3, L 4, XL 2, 2XL 112 x GD057-SGY
Read and mapped in 6 s: their codes to Contract Master lines, their rows into size grids.
Delivery
DPD
DPD Next Day
Collected 16:30 Fri 13 Nov
DeliveryMon 16 Nov, Kingsway Academy
AddressWolverhampton WV1
Pick slipSO-52559, on the pick slip for Fri 13 Nov
DPD Next DayDPD
1550 0002 0494 12
Kingsway Academy, Kingsway Academy Trust
FAO Claire Spencer
Wolverhampton, WV1
Weight5.6 kg, 18 garments
LabelPrints 15:00 Fri 13 Nov
One DPD consignment per delivery address a day: orders for the same address that day go under one label. DPD collects at 16:30 the working day before delivery and sends the proof of delivery back onto the order.
Invoice
Invoicing →Not yet. Once it is signed for, the invoice is made from the delivered quantities and sent to Xero at 18:00 that evening. Nobody re-types it.
Customer
KAKingsway Academy Trust
C-1009 · Education · 3 sites · since 2017
PricesBand B, 10% off list, 3 contract lines
Terms30 days end of month
Credit£11,485 of £17,250, £6,093 overdue
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Other orders from Kingsway Academy Trust
SO-52576
Today · Kingsway Primary
£144.05
Confirmed
SO-52568
Today · Kingsway Academy
£76.45
Confirmed
SO-52477
Thu 5 Nov · Kingsway Academy
£131.10
In production
SO-52364
Tue 3 Nov · Kingsway Academy
£146.25
Picking
SO-52246
29 Oct · Kingsway Academy
£34.75
Sent to Xero
Audit trail
Customer file KAT-PO-20931.csv received
Customer · Today 09:12
Read in 6 s: 2 of 2 lines matched to Contract Master lines with sizes
Auto · Today 09:13
Priced at Kingsway Academy Trust’s own rates: 1 from the Contract Master, 1 at Band B
Auto · Today 09:13
Margin floor stopped GD057 Gildan Heavy Blend Hoodie, Sport Grey at £9.20: under the 26% floor price (£10.55 at £7.80 cost); priced at £10.55, £16.20 kept
Auto · Today 09:13
Stock checked by size: every line available or due in next day
Auto · Today 09:13
Credit checked: within the £17,250 limit
Auto · Today 09:13
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · Today 09:13
Next: lots done, pick slip released, collected by DPD Fri 13 Nov
Planned · Thu 12 Nov 15:00