I have a problem which I can't figure out how to solve. Even with Excel Solver I could't manage to complete this.
Thanks in advance!
A company accepts calls 7 days a week during the period 9 A.M. to 5 P.M. Based on analysis of historical data, the following number of staffers are needed each day in the call center to cover incoming calls:
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
12 17 8 9 10 11 8
The company hires staff to work 5 consecutive days a week. It is not possible to offer part-time jobs. Thus, a staffer can start at any day of the week, and then works for 5 days in a row. The company pays these staffers €100/day to work on weekdays (Monday through Friday) and €150/day to work on the weekends (Saturday and Sunday). A continuous schedule must be created that can be used for the whole year and specifies the number of staffers that start each day (On every Sunday the same number of staffers will start, as on Tuesday, as on Wednesday, etc.). The objective is to minimise the total costs paid. Formulate this problem as an integer/binary/linear programming model.