Incorporate PSU reported occupancy rate and room rate and FY actual monthly revenue to calculate...

90.2K

Verified Solution

Question

Accounting

Incorporate PSU reported occupancy rate and room rate and FY actual monthly revenue to calculate more precise expectations of monthly revenue for FY16. What are your new precise expectation for FY16 revenue each month?

Occupancy rate FY2015 Rooms Occupied
July 0.559 -692465.96 3142
August 0.628 -537141.31 2878
September 0.559 -753740.85 3164
October 0.593 -1314158.6 3842
November 0.576 -632371 2806
December 0.347 -631695.6 899
January 0.460 -695961.8 2722
February 0.635 -693530.2 3750
March 0.713 -741844.95 3608
April 0.726 -1085463.3 3474
May 0.563 -839940.26 3439
June 0.758 -790909.95 4299
Occupancy rate FY2016
July 0.525 -687889.94 3344
August 0.481 -411488.49 3755
September 0.547 -918015.33 3234
October 0.642 -1223017.3 3548
November 0.485 -850248.99 3336
December 0.150 -699018.21 2076
January 0.452 -318315.32 2750
February 0.670 -685248.79 3429
March 0.603 -1016810.8 4263
April 0.600 -677455.54 4215
May 0.575 -816009.47 3367
June 0.743 -993703.93 4386

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students