Delko is considering hiring people for four types of jobs. The company would like to hire the number of people listed in the file P05_62.xlsx for each type of job. Delko can hire eight types of people. Each type is qualified to perform two or more types of jobs, as shown in this same file, along with the number of each type who have applied for jobs. Determine how Delko can maximize the number of employees assigned to suitable jobs, assuming that each person can be assigned to at most one job. (Hint: Set this up as a transportation model where the supplies are the applicants.) EXCEL PLEASE

b type ople required 6 45 4 40 20 35 30 20 rson type bs qualitied tor umber available 1,3 30 2,3,5 15 3,4 20 4 2,4 35 1,5,6 20 6 3,6 35 4,5,6 40 5,6 25 b type ople required 6 45 4 40 20 35 30 20 rson type bs qualitied tor umber available 1,3 30 2,3,5 15 3,4 20 4 2,4 35 1,5,6 20 6 3,6 35 4,5,6 40 5,6 25