Wiki source code of ASORTIMENTO VALDYMO TAISYKLĖS

Hide last authors
Administrator 15.1 1 {{toc/}}
2
Administrator 100.1 3 == **Assortment management** ==
Administrator 1.1 4
Administrator 100.1 5 Includes state of DTO / DTA / ND / CD / CD2 / NM / NA / ALT setting, items movement describing marks A, C, OUT, NEW setting and merging of alternative items.
Administrator 1.1 6
Administrator 100.1 7 == **Assortment determinable/changeable** ==
Administrator 1.1 8
Administrator 100.1 9 Assortment is changeable:
Administrator 1.1 10
Administrator 100.1 11 ~1. By starting to manage storage place by DBM.
Administrator 1.1 12
Administrator 100.1 13 2. According system suggestions:
Administrator 1.1 14
Administrator 100.1 15 1) 602-603 reports „NON movers reports“: DTA -> DTO (OUT) or ALT.
Administrator 1.1 16
Administrator 100.1 17 2) 605 report „DTO transfer DTA“: DTO -> DTA.
Administrator 1.1 18
Administrator 100.1 19 3) 630i report „Assortment evaluation/rating“ DTA -> DTO in all sales network or DTO -> in separate sales points.
Administrator 1.1 20
Administrator 100.1 21 (look: //STOCK-M reports description//).
Administrator 1.1 22
Administrator 100.1 23 3. By management decision:
Administrator 1.1 24
Administrator 100.1 25 1) Entered new item/product into the system (look: [[Item SKU settings>>doc:User_Manual.SKU_Settings.WebHome]]);
Administrator 1.1 26
Administrator 100.1 27 2) An item/product removed from the system OUT;
Administrator 1.1 28
Administrator 100.1 29 3) Other reasons.
Administrator 1.1 30
Administrator 100.1 31 == **Assortment control module (control of CAT groups)** ==
Administrator 24.1 32
Administrator 32.1 33
Administrator 100.1 34 Assortment control module is for controlling assortment width (number of items having DTA status)
Administrator 24.1 35
Administrator 100.1 36 1. **Creating a new CAT goup**
Administrator 24.1 37
Administrator 100.1 38 CAT group can be created: StockM -> „OTHERS“ -> „CAT GROUPS“ -> „New“
Administrator 24.1 39
Administrator 100.1 40 [[image:asortimentas1.png]]
Administrator 24.1 41
Administrator 100.1 42 Specify parameters when creating the group:
Administrator 32.1 43
Administrator 100.1 44 * Name – name of the assortment group (mandatory parameter);
45 * Min SKU per WH/Shop – minimum number of SKU in group;
46 * Max SKU per WH/Shop – maximum number of SKU in group;
47 * Max Inventory – the maximum amount of inventory (in cash) of all SKU of that CAT group;
48 * Trial days – is the period to trade in the item without doing assessment/decision, i.e. trial period shows after how many days the program will propose to decide whether to continue to maintain the product on DTA status in the group or to transfer it to DTO (mandatory parameter). Trial period is always calculated from the last change of SKU status or rejection of the proposal. The change of status is recorded only according to a schedule at the end of each day. Rejection of a proposal is recorded by rejecting a proposal to change the status;
49 * Manager – responsible manager (mandatory parameter).
50 * Min SKU per WH/Shop, Max SKU per WH/Shop, Max inventory – these fields can be filled either all or only those that are necessary for the user.
Administrator 32.1 51
Administrator 100.1 52 [[image:asortimentas2.PNG]]
Administrator 32.1 53
Administrator 100.1 54 **2. Assigning the item to a CAT group**
Administrator 32.1 55
Administrator 100.1 56 You can assign an item to a group in the Inventory window: "Assortment"-> "inventory". The same item code can belong to different CAT groups in different warehouses. However, in one warehouse item can only belong to one group.
Administrator 32.1 57
Administrator 100.1 58 The CAT Group column is visible in the Inventory window and on the item card.
Administrator 32.1 59
Administrator 100.1 60 The group can include items of various statuses, but only DTA items are actively involved in the group (the number of them is tracked according to the specified parameters). Items in the group having other statuses are not tracked.
Administrator 32.1 61
Administrator 100.1 62 Only after the specified trial period, the newly added items in the group begin to participate in the assessment/decision if to continue them as DTA items in the group further on.
Administrator 32.1 63
Administrator 100.1 64 **3. Product removal from the assortment**
Administrator 32.1 65
Administrator 100.1 66 For DTA items, the ROI rating is counted during the data exchange. The column is visible in the Inventory window. The items proposed to be removed from the assortment are selected based on this indicator and on specified CAT group parameters. The items are selected according to the lowest ROI rating indicator.
Administrator 32.1 67
Administrator 100.1 68 The window of product removal from the assortment is accessed via the dashboard taskbar or via the menu item: StockM-> Assortment-> "DTA-> DTO".
Administrator 32.1 69
Administrator 100.1 70 [[image:asortimentas3.PNG]]
Administrator 32.1 71
Administrator 100.1 72 It is proposed to change the status from DTA to DTO in the window or to postpone this offer:
Administrator 32.1 73
Administrator 100.1 74 • Press "DTA-> DTO" to change the status;
Administrator 32.1 75
Administrator 100.1 76 • Click "Postpone" if you don't change status now. The proposal to change the status will be postponed to the number of days specified in the CAT group description as the trial period (the trial period counts from the current day).
Administrator 32.1 77
Administrator 100.1 78 The window of the CAT group in the warehouse can be accessed by pressing the icon [[image:image-20200304165856-1.png]]. Here are all the items belonging to one group of the selected warehouse.
Administrator 32.1 79
Administrator 100.1 80 [[image:asortimentas4.PNG]]
Administrator 32.1 81
Administrator 100.1 82 == **Items (SKU) states** ==
Administrator 32.1 83
Administrator 100.1 84 ~1. Concepts:
Administrator 32.1 85
Administrator 100.1 86 **//DTA//** – item, which must always be in storage place and regulary supplement regional storage/branch (shop) with it. //!!! In reports: Lost sales are calculated when there is no DTA item balance in the storage place. Overstock - is the quantity of an item above the specified item buffer.//
Administrator 32.1 87
Administrator 100.1 88 //**DTO**// – item, which is carried according to special order, such item is in assortment, however the balance of it is not supported in company‘s storage space//!!! If DTO item placed into regular order by reservation, quantity of ordered item is rounded by pack (USQ) to a larger size. In reports: Lost sales are not calculated, because DTO item balance shouldn't be in storage place. Overstock - is the total quantity of DTO goods in the storage place.//
Administrator 32.1 89
Administrator 100.1 90 //**NM **//– item, which is not managed by system (for example, inventory in the shop, stand, service and so on). The balance of this item and sales are included into whole company inventory and sales//.//
Administrator 32.1 91
Administrator 100.1 92 **//NA//** – not active item, which is not in assortment, data is not updating for this item. The system automatically assigns NA state to items, which are taken out from assortment (OUT mover), when the balance becomes 0 in the storage place. NA goods are not included into reports.
Administrator 32.1 93
Administrator 100.1 94 **//ND// –** new item, i.e. such item, which was updated first time in StockM, „recovered“ from NA state, because item got „movement“, was disassembled „group of Alternatives“ or „Alternative item“ removed from „group of Alternatives“.
Administrator 51.1 95
Administrator 100.1 96 //**ALT**// – alternative item, which is not managed by system, but all item data, received during data exchange are recorded for the main item in the group. //Such items are not included into orders.//
Administrator 51.1 97
Administrator 100.1 98 //**CD**// – an item managed by Cross docking principle, only regional ordered items are ordered from the supplier. The state is assigned only for item in the Central Warehouse (in all other related warehouses states are in the same condition as specified above). More: Cross Docking Function.
Administrator 51.1 99
Administrator 100.1 100 //**CD2**// – an item managed by Cross docking principle, necessary quantity of items to supplement the regions are ordered from the supplier. The state is assigned only for item in the Central Warehouse (in all other related warehouses states are in the same condition as specified above). More: Cross Docking Function.
Administrator 51.1 101
Administrator 100.1 102 2. Connection: DTA and DTO in the system, when items are delivered to the further chain
Administrator 51.1 103
Administrator 100.1 104 (% style="height:179px; width:958px" %)
105 |// //|**//Central warehouse//**|**//Regional warehouses//**
106 |//Items, sold regularly//|//DTA//|//DTA//
107 |//Expensive, slow-selling items//|//DTA//|(((
108 //DTO,//
Administrator 51.1 109
Administrator 100.1 110 //In different storage places DTA (BUFF=1)//
111 )))
112 |//Items, taken out from assortment (OUT)//|//DTO//|//DTA//
113 |//Items, which buyer agree to wait for (DTA sales are not bigger)//|//DTO//|//DTO//
Administrator 32.1 114
Administrator 100.1 115 1) !!! For DTA items only, the system automatically generates regular orders (**exception:** when a pre-order is made for DTO item in the customer's accounting program (which is bigger than the item balance in storage place), then the DTO items are included in the regular system-generated order. **P.S. this condition must be agreed at the start of the system start**)//.//
Administrator 1.1 116
Administrator 100.1 117 **// //**2)**// !!! For DTO items, the employee forms a special order (see: [[Special Order Formation>>doc:User_Manual.Orders.WebHome||anchor="HSpecialordersformation"]])//**//.//
Administrator 1.1 118
Administrator 100.1 119 3) !!! CD and CD2 orders are formed regularly according to the described rules (see: Cross Docking function).
Administrator 1.1 120
Administrator 100.1 121 3. Assignment of status to the item in STOCK-M:
Administrator 1.1 122
Administrator 100.1 123 STOCK-M -> „Assortment“ -> „Inventory“ -> Filter: specific item, supplier, storage place and etc. -> in the column state, select the required state from the list -> save changes.
Administrator 1.1 124
Administrator 100.1 125 * !!! For primary window opening customized filter *DT, if you need to filter out other state items – specify it in the filter.
Administrator 1.1 126
Administrator 100.1 127 * !!! It is possible to change the status for big number of items (mark the required lines → click [[image:EditSelected.png]] select the required state -> save changes). Selected state will be assigned for all marked items.
Administrator 1.1 128
Administrator 100.1 129 You can also change states in New items window. New Items window is reached via the taskbar or menu item "Buffers" → "New Items"
Administrator 1.1 130
Administrator 100.1 131 //If you want to enter an item to the assortment, which was taken from assortment before, you need to do these actions: STOCK-M → "Assortment" → "Inventory" → Filter: specific item → change product status from NA to DTO / DTA in the window that opens (remember to take off the check mark from the OUT mark in the "SKU List" window).//
Administrator 1.1 132
Administrator 100.1 133 == **Weekly fluctuations management** ==
Administrator 1.1 134
Administrator 100.1 135 **Peak coefficients for DTA goods/items.**
Administrator 1.1 136
137
138
Administrator 100.1 139 If DTA item sales have weekly fluctuations (eg. sales increase on weekends), there is an option to specify Peak coefficients for each day of the week.
Administrator 1.1 140
Administrator 100.1 141 By default, this coefficient is equal to 1. Peak coefficients can be entered manually or uploaded via Table L11.
Administrator 1.1 142
Administrator 100.1 143 Peak coefficients are entered to that day, when items have to arrive. If sales increase on weekends and items arrive on Fridays and there are no deliveries in weekends, then the Peak coefficient is entered to Friday (for other days left 1).
Administrator 1.1 144
Administrator 100.1 145 Peak coefficient can only be applied if the supply is > = 2 times a week.
Administrator 1.1 146
Administrator 100.1 147 When forming the order, Peak coefficient is selected based on the day of the week, when the order will arrive and the buffer is multiplied with coefficient (more items are ordered in peak days).
Administrator 1.1 148
Administrator 100.1 149 == **Items (SKU) marks A, C, OUT, NEW** ==
Administrator 1.1 150
Administrator 100.1 151 Concepts:
Administrator 1.1 152
Administrator 100.1 153 //**SYSTEMATIC PARAMETERS**//, set for a single item throughout the system (all storage locations):
Administrator 1.1 154
Administrator 100.1 155 1) __A mover__ – system parameter, set automatically (once / month, at the beginning of the month). With thismakrk specified items, that generate 80% of the company's turnover during the last 3 months and which have sold more than 1 pcs. - most IMPORTANT company goods. A mover item is highlighted in green.
Administrator 1.1 156
Administrator 100.1 157 * (((
158 if there is made a decision inside the company other goods (which the system did not count as a A mover) keep as most important (accompanying goods, etc., which will result in lower sales), these items can be manually marked as A mover (but on the first day of the month)
159 )))
Administrator 1.1 160
Administrator 100.1 161 2) __C mover __– systematic parameter, set automatically (once / month, at the beginning of the month). This mark highlight goods that generate 5 % of the company's total turnover during the last 3 months - slow moving goods. These goods are candidates to be exported from the assortment.
Administrator 1.1 162
Administrator 100.1 163 When calculating A / C movers, it is possible to specify the number of months from which the data will be taken for the calculation. The setting is made on a company-wide basis. Contact StockM if necessary.
Administrator 1.1 164
Administrator 100.1 165 3) __OUT mover type:__
Administrator 1.1 166
Administrator 100.1 167 ~1. OUT - mark for the item, which is removed from the range. If the check mark is placed on the OUT Mover mark, the item status automatically changes into DTO, in Central warehouse. After the stock balance ends, item status will become DTO/NM/NA (according to the setting in SM Admin). If we later receive the stock balance or some kind of movement of the NA item into StockM, the status of the item will become ND but mark OUT will remain.
Administrator 1.1 168
Administrator 100.1 169 **~ **2. CLN - mark for the item to be sold out that may be kept in the range further on or included in the range later again. If the check mark is placed on the CLN mark, the item status automatically changes into DTO, in Central warehouse. After the stock balance ends, the mark CLN will be automatically removed, the final status of the item remains as specified in the SM Admin. If we later receive the stock balance or some kind of movement of the items into StockM, the status of the items will remain DTO.
Administrator 1.1 170
Administrator 100.1 171 Until now, the final state of the OUT type (OUT / CLN) could be specified as one that was valid for both OUT and CLN.
Administrator 1.1 172
Administrator 100.1 173 These settings are now separated. The final states of the OUT types can be specified separately for the OUT mark and separately for the CLN. By default, the DTO status is assigned to CLN mark.
Administrator 1.1 174
Administrator 100.1 175 Contact StockM if necessary to replace.
Administrator 1.1 176
Administrator 100.1 177 //**PARAMETERS**//, set per item separately for each storage place.
Administrator 1.1 178
Administrator 100.1 179 1) NEW mover - new item mark, which is automatically applied to all newly updated items in the system. By default, item is considered as new for 3 months from the date when it was entered into the system. After 3 months, NEW mover mark is automatically removed (period, how long the item will be new, is agreed at the start of the project with project manager).
Administrator 1.1 180
Administrator 100.1 181 * this mark, when there is need, you can assign manually and determine till when the item will be marked as NEW. You will pay attention to this item before sending the order.
Administrator 1.1 182
Administrator 100.1 183 * NEW mover, which is included into the order the first time, is highlighted in yellow, that you would pay attention when you send order
Administrator 1.1 184
Administrator 100.1 185 It is possible to set the method for assigning the New mover mark. In the SM Admin module you can choose:
Administrator 1.1 186
Administrator 100.1 187 * how many days after the product card is created in the warehouse it is considered as new (NEW) or
188 * how many delivery periods (OLT - order lead time) of the item / order it must be considered with the NEW mover mark.
Administrator 1.1 189
Administrator 100.1 190 The setting can only be made on a company-wide basis.
Administrator 1.1 191
Administrator 100.1 192 //**OUT type, NEW marks**// assigning for item in StockM:
Administrator 1.1 193
Administrator 100.1 194 1) StockM → „Assortment“ → „SKU list“ → Filter: specific item, group of items and etc. -> in the row of selected item in the column OUT type select type or click [[image:EditSelected.png]] after marking the required rows.
Administrator 60.1 195
Administrator 100.1 196 (% style="letter-spacing:0.1px" %) 2)StockM → „Assortment“ → „Inventory“ → Filter: specific item, specific storage place, group of items and etc. -> in the selected item row in the column NEW put a check mark or click [[image:EditSelected.png]] after marking the required rows.
Administrator 1.1 197
Administrator 100.1 198 **//IMPORTANT(% style="letter-spacing:0.1px" %)~://(%%)**
Administrator 56.1 199
Administrator 100.1 200 **//OUT type is //placed on one item through all the system**. **Type shows that the item is being removed from the assortment (OUT) or sold out (CLN).**
Administrator 56.1 201
Administrator 100.1 202 **OUT:**
Administrator 62.1 203
Administrator 100.1 204 * In the central warehouse – DTO OUT (item is no longer filled into a central warehouse from an external supplier), in the regional warehouses – DTA OUT (the item is filled into warehouses/regional warehouses/shops, to sell the stock/balance of the item);
Administrator 62.1 205
Administrator 100.1 206 * when items/goods, which have the mark OUT, are out of stock in the central warehouse (balance = 0), the system will automatically transfer this item to the DTO status in warehouses/regional warehouses/shops (there are no goods/items to fill warehouses/regional warehouses/shops);
Administrator 62.1 207
Administrator 100.1 208 * when goods are out of stock in all storage places (stock/balance = 0), system automatically transfers the product to the DTO/NM/NA state. **State, to which is transfered the product, exported from the assortment, when its balance in all storage places is 0, is agreed with the customer at the beginning of the project !!!**
Administrator 1.1 209
Administrator 100.1 210 * if the item is delivered directly from the supplier to the regional storage place, then after placing the mark OUT, system transfers the item to the DTO state in all storage places.
Administrator 1.1 211
Administrator 100.1 212 **~ Assignment of OUT type to items with ALT status.**
Administrator 1.1 213
Administrator 100.1 214 For alternative items (ALT) may be specified:
Administrator 1.1 215
Administrator 100.1 216 * The type OUT for a product that is taken out of the range.
Administrator 42.1 217
Administrator 100.1 218 When the ALT item is out of stock in all warehouses, the item is dropped from the group and the status specified in the SM Admin is assigned.
Administrator 42.1 219
Administrator 100.1 220 * The type CLN for product on sale, which may be in the range in the future.
Administrator 42.1 221
Administrator 100.1 222 When the ALT product is out of stock in all warehouses, the item is dropped from the group and the status DTO is assigned.
Administrator 1.1 223
Administrator 100.1 224 For ALT items, the OUT type can be assigned:
Administrator 1.1 225
Administrator 100.1 226 * in the ALT items combination window "Alternative SKU" in the "OUT type" column (if you do not see the column in the window, open it via the column visibility selection);
227 * by uploading it via SM Admin, via template to merge ALT items: Actions -> Merge ALT groups.
Administrator 1.1 228
Administrator 100.1 229 In the column “OUT type” next to the item it is necessary to indicate:
Administrator 56.1 230
Administrator 100.1 231 * “1” to assign OUT to the item;
232 * “2” if CLN
233 * “0” to remove the assigned type
Administrator 1.1 234
Administrator 100.1 235 **CLN**:
Administrator 1.1 236
Administrator 100.1 237 * The distribution and statuses of the items which are marked CLN operate on the same principle as OUT, but the final status remains DTO everywhere.
238 * After the stock balance ends, the mark CLN will be automatically removed. If we later receive the stock balance or some kind of movement of the items into StockM, the status of the items will remain DTO.
Administrator 56.1 239
Administrator 100.1 240 **//NEW mark//** is placed for one item separately in every storage place.
Administrator 1.1 241
Administrator 100.1 242 == **Item (SKU) export from assortment** ==
Administrator 1.1 243
244
245
Administrator 100.1 246 If there is made a decision to export an item from the assortment, then the mark OUT must be assigned to the item, (look to: [[Item (SKU) marks TOP, NON, OUT, NEW)>>WebHome||anchor="HItems28SKU29marksTOP2CNON2COUT2CNEW"]].
Administrator 58.3 247
Administrator 100.1 248 .
Administrator 58.3 249
Administrator 100.1 250 == **Exported item (SKU) returning to assortment** ==
Administrator 56.1 251
252
Administrator 1.1 253
Administrator 100.1 254 If there is made a decision to return an item back to assortment, which has already been exported from the assortment, you must change the state for that item, from NA to DTA/DTO/NM/ND and the OUT mark MUST be removed and other required parameters must be set (checked).
Administrator 1.1 255
Administrator 100.1 256 ~1. Item (SKU) you will find: STOCK-M → „Assortment“ → „SKU list“ → Filter: specific item, group of items and etc..
Administrator 1.1 257
258
Administrator 100.1 259 2. In the window that opens put the mark OUT (see: [[Items (SKU) marks TOP, NON, OUT, NEW>>WebHome||anchor="HItems28SKU29marksTOP2CNON2COUT2CNEW"]]). Save changes
Administrator 1.1 260
Administrator 100.1 261 (% style="letter-spacing:0.1px" %)3. STOCK-M → „Assortment“ → „Inventory“ manage states of the items and other parameters (see: [[Items (SKU) states>>WebHome||anchor="HItems28SKU29states"]]).
Administrator 1.1 262
Administrator 100.1 263 == **Combining alternative items** ==
Administrator 1.1 264
265
266
Administrator 100.1 267 When 2 and more goods are analogous "in the eye" of the buyer and it is enough to keep at least one of these items, however there are several similar goods balance, OR a new product replaces an old one and so on. cases - such goods can be combined as alternatives. Then the system will then "see" one main item and the total data (balances, sales, additions) of all alternative items.
Administrator 1.1 268
Administrator 100.1 269 Alternative (analogous) goods are combined by a management decision, i.e. alternative items are attached to the main item (for alternative items in StockM is set a single buffer such items balances are summed up. When it is not possible to order the main item, the alternative is ordered):
Administrator 1.1 270
Administrator 100.1 271 ~1. If you want to combine items, the main code and alternative code must be in all StockM active storage places.
Administrator 1.1 272
Administrator 100.1 273 2. StockM → „Assortment“ → „SKU list“ → Filter: specific (the main) item or group of items -> After marking the rows you want, click [[image:EditAltGroup.png]].
Administrator 1.1 274
Administrator 100.1 275 You can also access into the ALT group window in the SKU card (without leaving the item card): [[image:EditAltGroup2.png]]
Administrator 1.1 276
Administrator 100.1 277 3. If you need to add an item to the group – click „Add SKU“ in the window that opens and select items, which you want to combine.
Administrator 1.1 278
Administrator 100.1 279 4. Choose which code will be "Main" and which SKU parameters (buffer, minbuf, maxbuf, state and service level) should be uploaded on the main SKU. The main and alternative items codes must be available at all storage locations.
Administrator 1.1 280
Administrator 100.1 281 [[image:34_NewSkuGroup.png]]
Administrator 1.1 282
Administrator 100.1 283 5. A warning has been made in the confirmation window of combining when saving settings that both main and alternative items will be distributed through the warehouses. Distribution takes place through all warehouses containing at least one product involved in the ALT combination. The message after combining of items will show how many new items (SKU) cards have been created through the warehouses.
Administrator 1.1 284
Administrator 100.1 285 ALT items cannot be combined if the item whose parameters we are taking has NA status across all warehouses.
Administrator 1.1 286
Administrator 100.1 287 6. After saving, the data of the alternative items (excluding the status) will be copied and added to the main item. More specifically, “movement” data (sales, transfers, balance, replenishments, PTO) that you see next to the main item will be summed of the combined items.
Administrator 41.1 288
Administrator 100.1 289 7. Mass combining into groups of alternative items (ALT) is available. In SM Admin menu (ADMIN -> ACTIONS -> MERGE ALT GROUPS) window there is a draft of the table for mass combining of the items into ALT groups.
Administrator 41.1 290
Administrator 100.1 291 [[image:20200918.jpg]]
Administrator 1.1 292
Administrator 100.1 293 * Main SKU code: SKU code of the main item in the group. 
294 * Parameters SKU code: SKU code of the item, which parameters will be assigned to the main SKU.
295 * Old Main SKU code: if the existing group of items is changed, indicate the existing (old) code of the main SKU in the group. The Main SKU code field must contain the new main SKU code.
Administrator 1.1 296
Administrator 100.1 297 If a new group is being combined, do not specify anything in this field.
Administrator 1.1 298
Administrator 100.1 299 * Alt SKU code: SKU code of alternative item
Administrator 1.1 300
Administrator 100.1 301 Note: If there is more than one ALT item code for the same main SKU code, they must be listed on separate rows, repeating the main SKU code on each row.
Administrator 1.1 302
Administrator 100.1 303 The completed table needs to be imported into StockM.
Administrator 1.1 304
Administrator 100.1 305 8. Orders will always be formed for the main item.
Administrator 1.1 306
Administrator 100.1 307 9. When items are combined, the history of all items is summed up and uploaded on the main item, and the history of alternative items is **REMOVED IRREVERSIBLY.**
Administrator 1.1 308
Administrator 100.1 309 10. To edit an existing group: StockM → “Assortment” → “SKU List” → Filter: specific (main) item or group of items → Mark the rows you want and click [[image:EditAltGroup2.png]]. In the window that opens you will see all items, related with the marked item.
Administrator 40.1 310
Administrator 100.1 311 ~11. If the item needs to be connected to already combined alternative items, then click "Add SKU" and select items, which you want to connect.
Administrator 55.1 312
Administrator 100.1 313 12. If the item needs to be removed from the alternative items group, then click "Remove SKU". It is possible to remove an item from combined items group, but that item must be an alternative (to remove the main item, you must first make it an alternative and select another item as the main item, before removing it). Once an item has been separated from the group, its history is** NOT returned.**
Administrator 55.1 314
Administrator 100.1 315 13. The status of the alternative item is automatically transferred to "ALT". You see that the item is an alternative in the "Inventory" window, in the column "State". Alternative item's main item is visible in the window "SKU List" or "Inventory", in the column "Main SKU".
Administrator 55.1 316
Administrator 100.1 317 14.  When items are merged in the ALT group, if at least one item in the group has TOP movers mark, immediately after the merge the TOP movers mark will be assigned to the main SKU of that group (only the TOP movers mark is checked)
Administrator 55.1 318
Administrator 100.1 319 (% style="letter-spacing:0.1px" %)15. After disconnecting the alternative item from the connected items, that item will appear among new incompleted cards with buffer 0 and state ND.
Administrator 55.1 320
Administrator 100.1 321 16. When in all storage places state for the main item is changed to NA, then the alternative group of items is "disassembled", i.e. alternative items are disconnected from the main and the state of the alternative items automatically changes to NA.
Administrator 55.1 322
Administrator 100.1 323 17. For alternative items (ALT) may be specified:
Administrator 55.1 324
Administrator 100.1 325 * The type OUT for a product that is taken out of the range.
Administrator 58.1 326
Administrator 100.1 327 When the ALT item is out of stock in all warehouses, the item is dropped from the group and the status specified in the SM Admin is assigned.
Administrator 58.1 328
Administrator 100.1 329 * The type CLN for product on sale, which may be in the range in the future.
Administrator 58.1 330
Administrator 100.1 331 When the ALT product is out of stock in all warehouses, the item is dropped from the group and the status DTO is assigned.
Administrator 58.1 332
Administrator 100.1 333 18. For ALT items, the OUT type can be assigned:
Administrator 58.1 334
Administrator 100.1 335 * in the ALT items combination window "Alternative SKU" in the "OUT type" column (if you do not see the column in the window, open it via the column visibility selection);
336 * by uploading it via SM Admin, via template to merge ALT items: Actions -> Merge ALT groups.
Administrator 58.1 337
Administrator 100.1 338 19. In the column “OUT type” next to the item it is necessary to indicate:
Administrator 63.1 339
Administrator 100.1 340 * “1” to assign OUT to the item;
341 * “2” if CLN
342 * “0” to remove the assigned type
Administrator 63.1 343
Administrator 100.1 344 20.  Combining of alternative items: assigned parameters includes promotions and periods.
Administrator 1.1 345
Administrator 100.1 346 If the item whose parameters are assigned to the main item by combining alternative items, participated, participates or will participate in promotions/period that not started yet, these parameters (including history) of this item are assigned to main the item as well.
Administrator 1.1 347
Administrator 100.1 348 == **After setting assortment, these actions are next** ==
Administrator 1.1 349
350
Administrator 100.1 351 ~1. Supplier parameters are defined/set (see: [[Supplier settings>>doc:User_Manual.Suppliers.WebHome]])
Administrator 1.1 352
Administrator 100.1 353 2. Primary item‘s buffers are defined/calculated (see: [[Item (SKU) settings>>doc:User_Manual.SKU_Settings.WebHome]]).
Administrator 1.1 354
Administrator 100.1 355 == **Additional informational columns** ==
Administrator 1.1 356
357
358
Administrator 100.1 359 **~1. New indicator "Days since balance change" .**
Administrator 1.1 360
361
362
Administrator 100.1 363 In all windows, where provided SKU information through the warehouse, included new column with information, how many days the balance doesn't change in a storage place.
Administrator 1.1 364
Administrator 100.1 365 New indicator helps you to notice items (without waiting for monthly assortment reports) faster, which "don't move" and to make quicker decisions about exporting from assortment or additional actions for stimulating sales.
Administrator 1.1 366
Administrator 100.1 367 Counting of days from the last change of balance started from update installing date (18.07.2018) - recounting is not done in retrospective date.
Administrator 1.1 368
Administrator 100.1 369 By default, the column is not displayed, you must select their visibility through the Table settings window to see the column.
Administrator 1.1 370
Administrator 100.1 371 [[image:35_NoBalanceChange.png]]
Administrator 1.1 372
Administrator 100.1 373 **2. Columns in the Inventory window „In Group“ and „Main SKU“**
Administrator 1.1 374
375
376
Administrator 100.1 377 In the Inventory window there are visible columns "Group" and "Main SKU", which helps to analyze alternative group information easier.
Administrator 1.1 378
Administrator 100.1 379 By default columns are not showed, if you want to see new added columns, you have to select it‘s visibility through Table settings window.
Administrator 1.1 380
Administrator 100.1 381 [[image:36_InGroupmainSku.png]]
Administrator 1.1 382
Administrator 100.1 383 **3. Display of Warehouse A and C movers**.
Administrator 57.13 384
Administrator 100.1 385 The Movers mark is assigned as general through the company, however if you want to analyze and observe items, which becasue of the price in one storage place "move" good and in another - not, it is possible to do this in the Inventory window and SKU card. The column "LocABC" - Movers through the warehouse. If the item is new, you will see "New" in the "LocABC" column (if the "New to" date has not passed yet).
Administrator 57.13 386
Administrator 100.1 387 **4. The column "Next delivery".**
Administrator 57.13 388
Administrator 100.1 389 This column is visible in the Inventory, Suppliers Schedule windows and on the product card.
Administrator 57.13 390
Administrator 100.1 391 If the item is the same time in a several orders, the nearest expected delivery date is displayed.
Administrator 57.13 392
Administrator 100.1 393 p.s. if you don't see the column, open it through the column selection.
Administrator 1.1 394
Administrator 43.1 395
Administrator 100.1 396 == Module of perishable items (PER2) ==
Administrator 43.1 397
Administrator 100.1 398 StockM's module for perishable items (hereinafter PER2) is designed to manage goods and raw materials (hereinafter SKU), which overstock quantities have to be written off as loss relatively quickly due to:
Administrator 47.2 399
Administrator 100.1 400 * significant but recurring variations of demand during the week;
401 * due to the influence of similar items sales (cannibalism).
Administrator 47.2 402
Administrator 100.1 403 **It is an additional optional module and has an extra cost. This module is activated by StockM team only for the entire STOCKM program.**
Administrator 47.2 404
Administrator 100.1 405 SKUs whose supply is managed by this module must meet the following criteria:
Administrator 47.2 406
Administrator 100.1 407 * the number of orders during the SKU validity period does not exceed the set limit;
408 * SKU is replenished at least twice a week;
409 * SKU can have similar competing SKUs, whose sales promotion affects its own demand;
410 * weekly ordering schedule;
411 * the status of the item must be DTA. If status of item in item group is not DTA, PER2 module will manage only SKUs with status DTA;
412 * SKU validity must be specified.
Administrator 47.2 413
Administrator 100.1 414 **Initial settings – grouping.**
Administrator 47.2 415
Administrator 100.1 416 1. There must be indicated a limit on the number of orders during the SKU's validity period. It can only be entered by the StockM team (SM Admin setting). The setting is company-wide.
417 1. There must be indicated period of validity for the SKU.
418 1. A validity time threshold for balance validity evaluation must be specified. It can only be entered by the StockM team (SM Admin setting). The setting is company-wide.
Administrator 47.2 419
Administrator 100.1 420 StockM will automatically assign or will not assign the PER2 management method.
Administrator 47.2 421
Administrator 100.1 422 4. For related (similar, competing) SKUs, the PER2 group is described: StockM >> Menu >> Other >> SKU groups >> New.
Administrator 77.1 423
Administrator 100.1 424 If you want to manage a group immediately, specify an activity at once.
Administrator 47.2 425
Administrator 100.1 426 The group type “Perishable goods” is assigned at the company level.
Administrator 77.1 427
Administrator 100.1 428 The daily recalculation of estimated week sales (EWS) or item sales share (ISS) should be selected later if necessary.
Administrator 47.2 429
Administrator 100.1 430 The demand flexibility coefficient needs to be specified for the group (“Coefficient” column).
Administrator 47.2 431
Administrator 100.1 432 [[image:image-20220309153006-1.png]]
Administrator 47.2 433
Administrator 100.1 434 The coefficient take part in managment, when there are „items cannibals“  in a group, only during promotion.
Administrator 47.2 435
Administrator 100.1 436 We named „Cannibals“ such items, which „takes away“ sales from each other during promotion. The coefficient can also be called the "take away" coefficient (<1), which shows how much the quantity to order of the item, which doesn’t take a part in promotion, will decrease:
Administrator 47.2 437
Administrator 100.1 438 * 0 – indicates that there is no “cannibalism”;
439 * 1 - cannibalism 100%, i.e. if there are 2 items in the group and apply a promotion for one of them, - it takes all the sales of the other item;
440 * E.g: 0.5. If sales increase by 10 pcs, then by entering a coefficient 0.5 - sales of item, which does not take a part in a promotion, will decrease for 5 pcs (50%).
Administrator 77.1 441
Administrator 100.1 442 Select the coefficient of Cannibalism according to the **Cannibalism setting procedure**.
Administrator 82.1 443
Administrator 100.1 444 [[image:image-20220630093852-1.png||height="368" width="510"]]
Administrator 77.1 445
Administrator 100.1 446 5. When a group is created, the SKUs belonging to that group must be specified. This can be done by assigning one of the created groups to the SKU in the windows:
Administrator 48.1 447
Administrator 100.1 448 a) StockM >> Assortment >> SKU list >> SKU group;
Administrator 48.1 449
Administrator 100.1 450 b) StockM >> Assortment >> Inventory >> SKU card >> SKU in the company >> SKU group,
Administrator 47.2 451
Administrator 100.1 452 **Management**
Administrator 47.2 453
Administrator 100.1 454 1. In the “Perishable items card” window (StockM >> Other >> SKU groups >> Edit selected group (pencil) >> Perishable goods card), in the list on the left, after selecting the warehouse (below No. [1]), the right side contains the items information of the group of the selected warehouse:
Administrator 47.2 455
Administrator 100.1 456 [[image:image-20220309153519-2.png]]
Administrator 47.2 457
Administrator 100.1 458 * For each group, in each warehouse must be:
Administrator 47.2 459
Administrator 100.1 460 1)  Entered or calculated by system:
Administrator 47.2 461
Administrator 100.1 462 * Estimated week sales, in quantities (EWS). These are the seven estimated sales of days of a week. Shows the percentage of sales for each day from weekly sales.
463 * Item sale share, % (ISS) - shows the percentage of item from weekly sales of group.
Administrator 47.2 464
Administrator 100.1 465 (e.g. No. 2)
Administrator 47.2 466
Administrator 100.1 467 In the field "Estimated week sales" (e.g. No. 3) - the amount, obtained by suming all estimated week day sales. (e.g. No. 5).
Administrator 47.2 468
Administrator 100.1 469 2) Chosen method of management:
Administrator 47.2 470
Administrator 100.1 471 * Automatically by write-offs and lost sales
472 * Automatically by sales
473 * Manually
Administrator 47.2 474
Administrator 100.1 475 (e.g. No. 2)
Administrator 47.2 476
Administrator 100.1 477 When the management method "Auto by write-offs and lost sales" is selected, the system follows and changes the EWS and ISS depending on the result.
Administrator 47.2 478
Administrator 100.1 479 When the management method "Auto by sales” is selected, the system does a weekly recalculation. It is possible to turn on daily EWS and ISS recalculation for this method of management by putting a check mark in the appropriate column in the list of SKU group.
Administrator 47.2 480
Administrator 100.1 481 If you select manual management, the system does not change the EWS and ISS automatically, but give the recommendations for users, defined in red in example (e.g. No 8)
Administrator 47.2 482
Administrator 100.1 483 [[image:image-20220309154649-3.png]]
Administrator 48.1 484
Administrator 100.1 485 When you hover the mouse on the defined field (e.g. No. 8), an explanation of the result is displayed.
Administrator 48.1 486
Administrator 100.1 487 2. In order for the system to calculate EWS and ISS at the time of the first setting or if they need to be recalculated later, click „Calculate this warehouse“ (e.g. No 4).
Administrator 47.2 488
Administrator 100.1 489 In the table that appears, select "All warehouses" (3) to recalculate the values
Administrator 47.2 490
Administrator 100.1 491 for all warehouses at once.
Administrator 47.2 492
Administrator 100.1 493 For the newly created group it is necessary to calculate both values - EWS and
Administrator 47.2 494
Administrator 100.1 495 ISS (1 and 2).
Administrator 77.1 496
Administrator 100.1 497 Calculation is based on the average sales for the last 4 weeks of the relevant day of the week: E.g.: the sales of Monday group are calculated based on the average of the last 4 Mondays sales.
Administrator 77.1 498
Administrator 100.1 499 [[image:image-20220309154804-4.png]]
Administrator 47.2 500
Administrator 100.1 501 3. Below in the same window is a table with the items list of group in the selected warehouse, where shown the share of the item in a group and overstock/lost sales matrix (e.g. No. 6)
Administrator 47.2 502
Administrator 100.1 503 You can manually edit Item sales share (ISS). After changing the value, click „Calculate Item sales share % (ISS) (e.g. No.7). Then the system will change the ISS values of other items from the group so, that their sum would be 100 %.
Administrator 47.2 504
Administrator 100.1 505 **Supportive settings – reaction to variation of demand.**
Administrator 47.2 506
Administrator 100.1 507 The "Lost Sales and Write-Off Days" columns show the total results for the last 4 weeks on weekdays:
Administrator 47.2 508
Administrator 100.1 509 E.g.
Administrator 47.2 510
Administrator 100.1 511 • 4 - indicates that there was shortage of items (lost sales) of the items 4 times in 4 weeks on a specific day (black color);
Administrator 47.2 512
Administrator 100.1 513 • 0 – thus, the balance (of lost sales and write offs) at the end of the day was 0;
Administrator 47.2 514
Administrator 100.1 515 • 1 - indicates that there was an overstock (write offs) 1 time in 4 weeks on a specific day (blue color)
Administrator 47.2 516
Administrator 100.1 517 [[image:image-20220309155739-5.png]]
Administrator 77.1 518
Administrator 100.1 519 The column „Since last ISS change“ shows the result within the specified number of days – the number in the black shows how many days the item was missing; the number in the blue shows how many cases of write - offs of the item was.
Administrator 47.2 520
Administrator 100.1 521 [[image:image-20220309155923-6.png]]
Administrator 47.2 522
Administrator 100.1 523 When managing "Auto by sales”, the system weekly automatically recalculate EWS and ISS, unless otherwise specified.
Administrator 47.2 524
Administrator 100.1 525 When managing "Auto by write-offs and lost sales", the system automatically change EWS and ISS acording the result.
Administrator 77.1 526
Administrator 100.1 527 When managing manually then character of dominance of lost sales and write-offs need to be valued (or recalculated):
Administrator 77.1 528
Administrator 100.1 529 1. If colums dominates, the value of EWS whould be reviewed and corrected:
Administrator 77.1 530
Administrator 100.1 531 * If dominates black (zero inventory) everywhere – increase the value of EWS;
532 * If dominates blue (write-offs) – reduce the value of EWS.
533 * If blue (or black) dominates on certain days of the week - decrease (or increase) the value of that day or recalculate the value;
Administrator 77.1 534
Administrator 100.1 535 2.  If dominates in rows – correct ISS value:
Administrator 77.1 536
Administrator 100.1 537 * If blue (or black) dominates for certain SKU throughout the week, decrease (or increase) the ISS for that SKU.
Administrator 77.1 538
Administrator 100.1 539 Managing manually, the system provides recommendations to the user to change the values, taking into account the dominant character of lost sales and write-offs of items, as it is shown in example (e.g. No.8).
Administrator 77.1 540
Administrator 100.1 541 If you agree – press the sign of arrow and system will change the value to the one specified.
Administrator 77.1 542
Administrator 100.1 543 If you agree with all suggestions – press „Accept Recommended EWS“ (e.g. No.9).
Administrator 77.1 544
Administrator 100.1 545 Similarly, the system provides recommendations on ISS changes.
546
547 The system shows the last EWS and ISS date of change (e.g. No.10).  Hovering a mouse on it, system shows, when will be another change of values.
548
549 **Promotions**
550
551 During promotions, the system calculates the promotion quantity for the item, the ISS of such item is frozen, the system does not change it.
552
553 While the promotion is running for an item, the date is displayed in the Promotion date field (e.g. No. 10). At the end of the promotion, the end date of the last promotion - the last day of freezing - is displayed in the field.
554
555 **Orders of items.**
556
557 * During each order formation the buffer of item is calculated, which consists of estimated sales of item for the period from the day of arrival of the formering order to the day of arrival of the next order, taking in to account the share of the item's sales in group (EWS * ISS = BUF);
558
559 * It is allowed buffer to become lower than MOQ. Rounding is based on the accuracy of the unit of measurement;
560 * For perishable items, the balance is not evaluated in the order, if the items of the last order are no longer valid, when the formed / sent order will arrive;
561 * Even if the order is not counted, the system orders 1 MOQ;
562 * Perishable items are included in the order together with the other items, if a general order formation schedule is provided.
563
Administrator 77.1 564
This wiki is licensed under a Creative Commons 2.0 license
XWiki Enterprise 11.10.2 - Documentation