Customer file order · Westbrook College
SO-52433
In productionCustomer file WBC-53753.csv from Westbrook College’s own system on Wed 4 Nov at 11:28, read and mapped to the Contract Master in 6 s. For Wed 11 Nov by DPD next day once decorated. Owner Hannah Price. Westbrook College, education, price band B, 2 contract lines.
Website
Portal
Customer file
WBC-53753.csv, mapped in 6 s
Phone or email
Net, ex VAT
£103.35
£124.02 inc VAT
Margin
41.9%
GP floor 26% a line
Lines at Westbrook College’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 |
|---|---|---|---|---|---|
UC301 Uneek Classic T-shirt, Navy WBC301NAV · plain UC301-NAV · Sizes XS to 4XL · Contract Master | 3 | £7.95 | Contract Master | 45.3% ✓ | £23.85 |
SizeXSSMLXL2XL3XL4XLTotal Ordered001110003 Blanks free481513921052 On hand417333520610116 DecorationWBC301NAV: front chest print (WESTBROOK COLLEGE) Blanks UC301-NAV on PO-3330, lands Tue 10 Nov | |||||
UC101 Uneek Classic Polo, Royal WBC101ROY · plain UC101-ROY · Sizes XS to 4XL · Contract Master | 10 | £7.95 | Contract Master | 40.9% ✓ | £79.50 |
SizeXSSMLXL2XL3XL4XLTotal Ordered0133210010 Blanks free1528545331440189 On hand1659118125712240415 DecorationWBC101ROY: left chest embroidery (WESTBROOK COLLEGE) | |||||
Goods, ex VAT£103.35
Delivery, DPD next dayFree
Net, ex VAT£103.35
VAT at 20%£20.67
Total£124.02
Free delivery over £100 ex VAT.
Margin 41.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
£2,540 of the £3,000 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, Westbrook College
Toinfo@cwear.co.uk
SubjectOrder file WBC-53753
Wed 4 Nov 11:28
WBC-53753.csv1 file, 2 rows
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | WBC301NAV | NAVY | M:1 L:1 XL:1 | 3 |
| 3 | WBC101ROY | ROYAL | S:1 M:3 L:3 XL:2 2XL:1 | 10 |
How it was mapped
- WBC301NAV x M 1, L 1, XL 13 x UC301-NAV
- WBC101ROY x S 1, M 3, L 3, XL 2, 2XL 110 x UC101-ROY
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 Tue 10 Nov
DPD Next DayDPD
1550 0002 0447 50
Westbrook College
FAO Phil Archer
Leicester, LE1
Weight4.1 kg, 13 garments
LabelPrints 15:00 Tue 10 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
WCWestbrook College
C-1008 · Education · Leicester · since 2016
PricesBand B, 10% off list, 2 contract lines
Terms30 days end of month
Credit£2,540 of £3,000
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Audit trail
Customer file WBC-53753.csv received
Customer · Wed 4 Nov 11:28
Read in 6 s: 2 of 2 lines matched to Contract Master lines with sizes
Auto · Wed 4 Nov 11:29
Priced at Westbrook College’s own rates: 2 from the Contract Master
Auto · Wed 4 Nov 11:29
Stock checked by size: every line available or due in next day
Auto · Wed 4 Nov 11:29
Credit checked: within the £3,000 limit
Auto · Wed 4 Nov 11:29
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · Wed 4 Nov 11:29
Next: lots done, pick slip released, collected by DPD Tue 10 Nov
Planned · Today 15:00