If the Open to buy for each month is : February: $30,400.00 March: $31,250.00 Ap
ID: 2727784 • 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
Answer
Month
Planned sales
Sales on order
Mark down
Mark down % for each month
(Answer 3)
A
B
B/A
February
300000
125000
8000
2.67%
March
200000
30000
12000
6.00%
April
300000
150000
4000
1.33%
May
200000
100000
3000
1.50%
June
400000
150000
18000
4.50%
July
200000
30000
25000
12.50%
Total
C
16,00,000
5,85,000
Number of months
D
6
6
Average figures
C/D
266666.67
97500
(Answer 1)
(Answer 2)
Month
Planned sales
Sales on order
Mark down
Mark down % for each month
(Answer 3)
A
B
B/A
February
300000
125000
8000
2.67%
March
200000
30000
12000
6.00%
April
300000
150000
4000
1.33%
May
200000
100000
3000
1.50%
June
400000
150000
18000
4.50%
July
200000
30000
25000
12.50%
Total
C
16,00,000
5,85,000
Number of months
D
6
6
Average figures
C/D
266666.67
97500
(Answer 1)
(Answer 2)
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.