01 PLATFORM · TO-BE

Single run replaces the weekly manual merge

One macro pass consolidates the source files and feeds every downstream sheet

Design
Extracts only the mapped fields, on a fixed schema
Consolidation
New files are collected and sorted from one folder
Downstream
Demand, stock and order sheets update with no re-entry
Source files
→
One run
→
Merged output

Drop in the folder, run once — merge through to ordering is automatic

→ The manual merge step is gone entirely

Programme completion report 6 / 20
01

PART 1

Automated data consolidation

Owner: Planning & Procurement

00 OVERVIEW · EXECUTIVE SUMMARY

Both workstreams are live in day-to-day operations

Workstream 1 · Data consolidation
1 hr → 10 min 83%↓

Macro-driven merge · about 25 hours saved per year

Workstream 2 · Status platform
13 of 13 live

Zero manual input · one platform, five independent views

Built in-house with existing capability — run cost stays at internal effort plus tool subscriptions

18–27
Effort, person-months
5
Independent views
18 → 4
Weeks to delivery
0
Re-entry steps
Programme completion report 2 / 20