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)
- Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell