EXCEL EXAMPLEPLEASE
A group of people is to be assembledinto a team for a project. Their supervisors have provided thefollowing information about them. (10 points)
Name | Training Time Needed | Project Time Available |
Andrews | 8 hours | 24 hours |
Bailey | 10 hours | 40 hours |
Chu | 5 hours | 20 hours |
Darnell | 12 hours | 30 hours |
Elliott | 9 hours | 24 hours |
Fenton | 14 hours | 48 hours |
The task is to select themembers of the team to minimizetraining time needed. The constrains are asfollows:
i. The project will require at least 112hours.
ii. Andrews and Chu don't get along and should not bothbe assigned.
iii. For diversity, at least 4 people should be on the team.
iv. If Bailey is chosen, Elliott should be chosen also.
Using Excel, solve the above integerprogramming problem.
