Search YP X AutoSave On Sleeptight Motel Exercise . Saved v Yifeng Pei X Comments Share ~ File Home Insert Page Layout Formulas Data Review View Help AutoSum Century Gothic 12 ~ A" A " = = = 29 ap Wrap Text Percentage TIX AY O Cell Fill Insert Delete Format Sort & Find & Analyze Paste BIUVVMA V Merge & Center Conditional Format as 00 :0o Formatting Table v Styles v Clear Filter Select Data Cells Font Alignment Number Styles Editing Analysis Undo Clipboard F35 =E35/E$15 E F G H K L M N O P Q R S A B Sleeptight Motel Year Ending December 31,2022 W N Budget Actual Variances $ % Number of Rooms 80 80 Rooms Available 29,200 29,200 Rooms solo 19,856 20,294 Occupancy % 68.00% 69.50% ADR $85.00 $82.60 RevPAR $57.80 $57.41 Revenue: Rooms $1,687,760.00 97.33% $1,676,284.40 97.30% Convenience Store $46,353.97 2.67% $46,451.25 2.70% Total Revenues $1,734, 113.97 100.00% $1,722,735.65 100.00% Departmental Expenses Payro $270, 128.04 16.01% $285, 135.98 17.01% 18 Laundry $16,855.99 1.00% $16,830.16 1.00% Linen $33,820.03 2.00% $34,699.09 2.07% Commissions $16,855.99 1.00% $16,830.16 1.00% Other Expenses $25,283.98 1.50% $27, 155.81 1.62% Total Rooms Department Expenses $362,944.04 21.50% $380,651.20 22.71% Convenience Store $36,593.35 78.94% $38,634.58 83.17% Total Departmental Expenses $399,537.38 23.04% $419,285.78 24.34% Departmental Income Rooms $1,324,815.96 78.50% $1,295,633.20 77.29% Convenience Store $9,760.63 57.91% $7,816.68 46.44% Total Departmental Income $1,334,576.59 76.96% $1,303,449.88 75.66% Undistributed Operating Expenses Administration $329,772.31 19.02% $332,227.45 19.28% Maintenance & Utility $234,363.09 13.51% $244,628.46 14.20% Total Undistributed Operating Expenses $564, 135.40 32.53% $576,855.91 33.48% Insurance $6,000.00 0.35% $6,000.00 0.35% Property Taxes $6,600.00 0.38%% $6,600.00 0.38%% 35 Gross Operating Income $757,841.19 43.70% $713,993.96 41.45% 36 Sheet1 + + 70% Ready Accessibility: Good to go 99+ 16:25 33F 1 8 6 ENG 2023/3/12 5 cloudy