PLEASE HELP ME SOLVE THIS QUESTION WITH DETAILED STEPS IN EXCEL!!

PLEASE DO NOT COPY EXISTING SOLUTIONS ON CHEGG.

Pegasus Air, a charter airline based out of Prague, has six air hostesses that it wants to allocate to 6 monthly charter flight schedules in order to reduce the no. of nights they will be away from their residences. The following table shows the number of nights each air hostess must be away from home with each schedule: Attendant 1 2 3 4 5 6 L 7 4 9 11 5 10 M 4 5 9 6 8 12 Flight Schedule N O 6 10 5 12 11 7 8 5 6 10 11 9 P 5 7 10 O 8 6 8 10 6 10 9 7 9 Determine the best assignments to reduce the total number of nights the attendants will be away from home