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

Click For 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: 103
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?
 

Similar threads

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