You manage a beach guest house in Ft. Lauderdale containing three types of rental units. Prices...

 

Transcribed Image Text:

You manage a beach guest house in Ft. Lauderdale containing three types of rental units. Prices are based on peak and off-peak times of the year. You need to calculate the maximum daily revenue for 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 e01m2Rentals and save it as e01m2Rentals_LastFirst. b. Merge and center Peak Rentals in the range C4:D4, over the two columns of peak rental data. Apply Dark Red fill color and White, Background 1 font color. c. Merge and center Off-Peak Rentals in the range E4:G4 over the three columns of off-peak rental data. Apply Blue fill color and White, Background 1 font color. d. Center and wrap the headings on row 5. Adjust the width of columns D and F, if needed. Center the data in the range B6:B8. 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. g. Apply Blue, Accent 1, Lighter 80% fill color to the range E5:G8. h. Select the range C5:D8 and apply a custom color with Red 242, Green 220, and Blue 219. i. Answer the four questions below the worksheet data. If you change any values to answer the que 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 na code on the right side. 1. Create a copy of the Rental Rates worksheet, place the new sheet to the right side of the orig worksheet, and rename the new sheet Formulas. On the Formulas worksheet, select Lands orientation and the options to print gridlines and headings. Delete the question and answer tion on the Formulas sheet. m. Open the Excel Options dialog box while displaying the Formulas worksheet. In the Adva category, under Display options for this worksheet:, select the Show formulas in cells inste their calculated results check box. This option will make sure the active worksheet will d the formulas when you open the workbook again. The Rental Rates worksheet will continue 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. You manage a beach guest house in Ft. Lauderdale containing three types of rental units. Prices are based on peak and off-peak times of the year. You need to calculate the maximum daily revenue for 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 e01m2Rentals and save it as e01m2Rentals_LastFirst. b. Merge and center Peak Rentals in the range C4:D4, over the two columns of peak rental data. Apply Dark Red fill color and White, Background 1 font color. c. Merge and center Off-Peak Rentals in the range E4:G4 over the three columns of off-peak rental data. Apply Blue fill color and White, Background 1 font color. d. Center and wrap the headings on row 5. Adjust the width of columns D and F, if needed. Center the data in the range B6:B8. 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. g. Apply Blue, Accent 1, Lighter 80% fill color to the range E5:G8. h. Select the range C5:D8 and apply a custom color with Red 242, Green 220, and Blue 219. i. Answer the four questions below the worksheet data. If you change any values to answer the que 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 na code on the right side. 1. Create a copy of the Rental Rates worksheet, place the new sheet to the right side of the orig worksheet, and rename the new sheet Formulas. On the Formulas worksheet, select Lands orientation and the options to print gridlines and headings. Delete the question and answer tion on the Formulas sheet. m. Open the Excel Options dialog box while displaying the Formulas worksheet. In the Adva category, under Display options for this worksheet:, select the Show formulas in cells inste their calculated results check box. This option will make sure the active worksheet will d the formulas when you open the workbook again. The Rental Rates worksheet will continue 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.