# New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

## Solver Contraints Correct or Incorrect?

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

### Solver Contraints Correct or Incorrect?

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.