Solve using Excel ( please show each step and show all operation used in excel ) -Thank you

7-7. Marillion Hospital is building a satellite clinic in the Cold Harbor area of Richmond. The design committee has col- lected data on patient movement from similar facilities in hopes of making the new facility more efficient and customer-friendly. 1 From 1 Intake 2 Exam room 3 Radiology 4 Laboratory 5 Orthopedics 6 Waiting room Patient Movements To 2 3 4 5 50 10 25 10 30 40 20 40 20 60 10 10 10 30 20 10 60 50 20 50 6 100 20 40 40 30 40 Initial Layout 5 a. Calculate the nonadjacent loads for the initial layout. b. Which pairwise exchange of departments would most improve the layout