Cmis 351 Assignment #1

648 words - 3 pages

Assignment 1: Using a Database for Strategic Business Development


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 ...view middle of the document...

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 income for the hotel at $465.00.

4. The strongest customer base for The Queen’s Inn is 2 visitors per room. Based on the data, the base income is highest when there are 2 guests per room.


The following business strategies might be pursued to increase room occupancy and revenue for the Queen’s Inn.

Advertising: Increase advertising to attract more customers to the hotel. The Queen’s Inn should advertise the hotel and the packages that they are currently offering i.e. the Romantic Package, the Vacation Package, and the Weekday Discount Package. Advertising would generate more awareness of the hotel, leading to increase room occupancy and increased revenue.

Incentive Program: Offer an Incentive Program for frequent/repeat customers. Guest could collect points towards a free stay, a free room upgrade, free parking, etc.

Pricing Strategies: As the supply is fixed at 30 rooms, The Queen’s Inn should increase the Daily Room Rate based on demand/occupancy to increase revenue. I.e. offer a higher Daily Rate per room during peak times (summer). While offering accommodating rates during non-peak times and also focussing on Ocean rooms to generate a higher base income.


In order to provide better information for strategic decisions, the Queen’s Inn could improve their database by capturing additional information relating to the hotel. By adding additional columns to the reservation table (such as the frequency of visits, city of residence, etc.) would help the hotel better understand their customer base. Also, by adding additional tables to the database in order to track expenses (such as water, electricity, internet and cable services, hotel staff, etc.) the Queen’s Inn could view its costs in relation to revenue and determine where is could cut cost in order to maximize profits and operate more efficiently.

Other Essays Like Cmis 351 Assignment #1

Case 2.2 Dell Computer Corp Essay

5933 words - 24 pages percent of total assets and that less than ten percent of total assets are financed through the use of long-term debt for both companies. Solution for Case Assignment [1] Go to Dell’s web site ( and click on the “About Dell” link. Review background and investor information provided about Dell. Click on the “Investor” link in the About Dell section and print and read the most recent SEC Form 10-K provided for Dell. Selected

Ttherapeutic Relationships in Nursing Essay

3731 words - 15 pages decision making tool. I gained informed consent from patient A to carry out the assignment (Appendix. 1), which my tutor witnessed me obtain. My tutor then asked me if I would feel happy to admit patient A and take care of her for the rest of my shift. I was happy to do so. I explained to patient A that she could refuse, if she so wished, but she was happy to go ahead. According to the Nursing and Midwifery Council (2005) students of nursing and

Planning For Professional Development

2135 words - 9 pages tutor. Higher Education, 55, 735-752. doi:10.1007/s10734-007-9093-1 Beutel, D. & Spooner-Lane, R. (2009). Building mentoring capabilities in experienced teachers. International Journal of Learning, 16(4), 351-360. Http:// Ebscohost. Chester, A. (2012). Peer partnerships in teaching: Evaluation of a voluntary model of professional

Change and Cultural Case Study Ii

1957 words - 8 pages employees with the related skills in the appropriate work environments, and do a lot of observations during their analysis of how employees interact with one another, is teamwork or individual task more conducive, and what forms of communication are most effective in assignment of task and completion. According to The American Hospital Association (2008) “The change process starts with identifying a real patient-care service delivery problem

Business Ethics

2969 words - 12 pages - LeBaron, G. & Ayers, A.J. (2013). The Rise of a ‘New Slavery’? Understanding African unfree labour through neoliberalism, Third World Quarterly 34(5), 873-892. 6 - Vandekerckhove, W. (2014). ‘Virtue ethics and management’, in S. Van Hooft (ed) The Handbook of Virtue Ethics. Durham, Acumen, 341-351. Available at: https

SYMPTOMS Signs And Symbolism In Medical Discourse

3824 words - 16 pages through the system, not to remain within it” (Alexander 1982: 351). The social legitimization of disease, the assignment of the sick role, and the abuse of the sick role are all discussed here to illustrate the crucial role that the manifestation and presentation of symptoms play in the cultural legitimization of illness and the process of healing. Culture is a vital element in medicine because it helps determine not only what a

Fetal Alcohol Syndrome - Who Has the Rights?

2171 words - 9 pages Final Essay Assignment - Fetal Alcohol Syndrome: Who has the rights? Sheila Bird COR3100 Critical Thinking and Writing (Section 2) John F. Kennedy University Summer 2014 Fetal Alcohol Syndrome: Who Has The Rights? Who has the rights when an unborn child is involved, mother or child? Can an unborn child be protected from his/her mother? Fetal Alcohol Syndrome [FAS] raises these questions that so far, have not been addressed

Res 351 Syllabus

3192 words - 13 pages | Syllabus School of Business WD11-G2508 RES/351 Version 1 Business Research | Copyright © 2011 by University of Phoenix. All rights reserved. Course Description This course evaluates the process of conducting business research for improving decision making within an organization. Students will learn to apply an understanding of commonly employed business research techniques to improve a situation, solve a problem, or change a process

Intellectual Capital

2756 words - 12 pages Introduction Over the last decade, increasing interest in Intellectual Capital (IC) has been the core factor it is being developed rapidly (Juma and Paine, 2004; Bontis, 2001). IC was first being acknowledged in 1995 by Skandia when it published the world’s first IC yearly report (Edvinsson and Malone, 1997). Definition of Intellectual Capital (IC) There have been tremendously abundant definitions of IC (refer to Appendix 1). In general it

International Scm

3914 words - 16 pages 2014 INTRODUCTION TO SUPPLY CHAIN MANAGEMENT BY – ANUBHAV KANDPAL DIT | 351 October/November 2014 TABLE OF CONTENTS Abstract............................................................................................................................................................................................ 2 Part 1

Proposal Modeling

4285 words - 18 pages means (except for Subpart 31.6) amounts determined on the basis of costs incurred, as distinguished from forecasted costs. Actual costs include standard costs properly adjusted for applicable variances. Allocate means to assign an item of cost, or a group of items of cost, to one or more cost objectives. This term includes both direct assignment of cost and the reassignment of a share from an indirect cost pool. Allowable means a contract cost

Related Papers

Cmis 102 Hw 3 Essay

529 words - 3 pages CMIS 102 Homework Assignment 3 Description: I’ve been tasked to create a program that will allow a user, in this case a teacher, to enter their student names and final grades from their course. The amount of students in the class is an unknown variable, as well as courses completed. This program will be utilized to calculate the Grade Point Average for each student based on their final grades of the courses completed. Analysis: In order for

Data Analysis

4632 words - 19 pages ETF 5912 Assignment Question 1: a) Select a systematic sample of 151 saving accounts. Systematic sample: with N = 2,265, N = 151, K = 2,265/151 = 15 Choose the first element of the sample at random from the first 15 elements of the population. Choose the 6th element. Then choose every 15rd element thereafter: 21th, 36th, 51th, etc. Population size | 2,265 | Sample size | 151 | Sampling interval | 15 | Index | Systematic Sample

Blockbook Entreupreuneurship Essay

3792 words - 16 pages MEETINGS THE MEETINGS: CONTENT AND LITERATURE GUIDELINES ON CASE ANALYSIS AND DISCUSSION THE OPPORTUNITY CREATION ASSIGNMENT EXAM BLOCK ASSIGNMENT 15 16 16 6 7 7 8 9 12 3 4 5 2 Entrepreneurship Theory and Research (EBC4094) 2014/2015 1. INTRODUCTION Entrepreneurship is an important topic for industrialized as well as developing countries, as it is the driving force behind economic growth and rejuvenation all around the world. The fact that

Metronaps Essay

1311 words - 6 pages ACCT 351-002 Research and Writing Assignment #1 Christine Choi A Fair Tax System for a Better Society It is no doubt that the general goal of a government of the people and by the people must set its goal to work for the people, that is to maximize the well-being of society as Abraham Lincoln pointed out in his famous Gettysburg address. To maximize the well-being of society, or to make a better society in which its members live happier