Please list all decsion variables and constraints for this p

Please list all decsion variables and constraints for this problem to be solved in excel solver

There are two teams of fighters: Team A and team B. Team A has the following players: Rhonda. Cat, and Julianna. Team B has Holly, Miesha, and Amanda. We know the following information. Holly will always beat Cat, Miesha will always beat Julianna, Cat will always beat Amanda, and Rhonda will always beat Miesha. In every other possible match, each player has a 50% chance of winning. In the next event there will be two, equally important, fights (fight i and fight ii), so each team must select two different fighters - one for fight i and one for fight ii. Determine the best strategy to select fighters for each team, and state if team A or team B has an advantage.

Solution

Holly beats Cat

Miesha beats Juliana

Cat beats Amanda

Rhonda beats Miesha

-------------

Team A selection

If Rhonda is selected -

Probability of her winning = P(Holly is selected) * P(Rhonda winning) + P(Miesha is selected) * P(Rhonda winning) + P(Amanda is selected) * P(Rhonda winning)

= 1/3 * 0.5 + 1/3 * 1 + 1/3 * 0.5 = 0.67

If Cat is selected -

Probability of her winning = P(Holly is selected) * P(Cat winning) + P(Miesha is selected) * P(Cat winning) + P(Amanda is selected) * P(Cat winning)

= 1/3 * 0+ 1/3 * 0.5 + 1/3 * 1 = 0.5

If Juliana is selected -

Probability of her winning = P(Holly is selected) * P(Juliana winning) + P(Miesha is selected) * P(Juliana winning) + P(Amanda is selected) * P(Juliana winning)

= 1/3 * 0.5+ 1/3 * 0 + 1/3 * 0.5 = 0.33

Hence Team A will select the 2 players with higher probabiities of winning - Rhonda and Cat

-------------------

If Holly is selected -

Probability of her winning = P(Rhonda is selected) * P(Holly winning) + P(Cat is selected) * P(Holly winning) + P(Juliana is selected) * P(Holly winning)

= 1/3 * 0.5+ 1/3 * 1 + 1/3 * 0.5 = 0.67

If Miesha is selected -

Probability of her winning = P(Rhonda is selected) * P(Miesha winning) + P(Cat is selected) * P(Miesha winning) + P(Juliana is selected) * P(Miesha winning)

= 1/3 * 0+ 1/3 * 0.5 + 1/3 * 1 = 0.5

If Amadna is selected -

Probability of her winning = P(Rhonda is selected) * P(Amadna winning) + P(Cat is selected) * P(Amadna winning) + P(Juliana is selected) * P(Amadna winning)

= 1/3 * 0.5+ 1/3 * 0 + 1/3 * 0.5 = 0.33

Hence Team B will select the 2 players with higher probabiities of winning - Holly and Miesha

----------------

No team has an advantage since the probabilities are equal

Team A	Team B
Rhonda	Holly
Cat	Miesha
Juliana	Amanada