Create an excel spreadsheet that indicates the rental type

Assignment Help Computer Engineering

Reference no: EM13462259

You manage a B & B in Vail, Colorado, which has three 1 bedroom suites and two 2 bedroom suites. The 1 bedrooms rent for $200/day in season, and for $120/day during the off peak season. The 2 bedrooms lease at $350/day and $250/day, in season and off peak, respectively. Be sure to use functions, so that the number of bedrooms and prices can be changed.

Create an Excel spreadsheet that indicates the rental type, the number of units, the rental rates per day per unit type, the maximum revenue per day from each rental type, and the off peak discount rate.

Include a header that has been merged and centered titled B & B Rental Summary in blue and bold, and today's date in italics on a second merged and centered line.. Highlight the 1 bedroom titles in red, and the 2 bedroom titles in blue. Fill the 1 bedroom figure with a lighter red 60% Accent 2 fill colour, and the 2 bedroom with a 40% Accent 1blue fill colour.

Set it to print in the Landscape orientation, and make sure that the gridlines will show.

Reference no: EM13462259

Questions Cloud

Must be written in apa format with any and all sources : develop a 350- to 700-word synopsis with the following elementa description of how a specific business requirement

Describe a situation where a traditional relational : 1.describe a situation where a traditional relational database management system would not be suitable and you would

Explain the concept of an information system as if you : write an 800 word response to this questionexplain the concept of an information system as if you were teaching it to

Provide a threenbspto five page proposal summarizing : using the case studynbsppresentednbspin this documentnbspto complete an executive proposal.provide a threenbspto five

Create an excel spreadsheet that indicates the rental type : you manage a b amp b in vail colorado which has three 1 bedroom suites and two 2 bedroom suites. the 1 bedrooms rent

Apple inc is known for its state-of-the-art designs for : apple inc. is known for its state-of-the-art designs for products such as the iphone but most are unaware that apple

In the decision making process modeling is sometimes a key : in the decision making process modeling is sometimes a key enabler. our tenth discussion thread will focus on the

During a whole class discussion describe the association : during a whole class discussion describe the association between information systems and the concept of competitive

You are not being given an instruction file with the code : to accomplish this task you will be utilizing the following java classes methods in the character class and

User Account

All Pages