Advance Hospitality and Diploma Management: Hotel AET Project Report

This report provides a comprehensive analysis of a project management plan for Hotel AET, focusing on roster development, sales data, and payroll cost calculations. The report includes customer projections for two weeks, detailing lunch, dinner, and tea service demands. A roster is created based on 8-hour shifts, and the total sales for each week are calculated, followed by payroll cost estimations. Furthermore, the report examines the impact of sales increases on payroll expenses, evaluating the effectiveness of roster monitoring. It also provides insights on ways to improve the roster development process, such as optimizing employee hours and allocation, and includes relevant references to support the analysis.

Running head: ADVANCE HOSPITALITY AND DIPLOMA MANAGEMENT
Advance Hospitality and Diploma Management
Name of Student
Name of University
Author Note

1
ADVANCE HOSPITALITY AND DIPLOMA MANAGEMENT
Contents
.........................................................................................................................................................1
Project Management Plan for Hotel AET........................................................................................2
Preparation of the roster for the fortnight for Hotel AET................................................................2
Calculation of the total sales per week............................................................................................4
Calculation of the payroll cost for 2 weeks.....................................................................................5
Calculation of the payroll costs with the addition of sales..............................................................6
Evaluation of monitoring of the effectiveness of rosters.................................................................6
Ways of improving the roster development process........................................................................6
References........................................................................................................................................7

2
ADVANCE HOSPITALITY AND DIPLOMA MANAGEMENT
Project Management Plan for Hotel AET
Preparation of the roster for the fortnight for Hotel AET
First Week Customer projection
Lunch Dinner Morning Tea Afternoon Tea
Monday 50 70 15 15
Tuesday 50 80 30 20
Wednesday 60 80 30 20
Thursday 80 90 20 30
Friday 100 120 30 35
Saturday 120 150 30 40
Sunday 100 130 30 30
Second Week Customer projection
Lunch Dinner Morning Tea Afternoon Tea
Monday 50 70 15 15
Tuesday 50 80 30 20
Wednesday 65 90 30 30
Thursday 85 100 20 30
Friday 100 130 30 35
Saturday 150 200 35 40
Sunday 130 150 30 30

3
ADVANCE HOSPITALITY AND DIPLOMA MANAGEMENT
It is seen that from the customer projection ratio the preparation of the roster fortnight is
calculated from the sales of the company in terms of the number of days worked and the shifting
time as well for the study. This roster is for 8hrs shift. So the preparation of the roster has been
defined below
From this diagram it is illustrated that the coverage from Mon-Friday at days it is 3. For
Afternoon it should be 2 and for nights it should be 1. The coverage for Saturday and Sunday
should be 2 days, 1 afternoon and 1 night.
From the diagram it is stated that he total resources required should be more than 7 and
the average hours per week to be covered should be 40 as well.

4
ADVANCE HOSPITALITY AND DIPLOMA MANAGEMENT
Calculation of the total sales per week
Total Sales in first week
Monday 1500 1
100
15 450
Tuesday 1500 2400 30 600
Wednesday 1800 2400 2400 2400
Thursday 2400 2
700
1200 900
Friday 3000 3
600
900 1050
Saturday
Sunday
3600 1
500
900 1200
3000 1
300
900 900
Total sales in 2nd week
Monday 1500 1
100
150 450

5
ADVANCE HOSPITALITY AND DIPLOMA MANAGEMENT
Tuesday 1200 2200 300 600
Wednesday 2200 1700 2100 2400
Thursday 2400 2
800
1200 900
Friday 3000 3
400
900 1050
Saturday
Sunday
3400 1
300
900 1200
3000 1
300
900 900
Calculation of the payroll cost for 2 weeks
The calculation of the payroll cost is dependent on the customer project or the total sales
per week. The total sales on first week is around is 44125. The total sales in the 2nd week should
be around 49675. So it is indicated that in the 2nd week there is increase in the sales to be taken
place. The increase in the sales is directly proportional with the payroll costs or the expenses of
the employees working in this company. It is seen that the payroll cost enhances by 17 percent if
the total sales gets added up for the customer projection and the budget to be developed.
Calculation of the payroll costs with the addition of sales
It is seen that the total sales in 1st week is 44125. The increase in sales with addition of 17
percent of ancillary costs to be included will be 7501.25. So the total; sales with the addition of
17 percent of the ancillary costs will be 51626.25.

6
ADVANCE HOSPITALITY AND DIPLOMA MANAGEMENT
It is seen that in the second week the total sales is 49675. The increase in sales with
addition of 17 percent is 8444.75. So the total sales with its increase are around 58119.75.
Evaluation of monitoring of the effectiveness of rosters
It is very much important that there should be the development and monitoring the
effectiveness of roisters to be made by BD corp. It is essential in monitoring the effectiveness of
the roster as for confirming that what should be the strength of manpower to be there for an
organization like BDD Corp which is a small sized organization (Ahmad Yei and Bujan 2013).
They do not have so much of internal staffs who would be providing high quality services to
them as well. The regular monitoring of the rosters will help in ensuring that there should be
ensuring that there should not be any lack of potential employees and each of the employees
were assigned the power of doing it according to their capabilities.
Ways of improving the roster development process
The ways of improving the roster development process should be the calculation of the
hours each and every employee should be distributed properly. It is also seen that the calculation
of the total number of employees and the proper allocation of time is also measured effectively
for improving the roster development process (Linoff and Berry 2011) .

7
ADVANCE HOSPITALITY AND DIPLOMA MANAGEMENT
References
Gupta, N. and Shaw, J.D., 2014. Employee compensation: The neglected area of HRM
research. Human Resource Management Review, 24(1), pp.1-4.
Ahmad, R., Yei, E.T.P. and Bujan, S., 2013. Relationship between Types of Benefit (leave, loan
and retirement plan) and Employees’ Retention. International Journal of Education
Research, 1(8).
Ingram, T.N., LaForge, R.W., Williams, M.R. and Schwepker Jr, C.H., 2015. Sales management:
Analysis and decision making. Routledge.
Agnihotri, R., Kothandaraman, P., Kashyap, R. and Singh, R., 2012. Bringing “social” into sales:
The impact of salespeople’s social media use on service behaviors and value creation. Journal of
Personal Selling & Sales Management, 32(3), pp.333-348.
Linoff, G.S. and Berry, M.J., 2011. Data mining techniques: for marketing, sales, and customer
relationship management. John Wiley & Sons.