Revenue budget – actual for 2015-2016 Month Accommodation Food Beverages Total July 3000 1600 1560 6160 August 2800 1800 1600 6200 September 2800 1800 1900 6500 October 3600 2400 1800 7800 November 3800 3000 1960 8760 December 6000 3800 1700 11500 January 8800 3800 1600 14200 February 8800 4000 1600 14400 March 3800 3400 1400 8600 April 3600 2600 1200 7400 May 3400 2400 1400 7200 June 3200 1800 1500 6500 Total $53600 $32400 $19220 $105220 Betsy has also provided you with the following expenditure information that you will need to consider when preparing your cash flow budget. This data has been sourced from historical data, committed costs for the B&B and Marino Enterprises policy: • Marino Enterprises’ overheads are $2000. All individual businesses and departments pay this overhead in August of each year. • Lease payments are $1,500 monthly. • Combined insurance coverage to increase to $1,400 per year paid in two equal payments in March and September. • General repairs and maintenance to the property of $4,800 pa to be budgeted monthly. • Digital marketing and advertising costs will be $2,400 pa, payable monthly. • Charges for out-sourced laundering is $800 per month. • Electricity charges are payable every quarter as follows: • September: $2,200 December: $2,000 • March: $2,400 June: $3,000 • General monthly miscellaneous expenses amount to $600/month. You also know from your experience and the management of the property that: • You need to replace some linen and towels at the cost of $2000 and replace kitchenware consumables to the value of $1000 at some point in the year. You will need to decide when it is best to include this expenditure in your budget along with an explanation to Betsy as to why you think it is best budgeted for in those months. • The monthly cost of F&B stock is predicted to run at 40% of the food and beverage sales. You will need to calculate this cost into your projections. • The cost of labour is calculated at 25% of all monthly sales. You will need to calculate this cost into your projections. Considering all round expenditure and then evaluating with the total sales.