The worksheet shown was designed to calculate the cost of material that must be purchased to produce a given number of parts. The user will enter the specific gravity of the material, the diameter of the cylindrical part in units of inches, the cost of the raw material in dollars per pound$-$mass, and the number of parts to be manufactured. All user input is shown in red. The worksheet will calculate the radius of the cylindrical part in units of centimeters and the density of the fluid in grams per cubic centimeter. All conversions are shown in orange.

The worksheet will determine the volume and mass of a single part for a given height. Finally, the worksheet will determine the total mass of material needed to produce the desired number of parts in units of pounds$-$mass, and the total material cost.

The total material cost appears twice. In cells E$13$ to E$20,$ a formula is written to determine the cost. In cells B$26$ to B$33,$ the cells simply reference the corresponding cell in the table above. For example, in cell B$26$ the appears.

In the bottom table, the total cost for N parts is determined by the formula: Total Cost $=$ Total Material Cost $+($Energy Cost $+$ Labor Cost$)\backslash$times Number of Parts

The following sample worksheet is shown for comparison.