Workforce Scenerios L003.pdf
PDF 134 KB Posted
- Solicitation number
- 693KA9-24-R-00009
About this file
This document contains a technical scenario for a federal contract opportunity with the Federal Aviation Administration. The FAA requires a workforce scheduling system to manage schedules for up to 40,000 employees across multiple workforces, including air traffic controllers and technicians. The scenario outlines problems to determine optimal shift start times, coverage for variable demand curves, and bi-weekly employee schedules while meeting constraints such as 8 or 10-hour shift lengths, break requirements, days off, and minimum coverage levels from 2200 to 0500. Programming languages and algorithms are needed to solve scenarios with variable demand curves and different shift length combinations. Team members would require skills in areas such as scheduling, optimization, and software development.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
SIR No. 693KA9-24-R-00009 Attachment L003
Technical Scenario
1. A workload-based demand curve for all days is provided as follows:
a. 2300-0530: demand of 1
b. 0530-1600: demand of 3
c. 1600-2300: demand of 2
2. Given the above demand curve, determine the optimal set of shifts start times with the required number of employees per start time, subject to the following:
a. All shifts are 8-hour shifts.
b. There are three groups of shifts: day, evening, and midnight shifts.
c. No day shift can start before 0530.
d. No shift may cross from one pay period into another.
i. A pay period is a two week period that starts on Sunday and ends on Saturday.
e. Except for the midnight shift grouping, an employee may work a maximum of 2 consecutive hours before a break.
f. Breaks between consecutive work must be at least 15 minutes in duration.
g. Employees on the day and evening shifts must also have a 30-minute lunch.
h. The hours of 2200 to 0500 must have a minimum of two employees present regardless of workload-based demand.
3. For the results found in problem (2), provide a visual representation showing how the shifts selected cover the required demand.
4. Given the results you found in problem (2), create an optimal two-week schedule, subject to the following:
a. All employees work 40 hours in a week (Sunday-Saturday).
b. All employees must have 2 days off in a week.
c. Employees cannot work more than 6 consecutive days.
d. Employees must have 10 hours off between the end of one shift and the start of the next shift.
5. For the schedule created in problem (4), provide the following calculations:
a. The percentage of time where exact coverage to the demand is met by the schedule.
b. The percentage of time where there is more coverage than required.
c. The percentage of time where there is insufficient coverage provided by the schedule.
d. A visual representation of how the schedule provided covers the required demand.
e. A calculation of the average employee time spent providing coverage, split by the day, evening, and midnight shifts.
6. Given the same demand curve referenced in (1) above, determine the optimal set of shift start times with the required number of employees per start time, subject to the following:
a. There are two 10-hour shifts: one beginning at 1000 and one beginning at
1400. Both shifts require 1 employee each day.
b. The remaining shifts are 8-hour shifts.
c. There are three groups of shifts: day, evening, and midnight shifts.
d. No day shift can start before 0530.
e. No shift may cross from one pay period into another.
SIR No. 693KA9-24-R-00009 Attachment L003
Technical Scenario
i. A pay period is a two-week period that starts on Sunday and ends on Saturday.
f. Except for the midnight shift grouping, an employee may work a maximum of 2 consecutive hours.
g. Breaks between consecutive work must be at least 15 minutes in duration.
h. Employees on the day and evening shifts must also have a 30-minute lunch.
i. The hours of 2200 to 0500 must have a minimum of two employees present regardless of workload-based demand.
7. For the results found in problem (6), provide a visual representation showing how the shifts selected cover the required demand.
8. Given the results you found in problem (6), create an optimal two-week schedule, subject to the following:
a. All employees work 40 hours in a week (Sunday-Saturday).
b. All employees must have at least 2 days off in a week.
c. Employees cannot work more than 6 consecutive days.
d. Employees must have 10 hours off between the end of one shift and the start of the next shift.
9. For the schedule created in problem (8), provide the following calculations:
a. The percentage of time where exact coverage to the demand is met by the schedule.
b. The percentage of time where there is more coverage than required.
c. The percentage of time where there is insufficient coverage provided by the schedule.
d. A visual representation of how the schedule provided covers the required demand.
e. A calculation of the average employee time spent providing coverage, split by the day, evening, and midnight shifts.
10. Which schedule (4) or (8) is more optimal and why? Give your answer in both quantitative and qualitative terms.
11. Describe the programming, programming language, and algorithms that would be used to:
a. Solve problem (2) with a variable demand curve that ramps up and down throughout each day
b. Solve problem (2) for combinations of 7, 8, 9, and 10 hour shifts
12. What are the labor categories/skill sets of each team member that solved the above problems?
File details come from the government source that posted it. Updated .