Question

1. Developing a workforce schedule (using Linear Programming to model and solve this problem)

A local bank needs the minimum number of employees needed for each day of the week listed in the following table. If a staff is hired, his/her schedule will be working 5 consecutive days and take two days off. The bank operates seven days a week.

Day of the Week	M	T	W	TH	F	Sa	Su
Number of staff needed	4	5	5	3	5	2	3

So how will you help the bank hire the staffs?

Answer 1

Xi is the number of employee starting to work on day i

The representaion

Min Z = x1+x2+x3+x4+x5+x6+x7

Subject to

x1+x4+x5+x6+x7>=4

x1+x2+X5+x6+x7>=5

x1+x2+x3+x6+x7>=5

x1+x2+x3+x4+x7>=3

x1+x2+x3+x4+x5>=5

x2+x3+x4+x5+x6>=2

x3+x4+x5+X6+x7>=3

Solving this in solver

Please rate me

thanks