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.
Four office jobs, and why only two get priced here
| Job | What AI does | Setup effort | Priced here? |
|---|---|---|---|
| Costing and quotes | Builds the costing sheet, drafts the quote text, checks the arithmetic logic | Low | Yes (Job A) |
| Quality records | Summarises defect logs by loom, shift, yarn lot and fabric | Low to medium | Yes (Job B) |
| Production planning | Drafts a weekly loom plan from orders, lead times and changeover times | Medium | Described below |
| Design drafts | Generates colourways, repeat ideas and mood boards | Low | Described 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.
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.
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
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 nowStep 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.
| Line | Input or formula | Cost per metre |
|---|---|---|
| Yarn | 0.22 kg per metre x $6.50 per kg | $1.43 |
| Waste allowance | 8% on yarn | $0.11 |
| Warping and setup | 10 hours x $18 per loom hour, over 400 m | $0.45 |
| Weaving | 20 metres per hour = 20 hours x $18, over 400 m | $0.90 |
| Finishing and packing | $0.25 + $0.05 | $0.30 |
| Cost | Sum of the lines | $3.19 |
| Price at a 22% margin on price | Cost 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.
| Date | Loom | Shift | Fabric code | Yarn lot | Defect type | Metres affected | Outcome |
|---|---|---|---|---|---|---|---|
| Mon | L7 | Late | TW220 | Y-1042 | Broken pick | 6 | Cut out |
| Tue | L7 | Early | TW220 | Y-1042 | Broken pick | 9 | Second quality |
| Wed | L3 | Early | PL140 | Y-1051 | Oil stain | 2 | Cut out |
| Thu | L7 | Late | TW220 | Y-1042 | Slub | 5 | Second 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
- Which fabric types, widths and colours was the system trained on? Plain weaves are not mixed knits.
- Which defect classes does it detect, and what is the false alarm rate on my fabric?
- What does the quote include: hardware, software, installation, training and yearly support?
- Can I test it on my own rolls before buying?
- 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
- Day 1. Time three quotes by hand and write down the minutes.
- Day 2. Ask the assistant for the costing structure and build the sheet.
- Day 3. Test the sheet against a finished job, and fix the gap.
- Day 4. Type last month's defects into the row format above, with codes only.
- 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
- AI Pattern Making: Can It Replace CAD for a Small Apparel Maker? — Can AI pattern making replace CAD for a small apparel maker.
- Sawmill Software: Where AI Helps With Orders, Yield and Quotes — A similar quoting and yield question in another materials trade.
- AI Demand Planning Software: Built-In Add-Ons vs a ChatGPT Spreadsheet — Demand planning with add-ons versus a spreadsheet.
- How to Check AI Is Doing Good Work, Not Just Fast Work — How to check AI output is good, not just fast.
- How to Run Your First AI Pilot Project in a Small Business — Run a first pilot with a clear start and finish.
- Predictive Maintenance With AI: Realistic for a Small Workshop? — The same payback question asked about sensors on machines.
- What Should a Small Business Automate First With AI? — A general rule for choosing the first job in any business.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
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.