6. Melissa is the buyer for the men's 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: a. 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? b. Use the sales curve in the chart for LY and calculate the LY sales by month. c. If sales were planned with the increases in the below chart, what would the sales plan be for each month for TY? d. What percent of the total season would each month's plan represent? e. If actual sales were as follows, calculate the % change vs. plan for each month and the total season. February $ 600 May $ 882 March $1,000 June $1,111 April $ 900 July $ 666 f. 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. am Add Page Insert Table Chart Text Shape Media Commes Planned Sales TY Actual LY Stock- Sales Planned % of Plan LY Sales Increase vs. Stock-Sales Markdow Curve (b) LY (c) Sales (e) Ratio (f) Ratio ns LY MD's Februar $ Y 12% 6% $ 600 2.26 2.25 19.00% 40 March 22% 5% $ 1,000 2.33 2.30 20.00% 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% July 14% 7% $ 666 2.17 2.15 12.00% ~ ~ ~ ~ ~ ~ $ 52 50 Total 100% $ 5,159 275 g. Calculate average stock for LY and Plan: h. Calculate season turnover for LY and Plan i. Calculate planned markdowns, given total markdowns for the season are $250 j. Calculate % markdowns for LY and Plan (top grid), and the percentage each month represents of the total (main grid) k. Calculate initial markup for LY and Plan, given the following information: Operating Expense Net Profit Alteration Expense Cash Discounts LY 35.00% 8.55% 0.00% 5.00% 1. Calculate Gross Margin % for LY and Plan m. Calculate GRMOI for LY and Plan n. Calculate LY purchases at retail o. Calculate planned purchases as retail p. Calculate LY purchases at cost q. Calculate planned purchases as cost KA stv Plan 35.00% 10.00% 0.00% 5.00%