Ticket Pricing

[QuillPet]

Hello Everyone, I am attempting to solve a problem using solver that I built to complement a scenario that my students encountered while using a platform called knowledge matters. The long and short of it is that the students were tasked with figuring out the ticket prices for six sections in a stadium to generate $575,000 in profit to pass the simulation. I am trying to figure out the optimal ticket pricing to maximize revenue instead of guessing and checking. The constraints that I have would be seating capacity with changing cells being the prices. The target cell is the total revenue. I have attached the sheet. Any assistance would be greatly appreciated.

Dynamic Ticket Pricing

 

[QuillPet]

Hello Everyone, I am attempting to solve a problem using solver that I built to complement a scenario that my students encountered while using a platform called knowledge matters. The long and short of it is that the students were tasked with figuring out the ticket prices for six sections in a stadium to generate $575,000 in profit to pass the simulation. I am trying to figure out the optimal ticket pricing to maximize revenue instead of guessing and checking. The constraints that I have would be seating capacity with changing cells being the prices. The target cell is the total revenue. I have attached the sheet. Any assistance would be greatly appreciated.

Dynamic Ticket Pricing

It would be great if anybody with a little Solver experience could tell me the constraints based on the shared data sheet. Thank you in advance.

 

[awoohaw]

This seems to be a Google Sheets question and not an Excel Question.