Accurate and timely demand information is an essential element to the PHI Flex schedule optimization modeling process. In order for us to provide quality schedules for your region, we require your assistance in defining this demand.

For each location that should be considered in the Flex modeling process, we request that a Flex demand template be completed. The step by step instructions provided below will provide guidance on completing each location template. Thank you in advance for your assistance and please know that our analysis and support teams are available for assistance at [email protected]. 

First, start by filling out the top section of location specific data. This includes the locations name, hours of operation, restrictions of aircraft type and max payloads allowed on deck, if there is fuel available on the location, and lat and longs for both the location and desired service port.

After the basic location information has been captured, we'll focus on the demand information associated with your location. This guide will walk you through each column, and how the information should be captured.
Below is an example of what the template will look like once complete.

Column A: Name of Crew
This column will be where the crew's name  will be placed. The way that we are viewing crews for this exercise is the crew's that usually move together on a given day should be labeled as such.

Please break down your crews as granular as possible rather than lumping all crew movements that happen on a given day such as "Monday Crew." If Monday's crew is generally made up of 5 Transocean riggers, 3 members of the catering crew, and 1 foreman, label them as such. While having these crews broken down into the most detailed form if our ultimate goal, we understand that sometimes it is not realistic to accurately capture these numbers. In this event, we still need to be able to look at a locations movement capacity requirements as a whole.

Ad-hoc demand can be a difficult number to quantify. Some locations view passenger movements by the number of seats on an aircraft are available, and they then fill those seats accordingly. They may not know exactly who, or what company the passengers on the flight will be, they just know they have X number of seats to make their movements.
If this is the case, ad-hoc crews can be added for each day to account for the capacity the location needs on a regular basis. A true ad-hoc flight or passenger movement (one that is not normally scheduled for a location) can be left out.

Column B: # of Crew Members
In column B, input the number of crew movements that will take place for that crew on that given day. This does not represent all of the crew members that are set in the crew rotation, but rather the number of passengers that can be expected to fly on that day.

Column C: Crew Hitch Schedule
The crew hitch schedule column is to represent the hitch schedules of the workers on each crew. These crew changes can be 7/7, 14/14, 21/21, 28/28, 21/7, 21/14, etc.

Column D: Next Crew Movement
For each crew, we're looking for the next calendar date that this crew is scheduled to be on location. This date should be entered into the "Next Crew Movement" cell. For instance, if a crew is on a 21 and 21 schedule and is scheduled to return to your facility on the 10th of June, please enter this 10-MAR-2018 (dd-mmm-yyyy).

Column E: Crew Change Day of Week First Preference
This column is needs to have the actual day of the week this movement needs to happen.

Column F: Crew Change Time of Day
This column can be filled out with either Early, Mid, or Late.

Column G: Opposite Crew
This column is where you will capture the crew that is on the opposite schedule of the crew in column A. Make sure to label them in a way that makes the crew swaps easily identifiable.