CASE ANALYSIS: ABC HOTEL has 450 rooms. It has a STANDARD ROOM of 200, 40% DE LUXE ROOM,50 EXECUTIVE SUITE,15 BUSINESS ROOMS AND the REST ARE ALL PRESIDENTIAL SUITE. History shows that: a. 5% of the Standard rooms are under maintenance and cannot be sold for the day. b. 75 of the standards rooms were given to HRTM THIRD YEAR inclusive of meal and transportation package. c. 25% of Standard rooms were given to Philippine Airlines Employees for ther Valentine's party d. Employees of AAA Hotel got 50 of the De luxe room e. 30 rooms of the De luxe were given to SPUP HRTM Faculties. f.50% of the executive suite were given to SMB Corporation's Executive officers. g. 6% of the executive suite are Out of Order h. 100% of the Business Room were given to SPUP Sisters who booked 1 month in advance. I. 2 presidential suites were given to Ambassadors of North Korea and given the Membership rate of 15%. FOLLOWING RATES ARE OFFERED: A. WALK IN RATE --3% B.GOVERNMENT RATE—10% C. ADVANCE PURCHASED RATE---5% D. GROUP RATE---8% E. CORPORATE RATE—5% F. INDUSTRY RATE-- 6% G. AIRLINE RATE--- 3% H. EMPLOYEE RATE—50% I. PACKAGE RATE—5% ROOM RATES ARE THE FOLLOWING: A. STANDARD ROOM----10,000 B. DE LUXE ROOM--------15,000 C. EXECUTIVE SUITE----25,000 D. BUSINESS ROOM-----20,000 E. PRESIDENTIAL SUITE—55,000 FIND: 1. 2. 3. 4. 5.
HOTEL'S TOTAL SALES HOTEL'S ADR HOTEL'S GROSS % OCCUPANCY HOTEL'S NET % OCCUPANCY GROSS % OCCUPANCY OF STANDARD ROOM,DELUXE,EXECUTIVE,BUSINESS AND PRESIDENTIAL SUITE 6. ROOM RATE DESIGNATION OF EACH OCCUPANT