2. Big Tex is a true Texan. When he opened his hotel on the plains of West Texas, he named it the Screaming Saloon Inn. He now provides you with the following information about his property The inn has 200 rooms, and averages 95% rooms available for sale throughout the year Average Daily Rate (ADR) = $60 I Variable Costs 40% of sales Fixed Costs $604,800 per year Desired Profit $650,000 per year (after taxes) Tax Rate-: 36% Spreadsheet hint: Use the ROUNDUP function in the cells indicated throughout the problem to round up rooms.) a. Big Tex has asked you to help him calculate the following Spreadsheet hint: Do not calculate SP Percentage. You must type in 100 for SP Percentage in order for the grid to calculate propery) Per Unit (Room)Percentage SP CM Total fixed costs Desired aftertax prafit Tax rate Before-tax profit Roams available for sale per year