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. tv TA MacBook Pro 128 Zoom All Page Insert Table Chart Text Shape Media Comment Planned LY Stock- Sales TY Actual Sales Planned % of Plan LY Sales Curve (b) Increase vs. Stock-Sales Markdow LY LY (c) Sales (o) Ratio (f) Ratio Ins 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% 3455 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 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 tv Plan 35.00% 10.00% 0.00% 5.00% B SIX-MONTH MERCHANDISING PLAN Department Name: Men's Shoes Department Number: 435 Merchandise Manager: Buyer Period: Spring % initial markup (k) % markdowns () % alteration expense (k) % cash discount (k) % gross margin (1) % operating expense (K) % net profit (k) season turnover (h) average stock (g) GMROI (m) SALES FALL LY Sales (b) PL Sales (c) Revised Actual (e) % Change (ACT vs PLN) (e) % of LY Sales (b) % of PL Sales (d) EOM STOCK LY EOM Stock (f) MARKDOWNS PL EOM Stock (1) Revised Actual LY Markdowns PL Markdowns (1) Revised Actual % Change % of LY Markdowns () % of PL. Markdowns () BOM STOCK LY BOM Stock (f) PL BOM Stock (f) PLANNED PURCHASES AT RETAIL PLANNED PURCHASES AT COST Revised Actual LY Stock/Sales Ratio (f) PL Stock/Sales Ratio (f) LY Purchases @ Retail (n)) PL Purchases Retail (o) Revised Actual LY Purchases @Cost (p) PL Purchases Cost (q) Revised Actual Last Year Plan Actual SEASON February March April May June July TOTALS