Overview
This assignment is based upon the information given below relating to The Adler Hotel, St Moritz which is in the Swiss Alps. The Glacier Hotel Company Ltd operates 3 hotels across the Alps, although they are a UK based company. They are predominantly leisure hotels but as well as having bars, restaurants, gyms, they also have up to date meeting rooms in the hotels equipped with professional audio-visual equipment.
You are required to study and analyse this information and then produce a 3,000-word report [excluding tables] addressing all the tasks listed below. If there are any aspects of the business which are a cause for concern, these are to be identified and explained in your report. You are to suggest actions to be taken which will address these concerns. If there are aspects of the business which indicate a strength, these must also be identified with an explanation as to why they are strengths. You are expected to cover all tasks to ensure you will be producing evidence for all the learning outcomes.
You are also advised to carry out further analysis using your own initiative and the information you have acquired to show greater understanding of the topic and ensure you achieve the grade your work deserves
Detailed Assignment
1. Produce monthly trading accounts for the rooms division department for the 3 months shown, as well as an overall account. These records should show relevant percentages.
2. Identify any aspects of the business which are a cause for concern.
3. Produce detailed suggestions for how to resolve causes of concerns identified in task 2.
4. Produce a budgeted trading account for the next three months showing how your suggestions will improve the rooms division results. Explain some of the limitations of this budget.
5. Describe the main elements of cost for the rooms division, and how their behaviour is affected by the volume of sales.
6. The meeting rooms are not being used very much and it is believed this is due to the limited range of technical equipment provided for audio visual presentations. The cost of updating each room is £30,000. What advice would you give the General Manager about how to do this and how to fund this expenditure? Provide clear reasons for the guidance you offer explaining the costs and advantages of your proposals.
7. A Travel Firm would like to run hen party weekends for groups of up to 20 guests and is offering to pay £85 per person for 3-day all-inclusive breaks. Would you accept the offer? Explain your answer.
8. Analyse The Adler Hotel Company Ltd overall results using recognised accounting tools.
You are advised to ensure your report covers all the Learning Outcomes and Assessment Criteria in the unit. See the table attached showing how the above questions relate to the Learning Outcomes and Assessment Criteria.
The Adler Hotel Case Study
The hotel is situated on the edge of the town centre and has its own secure car park for guests. Some guests arrive with their ski equipment which the hotel can store for them, but others hire equipment from one of the hire shops in town.
There are 65 bedrooms, 5 family rooms and 3 suites. Most guests book on a bed and breakfast basis, but some also have dinner included in their package.
The Hotel has two restaurants, both of which are open to residents and non-residents. The Glacier Restaurant serves breakfast, light priced at £35; and the Adler is a fine dining à la carte restaurant which is only open in the evening. There is one large bar and lounge area, open to residents and non-residents.
The Glacier Restaurant has been run by Maria, who has worked her way up from starting as a waiter seven years ago. It can seat 100 guests but after serving breakfast it is generally quiet for the rest of the day. It has a 30% staff turnover, mainly young people looking for work experience before moving on.
The Adler seats up to 50 guests and is run by Simon, who has been at the hotel for 25 years. He has maintained the very high standards of food service unchanged for the last ten years and believes his restaurant is the main attraction for guests to stay in the hotel. Most of the staff have been at the hotel for over 5 years. The food ASP is £45.
There are 65 en-suite rooms, of which 50 are doubles and 15 twins. The rack rate is £95 room only per head, and this increases to £105 including breakfast, and £130 including dinner. All rooms are in excellent condition and include Netflix and other cable TV services, and 24-hour room service. The head housekeeper Greta has been at the hotel for 5 years and has 4 assistants and 18 room attendants. She earns £30,000 a year; the assistants earn £22,000 and the room attendants earn £18,000.
The hotel has three meeting rooms which can each hold up 100 people in a theatre layout. All can be provided with a full food and drink service if requested by the client. Charges range from £30 an hour up to £250 for a full day
The Adler Hotel Company Ltd Consolidated Profit and Loss Account
| 2023 | 2022 | |||
| £ 000 | £ 000 | |||
| Turnover | 7850 | 7,000 | ||
| Cost of sales | 440 | 350 | ||
| Gross Profit | 7,410 | 6,650 | ||
| Labour costs | 2,750 | 2,500 | ||
| Net Margin | 4,660 | 4,150 | ||
| overheads | 3,600 | 4,000 | ||
| Operating profit before tax | 1,060 | 150 | ||
| Taxation | 191 | 22 | ||
| Loss/profit for financial year | 869 | 128 | ||
| Consolidated Balance Sheet | 2021 | 2020 | ||
| £ 000 | £ 000 | |||
| Fixed Assets | ||||
| Premises | 4,500 | 3,500 | ||
| Equipment | 2,500 | 2,500 | ||
| 7,000 | 7,000 | 6,000 | 6,000 | |
| Current Assets | ||||
| Stocks | 21 | 29 | ||
| Debtors falling due within one year | 250 | 600 | ||
| Cash at bank and in hand | 20 | 25 | ||
| 251 | 654 | |||
| Creditors amounts falling due within one year | 900 | 500 | ||
| Working Capital | -649 | -649 | 154 | 154 |
| Net assets | 6,351 | 6,154 | ||
| Represented by | ||||
| Long term liabilities | 347 | 347 | 250 | 250 |
| Capital and reserves | ||||
| Share capital | 5,000 | 5,000 | ||
| retained profit | 1,004 | 904 | ||
| Shareholders` funds | 6,004 | 6,004 | 5,904 | 5,904 |
| 6,351 | 12,058 | 6,154 |
Adler Hotel Rooms Division
| Jan | Feb | Mar | |||
| Double rooms sold | 1100 | 1200 | 1250 | ||
| Single rooms sold | 250 | 200 | 220 | ||
| 1350 | 1400 | 1470 |
| Overheads per year | |
| rent | 900,000 |
| power | 30,000 |
| insurance | 15,000 |
| depreciation | 150,000 |
| maintenance | 800,000 |
SHN6023 : Mental Health, Resilience and Recovery Across the Life-course – Case Study Assignment
Read MoreBUS6009 : International Business Management – Written Case Report
Read MoreBUS6018 : PROJECT MANAGEMENT – PROJECT PLAN
Read MoreHCM4003 : Communication and Interprofessional Collaboration – Podcast
Read MoreQHO335 : Business Project – Critical evaluation of an organisation’s response during the cost-of-living crisis in the UK
Read MorePRM7006 : Management of Traditional Projects – PID Assignment
Read MoreBMA5108-20H : International Business – Strategic Evaluation
Read MoreCA5055 : Airline Revenue and Pricing Management – REPORT
Read MoreCA5056 Aviation Psychology and Human Factors Assignment brief
Read MoreHow can i assist with youGBEN5006 : Intrapreneurial Development – Portfolio
Read More