Question: Use the Excel template to solve Exercise 5.4 from chapter 5 on pages 118-119 of the OZCAN textbook. Table EX 5.4 shows the current and

Use the Excel template to solve Exercise 5.4 from chapter 5 on pages 118-119 of the OZCAN textbook.

Table EX 5.4 shows the current and proposed layouts for a group practice. The cost of travel per 1,000 feet is estimated to be $4. Moving departments cost $ 17,500 each.

Use the Excel template to solve Exercise 5.4 from chapter 5 on

a. What are the efficiency savings of the proposed layout? b. What is the cost of the proposed layout? c. In how many years can the cost of the new layout be recovered? 5.5 Determine which placement of departments for a newly designed urgent care center will minimize transportation costs. Assume that it costs $1 to travel a meter. Flow and distance matrices are shown in Table EX 5.5

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!