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.

4. Emily likes bird watching. Every year she takes a vacation to a park famous for

its rare birds. She goes there for 10 days. From her past experience, she knows that on

average she can get 6 good sightings a day. A very good day for her is a day with at least

10 good sightings. Assume Poisson distribution of the number of good sightings on any day

(independently of other days).

a) What is the probability that she can get at least one very good day this time?

b) What is the expected number of very good days during this vacation?

c) What is the expected number of days she has to go bird watching in this park before

getting one very good day?

d) Extra credit: What should the average number of good sightings per day be so that

the probability that she gets at least one very good day during this vacation be at least 0.9?

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?

One of the key questions decision makers must ask when considering whether to invest in a new technology is “what will the return on investment (ROI) be?” In other words, will this technology pay for itself, and when?

Consider an amusement park called FunTown. Funtown is a popular amusement park but because of long entrance lines to the park, yearly attendance has been flat (no increase or decrease) for the last 3 years. Unless something is done to alleviate the long entrance lines, attendance is not expected to increase for the next 3 years.

Funtown is considering implementing a handheld scanner system that can allow employees to walk around the front gates and accept credit card payment and print tickets on the spot. With the new scanner system, Funtown anticipates selling 2.4 million tickets in the next year (year 1), with a 4% increase (over the previous year) for the 2 years after that (years 2 and 3). Without the handheld scanner, Funtown anticipates selling 2.4 million tickets per year for the next 3 years.

The handheld scanner system is not without cost. Entrance to Funtown costs 35 dollars. For every ticket sold with the online scanner system, there is an expense of 6% of the ticket price.

It will take a while for the new system to catch on. Funtown estimates that 10% of year 1 attendance tickets will be sold using the online scanner. They also estimate that will grow to 20% and 30% in years 2 and 3 respectively.

Your assignment is to do a 3 year analysis of this proposal and determine if and when this scanner system will pay for itself.

Specifically, you are to calculate the net revenue of Funtown for each of the next 3 years, with, and without the new scanner system, and calculate the difference.

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.

The cosmetics division of Valles Global Industries (VGI) sells a special type of organic perfume that is highly sought after. This perfume sells for $150 per 75 ml bottle. For many years, they have sold in Asia through a Seoul-based importer by the name of Park Beauty Products. Their contract with Park Beauty Products is up for renewal and VGI has decided to look at options. You are in charge of making a recommendation.

Option 1: Continue to sell through Park Beauty Products by selling them the perfume in bulk loads of 750 liters at a cost of $150 USD per liter. Let them handle everything at their cost.   VGI receives a net payment of $15 USD per bottle.

Option 2: Sell a license for production to SohnCo Fragrances of Seoul, Korea. They will also manage marketing and distribution of the perfume. SohnCo Fragrances will charge VGI a fixed fee of $2 million USD per year to cover marketing costs. SohnCo Fragrances will pay VGI $25 USD per bottle of VGI products it sells in Asia.

Option 3: Create a new enterprise, VGI Asia, by building a small plant for $15 million USD. Annual fixed costs are estimated to be $1.5 million USD and variable costs are $0.60 per bottle.

USD—United States Dollar

Develop a five-year forecast for each of the three options. Assume there is no inflation and do a pre-tax analysis.   Develop a cash flow forecast assuming sales remain variable at somewhere between 1, 700,000 bottles and 2,000,000 bottles per year. Make and support a recommendation as to which of the options to employ.

Your professor is going on vacation. He has narrowed down a list of potential hotels, but he is still overwhelmed by the data. He loves great food and wants to do all the activities at the resort.

1. Develop two unique ways to display the data (two unique types of charts) to show him where he should stay.

2. Recommend the best way to present the data. Write a narrative summary of what hotel you recommend based on the data visualization and the tradeoffs that you observe.