Questions
Here is the ORIGINAL data of the Sport Hotel project: 1. Projected outflows First year (Purchase...

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...

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

  • 15 cases of detergent at $90 each
  • 15 cases of neutralizer at $65 each
  • 16 cases of softener at $31 each
  • 7 pails of bleach at $7.50 each
  • 1 bucket of starch at $13.50 each

In the Laundry Room

  • 5.75 cases of detergent
  • 2.25 cases of neutralizer
  • 8.50 cases of softener
  • 0.50 pails of bleach
  • 0.25 buckets of starch

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:

  • beginning inventory on May 1st was $6,932
  • purchases in May totaled $12,883
  • food transferred from main storeroom was $61,315
  • food transferred to other outlet was $114
  • entertainment and promotion checks totaled $2,010
  • management signed checks were $691
  • documented food spoilage was $139
  • food for employee meals was $5,795
  • happy hour hors d’oeuvres was $2,040
  • ending inventory on May 31st was $6,318

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...

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...

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...

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...

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...

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

Given the information below find net profit/loss in dollars for the month of June Guest Hotel...

Given the information below find net profit/loss in dollars for the month of June

Guest Hotel Inc.

Income Statement

for the period ending June 30, 2019

Sales
Food 193,864
Beverage 87,408
Total Sales -
Cost of Sales
Food 74,381
Beverage 28,467
Total cost of goods sold -
Gross Profit -
Controllable Expenses
Salaries & Wages 112,112
Occupancy 36,875
Office & General 14,642
Utilities 9,170
Transportation 7,472
Kitchen supplies 5,715
Professional fees 5,257
Advertising 8,088
Insurance 10,673
Vehicle 5,724
Total Controllable Expenses -
Net Profit / Loss -
Your Answer:

In: Accounting

Given the information below find gross profit percentage for the month of June ( do not...

Given the information below find gross profit percentage for the month of June ( do not include % sign)

Guest Hotel Inc.

Income Statement

for the period ending June 30, 2019

Sales
Food 212,323
Beverage 77,776
Total Sales -
Cost of Sales
Food 73,046
Beverage 27,691
Total cost of goods sold -
Gross Profit -
Controllable Expenses
Salaries & Wages 113,286
Occupancy 35,130
Office & General 12,778
Utilities 10,441
Transportation 5,250
Kitchen supplies 5,746
Professional fees 6,300
Advertising 10,215
Insurance 12,178
Vehicle 6,699
Total Controllable Expenses -
Net Profit / Loss -
Your Answer:

In: Accounting

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of...

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