Question: The Excel file Presidents Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate

The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed and breakfast inn during one month. 4 Room rates are the same for one or two guests; however, additional guests must pay an additional $ 20 per person per day for meals. Guests staying for seven days or more receive a 10% discount. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.

Step by Step Solution

★★★★★

3.46 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Presidents Inn Guest Database Additional Fee Per Guest Discount after 6 days 2000 10 per day ID Guest First Name Guest Last Name Room Room Type Arriva... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

607-B-B-C-B-M (612).xlsx

300 KBs Excel File

Students Have Also Explored These Related Business Communication Questions!

For the Presidents Inn Guest Database file, find the average length of stay and number of guests. Is there any correlation between the size of the party and the length of stay?

Apply the Data Validation tool to the Presidents Inn Guest Database file with an error alert message box to ensure that dates are in the month of December and correctly entered, and that the number...

The Excel file Credit Risk Data provides a database of information about loan applications along with a classification of credit risk in column L. Convert the categorical data into numerical codes as...

The Excel file Presidents Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn...

3. The Excel file Presidents Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn...

Assignment 1 The President's Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn...

(Can U see the Excel attached file?, cos it seems its only picture that can be attached). If so, send me an email address so I can send Excel file). Assignment 1 The President's Inn Guest Database...

1 The Presidents Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one...

A company has the following cash transactions during the year: a. Purchases inventory b. Issues long-term debt c. Purchases a building d. Sells common stock to investors e. Pays an account payable...

2. Ken Soree is the CEO of Black Bear, Inc. Although this firm was only recently incorporated, Ken's firm is already struggling. Among the firm's many problems, Ken notes that 1) customer demand is...

Which of these terms is a permitted feature for a High Cost Home Loan? Term of less than 1 5 years Negative amortization Provision to increase the interest rate if the borrower defaults on the loan...

Consecutive five-year balance sheets and income statements of Laura Gibson Corporation are shown below and on the following page. Required a. Compute the following for the years ended December 31,...

Using the base case data in question 10, analyze how the value of a loyal customer (VLC) will change if the average customer defection rate varies between 15 and 40 percent (in increments of 5...

What is the average defection rate for grocery store shoppers in a local area of a large city if they spend $45 per visit, shop 52 weeks per year, the grocery store has a 8 percent gross margin, and...

Gold Stock Market average return 8% 20% standard deviation 25% 22% Your estimate of the assets' correlation is -0.4. 12. What is the average return of a portfolio composed of equal proportions of...

You have just been assigned to a new manager who believes you have exceptional budgeting skills. Since you began your job last summer, you have been showing management your latest spreadsheets and...

Consider a box with 5 tickets, numbered from 1 to 5. We will draw 200 times with replacement from this box. (a) The expected value of the sum of draws is ___________ and the standard error is...