View the step-by-step solution to:

# Assignment plant Sources Task\Staff A B 3 C D Assigned Cost Matrix a b c d 1 0 0 0 0 0 2 0 0 0 0 0 3 0 0 0 0 0 4 0 0 0 0 0 1 17 15 19 21 2 14 10 16...

I got the minimum cost of 56, but i wasnt sure if that was right. then the second problem product b cannot be assigned to plant 2, what will be the revised assignment. what is the minimum cost. i cant figure out how to not assign product b with plant 2.

Assignment plant Task\Staff 1 2 3 4 Assigned Sources A 0 0 0 0 0 B 0 0 0 0 0 3 C 0 0 0 0 0 D 0 0 0 0 0 Assigned 0 0 0 0 Cost Matrix 1 2 3 4 a 17 14 21 9 b 15 10 22 12 c 19 16 19 17 d 21 15 18 14 Min Cost Objective 0 Z = SUMPRODUCT(C4:G8,C12:G16)

Please increase the deadline to at least 48 hours... View the full answer

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents