SWAAGUTH - effective revenue, Luxury, weekday night c...

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

View Full Document Right Arrow Icon
Spring 2011 Swaaguth Inc. 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 ? % weekday night occupancy ? % weekend night occupancy ? Rate for Deluxe Suite ? % weekday night occupancy ? % weekend night occupancy ? Rate for Comfort Suite ? % weekday night occupancy ? % weekend night occupancy ? Rate for Economy Suite ? % weekday night occupancy ? % weekend night occupancy ? Luxury % of all suites ? Deluxe % of all suites ? Comfort % of all suites ? Economy % of all suites ? # of weekday nights in a week ? # of weekend nights in a week ? # of nights in a week ? Outputs Section
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: effective revenue, Luxury, weekday night c effective revenue, Luxury, weekend night c therefore, effective revenue, Luxury per night c effective revenue, Deluxe, weekday night c effective revenue, Deluxe, weekend night c therefore, effective revenue, Deluxe per night c effective revenue, Comfort, weekday night c effective revenue, Comfort, weekend night c therefore, effective revenue, Comfort per night c effective revenue, Economy, weekday night c effective revenue, Economy, weekend night c therefore, effective revenue, Economy per night c Hence, Swaagath revenue per suite per night c...
View Full Document

Ask a homework question - tutors are online