Task 1 - Your Tasks: You are required to complete a draft budget based on information and factors that were determined during an executive meeting at Hotel Futura. A. Access the excel spreadsheet named "Task 1-Hotel Futura Budget_Forecast" provided on Moodle. The first tab on this spreadsheet is labelled "Departments Small" and shows the existing budget figures for the 2016 financial year. B. Use the template "Draft Budget" on the second tab of the spreadsheet and perform the calculations below using basic formulas. Your forecast needs to include the Dollar Figures and the % values for these affected by changes outlined below. The % values must be listed for each expense item shown in the Expenses Analysis for each department. You have met with the department heads of Hotel Futura and the following details have been discussed to prepare your draft budget for 2017: 1. Rooms Division: a. Due to renovations the rooms available have been reduced to 9696. b. The forecasted occupancy rate has been adjusted to 809% c. The revenue per available room needs to be increased to $150.00 d. The COGS will increase to 15% of total room revenue e. Staff costs need to be increased to 20% of total room revenue to allow for increases in superannuateon and awards. f. Other Expenses need to increase to 8% of total room revenue to cover electricity price rises. 2. Catering: a. The food revenue will be increased by 15% due to a new marketing campaign and specialty menus b. The beverage revenue will increase by 8%. c. Staff costs need to be adjusted to 44% of the food budget. d. Other Expenses will need to be increased to 79%. 3. Banquet: The Banquet Division will be directly affected by the new marketing campaign which has been directed at daytime seminars and corporate functions. For this purpose the kitchen has received specialised equipment including multiple combi steamers, hold-o-mats and sous-vide equipment