Can AI Quote Powder Coating Jobs? What It Gets Right and Wrong

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Can AI Quote Powder Coating Jobs? What It Gets Right and Wrong.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Can AI Quote Powder Coating Jobs? What It Gets Right and Wrong.

Yes, AI can quote a powder coating job from a part list, as long as you give it your own rates and timings. It will total area, powder, labour and oven time well. The shop must still measure surface area on anything complex, and supply prep, masking, colour-change and oven-load times, because the AI will otherwise guess them low.

The usual failure is not arithmetic. A model told "quote 40 brackets, 12 gate panels and 6 table bases in satin black" will happily price powder and spray time, then forget that the brackets need threaded holes plugged and the gates need blasting first. The result looks professional and loses money. Everything below is about stopping that, with one worked job priced line by line.

Follow me on Instagram@sagnikteaches

Where an AI quote usually leaves out the expensive hours

A powder coating job has seven cost lines, and an AI left to its own devices usually prices only three of them. It prices the powder, the spraying and the curing because those are the steps every article about powder coating describes. The four it drops are the ones that eat your day.

Connect on LinkedInSagnik Bhattacharya
  • Prep: degreasing, blasting, stripping old coatings, outgassing cast parts. Often the largest labour line.
  • Masking: plugs for threads and bores, tape for contact faces, caps for tube ends. Priced per feature, not per part.
  • Set-up: booth cleaning between colours, changing the hopper, test panel, hanging jigs or hooks.
  • Consumables and handling: plugs, caps, tape and hooks, plus unhanging, checking film thickness and boxing.

The three it prices are powder, spray labour and oven time. Keep that split in mind, because the fix is to name all seven lines in your prompt and give a number for each. If you also quote fabricated work, the tutorial on pricing fabrication from a drawing covers the same habit on the metalwork side.

Subscribe on YouTube@sagnikteaches

One job priced line by line

This is an illustration with made-up shop rates, so swap in yours. A customer sends a part list: 40 steel brackets, 12 bar-frame gate panels and 6 table bases, all in one satin black powder. The shop has a batch oven and a manual booth.

PartQtyArea each (sq ft)Total area (sq ft)
Steel bracket401.248
Bar-frame gate panel129.0108
Table base66.539
Total195

The shop has already measured these areas from the customer's drawings, which is the step the AI cannot do for you. Now the shop's own numbers go in: labour $65 an hour, oven running cost $18 an hour, powder $7 a pound, target margin 30% on price.

Powder. The commonly published coverage formula is 192.3 divided by (specific gravity times film thickness in mils), which gives square feet per pound at 100% transfer. For a powder of specific gravity 1.5 at 2.5 mils that is 192.3 / 3.75 = 51.3 sq ft per pound. If your gun setup transfers about 60% of the powder to the part, real coverage is about 30.8 sq ft per pound. So 195 sq ft needs about 6.3 pounds, roughly $44.

Labour and oven. The shop's timings, from its own job history, are in the next table. Notice that prep and masking together are more than spraying.

LineHow it is countedHoursCost
Prep (wash and blast)Brackets 3 min each, gates 10 min each, bases 6 min each4.6$299
MaskingBrackets: 2 plugs at 0.5 min each; gates: 4 min per panel for hinge lugs1.5$97.50
Set-up and booth cleanOne flat allowance for the job0.5$32.50
Hang, spray, unhang5 oven loads at 0.6 hour each3.0$195
Oven5 loads at 0.75 hour each (heat-up, cure, cool)3.75 oven hours$67.50
Powder6.3 lb at $7$44
Plugs, tape, hooksConsumables allowance$25
Cost$760.50

A 30% margin on price means dividing cost by 0.7, so the price is about $1,086. Call it $1,085. Now compare with what you get if the AI prices only powder, spraying and oven: $44 + $195 + $67.50 = $306.50, which becomes about $438 at the same margin. That is $647 less than the right quote, on a job that looks routine.

The loads number is worth a second look. Brackets all hang on one rack, six table bases on another, but gate panels are large, so four fit per load and twelve take three. That rack plan is a decision about oven space, and it is yours. If the AI is not told the rack capacity, it will assume everything fits in a single pass.

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

What the AI does well, so you can stop doing it by hand

Use the AI for the work that is tedious but not a judgement call:

  1. Turning an emailed part list, a photographed delivery note or a spreadsheet into a clean table with quantities and dimensions.
  2. Multiplying out area, powder weight, labour and oven cost from the rates you supplied.
  3. Grouping parts by colour and by oven loading so you see how many changes and loads the job implies.
  4. Writing the covering note with the finish spec, lead time and exclusions in plain wording.
  5. Flagging a line where the numbers look odd, such as a part with an area that does not match its dimensions.

It does not do well at deciding how many gate panels fit on your rack, whether a casting will outgas, or whether the customer's "RAL 9005" really matches the powder you stock. Those are shop knowledge.

A prompt that forces all seven lines

Here is a prompt template with the shop's numbers already filled in. Keep your own version in a saved note so it is the same every time.

You are helping a powder coating shop prepare a quote. Use only the shop figures below; if a figure you need is missing, ask me instead of assuming it.

SHOP FIGURES
- Labour $65/hour. Oven $18/hour. Powder $7/lb.
- Powder coverage: 192.3 / (specific gravity x mils) sq ft per lb at 100%; transfer efficiency 60%. Specific gravity 1.5, film 2.5 mils unless I say otherwise.
- Prep minutes per part: bracket 3, gate panel 10, table base 6.
- Masking: 0.5 minute per plug; gate hinge lugs 4 minutes per panel.
- Set-up and booth clean: 0.5 hour per job; add 0.5 hour for each extra colour.
- Oven: 0.75 hour per load. Rack capacity: 40 brackets, 4 gate panels, 6 table bases per load.
- Consumables: $25 per job. Margin: 30% on price. Minimum charge: $120.

PART LIST (areas already measured by us)
40 x bracket, 1.2 sq ft each
12 x gate panel, 9.0 sq ft each
6 x table base, 6.5 sq ft each
Finish: satin black, one colour.

OUTPUT
1. A table with seven cost lines: prep, masking, set-up, spray labour, oven, powder, consumables. Show hours and dollars.
2. Total cost, price at 30% margin, price per sq ft.
3. Any assumption you made, listed.
4. A three-line customer note with finish, lead time placeholder and exclusions.

Here is what a good reply looks like, labelled illustrative. The AI returns the table above, then adds something like: "Assumption: gate panels need blasting; assumed 4 panels per load from your rack figure; lead time left as [days] for you to fill in." That last line is the useful bit. An assumption stated is an assumption you can correct. If the reply says "assumed standard prep" without a number, send it back.

Surface area: the one input to measure yourself

Powder is sold by weight but quoted by area, so every price hangs on a square-foot figure. A model can calculate area from dimensions, but it cannot see your part. If a customer sends "mild steel tube frame, about 6 ft by 3 ft", the AI has no idea how many tubes there are, their diameter, or whether the frame has a mesh infill.

Keep a short list of measuring rules and paste it into the prompt:

  • Flat plate: 2 x length x width, plus edges (perimeter x thickness). Edges matter on thick laser-cut plate.
  • Round tube: pi x outside diameter x length. Add the inside only if it is to be coated.
  • Square or rectangular tube: perimeter x length.
  • Mesh and expanded metal: about 2 x the plan area as a start, then confirm on a sample; the wire sides add more than people expect.
  • Castings and fabrications with recesses: measure a representative part, or ask for the CAD file and read the surface area from it.

As an example of the tube rule: a handrail made from 1.5 inch outside-diameter tube, 8 ft long, has an area of pi x 1.5 in x 96 in = 452 sq in, which is 3.1 sq ft. Four of them is 12.6 sq ft. The AI will get this right if you state the rule. It gets it wrong when a customer writes "four railings" and no diameter, and it quietly picks one.

For a photo-based estimate, treat the AI's figure as a screening number to decide whether a job is worth a site visit, and put a hand-held tape on it before pricing. A part that is 30% bigger than guessed uses 30% more powder, spray time and often an extra oven load.

Batch size and the oven: why 5 parts and 500 parts price differently

An oven load is a fixed block of time. Whether it holds ten brackets or forty, you pay for the heat-up and cure. A common AI error is to take a per-square-foot rate from a 500-part run and apply it to a 5-part run.

A quick sum shows the effect. Say a job is one load of 5 brackets, and the oven costs $18 an hour for 0.75 hour, which is $13.50. Spread over 5 brackets, that is $2.70 each. The same load holding 40 brackets is $0.34 each. Add set-up of 0.5 hour at $65, which is $32.50, and the 5-bracket job carries $6.50 per part of set-up while the 40-bracket job carries $0.81. Ask the AI to show per-job costs and per-part costs separately, and to apply your minimum charge after the sum, not before.

Oven load planning is also where cure schedules bite. If one powder cures for 10 minutes at 400 degrees Fahrenheit metal temperature and another needs a lower temperature for longer, they cannot share a load. Heavy parts take longer to reach metal temperature, so a cast iron base and a thin bracket in the same load do not both cure in the same time. Put the cure schedule from each powder's data sheet in the prompt for any job with more than one product.

Colour changes: a cost that belongs to the job, not the part

Changing colour means cleaning the booth, the gun, the hoses and often the reclaim system, then spraying a test panel. How long that takes depends on your booth, so measure it. A manual booth with a single gun may be 20 to 40 minutes; a reclaim system may take longer. Those figures are examples; time your own on the next three changes.

Take a customer asking for three colours across 24 small items. The AI should treat that as three jobs for set-up purposes. At 0.5 hour each and $65 an hour, the colour changes alone are $97.50 before any parts are sprayed. If the customer then shrinks the order to one colour, the quote should shrink by the extra $65, and a model with the formula in front of it will do that arithmetic instantly.

Special finishes behave differently again. A metallic or a clear-over-colour needs two coats and two cure cycles, so the oven and spray lines double. Texture powders and candy colours often cost more per pound and may need a particular film thickness. Put these as multipliers in your notes: "two-coat systems: spray labour x 2, oven loads x 2, powder x 1.8".

Prep and masking: where the quote is won or lost

Prep time depends on what comes in the door, and no part list reveals it. New, clean laser-cut steel might need only a wash. A rusty gate needs blasting, and a previously painted one may need stripping. Cast parts may need a pre-bake to outgas before powder or they will pinhole.

Give the AI a condition code for each line and your minutes for each code:

CodeCondition on arrivalPrep rule (illustrative)
ANew, clean, bare steelWash and dry: 1 minute per sq ft
BLight rust or mill scaleBlast: 3 minutes per sq ft
CPreviously paintedStrip then blast: 6 minutes per sq ft
DCast or galvanisedOutgas bake plus blast: 4 minutes per sq ft plus one extra oven pass

Masking works the same way, priced per feature. A customer part list rarely says "six tapped holes, two bearing bores". Ask the AI to read the drawing notes or the email and list every masking feature it can find, then ask the customer to confirm. Where it cannot find any, it should say "no masking features stated" rather than assume none exist.

In the worked job, masking was 1.5 hours or $97.50. If the customer later says the table bases have threaded inserts, six bases with four inserts each at 0.5 minute per plug is another 12 minutes. A small number, but multiplied across a year of jobs that nobody counted, it is real money.

Checking a draft quote before it goes out

Run a second pass with a different prompt, asking the AI to find fault rather than produce. Paste in the finished quote and use this:

Check this powder coating quote for missing or inconsistent lines. List, in order of dollar impact:
1. Any of the seven cost lines (prep, masking, set-up, spray, oven, powder, consumables) that is zero or missing.
2. Any part whose area does not match its stated dimensions.
3. Any assumption not backed by a shop figure.
4. Any case where rack capacity makes the oven-load count look wrong.
Do not rewrite the quote. Only list problems.

A typical illustrative reply: "Masking is $0 but the part list says 'threaded' for the brackets. Gate panel area of 9.0 sq ft looks high for a 4 ft by 3 ft bar frame unless the bars are 1.5 inch tube; confirm. Oven loads: 12 gate panels at 4 per load is 3 loads; you have counted 2." Each of those is the sort of slip a tired person makes at the end of a shift. The AI is a reasonable second pair of eyes, and it costs nothing to ask.

A quote that was short: how it showed up

A different illustration. A shop quotes 30 aluminium wheel rims from a part list using a flat rate per wheel the AI proposed. The job comes back with powder and spray times roughly as expected, but the actual labour is 40% over the quote. Looking at the timesheet, nearly all the extra time is on prep: the wheels arrived with old clear coat and brake dust baked on, so each needed chemical stripping before blasting. The quote assumed condition A; the wheels were condition C.

The fix was not a better model. It was a line in the intake form: "Condition on arrival: A, B, C or D, with a photo", and a rule in the prompt that a missing condition defaults to C until a person confirms otherwise. After that, any quote with an unknown condition priced at the safer rate, and the customer sent a photo if they wanted the lower one.

Small examples from different kinds of work

A one-off bicycle frame. Area is about 4 sq ft, so powder is trivial: about 0.13 lb at 30.8 sq ft per pound. Cost is dominated by stripping the old paint, masking bearing seats and thread, a full oven load for one item, and a colour change. The quote is almost entirely set-up and prep, so a minimum charge is the sensible floor and per-square-foot pricing would give a ridiculous figure.

A repeat order of 500 identical bolt-on brackets. Here the AI is useful in a different way: build one template quote with a per-part price at three tiers (100, 250, 500), then reuse it. Hanging jigs are a one-off cost that gets amortised, so state it once on the first order.

Architectural aluminium with a spec. A customer wants a film thickness range, a gloss tolerance and a warranty-backed pretreatment. The AI should copy the spec into the quote exactly and flag any line it cannot meet, such as a thickness range tighter than your gun setup achieves. Do not let it paraphrase a spec.

Fence panels sprayed on site visits. Many shops do not, but if yours quotes a collection run, the AI can add a transport line from your mileage rate and the load count. Give it the van capacity in panels.

A customer who wants a price by email in ten minutes. Use a lighter prompt that returns a range, not a figure, and says "indicative, subject to inspection of parts". See the tutorial on quoting custom jobs in a small workshop for how to keep that quick reply from becoming a binding price.

Measuring whether the quotes are any good

After ten jobs, build a simple sheet with these columns: quoted prep hours, actual prep hours, quoted masking, actual masking, quoted powder pounds, actual pounds used, quoted oven loads, actual loads, and price. For each line compute actual divided by quoted. A ratio near 1.0 means the rule is good. A ratio of 1.3 on prep means your minutes per square foot are too low; multiply the rule by 1.3 and run the next ten.

Weigh the hopper before and after a job to get actual powder, since reclaim and spray losses are the usual difference between the formula and reality. If you see a ratio of 1.5 on powder, your transfer efficiency is worse than 60% or your film is thicker than you thought, and checking both is easy with a thickness gauge.

Also track quotes won and lost. If you win nearly every quote, you are probably cheap. The tutorial on checking your rates against past jobs uses the same approach for building work, and it carries over directly.

What to keep human

Three things should stay with a person even when the quote is generated: the final price, the lead-time promise and any spec that carries a warranty. The AI can draft the lines and the wording. Someone who knows this week's oven schedule must say "ten working days" or "next Thursday".

If you quote often and want the follow-up automated too, the same approach works for chasing unanswered quotes; see following up unapproved estimates with AI. And if you would rather map your own quoting steps with someone, that is what my AI implementation consultation covers.

Questions powder coaters ask before trusting an AI quote

Can AI work out surface area from a photo of a part?

Roughly, and only for simple shapes with something of known size in the frame. For quoting, treat a photo estimate as a screening number. Anything above a few hundred dollars, or anything with tubes, mesh or deep recesses, should be measured with a tape or taken from the drawing before the price goes out.

Which inputs should I never let the AI guess?

Never let it guess your hourly rates, oven cycle time, powder price per pound, transfer efficiency or minimum charge. These are your shop's numbers. Put them in the prompt or a saved sheet, and the AI only does arithmetic and wording around them.

How do I price a small batch against a big one?

Split the quote into per-job costs (colour change, booth clean, set-up, hanging jig, minimum oven load) and per-part costs (prep, masking, spray, powder). Small batches carry the per-job costs over fewer parts, so their per-part price is higher. Show both lines so the customer sees why.

Should the quote say the AI wrote it?

There is no need to mention the tool, but a person in your shop should read every figure before it leaves. The quote is your commitment, so check the area, the finish spec and the lead time against what the oven can actually do that week.

How soon will I know if my AI quotes are accurate?

After ten finished jobs. Record quoted hours and powder against actual hours and powder for each one, then see which line is off. Most shops find one or two consistent gaps, usually prep or masking, and fix them with a correction factor in the prompt.

Further reads

Sources: powder manufacturers' published coverage formula (192.3 divided by specific gravity times thickness in mils, multiplied by transfer efficiency) as set out in the trade journal Products Finishing; the shop's own timings supplied in the examples are illustrative.

Want your quoting sheet to match how your shop really runs?

On a 1:1 call we would walk through your last few jobs, find which quote lines run short, and set up a prompt or sheet that uses your own timings.

Book a 1:1 call with me