Customer file order · Kingsway Primary

SO-52576

Confirmed

Customer file KAT-51004.csv from Kingsway Academy Trust’s own system today at 10:24, read and mapped to the Contract Master in 3 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-51004.csv, mapped in 3 s

Phone or email

Net, ex VAT

£144.05

£172.86 inc VAT

Margin

40.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	7	£6.95	Contract Master	32.4% ✓	£48.65
SizeXSSMLXL2XL3XL4XLTotal Ordered012211007 Blanks free1528545331440189 On hand1659118125712240415 DecorationKAT101ROY: left chest embroidery (KINGSWAY ACADEMY)
UC301 Uneek Classic T-shirt, Navy KAT301NAV · plain UC301-NAV · Sizes XS to 4XL · Contract Master	12	£7.95	Contract Master	45.3% ✓	£95.40
SizeXSSMLXL2XL3XL4XLTotal Ordered0234210012 Blanks free481513921052 On hand417333520610116 DecorationKAT301NAV: front chest print (KINGSWAY ACADEMY) Blanks UC301-NAV on PO-3330, lands Tue 10 Nov

Goods, ex VAT£144.05

Delivery, DPD next dayFree

Net, ex VAT£144.05

VAT at 20%£28.81

Total£172.86

Free delivery over £100 ex VAT.

Margin 40.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-51004

Today 10:24

KAT-51004.csv1 file, 2 rows

	A	B	C	D
1	CODE	COLOUR	SIZES	QTY
2	KAT101ROY	ROYAL	S:1 M:2 L:2 XL:1 2XL:1	7
3	KAT301NAV	NAVY	S:2 M:3 L:4 XL:2 2XL:1	12

How it was mapped

KAT101ROY x S 1, M 2, L 2, XL 1, 2XL 17 x UC101-ROY
KAT301NAV x S 2, M 3, L 4, XL 2, 2XL 112 x UC301-NAV

Read and mapped in 3 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 Primary

AddressDudley DY1

DPD Next DayDPD

1550 0002 0500 41

Kingsway Primary, Kingsway Academy Trust

FAO Claire Spencer

Dudley, DY1

Weight5.9 kg, 19 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

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