This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 2500 253.076166 <= 253.072741539 B/Area 1500 3000 <= 30000 B/Area 2500 795.41839 <= 30000 L A *D*A L B *D*A Cost A Cost B P cr(B) L B = 25 A x A y L A = 15 B x B y Area A Area A Area B Area B P cr P cr f y(A) f y(A) f y(B) f y(B) Area A Area B P cr f y(A) f y(B) **When using excel Solver there where difficulties for solve to calculate. Seems that changing varibles (Area -A & Area - B) can not be quotients in the calculation process. Therefore, all equations where manipulated such that Area - A & Area - B where a product of the coefficients. Second Page of excel shows this with different numbers (i.e smaller #'s) This made solver find the best solution for the each material.**- Best Material to choose from was carbon steel with a total cost of $117.34. With Member - A having a crossectional area of .5 in2 & Member - B had a cross sectional area of 3.143 in2...
View Full Document
- Winter '12