You’ll probably want to store the products (“6x6x1/2 Diablo Red”, for example) in a different table of their own. In that table, you would have a “Unit Price” currency field where you enter the current unit price for a 12 sqft box of “6x6x1/2 Diablo Red” (you probably also want any other product specific data in that table as well, such as “(SF) per box”).
Then, you’ll want to pull that value into this table you are working in right now via a lookup to that “Unit Price” field, pull in other values like “(SF) per box” via lookups, and then just reference those lookup fields in your formula.
You definitely don’t want to bake things like “Unit Price” into formulas – those values change frequently, so you want to store them in fields that can be easily adjusted, and then just reference those fields in your formulas. And having a table dedicated to holding those values is the best way to handle that.
This way, whenever you need to reference “6x6x1/2 Diablo Red” in a bid proposal, you only need to link to it, and all the product specific values are pulled into your bid via lookups – no need to type them in each time. However, for the sake of preserving historical bids without changing their values whenever you change the “Unit Price” of a particular product, you’ll also want to look into using a Rate Schedule table for the Products.
Hopefully that makes sense the way I explained it!