Building a Robust Data Foundation for Manpower Supply Forecasting in Tourism

Behind every smoothly running hotel, well-organized tour, or efficiently staffed airport lies a quiet but powerful process – manpower forecasting. And at the heart of that process sits something unglamorous yet absolutely essential: data. Without reliable, well-organized information about people, jobs, and skills, even the smartest forecasting model becomes guesswork. For a labour-intensive sector like tourism, where service quality directly shapes guest experiences, building a strong data foundation isn’t optional. It’s the difference between proactive workforce planning and constant firefighting.

Why data is the backbone of supply forecasting 🔗

Supply forecasting is essentially about answering one question: how many people, with what skills, will be available to work in tourism over the next few years? You cannot answer that question with intuition alone. It requires a steady stream of accurate information about who is entering the workforce, who is leaving, who is being trained, and how internal employees are moving through their careers.

The challenge is that manpower forecasting often suffers more from missing reliable time-series data than from a lack of sophisticated models. Forecasters frequently have to rely on judgemental estimates because the underlying database is patchy. This is especially true in tourism, where the workforce is fragmented across hotels, restaurants, travel agencies, transport providers, and tour operators. The first job of any serious forecasting exercise, therefore, is to build and maintain a clean, comprehensive data base.

This data base operates on two distinct but connected levels – macro and micro. Each serves a different purpose, draws from different sources, and answers different planning questions.

The macro-level data base 🔗

Macro forecasting looks at the supply picture for the entire country, an industry segment, or a region. The audience for this data includes the Ministry of Tourism, state tourism boards, hospitality associations, and educational planners. Their concern is whether the country will have enough trained guides, chefs, front-office staff, travel consultants, and managers to support projected tourism growth.

For perspective on the scale involved, the travel and tourism sector employed nearly 42 million people in the financial year 2023. Planning for a workforce of that size demands a structured, multi-source information system at the national level.

Age at entry and age at exit 🔗

One of the foundational data points at the macro level is the age at which people enter and leave specific tourism occupations. This information is collected for every category of manpower – kitchen staff, housekeeping, front-office, tour guides, travel consultants, pilots, cabin crew, and so on.

For some jobs, like government tourism officers or public-sector hotel employees, age at entry and exit is largely fixed by service rules. For most private-sector tourism roles, however, these ages vary widely. A flight attendant may enter the profession at 22 and exit by 35, while a senior chef might enter at 25 and continue working into their 60s. Knowing this distribution helps planners estimate how many workers will retire, switch industries, or remain available over a forecast horizon.

Enrollment and out-turn from training institutions 🔗

Another critical macro input is the flow of students through hospitality and tourism education. This includes enrollment numbers in institutes of hotel management, food craft institutes, travel and tourism diploma programmes, culinary schools, and university-level tourism degrees. Equally important is the out-turn – how many students actually graduate each year and become available for employment.

Industry estimates suggest that the hospitality industry faces a shortfall of around 150,000 trained professionals, a gap that can only be addressed if educational institutions and forecasters share data continuously. Without this stream of information, training capacity quickly falls out of sync with industry demand, leading to either oversupply in some skill areas or chronic shortages in others.

Attrition and wastage rates 🔗

People don’t stay in the workforce indefinitely. They retire, change careers, migrate to other countries, take career breaks, or move into unrelated industries. Collectively, this loss is captured under attrition or wastage rates, and tourism is particularly vulnerable here.

The Indian hospitality sector has long battled high turnover. Reports indicate that attrition has risen due to limited workforce quality and rising competition for trained employees from sectors like aviation. Without reliable attrition data segmented by occupation, age group, and region, planners cannot estimate net additions to the workforce – they only see the gross numbers entering, not the silent exit.

Other macro-level inputs 🔗

A complete macro database also includes labour force participation rates, gender composition, regional distribution of tourism employment, migration patterns, and projections of foreign tourist arrivals. The Ministry of Tourism, the National Sample Survey Office, the World Travel & Tourism Council, and industry bodies like the Federation of Hotel & Restaurant Associations of India together provide most of this information. The forecaster’s role is to integrate these sources, reconcile inconsistencies, and convert them into usable inputs.

The micro-level data base: the Manpower Information System 🔗

Micro forecasting happens inside an enterprise – a hotel chain, an airline, a tour operator, or a restaurant group. Here, the forecaster is concerned with internal supply: how many of the company’s current employees will still be on the rolls one, two, or five years from now, and what their capabilities will be.

This is where a structured Manpower Information System (MIS) becomes indispensable. As one detailed framework explains, a well-defined Manpower Information System is needed at the enterprise or company level for micro forecasting. The MIS is essentially a comprehensive employee database structured around several modules. Let’s walk through each.

Personal data module 🔗

The personal data module captures the basics for every employee – name, date of birth, gender, marital status, contact information, address, educational qualifications, languages spoken, certifications, and identification details. While this seems administrative, it forms the demographic backbone of the system. Age distribution, for example, is critical for predicting retirements and succession needs. Educational background helps map skill clusters available in the company.

Recruitment module 🔗

This module records the entire hiring journey of every employee – date of joining, recruitment source (campus, walk-in, referral, agency), selection method, initial designation, starting compensation, and probation outcomes. Over time, this builds a rich picture of which recruitment channels yield the most reliable hires, how long new joiners take to stabilize, and which job categories suffer from the highest early-stage attrition.

Job experience module 🔗

People do not stay frozen in their starting roles. The job experience module tracks every promotion, transfer, lateral move, additional responsibility, and assignment. For example, a front-office trainee may move to guest relations, then to revenue management, then to a duty manager role. Without this module, the company has no way to see the internal mobility patterns that shape its future leadership pipeline.

This data is the raw material for techniques like skills inventories, replacement charts, and Markov-style flow modelling. Skill inventories prepare a list of employees showing each one’s education, experience, vocational interests, abilities, and skills, while succession planning identifies and develops individuals who can eventually take on senior positions.

Performance appraisal module 🔗

Numbers alone don’t tell you who is ready for what. The performance appraisal module integrates annual or biannual evaluations, ratings, feedback, and competency assessments into the system. Over several cycles, this builds a longitudinal view of how an employee is growing – or stagnating.

For supply forecasting, performance data answers a critical question: of the employees we currently have, how many are genuinely promotable in the next forecast period? A company may have 200 stewards on paper, but only 60 may be performance-ready for senior steward or captain roles. Without appraisal data, every internal promotion forecast becomes optimistic by default.

Training module 🔗

The training module captures every learning intervention – induction programmes, on-the-job training, cross-functional exposure, soft-skill workshops, certifications, and management development programmes. It records who attended what, when, the outcomes, and the resulting skill upgrades.

This is particularly valuable in tourism because skill profiles change rapidly. Digital booking platforms, sustainable tourism practices, contactless service delivery, and revenue management software all require continuous reskilling. A training module helps forecasters identify which employees can be developed internally to fill emerging roles, reducing the need for external recruitment.

How the macro and micro data bases work together 🔗

The macro and micro databases are not parallel universes – they feed into each other. A national hotel chain’s MIS data, when aggregated across the industry, becomes a key macro input. Conversely, the macro picture of educational out-turn helps a hotel chain plan its campus recruitment strategy.

Consider a practical example. Suppose a chain operating across India is planning to open fifteen new properties over the next three years. Its MIS tells it how many internal candidates can be promoted to leadership roles, how many lateral hires will be needed, and which existing properties have surplus capacity. Macro data from the Ministry of Tourism and hospitality institutes tells the chain how many fresh graduates will be available, in which regions, and with what skill mix. Together, these two layers produce a credible supply forecast.

Common challenges in building the data base 🔗

Despite its importance, building a robust manpower database is rarely smooth. Forecasting internal supply depends crucially on year-wise wastage data and well-defined cohorts, which can be difficult to maintain without a computerised personnel information system. Many small and mid-sized tourism enterprises still rely on spreadsheets or paper records, leading to data gaps that undermine forecasting accuracy.

Other common issues include inconsistent job titles across companies (one firm’s “guest relations executive” may be another’s “front-office associate”), poor documentation of informal or contractual workers, lack of standardization in skill classifications, and limited data sharing between training institutions and employers. The seasonal and fragmented nature of tourism employment further complicates matters.

Practical steps to strengthen the data foundation 🔗

Building a stronger data base is a multi-stakeholder effort. Tourism enterprises should invest in a digital Human Resource Information System (HRIS) that consolidates all five MIS modules into a single, queryable platform. HR information systems support activities such as identifying potential employees, maintaining records on existing employees, and creating programmes to develop their skills. This is no longer a luxury for large hotel chains – even mid-sized players can afford cloud-based solutions today.

At the macro level, industry bodies and government agencies should standardize occupation codes, skill frameworks, and reporting formats. Periodic skill-gap surveys, collaboration with the National Skill Development Corporation, and integration of data from tourism education institutes can collectively raise the quality of national supply forecasts.

Finally, forecasters themselves must develop the analytical mindset to combine quantitative records with qualitative judgement. Data alone cannot capture sudden disruptions like pandemics, regulatory shifts, or technology-led transformations. The data base provides the structure; experienced forecasters provide the interpretation.

What do you think? If you were designing the Manpower Information System for a fast-growing hotel chain, which of the five modules would you prioritize first, and why? And how would you handle data on contractual or seasonal workers, who often slip through the cracks of traditional HR systems?

References

1. https://www.sciencedirect.com/science/article/abs/pii/016920708890132X
2. https://www.statista.com/statistics/1094224/india-employment-in-travel-and-tourism-sector/
3. https://www.kenresearch.com/industry-reports/india-hospitality-industry
4. https://www.businesswire.com/news/home/20210302005726/en/India-Hotel-Industry-Report-2021-In-FY-2020-the-RevPAR-was-INR-1951.34-and-is-expected-to-reach-INR-3336.28-by-FY-2025—ResearchAndMarkets.com
5. https://www.ihmnotes.in/assets/Docs/Ignou/TS-07/Unit-2,DEMAND%20AND%20SUPPLY%20FORECASTING.pdf
6. https://ebsedu.org/blog/forecasting-of-human-resource-in-an-organization/
7. https://www.sciencedirect.com/science/article/abs/pii/0305054880900039
8. https://www.researchgate.net/publication/282557766_The_Role_of_Human_Resource_Information_System_in_the_Process_of_Manpower_Activities