New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Solver Contraints Correct or Incorrect?

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

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
Rookie
 
Posts: 1
Joined: Mar 14, 2013
Reputation: 0
Excel Version: 2010

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 25 guests