The U of A is in the process of forming a committee to handle students grievances. The administration wants the committee to include at least one female, one male, one student, one administrator, and one faculty member. Ten individuals (identifies, for simplicity, by the letters a to j) have been nominated. the mix of these individuals in the different categories is given as follows

Category Individuals

Females: a,b,c,d,e

Males: f,g,h,i,j

Students: a,b,c,j

Administrators: e,f

Faculty: d,g,h,i

The university wants to form the smallest committee with representation from each of the five categories. Formulate this problem as an IP and solve in Excel, please include complete steps and shots the of the excel screen.

Solve the following IP: