Question: please show excel functions and constraints !!! Programmer /Programs Andy Sam Norman Mary Program 1 15 9 16 20.5 Program 2 15 8 20 12

please show excel functions and constraints !!!
please show excel functions and constraints !!!
please show excel functions and constraints !!!
please show excel functions and constraints !!!
Programmer /Programs Andy Sam Norman Mary Program 1 15 9 16 20.5 Program 2 15 8 20 12 Program 3 9.5 20.5 3 12 Program 4 15 6 5 12 Big Inc. assigns programmers to develop programs. Assignment of a programmer to a program incurs a cost, which is given in the table above. Find out which allocation of the programmer to the program will incur the minimum cost. There are certain constraints we need to take into account while we are doing the assignments. Firstly, each program needs at least two programmers working on each program. Secondly, No programmer can work on more than three programs. However, each programmer needs to be assigned to at least one program. Finally, Program 2 requires the expertise of both Sam and Mary. 1 DATA 2 3 4 5 6 7 8 9 10 11 12 MODEL 13 14 15 16 17 18 19 20 21 22 Andy Sam Norman Mary Program 1 Program 2 Program 3 15 15 9.5 9 20.5 16 20.5 DESICION VARIABLE Andy Sam. Norman. Mary 8 20 12 3 12 Program 1 Program 2 Program 3 1 5 5 7 B 1 2 B 4 5 6 7 8 9 0 -1 2 CONSTRAINTS LS 0 OOOOOOO 0 0 0 0 0 OBJECTIVE FUNCTION 0 RELATION RS 0 2 2 2 3 3 32 3 (NAME)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!