ou 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". 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: Rooms Division: a. Due to renovations the rooms available have been reduced to 96%. b. The forecasted occupancy rate has been adjusted to 80%. c. The revenue per available room needs to be increased to $150.00