As technology has improved over the years, paint lines have become more commonplace throughout job shops. The ability to estimate how much a part costs is now more complicated due to the batch process and automation of paint lines. This entry will show you a sample formula for estimating “time per part”. This is a pretty complicated formula but you can put it into an Excel spreadsheet and try out the numbers.

**Variables**

TTR400 Time to Reach 400f

Cure Time Cure Time

CTA Cure Temp Adjustment

PPS Parts Per Set

LFPS Linear Feet Per Set

CT Cure Temperature

CSO Conveyor Speed Override

**Formula**

(LFPS/PPS)/IF(CSO=0,(IF((TTR400 + CTA*(Cure Time))<11, 5, IF((TTR400 + CTA*(Cure Time)) < 15, 4.5,IF((TTR400 + CTA*(Cure Time)) < 20, 4, IF((TTR400 + CTA*(Cure Time)) < 25, 3.5,IF((TTR400 + CTA*(Cure Time)) < 30, 3, IF((TTR400 + CTA*(Cure Time)) < 35,2.5,IF((TTR400 + CTA*(Cure Time)) < 40, 2,IF((TTR400 + CTA*(Cure Time)) < 45, 1.5, 1))))))))),CSO)