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 1 + 40x 2 + 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

A palindrome is a number or a text phrase that reads the same backwards as forwards. For example, each of the following five-digit integers is a palindrome: 12321, 55555, 45554 and 11611. Write a C++ program that reads in a five-digit integer and determines whether it is a palindrome .

Question: A palindrome is a number or a text phrase that reads the same backwards as forwards. For example, each of the following five-digit integers is a palindrome: 12321, 55555, 45554 and 11611. Write a C++ program that reads in a five-digit integer and determines whether it is a palindrome . Answer: Step 1 PROGRAMING CODE:   #include <stdio.h> int main() {   int n, a, b, c, d, e;   int digit = 0;   printf( "Enter one 5 digit number: \n" );   scanf( "%d", &n );   a = n / 10000;   b = n / 1000 % 10;   c = n / 100 % 10;   d = n / 10 % 10;   e = n % 10;   if ( a == e && b == d ) {     printf( "Palindrome!\n" );   }   if ( a != e || b != d ) {     printf( "Not a palindrome.. :(\n" );   }   return 0; } PROGRAM SCREENSHOT: Step 2

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