In Part B, you will calculate your OTB, which is the amount of retail $ you can spend to stock your store. This OTB money will be for the Fall season of 2021, which will encompass Aug, Sep, Oct, Nov, Dec and Jan of 2021. Using the figures provided you will calculate the following for your store. Show this work on an Excel spreadsheet in traditional OTB grid format.

1. Open to buy for each month

2. Average monthly sales

3. Average monthly on order

4. Mark down % for each month

Planned sales + Planned reductions + Planned EOM Stock = Total monthly needs - BOM Stock = Planned purchases - Merchandise on order = Open to buy

Planned Sales - Employee Discount - Merchandise - Shortages - EOM - BOM - Merchandise On Order

August $200,000 2% $50,000 1.5% $320,000 $350,000 $67,000

September $160,000 2% $32,000 1.5% $240,000 $320,000 $57,600

October $120,000 2% $24,000 1.5% $520,000 $240,000 $228,200

November $260,000 3% $65,000 2.5% $600,000 $520,000 $219,300

December $300,000 4% $75,000 2.5% $250,000 $600,000 $ 4,500

January $100,000 3% $20,000 1.5% $300,000 $250,000 $ 84,500

*Your spreadsheet should be set up so that the months run across the top (from left to right) and your descriptions run down.