Running out of a fast-moving product and overbuying a slow one often come from the same problem: purchasing decisions are not connected to demand, inventory, supplier lead time and available cash.
Purchase planning helps you decide what to buy, how much to order, when to place the order and how much cash to commit. Instead of waiting until stock is almost gone or buying because a supplier offers a discount, you use a repeatable set of inventory and purchasing inputs.
In this guide, you will learn a practical method for planning inventory purchases using average demand, available inventory, safety stock, supplier lead time, reorder points and a purchasing budget. You can also download a free Purchase Planning Excel Template to apply the method to your own products.
| Decision | Question to Answer | Main Inputs |
|---|---|---|
| What to buy | Which items need attention first? | Demand, criticality, inventory position |
| How much | How many units should you order? | Projected demand, available inventory, safety stock |
| When | When should the order be placed? | Average demand, lead time, reorder point |
| Budget | How much cash should you commit? | Unit cost, purchasing priorities, available budget |
Table of Contents
- What Is Purchase Planning?
- Purchase Planning vs. Inventory Management vs. Procurement
- What Data Do You Need Before Planning Purchases?
- How to Plan Inventory Purchases Step by Step
- Three Useful Purchase Planning Calculations
- Purchase Planning Example
- How to Adjust the Purchase Plan to Your Budget
- How to Prioritize Urgent, Monitor and Healthy Items
- Free Purchase Planning Excel Template
- Common Purchase Planning Mistakes
- Frequently Asked Questions
- Methodology and References
What Is Purchase Planning?
Purchase planning is the process of deciding which products or materials to buy, how much to order and when to place the order based on expected demand, current inventory, supplier lead times and available budget.
The objective is not to keep as much inventory as possible. It is to maintain enough stock to support sales or operations without tying up unnecessary cash in products that may not move quickly.
For a retailer or ecommerce business, the plan may cover products for resale. For a restaurant, it may cover ingredients and packaging. For a service business, it may include parts, materials or consumables.
The underlying decision is similar in each case: replenish what the business needs before a shortage occurs, without buying more than demand and cash flow can reasonably support.
Purchase Planning vs. Inventory Management vs. Procurement
These concepts are related, but they do not answer exactly the same question.
| Area | Main Question |
|---|---|
| Inventory management | What inventory do we have, where is it and how is it moving? |
| Purchase planning | What should we replenish, how much and when? |
| Procurement | How should we source, evaluate, negotiate with and manage suppliers? |
This guide focuses primarily on purchase planning and inventory replenishment. Supplier selection, commercial terms and broader sourcing decisions are important, but they are separate decisions.
If you are comparing vendors rather than calculating replenishment needs, use our Supplier Evaluation guide and scorecard.
What Data Do You Need Before Planning Purchases?
A useful purchase plan does not require dozens of metrics, but it does require reliable basic data.
| Input | Why It Matters |
|---|---|
| SKU | Identifies the exact product or variant being replenished. |
| Average daily demand | Estimates how quickly inventory is being used or sold. |
| On-hand inventory | Shows the physical units currently in stock. |
| Allocated inventory | Separates units already committed to customers or operations. |
| Available inventory | Shows what remains available after allocations. |
| Supplier lead time | Shows how long replenishment takes after an order is placed. |
| Safety stock | Provides a buffer against demand or delivery uncertainty. |
| Unit cost | Converts order quantities into cash requirements. |
| Available budget | Defines how much the business is prepared to commit during the purchasing cycle. |
If your product catalog does not yet use consistent internal identifiers, start with our guide on how to create SKU numbers. Purchase planning becomes much harder when the same item is identified differently across purchasing, inventory and sales.
Data quality matters more than spreadsheet complexity. A sophisticated formula built on outdated demand or unrealistic supplier lead times will still produce a poor purchase decision.
How to Plan Inventory Purchases Step by Step
1. Build a Reliable Product List
Start with the items you actually need to manage. Each item should have a unique SKU, product name, supplier, unit cost, lead time and safety stock assumption.
Avoid planning several variants as if they were one item when they are purchased or stocked separately. A medium black T-shirt and a large black T-shirt, for example, require separate replenishment decisions if each variant has its own inventory.
2. Estimate Average Demand
Use recent sales or consumption history to estimate how many units are normally used or sold per day.
Do not treat a temporary promotion, holiday peak or unusual stockout period as normal demand without adjustment. The objective is to create a reasonable operating assumption, not to pretend demand is perfectly predictable.
The Excel template does not forecast demand automatically. Average Daily Demand is an input that you must review and maintain.
3. Calculate Available Inventory
Physical inventory and usable inventory are not always the same.
If 90 units are physically in stock but 12 are already reserved for existing orders, only 78 units are available for new demand.
Available Inventory = On-Hand Inventory − Allocated Inventory
Ignoring allocations can make the business appear better stocked than it really is.
4. Review Supplier Lead Time and Safety Stock
Lead time is the number of days between placing an order and receiving the product.
Use a realistic supplier lead time rather than an optimistic promise. If a supplier usually delivers in seven days, planning as if delivery takes three days can trigger replenishment too late.
Safety stock is the buffer you keep to absorb uncertainty in demand or replenishment. The right amount depends on the item, variability, service expectations and the cost of holding additional inventory.
The basic template lets you enter safety stock manually. It does not calculate an optimized statistical safety stock automatically.
5. Calculate the Reorder Point
The reorder point answers when to place a replenishment order.
For a simple model:
Reorder Point = Average Daily Demand × Lead Time + Safety Stock
If available inventory reaches or falls below that level, replenishment should receive immediate attention.
A reorder point does not tell you how many units to buy. It tells you when action is required.
6. Define a Planning Horizon and Calculate Projected Demand
The planning horizon is the period you want the purchase plan to cover.
If your average daily demand is 12 units and you are planning the next 21 days:
Projected Demand = 12 × 21 = 252 units
The horizon should match the way you operate. A fast-moving business may review purchases weekly, while a more stable category may use a longer planning cycle.
7. Calculate a Suggested Order Quantity
Once you know projected demand, available inventory and the safety stock you want to protect, you can estimate an initial purchase quantity.
Suggested Order Qty = Projected Demand + Safety Stock − Available Inventory
If the result is negative, the practical order quantity is zero rather than a negative purchase.
This is a simple planning formula used by the template. It is not a universal optimization model and does not automatically account for minimum order quantities, case packs, freight thresholds or volume discounts.
8. Compare the Plan With Your Purchasing Budget
The mathematically suggested quantity is not automatically the quantity you should order.
Multiply the suggested quantity by unit cost and compare the resulting purchase plan with the cash you are willing and able to commit.
If the plan exceeds your budget, prioritize the items that protect sales and operations, then reduce or defer lower-priority quantities.
This is where purchasing and finance meet. Inventory is part of the capital tied up in day-to-day operations, so a purchase that looks reasonable from an inventory perspective can still create liquidity pressure. Our Working Capital guide explains that relationship in more detail.
Three Useful Purchase Planning Calculations
| Calculation | Formula | What It Tells You |
|---|---|---|
| Available Inventory | On-Hand Inventory − Allocated Inventory | What is actually available for future demand |
| Reorder Point | Average Daily Demand × Lead Time + Safety Stock | When replenishment should be triggered |
| Suggested Order Qty | Projected Demand + Safety Stock − Available Inventory | An initial quantity to cover the planning horizon |
You can also calculate Days of Coverage:
Days of Coverage = Available Inventory ÷ Average Daily Demand
Coverage is useful because it converts inventory units into time. Instead of only seeing that you have 78 units, you can see how many days those 78 units are expected to last at the current demand rate.
Purchase Planning Example
The Excel template includes a built-in example for a small cleaning-products business. Consider one of its products: All-Purpose Cleaner 1 L.
| Input | Example |
|---|---|
| Average Daily Demand | 12 units |
| On-Hand Inventory | 90 units |
| Allocated Inventory | 12 units |
| Available Inventory | 78 units |
| Supplier Lead Time | 7 days |
| Safety Stock | 25 units |
| Planning Horizon | 21 days |
| Unit Cost | $6.20 |
Step 1: Project Demand
Projected Demand = 12 × 21 = 252 units
Step 2: Calculate the Reorder Point
Reorder Point = 12 × 7 + 25 = 109 units
Available inventory is only 78 units, which is already below the 109-unit reorder point. The item therefore requires immediate replenishment attention.
Step 3: Calculate Days of Coverage
Days of Coverage = 78 ÷ 12 = 6.5 days
Step 4: Calculate the Suggested Order Quantity
Suggested Order Qty = 252 + 25 − 78 = 199 units
Suggested Order Cost = 199 × $6.20 = $1,233.80
Step 5: Apply Business Judgment
In the workbook example, the final adjusted quantity is 180 units rather than 199.
Adjusted Order Cost = 180 × $6.20 = $1,116.00
The adjustment does not mean the original calculation was wrong. It means the business is separating the calculated inventory need from the quantity it actually authorizes after considering budget and priorities.
How to Adjust the Purchase Plan to Your Budget
The template’s full example contains eight products and an available purchasing budget of $3,500.
| Summary | Amount |
|---|---|
| Total Suggested Order Cost | $3,513.90 |
| Total Adjusted Order Cost | $3,138.00 |
| Remaining Budget | $362.00 |
The suggested plan is slightly above the available budget. The example therefore uses manual adjusted quantities and leaves part of the budget uncommitted.
This is intentional. The spreadsheet calculates a purchasing need, but it does not automatically optimize the final allocation of cash across products.
When cash is limited, consider:
- whether the item is essential for sales or operations;
- how close available inventory is to the reorder point;
- how quickly the item is consumed or sold;
- how long replenishment takes;
- whether another item can substitute for it;
- how much cash you need to preserve for other operating obligations.
How to Prioritize Urgent, Monitor and Healthy Items
The Excel template uses four operational statuses to make the purchase plan easier to review.
| Status | Meaning in the Template | What to Do |
|---|---|---|
| Urgent | Available inventory is at or below the reorder point. | Review replenishment immediately. |
| Monitor | Coverage is approaching the supplier lead-time window. | Prepare or review the next purchase. |
| Healthy | Current coverage is above the monitoring threshold. | Continue monitoring; no immediate replenishment signal. |
| Review | Required data is missing, invalid, duplicated or unsafe to calculate. | Correct the data before using totals or placing an order. |
These statuses are decision aids created for this workbook. They are not universal inventory-management classifications.
The Critical Item field is also informational. Marking an item as critical helps you apply business judgment, but it does not automatically change the formulas or force that product to the top of the purchase plan.
Free Purchase Planning Excel Template
The free InfoExperiencia workbook is designed for small businesses that want a practical purchasing routine before moving to more complex inventory or ERP software.
It supports up to 200 products and includes five sheets:
- Instructions: explains the workflow, editable fields, alerts and limitations.
- Glossary: defines the main purchasing and inventory terms in plain English.
- Product Data: stores SKU, product, supplier, unit cost, lead time, safety stock and critical-item information.
- Purchase Planning: calculates available inventory, projected demand, reorder point, coverage, suggested order date, suggested order quantity, costs and status.
- Summary: compares the purchasing plan with your available budget and summarizes item priorities.
Important: the workbook is a basic-to-intermediate planning tool. It does not automatically forecast demand or model every supplier restriction.
Minimum order quantities, case packs, freight, taxes, quantity discounts, supplier capacity and service-level targets must still be reviewed separately when they apply to your business.
Common Purchase Planning Mistakes
Using Outdated Demand
A reorder calculation built on demand that no longer reflects the business can recommend the wrong quantity even when the formula itself is correct.
Using On-Hand Inventory Instead of Available Inventory
Units already allocated or committed should not be treated as freely available for future demand.
Underestimating Supplier Lead Time
An unrealistically short lead time delays the reorder trigger and increases stockout risk.
Using the Same Safety Stock for Every Item
Products differ in demand variability, supplier reliability, criticality and holding cost. A single buffer rule may not be appropriate for the entire catalog.
Confusing Reorder Point With Order Quantity
The reorder point tells you when replenishment should be triggered. It does not automatically tell you how many units to order.
Buying Because of a Discount
A lower unit price does not automatically make a purchase profitable. Excess inventory can consume cash and storage space long after the discount has been forgotten.
Ignoring the Purchasing Budget
An item may need replenishment and still require a smaller or phased purchase if committing the full amount would create unnecessary liquidity pressure.
Treating the Spreadsheet as an Automatic Purchase Order
The calculated quantity is a planning input. Before placing an order, review supplier restrictions, pack sizes, commercial terms, cash requirements and any unusual demand conditions.
Frequently Asked Questions
What is purchase planning?
Purchase planning is the process of deciding what inventory or materials to buy, how much to order and when to place the order using demand, inventory, supplier and budget information.
What is the difference between a reorder point and an order quantity?
The reorder point is an inventory threshold that indicates when replenishment should be triggered. The order quantity is the number of units you decide to purchase.
How often should I review my purchase plan?
The review frequency depends on how quickly demand, inventory and supplier conditions change. Fast-moving items may require weekly or even more frequent review, while stable categories may be reviewed less often.
Should every product have safety stock?
Not necessarily. Safety stock should reflect the uncertainty and importance of the item. Stable, noncritical products may require a different buffer than items with volatile demand or unreliable replenishment.
Can I use purchase planning without inventory software?
Yes. A spreadsheet can be sufficient for a small catalog if inventory records, demand assumptions and supplier data are maintained consistently. As complexity grows, more specialized inventory or planning systems may become appropriate.
What should I do if the suggested purchase exceeds my budget?
Do not automatically divide the budget equally across products. Review urgency, criticality, demand, lead time and available substitutes, then adjust lower-priority quantities while protecting the items most important to sales or operations.
Methodology and References
This guide uses a simplified small-business purchasing model built around demand, available inventory, replenishment lead time, safety stock, reorder points, order quantities and purchasing budget. The model is intended for practical planning rather than advanced inventory optimization.
- SAP: reorder point planning, average requirements during replenishment lead time, safety stock and purchasing triggers.
- Oracle Inventory: reorder point planning, forecast demand during lead time, safety stock and replenishment-order logic.
- Association for Supply Chain Management (ASCM/APICS): inventory replenishment, order-point techniques, safety stock and order-quantity decisions.
- North Carolina State University Supply Chain Resource Cooperative: safety stock, lead-time uncertainty and reorder-point models.
- Virginia Tech Cooperative Extension: inventory management, safety stock, supplier lead time and reorder-point applications.
- U.S. Small Business Administration: inventory and supplies as working-capital uses for small businesses and the importance of current inventory information when managing financing needs.
You can find more practical operations and purchasing resources in the Processes & Operations section.
The goal of purchase planning is not to predict every future purchase perfectly. It is to replace reactive buying with a repeatable decision process based on better information.
Discover more from
Subscribe to get the latest posts sent to your email.
