Solver Contraints Correct or Incorrect?

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
Forum Rules Please read the forum rules before posting!

Put CODE tags around your macro/vba code in a post. Easy way to do this: select the macro/vba in your post and click the CODE button above where you input the text.

Solver Contraints Correct or Incorrect?

Postby roadrunnerside8 » Thu Mar 14, 2013 7:50 pm

Any help is appreciated. Please take a look at the solver contraints I've entered.
The steps that Im having trouble with are below:

13: Load the Solver add-in if it is not already loaded. In cell C34 of the Budget worksheet, use Solver to find the highest balance possible by changing the number of attendees and the ticket price per person. Using the Limitations section of the spreadsheet model, add the following constraints:

Number of attendees
Ticket price per person (this will require two constraints based on the minimum and maximum ticket prices)

Keep the Solver dialog box open.

14: Add the following constraints to the Solver Parameters:

Valet parking expense (less than or equal to the product of the number of parking stalls and the valet price per vehicle)
Use the number of attendees as the integer constraint

Solve the problem, but keep the original values in the Budget worksheet. Create an Answer report.

These are the Contraints that I've come up with but are not correct.

$B$26<=240*19.95
$B$4<=500
$B$4= Integer
$B$9<=100
$B$9>=50
  • 0

You do not have the required permissions to view the files attached to this post.
roadrunnerside8
 
Posts: 1
Joined: Mar 14, 2013
Reputation: 0
Excel Version: 2010

Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 6 guests