Ask Your Question

Mutombo's profile - activity

2018-10-21 21:33:21 +0200 commented question Linear programmi

This is a problem I am trying to figure out. I am having trouble with it.

2018-10-21 21:29:32 +0200 asked a question Linear programmi

I am having trouble with this question.

Coyote Bill’s Casino, in Kennewick, WA, is open 24 hours a day, seven days a week. Along with all the other attractions and diversion, Coyote Bill’s operates a variety of gaming tables. Dealers at these tables are interchangeable. The casino has the following daily requirements for dealers:

​​Time​​​Minimum # of dealers ​1 am – 5 am​​​ 7 ​5 am – 9 am​​​ 4 ​9 am – 1 pm​​​ 9 ​1 pm – 5 pm​​​12 ​5 pm – 9 pm​​​15 ​9 pm – 1 am​​​17

A dealer may start work at the beginning of any one of the six shifts and, having begun, works eight consecutive hours. Formulate the linear program (denote the decision variables, objective function and the constraints). (Hint: Determine your decision variables thinking about how many dealers are needed). Use Excel to find the employee schedule that minimizes the total number of dealers required, meeting the minimum level of each shift’s requirements.