please help me fill this out i dont know what im doing

do not worry about the buyer or anything

1. Prepare a six-month merchandise plan based on the information below. PHOSIS are expected to be the same as last year. Month LY Sales February March April May June July TIT LYBOM Stock % of Season's Markdowns $25,000 10% $30,000 5% $38,000 5% $40,000 15% $39,000 30% $41,000 35% $12,000 $14,000 $18,000 $19,000 $18.000 $19,000 a. Calculate last year's monthly Stock-Sales ratios to plan BOM for this year. Planned EOM for the season is $43,000. b. Plan monthly reductions for the period. Seasonal reductions are planned at 8% and distributed as above Plan purchases at retail. What would the season purchase at retail be? The initial markup % 8 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 19. 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 August September October November December January of Season's Sales 15.5 175 19.0 180 15.5 of Season's Markdowns 15 12 19 16 18 20 145 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 SEX MONTHI MERCHANDISE PLAN Department Name: Last Year Plan Actual Department Number Merchandise Manager SALES CMUN MDN GMN 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 xChange XoflY Sales Nof PL Sales LY Ratio PL Ratio LY BOM Stock PL BOM Stock Revid Actual LY Markdowns PL Markdowns X to sales Xto month Revised Actual LY Purchases Retail PL Purchases Retail Revived Actual Markdowns Purchases Retail 1. Prepare a six-month merchandise plan based on the information below. PHOSIS are expected to be the same as last year. Month LY Sales February March April May June July TIT LYBOM Stock % of Season's Markdowns $25,000 10% $30,000 5% $38,000 5% $40,000 15% $39,000 30% $41,000 35% $12,000 $14,000 $18,000 $19,000 $18.000 $19,000 a. Calculate last year's monthly Stock-Sales ratios to plan BOM for this year. Planned EOM for the season is $43,000. b. Plan monthly reductions for the period. Seasonal reductions are planned at 8% and distributed as above Plan purchases at retail. What would the season purchase at retail be? The initial markup % 8 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 19. 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 August September October November December January of Season's Sales 15.5 175 19.0 180 15.5 of Season's Markdowns 15 12 19 16 18 20 145 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 SEX MONTHI MERCHANDISE PLAN Department Name: Last Year Plan Actual Department Number Merchandise Manager SALES CMUN MDN GMN 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 xChange XoflY Sales Nof PL Sales LY Ratio PL Ratio LY BOM Stock PL BOM Stock Revid Actual LY Markdowns PL Markdowns X to sales Xto month Revised Actual LY Purchases Retail PL Purchases Retail Revived Actual Markdowns Purchases Retail