Please show how to do all work preferably with excel. I have been having a hard time trying to figure this problem out. Thank you

Homework: Chapter 9 Homework Save Score: 0 of 4 pts 14 of 19 (13 complete) HW Score: 59.38%, 19 of 32 pts Problem 9.5 Question Help o Munson Manufacturing, in Gainesville, Florida, wants to arrange its four work centers so as to minimize interdepartmental parts handling costs. The fiows and existing facility layout are shown in the figures below. Figure 1. Parts Moved Between Work Centers A B D A 450 550 60 B 375 200 0 0 725 D 0 0 co Figure 2. Existing Layout A B 30 - 30 C D 30 a) For the existing layout, the cumulative "load distance" or "movement cost" - 90900 feet (enter your response as a whole number). Based on the flows shown in the matrix, one should expect that the centers A and B will be next to each other as they have the highest number of moves between each other. Based on the flows shown in the matrix, one should expect that centers and D will be next to each other as they have the second highest number of moves between each other b) The aim is to improve the layout so that the total "movement cost" can be reduced Functional locations for A and D have been fixed in the improved layout, the work center that should be located between them is: morillus DW Work centers of this layout oli conter your The CWC based on VR 2010 Wholenium