The Bijou Theater shows vintage movies. Customers arrive at the theater line at the rate of 80 per hour. The ticket seller averages 36 seconds per customer, which includes placing validation stamps on customers’ parking lot receipts and punching their frequent watcher cards. (Because of these added services, many customers don’t get in until after the feature has started.) (Use the Excel spreadsheet Queue Models.)

a. What is the average customer time in the system? (Round your answer to 2 decimal places.)

b. What would be the effect on customer time in the system of having a second ticket taker doing nothing but validations and card punching, thereby cutting the average service time to 25 seconds? (Round your answer to 3 decimal places.)

Average time in system ________ minutes

c. What would be the customer time in the system if instead of the change in Part b, a second window was opened with each server doing all three tasks? (Do not round intermediate calculations. Round your answer to 3 decimal places.)

d. Would system waiting time which is obtained in part (c) be less than you found in (b)?

• Yes

• No

Is the product or service of the hotel industry standardized or differentiated? Explain. Compared to other industries, is it difficult or easy to enter the hotel industry? Explain. Are there examples of nonprice competition in the hotel industry? Illustrate. Based on the above, would you say that the hotel industry is monopoly, oligopoly, monopolistic competition or perfect competition? Explain.

Only securities A.B.C with the following characteristics exist in the market.

1.Securities A: E (R) = 10% / Standard deviation = 12.0%
2.Securities B: E (R) = 6% / Standard deviation = 6.0%
3.Securities C: E (R) = 4% / Standard deviation = 0.0%

Suppose that the correlation coefficient between the returns of Securities A and B is 0.5.

(a) When constructing a portfolio with securities A and B, change the composition ratio to (1.0, 0), (0.7, 0.3), (0.5, 0.5), (0.3, 0.7), (0.1, 0) and expect How do returns and standard deviations change?

(b) Use only Securities A and B. We want to achieve an expected return of 8%. What is the minimum risk faced at this time?

(c) When constructing a portfolio with securities A, B, and C, what is the composition ratio of a portfolio with an expected return of 8% and a minimum risk? At this time, what is the composition ratio between risky assets A and B?

(d) What is the compositional ratio of the portfolio with the expected return of 6% and the minimum risk when constructing the portfolio with securities A, B, and C? At this time, does the composition ratio between risky assets A and B differ from that in (c)?

Given the monthly returns that follow, find the R2, alpha, and beta of the portfolio. Compute the average return differential with and without sign. Do not round intermediate calculations. Round your answers to two decimal places. Month Portfolio Return S&P 500 Return January 5.8 % 6.0 % February -2.4 -3.3 March -1.9 -1.3 April 2.4 1.6 May 0.5 0.2 June -1.0 -0.6 July 0.2 0.4 August 1.4 1.9 September -0.5 -0.3 October -3.5 -3.8 November 2.5 1.9 December 0.4 0.0

R2:

Alpha: %

Beta:

Average return difference (with signs): %

Average return difference (without signs) %

1. The price-elasticity of demand for cocaine to be 0.3 (Ped =0.3). Is this price-elastic or price-inelastic? And Why?

2. The price-elasticity of demand for methamphetamine to be 1.5 (Ped = 1.5). Is this price-elastic or price-inelastic? And Why?

Perth Corporation has two operating divisions, a casino and a hotel. The two divisions meet the requirements for segment disclosures. Before transactions between the two divisions are considered, revenues and costs are as follows:

The casino and the hotel have a joint marketing arrangement by which the hotel gives coupons redeemable at casino slot machines and the casino gives discount coupons good for stays at the hotel. The value of the coupons for the slot machines redeemed during the past year totaled $5,000,000. The discount coupons redeemed at the hotel totaled $1,000,000. As of the end of the year, all coupons for the current year expired.

Required:

What are the operating profits for each division considering the effects of the costs arising from the joint marketing agreement? (Enter your answers in thousands.)

Operating Profits

casino

hotel

Comparing occupancy for two hotels

Sunrise Suites and Nationwide Inns operate competing hotel chains across the region. Hotel capacity information for both hotels is as follows:

Information on the number of guests for each hotel and the average length of visit for June were as follows:

a. Determine the guest nights for each hotel in June. Guest Nights Sunrise Suites: Nationwide Inns:

b. Determine the room nights for each hotel in June. Room Nights Sunrise Suites: Nationwide Inns:

c. Determine the occupancy rate of each hotel in June. Occupancy Rate Sunrise Suites % Nationwide Inns

We have provided you the Hotel database to be used with SQLite DBMS. You should use this database in SQLite to extract the necessary information as per the following query requirements.

The sqlite script is based on the following relational schema:

•Hotel (hotelNo, hotelName, city)

• Room (roomNo, hotelNo, type, price)

• Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

•Guest (guestNo, guestName, guestAddress)

Note the following details of the hotel database;

•Hotel contains hotel details and hotelNo is the primary key;

•Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;

•Booking contains details of bookings and (hotelNo,guestNo,dateFrom) forms the primary key;

•Guest contains guest details and guestNo is the primary key.

Write an SQLite script for querying data.

•List hotelNo, type and price of each double or deluxe room with a price more than $99.

•List hotelNo who have more than 2 double rooms.

•List number of different guests who visited Ridge Hotel.

•What is the total income from bookings for the Grosvenor Hotel? .

•List all the guests who have stayed in a hotel.

Task 3 [3 marks]

Perform the following tasks.

•Write commands to insert rows in each of the Hotel database tables .

•Write a command to delete the row you inserted in the table Guest .

•Write a command to update the price of all rooms by 10% (1 mark).

Are the measurements Nominal, Ordinal, Interval, or Ratio?

Also, Qualitative, Discrete or Continuous?

1. Which subsidiary insures your vehicle (choose one)? {MallState, CaveLizard, MaryPoppins}
2. What is your weight?
3. Where do you usually park your vehicle (choose one)? {Public Street, Paid Parking Lot, Private Garage}
4. On average, how many minutes does it take you drive to work?
5. On average, how many miles per year do you drive? (to the nearest tenth of a mile, as the odometer[1] reads)
6. What is the state of your residency?
7. The make calendar year of your car?
8. Buyer’s age category: {less 25, 26-36,37-55, 56-65, over 65}

(i)   What is the temperature that you prefer inside the car (in Fahrenheit)?

(j) Give your customer satisfaction on a scale of 1-10.