1 T37 fx A B C D E F G H 1 J K L M N P Q 2 3 4 5 6 7 8 Rooms Occupied 9 ADR Apex Mountain Inn Budget 20X4 Benchmark Rate Jan Feb Mar Apr May June $ % $ % $ % $ % $ % $ % 3,600 $ 185 $ 3,400 185 3,900 3,950 $ 190 $ 195 $ 4,250 205 $ 5,500 225 13 14 15 16 10 Room Revenue 11 12 Payroll Expense: Management Front Desk Staff Housekeeping Supervisor Housekeepers $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 15,000 0.11 $ 13.85 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 0.49 $ 10.50 17 Total Rooms Wage Expense 18 Payroll Taxes and Benefits 51% 19 Total Payroll Expense 20 21 Direct Expenses: 22 Guest Amenity $ 1.25 23 Cleaning Supplies $ 0.84 24 Linen Expense $ 0.79 25 Terry Expense $ 1.34 26 Reservations Expense $ 5.95 27 Total Direct Expense 28 29 Total Departmental Expense 30 31 Departmental Profit 32 Departmental Profit % 33 34 35 Required: 36 37 Complete the budget for the first six months above. 38 Use Excel Formula to calculte the appropriate value in each of the cells. 39 Make certain all of your numbers are correctly formatted. 40 41