A sales mix is the ratio of how much you sell of each product compared with the others, such as 5:3:2:1 for four products. If you order four products on the same day from the same supplier, you are already using one, even if nobody has ever called it that. You know one item moves faster than the others, so you order a little more of it. The trouble is that this knowledge tends to live in one person's head. When that person is off shift, the reorder changes. One week the top seller runs out by Thursday, and the next week a slow item sits on the shelf for a month.
A sales mix gives that knowledge a shape you can write down and check. The OpenStax managerial accounting textbook uses the idea for this kind of planning. OpenStax builds a four-product example around a basket of fruit: "For our particular baskets, we will use 5 apples, 3 oranges, 2 bananas, and 1 pear." It then states the result in one line: "This means that our product mix is 5:3:2:1, as shown in Figure 3.11."
Read the numbers as a pattern. For every five of the first product, you sell three of the second, two of the third, and one of the fourth. The ratio is not a count of what you should order. It is the shape of your demand. This post shows how shop managers and the staff who count stock can take a ratio like this one and turn it into reorder quantities that match how the shop really sells. The method is simple. The discipline is in keeping the numbers current.
Key takeaways
- Base the mix on units sold for each product, not on sales money.
- Set the total for the cycle first, using the lowest of your shelf, delivery and counting limits.
- Divide the total by the sum of the parts, then multiply each share by that product's number in the ratio.
- Round to whole units or packs, then check that the orders still add up to the total.
- Check the mix every cycle, and change one product at a time.
What a sales mix measures
A sales mix is about shares, not totals. Two shops can sell the same number of units in a week and still have very different mixes. One might sell mostly the cheap item; the other might sell mostly the premium one. The mix tells you which products deserve a bigger share of your next order, and which ones need less.
The textbook's multi-product analysis points out that companies "have limited resources, such as time and labor, and must decide which products to sell or produce and in what quantities, or which services to offer in order to be the most profitable." Your shop has the same problem in smaller form. You have limited shelf space, a limited cooler, a limited number of hours for counting and receiving, and a limited budget for each delivery. The mix helps you spend those limits where demand is.
Another useful point is that a mix can be stated as a simple assumption. OpenStax also gives a two-product case in which the sales mix of products A and B is 3:1. You do not need a formal model to do the same. Write the mix on your count sheet, date it, and treat it as the working assumption until your numbers say otherwise.
Why four products need one ratio
With a single product, a reorder is a subtraction. Count what is on the shelf, compare it with the level you want, and order the gap. With four products, you could do four subtractions and hope the total works out. Often it does not. Each product's gap is calculated on its own, so the four orders add up to a total that nobody chose on purpose. Some weeks the van is overloaded; other weeks the counting team spends the morning with boxes that do not fit anywhere.
A ratio fixes that by making the split a choice. You decide the total units for the cycle first. The ratio then decides how that total is divided across the four products. The total can change for good reasons, such as a holiday, a delivery limit, or a shelf that is being rebuilt. The split stays consistent, so each product's share moves in step with the others.
Read the ratio the right way
The ratio 5:3:2:1 has four parts. Add them together to get the sum of the parts. Each part is one share of the total. The first product gets 5 parts out of that sum, the second gets 3, the third gets 2, and the fourth gets 1. The first product therefore takes the largest share, a little under half of the total, and the fourth takes the smallest.
Three mistakes come up often when people first use a ratio.
The first is treating the numbers as quantities. Ordering 5, 3, 2 and 1 units would cover a very small slice of demand and leave the shelves almost empty. The numbers only tell you the proportions.
The second is matching the numbers to the wrong products. The ratio has no names in it. Write each product name next to its number on the sheet, and check the names against the list before you send an order.
The third is forgetting that a ratio is a pattern from the past. If one product starts selling faster, the old ratio is out of date. We come back to this below.
Turn the ratio into order quantities
Here is the method in five steps. It works for any ratio, with two products or ten.
- Set the total number of units for this cycle. Base it on what your shelves, cooler and delivery can hold, and on what your staff can receive and count in one visit.
- Add the parts of the ratio together to get the sum of the parts.
- Divide the total by the sum of the parts to get the size of one share.
- Multiply that share by each product's number in the ratio.
- Adjust for pack sizes and rounding, then check that the quantities still add up to the total.
| Product | Ratio part | Share of the total |
|---|---|---|
| First | 5 | Five shares |
| Second | 3 | Three shares |
| Third | 2 | Two shares |
| Fourth | 1 | One share |
| Total | Sum of the parts | All shares together, equal to the chosen total |
Real totals rarely divide evenly. When a share does not come out to a whole number of units, round each share to the nearest whole unit. The rounded shares may then add to a little less or a little more than the total. If they fall short, give the leftover units to the product with the largest share. If they exceed the total, take units back from the products whose rounding went up the most, so the total still matches. Whatever rule you use, write it on the sheet, so the next person counts the same way.
If your products come in fixed pack sizes, round to packs instead of single units. Suppose the second product is sold in cases. A computed order may fall between two case counts. Choose the option that keeps your total closest to the target, and do not let rounding quietly change the mix by a large amount. If a product always ends up with a large rounding error, its pack size may be too big for the mix.
Two products work the same way. In the 3:1 case above, the sum of the parts is four: three parts for the first product and one for the second. If you have chosen a total for the cycle, divide it by the sum of the parts to get the size of one share, then give the first product three shares and the second product one. You can use the same five steps with any number of products, and the same check: do the parts add back to the total?
Build the ratio from your own counts
The textbook ratio is an example. Your ratio has to come from your own sales. Start with the units sold of each product over a stretch of normal weeks. For a checklist of those figures, see units sold from a stock count. Leave out any week with an unusual event, such as a holiday rush or a clearance, or note it so you can adjust later. Count units rather than money. A high-priced item can bring in a large share of sales dollars while selling few units, and the reorder works in units.
For each product, divide its units sold by the total units sold for all four. That gives its share. For example, if one product sold about half of all units and the other three shared the rest, its share is roughly half. Your real numbers will not usually be that round. You do not need a clean ratio. Keep the shares as percentages, multiply by the total, and round as described above.
Be careful with stock-outs. If a product sold out on Tuesday, its sales count understates what customers wanted. The count does not show demand that never reached the till. Mark the days or hours when each product was out of stock. When a product was out for a large part of the period, its true share is likely higher than the count shows. Either exclude the out-of-stock days from the count, or raise that product's share a little and write down why.
Set the total before you split it
The total is the decision that shop managers often leave until last, and it should come first. Work it out from three limits: what the shelves and storage can hold, what the delivery can carry, and what the team can receive and count in one visit. Then use the lowest of those limits as the target. If storage has room for more than the count team can handle in one visit, the target is the smaller figure. For the checks to run before an order goes out, see shop replenishment checks.
Do not let the total drift from week to week without a reason. If every order is a little different, you lose the ability to compare cycles. Write the total on the sheet beside the ratio. When you change the total, note the reason. Over time, the notes show which limit is actually binding, which is useful when you plan space or deliveries.
Keep the count simple
The point of a sales mix is to make reordering faster and more consistent, not more complicated. A good count sheet has one row for each product and a handful of columns. Resist the urge to add many categories or weights. More detail is only useful when it changes an order. If two products always get the same share and the same order size, merge them into one line for planning.
Here is a layout that works on a clipboard or a shared spreadsheet, with one row for each product:
- Product: the name, written once in each row.
- Units sold last cycle: taken from the last cycle's count or the till report.
- Share: units sold divided by the column total.
- Units on hand: the physical count on the day you order.
- Target: the share times the total you chose.
- Order: target minus units on hand, before any pack rounding. If the order comes out negative, the product already has more than its target, so order nothing for it and note the surplus.
Check the mix every cycle
A ratio is only useful if you check it. At each cycle, compare the split you ordered with the sales you saw. If one product runs out before the next delivery every time, its share is too low. If another product still has half its stock at the next count, its share is probably too high. Change one product at a time, and by a modest amount, so you can see what the change does.
Watch for seasonal shifts. Demand for some products rises and falls over the year, and a mix that is right in one month can be wrong in the next. Keep a log of each cycle with the date, the total, the shares, and any notes about events. After a few cycles, you can see which changes repeat and plan for them. For a longer planning window, see quarterly units to order.
Do not chase perfect accuracy. The goal is a mix that is close enough to keep shelves stocked, with fewer surprises and less time spent recounting. A simple ratio that is checked every cycle usually beats a complicated model that nobody updates. That is the practical reason the method above rests on a few steps and one check.
Consistency in the count matters as much as the math. Count at the same point in the day, use the same units, and have the same people record the same products the same way. A mix built from inconsistent counts will look precise and still mislead you.
Common mistakes to avoid
Four mistakes show up most often:
- Using sales money instead of units. A high-priced product can look bigger than it really is.
- Keeping an old mix after demand has changed. Check it every cycle.
- Treating the ratio as a quantity. Always convert it to a total first.
- Letting rounding hide a large error. Compare the rounded total against the target.
Put it into practice this week
Start small. Pick the four products you order most. Count the units sold for each over a normal stretch of weeks, and calculate the shares. Set a total that your storage and delivery can hold. Work out the order using the five steps, and write down the result. Then compare it with what you actually need at the next count.
Keep the first cycle simple. Do not try to fix every product at once. The aim of the first few orders is to learn how your demand behaves and to make the split consistent. Once your staff can run the sheet without help, the ratio becomes a routine instead of a judgment call made in a hurry.
A sales mix will not solve every reorder problem. It will not tell you when a supplier is late, or when a product has gone out of fashion. What it does give you is a clear, shared answer to a question that otherwise gets answered differently every week: how much of each product should we order when the total is set? For four products, that answer can be as simple as 5:3:2:1, as long as you keep checking it against the shelves.
Your next step today: open your till report or count sheet, list the units sold of each of your four products over one normal stretch of weeks, and calculate each product's share.
Related guides: Tax-included prices: 3 steps to back out sales tax · Card and cash sales: 3 amount limits for your till · Check 7 items before charging sales tax in your shop.
Frequently asked questions
Is a sales mix the same as total sales?
No. A sales mix is about shares, not totals, so two shops can sell the same number of units and still have very different mixes.
Should the mix be built from units or sales money?
Build it from units, because the reorder works in units and a high-priced item can look bigger in sales dollars than it really is.
Do I need a formal model to use a sales mix?
No. Write the mix on your count sheet, date it, and check it every cycle, because a simple ratio that is checked usually beats a complicated model that nobody updates.