1 B Instructions for students You will prepare various budgets, conduct a variance analysis and write a memo to the CEO of Crown Hotel regarding ethical practices during budgeting. This relates to content taught in 1. Your input is required for the following spreadsheets whose tabs are highlighted in yellow: > Static Budget > Actuals > Flexible Budget > Var Analysis - Static and Flex > Sales variances > Assumptions 52. Within each of the above spreadsheets, your input is required for cells highlighted in grey: 5 You calculate values, as those values will help in preparing static, Actual and flexible budget tabs 73. The input data is availalble in the spreadsheet, 'Input Database'. This spreadsheet is locked and you will 9 not be able to make any changes to its values. You are required to link data from this spreadsheet and complete the inputs in the spreadsheets above (whose tabs are highlighted in yellow). 4. Ensure that there are no plugged values in cells, use firmual to get figures 5. IF statements are used where appropriate. 26 Prepare inventory budget and cash collection budget, you should make template considering Royal examaple. 47. You will also write a memo regarding ethical conduct during budget preparation and how building in 'slack' represents unethical behaviour. 5 Grading: 9 This is an Group assignment worth 20% of your final grade. Related textbook content: The content you are being assessed on, appears in Chapter 7 and Chapter 11 of the textbook. This content is covered in class during weeks 9,10 and 11.