Question

BORNEO TEC. is a smart card technology company. Currently it has three project leaders that are very experienced in developing micropayment cards using the technology of MiFARE 3.0. There are 4 micropayment companies in Malaysia wanted to adopt the technology, these clients namely Client 1, Client 2, Client 3 and Client 4.

All projects are very critical to be completed in timely basis, therefore, the Program leader would assign the Project Leader strategically using the assignment method. The estimated project completion time’s requirement, in days, is as follows.

Project Leader	Client 1	Client 2	Client 3	Client 4
ABU	19	14	18	16
BALA	18	17	17	16
CHAN	13	18	16	18

Find the assignment of each project leaders to clients that will minimize the total days to complete all the projects.

Answer 1

Create Excel model as follows:

Enter Solver Parameters as follows:

Click Solve to generate the solution:

Click OK

----------------------

Result:

Project leader ABU should be assigned to clients 2 and 4

Project leader CHAN should be assigned to projects 1 and 3

Total days to complete all the projects = 59