We use sprayfoam as insulation in many of our products. We buy a pair of sprayfoam chemicals in 55 gallon drums. There’s a base chemical and a hardener. We can get 4,500 board feet of foam from a pair of drums. I originally had the sprayfoam using my Volume UOM class but it doesn’t really work because the set of two 55 gallon drums creates 375 cubic feet of foam (equivalent to 4,500 board feet). Typically, a 55 gallon drum has 7.5324306 cubic feet of liquid.
I am leaning towards creating a new Sprayfoam UOM Class with Sprayfoam Board Feet (SFBF) and a Sprayfoam Drum (SFDR). The Sprayfoam Drum would be the base UOM and there would be 4500 SFBF per SFDR.
How should I account for needing the two chemicals (in two separate drums) to create this 4,500 SFBF? I sell Sprayfoam in SFBF and I want to inventory/issue it in SFBF. We track costs in $/bf. Also, I want to make sure that the system knows that I need to have both drums of chemicals to create the sprayfoam.
Has anyone else dealt with a similar situation?
Thanks,
John McAlonan
Falcon Structures