Molly Mackenzie Boat Marina
Page 1
Molly Mackenzie Boat Marina
CASE BACKGROUND
Marvin and Dena Mackenzie own and operate the Molly Mackenzie Marina. Currently, data about the
marina's daily operating activities are manually captured and processed. When necessary, reports are
created using a word processing package. As the marina continues to grow, Mr. and Mrs. Mackenzie
recognize the necessity of using information technology to capture details about the marina's daily operations,
as well as facilitate decision-making activities. Mr. and Mrs. Mackenzie need a database to track information
about customer reservations, customer payments, and the marina's rental properties. Mr. and Mrs. Mackenzie
hire you to build the database. Building the database requires you to develop forms and subforms, reports,
queries, and a switchboard. The forms will utilize buttons to facilitate data navigation. Once the database is
developed, Mr. Mackenzie will export selected data from the marina database to a spreadsheet for further
analysis. Mr. Mackenzie will use the Subtotals function, PivotTable, Solver, and charting tools to analyse the
data.
CASE SCENARIO
The Molly Mackenzie Marina and its surrounding property are located on Lake Merewether in the Midwest.
Lake Merewether is a popular tourist spot, attracting visitors year round. The lake's notoriety is due to its
beautiful surroundings, camping facilities, excellent fishing, and ability to handle large boats. Lake visitors are
primarily local, but many visitors come from across the nation. Lake Merewether is situated between two large
cities, serving as a weekend getaway for many of its visitors.
Mr. Mackenzie uses a manual-based information system to manage the marina's rental property. However,
he realizes that automating the marina's daily operations will make his management activities more efficient.
Mr. and Mrs. Mackenzie spend numerous hours keeping the marina's paperwork up to date. The marina's
popularity continues to grow, and Mr. Mackenzie is quickly realizing the necessity of using information
technology to ease the marina's paperwork burden. In an effort to run the office in a more efficient manner,
Mr. Mackenzie hires you to design a marina database and worksheet for him. Since you have worked as a
part-time marina employee, you are familiar with the marina's daily operations and are eager to help.
The Molly Mackenzie Marina rents cabins, a variety of watercraft, and boat slips to its customers. When a
customer requests a watercraft or a cabin, a price quote is given. The price quote is based on a daily rate. If a
customer wants to rent a jet ski for a half day, then the daily rate is adjusted. Likewise, if a customer rents a
cabin or boat slip for more than a day, Mr. Mackenzie will discount the daily rate, making a longer stay more
attractive. Cabins can be rented for a weekend, week, or month at a reduced rate. Table 1 shows the discount
codes and their associated percentage discounts. If a customer rents a jet ski for a half day, Mr. Mackenzie
will charge the person 65 percent of the daily rate. If a person rents a boat slip for 180 days, Mr. Mackenzie
will reduce the daily rate by 15 percent.
评论0