Linear programmi

asked 2018-10-21 14:01:56 -0500

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.

edit retag flag offensive close merge delete

Comments

Is this homework ? Could you please tell us how using Excel is related to Sage ?

tmonteil gravatar imagetmonteil ( 2018-10-21 14:30:35 -0500 )edit

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

Mutombo gravatar imageMutombo ( 2018-10-21 14:33:21 -0500 )edit