Customer file order · Kingsway Academy

SO-52364

Picking

Customer file KAT-94098.csv from Kingsway Academy Trust’s own system on Tue 3 Nov at 07:00, read and mapped to the Contract Master in 5 s. For Tue 10 Nov by DPD next day. Owner Hannah Price. Kingsway Academy Trust, education, price band B, 3 contract lines.

Website

Portal

Customer file

KAT-94098.csv, mapped in 5 s

Phone or email

Net, ex VAT

£146.25

£175.50 inc VAT

Margin

32.9%

GP floor 26% a line

Kingsway Academy Trust

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%

Price lists →

Product	Qty	Price	Source	Margin	Line
UC101 Uneek Classic Polo, Royal KAT101ROY · plain UC101-ROY · Sizes XS to 4XL · Contract Master	9	£6.95	Contract Master	32.4% ✓	£62.55
SizeXSSMLXL2XL3XL4XLTotal Ordered013320009 Blanks free1528545331440189 On hand1659118125712240415 DecorationKAT101ROY: left chest embroidery (KINGSWAY ACADEMY)
GD057 Gildan Heavy Blend Hoodie, Navy KAT057NAV · plain GD057-NAV · Sizes S to 3XL · Contract Master	6	£13.95	Contract Master	33.3% ✓	£83.70
SizeSMLXL2XL3XLTotal Ordered1221006 Blanks free210750125 On hand2143452681144 DecorationKAT057NAV: left chest embroidery (KINGSWAY ACADEMY)

Goods, ex VAT£146.25

Delivery, DPD next dayFree

Net, ex VAT£146.25

VAT at 20%£29.25

Total£175.50

Free delivery over £100 ex VAT.

Margin 32.9% on the order; no line under the 26% GP floor.

Checked as it landed

price, stock and credit, before anyone touched it

£price

Priced at their rate

2 from the Contract Master. Contract Master prices as agreed; plain lines clear the 26% GP floor.

▦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 retyping

FromPurchasing, Kingsway Academy Trust

Toinfo@cwear.co.uk

SubjectOrder file KAT-94098

Tue 3 Nov 07:00

KAT-94098.csv1 file, 2 rows

	A	B	C	D
1	CODE	COLOUR	SIZES	QTY
2	KAT101ROY	ROYAL	S:1 M:3 L:3 XL:2	9
3	KAT057NAV	NAVY	S:1 M:2 L:2 XL:1	6

How it was mapped

KAT101ROY x S 1, M 3, L 3, XL 29 x UC101-ROY
KAT057NAV x S 1, M 2, L 2, XL 16 x GD057-NAV

Read and mapped in 5 s: their codes to Contract Master lines, their rows into size grids.

Delivery

DPD dispatch →

DPD

DPD Next Day

Collected 16:30 Mon 9 Nov

DeliveryTue 10 Nov, Kingsway Academy

AddressWolverhampton WV1

Pick slipSO-52364, Tom picking now

DPD Next DayDPD

1550 0002 0421 97

Kingsway Academy, Kingsway Academy Trust

FAO Claire Spencer

Wolverhampton, WV1

Weight4.7 kg, 15 garments

LabelPrints 15:00 Mon 9 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

Kingsway 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