Cash budget of Cardiff Central Hotel for 2020

HOSPITALITY INDUSTRY

TABLE OF CONTENTS
TABLE OF CONTENTS................................................................................................................2
TASK 1............................................................................................................................................1
Cash budget of Cardiff Central Hotel for 2020..........................................................................1
TASK 2............................................................................................................................................5
Budgeted Profit or loss statement for Jan to June 2020...............................................................5

TASK 1
Cash budget of Cardiff Central Hotel for 2020.
Jan Feb March April May June
£ £ £ £ £ £
Receipts :
Collection - Room
Sales
1,22,625 1,26,925 1,34,750 1,43,575 1,47,125 1,67,500
F & Bev. 44,500 40,100 43,300 42,600 40,200 36,500
Rent 950 950 950 950 950 950
Commission 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
Printing &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 & diesel 1,000 1,000 1,000 1,000 1,000 1,000
Restaurant Improve-
ments
8,800 22,000
General Maintenance 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 payments 19,667 73,917 1,02,517 49,584 48,634 2,52,834
Balance b / f 2,65,000 4,13,433 5,07,547 5,84,050 7,21,606 8,61,257
Net cash flow in
month
1,48,433 94,113 76,503 1,37,556 1,39,651 -47,844
1