Excel 2013 Comprehensive ASMT1

# Excel 2013 Comprehensive ASMT1 - Beachfront Guest House...

• Homework Help
• 2
• 75% (4) 3 out of 4 people found this document helpful

This preview shows page 1 - 2 out of 2 pages.

Beachfront Guest House Effective May 1, 2016 Peak Rentals Off-Peak Rentals Rental Type No. Units Per Day Per Day Studio Apartment 6 \$ 149.95 \$ 899.70 \$ 112.50 \$ 675.00 25.0% 1 Bedroom Suite 4 \$ 250.45 \$ 1,001.80 \$ 174.00 \$ 696.00 30.5% 2 Bedroom Suite 2 \$ 450.00 \$ 900.00 \$ 247.55 \$ 495.10 45.0% Questions & Answers Assume all 12 units are rented as you answer the following questions: (1) Which rental type generates the most maximum revenue for peak rental periods? 1 Bedroom suite (2) Which rental type generates the most maximum revenue for off-peak rental periods? Studio (3) Why is there a difference? because sudio is 25% whereas 1 bedroom is discounted 30.5 % (4) How much would the 2 Bedroom Suite Off-Peak per day rate need to be to have the same off-peak maximum revenue as the 1 Bedroom Suite?

#### You've reached the end of your free preview.

Unformatted text preview: \$354.65 247.55 - 174.00 = 73.55 73.55*.45 - 33.55 73.55+33.55=107.10 247.55+107.10 =354.65 Maximum Revenue Maximum Revenue Discount Rate Beachfront Guest House Efectve May 1, 2016 Peak Rentals OF-Peak Rentals Rental Type No. Units Per Day Per Day STudio AparTmenT 6 \$ 149.95 \$ 899.70 \$ 112.50 \$ 675.00 25.0% 1 Bedroom SuiTe 4 \$ 250.45 \$ 1,001.80 \$ 174.00 \$ 696.00 30.5% 2 Bedroom SuiTe 2 \$ 450.00 \$ 900.00 \$ 247.55 \$ 495.10 45.0% Maximum Revenue Maximum Revenue Discount Rate A B C D E F G 1 2 3 4 5 6 7 8...
View Full Document

• Fall '15
• taylo
• Apartment, bedroom suite, Peak Rentals

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern