Prepare a six-month merchandise plan based on the information presented below. Planned sales are expected to be the same as last year. February March April May June July

Last Year Monthly Sales $12,000 $14,000 $18.000 $19.000 $18.000 $19.000 Last Year BOM Stock $25,000 $30,000 $38.000 $40.000 $39.000 $41.000 Calculate last year's monthly stock-to-sales ratios and plan monthly BOM inventory levels. b. Now, plan monthly reductions for the period. Reductions are planned at 8% and will be distributed as follows: February March April Mav June Julv 10% 5% 5% 15% 30% 35% C. Next, plan monthly EOM stock for each month. Ending inventory for the season is planned at $43,000. d. Now, plan purchases at retail. Then, convert this figure to cost. The initial markup percentage is planned at 46.4 percent.