How to Forecast Inventory for Target: Replenishment, Velocity and Cash

Forecasting inventory for Target means forecasting two things at once: what shoppers pull off the shelf in each of your authorized stores, and what Target's replenishment system will order from you to keep its distribution centers and shelves at target cover. Get the first right and the second becomes predictable.

How Target orders from a supplier

Target runs a centralized DC replenishment model. You ship to Target's distribution network, not to stores, and Target's own system moves product from DCs to its roughly 1,900-plus stores. Faster-moving items typically route through regional DCs that serve a cluster of stores; slower movers may be held upstream and flowed to regional DCs as needed. The practical consequence is that your PO reflects Target's inventory position across its network, not what any single store sold this week.

POs arrive by EDI, and suppliers see item-level sales, store inventory and forecast information through Target's supplier portal (Partners Online). That data is your most valuable forecast input, because it separates store on-hand from DC on-hand. When DC on-hand is high and store sales are steady, do not expect a PO soon, even if the buyer is enthusiastic.

Three more patterns matter:

• Test-and-learn launches. Many new items start in a subset of stores (a few hundred doors) before a chain-wide expansion decision at the next planogram transition. Model the test doors, then model the expansion as a separate scenario with its own pipeline fill.
• Planogram transitions. Target resets categories on a schedule, often spring and fall for consumables, with additional seasonal sets. A transition can add facings, remove them, or move your item to a different shelf position, and each of those changes the opening fill and the velocity.
• Store-fulfilled digital. Many Target.com orders ship from or are picked up at stores, so store inventory depletes from online demand too. Treat Target.com as part of store velocity unless Target gives you a separate order stream.

Velocity and door-count math

The core equation for any retailer applies here. Weekly retail demand = units per store per week x active doors. For Target, pull units per store per week from the portal once you have sales history; before launch, use category benchmarks or a comparable item's velocity, and be conservative, since launch-week velocity is inflated by display and newness.

Then translate demand into Target's order behavior. Target's system targets a weeks-of-cover level at the DC, so a PO is triggered roughly when DC on-hand drops below that target. Written out:

Weeks of supply at Target = (DC on-hand + store on-hand) / weekly retail demand

Reorder point (your view) = weekly retail demand x Target's inbound lead time in weeks + DC safety stock

Ask your supply chain contact what cover the system is set to for your item; a few weeks is typical for shelf-stable consumables, but it varies by category and item speed. Then build the PO forecast as the quantity needed to bring Target back to target cover each time it crosses the reorder point, rounded to case pack and often to pallet layer.

The promotional calendar and what it does to inventory

Target's biggest supplier-relevant events are Target Circle Week (typically spring and fall), the back-to-school and holiday seasons, and category-specific features in the weekly ad and the Target Circle app. Each promotion does three things to your forecast:

1. It pulls Target's PO forward. Target builds DC inventory ahead of the event, so expect a larger PO two to four weeks before the promotion, not during it.
2. It lifts sell-through during the event. Lift varies widely by category and depth of discount; use your own history or a comparable item's, and plan for the display or endcap, not just the shelf.
3. It leaves a dip afterward. Shoppers who stocked up do not return at normal cadence for a few weeks, and Target's DC will be over cover, so the post-promo PO is late or small.

Model all three or the cash view will be wrong even when annual volume is right. The Target forecasting template has the pull-forward and dip built in as adjustable weeks.

Fill rate, OTIF and deductions

Target measures suppliers on on-time and in-full delivery to its DCs and typically charges back a percentage of the PO value for late or short shipments. It also deducts for labeling, ASN and routing non-compliance. Treat these as a planned cost line, not a surprise: build a deductions assumption of a few percentage points of gross into the forecast until your own history gives you a real rate, and track it monthly against what Target actually takes. Protecting fill rate is the main reason to hold safety stock in your own warehouse; a missed PO costs the chargeback, the sales and the velocity data that justifies expansion.

On payment, Target pays on net terms that typically run around 60 days from receipt, though terms vary by supplier and program and early-payment programs exist. Confirm your terms in writing and model them exactly; the gap between paying your co-manufacturer and receiving Target's payment is where launches run out of cash.

A worked example: Ridgeline Provisions at Target

Take a fictional snack brand we will call Ridgeline Provisions, launching one SKU in a 500-store test at Target. Assumptions: 6 units of shelf capacity per store, velocity of 2.5 units per store per week, case pack of 12, wholesale price $2.40, landed cost $1.10, co-manufacturer lead time 10 weeks with payment on delivery, Target terms 60 days, deductions 3% of gross, and Target holding 3 weeks of DC cover.

• Steady weekly demand: 2.5 x 500 = 1,250 units, or 104 cases a week.
• Opening PO (pipeline fill): shelf fill of 6 x 500 = 3,000 units, plus DC cover of 3 x 1,250 = 3,750 units, for 6,750 units, rounded to 563 cases (6,756 units).
• Opening PO value: 6,756 x $2.40 = $16,214 gross, about $15,728 after 3% deductions.
• Production to cover launch plus 8 weeks of replenishment: 6,756 + (8 x 1,250) = 16,756 units, rounded to 1,397 cases (16,764 units). At $1.10 landed, that is $18,440 of inventory paid to the co-manufacturer roughly 10 weeks before the first Target PO ships.
• Cash gap: inventory paid in week 0, first PO ships in week 10, Target pays in week 19. The first replenishment POs (weeks 12 through 18) are paid in weeks 21 through 27. Ridgeline carries roughly $18,000 of cash out for about five months before the account turns cash positive, and that is before the Circle Week pull-forward, which adds another PO of roughly 1,250 extra units three weeks ahead of the event.
• Expansion scenario: if the test converts to 1,500 doors at the next transition, the new pipeline fill is 3 times larger (about 20,000 units) and the weekly run rate triples. The question becomes "can we fund roughly $55,000 of inventory ahead of a PO that pays 60 days after receipt."

That last question is what the open-to-buy and PO cash commitment template answers, and it belongs in the model before you say yes to the buyer. For how Target fits alongside other accounts, see our hub on retail inventory forecasting by retailer, and for the SKU-level method underneath, SKU-level demand forecasting.

Where Drivepoint fits

Drivepoint is the AI finance platform for consumer brands, and retail launches like this one are what it was built for. It connects your Target sales and inventory data alongside Shopify, Amazon and your accounting system through 100+ integrations, turns store and DC movement into a SKU-level forecast inside your Excel model, and carries each PO through to the P&L, balance sheet and cash flow. When the buyer asks about expanding from 500 to 1,500 doors, AI scenario planning lets you answer in minutes, with the cash gap, deductions and promo pull-forward already in the numbers.