SnewSwaaguth - YourName FileName.xls YourEUID 1 2 3 4 5 6 7...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
gg solution 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 AB C D Weighted Average worksheet prepared by Dr. Gopala Ganesh ? means input information from case c means write a formula and calculate Inputs Section Rate for Luxury Suite 200.00 $ % weekday night occupancy 65.00% % weekend night occupancy 40.00% Rate for Deluxe Suite 150.00 $ % weekday night occupancy 70.00% % weekend night occupancy 50.00% Rate for Comfort Suite 100.00 $ % weekday night occupancy 75.00% % weekend night occupancy 60.00% Rate for Economy Suite 75.00 $ % weekday night occupancy 80.00% % weekend night occupancy 70.00% Luxury % of all suites 10.00% Deluxe % of all suites 20.00% Comfort % of all suites 30.00% Economy % of all suites 40.00% # of weekday nights in a week 5 # of weekend nights in a week 2 # of nights in a week
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/15/2011 for the course BUSI 5920 taught by Professor Staff during the Spring '11 term at North Texas.

Ask a homework question - tutors are online