I encountered a problem related to merchandise allocation. We are given the present available quantity of an item and its demand for every store. Quantity to be allocated is also given. The requirement is to allocate units in such a way that the "final available quantity-Demand%" is the same for maximum number of stores.(adsbygoogle = window.adsbygoogle || []).push({});

I initially found with great ease a formula for the final percentage.

Final Quantity-Demand% = (Quantity to be allocated+sum of existing quantities from all stores)/(sum of demands for all stores)

But when i tried different sets of data, i found to my utter dismay that in the process of making all the quantity-Demand% same, the formula is removing existing units from some of the stores which shouldn't be done.

Is there a logic that can make this simple? Please refer the template excel sheet below, that could make the problem still simpler if you haven't got a clear idea yet.

See the attached sheet--> View attachment problem.xls

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Equalising Final available quantity-demand percentage for all stores

Loading...

Similar Threads - Equalising Final available | Date |
---|---|

Discrete math study strategy - Tips and advice! | Dec 13, 2014 |

Probability of dealing the final blow | Dec 15, 2012 |

The probability of an electric car charging station being available | Jun 27, 2012 |

Maximum final component of a simple symmetric multidimensional random walk? | Apr 3, 2012 |

The Final Solution of the Liar Paradox | Jul 2, 2011 |

**Physics Forums - The Fusion of Science and Community**