How to Set Up a Linear Programming Problem in Excel?

amenon2 · Apr 21, 2014

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

MarkFL · Apr 21, 2014

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?

How to Set Up a Linear Programming Problem in Excel?

Attachments

Discussion

Undergrad Is infinity a necessary concept?

High School Ant on a stretchy rope puzzle

High School Potato paradox

Undergrad Descartes’ Geometry of Square Roots

High School Three Squares Problem

Mathematica NDSolve with forcing function via "digital waveguide"

MATLAB Unable to produce desired results using state-space model with observer for inverted pendulum

Insights Revisiting the Velocity-Time Function

Insights Remote Operated Gate Control System

Insights AI Enriched Problem Solving

Insights Thinking Outside The Box Versus Knowing What’s In The Box

Insights Why Entangled Photon-Polarization Qubits Violate Bell’s Inequality

Insights Quantum Entanglement is a Kinematic Fact, not a Dynamical Effect

How to Set Up a Linear Programming Problem in Excel?

Attachments

Discussion

Similar threads

Formulate this as a linear programming problem

Solutions of the given linear programming problem

Linear programming constraints not working in solver

Undergrad Mathematical formulation of Linear Programming Problem

Linear Programming Problem using the Simplex Method

Python Solving Linear Programming problems in python PulP

High School Solving a Linear Programming Problem which Requires Integer Solutions

Graduate linear programming, polyhedron and extreme points

Undergrad How Do You Formulate Decision Variables in a Linear Programming Problem?

Is This Solution to the Linear Programming Problem Correct?