Powder is bought by the pound, and the amount a job burns tracks its surface area. Multiply the square feet to coat by a pounds-per-square-foot usage rate — padded for overspray — and you know how much powder to shoot.
A railing of 120 square feet at 0.03 lb per square foot needs about 3.6 pounds of powder.
The example
Three parts, each with a surface area in square feet and a usage rate that already includes overspray.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Part | Area sqft | Lb/sqft | Powder lb |
| 2 | Railing | 120 | 0.03 | 3.6 |
| 3 | Frame | 250 | 0.03 | 7.5 |
| 4 | Wheels | 40 | 0.05 | 2.0 |
The formula
Area times the usage rate is the whole calculation:
How it works
Two inputs:
B2is the total surface area to coat, in square feet — all faces of the part.C2is the usage rate in pounds per square foot, chosen to include your gun's overspray and reclaim losses.- The product is the powder to shoot; a tighter booth with reclaim uses a lower rate.
- Film thickness (mils) drives the rate — a heavier coat raises the pounds per square foot.
Keep a usage rate per powder type and film build. Metallics and heavy textures lay on thicker and burn more powder per square foot than a thin smooth coat.
Try it: interactive demo
Enter the surface area and the usage rate in pounds per square foot.
Variations
Powder cost
Multiply the pounds by your powder cost per pound.
Add a reclaim credit
A booth with reclaim recovers overspray — lower the effective rate.
Pitfalls & errors
Coat the whole part, not just the visible face. Powder wraps edges and backs, so use the total surface area or you will run short on complex parts.
The usage rate is shop-specific — it depends on your gun, film build, and whether you reclaim overspray. Weigh powder against area on a few jobs to dial in your own rate.
Practice workbook
Frequently asked questions
What usage rate should I use?
Does reclaim change the number?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class