How to Set Up a Linear Programming Problem in Excel?

Click For Summary
SUMMARY

This discussion focuses on setting up a linear programming problem in Microsoft Excel. The user is familiar with the algebraic formulation but struggles with the implementation in Excel. Key tools mentioned include Excel's Solver add-in, which is essential for solving linear programming problems. The conversation emphasizes the importance of sharing attempted solutions to facilitate better assistance from the community.

PREREQUISITES
  • Understanding of linear programming concepts
  • Familiarity with Microsoft Excel, specifically the Solver add-in
  • Basic algebraic formulation skills
  • Knowledge of Excel functions and data organization
NEXT STEPS
  • Learn how to use Excel's Solver add-in for optimization problems
  • Research linear programming problem formulation techniques
  • Explore Excel functions relevant to data analysis and organization
  • Practice setting up sample linear programming problems in Excel
USEFUL FOR

This discussion is beneficial for students, data analysts, and professionals who need to implement linear programming solutions using Excel. It is particularly useful for those who have a theoretical understanding but require practical guidance on execution.

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: 109
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

  • · Replies 21 ·
Replies
21
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
Replies
6
Views
2K
  • · Replies 17 ·
Replies
17
Views
8K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 16 ·
Replies
16
Views
3K
  • · Replies 5 ·
Replies
5
Views
3K
Replies
20
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K