Math/Management
posted by Carla .
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.

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? 
¹ÚÉúÔ°Â·227ºÅ2ºÅÂ¥4Â¥£¬300Æ½Ã×£¬2Ôª/©O/Ìì£¬ÎïÒµ6Ôª£¬Ö»ÓÐ»õÌÝ£¬Ã»ÓÐµçÌÝ£¬±È½ÏÊµÓÃ£¡¸ô¶Ï3´ó¼ä£¬5Ð¡¼ä£¬²»ÊÇÖÐ½é£¬
<title>Jimmy Choo Gilda Nude Patent Leather Sandals Shoes  $139.00 : Jimmy Choo Outlet, menjimmy
Respond to this Question
Similar Questions

S.A.T Math
I do not understand This: Employee x is paid $12.50 an hour for the first 36 hours he works in a week, and is paid double that rate for every hour over that. Employee Y is paid $15.00 an hour for the first 40 hours she works in a week, … 
MATH
Could someone please double check me?  A Developer works 40 hours per week at $30 per hour. He or she earns : 40 hours x $30.00 per hour = $1200.00  per week. The four developers earn : 40 
math
Angelo is paid double time for each hour he works over 40 hours in a week. Last week he worked 46 hours and earned $520. What is his normal hourly rate? 
math
Angelo is paid double time for each hour he works over 40 hours in a week. Last week he worked 42 hours and earned $660. What is his normal hourly rate? 
math
Mack’s hourly wage is raised from $12.10 per hour to $13.35 per hour. He works 40 hours per week. How much more does he earn per week at this new rate? 
algebra
Sam earns R1 350 per week doing tiling. How much does sam earn in an hour if he works 45 hours a week? 
math
Angelo is paid double time for each hour he works over 40 hours in a week. Last week he worked 42 hours and earned $484. What is his normal hourly rate? 
Math
Prepare payroll worksheets (for the week) for three employees. Assume that they worked the following hours at the following rates:  Sam  6 hours per week at $30/hour  Lisa  on salary with $700/week  Ben  20 hours per week at … 
Math
Alice earns 1.5 times her hourly rate for each hour she works after 40 hours in a week. She worked 50 hours this week and earned $660. What is her normal hourly rate? 
Math
When Alexa works overtime any hours over 40 hours a week she is paid 1.5 times her regular hourly rate in the week she worked 52 hours if her regular hourly rate is 6.80 what did she earn that week