Question

Problem 4-20 X Y Profit $4 $5 =SUMPRODUCT(B5:C5,$B$4:$C$4) Constraints Labor 1 2 =SUMPRODUCT(B7:C7,$B$4:$C$4) <= 10 Material...

Problem 4-20
X Y
Profit $4 $5 =SUMPRODUCT(B5:C5,$B$4:$C$4)
Constraints
Labor 1 2 =SUMPRODUCT(B7:C7,$B$4:$C$4) <= 10
Material 6 6 =SUMPRODUCT(B8:C8,$B$4:$C$4) <= 36
Storage 8 4 =SUMPRODUCT(B9:C9,$B$4:$C$4) <= 40
LHS Sign RHS

Homework Answers

Answer #1

The (B4:C4) signifies the number of X & Y manufactured/procured

Objective Cell is D5 which is a summation of profits from the X & Y

Constraint at D7 signifies the total labor consumed in having the (B4:C4) quantity of X & Y

Constraint at D8 signifies the total material consumed in having the (B4:C4) quantity of X & Y

Constraint at D9 signifies the total storage consumed in having the (B4:C4) quantity of X & Y

Putting this in solver we get, Optimal solution at X = 2 & Y = 4

The screenshots are attached,


Please Like & Provide your reviews in Comments. :-)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A student will randomly select 5 cards from a deck of 52 cards. Each card is...
A student will randomly select 5 cards from a deck of 52 cards. Each card is uniquely identified by a label which is a combination of a letter (one of the following: A, B, C, D) followed by a number (one of the following: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13). The labels on the cards are A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, B1, B2, B3, B4,...
A student will randomly select 5 cards from a deck of 52 cards. Each card is...
A student will randomly select 5 cards from a deck of 52 cards. Each card is uniquely identified by a label which is a combination of a letter (one of the following: A, B, C, D) followed by a number (one of the following: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13). The labels on the cards are A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, B1, B2, B3, B4,...
LP Graphical Method Problems 1) MAXIMIZATION PROBLEM - 4 PTS Objective Function: Maximize Profit: 5X +...
LP Graphical Method Problems 1) MAXIMIZATION PROBLEM - 4 PTS Objective Function: Maximize Profit: 5X + 3Y Subject to the constraints: 5 X + 2 Y ≤ 40 3 X + 6 Y ≤ 48 X ≤ 7 2 X − Y ≥ 3 X , Y ≥ 0 ******* 2) MINIMIZATION PROBLEM - 4 PTS Objective function: Minimize Cost: 3X + 7Y Subject to the constraints: 9 X + 3 Y ≥ 36 4 X + 5 Y ≥...
a= 1, b =6 , c= 4 T(x,y,z) =(x^2 )y +(y^2 )z Find the directional derivative...
a= 1, b =6 , c= 4 T(x,y,z) =(x^2 )y +(y^2 )z Find the directional derivative of T at the point (a − 1, a, a + 1) along the direction of the vector < a, b, c >.
1 2 3 4 5 X 7 20 6 17 20 Y 7 19 11 9...
1 2 3 4 5 X 7 20 6 17 20 Y 7 19 11 9 3 The following sample observations were randomly selected: 1. Determine the regression equation. (Negative answers should be indicated by a minus sign. Do not round intermediate calculations. Round the final answer to 4 decimal places.) b= a= Y'= ------ + ------ X 2. Determine the value of Y' When X is 20. (Do not round intermediate calculations. Round the final answer to 4 decimal...
1.Solve the following initial value problem a) dy/dx= y2/(x-3), with y(4)=2 b) (sqrt(x)) dy/dx = ey+sqrt(x),...
1.Solve the following initial value problem a) dy/dx= y2/(x-3), with y(4)=2 b) (sqrt(x)) dy/dx = ey+sqrt(x), with y(0)= 0 2. Find an expression for nth term of the sequence a) {-1, 13/24, -20/120, 27/720, ...} b) {4/10, 12/7, 36/4, 108, ...}
find dy/dx a. (x+y)^4 =4y-9x b. y= (x +6)^2x c. y= cos^-1 (3x^2 -5x +1 )
find dy/dx a. (x+y)^4 =4y-9x b. y= (x +6)^2x c. y= cos^-1 (3x^2 -5x +1 )
Find the derivative of each of the following functions: (a) y=x^12 (c) y=7x^5 (e) w=-4u^(1/2) (b)...
Find the derivative of each of the following functions: (a) y=x^12 (c) y=7x^5 (e) w=-4u^(1/2) (b) y =63 (d) w=3u^(-1) (f) w=4u^(1/4) 2. Find the following: (a) d/dx(-x^(-4)) (c) d/dw 5w^4 (e) d/du au^b (b) d/dx 9x^(1/3) (d) d/dx cx^2 (f) d/du-au^(-b)    3. Find f? (1) and f? (2) from the following functions: Find the derivative of each of the following functions: (c) y=x^12 (c) y=7x^5 (e) w=-4u^(1/2) (d) y =63 (d)w=3u^(-1) (f) w=4u^(1/4) 4. (a) y=f(x)=18x (c) f(x)=-5x^(-2)...
hours spent studying x 1 1 2 4 5 5 tet score y 40 42 51...
hours spent studying x 1 1 2 4 5 5 tet score y 40 42 51 48 61 67 find the equation of the regression line for the given data. Then use the regression equation to predict the value of y for each of the given x values, if meaningful. The number of hours 6 students spent for a test and their scores are shown. a.) x = 2hours b.) x= 4.5 hours c.) x = 15 hrs d.) x...
Answer Questions 2 and 3 based on the following LP problem. Let     P1 = number of...
Answer Questions 2 and 3 based on the following LP problem. Let     P1 = number of Product 1 to be produced           P2 = number of Product 2 to be produced           P3 = number of Product 3 to be produced Maximize 100P1 + 120P2 + 90P3         Total profit Subject to         8P1 + 12P2 + 10P3 ≤ 7280       Production budget constraint             4P1 + 3P2 + 2P3 ≤ 1920       Labor hours constraint                                    P1 > 200         Minimum quantity needed...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT