If the Open to buy for each month is : February: $30,400.00 March: $31,250.00 Ap
ID: 456845 • 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
Solution :
Planned sales + Planned reductions +Planned EOM Stock = Total monthly needs -BOM
97500 + Planned reductions + 126666.7 = 266666.67 + 88333.33
Planned reductions = 130833.29
Stock =Planned purchases -Merchandise on order =Open to buy (At Retail)
Planned purchases - Merchandise on order =Open to buy (At Retail)
Planned purchases - 11666.67 = 142750
Planned purchases = 154416.67
Planned Sales On Order in $ Employees Discount in $ MD $ Shortages in % EOM in $ BOM Open to Buy For Each month Feb 300000 125000 2 8000 2 200000 160000 30400 Mar 200000 30000 3 12000 4 80000 40000 31250 Apr 300000 150000 4 4000 5 110000 90000 127800 May 200000 100000 0 3000 7 90000 60000 162000 Jun 400000 150000 5 18000 2 210000 150000 377550 Jul 200000 30000 7 25000 3 70000 30000 127500 Avg 266666.6667 97500 3.5 11666.67 3.833333333 126666.7 88333.33 142750Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.