Problem 9.1Michael Plumb’s job shop has four work areas, A, B,

Michael Plumb’s job shop has four work areas, A, B, C, and D. Distances in feet between centers of the work are (available in excel attachment).,Work pieces moved, in 100’s of work piece per week, between pair of work areas are: (available in excel attachment).,It costs Michael $1 to move 1 work piece 1 foot. What is the weekly total material handling cost of the layout?,Please answer in Excel format.