Joni Wu manages the GoldRush Casino in New Orleans. She would like to adjust the assortment of gaming machines in the casino to ensure they are operating in the most profitable manner. The following table summarizes the current assortment of gaming machines in the casino. Joni is willing to increase or decrease the number of each type of gaming machine by as much as 10% (rounded to the closet integer). However, due to space limitations the total number of gaming machines must remain the same.

 

a. How much does the casino currently make in profit on average each day?
 b. Create an optimization model in a spreadsheet to solve Joni’s problem.
 c. What is the optimal solution and how much profit should the casino expect to make on average each day under the optimal assortment of gaming machines?

Transcribed Image Text:

Machine Type Units on Floor Avg Daily Profit per Unit $123 $46 $82 $76 $89 $205 $316 $108 $0.05 Reel Slots $0.25 Reel Slots $0.50 Reel Slots $1.00 Reel Slots $5.00 Reel Slots $0.01 Video Slots $0.05 Video Slots $0.01 Video Poker $0.05 Video Slots $0.25 Video Slots $1.00 Video Slots $0.01Multi-Game $0.05Multi-Game $0.25Multi-Game $1.00Multi-Game $5.00Multi-Game $10.00Multi-Game $0.05 Video Keno 16 $137 $133 $115 $117 $70 $90 $266 $114 $776 $47 232 18