Customer file order · Hallmark Facilities
SO-52495
In productionCustomer file HMF-65752.csv from Hallmark Facilities’ own system on Fri 6 Nov at 07:21, read and mapped to the Contract Master in 5 s. For Fri 13 Nov by DPD next day once decorated. Owner Hannah Price. Hallmark Facilities, corporate and services, price band B, 4 contract lines.
Website
Portal
Customer file
HMF-65752.csv, mapped in 5 s
Phone or email
Net, ex VAT
£139.50
£167.40 inc VAT
Margin
32.3%
GP floor 26% a line
Lines at Hallmark Facilities’ 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 |
|---|---|---|---|---|---|
R331 Result Softshell Jacket, Black HMF331BLK · plain R331-BLK · Sizes S to 3XL · Contract Master | 5 | £19.95 £20.00 | Contract Master | 29.8% ✓ | £99.75 |
SizeSMLXL2XL3XLTotal Ordered1121005 Blanks free1202442561463810814 On hand16132034019459101084 DecorationHMF331BLK: left chest embroidery (HALLMARK FACILITIES) | |||||
SS6 Fruit of the Loom Polo, White HMF6WHT · plain SS6-WHT · Sizes S to 3XL · Contract Master | 5 | £7.95 | Contract Master | 38.4% ✓ | £39.75 |
SizeSMLXL2XL3XLTotal Ordered1121005 Blanks free92417112366 On hand5310511264193356 DecorationHMF6WHT: left chest embroidery (HALLMARK FACILITIES) | |||||
Goods, ex VAT£139.50
Delivery, DPD next dayFree
Net, ex VAT£139.50
VAT at 20%£27.90
Total£167.40
Free delivery over £100 ex VAT.
Margin 32.3% 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
£3,809 of the £5,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 retypingFromPurchasing, Hallmark Facilities
Toinfo@cwear.co.uk
SubjectOrder file HMF-65752
Fri 6 Nov 07:21
HMF-65752.csv1 file, 2 rows
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | HMF331BLK | BLACK | S:1 M:1 L:2 XL:1 | 5 |
| 3 | HMF6WHT | WHITE | S:1 M:1 L:2 XL:1 | 5 |
How it was mapped
- HMF331BLK x S 1, M 1, L 2, XL 15 x R331-BLK
- HMF6WHT x S 1, M 1, L 2, XL 15 x SS6-WHT
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 Thu 12 Nov
DPD Next DayDPD
1550 0002 0470 44
Hallmark Facilities
FAO Fiona Rhodes
Solihull, B91
Weight3.2 kg, 10 garments
LabelPrints 15:00 Thu 12 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
HFHallmark Facilities
C-1021 · Corporate and services · Solihull · since 2021
PricesBand B, 10% off list, 4 contract lines
Terms30 days end of month
Credit£3,809 of £5,750
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Other orders from Hallmark Facilities
SO-52552
Today · Hallmark Facilities
£259.30
Confirmed
SO-52517
Fri 6 Nov · Hallmark Facilities
£31.80
In production
SO-52408
Wed 4 Nov · Hallmark Facilities
£34.75
In production
SO-52370
Tue 3 Nov · Hallmark Facilities
£99.75
Picking
SO-52341
2 Nov · Hallmark Facilities
£69.50
With DPD
Audit trail
Customer file HMF-65752.csv received
Customer · Fri 6 Nov 07:21
Read in 5 s: 2 of 2 lines matched to Contract Master lines with sizes
Auto · Fri 6 Nov 07:22
Priced at Hallmark Facilities’ own rates: 2 from the Contract Master
Auto · Fri 6 Nov 07:22
Stock checked by size: every line available or due in next day
Auto · Fri 6 Nov 07:22
Credit checked: within the £5,750 limit
Auto · Fri 6 Nov 07:22
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · Fri 6 Nov 07:22
Next: lots done, pick slip released, collected by DPD Thu 12 Nov
Planned · Wed 11 Nov 15:00