Have you found the inventory solution you were seeking back in May? I
f not, I would like to speak with you.

--- In Distribution_Inventory_Control@yahoogroups.com, "henry_l_lyu"
<henry_l_lyu@...> wrote:
>
> Hi:
>
> I am a rookie for an IT department. And it is one of my duty to keep
> inventory clear and effective. Now I am looking for any inventory
> solution for hundreds of IT related parts. Appreciate any suggestion
or
> source I shall look at. I work for a company about 200+ users with
> LAN.
>

Hi, comments appreciated please
I deal with database of aircraft parts.
Currently we have customer and supplier UoMs set up and qty of stock
can only be expressed as an integer.
We don't really have a concept of "our" part or UoM.
Should I create one?
Should I try to convert to a "base" UoM that is the smallest
denomination?
Can I get away with the existing integer (non-decimal) quantity of
stock by doing that?

Any ideas on where I could source info that discusses this particuar
subject in detail?

Thanks in advance

Hi, thanks for reply.
We have our own home grown system that i'm trying to keep alive.
Changing quantities to decimals is probably more difficult than
implementing the idea of a master lowest denominator unit but I can
imagine whatever I devise there'll be an exception to it.

We buy and sell in diff UoMs it's unavoidable.  Very very aware of
pitfalls which is why one of my tasks is to fix it.  We still have
25 cartons of blue velcro we can't sell :)
Just wondered if the concept of a master part and lowest common
denominator UoM has benefit if I can handle decimals?

How do I deal with the situation where we buy in rolls but
distribute in metres (fractions fo a roll) the material, hydraulic
hose can not be joined and therfore. 0.4 (4 metres)of a roll and 0.6
of roll does not equate to a full roll or 10 metres....!!

Thanks

--- In Distribution_Inventory_Control@yahoogroups.com, "Dave
Piasecki" <dave@...> wrote:
>
> I'm not sure exactly what you are asking here, but if you can only
express
> U/M as an integer, you really have no choice but to use the
smallest U/M as
> your system U/M. From that, you may be able to "fake" other U/Ms on
> documents and reports (such as Purchase orders or customer orders)
or even
> on inquiry screens.
>
> However, if you want to properly use multiple U/Ms, you would need
to be
> able to track portions of U/Ms (therefore you would need the
ability track
> decimal places). Most mainstream inventory systems should be able
to do
> this.
>
> Whatever you choose to do, make sure you carefully consider the
implications
> of using multiple units of measure. The biggest issue being that
multiple
> U/Ms tend to create confusion and subsequently errors (big
errors). So if
> you do use them, you need to make sure you work through the
processes that
> would be impacted and that all involved are properly trained. You
will
> probably also want to look into ways of quickly identifying errors
that may
> result from U/M confusion (exception reports are useful for this
type of
> monitoring).
>
>
>
>              Dave Piasecki
>  <http://www.inventoryops.com>
>
>   _____
>
> From: Distribution_Inventory_Control@yahoogroups.com
> [mailto:Distribution_Inventory_Control@yahoogroups.com] On Behalf
Of
> happyolly
> Sent: Thursday, August 02, 2007 5:56 AM
> To: Distribution_Inventory_Control@yahoogroups.com
> Subject: [Distribution_Inventory_Control] UoM - base/master UoM
>
>
>
> Hi, comments appreciated please
> I deal with database of aircraft parts.
> Currently we have customer and supplier UoMs set up and qty of
stock
> can only be expressed as an integer.
> We don't really have a concept of "our" part or UoM.
> Should I create one?
> Should I try to convert to a "base" UoM that is the smallest
> denomination?
> Can I get away with the existing integer (non-decimal) quantity of
> stock by doing that?
>
> Any ideas on where I could source info that discusses this
particuar
> subject in detail?
>
> Thanks in advance
>

If your system will handle it, buy by the 'roll' and sell by the foot

Dave

--- In Distribution_Inventory_Control@yahoogroups.com, Dave Strebe
<dstrebe@...> wrote:
>
> If your system will handle it, buy by the 'roll' and sell by the foot
>
> Dave
>
eeeeerrrrrr....what? afraid that's not overly helpful sorry

--- In Distribution_Inventory_Control@yahoogroups.com, "happyolly"
<oraustin@...> wrote:
>
> --- In Distribution_Inventory_Control@yahoogroups.com, Dave Strebe
> <dstrebe@> wrote:
> >
> > If your system will handle it, buy by the 'roll' and sell by the foot
> >
> > Dave
> >
> eeeeerrrrrr....what? afraid that's not overly helpful sorry
>
Sorry my apologies didn't mean to be obtuse,
so why can't you set the issue unit of measurement
for the hose to a 'centimeter' or a 1/3 of a meter (foot) or what ever
handling unit you want to sell it at that works best for your business
just make sure all the hose is sold the same way. If your system can
handle it buy the hose by the roll (ie.1 roll is 500') have your
system convert it to the issue unit and receive it into your stock at
the corrected HU for sale (ie. 6000" if you want to sell by the inch)
or whatever measurements you want to use. or have I completely
misunderstood the problem?

Dave

Hello,
I am working in a company business with fasteners.
There are always thousands of fasteners every month
for our business transactions.
How can we know the best EOQ? I know its related with
suppliers MOQ,customers history usage, forecast,the
items leadtime and the ship mode etc. It is really
very complicated that how can I get the EOQ. Currently
we are facing some items overbuild stock while some
facing urgency from customer's side. How about the
inventory turn in the this field?

Any good examples to share with me? Or any new ways of
calculation of the EOQ?

Appreciated your reply!

Ling




       ___________________________________________________________
ΗΐΧ’ΡΕ»’Γβ·ΡΣΚΟδ3.5GΘέΑΏ£¬20MΈ½Όώ£‘
http://cn.mail.yahoo.com

Hello,
I am working in a company business with fasteners.
There are always thousands of fasteners every month
for our business transactions.
How can we know the best EOQ? I know its related with
suppliers MOQ,customers history usage, forecast,the
items leadtime and the ship mode etc. It is really
very complicated that how can I get the EOQ. Currently
we are facing some items overbuild stock while some
facing urgency from customer's side. How about the
inventory turn in the this field?

Any good examples to share with me? Or any new ways of
calculation of the EOQ?

Appreciated your reply!

Ling

__________________________________________________________
ΗΐΧ’ΡΕ»’Γβ·ΡΣΚΟδ3.5GΘέΑΏ£¬20MΈ½Όώ£‘
http://cn.mail.yahoo.com

Hi; I'm glad I found this forum.  The inventory sysytem used here is
SBT Pro, 5.0.  This is a small electronics manufacturer with inventory
accuracy and tracking issues.  My role, as a consultant, is to
determine if inventory is being 'lost', and if purchasing order volume
matchs end products sold.  The current system is unable to follow a
part from purchase to end products sold, due to how the system was set
up.
Any comments on the reliability of SBT in general and any ideas of how
you would approach this project?
Thanks for whatever advice you can give me.

wijtfinder

Hi; I'm glad I found this forum. The inventory sysytem used here is
SBT Pro, 5.0. This is a small electronics manufacturer with inventory
accuracy and tracking issues. My role, as a consultant, is to
determine if inventory is being 'lost', and if purchasing order volume
matchs end products sold. The current system is unable to follow a
part from purchase to end products sold, due to how the system was set
up.
Any comments on the reliability of SBT in general and any ideas of how
you would approach this project?
Thanks for whatever advice you can give me.

wijtfinder

Hi,

Well, I was assigned a task to develop automated data collection
system for inventory control. If anyone can give me directions where
I can find good information how that system should work will be very
helpful for me...


Thanks

Hi,

Well, I was assigned a task to develop automated data collection
system for inventory control. If anyone can give me directions where
I can find good information how that system should work will be very
helpful for me...

Thanks

The following sites are good resources

    www.inventoryops.com
    logistics.about.com
    www.apics.org
    www.idii.com

If you're planning to roll your own in Access there is a db schema here.
    http://office.microsoft.com/en-us/templates/TC010184581033.aspx

For commercial offerings google the following:
    Warehouse Management System
    inventory software

Phil Curnan
www.wildmousesoftware.com

--- In Distribution_Inventory_Control@yahoogroups.com, "bresliev"
<bresliev@...> wrote:
>
> Hi,
>
> Well, I was assigned a task to develop automated data collection
> system for inventory control. If anyone can give me directions where
> I can find good information how that system should work will be very
> helpful for me...
>
>
> Thanks
>

New to this forum so apologies if this has been covered. Some of my
branch managers use min/max as the amount of product they WANT to
stock of a certain product; some use min/max as the amount of product
they can PHYSICALLY store in a location.  I've been asked to come up
with a definition that we all agree upon.  Looking for pros/cons of
using either definition. Thank you.

New to this forum so apologies if this has been covered. Some of my
branch managers use min/max as the amount of product they WANT to
stock of a certain product; some use min/max as the amount of product
they can PHYSICALLY store in a location. I've been asked to come up
with a definition that we all agree upon. Looking for pros/cons of
using either definition. Thank you.

--- In Distribution_Inventory_Control@yahoogroups.com, "dselgen"
<dselgen@...> wrote:
>
> New to this forum so apologies if this has been covered. Some of
my
> branch managers use min/max as the amount of product they WANT to
> stock of a certain product; some use min/max as the amount of
product
> they can PHYSICALLY store in a location.  I've been asked to come
up
> with a definition that we all agree upon.  Looking for pros/cons
of
> using either definition. Thank you.
>

Could we have a little more information? If you have a stockroom
plus
a display area than this will affect how you want to order more
product. If it is for just a stock location, then you should go for
max storage not what each individual wants. Maximise your storage
space and then have a low trigger quantity for reorder. Base this
reorder quantity on how long the product takes to come in, vs how
many
you use in that waiting period. That will hopefully stop you from
running out
of any products. I hope this makes sense, if not, mail me to clarify
any points.

Mike B.

--- In Distribution_Inventory_Control@yahoogroups.com, "dselgen"
<dselgen@...> wrote:
>
> New to this forum so apologies if this has been covered. Some of my
> branch managers use min/max as the amount of product they WANT to
> stock of a certain product; some use min/max as the amount of product
> they can PHYSICALLY store in a location.  I've been asked to come up
> with a definition that we all agree upon.  Looking for pros/cons of
> using either definition. Thank you.
>

Using your parts inventory record to store information about your
physical plant is counter to common practices.

Typically you store the overall min / max (ie. the amount of product
they want) with the part inventory record and the limits of different
storage locations in a separate table. The min / max is typically used
to control purchasing as in when to trigger a PO and calculating the
amount to order. The max is based on price breaks, previous usage and
other various factors including in your case the physical limitations.
To use it for physical capacity alone reduces its  functionality.

Put the physical capacity limitations in a separate table and have
your software take it into account when issuing purchase orders. If
you centralize purchases then use it to calculate when to issue stock
to the branch.

Phil Curnan
WildMouseSoftware.com

Hey,

     Min / Max isn't a simple determination in my eyes.  Yes the basic
premise is: max represents the most inventory you want to maintain
and min represents the minimum accepted inventory level.

     There are several factors that need to be analyzed to arrive at
these numbers.

     Without discussing how to determine them, I will list some of
them.

     * Sales Analysis.  How many do you sell?
     * How often do you re-order inventory?
     * How long does it take for the supplier to process the purchase
order and ship?  Transit time for the shipment? (overnight ups,
overseas container, etc).
     * Cost of shipping as a percentage of the product.  Shipping can
be a hidden or sometimes overlooked expense of a company.  Thus
infrequent large orders or cheapest shipping methods, (ground service-
commercial standard).
     * How much room available to store the product.
     * does the product have a life span?  Perishable?
     * Does the product require special handling in heat or cold
weather that would limit summer or winter shipments.  Or increase the
shipping cost if a shipment were to occur in a season that doesn't
work well withthe product.
     * Financial burden of tying up money for inventory.  In a world
of "just in time"  there is no reason for companies, distributors,
warehouse, etc to maintain 90 days, 180 days of inventory any more.
     * Demand = is it seasonal, trend based, is the product compliment
another product.  Is sales dependant on a main products  sales? If
so, analysis of the main product, market, trend, etc needs to be
factored as well.
     * Does the product require repackaging, relabeling, sorting,
adjustments, etc prior to being able to sell.
     * How often do you want to rotate inventory annually?
     * Pricing structure of the product.  Price breaks, shipping
discounts, etc.


     If your not sure of some of these factors base your minimum
high.  You could also introduce a third value to the max/min theory.
A re order point.

     For instance.  A product that sells 100 permonth, takes two weeks
from purchase to arrival, purchased once a month, space can
accomadate plenty considering the item is small. Requires no
repackaging of any sort upon arrival.  Can ship by courier ground
service.  Shipping is relativiely inexpensive considering it is small
and accessible withinnorth america.  The product does not show a
seasonal trend, consistant sales, does not have another product that
it compliments.  Sales analysis shows 15% + growth over each year.

     I would maintain a max of 140 with a minimum of 40 and a reorder
point of 60.  Essentially 50 sell every two weeks.  day one 140 in
stock.  two weeks later 90 in stock.  two more weeks go by, 50 more
have been sold by this time.  40 in stock. At week three the order
went in for 80 (140-60). By end of week four, start of week five the
order arrives.

     Hope this helps.

Rob

----- Original Message -----
From: Cindy Graves
To: Distribution_Inventory_Control@yahoogroups.com
Sent: Thursday, September 06, 2007 2:39 PM
Subject: Re: [Distribution_Inventory_Control] Defining
minimum/maximum stock quantities



We are a small educational maintenance dept. and we use Max for the
amount we CAN/SHOULD store, and Min to trigger a reorder point....how
many before we reorder.....

Kind of a combination of both....and interesting concept, but for
sure everyone should be sure it means the same thing!

CGraves
Accountant
Facilities Management

dselgen <dselgen@...> wrote:
New to this forum so apologies if this has been covered. Some of my
branch managers use min/max as the amount of product they WANT to
stock of a certain product; some use min/max as the amount of product
they can PHYSICALLY store in a location. I've been asked to come up
with a definition that we all agree upon. Looking for pros/cons of
using either definition. Thank you.






----------------------------------------------------------------------
----------
Be a better Globetrotter. Get better travel answers from someone who
knows.
Yahoo! Answers - Check it out.

I'm trying to put a price on the cost of processing returns. Any magic
formula's out there?

Sandy MacDonald
Provincial Drug Distribution Program

Hello everyone, this is my first post but I am in need of some
guidance.  I am having a lot of trouble getting good inventory numbers
to the front.  I believe alot of this is due to work in progress,
however my physical counts never fit the computer's count.  Has anyone
out there run into this problem, and how did you overcome it?  Any
questions or suggestions would be appreciated.

Thank you for the response.  I spent some time on inventoryops.com so
I know what you mean by cycle counting, but to track at each
movement; does that mean simply more forms to sign or barcoding?  If
we go barcoding what are the pitfalls there?

--- In Distribution_Inventory_Control@yahoogroups.com, "Butcher, Mark
(GE Indust, ConsInd, consultant)" <mark.butcher@...> wrote:
>
> I would say that you have two options. First, would be to cycle
count during periods when the operations team is not performing any
functions (replenishment, order selection, receiving). If this is not
an option, then you will need to be able to identify and verify
product at each stage of movement.
>
> Mark Butcher
> Inventory Control Manager
> Baltimore ADC
> 238 Belvidere Rd
> Perryville, MD, 21903
> Phone: 410-996-2616
> Fax: 410-996-2634
> mark.butcher@...
>
>
> -----Original Message-----
> From: Distribution_Inventory_Control@yahoogroups.com
[mailto:Distribution_Inventory_Control@yahoogroups.com]On Behalf Of
jonah_the_mighty
> Sent: Monday, September 10, 2007 5:41 PM
> To: Distribution_Inventory_Control@yahoogroups.com
> Subject: [Distribution_Inventory_Control] inventory control
>
> Hello everyone, this is my first post but I am in need of some
> guidance. I am having a lot of trouble getting good inventory
numbers
> to the front. I believe alot of this is due to work in progress,
> however my physical counts never fit the computer's count. Has
anyone
> out there run into this problem, and how did you overcome it? Any
> questions or suggestions would be appreciated.
>

I think it is obvious that my current system is less than ideal.  We
have spreadsheets and yield reports but all has fallen short of the
glory of accuracy.  I suppose the first thing to do is to identify
whether I have a dominatly manual system or electronic system that
would benefit more from scanners; then head in that direction.  Thank
you very much for the reply.

--- In Distribution_Inventory_Control@yahoogroups.com, "Butcher, Mark
(GE Indust, ConsInd, consultant)" <mark.butcher@...> wrote:
>
> I would have to say that would depend on the operation that you
have. In a traditional warehouse environment you have receiving, put-
away, replenishment, and order fulfillment processes. You want the
ability to track product at each of these stages. If you have a
Warehouse Management System that drives these functions then barcodes
are the best option. This allows for tracking of each item throughout
the process and you can identify where the product is at any point.
However, if you have a manual system in place, then of course this
would not work and you would need to adapt a system that would have a
paper trail for each process. Any way it goes, the principle is the
same when it comes to counting. You have to have a way to account for
product that is "in progress" and you need to verify that it is
correct in addition to counting the storage and pick locations.
>
> Mark Butcher
> Inventory Control Manager
> Baltimore ADC
> 238 Belvidere Rd
> Perryville, MD, 21903
> Phone: 410-996-2616
> Fax: 410-996-2634
> mark.butcher@...
>
>
> -----Original Message-----
> From: Distribution_Inventory_Control@yahoogroups.com
[mailto:Distribution_Inventory_Control@yahoogroups.com]On Behalf Of
jonah_the_mighty
> Sent: Tuesday, September 11, 2007 9:00 AM
> To: Distribution_Inventory_Control@yahoogroups.com
> Subject: [Distribution_Inventory_Control] Re: inventory control
>
> Thank you for the response. I spent some time on inventoryops.com
so
> I know what you mean by cycle counting, but to track at each
> movement; does that mean simply more forms to sign or barcoding? If
> we go barcoding what are the pitfalls there?
>
> --- In Distribution_ <mailto:Distribution_Inventory_Control%
40yahoogroups.com> Inventory_Control@yahoogroups.com, "Butcher, Mark
> (GE Indust, ConsInd, consultant)" <mark.butcher@> wrote:
> >
> > I would say that you have two options. First, would be to cycle
> count during periods when the operations team is not performing any
> functions (replenishment, order selection, receiving). If this is
not
> an option, then you will need to be able to identify and verify
> product at each stage of movement.
> >
> > Mark Butcher
> > Inventory Control Manager
> > Baltimore ADC
> > 238 Belvidere Rd
> > Perryville, MD, 21903
> > Phone: 410-996-2616
> > Fax: 410-996-2634
> > mark.butcher@
> >
> >
> > -----Original Message-----
> > From: Distribution_ <mailto:Distribution_Inventory_Control%
40yahoogroups.com> Inventory_Control@yahoogroups.com
> [mailto: Distribution_ <mailto:Distribution_Inventory_Control%
40yahoogroups.com> Inventory_Control@yahoogroups.com]On Behalf Of
> jonah_the_mighty
> > Sent: Monday, September 10, 2007 5:41 PM
> > To: Distribution_ <mailto:Distribution_Inventory_Control%
40yahoogroups.com> Inventory_Control@yahoogroups.com
> > Subject: [Distribution_Inventory_Control] inventory control
> >
> > Hello everyone, this is my first post but I am in need of some
> > guidance. I am having a lot of trouble getting good inventory
> numbers
> > to the front. I believe alot of this is due to work in progress,
> > however my physical counts never fit the computer's count. Has
> anyone
> > out there run into this problem, and how did you overcome it? Any
> > questions or suggestions would be appreciated.
> >
>