how to solve this by excel

1. PROCESS LAYOUT Mohawk Valley Furniture Warehouse has purchased a retail outlet with six departments, as shown below. The anticipated number of customers that move between the departments each week is given in the load summary chart. a. Calculate the nonadjacent loads for the layout shown below. b. Revise Mohawk's layout such that nonadjacent loads are minimized. The bloc proc men are : duct the DEPARTMENT A B D E F A B C D E F 70 50 100 70 80 40 30 60 100 SOLUTION Composite movements ranked from highest to lowest are as follows: EF 130 BC 70 100 BF 60 CED 80 AF 50 AB 70 A E 40 SOL