Question

You have four skus for storage in a forward piece pick area for small parts. (Picks are given in person minutes and flows have been scaled as a fraction of the volume available in the forward pick area) Assume that savings per pick from the forward pick area is 1 person minute and a restock average 3 person minutes

SKU PICKS FLOW A 80 12.0 B 90 7.9 C 75 6.0 D 85 7.0

a. Rank the skus in order of priority for storage in the forward pick area

b. If all four skus were stored in the forward pick area, which would be allocated the least space

Answer 1

Denominator	36.3109
SKU	fi	ui
A	80	2.203195
B	90	2.478594
C	75	2.065495
D	85	2.340895

Denominator	=SQRT(F6)+SQRT(F7)+SQRT(F8)+SQRT(F9)
SKU	fi	ui
A	80	=F6/$F$3
B	90	=F7/$F$3
C	75	=F8/$F$3
D	85	=F9/$F$3

b)

Hence C has the least allocated space.