Homework Help: Math/Management

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 
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. 
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. 
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

Maths - A company employs 4 times as many unskilled workers as it does skilled ...
Geometric formulas - Contagious diseases can spread very quickly. Supposed five ...
math - Joes electric made 19 customer calls last week and 24 calls this week, ...
Math - The chart shows the number of cars sold per week at a car dealership ...
math - HELP PLEASE!!!! The question is: Carmella works 37.5 h per week for ...
Word Problem - Check Answer (geometric Seq) - 1) Suppose five people are ill ...
Math - If a person jobs at a rate of 5 1/2 mi/h for 3 1/2 h in a week, how many ...
11th Grade - I have a math problem on conics and I am not sure what to do? ...
Pre-Calc - Workers are designing a TV receiving dish in the shape of a ...
question - least three reasons why workers might be more satisfied with their ...

For Further Reading

First Name:
School Subject:
Answer: