Question: Please do all 6. Prepare a six-month merchandise plan based on the information presented below. Planned sales are expected to be the same as last
Please do all

6. 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 a. 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 10% March 5% April May 15% June 30% 35% 5% d. Now, plan purchases at retail. Then, convert this figure to cost. The initial markup percentage is planned at 46.4 percent. 7. Planned purchases at cost for the month of February are $21,000. Two purchase orders are outstanding. The first is for $550 and the second is for $2,150. What is the open-to-buy? 8. Planned purchases for the month of March are $27,500. Three purchase orders are outstanding. The first is for $1,100, the second is for $20,000, and the third is for $6,600. What is the open-to-buy? 6. 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 a. 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 10% March 5% April May 15% June 30% 35% 5% d. Now, plan purchases at retail. Then, convert this figure to cost. The initial markup percentage is planned at 46.4 percent. 7. Planned purchases at cost for the month of February are $21,000. Two purchase orders are outstanding. The first is for $550 and the second is for $2,150. What is the open-to-buy? 8. Planned purchases for the month of March are $27,500. Three purchase orders are outstanding. The first is for $1,100, the second is for $20,000, and the third is for $6,600. What is the open-to-buy
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
