I am trying to use excel to calculate the maximum profit for movie tickets based on who i sell it to. The price is $5 for seniors and 10$ for everyone else. There is 200 seats available in the movie theater. So if i sell 50 tickets to seniors there is only 150 tickets available for everyone else. I am thinking to use a what if analysis so I put on column 200 down to 0 and on the row 0 to 200.

profit = #seniors*5 + 10*#everyone else

formula 0 1 2 3 4 5 6 7 8 9 10 ....200
200
199
198
197
.
.
.
.
0

I was wondering there is a better way to handle this type of problem.