d2jsp
Log InRegister
d2jsp Forums > Off-Topic > General Chat > Homework Help > Linear Programming Question > Using Solver
Add Reply New Topic New Poll
Member
Posts: 4,437
Joined: Apr 21 2007
Gold: 53,616.79
Sep 30 2013 05:14pm
I'm stumped, but could probably use some help if anyones familiar with Linear Programming in Excel. I'm trying to set up the problem. How many variables and how many constraints will be in the problem? Paying nicely.

Heres the problem...

http://tinyurl.com/n6vx7ot
Member
Posts: 21,893
Joined: Mar 27 2009
Gold: 12,408.00
Sep 30 2013 06:30pm
You need......

15 variables (1 for each plant type in each parcel)
5 constraints for acreage in each parcel
5 constraints for amount of irrigation needed in each parcel, derived from how much of what you plant there
3 constraints on maximum allowable crops you can make (based on sales limits)
3 constraints on how much irrigation each plant type requires per acre
1 variable for profit
16 variables 16 constraints, GL with that lol

depending on which is more profitable per irrigation requirement, allot accordingly; if the best is maxed use second best ofc
then check to see if profit > 6k

This post was edited by Dontrunaway on Sep 30 2013 06:30pm
Banned
Posts: 4,377
Joined: Dec 25 2012
Gold: 13,953.01
Warn: 10%
Sep 30 2013 06:33pm
if you still need help, lmk, i love this shit
Go Back To Homework Help Topic List
Add Reply New Topic New Poll