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: 96
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 'What Exactly is Dirac’s Delta Function? - Insight'

Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
View full post »

Thread 'Fermat's Last Theorem'

Fermat's Last Theorem has long been one of the most famous mathematical problems, and is now one of the most famous theorems. It simply states that the equation $$ a^n+b^n=c^n $$ has no solutions with positive integers if ##n>2.## It was named after Pierre de Fermat (1607-1665). The problem itself stems from the book Arithmetica by Diophantus of Alexandria. It gained popularity because Fermat noted in his copy "Cubum autem in duos cubos, aut quadratoquadratum in duos quadratoquadratos, et...
View full post »
Thread 'Imaginary Pythagorus'

Thread 'Imaginary Pythagorus'

I posted this in the Lame Math thread, but it's got me thinking. Is there any validity to this? Or is it really just a mathematical trick? Naively, I see that i2 + plus 12 does equal zero2. But does this have a meaning? I know one can treat the imaginary number line as just another axis like the reals, but does that mean this does represent a triangle in the complex plane with a hypotenuse of length zero? Ibix offered a rendering of the diagram using what I assume is matrix* notation...
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