The purpose of this assignment is twofold. The first objective is to familiarize students with the format and how percentages are calculated in STR Host and PKF Trend reports. The second goal is to ensure that students are proficient in building basic spreadsheets. Below is an STR Host Report, Start with a blank Excel spreadsheet and recreate the report so that all answers are correctly calculated. You may directly input necessary data in the column in the left, but use formulas to correctly calculate the totals and percentages in the right hand column. Submit the Excel spreadsheet as an attachment via Sakai. To get full credit the spread sheet needs to demonstrate proper use of formulas and formatting. Grading Criteria: Proper use of formulas and correct answers: 80% Occupancy Average Rate REVPAR Revenues Rooms Marriott Hotels 73.0% $ 156.00 $ 113.88 S/Avail Rm Percent $ 41,700 55.7% $ 23,700 31.7% $ 3.100 4.1% $ 500 0.7% $ 5,800 7.8% $ 74,800 100.0% Food Beverages Telephone Rentals and Other Income Total Revenue Departmental Expenses Rooms Food & Bevera Telephone Rentals and Other Income Total Departmental Expenses $ 8,900 $ 17.500 $ 700 $ 4,000 $ 31,100 21.3% 65.3% 140.0% 69.0% 41.6% Departmental Income $ 43.700 58.4% $ $ 6.200 4.200 Undistributed Operating Expenses Administrative & General Marketing Franchise Fees Prop. Oper. & Maintenance Energy Costs Total UDOES 8.3% 5.6% 0.0% 3.5% 3.7% 21.1% $ 2,600 $ 2.800 $ 15,800 Income Before Fixed Charges $ 27,900 37.3% Fixed Charges Management Fee Property Tax Insurance Reserve for Replacement Total Fixed Charges $ $ $ $ $ 2.244 2.000 800 2.992 8,036 3.0% 2.7% 1.1% 4.0% 10.7% Net Income $ 19,864 26.6%