– Choose two hotel brands to use as the base of your assignment and analysis.

– Briefly describe each brand

– Compare and contrast the brands from a business perspective (as if you are considering opening a hotel under that brand or offering consulting services to someone considering opening a hotel). Consider how their fees and franchising works, market position, development process, corporate culture / values, management foundation, and resources available as a franchisee (revenue management, sales/marketing, training) and what the brand is looking for from someone looking to buy-in.

– Describe and explain two new trends these brands have been starting to implement in the last 2 years. Are they using these trends to gain competitive advantage, adapt to changing markets, be more cost effective or conserve resources?

– Based on research and course/program knowledge what would be another trend these hotel brands should consider that they are not doing now? Explain the trend and why you chose it.

– Based on your analysis, research and course content – what are some advantages and disadvantages of choosing a branded/chain hotel over an independent hotel?
1.Briefly describe each brand
A. http://www.hiltonworldwide.com/portfolio/hilton/

B. vision, mission, and values

http://www.hiltonworldwide.com/about/mission/

2. Fees and franchising works
Hilton Worldwide Exceeds Adjusted EBITDA Guidance for Fourth Quarter and Full Year 2014; Optimistic about 2015

http://www.hospitalitynet.org/news/4069110.html

Hilton Hotels & Resorts Franchise Cost & Fees

http://www.franchisedirect.com/travelfranchises/hilton-hotels-resorts-franchise-08360/ufoc/

3. market position (on page 19)

http://www.hiltonworldwide.com/assets/presentations/GlobalWebB2B_DevContent_Hilton_072911.pdf

4.Development process

http://www.hiltonworldwide.com/development/regions/north-america/united-states/delaware/hilton-hotels-and-resorts/development-process.html

5.Corporate culture / values

http://www.hiltonworldwide.com/about/mission/

6.resources available as a franchisee (revenue management, sales/marketing, training)

http://www.managementservices.hilton.com/en/what-we-manage-for-your-business/

7.what the brand is looking for from someone looking to buy-in
Hilton Hotels & Resorts Franchise Cost & Fees?obligations and restrictions?

http://www.franchisedirect.com/travelfranchises/hilton-hotels-resorts-franchise-08360/ufoc/

8. New Trends About Hilton:
A. Hilton Sees Filling Rooms on Weekends as New Trend

http://skift.com/2014/10/31/hilton-sees-filling-rooms-on-weekends-as-new-trend/

B. .Hilton will soon turn your smartphone into your hotel room key

http://www.digitaltrends.com/mobile/hilton-will-soon-turn-smartphone-room-key/

In this assignment, you will use Microsoft Access to generate reports using query. Please pay attention to every criteria when you do the selection. You can get the full credit only if everything is correct (Both the queries and the results). Please show and only show all the attributes listed in brackets in the same order, missing or unexpected attributes or criteria will cause you lose points. Import the data (DBHW1.xls) into MS Access and answer the following questions:

1. Generate a report showing the [order ID, order date, customer name, and the product subcategory] of all high priority orders shipped by express air in the year of 2011. (Hint: representing date: #3/12/2016#)

2. Generate a report showing the [product category, shipping cost, product container, and sales] for the top 5 largest sales (Hint: rank by sales and then only show the top 5).

3. Generate a report showing the [region, customer segment, profit, and shipment mode] for all furniture (product category) items in the region of “Nunavut”.

4. Generate a report showing the total [profits] of technology products (product category) shipped with “critical” and “high” priorities.

5. By using parameter query, generate reports that indicate [sales, profit, customer segment, and product category] for all high priority orders shipped by regular air containing “furniture” and “technology” (product category) with the profit greater than 1000 in home office. (Hint: parameter query for “or”: [] or []).

Submission Instructions

1. Make a screen shot (using snipping tool, alt+ctrl+prt sc, etc.) of each query form.

2. Combine all screen shots and reports into a single PDF file and label it “DB1”.