logo

Budget Report & Budget Forecasting

   

Added on  2023-01-09

9 Pages1937 Words37 Views
 | 
 | 
 | 
Budget Report & Budget
forecasting
Budget Report & Budget Forecasting_1

Contents
TASK 1............................................................................................................................................1
Month by month cash budget forecast for January 2020 to December 2020 (St Brides Group) 1
TASK 2............................................................................................................................................4
(a) Defining and evaluating the process of zero-base budgeting.................................................4
(b) Assessing the advantages zero-base budgeting has over traditional based............................5
(c) How the organisation might introduce such a technique in practical terms...........................6
REFERENCES................................................................................................................................7
Budget Report & Budget Forecasting_2

TASK 1
Month by month cash budget forecast for January 2020 to December 2020 (St Brides Group)
Particulars January February March April May June
Predicted revenue 195600 198218 191005 203968 213616 205450
Cash sales (A) 117360 118931 114603 122381 128170 123270
Credit sales (Revenue - cash
sales) 78240 79287 76402 81587 85446 82180
Credit sales distribution:
53% of credit sales 41467 42022 40493 43241 45287 43555
Less: Discount of 2.5% 1037 1051 1012 1081 1132 1089
Net 53% of credit sales (B) 40431 40972 39481 42160 44154 42467
46% of credit sales (C) 12000 35990 36472 35145 37530 39305
Bad debt 782 793 764 816 854 822
Net predicted revenue 169791 195893 190556 199686 209854 205042
Expenses:
Hybrid motor vehicles 22000
Laundry services 4500 4500
Printing and stationary costs 1800 1500 1500 1500 1800 1500
Complimentary toiletries
(shampoos, conditioners and
shower gels for guests) 1273 1273 1273 1273 1273
Complimentary in-room bever-
ages (coffee, tea, sugar, milk
and biscuits) 2000 2000 2000 2000 2000 2000
Two new hot-tubs 3750
Bedding bundles 4140
New kettle tray sets
Ten salaried staff at the hotel 15000 15000 15000 15000 15000 15000
35 waged staff at the hotel 12500 12500 12500 12500 12500 12500
1
Budget Report & Budget Forecasting_3

End of preview

Want to access all the pages? Upload your documents or become a member.