From Excel Chaos to ERP: How Ramz Al Badran Aluminum Factory Transformed Their Factory

The Factory Behind the Spreadsheets

Ramz Al Badran Aluminum Factory fabricates windows, doors, and curtain walls for commercial and residential projects across Saudi Arabia. Every order that arrives — a school window package, a villa sliding door set, a tower facade — passes through estimating, procurement, the cutting floor, glazing, and finally delivery. For years, all five stages lived inside Excel.

The system was not careless. It was built up over a decade by people who needed answers quickly, one workbook at a time, until 47 files were quietly holding the business together: one for pricing, one for profiles, one for glass, one for each major client, and a shared folder of cutting sheets nobody fully trusted.

Where the Spreadsheet System Broke

The cracks always appeared at the boundaries between workbooks — the places where a number had to travel from one person to another by hand.

• Revision drift: a client changed a window height and two workbooks kept the old dimension. The cutting list was cut from the wrong revision.
• Blind stock: nobody could say how much of a 6.5-metre profile was left without walking the yard, so material was re-ordered while offcuts sat in the racks.
• Estimating by memory: quotes depended on whichever estimator picked up the phone, so two customers could be quoted differently for identical work.
• Invisible production: a salesperson could not confirm whether an order was cut, glazed, or waiting on glass without a WhatsApp round trip to the floor.

What the Factory Actually Needed

The brief we received was short and unusually precise. It named outcomes rather than software features, which made the project far easier to scope.

• A single record per order, from first enquiry to final delivery.
• Cutting optimization planned against real profile stock, including offcuts.
• Automatic glass takeoff tied to the same window schedule used for pricing.
• Bilingual quotations in Arabic and English generated from that one data set.
• Live shop-floor status that anyone in the company could check without asking.

Migrating 47 Workbooks Without Stopping Production

The factory could not pause for a migration, so we retired the spreadsheets feature by feature rather than file by file. The master pricing and profile catalogues moved first, because every other workbook depended on them. Open orders — 60 were in flight — were then imported with their window schedules intact.

Historical jobs stayed in Excel. There was no reason to migrate ten years of completed projects; they needed to remain readable, not become live data. That single decision removed most of the migration risk before it could appear.

From Enquiry to Cutting List in One Flow

The workflow that replaced the workbooks is deliberately linear. Each step consumes the output of the step before it, so no number is ever typed twice.

1. Enquiry capture: the sales engineer logs the project, client, and drawings in one place.
2. Window schedule: each opening is entered once with type, dimensions, glazing, and finish.
3. Quotation: the bilingual quote is generated from that schedule and the live price catalogue.
4. Release to production: once accepted, the same schedule becomes the production order with no re-keying.
5. Cutting plan: profiles are optimized against available stock and remnants return to inventory.
6. Shop floor: cutting, welding, glazing, and packing each mark their own stage complete.

Cutting Optimization and Offcut Recovery

Aluminium is where a fabrication business quietly loses money. A 6.5-metre profile cut in the wrong sequence leaves a remnant too short for the next job and too long to throw away. WindowCraft Pro plans every bar against the whole order book instead of one window at a time, so a remnant from a school project can be assigned to a villa order scheduled the same week.

Within a quarter, measured profile waste at Ramz Al Badran fell from double digits to low single digits — the kind of saving that never appears on an invoice but shows up unmistakably in year-end margin.

The Numbers After Ninety Days

Three months after cutover, the picture on the floor looked different.

• Throughput up 230% against the same floor area and the same headcount.
• Quote turnaround down from two days to under an hour for a standard window package.
• Revision rework effectively eliminated, because one schedule now drives both the quote and the cutting list.
• Stock accuracy: the month-one physical count differed from the system by a single bar.

What Other Fabricators Should Take From This

Every factory is different, but three lessons travelled well beyond this project.

• Migrate the catalogue first. Pricing, profiles, glass, and finishes are what every other document depends on. Everything else is downstream.
• Do not migrate history. Retiring finished projects to a read-only archive is faster, cheaper, and far less risky than importing them.
• Pick one record of truth. If a number lives in two places, it will eventually disagree with itself. Order first; everything else follows.