Hi

I have a math challenge that proved to be to much for me. Anyone up for the challenge?

I need to build an Excel model that handles to split a groups total price to price per group member, given some parameters.

Group price: this is given in the model but can be any price.
Number of Adults in the group: this can be 0-300
Number of Children in the group: this can be 0-300
The price for a single child must be 20% below the price for an adult.

Ok an Example

We have agreed on the price 16650 sek for a group with 10 adults and 20 children. I can trial and error my way to that the price for an adult should be roughly 638 sek and 513 sek for a child. But this only applies for this input. I want to build the model so I can enter any number of adults and children and any total price and get the price per adult and child automatically.