schmidtd1989
New member
- Joined
- Sep 27, 2018
- Messages
- 1
Hello, new to the forum, I am sick of beating my head against a wall and I am looking for some help. It may be a shot in the dark and there may not be a way to solve my problem but I figured I would take the shot.
I need to determine how many returnable containers I need to ship a product. To determine this I need to know on average how many turns per year my pool of containers make.
All I know is the average amount of months by percentage that it takes to get containers back from customers. For example, 6% of containers shipped are returned in the same month in which they are shipped (month 1), 23% are returned the month after (month 2), 29% are returned month 3, 16% will be returned in month 4, 7% in month 5, 5% in month 6, 3% in month 7, 2% in month 8, 1% in month 9, 1% in month 10, 1% in month 11, and 1% in month 12. A total of 5% of what we ship is not returned.
So for example, what I want to know is if we ship 12,000 units per year, (1,000 per month average) how many containers do I need if I get return rates consistant with the percentages in the previous paragraph. Say if the data above told me I average 3 turns per year I would know I need 4,000 containers.
I have ran this out in an excel table with a lengthy formula but I want to be able to simplify this so I can quickly figure out how many containers I need for new programs that I need to budget for.
Like I said, I am not sure there is a way to get what I want but I would be greatly appreciative to anyone that can solve this riddle!
I need to determine how many returnable containers I need to ship a product. To determine this I need to know on average how many turns per year my pool of containers make.
All I know is the average amount of months by percentage that it takes to get containers back from customers. For example, 6% of containers shipped are returned in the same month in which they are shipped (month 1), 23% are returned the month after (month 2), 29% are returned month 3, 16% will be returned in month 4, 7% in month 5, 5% in month 6, 3% in month 7, 2% in month 8, 1% in month 9, 1% in month 10, 1% in month 11, and 1% in month 12. A total of 5% of what we ship is not returned.
So for example, what I want to know is if we ship 12,000 units per year, (1,000 per month average) how many containers do I need if I get return rates consistant with the percentages in the previous paragraph. Say if the data above told me I average 3 turns per year I would know I need 4,000 containers.
I have ran this out in an excel table with a lengthy formula but I want to be able to simplify this so I can quickly figure out how many containers I need for new programs that I need to budget for.
Like I said, I am not sure there is a way to get what I want but I would be greatly appreciative to anyone that can solve this riddle!