Quick answer
To forecast inventory for Ulta Beauty, multiply units per door per week by active doors (roughly 1,400 chain-wide), add a separate ulta.com line, and size the opening order as door target times doors plus dotcom stock, DC cover and testers. Build a PO three to four weeks ahead of any 21 Days of Beauty steal, book the brand-funded discount as trade spend, and run a low-velocity case to cash.
Forecasting inventory for Ulta Beauty is a scale problem wrapped around an events problem. Ulta runs roughly 1,400 stores across the US, all of them carrying mass and prestige beauty under one roof, with a loyalty program that drives a large share of sales and a promotional calendar that can move two weeks of volume in a single day. Your forecast needs the door-count math of a mass retailer and the launch-and-event sensitivity of a prestige one. Below: how Ulta orders, how to build velocity across a 1,000-plus door base, what the event calendar does to inventory and trade cost, and a fictional haircare example carried to cash.
How Ulta orders from a brand
Brands ship to Ulta's distribution centers, and Ulta replenishes stores and its online fulfillment from there. Store replenishment works on a per-door target with reorders triggered as sales draw down on-hand, so POs to you reflect DC depletion across all stores plus ulta.com, typically on a weekly cadence. Compared with grocery, POs are smoother; compared with Sephora, the door count is far larger, so the aggregate numbers get big quickly.
Features of the Ulta model that matter for forecasting:
- Mass and prestige in one box. Ulta's shopper trades up and down in the same visit, so a mid-priced item competes with both tiers. Price point relative to the adjacent shelf is a stronger velocity driver here than at a pure prestige retailer.
- Loyalty members do most of the buying. Ultamate Rewards members account for the large majority of Ulta's sales, and points-based promotions (bonus points, member-only pricing) are a constant. Expect velocity to move with the loyalty calendar even when your item is not on a formal promotion.
- Shop-in-shops at Target. Ulta Beauty at Target operates hundreds of in-store shops with a curated assortment. If your brand is included, treat it as a separate door set with its own velocity and its own planogram timing.
- Planogram resets and discontinuations. Ulta resets categories on a schedule and prunes assortments regularly. Discontinued items are typically marked down or returned to the vendor, often with the brand funding some of the markdown. Model an exit scenario for any SKU that is not a hero.
Testers are expected at every door and are supplied by the brand. Payment terms are negotiated and typically land in the 30 to 60 day range, with deductions for damages, returns, chargebacks and co-op netted against remittances; confirm yours before building the cash view.
Velocity across a large door base
The formula is standard, but the door count makes small velocity errors expensive:
Weekly Ulta demand = (units per door per week x active doors) + ulta.com units per week
Opening order = door target x doors + dotcom opening stock + DC cover + testers (1 per door per SKU)
At 1,200 doors, an error of 0.5 units per door per week is 600 units a week, or more than 30,000 units a year per SKU. Build the forecast with a velocity range, not a point estimate, and run the low case through to inventory and cash. After launch, Ulta provides sell-through reporting that lets you replace assumptions with store-level actuals within a few weeks; the first thing to check is the spread between your best and worst doors, which tells you whether a chain-wide number is even the right unit of analysis.
The event calendar and what it costs
Ulta's calendar is built around named events: 21 Days of Beauty in spring and fall (daily "Beauty Steals" at deep discounts on selected items), the Gorgeous Hair Event, the Love Your Skin Event, Fall Haul, and holiday. Being chosen as a Beauty Steal is both the best and the most dangerous thing that can happen to a mid-sized brand's inventory. A single-day steal at 50% off can sell a week or more of normal volume in one day, the DC has to be stocked for it in advance, and the discount is typically funded in whole or in part by the brand. Three modeling rules:
- Build the pre-event PO into the forecast three to four weeks ahead, sized to the expected steal volume plus normal replenishment.
- Book the brand-funded portion of the discount as trade spend on the units sold during the event, so net revenue for that week is correct.
- Expect a post-event dip, since loyalty members who stocked up at half price will not repurchase at full price for a while.
The Ulta forecasting template has the event build, lift and funding as inputs, and the trade spend gross-to-net template handles the accounting.
A worked example: Sunday Mane at Ulta
Take a fictional haircare brand we will call Sunday Mane, launching a shampoo and conditioner pair in 1,200 Ulta doors plus ulta.com. Assumptions per SKU: retail $28, wholesale $14, landed cost $4.20, door target of 6 units, steady velocity of 2 units per door per week, dotcom at 30% of store volume, 2 weeks of DC cover, 1 tester per door per SKU at $3, filler lead time 10 weeks, terms 45 days, and a fall 21 Days of Beauty steal on the shampoo at 50% off with the brand funding half the discount ($7 a unit) and an expected 20,000 units sold that day.
- Opening order (both SKUs): 6 x 1,200 x 2 = 14,400 store units, plus two weeks of dotcom at 30% (0.3 x 4,800 x 2 = 2,880), plus two weeks of DC cover (2 x 6,240 = 12,480), about 29,800 units, roughly $416,600 gross.
- Testers: 2,400 units at $3, $7,200 of non-revenue inventory.
- Steady weekly demand (both SKUs): 2 x 1,200 x 2 = 4,800 store units plus 1,440 dotcom = 6,240 units, $87,360 gross a week.
- Production for launch plus 10 weeks: 29,800 + 62,400 = 92,200 units at $4.20, $387,240, plus testers, roughly $394,000 paid to the filler before the first Ulta remittance.
- Beauty Steal: 20,000 shampoo units in one day is more than eight weeks of that SKU's normal store volume. The pre-event PO adds roughly 20,000 units ($280,000 gross), production for it costs $84,000, and the brand-funded discount is 20,000 x $7 = $140,000 of trade spend. Net revenue on those units is $7 each, not $14, so the steal week's contribution is roughly half what the gross line suggests, before the post-event dip.
- Cash: about $394,000 out at week 0, first remittance around week 16 (ship week 10 plus 45 days), with the steal adding another $84,000 of production cash in the quarter before the event and the $140,000 of trade spend appearing as a deduction against the remittance that follows it.
Run the low-velocity case (1.5 units per door per week) through the same model and the opening order is unchanged but replenishment falls by a quarter, which is how brands end up with a DC full of inventory and a buyer talking about resets. For PO-to-cash mechanics see purchase order forecasting, and for how Ulta compares with Sephora and other accounts see the retail inventory forecasting hub. More beauty models live in the beauty brands template library.
Where Drivepoint fits
Drivepoint is the AI finance platform for consumer brands, built for the moment a 1,200-door account and a one-day event land in the same quarter. It connects Ulta sell-through and PO data alongside Shopify, Amazon and your accounting system through 100+ integrations, forecasts by SKU, door set and dotcom inside your Excel model, and carries every PO, tester and trade dollar through to the P&L, balance sheet and cash flow. AI scenario planning lets you test the Beauty Steal, the low-velocity case and the Target shop-in-shop expansion in minutes, not days.