Optimization problem with POISSON formula

@Konesmeijer

Welcome on the forum.

You get better help if you add an excel file, without confidential information.

Please also add the desired result.

The demand for seat 1 is with a poission distrubution with average of 32.

Explain this in other words, since I don't understand it.

In your file, I don't see manualy added the desired (expected) result.

I get no good translation on the word poison.

But the profit is maximum is you can sell all chairs of seat (since the profit on that chair 1 is higher than chair 2).

And also you don't answer the question, what you expect to be the maximum profit.

If you know the rules how this is calculated, members of the forum can help you finding the right formula.

If this is more of a math question, I might start with something like http://en.wikipedia.org/wiki/Poisson_distribution to understand the properties of the Poisson distribution.

In Excel, there is the =POISSON.DIST() function https://support.office.com/en-us/art...3-7772695d9636 Once you understand how to use the Poisson distribution for this kind of problem, then the worksheet function should make implementation relatively easy.

I'm not sure if I can be of much more help. I'm not enough of a statistician to know what should go into "x" and what should go into "mean".

Seems to me like there's something missing, like the tradeofff between the total number of seats and the number of business seats, which occupy more space.

If the airline chose to, it could alwys fill all open business seats with coach passengers, no?