I suggest the Excel spreadsheet in Microsoft Office, or the
OpenOffice.org Spreadsheet which is the free equivalent.
Every cell in a spreadsheet is an amazing calculator. A tricky
learning learning curve, but not too hard to master, and your
spreadsheet will instantly re-calculate hundreds of variables by
changing one of them.
You can make it calculate the volume of each component, then make it
calculate the value of each component according to the material and
it’s current price.
For example, click a cell, type… =123.5…hit enter, and the
cell will display the answer of 1x2x3.5
Or type… = and then click another cell that has an answer in it,
hit enter, and your new cell will equal what the other cell has. In
this manner you can make the new cell calculate the answer in one
cell x the answer in another cell, and add sales tax too.
Google, ‘spreadsheet formula’. Really good to know.