Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

CPA Exam Review 2020 At Least Know This Auditing And Attestation

Authors: At Least Know This

1st Edition

1706038364, 978-1706038368

More Books

Students also viewed these Accounting questions