Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could someone help me this question? Ratio Analysis As the new General Manager of the recently opened Georgian Lodge Resort a: Spa, you are feeling

Could someone help me this question?

image text in transcribedimage text in transcribedimage text in transcribed
Ratio Analysis As the new General Manager of the recently opened Georgian Lodge Resort a: Spa, you are feeling pretty good about your success over the first year of operation. The Lodge is a 225 room independantly owned hotel located on the shores of Georgian Bay. The property has a Restaurant with an attached Lounge serving Breakfast, Lunch, Dinner, and a late night Lounge menu, as well as a Spa with a Pool & Hot Tub, offering Massage, Hairstylists & Estheticians. The accounting team has now submitted their final numbers for the first year's perfomance, and it is your responsibility to intrepret the numbers, determine your level of success, a strategy for the future along with performance targets for the following year. Total Room Nights Available (225 x 365) 8212 Total Rooms Occupied 51,10 Number of Guests 112,420 Housekeeping Costs 2,401,700 Rooms Revenue 6,387,500 Total Revenue from Hotel Guests 8,871,500 Restaurant Total Food Sales 985,500 Total Beverage Sales 328,500 Total Sales 1,314,000 Number of Covers 65700 Number of Seats in Restaurant 5475 Labour Cost 460,000 Food Cost 355,000 Beverage Cost 114,000 Spa Total Sales 1,170,000 Total # Spa Guests 29,230 Spa Repairs at Maintenance Costs 98,000 Spa Labour 475,000 Calculate the Following: Hotel Hotel Occupancy % Average Daily Rate (ADR) REVPAR Housekeeping Cost per Occupied Room (CPOR) Restaurant Average Check per Cover F&B Sales per Hotel Guest Seat Turnover Food Cost % Beverage Cost % Overall F&B Cost % Labour Cost % Gross Income $$$ Contributory Income $$$ Gross Income % Contributory Income % Spa Contributory Income $$$ Contributory Income % Sales per Spa Guest Sales per Hotel GuestBased on the information provided, give an evaluation of the performance of the Room Division. Based on the information provided, give an evaluation of the performance of the Food & Beverage Division. Based on the information provided, give an evaluation of the performance of the Spa. What would you recommend as areas of focus, performance targets, and stratgies for year 2 of the operation

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

Intermediate Accounting

Authors: James D. Stice, Earl K. Stice, Fred Skousen

16th Edition

324376375, 0324375743I, 978-0324376371, 9780324375749, 978-0324312140

More Books

Students also viewed these Accounting questions