Financial Management for Hotel Industry

FINANCIAL MANAGEMENT
FOR HOTEL INDUSTRY

TABLE OF CONTENTS
TABLE OF CONTENTS................................................................................................................2
TASK 1............................................................................................................................................1
Cash Budget of Hotel for January to December 2020.................................................................1
TASK 2............................................................................................................................................5
Profit Budget Forecast for January to June 2020.........................................................................5

TASK 1
Cash Budget of Hotel for January to December 2020
Jan February March April May June
£ £ £ £ £ £
Receipts :
Collection
from Room
Sales 1,22,625 1,26,925 1,34,750 1,43,575 1,47,125 1,67,500
Food & Bever-
age 44,500 40,100 43,300 42,600 40,200 36,500
Rent 950 950 950 950 950 950
Commision 25 55 20 15 10 40
Total Receipts 1,68,100 1,68,030 1,79,020 1,87,140 1,88,285 2,04,990
Payments :
Laundry 6,250 6,250 6,250 6,250 6,250 6,250
Printing and
stationary 2,000 2,000 2,000 2,000 2,900 2,000
Toiletries 46,000
Salaries 1,10,000
Wages 11,667 11,667 11,667 11,667 11,667 11,667
Marketing cost 60,000
Payment to
suppliers 0 2,000 12,300 2,000 16,400 2,000
Van 28,000
Petrol and
diesel 1,000 1,000 1,000 1,000 1,000 1,000
Restaurant Im-
provements 8,800 22,000
General Main-
tenance 5,000 5,000 5,000 5,000 5,000 5,000
Lighting &
heating 27,500 27,500
Rates 21,668 5,417 5,417
Total pay-
ments 25,917 73,917 1,02,517 49,584 48,634 2,52,834
1