AI in the Textile Industry: Two Mill Jobs Priced by Payback

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for AI in the Textile Industry: Two Mill Jobs Priced by Payback.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for AI in the Textile Industry: Two Mill Jobs Priced by Payback.

A small textile mill or workshop can use AI today for four office jobs: costing and quotes, production planning, design drafts and quality records. Costing and defect records pay back fastest because they need only a spreadsheet and a chat assistant. Camera inspection systems pay back only at high metreage and need a vendor quote first.

The catch is that both cheap jobs pay only if someone acts on what they show. A costing sheet nobody updates still quotes last season's yarn price, and a defect summary nobody takes to the loom floor changes nothing. Every volume, wage and price in the worked examples below belongs to one illustrative 12-loom workshop, so swap in your own figures before deciding anything.

Follow me on Instagram@sagnikteaches

Four office jobs, and why only two get priced here

JobWhat AI doesSetup effortPriced here?
Costing and quotesBuilds the costing sheet, drafts the quote text, checks the arithmetic logicLowYes (Job A)
Quality recordsSummarises defect logs by loom, shift, yarn lot and fabricLow to mediumYes (Job B)
Production planningDrafts a weekly loom plan from orders, lead times and changeover timesMediumDescribed below
Design draftsGenerates colourways, repeat ideas and mood boardsLowDescribed below

Planning and design are worth knowing about, but they are harder to price because the saving is a mix of time and judgement. The costing and quality jobs have simple numbers behind them, so they make good first tests. Tech packs and cost sheets for garment brands sit in a neighbouring niche, covered in the tutorial on AI tech packs for fashion brands.

Connect on LinkedInSagnik Bhattacharya

The example workshop used throughout

An illustrative workshop: 12 looms making woven cotton and cotton-blend fabric for small brands and interior makers. It sells about 1,000 metres a week at an average of $4 a metre. Two people split the office work. The owner quotes about six jobs a week, each quote taking around 45 minutes because the yarn price, waste allowance, setup time and loom hours are scattered across a notebook, a spreadsheet and a supplier email. Quality records are a paper defect log filled in at the inspection table and typed up on Fridays. The owner values office time at $25 an hour.

Subscribe on YouTube@sagnikteaches

Job A: costing and quotes

What goes wrong in the current routine

Quoting by memory leads to two kinds of error. The first is a stale input, such as an old yarn price. The second is a forgotten cost, such as warping time or the waste at the start and end of a beam. Both make a quote either too high, so you lose the job, or too low, so you win a job at a loss. A written structure fixes the forgotten cost, and a single place for prices fixes the stale input.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Step 1: have the assistant propose the costing structure

I run a small weaving workshop. Propose a costing sheet for quoting a woven fabric job.
List the input cells I must fill in (yarn type, price per kg, yarn weight per metre, waste percentage, warping hours, loom setup hours, weaving speed in metres per hour, finishing cost, packing, overheads per loom hour, margin percentage) and the formula for each calculated line.
Show the formulas for a spreadsheet. Do not invent any numbers. Flag any cost I may have forgotten.

A good output lists around a dozen inputs and flags a few extras, such as beam changes, sampling charges and carriage. You then build the sheet yourself or ask the assistant to explain each formula one at a time. The rule that stops errors: the spreadsheet does the arithmetic. The assistant explains and structures; it does not add up your numbers.

Step 2: test the sheet on a job you already know

Pick a finished job where you know the true cost. Enter its inputs, and compare the sheet's cost per metre with what you found afterwards. Suppose the sheet says $2.68 a metre and the real cost was $2.90. Find the gap, which is often a missing waste allowance or too fast a loom speed, and fix it before quoting anyone.

Step 3: draft the quote text from the sheet

Write a short quote email from these facts only.
Customer reference: [job code]. Fabric: 220 gsm cotton twill, 150 cm width, 400 metres.
Price: $4.10 per metre, total $1,640. Lead time: 3 weeks from yarn arrival. Payment: 50% on order.
Validity: 14 days. Tone: plain and courteous. Under 120 words. Do not add terms I have not given.

A realistic output is a clear short email. What to fix: the model may add "free sampling" or "express options" to be helpful. Delete both. Check the total ($4.10 x 400 = $1,640) before sending.

A filled-in costing sheet for the 400-metre twill job

Here are the numbers behind the $4.10 quote above, all assumed for illustration. Each line is one row of the spreadsheet, and the last two are formulas rather than inputs.

LineInput or formulaCost per metre
Yarn0.22 kg per metre x $6.50 per kg$1.43
Waste allowance8% on yarn$0.11
Warping and setup10 hours x $18 per loom hour, over 400 m$0.45
Weaving20 metres per hour = 20 hours x $18, over 400 m$0.90
Finishing and packing$0.25 + $0.05$0.30
CostSum of the lines$3.19
Price at a 22% margin on priceCost divided by 0.78$4.09, quoted as $4.10

Two details matter. First, the margin is taken on the selling price, so you divide by 0.78 rather than multiply by 1.22. Multiplying would give $3.89 and a real margin of only 18%. Second, the weaving speed is the most sensitive input: at 16 metres an hour instead of 20, weaving cost rises from $0.90 to $1.13 and the margin on a $4.10 price shrinks by between 5 and 6 points. Ask the assistant to explain why the margin formula divides, as a check that you understand it, and ask it which input would move the price most if it were 10% wrong. A sheet you understand is a sheet you can defend to a customer who pushes back on price.

Handling a repeat customer without redoing the sheet

Once the structure exists, repeat quotes become a copy of a previous row with one or two cells changed. Keep a tab with one line per past job: fabric code, date, yarn price used, cost per metre, quoted price, actual cost. After ten rows, ask the assistant to compare the quoted and actual columns and list jobs where the gap exceeded 3%. That list tells you which input to correct first, and it makes next year's yarn price rise a matter of changing one cell rather than a new argument.

Payback for Job A

Assumed timings: 45 minutes a quote now; with the sheet and a saved prompt, about 20 minutes. That saves 25 minutes a quote, or about 2.5 hours across six quotes a week. At $25 an hour that is roughly $62 a week, or $270 a month. The tool cost is a chat subscription at about $20 a month, so the monthly saving is around 13 times the cost. Setup, including building and testing the sheet, might take 8 hours, worth $200. Payback arrives inside the first month.

The larger gain may not be time. Say the old method underpriced one job in ten by 6%. On an average $1,600 job, that is $96 lost per underpriced quote, and on 24 quotes a month about $230 a month of margin recovered if the sheet catches those cases. That figure is speculative, so measure it by comparing the sheet's cost against actual costs on your next ten jobs. For the garment side of costing, the tutorial on a clothing cost sheet from a tech pack gives a similar method.

Job B: quality records

The paper defect log problem

Defect logs are usually written well and read badly. Entries pile up in a folder, and the patterns that matter stay hidden: one loom producing most of the broken picks, one yarn lot behind the slubs, one shift with more oil stains. Typing the log into a spreadsheet each Friday is the first step. The second is asking questions of it.

A log structure that works

One row per defect event, with the same columns every time.

DateLoomShiftFabric codeYarn lotDefect typeMetres affectedOutcome
MonL7LateTW220Y-1042Broken pick6Cut out
TueL7EarlyTW220Y-1042Broken pick9Second quality
WedL3EarlyPL140Y-1051Oil stain2Cut out
ThuL7LateTW220Y-1042Slub5Second quality

Strip out anything that identifies a customer or a worker: use loom numbers and codes, not names. Then give the assistant a month of rows and a precise question.

Below is a month of fabric defect events from a small weaving workshop (CSV).
1. Count metres affected by loom, by shift, by yarn lot and by defect type.
2. Tell me which single factor accounts for the largest share, and show the numbers behind it.
3. List any pattern that two columns share, for example one loom with one yarn lot.
4. Say what you cannot conclude from this data.
Do not guess causes; list questions I should ask on the floor.

A realistic output might report that loom L7 accounts for 41% of the metres affected, that yarn lot Y-1042 accounts for 52%, and that the two overlap, so the lot and the loom cannot be separated from this data. That last caution matters: the answer is a question for the floor, such as running Y-1042 on another loom for a day to see if the defects follow the yarn or the machine.

Check the numbers before acting

Recount one loom by hand. If the assistant says L7 had 63 metres affected and your count is 58, find out why. Often a row was dropped or counted twice. In a long list, ask for the totals by method such as a pivot table, so you can reproduce them in your spreadsheet rather than trusting a figure the model typed out.

Payback for Job B

Typing up and summarising a weekly log takes the office about 90 minutes now, of which the summary and chart production is perhaps 40 minutes. With an assistant, the summary drops to 10 minutes, saving around 30 minutes a week, or about $13 a week at $25 an hour. That alone does not justify a project. The return comes from the defects avoided.

Suppose 3% of output, 30 metres a week, is sold as second quality at a 40% lower price than the $4 first-quality price. The loss is 30 x $4 x 0.40 = $48 a week, about $2,500 a year. If the records point to a cause the floor can fix, and the second-quality rate halves to 1.5%, the saving is $24 a week, about $1,250 a year. Against a chat subscription of $240 a year, that is a clear gain, but the gain depends on someone acting on the pattern. Without that, the record is only tidier.

Our tutorials on spotting patterns in complaints, returns and defects and AI quality control for small manufacturers cover the habit in more depth.

Where camera inspection systems fit

Vision systems watch fabric as it moves, using cameras and software trained to spot defect types, and can grade rolls. They suit high-volume lines where people inspect for hours. The fabric-inspection product pages I checked publish no prices, so there is no verified list price to give here: you need a written quote. The sum below uses a hypothetical figure to show the method.

Say a supplier quotes $30,000 installed for one inspection station, with $3,000 a year for support. Take the earlier workshop: a second-quality loss of about $2,500 a year. Even if the system halved that loss, the saving is $1,250 a year against a yearly cost of at least $3,000 plus the capital. It does not pay back at 1,000 metres a week.

The break-even rises with volume. At 20,000 metres a week with the same 3% second quality at $4 a metre and a 40% drop, the loss is 600 x $4 x 0.40 = $960 a week, about $50,000 a year. Halving that saves $25,000 a year, and the same $30,000 system pays back in roughly 16 months once the yearly support is deducted. The numbers are invented, but the shape is real: payback depends on throughput, on the price drop for seconds and on how much of the defect problem the system really removes.

Questions to put to a vision-system vendor

  1. Which fabric types, widths and colours was the system trained on? Plain weaves are not mixed knits.
  2. Which defect classes does it detect, and what is the false alarm rate on my fabric?
  3. What does the quote include: hardware, software, installation, training and yearly support?
  4. Can I test it on my own rolls before buying?
  5. What happens to the data, and who can see my production figures?

The tutorial on what AI visual inspection costs a small manufacturer goes through those costs in more detail. Sensors that watch the looms themselves, rather than the fabric, raise the same payback question, and the arithmetic has the same shape: hours or seconds avoided against an up-front price.

Production planning: a weekly loom plan from your own constraints

Planning is the third office job. A chat assistant can turn a list of orders into a draft loom plan if you give it the constraints. Provide order codes, metres, due dates, which fabrics can run on which looms, and changeover time. Ask for a plan in a table plus a list of conflicts.

Draft a one-week loom plan from this data. Constraints: 12 looms; a changeover takes 3 hours; looms L1-L4 can run wide fabrics only; no loom runs more than 20 hours a day.
Orders: [code, metres, due day, fabric type, speed in metres per hour].
Return a table (loom, order, start, finish) and list every order that cannot meet its due date and why.

Treat the result as a proposal. Models make scheduling slips, such as double-booking a loom or ignoring a constraint, so check the table line by line. Your planner knows things the data does not, such as a loom due a service. For a workshop with 12 looms, a good use is to ask the assistant for two alternative plans and the trade-off between them, then choose.

Design drafts: colourways and repeats

For design, AI helps most at the early stage: producing colourway ideas from a mood description, exploring repeats, and making a client board. It does not replace the production check that a pattern can be woven or printed within your equipment's limits. Image tools differ in licensing and in how well they handle repeats. The tutorial on AI print repeats for a small brand shows a workflow, and it is worth reading the terms of any image tool before using its output for a customer.

A mistake that looked like a saving

An illustrative workshop asked a chat assistant to cost a job directly, pasting in yarn price, weight and hours. The answer looked tidy and was $0.40 a metre too low, because the model rounded the yarn weight early and left out the beam-end waste that was in the notes. The quote won the job and lost money. The fix was the structure above: the sheet calculates, the assistant explains, and every new sheet is tested against a job with a known cost. A habit of comparing every quote with the actual cost afterwards catches this kind of drift within a month.

How to check each job is working

  • Quotes: after ten jobs, compare quoted cost with actual cost per metre. If the gap is within 3%, the sheet is good. If not, find the missing line.
  • Defect records: check that the log is complete by counting entries against rolls inspected for one week.
  • Time: record minutes per quote and per weekly summary before and after. A claimed saving without a before figure is a guess.
  • Outcomes: track the second-quality percentage monthly. If it does not move after you act on the pattern, the pattern was not the cause.

A week to start

  1. Day 1. Time three quotes by hand and write down the minutes.
  2. Day 2. Ask the assistant for the costing structure and build the sheet.
  3. Day 3. Test the sheet against a finished job, and fix the gap.
  4. Day 4. Type last month's defects into the row format above, with codes only.
  5. Day 5. Run the defect-summary prompt, recount one loom by hand, and write down two questions for the floor.

If you would like help ranking your own mill's jobs the same way, that is what my AI implementation consultation covers. Whichever job you start with, keep the timings from Day 1: they are the only fair test of whether the second month is better than the first.

Questions from small mill and workshop owners

Do I need special AI software for a small mill?

Not for the first two jobs. A spreadsheet plus a general chat assistant covers quote costing and defect-record summaries at about the cost of one chat subscription. Specialist software, such as camera inspection systems, is a separate decision that depends on how many metres you inspect and what a second-quality roll costs you.

Can ChatGPT do my costing sums?

Use it to build and explain the costing sheet, not to do the sums itself. Ask it for the formula structure, put your real yarn and labour figures in a spreadsheet, and let the spreadsheet calculate. Then test the sheet against one finished job you already know the true cost of.

What does camera-based fabric inspection cost?

Vendors mostly quote privately, so I cannot give a reliable list price. Ask two or three for a written quote covering hardware, software, installation, training and yearly support, and ask which fabric types and defect classes the system has been trained on. Then run the payback sum in this tutorial with their figure.

Is it safe to put customer order details into an AI tool?

Strip customer names and contact details first, and use job codes instead. Check your plan's data terms and switch off training use where it is on. Prices, specifications and order volumes can also be commercially sensitive, so share only what the task needs.

How soon should a small mill see a return?

For the two jobs here, within weeks, because the cost is a chat subscription and a few hours of set-up. For hardware such as vision inspection, payback is measured in years at small volumes, so decide only after you have counted your own seconds and returns for at least a quarter.

Further reads

Sources: ChatGPT pricing page (Plus plan price); fabric-inspection vendor product pages (no published prices). Volumes, prices and hours in the worked examples are illustrative assumptions.

Want your mill's first AI job priced properly?

On a 1:1 call we can take your quoting and quality routines, time them, and work out which job pays back first and what to check before buying hardware.

Book a 1:1 call with me