Fill in all question marked areas of the grid and write the formula for each value together.

Open-To-Buy Worksheet
	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