Furniture sets: matching every carton to one sellable item

A sofa set is a single item in the sales record, but in the warehouse it sits as several cartons. The record says "20 sets", the storekeeper counts 79 cartons on the racks, and nobody can say for sure whether a set is missing. In multi-part furniture a count gives the right answer only if the set, not the carton, is treated as the item. This article explains how to match cartons and how to find the missing piece.

The set item and its carton list

Every set needs a carton list on its item card. An illustrative case: the "Roma three-seater" has 4 cartons: frame (1/4), seat cushions (2/4), legs and fixing kit (3/4) and arm cushions (4/4). Each carton must show the set code, the fabric or colour code and its carton number. A carton without a label is what costs the most time in a count.

If the same model is made in two fabrics, these are two separate items. Even if "Roma, grey" and "Roma, beige" end up on the same rack, they must not be mixed in the record.

How the count runs

1. Cartons are counted by set code and carton number, which gives a separate total for each carton number.
2. The number of complete sets equals the smallest of those totals. In the example the count gives 20 for 1/4, 20 for 2/4, 19 for 3/4 and 20 for 4/4: 79 cartons in all, but only 19 complete sets.
3. The surplus cartons make up the "incomplete set" list: one set has no carton 3/4 (legs and fixing kit), while its other three cartons stand on their own.
4. The one-set difference between the 20 sets in the record and the 19 complete sets counted is tied to the missing carton and shown as a separate line in the variance table.

Taking the number of sets from a single carton number only (the main frame, for example) is a common mistake: even if the frame is complete, a set cannot be sold when other cartons are missing.

What matters is that the missing carton continues to be tracked after the count as a "part to be found". A set quietly removed from the record causes trouble again months later, when a customer orders it.

Where does the missing piece usually turn up?

The places that come up most often in practice:

• the cartons of a set opened in the showroom are stored somewhere else;
• a damaged carton is waiting for a replacement part from the manufacturer, so the set is on hold;
• a part was given to another order for service or exchange but no issue slip was written;
• the cartons of one set were put on different racks or in different parts of the building;
• cartons of the same model in different fabrics were mixed up.

Using a separate note field for each of these during the count saves hunting for them one by one afterwards.

How to hold it in the record

Sets ready for sale and parts waiting should be counted separately. Two methods are common: build the set from carton items with an "assembly" type of movement, or keep the carton list on the item card and calculate the number of sets from the scarcest carton. The second is simpler and can also be set up in Excel. Mark damaged cartons, display pieces and incomplete sets with their own statuses.

Preparing for count day

• Print a carton list sorted by model and fabric code, with the number of sets in the record and the expected number of cartons for each carton number on every line.
• Teach the counting team the codes, not the set names; "Roma grey" and "Roma beige" are told apart by code.
• Bring display pieces that have left the showroom back into the warehouse before the count, or list them separately.
• Collect damaged cartons in one corner and give them a separate status label.
• When the count ends, give the list of incomplete sets to the warehouse manager and the sales lead together.

The last point matters. As long as an incomplete set shows as "available" in the sales record, it can be promised to a customer, and the missing piece comes to light on the delivery day.

In short

In multi-part furniture the right stock figure is the number of complete sets, not of cartons. In furniture and showroom counts StockSystem matches every carton of a sofa set and collects incomplete sets, damaged goods and display pieces in separate lists.