How to Build a Cacao Sourcing Schedule That Supports Production Planning

Production schedules fail when ingredient supply fails. This is one of the most common and most avoidable operational problems in food manufacturing. It is avoidable because the timing of when ingredients need to arrive is, in most manufacturing environments, knowable in advance with reasonable accuracy. And if the arrival timing is knowable, the procurement trigger that produces it on time is calculable.

The sourcing schedule is the operational tool that converts production requirements into procurement actions far enough in advance to ensure supply continuity without crisis management. Building one that genuinely integrates procurement and production planning requires four specific inputs and a calculation method. This article provides both.

Why Sourcing Schedules Fail in Practice

Most manufacturing businesses have some form of procurement schedule. Most of those schedules fail to prevent supply-driven production gaps because they are built on the wrong inputs, maintained too infrequently, or treated as a separate exercise from production planning rather than a direct output of it.

The three most common structural failures in cacao sourcing schedules are: using historical order frequency as a proxy for required order timing rather than calculating from forward demand; treating lead time as a fixed number rather than a range with variability that must be buffered; and maintaining the schedule as a static document rather than a rolling horizon that is updated as new information arrives.

The Four Inputs a Schedule Requires

A cacao sourcing schedule that supports production planning is built from four specific inputs, each of which feeds a different part of the calculation that determines when orders must be placed.

Input One: Production Demand Forecast

The production demand forecast converts finished product volume requirements into ingredient volume requirements on a time-phased basis. This conversion is straightforward for manufacturers with stable formulations: the cacao powder content per unit of finished product is known, and the forward production schedule provides the finished product volume plan from which ingredient requirements can be calculated directly.

Converting Production Volume to Ingredient Requirements

The conversion involves three steps: first, extracting the forward production plan by week or month from the production schedule; second, multiplying each period's production volume by the cacao powder inclusion rate per unit of finished product to produce an ingredient volume requirement per period; and third, adding any committed customer orders for periods beyond the current production horizon to capture demand that is confirmed but not yet in the production schedule.

The resulting ingredient demand profile by week is the primary driver of the sourcing schedule. Everything else in the schedule exists to ensure that this profile can be met reliably from available supply.

Forecast Horizon Requirements

The minimum useful forecast horizon for cacao powder procurement is equal to twice the maximum supplier lead time, so that a disruption in one supply cycle can be identified and addressed within the remaining supply horizon. For most commercial cacao powder supply relationships involving ocean freight from producing countries, this means a minimum rolling twelve-week forward horizon, and ideally twenty-six weeks to accommodate seasonal origin availability planning.

Input Two: Supplier Lead Time Map

Lead time in cacao powder procurement is not a single number. It is a range with a minimum, a typical, and a maximum that varies by supplier, by origin, by freight route, and by seasonal port and logistics conditions. A sourcing schedule built on a single lead time number is built on a best-case assumption. A sourcing schedule built on a lead time range is built on operational reality.

What the Lead Time Map Should Capture

The sum of these components at maximum creates the worst-case lead time that the safety stock calculation must cover. The sum at typical creates the expected lead time that the order trigger calculation is based on. Both figures belong in the lead time map.

The lead time variability that international procurement introduces, and how it should be factored into planning, is covered in our July article on how global cacao supply chains influence manufacturing performance.

Input Three: Safety Stock Calculation

Safety stock is the buffer inventory held to absorb lead time variability without creating a production gap. It is expressed most usefully in production days of coverage, rather than in absolute weight, because its adequacy is relative to the consumption rate at any given point in the production schedule.

The Safety Stock Formula

A practical safety stock calculation for cacao powder procurement uses the difference between maximum lead time and typical lead time, multiplied by average daily consumption rate. This produces a buffer that absorbs the worst-case lead time extension without exposing production to a supply gap.

In practice: if typical lead time is 28 days and maximum lead time is 42 days, and average daily consumption is 500 kg, the safety stock requirement is 14 days times 500 kg, or 7,000 kg. This is the minimum stock level at which a replenishment order should be triggered to ensure that even a maximum-delay delivery arrives before production is at risk.

Safety Stock and Demand Variability

Where production volumes are not constant, safety stock calculation should also factor in demand variability. A manufacturer with significant seasonal peaks needs a larger safety stock buffer during high-demand periods than during steady-state production. The safety stock level should be recalculated each time the production forecast is updated to reflect the current demand profile rather than a static annual average.

Input Four: Origin Availability Calendar

Cacao is an agricultural product with harvest seasonality that varies by growing origin. The major producing regions each have distinct harvest periods that affect the timing of new-crop availability, the pricing dynamics at different points in the supply year, and in some cases the specification profile of available material as harvest quality varies across the season.

Key Origin Availability Patterns

Ecuador has two main harvest periods: the principal harvest typically running from January through May, with a smaller "mitad" harvest in October and November. Peru has a similar pattern with regional variation. West Africa has its main crop from October to March and a mid-crop from May to August. Understanding these windows allows procurement planning to align new-crop orders with peak availability periods, where both supply volume and specification consistency are typically strongest.

For a fuller picture of how each major origin's supply characteristics affect procurement decisions, see our origin pages for Ecuador and Peru, and our article on how global cacao supply chains influence manufacturing performance.

Building the Order Trigger Calculation

With the four inputs defined, the order trigger calculation is straightforward. For each purchase cycle, it answers two questions: what is the latest date by which an order must be placed to ensure delivery before safety stock is exhausted, and what quantity should that order contain?

Order Trigger Date

The order trigger date is calculated by working backward from the required delivery date. The required delivery date is the date on which current stock will fall to the safety stock level, given the forward production consumption schedule. The order trigger date is that required delivery date minus the typical supplier lead time. Any order placed after this date risks a delivery arriving after safety stock has been breached.

Order Quantity

The order quantity is calculated to replenish stock to the maximum stock level, defined as safety stock plus the consumption between order placement and expected delivery plus a forward coverage buffer. For most commercial relationships, the order quantity is calibrated to produce a stock profile that does not require another order until after the next replenishment has arrived, creating a smooth and predictable inventory cycle.

Schedule Maintenance and Rolling Update Cadence

A sourcing schedule built once and not maintained is worse than useless: it creates false confidence while actual supply positions drift from the planned picture. A functional sourcing schedule is updated on a defined cadence, with each update rolling the horizon forward and incorporating the most current demand, inventory, and lead time information.

Weekly Update Checklist

How the Schedule Connects Procurement and Production

The sourcing schedule is only effective as a production planning tool if it is genuinely integrated with the production planning function. This means that the production planner and the procurement function share the same forward demand and supply picture, that changes to the production plan trigger a review of the sourcing schedule rather than being managed in isolation, and that supply position alerts from procurement reach production planning early enough to allow schedule adjustment before a production gap is created.

In many businesses, procurement and production planning operate from separate systems with no formal information exchange. The sourcing schedule is the bridge between them: a shared document or system view that makes the ingredient supply position visible to production planning with enough forward horizon to allow proactive management of any gaps or surpluses that the current plan would create.

What a Good Schedule Looks Like in Practice

A fully functional cacao sourcing schedule provides, at a glance, the following for any point in the next twelve to twenty-six weeks: current stock level and projected stock trajectory based on forward consumption; confirmed and planned deliveries with expected delivery dates and quantities; open purchase orders and their expected arrival windows; order trigger dates for the next two purchase cycles; and an alert flag for any period where stock is projected to fall below safety stock before the next planned delivery.

This view does not require sophisticated software. It can be maintained in a well-structured spreadsheet updated weekly. What it requires is the discipline to maintain it accurately, the integration with production planning to ensure consumption data is current, and the supplier relationship quality to ensure lead time information is reliable.

The Takeaway

A cacao sourcing schedule that supports production planning is built from four inputs, maintained weekly, and shared with the production function as a joint supply visibility tool. It is not a historical record of past orders. It is a forward-looking calculation that determines when orders must be placed to ensure supply continuity across the production horizon, with a buffer that absorbs the lead time variability that international ingredient supply inevitably introduces.

Procurement functions that build and maintain this schedule consistently produce fewer supply-driven production gaps, carry more appropriate inventory levels, and spend less time managing supply crises than those relying on reorder point triggers or experiential judgement without a structured forward plan.