WSSI is a good tool in using and keeping tabs on intake, stock and sales. The above table is a simple view of a WSSI. As because this is managed classically at style-color level (calculation at order quality level), the items offered for sale are 500 items. This is a very large quantity, considering the calculation is done with a spreadsheet and manually. It is advisable, keeping in mind the calculation to have been done manually in a spreadsheet, not to delve too much into details. It should not be that the value addition is stopped from becoming a mere administrative exercise.
Each line from the range plan, starting with ‘average weekly rate of sale’ is taken in units.
The seasonality factor should be applied that will help in calculating a more precise flow of stock. After that the WSSI forward should be rolled for a full season. The season typically denotes 26 weeks. The rolling would be longer if the sales are on the continuity lines.
The figures show that a simple WSSI should be developed. In case there is no weekly intake of stocks for purchase of larger upfront quantities, a WSSI can highlight the time when it will be out of stock for an item. The assumption will be made on sales track to forecasting.
In the column highlighted, the opening stock or the initial intake of the WSSI would have been shown. It consists of 40 units that were insufficient in meeting the sales forecast. It would be an alert in either increasing the initial quantity of order or bringing in replenishment order at the third week. This is a very simple plan, where the data may be used from a range plan in creating WSSI.