Equalising Final available quantity-demand percentage for all stores

  • Context: Undergrad 
  • Thread starter Thread starter sganesh88
  • Start date Start date
  • Tags Tags
    Final
Click For Summary
SUMMARY

The discussion focuses on the challenge of equalizing the final available quantity-demand percentage across multiple stores during merchandise allocation. The formula presented for calculating the final percentage is: Final Quantity-Demand% = (Quantity to be allocated + sum of existing quantities from all stores) / (sum of demands for all stores). However, the user encountered issues where applying this formula resulted in the unintended removal of existing stock from certain stores. The need for a more effective logic or method to achieve uniformity in quantity-demand percentages without depleting existing stock is emphasized.

PREREQUISITES
  • Understanding of merchandise allocation strategies
  • Familiarity with percentage calculations in inventory management
  • Basic proficiency in Excel for data manipulation
  • Knowledge of demand forecasting techniques
NEXT STEPS
  • Research methods for equitable inventory distribution across multiple locations
  • Learn advanced Excel functions for optimizing allocation formulas
  • Explore algorithms for solving allocation problems in supply chain management
  • Investigate demand planning software solutions for better inventory management
USEFUL FOR

Retail managers, supply chain analysts, and inventory planners seeking to optimize merchandise allocation and improve inventory performance across multiple store locations.

sganesh88
Messages
286
Reaction score
0
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.

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 news on Phys.org
can someone give it a thought please? I am breaking my head on this! :)
 

Similar threads

Model Pulley: Understanding System Physics
  • · Replies 27 ·
Replies
27
Views
11K
Requesting suggestions for languages, libraries, and architectures for parallel (and sometimes non parallel) numerical and scientific computations
  • · Replies 8 ·
Replies
8
Views
4K
Undergrad What does Purcell actually say about electromagnetism and relativity?
  • · Replies 32 ·
2
Replies
32
Views
7K
How to creaate a priority queue using print queue
  • · Replies 6 ·
Replies
6
Views
4K
Graduate BRS: PKI Cryptosystems for SA/Ms: A Tutorial
  • · Replies 13 ·
Replies
13
Views
4K
Graduate Strange Spam Email (The Limitation of the Photon Hypothesis)
  • · Replies 2 ·
Replies
2
Views
2K
Surface roughness in 2D sinusoidal corrugation
  • · Replies 1 ·
Replies
1
Views
5K
News Should the US intervene in world problems?
  • · Replies 29 ·
Replies
29
Views
11K
Graduate Hidden Momentum: Loop Precession Torque
  • · Replies 1 ·
Replies
1
Views
2K
Mathematica This Week's Finds in Mathematical Physics (Week 262)
  • · Replies 4 ·
Replies
4
Views
4K