Information Systems Excel

profileKobra123
sparrow_e01_grader_h2.xlsx

Rental Rates

Beachfront Guest House
Effective May 1, 2018
Peak Rentals Off-Peak Rentals
Rental Type No. Units Per Day Maximum Revenue Per Day Maximum Revenue Discount Rate
Studio Apartment 6 149.95 120 720
1 Bedroom Suite 4 250.45 174 696
2 Bedroom Suite 2 450 247.55 495.1
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?
Apply Yellow highlight to the correct answer below:
Studio Apartment
1 Bedroom Suite
2 Bedroom Suite
(2) Which rental type generates the most maximum revenue for off-peak rental periods?
Apply Yellow highlight to the correct answer below:
Studio Apartment
1 Bedroom Suite
2 Bedroom Suite
(3) Why is there a difference?
Change XX.X to the correct values at the end of the following sentence.
The Studio Apartment is discounted only 20% for off-peak periods, whereas the 1 Bedroom Suite is discounted XX.X%.