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 | 6 | 6 | =SUMPRODUCT(B8:C8,$B$4:$C$4) | <= | 36 | ||

Storage | 8 | 4 | =SUMPRODUCT(B9:C9,$B$4:$C$4) | <= | 40 | ||

LHS | Sign | RHS | |||||

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.
:-)*

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 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 +
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 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
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), 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 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
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 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

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 3 minutes ago

asked 10 minutes ago

asked 18 minutes ago

asked 23 minutes ago

asked 28 minutes ago

asked 43 minutes ago

asked 46 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago