Customer file order · Sterling Guard Glasgow

SO-52455

In production

Customer file SGS-51629.csv from Sterling Guard Security’s own system on Thu 5 Nov at 07:12, read and mapped to the Contract Master in 5 s. For Thu 12 Nov by DPD next day once decorated. Owner Hannah Price. Sterling Guard Security, security, price band A, 5 contract lines.

Website

Portal

Customer file

SGS-51629.csv, mapped in 5 s

Phone or email

Net, ex VAT

£322.70

£387.24 inc VAT

Margin

38.9%

GP floor 26% a line

Sterling Guard Security

Lines at Sterling Guard Security’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
PWVEST Portwest Hi-vis Vest, Yellow SGSPWVESTYLW · plain PWVEST-YLW · Sizes S/M to 4XL/5XL · Contract Master	6	£5.95	Contract Master	43.7% ✓	£35.70
SizeS/ML/XL2XL/3XL4XL/5XLTotal Ordered22116 Blanks free7485016175 On hand174198239413 DecorationSGSPWVESTYLW: back print (SECURITY) Blanks PWVEST-YLW on PO-3331, lands Tue 10 Nov
UC101 Uneek Classic Polo, Black SGS101BLK · plain UC101-BLK · Sizes XS to 4XL · Contract Master	9	£9.95	Contract Master	30.2% ✓	£89.55
SizeXSSMLXL2XL3XL4XLTotal Ordered013320009 Blanks free1619353217540128 On hand1968136145822540479 DecorationSGS101BLK: left chest embroidery (STERLING GUARD), back print (SECURITY) Blanks UC101-BLK on PO-3330, lands Tue 10 Nov
TRA620 Regatta Fleece, Black SGS620BLK · plain TRA620-BLK · Sizes S to 3XL · Contract Master	11	£17.95	Contract Master	42.1% ✓	£197.45
SizeSMLXL2XL3XLTotal Ordered23321011 Blanks free133026171289 On hand35717543132239 DecorationSGS620BLK: left chest embroidery (STERLING GUARD) Blanks TRA620-BLK on PO-3331, lands Tue 10 Nov

Goods, ex VAT£322.70

Delivery, DPD next dayFree

Net, ex VAT£322.70

VAT at 20%£64.54

Total£387.24

Free delivery over £100 ex VAT.

Margin 38.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

3 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

£79,301 of the £125,750 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, Sterling Guard Security

Toinfo@cwear.co.uk

SubjectOrder file SGS-51629

Thu 5 Nov 07:12

SGS-51629.csv1 file, 3 rows

	A	B	C	D
1	CODE	COLOUR	SIZES	QTY
2	SGSPWVESTYLW	YELLOW	S/M:2 L/XL:2 2XL/3XL:1 4XL/5XL:1	6
3	SGS101BLK	BLACK	S:1 M:3 L:3 XL:2	9
4	SGS620BLK	BLACK	S:2 M:3 L:3 XL:2 2XL:1	11

How it was mapped

SGSPWVESTYLW x S/M 2, L/XL 2, 2XL/3XL 1, 4XL/5XL 16 x PWVEST-YLW
SGS101BLK x S 1, M 3, L 3, XL 29 x UC101-BLK
SGS620BLK x S 2, M 3, L 3, XL 2, 2XL 111 x TRA620-BLK

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

Delivery

DPD

DPD Next Day

Collected 16:30 Wed 11 Nov

DeliveryThu 12 Nov, Sterling Guard Glasgow

AddressGlasgow G1

DPD Next DayDPD

1550 0002 0455 64

Sterling Guard Glasgow, Sterling Guard Security

FAO Marcus Hale

Glasgow, G1

Weight8.0 kg, 26 garments

LabelPrints 15:00 Wed 11 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

Sterling Guard Security

C-1005 · Security · 4 sites · since 2015

PricesBand A, 15% off list, 5 contract lines

Terms30 days end of month

Credit£79,301 of £125,750

Orders byCustomer file

Short stockpart-ship and back-order

RepHannah Price