Customer file order · Hallmark Facilities
SO-52341
With DPDCustomer file HMF-45101.csv from Hallmark Facilities’ own system on Mon 2 Nov at 10:51, read and mapped to the Contract Master in 3 s. For Mon 9 Nov by DPD next day. Owner Hannah Price. Hallmark Facilities, corporate and services, price band B, 4 contract lines.
Website
Portal
Customer file
HMF-45101.csv, mapped in 3 s
Phone or email
Net, ex VAT
£69.50
£90.54 inc VAT, with charges
Margin
32.4%
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 |
|---|---|---|---|---|---|
UC101 Uneek Classic Polo, Navy HMF101NAV · plain UC101-NAV · Sizes XS to 4XL · Contract Master | 10 | £6.95 | Contract Master | 32.4% ✓ | £69.50 |
SizeXSSMLXL2XL3XL4XLTotal Ordered0133210010 Blanks free000000000 On hand24700070242323234 DecorationHMF101NAV: left chest embroidery (HALLMARK FACILITIES) Blanks UC101-NAV on PO-3330, lands Tue 10 Nov | |||||
Goods, ex VAT£69.50
Delivery, DPD next day£5.95 ex VAT
Net, ex VAT£75.45
VAT at 20%£15.09
Total£90.54
Under £100 ex VAT, so £5.95 DPD delivery is added to the invoice that goes to Xero.
Margin 32.4% 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
1 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-45101
2 Nov 10:51
HMF-45101.csv1 file, 1 row
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | HMF101NAV | NAVY | S:1 M:3 L:3 XL:2 2XL:1 | 10 |
How it was mapped
- HMF101NAV x S 1, M 3, L 3, XL 2, 2XL 110 x UC101-NAV
Read and mapped in 3 s: their codes to Contract Master lines, their rows into size grids.
Delivery
DPD dispatch →DPD
DPD Next Day
Collected 16:30 Fri 6 Nov
DeliveryMon 9 Nov
AddressSolihull B91
DPD windowdue about 11:31
DPD Next DayDPD
1550 0002 0413 46
Hallmark Facilities
FAO Fiona Rhodes
Solihull, B91
Weight3.2 kg, 10 garments
LabelWith DPD
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-52495
Fri 6 Nov · Hallmark Facilities
£139.50
In production
SO-52408
Wed 4 Nov · Hallmark Facilities
£34.75
In production
SO-52370
Tue 3 Nov · Hallmark Facilities
£99.75
Picking
Audit trail
Customer file HMF-45101.csv received
Customer · 2 Nov 10:51
Read in 3 s: 1 of 1 line matched to Contract Master lines with sizes
Auto · 2 Nov 10:52
Priced at Hallmark Facilities’ own rates: 1 from the Contract Master
Auto · 2 Nov 10:52
Stock checked by size: every line available or due in next day
Auto · 2 Nov 10:52
Credit checked: within the £5,750 limit
Auto · 2 Nov 10:52
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · 2 Nov 10:52
Production lots done on the tablet; booked back in and the pick slip released
Dev · Thu 5 Nov 15:20
Picked and packed, checked by size against the pick slip
Tom · Fri 6 Nov 14:10
Collected by DPD at 16:30; DPD label and tracking emailed to Fiona
DPD · Fri 6 Nov 16:30
Plan: DPD one-hour window from about this time
Planned · Today 11:31