Conjoint Analysis

Imagine we are evaluating three hotels and have identified a conjoint model with three attributes. Two of the attributes (food and beach) have three levels, and the third, amusement, has two levels (see Table 1). We create a self-administered questionnaire. Four respondents are each asked to rate 18 packages (hotels) of attributes on a scale from 0 to 10. For example, a package/hotel might be : “A hotel with food featuring snacks, a beach with sand and boats, and no amusements.” The respondents responses are recorded in the Excel file “2_conjoint_hotels.xlsx” Google sheets version here (can be easily imported to excel): https://docs.google.com/spreadsheets/d/17tZ2xqS7KswhO9CgnUAgv-mKqPj63GwxaiHP2dhj7YU/edit?usp=sharing

Write out your regression model. For each respondent, run the conjoint analysis and report the part-worths.

.

A resort hotel annual sales revenue of $1,000,000, Variable costs of $350,000, and a fixed costs of $570,000. The fixed costs include $80,000 a year for land rental lease.

a) Calculate the hotel's breakeven point.

b) If the owners had an equity investment in the hotel of $1,200,000. What level of sales revenue is required for an operating income (BT) representing a 15% return on their investment?

c). In a renegotiation of the land lease, the landowner has offered management an alternative to the fixed lease currently being paid. The alternative in the lease currently being paid. The alternative is 10% of the resort's contribution margin.

i. If management accepts this proposal, what would be the resort hotel's new breakeven point?

ii. Calculate the indifference point.

iii. Explain whether management should accept this proposal. if next year's total sales revenue is expected to be $1,200,000?

iv. Should management accept this proposal if next's total sales revenue is expected to be $1,400,000

.:PS. I need all the C ( this includes " i " ; " ii " ; " iii " & " iv "

A) A large insurance company offers group disability insurance products to businesses, which in turn offer the product to their employees. Pricing policies to prevent a loss is difficult. Since it is difficult to know exactly which employees are more prone to file claims, it is hard to price policies accurately. If policies are priced too low, high-risk clients will be attracted and losses incurred. If policies are priced too high, not enough clients will be attracted. Compounding this factor is the fact that companies are motivated to exaggerate their safety in order to negotiate a lower price.  

What problem is being described in this scenario?  

What types of activities can the insurance company undertake to distinguish between customers with a low probability versus a high probability of claiming?

B)The large accommodation chains like Marriott, Accor do not run individual hotels themselves but rather lease the naming rights to a franchisee who leases the building from a property trust. What are the main advantages for hotel chains of not directly operating the hotel? What are the main disadvantages of the franchisee not owning the building?   

The food and beverage manager of the Glitz Hotel just got a great deal on beverages for the bar. Instead of buying large 5L containers for $25 each, they instead were able to purchase 1,000 cases of 12-packs of 500ml cans for $26,640. Beverages are served in 500ml servings. Usually, they sell 800 beverages over a weekend, but they actually sold 900 this past weekend. However, 20 customers had to be refunded due to problems with the cans.

Direct labour costs are driven by the number of beverages served. A typical weekend requires four servers each working two 8-hour shifts at $12/hour. At the end of the weekend, actual labour costs were $816.50 for 71 hours.

Required:

A   Calculate the following variances:

Material rate

Material quantity

Direct Labour rate

Direct labour efficiency

B   Briefly explain the variances to the hotel manager, and explain if the variances are somehow interlinked. Assess the special purchase and identify other factors that should be considered.

Summary

The cost of renting a room at a hotel is, say $100.00 per night. For special occasions, such as a wedding or conference, the hotel offers a special discount as follows.

If the number of rooms booked is:

• at least 10, the discount is 10%
• at least 20, the discount is 20%
• at least 30, the discount is 30%

Also if rooms are booked for at least three days, then there is an additional 5% discount.

Instructions

Write a program that prompts the user to enter:

1. The cost of renting one room
2. The number of rooms booked
3. The number of days the rooms are booked
4. The sales tax (as a percent).

The program outputs:

1. The cost of renting one room
2. The discount on each room as a percent
3. The number of rooms booked
4. The number of days the rooms are booked
5. The total cost of the rooms
6. The sales tax
7. The total billing amount.

Your program must use appropriate named constants to store special values such as various discounts.

Since your program handles currency, make sure to use a data type that can store decimals with a precision to 2 decimals.

You are a CEO of a national restaurant chain. You are facing an investment proposal of building 20 new hotels across the country. Since hotel is a new business line for your company, the management finds Hilton Hotel corporation as one pure play company to assist the evaluation of this investment proposal. With the following information, what discount rate should you use to evaluate this investment proposal?

1 year government bond return: 0.85%

10 year government bond return: 2.41%

Expected market risk premium: 5%

Info on Hilton

Equity return: 6.20%

Equity beta: .76

Debt to value ratio: 14%

Marginal tax rate: 40%

Info on your company

Book value of long-term debt: $5,000,000

Book value of equity: $5,000,000

Share price: $15

Number of shares outstanding: 1,000,000

Debt rate premium above government bonds is 3%

Marginal tax rate: 40%

The before tax cost of debt is _______________%

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel’s business is highly seasonal, with peaks occurring during the ski season and in the summer.

Required:

1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. (Do not round your intermediate calculations. Round your Variable cost answer to 2 decimal places and Fixed cost element answer to nearest whole dollar amount.)

Suppose that you are responsible for making arrangements for a medical convention and you have been charged with finding a city for the convention that has the least expensive hotel rooms. You have narrowed your choices to Atlanta and Houston. The data set contains a sample of hotel room prices from Atlanta and Houston. Based on the sample data, can you conclude that the mean price of a hotel room in Atlanta is lower than one in Houston? Perform a two-sample t-test with a significance level of α = 0.05. Use Excel to show your work.

1. Create a box plot of the data.

2. State the null and alternative hypotheses. Is this a left-tailed, right-tailed or two-tailed test?

3. Compute the following. Assume unequal variance and df = 66. The t.test() function can be used to compute the p-value directly.

Do you reject or fail to reject the null hypothesis? Whats the conclusion?

Suppose that you are responsible for making arrangements for a medical convention and you have been charged with finding a city for the convention that has the least expensive hotel rooms. You have narrowed your choices to Atlanta and Houston. The data set contains a sample of hotel room prices from Atlanta and Houston. Based on the sample data, can you conclude that the mean price of a hotel room in Atlanta is lower than one in Houston? Perform a two-sample t-test with a significance level of α = 0.05. Use Excel to show your work.

1. Create a box plot of the data.

2. State the null and alternative hypotheses. Is this a left-tailed, right-tailed or two-tailed test?

3. Compute the following. Assume unequal variance and df = 66. The t.test() function can be used to compute the p-value directly.

Do you reject or fail to reject the null hypothesis? Whats the conclusion?

PERFORMANCE EVALUATION

Julie Miller supervisor of housecleaning for Hotel Minto, was surprised by her summary report for March given below.

Julie was disappointed. She thought she had done a good job controlling housekeeping labor and towel usage, but her performance report revealed an unfavorable variance of $12,111. She had been hoping for a bonus for her good work, but now expected a series of questions from her manager.

The cost budget for housekeeping is based on standard costs. At the beginning of a month, Julie receives a report from Hotel Minto’s Sales Department outlining the planned room activity for the month. Julie then schedules labor and purchases using this information.

The budget for the housekeeping was based on 8,000 room nights. Each room night is budgeted based on the following standards for various materials, labor, and overhead:

With 8,900 room nights sold, actual costs and usage for housekeeping during April were:

Required:

You have been asked to re-evaluate Julie’s performance.

Prepare a report to Julie’s boss demonstrating and explaining your findings; including your suggestions for performance evaluation methods and measures in the future.