Question: Please answer using excel Get-Warm Hospital is a new small emergency process-oriented facility to be located in a popular ski resort in Ellicottville. Its new
Please answer using excel
Get-Warm Hospital is a new small emergency process-oriented facility to be located in a popular ski resort in Ellicottville. Its new administrator, Mary, decides to organize the hospital using the process-layout method she studied in business school. The layout of the facility is given below. The distance between each adjacent area is 40ft. For example the distance between A and E is 40ft, the distance between A and B is 40ft, and the distance between A and H is 160ft. There are eight departments to be located in these eight areas namely, Entrance, Exam room 1, Exam room 2, X-ray, Lab Test and EKG, Operating room, Recovery room, and Cast-setting room. The flows between the departments are given in the following matrix. Find the best assignment of the departments to the areas that minimizes the total distance travelled. Get-Warm Hospital is a new small emergency process-oriented facility to be located in a popular ski resort in Ellicottville. Its new administrator, Mary, decides to organize the hospital using the process-layout method she studied in business school. The layout of the facility is given below. The distance between each adjacent area is 40ft. For example the distance between A and E is 40ft, the distance between A and B is 40ft, and the distance between A and H is 160ft. There are eight departments to be located in these eight areas namely, Entrance, Exam room 1, Exam room 2, X-ray, Lab Test and EKG, Operating room, Recovery room, and Cast-setting room. The flows between the departments are given in the following matrix. Find the best assignment of the departments to the areas that minimizes the total distance travelled
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
