PLEASE SOLVE WITH EXCEL SOLVER

A wealthy executive is being transferred from New York City to Tokyo. Since the Japanese use right hand drive cars (i.e. they drive on the left), the executive decides to give his five cars to his three children, who are remaining in New York. Let Yi j = 1 if car i is given to child j, i = 1; : : : ;5; j = 1;2;3 0 otherwise Write a constraint or set of constraints for each of the following situations:

(a) no child may receive more than three cars

(b) each child must receive at least one car

(c) cars 2 and 4 may not be given to the same child

(d) child 2 may not receive more cars than child 1

(e) the same car cannot be given to more than one child

(f) if car 5 is given to child 1, then car 3 must be given to child 1 also

(g) if car 3 is given to child 1 or if car 4 is given to child 2, then car 1 must be given to child 3.