Ticket Pricing (1 Viewer)

Peter Quill

Member
Local time
Today, 14:35
Joined
Apr 13, 2023
Messages
30
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

Nifty Access Guy
Staff member
Local time
Today, 09:35
Joined
Jul 9, 2003
Messages
16,278
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...
 

Isaac

Lifelong Learner
Local time
Today, 01:35
Joined
Mar 14, 2017
Messages
8,777
no attachment and most people wont' click external links
 

GPGeorge

Grover Park George
Local time
Today, 01:35
Joined
Nov 25, 2004
Messages
1,838
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
Is this a class assignment you need to complete for a grade? Or are there other students for whom you are working on a solution?
 

coba4ken

New member
Local time
Today, 11:35
Joined
Mar 27, 2024
Messages
3
Using a solver to optimize ticket pricing is a smart approach. If you haven't already, consider setting constraints for minimum and maximum ticket prices based on market research. Additionally, incorporating demand elasticity into your model could further refine your pricing strategy to maximize revenue!
 
Last edited:

Isaac

Lifelong Learner
Local time
Today, 01:35
Joined
Mar 14, 2017
Messages
8,777
mistake on my part, I liked both your posts to make up for it 👍
 

Users who are viewing this thread

Top Bottom