Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Brent Smithson, owner of the Lakeland Hotel, requests your assistance with forecasting sales for the first quarter of 20X5. His 200-room hotel's sales during January-March

Brent Smithson, owner of the Lakeland Hotel, requests your assistance with forecasting sales for the first quarter of 20X5. His 200-room hotel's sales during January-March of 20X4 were as follows: January February March Pro 2009 Number of Days 31 29 31 Pd. Occ. % 80 082 78 81 0001 ADR $150 148 152 Room Sales $744,000 669,552 763,344 Brent believes that room sales will increase by one percentage point in each month and that the ADR should increase by $2 over the rate achieved in 20X4. Assume that total revenue consists of room sales and miscellaneous income. Required: 1. Forecast the expected number of room sales (units) for each month. 2. Forecast the room sales for each month. 3. If miscellaneous income is 5 percent of total revenue, forecast the miscellaneous income for each month.
image text in transcribed
Brent Smithson, owner of the Lakeland Hotel, requests your assistance with forecasting sales wer the ADR should increase by $2 over the rate achieved in 20X4. Assume that total revenue consists of room sales and miscellaneous income. Required: 1. Forecast the expected number of room sales (units) for each month. 2. Forecast the room sales for each month. 3. If miscellaneous income is 5 percent of total revenue, forecast the miscellaneous income for each month

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analytics For Auditing Using ACL

Authors: Alvin A. Arens

4th Edition

0912503629, 978-0912503622

More Books

Students also viewed these Accounting questions