Question: using excel to solve the problem Pro Inc. assigns programmers to develop programs. Assigning programmers to a program incurs a cost which is given in

using excel to solve the problem

Pro Inc. assigns programmers to develop programs. Assigning programmers to a program incurs a cost which is given in the table above. Find out which assignment of the programmer to program will incur the minimum cost. There are certain situations we need to take into account while we are doing the assignments. Firstly, each program needs at least three programmers working on each program. Secondly, Mary and Mark can work on up to three projects individually. Thirdly, John has mentioned Whanting, john has mentioned and 5. Fourthly, Mark wants ty work on at least three programs, Finally, program programbires the expertise of r ry

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!

I really need help with what to enter in Excel. I keep getting the following: OBJECTIVE FUNCTION MIN (COST) $ 148.50 DECISION VARIABLES Program 1 Program 2 Program 3 Program 4 Program 5 Program 6 Roy...

Problem 3 : CPM/PERT Using CPM/PERT find the minimum number of days to finish the project. For each activity find out the earliest start and finish time as well as latest start and finish time....

Problem 4: Assignment Problem Programmer /Program11 Program 1 Program 2 Program 3 Program 4 Program 5 Program 6 Roy 15 15 19.5 15 15 15 Amy 9 8 20.5 6 28 8 John 16 20 13 5 21 20 Jack 5 5.5 19 16 5.5...

Please show work in excel VUORI Programmer /Programil Program 1 Program 2 Program 3 Program 4 Program 5 Program 6 Roy 15 15 19.5 15 15 15 Amy 9 8 20.5 6 28 8 John 16 20 13 5 21 20 Jack 5.5 19 16 5.5...

Paragraph Problem 4: Assignment Problem Programmer Program11 Programi Program 2 Program 3 Program 4 Programs Program 6 Roy 15 15 19.5 15 15 15 Amy 9 8 20.5 6 28 8 John 16 20 13 5 21 20 Jack 5.5 19 16...

Programmer /Program11 Program 1 Program 2 Program 3 Program 4 Program 5 Program 6 Roy 15 15 19.5 15 15 15 Amy 9 8 20.5 6 28 8 John 16 20 13 5 21 20 Jack 5.5 19 16 5.5 9 19 Mary 12 12 12 12 12 12 Mark...

Programmer /Program11 Program 1 Program 2 Program 3 Program 4 Program 5 Program 6 Roy 15 15 19.5 15 15 15 Amy 9 8 20.5 6 28 8 John 16 20 13 5 21 20 Jack 5.5 19 16 5.5 9 19 Mary 12 12 12 14 22 12 Mark...

please Solve this Question Below. by Linear programing method. using similar excel template example attached with the problem below. Big Inc. assigns programmers to develop programs. A programmer's...

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...

Programmer Programs Indy Sam Norman Mary Program 15 9 16 20.5 Program 2 15 8 20 12 Program Program 4 9.5 1.6 20.5 6 3 5 12 12 Big Inc. assigns programmers to develop programs. Assignment of a...

Consider a circular DHT with node and key identifiers in the range [0,63]. Suppose there are eight peers with identifiers 0, 8, 16, 24, 32,40,48, and 56. a. Suppose each peer can have one shortcut...

Gibson Appliance Co. is a very stable billion-dollar company with a sales growth of about 7 percent per year in good or bad economic conditions. Because of this stability (a coefficient of...

Raffa works out 461.7 1.8. This is what he writes. a What should Raffa have done, instead of stopping the division and writing remainder 9? b Work out the correct answer. 461.7x10 4617 = 1.8x10 18...

The annual demand for an item is 1,700 units. The order cost is $7. Unit cost is $8 and the unit holding cost per year is 18% of the item's value. The order quantity is 125 units. What are the total...