If the Open to buy for each month is : February: $30,400.00 March: $31,250.00 Ap
ID: 2727783 • Letter: I
Question
If the Open to buy for each month is :
February: $30,400.00 March: $31,250.00 April: $127,800.00 May: $162,000.00 June: $377,550.00 July: $127,500.00
Using the figures provided you will calculate the following for the XYZ store.
1. Average monthly sales 2. Average monthly on order 3. Markdown % for each month
*** Planned sales + Planned reductions +Planned EOM Stock = Total monthly needs -BOM Stock =Planned purchases -Merchandise on order =Open to buy (At Retail)***
Planned sales On order Employee Discount MD$ Shortages EOM BOM
Feb. $300,000 $125,000 2% $8,000 2% $200,000 $160,000
Mar. $200,000 $30,000 3% $12,000 4% $80,000 $40,000
Apr. $300,000 $150,000 4% $4,000 5% $110,000 $90,000
May $200,000 $100,000 0% $3,000 7% $90,000 $60,000
June $400,000 $150,000 5% $18,000 2% $210,000 $150,000
July $200,000 $30,000 7% $25,000 3% $70,000 $30,000
Explanation / Answer
1)Average monthly sales=930,400.0 +31,250.0 +127,800.0 +162,000.0 +377,550.0 +127,500.0 )/5
=$142,750
2)Average monthly orders=(300,000.0+200,000.0 +300,000.0 +200,000.0+ 400,000.0 +200,000.0 )/5
=$266,666.7
3)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.