Facility Layout Assignment 1 You have been hired as consultants for the Clean Ha

Question

Facility Layout Assignment 1 You have been hired as consultants for the Clean Hands Soap Company of Springdale, Arkansas. They are a new company and need your help in determining the layout of their new office facility. They have purchased an existing office building with dimensions of 37.5 ft (north-south) by 100 ft (east-west). The building has a parking lot to the south that can accommodate the needs of the company, and there is a public road to the west. The building sits on a lot that has undeveloped areas to the north and east of the building. The office facility will consist of 14 departments. Management of Clean Hands Soap includes one person who has an MBA and knows a little bit about facility layout. He has provided you with the following table that includes activity relationships. Description Area (ft 2 3 4 5 6 7 8 9 10 11 12 13 1 President 2 Vice President 3 Plant Manager 200 200 200 500 250 250 300 400 200 4 Sales Manager Engineers Personnel Supervisors 6 8 Sales Persons 9 10 11 Meeting Room 12 Utility Room 13 14 Secretaries Receptionist Cafeteria Restrooms 150 250 300 Your task is to apply systematic layout planning to this problem using the following scoring scheme: A 8, E = 4, l = 2,0 = 1, U 0, and X =-16. Part 1 Develop a Microsoft Excel workbook that can be used to compute the efficiency of any proposed layout for the new facility. Upload your workbook to Blackboard by 9:30 am on Monday, October 2

Explanation / Answer

The calculation in excel sheet can be done as shown in the table below ----

President Vice President Plant Manager Sales Manager Engineers Personnel Supervisors Sales Persons Secretaries Receptionalist Meeting Room Utility room Cafeteria Restroom Name of Department Adjacent room for efficiency 8 President Vice President 4 1 Vice President Personnel 4 2 4 Plant Manager Sales Manager 2 2 2 4 Sales Manager Sales Persons 1 8 0 2 0 Engineers Meeting Room 2 4 0 1 1 1 Personnel Receptionist 1 4 1 8 2 4 8 Supervisors Secretaries 8 0 2 4 1 2 8 1 Sales Persons 4 0 1 0 2 1 1 1 1 Secretaries 0 1 0 0 2 0 0 2 2 2 Receptionalist -16 0 0 0 0 0 0 0 1 1 -16 Meeting Room 0 0 0 0 1 0 1 0 2 2 4 2 Utility room Restroom 0 -16 4 0 1 -16 -16 -16 1 -16 4 1 1 Cafeteria Restroom

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.