project deep dive

Todos a Aprender — National
Textbook Distribution Program

End-to-end coordination of a Colombian government education program: planning, production, packaging and delivery of 7M+ textbooks across 32 titles to 14,000+ rural schools nationwide — in under 6 months.

2016–2018 Full Project Lead 7M+ books 32 titles 14,000+ schools Panamericana Formas e Impresos < 6 months delivery
7M+

textbooks produced & delivered

32

simultaneous titles

14k+

rural schools nationwide

<6mo

full production to delivery

the moment

In the project kickoff meeting — immediately after the contract was awarded — William presented on-the-spot calculations of the program's full operational scope: warehouse space required, total box volume, packaging constraints, logistics throughput. Numbers nobody else in the room had. The general manager assigned him full project leadership on the spot, from that meeting through final delivery. He then built the complete process flow — planning, production, packaging, traceability and logistics coordination — from the ground up.

the program

Colombia's Todos a Aprender government initiative distributed educational materials to public schools in underserved and rural areas. Panamericana won the contract to produce and deliver the full batch — one of the largest single-run textbook logistics operations in the country's education system.

the complexity

This wasn't a single book run. It was 32 different titles simultaneously — each with its own production specs, quantities, packaging requirements and school-level allocation. Every title had to reach the right school, in the right quantity, with full government-grade traceability. At national scale.

what failure meant
  • Children without materials at the start of the school year — a direct educational impact affecting thousands of students in rural communities.
  • Contractual penalties — the government contract had strict delivery and traceability requirements with financial consequences for any failures.
  • National reputational risk — a program of this visibility, tied to a government initiative, left no room for error in execution or reporting.
01 / volume

7M+ Books, 32 Titles

Simultaneously managing production runs for 32 different titles — each with independent materials, specs, timelines and per-school allocation quantities.

02 / geography

14,000+ Rural Schools

Deliveries reaching schools across every department of Colombia, including remote rural areas requiring coordination with two external logistics operators.

03 / traceability

Government-Grade Tracking

Every box and pallet had to be traceable to the specific school destination — from the production floor through both logistics companies to final delivery confirmation.

04 / speed

Under 6 Months Total

The entire operation — planning, procurement, production, packaging, labeling and national distribution — executed in less than 6 months with a fixed school-year deadline.

05 / suppliers

Multi-Vendor Coordination

Materials procurement, print production and two independent logistics companies — all coordinated to a single synchronized delivery schedule.

06 / simultaneity

No Sequential Option

The deadline forced parallel execution across all 32 titles at once — there was no room to complete one title before starting the next. Everything ran at the same time.

01 / planning
Production Planning & Material Requirements
Defined the full production plan: sequencing 32 titles across available press capacity, calculating material requirements per title, and aligning procurement timelines to ensure zero stockout during production. Planning criteria combined geographic delivery zones, title allocation quantities and press availability.
MRPproduction scheduling32-title matrixcapacity planning
02 / production monitoring
Daily Production Tracking Against Delivery Windows
Monitored production output daily across all running titles, tracking actual vs. planned volumes and flagging deviations before they created downstream logistics conflicts. Adjusted scheduling dynamically when production runs fell behind or material arrivals shifted.
daily KPIsdeviation managementdynamic rescheduling
03 / packaging
Packaging Methodology & Logistics-Ready Labeling
Designed the full packaging system: box configurations per title mix, pallet build standards optimized for truck loading, and school-level labeling that made each unit identifiable throughout the distribution chain without manual lookup.
box configpallet standardsschool-level labelinglogistics optimization
04 / traceability software
Custom Tracking & Labeling Tool — Built In-House
Designed and built a proprietary software tool for box and pallet tracking and label generation. Enabled real-time traceability of every unit across both logistics operators and all 14,000+ delivery points. Government reporting was produced directly from the system.
custom softwaredatabasebarcode labelingreal-time tracking
05 / logistics coordination
Dual Logistics Operator Management
Coordinated two external logistics companies across the full national distribution: defining KPIs, delivery sequencing, escalation protocols and reporting standards. Maintained accountability across both operators while keeping the operation synchronized to the government timeline.
3PL coordinationKPI definitionnational distributioncompliance reporting
tracking_system.exe — custom build

Proprietary Box & Pallet Tracking System

Generated school-specific labels for every box and pallet, encoding destination, title, quantity and routing data for both logistics companies.
Tracked every unit from the production floor through packaging, warehouse and final delivery — providing a real-time status view across 14,000+ destinations.
Produced government-compliant delivery reports at school and municipality level directly from the tracking database — no manual reconciliation required.
Operated simultaneously across both logistics operators, consolidating data from two independent distribution chains into a single traceability record.
Custom DB (Access) Barcode Labeling Real-time Tracking Government Reporting Dual Logistics Integration 14,000+ Destinations

Volume + Simultaneity — No Margin for Sequential Execution

The single largest operational challenge was that every component of the project had to run in parallel. 32 titles in production at the same time, materials arriving from multiple suppliers on overlapping schedules, packaging and labeling running concurrently with production, and two logistics companies dispatching simultaneously — all with a fixed school-year deadline that couldn't move.

How I handled it: Multi-criteria production scheduling that balanced geographic delivery zones, per-title quantities and press capacity simultaneously. Daily tracking of actual vs. planned throughput per title. A packaging and traceability system designed to process output as it came off the line — not as a sequential step after production finished.
7M+ books delivered on time to 14,000+ schools before the school year start — zero missed delivery windows on the government contract.
32 titles managed simultaneously from production planning through final delivery, with no title blocking another.
Full government traceability compliance — every unit trackable to its destination school, with reporting produced directly from the custom tracking system.
Zero contractual penalties — the program met all delivery, quantity and documentation requirements set by the Ministry of Education.
Reusable traceability asset — the custom tracking software built for this project became a reusable tool for subsequent similar contracts at Panamericana.
key takeaway

This project demonstrates what happens when operational intelligence meets structured execution under pressure. The ability to calculate the full dimension of a 7-million-book national operation on the spot, then build the planning, production, packaging, software and logistics infrastructure to execute it — all in under 6 months, with government-grade traceability and no room for error — is the kind of capability that doesn't come from a job description. It comes from years of understanding how physical operations actually work.