Chapter Topics
Viewing Stock Data in the XpertMatrix
Changing the Order of Rows and Columns in the XpertMatrix
Switching Rows for Columns in the XpertMatrix

Viewing Stock Data in the XpertMatrix
The XpertMatrixdisplays the stock on hand for a certain style in a Color/Store/Size/SecondSize matrix. The XpertMatrix offers a dynamic way to quickly see your inventory and spot where you may be overstocked or understocked. For example, a sales clerk in a store where the items are sold out, would open the matrix to see if the sold out item is in stock anywhere else in the chain.XpertMatrix is launched by pressing the matrix button on the toolbar in any catalogue: .

The size of the XpertMatrix can be adjusted by moving the cursor to one of the corners of the window. The contents displayed automatically adjust to the size of the window; scroll bars will appear along the bottom and along the right side if the window becomes smaller than contents being displayed. The width of the columns in the matrix is configurable and can be adjusted in the Document Screens Tab of the Station Configure menu. You can also adjust the width of any column temporarily by clicking on the border of the column and dragging it to its desired size. (To temporarily adjust the width of all columns, press the right button of the mouse and click on Select All in the menu that appears before adjusting the width of the column).

The XpertMatrixwindow shows the name of the Style at the top (the Highbrows style in the example above) as well as the Department and Vendor it belongs to. In the basic display, the colors that the style is available in are displayed in rows along the left. In the example above, you can see that the Highbrows loafer is available in Black and in Silver. Also in the vertical axis, next to the Color rows, all of the stores in the chain are displayed. In this case, there are five stores: Capilano, Oakridge, Pacific, Robson and West 4th. Along the horizontal axis you see first the sizes the style is available in, and then the second sizes. In this case, the Highbrows loafer is available in sizes 5.0 - 10.0 and each Size comes in one of three Second Sizes: narrow, medium and wide. The Second Size is optional and many matrices will only show the Size along the horizontal axis.

Every combination of a color, a store, a size and a second size creates a cell in the matrix. Every cell in the matrix represents an item and the number in that cell shows the current stock level for that item. In the above example, there are currently 3 Silver Size 5.0 Narrow Highbrow loafers in stock in the Oakridge store and 2 Black Size 5.5 Wide in the Robson store. When there is a zero in a cell it means the item is out of stock, as is the case with the Silver Size 5.0 Narrow at both the Pacific and Robson stores. If a certain Color/Size/SecondSize combination did not exist then those corresponding cells would appear in gray.

Along the bottom and the right-hand side there are subtotals appearing in cells shaded pink. The pink cells along the bottom show the total of a particular Size/SeondSize combination. In the example above, there are 17 Size 5.0 Medium loafers in stock in all five stores in the chain, in both colors. The pink cells along the right show the total of a particular Color/Store combination. For example, the image above shows that there are a total of 59 Black loafers in the West 4th store in all sizes and second sizes. The cell in the bottom right-hand corner shaded dark pink shows the aggregate total for the style. In this case, there are a total of 465 Highbrow loafers available in every size and color throughout the chain.

Changing the order of Rows and Columns in the XpertMatrix
The way that the XpertMatrix displays data can be changed to help you get more insight into your inventory. You can change which information is shown in the horizontal and vertical axes and the order in which it is shown. In the example we saw above, the XpertMatrix was displaying  Color/Store combinations in the vertical axis. You can reverse this order so that the rows show Store/Color combination by putting the cursor over the Store column and dragging it to the left of the Color column, as shown below:

You can now visualize stock information primarily by store. The totals displayed in the pink column to the right will still match the ones displayed before (after all, the stock levels have not changed) but the order has been changed. Notice, for example, that the total number of Silver loafers in the Capilano store, 46, remains the same, but is now displayed as the second pink cell from the top and not the sixth from the top as it was before.

The stores and colors are listed in alphabetical order by default. However, you can move the rows around if it will help you better visualize the data. For example, if you want to closely compare the stock levels of the Robson store with those of the Capilano store, you can move the cursor over the Robson row header, click on it and drag it to the top as shown below:

When you release the mouse button, the Robson store row will be moved to the new location as shown below:

Notice that the two subtotals for the Robson store, 45 for Black and 41 for Silver, have been moved up to the top along with
the stock levels for every Size/SecondSize combination.

The same kind of rearrangement can be done on the horizontal axis. In the XpertMatrix basic display that was shown in the beginning, the matrix showed Size/SecondSize combinations on the horizontal axis. You can reverse this order so that the columns show SecondSize/Size combinations by putting the cursor over the Second Size header and dragging it to the top of the Size header, as shown below:

The XpertMatrix now shows the stock data by SecondSize/Size pairs: all of the Narrow sizes are shown first, followed by the medium sizes and so on. The totals displayed in the pink row at the bottom will still match the ones displayed before, but the order has changed.

Sizes are displayed in alphanumeric order form left to right by default. However, just as you are able to rearrange the order of the rows on the vertical axis, you can move the columns around to help you better understand the data. For example, if you want to closely compare the stock levels in Size 7.5 Narrow with those in the Size 5.0 Narrow, you can move the cursor over the Size 7.5 Narrow column header, click on it and drag it to the left as shown below: 

The Size 7.5 Narrow stock column is now next to the Size 5.0 Narrow stock column for easy comparison. Notice that the total in pink (25 pairs) has also moved.

Switching Rows for Columns in the XpertMatrix
The way the XpertMatrixdisplays stock data can further be modified by switching the information that is displayed in the horizontal axis to the vertical axis and vice-versa. This function is particularly useful if you want to isolate one of the four dimensions (Color, Store, Size and SecondSize for closer inspection). For example, you can move the Size column and make it a row. To do this, move the cursor over any Size header and right-click. You will see a small menu open up; select the Move to row headers option as shown below:

The Size will now appear as a row, alongside the Color and Store rows. This is a useful way to isolate the SecondSize dimension as you can now see subtotals for Narrow (199), Medium (115) and Wide (151).

As discussed in the previous section, you can change the order in which the rows arranged. In the example above, the information along the vertical axis is predominantly orderd by Size. However, you could rearrange the display so that the information is primarily displayed by Store by clicking on the Store column header.

Similarly, any column can become a row. To do this, right-click over any row header and select the Move to column headers option in the menu that appears. In the example below, the Color row is being moved to a column.

The total stock levels for each store have now been isolated. You can now see, for example, that the West 4th street has a lot more stock than the other four stores. If each store had received the same number of Highbrows loafers, this might be a matter of concern. The point is that by changing the way information is displayed, a new insight was suddenly made available.

Copyright © 2002 XpertMart

* Return to Catalogs *

* Return to Table of Contents*