Posted by Carla on Wednesday, October 17, 2012 at 1:25am.
Ten jobs are to be completed by three workers (Sam, Joy, and Kelly) during the next
week. Each person works a 40hour week and is paid an hourly rate: Sam, Joy, and Kelly
earn $11, $13, and $14 per hour, respectively. Union rules require workers to be treated
fairly; to ensure that most of the work is not assigned to one person while others are too
idle, make sure that no person works more than 8 hours above any other worker. For
example, if Joy works 20 hours, then Sam and Kelly should work within 12 to 28 hours,
and Sam and Kelly should have workhours that are no more than 8 hours apart.
The times for the workers to complete the tasks are shown in the table below. The values
in the cells assume that each task is completed by a single person. However, tasks can be
shared with completion times being determined proportionally (e.g. if Joy and Kelly
share task 1 equally, then Joy works 6 hours and Kelly works 9 hours). If no entry exists
in a particular cell, it means that task cannot be performed by that worker.

Math/Management  Carla, Wednesday, October 17, 2012 at 1:29am
a. Formulate the problem as a linear programming model (that is, define the variables,
and write down the objective function and all constraints mathematically).
b. Create a spreadsheet model for this problem and solve with Excel Solver.
c. What is the optimal solution? What is the optimal value?
Answer This Question
Related Questions
 algebra  Sam earns R1 350 per week doing tiling. How much does sam earn in an ...
 math  Mack’s hourly wage is raised from $12.10 per hour to $13.35 per hour. He ...
 Math  When Alexa works overtime any hours over 40 hours a week she is paid 1.5 ...
 Math  Prepare payroll worksheets (for the week) for three employees. Assume ...
 MATH  Could someone please double check me...
 S.A.T Math  I do not understand This: Employee x is paid $12.50 an hour for the...
 math  Angelo is paid double time for each hour he works over 40 hours in a week...
 math  Angelo is paid double time for each hour he works over 40 hours in a week...
 math  Angelo is paid double time for each hour he works over 40 hours in a week...
 Math  Alice earns 1.5 times her hourly rate for each hour she works after 40 ...
More Related Questions