Please help with the last question. Please show work and preferably excel. Thank you!!

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. Room 1 Room 4 Room 2 Room 5 Room 3 Room 6 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. 1 3 2 20 40 20 I From Te Materials Welding Drills Lathes Grinders Benders Materials 0 80 50 0 0 55 Welding 25 0 0 55 0 0 Drills 20 0 0 0 45 0 Lathes 0 30 0 0 15 0 Grinders 50 0 120 0 0 0 Benders 5 0 20 0 0 0 ( 1 2 3 4 5 4 5 6 20 40 60 40 20 40 60 40 20 20 40 20 - - 6 Based on the flows shown in the matrix, it is likely that the processes Drills and Grinders are in rooms next to each other as they have the highest number of moves between each other. are in rooms next to each other as they have the second Based on the flows shown in the matrix, it is likely that the processes Materials and Welding highest number of moves between each other. One of the layouts that could be designed is: Room 1 = Benders Room 4 = Drills Room 2 = Materials Room 3 = Welding Room 5 = Grinders Room 6 = Lathes The cumulative distance based on the overall movement of material between processes for this layout = | feet (enter your response as a whole number)