1) Based on the matrix results Drills and __________ are in the room next to each other as they have the highest number of moves between each other.

2) Based on the matrix results Materials and ______________ are the in the room next to each other as they have the second highest number of moves between each other.

3) The cumulative distance based on the overall movement of material between process for this layout? _______ feet

PLEASE SHOW WORK IN EXCEL EXAMPLE IF POSSIBLE.........Thanks

Roy Creasey Enterprises, a machine shop, is planning to move to a new, larger location. The new building will be 60 feet long by 40 feet wide. Creasey envisions the building as having six distinct production areas, roughly equal in size. He feels strongly about safety and intends to have marked pathways throughout the building to facilitate the movement of people and materials. See the following building schematic. His foreman has completed a month-long study of the number of loads of material that have moved from one process to another in the current building. This information is contained in the flow matrix on the left below. Finally, Creasey also developed a matrix to indicate distances between the work areas shown in the building schematic, shown on the right below