SLS-298 · Lesson 5 of 12 · 27 min

Planning the assortment

▶ Video coming soon A video version of this lesson is on the way.

Stage 5 is the biggest buying decision of the season, and in a real store it happens months before the first customer walks in. The decision brief, dated Monday, November 30, 2026 in the simulation timeline, contains the open-to-buy plan Bev presented to the owners, the fall 2026 sell-through report for sectionals, supplier lead times, and the category sales for spring 2026. Your task is an assortment and open-to-buy plan for spring: how much to buy, in which categories, at which price lines, in which colors, and how much to hold back.

Merchandise planning in SLS-253 gave you the tools: markup, open-to-buy, sell-through, stock turn and assortment breadth and depth. This stage asks you to use them together, under the constraint that you cannot see the future. You know what sold last fall and last spring; you do not know what will sell in May.

How much to buy: the open-to-buy

The open-to-buy for a season is the amount of merchandise, at retail, that can be bought so that the department ends the season with its planned inventory. The formula is the one from SLS-253: planned sales plus planned reductions plus planned ending inventory, minus the inventory you start with.

Worked problem

The season's open-to-buy

The spring plan has sales of 1,850,000 dollars, markdowns of 148,000, employee discounts of 0.5 in 100 of sales and shrink of 0.8 in 100 of sales. Inventory at retail is planned at 1,560,000 dollars on February 1 and 1,450,000 dollars at the end of July. The initial markup is 52 in 100 of retail. What is the open-to-buy at retail and at cost?

Show solution
  1. Planned reductions:
  2. \[148{,}000 + 1{,}850{,}000 \times 0.005 + 1{,}850{,}000 \times 0.008 = 148{,}000 + 9{,}250 + 14{,}800 = 172{,}050\]
  3. Open-to-buy at retail:
  4. \[1{,}850{,}000 + 172{,}050 + 1{,}450{,}000 - 1{,}560{,}000 = 1{,}912{,}050\]
  5. At cost, with a 52 in 100 initial markup:
  6. \[1{,}912{,}050 \times (1 - 0.52) = 917{,}784\]

Answer: The department can buy 1,912,050 dollars of merchandise at retail, which is 917,784 dollars at cost, for the season. Reductions are part of the formula because merchandise that is marked down, discounted or lost still has to be replaced.

The plan does not spend all of that at once. Following store policy, 70 in 100 is committed in the initial orders and 30 in 100 is kept in reserve for reorders of what sells, special-order stock and corrections later in the season.

Worked problem

Committed and reserve

Split the open-to-buy into committed and reserve amounts at retail.

Show solution
  1. Committed:
  2. \[1{,}912{,}050 \times 0.70 = 1{,}338{,}435\]
  3. Reserve:
  4. \[1{,}912{,}050 \times 0.30 = 573{,}615\]

Answer: About 1,338,000 dollars at retail is ordered now and about 574,000 is held back. The reserve is the department's answer to uncertainty: it lets Aiden buy more of what customers want once the season shows it.

Monthly flow

The season open-to-buy is a total; suppliers need monthly orders. The plan sets an inventory figure for the start of each month, and the open-to-buy for a month is calculated the same way as for the season.

Spring 2027 monthly plan (dollars at retail, from SLS-253)
MonthPlanned salesStart-of-month inventory at retailEnd-of-month inventory at retail
February260,0001,560,0001,600,000
March300,0001,600,0001,650,000
April330,0001,650,0001,680,000
May340,0001,680,0001,600,000
June320,0001,600,0001,500,000
July300,0001,500,0001,450,000

Worked problem

February's open-to-buy

Planned reductions for each month are about 9.3 in 100 of that month's sales. What is February's open-to-buy at retail?

Show solution
  1. February reductions:
  2. \[260{,}000 \times 0.093 = 24{,}180\]
  3. February open-to-buy:
  4. \[260{,}000 + 24{,}180 + 1{,}600{,}000 - 1{,}560{,}000 = 324{,}180\]

Answer: February needs about 324,180 dollars of merchandise at retail to arrive during the month. Inventory is planned to rise in February, March and April and fall in May, June and July, so the department is buying ahead of its busiest month. With upholstery lead times of six to eight weeks, March and April receipts have to be ordered in January and February.

A line chart of planned start-of-month inventory at retail from February to the end of July 2027: 1.56, 1.60, 1.65, 1.68, 1.60, 1.50 and 1.45 million dollars. Bars below show planned monthly sales of 260, 300, 330, 340, 320 and 300 thousand dollars. A note marks that inventory peaks in April, before the May sales peak.
Planned inventory and sales by month: stock builds before the May peak and runs down into summer.

What to buy: categories and price lines

The category plan shares the sales plan among the department's main categories, using spring 2026 as the starting point and adjusting for the new sofa price line.

Category plan for spring 2027
CategorySpring 2026 share (in 100)Spring 2027 plan (dollars)Share (in 100)Notes
Sofas36703,00038New 999 line
Sectionals35629,00034Color mix changed after fall
Recliners and lift chairs17296,00016Steady
Accent chairs and ottomans9166,5009Mustard chair lesson applied
Fabric protection and other services355,5003Sold with furniture
Total1001,850,000100

Sofas carry the change. SLS-253 set three price lines for sofas: 999, 1,799 and 2,799 dollars, a good, better and best ladder with clear steps in quality: fabric grade, cushion construction and frame warranty. The 999 line is new. It is aimed at first-home buyers who used to leave the store for online sellers when the cheapest sofa on the floor was 1,499.

Worked problem

The sofa price-line plan

Aiden planned 120 sofas at 999 dollars, 210 at 1,799 and 60 at 2,799, with the rest of the sofa plan coming from custom orders. What do the three lines produce, and how much is left for custom orders?

Show solution
  1. 999 line:
  2. \[120 \times 999 = 119{,}880\]
  3. 1,799 line:
  4. \[210 \times 1{,}799 = 377{,}790\]
  5. 2,799 line:
  6. \[60 \times 2{,}799 = 167{,}940\]
  7. Total of the three lines:
  8. \[119{,}880 + 377{,}790 + 167{,}940 = 665{,}610\]
  9. Left for custom sofas:
  10. \[703{,}000 - 665{,}610 = 37{,}390\]

Answer: The three lines produce 665,610 dollars and custom sofa orders need to bring in about 37,390 dollars. Most of the units are in the middle line, which is where most customers buy once they can see a cheaper and a better option on either side.

The 999 line has a lower margin: about 40 in 100 instead of the department's 46, because the supplier's cost is a larger share of a low price. Bev asked whether it was worth it.

Worked problem

What does the 999 line cost in margin?

If the 119,880 dollars of 999-line sales earn 40 in 100 instead of 46, how much margin is given up compared with selling the same dollars at the department rate? How many extra 999 sofas would cover it?

Show solution
  1. Margin given up:
  2. \[119{,}880 \times (0.46 - 0.40) \approx 7{,}193 \text{ dollars}\]
  3. Margin on one 999 sofa:
  4. \[999 \times 0.40 \approx 400 \text{ dollars}\]
  5. Sofas to cover the gap:
  6. \[\frac{7{,}193}{400} \approx 18\]

Answer: The lower margin costs about 7,200 dollars if the 999 sofas only replace sales the department would have made anyway. If at least 18 of the 120 are sales to customers who would otherwise have left, the line pays for itself, and every extra new customer is a chance to sell a chair, a protection plan or, years later, a sectional. Aiden recorded the 18-sofa test in his plan so that the midseason review could check it.

How many of each: the sectional color mix

The fall 2026 report from SLS-253 is the best evidence for the spring sectional buy. Of 64 sectionals received in August, the department had sold, after eight weeks, 18 of 24 gray, 13 of 18 oatmeal, 4 of 12 navy and 2 of 10 forest green.

Fall 2026 sectional sell-through (from SLS-253)
ColorReceivedSold in eight weeksSell-through (in 100)Decision for spring
Gray (style A)241875Buy deepest
Oatmeal (style B)181372Buy deep
Navy (style A)12433Keep a small range, main-aisle display
Forest green (style C)10220Drop

Worked problem

Allocating the spring sectional buy

The initial spring buy is 60 sectionals. Six are a terracotta test color. Allocate the other 54 to gray, oatmeal and navy in proportion to the units each sold in the fall, dropping forest green.

Show solution
  1. Units sold in the fall in the three colors kept:
  2. \[18 + 13 + 4 = 35\]
  3. Gray:
  4. \[54 \times \frac{18}{35} \approx 27.8\]
  5. Oatmeal:
  6. \[54 \times \frac{13}{35} \approx 20.1\]
  7. Navy:
  8. \[54 \times \frac{4}{35} \approx 6.2\]

Answer: The proportional split is about 28 gray, 20 oatmeal and 6 navy. Aiden rounded gray down to 27 and navy up to 7, because the navy display on the main aisle in SLS-253 was helping and a single extra piece let him keep one on the floor and six in stock. The buy is 27 gray, 20 oatmeal, 7 navy and 6 terracotta, matching the plan presented to the owners.

Two bar charts. Left: fall 2026 sell-through by sectional color, gray 75, oatmeal 72, navy 33, forest green 20 in 100. Right: spring 2027 initial buy, gray 27, oatmeal 20, navy 7, terracotta test 6 units, forest green 0.
The fall sell-through and the spring sectional buy that follows from it.

The terracotta test follows the advice in SLS-253 on testing new colors: buy a small number, give them a good floor position, and set a clear rule in advance. Aiden's rule was that terracotta would be reordered if at least 4 of the 6 sold by the end of April, and cleared through the markdown budget otherwise.

The 60 sectionals are only the stock buy. Many sectional customers choose their own fabric and configuration from swatches, and those special orders are bought one at a time when the customer has paid a deposit, so they do not need open-to-buy in advance in the same way. Spring 2026 special orders made up a little over half of sectional sales. Aiden kept that assumption, which is why the stock buy is small compared with the 629,000-dollar category plan, and he noted that a fall in special orders would show up first as a gap between sectional sales and the stock that had sold.

Breadth, depth and what not to buy

A department with 9,000 square feet cannot show everything. The assortment plan therefore says how many different styles to carry (breadth) and how many of each to stock (depth). Aiden kept breadth roughly the same as last spring, with 34 sofa and sectional styles on the floor, but made it deeper in the best sellers and thinner in the slow ones. He dropped four slow sofa styles to make room for the 999 line and the terracotta test.

He also applied the lesson of the mustard accent chairs in SLS-253. Thirty were bought in spring 2026 at a cost of 288 dollars and a ticket of 600, and they had to be cleared at 450, 360 and 300. For spring 2027 he bought accent chairs in smaller first orders, 8 to 12 of each color, with reorders funded from the reserve once sell-through passed 50 in 100 in four weeks.

Template: the assortment and open-to-buy plan

Assortment and open-to-buy template
SectionWhat to include
Open-to-buySeason total at retail and cost, committed and reserve, with working
Monthly flowReceipts needed by month and order dates given lead times
Category planSales by category with reasons for changes
Price linesLines, units and the test for any new line
Color and size mixAllocation from sell-through evidence
Rules for the reserveWhen reorders, tests and clearances will happen

Model answer and Bev's scoring

Bev scored Aiden's plan 18 out of 20. The open-to-buy, the color allocation and the reserve rules were complete and correct. She took one point from the monthly flow because the order dates did not allow for the Chinese New Year factory closure that delays some imported frames in February, and one from the price lines because the plan did not say how the 999 sofas would be displayed so they did not pull customers down from the 1,799 line. "A good, better, best ladder works when customers see all three together," she wrote.

Rubric for the assortment and open-to-buy plan, with Aiden's scores (total 18)
CriterionExcellent (4)Developing (2)Aiden
Open-to-buy arithmeticCorrect season and monthly figures, working shownErrors in reductions or inventory4
Use of evidenceEvery buying decision tied to sell-through or sales dataDecisions by preference4
Price linesClear ladder with a test for the new lineLines without reasoning3
Flow and lead timesOrders timed to arrive before demandLate or unrealistic orders3
Reserve rulesClear rules for reorders, tests and clearanceNo rules4

Reflection

What would you do with the reserve if gray sectionals sold out by mid-March? What evidence would make you drop the 999 sofa line at the end of the season?

Common mistakes

  • MistakeLeaving reductions out of the open-to-buy.

    InsteadAdd planned markdowns, discounts and shrink, because lost or reduced stock must be replaced.

  • MistakeCommitting the whole open-to-buy in the first orders.

    InsteadHold a reserve for reorders and corrections.

  • MistakeOrdering for May in May.

    InsteadAllow for lead times; stock must arrive before the peak.

  • MistakeBuying colors by personal taste.

    InsteadAllocate from sell-through and set test rules in advance.

  • MistakeAdding a cheaper price line without checking the margin.

    InsteadWork out the margin given up and how many new customers it needs.

Summary and key terms

  • The season open-to-buy is planned sales plus reductions plus ending inventory minus starting inventory: 1,912,050 dollars at retail, 917,784 at cost.
  • Seventy in 100 is committed and 30 in 100 held in reserve.
  • Inventory builds before the May peak, so March and April receipts are ordered in January and February.
  • Sofa price lines of 999, 1,799 and 2,799 form a good, better, best ladder; the 999 line pays for itself if about 18 of its sales are new.
  • The 54 core sectionals are allocated by fall units sold: 27 gray, 20 oatmeal, 7 navy, plus 6 terracotta to test.
Open-to-buy
The amount of merchandise that can be bought for a period while meeting the planned ending inventory.
Committed open-to-buy
The part of the open-to-buy placed in initial orders.
Reserve
The part of the open-to-buy held back for reorders and changes.
Price line
A set price point at which a group of products is sold.
Breadth
The number of different styles or items carried.
Depth
The number of units carried of each style or item.

Practice problems

Work each problem on paper first, then reveal the answer to check.

  1. May has planned sales of 340,000, reductions of 9.3 in 100 of sales, a start inventory of 1,680,000 and an end inventory of 1,600,000. What is May's open-to-buy at retail?

    Show answer

    Reductions 31,620; 340,000 + 31,620 + 1,600,000 − 1,680,000 = 291,620 dollars.

  2. If the reserve is 573,615 dollars at retail and the initial markup is 52 in 100, what is it at cost?

    Show answer

    573,615 × 0.48 ≈ 275,335 dollars.

  3. Gray sold 18 of 24 in the fall. What was its sell-through, and why is that a reason to buy deeper?

    Show answer

    75 in 100; it sold quickly, so more stock is likely to sell without markdowns.

Lesson quiz · 5 questions

Score 60% or more to complete this lesson.

Take the quiz