Maximizing Revenue for Holiday Entertainment Corporation's Casino

INDIVIDUAL TASK COVER SHEET
Student
Please sign, date and attach cover sheet to front of written assessment task OR
Submit as a separate document for non-written assessment task.
A cover sheet is to be completed for each assessment task.
SUBJECT CODE LB5230
STUDENT FAMILY NAME Student Given Name JCU Student Number
Kalra Chirag 1 3 3 0 7 3 9 6
ASSESSMENT TITLE Managing Strategic Resources and Operations
DUE DATE 27-04-2018
LECTURER NAME Dr. Max Boudan
TUTOR NAME Dwight K.Lemke
Student Declaration
1. This assignment is my original work and no part has been copied/ reproduced from any other person’s work or from
any other source, except where acknowledgement has been made (see Learning, Teaching and Assessment Policy
5.1).
2. This work has not been submitted for any other course/subject (see Learning, Teaching and Assessment Policy 5.9).
3. This assignment has not been written for me by anyone or by any organisation.
4. I hold a copy of this assignment and can produce a copy if requested.
5. This work may be used for the purposes of moderation and identifying plagiarism.
6. I give permission for a copy of this marked assignment to be retained by the College for benchmarking and course
review and accreditation purposes.
Learning, Teaching and Assessment Policy 5.1. A student who submits work containing plagiarised material for assessment
will be subject to the provisions of the Student Academic Misconduct Requirements.
Note definition of plagiarism and self-plagiarism in Learning, Teaching and Assessment Policy:
Plagiarism: reproduction without acknowledgement of another person’s words, work or expressed thoughts from any source.
The definition of words, works and thoughts includes such representations as diagrams, drawings, sketches, pictures, objects,
text, lecture hand-outs, artistic works and other such expressions of ideas, but hereafter the term ‘work’ is used to embrace all
of these. Plagiarism comprises not only direct copying of aspects of another person’s work but also the reproduction, even if
slightly rewritten or adapted, of someone else’s ideas. In both cases, someone else’s work is presented as the student’s own.
Under the Australian Copyright Act 1968 a copyright owner can take legal action in the courts against a party who has infringed
their copyright.
Self-Plagiarism: the use of one’s own previously assessed material being resubmitted without acknowledgement or citing of
the original.
Student Signature
Chirag Kalra Submission date 27 / 04 / 2018
ASSESSMENT TASK No _1A______________

Table of Contents
Introduction:...............................................................................................................................................3
Base model:................................................................................................................................................3
Alternative 1 model:...................................................................................................................................4
Alternative 2 model:...................................................................................................................................6
Conclusion:................................................................................................................................................7

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 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