Sales forecasting estimates how many units a business expects to sell during a specific period. Purchasing planning translates those estimates into actual procurement requirements.

When these two functions operate independently, businesses may encounter several problems:

• Overstocking: Purchasing quantities exceed actual customer demand, increasing storage costs and tying up working capital.
• Stockouts: Purchasing plans fail to account for demand growth or supplier lead times, leaving insufficient inventory to fulfill orders.
• Unnecessary purchasing costs: Frequent small orders, urgent shipments, or poorly timed purchases increase total procurement expenses.
• Poor cash flow management: Excessive inventory purchases reduce the cash available for marketing, product development, and daily operations.
• Unstable supply planning: Suppliers receive inconsistent order volumes, making production scheduling and delivery coordination more difficult.

The objective is not to make purchasing quantities match sales forecasts exactly. Instead, purchasing plans should account for expected demand, available stock, replenishment timing, and an appropriate safety buffer.

A well-aligned purchasing plan connects three key elements: expected sales, inventory availability, and the time required to replenish stock. When these elements are reviewed together, businesses can make purchasing decisions based on actual requirements rather than reacting to sales fluctuations after they occur.

The quality of a purchasing decision depends heavily on the quality of the sales forecast behind it.

Before placing an order, review historical sales data and identify the factors most likely to influence future demand.

Analyze Historical Sales Performance

Start by reviewing sales over the previous 6–12 months, if sufficient data is available. For products with strong seasonal patterns, compare performance with the same period in previous years.

Useful data includes:

• Monthly and weekly sales volumes
• Sales growth or decline by SKU
• Seasonal demand fluctuations
• Promotional campaign performance
• Product returns and cancellations
• Sales channel performance
• Current orders and confirmed customer commitments

Historical data provides a baseline, but it should not be treated as a guarantee of future sales.

For example, a product that sold 1,000 units last month may not sell the same quantity next month if the previous period included a major promotion or a temporary demand spike.

Businesses should also distinguish between gross sales and actual inventory consumption. Cancellations, returns, backorders, and channel-specific inventory movements may affect the number of units that need to be replenished.

Separate Baseline Demand from Exceptional Demand

Not every increase in sales should trigger a permanent increase in purchasing volume.

Distinguish between regular demand and temporary changes caused by discounts, influencer campaigns, new distribution agreements, or other unusual events.

If a promotion increases sales by 60% for two weeks, automatically using that sales rate for the next three months could result in excess inventory.

Instead, estimate how much of the increase is likely to continue after the promotion ends. Where possible, compare promotional periods with previous campaigns and examine whether higher sales were sustained after the campaign finished.

Include Upcoming Business Plans

Sales forecasts should reflect more than historical performance. Consider planned activities such as:

• New product launches
• Marketing campaigns
• Entry into new markets
• Expansion to additional sales channels
• Changes in pricing
• Seasonal promotions
• Major customer orders

Collaborating with sales and marketing teams helps purchasing managers understand the assumptions behind forecast changes and determine whether additional inventory is justified.

A forecast should also distinguish between confirmed demand and potential demand. A large sales opportunity may justify preparing suppliers and reviewing capacity, but it does not always justify committing to a large purchase order before the opportunity becomes sufficiently certain.

Once demand has been estimated, the next step is to calculate how much inventory needs to be purchased.

A common mistake is to use forecasted sales as the purchase quantity without accounting for stock already available or orders already in progress.

Where:

• Forecasted demand is the expected sales volume during the planning period.
• Target ending inventory is the stock you want to retain at the end of that period.
• Available inventory is usable stock currently on hand, after accounting for damaged, reserved, or otherwise unavailable units.
• Confirmed incoming inventory is stock expected to arrive within the relevant planning period.

The formula assumes that incoming inventory will arrive in time to meet demand. If a shipment is expected after the selling period, it should not be counted as available for that period.

The result may need to be adjusted for supplier minimum order quantities, case-pack requirements, production constraints, and purchasing budgets.

Purchasing Calculation Example

Suppose an online retailer is preparing a purchasing plan for a product with the following figures:

The business therefore needs approximately 1,800 additional units to meet forecasted demand and reach its target ending inventory.

In this example, the target ending inventory already includes safety stock. Adding the safety-stock quantity again would overstate the purchasing requirement.

If the calculated purchase requirement is negative, the immediate replenishment requirement is generally zero, although existing contractual commitments and supplier constraints may still need to be addressed.

Before confirming the order, the purchasing team should check whether the 400 incoming units will arrive before they are needed. If those units are delayed beyond the selling period, the business may still face a stockout despite having sufficient inventory on paper.

A purchasing plan can be mathematically correct and still fail if the order is placed too late.

Supplier lead time includes the time required for order confirmation, production, quality inspection, shipment preparation, transportation, customs clearance, and delivery to the destination warehouse, as applicable.

For international sourcing, the full replenishment cycle can be considerably longer than the factory’s quoted production time.

A factory may quote 30 days for production, but that does not mean the goods will arrive at the destination warehouse within 30 days. Production scheduling, inspection, freight arrangements, ocean transit, customs clearance, and final delivery must also be considered.

Calculate When to Place an Order

For example, a product has:

• Average daily demand: 40 units
• Total replenishment lead time: 35 days
• Safety stock: 300 units

The reorder point is:

When the inventory position reaches approximately 1,700 units, the business should evaluate whether to place a replenishment order.

Inventory position generally includes usable on-hand inventory plus confirmed incoming inventory, minus outstanding customer commitments or backorders. Businesses should apply a consistent definition so that stock is not counted twice.

The reorder point is a trigger for review, not an instruction to order automatically in every situation. Purchasing teams should also consider demand changes, supplier reliability, available cash, and the quantity required for the next replenishment cycle.

Plan Backward from the Required Delivery Date

If inventory is needed before a seasonal promotion or product launch, calculate the latest safe order date by working backward from the required warehouse arrival date.

Allow time for:

1. Supplier confirmation and production scheduling
2. Manufacturing and packaging
3. Pre-shipment quality inspection
4. Freight booking and transportation
5. Customs clearance and final delivery
6. Contingency for unexpected delays

Illustrative Lead-Time Planning for International Ocean Freight

The following table illustrates how international ocean-freight lead times can be broken down for planning purposes. These are indicative estimates, not guaranteed transit times or universal industry standards.

Planning note: Confirm actual production and transit estimates with the supplier and freight forwarder before committing to a delivery date.

Actual lead times can fall outside these ranges. Buyers should confirm the production schedule with the supplier and obtain route-specific transit estimates from the freight forwarder. Peak-season congestion, holiday closures, customs inspections, and unexpected disruptions can all affect delivery.

For a product with a 30-day production cycle, 35 days of ocean transit, and 10 days for clearance and final delivery, the estimated cycle is 75 days before any additional buffer. Including a 7–14-day contingency allowance brings the planning window to approximately 82–89 days.

This is why international buyers should plan against the expected warehouse arrival date rather than the factory’s production completion date alone.

Safety stock protects businesses against unexpected demand increases and supply delays. However, maintaining excessive safety stock can increase storage expenses, reduce cash availability, and create obsolescence risks.

The right level depends on the characteristics of each product.

Consider the following factors when setting safety stock:

• Demand variability: Products with unpredictable sales may require a larger buffer.
• Supplier reliability: Frequent production delays justify additional protection.
• Replenishment time: Longer lead times generally increase exposure to demand and supply fluctuations.
• Product importance: Stockouts of best-selling products may have a greater commercial impact than stockouts of low-volume items.
• Product lifecycle: New or short-lived products may not justify large safety-stock commitments.
• Cost of holding inventory: Bulky, expensive, or perishable products require more careful inventory decisions.

A practical approach is to classify products by sales volume, profitability, demand stability, and replenishment risk rather than applying the same safety-stock percentage to every SKU.

A Quantitative Method for Estimating Safety Stock

For businesses with reliable historical demand and supplier lead-time data, a quantitative method can help estimate an appropriate safety buffer.

When both demand and replenishment lead time vary, a commonly used approximation is:

Demand and lead-time measurements must use consistent time units. For example, if demand is measured weekly, lead time must also be expressed in weeks.

This approximation assumes that demand and lead-time variability can be modeled appropriately and are independent. Actual requirements may differ when demand is seasonal, intermittent, or affected by promotions.

For businesses with relatively stable lead times, a simpler formula may be sufficient:

Common Z values include:

Safety Stock Calculation Example

A product has a weekly demand standard deviation of 50 units, a replenishment lead time of five weeks, and a target cycle service level of 95%.

This provides an initial estimate of safety stock. Review the result against actual stockout history, supplier reliability, holding costs, and the commercial importance of the product before adopting it as an operating target.

The service-level factor should also be interpreted carefully. A 95% cycle service level refers to the probability of avoiding a stockout during a replenishment cycle under the model’s assumptions. It does not mean that 95% of all units demanded will necessarily be fulfilled.

Not every product should follow the same purchasing strategy. Product characteristics determine how much inventory risk a business can reasonably accept.

This approach allows purchasing teams to allocate capital according to commercial priorities rather than simply ordering more of the products that sold well in the past.

For new products, businesses should be especially cautious about using forecasts based entirely on similar products. Customer preferences, pricing, positioning, and competition can all influence launch performance.

For established products with stable demand, automated reorder alerts and regular replenishment schedules may be more appropriate. The purchasing strategy should reflect the actual behavior and risk profile of each product.

Sales forecasting should not be the responsibility of one department alone.

Sales teams understand customer demand and pipeline opportunities. Marketing teams know the timing of campaigns and promotions. Purchasing teams understand supplier capacity, production schedules, and minimum order quantities. Finance teams monitor cash availability and working capital requirements.

When these teams use different assumptions, purchasing decisions can become inconsistent.

For example, marketing may plan a major promotional campaign without informing purchasing. The campaign generates higher demand, but the additional stock cannot arrive in time.

A coordinated planning process helps prevent this type of mismatch.

Establish a Regular Planning Cycle

Businesses with volatile demand may need more frequent reviews, while companies selling stable products may operate effectively with a less intensive cycle.

A shared forecast should identify the assumptions behind significant changes, including planned promotions, expected customer orders, price adjustments, and supply constraints.

The important point is to establish a consistent process for updating forecasts and translating meaningful changes into purchasing decisions.

Even a well-prepared sales forecast will contain errors. The objective is to identify those errors early enough to adjust purchasing plans.

One useful measurement is forecast error:

If a product was forecast to sell 1,000 units but actually sold 1,200 units, the forecast underestimated demand by 200 units.

If actual sales were only 800 units, the forecast overestimated demand by 200 units.

Businesses should review forecast errors over time to determine whether forecasts consistently overestimate or underestimate demand.

Forecast accuracy should be measured consistently, using the same time horizon, SKU scope, and sales definitions. A forecast created three months before delivery should not be compared directly with a last-minute forecast without accounting for the difference in planning horizon.

Track Useful Purchasing and Inventory Metrics

No single metric provides a complete picture. High inventory turnover, for example, may indicate efficient inventory management, but it can also reflect insufficient stock if products frequently become unavailable.

Businesses should establish internal targets using historical results, product characteristics, customer expectations, and supplier performance. Review the metrics together to balance product availability, purchasing costs, and working capital efficiency.

Market demand can change after a purchase order has been placed. A new competitor, an unexpected promotion, changing customer preferences, or a slower-than-expected sales period can all affect inventory requirements.

The appropriate response depends on the stage of the purchasing process.

For products with relatively stable demand, staged purchasing or split deliveries may help reduce inventory exposure. However, these arrangements should be agreed upon in advance, with clear terms for pricing, storage, quality control, delivery schedules, and responsibility for any damage or loss.

The key is to respond to meaningful changes in demand without repeatedly changing purchase orders based on short-term fluctuations.

Worked Example: When the Calculated Quantity Meets the MOQ

The calculation in Section 3 may produce a quantity the supplier will not accept.

Suppose the calculated purchase requirement is 1,800 units, but the supplier’s minimum order quantity (MOQ) is 3,000 units and the price breaks are:

Option 1: Order the MOQ and Accept the Extra Inventory

This may be reasonable if the product sells steadily and the additional 1,200 units are expected to sell within an acceptable period without creating significant obsolescence or storage risks.

Option 2: Negotiate a Lower MOQ or a Trial Order

Some factories may accept a smaller initial order at a higher unit price or agree to split deliveries. Buyers should confirm the commercial terms, including whether the supplier requires payment for the full quantity upfront.

Option 3: Combine the Order with Another SKU

Where production capabilities and supplier policies allow, combining products may help meet minimum production requirements while keeping inventory more balanced across SKUs.

The following factors should guide the decision:

• Expected sell-through rate of the additional inventory
• Storage and financing costs
• Product obsolescence risk
• Available working capital
• Price savings from larger quantities
• Flexibility of future replenishment

A lower unit price does not automatically make a larger order more profitable. The total cost of holding and eventually selling the additional inventory must also be considered.

Worked Example: When In-Transit Inventory Arrives Late

Section 3 also highlighted the importance of confirming when incoming inventory will arrive.

Suppose 400 units are scheduled to arrive at the end of week 6, but the selling period ends at the end of week 5. The business effectively has only 500 units available during the selling period, rather than the 900 units it expected to have.

If a stockout would cause significant lost sales, the buyer can consider:

• Expediting part of the shipment: Compare the additional air-freight cost with the expected financial benefit of making the stock available earlier.
• Placing a supplementary order: Explore a faster supplier or local distributor, taking the higher unit cost into account.
• Reallocating inventory: Transfer stock from another warehouse or sales channel if the business has usable inventory elsewhere.
• Managing demand temporarily: Adjust promotional timing or product availability messaging where commercially appropriate.

The decision should be made as soon as the delay is confirmed, not when the stockout occurs.

A useful decision principle is to compare the incremental cost of expediting against the expected contribution margin preserved and other avoidable stockout costs. Account for the likelihood that the goods would otherwise sell, the remaining selling window, any additional handling expenses, and the costs already incurred under the original shipping arrangement.

Expediting is not automatically the best choice. If demand is uncertain or the product can be replenished before customers are significantly affected, accepting the delay may be more economical.

A consistent decision-making framework makes it easier to connect sales expectations with actual procurement actions.

Before approving a purchase order, review the following questions:

1. Is the sales forecast realistic? Check historical sales, upcoming promotions, and confirmed customer demand.
2. How much usable inventory is available? Include confirmed incoming stock and outstanding commitments without counting the same inventory twice.
3. When will replenishment be needed? Calculate lead time and the expected inventory position at arrival.
4. How much safety stock is appropriate? Consider demand uncertainty, supplier reliability, and the cost of holding inventory.
5. Does the order meet supplier requirements? Check minimum order quantities, packaging specifications, and production capacity. If not, decide explicitly whether to accept the excess, negotiate, or combine orders.
6. Can the business afford the purchase? Review payment terms, cash flow, and other upcoming commitments.
7. What happens if demand changes? Identify options for adjusting quantities, delivery schedules, or future orders, and confirm any agreed flexibility with the supplier in writing.

This framework helps businesses move away from reactive purchasing and toward decisions based on demand, inventory, and financial priorities.

The seven questions should be used as a decision gate rather than a checklist completed after the purchase has already been approved.

If an order only works if an incoming shipment arrives on time, or if the MOQ forces inventory well above the target level, the purchasing team should revisit the plan before committing.

A structured approval process also creates a record of why a purchase was made, which assumptions were used, and what risks were accepted. This information becomes valuable when reviewing forecast accuracy and improving future purchasing decisions.