User Account

All Pages

Calculate the maximum daily revenue for each rental type

Assignment Help Basic Computer Science
Reference no: EM132019797

EX16_XL_CH01_GRADER_ML1_HW - Guest House Rental Rates 1.3

Project Description:

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.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step Instructions

1 Start Excel. Download and open the file named e01_grader_h2.xlsx.

2 Apply the Heading 1 cell style to the range A1:G1.

3 Apply the 20% - Accent1 cell style to the range A2:G2.

4 Merge and center Off-Peak Rentals in the range E4:G4.

5 Apply Blue fill color (the eighth color below Standard Colors) and White, Background 1 font color to the cell E4.

6 Center and wrap the headings on row 5.

7 In cell D6, enter a formula that calculates the Peak Rentals Maximum Revenue by multiplying the No. Units by the Per Day value.

8 In cell G6, enter a formula that calculates 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 80% of its peak rental rate. However, you need to calculate and display the off-peak discount rate, which is .19973.

9 Copy the formula in cell D6 to cells D7:D8. Copy the formula in cell G6 to cells G7:G8.

10 Format the range C6:F8 with Accounting Number Format.

11 Format the range G6:G8 in Percent Style with one decimal place.

12 Apply Blue, Accent 1, Lighter 80% fill color to the range E5:G8.

13 Select the range C5:D8 and apply a custom fill color with Red 242, Green 220, and Blue 219.
Note, Mac users, in the Colors dialog box, click the Color Sliders tab and then select the RGB Sliders.

14 Answer the first question below the worksheet data. Apply Yellow highlight color to the correct answer in either cell A16, A17, or A18.

15 Answer the second question below the worksheet data. Apply Yellow highlight color to the correct answer in either cell A22, A23, or A24.

16 Answer the third question below the worksheet data. Change XX.X% to the correct percentage in cell A28.

17 Select Landscape orientation, center the data horizontally on the page, and apply the setting to fit to one page.

18 Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side.

19 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 as Formulas.

20 On the Formulas worksheet, display cell formulas, and set options to print gridlines and headings.

21 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Rental Rates, Formulas. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

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%.

Attachment:- Instructions.zip

Verified Expert

The task of the assignment is to format the provided excel file to suit its requirements. Its requirement includes applying heading style to cell, changing the style of the cells, merge some cells, apply colors to the cells. Computing formulas to calculate the maximum peak rentals and for determining the discount rate. The assignment also requires to change the page layout of the excel sheet on printing and insert header and footer for the excel.

Reference no: EM132019797

Questions Cloud

What is the dollar contribution margin : Question - If sales revenue was 48,840 and variable costs were 43%, what is the dollar contribution margin
Discuss the demands of various writing tasks at malcolm : An assertion regarding how comfortable and confident you are - in general - in approaching and meeting the demands of various writing tasks at Malcolm.
Explain the ethics on the internet and social media : A further exploration of a topic related to our class themes: ethics in a consumer society, and ethics on the internet and social media.
What is the ending work in process inventory balance : Actual manufacturing overhead was $86,500, and jobs costing $225742 were completed during the year. What is the ending work in process inventory balance
Calculate the maximum daily revenue for each rental type : 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
Describe the implications of globalization : Identify at least two ethical issues that go along with the global societal topic you have chosen for your final essay.Explain the implications of globalizatio
What are your reactions to the letter : What are your reactions to the letter? How effectively does the writer of the claim letter present his case? How does his letter align with what you have read.
Was music originally written to make a political statement : Was the music originally written to make a political statement, or did people other than the original artist use it to make political statements.
Find a specific example of a contemporary piece of music : We heard an example of ostinato in world music when we studied the music of the Mbuti people from the Democratic Republic of the Congo.

Reviews

inf2019797

12/21/2018 12:33:40 AM

some excel questions I never realized that I had the full solution to the assignment within 48hrs only after making the payment. I am really surprised because I did not pay any extra payment for such fast delivery. It was just normal pay as regular one. And also there is no compromise with the quality of the work.

Write a Review

Basic Computer Science Questions & Answers

  What are instance variables

What are instance variables

  What is phased implementation

When converting from an old to a new system, we can use a phased implementation approach. a. What is phased implementation?

  Will autonation can continue to be successful

How have they responded to pressures from its competitive environment? How does it provide value to its customers? Do you think AutoNation can continue to be successful?

  Topic-privacy policies

Many countries require organizations that collect personal information to publish a privacy policy that will outline how the company will handle and use this information. Find a copy of the privacy policy for an organization that has asked you to ..

  Draw a network diagram illustrating

Draw a network diagram illustrating how each device would be used to hook up a small network comprised of 5 wired and 5 wireless devices. Be sure to label each device in the diagram

  Write a flow-chart and pseudo-code to solve the following

Write a flow-chart and pseudo-code to solve the following problem:

  Simple model of timing circuit

Timing circuits are a crucial component of VLSI chips. Here's a simple model of such a timing circuit.Consider a complete balanced binary tree with n leaves, where n is a power of two. Each edge e of the tree has an associated length `e, which is ..

  Write an abel program for a combinational logic function

Compile the program and dete1mine the number of product terms needed for each output.

  Calculates the sum of two very long positive integer numbers

Write a method that calculates the sum of two very long positive integer numbers. The numbers are represented as array digits and the last digit (the ones) is stored in the array at index 0. Make the method work for all numbers with length up to 1..

  Convert from an adjacency matrix to adjacency lists

Present correct and efficient algorithms to convert an undirected graph G between the following graph data structures. You must give the time complexity of each algorithm, assuming n vertices and m edges.

  Show the stage that explains what the accumulator represents

Develop an accumulator-style version of how-many, which is the function that determines the number of items on a list. Show the stage that explains what the accumulator represents.

  What happens when the federal reserve buys

Fill in the table below to show what happens when the Federal Reserve buys $200,000 in securities when the reserve rate is 5%.  Use appropriate labels and then explain each step below your entries.  Assume that all excess reserves are loaned out. NEE..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd