Using the Solver Function in Excel to calculate the following: The main challenge is to allocate no more than 140 hours available for play among tables with different pot sizes. Tables with low pot sizes do not generate as much money as those with high pot sizes, however the low pot size tables have a greater frequency of play and the hourly expenses are lower because they do not require as much service. The low pot size tables also have a higher house intake (the percentage that the casino takes from the players) compared to the high pot tables. There are also restrictions on how many hours can be allocated to each table. Donald has set a maximum restriction on the number of tables for each pot size for maintenance and security reasons. He has also set a minimum restriction on the number of tables in order to satisfy customer demand. In addition, he has set minimum and maximum restrictions on the number of hours that should be allocated to each table for similar reasons. Given the information provided below, help Donald find the number of hours to allocate to each table for each pot size and the number of tables to allocate for each pot size so he can maximize his profit.
Using the Solver Function in Excel to calculate the following:
The main challenge is to allocate no more than 140 hours available for play among tables with different pot sizes.
Tables with low pot sizes do not generate as much money as those with
high pot sizes, however the low pot size tables have a greater frequency of play and the hourly expenses are lower because they do not require as much service.
The low pot size tables also have a higher house intake (the percentage that the casino takes
from the players) compared to the high pot tables. There are also restrictions on how many
hours can be allocated to each table. Donald has set a maximum restriction on the number of
tables for each pot size for maintenance and security reasons. He has also set a minimum restriction on the number of tables in order to satisfy customer demand. In addition, he has set minimum and maximum restrictions on the number of hours that should be allocated to each table for similar reasons. Given the information provided below, help Donald find the number of hours to allocate to each table for each pot size and the number of tables to allocate for each pot size so he can maximize his profit.
| Table Blind | Average Pot | House Intake | Pots Per Hour | Hourly Expense | Min Hours | Max Hrs. | Min Tables | Max Tables |
| 2 | 100 | 0.0475 | 70 | 50 | 6 | 9 | 5 | 8 |
| 5 | 150 | 0.0450 | 50 | 60 | 5 | 8 | 4 | 5 |
| 10 | 250 | 0.0400 | 40 | 70 | 5 | 7 | 3 | 5 |
| 20 | 400 | 0.0375 | 30 | 80 | 3 | 5 | 3 | 5 |
| 100 | 1500 | 0.0350 | 20 | 100 | 2 | 4 | 2 | 4 |
| 1000 | 10000 | 0.0300 | 10 | 200 | 1 | 2 | 1 | 2 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 6 images
