Hospitality Finance
Module period 4.9, week , study year 2015 - 2016
Institute IHM / Hotel Management
Module Hospitality Operations (HOP)
Test IHM HOP Hospitality Finance
Date June 14th 2016
Location Stenden Test Facilities (Tentamenhal)
Time 11.30-14.00 hrs
Module Co-ordination Saskia Penninga / Wouter Cornelius
Name of student
Student number Signature
Group (A,B,C, etc) Resit Yes / No
Important notes for the student before making the test:
The score of this test will only be granted if the student is entitled to make this
test according to the Teaching and Examination Regulations (TER) of IHM.
The student brings his/her student card to the test. If not, the student has to identify
him/herself by means of an official identity card: passport or driving license. If a student
has no student card AND no identification he/she will not be admitted to the test.
The student fills in his/her name and correct student number on each page of the test
form. For answering the questions only the test paper can be used !!
This test consists of twenty five (20) short answer / essay questions with an average
score of 5 points each. Be aware that some pages of the test paper can be printed
double sided. When finished the student hands in the test and signs the attendance list.
Students can follow an objections procedure. If you want to object to any of the test
items, submit your objections within 5 days after the test to the module co-ordinators
and / or IHM exam committee ().
Good luck!
Information for the test office:
Tick form or open questions?
Tick form
Open questions
Fill out on test form
What kind of tick form
ABC T/F
Use of dictionary allowed?
NO – only the ones provided by IHM
Use of draft paper allowed?
Yes No
Use of other materials (such as calculator) allowed? Yes, a non-programmable calculator
,Questions Managerial accounting (12 questions)
All amounts in the 12 managerial account questions need to be rounded off on 2
decimals. Percentages need to be rounded off on 2 decimals as well. Rounding off
during calculations is not recommended, only at the end of calculations.
NAME: Relation number: Group / Resit SCORE:
1. The controller of hotel-restaurant Happy Together collected the following information for
2012: (max. 5 points)
Rooms revenues € 1,200,000
Food revenues € 1,000,000
Cost of Food ingredients (=cost of sales) € 350,000
Guest Supplies € 250,000
Salaries rooms € 400,000
Salaries Food € 200,000
Administration and General € 220,000
Utility costs € 180,000
Rent € 150,000
Insurance costs € 90,000
Calculate the departmental income food, the gross operating profit and the gross profit
food.
1. Departmental income Food Food rev. – Cost of food ingredients - salaries food
( 2 points) € 1,000,000 - € 350,000 – 200,000 = € 450,000
2. Gross operating profit for Revenues – Cost of food ingredients – Guest
total company.(2 points ) supplies- salaries – A&G – UC
€ 2,200,000 – 350,000 – 250,000 – 600,000 –
220,000 – 180,000 = € 600,000
3. Gross profit Food. (1 point) Food revenue – Cost of sales
€ 1,000,000 – 350,000 = € 650,000
2. The following table presents a rooms division manager’s budget preparation working
paper for October. Not all figures are calculated:
Budget Actual Budget Favourable(F)/
Variance Unfavourable(U)
Room revenue:
ADR € 150 € 139
Rooms sold 800 820
, TOTAL REVENUE
Guest supplies expense:
Rooms sold 800 820
Unit cost € 38 € 36
TOTAL GUEST SUPPLIES EXPENSES
Calculate the budget, cost, and quantity variance and indicate whether it is favourable
(F) or unfavourable (U):
Favourable(F)/
Unfavourable(U)
Budget Variance for
revenue. (800x150)-(820x139)=- 6020 U
( 1 point) U/F?
Price variance related to
revenue. (139-150)x820=-9,020 U
( 2 points ) U/F?
Quantity variance related to
expenses. (800-820)x38=-760 U
( 2 points ) U/F?
3. The Sea view Hotels Plc operates a 540-room hotel. The capital invested is € 35 mln(all
rooms related) and the company is expecting a net profit of 8% after paying (profit) tax
at the rate of 30%. They expect an average occupancy percentage of 60%. Rooms
departmental expenses are expected to amount to € 5 mln and the profits from other
departments are expected to be € 7mln. The overhead expenses are € 9 mln.
Calculate the AVERAGE ROOM RATE by applying the bottom up approach. (max 5 points)
8% x 35 mln = 2,800,000 is NET PROFIT AFTER TAX (1pt)
The pre-tax profit = 2,800,.7 = 4mln (2pt)
Total required sales 4mln + 5mln – 7mln + 9mln = 11mln
60% x 540 x 365 = 118,260 room nights per year (1pt)
ADR = 11mln / 118,260 = 93,02 (1pt)
4. Captain Hotels Plc’ has 2 different room types. 320 economy rooms of type A and 120
luxury rooms of type B. Type A rooms measure 22 square meters and type B rooms
measure 35 square meters. The occupancy percentages of the room types are 50% and
70% for types A and B respectively. Total yearly sales is expected to be € 7 mln.
What is the Average room rate for room type A as well as room type B? (max 5 points)
50% x 320 x 22m2 = 3520 m2
70% x 120 x 35m2 = 2940 m2
6460 m2 (1pt)
Daily sales 7mln / 365 = 19,178 (1pt)
Module period 4.9, week , study year 2015 - 2016
Institute IHM / Hotel Management
Module Hospitality Operations (HOP)
Test IHM HOP Hospitality Finance
Date June 14th 2016
Location Stenden Test Facilities (Tentamenhal)
Time 11.30-14.00 hrs
Module Co-ordination Saskia Penninga / Wouter Cornelius
Name of student
Student number Signature
Group (A,B,C, etc) Resit Yes / No
Important notes for the student before making the test:
The score of this test will only be granted if the student is entitled to make this
test according to the Teaching and Examination Regulations (TER) of IHM.
The student brings his/her student card to the test. If not, the student has to identify
him/herself by means of an official identity card: passport or driving license. If a student
has no student card AND no identification he/she will not be admitted to the test.
The student fills in his/her name and correct student number on each page of the test
form. For answering the questions only the test paper can be used !!
This test consists of twenty five (20) short answer / essay questions with an average
score of 5 points each. Be aware that some pages of the test paper can be printed
double sided. When finished the student hands in the test and signs the attendance list.
Students can follow an objections procedure. If you want to object to any of the test
items, submit your objections within 5 days after the test to the module co-ordinators
and / or IHM exam committee ().
Good luck!
Information for the test office:
Tick form or open questions?
Tick form
Open questions
Fill out on test form
What kind of tick form
ABC T/F
Use of dictionary allowed?
NO – only the ones provided by IHM
Use of draft paper allowed?
Yes No
Use of other materials (such as calculator) allowed? Yes, a non-programmable calculator
,Questions Managerial accounting (12 questions)
All amounts in the 12 managerial account questions need to be rounded off on 2
decimals. Percentages need to be rounded off on 2 decimals as well. Rounding off
during calculations is not recommended, only at the end of calculations.
NAME: Relation number: Group / Resit SCORE:
1. The controller of hotel-restaurant Happy Together collected the following information for
2012: (max. 5 points)
Rooms revenues € 1,200,000
Food revenues € 1,000,000
Cost of Food ingredients (=cost of sales) € 350,000
Guest Supplies € 250,000
Salaries rooms € 400,000
Salaries Food € 200,000
Administration and General € 220,000
Utility costs € 180,000
Rent € 150,000
Insurance costs € 90,000
Calculate the departmental income food, the gross operating profit and the gross profit
food.
1. Departmental income Food Food rev. – Cost of food ingredients - salaries food
( 2 points) € 1,000,000 - € 350,000 – 200,000 = € 450,000
2. Gross operating profit for Revenues – Cost of food ingredients – Guest
total company.(2 points ) supplies- salaries – A&G – UC
€ 2,200,000 – 350,000 – 250,000 – 600,000 –
220,000 – 180,000 = € 600,000
3. Gross profit Food. (1 point) Food revenue – Cost of sales
€ 1,000,000 – 350,000 = € 650,000
2. The following table presents a rooms division manager’s budget preparation working
paper for October. Not all figures are calculated:
Budget Actual Budget Favourable(F)/
Variance Unfavourable(U)
Room revenue:
ADR € 150 € 139
Rooms sold 800 820
, TOTAL REVENUE
Guest supplies expense:
Rooms sold 800 820
Unit cost € 38 € 36
TOTAL GUEST SUPPLIES EXPENSES
Calculate the budget, cost, and quantity variance and indicate whether it is favourable
(F) or unfavourable (U):
Favourable(F)/
Unfavourable(U)
Budget Variance for
revenue. (800x150)-(820x139)=- 6020 U
( 1 point) U/F?
Price variance related to
revenue. (139-150)x820=-9,020 U
( 2 points ) U/F?
Quantity variance related to
expenses. (800-820)x38=-760 U
( 2 points ) U/F?
3. The Sea view Hotels Plc operates a 540-room hotel. The capital invested is € 35 mln(all
rooms related) and the company is expecting a net profit of 8% after paying (profit) tax
at the rate of 30%. They expect an average occupancy percentage of 60%. Rooms
departmental expenses are expected to amount to € 5 mln and the profits from other
departments are expected to be € 7mln. The overhead expenses are € 9 mln.
Calculate the AVERAGE ROOM RATE by applying the bottom up approach. (max 5 points)
8% x 35 mln = 2,800,000 is NET PROFIT AFTER TAX (1pt)
The pre-tax profit = 2,800,.7 = 4mln (2pt)
Total required sales 4mln + 5mln – 7mln + 9mln = 11mln
60% x 540 x 365 = 118,260 room nights per year (1pt)
ADR = 11mln / 118,260 = 93,02 (1pt)
4. Captain Hotels Plc’ has 2 different room types. 320 economy rooms of type A and 120
luxury rooms of type B. Type A rooms measure 22 square meters and type B rooms
measure 35 square meters. The occupancy percentages of the room types are 50% and
70% for types A and B respectively. Total yearly sales is expected to be € 7 mln.
What is the Average room rate for room type A as well as room type B? (max 5 points)
50% x 320 x 22m2 = 3520 m2
70% x 120 x 35m2 = 2940 m2
6460 m2 (1pt)
Daily sales 7mln / 365 = 19,178 (1pt)
