please answer step by step using excel formula ( or type out how it comes out, like revenues)

A B C D E F G H K L M The MOU Motel's costs at two different sales level are as follows AWN Monthly Room Sales 2,000 3,000 Payroll: Salaries 15,000 15,000 Wages 40,000 60,000 Employee benefits 9,200 10,700 Supplies 2,000 3,000 10 Utilities 6,000 8,000 11 Other operating costs 4,000 5,000 12 Building rent B,000 8,000 13 Interest expense 2,000 2,000 14 Insurance 3,000 3,000 15 16 1 Identify each cost as fixed, variable, or mixed 17 2 what are the total estimated monthly fixed costs 3 what are the total estimated variable costs per room sold 19 4 Develop a single equation to estimate total costs at various level of activity 20 5 Project the total costs if 3,500 rooms are sold 21 22 ANSWER Fixed 23 Variable 24 Mixed 25 26 27 1 Cost Fixed Variable payroll: 29 Salaries [formula] [number) [number) 30 Wages [formula] number} [number] 31 Employee benefits [formula] number} [number) 32 Supplies (formula] number} [number) 33 Utilities [formula] [number) [number) 34 Other operating costs [formula] (number] [number) 35 Building rent [formula] [number) [number) 36 Interest expense [formula] [number) [number) 37 Insurance [formula] [number) (number} TOTAL 2 [formula] 3 [formula) 39 40 Hint: For column E, please enter a formula as =C22, =023 or = C24 to indicate whether it is a fixed cost, vairable cost or mixed cost 41 Hint: For column G and I, only enter the number when it is applicable 42 43 4 Total Costs = [formula] [number) X Room sales 44 5 Total cost formula]