I need either an answer using one of the three methods Solver methods (GRG, Evol

Question

I need either an answer using one of the three methods Solver methods (GRG, Evolutionary, Simplex). Please show your excel spreadsheet and a copy of the method used (with values).

General Instructions Put each problem on its own tab in your Excel file. You will turn this in as backup. For your primary submission, turn in a well-formatted Word document that shows your spreadsheet setup, your optimization setup, and your solution (screenshots). For cach question, identify the type of algorithm used to solve the problem, and why that algorithm is the most appropriate for that problem. If using Solver, explain any default settings you change or ensure are correct to your situation. Comment on any observations you make

Explanation / Answer

Solution:-

Given

Compression load = 3000 kN

E =200*109 N/m2

Volume of cylinder = 0.0075 m3

Factor of safety = 2

P = 2 E I/L2

Volume of cylinder = 0.0075

r2 L = 0.0075

r2 = 0.0075/( L)

P = 2 * 200 *109* (r4/4)/L2

2*3 *106 = 2 * 200 * 109 * * (0.0075/(L))2/(4*L2)

L4 =1.47166

L= 1.1 meter

Beam length should be less than 1.1 meter Answer

Radius of cylinder (r) = (0.0075/(*1.1))

                                     = 0.046 meter    Answer

Value of radius and length of cylinder are taken maximum.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.