Please fill in all grey shaded areas of the grid and let me know the formula for each area.

Open-To-Buy Worksheet
Fill in all grey shaded areas of the grid
	BOM	Plan Sales	Sales % to total	Markdown $	Md %	OTB	Stock-To-Sales
February	35,000	$9,000	11.5%	$1,000			3.88
March	41,000	$15,000	19.2%	$2,000	13.3%	20,000
April	44,000	$18,000	23.1%	$2,000
May	41,000	$15,000			10.0%		2.73
June	38,000		15.4%	$3,000		12,000
July		$9,000		$2,500			3.89
EOM July	39,000
Total Spring		$78,000
Average Stock=
Turn=
Stock-to Sales Ratio = BOM Stock / Sales for the month