The relocation chart needs to be filled in with the information provided.

Lo A A Wrap Text ilil !!! Paste Merge & Center $ % 918 Conditiona Formatting K19 fx Formative Exercise Problem Using the guidance on black diagramming and the data collected on distance and loods (both provided on separate tabs) complete the Relocation Assessment table below and write a brief summary of your findings Current Locations As the operations manager, you've been asked by a shift leader if you would allow her team to relocate the medical supplies essentially, wapping the locations of Med Sup 1 and Med Sup 2 in locations A and C. Her team believes the change would be more efficent and reduce how long the spending retrieving items needed on a daily basis Resource Location MSI A MS2 B MS3 C Resource Poll MSI MS2 MSI MS3 MS2 - MS3 Wood 27 5 72 Lood 2 0 29 Composite lood 29 5 101 Location Dance Pale bhn Polr EXD A-B 50 1450 A C 30 B.C 80 8080 Total Load Distance 9680 150 Before spending the time, etfort, and costs suodated with swapping MS1 and M2, you need to determine if the change would, in fact, improve operational effidency Relocation Assessment Resource Resource Location Polr MS1 MS2 MS3 Lood Composite stood Lood Location Distance Pair btwn Pair LxD A.C 30 o B.C 80 0 A-B 50 0 Total Load Distance 0 HINT: erge & Center Conditional Format Cell Formatting as Table Styles Format 019 fx Distances between existing locations (A, B, cannot change. Distances and Loads DISTANCE (fixed) FACILITY SKETCH A 3 FROM/10 A B 50 30 80 50 A LOADS (observed MSI 30' B FROM/TO MSI MS2 MS3 MS2 27 MS3 5 72 2 0 80 29 Distance between inglocations Archange Cherved as terceros cabe changes, but resouronnected to wylotion Men Website