ZOOM + ns Fuations Beachfront Guest House Effective May 1, 2016 Peak Rentals Off-Peak Rentals Rental Type No. Units Per Day Maximum 1 Per Day Maximum I Discount Rate Studio Apartment 6 149.95 112.5 1 Bedroom Suite 4 250.45 174 2 Bedroom Suite 2 450 247.55 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? (2) Which rental type generates the most maximum revenue for off-peak rental periods? (3) Why is there a difference? (4) How much would the 2 Bedroom Suite off-Peak per day rate need to be to have the same off- hp . 2 Guest House Rental Rates ANALYSIS You manage a teach guest house in Pt Lauderdale containing three types of rental units. Prices are CASE each rental type, assuming all units are rented. In addition, you need to calculate the discount rate for off peak rental times. Finally , you will improve the appearance of the worksheet by applying font, alignment, and number formats a. Open colm Rentals and save it as eO m2 Rentals LastFirst. b. Merge and center Peak Rentals in the range C4D4, over the two columns of peak rental data, Apply Dark Red fill color and White Background I font color c. Merge and center of Peak Rentals in the range B4:G4 over the three columns of off peak rental data. Apply Blue fill color and White Background I font color d. Center and wrap the headings on row 5. Adjust the width of columns Dand F, if needed. Center the data in the range B6:38 e. Create and copy the following formulas Calculate the Peak Rentals Maximum Revenue by multiplying the number of units by the peak rental price per day Calculate the Off Peak Rentals Maximum Revenue by multiplying the number of units by the off peak rental price per day. Calculate the Discount rate for the Off-Peak rental price per day. For example, using the peak and off-peak per day values, the studio apartment rents for 75% of its peak rental rate. However, you need to calculate and display the off peak discount rate, which is 24975 f. Format the monetary values with Accounting Number Format, Format the Discount Rate for mula results in Percent Style with one decimal place. 9. Apply Blue, Accent 1. Lighter 80% fill color to the range E5:68 DISCOVER B . Select the range C5:08 and apply a custom color with Red 242, Green 220, and Blue 219. * 1. Answer the four questions below the worksheet data. If you change any values to answer the ques. tions, change the values back to the original values j. Set 1" top, bottom, left and right margins Center the data horizontally on the page. k. Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side 1. Create a copy of the Rental Rates worksheet place the new sheet to the right side of the original worksheet, and rename the new sheet Formulas. On the Formulas worksheet, select Landscape orientation and the options to print gridlines and headings Delete the question and answer sec tion on the Formulas sheet DISCOVER H m. Open the Excel Options dialog box while displaying the Formulas worksheet. In the Advanced category, under Display options for this worksheets, select the show formulas in cells instead of their calculated results check box. This option will make sure the active worksheet will display the formulas when you open the workbook again. The Rental Rates worksheet will continue show- ing the results. Adjust column widths so that the data will fit on one page. n. Save and close the file and submit based on your instructor's directions ZOOM + ns Fuations Beachfront Guest House Effective May 1, 2016 Peak Rentals Off-Peak Rentals Rental Type No. Units Per Day Maximum 1 Per Day Maximum I Discount Rate Studio Apartment 6 149.95 112.5 1 Bedroom Suite 4 250.45 174 2 Bedroom Suite 2 450 247.55 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? (2) Which rental type generates the most maximum revenue for off-peak rental periods? (3) Why is there a difference? (4) How much would the 2 Bedroom Suite off-Peak per day rate need to be to have the same off- hp . 2 Guest House Rental Rates ANALYSIS You manage a teach guest house in Pt Lauderdale containing three types of rental units. Prices are CASE each rental type, assuming all units are rented. In addition, you need to calculate the discount rate for off peak rental times. Finally , you will improve the appearance of the worksheet by applying font, alignment, and number formats a. Open colm Rentals and save it as eO m2 Rentals LastFirst. b. Merge and center Peak Rentals in the range C4D4, over the two columns of peak rental data, Apply Dark Red fill color and White Background I font color c. Merge and center of Peak Rentals in the range B4:G4 over the three columns of off peak rental data. Apply Blue fill color and White Background I font color d. Center and wrap the headings on row 5. Adjust the width of columns Dand F, if needed. Center the data in the range B6:38 e. Create and copy the following formulas Calculate the Peak Rentals Maximum Revenue by multiplying the number of units by the peak rental price per day Calculate the Off Peak Rentals Maximum Revenue by multiplying the number of units by the off peak rental price per day. Calculate the Discount rate for the Off-Peak rental price per day. For example, using the peak and off-peak per day values, the studio apartment rents for 75% of its peak rental rate. However, you need to calculate and display the off peak discount rate, which is 24975 f. Format the monetary values with Accounting Number Format, Format the Discount Rate for mula results in Percent Style with one decimal place. 9. Apply Blue, Accent 1. Lighter 80% fill color to the range E5:68 DISCOVER B . Select the range C5:08 and apply a custom color with Red 242, Green 220, and Blue 219. * 1. Answer the four questions below the worksheet data. If you change any values to answer the ques. tions, change the values back to the original values j. Set 1" top, bottom, left and right margins Center the data horizontally on the page. k. Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side 1. Create a copy of the Rental Rates worksheet place the new sheet to the right side of the original worksheet, and rename the new sheet Formulas. On the Formulas worksheet, select Landscape orientation and the options to print gridlines and headings Delete the question and answer sec tion on the Formulas sheet DISCOVER H m. Open the Excel Options dialog box while displaying the Formulas worksheet. In the Advanced category, under Display options for this worksheets, select the show formulas in cells instead of their calculated results check box. This option will make sure the active worksheet will display the formulas when you open the workbook again. The Rental Rates worksheet will continue show- ing the results. Adjust column widths so that the data will fit on one page. n. Save and close the file and submit based on your instructor's directions