Status: non-binding draft pending data-volume/edge-case discovery, definition approver, accessibility needs, VAT, fixed-price director approval, and legal/finance terms review.
Proposed outcome: a documented, repeatable standardization process for the three supplied current CSV formats; no guaranteed reduction or ongoing processing. Deliverables/acceptance: D1 approved canonical dictionary—each supplied field/category has definition, owner/approval status; D2 three mappings—representative samples transform to agreed canonical fields with exceptions logged; D3 validation checklist/test pack—normal, blank, unknown-label, duplicate and format-change cases have expected results; D4 training/guide—90-minute session delivered, guide covers run/review/escalation; two review rounds included. Client supplies NDA, samples, current list, representative edge cases, approver, and timely feedback.
Estimated time: 6 + 18-24 + 8-12 + 6 + 6 = 44-54h. Time-and-materials option: £3,740-£4,590 excluding VAT (44×85; 54×85), billed only under approved terms. Fixed-price calculation cannot be final until buffer chosen/approved: range before buffer £3,740-£4,590; a 15% maximum would be £4,301-£5,278.50, not a quoted price. Supplier director must set one figure after discovery.
Schedule assumption: NDA, three representative exports, category list, approver, and accessibility needs by 4 Sep; start 7 Sep; discovery week 1; draft mapping/checklist week 2; review/training/handover by 30 Sep. Late inputs or changed source formats trigger written change estimate, not silent compression. Exclusions: software build, API, ongoing runs, additional formats, data correction decisions, travel.
Options: A T&M range retains uncertainty; B fixed price only after a paid/approved discovery gate; C smaller phase delivers dictionary plus one-source mapping, with other mappings separately priced. Payment 40/60 is proposed, not approved. Use standard contract for IP/confidentiality. Pre-send gates: client questions, finance VAT, director pricing, legal terms, date capacity, PDF accessibility. No signature block until authorized.