Chapter 3, Problem 18PE

Create a useful dashboard for the data in the Excel file President’s Inn Guest Database. Use the additional information stated in Problem 20 of Chapter 2: 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. Use appropriate charts and layouts and other visualization tools that help to convey the information. Explain why you chose the elements of the dashboard and how a manager might use them.