Excel
Solving for %
Equations
Accounting
Operations
100
How do you begin an equation in a cell?
=
100

How do you solve for Food Cost %? 

Food cost / Food sales
100
How do you solve for ADR?

Total Room Rev / Total # Rooms Sold

100
What is accounting?

A system for compiling and reporting an organization's monetary information for making economic decisions.

100
What is Financial Analysis?

The assessment of businesses monetary affairs, financial statements, budgets, and other finance-related reports for decision making purposes.

200
How many decimal places do we use for %?
Two decimal places
200
How do you solve for beverage cost %?
Beverage cost / Beverage Sales
200
How do you solve for RevPAR?

Total Room Rev / Total # Rooms Available

200
What is Cost Accounting?

A subdivision of Managerial Accounting, which focuses on cost control.

200
What is Spreadsheet Modeling?

Financial statements provides a simplified way to use Microsoft Excel or any other spreadsheet to create and analyze financial statements.

300
What is a function?
An equation set up in Excel
300
How do you solve for Total Cost %?
Total Cost of Sales / Total Sales
300
How do you find total rooms sold?

Occupancy rate * Total # Rooms Available

300
What is Financial Accounting?

Focuses on reporting an organization's transaction, performance, and financial position.

300
What are Financial Reports?

Are based on the reading and understanding of numbers. Some of the more common financial reports that are based on the comparison of numbers of one specific period to another include (1) financial statements (2) forecast and (3) budgets.

400
What key freezes cells in a formula?
F4
400
How do you solve for Food Sales %?
Food sales / Total sales
400
How do you solve for Revenue?

Av Customer Expenditure * Volume (# cus served)

400
What is Managerial Accounting?

Is based on the identification, analysis, and interpretation of historical and/or projected financial data, which are used by the management for making daily and future operational plans.

400
What are Revenue Centers?

In the hospitality industry are operating departments that produce revenues (sales) by providing products and/or services that generate revenue to clients.

500
What symbols show when a value is too large for the cell?
####
500
How do you solve for Expense %?
Expense / Total Sales
500
How do you solve for Net Profit before tax?

Rev - COGS

500
What is Profit Maximization? 

One of the major objectives of business owners. The words profit, income, and earnings are the same and can be used interchangeably.

500
What are Cost or Expense Centers?

In the hospitality industry are the staff departments that support the operating departments that generate sales.