|A||B||C||Week 1||Week 2|
|MFG A||MFG B||MFG C||MFG A||MFG B||MFG C||MFG A||MFG B||MFG C|
Columns A,B and C represent Percentage of Unit Volume by MFG for the Fruits to the left.
Using these numbers, I would like to generate a rotating 13-week promotional schedule for each item. Maximum number of weeks in a row that an MFG can have any one specific item on sale is two weeks. However, at the end of the of the 13-weeks, I'd like the number of instances that, for example, MFG A has Bananas on sale equal or near their share or .6.
My initial thought was you could use a ratio to create a patterned binary list of 1 and 0 or "on" and "off" for each item, but perhaps it is easier with these percentages? Perhaps this is simply a manual task.
Your feedback is appreciated.