1. Jerry Dickson has been approached by the franchise sales representative of a major hotel chain....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Jerry Dickson has been approached by the franchise sales representative of a major hotel chain. The sales representative is trying to interest Jerry in building one of the franchise brand's full-service hotels. The hotel will cost $8,000,000 to build and will consist of 200 rooms. Mortgage payments on the hotel will be $750,000 per year and other nonoperating expenses will be $250,000 per year. At an assumed 60% occupancy level, the rooma manager has calculated that payroll and related expenses and other expenses for rooms is $45 per room, and undistributed operating expenses related to operating the hotel are $1,000,000. The hotel is projected to make an operating income of $125,000 per year from the F&B department and $50,000 from all other non-rooms departments. Jerry is interested in the project if he can achieve a 12% return on the investment, assuming a 40% tax rate. a. Utilizing the Hubbart room rate formula, what is the room rate required for Jerry to meet his 12% investment target? b. Assume Jerry decided that, due to the potentially risky nature of this ventura, he required a 15% (not 12%) retum on his investment. What is the room rate required for Jerry to meet this more aggressive investment target? C. Assume the oucupancy rate estimated to be achieved by the franchise sales representative was 70% and this number was utilized to compute the Hubbart rate (rather than Jerry's more conservative 60%). What would the sales representative tel Jerry his ADR would have to be to achieve Jerry's 15% investment goals? d. Assume instead, that the food and beveraga operating income is astimated at $75,000 per year rather than $125,000. Using the 15% desired investment return and a 70% ocupancy rate, what new room rate would allow Jery to meet his investment goals? (Spreadsheet hint: Calculate question a. above first and type the answer for ADR in the cell provided at the bottom of the spreadsheet. For items b., c., and d., change only the numbers that are required in each question, and all the other numbers in the spreadsheet will change accordingly. Then, type the answers for ADR (as you go) in the cells provided at the bottom of the spreadsheet.) step 1. Calculate the hotel's target before-tax net income. Owner's investment ROI After-Tax Net Income After-Tax Net Income Tax Before-Tax Net Income Step 2. Calculate estimated nonoperating expenses. Mortgage Other Nonoperating Expenses Total Nonoperating Expenses Step 3. Calculate estimated undistributed operating expenses. Undistributed Operating Expenses Step 4. Calculate estimated operated departments income excluding rooms. F&B Operating Income Other Non-Rooms Income Total Non-Rocms Operating Income Step 5. Calculate the operated department income for rooms. Before-Tax Net Income Nonoperating Expenses Undistributed Operating Expenses Total Non-Roorms Operating Income Rooms Operated Department Income Step 6. Calculate the estimated rooms department revenues based on estimated occupancy. Rooms Days in Pericd Occupancy 45 Total Rocms 1. Jerry Dickson has been approached by the franchise sales representative of a major hotel chain. The sales representative is trying to interest Jerry in building one of the franchise brand's full-service hotels. The hotel will cost $8,000,000 to build and will consist of 200 rooms. Mortgage payments on the hotel will be $750,000 per year and other nonoperating expenses will be $250,000 per year. At an assumed 60% occupancy level, the rooma manager has calculated that payroll and related expenses and other expenses for rooms is $45 per room, and undistributed operating expenses related to operating the hotel are $1,000,000. The hotel is projected to make an operating income of $125,000 per year from the F&B department and $50,000 from all other non-rooms departments. Jerry is interested in the project if he can achieve a 12% return on the investment, assuming a 40% tax rate. a. Utilizing the Hubbart room rate formula, what is the room rate required for Jerry to meet his 12% investment target? b. Assume Jerry decided that, due to the potentially risky nature of this ventura, he required a 15% (not 12%) retum on his investment. What is the room rate required for Jerry to meet this more aggressive investment target? C. Assume the oucupancy rate estimated to be achieved by the franchise sales representative was 70% and this number was utilized to compute the Hubbart rate (rather than Jerry's more conservative 60%). What would the sales representative tel Jerry his ADR would have to be to achieve Jerry's 15% investment goals? d. Assume instead, that the food and beveraga operating income is astimated at $75,000 per year rather than $125,000. Using the 15% desired investment return and a 70% ocupancy rate, what new room rate would allow Jery to meet his investment goals? (Spreadsheet hint: Calculate question a. above first and type the answer for ADR in the cell provided at the bottom of the spreadsheet. For items b., c., and d., change only the numbers that are required in each question, and all the other numbers in the spreadsheet will change accordingly. Then, type the answers for ADR (as you go) in the cells provided at the bottom of the spreadsheet.) step 1. Calculate the hotel's target before-tax net income. Owner's investment ROI After-Tax Net Income After-Tax Net Income Tax Before-Tax Net Income Step 2. Calculate estimated nonoperating expenses. Mortgage Other Nonoperating Expenses Total Nonoperating Expenses Step 3. Calculate estimated undistributed operating expenses. Undistributed Operating Expenses Step 4. Calculate estimated operated departments income excluding rooms. F&B Operating Income Other Non-Rooms Income Total Non-Rocms Operating Income Step 5. Calculate the operated department income for rooms. Before-Tax Net Income Nonoperating Expenses Undistributed Operating Expenses Total Non-Roorms Operating Income Rooms Operated Department Income Step 6. Calculate the estimated rooms department revenues based on estimated occupancy. Rooms Days in Pericd Occupancy 45 Total Rocms
Expert Answer:
Answer rating: 100% (QA)
a The Hubbart Formula is a formula that can be used in hotel management It is used to determine the proper average rate to set for rooms in a given ho... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The Brandt Company has been approached by two different commercial paper dealers offering to sell an issue of commercial paper for the company. Dealer A offered to market an $8 million issue maturing...
-
A maintenance engineer has been approached by a supplier who promises less downtime for machines using its new molybdenum-based super lubricant. Of 120 machines maintained with the new lubricant,...
-
A Big 10 University has been approached by Wilson Sporting Goods. Wilson has developed a football designed specifically for practice sessions. Wilson would like to claim the ball will last for 500...
-
Allison is paid $1,520 per week. What is the amount of federal income tax withheld from Allisons paycheck under the following conditions? Use the percentage method table in the Appendix to this...
-
Two people see the same movie; one says it was average and the other says it was exceptional. What level of data are they using in these ratings? Discuss how the same movie could receive different...
-
For 2015, Everyday Electronics reported $22 5 million of sales and $18 million of operating costs (including depreciation). The company has $15 million of total invested capital. Its after-tax cost...
-
Using a CPU that runs an operating system that uses RMS, try to get the CPU utilization up to 100%. Vary the data arrival times to test the robustness of the system.
-
Azen Company reported net income of $190,000 for 2012. Azen also reported depreciation expense of $35,000 and a loss of $5,000 on the sale of equipment. The comparative balance sheet shows an...
-
Select three (3) Federal legislature (laws) affecting human resources management and describe each thoroughly.
-
Bear Park, a camping ground in the Lake District, has compiled the following financial information as of December 31, 2020. Instructions a. Determine Bear Parks net income for 2020. b. Prepare a...
-
2. List the areas of the curriculum for your State/Territory (or the Australian curriculum, if you wish) and identify which area/s you most enjoyed at school and which area/s you found less enjoyable...
-
Find the cardinal number of the indicated set. If n(A) = 40, n(B)=117, and n(AUB)=137, what is n(AB)?
-
Examine the intricate molecular machinery underlying the process of DNA replication in eukaryotic cells, elucidating the coordination of DNA polymerases, helicases, and DNA repair mechanisms to...
-
Assuming the sales price for Kayak was $306 per unit (instead of $244), how would the company allocate the 12,000 available machine hours between the two products so that it maximize its profits.
-
A rigid container and a piston contains 1L of R-134a at 100 o C and 3.6 MPa. In an isobaric quasi-equilibrium process, the gas expands to 1.2L. The control volume has a uniform cross section 0.5 m2...
-
Waylon's mother has just received notification that he will be fully reevaluated for special education services. This is the first time that Waylon has been fully reevaluated since qualifying for...
-
Describe the three capabilities of database management systems: data definition, data dictionary, and data manipulation language. Discuss the importance of creating and using a data dictionary with a...
-
Maria Castigliani is head of the purchasing department of Ambrosiana Merceti, a medium-sized construction company. One morning she walked into the office and said, The main problem in this office is...
-
Shirley will be graduating soon and is anticipating job offers from several national-level corporations. Depending on the company she joins, she could end up living in any of four different locations...
-
Construct three-period and four-period centered moving averages for the quarterly J. C. Penney sales in Exercise 18.67. Are there any other retailing companies for whom a four-period moving average...
-
The accompanying data describe the hourly wage rates (dollars per hour) for 30 employees of an electronics firm: Construct a frequency distribution and a histogram for these data. 22.66 24.39 17.31...
-
In Example 12.1, we introduced the Hong-Ou-Mandel interferometer and presented an analysis of thinking about the photons produced by the laser as classical electromagnetic waves. In this exercise, we...
-
In Sec.12.4.3, we motivated and introduced Bell's inequalities for unambiguous observation of quantum entanglement. There we demonstrated that a classical, random density matrix of two spins...
-
We had mentioned that from the partition function \(Z\), all possible thermodynamical quantities can be determined. In this problem, we will use the harmonic oscillator's partition function of Eq....
Study smarter with the SolutionInn App