Posted by: Anjana Rames in Retail Management, IT, B2B on
May 2, 2010
In our previous blog we talked about the strategic importance of service levels to differentiate your Office Supplies & Stationery Business from the rest. A good service comes in different forms and shape, one of which is fulfilling customers orders in a timely manner.
In order to fulfill orders we need the right stocks in our warehouse/store and managing this stock is key to customer satisfaction. We touched upon A & B stock analysis and how it helps achieve this. In this blog we will look at A,B,c stock management in more detail.
Posted by: Anjana Rames in B2B on
Jan 30, 2010
The products each reseller offer to their clients are more or less the same in the Stationery and Office Supplies Industry. So the key differentiator between any two resellers is the service levels they offer.
Service comes in different forms and shape. One of the most important aspects of a good service is the ability to fulfil customer orders in a timely fashion. This in turn is dependent on the availability of the right stocks in your warehouse or store.
Posted by: Anjana Rames in B2B on
Dec 21, 2009
In our previous blogs, we looked at the importance of Identifying Dead Stock and went through a few strategies we could use to clear the Dead Stock identified.
Having the list ready for action is one mile stone completed, however execution is the key part of this exercise.
If this sheet is simply passed on to one of your staff members to take action, chances are this will be the last on their list of priorities.
Posted by: Anjana Rames in Untagged on
Oct 30, 2009
Your software package, accounting package or ERP system may have in-built features that can take in specific parameters and list the SKUs satisfying the input conditions.
If this facility is not available, you can export the stock sheet for each location or warehouse into a format that can be opened using Excel. The data fields that could be pulled out include:
- Date on which the SKU was created
- SKU number
- Description
- Quantity of Sales for the past 6 months
- Bin number
- Avg Cost
- Stock on Hand
By using simple Excel functions, you will be able to identify all the SKUs that have 0 quantity of sale in the last 6 months.The calculation logic could be If the 6 Month Sum of Qty of Sale of SKU is zero then Flag the entry as Dead.
Posted by: Anjana Rames in B2B on
Oct 30, 2009
I am sure many of you would be looking at ways of reducing costs, especially in the current economic climate. A simple yet effective cost control strategy revolves around managing your Dead Stock.
What is Dead Stock?
It is nothing but the stock that you have purchased previously which is still hiding in the aisles and corners of your Retail stores and Warehouses, literally gathering dust.
Although your store may appear to be well stocked and full, this Dead Stock is giving you a false impression of the overall value in the store.