Measurement Price Calculator Excel HELP!

[Nadeem89]

Hello All,

I run a metal fabrication shop and I want to calculate the cost of the product based on the dimensions of the materials used?

For example if a 2 x 2 sq.tube with 600cm length is $30, then what will be price of a 150cm tube? I want to automatically estimate the cost prices based on the dimensions of the material used while the total unit cost of the material will be inserted manually.

I hope i make my point clear. Can you please help me in creating an excel template that can make my life easier.

[BadlySpelledBuoy]

=CostPerUnit*RequiredLength/UnitLength
=30*150/600

See attached

BSB

[Nadeem89]

Thank you so Much (BSB).
The excel file definitely is very helpful. I did not realize the calculation will be so easy.
I have another confusion in putting a formula to calculate the total item qty required and calculating cost of metal sheet.

Like if the unit cost of the metal sheet size 100 x 200 is $80 then what will be the price of 50 x 50 metal sheet and how many pcs of 50 x 50 can I get from the material?
Please check attached excel sheet and kindly help me in putting the formulas that can automatically detect the changes.

[JohnTopley]

The calculation to determine what rectangles can be cut from a larger rectangle is not a simple problem to solve: it is (obviously) easier if the dimensions of the smaller rectangle are factors of the larger one.

In your example, with 50x50 from 100x200 is (relatively) easy to do as 50 is a factor of both 100 and 200 with no wastage. However a pieces of 40X60 or 35X70 are a different proposition as there will be wastage.

You need to provide us with a much larger sample of possible sizes.

[Nadeem89]

Thank you John.
It's okay if is difficult to calculate what quantity of pcs can be cut from a larger piece. No problem i will calculate that from sketchup software with the drawings.

But for the other question can you please insert a formula that can calculate/estimate the item quantity required for tube. Like the example i have given in the attachment previously.

[JohnTopley]

Try

in F2

=CEILING(D2/B2,1)