Software AI Business Management System Custom ERP Software Custom CRM Software Manufacturing ERP Software Jewellery Software Diamond Software Replace Excel & Tally Yukti AI CRM (product) Automation & AI AI Automation Agency in Surat WhatsApp Automation WhatsApp AI Chatbot AI Agents Voice AI Agents Workflow & n8n Automation GeM Tender Automation AI Consulting Web & Apps Web & Mobile Apps Shopify Store Development Industries Diamond & Jewellery Manufacturing Textile & Apparel Retail & E-commerce Logistics & Transport Travel & Tourism Real Estate Healthcare & Pharma All industries Company Work / Case Studies About Blog AI Automation Cost Free SEO Audit Contact
Glass & aluminium ERP in Surat · Case study · Cutting optimisation · AI & automation for fabricators · Gujarat

Glass and aluminium ERP from Surat: site measurement to GST quotation and project stages for a glass fabricator, length-wise aluminium stock with automatic cutting optimisation for a profile trader, and the AI and automation a fabrication business can add

Looking for glass fabrication software, aluminium section trading software or a cutting optimiser that knows your stock? Yukti AI, a software company in Surat, built one glass and aluminium ERP for two Gujarat businesses: Multiple Glass Solutions, which measures, fabricates and installs shower enclosures, partitions, mirrors and railings, and KJ Alutech, which trades aluminium profiles and cuts them to length. The glass side runs from the enquiry to a measurement sheet in feet, inches or millimetres, an estimate whose hardware is added by rules, a GST quotation with revisions, and a 13-stage project board that shows margin against material actually issued. The aluminium side keeps every bar and every remnant as its own record and plans each cut with a Best Fit Decreasing optimiser that charges saw kerf, respects a minimum remnant length and compares a full-bars-only plan with a remnants-first plan. This page shows the build, the worked numbers behind the cutting planner, and the AI and WhatsApp automation that can be added on top.

In a glass and aluminium works, money is lost at two places most software never sees: the tape measure and the saw. A panel measured as 6’3” on site and typed as 6.3 feet in the office is a remake. A 20 FT aluminium bar cut without a plan leaves offcuts that nobody records, so the next job opens a fresh bar while usable lengths lie on the rack. Yukti AI built the glass and aluminium ERP around those two points: measurements are stored to a thousandth of an inch whatever unit the site team uses, area is calculated as width × height ÷ 144 with the company’s own rounding and minimum billable area, hardware such as hinges, handles and seals is added by configurable rules, and on the aluminium side the cutting planner picks bars and remnants, charges kerf on every cut, keeps leftovers above the minimum as stock with their own IDs and books the rest as scrap. It is the working version built around the two businesses’ workflows, with records kept in the browser; daily use and results are not claimed.

Enquire

Glass and aluminium ERP software in Surat – enquire

Yukti AI, a software company in Surat, builds ERP, CRM, WhatsApp and AI automation for glass fabricators, aluminium section traders and window, door, partition and shower-enclosure fabricators in Surat, Gujarat and across India. The case study below shows a real build; this box tells you what you get and how to start.

  • What you get: enquiries, site measurement sheets, estimation with hardware rules, GST quotations, sales orders, project stages, glass and hardware stock, material issues, and for aluminium traders a profile master, piece-wise bar and remnant stock, a cutting planner, cutting jobs, wastage reports, challans, invoices, payments and ledgers — with WhatsApp and AI added when you are ready.
  • Built around your shop: your product categories, hardware rules, bar lengths, kerf, minimum remnant, roles and documents, not a generic template.
  • From price: a custom ERP from Yukti AI starts from ₹30,000; the final quote for a system of this breadth is given after a free 30-minute workflow audit. See custom ERP cost in India.
  • Where we are: 220, Leonard Square, Yogichowk, Varachha, Surat – 395006, Gujarat.
  • Next step: send one recent quotation and one cutting list, and we will show what one system would replace.
Quick answer

What is the best ERP for a glass fabrication and aluminium profile business?

The best ERP for a glass and aluminium works is one that starts at the site measurement and ends at the saw. For the glass side it must take panel sizes in feet, inches or millimetres without conversion mistakes, turn them into billable area with the shop’s own rounding and minimum, add hinges, handles, seals, spigots and channels by rules the shop controls, produce a GST quotation that can be revised and converted, and then track the project through measurement, advance, procurement, processing, installation and final payment while showing the real margin after material has been issued. For the aluminium side it must treat every bar and every leftover as its own record, plan cuts against that real stock with saw kerf and a minimum remnant length, show whether using remnants first actually helps, and update stock in one step when the cut is executed. Yukti AI, a software company in Surat, built exactly this for Multiple Glass Solutions and KJ Alutech: 23 screens for the glass business, 28 for the aluminium business, 6 roles, one shared platform with separated data. It is the working version built around the two businesses’ workflows, with records kept in the browser. Ready-made window-estimation apps and stand-alone cutting optimisers cover one slice each; this build connects the slices. The service page for the category is fabrication ERP software; this page is the case study and the cutting-optimisation detail.

How can AI and automation help a glass and aluminium fabricator?

Records first, automation second, AI third. The ERP records measurements, estimates, quotations, projects, pieces, cuts and money. Automation acts on those records — in this build, hardware lines re-sync when panels change, estimates become quotations and orders, stock availability is checked while an order is typed, the cutting plan is generated and compared, and execution writes every stock movement at once. WhatsApp automation can send quotations, stage updates and challans from ERP events, and AI can read a site sketch or a voice note into a draft measurement sheet, turn a cut list sent on WhatsApp into a cutting plan, re-cost open quotations when aluminium or glass rates change, and brief the owner each morning. No AI model is inside this version; the AI items are buildable by Yukti AI and rest on systems it has already built: an AI quotation engine for a box maker, a WhatsApp AI sales agent, voice AI payment reminders and an owner’s copilot over live ERP data. See ERP-connected AI agents for how the layer is added.

Executive summary

Quick facts

ClientsMultiple Glass Solutions (customised glass fabrication and installation) and KJ Alutech (aluminium profile trading and length-wise cutting), Gujarat
IndustryGlass and aluminium works: shower enclosures, frameless and slim-profile partitions, LED and SS PVD designer mirrors, glass railings, frameless and framed sliding systems and custom glass (9 product categories); aluminium profiles such as slim partition sections, shower channels, sliding tracks, U-channels, handrail tubes, base channels, L angles and H sections in powder-coated, anodised and PVD finishes, sold per running foot or per kg
ProblemSite measurements in mixed units re-typed by hand, estimates that forget hardware, quotations revised by overwriting, projects tracked on phone calls, and on the aluminium side stock counted as a quantity so offcuts were invisible and fresh bars opened while remnants lay on the rack
SolutionOne glass and aluminium ERP with a business selector: enquiries, measurement sheets, estimation calculator, quotations, sales orders, 13-stage projects, glass and hardware inventory, material issues, suppliers, purchases, invoices, payments and ledgers for the glass business; profile master, full-length stock, remnant stock, stock movements, reservations, cutting planner, cutting jobs, wastage reports, purchase orders, goods received, challans, invoices, ledgers and reports for the aluminium business; employees, permissions, settings and audit trail for both
Core mechanicsLengths stored as integer mils (1/1000 inch); area = W × H ÷ 144 with 4 rounding modes and a minimum billable panel area; hardware by factor × basis across 10 bases; wastage on material only; margin as markup on cost; every bar and remnant one record with its own ID; cutting consumes the parent and creates children; kerf charged per cut and capped by what is left; leftovers at or above the minimum remnant become stock, shorter ones scrap; Plan A (full bars only) vs Plan B (remnants first)
Screens23 for Multiple Glass Solutions in 7 groups; 28 for KJ Alutech in 8 groups
Roles6: owner, admin, sales executive, inventory manager, accountant, production operator; 16 modules × 5 actions (view, create, edit, delete, approve)
Optimiser defaultsKerf 0.125 inch, minimum remnant 2 FT, both per company with per-profile override; 3 cut orderings tried, cheapest plan kept
StackVite 5, React 18, TypeScript 5.6, React Router 6, Zustand 5 (persisted to LocalStorage), Tailwind CSS 3.4, Recharts; about 32,500 lines of TypeScript in 73 files
ConnectionsNone in this version: no server database, Tally, e-invoice, WhatsApp or AI model; all are listed as buildable
StatusThe working version built around the two businesses’ workflows, with records kept in the browser; usage and results are not claimed
Inside the system

What the two teams work in

Screens from the glass and aluminium ERP built by Yukti AI for Multiple Glass Solutions and KJ Alutech. Figures, customer names, project names and staff names visible in the screenshots come from the sample dataset the screens were set up with; they are not either company’s business numbers.

Cutting Planner screen of the KJ Alutech aluminium ERP by Yukti AI: required lengths of 6, 5 and 3 FT with quantities, profile and colour selector, machine settings for kerf and remnant policy, summary tiles for bars opened, material utilisation, new remnants and scrap plus kerf, and a Plan A versus Plan B comparison showing full bars opened, remnants consumed, material pulled, kerf loss, new remnants, scrap, shortage and utilisation, with a note that the results are heuristic from a Best Fit Decreasing algorithm with remnant prioritisation
Cutting planner — the lengths the customer needs, the profile and colour, kerf and remnant policy, and Plan A (full bars only) against Plan B (remnants first): bars opened, remnants consumed, material pulled, kerf, new remnants, scrap and utilisation, with the screen’s own note that the plan is a heuristic for the saw, not a claim of mathematical optimality.
Site measurement sheets in the Multiple Glass Solutions ERP: panel-wise width, height and quantity entered in feet, inches or millimetres, panel roles such as fixed, door and sliding shutter, glass thickness and grade per panel, site notes and a print option
Measurement sheets — panel by panel, width × height × quantity in the unit the site team used, panel role, glass thickness and grade, carpenter-style display and a printable sheet.
Estimation Calculator of the glass ERP: billable glass area, total cost, selling price, gross margin and grand total tiles, an estimate header with customer, project, date, transport and a linked measurement sheet, a product category picker, and a live cost summary split into glass and processing, aluminium profile, hardware and accessories, extras, wastage, labour, installation, margin and transport before GST
Estimation calculator — pull panels from a measurement sheet, pick the product category, and the glass, profile, hardware, wastage, labour, installation, margin and selling price recalculate live, with every rule editable in the product master.
Quotations list of the glass ERP: tiles for quotation count, open value, won, conversion rate and average margin, a quoted-versus-won chart by month, status tabs for draft, sent, approved, converted and rejected, and rows with quotation number, revision, customer and subject, validity date, margin, status and total
Quotations — revision history, validity, approval status and one-click conversion to a sales order, with quoted-versus-won by month and margin per quotation on the list.
Project Kanban board of the glass ERP with columns for the 13 project stages from enquiry received and site measurement through estimation, quotation sent, order confirmed, advance received, material procurement, glass processing, hardware procurement, installation scheduled, installation completed, final payment and project closed, with project cards that can be dragged between stages
Project Kanban — 13 stages grouped into pre-sales, execution, site and closure; drag a card to move a project, with stage history, checklist tasks and the margin against material issued on each project.
Glass inventory screen of the glass ERP: glass items by thickness, grade and finish with stock in square feet, reserved and available quantity, minimum stock, stock groups and movement types including issue, wastage, breakage and site return
Glass inventory — stock by thickness, grade and finish in square feet, reserved and available, minimum levels, and movements such as issue to a project, wastage, breakage and site return.
KJ Alutech dashboard in the aluminium ERP: stock SKUs, running feet in stock, material utilisation, open orders, receivables and payables tiles, with charts for sales and cutting activity and alerts for low stock and pending cutting jobs
Aluminium dashboard — stock SKUs, running feet on hand, material utilisation, open orders, money in and out, and the day’s cutting activity for the trading business.
Full Length Stock screen of the aluminium ERP: profile and colour SKUs with the number of full bars, running feet, weight and stock value, each SKU expandable to the individual bar records with piece ID, length, status such as available or reserved, rack location and landed cost per foot
Full-length stock — every SKU opens to its individual bars: piece ID, length, status, rack location and cost per foot, because receiving 100 bars creates 100 records.
Remnant Stock rack of the aluminium ERP: leftover pieces listed with remnant ID, profile and colour, length, status, rack location, cost per foot, the cutting job that produced each remnant and the parent bar it came from
Remnant stock — each leftover with its own ID, length, location, cost per foot inherited from its parent bar, the job that produced it and the bar it came from, ready for the optimiser to use first.
Cutting Jobs list of the aluminium ERP: jobs with status draft, approved or completed, the order they belong to, profile and colour, pieces required, bars and remnants used, machine and operator, and the printable cutting list for the saw
Cutting jobs — draft, approved and completed jobs with the order, SKU, pieces, bars and remnants used, machine and operator, and a printable cutting list grouped by length.
Wastage Report of the aluminium ERP: material consumed by cutting split into delivered cut pieces, reusable remnants returned to stock, kerf loss and scrap, in running feet and percentage, by profile and by period
Wastage report — what the saw consumed, split into delivered pieces, reusable remnants, kerf loss and scrap, by profile and period.
The two businesses

In glass and aluminium work, money is lost at the tape measure and at the saw

Multiple Glass Solutions measures, fabricates and installs customised glass: shower enclosures, frameless and slim-profile partitions, LED and SS PVD designer mirrors, glass railings, sliding systems and one-off glass work for builders, architects, interior designers, hotels, hospitals and homes. Every job starts on site with a tape, continues in the office as an estimate and a GST quotation, and ends weeks later with toughened glass arriving from the processor, hardware from a dealer, an installation team on a ladder and a final payment to chase. KJ Alutech is the other half of the same trade: it buys aluminium profiles — slim partition sections, shower channels, sliding tracks, U-channels, handrail tubes, base channels, angles and H sections — in full bars of 16, 20 or 21 feet, and sells them cut to the lengths a fabricator needs, per running foot or per kg, in powder-coated, anodised or PVD finishes.

The two businesses lose money in different places. For the glass fabricator it is the measurement and the estimate: a panel written as 6’3” and typed as 6.3 feet is a remake; a shower door quoted without its hinges, handle and seals is a margin that disappears at the hardware shop; an estimate kept in one person’s head cannot be checked when the glass rate changes. For the aluminium trader it is the saw: a bar cut without a plan leaves offcuts that nobody records, so stock on paper says twenty bars while the rack holds eleven full bars and a pile of lengths nobody trusts, and the next order opens a fresh bar while a usable 7-foot remnant sits two racks away. The build’s own seed data describes the glass business as a sister concern of the aluminium trader; whether the two firms are one group is for the owner to confirm, and nothing on this page depends on it.

Yukti AI’s job was to put both flows into one platform without mixing them: a business selector at sign-in, every record tagged with its company, screens that show only the active business, and shared masters for roles, permissions and settings. The result is the glass and aluminium ERP described on this page.

Why this matters for the software

A glass fabrication ERP has to follow the panel: the same width, height, thickness and grade measured on site must drive the billable area, the hardware list, the quotation line, the material issue and the margin. An aluminium trading ERP has to follow the piece: the same bar that was received must be the one the planner allocates, the saw cuts and the challan sells, with its leftover carried forward as a new piece. Billing is the last step, not the system.

Who this is for

Who is this glass and aluminium fabrication ERP for?

The system was designed around a Gujarat glass fabricator-installer and an aluminium profile trader that cuts to length. If you run a glass works that quotes shower enclosures, partitions, mirrors or railings in square feet, an aluminium section shop that sells by the running foot and cuts on a saw, or a window, door, partition or shower-enclosure fabrication unit in Surat, Vadodara, Rajkot, Navsari or anywhere in Gujarat that does both, the problems on this page will sound familiar. It is also a worked answer to the search for fabrication ERP software in Surat and for manufacturing ERP software when the product is cut to size rather than made to a catalogue.

It is a good fit if most of these are true for you:

  • Site measurements come back in feet and inches on one sheet and millimetres on the next, and somebody converts them by hand before quoting.
  • Two people estimate the same shower enclosure and get different hardware lists, or the hardware is remembered only when the installer asks for it.
  • Quotations are revised by overwriting the file, so nobody can say what the customer approved.
  • You know a project is at “glass processing” because the processor told you on the phone, not because the system shows it.
  • Aluminium stock is a quantity per section and colour, so offcuts are either thrown away or lie unrecorded and are never offered to the next job.
  • The operator decides which bar to cut from, and the kerf, the minimum usable leftover and the scrap are nowhere on paper.
  • Invoices and payments sit in Tally or a billing tool that knows nothing about projects, pieces or cuts.

The same design suits neighbouring trades. For a fabrication unit with karigar labour and job costing see the Zunowa fabrication ERP; for a roofing-sheet manufacturer with coil weight, CRM and accounting in one system see the roofing sheet ERP; for costing, production and accounts in a fastener plant see the Laxmi fastener ERP. Yukti AI is in Surat and builds these systems for fabricators across Surat, Gujarat and India; see AI and automation for manufacturing and construction for the wider picture.

The challenge

Why measurement sheets on paper, Excel estimates and quantity-only stock stop being enough

These points are our description of the gaps a system of this kind has to close, drawn from how glass and aluminium works run and from the scope of the build. They are not quotes from either client, and no measurement of the companies’ previous way of working is claimed.

  • Units do not agree. Architects send millimetres, site teams write feet and inches, glass processors want millimetres, and the quotation is in square feet. Every conversion by hand is a chance for a remake.
  • Area is not just width times height. Shops round up to the next quarter or half square foot and bill a minimum area per panel, because a tiny return panel costs as much to process as a bigger one. A spreadsheet rarely applies the rule the same way twice.
  • Hardware is the forgotten margin. Hinges per door, brackets per fixed panel, seals per running foot, spigots per running foot of railing, LED strip around a mirror: each is a small line that is easy to miss and expensive to buy after the quote.
  • Wastage and margin get stacked wrongly. Adding a wastage percentage to labour as well as material, or taking margin on price when the sheet assumed markup on cost, quietly changes the number.
  • Quotation revisions overwrite history. When the customer says “you quoted less last time”, nobody can show the revision they approved.
  • Projects live on the phone. Advance received, glass at the processor, hardware ordered, installation scheduled: thirteen things that each need a person to remember.
  • Aluminium stock as a quantity hides the truth. “Eighteen bars” may be eleven full bars and seven leftovers of different lengths. A quantity cannot answer “can I cut a 7-foot piece without opening a new bar?”
  • The saw has no memory. Kerf, the minimum leftover worth keeping, which remnant was used on which job and what became scrap exist only in the operator’s head.
  • Two businesses, one owner, two sets of books. Shared customers, shared staff and shared settings in two systems means double entry or, worse, one system with mixed data.
Before → after

How the work runs today in most glass and aluminium shops, and how it runs in the system

A general description of the manual way of working in this trade, not a measurement of either client.

Today: measurements on paper, estimates by hand, offcuts wasted

An enquiry comes in on WhatsApp or from an architect. Someone visits the site with a tape and a notebook, writes panel sizes in whatever unit comes naturally, and photographs the page. In the office the sizes are typed into a spreadsheet, converted, multiplied and rounded by memory, and the hardware is listed from experience. A quotation is typed in Word or a billing tool, sent as a PDF, revised twice by editing the same file, and eventually approved on the phone. The project then moves through advance, glass order, hardware purchase and installation with the owner as the only person who knows where it stands. On the aluminium side an order for cut lengths is written on a slip, the operator picks bars from the rack, cuts, and sweeps the leftovers into a corner; stock is adjusted by the number of bars opened, and the leftovers are forgotten until somebody needs exactly that length and does not know they have it.

After: one record from the site to the saw

The enquiry is a record with a status and a follow-up date. The measurement sheet is typed once in feet, inches or millimetres and stored to a thousandth of an inch; the carpenter-style display shows 7’ 3½” to the nearest eighth. The estimate pulls the panels in, applies the category’s glass rate and hardware rules, adds labour, installation, wastage on material, margin and transport, and shows the rate per square foot per line. One click makes a GST quotation; revisions are saved with a note; approval converts it to a sales order and moves the project to Order Confirmed on a 13-stage board. Material issued to the project is costed, and the project page shows order value, estimated cost, material at cost and the margin. For the aluminium trader, each order line is checked against real pieces while it is typed; the cutting planner proposes which bars and remnants to cut and shows a full-bars-only plan beside a remnants-first plan; the approved job prints a cutting list; executing it consumes the parent bars, creates remnant records with their own IDs, books scrap and writes one movement row per change, in a single step. The wastage report then splits what the saw consumed into delivered pieces, remnants back in stock, kerf and scrap.

Before vs after, step by step

How does a typical job change, task by task?

The table walks through the real tasks in a glass works and an aluminium cutting shop and what each looks like in the ERP. The “before” column is a general description of the manual way of working, not a measurement, and no time savings are claimed.

TaskBefore (manual)After (in the system)
Logging an enquiryWhatsApp chat, a note on the deskEnquiry with source (walk-in, reference, architect, Instagram, Google, builder tie-up, repeat, IndiaMART), status, assigned person, follow-up date and lost reason; Convert creates the project and the customer
Measuring the siteNotebook in mixed units, converted laterMeasurement sheet per panel with role, width × height × qty in feet, inches or mm, thickness, grade, finish and colour; stored as mils; printable
Working out billable areaCalculator, rounding by habitW(in) × H(in) ÷ 144 with the company’s rounding mode and minimum billable panel area, per category override
Listing hardwareFrom memory, at the hardware shopRules per category: factor × basis (per door, per fixed panel, per R.ft of height, width or perimeter, per sq.ft, per metre of profile, fixed); lines re-sync when panels change
Pricing the glassOne rate for everythingThickness base rate × grade factor + processing + toughening charge, per panel; 6 thickness rows and 8 grades in the master
Adding labour, wastage and marginLump sum at the endLabour and installation per sq.ft by category, wastage % on material only, margin as markup on total cost, transport at estimate level; rate per sq.ft shown per line
Sending the quotationWord file, overwritten on revisionGST quotation with items in Sq.Ft, R.Ft or Nos, discount, transport, installation, CGST/SGST, round-off, validity, terms; revisions with notes; print-ready A4
Confirming the orderPhone call; retype the jobConvert once to a sales order; project moves to Order Confirmed; the quotation is locked as converted
Tracking the projectOwner’s memory13-stage list and Kanban with checklist tasks, documents, stage history with notes and advance received
Issuing materialNobody writes it downMaterial issue against the project from glass and hardware stock at cost; the project shows order value vs estimated cost vs material issued and the margin
Taking an aluminium orderSlip for the operatorOrder lines by variant, length and qty at rate per ft or per kg; live availability against real pieces: full bars, remnants, reserved and shortage
Planning the cutOperator picks a barCutting planner: Best Fit Decreasing with remnant priority, kerf, minimum remnant, Plan A vs Plan B, to-scale bar diagrams, manual edits
CuttingLeftovers swept asideApproved job with a printable cutting list; execution consumes parents, creates remnant records, books scrap, writes movements in one step
Delivering and billingChallan book, invoice in another toolDelivery challan with vehicle and driver marks pieces sold; GST invoice; receipt; customer ledger and ageing
Knowing the wastageUnknownWastage report: delivered cut pieces vs reusable remnants vs kerf loss vs scrap, by profile and period

Want a glass and aluminium ERP built around your own measurement sheet and your own saw?Send us one recent quotation and one cutting list, and we’ll show you what one system would replace. Free workflow audit, reply the same day.

Book a free audit
One platform, two businesses

Two businesses on one platform: how Multiple Glass Solutions and KJ Alutech share a system without mixing data

The first screen after opening the system is a business selector. The user picks Multiple Glass Solutions or KJ Alutech, then signs in as one of six roles. From that moment every record created — a customer, a measurement sheet, a bar, a cutting job, an invoice — carries a company field, and every list, dashboard and report shows only the active business. Switching business is a click in the sidebar; it changes the navigation (the glass business has 23 screens in 7 groups, the aluminium business 28 screens in 8 groups), the document numbering, the settings and the dashboard, without signing out.

What is shared is the shape, not the data. Both businesses use the same customer types (builder, architect, interior designer, dealer, contractor and others), the same supplier model, the same GST sales and purchase invoice logic with draft, issued, part-paid and paid statuses, the same receipts and payments with ageing, credit and debit notes, the same employee and permission model, the same audit trail, CSV export and print-to-PDF documents. Each business has its own company settings: default unit, area rounding and minimum panel area for the glass side; kerf, minimum remnant and bar lengths for the aluminium side; wastage, margin, GST, quotation validity, credit days and round-off for both.

A glass fabricator that also trades sections, or a trader whose sister firm installs, usually ends up with two logins to two tools and a spreadsheet to reconcile them. Here the owner sees both from one place, and because a customer of the aluminium business can be the glass business itself, the cross-sale of slim partition profiles to the group’s own installation projects is just another order. See custom ERP software for how Yukti AI scopes multi-company builds.

Site measurement

Site measurement to estimation: feet, inches and millimetres on one sheet, stored to a thousandth of an inch

A measurement sheet in the glass ERP belongs to a customer and, usually, to a project. It holds a list of panels; each panel has a label, a role (fixed, door, sliding shutter, return, top, side or panel), a width, a height and a quantity, plus the glass thickness, grade, finish and colour for that panel and any site notes. The entry unit is chosen per sheet — feet, inches or millimetres — and loose text is parsed: 6’3”, 1829mm and 72in are all accepted. Quick-size buttons add the common sizes a shop uses every day.

Internally every length is stored as an integer number of mils, a thousandth of an inch, so 20 feet is 240,000 mils and there is no floating-point drift between what the site team typed and what the processor receives. The display converts back: the carpenter-style format shows 7’ 3½” to the nearest eighth of an inch, the millimetre format shows the metric value for a glass processor, and the print sheet carries both. The same unit library serves the aluminium business, which is why a 6,000 mm bar and a 20 FT bar can live in the same stock list and the same cutting plan.

Area is where shops differ, and the build makes the difference a setting rather than a habit. Area per panel is width in inches times height in inches divided by 144, which gives square feet. The company then chooses one of four rounding modes — exact, up to the next quarter square foot, up to the next half, or up to the next whole — and a minimum billable panel area. The glass business defaults to quarter-square-foot rounding with a 4 sq.ft minimum, and a product category can override the minimum: the build’s defaults use a higher minimum for shower enclosures, partitions and railings, because a small return panel still has to be cut, polished and toughened. All of these are editable in the product master and company settings.

Worked example

A worked estimation example: a hinged shower door with a fixed panel, from inches to billable square feet to hardware

The example below is computed from the build’s rules using its default settings: quarter-square-foot rounding, a minimum billable area, and the shower-enclosure category’s default hardware rules. It is not a client job and the hardware factors are the build’s editable defaults, which the shop confirms, not industry facts. Rupee rates are left out on purpose; the master holds them and they are the shop’s own.

PanelSize as measuredInchesExact area (W × H ÷ 144)Billable (up to next ¼ sq.ft)
Door (hinged)2’ 4” × 6’ 6”28 × 78 = 2,184 sq in15.1667 sq.ft15.25 sq.ft
Fixed panel3’ 3” × 6’ 6”39 × 78 = 3,042 sq in21.125 sq.ft21.25 sq.ft
Billable glass area for the enclosure36.50 sq.ft

Both panels are above the category minimum, so the minimum does not bite here. Where it does bite is the small stuff: an LED mirror measured at 1’ 6” × 2’ 0” is 18 × 24 = 432 sq in, or exactly 3.0 sq.ft, and with the company default minimum of 4 sq.ft and no category override it is billed as 4.0 sq.ft. That one line is the difference between a mirror that pays for its processing and one that does not.

The hardware for the enclosure is produced by the shower-enclosure category’s rules, each written as a factor times a basis. With the build’s defaults and one door panel plus one fixed panel:

Rule (editable default)BasisApplied to this enclosureQuantity on the estimate
2 hinges per doorper door / shutter1 door × 22 nos
1 D-handle per doorper door / shutter1 door × 11 nos
2 wall brackets per fixed panelper fixed panel1 fixed × 22 nos
Magnetic seal per running foot of door heightper R.ft height78 in = 6.5 ft6.5 R.ft
Wiper seal per running foot of door widthper R.ft width28 in = 2.33 ft2.33 R.ft
Silicone, 0.08 tube per running foot of perimeterper R.ft perimeter(2 × (28 + 78) + 2 × (39 + 78)) in = 446 in = 37.17 ft × 0.08 = 2.973 tubes (rounded up, whole units)
1 fixing kitfixedonce per line1 set

Change the door to a sliding two-panel type and the hinge and handle lines fall away while the track and roller lines appear; add a second fixed panel and the bracket count becomes four; remove the door and the seal lines drop to zero and disappear. That is the syncHardwareWithRules behaviour described in the next section: rules recompute when panels change, manual lines and rate overrides are kept.

The money then follows a fixed order. Glass cost per panel is billable area times the glass rate, where the rate is the thickness base rate times the grade factor plus processing, plus the toughening charge when the grade is toughened (the shower default is 10 mm toughened clear). Hardware is quantity times rate per item. Labour and installation are per square foot by category. Wastage, as a percentage, is applied to material only — glass, hardware and profile — never to labour. Margin is a markup on total cost. Transport is added at estimate level. The calculator shows cost, selling price, margin percentage and rate per square foot for each line and for the whole estimate, and the material requirement list shows glass square feet including wastage per thickness and grade, hardware by item and profile metres, ready for purchase. The numbers are live: change the door width and every dependent figure updates.

Estimation rules

Estimation rules that add hardware by themselves: shower enclosures, partitions, railings, mirrors and sliding systems

The product master holds nine categories, each with its default glass (thickness, grade), its labour and installation rates per square foot, its minimum billable area, its billing unit and its list of hardware rules. A rule is a hardware item, a factor and a basis. The ten bases are: fixed (once per line), per panel, per door or shutter, per fixed panel, per square foot, per running foot of perimeter, per running foot of running length, per running foot of height, per running foot of width, and per metre of profile. Items sold in whole units — nos, sets, pairs — are rounded up; items sold by length are not.

  • Shower enclosures — hinges and handle per door, wall brackets per fixed panel, magnetic seal per running foot of door height, wiper seal per running foot of width, silicone per running foot of perimeter, a fixing kit; shower types include L-shape hinged with fixed panel, walk-in, sliding two-panel, corner entry, door with return and bath-tub screen.
  • Frameless partitions — patch fittings per panel and a floor spring per door, billed in square feet.
  • Slim-profile partitions and framed sliding systems — the aluminium profile length is entered on the line and costed per metre, so the profile cost and the glass cost sit on the same estimate; this is where the group’s own aluminium business becomes the supplier.
  • LED mirrors — LED strip as a share of the perimeter, a driver, a touch sensor and a backing board; SS PVD mirrors with their frame hardware.
  • Glass railings — spigots per running foot, base channel, handrail; billed per running foot rather than square foot.
  • Frameless sliding systems and custom work — the same engine with their own defaults, and a free-form line for anything the categories do not cover.

The estimator carries a note of its own on screen: the hardware quantities come from configurable rules, and each factor is to be confirmed with the shop floor in the product master. This page repeats that honestly. The value of the rules is not that the defaults are right for every shop; it is that the shop decides them once, and from then on every estimate by every salesperson lists the same hardware for the same panels. When a rule changes, future estimates follow it; saved estimates keep the lines they were made with, with any manual lines and rate overrides preserved.

The glass rate table has six thickness rows from 4 to 12 mm and eight grades: clear float, toughened clear, toughened frosted, toughened tinted, toughened reflective, low-iron, lacquered and mirror. A grade is a factor on the thickness base rate plus its own processing and, where toughened, a toughening charge. Rates are the shop’s own and are not published here.

Quotations

GST quotation, revisions, expiry and conversion to a sales order

Generate quotation on an estimate turns its lines into quotation items billed in Sq.Ft, R.Ft or Nos, each with a specification text and the measurement text behind it, so the customer sees “10 mm toughened clear, 2’ 4” × 6’ 6” door” and not a bare quantity. The quotation adds a discount percentage, transport, installation, GST split into CGST and SGST (IGST handling exists on invoices for inter-state work), round-off, a validity in days (default 15, configurable), and terms. It prints as an A4 document with the company details, bank details and terms.

Statuses run draft, sent, approved or rejected or expired, and converted. A revision creates a new version with a note and keeps the previous ones, so when a customer asks why the price changed the answer is on screen. Expiry is by validity date. Converting an approved quotation to a sales order is a one-time action: it creates the order, marks the quotation converted and moves the linked project to Order Confirmed. Sales orders have six statuses of their own and are the record from which material is issued and the invoice is raised.

The list view shows what an owner wants at a glance: quotations open, open value, won, conversion rate and average margin on taxable value, with a quoted-versus-won chart by month and the margin on each row. The aluminium business has its own quotations with a 7-day default validity, built from cut-length lines rather than panels.

Projects

The 13-stage project board, with margin against material actually issued

A glass installation is a project, not an order line, and the build treats it that way. Thirteen stages are grouped into four phases: pre-sales (Enquiry Received, Site Measurement, Estimation, Quotation Sent), execution (Order Confirmed, Advance Received, Material Procurement, Glass Processing, Hardware Procurement), site (Installation Scheduled, Installation Completed) and closure (Final Payment, Project Closed). Projects appear as a list and as a Kanban board whose cards drag between columns; each move is written to the stage history with a note and a timestamp.

  • Checklist tasks per project, so “confirm glass sizes with processor” and “collect balance before installation” are items with a done state, not reminders in a chat.
  • A documents list for drawings, approvals and photos (files are not stored in this version; file storage is part of a hosted deployment).
  • Advance received, recorded against the project and visible on the card.
  • Order value vs estimated cost vs material issued at cost, and the resulting margin. As glass and hardware are issued from stock to the project, the material figure grows, and the margin the estimate promised is tested against what actually left the store.

Stage names and the order of stages are data, not code, and can be renamed or reduced for a shop that does not separate hardware procurement from glass processing. What the build enforces is the sequence of facts: a quotation converts to an order before a project reaches Order Confirmed, and material is issued against a project that exists.

Glass and hardware stock

Glass inventory, hardware inventory and material issues against a project

The glass business tracks glass in square feet by thickness, grade and finish, and hardware by item, across five stock groups with reserved quantity, minimum quantity and eight movement types including purchase receipt, issue to project, wastage, breakage, site return, reservation and adjustment. A material issue picks a project, then glass and hardware lines from stock; each line is costed at the stock’s cost, and the total lands on the project as material issued. Breakage and site returns are their own movements so the wastage figure is real and the returned panel comes back to stock rather than vanishing.

Glass here is tracked by area, not by sheet. The build does not nest panels on a jumbo sheet or optimise glass cutting; that is a two-dimensional problem for glass processors, and it is listed under what is not built. For a fabricator-installer that buys processed panels to size, area stock with wastage and breakage is the right level.

Suppliers and purchase invoices complete the loop: hardware and glass purchases raise stock and create a payable, and the supplier ledger shows what is owed.

Accounts

Invoices, receipts, payments and ledgers: the money thread for both businesses, and the Tally question

Both businesses share one invoicing model. A sales invoice is raised from an order (glass) or from delivered pieces (aluminium) with GST applied as CGST and SGST or IGST, in statuses draft, issued, part-paid and paid. Receipts are recorded against invoices and the customer ledger shows outstanding with ageing. Purchase invoices create payables; payments clear them; the supplier ledger shows the balance. Credit and debit notes exist for returns and corrections. Reports cover sales, projects, material and inventory and money for the glass business, and inventory, sales and profit for the aluminium business, where gross margin is computed after the real cost of the material consumed by cutting, kerf and scrap included.

The accounts module is an operational ledger that knows about projects, pieces and cuts; it is not a statutory book of accounts or a GST return. Many Gujarat shops will keep Tally for the accountant. That is a normal arrangement: the ERP owns the operational truth and pushes invoices and receipts to Tally, or exports them, and the two never disagree about what was sold. How that connection is built, and when a shop can stop using Tally altogether, is covered in Tally integration with a custom ERP. No Tally, e-invoice or e-way bill connection is in this version.

Length-wise aluminium inventory

Every bar and every remnant is its own record: the aluminium inventory engine

Most inventory software counts aluminium sections as a quantity per SKU: “SLIM-A in black, 18 bars”. That number cannot answer the question a cutting shop asks fifty times a day: can I cut this length without opening a new bar? The aluminium ERP answers it because it keeps one record per physical piece. Receiving 100 bars creates 100 records labelled P-00001 onwards, each with its profile and colour (the SKU), its length, its status, its rack location and its landed cost per foot. Cutting a bar does not reduce a quantity; it marks the parent record consumed and creates child records labelled R-00001 onwards for the leftovers worth keeping.

The inventory code states its own rules, and the screens obey them:

  1. Every physical piece is one record with a unique ID.
  2. Cutting consumes the parent (status consumed, length zero) and creates child records for reusable leftovers. Stock is never reduced by quantity alone.
  3. A consumed, scrapped or sold piece can never be cut again; a damaged piece must be released before it can be used.
  4. Every change writes an append-only movement row. There are nine movement types: inward, cut-consume, cut-produce, reserve, unreserve, scrap, damage, adjust and dispatch.
  5. Executing a cutting job is validated first and then applied in one state update: all pieces and movements change, or none do.

Pieces have six statuses: available, reserved, consumed, scrapped, damaged and sold. A remnant inherits its parent’s cost per foot and location and carries the ID of the job and the piece it came from, so a 4.98 FT remnant on the rack can be traced to the 20 FT bar and the order that produced it. Stock value is the sum of each piece’s remaining length times its own cost per foot, not an average; weight comes from the profile’s weight per metre, which matters for sections sold per kg.

The profile master defines each profile by code, series, section, shape, standard bar length, weight per metre, rate basis (per running foot or per kg), HSN code and, optionally, its own kerf and minimum remnant. A variant is a profile in a colour or finish, with a rack location and a minimum stock in pieces. Standard bar lengths in the set-up are 20 FT for most profiles, 21 FT for tracks and 16 FT for a heavy channel; these are configurable, not fixed.

Reservations mark pieces for an order without changing their length. The optimiser skips reserved pieces unless they are reserved for the order being planned, so a bar promised to Monday’s customer is not cut for Tuesday’s. Orders show live availability while they are typed: for each line, how many full bars and remnants of that SKU could serve it, how much is reserved, and whether there is a shortage. Orders carry eight statuses from draft to invoiced.

Cutting optimisation

How the cutting optimiser works: Best Fit Decreasing with remnant priority, kerf, minimum remnant and Plan A vs Plan B

Cutting aluminium bars to a list of lengths is the one-dimensional cutting-stock problem. Finding a provably optimal plan for a real order mix is hard; finding a good plan quickly is what a saw operator needs. The cutting planner in this build is, in its own words on screen, a set of heuristic results from a Best Fit Decreasing algorithm with remnant prioritisation — practical for the saw, not a claim of mathematical optimality. This page keeps that wording. It is a practical cutting plan, not an optimal one, and it is honest about it.

Inputs

The planner takes the requirements (length, quantity, label per line, typically pulled from a confirmed order), the candidate pieces (every available full bar and remnant of the same profile and colour, excluding pieces reserved for other orders), the saw kerf in mils (default 0.125 inch, per company, with a per-profile override), the minimum remnant length (default 2 FT, same overrides) and a flag for whether remnants may be used.

How a plan is built

  1. Sort the pool. Remnants first, shortest first; then full bars, shortest first. A short remnant that fits is always preferred to a long one, and any remnant to a fresh bar.
  2. Expand the cuts. Each requirement line becomes individual cuts, so 10 × 6 FT is ten cuts of 6 FT.
  3. Try three orderings. The cuts are ordered three ways and each ordering gets its own greedy pass: strict descending (classic Best Fit Decreasing), long/short interleave (first, last, second, second-last and so on), and two longs then one short. The cheapest of the three plans is kept. This multi-start is what stops the planner from being trapped by a single bad first choice.
  4. Place each cut. For every cut, the planner first looks at bars already opened in this plan and picks the one whose leftover after this cut and its kerf would be smallest (best fit). Then it looks at unopened candidates: a remnant is scored by its leftover; a fresh full bar carries a very large penalty so it is a last resort. A leftover that would fall into the dead zone — above zero but below the minimum remnant — is penalised by adding the minimum remnant length to its score, which nudges the plan away from producing unusable offcuts. If nothing fits, the cut is recorded as a shortage rather than silently dropped.
  5. Charge kerf honestly. Kerf on a cut is the lesser of the saw kerf and whatever is physically left after the piece: kerf = max(0, min(kerf, remaining − cut length)). A cut that finishes the bar exactly costs no kerf, because there is nothing left to lose.
  6. Classify the leftover. At or below 1 mil: nothing. At or above the minimum remnant: a remnant, returned to stock at full value with its own ID. In between: scrap.
  7. Score the plan. Plan cost = shortage pieces × 109 + scrap mils × 100 + full bars opened × 24,000 + kerf mils. In words: a shortage is unacceptable, scrap is expensive, opening a fresh bar costs the equivalent of 240 mils of scrap, and kerf is the tie-breaker. Remnants are not a cost, because they go back to stock.

Plan A vs Plan B

The planner runs twice and shows both results side by side. Plan A uses full bars only — what a quantity-only inventory would have to do, because it does not know the remnants exist. Plan B uses remnants first, then full bars. The comparison reports full bars saved, scrap saved and the change in utilisation, and names the better plan. The rule that picks the better plan is full bars × 1,000 + scrap feet + shortages × 5,000, so one saved bar outweighs up to 1,000 feet of scrap; the comparison deliberately favours opening fewer bars. The worked example below shows the trade-off this creates, with both numbers, so the operator can decide rather than the formula.

Statistics, diagrams and manual edits

Every plan reports pieces required and allocated, stock consumed, kerf loss, new remnant count and length, scrap count and length, shortages, full bars used, remnants used, utilisation (required length ÷ consumed length) and effective utilisation (required ÷ (consumed − new remnants), which treats returned remnants as stock, not loss). Each bar is drawn to scale with its cuts, kerf (given a visible minimum width), usable remnant and scrap. The operator can remove a cut from a bar or move it to another; the same function that built the plan recomputes kerf and leftover for the edited bar, flags over-capacity in red and turns any unplaced requirement into a shortage line. Because one function serves both the optimiser and the manual edits, the two cannot disagree about what a bar can hold.

Worked examples

Worked cutting examples: one 20 FT bar, a 30-piece order, and Plan A against Plan B

All figures in this section were computed from the build’s own cutting logic on 2026-11-19 with the default kerf of 0.125 inch and minimum remnant of 2 FT. They are not client figures and no saving is claimed for either business.

Example 1: one bar, two cuts

A 20 FT bar is cut into 8 FT and 7 FT. Two cuts, two kerfs of 0.125 inch, 0.25 inch in all. The leftover is 20 FT − 15 FT − 0.25 inch = 4.979 FT, not the 5 FT a spreadsheet would record. It is above the 2 FT minimum, so it goes back to stock as a remnant with its own ID, the parent bar’s cost per foot and a link to this job.

Example 2: a 30-piece order from full bars only (Plan A)

An order needs 10 × 6 FT, 10 × 5 FT and 10 × 3 FT of one profile and colour: 30 pieces, 140 running feet. Twenty 20 FT bars are available and there are no remnants. The planner opens 9 bars:

BarsCuts per barUsedKerfLeftoverClass
5 bars6 + 3 + 6 + 3 FT18 FT4 cuts, 0.5 in1.958 FT eachScrap (under 2 FT)
3 bars5 + 5 + 5 FT15 FT3 cuts, 0.375 in4.969 FT eachRemnant
1 bar5 FT5 FT1 cut, 0.125 in14.99 FTRemnant
Plan A totalsValue
Pieces allocated30 of 30, no shortage
Full bars opened9 (180 FT consumed)
Kerf loss3.75 inches
New remnants4, totalling 29.9 FT, back in stock
Scrap5 pieces, 9.79 FT
Utilisation (140 ÷ 180)77.8%
Effective utilisation (140 ÷ (180 − 29.9))93.3%

Two things are worth seeing in this table. The 6 + 3 + 6 + 3 pattern is the best-fit choice that leaves the least material, and its leftover of 1.958 FT is scrap only because the four kerfs pushed it under 2 FT; with a 1.5 FT minimum remnant it would be stock. And the single bar cut once for a 5 FT piece leaves a 14.99 FT remnant that is as good as a new bar for the next order. A quantity-only system would record “9 bars used” and lose the 29.9 FT of remnants and the 9.79 FT of scrap into the same number.

Example 3: the same order with remnants on the rack (Plan B)

Now the rack also holds four remnants of 8, 7, 4 and 3.5 FT from earlier jobs. Plan B uses all four, one cut each — 6 FT from the 8, 6 FT from the 7, 3 FT from the 4 and 3 FT from the 3.5 — and opens 8 full bars instead of 9. But each remnant leaves a piece under 2 FT: 1.99, 0.99, 0.99 and 0.49 FT, all scrap. So total scrap rises from 9.79 FT to 12.29 FT, and effective utilisation falls from 93.3% to 91.7%. The build still reports Plan B as better, with one full bar saved and a utilisation change of −1.6 points, because its comparison rule scores a saved bar above scrap feet.

MeasurePlan A — full bars onlyPlan B — remnants first
Full bars opened98
Remnants consumed04 (8, 7, 4, 3.5 FT)
Scrap9.79 FT12.29 FT
New remnants29.9 FT29.9 FT
Effective utilisation93.3%91.7%
ShortageNoneNone
The build’s verdict—Better: 1 bar saved

The honest reading is this: remnant-first cutting opens fewer fresh bars, and it can turn awkward short remnants into scrap. Whether a saved 20 FT bar is worth 2.5 FT of extra scrap depends on the profile’s cost per foot and on whether those remnants would ever have been used; for a slow-moving colour it usually is, for a fast-moving one it may not be. The screen shows both plans and both sets of numbers so the owner or operator decides, and the minimum remnant can be tuned per profile to change what counts as scrap. No page from Yukti AI will tell you that this planner saves a percentage of material; it tells you what it does to a given order and lets you check.

Millimetres

Does it work in millimetres? The 6,000 mm bar example

Many Gujarat traders buy 6-metre bars and many architects specify in millimetres. The planner stores everything in mils (1 mm = 39.37 mils), so metric bars and metric cuts are handled with the same logic, with a rounding of about 0.03 mm that does not matter at the saw. Both results below were computed from the build’s logic.

  • A 6,000 mm bar cut into 2,400 + 1,800 + 1,500 mm: 5,700 mm of pieces plus three kerfs of 3.175 mm (0.125 inch), 9.5 mm, leaves 290.5 mm. That is below the 2 FT minimum (609.6 mm), so it is booked as scrap.
  • The same bar cut into 2 × 2,500 mm: 5,000 mm plus two kerfs, 6.35 mm, leaves 993.6 mm, which is above the minimum and is stocked as a remnant with its own ID.

A shop that wants the minimum remnant in millimetres sets it that way in company settings; a shop that keeps feet for sale and millimetres for cutting enters each in its own unit and the system converts.

Executing the cut

Approval, the operator’s cutting list, atomic stock update and the wastage report

A saved plan is a cutting job in draft. Approval moves it to approved and prints the cutting list for the saw: cuts grouped by identical length so the operator sets the stop once and cuts ten pieces, with the bar or remnant ID to pull from the rack, the machine and the operator named on the job. Completed is the last of the four job statuses.

Execution is where most inventory systems cheat, and this one does not. Before anything changes, every piece in the plan is validated: it exists, it is not consumed, scrapped, sold or damaged, it is not used twice in the job, its length has not changed since the plan was made, and its cuts still fit. If any check fails the whole job is refused with the reason. If all pass, one state update does everything at once: parent bars are marked consumed, new remnant records are created with their source job and parent piece, short offcuts are booked as scrap, and one movement row is written per change (cut-consume, cut-produce, scrap). There is no half-executed job and no bar that is both cut and available.

The remnant stock screen then shows the new pieces with their ID, length, location, cost per foot and origin. The delivery challan, with vehicle and driver, marks the cut pieces sold; the invoice and receipt follow. The wastage report closes the loop by splitting everything the saw consumed into four parts: delivered cut pieces, reusable remnants returned to stock, kerf loss and scrap — by profile and by period. An owner reading it can see whether scrap is coming from one awkward profile, one operator or one customer’s length mix, and whether the remnant rack is being used or just growing.

Purchases and documents

Purchase orders, goods received into pieces, delivery challans and invoices

A purchase order for the aluminium business lists variants and quantities in bars, through five statuses. Goods received records what arrived against the order, line by line, with the rack location per line, and this is the moment the piece records are born: a GRN of 100 bars creates 100 available pieces at the landed cost per foot computed from the purchase invoice. Purchase invoices create the payable; payments clear it; the supplier ledger holds the balance.

On the sales side, a delivery challan is raised against an order for pieces that have been cut, with vehicle number and driver, and it is the challan that marks the pieces sold. Sales invoices can be raised from the challan, GST applied, and receipts recorded with ageing. The glass business follows the same purchase-to-payable and invoice-to-receipt pattern with suppliers for glass and hardware, so the owner reads one kind of ledger for both companies.

See your own cut list planned against your own rackWe build on your profiles, bar lengths, kerf and minimum remnant, so you judge a working cutting planner, not a slide deck. Free workflow audit, reply the same day.

Plan my cut list
AI and automation

AI and automation in a glass and aluminium ERP: what is built, what is built elsewhere by Yukti AI, and what is buildable

Honesty first: the version built for Multiple Glass Solutions and KJ Alutech does not contain a language model, a vision model or any machine-learning feature. What it has is a layer of automation and rules that does work people usually do by hand. AI features are listed separately as buildable, and each one points to a system Yukti AI has already built where the same technique is working.

Built here: what runs by itself in this version

  • Hardware lines added, re-synced and removed from category rules as panels change; manual lines and rate overrides preserved.
  • Live recalculation of glass, profile, hardware, wastage, labour, installation, margin, transport, selling price and rate per sq.ft on every change.
  • Estimate to quotation to sales order to project stage, each conversion carrying the lines forward and moving the project.
  • Stock availability checked against real pieces while an aluminium order is typed, including reserved stock and shortages.
  • Cutting plan generation with three orderings, kerf, minimum remnant and the Plan A vs Plan B comparison.
  • Atomic execution of cutting jobs: validation, consumption, remnant creation, scrap booking and movement rows in one step.
  • Document numbering, GST split, round-off, receipt allocation and ageing, and the audit trail.

Built in other Yukti AI systems: the techniques this ERP can borrow

  • The Box Factory — an AI quotation engine that turns a free-text brief into a bill of materials and a cost; the same pattern would read “shower, 2’4” door, 3’3” fixed, 10 mm” into a draft estimate here.
  • Arjun — a WhatsApp AI sales agent that replies to enquiries and qualifies leads, the model for a fabricator’s enquiry line.
  • Sureja — outbound voice AI payment reminders in Hindi with the outcome logged, the model for chasing final payments on closed projects.
  • P. Hitesh & Co. — a rule-based copilot and daily narrative over live ERP data, the model for an owner’s morning brief across both businesses.

Buildable on this system

WhatsApp sending of quotations, project-stage updates and challans; AI estimation from a site photo, a sketch or a voice note; a cutting plan made from a cut list sent on WhatsApp; re-costing of open quotations when a glass or profile rate changes; remnant suggestions when an order is typed; an owner’s assistant that answers questions over both businesses’ records; and a cutting list pushed to a saw with a digital stop. Each is described below with what it needs. See ERP-connected AI agents for how Yukti AI adds the layer and AI automation in Surat for the agency side.

By department

Where do AI and automation help a glass and aluminium works, department by department?

DepartmentAutomation already in the buildAI that can be addedStatus
Enquiries and salesEnquiry statuses, sources, follow-up dates, convert to projectWhatsApp agent that answers “what will a 6 × 7 shower cost?” with a range from the shop’s own rules and books a site visitBuilt / Buildable (Arjun pattern)
Site measurementUnit parsing, mils storage, carpenter display, printPhoto or voice note of a measurement page read into a draft sheet for a person to confirmBuilt / Buildable
EstimationHardware rules, live recalculation, material requirement listDraft estimate from a text brief; re-costing of open quotations when a rate changes; flagging estimates whose margin is below the category normBuilt / Buildable (Box Factory pattern)
Quotations and projectsRevisions, validity, conversion, 13 stages, checklistWhatsApp quotation sending with approval link; automatic stage messages to the customer (advance received, glass at processor, installation scheduled)Built / Buildable
Aluminium ordersLive availability against pieces, reservationsRemnant suggestion: “a 7 FT remnant in this colour can serve this line without opening a bar”; cut list received on WhatsApp turned into an orderBuilt / Buildable
CuttingPlanner, Plan A vs B, diagrams, cutting list, atomic executionCutting list pushed to a saw with a digital stop or to a label printer; anomaly alerts when scrap per job exceeds the profile’s normBuilt / Buildable (needs saw or printer interface)
PurchasePO to GRN to pieces, payablesReorder suggestions by SKU from consumption, lead time and minimum stock; supplier rate comparisonBuilt / Buildable
CollectionsAgeing, receipts, ledgersWhatsApp reminders on due dates; voice AI calls for overdue final paymentsBuilt / Buildable (Sureja pattern)
OwnerDashboards, reports, audit trailMorning brief across both businesses: what is late, what is short, who owes money, which remnants are ageingBuilt / Buildable (P. Hitesh pattern)
WhatsApp automation

WhatsApp automation for glass fabricators and aluminium traders: quotations, stage updates, challans and reminders

In this trade the customer is already on WhatsApp: that is where the enquiry arrived, where the site photo was sent and where the approval will come from. The ERP holds the facts; a WhatsApp layer sends them at the moment they happen. None of this is in the version built for the two businesses; all of it is buildable on it, through the WhatsApp Business API, and Yukti AI has built the sending and the agent side for other clients. See WhatsApp automation for the service.

Trigger in the ERPMessageWho receives it
Quotation status set to sentThe A4 quotation as PDF with validity date and a reply-to-approve lineCustomer, architect or builder
Quotation revisedRevised quotation with the note explaining the changeCustomer
Project reaches Advance Received, Glass Processing, Installation ScheduledShort stage update with the expected next dateCustomer; installation team for the schedule
Material issue to a projectPick list for the installation teamInstaller
Cutting job approvedCutting list to the operator’s phoneSaw operator
Delivery challan createdChallan with vehicle and driverCustomer; driver
Invoice issued or due date reachedInvoice PDF; then a reminder with the outstanding amountCustomer
Remnant ageing beyond a set periodWeekly list of ageing remnants by SKU to offer at a discountOwner, sales

Two things to budget for: automated messages go through the WhatsApp Business API and Meta charges per conversation, separate from any development fee; and templates for business-initiated messages need approval. The enquiry side — a WhatsApp AI agent that answers price-range questions from the shop’s own rules and books a measurement visit — is the Arjun pattern applied to a fabricator and is scoped separately from the sending layer.

AI estimation

AI estimation from a photo, a sketch or a voice note, and re-costing when rates change

The most valuable AI for a glass fabricator sits in front of the estimator, not instead of it. A site team photographs a measurement page or sends a voice note: “shower, door two-four by six-six, fixed three-three by six-six, ten mm toughened.” A model reads it into a draft measurement sheet — panel roles, sizes in the unit spoken, thickness and grade — and the estimator then does what it already does: billable area, hardware by rule, labour, wastage, margin. A person checks the draft before it becomes a quotation, because the model’s job is to save the typing, not to decide the price. Yukti AI built this pattern as the AI quotation engine in the Box Factory ERP, where a free-text brief becomes a bill of materials and a cost; the glass version would use the measurement library and the category rules described above.

Rate re-costing is simpler and arguably more valuable. Glass and aluminium rates move. When the 10 mm toughened base rate or the slim-profile rate per foot is changed in the master, an automation can re-cost every open quotation and list the ones whose margin has dropped below the category norm, so the salesperson calls the customer before the quotation is approved at a loss. That needs no language model, only the rules already in the build and a scheduled job, and it is listed as buildable because it is not in this version.

A third use is a margin check: estimates whose margin is unusually low or high for their category are flagged for review before they are sent. Again a rule, not a model, and again dependent on the records this ERP keeps.

AI at the saw

Cut-list intake from WhatsApp, remnant suggestions, scrap anomalies and the cutting list to the saw

A fabricator customer sends the aluminium trader a cut list on WhatsApp: a photo of a handwritten page, or a line like “SLIM-A black: 10 of 6 ft, 10 of 5 ft, 10 of 3 ft”. An intake agent can read that into an order with the right variant and lines, check availability against real pieces, and reply with the price and the expected date, with a person confirming before the order is placed. The planner then does the rest. This is the Arjun intake pattern joined to the availability check that is already built.

Remnant suggestions are a smaller automation with a large effect on the rack: when an order line is typed, the system lists remnants of that SKU that could serve it and shows the scrap each would leave, using the same kerf and minimum-remnant rules as the planner. Over a month, this is what empties the remnant rack instead of growing it.

Scrap anomaly alerts use the wastage report. Each profile develops a normal scrap share; a job, an operator or a week that exceeds it is raised to the owner. This is rule-based and needs only the records the build already writes.

Pushing the cutting list to the saw is the one item that needs hardware. A saw with a digital stop or a length controller can accept the cut sequence; a label printer can print the piece ID and length for each cut so the remnant goes back to the rack with its tag. The build prints a tick-sheet today; the machine interface is a scoped addition and depends on the saw.

Honest limits

What AI cannot do for a glass and aluminium works (yet)

  • It cannot measure the site. A model can read a page; it cannot know that the floor is out of level by 12 mm or that the tile ends before the wall. Measurement stays a person’s job; the software makes the record exact.
  • It cannot make a cutting plan provably optimal. The planner is a good heuristic with a multi-start, and the honest claim stays “practical for the saw”.
  • It cannot nest glass on a sheet in this build; two-dimensional glass optimisation is a different engine and belongs to a glass processor’s plant, not a fabricator-installer’s office.
  • It cannot approve a quotation, decide a discount or accept an order. Those stay with the owner or the salesperson; the AI drafts and flags.
  • It cannot replace the hardware rules with judgement. The rules are the shop’s knowledge written down once; a model that guessed hinge counts would be worse than the rule.
  • It cannot run without the records. Every AI item on this page reads measurements, estimates, pieces, cuts and ledgers that the ERP keeps; without them there is nothing to read.
AI cost

How much does AI and WhatsApp automation cost for a fabrication business?

Two lines can be stated plainly. A custom ERP from Yukti AI starts from ₹30,000, and AI and WhatsApp layers are quoted separately on top of the records they need. Running costs are separate again: WhatsApp Business API conversations are charged by Meta, and AI models are charged per use by their providers; both are passed through at cost and are small next to a single remake or an unnecessary bar. The general drivers are described in AI automation cost in India; the quote for a fabricator follows a free 30-minute workflow audit.

Proof

The real Yukti AI builds behind these AI and automation claims

BuildAI or automation in itRelevance to a glass and aluminium works
Multiple Glass Solutions and KJ Alutech (this page)Hardware rules, live estimation, piece-wise stock, cutting optimiser, atomic execution, wastage reportThe records and rules AI builds on
The Box FactoryAI quotation engine: free-text brief to bill of materials and costAI estimation from a brief, photo or voice note
ArjunWhatsApp AI sales agent that replies and qualifies leadsEnquiry line and cut-list intake on WhatsApp
SurejaOutbound voice AI payment reminders in Hindi, outcome loggedCollecting final payments on closed projects
P. Hitesh & Co.Rule-based copilot and daily narrative over live ERP dataOwner’s brief across two businesses
ZunowaFabrication ERP with job costing and karigar labourThe fabrication-side pattern this build extends

Running a glass works and a section shop on two tools and a spreadsheet?Show us how a job moves from the site to the saw today and we’ll map what one platform would replace. Free workflow audit, reply the same day.

Talk to Yukti AI
Comparison

Glass and aluminium ERP vs stand-alone cutting optimisers vs window-estimation apps vs Excel and Tally

Each tool class on this table solves one part of the problem well. The question for a Surat or Gujarat shop is which parts it has and which it does not.

NeedCustom glass & aluminium ERP (this build)Stand-alone 1D cutting optimiserWindow / door estimation appExcel + Tally
Site measurement in ft / in / mm with exact storageYes, per panel, parsed and stored as milsLengths only, typed per jobOften inches entry on siteTyped and converted by hand
Billable area with rounding and minimumYes, 4 modes and category minimumNoUsually sq.ft billing, rounding variesFormula per sheet, applied by habit
Hardware by rules per categoryYes, 10 bases, auto-syncNoPreset hardware for windows and doors; showers and railings rarelyRemembered
GST quotation with revisions and conversionYesNoQuotation PDF, often no revision historyWord or Tally quotation, overwritten
Project stages and margin vs material issuedYes, 13 stages, KanbanNoAdvance and due tracking at mostNo
Piece-wise bar and remnant stock with IDsYes, every bar and remnant a recordSome keep a remnant list; stock is separateNoQuantity per section
Cutting plan with kerf, minimum remnant, Plan A vs BYes, BFD with remnant priority, heuristic statedYes, often with mitre angles and DXF export tooCut lists from window sizes, no stock optimisationNo
Execution that updates stock and creates remnantsYes, atomicExport to a file; stock updated elsewhere, if at allNoManual adjustment
Wastage report (delivered / remnant / kerf / scrap)YesWaste % per planNoNo
Challans, invoices, ledgers, ageingYes, operational ledger for both businessesNoBasic invoicing in someTally, disconnected from jobs
Two businesses, separated data, one loginYesNoNoTwo companies in Tally, two sets of sheets
CAD / DXF drawings, 3D shower designerNo (listed as addable)DXF import/export in someDrawings for standard windows; 3D in premium shower toolsNo
WhatsApp and AIBuildable on the recordsNoPDF shared on WhatsApp by handNo
Fits your own categories, rules and rolesBuilt around themGenericGenericWhatever you type
Who it suitsA fabricator or trader whose method is its own and who wants one record from site to sawA shop that only needs better cut lists and keeps stock elsewhereA window and door fabricator with standard productsA very small shop with one estimator and no remnant rack

For the general argument on when a custom build beats a package, see custom ERP vs off-the-shelf ERP; for the Surat-specific service, custom ERP software in Surat.

Feature checklist

Features of glass and aluminium fabrication software, and which ones this build covers

The feature lists below take the headline features that glass software, aluminium estimation tools and cutting optimisers advertise and say plainly whether this build has them, has them differently, or does not have them. “Yes” means built in this version; “Addable” means Yukti AI can scope it on this system; “No” means it is out of scope for a fabricator-installer and trader of this kind.

Glass fabrication and installation

FeatureThis buildNote
Enquiry pipeline with sources and follow-upsYes6 statuses, 8 sources, assigned-to, lost reason
Site measurement sheet in feet, inches and mmYes7 panel roles, quick sizes, print, mils storage
Area calculation with rounding and minimum billable areaYesW × H ÷ 144; exact / ¼ / ½ / whole; category minimum
Glass rate by thickness, grade, processing and tougheningYes6 thickness rows, 8 grades
Hardware rules per category with auto-syncYes10 bases, round-up for whole units, manual lines kept
Shower enclosure estimationYes6 shower types, rules for hinges, handle, brackets, seals, silicone, kit; no 3D designer
Frameless and slim-profile partitions, railings, mirrors, slidingYesProfile metres costed on the line for slim and framed systems
Labour, installation, wastage, margin, transportYesWastage on material only; margin as markup on cost
Material requirement list from an estimateYesGlass sq.ft incl. wastage, hardware, profile metres
GST quotation with revisions, validity, A4 printYesCGST/SGST; IGST on invoices
Online quotation acceptance and paymentAddableApproval by WhatsApp reply is the simpler first step
Sales orders and 13-stage projects with KanbanYesChecklist tasks, documents list, stage history
Margin against material issuedYesOrder value vs estimated cost vs material at cost
Glass and hardware inventory with wastage and breakageYes5 stock groups, 8 movement types
Glass sheet nesting / 2D cutting optimisationNoGlass is tracked by area; nesting belongs to the processor
CAD, DXF or production drawingsAddableNot in this version
Site photos and document storageAddableNot stored in this version; needs hosted storage

Aluminium profile trading and cutting

FeatureThis buildNote
Profile master with bar length, weight per metre, rate basis, HSNYesPer-profile kerf and minimum remnant override
Variants by colour and finish with rack locationYesMinimum stock in pieces
Every bar and remnant as its own record with ID and costYes6 statuses, 9 movement types, append-only
Sale per running foot and per kgYesRate basis per profile; weight from weight per metre
Live availability while an order is typedYesFull bars, remnants, reserved, shortage
Reservations per orderYesOptimiser respects them
1D cutting optimisation with kerf and minimum remnantYesBFD with remnant priority, 3 orderings, heuristic stated
Plan A vs Plan B comparisonYesBoth sets of numbers shown
To-scale bar diagrams and manual editingYesSame function recomputes edits
Printable cutting list grouped by lengthYesMachine and operator on the job
Atomic execution creating remnants and booking scrapYesValidated first, applied in one step
Wastage report: delivered / remnant / kerf / scrapYesBy profile and period
Angle or mitre cuts, end trim, bar flipNoStraight cuts only in this version; addable for window frames
Saw / CNC export, barcode or QR piece labelsAddableDepends on the saw and printer
Multi-bar-length purchasing suggestionsAddableWhich bar length to buy for a given order mix
System-house or dealer profile catalogues, supplier price feedsNoOwn profile master instead
Purchase orders, GRN into pieces, purchase invoicesYesLanded cost per foot per piece
Delivery challans with vehicle and driver, invoices, ledgersYesChallan marks pieces sold

Platform

FeatureThis buildNote
Two businesses on one platform with separated dataYesBusiness selector, company field on every record
Roles and permissionsYes6 roles, 16 modules × 5 actions, enforced in the menu; server enforcement at go-live
Audit trailYesPer record and per stock movement
CSV export, print-to-PDF documentsYesA4 quotations, invoices, challans, cutting lists
Server database, multi-user sync, server-side loginAddableRecords live in one browser in this version
Tally, GST e-invoice, e-way billAddableSee the Tally integration guide
WhatsApp sending, AI estimation, cut-list intake, owner assistantAddableSee the AI and automation sections
Mobile app, offline mode, Gujarati UIAddableResponsive web build in English today
Benefits

Benefits of a glass and aluminium ERP for a fabricator or trader, stated without numbers

Because no usage is claimed, these benefits are described as what the design makes possible, not as measured outcomes.

  • One measurement, many uses. The panel typed once on the measurement sheet is the panel on the estimate, the quotation, the material issue and the processor’s cutting size, in whichever unit each needs.
  • The same hardware for the same panels, whoever estimates. Rules replace memory; the shop changes a rule once and every estimate follows.
  • Revisions you can show. Every version of a quotation is kept with its note, and the approved one is the one that converts.
  • A project board instead of a phone. Thirteen stages, tasks, history and advance on one card; the owner sees what is at the processor and what is waiting for a final payment.
  • Margin that is tested, not assumed. Material issued at cost against order value shows whether the estimate held.
  • A rack you can trust. Every bar and remnant is a record with a length, a location and a cost, so “can I cut 7 feet without opening a bar?” has an answer.
  • Fewer fresh bars opened, with the trade-off visible. Plan A and Plan B side by side, with scrap and utilisation for each, so the saving in bars is never hidden behind a rise in scrap.
  • Stock that cannot drift. Cutting is validated, applied atomically and written to an append-only movement log; a bar cannot be cut twice or counted twice.
  • Wastage you can name. Delivered, remnant, kerf and scrap by profile and period; the owner knows where the loss is.
  • Two businesses, one place. Separate data, shared roles and settings, one owner view.
  • A base for automation and AI. WhatsApp, AI estimation, cut-list intake and an owner’s brief all read the records this ERP keeps.
Not built, can be added

What this build does not have, and what competitors’ headline features it can gain

Glass and aluminium software from larger vendors advertises features this version does not have. Some are out of scope for a fabricator-installer and a trader; some are sensible additions. Here is the honest list.

  • Server database, multi-user sync and server-side login. Records live in one browser in this version; a hosted deployment with a database, roles enforced on the server, backups and an audit trail outside the browser is the normal next step and is part of any go-live scope.
  • Tally, GST e-invoice, e-way bill and bank feeds. Not connected; see Tally integration.
  • WhatsApp or SMS sending of quotations, challans and stage updates. Buildable, as described above.
  • CAD, DXF or DWG drawings, section drawings and a 3D shower configurator. Profile drawings are not in this version. A 3D designer is a headline feature of premium shower-quoting tools abroad; for most Gujarat fabricators a clear measurement sheet and an A4 quotation with specifications do the job, and drawings can be added when a customer base demands them.
  • Saw or CNC machine export and barcode or QR piece labels. The cutting list prints as a tick-sheet; the machine interface and labels depend on the saw and printer.
  • Glass sheet 2D nesting and toughening or furnace scheduling. The optimiser is one-dimensional for aluminium bars; glass is tracked in square feet. Two-dimensional nesting and IGU, DGU or furnace scheduling belong to a glass processor’s plant ERP.
  • Angle or mitre cuts, end trim and bar flip. Straight cuts only; window-frame fabricators that mitre every corner would need these added.
  • System-house profile catalogues, dealer catalogues and supplier price feeds. The shop keeps its own profile master.
  • Online quotation acceptance and payment. Not built; approval by WhatsApp reply is the first step.
  • Photo uploads, site photos and document storage. Not in this version; needs hosted storage.
  • Mobile or offline app and Gujarati UI. Responsive web in English.
  • Any AI model, voice agent or chatbot. None in this version; all listed as buildable with the Yukti AI builds they would be based on.
Buying checklist

Buying checklist: 12 questions to ask before you choose glass or aluminium fabrication software

Before you buy any glass or aluminium software, ask to see one of your own jobs on screen: a shower enclosure measured in feet and inches and quoted in square feet, and a cut list planned against your own rack. If the vendor shows you their own example job instead of yours, you have learned nothing about the fit.

  1. Can I enter 6’3” and 1,905 mm on the same sheet and see both correctly?
  2. How does it round area, and can I set a minimum billable area per category?
  3. Where do the hardware quantities come from, and can I change the factor for my shop?
  4. Does wastage apply to material only, and is margin markup on cost or margin on price? Show me.
  5. Can I see every revision of a quotation and which one the customer approved?
  6. What happens to the project when a quotation is converted, and can I rename the stages?
  7. Does the project show margin against material actually issued, or only the estimate?
  8. Is aluminium stock a quantity per section, or is every bar and remnant a record with a length and a cost?
  9. Does the cutting plan charge kerf, respect a minimum remnant, and show me a full-bars-only plan next to a remnants-first plan with scrap for each?
  10. When I execute a cut, what exactly changes in stock, and can a bar be cut twice by mistake?
  11. Does the wastage report split delivered pieces, remnants, kerf and scrap?
  12. Who owns the data, where is it hosted, how do I export it, what does Tally or e-invoice integration cost, and what is the full price including support?
Solution architecture

One thread from the site to the saw to the invoice

1

Enquiry and measurement

Source, status, follow-up; panels in ft, in or mm stored as mils

2

Estimate

Area, glass rate, hardware rules, labour, wastage, margin, transport

3

Quotation and order

GST, revisions, validity, conversion, 13-stage project

4

Pieces

GRN into bar records; availability and reservations per order

5

Cutting plan and job

BFD with remnant priority, kerf, Plan A vs B, approval, cutting list

6

Execute, deliver, bill

Atomic stock update, remnants and scrap, challan, invoice, receipt, wastage report

What we built

The modules

Fifty-one screens across the two businesses on one shared platform — the scope of a full custom ERP, shaped around a glass works and an aluminium cutting shop.

Multiple Glass Solutions (23 screens, 7 groups)

Overview: dashboard. Sales and projects: enquiries, customers, projects, quotations, sales orders. Estimation: product master, measurements, estimation calculator. Inventory: glass inventory, hardware inventory, material issues, suppliers, purchases. Finance: sales invoices, purchase invoices, payments, ledgers. Reports: sales, projects, material and inventory, money. Administration: employees, permissions, company settings, audit trail.

KJ Alutech (28 screens, 8 groups)

Overview: dashboard. Sales: customers, orders, quotations, sales invoices, delivery challans. Inventory: profile master, full-length stock, remnant stock, stock movements, stock reservations. Production: cutting planner, cutting jobs, wastage reports. Purchases: suppliers, purchase orders, goods received, purchase invoices. Finance: payments, customer ledger, supplier ledger. Reports: inventory, sales, profit. Administration: employees, permissions, company settings, audit trail.

Shared

Business selector, customer types, supplier model, GST invoicing with CGST/SGST/IGST, receipts and payments with ageing, credit and debit notes, employees, the permission matrix, company settings (kerf, minimum remnant, default unit, area rounding, minimum panel area, wastage, margin, GST, validity, credit days, round-off), audit trail, CSV export and print-to-PDF documents.

Roles

Roles and permissions: 6 roles, 16 modules, 5 actions

The build defines six roles: Owner, Admin, Sales Executive, Inventory Manager, Accountant and Production Operator. Permissions are a matrix of 16 modules against five actions — view, create, edit, delete and approve — and the sidebar hides any module a role cannot view. The table shows the shape of the matrix as set up for the two businesses; every cell is editable by the owner or admin on the permissions screen.

Module groupOwnerAdminSalesInventoryAccountsProduction
Enquiries, customers, quotations, ordersAllAllView, create, editViewView—
Measurements and estimationAllAllView, create, editView——
ProjectsAll, approveAll, approveView, edit stageViewViewView
Glass, hardware, profiles, pieces, remnants, movementsAllAllViewView, create, editViewView
Cutting planner and cutting jobsAll, approveAll, approveViewView, create—View, execute approved jobs
Purchases, GRN, suppliersAllAll—View, create, editView—
Invoices, payments, ledgersAllAllView—View, create, edit—
ReportsAllAllSalesInventory, wastageMoney, profit—
Employees, permissions, settings, audit trailAllAll————

One honest point: in this version the matrix shapes the navigation and the screens in the browser. In a hosted deployment the same matrix must also be enforced on the server and the database, which is part of the go-live scope for any real deployment and is the build’s own stated plan.

Implementation process

How it was built

1

Two workflows mapped

How a glass job moves from site to installation, and how a bar moves from GRN to challan

2

Units and rules first

The mils library, area rounding, hardware rule bases, kerf and minimum remnant, before any screen

3

The two engines

Estimation calculator and the cutting planner as pure modules, checked on worked orders

4

Screens by role

51 screens built around what each role does, with the permission matrix driving the menu

5

Walk-through on real-shaped data

A full thread from enquiry to project close and from order to wastage report, with figures from the sample dataset

Results

What was delivered

What the system does — no invented numbers.

2 businesses
One platform, separated data, one owner view
51 screens
23 for the glass business, 28 for the aluminium business
13 stages
From Enquiry Received to Project Closed, on a Kanban
10 rule bases
Hardware added by factor and basis, per category
1 record per piece
Every bar and remnant with ID, length, status, location and cost
6 roles
16 modules × 5 actions in the permission matrix
Transparency

What this page does not claim

  • No claim that Multiple Glass Solutions or KJ Alutech use the system in daily operation, how many people use it or since when. There is no client quote and no outcome figure.
  • No claim of bars saved, scrap reduced, remakes avoided, time saved or margin improved. The worked examples are computed from the build’s logic on sample orders and show both the gain and the trade-off.
  • No backend and no multi-user system yet: records live in the browser of the machine the system runs on, and sign-in is a business picker and a role switcher, not a server login. Hosting with a database, server-side permissions and backups is the next step and is not claimed as done.
  • No live connections: Tally, GST e-invoice and e-way bill, WhatsApp, bank feeds, saw or label printer, and no language model, vision model or chatbot in this version.
  • The city of the two businesses is not published; only “Gujarat”. Whether the two firms are one group is for the owner to confirm.
  • Figures, customer names, project names and staff names visible in the screenshots are from the sample dataset the screens were set up with and are not either company’s business numbers. The hardware factors and rates in the worked example are the build’s editable defaults, not shop facts or market prices.
  • The cutting planner is a heuristic. “Practical for the saw” is the claim; “optimal” is not.
  • The accounts module is an operational ledger, not a statutory book of accounts or a GST return.
Status

The working version built by Yukti AI around the two businesses’ workflows, with records kept in the browser. Anything not listed as built above is described as buildable, not as delivered.

Technology

Technology

The build uses Vite 5 with React 18 and TypeScript 5.6, React Router 6, Zustand 5 for state with persistence to the browser’s LocalStorage, Tailwind CSS 3.4, Recharts for the dashboard charts and Lucide icons, with a print stylesheet for A4 documents and CSV export. It is about 32,500 lines of TypeScript in 73 files. The two engines — the estimation calculator and the cutting planner with its inventory rules — are pure modules with no dependency on the screens: they take data and an input and return a result or a refusal, which is why the same function can serve the optimiser, the manual plan editor and the execution check without disagreeing. The unit library stores lengths as integer mils and formats them as carpenter feet-and-inches or millimetres on demand.

There are no automated tests in this version; the worked examples on this page were produced by bundling the cutting module and running it on the sample orders. The static build deploys anywhere a web page can be served. For a production deployment Yukti AI would move the records to a server database, enforce the permission matrix on the server, connect the approved providers (GST e-invoice and e-way bill, Tally, WhatsApp), add file storage for drawings and photos, and add backups and an audit trail outside the browser. That is the normal path from a working version to a live system.

What can be added next

  • Hosted deployment with a database, server-side roles and backups.
  • WhatsApp quotations, stage updates, challans and payment reminders through the Business API.
  • AI estimation from a photo, sketch or voice note; cut-list intake from WhatsApp; rate re-costing of open quotations; remnant suggestions and scrap anomaly alerts; an owner’s morning brief.
  • Mitre and angle cuts, end trim and multi-bar-length purchasing suggestions for window-frame work.
  • Saw interface and piece labels with barcode or QR.
  • GST e-invoice and e-way bill through a provider, and a Tally connection.
  • Drawings and site photos with storage; a customer portal for approvals and project status.
Cost and timeline

How much does a glass and aluminium fabrication ERP cost in Surat, and how long does it take?

Yukti AI does not publish a price list, because the price follows the scope. Two lines are approved and can be stated plainly: a custom ERP from Yukti AI starts from ₹30,000, and a first working version is typically ready in about 7–10 days. A two-business platform of this breadth — measurement, estimation, quotations, projects, glass and hardware stock, piece-wise aluminium stock, a cutting planner, cutting jobs, purchases, challans, invoices and ledgers — is toward the larger end of what we build, and its quote depends on these factors:

  • Which side you need first: the glass side (measurement, estimation, quotation, projects) or the aluminium side (pieces, planner, cutting jobs), or both.
  • How many businesses, users, roles and locations.
  • Migration: customers, profiles, rates, hardware items and opening stock from Excel or Tally, and whether opening aluminium stock is to be entered piece by piece.
  • Integrations: WhatsApp, Tally, GST e-invoice and e-way bill, a saw interface or label printer.
  • Hosting, security and support expectations after go-live.

The way to start is a free workflow audit: you show us one recent quotation and one cutting list, we show what one system would replace, and you get a custom quote. See custom ERP software cost in India for the general drivers and contact us to book the audit.

Surat and Gujarat

Glass and aluminium fabrication software in Surat and Gujarat: who it is for and how a project starts

Glass and aluminium fabrication software in Surat is one system that records the site measurement, prices the job with the shop’s own rules, tracks the project to installation and payment, and for the aluminium side keeps every bar and remnant as a record and plans each cut. Yukti AI, a software company at Leonard Square in Varachha, Surat, builds it as a custom ERP around the fabricator’s or trader’s own method, and this page is the case study behind the fabrication ERP service in Surat.

Surat and the wider Gujarat belt — Vadodara, Rajkot, Navsari, Vapi, Bharuch — have hundreds of glass works and aluminium section shops serving builders, interior designers, hotels, hospitals and the diamond and textile offices that fit out floors every year. Most run on a notebook, a spreadsheet and Tally. The two business types on this page are typical: a fabricator-installer that quotes in square feet and a section trader that sells by the running foot and cuts on a saw. Shops that do both — buy sections, cut and fit, and install glass — get both halves.

A project with Yukti AI starts with a free 30-minute workflow audit, in person in Surat or on a call elsewhere in Gujarat, where you show one recent quotation and one cutting list. We map what one system would replace, scope a first working version, and give a quote. The first version is usually a focused slice — measurement to quotation, or pieces to cutting plan — so you judge something working on your own data within days, and the rest follows. Training is by role: sales learns measurement and estimation, the store learns pieces and reservations, the operator learns the cutting list and execution, accounts learns invoices and ledgers. Support after go-live is included for twelve months. See about Yukti AI and all case studies.

Terms explained

Terms used on this page: kerf, remnant, scrap, Best Fit Decreasing, utilisation, mils and billable area

TermMeaning in this build
KerfThe width of material the saw blade removes on each cut. Default 0.125 inch; charged per cut but never more than what is physically left after the piece.
RemnantA leftover at or above the minimum remnant length (default 2 FT). It returns to stock as a new piece record with its own ID, its parent’s cost per foot and a link to the job that made it.
ScrapA leftover above zero but below the minimum remnant length. Booked as scrap with a movement row; counted in the wastage report.
Dead zoneThe range between 1 mil and the minimum remnant. The planner penalises leftovers that would fall there so the plan avoids producing unusable offcuts.
Best Fit Decreasing (BFD)A cutting-stock heuristic: order cuts from longest to shortest and place each in the open bar where it leaves the least space. This build runs it three ways with remnants first and keeps the cheapest plan.
Plan A / Plan BPlan A uses full bars only; Plan B uses remnants first, then full bars. Both are shown with bars, scrap and utilisation.
UtilisationRequired length divided by consumed length. Effective utilisation divides by consumed length minus new remnants, treating remnants as stock rather than loss.
MilsThousandths of an inch. All lengths are stored as integer mils; 20 FT is 240,000 mils; 1 mm is 39.37 mils.
Billable areaWidth in inches times height in inches divided by 144, rounded by the company’s mode (exact, quarter, half, whole) and raised to the minimum billable panel area if below it.
Hardware ruleA hardware item with a factor and a basis (fixed, per panel, per door, per fixed panel, per sq.ft, per R.ft of perimeter, running length, height or width, per metre of profile). Whole-unit items round up.
ReservationMarking a piece for an order without changing its length; the planner skips pieces reserved for other orders.
Atomic executionA cutting job is validated completely and then applied in a single state update: all pieces and movements change, or nothing does.
FAQ

Glass and aluminium ERP, estimation and cutting optimisation: questions fabricators and traders ask

A glass and aluminium fabrication ERP is one system that records a glass job from the site measurement to the installed project and an aluminium job from the bar received to the piece delivered, with money on both. For the glass side it holds measurement sheets in feet, inches or millimetres, an estimation calculator with hardware rules, GST quotations with revisions, sales orders, project stages, glass and hardware stock and material issues. For the aluminium side it holds a profile master, every bar and remnant as a record, a cutting planner, cutting jobs, wastage reports, challans and invoices. The build on this page, made by Yukti AI in Surat for Multiple Glass Solutions and KJ Alutech, is one example; the service page is fabrication ERP software.
Yes. The build uses a business selector at sign-in, and every record carries a company field, so each business sees only its own customers, documents, stock and reports while sharing the platform, roles, permission matrix and settings model. The glass business has 23 screens in 7 groups and the aluminium business 28 screens in 8 groups; switching is a click in the sidebar. Data is separated, not merged, which is what an owner with a sister concern needs. See the section on two businesses on one platform.
Glass fabricator-installers that quote shower enclosures, frameless and slim-profile partitions, mirrors, railings and sliding systems in square feet; aluminium section traders that sell slim partition profiles, channels, tracks, tubes and angles per running foot or per kg and cut to length on a saw; and window, door, partition or shower-enclosure fabrication units that do both. Yukti AI is in Surat and builds for shops across Surat, Vadodara, Rajkot, Navsari and the rest of Gujarat; see custom ERP software in Surat.
Either. The ERP keeps an operational ledger: GST invoices, receipts, payables, customer and supplier ledgers with ageing, credit and debit notes, and profit after the real cost of material consumed. It is not a statutory book of accounts or a GST return. Many Gujarat shops keep Tally for the accountant and have the ERP push or export invoices and receipts to it; others move off Tally in stages. No Tally, e-invoice or e-way bill connection is in this version. The options are explained in Tally integration with a custom ERP.
A custom build. Yukti AI built it around the two businesses’ own categories, hardware rules, bar lengths, kerf, minimum remnant, document formats and roles. The patterns — the mils unit library, the rule-based estimator, the piece-wise inventory, the cutting planner — are reusable, so another fabricator or trader gets a system built on the same foundations but shaped to its own shop. The difference from a package is discussed in custom ERP vs off-the-shelf ERP.
Each sheet has an entry unit — feet, inches or millimetres — and loose text such as 6’3”, 1829mm or 72in is parsed whatever the unit selector says. Every length is stored as an integer number of mils (thousandths of an inch), so there is no rounding drift between the site note, the estimate and the processor’s cutting size. The display converts back on demand: carpenter-style feet and inches to the nearest eighth, or millimetres. The same library serves the aluminium business, so a 6,000 mm bar and a 20 FT bar sit in the same stock list.
Area per panel is width in inches times height in inches divided by 144, which gives square feet. The company then applies one of four rounding modes — exact, up to the next quarter, up to the next half, or up to the next whole square foot — and a minimum billable panel area. Shops round up because a panel costs the same to cut, polish and toughen whether it is 15.17 or 15.25 sq.ft, and because quoting in quarter feet is what the trade expects. In the worked example, a 2’4” × 6’6” door is 15.1667 sq.ft exact and 15.25 sq.ft billable.
It is the smallest area a single panel is billed at, even if its measured area is less. A small return panel or a mirror still has to be cut, edged and processed, so shops bill a floor. The glass business defaults to 4 sq.ft, and a product category can override it; the build’s defaults set higher minimums for shower enclosures, partitions and railings. The owner sets these in company settings and the product master. In the worked example a 1’6” × 2’0” mirror measures 3.0 sq.ft and is billed at 4.0.
Each product category has hardware rules written as an item, a factor and a basis. The ten bases are fixed, per panel, per door or shutter, per fixed panel, per square foot, per running foot of perimeter, running length, height or width, and per metre of profile. When panels are added or changed, the rules recompute: add a door and the hinge and handle lines appear; remove it and they drop to zero and disappear. Whole-unit items round up. Manual lines and rate overrides are kept. The build labels its default factors as assumptions for the shop to confirm, and so does this page.
Yes. Factors, bases and items are data in the product master, not code. Change the shower-enclosure rule from 2 hinges per door to 3 and every new estimate follows it; saved estimates keep the lines they were made with. A shop can also add a rule (a second handle per sliding shutter), remove one, or override the rate or quantity on a single estimate line without touching the rule. That is the point: the shop writes its own hardware knowledge down once.
The glass rate per square foot for a panel is the thickness base rate multiplied by the grade factor, plus the processing charge, plus the toughening charge when the grade is a toughened one. The master holds six thickness rows from 4 to 12 mm and eight grades: clear float, toughened clear, toughened frosted, toughened tinted, toughened reflective, low-iron, lacquered and mirror. Rates are the shop’s own and are editable; none are published on this page.
Only to material. The wastage percentage is applied to glass, hardware and profile cost, never to labour or installation, which are per-square-foot charges by category. This avoids the common spreadsheet mistake of grossing up the whole estimate for wastage and double counting. The material requirement list shows glass square feet including wastage per thickness and grade, so purchasing matches the estimate.
Margin is a markup on total cost in this build: selling price equals total cost (material including wastage, labour, installation, extras) multiplied by one plus the margin percentage, with transport added at estimate level and GST added only on the quotation. The calculator shows cost, selling price, the resulting margin percentage and the rate per square foot for each line and for the estimate. If a shop thinks in margin on price instead, that is a settings decision made at the workflow audit.
Yes. An estimate has product lines, each with its own category, panels, rules and billing unit, so a shower enclosure in square feet, a railing in running feet and a mirror in numbers sit on one estimate and become items on one GST quotation with their specification and measurement text. Transport is at estimate level; installation can be per line or at quotation level. The material requirement list totals glass, hardware and profile across the lines.
A revision creates a new version with a note and keeps the earlier versions, so the history of what was sent and what the customer approved is on screen. Validity is a number of days (default 15, configurable); after it the status becomes expired and the quotation can be revised and re-sent. Statuses run draft, sent, approved, rejected, expired and converted. The quotation list shows open value, won value, conversion rate and average margin, and a quoted-versus-won chart by month.
Convert to sales order is a one-time action on an approved quotation. It creates the order with the quotation’s items, marks the quotation converted, and moves the linked project to the Order Confirmed stage. The project itself is created earlier, when the enquiry is converted, so measurement, estimation and quotation already sit on it. From the order, material is issued and the invoice is raised.
Enquiry Received, Site Measurement, Estimation, Quotation Sent (pre-sales); Order Confirmed, Advance Received, Material Procurement, Glass Processing, Hardware Procurement (execution); Installation Scheduled, Installation Completed (site); Final Payment, Project Closed (closure). Projects move as a list or by dragging cards on a Kanban, with the history written each time. Stage names and order are data and can be renamed or reduced for a shop that works differently; what stays fixed is that a quotation converts before a project is Order Confirmed.
Each project shows order value, estimated cost from the estimate, material issued at cost, and the margin that results. As glass and hardware are issued from stock to the project, the material figure grows and the margin is recomputed, so the owner sees whether the estimate held or whether a remake or extra hardware has eaten into it. Breakage and site return are their own stock movements, so a broken panel is counted and a returned one comes back to stock.
It is choosing which bars and remnants to cut, and in what order, so an order’s lengths are produced with the fewest fresh bars opened and the least scrap, after allowing for the saw kerf. It is the one-dimensional cutting-stock problem. In this build the cutting planner takes the order lines, the available pieces of that profile and colour, the kerf and the minimum remnant, builds a plan with a Best Fit Decreasing heuristic that uses remnants first, compares it with a full-bars-only plan, draws each bar to scale and prints a cutting list. The full description is in how the cutting optimiser works.
The pool is sorted remnants first, shortest first, then full bars shortest first. Cuts are ordered three ways — longest to shortest, long/short interleave, and two longs then one short — and each ordering gets a greedy pass. For each cut the planner prefers an already-open bar where the leftover after the cut and its kerf would be smallest; otherwise it opens a remnant, scored by its leftover; a fresh full bar carries a large penalty so it is a last resort. Leftovers that would fall between zero and the minimum remnant are penalised. The cheapest of the three plans is kept.
No, and the screen says so: the results are heuristic, from a Best Fit Decreasing algorithm with remnant prioritisation, practical for the saw and not a claim of mathematical optimality. Provably optimal plans for real order mixes need exhaustive or integer-programming methods that are slow and rarely worth it at a trader’s saw. The multi-start over three orderings avoids the worst cases of a single greedy pass, and the operator can edit the plan by hand with the same function recomputing kerf and leftovers. Yukti AI does not publish a percentage for how close the plan comes.
Kerf is the material the blade removes on each cut, 0.125 inch by default in this build and configurable per company and per profile. It is charged on every cut, but never more than what is physically left after the piece: kerf equals the lesser of the kerf setting and the remaining length minus the cut length. A cut that finishes a bar exactly costs no kerf. In the worked example, two cuts of 8 and 7 FT from a 20 FT bar cost 0.25 inch of kerf and leave 4.979 FT, not 5 FT.
The minimum remnant is the shortest leftover worth keeping as stock, 2 FT by default, configurable per company and per profile. A leftover at or above it becomes a remnant record with its own ID, its parent bar’s cost per foot and a link to the job; the optimiser will use it first next time. A leftover below it is booked as scrap with a movement row and counted in the wastage report. In the 30-piece example, the 1.958 FT leftovers from the 6+3+6+3 bars are scrap only because four kerfs pushed them under 2 FT.
Plan A cuts from full bars only, as a quantity-only inventory would have to. Plan B uses remnants first, then full bars. The build shows both with bars opened, remnants consumed, scrap and utilisation, and names the better one by a rule that scores one saved bar above up to 1,000 feet of scrap. Using an 8 FT remnant for a 6 FT piece saves opening a bar but leaves 1.99 FT, which is scrap; so in the worked example Plan B opens 8 bars instead of 9 while scrap rises from 9.79 FT to 12.29 FT and effective utilisation falls from 93.3% to 91.7%. Both numbers are shown so the operator decides.
Yes. A cut can be removed from a bar or moved to another bar, and the same function that built the plan recomputes kerf and leftover for the edited bar, flags a bar that is over capacity in red, and turns any requirement that is no longer placed into a shortage line. Because the optimiser, the editor and the execution check all use one function, they cannot disagree about what a bar can hold. The edited plan is saved as the cutting job and printed as the cutting list.
Because a quantity cannot answer the question a cutting shop asks all day: can this length be cut without opening a new bar? Eighteen bars may be eleven full bars and seven leftovers of different lengths. With one record per piece — ID, length, status, location, cost per foot — the planner can allocate real pieces, the challan can mark the exact pieces sold, a remnant can be traced to its parent and job, and stock value is each piece’s remaining length times its own cost rather than an average.
Three things. A consumed, scrapped or sold piece can never be cut again, and a damaged piece must be released first. Before a cutting job is executed every piece is validated: it exists, is in a cuttable status, is not used twice in the job, has the length the plan assumed, and its cuts still fit; if any check fails the whole job is refused. Then execution is applied in one state update — parents consumed, remnants created, scrap booked, movement rows written — so there is never a half-executed job. Every change is an append-only movement row in the audit trail.
A remnant inherits its parent bar’s landed cost per foot, so a 4.979 FT remnant from a bar that cost a certain amount per foot is valued at 4.979 times that figure. Stock value is the sum over all pieces of remaining length times each piece’s own cost per foot; weight comes from the profile’s weight per metre. Remnants are not treated as a cost by the planner, because they return to stock at full value; scrap is. The profit report computes gross margin after the real cost of material consumed by cutting, kerf and scrap included.
Yes. Each profile has a rate basis, per running foot or per kg, and the order line uses the basis of its profile; weight is computed from the profile’s weight per metre and the length cut. An order can mix a handrail tube sold per kg with a slim partition profile sold per foot. The invoice carries each line in its own unit with its HSN code.
Yes. Lengths are stored in mils and millimetres convert at 39.37 mils per mm, with a rounding of about 0.03 mm that does not matter at the saw. Computed from the build’s logic: a 6,000 mm bar cut into 2,400 + 1,800 + 1,500 mm leaves 290.5 mm after three kerfs of 3.175 mm, which is under the 2 FT (609.6 mm) minimum and is scrap; the same bar cut into 2 × 2,500 mm leaves 993.6 mm, which is stocked as a remnant. The minimum remnant can be set in millimetres.
No AI model, voice agent or chatbot is in this version. The automation that is built: hardware lines added and re-synced from category rules, live estimate recalculation, estimate to quotation to order to project stage conversion, stock availability checked against real pieces while an order is typed, cutting plan generation with the Plan A vs Plan B comparison, atomic execution of cutting jobs with remnant creation and scrap booking, document numbering, GST split, receipt allocation and ageing, and an audit trail. AI items such as estimation from a photo, cut-list intake from WhatsApp and an owner’s brief are buildable and rest on other Yukti AI builds; see AI and automation.
Not in this version; it is a buildable layer. The ERP would trigger messages through the WhatsApp Business API when a quotation is sent or revised, when a project reaches Advance Received, Glass Processing or Installation Scheduled, when a challan is created and when an invoice falls due, and could run an enquiry agent that answers price-range questions from the shop’s own rules and books a measurement visit, as Yukti AI did with the Arjun WhatsApp AI sales agent. Meta charges per conversation separately from development. See WhatsApp automation.
It can be built. A cut list arrives as a photo or a text line such as “SLIM-A black: 10 of 6 ft, 10 of 5 ft, 10 of 3 ft”; an intake agent reads it into an order with the right variant and lines, the live availability check runs against real pieces, a person confirms, and the cutting planner produces Plan A and Plan B as it does today. The intake pattern is the one Yukti AI built for WhatsApp sales; the availability check and the planner are already in this build. Pushing the finished cutting list to a saw with a digital stop depends on the saw.
A custom ERP from Yukti AI starts from ₹30,000, and a first working version is typically ready in about 7–10 days. A two-business system of this breadth is toward the larger end, and the quote depends on which side comes first, the number of businesses, users and locations, how much data moves from Excel or Tally, which integrations are needed (WhatsApp, Tally, e-invoice, a saw interface) and hosting and support. The quote follows a free 30-minute workflow audit; see custom ERP cost in India and contact Yukti AI.
Case study at a glance

Summary

Knowledge summary

Yukti AI, a software company in Surat, built one glass and aluminium ERP for two Gujarat businesses: Multiple Glass Solutions (glass fabrication and installation) and KJ Alutech (aluminium profile trading and cutting), with a business selector and separated data. The glass side runs enquiry to measurement sheet (feet, inches or millimetres, stored as mils), estimation (area = W × H ÷ 144 with four rounding modes and a minimum billable area; glass rate from thickness, grade, processing and toughening; hardware by factor × basis across 10 bases with auto-sync; wastage on material only; margin as markup on cost), GST quotation with revisions and validity, sales order, a 13-stage project board with margin against material issued, glass and hardware stock, invoices, receipts and ledgers. The aluminium side keeps every bar and remnant as its own record with ID, status, location and cost per foot; a cutting planner (Best Fit Decreasing with remnant priority, three orderings, kerf 0.125 inch capped by material left, minimum remnant 2 FT, Plan A full bars only vs Plan B remnants first); cutting jobs with a printable list and atomic execution that consumes parents, creates remnants, books scrap and writes movements; wastage reports; purchases into pieces; challans, invoices and ledgers. Computed examples: a 20 FT bar cut 8 + 7 leaves a 4.979 FT remnant; a 30-piece order takes 9 bars with 9.79 FT scrap and 77.8% utilisation (93.3% effective); remnants-first saves one bar but raises scrap to 12.29 FT; a 6,000 mm bar cut 2,400 + 1,800 + 1,500 leaves 290.5 mm scrap. Six roles, 16 modules, 51 screens, Vite, React, TypeScript. It is the working version built around the two businesses’ workflows, with records kept in the browser; no backend, Tally, WhatsApp or AI is connected, and usage and results are not claimed. A custom ERP from Yukti AI starts from ₹30,000 with a first version in about 7–10 days.

Still measuring on paper
and cutting bars by guess?

Send us one recent quotation and tell us how the job ran — from the site measurement and the estimate to the saw, the remnant rack and the invoice. We’ll show you what one system with measurement sheets, estimation, project stages, piece-wise stock and a cutting planner would replace.

Free audit · No commitment required · Surat, Gujarat