need help setting this up using Excel. back of the book provides the answer.

*9.4 Roy Creascy 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. Bulldina Schematie (with whrk arane 1-at 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 follow. ing flow matrix. Flow Matrix between Production Processes Finally, Creasey has developed the following matrix to indicate distances between the work areas shown in the building schematic. What is the appropriate layout of the new building? Px Chapter 9 9.2 (a) $23.400 : (b) $20,600; (c) $22,000 : (d) Plan B 9.4 Benders to area 1: Materials to 2; Welders to 3; Drills to 4; Grinder to 5; and Lathes to 6 : Trips Distance =13.000ft