Bonita Reya is the RM for the Mayfair hotel. She is comparing this February’s fo
ID: 2448539 • Letter: B
Question
Bonita Reya is the RM for the Mayfair hotel. She is comparing this February’s food andbeverage (F&B) sales to the F&B sales achieved at the hotel this past January. Sales wereup in all of Bonita’s revenue centers! The hotel has one dining room, a lounge, andaccounts separately for banquet food and banquet beverage (alcoholic beverage) sales.Bonita has collected the following sales data, but some are missing. Complete her salessummary, calculating your percentage answers to one decimal place, and then answer the questions that follow:
C
Need the answers to A,B and C
Mayfair Hotel F&B Revenue: February This Year versus January This Year Revenue Source February January $ Variance % Variance Dining room $ 18,000 $ 15,000 $ 3,000 20.00% Lounge $ 2,500 $ 1,500 $ 1,000 A Banquet food $ 29,000 $ 25,000 $ 4,000 16.00% Banquet bar $ 17,000 $ 15,000 $ 2,000 B Total F&B $ 66,500 $ 56,500 $ 10,000C
Explanation / Answer
Solution:
17.70%
(A). Lounge:
Varience % = Varience / January * 100
= 1,000 / 1,500 * 100
= 66.66%
(B). Banquet bar:
Varience % = Varience / January * 100
= 2,000 / 15,000 * 100
= 13.33%
(C). Total F&B:
Varience % = Varience / January * 100
= 10,000 / 56,500 * 100
= 17.70%
Mayfair Hotel F&B Revenue: February This Year versus January This Year Revenue Source February January $ Variance % Variance Dining room $ 18,000 $ 15,000 $ 3,000 20.00% Lounge $ 2,500 $ 1,500 $ 1,000 66.66% Banquet food $ 29,000 $ 25,000 $ 4,000 16.00% Banquet bar $ 17,000 $ 15,000 $ 2,000 13.33% Total F&B $ 66,500 $ 56,500 $ 10,00017.70%