Can someone please help me.. 6. The MSU Colvard Student union anticipates that i
ID: 418143 • Letter: C
Question
Can someone please help me.. 6. The MSU Colvard Student union anticipates that it will need the following numbers of extra workers over the next six months: o July: 11 o Aug: 3 o Sept: 9 o Oct:7 o Nov: 12 o Dec: 3 Temporary employees can be hired for a period of one, two or three months at the following rates: o One month: S2,000 per month o Two months: $1,750 per month o Three monts:$1,500 per month Formulate a linear program that can be used to minimize the cost of workers for the next six months. You may assume that if a worker is hired for a period of time extending beyond December, the cost should be prorated. For example, if a worker is hired for three months at the beginning of November, then a cost of(2/3)(4500) = $3,000. not $4,500, should be assessed in the objective function.
Explanation / Answer
We use solver to solve these kind of problems in Excel.
Here the goal is to Complete the work at low cost
through
constraint: ensuring sufficient number of employees present according to the month
So, I have to ensure that minimum of 9 workers in Sept and 7 mem in October.
Parallely, we need to calculate the pay for the 6 month period.
1 month workers take $2000 and work for 1 month
2 month worker takes $1750 per month and will be present for 2 months.
So, I cosntructed two tables.
One shows the fresh recruits in that month. The other table shows the total number of workers in that month.
Now, the decision which we can take is the number of fresh recruits every month.
Total number of workers in the month is a result of the decision taken before.
Also, the cost is calculated according to the pay we are giving them for that month.
Formulas used:
Solver snapshot:
Fell free to reply in case of doubts.