PLEASE ANSWER BOTH QUESTION A and B!

you do not have to show a spread sheet. please just specifically answer question A and B

hges? 511 The administrator of the Vacationers Hospital (VH) recognized the amount of traffic in the corridors. This prompted her to think about possible problems with the current lay- out. The core work of the patient care is performed in an area 300 by 150 feet, as shown in Table EX 5.11.1. Table EX 5.11.1 Entrance/Initial Processing Exam Room 2 Operating Room Walting Room X-Ray Recovery Room Exam Room Lab/EKG Cast Setting Room 300 feet 150 feet All rooms (departments) measure 100 feet (length) by 50 feet (width). Walking distance from one department to another is completed by rectangular working patterns. Assuming that a trip originates from the center of a department and terminates at the center of an ad- jacent department, a person would walk 150 feet (25 feet from the center of the originating department to the hallway, 100 feet on the hallway to an adjacent department, and 25 feet from the hallway to the center of the adjacent department). The results of a six-month-long work sampling study analyzing the movement of VH patients and staff between the depart- ments, averaged per month, are presented in a from-to chart, as shown in Table EX 5.11.2. IN 11 250 Table EX5.11.2 From-To Chart: Monthly Traffic between Departments (Number of People in Motion). Department 1 2 3 4 5 6 1 Entrance/Initial Processing 2 Walting Room 1,900 3 Exam Room 1 1,750 4 Exam Room 2 1,600 300 900 5 X-Ray 500 750 1,005 6 Lab/EKG 800 650 880 870 400 7 Operating Room 375 0 225 300 325 650 Recovery Room 0 0 0 0 0 0 9 Cast.Setting Room 0 0 0 0 985 525 - 675 1,125 0 A consultant informed the administrator that every 1,000 extra feet walked (by either patients or staff) cost $5.50 a month in terms of lost productivity (assuming flows and costs are symmetrical among departments). The objective is to minimize unnecessary walking by changing the location of each department on the basis of traffic data. To move a department costs $20,000 per room, except for lab/EKG, operating room, and X-ray, which cost $75,000 each a. Determine whether it would be worthwhile to change the layout of the hospital. b. How many years would it take to recover the cost of layout changes? (Hint: Total transportation costs of this problem can be calculated by using the Excel template.)