What are the tasks of a production planner in oilfield logistics?

Production Planner — Oilfield Logistics

Role focused on orchestrating the end-to-end movement and availability of materials, equipment, and people supporting drilling, completions, well services, and production operations.

I. Core responsibilities

1.1 Demand and activity planning — translate rig/frac/WO schedules into time-phased material and transport requirements (OCTG, chemicals, proppant, fuel, spares, rental tools).
1.2 MRP and inventory alignment — run materials requirements plans, set min/max and safety stock by location (base, satellite yards, offshore supply base), and create purchase/transfer proposals.
1.3 Load building and dispatch — consolidate loads, optimize cube/weight and hazmat segregation, issue pick lists, and release dispatches to road, marine, or air logistics.
1.4 Vessel/flight/truck slotting — allocate shipments to sailings, flights, and road windows, considering weather, port queues, axle limits, and road bans.
1.5 7–14-day look-ahead — maintain rolling look-ahead plans for campaigns (e.g., multi-well frac, coil tubing runs, rig moves), level resource demand versus fleet/yard capacity.
1.6 Yard and warehouse synchronization — sequence receiving, staging, kitting, and cross-dock to meet ETD/ETA, minimize double handling.
1.7 Constraint and exception management — resolve shortages, substitutions, and off-spec returns; trigger expediting, alternate sources, or schedule re-sequencing.
1.8 Documentation readiness — ensure manifests, certificates, SDS, MSDS, hazmat declarations, and customs documents are complete and reconciled to loads.
1.9 KPI monitoring — track OTIF/DIFOT, NPT due to logistics, demurrage/detention, utilization, forecast accuracy; drive corrective actions.
1.10 Cost control — compare planned vs actual freight and handling costs, prevent premium freight through proactive planning.
1.11 HSE and compliance alignment — plan to lifting limits, segregation rules, and transport class requirements; coordinate permits and JSA prerequisites for unusual loads.
1.12 Stakeholder communication — publish daily operations plan, variance notes, and recovery plans to operations, vendors, carriers, and site supervisors.
1.13 Post-ops reconciliation — close out deliveries/returns, reconcile consumptions vs issues, update inventory and usage histories.

II. Required skills and physical demands

2.1 Technical skills
- Oilfield materials knowledge: OCTG, wellhead/valving, rental tools, completion strings, proppant, drilling/completion chemicals, production chemicals, H2S safety gear.
- Planning methods: MRP, finite capacity scheduling, rough-cut capacity planning, time-fencing, ABC/XYZ classification.
- Inventory control: safety stock, reorder point, cycle counting, consignment/VMI, quarantine and shelf-life management.
- Transport planning: axle load/cube, hazmat classes, offshore packaging, breakbulk vs container, last-mile constraints to lease roads and quaysides.
- Campaign planning: rig moves, multi-well pad operations, SIMOPS coordination with marine/aviation.
- Data competence: ERP/APS planning runs, master data stewardship (UOM, lead times, BOM/kits), pivot analysis, dashboarding.
- Basic analytics: forecasting, scenario planning, and what-if cost/time trade-offs.
2.2 Soft skills
- Prioritization under time pressure; clear, concise communication.
- Cross-functional negotiation to resolve constraints and protect schedule critical path.
- Attention to detail in documentation; bias for preventive action.
2.3 Physical demands
- Frequent yard walk-downs in PPE, exposure to weather, noise, and moving equipment.
- Extended screen time; after-hours/on-call support during 24/7 operations.
- Occasional lifting of up to 23 kg/50 lb for sample packs or documentation boxes (most material handling is mechanized).

Key planning formulas

Safety stock (normal demand): \(SS = Z \cdot \sigma_{LT}\)
Reorder point: \(ROP = d \cdot L + SS\)
Economic order quantity: \(Q^* = \sqrt{\frac{2DS}{H}}\)
Little’s Law: \(WIP = \lambda \cdot CT\)
Utilization: \(U = \frac{\text{Throughput}}{\text{Capacity}}\)
OTIF: \(\%OTIF = \frac{\text{On-time, in-full deliveries}}{\text{Total deliveries}} \times 100\%\)
MAPE: \(\text{MAPE} = \frac{1}{n}\sum_{t=1}^{n}\left|\frac{A_t - F_t}{A_t}\right|\times 100\%\)
Transport capacity/day: \(C_{\text{day}} = N_{\text{units}} \times \text{payload} \times \text{turns/day}\)

III. Typical tools, software, and equipment

3.1 Planning systems — ERP (materials management, production planning, inventory), APS (finite capacity scheduling, what-if scenarios), demand planning modules.
3.2 Logistics execution — WMS (receiving, pick/pack/ship, kitting, cycle count), TMS (load tendering, routing, track-and-trace), e-manifest/compliance systems.
3.3 Analytics and visualization — BI dashboards, SQL/pivots, planning boards, Gantt tools.
3.4 Geospatial and routing — GIS for corridor/road ban visibility; routing solvers with axle/cube constraints.
3.5 Field hardware — handheld scanners, RFID, weighbridges, load cells, GPS telematics, temperature/tilt loggers for sensitive loads.
3.6 Yard/transport equipment — forklifts, telehandlers, cranes, spreader bars, rigging, pneumatic trailers, bulk tanks, ISO tanks, chemical totes, frac sand silos, pipe racks, sea-fastening fixtures.

Toolchain Snapshot

ERP + APS for MRP and finite scheduling
WMS + TMS for execution and visibility
GIS + routing optimizer for last-mile and marine windows
BI dashboard for OTIF, detention/demurrage, and inventory turns

IV. Work environment

4.1 Location — onshore logistics bases, warehouses, and marine/aviation coordination centers; periodic rig/pad or offshore supply base visits.
4.2 Schedule — standard weekday schedule with frequent on-call; during campaigns, coverage aligns to 24/7 operations with handover across shifts.
4.3 Travel — typically 10–30% to yards, vendors, and sites; occasional offshore visits subject to medicals and survival training (estimated).
4.4 Conditions — mix of office and industrial settings; strict adherence to HSE, hazmat handling, and lifting/transport standards.

V. Reporting lines and cross-functional interfaces

5.1 Reporting lines — typically reports to Logistics Planning Lead or Supply Chain Manager.
5.2 Key interfaces
- Drilling, completions, well services, and production operations planners.
- Warehouse and yard supervisors; marine and aviation coordinators.
- Procurement, category management, and contract owners.
- Carriers, freight forwarders, and rental/service vendors.
- HSE and QA/QC for compliance and inspections.
- Finance for cost accruals and variance analysis.

Deliverables & Interfaces

Daily/weekly logistics plan, 7–14-day look-ahead, and dispatch schedule ? issued to operations, yard, and carriers.
MRP outputs, purchase/transfer proposals, and pick lists ? handed to procurement and warehouse teams.
Load plans, manifests, hazmat docs, and certificates ? provided to compliance, marine/aviation, and security.
KPI dashboards and variance reports ? reported to management and operations stakeholders.

VI. Career ladder and progression

6.1 Next roles — Senior Production Planner (logistics), Planning Supervisor, Materials Manager, Logistics Manager, Supply Chain Planning Manager.
6.2 Development needs
- Certification: planning/supply-chain credentials, hazmat transport competence (road/marine/air), lean/continuous improvement.
- Systems mastery: advanced ERP/APS configuration, TMS optimization, data quality governance.
- Operational breadth: offshore campaigns, international customs, turnkey rig moves, SIMOPS.
- Leadership: coordinating 24/7 teams, vendor performance management, cost stewardship.
6.3 Progression Trigger — typically promoted after 6–10 major campaigns or 20–40 rig moves planned with sustained OTIF = 95%, logistics-related NPT near zero, and a recognized planning certification (estimated ranges).