Question: Consider the following linear optimization problem: maximize profit = 15 A + 10 B + 5 C subject to A + B + C

Consider the following linear optimization problem:

maximize profit = 15 A + 10 B + 5 C

subject to

A + B + C <= 1000

A + B <= 2 C

A and B are non-negative

(hint: the second constraint is same as A + B - 2 C <= 0)

Solve this using Excel Solver, and using the optimal solution, match the following:

-

value of A
-

value of B
-

value of C
-

maximum value of profit
A.

200
B.

15440.49
C.

800
D.

666.67
E.

0
F.

333.33
G.

440.80
H.

520.11
I.

11666.67

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Closing Process At December 31, Hanlon Consulting's financial records show the following selected account information. Debit Service fees earned Credit $128,480 Rent expense $33,280 Salaries expense...

Q:

Consider the following linear programming problem: Maximize Profit = 50X + 70Y Subject to the constraints: -20X + 20Y 600 X 0 Consider the graph: -20 -15 -10 b 5 a d 10 15 20 (Remark: x-axis is...

Q:

please write step by step on how to imput in excel a B.3 Solve the following linear programming problem graphically: Maximize profit = X + 10 Y Subject to: 4X + 3Y S 36 2x + 4y = 40 Y = 3 X, Y Z 0PX...

Q:

Question QUESTION 2 a) Consider the following linear programming model. Maximize profit, Z = 5x + 6X2 + 4X3 Subject to: 3X, +4X2 + 2X3 = 120 X1 + 2X2 + X3 s 50 X1 + 2X2 + 3X3 = 30 X1, X2, X3 20...

Q:

1. B.4 Consider the following linear programming problem: Maximize profit 30% + 10X2 Subject to: 3X1 + X, s 300 X; + X, 200 XS 100 X 250 X - X, 50 X1, X 2 0 a) Solve the problem graphically. b) Is...

Q:

Consider the following linear programming problem: Maximize 40 X1 + 30 X2 + 60X3 Subject to: X1 + X2 + X3 90 12 X1 + 8 X2 + 10 X3 1500 X1 = 20 X3 100 X1, X2, X3 0 How many slack, surplus, and...

Q:

21 of 40 FINISH QUIZ MULTIPLE CHOICE Consider the following linear programming problem: Maximize profit = 30X1+10X2 Subject to: 3X1+X25300 X1+X2=200 X1=100 X2250 X1-X250 X1, X220 What is the optimal...

Q:

2. (50 pts.) Consider the following linear programming problem: Maximize profit =30X1+10X2 Subject to: 3X1+X2X1+X2X1X2X1X2X1,X23002001005000 Solve the problem graphically by finding the optimal...

Q:

2. (50 pts.) Consider the following linear programming problem: Maximize profit =30X1+10X2 Subject to: 3X1+X2X1+X2X1X2X1X2X1,X23002001005000 Solve the problem graphically by finding the optimal...

Q:

Consider the following linear programming problem: Maximize profit ( $ ) Z = 3 0 0 X + 2 5 0 Y subject to: 4 X + 3 Y 2 4 4 X + Y 1 6 Y 6 X , Y 0 Find the optimal solution using graphical method (...

Q:

Consider the following linear programming problem: Maximize profit = 30X1 + 10X2 Subject to: 3X1 + X2 300 X1 + X2 200 X1 100 X2 50 X1 X2 0 X1, X2 0 (a) Solve the problem graphically. (b) Is...

Q:

Consider an investment project with the cash flows given in Table P7.15. Table P7.15 n Net Cash Flow 0................................ -$220,000 l................................ 94,000...

Q:

An amino acid is drawn below. *H3N- H3C- -CH CH CH3 -H Identify the amino acid. Isoleucine Leucine Alanine Glycine Identify the three-letter abbreviation. 2000 Gly Ala lle Leu Identify the one-letter...

Q:

Describe tools and techniques used to analyze data when an act or acts of fraud have occurred. Include the following: Identify the forensic tool specific to the crime.Explain the methodology used to...

Q:

A company has the following transactions during the week. Purchase of $1,000 raw materials inventory Assignment of $500 of raw materials inventory to Job 5 Payroll for 20 hours with $1,000 assigned...