1. Melissa is the buyer for the mens shoe department at Neiman Marcus. She is finalizing the details for the spring season, and needs to complete the Merchandising Plan, using the below data: Total sales for last year (LY) were $4,575. If sales are planned to increase 6% vs. LY, what is the total plan for the season? Use the sales curve in the chart for LY and calculate the LY sales by month.If sales were planned with the increases in the below chart, what would the sales plan be for each month for TY?What percent of the total season would each months plan represent?If actual sales were as follows, calculate the % change vs. plan for each month and the total season.February $ 600 May $ 882March $1,000 June $1,111April $ 900 July $ 666 Given the stock-sales ratios for LY and plan in the below chart, calculate the BOM stock by month. Calculate EOM for LY and plan.

   		Planned Sales	TY Actual	LY Stock-Sales	Planned	% of Plan
   	LY Sales Curve (b)	Increase vs. LY (c)	Sales (e)	Ratio (f)	Stock-Sales Ratio	Markdowns	LY MD's
   February	12%	6%	$ 600	2.26	2.25	19.00%	$ 40
   March	22%	5%	$ 1,000	2.33	2.30	20.00%	$ 52
   April	17%	6%	$ 900	2.66	2.65	22.00%	$ 40
   May	16%	9%	$ 882	2.12	2.10	17.00%	$ 40
   June	19%	4%	$ 1,111	2.02	2.00	10.00%	$ 50
   July	14%	7%	$ 666	2.17	2.15	12.00%	$ 53
   Total	100%		$ 5,159				$ 275

Calculate average stock for LY and Plan Calculate season turnover for LY and PlanCalculate planned markdowns, given total markdowns for the season are $250Calculate % markdowns for LY and Plan (top grid), and the percentage each month represents of the total (main grid)Calculate initial markup for LY and Plan, given the following information:

LY Plan

Operating Expense 35.00% 35.00%

Net Profit 8.55% 10.00%

Alteration Expense 0.00% 0.00%

Cash Discounts 5.00% 5.00%

Calculate Gross Margin % for LY and Plan, Calculate GRMOI for LY and Plan, Calculate LY purchases at retail, Calculate planned purchases as retail, Calculate LY purchases at cost,Calculate planned purchases as cost