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