Ticket Pricing (1 Viewer)

[Peter Quill]

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

 

[Uncle Gizmo]

I note that you have yet to receive a reply. I am replying to your post so that it is bumped up the list of posts in the hope that it will get another look...