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 40-hour 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 work-hours 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?

- Help me choose my dress!! -
**Help me choose my dress!!**, Saturday, April 6, 2013 at 7:12am
Hey ladies<br><br>

I have done a bit of shopping around and internet hunting and found I really rea

- Am I the only one who doesn't want a White Dress? -
**Am I the only one who doesn&amp;amp;amp;am**, Saturday, April 13, 2013 at 8:54pm
As above.<br><br>

We're most likely getting married outside, and around late morning. Even though it's a wedding...to me, a big white gown doesn't fit with the surroundings/situation. <br><br>

There are another reason why I don't really want a big white gown either. I don't wear dresses very often but when I do I always buy quality. Wedding dresses seem to be too expensive for the quality they a

## 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 - 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...
- S.A.T Math - I do not understand This: Employee x is paid $12.50 an hour for the...
- Math - Prepare payroll worksheets (for the week) for three employees. Assume ...
- Algebra (I think) - Bruce earns 1.5 times his normal hourly rate for each hour ...
- math - HELP PLEASE!!!! The question is: Carmella works 37.5 h per week for ...
- MATH - Could someone please double check me...

More Related Questions