Can you solve PART B OnLY!

I have solved part A (optimal solution)and the solution of part A below

This is the solution and I have posted the question.

TransGlobal Airlines (TGA), based in New York City, is a charter airline with seven pilots. In assigning routes, the most senior pilot chooses first, then the next most senior, and so on. TGA discovered, however, that some pilots had very little preference, while others cared a great deal about which route they were assigned. Hence, a senior pilot sometimes selected a route that a more junior pilot would have preferred, even though the senior pilot was ambivalent about his or her choice. As a result of complaints from some of the junior pilots, TGA is considering implementing a new policy. Each pilot, regardless of seniority, would rate in numerical order his or her five most preferred cities as well as standby and vacation preference. (Each period, one pilot is on standby and another pilot is on vacation.) TGA would then create a schedule that maximizes overall pilot satisfaction (giving the lowest total overall preference value). London 1 Route Hawaii 3 Standby 6 2 7 2 NINN Paris 2 1 2 1 Moscow 5 7 6 6 Vacation 7 5 Tokyo 4 6 4 7 3 3 4 4 5 5 1 3 Captain Smith Captain Jones Captain Heinz Captain Chang Captain Wells Captain Blinn Captain Klein 1 4 6 3 3 7 7 2 5 2 1 3 6 2 nuo 5 4 1 4 7 a. Given the rankings in the table below submitted by the pilots for the current scheduling period, what schedule should be assigned? b. The pilots are listed in order of seniority. Explain why Captain Smith and Captain Jones, the two most senior pilots, are particularly upset with this period's schedule. Cost 5 4 1 Optimal solution is Work Job Captain Smith Moscow Captain Jones Standby Captain Heinz Vacation Captain Chang Paris Captain Wells London Captain Blinn Hawaii Captain Klein Tokyo Total 1 1 1 2 15 Lowest total overall preference value = 15 EXCEL FORMULA Set up Solverameters as follows Click Solve After that, values appear automatically in variable yellow cells Optimal assignment of routes to pilots FROM TO Captain Moe Capa Aruande Captain Captain Zari Captain Som Ladie Captain Fahim Lowest total overall preference we = 15