Chapter 9 Layout Strategies  Operations Management 12Th Edition Jay Heizer

• Task 1:  Chapter 9:  9.9  (Show all work use Excel)
•  
• Six processes are to be held out in six areas along a long corridor at Rita
• Gibson Accounting Services in Daytona Beach. The distance between adjacent
• work centers is 40 feet. The number of trips between centers is given in the
• following table
•  
•  

		Trips Between Processes
				TO
FROM	A	B	C	D	E	F
A		18	25	73	12	54
B			96	23	31	45
C				41	22	20
D					19	57
E						48
F

•  
•  
•  
•  
• Assign the processes to the work areas in a way that minimizes the total flow using a method that places processes with highest flow adjacent to each other.
•  
• What assignment minimizes the total traffic flow?
•  
•  
•  
•  
• Task 2:  Linear Programming  (Show all work use Excel)
•  

A farmer has 10 acres to plant wheat and barley. He must plant at least 7 acres. However, he has only $1200 to spend; each acre of wheat costs $200 to plant, and each acre of barley costs $100. Moreover, the farmer must get the planting done in 12 hours and it takes an hour to plant an acre of wheat and 2 hours to plant an acre of barley. If the profit is $500 per acre of wheat and $300 per acre of barley how many acres of each should be planted to maximize profits?  

Construct the Linear Programming model  

Solve for the optimal answer using the Excel Solver