top of page
Electricity Repair Work

Assignment Model

The assignment model assigns the workers to the machines in such a way as to keep assignment cost minimum. The model is solving the problem of assigning 4 workers to 5 machines to keep wages per month minimum.

  • The table has the workers and machines to be assigned with the respective wages to be paid to the worker.

  • This problem has the complexity of 

    1. Having 4 workers & 5 machines​

    2. 2nd & 3rd workers can't be assigned to machines 3 & 1 respectively

  • This special kind of transportation problem is solved using the "Solver" function of Excel. 

  • A dummy row is added to satisfy the requirement of the assignment model & infinite cost is considered for the assignments that can't be done

Assignment Model

prob.png
Step1.png
Sol.png
ans.png

Kaustubh Prabhakar Sonawane

  • alt.text.label.LinkedIn

©2022 by Kaustubh Prabhakar Sonawane. Proudly created with Wix.com

bottom of page