pleass help idk what to do

SIX MONTH MERCHANDISE PLAN Department Name: Last Year Plan Actual Department Number: Merchandise Manager: SALES CMU% MD% GM% AVG STOCK TURNOVER Buyer: Period: February March April May June July Season Total Sales Stock Sales Ratio Bom Stock Spring LY Sales PL Sales Revised Actual % Change % of LY Sales of PL Sales LY Ratio PL Ratio LY BOM Stock PL BOM Stock Revised Actual LY Markdowns PL Markdowns % to sales % to month Revised Actual LY Purchases Retail PL Purchase a Retail Revised Actual Markdowns Purchases S Retail 1. Prepare a six-month merchandise plan based on the information below. Planned sales are expected to be the same as last year. 10% Month LY Sales LY BOM Stock % of Season's Markdowns February S12.000 $25,000 March $14,000 $30,000 5% April $18,000 $38.000 5% May $19,000 540,000 15% June $18,000 $39,000 July $19.000 541,000 30% a. Calculate last year's monthly Stock-Sales ratios to plan BOM for this year. Planned EOM for the season is S43,000. b. Plan monthly reductions for the period. Seasonal reductions are planned at 8% and distributed as above. c. Plan purchases at retail. What would the season purchase at retail be? The initial markup % is 46.4%. What would the planned purchases for the season be at cost? 2. Develop a merchandise plan based on information that follows. Sales for the six-month fall/winter season have been planned to total $650,000. Markdowns for the total season are to be 22% of the total planned sales, and season's turnover should be 1.9. BOM inventory values are to be planned by the basic stock method. In this problem, ending inventory will be the same as the average inventory. Month of Season's Sales of Season's Markdowns August 155 15 September 17.5 12 October 19,0 19 November 18,0 16 December ISS 18 January 14.5 20 a. Calculate total markdown dollars for the season and allocate the markdowns for each month on the basis of the percentages given b. Using the basic stock method, calculate BOM inventory values for each month. c. The season's EOM is the average inventory for the season. d. Calculate planned purchases at retail. SIX MONTH MERCHANDISE PLAN Department Name: Last Year Plan Actual Department Number: Merchandise Manager: SALES CMU% MD% GM% AVG STOCK TURNOVER Buyer: Period: February March April May June July Season Total Sales Stock Sales Ratio Bom Stock Spring LY Sales PL Sales Revised Actual % Change % of LY Sales of PL Sales LY Ratio PL Ratio LY BOM Stock PL BOM Stock Revised Actual LY Markdowns PL Markdowns % to sales % to month Revised Actual LY Purchases Retail PL Purchase a Retail Revised Actual Markdowns Purchases S Retail 1. Prepare a six-month merchandise plan based on the information below. Planned sales are expected to be the same as last year. 10% Month LY Sales LY BOM Stock % of Season's Markdowns February S12.000 $25,000 March $14,000 $30,000 5% April $18,000 $38.000 5% May $19,000 540,000 15% June $18,000 $39,000 July $19.000 541,000 30% a. Calculate last year's monthly Stock-Sales ratios to plan BOM for this year. Planned EOM for the season is S43,000. b. Plan monthly reductions for the period. Seasonal reductions are planned at 8% and distributed as above. c. Plan purchases at retail. What would the season purchase at retail be? The initial markup % is 46.4%. What would the planned purchases for the season be at cost? 2. Develop a merchandise plan based on information that follows. Sales for the six-month fall/winter season have been planned to total $650,000. Markdowns for the total season are to be 22% of the total planned sales, and season's turnover should be 1.9. BOM inventory values are to be planned by the basic stock method. In this problem, ending inventory will be the same as the average inventory. Month of Season's Sales of Season's Markdowns August 155 15 September 17.5 12 October 19,0 19 November 18,0 16 December ISS 18 January 14.5 20 a. Calculate total markdown dollars for the season and allocate the markdowns for each month on the basis of the percentages given b. Using the basic stock method, calculate BOM inventory values for each month. c. The season's EOM is the average inventory for the season. d. Calculate planned purchases at retail