Project Outcomes:
Develop a python program that uses:
 decision constructs
 looping constructs
 basic operations on an list of objects (find, change, access all elements)
 more than one class and has multiple objects
Project Requirements:
1. Develop a simple Hotel program. We will have two classes, a Hotel class
representing an individual hotel and a Room class. The Hotel class will contain several
Room objects and will have several operations. We will also have a driver program to test
the Hotel class.
2. Build a Hotel class that will store information about a Hotel. It will include a name and
location. It should also include a list of class Room to hold information about each
room. It will also have a int called occupiedCnt that keeps track of how many rooms in
the hotel are occupied.
Specific Requirements for the Hotel Class:
1. The Hotel class has two constructors
1. __init__ function, will read in the hotel name and location from hard-coded
values in the tester class, such as Beach Marriot Pensacola, it will also assign
numOfRooms to zero.  numOfRooms indicates how many rooms are in the hotel.
It will create a 10 element array.

2. The Hotel will have an addRoom method that will create each room with the required
information: room number, bed type, smoking/non-smoking, and the room rate. Create at
least 5 rooms with different characteristics. Each room will also have a boolean field
called occupied attribute that will be set to false when the room is created. Don't forget
to increment the numOfRooms instance variable.  Example values for the rooms are:
101 queen s 100
102 king n 110
103 king n 88
104 twin s 100
105 queen n 99
3. The UML class diagram for the Hotel class will look like this:

Hotel

theRooms: Array Room[]
name: String
location: String
occupiedCnt: int
numOfRooms: int

def __init(self)__(String,String)
def isFull(self) : boolean
def isEmpty(self) : boolean
def addRoom(self ,roomnumber,bedtype,smoking,price)
def addReservation(self,occupantName ,smoking,
bedtype)
def cancelReservation(self,occupantName)
def findReservation(self,occupantName):
def printReservationList(self)
def getDailySales(self) :
def occupancyPercentage(self) :
Setters and getters methods for name and location.

4. isFull() – returns a boolean that is true if all the rooms in the hotel are occupied.
5. isEmpty() – returns a boolean that is true if all the rooms in the hotel are unoccupied.
6. The addReservation() method takes three parameters: the occupant’s name
(String), smoking or non-smoking request (char), and the requested bed type (String).
When this method is called, the hotel will search the list of its rooms for one that matches
the bed type and smoking/non-smoking attributes. If an unoccupied room with the correct
attributes is found, the renter's name will be set and the occupied attribute will be set
to true. In either case a message will be printed that will state whether or not the
reservation was made.
7. When the cancelReservation() method executes, the hotel will search for the
name of the visitor in each room. If it is found, the occupied attribute will be set to false.
In either case a message will state whether or not the reservation was cancelled. This
method calls the private utility method findReservation()to scan the list of rooms
looking for a guest by name. It will return the index of the room in the Array of rooms
or NOT_FOUND if the room is not found, which will be declared as:
NOT_FOUND = -1;
8. findReservation() will take in a String representing the occupant’s name and
search the occupied rooms for a reservation with that person’s name. It will return the
index of the room or NOT_FOUND if not found.
9. printReservationList() will scan through all the rooms and display all details
for only those rooms that are occupied. For example:

Room Number: 102
Occupant name: Pinto
Smoking room: n
Bed Type: king
Rate: 110.0
Room Number: 103
Occupant name: Wilson
Smoking room: n
Bed Type: king
Rate: 88.0
10. getDailySales() will scan the room list, adding up the dollar amounts of the room
rates of all occupied rooms only.
11. occupancyPercentage() will divide occupiedCnt by the total number of rooms to
provide an occupancy percentage.
12. __str__ – returns a nicely formatted string giving hotel and room details (by calling
the __str__ in the Room class) for all the rooms in the hotel. For example:
Hotel Name : Beach Marriot
Number of Rooms : 5
Number of Occupied Rooms : 1

Room Details are:

Room Number: 101
Occupant name: Not Occupied
Smoking room: s
Bed Type: queen
Rate: 100.0
Room Number: 102
Occupant name: Coffey
Smoking room: n
Bed Type: king
Rate: 110.0
Room Number: 103
Occupant name: Wilson
Smoking room: n
Bed Type: king
Rate: 88.0
Room Number: 104
Occupant name: Not Occupied

Smoking room: s
Bed Type: twin
Rate: 100.0
Room Number: 105
Occupant name: Not Occupied
Smoking room: n
Bed Type: queen
Rate: 99.0

13. The Room class diagram will look like this:

Room

roomNum: int
bedType: String
rate: double
occupantName: String
smoking: char
occupied: boolean
def __init__(int,String,char,double)
def getBedType(): String
def getSmoking(): char       
def getRoomNum(): int
def getRoomRate(): double
def getOccupant(): String
def setOccupied(boolean)
def setOccupant(String)
def setRoomNum(int)
def setBedType(String)
def setRate(double)
def setSmoking(char)
def isOccupied(): boolean

1. The __init__() for a Room takes an int (room number), String (bed type), char (s or n for
smoking or non-smoking)), and a double (room rate).
2. isOccupied() method returns true if the room is occupied, false otherwise.

3. __str__() provides all the details of a room - room number, name of guest(if
occupied) , bed type, smoking/non-smoking, rental rate. This should all be formatted
nicely with one attribute on each line using the '\n' escape character. See example above.
4. Several accessor and mutator methods for the Room class.

# Use list to store the room details.
You have to store required data in the list/database. You can store hotel name, address, and
all rooms. Customer data in database tables.

Net Present Value Method—Annuity for a Service Company

Amenity Hotels Inc. is considering the construction of a new hotel for $81 million. The expected life of the hotel is 7 years with no residual value. The hotel is expected to earn revenues of $22 million per year. Total expenses, including depreciation, are expected to be $16 million per year. Amenity Hotels’ management has set a minimum acceptable rate of return of 9%.

a. Determine the equal annual net cash flows from operating the hotel. Enter your answer in million. Round your answer to two decimal places.
$ million

b. Compute the net present value of the new hotel, using the present value of an annuity of $1 table above. Round to the nearest million dollars. If required, use the minus sign to indicate a negative net present value.
Net present value of hotel project: $ million

c. Does your analysis support construction of the new hotel?
Yes/No , because the net present value is positive/negative .

Net Present Value Method—Annuity for a Service Company

Welcome Inn Hotels is considering the construction of a new hotel for $70 million. The expected life of the hotel is 10 years with no residual value. The hotel is expected to earn revenues of $19 million per year. Total expenses, including depreciation, are expected to be $14 million per year. Welcome Inn management has set a minimum acceptable rate of return of 10%. Assume straight-line depreciation.

a. Determine the equal annual net cash flows from operating the hotel. Round to the nearest million dollars.
$ million

b. Calculate the net present value of the new hotel using the present value of an annuity of $1 table above. Round to the nearest million dollars. If required, use the minus sign to indicate a negative net present value.
Net present value of hotel project: $ million

c. Does your analysis support the purchase of the new hotel?
, because the net present value is  .

The Wilton is an all-inclusive spa and hotel in the heart of Brooklyn and uses guests as its measure of activity. During June, The Wilton budgeted for 2,000 guests, but it actually hosted 2,100 guests. The hotel used the following revenue and cost formulas in its budgeting, where q is the number of guests:

Revenue: $62.90q
Personnel expenses: $28,500 + $20.40q
Food and beverage supplies: $1,400 + $9.90q
Occupancy expenses: $8,200 + $3.30q
Spa expenses: $4,000 + $0.40q

The hotel reported the following actual results for June:

Revenue                                       $129,450

Personnel expenses                      $ 74,770

Food and beverage supplies           $ 22,940

Occupancy expenses                     $ 14,640

Spa expenses                                   $   4,740

Required:
a. Prepare a flexible budget performance report showing The Wilton’s revenue and spending variances and activity variances for June. Label each variance as favorable (F) or unfavorable (U), filling out the shaded squares. (22 points)

b. Describe at least two potential reasons for the revenue, spa expenses and food/beverage supplies variances found above. Are any of the variances related? Describe. (6 pts)

In January 2017, Mitzu Co. pays $2,700,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 $570,000, with a useful life of 20 years and a $85,000 salvage value. A lighted parking lot near Building 1 has improvements (Land Improvements 1) valued at $570,000 that are expected to last another 19 years with no salvage value. Without the buildings and improvements, the tract of land is valued at $1,860,000. The company also incurs the following additional costs:

Journal entry worksheet

Record the cost of the plant assets, paid in cash.

8. Peter Griffin calculates that his portfolio's risk, as measured by the standard deviation, is 19.67%. His portfolio is made up of many stocks from just two companies, South Park Company and Quahog Company. South Park Co.'s returns have a standard deviation of 12.9% and Quahog Co.'s returns have a standard deviation of 28.84%. If the weight of Quahog Co. in his portfolio is 48.21%, what is the correlation between the returns of Quahog and South Park.

9.

A portfolio has an excess return of 15.9 % and a standard deviation of 15.23 %. What is the Sharpe Ratio for this portfolio?

3. Design and draw a circuit using the cascade system to operate two cylinders (A and B) which, on the operation of a start valve, produces the sequence A – B + B – A+. The cylinders should park in the positions B – A + when the start switch is in the ‘off’ position.

4. Modify the circuit designed for question 3 to provide an emergency stop which will park both cylinders in the extended position (i.e. A + B +).

5. Modify the circuit designed for question 3 to provide a fail safe. The fail safe should:

(a) act in the event of a reduced pressure at inlet to the group selecting valve

(b) park the cylinders in the retracted position

A new wastewater treatment plant was built to treat the wastewater flow 800,000 gpd. The capital cost to build the wastewater treatment plant was $6,000,000. The annual operation and maintenance costs of operating the plant is $700,000/year. Estimate the cost of treating 1000 gallons of wastewater ($/1000 gallon). Assume the design life as 20 years and interest rate of 4%.

The Royal Hotel is being sold. The underwriter requests the pro forma statements showing future projected cash flows from the hotel owner. If the underwriter only uses this information, (a) which approach to valuation are they using? Please also (b) name and (c) briefly describe the other two approaches.

What differences if any do you think exist in the way that a professional hotelier would manager an American owned hotel in the United States or a European or Asian owned hotel in the United States?

What are differences in the way governments in other countries affect the management and operation of hotels in those countries?