Managing staff schedules: optimizing teams

As a production manager or plant manager working a 2×8 or 3×8 shift schedule, you revise your schedule every week—often every morning—to account for absences, emergencies, and expiring certifications. A poorly planned assignment can delay a delivery, result in a quality defect, or put an operator at risk. Since a spreadsheet doesn’t tell you who is qualified, you have to make quick decisions on the fly, using your management time.

Staff scheduling involves assign each position to an available, qualified person in accordance with the law, in four steps.

• Map out, position by position, the required skills and authorizations.
• Establish assignment rules, from authorized substitutes to rest periods.
• Create a sample schedule for a typical week.
• Check each change as it is entered, when a discrepancy can still be corrected.

To provide you with benchmarks at each stage, we analyzed twelve months of usage data from the Mercateam platform, representing 3.65 million assignments across a sample of 210 French industrial sites.

Mercateam usage data: 3,651,583 assignments, a sample of 210 French industrial sites, August 2025 through August 2026.

1. What is workforce scheduling in an industrial setting?

Definition and issues specific to the industrial sector

In industry, managing the staff schedule involves decide who will fill each position in each time slot, taking into account authorizations, proficiency levels, and production uncertainties.

Your website faces five challenges that a typical office schedule doesn't take into account.

• Specific technical skills that are often non-interchangeable
• Strict delivery commitments
• Mandatory Authorizations and Certifications
• A shift schedule (2×8, 3×8, 5×8)
• Fluctuations in business activity that are sometimes seasonal or order-driven

The first can be measured. We counted, position by position, the skills and qualifications required, ranging from an average of 3.7 in the pharmaceutical industry to 7.2 in the automotive industry.

Assigning an operator therefore involves checking four to seven conditions at once. This is the qualifications required for the position which sets this schedule apart from a simple timetable.

The Different Components of an Effective Schedule

Effective scheduling takes four factors into account for each assignment, and each one is enough to block a position.

• The human aspect encompasses availability, skills, medical restrictions, and preferences.
• The technical aspect covers the equipment, maintenance, and requirements for each position.
• The regulatory aspect covers working hours, breaks, and authorizations.
• Economic considerations limit overtime and temporary work.

Our data provides a rough estimate to help you gauge where your site stands.

A production schedule can be viewed as a series of assignment decisions, each of which has implications for quality, safety, and labor law.

Impact on productivity and team satisfaction

A Well-Structured Schedule puts the right person in the right position at the right time, which reduces production line downtime and identifies training or hiring needs in advance.

For your operators, fairness is primarily a matter of shift rotation, a key aspect of the scheduling of rotating shifts at the factory. To that end, the INRS recommends a few guidelines.

• Short shifts, with no more than two or three consecutive nights, followed by days off.
• As many weekends off as possible for everyone.
• A morning shift that doesn't start until 6 a.m.
• A rotation of morning, afternoon, and night shifts, as recommended by the Ministry of Labor.
• A regular cycle that everyone learns about early enough to plan their personal lives around.

At Trigano, a more flexible and transparent organizational structure has improved team satisfaction; Berry Global It improves its ability to anticipate and control production.

On the production side, LVMH Fragrance Brands has reduced its allocation errors by implementing configured constraints, with no production line stoppages due to unexpected absences since (See the LVMH Fragrance Brands use case).

2. The daily challenges of production planning

Managing Absenteeism and Unforeseen Events

An unexpected absence can be handled quickly when you know who, among those present, is qualified for the position. The replacement therefore requires two things.

• Quickly find a replacement who has the skills and qualifications required for the position.
• Rearrange the team without overburdening the same workers or calling an employee back from their time off—even if it’s voluntary—because it interferes with their recovery.

L'Social Performance Observatory 2026, conducted by Ipsos bva for Oasys Diot-Siaci, estimates absenteeism at 4.98 % in 2025. At a site with 200 employees, that amounts to about ten employees absent on any given day.

Without a clear picture of available skills, this search takes place when a position opens up—under time pressure—and it happens every week.

How many times is the schedule changed each week?

On average, a schedule is modified 467 times per week at a site with 100 to 300 employees, 212 times at sites with fewer than 100 employees, and 1,277 times at sites with more than 300 employees.

On a large site, that amounts to one change every two minutes during an eight-hour workday. We measured this at sites that use the assignment schedule, focusing only on weeks with actual activity.

Weekly schedule changes, depending on the size of the site

Light bar: P25 to P75 range across sites. Purple line: median.

Dispersion tells us more than the median. Among sites with 100 to 300 employees, a site in the third quartile processes 851 changes per week—nearly four times the volume of a site in the first quartile (221).

At what point in the week does the schedule change?

The schedule changes most often on Wednesdays and Thursdays, which account for 45 % of the changes, compared with 14.7 % on Friday. We’re far from having a finalized schedule on Friday for the following week.

Weekly Breakdown of Schedule Changes

Percentage of total change volume, in %, over 12 months.

On business days, the volume is concentrated at the start of production.

• 48 % changes between 6 a.m. and 12 p.m.; ;
• 35 % between 12:00 p.m. and 6:00 p.m.; ;
• 17 % between 6:00 p.m. and 6:00 a.m.

The peak occurs on Wednesdays at 8 a.m. That’s when the shift starts, when actual absences become apparent, and decisions must be made within the hour.

The balance between production needs and available skills

The balance between production and skills hinges on the small number of qualified candidates per position, for three reasons.

• Specific skills that are sometimes possessed by only a limited number of operators
• Positions requiring special clearance (working at heights, electrical work, etc.)
• A transfer of expertise that is not always formalized

How many operators are proficient in two positions?

Only 10.1 % to 20.1 % of operators are proficient in two or more positions, depending on the sector, with the result that 8 out of 10 operators are proficient in no more than one position.

Why such a strict threshold? We follow the criteria of an auditor, who considers that an operator has mastered a position only if they meet 100 % of the requirements, including skills and authorizations.

Percentage of operators proficient in two or more positions, by sector

Light bar: P25 to P75 range between sites. Purple dot: median for the sector.

The variation among sites within the same sector is greater than the variation across sectors. In the automotive industry, one-quarter of sites have fewer than 1 % multi-skilled workers, while another quarter have more than 67 %, indicating that organizational structure has a greater impact than the nature of the work.

How many positions are staffed by fewer than three people?

This trend holds true without exception across all five sectors. In the automotive sector, 647 of the 1,156 positions analyzed have no incumbent who meets all the requirements; in the aerospace sector, the figure is 533 out of 2,112.

Yet these workstations are in operation every day, with operators verifying some of their requirements.

Skills possessed by a single person

Almost every site relies on at least one irreplaceable person, since 93 % to 100 % of them, depending on the sector, have a skill or certification held by only one employee.

In the aerospace industry, one in seven positions is held by a single employee, and the median number of skills held by a single person at a given site is 52—a sign of a more refined skill set.

Identify your monopolies before a move reveals them. The Exxelia Case Study outlines the method, including a skills tracking system that identifies critical skills and anticipates retirements.

Nearly one in two validated skills is never used

Up to one in two validated skills is not used in any assignment over a 12-month period, from 26.1 % in the pharmaceutical sector to 49.6 % in the aerospace sector.

Skills validated without any job assignments over a 12-month period, by sector

Percentage of skills validated at the operational level that were not used for any scheduling assignment.

We compared the skills validated at the operational level with the actual assignments of only those employees who were assigned to a position at least once during the year. Therefore, neither extended absences nor resignations account for these rates.

Compliance with legal and regulatory constraints

Your schedule must comply with five categories of rules, from rest periods to the validity of certifications, because they protect the safety of the teams.

• Respect for daily and weekly rest periods
• Managing mandatory breaks
• Maximum working hours
• Compliance with company agreements and collective bargaining agreements
• Validity of necessary authorizations and certifications

Thresholds to Include in Any Schedule

Every change is also a legal decision. In a 3×8 schedule, an operator who is called back to work the night shift after his day shift no longer gets his 11 hours of rest, and he is no longer in compliance—even if he volunteers to do so.

How soon after publication can a schedule be modified?

For part-time employees, the notice period is 7 business days, reduced to at least 3 by collective agreement. The collective work schedule, on the other hand, must be amended before it is implemented.

• Part-time. At least 7 business days before any change to the work schedule. A collective agreement may reduce this notice period to 3 business days, subject to compensatory measures.
• Duration spread over several weeks without an agreement. Schedule changes are announced 7 business days in advance.
• Group schedule. The amendment is posted prior to implementation and submitted in advance to the labor inspectorate, following consultation with the Social and Economic Committee (CSE) in companies with at least 50 employees.

On a site that records hundreds of changes per week, knowing who made which changes and when the employee was notified becomes your strongest evidence in the event of a dispute.

Failure to submit the collective work schedule to the labor inspectorate results in a 4th-class fine for each affected employee, up to €750 per employee, and five times that amount for a company.

The limits of traditional methods (Excel, paper tables)

Excel and paper quickly reach their limits at an industrial site, because they have no control over anything you enter there.

• It's hard to get a quick overview of the entire team's skills and availability.
• Information quickly becomes outdated if it isn't updated at the source.
• There are no alerts indicating that hours have been exceeded or that authorization has expired.

The SEB Group overcame these limitations by replacing 35 Excel, Word, and PowerPoint files with a single solution at its sites in Tournus and Rumilly.

This lack of alerts can be managed at a rate of 212 changes per week. At 1,277, it can no longer be handled by eye.

Visit Limitations of Production Scheduling in Excel stem from its architecture. Scheduling and skills are stored in two separate files, so no assignments are verified during data entry.

3. How to set up an efficient staff scheduling system?

Effective Staff Scheduling Start by assessing your current schedule, then links skills to the schedule, anticipates peaks, and tracks three metrics.

Preliminary Analysis of Needs and Constraints

Start by analyzing your current organization, to avoid replicating those issues in the new tool. The analysis focuses on four points.

• Current processes and their pain points.
• Business cycles, with their predictable periods of high and low workload.
• Site-specific constraints, such as night shifts, critical positions, or hard-to-find skills.
• The time your teams currently spend on scheduling.

To assess this workload, keep track of your schedule changes over a four-week period, noting who makes them, on what day, and at what time. This data will show you how your workload compares to the medians for your group.

Three interpretations emerge.

• A volume close to the median, spread out over the week, indicates an organization that can handle unforeseen events.
• A sharp spike on Wednesday morning indicates a pattern that doesn't hold beyond Tuesday, and that's the one you need to reevaluate.
• A volume above the third quartile indicates that there is a lack of information on skills at the time of assignment.

While Wednesday's peak is the main focus, a workload review on Tuesday afternoon helps alleviate some of the pressure before the shift begins.

Integration of Skills and Authorizations

Reliable scheduling is based on a skills database that is updated for each position, which consists of four parts.

• Creating a skills repository structured by item
• Define mastery levels for each skill (beginner, intermediate, expert)
• Identify regulatory authorizations and their expiration dates
• Identify in-house trainers able to pass on every skill

Valrhona formalized this process in response to its expansion and growing workforce, to maintain the quality of its products while integrating new employees.

A reference framework that becomes outdated faster than the schedule

An operator's skills profile is updated only every 49 days (median), and every 118 days for one-quarter of employees.

The percentage of workers whose pay grades were adjusted during the year ranges from 54.1 Q3 in the automotive sector and 50.0 1 Q3 in the aerospace sector to 24.8 1 Q3 in the cosmetics sector and 11.1 1 Q3 in the pharmaceutical sector.

An authorization that was renewed in the system but entered six weeks later triggers the same alert as an expired authorization. A Tracking of authorizations prepared for audits Close this window.

Anticipating Peaks in Activity

A peak in activity is planned weeks in advance, based on your charging history.

• Analyze historical data to identify load patterns
• Prepare scenarios for busy periods
• Schedule training courses during off-peak periods

This proactive approach limits overtime and emergency temporary staffing, two practices that are regulated by law.

• In the absence of an agreement, the limit is 220 hours of overtime per employee per year; beyond that, each hour entitles the employee to a mandatory rest period.
• These rates are increased by 25 % for the first 8 of the week, and then by 50 %; an agreement may set a different rate, of at least 10 %.
• Temporary employment is limited to specific cases, including replacing an absent employee and handling a temporary increase in workload, and cannot be used to fill a permanent position on a long-term basis.

A position that lacks permanent staff throughout the year cannot, therefore, be filled with temporary workers. Temporary workers handle the peak workload; versatility—which is prepared well in advance—covers the position.

The increase is concentrated between the first and third years, then levels off at around 32 % for permanent employees. A seasonal peak is therefore expected as a result of the previous year’s hiring.

Temporary workers with 3 to 10 years of cumulative seniority account for 43.4 %: assigned to wherever there is a shortage of staff, they rotate among different positions. For the interim management, Retaining repeat customers pays off.

Three Metrics for Managing the Schedule

Three metrics are all you need to manage your schedule, using our medians as a point of comparison.

Taken separately, they are misleading, because a factory that reduces its changes without improving its coverage has merely frozen its schedule. The other industrial performance indicators come next.

4. The Benefits of a Digital Solution for Your Schedules

Time-saving for managers

Linking scheduling and skills within a single suitable tool gives managers time for planning, which should be devoted to supporting the teams. This time comes from three automatic processes.

• Duplicating sample weeks.
• Skill-based placement recommendations.
• Alerts for non-compliance with rest period rules.

Our clients have measured the results: 25 % in time saved on assignments at LVMH Fragrance Brands and 30 % less time spent on planning at Groupe SEB.

Better visibility for all employees

«When am I working next week?» The operator finds the answer on their smartphone or on a workshop monitor, with a notification every time something changes, and better organizes their personal life.

However, the collective work schedule must still be dated, signed, and posted at each workplace (Art. D3171-2). Viewing the schedule on a smartphone supplements this posting but does not replace it.

Reducing Allocation Errors

A tool that monitors every assignment reports the discrepancy before starting the job, whether it involves an expired authorization, a missing qualification, or a failure to comply with rest periods.

These discrepancies relate to safety, quality, and labor law, and each is easier to correct at the time of staffing than after an audit or an incident.

How many assignments indicate a missing requirement?

14.3 % of assignments, one in seven, relate to an employee who lacks at least one required skill or authorization, or about 1,435 per day in the sample.

Percentage of non-compliant assignments and variation across sites

On the left, the overall rate for the fleet. On the right, the breakdown of the rates calculated on a site-by-site basis.

On a site-by-site basis, the median is 14.2 %. One-quarter of the sites remain below 3.6 %, and another quarter exceed 31.2 %—nearly one in three assignments.

The metric counts each assignment as one, whether it lasts two hours or a full shift in a 3×8 rotation.

Ability to adapt to the unexpected

When faced with a last-minute absence or an urgent order, a digital tool displays qualified and available substitutes with just a few clicks and notifies the people involved.

This helps you minimize unplanned absences, even when an employee is absent at the start of their shift.

Centralized information

A single tool brings together data from planning, HR, production, and quality, so that every update is visible to all authorized users.

Availability, qualifications, and the legal framework can all be reviewed in one place when making an assignment.

5. Concrete examples of successful transformation

Customer Case Studies and Testimonials

Three business leaders show what's changing a skills-based schedule.

• LVMH Fragrance Brands used to manage the schedules for its Beauvais site using Excel and physical maps; staff assignments there are now based on skills (LVMH Fragrance Brands x Mercateam Use Case).
• Groupe SEB replaced its Excel, Word, and PowerPoint files with a single solution and standardized its processes across sites (SEB Group x Mercateam Use Case).
• Trigano, a manufacturer of recreational vehicles, can view available skills in real time and assign only trained and authorized operators to sensitive positions (Trigano x Mercateam Use Case).

Quantifiable results

Four of our clients have quantified the benefits they gained after digitization.

6. How do you choose the right solution for your needs?

Essential criteria to consider

The primary selection criterion is an assessment of the candidate's qualifications for the position, because a tool that only manages time slots doesn't detect the missing authorization.

Two usage criteria supplement this initial filter.

• An interface that team leaders can quickly get the hang of, even without a technical background (Explore the Mercateam platform).
• The provisions of your collective bargaining agreement and your company-wide agreement, integrated into the tool.

Before comparing staff scheduling software, measure your rate of non-compliant assignments, which indicates how well your schedule and your skills align.

Questions to ask before choosing

Three internal questions help narrow down your options before meeting with a publisher.

1. What are our main current sticking points when it comes to managing staff schedules?
2. Do we need detailed management of skills and authorizations?
3. What are our specific constraints (shift work, multi-site teams, etc.)?

For demonstration purposes, check each criterion against your own rules and authorizations.

Conclusion

Staff scheduling becomes reliable when Each assignment is verified at the time of entry, regarding availability, qualifications, and the legal framework.

Our data breaks this requirement down into three questions, which are asked hundreds of times a week on each site.

Start by counting the number of schedule changes over a four-week period and mapping them against the milestones in your timeframe. This is the basis for the discussion we’re demonstrating.