Inventory Management for my business

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:

Want to reply to this thread?

"Inventory Management for my business" You must log in or register to reply here.

Related Threads for: Inventory Management for my business

  • Posted
Replies
1
Views
2K
Replies
19
Views
3K
  • Posted
Replies
16
Views
904
  • Posted
2
Replies
30
Views
2K

Physics Forums Values

We Value Quality
• Topics based on mainstream science
• Proper English grammar and spelling
We Value Civility
• Positive and compassionate attitudes
• Patience while debating
We Value Productivity
• Disciplined to remain on-topic
• Recognition of own weaknesses
• Solo and co-op problem solving
Top