Dwell time for warehouse stocks

BOOCLAWSON

New Member
Joined
Aug 16, 2012
Messages
23
Hi - I am trying to work out how I can get an average dwell time for product which comes in intermittently and gets despatched intermittently.

a screenshot of the file is attached.

As you can see, some products come in and then get despatched piece-meal whereby some will come in and hang around for a while.

I need to be able to see average time the product has sat on the shelf - even if I can do this as an average of the weekly differences. This is the current format but it is new so could change but have about 180 products to track for this.

Apologies - also should mention that some of the product could dwell for a couple of weeks and then start moving so would have to be able to identify earliest date even though stock levels unlikely to go down to zero.



Can you help?
mrexcel.PNG
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top