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-orientedPlease 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!