# (Solved): The following spreadsheet presents an assignment model structure for allocating three part time empl ...

The following spreadsheet presents an assignment model structure for allocating three part time employees (Ali (A), Belal (B), and Clincy (C)) across three temporary jobs at a publishing house – (1) Formatting, (2) Printing, and (3) Binding. While all three employees are qualified to do the three jobs, they differ with respect to how much time they spend to complete each job. The publishing house has created the following spreadsheet model to assign each employee to a specific job. As input, the model uses the hours taken by each staff member to complete a job as well as the hourly wage rate payable to them. The publishing house would like to assign each employee to one of the three jobs in a manner that minimizes the total costs. PQ6.1.jpg Let Ai = 1 if Ali is assigned to do job i, or zero otherwise, where i = 1, 2, and 3 Bi = 1 if Belal is assigned to do job i, or zero otherwise, where i = 1, 2, and 3 Ci = 1 if Clincy is assigned to do job i, or zero otherwise, where i = 1, 2, and 3 The algebraic form of the constraint associated with the Printing task can be expressed as A2 + B2 + C2 = 0 A2 + B2 + C2 <= 1 A2 + B2 + C2 >= 1 A2 + B2 + C2 = 1

We have an Answer from Expert