Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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-buyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started