Question 11:
Solve the following LP formulation in Excel
Maximize Z=300×1+90×2+400×3+150×4
subject to:
$35,000×1+10,000×2+25,000×3+90,000×4≤$120,000
4×1+2×2+7×3+3×4≤12 acres
×1+×2≤1 facility
×1,×2,×3,×4=0 or 1


Answers

Answer 1

By solving the LP formulation using Solver in Excel, you will obtain the optimal values for the decision variables x1, x2, x3, x4 that maximize the objective function Z.

To solve the given linear programming problem in Excel, you can use the Solver add-in. Here are the steps to set up and solve the LP formulation:

Step 1: Set up the Excel spreadsheet with the following columns:

Column A: Variables (x1, x2, x3, x4)

Column B: Coefficients of the objective function (300, 90, 400, 150)

Column C: Constraint coefficients for the first constraint (35000, 10000, 25000, 90000)

Column D: Constraint coefficients for the second constraint (4, 2, 7, 3)

Column E: Constraint coefficients for the third constraint (1, 1, 0, 0)

Column F: RHS values for the constraints (120000, 12, 1)

Column G: Variable type (0 or 1)

Column H: Variable names (optional)

Cell J2: Objective function (formula: =SUMPRODUCT(B2:B5, G2:G5))

Step 2: Set up the Solver add-in:

Go to the "Data" tab and click on "Solver" in the "Analysis" group.

In the Solver Parameters dialog box, set the following:

Set Objective: Cell J2

To: Max

By Changing Variable Cells: Range G2:G5

Subject to the Constraints: Range C2:F4

Click on the "Add" button to add each constraint.

Click on the "Solve" button to solve the LP problem.

Note: Before running the Solver, make sure you have the Solver add-in enabled. You can enable it by going to "File" -> "Options" -> "Add-Ins" -> "Excel Add-Ins" -> "Solver Add-in" -> "OK".

By solving the LP formulation using Solver in Excel, you will obtain the optimal values for the decision variables x1, x2, x3, x4 that maximize the objective function Z.

Learn more about variable  from

https://brainly.com/question/28248724

#SPJ11


Related Questions

help pls...........................

Answers

Answer:

220%,2.2,√5,2.25

Step-by-step explanation:

220%=2.2

√5=2.23

I need help on rhis pls fastttttttt fastttttttt pls stytyt
y

Answers

Answer:

60 slices

Step-by-step explanation:

Well, to start you must figure the amount of slices, to begin with. This is 9 x 8

this is = to 72.

Then you take 5/6 of 72/1 by multiplying across. to get 60

If the degree in the numerator is smaller than the degree in the denominator and there is no vertical
shift, then there is a vertical horizontal at y = 0.
O True
O False

Answers

The answer is false.

Step-by-step explanation:

what do u think ?

not always true so the answer is false

The cross section of a parabolic reflector has a vertical axis of symmetry with its vertex at (0,0). The focus of the reflector is 6 feet above the vertex. The reflector extends 5.5 feet to either side of the vertex. What is the depth of the reflector? Round your answer to the nearest hundredth.


The depth of the reflector is about _____

feet.

Answers

Answer:

1.26 feets

Step-by-step explanation:

Given the following :

Vertex (0, 0)

Focus of reflector = 6 feets

Extension = 5.5 feets

Equation to obtain conic section of a parabola:

(x - h)² = 4p(y - k)

Vertex (0, 0)

h =0 ; k = 0, p = 6, x = 5.5

(5.5 - 0)² = 4*6(y - 0)

30.25 - 0 = 24(y - 0)

30.25 = 24y

y = 30.25 / 24

y = 1.26

Hence, depth of reflector = 1.26 feets

Q is th midpoint of pr.if pq = x+8 and qr =9x, what is the qr

Answers

Answer:

Step-by-step explanation:

7x5=35     i hope this helps

As Q is the midpoint of pr the value of qr will be 9 units

What is midpoint of line segment?

The midpoint divides the line segment into two equal parts.

Here in the question It is given that q is the midpoint of pr which implies  q will divide pq into two equal parts that is pq (x+8) equals qr (9x). now calculating x value first :

[tex]\begin{aligned}pq&=qr\\x+8&=9x\\8x&=8\\x&=1\end{aligned}[/tex]

Now, qr will be [tex]9x=9\cdot1=9[/tex]

Therefore, As Q is the midpoint of pr the value of qr will be 9 units

Read more about intersection at:

https://brainly.in/question/28160696

#SPJ2

what number would “x” be ?

Answers

Answer:

11

Step-by-step explanation:

To divide these terms we should subtract x from 7

19^7/19^x = 19^-4

19^7-x = 19^-4

7 - x = -4

-x = -4 -7

x = 11

How much string is left when 1 3/4 inches are cut from a piece measuring 3 1/16 inches?

1 5/16 inches
1 10/12 inches
2 2/12 inches
2 11/16 inches

Answers

Answer:

1 5/16

Step-by-step explanation:

subtract 1 3/4 from 3 1/16

y-3 rewrite as a postitive exponent

Answers

Answer:

(see first pic attached)

Step-by-step explanation:

Use the pattern below for questions 6 - 8.

6, 19, 58, 175,

6. What are the next two terms in the sequence?


7. Describe what you are doing to the previous number to get the next number in the sequence.


8. What would the 8th term be in this sequence?

Answers

Answer:

See below

Step-by-step explanation:

The sequence given

6, 19, 58, 175

We see the pattern: triple the previous term plus 1

2) 19 = 6*3 + 13) 58 = 19*3 + 14) 175 = 58*3 + 1

Next two terms

5) 175*3 + 1 = 5266) 526*3 + 1 = 1579

Following two terms

7) 1579*3 + 1 = 47388) 4738*3 + 1 = 14215

A certain rock has a density of 12.5 g/mL. What volume will 4.0g of this rock occupy

Answers

Answer:

0.32 mL

Step-by-step explanation:

d = m/v

v = m/d

v = 4.0 g ÷ 12.5 g/mL

g ÷ g cancels out the unit g

v = 0.32 mL

Apply Axiom 2 to find the unique fold (line) that places p1 = (1,4) on to p2 = (3,1).
Check your answer by plotting the two points in Desmos, plot also the fold line. You could even
print this out and make sure it works. (With only one fold the result is just a folded piece of paper,
not an origami crane or even a hat, but check that the two points are placed on top of each othe

Answers

We are asked to apply Axiom 2, also known as the "unique fold" axiom, to find the line that maps point p1 = (1,4) onto point p2 = (3,1). We will use the formula for the equation of a line to determine the equation of the line that satisfies this condition. We can then verify our answer by plotting the two points on a graphing tool like Desmos.

Axiom 2 states that for any two distinct points p1 = (x1, y1) and p2 = (x2, y2), there exists a unique line that maps p1 onto p2. The equation of a line passing through two points can be found using the point-slope formula:

y - y1 = m(x - x1)

where m is the slope of the line. To find the slope, we use the formula:

m = (y2 - y1) / (x2 - x1)

In this case, p1 = (1,4) and p2 = (3,1), so we can substitute these values into the formulas to find the equation of the line. The slope is:

m = (1 - 4) / (3 - 1) = -3 / 2

Using the point-slope formula with p1, we have:

y - 4 = (-3/2)(x - 1)

Simplifying the equation, we get:

y - 4 = (-3/2)x + 3/2

y = (-3/2)x + 11/2

This is the equation of the unique line that maps p1 onto p2. To verify our answer, we can plot the two points (1,4) and (3,1) on a graphing tool like Desmos and observe that they lie on the same line with the equation

y = (-3/2)x + 11/2.

Learn About Point-Slope Here:

https://brainly.com/question/837699

#SPJ11

Question 12 3 pts If we know that the length of time it takes a college student to find a parking spot in the library parking lot follows a normal distribution with a mean of 2.5 minutes and a standard deviation of 0.75 minute, find the probability that a randomly selected college student will find a parking spot in the library parking lot in less than 3 minutes. 0.3085 0.3551 0.6915 0.7475

Answers

The probability that a randomly selected college student will find a parking spot in the library parking lot in less than 3 minutes is found as  `0.7475`. Hence, the option D is correct.

The length of time it takes a college student to find a parking spot in the library parking lot follows a normal distribution with a mean of 2.5 minutes and a standard deviation of 0.75 minute.

We are supposed to find the probability that a randomly selected college student will find a parking spot in the library parking lot in less than 3 minutes.

So, we need to find `P(x < 3)` where `x` is the time taken to find a parking spot in the library parking lot.

Now, z-score will be

`z = (3 - 2.5)/0.75

= 0.67`

By looking at the z-score table, the probability that corresponds to z = 0.67 is 0.2514.

Therefore,

`P(x < 3) = P(z < 0.67)

= 0.2514 + 0.5

= 0.7514

≈ 0.7475 (approx)`

So, the correct option is `0.7475`. Hence, the answer is option D.

Know more about the standard deviation

https://brainly.com/question/475676

#SPJ11

Anyone knows this?? Please I rly NEED help ASAP!! (ᗒᗣᗕ)

Answers

Answer:

Translations mapping = (x, y) -----> (x+a, y+b)

Reflections across the y-axis = (x, y) -----> (-x, y)

Reflections across the x-axis = (x, y) -----> (x, -y)

Rotation: 90 degree: (x, y)-----> ( -y, x )

Rotation: 180 degree: (x, y)-----> (-x, -y)

Rotation: 270 degree: (x, y)-----> (y, -x)

Please solve RIGHT i will give brainleist

Answers

Answer:

I can solve but I can't see clearly your questions...

someone please answer.​

Answers

Answer:

[tex]x = 21.[/tex]

Step-by-step explanation:

[tex]m \angle \: bce = m \angle \: bcd + m \angle \: dce \\ 6x = 74 + (3x - 11) \\ 6x - 3x = 74 - 11 \\ 3x = 63 \\ \boxed{ x = 21.}[/tex]

♨Rage♨

3- Find the Domain (ONLY) for each of the following functions (60 points - 10 each) a) f(x) = x²-3x − 4 b) f(x) 2 x-3 c) M(x) √x-5 2 10 d) g(x) = e) h(x) a) f(x) = 4, x +9 x-4 drhring 16 miles since a full tank 2x-5 x-2x-15

Answers

The domain of each function is determined by the values of x for which the function is defined. The domain of function a) f(x) = x²-3x-4 is all real numbers. The domain of function b) f(x) = 2x-3 is all real numbers. The domain of function c) M(x) = √(x-5) is x ≥ 5. The domain of function d) g(x) = (x+9)/(x-4) is x ≠ 4. The domain of function e) h(x) = 16/(2x-5) is x ≠ 2.

a) The function f(x) = x²-3x-4 is a polynomials function, and polynomial functions are defined for all real numbers. Therefore, the domain of f(x) is all real numbers.

b) The function f(x) = 2x-3 is a linear function, and linear functions are defined for all real numbers. Hence, the domain of f(x) is all real numbers.

c) The function M(x) = √(x-5) represents a square-root function. Square root functions are defined only for non-negative values inside the square root. In this case, x-5 must be greater than or equal to zero, which implies x ≥ 5. Therefore, the domain of M(x) is x ≥ 5.

d) The function g(x) = (x+9)/(x-4) is a rational function. Rational functions are defined for all real numbers except the values that make the denominator equal to zero. In this case, the denominator is x-4, so the function is undefined when x = 4. Hence, the domain of g(x) is x ≠ 4.

e) The function h(x) = 16/(2x-5) is also a rational function. Similar to the previous explanation, rational functions are defined for all real numbers except the values that make the denominator equal to zero. In this case, the denominator is 2x-5, so the function is undefined when x = 5/2. Therefore, the domain of h(x) is x ≠ 5/2 or x ≠ 2.

Learn More About polynomials Here:

https://brainly.com/question/11536910

#SPJ11

The graph of a roller coaster track goes in a straight line through coordinates (10, 54) and (42.48) with coordinates in feet. A support beam runs parallel 12 feet below the track. What equation describes the support beam?

Answers

Answer:

y = -3/16x + 43 7/8

Step-by-step explanation:

The equation of the line through the points (10, 54) and (42, 48)

y = mx + b

Slope

m = (48 - 54)/(42 - 10) = - 6/32 = -3/16y = -3/16x + b

y-intercept

54 = -3/16*10 + bb = 54 + 15/8 = 55 7/8

So the line is

y = -3/16x + 55 7/8

The support beam has y-intercept 12 feet below

b = 55 7/8 - 12 = 43 7/8

Required equation

y = -3/16x + 43 7/8

MATH QUESTION ON SLOPESSSSSSS
Given: m = 3/2 and b = -1

The slope and y-intercept for a linear equation are given. Which graph matches this information?

Answers

I’m fairly sure it is the last one. But the pictures are hard to see. 3/2 is the slope and -1 is the y intercept. Find the point at (0,-1) , the y intercept. Then go up 3 and over 2 to find the next point

please help with this by showing work
8. Find the equation for the line that passes through the points: (-2,5) and (7,3). Give your answer in point-slope form.

Answers

The equation for the line in slope-intercept form is: y = (-2/9)x + 41/9 This is the required equation for the line that passes through the points: (-2, 5) and (7, 3) in point-slope form.

The equation for the line that passes through the points: (-2,5) and (7,3) in point-slope form can be found as follows:

Solution:

Given points are (-2, 5) and (7, 3).

Let (x1, y1) = (-2, 5)and (x2, y2) = (7, 3)

Formula used: Point-slope form of a line: y - y1 = m(x - x1)

Slope of the line: m = (y2 - y1) / (x2 - x1)

Substitute x1, y1, x2, and y2 in the slope formula: Slope m = (3 - 5) / (7 - (-2)) = -2 / 9

Slope-intercept form of the line: y = mx + b

Substitute slope m, and any one point (x1, y1) in the slope-intercept formula: 5 = (-2/9) * (-2) + b

Simplify and solve for b: 5 = 4/9 + b b = 41/9

The equation for the line in slope-intercept form is: y = (-2/9)x + 41/9

To leran more about slope-intercept, refer:-

https://brainly.com/question/30216543

#SPJ11

find the slope of the line that goes through (3, 7) and (-1, 4)​

Answers

The slope of the line that goes through the points (3, 7) and (-1, 4) is 3/4.

The slope formula is: m = (y2 - y1) / (x2 - x1) where (x1, y1) and (x2, y2) are two points on the line. This will allow us to determine the slope of the line that passes through the points (3, 7) and (-1, 4).

When we enter the provided coordinates into the formula, we get:

m = (4 - 7) / (-1 - 3) = -3 / (-4) = 3/4

The pace at which the y-coordinates vary in relation to the x-coordinates is shown by the slope, which expresses how steep the line is. In this instance, the slope of 3/4 means that the y-coordinate increases by 3 units for every 4 units that the x-coordinate increases. Likewise, the y-coordinate falls by 3 units for every 4 units decrease in the x-coordinate.

For such more questions on slope

https://brainly.com/question/16949303

#SPJ8

Answer:

The slope of the line that goes through (3,7) and (-1,4) is 3/4

Step-by-step explanation:

Apply the formula m = (y₂ - y₁) / (x₂ - x₁) to find the slope.

(x₁, y₁) = (3, 7)

(x₂, y₂) = (-1,4)

= (4 - 7) / ((-1) - 3)

= -3 / -4

Since both of them are negative, they cancel out to 3/4.

Simplify as much as possible (5^3)^-2

Answers

Answer:

1/15625

Step by Step Explanation:

Its the right answer

Help please, hurry please

Answers

The working to the problems shows the factorization method of solving quadratic equations.

What is a quadratic equation?

A polynomial equation of degree 2 is a quadratic equation because it includes terms with variables raised to the power of 2.

We have that;

[tex]x^2 + 10x + 16 = 0\\x^2 + 8x + 2x + 16 = 0[/tex]

x(x + 8) + 2 (x + 8) = 0

(x +2) (x + 8) = 0

x = -2 and -8

2)

[tex]x^2 - 6x + 5 = 0\\x^2 -5x - x + 5 = 0[/tex]

x(x - 5) -1 (x - 5) = 0

(x - 5) (x - 1) = 0

x = 1 or 5

3)

[tex]x^2 - 2x - 8 = 0\\x^2 -4x + 2x - 8 = 0[/tex]

x(x - 4) + 2(x - 4) = 0

(x + 2) (x - 4) = 0

x = -2 or 4

4)

[tex]2x^2 - 8x - 10 = 0\\x^2 - 4x - 5 = 0\\x^2 +x - 5x - 5 = 0[/tex]

x(x + 1) -5(x + 1) = 0

(x + 1) (x - 5) =0

x = -1 or + 5

5)

[tex]4x^2 - 36 = 0\\x^2 - 9 = 0[/tex]

x = ±3

Learn more about quadratic equation:https://brainly.com/question/29269455

#SPJ1

which of the following is a true statement?select one:interval is the name of a particular octave sizeoctave is the name of a particular interval sizethe fifth is a kind of octavea synonym for distance is octave

Answers

The true statement is: "Octave is the name of a particular interval size."

In music theory, an octave refers to the interval between two pitches where the higher pitch has a frequency that is exactly twice that of the lower pitch. It represents a doubling or halving of the frequency. For example, if we start on the note A and move up to the next A, we have traversed an octave.

An interval, on the other hand, refers to the distance between two pitches. It is the numerical representation of the difference in pitch between two notes.

The statement mentioning "interval as the name of a particular octave size" is incorrect because the octave is a specific interval size, not the other way around.

The statement suggesting that "the fifth is a kind of octave" is also incorrect. The fifth is a specific interval that represents the distance of five diatonic scale steps between two pitches.

Lastly, the statement that "a synonym for distance is octave" is not true. While an octave represents a specific interval size, the term "distance" is a more general term that can refer to the measurement between any two pitches, regardless of the specific interval size.

for such more question on interval

https://brainly.com/question/23558817

#SPJ8

The price of an online Maths website subscription is increased by 24% and now is £300.08.

Find the original price
Plz give a step by step equation

Answers

Answer:

205??????

Step-by-step explanation:

sorry if I didn't get it right

Step-by-step explanation:

it may help you to understand

Helppp meeeeeeee im stuck on this l

Answers

Answer:

subtraction property of equality

Step-by-step explanation:

180 = 155 + m< EGH

Subtract 155 from each side using the subtraction property of equality

180-155 = 155-155 + m< EGH

25 = m< EGH

Prove The Following
------------------------------

Answers

Answer: WAP if yu dont understand look up videos of WAP

Step-by-step explanation:

Answer:

Below.

Step-by-step explanation:

m < PCA = m  < CAD ( alternate angles)

m < BAD = m <CAD ( given)

Also m < CAB = m < PCA + m < CPA  ( exterior angle of a triangle theorem).

Also m < CAB = m< CAD + m < BAD (given)

So  m < PCA + m < CPA =  m < CAD + m < BAD

But m < PCA = m  < CAD

so  m < CAD + m < CPA = m < CAD + m BAD

So m < CPA = m < BAD

But m < PCA = m < CAD = m BAD

therefore m < CPA = m < PCA

That makes triangle CAP isosceles

Therefore AP = AC.

I=prt,,5.00=.0125*1212p,,p=5.00/.0125*1212=?? Use the calculator\



whats the answer

Answers

G is the answer okay

2b + 4 = -8 help please

Answers

Answer:

-12 is the answerrrrrr

-12 is the answer mannn

If X= 24, and b = 20
what does x²+b²-123 equal ​

Answers

Answer:

853

Step-by-step explanation: hope this helps

Answer:

853

Step-by-step explanation:

Hope this helps!

24^2 = 976

20^2 = 400

976+400-123= 853

Which expression is equivalent to 5m + m + 2m?

Answers

Answer:

8m

Step-by-step explanation:

Other Questions
What Impact did the Great War have on Russia and the creation of the Soviet Union? Which of the following is NOT a way that alcohol impairs your driving?Decreased visionLack of coordiantionSlows reaction timeO Increased concentration If there Is a new moon on July 8th, what is the date of the following full moon? The atomic mass is...A. Equal to the number of protonsB. equal to the number of protons + neutronsC. Equal to the number of protons-electronsD.Equal to the number of electronsE. none of the above Sound science is based on one time occurrences true or false Choose appropriate pair of verbs to fill in the blanks elles _ franaises mais je _ amrican Which BEST describes the significance of the War of Jenkins' Ear? A. It helped the Spanish conquer the barrier islands,B.It helped Georgia function as a buffer colony for South Carolina from the SpanishC.It helped the Spanish invade the buffer colony and take over CharlestownD.It helped Georgia establish a strong economic foundation, Bob, CPA, has a client with a strong belief that he is correct about an aggressive but creative tax position. Bob thinks otherwise and has documented his position. Bob files the tax return as his client wishes but also includes disclosure on his client's position. There is no substantial authority on this tax position. The client agrees with Bob that the position should be disclosed to the __________ why are thermatic maps useful? Why are Li Na and k Placed in the same group of the periodic table? What is 20% of 60?A. 1.2B. 12C. 40D. 120 24 students in a class.If 18 students made their own lunch,what percent did not? Which is a convention that Egyptian artists used in wall paintings?They depicted body parts in their most recognizable position.They studied the human form in order to depict accurate proportion.They carefully covered the outlines they drew by painting over them 2.02 / 15 of 35Which is not a factor in controlling growth of microorganisms?A. OxygenB. colorC. temperatureD. moisture Elaborate How did President Coolidge help to improve conditions for Native Americansin the 1920s? What makes the planets orbit the sun? Haydn's "Minuet and Trio" from Symphony No. 45 is played by two oboes, two horns, violins, viola, cello, and a double bass. Which of the following instrument families is not included? Determine if the following equation is conditional equation, identity or a contradiction.4(+3)=-7(6+2y)+18 Can someone please help me I will give them 20 points and brianly 1. provide at least 3 properties and 3 methods of the object computer.OBJECT COMPUTER PROPERTIES 1. 2. 3. METHODS 1. 2. 3 2. provide at least 3 properties and 3 methods of the object computer. OBJECT Car PROPERTIES 1. 2. 3. METHODS 1. 2. 3Need help maam/sir thanks in advance 5stars for good answer