Premium Essay

Cmis 351 Assignment #1

In:

Submitted By lorrietherrien
Words 626
Pages 3
Assignment 1: Using a Database for Strategic Business Development

Situation:

The Queen’s Inn does not have an automated reservation and bookkeeping system which causes inefficiencies and errors in its daily operations. By utilizing Microsoft Access, the Queen’s Inn will be able to manage their daily business more effectively and efficiently, ultimately reducing errors and costs. Employees will be able to create and confirm reservations with little to no errors and management will be able to easily see how the business is doing.

Summary of Results:

1. The average length of stay per room type varies according to the different room types of the hotel. The average length of stay is 3.00 nights in the Bay-Window rooms; 3.63 nights in the Ocean rooms; and 5.50 nights in the Side rooms. Based on this information, there is a correlation between the cost of the room type and the length of stay in a specific room type. Based on the data, hotel guests tend to stay for longer periods of time in the room types that have a lower daily rate i.e. Side room, whereas guests who stay for shorter periods of time (3 nights or less) tend to stay in higher daily rate rooms i.e. Bay-Window room.

2. The average number of visitors per room type fluctuates depending on the corresponding room type. The average number of guests per room type is as follows:

• Bay-Window rooms have an average of 2.25 visitors indicating that it usually reserved by couples or business travelers.
• Ocean rooms have an average of 3.8 visitors indicating that it usually reserved by families.
• Side rooms have an average of 3.25 visitors indicating that it usually reserved by young family.

3. Based on the report: Summary – Base Income per Room Type, Ocean rooms generate the highest base income at $874.44, followed by Side rooms at $697.38, and then by Bay-Window room generating the lowest

Similar Documents

Premium Essay

Cmis 351 Assignment 1 Essay

...Introduction The purpose of this report is to analyze the Queen’s Inn current reservation system and propose a recommendation for management to move towards an automated system that will increase profit, transparency to management on daily operation and to introduce a solid tracking system of their customers promoting efficiency and accuracy by using Microsoft Access. As a result of utilizing automated advanced database entry system like Microsoft Access, users will be able to generate queries and reports based on their own desires without going through circles or complex steps. Using a database querying system, anyone in management of Queen’s Inn will be able to find out how the business is doing on a daily basis, how many rooms are occupied, average length of stay per guest, what is the average base income in a specific timeframe or season, what room type is rented most and it will identify the strongest customer base they have and more. Background of Queens Inn Queen’s Inn, located in St. John’s, Newfoundland is a thirty rooms hotel. It has thirty rooms with various views such as ten that overlooks the side streets, ten that has ocean view and ten with partial ocean view. Guest rates depends on the type of room they stay in, how long they stay in a room, and the number of guests in a room. Rates varies per room, applying discounts or extra charges to a standard rate. With steady growth, and complete renovation, the inn service expanded to attract other...

Words: 2070 - Pages: 9

Free Essay

Advance Case with Ibm Case Manager

...Front cover Advanced Case Management with IBM Case Manager Introducing case management and IBM Case Manager Building IBM Case Manager solutions with use case example Covering customization, rules, deployment, and more Wei-Dong Zhu Brian Benoit Bob Jackson Johnson Liu Mike Marin Seema Meena Juan Felipe Ospina Guillermo Rios ibm.com/redbooks International Technical Support Organization Advanced Case Management with IBM Case Manager May 2014 SG24-7929-03 Note: Before using this information and the product it supports, read the information in “Notices” on page xiii. Fourth Edition (May 2014) This edition applies to Version 5.2.0, IBM Case Manager (product number 5725-A15). © Copyright International Business Machines Corporation 2013, 2014. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contents Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii Trademarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv Authors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv Now you can become a published author, too! . . . . . . . . . . . . . . . . ...

Words: 95119 - Pages: 381

Premium Essay

Market Research Problem

...analyzovat zvolený trh, popř. zvolené trhy, formuluje doporučení pro tvorbu daného produktu a provede ekonomické vyhodnocení jeho zavedení. Použité metody: Analýza sekundárních dat, dedukce, deskripce, komparace, relevantní matematicko-statistické metody. Rozsah grafických prací: Rozsah práce bez příloh: předpoklad cca 15 tabulek a grafů 60 – 70 stran Seznam odborné literatury: BOLDIŠ, P. Bibliografické citace dokumentu podle ČSN ISO 690 a ČSN ISO 690-2 (01 0197): Část 1 – Citace: metodika a obecná pravidla. Verze 3.2 [online]. 1999–2002. Poslední aktualizace 2002-09-03. Dostupné na World Wide Web: HENDL, J. Kvalitativní výzkum – základní metody a aplikace. 1. vyd. Praha : Portál, 2005. 408 s. ISBN 80-7667-040-2. HENDL, J. Přehled statistických metod zpracování dat – Analýza a meta analýza dat. 1. vyd. Praha : Portál, 2004. 584 s. ISBN 80-7178-820-1. KOTLER, P. Marketing management. 10. rozšířené vyd. Praha : Grada, 2001. 719 s. ISBN 80-247-0016-6. TOMEK, G. – VÁVROVÁ, V. Výrobek a jeho úspěch na trhu. 1. vyd. Praha : Grada, 2001. 352 s. ISBN 80-247-0053-0. Vedoucí diplomové...

Words: 33489 - Pages: 134

Free Essay

Ahp and Other

...Li, S.K. Ong, A.Y.C. Nee and C. McMahon (Eds.) R. Venkata Rao Decision Making in the Manufacturing Environment Using Graph Theory and Fuzzy Multiple Attribute Decision Making Methods 123 R. Venkata Rao, PhD Department of Mechanical Engineering Sardar Vallabhbhai National Institute of Technology, Surat Ichchanath Surat 395 007 Gujarat State India British Library Cataloguing in Publication Data Rao, R. Venkata Decision making in the manufacturing environment : using graph theory and fuzzy multiple attribute decision making methods. - (Springer series in advanced manufacturing) 1. Production management - Decision making 2. Graph theory 3. Fuzzy decision making 4. Multiple criteria decision making I. Title 658.5’036 ISBN-13: 9781846288180 Library of Congress Control Number: 2007926809 Springer Series in Advanced Manufacturing ISSN 1860-5168 ISBN 978-1-84628-818-0 e-ISBN 978-1-84628-819-7 Printed on acid-free paper © Springer-Verlag London Limited 2007...

Words: 75183 - Pages: 301

Premium Essay

Daimler-Chrysler Merger Portrayal

...permission of the publisher. Permissions may be sought directly from Elsevier’s Science & Technology Rights Department in Oxford, UK: phone: (+44) 1865 843830, fax: (+44) 1865 853333, e-mail: permissions@elsevier.com.uk. You may also complete your request on-line via the Elsevier homepage (http://elsevier.com), by selecting “Customer Support” and then “Obtaining Permissions.” Recognizing the importance of preserving what has been written, Elsevier prints its books on acid-free paper whenever possible. Library of Congress Cataloging-in-Publication Data Rao, Madanmohan. KM tools and techniques : practitioners and experts evaluate KM solutions / Madanmohan Rao. p. cm. Includes bibliographical references and index. ISBN 0-7506-7818-6 (alk. paper) 1. Knowledge management. 2. Organizational learning. 3. Knowledge management—Data processing. 4. Management information systems. 5. Information resources management. 6. Database management. I. Title Knowledge management tools and techniques. II. Title. HD30.2.R356 2004 658.4¢038—dc22 2004050698 British Library...

Words: 182966 - Pages: 732

Premium Essay

Leadership Development - Doe

...Leadership Development Seminars and ECQ-based Readings The success or failure of any endeavor depends on leadership. Now, more than ever before, we need leaders in our organizations and in our world. Great leaders create and communicate a vision and move people into action to achieve it. They ignite our passion and inspire us to do our best. Government leaders in the 21st century are experiencing change at a more rapid pace than previous generations. Rapid advances in technology have expanded the quantity of work we are capable of accomplishing, and also where it’s accomplished. We have a more highly educated workforce, yet face diminishing resources with an increased demand for productivity, and the essential services we provide to the American public. To be successful at navigating these challenges leaders must develop the essential skills to motivate their employees, effectively communicate with others, fine-tune critical thinking skills, and build and leverage partnerships. Future leaders must also be visionary; i.e., possess the ability to identify trends and the courage to be innovative. Being technically adept in your field will no longer be enough. In response to these demands on senior executives, the U.S. Office of Personnel Management identified five Executive Core Qualifications (ECQs) that all aspiring government leaders and executives must possess. These ECQs and Fundamental Competencies were developed by OPM after extensive research on the attributes...

Words: 181771 - Pages: 728

Premium Essay

Career Planning

...Leadership Development Seminars and ECQ-based Readings The success or failure of any endeavor depends on leadership. Now, more than ever before, we need leaders in our organizations and in our world. Great leaders create and communicate a vision and move people into action to achieve it. They ignite our passion and inspire us to do our best. Government leaders in the 21st century are experiencing change at a more rapid pace than previous generations. Rapid advances in technology have expanded the quantity of work we are capable of accomplishing, and also where it’s accomplished. We have a more highly educated workforce, yet face diminishing resources with an increased demand for productivity, and the essential services we provide to the American public. To be successful at navigating these challenges leaders must develop the essential skills to motivate their employees, effectively communicate with others, fine-tune critical thinking skills, and build and leverage partnerships. Future leaders must also be visionary; i.e., possess the ability to identify trends and the courage to be innovative. Being technically adept in your field will no longer be enough. In response to these demands on senior executives, the U.S. Office of Personnel Management identified five Executive Core Qualifications (ECQs) that all aspiring government leaders and executives must possess. These ECQs and Fundamental Competencies were developed by OPM after extensive research on the attributes...

Words: 181771 - Pages: 728

Premium Essay

Book

...circumstance”……………………………………...Bowley. STRUCTURE: 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 Introduction Meaning and Definitions of Statistics Types of Data and Data Sources Types of Statistics Scope of Statistics Importance of Statistics in Business Limitations of statistics Summary Self-Test Questions Suggested Readings 1.1 INTRODUCTION For a layman, ‘Statistics’ means numerical information expressed in quantitative terms. This information may relate to objects, subjects, activities, phenomena, or regions of space. As a matter of fact, data have no limits as to their reference, coverage, and scope. At the macro level, these are data on gross national product and shares of agriculture, manufacturing, and services in GDP (Gross Domestic Product). 1 At the micro level, individual firms, howsoever small or large, produce extensive statistics on their operations. The annual reports of companies contain variety of data on sales, production, expenditure, inventories, capital employed, and other activities. These data are often field data, collected by employing scientific survey techniques. Unless regularly updated, such data are the product of a one-time effort and have limited use beyond the situation that may have called for their collection. A student knows statistics more intimately as a subject of study like economics, mathematics, chemistry, physics, and others. It is a discipline, which scientifically deals with data,...

Words: 134607 - Pages: 539

Premium Essay

Paper

...ended December 31, 2010 or Transition report pursuant to Section 13 or 15(d) of the Securities Exchange Act of 1934 For the transition period from Commission File Number 1-87 to EASTMAN KODAK COMPANY (Exact name of registrant as specified in its charter) NEW JERSEY (State of incorporation) 343 STATE STREET, ROCHESTER, NEW YORK (Address of principal executive offices) Registrant’s telephone number, including area code: __________________________ Securities registered pursuant to Section 12(b) of the Act: Title of each Class Common Stock, $2.50 par value Securities registered pursuant to Section 12(g) of the Act: None Indicate by check mark if the registrant is a well-known seasoned issuer, as defined in Rule 405 of the Securities Act. Yes [X] No [ ] Name of each exchange on which registered New York Stock Exchange 16-0417150 (IRS Employer Identification No.) 14650 (Zip Code) 585-724-4000 Indicate by check mark if the registrant is not required to file reports pursuant to Section 13 or Section 15(d) of the Act. Yes [ ] No [X] Indicate by check mark whether the registrant (1) has filed all reports required to be filed by Section 13 or 15(d) of the Securities Exchange Act of 1934 during the preceding 12 months, and (2) has been subject to such filing requirements for the past 90 days. Yes [X] No [ ] 1 Indicate by check mark whether the registrant has submitted electronically and posted on its corporate Website, if any, every Interactive Data File required to be submitted...

Words: 115418 - Pages: 462

Premium Essay

Well Done Bp

...by the Depositary to the issuer Called-up share capital Administration Annual general meeting Exhibits BP Annual Report and Form 20-F 2010 83 Directors and senior management 84 87 Directors and senior management Directors’ interests 89 Corporate governance 90 105 106 106 107 108 Board performance report Corporate governance practices Code of ethics Controls and procedures Principal accountants’ fees and services Memorandum and Articles of Association 141 Financial statements 142 Consolidated financial statements of the BP group 150 Notes on financial statements 228 Supplementary information on oil and natural gas (unaudited) PC1 Parent company financial statements of BP p.l.c. 111 Directors’ remuneration report 112 Part 1 Summary 114 Part 2 Executive directors’ remuneration 120 Part 3 Non-executive directors’ remuneration UNITED...

Words: 215326 - Pages: 862