Fill in all grey shaded areas of the grid and let me know the formula for each value.

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