MHB How to Set Up a Linear Programming Problem in Excel?

AI Thread Summary
To set up a linear programming problem in Excel, users need to define the objective function and constraints clearly. Providing specific details about the problem can help others offer targeted assistance. Sharing attempted solutions or current progress can facilitate more effective guidance. Excel's Solver tool is commonly used for solving such problems, and understanding its features is crucial. Engaging with the community by sharing challenges can lead to better support and solutions.
amenon2
Messages
1
Reaction score
0
Hello everyone, I am stuck on the problem given below. I am know how to set this problem algebraically but I am having a hard time setting up this problem in excel. This is the problem:
View attachment 2363

I would really appreciate if you guys help me. Thank you! :D
 

Attachments

  • Larry Edison Question.png
    Larry Edison Question.png
    17.5 KB · Views: 101
Last edited:
Mathematics news on Phys.org
Hello and welcome to MHB! :D

Can you show what you have tried so far so our helpers can see where you are stuck and be better able to provide help?
 

Thread 'Trigonometry problem of interest'

Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
View full post »

Similar threads

Can Linear Programming Solve Problems with Division Constraints?
Replies
1
Views
1K
I The Price of Beer - Linear Algebra Problem
Replies
44
Views
5K
B A symmetric problem has an asymmetric solution - why?
Replies
21
Views
2K
MHB Solutions of the given linear programming problem
Replies
3
Views
2K
I Modulo and Modulus in math and computer programming
Replies
5
Views
3K
MHB Can you help me with angular and linear speed applications in precalculus?
Replies
6
Views
2K
Linear Algebra How hard is this Linear Algebra textbook?
Replies
17
Views
7K
MHB Find Linear Correlation Coefficient & P-Value for Internet Users & Award Winners
Replies
1
Views
3K
MHB What is the maximum of the given function in the closed square $D$?
Replies
8
Views
3K
A Are these two optimization problems equivalent?
Replies
1
Views
1K

Hot Threads

Recent Insights

Back
Top