Chapter 7, Problem 8

Please provide step by step directions and explanation

pictures below please follow same format excel

total load-distance for your recommended layout? 8. The following is the current layout of a large storage area with items placed in rooms 1, 2, or 3 depending on their types. Based b. Redesign the layout to minimize load-distance. What is the on the data regarding traffic and distance: Fnd the load-distance for the current layout. a. A Room 1 B Room 2 Room 3 Distances between locations (in feet): Location TO B From 50 30 80 Daily traffic (number of trips) between rooms: Room 2 To 1 3 From 27 5 Room 1 Room 2 Room 3 2 72 29 Alignment Number Styles Clipboard Font H4 fx D E F G A B M3-Q3 (Chapter 7. Problem 8) 1 2 3 4 5 Room 1 0 Room 2 50 Distance Room 1 Room 2 Room 3 Room 3 30 80 0 6 7 8 9 B 29 Campsite Load