Your cart is empty
Browse OfferingsLicensed & Affiliated
Ethio Coffee Import and Export PLC is a family-owned Ethiopian coffee exporter shipping green coffee beans to roasters, importers, and distributors worldwide.
© 2026 Ethio Coffee Import and Export PLC. All rights reserved.
Photo: Wisnu Dwi Wibowo, Unsplash.
Green coffee inventory management starts with one decision rule: reorder when usable stock plus confirmed inbound coffee, less committed demand, reaches expected use during replenishment lead time plus safety stock. Forecast roasted sales first, convert them to green kilograms with your actual roast yield, then calculate the rule for each origin or blend component. Track fresh-crop allocation, pre-shipment approval, export preparation, ocean transit, and warehouse receipt as separate milestones. This prevents a booked lot from being treated like available stock. The goal is not maximum inventory. It is enough saleable coffee to protect customer commitments without locking excess cash into beans that may age before roasting.
Green coffee inventory management fails when a roaster notices a shortage only after the production schedule is at risk. A purchase order may be signed, but the coffee can still be awaiting milling, pre-shipment approval, export documents, a vessel, customs clearance, or warehouse release. Each stage consumes time, while sales continue to consume the lot already on hand.
The solution is a buying model that connects sales velocity to origin lead time. It should tell a green buyer how many usable kilograms remain, how many weeks of demand those kilograms cover, when the next order decision is due, and which assumptions caused the answer. The system below works in a spreadsheet or inventory platform and keeps the calculation separate from storage science, freight execution, and price hedging, which already have their own specialist guides.
A useful inventory system controls availability, not bag count. The key quantity is inventory position: usable coffee on hand plus confirmed inbound coffee, minus stock already allocated to customer orders or blocked by quality review. Reorder when that position reaches the volume expected to be consumed before a replacement can become usable, plus a measured buffer.
Inventory position = usable on hand + confirmed inbound - committed or blocked stock
Reorder point = expected use during replenishment lead time + safety stock
"Confirmed inbound" needs a strict definition. Count a contracted lot only when its quantity, quality specification, shipment window, and commercial approval are documented. Keep tentative offers and unapproved samples in a separate supply-opportunity field. A coffee that exists on an offer sheet but has not cleared your buying gates cannot protect a production commitment.
Origin-connected exporters see one recurring mistake: buyers use the vessel ETA as the only lead-time date. A delayed pre-shipment sample or dry-mill slot can move the shipment before a vessel is booked. The inventory record should therefore show the lot's next controllable milestone, owner, and due date, not just a distant arrival estimate.
Forecast demand in roasted kilograms by SKU, then convert it to green kilograms with the yield your roastery actually records. Do not apply one assumed loss factor to every roast. Dense light-roast lots, darker profiles, sample roasts, cleaning loss, and production variance can give different usable yields.
Required green kg = forecast roasted kg / historical roasted yield
If a SKU must deliver 850 kg roasted and its trailing yield is 85%, the purchasing model needs 1,000 kg green before any safety stock is added.
Build a rolling 13-week forecast because it is long enough to expose an origin replenishment gap and short enough to update from live orders. Start with committed wholesale orders, subscriptions, and standing café demand. Add a baseline for uncommitted sales, then show promotions, new accounts, and seasonal events as separate adjustments. This preserves the reason behind each change instead of hiding it in one optimistic total.
| Forecast Layer | Evidence | Inventory Treatment |
|---|---|---|
| Committed demand | Open wholesale orders, subscriptions, signed programs | Reserve component volume immediately |
| Baseline demand | Recent weekly sales, corrected for stockouts and one-off orders | Use as the core run rate |
| Known uplift | Promotions, new locations, holidays, signed customer launches | Add only for named dates and owners |
| Uncertain pipeline | Unwon accounts, proposed listings, unconfirmed events | Scenario only, not committed purchasing demand |
Translate blend sales after the green conversion. If an espresso uses 35% Ethiopian coffee, apply 35% to the green requirement for that SKU, not to its packaged roasted weight. This sequence keeps roast loss visible and prevents a component shortage from being masked by total green stock belonging to other products.
The reorder point is the inventory position at which a buyer must act so new coffee becomes usable before existing coverage is exhausted. Multiply expected weekly consumption by the full replenishment lead time, then add safety stock for demand error and schedule variation. Use an end-to-end lead time, not ocean transit alone.
Average weekly use multiplied by the weeks from buying approval to usable warehouse release. Review the assumption by route, contract type, and crop stage.
A buffer for forecast error and replenishment variation. Start with average weekly use multiplied by chosen buffer weeks, then revise it from actual misses and service risk.
Set the buffer from evidence. A stable blend component with contracted demand and variable ocean schedules may need more time protection than a limited single origin whose menu can close when the lot sells out. Record why the buffer exists. Otherwise, safety stock becomes an unexplained number that only increases after a shortage and never decreases after reliability improves.
Calculate the point for each critical component. Ten tonnes of assorted green coffee do not protect a house blend if its Ethiopian component has two weeks of cover. Component-level control is especially important when several roasted SKUs draw from the same lot.
Every green lot should serve a named role: core continuity, seasonal campaign, approved bridge, or limited release. The role determines how the buyer forecasts it, whether a stockout is acceptable, and when substitute approval must begin. One policy across all coffees either overfunds seasonal stock or underprotects core blends.
| Inventory Role | Control Rule | Buyer Action |
|---|---|---|
| Core blend component | Protect service with a reorder point and approved bridge profile | Review weekly; start replacement cupping before the current lot closes |
| Seasonal single origin | Buy to a defined campaign quantity and end date | Do not create permanent safety stock for a finite menu slot |
| Approved bridge | Hold a sensory function, not an identical origin label | Pre-approve cup and roast fit before the primary lot reaches risk cover |
| Limited micro-lot | Allocate by campaign, wholesale account, or release batch | Close sales when allocable stock reaches zero |
Buyers often ask an exporter for the "same Ethiopian profile" after the replacement decision is already urgent. At origin, a more workable brief states the coffee's job in the product, the must-keep sensory attributes, the attributes that can move, the acceptable process, and the needed arrival window. That gives the sourcing network time to present bridge candidates while the buyer can still cup deliberately.
An Ethiopian replenishment clock should start at internal buying approval and end when the warehouse releases accepted coffee to production. Ethio Coffee's standard planning range is typically 8 to 14 weeks from contract to warehouse, depending on destination. Your model should retain the actual duration of every stage so the next calculation uses observed performance rather than memory.
| Milestone | Planning Question | Evidence to Record |
|---|---|---|
| Allocation and sample | Is the lot identified and available in the required volume? | Offer, sample code, quantity, crop, approval deadline |
| Contract and preparation | Are commercial terms final, and when is milling or bagging booked? | Signed contract, payment gate, preparation date |
| PSS release | Has the pre-shipment sample passed the written specification? | Approval status, cup date, exceptions, release owner |
| Export and vessel | Is the shipment cleared and loaded against a confirmed booking? | Container, vessel, bill of lading, departure and ETA |
| Arrival and release | When can accepted coffee enter the roast schedule? | Customs release, warehouse receipt, arrival QC decision |
For the stage-by-stage export workflow, use the Ethiopian coffee export process guide. Use the harvest calendar to place sourcing and sample activity before the desired arrival date. The inventory page should store the resulting dates, not repeat the underlying logistics instructions.
2026 supply context: The USDA Foreign Agricultural Service Coffee Annual published in May 2026 forecasts Ethiopia's 2026/27 production at 12.10 million 60 kg bags and exports at 7.13 million bags. National volume growth does not guarantee availability of a particular grade, process, washing station, or delivery month. Plan the named supply requirement, not the national headline.
A valid reorder point still needs two limits: how much working capital the business can fund and how old the coffee may become before it is roasted. Treat both as explicit constraints in the buying review. More stock can improve service protection while simultaneously increasing cash exposure and the share of coffee that reaches an unwanted age band.
Track open contract value, inventory value on hand, due payment dates, and landed-cost exposure. Connect the physical plan to the green coffee financing guide instead of treating approved volume as free capacity.
Show projected lot age at final roast, not only age on receipt. Use the green coffee shelf-life guide for packaging, storage, and quality-monitoring limits.
Price movement adds a reason to review the plan, but not a reason to abandon it. The International Coffee Organization's May 2026 market report placed the ICO Composite Indicator Price at 256.05 US cents per pound, down 3.8% from April 2026. A monthly move can change the cash required for the same physical coverage. Keep quantity, timing, and price assumptions in separate fields so the team can see which variable changed.
Use staggered deliveries or scheduled shipment windows when the contract size exceeds practical warehouse cover. Ethio Coffee can discuss harvest allocations and staged shipments; the ordering information page explains the commercial workflow. Any schedule still needs contract-specific confirmation.
Consider a multi-location roaster forecasting 4,000 kg of roasted sales per month. Its recorded yield is 85%, and Ethiopian coffee supplies 35% of green demand across a core espresso and one wholesale SKU. With 12 weeks of replenishment lead time and four weeks of safety stock, the Ethiopian component reaches a reorder point of about 6.1 metric tons.
| Step | Calculation | Result |
|---|---|---|
| Monthly green requirement | 4,000 kg roasted / 0.85 yield | 4,706 kg green |
| Ethiopian monthly requirement | 4,706 kg x 35% | 1,647 kg |
| Average weekly use | 1,647 kg / 4.33 weeks | 380 kg |
| Lead-time demand | 380 kg x 12 weeks | 4,560 kg |
| Safety stock | 380 kg x 4 weeks | 1,520 kg |
| Reorder point | 4,560 kg + 1,520 kg | 6,080 kg |
The roaster has 3,900 kg usable on hand, 2,800 kg in confirmed inbound supply, and 900 kg allocated to open wholesale commitments. Its inventory position is 5,800 kg. Because that is 280 kg below the 6,080 kg reorder point, the buying decision is due now even though physical stock still looks comfortable.
Annual Ethiopian demand in this scenario is about 19.8 metric tons. That output gives the buyer a commercial starting point, while shipment configuration, bag count, and feasible releases belong in the Ethiopian coffee MOQ guide and the supplier discussion. The calculation does not automatically mean the buyer should receive the entire annual quantity at once.
A weekly dashboard should surface the few conditions that require a buying action. Show each critical lot or component on one row, calculate its coverage from the latest use rate, and assign an owner to every exception. A long inventory export without decision thresholds is a record, not a control system.
| Dashboard Field | Decision It Supports |
|---|---|
| Usable kg and weeks of cover | Shows the physical runway at the current demand rate |
| Inventory position | Adds reliable inbound supply and removes allocations or holds |
| Reorder point and trigger date | Signals when a buyer must approve the next action |
| Projected run-out date | Connects supply risk to the roast and sales calendar |
| Inbound milestone and confidence | Separates booked, shipped, arrived, and quality-released coffee |
| Forecast error | Shows whether the buffer and demand model need revision |
| Projected age at final roast | Flags excess coverage before quality or campaign value fades |
Send suppliers a concise forward view even when it is not yet an order: expected kilograms by delivery month, coffee role, grade or cup requirement, process, certification, sample deadline, and confidence level. From an exporter's side, a rolling forecast makes it easier to distinguish ready stock from coffee that needs harvest allocation or a dry-mill slot. It does not reserve supply until commercial terms are agreed.
Implement the model in three operating cycles: establish clean consumption data, add replenishment logic, then manage exceptions on a fixed cadence. Software can automate transactions later, but it cannot repair unclear definitions for usable stock, confirmed inbound supply, or committed demand.
Reconcile lots and locations. Capture actual roast yield by SKU. Map every product to its green components. Define usable, blocked, allocated, and inbound status.
Build the 13-week forecast. Classify inventory roles. Measure actual supplier and route lead times. Set initial buffer weeks and exception thresholds.
Run weekly reviews. Issue a forward supplier brief. Record forecast error and milestone misses. Adjust reorder points only from observed demand or lead-time changes.
Green coffee inventory management becomes reliable when the same numbers drive sales commitments, roast planning, sourcing, cash review, and supplier communication. Forecast the roasted need, translate it into component-level green demand, count only dependable supply, and trigger buying before the risk reaches production. That discipline gives Ethiopian coffee enough time to move from a sourcing relationship at origin into an accepted lot in the roastery.
Share your required origin, cup profile, monthly green use, and target delivery window. We can match the brief to current offerings, arrange samples, and discuss an order schedule that supports your inventory plan.
Set the target from lead-time demand plus safety stock, not a universal number of months. A roaster using 380 kg of one component each week, facing 12 replenishment weeks, and carrying four buffer weeks reaches a 6,080 kg reorder point. Then cap stock by cash, storage, and acceptable age.
Multiply average green coffee use per week by the full replenishment lead time, then add safety stock. Compare that result with inventory position, defined as usable on-hand coffee plus confirmed inbound supply minus committed or blocked stock. Trigger the buying action when inventory position reaches or falls below the calculated point.
Count a contracted shipment in inventory position only as confirmed inbound supply, never as usable on-hand stock. Record its quantity, quality approval, current milestone, and confidence separately. If the pre-shipment sample, export release, or vessel booking is unresolved, discount it or exclude it until the blocking gate has cleared.
Control each critical blend component with its own forecast, reorder point, and approved bridge profile. Start replacement cupping while the current component still has adequate cover. Define the sensory function that must remain stable, then approve an alternate lot before urgency forces the production team to accept an untested substitution.
Update inventory transactions as they occur, review critical coverage weekly, and rebuild the rolling forecast at least monthly. Recalculate sooner after a major wholesale win, promotion, shipment delay, quality hold, or demand miss. Keep the prior forecast so the buyer can measure error instead of continually replacing the evidence.
About This Insight: Written by Ethio Coffee Import and Export PLC, an origin-connected Ethiopian coffee exporter with three decades of sourcing relationships across Yirgacheffe, Sidamo, Guji, Harar, Limu, and Jimma. Published Jul 13, 2026.