Here is the ORIGINAL data of the Sport Hotel project: 1. Projected outflows First year (Purchase Right, Land, and Permits) $1,000,000 Second Year (Construct building shell $2,000,000 Third Year: (Finish interior and furnishings) $2,000,000 TOTAL $5,000,000 2. Projected inflows If the franchise is granted hotel will be worth: $8,000,000 when it opened If the franchise is denied hotel will be worth: $2,000,000 when it opened. The probability of the city being awarded the franchise is 50%. Suppose that everything is the same as in that problem except TWO things: the worth of the hotel, should the city be awarded the franchise, is not $8 million but some unknown smaller number; and the probability of getting the franchise is NOT 50% but is upgraded to 80%. What must the new worth of the hotel when the franchise is granted be in order for the NPV of the Sporthotel project to be equal to exactly zero?
In: Finance
ABC Hotel is a 390-room economy hotel in downtown St. Louis. After taking physical inventory of the laundry chemicals on May 31st, the assistant controller found that:
In the Main Storeroom
In the Laundry Room
The beginning inventory for laundry supplies on May 1st was $6,051.75. Purchase of laundry chemicals on May 9th totaled $890.15. The hotel sold 9,067 rooms for the month at an average daily rate of $65.10. Please calculate the laundry chemical cost percentage for the month. Please round all answers to two decimal places.
First please calculate total ending inventory $___
2. Please use the information in Question 1 to calculate the cost of laundry supplies used. Round all answers to two decimal places.
Cost of laundry supplies used $___
3.Please use the information in Question 1 to calculate the monthly rooms revenue. Round all answers to two decimal places.
Monthly rooms revenue $___
4. Please use the information in Question 1 to calculate the laundry cost percentage. Round all answers to two decimal places.
Laundry cost percentage ___%
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 $___
In: Accounting
A quality control activity analysis indicated the following four activity costs of a hotel:
| Inspecting cleanliness of rooms | $468,000 |
| Processing lost customer reservations | 156,000 |
| Rework incorrectly prepared room service meal | 78,000 |
| Employee training | 78,000 |
| Total | $780,000 |
Sales are $3,900,000. Prepare a cost of quality report. Round percent of sales to one decimal place.
In: Accounting
New York City is the most expensive city in the United States for lodging. The mean hotel room rate is $204 per night (USA Today, April 30, 2012). Assume that room rates are normally distributed with a standard deviation of $55. a. What is the probability that a hotel room costs $225 or more per night (to 4 decimals)? b. What is the probability that a hotel room costs less than $140 per night (to 4 decimals)? c. What is the probability that a hotel room costs between $200 and $300 per night (to 4 decimals)? d. What is the cost of the 20% most expensive hotel rooms in New York City? Round up to the next dollar. $ or
In: Statistics and Probability
On a 15-year, $200K mortgage at 4% APR, how much interest will you pay in ONLY the second year if you make the regular monthly payments?
Multiple Choice
$8,366
$17,170
$1,497
$680
$9,083
In: Finance
Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings.
REGION ID
1= Crete
2=Southern Aegean Islands
3=Ionian Islands
| Total_Rooms | Region_ID |
| 412 | 1 |
| 313 | 1 |
| 265 | 1 |
| 204 | 1 |
| 172 | 1 |
| 133 | 1 |
| 127 | 1 |
| 322 | 1 |
| 241 | 1 |
| 172 | 1 |
| 121 | 1 |
| 70 | 1 |
| 65 | 1 |
| 93 | 1 |
| 75 | 1 |
| 69 | 1 |
| 66 | 1 |
| 54 | 1 |
| 68 | 1 |
| 57 | 1 |
| 38 | 1 |
| 27 | 1 |
| 47 | 1 |
| 32 | 1 |
| 27 | 1 |
| 48 | 1 |
| 39 | 1 |
| 35 | 1 |
| 23 | 1 |
| 25 | 1 |
| 10 | 1 |
| 18 | 1 |
| 17 | 1 |
| 29 | 1 |
| 21 | 1 |
| 23 | 1 |
| 15 | 1 |
| 8 | 1 |
| 20 | 1 |
| 11 | 1 |
| 15 | 1 |
| 18 | 1 |
| 23 | 1 |
| 10 | 1 |
| 26 | 1 |
| 306 | 2 |
| 240 | 2 |
| 330 | 2 |
| 139 | 2 |
| 353 | 2 |
| 324 | 2 |
| 276 | 2 |
| 221 | 2 |
| 200 | 2 |
| 117 | 2 |
| 170 | 2 |
| 122 | 2 |
| 57 | 2 |
| 62 | 2 |
| 98 | 2 |
| 75 | 2 |
| 62 | 2 |
| 50 | 2 |
| 27 | 2 |
| 44 | 2 |
| 33 | 2 |
| 25 | 2 |
| 42 | 2 |
| 30 | 2 |
| 44 | 2 |
| 10 | 2 |
| 18 | 2 |
| 18 | 2 |
| 73 | 2 |
| 21 | 2 |
| 22 | 2 |
| 25 | 2 |
| 25 | 2 |
| 31 | 2 |
| 16 | 2 |
| 15 | 2 |
| 12 | 2 |
| 11 | 2 |
| 16 | 2 |
| 22 | 2 |
| 12 | 2 |
| 34 | 2 |
| 37 | 2 |
| 25 | 2 |
| 10 | 2 |
| 270 | 3 |
| 261 | 3 |
| 219 | 3 |
| 280 | 3 |
| 378 | 3 |
| 181 | 3 |
| 166 | 3 |
| 119 | 3 |
| 174 | 3 |
| 124 | 3 |
| 112 | 3 |
| 227 | 3 |
| 161 | 3 |
| 216 | 3 |
| 102 | 3 |
| 96 | 3 |
| 97 | 3 |
| 56 | 3 |
| 72 | 3 |
| 62 | 3 |
| 78 | 3 |
| 74 | 3 |
| 33 | 3 |
| 30 | 3 |
| 39 | 3 |
| 32 | 3 |
| 25 | 3 |
| 41 | 3 |
| 24 | 3 |
| 49 | 3 |
| 43 | 3 |
| 9 | 3 |
| 20 | 3 |
| 32 | 3 |
| 14 | 3 |
| 14 | 3 |
| 13 | 3 |
| 13 | 3 |
| 53 | 3 |
| 11 | 3 |
| 16 | 3 |
| 21 | 3 |
| 21 | 3 |
| 46 | 3 |
| 21 | 3 |
In: Statistics and Probability
Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings
REGION ID
1= Crete
2=Southern Aegean Islands
3=Ionian Islands
| Total_Rooms | Region_ID |
| 412 | 1 |
| 313 | 1 |
| 265 | 1 |
| 204 | 1 |
| 172 | 1 |
| 133 | 1 |
| 127 | 1 |
| 322 | 1 |
| 241 | 1 |
| 172 | 1 |
| 121 | 1 |
| 70 | 1 |
| 65 | 1 |
| 93 | 1 |
| 75 | 1 |
| 69 | 1 |
| 66 | 1 |
| 54 | 1 |
| 68 | 1 |
| 57 | 1 |
| 38 | 1 |
| 27 | 1 |
| 47 | 1 |
| 32 | 1 |
| 27 | 1 |
| 48 | 1 |
| 39 | 1 |
| 35 | 1 |
| 23 | 1 |
| 25 | 1 |
| 10 | 1 |
| 18 | 1 |
| 17 | 1 |
| 29 | 1 |
| 21 | 1 |
| 23 | 1 |
| 15 | 1 |
| 8 | 1 |
| 20 | 1 |
| 11 | 1 |
| 15 | 1 |
| 18 | 1 |
| 23 | 1 |
| 10 | 1 |
| 26 | 1 |
| 306 | 2 |
| 240 | 2 |
| 330 | 2 |
| 139 | 2 |
| 353 | 2 |
| 324 | 2 |
| 276 | 2 |
| 221 | 2 |
| 200 | 2 |
| 117 | 2 |
| 170 | 2 |
| 122 | 2 |
| 57 | 2 |
| 62 | 2 |
| 98 | 2 |
| 75 | 2 |
| 62 | 2 |
| 50 | 2 |
| 27 | 2 |
| 44 | 2 |
| 33 | 2 |
| 25 | 2 |
| 42 | 2 |
| 30 | 2 |
| 44 | 2 |
| 10 | 2 |
| 18 | 2 |
| 18 | 2 |
| 73 | 2 |
| 21 | 2 |
| 22 | 2 |
| 25 | 2 |
| 25 | 2 |
| 31 | 2 |
| 16 | 2 |
| 15 | 2 |
| 12 | 2 |
| 11 | 2 |
| 16 | 2 |
| 22 | 2 |
| 12 | 2 |
| 34 | 2 |
| 37 | 2 |
| 25 | 2 |
| 10 | 2 |
| 270 | 3 |
| 261 | 3 |
| 219 | 3 |
| 280 | 3 |
| 378 | 3 |
| 181 | 3 |
| 166 | 3 |
| 119 | 3 |
| 174 | 3 |
| 124 | 3 |
| 112 | 3 |
| 227 | 3 |
| 161 | 3 |
| 216 | 3 |
| 102 | 3 |
| 96 | 3 |
| 97 | 3 |
| 56 | 3 |
| 72 | 3 |
| 62 | 3 |
| 78 | 3 |
| 74 | 3 |
| 33 | 3 |
| 30 | 3 |
| 39 | 3 |
| 32 | 3 |
| 25 | 3 |
| 41 | 3 |
| 24 | 3 |
| 49 | 3 |
| 43 | 3 |
| 9 | 3 |
| 20 | 3 |
| 32 | 3 |
| 14 | 3 |
| 14 | 3 |
| 13 | 3 |
| 13 | 3 |
| 53 | 3 |
| 11 | 3 |
| 16 | 3 |
| 21 | 3 |
| 21 | 3 |
| 46 | 3 |
| 21 | 3 |
In: Statistics and Probability
In: Accounting
In: Accounting
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.
| Month |
Occupancy-Days |
Electrical Costs | |||
| January | 2,710 | $ | 5,270 | ||
| February | 3,600 | $ | 6,205 | ||
| March | 860 | $ | 2,150 | ||
| April | 2,170 | $ | 4,350 | ||
| May | 4,200 | $ | 7,160 | ||
| June | 1,530 | $ | 3,825 | ||
| July | 4,110 | $ | 7,050 | ||
| August | 4,060 | $ | 6,925 | ||
| September | 1,980 | $ | 4,090 | ||
| October | 1,160 | $ | 2,900 | ||
| November | 1,210 | $ | 3,025 | ||
| December | 2,480 | $ | 4,910 | ||
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.)
In: Accounting