Suppose a data processing department wishes to assign five programmers to five programming tasks (one programmer to
Question:
Suppose a data processing department wishes to assign five programmers to five programming tasks (one programmer to each task). Management has estimated the total number of days each programmer would take if assigned to the different jobs, and these estimates are summarized in the following table.
a. Suppose that your goal is to minimize the total programmer days required to complete all five jobs. Provide an LP formulation of this problem. Clearly define variables, constraints, and objective.
b. Use Excel Solver to solver your model.
c. Which programmer should be assigned to which task? What would be the total programmer days required?
d. Now, suppose that your goal is instead to minimize the maximum time it takes any programmer to complete their task. How would you change your model? You do not need to solve the updated model.
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley