Excel 2013 Comprehensive ASMT1

Excel 2013 Comprehensive ASMT1 - Beachfront Guest House...

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?
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

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

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern