Dear all,

I made a inventory simulation with (Q,r), (S,s) ordering system using Matlab
Simulink software. I need real data from industry such as apparel industry,
supermarket, etc. I need real data for inventory cost related (ordering cost,
holding cost) and also demand data. The data will be used in the simulation. I
have tried with assumption data but in this case I need real data from industry.

Any body can help me with the data ?

I have been in warehousing and transportation for 25 years and now wish to
advance by continuing my education. What courses could you recommend I take. I
have been reading several books that I saw on inventoryops.com(a very
informative site by the way)and gained some insight into the management of
warehouses, but feel secondary education is required to gain full knowledge.
Some of this is a little beyond my current level of understanding.

I am seeking an experienced Inventory and Materials Control Manager for a
manufacturing firm in the greater Chicago area.  The individual should have a
solid background in inventory management.  A CPIM is desirable.  If you are
interested please contact me for further details.  This is a confidential search
for this employer.

Hello Everyone - I am looking for someone with experience with one of the
following inventory control systems: Stone Edge, Fishbowl Inventory or
Interprise to make an assessment & recommendation and stay on for the
implementation. If anyone is interested please contact me.

- Greg McDanel
630 401 0594
gregory.mcdanel@...

Wouldn't recommend starting from scratch.
Look into a system like Syteline...
http://go.infor.com/erpsytelinedemo/

If you decide to develop one on your own, whatever you do, don't use Microsoft
Excel.

--- In Distribution_Inventory_Control@yahoogroups.com, "andrewwongyen"
<andrewwongyen@...> wrote:
>
> Hi I have been commissioned to scope an Inventroy Control System for
> the company I work for.
>
> We are a small to medium company (30 employees) on a rapid growth
> path. We supply a combined hardware and web service solution to the
> transport sector and track perishable foods through the supply cool
> chain using our own RF solutions for safety, tracking and quality
> assurance applications.
>
> We manufacture our own hardware and develop software in-house and I
> have been given a project to scope and assess the purchase or
> development of a system to help us manage and track inventory. We
> require the ability to:
>
> 1.       Order and track components for our end products
>
> 2.       Manage and track manufacture of our products (hardware- 3rd
> Party company that work for us 80% of their time)
>
> 3.       Manage and track finished product and maintain accurate
> inventory, re-order levels etc
>
> 4.       Manage units in the field as far as which customer has which
> units, for how long (warranty), which Data SIM card is in each unit
> etc
>
> 5.       Create std business docs – PO. Invoices, Sales Orders, BOMs
> etc
>
> 6.       Create monthly reports
>
> 7.       Web based or Intranet – we are a Microsoft Accredited partner
>
> 8.       Currently use MYOB for financials
>
>
>
> We are not a large company with offices opening outside of Australia
> (USA and NZ at the moment) and our market share growing we need a
> system to make sure we grow on an efficient base, we currently have
> all of our work flow and processes documented and now need a system
> to make sure we can manage our growth stage efficiently and
> accurately and manage costs.
>
>
>
> Can anyone offer some advice on how we should best approach this
> requirement – is there off the shelf products that get us most of the
> way there or do we need to develop from scratch?
>
>
>
> Thank You any advice would be greatly appreciated
>

True. The uses of this figure are pretty limited, I only use it when trying to
capture some extra "soft" cost savings with continuous improvement projects. 
Helps with figuring out how well the facility's space is being utilized from a
cost standpoint.

--- In Distribution_Inventory_Control@yahoogroups.com, "Dave Piasecki"
<dave@...> wrote:
>
> I would just add that you first need to know how you expect to use your
> "cost of storing a pallet". There are costs that may or may not apply
> depending upon the use. For example, if you are purely looking at the
> storage costs, you will find that most warehouses have a significant amount
> of space that is used for "processing" and not storage. You would not want
> to include the costs associated with this space in your calculation.
>
>
>
>              Dave Piasecki
>  <http://www.inventoryops.com/>
>
> From: Distribution_Inventory_Control@yahoogroups.com
> [mailto:Distribution_Inventory_Control@yahoogroups.com] On Behalf Of
> code3nine
> Sent: Tuesday, March 17, 2009 4:38 PM
> To: Distribution_Inventory_Control@yahoogroups.com
> Subject: [Distribution_Inventory_Control] Re: Can someone tell me the proof
> of Square Root Law?
>
>
>
> May not be a 100% perfect method, but a start:
>
> 1. Measure and get the total cu. ft. worth of space your warehouse occupies
> within your facility, divide this by the total cu. ft. of the entire
> facility. Result gives you a percentage you can use to represent how much
> space within the facility is dedicated to it's warehouse.
> 2. Count, and figure out the maximum number of "full skid" sized locations
> your warehouse contains. If you have different size locations throughout
> your warehouse, use weighted counts (example: when counting, the largest
> locations are worth 1, medium locations 0.5, small locations 0.25). Result
> is an approx. location count.
> 3. Determine the monthly cost to operate the facility (lease, utilities,
> insurance, taxes. If you want to capture material handling labor cost within
> this figure, add the monthly labor cost in with this also.). Multiply this
> total cost by the percentage you came up with in step 1. Result is an
> approx. monthly cost of your warehouse.
> 4. Take the monthly warehouse cost, divide by the number of counted
> locations, gives you a cost-per-location-per-month figure.
>
> Optional: divide the total cu. ft. from step 1 by the location count from
> step 2, gives you the crude number of cu. ft. per location.
>
> -c39
>
> --- In Distribution_Inventory_Control@yahoogroups.com
> <mailto:Distribution_Inventory_Control%40yahoogroups.com> , Basem Shahhal
> <b_shahhal@> wrote:
> >
> > Hi,
> > i am looking for a method to calculate the cost of storing a pallet in the
> DC. How can that be linked to the stock holding cost? please assist. thank
> you
>

May not be a 100% perfect method, but a start:

1. Measure and get the total cu. ft. worth of space your warehouse occupies
within your facility, divide this by the total cu. ft. of the entire facility.
Result gives you a percentage you can use to represent how much space within the
facility is dedicated to it's warehouse.
2. Count, and figure out the maximum number of "full skid" sized locations your
warehouse contains.  If you have different size locations throughout your
warehouse, use weighted counts (example: when counting, the largest locations
are worth 1, medium locations 0.5, small locations 0.25). Result is an approx.
location count.
3. Determine the monthly cost to operate the facility (lease, utilities,
insurance, taxes. If you want to capture material handling labor cost within
this figure, add the monthly labor cost in with this also.). Multiply this total
cost by the percentage you came up with in step 1.  Result is an approx. monthly
cost of your warehouse.
4. Take the monthly warehouse cost, divide by the number of counted locations,
gives you a cost-per-location-per-month figure.

Optional: divide the total cu. ft. from step 1 by the location count from step
2, gives you the crude number of cu. ft. per location.

-c39

--- In Distribution_Inventory_Control@yahoogroups.com, Basem Shahhal
<b_shahhal@...> wrote:
>
> Hi,
> i am looking for a method to calculate the cost of storing a pallet in the DC.
How can that be linked to the stock holding cost? please assist. thank you

Thank-you so much for providing me the info!

I could find the proof in David Maister's article "Centralization of Inventories
and the Square Root Law". If interested, I can mail it to you.

Thanks,
Prem


--- On Fri, 3/6/09, Dave Piasecki <dave@...> wrote:

> From: Dave Piasecki <dave@...>
> Subject: RE: [Distribution_Inventory_Control] Can someone tell me the proof of
Square Root Law?
> To: Distribution_Inventory_Control@yahoogroups.com
> Date: Friday, March 6, 2009, 11:28 AM
> I would just add that the term "square root law"
> is very misleading.
> Applying the square root to a ratio is used sometimes in
> statistics when you
> want to "soften" a ratio (often to reflect the
> law of large numbers). In the
> case of a distribution network, it can generally be assumed
> that if you
> expand from say 1 location to 4 locations, your inventory
> will increase but
> it will not be 4 times as much. Therefore we could try to
> take the square
> root of our ratio (4/1) to soften it (giving us a result of
> 2/1).
>
> Applying the square root to determine changes in inventory
> levels in a
> distribution network is often referred to as a "rule
> of thumb" but I think
> that too is a little too strong a term for this very rough
> means of
> estimating inventory levels. You would be far better off
> looking at the
> ordering policies you will use in these facilities, and
> using that as the
> basis of "simulating" what your inventory levels
> might be.
>
>
>
>              Dave Piasecki
>  <http://www.inventoryops.com/>
>
> From: Distribution_Inventory_Control@yahoogroups.com
> [mailto:Distribution_Inventory_Control@yahoogroups.com] On
> Behalf Of
> ultimate32123
> Sent: Wednesday, March 04, 2009 1:25 PM
> To: Distribution_Inventory_Control@yahoogroups.com
> Subject: [Distribution_Inventory_Control] Can someone tell
> me the proof of
> Square Root Law?
>
>
>
> The law is related to Inventory at multiple locations.
>
> Inventory at Multiple Locations - TheSquare Root Law
> . X2= (X1) * &#8730;(n2/n1)
> . Where:
> o n1 = number of existing facilities
> o n2 = number of future facilities
> o X1 = total inventory in existing facilities
> o X2 = total inventory in future facilities
>
> Thanks!!

The law is related to Inventory at multiple locations.

Inventory at Multiple Locations – TheSquare Root Law
• X2= (X1) * √(n2/n1)
• Where:
o n1 = number of existing facilities
o n2 = number of future facilities
o X1 =  total inventory in existing facilities
o X2 = total inventory in future facilities

Thanks!!

-----Original Message-----
From: Distribution_Inventory_Control@yahoogroups.com [mailto:Distribution_Inventory_Control@yahoogroups.com]On Behalf Of andrewwongyen
Sent: Monday, February 23, 2009 10:54 PM
To: Distribution_Inventory_Control@yahoogroups.com
Subject: [Distribution_Inventory_Control] Project to scope Inventroy Control System

Hi I have been commissioned to scope an Inventroy Control System for
the company I work for.

We are a small to medium company (30 employees) on a rapid growth
path. We supply a combined hardware and web service solution to the
transport sector and track perishable foods through the supply cool
chain using our own RF solutions for safety, tracking and quality
assurance applications.

We manufacture our own hardware and develop software in-house and I
have been given a project to scope and assess the purchase or
development of a system to help us manage and track inventory. We
require the ability to:

1. Order and track components for our end products

2. Manage and track manufacture of our products (hardware- 3rd
Party company that work for us 80% of their time)

3. Manage and track finished product and maintain accurate
inventory, re-order levels etc

4. Manage units in the field as far as which customer has which
units, for how long (warranty), which Data SIM card is in each unit
etc

5. Create std business docs – PO. Invoices, Sales Orders, BOMs
etc

6. Create monthly reports

7. Web based or Intranet – we are a Microsoft Accredited partner

8. Currently use MYOB for financials

We are not a large company with offices opening outside of Australia
(USA and NZ at the moment) and our market share growing we need a
system to make sure we grow on an efficient base, we currently have
all of our work flow and processes documented and now need a system
to make sure we can manage our growth stage efficiently and
accurately and manage costs.

Can anyone offer some advice on how we should best approach this
requirement – is there off the shelf products that get us most of the
way there or do we need to develop from scratch?

Thank You any advice would be greatly appreciated

Hi I have been commissioned to scope an Inventroy Control System for
the company I work for.

We are a small to medium company (30 employees) on a rapid growth
path. We supply a combined hardware and web service solution to the
transport sector and track perishable foods through the supply cool
chain using our own RF solutions for safety, tracking and quality
assurance applications.

We manufacture our own hardware and develop software in-house and I
have been given a project to scope and assess the purchase or
development of a system to help us manage and track inventory. We
require the ability to:

1.       Order and track components for our end products

2.       Manage and track manufacture of our products (hardware- 3rd
Party company that work for us 80% of their time)

3.       Manage and track finished product and maintain accurate
inventory, re-order levels etc

4.       Manage units in the field as far as which customer has which
units, for how long (warranty), which Data SIM card is in each unit
etc

5.       Create std business docs – PO. Invoices, Sales Orders, BOMs
etc

6.       Create monthly reports

7.       Web based or Intranet – we are a Microsoft Accredited partner

8.       Currently use MYOB for financials



We are not a large company with offices opening outside of Australia
(USA and NZ at the moment) and our market share growing we need a
system to make sure we grow on an efficient base, we currently have
all of our work flow and processes documented and now need a system
to make sure we can manage our growth stage efficiently and
accurately and manage costs.



Can anyone offer some advice on how we should best approach this
requirement – is there off the shelf products that get us most of the
way there or do we need to develop from scratch?



Thank You any advice would be greatly appreciated

Anybody familiar with this site, especially the book written by the
site's owner - "Inventory Acc_racy:...."? Wondering if it's worth the
money.

Thanks.

I've got an assignment from my boss, asking to benchmark our department
with others in our entertainment restaurant industry. I came up with
some questions for this, if possible please include name, title, and
company.

1) What inventory system are you using?
2) How you have a bar-coding system? If so, when was it implemented?
3) How time consuming was it?
4) Comparing before and after bar-coding, what are the major
differences?
5) What types of reports do you use for maximinzing your warehouse
space?
6) How type of racks or storage system do you use for the warehouse?

Much appreicated,

Hung