$2.$ Show all work for a$-$b with charts and formulas using excel

Problem $2$

A job shop has four work centers: A$,$ B$,$ C$,$ and D that are currently located in an L$-$shaped facility as in locations $1,2,3,$ and $4$ as shown:

$\backslash$table$[[A$ in $1,B$ in $2,C$ in $3],[D$ in $4,,]]$

The distance in meters between each pair of locations are as follows:

$\backslash$table$[[,1,2,3,4],[1,$longrightarrow,$70,160,240],[2,$longrightarrow,longrightarrow,$70,85],[3,$longrightarrow,longrightarrow,longrightarrow,$40],[4,$longrightarrow,longrightarrow,longrightarrow,$-]]$

The loads moved between each pair of work centers per week are as follows:

$\backslash$table$[[,A,$B$,$C$,$D$],[A,,15,30,60],[$B$,$longrightarrow,longrightarrow,$15,10],[$C$,$longrightarrow,longrightarrow,$-,20],[$D$,$longrightarrow,$-,-,$longrightarrow