PLESE SHOW EXCEL STEP BY STEP SOLUTION

Assume that there are 5 hospital departments: A, B, C, D, and E. Loads, presented in the following table, could be the average number of patients or staff that move between the departments each day; for example, number of pationts or staff move between department A and Eis 20. A B D D E A - 10 5 3 20 B 3 5 o 0 12 D 15 F The hospital floor area looks like this: The hospital floor area looks like this: Assume that pationts can't move diagonally (through walls). Also assume that it costs $1 if someone moves from a department to an adjacent department. 1. Put the departments in the available places (1 point). 2. Calculate the total cost of your layout (1 point). Please show the calculation otherwise you cannot get any score. You can do the calculation on a sheet of paper, and then paste it in this sheet