Monthly Room Salar 2,000 3,000 Payroll: Salarior Wagor Employee benetin Supplier Utilitiar Other operating carts Building ront Intorart expono Insurance 15,000 40,000 4,200 2,000 8,000 4,000 8,000 2,000 3,000 15,000 60,000 10,700 3,000 8,000 5,000 8,000 2,000 3,000 1 Identify wash cart ar fixed, variable, or mixed 2 What are the total artimated monthly fixed carts 3 What are the total artimated variable cartr por roomsald 4 Dovolop asingle equation to artimate total cort at various level of activity 5 Project the total cortif 3,500 room arorald ANSWER Fixed Variable Mixed Fixed Variable 1 Cart Payroll: Salarior Waqar Employee benefits Mixed Supplier Variable Utilitiar Other operating cart Mixed Building rent Fixed Interer expono Fixed Insurance TOTAL 2 3 Hint:For column E, please enter a formula sr-C22,-C23 or-c24 to indicate whether it is a fixed cart, vairable cart or mixed cart Hint:For column Gand, only enter the number when it is applicablo 4 Total Car X Roomraler 5 Totalcar