Solver problem to divide cases propotionally

[cliffbooth]

I need a way to distribute inventory in cases as per requirement at stores fron warehouse
Let say there are 3 store a, b and c. a requires 5, b requires 8, c requires 7
So overall req is 20
At warehouse only 15 is available
So how should i divide propotionately. The output requiremtn should be integer only not decimal

 

[BadgerRoad]

Book1
	A	B	C	D	E	F	G
1		Store A	Store B	Store C	Total Needed		Available from Warehouse
2	Needed	5	8	7	20		15
3
4	Filled	3	6	5	14
Sheet1

Cell Formulas
Range	Formula
E2,E4	E2	=SUM(B2:D2)
B4:D4	B4	=INT(B2/$E$2*$G$2)