Star Inn is a chain of hotels. The reservation system is uses a centralized reservation database. The database contains booking information on all hotels of Star Inn. The following is a description of the conceptual model of the hotel reservation database at Star Inn.

The database contains information about hotels, hotel rooms, customers, and reservation. A hotel can be identified by its identification number (hotel_id). It is also described by hotel_name, address and phone_no. Rooms are identified by room_no which is unique for a hotel. The same room_no may exist in different hotels of Star Inn. Rooms are also described by type and rate.

Customers are identified by customer_id and are described by name (customer_name), address (customer_address), and phone number (customer_phone). When a customer makes a reservation, he/she is asked to specify the hotel, the room type, the arrival date (arrival_date) and duration of stay (duration). A specific room is then booked for the customer. A customer can book the same room more than once. Therefore, a reservation is identified by a reservation number (reservation_no).

Please use Visible Analyst or any other CASE tool to draw the ERD.

• The following information is for Winter Break Hotel. Given the information, questions from #14 to #16.
o Average room selling price: $65
o Average variable cost per room: $17
o Annual total fixed costs: $450,000
o Sales goal (= Net Income) of the hotel this year: $5,000,000
o Number of rooms available per day: 400 rooms
o This hotel is open 365 days a year.

What is the occupancy percentage required to reach the sales goal? (Round to the second decimal place.)

A. 23.43%

B. 9.46%

C. 23.65%

D. 77.77%

For every $1 of sales, how much can this hotel use to pay on fixed costs or to generate profits?

A. $2.82

B. $.82

C. $.26

D. $.74

If this hotel experiences an increase in its fixed cost by $35,000 this year, how many additional rooms must be sold to absorb this increase? (Round up to the nearest whole number.)

A. 730 rooms

B. 21,722 rooms

C. 727 rooms

D. 11,667 rooms

Hubbart approach

The Pimlico Hotel is a 200-room hotel and it is projected to cost $15 million including land, building, equipment, and furniture and working capital. The hotel is financed with a $10 million loan at 8% interest rate. The owner’s investment in the property is $5 million. The owners desire a 16% return on investment. The hotel projects 80% occupancy rate and it will be open 365 days a year. The income tax rate is 40%. Room’s department direct expenses

are $10 per room sold.

The following are the fixed and undistributed expenses.

Depreciation expense $300,000

Amortization expense 100,000

Rent Expense 130,000

Administration and general 300,000

Marketing 200,000

Utility costs 200,000

Property Operations and Maintenance 120,000

Insurance 50,000

Property taxes 200,000

Other operated departments’ Income/losses

Food 150,000

Beverage 50,000

Telephone (50,000)

Additional information

Double occupancy 40%

Rate difference (spread) between double and single is $10.

Using the information above find the ADR and determine double rate and single rate for the Pimlico Hotel.

Fun City has decided to build a new municipal water park with pools, water slides, and so forth. You have been hired to conduct a study to determine if the water park can pass the test. A nearby and very similar city currently has a water park similar to the one Fun City is considering. The nearby city currently charges $10 for admission and, on a typical day, attracts 4,000 persons. Last year, it charged $15, but only attracted 3,000 paying customers.

1. Assuming that the demand curve for water parks is linear, estimate the net benefits received by those using the Fun City water park, if Fun City charges an admission price of $12.50. [NOTE: You need not compute the actual amount; just use a graph and clearly indicate the area that represents the net benefit amount.]

2. By how much, and in what direction, would the net benefits received by those using the water park change if Fun City charges a $15.00 admission price, rather than $12.50? [NOTE: This time compute the actual dollar value.]

IN JAVA

Write a program that calculates the occupancy rate for each floor of a hotel. (Use a sentinel value and please point out the sentinel in bold.) The program should start by asking for the number of floors in the hotel. A loop should then iterate once for each floor. During each iteration, the loop should ask the user for the number of rooms on the floor and the number of them that are occupied. After all the iterations, the program should display the number of rooms the hotel has, the number of them that are occupied, the number that are vacant, and the occupancy rate for the hotel. Input Validation: Do not accept a value less than 1 for the number of floors. Do not accept a number less than 10 for the number of rooms on a floor.

SAMPLE OUTPUT:

Enter number of floors:
2
Enter total rooms at floor 1:
10
Enter total rooms occupied at floor1:
5
Enter total rooms at floor 2:
10
Enter total rooms occupied at floor2:
5
Total rooms: 20
Total occupied rooms: 20
Hotel occupany: 50.0

A bicycle racer sprints at the end of a race to clinch a victory. The racer has an initial velocity of 11.2 m/s and accelerates at the rate of 0.3 m/s2 for 6.9 s.

a)The racer continues at this velocity to the finish line. If he was 293 m from the finish line when he started to accelerate, how much time did he save (in s)?

b)One other racer was 5 m ahead when the winner started to accelerate, but he was unable to accelerate, and traveled at 11.5 m/s until the finish line. How far ahead of him (in seconds) did the winner finish?

c) How far ahead of him (in meters) did the winner finish?

A fast elevator in a skyscraper is employing the following scheme to get from the starting level to the desired level: For the first half of the time it accelerates at the maximum allowed acceleration of 1.0 m/s2 and for the second half it decelerates at the maximum allowed acceleration of −1.0 m/s2. How long does it take (in seconds) to go from ground level to the highest level at 80 m elevation?

A track team is practicing for a 4 × 100 m relay race. The first runner, Linda, is running at a constant speed of 8.6 m/s. The next runner, Jenny, will be starting from rest at the 80 m mark. She has an acceleration of 1.0 m/s2. Ideally the two runners meet at the 100 m mark to hand over the baton. At this point, Jenny is still accelerating.

a) How long does it take Jenny to run from the 80-m mark to the 100-m mark?

b) At what distance behind Jenny should Linda be when Jenny starts running? (Assume for simplicity that there is no distance between the two runners when the switch happens.)

c) What’s Jenny’s speed at the 100m mark?

Suppose you work at a large tire distribution center. The tires’ average tread life has been 50,000 miles with a standard deviation of 5,000 miles. At the end of the year, the company can reevaluate their supply contract. There are four supply options for the next contract: the current supplier or one of three competitors.

The current supplier produces tires with an average tread life of 50,000 miles with a standard deviation of 5,000 miles. Competitor A claims to produce tires with an average tread life of 52,000 miles with a population standard deviation of 8,000 miles. Competitor B claims to produce tires with an average tread life of 50,000 miles with a population standard deviation of 3,000 miles. Competitor C claims to produce tires with an average tread life of 60,000 miles with a population standard deviation of 12,000 miles.

Based on your evaluations of the three competitors, you must recommend a supply option for the next contract. Recall, you are allowed to choose the current supplier.