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: 108
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 'Area of Overlapping Squares'

Here is a little puzzle from the book 100 Geometric Games by Pierre Berloquin. The side of a small square is one meter long and the side of a larger square one and a half meters long. One vertex of the large square is at the center of the small square. The side of the large square cuts two sides of the small square into one- third parts and two-thirds parts. What is the area where the squares overlap?
View full post »

Similar threads

Can Linear Programming Solve Problems with Division Constraints?
  • · Replies 1 ·
Replies
1
Views
1K
Undergrad The Price of Beer - Linear Algebra Problem
  • · Replies 44 ·
2
Replies
44
Views
5K
High School 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
Undergrad 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
Graduate Are these two optimization problems equivalent?
  • · Replies 1 ·
Replies
1
Views
2K