Data Analysis and Decision Modelling Oz Assignments

Introduction:

In this assignment the main objective is to maximize the revenue of the casino recently owned by Holiday Entertainment Corporation (HEC) by choosing a specific strategy. Hence, a total of 3 strategies are evaluated by the method of optimization by using Linear Programming in excel solver and then the best business strategy is chosen. The three models that are evaluated are base model, alternative 1 and alternative 2 model. In all the models the optimum number of pokies, gamers, show guests and high rollers that will generate the maximum income are calculated with some constraints as specified below.

Base model:

In this model the base revenue, side effects, expenses, minimum square feet needed, minimum and maximum of each guest is given and the Linear Programming model is formed in excel as given below.

	Pokies(P)	Gamers(G)	Show guests(S)	High Rollers(H)
Base revenue	200	300	100	5000
Food and drink revenue	25	100	125	0
Side effects	0	more (H/10)2 less (P/25)5	less (P/25)*2	less (P/25)5 more (G/25)10
Expenses	-1	-40	-10	-500
Square feet needed	15	30	10	100


Total revenue	225	400	225	5000
Expenses	-1	-40	-10	-500
Income	224	360	215	4500

Objective Function	224P + 360G + 215S + 4500H + H/5 - P/5 - 2P/25 - P/5 + 2G/5
MAXIMIZE	5588P/25 + 1802G/5 + 215S + 22501H/5


Constraints
	P15 + G30 + S10 + H100 <= (50000- 5000 -5000)
	P + G + S + H <= 1850
Additional constraints
	600 <= P <= 800
	400 <= G <= 800
	300 <= S <= 800
	20 <= H <= 60

The optimum number of guests satisfying all the constraints are

Pokies = 600, Guests = 655, Show guests = 535 and High rollers = 60

And the maximized revenue is $755211.

Alternative 1 model:

In this model the conditions of base model is considered along with the condition that the buffet dining area can be reduced from 5000 square feet to 1500 square feet and the maximum number of gamers and high rollers can be removed such that the revenue generated is not less than the same in base model. The LP which is formulated in excel solver is given below.

	Pokies(P)	Gamers(G)	Show guests(S)	High Rollers(H)
Base revenue	200	300	100	5000
Food and drink revenue	25	100	125	0
Side effects	0	more (H/10)2 less (P/25)5	less (P/25)*2	less (P/25)5 more (G/25)10
Expenses	-1	-40	-10	-500
Square feet needed	15	30	10	100


Total revenue	225	400	225	5000
Expenses	-1	-40	-10	-500
Income	224	360	215	4500

Objective Function
MINIMIZE	G+H


Constraints
	P15 + G30 + S10 + H100 <= (50000- 1500 -5000)
	P + G + S + H <= 1850
	5588P/25 + 1802G/5 + 215S + 22501H/5 >= 755211
Additional constraints
	600 <= P <= 800
	400 <= G <= 800
	300 <= S <= 800
	20 <= H <= 60

Now, solving the model, the total income generated in this model is 755315.60 and the optimal number of guests are Pokies = 800, Gamers = 644, Show guests = 346 and High rollers = 60.

In this model the utilized square feet by the guests is 40780 square feet. Now, as per the condition the minimum number of gamers and high rollers to meet the minimum income is 704.

Alternative 2 model:

In this model the mixed number of guests required (by considering at least two type of guests in the model) to generate the maximum income and both buffet dining area and show dining area can be compromised for more space. Also, the minimum income from this model should be at least $1500000 with the minimum and maximum of each type of guests can be modified. The LP of this problem as formed in excel is given below. All the other constraints in the base model is kept in this model also.

Now, the mixed type of guests is considered as a binary variable i.e. in the solution if a particular type of guest is 0, then in the optimized revenue that type of guest is not considered. From the solution it is evident that the Gamers and High rollers is 1, that means only 127 gamers and 461 high rollers will maximize the revenue satisfying all the constraints.

The maximized revenue of this model is $2144082 and the total area that is utilized is 49910 by a total of 588 guests (127 gamers and 461 high rollers).

Conclusion:

Now, comparing the three models above namely base model, alternative 1 model and the alternative 2 model it is seen that the income is maximum in the alternative 2 model and hence the best strategy for maximizing the income from the casino is to employ the alternative 2 model by Holiday Entertainment Corporation Law.