You will have $1,430,000 (Retail) to spend to stock your store. (Use an excel worksheet to show your work)

Using the figures provided you will calculate the following for the XYZ store.

Open to buy for each month

Average monthly sales

Average monthly on order

Markdown % for each month

	Planned sales	On Order	Employee	Mark Down $	Shortages	EOM Stock	DOM Stock
Feb.	$300,000	$125,000	2%	$8,000	2%	$200,000	$160,000
Mar.	$200,000	$30,000	3%	$12,000	4%	$80,000	$40,000
Apr.	$300,000	$150,000	4%	$4,000	5%	$110,000	$90,000
May	$200,000	$100,000	0%	$3,000	7%	$90,000	$60,000
June	$400,000	$150,000	5%	$18,000	2%	$210,000	$150,000
July	$200,000	$30,000	7%	$25,000	3%	$70,000	$30,000