Standard Report Viewing

To simply view the standard Trends® data table:
-Select a Property Type.
-Select 2018 under Year (to view 2019 Trends® report).
-From the Preconfigured Report dropdown list, select the type of report you wish to view (these are the reports traditionally presented in the Trends® book. See sample reports by clicking Here .
-Hit View Report in the lower right corner.
-Your report will be displayed at the bottom of the page.
-If you wish to save this report, name the report (Report Name) at the top of the page, and hit Save Trends Report.
-If you wish to view the report in Excel for exporting, or copying, hit Export to Excel.

Customized Standard Report Viewing

If there are specific property types, geographic regions, property size (room count) and ADR categories that you would like to view, you can create a Custom Trends® report.
-Select a Property Type.
-Select 2018 under Year (to view 2019 Trends® report).
-Select the Create Your Own.
-Select the type of Report Type you wish to view
-Select the Geographic Region, and/or Property Size, and/or Rate Group categories you wish to view.
-Select which Metrics you wish to view ($PAR, $POR, Percent of Revenue, Change from Prior Year).
-Hit View Report in the lower right corner.
-Your report will be displayed at the bottom of the page.
-If you wish to save this report, name the report (Report Name) at the top of the page, and hit Save Trends Report.
-If you wish to view the report in Excel for exporting, or copying, hit Export to Excel.

Comparative Benchmarking Using Create Trends®

If you wish to compare the performance of your property to the benchmarks provided in the Trends® report, you can display the performance data for your property on any standard or customized report. Once your standard or customized report is run using the instructions above:
-Select the appropriate property name from the dropdown menu entitled Want to See How Your Property Compares?, and then hit View Report. Any data that you have already entered into the CBRE PIP system will be listed. You will not have access to any individual property data submitted by another party.
-For you to prepare a Custom Create Trends® report, we need your permission to upload your 2018 P&L data to your secure account on the PIP. Your property data will only be viewable by you, after you have logged in and provided your credentials. To provide your permission, please contact Gary McDade at gary.mcdade@cbre.com.

For a more refined custom benchmarking report, please visit Benchmarker under the Property Analytics section on the menu on top of any PIP page.

If you have any questions, or need assistance, please contact Client Services at websales@cbre.com.


All Departments

-Salaries and Wages – Non-Management: Cash Payments for Regular and Overtime Work - Staff level, Mostly hourly employees.
-Salaries and Wages – Management: Cash Payments for Regular and Overtime Work - Management level, Mostly salaried employees.
-Service Charge Distribution: Cost of service charges paid through hotel payroll system.
-Contract/Leased/Outsourced Labor: Gross cost associated with shared staffing arrangements that are supported by a formal agreement.
-Bonuses and Incentives: Contractual and incentive bonuses designed to drive revenue, guest satisfaction, or profits.
-Unassigned Payroll: Any payroll costs not assigned to the previous five categories.
-Payroll-Related Expenses: Payroll Taxes, Health Insurance, Workers' Compensation, --Employees' Meals, Vacation, Holiday and Sick Pay.

Rooms Department
-Rooms Revenue: Guest Room Rentals, No-Show Charges, Early Departure and Late Checkout Fees, Charges for Rollaway Beds and Cribs, Day-Use Rooms, Pet Fees, Mandatory Service and Surcharges (Not Resort Fees)
-Laundry, Linen, Supplies: Paper and Other Supplies for Guests, Cleaning Supplies, Uniforms, Office Supplies, Decorations, Small Equipment, Washing/Replacement of Linens.
-Remuneration paid to agents for securing transient or group business. Commissions based on all revenue, not just rooms revenue.
-Reservation Expense: Fees for Chain Reservation Services, Cost of Internet Sites Dedicated to Reservations. Non-transactional technology system costs are not included in this line item.
-Training: Non-Payroll Costs that can be Directly Attributable to Training Employees in this Department.
-Complimentary Services, Gifts, F&B, and In-Room Entertainment: Newspapers, Fruit Baskets, Breakfast and Evening Receptions Provided to Guests on a Complimentary Basis, Cable and Satellite TV.

Food and Beverage Department
-Food Revenue – Venues: Food and Non-Alcoholic Beverages Served in a Bar or Restaurant.
-Food Revenue – In-Room Dining: Food and Non-Alcoholic Beverages.
-Food Revenue – Mini-Bar: Packaged Food and Snacks, Soft Drinks and Bottled Water.
-Food Revenue – Banquet: Food and Non-Alcoholic Beverages.
-Beverage Revenue – Venues: Alcoholic Beverages Served in a Bar or Restaurant.
-Beverage Revenue – In-Room Dining: Alcoholic Beverages.
-Beverage Revenue – Mini-Bar: Alcoholic Beverages
-Beverage Revenue – Banquet: Alcoholic Beverages
-Other Revenue – Function Room Rental and Set-Up Charges: Charges for Use of Public Rooms, Charges for the Set-Up of Tables, Chairs, etc…
-Other Revenue – Audiovisual Rental: Charges for Use of Audiovisual Equipment (Rented or Hotel Owned).
-Other Revenue – Surcharges and Service Charges: Mandatory Charges in Lieu of Tips.
-Other Revenue – Other: Cover Charges, Non Food and Beverage Items Sold in the Guest Rooms.
-Cost of Sales – Food: Cost of Food and Non-Alcoholic Beverages Served to Guests, Spoilage, Waste and Spillage (Net of Employees' Meal Cost).
-Cost of Sales – Beverage: Cost of Alcoholic Beverages Served to Guests, Waste and Spillage.
-Cost of Sales – Audiovisual: Rental Costs Associated with Audiovisual Services.
-Cost of Sales – Miscellaneous: Other cost of sales not associated with Food, Beverage, or Audiovisual.
-Laundry, Linen, Supplies: Costs Associated with Laundry, Linen, China, Glassware, Silverware, Utensils, Paper and Cleaning Supplies, Office Supplies, Menus, Uniforms, Decorations.
-Training: Non-Payroll Costs that can be Directly Attributable to Training Employees in this Department.

Other Operated Departments
-Telecommunications: Revenues Associated with Telephone and Faxes Throughout the Hotel, and the direct Cost of Sales. Does not include Labor or System Expenses.
-Laundry and Valet: Revenues and Costs Associated with Hotel-Operated Guest Laundry and Valet Service.
-Gift Shop/Retail: Revenues and Costs Associated with Hotel-Operated Gift and Retail Shops.
-Golf: Revenues and Costs Associated with Hotel-Operated Golf Facilities.
-Other Recreation: Revenues and Costs Associated with Hotel-Operated Other Recreational Facilities.
-Spa: Revenues and Costs Associated with Hotel-Operated Spa.
-Health Club: Revenues and Costs Associated with Hotel-Operated Health Club.
-Movie Rental: Revenues and Costs Associated with In-Room Movies.
-Garage/Parking: Revenues and Costs Associated with Operation of Parking Facilities.
-Internet Connectivity: Revenues Associated with Internet Connectivity Throughout the Hotel, and the direct Cost of Sales. Does not include Labor or System Expenses.

Miscellaneous Income
-Space Rental and Concessions: Amounts Derived from Rentals of Stores, Offices, Kiosks, etc.
-Commissions: Amounts Derived from Third Parties Offering Various Services throughout the Property.
-Cancellation and Attrition Penalties: Penalties Charged for Unauthorized Cancellation of Meetings, Parties, Banquets, etc.
-Resort Fees: Mandatory Fees Typically Charged to Cover Hotel Services and Amenities.
-Other Income: Amounts Derived from Interest, Cash Discounts for Prompt Payment, Breakage, Proceeds from Business Interruption Insurance, Guest Foreign Exchange Gains (Losses).

Administrative and General
-Credit Card Commissions: Commissions Paid to Credit Card Companies for Processing Credit Card Transactions.
-Provision for Doubtful Accounts: Charges Recorded to Provide for the Possible Loss on Accounts and Notes Receivable.
-Legal and Professional Fees: Costs for Attorneys, Outside Auditors and Accountants, Consultants, etc.
-Training: Non-Payroll Costs that can be Directly Attributable to Training Employees in this Department.

Information and Telecommunications
-Cost of Service – Phone: Cost of Phone Service for Administrative and Complimentary Guest Use. Includes Cost of Cell Phones.
-Cost of Service – Internet: Cost of Internet Service for Administrative and Complimentary Guest Use.
-System Expenses – Operated Departments: Information System Expenses for the Rooms, Food and Beverage, and Other Operated Departments.
-System Expenses – Undistributed Departments: Information System Expenses for the Administrative & General, Information & Telecommunications, Sales and Marketing, Maintenance, and Utilities Departments.
-Training: Non-Payroll Costs that can be Directly Attributable to Training Employees in this Department.

Sales and Marketing Department
-Franchise Royalty: All Fees Charged by a Franchisor Except Those Related to National Advertising, Loyalty Programs and Reservations.
-Franchise Advertising and Marketing Assessment: Costs Paid to a Franchise or Affiliation Entity for the Purpose of Advertising on a National or Regional Basis.
-Loyalty Programs and Affiliation Fees: Costs Associated with Programs to Build Guest Loyalty, Including any Costs Associated with Administering the Programs.
-Advertising/Media: All Costs Associated with the Design, Production, and Purchase of Advertising via Radio, TV, Print, and Internet.
-Training: Non-Payroll Costs that can be Directly Attributable to Training Employees in this Department.
-Website: Website Development and Maintenance, Content Management, Social Media, Responses to On-Line Customer Reviews, Search Engine Optimization.
-Promotion/Public Relations: Costs Associated with the Promotion of the Property Within the Community and Industry. Does not Include Advertising.


Property Operation and Maintenance
-Contract Services: Maintenance and Repair Services Provided by Outside Companies Under a Contractual Agreement (Contract Services, Elevator, Trash Removal, Life Safety).

Utilities
-Electricity: Cost of Electricity Provided by Outside Producers.
-Water/Sewer: Cost of Water, Including Chilled Water, and Sewer Services.
-Steam: Cost of Steam Provided by Outside Producers.
-Gas/Fuel: Cost of Gas, Oil and Other Fuels Provided by Outside Producers.
-Other: Other Costs Associated with Utility Services, Including Utility Taxes.

Management Fees
-Base Fee: Management Fees Computed as a Fixed Amount or a Percentage of Revenues or Profit.
-Incentive Fee: Management Fees Contingent upon Achieving Certain Pre-Defined Levels of Profitability.

Non-Operating Income and Expenses
-Non-Operating Income: Income Generated by the Facility not Associated with Operations or Managed by the Operator. Cost Reovery Income. Rooftop Antenna Lease. Some Commercial Leases.
-Real Estate, Personal, and Other Taxes: Taxes Assessed Against Real and Personal Property. Professional Fees Incurred in Property Tax Related Matters. Business/Occupation Taxes not Passed on to Customers.
-Insurance: Insurance Protection of the Real and Personal Property of the Hotel. Liability Insurance and Costs Incurred as a Result of Co-Insurance.
-Rent: Land and Building Leases. Property and Equipment, if Purchased, Would Have Been Capitalized.

Statistics
-Occupancy: Rooms Sold divided by Rooms Available
-Average Daily Rate: Total Rooms Revenue divided by Rooms Sold
-RevPAR: Total Rooms Revenue divided by Rooms Available
-Average Size: Daily Rooms Available

Trends®