Encrypting your link and protect the link from viruses, malware, thief, etc! Made your link safe to visit.

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.

A B C D E F G H 1 Product 1 Product 2 Product 3 0 0 Production Quantity Unit Profits Total Profit 0 30 0 20 40 Used 2 3 4 5 6

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".

Solver Parameters X Set objective: SF54 To: Max Омір O Value of: 0 By Changing Variable Cells: $C$3:$E$3 Subject to the Const

Then i click solved.

Then i get

1 Product 1 Production Quantity Unit Profits Product 2 50 20 Product 3 50 40 Total Profit ol 30 3000 2 3 4 5 6 7 8 9 10 11 Us

Its shows that, if we manufacture

Product = 50

Product 2 = 50

Product 3 = 0,

then we achieve the maximum profit in given resources.

ST

Search This Blog

Labels

Report Abuse

Question: A 250-V, 4-pole, wave-wound d.c. series motor has 782 conductors on itsarmature. It has armature and series field resistance of 0.75 ohm. The motor takesa current of 40 A. Estimate its speed and gross torque developed if it has a flux per pole of 25 mWb Answer: Step 1 Mechanical Engineering homework question answer, step 1, image 1 Mechanical Engineering homework question answer, step 1, image 2 Step 2 Mechanical Engineering homework question answer, step 2, image 1 Step 3 Mechanical Engineering homework question answer, step 3, image 1

Question: A 250-V, 4-pole, wave-wound d.c. series motor has 782 conductors on itsarmature. It has armature and series field resistance of 0.75 ohm. The motor takesa current of 40 A. Estimate its speed and gross torque developed if it has a flux per pole of 25 mWb Answer: Step 1 Step 2 Step 3

QUESTION 6 (a) The bar shown in Figure Q2(a) is subjected to tensile load of 150 Kn. If the stress in the middle portions is limited to 160 N/mm², determine the diameter of the middle portion. Find also the length of the middle portion if the total elongation of the bar is to be 0.25 mm. E E = 2.0 + 105N/mm². (12 marks) 150 KN 10 cm DIA 10 cm DIA 150 KN 45 cm Figure Q6(a) (b) A brass bar, having cross-section area of 900 mm², is subjected to axial forces as shown in Figure Q2(b), in which AB = 0.6 m, BC = 0.8 m, and CD = 1.0 m. Find the total elongation of the bar. E = 1.0 + 105N/mm2 . (8 marks) Page 4 of 5 B D 40 KN 70 KN 20 KN 10 KN Figure Q6(b) (TOTAL = 20 MARKS)

  Question: Show transcribed image text Answer:

Contributors