This form does 4 types of analysis...

Level 1-  Input the width of the coil, the Outer Diameter of the coil, and Inner diameter of the coil in inches, and it will output the weight of the coil rounded to the nearest pound.

Level 2- Input the weight of one coil, the width of the coil, the thickness of the material, and the progression to make the part, and it will tell you how many parts per coil you will get rounded to the nearest whole number.

Level 3- Input the width of the coil, the thickness of the material, the progression of the material, the cost per pound of material, and number of parts per unit, and it will tell you the cost per part, and the cost per unit.

All-  Input the width of the coil, the thickness of material, Outer diameter of the coil, Inner diameter of the coil, the progression, cost per pound, and number of parts per unit, and it will tell you the coil weight, Number of parts per coil, cost per part, and cost per unit.

Note: Information only needs to be added in the fields with the BLUE font.

Item

Part Dimensions

Width of Coil in inches  

Outer Diameter of Coil in inches  

Inner Diameter of Coil in inches 

Weight of one Coil (to the nearest lb)

Thickness of Material

Progression/Tube length

Number of Parts per coil (to the nearst whole part)

Weight of one part in lbs.

Cost per pound

# of parts per unit

Cost per part

Cost per unit