Build a conceptional model for a Hotel Management System. The solution should be presented as an ER-diagram. Base your design on the following requirements.

• The database should record information about Customer, Hotel, Booking, Rooms, Employee, Feedback, and Payments.

• A Customer has a name which consists of firstName, middleName and lastName. Customers are identified by a unique customerID. A Customer has an Address, phoneNo and email address – Customers can place any number of Bookings (including none). Customer may provide Feedback for each Booking they have placed (optional). For every Booking, a Booking has to make a Payment. Customer is associated with at least one address and multiple customer can live in the same place.

• A Room is identified by its number and has a type, and a description. – Rooms are part of a Hotel.

• A hotel is identified by it is name and address ID and has a stars rating

• A Booking is uniquely identified by a bookingId. A Booking is created by a Customer. For each booking we store a Total Amount of reserved rooms, and a price for room on the booked day, period and a Date. – A Booking is associated with one or more Rooms. For each Room in a Booking, we have to record how many of the Room type is reserved for the stay, for example (2 Queen, 1 king bedroom and a suite). A booking is a made at one hotel, some hotels may not have any booking.

• Employee is identified by an employee number. An employee works in one or more hotels. An employee has a name and address and birth year. In each hotel you have a permanent employee taking a yearly salary and temporary employee working on hourly rates.

• An Address consists of a unique addrID, street and has streetNumber, city, state and zipcode. The attributes city and state can be derived from the attribute zipcode. – There may be some Addresses which are not be associated with any Customer or Hotel.

• A Payment is identified by the Booking for which the payment was made. It consists of the amountPaid and paymentMethod (Credit Card, E-Check, etc.

A park claims that the average number of visitors per day is about 85. We monitor the park on 6 random days and find the following number of visitors on these days: 46, 79, 73, 90, 80, 55 Can we conclude at ? = 0.05 that the mean number of visitors per day in general is different from 85?

A survey of 1465 people who took trips revealed that 135 of them included a visit to a theme park. Based on those survey results, a management consultant claims that less than 10 % of trips include a theme park visit. Test this claim using the α=0.05 significance level.

The test statistic is
The PP-value is

A survey of 1375 people who took trips revealed that 125 of them included a visit to a theme park. Based on those survery results, a management consultant claims that less than 10 % of trips include a theme park visit. Test this claim using the α=0.01 significance level. The test statistic is The critical value is

Self-check-in and self-check-out saves guests time and can be very appealing to them, however, some hotels believe that guests prefer to interact with hotel staff during their registration and departure. Discuss your position on this matter and how your perspective may change depending on the type of hotel or type of guest involved.

This is for a hotel project. The first phase is a restaurant and the 2nd phase is the hotel. It will be located on a small island in the Caribbean in the United States Virgin Islands.

1. Vision statement
2. Mission statement
   1. Product line or services provided
   2. Philosophy of the business
3. The business and its environment
   1. General environment characteristics
   2. Industry environment and competition
   3. Location description
4. Distinctive competencies

Company X is calculating its WACC. The firm’s common stock just paid a dividend of $4.5 per share and now is selling for $80. The firm’s financial staff estimates the company’s new product will generate a dividend growth rate of 7%. Today the firm issued 7000 bonds that will mature in 15 years with $1,000 face value. These bonds will pay a 9% coupon rate quarterly and are currently selling for $970. The firm has 100K preferred shares of stock outstanding with a book value of $45, but currently selling for $55 per share. The last preferred dividend payments were $3.5 per share. The firm’s tax rate is 40%. The firm has 200K shares of common stock outstanding with the same book value as that of its preferred stock.

Calculate the book value weights for each source of capital.
Calculate the market value weights for each source of capital.
Calculate the before-tax and after tax componenet cost of capital
Determine the after tax weighted average costs of capital using both market and the book value weights.

January 2010, Giant Green Company pays $3,400,000 for a tract of land with two buildings on it. It plans to demolish Building 1 and build a new store in its place. Building 2 will be a company office; it is appraised at $782,000, with a useful life of 25 years and a $79,000 salvage value. A lighted parking lot near Building 1 has improvements (Land Improvements 1) valued at $440,500 that are expected to last another 18 years with no salvage value. Without the buildings and improvements, the tract of land is valued at $2,420,600. Giant Green also incurs the following additional costs:

What is the amount that should be recorded for Land?

a) A manager of a firm in the area of Dukagjini region is considering to knocking down the old barn to provide much needed parking space for tractors and equipment. This project would require an immediate expense of £110,000 to remove the asbestos and to knock down the barn. Building the car park would then cost £17,000. The space created would have spare capacity, which will be rented out at £45,000 (pre-tax) per year for parking and other uses. This project also lasts five years and has no residual value at the end. The farmer is able to depreciate the total cost of removing the asbestos, knocking down the building and building the car park. This is done over the five years of the project using the straight-line method. The corporate tax rate is 28%. The nominal discount rate is 3% and all cash flows are nominal values. . At the moment the farmer is paying £3,000 per year (post-tax) to park these on a neighbour’s land.

Calculate the net present value of this project.

b) An alternative is to expand its production capacities. The only possible location is an old barn owned by the farm but not utilised because of asbestos contamination. For legal reasons the building cannot be sold or leased. At a cost of £2,000, the farmer hired an environmental expert, who produced a report with detailed plans for the removal of the asbestos in compliance with environmental regulations. To refurbish the barn—including removing the chemical substances it is expected to cost £350,000. The cheesemaking equipment costs £150,000. Starting at the end of year one, cheese production is expected to yield £170,000 yearly for five years in pre-tax revenue minus cash expenses. The firm depreciates the refurbishment cost and the cost of the cheese-making equipment over the five years of the project using the straight-line method. There is no residual value at the end of the project. The corporate tax rate is 28%. The nominal discount rate is 7% and all values are nominal values.

Calculate the net present value of this project.

c) The farmer asks for your advice on how to choose between the two projects using the information in Parts (a) and (b. What would be your advice to the farmer? Explain.

d) Why might it be appropriate to use different discount rates for different projects, such as those in Parts (a) and (b)? Briefly explain.

Saving the Glaciers

The glaciers have been disappearing from Glacier National Park in Montana and adjoining Waterton National Park in Canada. In 1850, Glacier is said to have had 150 glaciers; in 2006 there were 27. In response to this trend, various organizations petitioned for the parks to be designated endangered by being placed on the danger list of the World Heritage Committee. As one report says,

Endangered status would require the World Heritage Committee to find ways to mitigate how climate change affects the park, [the law professor who wrote the petition] said . . . Better fuel efficiency for automobiles and stronger energy efficiency standards for buildings and appliances are among the ways to reduce greenhouse pollution that contributes to warming, the petition [said].

But some denounced the petition as unnecessary and unsupported by scientific data, while one group of scientists estimated that if climate trends continue, Glacier Park’s glaciers will disappear completely by 2030.

Justify your answers: Suppose the glaciers’ melting would have no appreciable effect on the environ- ment except that they would no longer exist. Would conservationists still be justified in trying to save the glaciers? If so, how could they justify their efforts? If not, why not? Suppose the glaciers could be saved only if the government spends $10 billion on pollution controls—money that would have to be taken away from social programs. Would this cost be worth it? Why or why not? Using the utilitarian Theory