Define and solve a problem by using Solver -

Surname 1
Student Name
Professor’s Name
Course Name
Date
Problem 3
a) Using Excel, define the range of D and other variables such as W, Lb, Lc and write down
the formula for T in terms of the defined variables ("Ms Excel").
The plot of T(N) against D(m) is given below
0 0.5 1 1.5 2 2.5 3 3.5
0
5000
10000
15000
20000
25000
30000
35000
40000
45000
T(N) vs D(m)
D(m)
T(N)

Surname 2
b) To minimize the value, use the Excel Solver tool and set the various parameters
appropriately and set the “To” field to Min (Stewart 88).
The figure below shows the Excel solver interface to minimize the function T(D)
The minimum value of D is 2.12132 m as shown in the spreadsheet attached with a
corresponding minimum tension of 1333.33 N ("Ms Excel").
c) To obtain value of D at T=1.1*T_min
Using excel solver: