1 Reply Latest reply on Jul 9, 2011 12:51 AM by hjustmann

    inventory stocking

    lee Newbie

      we are a ecommerce retailer. we have two warehouses and we also drop ship a majority of goods. I need to build a inventory model in excel which will decide


      1) what skus to keep in warehouses and what to drop ship

      2) if i keep skus in warehouses, then how many volume?


      how should i build this model in excel? what should i take into consideration. ? is there any template that you can share please. it will be very helpful thank you much

        • Re: inventory stocking
          hjustmann Novice

          Hello Lee,


          It sounds as if you have a thriving business.  My name is Harvey Justamann.  I've been in importing and supply chain management for 25+ years.  Of course an Excel model can be built to become a tool in managing your inventory.  I do not think you will find a model that fits your business in a pre-made template.  In order to make the best tool for your business many questions must be asked and answered.  I have built many financial forecasts in Excel. I would be happy to give you some advice at no charge.


          Best of luck,


          Harvey Justmann