Share
ReportI have a situation where we have 3 different flavors of soft drinks that can be sold as a single unit, a 6 pack, or a case (4-6 packs.) To add to that a case can be a mixture of the 3 different flavors(2-6 packs of one flavor 2 of another, 2 of 1 and 1 each of the other 2 flavors, etc. etc.) Prices for the single unit, 6 pack, and case all are different on a per unit(individual bottle) price.
The inventory is ordered from the vendor in 6 packs only. For each flavor the single unit and the six pack have their own upc code. Cases do not have their own upc code(there is a case upc but it is universal and doesn't differentiate what flavor it is for.) For this reason I am considering eliminating the upc code for the case from our system.
For the 6 pack to case I was thinking of setting it up as a mix and match discount when a total of 4 6packs are purchased. This would allow for the price difference as well as keeping the inventory counts for each correct. This is the best solution that I can see for this part of the problem.
The part I cannot figure out(and I'm probably over analyzing it) is keeping up with the bottles vs 6 packs. Any ideas? I've looked at assembly, kitting, parent/child, and lot matrix.
*This post is locked for comments
All responses (
Answers (
13,380
