DO NOT ANSWER IN EXCEL
|
Years |
Project A |
Project B |
|
Year 1 CashFlow |
316,000.00 |
200,000.00 |
|
Year 2 CashFlow |
350,000.00 |
200,000.00 |
|
Year 3 CashFlow |
(20,000.00) |
(15,000.00) |
|
Year 4 CashFlow |
280,000.00 |
390,000.00 |
The cost of capital for Project A is 13% and the cost of capital
for project B is 15%.
Calculate the following;
In: Finance
Regarding the hotel/hospitality industry
Who are the competitors? Is it easy to start a business in this industry? Are there significant entry barriers? What are the dominant characteristics and current trends in your industry?
Discuss industry size in terms of the number of companies, total employment, capital investment, major customers, and annual revenues. What are the driving forces of change in the industry, (e.g., innovation, technology, and buyer preferences and lifestyles)? State how organizations compete within the industry and identify the critical success factors in this industry.
In: Economics
5. Calculate the net food cost percentage for the Food department of a hotel for the month of May. The total food sales revenue for May was $191,118. The following information has been gathered:
To earn full credit, please calculate these amounts. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts:
First calculate gross cost of food sales $___
6 . Please use the information from Question 5 to calculate the amount to transfer from mail storeroom. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts:
Transfer from mail storeroom $___
2. Please use the information from Question 5 to calculate the amount to transfer to the other outlet. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts.
Transfer to other outlet $___
3. Please use the information from Question 5 to calculate the amount in entertainment and promotion checks. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts:
Entertainment & promotion checks $___
4.Please use the information from Question 5 to calculate the amount in management signed checks. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts.
Management signed checks $___
5.Please use the information from Question 5 to calculate the amount of food spoilage. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts.
Food spoilage $ ___
6. Please use the information from Question 5 to calculate the amount in Employees' meals. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts.
Employees' meals $___
7.Please use the information from Question 5 to calculate the amount in happy hour hors d'oeuvres. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts:
Happy hour hors d'oeuvres $ ___
8. Please use the information from Question 5 to calculate the amount in net cost of food sales. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts.
Net cost of food sales $___
9.Please use the information from Question 5 to calculate the amount in food cost percentage. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts.
Food cost percentage (round to two decimal points) ___%
10.A 345-room hotel’s food and beverage department recorded food revenue of $3,460,397.5 and beverage revenue of $1,483,027.5. The cost of sales was 27.3% of F & B revenue, and the departmental expenses were 43.2% of F & B revenue. What is the gross profit percentage for the hotel’s F&B department?
Gross profit percentage for the hotel's F&B department (round to one decimal point) ___%.
In: Accounting
The manager of alarge hotel on the Riviera in southern France wanted to forecast the monthly vacancy rate (as a percentage) during the peak season. After considering a long list of potential variables, she identified two variables that she believed were most closely related to the vacancy rate: the average daily temperature and the value of the currency in American dollars. She collected data for 23 months.
a. Perform a regression analysis using a first-order model with interaction.
b. Perform a regression analysis using a second-order model with interaction.
c. Which model fits better? Explain.
In: Statistics and Probability
Suppose the guests at the hotel have an average weight of 180 with a standard deviation of 50 pounds. An elevator is designed to carry only 10 people with a maximum capacity of 2400 pounds.
5. What is the mean of the sample mean?
6. What is the standard deviation for the sample mean of the 10 people? (Use 2 decimals)
7. If 10 guest ride the elevator at one time, what is the probability that the elevator is overweight? (Hint: If the 10 people weigh more than 2400 pounds, how much does each person have to weigh on average? (Use 4 decimals)
8. If 12 guests ride in the elevator at one time, now what is the probability that the elevator is overweight? (Hint: the standard deviation also changes here) (Use 4 decimals)
In: Statistics and Probability
According to a research institution, the average hotel price in a certain year was
$107.64
.
Assume the population standard deviation is
$20.00
and that a random sample of
46
hotels was selected. Complete parts a through d below.
a. Calculate the standard error of the mean.
sigma Subscript x overbar
equals$nothing
(Round to two decimal places as needed.)
b. What is the probability that the sample mean will be less than
$109
?
Upper P left parenthesis x overbar less than $ 109 right parenthesis
equalsnothing
(Round to four decimal places as needed.)
c. What is the probability that the sample mean will be more than
$113
?
Upper P left parenthesis x overbar greater than $ 113 right parenthesis
equalsnothing
(Round to four decimal places as needed.)
d. What is the probability that the sample mean will be between
$106
and
$108
?
Upper P left parenthesis $ 106 less than or equals x overbar less than or equals $ 108 right parenthesis
equalsnothing
(Round to four decimal places as needed.)
In: Statistics and Probability
According to a research institution, the average hotel price in a certain year was $95.82 . Assume the population standard deviation is $18.00 and that a random sample of 36 hotels was selected. Complete parts a through d below. a. Calculate the standard error of the mean. sigma Subscript x overbar equals$nothing (Round to two decimal places as needed.) b. What is the probability that the sample mean will be less than $98 ? Upper P left parenthesis x overbar less than $ 98 right parenthesis equalsnothing (Round to four decimal places as needed.) c. What is the probability that the sample mean will be more than $100 ? Upper P left parenthesis x overbar greater than $ 100 right parenthesis equalsnothing (Round to four decimal places as needed.) d. What is the probability that the sample mean will be between $94 and $96 ? Upper P left parenthesis $ 94 less than or equals x overbar less than or equals $ 96 right parenthesis equalsnothing (Round to four decimal places as needed.
In: Statistics and Probability
The management of the Mojito Theme hotel estimated that they can generate $180,000 and $190,000 in room revenues in 2011 and 2012, respectively, by using some other forecasting methods. However, the total room revenues were actually $185,000 and $200,000 in 2011 and 2012, respectively. The management team wants to come up with a robust forecasting report and they want to see the forecasting results with exponential smoothing model. Therefore, based on the information given, if the management would like to sell 2,500 rooms in 2012, what is the forecasted average daily rate (ADR) in 2012 based on the exponential smoothing model?
In: Finance
The average daily rate of a hotel in Canada as of August 2018
was $172.75. Assume the average daily rate follows a normal
distribution with a standard deviation of $28.60.
Standard Normal Distribution Table ( note you need access to this
table in order to do this question)
a. What is the probability that the average
daily rate of a Canadian hotel will be:
(i) less than $175
P(X < 175)=P(X < 175)=
(ii) more than $205
P(X > 205)=P(X > 205)=
(iii) Between $145 and $185
P(145 < X < 185)=P(145 < X < 185)=
b. Determine the average daily rates that
separate the:
(i) top 7% of average daily rates from the rest of the
daily rates or from the bottom 93% of average daily
rates
x=x=
Round to 2 decimal places.
(ii) bottom 25% of average daily rates from the rest of the
daily rates
x=x=
Round to 2 decimal places.
(iii) middle 70% of average daily rates from the rest of
the daily rates
< x < < x <
Round to 2 decimal places.
h(i,x)=
{10if program i halts on input x,otherwise.{1if program i halts on input x,0otherwise.
In: Statistics and Probability
| Years | Project A | Project B |
| Year 1 CashFlow | 316,000.00 | 200,000.00 |
| Year 2 CashFlow | 350,000.00 | 200,000.00 |
| Year 3 CashFlow | (20,000.00) | (15,000.00) |
| Year 4 CashFlow | 280,000.00 | 390,000.00 |
The cost of capital for Project A is 13% and the cost of capital
for project B is 15%.
Calculate the following;
In: Finance