In this exercise, you’ll use database software to analyze the reservation transactions for a hotel and use that information to fine-tune the hotel’s business strategy and marketing activities.

 

In MyMISLab™, you’ll find a database for hotel reservation transactions developed in Microsoft Access with information about The President’s Inn hotel in Cape May, New Jersey. At the Inn, 10 rooms overlook side streets, 10 rooms have bay windows with limited views of the ocean, and the remaining 10 rooms in the front of the hotel face the ocean. Room rates are based on room choice, length of stay, and the number of guests per room. Room rates are the same for one to four guests. Fifth and sixth guests must pay an additional $20 per person per day. Guests staying for seven days or more receive a 10 percent discount on their daily room rates. The owners currently use a manual reservation and bookkeeping system, which cannot provide management with immediate data about the hotel’s daily operations and revenue. Use the database to develop reports on the average length of stay per room type, average visitors per room type, base revenue per room (i.e., length of visit multiplied by the daily rate) during a specified period of time, and strongest customer base. 

After answering these questions, write a brief report about the Inn’s current business situation and suggest future strategies.

Guest First Name Guest Last Nam- Barry 2 Michael 3 Kim 4 Edward 5 Thomas 6 Paul 7 Randall 8 Calvin 9 Homer 10 David 11 Buster 12 Julia 13 Samuel 14 Arthur 15 Darlene 16 Carlyle 17 Albert 18 Charlene 19 Everett 20 Gerald 21 Jamal 22 Louis 23 Nigel 24 Peter 25 Ronald 26 Trista 27 Valerie 28 Walter 29 Xavier 30 Zachary *ew) L Lloyd Lunsford Kyuong Holt Collins Bodkin Battenburg Nowotney Gonzalez Sanchez Whisler Martines Kim Gottfried Shore Charleston Goldstone Tilson Chad Pittsfield Smith Paris Stratford Willington Cartier Leven Snell Acton Trezza Miller Room Hayes Cleveland Coolidge Washington Lincoln Coolidge Washington Lincoln Lincoln Jefferson Jackson Van Buren Madison Roosevelt Tyler Jackson W Room Typ Bay-window Ocean Adams Polk Reagan Truman Garfield Arthur Quincy Adams Bay-window Johnson Ocean Bay-window Ocean Ocean McKinley Washington Bay-window Ocean Ocean Bay-window Ocean Ocean Ocean Bay window Ocean Bay-window Bay-window Ocean Eisenhower Ocean Ocean Side Side Ocean Grant Jefferson Bay-window Eisenhower Ocean T Bay-window Side Side Ocean Find Window Arrival Da Departure Da No of Gues - Daily Ral - 12/1/2015 12/4/2015 2 $150.00 12/1/2015 3 $112.50 12/4/2015 $150.00 12/1/2015 4 $325.00 12/9/2015 12/13/2015 2 $300.00 12/1/2015 12/3/2015 2 $150.00 12/4/2015 12/12/2015 12/2/2015 12/4/2015 12/5/2015 12/7/2015 12/5/2015 12-7/2015 12/5/2015 12/8/2015 12/10/2015 12/15/2015 12/20/2015 12/9/2015 12/7/2015 12/3/2015 12/30/2015 12/13/2015 12/15/2015 12/24/2015 12/31/2015 12/3/2015 12/6/2015 12/5/2015 12/7/2015 12/5/2015 12/7/2015 12/10/2015 12/14/2015 12/5/2015 12/7/2015 12/20/2015 12/10/2015 12/14/2015 12/19/2015 12/24/2015 12/17/2015 12/3/2015 12/24/2015 12/14/2015 12/13/2015 12/23/2015 12/14/2015 12/16/2015 12/21/2015 12/28/2015 12/20/2015 12/6/2015 12/31/2015 12/17/2015 12/16/2015 11 220 Text Formatting Click 2 $292.50 1 $300.00 5 $320.00 $175.00 $250.00 $150.00 1 3 $112.50 2 $125.00 5 $198.00 2 $150.00 3 $250.00 1 $150.00 2 $275.00 2 $275.00 2 $150.00 1 $250.00 2 $200.00 1 $200.00 4 $175.00 1 $200.00 1 $150.00 6 $148.50 $125.00 $325.00 $0.00 5224