Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Inventory Management for my business

  1. Mar 26, 2009 #1
    This is actually for my business. I’m not a student. I have no idea if probability can be applied to this or not - just trying to have a tool to better manage my inventory.

    I own a clothing store. We receive inventory in every single day. Each item receives its own unique SKU that is tagged to the clothing. Occasionally there is a glitch (or employee error) and SKUs will be created for items that never existed. I can run a report that will show me which SKUs have not sold and when they were “received” into inventory (I put received in quotes b/c some of the SKUs could be the phantom SKUs). Since I know what date they are theoretically received into inventory I can run another report showing me how many other like items were received into inventory that same week and out of those how many have sold. So, for example, say I run my report and see that there is a T-shirt that was received into inventory on 1/5/2009 that hasn’t sold. I can also see that for the week surrounding that date (1/2/2009 to 1/8/2009) I received a total of 300 T-shirts (299 T-shirts outside of the T-shirt in question) out of which 250 have sold. Is there a probability that the T-shirt in question is a phantom T-shirt? Is it always going to 50/50 because it either is or isn’t? If it is a phantom T-shirt and the rest are real, then eventually for that time frame I’ll have 299 that have sold out of the 300. Would that not narrow down the probability that that T-shirt is phantom and never existed?

    Next, to take it one step further – assuming probability applies to the above – can I a probability be derived for a group of items that my report shows that haven’t sold for a given day. Lets say I show that on that same date I’m showing that not just a T-shirt received on that date hasn’t sold but it’s a pair of jeans and a long sleeve shirt as well. Here is the data (would have put it in a table but cant figure out to make a table in this forum :smile:):

    Item: T-shirt
    Recieved: 1/5/09
    Like Items Received During Same Week: 300
    Like Items that have sold: 250

    Item: Pair of Jeans
    Recieved: 1/5/09
    Like Items Received During Same Week: 500
    Like Items that have sold: 480

    Item: Logn Sleeve Shirt
    Recieved: 1/5/09
    Like Items Received During Same Week: 200
    Like Items that have sold: 100

    Is there a probability that all these items are phantom items as a group?

    Thanks!!!!
     
    Last edited: Mar 26, 2009
  2. jcsd
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Can you offer guidance or do you also need help?
Draft saved Draft deleted



Similar Discussions: Inventory Management for my business
  1. Busy Beaver (Replies: 1)

Loading...