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 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 thatminimizes the total costs.

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 employee Ali can be expressed as

A₁+ A₂+ A₃? 1

A₁+ A₂+ A₃? 1

A₁+ A₂+ A₃=0

A₁+ A₂+ A₃= 1

Chrome File Edit View History Bookmarks People Tab Window Help GOT A 17% [4 )) Mon 9:15 PM Q E ... PDF 5elementov_uchebnik_A1.pdf - X woul dell Jbell is Jawlly awill X | Netflix X Bb Take Test: Participation Quiz 6 X VitalSource Bookshelf: Essentic X Course Hero X blackboard.adu.ac.ae/webapps/assessment/take/launch.jsp?course_assessment_id=_19601_1&course_id=_52494_1&content_id=_953305_1&step=null ES M Syllabus Description Course Materials Instructions General Lecture-Saturday Timed Test This test has a time limit of 1 hour. This test will save and submit automatically when the time expires. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain. Multiple Attempts This test allows 2 attempts. This is attempt number 1. Quick Links force Completion Once started, this test must be completed in one sitting. Do not leave the test before clicking Save and Submit. Announcements This test does not allow backtracking. Changes to the answer after submission are prohibited. Grades Course Tools Access Remaining Time: 58 minutes, 48 seconds. Course Email Question Completion Status Important Links Academic Integrity A Moving to the next question prevents changes to this answer. Question 1 of 20 > Library My Surveys Question 1 0.5 points Save Answer Bb Help 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. A B D E F G H Hours Required for Each Job JO O V Q UI A W N Formating (1) Printing (2) Binding (3) Wage/Hour Ali (A) 5 $ 12.00 Belal ( Clincy (C) N W 2 $ 10.00 $ 14.00 Assignments Total Formating (1) Printing (2) Binding (3) Assignments Supply 11 Ali (A) 0 0 12 Belal (B) 13 Clincy (C) O - 0 14 Total Assigned 15 Total Cost Demand 16 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 employee Ali can be expressed as A1 + A2 + A3 51 O A1 + A2 + A3 21 6 A1 + A2 + A3 = 0 O A1 + A2 + A3 = 1 19 DOCK