Concept explainers
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. 4Room rates are the same for one or two guest; however, additional guests must pay an additional $20 per person per day for meals. Guest 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.
4Based on Kenneth C. Laudon and Jane P. Laudon, Essentials of Management Information System.
To calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
Explanation of Solution
Given:
The data consists list of customers, rooms they occupied, arrivaland departure dates, number of occupants, anddaily rate for a small bed-and-breakfast inn duringone month
Formula:
Following is the table which have number of days and total revenue for that days.
ID | Guest First Name | Guest Last Name | Room | Room Type | Number of days | Total revenue |
1 | Barry | Lloyd | Hayes | Bay-window | 3 | $450.00 |
2 | Michael | Lunsford | Cleveland | Ocean | 8 | $900.00 |
3 | Kim | Kyuong | Coolidge | Bay-window | 3 | $450.00 |
4 | Edward | Holt | Washington | Ocean | 2 | $650.00 |
5 | Thomas | Collins | Lincoln | Ocean | 4 | $1,200.00 |
6 | Paul | Bodkin | Coolidge | Bay-window | 2 | $300.00 |
7 | Randall | Battenburg | Washington | Ocean | 8 | $2,340.00 |
8 | Calvin | Nowotney | Lincoln | Ocean | 2 | $600.00 |
9 | Homer | Gonzalez | Lincoln | Ocean | 2 | $640.00 |
10 | David | Sanchez | Jefferson | Bay-window | 2 | $350.00 |
11 | Buster | Whisler | Jackson | Ocean | 3 | $750.00 |
12 | Julia | Martines | Reagan | Bay-window | 5 | $750.00 |
13 | Samuel | Kim | Truman | Side | 10 | $1,125.00 |
14 | Arthur | Gottfried | Garfield | Side | 2 | $250.00 |
15 | Darlene | Shore | Arthur | Ocean | 7 | $1,386.00 |
16 | Carlyle | Charleston | Quincy Adams | Bay-window | 3 | $450.00 |
17 | Albert | Goldstone | Johnson | Ocean | 2 | $500.00 |
18 | Charlene | Tilson | Van Buren | Bay-window | 2 | $300.00 |
19 | Everett | Chad | Madison | Ocean | 4 | $1,100.00 |
20 | Gerald | Pittsfield | Roosevelt | Ocean | 2 | $550.00 |
21 | Jamal | Smith | Tyler | Bay-window | 3 | $450.00 |
22 | Louis | Paris | Jackson | Ocean | 4 | $1,000.00 |
23 | Nigel | Stratford | Eisenhower | Ocean | 2 | $400.00 |
24 | Peter | Willington | Grant | Ocean | 2 | $400.00 |
25 | Ronald | Cartier | Jefferson | Bay-window | 4 | $700.00 |
26 | Trista | Leven | Eisenhower | Ocean | 3 | $600.00 |
27 | Valerie | Snell | Adams | Bay-window | 3 | $450.00 |
28 | Walter | Acton | Polk | Side | 7 | $1,039.50 |
29 | Xavier | Trezza | McKinley | Side | 3 | $375.00 |
30 | Zachary | Miller | Washington | Ocean | 3 | $975.00 |
Want to see more full solutions like this?
Chapter 2 Solutions
Business Analytics (2nd Edition)
- The director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on this information if the company contacts 900 potential donors to donate at the $100 level or below E Click the icon to view the percentages of donors and gift levels. C..... 3 Philanthropist $5,000 11 =B3*C3 4 Producer's Circle $1,000 25 =B4*C4 5 Director's Circle $500 49 =B5 C5 6 Principal $100 8% =B6*C6*$B$9 7 Soloist $50 14% =B7*C7*SB$9 8. 9 Solicitations 900 10 Total Donations =SUM(D2:D7) Enter the values in the model. (Type integers or decimals. Do not round.) B D Average Number of Gifts 1 Gift Level Amount Donations 2 Benefactor $10,000 3 Philanthropist $5,000 11 4 Producer's Circle $1,000 25 5 Director's Circle $500 49 6 Principal $100 8% ns? 7 Soloist $50 14% 8. 9…arrow_forwardThe spreadsheet at MarathonWinningTimes.xlsx shows the history of the winning time in the Boston Marathon for men and women from 1966 (when women first ran) through 2013. What is the average rate at which the men’s finishing time changed from year to year?arrow_forwardSuppose your monthly salary for your first job after graduation is $5,000. And 25% of this monthly salary is taken for federal, state, and local taxes. Yourapartment rent is $800 per month which includes utilities. Other budget categories are savings, food, leisure, and clothing. Allocate the remaining monthly amount as you wish, and create a pie chart showing where your monthly budget goes.arrow_forward
- Find the amounts of Social Security and Medicare for the current pay. For each of the following employees. M. Bell has $583.16 in current gross earnings, and $30,411.18 in year-to -date earnings.arrow_forwardCharity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions. Charity # Charity Total Expenses ($) Administrative Expenses (%) Fundraising Expenses (%) Program Expenses (%) 1 American Red Cross 3355147520 3.8 3.9 92.1 2 World Vision 1200410940 3.8 7.6 88.4 3 Smithsonian Institution 1078888839 23.3 2.6 73.7 4 Food For…arrow_forwardCharity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.arrow_forward
- Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.arrow_forwardTwo cars with the same purchase price are not worth the same amount at the end of the year. Some cars depreciate faster than others. A truck depreciates at 45%45% and a Jeep depreciates at 25%25% per year. Assume the initial purchase price is $19,000.$19,000. Use a spreadsheet to determine how much more the Jeep is worth in three years.arrow_forwardIf a household has 3 members, and has an annual income of $100,000, predict this household’s monthly spending.arrow_forward
- A real estate company owns 120 apartments which are fully occupied when the rent is $700 per month. Analytics indicate that for each $35 increase in rent, 5 apartments will become unoccupied. What rent should be charged in order to obtain the largest gross income?arrow_forwardPlease complete the following. Please show work. Thank you!arrow_forwardUse a graphing calculator to make a scatter plot of the amounts Leah willaccumulate for years 1 through 5.arrow_forward
- Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell