Hey everyone, Im new here. I've been trying to figure out how to use Excel DDS features and I'm having trouble with solver. I just dont understand how to make the constraints work.

Take for example if you have four resorts currently running at a net loss. A maximum of $85 per client can be charge in only one of the four resorts, for which resort should she charge the $85 fee per client-day if she is looking to keep her loss to a minimum?

Now I understand to set the target cell to net loss and select max, but the constraints are confusing me.

Any help would be great.
Thanks,
John