Income & Expenses Statement for The Elephant Hotel for the year ended 30th
June 2018
ACTUAL INCOME BUDGETED INCOME
& EXPENSES
& EXPENSES
2017-2018
2017-2018
INCOME
RESTAURANT Sales
$445,000.00
$425,000.00
Sale From Bar
$245,000.00
$250,000.00
TOTAL SALE
$690,000.00
$675,000.00
Expenses
Advertising
$4,953.13
$3,937.50
Bank charges
$810.00
$1,080.00
Casual employee wages
$180,625.00
$187,500.00
Cleaning & cleaning products
$1,215.00
$1,620.00
Credit card commission
$16,192.50
$13,590.00
Electricity/Gas
$37,125.00
$37,000.00
FOOD DELIVERY Vehicle service costs
$3,937.50
$4,050.00
kitchen utensils hire
$1,350.00
$1,250.00
Netflix subscription
$1,350.00
$1,350.00
Permanent full time employees wages
$315,000.00
$315,000.00
property insurance
$1,181.25
$1,575.00
Public liability insurance
$945.00
$1,260.00
Repair & maintenance
$12,531.50
$9,375.00
Superannuation for employees
$47,084.38
$47,737.50
Waste removal
$1,822.50
$2,430.00
Water charges
$9,450.00
$10,600.00
Website hosting expenses
$2,995.31
$3,993.75
Total Expenses
$638,568.06
$643,348.75
Month Net Profit / (Loss)
$51,431.94
$31,651.25
Advertising
Bank charges
Casual employee wages
Cleaning & cleaning products
Credit card commission
Electricity/Gas
FOOD DELIVERY Vehicle service costs
kitchen utensils hire
Netflix subscription
Permanent full time employees wages
property insurance
Public liability insurance
Repair & maintenance
Superannuation for employees
Waste removal
Water charges
Website hosting expenses
$2,953.13
$810.00
$140,625.00
$1,215.00
$10,192.50
$37,125.00
$3,037.50
$1,350.00
$1,012.50
$236,250.00
$1,181.25
$945.00
$2,531.25
$13,471.59
$1,822.50
$9,450.00
$2,995.31
$3,937.50
$1,080.00
$187,500.00
$1,620.00
$13,590.00
$49,500.00
$4,050.00
$1,800.00
$1,350.00
$315,000.00
$1,575.00
$1,260.00
$3,375.00
$17,962.13
$2,430.00
$12,600.00
$3,993.75
Bachelor of Tourism and Hospitality
Management
BTHM
2019-SEM1-THH3113 Cost and Performance Management for Tourism and Hospitality
Assessment Task 3: Individual Assignment
Assessment of the assignment is based on the adequacy and accuracy
of the submitted assignment.
For all written work students must ensure that they submit their own
original work. Any act of plagiarism will be severely penalised.
Students must:
fully reference the source(s) of all material, even if you have reexpressed the ideas, facts or descriptions;
acknowledge all direct quotations; and
Not submit work that has been researched and written by another person.
Your work will be assessed in terms of the following criteria:
1. Effectiveness of communication – i.e. readability, legibility, neatness,
completeness and presentation
2. Demonstrated understanding of the subject matter covered - This will be
evidenced by your ability of submitted answers.
Certain aspects of these questions may require some assumptions to be made.
Therefore, different answers are very acceptable. For ease of marking please
specify these if you think it clarifies your decisions and responses.
Your assignment must be submitted into the Turnitin drop box on LMS.
1
THH3113 COST AND PERFORMANCE MANAGEMENT FOR TOURISM
AND HOSPITALITY (2019 Sem 1)
Student
ID:
First
Name:
Last
Name:
Case study:
The Elephant Hotel was first opened as the Prince Consort Hotel in 1888.
The Hotel was refurbished in 2013 and is comprised of a large public bar with full
facilities, dining room, beer garden, bottle shop - the Valley Wine Shop, located on
the corner of Brunswick & Wickham streets. Of Queensland Australia.
The owners of The Elephant Hotel BOB & BIB have successfully gained their
new trading license for their new hotel in Fortitude Valley Queensland and they have a
lot of competitors to compete with. BOB & BIB are very concerned about their business
that they might succeed only if they cut done on their costs. They want to compare their
budgeted expenses and income statement and see how they have performed in the
basis of cost management when compared to previous year and current year.
They want to be proactive thus forecast and decide for any extra costs that they might incur
in running their new branch. As their current revenue manager for their Old branch you are
approached to evaluate factors affecting value perceptions in food services.
BOB & BIB are sure that you can help them to point out the cost drivers and
evaluate management cost drivers that measure performance of the cost control
The extract of The Elephant Hotel is below which you should use for your analysis.
Income & Expenses Statement for The Elephant Hotel for the year ended
30th June 2018
ACTUAL
BUDGETED
INCOME &
INCOME &
EXPENSES
EXPENSES
2017-2018
2017-2018
INCOME
RESTAURANT Sales
$445,000.00
$425,000.00
Sale From Bar
TOTAL SALE
$245,000.00
$690,000.00
$250,000.00
$675,000.00
$4,953.13
$3,937.50
$810.00
$1,080.00
$180,625.00
$1,215.00
$187,500.00
$1,620.00
Credit card commission
$16,192.50
$13,590.00
Electricity/Gas
FOOD DELIVERY Vehicle service
costs
kitchen utensils hire
$37,125.00
$37,000.00
$3,937.50
$4,050.00
$1,350.00
$1,250.00
Netflix subscription
Permanent full time employees
wages
property insurance
$1,350.00
$1,350.00
$315,000.00
$315,000.00
$1,181.25
$1,575.00
$945.00
$1,260.00
Repair & maintenance
$12,531.50
$9,375.00
Superannuation for employees
$47,084.38
$47,737.50
Waste removal
Water charges
$1,822.50
$9,450.00
$2,430.00
$10,600.00
Website hosting expenses
$2,995.31
$3,993.75
$638,568.06
$643,348.75
$51,431.94
$31,651.25
Expenses
Advertising
Bank charges
Casual employee wages
Cleaning & cleaning products
Public liability insurance
Total Expenses
Month Net Profit / (Loss)
NOTES FOR THE NEW SHOP RUNNING EXPENSES
1. The bank charges depend on the number of transactions that
takes place in the restaurants
2. Property Insurances change according to the area
3. Kitchen utensils are hired as per the catering orders they receive. All cooking is done in
the current shop (management doesn’t want to plan catering in the new branch. If they
are getting an order, they have decided to make it all in the current hotel and deliver)
4. There was an unexpected equipment failure in the hotel during in the
months of December that has increased the repair expenses (this was
mainly because of poor record keeping for the equipment’s maintenance)
5. The management has implemented some strict waste reduction measure
as a result the waste removal charges have decreased
(YOU CAN ALSO DOWNLOAD THIS EXCEL FILE FORM THE LMS)
Analysis and Report (30 marks. Approximately 1250 – 1500 words)
1. Cost Control: (5 Marks)
Identify and evaluate cost control areas and recommend how they can
control them in future by better cost management
2. PERFORMANCE ANALYSIS (VARIANCE): (10 Marks)
Perform a variance analysis on the following report and discuss about
the variances in performance when compared to their budget.
3. Cost and Revenue Analysis: (10 Marks)
Recommend on how Bob and BiB should handle his sales without
compromising on cost in the future (no increasing in cost)
4. Presentation with no errors is awarded (5 marks)
(you can use Microsoft excel to work on your assignment and import it to
Microsoft word when writing your report)
Purchase answer to see full
attachment