From the following information which relates to the Hotel rooms only, you are required to prepare a month by month cash budget forecast for January 2021 to December 2021 (show each month separately).

 

Travelodge, Tower Hill, London

Module Learning Outcomes
(from module syllabus)

1. Analyse and evaluate the informational requirement of management, particularly in relation to decisions involving revenues and costs and other financial criteria.

2. Select and apply appropriate cost and management accounting methods and techniques.

TASK DESCRIPTION

Task 1

The Travelodge, Tower Hill, London a 3-star Hotel in London, United Kingdom. The hotel has 182 rooms for which an average rate of £55 per night is charged, irrespective of whether the room is occupied by one or two people.

From the following information which relates to the Hotel rooms only, you are required to prepare a month by month cash budget forecast for January 2021 to December 2021 (show each month separately). Budgets related to the restaurant are recorded separately. (60% of assignment total mark)

On the basis of past experience and taking account of predicted future developments in the market, the hotel’s management believes that the average nightly demand for 2021 will be:

Month                                  Predicted Revenue
                                               £

January                               91,818

February                           61,697

March                               245,648

April                                 271,454

May                                  280,280

June                                  277,745

July                                  222,182

August                             280,203

September                     241,939

October                          261,697

November                     193,794

December                     277,745

Each month, 55% of room sales are made for cash, whilst 45% are made on credit (business accounts), except for September, where the credit sales figure increases to 65%

Of the rooms paid for via business accounts, payment is received from customers as follows:

51% within one month of the invoice date
48% within two months of the invoice date
The balance is not normally received (i.e. it is a bad debt)

Those customers who pay within 30 days of the invoice date will receive a discount of 4% from the hotel

The hotel is charged an annual cost of £182,000 for Laundry services, irrespective of occupancy rates.

The hotel’s printing and stationary costs are £5,000 per month, except for March, June and November where extra printing costs of 38% are incurred due to annual date changes and other amendments.

The complimentary toiletries total £82,000 per annum.

The complimentary in-room beverages (coffee, tea, sugar, milk and biscuits) are purchased on credit monthly at a cost of £5,000, except when room occupancy rates go over 65%, at which point the cost increases to £5,600. When room occupancy rates increase to 85% or more, the cost increases to £5,900. All other beverages are covered by a separate budget.

The hotel plans to purchase the adjacent building at a cost of £5,000,000 to facilitate future expansion, An initial deposit of 25% of the purchase price will be paid in December, the remainder being paid via a mortgage from January 2022

The hotel has been going through regular upgrades of facilities, stock and inventories. Bedding bundles are included in these upgrades. 182 bundles will be purchased in May, to replace those which are old/damaged. Each Bundle costs £30 from the Hotel’s usual supplier.

In June, 182 new kettle tray sets at a cost of £29 each will be purchased as replacement sets. They will be paid for in full at time of delivery. Also in June, 182 Towel sets at £45 per set will be purchased and paid for a month following receipt.

Employee details:

There are currently 28 salaried staff at the hotel, totalling £780,000 per annum.
There are currently 140 staff who receive a wage, with a combined total of £480,000 per annum
The hotel also employs zero-hour contract staff to cover the busy periods, where there is over 80% occupancy. At these times, it is anticipated that 100 staff members will receive a wage of £70 per shift, with each employee working ten shifts within that month.
All salaries and wages are inclusive of employer National Insurance contributions.

Details of cost payments are as follows:

Complimentary shampoos, conditioners and shower gels for guests are all purchased from the usual supplier who allows the hotel a month’s credit before payment
All other suppliers are paid two months after receipt of goods
Laundry services are paid for quarterly, the next payment is due in March 2021
All wages are paid weekly
All salaries are paid on the last day of the month

Light and heat will be paid quarterly from February, with an anticipated annual cost of £98,000. Annual Business rates of £76,500 will be paid in monthly instalments, starting in April 2021

Marketing costs of £18,000 will be incurred in April and October 2021

Corporation tax of £849,000 is to be paid in March 2021, which is 9 months after the hotel’s year end.

Annual petrol and diesel costs for the hotel’s motor vehicles is £10,000, with the cost being spread equally throughout the year.

The hotel management will refurbish the top floor of the hotel. The contractor anticipates that it will take until October 2021 for the rooms to be ready. Fixtures and fittings will be delivered in July 2021 at a cost of £95,000 and paid in four instalments, beginning in August 2021. Building costs are estimated to be around £350,000 and will be payable in monthly instalments beginning in July 2021, with the final payment being due in October 2021.

Hotel Management have also decided that the public toilets on the ground and first floor will also be refurbished. This will incur extra decorating costs of £28,000, which will be paid for in November.

The annual general maintenance costs for the Hotel are £250,000 and are spread out monthly within the budget.

Every year in September, a cleaning company is employed to undertake a deep clean of the Hotel. This service incurs a cost of £25,000 and will be paid for in November.

If the Hotel is overdrawn at the end of any month, it will be charged interest at an annual rate of 5.4%. This will be charged to the company’s account on the 2nd day of the subsequent month.

However, if the Hotel is in credit at the end of the month, interest will be credited to its account on the 4th day of the subsequent month calculated at 2.5%.

Opening cash balance at 1st January 2021 is £180,000

The hotel has been the venue for an Accounting conference each November since 2015, which results in full occupancy during the week of the event, which significantly increases the overall occupancy percentage for that month. The contract for the holding of this event is due for renewal discussions in June 2021.

Task 2

The new chief executive of the hotel has asked you to provide details of the zero-base budgeting technique with a view to implementing this type of budgeting approach in the future.
You are required to prepare a report for the board of directors that:
Defines and evaluates the process of zero-base budgeting
Assesses the advantages zero-base budgeting has over traditional based
How the organisation might introduce such a technique in practical terms

(1000 +/- 10% words – 40% of assignment total mark)