tema 6 job shop - Supply TotalAssignments H11:H13 Machine 1...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Job Shop Co. Machine-Location Problem Cost ($/hour) Location 1 Location 2 Location 3 Location 4 Location 5 Machine 1 13 16 12 14 15 Range Name Cells Machine 2 15 - 13 20 16 Assignment C11:G13 Machine 3 4 7 10 6 7 Cost C4:G6 Demand C16:G16 Supply J11:J13 Total TotalAssigned C14:G14 Assignment Location 1 Location 2 Location 3 Location 4 Location 5 Assignments
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Supply TotalAssignments H11:H13 Machine 1 1 1 = 1 TotalCost J17 Machine 2 1 1 = 1 Machine 3 1 1 = 1 Total Assigned 1 1 1 <= <= <= <= <= Total Cost Demand 1 1 1 1 1 ($/hour) 31 A B C D E F G H I J K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...
View Full Document

Ask a homework question - tutors are online