1 A Staff bonus incentive of 5% will only be paid ifTotal Gross Income exceeds 8,000 per month. This bonus will only be paid on the amount of gross income in excess of 8,000 and applies separately to each hotel. Please use an appropriate function to calculate whether or not this bonus will be paid and if so, how much it will be in each hotel. This will be paid into an account and used at our annual away day in March of each year. 2 In each bar we have independent sales income, this comes from local suppliers who pay a commission on any sales on our premises. This is currently 15% and the total gures received should be detailed in the Bar Income section of the spreadsheet. Information required for our management meetings are as follows: Total Income from Rooms per month Total Bar Income Gross Revenue Total Expenses Net Operating Prot QOOOO 3 During the consultation regarding this spreadsheet it was noted that the Room Reference codes were different lengths. Please use a function to only use the rst 5 characters and numbers in the reference given. 4 Appropriate linking of all data should be used. Please name the cell containing the Bonus incentive percentage and the Independent Sales Commission rate appropriately and use this within your calculations