Link BD consists of a single bar 30 mm wide and 12 mm thick. Knowing that each pin has a10 mm diameter, determine the maximum value of the average normal stress in the link BD if θ = 15 degrees.

Link will be apear in 30 seconds.

Well done! you have successfully gained access to Decrypted Link.

https://www.chegg.com/homework-help/questions-and-answers/question-1-consider-following-algebraic-formulation-resource-allocation-problem-three-reso-q67536418

ad

Solution in Excel:

Step 1: First I made the model of the problem in spreadsheet.

where some cells have excel formula like,

Production Quantity left blanked, because we have to find that,

Unit profit is filled, according to the , 'Maximise Profit: = 20x ¹ + 40x ² + 30x ^3'

C4= 20

D4= 40

E4=30

F4 = (C3*C4)+(D3*D4)+(E3*E4)

In Constraint,

Resource 1: 3x1 + 5x2+4x3≤ 400

C8= 3

D8=5

E8=4

F8 = (C3*C8)+(D3*D8)+(E3*E8)

G8=400

Resource 2: x1 +x2 + x3≤ 100

C9=1

D9=1

E9=1

F9 = (C3*C9)+(D3*D9)+(E3*E9)

G9 = 100

Resource 3: x1 + 3x2 + 2x3≤ 200

C10=1

D10=3

E10=2

F10 = (C3*C10)+(D3*D10)+(E3*E10)

G10=200

Step 2: I opened the solver. Data --> Solver

Added the values like in:

Set objective: I select the Total Profit Cell '$F$4'

To: I select 'Max' Because it is the maximization problem.

By changing Variable cells: I select the "Production Quantity" Cell for all 3 Products.

Subject to constraints: I added 3 constraints as given in the question, and the value is Used<= Available of 3 resources

then,

I "select the solving method" that is "Simple LX".

Then i click solved.

Then i get

Its shows that, if we manufacture

Product = 50

Product 2 = 50

Product 3 = 0,

then we achieve the maximum profit in given resources.