Tm 445 Quiz 2

Question 0

Retention or flow through is the percentage or formula that identifies how expenses and profits are expected to change with the given changes in expenses

Answer 0

False- changes in revenue

Question 1

In room televisions are examples of

Answer 1

CapX inventory items

Question 2

The p&l statement is prepared during the night audit and collects and reports actual revenue information if the precious day

Answer 2

False- the daily revenue report is prepared during night audit

Question 3

A man hour is defined as

Answer 3

The number if hours one employee works in performing his or her job responsibilities

Question 4

Labor productivity is measured how

Answer 4

By using man hours per room sold rooms cleaned per shift and or man hours per customer

Question 5

Wage cost percentage compares the wage cost in dollars to corresponding profit in dollars

Answer 5

False-wage cost percentage compares the wage cost in dollars to the corresponding REVEnUe

Question 6

What is a shoulder night?

Answer 6

A shoulder night is the number of group rooms sold per night before the peak night(front side) or after the peak night (back side).

Question 7

What is slippage?

Answer 7

Slippage is the difference between expected or blocked group rooms for each night in a group room block and the actual number of rooms sold for each night in a group room block.

Question 8

What is booking pace?

Answer 8

Booking pace is the current rate at which reservations are being received for a specific DOA.

Question 9

What system is DOA the focus point?

Answer 9

DOA is the focus point of yield management systems.

Question 10

What is a pick-up?

Answer 10

A pick up is the number if actual room reservations made by day for a group room block compared to the number of group rooms blocked for that night. It also included the pace at which actual reservations are being made for a specific day and the percentage of actual room reservations made compared to the group room block for the day.

Question 11

What is bench rate?

Answer 11

Bench rate is the base room rate that a hotel wants to achieve and sell to the public.

Question 12

Zero based budgeting is a bottom up budgeting approach

Answer 12

True

Question 13

Goal based budgeting is a bottom up budgeting approach-false

Answer 13

False

Question 14

Pp&e is NOT the acronym for property profit and expenses

Answer 14

Pp&e stands for property plant and equipment

Question 15

Budget is the formal business and financial plan for a business for one year

Answer 15

True

Question 16

Excel functions as a simple database, allowing easy manipulation of data to include search and sort etc

Answer 16

True

Question 17

The small black square at the lower right corner of a cell that can be used to drag and copy is known as the fill handle

Answer 17

True

Question 18

Don’t alignment and number are excel tools

Answer 18

True

Question 19

Fx indicates the function took in excel

Answer 19

Fx not fs means function

Question 20

What are functions?

Answer 20

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order or structure

Question 21

What does AND do?

Answer 21

AND returns TRUE if all arguments are TRUE; returns FALSE if one or more argument is false

Question 22

What does COUNTIF do?

Answer 22

Counts the number of cells within a range that meets the given criteria

Question 23

What does IF do?

Answer 23

IF returns one value if a condition you specify evaluates to true and another value if it evaluates to FALSe

Question 24

what is SUMIF?

Answer 24

SumIF adds the cells specified by a given criteria

Question 25

What is a MEDIAN?

Answer 25

MEDIAN is the number in the middle if a set of numbers

Question 26

What is MODE?

Answer 26

MODE is the most frequent number used

Question 27

What is a document on excel called?

Answer 27

A document in excel is known as a workbook

Question 28

Budget is the formal business and financial plan for a business for one year.

Answer 28

True