Buy allocation size wise
I have a size wise selling contribution and available quantity to buy i.e., 7 and I want to buy these 7 quantity size wise as I was sold in the previous season but my allocation quantity should be exactly the same as available quantity. My allocation quantity is not more than 7 nor less than 7 when I sum it....please help..
Hello rrahul127 and Welcome to Excel Forum.
The values displayed in E2:O2 are not the actual values. If you select cell E2 the value shown in the formula bar is 0.021917808219174%. The same is true for most of the rest of the values in that range. If you were to change those values to what is being displayed, 0%, 8% etc. then the percentages would sum to 101%. Reducing either F2 or J2 from 8% to 7% would reduce the sum of the percentages to 100% and would also reduce the value in Q4 to 7.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hello JeteMc...Thanks for your reply.
I have done the changes, which you were suggested but here I have lots of available quantity to buy.
For now, I have taken example of 5 available option.
Please advise, What should I do for the rest available quantity because in this case excel should bought the 100% quantity in the sizes (according to their selling contribution).
I Believe that the only way that you would get the same value in column Q for any random value that is placed in column B would be to have one size set to 100% and the remaining sizes set to 0%.
If you had two sizes sizes, set to 50%, and the remaining sizes set to 0%, you would only get matching results when even numbers were entered in column B.
If you had three sizes set to 33%, and the remaining sizes set to 0%, the values would match only when a multiple of 3 was entered in column B.
Extending this line of thought it seems reasonable that, given the range of percentages in row 2, only certain values placed in column B are going to yield the same value in column Q.
A bit of experimentation shows that some of those values are 5, 6, 7, 9, 10, 12, 13, 14, 18, 19, 24, 27, 28, 29, 30...
Let us know if you have any questions.
Hi JeteMc....It would be great if you please send me the excel file with examples.
Many Thanks In Advance!
Sheets are a bit out of order however:
Sheet 2 shows one size assigned 100%
Sheet 3 shows two sizes assigned 50% each
Sheet 4 shows three sizes assigned 33% each
Sheet 1 is the original which shows which of the first 30 numbers will work
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks