I need either an answer using one of the three methods Solve

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

Solution

Solution:-

Given

Compression load = 3000 kN

E =200*10⁹ N/m²

Volume of cylinder = 0.0075 m³

Factor of safety = 2

P = ² E I/L²

Volume of cylinder = 0.0075

r² L = 0.0075

r² = 0.0075/( L)

P = ² * 200 *10⁹* (r⁴/4)/L²

2*3 *10⁶ = ² * 200 * 10⁹ * * (0.0075/(L))²/(4*L²)

L⁴ =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.