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