Keep an Essential Oil Reorder Planning Record

Define which units are actually available to sell

Start with a dated physical or system stock record for each complete SKU. Keep saleable units separate from held stock, damaged units, samples and units already allocated to customer orders. State whether the available number has already deducted those allocations. Otherwise two people can use the same spreadsheet and arrive at different buying decisions while both believe they are using 'stock on hand.'

Include the product, fill size, label version and batch reference where used in your records. Similar bottles should not be pooled if they cannot fulfil the same customer order. Keep product condition, remaining usable life and any review hold visible under your agreed handling arrangements. A unit that needs further review should not silently become available just because the total is low.

Separate recorded demand from a future assumption

Use a defined observation period and describe what your demand measure contains: shipped units, accepted customer orders or another explicitly chosen measure. Do not mix them without explaining how double counting is prevented. Record promotions, channel changes or unusual orders alongside the data so a temporary spike does not become an unexplained permanent forecast.

The future planning rate is an assumption even when it is informed by past movements. Write a baseline and, where useful, a higher or lower scenario. For a new SKU with little history, record the reasoning rather than giving a precise number an undeserved sense of certainty. Set a review date so assumptions can change when actual orders provide better information.

Record the complete timing conversation

Ask what must happen before the next production schedule can be confirmed. Material review, packaging availability, artwork changes and approvals can affect the sequence. Keep the supplier's confirmed timing, its starting conditions and the confirmation date together. A duration remembered from the opening order is not confirmation of the next one.

Track incoming supply separately from a planned enquiry. Record order reference, quantity, current status and expected usable receipt date, with the basis for that expectation. Arrival, receiving checks and release into saleable stock are different events. If an incoming date is uncertain, show that uncertainty in the planning scenario instead of treating the order as ready for customers.

• Supplier timing confirmation and starting conditions
• Incoming order reference, quantity and current status
• Expected arrival and receiving review assumptions
• Date and owner of the next timing check

Use a simple hypothetical gap calculation

Assume, solely for this example, that one SKU has 320 saleable bottles after existing customer allocations have been deducted. The buyer is planning at 40 bottles per week for the next six weeks. With no incoming supply in that period, the scenario would use 240 bottles and leave 80. That is an arithmetic view of the assumptions, not a forecast of actual sales or a recommended stock level.

Now test a higher scenario of 60 bottles per week using the same six-week period. It would require 360 bottles, revealing a possible 40-bottle gap. The useful result is the question: what can the team confirm or change? Review demand, timing, the order scope and customer commitments. Do not convert the gap directly into a purchase quantity without those checks.

Keep a dated review and a deliberate next action

Use one row per SKU per review date, with links to the previous review and any resulting order. Capture saleable quantity, planning rate, period, incoming supply, timing assumptions, scenario result and action. Actions may include requesting a new quotation, clarifying a receipt date, reviewing slow-moving stock or scheduling another check. 'Buy more' is not the only possible outcome.

Before a reorder is accepted, confirm whether the specification, packaging, artwork and commercial scope remain unchanged. Keep any revision visible and obtain the required approvals. PanPan Aroma reviews repeat sourcing with the selected project information through partner manufacturers. This method supports operational record keeping; it does not recommend inventory investment, promise sales or provide financial advice.